ORD_AUD_ATTACHED_PROTCL
Description:
This table contains audit information about the list of protocols which have been assigned to the imaging order.

Primary Key
Column Name Ordinal Position
ORDER_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 ORDER_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 PROTOCOL_EXTERNAL_VALUES VARCHAR No
Audit of the list of protocols (external values) which have been assigned to the imaging order. The values are delimited by "^". The source item is located at PROTOCOL_INFO.ASGN_PROTOCOL_ID. This column shows the translated external value as of when the column was last extracted.
4 PROTOCOL_LQF_IDS VARCHAR No
Audit of the list of protocols (IDs) which have been assigned to the imaging order. The values are delimited by "^". The source item is located at PROTOCOL_INFO.ASGN_PROTOCOL_ID.