NSQIP_INFO

Description:

The NSQIP_INFO table contains NSQIP registry data for the surgeries that are selected for NSQIP submission.

Primary Key

Column Name	Ordinal Position
REGISTRY_DATA_ID	1

Column Information

	Name	Type	Discontinued?
1	REGISTRY_DATA_ID	NUMERIC	No
	The unique identifier (.1 item) for the registry data record.
2	REGISTRY_DATA_NAME	VARCHAR	No
	The registry record name.
3	RECORD_STATUS_C_NAME	VARCHAR	No
	The category ID for the record status (hidden, soft-deleted, etc...). May contain organization-specific values: No Category Entries: Soft Deleted Hidden Hidden and Soft Deleted
4	REGISTRY_ID	NUMERIC	No
	The unique ID of the registry associated with this RDI record.
5	REGISTRY_ID_REGISTRY_NAME	VARCHAR	No
	The name of the registry record.
6	REGISTRY_TYPE_C_NAME	VARCHAR	No
	The category ID for the type of registry. For this table the value will always be 20000 corresponding to ACS NSQIP. May contain organization-specific values: Yes Category Entries: Core Measures ACC-NCDR CathPCI Version 3 and 4 ACC-NCDR EP Device Implant Meaningful Use Quality Measures ACC-NCDR PINNACLE ACC-NCDR AFib Ablation ACC-NCDR CathPCI ACC-NCDR CathPCI Follow-up UNOS Configuration Vermont Oxford Network Quality Measure - Individual Quality Measure - Patient Details Generic Attribution Physician Quality Reporting Summary - Incremental Meaningful Use Summary - Incremental Internal QM Summary - Incremental Physician Quality Reporting Registry Summary - Full Year Meaningful Use Summary - Final Physician Quality Reporting Registry Summary - Half Year Physician Quality Reporting EHR Summary - Full Year Universal Data System Summary Universal Data System Details QRDA-III XML Run Summary Regulatory Reporting Patient Metadata Objective Measures - Run Statistics Objective Measures - EP Fact Objective Measures - Patient Fact Objective Measures - Summary Objective Measures - EH Fact My Panel Metrics - Patient Pulse Information RDI Child Record Health and Care Plan UNOS Kidney Recipient Follow-up UNOS Liver Recipient Follow-up UNOS Pancreas Recipient Follow-up UNOS Kidney/Pancreas Recipient Follow-up UNOS Thoracic Recipient Follow-up UNOS Kidney Living Donor Follow-up UNOS Kidney Pancreas Wait List UNOS Liver Intestine Wait List UNOS Thoracic Wait List UNOS Kidney Candidate Registration UNOS Liver Candidate Registration UNOS Heart/Lung Candidate Registration UNOS Heart Candidate Registration UNOS Lung Candidate Registration UNOS Pancreas and Pancreas Islets Candidate Registration UNOS Kidney/Pancreas Candidate Registration UNOS Kidney Recipient Registration UNOS Liver Recipient Registration UNOS Pancreas Recipient Registration UNOS Kidney/Pancreas Recipient Registration UNOS Thoracic Recipient Registration UNOS Kidney Living Donor Registration UNOS Deceased Donor Registration UNOS Deceased Donor Histocompatibility ACS NSQIP THL Implant Surgical Care Improvement Project Hoitotahto Elinluovutustahto HH Outcomes HH Adverse Events National POLST Form Ryan White Services Reporting Ryan White CAREWare Reporting Nationale Intensive Care Evaluatie Pediatrische Intensive Care Evaluatie Australian and New Zealand Pediatric Intensive Care Registry Australian and New Zealand Neonatal Network Swiss MDSi MyChart Federal MCSA-5875 State MCSA-5875 Certificate MCSA-5876 CG719K Form Belgium eBirth - Birth Notification Belgium eBirth - Medical Form Fødselsmelding Skatteetaten Medisinsk fødselsregister (MFR) Labour Birth Postpartum Maternal HBHC Birth Child Postpartum Child NICU Child HBHC Abstraction Subabstraction Minimum Data Set Infection Case NHSN Lab Identified Organism Procedure Abstraction COVID-19 Hospital Infections EQRS Submission CMS Registration Form 2728 CMS Death Form 2746 Nephrology Configuration American Heart Association Get With The Guidelines - Stroke COVID-19 PUI Case Report Lung Cancer Screening Registry ASCO-QOPI Cancer Outcomes and Services Dataset Perined: Kernset Aanleverbericht THL: Congenital Malformations Family Planning Annual Report IRF-PAI CMG Data 60% Rule Data CMG Score Config Data Map IGC Data IRF IGC Spotter Risk Adjusted Self Care Change Risk Adjusted Mobility Change Risk Adjusted Self Care Discharge Risk Adjusted Mobility Discharge IRF Risk Adjustment ICD-10 to HCC Mappings Infection Control Regulatory Definitions Infection Control LDA-Based Metric Definition Infection Control Metric Details Infection Control Manual Metric Details Configuration Template Infection Control Surveillance Abstraction Infection Control Search Parameters NHSN Antimicrobial Resistance Event Exposure Case Abstraction Outbreak Definition NHSN CLIP Abstraction Scoring System Deferral Configuration Scoring System Deferral User Interface Configuration Reporting Agency Configuration Reportable Condition Configuration Syndromic Surveillance Event Type (BPA Trigger) Syndromic Surveillance Syndrome GIQuIC-Colonoscopy Analytics Registry
7	REG_OVRIDE_CONTEXT	VARCHAR	No
	The override context string to identify the correct override record for the registry settings record (HFR).
8	PAT_ID	VARCHAR	No
	The unique ID of the patient associated with this registry record.
9	PAT_DATE	DATETIME	No
	The date of patient encounter linked to the surgery.
10	LOG_ID	VARCHAR	No
	The unique ID of the surgery associated with this registry record.
11	NSQIP_CYCLE_C_NAME	VARCHAR	No
	The category ID for the cycle number assigned to the case. A cycle number is assigned to every eight consecutive days in a calendar year. It is automatically generated based on the operation date. May contain organization-specific values: No Category Entries: Cycle 01 Cycle 02 Cycle 03 Cycle 04 Cycle 05 Cycle 06 Cycle 07 Cycle 08 Cycle 09 Cycle 10 Cycle 11 Cycle 12 Cycle 13 Cycle 14 Cycle 15 Cycle 16 Cycle 17 Cycle 18 Cycle 19 Cycle 20 Cycle 21 Cycle 22 Cycle 23 Cycle 24 Cycle 25 Cycle 26 Cycle 27 Cycle 28 Cycle 29 Cycle 30 Cycle 31 Cycle 32 Cycle 33 Cycle 34 Cycle 35 Cycle 36 Cycle 37 Cycle 38 Cycle 39 Cycle 40 Cycle 41 Cycle 42 Cycle 43 Cycle 44 Cycle 45 Cycle 46
12	NSQIP_IDN	VARCHAR	No
	The unique identifier for the patient in the ACS NSQIP database.
13	NSQIP_LMRN	VARCHAR	No
	The Medical Record Number (MRN) of the patient as assigned by the hospital.
14	NSQIP_DOB_DT	DATETIME	No
	The patient's date of birth.
15	NSQIP_GENDER_C_NAME	VARCHAR	No
	The category ID for the gender of the patient. May contain organization-specific values: No Category Entries: Male Female Non-binary
16	NSQIP_RACE_C_NAME	VARCHAR	No
	The category ID for the race of the patient. Starting with the January 2021 specification updates, discrete race categories are now located in the column NSQIP_RACES.NSQIP_RACES_C. May contain organization-specific values: No Category Entries: White Black or African American American Indian or Alaska Native Native Hawaiian or Other Pacific Islander Asian Unknown / Not Reported Some Other Race
17	NSQIP_HISPANIC_C_NAME	VARCHAR	No
	Indicates whether the patient is of Hispanic or Latino ethnicity. May contain organization-specific values: No Category Entries: No Yes Unknown
18	NSQIP_NAME_FIRST	VARCHAR	No
	The patient's first name.
19	NSQIP_NAME_MI	VARCHAR	No
	The patient's middle initial.
20	NSQIP_NAME_LAST	VARCHAR	No
	The patient's last name.
21	NSQIP_ADDRESS_LINE_1	VARCHAR	No
	Line 1 of the patient's address.
22	NSQIP_ADDRESS_LINE_2	VARCHAR	No
	Line 2 of the patient's address.
23	NSQIP_CITY	VARCHAR	No
	The patient's city.
24	NSQIP_STATE_C_NAME	VARCHAR	No
	The category ID for the state of the patient. May contain organization-specific values: No Category Entries: Alabama Alaska Alberta American Samoa APO/FPO ADDRESS (AA) APO/FPO ADDRESS (AE) APO/FPO ADDRESS (AP) Arizona Arkansas British Columbia California Colorado Connecticut Delaware District of Columbia Federation of Micronesia Florida Georgia Guam Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Manitoba Marshall Islands Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Brunswick New Hampshire New Jersey New Mexico New York Newfoundland North Carolina North Dakota Northern Mariana Islands Northwest Territories Nova Scotia Nunavut Ohio Oklahoma Ontario Oregon Palau Pennsylvania Prince Edward Island Puerto Rico Quebec Rhode Island Saskatchewan South Carolina South Dakota Tennessee Texas Utah Vermont Virgin Islands Virginia Washington West Virginia Wisconsin Wyoming Yukon Territory
25	NSQIP_ZIP	VARCHAR	No
	The patient's ZIP code.
26	NSQIP_COUNTRY_C_NAME	VARCHAR	No
	The category ID for the country of the patient. May contain organization-specific values: No Category Entries: Afghanistan Aland Albania Algeria American Samoa Andorra Angola Anguilla Antarctica Antigua and Barbuda Argentina Armenia Aruba Australia Austria Azerbaijan Bahamas Bahrain Bangladesh Barbados Belarus Belgium Belize Benin Bermuda Bhutan Bolivia Bosnia and Herzegovina Botswana Bouvet Island Brazil British Indian Ocean Territory Brunei Darussalam Bulgaria Burkina Faso Burundi Cambodia Cameroon Canada Cape Verde Cayman Islands Central African Republic Chad Chile China, Peoples Republic of Christmas Island Cocos (Keeling) Islands Colombia Comoros Congo (Brazzaville) Congo, (Kinshasa) Cook Islands Costa Rica Cote D`ivoire Croatia Cuba Cyprus Czech Republic Denmark Djibouti Dominica Dominican Republic Ecuador Egypt El Salvador Equatorial Guinea Eritrea Estonia Ethiopia Falkland Islands Faroe Islands Fiji Finland France French Guiana French Polynesia French Southern and Antartic Lands Gabon Gambia Georgia, Republic of Germany Ghana Gibraltar Greece Greenland Grenada Guadeloupe Guam Guatemala Guinea Guinea-Bissau Guyana Haiti Heard Islands and McDonald Islands Honduras Hong Kong Hungary Iceland India Indonesia Iran Iraq Ireland Israel Italy Jamaica Japan Jordan Kazakhstan Kenya Kiribati Korea, North Korea, South Kuwait Kyrgyzstan Laos Latvia Lebanon Lesotho Liberia Libya Liechtenstein Lithuania Luxembourg Macau North Macedonia Madagascar Malawi Malaysia Maldives Mali Malta Marshall Islands Martinique Mauritania Mauritius Mayotte Mexico Micronesia Moldova Monaco Mongolia Montserrat Morocco Mozambique Myanmar Namibia Nauru Nepal Netherlands Netherlands Antilles New Caledonia New Zealand Nicaragua Niger Nigeria Niue Norfolk Island Northern Mariana Islands Norway Oman Pakistan Palau Palestine Panama Papua New Guinea Paraguay Peru Philippines Pitcairn Islands Poland Portugal Puerto Rico Qatar Reunion Romania Russia Rwanda Saint Helena Saint Kitts and Nevis Saint Lucia Saint Pierre and Miquelon Saint Vincent and The Grenadines Samoa San Marino Sao Tome and Principe Saudi Arabia Senegal Serbia-Montenegro Seychelles Sierra Leone Singapore, Republic of Slovakia Slovenia Solomon Islands Somalia South Africa, Republic of South Georgia and South Sandwich Islands Spain Sri Lanka Sudan Suriname Svalbard and Jan Mayen Islands Eswatini Sweden Switzerland Syria Taiwan Tajikistan Tanzania Thailand Timor-Leste Togo Tokelau Tonga Trinidad and Tobago Tunisia Turkey Turkmenistan Turks and Caicos Islands Tuvalu Uganda Ukraine United Arab Emirates United Kingdom United States Minor Outlying Islands Uruguay Uzbekistan Vanuatu Vatican City Venezuela Vietnam Virgin Islands, British Virgin Islands, US Wallis and Futuna Western Sahara Yemen Zambia Zimbabwe United States
27	NSQIP_COUNTY	VARCHAR	No
	The patient's county.
28	NSQIP_HOME_PHONE	VARCHAR	No
	The patient's home phone number.
29	NSQIP_WORK_PHONE	VARCHAR	No
	The patient's work phone number.
30	NSQIP_CELL_PHONE	VARCHAR	No
	The patient's cell phone number.
31	NSQIP_PREF_LANG_C_NAME	VARCHAR	No
	The category ID for the preferred language of the patient. May contain organization-specific values: No Category Entries: English Spanish
32	NSQIP_PRIN_PROC_PANEL	VARCHAR	No
	The panel number corresponding to the NSQIP principal operative procedure. It is used along with procedure ID from NSQIP_PRIN_PROC_ID to identify the row in OR_LOG_ALL_PROC table corresponding to the NSQIP principal operative procedure.
33	NSQIP_PRIN_PROC_ID	VARCHAR	No
	The unique ID of the procedure record corresponding to the NSQIP principal operative procedure. It is used along with panel number from NSQIP_PRIN_PROC_PANEL to identify the row in OR_LOG_ALL_PROC table corresponding to the NSQIP principal operative procedure.
34	NSQIP_PRIN_PROC_ID_PROC_NAME	VARCHAR	No
	The name of the surgical procedure record.
35	NSQIP_PRIN_PROC_CPT	VARCHAR	No
	The CPT code of the principal NSQIP procedure.
36	NSQIP_PRIN_PROC_NAME	VARCHAR	No
	The name of the principal operative procedure.
37	NSQIP_ADMSN_STATUS_C_NAME	VARCHAR	No
	The category ID for the admission status of the case (inpatient or outpatient). May contain organization-specific values: No Category Entries: Outpatient Inpatient
38	NSQIP_ELECTIVE_C_NAME	VARCHAR	No
	Indicates whether the surgical case is considered an elective case. May contain organization-specific values: No Category Entries: Yes No Unknown
39	NSQIP_ORIGIN_C_NAME	VARCHAR	No
	The category ID for the origin status of the case. It indicates whether the patient was admitted from their home or from another type of facility. May contain organization-specific values: No Category Entries: Admitted directly from home Acute care hospital Nursing home / Chronic care / Intermediate care Transfer from other Outside emergency department Unknown Home/Permanent residence Acute care hospital Other facility
40	NSQIP_ADMSN_DT	DATETIME	No
	The date the patient was admitted to the hospital for the principal operative procedure.
41	NSQIP_OPERATION_DT	DATETIME	No
	The date the patient entered the surgical suite for the principal operative procedure.
42	NSQIP_PRIN_ANES_C_NAME	VARCHAR	No
	The category ID for the principal anesthesia type of the case. May contain organization-specific values: No Category Entries: General Epidural Spinal Regional Local Monitored Anesthesia Care (MAC) / IV Sedation Other Unknown None
43	NSQIP_SPECIALTY_C_NAME	VARCHAR	No
	The category ID for the surgical specialty of the case. May contain organization-specific values: No Category Entries: General Surgery Gynecology Neurosurgery Orthopedics Otolaryngology (ENT) Plastics Cardiac Thoracic Urology Vascular Interventional Radiologist Obstetrics
44	NSQIP_EMERG_CASE_YN	VARCHAR	No
	Indicates whether the surgical case is considered an emergency case. May contain organization-specific values: No Category Entries: Yes No
45	NSQIP_WOUND_CLASS_C_NAME	VARCHAR	No
	The category ID for the wound classification of the surgical wound at the time of principal operative procedure. May contain organization-specific values: No Category Entries: Clean Clean/Contaminated Contaminated Dirty/Infected
46	NSQIP_WOUND_CLOSE_C_NAME	VARCHAR	No
	The category ID for the wound closure associated with the surgical wound at the time of principal operative procedure. May contain organization-specific values: No Category Entries: All layers of incision (deep and superficial) fully closed Only deep layers closed; superficial left open No layers of incision are surgically closed
47	NSQIP_ASA_CLASS_C_NAME	VARCHAR	No
	The category ID for the ASA class associated with the case. May contain organization-specific values: No Category Entries: ASA not assigned ASA 1 - Normal/Healthy ASA 2 - Mild systemic disease ASA 3 - Severe systemic disease ASA 4 - Life threat ASA 5 - Moribund
48	NSQIP_PROC_START_DTTM	DATETIME (UTC)	No
	The time the principal operative procedure began.
49	NSQIP_PROC_FINISH_DTTM	DATETIME (UTC)	No
	The time the principal operative procedure was completed.
50	NSQIP_LABS_ALL_UNKNOWN_YN	VARCHAR	No
	Indicates whether all preop labs are unknown. May contain organization-specific values: No Category Entries: No Yes
51	NSQIP_HEIGHT	NUMERIC	No
	The patient's height.
52	NSQIP_HEIGHT_UNIT_C_NAME	VARCHAR	No
	The category ID for the unit of the height entered in the height column. May contain organization-specific values: No Category Entries: Inches Centimeters
53	NSQIP_HEIGHT_UNKNOWN_YN	VARCHAR	No
	Indicates whether the patient's height is unknown. The category values for this column were already listed for column: NSQIP_LABS_ALL_UNKNOWN_YN
54	NSQIP_WEIGHT	NUMERIC	No
	The patient's weight.
55	NSQIP_WEIGHT_UNIT_C_NAME	VARCHAR	No
	The category ID for the unit of the weight entered in the weight column. May contain organization-specific values: No Category Entries: Pounds Kilograms
56	NSQIP_WEIGHT_UNKNOWN_YN	VARCHAR	No
	Indicates whether the patient's weight is unknown. The category values for this column were already listed for column: NSQIP_LABS_ALL_UNKNOWN_YN
57	NSQIP_DIABETES_C_NAME	VARCHAR	No
	The category ID for the diabetes mellitus variable. It determines whether the patient had diabetes mellitus that required therapy with non-insulin agents or insulin. May contain organization-specific values: No Category Entries: No Non-insulin Insulin
58	NSQIP_SMOKER_YN	VARCHAR	No
	Indicates whether the patient was a smoker within 12 months prior to surgery. The category values for this column were already listed for column: NSQIP_EMERG_CASE_YN
59	NSQIP_DYSPNEA_C_NAME	VARCHAR	No
	The category ID for the dyspnea variable. It determines the usual and typical level of dyspnea. May contain organization-specific values: No Category Entries: No Moderate exertion At rest
60	NSQIP_FHS_C_NAME	VARCHAR	No
	The category ID for the Functional Health Status variable. It determines the best functional status of self-care as demonstrated by the patient prior to the onset of acute illness. May contain organization-specific values: No Category Entries: Independent Partially dependent Totally dependent Unknown
61	NSQIP_VENT_DEP_YN	VARCHAR	No
	Indicates whether the patient required ventilator-assisted respirations within 48 hours prior to the principal operative procedure. The category values for this column were already listed for column: NSQIP_EMERG_CASE_YN
62	NSQIP_COPD_YN	VARCHAR	No
	Indicates whether the patient suffered from Chronic Obstructive Pulmonary Disease (COPD) prior to surgery. The category values for this column were already listed for column: NSQIP_EMERG_CASE_YN
63	NSQIP_ASCITES_YN	VARCHAR	No
	Indicates whether the patient had fluid accumulation in the abodmen due to advanced liver disease or malignancy prior to surgery. The category values for this column were already listed for column: NSQIP_EMERG_CASE_YN
64	NSQIP_CHF_YN	VARCHAR	No
	Indicates whether the patient had newly diagnosed Congestive Heart Failure (CHF) or a diagnosis of chronic CHF prior to surgery. The category values for this column were already listed for column: NSQIP_EMERG_CASE_YN
65	NSQIP_HYPERTENSION_YN	VARCHAR	No
	Indicates whether the patient had hypertension that required medication prior to surgery. The category values for this column were already listed for column: NSQIP_EMERG_CASE_YN
66	NSQIP_ARF_YN	VARCHAR	No
	Indicates whether the patient had renal compromise within 24 hours prior to surgery. The category values for this column were already listed for column: NSQIP_EMERG_CASE_YN
67	NSQIP_DIALYSIS_YN	VARCHAR	No
	Indicates whether the patient required dialysis two weeks prior to surgery. The category values for this column were already listed for column: NSQIP_EMERG_CASE_YN
68	NSQIP_CANCER_YN	VARCHAR	No
	Indicates whether the patient had advanced malignancy reflecting serious physiologic compromise. The category values for this column were already listed for column: NSQIP_EMERG_CASE_YN
69	NSQIP_OPEN_WOUND_YN	VARCHAR	No
	Indicates whether the patient had an open wound prior to surgery. The category values for this column were already listed for column: NSQIP_EMERG_CASE_YN
70	NSQIP_STEROID_USE_YN	VARCHAR	No
	Indicates whether the patient was receiving long-term pharmaceutical immunosuppresants. The category values for this column were already listed for column: NSQIP_EMERG_CASE_YN
71	NSQIP_WEIGHT_LOSS_YN	VARCHAR	No
	Indicates whether the patient had 10% decrease in body weight in the six month interval prior to surgery. The category values for this column were already listed for column: NSQIP_EMERG_CASE_YN
72	NSQIP_BLEEDING_YN	VARCHAR	No
	Indicates whether the patient was at an increased risk for bleeding prior to surgery due to a hematologic disorder or chronic anticoagulation. The category values for this column were already listed for column: NSQIP_EMERG_CASE_YN
73	NSQIP_PREOP_TRANSFUSION_YN	VARCHAR	No
	Indicates whether the patient received a preop blood transfusion. The category values for this column were already listed for column: NSQIP_EMERG_CASE_YN
74	NSQIP_SEPSIS_C_NAME	VARCHAR	No
	The category ID for the sepsis variable. It determines the most significant level of sepsis prior to surgery. May contain organization-specific values: No Category Entries: Sepsis None Septic shock SIRS
75	NSQIP_WCN	VARCHAR	No
	The Web Case Number (WCN) ID of the NSQIP case.
76	NSQIP_FOLLOW_UP_30_DAYS_YN	VARCHAR	No
	Indicates whether the case was followed for the full 30 days. The category values for this column were already listed for column: NSQIP_EMERG_CASE_YN
77	NSQIP_FOLLOW_UP_NUM_DAYS	INTEGER	No
	The number of days the case was followed. It is used only if the case was not followed for full 30 days.
78	NSQIP_NUM_PHONE_ATTEMPTS	INTEGER	No
	The number of phone attempts that were done to follow the case. It is used only if the case was not followed for full 30 days.
79	NSQIP_NUM_LETTER_ATTEMPTS	INTEGER	No
	The number of letter attempts that were done to follow the case. It is used only if the case was not followed for full 30 days.
80	NSQIP_POST_OCCURRENCE_YN	VARCHAR	No
	Indicates whether the postoperative occurrence was present. The category values for this column were already listed for column: NSQIP_EMERG_CASE_YN
81	NSQIP_DISCHG_DT	DATETIME	No
	The acute hospital discharge date.
82	NSQIP_DISCHG_DEST_C_NAME	VARCHAR	No
	The category ID for the discharge destination. May contain organization-specific values: No Category Entries: Skilled care, not home Unskilled facility, not home Facility which was home Home Separate acute care Unknown Rehab Expired Multi-level senior community Hospice Against medical advice (AMA) Home/Permanent residence Acute care hospital Other facility
83	NSQIP_DISCHG_POSTOP_ICD9	VARCHAR	No
	The ICD-9 code associated with the postoperative discharge.
84	NSQIP_DISCHG_STILL_HOSP_YN	VARCHAR	No
	Indicates whether the patient was still in hospital 30 days after surgery. The category values for this column were already listed for column: NSQIP_LABS_ALL_UNKNOWN_YN
85	NSQIP_DISCHG_DEATH_LT_30_YN	VARCHAR	No
	Indicates whether the death occurred during operation or within 30 days of procedure. The category values for this column were already listed for column: NSQIP_EMERG_CASE_YN
86	NSQIP_DISCHG_DEATH_GT_30_YN	VARCHAR	No
	Indicates whether the postoperative death occurred more than 30 days after procedure. The category values for this column were already listed for column: NSQIP_EMERG_CASE_YN
87	NSQIP_DISCHG_DEATH_DT	DATETIME	No
	The date of death.
88	NSQIP_DISCHG_DEATH_UNKWN_YN	VARCHAR	No
	Indicates whether the date of death is unknown. The category values for this column were already listed for column: NSQIP_LABS_ALL_UNKNOWN_YN
89	NSQIP_FST_REOP_YN	VARCHAR	No
	Indicates whether the patient returned to the OR within 30 days after principal procedure for the first reoperation. The category values for this column were already listed for column: NSQIP_EMERG_CASE_YN
90	NSQIP_FST_REOP_DT	DATETIME	No
	The date the patient returned to the OR for the first reoperation.
91	NSQIP_FST_REOP_DT_UNKWN_YN	VARCHAR	No
	Indicates whether the date of the first return to the OR is not known. The category values for this column were already listed for column: NSQIP_LABS_ALL_UNKNOWN_YN
92	NSQIP_FST_REOP_RELATED_C_NAME	VARCHAR	No
	The category ID of the value that indicates whether the first return to the OR was related to principal operative procedure. May contain organization-specific values: No Category Entries: Yes No Unknown
93	NSQIP_SEC_REOP_YN	VARCHAR	No
	Indicates whether the patient returned to the OR within 30 days after principal procedure for the second reoperation. The category values for this column were already listed for column: NSQIP_EMERG_CASE_YN
94	NSQIP_SEC_REOP_DT	DATETIME	No
	The date the patient returned to the OR for the second reoperation.
95	NSQIP_SEC_REOP_DT_UNKWN_YN	VARCHAR	No
	Indicates whether the date of the second return to the OR is not known. The category values for this column were already listed for column: NSQIP_LABS_ALL_UNKNOWN_YN
96	NSQIP_SEC_REOP_RELATED_C_NAME	VARCHAR	No
	The category ID of the value that indicates whether the second return to the OR was related to principal operative procedure. The category values for this column were already listed for column: NSQIP_FST_REOP_RELATED_C_NAME
97	NSQIP_REOP_MORE_THAN_TWO_YN	VARCHAR	No
	Indicates if there were more than two unplanned returns to the OR. The category values for this column were already listed for column: NSQIP_EMERG_CASE_YN
98	NSQIP_DISCHG_POSTOP_ICD10	VARCHAR	No
	The ICD-10 code associated with the postoperative discharge.
99	NSQIP_ENC_NUM	VARCHAR	No
	The encounter number associated with the NSQIP case. It is an additional optional unique tracking number that hospitals can use for NSQIP cases.
100	NSQIP_READMISSION_YN	VARCHAR	No
	Indicates whether the patient was readmitted. 'Y' indicates that the patient was readmitted. 'N' indicates that the patient was not readmitted. The category values for this column were already listed for column: NSQIP_EMERG_CASE_YN
101	NSQIP_DISCHG_TRANS_HLC_YN	VARCHAR	No
	Indicates whether the patient was transferred to a higher level of care. 'Y' indicates that the patient was transferred to a higher level of care. 'N' indicates that the patient was not transferred to a higher level of care. The category values for this column were already listed for column: NSQIP_EMERG_CASE_YN