Transaction (Audit) Log

Overview

Veracross tracks user and system made changes to data including changes to people, households, organizations, applications, as well as all academic information (grades, enrollments, etc.). This can be helpful to track down when changes were made to data, what the changes were, and by whom they were made.

The transaction (or audit) log may be accessed from two places:

  1. The “Audit Log” link on a detail screen. This will display the changes relevant to the particular record.
  2. The “Find Audit Log Records” query in the General column of the System homepage. SysAdmin_1, SysAdmin_2, or Admissions_1 permission is required.

Query Design and Results

To run a transaction log query, click “Find Audit Log Records” on the System homepage.

Query Design

General Query Template Category

Update DateBy default, the “Update Date” field is set to “is on or after (today).” There are hundreds of thousands of transactions logs — sometimes more — so it is recommended that you only search for relatively narrow date ranges to ensure a reasonable query runtime.
Update Date (Local)The local time (at the school) the update was made.
Update UserThe user who made the update. If the update was made by the system, one of several system usernames will appear: vc_system, dbo, vc.web are the most common.
Table NameThe name of the table in the database.
Update MachineThe name of the computer (set in its own sharing settings) that made the update.
Update ApplicationThe application used to make the update, such as Axiom or Admission Portal.
Record IDThe internal ID of the record that was updated.
DescriptionDescription of the record, which will vary by type.
Field UpdatedThe name of the field that was updated.
Old Value and New ValueThe old and new values of the fields.

Household/Person Query Template Category

The first three fields below pertain to the information being updated, and the fourth field (User Roles) pertain to the user making the update.

Person RoleIf there are changes to the following tables, the role of the person being updated is displayed:


  • Person
  • Person__Overflow
  • Person_Citizenship
  • Person_Permission
  • Person_Preference
  • Person_Profile_Code
  • Person_Role
Household/ Person RolesDisplays all household member roles if the updated table is Household or all person roles if the updated table is Person.
Person Graduation YearDisplays the graduation year if the record is updated on the Person table for an alumni or former student.
User RolesDisplays all person roles for the update user.

Query Results

On the query results screen, the “Description” field will be linked if applicable, e.g., if a Person record is updated, the name will be linked to the Person detail screen. Click the “Transaction Log ID” to view the Transaction detail screen.

The detail screen presents the same information as the results grid, but adds a “New Value (Memo)” field to more easily view multi-line updates.