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 |