ORDER_PENDING
Description:
This table contains information on pending orders.

Primary Key
Column Name Ordinal Position
ORDER_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 ORDER_ID NUMERIC No
The unique identifier for the pended 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 USER_ID VARCHAR No
The unique ID of the user pending the order.
4 USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
5 PENDED_TIME DATETIME (Local) No
The time an order was pended.
6 PENDED_FOR VARCHAR No
The reason an order was pended.
7 RELEASED_USER_ID VARCHAR No
The unique ID of the user releasing a pended medication.
8 RELEASED_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
9 PENDING_COMMENTS VARCHAR No
Order pending comments.
10 PEND_REASON_C_NAME VARCHAR No
Order pending reason.
May contain organization-specific values: Yes
11 SH_ORDR_PROV_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
12 SH_AUTH_PROV_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
13 SH_ORDER_MODE_C_NAME VARCHAR No
The verbal order mode category ID for the signed and held order, indicating the way the order was placed, e.g. telephone with readback.
May contain organization-specific values: Yes
Category Entries:
Verbal
Standard
14 SH_VERB_ORD_COMMENT VARCHAR No
The comment entered by a user when creating a signed and held order.
15 SH_VRB_COMM_PROV_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
16 SH_COSIGN_USER_ID VARCHAR No
The unique identifier of the user responsible for providing a cosignature for the order.
17 SH_COSIGN_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
18 SH_COSIGN_REQ_YN VARCHAR No
Indicates whether this order required a cosignature. 'Y' indicates that the order required a cosignature. 'N' or NULL indicates that the order did not require a cosignature.
May contain organization-specific values: No
Category Entries:
No
Yes
19 SH_VBL_CSN_NO_REQ_N INTEGER No
Indicates whether a rule was used to prevent generating a verbal signature requirement for the order record.
20 SH_COS_REQ_RSN_C_NAME VARCHAR No
The signature requirement creation source category ID for the order, indicating the reason a cosignature is required for this signed and held order.
May contain organization-specific values: No
Category Entries:
Automatically Created
HIM
Create Signature Requirement Utility
Patient Creator Utility
Bulk Orders Utility
Beacon
Inactive User Attached to Ordering Provider
Instant Orders
Cosign Checkbox
Cosign Rule
LQL
Profile Setting 8535 - Admission Orders
Profile Setting 8536 - Code Status Orders
Profile Setting 38800 - RW Bulk Orders
Home Health Code Status Order
Anesthesia Sedation Order
Radiant Change Order LPP
Low Acuity Order
Cadence Decision Tree
Security EC36 - Rx Non-controlled
Security EC37 - Rx Controlled w/o C-II
Security EC90 - OP Procedures
Security EC104 - Rx Schedule II
Security EC235 - IP Non-controlled
Security EC236 - IP Controlled w/o C-II
Security EC237 - IP Schedule II
Security EC238 - IP Procedure
Security EC282 - DC Med