Table Detail Report
LH_D_NURSE_UNIT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_D_NURSE_UNIT |
Definition: | This table is used to store nurse unit reference data for the lighthouse quality metrics. |
Table Type: | REFERENCE |
Column Detail - LH_D_NURSE_UNIT
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
D_BUILDING_ID | DOUBLE | Y | Identifies the building associated with the nurse unit. Foreign key to the LH_D_BUILDING table. |
D_FACILITY_ID | DOUBLE | Y | Identifies the facility associated with the nurse unit. Foreign key to the LH_D_FACILITY table. |
D_NURSE_UNIT_ID | DOUBLE | N | Unique identifier for a nurse unit. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the program running the extracts was started. This field should be the same across all files and across all records within a file for a given extraction run. This time should be in UTC time. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data. |
LOC_NURSE_UNIT_CD | DOUBLE | Y | Identifies the nurse unit associated with the quality measure. Foreign key to the code_value table for code set 220. |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
NURSE_UNIT_DESCRIPTION | VARCHAR(40) | Y | The description of the nurse unit. |
NURSE_UNIT_DISPLAY | VARCHAR(40) | Y | The display value for the nurse unit. |
NURSE_UNIT_MEANING | VARCHAR(40) | Y | The Cerner-defined meaning for the nurse unit. |
PROCESS_DT_TM | DATETIME | Y | The date/time the record was first loaded into the table. |
UPDT_CNT | DOUBLE | Y | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_SOURCE | VARCHAR(50) | Y | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | Y | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - LH_D_NURSE_UNIT
Child Column in LH_D_NURSE_UNIT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | D_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
D_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |
Parent Column in LH_D_NURSE_UNIT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | D_NURSE_UNIT_ID | LH_ABS_AMI_METRICS | D_ADMIT_NURSE_UNIT_ID |
LH_ABS_AMI_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_ABS_CAC_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_ABS_CAC_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_CAC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_CAC_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_ABS_CSTK02_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_ABS_CSTK02_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_CSTK02_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_CSTK02_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_ABS_ED_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_ABS_ED_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_ED_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_ED_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_ABS_HBIPS_DISC_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_ABS_HBIPS_DISC_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HBIPS_DISC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_HBIPS_DISC_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_ABS_HBIPS_EVNT_METRICS | D_EVENT_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HBIPS_EVNT_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_NURSE_UNIT_ID | LH_ABS_HBIPS_PATIENTS | D_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HBIPS_PATIENTS | HEALTH_SYSTEM_SOURCE_ID | |
D_NURSE_UNIT_ID | LH_ABS_HBIPS_PATIENTS_INFO | D_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HBIPS_PATIENTS_INFO | HEALTH_SYSTEM_SOURCE_ID | |
D_NURSE_UNIT_ID | LH_ABS_HF_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_ABS_HF_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HF_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_HF_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_ABS_HOQR_AMI_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_ABS_HOQR_AMI_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_HOQR_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_ABS_HOQR_CATA_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_ABS_HOQR_CATA_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_CATA_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_HOQR_CATA_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_ABS_HOQR_CP_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_ABS_HOQR_CP_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_CP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_HOQR_CP_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_ABS_HOQR_EBRT_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_ABS_HOQR_EBRT_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_EBRT_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_HOQR_EBRT_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_ABS_HOQR_ED_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_ABS_HOQR_ED_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_ED_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_HOQR_ED_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_ABS_HOQR_END29_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_ABS_HOQR_END29_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_END29_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_HOQR_END29_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_ABS_HOQR_END30_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_ABS_HOQR_END30_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_END30_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_HOQR_END30_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_ABS_HOQR_PM_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_ABS_HOQR_PM_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_PM_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_HOQR_PM_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_ABS_HOQR_STK_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_ABS_HOQR_STK_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_STK_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_HOQR_STK_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_ABS_HOQR_SURG_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_ABS_HOQR_SURG_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_SURG_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_HOQR_SURG_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_ABS_IMM_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_ABS_IMM_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_IMM_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_IMM_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_ABS_PC_BF_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_ABS_PC_BF_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PC_BF_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_PC_BF_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_ABS_PC_BSI_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_ABS_PC_BSI_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PC_BSI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_PC_BSI_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_ABS_PC_MOTHER_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_ABS_PC_MOTHER_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PC_MOTHER_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_PC_MOTHER_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_ABS_PC_UNC_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_ABS_PC_UNC_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PC_UNC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_PC_UNC_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_ABS_PN_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_ABS_PN_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_PN_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_ABS_SCIP_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_ABS_SCIP_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_SCIP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_SCIP_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_ABS_SMD_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_ABS_SMD_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_SMD_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_SMD_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_ABS_STK_OP_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_ABS_STK_OP_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_STK_OP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_STK_OP_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_ABS_STROKE_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_ABS_STROKE_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_STROKE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_STROKE_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_ABS_SUB_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_ABS_SUB_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_SUB_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_SUB_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_ABS_TOB_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_ABS_TOB_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_TOB_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_TOB_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_ABS_TR_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_ABS_TR_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_TR_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_TR_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_ABS_VTE_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_ABS_VTE_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_VTE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_VTE_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_EH_HCO_ISSUE | D_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_EH_HCO_ISSUE | HEALTH_SYSTEM_SOURCE_ID | |
D_NURSE_UNIT_ID | LH_EH_QRDA_ISSUE | D_ADMIT_NURSE_UNIT_ID | |
LH_EH_QRDA_ISSUE | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_EH_QRDA_ISSUE | HEALTH_SYSTEM_SOURCE_ID | |
LH_EH_QRDA_ISSUE | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_AMI_2017_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_AMI_2017_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_AMI_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_AMI_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_AMI_2018_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_AMI_2018_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_AMI_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_AMI_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_AMI_2019_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_AMI_2019_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_AMI_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_AMI_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_AMI_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_AMI_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_APHYBD_2024_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_APHYBD_2024_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_APHYBD_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_APHYBD_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_CAC_2017_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_CAC_2017_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_CAC_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_CAC_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_CAC_2018_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_CAC_2018_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_CAC_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_CAC_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_CAC_2019_METRICS | D_DISCHARGE_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_CAC_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_NURSE_UNIT_ID | LH_E_CAC_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_CAC_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_CAC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_CAC_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_ED_2016_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_ED_2016_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_ED_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_ED_2017_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_ED_2017_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_ED_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_ED_2018_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_ED_2018_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_ED_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_ED_2019_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_ED_2019_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_ED_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_ED_2020_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_ED_2020_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_ED_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_ED_2021_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_ED_2021_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_ED_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_ED_2022_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_ED_2022_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_ED_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_ED_2023_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_ED_2023_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_ED_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_ED_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_ED_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_ED_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_EHDI_2017_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_EHDI_2017_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_EHDI_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_EHDI_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_EHDI_2018_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_EHDI_2018_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_EHDI_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_EHDI_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_EHDI_2019_METRICS | D_DISCHARGE_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_EHDI_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_NURSE_UNIT_ID | LH_E_GMCS_2024_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_GMCS_2024_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_GMCS_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_GMCS_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_HEARING_SCREEN_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_HEARING_SCREEN_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_HEARING_SCREEN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_HEARING_SCREEN_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_HH_2023_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_HH_2023_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_HH_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_HH_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_HH_2024_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_HH_2024_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_HH_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_HH_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_HTN_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_HTN_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_HTN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_HTN_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_HWR_2018_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_HWR_2018_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_HWR_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_HWR_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_HWR_2021_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_HWR_2021_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_HWR_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_HWR_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_HYBRID_2022_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_HYBRID_2022_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_HYBRID_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_HYBRID_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_HYBRID_2023_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_HYBRID_2023_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_HYBRID_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_HYBRID_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_HYBRID_2024_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_HYBRID_2024_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_HYBRID_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_HYBRID_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_OPIOID_2021_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_OPIOID_2021_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_OPIOID_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_OPIOID_2022_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_OPIOID_2022_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_OPIOID_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_OPIOID_2023_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_OPIOID_2023_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_OPIOID_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_OPIOID_2024_METRICS | D_DISCHARGE_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_NURSE_UNIT_ID | LH_E_ORAE_2024_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_ORAE_2024_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_ORAE_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_ORAE_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_PCB_2020_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_PCB_2020_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_PCB_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_PCB_2021_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_PCB_2021_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_PCB_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_PCB_2022_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_PCB_2022_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_PCB_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_PCB_2023_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_PCB_2023_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_PCB_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_PCB_2024_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_PCB_2024_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_PCB_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_PCM_2020_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_PCM_2020_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_PCM_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_PCM_2021_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_PCM_2021_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_PCM_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_PCM_2022_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_PCM_2022_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_PCM_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_PCM_2023_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_PCM_2023_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_PCM_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_PCM_2024_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_PCM_2024_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_PCM_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_PC_2016_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_PC_2016_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_PC_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_PC_2017_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_PC_2017_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_PC_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_PC_2018_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_PC_2018_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_PC_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_PC_2019_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_PC_2019_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_PC_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_PC_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_PC_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_PC_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_PN_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_PN_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_PN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_PN_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_SCIP_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_SCIP_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_SCIP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_SCIP_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_STEMI_2023_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_STEMI_2023_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_STEMI_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_STEMI_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_STEMI_2024_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_STEMI_2024_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_STEMI_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_STEMI_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_STROKE_2016_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_STROKE_2016_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_STROKE_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_STROKE_2017_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_STROKE_2017_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_STROKE_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_STROKE_2018_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_STROKE_2018_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_STROKE_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_STROKE_2019_METRICS | D_DISCHARGE_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_NURSE_UNIT_ID | LH_E_STROKE_2020_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_STROKE_2020_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_STROKE_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_STROKE_2021_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_STROKE_2021_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_STROKE_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_STROKE_2022_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_STROKE_2022_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_STROKE_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_STROKE_2023_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_STROKE_2023_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_STROKE_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_STROKE_2024_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_STROKE_2024_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_STROKE_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_STROKE_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_STROKE_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_STROKE_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_VTE_2016_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_VTE_2016_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_VTE_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_VTE_2017_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_VTE_2017_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_VTE_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_VTE_2018_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_VTE_2018_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_VTE_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_VTE_2019_METRICS | D_DISCHARGE_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_NURSE_UNIT_ID | LH_E_VTE_2020_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_VTE_2020_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_VTE_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_VTE_2021_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_VTE_2021_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_VTE_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_VTE_2022_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_VTE_2022_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_VTE_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_VTE_2023_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_VTE_2023_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_VTE_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_VTE_2024_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_VTE_2024_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_VTE_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_E_VTE_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_E_VTE_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_E_VTE_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_ACT_INTOL_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_ACT_INTOL_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_ACT_INTOL_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_ACT_INTOL_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_ACUTE_PAIN_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_ACUTE_PAIN_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_ACUTE_PAIN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_ACUTE_PAIN_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_AMI_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_AMI_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_ANEMIA_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_ANEMIA_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_ANEMIA_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_ANEMIA_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_CAC_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_CAC_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_CAC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_CAC_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_CHF_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_CHF_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_CHF_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_CHF_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_CRI_CE_METRICS | D_CRI_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_CRI_CE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_NURSE_UNIT_ID | LH_F_CRI_ENCNTR_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_CRI_ENCNTR_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_CRI_ENCNTR_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_CRI_ENCNTR_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_DELIRIUM_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_DELIRIUM_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_DELIRIUM_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_DELIRIUM_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_DEPRESSION_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_DEPRESSION_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_DEPRESSION_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_DEPRESSION_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_DYSPHAGIA_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_DYSPHAGIA_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_DYSPHAGIA_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_DYSPHAGIA_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_FALLS_DTL_METRICS | D_FALL_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_FALLS_DTL_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_NURSE_UNIT_ID | LH_F_FALLS_HST_METRICS | D_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_FALLS_HST_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_NURSE_UNIT_ID | LH_F_FALLS_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_FALLS_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
LH_F_FALLS_METRICS | D_FIRST_FALL_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_FALLS_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_FALLS_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
LH_F_FALLS_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_FVE_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_FVE_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_FVE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_FVE_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_GLYCEMIC_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_GLYCEMIC_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_GLYCEMIC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_GLYCEMIC_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_HAPU_DTL_METRICS | D_HAPU_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_HAPU_DTL_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_NURSE_UNIT_ID | LH_F_HAPU_HST_METRICS | D_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_HAPU_HST_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_NURSE_UNIT_ID | LH_F_HAPU_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_HAPU_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
LH_F_HAPU_METRICS | D_FIRST_HAPU_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_HAPU_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_HAPU_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
LH_F_HAPU_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_HH_METRICS | D_OBSRV_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_HH_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_NURSE_UNIT_ID | LH_F_HOP_AMI_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_HOP_AMI_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_HOP_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_HOP_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_HOP_SURG_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_HOP_SURG_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_HOP_SURG_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_HOP_SURG_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_IC_ANTIBGRM_METRICS | D_COLL_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_IC_ANTIBGRM_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_NURSE_UNIT_ID | LH_F_IC_HAI_ENCNTR_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_IC_HAI_ENCNTR_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_IC_HAI_ENCNTR_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_IC_HAI_ENCNTR_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_IC_MDRO_DTL_METRICS | D_COLL_NURSE_UNIT_ID | |
LH_F_IC_MDRO_DTL_METRICS | D_COLL_PREV_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_IC_MDRO_DTL_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_IC_MDRO_DTL_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_IC_MDRO_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_IC_MDRO_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
LH_F_IC_MDRO_METRICS | D_PREV_DISCH_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_IC_MDRO_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_IC_MDRO_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
LH_F_IC_MDRO_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_LHHF_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_LHHF_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_LHHF_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_LHHF_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_LIPID_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_LIPID_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_LIPID_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_LIPID_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_MED_AD_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_MED_AD_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_MED_AD_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_MED_AD_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_MOD_SEDATION_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_MOD_SEDATION_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_MOD_SEDATION_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_MOD_SEDATION_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_NHIQM_VTE_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_NHIQM_VTE_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_NHIQM_VTE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_NHIQM_VTE_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_PAIN_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_PAIN_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_PAIN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_PAIN_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_PC_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_PC_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_PC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_PC_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_PEDS_MED_AD_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_PEDS_MED_AD_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_PEDS_MED_AD_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_PEDS_MED_AD_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_PEDS_PAIN_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_PEDS_PAIN_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_PEDS_PAIN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_PEDS_PAIN_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_PEDS_SKIN_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_PEDS_SKIN_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_PEDS_SKIN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_PEDS_SKIN_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_PN_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_PN_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_PN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_PN_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_READMISSION_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_READMISSION_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_READMISSION_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_READMISSION_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_READMIT_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_READMIT_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_READMIT_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_READMIT_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_REST_DTL_METRICS | D_REST_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_REST_DTL_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_NURSE_UNIT_ID | LH_F_REST_HST_METRICS | D_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_REST_HST_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_NURSE_UNIT_ID | LH_F_REST_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_REST_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_REST_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_REST_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_RRT_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_RRT_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_RRT_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_RRT_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_SCIP_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_SCIP_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_SCIP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_SCIP_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_SEPSIS_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_SEPSIS_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_SEPSIS_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_SEPSIS_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_SEPSIS_PD_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_SEPSIS_PD_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_SEPSIS_PD_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_SEPSIS_PD_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_SEPSIS_RT_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_SEPSIS_RT_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_SEPSIS_RT_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_SEPSIS_RT_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_STROKE_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_STROKE_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_STROKE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_STROKE_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_UI_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_UI_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_UI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_UI_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_F_VTE_METRICS | D_ADMIT_NURSE_UNIT_ID | |
LH_F_VTE_METRICS | D_DISCHARGE_NURSE_UNIT_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_VTE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_VTE_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_NURSE_UNIT_ID | LH_MU_FX_2_METRICS | D_DISCHARGE_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_MU_FX_2_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_NURSE_UNIT_ID | LH_MU_FX_3_ORD_METRICS | D_DISCHARGE_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_MU_FX_3_ORD_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_NURSE_UNIT_ID | LH_MU_FX_3_POP_METRICS | D_DISCHARGE_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_MU_FX_3_POP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_NURSE_UNIT_ID | LH_MU_FX_METRICS | D_DISCHARGE_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_MU_FX_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_NURSE_UNIT_ID | LH_SDOH_METRICS | D_DISCHARGE_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_SDOH_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_NURSE_UNIT_ID | LH_THA_TKA_METRICS | D_DISCH_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_THA_TKA_METRICS | HEALTH_SYSTEM_SOURCE_ID |
LH_D_PERSON
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_D_PERSON |
Definition: | This table is used to store person reference data for the lighthouse quality metrics. |
Table Type: | ACTIVITY |
Column Detail - LH_D_PERSON
Column Name | Type | Null? | Definition |
---|---|---|---|
ABS_BIRTH_DT_TM | DATETIME | Y | The birth date/time "as entered" during registration. The date/time data in this field is "local" when the database is running in "UTC mode" and it is typically not populated (NULL) when the database is running in "local mode." This field is used for querying purposes only and helps eliminate edge cases where records fail to qualify because the user performing the search is in a different time zone. |
ACTIVE_IND | DOUBLE | Y | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
BIRTH_DT_TM | DATETIME | Y | The date/time on which the patient was born. |
BIRTH_TZ | DOUBLE | Y | This field specifies the time zone of the person's birth date time. |
DECEASED_DT_TM | DATETIME | Y | The date/time that the patient expired. |
DECEASED_UTC_DT_TM | DATETIME | Y | The date/time that the patient expired in GMT. |
D_PERSON_ID | DOUBLE | N | Unique identifier for a person. |
EMAIL_ADDR | VARCHAR(100) | Y | The e-mail address of the person. |
EMAIL_IMPORT_IND | DOUBLE | Y | Indicates that the e-mail address was imported rather than from Millennium. 1 - Imported |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
ETHNIC_GROUP_DISPLAY | VARCHAR(40) | Y | The display value for the ethnic group of the patient. |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the program running the extracts was started. This field should be the same across all files and across all records within a file for a given extraction run. This time should be in UTC time. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data. |
HOME_CITY | VARCHAR(100) | Y | Identifies the home address of the patient. |
HOME_COUNTY | VARCHAR(100) | Y | Identifies the home address of the patient. |
HOME_STATE | VARCHAR(100) | Y | Identifies the home address of the patient. |
HOME_STREET_ADDR1 | VARCHAR(100) | Y | Identifies the home address of the patient. |
HOME_STREET_ADDR2 | VARCHAR(100) | Y | Identifies the home address of the patient. |
HOME_STREET_ADDR3 | VARCHAR(100) | Y | Identifies the home address of the patient. |
HOME_STREET_ADDR4 | VARCHAR(100) | Y | Identifies the home address of the patient. |
HOME_ZIPCODE | VARCHAR(25) | Y | Identifies the home address of the patient. |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
NAME_FIRST | VARCHAR(100) | Y | The first name of the patient. |
NAME_FULL | VARCHAR(100) | Y | The full name of the patient. |
NAME_LAST | VARCHAR(100) | Y | The last name of the patient. |
NAME_MIDDLE | VARCHAR(100) | Y | the middle name of the patient. |
NATIONAL_IDENT_TXT | VARCHAR(50) | Y | The national identifier associated with the patient. In the United States this is the Social Security Number. |
ORG_MRN_TXT | VARCHAR(50) | Y | Identifies the medical record number of the patient. |
PERSON_ID | DOUBLE | Y | Identifies the person associated with the quality measure. Foreign key to the PERSON table. |
PHONE_IMPORT_IND | DOUBLE | Y | Indicates that the phone number was imported rather than from Millennium. 1 - Imported |
PHONE_NUM | VARCHAR(100) | Y | The phone number of the person. |
PROCESS_DT_TM | DATETIME | Y | The date/time the record was first loaded into the table. |
RACE_DISPLAY | VARCHAR(50) | Y | The display value for the race of the patient. |
SEX_DISPLAY | VARCHAR(40) | Y | The display value for the gender of the patient. |
SEX_MEANING | VARCHAR(40) | Y | The cdf_meaning for the gender of the patient. |
UPDT_CNT | DOUBLE | Y | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_SOURCE | VARCHAR(50) | Y | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | Y | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - LH_D_PERSON
Parent Column in LH_D_PERSON (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | D_PERSON_ID | LH_ABS_AMI_METRICS | D_PERSON_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_CAC_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_CAC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_CSTK02_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_CSTK02_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_ED_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_ED_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_HBIPS_DISC_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HBIPS_DISC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_HBIPS_EVNT_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HBIPS_EVNT_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_HBIPS_PATIENTS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HBIPS_PATIENTS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_HF_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HF_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_HOQR_AMI_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_HOQR_CATA_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_CATA_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_HOQR_CP_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_CP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_HOQR_EBRT_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_EBRT_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_HOQR_ED_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_ED_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_HOQR_END29_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_END29_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_HOQR_END30_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_END30_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_HOQR_PM_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_PM_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_HOQR_STK_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_STK_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_HOQR_SURG_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_SURG_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_IMM_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_IMM_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_PC_BF_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PC_BF_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_PC_BSI_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PC_BSI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_PC_MOTHER_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PC_MOTHER_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_PC_UNC_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PC_UNC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_PN_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_SCIP_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_SCIP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_SMD_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_SMD_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_STK_OP_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_STK_OP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_STROKE_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_STROKE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_SUB_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_SUB_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_TOB_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_TOB_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_TR_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_TR_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_ABS_VTE_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_VTE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_AMB_QUAL_ENCNTR | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_AMB_QUAL_ENCNTR | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_AMB_QUAL_ENCNTR_2016 | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_AMB_QUAL_ENCNTR_2016 | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_AMB_QUAL_ENCNTR_2017 | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_AMB_QUAL_ENCNTR_2017 | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_AMB_QUAL_ENCNTR_2018 | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_AMB_QUAL_ENCNTR_2018 | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_AMB_QUAL_ENCNTR_2019 | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_AMB_QUAL_ENCNTR_2019 | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_AMB_QUAL_ENCNTR_2020 | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_AMB_QUAL_ENCNTR_2020 | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_AMB_QUAL_ENCNTR_2021 | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_AMB_QUAL_ENCNTR_2021 | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_AMB_QUAL_ENCNTR_2022 | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_AMB_QUAL_ENCNTR_2022 | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_EH_QRDA_ISSUE | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_EH_QRDA_ISSUE | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_AMI_2017_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_AMI_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_AMI_2018_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_AMI_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_AMI_2019_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_AMI_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_AMI_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_APHYBD_2024_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_APHYBD_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_CAC_2017_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_CAC_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_CAC_2018_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_CAC_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_CAC_2019_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_CAC_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_CAC_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_CAC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_ED_2016_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_ED_2017_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_ED_2018_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_ED_2019_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_ED_2020_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_ED_2021_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_ED_2022_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_ED_2023_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_ED_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_EHDI_2017_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_EHDI_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_EHDI_2018_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_EHDI_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_EHDI_2019_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_EHDI_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_GMCS_2024_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_GMCS_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_HEARING_SCREEN_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HEARING_SCREEN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_HH_2023_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HH_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_HH_2024_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HH_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_HTN_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HTN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_HWR_2018_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HWR_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_HWR_2021_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HWR_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_HYBRID_2022_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HYBRID_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_HYBRID_2023_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HYBRID_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_HYBRID_2024_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HYBRID_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_OPIOID_2021_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_OPIOID_2022_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_OPIOID_2023_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_OPIOID_2024_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_ORAE_2024_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ORAE_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_PCB_2020_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_PCB_2021_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_PCB_2022_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_PCB_2023_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_PCB_2024_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_PCM_2020_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_PCM_2021_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_PCM_2022_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_PCM_2023_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_PCM_2024_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_PC_2016_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_PC_2017_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_PC_2018_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_PC_2019_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_PC_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_PN_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_SCIP_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_SCIP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_STEMI_2023_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STEMI_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_STEMI_2024_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STEMI_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_STROKE_2016_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_STROKE_2017_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_STROKE_2018_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_STROKE_2019_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_STROKE_2020_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_STROKE_2021_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_STROKE_2022_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_STROKE_2023_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_STROKE_2024_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_STROKE_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_VTE_2016_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_VTE_2017_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_VTE_2018_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_VTE_2019_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_VTE_2020_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_VTE_2021_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_VTE_2022_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_VTE_2023_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_VTE_2024_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_E_VTE_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_ACT_INTOL_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_ACT_INTOL_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_ACUTE_PAIN_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_ACUTE_PAIN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_AMI_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_ANEMIA_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_ANEMIA_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_CAC_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_CAC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_CHF_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_CHF_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_CRI_ENCNTR_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_CRI_ENCNTR_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_DELIRIUM_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_DELIRIUM_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_DEPRESSION_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_DEPRESSION_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_DYSPHAGIA_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_DYSPHAGIA_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_FALLS_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_FALLS_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_FVE_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_FVE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_GLYCEMIC_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_GLYCEMIC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_HAPU_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_HAPU_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_HH_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_HH_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_HOP_AMI_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_HOP_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_HOP_SURG_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_HOP_SURG_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_IC_MDRO_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_IC_MDRO_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_IC_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_IC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_LHHF_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_LHHF_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_LIPID_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_LIPID_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_MED_AD_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_MED_AD_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_MOD_SEDATION_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_MOD_SEDATION_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_NHIQM_VTE_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_NHIQM_VTE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_PAIN_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_PAIN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_PC_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_PC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_PEDS_MED_AD_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_PEDS_MED_AD_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_PEDS_PAIN_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_PEDS_PAIN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_PEDS_SKIN_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_PEDS_SKIN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_PN_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_PN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_READMISSION_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_READMISSION_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_READMIT_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_READMIT_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_REST_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_REST_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_RRT_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_RRT_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_SCIP_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_SCIP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_SEPSIS_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_SEPSIS_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_SEPSIS_PD_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_SEPSIS_PD_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_SEPSIS_RT_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_SEPSIS_RT_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_STROKE_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_STROKE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_UI_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_UI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_F_VTE_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_VTE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_MU_FX_2_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_MU_FX_2_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_MU_FX_3_ORD_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_MU_FX_3_ORD_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_MU_FX_3_POP_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_MU_FX_3_POP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_QRDA_EC | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_QRDA_EC | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_SDOH_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_SDOH_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_THA_TKA_METRICS | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_THA_TKA_METRICS | HEALTH_SYSTEM_SOURCE_ID |
LH_D_PERSONNEL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_D_PERSONNEL |
Definition: | This table is used to store personnel reference data for the lighthouse quality metrics. |
Table Type: | REFERENCE |
Column Detail - LH_D_PERSONNEL
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
D_PRSNL_ID | DOUBLE | N | Unique identifier for a personnel record. |
VARCHAR(100) | Y | Cerner system E-MAIL identifier for the personnel. | |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the program running the extracts was started. This field should be the same across all files and across all records within a file for a given extraction run. This time should be in UTC time. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data. |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
NAME_FIRST | VARCHAR(100) | Y | The first name for the personnel. |
NAME_FULL | VARCHAR(100) | Y | The full name for the personnel. |
NAME_LAST | VARCHAR(100) | Y | The last name for the personnel. |
NAME_MIDDLE | VARCHAR(100) | Y | The middle name for the personnel. |
PERSON_ID | DOUBLE | Y | Identifies personnel associated with the quality measure. Foreign key to the PRSNL table. |
PROCESS_DT_TM | DATETIME | Y | The date/time the record was first loaded into the table. |
UPDT_CNT | DOUBLE | Y | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_SOURCE | VARCHAR(50) | Y | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | Y | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
USERNAME | VARCHAR(50) | Y | The Millennium username for the person. |
Relationship Detail - LH_D_PERSONNEL
Parent Column in LH_D_PERSONNEL (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | D_PRSNL_ID | LH_ABS_AMI_METRICS | D_ATTEND_PRSNL_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_ABS_CAC_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_CAC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_ABS_CSTK02_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_CSTK02_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_ABS_ED_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_ED_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_ABS_HBIPS_DISC_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HBIPS_DISC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_ABS_HBIPS_EVNT_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HBIPS_EVNT_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_ABS_HF_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HF_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_ABS_HOQR_AMI_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_ABS_HOQR_CATA_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_CATA_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_ABS_HOQR_CP_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_CP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_ABS_HOQR_EBRT_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_EBRT_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_ABS_HOQR_ED_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_ED_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_ABS_HOQR_END29_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_END29_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_ABS_HOQR_END30_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_END30_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_ABS_HOQR_PM_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_PM_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_ABS_HOQR_STK_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_STK_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_ABS_HOQR_SURG_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_SURG_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_ABS_IMM_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_IMM_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_ABS_PC_BF_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PC_BF_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_ABS_PC_BSI_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PC_BSI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_ABS_PC_MOTHER_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PC_MOTHER_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_ABS_PN_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_ABS_SCIP_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_SCIP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_ABS_SMD_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_SMD_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_ABS_STK_OP_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_STK_OP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_ABS_STROKE_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_STROKE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_ABS_SUB_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_SUB_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_ABS_TOB_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_TOB_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_ABS_TR_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_TR_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_ABS_VTE_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_VTE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_AMI_2017_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_AMI_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_AMI_2018_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_AMI_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_AMI_2019_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_AMI_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_AMI_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_APHYBD_2024_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_APHYBD_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_CAC_2017_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_CAC_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_CAC_2018_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_CAC_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_CAC_2019_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_CAC_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_CAC_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_CAC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_ED_2016_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_ED_2017_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_ED_2018_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_ED_2019_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_ED_2020_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_ED_2021_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_ED_2022_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_ED_2023_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_ED_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_EHDI_2017_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_EHDI_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_EHDI_2018_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_EHDI_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_EHDI_2019_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_EHDI_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_GMCS_2024_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_GMCS_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_HEARING_SCREEN_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HEARING_SCREEN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_HH_2023_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HH_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_HH_2024_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HH_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_HTN_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HTN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_HWR_2018_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HWR_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_HWR_2021_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HWR_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_HYBRID_2022_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HYBRID_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_HYBRID_2023_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HYBRID_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_HYBRID_2024_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HYBRID_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_OPIOID_2021_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_OPIOID_2022_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_OPIOID_2023_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_OPIOID_2024_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_ORAE_2024_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ORAE_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_PCB_2020_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_PCB_2021_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_PCB_2022_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_PCB_2023_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_PCB_2024_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_PCM_2020_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_PCM_2021_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_PCM_2022_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_PCM_2023_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_PCM_2024_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_PC_2016_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_PC_2017_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_PC_2018_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_PC_2019_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_PC_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_PN_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_SCIP_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_SCIP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_STEMI_2023_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STEMI_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_STEMI_2024_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STEMI_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_STROKE_2016_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_STROKE_2017_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_STROKE_2018_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_STROKE_2019_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_STROKE_2020_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_STROKE_2021_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_STROKE_2022_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_STROKE_2023_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_STROKE_2024_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_STROKE_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_VTE_2016_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_VTE_2017_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_VTE_2018_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_VTE_2019_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_VTE_2020_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_VTE_2021_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_VTE_2022_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_VTE_2023_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_VTE_2024_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_E_VTE_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_ACT_INTOL_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_ACT_INTOL_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_ACUTE_PAIN_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_ACUTE_PAIN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_AMI_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_ANEMIA_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_ANEMIA_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_CAC_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_CAC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_CHF_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_CHF_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_DELIRIUM_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_DELIRIUM_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_DEPRESSION_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_DEPRESSION_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_DYSPHAGIA_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_DYSPHAGIA_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_FALLS_DTL_METRICS | D_FALL_DOCU_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_FALLS_DTL_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_FVE_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_FVE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_GLYCEMIC_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_GLYCEMIC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_HAPU_DTL_METRICS | D_HAPU_DOCU_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_HAPU_DTL_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_HH_METRICS | D_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_HH_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_HOP_AMI_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_HOP_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_HOP_SURG_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_HOP_SURG_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_IC_MDRO_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_IC_MDRO_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_LHHF_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_LHHF_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_LIPID_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_LIPID_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_MED_AD_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_MED_AD_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_MOD_SEDATION_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_MOD_SEDATION_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_NHIQM_VTE_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_NHIQM_VTE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_PAIN_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_PAIN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_PC_METRICS | D_ATTEND_PRSNL_ID | |
LH_F_PC_METRICS | D_REFER_PRSNL_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_PC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_PC_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_PRSNL_ID | LH_F_PEDS_MED_AD_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_PEDS_MED_AD_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_PEDS_PAIN_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_PEDS_PAIN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_PEDS_SKIN_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_PEDS_SKIN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_PN_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_PN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_READMISSION_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_READMISSION_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_READMIT_METRICS | D_ATTEND_PRSNL_ID | |
LH_F_READMIT_METRICS | D_PCP_ID | ||
LH_F_READMIT_METRICS | D_SURGERY_PRSNL_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_READMIT_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_READMIT_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
LH_F_READMIT_METRICS | HEALTH_SYSTEM_SOURCE_ID | ||
D_PRSNL_ID | LH_F_REST_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_REST_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_RRT_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_RRT_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_SCIP_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_SCIP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_SEPSIS_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_SEPSIS_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_SEPSIS_PD_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_SEPSIS_PD_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_SEPSIS_RT_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_SEPSIS_RT_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_STROKE_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_STROKE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_UI_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_UI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_F_VTE_METRICS | D_VTE_ADV_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_VTE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_MU_FX_2_DETAILS | D_EP_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_MU_FX_2_DETAILS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_MU_FX_2_EP_RELTN | D_EP_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_MU_FX_2_EP_RELTN | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_MU_FX_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_MU_FX_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_QRDA_EC | D_PPR_ID | |
LH_QRDA_EC | D_PRSNL_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_QRDA_EC | HEALTH_SYSTEM_SOURCE_ID | |
LH_QRDA_EC | HEALTH_SYSTEM_SOURCE_ID | ||
D_PRSNL_ID | LH_QRDA_SETUP_DATA | D_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_QRDA_SETUP_DATA | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_SDOH_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_SDOH_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PRSNL_ID | LH_THA_TKA_METRICS | D_ATTEND_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_THA_TKA_METRICS | HEALTH_SYSTEM_SOURCE_ID |
LH_D_PROCEDURE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_D_PROCEDURE |
Definition: | This table is used to store procedure reference data for the lighthouse quality metrics. |
Table Type: | REFERENCE |
Column Detail - LH_D_PROCEDURE
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
CONCEPT_CKI | VARCHAR(255) | Y | CKI from the concept table representing the functional concept. |
D_PROCEDURE_ID | DOUBLE | N | Unique identifier for the procedure. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the program running the extracts was started. This field should be the same across all files and across all records within a file for a given extraction run. This time should be in UTC time. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data. |
LONG_DESCRIPTION | VARCHAR(255) | Y | The long description of the procedure. |
NOMENCLATURE_ID | DOUBLE | Y | Identifies the procedure nomenclature associated with the quality measure. Foreign key to the nomenclature table with a procedure principle type. |
PROCEDURE_CODE | VARCHAR(50) | Y | The code associated with the procedure. |
PROCESS_DT_TM | DATETIME | Y | The date/time the record was first loaded into the table. |
SHORT_DESCRIPTION | VARCHAR(60) | Y | The short description of the procedure. |
SOURCE_VOCABULARY_MEANING | VARCHAR(40) | Y | The vocabulary that contributed the procedure (i.e. ICD9 ICD10 CPT4 etc.) |
SRC_BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date/time on which the record became effective on the source system. |
SRC_END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time on which the record is no longer effective on the source system. |
UPDT_CNT | DOUBLE | Y | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated. |
UPDT_SOURCE | VARCHAR(50) | Y | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | Y | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - LH_D_PROCEDURE
Parent Column in LH_D_PROCEDURE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | D_PROCEDURE_ID | LH_F_ACT_INTOL_METRICS | D_PRIN_PROCEDURE_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_F_ACT_INTOL_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PROCEDURE_ID | LH_F_AMI_METRICS | D_PRIN_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PROCEDURE_ID | LH_F_ANEMIA_METRICS | D_PRIN_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_ANEMIA_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PROCEDURE_ID | LH_F_CAC_METRICS | D_PRIN_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_CAC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PROCEDURE_ID | LH_F_CHF_METRICS | D_PRIN_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_CHF_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PROCEDURE_ID | LH_F_DELIRIUM_METRICS | D_PRIN_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_DELIRIUM_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PROCEDURE_ID | LH_F_DEPRESSION_METRICS | D_PRIN_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_DEPRESSION_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PROCEDURE_ID | LH_F_DYSPHAGIA_METRICS | D_PRIN_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_DYSPHAGIA_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PROCEDURE_ID | LH_F_FVE_METRICS | D_PRIN_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_FVE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PROCEDURE_ID | LH_F_GLYCEMIC_METRICS | D_PRIN_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_GLYCEMIC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PROCEDURE_ID | LH_F_HOP_AMI_METRICS | D_PRIN_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_HOP_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PROCEDURE_ID | LH_F_HOP_SURG_METRICS | D_PRIN_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_HOP_SURG_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PROCEDURE_ID | LH_F_IC_MDRO_METRICS | D_PRIN_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_IC_MDRO_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PROCEDURE_ID | LH_F_LHHF_METRICS | D_PRIN_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_LHHF_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PROCEDURE_ID | LH_F_LIPID_METRICS | D_PRIN_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_LIPID_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PROCEDURE_ID | LH_F_MED_AD_METRICS | D_PRIN_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_MED_AD_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PROCEDURE_ID | LH_F_MOD_SEDATION_METRICS | D_PRIN_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_MOD_SEDATION_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PROCEDURE_ID | LH_F_NHIQM_VTE_METRICS | D_PRIN_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_NHIQM_VTE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PROCEDURE_ID | LH_F_PAIN_METRICS | D_PRIN_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_PAIN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PROCEDURE_ID | LH_F_PEDS_MED_AD_METRICS | D_PRIN_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_PEDS_MED_AD_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PROCEDURE_ID | LH_F_PEDS_PAIN_METRICS | D_PRIN_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_PEDS_PAIN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PROCEDURE_ID | LH_F_PEDS_SKIN_METRICS | D_PRIN_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_PEDS_SKIN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PROCEDURE_ID | LH_F_PN_METRICS | D_PRIN_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_PN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PROCEDURE_ID | LH_F_READMIT_METRICS | D_PRIN_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_READMIT_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PROCEDURE_ID | LH_F_REST_METRICS | D_PRIN_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_REST_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PROCEDURE_ID | LH_F_RRT_METRICS | D_PRIN_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_RRT_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PROCEDURE_ID | LH_F_SCIP_METRICS | D_PRIN_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_SCIP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PROCEDURE_ID | LH_F_SEPSIS_METRICS | D_PRIN_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_SEPSIS_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PROCEDURE_ID | LH_F_STROKE_METRICS | D_PRIN_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_STROKE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_PROCEDURE_ID | LH_F_UI_METRICS | D_PRIN_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_UI_METRICS | HEALTH_SYSTEM_SOURCE_ID |
LH_D_PROV_POSITION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_D_PROV_POSITION |
Definition: | Dimension table for Lighthouse report |
Table Type: | REFERENCE |
Column Detail - LH_D_PROV_POSITION
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | Identifies whether this record is active or has been logically deleted. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date/time on which the record became effective; defaults to 1/01/1800. |
D_PROV_POSITION_ID | DOUBLE | N | Unique identifier for the provider position. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time on which the record is no longer effective; defaults to 12/31/2100. |
EXTRACT_DT_TM | DATETIME | Y | The maximum extraction end date/time of the reporting period |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data. |
PROCESS_DT_TM | DATETIME | Y | The date/time the record was first loaded into the table. |
PROV_POSITION_CD | DOUBLE | N | Source identifier for the provider position |
PROV_POSITION_DESCRIPTION | VARCHAR(60) | Y | The description for the provider position |
PROV_POSITION_DISPLAY | VARCHAR(40) | Y | The display value for the provider position |
PROV_POSITION_MEANING | VARCHAR(40) | Y | The Cerner-defined meaning for the provider position |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. |
UPDT_DT_TM | DATETIME | N | The date/time the row was last inserted or updated. |
UPDT_SOURCE | VARCHAR(50) | N | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | N | The application responsible for updating the record. |
Relationship Detail - LH_D_PROV_POSITION
Parent Column in LH_D_PROV_POSITION (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | D_PROV_POSITION_ID | LH_F_HH_METRICS | D_PROV_POSITION_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_F_HH_METRICS | HEALTH_SYSTEM_SOURCE_ID |