Community Forum     Helping YOU do what YOU want with YOUR data.
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Production team  
#1 Posted : Tuesday, August 24, 2021 1:21:11 PM(UTC)
Production team
Rank: Newbie

Reputation:

Groups: Registered
Posts: 5
New Zealand

Thanks: 3 times

Hello,

The ESdat specifications state that the SampleCode should be contructed as: [Lab_Report_Number]_[LabSampleID].

It also states that each sample should have a unique SampleCode even when reported in a different report. This is contradictory - every report must be uniquely identified, so different reports always have different numbers.

Is it sufficient to use LabSampleID as the SampleCode?

Cheers

Nick Support  
#2 Posted : Tuesday, August 24, 2021 3:36:11 PM(UTC)
Nick Support
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 269
Canada

Was thanked: 24 time(s) in 24 post(s)

Hi,

Often client samples already have the Lab Report Number as part of the Lab Sample ID.  In this scenario there is no need to duplicate the Lab Report Number at the begining of the SampleCode.

The reason for [Lab_Report_Number]_[LabSampleID] in the specification is predominantly for Lab QA samples which can often be used in multiple reports.  This includes MS, Lab_D, etc.

If you were to just use the LabSampleID in this scenario, this means you may repeat the same SampleCode across multiple reports which would cause duplicates when trying to import the Lab Reports (and it would not load).

For example if you have a matrix spike with LabSampleID 123456MS and this QA sample was reported in Lab Report 35462 and Lab Report 35463 with the same SampleCode, whichever Lab Report was uploaded second would give a duplicate sample error and not upload. 

By prefixing the Lab Report Number, you will get two unique SampleCodes (35462_123456MS and 35463_123456MS) and both reports will upload successfully with no duplicate errors.

I hope this clarifies things for you. 

Thanks,

Nick

thanks 1 user thanked Nick Support for this useful post.
Production team on 8/25/2021(UTC)
Production team  
#3 Posted : Wednesday, August 25, 2021 7:24:16 AM(UTC)
Production team
Rank: Newbie

Reputation:

Groups: Registered
Posts: 5
New Zealand

Thanks: 3 times

Hi Nick,

That does help, thank you!

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.