REFERRAL_ORG_FILTER_SA

Description:

This table holds a list of authorized service areas, business segments and the patient associated with each referral. This table is used with Organizational Filtering. An organization will have access to a referral if they are authorized for at least one of the referral's associated service areas/business segments or if they are authorized for the referral's associated patient.

Primary Key

Column Name	Ordinal Position
REFERRAL_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	REFERRAL_ID	NUMERIC	No
	The unique identifier for the referral record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple service areas and business segments can be associated with a referral.
3	AUTH_SA_OR_BUS_SEG_ID	NUMERIC	No
	The authorized service areas and business segments. This is only populated when Tapestry business segmentation is on. When it is, this column is used to determine which organizations are authorized to view the referral.