Audit and Control Management Server 2013 - Change Tracking Types

  • Article

The following is a list of the different Change Tracking Types that are shown on the Change History page for a file, as well as their definitions, used in Audit and Control Management Server 2013 for comparing versions of workbooks and Access databases.

 

ACM Change Tracking Type Definition
   Spreadsheet
Formula Formula modifications are changes to an existing cell formula, and additions and deletions of formulas.
Entered Value Entered value modifications are changes to a cell value that the user enters, and additions and deletions of a cell value by the user. These cells do not contain formulas.
Calculated Value Calculated value modifications are changes to a calculated value in a cell. This cell contains a formula that calculates the resulting value.
Structural Structural modifications are changes to sheets, including renames, deletions, additions, and moves, as well as row and column insertions and deletions.
Named Item Named item modifications are changes to a named item, and additions and deletions of names.
Macro Code module modifications are changes to a VBA code module or macro item.
Data Connection Data connection modifications are changes to an external data connection, including databases, xml, text, etc., and additions and deletions of data connections.
Key Item Key items are ranges with values that are tracked whether or not a value in the range was changed. This only tracks values, not formulas.
Format/Protection Format/Protection modifications are changes to cell format, cell protection, workbook protection, sheet protection, or VBA protection.
Status Status changes occur when 1) the first version of a file is processed to start the Change History and 2) there are no changes detected in a version.
   Access Database
Table Table modifications are changes to a database table.
Query Query modifications are changes to a database query.
Module Module modifications are changes to a database code module.
Macro Macro modifications are changes to a database macro.
Report Report modifications are changes to a database report.
Form Form modifications are changes to a database form.
Page Page modifications are changes to a database page.
Status Status changes occur when 1) the first version of a file is processed to start the Change History and 2) there are no changes detected in a version.