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. |