How to submit data in our Electronic Data Delivery format
A DEQ training session explaining how to use the Electronic Data Delivery (EDD) template for pre-treatment annual reports. The session covers template navigation, data entry procedures, and additional requirements specific to pre-treatment data submission.
Summary
This training session was conducted by Nicole Morris, DEQ's pre-treatment coordinator, and Carter Thomas, DEQ's data steward, to explain the Electronic Data Delivery (EDD) template usage for pre-treatment annual reports. The session was requested at the last pre-treatment subcommittee meeting of ACWA to help users unfamiliar with the template. Carter Thomas demonstrated how to download the template from DEQ's website, navigate its various tabs (including monitoring location info, results info, and example data), and properly fill out data fields including monitoring locations, sample results, detection limits, qualifiers, and laboratory information. He emphasized the importance of using specific location identifiers, 24-hour time format, descriptive media types, and proper formatting for non-detect results (using 'less than' values rather than 'ND'). Nicole Morris then explained the additional requirements specific to pre-treatment annual reports, including the need to add a new sheet containing treatment plant flow data (influent and effluent), removal rates for each sampling day, and narrative information about disposal method changes, approved test methods, and data anomalies. She stressed that the results tab must remain as the sixth sheet for proper database integration. The session concluded with a Q&A period addressing questions about removal rate calculations, comment field sizing, data dictionary requirements, and specific formatting concerns from various municipal facilities.
About this episode
Contacts Nicole Morris and Carter Thomas
Key Insights
- Nicole Morris explains that the training was specifically requested at the last pre-treatment subcommittee meeting of ACWA because some people have not used the EDD template before
- Carter Thomas states that the same EDD template used for toxics and copper biotic ligand model monitoring will be used for pre-treatment data with some additions
- Carter Thomas emphasizes that DEQ wants descriptive media types like 'municipal effluent' or 'surface water' rather than just 'water' to allow proper data filtering
- Nicole Morris clarifies that for non-detect results, DEQ wants to see 'less than the detection limit' rather than 'ND' or just zero, as those are not accurate enough for their purposes
- Nicole Morris explains that when adding pre-treatment specific data, users must ensure the results tab remains as the sixth sheet because it's set up to automatically route into the water quality database
- Carter Thomas notes that detection limits will always be less than or equal to reporting limits, explaining that you can detect things before you're sure you can report them
- Nicole Morris states that DEQ will accept the additional pre-treatment information sheet in whatever form it comes so long as it contains all the relevant required information
- Carter Thomas mentions that the template will change slightly to meet DEQ's new accessibility standards, but this won't affect functionality or the way data is filled out
Topics
Transcript
[0:03] This is going to be the DEQ pre-treatment training on how to use the EDD template. It was requested at the last pre-treatment subcommittee meeting of ACWA that DEQ do a training on this as we have some people who have not used the EDD template before. So, this training is designed to go over that template, what you should put in that, what we want to see, how we want to get it back, and basically explain the form three of the pre-treatment annual report. And we'll just jump [0:43] right in. So, I'm Nicole Morris. I'm the DEQ's pre-treatment coordinator. And with me I have Carter Thomas, the DEQ's data steward. And I'll let Carter Thomas reintroduce…
Full transcript available for MurmurCast members
Sign Up to AccessMore from Oregon Department of Environmental Quality
Information Session, March 10, 2026
DEEQ hosted an information session for their $2 million Reduce Reuse Reimagine grant program, focusing on reducing exposure to toxic substances in building materials within Oregon's built environment. The session covered eligibility requirements, application processes, and project examples for the 2026 funding cycle.
Cleaner Air Oregon Toxic Air Contaminant Review and Update 2026- RAC Meeting #1
Oregon DEQ and OHA held the first Rules Advisory Committee meeting for updating Cleaner Air Oregon's toxic air contaminant standards. The agencies presented their comprehensive 3-year process for reviewing and updating Toxicity Reference Values (TRVs) with input from the Air Toxic Science Advisory Committee (ATSAC), covering 377 contaminants and resulting in 623 proposed TRV updates.
Reporting in Your DEQ Online for General Permits with Annual Reports
This training session demonstrates how to complete annual reports for Oregon DEQ general permits using the Your DEQ Online platform. Amanda Hallmark and colleagues from Oregon DEQ walk through the system navigation and provide detailed examples of filling out three different permit types: 700PM suction dredge mining reports, 1400A wastewater reports, and 2300A pesticide application reports.
Quarterly electricity transactions verification training
This is a training session by DEQ's Courtney Herbolsheimer on verifying quarterly electricity transactions reporting for Oregon's Clean Fuels Program. The training covers registration requirements, fuel pathway codes, verification considerations, and specific challenges with electric vehicle chargers and forklifts.