The Hach WIMS Direct Server-Side Interface to Custom Q13249 ATL Sample Master LIMS is designed to work in conjunction with the Hach WIMS Direct Server-Side Interface to Mettler Toledo Overdrive interface (Q12695). The Q12695 interface will import values into Hach WIMS as far as truck account ID's, descriptions, sample bottle numbers, transaction start date, transaction complete date, and among other things, transaction number. The transaction number is used to match records in the ATL Sample Master database in order to find related tests.

The transaction number is stored in an additional info field. The number is matched with the SITE number in the ORDERDETAILS table. From the ATL database, the test codes can be extracted for a particular transaction number by using the following query:

SELECT o.site as LOCCode, r.param as TestCode, r.result as Result, o.collectdate as COLDate, r.samplenumber as SampleNumber FROM SMSU.results as r, SMSU.orderdetails as o WHERE o.samplenumber=r.samplenumber and r.resultstatus=3 and r.result is not null and o.site is not null and r.approveddate>'2006-01-01 00:00:00' and r.approveddate<'2010-12-08 13:57:00' and o.Site = '3-0-10159' ORDER BY r.samplenumber

Enter appropriate R.APPROVEDDATE's and the O.SITE is the transaction number. In our particular test we see the following results:

An additional info field must be created and mapped to each test code in order to import values.