Table Detail Report

LH_D_DISCH_DISP



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_D_DISCH_DISP
Definition: This is a dimension table used to store discharge_disposition data for Lighthouse Reporting.
Table Type: REFERENCE





Column Detail - LH_D_DISCH_DISP


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.
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.
DISCH_DISP_CD DOUBLE N Source identifier for the discharge disposition.
DISCH_DISP_DESCRIPTION VARCHAR(255) Y The description of the discharge disposition.
DISCH_DISP_DISPLAY VARCHAR(40) Y The display value for the discharge disposition.
DISCH_DISP_MEANING VARCHAR(40) Y The Cerner-defined meaning for the discharge disposition.
D_DISCH_DISP_ID DOUBLE N Unique identifier for the discharge disposition 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_DISCH_DISP




Parent Column in LH_D_DISCH_DISP (PK) Child Table Name Child Column Name
Children: D_DISCH_DISP_ID LH_ABS_AMI_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_AMI_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_ABS_CSTK02_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_CSTK02_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_ABS_IMM_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_IMM_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_ABS_PC_BF_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_PC_BF_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_ABS_PC_BSI_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_PC_BSI_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_ABS_PC_MOTHER_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_PC_MOTHER_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_ABS_PC_UNC_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_PC_UNC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_ABS_PN_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_PN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_ABS_SCIP_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_SCIP_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_ABS_STK_OP_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_STK_OP_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_ABS_SUB_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_SUB_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_ABS_TOB_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_TOB_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_AMI_2018_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_AMI_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_AMI_2019_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_AMI_2019_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_AMI_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_AMI_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_APHYBD_2024_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_APHYBD_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_CAC_2019_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_CAC_2019_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_CAC_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_CAC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_ED_2016_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2016_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_ED_2017_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_ED_2018_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_ED_2019_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2019_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_ED_2020_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2020_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_ED_2021_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_ED_2022_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_ED_2023_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_ED_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ED_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_EHDI_2019_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_EHDI_2019_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_GMCS_2024_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_GMCS_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_HEARING_SCREEN_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HEARING_SCREEN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_HH_2023_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HH_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_HH_2024_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HH_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_HTN_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HTN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_HWR_2021_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HWR_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_HYBRID_2022_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HYBRID_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_HYBRID_2023_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HYBRID_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_HYBRID_2024_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_HYBRID_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_OPIOID_2021_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_OPIOID_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_OPIOID_2022_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_OPIOID_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_OPIOID_2023_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_OPIOID_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_OPIOID_2024_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_OPIOID_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_ORAE_2024_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_ORAE_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_PCB_2020_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCB_2020_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_PCB_2021_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCB_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_PCB_2022_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCB_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_PCB_2023_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCB_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_PCB_2024_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCB_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_PCM_2020_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCM_2020_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_PCM_2021_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCM_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_PCM_2022_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCM_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_PCM_2023_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCM_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_PCM_2024_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PCM_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_PC_2016_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PC_2016_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_PC_2017_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PC_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_PC_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_PN_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_PN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_SCIP_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_SCIP_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_STEMI_2023_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STEMI_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_STEMI_2024_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STEMI_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_STROKE_2016_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2016_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_STROKE_2017_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_STROKE_2018_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_STROKE_2019_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2019_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_STROKE_2020_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2020_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_STROKE_2021_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_STROKE_2022_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_STROKE_2023_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_STROKE_2024_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_STROKE_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_STROKE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_VTE_2016_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2016_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_VTE_2017_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2017_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_VTE_2018_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2018_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_VTE_2019_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2019_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_VTE_2020_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2020_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_VTE_2021_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2021_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_VTE_2022_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2022_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_VTE_2023_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2023_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_VTE_2024_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_2024_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_E_VTE_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_E_VTE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_ACT_INTOL_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_ACT_INTOL_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_ACUTE_PAIN_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_ACUTE_PAIN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_AMI_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_AMI_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_ANEMIA_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_ANEMIA_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_CAC_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_CAC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_CHF_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_CHF_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_DELIRIUM_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_DELIRIUM_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_DEPRESSION_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_DEPRESSION_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_DYSPHAGIA_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_DYSPHAGIA_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_FVE_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_FVE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_GLYCEMIC_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_GLYCEMIC_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_HOP_AMI_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_HOP_AMI_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_HOP_SURG_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_HOP_SURG_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_IC_MDRO_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_IC_MDRO_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_LHHF_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_LHHF_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_LIPID_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_LIPID_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_MED_AD_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_MED_AD_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_MOD_SEDATION_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_MOD_SEDATION_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_NHIQM_VTE_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_NHIQM_VTE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_PAIN_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_PAIN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_PEDS_MED_AD_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_PEDS_MED_AD_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_PEDS_PAIN_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_PEDS_PAIN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_PEDS_SKIN_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_PEDS_SKIN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_PN_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_PN_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_READMISSION_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_READMISSION_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_READMIT_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_READMIT_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_REST_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_REST_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_RRT_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_RRT_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_SCIP_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_SCIP_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_SEPSIS_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_SEPSIS_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_SEPSIS_PD_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_SEPSIS_PD_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_SEPSIS_RT_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_SEPSIS_RT_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_STROKE_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_STROKE_METRICS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_F_UI_METRICS D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_UI_METRICS HEALTH_SYSTEM_SOURCE_ID


LH_D_ENCNTR_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - LH_D_ENCNTR_TYPE


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_ENCNTR_TYPE_ID DOUBLE N Unique identifier for the encounter type.
ENCNTR_TYPE_CD DOUBLE Y Identifies the encounter type associated with the quality measure. Foreign key to the code_value table for code set 71.
ENCNTR_TYPE_DESCRIPTION VARCHAR(40) Y The description of the encounter type.
ENCNTR_TYPE_DISPLAY VARCHAR(40) Y The display value for the encounter type.
ENCNTR_TYPE_MEANING VARCHAR(40) Y The Cerner-defined meaning for the encounter type.
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_ENCNTR_TYPE




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


LH_D_EP_MIPS



Column Section Top of Page


Table-level Detail

Description: LH_D_EP_MIPS
Definition: This table contains the information about br_eligible_provider.
Table Type: REFERENCE





Column Detail - LH_D_EP_MIPS


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.
BR_ELIGIBLE_PROVIDER_ID DOUBLE N Unique, generated number that identifies a single row on the BR_ELIGIBLE_PROVIDER table.
D_NURSE_UNIT_ID DOUBLE N The unique key from the lh_d_nurse_unit 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.
EP_NAME VARCHAR(250) Y Name of the provider/physician
EXTRACT_DT_TM DATETIME Y Extract date of the record
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
GPRO_ID DOUBLE N The primary key of the BR_GPRO table
GPRO_NAME VARCHAR(250) Y Name of the TIN from the BR_GPRO table
HEALTH_SYSTEM_SOURCE_ID DOUBLE N 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_D_EP_MIPS_ID DOUBLE N Unique generated number that identifies a single row on the LH_D_EP_MIPS table.
LOC_NURSE_UNIT_CD DOUBLE N CODE SET:220 This field identifies the current permanent location of the patient. The location for an inpatient will be valued with the lowest level location type in the hierarchy of facility, building, nurse unit, room, bed.
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.
NPI_TXT VARCHAR(200) Y Stores the eligible providers's national provider number.
TAX_ID_NBR_TXT VARCHAR(250) Y Stores the TIN or tax id number from the BR_GPRO 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 source which updated/inserted the row
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_EP_MIPS_S3



Column Section Top of Page


Table-level Detail

Description: LH_D_EP_MIPS_S3
Definition: This table contains the information about br_eligible_provider.N I it s a clone of table LH_D_EP_MIPS. It is needed due to an issue where a change for Stage 3 code would break stage 2 code, This way, stage 2 code can use the original LH_D_EP_MIPS table and the stage 3 code can use the new LH_D_EP_MIPS_S3 table and Stage 3 code change will not affect the data on the LH_D_EP_MIPS.
Table Type: REFERENCE





Column Detail - LH_D_EP_MIPS_S3


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.
BR_ELIGIBLE_PROVIDER_ID DOUBLE N Unique, generated number that identifies a single row on the BR_ELIGIBLE_PROVIDER table.
D_NURSE_UNIT_ID DOUBLE N The unique key from the lh_d_nurse_unit 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.
EP_NAME VARCHAR(250) Y Name of the provider/physician
EXTRACT_DT_TM DATETIME Y Extract date of the record
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
GPRO_ID DOUBLE N The primary key of the BR_GPRO table
GPRO_NAME VARCHAR(250) Y Name of the TIN from the BR_GPRO table
HEALTH_SYSTEM_SOURCE_ID DOUBLE N 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_D_EP_MIPS_S3_ID DOUBLE N Unique generated number that identifies a single row on the LH_D_EP_MIPS_S3 table.
LOC_NURSE_UNIT_CD DOUBLE N 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.
NPI_TXT VARCHAR(200) Y Stores the eligible providers's national provider number.
TAX_ID_NBR_TXT VARCHAR(250) Y Stores the TIN or tax id number from the BR_GPRO 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 source which updated/inserted the row
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_EP_TIER_PROGRAM



Column Section Top of Page


Table-level Detail

Description: LH_D_EP_TIER_PROGRAM
Definition: This table contains the ep info
Table Type: REFERENCE





Column Detail - LH_D_EP_TIER_PROGRAM


Column Name Type Null? Definition
BR_ELIGIBLE_PROVIDER_ID DOUBLE N Id for the providers to identity them
BR_ELIGIBLE_PROV_UPDT_DT_TM DATETIME Y Date and time the row was updated in the br_group_prov table
BR_ELIGIBLE_PROV_UPDT_PRSNL_NM VARCHAR(100) Y This column contains the full name of the personnel who updated the Eligible Provider information in bedrock.
BR_EP_ACTIVE_IND DOUBLE Y Active ind
BR_GROUP_RELTN_UPDT_DT_TM DATETIME Y Date and time the row was updated in the br_group_reltn table
BR_GROUP_RELTN_UPDT_PRSNL_NM VARCHAR(100) Y This column contains the full name of the personnel who updated the tier information in bedrock.
EP_NAME VARCHAR(100) Y The name of the Provider
EXTRACT_DT_TM DATETIME Y Date and time when the load was run and the row qualified
HEALTH_SYSTEM_SOURCE_ID DOUBLE N This column is needed for all lh_d_* tables
LH_D_EP_TIER_PROGRAM_ID DOUBLE N Unique generated number that identifies a single row on the LH_D_EP_TIER_PROGRAM 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.
MEDICAID_ACTIVE_IND DOUBLE Y Active ind for the medicaid row
MEDICAID_BEG_EFFECTIVE_DT_TM DATETIME Y The beg date and time for medicaid row
MEDICAID_END_EFFECTIVE_DT_TM DATETIME Y #REF!
MEDICAID_PROGRAM_ID DOUBLE N The program id for the medicaid row
MEDICAID_STAGE_CD DOUBLE N The cd value for the medicaid rows ( e.g. S2Y2)
MEDICAID_UPDT_DT_TM DATETIME Y update Date and time for the medicaid row
MEDICARE_ACTIVE_IND DOUBLE Y Active ind for medicare row
MEDICARE_BEG_EFFECTIVE_DT_TM DATETIME Y The beg date and time for medicare row
MEDICARE_END_EFFECTIVE_DT_TM DATETIME Y The end date and time for medicaid row
MEDICARE_PROGRAM_ID DOUBLE N The program id for medicare
MEDICARE_UPDT_DT_TM DATETIME Y update date and time for the medicare row
MEDICARE_YEAR VARCHAR(50) Y The year the provider is configured as MEDICARE
NPI_TXT VARCHAR(50) Y The unique number to identify the Provider
PERSONNEL_ACTIVE_IND DOUBLE Y Active ind
PERSON_ID DOUBLE N Id for the provider coming from prsnl table
PROCESS_DT_TM DATETIME Y Date and time when the load was run and the row qualified
TIER1_ID DOUBLE N The id of the tier the ep is associated with
TIER1_NAME VARCHAR(100) Y The name of the Tier the ep is associated with
TIER2_ID DOUBLE N The id of the tier the ep is associated with
TIER2_NAME VARCHAR(100) Y The name of the Tier the ep is associated with
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 Source which updated the row
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.