Table Detail Report

CNT_DCP_INTERP2



Column Section Relationship Section Top of Page


Table-level Detail

Description: CNT DCP INTERP
Definition: CONTENT DCP INTERPRET
Table Type: REFERENCE





Column Detail - CNT_DCP_INTERP2


Column Name Type Null? Definition
AGE_FROM_MINUTES DOUBLE N defines the beginning age range defined for the calculation.
AGE_TO_MINUTES DOUBLE N defines the ending age range defined for the calculation.
CNT_DCP_INTERP2_ID DOUBLE N PRIMARY KEY
CNT_DTA_KEY_ID DOUBLE N Sequence generated ID (Value: 0.0)
DCP_INTERP_ID DOUBLE N Unique identifier for Interp
DCP_INTERP_UID VARCHAR(100) N Unique identifier for Interp
SERVICE_RESOURCE_CD DOUBLE N Code Set: 221 a unique code value that identifies the service resource associated with the equation. a value of zero means all service resources.
SERVICE_RESOURCE_CDUID VARCHAR(100) N Unique identifier for Service Resource Code Value
SEX_CD DOUBLE N Code Set: 57 a unique code value that identifies the sex of the person for which the equation is to be used.
SEX_CDUID VARCHAR(100) N Unique identifier for Sex Code Value
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_DCP_INTERP2


Child Column in CNT_DCP_INTERP2(FK) Parent Table Name Parent Column Name
Parents: CNT_DTA_KEY_ID CNT_DTA_KEY2 CNT_DTA_KEY_ID




Parent Column in CNT_DCP_INTERP2 (PK) Child Table Name Child Column Name
Children: CNT_DCP_INTERP2_ID CNT_DCP_INTERP_COMPONENT CNT_DCP_INTERP_ID
CNT_DCP_INTERP_STATE CNT_DCP_INTERP_ID


CNT_DCP_INTERP_COMPONENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: CNT DCP INTERP COMPONENT
Definition: CONTENCT DCP INTERPRET COMPONENTS
Table Type: REFERENCE





Column Detail - CNT_DCP_INTERP_COMPONENT


Column Name Type Null? Definition
CNT_DCP_INTERP_COMPONENT_ID DOUBLE N Sequence generated ID - PRIMARY KEY
CNT_DCP_INTERP_ID DOUBLE N Sequence generated ID
COMPONENT_ASSAY_UID VARCHAR(100) N Unique identifier for DTA
COMPONENT_SEQUENCE DOUBLE N sequence number of the component.
DCP_INTERP_UID VARCHAR(100) N Unique identifier for Interp
DESCRIPTION VARCHAR(200) N description of component.
FLAGS DOUBLE N flags which identify properties of the component 1 - numeric component
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_DCP_INTERP_COMPONENT


Child Column in CNT_DCP_INTERP_COMPONENT(FK) Parent Table Name Parent Column Name
Parents: CNT_DCP_INTERP_ID CNT_DCP_INTERP2 CNT_DCP_INTERP2_ID


CNT_DCP_INTERP_STATE



Column Section Relationship Section Top of Page


Table-level Detail

Description: CNT DCP INTERP STATE
Definition: CONTENT DCP INTERPRET STATES
Table Type: REFERENCE





Column Detail - CNT_DCP_INTERP_STATE


Column Name Type Null? Definition
AR_UID VARCHAR(100) N CNT identifier for alpha response/nomenclature
CNT_ALPHA_RESPONSE_KEY_ID DOUBLE N FK to CNT_ALPHA_RESPONSE_KEY
CNT_DCP_INTERP_ID DOUBLE N Sequence generated ID - FK From CNT_DCP_INTERP
CNT_DCP_INTERP_STATE_ID DOUBLE N Sequence generated ID - PRIMARY KEY
DCP_INTERP_UID VARCHAR(100) N Unique identifier for Interp
FLAGS DOUBLE N flags which identify properties of the component 1 - numeric component
INPUT_ASSAY_UID VARCHAR(100) N CNT identifier for DTA
INTERP_STATE DOUBLE N identifier of the state
NOMENCLATURE_ID DOUBLE N nomenclature id of input corresponding to transition_assay_cd
NUMERIC_HIGH DOUBLE N numeric high value
NUMERIC_LOW DOUBLE N numeric low value
RESULTING_STATE DOUBLE N next state as a result of current input
RESULT_AR_UID VARCHAR(100) N CNT Identifier for alpha response/nomenclature
RESULT_NOMENCLATURE_ID DOUBLE N Nomenclature id that should be returned as result.
RESULT_VALUE DOUBLE N numeric value that should be returned as a result.
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_DCP_INTERP_STATE


Child Column in CNT_DCP_INTERP_STATE(FK) Parent Table Name Parent Column Name
Parents: CNT_ALPHA_RESPONSE_KEY_ID CNT_ALPHA_RESPONSE_KEY CNT_ALPHA_RESPONSE_KEY_ID
CNT_DCP_INTERP_ID CNT_DCP_INTERP2 CNT_DCP_INTERP2_ID
NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
RESULT_NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID


CNT_DS_KEY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Content Doc Set Key
Definition: Used to build data to be imported into DOC_SET_REF and CODE_VALUE.
Table Type: REFERENCE





Column Detail - CNT_DS_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.
CNT_DS_KEY_ID DOUBLE N Unique, generated number that identifies a single row on the CNT_DS_KEY table.
CNT_DS_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_DESCRIPTION VARCHAR(250) N A description of a documentation set.
DOC_SET_NAME VARCHAR(40) N The name of a documentation set.
DOC_SET_NAME_KEY VARCHAR(40) N The name value of DOC_SET_NAME in all CAPS with no spaces.
DOC_SET_REF_ID DOUBLE Y When the configuration is imported from from .xml/.czf to this table, ithis column will be populated with a null. When Bedrock tool maps this record, it will be updated to the parent row from DOC_SET_REF.
EVENT_CD DOUBLE N Type of Doc Set as defined in the 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 Name of the Event Set that is associated with the Doc Set.
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 in conjunction with UID column.



Relationship Detail - CNT_DS_KEY


Child Column in CNT_DS_KEY(FK) Parent Table Name Parent Column Name
Parents: DOC_SET_REF_ID DOC_SET_REF DOC_SET_REF_ID


CNT_DS_LABEL_ASSAY_KEY



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - CNT_DS_LABEL_ASSAY_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.
ACTIVITY_TYPE_DISP_TXT VARCHAR(255) N Activity type display text of label assay
CNT_DS_LABEL_ASSAY_KEY_ID DOUBLE N Unique generated number that identifies a single row on the CNT_DS_LABEL_ASSAY_KEY table.
CNT_DS_LABEL_ASSAY_KEY_UID VARCHAR(100) N UID(unique identification) number which is used in versioning of label assay in conjunction with version_dt_tm column
DTA_MNEMONIC VARCHAR(50) N Defines the abbreviated form of the discrete task assay long description. Used in most applications to display the discrete assay task.
TASK_ASSAY_REF_CD 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 DISCRETE_TASK_ASSAY.
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 assay in conjunction with UID column



Relationship Detail - CNT_DS_LABEL_ASSAY_KEY


Child Column in CNT_DS_LABEL_ASSAY_KEY(FK) Parent Table Name Parent Column Name
Parents: TASK_ASSAY_REF_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD