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. |