Hach WIMS Direct Server-Side Interface to Perkin Elmer Labworks LIMS supports reading of the following fields from PE Labworks Database :
- SAMPLE.SAMPNO : Sample Number from SAMPLE table
- SAMPLE.COLDATE : Sample Collection Date from SAMPLE table
- SAMPLE.LOCCODE : Sample LOCCODE from SAMPLE table
- RESULT.ACODE : ACODE from RESULT table
- RESULT.ANALYTE : ANALYTE from RESULT table
- RESULT.RESULT : RESULT from RESULT table
- RESULT.RESULT2 : RESULT2 from RESULT table
- RESULT.RLTUNIT : RTLUNIT from RESULT table
- RESULT.QUALIFY : QUALIFY from RESULT table
- VALIDATION: From either ANALYSIS.AVALUSER or SAMPLE.VALUSER, depending on the setting Verify result validation type under Configuration -> Source Configuration -> Advanced Settings. See article Configuration - Source Configuration Q12211 for more information.
(NOTE: The following fields, if used in Custom Query, MUST be added to the SQL statement. See Source Configuration for more details)
- RESULT.MDL : MDL from RESULT table
- RESULT.PQL : PQL from RESULT table (NOTE: this field is not in every Labworks database, you MUST go to Source Configuration to enable this field in order to use it.)
- RESULT.StartDate : StartDate from RESULT table
- RESULT.Analyst : Analyst from RESULT table
In order to set this up, first create additional information fields in the Hach WIMS client under System Setup -> System Tables -> This Facility -> Additional Info Tables -> and select the option Data Additional Info.
Create a New field:
Now run the interface and navigate to Configuration -> Advanced Configuration -> Additional Info tab and click the Configure Additional Info button.
When you click the box just below the title Source Field Identifier, the following screen will appear. Select the appropriate field you want imported to the additional info field you created.
Click the corresponding box below the title; Target WIMS Facility Identifier Field Identifier.
Finally, check the Enabled box to allow the interface to populate this value.
