Audit trail data dictionary

Time

The date and time that the change occurred (in the UTC timezone).

Site

The site that the work order is for.

Service

The type of item that's being changed:

Identifier

For changes directly to work orders, the work order ID is displayed in this column. For changes to items within a work order, this column will be blank.

Parent

For changes directly to work orders, this column will be blank. For changes to items within a work order, this column displays the work order's ID.

Status

The work order's status at the time the change was made.

Asset Code

The name of the asset that the change was made for in the work order.

For example, if the change was adding a task for a specific asset, that asset's name would be displayed in this column.

Modified By

The username (or email address) of the user who made the change.

Action (CRUD)

The type of action (also called an event) that this change represents.

The possible actions are: CREATE, UPDATE, and DELETE.

Key

The key for the field being updated.

For example, a change to the asset assigned to a work order would have the key "intAssetID".

Value

The value associated with the change.

For example, for a status change, this column would display the status that was assigned to the work order in this change.

Note: Values in audit trail are limited to 1000 characters. For example, if a work order's description has more than 1000 characters, the file will only include the first 1000.