RFL_REF_TO_REGIONS
Description:
This table holds the list of geographical areas for referred to geographical steering in Referral and Order Entry. It will only be populated if the "Use Referred to Geographic Areas" Referral system definition is set to Yes.

Primary Key
Column Name Ordinal Position
REFERRAL_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 REFERRAL_ID NUMERIC No
The unique ID of the referral.
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 REF_TO_AREAS_ID NUMERIC No
The unique ID of the geographical area record that was used for referred to geographical steering for this referral. The stored value will be the first populated value from this list: 1) The referred to department's geographic area item 2) The referred to location/POS 3) The referred to vendor 4) The referred to provider