The utility requires WIMS additional info fields be setup as follows for the Variable (VARDESC) table and the data (DATATBL,DATADDH, etc...) tables.

Variable Additional Info Field Setup:

LIMS_TABLE_NM                         NVARCHAR2(50)     DEFAULT NULL,
LIMS_COLUMN_NM                      NVARCHAR2(50)     DEFAULT NULL,
LIMS_CONVERSION_FACTOR_NUM  FLOAT(126)          DEFAULT NULL,
LIMS_DECIMAL_PLACES_NUM        NUMBER               DEFAULT NULL,
LIMS_TS_VARID                         NUMBER                DEFAULT NULL,
LIMS_PT_GROUP                         NVARCHAR2(50)

To setup the variable Additional Info fields, log into the WIMS client, and go to:

Data Additional Info Field Setup:

SENT_TO_LIMS_DATE (DATE type field): Will be set to the date/time that the data is pushed to the LIMS tables.  The Utility checks that the SENT_TO_LIMS_DATE is set to Null before pushing the data.  Therefore, this field prevents a data point from getting pushed to LIMS more than once.  If you need to push data a second time you MUST clear this field.  In a data entry form (such as Monthly Data Entry), bring up the point, right click and choose Additional Info: 

To setup the Data Additional Info fields, log into the WIMS client, and go to: