Table Detail Report

LH_D_NURSE_UNIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_D_NURSE_UNIT
Definition: This table is used to store nurse unit reference data for the lighthouse quality metrics.
Table Type: REFERENCE





Column Detail - LH_D_NURSE_UNIT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
D_BUILDING_ID DOUBLE Y Identifies the building associated with the nurse unit. Foreign key to the LH_D_BUILDING table.
D_FACILITY_ID DOUBLE Y Identifies the facility associated with the nurse unit. Foreign key to the LH_D_FACILITY table.
D_NURSE_UNIT_ID DOUBLE N Unique identifier for a nurse unit.
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 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.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
LOC_NURSE_UNIT_CD DOUBLE Y Identifies the nurse unit associated with the quality measure. Foreign key to the code_value table for code set 220.
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.
NURSE_UNIT_DESCRIPTION VARCHAR(40) Y The description of the nurse unit.
NURSE_UNIT_DISPLAY VARCHAR(40) Y The display value for the nurse unit.
NURSE_UNIT_MEANING VARCHAR(40) Y The Cerner-defined meaning for the nurse unit.
PROCESS_DT_TM DATETIME Y The date/time the record was first loaded into the table.
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) 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_D_NURSE_UNIT


Child Column in LH_D_NURSE_UNIT(FK) Parent Table Name Parent Column Name
Parents: D_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID




Parent Column in LH_D_NURSE_UNIT (PK) Child Table Name Child Column Name
Children: D_NURSE_UNIT_ID LH_ABS_AMI_METRICS D_ADMIT_NURSE_UNIT_ID
LH_ABS_AMI_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_AMI_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_AMI_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_CAC_METRICS D_ADMIT_NURSE_UNIT_ID
LH_ABS_CAC_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_CAC_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_CAC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_CSTK02_METRICS D_ADMIT_NURSE_UNIT_ID
LH_ABS_CSTK02_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_CSTK02_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_CSTK02_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_ED_METRICS D_ADMIT_NURSE_UNIT_ID
LH_ABS_ED_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_ED_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_ED_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_HBIPS_DISC_METRICS D_ADMIT_NURSE_UNIT_ID
LH_ABS_HBIPS_DISC_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HBIPS_DISC_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_HBIPS_DISC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_HBIPS_EVNT_METRICS D_EVENT_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HBIPS_EVNT_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_HBIPS_PATIENTS D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HBIPS_PATIENTS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_HBIPS_PATIENTS_INFO D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HBIPS_PATIENTS_INFO HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_HF_METRICS D_ADMIT_NURSE_UNIT_ID
LH_ABS_HF_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HF_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_HF_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_HOQR_AMI_METRICS D_ADMIT_NURSE_UNIT_ID
LH_ABS_HOQR_AMI_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HOQR_AMI_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_HOQR_AMI_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_HOQR_CATA_METRICS D_ADMIT_NURSE_UNIT_ID
LH_ABS_HOQR_CATA_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HOQR_CATA_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_HOQR_CATA_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_HOQR_CP_METRICS D_ADMIT_NURSE_UNIT_ID
LH_ABS_HOQR_CP_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HOQR_CP_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_HOQR_CP_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_HOQR_EBRT_METRICS D_ADMIT_NURSE_UNIT_ID
LH_ABS_HOQR_EBRT_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HOQR_EBRT_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_HOQR_EBRT_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_HOQR_ED_METRICS D_ADMIT_NURSE_UNIT_ID
LH_ABS_HOQR_ED_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HOQR_ED_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_HOQR_ED_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_HOQR_END29_METRICS D_ADMIT_NURSE_UNIT_ID
LH_ABS_HOQR_END29_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HOQR_END29_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_HOQR_END29_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_HOQR_END30_METRICS D_ADMIT_NURSE_UNIT_ID
LH_ABS_HOQR_END30_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HOQR_END30_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_HOQR_END30_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_HOQR_PM_METRICS D_ADMIT_NURSE_UNIT_ID
LH_ABS_HOQR_PM_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HOQR_PM_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_HOQR_PM_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_HOQR_STK_METRICS D_ADMIT_NURSE_UNIT_ID
LH_ABS_HOQR_STK_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HOQR_STK_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_HOQR_STK_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_HOQR_SURG_METRICS D_ADMIT_NURSE_UNIT_ID
LH_ABS_HOQR_SURG_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HOQR_SURG_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_HOQR_SURG_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_IMM_METRICS D_ADMIT_NURSE_UNIT_ID
LH_ABS_IMM_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_IMM_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_IMM_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_PC_BF_METRICS D_ADMIT_NURSE_UNIT_ID
LH_ABS_PC_BF_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_PC_BF_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_PC_BF_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_PC_BSI_METRICS D_ADMIT_NURSE_UNIT_ID
LH_ABS_PC_BSI_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_PC_BSI_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_PC_BSI_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_PC_MOTHER_METRICS D_ADMIT_NURSE_UNIT_ID
LH_ABS_PC_MOTHER_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_PC_MOTHER_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_PC_MOTHER_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_PC_UNC_METRICS D_ADMIT_NURSE_UNIT_ID
LH_ABS_PC_UNC_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_PC_UNC_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_PC_UNC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_PN_METRICS D_ADMIT_NURSE_UNIT_ID
LH_ABS_PN_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_PN_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_PN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_SCIP_METRICS D_ADMIT_NURSE_UNIT_ID
LH_ABS_SCIP_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_SCIP_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_SCIP_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_SMD_METRICS D_ADMIT_NURSE_UNIT_ID
LH_ABS_SMD_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_SMD_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_SMD_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_STK_OP_METRICS D_ADMIT_NURSE_UNIT_ID
LH_ABS_STK_OP_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_STK_OP_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_STK_OP_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_STROKE_METRICS D_ADMIT_NURSE_UNIT_ID
LH_ABS_STROKE_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_STROKE_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_STROKE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_SUB_METRICS D_ADMIT_NURSE_UNIT_ID
LH_ABS_SUB_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_SUB_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_SUB_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_TOB_METRICS D_ADMIT_NURSE_UNIT_ID
LH_ABS_TOB_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_TOB_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_TOB_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_TR_METRICS D_ADMIT_NURSE_UNIT_ID
LH_ABS_TR_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_TR_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_TR_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_ABS_VTE_METRICS D_ADMIT_NURSE_UNIT_ID
LH_ABS_VTE_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_VTE_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_VTE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_EH_HCO_ISSUE D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_EH_HCO_ISSUE HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_EH_QRDA_ISSUE D_ADMIT_NURSE_UNIT_ID
LH_EH_QRDA_ISSUE D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_EH_QRDA_ISSUE HEALTH_SYSTEM_SOURCE_ID
LH_EH_QRDA_ISSUE HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_AMI_2017_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_AMI_2017_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_AMI_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_AMI_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_AMI_2018_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_AMI_2018_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_AMI_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_AMI_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_AMI_2019_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_AMI_2019_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_AMI_2019_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_AMI_2019_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_AMI_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_AMI_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_AMI_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_AMI_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_APHYBD_2024_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_APHYBD_2024_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_APHYBD_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_APHYBD_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_CAC_2017_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_CAC_2017_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_CAC_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_CAC_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_CAC_2018_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_CAC_2018_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_CAC_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_CAC_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_CAC_2019_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_CAC_2019_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_CAC_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_CAC_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_CAC_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_CAC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_ED_2016_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_ED_2016_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2016_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_ED_2016_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_ED_2017_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_ED_2017_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_ED_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_ED_2018_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_ED_2018_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_ED_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_ED_2019_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_ED_2019_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2019_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_ED_2019_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_ED_2020_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_ED_2020_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2020_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_ED_2020_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_ED_2021_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_ED_2021_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_ED_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_ED_2022_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_ED_2022_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_ED_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_ED_2023_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_ED_2023_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_ED_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_ED_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_ED_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_ED_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_EHDI_2017_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_EHDI_2017_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_EHDI_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_EHDI_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_EHDI_2018_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_EHDI_2018_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_EHDI_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_EHDI_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_EHDI_2019_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_EHDI_2019_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_GMCS_2024_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_GMCS_2024_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_GMCS_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_GMCS_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_HEARING_SCREEN_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_HEARING_SCREEN_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HEARING_SCREEN_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_HEARING_SCREEN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_HH_2023_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_HH_2023_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HH_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_HH_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_HH_2024_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_HH_2024_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HH_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_HH_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_HTN_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_HTN_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HTN_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_HTN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_HWR_2018_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_HWR_2018_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HWR_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_HWR_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_HWR_2021_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_HWR_2021_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HWR_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_HWR_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_HYBRID_2022_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_HYBRID_2022_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HYBRID_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_HYBRID_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_HYBRID_2023_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_HYBRID_2023_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HYBRID_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_HYBRID_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_HYBRID_2024_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_HYBRID_2024_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HYBRID_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_HYBRID_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_OPIOID_2021_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_OPIOID_2021_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_OPIOID_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_OPIOID_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_OPIOID_2022_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_OPIOID_2022_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_OPIOID_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_OPIOID_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_OPIOID_2023_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_OPIOID_2023_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_OPIOID_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_OPIOID_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_OPIOID_2024_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_OPIOID_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_ORAE_2024_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_ORAE_2024_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ORAE_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_ORAE_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_PCB_2020_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_PCB_2020_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCB_2020_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_PCB_2020_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_PCB_2021_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_PCB_2021_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCB_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_PCB_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_PCB_2022_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_PCB_2022_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCB_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_PCB_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_PCB_2023_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_PCB_2023_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCB_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_PCB_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_PCB_2024_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_PCB_2024_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCB_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_PCB_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_PCM_2020_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_PCM_2020_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCM_2020_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_PCM_2020_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_PCM_2021_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_PCM_2021_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCM_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_PCM_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_PCM_2022_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_PCM_2022_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCM_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_PCM_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_PCM_2023_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_PCM_2023_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCM_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_PCM_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_PCM_2024_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_PCM_2024_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCM_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_PCM_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_PC_2016_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_PC_2016_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PC_2016_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_PC_2016_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_PC_2017_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_PC_2017_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PC_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_PC_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_PC_2018_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_PC_2018_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PC_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_PC_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_PC_2019_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_PC_2019_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PC_2019_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_PC_2019_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_PC_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_PC_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PC_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_PC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_PN_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_PN_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PN_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_PN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_SCIP_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_SCIP_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_SCIP_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_SCIP_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_STEMI_2023_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_STEMI_2023_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STEMI_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_STEMI_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_STEMI_2024_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_STEMI_2024_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STEMI_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_STEMI_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_STROKE_2016_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_STROKE_2016_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2016_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_STROKE_2016_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_STROKE_2017_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_STROKE_2017_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_STROKE_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_STROKE_2018_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_STROKE_2018_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_STROKE_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_STROKE_2019_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2019_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_STROKE_2020_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_STROKE_2020_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2020_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_STROKE_2020_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_STROKE_2021_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_STROKE_2021_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_STROKE_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_STROKE_2022_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_STROKE_2022_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_STROKE_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_STROKE_2023_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_STROKE_2023_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_STROKE_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_STROKE_2024_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_STROKE_2024_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_STROKE_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_STROKE_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_STROKE_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_STROKE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_VTE_2016_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_VTE_2016_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2016_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_VTE_2016_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_VTE_2017_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_VTE_2017_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_VTE_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_VTE_2018_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_VTE_2018_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_VTE_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_VTE_2019_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2019_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_VTE_2020_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_VTE_2020_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2020_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_VTE_2020_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_VTE_2021_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_VTE_2021_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_VTE_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_VTE_2022_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_VTE_2022_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_VTE_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_VTE_2023_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_VTE_2023_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_VTE_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_VTE_2024_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_VTE_2024_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_VTE_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_E_VTE_METRICS D_ADMIT_NURSE_UNIT_ID
LH_E_VTE_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_E_VTE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_ACT_INTOL_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_ACT_INTOL_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_ACT_INTOL_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_ACT_INTOL_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_ACUTE_PAIN_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_ACUTE_PAIN_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_ACUTE_PAIN_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_ACUTE_PAIN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_AMI_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_AMI_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_AMI_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_AMI_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_ANEMIA_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_ANEMIA_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_ANEMIA_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_ANEMIA_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_CAC_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_CAC_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_CAC_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_CAC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_CHF_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_CHF_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_CHF_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_CHF_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_CRI_CE_METRICS D_CRI_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_CRI_CE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_CRI_ENCNTR_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_CRI_ENCNTR_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_CRI_ENCNTR_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_CRI_ENCNTR_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_DELIRIUM_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_DELIRIUM_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_DELIRIUM_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_DELIRIUM_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_DEPRESSION_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_DEPRESSION_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_DEPRESSION_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_DEPRESSION_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_DYSPHAGIA_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_DYSPHAGIA_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_DYSPHAGIA_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_DYSPHAGIA_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_FALLS_DTL_METRICS D_FALL_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_FALLS_DTL_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_FALLS_HST_METRICS D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_FALLS_HST_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_FALLS_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_FALLS_METRICS D_DISCHARGE_NURSE_UNIT_ID
LH_F_FALLS_METRICS D_FIRST_FALL_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_FALLS_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_FALLS_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_FALLS_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_FVE_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_FVE_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_FVE_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_FVE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_GLYCEMIC_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_GLYCEMIC_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_GLYCEMIC_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_GLYCEMIC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_HAPU_DTL_METRICS D_HAPU_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_HAPU_DTL_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_HAPU_HST_METRICS D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_HAPU_HST_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_HAPU_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_HAPU_METRICS D_DISCHARGE_NURSE_UNIT_ID
LH_F_HAPU_METRICS D_FIRST_HAPU_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_HAPU_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_HAPU_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_HAPU_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_HH_METRICS D_OBSRV_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_HH_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_HOP_AMI_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_HOP_AMI_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_HOP_AMI_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_HOP_AMI_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_HOP_SURG_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_HOP_SURG_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_HOP_SURG_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_HOP_SURG_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_IC_ANTIBGRM_METRICS D_COLL_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_IC_ANTIBGRM_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_IC_HAI_ENCNTR_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_IC_HAI_ENCNTR_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_IC_HAI_ENCNTR_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_IC_HAI_ENCNTR_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_IC_MDRO_DTL_METRICS D_COLL_NURSE_UNIT_ID
LH_F_IC_MDRO_DTL_METRICS D_COLL_PREV_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_IC_MDRO_DTL_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_IC_MDRO_DTL_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_IC_MDRO_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_IC_MDRO_METRICS D_DISCHARGE_NURSE_UNIT_ID
LH_F_IC_MDRO_METRICS D_PREV_DISCH_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_IC_MDRO_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_IC_MDRO_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_IC_MDRO_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_LHHF_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_LHHF_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_LHHF_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_LHHF_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_LIPID_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_LIPID_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_LIPID_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_LIPID_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_MED_AD_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_MED_AD_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_MED_AD_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_MED_AD_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_MOD_SEDATION_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_MOD_SEDATION_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_MOD_SEDATION_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_MOD_SEDATION_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_NHIQM_VTE_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_NHIQM_VTE_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_NHIQM_VTE_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_NHIQM_VTE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_PAIN_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_PAIN_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_PAIN_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_PAIN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_PC_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_PC_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_PC_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_PC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_PEDS_MED_AD_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_PEDS_MED_AD_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_PEDS_MED_AD_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_PEDS_MED_AD_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_PEDS_PAIN_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_PEDS_PAIN_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_PEDS_PAIN_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_PEDS_PAIN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_PEDS_SKIN_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_PEDS_SKIN_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_PEDS_SKIN_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_PEDS_SKIN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_PN_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_PN_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_PN_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_PN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_READMISSION_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_READMISSION_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_READMISSION_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_READMISSION_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_READMIT_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_READMIT_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_READMIT_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_READMIT_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_REST_DTL_METRICS D_REST_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_REST_DTL_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_REST_HST_METRICS D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_REST_HST_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_REST_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_REST_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_REST_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_REST_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_RRT_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_RRT_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_RRT_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_RRT_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_SCIP_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_SCIP_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_SCIP_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_SCIP_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_SEPSIS_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_SEPSIS_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_SEPSIS_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_SEPSIS_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_SEPSIS_PD_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_SEPSIS_PD_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_SEPSIS_PD_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_SEPSIS_PD_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_SEPSIS_RT_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_SEPSIS_RT_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_SEPSIS_RT_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_SEPSIS_RT_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_STROKE_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_STROKE_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_STROKE_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_STROKE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_UI_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_UI_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_UI_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_UI_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_F_VTE_METRICS D_ADMIT_NURSE_UNIT_ID
LH_F_VTE_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_VTE_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_VTE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_MU_FX_2_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_MU_FX_2_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_MU_FX_3_ORD_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_MU_FX_3_ORD_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_MU_FX_3_POP_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_MU_FX_3_POP_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_MU_FX_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_MU_FX_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_SDOH_METRICS D_DISCHARGE_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_SDOH_METRICS HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_THA_TKA_METRICS D_DISCH_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_THA_TKA_METRICS HEALTH_SYSTEM_SOURCE_ID


LH_D_PERSON



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_D_PERSON
Definition: This table is used to store person reference data for the lighthouse quality metrics.
Table Type: ACTIVITY





Column Detail - LH_D_PERSON


Column Name Type Null? Definition
ABS_BIRTH_DT_TM DATETIME Y The birth date/time "as entered" during registration. The date/time data in this field is "local" when the database is running in "UTC mode" and it is typically not populated (NULL) when the database is running in "local mode." This field is used for querying purposes only and helps eliminate edge cases where records fail to qualify because the user performing the search is in a different time zone.
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
BIRTH_DT_TM DATETIME Y The date/time on which the patient was born.
BIRTH_TZ DOUBLE Y This field specifies the time zone of the person's birth date time.
DECEASED_DT_TM DATETIME Y The date/time that the patient expired.
DECEASED_UTC_DT_TM DATETIME Y The date/time that the patient expired in GMT.
D_PERSON_ID DOUBLE N Unique identifier for a person.
EMAIL_ADDR VARCHAR(100) Y The e-mail address of the person.
EMAIL_IMPORT_IND DOUBLE Y Indicates that the e-mail address was imported rather than from Millennium. 1 - Imported
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.
ETHNIC_GROUP_DISPLAY VARCHAR(40) Y The display value for the ethnic group of the patient.
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.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
HOME_CITY VARCHAR(100) Y Identifies the home address of the patient.
HOME_COUNTY VARCHAR(100) Y Identifies the home address of the patient.
HOME_STATE VARCHAR(100) Y Identifies the home address of the patient.
HOME_STREET_ADDR1 VARCHAR(100) Y Identifies the home address of the patient.
HOME_STREET_ADDR2 VARCHAR(100) Y Identifies the home address of the patient.
HOME_STREET_ADDR3 VARCHAR(100) Y Identifies the home address of the patient.
HOME_STREET_ADDR4 VARCHAR(100) Y Identifies the home address of the patient.
HOME_ZIPCODE VARCHAR(25) Y Identifies the home address of the patient.
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.
NAME_FIRST VARCHAR(100) Y The first name of the patient.
NAME_FULL VARCHAR(100) Y The full name of the patient.
NAME_LAST VARCHAR(100) Y The last name of the patient.
NAME_MIDDLE VARCHAR(100) Y the middle name of the patient.
NATIONAL_IDENT_TXT VARCHAR(50) Y The national identifier associated with the patient. In the United States this is the Social Security Number.
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
PERSON_ID DOUBLE Y Identifies the person associated with the quality measure. Foreign key to the PERSON table.
PHONE_IMPORT_IND DOUBLE Y Indicates that the phone number was imported rather than from Millennium. 1 - Imported
PHONE_NUM VARCHAR(100) Y The phone number of the person.
PROCESS_DT_TM DATETIME Y The date/time the record was first loaded into the table.
RACE_DISPLAY VARCHAR(50) Y The display value for the race of the patient.
SEX_DISPLAY VARCHAR(40) Y The display value for the gender of the patient.
SEX_MEANING VARCHAR(40) Y The cdf_meaning for the gender of the patient.
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) 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_D_PERSON




Parent Column in LH_D_PERSON (PK) Child Table Name Child Column Name
Children: D_PERSON_ID LH_ABS_AMI_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_AMI_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_CAC_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_CAC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_CSTK02_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_CSTK02_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_ED_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_ED_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_HBIPS_DISC_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HBIPS_DISC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_HBIPS_EVNT_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HBIPS_EVNT_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_HBIPS_PATIENTS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HBIPS_PATIENTS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_HF_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HF_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_HOQR_AMI_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HOQR_AMI_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_HOQR_CATA_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HOQR_CATA_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_HOQR_CP_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HOQR_CP_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_HOQR_EBRT_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HOQR_EBRT_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_HOQR_ED_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HOQR_ED_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_HOQR_END29_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HOQR_END29_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_HOQR_END30_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HOQR_END30_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_HOQR_PM_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HOQR_PM_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_HOQR_STK_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HOQR_STK_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_HOQR_SURG_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HOQR_SURG_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_IMM_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_IMM_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_PC_BF_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_PC_BF_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_PC_BSI_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_PC_BSI_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_PC_MOTHER_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_PC_MOTHER_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_PC_UNC_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_PC_UNC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_PN_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_PN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_SCIP_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_SCIP_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_SMD_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_SMD_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_STK_OP_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_STK_OP_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_STROKE_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_STROKE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_SUB_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_SUB_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_TOB_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_TOB_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_TR_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_TR_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_ABS_VTE_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_VTE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_AMB_QUAL_ENCNTR D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_AMB_QUAL_ENCNTR HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_AMB_QUAL_ENCNTR_2016 D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_AMB_QUAL_ENCNTR_2016 HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_AMB_QUAL_ENCNTR_2017 D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_AMB_QUAL_ENCNTR_2017 HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_AMB_QUAL_ENCNTR_2018 D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_AMB_QUAL_ENCNTR_2018 HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_AMB_QUAL_ENCNTR_2019 D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_AMB_QUAL_ENCNTR_2019 HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_AMB_QUAL_ENCNTR_2020 D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_AMB_QUAL_ENCNTR_2020 HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_AMB_QUAL_ENCNTR_2021 D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_AMB_QUAL_ENCNTR_2021 HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_AMB_QUAL_ENCNTR_2022 D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_AMB_QUAL_ENCNTR_2022 HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_EH_QRDA_ISSUE D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_EH_QRDA_ISSUE HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_AMI_2017_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_AMI_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_AMI_2018_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_AMI_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_AMI_2019_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_AMI_2019_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_AMI_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_AMI_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_APHYBD_2024_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_APHYBD_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_CAC_2017_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_CAC_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_CAC_2018_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_CAC_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_CAC_2019_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_CAC_2019_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_CAC_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_CAC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_ED_2016_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2016_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_ED_2017_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_ED_2018_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_ED_2019_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2019_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_ED_2020_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2020_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_ED_2021_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_ED_2022_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_ED_2023_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_ED_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_EHDI_2017_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_EHDI_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_EHDI_2018_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_EHDI_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_EHDI_2019_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_EHDI_2019_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_GMCS_2024_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_GMCS_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_HEARING_SCREEN_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HEARING_SCREEN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_HH_2023_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HH_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_HH_2024_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HH_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_HTN_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HTN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_HWR_2018_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HWR_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_HWR_2021_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HWR_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_HYBRID_2022_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HYBRID_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_HYBRID_2023_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HYBRID_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_HYBRID_2024_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HYBRID_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_OPIOID_2021_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_OPIOID_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_OPIOID_2022_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_OPIOID_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_OPIOID_2023_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_OPIOID_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_OPIOID_2024_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_OPIOID_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_ORAE_2024_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ORAE_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_PCB_2020_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCB_2020_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_PCB_2021_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCB_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_PCB_2022_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCB_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_PCB_2023_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCB_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_PCB_2024_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCB_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_PCM_2020_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCM_2020_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_PCM_2021_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCM_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_PCM_2022_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCM_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_PCM_2023_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCM_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_PCM_2024_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCM_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_PC_2016_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PC_2016_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_PC_2017_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PC_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_PC_2018_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PC_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_PC_2019_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PC_2019_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_PC_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_PN_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_SCIP_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_SCIP_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_STEMI_2023_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STEMI_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_STEMI_2024_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STEMI_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_STROKE_2016_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2016_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_STROKE_2017_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_STROKE_2018_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_STROKE_2019_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2019_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_STROKE_2020_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2020_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_STROKE_2021_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_STROKE_2022_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_STROKE_2023_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_STROKE_2024_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_STROKE_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_VTE_2016_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2016_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_VTE_2017_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_VTE_2018_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_VTE_2019_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2019_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_VTE_2020_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2020_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_VTE_2021_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_VTE_2022_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_VTE_2023_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_VTE_2024_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_E_VTE_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_ACT_INTOL_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_ACT_INTOL_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_ACUTE_PAIN_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_ACUTE_PAIN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_AMI_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_AMI_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_ANEMIA_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_ANEMIA_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_CAC_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_CAC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_CHF_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_CHF_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_CRI_ENCNTR_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_CRI_ENCNTR_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_DELIRIUM_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_DELIRIUM_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_DEPRESSION_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_DEPRESSION_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_DYSPHAGIA_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_DYSPHAGIA_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_FALLS_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_FALLS_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_FVE_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_FVE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_GLYCEMIC_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_GLYCEMIC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_HAPU_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_HAPU_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_HH_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_HH_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_HOP_AMI_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_HOP_AMI_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_HOP_SURG_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_HOP_SURG_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_IC_MDRO_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_IC_MDRO_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_IC_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_IC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_LHHF_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_LHHF_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_LIPID_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_LIPID_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_MED_AD_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_MED_AD_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_MOD_SEDATION_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_MOD_SEDATION_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_NHIQM_VTE_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_NHIQM_VTE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_PAIN_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_PAIN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_PC_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_PC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_PEDS_MED_AD_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_PEDS_MED_AD_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_PEDS_PAIN_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_PEDS_PAIN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_PEDS_SKIN_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_PEDS_SKIN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_PN_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_PN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_READMISSION_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_READMISSION_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_READMIT_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_READMIT_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_REST_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_REST_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_RRT_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_RRT_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_SCIP_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_SCIP_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_SEPSIS_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_SEPSIS_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_SEPSIS_PD_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_SEPSIS_PD_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_SEPSIS_RT_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_SEPSIS_RT_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_STROKE_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_STROKE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_UI_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_UI_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_F_VTE_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_VTE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_MU_FX_2_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_MU_FX_2_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_MU_FX_3_ORD_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_MU_FX_3_ORD_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_MU_FX_3_POP_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_MU_FX_3_POP_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_QRDA_EC D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_QRDA_EC HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_SDOH_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_SDOH_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_THA_TKA_METRICS D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_THA_TKA_METRICS HEALTH_SYSTEM_SOURCE_ID


LH_D_PERSONNEL



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_D_PERSONNEL
Definition: This table is used to store personnel reference data for the lighthouse quality metrics.
Table Type: REFERENCE





Column Detail - LH_D_PERSONNEL


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
D_PRSNL_ID DOUBLE N Unique identifier for a personnel record.
EMAIL VARCHAR(100) Y Cerner system E-MAIL identifier for the personnel.
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 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.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
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.
NAME_FIRST VARCHAR(100) Y The first name for the personnel.
NAME_FULL VARCHAR(100) Y The full name for the personnel.
NAME_LAST VARCHAR(100) Y The last name for the personnel.
NAME_MIDDLE VARCHAR(100) Y The middle name for the personnel.
PERSON_ID DOUBLE Y Identifies personnel associated with the quality measure. Foreign key to the PRSNL table.
PROCESS_DT_TM DATETIME Y The date/time the record was first loaded into the table.
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) 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.
USERNAME VARCHAR(50) Y The Millennium username for the person.



Relationship Detail - LH_D_PERSONNEL




Parent Column in LH_D_PERSONNEL (PK) Child Table Name Child Column Name
Children: D_PRSNL_ID LH_ABS_AMI_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_AMI_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_ABS_CAC_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_CAC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_ABS_CSTK02_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_CSTK02_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_ABS_ED_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_ED_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_ABS_HBIPS_DISC_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HBIPS_DISC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_ABS_HBIPS_EVNT_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HBIPS_EVNT_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_ABS_HF_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HF_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_ABS_HOQR_AMI_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HOQR_AMI_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_ABS_HOQR_CATA_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HOQR_CATA_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_ABS_HOQR_CP_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HOQR_CP_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_ABS_HOQR_EBRT_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HOQR_EBRT_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_ABS_HOQR_ED_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HOQR_ED_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_ABS_HOQR_END29_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HOQR_END29_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_ABS_HOQR_END30_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HOQR_END30_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_ABS_HOQR_PM_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HOQR_PM_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_ABS_HOQR_STK_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HOQR_STK_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_ABS_HOQR_SURG_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_HOQR_SURG_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_ABS_IMM_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_IMM_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_ABS_PC_BF_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_PC_BF_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_ABS_PC_BSI_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_PC_BSI_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_ABS_PC_MOTHER_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_PC_MOTHER_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_ABS_PN_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_PN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_ABS_SCIP_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_SCIP_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_ABS_SMD_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_SMD_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_ABS_STK_OP_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_STK_OP_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_ABS_STROKE_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_STROKE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_ABS_SUB_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_SUB_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_ABS_TOB_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_TOB_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_ABS_TR_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_TR_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_ABS_VTE_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_VTE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_AMI_2017_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_AMI_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_AMI_2018_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_AMI_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_AMI_2019_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_AMI_2019_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_AMI_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_AMI_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_APHYBD_2024_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_APHYBD_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_CAC_2017_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_CAC_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_CAC_2018_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_CAC_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_CAC_2019_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_CAC_2019_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_CAC_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_CAC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_ED_2016_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2016_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_ED_2017_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_ED_2018_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_ED_2019_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2019_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_ED_2020_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2020_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_ED_2021_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_ED_2022_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_ED_2023_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_ED_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_EHDI_2017_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_EHDI_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_EHDI_2018_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_EHDI_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_EHDI_2019_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_EHDI_2019_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_GMCS_2024_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_GMCS_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_HEARING_SCREEN_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HEARING_SCREEN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_HH_2023_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HH_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_HH_2024_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HH_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_HTN_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HTN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_HWR_2018_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HWR_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_HWR_2021_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HWR_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_HYBRID_2022_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HYBRID_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_HYBRID_2023_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HYBRID_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_HYBRID_2024_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HYBRID_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_OPIOID_2021_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_OPIOID_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_OPIOID_2022_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_OPIOID_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_OPIOID_2023_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_OPIOID_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_OPIOID_2024_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_OPIOID_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_ORAE_2024_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ORAE_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_PCB_2020_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCB_2020_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_PCB_2021_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCB_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_PCB_2022_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCB_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_PCB_2023_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCB_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_PCB_2024_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCB_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_PCM_2020_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCM_2020_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_PCM_2021_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCM_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_PCM_2022_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCM_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_PCM_2023_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCM_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_PCM_2024_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCM_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_PC_2016_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PC_2016_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_PC_2017_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PC_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_PC_2018_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PC_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_PC_2019_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PC_2019_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_PC_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_PN_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_SCIP_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_SCIP_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_STEMI_2023_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STEMI_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_STEMI_2024_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STEMI_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_STROKE_2016_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2016_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_STROKE_2017_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_STROKE_2018_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_STROKE_2019_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2019_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_STROKE_2020_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2020_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_STROKE_2021_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_STROKE_2022_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_STROKE_2023_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_STROKE_2024_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_STROKE_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_VTE_2016_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2016_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_VTE_2017_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_VTE_2018_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_VTE_2019_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2019_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_VTE_2020_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2020_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_VTE_2021_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_VTE_2022_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_VTE_2023_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_VTE_2024_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_E_VTE_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_ACT_INTOL_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_ACT_INTOL_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_ACUTE_PAIN_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_ACUTE_PAIN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_AMI_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_AMI_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_ANEMIA_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_ANEMIA_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_CAC_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_CAC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_CHF_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_CHF_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_DELIRIUM_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_DELIRIUM_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_DEPRESSION_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_DEPRESSION_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_DYSPHAGIA_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_DYSPHAGIA_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_FALLS_DTL_METRICS D_FALL_DOCU_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_FALLS_DTL_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_FVE_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_FVE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_GLYCEMIC_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_GLYCEMIC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_HAPU_DTL_METRICS D_HAPU_DOCU_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_HAPU_DTL_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_HH_METRICS D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_HH_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_HOP_AMI_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_HOP_AMI_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_HOP_SURG_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_HOP_SURG_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_IC_MDRO_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_IC_MDRO_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_LHHF_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_LHHF_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_LIPID_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_LIPID_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_MED_AD_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_MED_AD_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_MOD_SEDATION_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_MOD_SEDATION_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_NHIQM_VTE_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_NHIQM_VTE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_PAIN_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_PAIN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_PC_METRICS D_ATTEND_PRSNL_ID
LH_F_PC_METRICS D_REFER_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_PC_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_PC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_PEDS_MED_AD_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_PEDS_MED_AD_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_PEDS_PAIN_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_PEDS_PAIN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_PEDS_SKIN_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_PEDS_SKIN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_PN_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_PN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_READMISSION_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_READMISSION_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_READMIT_METRICS D_ATTEND_PRSNL_ID
LH_F_READMIT_METRICS D_PCP_ID
LH_F_READMIT_METRICS D_SURGERY_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_READMIT_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_READMIT_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_READMIT_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_REST_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_REST_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_RRT_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_RRT_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_SCIP_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_SCIP_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_SEPSIS_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_SEPSIS_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_SEPSIS_PD_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_SEPSIS_PD_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_SEPSIS_RT_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_SEPSIS_RT_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_STROKE_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_STROKE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_UI_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_UI_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_F_VTE_METRICS D_VTE_ADV_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_VTE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_MU_FX_2_DETAILS D_EP_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_MU_FX_2_DETAILS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_MU_FX_2_EP_RELTN D_EP_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_MU_FX_2_EP_RELTN HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_MU_FX_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_MU_FX_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_QRDA_EC D_PPR_ID
LH_QRDA_EC D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_QRDA_EC HEALTH_SYSTEM_SOURCE_ID
LH_QRDA_EC HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_QRDA_SETUP_DATA D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_QRDA_SETUP_DATA HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_SDOH_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_SDOH_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PRSNL_ID LH_THA_TKA_METRICS D_ATTEND_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_THA_TKA_METRICS HEALTH_SYSTEM_SOURCE_ID


LH_D_PROCEDURE



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_D_PROCEDURE
Definition: This table is used to store procedure reference data for the lighthouse quality metrics.
Table Type: REFERENCE





Column Detail - LH_D_PROCEDURE


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CONCEPT_CKI VARCHAR(255) Y CKI from the concept table representing the functional concept.
D_PROCEDURE_ID DOUBLE N Unique identifier for the procedure.
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 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.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
LONG_DESCRIPTION VARCHAR(255) Y The long description of the procedure.
NOMENCLATURE_ID DOUBLE Y Identifies the procedure nomenclature associated with the quality measure. Foreign key to the nomenclature table with a procedure principle type.
PROCEDURE_CODE VARCHAR(50) Y The code associated with the procedure.
PROCESS_DT_TM DATETIME Y The date/time the record was first loaded into the table.
SHORT_DESCRIPTION VARCHAR(60) Y The short description of the procedure.
SOURCE_VOCABULARY_MEANING VARCHAR(40) Y The vocabulary that contributed the procedure (i.e. ICD9 ICD10 CPT4 etc.)
SRC_BEG_EFFECTIVE_DT_TM DATETIME Y The date/time on which the record became effective on the source system.
SRC_END_EFFECTIVE_DT_TM DATETIME Y The date/time on which the record is no longer effective on the source system.
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.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated.
UPDT_SOURCE VARCHAR(50) 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.



Relationship Detail - LH_D_PROCEDURE




Parent Column in LH_D_PROCEDURE (PK) Child Table Name Child Column Name
Children: D_PROCEDURE_ID LH_F_ACT_INTOL_METRICS D_PRIN_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_ACT_INTOL_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PROCEDURE_ID LH_F_AMI_METRICS D_PRIN_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_AMI_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PROCEDURE_ID LH_F_ANEMIA_METRICS D_PRIN_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_ANEMIA_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PROCEDURE_ID LH_F_CAC_METRICS D_PRIN_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_CAC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PROCEDURE_ID LH_F_CHF_METRICS D_PRIN_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_CHF_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PROCEDURE_ID LH_F_DELIRIUM_METRICS D_PRIN_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_DELIRIUM_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PROCEDURE_ID LH_F_DEPRESSION_METRICS D_PRIN_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_DEPRESSION_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PROCEDURE_ID LH_F_DYSPHAGIA_METRICS D_PRIN_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_DYSPHAGIA_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PROCEDURE_ID LH_F_FVE_METRICS D_PRIN_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_FVE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PROCEDURE_ID LH_F_GLYCEMIC_METRICS D_PRIN_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_GLYCEMIC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PROCEDURE_ID LH_F_HOP_AMI_METRICS D_PRIN_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_HOP_AMI_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PROCEDURE_ID LH_F_HOP_SURG_METRICS D_PRIN_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_HOP_SURG_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PROCEDURE_ID LH_F_IC_MDRO_METRICS D_PRIN_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_IC_MDRO_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PROCEDURE_ID LH_F_LHHF_METRICS D_PRIN_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_LHHF_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PROCEDURE_ID LH_F_LIPID_METRICS D_PRIN_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_LIPID_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PROCEDURE_ID LH_F_MED_AD_METRICS D_PRIN_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_MED_AD_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PROCEDURE_ID LH_F_MOD_SEDATION_METRICS D_PRIN_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_MOD_SEDATION_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PROCEDURE_ID LH_F_NHIQM_VTE_METRICS D_PRIN_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_NHIQM_VTE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PROCEDURE_ID LH_F_PAIN_METRICS D_PRIN_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_PAIN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PROCEDURE_ID LH_F_PEDS_MED_AD_METRICS D_PRIN_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_PEDS_MED_AD_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PROCEDURE_ID LH_F_PEDS_PAIN_METRICS D_PRIN_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_PEDS_PAIN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PROCEDURE_ID LH_F_PEDS_SKIN_METRICS D_PRIN_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_PEDS_SKIN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PROCEDURE_ID LH_F_PN_METRICS D_PRIN_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_PN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PROCEDURE_ID LH_F_READMIT_METRICS D_PRIN_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_READMIT_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PROCEDURE_ID LH_F_REST_METRICS D_PRIN_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_REST_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PROCEDURE_ID LH_F_RRT_METRICS D_PRIN_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_RRT_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PROCEDURE_ID LH_F_SCIP_METRICS D_PRIN_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_SCIP_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PROCEDURE_ID LH_F_SEPSIS_METRICS D_PRIN_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_SEPSIS_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PROCEDURE_ID LH_F_STROKE_METRICS D_PRIN_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_STROKE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_PROCEDURE_ID LH_F_UI_METRICS D_PRIN_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_UI_METRICS HEALTH_SYSTEM_SOURCE_ID


LH_D_PROV_POSITION



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - LH_D_PROV_POSITION


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_PROV_POSITION_ID DOUBLE N Unique identifier for the provider position.
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.
PROCESS_DT_TM DATETIME Y The date/time the record was first loaded into the table.
PROV_POSITION_CD DOUBLE N Source identifier for the provider position
PROV_POSITION_DESCRIPTION VARCHAR(60) Y The description for the provider position
PROV_POSITION_DISPLAY VARCHAR(40) Y The display value for the provider position
PROV_POSITION_MEANING VARCHAR(40) Y The Cerner-defined meaning for the provider position
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_PROV_POSITION




Parent Column in LH_D_PROV_POSITION (PK) Child Table Name Child Column Name
Children: D_PROV_POSITION_ID LH_F_HH_METRICS D_PROV_POSITION_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_HH_METRICS HEALTH_SYSTEM_SOURCE_ID