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.