LH_DELETE_TRACKING



Column Section Top of Page


Table-level Detail

Description: LH_DELETE_TRACKING
Definition: Track deletes on selected LH tables.
Table Type: ACTIVITY





Column Detail - LH_DELETE_TRACKING


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
HEALTH_SYSTEM_SOURCE_ID DOUBLE Y Identifies the unique source within the delivery network responsible for supplying the data.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_DELETE_TRACKING_ID DOUBLE N SEQUENCE NAME:REFERENCE_SEQ, Unique generated number that identifies a single row on the LH_DELETE_TRACKING table.
PROCESS_DT_TM DATETIME Y The date/time the record was processed
TABLE_NAME VARCHAR(30) Y The name of the table the row was deleted from.
TABLE_PK_VALUE DOUBLE Y The PK value corresponding to the PK of TABLE_NAME.
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_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.


LH_D_ADMIT_SRC



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - LH_D_ADMIT_SRC


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ADMIT_SRC_CD DOUBLE Y Identifies the admission source associated with the quality measure. Foreign key to the code_value table for code set 2.
ADMIT_SRC_DESCRIPTION VARCHAR(40) Y The description of the admission source.
ADMIT_SRC_DISPLAY VARCHAR(40) Y The display value for the admission source.
ADMIT_SRC_MEANING VARCHAR(40) Y The Cerner-defined meaning for the admission source.
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_ADMIT_SRC_ID DOUBLE N Unique identifier for the admit source.
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.
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_ADMIT_SRC




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


LH_D_ADMIT_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_D_ADMIT_TYPE
Definition: This is a dimension table used to store admission type data for Lighthouse Reporting.
Table Type: REFERENCE





Column Detail - LH_D_ADMIT_TYPE


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ADMIT_TYPE_CD DOUBLE N Source identifier for the admit type.
ADMIT_TYPE_DESCRIPTION VARCHAR(255) Y The description of the admit type.
ADMIT_TYPE_DISPLAY VARCHAR(40) Y The display value for the admit type.
ADMIT_TYPE_MEANING VARCHAR(40) Y The Cerner-defined meaning for the admit type.
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_ADMIT_TYPE_ID DOUBLE N Unique identifier for the admit type dimension.
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 record was extracted from the source system.
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 on which the record was first loaded into the table.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_SOURCE VARCHAR(50) N The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - LH_D_ADMIT_TYPE




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


LH_D_BED



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_D_BED
Definition: Dimension table to hold BED Results for Infection Control Reports
Table Type: REFERENCE





Column Detail - LH_D_BED


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BED_DESCRIPTION VARCHAR(50) Y The description of the bed
BED_DISPLAY VARCHAR(50) Y The display value for the bed
BED_MEANING VARCHAR(50) Y The Cerner-identified meaning for the bed
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_BED_ID DOUBLE N Unique generated number that identifies a single row on the LH_D_BED table.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
EXTRACT_DT_TM DATETIME Y The date/time that the program running the extracts was started. This filed 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_BED_CD DOUBLE N This field is the patient location with a location type of bed. Code set 220
PROCESS_DT_TM DATETIME Y The date/time the record was first loaded into the table.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_SOURCE VARCHAR(50) N The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - LH_D_BED




Parent Column in LH_D_BED (PK) Child Table Name Child Column Name
Children: D_BED_ID LH_F_IC_MDRO_DTL_METRICS D_COLL_BED_ID
LH_F_IC_MDRO_DTL_METRICS D_COLL_PREV_BED_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


LH_D_BEDROCK



Column Section Top of Page


Table-level Detail

Description: LH_D_BEDROCK
Definition: This table contains the information about the bedrock configurations.
Table Type: REFERENCE





Column Detail - LH_D_BEDROCK


Column Name Type Null? Definition
BR_DATAMART_CATEGORY_ID DOUBLE Y BR_DATAMART_CATEGORY_ID from br_datamart_category_id table
BR_DATAMART_FILTER_ID DOUBLE Y Filter Id from br_datamart_filter table
BR_DATAMART_REPORT_ID DOUBLE Y Report Id from br_datamart_report table
BR_DATAMART_VALUE_ID DOUBLE Y Value Id from br_datamart_value table
CATEGORY_MEAN VARCHAR(30) Y Category Mean from category table
CATEGORY_NAME VARCHAR(100) Y Category Name from category table
EXTRACT_DT_TM DATETIME Y Date and time when the row was updated
FILTER_DISPLAY VARCHAR(100) Y Filter Name from br_datamart_filter table
FILTER_MEAN VARCHAR(30) Y Filter Mean from br_datamart_filter table
FREETEXT_DESC VARCHAR(255) Y Freetext Desc from br_datamart_value table
GROUP_SEQ DOUBLE Y Group Seq from br_datamart_value table
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the
LH_D_BEDROCK_ID DOUBLE N Unique generated number that identifies a single row on the LH_D_BEDROCK table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
MAP_DATA_TYPE_CD DOUBLE Y MAP_DATA_TYPE_CD from br_datamart_value table
MPAGE_PARAM_MEAN VARCHAR(25) Y MPAGE_PARAM_MEAN from br_datamart_value table
MPAGE_PARAM_VALUE VARCHAR(255) Y MPAGE_PARAM_VALUE from br_datamart_value table
PARENT_ENTITY_ID DOUBLE Y Parent Entity Id from br_datamart_value table
PARENT_ENTITY_ID2 DOUBLE Y PARENT_ENTITY_ID2 from br_datamart_value table
PARENT_ENTITY_ID_VALUE DOUBLE Y Parent Entity Id from br_datamart_value table
PARENT_ENTITY_ID_VALUE_DISP VARCHAR(255) Y Value Display for the parent_entity_id column from br_datamart_value table i.e. "" uar_get_code_display(val.parent_entity_id) ""
PARENT_ENTITY_NAME VARCHAR(50) Y Entity Name from br_datamart_value
PARENT_ENTITY_NAME2 VARCHAR(50) Y PARENT_ENTITY_NAME2 from br_datamart_value table
PROCESS_DT_TM DATETIME Y Date and time when the row was processed
QUALIFIER_FLAG DOUBLE Y Qualifier Flag from br_datamart_value table, 0 - Equal, 1 - Not equal, 2 - Greater than.
REPORT_MEAN VARCHAR(30) Y Report Mean from report table
REPORT_NAME VARCHAR(200) Y Report Name from report table
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_SOURCE VARCHAR(50) N The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
VALUE_SEQ DOUBLE Y Value Seq from br_datamart_value table
VALUE_TYPE_FLAG DOUBLE Y Type Flag from br_datamart_value table. 0 - Numeric, 1 - Freetext, 2 - Alpha.