REFERRAL_HIST

Description: |
The REFERRAL_HIST table contains information on changes to referrals stored in system.

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 of the change to the referral. For example, if the referral is changed twice, the first change will have a line value of 1, while the second change will have a line value of 2.
3 | CHANGE_DATE | DATETIME | No |
The date of the change to the referral.
4 | CHANGE_TYPE_C_NAME | VARCHAR | No |
The category value indicating the type of referral change.
May contain organization-specific values: Yes
Category Entries:
Create Referral
Accept Referral
Reject Referral
Pend to Self
Pend to Director
Pend to Specified Pool
Pend to Employee
Change ID
Change Pend Reason
Add Procedure
Remove Procedure
Change Order
Change Units Approved
Change Units Requested
Change Denial Reason
Change Visit Info
Change Estimated Bed Days
Change Bed Days Start Date
Change First Day Surgery
Change Coverage
Change Bed Days End Date
Change Coverage Use
Refreshed Coverages
Change Authorized Start Date
Change Authorized Expiration Date
Change IBNR Pay Until Date
Change Expect to Pay
Closed Manually
Closed: IBNR or Visits=0
Auto Expired by Nightly Processing
Reopened Manually
Reopened: IBNR and Visits>0
Change Override Bed Days
Change Converted Bed Days
Change Bed Days Day Type
Changed Case Rate Flag
Delete Bed Days Row
Change Authorization Reason
Set Auto-status
Remove Referral Count
Recalculate Referral Counts
Pended by Nightly Processing
Closed: IBNR=0
Closed: Visits=0
Reopened: IBNR>0
Reopened: Visits>0
Confirmation Expired - Canceled by Nightly Processing
Default Referral Type
Change Referral Type
Canceled Order - Referral Status Changed
Assign Referral
Unassign Referral
Change Status
Change Close Reason
Electronic Authorization Message Sent
Electronic Authorization Message Received
Duplicate Check Set Status
Void Referral
Unvoid Referral
Order Diagnosis Changed
Change Class
Change Admit Date
Change Discharge Date
Change Priority
Change Referred to Provider
Change Referred to Prov Specialty
Change Referred to Department
Change Referred to Dept Specialty
Change Referred to Vendor
Change Referred to Location/POS
Delete Note
Scheduling Status Auto Assign
Change Scheduling Status
Schedule by Date Automatically Set
Change Schedule by Date
Change Reasons
Change Referred by Location
Change Referred by Department
Change Referred by Provider
Change Misc Flags
Change Coded Dx
Change Free Text Dx
Change Free Text Px
Change Authorization Number
Change Authorization Comment
Change Pre-cert Number
Change Coverage Authorization Number
Change Coverage Authorization Comment
Change Coverage Pre-cert Number
Change Guideline Days
Change Claim Alert EOB Code
Add/Edit Referral Message
Outside Update
Sent Referral Message
Change Expiration Review
Add Revenue Code
Remove Revenue Code
Change Revenue Code
Questionnaire Changed
Change Modifier
Change Rqst Units Per Period
Change Rqst Units Period
Change Rqst Periods
Change Appr Units Per Period
Change Appr Units Period
Change Appr Periods
Create Note
Change Adjudication User
Change Adjudication Service Area
Change Adjudication Vendor
Change Adjudication Member Group
Change Adjudication Network Status
Change UBRN
Change Source Type
Change Elective Admission Type
Change Elective Admission Planned Date
Change PAS Priority
Change Suspected Cancer
Change Decision to Refer Date
Change Symptomatic Type
Change Radiotherapy Priority
Change Request to Upgrade to Cancer Pathway
Change Triage Decision
Change Reject Reason
Change Redirect Specialty
Change Redirect Consultant
Change Redirect Site
Change Appointment Comments
Change Medium
Change Administrative Category
Change Cancellation Reason
HAAD Prior Request Message Sent
HAAD Prior Auth Message Received
Authorization Created
Authorization Edited
Authorization Deleted
Updated by Import
Updated by eReferrals Reschedule
Apply Template
Synchronize Group Data
Receive Group Data
Change Referral Patient
Change Group Number
Change Pre-cert Required
Change Pre-cert Date Received
Change Pre-cert Receiving User
Change Transportation Requirement
Change Received Time
Change Primary Referral Diagnosis
Change Specialization Level
Change Encounter Type
Change Referred by Provider Address
Change Referred to Provider Address
Add Triage Comments
Change Procedure Provider
Update Questionnaire Answers
Change Referral in Program
Change Referral in Stream
Change Referral in Acknowledgement Date
Change Referral Duration
Change Replacement Referral
Closed: Claim Remaining = 0
Reopened: Claim Remaining > 0
Canceled Order - Referral Status Not Changed
Change Counting Rule
Change Counting Method
Change Completed Visits
Change Scheduled Visits
Change AP Claims Count
Change Patient Notified Date
Referral Phase
Change Primary Referral Diagnosis Add Codes
Change Diagnosis Add Codes
Change Epicrisis Copy to Provider
Change Epicrisis Copy to Location
Change Referral Out Place
Change Pregnancy Status
Change Procedure Generic Category Item
ANSI 278 Inquiry Message Sent
Change Override Received Date
Change Override Received Time
Change Override Decision Date
Change Override Decision Time
Change Additional Info Request Date
Change Additional Info Request Time
Change Attending Provider
Change Authorization Inquiry Batch Flag
Electronic Attachment Message Sent
Electronic Attachment Received
Use Service-Level Authorization Count in Claim
Remove Service-Level Authorization Count from Claim
Change Additional Info Receipt Date
Change Additional Info Receipt Time
Change Extension Days
Change Reporting Referred To Is Contracted Override
Change Reporting Referred By Is Contracted Override
System Changed Start Date
System Changed Expiration Date
Change Episode Link
Change POS Type
External Provisioning
Archiving Rights
Document Viewing Rights
Viewing Rights Start Date
Viewing Rights End Date
Viewing Rights Selected Service Events
Merged Data Automatically
DaVinci PAS Message Sent
DaVinci PAS Message Received
DaVinci PAS Message Failed to Send
Auto Triage Status Assign
Coverage Requirements Message Sent
Coverage Requirements Message Received
Information Request Remind Date
Information Request Source
Electronic Message Status Update
Financial Commitment Decision ID
Financial Commitment Type
Financial Commitment Start Date
Financial Commitment End Date
Financial Commitment Authorized Amount
Financial Commitment Patient is Recipient
Financial Commitment Benefit Recipient Relation
Financial Commitment Provision Status
Financial Commitment Date Completed
Financial Commitment Products/Services
Financial Commitment Product/Service Approved Count
Financial Commitment Waiting Lists
Financial Commitment Case
Financial Commitment Description
Financial Commitment Internal Message
Financial Commitment Reason for Deletion
Procedure Grid Modified
Change Allow Consultation Upgrade
Clinical Attachment Created
Change SAR
Change TAR
Change Reference ID
Change Reference Type
Change Free Choice
Info Request Other Users
Info Request Other Pools
Conversion or Utility
Change Delay-Until Date
Financial Commitment Product/Service Used Count
Financial Commitment Current Balance
Financial Commitment Free Text Product/Service
Appointment Request Linked
Financial Commitment Free Text Service Provider Name
Financial Commitment Free Text Service Provider Address
Financial Commitment Product/Service Unit Price
Financial Commitment Product/Service Total Price
Triage Unaccept Reason
Appointment Request Canceled
Appointment Request Reinstated
Change Bed Day Status
Change Bed Day Avoidable Reason
Change Bed Day Approved Reason
Change Bed Day Denied Reason
Change Admitting Provider
Change Contact Name
Approved Day Start Date
Approved Day End Date
Denied Start Date
Denied End Date
Avoidable Start Date
Avoidable End Date
Change Expected Discharge Date
Change Concurrent Review Next Review Due
Change Bed Day Pending Reason
Change Bed Day Closed Reason
Change Pre-Cert Status
Change Condition Group
Change Right To Healthcare
Change Result Of Initial Assessment
Change Formality
Change Requesting Authority
Change Basis Condition
Change Basis Situation
Change Case Worker
Change Care Situation
Change Child Service's Role
Change Parental Responsibility
Change Consent Status
Change Seniority Date
Change First Appointment By Date
Change Fax Override Recipient Type
Change Fax Override Number
Change Healthcare Start Due Date
Change Bed Day Request Date/Time
Change Bed Day Decision Date/Time
Updated by Post Mortem Actions
Financial Commitment Initial Treatment Date
Coverage Level Service Type Changed
Assign Home Care Authorization
Unassign Home Care Authorization
Change Bed Day Request Type
Change Bed Day Electronic Request
Change Triage Status
Change Triage Status Reason
Closed: Linked episode marked resolved
Reopened: Linked episode marked active
Change Override Date/Time for Bed Day Additional Information Request
Change Override Date/Time for Bed Day Additional Information Receipt
Change Whether Additional Info Extension Was Taken for Bed Day
Change Number of Manual TAT Extension Days for Bed Day
Change Bed Day Withdrawn Reason
Change Bed Day Dismissed Reason
Change Bed Day No Authorization Required Reason
UM Clinicals Reviewer
UM Clinicals Review Instant
Change Bed Day Claim Submission by Date
Change Expected Admit Date
Linked Initiating Referral
Linked Subsequent Referral
Unlinked Initiating Referral
Unlinked Subsequent Referral
Linked Referral to Treatment Plan
Linked Referral to Waiting List
Removed Referral from Waiting List
In Basket Message Sent
Communication Removed
Unlinked Referral from Treatment Plan
Authorization Approved
Electronic Authorization Message Failed to Send
ANSI 278 Inquiry Message Failed to Send
Procedure Grid Modified
Assign Auth/Cert to Hospital Account
Unassign Auth/Cert from Hospital Account
Assign Auth/Cert to Admission
Unassign Auth/Cert from Admission
External Document Update
Communication Added
UM Turnaround Time Start Ignore Instant
UM Turnaround Time End Ignore Instant
Authorization Status Set to No Auth Required
Authorization Status Set to Pending
Authorization Status Set to Canceled
Authorization Status Set to Denied
Change Referred to Specialty
Change Referred to Subspecialty
Change Referred for Condition
Change Referred for Treatment
5 | CHANGE_USER_ID | VARCHAR | No |
The ID number of the user who made the change to the referral.
6 | CHANGE_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
7 | PREVIOUS_VALUE | VARCHAR | No |
Some of the information on the referral is tracked when it changes. This stores the previous value of an item if it is tracked when it changes.
8 | CHANGE_DATETIME | DATETIME (UTC) | No |
The date and time of the change to the referral.
9 | AUTH_HX_EVENT_NO | VARCHAR | No |
The event no of the authorization history
10 | AUTH_HX_NOTE_ID | VARCHAR | No |
Referral audit trail item to store note Id
11 | CHANGE_LOCAL_DTTM | DATETIME (Attached) | No |
The authorization date and time as an instant in the local time zone
12 | NEW_RFL_STATUS_C_NAME | VARCHAR | No |
If the item being changed is Referral Status (I RFL 50), this item stores the new value for that item.
May contain organization-specific values: Yes
Category Entries:
Authorized
Open
Pending Review
Canceled
Denied
Closed
New Request
Incomplete
13 | NEW_PEND_RSN_C_NAME | VARCHAR | No |
If the item being changed is Reason Pending (I RFL 18003), this item stores the new value for that item.
May contain organization-specific values: Yes
14 | NEW_FIN_PROV_STATUS_C_NAME | VARCHAR | No |
If the item being changed is Finland - Provision Status (I RFL 72124), this item stores the new value for that item.
May contain organization-specific values: Yes
Category Entries:
Draft
Completed
Issued
Patient Declined
Cancelled
15 | NEW_FIN_VALID_END_DATE | DATETIME | No |
If the item being changed is Finland - Validity End Date (I RFL 72115), this item stores the new value for that item.