Table Detail Report
LH_D_BODY_SITE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_D_BODY_SITE |
Definition: | Dimension table to hold Body Site Results for Infection Control Reports |
Table Type: | REFERENCE |
Column Detail - LH_D_BODY_SITE
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. |
BODY_SITE_CD | DOUBLE | N | The coded value of the body site (ankle, arm, ear, etc.). Code set 1028 |
BODY_SITE_DESCRIPTION | VARCHAR(50) | Y | The description of the body site |
BODY_SITE_DISPLAY | VARCHAR(50) | Y | The display value for the body site |
BODY_SITE_MEANING | VARCHAR(50) | Y | The Cerner-identified meaning for the body site |
D_BODY_SITE_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_D_BODY_SITE table. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the program running the extracts was started. This filed should be the same across all files and across all records within a file for a given extraction run. This time should be in UTC time. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data |
PROCESS_DT_TM | DATETIME | Y | The date/time the record wad 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. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_SOURCE | VARCHAR(50) | N | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - LH_D_BODY_SITE
Parent Column in LH_D_BODY_SITE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | D_BODY_SITE_ID | LH_F_IC_MDRO_DTL_METRICS | D_BODY_SITE_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_F_IC_MDRO_DTL_METRICS | HEALTH_SYSTEM_SOURCE_ID |
LH_D_BR_CCN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_D_BR_CCN |
Definition: | This dimention table is used to store CMS Certification Number (CCN) reference data |
Table Type: | REFERENCE |
Column Detail - LH_D_BR_CCN
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. |
BR_CCN_ID | DOUBLE | N | CMS Certification Number (CCN) |
CCN_NAME | VARCHAR(150) | Y | the name associated to the CCN |
CCN_NBR_TXT | VARCHAR(150) | Y | The CCN's identifying number |
D_BR_CCN_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_D_BR_CCN table. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the delivery network responsible for supplying the data. |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for the logical domain. This identifier allows the data to be grouped by logical domain. |
PROCESS_DT_TM | DATETIME | Y | The date/time the record was first loaded into the table. |
TAX_ID_NBR_TXT | VARCHAR(50) | Y | the tax id number associated to the CCN |
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. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_SOURCE | VARCHAR(50) | N | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - LH_D_BR_CCN
Parent Column in LH_D_BR_CCN (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | D_BR_CCN_ID | LH_ABS_AMI_METRICS | D_BR_CCN_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_CAC_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_CAC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_CSTK02_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_CSTK02_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_ED_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_ED_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_HBIPS_DISC_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HBIPS_DISC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_HBIPS_EVNT_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HBIPS_EVNT_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_HBIPS_PATIENTS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HBIPS_PATIENTS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_HF_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HF_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_HOQR_AMI_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_HOQR_CATA_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_CATA_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_HOQR_CP_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_CP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_HOQR_ED_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_ED_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_HOQR_END29_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_END29_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_HOQR_END30_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_END30_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_HOQR_PM_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_PM_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_HOQR_STK_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_STK_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_HOQR_SURG_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_SURG_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_IMM_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_IMM_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_PC_BF_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PC_BF_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_PC_BSI_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PC_BSI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_PC_MOTHER_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PC_MOTHER_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_PC_UNC_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PC_UNC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_PN_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_SAMP_INFO | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_SAMP_INFO | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_SCIP_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_SCIP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_SMD_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_SMD_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_STK_OP_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_STK_OP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_STROKE_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_STROKE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_SUB_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_SUB_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_TOB_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_TOB_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_TR_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_TR_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_ABS_VTE_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_VTE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_EH_QRDA_ISSUE | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_EH_QRDA_ISSUE | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_AMI_2017_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_AMI_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_AMI_2018_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_AMI_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_AMI_2019_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_AMI_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_AMI_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_APHYBD_2024_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_APHYBD_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_CAC_2017_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_CAC_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_CAC_2018_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_CAC_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_CAC_2019_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_CAC_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_CAC_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_CAC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_ED_2016_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_ED_2017_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_ED_2018_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_ED_2019_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_ED_2020_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_ED_2021_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_ED_2022_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_ED_2023_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_ED_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_EHDI_2017_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_EHDI_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_EHDI_2018_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_EHDI_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_EHDI_2019_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_EHDI_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_GMCS_2024_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_GMCS_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_HEARING_SCREEN_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HEARING_SCREEN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_HH_2023_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HH_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_HH_2024_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HH_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_HTN_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HTN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_HWR_2018_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HWR_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_HWR_2021_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HWR_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_HYBRID_2022_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HYBRID_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_HYBRID_2023_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HYBRID_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_HYBRID_2024_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HYBRID_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_OPIOID_2021_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_OPIOID_2022_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_OPIOID_2023_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_OPIOID_2024_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_ORAE_2024_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ORAE_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_PCB_2020_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_PCB_2021_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_PCB_2022_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_PCB_2023_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_PCB_2024_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_PCM_2020_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_PCM_2021_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_PCM_2022_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_PCM_2023_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_PCM_2024_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_PC_2016_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_PC_2017_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_PC_2018_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_PC_2019_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_PC_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_PN_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_SCIP_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_SCIP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_STEMI_2023_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STEMI_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_STEMI_2024_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STEMI_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_STROKE_2016_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_STROKE_2017_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_STROKE_2018_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_STROKE_2019_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_STROKE_2020_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_STROKE_2021_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_STROKE_2022_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_STROKE_2023_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_STROKE_2024_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_STROKE_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_VTE_2016_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_VTE_2017_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_VTE_2018_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_VTE_2019_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_VTE_2020_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_VTE_2021_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_VTE_2022_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_VTE_2023_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_VTE_2024_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_E_VTE_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_SDOH_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_SDOH_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_THA_TKA_METRICS | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_THA_TKA_METRICS | HEALTH_SYSTEM_SOURCE_ID |
LH_D_BR_DATAMART_CATEGORY
Column Section | Top of Page |
Table-level Detail
Description: | LH_D_BR_DATAMART_CATEGORY |
Definition: | This dimension table is used to store Bedrock Category reference data |
Table Type: | REFERENCE |
Column Detail - LH_D_BR_DATAMART_CATEGORY
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. |
BASELINE_TARGET_IND | DOUBLE | N | Determines whether to display baseline/target values. 1 is OFF |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date/time that the record became effective. |
BR_DATAMART_CATEGORY_ID | DOUBLE | N | Unique ID for each category |
CATEGORY_MEAN | VARCHAR(30) | N | Unique string for a category |
CATEGORY_NAME | VARCHAR(100) | N | Category display name |
CATEGORY_TOPIC_MEAN | VARCHAR(30) | Y | Stores a generic meaning for categories that are linked together |
CATEGORY_TYPE_FLAG | DOUBLE | N | Stores the type of reports to be setup - 0 = lighthouse 1 = Mpages 2 = nhiqm |
D_BR_DATAMART_CATEGORY_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_D_BR_DATAMART_CATEGORY table. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time that the record became end effective. |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FLEX_FLAG | DOUBLE | N | Store an indicator of how this category is flexed |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the delivery network responsible for supplying the data. |
PROCESS_DT_TM | DATETIME | Y | The date/time the record was first loaded into the table. |
RELIABILITY_SCORE_IND | DOUBLE | N | Determines whether to display Reliability Score Input Fields. 1 is OFF. |
SCRIPT_NAME | VARCHAR(30) | Y | Name of the ccl script that will be used by Mpages to return data for the category |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. |
UPDT_DT_TM | DATETIME | N | The date/time the row was last inserted or updated. |
UPDT_SOURCE | VARCHAR(50) | N | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | N | The application responsible for updating the record. |
VIEWPOINT_CAPABLE_IND | DOUBLE | N | Indicates whether a category is eligible to be included in an Mpage viewpoint. |
LH_D_BR_HCO
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_D_BR_HCO |
Definition: | This dimention table is used to store Healthcare organization Number (HCO) reference data |
Table Type: | REFERENCE |
Column Detail - LH_D_BR_HCO
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. |
BR_HCO_ID | DOUBLE | N | Healthcare organization Number (HCO) |
D_BR_HCO_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_D_BR_HCO table. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
HCO_NAME | VARCHAR(150) | Y | the name associated to the HCO |
HCO_NBR | DOUBLE | N | The number assigned by The Joint Commission to a healthcare organization. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the delivery network responsible for supplying the data. |
LOGICAL_DOMAIN_ID | DOUBLE | N | LOGICAL DOMAIN |
PROCESS_DT_TM | DATETIME | Y | The date/time the record was first loaded into the table. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_SOURCE | VARCHAR(50) | N | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - LH_D_BR_HCO
Child Column in LH_D_BR_HCO(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |
Parent Column in LH_D_BR_HCO (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | D_BR_HCO_ID | LH_ABS_AMI_METRICS | D_BR_HCO_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_CAC_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_CAC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_CSTK02_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_CSTK02_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_ED_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_ED_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_HBIPS_DISC_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HBIPS_DISC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_HBIPS_EVNT_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HBIPS_EVNT_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_HBIPS_PATIENTS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HBIPS_PATIENTS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_HF_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HF_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_HOQR_AMI_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_HOQR_CATA_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_CATA_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_HOQR_CP_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_CP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_HOQR_EBRT_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_EBRT_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_HOQR_ED_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_ED_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_HOQR_END29_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_END29_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_HOQR_END30_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_END30_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_HOQR_PM_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_PM_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_HOQR_STK_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_STK_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_HOQR_SURG_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_SURG_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_IMM_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_IMM_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_PC_BF_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PC_BF_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_PC_BSI_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PC_BSI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_PC_MOTHER_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PC_MOTHER_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_PC_UNC_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PC_UNC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_PN_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_SAMP_INFO | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_SAMP_INFO | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_SCIP_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_SCIP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_SMD_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_SMD_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_STK_OP_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_STK_OP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_STROKE_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_STROKE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_SUB_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_SUB_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_TOB_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_TOB_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_TR_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_TR_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_ABS_VTE_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_VTE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_EH_QRDA_ISSUE | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_EH_QRDA_ISSUE | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_AMI_2017_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_AMI_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_AMI_2018_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_AMI_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_AMI_2019_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_AMI_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_AMI_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_APHYBD_2024_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_APHYBD_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_CAC_2017_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_CAC_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_CAC_2018_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_CAC_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_CAC_2019_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_CAC_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_CAC_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_CAC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_ED_2016_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_ED_2017_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_ED_2018_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_ED_2019_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_ED_2020_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_ED_2021_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_ED_2022_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_ED_2023_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_ED_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_EHDI_2017_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_EHDI_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_EHDI_2018_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_EHDI_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_EHDI_2019_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_EHDI_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_GMCS_2024_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_GMCS_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_HEARING_SCREEN_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HEARING_SCREEN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_HH_2023_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HH_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_HH_2024_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HH_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_HTN_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HTN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_HWR_2018_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HWR_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_HWR_2021_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HWR_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_HYBRID_2022_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HYBRID_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_HYBRID_2023_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HYBRID_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_HYBRID_2024_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HYBRID_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_OPIOID_2021_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_OPIOID_2022_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_OPIOID_2023_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_OPIOID_2024_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_ORAE_2024_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ORAE_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_PCB_2020_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_PCB_2021_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_PCB_2022_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_PCB_2023_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_PCB_2024_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_PCM_2020_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_PCM_2021_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_PCM_2022_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_PCM_2023_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_PCM_2024_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_PC_2016_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_PC_2017_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_PC_2018_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_PC_2019_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_PC_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_PN_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_SCIP_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_SCIP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_STEMI_2023_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STEMI_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_STEMI_2024_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STEMI_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_STROKE_2016_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_STROKE_2017_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_STROKE_2018_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_STROKE_2019_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_STROKE_2020_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_STROKE_2021_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_STROKE_2022_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_STROKE_2023_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_STROKE_2024_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_STROKE_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_VTE_2016_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_VTE_2017_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_VTE_2018_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_VTE_2019_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_VTE_2020_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_VTE_2021_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_VTE_2022_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_VTE_2023_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_VTE_2024_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_E_VTE_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_SDOH_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_SDOH_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_THA_TKA_METRICS | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_THA_TKA_METRICS | HEALTH_SYSTEM_SOURCE_ID |
LH_D_BR_NAME_VALUE
Column Section | Top of Page |
Table-level Detail
Description: | LH_D_BR_NAME_VALUE |
Definition: | This table contains the information about br_eligible_provider |
Table Type: | REFERENCE |
Column Detail - LH_D_BR_NAME_VALUE
Column Name | Type | Null? | Definition |
---|---|---|---|
BNV_UPDT_DT_TM | DATETIME | Y | Date and time coming from br_name_value |
BNV_UPDT_ID | DOUBLE | Y | updt_id coming from br_name_value table |
BNV_UPDT_PRSNL_NAME | VARCHAR(200) | Y | Name coming from prsnl table |
BR_CLIENT_ID | DOUBLE | Y | Identifies which bedrock client data belongs to |
BR_NAME | VARCHAR(50) | Y | Name value coming br_name_value table |
BR_NAME_VALUE_ID | DOUBLE | Y | Date and time when the load was run and the row qualified |
BR_NV_KEY | VARCHAR(50) | Y | Key value coming br_name_value table |
BR_VALUE | DOUBLE | Y | Code Value coming from br_name_value table |
BR_VALUE_TEXT | VARCHAR(50) | Y | Display of the br_value field |
DEFAULT_SELECTED_IND | DOUBLE | Y | Defined as 1 the name value should default in as selected. |
EXTRACT_DT_TM | DATETIME | Y | Date and time when the load was run |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data |
LH_D_BR_NAME_VALUE_ID | DOUBLE | N | PRIMARY KEY |
PROCESS_DT_TM | DATETIME | Y | Process date and time |
START_VERSION_NBR | DOUBLE | Y | Identifies which version of start has been loaded |
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(100) | Y | Source through which the row was updated |
UPDT_TASK | VARCHAR(100) | 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. |