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.
15	LOCATION_HAS_FIN_INTEREST_YN	VARCHAR	No
	Records whether the patient's encounter location had a disclosable financial interest in this service provider at the time this service provider was first added to a Continued Care and Services Coordination navigator section. The category values for this column were already listed for column: ECONSULT_CONVERT_YN
16	LOC_PREF_PARTNER_TIER_C_NAME	NUMERIC	No
	The preferred partner type associated with this service provider at the time the service request was created in Continued Care and Services Coordination. May contain organization-specific values: Yes Category Entries: Preferred Partner Hospital Preferred Hospital Partner ACO Affiliated Quality Designated Entity Trusted Partner CMS TEAM Qualified
17	SVC_REQ_DESELECT_RSN_C_NAME	NUMERIC	No
	The last known reason a service request was deselected in CCSC. A user is only prompted to enter a deselection reason for service requests with primary service types (MAG) that have an associated procedure (EAP). May contain organization-specific values: Yes Category Entries: Selecting Different Service Provider Patient Discharge Disposition Changed Service Request was Selected in Error Facility No Longer Able to Provide Care Other (Comment)
18	SERVICE_REQUEST_DESEL_RSN_CMT	VARCHAR	No
	The last known comment for CCSC service request deselection reason of Other (Comment).
19	HIDE_FROM_PAT_MATERIALS_YN	VARCHAR	No
	This column indicates whether the referral should be hidden from patient-facing materials. It does not indicate whether the referral is restricted from clinicians. The category values for this column were already listed for column: ECONSULT_CONVERT_YN
20	HIDE_FROM_PAT_MANUALLY_SET_YN	VARCHAR	No
	This column indicates if the status of the referral being hidden from patient materials was manually changed by a user, rather than set from system defaults. The category values for this column were already listed for column: ECONSULT_CONVERT_YN