Skip to main content
U.S. flag

An official website of the United States government

Here’s how you know

Dot gov

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

HTTPS

Secure .gov websites use HTTPS
A lock (LockA locked padlock) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

    • Environmental Topics
    • Air
    • Bed Bugs
    • Cancer
    • Chemicals, Toxics, and Pesticide
    • Emergency Response
    • Environmental Information by Location
    • Health
    • Land, Waste, and Cleanup
    • Lead
    • Mold
    • Radon
    • Research
    • Science Topics
    • Water Topics
    • A-Z Topic Index
    • Laws & Regulations
    • By Business Sector
    • By Topic
    • Compliance
    • Enforcement
    • Laws and Executive Orders
    • Regulations
    • Report a Violation
    • Environmental Violations
    • Fraud, Waste or Abuse
    • About EPA
    • Our Mission and What We Do
    • Headquarters Offices
    • Regional Offices
    • Labs and Research Centers
    • Planning, Budget, and Results
    • Organization Chart
    • EPA History

Breadcrumb

  1. Home
  2. Air Quality System (AQS)
  3. All Manuals and Guides
  4. User Guide

On-Line Data Tools - Correct Raw Data

Correct Raw Data

This section covers how to correct Raw Data. 

[Note] correcting other transaction types (with the exception of QA, which is described later) will work identically.

Procedure Overview

  1. The user will select the correct form from the menu or sub-menu
  2. The user will query the data requiring correcting from the AQS database
  3. The user will edit the data
  4. The user will save the data back to the AQS staging area

Open Correct Raw Data Form

To access the Raw Data Form the user will click the Correct link in the Menu Bar, this will open a drop down menu.  Here the user will click the Raw link from the menu.

screenshot of the aqs correct drop down menu with the raw option highlighted

This will open the Raw Data Form.

screenshot of the AQS Correct Raw data form

Query Data

The user will query data from the database in to the form.

screenshot highlighting the query data buttons in AQS

The principle buttons used for query operations are:

zoom in on the AQS principle query buttons
(1) Enter Query  (2) Execute Query  (3) Cancel Query

Enter Query

When the form opens it defaults to query mode as evidenced by "Enter Query" in the status bar at the bottom.  It assumes the user wants to bring data from the AQS database in the form and allows the user to query all data or limit the data by inputting specific parameters.  If the user would prefer to enter data manually then the user must click the cancel query button.  However, once the user has begun to enter data manually the query function is no longer available unless the user clears the form.

The purpose of the Enter Query function is to bring data from the database into the form, edit it, and save it back into the AQS database.

Entering values into any field will allow the user to narrow searches.  For example, if the user wanted only data for a specific state, the user would enter the corresponding a state code.  If the user wanted data for just one parameter in a specific state the user would enter the state code and a parameter code.

A correct form will never bring back data not loaded by the user's screening group.

Once the user has entered query criteria the user will execute the query to bring the data from AQS into the form.

Execute Query

Ths button retrieves all of the user's screening group data, matching the query criteria, into the Correct form.  If no query criteria was entered al data from the screening group will be returned.

[Note] all records in the staging tables that match the query criteria will be returned.  In the old-style correct forms, there is no way to retrieve only the data that was submitted in a specific file.

To retrieve all the queried data to the form the user will click the Last Record button, otherwise the data is retrieved on screen/page at a time.

screenshot highlighting the AQS last record button

The status bar at the bottom left of the screen will display the number of records retrieved from the database to the form.

screenshot highlighting an example of query returned record count and where it is located

Cancel Query

This button cancels any active query and cancels the query mode.

The user may need to use this button to execute a second query if the first returned no data.  After the user has executed a query with no results the Cancel Query button should be clicked then clicking the Enter Query button will allow the user to enter new criteria.

Edit Data

Once the data is in the form changes can be made to it.  There are two ways to do this.

Edit options

  1.  Type Over

Edit the data field by field (box by box) on the screen.  The user will select text or place the cursor where necessary and insert, delete, or replace text.

  1. Global Replace

Perform a "search and replace" in a single column.  The user does this by placing the cursor in the value to be replaced.

screenshot in AQS raw data form illustrating how to edit individual cell

Then press the Search and Replace icon

Screenshot highlighting the search and replace button in AQS

This will bring up a window that will allow the user to replace every occurrence in that column for all data retrieved by the query.

[Note] this operation does not work like any other program; "Replace" and "Replace All" replace every value in that column with the new value, not just the ones with the "Current Value".

screenshot showing an example of the search and replace function in AQS

Search and Replace

Search and Replace allows the user to search within the specified column and replace specific values with a new value or to replace al values in the column with a new value.

The Replace Item is automatically populated with the name of the column the user was on before launching the Search and Replace.  The Current Value field is automatically populated with the value of the column the user was on prior to launching the search and replace.

Save the Data

After the data has been edited it is still only in the form until it is saved.  Clicking the save icon will save the changes to the database.

screenshot highlighting the AQS save button

Other Correct Features

screenshot highlighting additional AQS correct features
zoom in of the other AQS correct function buttons
  1. Insert Record:  Inserts a new blank record after the highlighted one.
  2. Remove Record:  Deletes the highlighted record.
  3. Duplicate Record:  Duplicates a record.
  4. Clear Record:  Deletes all of the contents of the fields, but not the record.

[Note] when transactions are inserted, they are associated with an "on-line" session rather than a previously submitted file.  On the Batch form they will be in a file named "ONLINE_UU_NNNN"; where "UUU" is the user's AQS user-id and "NNNN" is a unique number.

The Delete All Selected button

screenshot highlighting the AQS delete all selected button

This button deletes all records that were returned by the query.

[Note] this deletes all records that are listed in the display not just the selected records on the screen.


Previous  |  Next

Air Quality System (AQS)

  • AQS User Support
    • New User Registration
    • Training
    • Events Calendar
    • Java Memo
  • All Manuals and Guides
    • User Guide
      • AQS at a Glance
      • ENSC at a Glance
      • Logging On
      • Site ID Format
      • Batch Submission - Overview
      • Batch Submission - Using the ENSC
      • Batch Submission - Loading Using AQS
      • Batch Submission - Type of Data
      • Correct - Overview
      • Correct - Raw Data
      • Correct - 1-PT QC
      • Maintain - Overview
      • Maintain - Site
      • Maintain - Monitor
      • Maintain - Adding Events
      • Maintain - QA
      • Setting Up Samplers
      • Data Reports
      • CA Dump Bucket
      • Logging Off and Additional Info
    • Code Lists
    • Data Dictionary
    • Data Coding Manual
    • AQS Primer
    • AQS Frequent Questions
  • Related Resources
    • Monitoring and Policy Memos
    • AQS Pollutant Memos
    • Quality Assurance and Audits Memos
  • Archive Data
  • Obtaining AQS Data
    • API
    • About AQS Datamart
    • Pre-Generated Data
AQS Contact Us
Contact Us to ask a question, provide feedback, or report a problem.
Last updated on December 17, 2024
  • Assistance
  • Spanish
  • Arabic
  • Chinese (simplified)
  • Chinese (traditional)
  • French
  • Haitian Creole
  • Korean
  • Portuguese
  • Russian
  • Tagalog
  • Vietnamese
United States Environmental Protection Agency

Discover.

  • Accessibility Statement
  • Budget & Performance
  • Contracting
  • EPA www Web Snapshot
  • Grants
  • No FEAR Act Data
  • Plain Writing
  • Privacy
  • Privacy and Security Notice

Connect.

  • Data
  • Inspector General
  • Jobs
  • Newsroom
  • Regulations.gov
  • Subscribe
  • USA.gov
  • White House

Ask.

  • Contact EPA
  • EPA Disclaimers
  • Hotlines
  • FOIA Requests
  • Frequent Questions
  • Site Feedback

Follow.