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_AKI_2025_METRICS | D_ADMIT_NURSE_UNIT_ID | |
| LH_E_AKI_2025_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
| HEALTH_SYSTEM_SOURCE_ID | LH_E_AKI_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| LH_E_AKI_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
| D_NURSE_UNIT_ID | LH_E_AKI_2026_METRICS | D_ADMIT_NURSE_UNIT_ID | |
| LH_E_AKI_2026_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
| HEALTH_SYSTEM_SOURCE_ID | LH_E_AKI_2026_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| LH_E_AKI_2026_METRICS | 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_APHYBD_2025_METRICS | D_ADMIT_NURSE_UNIT_ID | |
| LH_E_APHYBD_2025_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
| HEALTH_SYSTEM_SOURCE_ID | LH_E_APHYBD_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| LH_E_APHYBD_2025_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_FI_2026_METRICS | D_ADMIT_NURSE_UNIT_ID | |
| LH_E_FI_2026_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
| HEALTH_SYSTEM_SOURCE_ID | LH_E_FI_2026_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| LH_E_FI_2026_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_GMCS_2025_METRICS | D_ADMIT_NURSE_UNIT_ID | |
| LH_E_GMCS_2025_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
| HEALTH_SYSTEM_SOURCE_ID | LH_E_GMCS_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| LH_E_GMCS_2025_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_HH_2025_METRICS | D_ADMIT_NURSE_UNIT_ID | |
| LH_E_HH_2025_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
| HEALTH_SYSTEM_SOURCE_ID | LH_E_HH_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| LH_E_HH_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
| D_NURSE_UNIT_ID | LH_E_HH_2026_METRICS | D_ADMIT_NURSE_UNIT_ID | |
| LH_E_HH_2026_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
| HEALTH_SYSTEM_SOURCE_ID | LH_E_HH_2026_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| LH_E_HH_2026_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_HYBRID_2025_METRICS | D_ADMIT_NURSE_UNIT_ID | |
| LH_E_HYBRID_2025_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
| HEALTH_SYSTEM_SOURCE_ID | LH_E_HYBRID_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| LH_E_HYBRID_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
| D_NURSE_UNIT_ID | LH_E_IPRAD_2025_METRICS | D_ADMIT_NURSE_UNIT_ID | |
| LH_E_IPRAD_2025_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
| HEALTH_SYSTEM_SOURCE_ID | LH_E_IPRAD_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| LH_E_IPRAD_2025_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_OPIOID_2025_METRICS | D_DISCHARGE_NURSE_UNIT_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| D_NURSE_UNIT_ID | LH_E_OPIOID_2026_METRICS | D_DISCHARGE_NURSE_UNIT_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2026_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| D_NURSE_UNIT_ID | LH_E_OPRAD_2025_METRICS | D_ADMIT_NURSE_UNIT_ID | |
| LH_E_OPRAD_2025_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
| HEALTH_SYSTEM_SOURCE_ID | LH_E_OPRAD_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| LH_E_OPRAD_2025_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_ORAE_2025_METRICS | D_ADMIT_NURSE_UNIT_ID | |
| LH_E_ORAE_2025_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
| HEALTH_SYSTEM_SOURCE_ID | LH_E_ORAE_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| LH_E_ORAE_2025_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_PCB_2025_METRICS | D_ADMIT_NURSE_UNIT_ID | |
| LH_E_PCB_2025_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
| HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| LH_E_PCB_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
| D_NURSE_UNIT_ID | LH_E_PCB_2026_METRICS | D_ADMIT_NURSE_UNIT_ID | |
| LH_E_PCB_2026_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
| HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2026_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| LH_E_PCB_2026_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_PCM_2025_METRICS | D_ADMIT_NURSE_UNIT_ID | |
| LH_E_PCM_2025_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
| HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| LH_E_PCM_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
| D_NURSE_UNIT_ID | LH_E_PCM_2026_METRICS | D_ADMIT_NURSE_UNIT_ID | |
| LH_E_PCM_2026_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
| HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2026_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| LH_E_PCM_2026_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_PI_2025_METRICS | D_ADMIT_NURSE_UNIT_ID | |
| LH_E_PI_2025_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
| HEALTH_SYSTEM_SOURCE_ID | LH_E_PI_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| LH_E_PI_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
| D_NURSE_UNIT_ID | LH_E_PI_2026_METRICS | D_ADMIT_NURSE_UNIT_ID | |
| LH_E_PI_2026_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
| HEALTH_SYSTEM_SOURCE_ID | LH_E_PI_2026_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| LH_E_PI_2026_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_STEMI_2025_METRICS | D_ADMIT_NURSE_UNIT_ID | |
| LH_E_STEMI_2025_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
| HEALTH_SYSTEM_SOURCE_ID | LH_E_STEMI_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| LH_E_STEMI_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
| D_NURSE_UNIT_ID | LH_E_STEMI_2026_METRICS | D_ADMIT_NURSE_UNIT_ID | |
| LH_E_STEMI_2026_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
| HEALTH_SYSTEM_SOURCE_ID | LH_E_STEMI_2026_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| LH_E_STEMI_2026_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_2025_METRICS | D_ADMIT_NURSE_UNIT_ID | |
| LH_E_STROKE_2025_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
| HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| LH_E_STROKE_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
| D_NURSE_UNIT_ID | LH_E_STROKE_2026_METRICS | D_ADMIT_NURSE_UNIT_ID | |
| LH_E_STROKE_2026_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
| HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2026_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| LH_E_STROKE_2026_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_2025_METRICS | D_ADMIT_NURSE_UNIT_ID | |
| LH_E_VTE_2025_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
| HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| LH_E_VTE_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
| D_NURSE_UNIT_ID | LH_E_VTE_2026_METRICS | D_ADMIT_NURSE_UNIT_ID | |
| LH_E_VTE_2026_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
| HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2026_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| LH_E_VTE_2026_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_SDOH_OP_METRICS | D_ADMIT_NURSE_UNIT_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_SDOH_OP_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 | |
| D_NURSE_UNIT_ID | LH_THA_TKA_OP_METRICS | D_ADMIT_NURSE_UNIT_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_THA_TKA_OP_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_AKI_2025_METRICS | D_PERSON_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_AKI_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| D_PERSON_ID | LH_E_AKI_2026_METRICS | D_PERSON_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_AKI_2026_METRICS | 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_APHYBD_2025_METRICS | D_PERSON_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_APHYBD_2025_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_FI_2026_METRICS | D_PERSON_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_FI_2026_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_GMCS_2025_METRICS | D_PERSON_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_GMCS_2025_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_HH_2025_METRICS | D_PERSON_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_HH_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| D_PERSON_ID | LH_E_HH_2026_METRICS | D_PERSON_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_HH_2026_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_HYBRID_2025_METRICS | D_PERSON_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_HYBRID_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| D_PERSON_ID | LH_E_IPRAD_2025_METRICS | D_PERSON_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_IPRAD_2025_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_OPIOID_2025_METRICS | D_PERSON_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| D_PERSON_ID | LH_E_OPIOID_2026_METRICS | D_PERSON_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2026_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| D_PERSON_ID | LH_E_OPRAD_2025_METRICS | D_PERSON_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_OPRAD_2025_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_ORAE_2025_METRICS | D_PERSON_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_ORAE_2025_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_PCB_2025_METRICS | D_PERSON_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| D_PERSON_ID | LH_E_PCB_2026_METRICS | D_PERSON_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2026_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_PCM_2025_METRICS | D_PERSON_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| D_PERSON_ID | LH_E_PCM_2026_METRICS | D_PERSON_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2026_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_PI_2025_METRICS | D_PERSON_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_PI_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| D_PERSON_ID | LH_E_PI_2026_METRICS | D_PERSON_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_PI_2026_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_STEMI_2025_METRICS | D_PERSON_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_STEMI_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| D_PERSON_ID | LH_E_STEMI_2026_METRICS | D_PERSON_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_STEMI_2026_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_2025_METRICS | D_PERSON_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| D_PERSON_ID | LH_E_STROKE_2026_METRICS | D_PERSON_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2026_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_2025_METRICS | D_PERSON_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| D_PERSON_ID | LH_E_VTE_2026_METRICS | D_PERSON_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2026_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_SDOH_OP_METRICS | D_PERSON_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_SDOH_OP_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 | |
| D_PERSON_ID | LH_THA_TKA_OP_METRICS | D_PERSON_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_THA_TKA_OP_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. |
| 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_AKI_2025_METRICS | D_ATTEND_PRSNL_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_AKI_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| D_PRSNL_ID | LH_E_AKI_2026_METRICS | D_ATTEND_PRSNL_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_AKI_2026_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_APHYBD_2025_METRICS | D_ATTEND_PRSNL_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_APHYBD_2025_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_FI_2026_METRICS | D_ATTEND_PRSNL_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_FI_2026_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_GMCS_2025_METRICS | D_ATTEND_PRSNL_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_GMCS_2025_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_HH_2025_METRICS | D_ATTEND_PRSNL_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_HH_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| D_PRSNL_ID | LH_E_HH_2026_METRICS | D_ATTEND_PRSNL_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_HH_2026_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_HYBRID_2025_METRICS | D_ATTEND_PRSNL_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_HYBRID_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| D_PRSNL_ID | LH_E_IPRAD_2025_METRICS | D_ATTEND_PRSNL_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_IPRAD_2025_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_OPIOID_2025_METRICS | D_ATTEND_PRSNL_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| D_PRSNL_ID | LH_E_OPIOID_2026_METRICS | D_ATTEND_PRSNL_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2026_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| D_PRSNL_ID | LH_E_OPRAD_2025_METRICS | D_ATTEND_PRSNL_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_OPRAD_2025_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_ORAE_2025_METRICS | D_ATTEND_PRSNL_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_ORAE_2025_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_PCB_2025_METRICS | D_ATTEND_PRSNL_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| D_PRSNL_ID | LH_E_PCB_2026_METRICS | D_ATTEND_PRSNL_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2026_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_PCM_2025_METRICS | D_ATTEND_PRSNL_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| D_PRSNL_ID | LH_E_PCM_2026_METRICS | D_ATTEND_PRSNL_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2026_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_PI_2025_METRICS | D_ATTEND_PRSNL_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_PI_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| D_PRSNL_ID | LH_E_PI_2026_METRICS | D_ATTEND_PRSNL_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_PI_2026_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_STEMI_2025_METRICS | D_ATTEND_PRSNL_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_STEMI_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| D_PRSNL_ID | LH_E_STEMI_2026_METRICS | D_ATTEND_PRSNL_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_STEMI_2026_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_2025_METRICS | D_ATTEND_PRSNL_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| D_PRSNL_ID | LH_E_STROKE_2026_METRICS | D_ATTEND_PRSNL_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2026_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_2025_METRICS | D_ATTEND_PRSNL_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2025_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
| D_PRSNL_ID | LH_E_VTE_2026_METRICS | D_ATTEND_PRSNL_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2026_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_SDOH_OP_METRICS | D_ATTEND_PRSNL_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_SDOH_OP_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 | |
| D_PRSNL_ID | LH_THA_TKA_OP_METRICS | D_ATTEND_PRSNL_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_THA_TKA_OP_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 |