NSQIP PUF User Guide 2015
User Manual:
Open the PDF directly: View PDF .
Page Count: 26
Download | |
Open PDF In Browser | View PDF |
“Quality Improvement through Quality Data” American College of Surgeons National Surgical Quality Improvement Program Revised Version October 2016 Data Update Initially, in October 2016, the 2015 PUF datasets were issued with certain inconsistencies that were subsequently identified and corrected in revised datasets. These inconsistencies involved the following data fields: 1. Height and Weight in the Adult PUF 2. C. diff (NOTHCDIFF, OTHCDIFF) in the Adult PUF Please make certain that in all research efforts you are using the most recent release of the PUF for any period. ACS NSQIP 2015 PUF USER GUIDE | OCTOBER 2016 Contents ______________________________________________________________________ Section Page 1. Introduction 1 2. Data Request Process 1 3. File Description 2 4. Data Variable Updates 3 5. Data Collection Background and Data Quality 4 6. Sampling Process and Case Exclusion Criteria 5 7. Data Limitations 6 8. Contact Information 8 9. Frequently Asked Questions 9 10. Data Variables and Definitions 13 ACS NSQIP 2015 PUF USER GUIDE | OCTOBER 2016 1. Introduction This document is designed to accompany the 2015 Participant Use Data File (PUF) available for download on the American College of Surgeons National Surgical Quality Improvement Program (ACS NSQIP) website ( www.facs.org/quality-programs/acs-nsqip ). The sections contained herein will provide the user with information on how to request the PUF, the contents of the data files, the data collection background, the inclusion and exclusion criteria for cases and hospitals, the data limitations, and the data point definitions and descriptions. This user guide applies specifically to the 2015 PUF. Hospitals utilizing the PUF from a different year should refer to the user guide specifically tailored to that particular data set. 2. Data Request Process An individual who has an official appointment at a fully enrolled site and wants to obtain a copy of the ACS NSQIP PUF can do so by visiting www.facs.org/quality-programs/acs-nsqip and following the steps listed below: 1. From the ACS NSQIP main page (www.facs.org/quality-programs/acs-nsqip) the requestor can scroll down to the “Quick Links” box on the left side. Within that box you can click on the “Participant Use Data File” link. This will take you to the PUF information and request page. 2. Following a brief introduction and explanation of the various PUFs, the requestor can click on “Request Data Set.” 3. This will take the requestor to the Data Use Agreement. This is a 3-page document that implements the data protections of the Health Insurance Portability and Accountability Act of 1996 (HIPAA) and the ACS NSQIP Hospital Participation Agreement. Delivery of the PUF is contingent on agreement to the terms and conditions specified within the Data Use Agreement. You can read the Data Use Agreement from this page or download the 3-page document. The requestor is then required to type in their first and last name and click on “Request Data File.” By clicking on “Request Data File” the requestor agrees to the terms and conditions of the Data Use Agreement. 4. Requestors will then be required to complete a brief online form to provide ACS with basic information about themselves, including the participating hospital in which they are currently employed and in what capacity, as well as how the requestor plans on using the PUF data. Once all of the required fields are completed, the requestor clicks “Submit.” 1 ACS NSQIP 2015 PUF USER GUIDE | OCTOBER 2016 5. ACS NSQIP staff will review the request in a timely manner. Program contacts at participating sites will be contacted at this time to confirm the requestor’s affiliation with the hospital and confirm internal approval of the PUF request. 6. Following receipt and confirmation of the information submitted, an email will be sent to the requestor containing a username and password along with the URL to download the data. The web link will be active from the time of the email for 10 full days (240 hours). 7. The file will be available in three different formats (Text, SPSS, SAS) and depending on the connection speed should take between 5 and 30 minutes to download. 8. The requestor may be contacted to confirm receipt of the data file and allow for feedback on the delivery mechanism, data points contained, and data file format. 3. File Description Each summer/fall a PUF will be made available for the previous calendar year’s data. The PUF is available in one of three different formats - Text, SAS, and SPSS. In 2008, we provided an additional file that contains SAS and SPSS codes for constructing RACE variable that was available in previous years. The 2015 file contains 273 variables for each case, and a variableby-variable description is provided starting on page 13. A brief description of the different formats follows: File Name ACS_NSQIP_PUF15_v2.txt Type tab delimited TXT file Uncompressed File Size 1.4 GB ACS_NSQIP_PUF15_v2.sas7bdat SAS 9.2 data file 5.1 GB ACS_NSQIP_PUF15_v2.sav SPSS 16.0 data file 2.9 GB Construct_RACE_Codes.txt Notepad file 2 3KB Description Contains 273 HIPAA compliant variables on 885,502 cases submitted from 603 sites in 2015. Same information as stated above in TXT data format. Same information as stated above in TXT and SAS data format. Contains SAS and SPSS codes for constructing RACE variable that was available in 2005, 2006 and 2007. ACS NSQIP 2015 PUF USER GUIDE | OCTOBER 2016 4. Data Variable Updates There are several changes to the “Data Variables” list beginning on Page 13 of this document. The “Variable Definition” column (as it appeared in the PUF User Guides from 2005-2014) has been removed. It has been replaced by a column titled: “Search Term in Chapter 4…” Beginning with this PUF, abbreviated definitions have been removed from the Variable Definition field. So that investigators will have ready access to complete and authoritative variable definitions (rather than past definitions which may be incomplete and potentially misleading with respect to nuanced clinical features of importance to the investigator), the “Search Term in Chapter 4…” field will now contain a search term that will locate the complete definition in Chapter 4 of the “ACS NSQIP Operations Manual” - the authoritative variable definition reference manual used by SCRs. Please be aware that Chapter 4 definitions are year specific, though dramatic changes are rare. Variables names have been reconciled so that you can copy the entire text within an individual cell from the column titled “Search Term in Chapter 4…” in the User Guide, and paste it into a search field (you can create a search field by simultaneously hitting Ctrl and F on your keyboard) in Chapter 4. Once the text is copied into the search field and enter is hit, you will see the variable definition and other information pertinent to that particular variable. To support this new process, investigators receiving the PUF will have the opportunity to download a Chapter 4 corresponding to the specific PUF year (beginning with data for 2015). Appropriate definitions will continue to be provided in the “Search Term in Chapter 4…” field for those variables that are constructed specifically for the PUF and do not exist in Chapter 4. Chapter 4 will be made available to you for download with the rest of your requested PUF files or by contacting your hospital’s Surgical Clinical Reviewer (SCR). Data Use Agreements will now apply to the use and distribution of Chapter 4, as well as PUF data itself. A new variable, “PUFYEAR” has been added to the dataset. This variable will allow you to identify the appropriate Chapter 4 for data that has been merged across several years. In prior years we have retained data fields for historical variables that are no longer collected and inserted missing values. Beginning this year, we are dropping all variables that are not currently collected. Thus, the number of variables included in the Essential PUF is fewer this year than in past years. Also, because the position of data fields is no longer consistent across years, it will no longer be possible to join data across years by merely concatenating files. Files will need to be merged by variable name using appropriate statistical software. 3 ACS NSQIP 2015 PUF USER GUIDE | OCTOBER 2016 5. Data Collection Background and Data Quality The ACS NSQIP collects data on over 150 variables, including preoperative risk factors, intraoperative variables, and 30-day postoperative mortality and morbidity outcomes for patients undergoing major surgical procedures in both the inpatient and outpatient setting. A site’s trained and certified Surgical Clinical Reviewer (SCR) captures these data using a variety of methods including medical chart abstraction. Required data variables are entered via web-based data collection to the ACS NSQIP website. Portions of the data may be automatically populated by a software program that was developed to extract data from the participating hospital’s existing information systems. Requestors should contact the SCR(s) at their hospital for detailed information on how the hospital collects its ACS NSQIP data. To ensure the data collected are of the highest quality, the ACS NSQIP has developed a host of different training mechanisms for the SCRs and conducts an Inter-Rater Reliability (IRR) Audit of selected participating sites. In addition to an initial web-based training program, the ACS NSQIP requires SCRs to complete a series of web-based training modules followed by a certification exam that must be retaken annually. The modules and certification exam focus on the program, processes, and analysis; preoperative, intraoperative, and postoperative definitions; and case studies. These modules are complemented by a growing online decision support system that ensures the SCRs have the knowledge and resources available to collect high-quality data. The IRR Audit is a fundamental tool of ACS NSQIP to assess the quality of the data collected at participating sites. The process involves the review of multiple charts, some of which are selected randomly and others selected based on criteria designed to identify potential reporting errors. For example, cases with five or more preoperative risk factors and no reported mortality or morbidity or cases with two or fewer preoperative risk factors and reported mortality or morbidity will be selected for chart review. Operating room logs are also audited to ensure correct sampling of cases. The combined results of the audits completed to date revealed an overall disagreement rate of approximately 2% for all assessed program variables. The ACS NSQIP has determined that an IRR Audit disagreement rate of 5% or less is acceptable. Sites that have higher than a 5% disagreement rate are not provided a hospital odds ratio in the ACS NSQIP Semiannual Report and may be required to undergo an additional audit following training and education recommendations from the ACS NSQIP. 4 ACS NSQIP 2015 PUF USER GUIDE | OCTOBER 2016 6. Sampling Process and Case Exclusion Criteria Sites participating in the ACS NSQIP can do so in a variety of options that cover general/vascular surgery, multispecialty surgery, or procedure targeted (reported separately). Each participation option includes a systematic sampling process that is described below. Systematic Sampling Process Larger institutions normally experience a significant volume of surgical cases. This presents the problem of managing an overwhelming workload. In order to prevent bias in choosing cases for assessment, a systematic sampling process was developed. An important tool to utilize while performing the systematic sampling process is the 8-Day Cycle Schedule. The 8-day cycle works as follows: If the first ‘cycle’ begins on a Monday, it continues through to include the following Monday (an 8-day period of time). The next cycle begins on Tuesday and continues through to include the following Tuesday. And so on. This process assures that over time cases have equal chances of being selected from each day of the week. Note: There are some exceptions to the systematic sampling inclusion. Hospitals participating in the Small & Rural option will collect all ACS NSQIP®-eligible cases at their hospital. Hospitals participating in Essentials (Multispecialty only) or in the Procedure Targeted (General/Vascular OR Multispecialty) options are provided with sampling requirements specific to their site and may opt to collect more than the specified sampling requirements if resources allow. Case Exclusion Criteria The following exclusion criteria were applied to cases collected in 2015. For the current inclusion/exclusion criteria please contact the ACS NSQIP Clinical Support Team at clinicalsupport@acsnsqip.org. Minor Cases (all cases that are not considered Major) Patients under the age of 18 years. Patient for the case in question has been assigned with an ASA score of 6 (brain-death organ donors). Cases involving Hyperthermic Intraperitoneal Chemotherapy (HIPEC) Trauma cases: Any patient that meets the trauma exclusion criteria will be excluded. Transplant cases: For any patient who is admitted to the hospital and has a transplant procedure, that transplant procedure and any additional surgical procedure during the transplant hospitalization will be excluded. 5 ACS NSQIP 2015 PUF USER GUIDE | OCTOBER 2016 Cases beyond three per cycle for limited cases: For each program option (excluding Small & Rural), only a maximum of three cases from each of the below procedures should be included per 8-day cycle. Any case beyond the case limit of three for any of these procedures should be excluded. o Inguinal Herniorrhaphies o Breast Lumpectomies o Laparoscopic Cholecystectomies o TURPs and/or TURBTs (This limit does not apply for Procedure Targeted sites that are targeting TURPs.) Cases beyond the required number per your site’s contract for each cycle. A return to the operating room that is related to an occurrence or complication of a prior procedure Multiple NSQIP assessed cases within 30 days: Any patient who already has a NSQIPassessed procedure entered within the previous 30 days at your site should be excluded. Only one NSQIP®-assessed procedure can be abstracted patient, per 30 days, for each Hospital Exclusion Criteria In addition to the case inclusion/exclusion criteria, hospital inclusion/exclusion criteria are also imposed. To maintain the highest level of data quality, only cases included in the odds ratio analysis are included in the PUF. These cases go through an additional level of scrutiny as they are passed from data collection to statistical analysis. A site is excluded from the odds ratio calculations and the PUF if it fits any of the following criteria: 30-day follow-up rate is under 80% Inter-Rater Reliability Audit disagreement rate is over 5% Measures Sites Excluded Due to the small number of “Measures” sites enrolled in ACS NSQIP, cases from “Measures” sites have been removed from the PUF dataset in order to protect against possible identification of those sites and cases. 7. Data Limitations While every effort has been made to make the PUF as complete as possible, the data do have certain limitations. Some of these limitations have been deliberately introduced to safeguard the privacy of patients (such as removal of absolute dates). Other limitations are due to resource constraints (such as the collection of generic surgical variables only, except for the procedure 6 ACS NSQIP 2015 PUF USER GUIDE | OCTOBER 2016 targeted option, which is reported separately). The following items represent the most salient limitations of the data: Because such a wide variety of operations are tracked, the variables are necessarily generic in nature. This limitation may pose difficulties for researchers attempting indepth research on specific conditions or operations. However, surgical Targeted PUF datasets are now available which address target-specific predictors and outcomes for many types of operations. While the sex and race distributions are reasonably representative of the national surgery patient population, only patients over the age of 18 are available for assessment, so the age distribution is somewhat truncated. Patients over the age of 90 are also grouped into a 90+ category to prevent cases from being identifiable due to unique data. Patients are followed after surgery for 30 days. Complications or death after that period are not included. Hospitals may follow patients longer than 30 days, but this data is not reported by NSQIP. In order to comply with HIPAA requirements, all absolute dates have been removed. The most critical of these is the date of surgery, which has been reduced to year of surgery only. Some dates (hospital entry, dates of laboratory tests, and so on) have been recoded into durations e.g. Date of Admission and Date of Discharge is recoded into Hospital Length of Stay. In order to comply with the Hospital Participation Agreement (HPA) that is agreed to between the ACS and participating sites, facility identifiers as well as geographic information regarding the case have been removed. The HPA stipulates that the ACS does not identify participating sites. Site identification could be possible even with blinded identifiers through advanced statistics. A stipulation of access to the PUF is completion of the Data Use Agreement that strictly prohibits attempts to identify hospitals, health care providers, or patients. While many risk factors are tracked, preventative measures are not recorded which can lead to an underestimation of the risk of certain conditions when such measures are routinely taken before surgery. The data are submitted from hospitals that are participating in the ACS NSQIP and do not represent a statistically valid nationally representative sample. 7 ACS NSQIP 2015 PUF USER GUIDE | OCTOBER 2016 Most patients do not receive all possible preoperative laboratory tests, so some of these variables have a high percentage of missing values (15% to 45%, depending on the tests). This high percentage of missing data can make it problematic to use these variables in a traditional logistic regression model as well as in many other types of analysis. This list may not include all data limitations and additional limitations may apply in future versions of the data. Graft failure, Coma, and Peripheral Nerve Injury Data Update As first identified and reported in December of 2014, we have identified a problem in reported results for three outcome variables that existed in the Classic program, but did not exist in Essentials, between 2011 and 2013. As it is mandatory to report outcome variables, we have historically converted the absence of an affirmative response (i.e., missing data) to “No Complication”. This otherwise appropriate procedure was mistakenly applied to three outcome variables which were dropped from Essentials beginning in 2011 (Graft failure, Coma, Peripheral Nerve Injury). This logic resulted in “No complication” being assigned to missing data coming from Essential sites where, in fact, no data was being collected for these three outcomes. For the 2013 SAR (when Classic no longer existed) this isn’t much of a problem as users would clearly know that something was wrong when 100% of the cases had “No complication” (for 2014 missing values were inserted for these historical outcome variables rather than “No complication”). However for 2011 and 2012, when some sites were Essentials and some Classic, a PUF user would see a strange, precipitous, drop in event rates for these outcomes. Because of this problem, Graft failure, Coma, and Peripheral Nerve Injury should not be considered accurate for any PUF after 2010. 8. Contact Information All questions about the User Guide or PUF, as well as comments and suggestions for improvements are welcome and may be directed to Brian Matel, ACS NSQIP Statistical Report Manager, via email at bmatel@facs.org. 8 ACS NSQIP 2015 PUF USER GUIDE | OCTOBER 2016 9. Frequently Asked Questions Request Process Q: A: Who has access to this file? Any individual with an official appointment at a fully participating site will be given access to the file following completion of the Data Use Agreement and a short set of questions that are available on the website. Q: A: Is the file available to individuals from nonparticipating sites? At this time the data files are only available to individuals with official appointments at fully participating sites. Q: I am at a NSQIP-participating site and would like to work on a research project with others from a different site that is not participating. Will I be allowed to do that? Yes, however, the NSQIP affiliated researcher must be the lead investigator on all PUFbased research projects and is responsible for the PUF dataset, even if forwarded to someone else. The non-participating collaborator must also sign the DUA. A: Q: A: How do I obtain a copy of this file? Please see the “Data Request Process” on page 1 of this document for a step-by-step approach on how to do so. Contents of the Files Q: A: What is in this file? The file contains Health Insurance Portability and Accountability Act (HIPAA) deidentified data from sites participating in the ACS NSQIP that received risk-adjusted reports in 2015. The variable name, variable label, data definition, and other pertinent information are provided in Section 10: Data Variables and Definitions. Q: A: Are site identifiers included in the database? At this time we do not provide any geographic or site-specific identification. We took this approach to ensure the privacy of both the participating sites and surgeons. Q: A: Are there surgeon-specific identifiers included in the database? At this time we do not provide any surgeon-specific information. We took this approach to ensure the privacy of both the participating sites and surgeons. 9 ACS NSQIP 2015 PUF USER GUIDE | OCTOBER 2016 Q: A: Are other PUF data sets available? 19 other PUF files are available for request / download: PUF Year 2005/2006 2007 2008 2009 2010 2011 2012 2013 2014 2011/2012 2013 2014 2011/2012 2013 2014 2014 2014 2014 2014 PUF Type Essentials Essentials Essentials Essentials Essentials Essentials Essentials Essentials Essentials Colectomy Colectomy Colectomy Vascular Vascular Vascular Gynecology Hepatectomy Hysterectomy Pancreatectomy Cases 152,490 211,407 271,368 336,190 363,431 442,149 543,885 651,940 750,397 16,981 21,505 25,262 655 4,292 4,029 500 3,064 19,283 5,187 Sites 121 183 211 237 258 315 374 435 517 121 154 203 71 83 83 19 92 91 106 Q: A: Why does the PUF exclude specific dates? In order to release the PUF, certain adjustments to the data are required to ensure proper protection of patient information. To meet these requirements, we remove all elements of dates (except quarter of admission and year) for dates directly related to an individual. For more information on the 18 data elements that are required for removal, please visit http://privacyruleandresearch.nih.gov/ or http://privacyruleandresearch.nih.gov/pdf/HIPAA_Booklet_4-14-2003.pdf. Q: I am the Surgeon Champion or Surgical Clinical Reviewer from a site that has records in the PUF and would like to know which specific records are ours. At this time we do not provide site identification of any cases in the PUF, even selfidentification. A: 10 ACS NSQIP 2015 PUF USER GUIDE | OCTOBER 2016 Values in the Data Q: A: Q: A: Q: A: Q: A: Q: A: For each of the following complications, Pneumonia, On Ventilator > 48 hours, Urinary Tract Infection, and Bleeding Transfusion, one case did not have a known duration from operation to complication. Why is that? In each of these complications the case had an invalid date which inhibited the calculation of duration. The number of days from operation to complication variable is coded as -99 for these cases. What are the probability scores for mortality and morbidity and how often are they calculated? The probabilities of mortality and morbidity are provided in this database for all surgery cases in 2015. These probabilities are derived using hierarchical regression analysis, but based only on patient-level effects. They represent the probability (0 to 1) that a case will experience a morbidity or mortality event based on pre-existing conditions. These probabilities are calculated every six months for the previous 12 months of data so the algorithm used to generate the predicted values changes over time as does the data used to create the algorithm. Which calculated probabilities of mortality and morbidity are supplied in this data set? The probabilities of mortality and morbidity for all surgical cases used in the riskadjusted analysis in 2015 are provided. Why do some of the preoperative lab values have duration from lab to operation, but a value of -99 for the lab value? The results of the lab tests can be entered manually and thus are susceptible to data entry error. Depending on the preoperative lab variable roughly 1% of the cases had invalid values and these invalid values were set to -99 to simplify analysis. It is also possible that some cases have valid lab values, but are missing duration from lab to operation variable. This discrepancy is also related to a data entry error and the program continues to improve the data collection software to minimize the potential for data entry errors. When performing analysis on the five digit CPT codes in the Other and Concurrent variables, how should I interpret those cases with a valid 5 digit CPT code but a CPT description set to NULL? If the case has a valid five digit CPT code that procedure occurred and should be evaluated as such. The CPT description is a secondary variable and provided for 11 ACS NSQIP 2015 PUF USER GUIDE | OCTOBER 2016 convenience. In the processing of large amounts of data some descriptions are purposefully or inadvertently removed. File Formats Q: A: In what file formats are the data available? The data files are made available in a tab delimited TXT file, an SPSS file, and a SAS file. 12 ACS NSQIP 2015 PUF USER GUIDE | OCTOBER 2016 Advisement: When a change in definitions across PUF years is noted, users should attend to this if they merge files. It is suggested that they evaluate variable categories across years and combine them in a manner appropriate to their research objectives. Position # Variable Name Data Variable Label Search Term in Chapter 4 Variable Options at Entry Type Notes: 'Variable Name:' needs to be included in Search Term; *Variables not included in Chap 4 1 PUFYEAR Char Year of PUF *Year of PUF 2 CaseID Num Case Identification Number Variable Name:Identification Number (IDN) 3 SEX Char Gender Variable Name:Gender Male; Female American Indian or Alaska Native 4 RACE_NEW Char New Race Variable Name:Race Asian Black or African American Native Hawaiian or Pacific Islander Unknown/Not Reported White 5 ETHNICITY_HISPANIC Char Ethnicity Hispanic Variable Name:Hispanic Ethnicity Yes; No; Unknown 6 PRNCPTX Char Principal operative procedure CPT code description Variable Name:Principal operative procedure CPT code description 7 CPT Char CPT Variable Name:CPT® (Current Procedural Terminology) Code 8 WORKRVU Num Work Relative Value Unit *Work Relative Value Unit 9 INOUT Char Inpatient/outpatient Variable Name:In/Out-Patient Status Outpatient; Inpatient From acute care hospital inpatient 10 TRANST Char Transfer status Variable Name:Origin Status Not transferred (admitted from home) Nursing home - Chronic care - Intermediate care Outside emergency department Transfer from other Unknown 11 Age Char Age of patient with patients over 89 coded as 90+ Variable Name:Date of Birth 12 AdmYR Num Year of Admission Variable Name:Hospital Admission Date 13 OperYR Num Year of Operation Variable Name:Operation Date Skilled Care, Not Home 14 DISCHDEST Char Discharge Destination Variable Name:Hospital Discharge Destination Unskilled Facility Not Home Facility Which was Home Home Separate Acute Care Rehab Expired Unknown Epidural 15 ANESTHES Char Principal anesthesia technique Variable Name:Principal Anesthesia Technique General Local Monitored Anesthesia care (MAC) / IV Sedation None Other Regional Spinal Unknown 16 SURGSPEC Char Surgical Specialty Variable Name:Surgical Specialty Cardiac Surgery General Surgery Gynecology Neurosurgery Orthopedics Otolaryngology (ENT) Plastics Thoracic Urology Vascular Interventional Radiologist 17 ELECTSURG Char Elective Surgery Variable Name:Elective Surgery, Patient Coming From Home Yes; No; Unknown 18 HEIGHT Num Height in inches Variable Name:Height Comments NULL = No Response NULL = No Response NULL = No Response -99 = No Response NULL = No Response NULL = No Response -99 = No Response -99 = No Response -99 = No Response NULL = No Response NULL = No Response 19 WEIGHT Num Weight in lbs Variable Name:weight 20 DIABETES Char Diabetes mellitus with oral agents or insulin Variable Name:Diabetes Mellitus Requiring Therapy with Non-Insulin Agents or Insulin INSULIN; NO; NON-INSULIN NULL = No Response -99=No Response Units converted to inches -99=No Response Units converted to lbs NULL = No Response 21 22 23 24 25 26 27 SMOKE DYSPNEA FNSTATUS2 VENTILAT HXCOPD ASCITES HXCHF Char Char Char Char Char Char Char Current smoker within one year Dyspnea Functional health status Prior to Surgery Ventilator dependent History of severe COPD Ascites Congestive heart failure (CHF) in 30 days before surgery Variable Name:Current Smoker within One Year Variable Name:Dyspnea Variable Name:Functional Health Status Variable Name:Ventilator Dependent Variable Name:COPD (Severe) Variable Name:Ascites within 30 Days Prior to Surgery Variable Name:Congestive Heart Failure within 30 Days Prior to Surgery Yes; No AT REST; MODERATE EXERTION; No Independent; Partially Dependent; Totally Dependent; Unknown Yes; No Yes; No Yes; No Yes; No NULL = No Response NULL = No Response NULL = No Response NULL = No Response NULL = No Response NULL=No Response NULL = No Response Section 10 - Data Variables and Definitions 13 ACS NSQIP 2015 PUF USER GUIDE | OCTOBER 2016 Position # Variable Name Data Type Variable Label Search Term in Chapter 4 Notes: 'Variable Name:' needs to be included in Search Term; *Variables not included in Chap 4 Variable Name:Hypertension Requiring Medication Variable Name:Acute Renal Failure Variable Options at Entry Comments 28 29 HYPERMED RENAFAIL Char Char Hypertension requiring medication Acute renal failure (pre-op) Yes; No Yes; No NULL = No Response NULL = No Response 30 31 32 33 34 35 36 DIALYSIS DISCANCR WNDINF STEROID WTLOSS BLEEDDIS TRANSFUS Char Char Char Char Char Char Char Variable Name:Currently Requiring or On Dialysis Variable Name:Disseminated cancer Variable Name:Open Wound (with or without Infection) Variable Name:Steroid/Immunosuppressant Use for a Chronic Condition Variable Name: > 10% Loss of Body Weight in the 6 Months Prior to Surgery Variable Name:Bleeding disorders Variable Name:Preop Transfusions (RBC within 72 Hours Prior to Surgery Start Time) Yes; No Yes; No Yes; No Yes; No Yes; No Yes; No Yes; No NULL = No Response NULL = No Response NULL = No Response NULL = No Response NULL = No Response NULL = No Response NULL = No Response Char Num Currently on dialysis (pre-op) Disseminated cancer Open wound/wound infection Steroid use for chronic condition >10% loss body weight in last 6 months Bleeding disorders Preop Transfusion of >= 1 unit of whole/packed RBCs in 72 hours prior to surgery Systemic Sepsis Days from Na Preoperative Labs to Operation 37 38 PRSEPIS DPRNA Variable Name:Sepsis within 48 Hours Prior to Surgery *Days from Na Preoperative Labs to Operation SIRS; Sepsis; Septic Shock; None DPRBUN Num Days from BUN Preoperative Labs to Operation *Days from BUN Preoperative Labs to Operation DPRCREAT Num Days from Creatinine Preoperative Labs to Operation *Days from Creatinine Preoperative Labs to Operation 41 DPRALBUM Num Days from Albumin Preoperative Labs to Operation *Days from Albumin Preoperative Labs to Operation 42 DPRBILI Num Days from Bilirubin Preoperative Labs to Operation *Days from Bilirubin Preoperative Labs to Operation 43 DPRSGOT Num Days from SGOT Preoperative Labs to Operation *Days from SGOT Preoperative Labs to Operation 44 DPRALKPH Num Days from ALKPHOS Preoperative Labs to Operation *Days from ALKPHOS Preoperative Labs to Operation 45 DPRWBC Num Days from WBC Preoperative Labs to Operation *Days from WBC Preoperative Labs to Operation 46 DPRHCT Num Days from HCT Preoperative Labs to Operation *Days from HCT Preoperative Labs to Operation 47 DPRPLATE Num Days from PlateCount Preoperative Labs to Operation *Days from PlateCount Preoperative Labs to Operation 48 DPRPTT Num Days from PTT Preoperative Labs to Operation *Days from PTT Preoperative Labs to Operation 49 DPRPT Num Days from PT Preoperative Labs to Operation *Days from PT Preoperative Labs to Operation 50 DPRINR Num Days from INR Preoperative Labs to Operation *Days from INR Preoperative Labs to Operation 51 PRSODM Num Pre-operative serum sodium Variable Name:Preoperative Lab Value Information 52 PRBUN Num Pre-operative BUN Variable Name:Preoperative Lab Value Information 53 PRCREAT Num Pre-operative serum creatinine Variable Name:Preoperative Lab Value Information 54 PRALBUM Num Pre-operative serum albumin Variable Name:Preoperative Lab Value Information 55 PRBILI Num Pre-operative total bilirubin Variable Name:Preoperative Lab Value Information 56 PRSGOT Num Pre-operative SGOT Variable Name:Preoperative Lab Value Information 57 PRALKPH Num Pre-operative alkaline phosphatase Variable Name:Preoperative Lab Value Information 58 PRWBC Num Pre-operative WBC Variable Name:Preoperative Lab Value Information 59 PRHCT Num Pre-operative hematocrit Variable Name:Preoperative Lab Value Information 60 PRPLATE Num Pre-operative platelet count Variable Name:Preoperative Lab Value Information 61 PRPTT Num Pre-operative PTT Variable Name:Preoperative Lab Value Information 62 PRINR Num Pre-operative International Normalized Ratio (INR) of PT values Variable Name:Preoperative Lab Value Information 63 PRPT Num Pre-operative PT Variable Name:Preoperative Lab Value Information 64 65 OTHERPROC1 OTHERCPT1 Char Char Other Procedure 1 Other CPT Code 1 Variable Name:Other Procedure Variable Name:Other Procedure NULL=No Response -99 = Lab value not obtained or No Response -99 = Lab value not obtained or No Response -99 = Lab value not obtained or No Response -99 = Lab value not obtained or No Response -99 = Lab value not obtained or No Response -99 = Lab value not obtained or No Response -99 = Lab value not obtained or No Response -99 = Lab value not obtained or No Response -99 = Lab value not obtained or No Response -99 = Lab value not obtained or No Response -99 = Lab value not obtained or No Response -99 = Lab value not obtained or No Response -99 = Lab value not obtained or No Response -99 = Lab value not obtained or No Response -99 = Lab value not obtained or No Response -99 = Lab value not obtained or No Response -99 = Lab value not obtained or No Response -99 = Lab value not obtained or No Response -99 = Lab value not obtained or No Response -99 = Lab value not obtained or No Response -99 = Lab value not obtained or No Response -99 = Lab value not obtained or No Response -99 = Lab value not obtained or No Response -99 = Lab value not obtained or No Response -99 = Lab value not obtained or No Response -99 = Lab value not obtained or No Response NULL = No Procedure NULL = No Procedure 39 40 Section 10 - Data Variables and Definitions 14 ACS NSQIP 2015 PUF USER GUIDE | OCTOBER 2016 Position # Variable Name Data Type Variable Label 66 OTHERWRVU1 Num Other Work Relative Value Unit 1 Search Term in Chapter 4 Notes: 'Variable Name:' needs to be included in Search Term; *Variables not included in Chap 4 *Other Work Relative Value Unit 1 67 68 69 OTHERPROC2 OTHERCPT2 OTHERWRVU2 Char Char Num Variable Name:Other Procedure 2 Other CPT Code 2 Other Work Relative Value Unit 2 Variable Name:Other Procedure Variable Name:Other Procedure *Other Work Relative Value Unit 2 NULL = No Procedure NULL = No Procedure -99 = No Procedure/No Response 70 71 72 OTHERPROC3 OTHERCPT3 OTHERWRVU3 Char Char Num Variable Name:Other Procedure 3 Other CPT Code 3 Other Work Relative Value Unit 3 Variable Name:Other Procedure Variable Name:Other Procedure *Other Work Relative Value Unit 3 NULL = No Procedure NULL = No Procedure -99 = No Procedure/No Response 73 74 75 OTHERPROC4 OTHERCPT4 OTHERWRVU4 Char Char Num Variable Name:Other Procedure 4 Other CPT Code 4 Other Work Relative Value Unit 4 Variable Name:Other Procedure Variable Name:Other Procedure *Other Work Relative Value Unit 4 NULL = No Procedure NULL = No Procedure -99 = No Procedure/No Response 76 77 78 OTHERPROC5 OTHERCPT5 OTHERWRVU5 Char Char Num Variable Name:Other Procedure 5 Other CPT Code 5 Other Work Relative Value Unit 5 Variable Name:Other Procedure Variable Name:Other Procedure *Other Work Relative Value Unit 5 NULL = No Procedure NULL = No Procedure -99 = No Procedure/No Response 79 80 81 OTHERPROC6 OTHERCPT6 OTHERWRVU6 Char Char Num Variable Name:Other Procedure 6 Other CPT Code 6 Other Work Relative Value Unit 6 Variable Name:Other Procedure Variable Name:Other Procedure *Other Work Relative Value Unit 6 NULL = No Procedure NULL = No Procedure -99 = No Procedure/No Response 82 83 84 OTHERPROC7 OTHERCPT7 OTHERWRVU7 Char Char Num Variable Name:Other Procedure 7 Other Variable Name:Other Procedure 7 Other Work Relative Value Unit 7 Variable Name:Other Procedure Variable Name:Other Procedure *Other Work Relative Value Unit 7 NULL = No Procedure NULL = No Procedure -99 = No Procedure/No Response 85 86 87 OTHERPROC8 OTHERCPT8 OTHERWRVU8 Char Char Num Variable Name:Other Procedure 8 Other Variable Name:Other Procedure 8 Other Work Relative Value Unit 8 Variable Name:Other Procedure Variable Name:Other Procedure *Other Work Relative Value Unit 8 NULL = No Procedure NULL = No Procedure -99 = No Procedure/No Response 88 89 90 OTHERPROC9 OTHERCPT9 OTHERWRVU9 Char Char Num Variable Name:Other Procedure 9 Other Variable Name:Other Procedure 9 Other Work Relative Value Unit 9 Variable Name:Other Procedure Variable Name:Other Procedure *Other Work Relative Value Unit 9 NULL = No Procedure NULL = No Procedure -99 = No Procedure/No Response 91 92 93 OTHERPROC10 OTHERCPT10 OTHERWRVU10 Char Char Num Variable Name:Other Procedure 10 Other Variable Name:Other Procedure 10 Other Work Relative Value Unit 10 Variable Name:Other Procedure Variable Name:Other Procedure *Other Work Relative Value Unit 10 NULL = No Procedure NULL = No Procedure -99 = No Procedure/No Response 94 95 96 CONCURR1 CONCPT1 CONWRVU1 Char Char Num Concurrent Procedure 1 Concurrent CPT 1 Concurrent Work Relative Value Unit 1 Variable Name:Concurrent Procedure Variable Name:Concurrent Procedure *Concurrent Work Relative Value Unit 1 NULL = No Procedure NULL = No Procedure -99 = No Procedure/No Response 97 98 99 CONCURR2 CONCPT2 CONWRVU2 Char Char Num Concurrent Procedure 2 Concurrent CPT 2 Concurrent Work Relative Value Unit 2 Variable Name:Concurrent Procedure Variable Name:Concurrent Procedure *Concurrent Work Relative Value Unit 2 NULL = No Procedure NULL = No Procedure -99 = No Procedure/No Response 100 101 102 CONCURR3 CONCPT3 CONWRVU3 Char Char Num Concurrent Procedure 3 Concurrent CPT 3 Concurrent Work Relative Value Unit 3 Variable Name:Concurrent Procedure Variable Name:Concurrent Procedure *Concurrent Work Relative Value Unit 3 NULL = No Procedure NULL = No Procedure -99 = No Procedure/No Response 103 104 105 CONCURR4 CONCPT4 CONWRVU4 Char Char Num Concurrent Procedure 4 Concurrent CPT 4 Concurrent Work Relative Value Unit 4 Variable Name:Concurrent Procedure Variable Name:Concurrent Procedure *Concurrent Work Relative Value Unit 4 NULL = No Procedure NULL = No Procedure -99 = No Procedure/No Response 106 107 108 CONCURR5 CONCPT5 CONWRVU5 Char Char Num Concurrent Procedure 5 Concurrent CPT 5 Concurrent Work Relative Value Unit 5 Variable Name:Concurrent Procedure Variable Name:Concurrent Procedure *Concurrent Work Relative Value Unit 5 NULL = No Procedure NULL = No Procedure -99 = No Procedure/No Response 109 110 111 CONCURR6 CONCPT6 CONWRVU6 Char Char Num Concurrent Procedure 6 Concurrent CPT 6 Concurrent Work Relative Value Unit 6 Variable Name:Concurrent Procedure Variable Name:Concurrent Procedure *Concurrent Work Relative Value Unit 6 NULL = No Procedure NULL = No Procedure -99 = No Procedure/No Response 112 113 114 CONCURR7 CONCPT7 CONWRVU7 Char Char Num Concurrent Procedure 7 Concurrent CPT 7 Concurrent Work Relative Value Unit 7 Variable Name:Concurrent Procedure Variable Name:Concurrent Procedure *Concurrent Work Relative Value Unit 7 NULL = No Procedure NULL = No Procedure -99 = No Procedure/No Response 115 CONCURR8 Char Concurrent Procedure 8 Variable Name:Concurrent Procedure NULL = No Procedure Variable Options at Entry Comments -99 = No Procedure/No Response Section 10 - Data Variables and Definitions 15 ACS NSQIP 2015 PUF USER GUIDE | OCTOBER 2016 Position # Variable Name Data Type Variable Label 116 117 CONCPT8 CONWRVU8 Char Num Concurrent CPT 8 Concurrent Work Relative Value Unit 8 Search Term in Chapter 4 Notes: 'Variable Name:' needs to be included in Search Term; *Variables not included in Chap 4 Variable Name:Concurrent Procedure *Concurrent Work Relative Value Unit 8 118 119 120 CONCURR9 CONCPT9 CONWRVU9 Char Char Num Concurrent Procedure 9 Concurrent CPT 9 Concurrent Work Relative Value Unit 9 Variable Name:Concurrent Procedure Variable Name:Concurrent Procedure *Concurrent Work Relative Value Unit 9 NULL = No Procedure NULL = No Procedure -99 = No Procedure/No Response 121 122 123 CONCURR10 CONCPT10 CONWRVU10 Char Char Num Concurrent Procedure 10 Concurrent CPT 10 Concurrent Work Relative Value Unit 10 Variable Name:Concurrent Procedure Variable Name:Concurrent Procedure *Concurrent Work Relative Value Unit 10 NULL = No Procedure NULL = No Procedure -99 = No Procedure/No Response 124 125 EMERGNCY WNDCLAS Char Char Emergency case Wound classification Variable Name:Emergency Case Variable Name: Wound Classification 126 ASACLAS Char ASA classification Variable Name:ASA Classification 127 MORTPROB Num Estimated Probability of Mortality *Probability of mortality is developed for all cases based on a logistic regression analysis using the patient's preopeartive characteristics as the independent or predictive variables. Only cases included in the logistic regression analysis will have the associated probabilities of mortality. System missing = case was not included in the logistic regression analysis 128 MORBPROB Num Estimated Probability of Morbidity *Probability of morbidity is developed for all cases based on a logistic regression analysis using the patient's preopeartive characteristics as the independent or predictive variables. Only cases included in the logistic regression analysis will have the associated probabilities of morbidity. System missing = case was not included in the logistic regression analysis 129 130 131 OPTIME HDISDT YRDEATH Num Num Num Total operation time Hospital discharge Year Year of death *Total operation time in minutes Variable Name:Acute Hospital Discharge Date Variable Name:Date of Death -99 = No Response -99 = No Response -99 = Patient alive at 30 days Notes: include death >30days of procedure 132 133 134 135 136 137 138 139 140 141 TOTHLOS AdmQtr HtoODay NSUPINFEC SUPINFEC SSSIPATOS DSUPINFEC NWNDINFD WNDINFD DSSIPATOS Num Num Num Num Char Char Num Num Char Char Length of total hospital stay Quarter of Admission Days from Hospital Admission to Operation Number of Superficial Incisional SSI Occurrences Occurrences Superficial surgical site infection Superficial Incisional SSI PATOS Days from Operation until Superficial Incisional SSI Complication Number of Deep Incisional SSI Occurrences Occurrences Deep Incisional SSI Deep Incisional SSI PATOS *Length of total hospital stay Variable Name:Hospital Admission Date *Days from Hospital Admission to Operation *Number of Superficial Incisional SSI Occurrences Variable Name:Superficial Incisional SSI Variable Name:Superficial Incisional SSI – PATOS *Days from Operation until Superficial Incisional SSI Complication *Number of Deep Incisional SSI Occurrences Variable Name:Deep Incisional SSI Variable Name:Deep Incisional SSI – PATOS 142 DWNDINFD Num Days from Operation until Deep Incisional SSI Complication *Days from Operation until Deep Incisional SSI Complication 143 144 145 146 NORGSPCSSI ORGSPCSSI OSSIPATOS DORGSPCSSI Num Char Char Num Number of Organ/Space SSI Occurrences Occurrences Organ Space SSI Organ/Space SSI PATOS Days from Operation until Organ/Space SSI Complication *Number of Organ/Space SSI Occurrences Variable Name:Organ/Space SSI Variable Name:Organ/Space SSI – PATOS *Days from Operation until Organ/Space SSI Complication Organ/Space SSI; No Complication Yes; No 147 148 149 NDEHIS DEHIS DDEHIS Num Char Num Number of Wound Disruption Occurrences Occurrences Wound Disrupt Days from Operation until Wound Disruption Complication *Number of Wound Disruption Occurrences Variable Name:Wound Disruption *Days from Operation until Wound Disruption Complication Wound Disruption; No Complication 150 151 152 153 NOUPNEUMO OUPNEUMO PNAPATOS DOUPNEUMO Num Char Char Num Number of Pneumonia Occurrences Occurrences Pneumonia Pneumonia PATOS Days from Operation until Pneumonia Complication *Number of Pneumonia Occurrences Variable Name:Pneumonia Variable Name:Pneumonia – PATOS *Days from Operation until Pneumonia Complication Pneumonia; No Complication Yes; No 154 NREINTUB Num Number of Unplanned Intubation Occurrences *Number of Unplanned Intubation Occurrences Variable Options at Entry Comments NULL = No Procedure -99 = No Procedure/No Response Yes; No 1-Clean 2-Clean/Contaminated 3-Contaminated 4-Dirty/Infected 1 -No Disturb 2 -Mild Disturb 3 -Severe Disturb 4 -Life Threat 5 -Moribund None assigned 1; 2; 3; 4 NULL = No Response NULL = No Response NULL= No Response -99 = No Response -99 = No Response No Complication; Superficial Incisional SSI Yes; No NULL = No response Deep Incisional SSI; No Complication Yes; No NULL = No response -99 = Patient did not experience this complication at or before 30 days post operation NULL = No response -99 = Patient did not experience this complication at or before 30 days post operation -99 = Patient did not experience this complication at or before 30 days post operation NULL = No response -99 = Patient did not experience this complication at or before 30 days post operation Section 10 - Data Variables and Definitions 16 ACS NSQIP 2015 PUF USER GUIDE | OCTOBER 2016 Position # Variable Name Data Type Variable Label 155 156 REINTUB DREINTUB Char Num Occurrences Unplanned Intubation Days from Operation until Unplanned Intubation Complication Search Term in Chapter 4 Notes: 'Variable Name:' needs to be included in Search Term; *Variables not included in Chap 4 Variable Name:Unplanned Intubation *Days from Operation until Unplanned Intubation Complication 157 158 NPULEMBOL PULEMBOL Num Char Number of Pulmonary Embolism Occurrences Occurrences Pulmonary Embolism *Number of Pulmonary Embolism Occurrences Variable Name:Pulmonary Embolism 159 DPULEMBOL Num Days from Operation until Pulmonary Embolism Complication *Days from Operation until Pulmonary Embolism Complication 160 161 162 163 NFAILWEAN FAILWEAN VENTPATOS DFAILWEAN Num Char Char Num Number of On Ventilator > 48 Hours Occurrences Occurrences Ventilator > 48Hours On Ventilator > 48 Hours PATOS Days from Operation until On Ventilator > 48 Hours Complication *Number of On Ventilator > 48 Hours Occurrences Variable Name:On Ventilator > 48 Hours Variable Name:On Ventilator > 48 Hours – PATOS *Days from Operation until On Ventilator > 48 Hours Complication 164 165 NRENAINSF RENAINSF Num Char Number of Progressive Renal Insufficiency Occurrences Occurrences Progressive Renal Insufficiency *Number of Progressive Renal Insufficiency Occurrences Variable Name:Progressive Renal Insufficiency/Acute Renal Failure Requiring Dialysis 166 DRENAINSF Num Days from Operation until Progressive Renal Insufficiency Complication *Days from Operation until Progressive Renal Insufficiency Complication 167 168 NOPRENAFL OPRENAFL Num Char Number of Acute Renal Failure Occurrences Occurrences Acute Renal Fail *Number of Acute Renal Failure Occurrences Variable Name:Progressive Renal Insufficiency/Acute Renal Failure Requiring Dialysis 169 DOPRENAFL Num Days from Operation until Acute Renal Failure Complication *Days from Operation until Acute Renal Failure Complication 170 171 172 173 NURNINFEC URNINFEC UTIPATOS DURNINFEC Num Char Char Num Number of Urinary Tract infection Occurrences Occurrences Urinary Tract Infection UTI PATOS Days from Operation until Urinary Tract Infection Complication *Number of Urinary Tract infection Occurrences Variable Name:Urinary Tract Infection Variable Name:UTI – PATOS *Days from Operation until Urinary Tract Infection Complication Urinary Tract Infection; No Complication Yes; No 174 175 176 NCNSCVA CNSCVA DCNSCVA Num Char Num Number of Stroke/CVA Occurrences CVA/Stroke with neurological deficit Days from Operation until Stroke/CVA Complication *Number of Stroke/CVA Occurrences Variable Name:Stroke/Cerebral Vascular Accident (CVA) *Days from Operation until Stroke/CVA Complication Stroke/CVA; No Complication 177 178 179 NCDARREST CDARREST DCDARREST Num Char Num Number of Cardiac Arrest Requiring CPR Occurrences Occurrences Cardiac Arrest Requiring CPR Days from Operation until Cardiac Arrest Requiring CPR Complication *Number of Cardiac Arrest Requiring CPR Occurrences Variable Name:Intraoperative or Postoperative Cardiac Arrest Requiring CPR *Days from Operation until Cardiac Arrest Requiring CPR Complication Cardiac Arrest Requiring CPR; No Complication 180 181 182 NCDMI CDMI DCDMI Num Char Num Number of Myocardial Infarction Occurrences Occurrences Myocardial Infarction Days from Operation until Myocardial Infarction Complication *Number of Myocardial Infarction Occurrences Variable Name:Intraoperative or Postoperative Myocardial Infarction *Days from Operation until Myocardial Infarction Complication Myocardial Infarction; No Complication 183 184 NOTHBLEED OTHBLEED Num Char Number of Bleeding Transfusions Occurrences Occurrences Bleeding Transfusions *Number of Bleeding Transfusions Occurrences Variable Name:Transfusion Intra/Postop (RBC within the First 72 Hrs of Surgery Start Time) Transfusions/Intraop/Postop; No Complication 185 DOTHBLEED Num Days from Operation until Bleeding Transfusions Complication *Days from Operation until Bleeding Transfusions Complication 186 187 188 NOTHDVT OTHDVT DOTHDVT Num Char Num Number of DVT/Thrombophlebitis Occurrences Occurrences DVT/Thrombophlebitis Days from Operation until DVT/Thrombophlebitis Complication *Number of DVT/Thrombophlebitis Occurrences Variable Name:Vein Thrombosis Requiring Therapy *Days from Operation until DVT/Thrombophlebitis Complication DVT Requiring Therapy; No Complication 189 190 191 192 NOTHSYSEP OTHSYSEP SEPSISPATOS DOTHSYSEP Num Char Char Num Number of Sepsis Occurrences Occurrences Sepsis Sepsis PATOS Days from Operation until Sepsis Complication *Number of Sepsis Occurrences Variable Name:Sepsis Variable Name:Sepsis – PATOS *Days from Operation until Sepsis Complication Sepsis; No Complication Yes; No 193 NOTHSESHOCK Num Number of Septic Shock Occurrences *Number of Septic Shock Occurrences Variable Options at Entry Comments Unplanned Intubation; No Complication -99 = Patient did not experience this complication at or before 30 days post operation Pulmonary Embolism; No Complication -99 = Patient did not experience this complication at or before 30 days post operation On Ventilator greater than 48 Hours; No Complication Yes; No NULL = No response -99 = Patient did not experience this complication at or before 30 days post operation Progressive Renal Insufficiency; No Complication -99 = Patient did not experience this complication at or before 30 days post operation Acute Renal Failure; No Complication -99 = Patient did not experience this complication at or before 30 days post operation NULL = No response -99 = Patient did not experience this complication at or before 30 days post operation -99 = Patient did not experience this complication at or before 30 days post operation -99 = Patient did not experience this complication at or before 30 days post operation -99 = Patient did not experience this complication at or before 30 days post operation -99 = Patient did not experience this complication at or before 30 days post operation -99 = Patient did not experience this complication at or before 30 days post operation NULL = No Response -99 = Patient did not experience this complication at or before 30 days post operation Section 10 - Data Variables and Definitions 17 ACS NSQIP 2015 PUF USER GUIDE | OCTOBER 2016 Position # Variable Name Data Type Variable Label 194 195 196 OTHSESHOCK SEPSHOCKPATOS DOTHSESHOCK Char Char Num Occurrences Septic Shock Septic Shock PATOS Days from Operation until Septic Shock Complication Search Term in Chapter 4 Notes: 'Variable Name:' needs to be included in Search Term; *Variables not included in Chap 4 Variable Name:Septic Shock Variable Name:Septic Shock – PATOS *Days from Operation until Septic Shock Complication 197 198 199 200 201 202 PODIAG PODIAGTX PODIAG10 PODIAGTX10 RETURNOR DOpertoD Char Char Char Char Char Num Post-op diagnosis (ICD 9) Post-op Diagnosis Text Post-op diagnosis (ICD 10) Post-op Diagnosis Text Return to OR Days from Operation to Death Variable Name:Postoperative Diagnosis (ICD Code) Variable Name:Postoperative Diagnosis (ICD Code) Variable Name:Postoperative Diagnosis (ICD Code) Variable Name:Postoperative Diagnosis (ICD Code) Variable Name:Unplanned Reoperation *Days from Operation to Death 203 204 205 206 DOptoDis STILLINHOSP REOPERATION1 RETORPODAYS Num Char Char Num Days from Operation to Discharge Still in Hospital > 30 Days Unplanned Reoperation 1 Days from principal operative procedure to Unplanned Reoperation 1 *Days from Operation to Discharge Variable Name:Still in Hospital > 30 Days Variable Name:Unplanned Reoperation *Days from principal operative procedure to Unplanned Reoperation 1 207 208 REOPORCPT1 RETORRELATED Char Char Unplanned Reoperation 1 CPT Unplanned Reoperation 1 related to principal operative procedure Variable Name:Unplanned Reoperation Variable Name:Unplanned Reoperation 209 210 211 212 REOPORICD91 REOPOR1ICD101 REOPERATION2 RETOR2PODAYS Char Char Char Num Unplanned Reoperation 1 ICD-9 Unplanned Reoperation 1 ICD-10 Unplanned Reoperation 2 Days from principal operative procedure to Unplanned Reoperation 2 Variable Name:Unplanned Reoperation Variable Name:Unplanned Reoperation Variable Name:Unplanned Reoperation *Days from principal operative procedure to Unplanned Reoperation 2 213 214 REOPOR2CPT1 RETOR2RELATED Char Char Unplanned Reoperation 2 CPT Unplanned Reoperation 2 related to principal operative procedure Variable Name:Unplanned Reoperation Variable Name:Unplanned Reoperation 215 216 217 218 219 REOPOR2ICD91 REOPOR2ICD101 REOPERATION3 READMISSION1 READMPODAYS1 Char Char Char Char Num Unplanned Reoperation 2 ICD-9 Unplanned Reoperation 2 ICD-10 More than 2 unplanned reoperations Any Readmission 1 Days from principal operative procedure to Any Readmission 1 Variable Name:Unplanned Reoperation Variable Name:Unplanned Reoperation Variable Name:Unplanned Reoperation Variable Name:Hospital Readmission *Days from principal operative procedure to Any Readmission 1 220 221 UNPLANNEDREADMISSION1 READMRELATED1 Char Char Unplanned Readmission 1 Unplanned Readmission 1 likely related to the principal procedure Variable Name:Hospital Readmission Variable Name:Hospital Readmission Yes; No Yes; No 222 READMSUSPREASON1 Char Readmission related suspected reason 1 Variable Name:Hospital Readmission Superficial Incisional SSI Deep Incisional SSI Organ/Space SSI Wound Disruption Pneumonia Unplanned Intubation Pulmonary Embolism On Ventilator > 48 hours Progressive Renal Insufficiency Acute Renal Failure Urinary Tract Infection CVA Cardiac Arrest Requiring CPR Myocardial Infarction Bleeding Requiring Transfusion (72h of surgery start time) Vein Thrombosis Requiring Therapy Sepsis Septic Shock Other (list ICD 9 code) Other (list ICD 10 code) C. diff Variable Options at Entry Comments Septic Shock; No Complication Yes; No NULL = No Response -99 = Patient did not experience this complication at or before 30 days post operation Yes; No NULL= No Response -99 = Patient did not die at or before 30 days post operation Notes: deaths within 30 days of procedure included only -99 = No Response NULL = No Response NULL=No Response -99 = Patient did not experience Unplanned Reoperation 1 NULL = No Response NULL = No Response Yes; No Yes; No Yes No Unknown NULL = No Response Yes; No NULL=No Response -99 = Patient did not experience Unplanned Reoperation 2 NULL = No Response NULL = No Response Yes No Unknown NULL = No Response NULL = No Response NULL=No Response NULL=No Response -99 = Patient did not experience Any Readmission 1 NULL = No Response NULL = No Response Yes; No Yes; No NULL = No Response Section 10 - Data Variables and Definitions 18 ACS NSQIP 2015 PUF USER GUIDE | OCTOBER 2016 Position # Variable Name Data Type Variable Label 223 READMUNRELSUSP1 Char Readmission unrelated suspected reason 1 Search Term in Chapter 4 Notes: 'Variable Name:' needs to be included in Search Term; *Variables not included in Chap 4 Variable Name:Hospital Readmission 224 225 226 227 228 229 READMRELICD91 READMRELICD101 READMUNRELICD91 READMUNRELICD101 READMISSION2 READMPODAYS2 Char Char Char Char Char Num Readmission related ICD-9 code 1 Readmission related ICD-10 code 1 Readmission unrelated ICD-9 code 1 Readmission unrelated ICD-10 code 1 Any Readmission 2 Days from principal operative procedure to Any Readmission 2 Variable Name:Hospital Readmission Variable Name:Hospital Readmission Variable Name:Hospital Readmission Variable Name:Hospital Readmission Variable Name:Hospital Readmission *Days from principal operative procedure to Any Readmission 2 230 231 UNPLANNEDREADMISSION2 READMRELATED2 Char Char Unplanned Readmission 2 Unplanned Readmission 2 likely related to the principal procedure Variable Name:Hospital Readmission Variable Name:Hospital Readmission Yes;No Yes;No 232 233 234 235 236 237 238 239 READMSUSPREASON2 READMUNRELSUSP2 READMRELICD92 READMRELICD102 READMUNRELICD92 READMUNRELICD102 READMISSION3 READMPODAYS3 Char Char Char Char Char Char Char Num Readmission related suspected reason 2 Readmission unrelated suspected reason 2 Readmission related ICD-9 code 2 Readmission related ICD-10 code 2 Readmission unrelated ICD-9 code 2 Readmission unrelated ICD-10 code 2 Any Readmission 3 Days from principal operative procedure to Any Readmission 3 Variable Name:Hospital Readmission Variable Name:Hospital Readmission Variable Name:Hospital Readmission Variable Name:Hospital Readmission Variable Name:Hospital Readmission Variable Name:Hospital Readmission Variable Name:Hospital Readmission *Days from principal operative procedure to Any Readmission 3 See "Readmission related suspected reason 1" See "Readmission unrelated suspected reason 1" 240 241 UNPLANNEDREADMISSION3 READMRELATED3 Char Char Unplanned Readmission 3 Unplanned Readmission 3 likely related to the principal procedure Variable Name:Hospital Readmission Variable Name:Hospital Readmission Yes;No Yes; No 242 243 244 245 246 247 248 249 READMSUSPREASON3 READMUNRELSUSP3 READMRELICD93 READMRELICD103 READMUNRELICD93 READMUNRELICD103 READMISSION4 READMPODAYS4 Char Char Char Char Char Char Char Num Readmission related suspected reason 3 Readmission unrelated suspected reason 3 Readmission related ICD-9 code 3 Readmission related ICD-10 code 3 Readmission unrelated ICD-9 code 3 Readmission unrelated ICD-10 code 3 Any Readmission 4 Days from principal operative procedure to Any Readmission 4 Variable Name:Hospital Readmission Variable Name:Hospital Readmission Variable Name:Hospital Readmission Variable Name:Hospital Readmission Variable Name:Hospital Readmission Variable Name:Hospital Readmission Variable Name:Hospital Readmission *Days from principal operative procedure to Any Readmission 4 See "Readmission related suspected reason 1" See "Readmission unrelated suspected reason 1" 250 251 UNPLANNEDREADMISSION4 READMRELATED4 Char Char Unplanned Readmission 4 Unplanned Readmission 4 likely related to the principal procedure Variable Name:Hospital Readmission Variable Name:Hospital Readmission Yes; No Yes; No 252 253 254 255 256 257 258 259 READMSUSPREASON4 READMUNRELSUSP4 READMRELICD94 READMRELICD104 READMUNRELICD94 READMUNRELICD104 READMISSION5 READMPODAYS5 Char Char Char Char Char Char Char Num Readmission related suspected reason 4 Readmission unrelated suspected reason 4 Readmission related ICD-9 code 4 Readmission related ICD-10 code 4 Readmission unrelated ICD-9 code 4 Readmission unrelated ICD-10 code 4 Any Readmission 5 Days from principal operative procedure to Any Readmission 5 Variable Name:Hospital Readmission Variable Name:Hospital Readmission Variable Name:Hospital Readmission Variable Name:Hospital Readmission Variable Name:Hospital Readmission Variable Name:Hospital Readmission Variable Name:Hospital Readmission *Days from principal operative procedure to Any Readmission 5 See "Readmission related suspected reason 1" See "Readmission unrelated suspected reason 1" 260 261 UNPLANNEDREADMISSION5 READMRELATED5 Char Char Unplanned Readmission 5 Unplanned Readmission 5 likely related to the principal procedure Variable Name:Hospital Readmission Variable Name:Hospital Readmission Yes; No Yes; No Variable Options at Entry Comments Superficial Incisional SSI Deep Incisional SSI Organ/Space SSI Wound Disruption Pneumonia Unplanned Intubation Pulmonary Embolism On Ventilator > 48 hours Progressive Renal Insufficiency Acute Renal Failure Urinary Tract Infection CVA Cardiac Arrest Requiring CPR Myocardial Infarction Bleeding Requiring Transfusion (72h of surgery start time) Vein Thrombosis Requiring Therapy Sepsis Septic Shock Other (list ICD 9 code) Other (list ICD 10 code) C. diff NULL = No Response NULL = No Response NULL = No Response NULL = No Response NULL = No Response Yes; No -99 = Patient did not experience Any Readmission 2 NULL = No Response NULL = No Response NULL = No Response NULL = No Response NULL = No Response NULL = No Response NULL = No Response NULL = No Response Yes; No -99 = Patient did not experience Any Readmission 3 NULL = No Response NULL = No Response NULL = No Response NULL = No Response NULL = No Response NULL = No Response NULL = No Response NULL = No Response Yes; No -99 = Patient did not experience Any Readmission 4 NULL = No Response NULL = No Response NULL = No Response NULL = No Response NULL = No Response NULL = No Response NULL = No Response NULL = No Response Yes; No -99 = Patient did not experience Any Readmission 5 NULL = No Response NULL = No Response Section 10 - Data Variables and Definitions 19 ACS NSQIP 2015 PUF USER GUIDE | OCTOBER 2016 Position # Variable Name Data Type Variable Label 262 263 264 265 266 267 268 READMSUSPREASON5 READMUNRELSUSP5 READMRELICD95 READMRELICD105 READMUNRELICD95 READMUNRELICD105 WOUND_CLOSURE Char Char Char Char Char Char Char Readmission related suspected reason 5 Readmission unrelated suspected reason 5 Readmission related ICD-9 code 5 Readmission related ICD-10 code 5 Readmission unrelated ICD-9 code 5 Readmission unrelated ICD-10 code 5 Surgical wound closure Search Term in Chapter 4 Notes: 'Variable Name:' needs to be included in Search Term; *Variables not included in Chap 4 Variable Name:Hospital Readmission Variable Name:Hospital Readmission Variable Name:Hospital Readmission Variable Name:Hospital Readmission Variable Name:Hospital Readmission Variable Name:Hospital Readmission Variable Name:Surgical Wound(s) Closure 269 270 271 PODIAG_OTHER PODIAG_OTHER10 ANESTHES_OTHER Char Char Char Other postoperative occurrence(ICD 9) Other postoperative occurrence(ICD 10) Additional anesthesia technique Variable Name:Other Postoperative Occurrence (ICD Code) Variable Name:Other Postoperative Occurrence (ICD Code) Variable Name:Additional Anesthesia Technique(s) 272 273 274 OTHCDIFF NOTHCDIFF DOTHCDIFF Char Num Num Occurrences Clostridium Difficile (C.diff) Colitis Number of C. diff Occurrences Days from operation until C.diff Complication Variable Name:Postoperative Clostridium Difficile (C.diff) Colitis *Number of C. diff Colitis Occurrences *Days from operation till C. diff Colitis Complication Variable Options at Entry Comments See "Readmission related suspected reason 1" See "Readmission unrelated suspected reason 1" NULL = No Response NULL = No Response NULL = No Response NULL = No Response NULL = No Response NULL = No Response NULL=No Response All layers of incision (deep and superficial) fully closed Only deep layers closed; superficial left open No layers of incision are surgically closed General Epidural Spinal Regional Local Monitored Anesthesia Care/IV Sedation Other No Complication; C. diff NULL=No Response NULL=No Response NULL = No Response -99=Patient did not experience complication at or before 30 days post operations Section 10 - Data Variables and Definitions 20 © 2016 American College of Surgeons All rights reserved
Source Exif Data:
File Type : PDF File Type Extension : pdf MIME Type : application/pdf PDF Version : 1.3 Linearized : No XMP Toolkit : XMP Core 5.4.0 Modify Date : 2016:10:31 10:58:37-05:00 Create Date : 2016:10:31 10:58:37-05:00 Metadata Date : 2016:10:31 10:58:37-05:00 Creator Tool : Adobe Acrobat Pro 10.1.8 Producer : Adobe Acrobat Pro 10.1.8 Creator : bmatel Format : application/pdf Document ID : uuid:c9296619-1ada-449b-a1b7-b6027dc5e63b Instance ID : uuid:1f6999a4-e2bc-4414-b544-1c86201f768c Page Count : 26 Author : bmatelEXIF Metadata provided by EXIF.tools