AuditUID

Key used to uniquely identify an entry in an event's audit trail.

Yes

IDENTITYDEF

13

EventUID

Key used to uniquely identify a captured or imported event.

Yes

IDENTITYREF

13

Foreign key: Wgn3Event

EventTimestamp

The time at which the event occurred.

Yes

TIMESTAMP

8

Foreign key: Wgn3Event

IssueUID

Key used to uniquely identify an event issue.

IDENTITYREF

13

A null value means that the entry relates to the entire event; otherwise it must reference a valid issue

NextAuditUID

Reference to the next audit entry

IDENTITYREF

13

Foreign key: Wgn3EventAudit

BulkAudit

Indicates if the audit entry was created from a bulk review.

INTEGER

4

A value of 1 means the entry was created from a bulk review

AuditTimestamp

The time that the audit trail entry was generated.

Yes

TIMESTAMP

8

LoginIDM

Part-key that indicates the user that generated the transaction.

INTEGER

4

Foreign key: WgnUserLogin

LoginID

Part-key that indicates the user that generated the transaction.

INTEGER

4

Foreign key: WgnUserLogin

AuditType

The type of audit trail entry.

Yes

INTEGER

4

Follow the hyperlink for details.

ApplicationID

Identifies the application that triggered the audit trail entry

INTEGER

4

Follow the hyperlink for details.

AuditDetail

The detail of the audit trail entry. Its content is specific to the AuditType.

LONGVARCHAR

For audit trail comments this will contain the comment, and for status changes this indicates the new status value.