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.