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