ORD_PRFLST_TRK
Description:
Tracking info for orders coming from a preference list or order template. For Beacon, the column ORDER_TEMPLATE_ID is used, which is the unique ID of the order template in the patient's treatment plan used to create the order.

Primary Key
Column Name Ordinal Position
ORDER_ID 1

Column Information
Name Type Discontinued?
1 ORDER_ID NUMERIC No
The unique identifier for the order record.
2 ORDER_TEMPLATE_ID NUMERIC No
The unique ID of the order template (OTP) in the patient's treatment plan that was used to create the order.
3 ORDER_TMPLTE_OTL_I_ORDER_DESC VARCHAR No
Description of the procedure.
4 MOD_FROM_OTL_YN VARCHAR No
Flag whether this order is modified from its order template.
May contain organization-specific values: No
Category Entries:
No
Yes