PHARMACY_FLAGS
Description:
Pharmacy flags on the order. Flags are used by Ambulatory Pharmacy to mark fill requests as needing additional review. There are various types of flags, and one or more can be added to specific fill request contacts on the order.

Primary Key
Column Name Ordinal Position
ORDER_ID 1
CONTACT_DATE_REAL 2
LINE 3

Column Information
Name Type Discontinued?
1 ORDER_ID NUMERIC No
The unique ID of the order that has pharmacy flags attached to it.
2 CONTACT_DATE_REAL FLOAT No
A unique, internal contact date in decimal format. The integer portion of the number indicates the date of the contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
5 CM_CT_OWNER_ID VARCHAR No
The Community ID (CID) of the instance that owns this contact. This is only populated if you use IntraConnect.
6 PHARMACY_FLAG_ID NUMERIC No
The unique ID of the flag that is attached to this order.
7 PHARMACY_FLAG_ID_RECORD_NAME VARCHAR No
The flag name.
8 INSTANT_ADDED_DTTM DATETIME (UTC) No
The instant when this flag was added to the order.
9 ADDED_BY_USER_ID VARCHAR No
The unique identifier for the user that added the flag to the order.
10 ADDED_BY_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
11 FLAG_BLOCKING_YN VARCHAR No
Indicates if the flag is blocking this order from continuing past a certain point in the workflow. 'Y' indicates that the flag is blocking. 'N' or NULL indicate that the flag is not blocking.
May contain organization-specific values: No
Category Entries:
No
Yes
12 ASSOCIATED_CVG_ID NUMERIC No
The unique identifier for the coverage that is associated with this flag.
13 FREE_TXT_DESC VARCHAR No
A free text description of what the flag indicates.
14 FLAG_COMMENT_ID VARCHAR No
The unique identifier of the notes record that contains the text that the user added to the customer flag.
15 FLAGGING_PHR_ID NUMERIC No
The unique identifier for the pharmacy record that added the flag
16 FLAGGING_PHR_ID_PHARMACY_NAME VARCHAR No
The name of the pharmacy.
17 RX_FLG_ADD_RSN_C_NAME VARCHAR No
The flag added reason category ID for the order.
May contain organization-specific values: Yes
Category Entries:
Copied from Previous Prescription
Partial Fill Converted to Standard Fill
Patient Notification
18 FOLLOW_UP_DATE DATETIME No
The date the flag should be deferred until. For Charging flags, the follow-up date is when the fill should be re-adjudicated.