The Hach WIMS Direct Server-Side Interface to Custom Q12410 LabVantage LIMS is used to transfer daily lab results to the Hach WIMS DBMS. Source table defaults to u_transfer, but can be changed in the configuration. Once a day, data will be read from the u_transfer table and inserted (or edited) into the appropriate Hach WIMS record. Sample Type has been added as optional, and allows user to specify values from the Sample Type field. If blank, the Sample Type is ignored.

The u_transfer is a data table created by a specific SQL trigger, and is very specific and unique to this custom interface. The following is a snapshot of the database.

The data was extracted from LabVantage's Sapphire LIMS. For more information on Sapphire go to www.labvantage.com.

This interface is a HYBRID, meaning it has broken off the normal way a LIMS interface works. The following are important points to keep in mind.

1. When importing values, the STATUS field (RAW or FINAL) determines the approval level written in Hach WIMS. This means it will overwrite the data point no matter what the Hach WIMS has. The reason is that the Lab might have finalized a result and then come back and say it's wrong and set it back to RAW. The latest value is always written to Hach WIMS.
2. If the latest value is blank or null, the interface will delete the data point, an audit trail will still exist for that point showing the pervious value
3. If the value is unknown to Hach WIMS, it is appended to the result comment along with NOTES and TESTNOTES fields. If there was a numeric value and it changed to some unknown text value, the numeric value is deleted and the comments are updated with the text value. Again, the audit trail will show all of the transactions for the data point.
4. When a data point is written to Hach WIMS, that data point in the source data has the field PROCESSED updated with 'Y'.

Here is an example data point that had a value, then the value changed to something unrecognizable to Hach WIMS, notice the audit trail keeps track of all transactions with the latest at the top:

Also notice this data point has a comment. This will tell us more about what happened.