NSQIP_READMISSION

Description:

The NSQIP_READMISSION table contains readmission 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_READM_WITHIN_30_YN	VARCHAR	No
	Indicates whether there was a readmission within 30 days of principal operative procedure. May contain organization-specific values: No Category Entries: Yes No
6	NSQIP_READM_DT	DATETIME	No
	The readmission date.
7	NSQIP_READM_DT_UNKWN_YN	VARCHAR	No
	Indicates whether the date of readmission is unknown. May contain organization-specific values: No Category Entries: No Yes
8	NSQIP_READM_INFO_SRC_C_NAME	VARCHAR	No
	The category ID for the source of information for readmission. May contain organization-specific values: No Category Entries: Medical record Patient/Family report Other
9	NSQIP_READM_UNPLANNED_YN	VARCHAR	No
	Indicates whether the readmission was unplanned. The category values for this column were already listed for column: NSQIP_READM_WITHIN_30_YN
10	NSQIP_READM_RELATED_YN	VARCHAR	No
	Indicates whether the readmission is related to the principal operative procedure. The category values for this column were already listed for column: NSQIP_READM_WITHIN_30_YN
11	NSQIP_READM_REL_RSN_C_NAME	VARCHAR	No
	The category ID for the primary reason for readmission related to the principal operative procedure. 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 (ICD-10 code) C. diff
12	NSQIP_READM_REL_RSN_ICD9	VARCHAR	No
	The ICD-9 code associated with readmission reason if the readmission is related to the principal operative procedure.
13	NSQIP_READM_REL_RSN_TXT	VARCHAR	No
	The ICD-9 free text comment associated with readmission reason if the readmission is related to the principal operative procedure.
14	NSQIP_READM_UNREL_RSN_C_NAME	VARCHAR	No
	The category ID for the primary reason for readmission unrelated to the principal operative procedure. May contain organization-specific values: No Category Entries: Acute Renal Failure Bleeding Requiring Transfusion Cardiac Arrest Requiring CPR Deep Incisional SSI Vein Thrombosis Requiring Therapy Myocardial Infarction On Ventilator > 48 hours Pneumonia Pulmonary Embolism Progressive Renal Insufficiency 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
15	NSQIP_READM_UNREL_RSN_ICD9	VARCHAR	No
	The ICD-9 code associated with readmission reason if the readmission is unrelated to the principal operative procedure.
16	NSQIP_READM_UNREL_RSN_TXT	VARCHAR	No
	The ICD-9 free text comment associated with readmission reason if the readmission is unrelated to the principal operative procedure.
17	NSQIP_READM_REL_RSN_ICD10	VARCHAR	No
	The ICD-10 code associated with readmission reason if the readmission is related to the principal operative procedure.
18	NSQIP_READM_REL_RSN_ICD10_TXT	VARCHAR	No
	The ICD-10 free text comment associated with readmission reason if the readmission is related to the principal operative procedure.
19	NSQIP_READM_UNREL_RSN_ICD10	VARCHAR	No
	The ICD-10 code associated with readmission reason if the readmission is unrelated to the principal operative procedure.
20	NSQIP_READM_UNREL_RSN_ICD10TXT	VARCHAR	No
	The ICD-10 free text comment associated with readmission reason if the readmission is unrelated to the principal operative procedure.
21	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