Populate Event_Detail_History

Use this site parameter to determine whether a history of changes to the Event_Details table will be recorded. If you set the value to True, any changes to the Event_Details table will be recorded in the Event_Detail_History table.

If you have installed Proficy DataMart, as soon as you add the server to the DataMart, this site parameter is set to True, changed to a system parameter, and is no longer visible in the Plant Applications Administrator.

Keep in mind that if there are a lot of changes, this table can become quite large. For example, if you were to delete a number of records in the Event_Details table, ALL of those deletions would be recorded in the Event_Detail_History table.

To change this site parameter:

  1. Log in to the Plant Applications Administrator.

You must have Administrator access to the Administrator security group to change site parameters.

  1. Open Global Configuration.

  2. Right-click on Administer Site Parameters and select Edit Site Parameters from the pop-up menu.

  3. In the Site Parameters dialog box, scroll down and double-click on Populate Event_Detail_History.

  4. In the Edit Parameter dialog box, select a Value from the drop-down list:

  5. Full History – All changes are recorded to the history table and, if the generating time stamp is set to move at some interval (Auto move End Time), history is recorded at those intervals.

  6. History Based On Event Status – History is recorded for all associated events that have a status for which the Bypass History flag is not set.

  7. No History – No changes, included History changes for a Complete status, are recorded in the History table.

TIP:  To monitor event progress for long production events and control history data collection, refer to Event Dimension Periodic Update.

  1. Click the OK button to save your changes and close the dialog box.

  2. Click the button to close the Site Parameters dialog box.

  3. Refresh the server.