The file's text, extracted by GovTribe without its formatting.
RFP-25-81029
ATTACHMENT K
ELECTRONIC DATA REPORTING STANDARDS
EDI FORMAT DESCRIPTION
TC "INTRODUCTION" \f A \l "1" This document identifies the Laboratory Results electronic reporting format required by the Indiana Department of Environmental Management - Office of Water Quality, Watershed Assessments and Planning Branch.
The general layout is "pipe-delimited". There are several different record types, which are defined in separate sections in this document. Record type is specified in the first field of every record (Record ID). Details are as listed below:
Naming Conventions:
n = place holder for a Decimal Number (0-9)
X = place holder for text/other
M = place holder for a "Month" or "Minute" number
D = place holder for a "Date" number
Y = place holder for a "Year" number
H = place holder for an "Hour" number
S = place holder for a "Second" number
The file MUST BE SAVED in MS-DOS Text format.
Field names in Bold Red are Required fields.
Use the following Table for selection of Units:
UnitValue Comments
CFU/100mL Colony Forming Units / 100 mL MPN/100mL Most Probable Number / 100mL g/cm3
Density mg/Kg dw Dry Weight mg/L milligrams/Liter (Water)
NTU
Turbidity units
SU
pH units ug/Kg dw Dry Weight ug/L micrograms/Liter (Water) umho/cm Conductivity
Percent umoles/g Molar Ratio for SEM pg/L picograms/Liter (Water)
%Recov % Recovery
°C
Degrees Celsius
AMU
Atomic Mass Units ug/Kg ww Wet Weight mg/Kg ww Wet Weight ng/L nanograms/Liter (Water)
Ratio to be used for Ratios without Units
DO NOT USE ANY OTHER UNITS WITHOUT PRIOR APPROVAL FROM IDEM/OWQ.
Use dry weight (dw) units for ALL sediment parameters unless specifically told otherwise by IDEM/OWQ.
Use wet weight (ww) units for ALL fish tissues parameters unless specifically told otherwise by IDEM/OWQ.
Recent Revisions to this Document: TC "Recent Revisions to this Document:" \f A \l "1"
| 5/18/2021 |
| Added Dup_MDL and DUP_MDL_Units to QC tables. This has been in the EDI since 2009 |
| 5/30/2019 |
| Updated contacts |
| 3/1/2017 |
| Added notes to show which fields are required fields for each record type. Required Fields are Bold in Red. |
| 02/01/2016 |
| Updated contact information for Technical Logistics and Services section chief. Corrected footnotes for Narrative Records. |
| 06/05/2009 |
| Added Method Detection Limit and Method Detection Limit Units to DS and QC records |
| 6/10/2005 |
| Added language clarifying selections from Units Table (page i) and the Note in Result Field in Sample Number Record (page 5). |
| 6/28/2004 |
| Updated units for coliforms |
| 12/11/2003 |
| Added descriptions for Dup_Reporting_Limit and Dup_Reporting_Limit_Units in the QC records where duplicates may be present. (DU, LC, MS) |
| 5/15/2003 |
| Merged EDI Export format Description with this document. |
| 12/5/2002 |
| Redefined Sample_Medium_ID where ‘F’ is Biological Tissues including Fish & Plants |
| 10/30/2002 |
| Corrected Typos |
| 6/12/2002 |
| This format is to be used for Lakes Data and Field Data. |
Added Sample_Depth, and Sample_Depth_Units to Sample Number Header/Footer Records.
Added Descriptions for Field Data Records.
These additional fields are only required if the EDI includes Lakes data or Field Measured Data (Dissolved oxygen, pH, Water Temperature, Specific conductivity, Turbidity, % Saturation, Chloride, Chlorophyll-a, or Weather Codes)
| 5/2/2002 |
| Altered unique combination for QC records to CAS_Number + CAS_Num_Qualifier +Test_Method +Test_SubMethod + Sample_Medium_ID + RECORD_ID + RUN_BATCH_NUM + LAB_SAMPLE_NUM (See note on Page 10) |
Added units ng/L and Ratio to accepted units list.
| 3/25/2002 |
| Added language Clarifying the Measure_Flags field in QC records is to record the QC Flag for the QC sample and not the regular sample. |
| 3/12/2002 |
| Added the reporting limit and reporting limit units fields to QC records. Modified examples to reflect the additional fields. |
Added instructions for reporting results below the Min. Reporting Limit or above the Max. Reporting Limit (see Sample Number Record Description) to QC Records Measured_Value, Dup_Measure_Value, True_Value
| 6/11/2001 |
| Added instructions for reporting results below the Min. Reporting Limit or above the Max. Reporting Limit (see Sample Number Record Description). |
Added instructions for Lab_Sample_Num, Run_Batch_Num, or Prep_Batch_Num in Project Narrative Header/Footer Records.
Added Table for selection of Units.
Updated Table of Contents page references for QC Record types: IB, IC, CB, SI, LR
| 4/19/2001 |
| Added Sample_Medium_ID to Sample Number and QC Header Records |
| 3/28/2001 |
| Added instructions in Sample Number Record for Results exceeding the maximum reporting limit for a test. Added Note in QC Records emphasizing each record must have a unique combination of : |
CAS_Number + CAS_Num_Qualifier +Test_Method +Test_SubMethod + Sample_Medium_ID + RECORD_ID + RUN_BATCH_NUM + RUN_DATE + RUN_TIME+LAB_SAMPLE_NUM Added Descriptive format for Bacteriological QC Records: KP, PA, EC.
Revised Real World Example (final page).
Revised Descriptions for Sample Narrative & Added a Table of Contents
| 2/26/2001 |
| Added MS-DOS Text format requirement to the file requirements. |
| 2/20/2001 |
| Corrected Omissions in Format and Examples in record descriptions (pg. 15) |
| 2/7/2001 |
| Added Dup_Dilution_Mult to Lab QC Records & properly referenced Serial Dilutions in ‘Duplicate’ QC Records. |
| 2/1/2001 |
| Added choice of ‘Free’ to CAS_Num_Qualifier |
| 1/29/2001 |
| Replaced Date & Time of file/batch creation with Date_Rec (Date analysis set received by lab) and Time_Rec (Time analysis set received by lab) in: |
1) Analysis Set Header/Footer Records 2) Sample Number Header/Footer Records
Added Sample_Medium_ID to Analysis Set Header/Footer Records.
| 1/10/2001 |
| Added File Revision Date to this Document. |
TABLE OF CONTENTS TC "TABLE OF CONTENTS" \f A \l "1"
1INTRODUCTION
TABLE OF CONTENTS
EDI Submission Set Header/Footer Records:
Analysis Set Header/Footer Records:
Sample Number Header/Footer Records:
Sample Number Records:
Field Data Records:
Project Narrative Header/Footer Records Project Narrative Data Record:
QC Header/Footer Records:
Lab QC Records: General Format Description Lab QC Records: Format for QC Records of following types: ‘Blank’, ‘Initial Calibration Blank’, or ‘Continuing Calibration Blank’ Lab QC Records: Format for QC Records of following types: Continuing Calibration Verification, Initial Calibration Standard, Linear Upper Range Standard, or Spectral Interference Check Standard Lab QC Records: Format for ‘Duplicate’ or ‘Serial Dilution’ QC Records Lab QC Records: Format for ‘Matrix Spike’, ‘Matrix Spike Duplicate’ Records Lab QC Records: Format for Records of following types: ‘Control Spike’, ‘Internal Standard’, ‘Laboratory Control Standard’, ‘Surrogate Standard’ Lab QC Records: Format for Records of following types: ‘Tuning Standard’ Lab QC Records: Format for Records of following types: ‘Neg. E. Coli, Pos Coliform (KP)’, ‘Negative Coliform (PA)’, ‘Positive E. Coli (EC)’ Example for a complete batch transmission file:
Another Example for a complete batch transmission file:
EDI Export Format Description
TC "EDI Submission Set Header/Footer Records" \f A \l "1" EDI Submission Set Header/Footer Records:
The EDI Submission Set Header Record is placed prior to the first line of an EDI Transmission file. An EDI Submission Set Footer Record is placed after the last line of the file, forming a matched pair.
| Field Name |
| Description |
| Format |
| Example |
| Record_ID |
| Identifies EDI Submission Set Header Record (“HE”) |
Or – EDI Submission Set Footer Record (“FE”)
| Lab_ID |
| Name of Lab Submitting Lab Analysis Data Results |
| XXXXXXXX |
| ISDH |
| Date |
| Date of file/batch creation |
| MMDDYYYY |
| 11191999 |
| Time |
| 24-Hour Time of file/batch creation |
| HHMMSS |
| 220156 |
| Count |
| Number of Records in this file, excluding EDI Submission Set Header and Footer Lines |
| nnnnn |
| 43 |
Record_ID|Lab_ID|Date|Time|Count|
Description Example:
HE|XXXXXXXX|MMDDYYYY|HHMMSS|NNNNN|
Real World Example:
HE|ISDH|11191999|220156|43|
(EDI Submission Set Header Record)
----Analysis Set1 Header Record---
----Sample Number1 Header Record---
----Sample Number1 Records---
----Sample Number1 Footer Record---
----Sample Number2 Header Record---
----Sample Number2 Records---
----Sample Number2 Footer Record---
----Narrative1 Header Record---
----Narrative1 Records---
----Narrative1 Footer Record---
----Narrative2 Header Record---
----Narrative2 Records---
----Narrative2 Footer Record---
----QC Header Record---
----QC Records---
----QC Footer Record---
----Analysis Set1 Footer Record---
----Analysis Set2 Header Record---
----Sample Number Header Record---
----Sample Number Records---
----Sample Number Footer Record---
----Narrative Header Record---
----Narrative Records---
----Narrative Footer Record---
----QC Header Record---
----QC Records---
----QC Footer Record---
----Analysis Set2 Footer Record---
FE|ISDH|11191999|220156|43|
(EDI Submission Set Footer Record)
TC "Analysis Set Header/Footer Records" \f A \l "1" Analysis Set Header/Footer Records:
Analysis Set Header Records are placed prior to the first line of an Analysis Set Batch. An Analysis Set Footer Record is placed after the last line of the Analysis Set Batch, forming a matched pair.
| Field Name |
| Description |
| Format |
| Example |
| Record_ID |
| Identifies Analysis Set Header Record (“HA”) |
Or – Analysis Set Footer Record (“FA”)
| Lab_ID |
| Name of Lab Submitting Lab Analysis Data Results |
| XXXXXXXX |
| ISDH |
| Lab_Job_Num |
| Number used internally by Lab to identify the entire group of samples being analyzed for IDEM |
| XXXXXXXX |
| BB345678 |
| OWQ_Analysis_Set |
| IDEM Assigned Analysis Set Number |
| XXXXXXXX |
| 00TSW190 |
| Analysis_Set_SubmitCount |
| On first submission of analysis set test results, =1; |
if samples are re-analyzed & re-submitted, =2 (or 3 for a 2nd re-analysis/submittal, etc.)
| Sample_Medium_ID |
| What is the medium of the sample being tested? (W=Water, S=Sediment, or F=Biological Tissues such as Fish) |
| X |
| W |
| Date_Rec |
| Date Analysis Set Received by Lab |
| MMDDYYYY |
| 11191999 |
| Time_Rec |
| 24-Hour Time Analysis Set Received by Lab |
| HHMMSS |
| 220156 |
| Count |
| Number of Data Records in this batch (related to this specific Analysis Set Header Record) |
| nnnnnn |
| 43 |
Record_ID|Lab_ID|Lab_Job_Num|OWQ_Analysis_Set|Analysis_Set_SubmitCount| Sample_Medium_ID | Date_Rec|Time_Rec|Count|
HA|XXXXXXXX| |XXXXXXXX|XXXXXXXX|NN|X|MMDDYYYY|HHMMSS|NNNN|
Real World Example:
HA|ISDH| |BB345678|00TSW190|1|W|11191999|220156|43|
(Analysis Set Header Record)
----Sample Number1 Header Record---
----Sample Number1 Records---
----Sample Number1 Footer Record---
----Sample Number2 Header Record---
----Sample Number2 Records---
----Sample Number2 Footer Record---
----Narrative1 Header Record---
----Narrative1 Records---
----Narrative1 Footer Record---
----Narrative2 Header Record---
----Narrative2 Records---
----Narrative2 Footer Record---
----QC Header Record---
----QC Records---
----QC Footer Record---
FA|ISDH| |BB345678|00TSW190|1|11191999|220156|43|
(Analysis Set Footer Record)
TC "Sample Number Header/Footer Records" \f A \l "2" Sample Number Header/Footer Records:
Sample Number Header Records are placed prior to the first line of a Sample Number’s lab analysis result set. A Sample Number Footer Record is placed after the last line of the Sample Number record, forming a matched pair.
| Field Name |
| Description |
| Format |
| Example |
| Record_ID |
| Identifies Sample Number Header Record (“HS”) |
Or – Sample Number Footer Record (“FS”)
| Lab_ID |
| Name of Lab Submitting Lab Analysis Data Results |
| XXXXXXXX |
| ISDH |
| Sample_ID |
| IDEM assigned Sample ID |
| XXnnnnn |
| DA12345 |
| Sample_Medium_ID |
| What is the medium of the sample being tested? (W=Water, S=Sediment, or F=Biological Tissues such as Fish) |
| X |
| W |
| Lab_Sample_Num |
| Number used internally by Lab to identify IDEM Sample being analyzed |
| XXXXXXXX |
| AA345678 |
| Lab_Job_Num |
| Number used internally by Lab to identify the entire group of samples being analyzed for IDEM |
| XXXXXXXX |
| BB345678 |
| OWQ_Analysis_Set |
| IDEM Assigned Analysis Set Number |
| XXXXXXXX |
| 00TSW190 |
| Analysis_Set_SubmitCount |
| On first submission of analysis set test results, =1; |
if samples are re-analyzed & re-submitted, =2 (or 3 for a 2nd re-analysis/submittal, etc.)
| Date_Rec |
| Date Analysis Set Received by Lab |
| MMDDYYYY |
| 11191999 |
| Time_Rec |
| 24-Hour Time Analysis Set Received by Lab |
| HHMMSS |
| 220156 |
| Count |
| Number of Data Records in this batch (related to this specific Header Record) |
| nnnn |
| 43 |
| Sample_Depth |
| Depth the sample was taken in meters |
(Use 0 for surface water samples)
| Sample_Depth_Units |
| Units for Sample_Depth (leave blank if Sample_depth is not used) |
| XXX |
| m |
Record_ID|Lab_ID|Sample_ID|Sample_Medium_ID|Lab_Sample_Num|Lab_Job_Num|OWQ_Analysis_Set| Analysis_Set_SubmitCount|Date_Rec|Time_Rec|Count|Sample_Depth|Sample_Depth_Units|
HS|XXXXXXXX|XXNNNNN|X|XXXXXXXX|XXXXXXXX|XXXXXXXX|NN|MMDDYYYY|HHMMSS|NNNN|NNNN|XXX|
Real World Examples:
HS|ISDH|DA12345|W|AA345678|BB345678|00TSW190|1|11191999|220156|3|
(Sample Number1 Header Record)
----Sample Number Record1---
----Sample Number Record2---
----Sample Number Record3---
FS|ISDH|DA12345|W|AA345678|BB345678|00TSW190|1|11191999|220156|3|
(Sample Number1 Footer Record)
HS|ISDH|DA54321|S|345678|363783|00TSW190|1|11191999|142112|2|
(Sample Number2 Footer Record)
----Sample Number2 Record1---
----Sample Number2 Record2---
FS|ISDH|DA54321|S|345678|363783|00TSW190|1|11191999|142112|2|
(Sample Number2 Footer Record)
Sample Number Record: TC "Sample Number Record:" \f A \l "2"
| Field Name |
| Description |
| Format |
| Example |
| Record_ID |
| Identifies Field Data Record |
| "DS" |
| DS |
| Lab_Sample_Num |
| Number used internally by Lab to identify IDEM Sample being analyzed |
| XXXXXXXX |
| AA345678 |
| CAS_Number |
| CAS # of substance being tested for |
| XXXXXXXXXX |
| 257301-77-2 |
| CAS_Num_Qualifier |
| Does this record show the substance’s value as ‘Total’ (=T), ‘Dissolved’ (=D), ‘Free’ (=F), or ‘Simultaneously Extracted Metals’ (SEM) (=S)? |
| “T”, “D”, “F”, or ”S” |
| T |
| Test_Method |
| Test method used by lab |
| XXXXXXXXXX |
| 200.7 |
| Test_SubMethod |
| Identifies Method's elective process when it produces different MDL (as in 200.8; others possible). Potential Values: 'N/A'=No Sub-Method; ‘SCAN’=Scanning Mode; ‘SIM’=Selection Ion Monitoring Mode |
| "N/A”, “SCAN", or "SIM" |
| SCAN |
| Sample_Medium_ID |
| What is the medium of the sample being tested? (W=Water, S=Sediment, or F=Biological Tissues such as Fish) |
| X |
| W |
| Report_Limit |
| Lab’s Reporting limit for test (Method Reporting Limit X Dilution Multiplier) or if Result exceeds the Maximum Reporting Limit enter Maximum Reporting Limit X Dilution Multiplier) |
| nnnnnnnn.nnnn |
| 5.0 |
| Report_Limit_Units |
| Lab Reporting limit units (see page 1 for selection of units.) |
| XXXXX |
| ug/l, mg/kg |
| Result |
| Parameter test result |
Use the following if the results are between the Method Detection Limit (MDL) and the Min. Reporting Limit (MRL):
Case 1 (Actual Values Requested) then use the Actual value measured
Case 2 (Actual Values Not Requested) then use “-1”
In Case 1 and Case 2, include ‘<’ in the Result_Flags field.
if the Result exceeds the Max. Reporting Limit, then use ‘-2’ in the Result field and include ‘>’ in Result_Flags field.
| Result_Units |
| Result Units (see page 1 for selection of units.) |
| XXXXX |
| ug/l, mg/kg |
| Result_Flags |
| Lab Flags for this record (Labs must provide cross-reference of flag codes and interpretations; IDEM will incorporate into translation table) Use “<” symbol if Result is less than Reporting Limit and use “>” if Result exceeds the Maximum Reporting Limit. |
| XXXXX |
| <gx |
| Prep_Batch_Num |
| Lab-Internal Alphanumeric identifier indicating batch within which sample was prepped |
| XXXXXXXX |
| 768 |
| Prep_Date |
| Date sample prepped (if applicable) |
| MMDDYYYY |
| 12251999 |
| Prep_Time |
| 24-Hour Time sample prepped for analysis (if applicable) |
| HHMMSS |
| 163403 |
| Prep_Method |
| Prep Method Used (if applicable) |
| XXXXXXXXXX |
| 3050 |
| Run_Batch_Num |
| Lab-Internal Alphanumeric identifier indicating batch within which sample was analyzed |
| XXXXXXXX |
| 8043 |
| Run_Date |
| Date Field Measurements Taken |
| MMDDYYYY |
| 12251999 |
| Run_Time |
| 24-Hour Time Field Measurements Taken |
| HHMMSS |
| 163403 |
| Dilution_Mult |
| Number indicating dilution magnitude required for analysis |
| nnnn |
| 10 |
| Lab_MDL |
| Lab’s Detection limit for test (Method Detection Limit X Dilution Multiplier |
| nnnnnnnn.nnnn |
| 5.0 |
| Lab_MDL_Units |
| Lab Detection limit units (see page 1 for selection of units.) |
| XXXXX |
| ug/l, mg/kg |
Record Format (in actual data records, all on one line):
Record_ID|Lab_Sample_Num|CAS_Number|CAS_Num_Qualifier|Test_Method|Test_SubMethod|Sample_Medium_ID|Report_Limit| Report_Limit_Units|Result|Result_Units|Result_Flags|Prep_Batch_Num|Prep_Date|Prep_Time|Prep_Method| Run_Batch_Num|Run_Date|Run_Time|Dilution_Mult|Lab_MDL|Lab_MDL_Units| Description Example:
DS|XXXXXXXX|XXXXXXXXXX|X|XXXXXXXXXX|XXXX|X|NNNNNNNN.NNNN|XXXXX|NNNNNNNN.NNNN|XXXXX|XXXXX| XXXXXXXX|MMDDYYYY|HHMMSS|XXXXXXXX|XXXXXXXX|MMDDYYYY|HHMMSS|NNNN|NNNNNNNN.NNNN|XXXXX| Real World Examples:
DS|AA345678|257301-77-2|T|200.7|N/A|W|1.0|ug/l|8.1|ug/l|<gx|768|12251999|163403|3050|8043|12251999|163403|10|0.3|ug/l| DS|AA345678|257301-77-2|T|200.7|N/A|W|1.0|ug/l|8.1|ug/l|<gx| | | ||8043|12251999|163403|10|0.3|ug/l|
Field Data Record: TC "Field Data Record:" \f A \l "2"
| Field Name |
| Description |
| Format |
| Example |
| Record_ID |
| Identifies Field Data Record |
| "DS" |
| DS |
| Lab_Sample_Num |
| Number used internally by Lab to identify IDEM Sample being analyzed |
| XXXXXXXX |
| AA345678 |
| CAS_Number |
| CAS # of substance being tested for |
| XXXXXXXXXX |
| E-14539 |
| CAS_Num_Qualifier |
| Does this record show the substance’s value as ‘Total’ (=T), ‘Dissolved’ (=D), ‘Free’ (=F), or ‘Simultaneously Extracted Metals’ (SEM) (=S)? |
| “T”, “D”, “F”, or ”S” |
| D |
| Test_Method |
| Test method used by Field Sampler |
| XXXXXXXXXX |
| SM4500-OG |
| Test_SubMethod |
| Identifies Method's elective process when it produces different MDL (as in 200.8; others possible). Potential Values: 'N/A'=No Sub-Method; ‘SCAN’=Scanning Mode; ‘SIM’=Selection Ion Monitoring Mode |
| "N/A”, “SCAN", or "SIM" |
| N/A |
| Sample_Medium_ID |
| What is the medium of the sample being tested? (W=Water, S=Sediment, or F=Biological Tissues such as Fish) |
| X |
| W |
| Report_Limit |
| Lab’s Reporting limit for test (Method Reporting Limit X Dilution Multiplier) or if Result exceeds the Maximum Reporting Limit enter Maximum Reporting Limit X Dilution Multiplier) |
| nnnnnnnn.nnnn |
| 0.01 |
| Report_Limit_Units |
| Lab Reporting limit units (see page 1 for selection of units.) |
| XXXXX |
| mg/L |
| Result |
| Parameter test result |
(If the results are between the Method Detection Limit and the Min. Reporting Limit. Include “<” symbol in Result_Flags field and use the actual value measured, if actual values have been requested, or ‘-1’ in the result field.
Include ‘>’ in Result_Flags field and use ‘-2’ in the Result field if the Result exceeds the Max. Reporting Limit.
| Result_Units |
| Result Units (see page 1 for selection of units.) |
| XXXXX |
| mg/L |
| Result_Flags |
| Lab Flags for this record (Labs must provide cross-reference of flag codes and interpretations; IDEM will incorporate into translation table) Use “<” symbol if Result is less than Reporting Limit and use “>” if Result exceeds the Maximum Reporting Limit. |
| XXXXX |
| <gx |
| Prep_Batch_Num |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Prep_Date |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Prep_Time |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Prep_Method |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Run_Batch_Num |
| Lab-Internal Alphanumeric identifier indicating batch within which sample was analyzed |
| XXXXXXXX |
| 8043 |
| Run_Date |
| Date analysis run |
| MMDDYYYY |
| 12251999 |
| Run_Time |
| 24-Hour Time analysis run |
| HHMMSS |
| 163403 |
| Dilution_Mult |
| Number indicating dilution magnitude required for analysis |
| nnnn |
| 1.0 |
| SampleDepth |
| Water depth at which sample collected. |
| nnnnn.n |
| 0.0 |
| Lab_MDL |
| Lab’s Detection limit for test (Method Detection Limit X Dilution Multiplier |
| nnnnnnnn.nnnn |
| 5.0 |
| Lab_MDL_Units |
| Lab Detection limit units (see page 1 for selection of units.) |
| XXXXX |
| ug/l, mg/kg |
Record_ID|Lab_Sample_Num|CAS_Number|CAS_Num_Qualifier|Test_Method|Test_SubMethod|Sample_Medium_ID|Report_Limit| Report_Limit_Units|Result|Result_Units|Result_Flags|Prep_Batch_Num|Prep_Date|Prep_Time|Prep_Method| Run_Batch_Num|Run_Date|Run_Time|Dilution_Mult| SampleDepth|Lab_MDL|Lab_MDL_Units| Description Example:
DS|XXXXXXXX|XXXXXXXXXX|X|XXXXXXXXXX|XXXX|X|NNNNNNNN.NNNN|XXXXX|NNNNNNNN.NNNN|XXXXX|XXXXX| XXXXXXXX|MMDDYYYY|HHMMSS|XXXXXXXX|XXXXXXXX|MMDDYYYY|HHMMSS|NNNN|NNN.NNNN|NNNNNNNN.NNNN|XXXXX| Real World Examples:
DS|AA345678|257301-77-2|T|200.7|N/A|W|1.0|ug/l|8.1|ug/l|<gx|768|12251999|163403|3050|8043|12251999|163403|10| 0.3|ug/l| DS|AA345678|257301-77-2|T|200.7|N/A|W|1.0|ug/l|8.1|ug/l|<gx| | | ||8043|12251999|163403|10|0| 0.3|ug/l|
TC "Project Narrative Header/Footer Records" \f A \l "2" Project Narrative Header/Footer Records
Project Narrative Header Records are placed prior to the first line of a Project Narrative. Project Narrative Footer Record is placed after last line of the Project Narrative, forming a matched pair.
| Field Name |
| Description |
| Format |
| Example |
| Record_ID |
| Identifies Project Narrative Header Record (“HN”) Or – Project Narrative Footer Record (“FN”) |
| "HN" |
| HN |
| Lab_ID |
| Name of Lab Submitting Lab Analysis Data Results |
| XXXXXXXX |
| ISDH |
| Lab_Job_Num |
| Number used internally by Lab to identify the entire group of samples being analyzed for IDEM |
| XXXXXXXX |
| BB345678 |
| OWQ_Analysis_Set |
| IDEM Assigned Analysis Set Number |
| XXXXXXXX |
| 00TSW190 |
| Analysis_Set_SubmitCount |
| On first submission of analysis set test results, =1; |
if samples are re-analyzed & re-submitted, =2 (or 3 for a 2nd re-analysis/submittal, etc.)
Lab_Sample_Num
| Number used internally by Lab to identify IDEM Sample being analyzed |
| XXXXXXXX |
| AA345678 |
Prep_Batch_Num
| Lab-Internal Alphanumeric identifier indicating batch within which sample was prepped |
| XXXXXXXX |
| 768 |
Run_Batch_Num
| Lab-Internal Alphanumeric identifier indicating batch within which sample was analyzed |
| XXXXXXXX |
| 8043 |
| Refer_Record_ID |
| Record_ID describing type of record being referred to (“DS”, “CC”, “BL”, “LC”, “CS”, “SS”, “IS”, “MS”, or “DU”) – for definitions, see the Record_ID field in the Sample Number Record and Lab QC Records: General Format Description sections of this document. |
| XX |
| DS |
| CAS_Number |
| CAS # of substance being tested for |
| XXXXXXXXXX |
| 257301-77-2 |
| CAS_Num_Qualifier |
| Does this record show the substance’s value as ‘Total’ (=T), ‘Dissolved’ (=D), ‘Free’ (=F), or ‘Simultaneously Extracted Metals’ (SEM) (=S)? |
| “T”, “D”, “F”, or ”S” |
| T |
| Sample_Medium_ID |
| What is the medium of the sample being tested? (W=Water, S=Sediment, or F=Biological Tissues such as Fish) |
| X |
| W |
| Test_Method |
| Test method used by lab |
| XXXXXXXXXX |
| 200.7 |
| Test_SubMethod |
| Identifies Method's elective process when it produces different MDL (as in 200.8; others possible). Values: 'N/A'=No Sub-Method; ‘SCAN’=Scanning Mode; ‘SIM’=Selection Ion Monitoring Mode |
| "N/A”, “SCAN", or "SIM" |
| SCAN |
| Prep_Method |
| Prep Method Used (if applicable) |
| XXXXXXXXXX |
| 3050 |
| Date |
| Date of file/batch creation |
| MMDDYYYY |
| 11191999 |
| Time |
| 24-Hour Time of file/batch creation |
| HHMMSS |
| 220156 |
| Count |
| Number of Narrative records in batch (for this Header Record) |
| nnnn |
| 7 |
Record Format(in actual data records, all on one line):
Record_ID|Lab_ID|Lab_Job_Num|OWQ_Analysis_Set|Analysis_Set_SubmitCount|Lab_Sample_Num|Prep_Batch_Num| Run_Batch_Num|Refer_Record_ID|CAS_Number|CAS_Num_Qualifier|Sample_Medium_ID|Test_Method|Test_SubMethod| Prep_Method|Date|Time|Count|
Project Narrative Header Description Example:
HN|XXXXXXXX|XXXXXXXX|XXXXXXXX|NN|XXXXXXXX|XXXXXXXX|XXXXXXXX|XX|XXXXXXXXXXX|X|X|XXXXXXXXXX|XXXX| XXXXXXXXXX| HHMMSS|NNNN|MMDDYYYY|
IF VALID FOR BATCH, PROVIDE BATCH AND NOT INTERNAL SAMPLE NUMBER
IF VALID FOR CERTAIN SAMPLES, PROVIDE INTERNAL SAMPLE NUMBER, BUT NOT BATCH NUMBER
TC "Project Narrative Data Record" \f A \l "2" Project Narrative Data Record:
| Field Name |
| Description |
| Format |
| Example |
| Record_ID |
| Identifies Project Narrative Data Record |
| "DN" |
| DN |
| Narrative |
| Projective Narrative Text in a continuous line |
| XXXXXXXXXX |
| Analysis Resul… |
Record Format:
Record_ID|Narrative|
Description Example:
PN|XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX|
Real World Example of Project Narrative Header, Data, and Footer Records:
HN|ISDH|BB345678|00TSW190|1|AA345678|768|8043|DR|257301-77-2|T|S|200.7|N/A|3050|11191999|220156|2|
DN|Analysis resulted in an unusually high analyte concentration. Sample tested positive for presence of sulfuric acid preservative. It is possible that nitric acid is also present in sample.| (This is ONE Line of Text)
FN|ISDH|BB345678|00TSW190|1|AA345678|768|8043|DR|257301-77-2|T|S|200.7|N/A|3050|11191999|220156|2|
HN|ISDH|BB345678|00TSW190|1|AA345679|768|8043|DR|257301-77-2|T|S|200.7|N/A|3050|11191999|220156|3|
---Project Narrative Record---
---Project Narrative Record---
---Project Narrative Record---
FN|ISDH|BB345678|00TSW190|1|AA345679|768|8043|DR|257301-77-2|T|S|200.7|N/A|3050|11191999|220156|3|
HN|ISDH|BB345678|00TSW190|1|AA345680|768|8043|DR|257301-77-2|T|S|200.7|N/A|3050|11191999|220156|6|
---Project Narrative Record---
---Project Narrative Record---
---Project Narrative Record---
---Project Narrative Record---
---Project Narrative Record---
---Project Narrative Record---
FN|ISDH|BB345678|00TSW190|1|AA345680|768|8043|DR|257301-77-2|T|S|200.7|N/A|3050|11191999|220156|6|
QC Header/Footer Records TC "QC Header/Footer Records" \f A \l "2" :
QC Header Records are placed prior to the first line of an Analysis Set’s QC Section. QC Footer Record is placed after last line of the QC Section, forming a matched pair.
There is one QC Header/Footer Pair per Analysis Set. QC Detail Records include several types of QC performed by the labs.
| Field Name |
| Description |
| Format |
| Example |
| Record_ID |
| Identifies QC Header Record (“HQ”) |
Or – QC Footer Record (“FQ”)
| Lab_ID |
| Name of Lab Submitting Lab Analysis Data Results |
| XXXXXXXX |
| ISDH |
| Sample_Medium_ID |
| What is the medium of the sample being tested? (W=Water, S=Sediment, or F=Biological Tissues such as Fish) |
| X |
| W |
| Lab_Job_Num |
| Number used internally by Lab to identify the entire group of samples being analyzed for IDEM |
| XXXXXXXX |
| BB345678 |
| OWQ_Analysis_Set |
| IDEM Assigned Analysis Set Number |
| XXXXXXXX |
| 00TSW190 |
| Analysis_Set_SubmitCount |
| On first submission of analysis set test results, =1; |
if samples are re-analyzed & re-submitted, =2
(or 3 for a 2nd re-analysis/submittal, etc.)
| Date |
| Date of file/batch creation |
| MMDDYYYY |
| 11191999 |
| Time |
| 24-Hour Time of file/batch creation |
| HHMMSS |
| 220156 |
| Count |
| Number of records in this batch (for all QC Records) |
| nnnn |
| 43 |
Record ID|Lab_ID|Sample_Medium_ID|Lab_Job_Num|OWQ_Analysis_Set|Analysis_Set_SubmitCount|Date|Time|Count|
HQ|XXXXXXXX|X|XXXXXXXX|XXXXXXXX|NN|MMDDYYYY|HHMMSS|NNNN|
Real World Examples:
HQ|ISDH|W|BB345678|00TSW190|1|11191999|220156|3|
(QC Header Record)
----QC Record1---
----QC Record2---
----QC Record3---
FQ|ISDH|W|BB345678|00TSW190|1|11191999|220156|3|
(QC Footer Record)
Lab QC Records: General Format Description TC "Lab QC Records: General Format Description" \f A \l "2"
| Field Name |
| Description |
| Format |
| Example |
| Record_ID |
| Identifies type of QC record: |
Blank Record = “BL” Laboratory Control Standard Record = “LC” Laboratory Duplicate Record = “DU” Matrix Spike/Matrix Spike Dup. Record = “MS” Post Digestion Spike/Spike Dup Record = “PS” Serial Dilution Duplicate=”SD”
Initial Calibration Blank=”IB” Initial Calibration Standard=”IC” Continuing Calibration Blank=”CB”
Spectral Interference Check Standard=”SI”
Continuing Calibration Verification Record = “CC” Control Spike=“CS”
Internal Standard=”IS” Surrogate Standard=“SS”
Linear Upper Range Standard=”LR”
Mass Spectrometry Tuning or Performance Standard=”TS” Neg. E. Coli, Pos Coliform = “KP” Negative Coliform =”PA”
Positive E. Coli =”EC”
| CAS_Number |
| CAS # of substance being tested for |
| XXXXXXXXXX |
| 257301-77-2 |
| CAS_Num_Qualifier |
| Does this record show the substance’s value as ‘Total’ (=T), ‘Dissolved’ (=D), ‘Free’ (=F), or ‘Simultaneously Extracted Metals’ (SEM) (=S)? |
| “T”, “D”, “F”, or ”S” |
| T |
| Test_Method |
| Test method used by lab |
| XXXXXXXXXX |
| 200.7 |
| Test_SubMethod |
| Identifies Method's elective process when it produces different MDL (as in 200.8; others possible). Values: 'N/A'=No Sub-Method; ‘SCAN’=Scanning Mode; ‘SIM’=Selection Ion Monitoring Mode |
| "N/A”, “SCAN", or "SIM" |
| SCAN |
| Sample_Medium_ID |
| What is the medium of the sample being tested? (W=Water, S=Sediment, or F=Biological Tissues such as Fish) |
| X |
| W |
| Prep_Batch_Num |
| Lab’s Alphanumeric identifier of batch within which Sample prepped |
| XXXXXXXX |
| 768 |
| Prep_Date |
| Date sample prepped for analysis (if applicable) |
| MMDDYYYY |
| 12251999 |
| Prep_Time |
| 24-Hour Time sample prepped for analysis (if applicable) |
| HHMMSS |
| 163403 |
| Prep_Method |
| Prep Method Used (if applicable) |
| XXXXXXXX |
| 3050 |
| Run_Batch_Num |
| Lab’s Alphanumeric identifier of batch within which Sample analyzed |
| XXXXXXXX |
| 8043 |
| Run_Date |
| Date analysis run |
| MMDDYYYY |
| 12251999 |
| Run_Time |
| 24-Hour Time analysis run |
| HHMMSS |
| 163403 |
| Dup_Run_Date |
| Date analysis run for the DUP, MSD, or PSD |
| MMDDYYYY |
| 12251999 |
| Dup_Run_Time |
| 24-Hour Time analysis run for the DUP, MSD, or PSD |
| HHMMSS |
| 163403 |
| True_Value |
| True Value of substance added to sample (See Note for Result in Sample Number Records) |
| Nnnnnnnn.nnnn |
| 5.0 |
| True_Value_Units |
| Units for True_Value (see page 1 for selection of units.) |
| XXXXX |
| ug/l, mg/kg |
| Measured_Value |
| Value Measured |
(See Note for Result in Sample Number Records)
| Measured_Units |
| Units for Measured_Value (see page 1 for selection of units.) |
| XXXXX |
| ug/l, mg/kg |
| Pcnt_Recovered |
| Percentage Recovered |
| nnn.nn |
| 88.00 |
| Dup_Measure_Value |
| Value Measured in Duplicate, MSD, or PSD |
(See Note for Result in Sample Number Records)
| Dup_Measure_Units |
| Units for Dup_Measure_Value, MSD, or PSD |
| XXXXX |
| ug/l, mg/kg |
| Dup_Pcnt_Recover |
| Percentage Recovered for Duplicate, MSD, or PSD |
| nnn.nn |
| 80.0 |
| Dup_RPD |
| % Difference Between Measured_Value and Dup_Measure_Value |
| nnn.nn |
| 9.50 |
| M_Z_Ratio |
| Mass to Charge Ratio of Ion Fragment (use for Mass Spectrometry Tuning Standard) |
| nnn |
| 177 |
| M_Z_Ref |
| Reference Mass to Charge Ratio of Parent Peak or Secondary Ion (use for Mass Spectrometry Tuning/Performance Ion Abundance Criteria) |
| nnn |
| 176 |
| MS_Spike_Added |
| Matrix or Post Digestion Spike Added |
| Nnnnnnnn.nnnn |
| 4.0 |
| MS_Spike_Units |
| Units for Matrix Spike Added (see page 1 for selection of units.) |
| XXXXX |
| ug/l, mg/kg |
| Measure_Flags |
| Lab Flags for this QC record (Labs must provide cross-reference of flag codes and interpretations; IDEM will incorporate into translation table) |
| XXXXX |
| <gx |
| Dup_Measure_Flags |
| Lab Flags for this QC Dup record (Labs must provide cross-reference of flag codes and interpretations; IDEM will incorporate into translation table) |
| XXXXX |
| <gx |
| Lower_Limit |
| Lower Percent Recovered Limit (in percent) |
| nnn.n |
| 80.0 |
| Upper_Limit |
| Upper Percent Recovered Limit (in percent) |
| nnn.n |
| 120.0 |
| Lab_Sample_Num |
| Number used internally by Lab to identify Sample analyzed |
| XXXXXXXX |
| AA345678 |
| Dup_Lab_Sample_Num |
| Number used internally by Lab to identify Sample Dup analyzed |
| XXXXXXXX |
| AA345679 |
| Dilution_Mult |
| Number indicating dilution magnitude required for analysis |
| nnnn |
| 10 |
| Dup_Dilution_Mult |
| Number indicating dilution magnitude of Duplicate required for analysis |
| nnnn |
| 10 |
| Report_Limit |
| Lab’s Reporting limit for test (Method Reporting Limit X Dilution Multiplier) or if Result exceeds the Maximum Reporting Limit enter Maximum Reporting Limit X Dilution Multiplier) |
| nnnnnnnn.nnnn |
| 5.0 |
| Report_Limit_Units |
| Lab Reporting limit units (see page 1 for selection of units.) |
| XXXXX |
| ug/l, mg/kg |
| Dup_Report_Limit |
| Lab's Reporting Limit for Duplicate test (Method Reporting Limit X Dilution Multiplier)or if Result exceeds the Maximum Reporting Limit enter Maximum Reporting Limit X Dilution Multiplier) |
| nnnnnnnn.nnnn |
| 5.0 |
| Dup_Report_Limit_Units |
| Lab Reporting Limit units for Duplicate test (see page 1 for selection of units.) |
| XXXXX |
| ug/l, mg/kg |
| Lab_MDL |
| Lab’s Detection limit for test (Method Detection Limit X Dilution Multiplier |
| nnnnnnnn.nnnn |
| 5.0 |
| Lab_MDL_Units |
| Lab Detection limit units (see page 1 for selection of units.) |
| XXXXX |
| ug/l, mg/kg |
| Dup_Lab_MDL |
| Lab’s Detection limit for test (Method Detection Limit X Dilution Multiplier |
| nnnnnnnn.nnnn |
| 5.0 |
| Dup_Lab_MDL_Units |
| Lab Detection limit units (see page 1 for selection of units.) |
| XXXXX |
| ug/l, mg/kg |
Record Format (in actual QC data records, all on one line):
Record_ID|CAS_Number|CAS_Num_Qualifier| Test_Method|Test_SubMethod|Sample_Medium_ID|Prep_Batch_Num|Prep_Date| Prep_Time|Prep_Method|Run_Batch_Num|Run_Date|Run_Time|Dup_Run_Date|Dup_Run_Time|True_Value|True_Value_Units| Measured_Value|Measured_Units|Pcnt_Recovered|Dup_Measure_Value|Dup_Measure_Units|Dup_Pcnt_Recover|Dup_RPD| M_Z_Ratio|M_Z_Ref|MS_Spike_Added|MS_Spike_Units|Measure_Flags|Dup_Measure_Flags|Lower_Limit|Upper_Limit|Lab_Sample_Num| Dup_Lab_Sample_Num|Dilution_Mult|Dup_Dilution_Mult| Report_Limit| Report_Limit_Units| Dup_Report_Limit | Dup_Report_Limit_Units|Lab_MDL|Lab_MDL_Units| Description Example:
LC|XXXXXXXXXX|X|XXXXXXXXXX|XXXX|X|XXXXXXXX|MMDDYYYY|HHMMSS|XXXXXXXX|XXXXXXXX|MMDDYYYY|HHMMSS|MMDDYYYY|HHMMSS| NNNNNNNN.NNNNNN|XXXXX|NNNNNNNN.NNNNNN|XXXXX|NNN.N|NNNNNNNN.NNNNNN|XXXXX|NNN.N| NNN.N| XXXXXXXXXX|XXXXXXXXXX|NNNNNNNN.NNNNNN|XXXXX|XXXXX|XXXXX|NNN.N|NNN.N|XXXXXXXX|XXXXXXXX|NNNN|NNNN| NNNNNNNN.NNNN|XXXXX|NNNNNNNN.NNNN|XXXXX|NNNNNNNN.NNNN|XXXXX|
EACH QC RECORD MUST HAVE A UNIQUE COMBINATION OF:
CAS_Number + CAS_Num_Qualifier + Test_Method + Test_SubMethod + Sample_Medium_ID + RECORD_ID + RUN_BATCH_NUM + LAB_SAMPLE_NUM It may be necessary to create an arbitrary Lab_Sample_Num (i.e. CCV1, CCV2, Blank1, Blank2, etc.) in order to achieve this unique combination. A unique Lab_Sample_Num could be generated by concatenating the Lab_Sample_Num & Run_Time fields. Only 4 characters would be need from the Run_Time field. Note that Run_Time does not contain any colons or slashes.
Example: CCV1 run at 080000 would be CCV1-0800
CCV1 run at 083000 would be CCV1-0830, Etc.
Lab QC Records: Format for QC Records of following types: ‘Blank’, ‘Initial Calibration Blank’, or ‘Continuing Calibration Blank’ TC "Lab QC Records: Format for ‘Blank’ QC Records" \f A \l
TC "Lab QC Records: Format for QC Records of following types: ‘Blank’, ‘Initial Calibration Blank’, or ‘Continuing Calibration Blank’" \f A \l "2"
| Field Name |
| Description |
| Format |
| Example |
| Record_ID |
| Identifies type of QC record: Blank Record = “BL” |
Initial Calibration Blank=”IB” Continuing Calibration Blank=”CB”
| CAS_Number |
| CAS # of substance being tested for |
| XXXXXXXXXX |
| 257301-77-2 |
| CAS_Num_Qualifier |
| Does this record show the substance’s value as ‘Total’ (=T), ‘Dissolved’ (=D), ‘Free’ (=F), or ‘Simultaneously Extracted Metals’ (SEM) (=S)? |
| “T”, “D”, “F”, or ”S” |
| T |
| Test_Method |
| Test method used by lab |
| XXXXXXXXXX |
| 200.7 |
| Test_SubMethod |
| Identifies Method's elective process when it produces different MDL (as in 200.8; others possible). Values: 'N/A'=No Sub-Method; ‘SCAN’=Scanning Mode; ‘SIM’=Selection Ion Monitoring Mode |
| "N/A”, “SCAN", or "SIM" |
| SCAN |
| Sample_Medium_ID |
| What is the medium of the sample being tested? (W=Water, S=Sediment, or F=Biological Tissues such as Fish) |
| X |
| W |
| Prep_Batch_Num |
| Lab’s Alphanumeric identifier of batch within which Sample prepped |
| XXXXXXXX |
| 768 |
| Prep_Date |
| Date sample prepped for analysis (if applicable) |
| MMDDYYYY |
| 12251999 |
| Prep_Time |
| 24-Hour Time sample prepped for analysis (if applicable) |
| HHMMSS |
| 163403 |
| Prep_Method |
| Prep Method used (if applicable) |
| XXXXXXXX |
| 3050 |
| Run_Batch_Num |
| Lab’s Alphanumeric identifyier of batch within which Sample analyzed |
| XXXXXXXX |
| 8043 |
| Run_Date |
| Date analysis run |
| MMDDYYYY |
| 12251999 |
| Run_Time |
| 24-Hour Time analysis run |
| HHMMSS |
| 163403 |
| Dup_Run_Date |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Dup_Run_Time |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| True_Value |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| True_Value_Units |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Measured_Value |
| Value Measured |
(See Note for Result in Sample Number Records)
| Measured_Units |
| Units for Measured_Value (see page 1 for selection of units.) |
| XXXXX |
| ug/l, mg/kg |
| Pcnt_Recovered |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Dup_Measure_Value |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Dup_Measure_Units |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Dup_Pcnt_Recover |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Dup_RPD |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| M_Z_Ratio |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| M_Z_Ref |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| MS_Spike_Added |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| MS_Spike_Units |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Measure_Flags |
| Lab Flags for this Blank QC record (Labs must provide cross-reference of flag codes and interpretations; IDEM will incorporate into translation table) |
| XXXXX |
| <gx |
| Dup_Measure_Flags |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Lower_Limit |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Upper_Limit |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Lab_Sample_Num |
| Number used internally by Lab to identify Sample analyzed |
| XXXXXXXX |
| AA345678 |
| Dup_Lab_Sample_Num |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Dilution_Mult |
| Number indicating dilution magnitude required for analysis |
| nnnn |
| 10 |
| Dup_Dilution_Mult |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Report_Limit |
| Lab’s Reporting limit for test (Method Reporting Limit X Dilution Multiplier) |
or if Result exceeds the Maximum Reporting Limit enter Maximum Reporting Limit X Dilution Multiplier)
| Report_Limit_Units |
| Lab Reporting limit units (see page 1 for selection of units.) |
| XXXXX |
| ug/l, mg/kg |
| Dup_Report_Limit |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Dup_Report_Limit_Units |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Lab_MDL |
| Lab’s Detection limit for test (Method Detection Limit X Dilution Multiplier |
| nnnnnnnn.nnnn |
| 5.0 |
| Lab_MDL_Units |
| Lab Detection limit units (see page 1 for selection of units.) |
| XXXXX |
| ug/l, mg/kg |
| Dup_Lab_MDL |
| Lab’s Detection limit for test (Method Detection Limit X Dilution Multiplier |
| nnnnnnnn.nnnn |
| 5.0 |
| Dup_Lab_MDL_Units |
| Lab Detection limit units (see page 1 for selection of units.) |
| XXXXX |
| ug/l, mg/kg |
Record_ID|CAS_Number|CAS_Num_Qualifier|Test_Method|Test_SubMethod|Sample_Medium_ID|Prep_Batch_Num|Prep_Date| Prep_Time|Prep_Method|Run_Batch_Num|Run_Date|Run_Time| | | | |Measured_Value|Measured_Units| | | | | | | | | |Measure_Flags| | | | Lab_Sample_Num| |Dilution_Mult| | Report_Limit| Report_Limit_Units| | |Lab_MDL|Lab_MDL_Units| Description Example:
BL|XXXXXXXXXX|T|XXXXXXXXXX|XXXX|X|XXXXXXXX|MMDDYYYY|HHMMSS|XXXXXXXX|XXXXXXXX|MMDDYYYY|HHMMSS| | | | | NNNNNNNN.NNNNNN|XXXXX| | | | | | | | | |XXXXX| | | |XXXXXXXX| |NNNN| | NNNNNNNN.NNNN|XXXXX| | |NNNNNNNN.NNNN|XXXXX| Lab QC Records: Format for QC Records of following types: Continuing Calibration Verification, Initial Calibration Standard, Linear Upper Range Standard, or Spectral Interference Check Standard TC "Lab QC Records: Format for QC Records of following types: Continuing Calibration Verification, Initial Calibration Standard, Linear Upper Range Standard, or Spectral Interference Check Standard" \f A \l "2"
| Field Name |
| Description |
| Format |
| Example |
| Record_ID |
| Continuing Calibration Verification Record = “CC” |
Initial Calibration Standard=”IC”
Linear Upper Range Standard=”LR”
Spectral Interference Check Standard=”SI”
| CAS_Number |
| CAS # of substance being tested for |
| XXXXXXXXXX |
| 257301-77-2 |
| CAS_Num_Qualifier |
| Does this record show the substance’s value as ‘Total’ (=T), ‘Dissolved’ (=D), ‘Free’ (=F), or ‘Simultaneously Extracted Metals’ (SEM) (=S)? |
| “T”, “D”, “F”, or ”S” |
| T |
| Test_Method |
| Test method used by lab |
| XXXXXXXXXX |
| 200.7 |
| Test_SubMethod |
| Identifies Method's elective process when it produces different MDL (as in 200.8; others possible). Values: 'N/A'=No Sub-Method; ‘SCAN’=Scanning Mode; ‘SIM’=Selection Ion Monitoring Mode |
| "N/A”, “SCAN", or "SIM" |
| SCAN |
| Sample_Medium_ID |
| What is the medium of the sample being tested? (W=Water, S=Sediment, or F=Biological Tissues such as Fish) |
| X |
| W |
| Prep_Batch_Num |
| Lab’s Alphanumeric identifier of batch within which Sample prepped |
| XXXXXXXX |
| 768 |
| Prep_Date |
| Date sample prepped for analysis (if applicable) |
| MMDDYYYY |
| 12251999 |
| Prep_Time |
| 24-Hour Time sample prepped for analysis (if applicable) |
| HHMMSS |
| 163403 |
| Prep_Method |
| Prep Method Used (if applicable) |
| XXXXXXXX |
| 3050 |
| Run_Batch_Num |
| Lab’s Alphanumeric identifyier of batch within which Sample analyzed |
| XXXXXXXX |
| 8043 |
| Run_Date |
| Date analysis run |
| MMDDYYYY |
| 12251999 |
| Run_Time |
| 24-Hour Time analysis run |
| HHMMSS |
| 163403 |
| Dup_Run_Date |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Dup_Run_Time |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| True_Value |
| True Value of substance added to sample (See Note for Result in Sample Number Records) |
| nnnnnnnn.nnnn |
| 5.0 |
| True_Value_Units |
| Units for True_Value (see page 1 for selection of units.) |
| XXXXX |
| ug/l, mg/kg |
| Measured_Value |
| Value Measured |
(See Note for Result in Sample Number Records)
| Measured_Units |
| Units for Measured_Value (see page 1 for selection of units.) |
| XXXXX |
| ug/l, mg/kg |
| Pcnt_Recovered |
| Percentage Recovered |
| nnn.n |
| 88.0 |
| Dup_Measure_Value |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Dup_Measure_Units |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Dup_Pcnt_Recover |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Dup_RPD |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| M_Z_Ratio |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| M_Z_Ref |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| MS_Spike_Added |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| MS_Spike_Units |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Measure_Flags |
| Lab Flags for this QC record (Labs must provide cross-reference of flag codes and interpretations; IDEM will incorporate into translation table) |
| XXXXX |
| <gx |
| Dup_Measure_Flags |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Lower_Limit |
| Lower Percent Recovered Limit (in percent) |
| nnn.n |
| 80.0 |
| Upper_Limit |
| Upper Percent Recovered Limit (in percent) |
| nnn.n |
| 120.0 |
| Lab_Sample_Num |
| Number used internally by Lab to identify Sample analyzed |
| XXXXXXXX |
| AA345678 |
| Dup_Lab_Sample_Num |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Dilution_Mult |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Dup_Dilution_Mult |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Report_Limit |
| Lab’s Reporting limit for test (Method Reporting Limit X Dilution Multiplier) or if Result exceeds the Maximum Reporting Limit enter Maximum Reporting Limit X Dilution Multiplier) |
| nnnnnnnn.nnnn |
| 5.0 |
| Report_Limit_Units |
| Lab Reporting limit units (see page 1 for selection of units.) |
| XXXXX |
| ug/l, mg/kg |
| Dup_Report_Limit |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Dup_Report_Limit_Units |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Lab_MDL |
| Lab’s Detection limit for test (Method Detection Limit X Dilution Multiplier |
| nnnnnnnn.nnnn |
| 5.0 |
| Lab_MDL_Units |
| Lab Detection limit units (see page 1 for selection of units.) |
| XXXXX |
| ug/l, mg/kg |
| Dup_Lab_MDL |
| Lab’s Detection limit for test (Method Detection Limit X Dilution Multiplier |
| nnnnnnnn.nnnn |
| 5.0 |
| Dup_Lab_MDL_Units |
| Lab Detection limit units (see page 1 for selection of units.) |
| XXXXX |
| ug/l, mg/kg |
Record_ID|CAS_Number|CAS_Num_Qualifier|Test_Method|Test_SubMethod|Sample_Medium_ID|Prep_Batch_Num|Prep_Date| Prep_Time|Prep_Method|Run_Batch_Num|Run_Date|Run_Time| | |True_Value|True_Value_Units|Measured_Value|Measured_Units| Pcnt_Recovered| | | | | | | | |Measure_Flags| |Lower_Limit|Upper_Limit| Lab_Sample_Num| | | | Report_Limit| Report_Limit_Units| | |Lab_MDL|Lab_MDL_Units| Description Example:
CC|XXXXXXXXXX|T|XXXXXXXXXX|XXXX|X|XXXXXXXX|MMDDYYYY|HHMMSS|XXXXXXXX|XXXXXXXX|MMDDYYYY|HHMMSS| | | NNNNNNNN.NNNNNN|XXXXX|NNNNNNNN.NNNNNN|XXXXX|NNN.N| | | | | | | | |XXXXX| |NNN.N|NNN.N|XXXXXXXX| | | | NNNNNNNN.NNNN|XXXXX| | |NNNNNNNN.NNNN|XXXXX| Lab QC Records: Format for ‘Duplicate’ or ‘Serial Dilution’ QC Records TC "Lab QC Records: Format for ‘Duplicate’ or ‘Serial Dilution’ QC Records" \f A \l "2"
| Field Name |
| Description |
| Format |
| Example |
| Record_ID |
| Identifies type of QC record: Duplicate Record = “DU”; Serial Dilution = “SD” |
| XX |
| DU |
| CAS_Number |
| CAS # of substance being tested for |
| XXXXXXXXXX |
| 257301-77-2 |
| CAS_Num_Qualifier |
| Does this record show the substance’s value as ‘Total’ (=T), ‘Dissolved’ (=D), ‘Free’ (=F), or ‘Simultaneously Extracted Metals’ (SEM) (=S)? |
| “T”, “D”, “F”, or ”S” |
| T |
| Test_Method |
| Test method used by lab |
| XXXXXXXXXX |
| 200.7 |
| Test_SubMethod |
| Identifies Method's elective process when it produces different MDL (as in 200.8; others possible). Values: 'N/A'=No Sub-Method; ‘SCAN’=Scanning Mode; ‘SIM’=Selection Ion Monitoring Mode |
| "N/A”, “SCAN", or "SIM" |
| SCAN |
| Sample_Medium_ID |
| What is the medium of the sample being tested? (W=Water, S=Sediment, or F=Biological Tissues such as Fish) |
| X |
| W |
| Prep_Batch_Num |
| Lab’s Alphanumeric identifier of batch within which Sample prepped |
| XXXXXXXX |
| 768 |
| Prep_Date |
| Date sample prepped for analysis (if applicable) |
| MMDDYYYY |
| 12251999 |
| Prep_Time |
| 24-Hour Time sample prepped for analysis (if applicable) |
| HHMMSS (military time) |
| 163403 (4:34:03 PM) |
| Prep_Method |
| Prep Method Used (if applicable) |
| XXXXXXXX |
| 3050 |
| Run_Batch_Num |
| Lab’s Alphanumeric identifyier of batch within which Sample analyzed |
| XXXXXXXX |
| 8043 |
| Run_Date |
| Date analysis run |
| MMDDYYYY |
| 12251999 |
| Run_Time |
| 24-Hour Time analysis run |
| HHMMSS |
| 163403 |
| Dup_Run_Date |
| Date analysis run |
| MMDDYYYY |
| 12251999 |
| Dup_Run_Time |
| 24-Hour Time analysis run |
| HHMMSS |
| 163403 |
| True_Value |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| True_Value_Units |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Measured_Value |
| Value Measured |
(See Note for Result in Sample Number Records)
| Measured_Units |
| Units for Measured_Value (see page 1 for selection of units.) |
| XXXXX |
| ug/l, mg/kg |
| Pcnt_Recovered |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Dup_Measure_Value |
| Value Measured in Duplicate (See Note for Result in Sample Number Records) |
| nnnnnnnn.nnnn |
| 4.0 |
| Dup_Measure_Units |
| Units for Dup_Measure_Value |
| XXXXX |
| ug/l, mg/kg |
| Dup_Pcnt_Recover |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Dup_RPD |
| % Difference Between Measured_Value and Dup_Measure_Value |
| nnn.n |
| 9.5 |
| M_Z_Ratio |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| M_Z_Ref |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| MS_Spike_Added |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| MS_Spike_Units |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Measure_Flags |
| Lab Flags for this record (Labs must provide cross-reference of flag codes and interpretations; IDEM will incorporate into translation table) |
| XXXXX |
| <gx |
| Dup_Measure_Flags |
| Lab Flags for record duplicate (Labs must provide cross-reference of flag codes and interpretations; IDEM will incorporate into translation table) |
| XXXXX |
| <gx |
| Lower_Limit |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Upper_Limit |
| UNUSED (but please add Pipe Delimiter for placeholder) |
| Lab_Sample_Num |
| Number used internally by Lab to identify Sample analyzed |
| XXXXXXXX |
| AA345678 |
| Dup_Lab_Sample_Num |
| Number used internally by Lab to identify Sample Dup analyzed |
| XXXXXXXX |
| AA345679 |
| Dilution_Mult |
| Number indicating dilution magnitude required for analysis |
| nnnn |
| 10 |
| Dup_Dilution_Mult |
| Number indicating dilution magnitude of Duplicate required for analysis |
| nnnn |
| 10 |
| Report_Limit |
| Lab’s Reporting limit for test (Method Reporting Limit X Dilution Multiplier) or if Result exceeds the Maximum Reporting Limit enter Maximum Reporting Limit X Dilution Multiplier) |
| nnnnnnnn.nnnn |
| 5.0 |
| Report_Limit_Units |
| Lab Reporting limit units (see page 1 for selection of units.) |
| XXXXX |
| ug/l, mg/kg |
| Dup_Report_Limit |
| Lab's Reporting Limit for Duplicate test (Method Reporting Limit X Dilution Multiplier)or if Result exceeds the Maximum Reporting Limit enter Maximum Reporting Limit X Dilution Multiplier) |
| nnnnnnnn.nnnn |
| 5.0 |
| Dup_Report_Limit_Units |
| Lab Reporting Limit units for Duplicate test (see page 1 for selection of units.) |
| XXXXX |
| ug/l, mg/kg |
| Lab_MDL |
| Lab’s Detection limit for test (Method Detection Limit X Dilution Multiplier |
| nnnnnnnn.nnnn |
| 5.0 |
| Lab_MDL_Units |
| Lab Detection limit units (see page 1 for selection of units.) |
| XXXXX |
| ug/l, mg/kg |
| Dup_Lab_MDL |
| Lab’s Detection limit for test (Method Detection Limit X Dilution Multiplier |
| nnnnnnnn.nnnn |
| 5.0 |
| Dup_Lab_MDL_Units |
| Lab Detection limit units (see page 1 for selection of units.) |
| XXXXX |
| ug/l, mg/kg |
Record_ID|CAS_Number|CAS_Num_Qualifier|Test_Method|Test_SubMethod|Sample_Medium_ID|Prep_Batch_Num|Prep_Date| Prep_Time|Prep_Method|Run_Batch_Num|Run_Date|Run_Time|Dup_Run_Date|Dup_Run_Time| | |Measured_Value|Measured_Units| | Dup_Measure_Value|Dup_Measure_Units| |Dup_RPD| | | | |Measure_Flags|Dup_Measure_Flags| | |Lab_Sample_Num| Dup_Lab_Sample_Num|Dilution_Mult|Dup_Dilution_Mult| Report_Limit| Report_Limit_Units| Dup_Report_Limit | Dup_Report_Limit_Units|Lab_MDL|Lab_MDL_Units| Description Example:
DU|XXXXXXXXXX|T|XXXXXXXXXX|XXXX|X|XXXXXXXX|MMDDYYYY|HHMMSS|XXXXXXXX|XXXXXXXX|MMDDYYYY|HHMMSS| MMDDYYYY|HHMMSS| | |NNNNNNNN.NNNNNN|XXXXX| |NNNNNNNN.NNNNNN|XXXXX| |NNN.N| | | | |XXXXX|XXXXX| | |XXXXXXXX| XXXXXXXX|NNNN|NNNN| NNNNNNNN.NNNN|XXXXX| NNNNNNNN.NNNN|XXXXX|NNNNNNNN.NNNN|XXXXX| Lab QC Records: Format for ‘Matrix Spike’, ‘Matrix Spike Duplicate’ Records TC "Lab QC Records: Format for ‘Matrix Spike’, ‘Matrix Spike Duplicate’ Records" \f A \l "2"
| Field Name |
| Description |
| Format |
| Example |
| Record_ID |
| Identifies type of QC record: Matrix Spike/Matrix Spike Dup. Record = “MS” Post Digestion Spike/Spike Dup Record = “PS” |
| XX |
| MD |
| CAS_Number |
| CAS # of substance being tested for |
| XXXXXXXXXX |
| 257301-77-2 |
| CAS_Num_Qualifier |
| Does this record show the substance’s value as ‘Total’ (=T), ‘Dissolved’ (=D), ‘Free’ (=F), or ‘Simultaneously Extracted Metals’ (SEM) (=S)? |
| “T”, “D”, “F”, or ”S” |
| T |
| Test_Method |
| Test method used by lab |
| XXXXXXXXXX |
| 200.7 |
| Test_SubMethod |
| Identifies Method's elective process when it produces different MDL (as in 200.8; others possible). Values: 'N/A'=No Sub-Method; ‘SCAN’=Scanning Mode; ‘SIM’=Selection Ion Monitoring Mode |
| "N/A”, “SCAN", or "SIM" |
| SCAN |
| Sample_Medium_ID |
| What is the medium of the sample being tested? (W=Water, S=Sediment, or F=Biological Tissues such as Fish) |
| X |
| W |
| Prep_Batch_Num |
| Lab’s Alphanumeric identifier of batch within which Sample prepped |
| XXXXXXXX |
| 768 |
| Prep_Date |
| Date sample prepped for analysis (if applicable) |
| MMDDYYYY |
| 12251999 |
| Prep_Time |
| 24-Hour Time sample prepped for analysis (if applicable) |
| HHMMSS |
| 163403 |
| Prep_Method |
| Prep Method Used (if applicable) |
| XXXXXXXX |
| 3050 |
| Run_Batch_Num |
| Lab’s Alphanumeric identifyier of batch within which Sample analyzed |
| XXXXXXXX |
| 8043 |
| Run_Date |
| Date analysis run for the MS or PS |
| MMDDYYYY |
| 12251999 |
| Run_Time |
| 24-Hour Time analysis run for the MS or PS |
| HHMMSS |
| 163403 |
| Dup_Run_Date |
| Date analysis run for the MSD or PSD |
| MMDDYYYY |
| 12251999 |
| Dup_Run_Time |
| 24-Hour Time analysis run for the MSD or PSD |
| HHMMSS |
| 163403 |
| Unspiked_Value |
| Measured Value of substance in unspiked sample Use measured value if known or ‘-1’ if below the detection limit. |
(See Note for Result in Sample Number Records) If the value is ‘0’ then use ‘-1’
| Unspiked_Units |
| Units for Unspiked_Value |
| XXXXX |
| ug/l, mg/kg |
| Measured_Value |
| Value Measured in Matrix Spike Sample (See Note for Result in Sample Number Records) |
| nnnnnnnn.nnnn |
| 8.5 |
| Measured_Units |
| Units for Measured_Value (see page 1 for selection of units.) |
| XXXXX |
| ug/l, mg/kg |
| Pcnt_Recovered |
| Percentage Recovered |
| nnn.n |
| 88.0 |
| Dup_Measure_Value |
| Value Measured in Matrix Spike Duplicate (See Note for Result in Sample Number Records) |
| nnnnnnnn.nnnn |
| 8.2 |
| Dup_Measure_Units |
| Units for Dup_Measure_Value |
| XXXXX |
| ug/l, mg/kg |
| Dup_Pcnt_Recover |
| Percentage Recovered for Duplicate |
| nnn.n |
| 80.0 |
| Dup_RPD |
| % Difference Between Measured_Value and Dup_Measure_Value |
| nnn.n |
| 3.6 |
This is the start of the file's text. The full file is on GovTribe.