The interface was designed and tested for source data on Oracle 10g, but with the ability to import from later versions of Oracle.

Specifications:

When running as a service, all records in OPSWIN table are imported, and when ran interactively the interface imports from a date range.

Cross Reference is with the OPSWIN.LOCATIONCODE and OPSWIN.STORET, with the option of adding OPSWIN.PROJECT#. To omit the OPSWIN.PROJECT# from cross reference, the PROJECT NUMBER (LIMS_UD1) field in Hach WIMS variable setup must be blank.

Unit conversion is accomplished using a Multiplier field in the Hach WIMS variable setup (LIMS_UD2). Previous versions of this interface used USER DEFINED 1 (UD1). Removed the restriction of this field being > 0, it can be any positive or negative real number within limits of a double percision number. 

The OPSWIN.REPORTEDRESULT numeric portion is multiplied by the multiplier, mentioned above. The OPSWIN.DATA_QUALIFIER is appended to the result and then the value is imported.

If the OPSWIN.DATA_QUALIFIER is not recognized by Hach WIMS (i.e., "BB" for a value), the result is written to comments.

Source Data to Hach WIMS Cross Reference:

LOCATIONCODE = LIMS_LOC (Formerly LOCATION)
STORET = LIMS_TEST (Formerly STORET)
PROJECT# = LIMS_UD1 (Formerly UD2)
Multiplier = LIMS_UD2 (Formerly UD1)

Field Definition:

Date Stamp = COLLECTION_DATE
Symbol = DATA_QUALIFIER
Result = REPORTEDRESULT

Result = Result * Multiplier

Return Value = Symbol & Result