OPSDailyNotification
Name: OPS Daily Notification
Type: Application
Modules: OPS-Dispatch
Description: Contains notifications that were sent out to employees.
| Field | Documentation |
|---|---|
| EmployeeId | Employee identifier from Employees.EmployeeId. References the associated employee. |
| LDate | Date the notification was created. |
| NotificationTypeAbbr | Description of the notification (e.g., StopBasedAlerts). |
| DeliveryMethod | Method by which the notification was delivered ('Email', 'SMS' or 'Voice'). |
| DeliveryDestination | Phone number or email to which the notification was sent. |
| NotificationId | Notification identifier from NotificationWaitingArea.NotificationId. References the associated notification. |
| Status | Status of the notification (0 = Dormant, 1 = Sending, 2 = Sent, 3 = Failed, 4 = Expired). |
| Priority | Priority of delivery method (1 = Delivery method was the primary option, 2 = Delivery method was the secondary/alternative option). |
| Abbreviation | Abbreviated name of the notification. |
| Sequence | Priority number used for ordering data query records. |