REFERRAL_6
Description:
The REFERRAL_6 table is a continuation of the REFERRAL_5 table. The REFERRAL_* tables are the primary tables for referral information stored in the system.

Primary Key
Column Name Ordinal Position
REFERRAL_ID 1

Column Information
Name Type Discontinued?
1 REFERRAL_ID NUMERIC No
The unique identifier (.1 item) for the referral record.
2 RFL_TRIAGE_STATUS_C_NAME VARCHAR No
Indicates the triage status of the referral.
May contain organization-specific values: No
Category Entries:
Complete
In Progress
Not Started
Not Needed
3 ECONSULT_TYPE_C_NAME VARCHAR No
The type of e-Consult this referral represents.
May contain organization-specific values: No
Category Entries:
NHS e-RS Advice and Guidance
4 ECONSULT_CONVERT_YN VARCHAR No
Item representing if this e-Consult can be converted into a regular referral.
May contain organization-specific values: No
Category Entries:
No
Yes
5 CONV_ECON_REFERRAL_ID NUMERIC No
The e-Consult that this referral was converted from.
6 ADVICE_GUIDANCE_UBRN VARCHAR No
The eReferrals unique booking reference number from NHS eReferrals specific to advice and guidance e-Consult workflows.
7 UM_UCN_PAT_ENC_CSN_ID NUMERIC No
The unique contact serial number of the health plan contact on the EPT record that is linked with UM UCN Notes
8 EXPECTED_ADMSN_DATE DATETIME No
The expected admit date documented on the referral bed days navigator section.
9 REF_TO_SVC_LN_ID NUMERIC No
Referred to service line (HCS) on a service request referral.
10 REF_TO_SVC_LN_ID_SVC_LN_NAME VARCHAR No
The name (.2 item) of the service line record.
11 SERVICE_REQUEST_STATUS_C_NAME NUMERIC No
The status of the service request
May contain organization-specific values: Yes
Category Entries:
Accepted
Declined
Pending - No Request Sent
Pending - Request Sent
Removed
Considering
Processing
Selected
12 RECEIVED_DOC_CHECK_UTC_DTTM DATETIME (UTC) No
Stores instant of the last check made on the referral for Care Everywhere document attachments for this given referral.
13 SOURCE_SYSTEM_ID NUMERIC No
The data exchange organization record of the source system that originated or updated the inpatient-only authorization request.
14 SOURCE_SYSTEM_ID_EXTERNAL_NAME VARCHAR No
Organization's external name used as the display name on forms and user interfaces.