ACTIVE_IND |
DOUBLE |
N |
The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ACT_ORDER_IND |
DOUBLE |
Y |
Indicator is set if ambulatory activity order is ordered. |
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. |
ADVISOR_RECOM_IND |
DOUBLE |
Y |
Identifies patient has advisor recommendation documented. |
AMB_ORDER_IND |
DOUBLE |
Y |
Identifies patients that have had an order for ambulation. |
APPROP_TREAT_ORD_IND |
DOUBLE |
Y |
Identifies patient has appropriate treatment order within time frame of advisor recommendation documented. |
ARRIVAL_DT_TM |
DATETIME |
Y |
The date/time on which the patient arrived at the facility. |
ARRIVAL_UTC_DT_TM |
DATETIME |
Y |
The date/time on which the patient arrived at the facility; normalized to GMT. |
ASSESS_24H_ADMIT_IND |
DOUBLE |
Y |
Identifies patients that have been assessed for VTE risk within 24 hours of admission. |
ASSESS_24H_CHG_PROC_IND |
DOUBLE |
Y |
Identifies patients that have been assessed within 24 hours of all completed procedure orders |
ASSESS_24H_CHG_STAT_IND |
DOUBLE |
Y |
Identifies patients that have been assessed within 24 hours of all transfers to a nurse unit with a higher/lower acuity level. |
ASSESS_24H_CHG_SURG_IND |
DOUBLE |
Y |
Identifies patients that have been assessed within 24 hours of all competed surgery procedures. |
ASSESS_24H_CHG_SVC_IND |
DOUBLE |
Y |
Identifies patients that have been assessed within 24 hours of all primary service changes. |
ASSESS_24H_CHG_TRAN_IND |
DOUBLE |
Y |
Identifies patients that have been assessed within 24 hours of all completed transfer orders. |
AT_RISK_EDUCATION_IND |
DOUBLE |
Y |
Identifies patients that have had VTE prevention education documented. |
CHANGE_PROC_ORD_IND |
DOUBLE |
Y |
Identifies patients that have completed Procedure Orders |
CHANGE_SERVICE_IND |
DOUBLE |
Y |
Identifies patients that have had a change in medical service during the visit. |
CHANGE_STATUS_IND |
DOUBLE |
Y |
Identifies patients that have moved to a nurse unit with a higher or lower acuity level than the previous nurse unit. |
CHANGE_SURG_PROC_IND |
DOUBLE |
Y |
Identifies patients that have completed surgery procedure. |
CHANGE_TRAN_ORD_IND |
DOUBLE |
Y |
Identifies patients that have completed transfer order |
COMM_MRN_TXT |
VARCHAR(50) |
Y |
Identifies the community medical record number of the patient. |
DISAG_RECOM_IND |
DOUBLE |
Y |
Identifies if there was a disagreement with the recommendations documented. |
DISCHARGED_LAST_30_DAYS_IND |
DOUBLE |
Y |
Identifies if the patient has been discharged previously within the last 30 days |
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_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_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_01_ID |
DOUBLE |
N |
Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_02_ID |
DOUBLE |
N |
Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_03_ID |
DOUBLE |
N |
Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_04_ID |
DOUBLE |
N |
Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_05_ID |
DOUBLE |
N |
Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_06_ID |
DOUBLE |
N |
Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_07_ID |
DOUBLE |
N |
Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_08_ID |
DOUBLE |
N |
Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_09_ID |
DOUBLE |
N |
Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_10_ID |
DOUBLE |
N |
Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_11_ID |
DOUBLE |
N |
Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_12_ID |
DOUBLE |
N |
Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_13_ID |
DOUBLE |
N |
Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_14_ID |
DOUBLE |
N |
Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_15_ID |
DOUBLE |
N |
Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_16_ID |
DOUBLE |
N |
Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_17_ID |
DOUBLE |
N |
Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_18_ID |
DOUBLE |
N |
Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_19_ID |
DOUBLE |
N |
Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_20_ID |
DOUBLE |
N |
Identifies a metric associated with falls. Foreign key to the lh_d_metric table. |
D_METRIC_21_ID |
DOUBLE |
N |
Identifier of a falls metric. Foreign key to the lh_d_metric table. |
D_METRIC_22_ID |
DOUBLE |
N |
Identifier of a falls metric. Foreign key to the lh_d_metric table. |
D_METRIC_23_ID |
DOUBLE |
N |
Identifier of a falls metric. Foreign key to the lh_d_metric table. |
D_PERSON_ID |
DOUBLE |
N |
Identifies the person associated with the quality measure. Foreign key to the PERSON table. |
D_VTE_ADV_PRSNL_ID |
DOUBLE |
N |
The identifier of the provider that completed the advisor. |
EDUCATION_IND |
DOUBLE |
Y |
Identifies patients that have had VTE education documented |
ENCNTR_ID |
DOUBLE |
N |
Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
ENOXAPARIN_ORDER_IND |
DOUBLE |
Y |
Identifies patients that had an order for Enoxaparin and a creatinine clearance result of less than 30 ml/min |
ENOXAPARIN_RENAL_IND |
DOUBLE |
Y |
Identifies patients with an Enoxaparin renal dose. |
EXCLUDE_SERVICE_IND |
DOUBLE |
Y |
Excludes services set in exclusion bedrock filter. |
EXTRACT_DT_TM |
DATETIME |
Y |
The date/time that the record was extracted from the source system. |
FINANCIAL_NBR_TXT |
VARCHAR(50) |
Y |
The financial number alias associated to the encounter. |
FIRST_PROCESS_DT_TM |
DATETIME |
Y |
The date/time the record was first loaded into the table. |
FIRST_RISK_ASS_LEVEL_DT_TM |
DATETIME |
Y |
The date/time on the first VTE risk assessment level. |
FIRST_RISK_ASS_LEVEL_FLAG |
DOUBLE |
Y |
Identifies patients' the first VTE risk assessment level, very lower, lower, moderate or high. |
FIRST_RISK_ASS_LEVEL_UTC_DT_TM |
DATETIME |
Y |
The date/time on the first VTE risk assessment level normalized to GMT. |
F_VTE_METRICS_ID |
DOUBLE |
N |
Unique identifier for the lighthouse VTE metrics. |
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. |
HEPARIN_ORDER_IND |
DOUBLE |
Y |
Identifies patients that have had heparin anticoagulation therapy |
HIT_DX_IND |
DOUBLE |
Y |
Identifies patients with hit diagnosis |
INR_WIN_24H_WARFARIN_IND |
DOUBLE |
Y |
Identifies patients that had an INR result within 24 hours before or after the administration of warfarin |
LAST_PROCESS_DT_TM |
DATETIME |
Y |
The date/time the record was last loaded into the table. |
LMWH_UFH_IND |
DOUBLE |
Y |
Identifies patient received LMWH or UFH |
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. |
LOW_MECH_ORDER_IND |
DOUBLE |
Y |
Identifies patients have a risk assessment of low and an order for compression stockings and/or a mechanical device during the period which the patient is considered low risk. |
LOW_PHARM_ORDER_IND |
DOUBLE |
Y |
Identifies patients have a risk assessment of low and an active order for pharmacological anticoagulants during the period which the patient is considered low risk. |
MECH_CONTRA_IND |
DOUBLE |
Y |
Identifies patient has Mech Contraindication |
MECH_PHARM_ORD_DT_TM |
DATETIME |
Y |
Order dt/tm of mechanical or pharmacological order.. |
MECH_PHARM_ORD_IND |
DOUBLE |
Y |
Identifies patient has a mech or pharm order. |
MOD_PHARM_ORDER_IND |
DOUBLE |
Y |
Identifies patients that have a risk assessment of moderate and an active order for pharmacological anticoagulants during the period which the patient is considered moderate risk. |
NOTIFY_PRV_ORD_COMP_IND |
DOUBLE |
Y |
Identifies patients against which an order to notify the physician was completed. |
NOTIFY_PRV_ORD_IND |
DOUBLE |
Y |
Identifies patients against which an order to notify the physician was placed. |
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_TYPE_FLAG |
DOUBLE |
Y |
Identifies the first patient type |
PHARM_CONTRA_IND |
DOUBLE |
Y |
Identifies patient has Pharm Contraindication |
PLAN_INITIATED_IND |
DOUBLE |
Y |
Identifies patients that have had the VTE prevention plan initiated. |
PLATELET_PRIOR_HEPARIN_IND |
DOUBLE |
Y |
Identifies patients that have had a baseline platelet count prior to heparin anticoagulation therapy. |
POPULATION_IND |
DOUBLE |
Y |
Identifies patients that have qualified for the VTE prevention population. |
PREV_INCDNT_DT_TM |
DATETIME |
Y |
Identifies the date/time of the last VTE incident. |
PREV_INCDNT_UTC_DT_TM |
DATETIME |
Y |
Identifies the date/time of the last VTE incident normalized to GMT. |
PREV_PROPH_ORD_IND |
DOUBLE |
Y |
Identifies patient that vte prophylaxis received visit with 30 days of current visit. |
PRIN_PROCEDURE_DT_TM |
DATETIME |
Y |
The date/time on which the principle procedure was performed. |
PRIN_PROCEDURE_UTC_DT_TM |
DATETIME |
Y |
The date/time on which the principle procedure was performed; normalized to GMT |
PROPHYLAXIS_REGIMEN_IND |
DOUBLE |
Y |
Identifies patients that are following the appropriate prophylaxis regimen for visits within 30 days of the current visit. |
RISK_ASSESS_IND |
DOUBLE |
Y |
Identifies patient that have been assessed for VTE risk. |
RISK_ASSESS_LOW_IND |
DOUBLE |
Y |
Identifies patients that have a VTE risk assessment equal to ""low"". |
RISK_ASSESS_MOD_IND |
DOUBLE |
Y |
Identifies patients that have a VTE risk assessment greater than or equal to ""moderate"". |
SUGGESTED_PLAN_IND |
DOUBLE |
Y |
Identifies patients that had the suggested VTE prevention PowerPlan |
TREAT_NONE_IND |
DOUBLE |
Y |
Identifies if there was documentation where the VTE Treatment chosen was "None". |
TREAT_PHARM_AND_MECH_IND |
DOUBLE |
Y |
Identifies patients with a pharmacological and mechanical treatment plan. |
TREAT_PHARM_IND |
DOUBLE |
Y |
Identifies patients with a pharmacological treatment plan. |
UPDT_CNT |
DOUBLE |
N |
Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM |
DATETIME |
N |
The date and time the row was last inserted or updated. |
UPDT_SOURCE |
VARCHAR(50) |
N |
The script name responsible for updating the record. |
UPDT_TASK |
VARCHAR(50) |
N |
The registered (assigned) task number for the process that inserted or updated the row. |
VTE_DEFER_24H_ADMIT_IND |
DOUBLE |
Y |
Identifies patients that have been assessed for VTE risk within 24 hours of admission. |
VTE_DEFER_IND |
DOUBLE |
Y |
Identifies patient has vte deferral document |
VTE_IND |
DOUBLE |
Y |
Identifies patients with a VTE (DVT or PE diagnosis/problems) |
VTE_POA_IND |
DOUBLE |
Y |
Identifies patients with a VTE present on admission (DVT or PE diagnosis/problems) |
VTE_PREV_ADM_IND |
DOUBLE |
Y |
Identifies if the patient had a VTE dx on the previous admission within 30 days |
VTE_PROB_DX_DT_TM |
DATETIME |
Y |
Date time when vte problem/ diagnosis is is diagnosed. |
VTE_PROPH_DAYS_IND |
DOUBLE |
Y |
Indicator is set if the number of vte prophylaxis days is less than 30. |
VTE_RISK_IND |
DOUBLE |
Y |
Identifies patients that are at risk for VTE. |
WARFARIN_ORDER_IND |
DOUBLE |
Y |
Identifies patients that have had an order for warfarin administered. |