ORD_PENDING_NOTIF
Description:
Contains users waiting to be notified about an order.

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 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 RECIPIENT_USER_ID VARCHAR No
EMP ID of a user waiting to be notified about the order.
4 RECIPIENT_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
5 REQ_INST_UTC_DTTM DATETIME (UTC) No
The instant the user started waiting to be notified.