Table Detail Report

CNT_SECTION_DTA_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: CNT SECTION DTA R
Definition: SECTION DTA RELATION
Table Type: REFERENCE





Column Detail - CNT_SECTION_DTA_R


Column Name Type Null? Definition
CNT_DTA_KEY_ID DOUBLE N Sequence generated ID (Value: 0.0)
CNT_SECTION_DTA_R_ID DOUBLE N Sequence generated ID - PRIMARY KEY
CNT_SECTION_KEY_ID DOUBLE N Sequence generated ID (Value: 0.0)
IGNORE_IND DOUBLE N Indicator for Bedrock Wizard whether to ignore section to DTA relationship
SECTION_UID VARCHAR(100) N Unique identifier for Section
TASK_ASSAY_UID VARCHAR(100) N Unique identifier for DTA
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 - CNT_SECTION_DTA_R


Child Column in CNT_SECTION_DTA_R(FK) Parent Table Name Parent Column Name
Parents: CNT_DTA_KEY_ID CNT_DTA_KEY2 CNT_DTA_KEY_ID
CNT_SECTION_KEY_ID CNT_SECTION_KEY2 CNT_SECTION_KEY2_ID


CNT_SECTION_KEY2



Column Section Relationship Section Top of Page


Table-level Detail

Description: CNT SECTION KEY
Definition: SECTION KEY
Table Type: REFERENCE





Column Detail - CNT_SECTION_KEY2


Column Name Type Null? Definition
CNT_SECTION_KEY2_ID DOUBLE N Sequence generated ID PRIMARY KEY
DCP_SECTION_REF_ID DOUBLE N Unique identifier for each individual form section
SECTION_DEFINITION VARCHAR(200) Y Textual definition of the section
SECTION_DESCRIPTION VARCHAR(200) Y Textual description of the section. This is displayed in the navigator when a form is charted.
SECTION_INTERNAL_UID VARCHAR(100) N Unique identifier for domain generated Section
SECTION_UID VARCHAR(100) N Unique identifier for Section
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.
VERSION_DT_TM DATETIME Y Stored version of the section



Relationship Detail - CNT_SECTION_KEY2




Parent Column in CNT_SECTION_KEY2 (PK) Child Table Name Child Column Name
Children: CNT_SECTION_KEY2_ID CNT_INPUT CNT_SECTION_KEY2_ID
CNT_INPUT_KEY CNT_SECTION_KEY2_ID
CNT_PF_SECTION_R CNT_SECTION_KEY2_ID
CNT_SECTION CNT_SECTION_KEY2_ID
CNT_SECTION_DTA_R CNT_SECTION_KEY_ID


CNT_UID_ALIAS



Column Section Top of Page


Table-level Detail

Description: CNT_UID_ALIAS
Definition: Table to hold UID aliasing
Table Type: REFERENCE





Column Detail - CNT_UID_ALIAS


Column Name Type Null? Definition
CNT_UID VARCHAR(100) N This field contains the UID for the CNT item that is aliased
CNT_UID_ALIAS VARCHAR(100) N This field contains the alias for the given UID and Domain
CNT_UID_ALIAS_ID DOUBLE N This field is a PK sequence value for the table.
CNT_UID_DOMAIN VARCHAR(50) Y This defines the domain for CNT that the alias is for.
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.


CNT_WV_ITEM_DTA



Column Section Top of Page


Table-level Detail

Description: Working view item - display association dta relation table
Definition: Contains details about working view item and display association DTA details, which are used by Bedrock tool. Imported using content manager tool.
Table Type: REFERENCE





Column Detail - CNT_WV_ITEM_DTA


Column Name Type Null? Definition
CNT_WV_ITEM_DTA_ID DOUBLE N PRIMARY KEY
TASK_ASSAY_UID VARCHAR(100) N UID of the DTA which is part of display association. Value comes from field in CNT_DTA_KEY2
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.
WV_ITEM_UID VARCHAR(100) N Working view item UIDWorking view item UID for which DTA's associated as display association.value from CNT_WV_ITEM_KEY table.


CNT_WV_ITEM_KEY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Content Working View Item Key
Definition: Contains details about working view items which are used by Bedrock tool. Imported using content manager tool.
Table Type: REFERENCE





Column Detail - CNT_WV_ITEM_KEY


Column Name Type Null? Definition
CNT_WV_ITEM_KEY_ID DOUBLE N Unique generated number that identifies a single row on the CNT_WV_ITEM_KEY table.
DCP_WV_ITEM_REF_ID DOUBLE Y When the configuration is imported from from .xml/.czf to this table, ithis column will be populated with a null value. When Bedrock tool maps this record, it will be updated to the parent row from WORKING_VIEW_ITEM.
DISP_ASSOC_IND DOUBLE N Working view display association indicator
FALLOFF_VIEW_MINUTES DOUBLE N Specifies when to remove the item if it hasn't been documented on within the working view
INCLUDED_IND DOUBLE N Specifies whether the event set is included on the working view.
PARENT_EVENT_SET_NAME VARCHAR(40) N Specifies the primitive event set parents associated to a working view section.
PRIMITIVE_EVENT_SET_NAME VARCHAR(40) N Specifies the primitive event sets associated to a working view section.
TASK_ASSAY_GUID VARCHAR(100) Y GUID - used to link between item and DTA
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.
VERSION_DT_TM DATETIME N The date of the version for the given data
WV_ITEM_UID VARCHAR(100) N UID(unique identification) number which is used in versioning of working view section in conjunction with version_dt_tm column



Relationship Detail - CNT_WV_ITEM_KEY


Child Column in CNT_WV_ITEM_KEY(FK) Parent Table Name Parent Column Name
Parents: DCP_WV_ITEM_REF_ID WORKING_VIEW_ITEM WORKING_VIEW_ITEM_ID