REFERRAL_2
Description:
The REFERRAL_2 table is a continuation of the REFERRAL table. These 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 referral ID for the referral record.
2 CE_SENT_YN VARCHAR No
Indicates whether this referral was sent using Care Everywhere.
May contain organization-specific values: No
Category Entries:
No
Yes
3 RFL_ATT_PROV_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
4 RFL_CONTACT_NAME VARCHAR No
Free text field that will be populated by the user who creates the referral.
5 RPT_RECEIVED_DATE DATETIME No
Indicates the date that a PCP acknowledged receipt of an internal report regarding a referral.
6 RPT_SENT_DATE DATETIME No
Indicates the date that an internal report regarding a referral is sent to the referring provider.
7 RFL_RECEIVED_DATE DATETIME No
Indicates the date in which the referred to department acknowledged receipt of the referral.
8 AUDIT_REF_TO_NAME VARCHAR No
This item is used to audit data from incoming Care Everywhere referrals. It stores the name of the referred-to provider.
9 AUDIT_DATE VARCHAR No
This item is used to audit data from incoming Care Everywhere referrals. It stores the referred-on date.
10 AUDIT_RFL_TYPE VARCHAR No
This item is used to audit data from incoming Care Everywhere referrals. It stores the original text for the referral type.
11 AUDIT_REQ_VISITS INTEGER No
This item is used to audit data from incoming Care Everywhere referrals. It stores the requested number of visits.
12 AUDIT_AUTH_VISITS INTEGER No
This item is used to audit data from incoming Care Everywhere referrals. It stores the authorized number of visits.
13 AUDIT_START_DATE VARCHAR No
This item is used to audit data from incoming Care Everywhere referrals. It stores the starting date for the referral in HL7 format.
14 AUDIT_END_DATE VARCHAR No
This item is used to audit data from incoming Care Everywhere referrals. It stores the ending date for the referral in HL7 format.
15 AUDIT_RFTO_PROVSPEC VARCHAR No
This item is used to audit data from incoming Care Everywhere referrals. It stores the original text for the referred-to provider specialty.
16 AUDIT_RFNG_PROVSPEC VARCHAR No
This item is used to audit data from incoming Care Everywhere referrals. It stores the original text for the referring provider specialty.
17 AUDIT_RFTO_DEPTSPEC VARCHAR No
This item is used to audit data from incoming Care Everywhere referrals. It stores the original text for the referred-to department specialty.
18 AUDIT_RFNG_DEPTSPEC VARCHAR No
This item is used to audit data from incoming Care Everywhere referrals. It stores the original text for the referring department specialty.
19 OUTST_AMT NUMERIC No
Specifies the outstanding amount.
20 CASE_MGMT_CREATE_ID VARCHAR No
Specifies the case management creation message.
21 CASE_RATE_OVERRIDE INTEGER No
Specifies the case rate override.
22 QNR_HQA_ID VARCHAR No
Questionnaire related data
23 ALT_PYR_SVC_DT DATETIME No
The service date for the alternate payor information. This date is used as the contact date to look up the alternate billing table in the plan master file.
24 GEN_RFL_NUM_IT_1 NUMERIC No
This contains information from generic referral numeric item 1.
25 GEN_RFL_NUM_IT_2 NUMERIC No
This contains information from generic referral numeric item 2.
26 GEN_RFL_NUM_IT_3 NUMERIC No
This contains information from generic referral numeric item 3.
27 GEN_RFL_NUM_IT_4 NUMERIC No
This contains information from generic referral numeric item 4.
28 GEN_RFL_NUM_IT_5 NUMERIC No
This contains information from generic referral numeric item 5.
29 GEN_RFL_NUM_IT_6 NUMERIC No
This contains information from generic referral numeric item 6.
30 GEN_RFL_NUM_IT_7 NUMERIC No
This contains information from generic referral numeric item 7.
31 GEN_RFL_NUM_IT_8 NUMERIC No
This contains information from generic referral numeric item 8.
32 GEN_RFL_NUM_IT_9 NUMERIC No
This contains information from generic referral numeric item 9.
33 GEN_RFL_NUM_IT_10 NUMERIC No
This contains information from generic referral numeric item 10.
34 GEN_RFL_CAT_1_C_NAME VARCHAR No
This contains information from generic referral category item 1.
May contain organization-specific values: Yes
No Entries Defined
35 GEN_RFL_CAT_2_C_NAME VARCHAR No
This contains information from generic referral category item 2.
May contain organization-specific values: Yes
No Entries Defined
36 GEN_RFL_CAT_3_C_NAME VARCHAR No
This contains information from generic referral category item 3.
May contain organization-specific values: Yes
No Entries Defined
37 GEN_RFL_CAT_4_C_NAME VARCHAR No
This contains information from generic referral category item 4.
May contain organization-specific values: Yes
No Entries Defined
38 GEN_RFL_CAT_5_C_NAME VARCHAR No
This contains information from generic referral category item 5.
May contain organization-specific values: Yes
No Entries Defined
39 GEN_RFL_STR_1 VARCHAR No
This contains information from generic referral string item 1.
40 GEN_RFL_STR_2 VARCHAR No
This contains information from generic referral string item 2.
41 GEN_RFL_STR_3 VARCHAR No
This contains information from generic referral string item 3.
42 GEN_RFL_STR_4 VARCHAR No
This contains information from generic referral string item 4.
43 GEN_RFL_STR_5 VARCHAR No
This contains information from generic referral string item 5.
44 GEN_RFL_DATE_1_DT DATETIME No
This contains information from generic referral date item 1.
45 GEN_RFL_DATE_2_DT DATETIME No
This contains information from generic referral date item 2.
46 GEN_RFL_DATE_3_DT DATETIME No
This contains information from generic referral date item 3.
47 GEN_RFL_DATE_4_DT DATETIME No
This contains information from generic referral date item 4.
48 GEN_RFL_DATE_5_DT DATETIME No
This contains information from generic referral date item 5.
49 TRIAGE_DECISION_C_NAME VARCHAR No
The triage decision category ID for the referral.
May contain organization-specific values: No
Category Entries:
Accept
Reject
Redirect
Information Request
50 REJECT_REASON_C_NAME VARCHAR No
UK referral triage information
May contain organization-specific values: Yes
51 TRIAGE_APPT_CHANGE VARCHAR No
The appointment change comments for the referral record.
52 OVRRD_REF_COUNTS INTEGER No
The number of visits approved for this referral, overridden by the user.
53 CALC_SVC_LVL_CNTS INTEGER No
The calculated number of service level authorizations counts, based on the service level authorizations collected.
54 TOC_STATUS_C_NAME VARCHAR No
Indicates the status of the last transfer of care transmission attempt. If the attempt was unsuccessful, the failure reason is stored.
May contain organization-specific values: No
Category Entries:
Success
No patient associated with referral
No destination specified
No profile or not configured to send
Communication generation failed
Not a transfer of care
No sending method defined for recipient
No order encounter associated with referral
Provider address mismatch
Provider address inactive
Patient needs authorization to send
Patient not participating in Care Everywhere
Processing communication
Care Everywhere Referrals not enabled
Communication failed at destination
Referral has expired
55 GEN_RFL_STR_6 VARCHAR No
This contains information from generic referral string item 6.
56 GEN_RFL_STR_7 VARCHAR No
This contains information from generic referral string item 7.
57 GEN_RFL_STR_8 VARCHAR No
This contains information from generic referral string item 8.
58 GEN_RFL_STR_9 VARCHAR No
This contains information from generic referral string item 9.
59 AP_CLAIM_COUNT NUMERIC No
The actual AP claims count for the referral. This number is calculated from the counts table based the Counts Settings in the Referral System Definitions.
60 RFL_DX_ID_DX_NAME VARCHAR No
The name of the diagnosis.
61 RFL_ENC_TYPE_C_NAME VARCHAR No
The expected encounter type for the referral (inpatient or outpatient).
May contain organization-specific values: Yes
Category Entries:
Outpatient
Inpatient