This table stores data for notifications that need to be processed by Cron tasks. |
notification_queue_KEY | int (4) | NOT NULL | The primary key used for identifying a record in the notification queue. |
notification_type_KEY | tinyint (1) | NOT NULL | The notification type of the record (set when the record is created). |
client_KEY | int (4) | NOT NULL | The client key for the record (set when the record is created). |
notification_status_KEY | tinyint (1) | NOT NULL | The notification status of the record (set to pending when the record is created and later updated by a Cron task). |
details | nvarchar (-1) | | The details of the notification (e.g., threshold amount, may be in xml format; set when the records is created). |
recipients | nvarchar (-1) | NOT NULL | The list of recipients the email should be sent to (set by the Cron task via database lookup). |
sender | nvarchar (600) | NOT NULL | The from address of the email (set by the Cron task). |
enqueued_time_utc | datetime (8, 3) | NOT NULL | The date on which the notification was created and added to the table. |
sent_time_utc | datetime (8, 3) | | Indicates the time the email was sent. This is saved for audit purposes. |