Improving the Measurement of Surgical Site Infection Risk Stratification/Outcome Detection

Exhibit 23. Data sources for the SSI common risk factors

Column Heading Denver Health SLC VA Vail Intermountain
Admit_src Utilization PTFMove Encounter.Admit_src_cd Demographics
Icu_admit Utilization PTFMove Encntr_loc_hist.nurse_unit_cd ADT data
Inpat_surg Utilization Local VASQIP Encounter.Encntr_type_cd Surgery data
Outpat_surg Utilization Local VASQIP Encounter.Encntr_type_cd Surgery data
Age Utilization demographics Person.birth_dt_tm (calculation) Demographics
BMI Pharmacy/ Lab vitals Clinical_event Height & weight
CA_hx Utilization/ Surgery Dx Codes Diagnosis ICD-9 codes
Chronic kidney dx Utilization Dx Codes Diagnosis ICD-9 codes
Chronic lung dx Utilization Dx Codes Diagnosis ICD-9 codes
COPD_hx Utilization/ Surgery Dx Codes Diagnosis ICD-9 codes
Diabetes Utilization Dx Codes Diagnosis ICD-9 codes
DVT Utilization/ Surgery Dx Codes Diagnosis Vascular studies
Hypocholest Utilization Dx Codes Diagnosis ICD-9 codes
MRSA Utilization Microbiology person_patient.disease_alert_cd Microbiology
Patid ADT PTF Person.Person_id Demographics
Payer Utilization Fee Basis Health_plan.health_plan_cd Demographics
Postop_hematocrit Lab laboratory Clinical_event Laboratory data
Postop_admit Utilization/ Surgery ADT   Laboratory data
Preop_hematocrit Lab laboratory Clinical_event Laboratory data
Preop_hemoglob Lab laboratory Clinical_event Laboratory data
Postop_hemoglob Lab laboratory Clinical_event Laboratory data
Preop_stay Utilization/surg ADT Encounter.arrive_dt_tm
Surgical_case.surg_start_dt_tm (calculation)
ADT & surgery
Proeop_albumin Lab laboratory Clinical_event Laboratory data
Rheum-dx Utilization Dx codes Diagnosis ICD-9 codes
Sex Utilization Demographics Person.sex_cd Demographics
SSI NHSN reports Local VASQIP Manual tracking Infection control
Abx_dc   Pharmacy Clinical_event Pharmacy data
ASA NHSN reports Local VASQIP Surgical_case.asa_class_cd Surgery data
Emergent NHSN reports/ Surgery Local VASQIP Surgical_case.sched_type_cd Surgery data
General_anes NHSN reports/ Surgery LocalVASQIP Surgical_case.anesth_type_cd Surgery data
No_procedures Utilization Local VASQIP Count instances of surg_case_procedure for a surgical_case Surgery data
Surg_date/time   Local VASQIP Surgical_case.surg_start_dt_tm Surgery data
Surg_dur Surgery Local VASQIP Surg_case_procedure.proc_dur_min Surgery data
Surg_proc Utilization Local VASQIP Hardcoded based on dx Surgery data
Surgeon_ex Medical Records Local VASQIP Not done Surgery data
Wnd_class Surgery Local VASQIP Surgical_case.wound_class_cd Surgery data

Return to Document

Page last reviewed December 2012
Internet Citation: Exhibit 23. Data sources for the SSI common risk factors. Content last reviewed December 2012. Agency for Healthcare Research and Quality, Rockville, MD. http://www.ahrq.gov/research/findings/final-reports/ssi/ssiexh23.html