anl_event_delivery_detail_history

Stores historical deliveries details tied to an event as deliveries change over time.

Table 1. anl_event_delivery_detail_history table
Column Description Example
event_delivery_detail_history_id

bigint

The unique event delivery detail history id.

4
event_delivery_id

bigint

The event delivery id.

9624411
delivery_created_at

datetime

The date and time on which the delivery was created.

2017-11-14 08:54:29.753000
delivery_date

datetime

The date on which the delivery was created, if provided.

 
delivery_processing_time

decimal

The amount of time needed to process delivery notification.

180.0000000
delivery_status

varchar

The status of the delivery notification (for example, Pending, Queued, Delivered, Error).

Pending
delivery_status_text

varchar

The delivery notification status text. This is normally used when an error occurred in delivery.

Room expired
created_at

datetime

The system-generated date and time on which this entry was created.

2017-11-14 09:01:46.182000
source_id

bigint

The source id of the appliance providing data.

1
control_id

bigint

The control id, indicating when the record was loaded.

12642