Table Detail Report
LH_E_VTE_2021_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Lighthouse eMeasures VTE 2021 Metrics |
Definition: | Stores data gathered by the LH_E_VTE_2021 script. |
Table Type: | ACTIVITY |
Column Detail - LH_E_VTE_2021_METRICS
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. |
ANES_ICU_END_DT_TM | DATETIME | Y | The end date/time of anesthesia after inpatient admission |
ANES_IP_END_DT_TM | DATETIME | Y | The end date/time of anesthesia for VTE-1 |
ATRIAL_FIB_NOMEN | VARCHAR(50) | Y | The code of the Atrial Fibrillation active diagnosis |
CM_ORD_VTE1_DT_TM | DATETIME | Y | The date/time comfort measures was ordered for VTE1 requirements |
CM_ORD_VTE2_DT_TM | DATETIME | Y | The date/time comfort measures was ordered for VTE2 requirements |
CM_PERF_VTE1_DT_TM | DATETIME | Y | The date/time comfort measures was performed for VTE1 requirements |
CM_PERF_VTE2_DT_TM | DATETIME | Y | The date/time comfort measures was performed for VTE2 requirements |
DEN_2_IND | DOUBLE | Y | Identifies if the encounter is In Denominator for VTE-2 |
DISCHARGE_DT_TM | DATETIME | Y | The end of the qualifying encounter. |
D_ADMIT_BUILDING_ID | DOUBLE | N | Dimension ID for admit building. |
D_ADMIT_FACILITY_ID | DOUBLE | N | Dimension ID for admit facility. |
D_ADMIT_NURSE_UNIT_ID | DOUBLE | N | Dimension ID for admit nurse unit. |
D_ADMIT_SRC_ID | DOUBLE | N | Dimension ID for admit source. |
D_ADMIT_TYPE_ID | DOUBLE | N | Dimension ID for admit type. |
D_ATTEND_PRSNL_ID | DOUBLE | N | Dimension ID for attending physician. |
D_BR_CCN_ID | DOUBLE | N | Dimension ID for CCN. |
D_BR_HCO_ID | DOUBLE | N | Dimension ID for HCO. |
D_DISCHARGE_BUILDING_ID | DOUBLE | N | Dimension ID for discharge building. |
D_DISCHARGE_FACILITY_ID | DOUBLE | N | Dimension ID for discharge facility. |
D_DISCHARGE_NURSE_UNIT_ID | DOUBLE | N | Dimension ID for discharge nurse unit. |
D_DISCH_DISP_ID | DOUBLE | N | Dimension ID for discharge disposition. |
D_ENCNTR_TYPE_ID | DOUBLE | N | Dimension ID for encounter type. |
D_METRIC_1_ID | DOUBLE | N | Dimension ID for VTE-1 metric. |
D_METRIC_2_ID | DOUBLE | N | Dimension ID for VTE-2 metric. |
D_PERSON_ID | DOUBLE | N | Dimension ID for person data. |
ED_ARRIVAL_DT_TM | DATETIME | Y | The start of the emergency encounter. |
ED_DEPART_DT_TM | DATETIME | Y | The end of the emergency encounter. |
ED_ENCNTR_ID | DOUBLE | N | The ID of the emergency encounter associated to the record. |
ENCNTR_ID | DOUBLE | N | The ID of the qualifying encounter associated to the record. |
EXCEP_2_IND | DOUBLE | Y | Identifies if the encounter is a Denominator Exception for VTE-2 |
EXCLUDE_1_IND | DOUBLE | Y | Identifies if the encounter is In Denominator Exclusion for VTE-1 |
EXCLUDE_2_IND | DOUBLE | Y | Identifies if the encounter is In Denominator Exclusion for VTE-2 |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FINANCIAL_NBR_TXT | VARCHAR(50) | Y | Financial Number of the record. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time that the first ETL process started that created this record. |
GCS_APPLIED_VTE1_DT_TM | DATETIME | Y | The first application of GCS after meeting VTE1 requirements |
GCS_APPLIED_VTE2_DT_TM | DATETIME | Y | The first application of GCS after meeting VTE2 requirements |
GCS_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering GCS were documented |
GCS_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusals for not ordering/administering GCS were documented |
GLYCOPROTEIN_VTE1_DT_TM | DATETIME | Y | The first administration of Glycoprotein meeting VTE1 requirements |
GLYCOPROTEIN_VTE2_DT_TM | DATETIME | Y | The first administration of Glycoprotein meeting VTE2 requirements |
HEALTH_SYSTEM_ID | DOUBLE | N | Identifies the delivery network responsible for supplying the data. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data. |
HIP_REPLACE_DT_TM | DATETIME | Y | The date/time of the hip replacment surgery |
HIP_REPLACE_NOMEN | VARCHAR(50) | Y | The code of hip replacement surgery |
IFXA_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering Injectable Factor xA were documented |
IFXA_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusal for not ordering/administering Injectable Factor xA were documented |
IFXA_VTE1_ADMIN_DT_TM | DATETIME | Y | The first administration of Injectable Factor xA after meeting VTE1 requirements |
IFXA_VTE2_ADMIN_DT_TM | DATETIME | Y | The first administration of Injectable Factor xA after meeting VTE2 requirements |
INR_VTE1_TXT | VARCHAR(100) | Y | INR result text for INRs meeting VTE1 Requirements |
INR_VTE2_TXT | VARCHAR(100) | Y | INR result text for INRs meeting VTE2 Requirements |
IPC_APPLIED_VTE1_DT_TM | DATETIME | Y | The first application of IPC after meeting VTE1 requirements |
IPC_APPLIED_VTE2_DT_TM | DATETIME | Y | The first application of IPC after meeting VTE2 requirements |
IPC_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering IPC were documented |
IPC_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusals for not ordering/administering IPC were documented |
IPP_IND | DOUBLE | Y | Indicates the encounter within the initial patient population |
IP_ADMIT_DT_TM | DATETIME | Y | The start of the inpatient encounter. |
IV_UFH_VTE1_ADMIN_DT_TM | DATETIME | Y | The first administration of IV Unfractionated Heparin after meeting VTE1 requirements |
IV_UFH_VTE2_ADMIN_DT_TM | DATETIME | Y | The first administration of IV Unfractionated Heparin after meeting VTE2 requirements |
KNEE_REPLACE_DT_TM | DATETIME | Y | The date/time of the knee replacment surgery |
KNEE_REPLACE_NOMEN | VARCHAR(50) | Y | The code of knee replacement surgery |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
LDUH_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering LDUH for VTE were documented |
LDUH_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusal for not ordering/administering LDUH for VTE were documented |
LDUH_VTE1_ADMIN_DT_TM | DATETIME | Y | The first administration of Subcutaneous LDUH meeting VTE1 requirements |
LDUH_VTE2_ADMIN_DT_TM | DATETIME | Y | The first administration of Subcutaneous LDUH meeting VTE2 requirements |
LH_E_VTE_2021_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_E_VTE_2021_METRICS table. |
LMWH_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering LMWH were documented |
LMWH_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusal for not ordering/administering LMWH were documented |
LMWH_VTE1_ADMIN_DT_TM | DATETIME | Y | The first administration of LMWH after meeting VTE1 requirements |
LMWH_VTE2_ADMIN_DT_TM | DATETIME | Y | The first administration of LMWH after meeting VTE2 requirements |
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. |
NUM_1_IND | DOUBLE | Y | Identifies if the encounter is Numerator for VTE-1 |
NUM_2_IND | DOUBLE | Y | Identifies if the encounter is Numerator for VTE-2 |
OBS_DX_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying Obstetrics diagnosis. |
OBS_SERV_ARRIVAL_DT_TM | DATETIME | Y | The start of the observation encounter. |
OBS_SERV_DEPART_DT_TM | DATETIME | Y | The end of the observation encounter. |
OBS_SERV_ENCNTR_ID | DOUBLE | N | The ID of the observation services encounter associated to the record. |
OBS_VTE_DX_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying Obstetrics VTE diagnosis. |
OFXA_ADMIN_VTE1_DT_TM | DATETIME | Y | The first administration of Oral Factor xA after meeting VTE1 requirements |
OFXA_ADMIN_VTE2_DT_TM | DATETIME | Y | The first administration of Oral Factor xA after meeting VTE2 requirements |
ORG_MRN_TXT | VARCHAR(50) | Y | Medical Record Number of the record. |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility. |
PATIENT_IDENT | VARCHAR(50) | Y | Identifies the earliest documented medical record number of the patient. |
PERSON_ETHNIC_CODE_DISPLAY | VARCHAR(300) | Y | String to store ethnicity display. |
PERSON_GENDER_CODE_DISPLAY | VARCHAR(300) | Y | String to store gender display. |
PERSON_ID | DOUBLE | N | The ID of the person associated to the record. |
PERSON_PAYER_CODE_DISPLAY | VARCHAR(300) | Y | String to store payer display. |
PERSON_RACE_DESC | VARCHAR(300) | Y | String to store multiple races. |
PRIN_DX_HEMORRHAGIC_STK_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying Hemorrhagic Stroke principal diagnosis. |
PRIN_DX_ISCHEMIC_STK_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying Ischemic Stroke principal diagnosis. |
PRIN_DX_MENTAL_HEALTH_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying Mental Health principal diagnosis. |
PRIN_PROC_GEN_SURG_ICU_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-2 for value set 'GENERAL_SURGERY' |
PRIN_PROC_GEN_SURG_IP_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-1 for value set 'GENERAL_SURGERY' |
PRIN_PROC_GYNEC_SURG_ICU_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-2 for value set 'GYNECOLOGICAL_SURGERY' |
PRIN_PROC_GYNEC_SURG_IP_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-1 for value set 'GYNECOLOGICAL_SURGERY' |
PRIN_PROC_HIP_FRAC_ICU_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-2 for value set 'HIP_FRACTURE_SURGERY' |
PRIN_PROC_HIP_FRAC_IP_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-1 for value set 'HIP_FRACTURE_SURGERY' |
PRIN_PROC_HIP_REPL_ICU_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-2 for value set 'HIP_REPLACEMENT_SURGERY' |
PRIN_PROC_HIP_REPL_IP_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-1 for value set 'HIP_REPLACEMENT_SURGERY' |
PRIN_PROC_KNEE_REPL_ICU_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-2 for value set 'KNEE_REPLACEMENT_SURGERY' |
PRIN_PROC_KNEE_REPL_IP_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-1 for value set 'KNEE_REPLACEMENT_SURGERY' |
PRIN_PROC_NEURO_SURG_ICU_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-2 for value set 'INTRACRANIAL_NEUROSURGERY' |
PRIN_PROC_NEURO_SURG_IP_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-1 for value set 'INTRACRANIAL_NEUROSURGERY' |
PRIN_PROC_URO_SURG_ICU_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-2 for value set 'UROLOGICAL_SURGERY' |
PRIN_PROC_URO_SURG_IP_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-1 for value set 'UROLOGICAL_SURGERY' |
RVBT_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering Rivaroxaban or Betrixaban were documented |
RVBT_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusal for not ordering/administering Rivaroxaban or Betrixaban were documented |
RVBT_VTE1_ADMIN_DT_TM | DATETIME | Y | The first date/time of Rivaroxaban or Betrixaban after meeting VTE1 requirements |
RVBT_VTE2_ADMIN_DT_TM | DATETIME | Y | The first date/time of Rivaroxaban or Betrixaban after meeting VTE2 requirements |
SCRIPT_VERSION | DOUBLE | Y | The version number of the script that populated the row |
SRC_UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated to be preserved during extracts. |
SRC_UPDT_SOURCE | VARCHAR(50) | Y | The script name responsible for updating the record to be preserved during extracts. |
THROM_VTE1_ADMIN_DT_TM | DATETIME | Y | The first administration of Direct Thrombin Inhibitor meeting VTE1 requirements |
THROM_VTE2_ADMIN_DT_TM | DATETIME | Y | The first administration of Direct Thrombin Inhibitor meeting VTE2 requirements |
TIME_ZONE_TXT | VARCHAR(300) | Y | The timezone of the record in ""America/Chicago"" format. |
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. |
VFP_APPLIED_VTE1_DT_TM | DATETIME | Y | The first application of VFP after meeting VTE1 requirements |
VFP_APPLIED_VTE2_DT_TM | DATETIME | Y | The first application of VFP after meeting VTE2 requirements |
VFP_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering VFP were documented |
VFP_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusals for not ordering/administering VFP were documented |
VTE1_ICU_ADMIT_DT_TM | DATETIME | Y | The start date/time of ICU for VTE-1 |
VTE1_ICU_DEPART_DT_TM | DATETIME | Y | The end date/time of ICU for VTE-1 |
VTE1_LOW_RISK_IND | DOUBLE | Y | Indicates if Low Risk is documented on a patient for VTE-1 |
VTE2_ICU_ADMIT_DT_TM | DATETIME | Y | The start date/time of ICU for VTE-2 |
VTE2_ICU_DEPART_DT_TM | DATETIME | Y | The end date/time of ICU for VTE-2 |
VTE2_LOW_RISK_IND | DOUBLE | Y | Indicates if Low Risk is documented on a patient for VTE-2 |
VTE_DX_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying VTE diagnosis. |
VTE_DX_PRIOR_DT_TM | DATETIME | Y | The date/time of the VTE diagnosis prior to the inpatient encounter |
VTE_DX_PRIOR_NOMEN | VARCHAR(50) | Y | The nomenclature of the VTE diagnosis prior to inpatient |
WARF_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering Warfarin were documented |
WARF_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusal for not ordering/administering Warfarin were documented |
WARF_VTE1_ADMIN_DT_TM | DATETIME | Y | The first date/time of Warfarin after meeting VTE1 requirements |
WARF_VTE2_ADMIN_DT_TM | DATETIME | Y | The first date/time of Warfarin after meeting VTE2 requirements |
Relationship Detail - LH_E_VTE_2021_METRICS
Child Column in LH_E_VTE_2021_METRICS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | D_ADMIT_SRC_ID | LH_D_ADMIT_SRC | D_ADMIT_SRC_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_SRC | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_D_ADMIT_TYPE | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_D_BR_CCN | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BR_CCN | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_D_BR_HCO | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BR_HCO | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
D_DISCHARGE_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
D_DISCH_DISP_ID | LH_D_DISCH_DISP | D_DISCH_DISP_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_DISCH_DISP | HEALTH_SYSTEM_SOURCE_ID | |
D_ENCNTR_TYPE_ID | LH_D_ENCNTR_TYPE | D_ENCNTR_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ENCNTR_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
D_DISCHARGE_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
D_METRIC_1_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_2_ID | LH_D_METRIC | D_METRIC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
D_DISCHARGE_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_D_PERSON | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSON | HEALTH_SYSTEM_SOURCE_ID | |
D_ATTEND_PRSNL_ID | LH_D_PERSONNEL | D_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSONNEL | HEALTH_SYSTEM_SOURCE_ID |
LH_E_VTE_2022_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Lighthouse eMeasures VTE 2022 Metrics |
Definition: | Stores data gathered by the LH_E_VTE_2022 script. |
Table Type: | ACTIVITY |
Column Detail - LH_E_VTE_2022_METRICS
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. |
ANES_ICU_END_DT_TM | DATETIME | Y | The end date/time of anesthesia after inpatient admission |
ANES_IP_END_DT_TM | DATETIME | Y | The end date/time of anesthesia for VTE-1 |
ATRIAL_FIB_NOMEN | VARCHAR(50) | Y | The code of the Atrial Fibrillation active diagnosis |
CM_ORD_VTE1_DT_TM | DATETIME | Y | The date/time comfort measures was ordered for VTE1 requirements |
CM_ORD_VTE2_DT_TM | DATETIME | Y | The date/time comfort measures was ordered for VTE2 requirements |
CM_PERF_VTE1_DT_TM | DATETIME | Y | The date/time comfort measures was performed for VTE1 requirements |
CM_PERF_VTE2_DT_TM | DATETIME | Y | The date/time comfort measures was performed for VTE2 requirements |
DEN_2_IND | DOUBLE | Y | Identifies if the encounter is In Denominator for VTE-2 |
DISCHARGE_DT_TM | DATETIME | Y | The end of the qualifying encounter. |
D_ADMIT_BUILDING_ID | DOUBLE | N | Dimension ID for admit building. |
D_ADMIT_FACILITY_ID | DOUBLE | N | Dimension ID for admit facility. |
D_ADMIT_NURSE_UNIT_ID | DOUBLE | N | Dimension ID for admit nurse unit. |
D_ADMIT_SRC_ID | DOUBLE | N | Dimension ID for admit source. |
D_ADMIT_TYPE_ID | DOUBLE | N | Dimension ID for admit type. |
D_ATTEND_PRSNL_ID | DOUBLE | N | Dimension ID for attending physician. |
D_BR_CCN_ID | DOUBLE | N | Dimension ID for CCN. |
D_BR_HCO_ID | DOUBLE | N | Dimension ID for HCO. |
D_DISCHARGE_BUILDING_ID | DOUBLE | N | Dimension ID for discharge building. |
D_DISCHARGE_FACILITY_ID | DOUBLE | N | Dimension ID for discharge facility. |
D_DISCHARGE_NURSE_UNIT_ID | DOUBLE | N | Dimension ID for discharge nurse unit. |
D_DISCH_DISP_ID | DOUBLE | N | Dimension ID for discharge disposition. |
D_ENCNTR_TYPE_ID | DOUBLE | N | Dimension ID for encounter type. |
D_METRIC_1_ID | DOUBLE | N | Dimension ID for VTE-1 metric. |
D_METRIC_2_ID | DOUBLE | N | Dimension ID for VTE-2 metric. |
D_PERSON_ID | DOUBLE | N | Dimension ID for person data. |
ED_ARRIVAL_DT_TM | DATETIME | Y | The start of the emergency encounter. |
ED_DEPART_DT_TM | DATETIME | Y | The end of the emergency encounter. |
ED_ENCNTR_ID | DOUBLE | N | The ID of the emergency encounter associated to the record. |
ENCNTR_ID | DOUBLE | N | The ID of the qualifying encounter associated to the record. |
EXCEP_2_IND | DOUBLE | Y | Identifies if the encounter is a Denominator Exception for VTE-2 |
EXCLUDE_1_IND | DOUBLE | Y | Identifies if the encounter is In Denominator Exclusion for VTE-1 |
EXCLUDE_2_IND | DOUBLE | Y | Identifies if the encounter is In Denominator Exclusion for VTE-2 |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FINANCIAL_NBR_TXT | VARCHAR(50) | Y | Financial Number of the record. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time that the first ETL process started that created this record. |
GCS_APPLIED_VTE1_DT_TM | DATETIME | Y | The first application of GCS after meeting VTE1 requirements |
GCS_APPLIED_VTE2_DT_TM | DATETIME | Y | The first application of GCS after meeting VTE2 requirements |
GCS_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering GCS were documented |
GCS_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusals for not ordering/administering GCS were documented |
GLYCOPROTEIN_VTE1_DT_TM | DATETIME | Y | The first administration of Glycoprotein meeting VTE1 requirements |
GLYCOPROTEIN_VTE2_DT_TM | DATETIME | Y | The first administration of Glycoprotein meeting VTE2 requirements |
HEALTH_SYSTEM_ID | DOUBLE | N | Identifies the delivery network responsible for supplying the data. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data. |
HIP_REPLACE_DT_TM | DATETIME | Y | The date/time of the hip replacment surgery |
HIP_REPLACE_NOMEN | VARCHAR(50) | Y | The code of hip replacement surgery |
IFXA_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering Injectable Factor xA were documented |
IFXA_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusal for not ordering/administering Injectable Factor xA were documented |
IFXA_VTE1_ADMIN_DT_TM | DATETIME | Y | The first administration of Injectable Factor xA after meeting VTE1 requirements |
IFXA_VTE2_ADMIN_DT_TM | DATETIME | Y | The first administration of Injectable Factor xA after meeting VTE2 requirements |
INR_VTE1_TXT | VARCHAR(100) | Y | INR result text for INRs meeting VTE1 Requirements |
INR_VTE2_TXT | VARCHAR(100) | Y | INR result text for INRs meeting VTE2 Requirements |
IPC_APPLIED_VTE1_DT_TM | DATETIME | Y | The first application of IPC after meeting VTE1 requirements |
IPC_APPLIED_VTE2_DT_TM | DATETIME | Y | The first application of IPC after meeting VTE2 requirements |
IPC_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering IPC were documented |
IPC_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusals for not ordering/administering IPC were documented |
IPP_IND | DOUBLE | Y | Indicates the encounter within the initial patient population |
IP_ADMIT_DT_TM | DATETIME | Y | The start of the inpatient encounter. |
IV_UFH_VTE1_ADMIN_DT_TM | DATETIME | Y | The first administration of IV Unfractionated Heparin after meeting VTE1 requirements |
IV_UFH_VTE2_ADMIN_DT_TM | DATETIME | Y | The first administration of IV Unfractionated Heparin after meeting VTE2 requirements |
KNEE_REPLACE_DT_TM | DATETIME | Y | The date/time of the knee replacment surgery |
KNEE_REPLACE_NOMEN | VARCHAR(50) | Y | The code of knee replacement surgery |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
LDUH_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering LDUH for VTE were documented |
LDUH_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusal for not ordering/administering LDUH for VTE were documented |
LDUH_VTE1_ADMIN_DT_TM | DATETIME | Y | The first administration of Subcutaneous LDUH meeting VTE1 requirements |
LDUH_VTE2_ADMIN_DT_TM | DATETIME | Y | The first administration of Subcutaneous LDUH meeting VTE2 requirements |
LH_E_VTE_2022_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_E_VTE_2022_METRICS table. |
LMWH_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering LMWH were documented |
LMWH_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusal for not ordering/administering LMWH were documented |
LMWH_VTE1_ADMIN_DT_TM | DATETIME | Y | The first administration of LMWH after meeting VTE1 requirements |
LMWH_VTE2_ADMIN_DT_TM | DATETIME | Y | The first administration of LMWH after meeting VTE2 requirements |
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. |
NUM_1_IND | DOUBLE | Y | Identifies if the encounter is Numerator for VTE-1 |
NUM_2_IND | DOUBLE | Y | Identifies if the encounter is Numerator for VTE-2 |
OBS_DX_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying Obstetrics diagnosis. |
OBS_SERV_ARRIVAL_DT_TM | DATETIME | Y | The start of the observation encounter. |
OBS_SERV_DEPART_DT_TM | DATETIME | Y | The end of the observation encounter. |
OBS_SERV_ENCNTR_ID | DOUBLE | N | The ID of the observation services encounter associated to the record. |
OBS_VTE_DX_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying Obstetrics VTE diagnosis. |
OFXA_ADMIN_VTE1_DT_TM | DATETIME | Y | The first administration of Oral Factor xA after meeting VTE1 requirements |
OFXA_ADMIN_VTE2_DT_TM | DATETIME | Y | The first administration of Oral Factor xA after meeting VTE2 requirements |
ORG_MRN_TXT | VARCHAR(50) | Y | Medical Record Number of the record. |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility. |
PATIENT_IDENT | VARCHAR(50) | Y | Identifies the earliest documented medical record number of the patient. |
PERSON_ETHNIC_CODE_DISPLAY | VARCHAR(300) | Y | String to store ethnicity display. |
PERSON_GENDER_CODE_DISPLAY | VARCHAR(300) | Y | String to store gender display. |
PERSON_ID | DOUBLE | N | The ID of the person associated to the record. |
PERSON_PAYER_CODE_DISPLAY | VARCHAR(300) | Y | String to store payer display. |
PERSON_RACE_DESC | VARCHAR(300) | Y | String to store multiple races. |
PRIN_DX_HEMORRHAGIC_STK_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying Hemorrhagic Stroke principal diagnosis. |
PRIN_DX_ISCHEMIC_STK_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying Ischemic Stroke principal diagnosis. |
PRIN_DX_MENTAL_HEALTH_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying Mental Health principal diagnosis. |
PRIN_PROC_GEN_SURG_ICU_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-2 for value set 'GENERAL_SURGERY' |
PRIN_PROC_GEN_SURG_IP_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-1 for value set 'GENERAL_SURGERY' |
PRIN_PROC_GYNEC_SURG_ICU_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-2 for value set 'GYNECOLOGICAL_SURGERY' |
PRIN_PROC_GYNEC_SURG_IP_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-1 for value set 'GYNECOLOGICAL_SURGERY' |
PRIN_PROC_HIP_FRAC_ICU_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-2 for value set 'HIP_FRACTURE_SURGERY' |
PRIN_PROC_HIP_FRAC_IP_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-1 for value set 'HIP_FRACTURE_SURGERY' |
PRIN_PROC_HIP_REPL_ICU_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-2 for value set 'HIP_REPLACEMENT_SURGERY' |
PRIN_PROC_HIP_REPL_IP_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-1 for value set 'HIP_REPLACEMENT_SURGERY' |
PRIN_PROC_KNEE_REPL_ICU_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-2 for value set 'KNEE_REPLACEMENT_SURGERY' |
PRIN_PROC_KNEE_REPL_IP_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-1 for value set 'KNEE_REPLACEMENT_SURGERY' |
PRIN_PROC_NEURO_SURG_ICU_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-2 for value set 'INTRACRANIAL_NEUROSURGERY' |
PRIN_PROC_NEURO_SURG_IP_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-1 for value set 'INTRACRANIAL_NEUROSURGERY' |
PRIN_PROC_URO_SURG_ICU_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-2 for value set 'UROLOGICAL_SURGERY' |
PRIN_PROC_URO_SURG_IP_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-1 for value set 'UROLOGICAL_SURGERY' |
RVBT_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering Rivaroxaban or Betrixaban were documented |
RVBT_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusal for not ordering/administering Rivaroxaban or Betrixaban were documented |
RVBT_VTE1_ADMIN_DT_TM | DATETIME | Y | The first date/time of Rivaroxaban or Betrixaban after meeting VTE1 requirements |
RVBT_VTE2_ADMIN_DT_TM | DATETIME | Y | The first date/time of Rivaroxaban or Betrixaban after meeting VTE2 requirements |
SCRIPT_VERSION | DOUBLE | Y | The version number of the script that populated the row |
SRC_UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated to be preserved during extracts. |
SRC_UPDT_SOURCE | VARCHAR(50) | Y | The script name responsible for updating the record to be preserved during extracts. |
THROM_VTE1_ADMIN_DT_TM | DATETIME | Y | The first administration of Direct Thrombin Inhibitor meeting VTE1 requirements |
THROM_VTE2_ADMIN_DT_TM | DATETIME | Y | The first administration of Direct Thrombin Inhibitor meeting VTE2 requirements |
TIME_ZONE_TXT | VARCHAR(300) | Y | The timezone of the record in ""America/Chicago"" format. |
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. |
VFP_APPLIED_VTE1_DT_TM | DATETIME | Y | The first application of VFP after meeting VTE1 requirements |
VFP_APPLIED_VTE2_DT_TM | DATETIME | Y | The first application of VFP after meeting VTE2 requirements |
VFP_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering VFP were documented |
VFP_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusals for not ordering/administering VFP were documented |
VTE1_ICU_ADMIT_DT_TM | DATETIME | Y | The start date/time of ICU for VTE-1 |
VTE1_ICU_DEPART_DT_TM | DATETIME | Y | The end date/time of ICU for VTE-1 |
VTE1_LOW_RISK_IND | DOUBLE | Y | Indicates if Low Risk is documented on a patient for VTE-1 |
VTE2_ICU_ADMIT_DT_TM | DATETIME | Y | The start date/time of ICU for VTE-2 |
VTE2_ICU_DEPART_DT_TM | DATETIME | Y | The end date/time of ICU for VTE-2 |
VTE2_LOW_RISK_IND | DOUBLE | Y | Indicates if Low Risk is documented on a patient for VTE-2 |
VTE_DX_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying VTE diagnosis. |
VTE_DX_PRIOR_DT_TM | DATETIME | Y | The date/time of the VTE diagnosis prior to the inpatient encounter |
VTE_DX_PRIOR_NOMEN | VARCHAR(50) | Y | The nomenclature of the VTE diagnosis prior to inpatient |
WARF_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering Warfarin were documented |
WARF_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusal for not ordering/administering Warfarin were documented |
WARF_VTE1_ADMIN_DT_TM | DATETIME | Y | The first date/time of Warfarin after meeting VTE1 requirements |
WARF_VTE2_ADMIN_DT_TM | DATETIME | Y | The first date/time of Warfarin after meeting VTE2 requirements |
Relationship Detail - LH_E_VTE_2022_METRICS
Child Column in LH_E_VTE_2022_METRICS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | D_ADMIT_SRC_ID | LH_D_ADMIT_SRC | D_ADMIT_SRC_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_SRC | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_D_ADMIT_TYPE | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_D_BR_CCN | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BR_CCN | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_D_BR_HCO | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BR_HCO | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
D_DISCHARGE_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
D_DISCH_DISP_ID | LH_D_DISCH_DISP | D_DISCH_DISP_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_DISCH_DISP | HEALTH_SYSTEM_SOURCE_ID | |
D_ENCNTR_TYPE_ID | LH_D_ENCNTR_TYPE | D_ENCNTR_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ENCNTR_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
D_DISCHARGE_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
D_METRIC_1_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_2_ID | LH_D_METRIC | D_METRIC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
D_DISCHARGE_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_D_PERSON | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSON | HEALTH_SYSTEM_SOURCE_ID | |
D_ATTEND_PRSNL_ID | LH_D_PERSONNEL | D_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSONNEL | HEALTH_SYSTEM_SOURCE_ID |
LH_E_VTE_2023_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Lighthouse eMeasures VTE 2023 Metrics |
Definition: | Stores data gathered by the LH_E_VTE_2023 script. |
Table Type: | ACTIVITY |
Column Detail - LH_E_VTE_2023_METRICS
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. |
ANES_ICU_END_DT_TM | DATETIME | Y | The end date/time of anesthesia after inpatient admission |
ANES_IP_END_DT_TM | DATETIME | Y | The end date/time of anesthesia for VTE-1 |
ATRIAL_FIB_NOMEN | VARCHAR(50) | Y | The code of the Atrial Fibrillation active diagnosis |
CM_ORD_VTE1_DT_TM | DATETIME | Y | The date/time comfort measures was ordered for VTE1 requirements |
CM_ORD_VTE2_DT_TM | DATETIME | Y | The date/time comfort measures was ordered for VTE2 requirements |
CM_PERF_VTE1_DT_TM | DATETIME | Y | The date/time comfort measures was performed for VTE1 requirements |
CM_PERF_VTE2_DT_TM | DATETIME | Y | The date/time comfort measures was performed for VTE2 requirements |
DEN_2_IND | DOUBLE | Y | Identifies if the encounter is In Denominator for VTE-2 |
DISCHARGE_DT_TM | DATETIME | Y | The end of the qualifying encounter. |
D_ADMIT_BUILDING_ID | DOUBLE | N | Dimension ID for admit building. |
D_ADMIT_FACILITY_ID | DOUBLE | N | Dimension ID for admit facility. |
D_ADMIT_NURSE_UNIT_ID | DOUBLE | N | Dimension ID for admit nurse unit. |
D_ADMIT_SRC_ID | DOUBLE | N | Dimension ID for admit source. |
D_ADMIT_TYPE_ID | DOUBLE | N | Dimension ID for admit type. |
D_ATTEND_PRSNL_ID | DOUBLE | N | Dimension ID for attending physician. |
D_BR_CCN_ID | DOUBLE | N | Dimension ID for CCN. |
D_BR_HCO_ID | DOUBLE | N | Dimension ID for HCO. |
D_DISCHARGE_BUILDING_ID | DOUBLE | N | Dimension ID for discharge building. |
D_DISCHARGE_FACILITY_ID | DOUBLE | N | Dimension ID for discharge facility. |
D_DISCHARGE_NURSE_UNIT_ID | DOUBLE | N | Dimension ID for discharge nurse unit. |
D_DISCH_DISP_ID | DOUBLE | N | Dimension ID for discharge disposition. |
D_ENCNTR_TYPE_ID | DOUBLE | N | Dimension ID for encounter type. |
D_METRIC_1_ID | DOUBLE | N | Dimension ID for VTE-1 metric. |
D_METRIC_2_ID | DOUBLE | N | Dimension ID for VTE-2 metric. |
D_PERSON_ID | DOUBLE | N | Dimension ID for person data. |
ED_ARRIVAL_DT_TM | DATETIME | Y | The start of the emergency encounter. |
ED_DEPART_DT_TM | DATETIME | Y | The end of the emergency encounter. |
ED_ENCNTR_ID | DOUBLE | N | The ID of the emergency encounter associated to the record. |
ENCNTR_ID | DOUBLE | N | The ID of the qualifying encounter associated to the record. |
EXCEP_2_IND | DOUBLE | Y | Identifies if the encounter is a Denominator Exception for VTE-2 |
EXCLUDE_1_IND | DOUBLE | Y | Identifies if the encounter is In Denominator Exclusion for VTE-1 |
EXCLUDE_2_IND | DOUBLE | Y | Identifies if the encounter is In Denominator Exclusion for VTE-2 |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FINANCIAL_NBR_TXT | VARCHAR(50) | Y | Financial Number of the record. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time that the first ETL process started that created this record. |
GCS_APPLIED_VTE1_PROC_DT_TM | DATETIME | Y | The first application of GCS procedure after meeting VTE1 requirements |
GCS_APPLIED_VTE2_PROC_DT_TM | DATETIME | Y | The first application of GCS procedure after meeting VTE2 requirements |
GCS_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering GCS were documented |
GCS_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusals for not ordering/administering GCS were documented |
GLYCOPROTEIN_VTE1_DT_TM | DATETIME | Y | The first administration of Glycoprotein meeting VTE1 requirements |
GLYCOPROTEIN_VTE1_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Glycoprotein lIb/llla Inhibitors |
GLYCOPROTEIN_VTE2_DT_TM | DATETIME | Y | The first administration of Glycoprotein meeting VTE2 requirements |
GLYCOPROTEIN_VTE2_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Glycoprotein lIb/llla Inhibitors |
HEALTH_SYSTEM_ID | DOUBLE | N | Identifies the delivery network responsible for supplying the data. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data. |
HIP_REPLACE_DT_TM | DATETIME | Y | The date/time of the hip replacment surgery |
HIP_REPLACE_NOMEN | VARCHAR(50) | Y | The code of hip replacement surgery |
IFXA_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering Injectable Factor xA were documented |
IFXA_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusal for not ordering/administering Injectable Factor xA were documented |
IFXA_VTE1_ADMIN_DT_TM | DATETIME | Y | The first administration of Injectable Factor xA after meeting VTE1 requirements |
IFXA_VTE1_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Injectable Factor Xa Inhibitor |
IFXA_VTE2_ADMIN_DT_TM | DATETIME | Y | The first administration of Injectable Factor xA after meeting VTE2 requirements |
IFXA_VTE2_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Injectable Factor Xa Inhibitor |
INR_VTE1_TXT | VARCHAR(100) | Y | INR result text for INRs meeting VTE1 Requirements |
INR_VTE2_TXT | VARCHAR(100) | Y | INR result text for INRs meeting VTE2 Requirements |
IPC_APPLIED_VTE1_PROC_DT_TM | DATETIME | Y | The first application of IPC procedure after meeting VTE1 requirements |
IPC_APPLIED_VTE2_PROC_DT_TM | DATETIME | Y | The first application of IPC procedure after meeting VTE2 requirements |
IPC_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering IPC were documented |
IPC_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusals for not ordering/administering IPC were documented |
IPP_IND | DOUBLE | Y | Indicates the encounter within the initial patient population |
IP_ADMIT_DT_TM | DATETIME | Y | The start of the inpatient encounter. |
IV_UFH_VTE1_ADMIN_DT_TM | DATETIME | Y | The first administration of IV Unfractionated Heparin after meeting VTE1 requirements |
IV_UFH_VTE1_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Unfractionated Heparin |
IV_UFH_VTE2_ADMIN_DT_TM | DATETIME | Y | The first administration of IV Unfractionated Heparin after meeting VTE2 requirements |
IV_UFH_VTE2_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Unfractionated Heparin |
KNEE_REPLACE_DT_TM | DATETIME | Y | The date/time of the knee replacment surgery |
KNEE_REPLACE_NOMEN | VARCHAR(50) | Y | The code of knee replacement surgery |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
LDUH_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering LDUH for VTE were documented |
LDUH_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusal for not ordering/administering LDUH for VTE were documented |
LDUH_VTE1_ADMIN_DT_TM | DATETIME | Y | The first administration of Subcutaneous LDUH meeting VTE1 requirements |
LDUH_VTE1_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Low Dose Unfractionated Heparin |
LDUH_VTE2_ADMIN_DT_TM | DATETIME | Y | The first administration of Subcutaneous LDUH meeting VTE2 requirements |
LDUH_VTE2_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Low Dose Unfractionated Heparin |
LH_E_VTE_2023_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_E_VTE_2023_METRICS table. |
LMWH_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering LMWH were documented |
LMWH_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusal for not ordering/administering LMWH were documented |
LMWH_VTE1_ADMIN_DT_TM | DATETIME | Y | The first administration of LMWH after meeting VTE1 requirements |
LMWH_VTE1_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Low Molecular Weight Heparin |
LMWH_VTE2_ADMIN_DT_TM | DATETIME | Y | The first administration of LMWH after meeting VTE2 requirements |
LMWH_VTE2_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Low Molecular Weight Heparin |
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. |
NUM_1_IND | DOUBLE | Y | Identifies if the encounter is Numerator for VTE-1 |
NUM_2_IND | DOUBLE | Y | Identifies if the encounter is Numerator for VTE-2 |
OBS_DX_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying Obstetrics diagnosis. |
OBS_SERV_ARRIVAL_DT_TM | DATETIME | Y | The start of the observation encounter. |
OBS_SERV_DEPART_DT_TM | DATETIME | Y | The end of the observation encounter. |
OBS_SERV_ENCNTR_ID | DOUBLE | N | The ID of the observation services encounter associated to the record. |
OBS_VTE_DX_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying Obstetrics VTE diagnosis. |
OFXA_ADMIN_VTE1_DT_TM | DATETIME | Y | The first administration of Oral Factor xA after meeting VTE1 requirements |
OFXA_ADMIN_VTE1_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Oral Factor Xa Inhibitor |
OFXA_ADMIN_VTE2_DT_TM | DATETIME | Y | The first administration of Oral Factor xA after meeting VTE2 requirements |
OFXA_ADMIN_VTE2_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Oral Factor Xa Inhibitor |
ORG_MRN_TXT | VARCHAR(50) | Y | Medical Record Number of the record. |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility. |
PATIENT_IDENT | VARCHAR(50) | Y | Identifies the earliest documented medical record number of the patient. |
PERSON_ETHNIC_CODE_DISPLAY | VARCHAR(300) | Y | String to store ethnicity display. |
PERSON_GENDER_CODE_DISPLAY | VARCHAR(300) | Y | String to store gender display. |
PERSON_ID | DOUBLE | N | The ID of the person associated to the record. |
PERSON_PAYER_CODE_DISPLAY | VARCHAR(300) | Y | String to store payer display. |
PERSON_RACE_DESC | VARCHAR(300) | Y | String to store multiple races. |
PRIN_DX_HEMORRHAGIC_STK_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying Hemorrhagic Stroke principal diagnosis. |
PRIN_DX_ISCHEMIC_STK_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying Ischemic Stroke principal diagnosis. |
PRIN_DX_MENTAL_HEALTH_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying Mental Health principal diagnosis. |
PRIN_PROC_GEN_SURG_ICU_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-2 for value set 'GENERAL_SURGERY' |
PRIN_PROC_GEN_SURG_IP_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-1 for value set 'GENERAL_SURGERY' |
PRIN_PROC_GYNEC_SURG_ICU_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-2 for value set 'GYNECOLOGICAL_SURGERY' |
PRIN_PROC_GYNEC_SURG_IP_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-1 for value set 'GYNECOLOGICAL_SURGERY' |
PRIN_PROC_HIP_FRAC_ICU_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-2 for value set 'HIP_FRACTURE_SURGERY' |
PRIN_PROC_HIP_FRAC_IP_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-1 for value set 'HIP_FRACTURE_SURGERY' |
PRIN_PROC_HIP_REPL_ICU_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-2 for value set 'HIP_REPLACEMENT_SURGERY' |
PRIN_PROC_HIP_REPL_IP_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-1 for value set 'HIP_REPLACEMENT_SURGERY' |
PRIN_PROC_KNEE_REPL_ICU_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-2 for value set 'KNEE_REPLACEMENT_SURGERY' |
PRIN_PROC_KNEE_REPL_IP_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-1 for value set 'KNEE_REPLACEMENT_SURGERY' |
PRIN_PROC_NEURO_SURG_ICU_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-2 for value set 'INTRACRANIAL_NEUROSURGERY' |
PRIN_PROC_NEURO_SURG_IP_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-1 for value set 'INTRACRANIAL_NEUROSURGERY' |
PRIN_PROC_URO_SURG_ICU_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-2 for value set 'UROLOGICAL_SURGERY' |
PRIN_PROC_URO_SURG_IP_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-1 for value set 'UROLOGICAL_SURGERY' |
RVBT_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering Rivaroxaban or Betrixaban were documented |
RVBT_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusal for not ordering/administering Rivaroxaban or Betrixaban were documented |
RVBT_VTE1_ADMIN_DT_TM | DATETIME | Y | The first date/time of Rivaroxaban or Betrixaban after meeting VTE1 requirements |
RVBT_VTE1_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Rivaroxaban |
RVBT_VTE2_ADMIN_DT_TM | DATETIME | Y | The first date/time of Rivaroxaban or Betrixaban after meeting VTE2 requirements |
RVBT_VTE2_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Rivaroxaban |
SCRIPT_VERSION | DOUBLE | Y | The version number of the script that populated the row |
SRC_UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated to be preserved during extracts. |
SRC_UPDT_SOURCE | VARCHAR(50) | Y | The script name responsible for updating the record to be preserved during extracts. |
THROM_VTE1_ADMIN_DT_TM | DATETIME | Y | The first administration of Direct Thrombin Inhibitor meeting VTE1 requirements |
THROM_VTE1_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Direct Thrombin Inhibitor |
THROM_VTE2_ADMIN_DT_TM | DATETIME | Y | The first administration of Direct Thrombin Inhibitor meeting VTE2 requirements |
THROM_VTE2_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Direct Thrombin Inhibitor |
TIME_ZONE_TXT | VARCHAR(300) | Y | The timezone of the record in ""America/Chicago"" format. |
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. |
VFP_APPLIED_VTE1_PROC_DT_TM | DATETIME | Y | The first application of VFP procedure after meeting VTE1 requirements |
VFP_APPLIED_VTE2_PROC_DT_TM | DATETIME | Y | The first application of VFP procedure after meeting VTE2 requirements |
VFP_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering VFP were documented |
VFP_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusals for not ordering/administering VFP were documented |
VTE1_ICU_ADMIT_DT_TM | DATETIME | Y | The start date/time of ICU for VTE-1 |
VTE1_ICU_DEPART_DT_TM | DATETIME | Y | The end date/time of ICU for VTE-1 |
VTE1_LOW_RISK_IND | DOUBLE | Y | Indicates if Low Risk is documented on a patient for VTE-1 |
VTE2_ICU_ADMIT_DT_TM | DATETIME | Y | The start date/time of ICU for VTE-2 |
VTE2_ICU_DEPART_DT_TM | DATETIME | Y | The end date/time of ICU for VTE-2 |
VTE2_LOW_RISK_IND | DOUBLE | Y | Indicates if Low Risk is documented on a patient for VTE-2 |
VTE_DX_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying VTE diagnosis. |
VTE_DX_PRIOR_DT_TM | DATETIME | Y | The date/time of the VTE diagnosis prior to the inpatient encounter |
VTE_DX_PRIOR_NOMEN | VARCHAR(50) | Y | The nomenclature of the VTE diagnosis prior to inpatient |
WARF_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering Warfarin were documented |
WARF_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusal for not ordering/administering Warfarin were documented |
WARF_VTE1_ADMIN_DT_TM | DATETIME | Y | The first date/time of Warfarin after meeting VTE1 requirements |
WARF_VTE1_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Warfarin |
WARF_VTE2_ADMIN_DT_TM | DATETIME | Y | The first date/time of Warfarin after meeting VTE2 requirements |
WARF_VTE2_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Warfarin |
Relationship Detail - LH_E_VTE_2023_METRICS
Child Column in LH_E_VTE_2023_METRICS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | D_ADMIT_SRC_ID | LH_D_ADMIT_SRC | D_ADMIT_SRC_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_SRC | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_D_ADMIT_TYPE | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_D_BR_CCN | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BR_CCN | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_D_BR_HCO | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BR_HCO | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
D_DISCHARGE_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
D_DISCH_DISP_ID | LH_D_DISCH_DISP | D_DISCH_DISP_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_DISCH_DISP | HEALTH_SYSTEM_SOURCE_ID | |
D_ENCNTR_TYPE_ID | LH_D_ENCNTR_TYPE | D_ENCNTR_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ENCNTR_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
D_DISCHARGE_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
D_METRIC_1_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_2_ID | LH_D_METRIC | D_METRIC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
D_DISCHARGE_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_D_PERSON | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSON | HEALTH_SYSTEM_SOURCE_ID | |
D_ATTEND_PRSNL_ID | LH_D_PERSONNEL | D_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSONNEL | HEALTH_SYSTEM_SOURCE_ID |
LH_E_VTE_2024_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Lighthouse eMeasures VTE 2024 Metrics |
Definition: | Stores data gathered by the LH_E_VTE_2024 script. |
Table Type: | ACTIVITY |
Column Detail - LH_E_VTE_2024_METRICS
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. |
ANES_ICU_END_DT_TM | DATETIME | Y | The end date/time of anesthesia after inpatient admission |
ANES_IP_END_DT_TM | DATETIME | Y | The end date/time of anesthesia for VTE-1 |
ATRIAL_FIB_NOMEN | VARCHAR(50) | Y | The code of the Atrial Fibrillation active diagnosis |
CM_ORD_VTE1_DT_TM | DATETIME | Y | The date/time comfort measures was ordered for VTE1 requirements |
CM_ORD_VTE2_DT_TM | DATETIME | Y | The date/time comfort measures was ordered for VTE2 requirements |
CM_PERF_VTE1_DT_TM | DATETIME | Y | The date/time comfort measures was performed for VTE1 requirements |
CM_PERF_VTE2_DT_TM | DATETIME | Y | The date/time comfort measures was performed for VTE2 requirements |
DEN_2_IND | DOUBLE | Y | Identifies if the encounter is In Denominator for VTE-2 |
DISCHARGE_DT_TM | DATETIME | Y | The end of the qualifying encounter. |
D_ADMIT_BUILDING_ID | DOUBLE | N | Dimension ID for admit building. |
D_ADMIT_FACILITY_ID | DOUBLE | N | Dimension ID for admit facility. |
D_ADMIT_NURSE_UNIT_ID | DOUBLE | N | Dimension ID for admit nurse unit. |
D_ADMIT_SRC_ID | DOUBLE | N | Dimension ID for admit source. |
D_ADMIT_TYPE_ID | DOUBLE | N | Dimension ID for admit type. |
D_ATTEND_PRSNL_ID | DOUBLE | N | Dimension ID for attending physician. |
D_BR_CCN_ID | DOUBLE | N | Dimension ID for CCN. |
D_BR_HCO_ID | DOUBLE | N | Dimension ID for HCO. |
D_DISCHARGE_BUILDING_ID | DOUBLE | N | Dimension ID for discharge building. |
D_DISCHARGE_FACILITY_ID | DOUBLE | N | Dimension ID for discharge facility. |
D_DISCHARGE_NURSE_UNIT_ID | DOUBLE | N | Dimension ID for discharge nurse unit. |
D_DISCH_DISP_ID | DOUBLE | N | Dimension ID for discharge disposition. |
D_ENCNTR_TYPE_ID | DOUBLE | N | Dimension ID for encounter type. |
D_METRIC_1_ID | DOUBLE | N | Dimension ID for VTE-1 metric. |
D_METRIC_2_ID | DOUBLE | N | Dimension ID for VTE-2 metric. |
D_PERSON_ID | DOUBLE | N | Dimension ID for person data. |
ED_ARRIVAL_DT_TM | DATETIME | Y | The start of the emergency encounter. |
ED_DEPART_DT_TM | DATETIME | Y | The end of the emergency encounter. |
ED_ENCNTR_ID | DOUBLE | N | The ID of the emergency encounter associated to the record. |
ENCNTR_ID | DOUBLE | N | The ID of the qualifying encounter associated to the record. |
EXCEP_2_IND | DOUBLE | Y | Identifies if the encounter is a Denominator Exception for VTE-2 |
EXCLUDE_1_IND | DOUBLE | Y | Identifies if the encounter is In Denominator Exclusion for VTE-1 |
EXCLUDE_2_IND | DOUBLE | Y | Identifies if the encounter is In Denominator Exclusion for VTE-2 |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FINANCIAL_NBR_TXT | VARCHAR(50) | Y | Financial Number of the record. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time that the first ETL process started that created this record. |
GCS_APPLIED_VTE1_PROC_DT_TM | DATETIME | Y | The first application of GCS procedure after meeting VTE1 requirements |
GCS_APPLIED_VTE2_PROC_DT_TM | DATETIME | Y | The first application of GCS procedure after meeting VTE2 requirements |
GCS_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering GCS were documented |
GCS_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusals for not ordering/administering GCS were documented |
GLYCOPROTEIN_VTE1_DT_TM | DATETIME | Y | The first administration of Glycoprotein meeting VTE1 requirements |
GLYCOPROTEIN_VTE1_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Glycoprotein lIb/llla Inhibitors |
GLYCOPROTEIN_VTE2_DT_TM | DATETIME | Y | The first administration of Glycoprotein meeting VTE2 requirements |
GLYCOPROTEIN_VTE2_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Glycoprotein lIb/llla Inhibitors |
HEALTH_SYSTEM_ID | DOUBLE | N | Identifies the delivery network responsible for supplying the data. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data. |
HIP_REPLACE_DT_TM | DATETIME | Y | The date/time of the hip replacment surgery |
HIP_REPLACE_NOMEN | VARCHAR(50) | Y | The code of hip replacement surgery |
IFXA_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering Injectable Factor xA were documented |
IFXA_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusal for not ordering/administering Injectable Factor xA were documented |
IFXA_VTE1_ADMIN_DT_TM | DATETIME | Y | The first administration of Injectable Factor xA after meeting VTE1 requirements |
IFXA_VTE1_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Injectable Factor Xa Inhibitor |
IFXA_VTE2_ADMIN_DT_TM | DATETIME | Y | The first administration of Injectable Factor xA after meeting VTE2 requirements |
IFXA_VTE2_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Injectable Factor Xa Inhibitor |
INR_VTE1_TXT | VARCHAR(100) | Y | INR result text for INRs meeting VTE1 Requirements |
INR_VTE2_TXT | VARCHAR(100) | Y | INR result text for INRs meeting VTE2 Requirements |
IPC_APPLIED_VTE1_PROC_DT_TM | DATETIME | Y | The first application of IPC procedure after meeting VTE1 requirements |
IPC_APPLIED_VTE2_PROC_DT_TM | DATETIME | Y | The first application of IPC procedure after meeting VTE2 requirements |
IPC_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering IPC were documented |
IPC_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusals for not ordering/administering IPC were documented |
IPP_IND | DOUBLE | Y | Indicates the encounter within the initial patient population |
IP_ADMIT_DT_TM | DATETIME | Y | The start of the inpatient encounter. |
IV_UFH_VTE1_ADMIN_DT_TM | DATETIME | Y | The first administration of IV Unfractionated Heparin after meeting VTE1 requirements |
IV_UFH_VTE1_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Unfractionated Heparin |
IV_UFH_VTE2_ADMIN_DT_TM | DATETIME | Y | The first administration of IV Unfractionated Heparin after meeting VTE2 requirements |
IV_UFH_VTE2_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Unfractionated Heparin |
KNEE_REPLACE_DT_TM | DATETIME | Y | The date/time of the knee replacment surgery |
KNEE_REPLACE_NOMEN | VARCHAR(50) | Y | The code of knee replacement surgery |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
LDUH_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering LDUH for VTE were documented |
LDUH_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusal for not ordering/administering LDUH for VTE were documented |
LDUH_VTE1_ADMIN_DT_TM | DATETIME | Y | The first administration of Subcutaneous LDUH meeting VTE1 requirements |
LDUH_VTE1_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Low Dose Unfractionated Heparin |
LDUH_VTE2_ADMIN_DT_TM | DATETIME | Y | The first administration of Subcutaneous LDUH meeting VTE2 requirements |
LDUH_VTE2_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Low Dose Unfractionated Heparin |
LH_E_VTE_2024_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_E_VTE_2024_METRICS table. |
LMWH_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering LMWH were documented |
LMWH_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusal for not ordering/administering LMWH were documented |
LMWH_VTE1_ADMIN_DT_TM | DATETIME | Y | The first administration of LMWH after meeting VTE1 requirements |
LMWH_VTE1_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Low Molecular Weight Heparin |
LMWH_VTE2_ADMIN_DT_TM | DATETIME | Y | The first administration of LMWH after meeting VTE2 requirements |
LMWH_VTE2_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Low Molecular Weight Heparin |
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. |
NUM_1_IND | DOUBLE | Y | Identifies if the encounter is Numerator for VTE-1 |
NUM_2_IND | DOUBLE | Y | Identifies if the encounter is Numerator for VTE-2 |
OBS_DX_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying Obstetrics diagnosis. |
OBS_SERV_ARRIVAL_DT_TM | DATETIME | Y | The start of the observation encounter. |
OBS_SERV_DEPART_DT_TM | DATETIME | Y | The end of the observation encounter. |
OBS_SERV_ENCNTR_ID | DOUBLE | N | The ID of the observation services encounter associated to the record. |
OBS_VTE_DX_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying Obstetrics VTE diagnosis. |
OFXA_ADMIN_VTE1_DT_TM | DATETIME | Y | The first administration of Oral Factor xA after meeting VTE1 requirements |
OFXA_ADMIN_VTE1_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Oral Factor Xa Inhibitor |
OFXA_ADMIN_VTE2_DT_TM | DATETIME | Y | The first administration of Oral Factor xA after meeting VTE2 requirements |
OFXA_ADMIN_VTE2_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Oral Factor Xa Inhibitor |
ORG_MRN_TXT | VARCHAR(50) | Y | Medical Record Number of the record. |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility. |
PATIENT_IDENT | VARCHAR(50) | Y | Identifies the earliest documented medical record number of the patient. |
PERSON_ETHNIC_CODE_DISPLAY | VARCHAR(300) | Y | String to store ethnicity display. |
PERSON_GENDER_CODE_DISPLAY | VARCHAR(300) | Y | String to store gender display. |
PERSON_ID | DOUBLE | N | The ID of the person associated to the record. |
PERSON_PAYER_CODE_DISPLAY | VARCHAR(300) | Y | String to store payer display. |
PERSON_RACE_DESC | VARCHAR(300) | Y | String to store multiple races. |
PRIN_DX_HEMORRHAGIC_STK_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying Hemorrhagic Stroke principal diagnosis. |
PRIN_DX_ISCHEMIC_STK_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying Ischemic Stroke principal diagnosis. |
PRIN_DX_MENTAL_HEALTH_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying Mental Health principal diagnosis. |
PRIN_PROC_GEN_SURG_ICU_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-2 for value set 'GENERAL_SURGERY' |
PRIN_PROC_GEN_SURG_IP_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-1 for value set 'GENERAL_SURGERY' |
PRIN_PROC_GYNEC_SURG_ICU_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-2 for value set 'GYNECOLOGICAL_SURGERY' |
PRIN_PROC_GYNEC_SURG_IP_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-1 for value set 'GYNECOLOGICAL_SURGERY' |
PRIN_PROC_HIP_FRAC_ICU_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-2 for value set 'HIP_FRACTURE_SURGERY' |
PRIN_PROC_HIP_FRAC_IP_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-1 for value set 'HIP_FRACTURE_SURGERY' |
PRIN_PROC_HIP_REPL_ICU_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-2 for value set 'HIP_REPLACEMENT_SURGERY' |
PRIN_PROC_HIP_REPL_IP_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-1 for value set 'HIP_REPLACEMENT_SURGERY' |
PRIN_PROC_KNEE_REPL_ICU_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-2 for value set 'KNEE_REPLACEMENT_SURGERY' |
PRIN_PROC_KNEE_REPL_IP_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-1 for value set 'KNEE_REPLACEMENT_SURGERY' |
PRIN_PROC_NEURO_SURG_ICU_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-2 for value set 'INTRACRANIAL_NEUROSURGERY' |
PRIN_PROC_NEURO_SURG_IP_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-1 for value set 'INTRACRANIAL_NEUROSURGERY' |
PRIN_PROC_URO_SURG_ICU_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-2 for value set 'UROLOGICAL_SURGERY' |
PRIN_PROC_URO_SURG_IP_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying principal procedure for VTE-1 for value set 'UROLOGICAL_SURGERY' |
RVBT_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering Rivaroxaban or Betrixaban were documented |
RVBT_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusal for not ordering/administering Rivaroxaban or Betrixaban were documented |
RVBT_VTE1_ADMIN_DT_TM | DATETIME | Y | The first date/time of Rivaroxaban or Betrixaban after meeting VTE1 requirements |
RVBT_VTE1_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Rivaroxaban |
RVBT_VTE2_ADMIN_DT_TM | DATETIME | Y | The first date/time of Rivaroxaban or Betrixaban after meeting VTE2 requirements |
RVBT_VTE2_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Rivaroxaban |
SCRIPT_VERSION | DOUBLE | Y | The version number of the script that populated the row |
SRC_UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated to be preserved during extracts. |
SRC_UPDT_SOURCE | VARCHAR(50) | Y | The script name responsible for updating the record to be preserved during extracts. |
THROM_VTE1_ADMIN_DT_TM | DATETIME | Y | The first administration of Direct Thrombin Inhibitor meeting VTE1 requirements |
THROM_VTE1_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Direct Thrombin Inhibitor |
THROM_VTE2_ADMIN_DT_TM | DATETIME | Y | The first administration of Direct Thrombin Inhibitor meeting VTE2 requirements |
THROM_VTE2_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Direct Thrombin Inhibitor |
TIME_ZONE_TXT | VARCHAR(300) | Y | The timezone of the record in ""America/Chicago"" format. |
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. |
VFP_APPLIED_VTE1_PROC_DT_TM | DATETIME | Y | The first application of VFP procedure after meeting VTE1 requirements |
VFP_APPLIED_VTE2_PROC_DT_TM | DATETIME | Y | The first application of VFP procedure after meeting VTE2 requirements |
VFP_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering VFP were documented |
VFP_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusals for not ordering/administering VFP were documented |
VTE1_ICU_ADMIT_DT_TM | DATETIME | Y | The start date/time of ICU for VTE-1 |
VTE1_ICU_DEPART_DT_TM | DATETIME | Y | The end date/time of ICU for VTE-1 |
VTE1_LOW_RISK_IND | DOUBLE | Y | Indicates if Low Risk is documented on a patient for VTE-1 |
VTE2_ICU_ADMIT_DT_TM | DATETIME | Y | The start date/time of ICU for VTE-2 |
VTE2_ICU_DEPART_DT_TM | DATETIME | Y | The end date/time of ICU for VTE-2 |
VTE2_LOW_RISK_IND | DOUBLE | Y | Indicates if Low Risk is documented on a patient for VTE-2 |
VTE_DX_NOMEN | VARCHAR(50) | Y | The nomenclature of a qualifying VTE diagnosis. |
VTE_DX_PRIOR_DT_TM | DATETIME | Y | The date/time of the VTE diagnosis prior to the inpatient encounter |
VTE_DX_PRIOR_NOMEN | VARCHAR(50) | Y | The nomenclature of the VTE diagnosis prior to inpatient |
WARF_MEDRES_MASK | DOUBLE | Y | Identifies which Medical Reasons for not ordering/administering Warfarin were documented |
WARF_PATREF_MASK | DOUBLE | Y | Identifies which Patient Refusal for not ordering/administering Warfarin were documented |
WARF_VTE1_ADMIN_DT_TM | DATETIME | Y | The first date/time of Warfarin after meeting VTE1 requirements |
WARF_VTE1_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Warfarin |
WARF_VTE2_ADMIN_DT_TM | DATETIME | Y | The first date/time of Warfarin after meeting VTE2 requirements |
WARF_VTE2_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Warfarin |
Relationship Detail - LH_E_VTE_2024_METRICS
Child Column in LH_E_VTE_2024_METRICS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | D_ADMIT_SRC_ID | LH_D_ADMIT_SRC | D_ADMIT_SRC_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_SRC | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_D_ADMIT_TYPE | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_D_BR_CCN | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BR_CCN | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_D_BR_HCO | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BR_HCO | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
D_DISCHARGE_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
D_DISCH_DISP_ID | LH_D_DISCH_DISP | D_DISCH_DISP_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_DISCH_DISP | HEALTH_SYSTEM_SOURCE_ID | |
D_ENCNTR_TYPE_ID | LH_D_ENCNTR_TYPE | D_ENCNTR_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ENCNTR_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
D_DISCHARGE_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
D_METRIC_1_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_2_ID | LH_D_METRIC | D_METRIC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
D_DISCHARGE_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_D_PERSON | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSON | HEALTH_SYSTEM_SOURCE_ID | |
D_ATTEND_PRSNL_ID | LH_D_PERSONNEL | D_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSONNEL | HEALTH_SYSTEM_SOURCE_ID |
LH_E_VTE_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_E_VTE_METRICS |
Definition: | This table is used to store VTE metrics from the Lighthouse eMeasure. This table is at the encounter grain. |
Table Type: | ACTIVITY |
Column Detail - LH_E_VTE_METRICS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACOAG_DISCH_IND | DOUBLE | Y | Identifies if the encounter had anticoagulant ordered as discharge meds |
ACOAG_MED_REASON_DT_TM | DATETIME | Y | Identifies the date/time that anticoagulant was not given due to medical reasons |
ACOAG_MED_REASON_UTC_DT_TM | DATETIME | Y | Identifies the date/time that anticoagulant was not given due to medical reasons normalized to GMT |
ACOAG_ORDER_DT_TM | DATETIME | Y | Identifies the date/time of the anticoagulant order on the encounter |
ACOAG_ORDER_UTC_DT_TM | DATETIME | Y | Identifies the date/time of the anticoagulant order on the encounter normalized to GMT |
ACOAG_PAT_REF_DT_TM | DATETIME | Y | Identifies the date/time that anticoagulant was not given due to patient refusal |
ACOAG_PAT_REF_UTC_DT_TM | DATETIME | Y | Identifies the date/time that anticoagulant was not given due to patient refusal normalized to GMT |
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_DT_TM | DATETIME | Y | The date/time on which the patient was admitted |
ADMIT_UTC_DT_TM | DATETIME | Y | The date/time on which the patient was admitted normalized to GMT. |
ANESTHESIA_END_DT_TM | DATETIME | Y | Identifies the date/time that anesthesia ended for the patient |
ANESTHESIA_END_UTC_DT_TM | DATETIME | Y | Identifies the date/time that anesthesia ended for the patient- normalized to GMT |
ANESTHESIA_START_DT_TM | DATETIME | Y | Identifies the date/time that anesthesia was started for the patient |
ANESTHESIA_START_UTC_DT_TM | DATETIME | Y | Identifies the date/time that anesthesia was started for the patient- normalized to GMT |
CLINICAL_PATHWAY_IND | DOUBLE | Y | Identifies patients who had a clinical pathway documented |
COMM_MRN_TXT | VARCHAR(50) | Y | Identifies the community medical record number of the patient. |
DEN_EXCEPTION_1_IND | DOUBLE | Y | Identifies patients who are a denominator exception (stage 2) |
DEN_EXCEPTION_2_IND | DOUBLE | Y | Identifies patients who are a denominator exception (stage 2) |
DEN_EXCEPTION_3_IND | DOUBLE | Y | Identifies patients who are a denominator exception (stage 2) |
DEN_EXCEPTION_4_IND | DOUBLE | Y | Identifies patients who are a denominator exception (stage 2) |
DEN_EXCEPTION_5_IND | DOUBLE | Y | Identifies patients who are a denominator exception (stage 2) |
DEN_EXCEPTION_6_IND | DOUBLE | Y | Identifies patients who are a denominator exception (stage 2) |
DEVICE_ICU_NOT_DONE_DT_TM | DATETIME | Y | Identifies the first documented medical reason for not giving a device after ICU arrival |
DEVICE_ICU_NOT_DONE_UTC_DT_TM | DATETIME | Y | Identifies the first documented medical reason for not giving a device after ICU arrival normalized to UTC |
DEVICE_NOT_DONE_DT_TM | DATETIME | Y | Identifies the date/time that the device was not given due to a medical reason |
DEVICE_NOT_DONE_UTC_DT_TM | DATETIME | Y | Identifies the date/time that the device was not given due to a medical reason normalized to GMT |
DEVICE_PAT_REF_DT_TM | DATETIME | Y | Identifies the date/time that the device was not given due to a patient refusal |
DEVICE_PAT_REF_UTC_DT_TM | DATETIME | Y | Identifies the date/time that the device was not given due to a patient refusal normalized to GMT |
DEV_CONTRA_DT_TM | DATETIME | Y | Identifies the first documented contraindication for medical devices |
DEV_CONTRA_UTC_DT_TM | DATETIME | Y | Identifies the first documented contraindication for medical devices normalized to UTC |
DISCHARGE_DISPOSITION_FLAG | DOUBLE | Y | Identifies the discharge disposition of the patient |
DISCHARGE_DT_TM | DATETIME | Y | The date/time on which the patient was discharged. |
DISCHARGE_UTC_DT_TM | DATETIME | Y | The date/time on which the patient was discharged normalized to GMT. |
D_ADMIT_BUILDING_ID | DOUBLE | N | The building to which the patient was admitted. |
D_ADMIT_FACILITY_ID | DOUBLE | N | The facility to which the patient was admitted. |
D_ADMIT_NURSE_UNIT_ID | DOUBLE | N | The nurse unit to which the patient was admitted. |
D_ADMIT_SRC_ID | DOUBLE | N | Identifies the place from which the patient came before being admitted. |
D_ADMIT_TYPE_ID | DOUBLE | N | Indicates the circumstances under which the patient was admitted. |
D_ATTEND_PRSNL_ID | DOUBLE | N | Identifies the final attending physician associated to the encounter. |
D_BR_CCN_ID | DOUBLE | N | CMS Certification Number. |
D_BR_HCO_ID | DOUBLE | N | Healthcare organization Number. |
D_DISCHARGE_BUILDING_ID | DOUBLE | N | The building from which the patient was discharged |
D_DISCHARGE_FACILITY_ID | DOUBLE | N | The facility from which the patient was discharged |
D_DISCHARGE_NURSE_UNIT_ID | DOUBLE | N | The nurse unit from which the patient was discharged |
D_DISCH_DISP_ID | DOUBLE | N | Defines the discharge disposition of the encounter. |
D_ENCNTR_TYPE_ID | DOUBLE | N | Categorizes the encounter into a logical group or type. |
D_MED_SERVICE_ID | DOUBLE | N | The type or category of medical service that the patient is receiving in relation to their encounter. The category may be treatment type surgery general resources or others. |
D_METRIC_1_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_2_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_3_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_4_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_5_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_6_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_7_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_PERSON_ID | DOUBLE | N | The person that qualified for the quality metric. |
ED_ARRIVAL_DT_TM | DATETIME | Y | Time the patient arrived the emergency department. |
ED_ARRIVAL_UTC_DT_TM | DATETIME | Y | Time the patient arrived the emergency department normalized to GMT. |
ED_DEPART_DT_TM | DATETIME | Y | Time the patient departed from the emergency department. |
ED_DEPART_UTC_DT_TM | DATETIME | Y | Time the patient departed from the emergency department. normalized to GMT |
ED_ENCNTR_ID | DOUBLE | N | Identifies the encounter is admitted through the ED |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
EXCLUDE_SG1_1_IND | DOUBLE | Y | Identifies patients excluded for the measure (stage 1) |
EXCLUDE_SG1_2_IND | DOUBLE | Y | Identifies patients excluded for the measure (stage 1) |
EXCLUDE_SG1_3_IND | DOUBLE | Y | Identifies patients excluded for the measure (stage 1) |
EXCLUDE_SG1_4_IND | DOUBLE | Y | Identifies patients excluded for the measure (stage 1) |
EXCLUDE_SG1_5_IND | DOUBLE | Y | Identifies patients excluded for the measure (stage 1) |
EXCLUDE_SG1_6_IND | DOUBLE | Y | Identifies patients excluded for the measure (stage 1) |
EXCLUDE_SG2_1_IND | DOUBLE | Y | Identifies patients excluded for the measure (stage 2) |
EXCLUDE_SG2_2_IND | DOUBLE | Y | Identifies patients excluded for the measure (stage 2) |
EXCLUDE_SG2_3_IND | DOUBLE | Y | Identifies patients excluded for the measure (stage 2) |
EXCLUDE_SG2_4_IND | DOUBLE | Y | Identifies patients excluded for the measure (stage 2) |
EXCLUDE_SG2_5_IND | DOUBLE | Y | Identifies patients excluded for the measure (stage 2) |
EXCLUDE_SG2_6_IND | DOUBLE | Y | Identifies patients excluded for the measure (stage 2) |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FINANCIAL_NBR_TXT | VARCHAR(50) | Y | The financial number alias associated to the encounter. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time the record was first loaded into the table. |
HEALTH_SYSTEM_ID | DOUBLE | N | Identifies the delivery network responsible for supplying the data. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data. |
HEMORRHAGIC_STK_DX_IND | DOUBLE | Y | Identifies patients who had a hemorrhagic stroke diagnosis |
ICU_ADMIT_DT_TM | DATETIME | Y | Identifies when patients where admitted to the ICU |
ICU_ADMIT_UTC_DT_TM | DATETIME | Y | Identifies when patients where admitted to the ICU normalized to GMT |
ICU_DEPART_DT_TM | DATETIME | Y | Identifies when patients left the ICU |
ICU_DEPART_UTC_DT_TM | DATETIME | Y | identifies when patients left the ICU normalized to GMT |
ICU_PROPH_ADMIN_DT_TM | DATETIME | Y | Identifies the first prophylaxis administration after ICU arrival |
ICU_PROPH_ADMIN_UTC_DT_TM | DATETIME | Y | Identifies the first prophylaxis administration after ICU arrival normalized to GMT |
INP_PRINCIPAL_PROCEDURE_FLAG | DOUBLE | Y | Identifies the principal procedure that occurred during the inpatient encounter |
INR_ICU_IND | DOUBLE | Y | Identifies if there was a qualifying INR result during the appropriate timeframe, in reference to ICU arrival |
INR_INPT_IND | DOUBLE | Y | Identifies if there was a qualifying INR result during the appropriate timeframe, in reference to inpatient admission |
INR_LAST_ACOAG_IND | DOUBLE | Y | Identifies if there was a qualifying INR result during the appropriate timeframe, in reference to the last anticoagulation administration |
INR_RESULT_DT_TM | DATETIME | Y | Identifies the date/time that the INR result was documented |
INR_RESULT_UTC_DT_TM | DATETIME | Y | Identifies the date/time that the INR result was documented normalized to GMT |
INR_RESULT_VALUE | DOUBLE | Y | Identifies the INR value documented for the patient |
ISCHEMIC_STK_DX_IND | DOUBLE | Y | Identifies patients who had an ischemic stroke diagnosis |
IV_UFH_ADMIN_DT_TM | DATETIME | Y | Identifies the date/time that IV Unfractionated Heparin was first given |
IV_UFH_ADMIN_UTC_DT_TM | DATETIME | Y | Identifies the date/time that IV Unfractionated Heparin was first given normalized to GMT |
IV_UFH_ORDER_DT_TM | DATETIME | Y | Identifies the date/time the IV Unfractionated Heparain was ordered |
IV_UFH_ORDER_UTC_DT_TM | DATETIME | Y | Identifies the date/time the IV Unfractionated Heparain was ordered normalized to GMT |
IV_UFH_STOP_DT_TM | DATETIME | Y | Identifies the date/time that IV Unfractionated Heparin was last given |
IV_UFH_STOP_UTC_DT_TM | DATETIME | Y | Identifies the date/time that IV Unfractionated Heparin was last given normalized to GMT |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time the record was last loaded into the table. |
LH_E_VTE_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_E_VTE_METRICS 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. |
MED_CONTRA_DT_TM | DATETIME | Y | Identifies the first medical contraindication documented after inpatient admission |
MED_CONTRA_UTC_DT_TM | DATETIME | Y | Identifies the first medical contraindication documented after inpatient admission normalized to UTC |
MED_PAT_REFUSAL_DT_TM | DATETIME | Y | Identifies the date/time that the prophylaxis was not given due to a patient refusal |
MED_PAT_REFUSAL_UTC_DT_TM | DATETIME | Y | Identifies the date/time that the prophylaxis was not given due to a patient refusal normalized to GMT |
MED_REASON_NOT_DONE_DT_TM | DATETIME | Y | Identifies the date/time that the prophylaxis was not given due to a medical reason |
MED_REASON_NOT_DONE_UTC_DT_TM | DATETIME | Y | Identifies the date/time that the prophylaxis was not given due to a medical reason normalized to GMT |
MED_RES_ICU_NOT_DONE_DT_TM | DATETIME | Y | Identifies the first medication reason documented after ICU arrival |
MED_RES_ICU_NOT_DONE_UTC_DT_TM | DATETIME | Y | Identifies the first medication reason documented after ICU arrival normalized to UTC |
MENTAL_DISORDER_DX_IND | DOUBLE | Y | Identifies patients who had a mental disorder diagnosed |
NOT_IN_DEN_1_IND | DOUBLE | Y | Identifies patients who are not in denominator (stage 2) |
NOT_IN_DEN_2_IND | DOUBLE | Y | Identifies patients who are not in denominator (stage 2) |
NOT_IN_DEN_3_IND | DOUBLE | Y | Identifies patients who are not in denominator (stage 2) |
NOT_IN_DEN_4_IND | DOUBLE | Y | Identifies patients who are not in denominator (stage 2) |
NOT_IN_DEN_5_IND | DOUBLE | Y | Identifies patients who are not in denominator (stage 2) |
NOT_IN_DEN_6_IND | DOUBLE | Y | Identifies patients who are not in denominator (stage 2) |
NUMERATOR_1_IND | DOUBLE | Y | Identifies patients in the numerator for the measure |
NUMERATOR_2_IND | DOUBLE | Y | Identifies patients in the numerator for the measure |
NUMERATOR_3_IND | DOUBLE | Y | Identifies patients in the numerator for the measure |
NUMERATOR_4_IND | DOUBLE | Y | Identifies patients in the numerator for the measure |
NUMERATOR_5_IND | DOUBLE | Y | Identifies patients in the numerator for the measure |
NUMERATOR_6_IND | DOUBLE | Y | Identifies patients in the numerator for the measure |
OBSTETRICS_DX_IND | DOUBLE | Y | Identifies patients who have an obstetrics diagnosis |
OBSTETRICS_VTE_DX_IND | DOUBLE | Y | Identifies patients who have an obstetrics VTE diagnosis |
ORG_MRN_TXT | VARCHAR(50) | Y | Identifies the medical record number of the patient. |
PALL_CARE_IND | DOUBLE | Y | Identifies if a Palliative Care Order or Palliative Care Performed was documented |
PALL_CARE_ORDER_DT_TM | DATETIME | Y | Identifies the date/time that a palliative care order was placed for the patient |
PALL_CARE_ORDER_UTC_DT_TM | DATETIME | Y | Identifies the date/time that a palliative care order was placed for the patient- normalized to GMT |
PALL_CARE_PERF_DT_TM | DATETIME | Y | Identifies the date/time that palliative care was performed for the patient |
PALL_CARE_PERF_UTC_DT_TM | DATETIME | Y | Identifies the date/time that palliative care was performed for the patient- normalized to GMT |
PARENTERAL_ANTICOAG_DT_TM | DATETIME | Y | Identifies the date/time that parenteral anticoagulant was given |
PARENTERAL_ANTICOAG_UTC_DT_TM | DATETIME | Y | Identifies the date/time that parenteral anticoagulant was given normalized to the patient |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility |
PAYER_CODE_TXT | VARCHAR(20) | Y | identifies the payer code value that is associated to the patient for QRDA file payer information. |
PLATELET_CNT_DT_TM | DATETIME | Y | Identifies the date/time that the platelet count was taken |
PLATELET_CNT_UTC_DT_TM | DATETIME | Y | Identifies the date/time that the platelet count was taken normalized to GMT |
POP1_SG1_IND | DOUBLE | Y | Identifies patients who are in the population for VTE-1 and VTE-2 for Stage 1 |
POP1_SG2_IND | DOUBLE | Y | Identifies patients who are in the population for VTE-1 and VTE-2 for Stage 2 |
POP2_SG1_IND | DOUBLE | Y | Identifies patients who are in the population for VTE-3- VTE-4- and VTE-5 for Stage 1 |
POP2_SG2_IND | DOUBLE | Y | Identifies patients who are in the population for VTE-3- VTE-4- and VTE-5 for Stage 2 |
POP3_SG1_IND | DOUBLE | Y | Identifies patients who are in the population for VTE-6 for Stage 1 |
POP3_SG2_IND | DOUBLE | Y | Identifies patients who are in the population for VTE-6 for Stage 2 |
PRINCIPAL_DX_OBS_VTE_IND | DOUBLE | Y | Identifies patients who had a principle diagnosis of Obstetrics VTE |
PRINCIPAL_DX_VTE_IND | DOUBLE | Y | Identifies patients who had a principle diagnosis of VTE |
PRINCIPAL_PROCEDURE_DT_TM | DATETIME | Y | Identifies the date/time that the principal procedure was documented |
PRINCIPAL_PROCEDURE_UTC_DT_TM | DATETIME | Y | Identifies the date/time that the principal procedure was documented normalized to GMT |
PROPH_ADMINISTERED_MASK | DOUBLE | Y | Identifies the type of prophylaxis given to the patient |
PROPH_ADMIN_DT_TM | DATETIME | Y | Identifies the date/time of prophylaxis given to the patient |
PROPH_ADMIN_UTC_DT_TM | DATETIME | Y | Identifies the date/time of prophylaxis given to the patient normalized to GMT |
TREATMENT_ADJUST_IND | DOUBLE | Y | Identifies patients who had treatment adjusted |
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. |
VTE_CONFIRM_DT_TM | DATETIME | Y | Identifies the date/time that VTE was confirmed for the patient |
VTE_CONFIRM_UTC_DT_TM | DATETIME | Y | Identifies the date/time that VTE was confirmed for the patient normalized to GMT |
VTE_DIAG_ORDER_DT_TM | DATETIME | Y | Identifies the date/time that the diagnosis for VTE or Obstetrics VTE was documented |
VTE_DIAG_ORDER_UTC_DT_TM | DATETIME | Y | Identifies the date/time that the diagnosis for VTE or Obstetrics VTE was documented normalized to GMT |
VTE_DIAG_TEST_DT_TM | DATETIME | Y | Identifies the date/time that a VTE diagnostic test was performed |
VTE_DIAG_TEST_UTC_DT_TM | DATETIME | Y | Identifies the date/time that a VTE diagnostic test was performed normalized to GMT |
VTE_DT_TM | DATETIME | Y | Identifies the date/time that VTE was diagnosed or suspected |
VTE_DX_IND | DOUBLE | Y | Identifies patients who have a VTE diagnosis |
VTE_EDUCATION_MASK | DOUBLE | Y | Identifies the type of education given to the patient regarding VTE |
VTE_LOW_RISK_DT_TM | DATETIME | Y | Identifies the date/time that a VTE risk assessment was done with a result of Low |
VTE_LOW_RISK_UTC_DT_TM | DATETIME | Y | Identifies the date/time that a VTE risk assessment was done with a result of Low normalized to GMT |
VTE_ONSET_DT_TM | DATETIME | Y | Identifies the date that the VTE problem was onset |
VTE_ONSET_UTC_DT_TM | DATETIME | Y | Identifies the date that the VTE problem was onset normalized to GMT |
VTE_UTC_DT_TM | DATETIME | Y | Identifies the date/time that VTE was diagnosed or suspected normalized to GMT |
WARFARIN_ADMIN_DT_TM | DATETIME | Y | Identifies the date/time that warfarin was first administered |
WARFARIN_ADMIN_UTC_DT_TM | DATETIME | Y | Identifies the date/time that warfarin was first administered normalized to GMT |
WARFARIN_DISCH_IND | DOUBLE | Y | Identifies patients who were given warfarin at discharge |
WRITTEN_INFO_PAT_REF_IND | DOUBLE | Y | Identifies patients who refused written information |
Relationship Detail - LH_E_VTE_METRICS
Child Column in LH_E_VTE_METRICS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | D_ADMIT_SRC_ID | LH_D_ADMIT_SRC | D_ADMIT_SRC_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_SRC | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_D_ADMIT_TYPE | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_D_BR_CCN | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BR_CCN | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_D_BR_HCO | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BR_HCO | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
D_DISCHARGE_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
D_DISCH_DISP_ID | LH_D_DISCH_DISP | D_DISCH_DISP_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_DISCH_DISP | HEALTH_SYSTEM_SOURCE_ID | |
D_ENCNTR_TYPE_ID | LH_D_ENCNTR_TYPE | D_ENCNTR_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ENCNTR_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
D_DISCHARGE_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
D_MED_SERVICE_ID | LH_D_MED_SERVICE | D_MED_SERVICE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_MED_SERVICE | HEALTH_SYSTEM_SOURCE_ID | |
D_METRIC_1_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_2_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_3_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_4_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_5_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_6_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_7_ID | LH_D_METRIC | D_METRIC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
D_DISCHARGE_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_D_PERSON | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSON | HEALTH_SYSTEM_SOURCE_ID | |
D_ATTEND_PRSNL_ID | LH_D_PERSONNEL | D_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSONNEL | HEALTH_SYSTEM_SOURCE_ID |