SOC.

The purpose of this application is to compare and update parameters originating from a SOC – Standard Operating Conditions – database with TDC realtime values enabling users to perform a comfortable and regularly check of these SOC-parameters.

The architecture consists of 2 databases and 1 GUS-display as interface.

The type of SOC datastore is not important as long as a datatable(s) can be linked to the RealTime MS-Access database.
The RealTime db is used as an intermediate storage in which data from TDC is collected, compared, stored and if required distributed again to TDC.

Reading and storing of TDC data is done by the GUS-display.

The GUS-display does not contain code but hosts two subpictures "RealTimeGridBar.pct", "PrintScreen.pct" and three controls "S3RealTimeGrid.ocx", "Editor.ocx" and "S3PopUpMenuCtl.ocx"

The RealTimeGridBar -subpicture contains code to collect/distribute data from/to TDC while the S3RealTimeGrid control collects/distributes data from/to the RealTime datastore.The Editor control has been used to view some logging.A Log file per day is generated and data is appended to it each time the interface is used for a comparison or update.
PrintScreen.pct is used to provide a customized popup menu with aid of the S3PopUpMenuCtl control which disables the standard GUS popup menu for security reasons.

During display startup a pre-configured parameterlist is loaded into the combobox. Depending of the location of the RealTime database e.g. if it is stored on a server, loading can increase to a few seconds.
Once it is loaded the "Show Data" button is made visible, while all other buttons are invisible. Clicking on this button starts collecting TagNames from the SOC/RealTime datastores of which the parameters should be checked and starts to retrieve the parameter values from TDC.During this process – can increase to several minutes depending on the amount of TagNames – logging is activated.Log results are immediately viewable in the Editor control and each message is appended during one Show Data session.

Clearing the textbox is possible and is automatically done if the "Show Data" button has been pressed, however all messages are appended to the log file.
After capturing the data, the grid will show all differences between the SOC db and TDC.

And the remaining buttons are made visible unless retrieving was unsuccessful.
An additional field in the grid shows information if the parameter is UPDATABLE or not.

Differences for ALL defined parameters or one selected parameter can be retrieved.
Updating TDC parameters can be activated by clicking the "Upd. TDC" button. While updating, a status message is shown and the "Updating" box is blinking RED.

Updating is possible for all parameters or one selected parameter.
If the inactive checkbox is selected then all points of which the parameter requires an inactive state will be put inactive and active again during the update. Not selected will prevent an update of these parameters.
The "Parameter Existence" checkbox will execute a parameter check for each Tag if it has been checked. If a parameter does not exist for a pointtype then it won’t show this parameter in the resulting grid and won’t try to update the parameter in TDC.
Checked or unchecked, a message to the log file is appended indicating the faulty parameter for the examined pointtype.

The BackUp button enables the user to copy the resulting Differences-table for backlog activities.

Printing is done by automating Access and printing the configured report in the RealTime database.
Hence it is possible to build a customized report by modifying a configured parameter.

If configured, the popupmenu of the RealTimeGrid enables the user to invoke the detail of the selected Tag in the Native Window.

Rightclicking in the toolbar will invoke a popup which enables to print the screen or the active window.
- Standard TPS security: OPR/SUP and ENG personalities - OS security: File security

Required software:
- GUS Display RunTime
- GUS Display Builder
- MS Access 2000 or higher

Dupont De Nemours Luxemburg: Luxemburg city