Table Detail Report

LH_D_INTERP_RESULTS



Column Section Top of Page


Table-level Detail

Description: LH_D_INTERP_RESULTS
Definition: Dimension table to store Interpretatoin Results Reference Data for Infection Control Reports
Table Type: REFERENCE





Column Detail - LH_D_INTERP_RESULTS


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.
D_INTERP_RESULTS_ID DOUBLE N Unique generated number that identifies a single row on the LH_D_INTERP_RESULTS 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.
EXTRACT_DT_TM DATETIME Y The date/time that the program running the extracts was started. This filed should be the same across all files and across all records within a file for a given extraction run. This time should be in UTC time.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data
INTERP_CD DOUBLE N CODE SET 64
INTERP_DESCRIPTION VARCHAR(60) Y The description of the interpretation result
INTERP_DISPLAY VARCHAR(50) Y The display value for the interpretation result
INTERP_MEANING VARCHAR(50) Y The Cerner-identified meaning for the interpretation result
PROCESS_DT_TM DATETIME Y The date/time the record wad first loaded into the table.
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_SOURCE VARCHAR(50) N The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) N The registered (assigned) task number for the process that inserted or updated the row.


LH_D_ISOLATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_D_ISOLATION
Definition: Dimension table for Lighthouse report
Table Type: REFERENCE





Column Detail - LH_D_ISOLATION


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N Identifies whether this record is active or has been logically deleted.
BEG_EFFECTIVE_DT_TM DATETIME Y The date/time on which the record became effective; defaults to 1/01/1800.
D_ISOLATION_ID DOUBLE N Unique identifier for the isolation.
END_EFFECTIVE_DT_TM DATETIME Y The date/time on which the record is no longer effective; defaults to 12/31/2100.
EXTRACT_DT_TM DATETIME Y The maximum extraction end date/time of the reporting period
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
ISOLATION_CD DOUBLE N Source identifier for the isolation.
ISOLATION_DESCRIPTION VARCHAR(60) Y The description for the isolation.
ISOLATION_DISPLAY VARCHAR(40) Y The display value for the isolation.
ISOLATION_MEANING VARCHAR(40) Y The Cerner-defined meaning for the isolation.
PROCESS_DT_TM DATETIME Y The date/time the record was first loaded into the table.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update.
UPDT_DT_TM DATETIME N The date/time the row was last inserted or updated.
UPDT_SOURCE VARCHAR(50) N The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) N The application responsible for updating the record.



Relationship Detail - LH_D_ISOLATION




Parent Column in LH_D_ISOLATION (PK) Child Table Name Child Column Name
Children: D_ISOLATION_ID LH_F_HH_METRICS D_ISOLATION_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_HH_METRICS HEALTH_SYSTEM_SOURCE_ID


LH_D_ORGANISM



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_D_ORGANISM
Definition: Dimension table to hold Organism Results for Infection Control Reports
Table Type: REFERENCE





Column Detail - LH_D_ORGANISM


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.
D_ORGANISM_ID DOUBLE N Unique generated number that identifies a single row on the LH_D_ORGANISM 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.
EXTRACT_DT_TM DATETIME Y The date/time that the program running the extracts was started. This filed should be the same across all files and across all records within a file for a given extraction run. This time should be in UTC time.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data
ORGANISM_CD DOUBLE N Code value for organism on codeset 1021.
ORGANISM_DESCRIPTION VARCHAR(50) Y The description of the organism
ORGANISM_DISPLAY VARCHAR(50) Y The display value for the organism
ORGANISM_ENTITY_NAME VARCHAR(50) Y The type of organism being stored
ORGANISM_MEANING VARCHAR(50) Y The Cerner-identified meaning for the organism
PROCESS_DT_TM DATETIME Y The date/time the record wad first loaded into the table.
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_SOURCE VARCHAR(50) N The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - LH_D_ORGANISM




Parent Column in LH_D_ORGANISM (PK) Child Table Name Child Column Name
Children: D_ORGANISM_ID LH_F_IC_ANTIBGRM_METRICS D_ORGANISM_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_IC_ANTIBGRM_METRICS HEALTH_SYSTEM_SOURCE_ID
D_ORGANISM_ID LH_F_IC_MDRO_DTL_METRICS D_ORGANISM_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_IC_MDRO_DTL_METRICS HEALTH_SYSTEM_SOURCE_ID


LH_F_ACT_INTOL_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_ACT_INTOL_METRICS
Definition: Fact table for Activity Intolerance Lighthouse Report
Table Type: ACTIVITY





Column Detail - LH_F_ACT_INTOL_METRICS


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.
ACT_INT_IND DOUBLE Y Identifies patients with a problem of activity intolerance
ADMIT_DT_TM DATETIME Y The date/time on which the patient was admitted.
ADMIT_UTC_DT_TM DATETIME Y The date/time on which the patient was admitted; normalized to GMT.
AI_EDU_OUTCOMES_MET_IND DOUBLE Y Identifies if the patient with activity intolerance has education outcomes met prior to discharge
ARRIVAL_DT_TM DATETIME Y The date/time on which the patient arrived at the facility.
ARRIVAL_UTC_DT_TM DATETIME Y The date/time on which the patient arrived at the facility; normalized to GMT.
BASE_FX_STATUS_IND DOUBLE Y Identifies if the patient returned to admission functional status at time of discharge
BEDREST_HRS DOUBLE Y Time in hours between the order for bedrest and the bedrest end time.
CARE_LEVEL_DISCH_IND DOUBLE Y Identifies if the patient had level of care at discharge equal or lower than at admission
CARE_LEVEL_IND DOUBLE Y Identifies if the patient had level of care documented.
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
DISCHARGE_DT_TM DATETIME Y The date/time on which the patient was discharged.
DISCHARGE_UTC_DT_TM DATETIME Y The date/time on which the patient was discharged; normalized to GMT.
D_ADMIT_BUILDING_ID DOUBLE N The building to which the patient was admitted.
D_ADMIT_FACILITY_ID DOUBLE N The facility to which the patient was admitted.
D_ADMIT_NURSE_UNIT_ID DOUBLE N The nurse unit to which the patient was admitted.
D_ADMIT_SRC_ID DOUBLE N Identifies the place from which the patient came before being admitted.
D_ADMIT_TYPE_ID DOUBLE N Indicates the circumstances under which the patient was admitted.
D_ATTEND_PRSNL_ID DOUBLE N Identifies the final attending physician associated to the encounter.
D_DISCHARGE_BUILDING_ID DOUBLE N The building from which the patient was discharged
D_DISCHARGE_FACILITY_ID DOUBLE N The facility from which the patient was discharged
D_DISCHARGE_NURSE_UNIT_ID DOUBLE N The nurse unit from which the patient was discharged
D_DISCH_DISP_ID DOUBLE N The conditions under which the patient left the facility at the time of discharge.
D_ENCNTR_TYPE_ID DOUBLE N Categorizes the encounter into a logical group or type. Foreign key to the CODE_VALUE table.
D_MED_SERVICE_ID DOUBLE N The type or category of medical service that the patient is receiving in relation to their encounter. The category may be treatment type, surgery, general resources, or others.
D_METRIC_10_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_11_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_12_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_13_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_14_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_15_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_16_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_17_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_18_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_19_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_1_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_20_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_2_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_3_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_4_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_5_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_6_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_7_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_8_ID DOUBLE N The unique identifier for the quality measure.
D_METRIC_9_ID DOUBLE N The unique identifier for the quality measure.
D_PERSON_ID DOUBLE N The person that qualified for the quality metric.
D_PRIN_DIAGNOSIS_ID DOUBLE N Identifies the principle diagnosis associated with the encounter.
D_PRIN_PROCEDURE_ID DOUBLE N Identifies the principle procedure associated with the encounter.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EVAL_POST_ACT_FLAG DOUBLE Y Identifies if the patient had evaluation post activity documented. 0 - No, 1 - Yes, 999 - Missing.
EVAL_TIMING_IND DOUBLE Y Identifies if the patient had evaluation post activity documented within 24hrs prior to discharge
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FINANCIAL_NBR_TXT VARCHAR(50) Y The financial number alias associated to the encounter.
FIRST_PROCESS_DT_TM DATETIME Y The date/time the record was first loaded into the table.
FX_ASSESS_DAILY_IND DOUBLE Y Identifies patients with a problem of activity intolerance or impaired mobility who had a functional assessment completed daily
F_ACT_INTOL_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_F_ACT_INTOL_METRICS table.
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
IMP_MOB_IND DOUBLE Y Identifies patients with a problem of impaired mobility
IM_EDU_OUTCOMES_MET_IND DOUBLE Y Identifies if the patient with impaired mobility has education outcomes met prior to discharge
LAST_PROCESS_DT_TM DATETIME Y The date/time the record was last loaded into the table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for the logical domain. This identifier allows the data to be grouped by logical domain.
LOS_HRS DOUBLE Y Time in hours between Admit and Discharge
NEW_FUNC_DECLINE_IND DOUBLE Y Identifies patients with a new functional decline from baseline documented at admission.
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
ORTHO_EDU_IND DOUBLE Y Identifies if the patient received education for the orthostatic hypotension precautions.
ORTHO_SX_IND DOUBLE Y Identifies if the symptoms of orthostatic hypotension were documented during activity
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility
PLAN_INITIATED_IND DOUBLE Y Identifies if the patient has had an orderset or powerplan activated.
POPULATION_IND DOUBLE Y Identifies patients that qualify for the base population for the Lighthouse metric.
PRIN_PROCEDURE_DT_TM DATETIME Y The date/time on which the principle procedure was performed.
PRIN_PROCEDURE_UTC_DT_TM DATETIME Y The date/time on which the principle procedure was performed; normalized to GMT.
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_SOURCE VARCHAR(50) N The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - LH_F_ACT_INTOL_METRICS


Child Column in LH_F_ACT_INTOL_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_ADMIT_SRC_ID LH_D_ADMIT_SRC D_ADMIT_SRC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_SRC HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_TYPE_ID LH_D_ADMIT_TYPE D_ADMIT_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_TYPE HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
D_DISCHARGE_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_PRIN_DIAGNOSIS_ID LH_D_DIAGNOSIS D_DIAGNOSIS_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_DIAGNOSIS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_D_DISCH_DISP D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_DISCH_DISP HEALTH_SYSTEM_SOURCE_ID
D_ENCNTR_TYPE_ID LH_D_ENCNTR_TYPE D_ENCNTR_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ENCNTR_TYPE HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
D_DISCHARGE_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_MED_SERVICE_ID LH_D_MED_SERVICE D_MED_SERVICE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_MED_SERVICE HEALTH_SYSTEM_SOURCE_ID
D_METRIC_10_ID LH_D_METRIC D_METRIC_ID
D_METRIC_11_ID LH_D_METRIC D_METRIC_ID
D_METRIC_12_ID LH_D_METRIC D_METRIC_ID
D_METRIC_13_ID LH_D_METRIC D_METRIC_ID
D_METRIC_14_ID LH_D_METRIC D_METRIC_ID
D_METRIC_15_ID LH_D_METRIC D_METRIC_ID
D_METRIC_16_ID LH_D_METRIC D_METRIC_ID
D_METRIC_17_ID LH_D_METRIC D_METRIC_ID
D_METRIC_18_ID LH_D_METRIC D_METRIC_ID
D_METRIC_19_ID LH_D_METRIC D_METRIC_ID
D_METRIC_1_ID LH_D_METRIC D_METRIC_ID
D_METRIC_20_ID LH_D_METRIC D_METRIC_ID
D_METRIC_2_ID LH_D_METRIC D_METRIC_ID
D_METRIC_3_ID LH_D_METRIC D_METRIC_ID
D_METRIC_4_ID LH_D_METRIC D_METRIC_ID
D_METRIC_5_ID LH_D_METRIC D_METRIC_ID
D_METRIC_6_ID LH_D_METRIC D_METRIC_ID
D_METRIC_7_ID LH_D_METRIC D_METRIC_ID
D_METRIC_8_ID LH_D_METRIC D_METRIC_ID
D_METRIC_9_ID LH_D_METRIC D_METRIC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
D_DISCHARGE_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_D_PERSON D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSON HEALTH_SYSTEM_SOURCE_ID
D_ATTEND_PRSNL_ID LH_D_PERSONNEL D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID
D_PRIN_PROCEDURE_ID LH_D_PROCEDURE D_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PROCEDURE HEALTH_SYSTEM_SOURCE_ID


LH_F_ACUTE_PAIN_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_ACUTE_PAIN_METRICS
Definition: This table is used to store Acute pain Management . This table is at the encounter grain.
Table Type: ACTIVITY





Column Detail - LH_F_ACUTE_PAIN_METRICS


Column Name Type Null? Definition
ACCEPT_OUTCOME_IND DOUBLE Y Identifies plan of care outcome event indicative of Acceptable Pain Intensity
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.
ADMIT_DT_TM DATETIME Y The date/time on which the patient was admitted
ADMIT_UTC_DT_TM DATETIME Y The date/time on which the patient was admitted normalized to GMT.
ADVERSE_INTERVENTION_IND DOUBLE Y indicates intervention(s) performed due to opioid adverse effects
AGE_CRITERIA_FLAG DOUBLE Y Age categorized as 1 -Adult, 2-Pediatric, 3-Neonate, 4-Preterm Neonate
ARRIVAL_DT_TM DATETIME Y The date/time on which the patient arrived at the facility.
ARRIVAL_UTC_DT_TM DATETIME Y The date/time on which the patient arrived at the facility normalized to GMT.
ASMT24H_ARRIVAL_CNT DOUBLE Y Number of pain assessments documented within 24 hours of patient admission
ASMT_BTWN_EPISODE_IND DOUBLE Y Identifies if pain present assessments are documented within recommended time interval of pain episode
BEHAVIOR_REDUCED_IND DOUBLE Y Identifies plan of care outcome event indicative of Pain Associated Behaviors Reduced
CAREGIVER_MED_IND DOUBLE Y Identifies plan of care outcome indicative of Caregiver Verbalizes Accurate Medication Admin Routine
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
COMP24H_ASMT_CNT DOUBLE Y Number of comprehensive pain assessments documented by same personnel within 24 hours of patient admission for those who are able to self report pain
COMP_ASMT_DAYS_CNT DOUBLE Y Number of days all comprehensive pain assessments are documented by same personnel for full calendar days when pain is present
DAILY_ASMT_IND DOUBLE Y Identifies if patient was given recommended frequency of pain assessments for full calendar days
DAILY_PAIN_ASMT_NUM DOUBLE Y The recommended frequency of pain assessment for full calendar day based on age of patient
DEF_COMP_FILTERS_CNT DOUBLE Y Number of distinct bedrock filters defined for comprehensive pain assessment
DENOMINATOR_10_IND DOUBLE Y Identifies if the encounter is in the Denominator for metric of patients with actual or suspected pain on opioid therapy who developed an adverse effect
DENOMINATOR_11_IND DOUBLE Y Identifies if the encounter is in the Denominator for metric of patients with actual or suspected pain on opioid therapy who developed an adverse effect requiring intervention
DENOMINATOR_12_IND DOUBLE Y Identifies if the encounter is in the Denominator for metric of patients with actual or suspected pain who were on a pain management plan within X hours of pain-present
DENOMINATOR_13_IND DOUBLE Y Identifies if the encounter is in the Denominator for metric of patients with actual or suspected pain who received pharmacologic and non-pharmacologic therapy per hospital protocol
DENOMINATOR_14_IND DOUBLE Y Identifies if the encounter is in the Denominator for metric of patients on pain plan of care who received pain management education
DENOMINATOR_15_IND DOUBLE Y Identifies if the encounter is in the Denominator for metric of patients on pain plan of care who received pain medication education
DENOMINATOR_16_IND DOUBLE Y Identifies if the encounter is in the Denominator for metric of patients on pain plan of care who self-report pain with acceptable pain intensity
DENOMINATOR_17_IND DOUBLE Y Identifies if the encounter is in the Denominator for metric of patients on pain plan of care who were unable to self report pain with reduction in pain associated behaviors
DENOMINATOR_18_IND DOUBLE Y Identifies if the encounter is in the Denominator for metric of patients on pain plan of care who were unable to self report pain whose caregiver understood discharge medication administration routine
DENOMINATOR_1_IND DOUBLE Y Identifies if the encounter is in the Denominator for metric of patients with actual or suspected pain
DENOMINATOR_2_IND DOUBLE Y Identifies if the encounter is in the Denominator for metric of patients who received a pain assessment X times per day
DENOMINATOR_3_IND DOUBLE Y Identifies if the encounter is in the Denominator for metric of patients with actual or suspected pain who received a daily comprehensive pain assessment
DENOMINATOR_4_IND DOUBLE Y Identifies if the encounter is in the Denominator for metric of patients with actual or suspected pain who were reassessed for pain per hospital protocol
DENOMINATOR_5_IND DOUBLE Y Identifies if the encounter is in the Denominator for metric of non-pharmacological interventions where pain was reassessed per hospital protocol
DENOMINATOR_6_IND DOUBLE Y Identifies if the encounter is in the Denominator for metric of opioid administrations where pain was reassessed per hospital protocol
DENOMINATOR_7_IND DOUBLE Y Identifies if the encounter is in the Denominator for metric of opioid administrations where pain was reassessed per hospital protocol and had effective pharmacological response
DENOMINATOR_8_IND DOUBLE Y Identifies if the encounter is in the Denominator for metric of patients on opioid therapy identified at high risk of opioid induced respiratory depression prior to over sedation
DENOMINATOR_9_IND DOUBLE Y Identifies if the encounter is in the Denominator for metric of patients on opioid therapy identified at high risk of opioid induced respiratory depression who had a sedation and respiratory assessment every 1 hour for the first 12 hours and every 2 hours for the second 12 hours
DISCHARGE_DT_TM DATETIME Y The date/time on which the patient was discharged.
DISCHARGE_UTC_DT_TM DATETIME Y The date/time on which the patient was discharged normalized to GMT.
D_ADMIT_BUILDING_ID DOUBLE N The building to which the patient was admitted.
D_ADMIT_FACILITY_ID DOUBLE N The facility to which the patient was admitted.
D_ADMIT_NURSE_UNIT_ID DOUBLE N The nurse unit to which the patient was admitted.
D_ADMIT_SRC_ID DOUBLE N Identifies the place from which the patient came before being admitted.
D_ADMIT_TYPE_ID DOUBLE N Indicates the circumstances under which the patient was admitted.
D_ATTEND_PRSNL_ID DOUBLE N Identifies the final attending physician associated to the encounter.
D_DISCHARGE_BUILDING_ID DOUBLE N The building from which the patient was discharged
D_DISCHARGE_FACILITY_ID DOUBLE N The facility from which the patient was discharged
D_DISCHARGE_NURSE_UNIT_ID DOUBLE N The nurse unit from which the patient was discharged
D_DISCH_DISP_ID DOUBLE N Identifies the discharge disposition of the encounter
D_ENCNTR_TYPE_ID DOUBLE N Categorizes the encounter into a logical group or type.
D_FINANCIAL_CLASS_ID DOUBLE N Identifies the financial class of the encounter during registration
D_MED_SERVICE_ID DOUBLE N The type or category of medical service that the patient is receiving in relation to their encounter. The category may be treatment type surgery general resources or others.
D_PERSON_ID DOUBLE N The person that qualified for the quality metric.
ENCNTR_CLASS_FILTER VARCHAR(20) Y Identifies if the patient is classified within the category of 'INPATIENT', 'OBSERVATION' and 'EMERGENCY'
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
END_CAL_DT_TM DATETIME Y the date/time of End of the full calendar day (day before discharge or current date)
EXCLUDE_10_IND DOUBLE Y Identifies if the encounter is in the Exclude for metric of patients with actual or suspected pain on opioid therapy who developed an adverse effect
EXCLUDE_11_IND DOUBLE Y Identifies if the encounter is in the Exclude for metric of patients with actual or suspected pain on opioid therapy who developed an adverse effect requiring intervention
EXCLUDE_12_IND DOUBLE Y Identifies if the encounter is in the Exclude for metric of patients with actual or suspected pain who were on a pain management plan within X hours of pain-present
EXCLUDE_13_IND DOUBLE Y Identifies if the encounter is in the Exclude for metric of patients with actual or suspected pain who received pharmacologic and non-pharmacologic therapy per hospital protocol
EXCLUDE_14_IND DOUBLE Y Identifies if the encounter is in the Exclude for metric of patients on pain plan of care who received pain management education
EXCLUDE_15_IND DOUBLE Y Identifies if the encounter is in the Exclude for metric of patients on pain plan of care who received pain medication education
EXCLUDE_16_IND DOUBLE Y Identifies if the encounter is in the Exclude for metric of patients on pain plan of care who self-report pain with acceptable pain intensity
EXCLUDE_17_IND DOUBLE Y Identifies if the encounter is in the Exclude for metric of patients on pain plan of care who were unable to self report pain with reduction in pain associated behaviors
EXCLUDE_18_IND DOUBLE Y Identifies if the encounter is in the Denominator for metric of patients on pain plan of care who were unable to self report pain whose caregiver understood discharge medication administration routine
EXCLUDE_3_IND DOUBLE Y Identifies if the encounter is in the Exclude for metric of patients with actual or suspected pain who received a daily comprehensive pain assessment
EXCLUDE_4_IND DOUBLE Y Identifies if the encounter is in the Exclude for metric of patients with actual or suspected pain who were reassessed for pain per hospital protocol
EXCLUDE_5_IND DOUBLE Y Identifies if the encounter is in the Exclude for metric of non-pharmacological interventions where pain was reassessed per hospital protocol
EXCLUDE_6_IND DOUBLE Y Identifies if the encounter is in the Exclude for metric of opioid administrations where pain was reassessed per hospital protocol
EXCLUDE_7_IND DOUBLE Y Identifies if the encounter is in the Exclude for metric of opioid administrations where pain was reassessed per hospital protocol and had effective pharmacological response
EXCLUDE_8_IND DOUBLE Y Identifies if the encounter is in the Exclude for metric of patients on opioid therapy identified at high risk of opioid induced respiratory depression prior to over sedation
EXCLUDE_9_IND DOUBLE Y Identifies if the encounter is in the Exclude for metric of patients on opioid therapy identified at high risk of opioid induced respiratory depression who had a sedation and respiratory assessment every 1 hour for the first 12 hours and every 2 hours for the second 12 hours
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FINANCIAL_NBR_TXT VARCHAR(50) Y The financial number alias associated to the encounter.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
FULL_CAL_DAYS DOUBLE Y Number of full calendar Days (greater than 2 days) patient stayed in hospital (excluding admit, discharge or current date)
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
IPOC_INITIATED_DT_TM DATETIME Y The date/time pain plan of care was initiated for patient
IPOC_INITIATED_UTC_DT_TM DATETIME Y The date/time pain plan of care was initiated for patient normalized to GMT
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LAST_SELF_RPT_DT_TM DATETIME Y the date/time last able to self report pain response documented for patient
LAST_SELF_RPT_UTC_DT_TM DATETIME Y the date/time last able to self report pain response documented for patient normalized to GMT
LAST_UNABLE_RPT_DT_TM DATETIME Y the date/time last unable to self report pain response documented for patient
LAST_UNABLE_RPT_UTC_DT_TM DATETIME Y the date/time last unable to self report pain response documented for patient normalized to GMT
LH_F_ACUTE_PAIN_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_F_ACUTE_PAIN_METRICS table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
MED_EFFECTIVE_IND DOUBLE Y Identifies if any medication effective response is documented
MED_EFFECT_IM_FLAG DOUBLE Y Identifies if medication effective response is documented after opioid medication is administered via intramuscular route. 1-any response 2-yes response
MED_EFFECT_IV_FLAG DOUBLE Y Identifies if medication effective response is documented after opioid medication is administered via intraveinal route. 1-response is 'NO', 2-response is 'YES'
MED_EFFECT_PO_FLAG DOUBLE Y Identifies if medication effective response is documented after opioid medication is administered via oral route. 1-any response 2-yes response
MED_EFFECT_RESPONSE_IND DOUBLE Y Identifies if documented medication effective response was yes
NON_PHARM_COMFORT_CNT DOUBLE Y Number of times non pharmacological therapy and comfort measures were documented
NON_PHARM_COMFORT_IND DOUBLE Y identifies if non pharmacological therapy or comfort measures are documented
NUMERATOR_10_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients with actual or suspected pain on opioid therapy who developed an adverse effect
NUMERATOR_11_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients with actual or suspected pain on opioid therapy who developed an adverse effect requiring intervention
NUMERATOR_12_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients with actual or suspected pain who were on a pain management plan within X hours of pain-present
NUMERATOR_13_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients with actual or suspected pain who received pharmacologic and non-pharmacologic therapy per hospital protocol
NUMERATOR_14_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients on pain plan of care who received pain management education
NUMERATOR_15_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients on pain plan of care who received pain medication education
NUMERATOR_16_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients on pain plan of care who self-report pain with acceptable pain intensity
NUMERATOR_17_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients on pain plan of care who were unable to self report pain with reduction in pain associated behaviors
NUMERATOR_18_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients on pain plan of care who were unable to self report pain whose caregiver understood discharge medication administration routine
NUMERATOR_1_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients with actual or suspected pain
NUMERATOR_2_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients who received a pain assessment X times per day
NUMERATOR_3_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients with actual or suspected pain who received a daily comprehensive pain assessment
NUMERATOR_4_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients with actual or suspected pain who were reassessed for pain per hospital protocol
NUMERATOR_5_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of non-pharmacological interventions where pain was reassessed per hospital protocol
NUMERATOR_6_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of opioid administrations where pain was reassessed per hospital protocol
NUMERATOR_7_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of opioid administrations where pain was reassessed per hospital protocol and had effective pharmacological response
NUMERATOR_8_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients on opioid therapy identified at high risk of opioid induced respiratory depression prior to over sedation
NUMERATOR_9_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients on opioid therapy identified at high risk of opioid induced respiratory depression who had a sedation and respiratory assessment every 1 hour for the first 12 hours and every 2 hours for the second 12 hours
OPIOID_ADMIN_DT_TM DATETIME Y The date/time of initial opioid administration to a patient
OPIOID_ADMIN_UTC_DT_TM DATETIME Y The date/time of initial opioid administration to a patient normalized to GMT
OPIOID_ADVERSE_IND DOUBLE Y Identifies if patient developed adverse effects post opioid administration
OPIOID_IM_ROUTE_IND DOUBLE Y Identifies intramuscular route of opioid medication administration to a patient
OPIOID_IV_ROUTE_IND DOUBLE Y Identifies Intraveinal route of opioid medication administration to a patient
OPIOID_PO_ROUTE_IND DOUBLE Y Identifies oral route of opioid medication administration to a patient
OPIOID_RESP_RISK_CNT DOUBLE Y Number of times the event identifying risk for opioid induced respiratory depression occurred before opioid medication administration
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
OVERSEDATION_CNT DOUBLE Y Identifies the number of times the patient was over-sedated during the visit.
OVER_SED_DT_TM DATETIME Y The date/time of initial event which indicates over sedation for patient on opioid therapy
OVER_SED_UTC_DT_TM DATETIME Y The date/time of initial event which indicates over sedation for patient on opioid therapy normalized to GMT
PAIN_ASMT_INTERVAL DOUBLE Y Time interval in hours that is recommended for a pain to be reassessed for patient per pain episode
PAIN_DAYS_CNT DOUBLE Y Number of days Pain present assessments documented daily for full calendar days
PAIN_EPISODE_CNT DOUBLE Y Number of pain episodes in an ecounter.Pain episode is the time interval between pain is present date/time and pain not present date/time
PAIN_MED_EDU_IND DOUBLE Y Indicates if the patient, family, or caregiver received pain medication education
PAIN_MGMT_EDU_IND DOUBLE Y Indicates if the patient, family, or caregiver received pain management education
PAIN_MGMT_ORDER_DT_TM DATETIME Y The date/time pain management order was documented for patient
PAIN_MGMT_ORDER_UTC_DT_TM DATETIME Y The date/time pain management order was documented normalized to GMT
PAIN_NOT_PRESENT_IND DOUBLE Y Identifies if the patient has no actual or suspected pain.
PAIN_PRESENT_DT_TM DATETIME Y The initial date/time on which the patient had actual or suspected pain.
PAIN_PRESENT_IND DOUBLE Y Identifies if the patient has actual or suspected pain.
PAIN_PRESENT_UTC_DT_TM DATETIME Y The initial date/time on which the patient had actual or suspected pain normalized to GMT
PAIN_PRIOR_NON_PHARM_IND DOUBLE Y Pain present assessment documented prior to non pharmacological therapy or comfort measures
PAIN_PRIOR_OPIOID_IM_IND DOUBLE Y Pain present assessment documented prior to intramuscular route of opioid administration
PAIN_PRIOR_OPIOID_IV_IND DOUBLE Y Pain present assessment documented prior to Intraveinal route of opioid administration
PAIN_PRIOR_OPIOID_PO_IND DOUBLE Y Pain present assessment documented prior to oral route of opioid administration
PHARM_THERAPY_CNT DOUBLE Y Number of times pharmacological therapy were documented
PHARM_THERAPY_IND DOUBLE Y identifies if pharmacological therapy is documented
PHARM_WTH_NON_PHARM_IND DOUBLE Y Identifies if non pharmacological therapy or comfort measures are documented within a recommended timeframe after each pharmacological therapy
POPULATION_IND DOUBLE Y Identifies if the encounter is qualified initial population for Acute Pain Management
POSTMENSTRUAL_AGE VARCHAR(255) Y The postmenstrual age of preterm neonate patient
POWER_PLAN_TMFRM DOUBLE Y Timeframe in minutes recommended for pain management plan to be initiated once pain present is documented
REASMT_NON_PHARM_IND DOUBLE Y Pain reassessed within recommended timeframe after non pharmacological therapy or comfort measures are given to patient
REASMT_NON_PHARM_TMFRM DOUBLE Y Timeframe in minutes recommended for pain reassessment after non pharmacological therapy or comfort measures are given to patient
RESP_RISK_DT_TM DATETIME Y The date/time of initial event which identifies patient is at high risk of opioid induced respiratory depression
RESP_RISK_UTC_DT_TM DATETIME Y The date/time of initial event which identifies patient is at high risk of opioid induced respiratory depression normalized to GMT
SEDATION_DAYS_CNT DOUBLE Y Identifies the number of sedation days during the visit.
SED_RESP_ASMT12H_CNT DOUBLE Y Number of times recommended sedation and respiratory assessments were documented every 1 hour for the first 12hours after opioid administration
SED_RESP_ASMT24H_CNT DOUBLE Y Number of times recommended sedation and respiratory assessments were documented every 2 hour from 12th to 24th hour after opioid administration
START_CAL_DT_TM DATETIME Y the date/time of Start of the full calendar day (day after admission date)
UNABLE_RPT_PAIN24H_IND DOUBLE Y Pain documented within 24 hours of patient admission for those who are unable to self report
UPDT_CNT DOUBLE Y 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 Y 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_SOURCE VARCHAR(50) N The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) 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 - LH_F_ACUTE_PAIN_METRICS


Child Column in LH_F_ACUTE_PAIN_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_ADMIT_SRC_ID LH_D_ADMIT_SRC D_ADMIT_SRC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_SRC HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_TYPE_ID LH_D_ADMIT_TYPE D_ADMIT_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_TYPE HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
D_DISCHARGE_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_D_DISCH_DISP D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_DISCH_DISP HEALTH_SYSTEM_SOURCE_ID
D_ENCNTR_TYPE_ID LH_D_ENCNTR_TYPE D_ENCNTR_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ENCNTR_TYPE HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
D_DISCHARGE_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_FINANCIAL_CLASS_ID LH_D_FINANCIAL_CLASS D_FINANCIAL_CLASS_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FINANCIAL_CLASS HEALTH_SYSTEM_SOURCE_ID
D_MED_SERVICE_ID LH_D_MED_SERVICE D_MED_SERVICE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_MED_SERVICE HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
D_DISCHARGE_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_D_PERSON D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSON HEALTH_SYSTEM_SOURCE_ID
D_ATTEND_PRSNL_ID LH_D_PERSONNEL D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID