Table 2.
Data variables and data sources
| Component | Variable | Data Source |
|---|---|---|
| Pre-Admission | ||
| Demographics | Sex, Race/Ethnicity | CDW Patient Tables |
| Age | CDW Vital Status Files | |
| Comorbidities | Functional Status, DNR Status | VASQIP |
| History of: Angina, Congestive Heart Failure, Cerebrovascular Accident, Peripheral Vascular Disease, Cardiac Surgery, Pre-operative Coma, Impaired Sensorium, Ascites, Esophageal Varices, Bleeding Disorders, Disseminated Cancer, Steroid Use, RBC Transfusion, Wound Infection, Weight Loss, Pneumonia, Ventilator Dependence, Dialysis, Acute Renal Failure | ||
| Social/Behavioral | BMI, >2 Drinks/Day in the 2 Weeks Before Admission, Pack-Years Smoking | VASQIP |
| Marital Status | CDW Patient Table | |
| Pre-Admission Inpatient and ER Utilization | CDW Inpatient and Outpatient Tables | |
| Preoperative Labs & Vitals | Albumin, Bicarbonate, Bilirubin, BUN, Calcium, Chloride, Serum Creatinine, Creatinine eGFR, Glucose, Hematocrit, Hemoglobin, INR, Potassium, Sodium, WBC | MCA Laboratory |
| Systolic & Diastolic Blood Pressure, Pain, Pulse, Pulse Oximetry, Respiration Rate, Temperature | CDW Vital Signs | |
| Hospital Factors | Index Hospitalization Facility | VASQIP |
| Operative | ||
| Complexity | Urgent/Emergent status, Inpatient/Outpatient status, Operative Time, Intraoperative RBC transfusion, Wound Classification, work RVU | VASQIP |
| Other | Year of Surgery, ASA classification, Anesthesia technique | VASQIP |
| Post-Operative | ||
| Postoperative Labs & Vitals | Albumin, Bicarbonate, Bilirubin, BUN, Calcium, Chloride, Serum Creatinine, Creatinine eGFR, Glucose, Hematocrit, Hemoglobin, INR, Potassium, Sodium, WBC | MCA Laboratory |
| Systolic & Diastolic Blood Pressure, Pain, Pulse, Pulse Oximetry, Respiration Rate, Temperature | CDW Vital Signs | |
| Pre-Discharge Complications | Cardiac Arrest, Myocardial Infarction, Coma, Cerebral Vascular Accident, Wound Disruption, Failure to Wean, Peripheral Nerve Injury, Acute Renal Failure, Organ/Space SSI, RBC Transfusion, DVT/Thrombophlebitis, Pneumonia, Pulmonary Embolism, Reintubation, Progressive Renal Insufficiency, Sepsis, Superficial Infection, Urinary Tract Infection, Deep Wound Infection | VASQIP |
| ICU Utilization | ICU visits during the index hospitalization | CDW Inpatient Tables |
| Other Postoperative | Postoperative Length of Stay, Number of Surgeries during Index Hospitalization | VASQIP |
| Discharge Destination | CDW Inpatient Tables | |
| Post-Discharge | ||
| Discharge Characteristics | Care Coordination, Caregiver Accessibility, | CTM-15 |
| Discharge Destination, Functional Status at Discharge, Transportation | Discharge, Readmission, and Follow-Up Interviews | |
| Discharge Complexity | Medications, Wound Care Instructions, Mobility | Discharge Interview |
| Patient Characteristics at Discharge | General Health | VR-12 |
| Cognitive Function | SBT | |
| Pain at Discharge | Visual Analogue Scale | |
| Post-Discharge Clinic Utilization | VA Clinic Stops in the 30-days post-discharge | CDW Outpatient Tables |
| Post-Discharge Complications | Cardiac Arrest, Myocardial Infarction, Coma, Cerebral Vascular Accident, Wound Disruption, Peripheral Nerve Injury, Acute Renal Failure, Organ/Space SSI, RBC Transfusion, DVT/Thrombophlebitis, Pneumonia, Pulmonary Embolism, Reintubation, Progressive Renal Insufficiency, Sepsis, Superficial Infection, Urinary Tract Infection, Deep Wound Infection | VASQIP |
| Medical Chart Abstraction | ||
| Other | Changes in: Care Coordination, Caregiver Accessibility, Transportation, Medications | Follow-up Interview |
| Pain at Follow-Up/Readmission | Visual Analogue Scale | |
| Outcome | ||
| Inpatient Readmission | Inpatient Admission within 30-days Following Index Hospitalization Discharge | CDW Inpatient Tables |
| Readmission Interview | ||
| Unplanned ER Admission | ER utilization within 30-days Following Index Hospitalization Discharge | CDW Outpatient Tables |
| Readmission Interview | ||
CDW VA’s Corporate Data Warehouse, VASQIP VA Surgical Quality Improvement Program, MCA Managerial Cost Accounting (a series of VA files), CTM Care Transitions Measures, SBT Short Blessed Test; BMI Body Mass Index, DNR Do Not Resuscitate; ER Emergency Room, BUN Blood Urea Nitrogen, eGFR Estimated Glomerular Filtration Rate, INR International Normalized Ratio, WBC White Blood Cell, RBC Red Blood Cell, RVU Relative Value Unit, ASA American Society of Anesthesiologists Physical Status Classification