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.