Table Detail Report

LH_F_NHIQM_VTE_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_NHIQM_VTE_METRICS
Definition: Fact table for inpatient VTE core measures.
Table Type: ACTIVITY





Column Detail - LH_F_NHIQM_VTE_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.
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.
ANES_START_DT_TM DATETIME Y Identifies the anesthesia start date/time.
ANES_START_UTC_DT_TM DATETIME Y Identifies the anesthesia start date/time.
ANTICOAG_ADMIN_FLAG DOUBLE Y Identifies if the patient had an anticoagulant administered.
ANTICOAG_DISC_FLAG DOUBLE Y Identifies if an anticoagulant was prescribed at discharge.
ANTICOAG_END_DT_TM DATETIME Y The end date/time of anticoagulation therapy.
ANTICOAG_END_UTC_DT_TM DATETIME Y The start date/time of overlap therapy.
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_POPULATION_IND DOUBLE Y Identifies if the patient is in the population for the quality measure.
CLIN_TRIAL_EXCL_FLAG DOUBLE Y Identifies if the patient is part of a clinical trial.
CMO_ORDER_DT_TM DATETIME Y Identifies the date/time for that comfort measures only were placed.
CMO_ORDER_UTC_DT_TM DATETIME Y Identifies the date/time for that comfort measures only were placed.
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_INSTRUCTION_MASK DOUBLE Y Identifies the discharge instructions provided to the patient.
DISCHARGE_UTC_DT_TM DATETIME Y The date/time on which the patient was discharged; normalized to GMT.
DISC_DISP_FLAG DOUBLE Y Identifies the discharge status of the patient.
DISC_OVERLAP_REASON_FLAG DOUBLE Y Identifies if there is a valid reason for discontinuing overlap therapy.
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_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.
D_VTE1_METRIC_ID DOUBLE Y The unique identifier for the quality measure.
D_VTE2_METRIC_ID DOUBLE Y The unique identifier for the quality measure.
D_VTE3_METRIC_ID DOUBLE Y The unique identifier for the quality measure.
D_VTE4_METRIC_ID DOUBLE Y The unique identifier for the quality measure.
D_VTE5_METRIC_ID DOUBLE Y The unique identifier for the quality measure.
D_VTE6_METRIC_ID DOUBLE Y The unique identifier for the quality measure.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXCLUDE_1_IND DOUBLE Y Identifies if a patient was excluded from the quality measure.
EXCLUDE_2_IND DOUBLE Y Identifies if a patient was excluded from the quality measure.
EXCLUDE_3_IND DOUBLE Y Identifies if a patient was excluded from the quality measure.
EXCLUDE_4_IND DOUBLE Y Identifies if a patient was excluded from the quality measure.
EXCLUDE_5_IND DOUBLE Y Identifies if a patient was excluded from the quality measure.
EXCLUDE_6_IND DOUBLE Y Identifies if a patient was excluded from the quality measure.
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.
F_NHIQM_VTE_METRICS_ID DOUBLE N Unique identifier for the lighthouse VTE metrics
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.
ICU_SURGICAL_PATIENT_FLAG DOUBLE Y Identifies if the patient is an ICU surgical patient.
ICU_SURGICAL_PROC_FLAG DOUBLE Y Identifies it is an ICU surgical procedure.
ICU_SURG_END_DT_TM DATETIME Y Identifies the date/time on which surgery while in ICU ended.
ICU_SURG_END_UTC_DT_TM DATETIME Y Identifies the date/time on which surgery while in ICU ended. Normalized to GMT.
ICU_VTE_PROPH_DT_TM DATETIME Y The date/time of VTE prophylaxis in the ICU.
ICU_VTE_PROPH_MASK DOUBLE Y The VTE prophylaxis selected in the ICU.
ICU_VTE_PROPH_UTC_DT_TM DATETIME Y The date/time of VTE prophylaxis in the ICU.
INIT_ICU_ADMIT_DT_TM DATETIME Y Identifies the initial time that the patient was admitted or transferred to the ICU during this visit.
INIT_ICU_ADMIT_UTC_DT_TM DATETIME Y Identifies the initial time that the patient was admitted or transferred to the ICU during this visit.
INIT_ICU_DISC_DT_TM DATETIME Y Identifies the date/time that the patient was discharged from their initial visit to the ICU.
INIT_ICU_DISC_UTC_DT_TM DATETIME Y Identifies the date/time that the patient was discharged from their initial visit to the ICU.
INR_RESULT_VALUE DOUBLE Y Identifies the INR result.
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 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.
MENTAL_DISORDER_DX_IND DOUBLE Y Identifies if the patient has a principal diagnosis for a mental disorder.
NHIQM_VERSION DOUBLE Y Identifies the NHIQM version for which the patient qualifies.
NO_ICU_VTE_PROPH_REAS_FLAG DOUBLE Y A documented reason exists for no VTE prophylaxis in the ICU.
NO_VTE_PROPH_REAS_FLAG DOUBLE Y Identifies if there is a valid reason for not selecting VTE prophylaxis.
NUMERATOR_1_IND DOUBLE Y Identifies if a patient met the quality measure.
NUMERATOR_2_IND DOUBLE Y Identifies if a patient met the quality measure.
NUMERATOR_3_IND DOUBLE Y Identifies if a patient met the quality measure.
NUMERATOR_4_IND DOUBLE Y Identifies if a patient met the quality measure.
NUMERATOR_5_IND DOUBLE Y Identifies if a patient met the quality measure.
NUMERATOR_6_IND DOUBLE Y Identifies if a patient met the quality measure.
OBSTETRICS_DX_IND DOUBLE Y Identifies if the patient has a diagnosis for obstetrics.
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
OVERLAP_START_DT_TM DATETIME Y The start date/time of overlap therapy.
OVERLAP_START_UTC_DT_TM DATETIME Y The start date/time of overlap therapy.
OVERLAY_THERAPY_FLAG DOUBLE Y Identifies if an Overlap Therapy was document.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility
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.
REJECT_1_IND DOUBLE Y Identifies if a patient was rejected from the quality measure due to incomplete documentation.
REJECT_2_IND DOUBLE Y Identifies if a patient was rejected from the quality measure due to incomplete documentation.
REJECT_3_IND DOUBLE Y Identifies if a patient was rejected from the quality measure due to incomplete documentation.
REJECT_4_IND DOUBLE Y Identifies if a patient was rejected from the quality measure due to incomplete documentation.
REJECT_5_IND DOUBLE Y Identifies if a patient was rejected from the quality measure due to incomplete documentation.
REJECT_6_IND DOUBLE Y Identifies if a patient was rejected from the quality measure due to incomplete documentation.
SCIP_PROC_IND DOUBLE Y Identifies if the patient is in the SCIP-VTE population.
STROKE_DX_IND DOUBLE Y Identifies if the patient has a principal diagnosis for stroke.
SURGICAL_PATIENT_FLAG DOUBLE Y Identifies if the patient is a surgical patient.
SURGICAL_PROCEDURE_FLAG DOUBLE Y Identifies if the patient had a surgical procedure.
SURG_END_DT_TM DATETIME Y The surgery end date/time.
SURG_END_UTC_DT_TM DATETIME Y The surgery end date/time.
UFH_ADMIN_FLAG DOUBLE Y Identifies patients that had UFH administered.
UFH_PLATELET_MONITOR_FLAG DOUBLE Y Identifies patients that have had UFH platelet monitored.
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.
VTE_CONFIRMED_FLAG DOUBLE Y Identifies if VTE was confirmed.
VTE_DIAGNOSTIC_FLAG DOUBLE Y Identifies if the patient had VTE diagnostic testing completed.
VTE_DX_FLAG DOUBLE Y Identifies if the patient has a diagnosis for VTE.
VTE_POA_FLAG DOUBLE Y Identifies if VTE was present upon admission.
VTE_PROPH_DT_TM DATETIME Y Identifies the date/time of VTE prophylaxis.
VTE_PROPH_MASK DOUBLE Y Identifies the VTE prophylaxis selected.
VTE_PROPH_STATUS_FLAG DOUBLE Y Identifies the VTE prophylaxis status.
VTE_PROPH_UTC_DT_TM DATETIME Y Identifies the date/time of VTE prophylaxis.
WARFARIN_ADMIN_FLAG DOUBLE Y Identifies if the patient had warfarin administered.
WARFARIN_DISC_FLAG DOUBLE Y Identifies if warfarin was prescribed at discharge.



Relationship Detail - LH_F_NHIQM_VTE_METRICS


Child Column in LH_F_NHIQM_VTE_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_VTE1_METRIC_ID LH_D_METRIC D_METRIC_ID
D_VTE2_METRIC_ID LH_D_METRIC D_METRIC_ID
D_VTE3_METRIC_ID LH_D_METRIC D_METRIC_ID
D_VTE4_METRIC_ID LH_D_METRIC D_METRIC_ID
D_VTE5_METRIC_ID LH_D_METRIC D_METRIC_ID
D_VTE6_METRIC_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
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_PAIN_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Light House Fact Pain Metrics
Definition: Contains data related to the Lighthouse Pain metrics.
Table Type: ACTIVITY





Column Detail - LH_F_PAIN_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.
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.
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.
ASSESS_24H_IND DOUBLE Y Identifies if the appropriate pain assessment was performed within 24 hours of arrival.
ASSESS_AGGRAVATING_FX_IND DOUBLE Y Identifies if the patient was screened for aggravating factors.
ASSESS_ALLEVIATING_FX_IND DOUBLE Y Identifies if the patient was screened for non-aggravating factors
ASSESS_DAILY_IND DOUBLE Y Identifies if the appropriate pain assessment was performed daily.
ASSESS_PAIN_HX_FLAG DOUBLE Y Identifies if the patient was self-reporting or non-self-reporting when assessed for pain history. 1 - Self-Reporting, 2 = Unable to Self-Report, 3 - Other.
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 circumstance under which the patient was admitted or will be admitted.
D_ATTEND_PRSNL_ID DOUBLE N The most recent attending physician associated with 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 Identifies a metric associated with pain. Foreign key to the lh_d_metric table.
D_METRIC_11_ID DOUBLE N Identifies a metric associated with pain. Foreign key to the lh_d_metric table.
D_METRIC_12_ID DOUBLE N Identifies a metric associated with pain. Foreign key to the lh_d_metric table.
D_METRIC_13_ID DOUBLE N Identifies a metric associated with pain. Foreign key to the lh_d_metric table.
D_METRIC_14_ID DOUBLE N Identifies a metric associated with pain. Foreign key to the lh_d_metric table.
D_METRIC_15_ID DOUBLE N Identifies a metric associated with pain. Foreign key to the lh_d_metric table.
D_METRIC_16_ID DOUBLE N Identifies a metric associated with pain. Foreign key to the lh_d_metric table.
D_METRIC_17_ID DOUBLE N Identifies a metric associated with pain. Foreign key to the lh_d_metric table.
D_METRIC_18_ID DOUBLE N Identifies a metric associated with pain. Foreign key to the lh_d_metric table.
D_METRIC_19_ID DOUBLE N Identifies a metric associated with pain. Foreign key to the lh_d_metric table.
D_METRIC_1_ID DOUBLE N Identifies a metric associated with pain. Foreign key to the lh_d_metric table.
D_METRIC_20_ID DOUBLE N Identifies a metric associated with pain. Foreign key to the lh_d_metric table.
D_METRIC_2_ID DOUBLE N Identifies a metric associated with pain. Foreign key to the lh_d_metric table.
D_METRIC_3_ID DOUBLE N Identifies a metric associated with pain Foreign key to the lh_d_metric table.
D_METRIC_4_ID DOUBLE N Identifies a metric associated with pain. Foreign key to the lh_d_metric table.
D_METRIC_5_ID DOUBLE N Identifies a metric associated with pain. Foreign key to the lh_d_metric table.
D_METRIC_6_ID DOUBLE N Identifies a metric associated with pain. Foreign key to the lh_d_metric table.
D_METRIC_7_ID DOUBLE N Identifies a metric associated with pain. Foreign key to the lh_d_metric table.
D_METRIC_8_ID DOUBLE N Identifies a metric associated with pain. Foreign key to the lh_d_metric table.
D_METRIC_9_ID DOUBLE N Identifies a metric associated with pain. NForeign key to the lh_d_metric table.
D_PERSON_ID DOUBLE N Identifies the person associated with the quality measure. Foreign key to the PERSON table.
D_PRIN_DIAGNOSIS_ID DOUBLE N The principal diagnosis associated with the encounter.
D_PRIN_PROCEDURE_ID DOUBLE N The principal procedure associated with the encounter.
EDUCATION_IND DOUBLE Y Identifies if the patient had education documented.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
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.
F_PAIN_METRICS_ID DOUBLE N Unique identifier for the lighthouse pain metrics.
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.
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 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.
NSR_ASSESS_APPROP_CNT DOUBLE Y Identifies the number of times the patient was properly assessed as non-self-reporting.
NSR_ASSESS_PAIN_HX_IND DOUBLE Y Identifies if the non-self-reporting patient was completely screened for pain history.
NSR_PAIN_ASSESS_CNT DOUBLE Y Identifies the number of times the patient was assessed as non-self-reporting
OPIOID_ADMIN_CNT DOUBLE Y Identifies the number of opioid administrations.
OPIOID_APPROP_EVAL_CNT DOUBLE Y Identifies the number of opioid administrations that had appropriate evaluations every 2 hours during the first 24 hours.
OPIOID_EVAL_ND_0300_CNT DOUBLE Y Identifies the number of times the patient was not appropriately evaluated between the hours of 00:01 and 03:00.
OPIOID_EVAL_ND_0600_CNT DOUBLE Y Identifies the number of times the patient was not appropriately evaluated between the hours of 03:01 and 06:00.
OPIOID_EVAL_ND_0900_CNT DOUBLE Y Identifies the number of times the patient was not appropriately evaluated between the hours of 06:01 and 09:00.
OPIOID_EVAL_ND_1200_CNT DOUBLE Y Identifies the number of times the patient was not appropriately evaluated between the hours of 09:01 and 12:00.
OPIOID_EVAL_ND_1500_CNT DOUBLE Y Identifies the number of times the patient was not appropriately evaluated between the hours of 12:01 and 15:00.
OPIOID_EVAL_ND_1800_CNT DOUBLE Y Identifies the number of times the patient was not appropriately evaluated between the hours of 15:01 and 18:00.
OPIOID_EVAL_ND_2100_CNT DOUBLE Y Identifies the number of times the patient was not appropriately evaluated between the hours of 18:01 and 21:00.
OPIOID_EVAL_ND_2400_CNT DOUBLE Y Identifies the number of times the patient was not appropriately evaluated between the hours of 21:01 and 24:00.
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.
PAIN_PRESENT_IND DOUBLE Y Identifies if the patient has actual or suspected pain.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility
PHRM_NON_PHRM_THERAPY_IND DOUBLE Y Identifies if the patient had pharmacological and non-pharmacological therapy.
PLAN_INITIATED_IND DOUBLE Y Identifies if the patient is on a pain management plan.
POPULATION_IND DOUBLE Y Identifies if the patient is a part of the Lighthouse condition population.
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
SEDATION_DAYS_CNT DOUBLE Y Identifies the number of sedation days during the visit.
SR_ASSESS_APPROP_CNT DOUBLE Y Identifies the number of times the patient was properly assessed as self-reporting.
SR_ASSESS_PAIN_HX_IND DOUBLE Y Identifies if the self-reporting patient was completely screened for pain history.
SR_PAIN_ASSESS_CNT DOUBLE Y Identifies the number of times the patient was assessed as self-reporting.
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_PAIN_METRICS


Child Column in LH_F_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_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_PC_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_PC_METRICS
Definition: This table is used to store Pallative Care Metrics for the 2015 reporting period. This table is at the encounter grain.
Table Type: ACTIVITY





Column Detail - LH_F_PC_METRICS


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.
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.
ADULT_SELF_SCORE_IND DOUBLE Y identifies if adult can self score pain
ADULT_UNABLE_IND DOUBLE Y identifies if adult cannot self score pain
ADV_DIR_DT_TM DATETIME Y The date/time Advanced Dircetive was documented for patient
ADV_DIR_UTC_DT_TM DATETIME Y The date/time Advanced Dircetive was documented for patient normalized to GMT
ANXIETY_DX_DT_TM DATETIME Y time when anxiety was identified
ANXIETY_DX_UTC_DT_TM DATETIME Y time when anxiety was identified normalized to GMT
ANXIETY_IPOC_DT_TM DATETIME Y time when anxiety ipoc was ordered on the patient
ANXIETY_IPOC_UTC_DT_TM DATETIME Y time when anxiety ipoc was ordered on the patient normalized to GMT
ANXIETY_PROB_DT_TM DATETIME Y time when anxiety problem was identified
ANXIETY_PROB_UTC_DT_TM DATETIME Y time when anxiety problem was identified normalized to GMT
ANXIETY_TMFRM DOUBLE Y time frame between anxiety identified and depression ipoc should be give to the patient
CLIN_SPECIALITY VARCHAR(255) Y The Speciality of the Referring Clinicians.
COMF_MEASURES VARCHAR(255) Y Comfort measures documented for pain treatment
COMF_MEAS_DT_TM DATETIME Y time when comfort measures were signed
COMF_MEAS_IND DOUBLE Y identifies if comfort measures were taken
COMF_MEAS_UTC_DT_TM DATETIME Y time when comfort measures were signed normalized to GMT
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
DENOMINATOR_10_IND DOUBLE Y Identifies if the encounter is in the denominator for metric 10
DENOMINATOR_11_IND DOUBLE Y Identifies if the encounter is in the denominator for metric 11
DENOMINATOR_12_IND DOUBLE Y Identifies if the encounter is in the denominator for metric 12
DENOMINATOR_13_IND DOUBLE Y Identifies if the encounter is in the denominator for metric 13
DENOMINATOR_14_IND DOUBLE Y Identifies if the encounter is in the denominator for metric 14
DENOMINATOR_15_IND DOUBLE Y Identifies if the encounter is in the denominator for metric 15
DENOMINATOR_16_IND DOUBLE Y Identifies if the encounter is in the denominator for metric 16
DENOMINATOR_17_IND DOUBLE Y Identifies if the encounter is in the denominator for metric 17
DENOMINATOR_1_IND DOUBLE Y Identifies if the encounter is in the denominator for metric 1
DENOMINATOR_2_IND DOUBLE Y Identifies if the encounter is in the denominator for metric 2
DENOMINATOR_37_IND DOUBLE Y Identifies if the encounter is in the Denominator for metric of patients who screened positive for pain screening and received a clinical assessment.
DENOMINATOR_3_IND DOUBLE Y Identifies if the encounter is in the denominator for metric 3
DENOMINATOR_40_IND DOUBLE Y Identifies if the encounter is in the Denominator for metric of patients with Transistion of care is documented and accompanied to Next Level of Care
DENOMINATOR_4_IND DOUBLE Y Identifies if the encounter is in the denominator for metric 4
DENOMINATOR_5_IND DOUBLE Y Identifies if the encounter is in the denominator for metric 5
DENOMINATOR_6_IND DOUBLE Y Identifies if the encounter is in the denominator for metric 6
DENOMINATOR_7_IND DOUBLE Y Identifies if the encounter is in the denominator for metric 7
DENOMINATOR_8_IND DOUBLE Y Identifies if the encounter is in the denominator for metric 8
DENOMINATOR_9_IND DOUBLE Y Identifies if the encounter is in the denominator for metric 9
DEPRESSION_DX_DT_TM DATETIME Y time when depression was identified
DEPRESSION_DX_UTC_DT_TM DATETIME Y time when depression was identified normalized to GMT
DEPRESSION_IPOC_DT_TM DATETIME Y time when depression ipoc was ordered on the patient
DEPRESSION_IPOC_UTC_DT_TM DATETIME Y time when depression ipoc was ordered on the patient normalized to GMT
DEPRESSION_PROB_DT_TM DATETIME Y time when depression problem was identified
DEPRESSION_PROB_UTC_DT_TM DATETIME Y time when depression problem was identified normalized to GMT
DEPRESSION_TMFRM DOUBLE Y time frame between depression identified and depression ipoc should be give to the patient
DIAG_PRIMARY VARCHAR(255) Y The primary Diagnosis given to the Patient.
DISCHARGE_DT_TM DATETIME Y The date/time on which the patient was discharged.
DISCHARGE_REPORTING_IND DOUBLE Y Identifies if the Patient is Dicharged Within the Reporting Period.
DISCHARGE_UTC_DT_TM DATETIME Y The date/time on which the patient was discharged normalized to GMT.
DISCH_AMA_IND DOUBLE Y Identifies if the patient is Discharged against the Medical Advice
DISCH_LOC_FLAG DOUBLE Y Discharge Location Categorized as 1 - HOME 2 - SNF 3 - ACUTE 4 - LTAC 5 - HOSPICE 6 - GENERAL HOSPITAL 7 - ASSISTED LIVING 8 - OTHER
DISCH_SERV_FLAG DOUBLE Y Discharge Service Categorized as 1 - Certified home health agency services 2 -Medical house calls 3 - Home hospice 4 - Continuing palliative care by current team 5 - Continuing palliative care by another team 6 - Clinic-based palliative care 7 - Telemedicine 8 - No services 9 - Unknown
DISCH_TO_LOC VARCHAR(255) Y The Discharged to Location of the patient.
DNR_ORDER_DT_TM DATETIME Y The date/time DNR Order was documented for patient
DNR_ORDER_UTC_DT_TM DATETIME Y The date/time DNR Order was documented for patient normalized to GMT
DYSPNEA_SCORE DOUBLE Y identifies dyspnea score
DYSPNEA_SCORE_DT_TM DATETIME Y time when dyspnea score was identified
DYSPNEA_SCORE_UTC_DT_TM DATETIME Y time when dyspnea score was identified normalized to GMT
DYSP_ASCENDING_IND DOUBLE Y identifies if dyspnea score tool is acending
DYSP_IMPROVE_IND DOUBLE Y identifies iimprovement in dyspnea results
DYSP_IMPROVE_TMFRM DOUBLE Y dyspnea improvement time frame
DYSP_NON_PHARM_TREATMENT VARCHAR(255) Y documented non pharmacalogical treatment for dyspnea
DYSP_NON_PHARM_TREAT_IND DOUBLE Y identifies if non pharmacalogical treatment for dyspnea documented
DYSP_PHARM_TREATMENT VARCHAR(255) Y documented pharmacalogical treatment for dyspnea
DYSP_PHARM_TREAT_IND DOUBLE Y identifies if pharmacalogical treatment for dyspnea documented
DYSP_SCORE_CURRENT DOUBLE Y stores latest dyspnea score
DYSP_SCORE_CURRENT_DT_TM DATETIME Y time when current score was identified
DYSP_SCORE_CURRENT_UTC_DT_TM DATETIME Y time when current score was identified normalized to GMT
DYSP_SCORE_IND DOUBLE Y Identfies postive results of dyspnea screening documented
DYSP_SCORE_LAST DOUBLE Y stores last dyspnea score before current score
DYSP_SCORE_LAST_DT_TM DATETIME Y time when last score was identified
DYSP_SCORE_LAST_UTC_DT_TM DATETIME Y time when last score was identified 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.
D_REFER_PRSNL_ID DOUBLE N Identifies the final referring physician associated to the encounter during registration.
ED_CONSULT_CNT DOUBLE Y The total Number of PC Consults ordered while the Patient is in ED.
ED_TO_INPT_IND DOUBLE Y Indicates if the Patient is transferred from ED to Inpatient
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EVAL_START_DT_TM DATETIME Y time when evaluation was started
EVAL_START_UTC_DT_TM DATETIME Y time when evaluation was started normalized to GMT
EXCLUDE_10_IND DOUBLE Y Identifies if the encounter is in the exclude for metric 10
EXCLUDE_11_IND DOUBLE Y Identifies if the encounter is in the exclude for metric 11
EXCLUDE_12_IND DOUBLE Y Identifies if the encounter is in the exclude for metric 12
EXCLUDE_13_IND DOUBLE Y Identifies if the encounter is in the exclude for metric 13
EXCLUDE_14_IND DOUBLE Y Identifies if the encounter is in the exclude for metric 14
EXCLUDE_15_IND DOUBLE Y Identifies if the encounter is in the exclude for metric 15
EXCLUDE_16_IND DOUBLE Y Identifies if the encounter is in the exclude for metric 16
EXCLUDE_17_IND DOUBLE Y Identifies if the encounter is in the exclude for metric 17
EXCLUDE_37_IND DOUBLE Y Identifies if the encounter is in Excluded for metric of patients who screened positive for pain screening and received a clinical assessment.
EXCLUDE_3_IND DOUBLE Y Identifies if the encounter is in the exclude for metric 3
EXCLUDE_40_IND DOUBLE Y Identifies if the encounter is in Excluded for metric of patients with Transistion of care is documented and accompanied to Next Level of Care
EXCLUDE_4_IND DOUBLE Y Identifies if the encounter is in the exclude for metric 4
EXCLUDE_5_IND DOUBLE Y Identifies if the encounter is in the exclude for metric 5
EXCLUDE_6_IND DOUBLE Y Identifies if the encounter is in the exclude for metric 6
EXCLUDE_7_IND DOUBLE Y Identifies if the encounter is in the exclude for metric 7
EXCLUDE_8_IND DOUBLE Y Identifies if the encounter is in the exclude for metric 8
EXCLUDE_9_IND DOUBLE Y Identifies if the encounter is in the exclude for metric 9
EXPIRED_IND DOUBLE Y Identifies if the Patient is Expired or Not.
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FINANCIAL_NBR_TXT VARCHAR(100) 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.
FOLLOWUP_VISITS_CNT DOUBLE Y The total number of Consult orders given to the Patient.
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.
INIT_ENCNTR_ID DOUBLE N Stores the Encounter Id of the Initial Encounter for that Person.
INIT_POP_IND DOUBLE Y Common Population Indicator for the Palliative Care Metrics.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LENGTH_OF_STAY DOUBLE Y The total number of days that the patient was in the hospital.
LH_F_PC_METRICS_ID DOUBLE N unique generated number that identifies a single row on LH_F_PC_METRICS table
LIFE_PREFERENCE_IND DOUBLE Y identifies if life preference was documented on the patient
LIFE_PREF_DT_TM DATETIME Y Date/time Life Sustaining Preferences were documented
LIFE_PREF_TYPE VARCHAR(255) Y Type of Life Sustaining preferences documented
LIFE_PREF_UTC_DT_TM DATETIME Y Date/time Life Sustaining Preferences were documented normalized to GMT
LOC_AT_REFERRAL VARCHAR(255) Y The Location of the Patient at the time of Referral.
LOGICAL_DOMAIN_ID DOUBLE Y 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.
NOT_SEEN_IND DOUBLE Y Identifies the patients that were not able to be seen before discharge.
NPHARM_CHANGE_DT_TM DATETIME Y The date/time Non-Pharm Change was documented for patient
NPHARM_CHANGE_UTC_DT_TM DATETIME Y The date/time Non-Pharm Change was documented for patient normalized to GMT
NUMERATOR_10_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric 10
NUMERATOR_11_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric 11
NUMERATOR_12_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric 12
NUMERATOR_13_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric 13
NUMERATOR_14_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric 14
NUMERATOR_15_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric 15
NUMERATOR_16_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric 16
NUMERATOR_17_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric 17
NUMERATOR_18_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients for whom the palliative care consults were completed on the day of the referral(Same day)
NUMERATOR_19_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients for whom the palliative care consults were completed within 24 hours of the referral(Same day or next day)
NUMERATOR_1_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric 1
NUMERATOR_20_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients for whom the palliative care consults were completed on the day of their hospital admission(Same day)
NUMERATOR_21_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients for whom the palliative care consults were completed within 24 hours of their hospital admission(Same day or next day)
NUMERATOR_22_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients who expired within 2 days of palliative care referral.
NUMERATOR_23_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients with emotional or psychological needs documented before palliative care consulation
NUMERATOR_24_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients with emotional or psychological needs documented after palliative care consulation
NUMERATOR_25_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients with spiritual/religious needs documented before palliative care consulation
NUMERATOR_26_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients with spiritual/religious needs documented after palliative care consulation
NUMERATOR_29_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients with advanced directive documented before palliative care consulation
NUMERATOR_2_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric 2
NUMERATOR_30_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients with advanced directive documented after palliative care consulation
NUMERATOR_31_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients with DNR documented before palliative care consulation
NUMERATOR_32_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients with DNR documented after palliative care consulation
NUMERATOR_34_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients who has either Pharm change or Npharm change
NUMERATOR_35_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients who has a Full Code Status Change.
NUMERATOR_36_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients who were screened for pain during the initial encounter
NUMERATOR_37_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients who screened positive for pain screening and received a clinical assessment.
NUMERATOR_38_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients who were screened for dyspnea during the initial encounter.
NUMERATOR_39_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients with Medical Record Documentation of Treatment Preferences or Goals of Care
NUMERATOR_3_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric 3
NUMERATOR_40_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric of patients with Transistion of care is documented and accompanied to Next Level of Care
NUMERATOR_4_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric 4
NUMERATOR_5_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric 5
NUMERATOR_6_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric 6
NUMERATOR_7_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric 7
NUMERATOR_8_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric 8
NUMERATOR_9_IND DOUBLE Y Identifies if the encounter is in the Numerator for metric 9
NXT_INPT_DT_TM DATETIME Y Identifies the next admission date of an inpatient encounter.
NXT_INPT_UTC_DT_TM DATETIME Y Identifies the next admission date of an inpatient encounter normalized to GMT.
OBS_CONSULT_CNT DOUBLE Y The total Number of PC Consults ordered while the Patient is in Observation.
OBS_TO_INPT_IND DOUBLE Y Indicates if the Patient is transferred from Observation to Inpatient
ORG_MRN_TXT VARCHAR(100) Y Identifies the medical record number of the patient.
PAIN_ASCENDING_IND DOUBLE Y identifies if pain scale is ascending
PAIN_ASMT_CNT DOUBLE Y The Count of the Pain Assessments
PAIN_BEHAVIOR_REDUCED_IND DOUBLE Y identifies if pain behavior is reduced
PAIN_BEHAVIOR_RED_DT_TM DATETIME Y time when pain behavior reduced
PAIN_BEHAVIOR_RED_UTC_DT_TM DATETIME Y time when pain behavior reduced normalized to GMT
PAIN_CURRENT_DT_TM DATETIME Y Date/time when current pain score was documented
PAIN_CURRENT_UTC_DT_TM DATETIME Y Date/time when current pain score was documented normalized to GMT
PAIN_IMPROVEMENT_IND DOUBLE Y identifies if pain improved
PAIN_LAST_DT_TM DATETIME Y Date/time when last before cureent pain score was documented
PAIN_LAST_UTC_DT_TM DATETIME Y Date/time when last before current pain score was documented normalized to GMT
PAIN_NONPHARM_THERAPY VARCHAR(255) Y non pharmacalogical therapies documented for pain treatment
PAIN_NONPHARM_THER_DT_TM DATETIME Y time when non pharmacalogical therapy was given
PAIN_NONPHARM_THER_IND DOUBLE Y identifies if non pharmacalogical therapy was given
PAIN_NONPHARM_THER_UTC_DT_TM DATETIME Y time when non pharmacalogical therapy was given normalized to GMT
PAIN_NT_PRESENT_DT_TM DATETIME Y time when pain was inot dentified
PAIN_NT_PRESENT_IND DOUBLE Y identifies if pain is not present
PAIN_NT_PRESENT_UTC_DT_TM DATETIME Y time when pain was not identified normalized to GMT
PAIN_PHARM_THERAPY VARCHAR(255) Y pharmacalogical therapies documented for pain treatment
PAIN_PHARM_THER_DT_TM DATETIME Y time when pharmacalogical therapy was given
PAIN_PHARM_THER_IND DOUBLE Y identifies if pharmacalogical therapy was given
PAIN_PHARM_THER_UTC_DT_TM DATETIME Y time when pharmacalogical therapy was given normalized to GMT
PAIN_PRESENT_DT_TM DATETIME Y time when pain was identified
PAIN_PRESENT_IND DOUBLE Y identifies if pain is present
PAIN_PRESENT_UTC_DT_TM DATETIME Y time when pain was identified normalized to GMT
PAIN_SCORE_CURRENT DOUBLE Y Most recent pain score documented
PAIN_SCORE_LAST DOUBLE Y last pain score documented before current score
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility
PC_ACCEPTED_IND DOUBLE Y identifies if patient consents to Palliative care consult
PC_CHAPLAIN_DT_TM DATETIME Y time when chaplain was signed on the patient
PC_CHAPLAIN_IND DOUBLE Y identifies if chaplain was performed on the patient
PC_CHAPLAIN_UTC_DT_TM DATETIME Y time when chaplain was signed on the patient normalized to GMT
PC_CONSULT_ORD_DT_TM DATETIME Y time the pc order was given to the patient
PC_CONSULT_ORD_IND DOUBLE Y Identifies the inptient encounter has Palliative Care consultation Order given
PC_CONSULT_ORD_UTC_DT_TM DATETIME Y time the pc order was given to the patient normalized to GMT
PC_DOC_COMPLETE_DAYS DOUBLE Y days within which pc documentation was completed on the patient from the tme oc consult was identified
PC_DOC_INIT_TMFRM DOUBLE Y time frame within which the palliative care documentation was initialized
PC_DYSPNEA_SCREENING_TMFRM DOUBLE Y The Time frame for the Dyspnea Screening
PC_EDUCATION_DT_TM DATETIME Y time when PC education was given to the patient
PC_EDUCATION_IND DOUBLE Y identifies if education(Ad hoc charting) documented for encounter
PC_EDUCATION_TYPE VARCHAR(255) Y Type of education(Ad hoc charting) documented for encounter
PC_EDUCATION_UTC_DT_TM DATETIME Y time when PC education was given to the patient normalized to GMT
PC_EDU_INST_DT_TM DATETIME Y Date/time Patient Education Instructions were documented
PC_EDU_INST_IND DOUBLE Y identifies if patient education instruction documented for encounter
PC_EDU_INST_TYPE VARCHAR(255) Y Type of Education Instruction documented
PC_EDU_INST_UTC_DT_TM DATETIME Y Date/time Patient Education Instructions were documented normalized to GMT
PC_EVENT_IND DOUBLE Y Identifies the inptient encounter has Palliative Care consultation event performed
PC_GOALS_DISC_DT_TM DATETIME Y The date/time Goals of Care Discussion was documented for patient
PC_GOALS_DISC_IND DOUBLE Y Identifies if the Goals of Care Discussion was given or Not.
PC_GOALS_DISC_UTC_DT_TM DATETIME Y The date/time Goals of Care Discussion was documented for patient Normalized to GMT
PC_GOALS_DT_TM DATETIME Y Date/time Goals were documented
PC_GOALS_IND DOUBLE Y identifies if pc goals was documented on the patient
PC_GOALS_UTC_DT_TM DATETIME Y Date/time Goals were documented normalized to GMT
PC_IDT_COMP_DT_TM DATETIME Y time when pc idt was performed on the patient
PC_IDT_COMP_UTC_DT_TM DATETIME Y time when pc idt was performed normalized to GMT
PC_IDT_IND DOUBLE Y identifies if pc_idt was performed on the patient
PC_ID_ALGO_DT_TM DATETIME Y Date/time Patient Identification Agolrithm was documented
PC_ID_ALGO_UTC_DT_TM DATETIME Y Date/time Patient Identification Agolrithm was documented normalized to GMT
PC_JOINT_POP_IND DOUBLE Y The Population Indicator for the Joint Commission
PC_NON_PHARM_DT_TM DATETIME Y time when non pharm therapy was given to the patinet
PC_NON_PHARM_UTC_DT_TM DATETIME Y time when non pharm therapy was given to the patient normalized to GMT
PC_PAIN_SCREENING_TMFRM DOUBLE Y The Time Frame for the Pain Screening
PC_PAIN_TMFRM DOUBLE Y time between pain identified and therapy was done
PC_PFORM_DT_TM DATETIME Y time pc pform was performed on the patient
PC_PFORM_IND DOUBLE Y identified if pc_pform was performed on the patient
PC_PFORM_UTC_DT_TM DATETIME Y time pc pform was performed on the patient normalized to GMT
PC_PHARM_DT_TM DATETIME Y time when pharm therapy was given to the patient
PC_PHARM_UTC_DT_TM DATETIME Y time when pharm therapy was given to the patient normalized to GMT
PC_PHYS_ASSMNT_COMP_DT_TM DATETIME Y time when physical assessment was completed
PC_PHYS_ASSMNT_COMP_IND DOUBLE Y identifies if physical assessment was completed
PC_PHYS_ASSMNT_COMP_UTC_DT_TM DATETIME Y time when phsical assessment was completed normalized to GMT
PC_PHYS_ASSMNT_DT_TM DATETIME Y time physical assessment was done on the patient
PC_PHYS_ASSMNT_IND DOUBLE Y identifies if physical assessment was done
PC_PHYS_ASSMNT_UTC_DT_TM DATETIME Y time physical assessment was done on the patient normalized to GMT
PC_PNOTE_COMP_DT_TM DATETIME Y time when pnote was completed on the patient
PC_PNOTE_COMP_IND DOUBLE Y identifies if pnote was completed on the patient
PC_PNOTE_COMP_UTC_DT_TM DATETIME Y time when pnote was completed on the patient normalized to GMT
PC_PNOTE_DT_TM DATETIME Y time pnote was performed on the patient
PC_PNOTE_IND DOUBLE Y identifies if pnote was performed on the patient
PC_PNOTE_UTC_DT_TM DATETIME Y time pnote was performed on the patient normalized to GMT
PC_PROVIDER VARCHAR(255) Y Palliative Care Provider
PC_QUAL_LIFE_DT_TM DATETIME Y time quality of life IPOC was given to the patient
PC_QUAL_LIFE_IND DOUBLE Y identifes if quality of life IPOC was given to the patient
PC_QUAL_LIFE_UTC_DT_TM DATETIME Y time quality of life IPOC was given to the patient normalized to GMT
PC_READMIT_DAYS DOUBLE Y number of days between two encounters
PC_THERAPY_TMFRM DOUBLE Y timeframe between dyspnea identified and therapy was given to the patient
PC_TREAT_PREF_DC_DOC_DT_TM DATETIME Y The date/time Treatment Preferences Discharge Documentation was documented for patient
PC_TREAT_PREF_DC_DOC_IND DOUBLE Y Identifies if the Treatment Preferences Discharge Documentation was given or Not.
PC_TREAT_PREF_DC_DOC_UTC_DT_TM DATETIME Y The date/time Treatment Preferences Discharge Documentation was documented for patient Normalized to GMT
PC_TREAT_PREF_DISC_DT_TM DATETIME Y The date/time Treatment Preferences Discussion was documented for patient
PC_TREAT_PREF_DISC_IND DOUBLE Y Identifies if the Treatment Preferences Discussion was given or Not.
PC_TREAT_PREF_DISC_UTC_DT_TM DATETIME Y The date/time Treatment Preferences Discussion was documented for patient Normalized to GMT
PC_TREAT_PREF_DT_TM DATETIME Y The date/time Treatment Preferences Documentation was documented for patient
PC_TREAT_PREF_IND DOUBLE Y Identifies if the Treatment Preferences Documentation was given or Not.
PC_TREAT_PREF_UTC_DT_TM DATETIME Y The date/time Treatment Preferences Documentation was documented for patient Normalized to GMT
PED_SELF_SCORE_IND DOUBLE Y identifies if ped can self score pain
PED_UNABLE_IND DOUBLE Y identifies if ped cannot self score pain
PHARM_CHANGE_DT_TM DATETIME Y The date/time Pharm Change was documented for patient
PHARM_CHANGE_UTC_DT_TM DATETIME Y The date/time Pharm Change was documented for patient normalized to GMT
PLACE_OF_ORIGIN_IND DOUBLE Y Identifies if the Patient is Discharged to Place of Origin or Not.
POPULATION_IND DOUBLE Y Identifies the inptient encounter is qualified initial population for Palliative Care
POPULATION_OPS_IND DOUBLE Y Identifies if the inpatient encounter is qualified initial population for Palliative Care OPS Report.
PROB_PRIMARY VARCHAR(255) Y The primary Problem given to the Patinet.
PSYCH_NEEDS_DT_TM DATETIME Y The date/time psychological needs was documented for patient
PSYCH_NEEDS_UTC_DT_TM DATETIME Y The date/time psychological needs was documented for patient normalized to GMT
READMIT_30DAY_IND DOUBLE Y Identifies if the patient is redamitted to the hospital within 30 days.
RESUSCT_STATUS_TXT VARCHAR(255) Y The Code Status at the time of Palliative Care Consult.
SPIRIT_NEEDS_DT_TM DATETIME Y The date/time Spiritual needs was documented for patient
SPIRIT_NEEDS_UTC_DT_TM DATETIME Y The date/time Spiritual needs was documented for patient normalized to GMT
SURROGATE_DT_TM DATETIME Y Date/time Surrogate Decision Maker was documented
SURROGATE_IND DOUBLE Y identifies id surrogate was documented on the patient
SURROGATE_UTC_DT_TM DATETIME Y Date/time Surrogate Decision Maker was documented normalized to GMT
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(100) Y The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) Y 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_PC_METRICS


Child Column in LH_F_PC_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_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_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
D_REFER_PRSNL_ID LH_D_PERSONNEL D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID


LH_F_PEDS_MED_AD_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_PEDS_MED_AD_METRICS
Definition: Fact table for Pediatric Medication Adherence Lighthouse Report
Table Type: ACTIVITY





Column Detail - LH_F_PEDS_MED_AD_METRICS


Column Name Type Null? Definition
ACC_VERB_IND DOUBLE Y Identifies if the patient accurately verbalize med information prior to discharge
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.
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.
ADOLESCENT_AGE_IND DOUBLE Y Identifies if the patient age is >= X and <18 with adolescent low
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.
CHRON_ILL_IND DOUBLE Y Identifies if the patient with a order for chronic illness assessment adolescent
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.
DIS_PROC_IND DOUBLE Y Identifies if the patient with verbalized understanding of disease processd
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 during the visit.
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 Identifies the metric identifier for the Lighthouse metric.
D_METRIC_11_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_12_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_13_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_14_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_15_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_16_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_17_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_18_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_19_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_1_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_20_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_2_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_3_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_4_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_5_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_6_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_7_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_8_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_9_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_PERSON_ID DOUBLE N Identifies the person associated with the quality measure. Foreign key to the PERSON table.
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.
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.
F_PEDS_MED_AD_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_F_PEDS_MED_AD_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.
INT_AD_IND DOUBLE Y Identifies if the patient with interventions to improved adherence documented
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
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_AD_SCR_IND DOUBLE Y Identifies patients with medication adherence screening documented
MED_HIST_ADM_IND DOUBLE Y Identifies patients with Medication History documented on admission
MED_REG_DEF_IND DOUBLE Y Identifies patients with a problem of medication regimen deficit
MGMT_INEF_IND DOUBLE Y Identifies patients with home medications managed ineffectively documented
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
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 are less than 18 years old and 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
RED_BARRIERS_IND DOUBLE Y Identifies if the patient with a plan to reduce barriers interfering with med adherence
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_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.
VERB_MEDS_INAC_IND DOUBLE Y Identifies patients with home medications verbalized inaccurately documented



Relationship Detail - LH_F_PEDS_MED_AD_METRICS


Child Column in LH_F_PEDS_MED_AD_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_PEDS_PAIN_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_PEDS_PAIN_METRICS
Definition: Fact table for Pediatric Pain Lighthouse Report
Table Type: ACTIVITY





Column Detail - LH_F_PEDS_PAIN_METRICS


Column Name Type Null? Definition
ACCEPTABLE_PAIN_IND DOUBLE Y Identifies patients that had a plan with acceptable pain
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.
ADMIT_DT_TM DATETIME Y The date and time when the patient was admitted to the hospital
ADMIT_UTC_DT_TM DATETIME Y The date/time on which the patient was admitted; normalized to GMT.
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.
ASSESS_AGGRAVATING_FX_IND DOUBLE Y Identifies if the patient was screened for aggravating factors.
ASSESS_ALLEVIATING_FX_IND DOUBLE Y Identifies if the patient was screened for alleviating factors.
ASSESS_APPROP_IND DOUBLE Y Identifies the number of times the patient was properly assessed when self-reporting or unable to self report.
ASSESS_DEFINED_24H_IND DOUBLE Y Identifies if the patient had actual or suspected pain during their visit with a defined number of assessments every 24hrs
ASSESS_PAIN_24H_COMFORT_IND DOUBLE Y Identifies critical care patients with actual or suspected pain with a narcotic analgesic administration, and was assessed for comfort periodically
ASSESS_PAIN_4H_IND DOUBLE Y Identifies if the patient had actual or suspected pain and had at least 1 assessment every 4 hours
ASSESS_PAIN_4H_INTERVAL_IND DOUBLE Y Identifies if the patient had actual or suspected pain with at least one 4hr assessment opportunity
ASSESS_PAIN_8H_FLAG DOUBLE Y Identifies if the patient had actual or suspected pain within 8 hours of admission.0 = Patient did not have Pain Present, 1 = Time Difference < 8hrs, 2 = Time Difference >= 8hrs, 999 = Missing
ASSESS_PAIN_HX_FLAG DOUBLE Y Identifies if the patient was self-reporting or unable to self-report when being screened for pain history.1 = Self-reporting2 = Unable to Self-Report3 = Unable to obtain 999 = missing
ASSESS_SELF_INTENSITY_IND DOUBLE Y Identifies if the patient had actual or suspected pain during their visit with a self report pain assessment.
ASSESS_SELF_REPORT_IND DOUBLE Y Identifies if the patient was able to self-report pain tools
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
CRIT_CARE_NARCOTIC_ADM_IND DOUBLE Y Identifies critical care patients with actual or suspected pain with a narcotic analgesic administration.
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 Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_11_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_12_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_13_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_14_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_15_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_16_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_17_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_18_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_19_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_1_ID DOUBLE Y Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_20_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_2_ID DOUBLE Y Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_3_ID DOUBLE Y Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_4_ID DOUBLE Y Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_5_ID DOUBLE Y Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_6_ID DOUBLE Y Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_7_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_8_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_9_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_PERSON_ID DOUBLE N Identifies the person associated with the quality measure. Foreign key to the PERSON table.
D_PRIN_DIAGNOSIS_ID DOUBLE N Identifies the principle diagnosis associated with the encounter.
D_PRIN_PROCEDURE_ID DOUBLE N Describes the principle procedure that was performed during the patient visit.
EDUCATION_IND DOUBLE Y Identifies patients with actual or suspected pain that had pain management education documented.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXTRACT_DT_TM DATETIME Y The date/time that the program running the extracts was started. This field 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.
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.
F_PEDS_PAIN_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_F_PEDS_PAIN_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.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
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.
NSR_ASSESS_PAIN_HX_IND DOUBLE Y Identifies if the non self-reporting patient was completely screened for pain history.
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
PAIN_COMMUNICATED_IND DOUBLE Y Identifies if the patient's pain was communicated
PAIN_MGMT_PLAN_IND DOUBLE Y Identifies patients that had a plan
PAIN_PRESENT_IND DOUBLE Y Identifies if the patient had actual or suspected pain during their visit.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility
PLAN_INITIATED_IND DOUBLE Y Identifies patients that had a plan initiated within 24 hours of being identified with actual or suspected pain.
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
SR_ASSESS_PAIN_HX_IND DOUBLE Y Identifies if the self-reporting patient was completely screened for pain history.
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_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_PEDS_PAIN_METRICS


Child Column in LH_F_PEDS_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_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