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.