REFERRAL_NOTIF_HIS

Description:

The REFERRAL_NOTIF_HIS table holds the notification history information associated with the referral records stored in the REFERRAL table.

Primary Key

Column Name	Ordinal Position
REFERRAL_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	REFERRAL_ID	NUMERIC	No
	The unique ID of the referral in database, to which this notification history information is linked.
2	LINE	INTEGER	No
	The line number of the notification history for the referral. For example, if the referral has two notification events, the first will have a line value of 1, while the second will have a line value of 2.
3	LTR_HX_DOC_TYPE_C_NAME	VARCHAR	No
	Stores the document type generated from this notification event. May contain organization-specific values: No Category Entries: Kanta - Standard Referral Kanta - Referral Feedback Kanta - Outsource Service Authorization Kanta - Outsource Service Authorization Annulment Kanta - Standard Referral Annulment Kanta - Referral Feedback Annulment Kanta - Standard Referral Annulment and Deletion Kanta - Referral Feedback Annulment and Deletion
4	LTR_HX_ROI_ID	VARCHAR	No
	Stores the release of information record that the document sent is stored on.
5	LTR_HX_PAYER_ID_PAYOR_NAME	VARCHAR	No
	The name of the payor.
6	LTR_HX_FAX_OVERRIDE	VARCHAR	No
	Stores the fax number we sent this notification to.
7	NOTIF_HX_GRP_IDENT	VARCHAR	No
	A grouper ID shared between multiple rows in the notification history table that relate to the same event.
8	EVENT_ID	VARCHAR	No
	Stores the notification event ID triggered
9	EVENT_ID_EVENT_NAME	VARCHAR	No
	The name of the event.
10	NOTIF_HX_ROUTE_C_NAME	VARCHAR	No
	Stores the Routing Method of the notification event record. May contain organization-specific values: Yes Category Entries: In Basket Fax Mail Phone Call MyChart Network Printer Courier Service Outside Provider Messaging Print Locally EDI Opt Out E-mail FHIR Save to File Electronic Authorization Message Suppress Result Routing Payer Platform Notification
11	OWNING_INSTANCE_ID	VARCHAR	No
	Stores the owning deployment of this notification history line.