Matrix Spike on a Non-Client Sample

Matrix Spikes are sometimes performed on field samples not associated a given laboratory report.   These samples are called Non-Client samples because they do not belong to the client listed on the laboratory report.   However, the quality control information generated from these samples are reported in EDF, as they are part of quality control associated with the report. To protect confidential information, Non-Client samples are reported without sample information (no record is entered into the SAMPLE table).  They are essentially entered like a quality control sample.  The image below is an overview of how the samples are organized for EDF entry.

Note that EDF requires both the matrix spike (MSEFF-1) and the original value of EFF-1(NCEFF-1) to complete Lab Report 1. The EDF system calculates the matrix spike recovery from these measured values (and the EXPECTED value), generating the percent recovery.  An Example of Lab Report 1 is outlined in the tables below:

 

LOCID LOGDATE LOGTIME LOGCODE SAMPID MATRIX PROJNAME LABWO GLOBAL_ID LABCODE
SAMPLE Table*
MW-1 20130901 1030 FRM1 SAMP-1 W NC_MATRIX_SPIKE 1 12345678910 LAB1
MW-2 20130901 1100 FRM1 SAMP-2 W NC_MATRIX_SPIKE 1 12345678910 LAB1

 *Optional fields COOLER_ID, COC_MATRIX, and DQO_ID not listed.

 

LOCID LOGDATE LOGTIME LOGCODE SAMPID MATRIX LABCODE LABSAMPID QCCODE ANMCODE MODPARLIST EXMCODE LABLOTCTL
TEST Table
MW-1 20130901 1030 FRM1 SAMP-1 W LAB1 LABSAMP-1 CS SW8260B T METHOD BATCH_1
MW-2 20130901 1100 FRM1 SAMP-2 W LAB1 LABSAMP-2 CS SW8260B T METHOD BATCH_1
          W LAB1 NCEFF-1 NC SW8260B T METHOD BATCH_1
          W LAB1 MSEFF-1 MS1 SW8260B T METHOD BATCH_1
LCHMETH ANADATE EXTDATE RUN_NUMBER RECDATE COCNUM BASIS PRESCODE SUB REP_DATE LAB_REPNO APPRVD TLNOTE
TEST Table (Cont.)**
  20130907 20130907 1 20130902 1 N P05 NA 20130915 LAB_REPORT_1 ALI  
  20130907 20130907 1 20130902 1 N P05 NA 20130915 LAB_REPORT_1 ALI  
  20130907 20130907 1 20130907   N   NA        
  20130907 20130907 1 20130907   N   NA        

**Optional fields REQMETHGRP, PROC_NAME, COOLER_ID, LABMETHGRP, METH_DESID, and CLEANUP not listed.

 

MATRIX LABCODE LABSAMPID QCCODE ANMCODE EXMCODE PVCCODE ANADATE RUN_NUMBER PARLABEL PARVAL RLNOTE PARVQ
RESULTS Table
W LAB1 LABSAMP-1 CS SW8260B METHOD PR 20130907 1 BZ 1.0   =
W LAB1 LABSAMP-2 CS SW8260B METHOD PR 20130907 1 BZ 0.0   ND
W LAB1 NCEFF-1 NC SW8260B METHOD PR 20130907 1 BZ 5.0   =
W LAB1 MSEFF-1 MS1 SW8260B METHOD PR 20130907 1 BZ 27.0   =
LABDL REPDL REPDLVQ PARUN UNITS RT DILFAC CLREVDATE SRM
RESULTS Table (Cont.)***
0.1 0.5 MRL   UG/L   1   NA
0.1 0.5 MRL   UG/L   1   NA
0.1 0.5 MRL   UG/L   1   NA
0.1 0.5 MRL   UG/L   1 20130101 NA

***Optional fields PROC_NAME, LABMETHGRP, and METH_DESID not listed.

 

MATRIX LABCODE LABLOTCTL ANMCODE PARLABEL QCCODE LABSAMPID LABREFID EXPECTED UNITS
QC Table***
W LAB1 BATCH_1 SW8260B BZ MS1 MSEFF-1 NCEFF-1 30 UG/L

***Optional fields PROC_NAME, LABMETHGRP, and METH_DESID not listed.

 

LABCODE MATRIX ANMCODE EXMCODE PARLABEL CLREVDATE CLCODE UPPERCL LOWERCL
CL Table***
LAB1 W SW8260B METHOD BZ 20130101 MSA 120 80
LAB1 W SW8260B METHOD BZ 20130101 MSP 20 0

***Optional fields PROC_NAME, LABMETHGRP, and METH_DESID not listed.