Hach WIMS Direct Server-Side Interface to Custom DCS_Points_Retrieved table pulls data from a DCS_POINTS_RETRIEVED and stores the values in the WIMS Database. This interface works in conjunction with the Hach WIMS Direct Server-Side Utility to Custom SCADA Request Table Q13645 to pull data from an older Emerson DCS system. Steps to get data:
1. Q13645 Utility inserts data request records in the DCS_POINTS_TO_PROCESS table for all variables linked to this interface
2. A client supplied program checks the DCS_POINTS_TO_PROCESS Table and using an Emerson API pulls summary values for the requested data and puts the data in the DCS_POINTS_RETRIEVED table
3. This Interface reads the data from the DCS_POINTS_RETRIEVED and places the data in the WIMS database for the specified Varids. Note: Interface retrieves the earliest STATISTIC_DT_DATE and runs the interface from that date thru the current time.
DCS_POINTS_RETRIEVED Table Structure
| Field |
Data Type |
Description |
| POINT_ID |
VARCHAR2(9 BYTE) NOT NULL |
WIMS Varid |
| POINT_NM |
VARCHAR2(26 BYTE) NOT NULL |
WIMS SCADATAG |
| POINT_COLLECTION_ID |
VARCHAR2(9 BYTE) NOT NULL |
WIMS Varnum |
| POINT_TYPE |
VARCHAR2(4 BYTE) NOT NULL |
|
| STATISTIC_VALUE_FORMAT |
VARCHAR2(6 BYTE) NOT NULL |
DOUB for Numeric, TIME for Epoch Time |
| STATISTIC_VALUE |
VARCHAR2(30 BYTE) NOT NULL |
Returned Result as a String |
| STATISTIC_DT |
VARCHAR2(19 BYTE) NOT NULL |
Date value is for as a String |
| QUALITY |
VARCHAR2(7 BYTE) NOT NULL |
Quality Flag |
| STATUS |
VARCHAR2(1 BYTE) NOT NULL |
? |
| TIMESTAMP |
DATE |
AuditTimeStamp of when record was written to DCS_POINTS_RETRIEVED table |
| STATISTIC_DT_DATE |
DATE |
Date value is for as a Date |
| FACILITY |
VARCHAR2(10 BYTE) |
The WIMS Facility ID (OPSROOT.FACILITY.FILENAME). I.E. OPSPL. |