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.
|