CNT_ADVANCED_DELTA



Column Section Top of Page


Table-level Detail

Description: CNT ADVANCED DELTA (Advanced Delta Checking)
Definition: Stores parameters used for advanced delta checking for General Lab applications.
Table Type: REFERENCE





Column Detail - CNT_ADVANCED_DELTA


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME Y 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_ADVANCED_DELTA_ID DOUBLE N PRIMARY KEY
DELTA_CHECK_TYPE_CD DOUBLE N a unique code value that identifies the specific type of delta checking (such as absolute, percent, and so on).
DELTA_CHECK_TYPE_CDUID VARCHAR(100) Y Unique Identifier FK to CNT_CODE_VALUE_KEY
DELTA_FLAG DOUBLE Y stores the indicator that is used to determine whether a delta checking range has been entered. valid values are 0 - no range, 1 - low value only, 2 - high value only, 3 - both low and high values.
DELTA_HIGH DOUBLE Y stores the value for the high end of the range for delta checking.
DELTA_LOW DOUBLE Y used to store the value for the low range to be used for delta checking.
DELTA_MINUTES DOUBLE Y defines the number of minutes used to evaluate the delta check rule.
DELTA_VALUE DOUBLE Y defines the value used to evaluate delta checking.
END_EFFECTIVE_DT_TM DATETIME Y 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.
RRF_UID VARCHAR(100) Y relates this record to a specific row in the cnt_rrf 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_ALPHA_RESPONSE



Column Section Relationship Section Top of Page


Table-level Detail

Description: CNT ALPHA RESPONSE
Definition: Used to store codified alpha responses for discrete task assays that are result type of alpha.
Table Type: REFERENCE





Column Detail - CNT_ALPHA_RESPONSE


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.
AR_INTERNAL_UID VARCHAR(100) N Unique identifier for INTERNALAlpha Response
AR_UID VARCHAR(100) N Unique identifier for Alpha Response
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.
CMTI VARCHAR(100) N The unique term identifier - from Nomenclature CMTI
CNT_ALPHA_RESPONSE_ID DOUBLE N PRIMARY KEY
CNT_ALPHA_RESPONSE_KEY_ID DOUBLE N FOREIGN KEY FROM CNT_ALPHA_RESPONSE_KEY
CONCEPT_CKI VARCHAR(255) N The Concept CKI associated to the term
CONCEPT_IDENTIFIER VARCHAR(242) N a unique identifier supplied from Cerner or other external database and is persistent once it is assigned to a concept. all Cerner assigned concept identifiers are created from the concept_seq. the sequence number is formatted to an 8-byte number padded
CONCEPT_SOURCE_CD DOUBLE N represents the external source that owns the concept_identifier.
CONCEPT_SOURCE_CDUID VARCHAR(100) Y unique identifier fk to cnt_code_value_key
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
CONTRIBUTOR_SYSTEM_CDUID VARCHAR(100) N Unique identifier UID from CNT_CODE_VALUE_KEY
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_STATUS_CDUID VARCHAR(100) Y unique identifier fk to cnt_code_value_key
END_EFFECTIVE_DT_TM DATETIME Y 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.
LANGUAGE_CD DOUBLE N the language that the string is expressed.
LANGUAGE_CDUID VARCHAR(100) Y unique identifier fk to cnt_code_value_key
MNEMONIC VARCHAR(25) Y A terse description of the source string.
PRIMARY_CTERM_IND DOUBLE N This indicator identifies which string is the official client term for a source identifier within a source vocabulary.
PRIMARY_VTERM_IND DOUBLE N This indicator identifies which string is the official term for a source identifier within a source vocabulary.
SHORT_STRING VARCHAR(60) Y Variable length string that may include alphanumeric characters and punctuation.
STRING_IDENTIFIER VARCHAR(18) N a unique identifier supplied from Cerner or other external database and is persistent once it is assigned to a string.
STRING_SOURCE_CD DOUBLE N represents the external source that owns the string_identifier.
STRING_SOURCE_CDUID VARCHAR(100) Y unique identifier fk to cnt_code_value_key
STRING_STATUS_CD DOUBLE N an indication of whether the string is the preferred form of a term or a variant of that form, e.g. by case, plurality, word order.
STRING_STATUS_CDUID VARCHAR(100) Y unique identifier fk to cnt_code_value_key
TERM_SOURCE_CD DOUBLE N represents the external source that owns the term_identifier.
TERM_SOURCE_CDUID VARCHAR(100) Y unique identifier fk to cnt_code_value_key
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.
VOCAB_AXIS_CD DOUBLE N The vocabulary axis for the given code - code set 15849
VOCAB_AXIS_CDUID VARCHAR(100) N Unique identifier FK to CNT_CODE_VALUE_KEY



Relationship Detail - CNT_ALPHA_RESPONSE


Child Column in CNT_ALPHA_RESPONSE(FK) Parent Table Name Parent Column Name
Parents: CNT_ALPHA_RESPONSE_KEY_ID CNT_ALPHA_RESPONSE_KEY CNT_ALPHA_RESPONSE_KEY_ID


CNT_ALPHA_RESPONSE_KEY



Column Section Relationship Section Top of Page


Table-level Detail

Description: CNT ALPHA RESPONSE KEY
Definition: ALPHA RESPONSE KEY
Table Type: REFERENCE





Column Detail - CNT_ALPHA_RESPONSE_KEY


Column Name Type Null? Definition
AR_UID VARCHAR(100) N Unique identifier for Alpha Response
CNT_ALPHA_RESPONSE_KEY_ID DOUBLE N PRIMERY KEY
NOMENCLATURE_ID DOUBLE N NOMENCLATURE ID - VALUE FROM NOMENCLATURE
PRINCIPLE_TYPE_CD DOUBLE N A general category used to group strings. (for alpha responses will be ALPHA_RESPON).
PRINCIPLE_TYPE_CDUID VARCHAR(100) N Unique identifier FK to CNT_CODE_VALUE_KEY
SOURCE_IDENTIFIER VARCHAR(50) Y The code, or key, from the source vocabulary that contributed that string to the nomenclature (e.g. ICD9). For alpha responses, this will be blank.
SOURCE_STRING VARCHAR(255) Y Variable length string that may include alphanumeric characters and punctuation.
SOURCE_VOCABULARY_CD DOUBLE N The source vocabulary for the entry.
SOURCE_VOCABULARY_CDUID VARCHAR(100) N Unique identifier FK to CNT_CODE_VALUE_KEY
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_ALPHA_RESPONSE_KEY




Parent Column in CNT_ALPHA_RESPONSE_KEY (PK) Child Table Name Child Column Name
Children: CNT_ALPHA_RESPONSE_KEY_ID CNT_ALPHA_RESPONSE CNT_ALPHA_RESPONSE_KEY_ID
CNT_DCP_INTERP_STATE CNT_ALPHA_RESPONSE_KEY_ID
CNT_RRF_AR_R CNT_ALPHA_RESPONSE_KEY_ID


CNT_ALPHA_RESP_CATEGORY



Column Section Top of Page


Table-level Detail

Description: CNT_ALPHA_RESPONSE_CATEGORY
Definition: Allows categorization of Alpha Responses.
Table Type: REFERENCE





Column Detail - CNT_ALPHA_RESP_CATEGORY


Column Name Type Null? Definition
CATEGORY_NAME VARCHAR(100) Y The identifier and display value for the category
CNT_ALPHA_RESP_CATEGORY_ID DOUBLE N PRIMARY KEY
DISPLAY_SEQ DOUBLE Y Identifies the order the categories will be displayed
EXPAND_FLAG DOUBLE Y Indicates whether the category is expanded or contracted to show the associated alpha responses.0
RRF_UID VARCHAR(100) Y Relates this record to a specific row in the cnt_rrf 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_CODE_VALUE_KEY



Column Section Relationship Section Top of Page


Table-level Detail

Description: CNT CODE VALUE KEY
Definition: CODE VALUE KEY
Table Type: REFERENCE





Column Detail - CNT_CODE_VALUE_KEY


Column Name Type Null? Definition
CDF_MEANING VARCHAR(12) Y The actual string value for the cdf meaning.
CKI VARCHAR(255) N Cerner Knowledge Index for the Code Value
CNT_CODE_VALUE_KEY_ID DOUBLE N PRIMARY KEY
CODE_SET DOUBLE N The code_set for the code_value_uid
CODE_VALUE DOUBLE N The mapped code_value for the code_value_uid
CODE_VALUE_UID VARCHAR(100) N Unique identifier for Code Value
CODE_VALUE_UID_ALIAS VARCHAR(100) Y ALIAS NAME FOR CODE VALUE UID
CONCEPT_CKI VARCHAR(255) N Concept CKI is the functional Concept Identifier; it is the codified means within 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 concept identifier is "123", then the CKI is "SNOMED!123".
DEFINITION VARCHAR(100) Y the definition for the code value
DESCRIPTION VARCHAR(100) N The description for the code value
DISPLAY VARCHAR(40) Y The display string for the code_value
EVENT_SET_NAME VARCHAR(100) Y the event set name
IGNORE_IND DOUBLE N field to indicate if the user has chosen NOT to match a code value from content to a code value in the domain
IGNORE_USER_ID DOUBLE N the user who decided and chose to ignore matching a content code value with domain code value
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - CNT_CODE_VALUE_KEY


Child Column in CNT_CODE_VALUE_KEY(FK) Parent Table Name Parent Column Name
Parents: IGNORE_USER_ID PRSNL PERSON_ID