Division of Environmental Health Drinking Water Program

Disinfection By-Products Sample Submission Guide

Excel Reporting

This page outlines how to report routine Disinfection by-Products (DBP) sample results. Please note there is a separate guide on  Shipping Blanks (trip/field blanks) which are required for TTHM detections. This guidance is separated into three sections to match the sections in CMDP: general Sample Information, Chem/Rad Results, and Field Results and Measurements (this section not used for DBP reporting). Additionally, this page includes examples of completed sample submissions.

This guidance page notes the state/federally required fields within each section. Submit the information as described to help ensure a successful sample submission. Do not rely on the symbols noted in the template as they do not include the state required fields.

If you have questions, please contact DEC CMDP support staff at dec.cmdpsupport@alaska.gov.

Section 1: Sample Information

• Reporting Lab. ID*: Lab Identification number.
• Sample ID*: Lab sample identification number, limit to 20 characters (numbers, letters, dash, and underscore are allowed). 
• WS ID*: Public Water System identification number (PWSID). 
  • NOTE: Each water system name has a unique PWSID number. If the name and number on the work order does not match what is listed in CMDP, investigate to ensure accuracy and consistency.
• Facility ID*: Facility identification number where sample was collected. 
• Sampling Point ID*: Sample Point identification number related to the facility where the sample was collected. 
  • NOTE: A PWS can potentially have more than one Sampling Point for TTHMs & HAA5s; selecting the appropriate sampling point is very important for this rule. If the PWS did not provide sufficient information to select the appropriate Sampling Point feel free to contact the DW Program or review the How to Find PWS Facility ID/Sample Point ID information page.
• Sampling Location*: This field must describe the distribution system location where the sample was taken (i.e., entry point, 123 Main Street, Health Clinic, etc.). Keep description succinct (numbers, letters, dash, and underscore only). 
• Collection Date*: Date sample collected (MM/DD/YY). 
• Collection Time (24H)*: Time sample collected (HH:MM).
• Sample Type*: Type of sample to be submitted. From the drop-down menu, select the appropriate sample type (i.e., routine, confirmation, special, etc.)
• Sample Volume: Not Required (numerical value only).
• Repeat Location: Not applicable for this sample type.
• Original Sample ID: Not applicable for this sample type.
• Original Reporting Lab. ID: Not applicable for this sample type.
• Original Collection Date: Not applicable for this sample type.
• Comment: Not required, however if comments are provided, please limit characters to numbers, letters, dash or underscore. In particular, do NOT include quotation marks.
• Sample Collector Name: Name of sample collector, report if information is provided.

Section 2: Chem/Rad Results

• Analyte [Code-Name]*: From the drop down menu, select the analytes for the results you are submitting. For a successful DBP sample submittal, use the list below for the analyte codes:  
  • Total THM Analyte Code = 2950 (Individual analytes: Chloroform (2941), Bromoform (2942), Bromodichloromethane (2943), and Dibromochloromethane (2944))
  • Total HAA5 Analyte Code = 2456 (Individual analytes: Dibromoacetic Acid (2454), Dichloroacetic Acid (2451), Monobromoacetic Acid (2453), Monobromoacetic Acid (2450) and Trichloroacetic Acid (2452))
• Not Detected*: From the drop down menu, select the appropriate value listed below:
  • Contaminant was Detected in the analyzed sample= select No.
  • Contaminant was Not Detected in the analyzed sample= select Yes.
• Result**: Enter the appropriate reported result of the sample only if reporting a detect.
  • Reminder: If the detected sample is TTHM, a Shipping Blank result is required to be reported, see Shipping Blank Data Submission guide.
• Result UOM**: From the drop-down menu, select the unit of measure for the sample result as appropriate.
• Standard Deviation (+/-): Not required but report if applicable.
• Reporting Limit*: Enter the appropriate reporting limit of the analytes.
• Reporting Limit UOM*:From the drop-down menu, select the unit of measure for the reporting limit as appropriate.
• Volume Assayed: Not required but report if applicable (numerical value only). 
• Method*: Select the appropriate method based on how analyzed as listed below  
  • Method 524.2 from drop-down select 524.2 - VOC, GC/MS, P&T, CAPCOLUMN 
  • Method 552.2 from drop-down select 552.2-DBPS & CL2 SOLVENTS GC L/L ELECTRON CAPT 
• Analysis Start Date*: Date when lab began analysis (MM/DD/YY).
• Analysis Start Time*: Time when lab began analysis (HH:MM).
• Analysis Completed Date: Not required but report if information is available (MM/DD/YY).
• Analysis Completed Time: Not required but report if information is available (HH:MM).
• Analyst Name: Not required.
• Analyzing Lab ID**: If the sample was subcontracted to a different lab for analysis, the analyzing lab identification number is required to be reported here.
• Comment: Not required, however if comments are provided, please limit characters to numbers, letters, dash or underscore. In particular, do NOT include quotation marks

Section 3: Field Results and Measurements

REMINDER! This section should NOT be used for Disinfection By-Product sample submittals. Please leave fields blank.

Section 4: Examples

Excel Examples Document - This document includes several examples as follows:

• Tab 1- Non-Detect Sample
• Tab 2- Detect Sample
• Tab 3- TTHM Detect including Shipping Blank