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.