The Hach WIMS Direct Server-Side Interface to Custom Q12827 LIMS was tested against a database table received from the customer. The table structure and sample data look like the following:

After the LIMS_DATA is imported, and if configured, it will copy the data points to the LIMS_DATA_DONE table and delete LIMS_DATA data points.

This is the SQL to create LIMS_DATA table:

USE [LIMS_EXCHANGE]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LIMS_DATA](
[EXCHANGE_SID] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
[SAMPLE_SID] [numeric](8, 0) NOT NULL,
[SOURCE_CODE_SID] [numeric](9, 0) NOT NULL,
[SITE_SEQ_NUM] [numeric](4, 0) NOT NULL,
[COLLECTION_DATE] [datetime] NOT NULL,
[COLLECTION_TIME] [datetime] NULL,
[OP_SID] [numeric](9, 0) NOT NULL,
[RESULT_REPORT] [varchar](50) NULL,
[UNIT_OF_MEASURE_SID] [numeric](9, 0) NOT NULL,
CONSTRAINT [PK_LIMS_DATA] PRIMARY KEY CLUSTERED
(
[EXCHANGE_SID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

This is the SQL to create LIMS_DATA_DONE table:

USE [LIMS_EXCHANGE]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LIMS_DATA_DONE](
[EXCHANGE_SID] [numeric](18, 0) NOT NULL,
[SAMPLE_SID] [numeric](8, 0) NOT NULL,
[SOURCE_CODE_SID] [numeric](9, 0) NOT NULL,
[SITE_SEQ_NUM] [numeric](4, 0) NOT NULL,
[COLLECTION_DATE] [datetime] NOT NULL,
[COLLECTION_TIME] [datetime] NULL,
[OP_SID] [numeric](9, 0) NOT NULL,
[RESULT_REPORT] [varchar](50) NULL,
[UNIT_OF_MEASURE_SID] [numeric](9, 0) NOT NULL,
CONSTRAINT [PK_LIMS_DATA_DONE] PRIMARY KEY CLUSTERED
(
[EXCHANGE_SID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF