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