B01_Attachment_4_Final_Reporting_Requirements_v2.docx

ATTACHMENT 4

FINAL REPORT and ELECTRONIC DATA DELIVERABLE (EDD) REQUIREMENTS Contractor data packages shall include the following documentation:

A. Complete Data Package (Submitted via PDF) – Data package shall comprise the following items:

a. Invoice for Services Rendered – Contractor shall submit a PDF of the invoice for each pick-up order/report submitted.

b. Case Narrative – A summary description of the analytical operations that occurred during sample receipt and analyses. Case narrative should include quality control activities and actions take by lab personnel to eliminate problem areas identified during sample analyses.

c. Analysis report forms – These forms contain the results from measurement of those chemical parameters that are requested and specified in the Pickup Order/Delivery Order. Data are to be identified by the DCPH-A Lab ID number and the corresponding field number.

d. Sample Receipt Documentation – sample receipt logs, temperature logs, pickup order forms, COC forms.

e. Quality Control Data Summary – This section shall include data from spikes, duplicates, blinds, reagent blanks, system calibrations, etc.

f. Raw data for analytical measurements to include the following:

i. Chemical parameter analyzed; NIOSH, OSHA, or other method description; date of analysis of samples.

ii. Calibration and stock standards (including method of preparation and standardization) with accompanying readings.

iii. Summary sheet to include: designation of samples by DCPH-A number

iv. Summary sheets for quality control samples

v. Any instrument adjustments to include periodic base line adjustments or adjustments in attenuation/sensitivity.

vi. Copies of instrument print outs as applicable

vii. Calculation sheet clearly describing how positive results were calculated.

viii. Tabulation of instrument detection/Limit of Quantitation (LOQ) which have been determined by the contract laboratory and reported on Data Report Form. (Raw data must show that at least one standard was analyzed at or below detection limit for data to be valid).

B. PDF Instructions for the Complete “FINAL” Data Package – This PDF document will include the entire data package as described above, minus the invoice. Please provide the invoice via PDF as a separate file from Final report. Final package PDF and invoice PDF are emailed to the following addresses: DHA APG Pub Health - A Mailbox LAB COR at dha.apg.Pub-Health- A.mbx.lab-cor@health.mil and DHA APG Pub Health - A Mailbox DLS-Contract-Hardcopies at dha.apg.Pub-Health-A.mbx.dls-contract-hardcopies@health.mil C. These will be due no later than 2:00 PM Eastern Time on the due date specified on the Pick-up Order. Naming convention of hard copy file and invoice should at least include the lab queue (acronym) and the DCPH-A Pick up Order number, both of which will be provided on the documentation.

D. Preliminary Sample Analysis Results (pdf file) – If a Level-2 data package is delivered within the initial 8-day Turn Around Time (TAT), then a grace period will be granted, up to 7 calendar days, before the final delivery of the Level-4 data package. These preliminary pdfs will contain final, numerical results in appropriate units, for the requested chemical parameters. Sample data shall be identified by DCPH-A Lab number and field ID number.

E. Electronic Data Deliverable (EDD) - The electronic data deliverable (EDD) and Final PDF report are REQUIRED to be derived from the same source. Information (sample numbers, field numbers, etc) and data (analytical results, units) must match. The process that generates the final report and EDD is REQUIRED to be validated to demonstrate that the process provides identical information and data.

Analytical Contract Lab Electronic Data Deliverables (EDD) Specifications Microsoft Access 2010 Format Electronic Data Deliverable (EDD) The electronic copy of the results is commonly referred to as the contract Electronic Data Deliverable or EDD.

The (EDD) and Final PDF reports are required to use and have the same information (sample numbers, field ID numbers, etc.) and data (analytical results, units). The process that generates the final report (pdf) and EDD is required to be validated to demonstrate that the process provides identical information and data.

The EDD will contain final, numerical results (concentrations) in appropriate units, with quantitation limits, for the requested chemical parameters. Sample data shall be identified by DCPH-A (prov) lab numbers. Please note that the contractor shall transfer the data electronically from their lab to the DCPH- A (prov) lab via the INTERNET using the file format described below:

EDD File Requirements The data must be saved as a Tab-deliminted text (.txt) file.

File Naming Convention The database containing the EDD should be named using the following format: Pickup Order #.txt Example 1. The EDD for Pickup Order 3 / Delivery Order 10 would be as follows: P3.txt Example 2. The EDD for Pickup Order 15 / Delivery Order 5 would be as follows: P15.txt

Contents of the tab delimited EDD file

The following table lists the fields in the tab delimited file along with the data type, the maximum size in characters and a description.

Tab Delimited EDD Line Specifications:

DELIMITER

Tab character (ASCII 9) is used as field separator, even if proceeding field is null

DELIMITER

Tab character (ASCII 9) is used as field separator, even if proceeding field is null

DELIMITER

Tab character (ASCII 9) is used as field separator, even if proceeding field is null

DELIMITER

Tab character (ASCII 9) is used as field separator, even if proceeding field is null

DELIMITER

Tab character (ASCII 9) is used as field separator, even if proceeding field is null

DELIMITER

Tab character (ASCII 9) is used as field separator, even if proceeding field is null

DELIMITER

Tab character (ASCII 9) is used as field separator, even if proceeding field is null

DELIMITER

Tab character (ASCII 9) is used as field separator, even if proceeding field is null

DELIMITER

Tab character (ASCII 9) is used as field separator, even if proceeding field is null

DELIMITER

Tab character (ASCII 9) is used as field separator, even if proceeding field is null

DELIMITER

Tab character (ASCII 9) is used as field separator, even if proceeding field is null

DELIMITER

Tab character (ASCII 9) is used as field separator, even if proceeding field is null

DELIMITER

Tab character (ASCII 9) is used as field separator, even if proceeding field is null

LINE TERMINATORS

Each line is terminated by a carriage return (ASCII 13) and a line feed (ASCII 10)

File Delivery The EDD file should be emailed to the following address: dha.apg.Pub-Health-A.mbx.dls-contract-data@health.mil Questions or comments regarding this guidance should be addressed to the COR.