REFERRAL_APT
Description:
This table contains information about referral appointments.

Primary Key
Column Name Ordinal Position
REFERRAL_ID 1
LINE_COUNT 2

Column Information
Name Type Discontinued?
1 REFERRAL_ID NUMERIC No
The referral ID for the referral record.
2 LINE_COUNT INTEGER No
A line number that is used to group information about contacts that have counted towards the referral.
3 SERVICE_DATE DATETIME No
The date of the service (date of the appointment, claim, charge, or admission date) that is associated with the referral
4 SERVICE_TYPE_C_NAME VARCHAR No
The type of service that has been counted as a contact toward the total of completed contacts for this referral.
May contain organization-specific values: No
Category Entries:
Override
Admission
Visit
Claim
Charge
Home Health Intake
Surgery
Home Infusion
Lab Requisition
5 CHARGE_ID NUMERIC No
The ID number of the charge, if the source is “Charge.”
6 CLAIM_ID NUMERIC No
The ID number of the AP Claim, if the source is “Claim”
7 SERIAL_NUMBER NUMERIC No
The ID number of the contact, if the source is either "Visit" or "Admission"
8 USER_ID VARCHAR No
The ID number of the user who performed an override of the counting/contact information, if the source of the contact is "User Override"
9 USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
10 REASON VARCHAR No
The reason for the user override, if the source of the contact was "User Override"
11 TABLE_COUNT NUMERIC No
The number of completed contacts that have been counted for this source.
12 EXT_SVC_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.
13 EXT_SVC_TIME DATETIME (Local) No
The time associated with the external appointment that was added to the referral.
14 EXT_SVC_POS_ID_LOC_NAME VARCHAR No
The name of the revenue location.
15 EXT_APPT_STATUS_C_NAME VARCHAR No
This column contains the appointment status for external appointments.
May contain organization-specific values: Yes
Category Entries:
Scheduled
Completed
Canceled
No Show
Left without seen
Arrived
16 EXT_APPT_UNIQ_ID VARCHAR No
This column contains the unique ID for external appointments.
17 EXT_SVC_UTC_DTTM DATETIME (UTC) No
This column contains the timestamp when the service is performed in UTC format.
18 EXT_SVC_DTTM DATETIME (Attached) No
This column contains the external service date and time as an instant in the local time zone.