Hach WIMS Direct Server-Side Utility to Custom SCADA Request Table (Q13645) is a utility that writes records to a data request table for variables that are cross referenced to a specfied SCADA Interface (Q13605).  The Utility reads the WIMS vardesc table, writes records to EDORS.DCS_POINTS_TO_PROCESS based on specific rules.  The DCS_POINTS_TO_PROCESS table is then read by a customer supplied utility that calls an Emerson API that calculates the requested data and stores the results in the EDORS.DCS_POINTS_RETRIEVED. 

Interface Q13605 then loads the data in EDORS.DCS_POINTS_RETRIEVED.

Example DCS_POINTS_TO_PROCESS Table:

Table Definition

"EDORS"."DCS_POINTS_TO_PROCESS" 
 "FACILITY" VARCHAR2(2 BYTE) NOT NULL ENABLE,
 "POINT_ID" NUMBER(9,0) NOT NULL ENABLE,
 "POINT_NM" VARCHAR2(26 BYTE) NOT NULL ENABLE,
 "POINT_COLLECTION_ID" NUMBER(9,0) NOT NULL ENABLE,
 "STATISTIC_DT" DATE NOT NULL ENABLE,
 "STATISTIC_START" DATE NOT NULL ENABLE,
 "STATISTIC_END" DATE NOT NULL ENABLE,
 "STATISTIC_INTERVAL" VARCHAR2(9 BYTE) NOT NULL ENABLE,
 "STATISTIC_AGG" VARCHAR2(19 BYTE) NOT NULL ENABLE,
 "STATUS" CHAR(1 BYTE)