Audit Trail Header and Detail Records

Windchill Risk and Reliability Desktop Help > Overview > Features > Audit Trails (Enterprise Edition Only) > Audit Trail Header and Detail Records

Each Audit Trail file contains Audit Header and Audit Detail records for the date range indicated in its file name. Each time that a record is inserted, modified, or deleted from a primary System file table, Audit Header and Audit Detail records are inserted in the current Audit Trail file.

The Audit Header and Audit Detail records identify the System file table and record associated with an audit action. For example, in the upper right corner above the table, you might see System Tree Item: LRU2. The format is singular table name:table display name.

Additionally, Audit Header and Audit Detail records contain the fields described in the following table.

Field	Description
Header Record
AuditAction	Indicates the type of change action, which includes Insert, Update, Delete Attachment, and Open Attachment. • When you insert or update data, a header record is inserted. Additionally, detail records are inserted for each field in which data was entered or changed. • When you delete a record from the System file, a header record is inserted. However, no detail record is inserted. Consequently, a Report Design file that is to show all modifications, including deletions, cannot use fields in the detail record. For more information, see Audit Trail Reports.
UserID	The unique numeric identifier assigned to the user who performed the action.
UserName	The user name assigned to the user who performed the action.
GroupID	The unique numeric identifier assigned to the group under which the user is logged into
GroupName	The name of the group to which the user who performed the action belongs.
AuditDateTime	The date and time that the action occurred.
Source	Indicates whether the change was made from the desktop application or web application.
IPAddress	For an Attachments field only, the IP (internet protocol) address of the machine from which the audit action was performed. This field remains blank for other field types.
Detail Record
FieldName	The name of the field that was changed.
OldDataText	The original value for the field, before the change was made. For a newly inserted record, this field is blank. For an Attachments field, deleting multiple attachments creates multiple records. For each record, this field shows the name of the file that was deleted.
NewDataText	The new value for the field. For an Attachments field, inserting attachments creates multiple records. For the first record, this field shows the updated number of attachments. For the one or more subsequent records, this field shows the name of the file that was inserted.

When you are working in a System file and the Audit Trail application is turned on, you can view audit trail information for the selected record from the View menu. For more information, see Viewing Audit Trail History (Enterprise Edition Only).