Table Detail Report
CMT_CONCEPT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | The cmt_concept table contains one row for each unique meaning or idea. |
Definition: | The cmt_concept table contains one row for each unique meaning or idea. Its purpose is to link alternative names and views of the same concept together and to identify useful relationships between different concepts through the semantic network. |
Table Type: | REFERENCE |
Column Detail - CMT_CONCEPT
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. |
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". |
CONCEPT_IDENTIFIER | VARCHAR(242) | N | The unique identifier supplied from other external database (e.g. SNOMED) or Cerner and is persistent once it is assigned to a concept. If the concept is from SNOMED, concept identifier is the unique SNOMED Clinical Term identifier provided by CAP. |
CONCEPT_NAME | VARCHAR(2000) | Y | A phrase that describes a concept in a way that it is intended to be unambiguous. It is the same as "Fully Specified Name" in SNOMED CT. It explains the meaning of the concept more fully than preferred term. |
CONCEPT_SOURCE_MEAN | VARCHAR(12) | N | Represents the source that owns the concept identifier. |
DISALLOWED_IND | DOUBLE | Y | An indication of whether the term is allowed for selection or not. 0 - allowed1 - disallowed |
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. |
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_CONCEPT
Parent Column in CMT_CONCEPT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CONCEPT_CKI | CMT_CONCEPT_EXPLODE | CHILD_CONCEPT_CKI |
CMT_CONCEPT_EXPLODE | PARENT_CONCEPT_CKI | ||
CMT_CONCEPT_EXTENSION | CONCEPT_CKI | ||
CMT_CONCEPT_HISTORY | CONCEPT_CKI | ||
CMT_CONCEPT_HISTORY | REFERENCE_CONCEPT_CKI | ||
CMT_CONCEPT_RELTN | CONCEPT_CKI1 | ||
CMT_CONCEPT_RELTN | CONCEPT_CKI2 | ||
CMT_CONCEPT_RELTN | RELATION_CKI | ||
CMT_CROSS_MAP | CONCEPT_CKI | ||
CMT_SUBSET_MEMBER | CHILD_CONCEPT_CKI | ||
CMT_SUBSET_MEMBER | PARENT_CONCEPT_CKI | ||
CONCEPT_IDENT_BB_CODE | CONCEPT_CKI | ||
CONCEPT_IDENT_BB_DTA | CONCEPT_CKI | ||
CONCEPT_IDENT_MIC_RPT | CONCEPT_CKI | ||
CONCEPT_IDENT_MIC_SUSC | CONCEPT_CKI |
CMT_CONCEPT_EXPLODE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CMT CONCEPT EXPLODE |
Definition: | Provides an exploded view of the hierarchies defined in the cmt_concept_reltn table. |
Table Type: | REFERENCE |
Column Detail - CMT_CONCEPT_EXPLODE
Column Name | Type | Null? | Definition |
---|---|---|---|
CHILD_CONCEPT_CKI | VARCHAR(255) | N | The child concept_cki in the hierarchy. |
EFFECTIVE_IND | DOUBLE | N | The Effective Status of the Relationship |
PARENT_CONCEPT_CKI | VARCHAR(255) | N | The parent concept_cki in the hierarchy. |
SOURCE_VOCABULARY_CD | DOUBLE | N | Stores a _cd that indicates which vocabulary the row belongs to |
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_CONCEPT_EXPLODE
Child Column in CMT_CONCEPT_EXPLODE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CHILD_CONCEPT_CKI | CMT_CONCEPT | CONCEPT_CKI |
PARENT_CONCEPT_CKI | CMT_CONCEPT | CONCEPT_CKI |
CMT_CONCEPT_EXPLODE_LOAD
Column Section | Top of Page |
Table-level Detail
Description: | CMT_CONCEPT_EXPLODE_LOAD |
Definition: | Table used for temporary storage of cmt_concept_explode data. This table is only used during content package installs. |
Table Type: | REFERENCE |
Column Detail - CMT_CONCEPT_EXPLODE_LOAD
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_FLAG | DOUBLE | Y | Flag for determining delete/insert action |
CHILD_CONCEPT_CKI | VARCHAR(255) | N | Child Concept CKI. FK from the CMT_CONCEPT table. |
EFFECTIVE_IND | DOUBLE | N | The Effective Status of the Relationship |
PARENT_CONCEPT_CKI | VARCHAR(255) | N | Parent Concept CKI. FK from the CMT_CONCEPT table. |
SOURCE_VOCABULARY_MEAN | VARCHAR(12) | N | Stores a meaning that indicates which vocabulary the row belongs to |
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_EXPLODE_LOAD_NS
Column Section | Top of Page |
Table-level Detail
Description: | CMT_CONCEPT_EXPLODE_LOAD_NS |
Definition: | This is a holding table for the cmt_concept_explode to allow faster loading. This table is identical to cmt_concept_explode_load except that the _ns table will not contain any snomed items. |
Table Type: | REFERENCE |
Column Detail - CMT_CONCEPT_EXPLODE_LOAD_NS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_FLAG | DOUBLE | Y | Flag for determining delete/insert action |
CHILD_CONCEPT_CKI | VARCHAR(255) | N | Child Concept CKI. FK from the CMT_CONCEPT table. |
EFFECTIVE_IND | DOUBLE | N | The Effective Status of the Relationship |
PARENT_CONCEPT_CKI | VARCHAR(255) | N | Parent Concept CKI. FK from the CMT_CONCEPT table. |
SOURCE_VOCABULARY_MEAN | VARCHAR(12) | N | Stores a meaning that indicates which vocabulary the row belongs to |
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_EXTENSION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CMT Concept extension |
Definition: | Each row in the table store the information for the concept extension. Client is not allowed to modify this table. |
Table Type: | REFERENCE |
Column Detail - CMT_CONCEPT_EXTENSION
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. |
AGE1_OPERATOR | VARCHAR(2) | Y | Operator for age. E.g. >,<,>=,<= |
AGE1_UNIT_FLAG | DOUBLE | Y | Unit of measure for age. |
AGE1_VALUE | DOUBLE | Y | The numeric value for age. |
AGE2_OPERATOR | VARCHAR(2) | Y | Operator for age. E.g. >,<,>=,<= |
AGE2_UNIT_FLAG | DOUBLE | Y | Unit of measure for age. |
AGE2_VALUE | DOUBLE | Y | The numeric value for age. |
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. |
CONCEPT_CKI | VARCHAR(255) | N | Functional unique identifier from cmt_concept_table. |
CONCEPT_EXTENSION_ID | DOUBLE | N | Primary key of concept extension table |
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. |
EXTENSION_DATA_TYPE_FLAG | DOUBLE | N | The value associated with the extension_type_meaning |
EXTENSION_TYPE_MEAN | VARCHAR(12) | N | Value from code Set 29746 |
EXTENSION_VALUE | VARCHAR(40) | N | The value associated with the extension type mean |
GENDER_FLAG | DOUBLE | Y | Gender. 0 = unknown and/or do not care; 1 = male; 2 = female |
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 - CMT_CONCEPT_EXTENSION
Child Column in CMT_CONCEPT_EXTENSION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CONCEPT_CKI | CMT_CONCEPT | CONCEPT_CKI |