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
Internal Payer Notification
11 | OWNING_INSTANCE_ID | VARCHAR | No |
Stores the owning deployment of this notification history line.
12 | LTR_HX_RECIP_NAME | VARCHAR | No |
Notification address override recipient name.
13 | LTR_HX_CITY | VARCHAR | No |
Stores the recipient's city for this notification history line.
14 | LTR_HX_TAX_STATE_C_NAME | VARCHAR | No |
Stores the recipient's state for this notification history line.
May contain organization-specific values: Yes
15 | LTR_HX_ZIP | VARCHAR | No |
Stores the recipient's ZIP code for this notification history line.
16 | LTR_HX_COUNTY_2_C_NAME | VARCHAR | No |
Stores the recipient's county for this notification history line.
May contain organization-specific values: Yes
17 | LTR_HX_COUNTRY_2_C_NAME | VARCHAR | No |
Stores the recipient's country for this notification history line.
May contain organization-specific values: Yes
18 | LTR_HX_HOUSE_NUMBER | VARCHAR | No |
Stores the recipient's house number for this notification history line.
19 | LTR_HX_DISTRICT_C_NAME | NUMERIC | No |
Stores the recipient's district for this notification history line.
May contain organization-specific values: Yes
20 | LTR_HX_LETTER_REASON_C_NAME | VARCHAR | No |
Stores the letter reason for the notification line.
May contain organization-specific values: Yes