Table Detail Report
CMT_CONCEPT_RELTN_LD_NS
Column Section | Top of Page |
Table-level Detail
Description: | CMT_CONCEPT_RELTN_LD_NS |
Definition: | CMT Concept Reltn Load (Non-SNOMED) |
Table Type: | REFERENCE |
Column Detail - CMT_CONCEPT_RELTN_LD_NS
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 | 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 | 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. |
CHARACTERISTIC_TYPE_FLAG | DOUBLE | Y | an indication of whether a relationship specifies a defining characteristic of the source concept or a possible qualification of that concept. 0 - defining 1- qualifier 2- additional |
CONCEPT_CKI1 | VARCHAR(255) | N | the cki of the concept, which is the source of this relationship. usually, it is the child concept in parent-child relationship. |
CONCEPT_CKI2 | VARCHAR(255) | N | the cki of the concept, which is the target of this relationship. usually, it is the parent concept in parent-child relationship. |
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. |
REFINABILITY_FLAG | DOUBLE | Y | an indication of whether it is possible to refine the target concept when this relationship is used as a template for clinical data entry. 0 - not refinable. 1- optional. 2 - mandatory |
RELATION_CKI | VARCHAR(255) | N | the cki of the concept, which represents the type of relationship between concept_cki1 and concept_cki2. |
RELTN_GROUP | DOUBLE | Y | An integer value that links together Relationships which are part of a logically associated Relationship group. |
RELTN_IDENTIFIER | VARCHAR(60) | N | The unique SNOMED CT Identifier of this Relationship. |
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_CONCEPT_RELTN_LOAD
Column Section | Top of Page |
Table-level Detail
Description: | CMT Concept Relation Load Table |
Definition: | This is a copy of CMT_CONCEPT_RELTN and is used for the load process only. |
Table Type: | REFERENCE |
Column Detail - CMT_CONCEPT_RELTN_LOAD
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. |
CHARACTERISTIC_TYPE_FLAG | DOUBLE | Y | Characteristic Type Flag. Values are: |
CONCEPT_CKI1 | VARCHAR(255) | N | Concept CKI column 1 |
CONCEPT_CKI2 | VARCHAR(255) | N | Concept CKI column 2 |
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. |
REFINABILITY_FLAG | DOUBLE | Y | See values in CMT_CONCEPT_RELTN |
RELATION_CKI | VARCHAR(255) | N | The Relatinship CKI |
RELTN_GROUP | DOUBLE | Y | An integer value that links together Relationships which are part of a logically associated Relationship group. |
RELTN_IDENTIFIER | VARCHAR(60) | N | The unique SNOMED CT Identifier of this Relationship. |
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_CONTENT_VERSION
Column Section | Top of Page |
Table-level Detail
Description: | community content version |
Definition: | Version number for vocabulary. Version information for various 3rd party content (ICD9, ICD10, SNOMED, etc) installed on the client site. |
Table Type: | REFERENCE |
Column Detail - CMT_CONTENT_VERSION
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. |
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. |
CMT_CONTENT_VERSION_ID | DOUBLE | N | Sequence: Reference_seq This is the value of the unique identifier of the cmt_content_version table. It is an internal system assigned number. |
CONTENT_TYPE_FLAG | DOUBLE | N | Content version type. 0 - terminology as whole 1 - subset of terminology by vocab_axis 2 - cross mapping |
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. |
PACKAGE_NBR | DOUBLE | N | Package from which load was run. |
PARENT_ENTITY_ID | DOUBLE | N | The value of the primary identifier of the table to which the address row is related (i.e., person_id, organization_id, etc.) |
PARENT_ENTITY_NAME | VARCHAR(32) | N | The upper case name of the table to which this address row is related (i.e., PERSON, PRSNL, ORGANIZATION, etc.) |
SOURCE_VOCABULARY_CD | DOUBLE | N | Code set : 400 The identifier of the vocabulary. |
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_FT | VARCHAR(100) | Y | Free text version number in alphanumeric value. |
VERSION_NUMBER | DOUBLE | Y | Version number in numeric value. |
VER_BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which the version of the vocabulary becomes effective. |
VER_END_EFFECTIVE_DT_TM | DATETIME | Y | The date and time after which the version of the vocabulary is no longer effective. |
CMT_CROSS_MAP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CMT CROSS MAP |
Definition: | A crossmap links a single SNOMED CT concept to one or more concepts in target terminologies, such as ICD-9-CM, CPT-4 etc. |
Table Type: | REFERENCE |
Column Detail - CMT_CROSS_MAP
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. |
CMT_CROSS_MAP_ID | DOUBLE | N | cmt cross map identifierColumn |
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". |
CROSS_MAP_FLAG | DOUBLE | Y | Cross_map_FlagColumn |
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. |
GROUP_SEQUENCE | DOUBLE | Y | Group SequenceColumn |
MAP_TYPE_CD | DOUBLE | N | The type of cross mapping to indicate whether the SNOMED to ICD-9-cm mapping relationship is one-to-one, or whether the SNOMED concept is more specific or general than the ICD-9-cm code. |
MAP_TYPE_FLAG | DOUBLE | Y | map type flagColumn |
SOURCE_IDENTIFIER | VARCHAR(242) | N | The code, or key, from source vocabulary that contributed the term to the nomenclature. |
SOURCE_VOCABULARY_CD | DOUBLE | N | The external vocabulary or lexicon that contributed the code. For example, ICD9, CPT4 etc. |
TARGET_CONCEPT_CKI | VARCHAR(255) | N | Contains the target concept_cki to which the concept_cki is mapped. |
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 - CMT_CROSS_MAP
Child Column in CMT_CROSS_MAP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CONCEPT_CKI | CMT_CONCEPT | CONCEPT_CKI |
MAP_TYPE_CD | CODE_VALUE | CODE_VALUE | |
SOURCE_VOCABULARY_CD | CODE_VALUE | CODE_VALUE |
CMT_CROSS_MAP_LOAD
Column Section | Top of Page |
Table-level Detail
Description: | CMT Cross map Load Table |
Definition: | A crossmap links a single SNOMED CT concept to one or more concepts in target terminologies, such as ICD-9-CM, CPT-4, etc. This table is used to upload the latest cross maps and update the CMT_CROSS_MAP table. |
Table Type: | REFERENCE |
Column Detail - CMT_CROSS_MAP_LOAD
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. |
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. |
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". |
CROSS_MAP_FLAG | DOUBLE | Y | Cross_map_Flag. Possible values are : 0, = ? |
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. |
FORCED_OBS_IND | DOUBLE | Y | If the table row is obsolete, but its concept_cki and target_concept_cki are still active on the cmt_concept table, it may be forced into obsoletion. Otherwise, the table row in CMT_CROSS_MAP will not be made obsolete. |
GROUP_SEQUENCE | DOUBLE | N | This column used for group sequence |
MAP_TYPE_CD | DOUBLE | N | Map Type Code from code set 29223 |
MAP_TYPE_FLAG | DOUBLE | Y | Map Type Flag. Possible values are 0 = ?, etc. |
MAP_TYPE_MEAN | VARCHAR(12) | Y | The type of cross mapping to indicate whether the SNOMED to ICD-9-cm mapping relationship is one-to-one, or whether the SNOMED concept is more specific or general than the ICD-9-cm code. |
SOURCE_MEAN | VARCHAR(12) | Y | The external vocabulary or lexicon that contributed the concept_cki. For example, ICD9, CPT4 etc. |
TARGET_CONCEPT_CKI | VARCHAR(255) | N | Contains the target concept_cki to which the concept_cki is mapped. |
TARGET_MEAN | VARCHAR(12) | Y | The external vocabulary or lexicon that contributed the target_concept_cki. For example, ICD9, CPT4 etc. |
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. |