NSQIP_FOLLOWUP_PAT_CNCT
Description:
This table contains patient follow-up contact 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_PAT_CONTACT_DATE DATETIME No
The date of the follow-up patient contact.
6 NSQIP_PAT_CONTACT_ACTION_C_NAME VARCHAR No
The action taken for the follow-up patient contact.
May contain organization-specific values: No
Category Entries:
Phone
Letter
Documentation
Fax
Email
Other
7 NSQIP_PAT_CONTACT_RESULT_C_NAME VARCHAR No
The result of the follow-up patient contact.
May contain organization-specific values: No
Category Entries:
No Answer
Left Message
Letter/Email Sent
Letter/Email Received
Talked to Patient
Talked to Family/Caregiver
Incorrect Contact Information
Patient Refused
Other
Family/Caregiver Refused
Other
8 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