Page 1 of 1

Exhibit 23. Data sources for the SSI common risk factors

Column HeadingDenver HealthSLC VAVail Intermountain
Admit_srcUtilizationPTFMoveEncounter.Admit_src_cdDemographics
Icu_admitUtilizationPTFMoveEncntr_loc_hist.nurse_unit_cdADT data
Inpat_surgUtilizationLocal VASQIPEncounter.Encntr_type_cdSurgery data
Outpat_surgUtilizationLocal VASQIPEncounter.Encntr_type_cdSurgery data
AgeUtilizationdemographicsPerson.birth_dt_tm (calculation)Demographics
BMIPharmacy/ LabvitalsClinical_eventHeight & weight
CA_hxUtilization/ SurgeryDx CodesDiagnosisICD-9 codes
Chronic kidney dxUtilizationDx CodesDiagnosisICD-9 codes
Chronic lung dxUtilizationDx CodesDiagnosisICD-9 codes
COPD_hxUtilization/ SurgeryDx CodesDiagnosisICD-9 codes
DiabetesUtilizationDx CodesDiagnosisICD-9 codes
DVTUtilization/ SurgeryDx CodesDiagnosisVascular studies
HypocholestUtilizationDx CodesDiagnosisICD-9 codes
MRSAUtilizationMicrobiologyperson_patient.disease_alert_cdMicrobiology
PatidADTPTFPerson.Person_idDemographics
PayerUtilizationFee BasisHealth_plan.health_plan_cdDemographics
Postop_hematocritLablaboratoryClinical_eventLaboratory data
Postop_admitUtilization/ SurgeryADT Laboratory data
Preop_hematocritLablaboratoryClinical_eventLaboratory data
Preop_hemoglobLablaboratoryClinical_eventLaboratory data
Postop_hemoglobLablaboratoryClinical_eventLaboratory data
Preop_stayUtilization/surgADTEncounter.arrive_dt_tm
Surgical_case.surg_start_dt_tm (calculation)
ADT & surgery
Proeop_albuminLablaboratoryClinical_eventLaboratory data
Rheum-dxUtilizationDx codesDiagnosisICD-9 codes
SexUtilizationDemographicsPerson.sex_cdDemographics
SSINHSN reportsLocal VASQIPManual trackingInfection control
Abx_dc PharmacyClinical_eventPharmacy data
ASANHSN reportsLocal VASQIPSurgical_case.asa_class_cdSurgery data
EmergentNHSN reports/ SurgeryLocal VASQIPSurgical_case.sched_type_cdSurgery data
General_anesNHSN reports/ SurgeryLocalVASQIPSurgical_case.anesth_type_cdSurgery data
No_proceduresUtilizationLocal VASQIPCount instances of surg_case_procedure for a surgical_caseSurgery data
Surg_date/time Local VASQIPSurgical_case.surg_start_dt_tmSurgery data
Surg_durSurgeryLocal VASQIPSurg_case_procedure.proc_dur_minSurgery data
Surg_procUtilizationLocal VASQIPHardcoded based on dxSurgery data
Surgeon_exMedical RecordsLocal VASQIPNot doneSurgery data
Wnd_classSurgeryLocal VASQIPSurgical_case.wound_class_cdSurgery data

Return to Document

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