ssiapc.htm Appendix C. Data DictionaryTableFieldDatatypeDescriptionPATIENT Include patients who had surgery that meet inclusion CPT,SNOMED, or ICD-9 criteria between 1/1/2007 and 1/30/2009PATIENTDOBDateThe birthdate for the patientPATIENTPATIENT_IDIntegerA unique ID for the patientPATIENTDATA_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 diagnosisDIAGNOSISDIAGNOSIS_CODEVarchar(64)The code for the patient's diagnosisDIAGNOSISDIAGNOSIS_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 exacerbationMICROBIOLOGY 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 procedureMICROBIOLOGYSPECIMEN_CODEVarchar(64)The site that the specimen was collected fromMICROBIOLOGYSPECIMEN_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 specimenMICROBIOLOGYPATHOGEN_CODE_SOURCEVarchar(64)The nomenclature that the pathogen code is taken from (SNOMED, LOINC, etc.)MICROBIOLOGYCOLLECT_DTMDateThe date and time the specimen was collectedENCOUNTER 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 visitENCOUNTERDISCH_DTMDateThe discharge date and time for a patient's visitENCOUNTERENCOUNTER_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/2009PROCEDUREPROCEDURE_IDIntegerA unique ID for the procedurePROCEDURECLINICAL_DTMDateThe date and time that the procedure was performedPROCEDUREPROC_CODEVarchar(64)The code (ICD9, CPT4, SNOMED etc.) or description for the procedure that was performedPROCEDUREPROC_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 performedPROCEDURESITE_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 surgeryANTIBIOTICABX_IDIntegerA unique ID for the antibioticANTIBIOTICNAMEVarchar(64)The name of the antibiotic givenANTIBIOTICDOSEVarchar(64)The dose of the antibioticANTIBIOTICFREQUENCYVarchar(64)The frequency of the antibioticANTIBIOTICSTART_DTMDateThe date of when the antibiotic treatment beganANTIBIOTICDC_DTMDateThe date of when the antibiotic treatment endedVITAL_SIGN Include the lowest systolic and diastolic blood pressures, and highest pulse and temperature 2 days before and after each cultureVITAL_SIGNVS_IDIntegerA unique ID for the vital signVITAL_SIGNTEMPERATUREDoublePatient's temperature for determination of present infectionVITAL_SIGNTEMP_SCALEVarchar(64)The scale that the temperature was taken in (Celsius, Fahrenheit)VITAL_SIGNTEMP_DTMDateThe date and time the temperature was takenLAB 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 labLABTEST_NAMEVarchar(64)The name or type of lab testLABRESULTVarchar(64)The results from the lab testLABCOLLECT_DTMDateThe date and time the specimen was collectedLABRESULT_DTMDateThe date and time the lab test was resultedLABSPECIMEN_CODEVarchar(64)The site that the specimen was collected fromLABSPECIMEN_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 patientOUTCOMESDATA_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 institutionOUTCOMESSURG_DATEDateDate and time of surgery startOUTCOMESSURG_CODEVarchar(10)Surgery Codes associated with SURG_IDOUTCOMESSURG_CODE_TYPEVarchar(10)ICD-9, CPT or otherOUTCOMESWOUND_CLASSVarchar(64)Clean, Clean/Contaminated, Contaminated, Dirty/InfectedOUTCOMESS_INCIS_SSIDateEnter date when superficial incisional SSI foundOUTCOMESD_INCIS_SSIDateEnter date when deep incisional SSI foundOUTCOMESORG_SSIDateEnter date when an organ space SSI foundOUTCOMESSYS_SEPSISDateEnter date when patient suffered systemic sepsisOUTCOMESSEPSISDateEnter date when patient suffered sepsisOUTCOMESSEPTIC_SHOCKDateEnter date when patient suffered septic shockRISKPATIENT_IDIntegerA unique ID for the patientRISKDATA_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 institutionRISKSURG_DATEDateDate and time of surgery startReturn to Contents Proceed to Next Section Current as of December 2012 Internet Citation: ssiapc.htm. December 2012. Agency for Healthcare Research and Quality, Rockville, MD. http://www.ahrq.gov/research/findings/final-reports/ssi/ssiapc.html
Back
