PR_EST_NOTIF
Description:
This tables stores the notifications sent for estimate records.

Primary Key
Column Name Ordinal Position
ESTIMATE_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 ESTIMATE_ID NUMERIC No
The unique identifier (.1 item) for the patient estimate 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 NOTIF_DTTM DATETIME (UTC) No
Stores the UTC instant when the notification was sent for this estimate.
4 NOTIF_HX_DESTTYPE_C_NAME VARCHAR No
The type of notification that was sent (e.g. Email/SMS).
May contain organization-specific values: No
Category Entries:
Email
SMS
Push
5 NOTIF_DEST VARCHAR No
The destination (email or phone number) to which an estimate notification was sent.