DD_SDOC_ATTRIBUTE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Dynamic Documentation - Structured Documentation Attribute |
Definition: | This table contains the documented Attributes under an Item in a documented section. An Attribute is one of the questions to be asked inside an Item. An entry on this table indicates that the question was answered, while the value of the answer is on DD_SDOC_ATTR_MENU_ITEM. |
Table Type: | ACTIVITY |
Column Detail - DD_SDOC_ATTRIBUTE
Column Name | Type | Null? | Definition |
---|---|---|---|
DD_SDOC_ATTRIBUTE_ID | DOUBLE | N | Uniquely identifies an attribute under an Item in a documented section. An Attribute is one of the questions to be asked inside an Item. An entry on this table indicates that the question was answered, while the value of the answer is on DD_SDOC_ATTRIBUTEMENUITEM. |
DD_SDOC_SECTION_ID | DOUBLE | N | Uniquely identifies the documented section which contains this documented attribute. |
OCID_IDENT | VARCHAR(255) | N | The reference identifier for this Attribute. Useful for finding all documented copies of a given conceptual Attribute. |
PARENT_DD_SDOC_ITEM_ID | DOUBLE | N | The identifier of the parent item |
TRUTH_STATE_CD | DOUBLE | N | The truth state of this Attribute - options defined on codeset 15751. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - DD_SDOC_ATTRIBUTE
Child Column in DD_SDOC_ATTRIBUTE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PARENT_DD_SDOC_ITEM_ID | DD_SDOC_ITEM | DD_SDOC_ITEM_ID |
Parent Column in DD_SDOC_ATTRIBUTE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | DD_SDOC_ATTRIBUTE_ID | DD_SDOC_ATTR_MENU_ITEM | PARENT_DD_SDOC_ATTRIBUTE_ID |
DD_SDOC_ATTR_MENU_ITEM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Dynamic Documentation Structured Document Attribute Menu Item |
Definition: | This table contains the documented AttributeMenuItems under an Attribute in a documented section. |
Table Type: | ACTIVITY |
Column Detail - DD_SDOC_ATTR_MENU_ITEM
Column Name | Type | Null? | Definition |
---|---|---|---|
COMMENT_BLOB_ID | DOUBLE | N | Uniquely identifies the entry on the Long_Blob table that holds a comment about this documented Attribute Menu Item. |
DD_SDOC_ATTR_MENU_ITEM_ID | DOUBLE | N | Uniquely identifies an attribute menu item under an Attribute in a documented section. Attribute Menu Items can be considered the answers to the questions posed in Attributes. |
DD_SDOC_SECTION_ID | DOUBLE | N | Uniquely identifies a documented section which contains this documented Attribute Menu Item. |
DISPLAY_SEQ | DOUBLE | N | The position relative to sibling Attribute Menu Items |
OCID_IDENT | VARCHAR(255) | N | The reference identifier for this Attribute Menu Item. Useful for finding all documented copies of a given conceptual Attribute Menu Item. |
PARENT_DD_SDOC_ATTRIBUTE_ID | DOUBLE | N | Uniquely identifies the related attribute. |
RENDERED_TEXT_BLOB_ID | DOUBLE | N | Uniquely identifies the entry on the LONG_BLOB table that holds the full rendered text for this Attribute Menu Item. |
TRUTH_STATE_CD | DOUBLE | N | Truth state of this Attribute Menu Item - options defined on codeset 15751. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - DD_SDOC_ATTR_MENU_ITEM
Child Column in DD_SDOC_ATTR_MENU_ITEM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PARENT_DD_SDOC_ATTRIBUTE_ID | DD_SDOC_ATTRIBUTE | DD_SDOC_ATTRIBUTE_ID |
DD_SDOC_SECTION_ID | DD_SDOC_SECTION | DD_SDOC_SECTION_ID | |
COMMENT_BLOB_ID | LONG_BLOB | LONG_BLOB_ID | |
RENDERED_TEXT_BLOB_ID | LONG_BLOB | LONG_BLOB_ID |
DD_SDOC_DATA
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Dynamic Documentation Structured Documentation Data |
Definition: | This table contains a generic data structure used to store various information in Structured Documentation. |
Table Type: | ACTIVITY |
Column Detail - DD_SDOC_DATA
Column Name | Type | Null? | Definition |
---|---|---|---|
DATA_TYPE_CD | DOUBLE | N | Type/Format/Use of the data in this row |
DD_SDOC_DATA_ID | DOUBLE | N | Uniquely identifies a generic data structure used to store various information in Structured Documentation. |
DD_SDOC_SECTION_ID | DOUBLE | N | Uniquely identifies the related section. |
FKEY_ENTITY_ID | DOUBLE | N | Key to a foreign table (table identified by fkey_entity_name) which holds the expanded data for this row. |
FKEY_ENTITY_NAME | VARCHAR(40) | Y | Entity (table name) for link to another entity. LONG_BLOB for example. |
PARENT_ENTITY_ID | DOUBLE | N | Key to a parent table (table identified by parent_entity_name) |
PARENT_ENTITY_NAME | VARCHAR(40) | N | Entity (table name) for link to a parent Entity. DD_SDOC_ATTRI_MENU_ITEM for example. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
VALUE_NBR | DOUBLE | N | Number value of documentation. |
VALUE_UNIT_CD | DOUBLE | N | Unit of measure associated with the data stored in this row. Options on codeset 54. |
Relationship Detail - DD_SDOC_DATA
Child Column in DD_SDOC_DATA(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DD_SDOC_SECTION_ID | DD_SDOC_SECTION | DD_SDOC_SECTION_ID |
DD_SDOC_GROUPBY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Dynamic Documentation Structured Documentation Group By |
Definition: | This table contains the documented GroupBy and SGroupBy elements in a structured section. |
Table Type: | ACTIVITY |
Column Detail - DD_SDOC_GROUPBY
Column Name | Type | Null? | Definition |
---|---|---|---|
DD_SDOC_GROUPBY_ID | DOUBLE | N | Uniquely identifies a documented GroupBy or SGroupBy element in a structured section. |
DD_SDOC_SECTION_ID | DOUBLE | N | Uniquely identifies the related section. |
GROUP_LABEL | VARCHAR(3000) | N | The label of this Group (typically displayed at the top of the Group). |
PARENT_DD_SDOC_GROUPBY_ID | DOUBLE | N | The id of the parent Group. This will be equal to the DD_SDOC_GROUPBY_ID when this is a top-level group. For a subgroup, it will be equal to the parent group's DD_SDOC_GROUPBY_ID id. |
TRUTH_STATE_CD | DOUBLE | N | Truth state of this Group - options defined on codeset 15751. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - DD_SDOC_GROUPBY
Child Column in DD_SDOC_GROUPBY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PARENT_DD_SDOC_GROUPBY_ID | DD_SDOC_GROUPBY | DD_SDOC_GROUPBY_ID |
DD_SDOC_SECTION_ID | DD_SDOC_SECTION | DD_SDOC_SECTION_ID |
Parent Column in DD_SDOC_GROUPBY (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | DD_SDOC_GROUPBY_ID | DD_SDOC_GROUPBY | PARENT_DD_SDOC_GROUPBY_ID |
DD_SDOC_ITEM | PARENT_DD_SDOC_GROUPBY_ID |
DD_SDOC_ITEM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Dynamic Documentation Structured Documentation Item |
Definition: | This table contains the documented Items under a Group/Subgroup in a documented section. Items can be considered a collection of questions, which result in a nicely formatted, self-contained output when answered. |
Table Type: | ACTIVITY |
Column Detail - DD_SDOC_ITEM
Column Name | Type | Null? | Definition |
---|---|---|---|
DD_SDOC_ITEM_ID | DOUBLE | N | Uniquely identifies an item under a group/subgroup in a documented section. Items can be considered a collection of questions, which result in a nicely formatted, self-contained output when answered. |
DD_SDOC_SECTION_ID | DOUBLE | N | Uniquely identifies the related section. |
OCID_IDENT | VARCHAR(255) | N | The reference identifier for this Item. Useful for finding all documented copies of a given conceptual Item. |
PARENT_DD_SDOC_GROUPBY_ID | DOUBLE | N | The id of the parent Group/Subgroup. |
TRUTH_STATE_CD | DOUBLE | N | Truth state of this item - options defined on codeset 15751. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - DD_SDOC_ITEM
Child Column in DD_SDOC_ITEM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PARENT_DD_SDOC_GROUPBY_ID | DD_SDOC_GROUPBY | DD_SDOC_GROUPBY_ID |
DD_SDOC_SECTION_ID | DD_SDOC_SECTION | DD_SDOC_SECTION_ID |
Parent Column in DD_SDOC_ITEM (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | DD_SDOC_ITEM_ID | DD_SDOC_ATTRIBUTE | PARENT_DD_SDOC_ITEM_ID |