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 |