Table Detail Report

CMT_WORDKEY_EXCLUDE_LOAD



Column Section Top of Page


Table-level Detail

Description: CMT WORDKEY EXCLUDE LOAD
Definition: LOAD TABLE FOR CMT_WORDKEY_EXCLUDE
Table Type: REFERENCE





Column Detail - CMT_WORDKEY_EXCLUDE_LOAD


Column Name Type Null? Definition
KEYWORD_NAME VARCHAR(8) N A word used in source_strings in the nomenclature table but excluded from keyword generation. Words are represented using only upper case letters and words of more than eight characters are represented as their first eight characters only.
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.


CMT_WORDKEY_INDEX



Column Section Top of Page


Table-level Detail

Description: CMT WORDKEY INDEX
Definition: Each row in this table is a word followed by a reference to a source_string in which this word appears. A keyword may relate to multiple source_strings. If there is a duplicate row where the keyword and source_identifier appear multiple times, the duplicates are omitted. Only one row is present for each combination of a keyword with a particular source_string, even if that keyword appears several times in the referenced source_string.
Table Type: REFERENCE





Column Detail - CMT_WORDKEY_INDEX


Column Name Type Null? Definition
CMTI_IDENT VARCHAR(50) N CMTI IDENTIFIER
CMT_WORDKEY_INDEX_ID DOUBLE N PRIMARY KEY
KEYWORD_NAME VARCHAR(8) N Keywords are represented using only upper case letters and words of more than eight characters are represented as their first eight characters only. Permitted characters include 0 to 9, A to Z and dash "-".
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.


CMT_WORDKEY_INDEX_LOAD



Column Section Top of Page


Table-level Detail

Description: CMT_WORDKEY_iNDEX LOAD
Definition: LOAD TABLE FOR CMT_WORDKEY_INDEX
Table Type: REFERENCE





Column Detail - CMT_WORDKEY_INDEX_LOAD


Column Name Type Null? Definition
CMTI_IDENT VARCHAR(50) N Indicates the unique identifier for a term which the word exists.
KEYWORD_NAME VARCHAR(8) N Keywords are represented using only upper case letters and words of more than eight characters are represented as their first eight characters only. Permitted characters include 0 to 9, A to Z and dash "-".
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.


CMT_XMAP_CNTNT_VER



Column Section Top of Page


Table-level Detail

Description: CMT crossmap content version
Definition: Contains version information for cmt_cross_map content releases
Table Type: ACTIVITY





Column Detail - CMT_XMAP_CNTNT_VER


Column Name Type Null? Definition
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.
CMT_XMAP_CNTNT_VER_ID DOUBLE N cmt crossmap content version identifierColumn
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.
MAP_FROM_VERSION_FT VARCHAR(20) Y Version of source vocablary mean free text field
MAP_FROM_VERSION_NBR DOUBLE N Version of vocabulary mean for the cross-map source
MAP_FROM_VOCAB_CD DOUBLE N Source_vocabulary_cd for the cross-map target
MAP_TO_VERSION_FT VARCHAR(20) Y Version of source vocabulary mean free text field
MAP_TO_VERSION_NBR DOUBLE N map to version numberColumn
MAP_TO_VOCAB_CD DOUBLE N Source_vocabulary_cd for the cross-map target
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.


CONCEPT



Column Section Top of Page


Table-level Detail

Description: Concept
Definition: The Concept table contains one row for each unique meaning or idea. A concept code has no intrinsic meaning. Its purpose is to link alternative names and views of the same concept together and to identify useful relationships between different concepts.
Table Type: REFERENCE





Column Detail - CONCEPT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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 Y 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 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.
CKI VARCHAR(255) N The CKID is composed of a source and an identifier. If the source cannot uniquely define an identifier, then the source will include a domain. These elements will always determine uniqueness whether created at Cerner, a third party content developer, or on a client site. Wherever possible we will use industry standard vocabularies to create this unique external identifier.
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_NAME VARCHAR(255) Y The name of the concept, or idea, generally defaulted as the preferred string of the preferred term.
CONCEPT_SOURCE_CD DOUBLE N Represents the external source that owns the concept_identifier.
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_DT_TM DATETIME Y The date and time that the data_status_cd was set.
DATA_STATUS_PRSNL_ID DOUBLE N The person who caused the data_status_cd to be set or change.
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.
REVIEW_STATUS_CD DOUBLE N The review status of the concept.
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.