POTW and NSSS Data Template

Publicly Owned Treatment Works (POTW) Influent Per- and Polyfluoroalkyl Substances (PFAS) Study and National Sewage Sludge Survey

2799.01 Data Template POTW & NSSS (1).xlsx

National Sewage Sludge Survey

OMB:

Document [xlsx]
Download: xlsx | pdf

Overview

Description of Data Fields
Data Submission Template


Sheet 1: Description of Data Fields

Template for Submitting PFAS and AOF Monitoring Data for the US EPA's POTW Influent PFAS Study (January 23, 2024)
Category Field Name Description Required Field
Sample Site Details FacilityName Name of the sampled facility. Required Field
Sample Site Details FacilityType Select from the following options which best reflects the sampled facility type: [POTW, Industrial User, Residential Wastewater, Non-Industrial User, Other]. Required Field
Sample Site Details OtherFacilityType If "Other" was selected for FacilityType field, enter a description of the type of facility.
Sample Site Details FacilityCity City where the sampled facility is located. Required Field
Sample Site Details FacilityState Two letter state abbreviation. Required Field
Sample Site Details NPDES_ID National Pollutant Discharge Elimination System (NPDES) permit number.
Sample Site Details OtherPermitNumber Pretreatment ID or other applicable permit number or ID used to identify the facility
Sample Site Details PSC If the facility is subject to one or more effluent guidelines, enter the relevant Point Source Category (PSC) code from Title 40 of the Code of Federal Regulations (CFR).
Sample Site Details SIC Primary Standard Industrial Classification (SIC) code.
Sample Site Details NAICS Primay North American Industry Classification System (NAICS) code.
Sample Site Details FacilityDesignFlow_GPD Design wastewater flow of the sampled facility in gallons per day (gpd)
Sample Details DateCollected Date the sample was collected. Required Field
Sample Details SampleID Number or identifier for individual sample. Required Field
Sample Details SamplePoint Sample point identifier or specific location sample was collected. Required Field
Sample Details SampleDescription Description of sample point, which can include details on sample location, sampling procedures, or wastewater type. Required Field
Sample Details SampleMatrix Choose from: [Facility Influent, Facility Effluent, Internal Process Wastewater, Domestic Wastewater, Stormwater, Sewage Sludge, Biosolids]. Required Field
Sample Details SampleCollectionType Indicate whether sample represents a single grab sample or composite of multiple samples. [Grab; Composite] Required Field
Sample Details QASample Indicate whether the sample is a quality assurance (QA) sample (e.g., duplicate samples or field blank samples). [QA Duplicate; Field Blank; Trip Blank]
Sample Details SamplePointFlow Flow rate at the sample point at the time of sample collection.
Sample Details FlowUnits Standardized unit of measure for the SamplePointFlow field. [Million Gallons per Day (MGD); Gallons per Minute (GPM); Gallons per Day (gpd); Cubic Feet per Second (cfs)]
Sample Details TreatmentDescription Description of wastewater treatment configuration prior to sample point (if known).
Laboratory Analysis Details LabName Analytical laboratory that analyzed the sample. Required Field
Laboratory Analysis Details Analyte Name of chemical substance measured. Required Field
Laboratory Analysis Details CAS Chemical Abstracts Service (CAS) registry number specific the analyte.
Laboratory Analysis Details LabMethod Analytical method used to quantify the amount of the specified analyte in the sample. Required Field
Laboratory Analysis Details ConcentrationUnits Standardized unit of measure for the Amount, J-Value Concentration, method detection limit (MDL), and quantitation limit (QL) fields. [ng/L; ug/L; mg/L; ug/kg] Required Field
Laboratory Analysis Details NonDetectIndicator Flag indicating whether the sample was detected at or above the sample-specific QL. Flag results at or above the sample-specific QL as detections (“D”) and results less than the QL as non-detect (“ND”). Required Field
Laboratory Analysis Details Detection_Amount Concentration of the analyte in the detected sample. Populated for detections only (“D” detect indicator).
Laboratory Analysis Details JValueConcentration Estimated concentration of the analyte that is detected above the MDL but below the QL. Populated for detections below the sample-specific QL only (“ND” non-detect indicator).
Laboratory Analysis Details MDL Method detection limit. Minimum analyte concentration that can be demonstrated to be different from zero or a blank concentration at the 99% level of confidence. Required Field
Laboratory Analysis Details QL Quantitation limit. Lowest concentration of an analyte that produces a quantitative result within specified limits of precision and bias. Sometimes referred to as the reporting limit. Required Field
Laboratory Analysis Details Qualifier Qualifier assigned by the analytical laboratory to flag any analytical issues or concerns.
Laboratory Analysis Details Qualifier_Reason Description of the reported qualifier.
Comments Comments Any other comments about this sample result.

Sheet 2: Data Submission Template

FacilityName FacilityType OtherFacilityType FacilityCity FacilityState NPDES Number OtherPermitNumber PSC SIC NAICS FacilityDesignFlow_GPD DateCollected SampleID SamplePoint SampleDescription TypeOfWastewater SampleType QASample SamplePointFlow FlowUnits TreatmentDescription LabName Analyte CAS LabMethod ConcentrationUnits NonDetectIndicator Detection_Amount JValueConcentration MDL QL Qualifier Qualifier_Reason Comments
Required Field Required Field
Required Field Required Field Required Field Required Field



Required Field Required Field Required Field Required Field Required Field Required Field



Required Field Required Field
Required Field Required Field Required Field

Required Field Required Field


Example Data - Delete Rows 3-7 Before Use
ABC Manufacturing Plant Industrial User
Birmingham AL AL1234567 IU000000123 420 1111 325211 1 12/31/2020 Sample001 Outfall001 IU Effluent Discharge Industrial Effluent Grab
0.075 MGD Chem Precip Jonesville Analytics Perfluorooctanoic acid (PFOA) 335-67-1 EPA 1633 ng/L D 250
2 5

Facility intends to install GAC treatment.
Springfield POTW POTW
Richmond VA VA1234567

4952 221320 12 12/31/2020 Sample002 IntakeWest After bar screen at west intake to POTW POTW Influent Grab
1 MGD
Jonesville Analytics Perfluorodecanoic acid (PFDA) 335-76-2 EPA 1633 ng/L ND
2.8 2 5 J J value
Springfield POTW POTW
Richmond VA VA1234567

4952 221320 12 12/31/2020 Sample002 IntakeWest After bar screen at west intake to POTW POTW Influent Grab
1 MGD
Jonesville Analytics Perfluorooctanoic acid (PFOA) 335-67-1 EPA 1633 ng/L D 45
2 5


Example Data - Delete Rows 3-7 Before Use








































































































































































































































































































































































































































































































































































































































































































File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2026 OMB.report | Privacy Policy