Data Audit Log Table

The Data Audit Log Table (DataAuditLog_tb) contains audit messages that indicate system activity relating to specific data in the system.

Table 1. Data Audit Log Table field information
Field Name Type Size Use
AuditEntryKEY number (long) 4 Uniquely identifies each audit entry, sequentially incremented.
DataAuditType number (integer) 2 Numeric value that represents a data audit type.
DataAuditKEY string 50 Relates to the key of the table for which the audit is indicating activity. For examle, DocumentKEY for document audits.
SourceID number (long) 4 Source of the message.
ComponentID number (integer) 2 Functional area within the source that is generating the message (such as the ID representing the translator).
MsgID number (long) 4 Specific error generated by the Source/Component. In the range 1 – 65535.
Severity number (integer) 2 Indicates the magnitude of the error.
EventID number (long) 4 Event ID to which the audit message belongs. Used to group audit messages generated by related processing and
EventType number (integer) 2 Type of event:
  • 0 = undefined
  • 1 = system event
  • 2 = automated event (scheduler event)
  • 3 = interactive event (user session)
  • 4 = channel event
EventName string 50 Textual description of the event.
AuditDateTime datetime (for SQL)

DATE (for Oracle)

 varies by DBMS Date and time the audit log entry was created.
UserID string 255 Windows user ID associated with the application requesting the audit log entry.
MachineName string 31 Name of the machine requesting the audit log entry.
Parm1 through Parm10 string 255 Parameter value that the program formatting the audit message selects at run-time.
Restored number (integer) 2 Indicates whether the entry was restored from archived data:
  • 0 = non-restored
  • 1 = restored