Previous Topic: Wgn3Stringi18nNext Topic: Wgn3Role


Wgn_UE_Export

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.