Table Detail Report

CNT_DS_LABEL_ASSAY_R



Column Section Top of Page


Table-level Detail

Description: Content Doc Set Label Assay Relation
Definition: Identifies the relationship between CNT_DS_LABEL_KEY and CNT_DS_LABEL_ASSAY_KEY.
Table Type: REFERENCE





Column Detail - CNT_DS_LABEL_ASSAY_R


Column Name Type Null? Definition
CNT_DS_LABEL_ASSAY_KEY_UID VARCHAR(100) N UID of the label assay key, used for relating doc set label and assay.
CNT_DS_LABEL_ASSAY_R_ID DOUBLE N Unique generated number that identifies a single row on the CNT_DS_LABEL_ASSAY_R table.
CNT_DS_LABEL_KEY_UID VARCHAR(100) N UID of the doc set label, used for relating doc set and label
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_DS_LABEL_KEY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Content Doc Set Label Key
Definition: Used to build data to be imported into DYNAMIC_LABEL_TEMPLATE.
Table Type: REFERENCE





Column Detail - CNT_DS_LABEL_KEY


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
CNT_DS_LABEL_KEY_ID DOUBLE N Unique generated number that identifies a single row on the CNT_DS_LABEL_KEY table.
CNT_DS_LABEL_KEY_UID VARCHAR(100) N UID(unique identification) number which is used in versioning of label in conjunction with version_dt_tm column
ENCOUNTER_SPECIFIC_IND DOUBLE N This field indicates if a label created from this template is intended to be active only during a single encounter or if it spans multiple encounters
LABEL_TEMPLATE_ID DOUBLE N ID of the dynamic label template which is part of the doc set
LABEL_TEMPLATE_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 DYNAMIC_LABEL_TEMPLATE.
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 Date and time when this record was updated, used in versioning of the label in conjunction with UID column



Relationship Detail - CNT_DS_LABEL_KEY


Child Column in CNT_DS_LABEL_KEY(FK) Parent Table Name Parent Column Name
Parents: LABEL_TEMPLATE_REF_ID DYNAMIC_LABEL_TEMPLATE LABEL_TEMPLATE_ID


CNT_DS_LABEL_R



Column Section Top of Page


Table-level Detail

Description: Content Doc Set Label Assay Relation
Definition: Identifies the relationship between CNT_DS_SEC_ELEMENT and CNT_DS_SECTION_KEY.
Table Type: REFERENCE





Column Detail - CNT_DS_LABEL_R


Column Name Type Null? Definition
CNT_DS_KEY_UID VARCHAR(100) N UID of the doc set, used for relating doc set and label
CNT_DS_LABEL_KEY_UID VARCHAR(100) N UID of the doc set label, used for relating doc set and label
CNT_DS_LABEL_R_ID DOUBLE N Unique generated number that identifies a single row on the CNT_DS_LABEL_R table.
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_DS_SECTION_ELEMENT_R



Column Section Top of Page


Table-level Detail

Description: Content Doc Set Section Element Relation
Definition: Identifies the relationship between CNT_DS_SECTION_KEY and CNT_DS_SEC_ELEMENT_KEY.
Table Type: REFERENCE





Column Detail - CNT_DS_SECTION_ELEMENT_R


Column Name Type Null? Definition
CNT_DS_SECTION_ELEMENT_R_ID DOUBLE N Unique generated number that identifies a single row on the CNT_DS_SECTION_ELEMENT_R table.
CNT_DS_SECTION_KEY_UID VARCHAR(100) N UID of the doc set section, used for relating doc set and section
CNT_DS_SEC_ELEMENT_KEY_UID VARCHAR(100) N UID of the doc set element, used for relating doc set section and element
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_DS_SECTION_KEY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Content Doc Set Section Key
Definition: Used to build data to be imported into DOC_SET_SECTION_REF
Table Type: REFERENCE





Column Detail - CNT_DS_SECTION_KEY


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ALLOW_COMMENT_IND DOUBLE N Determines if comments may be written against the documentation set section.
CNT_DS_SECTION_KEY_ID DOUBLE N Unique generated number that identifies a single row on the CNT_DS_SECTION_KEY table.
CNT_DS_SECTION_KEY_UID VARCHAR(100) N UID(unique identification) number which is used in versioning of doc set in conjunction with version_dt_tm column
DOC_SET_SECTION_DESCRIPTION VARCHAR(250) N A description of a documentation set section.
DOC_SET_SECTION_INSTRUCTION VARCHAR(2000) N This is instructional content used to assist with entering data related to the elements contained within the section.
DOC_SET_SECTION_NAME VARCHAR(40) N Name of the doc set
DOC_SET_SECTION_NAME_KEY VARCHAR(40) N The name value of DOC_SET_SECTION_NAME in all CAPS with no spaces.
DOC_SET_SECTION_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 DOC_SET_SECTION_REF.
EVENT_CD DOUBLE N Type of doc set section as defined in event code model
EVENT_CD_CKI VARCHAR(255) N Cerner Knowledge Index for Event code
EVENT_CD_CONCEPT_CKI VARCHAR(255) N Cerner Knowledge Index for Event code concept
EVENT_CD_DISPLAY_NAME VARCHAR(40) N The display name from CODE_VALUE for the EVENT_CD.
EVENT_CD_UID VARCHAR(100) N UID(unique identification) number which is used in versioning of event cd in conjunction with version_dt_tm column
EVENT_SET_NAME VARCHAR(100) N The Event Set Name
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 Date and time when this record was updated, used in versioning of the doc set section in conjunction with UID column.



Relationship Detail - CNT_DS_SECTION_KEY


Child Column in CNT_DS_SECTION_KEY(FK) Parent Table Name Parent Column Name
Parents: DOC_SET_SECTION_REF_ID DOC_SET_SECTION_REF DOC_SET_SECTION_REF_ID