Populate Test_History
Use this site parameter to determine whether a history of changes to the Tests table will be recorded. If you set the value to True, any changes to the Tests table will be recorded in the Test_History table.
If you have installed Proficy DataMart, as soon as you add the server to the DataMart, this site parameter is set to Full History, changed to a system parameter, and is no longer visible in the Plant Applications Administrator. If you change the site parameter's value to any value other than Full History, you may cause the DataMart to become out of sync with your Plant Applications database.
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 Tests table, ALL of those deletions would be recorded in the Test_History table.
To change this site parameter:
-
Log in to the Plant Applications Administrator.
You must have Administrator access to the Administrator security group to change site parameters.
-
Open Global Configuration.
-
Right-click on Administer Site Parameters and select Edit Site Parameters from the pop-up menu.
-
In the Site Parameters dialog box, scroll down and double-click on Populate Test_History.
-
In the Edit Parameter dialog box, select a Value from the drop-down list:
-
Full History – Any and all changes (result_on and test value changes) to the Tests table will be recorded in the Test_History table. If the generating time stamp is set to move at some interval (Auto move End Time), history is recorded at those intervals.
-
History Based On Event Status and Value Change – History is recorded in the Test_History table for all associated events that have a status for which the Bypass History flag is not set. History records associated with test value changes are also updated.
-
History (Based) On Value Change Only – Only test value changes are recorded in the Test_History table
-
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.
-
Click the OK button to save your changes, and close the dialog box.
-
Click the Close button to close the Site Parameters dialog box.
-
Refresh the server.