REFERRAL
Description:
The REFERRAL table is the primary table for referral information stored in system.

Primary Key
Column Name Ordinal Position
REFERRAL_ID 1

Column Information
Name Type Discontinued?
1 REFERRAL_ID NUMERIC No
The unique ID of the referral in database. This is the primary key for the REFERRAL table.
2 EXTERNAL_ID_NUM VARCHAR No
The external identification number used on the referral.
3 PAT_ID VARCHAR No
The ID of the patient associated with the referral.
4 PCP_PROV_ID VARCHAR No
The unique ID of the patient's primary care provider at the time the referral was created.
5 ENTRY_DATE DATETIME No
The date the referral was entered.
6 RFL_STATUS_C_NAME VARCHAR No
The category value representing the status of the referral (I.e. authorized, open, pending, etc.).
May contain organization-specific values: Yes
Category Entries:
Authorized
Open
Pending Review
Canceled
Denied
Closed
New Request
Incomplete
7 REFERRING_PROV_ID VARCHAR No
The unique ID of the referral source (REF) record of the provider who made the referral. This column is frequently used to link to the REFERRAL_SOURCE table. The actual provider (SER) ID can be found in column REF_PROVIDER_ID of table REFERRAL_SOURCE.
8 REFERRING_PROV_ID_REFERRING_PROV_NAM VARCHAR No
The name of the referral source.
9 VENDOR_ID VARCHAR No
The ID number of the vendor associated with the referral.
10 VENDOR_ID_VENDOR_NAME VARCHAR No
The name of the vendor.
11 REFERRAL_PROV_ID VARCHAR No
The unique ID of the provider (SER) being referred to. This column is frequently used to link to the CLARITY_SER table.
12 PROV_SPEC_C_NAME VARCHAR No
The category value indicating the provider specialty being referred to.
May contain organization-specific values: Yes
13 RFL_TYPE_C_NAME VARCHAR No
The category value indicating the type of referral.
May contain organization-specific values: Yes
14 RSN_FOR_RFL_C_NAME VARCHAR No
The category value indicating the main (first) reason for the referral. Since multiple reasons can be listed, use table REFERRAL_REASONS to view all of them.
May contain organization-specific values: Yes
15 RFL_CLASS_C_NAME VARCHAR No
The category value indicating the class of the referral.
May contain organization-specific values: No
Category Entries:
Internal
Incoming
Outgoing
16 AUTH_VIS_PERIOD INTEGER No
The number of authorized visits in each visit period.
17 AUTH_PERIOD_TYPE_C_NAME VARCHAR No
The category value indicating the type of period for authorized visits - i.e. hour, day, week, month, year.
May contain organization-specific values: No
Category Entries:
Hour
Day
Week
Month
Year
18 AUTH_NUM_PERIODS INTEGER No
The number of periods authorized for this referral.
19 AUTH_NUM_OF_VISITS NUMERIC No
The number of visits authorized for this referral.
20 ADMISSION_DATE DATETIME No
The admission date associated with the referral.
21 DISCHARGE_DATE DATETIME No
The discharge date associated with the referral.
22 ESTIMATED_DAYS INTEGER No
The authorized length of stay if the patient is being admitted.
23 START_DATE DATETIME No
The start date of the referral.
24 EXP_DATE DATETIME No
The expiration date of the referral.
25 PEND_TO VARCHAR No
The person or pool to whom an In Basket message should be sent about this referral.
26 PEND_RSN_C_NAME VARCHAR No
For pended referrals, the category value indicating the reason for pending.
May contain organization-specific values: Yes
27 DENY_RSN_C_NAME VARCHAR No
For denied referrals, the category value indicating the reason for denial.
May contain organization-specific values: Yes
28 SERV_AREA_ID NUMERIC No
The ID number of the service area associated with the referral.
29 COVERAGE_ID NUMERIC No
The unique ID of the coverage associated with the referral.
30 NUM_PROC NUMERIC No
The number of procedures associated with the referral.
31 SVC_DATE_REAL FLOAT No
If available, this column is populated by the authorized start date (I RFL 85). If not, it is populated by the expiration date on the referral (I RFL 90). If neither of these are available, the column will be empty. The date in this column is based on days since December 31, 1840.
32 CARRIER_ID VARCHAR No
The ID number of the carrier associated with the referral.
33 CARRIER_ID_CARRIER_NAME VARCHAR No
The name of the carrier record.
34 PAYOR_ID NUMERIC No
The ID number of the payor associated with the referral.
35 PLAN_ID NUMERIC No
The ID number of the plan associated with the referral.
36 SERV_DATE DATETIME No
This column is populated by the authorized start date (I RFL 85) if available. If not, it is populated by the expiration date on the referral (I RFL 90). If neither of these are available, the column will be empty. The date in this column is in MM/DD/YYYY format.
37 RETRO_FLAG_YN VARCHAR No
The category value used to mark a referral as being "Retro" entered.
May contain organization-specific values: No
Category Entries:
Yes
No
38 IBNR NUMERIC No
The "Incurred but not reported" amount associated with this referral.
39 AUTO_APPROVED_DATE DATETIME No
The date on which the referral was approved automatically by the system.
40 AUTH_RSN_C_NAME VARCHAR No
The category value indicating the authorization reason associated with the referral.
May contain organization-specific values: Yes
41 REFD_BY_LOC_POS_ID NUMERIC No
The ID number of the place of service the referral was referred from.
42 REFD_TO_LOC_POS_ID NUMERIC No
The ID number of the place of service the referral was referred to.
43 REFD_TO_DEPT_ID NUMERIC No
The ID number of the department the referral was referred to.
44 REFD_TO_SPEC_C_NAME VARCHAR No
The category value indicating the specialty the department was referred to.
May contain organization-specific values: Yes
45 PRIORITY_C_NAME VARCHAR No
The category value indicating the priority of the referral.
May contain organization-specific values: Yes
Category Entries:
Routine
Urgent
Emergency
Elective
Two Week Wait
See Details
46 TOTAL_PRICE NUMERIC No
The total cost of the procedures authorized under the referral.
47 TOTAL_PAYABLE NUMERIC No
The portion of the total price for which your facility is responsible.
48 PATIENT_AMOUNT NUMERIC No
The total patient liability, under the parameters of the primary coverage used, for the procedures authorized under the referral.
49 EXPECT_TO_PAY NUMERIC No
The total amount you expect your facility will pay for the procedures authorized under the referral. This amount entered by you overrides the total payable amount for the purpose of calculating IBNR.
50 IBNR_PAY_UNTIL_DT DATETIME No
The date up to which your facility will pay claims for the procedures approved on this referral.
51 CASE_RATE_YN VARCHAR No
The category value indicating whether this referral involves services that are reimbursed at a specific case rate.
May contain organization-specific values: No
Category Entries:
Yes
No
52 PRIM_LOC_ID NUMERIC No
The unique ID of the member's primary location at the time the referral was entered.
53 MED_TYPE_C_NAME VARCHAR No
The category value indicating what type of confirmation it is - acute, chronic or PAT.
May contain organization-specific values: No
Category Entries:
Acute
Chronic
PAT
54 ACUTE_AMOUNT NUMERIC No
The amount of the confirmation if the confirmation is acute.
55 CHRONIC_AMOUNT NUMERIC No
The amount of the confirmation if the confirmation is chronic.
56 PAT_AMOUNT NUMERIC No
The amount of the confirmation if the confirmation is an acute medication that was suggested by the pharmacist or over-the-counter medication.
57 RFL_LOB_ID VARCHAR No
ID of the Line of Business (LOB) assigned to the referral.
58 RFL_LOB_ID_LOB_NAME VARCHAR No
The name of the line of business record.
59 ACTUAL_NUM_VISITS NUMERIC No
The actual number of completed visits for this referral.
60 SCHED_NUM_VISITS NUMERIC No
The number of visits scheduled for this referral.
61 REQUEST_NUM_VISITS NUMERIC No
The number of visits requested for this referral.
62 GUIDELINE_DAYS NUMERIC No
Guideline days for this referral.
63 OVRD_ADMIT_DATE DATETIME No
Override admit date for this referral.
64 OVRD_DISCHARGE_DT DATETIME No
Override discharge date for this referral.
65 DISP_VAL_C_NAME VARCHAR No
Whether the referral was accepted ("appointed") or refused ("denied") by the referred-to provider, department or facility.
May contain organization-specific values: No
Category Entries:
Appointed
Denied
66 DISP_RSN_C_NAME VARCHAR No
The reason that a referral's disposition has a status of "denied."
May contain organization-specific values: Yes
Category Entries:
Forwarded to External
Forwarded to Internal
67 DISP_EAF_ID NUMERIC No
The unique id of the facility to which the referral was forwarded.
68 REFD_BY_DEPT_ID NUMERIC No
The ID number of the department the referral was referred by.
69 CLOSE_RSN_C_NAME VARCHAR No
For closed referrals, the category value indicating the reason for closing.
May contain organization-specific values: Yes
70 SCHED_STATUS_C_NAME VARCHAR No
Scheduling status of the referral to keep track of internally schedulable referrals. For category list use ZC_SCHED_STATUS.
May contain organization-specific values: Yes
Category Entries:
Do not change
71 SCHED_BY_DATE DATETIME No
Indicates deadline to schedule a referral.
72 PREAUTH_REQ_C_NAME VARCHAR No
For referrals created from an order, indicates if a preauthorization number must be collected before scheduling.
May contain organization-specific values: No
Category Entries:
Prior Authorization Number Required
Prior Authorization Number Collected
Prior Authorization Number Not Collected
Prior Authorization Number Processed
73 NOT_COLLCTD_RSN_C_NAME VARCHAR No
Reason indicating why the preauth number will not be collected for this referral.
May contain organization-specific values: Yes
74 PROCESSED_RSN_C_NAME VARCHAR No
Reason indicating why the preauth number is marked as processed for this referral.
May contain organization-specific values: Yes
75 PREAUTH_CHG_EMP_ID VARCHAR No
The unique ID of the user who last changed the preauthorization data.
76 PREAUTH_CHG_EMP_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
77 PREAUTH_CHNGD_DTTM DATETIME (Local) No
Date/time stamp for last time the preauthorization data was changed.
78 AUTH_NUM VARCHAR No
Authorization number.
79 PRE_CERT_NUM VARCHAR No
Pre-certification number.
80 NON_PREF_PROV_RSN_C_NAME VARCHAR No
Stores the reason why a non preferred level provider was chosen.
May contain organization-specific values: Yes
81 EXT_REF_DATE DATETIME No
This is the external referring date.
82 EOW_ID VARCHAR No
The unique EOW ID associated with the referral.
83 REQ_VIS_PER_PERIOD INTEGER No
The requested visits per period on the referral.
84 REQ_PERIOD_TYPE_C_NAME VARCHAR No
The requested period type on the referral.
The category values for this column were already listed for column: AUTH_PERIOD_TYPE_C_NAME
85 REQ_NUM_OF_PERIODS INTEGER No
The requested number of periods on the referral.
86 REF_TO_PROV_ADDR_ID VARCHAR No
This stores the address ID of the referred to provider. The format is as follows: ProvID-AddressID. AddressID is the line number of the multiple response address items in the SER masterfile. To use this column, join to CLARITY_SER_ADDR on REFERRAL.REF_TO_PROV_ADDR_ID = CLARITY_SER_ADDR.ADDR_UNIQUE_ID. If you use IntraConnect, also join on REFERRAL.REFERRAL_PROV_ID = CLARITY_SER_ADDR.PROV_ID.
87 DECISION_DATE DATETIME No
Date on which the referral's current status was assigned.
88 NUM_CLMS_EXPECTED INTEGER No
Number of claims expected to be filed on this referral.
89 RFL_STATCHG_RSN_C_NAME VARCHAR No
The reason category number describing why the referral status was changed.
May contain organization-specific values: Yes
Category Entries:
Canceled Order
TPL Created
Order Added
Order Modified
Order Deleted
Build Change
Coverage Change
Treatment Department Change
Diagnosis Change
Create AUTs for new coverage
Day/Cycle Copied
90 TOTAL_EST_DAYS NUMERIC No
Total estimated days for the referral.
91 TOTAL_OVERRIDE_DAYS NUMERIC No
The total number of override days on the referral.
92 TOTAL_CONVTD_DAYS NUMERIC No
The total number of converted days on the referral.
93 AMT_CLMS_ADJUDICTD NUMERIC No
The amount of claims adjudicated.
94 AMT_CLMS_PAID NUMERIC No
The amount of claims paid.
95 ADJ_VENDOR_ID VARCHAR No
The adjudication vendor.
96 ADJ_VENDOR_ID_VENDOR_NAME VARCHAR No
The name of the vendor.
97 ADJ_MEMBER_GROUP_ID VARCHAR No
Adjudication member group.
98 ADJ_NET_STATUS_C_NAME VARCHAR No
Adjudication network status.
May contain organization-specific values: Yes
Category Entries:
In Network
Out of Network
N/A
99 NO_CLAIMS_PAID NUMERIC No
The number of claims paid on the claim.
100 ADJUD_SERV_AREA_ID NUMERIC No
Service area used in referral pricing and adjudication.