Division of Environmental Health Drinking Water Program

Chemical/Radionuclide Sample Submission Guide

Excel Reporting

This page outlines how to report routine, special, and confirmation chemical or radiological sample results. Please note there are separate guides on Disinfection By-Product samples and Shipping Blanks (trip/field blanks). 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 Chem/Rad reporting). Additionally, this page includes the Methods Chart and examples of completed sample submissions (including Lead/Copper samples, PFAS samples, detected samples and non-detected samples).

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*: Select the appropriate sample point related to the facility where the sample was collected.
  • If you are unsure of the Facility ID and Sample Point ID to enter, review the How to Find PWS Facility ID/Sample Point ID information page.
• Sampling Location*: This field must describe the location where the sample was taken from in the distribution system (i.e., 123 Main Street, Health Clinic, Kitchen sink, etc.). Keep description succinct (numbers, letters, dash/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: Do NOT report a repeat location.
• Original Sample ID**: If reporting a confirmation sample be sure to enter the lab Sample ID number of the original sample collected.
• Original Reporting Lab. ID: Not required but report if information is available.
• Original Collection Date: Not required but report if information is available (MM/DD/YY).
• Comment**: Must include water idle time when reporting Lead/Copper samples (e.g., Idle time 7 hours 40 minutes or Water sat unused for 9 hours). 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 you are submitting results for as appropriate. 
• Not Detected*: From the drop down menu, select whether the contaminant was Not Detected (select Yes) or Detected (select No) in the analyzed sample. 
• Result**: Enter the appropriate reported result of the sample only if reporting a detect.
  • Reminder: If the detected sample is VOC or PFAS, 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*: This drop-down list includes methods for ALL chemical analyses and is not filtered by the analytes your lab (or subcontracting lab) is certified for. Be sure to verify certification status and select the appropriate method. If the method is reported incorrectly, it will be rejected from the state database. If you are unsure which method should be reported, please see the Methods Chart to determine correct reporting.
• 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 Chemical/Radionuclide 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- Confirmation Sample
• Tab 4- PFAS Sample with Detects & Non-Detects including Shipping Blank
• Tab 5- Lead & Copper Sample