V_REFERRAL_HISTORY_NON_ITEM

Description: |
This view contains audited referral changes not associated with a direct item change on the Referral File (RFL) record.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
REFERRAL_ID | 1 |
LINE | 2 |
VALUE_LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | REFERRAL_ID | NUMERIC | No |
The 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 | HX_USER_ID | VARCHAR | No |
The user tied to the audited action on the referral.
4 | HX_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
5 | VALUE_LINE | INTEGER | No |
The line number of one of the multiple values associated with a specific group of data within this record.
6 | ACTION_UTC_DTTM | DATETIME (UTC) | No |
Store the UTC instant when an action took place.
7 | NON_ITEM_CHANGE_C_NAME | VARCHAR | No |
The non-item change category ID associated with the audit action
May contain organization-specific values: No
Category Entries:
Create Referral
Authorize Referral
Reject Referral
Pend to Self
Pend to Director
Pend to Specified Pool
Pend to Employee
Add Procedure
Change Units Approved
Change Units Requested
Change Visit Info
Change Coverage
Assign Referral to Appointment
Unassign Referral from Appointment
Electronic Authorization Message Sent
Electronic Authorization Message Filing Prevented
Delete Note
In Basket Referral Message Sent
Add Revenue Code
Change Revenue Code
Questionnaire Changed
Create Note
UAE Prior Auth Request Message Sent
UAE Prior Auth Message Received
Authorization Created
Authorization Edited
Authorization Deleted
Synchronize Group Data
Receive Group Data
Change Procedure Provider
Update Questionnaire Answers
Change Completed Visits
Change Scheduled Visits
Change AP Claims Count
ANSI 278 Inquiry Message Sent
Electronic Attachment Message Sent
Electronic Attachment Message Failed to Send
Electronic Attachment Received
Use Service-Level Authorization Count in Claim
Remove Service-Level Authorization Count from Claim
DaVinci PAS Message Sent
DaVinci PAS Message Received
DaVinci PAS Message Failed to Send
Procedure Grid Modified
Communication Added
Assign Auth/Cert to Hospital Account
Unassign Auth/Cert from Hospital Account
Assign Auth/Cert to Admission
Unassign Auth/Cert from Admission
Conversion or Utility
Change Pre-Cert Status
Attached Initiating Referral
Attached Subsequent Referral
Unattached Initiating Referral
Unattached 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 Failed to Send
ANSI 278 Inquiry Message Failed to Send
Trigger pikaXml KAS message
Link Service Decision
Unlink Service Decision
External Document Invalidated
External Document Added
NHS eRS Triage Synced
NHS eRS Retrieved Referral For Review
Authorization Status Set to No Auth Required
Authorization Status Set to Pending
Authorization Status Set to Canceled
Authorization Status Set to Denied
Link Referral to Med Access Order
Link Authorization Referral to Episode
Unlink Authorization Referral from Episode
Associated Attachment Invalidated by Cleanup
8 | HX_TREATMENT_PLAN_ID | NUMERIC | No |
The ID of the treatment plan record associated with the audit action
9 | HX_WAITING_LIST_ID | NUMERIC | No |
The ID of the waiting list record associated with the audit action
10 | HX_EPISODE_ID | NUMERIC | No |
The ID of the pathway record linked to the audit action
11 | HX_HSP_ACCOUNT_ID | NUMERIC | No |
The ID of the hospital account record linked to the audit action
12 | HX_APPT_PAT_ENC_CSN_ID | NUMERIC | No |
The Contact Serial Number (CSN) of the appointment linked to the audit action
13 | HX_COMM_ID | VARCHAR | No |
The ID of the communication record linked to the audit action
14 | HX_AUTH_ID | NUMERIC | No |
The ID of the service level authorization record linked to the audit action
15 | HX_MSG_ID | VARCHAR | No |
The ID of the In Basket message record linked to the audit action
16 | HX_ORDER_ID | NUMERIC | No |
The ID of the order record associated with the audit action
17 | HX_NOTE_ID | VARCHAR | No |
The ID of the note record associated with the audit action
18 | HX_FIN_ASST_TRACKER_ID | NUMERIC | No |
The FNT record that corresponds to the Service Decision-based non-item change in I RFL 16140.
19 | HX_CLAIM_TX_ID | NUMERIC | No |
Stores the Accounts Receivable Transaction (ETR) associated with this audited change
20 | HX_RCV_DOCUMENT_ID | NUMERIC | No |
The received document record that corresponds to the non-item change in referral audit history.