RFL_NOTIF_STATUS
Description:
This table contains information about the status of failed faxes from a referral.

Primary Key
Column Name Ordinal Position
REFERRAL_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 REFERRAL_ID NUMERIC No
The referral ID for the referral record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 NOTIFICATION_ID INTEGER No
Holds the unique ID within a referral for a particular referral notification
4 LAST_UPDATED_DTTM DATETIME (UTC) No
This holds the last instant this particular fax line was updated.
5 ATTEMPTS INTEGER No
The number of times this fax has been submitted
6 STATUS_C_NAME VARCHAR No
Current status of the notification
May contain organization-specific values: No
Category Entries:
Submitted
Printed
Failed
Canceled
Sent Successfully
Sent to Print Job
7 FAILURE_REASON_C_NAME VARCHAR No
Failure reason for the fax
May contain organization-specific values: No
Category Entries:
Failed in print server
No fax number defined for recipient
Failed in PDF generation
No printer defined for PDF generation
No fax device found for current print class
Document Reference Sending Failed
Document Retrieval Failed
8 RECIPIENT_C_NAME VARCHAR No
The recipient of the fax
May contain organization-specific values: No
Category Entries:
Patient
Referred By Provider
Referred To Provider
Referred To Vendor
PCP
Other
Vendor
Provider
Subscriber of Coverage
Payer of Coverage
Referred By Location/POS
Referred To Location/POS
Referring Physician
Pool
Distribution Scheme
CRM Creator
CRM Current Recipients
CRM Task Owners
Admitting Provider
Attending Provider
Treatment Team
Current PCP
Primary Transporter
Secondary Transporter
Transport Manager
Transport Sending Unit
Transport Receiving Unit
MC Coverage PCP
MC Coverage Current PCP
Referred To Department
Referred To Specialty
Care Team
IP Sign In - Sending Unit User
IP Sign In - Receiving Unit User
IP Sign In - Current Unit User
Bed Planning IB Pager - Sending Unit
Bed Planning IB Pager - Receiving Unit
Emergency Contacts
Bed Request Admitting Provider
Bed Request Attending Provider
Premium Billing Account
CC Receiver
Information Requester
Referred By Department
Transfer Center Request Owner
ADT Visit Contacts
Technician
Supervisor
Inspector
Manager
Start Location Unit Pager
End Location Unit Pager
Other Technicians
All Qualified Techs In Sector
Primary Qualified Techs In Sector
Authorized Representative
User Group Referred By Location
User Group Referred To Location
User Group Referred By Provider
User Group Referred To Provider
Operating Provider
Other Provider
Rendering Provider
Supervising Provider
Unified Communications Group - Sending Unit/Location
Unified Communications Group - Receiving Unit/Location
Unified Communications Group - Current Unit/Location
Unified Communications Group - Specific Group
Attached Chat Conversations
Follow-Up Providers
Follow-Up Locations
Trading Partner
Subscribed Payer
Prior Admission Last Attending Provider
Prior Admission Discharge Provider
Prior Admission Treatment Team
Provider Assigned to Bed
Nurse Assigned to Bed
Referred To Subspecialty
Referred For Treatment
Referred For Condition
Appointment Staff
Patient Care Organizations
9 LETTER_ID VARCHAR No
Letter from the original notification event
10 LETTER_ID_SMARTTEXT_NAME VARCHAR No
The name of the SmartText record.
11 PRINT_CLASS_C_NAME VARCHAR No
This holds the original print class used to generate the notification.
May contain organization-specific values: Yes
Category Entries:
Default
Laser Printer
DRAFT PRINTER
High Volume Laser
High Volume Draft
Wide Carriage Draft
Letterhead
Envelope
Labels
Breeze
Ad Hoc Reporting
Rich Format Reports
Plain Format Reports
Courier Service
Report HTML Reports
batch
NFW CMS
nfw UB
RW Report Emailing
*** LAB PRINT CLASSES ***
Lab - Label Printer
Lab - Form Letter Printer
Lab - Worksheet Printer
Lab - Fax Journal
*** AS PRINT CLASSES ***
Staff Daily Schedules
Staff Daily Schedules (RTF)
Transport Notification
ES RTF Letters
ES Appointment Notification
ES Recall Letters
REFERRAL SUMMARY BATCH
ES Plain Text Appt Letters
Referral History
ES Patient Visit Guide
ES Patient Visit Guide Batch
ES Patient Visit Guide MyChart
ES Request Reminder Letter
Fax Provider Feedback
Print Provider Feedback
ES Schedule View
OB Manager Report
*** OR Print Classes ***
Operative Forms
Preference Cards
OR Reports
OR Labels
OR Plain Text Printing
OR RTF Printing
OR RTF Pick List Printing
OR Specimen Labels
OR Specimen Requisition
OR RTF Letters
*** AR PRINT CLASSES ***
AR Encounter Form
AR Draft Form
AR Letters
AR Payment Receipt
AR Batch Scheduler Reports
AR Face Sheet
AR Cash Drawer Closing Report
PB Refund Slip
*** AR BILLING FORMS ***
AR Standard Bill
*** AR CLAIMS ***
AR Claim-CMS
AR Claim-CMS/CRNA
AR Claim-UB
AR Claim-CMS Medicaid
AR Claim-DPA 2211
AR Claim-PDF
Claim Run Report
Remittance Run Report
Reconciliation Run Report
Electronic Claim Image
ESignature Document
*** MC REPORTS ***
Managed Care Reports - all
ID Card
AP Claims Auto Fax Notification
*** MC Outpat Reg Reports ***
MC Same Day New Patients Report
MC New Patient Registration Report
MC Unassociated Visit Report
MC Elapsed Registration Report
MC New/Changed Registration Report
MC Incomplete Registration Report
MC Registration Change Report
MC Premium Billing Invoice
MC Rich Text BLOB PDF File
MC Letter
MC Referral PDF Generation
MC Machine Readable EOP
MC ANSI 835
Reg Reports
Reg Financial Assistance Letter
***EpicCare Items 17000-17999***
MR Health Maintenance Letter
MR Clinical Summary
MR Visit Summary
MR After Visit Summary
MR Charge Reports
MR Menu Clinical Summary
MR Menu Visit Summary
MR Cancel Order Report
MR Results Routing
MR Extra Clinical Summary
MR Same Day Clinical Summary
MR Patient Instructions
MR Pre Visit Summary
MR Checkout AVS
MR Order Completion Report from InBasket
MR Discontinue/Change Medications
Letter Exchange PDF
IP ORDER SESSION REPORT CLASS
IP ORDER REPRINT
IP Print on Discharge
IP ADT Light
IP Incremental Update
MR Batch Summary Reports
MR FAX AVS
MR PRINT AVS
MR TRANS FAX
MR Transcription
MR Encounter Form
MR Result Batch Letters
MR Preview Window
MR Letters
MR ORD TRANSMITTAL RICHTEXT
MR ORD TRANSMITTAL PLAINTEXT
MR Patient Lists
MR Belgian Hub Printing
MR DT Clinical Summary
Dictation Metadata File
*** AP Claims ***
AP Claim-UB
AP Claim-CMS
MWZ Print-O-Matic Danish Style
ARB Print Class
ES Chart Pulls Outguide (Batch)
ES Chart Pulls Outguide (Demand)
ES Visit Label (Batch)
ES Visit Label (Demand)
MR Pull List
Spec Chrt Req
XRay Spec Chrt Req
CT Pull List
CT Outguide
CT Routing Slip
CT PCP Change Report
CT Creation Report
Imaging Pull Slip-B
Imaging Pull Slip-D
Imaging Pull List
CT statistics report
CT Forwarding Outguide
CT Outstanding Chart Report
CT Chart location Report
CT Charts Needed Report
CT Chart Labels
CT RoI Invoice
CT RoI Receipt
CT Overdue Charts Letter
HIM DEF Batch Letters
HIM DEF Batch Pull Lists
HIM LETTERS
HIM DEF Deficiency Slip
HIM HYPERSPACE BATCH PULL LIST
HIM DEF Fax Provider Letter
HIM CT Chart Creation Slip
HIM CT SCR Review-RTF
HIM CT SCR Review-Plain Text
HIM ROI Encounter Printing
HIM ROI Encounter Print (Rich Text)
HIM ROI FAXING
EMRP/HIM SAVE EMR TO FILE
EMRP EXIT RECORDS
HIM DEF PROV LTR EMAIL
(Inactive) HIM Letters
Web Application Rich-Text Reports
ADT RW Transaction Report
RightFax Server
Forward Advantage Fax Server
Biscom Fax Server
XmediusFax Server
ADT Discharge
ADT Transfer Notification
ADT Admit Notification
ADT Face Sheet
ADT Labels
ADT Card Embosser
ADT Mailing Label
ADT R-Complex Report
ADT RW Admission Report
ADT RW Discharge Report
ADT RW Census Report
ADT RW Transfer Report
ADT RW Patient Report
ADT DOWNTIME REPORT
ADT RW Accommodation Code Report
ADT RW Level of Care Report
ADT RW Patient Class Report
ADT RW Hospital Service Report
ADT Component Card Embosser
ADT RW BED REPORT
ADT RW Department Information Report
ADT PLUE Labels
ADT PLUE Packet
ADT RW EVS Bed Status Report
ADT RW EVS Housekeeper Productivity Report
ADT RW EVS Turnaround Time Report
ADT RW EVS Maintenance Cleaning Report
ADT Alternate Transfer Notice
ADT Alternate Discharge Notice
ADT Undo Discharge Notice
ADT Census Inquiry Batch Job
ADT SQL Report
Alternate Transfer Notice
ADT Optio
ADT Encounter Letters
ADT Encounter Report
ADT Copay Receipt
ADT Labels Intermec Version
ADT Discharged Patients
ADT Mother Children
ADT Patient Query Default
ADT Provider Notification
ADT Transfer Notice for Dietary and Pharmacy
ADT Discharge Notice for Dietary and Pharmacy
ADT Undo Discharge Notice for Dietary and Pharmacy
ADT Bed Page
ADT Datastream Output Report
ADT Patient Identity
ADT Integrity Check Report
ADT Census Inquiry
ADT Transport Ticket To Ride
ADT Manager Report
ADT EVS Inspection
PAS Manually Generated Waiting List Letter
PAS Automatically Generated Waiting List Letter
HH Orders
HSPC Bereavement Follow-Up Letter
HSPC Bereavement Follow-Up Label
Home Care Verbal Order Fax
nightly batch
MyChart Covid Vaccination Record Document
MyChart Lab Requisition Document
MyChart Test Results Document
IP After Visit Summary
IP Patient Lists
IP HTML Report
File Export Utility
HB Statement
HB Hospital Account Detail Bill
HB Letters
Enterprise Billing Statement
Enterprise Payment Receipt
Enterprise Hospital Account Detail Bill
HB Payment Receipt
EB Estimate Letter
EB Paperless Rich Text Print
EB Paperless Plain Text Print
Dutch Claim Image
HB Guarantor Detail Bill
Enterprise Guarantor Detail Bill
HB Claim Detail Bill
Enterprise Billing Deposit Reconciliation Acknowledgement
HB Account Maintenance Display
HB Account Summary
HB Charge Errors
CR Compass Comparison Results
Willow
Rx Printer
Rx Label
Rx Paper
Rx Sale Receipt
Rx Fax
ED After Visit Summary
ED Track Board
ED Manager Report
Campaigns Letter Outreach
Lab - Current Workstation Label Printer
Lab - Current Lab Label Printer
Lab - Patient Location Label Printer
Lab - STAT Current Workstation Label Printer
Lab - STAT Current Lab Label Printer
Lab - STAT Patient Location Label Printer
Lab - Result Reprint Printer
Lab - Requisition Form Printer
Lab - Manual Label Reprint Printer
Lab - Report Printer
Lab - Outstanding List Printer
Flash Cards
Control Sheets
Imaging Batch Reports
Imaging Patient Results Letter
Imaging Results Report Auto-Fax
Imaging Results Address Labels
Imaging Film Labels
Imaging External Film Return Address Labels
Imaging Results Report
Imaging Reminder Letters
Imaging Film Auto-print Label
Imaging Subfolder Auto-print Label
Imaging Jacket Auto-print Label
Imaging MRI Screening Form
OB Grease Board
CONVERT HNO TO PDF
Charge Router Charge Tickets
CE COMMUNITY TICKET REPORT
Payer Platform ID Card
Kiosk Email
Kiosk Web Blob Server Storage
Kiosk Receipt
Kiosk Tablet Printing
Social Care - Calculation
Eyecare Lens Rx
Eyecare Cataract Planning
Specialty Plan of Care - Snapshot
Neph Dialysis Calendar
CRM Search
12 NOTE_ID VARCHAR No
The General Use Note (HNO) record that was sent during the letter review process, used to resend the updated letter.
13 FAX_NAME VARCHAR No
Stores the name of the recipient for a fax. This will be used as the recipient name in the event the failed fax is resent.
14 FAX_NUM VARCHAR No
Stores the fax number for a fax. This will be used as the fax number in the event the failed fax is resent.
15 FAILURE_ERR_MSG VARCHAR No
For a failed notification, the error message associated with the failure.
16 NOTIF_DOC_ROI_ID VARCHAR No
The document associated with the original notification.