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