ssiexh23.htm

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

Current as of December 2012

Internet Citation: ssiexh23.htm. December 2012. Agency for Healthcare Research and Quality, Rockville, MD. http://www.ahrq.gov/research/findings/final-reports/ssi/ssiexh23.html