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