Appendix C. Data Dictionary

TableFieldDatatypeDescription
PATIENT  Include patients who had surgery that meet inclusion CPT,SNOMED, or ICD-9 criteria between 1/1/2007 and 1/30/2009
PATIENTDOBDateThe birthdate for the patient
PATIENTPATIENT_IDIntegerA unique ID for the patient
PATIENTDATA_SOURCE_IDVarchar(10)An identifier for the source of the patient record data (UU, IHC, DH for example)
DIAGNOSIS  Include ICD-9 CM discharge codes within one month of surgery. A list of included codes is in table 2 of Stevenson et al. AJIC vol 36(3) 155-164.
DIAGNOSISDIAGNOSIS_IDIntegerA unique ID for the diagnosis
DIAGNOSISDIAGNOSIS_CODEVarchar(64)The code for the patient's diagnosis
DIAGNOSISDIAGNOSIS_CODE_SOURCEVarchar(64)The nomenclature that the diagnosis code is taken from (ICD9, etc.)
DIAGNOSISCLINICAL_DTMDateThe date and time of the diagnosis's onset or exacerbation
MICROBIOLOGY  Include all Microbiology specimens taken within one month before or after a surgery. (For risk, this might be expanded to one-year or more.)
MICROBIOLOGYMICRO_IDIntegerA unique ID for the procedure
MICROBIOLOGYSPECIMEN_CODEVarchar(64)The site that the specimen was collected from
MICROBIOLOGYSPECIMEN_CODE_SOURCEVarchar(64)The nomenclature that the specimen code is taken from (SNOMED, LOINC, etc.)
MICROBIOLOGYPATHOGEN_CODEVarchar(64)The code of the pathogen cultured from the collected specimen
MICROBIOLOGYPATHOGEN_CODE_SOURCEVarchar(64)The nomenclature that the pathogen code is taken from (SNOMED, LOINC, etc.)
MICROBIOLOGYCOLLECT_DTMDateThe date and time the specimen was collected
ENCOUNTER  Include all Encounters within one month before or after surgery.
ENCOUNTERENCOUNTER_IDIntegerA unique ID for the visit.  This will server to tie all of the different data tables together via foreign key relationship.
ENCOUNTERADMIT_DTMDateThe admission date and time for a patient's visit
ENCOUNTERDISCH_DTMDateThe discharge date and time for a patient's visit
ENCOUNTERENCOUNTER_TYPEVarchar(64)The type of patient encounter such as inpatient, outpatient, observation, etc.
PROCEDURE  Include all procedures that meet inclusion CPT, SNOMED, or ICD-9 criteria between 1/1/2007 and 1/30/2009
PROCEDUREPROCEDURE_IDIntegerA unique ID for the procedure
PROCEDURECLINICAL_DTMDateThe date and time that the procedure was performed
PROCEDUREPROC_CODEVarchar(64)The code (ICD9, CPT4, SNOMED etc.) or description for the procedure that was performed
PROCEDUREPROC_CODE_SOURCEVarchar(64)The nomenclature that the procedure code is taken from (ICD9, CPT4, SNOMED etc.)
PROCEDURESITE_CODEVarchar(64)The code (ICD9, CPT4, SNOMED etc.) or description for the site where the procedure was performed
PROCEDURESITE_CODE_SOURCEVarchar(64)The nomenclature that the site code is taken from (ICD9, CPT4, SNOMED etc.)
ANTIBIOTIC  Include all antibiotics that were given one month before or after surgery
ANTIBIOTICABX_IDIntegerA unique ID for the antibiotic
ANTIBIOTICNAMEVarchar(64)The name of the antibiotic given
ANTIBIOTICDOSEVarchar(64)The dose of the antibiotic
ANTIBIOTICFREQUENCYVarchar(64)The frequency of the antibiotic
ANTIBIOTICSTART_DTMDateThe date of when the antibiotic treatment began
ANTIBIOTICDC_DTMDateThe date of when the antibiotic treatment ended
VITAL_SIGN  Include the lowest systolic and diastolic blood pressures, and highest pulse and temperature 2 days before and after each culture
VITAL_SIGNVS_IDIntegerA unique ID for the vital sign
VITAL_SIGNTEMPERATUREDoublePatient's temperature for determination of present infection
VITAL_SIGNTEMP_SCALEVarchar(64)The scale that the temperature was taken in (Celsius, Fahrenheit)
VITAL_SIGNTEMP_DTMDateThe date and time the temperature was taken
LAB  Include the most extreme laboratory values from tests of interest within 2 days before and after each culture. Potential tests of interest: blood leukocyte count, erythrocyte sedimentation rate, c-reactive protein, and procalcitonin.
LABLAB_IDIntegerA unique ID for the lab
LABTEST_NAMEVarchar(64)The name or type of lab test
LABRESULTVarchar(64)The results from the lab test
LABCOLLECT_DTMDateThe date and time the specimen was collected
LABRESULT_DTMDateThe date and time the lab test was resulted
LABSPECIMEN_CODEVarchar(64)The site that the specimen was collected from
LABSPECIMEN_CODE_SOURCEVarchar(64)The nomenclature that the specimen code is taken from (SNOMED, LOINC, etc.)
OUTCOMES - FROM NSQIP or OTHERInclude patients who had surgery that meet inclusion CPT,SNOMED, or ICD-9 criteria between 1/1/2007 and 1/30/2009 
OUTCOMESPATIENT_IDIntegerA unique ID for the patient
OUTCOMESDATA_SOURCE_IDVarchar(10)An identifier for the source of the patient record data (VA, IHC, DH, VA-NSQIP for example)
OUTCOMESSURG_IDVarchar(10)A unique identifier for all surgeries performed at an institution
OUTCOMESSURG_DATEDateDate and time of surgery start
OUTCOMESSURG_CODEVarchar(10)Surgery Codes associated with SURG_ID
OUTCOMESSURG_CODE_TYPEVarchar(10)ICD-9, CPT or other
OUTCOMESWOUND_CLASSVarchar(64)Clean, Clean/Contaminated, Contaminated, Dirty/Infected
OUTCOMESS_INCIS_SSIDateEnter date when superficial incisional SSI found
OUTCOMESD_INCIS_SSIDateEnter date when deep incisional SSI found
OUTCOMESORG_SSIDateEnter date when an organ space SSI found
OUTCOMESSYS_SEPSISDateEnter date when patient suffered systemic sepsis
OUTCOMESSEPSISDateEnter date when patient suffered sepsis
OUTCOMESSEPTIC_SHOCKDateEnter date when patient suffered septic shock
RISKPATIENT_IDIntegerA unique ID for the patient
RISKDATA_SOURCE_IDVarchar(10)An identifier for the source of the patient record data (VA, IHC, DH, VA-NSQIP for example)
RISKSURG_IDVarchar(10)A unique identifier for all surgeries performed at an institution
RISKSURG_DATEDateDate and time of surgery start
Current as of December 2012
Internet Citation: Appendix C. Data Dictionary. December 2012. Agency for Healthcare Research and Quality, Rockville, MD. http://www.ahrq.gov/research/findings/final-reports/ssi/ssiapc.html