TABLE 1: Columns in the Change-Tracking Table
Column Description
SerialNo Identification number of the change
Date Date of this change
ChangedComponentType Type of component changed (e.g., table, view)
ChangedComponentName Name of database object
OldVersionNumber Version changed from
NewVersionNumber Version changed to
ChangedBy Person making change
ChangeDescription Short description of the change
ChangeRequestNo Number for the Change Request Tracking system
TestedOK Yes or no
DatabaseName Name of database containing change
DateAppliedToServer1 Date change was applied to Server 1
DateAppliedToServer2 Date change was applied to Server 2
DateAppliedToServer3 Date change was applied to Server 3