REFERRAL_CROSS_ORG
Description:
This table contains cross-organization referral information.

Primary Key
Column Name Ordinal Position
REFERRAL_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 REFERRAL_ID NUMERIC No
The unique identifier (.1 item) for the referral record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 CROSS_ORG_RFL_STATUS_C_NAME VARCHAR No
Track the status of a cross-organization referral.
May contain organization-specific values: No
Category Entries:
Created
Accepted
Declined
Cancellation Requested
Specialist Visit Completed
Referral Completed
Canceled
4 CROSS_ORG_RFL_ORGANIZATION_ID NUMERIC No
Store the organization for a cross-organization referral.
5 CROSS_ORG_RFL_ORGANIZATION_ID_EXTERNAL_NAME VARCHAR No
Organization's external name used as the display name on forms and user interfaces.
6 CROSS_ORG_RFL_UNIQUE_IDENT VARCHAR No
Store the unique ID of a cross-organization referral.
7 CROSS_ORG_RFL_ASGN_AUTH_OID VARCHAR No
Store the assigning authority OID of a cross-organization referral.
8 CROSS_ORG_RFL_RSN_CNCL_RQST VARCHAR No
The reason a cancellation was requested for this referral.
9 CROSS_ORG_RFL_INST_UPDATE_DTTM DATETIME (UTC) No
Instant the cross-organization status was last updated.
10 CROSS_ORG_RFL_INACTIVE_YN VARCHAR No
Indicates whether this line of cross organization referral information is inactive due to patient unlinking. 'Y' indicates that the information is not currently active. 'N' or NULL indicates that the information is active.
May contain organization-specific values: No
Category Entries:
No
Yes
11 CROSS_ORG_RFL_REASON_DECLINE VARCHAR No
The reason the cross-organization referral was declined.