WF_AUDIT_TRAILS

Description

Contains audit trail information about a process template.

Columns

Column Name Data Type Size Description
OBJECT_ID nvarchar256 The unique ID of the object.
CATEGORYint4 The category of the item being audited (e.g. process template, process instance, etc). This column can be used to extend AgilePoint to store custom audit information.
PURPOSE nvarchar64 The type of action performed on the process model.
OBJECT_INFO nvarchar1024 The name and version of the process model.
DATE_OCCURRED datetime8 The date the operation occurred on the process model.
PERFORMER nvarchar 64 The domain and username of the user who performed the operation.
DESCRIPTION nvarchar2048 A custom description of the item being audited (e.g. process template, process instance, etc). This column can be used to extend AgilePoint to store custom audit information.
STATUSnvarchar16 The outcome of the operation.

Relationships

Table Name Relationship
WF_PROC_DEFS 1 – n