DRAFT Exhibit F and Tech.pdf

Exhibit F

Technical Specifications for Hazardous Chemical and Radiochemical Analytical Laboratory

Services - Part II Specifications for Environmental Information Management System (EIMS)

Analytical Data Format

DRAFT

Revised 7/7/16

Exhibit 1

SPECIFICATIONS FOR

ENVIRONMENTAL INFORMATION MANAGEMENT SYSTEM (EIMS) ANALYTICAL ELECTRONIC DATA DELIVERABLE (EDD) FORMAT

PURPOSE

To provide specifications for the delivery of laboratory analysis results for environmental samples taken by or for the Brookhaven National Laboratory (BNL).

SCOPE

Applies to all environmental and waste samples.

GENERAL

BNL maintains an Environmental Information Management System (EIMS) that contains the results of laboratory analysis of samples of environmental and waste media. A template has been developed to facilitate data entry to this table. BNL will provide each contractor or laboratory with the template (Attachment 1) and its associated data dictionary (Attachment 2). The contractor shall enter all data following the formatting conventions provided in this document. Electronic copies of supporting documentation (see below) shall be provided to the BNL as part of the contractor’s deliverable requirements.

INSTRUCTIONS

BNL shall provide each contractor or laboratory the required electronic data deliverable file format (Attachment 1), a sample file (Attachment 2), a listing of the field descriptions for each field in the file (Attachment 3), and a listing of legal values for restricted fields (Attachment 4.

Formatting Conventions: the contractor shall enter the laboratory analytical data according to the following formatting conventions:

All dates are mm/dd/yy.

All times are military (24 hr), no colons.

Fields should not be padded with spaces or tabs.

No fields may be omitted.

No extra fields may be added (no extra pipe at end of line).

Fields lacking data (not applicable or missing data) should be left blank.

All alpha characters must be upper case.

Deliverables:

Each file shall be delivered to BNL as a pipe-(|) delimited ASCII text file (Attachment 2). Each sample shall constitute a single file. File names must be unique, preferably the same as the Sample ID in the file. Files shall be delivered as Sample Delivery Groups (SDGs) corresponding to the samples on one Chain of Custody Record form and their associated laboratory QC data. Each SDG shall be compressed into a single WinZip file and e-mailed to the EIMS Project Manager. If the electronic deliverable must be sent on diskette, each SDG must be on a separate diskette.

First line is the header for the Sample data information.

Second line is the Sample metadata.

Third line is the header for the Sample analytical results.

Lines 4-n are the Sample analytical results, 1 record per analyte.

The data contents of the file must match the hard copy data report exactly, except for diluted samples, for which only the final [calculated] result shall be reported..

The contractor shall also provide in the body of the e-mail (or in a letter of transmission for each diskette) documentation including:

Chain of Custody number;

Project name and Project Manager name;

BNL account number;

Sample Delivery Group name.

ATTACHMENT 1

ELECTRONIC DATA DELIVERABLE TEMPLATE

This template indicates the required number and order of fields in the EIMS electronic data deliverable format. See Attachment 2, Data Dictionary, for a complete description of implementation requirements. Files shall be saved as ASCII text files, with each field separated by a pipe (|).

COC_num Site_ID Matrix Smp_ID Smp_date Smp_time Rec_date SDG Lab_file-ID Smp_depth Smp_QC Notes

Cas_num Name Conc Err Det_lim Units An_date Method-Id Lab_batch-ID Ext_date Dil Anal_QC Conc_UCL Conc_LCL

Ret_time Ret_UCL Ret_LCL Spike True_val RPD_UCL Lab_Qual Lab_QCnotes Rev_Qual Rev_conc Rev_QCnotes

(Format is shown in two sections for clarity. Actual header lines are 12 fields (11 pipes); actual detail lines are 25 fields (24 pipes).

ATTACHMENT 2

ELECTRONIC DATA DELIVERABLE SAMPLE FILE

Field Sample File

COC_num|Site_ID|Matrix|Smp_ID|Smp_date|Smp_time|Rec_date|SDG|Lab_file-ID|Smp_depth|Smp_QC|Notes 6228|000-255|W|6228-009|01/13/00|1435|01/15/00|20632|20632009|167.5|| Cas_num|Name|Conc|Err|DetLim|Units|An_date|Method-Id|Lab_batch-ID|Ext_date|Dil|Anal_QC|Conc_UCL|Conc_LCL|Ret_time|Ret_UCL|Ret_LCL|Spike|True_val|RPD_UCL|Lab_Qual|Lab_QCnotes|Rev_Qual|Rev_conc|Rev_QCnotes 100-41-4|Ethylbenzene|.5||.5|UG/L|01/27/00|EPA 524.2|9187|01/27/00|1||||||||0||U|||| 100-42-5|Styrene|.5||.5|UG/L|01/27/00|EPA 524.2|9187|01/27/00|1||||||||0||JB|||| 10061-01-5|cis-1,3-Dichloropropylene|.5||.5|UG/L|01/27/00|EPA 524.2|9187|01/27/00|1||||||||0||U|||| 10061-02-6|trans-1,3-Dichloropropylene|.5||.5|UG/L|01/27/00|EPA 524.2|9187|01/27/00|1||||||||0||U|||| 124-48-1|Dibromochloromethane|.5||.5|UG/L|01/27/00|EPA 524.2|9187|01/27/00|1||||||||0||U|||| 127-18-4|Tetrachloroethylene|.5||.5|UG/L|01/27/00|EPA 524.2|9187|01/27/00|1||||||||0||J|||| 135-98-8|sec-Butylbenzene|.5||.5|UG/L|01/27/00|EPA 524.2|9187|01/27/00|1||||||||0||U|||| 142-28-9|1,3-Dichloropropane|.5||.5|UG/L|01/27/00|EPA 524.2|9187|01/27/00|1||||||||0||U|||| 156-59-2|cis-1,2-Dichloroethylene|.5||.5|UG/L|01/27/00|EPA 524.2|9187|01/27/00|1||||||||0||U|||| 156-60-5|trans-1,2-Dichloroethylene|.5||.5|UG/L|01/27/00|EPA 524.2|9187|01/27/00|1||||||||0||U|||| 1868-53-7|Dibromofluoromethane|5|||UG/L|01/27/00|EPA 524.2|9187|01/27/00|1|SU|117|66|||||5|||||| 2037-26-5|Toluene-d8|4.9|||UG/L|01/27/00|EPA 524.2|9187|01/27/00|1|SU|122|73|||||5|||||| 3114-55-4|Chlorobenzene-d5|5|||UG/L|01/27/00|EPA 524.2|9187|01/27/00|1|IS|||||||5||E|||| 3855-82-1|1,4-Dichlorobenzene-d4|5|||UG/L|01/27/00|EPA 524.2|9187|01/27/00|1|IS|||||||5||E||||

Lab QC Sample File

COC_num|Site_ID|Matrix|Smp_ID|Smp_date|Smp_time|Rec_date|SDG|Lab_file-ID|Smp_depth|Smp_QC|Notes

||S|LCS||||99990|LCS|||

Cas_num|Name|Conc|Err|DetLim|Units|An_date|Method-Id|Lab_batch-ID|Ext_date|Dil|Anal_QC|Conc_UCL|Conc_LCL|Ret_time|Ret_UCL|Ret_LCL|Spike|True_val|RPD_UCL|Lab_Qual|Lab_QCnotes|Rev_Qual|Rev_conc|Rev_QCnotes 14269-63-7|Th-230|8.37|0.06|0.06|pCi/g|01/18/00|HASL-300 Mod.|LCS||1||120|80||||8.32|8.37|100.60|||||

ATTACHMENT 3

DATA DICTIONARY

Fields in bold are required fields, must not be null or blank except as noted.

Fields marked with an asterisk (*) must match the corresponding field on the Chain of Custody Record form.

SAMPLE HEADER FIELDS

DB Field Field Description Format (length, data type) Example Comment

*COC_num : Chain of Custody Number number(8) 5230 Must match corresponding field on COC *Site_ID : Location ID for the sample varchar2(30) 108-01, AOC3MW8 Must match corresponding field on COC *Matrix : Sample matrix char(1) See Attachment 4 for Legal Values for this field *Smp_ID : Sample's unique identifier varchar2(10) 4890-004 Field samples only (blank for QC samples); must match corresponding field on COC, = COC+UID

*Smp_date : Date of sample date MM/DD/YY Must match corresponding field on COC *Smp_time : Time of sample varchar2(4) 1215 Rec_date : Laboratory received date date MM/DD/YY SDG : Sample Delivery Group varchar2(30) Lab_file-ID : Laboratory ID for this sample varchar2(30) *Smp_depth : Depth in feet that sample was taken varchar2(20) 95.75, 123.5-133.5 One or two floating point numbers, separated by a hyphen Smp_QC : Laboratory sample QC type varchar2(8) MSD, LCS See Attachment 4 for Legal Values for this field Notes : Comments up to 100 characters varchar2(100) Any comments that apply to entire sample

DATA DICTIONARY, continued

Fields in bold are required fields, must not be null or blank.

Fields marked with an asterisk (*) must match the corresponding field on the Chain of Custody Record form.

SAMPLE DETAIL (ANALYTE) FIELDS

DB Field Field Description Format (length, data type) Example Comment

Cas_num : CAS number for chemical varchar2(15) Must match BNL-provided list; contact EIMS Data Coordinator for CAS numbers not in current list Name : Chemical name varchar2(100) Conc : Amount detected or quantitation limit number(15,10) Show non-rad nondetects as the value of the detection limit; field cannot be changed by validator Error : 2,sigma error for radioactive analysis number(15,10) Required for rad analytes; leave blank for non-rad Det_lim : Detection reporting limit (MDA) number(15,10) Required except for pH, TLD, moisture, QC analytes Units : Units varchar2(20) See Attachment 4 for Legal Values for this field An_date : Date of lab's analysis date MM/DD/YY Method : Laboratory method varchar2(20) 524.2, 1131/7470 Incl. Extraction Method where applicable (e.g., TCLP) Lab_batch-id : Batch number assigned by lab varchar2(20) Ext_date : Sample extraction date date MM/DD/YY Dilution : Dilution factor number(10,5) If undiluted, use 1 Anal_QC : Analyte QC code varchar2(3) SU, IS, S See Attachment 4 for Legal Values for this field Conc_UCL1 : Concentration upper control limit number(10,5) Required for SU, MS, MSD, LCS; same units as Conc.

Conc_LCL2 : Concentration lower control limit number(10,5) Required for SU, MS, MSD, LCS; same units as Conc.

Ret_time1 : Retention time in seconds integer(6) Required for IS Ret_UCL1 : Retention time upper control limit integer(6) Required for IS Ret_LCL1 : Retention time lower control limit integer(6) Required for IS Spike3 : Spike added number(10,5) Required for MS, MSD; same units as Concentration True_val1 : True concentration before injection number(10,5) Required for LCS; same units as Concentration RPD_UCL1 : Relative % difference upper control limit number(10,5) In percent; required for MSD Lab_qual : Laboratory’s data qualifier(s) varchar2(10) Legal values are as stipulated in the current contract Lab_QCnotes : Lab qualifier flag explanation varchar2(500) Leave blank if no QC flag or no explanation needed;

required if QC flag is X Rev_qual : Reviewer's data validation qualifier(s) varchar2(10) To be filled in by data validator only Rev_conc : Revised concentration from validation number To be filled in by data validator only (only if changed from original Lab value) Rev_QCnotes : Reviewer's qualifier flag explanation varchar2(500) To be filled in by data validator only Leave blank if no QC flag or no explanation needed;

required if Rev_conc not NULL

1 Must be > 0 2 Must be >=0 3 Spike must be >0 for at least one analyte in a spiked sample

ATTACHMENT 4 -- LEGAL DATA VALUES

SAMPLE QC CODES (all codes are upper case) ANALYTE QC CODES

DF Drilling Fluid MB Method Blank SB Solvent Blank IS Internal Standard FD Field Duplicate MS Matrix Spike SO Source Water S Spike LCS Laboratory Control Sample MSD Matrix Spike Duplicate XB Extraction Blank SU Surrogate LD Laboratory Duplicate

MATRIX and UNITS OF MEASUREMENT (all units are upper case) Matrix Non-rad Analysis Rad Analysis

A Air UG/M3 MR/90D, PCI/L, UCI/CC, UCI/ML, MR/WEEK

UCI/SAMPLE

B Asbestos PCI/G, UCI/G C Charcoal Filter UG/M3 MR/90D, PCI/L, UCI/CC, UCI/ML, MR/WEEK, UCI/SAMPLE

D Deer GRAM PCI/G E Smear UCI F Fish MG/KG, UG/KG PCI/G G Silica Gel UG/M3 MR/90D, PCI/L, UCI/CC, UCI/ML, MR/WEEK, UCI/SAMPLE

H TLD MR/90D, PCI/L, UCI/CC, UCI/ML, MR/WEEK,

UCI/SAMPLE

L Sludge C, F, FAHRENHEIT, MG/L, MPN/100ML, P/A, PH UNITS, SU, UG/L, UNITS PCI/L, UCI/CC, UCI/ML M Marinelli UCI/L, PCI/L N Solvent C, F, FAHRENHEIT, MG/L, MPN/100ML, P/A, PH UNITS, SU, UG/L, UNITS PCI/L, UCI/CC, UCI/ML O Oil MG/KG, UG/KG PCI/G P Particulate Filter UG/M3 MR/90D, PCI/L, UCI/CC, UCI/ML, MR/WEEK, UCI/SAMPLE

Q Wipe UG/WIPE PCI, UCI R Other UG/L, % UCI/G S Soil, sediment %DRY, %WET, MG/KG, MG/L, UG/KG, UG/L, null PCI/G, UCI/G T Other animal %WET, UG/KG PCI/G U Urine C, F, FAHRENHEIT, MG/L, MPN/100ML, P/A, PH UNITS, SU, UG/L, UNITS PCI/L, UCI/CC, UCI/ML V Vegetation MG/KG, UG/KG, GRAM UCI/G W Water ADMI, C, F, FAHRENHEIT, MG/L, MPN/100ML, P/A, PH UNITS, SU, PCI/L, UCI/CC, UCI/ML

UG/KG, UG/L, UNITS

SAMPLE QC CODES (all codes are upper case) ANALYTE QC CODES