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 ANSI 278 Message Sent ANSI 278 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 ANSI 278 Message 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.