AnsweredAssumed Answered

PI AF Design for LIMS data

Question asked by RayHoward on Jun 8, 2016
Latest reply on Jun 9, 2016 by RayHoward

Hi,

As a newbie to PI I have been thrown into the deep end to help setup PI to store our LIMS assay data. As a test I'm setting up tags in SMT as follows:

L1CONAU - Holds the assay value

L1CONAU.BATCHID - Holds the Sample BatchID (Not unique)

L1CONAU.SAMPLEID - Holds the unique Sample ID

L1CONAU.SAMPLEDATETIME - Holds the date and time of the original sample

 

We have multiple elements (Au, Ag, SiO2 etc) for multiple lines (Line 1, Line 2) giving us results in the SQL LIMS table like this.

L1CONAG - Holds the assay value

L1CONAG.BATCHID - Holds the Sample BatchID (Not unique)

L1CONAG.SAMPLEID - Holds the unique Sample ID

L1CONAG.SAMPLEDATETIME - Holds the date and time of the original sample

 

L1CONAU - Holds the assay value

L1CONAU.BATCHID - Holds the Sample BatchID (Not unique)

L1CONAU.SAMPLEID - Holds the unique Sample ID

L2CONAU.SAMPLEDATETIME - Holds the date and time of the original sample

 

I have created the 1st set of tags for L1CONSiO2 (in SMT) and was trying to figure out the best way to set them up in AF.

Should I have an Element setup like this:

Site

     Assays

          Line 1

               Line 1 Concentrate Grade Au

               Line 1 Concentrate Grade Ag

          Line 2

               Line 2 Concentrate Grade Au

               Line 2 Concentrate Grade Ag

 

Attributes for every element includes:

Result - TagID is L1CONAU

BatchID - TagID is L1CONAU.BatchID

SampleDateTime - TagID is L1CONAU.SAMPLEDATETIME

SampleID - TagID is L1CONAU.SAMPLEID

 

Viewers of the data want to be able to see the results by BatchID, Element, Line Number and individual SampleId's.

My current example is as below (missing the SampleID Attribute).

 

 

Any suggestions, will this work or are there better ways to set it up?

 

Regards,

 

Ray

Outcomes