REFERRAL_3
Description:
The REFERRAL_3 table is a continuation of the REFERRAL_2 which is 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 unique identifier for the referral record.
2 GEN_RFL_STR_10 VARCHAR No
This contains information from generic referral string item 10.
3 GEN_RFL_CAT_11_C_NAME VARCHAR No
This contains information from generic referral category item 11.
May contain organization-specific values: Yes
No Entries Defined
4 GEN_RFL_CAT_12_C_NAME VARCHAR No
This contains information from generic referral category item 12.
May contain organization-specific values: Yes
No Entries Defined
5 GEN_RFL_CAT_13_C_NAME VARCHAR No
This contains information from generic referral category item 13.
May contain organization-specific values: Yes
No Entries Defined
6 GEN_RFL_CAT_14_C_NAME VARCHAR No
This contains information from generic referral category item 14.
May contain organization-specific values: Yes
No Entries Defined
7 GEN_RFL_CAT_15_C_NAME VARCHAR No
This contains information from generic referral category item 15.
May contain organization-specific values: Yes
No Entries Defined
8 REFERRING_DEP_SPC_C_NAME VARCHAR No
Indicates the specialty of the department where the referral is coming from.
May contain organization-specific values: Yes
9 CANCEL_RSN_C_NAME VARCHAR No
Status reason explaining why a referral was canceled.
May contain organization-specific values: Yes
10 PAT_COMM_DATE DATETIME No
The date when the patient's scheduled encounter was communicated to the patient.
11 GEN_RFL_CAT_16_C_NAME VARCHAR No
This contains information from generic referral category item 16.
May contain organization-specific values: Yes
No Entries Defined
12 GEN_RFL_CAT_17_C_NAME VARCHAR No
This contains information from generic referral category item 17.
May contain organization-specific values: Yes
No Entries Defined
13 GEN_RFL_CAT_18_C_NAME VARCHAR No
This contains information from generic referral category item 18.
May contain organization-specific values: Yes
No Entries Defined
14 GEN_RFL_CAT_19_C_NAME VARCHAR No
This contains information from generic referral category item 19.
May contain organization-specific values: Yes
No Entries Defined
15 GEN_RFL_CAT_20_C_NAME VARCHAR No
This contains information from generic referral category item 20.
May contain organization-specific values: Yes
No Entries Defined
16 GEN_RFL_CAT_21_C_NAME VARCHAR No
This contains information from generic referral category item 21.
May contain organization-specific values: Yes
No Entries Defined
17 GEN_RFL_CAT_22_C_NAME VARCHAR No
This contains information from generic referral category item 22.
May contain organization-specific values: Yes
No Entries Defined
18 GEN_RFL_CAT_23_C_NAME VARCHAR No
This contains information from generic referral category item 23.
May contain organization-specific values: Yes
No Entries Defined
19 GEN_RFL_CAT_24_C_NAME VARCHAR No
This contains information from generic referral category item 24.
May contain organization-specific values: Yes
No Entries Defined
20 GEN_RFL_CAT_25_C_NAME VARCHAR No
This contains information from generic referral category item 25.
May contain organization-specific values: Yes
No Entries Defined
21 GEN_RFL_STR_11 VARCHAR No
Referral-level generic string for general use.
22 GEN_RFL_STR_12 VARCHAR No
Referral-level generic string for general use.
23 GEN_RFL_STR_13 VARCHAR No
Referral-level generic string for general use.
24 GEN_RFL_STR_14 VARCHAR No
Referral-level generic string for general use.
25 GEN_RFL_STR_16 VARCHAR No
Referral-level generic string for general use.
26 GEN_RFL_STR_17 VARCHAR No
Referral-level generic string for general use.
27 GEN_RFL_STR_18 VARCHAR No
Referral-level generic string for general use.
28 GEN_RFL_STR_19 VARCHAR No
Referral-level generic string for general use.
29 GEN_RFL_STR_20 VARCHAR No
Referral-level generic string for general use.
30 GEN_RFL_STR_21 VARCHAR No
Referral-level generic string for general use.
31 GEN_RFL_STR_22 VARCHAR No
Referral-level generic string for general use.
32 GEN_RFL_STR_23 VARCHAR No
Referral-level generic string for general use.
33 GEN_RFL_STR_24 VARCHAR No
Referral-level generic string for general use.
34 GEN_RFL_STR_25 VARCHAR No
Referral-level generic string for general use.
35 GEN_RFL_STR_26 VARCHAR No
Referral-level generic string for general use.
36 GEN_RFL_STR_27 VARCHAR No
Referral-level generic string for general use.
37 GEN_RFL_STR_28 VARCHAR No
Referral-level generic string for general use.
38 GEN_RFL_STR_29 VARCHAR No
Referral-level generic string for general use.
39 GEN_RFL_STR_30 VARCHAR No
Referral-level generic string for general use.
40 GEN_RFL_STR_15 VARCHAR No
Referral-level generic string for general use.