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
21 | SH_COS_SRC_ENC | VARCHAR | No |
The DAT of the patient encounter where a cosign or verbal sign was created for a signed and held order.