Name | Short Description | Units/variable type | Long Description |
---|---|---|---|
Hosp ID | Hospital identifier | varchar | Unique identifier for the hospital |
Pt_ID | Patient identifier | varchar | Unique identifier for each patient |
SGY_ID | Surgery identifier | varchar | Unique identifier for each surgery |
sSSI | superficial surgical site infection | integer [0,1] | 0 if routine surveillance found no infection; 1 for + superficial SSI |
dSSI | deep surgical site infection | integer [0,1] | 0 if routine surveillance found no infection; 1 for + deep SSI |
oSSI | organ space surgical site infection | integer [0,1] | 0 if routine surveillance found no infection; 1 for + organ space SSI |
postopabx | postoperative antibiotics | integer [0,1] | 1 if any antibiotics given between postop day 3 and 30, but not day -1 to -7; else 0 |
postopcx | postoperative culture | integer [0,1] | 1 if any microbiology culture sent between postop day 3 and 30; else 0 |
postopadmit | postoperative readmission | integer [0,1] | 1 if any readmission between postop day 3 and 30; else 0 |
wbc | white blood cell count | float [K/mm3] | maximum recorded wbc between postop day 4 and 30 |
crp | C-reactive protein | float [mg/dL | maximum recorded crp between postop day 4 and 30 |
SGY_Type | Procedure Type | varchar | [CABG, THA, TKA, Herniorrhaphy] |
National Healthcare Quality and Disparities Report
Latest available findings on quality of and access to health care
Data & Analytics
- Data Infographics
- Data Visualizations
- Data Tools
- Data Innovations
- All-Payer Claims Database
- Consumer Assessment of Healthcare Providers and Systems (CAHPS®) Program
- Healthcare Cost and Utilization Project (HCUP)
- Medical Expenditure Panel Survey (MEPS)
- National Healthcare Quality and Disparities Report Data Tools
- AHRQ Quality Indicator Tools for Data Analytics
- United States Health Information Knowledgebase (USHIK)
- Data Sources Available from AHRQ
Improving the Measurement of Surgical Site Infection Risk Stratification/Outcome Detection
Exhibit 12. Data for Algorithm
Table of Contents
- Improving the Measurement of Surgical Site Infection Risk Stratification/Outcome Detection
- Executive Summary
- Chapter 1. Administration
- Chapter 2. Determining Surgical Site Infection Rates
- Chapter 3. Designing and Testing Methods to Stratify Risk of Surgical Site Infections
- Chapter 4. Assessing Surgeon Acceptance of Risk Adjustment Models
- Chapter 5. Project Expansion
- Chapter 6. Conclusions and Recommendations
- References
- Appendix A. Teleconferences with AHRQ & CDC
- Appendix B. In-Person Meetings
- Appendix C. Data Dictionary
- Appendix D. Mapping ICD9 and CPT Codes
- Appendix E. Culture Type Map to Procedure Types
- Appendix F. Algorithms
- Appendix G. Pairwise Correlation of Variables with SSI and with Each Other
- Appendix H. Calculating Sensitivity and Specificity for Validation
- Appendix I. Initial Risk Factors
- Appendix J. Additional Risk Factors
- Appendix K. Final Risk Factors
- Appendix L. Final data sheet submitted by each site that included the list of potential SSI risk factors and other pertinent variables
- Appendix M. Master Risk Factor List with Final Bolded
- Appendix N. Surgeon Focus Group Guide
- Appendix O. Nursing Focus Group Guides
- Appendix P. Focus Group Risk Factors
- Appendix Q. Surgeon Focus Group Content Analysis
- Appendix R. Infection Prevention Support Tool
- Appendix S. Surgeons' Acceptance of Surgical Site Infection Risk Adjustment Models
- Appendix T. Surgical Infection Society Abstract
- Appendix U. Improving the Measurement of Surgical Site Infection (SSI) Risk Stratification and Outcome Detection
- Appendix V. JAMIA Draft Manuscript
Publication: 12-0046-EF
Page last reviewed April 2018
Page originally created December 2012
Internet Citation: Exhibit 12. Data for Algorithm. Content last reviewed April 2018. Agency for Healthcare Research and Quality, Rockville, MD.
https://www.ahrq.gov/research/findings/final-reports/ssi/ssiexh12.html