140G0320Q0088 SOW and IT Requirements.pdf

140G0320Q0088 Statement of Work

I. GENERAL INFORMATION

A. Introduction / Background

The US Geological Survey California Water Science Center requires chemical analytical laboratory services for the analysis of lithium (total, Li, Li), boron (total, B, B), strontium (total, Sr, Sr), and the elemental concentrations of F, Cl, Br, NO3, SO4, I, NH4, Mg, Sr, Na, Fe, Ba, Mn, , Li, Be, B, Mg, Al, Ca, V, Cr, Mn, Fe, Co, Ni, Cu, Zn, As, Se, Rb, Sr, Mo, Ag, Cd, Sb, Ba, Tl, Pb, Th, and U, (hereinafter referred to as the “constituents”), in produced- water samples, which may contain up to

~50% oil and TDS up to 70,000 mg/L, and quality control samples through the year

2025. The laboratory analysis of produced-water samples is essential to generating the final products for this project.

B. Scope

The USGS expects to submit as many as 30 samples per year; the number of samples may be as low as 1 sample per year. Samples will be collected throughout the contract period and submitted to the Contractor for analysis. The samples are to be collected by USGS staff at multiple locations. Samples will be analyzed in the Contractor's laboratory within the holding times required by analytical methods. The USGS has established data-quality objectives (DQOs) that must be met to ensure that water-quality data can be used with confidence to assess the quality ground-water resources in the State of California.

II. WORK REQUIREMENTS

A. Technical Requirements and Criteria for Acceptance.

1. Analytical Methods: Methods selected for the analysis of the constituents in produced- water samples must be recognized by state or federal regulatory agencies

(California State Water Resources Control Board Division of Drinking Water or U.S.

Environmental Protection Agency), and must be documented, have undergone peer review, and published in a peer reviewed scientific journal. Each bid proposal must include the references for the proposed methods and published results. The contract laboratory shall document any modifications that are made to a method and demonstrate that the results provide equivalent or better performance than the unmodified method. The contract laboratory shall provide citable references for each analytical method used.

The methods in the table below would be acceptable for this contract, provided that the results satisfy the USGS data quality objectives and quality assurance requirements in this statement of work. USGS advises potential contractors that analytical methods may require modification or optimization to meet these requirements.

Analyte Suggested analytical method

Reference and link

Li, Li Thermal ionization mass spectrometry (TIMS) Chen, 1987; Hall et al. 2005; Moriguti and

Nakamura, 1998

Sr, Sr Thermal ionization mass spectrometry (TIMS) Bullen et al., 1997, Vengosh et al., 2013, Warner et al., 2014

10B, 11B Thermal ionization mass spectrometry (TIMS) Vengosh et al.,, 1989; Dwyer and Vengosh, 2008, Warner et al., 2014

Trace elements Inductively coupled plasma mass spectrometry (ICP-MS) Fishman and Friedman, 1989; Faires, 1993;

Fishman, 1993; McLain, 1993; American Public Health Association, 1998;

Garbarino, 1999; Garbarino and others, 2006

Initial Demonstration of Proficiency

Prior to analyzing environmental samples for the USGS, the contract laboratory shall show initial proficiency in each method on the basis of historical analytical data for each analyte. Proficiency will be judged on an evaluation dataset consisting of at least 15 blanks and 15 concentrations above the method reporting limit. The laboratory shall submit any data they deem relevant to this demonstration with their offer in response to this solicitation. Blank, spike, and replicate sample results that were blind to the analyst are preferred.

During the period of this contract, if the contract laboratory chooses to change equipment or analytical methods, the initial demonstration of proficiency must be repeated at the contract laboratory’s expense, prior to analyses of environmental samples

2. Criteria for acceptance: USGS Program Data Quality Objectives (DQOs)

In addition to the QA/QC measures described later in this document, the USGS has established data-quality objectives (DQOs) that must be met to ensure that water-quality data can be used with confidence to assess ground-water chemistry in the State of California relative. These DQOs pertain to the required concentration range, laboratory bias, variability, and analyte recoveries listed below.

Concentration range. The required reporting limits for this contract are listed in the table below; these method reporting limits (MRLs) were selected based on human-health benchmarks for drinking water used by the US EPA and the State Water

Resources Control Board. The precision or analytical uncertainty that the contract laboratory is required to achieve is also listed. The Contractor can use MRLs that have been determined to be equal to or higher than method detection limits (MDLs) calculated using 40 CFR 136 Appendix B, or a more robust method. The analytical precision of the contract laboratory must be established and published in peer reviewed literature.

Analyte

U ni ts

Method

Reporting limit

Precision or reproducibilit y Lithium µg/L 0.42 --

Lithium isotopes permil Na ± 0.5

Boron µg/L 2.43 --

Boron isotopes permil

Na

± 0.5

Strontium µg/L 0.25 --

Strontium isotopes

Permil

Na

± 0.1

Trace elements µg/L 0.07-4 --

• Bias. The objective is that laboratory bias be less than the MDL for each target analyte, based on laboratory blank results.

• Variability. The objective is that the laboratory variability be less than 20 percent relative standard deviation, based on daily continuing calibration checks and replicate spike analyses in clean matrices.

• Analyte recoveries. The objective is that in laboratory spikes of reagent water, recoveries of target analytes must be within the control limits specified in the respective analytical methods.

Quality Assurance / Quality Control: USGS personnel will submit quality control

(QC) samples in addition to environmental samples; each type of field QC sample will constitute up to 10 percent of all samples analyzed. These QC samples will include field blanks and replicate samples. Other quality control samples may be submitted as needed to meet the USGS objectives. The contract laboratory shall analyze all QC samples using the same procedures and methods as for the environmental samples.

Samples shall be analyzed by the contract laboratory within holding times required by analytical methods. Sample bottles and preservatives provided by the contract laboratory will be quality- control checked by the contract laboratory.

Laboratory capability must be demonstrated on a continuing basis through initial and continuing calibration, annual MDL study, annual precision and accuracy study, annual analysis of performance-evaluation samples, and laboratory reagent blank and spike analysis. The laboratory shall document these activities and maintain a schedule to assure that each requirement is fulfilled annually. In addition to these measures, routine QA/QC must also include monitoring of surrogate recoveries where applicable and the analysis of environmental samples spiked with the target analytes by the contract laboratory.

• Initial calibration. For initial calibration, the contract laboratory shall use a minimum of 3 standards of differing concentrations. Calibration procedures shall follow established analytical protocols and be consistent with recommendations of the instrument manufacturer. The contract laboratory shall perform an initial calibration each time the instrument undergoes set up, major disruption, or installation of new materials that could affect analyte recoveries. The full calibration shall be verified or redone any time that a routine calibration check fails to meet the control limits specified in the analytical method.

• Continuing calibration. Continuing calibration checks, consisting of a low-range or mid-range standard, shall be analyzed once at the beginning of each analytical day or once at the beginning of each batch of analyses, whichever is more frequent. If recoveries of continuing calibration check standards fall outside of the control limits specified in the analytical method, corrective action shall be taken before continuing to analyze environmental samples.

• Annual MDL study. The contract laboratory shall determine or verify the method detection limit (MDL) for each analyte at least annually through the analysis of at least seven low- concentration replicates analyzed over at least a 3-day period, following EPA-accepted methods described in 40 CFR 136 Appendix B, or using any other published method that has been accepted by the USGS technical representative for these analyses in water samples.

• Annual precision and accuracy study. The contracting laboratory shall provide to USGS a compilation of the quality-control data at least annually and summarize method performance by indicating the precision (expressed as percent relative standard deviation or other appropriate metric) and accuracy (as mean percent recovery or other appropriate metric) for each analyte.

• Annual analysis of a third-party PT sample. The contract laboratory shall provide the results of third-party blind proficiency testing (PT) for the target analytes at least annually; at least one of the PT samples for each analyte must be in the range of expected environmental concentrations.

• Laboratory Reagent Blanks. The contract laboratory shall prepare laboratory reagent blanks (LRBs) using an appropriate matrix that has no concentrations of target analytes above the MDL. A LRB shall be analyzed once at the beginning of each analytical day or once at the beginning of each batch of analyses, whichever is more frequent. The initial

LRB results must be below the MDL or corrective action shall be taken before continuing to analyze environmental samples. Additional LRBs shall be analyzed, numbering one for every 20 analyses. If a target analyte is detected and identified in an LRB, quantitation of that same analyte in the environmental samples in that batch must be qualified. If the time needed for corrective action will cause samples to exceed holding times, the USGS must be contacted immediately.

B. Deliverables. USGS expects to submit as many as 30 samples per year; the number of samples may be as few as 1 sample per year.

USGS personnel will collect and ship environmental and quality control samples by overnight delivery to the contract laboratory, Monday through Friday. The contract laboratory must be able to receive samples on those days. Samples will be shipped on ice, in coolers supplied by the contract laboratory. USGS personnel will request the number of sample bottles needed, to be shipped to the designated USGS personnel in the coolers that will be used to ship the samples to the contract laboratory; the requested supplies must be shipped to arrive within 5 business days of the initial request. The contract laboratory will pay for the cost of shipping supplies to designated USGS personnel. The USGS will pay for the cost of shipping the samples to the contract laboratory. USGS will provide the environmental samples and the source water used for field blanks only.

To be supplied by contract laboratory:

• Sample Bottles

• Electronic version of an Analytical Request or Chain-of-Custody form to be sent in with samples that includes the contractor’s description of the analyses being requested and the

USGS sample identification information and appropriate field information.

• All reagents and equipment needed to complete the contract analyses. All reagents must be ACS grade or better.

Liaison

A company representative/project manager shall be assigned to this contract. This person will serve as a Point Of Contact familiar with USGS requirements and procedures. This

POC shall trouble shoot discrepancies in analytical requests forms, analytical requests, and sample information, make corrections, adjustments and updates to the contractor’s records at USGS request, and troubleshoot and catch errors prior to issuance of the final data package. The POC must respond to USGS inquiries, either by phone or email, within

1 business day.

Timeliness

Samples shall be analyzed within the holding times designated by the analytical methods, or within thirty (30) days of the sampling date, whichever is shorter. Hard copy data package and sample results and the electronic data in USGS format described below shall be sent to designated USGS personnel within thirty (30) days of analysis.

Data Delivery

The contracting laboratory shall provide the data deliverables in both hard copy and electronic format. The hard copy deliverable (data package) will include all results of sample analyses, including quality-control data (field blanks, source solution blanks, laboratory reagent blanks, , replicate analyses,), which will be reported as values of concentration or percent recoveries, identifying samples by contract laboratory sample numbers and USGS identification information (USGS site number, sample date, and sample time). The electronic deliverable will be sent in the format described in

Attachment 1 to designated USGS project personnel; this format may change as needed by the USGS. The contract laboratory will work with USGS representatives to resolve any problems in the reporting format between the contract laboratory and the USGS.

Results will be considered acceptable if the quality-control data listed above are provided with the sample results and after all data are reviewed by USGS project staff.

III. SUPPORTING INFORMATION

A. Place of Performance. Contractor’s Laboratory

B. Period of Performance: From Date of Award for Five Years

C. Government Furnished Property (GFP): No government property shall be furnished for this procurement.

D. Special Considerations. The contract laboratory shall comply with the Department of

Interior Information Security Requirements (Attachment 2).

Attachment 1. Electronic Data Deliverable Requirement for Contracting Labs

QWDATA tab-delimited batch-file format

Data transmittal for automated data loading into the U.S. Geological Survey’s Water-

Quality System (QWDATA) is done through the use of batch files. The batch processing utilizes two files: a sample-level batch file and a result-level batch file. In general, the sample-level file contains information about the sample-collection activity, such as the site identification number, sample collection date and time, and sample medium. The result-level file contains information about the individual analytical results. Each row in the result table contains the analytical result for one chemical constituent. The relationship between the two files is one-to-many; that is, a row of sample-level data may be related to many rows of result-level data.

The batch-format files are tab-delimited ASCII text files that require specific information to be displayed in specific fields. Each attribute must be separated from the previous attribute with a

<tab>. Missing attributes must have a <tab> inserted. Padding with blank characters to create fields with full-length entries is not necessary. The files are related through a surrogate primary key called the sample integer (SINT). The description of the format of the sample-level and result-level files follows.

Sample-level batch file:

The format of the sample-level batch file is defined in table 1. The contract laboratory shall supply the data fields identified as mandatory fields in table 1. The tab-delimited format is designed to accommodate 22 attributes for a row of data. Many of these attributes are specific to field-collection activities and are not required for the batch processing of laboratory data.

Therefore, these attributes do not need to be stored in a laboratory’s database and will not have values transmitted in the batch files. However, the positions must be held in the file, so a <tab> must be inserted to separate these fields. The file containing the sample information is usually named ‘qwsample.date.time’. The date.time tag on the file name should be identical to the date.time tag on the paired result-level batch file. The date.time tag is usually the creation date.time of the batch files.

Table 1: Sample-level batch file format

Colum n order

Attribute name

Description

Attribute Type

(maximum length, or required format)

Mandatory field for batch file

Supplied by

Sample Integer (SINT) Integer used to link sample and result information between the two batch files

Integer(18)

Yes

LAB

2 user code --- --- Leave blank ---

3 agency_cd Agency code Char(5) Leave blank ---

4 site_no Station identification number Char(15) Yes USGS

5 sample_start_dt Sample start date and time Date

(yyyymmddhhmm) Yes USGS

6 sample_end_dt Sample end date and time Date

(yyyymmddhhmm) Leave blank ---

7 medium_cd Medium code Char (1) Yes USGS

8 lab_no Lab identification number Char (7) Leave blank ---

9 project_cd Project code Char (9) Leave blank ---

10 aqfr_cd Aquifer code Char (8) Leave blank ---

11 samp_type_cd Sample type Char (1) Leave blank ---

12 anl_stat_cd Analysis status Char (1) Leave blank ---

13 anl_src_cd Analysis source Char (1) Leave blank ---

14 hyd_cond_cd Hydrologic condition Char (1) Leave blank ---

15 hyd_event_cd Hydrologic event Char (1) Leave blank ---

16 tu_id Tissue sample identifier Integer Leave blank ---

17 body_part_id Body part code Integer Leave blank ---

18 lab_sample_cm_tx Lab sample comment Varchar (300) Leave blank ---

19 field_sample_cm_tx Field sample comment Varchar (300) Leave blank ---

20 tz_cd Time-zone code Char (6) Leave blank ---

21 tm_datum_rlblty_cd Time-datum reliability code Char (1) Leave blank ---

22 coll_ent_cd Collecting agency code Char(8) Leave blank ---

Further information for the sample-level attributes follows:

Column 1: Sample integer (Mandatory, Primary Key)

The laboratory must generate the sample integer. This integer is critical for linking the sample- level data to the result-level data. The maximum length for this integer is 18 digits and they must be in sequential order in the file. This field is used only for batch processing and is not stored in

QWDATA.

Column 2: User code

Leave blank, but it must be separated with a <tab>.

Column 3: Agency code

Column 4: Station number (Mandatory)

Station number is an 8-digit or 15-digit number assigned to a sampling site. The field contains only numeric characters. The USGS personnel must supply the station number to the laboratory when samples are submitted for analysis.

Column 5: Begin date and time (Mandatory)

Begin date and begin time describe when the sample was collected (or the begin time for a sample that is collected over a range of dates and/or times). The date format is yyyymmdd. The time format is hhmm. These fields are concatenated together (not separated by a <tab>). The USGS personnel must supply this information to the laboratory when samples are submitted for analysis.

Column 6: End date and end time

Column 7: Medium code (Mandatory)

Medium code is the medium from which the sample was collected (i.e. surface water, ground water, sediment, tissue). This field has a valid domain in the QWDATA software.

The USGS personnel will supply a valid value for the medium code to the laboratory when samples are submitted for analysis.

Column 8: Lab number (NWQL)

Column 9: Project number

Column 10: Aquifer code

Column 11: Sample type

Column 12: Analysis status

Column 13: Hydrologic condition

Column 14: Hydrologic event

Column 15: Analysis source

Column 16: Tissue sample identifier

Column 17: Body part code

Column 18: NWQL Lab sample comment

Column 19: Field sample comment

Column 20: Time-zone code

Column 21: Time-datum reliability code

Column 22: Sample collecting agency code

Result-level batch file:

The result-level file includes analytical results and metadata for each analytical result. The contract laboratory shall supply the data fields identified as mandatory or conditional fields in table 2. The tab-delimited format is designed to accommodate 20 attributes for a row of data. The format of the result-level batch file is defined in table 2. The file containing the results information is usually named

‘qwresult.date.time’. The date.time tag on the file name should be identical to the date.time tag on the paired sample-level batch file. The date.time tag is usually the creation date.time of the batch files.

Table 2. Result-level batch file format

Colum n order

Column name

Format

Mandatory field for batch file

Supplied by

Sample Integer

(SINT)

Integer used to link sample and result information between the two batch files

Integer—up to 18 digits

Yes

2 parameter_cd Parameter code Char (5) Yes

USGS

3 result_va Result value Float Yes LAB

4 remark_cd Remark code Char (1) Conditional

5 qa_cd Quality-assurance code Char (1) Leave blank ---

6 meth_cd Method code Char (5) Yes

7 result_rd Rounding code Char (1) Leave blank ---

8 val_qual_cd Value qualifiers Char (3) Preferred

9 rpt_lev_va Report level Float Yes LAB

10 rpt_lev_cd Report level type Varchar (6) Yes

11 dqi_cd Data quality indicator Char (1) Leave blank ---

12 null_val_qual_cd Null-value qualifier Char (1) Conditional

13 prep_set_no Preparation set number Char (12) Preferred if applicable

LAB

14 anl_set_no Analytical set number Char (12) Preferred if applicable

LAB

15 anl_dt Analysis date Date (yyyymmdd) Preferred if applicable

LAB

16 prep_dt Preparation date Date (yyyymmdd) Preferred if applicable result_cm_tx

(where result_cm_tp =

L)

Laboratory result comment

Varchar (300)

Conditional result_cm_tx

(where result_cm_tp =

F)

Field result comment

Varchar (300)

Leave blank ---

19 lab_std_dev_va Laboratory standard deviation Float Leave blank ---

20 anl_ent_cd Analyzing entity code Char (8) Yes

1 LOOK-UP TABLE WILL BE PROVIDED BY USGS (SEE BELOW)

2 INFORMATION WILL BE PROVIDED BY USGS AND POPULATED BY CONTRACT LAB

Column 1: Sample integer (Mandatory)

The laboratory must generate the sample integer. This integer is critical for linking the result-level data to the sample-level data. The maximum length for this integer is 18 digits and the integers must be in sequential order in the file.

Column 2: Parameter code (Mandatory)

Each analytical result value must be reported with a parameter code that defines the constituent name, phase, reporting form, and reporting units. USGS personnel will provide a look-up table for use by the contract laboratory for the needed parameter codes.

Column 3: Result value (Mandatory)

The result value is a numeric value produced by an analytical method for a constituent. The field is stored as float. The contract laboratory must put the method reporting limit in this field if the result is a non-detect. The ‘#’ sign can be used to tell the software that the value is “null” (missing) if appropriate. The contract laboratory must supply a null value qualifier code if the contract laboratory sends a null value.

Column 4: Remark code (Only mandatory if result value is a non-detect, or null and null- value qualifier code is not supplied)

Remark codes provide additional information about the magnitude (or absence) of a value. A remark code is not required on every value; it is only required where it is needed to avoid misinterpretation of a value. If a remark is supplied, the remark code is viewed with the value for publication or data dissemination. A remark code of “<” is required for a non-detect. If the laboratory chooses to transmit null values, the laboratory must also provide a null value qualifier code (column 12) to identify why the value is missing. The remark codes are case sensitive. The remark codes are listed in table 3.

Table 3: Remark codes

Code Description

< Actual value is known to be less than the value shown.

> Actual value is known to be greater than the value shown.

E Value is estimated

Column 5: Quality-assurance code

Column 6: Method codes (Mandatory)

An analytical method is coded in the database by use of a five-character alphanumeric code in the method code field. The USGS personnel will supply the contract laboratory with a look-up table of the parameter code-method code pair that defines the chemical constituent and analytical method. When reported, method codes are all upper case.

Column 7: Result rounding code

Column 8: Value-qualifier codes (Preferred)

Value-qualifier codes provide additional qualifying information about the value. Up to three value qualifiers can be stored with any single result. The value qualifiers are case sensitive

(all lower case). If a contract laboratory supplies more than one value qualifier code, the individual codes are concatenated (not separated by <tab>s). Value-qualifier codes are not mandatory. The value- qualifier codes are listed in table 4.

Table 4. Value-qualifier codes

Value-qualifier codes

Raised reporting Level d Diluted sample: method high range exceeded q Insufficient sample received s Instrument sensitivity problem x Analyte interference from environmental sample matrix

Method Problems a Value was extrapolated above highest calibration standard, method range, or instrument linear range.

b Value was extrapolated below lowest calibration standard, method range, or instrument linear range f Sample field preparation problem. Problem described in result comment.

i Result may be affected by interference(s).

l Sample lab preparation problem. Problem described in result comment.

m Highly variable compound using this method, questionable precision and

(or) accuracy. Citation of OFR or NWQL Technical Memo in result comment. n Below the laboratory reporting level and above the long-term method detection level. o Result determined by alternate method. Reason described in result comment. t Below the long-term MDL.

w High variability: questionable precision and (or) accuracy. Cause explained in result comment. Rerun h Compound identification verified by rerun using a different method;

Alternate method identified in result comments.

p Value reported is preferred; explanation in result comments r Quantification verified by rerun using the same method u Value reported not confirmable due to interference y Sample variability described in result comments.

z Quantification verified by rerun using a different method

Other

+ Improper preservation.

@ Holding-time violation.

* Sample warm when received.

c See laboratory comments for this result e See field comments for this result v Analyte detected in laboratory blank

$ Used incorrect bottle type as requested

Column 9: Report level (Mandatory)

The report level is associated with the analytical method. This is usually the minimum value that is reported for the laboratory method at the time the sample is analyzed, based on some sort of statistical analysis of the method. If a value falls above this value, usually the value is reported without a remark code. If a report level is included in a batch file, a report-level type code must also be present. The USGS will confer with the contract laboratory liaison to make sure that this field is correctly populated.

Column 10: Report-level type code (Mandatory)

The report-level type code identifies the type of report level used for the method that is associated with the report level. If a report level type code is included in a batch file, a report level must also be present. The domain for the report level type code is shown in table 5. The USGS will confer with the contract laboratory liaison to make sure that this field is correctly populated.

Table 5. Report level type codes

Report-

Level Type

Code

Definition Description

MRL

Minimum

Reporting Level

Smallest measured concentration of a constituent that can be reliably measured using a given analytical method. Equivalent to method reporting limit as defined in this Statement of Work.

Blank

A blank report-level code should only be stored when no reporting level is stored. If a report level value is entered, a report level code must also be stored.

Column 11: Data-quality indicator code

Column 12: Null-value qualifier code (Only mandatory if result value is null and a null value remark code is not supplied)

The laboratory has the ability to transmit null results for a given parameter code. A null result means that a requested analytical procedure was not performed or the result was not quantified. If the laboratory chooses to transmit null values, the laboratory must also provide a null-value qualifier code or a null value remark code (M, Table 3) to identify why the value is missing. The one-character code is case sensitive (lower case). The domain for the null-value qualifier code is listed in table 6.

Table 6: Null-Value Qualifiers

Null-Value

Qualifiers

A Planned measurement was not made

B Sample broken/spilled in shipment

C Sample lost in lab

E Required equipment not functional or available F Sample discarded: improper filter used

I Required sample type not received

L Analysis discarded: low surrogate recovery M Results sent by separate memo

O Insufficient amount of water

P Sample discarded: improper preservation

Q Sample discarded: holding time exceeded

R Sample ruined in preparation

U Unable to determine due to matrix interference. W Sample discarded: warm when received.

X Failed quality-assurance review.

Column 13: Preparation set identifier (Preferred if applicable)

Preparation set identifier is a field used to store the set identification code of the preparation set at the laboratory. The field can be variable in length, up to a maximum of

12 characters. The field can contain mixed numeric and alpha characters. The preparation set identifier is not mandatory.

Column 14: Analysis set identifier (Preferred if applicable)

Analysis set identifier is a field used to store the set identification code of the analysis set at the laboratory. The field can be variable length, up to a maximum of 12 characters.

The field can contain mixed numeric and alpha characters. The analysis set identifier is not mandatory.

Column 15: Analysis date (Preferred if applicable)

The analysis date field is used to identify the date when an analysis was performed at the laboratory. The format of the date is yyyymmdd. The analysis date is not mandatory.

Column 16: Preparation date (Preferred if applicable)

The preparation date field is used to identify the date when a sample was prepared for analysis at the laboratory. The format of the date is yyyymmdd. The preparation date is not mandatory.

Column 17: Laboratory result comment (Only mandatory if appropriate)

Result lab comment is a free-form text field to hold information from the lab about a result that cannot be defined by the coded information in the system. This field is reserved for laboratory use. Laboratories can send text up to 300 characters in length.

Column 18: Field result comment

Column 19: Laboratory standard deviation Leave blank, but it must be separated with a <tab>.

Column 20: Analyzing entity (Mandatory)

The agency, organization, group, or company that analyzes the result is known as the analyzing entity.

This is an eight-character field used to identify the entity that analyzed the value for the parameter and method code listed. The USGS personnel must supply the laboratory with the appropriate code for the analyzing entity.

The following examples are provided to illustrate how the sample-level batch file (table 7) and the result-level batch file (table 8) look with test data populated in the fields.

Table 7: Sample-level batch file format example

Sam ple inte ger

(SI

NT)

U se r c o d e

A g e n c y c o

Site #

Sample begin date/tim

Sam pl e end date tim

Med iu m code

Lab

P r o j e c t c o

Aq ui fer co de

Sa m ple

Ty pe co de

Ana ly sis stat us cod e

An al ysi s sou rc e cod e

Hyd ro logi c con diti on cod

Hyd ro logi c even t cod

Tis su e

ID

B o d y p ar t c o d e

Lab sam pl e com m ent

Fiel d sam pl e com m ent

Ti m e-zo ne dat u m

Time datu m relia bili ty

Sam pl e colle cti ng agen cy

46244810

200105

WG

06334630 200106

WS

06334630 200106

WG

Table 8: Result-level batch file format example

Sample integer

(SINT)

Parameter

Result value

Re a r k c o

Q

A co de

QW

method

Ro u n d i n g c o

V alue qual ifier s

Report level

Report level

DQ

I cod e

Null value quali fier

Preparation set number

Analytical set number

Analysis date

Preparation date

Labor atory result comm ent

Fi el d re su lt co m

0200100376 00940 18 IC022 0.08 MRL 200114801 AKTO01150A 20010530 20010528

0200100376

00945

IC022

0.11

MRL

200114801

AKTO01150A

20010530

20010528 Instru ment run by

KRM

0200100376 01020 400 IP107 13 MRL 200114801 AKTO01150A 20010530 20010528

0200100945 00631 0.020 COL41 0.005 MRL 200115903 1200101162A 20010611 20010608

0200100945 00666 0.06 < KJ005 s 0.06 MRL 200115903 1200101162A 20010611 20010608

0200100945 00677 0.03 PHM04 0.01 MRL 200115903 1200101162A 20010611 20010608

0200100946 49258 # GC095 0.10 MRL r 200115903 GCMS162A 20010611 20010608

0200100946 39350 0.2 < GC096 0.10 MRL 200115903 GCMS162A 20010611 20010608

0200100946 39371 0.08 GC054 x i z

0.01 MRL 200115903 GCMS162A 20010611 20010608

Attachment 1 - Information Technology Security Requirements Summary

1. Background Investigation: Not applicable.

2. Non-disclosure Agreement: Not applicable.

3. Training: Not applicable.

4. Personnel Changes: Not applicable.

5. Contractor Location: Not applicable.

6. Applicable Standards: Not applicable.

7. Asset Valuation: Not applicable.

8. Property Rights: Not applicable.

9. Independent Verification and Validation (IV & V): Not applicable.

10. Certification & Accreditation: Not applicable.

11. Internet Logon Banner: Not applicable.

12. Incident Reporting :

Contractor employees must report any computer security incidents (viruses, intrusion attempts, system compromises, offensive e-mail, etc.) which may affect Government data or systems in accordance with the DOI Computer Incident Response Guide. Report computer security incidents to the USGS Point Of Contact.

13. Quality Control (Malicious Code) :

All electronic data files shall be free of malicious code.

14. Self Assessment: Not applicable.

15. Vulnerability Analysis: Not applicable.

16. Logon Banner: Not applicable.

17. Security Controls :

The Contractor shall be responsible for Information Technology security for all non-government- owned systems used in the development of and systems intended for eventual delivery to the USGS/DOI in fulfillment of contract requirements. This includes information technology, hardware, software, databases, networks, and telecommunications systems.

18. Contingency Plan: Not applicable.