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.