RES_PERFORMING_DEPTS

Description:

Stores the performing departments of all orders in the study to which each recommendation is linked. This table only applies to the following recommendation types (I RES 30): General [52015], Mammo [52011], and Screening Program [52018].

Primary Key

Column Name	Ordinal Position
FINDING_ID	1
LINE	2

Column Information

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