CONCEPT_PRSNL_CROSSMAP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Concept personnel crossmap |
Definition: | Table used to store concept mappings established by end users. |
Table Type: | ACTIVITY |
Column Detail - CONCEPT_PRSNL_CROSSMAP
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. |
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_PRSNL_CROSSMAP_ID | DOUBLE | N | Unique identifier for table row. |
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. |
MAP_SCOPE_MEAN | VARCHAR(12) | Y | Map scope identifier used to determine the scope of the mapping's applicability (all patients, this patient, etc.) |
MAP_TYPE_MEAN | VARCHAR(12) | Y | Map type identifier used to distinguish between specific entities that were crossmapped (problem to diagnosis, diagnosis to problem, etc.) |
PERSON_ID | DOUBLE | N | Person Patient ID |
PRSNL_ID | DOUBLE | N | Unique identifier for the user who established the concept mapping. |
SOURCE_CONCEPT_CKI | VARCHAR(255) | Y | Concept identifier for the source concept. |
SOURCE_NOMEN_ID | DOUBLE | N | Nomenclature identifier for the source nomenclature. |
SOURCE_VOCAB_CD | DOUBLE | N | Vocabulary code identifier for the source concept |
TARGET_CONCEPT_CKI | VARCHAR(255) | Y | Concept identifier for the target concept. |
TARGET_NOMEN_ID | DOUBLE | N | Nomenclature identifier for the target nomenclature. |
TARGET_VOCAB_CD | DOUBLE | N | Vocabulary code identifier for the target 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_PRSNL_CROSSMAP
Child Column in CONCEPT_PRSNL_CROSSMAP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SOURCE_NOMEN_ID | NOMENCLATURE | NOMENCLATURE_ID |
TARGET_NOMEN_ID | NOMENCLATURE | NOMENCLATURE_ID | |
PERSON_ID | PERSON | PERSON_ID | |
PRSNL_ID | PRSNL | PERSON_ID |
CONDITION_PRIORITY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CONDITION PRIORITY |
Definition: | Store the user level priority for the conditions associated to a specific patient |
Table Type: | ACTIVITY |
Column Detail - CONDITION_PRIORITY
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. |
CONDITION_ENTITY_ID | DOUBLE | N | Contains a PK value from the table noted in field CONDITION_ENTITY_NAME |
CONDITION_ENTITY_NAME | VARCHAR(30) | N | Identifies the table for field CONDITION_ENTITY_ID( PROBLEM, DIAGNOSIS ) |
CONDITION_PRIORITY_ID | DOUBLE | N | PRIMARY KEY |
ENCNTR_ID | DOUBLE | N | Identifies the ENCOUNTER associated with this condition |
OWNER_ENTITY_ID | DOUBLE | N | Identifies a row in the table noted in OWNER_ENTITY_NAME) - The PK value |
OWNER_ENTITY_NAME | VARCHAR(30) | N | Identifies the table for field OWNER_ENTITY_ID( PERSON, ENCOUNTER, PCT_CARE_TEAM ) |
PERSON_ID | DOUBLE | N | The PK value of the PERSON row associated with this condition |
PRIORITY_NBR | DOUBLE | N | a numeric value indicating the relative priority |
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 - CONDITION_PRIORITY
Child Column in CONDITION_PRIORITY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
PERSON_ID | PERSON | PERSON_ID |
CONDITION_SUMMARY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CONDITION SUMMARY |
Definition: | This table stores historical summaries for a CONDITION (based on DIAGNOSIS and/or PROBLEM) |
Table Type: | ACTIVITY |
Column Detail - CONDITION_SUMMARY
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. |
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. |
CONDITION_ENTITY_ID | DOUBLE | N | The condition entity the condtion summary is related or tied to. This can be a problem_id or a diagnosis_id. A PK value from the table identified in CONDITION_ENTITY_NAME. |
CONDITION_ENTITY_NAME | VARCHAR(30) | Y | The table to which the condition entity id is associated. This can be PROBLEM or DIAGNOSIS. |
CONDITION_SUMMARY | LONGTEXT | Y | The textual value of the problem summary |
CONDITION_SUMMARY_GROUP_ID | DOUBLE | N | The parent or group id for the condition summary. This can be used as a means to version a condition summary. Contains the PK value for the initial CONDITION_SUMMARY row which begins the group |
CONDITION_SUMMARY_ID | DOUBLE | N | PRIMARY KEY |
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. |
PERSON_ID | DOUBLE | N | The person_id of the patient to whom the condition belongs. |
RECORDED_BY_PRSNL_ID | DOUBLE | N | The person who recorded the Condition summary. |
RECORDED_DT_TM | DATETIME | Y | The date and time the condition summary was recorded |
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 - CONDITION_SUMMARY
Child Column in CONDITION_SUMMARY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CONDITION_SUMMARY_GROUP_ID | CONDITION_SUMMARY | CONDITION_SUMMARY_ID |
PERSON_ID | PERSON | PERSON_ID | |
RECORDED_BY_PRSNL_ID | PRSNL | PERSON_ID |
Parent Column in CONDITION_SUMMARY (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CONDITION_SUMMARY_ID | CONDITION_SUMMARY | CONDITION_SUMMARY_GROUP_ID |
DIAGNOSIS_ACTION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Diagnosis Action |
Definition: | Each row on the table represents an action (Create, Review, etc.) that a particular clinician performed on a clinical diagnosis. |
Table Type: | ACTIVITY |
Column Detail - DIAGNOSIS_ACTION
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_DT_TM | DATETIME | N | Action Date and Time |
ACTION_TYPE_MEAN | VARCHAR(12) | N | Indicates the type of action performed by clinician. In the initial release it will be REVIEW. |
DIAGNOSIS_ACTION_ID | DOUBLE | N | Unique key for the table. Sequence: PROBLEM_SEQ |
DIAGNOSIS_GROUP | DOUBLE | N | Unique identifier for a clinical diagnosis group from DIAGNOSIS table |
DIAGNOSIS_ID | DOUBLE | N | Unique identifier for a clinical diagnosis instance from DIAGNOSIS table |
PRSNL_ID | DOUBLE | N | Unique identifier for the clinician who performed a particular action on the diagnosis. |
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 - DIAGNOSIS_ACTION
Child Column in DIAGNOSIS_ACTION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DIAGNOSIS_ID | DIAGNOSIS | DIAGNOSIS_ID |
PRSNL_ID | PRSNL | PERSON_ID |
PROBLEM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Problem |
Definition: | The Problem table contains coded and freetext problems that are being managed by care providers. Each row in the problem table represents an evolution of a problem. |
Table Type: | ACTIVITY |
Column Detail - PROBLEM
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. |
ACTUAL_RESOLUTION_DT_TM | DATETIME | Y | The date and time that the problem was actually resolved. |
ANNOTATED_DISPLAY | VARCHAR(255) | Y | A de-normalized or annotated description of the problem. This is defaulted from the display term of the selected codified problem, and can be extended (annotated) by the clinician. |
ASSERTED_DT_CD | DOUBLE | Y | Indicate to what level of accuracy the ASSERTED_CYCLE_DT_TM has been set |
ASSERTED_DT_FLAG | DOUBLE | Y | Indicates to what precision (Day, Month, Year, Week Of) the ASSERTED_CYCLE_DT_TM has been set |
ASSERTED_DT_TM | DATETIME | Y | The asserted date refers to the date when a patient or their caregiver reported or asserted the presence of a condition(Diagnosis) or problem |
ASSERTED_TZ | DOUBLE | Y | Time zone associated with the ASSERTED_CYCLE_DT_TM column; |
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. |
BEG_EFFECTIVE_TZ | DOUBLE | Y | Time zone associated with the corresponding DT_TM column. |
CANCEL_REASON_CD | DOUBLE | N | The cancel reason is required when a life cycle status of meaning CANCEL is selected. |
CERTAINTY_CD | DOUBLE | N | Contains a qualitative representation of the certainty of the problem. Alternative approach to probability_cd. |
CLASSIFICATION_CD | DOUBLE | N | Identifies the kind of problem. Used to categorize the problem so that it may be managed and viewed independently within different applications. |
COND_TYPE_FLAG | DOUBLE | N | The condition type. 0 - problem 1 - pregnancy related complication |
CONFIRMATION_STATUS_CD | DOUBLE | N | Indicates the verification status of the problem. |
CONTRIBUTOR_SYSTEM_CD | DOUBLE | N | Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed. |
COURSE_CD | DOUBLE | N | Describes the progress of the disease, e.g. improving, stable, or worsening. |
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. |
DEL_IND | DOUBLE | Y | delete indicatorColumn |
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. |
ESTIMATED_RESOLUTION_DT_TM | DATETIME | Y | The estimated date and time that the problem will be resolved. |
FAMILY_AWARE_CD | DOUBLE | N | Indicates the family¿s comprehension of the actual problem and prognosis. |
LATERALITY_CD | DOUBLE | N | Identifies the code value associated with the laterality of the problem. Code set 4002375 |
LIFE_CYCLE_DT_CD | DOUBLE | N | CODE SET: 25320 Indicate to what level of accuracy the life_cycle_dt_tm has been set. |
LIFE_CYCLE_DT_FLAG | DOUBLE | N | Indicates to what precision (Day, Month, Year) the life_cycle_dt_tm has been set. |
LIFE_CYCLE_DT_TM | DATETIME | Y | The effective date and time of the life_cycle_status_cd. |
LIFE_CYCLE_STATUS_CD | DOUBLE | N | The current status of the problem. |
LIFE_CYCLE_TZ | DOUBLE | Y | Time zone associated with the corresponding DT_TM column. |
NOMENCLATURE_ID | DOUBLE | N | Unique identifier for nomenclature item. |
ONSET_DT_CD | DOUBLE | N | Not Used. |
ONSET_DT_FLAG | DOUBLE | Y | Indicates to what precision (Day, Month, or Year) the ONSET_DT_TM has been set. |
ONSET_DT_TM | DATETIME | Y | The date and time that the problem began. |
ONSET_TZ | DOUBLE | Y | Time zone associated with the corresponding DT_TM column. |
ORGANIZATION_ID | DOUBLE | N | Organization ID. FK from ORGANIZATION table. |
ORIGINATING_ENCNTR_ID | DOUBLE | N | The value of the unique primary identifierof the encounter table. Represents the originating encounter id on which the problem was first documented |
ORIGINATING_NOMENCLATURE_ID | DOUBLE | N | The originating nomenclature id of the problem. This is used to record the source nomenclature id of the problem. |
PERSISTENCE_CD | DOUBLE | N | Indicates the perseverance of a problem. |
PERSON_AWARE_CD | DOUBLE | N | Identifies the person¿s comprehension of the problem. |
PERSON_AWARE_PROGNOSIS_CD | DOUBLE | N | Identifies the person¿s comprehension of the prognosis for the problem. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
PROBABILITY | DOUBLE | Y | Contains a quantitative or numeric representation of the certainty of that the problem exists. For example, a .75 would imply a 75% probability that the problem was correclty identified. Alternative approach to certainty_cd. |
PROBLEM_FTDESC | VARCHAR(255) | Y | Allows a free text description of a problem not found in the nomenclature. |
PROBLEM_ID | DOUBLE | N | Uniquely defines a problem within the problem table. The problem_id can be associated with multiple problem instances. When a new problem is added to the problem table the problem_id is assigned to the problem_instance_id. |
PROBLEM_INSTANCE_ID | DOUBLE | N | Unique identifier for the problem table. Each change or revision made to a problem creates a new problem instance. |
PROBLEM_INSTANCE_UUID | VARCHAR(255) | N | Problem instance unique universal identifierColumn |
PROBLEM_TYPE_FLAG | DOUBLE | N | Problem type flag (0 = problem, 1 = past medical history, 2 = Pregnancy) |
PROBLEM_UUID | VARCHAR(255) | N | Problem unique universal identifierColumn |
PROGNOSIS_CD | DOUBLE | N | Contains the prognosis for the person¿s problem. |
QUALIFIER_CD | DOUBLE | N | It supports the ability to further describe the clinical diagnosis by a qualifier that provides context information. |
RANKING_CD | DOUBLE | N | A user-defined prioritization of the problem. |
SENSITIVITY | DOUBLE | Y | Indicates the level of sensitivity surrounding the problem. |
SEVERITY_CD | DOUBLE | N | Severity of a condition identified by the problem. |
SEVERITY_CLASS_CD | DOUBLE | N | Severity classification system by which the severity code is based on |
SEVERITY_FTDESC | VARCHAR(40) | Y | Free text severity of a condition identified by the problem. |
SHOW_IN_PM_HISTORY_IND | DOUBLE | N | Used to show a particular problem item in past medical history view |
STATUS_UPDT_DT_TM | DATETIME | Y | The date time where the problem was modified. |
STATUS_UPDT_FLAG | DOUBLE | Y | Indicates to what precision (Day, Month, or Year) the status_upt_DT_TM has been set. |
STATUS_UPDT_PRECISION_CD | DOUBLE | N | Indicated to what level of accuracy the status_upd_DT_TM has been set. |
UPDATE_ENCNTR_ID | DOUBLE | N | The value of the unique primary identifierof the encounter table. Represents the last encounter id on which the problem was modified |
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 - PROBLEM
Child Column in PROBLEM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORIGINATING_ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
UPDATE_ENCNTR_ID | ENCOUNTER | ENCNTR_ID | |
NOMENCLATURE_ID | NOMENCLATURE | NOMENCLATURE_ID | |
ORIGINATING_NOMENCLATURE_ID | NOMENCLATURE | NOMENCLATURE_ID | |
ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID | |
PERSON_ID | PERSON | PERSON_ID |
Parent Column in PROBLEM (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PROBLEM_INSTANCE_ID | ONC_FORM_ACTIVITY | PROBLEM_ID |
PREGNANCY_INSTANCE | PROBLEM_ID | ||
PROBLEM_ACTION | PROBLEM_INSTANCE_ID | ||
PROBLEM_COMMENT | PROBLEM_ID | ||
PROBLEM_DISCIPLINE | PROBLEM_ID | ||
PROBLEM_EXT_DATA | PROBLEM_ID | ||
PROBLEM_PRSNL_R | PROBLEM_ID | ||
PROBLEM_SEC_LBL | PROBLEM_ID |