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 VARCHAR No
The unique ID associated with the provider record for this row.
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 NUMERIC No
The unique ID associated with the location or place of service record for this row. This column is frequently used to link to the CLARITY_POS table.
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.