Table Detail Report

LH_D_BUILDING



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - LH_D_BUILDING


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.
BUILDING_DESCRIPTION VARCHAR(40) Y The description of the building.
BUILDING_DISPLAY VARCHAR(40) Y The display value for the building.
BUILDING_MEANING VARCHAR(40) Y The Cerner-defined meaning for the building.
D_BUILDING_ID DOUBLE N Unique identifier for a building.
D_FACILITY_ID DOUBLE Y Identifies the facility associated with the building. Foreign key to the LH_D_FACILITY table.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
EXTRACT_DT_TM DATETIME Y The date/time that the program running the extracts was started. This 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_BUILDING_CD DOUBLE Y Identifies the building 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.
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_BUILDING


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


LH_D_CQM_BEDROCK_MAP



Column Section Top of Page


Table-level Detail

Description: LH_D_CQM_BEDROCK_MAP
Definition: This table is used to store reference data based off of the Clinical Quality Measures Bedrock components
Table Type: REFERENCE





Column Detail - LH_D_CQM_BEDROCK_MAP


Column Name Type Null? Definition
BEG_EFFECTIVE_DT_TM DATETIME Y When the row is first activated
CATEGORY_MEAN VARCHAR(100) Y Unique string for a category
END_EFFECTIVE_DT_TM DATETIME Y When the row becomes 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.
FILTER_MEAN VARCHAR(100) Y Unique string for a filter
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
LH_D_CQM_BEDROCK_MAP_ID DOUBLE N Unique generated number that identifies a single row on the LH_D_CQM_BEDROCK_MAP table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
PARENT_ENTITY_ID DOUBLE N The Millennium value stored on the Bedrock table
PROCESS_DT_TM DATETIME Y The date/time the record was first loaded into the table.
SOURCE_VOCAB_ITEM_IDENT VARCHAR(50) Y The identifier that the Millennium value is mapped to
SOURCE_VOCAB_MEAN VARCHAR(50) Y The type of identifier as identified by CMS
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated
UPDT_SOURCE VARCHAR(50) N The script name responsible for updating the record
UPDT_TASK VARCHAR(50) N The registered (assigned) task number for the process that inserted or updated the row
VALUE_SET_NAME VARCHAR(255) Y The CMS Value Set Name
VOCAB_OID_TXT VARCHAR(100) Y The CMS Value Set Identifier


LH_D_CQM_MEDICATION_MAP



Column Section Top of Page


Table-level Detail

Description: LH_D_CQM_MEDICATION_MAP
Definition: This table is used to store reference data based off of the Clinical Quality Measures Bedrock and Multum components
Table Type: REFERENCE





Column Detail - LH_D_CQM_MEDICATION_MAP


Column Name Type Null? Definition
BEG_EFFECTIVE_DT_TM DATETIME Y The Begin effective date/time for the mapping
CATEGORY_MEAN VARCHAR(100) Y Unique string for a category
END_EFFECTIVE_DT_TM DATETIME Y The End effective date/time for the mapping
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 delivery network responsible for supplying the data.
LH_D_CQM_MEDICATION_MAP_ID DOUBLE N Unique generated number that identifies a single row on the LH_D_CQM_MEDICATION_MAP table.
PROCESS_DT_TM DATETIME Y The date/time the record was first loaded into the table.
SOURCE_VOCAB_ITEM_IDENT VARCHAR(50) Y The identifier that the Millennium value is mapped to
SOURCE_VOCAB_MEAN VARCHAR(50) Y The type of identifier as identified by CMS
SYNONYM_ID DOUBLE N A Millennium synonym that identifies the medication
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_SOURCE VARCHAR(50) N The script name responsible for updating the record
UPDT_TASK VARCHAR(50) N The registered (assigned) task number for the process that inserted or updated the row.
VALUE_SET_NAME VARCHAR(255) Y The CMS Value Set Name
VOCAB_OID_TXT VARCHAR(100) Y The CMS Value Set Identifier


LH_D_CQM_RXNORM_MAP



Column Section Top of Page


Table-level Detail

Description: LH_D_RXNORM_MAP
Definition: This table is used to store reference data based off of the Clinical Quality Measures Bedrock and Multum components
Table Type: REFERENCE





Column Detail - LH_D_CQM_RXNORM_MAP


Column Name Type Null? Definition
AMOUNT_NBR DOUBLE N The Amount of the drug
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.
CATALOG_CD DOUBLE N The Millennium catalog code for the order
CATEGORY_MEAN VARCHAR(100) Y Unique string for a category
DOSE_CD DOUBLE N The Millennium code value for the dosage of the medication
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.
GENERIC_DRUG_NAME_TXT VARCHAR(255) Y The generic name of the drug from Multum
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
LH_D_CQM_RXNORM_MAP_ID DOUBLE N Unique generated number that identifies a single row on the LH_D_CQM_RXNORM_MAP table.
MLTM_ACTIVE_INGRED_TXT VARCHAR(255) Y The Multum code value for the primary route of the RxNorm
MLTM_DOSE_ABBR_TXT VARCHAR(50) Y The Multum abbreviation for the dosage of the RxNorm
MLTM_DOSE_CODE DOUBLE N The Multum code value for the primary route of the RxNorm
MLTM_DOSE_DESC_TXT VARCHAR(255) Y The Multum description for the dosage of the RxNorm
MLTM_DRUG_IDENT_TXT VARCHAR(255) Y The Multum code value for the primary route of the RxNorm
MLTM_ROUTE_ABBR_TXT VARCHAR(50) Y The Multum abbreviation for the route of the RxNorm
MLTM_ROUTE_CODE DOUBLE N The Multum code value for the primary route of the RxNorm
MLTM_ROUTE_DESC_TXT VARCHAR(50) Y The Multum description for the route of the RxNorm
MLTM_UNIT_ABBR_TXT VARCHAR(255) Y The Multum code value for the primary route of the RxNorm
PROCESS_DT_TM DATETIME Y The date/time the record was first loaded into the table.
ROUTE_CD DOUBLE N The Millennium code value for the route of the drug
RXNORM_TXT VARCHAR(25) Y The RxNorm
UNIT_CD DOUBLE N The Millennium code value for the units of the medication
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME 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.
VALUE_SET_NAME VARCHAR(255) Y Unique string for a value set identifier
VOCAB_OID_TXT VARCHAR(100) Y The the CMS defined OID for the Value Set


LH_D_DIAGNOSIS



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - LH_D_DIAGNOSIS


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.
DIAGNOSIS_CODE VARCHAR(50) Y The code associated with the diagnosis.
D_DIAGNOSIS_ID DOUBLE N Unique identifier for the diagnosis.
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 diagnosis.
NOMENCLATURE_ID DOUBLE Y Identifies the diagnosis nomenclature associated with the quality measure. Foreign key to the nomenclature table with a diagnosis principle type.
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 diagnosis.
SOURCE_VOCABULARY_MEANING VARCHAR(40) Y The vocabulary that contributed the diagnosis (i.e. ICD9 ICD10 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_DIAGNOSIS




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