AUDIT table

AUDIT –This table contains the audit trail values when the Audit Trail is enabled.

Ÿ      ID – This unique ID of the audit entry. (PK)

Ÿ      DATE – The date of the audit entry.

Ÿ      EMPID – The employee ID of the employee making the audit entry.

Ÿ      EMPNAME – The name of the employee making the audit entry.

Ÿ      TYPE – The type of audit for this record: Assignments, User Expense, Session, Workflow, etc.

Ÿ      LINKID – The ID of the item the action was performed on (where applicable).

Ÿ      ACTION – A description of the audit action.

Ÿ      RESERVED – Reserved for future use.