NSQIP_POST_OCCURRENCE

Description:

The NSQIP_POST_OCCURRENCE table contains postoperative occurrence information for NSQIP registry data for the surgeries that are selected for NSQIP submission. It is used in conjunction with NSQIP_INFO table.

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_TYPE_C_NAME	VARCHAR	No
	The type of registry. 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
3	CHILD_RECORD_NAME	VARCHAR	No
	The name for a child record.
4	CHILD_RECORD_ABBR	VARCHAR	No
	The abbreviated name for a child record.
5	NSQIP_POST_OCCURRENCE_CAT_C_NAME	VARCHAR	No
	The category ID for the type of postoperative occurrence. May contain organization-specific values: No Category Entries: Post-op dialysis Blood transfusion Cardiac arrest requiring CPR Deep incisional SSI Venous thrombosis requiring therapy Myocardial infarction On ventilator > 48 hours Pneumonia Pulmonary embolism Post-op renal insufficiency Stroke/CVA Superficial incisional SSI Sepsis Unplanned intubation Urinary tract infection Wound disruption Organ/Space SSI Septic shock Other (list ICD-9 code) Other (List ICD-10 code) C. diff
6	NSQIP_POST_OCCURRENCE_PATOS_YN	VARCHAR	No
	Indicates whether the postoperative occurrence was present at the time of surgery. May contain organization-specific values: No Category Entries: Yes No
7	NSQIP_POST_OCCURRENCE_TRANS	INTEGER	No
	The number of units of red blood cells, whole blood, autologous blood, and cell-saver products transfused postoperatively within the 72 hours of surgery start time.
8	NSQIP_POST_OCCURRENCE_DATE	DATETIME	No
	The date of postoperative occurrence.
9	NSQIP_POST_OCCURRENCE_ICD9	VARCHAR	No
	The ICD-9 code associated with the postoperative occurrence if the post-op category is Other.
10	NSQIP_POST_OCCURRENCE_ICD10	VARCHAR	No
	The ICD-10 code associated with the postoperative occurrence if the post-op category is Other.
11	NSQIP_CDIFF_TYPE_C_NAME	VARCHAR	No
	The type of C. diff test performed. May contain organization-specific values: No Category Entries: Toxin DNA Other-C. diff Other-non C. diff None Unknown
12	NSQIP_CDIFF_RESULT_C_NAME	VARCHAR	No
	The result of C. diff test. May contain organization-specific values: No Category Entries: Positive Negative
13	NSQIP_CDIFF_TREATMENT_YN	VARCHAR	No
	Indicates whether the patient was given treatment for C. diff. The category values for this column were already listed for column: NSQIP_POST_OCCURRENCE_PATOS_YN
14	NSQIP_CDIFF_DIARRHEA_YN	VARCHAR	No
	Indicates whether the patient with C. diff had diarrhea/loose stools. The category values for this column were already listed for column: NSQIP_POST_OCCURRENCE_PATOS_YN
15	NSQIP_CDIFF_PAT_HAS_DX_YN	VARCHAR	No
	Indicates whether a patient has a C. diff diagnosis. 'Y' indicates that the patient does have a C. diff diagnosis. 'N' or NULL indicates that the patient does not have a C. diff diagnosis. The category values for this column were already listed for column: NSQIP_POST_OCCURRENCE_PATOS_YN
16	NSQIP_CDIFF_POSITIVE_TEST_OTHR	VARCHAR	No
	The user-entered name of other C.diff tests performed that resulted positive for a patient. This column should only be populated if Other [10] is included in the NSQIP_CDIFF_POSITIVE_TEST table for the patient.
17	NSQIP_CDIFF_NEGATIVE_TEST_OTHR	VARCHAR	No
	The user-entered name of other C.diff tests performed that resulted negative for a patient. This column should only be populated if Other [10] is included in the NSQIP_CDIFF_NEGATIVE_TEST table for the patient.
18	RECORD_STATUS_C_NAME	VARCHAR	No
	The record status (hidden, soft-deleted, etc...) category ID for the registry data record. May contain organization-specific values: No Category Entries: Soft Deleted Hidden Hidden and Soft Deleted
19	NSQIP_CREAT_INCREASE_C_NAME	VARCHAR	No
	The category ID corresponding to the most severe level of creatinine increase postoperatively. May contain organization-specific values: No Category Entries: N/A Increase of greater than or equal 0.3 mg/dl within 48 hours Increase to 1.5 to less than 2.0 times baseline within 7 days Increase to 2.0 to less than 3.0 times baseline within 7 days Increase to greater than or equal 3.0 times baseline within 7 days Increase of greater than or equal 0.3 mg/dl to greater than or equal 4.0 mg/dl within 48 hours Increase to greater than or equal 1.5 times baseline to greater than or equal 4.0 mg/dl within 7 days
20	NSQIP_LOW_URINE_OUTPUT_C_NAME	VARCHAR	No
	The category ID corresponding to the lowest level of urine output postoperatively. May contain organization-specific values: No Category Entries: N/A Less than 0.5 ml/kg/h for greater than or equal 6 hours Less than 0.5 ml/kg/h for greater than or equal 12 hours Less than 0.3 ml/kg/h for greater than or equal 24 hours Anuria for greater than or equal 12 hours
21	NSQIP_CDIFF_CONF_YN	VARCHAR	No
	This item stores whether the patient's C. diff Colitis lab has been confirmed. The category values for this column were already listed for column: NSQIP_POST_OCCURRENCE_PATOS_YN