Table Detail Report
CONCEPT_CKI_ENTITY_R
Column Section | Top of Page |
Table-level Detail
Description: | Concept CKI entity relation |
Definition: | The relationship between concept_cki and value from different table. |
Table Type: | REFERENCE |
Column Detail - CONCEPT_CKI_ENTITY_R
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. |
CKI_SEQUENCE | DOUBLE | Y | Supports multiple concept_ckis as part of a single modifier. |
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_CKI_ENTITY_R_ID | DOUBLE | N | concept cki entity relation identifierColumn |
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. |
ENTITY_ID | DOUBLE | N | The Cerner internal Id for the table (Entity Name) |
ENTITY_NAME | VARCHAR(40) | N | Table name where concept_cki is linked. |
EVENT_SET_NAME | VARCHAR(40) | Y | The event set name from the v500_event_set_code table. |
GROUP_SEQ | DOUBLE | Y | Supports multiple groups of the modifier. |
RELTN_TYPE_CD | DOUBLE | N | CODE SET: 29753The relationships type. |
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_CONCEPT_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Concept Concept Relationship |
Definition: | The Concept Concept Relationship table stores the meaningful relationships between concepts. The most common types of relationships are IS_A and PART_OF. |
Table Type: | REFERENCE |
Column Detail - CONCEPT_CONCEPT_R
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_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. |
CKI1 | VARCHAR(255) | N | The first concept in the relationship. |
CKI1_VALUE | DOUBLE | Y | Relates to cki1, where the concept for cki1 represents a scalar. This column stores the number associated with the scalar concept. |
CKI2 | VARCHAR(255) | N | The related concept in the relationship. |
CKI2_VALUE | DOUBLE | Y | Relates to cki2, where the concept for cki2 represents a scalar. This column stores the number associated with the scalar concept. |
CONCEPT_CONCEPT_ID | DOUBLE | N | Primary key for the table. Uniquely identifies a row within the table. |
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. |
INVERSE_RELATION_ID | DOUBLE | N | The relationship that is the inverse of the relation_id, e.g. if the relation_id represented PART_OF, then the inverse_relation_id may represent HAS_PART. |
RELATION_ID | DOUBLE | N | Represents the kind of relationship between two concepts, e.g. IS_A or PART_OF. |
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 - CONCEPT_CONCEPT_R
Child Column in CONCEPT_CONCEPT_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | INVERSE_RELATION_ID | SEMANTIC_TYPE | SEMANTIC_TYPE_ID |
RELATION_ID | SEMANTIC_TYPE | SEMANTIC_TYPE_ID |
CONCEPT_DEFINITION
Column Section | Top of Page |
Table-level Detail
Description: | Concept Definition |
Definition: | Each row in the Concept Definition table is a definition of the concept. A concept may have definitions contributed from multiple source vocabularies. |
Table Type: | REFERENCE |
Column Detail - CONCEPT_DEFINITION
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. |
CONCEPT_DEFINITION_ID | DOUBLE | N | This is the value of the unique primary identifier of the concept definition table. It is an internal system assigned number. |
CONCEPT_IDENTIFIER | VARCHAR(242) | Y | 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. |
DEFINITION | VARCHAR(1000) | Y | Narrative description of the meaning of the concept. |
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. |
SOURCE_VOCABULARY_CD | DOUBLE | N | The external vocabulary or lexicon that contributed the string, e.g. ICD9, SNOMED, etc. |
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_PROPERTY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Stores the HNAM properties associated with a concept. |
Definition: | Concept Property |
Table Type: | REFERENCE |
Column Detail - CONCEPT_PROPERTY
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 | 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 CKI that the properties belong. |
CONCEPT_PROPERTY_ID | DOUBLE | N | Uniquely identifies a row in the 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. |
LONG_BLOB_ID | DOUBLE | N | Long blob idColumn |
LONG_TEXT_ID | DOUBLE | N | The id of the xml string that contains the concept property data in the long_text_reference table. |
SEMANTIC_TYPE_ID | DOUBLE | N | The semanitc type associated with 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. |
Relationship Detail - CONCEPT_PROPERTY
Child Column in CONCEPT_PROPERTY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LONG_BLOB_ID | LONG_BLOB_REFERENCE | LONG_BLOB_ID |
LONG_TEXT_ID | LONG_TEXT_REFERENCE | LONG_TEXT_ID | |
SEMANTIC_TYPE_ID | SEMANTIC_TYPE | SEMANTIC_TYPE_ID |
CONCEPT_SEMTYPE_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Concept Semantic Type Relationship |
Definition: | Provides for the categorization of concepts in the semantic network. |
Table Type: | REFERENCE |
Column Detail - CONCEPT_SEMTYPE_R
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. |
CKI | VARCHAR(255) | N | The concept that is related to the semantic type. |
CONCEPT_SEMTYPE_ID | DOUBLE | N | Primary key for the table. Uniquely identifies a row within the table. |
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. |
SEMANTIC_TYPE_ID | DOUBLE | N | The semantic type that the concept is related. |
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 - CONCEPT_SEMTYPE_R
Child Column in CONCEPT_SEMTYPE_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SEMANTIC_TYPE_ID | SEMANTIC_TYPE | SEMANTIC_TYPE_ID |