Open topic with navigation

Share Topic

Set Up Change Tracking with a Simple Trigger

Configuring PCS to track data changes with a trigger can be done from within PCS using the Field and UDF Customizations and Options windows. It is recommended that change tracking configurations are only made during the initial configuration of PCS or while performing system maintenance.

Perform the following steps to track data changes using a trigger:

  • Modify change tracking settings for each individual field as needed by doing the following:

    1. Click Tools > Field and UDF Customizations to open the Field and UDF Customizations window.

    2. Select a table in the Properties panel that includes the field you want to modify for change history.

    3. Select the field you want to set up for change tracking.

    4. In the System-Enable Change History column, select Yes to track changes made in the selected field while change history is enabled. Select No to not record any changes made in the field, even if change history is enabled in Options.

    5. Repeat steps through for additional fields. When you finish, click the close icon to close the Field and UDF Customizations window.

  • Enable change history for PCS by clicking to select the Change History check box in Options. If change history was already enabled, update the setting by clicking to clear the Change History check box and then clicking to re-select the check box.