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
ACC-NCDR AFib Ablation Follow-Up
UNOS Configuration
Vermont Oxford Network
Quality Measure - Individual
Quality Measure - Patient Details
Generic Attribution
Generic Attribution - External ID Bundle
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
Regulatory Reporting External ID Bundle 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
SRTR Kidney Pre-Transplant Data
SRTR Liver Pre-Transplant Data
SART CORS
SART Configuration
ACS NSQIP
THL Implant
Surgical Care Improvement Project
Hoitotahto
Elinluovutustahto
NHSE Admin Pathway Submission - Diagnostic - Current
NHSE Admin Pathway Submission - Diagnostic - Weekly
NHSE Admin Pathway Submission - Diagnostic - Monthly
NHSE Admin Pathway Submission - RTT - Current
NHSE Admin Pathway Submission - RTT - Weekly
NHSE Admin Pathway Submission - RTT - Monthly
NHSE Diagnostic Activity Submission
NHSE Diagnostic Planned Waiting Lists
NHSE Admin Pathway Submission - Cancer RTT - Current
NHSE Admin Pathway Submission - Cancer RTT - Weekly
NHSE Admin Pathway Submission - Cancer RTT - Monthly
NHSE Admin Pathway Submission - Cancer Treatment - Current
NHSE Admin Pathway Submission - Cancer Treatment - Weekly
NHSE Admin Pathway Submission - Cancer Treatment - Monthly
NHSE Outpatient Activity
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
CA-17 Duty Status Report
CA-20 Attending Physician's Report
MCSA-5870
Federal MCSA-5871
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
IPFQR Abstraction Registry
COVID-19 PUI Case Report
Building Blocks Registry
Certificate of Death
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
Quality Observation
SEP-1 Abstraction
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 (OPA Trigger)
Syndromic Surveillance Syndrome
GIQuIC-Colonoscopy
Analytics Registry
BH IPFQR Abstraction Details
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
Intersex
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
Hispanic or Latino
Middle Eastern or North African
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