APPT_REQ_RELEVANT_DEPTS

Description:

This table contains departments relevant to appointment requests. It includes currently and previously responsible departments, visit departments, the creation department, and the current referred-to department in the linked referral.

Primary Key

Column Name	Ordinal Position
REQUEST_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	REQUEST_ID	NUMERIC	No
	The unique identifier (.1 item) for the order 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	RELEVANT_DEPARTMENT_ID_EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.