LH_DELETE_TRACKING
Column Section | Top of Page |
Table-level Detail
Description: | LH_DELETE_TRACKING |
Definition: | Track deletes on selected LH tables. |
Table Type: | ACTIVITY |
Column Detail - LH_DELETE_TRACKING
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time that the first ETL process started that created this record. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | Y | Identifies the unique source within the delivery network responsible for supplying the data. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
LH_DELETE_TRACKING_ID | DOUBLE | N | SEQUENCE NAME:REFERENCE_SEQ, Unique generated number that identifies a single row on the LH_DELETE_TRACKING table. |
PROCESS_DT_TM | DATETIME | Y | The date/time the record was processed |
TABLE_NAME | VARCHAR(30) | Y | The name of the table the row was deleted from. |
TABLE_PK_VALUE | DOUBLE | Y | The PK value corresponding to the PK of TABLE_NAME. |
UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | VARCHAR(50) | Y | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
LH_D_ADMIT_SRC
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_D_ADMIT_SRC |
Definition: | This table is used to store admission source reference data for the lighthouse quality metrics. |
Table Type: | REFERENCE |
Column Detail - LH_D_ADMIT_SRC
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ADMIT_SRC_CD | DOUBLE | Y | Identifies the admission source associated with the quality measure. Foreign key to the code_value table for code set 2. |
ADMIT_SRC_DESCRIPTION | VARCHAR(40) | Y | The description of the admission source. |
ADMIT_SRC_DISPLAY | VARCHAR(40) | Y | The display value for the admission source. |
ADMIT_SRC_MEANING | VARCHAR(40) | Y | The Cerner-defined meaning for the admission source. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
CONCEPT_CKI | VARCHAR(255) | Y | CKI from the concept table representing the functional concept. |
D_ADMIT_SRC_ID | DOUBLE | N | Unique identifier for the admit source. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the program running the extracts was started. This field should be the same across all files and across all records within a file for a given extraction run. This time should be in UTC time. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data. |
PROCESS_DT_TM | DATETIME | Y | The date/time the record was first loaded into the table. |
UPDT_CNT | DOUBLE | Y | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_SOURCE | VARCHAR(50) | Y | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | Y | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - LH_D_ADMIT_SRC
Parent Column in LH_D_ADMIT_SRC (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | D_ADMIT_SRC_ID | LH_ABS_AMI_METRICS | D_ADMIT_SRC_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_ABS_CAC_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_CAC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_ABS_CSTK02_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_CSTK02_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_ABS_ED_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_ED_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_ABS_HBIPS_DISC_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HBIPS_DISC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_ABS_HBIPS_EVNT_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HBIPS_EVNT_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_ABS_HF_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HF_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_ABS_HOQR_AMI_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_ABS_HOQR_CATA_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_CATA_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_ABS_HOQR_CP_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_CP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_ABS_HOQR_EBRT_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_EBRT_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_ABS_HOQR_ED_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_ED_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_ABS_HOQR_END29_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_END29_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_ABS_HOQR_END30_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_END30_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_ABS_HOQR_PM_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_PM_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_ABS_HOQR_STK_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_STK_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_ABS_HOQR_SURG_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_SURG_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_ABS_IMM_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_IMM_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_ABS_PC_BF_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PC_BF_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_ABS_PC_BSI_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PC_BSI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_ABS_PC_MOTHER_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PC_MOTHER_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_ABS_PC_UNC_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PC_UNC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_ABS_PN_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_ABS_SCIP_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_SCIP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_ABS_SMD_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_SMD_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_ABS_STK_OP_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_STK_OP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_ABS_STROKE_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_STROKE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_ABS_SUB_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_SUB_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_ABS_TOB_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_TOB_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_ABS_TR_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_TR_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_ABS_VTE_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_VTE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_AMI_2017_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_AMI_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_AMI_2018_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_AMI_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_AMI_2019_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_AMI_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_AMI_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_APHYBD_2024_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_APHYBD_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_CAC_2017_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_CAC_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_CAC_2018_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_CAC_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_CAC_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_CAC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_ED_2016_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_ED_2017_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_ED_2018_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_ED_2019_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_ED_2020_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_ED_2021_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_ED_2022_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_ED_2023_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_ED_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_EHDI_2017_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_EHDI_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_EHDI_2018_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_EHDI_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_GMCS_2024_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_GMCS_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_HEARING_SCREEN_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HEARING_SCREEN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_HH_2023_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HH_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_HH_2024_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HH_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_HTN_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HTN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_HWR_2018_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HWR_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_HWR_2021_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HWR_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_HYBRID_2022_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HYBRID_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_HYBRID_2023_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HYBRID_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_HYBRID_2024_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HYBRID_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_OPIOID_2021_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_OPIOID_2022_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_OPIOID_2023_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_OPIOID_2024_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_ORAE_2024_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ORAE_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_PCB_2020_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_PCB_2021_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_PCB_2022_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_PCB_2023_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_PCB_2024_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_PCM_2020_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_PCM_2021_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_PCM_2022_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_PCM_2023_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_PCM_2024_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_PC_2016_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_PC_2017_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_PC_2018_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_PC_2019_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_PC_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_PN_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_SCIP_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_SCIP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_STEMI_2023_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STEMI_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_STEMI_2024_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STEMI_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_STROKE_2016_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_STROKE_2017_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_STROKE_2018_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_STROKE_2020_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_STROKE_2021_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_STROKE_2022_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_STROKE_2023_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_STROKE_2024_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_STROKE_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_VTE_2016_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_VTE_2017_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_VTE_2018_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_VTE_2020_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_VTE_2021_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_VTE_2022_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_VTE_2023_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_VTE_2024_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_E_VTE_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_ACT_INTOL_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_ACT_INTOL_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_ACUTE_PAIN_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_ACUTE_PAIN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_AMI_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_ANEMIA_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_ANEMIA_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_CAC_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_CAC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_CHF_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_CHF_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_CRI_ENCNTR_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_CRI_ENCNTR_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_DELIRIUM_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_DELIRIUM_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_DEPRESSION_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_DEPRESSION_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_DYSPHAGIA_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_DYSPHAGIA_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_FALLS_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_FALLS_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_FVE_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_FVE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_GLYCEMIC_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_GLYCEMIC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_HAPU_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_HAPU_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_HOP_AMI_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_HOP_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_HOP_SURG_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_HOP_SURG_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_IC_MDRO_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_IC_MDRO_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_LHHF_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_LHHF_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_LIPID_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_LIPID_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_MED_AD_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_MED_AD_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_MOD_SEDATION_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_MOD_SEDATION_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_NHIQM_VTE_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_NHIQM_VTE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_PAIN_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_PAIN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_PC_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_PC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_PEDS_MED_AD_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_PEDS_MED_AD_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_PEDS_PAIN_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_PEDS_PAIN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_PEDS_SKIN_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_PEDS_SKIN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_PN_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_PN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_READMISSION_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_READMISSION_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_READMIT_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_READMIT_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_REST_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_REST_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_RRT_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_RRT_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_SCIP_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_SCIP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_SEPSIS_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_SEPSIS_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_SEPSIS_PD_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_SEPSIS_PD_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_SEPSIS_RT_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_SEPSIS_RT_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_STROKE_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_STROKE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_UI_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_UI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_SRC_ID | LH_F_VTE_METRICS | D_ADMIT_SRC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_VTE_METRICS | HEALTH_SYSTEM_SOURCE_ID |
LH_D_ADMIT_TYPE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_D_ADMIT_TYPE |
Definition: | This is a dimension table used to store admission type data for Lighthouse Reporting. |
Table Type: | REFERENCE |
Column Detail - LH_D_ADMIT_TYPE
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ADMIT_TYPE_CD | DOUBLE | N | Source identifier for the admit type. |
ADMIT_TYPE_DESCRIPTION | VARCHAR(255) | Y | The description of the admit type. |
ADMIT_TYPE_DISPLAY | VARCHAR(40) | Y | The display value for the admit type. |
ADMIT_TYPE_MEANING | VARCHAR(40) | Y | The Cerner-defined meaning for the admit type. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
D_ADMIT_TYPE_ID | DOUBLE | N | Unique identifier for the admit type dimension. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data. |
PROCESS_DT_TM | DATETIME | Y | The date/time on which the record was first loaded into the table. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_SOURCE | VARCHAR(50) | N | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - LH_D_ADMIT_TYPE
Parent Column in LH_D_ADMIT_TYPE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | D_ADMIT_TYPE_ID | LH_ABS_AMI_METRICS | D_ADMIT_TYPE_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_ABS_CAC_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_CAC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_ABS_CSTK02_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_CSTK02_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_ABS_ED_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_ED_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_ABS_HBIPS_DISC_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HBIPS_DISC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_ABS_HBIPS_EVNT_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HBIPS_EVNT_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_ABS_HF_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HF_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_ABS_HOQR_AMI_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_ABS_HOQR_CATA_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_CATA_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_ABS_HOQR_CP_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_CP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_ABS_HOQR_EBRT_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_EBRT_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_ABS_HOQR_ED_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_ED_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_ABS_HOQR_END29_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_END29_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_ABS_HOQR_END30_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_END30_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_ABS_HOQR_PM_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_PM_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_ABS_HOQR_STK_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_STK_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_ABS_HOQR_SURG_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HOQR_SURG_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_ABS_IMM_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_IMM_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_ABS_PC_BF_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PC_BF_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_ABS_PC_BSI_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PC_BSI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_ABS_PC_MOTHER_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PC_MOTHER_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_ABS_PC_UNC_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PC_UNC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_ABS_PN_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_PN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_ABS_SCIP_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_SCIP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_ABS_SMD_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_SMD_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_ABS_STK_OP_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_STK_OP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_ABS_STROKE_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_STROKE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_ABS_SUB_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_SUB_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_ABS_TOB_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_TOB_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_ABS_TR_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_TR_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_ABS_VTE_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_VTE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_AMI_2017_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_AMI_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_AMI_2018_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_AMI_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_AMI_2019_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_AMI_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_AMI_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_APHYBD_2024_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_APHYBD_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_CAC_2017_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_CAC_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_CAC_2018_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_CAC_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_CAC_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_CAC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_ED_2016_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_ED_2017_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_ED_2018_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_ED_2019_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_ED_2020_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_ED_2021_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_ED_2022_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_ED_2023_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_ED_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ED_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_EHDI_2017_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_EHDI_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_EHDI_2018_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_EHDI_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_GMCS_2024_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_GMCS_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_HEARING_SCREEN_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HEARING_SCREEN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_HH_2023_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HH_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_HH_2024_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HH_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_HTN_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HTN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_HWR_2018_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HWR_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_HWR_2021_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HWR_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_HYBRID_2022_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HYBRID_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_HYBRID_2023_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HYBRID_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_HYBRID_2024_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_HYBRID_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_OPIOID_2021_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_OPIOID_2022_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_OPIOID_2023_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_OPIOID_2024_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_OPIOID_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_ORAE_2024_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_ORAE_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_PCB_2020_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_PCB_2021_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_PCB_2022_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_PCB_2023_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_PCB_2024_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCB_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_PCM_2020_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_PCM_2021_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_PCM_2022_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_PCM_2023_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_PCM_2024_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PCM_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_PC_2016_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_PC_2017_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_PC_2018_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_PC_2019_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_2019_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_PC_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_PN_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_PN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_SCIP_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_SCIP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_STEMI_2023_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STEMI_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_STEMI_2024_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STEMI_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_STROKE_2016_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_STROKE_2017_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_STROKE_2018_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_STROKE_2020_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_STROKE_2021_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_STROKE_2022_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_STROKE_2023_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_STROKE_2024_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_STROKE_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_STROKE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_VTE_2016_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2016_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_VTE_2017_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2017_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_VTE_2018_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2018_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_VTE_2020_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2020_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_VTE_2021_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2021_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_VTE_2022_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2022_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_VTE_2023_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2023_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_VTE_2024_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_2024_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_E_VTE_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_E_VTE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_ACT_INTOL_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_ACT_INTOL_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_ACUTE_PAIN_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_ACUTE_PAIN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_AMI_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_ANEMIA_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_ANEMIA_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_CAC_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_CAC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_CHF_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_CHF_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_DELIRIUM_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_DELIRIUM_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_DEPRESSION_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_DEPRESSION_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_DYSPHAGIA_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_DYSPHAGIA_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_FVE_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_FVE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_GLYCEMIC_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_GLYCEMIC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_HOP_AMI_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_HOP_AMI_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_HOP_SURG_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_HOP_SURG_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_IC_MDRO_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_IC_MDRO_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_LHHF_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_LHHF_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_LIPID_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_LIPID_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_MED_AD_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_MED_AD_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_MOD_SEDATION_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_MOD_SEDATION_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_NHIQM_VTE_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_NHIQM_VTE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_PAIN_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_PAIN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_PC_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_PC_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_PEDS_MED_AD_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_PEDS_MED_AD_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_PEDS_PAIN_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_PEDS_PAIN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_PEDS_SKIN_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_PEDS_SKIN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_PN_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_PN_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_READMISSION_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_READMISSION_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_READMIT_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_READMIT_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_REST_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_REST_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_RRT_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_RRT_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_SCIP_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_SCIP_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_SEPSIS_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_SEPSIS_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_SEPSIS_PD_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_SEPSIS_PD_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_SEPSIS_RT_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_SEPSIS_RT_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_STROKE_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_STROKE_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_F_UI_METRICS | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_F_UI_METRICS | HEALTH_SYSTEM_SOURCE_ID |
LH_D_BED
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_D_BED |
Definition: | Dimension table to hold BED Results for Infection Control Reports |
Table Type: | REFERENCE |
Column Detail - LH_D_BED
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
BED_DESCRIPTION | VARCHAR(50) | Y | The description of the bed |
BED_DISPLAY | VARCHAR(50) | Y | The display value for the bed |
BED_MEANING | VARCHAR(50) | Y | The Cerner-identified meaning for the bed |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
D_BED_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_D_BED table. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the program running the extracts was started. This filed should be the same across all files and across all records within a file for a given extraction run. This time should be in UTC time. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data |
LOC_BED_CD | DOUBLE | N | This field is the patient location with a location type of bed. Code set 220 |
PROCESS_DT_TM | DATETIME | Y | The date/time the record was first loaded into the table. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_SOURCE | VARCHAR(50) | N | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - LH_D_BED
Parent Column in LH_D_BED (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | D_BED_ID | LH_F_IC_MDRO_DTL_METRICS | D_COLL_BED_ID |
LH_F_IC_MDRO_DTL_METRICS | D_COLL_PREV_BED_ID | ||
HEALTH_SYSTEM_SOURCE_ID | LH_F_IC_MDRO_DTL_METRICS | HEALTH_SYSTEM_SOURCE_ID | |
LH_F_IC_MDRO_DTL_METRICS | HEALTH_SYSTEM_SOURCE_ID |
LH_D_BEDROCK
Column Section | Top of Page |
Table-level Detail
Description: | LH_D_BEDROCK |
Definition: | This table contains the information about the bedrock configurations. |
Table Type: | REFERENCE |
Column Detail - LH_D_BEDROCK
Column Name | Type | Null? | Definition |
---|---|---|---|
BR_DATAMART_CATEGORY_ID | DOUBLE | Y | BR_DATAMART_CATEGORY_ID from br_datamart_category_id table |
BR_DATAMART_FILTER_ID | DOUBLE | Y | Filter Id from br_datamart_filter table |
BR_DATAMART_REPORT_ID | DOUBLE | Y | Report Id from br_datamart_report table |
BR_DATAMART_VALUE_ID | DOUBLE | Y | Value Id from br_datamart_value table |
CATEGORY_MEAN | VARCHAR(30) | Y | Category Mean from category table |
CATEGORY_NAME | VARCHAR(100) | Y | Category Name from category table |
EXTRACT_DT_TM | DATETIME | Y | Date and time when the row was updated |
FILTER_DISPLAY | VARCHAR(100) | Y | Filter Name from br_datamart_filter table |
FILTER_MEAN | VARCHAR(30) | Y | Filter Mean from br_datamart_filter table |
FREETEXT_DESC | VARCHAR(255) | Y | Freetext Desc from br_datamart_value table |
GROUP_SEQ | DOUBLE | Y | Group Seq from br_datamart_value table |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the |
LH_D_BEDROCK_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_D_BEDROCK table. |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
MAP_DATA_TYPE_CD | DOUBLE | Y | MAP_DATA_TYPE_CD from br_datamart_value table |
MPAGE_PARAM_MEAN | VARCHAR(25) | Y | MPAGE_PARAM_MEAN from br_datamart_value table |
MPAGE_PARAM_VALUE | VARCHAR(255) | Y | MPAGE_PARAM_VALUE from br_datamart_value table |
PARENT_ENTITY_ID | DOUBLE | Y | Parent Entity Id from br_datamart_value table |
PARENT_ENTITY_ID2 | DOUBLE | Y | PARENT_ENTITY_ID2 from br_datamart_value table |
PARENT_ENTITY_ID_VALUE | DOUBLE | Y | Parent Entity Id from br_datamart_value table |
PARENT_ENTITY_ID_VALUE_DISP | VARCHAR(255) | Y | Value Display for the parent_entity_id column from br_datamart_value table i.e. "" uar_get_code_display(val.parent_entity_id) "" |
PARENT_ENTITY_NAME | VARCHAR(50) | Y | Entity Name from br_datamart_value |
PARENT_ENTITY_NAME2 | VARCHAR(50) | Y | PARENT_ENTITY_NAME2 from br_datamart_value table |
PROCESS_DT_TM | DATETIME | Y | Date and time when the row was processed |
QUALIFIER_FLAG | DOUBLE | Y | Qualifier Flag from br_datamart_value table, 0 - Equal, 1 - Not equal, 2 - Greater than. |
REPORT_MEAN | VARCHAR(30) | Y | Report Mean from report table |
REPORT_NAME | VARCHAR(200) | Y | Report Name from report table |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_SOURCE | VARCHAR(50) | N | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
VALUE_SEQ | DOUBLE | Y | Value Seq from br_datamart_value table |
VALUE_TYPE_FLAG | DOUBLE | Y | Type Flag from br_datamart_value table. 0 - Numeric, 1 - Freetext, 2 - Alpha. |