Table Detail Report

LH_E_VTE_2016_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_E_VTE_2016_METRICS
Definition: Holds data for EH VTE data for 2016 Submission.
Table Type: ACTIVITY





Column Detail - LH_E_VTE_2016_METRICS


Column Name Type Null? Definition
ACTIVE_ATRIAL_FIB_NOMEN VARCHAR(50) Y The code of the Atrial Fibrillation active diagnosis.
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ADMIT_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.
ANES_ICU_END_DT_TM DATETIME Y The first documentation of anesthesia end after ICU arrival
ANES_ICU_END_UTC_DT_TM DATETIME Y The first documentation of anesthesia end after ICU arrival normalized to GMT
ANES_IP_END_DT_TM DATETIME Y The end date/time of anesthesia after inpatient admission
ANES_IP_END_UTC_DT_TM DATETIME Y The end date/time of anesthesia after inpatient admission normalized to GMT
ATRIAL_FIB_FLUT_DX_ACT_IND DOUBLE Y If there was a diagnosis of atrial fibrillation/flutter during the IP encounter
ATRIAL_FIB_FLUT_DX_INACT_IND DOUBLE Y If there was a diagnosis of atrial fibrillation/flutter prior to the IP encounter
ATRIAL_FIB_FLUT_PROB_ACT_IND DOUBLE Y If there was a problem of atrial fibrillation/flutter during the IP encounter
ATRIAL_FIB_FLUT_PROB_INACT_IND DOUBLE Y If there was a problem of atrial fibrillation/flutter prior to the IP encounter
CLINICAL_PATHWAY_CD_DESC VARCHAR(60) Y The code of the clinical pathway protocol
CLINICAL_PATHWAY_EVENT_IND DOUBLE Y If there was documentation of a Clinical Pathway Protocol clinical event
CLINICAL_PATHWAY_ORDER_IND DOUBLE Y If there was documentation of a Clinical Pathway Protocol order
CMO_MASK DOUBLE Y **OBSOLETE COLUMN**Identifies which CMO documentations are ordered or performed
CMO_ORDER_ANS_ICU_DT_TM DATETIME Y The date of CMO order documentation after anesthesia on ICU encounter
CMO_ORDER_ANS_ICU_UTC_DT_TM DATETIME Y The utc date of CMO order documentation after anesthesia on ICU encounter
CMO_ORDER_ANS_IP_DT_TM DATETIME Y The date of CMO order documentation after anesthesia on inpatient encounter
CMO_ORDER_ANS_IP_UTC_DT_TM DATETIME Y The utc date of CMO order documentation after anesthesia on inpatient encounter
CMO_ORDER_ED_DT_TM DATETIME Y The date of CMO order documentation on ed encounter
CMO_ORDER_ED_UTC_DT_TM DATETIME Y The utc date of CMO order documentation on ed encounter
CMO_ORDER_ICU_DT_TM DATETIME Y The date of CMO order documentation on icu encounter
CMO_ORDER_ICU_UTC_DT_TM DATETIME Y The utc date of CMO order documentation on icu encounter
CMO_ORDER_IP_DT_TM DATETIME Y The date of CMO order documentation on inpatient encounter
CMO_ORDER_IP_UTC_DT_TM DATETIME Y The utc date of CMO order documentation on inpatient encounter
CMO_PERF_ANS_ICU_DT_TM DATETIME Y The date of CMO performed documentation after anesthesia on inpatient encounter
CMO_PERF_ANS_ICU_UTC_DT_TM DATETIME Y The utc date of CMO performed documentation after anesthesia on inpatient encounter
CMO_PERF_ANS_IP_DT_TM DATETIME Y The date of CMO performed documentation after anesthesia on inpatient encounter
CMO_PERF_ANS_IP_UTC_DT_TM DATETIME Y The utc date of CMO performed documentation after anesthesia on inpatient encounter
CMO_PERF_ED_DT_TM DATETIME Y The date of CMO performed documentation on ed encounter
CMO_PERF_ED_UTC_DT_TM DATETIME Y The utc date of CMO performed documentation on ed encounter
CMO_PERF_ICU_DT_TM DATETIME Y The date of CMO performed documentation on icu encounter
CMO_PERF_ICU_UTC_DT_TM DATETIME Y The utc date of CMO performed documentation on icu encounter
CMO_PERF_IP_DT_TM DATETIME Y The date of CMO performed documentation on inpatient encounter
CMO_PERF_IP_UTC_DT_TM DATETIME Y The utc date of CMO performed documentation on inpatient encounter
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
DABIGATRAN_ED_DT_TM DATETIME Y The date of the dabigatran medication administered on ED encounter
DABIGATRAN_ED_UTC_DT_TM DATETIME Y The date of the dabigatran medication administered on ED encounter normalized to GMT
DABIGATRAN_IP_DT_TM DATETIME Y The date of the dabigatran medication administered on IP encounter
DABIGATRAN_IP_UTC_DT_TM DATETIME Y The date of the dabigatran medication administered on IP encounter normalized to GMT
DEN_EXCEPTION_2_IND DOUBLE Y If the patient has a denominator exception for VTE-2
DIRECT_THROMBIN_ED_DT_TM DATETIME Y The date of direct thrombin inhibitor documented on ED encounter
DIRECT_THROMBIN_ED_IND DOUBLE Y If there was Direct Thrombin Inhibitor on ED visit encounter
DIRECT_THROMBIN_ED_UTC_DT_TM DATETIME Y The utc date of direct thrombin inhibitor documented on ED encounter
DIRECT_THROMBIN_ICU_DT_TM DATETIME Y The first administration of Direct Thrombin Inhibitor after ICU Arrival
DIRECT_THROMBIN_ICU_UTC_DT_TM DATETIME Y The first administration of Direct Thrombin Inhibitor after ICU Arrival normalized to GMT
DIRECT_THROMBIN_IP_DT_TM DATETIME Y The first administration of Direct Thrombin Inhibitor after inpatient admission
DIRECT_THROMBIN_IP_UTC_DT_TM DATETIME Y The first administration of Direct Thrombin Inhibitor after inpatient admission normalized to GMT
DISCHARGE_DISPOSITION_FLAG DOUBLE Y The discharge disposition of the encounter, based on the mapping in Bedrock
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.
DISCH_DISPOSITION_CD_DESC VARCHAR(60) Y The code of the discharge disposition
DISCH_PACOAG_DT_TM DATETIME Y The date of prescription for discharge parenteral anticoagulant
DISCH_PACOAG_IND DOUBLE Y **OBSOLETE COLUMN**If there is a prescription for discharge parenteral anticoagulant
DISCH_PACOAG_UTC_DT_TM DATETIME Y The utc date of prescription for discharge parenteral anticoagulant
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 during the visit.
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 Identifies the discharge disposition of the encounter
D_ENCNTR_TYPE_ID DOUBLE N Categorizes the encounter into a logical group or type. Foreign key to the CODE_VALUE table.
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_PERSON_ID DOUBLE N Identifies the person associated with the quality measure. Foreign key to the PERSON table.
EDU_ADVERSE_DRUG_IND DOUBLE Y If the patient received education on Adverse Drug Reactions
EDU_DRUG_INTERACTIONS_IND DOUBLE Y If the patient received education on Drug Interactions
EDU_FOLLOWUP_MONITORING_IND DOUBLE Y If the patient received education on follow-up monitoring
EDU_INR_MONITORING_IND DOUBLE Y If the patient received education on INR Monitoring
EDU_MED_COMPLIANCE_IND DOUBLE Y If the patient received education on Medication Compliance
EDU_NO_DIET_CHANGE_IND DOUBLE Y If the patient received education on Not to Change Diet
EDU_VITAMIN_K_IND DOUBLE Y If the patient received education on Vitamin K Dietary Management
EDU_WRITTEN_INFO_IND DOUBLE Y If the patient received Written Information
ED_ARRIVAL_DT_TM DATETIME Y The Arrival date/time of the ED Encounter
ED_ARRIVAL_UTC_DT_TM DATETIME Y The Arrival date/time of the ED Encounter normalized to GMT
ED_DEPART_DT_TM DATETIME Y The Depart date/time of the ED Encounter
ED_DEPART_UTC_DT_TM DATETIME Y The Depart date/time of the ED Encounter normalized to GMT
ED_ENCNTR_ID DOUBLE N The encounter ID that's associated to an ED encounter
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXCLUDE_1_IND DOUBLE Y If the patient is excluded for VTE-1
EXCLUDE_2_IND DOUBLE Y If the patient is excluded for VTE-2
EXCLUDE_3_IND DOUBLE Y If the patient is excluded for VTE-3
EXCLUDE_4_IND DOUBLE Y If the patient is excluded for VTE-4
EXCLUDE_6_IND DOUBLE Y If the patient is excluded for VTE-6
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 that the first ETL process started that created this record.
GCS_APPLIED_ANS_DT_TM DATETIME Y The first date/time of GCS after anesthesia
GCS_APPLIED_ANS_UTC_DT_TM DATETIME Y The first date/time of GCS after anesthesia normalized to GMT
GCS_APPLIED_ICU_DT_TM DATETIME Y The first application of GCS after ICU Arrival
GCS_APPLIED_ICU_UTC_DT_TM DATETIME Y The first application of GCS after ICU Arrival normalized to GMT
GCS_APPLIED_IP_DT_TM DATETIME Y The first application of GCS after inpatient admission
GCS_APPLIED_IP_UTC_DT_TM DATETIME Y The first application of GCS after inpatient admission normalized to GMT
GCS_APPLIED_TEST_DT_TM DATETIME Y The most recent application of GCS prior to VTE Diagnostic Test
GCS_APPLIED_TEST_UTC_DT_TM DATETIME Y The most recent application of GCS prior to VTE Diagnostic Test normalized to GMT
GCS_CONTRA_MASK DOUBLE Y Identifies which Medical contraindications for not ordering/administering GCS were documented
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_ANS_ICU_DT_TM DATETIME Y The first administration of Direct Thrombin Inhibitor after anesthesia end before icu
GLYCOPROTEIN_ANS_ICU_UTC_DT_TM DATETIME Y The first administration of Glycoprotein Inhibitor after anesthesia end before icu normalized to GMT
GLYCOPROTEIN_ANS_IP_DT_TM DATETIME Y The first administration of Direct Thrombin Inhibitor after anesthesia end before ip
GLYCOPROTEIN_ANS_IP_UTC_DT_TM DATETIME Y The first administration of Direct Thrombin Inhibitor after anesthesia end before ip normalized to GMT
GLYCOPROTEIN_ED_DT_TM DATETIME Y The date of glycoprotein lib/llla inhibitor documented on ED encounter
GLYCOPROTEIN_ED_IND DOUBLE Y If there was Glycoprotein Inhibitor on ED visit encounter
GLYCOPROTEIN_ED_UTC_DT_TM DATETIME Y The utc date of glycoprotein lib/llla inhibitor documented on ED encounter
GLYCOPROTEIN_ICU_DT_TM DATETIME Y The first administration of Glycoprotein Inhibitor after ICU Arrival
GLYCOPROTEIN_ICU_UTC_DT_TM DATETIME Y The first administration of Glycoprotein Inhibitor after ICU Arrival normalized to GMT
GLYCOPROTEIN_IP_DT_TM DATETIME Y The first administration of Glycoprotein Inhibitor after inpatient admission
GLYCOPROTEIN_IP_UTC_DT_TM DATETIME Y The first administration of Glycoprotein Inhibitor after inpatient admission normalized to GMT
HEALTH_INS_NBR_TXT VARCHAR(50) Y The Medicare HIC number is the identification number given to a patient who is covered by Medicare
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_FRACT_PRIOR_DISCH_IND DOUBLE Y If there was documentation of a hip fracture diagnosis prior to discharge
HIP_REPLACE_NOMEN VARCHAR(50) Y The code of hip replacement surgery.
HIP_REPLACE_PRIOR_DISCH_IND DOUBLE Y If there was documentation of a hip replacement procedure prior to discharge
ICU_ADMIT_DT_TM DATETIME Y The first date/time that the patient arrived in the ICU
ICU_ADMIT_UTC_DT_TM DATETIME Y The first date/time that the patient arrived in the ICU normalized to GMT
ICU_DEPART_DT_TM DATETIME Y The date/time when the patient left the ICU
ICU_DEPART_UTC_DT_TM DATETIME Y The date/time when the patient left the ICU normalized to GMT
IFXA_ADMIN_TEST_DT_TM DATETIME Y The most recent administration of Injectable Factor xA prior to VTE Diagnostic Test
IFXA_ADMIN_TEST_UTC_DT_TM DATETIME Y The most recent administration of Injectable Factor xA prior to VTE Diagnostic Test normalized to GMT
IFXA_ANS_ADMIN_DT_TM DATETIME Y The first date/time of Injectable Factor xA after anesthesia
IFXA_ANS_ADMIN_UTC_DT_TM DATETIME Y The first date/time of Injectable Factor xA after anesthesia normalized to GMT
IFXA_CONTRA_MASK DOUBLE Y Represents the contraindication timeframes for injectable Factor xA that are documented
IFXA_ICU_ADMIN_DT_TM DATETIME Y The first administration of Injectable Factor xA after ICU Arrival
IFXA_ICU_ADMIN_UTC_DT_TM DATETIME Y The first administration of Injectable Factor xA after ICU Arrival normalized to GMT
IFXA_IP_ADMIN_DT_TM DATETIME Y The first administration of Injectable Factor xA after inpatient admission
IFXA_IP_ADMIN_UTC_DT_TM DATETIME Y The first administration of Injectable Factor xA after inpatient admission normalized to GMT
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
INACTIVE_ATRIAL_FIB_NOMEN VARCHAR(50) Y The code of the Atrial Fibrillation inactive diagnosis.
INACTIVE_VTE_DX_NOMEN VARCHAR(50) Y The code of VTE inactive diagnosis.
INR_OVER2_DT_TM DATETIME Y The date/time of an INR result >= 2 documented after the last administration of parenteral anticoagulant
INR_OVER2_UTC_DT_TM DATETIME Y The date/time of an INR result >= 2 documented after the last administration of parenteral anticoagulant normalized to GMT
INR_OVER3_ANS_IND DOUBLE Y If there was an INR result > 3 within 1 day of anesthesia end date/time
INR_OVER3_ED_IND DOUBLE Y If there was an INR result > 3 on ED visit encounter
INR_OVER3_ICU_IND DOUBLE Y If there was an INR result > 3 within 1 day of ICU Arrival
INR_OVER3_IP_IND DOUBLE Y If there was an INR result > 3 within 1 day of inpatient admission
INR_UNDER2_DT_TM DATETIME Y The date/time of an INR result under 2 documented after the last administration of parenteral anticoagulant
INR_UNDER2_UTC_DT_TM DATETIME Y The date/time of an INR result under 2 documented after the last administration of parenteral anticoagulant normalized to GMT
IPC_APPLIED_ANS_DT_TM DATETIME Y The first date/time of IPC after anesthesia
IPC_APPLIED_ANS_UTC_DT_TM DATETIME Y The first date/time of IPC after anesthesia normalized to GMT
IPC_APPLIED_ICU_DT_TM DATETIME Y The first application of IPC after ICU Arrival
IPC_APPLIED_ICU_UTC_DT_TM DATETIME Y The first application of IPC after ICU Arrival normalized to GMT
IPC_APPLIED_IP_DT_TM DATETIME Y The first application of IPC after inpatient admission
IPC_APPLIED_IP_UTC_DT_TM DATETIME Y The first application of IPC after inpatient admission normalized to GMT
IPC_APPLIED_TEST_DT_TM DATETIME Y The most recent application of IPC prior to VTE Diagnostic Test
IPC_APPLIED_TEST_UTC_DT_TM DATETIME Y The most recent application of IPC prior to VTE Diagnostic Test normalized to GMT
IPC_CONTRA_MASK DOUBLE Y Identifies which Medical contraindications for not ordering/administering IPC were documented
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
IV_UFH_ADMIN_ED_IND DOUBLE Y **OBSOLETE COLUMN**If there was IV Unfractionated Heparin documented during the ED encounter
IV_UFH_ADMIN_IP_IND DOUBLE Y If there was IV Unfractionated Heparin documented during the IP encounter
IV_UFH_ANS_ICU_ADMIN_DT_TM DATETIME Y The first date/time of IV Unfractionated Heparin after anesthesia before icu
IV_UFH_ANS_ICU_ADMIN_UTC_DT_TM DATETIME Y The first date/time of IV Unfractionated Heparin after anesthesia before icu normalized to GMT
IV_UFH_ANS_IP_ADMIN_DT_TM DATETIME Y The first date/time of IV Unfractionated Heparin after anesthesia before ip
IV_UFH_ANS_IP_ADMIN_UTC_DT_TM DATETIME Y The first date/time of IV Unfractionated Heparin after anesthesia before ip normalized to GMT
IV_UFH_ED_ADMIN_DT_TM DATETIME Y The date of IV Unfractionated Heparin documented during the ED encounter
IV_UFH_ED_ADMIN_UTC_DT_TM DATETIME Y The utc date of IV Unfractionated Heparin documented during the ED encounter
IV_UFH_ICU_ADMIN_DT_TM DATETIME Y The first administration of IV Unfractionated Heparin after ICU Arrival
IV_UFH_ICU_ADMIN_UTC_DT_TM DATETIME Y The first administration of IV Unfractionated Heparin after ICU Arrival normalized to GMT
IV_UFH_IP_ADMIN_DT_TM DATETIME Y The first administration of IV Unfractionated Heparin after inpatient admission
IV_UFH_IP_ADMIN_UTC_DT_TM DATETIME Y The first administration of IV Unfractionated Heparin after inpatient admission normalized to GMT
IV_UFH_ORDER_DT_TM DATETIME Y The first date/time for an order for IV Unfractionated Heparin
IV_UFH_ORDER_UTC_DT_TM DATETIME Y The first date/time for an order for IV Unfractionated Heparin normalized to GMT
KNEE_REPLACE_NOMEN VARCHAR(50) Y The code of knee replacement surgery.
KNEE_REPLACE_PRIOR_DISCH_IND DOUBLE Y If there was a procedure for knee replacement documented prior to this encounter
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LDUH_CONTRA_MASK DOUBLE Y Represents the contraindication timeframes for LDUH that are documented
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
LH_E_VTE_2016_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_VTE_2016_METRICS table.
LMWH_ADMIN_TEST_DT_TM DATETIME Y The most recent administration of LMWH prior to VTE Diagnostic Test
LMWH_ADMIN_TEST_UTC_DT_TM DATETIME Y The most recent administration of LMWH prior to VTE Diagnostic Test normalized to GMT
LMWH_ANS_ADMIN_DT_TM DATETIME Y The first date/time of LMWH after anesthesia
LMWH_ANS_ADMIN_UTC_DT_TM DATETIME Y The first date/time of LMWH after anesthesia normalized to GMT
LMWH_CONTRA_MASK DOUBLE Y Represents the contraindication timeframes for LMWH that are documented
LMWH_ICU_ADMIN_DT_TM DATETIME Y The first administration of LMWH after ICU Arrival
LMWH_ICU_ADMIN_UTC_DT_TM DATETIME Y The first administration of LMWH after ICU Arrival normalized to GMT
LMWH_IP_ADMIN_DT_TM DATETIME Y The first administration of LMWH after inpatient admission
LMWH_IP_ADMIN_UTC_DT_TM DATETIME Y The first administration of LMWH after inpatient admission normalized to GMT
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
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.
NOT_IN_DEN_2_IND DOUBLE Y If the patient is not in denominator for VTE-2
NOT_IN_DEN_3_IND DOUBLE Y If the patient is not in denominator for VTE-3
NOT_IN_DEN_4_IND DOUBLE Y If the patient is not in denominator for VTE-4
NOT_IN_DEN_5_IND DOUBLE Y If the patient is not in denominator for VTE-5
NOT_IN_DEN_6_IND DOUBLE Y If the patient is not in denominator for VTE-6
NUMERATOR_1_IND DOUBLE Y If the patient is in the numerator for VTE-1
NUMERATOR_2_IND DOUBLE Y If the patient is in the numerator for VTE-2
NUMERATOR_3_IND DOUBLE Y If the patient is in the numerator for VTE-3
NUMERATOR_4_IND DOUBLE Y If the patient is in the numerator for VTE-4
NUMERATOR_5_IND DOUBLE Y If the patient is in the numerator for VTE-5
NUMERATOR_6_IND DOUBLE Y If the patient is in the numerator for VTE-6
OBS_DX_IND DOUBLE Y **OBSOLETE COLUMN**If the patient has an obstetrics diagnosis
OBS_DX_NOMEN VARCHAR(50) Y The code of the obstetrics diagnosis
OBS_VTE_DX_ED_IND DOUBLE Y **OBSOLETE COLUMN**If the patient has a Obstetrics VTE diagnosis associated to the ED encounter
OBS_VTE_DX_ED_NOMEN VARCHAR(50) Y The code of the obstetrics VTE diagnosis on ed encounter
OBS_VTE_DX_IND DOUBLE Y **OBSOLETE COLUMN**If the patient has an obstetrics VTE diagnosis
OBS_VTE_DX_INPT_IND DOUBLE Y If the patient has a Obstetrics VTE diagnosis associated to the inpatient encounter
OBS_VTE_DX_IP_NOMEN VARCHAR(50) Y The code of the obstetrics VTE diagnosis on inpatient encounter
OBS_VTE_PROB_ED_IND DOUBLE Y If there was a VTE Suspect diagnosis during the IP encounter
OBS_VTE_PROB_IP_IND DOUBLE Y If there was a Obstetrics VTE Problem active during the IP encounter
OFXA_ADMIN_ANS_DT_TM DATETIME Y The first administration of Oral Factor xA after anesthesia end
OFXA_ADMIN_ANS_UTC_DT_TM DATETIME Y The first administration of Oral Factor xA after anesthesia end normalized to GMT
OFXA_ADMIN_ICU_DT_TM DATETIME Y The first administration of Oral Factor xA after ICU Arrival
OFXA_ADMIN_ICU_UTC_DT_TM DATETIME Y The first administration of Oral Factor xA after ICU Arrival normalized to GMT
OFXA_ADMIN_IND DOUBLE Y If there was an Oral Factor xA administered on this encounter
OFXA_ADMIN_IP_DT_TM DATETIME Y The first administration of Oral Factor xA after inpatient admission
OFXA_ADMIN_IP_UTC_DT_TM DATETIME Y The first administration of Oral Factor xA after inpatient admission normalized to GMT
OFXA_ADMIN_TEST_DT_TM DATETIME Y The first administration of Oral Factor xA after VTE Diagnostic test
OFXA_ADMIN_TEST_ORD_DT_TM DATETIME Y The date of oral factor xa administration when there is a diagnostic test.
OFXA_ADMIN_TEST_ORD_UTC_DT_TM DATETIME Y The utc date of oral factor xa administration when there is a diagnostic test.
OFXA_ADMIN_TEST_UTC_DT_TM DATETIME Y The first administration of Oral Factor xA after VTE Diagnostic test normalized to GMT
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
OTH_DX_OBS_VTE_IND DOUBLE Y If the patient has a non-principal diagnosis of Obstetrics VTE
OTH_DX_VTE_IND DOUBLE Y If the patient has a non-principal diagnosis of VTE
PACOAG_LAST_ADMIN_DT_TM DATETIME Y The most recent parenteral anticoagulant administration
PACOAG_LAST_ADMIN_UTC_DT_TM DATETIME Y The most recent parenteral anticoagulant administration normalized to GMT
PACOAG_MEDRES_MASK DOUBLE Y Identifies which Medical Reasons for not ordering/administering parenteral anticoagulant were documented
PACOAG_PATREF_MASK DOUBLE Y Identifies which Patient Refusals for not ordering/administering parenteral anticoagulant were documented
PACOAG_POST_WARF_ED_DT_TM DATETIME Y The first Parenteral Anticoagulant after Warfarin was given during the ED encounter
PACOAG_POST_WARF_ED_UTC_DT_TM DATETIME Y The first Parenteral Anticoagulant after Warfarin was given during the ED encounter normalized to GMT
PACOAG_POST_WARF_IP_DT_TM DATETIME Y The first Parenteral Anticoagulant after Warfarin was given during the IP encounter
PACOAG_POST_WARF_IP_UTC_DT_TM DATETIME Y The first Parenteral Anticoagulant after Warfarin was given during the IP encounter normalized to GMT
PACOAG_PRE_WARF_ED_DT_TM DATETIME Y The most recent Parenteral Anticoagulant before Warfarin was given during the ED encounter
PACOAG_PRE_WARF_ED_UTC_DT_TM DATETIME Y The most recent Parenteral Anticoagulant before Warfarin was given during the ED encounter normalized to GMT
PACOAG_PRE_WARF_IP_DT_TM DATETIME Y The most recent Parenteral Anticoagulant before Warfarin was given during the IP encounter
PACOAG_PRE_WARF_IP_UTC_DT_TM DATETIME Y The most recent Parenteral Anticoagulant before Warfarin was given during the IP encounter normalized to GMT
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility
PAT_REF_COMMUNICATION_IND DOUBLE Y If the patient refused discharge communication
PAYER_CODE_TXT VARCHAR(255) Y Identifies the payer code for the encounter
PERSON_ETHNIC_CODE VARCHAR(50) Y Ethnicity code of the patient as per value set
PERSON_ETHNIC_CODE_DISPLAY VARCHAR(500) Y Ethnicity code system OID of the patient as per value set
PERSON_ETHNIC_CODE_SYSTEM VARCHAR(50) Y Ethnicity code display of the patient as per value set
PERSON_ETHNIC_CODE_SYSTEM_NAME VARCHAR(50) Y Ethnicity code system name of the patient as per value set
PERSON_GENDER_CODE VARCHAR(50) Y Gender code of the patient as per value set
PERSON_GENDER_CODE_DISPLAY VARCHAR(500) Y Gender code system OID of the patient as per value set
PERSON_GENDER_CODE_SYSTEM VARCHAR(50) Y Gender code display of the patient as per value set
PERSON_GENDER_CODE_SYSTEM_NAME VARCHAR(50) Y Gender code system name of the patient as per value set
PERSON_PAYER_CODE VARCHAR(50) Y Represents the patient's member or subscriber identifier with respect to the payer
PERSON_PAYER_CODE_DISPLAY VARCHAR(500) Y Represents the patient's member or subscriber identifier coding system OID with respect to the payer
PERSON_PAYER_CODE_SYSTEM VARCHAR(50) Y Represents the patient's member or subscriber identifier display with respect to the payer
PERSON_PAYER_CODE_SYSTEM_NAME VARCHAR(50) Y Represents the patient's member or subscriber identifier coding system name with respect to the payer
PERSON_RACE_CODE VARCHAR(50) Y Race code of the patient as per value set
PERSON_RACE_CODE_DISPLAY VARCHAR(500) Y Race code system OID of the patient as per value set
PERSON_RACE_CODE_SYSTEM VARCHAR(50) Y Race code display of the patient as per value set
PERSON_RACE_CODE_SYSTEM_NAME VARCHAR(50) Y Race code system name of the patient as per value set
PLATELET_COUNT_EVENT_IND DOUBLE Y If there was documentation of a Platelet count clinical event
POP1_IND DOUBLE Y If the patient is in the population for VTE-1 and VTE-2
POP2_IND DOUBLE Y If the patient is in the population for VTE-3, VTE-4, and VTE-5
POP3_IND DOUBLE Y If the patient is in the population for VTE-6
PRINCIPAL_PROCEDURE_DT_TM DATETIME Y The date/time of the principal procedure associated to the inpatient encounter
PRINCIPAL_PROCEDURE_FLAG DOUBLE Y **OBSOLETE COLUMN**Identifies if the principal procedure is part of a group of procedures important to VTE
PRINCIPAL_PROCEDURE_UTC_DT_TM DATETIME Y The date/time of the principal procedure associated to the inpatient encounter normalized to GMT
PRIN_DX_HEMORRHAGIC_STK_IND DOUBLE Y **OBSOLETE COLUMN**If the patient has a principal diagnosis of Hemorrhagic Stroke
PRIN_DX_HEMORRHAGIC_STK_NOMEN VARCHAR(50) Y The code of the principal hemorrhagic stroke diagnosis
PRIN_DX_ISCHEMIC_STK_IND DOUBLE Y **OBSOLETE COLUMN**If the patient has a principal diagnosis of Ischemic Stroke
PRIN_DX_ISCHEMIC_STK_NOMEN VARCHAR(50) Y The code of the principal ischemic stroke diagnosis
PRIN_DX_MENTAL_DISORDER_IND DOUBLE Y **OBSOLETE COLUMN**If the patient has a mental disorder diagnosis
PRIN_DX_MENTAL_DISORDER_NOMEN VARCHAR(50) Y The code of the principal mental disorder diagnosis
PRIN_DX_OBS_VTE_IND DOUBLE Y If the patient has a principal diagnosis of Obstetrics VTE
PRIN_DX_VTE_IND DOUBLE Y If the patient has a principal diagnosis of VTE
PRIN_PROC_GEN_NOMEN VARCHAR(50) Y The code of the principal general surgery procedure
PRIN_PROC_GYN_NOMEN VARCHAR(50) Y The code of the principal gynecological surgery procedure
PRIN_PROC_HFRAC_NOMEN VARCHAR(50) Y The code of the principal hip fracture surgery procedure
PRIN_PROC_HREP_NOMEN VARCHAR(50) Y The code of the principal hip replacement surgery procedure
PRIN_PROC_INCRAN_NOMEN VARCHAR(50) Y The code of the principal intracranial neurosurgery procedure
PRIN_PROC_KNEE_NOMEN VARCHAR(50) Y The code of the principal knee replacement surgery procedure
PRIN_PROC_URO_NOMEN VARCHAR(50) Y The code of the principal urological surgery procedure
SUBCU_LDUH_ANS_ADMIN_DT_TM DATETIME Y The first date/time of Subcutaneous LDUH after anesthesia
SUBCU_LDUH_ANS_ADMIN_UTC_DT_TM DATETIME Y The first date/time of Subcutaneous LDUH after anesthesia normalized to GMT
SUBCU_LDUH_ICU_ADMIN_DT_TM DATETIME Y The first administration of Subcutaneous LDUH after inpatient admission
SUBCU_LDUH_ICU_ADMIN_UTC_DT_TM DATETIME Y The first administration of Subcutaneous LDUH after inpatient admission normalized to GMT
SUBCU_LDUH_IP_ADMIN_DT_TM DATETIME Y The first administration of Subcutaneous LDUH after inpatient admission
SUBCU_LDUH_IP_ADMIN_UTC_DT_TM DATETIME Y The first administration of Subcutaneous LDUH after inpatient admission normalized to GMT
SUBCU_UFH_ADMIN_TEST_DT_TM DATETIME Y The most recent administration of Subcutaneous UFH prior to VTE Diagnostic Test
SUBCU_UFH_ADMIN_TEST_UTC_DT_TM DATETIME Y The most recent administration of Subcutaneous UFH prior to VTE Diagnostic Test normalized to GMT
THROMBOCYTOPENIA_DX_IND DOUBLE Y If there is a diagnosis for thrombocytopenia documented
THROMBOCYTOPENIA_PROB_IND DOUBLE Y If there is a problem for thrombocytopenia documented
THROM_ANS_ICU_ADMIN_DT_TM DATETIME Y The first administration of Direct Thrombin Inhibitor after anesthesia end before icu
THROM_ANS_ICU_ADMIN_UTC_DT_TM DATETIME Y The first administration of Direct Thrombin Inhibitor after anesthesia end before icu normalized to GMT
THROM_ANS_IP_ADMIN_DT_TM DATETIME Y The first administration of Direct Thrombin Inhibitor after anesthesia end before ip
THROM_ANS_IP_ADMIN_UTC_DT_TM DATETIME Y The first administration of Direct Thrombin Inhibitor after anesthesia end before ip normalized to GMT
TREATMENT_ADJUST_CD_DESC VARCHAR(60) Y The code of the treatment adjusted by protocol
TREATMENT_ADJUST_EVENT_IND DOUBLE Y If there was documentation of a Treatment Adjustment clinical event
TREATMENT_ADJUST_ORDER_IND DOUBLE Y If there was documentation of a Treatment Adjustment order
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.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated.
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.
VFP_APPLIED_ANS_DT_TM DATETIME Y The first date/time of VFP after anesthesia
VFP_APPLIED_ANS_UTC_DT_TM DATETIME Y The first date/time of VFP after anesthesia normalized to GMT
VFP_APPLIED_ICU_DT_TM DATETIME Y The first application of VFP after ICU Arrival
VFP_APPLIED_ICU_UTC_DT_TM DATETIME Y The first application of VFP after ICU Arrival normalized to GMT
VFP_APPLIED_IP_DT_TM DATETIME Y The first application of VFP after inpatient admission
VFP_APPLIED_IP_UTC_DT_TM DATETIME Y The first application of VFP after inpatient admission normalized to GMT
VFP_APPLIED_TEST_DT_TM DATETIME Y The most recent application of VFP prior to VTE Diagnostic Test
VFP_APPLIED_TEST_UTC_DT_TM DATETIME Y The most recent application of VFP prior to VTE Diagnostic Test normalized to GMT
VFP_CONTRA_MASK DOUBLE Y Identifies which Medical contraindications for not ordering/administering VFP were documented
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
VTE_CONFIRMED_CE_ED_IND DOUBLE Y If there was documentation of a clinical event for VTE confirmed during the ED encounter
VTE_CONFIRMED_CE_IP_IND DOUBLE Y If there was documentation of a clinical event for VTE confirmed during the IP encounter
VTE_CONFIRMED_PROB_ED_IND DOUBLE Y If there was documentation of a problem for VTE confirmed during the ED encounter
VTE_CONFIRMED_PROB_IP_IND DOUBLE Y If there was documentation of a problem for VTE confirmed during the IP encounter
VTE_CONF_CE_PRIOR_DT_TM DATETIME Y The most recent documentation of a clinical event of VTE confirmed prior to IP admission
VTE_CONF_CE_PRIOR_UTC_DT_TM DATETIME Y The most recent documentation of a clinical event of VTE confirmed prior to IP admission normalized to GMT
VTE_CONF_FIRST_ED_DT_TM DATETIME Y The first documentation of VTE confirmed after ED Arrival
VTE_CONF_FIRST_ED_UTC_DT_TM DATETIME Y The first documentation of VTE confirmed after ED Arrival normalized to GMT
VTE_CONF_FIRST_IP_DT_TM DATETIME Y The first documentation of VTE confirmed after IP admission
VTE_CONF_FIRST_IP_UTC_DT_TM DATETIME Y The first documentation of VTE confirmed after IP admission normalized to GMT
VTE_CONF_PROB_PRIOR_DT_TM DATETIME Y The most recent documentation of a problem of VTE confirmed prior to IP admission
VTE_CONF_PROB_PRIOR_UTC_DT_TM DATETIME Y The most recent documentation of a problem of VTE confirmed prior to IP admission normalized to GMT
VTE_DIAG_TEST_1ST_ED_DT_TM DATETIME Y The first documentation of VTE Diagnostic test after ED Arrival
VTE_DIAG_TEST_1ST_ED_UTC_DT_TM DATETIME Y The first documentation of VTE Diagnostic test after ED Arrival normalized to GMT
VTE_DIAG_TEST_1ST_IP_DT_TM DATETIME Y The first documentation of VTE Diagnostic test after IP admission
VTE_DIAG_TEST_1ST_IP_UTC_DT_TM DATETIME Y The first documentation of VTE Diagnostic test after IP admission normalized to GMT
VTE_DIAG_TEST_ED_DT_TM DATETIME Y The first documentation of a VTE diagnostic test after ED Arrival
VTE_DIAG_TEST_ED_UTC_DT_TM DATETIME Y The first documentation of a VTE diagnostic test after ED Arrival normalized to GMT
VTE_DIAG_TEST_IP_DT_TM DATETIME Y The first documentation of a VTE diagnostic test after IP admission
VTE_DIAG_TEST_IP_UTC_DT_TM DATETIME Y The first documentation of a VTE diagnostic test after IP admission normalized to GMT
VTE_DIAG_TEST_ORDER_DT_TM DATETIME Y The order date/time for the VTE Diagnostic Test
VTE_DIAG_TEST_ORDER_UTC_DT_TM DATETIME Y The order date/time for the VTE Diagnostic Test normalized to GMT
VTE_DIAG_TEST_PRIOR_DT_TM DATETIME Y The most recent documentation of a VTE Diagnostic test prior to IP admission
VTE_DIAG_TEST_PRIOR_UTC_DT_TM DATETIME Y The most recent documentation of a VTE Diagnostic test prior to IP admission normalized to GMT
VTE_DX_ED_IND DOUBLE Y **OBSOLETE COLUMN**If the patient has a VTE diagnosis associated to the ED encounter
VTE_DX_ED_NOMEN VARCHAR(50) Y The code of the VTE diagnosis on ed encounter
VTE_DX_INACTIVE_PRIOR_IND DOUBLE Y If there was a VTE diagnosis prior to this encounter documented that is inactive
VTE_DX_IND DOUBLE Y **OBSOLETE COLUMN**If the patient has a VTE diagnosis
VTE_DX_INPT_IND DOUBLE Y If the patient has a VTE diagnosis associated to the inpatient encounter
VTE_DX_IP_NOMEN VARCHAR(50) Y The code of the VTE diagnosis on inpatient encounter
VTE_DX_PRIOR_IND DOUBLE Y If there was a VTE diagnosis prior to this encounter documented
VTE_LOW_RISK_ANS_IND DOUBLE Y If there was an VTE Low Risk documented within 1 day of anesthesia end date/time
VTE_LOW_RISK_ED_IND DOUBLE Y If there was an VTE Low Risk documented on ED visit encounter
VTE_LOW_RISK_ICU_IND DOUBLE Y If there was an VTE Low Risk documented within 1 day of ICU Arrival
VTE_LOW_RISK_IP_IND DOUBLE Y If there was an VTE Low Risk documented within 1 day of inpatient admission
VTE_PROB_ED_IND DOUBLE Y If there was a VTE Suspect problem active during the IP encounter
VTE_PROB_INACTIVE_PRIOR_IND DOUBLE Y If there was a VTE problem prior to this encounter documented that is inactive
VTE_PROB_IP_IND DOUBLE Y If there was a VTE Problem active during the IP encounter
VTE_PROB_PRIOR_IND DOUBLE Y If there was a VTE problem prior to this encounter documented
VTE_RISK_ANS_IND DOUBLE Y If there was an VTE Risk documented within 1 day of anesthesia end date/time
VTE_RISK_ED_IND DOUBLE Y If there was an VTE Risk documented on ED visit encounter
VTE_RISK_ICU_IND DOUBLE Y If there was an VTE Risk documented within 1 day of ICU Arrival
VTE_RISK_IP_IND DOUBLE Y If there was an VTE Risk documented within 1 day of inpatient admission
VTE_SUSPECT_DX_ED_IND DOUBLE Y If there was a Obstetrics VTE Problem active during the IP encounter
VTE_SUSPECT_DX_IP_DT_TM DATETIME Y The date of a VTE Suspect diagnosis on IP encounter
VTE_SUSPECT_DX_IP_UTC_DT_TM DATETIME Y The date of a VTE Suspect diagnosis on IP encounter normalized to GMT
VTE_SUSPECT_PROB_ED_IND DOUBLE Y If there was a VTE Problem active during the IP encounter
VTE_SUSPECT_PROB_IP_DT_TM DATETIME Y The date of a VTE Suspect problem on IP encounter
VTE_SUSPECT_PROB_IP_UTC_DT_TM DATETIME Y The date of a VTE Suspect problem on IP encounter normalized to GMT
WARFARIN_ADMIN_ED_DT_TM DATETIME Y The first administration of Warfarin after ED Arrival
WARFARIN_ADMIN_ED_UTC_DT_TM DATETIME Y The first administration of Warfarin after ED Arrival normalized to GMT
WARFARIN_ADMIN_IP_DT_TM DATETIME Y The first administration of Warfarin after IP admission
WARFARIN_ADMIN_IP_UTC_DT_TM DATETIME Y The first administration of Warfarin after IP admission normalized to GMT
WARFARIN_ADMIN_TEST_DT_TM DATETIME Y The most recent administration of Warfarin prior to VTE Diagnostic Test
WARFARIN_ADMIN_TEST_UTC_DT_TM DATETIME Y The most recent administration of Warfarin prior to VTE Diagnostic Test normalized to GMT
WARFARIN_DISCH_IND DOUBLE Y If there was a prescription for Warfarin
WARF_ANS_ADMIN_DT_TM DATETIME Y The first date/time of Warfarin after anesthesia
WARF_ANS_ADMIN_UTC_DT_TM DATETIME Y The first date/time of Warfarin after anesthesia normalized to GMT
WARF_CONTRA_MASK DOUBLE Y Represents the contraindication timeframes for Warfarin that are documented
WARF_ICU_ADMIN_DT_TM DATETIME Y The first administration of Warfarin after ICU Arrival
WARF_ICU_ADMIN_UTC_DT_TM DATETIME Y The first administration of Warfarin after ICU Arrival normalized to GMT
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



Relationship Detail - LH_E_VTE_2016_METRICS


Child Column in LH_E_VTE_2016_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
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


LH_E_VTE_2017_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_E_VTE_2017_METRICS
Definition: Holds data for EH VTE data for 2017 Submission
Table Type: ACTIVITY





Column Detail - LH_E_VTE_2017_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.
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.
ANES_ICU_END_DT_TM DATETIME Y The first documentation of anestheisa end after ICU arrival
ANES_ICU_END_UTC_DT_TM DATETIME Y The first documentation of anestheisa end after ICU arrival normalized to GMT
ANES_IP_END_DT_TM DATETIME Y The end date/time of anesthesia after inpatient admission
ANES_IP_END_UTC_DT_TM DATETIME Y The end date/time of anesthesia after inpatient admission normalized to GMT
ATRIAL_FIB_NOMEN VARCHAR(60) Y The code of the Atrial Fibrillation active diagnosis
CM_ORD_ANS_ICU_DT_TM DATETIME Y The date/time comfort measures was ordered after anesthesia
CM_ORD_ANS_ICU_UTC_DT_TM DATETIME Y The UTC date/time comfort measures was ordered after anesthesia
CM_ORD_ANS_IP_DT_TM DATETIME Y The date/time comfort measures was ordered after anesthesia
CM_ORD_ANS_IP_UTC_DT_TM DATETIME Y The UTC date/time comfort measures was ordered after anesthesia
CM_ORD_ED_DT_TM DATETIME Y The date/time comfort measures was ordered during ED
CM_ORD_ED_UTC_DT_TM DATETIME Y The UTC date/time comfort measures was ordered during ED
CM_ORD_ICU_DT_TM DATETIME Y The date/time comfort measures was ordered during ICU
CM_ORD_ICU_UTC_DT_TM DATETIME Y The UTC date/time comfort measures was ordered during ICU
CM_ORD_IP_DT_TM DATETIME Y The date/time comfort measures was ordered during inpatient
CM_ORD_IP_UTC_DT_TM DATETIME Y The UTC date/time comfort measures was ordered during inpatient
CM_PERF_ANS_ICU_DT_TM DATETIME Y The date/time comfort measures was performed after anesthesia
CM_PERF_ANS_ICU_UTC_DT_TM DATETIME Y The UTC date/time comfort measures was performed after anesthesia
CM_PERF_ANS_IP_DT_TM DATETIME Y The date/time comfort measures was performed after anesthesia
CM_PERF_ANS_IP_UTC_DT_TM DATETIME Y The UTC date/time comfort measures was performed after anesthesia
CM_PERF_ED_DT_TM DATETIME Y The date/time comfort measures was performed during ED
CM_PERF_ED_UTC_DT_TM DATETIME Y The UTC date/time comfort measures was performed during ED
CM_PERF_ICU_DT_TM DATETIME Y The date/time comfort measures was performed during ICU
CM_PERF_ICU_UTC_DT_TM DATETIME Y The UTC date/time comfort measures was performed during ICU
CM_PERF_IP_DT_TM DATETIME Y The date/time comfort measures was performed during inpatient
CM_PERF_IP_UTC_DT_TM DATETIME Y The UTC date/time comfort measures was performed during inpatient
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
DEN_2_IND DOUBLE Y If the patient is in denominator for VTE-2
DEN_EXCEPTION_2_IND DOUBLE Y If the patient has a denominator exception for VTE-2
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 during the visit.
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 Identifies the discharge disposition of the encounter
D_ENCNTR_TYPE_ID DOUBLE N Categorizes the encounter into a logical group or type. Foreign key to the CODE_VALUE table.
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_PERSON_ID DOUBLE N Identifies the person associated with the quality measure. Foreign key to the PERSON table.
ED_ARRIVAL_DT_TM DATETIME Y The Arrival date/time of the ED Encounter
ED_ARRIVAL_UTC_DT_TM DATETIME Y The Arrival date/time of the ED Encounter normalized to GMT
ED_DEPART_DT_TM DATETIME Y The Depart date/time of the ED Encounter
ED_DEPART_UTC_DT_TM DATETIME Y The Depart date/time of the ED Encounter normalized to GMT
ED_ENCNTR_ID DOUBLE N The encounter ID that's associated to an ED encounter
ED_TO_ICU_IND DOUBLE Y Indicates that the ED visit end is within 1hr of the ICU transfer
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXCLUDE_1_IND DOUBLE Y If the patient is excluded for VTE-1
EXCLUDE_2_IND DOUBLE Y If the patient is excluded 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 The financial number alias associated to the encounter.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
GCS_APPLIED_ANS_ICU_DT_TM DATETIME Y The first date/time of GCS after anesthesia
GCS_APPLIED_ANS_ICU_UTC_DT_TM DATETIME Y The first date/time of GCS after anesthesia normalized to GMT
GCS_APPLIED_ANS_IP_DT_TM DATETIME Y The first date/time of GCS after anesthesia
GCS_APPLIED_ANS_IP_UTC_DT_TM DATETIME Y The first date/time of GCS after anesthesia normalized to GMT
GCS_APPLIED_ICU_DT_TM DATETIME Y The first application of GCS after ICU Arrival
GCS_APPLIED_ICU_UTC_DT_TM DATETIME Y The first application of GCS after ICU Arrival normalized to GMT
GCS_APPLIED_IP_DT_TM DATETIME Y The first application of GCS after inpatient admission
GCS_APPLIED_IP_UTC_DT_TM DATETIME Y The first application of GCS after inpatient admission normalized to GMT
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_ANS_ICU_DT_TM DATETIME Y The first administration of Direct Thrombin Inhibitor after anesthesia end before icu
GLYCOPROTEIN_ANS_ICU_UTC_DT_TM DATETIME Y The first administration of Glycoprotein Inhibitor after anesthesia end before icu normalized to GMT
GLYCOPROTEIN_ANS_IP_DT_TM DATETIME Y The first administration of Direct Thrombin Inhibitor after anesthesia end before ip
GLYCOPROTEIN_ANS_IP_UTC_DT_TM DATETIME Y The first administration of Direct Thrombin Inhibitor after anesthesia end before ip normalized to GMT
GLYCOPROTEIN_ED_DT_TM DATETIME Y The first administration of Glycoprotein during ED
GLYCOPROTEIN_ED_UTC_DT_TM DATETIME Y The first administration of Glycoprotein during ED normalized to GMT
GLYCOPROTEIN_ICU_DT_TM DATETIME Y The first administration of Glycoprotein Inhibitor after ICU Arrival
GLYCOPROTEIN_ICU_UTC_DT_TM DATETIME Y The first administration of Glycoprotein Inhibitor after ICU Arrival normalized to GMT
GLYCOPROTEIN_IP_DT_TM DATETIME Y The first administration of Glycoprotein Inhibitor after inpatient admission
GLYCOPROTEIN_IP_UTC_DT_TM DATETIME Y The first administration of Glycoprotein Inhibitor after inpatient admission normalized to GMT
HEALTH_INS_NBR_TXT VARCHAR(50) Y The Medicare HIC number is the identification number given to a patient who is covered by Medicare
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_NOMEN VARCHAR(60) Y The code of hip replacement surgery
HOSP_SVC_IND DOUBLE N Indicates if the encounter should be excluded from the population due to the visit type
ICU_ADMIT_DT_TM DATETIME Y The first date/time that the patient arrived in the ICU
ICU_ADMIT_UTC_DT_TM DATETIME Y The first date/time that the patient arrived in the ICU normalized to GMT
ICU_DEPART_DT_TM DATETIME Y The date/time when the patient left the ICU
ICU_DEPART_UTC_DT_TM DATETIME Y The date/time when the patient left the ICU normalized to GMT
IFXA_ANS_ICU_ADMIN_DT_TM DATETIME Y The first date/time of Injectable Factor xA after anesthesia
IFXA_ANS_ICU_ADMIN_UTC_DT_TM DATETIME Y The first date/time of Injectable Factor xA after anesthesia normalized to GMT
IFXA_ANS_IP_ADMIN_DT_TM DATETIME Y The first date/time of Injectable Factor xA after anesthesia
IFXA_ANS_IP_ADMIN_UTC_DT_TM DATETIME Y The first date/time of Injectable Factor xA after anesthesia normalized to GMT
IFXA_ICU_ADMIN_DT_TM DATETIME Y The first administration of Injectable Factor xA after ICU Arrival
IFXA_ICU_ADMIN_UTC_DT_TM DATETIME Y The first administration of Injectable Factor xA after ICU Arrival normalized to GMT
IFXA_IP_ADMIN_DT_TM DATETIME Y The first administration of Injectable Factor xA after inpatient admission
IFXA_IP_ADMIN_UTC_DT_TM DATETIME Y The first administration of Injectable Factor xA after inpatient admission normalized to GMT
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
INR_OVER3_ANS_ICU_IND DOUBLE Y If there was an INR result > 3 after anesthesia after ICU transfer
INR_OVER3_ANS_IP_IND DOUBLE Y If there was an INR result > 3 after anesthesia during inpatient visit encounter
INR_OVER3_ED_IND DOUBLE Y If there was an INR result > 3 on ED visit encounter
INR_OVER3_ICU_IND DOUBLE Y If there was an INR result > 3 within 1 day of ICU Arrival
INR_OVER3_IP_IND DOUBLE Y If there was an INR result > 3 within 1 day of inpatient admisison
IPC_APPLIED_ANS_ICU_DT_TM DATETIME Y The first date/time of IPC after anesthesia
IPC_APPLIED_ANS_ICU_UTC_DT_TM DATETIME Y The first date/time of IPC after anesthesia normalized to GMT
IPC_APPLIED_ANS_IP_DT_TM DATETIME Y The first date/time of IPC after anesthesia
IPC_APPLIED_ANS_IP_UTC_DT_TM DATETIME Y The first date/time of IPC after anesthesia normalized to GMT
IPC_APPLIED_ICU_DT_TM DATETIME Y The first application of IPC after ICU Arrival
IPC_APPLIED_ICU_UTC_DT_TM DATETIME Y The first application of IPC after ICU Arrival normalized to GMT
IPC_APPLIED_IP_DT_TM DATETIME Y The first application of IPC after inpatient admission
IPC_APPLIED_IP_UTC_DT_TM DATETIME Y The first application of IPC after inpatient admission normalized to GMT
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 If the patient is in the initial patient population for VTE-1 and VTE-2
IV_UFH_ANS_ICU_ADMIN_DT_TM DATETIME Y The first date/time of IV Unfractionated Heparin after anesthesia before icu
IV_UFH_ANS_ICU_ADMIN_UTC_DT_TM DATETIME Y The first date/time of IV Unfractionated Heparin after anesthesia before icu normalized to GMT
IV_UFH_ANS_IP_ADMIN_DT_TM DATETIME Y The first date/time of IV Unfractionated Heparin after anesthesia before ip
IV_UFH_ANS_IP_ADMIN_UTC_DT_TM DATETIME Y The first date/time of IV Unfractionated Heparin after anesthesia before ip normalized to GMT
IV_UFH_ED_ADMIN_DT_TM DATETIME Y The first administration of IV Unfractionated Heparin after ED admission
IV_UFH_ED_ADMIN_UTC_DT_TM DATETIME Y The first administration of IV Unfractionated Heparin after ED admission normalized to GMT
IV_UFH_ICU_ADMIN_DT_TM DATETIME Y The first administration of IV Unfractionated Heparin after ICU Arrival
IV_UFH_ICU_ADMIN_UTC_DT_TM DATETIME Y The first administration of IV Unfractionated Heparin after ICU Arrival normalized to GMT
IV_UFH_IP_ADMIN_DT_TM DATETIME Y The first administration of IV Unfractionated Heparin after inpatient admission
IV_UFH_IP_ADMIN_UTC_DT_TM DATETIME Y The first administration of IV Unfractionated Heparin after inpatient admission normalized to GMT
KNEE_REPLACE_NOMEN VARCHAR(60) 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_ANS_ICU_ADMIN_DT_TM DATETIME Y The first date/time of Subcutaneous LDUH after anesthesia
LDUH_ANS_ICU_ADMIN_UTC_DT_TM DATETIME Y The first date/time of Subcutaneous LDUH after anesthesia normalized to GMT
LDUH_ANS_IP_ADMIN_DT_TM DATETIME Y The first date/time of Subcutaneous LDUH after anesthesia
LDUH_ANS_IP_ADMIN_UTC_DT_TM DATETIME Y The first date/time of Subcutaneous LDUH after anesthesia normalized to GMT
LDUH_ICU_ADMIN_DT_TM DATETIME Y The first administration of Subcutaneous LDUH after inpatient admission
LDUH_ICU_ADMIN_UTC_DT_TM DATETIME Y The first administration of Subcutaneous LDUH after inpatient admission normalized to GMT
LDUH_IP_ADMIN_DT_TM DATETIME Y The first administration of Subcutaneous LDUH after inpatient admission
LDUH_IP_ADMIN_UTC_DT_TM DATETIME Y The first administration of Subcutaneous LDUH after inpatient admission normalized to GMT
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
LH_E_VTE_2017_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_VTE_2017_METRICS table.
LMWH_ANS_ICU_ADMIN_DT_TM DATETIME Y The first date/time of LMWH after anesthesia
LMWH_ANS_ICU_ADMIN_UTC_DT_TM DATETIME Y The first date/time of LMWH after anesthesia normalized to GMT
LMWH_ANS_IP_ADMIN_DT_TM DATETIME Y The first date/time of LMWH after anesthesia
LMWH_ANS_IP_ADMIN_UTC_DT_TM DATETIME Y The first date/time of LMWH after anesthesia normalized to GMT
LMWH_ICU_ADMIN_DT_TM DATETIME Y The first administration of LMWH after ICU Arrival
LMWH_ICU_ADMIN_UTC_DT_TM DATETIME Y The first administration of LMWH after ICU Arrival normalized to GMT
LMWH_IP_ADMIN_DT_TM DATETIME Y The first administration of LMWH after inpatient admission
LMWH_IP_ADMIN_UTC_DT_TM DATETIME Y The first administration of LMWH after inpatient admission normalized to GMT
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
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.
NUMERATOR_1_IND DOUBLE Y If the patient is in the numerator for VTE-1
NUMERATOR_2_IND DOUBLE Y If the patient is in the numerator for VTE-2
OBS_DX_ED_NOMEN VARCHAR(60) Y The nomenclature of the obstetrics diagnosis on ed encounter
OBS_DX_IP_NOMEN VARCHAR(60) Y The nomenclature of the obstetrics diagnosis on inpatient encounter
OBS_VTE_DX_ED_NOMEN VARCHAR(60) Y The nomenclature of the obstetrics VTE diagnosis on ed encounter
OBS_VTE_DX_IP_NOMEN VARCHAR(60) Y The nomenclature of the obstetrics VTE diagnosis on inpatient encounter
OFXA_ADMIN_ANS_ICU_DT_TM DATETIME Y The first administration of Oral Factor xA after anesthesia end
OFXA_ADMIN_ANS_ICU_UTC_DT_TM DATETIME Y The first administration of Oral Factor xA after anesthesia end normalized to GMT
OFXA_ADMIN_ANS_IP_DT_TM DATETIME Y The first administration of Oral Factor xA after anesthesia end
OFXA_ADMIN_ANS_IP_UTC_DT_TM DATETIME Y The first administration of Oral Factor xA after anesthesia end normalized to GMT
OFXA_ADMIN_ICU_DT_TM DATETIME Y The first administration of Oral Factor xA after ICU Arrival
OFXA_ADMIN_ICU_UTC_DT_TM DATETIME Y The first administration of Oral Factor xA after ICU Arrival normalized to GMT
OFXA_ADMIN_IP_DT_TM DATETIME Y The first administration of Oral Factor xA after inpatient admission
OFXA_ADMIN_IP_UTC_DT_TM DATETIME Y The first administration of Oral Factor xA after inpatient admission normalized to GMT
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility
PAYER_CODE_TXT VARCHAR(255) Y Identifies the payer code for the encounter
PERSON_ETHNIC_CODE VARCHAR(50) Y Ethnicity code of the patient as per value set
PERSON_ETHNIC_CODE_DISPLAY VARCHAR(500) Y Ethnicity code system OID of the patient as per value set
PERSON_ETHNIC_CODE_SYSTEM VARCHAR(50) Y Ethnicity code display of the patient as per value set
PERSON_ETHNIC_CODE_SYSTEM_NAME VARCHAR(50) Y Ethnicity code system name of the patient as per value set
PERSON_GENDER_CODE VARCHAR(50) Y Gender code of the patient as per value set
PERSON_GENDER_CODE_DISPLAY VARCHAR(500) Y Gender code system OID of the patient as per value set
PERSON_GENDER_CODE_SYSTEM VARCHAR(50) Y Gender code display of the patient as per value set
PERSON_GENDER_CODE_SYSTEM_NAME VARCHAR(50) Y Gender code system name of the patient as per value set
PERSON_PAYER_CODE VARCHAR(50) Y Represents the patient's member or subscriber identifier with respect to the payer
PERSON_PAYER_CODE_DISPLAY VARCHAR(500) Y Represents the patient's member or subscriber identifier coding system OID with respect to the payer
PERSON_PAYER_CODE_SYSTEM VARCHAR(50) Y Represents the patient's member or subscriber identifier display with respect to the payer
PERSON_PAYER_CODE_SYSTEM_NAME VARCHAR(50) Y Represents the patient's member or subscriber identifier coding system name with respect to the payer
PERSON_RACE_CODE VARCHAR(50) Y Race code of the patient as per value set
PERSON_RACE_CODE_DISPLAY VARCHAR(500) Y Race code system OID of the patient as per value set
PERSON_RACE_CODE_SYSTEM VARCHAR(50) Y Race code display of the patient as per value set
PERSON_RACE_CODE_SYSTEM_NAME VARCHAR(50) Y Race code system name of the patient as per value set
PERSON_RACE_DESC VARCHAR(500) Y The list of all of a patient's races
PRINCIPAL_PROCEDURE_ICU_FLAG DOUBLE Y Identifies if the principal procedure is part of a group of procedures important to VTE.0 - No qualifying principal procedure; 1 - General Surgery; 2 - Gynecological Surgery; 3 - Hip Fracture Surgery; 4 - Hip Replacement Surgery; 5 - Intracranial Neurosurgery; 6 - Knee Replacement Surgery; 7 - Urlogical Surgery
PRINCIPAL_PROCEDURE_ICU_NOMEN VARCHAR(60) Y The nomenclature of the principal procedure associated to the inpatient encounter
PRINCIPAL_PROCEDURE_IP_FLAG DOUBLE Y Identifies if the principal procedure is part of a group of procedures important to VTE
PRINCIPAL_PROCEDURE_IP_NOMEN VARCHAR(60) Y The nomenclature of the principal procedure associated to the inpatient encounter
PRIN_DX_HEMORRHAGIC_STK_NOMEN VARCHAR(60) Y The nomenclature of the principal diagnosis of Hemorrhagic Stroke
PRIN_DX_ISCHEMIC_STK_NOMEN VARCHAR(60) Y The nomenclature of the principal diagnosis of Ischemic Stroke
PRIN_DX_MENTAL_HEALTH_NOMEN VARCHAR(60) Y The nomenclature of the mental health diagnosis
THROM_ANS_ICU_ADMIN_DT_TM DATETIME Y The first administration of Direct Thrombin Inhibitor after anesthesia end before icu
THROM_ANS_ICU_ADMIN_UTC_DT_TM DATETIME Y The first administration of Direct Thrombin Inhibitor after anesthesia end before icu normalized to GMT
THROM_ANS_IP_ADMIN_DT_TM DATETIME Y The first administration of Direct Thrombin Inhibitor after anesthesia end before ip
THROM_ANS_IP_ADMIN_UTC_DT_TM DATETIME Y The first administration of Direct Thrombin Inhibitor after anesthesia end before ip normalized to GMT
THROM_ED_ADMIN_DT_TM DATETIME Y The first administration of Direct Thrombin Inhibitor during ED
THROM_ED_ADMIN_UTC_DT_TM DATETIME Y The first administration of Direct Thrombin Inhibitor during ED
THROM_ICU_ADMIN_DT_TM DATETIME Y The first administration of Direct Thrombin Inhibitor after ICU transfer
THROM_ICU_ADMIN_UTC_DT_TM DATETIME Y The first administration of Direct Thrombin Inhibitor after ICU transfer normalized to GMT
THROM_IP_ADMIN_DT_TM DATETIME Y The first administration of Direct Thrombin Inhibitor during inpatient
THROM_IP_ADMIN_UTC_DT_TM DATETIME Y The first administration of Direct Thrombin Inhibitor during inpatient normalized to GMT
TIMEZONE_IDENT DOUBLE Y Identifies the timezone index number associated with the quality measure.
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 reecord.
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_ANS_ICU_DT_TM DATETIME Y The first date/time of VFP after anesthesia
VFP_APPLIED_ANS_ICU_UTC_DT_TM DATETIME Y The first date/time of VFP after anesthesia normalized to GMT
VFP_APPLIED_ANS_IP_DT_TM DATETIME Y The first date/time of VFP after anesthesia
VFP_APPLIED_ANS_IP_UTC_DT_TM DATETIME Y The first date/time of VFP after anesthesia normalized to GMT
VFP_APPLIED_ICU_DT_TM DATETIME Y The first application of VFP after ICU Arrival
VFP_APPLIED_ICU_UTC_DT_TM DATETIME Y The first application of VFP after ICU Arrival normalized to GMT
VFP_APPLIED_IP_DT_TM DATETIME Y The first application of VFP after inpatient admission
VFP_APPLIED_IP_UTC_DT_TM DATETIME Y The first application of VFP after inpatient admission normalized to GMT
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
VTE_DX_ED_NOMEN VARCHAR(60) Y The nomenclature of the VTE diagnosis on ed encounter
VTE_DX_IP_NOMEN VARCHAR(60) Y The nomenclature of the VTE diagnosis on inpatient encounter
VTE_DX_PRIOR_NOMEN VARCHAR(60) Y The nomenclature of the VTE diagnosis prior or during inpatient
VTE_LOW_RISK_ANS_ICU_IND DOUBLE Y If there was an VTE Low Risk documented after anesthesia after ICU transfer visit
VTE_LOW_RISK_ANS_IP_IND DOUBLE Y If there was an VTE Low Risk documented after anesthesia during inpatient visit encounter
VTE_LOW_RISK_ED_IND DOUBLE Y If there was an VTE Low Risk documented on ED visit encounter
VTE_LOW_RISK_ICU_IND DOUBLE Y If there was an VTE Low Risk documented within 1 day of ICU Arrival
VTE_LOW_RISK_IP_IND DOUBLE Y If there was an VTE Low Risk documented within 1 day of inpatient admission
WARF_ANS_ICU_ADMIN_DT_TM DATETIME Y The first date/time of Warfarin after anesthesia
WARF_ANS_ICU_ADMIN_UTC_DT_TM DATETIME Y The first date/time of Warfarin after anesthesia normalized to GMT
WARF_ANS_IP_ADMIN_DT_TM DATETIME Y The first date/time of Warfarin after anesthesia
WARF_ANS_IP_ADMIN_UTC_DT_TM DATETIME Y The first date/time of Warfarin after anesthesia normalized to GMT
WARF_ICU_ADMIN_DT_TM DATETIME Y The first administration of Warfarin after ICU Arrival
WARF_ICU_ADMIN_UTC_DT_TM DATETIME Y The first administration of Warfarin after ICU Arrival normalized to GMT
WARF_IP_ADMIN_DT_TM DATETIME Y The first date/time of Warfarin after inpatient start
WARF_IP_ADMIN_UTC_DT_TM DATETIME Y The first date/time of Warfarin after inpatient start normalized to GMT
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



Relationship Detail - LH_E_VTE_2017_METRICS


Child Column in LH_E_VTE_2017_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
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_2018_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_E_VTE_2018_METRICS
Definition: Stores data gathered by the LH_E_VTE_2018 program.
Table Type: ACTIVITY





Column Detail - LH_E_VTE_2018_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_ICU_END_UTC_DT_TM DATETIME Y The end date/time of anesthesia after inpatient admission normalized to GMT
ANES_IP_END_DT_TM DATETIME Y The end date/time of anesthesia after inpatient admission
ANES_IP_END_UTC_DT_TM DATETIME Y The end date/time of anesthesia after inpatient admission normalized to GMT
ATRIAL_FIB_NOMEN VARCHAR(60) 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_VTE1_UTC_DT_TM DATETIME Y UTC 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_ORD_VTE2_UTC_DT_TM DATETIME Y The UTC 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_VTE1_UTC_DT_TM DATETIME Y The UTC 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.
CM_PERF_VTE2_UTC_DT_TM DATETIME Y The UTC date/time comfort measures was performed for VTE2 requirements.
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
DEN_2_IND DOUBLE Y If the patient is in denominator for VTE-2
DEN_EXCEPTION_2_IND DOUBLE Y If the patient has a denominator exception for VTE-2
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 during the visit.
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 Identifies the discharge disposition of the encounter
D_ENCNTR_TYPE_ID DOUBLE N Categorizes the encounter into a logical group or type. Foreign key to the CODE_VALUE table.
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_PERSON_ID DOUBLE N Identifies the person associated with the quality measure. Foreign key to the PERSON table.
ED_ARRIVAL_DT_TM DATETIME Y The Arrival date/time of the ED Encounter
ED_ARRIVAL_UTC_DT_TM DATETIME Y The Arrival date/time of the ED Encounter normalized to GMT
ED_DEPART_DT_TM DATETIME Y The Depart date/time of the ED Encounter
ED_DEPART_UTC_DT_TM DATETIME Y The Depart date/time of the ED Encounter normalized to GMT
ED_ENCNTR_ID DOUBLE N The encounter ID that's associated to an ED encounter
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXCLUDE_1_IND DOUBLE Y If the patient is excluded for VTE-1
EXCLUDE_2_IND DOUBLE Y If the patient is excluded 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 The financial number alias associated to the encounter.
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_VTE1_UTC_DT_TM DATETIME Y The first application of GCS after meeting VTE1 requirements normalized to GMT
GCS_APPLIED_VTE2_DT_TM DATETIME Y The first application of GCS meeting VTE2 requirements
GCS_APPLIED_VTE2_UTC_DT_TM DATETIME Y The first application of GCS meeting VTE2 requirements normalized to GMT
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_UTC_DT_TM DATETIME Y The first administration of Glycoprotein meeting VTE1 requirements normalized to GMT
GLYCOPROTEIN_VTE2_DT_TM DATETIME Y The first administration of Glycoprotein meeting VTE2 requirements
GLYCOPROTEIN_VTE2_UTC_DT_TM DATETIME Y The first administration of Glycoprotein meeting VTE2 requirements normalized to GMT
HEALTH_INS_NBR_TXT VARCHAR(50) Y The Medicare HIC number is the identification number given to a patient who is covered by Medicare
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_NOMEN VARCHAR(60) 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_UTC_DT_TM DATETIME Y The first administration of Injectable Factor xA after meeting VTE1 requirements normalized to GMT
IFXA_VTE2_ADMIN_DT_TM DATETIME Y The first administration of Injectable Factor xA meeting VTE2 requirements
IFXA_VTE2_ADMIN_UTC_DT_TM DATETIME Y The first administration of Injectable Factor xA meeting VTE2 requirements normalized to GMT
INR_OVER3_VTE1_IND DOUBLE Y If there was an INR result > 3 meeting VTE1 requirements
INR_OVER3_VTE2_IND DOUBLE Y If there was an INR result > 3 meeting VTE2 requirements
IPC_APPLIED_VTE1_DT_TM DATETIME Y The first application of IPC after meeting VTE1 requirements
IPC_APPLIED_VTE1_UTC_DT_TM DATETIME Y The first application of IPC after meeting VTE1 requirements normalized to GMT
IPC_APPLIED_VTE2_DT_TM DATETIME Y The first application of IPC meeting VTE2 requirements
IPC_APPLIED_VTE2_UTC_DT_TM DATETIME Y The first application of IPC meeting VTE2 requirements normalized to GMT
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 If the patient is in the initial patient population for VTE-1 and VTE-2
IP_ADMIT_DT_TM DATETIME Y The date/time on which the patient was admitted.
IP_ADMIT_UTC_DT_TM DATETIME Y The date/time on which the patient was admitted; normalized to GMT.
IV_UFH_VTE1_ADMIN_DT_TM DATETIME Y The first administration of IV Unfractionated Heparin after meeting VTE1 requirements
IV_UFH_VTE1_ADMIN_UTC_DT_TM DATETIME Y The first administration of IV Unfractionated Heparin after meeting VTE1 requirements normalized to GMT
IV_UFH_VTE2_ADMIN_DT_TM DATETIME Y The first administration of IV Unfractionated Heparin meeting VTE2 requirements
IV_UFH_VTE2_ADMIN_UTC_DT_TM DATETIME Y The first administration of IV Unfractionated Heparin meeting VTE2 requirements normalized to GMT
KNEE_REPLACE_NOMEN VARCHAR(60) 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_UTC_DT_TM DATETIME Y The first administration of Subcutaneous LDUH meeting VTE1 requirements normalized to GMT
LDUH_VTE2_ADMIN_DT_TM DATETIME Y The first administration of Subcutaneous LDUH meeting VTE2 requirements
LDUH_VTE2_ADMIN_UTC_DT_TM DATETIME Y The first administration of Subcutaneous LDUH meeting VTE2 requirements normalized to GMT
LH_E_VTE_2018_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_VTE_2018_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_UTC_DT_TM DATETIME Y The first administration of LMWH after meeting VTE1 requirements normalized to GMT
LMWH_VTE2_ADMIN_DT_TM DATETIME Y The first administration of LMWH meeting VTE2 requirements
LMWH_VTE2_ADMIN_UTC_DT_TM DATETIME Y The first administration of LMWH meeting VTE2 requirements normalized to GMT
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.
NUMERATOR_1_IND DOUBLE Y If the patient is in the numerator for VTE-1
NUMERATOR_2_IND DOUBLE Y If the patient is in the numerator for VTE-2
OBS_DX_ED_NOMEN VARCHAR(60) Y The nomenclature of the obstetrics diagnosis on ed encounter
OBS_DX_IP_NOMEN VARCHAR(60) Y The nomenclature of the obstetrics diagnosis on inpatient encounter
OBS_VTE_DX_ED_NOMEN VARCHAR(60) Y The nomenclature of the obstetrics VTE diagnosis on ed encounter
OBS_VTE_DX_IP_NOMEN VARCHAR(60) Y The nomenclature of the obstetrics VTE diagnosis on inpatient encounter
OFXA_ADMIN_VTE1_DT_TM DATETIME Y The first administration of Oral Factor xA after meeting VTE1 requirements
OFXA_ADMIN_VTE1_UTC_DT_TM DATETIME Y The first administration of Oral Factor xA after meeting VTE1 requirements normalized to GMT
OFXA_ADMIN_VTE2_DT_TM DATETIME Y The first administration of Oral Factor xA meeting VTE2 requirements
OFXA_ADMIN_VTE2_UTC_DT_TM DATETIME Y The first administration of Oral Factor xA meeting VTE2 requirements normalized to GMT
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
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(500) Y Ethnicity code system OID of the patient as per value set
PERSON_GENDER_CODE_DISPLAY VARCHAR(500) Y Gender code system OID of the patient as per value set
PERSON_ID DOUBLE N The ID of the person associated to the record.
PERSON_PAYER_CODE_DISPLAY VARCHAR(500) Y Represents the patient's member or subscriber identifier coding system OID with respect to the payer
PERSON_RACE_DESC VARCHAR(50) Y The list of all of a patient's races
PRINCIPAL_PROCEDURE_ICU_FLAG DOUBLE Y Identifies if the principal procedure is part of a group of procedures important to VTE
PRINCIPAL_PROCEDURE_ICU_NOMEN VARCHAR(60) Y The nomenclature of the principal procedure associated to the inpatient encounter
PRINCIPAL_PROCEDURE_IP_FLAG DOUBLE Y Identifies if the principal procedure is part of a group of procedures important to VTE
PRINCIPAL_PROCEDURE_IP_NOMEN VARCHAR(60) Y The nomenclature of the principal procedure associated to the inpatient encounter
PRIN_DX_HEMORRHAGIC_STK_NOMEN VARCHAR(60) Y The nomenclature of the principal diagnosis of Hemorrhagic Stroke
PRIN_DX_ISCHEMIC_STK_NOMEN VARCHAR(60) Y The nomenclature of the principal diagnosis of Ischemic Stroke
PRIN_DX_MENTAL_HEALTH_NOMEN VARCHAR(60) Y The nomenclature of the mental health diagnosis
THROM_VTE1_ADMIN_DT_TM DATETIME Y The first administration of Direct Thrombin Inhibitor meeting VTE1 requirements
THROM_VTE1_ADMIN_UTC_DT_TM DATETIME Y The first administration of Direct Thrombin Inhibitor meeting VTE1 requirements normalized to GMT
THROM_VTE2_ADMIN_DT_TM DATETIME Y The first administration of Direct Thrombin Inhibitor meeting VTE2 requirements
THROM_VTE2_ADMIN_UTC_DT_TM DATETIME Y The first administration of Direct Thrombin Inhibitor meeting VTE2 requirements normalized to GMT
TIME_ZONE_TXT VARCHAR(100) Y The timezone of the record.
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_VTE1_UTC_DT_TM DATETIME Y The first application of VFP after meeting VTE1 requirements normalized to GMT
VFP_APPLIED_VTE2_DT_TM DATETIME Y The first application of VFP meeting VTE2 requirements
VFP_APPLIED_VTE2_UTC_DT_TM DATETIME Y The first application of VFP meeting VTE2 requirements normalized to GMT
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 first date/time that the patient arrived in the ICU and stayed for less than one day
VTE1_ICU_ADMIT_UTC_DT_TM DATETIME Y The first date/time that the patient arrived in the ICU and stayed for less than one day normalized to GMT
VTE1_ICU_DEPART_DT_TM DATETIME Y The date/time when the patient left the ICU normalized to GMT
VTE1_ICU_DEPART_UTC_DT_TM DATETIME Y The name of the task updating the record.
VTE1_LOW_RISK_IND DOUBLE Y If there was an VTE Low Risk documented meeting VTE1 requirements
VTE2_ICU_ADMIT_DT_TM DATETIME Y The first date/time that the patient arrived in the ICU
VTE2_ICU_ADMIT_UTC_DT_TM DATETIME Y The first date/time that the patient arrived in the ICU normalized to GMT
VTE2_ICU_DEPART_DT_TM DATETIME Y The date/time when the patient left the ICU
VTE2_ICU_DEPART_UTC_DT_TM DATETIME Y The date/time when the patient left the ICU normalized to GMT
VTE2_LOW_RISK_IND DOUBLE Y If there was an VTE Low Risk documented meeting VTE2 requirements
VTE_DX_ED_NOMEN VARCHAR(60) Y The nomenclature of the VTE diagnosis on ed encounter
VTE_DX_IP_NOMEN VARCHAR(60) Y The nomenclature of the VTE diagnosis on inpatient encounter
VTE_DX_PRIOR_NOMEN VARCHAR(60) Y The nomenclature of the VTE diagnosis prior or during 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_UTC_DT_TM DATETIME Y The first date/time of Warfarin after meeting VTE1 requirements normalized to GMT
WARF_VTE2_ADMIN_DT_TM DATETIME Y The first date/time of Warfarin meeting VTE2 requirements
WARF_VTE2_ADMIN_UTC_DT_TM DATETIME Y The first date/time of Warfarin meeting VTE2 requirements normalized to GMT



Relationship Detail - LH_E_VTE_2018_METRICS


Child Column in LH_E_VTE_2018_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_2019_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_E_VTE_2019_METRICS
Definition: Stores data gathered by the LH_E_VTE_2019 program.
Table Type: ACTIVITY





Column Detail - LH_E_VTE_2019_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 date/time on which the patient was discharged.
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 Identifies the discharge disposition of the encounter
D_ENCNTR_TYPE_ID DOUBLE N Categorizes the encounter into a logical group or type.
D_METRIC_1_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric: VTE-1
D_METRIC_2_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric: VTE-2
D_PERSON_ID DOUBLE N The person that qualified for the quality metric.
ED_ARRIVAL_DT_TM DATETIME Y The date/time of the emergency department arrival.
ED_DEPART_DT_TM DATETIME Y The date/time of the emergency department depart.
ED_ENCNTR_ID DOUBLE N Identifies the emergency encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
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 The financial number alias associated to the encounter.
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 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 unique source within the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
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 meeting VTE2 requirements
INR_OVER3_VTE1_IND DOUBLE Y If there was an INR result > 3 meeting VTE1 requirements ** Obsolete Column **
INR_OVER3_VTE2_IND DOUBLE Y If there was an INR result > 3 meeting VTE2 requirements ** Obsolete Column **
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 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 date/time on which the patient was admitted
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_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_2019_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_VTE_2019_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 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_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 Identifies the medical record number associated to the encounter.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility
PATIENT_IDENT VARCHAR(50) Y Identifies the medical record number of the patient.
PERSON_ETHNIC_CODE_DISPLAY VARCHAR(300) Y Gender code system OID of the patient as per value set
PERSON_GENDER_CODE_DISPLAY VARCHAR(300) Y Represents the patient's member or subscriber identifier coding system OID with respect to the payer
PERSON_ID DOUBLE N The ID of the person associated to the record.
PERSON_PAYER_CODE_DISPLAY VARCHAR(300) Y Ethnicity code system OID of the patient as per value set
PERSON_RACE_DESC VARCHAR(300) Y The list of all of a patient's races
PRINCIPAL_PROCEDURE_ICU_FLAG DOUBLE Y Identifies the valueset the principal procedure is tied to. 1 - GENERAL_SURGERY. 2 - GYNECOLOGICAL_SURGERY. 3 - HIP_FRACTURE_SURGERY. 4 - HIP_REPLACEMENT_SURGERY. 5 - INTRACRANIAL_NEUROSURGERY. 6 - KNEE_REPLACEMENT_SURGERY. 7 - UROLOGICAL_SURGERY.
PRINCIPAL_PROCEDURE_ICU_NOMEN VARCHAR(50) Y This column is obsolete
PRINCIPAL_PROCEDURE_IP_FLAG DOUBLE Y Identifies the valueset the principal procedure is tied to. 1 - GENERAL_SURGERY. 2 - GYNECOLOGICAL_SURGERY. 3 - HIP_FRACTURE_SURGERY. 4 - HIP_REPLACEMENT_SURGERY. 5 - INTRACRANIAL_NEUROSURGERY. 6 - KNEE_REPLACEMENT_SURGERY. 7 - UROLOGICAL_SURGERY.
PRINCIPAL_PROCEDURE_IP_NOMEN VARCHAR(50) Y This column is obsolete
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'
SRC_UPDT_DT_TM DATETIME Y Indicates the actual time when the row was inserted or updated at the source. This column is used only for date extraction and will not be populated on the client site.
SRC_UPDT_SOURCE VARCHAR(50) Y This column is updated with the name of the source program that loaded these rows into this table in Quality Clearinghouse when the Power Insight extracts were executed. This column is used only for date extraction and will not be populated on the client site.
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(100) Y The name of the timezone for the record. For example, 'America / Chicago'.
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 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 If there was an VTE Low Risk documented meeting VTE1 requirements
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 If there was an VTE Low Risk documented meeting VTE2 requirements
VTE_DX_NOMEN VARCHAR(50) Y The nomenclature of a qualifying VTE diagnosis.
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 meeting VTE2 requirements



Relationship Detail - LH_E_VTE_2019_METRICS


Child Column in LH_E_VTE_2019_METRICS(FK) Parent Table Name Parent Column Name
Parents: 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_DISCHARGE_BUILDING_ID LH_D_BUILDING D_BUILDING_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_DISCHARGE_FACILITY_ID LH_D_FACILITY D_FACILITY_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_DISCHARGE_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_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_2020_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse eMeasures VTE 2020 Metrics
Definition: Stores data gathered by the LH_E_VTE_2020 script.
Table Type: ACTIVITY





Column Detail - LH_E_VTE_2020_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_2020_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_VTE_2020_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'
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_2020_METRICS


Child Column in LH_E_VTE_2020_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