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.