Database Schema Tables / Engage Dimension and Fact Tables |
Stores historical deliveries details tied to an event as deliveries change over time.
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 |