Supported variable configurations for the Hach WIMS Direct Server-Side Interface to Custom 12692 PCS SCADA.
To configure a variable to hold values from PCS SCADA Archive database, select System Setup > Edit/View Variables in the Hach WIMS Client and select the Interface tab.
Then click Interface To radio button. The drop down box next to the option is now enabled, click the drop down arrow and choose the PCS SCADA Archive database interface name (name given when configuring the interface, in our example this is PCS SCADA).
Now you are ready to configure a signal tag from the PCS SCADA Archive database. The Tag name and a statistic are all that are mandatory.
The tag name includes the group name and the logging name seperated by "@@". The ? symbol (question mark) will allow you to browse the Historian database for tag names. An explanation of the browser can be found in Using Interface Browser Q12582.
This is a listing of all the statistics supported by this interface. This includes the following statistics for a specified time period:
NOTE: All statistics return a BLANK when no data is found except where specified.
|
STATISTIC |
DESCRIPTION |
|
AVERAGE
AVERAGEZERO |
Take the average of the data points, the ZERO option returns a zero (0) if no data found. |
|
TOTAL
TOTALZERO |
Take the sum total of all values, the ZERO option returns a zero (0) if no data found. |
|
MINIMUM |
Get the minimum value |
|
MAXIMUM |
Get the maximum value |
|
FIRST |
Get the first value |
|
LAST |
Get the last value |
|
DIFF |
Calculate the difference between the first and last values. If the first value is larger than the second then it will perform the following calculation: (10 ^ (Ceil(LOG(first_value) / LOG(10)))) - first_value + last_value
Ceil will cause the value to round up |
|
RANGE |
Calculate the absolute value of the difference between the minimum and maximum values |
|
COUNT |
Counts the number of data points. |
The records returned from the query are then calculated based on the statistic.
This is the value to multiply the result by when using parameter variable types. Commonly used to convert from one unit base to another. For example to convert gallons per minute (GPM) to gallons per day (GPD), set the scale factor to 1440 (1440 minutes per day).
All three fields must have numeric values or the word None (as shown). The Low Range and High Range will crop data from the source. For example to eliminate negative numbers from a particular tag, set the Low Range to 0 (zero) - this will get any values equal to or greater than 0 (zero). The Deadband is used for the statistic Inventory and will elliminate noise levels up to the value specified. For example, if you enter .5 next to Deadband, any value change of .5 or less, will be ignored.
- Start Time will set the beginning of the time slot for this variable.
- Stop Time will set the ending time for the time slot.
- Same Day as Start is only used by daily variables and it means the stop time is on the same day as the start time.
- Day After Start is also only used by daily variables and it means the stop time is a day after the start time.