This table contains data relating to events exported by the Universal Extractor.
Column |
Primary Key |
Datatype |
Length |
Notes |
---|---|---|---|---|
EventUID Part-key identifying an event that was exported. |
Yes |
IDENTITYREF |
8 |
|
EventTimestamp Part-key identifying an event that was exported. |
Yes |
TIMESTAMP |
8 |
|
ExportTimestamp Time that the event was last exported. |
|
TIMESTAMP |
8 |
This field is updated if the event is re-exported such as, because the audit trail has been extended. |
SuccessTimestamp Time that the event was successfully loaded into the target system. |
|
TIMESTAMP |
8 |
This field is set by acknowledgement messages from the target system. When Data Integrity is not required this will always be set equal to ExportTimestamp. |
Received Flag indicating whether acknowledgement has been received for the event. |
|
BIT |
|
0 – Acknowledgement from the target system is required but has not yet been received. 1 – Acknowledgement has been received or data integrity was not required. |
Committed Flag indicating whether the event was successfully exported. |
|
BIT |
|
0 – Event has not yet been sent to the target system. Events left with this status will be retried in the next run as it indicates that the previous run failed to complete. 1 – Event successfully sent to target system (such as, written to XML file) |
Error Description of error that occurred when attempting to export the event. |
|
VARCHAR |
255 |
Not used currently. |
Copyright © 2014 CA.
All rights reserved.
|
|