Table Detail Report
CNT_DS_SECTION_R
Column Section | Top of Page |
Table-level Detail
Description: | Content Doc Set Section Relation |
Definition: | Identifies the relationship between CNT_DS_KEY and CNT_DS_SECTION_KEY. |
Table Type: | REFERENCE |
Column Detail - CNT_DS_SECTION_R
Column Name | Type | Null? | Definition |
---|---|---|---|
CNT_DS_KEY_UID | VARCHAR(100) | N | UID of the doc set, used for relating doc set and section |
CNT_DS_SECTION_KEY_UID | VARCHAR(100) | N | UID of the doc set section, used for relating doc set and section |
CNT_DS_SECTION_R_ID | DOUBLE | N | Unique generated number that identifies a single row on the CNT_DS_SECTION_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_SEC_ELEMENT_KEY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Content Doc Set Section Element Key |
Definition: | Used to build data to be imported into DOC_SET_ELEMENT_REF and DISCRETE_TASK_ASSAY |
Table Type: | REFERENCE |
Column Detail - CNT_DS_SEC_ELEMENT_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_SEC_ELEMENT_KEY_ID | DOUBLE | N | Unique generated number that identifies a single row on the CNT_DS_SEC_ELEMENT_KEY table. |
CNT_DS_SEC_ELEMENT_KEY_UID | VARCHAR(100) | N | UID(unique identification) number which is used in versioning of doc set element in conjunction with version_dt_tm column |
DOC_SET_ELEMENT_DESCRIPTION | VARCHAR(250) | N | A description of a documentation set element. |
DOC_SET_ELEMENT_NAME | VARCHAR(40) | N | The name of a documentation set element. |
DOC_SET_ELEM_SEQUENCE | DOUBLE | N | Identifies the ordering of this element relative to other elements contained within a section. |
DS_ELEMENT_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_ELEMENT_REF. |
ELEMENT_TYPE_CD | DOUBLE | N | Classifies this element by its functionality. Examples include 'NUMERIC' and 'CALCULATION'. |
ELEMENT_TYPE_CD_UID | VARCHAR(100) | N | UID(unique identification) number which is used in versioning of element type in conjunction with version_dt_tm column |
ELEMENT_TYPE_DISPLAY_NAME | VARCHAR(40) | N | Element display name |
ELEMENT_TYPE_MEAN_TXT | VARCHAR(12) | N | Element mean text |
EVENT_CD | DOUBLE | N | Type of Section 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 used for the event code. |
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 |
READ_ONLY_IND | DOUBLE | N | Specifies if data related to this element may be saved. |
REQUIRED_IND | DOUBLE | N | Indicates if this element is required to be populated to ensure the section it is a part of. |
TASK_ASSAY_CD | DOUBLE | N | Defines information that further defines this element. |
TASK_ASSAY_CD_UID | VARCHAR(100) | N | UID(unique identification) number which is used in versioning of task assay in conjunction with version_dt_tm column |
TASK_ASSAY_CKI | VARCHAR(255) | N | Cerner Knowledge Index for task assay |
TASK_ASSAY_DISPLAY_NAME | VARCHAR(40) | N | Display name for the 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 doc set section element in conjunction with UID column. |
Relationship Detail - CNT_DS_SEC_ELEMENT_KEY
Child Column in CNT_DS_SEC_ELEMENT_KEY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DS_ELEMENT_REF_ID | DOC_SET_ELEMENT_REF | DOC_SET_ELEMENT_ID |
CNT_DTA
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CNT DTA |
Definition: | DTA |
Table Type: | REFERENCE |
Column Detail - CNT_DTA
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_CD | DOUBLE | N | A unique code value display that identifies a specific activity type associated with the discrete task assay. |
ACTIVITY_TYPE_CDUID | VARCHAR(100) | N | Unique identifier FK to CNT_CODE_VALUE_KEY |
BB_RESULT_TYPE_CD | DOUBLE | N | A unique code value used to determine result processing during blood bank result entry. |
BB_RESULT_TYPE_CDUID | VARCHAR(100) | N | Unique identifier from the CNT_CODE_VALUE_KEY table |
CERNER_DEFINED_IND | DOUBLE | N | (currently not implemented) |
CNT_DTA_ID | DOUBLE | N | PRIMARY KEY |
CNT_DTA_KEY_ID | DOUBLE | N | FOREIGN KEY VALUE FROM |
CNT_DTA_KEY_TASK_ASSAY_UID | VARCHAR(100) | N | Not used |
CODE_SET | DOUBLE | N | Defines which code set is to be prompted for when the discrete task assay is defined as a result type of 'online' code set. |
CONCEPT_CKI | VARCHAR(255) | N | Concept CKI is the functional Concept Identifier; it is the codified means within Cerner Millennium? to identify key medical concepts to support information processing, clinical decision support, executable knowledge and knowledge presentation. Composed of a source and an identifier. For example, if the concept source is "SNOMED" and the conceptidentifier is "123", then the CKI is "SNOMED!123" |
DEFAULT_RESULT_TYPE_CD | DOUBLE | N | A unique code value display that identifies the default result type for the discrete task assay. |
DEFAULT_RESULT_TYPE_CDUID | VARCHAR(100) | N | Unique identifier from the CNT_CODE_VALUE_KEY table |
DEFAULT_TYPE_FLAG | DOUBLE | N | 0.00 No defaults 1.00 Default form the Reference Range 2.00 Default the last charted value 3.00 Default from the template script |
DELTA_LVL_FLAG | DOUBLE | N | 0.00 No delta checking 1.00 Perform delta checking on current result 2.00 Perform delta checking on current and previous result |
DESCRIPTION | VARCHAR(100) | N | Stores the long description for the discrete task assay. |
DTA_CKI | VARCHAR(50) | N | Cerner Knowledge Index for the code value |
DTA_INTERNAL_UID | VARCHAR(100) | N | Unique identifier for client created DTA |
EVENT_CD | DOUBLE | N | Cerner Knowledge Index for the code value. |
EVENT_CODE_CDUID | VARCHAR(100) | N | Unique identifier from the CNT_CODE_VALUE_KEY table |
HISTORY_ACTIVITY_TYPE_CD | DOUBLE | N | CODE SET 233 |
HISTORY_ACTIVITY_TYPE_CDUID | VARCHAR(100) | N | Unique identifier from the CNT_CODE_VALUE_KEY table |
ICD_CODE_IND | DOUBLE | N | indicates whether icd9 billing codes are associated with the discrete task assay. |
INTERP_DATA_IND | DOUBLE | N | indicates whether interpretive data is associated with the discrete task assay. |
IO_FLAG | DOUBLE | N | 0.00 Undetermined 1.00 Input 2.00 Output |
LABEL_TEMPLATE_ID | DOUBLE | N | ID of the dynamic label template which is updated from doc set import script(Request#4170080) |
MNEMONIC | VARCHAR(50) | Y | Defines the abbreviated form of the discrete task assay long description. Used in most applications to display the discrete assay task. |
MNEMONIC_KEY_CAP | VARCHAR(50) | Y | defines the discrete task assay mnemonic in uppercase. used for performing indexed searches on the table. |
MODIFIER_IND | DOUBLE | N | a normalized value which tells that a modifier that can be documented (extended description of the result) exists for the result. |
PRINT_REF_RANGES_ON_REPT_IND | DOUBLE | N | (currently not implemented) |
PRINT_RESULTS | DOUBLE | Y | (currently not implemented) |
RAD_SECTION_TYPE_CD | DOUBLE | N | Classifies the type of report section to which the procedure belongs. |
RAD_SECTION_TYPE_CDUID | DOUBLE | N | ** OBSOLETE ** - REPLACED BY RAD_SECT_TYPE_CDUID *** Unique identifier from the CNT_CODE_VALUE_KEY table |
RAD_SECT_TYPE_CDUID | VARCHAR(100) | N | Unique identifier from the CNT_CODE_VALUE_KEY table |
REF_RANGE_SCRIPT | VARCHAR(50) | Y | defines an alternate site-specific script used to determine reference ranges for the discrete task assay. (currently not implemented) |
REL_ASSAY_IND | DOUBLE | N | indicates whether or not the discrete task assay has associated related discrete task assays defined. |
RENDERING_PROVIDER_IND | DOUBLE | N | (currently not implemented) |
SCI_NOTATION_IND | DOUBLE | N | this field indicates whether the task assay allows numeric values in scientific notation. if set, any value that exceeds the maximum digits and decimal places data map settings will be formatted in scientific notation. (e.g. maxdigits = 5, decimalplaces = 2, value = 1000.00 then formattedvalue = 1.00e3). otherwise, the value will be formatted using |
SIGNATURE_LINE_IND | DOUBLE | N | indicates whether the discrete task assay should have an associated signature line. |
SINGLE_SELECT_IND | DOUBLE | N | indicator for first alpha single select. for multi select dta, this indicator is used to make the first entry single select. |
STRT_ASSAY_ID | DOUBLE | N | used to map to the strt_assay table for mdi database building. |
TASK_ASSAY_UID | VARCHAR(100) | N | Unique identifier for DTA |
TASK_REPT_IND | DOUBLE | N | (currently not implemented) |
TRANSMIT_IND | DOUBLE | N | (currently not implemented) |
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_NUMBER | DOUBLE | Y | this tells the how many times a user has update the discrete_task_assay table. this table is not version-able and doesn't need to be versioned but we can store the versions in an archive so that we can compare what existed when it was documented. |
Relationship Detail - CNT_DTA
Child Column in CNT_DTA(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CNT_DTA_KEY_ID | CNT_DTA_KEY2 | CNT_DTA_KEY_ID |
Parent Column in CNT_DTA (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CNT_DTA_ID | CNT_DTA_RRF_R | CNT_DTA_ID |
CNT_DTA_KEY2
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CNT DTA KEY |
Definition: | DTA KEY |
Table Type: | REFERENCE |
Column Detail - CNT_DTA_KEY2
Column Name | Type | Null? | Definition |
---|---|---|---|
CNT_DTA_KEY_ID | DOUBLE | N | Sequence generated ID - primary key |
TASK_ASSAY_CD | DOUBLE | N | a unique code value that identifies a specific discrete task assay. |
TASK_ASSAY_DISP | VARCHAR(50) | Y | Defines the abbreviated form of the discrete task assay long description. Used in most applications to display the discrete assay task. |
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. |
VERSION_DT_TM | DATETIME | Y | Date the DTA we extracted from source. |
Relationship Detail - CNT_DTA_KEY2
Parent Column in CNT_DTA_KEY2 (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CNT_DTA_KEY_ID | CNT_DATA_MAP | CNT_DTA_KEY_ID |
CNT_DCP_INTERP2 | CNT_DTA_KEY_ID | ||
CNT_DTA | CNT_DTA_KEY_ID | ||
CNT_EQUATION | CNT_DTA_KEY_ID | ||
CNT_GRID | CNT_DTA_KEY_ID | ||
CNT_REF_TEXT | CNT_DTA_KEY_ID | ||
CNT_SECTION_DTA_R | CNT_DTA_KEY_ID |
CNT_DTA_OFFSET_MIN
Column Section | Top of Page |
Table-level Detail
Description: | CNT_DTA_OFFSET_MIN |
Definition: | Stores the types of offset minutes and the number of minutes that need to be considered for a DTA |
Table Type: | REFERENCE |
Column Detail - CNT_DTA_OFFSET_MIN
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. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
CNT_DTA_OFFSET_MIN_ID | DOUBLE | N | PRIMARY KEY |
END_EFFECTIVE_DT_TM | DATETIME | N | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
OFFSET_MIN_NBR | DOUBLE | Y | look back/forward minutes based on the type to tell how far back/forward to look |
OFFSET_MIN_TYPE_CD | DOUBLE | N | the type of minutes that need to be looked at. |
OFFSET_MIN_TYPE_CDUID | VARCHAR(100) | Y | unique identifier fk to cnt_code_value_key |
TASK_ASSAY_UID | VARCHAR(100) | Y | Relates this record to a specific row in the cnt_dta 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. |