Audit and Control Management Server 2013 - Change Tracking Types

Article
08/29/2013

Below is a list of Change Tracking Types and their definitions in Microsoft Audit and Control Management (ACM) Server 2013. These tracking types are used to categorize changes between file versions in the Change History.

Spreadsheets

ACM Change Tracking Type	Definition
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 there are no changes detected in a version. This includes the first version as it does not have a previous version to compare to.

Access Databases

ACM Change Tracking Type	Definition
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 there are no changes detected in a version. This includes the first version as it does not have a previous version to compare to.