WF_AUDIT_TRAILS

CATEGORY

Function:

The category of the process model being audited. This column can be used to extend AgilePoint to store custom audit information.

Values:

• 0 - ProcessDefinition. Audit for process model related changes.
• 1 - ProcessInstance. Audit for process instance related changes.
• 2 - ActivityInstance. Audit for activity instance related changes.
• 3 - ManualWorkItem. Audit for forms related changes.
• 4 - ManualWorkItem. Audit for forms related changes.
• 5 - CustomAttributes. Audit for schema mapper related changes.
• 6 - Application. Audit for app related changes.
• 7 - FloatingUserAccess. Audit for shared user related changes.
• 8 - AppSettings. Audit for app settings related changes.
• 9 - AnonymousAccessSettings. Audit for anonymous access settings related changes.
• 10 - SecureKeyCredential. Audit for secured key credentials related changes.
• 11 - AgilePart. Audit for system activities related changes.
• 12 - AgileWork. Audit for human task activities related changes.
• 13 - AgileConnector. Audit for AgileConnector related changes.
• 14 - AgileExtender. Audit for AgileExtender related changes.
• 16 - Events. Audit for events related changes.
• 17 - DataEntity. Audit for entities in Data Entities related changes.
• 18 - Roles. Audit for roles related changes.
• 19 - Groups. Audit for groups related changes.
• 20 - ApplicationPermissions. Audit for app permission related changes.
• 21 - PageBuilder. Audit for Page Builder related changes.
• 22 - Package. Audit for packages related changes.
• 23 - Users. Audit for users related changes.
• 24 - Configuration. Audit for system configuration related changes.

Data Type:

Int

Size:

4

Can Be Null:

No

Primary Key:

No

Foreign Key:

No

DATE_OCCURRED

Function:

The date the operation occurred on the process.

Data Type:

datetime

Size:

8

Can Be Null:

No

Primary Key:

No

Foreign Key:

No

DETAILED_DESCRIPTION

Function:

A detailed description of the operation performed on the item being audited — for example, a process model or process instance.

Data Type:

ntext

Size:

1073741823

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

DESCRIPTION

Function:

A custom description for the process model being audited. This column can be used to extend AgilePoint to store custom audit information.

Data Type:

nvarchar

Size:

2048

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

OBJECT_ID

Function:

The unique ID of the object.

Data Type:

nvarchar

Size:

256

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

OBJECT_INFO

Function:

The name and version of the process model.

Data Type:

nvarchar

Size:

1024

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

PERFORMER

Function:

The domain and user name of the user who performed the operation.

Data Type:

nvarchar

Size:

256

Can Be Null:

No

Primary Key:

No

Foreign Key:

No

PURPOSE

Function:

The type of action performed on the process model.

Values:

• Create Role - Creates a role.
• Update Role - Updates a role.
• Grant Permission to Role - Assigns access rights to the role.
• Create Entity MetaData - Creates an entity metadata.
• Create Property MetaData - Creates a property metadata for an entity.
• Update Property MetaData - Updates the metadata of a property and stores the operation name for which the audit is enabled.

Data Type:

nvarchar

Size:

64

Can Be Null:

No

Primary Key:

No

Foreign Key:

No

STATUS

Function:

The outcome of the operation.

Values:

• 0 - Succeeded. The operation is successfully executed.
• 1 - Failed. The operation failed to execute.

Data Type:

nvarchar

Size:

16

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No