On-Line Data Tools - Correct

On this page:

Correct overview
Row errors
Correct monitor objectives
Correct monitor types
Correct sample periods
Correct Site

Correct Overview

Correct within AQS is used to Modify data that has been staged (uploaded) but not yet fully loaded into the AQS database. Correct only works on data that has been staged and not yet loaded.

When data is submitted it is first placed in an area of the system called the "Staging Tables". Once data has been successfully processed by the AQS Load program it is no longer available to Correct.

Since each transaction is formatted differently (has a different number of fields with different content), there is a Correct form for each transaction type.

To access a correct form the user will click the Correct link in the Menu Bar, this will open a drop down menu. Here the user will select the particular form from the menu or sub-menu.

screenshot of the AQS correct menu drop down options

Under Site Data	Under Monitor Data	Under QA Transactions
Site	Monitor	One Point QC
Open Path	Sample Period	Annual Performance Evaluation
Tangent Road	Types	Semi Annual Flow Rate Audit
Site Sampler	Objectives	Flow Rate Verification
Sampler Channel	Sample Schedule	PM Coarse Semi Flow Rate Audit
	Probe Obs	Performance Evaluation Program
	Reg Compliance	NPAP
	Protocol	Field Proficiency Test
	Agency	Duplicate
	Tangent Road	Replicate
	Monitor Network Affiliations	Speciation Flow Rate Verification
	Primary Monitor Period	Speciation Semi Annual Flow Rate Audit
	Monitor Channel	Pb Analysis Audit
	Monitor Method	Lab Proficiency Test
	Monitor Exclusion	Ozone SRP and Standard Transfer Verifications
		Ambient Air Protocol Gas Verification Program

Rows Errors

The Row Errors section of the form indicates the errors or conditions on the current Correct Form row that prevented that data from properly loading.

The data displayed on the Row Errors screen is for display only (errors may not be updated or deleted) and applies only to the currently selected Correct row. Row Errors will not exist for data records being inserted.

Correct Monitor Agency Roles

To access the Correct Monitor Agency Roles form the user will click the Correct link in the Menu Bar, this will open a drop down menu. Here the user will select Monitor Data from the menu then the user will select Monitor Agency Role from the sub-menu.

The Correct Monitor Agency Role form provides the capability to correct data that failed at least one table constraint validation and therefore could not be inserted into the production tables. This form will display the erroneous monitor agency role data and any associated errors for the currently selected data record.

Correct Monitor Collocations

To access the Correct Monitor Collocations form the user will click the Correct link in the Menu Bar, this will open a drop down menu. Here the user will select Monitor Data from the menu then the user will select Collocation from the sub-menu.

The Correct Monitor Collocations form provides the capability to correct Monitor Collocation data that failed at least one table constraint validation and therefore could not be inserted into the production tables. This form will display the erroneous monitor collocation data and any associated errors for the currently selected data record.

Correct Monitor Objectives

The Correct Monitor Objectives form provides the capability to correct Monitor Objective data that failed at least one table constraint validation and therefore could not be inserted into the production tables. This form will display the erroneous monitor objective data and any associated errors for the currently selected data record.

Correct Monitor Regulation Compliances

To access the Correct Monitor Regulation Compliances form the user will click the Correct link in the Menu Bar, this will open a drop down menu. Here the user will select Monitor Data from the menu then the user will select Reg Compliance from the sub-menu.

The Correct Monitor Regulation Compliances form provides the capability to correct Monitor Regulation Compliance data that failed at least one table constraint validation and therefore could not be inserted into the production tables. This form will display the erroneous monitor regulation compliance data and any associated errors for the currently selected data record.

Correct Monitor Tangent Roads

To access the Correct Monitor Tangent Roads form the user will click the Correct link in the Menu Bar, this will open a drop down menu. Here the user will select Monitor Data from the menu then the user will select Tangent Road from the sub-menu.

The Correct Monitor Tangent Roads form provides the capability to correct Monitor Tangent Roads data that failed at least one table constraint validation and therefore could not be inserted into the production tables. This form will display the erroneous monitor tangent road data and any associated errors for the currently selected data record.

Correct Monitor Types

To access the Correct Monitor Types form the user will click the Correct link in the Menu Bar, this will open a drop down menu. Here the user will select Monitor Data from the menu then the user will select Types from the sub-menu.

The Correct Monitor Types form provides the capability to correct Monitor Types data that failed at least one table constraint validation and therefore could not be inserted into the production tables. This form will display the erroneous monitor type data and any associated errors for the currently selected data record.

Correct Monitor

To access the Correct Monitor form the user will click the Correct link in the Menu Bar, this will open a drop down menu. Here the user will select Monitor Data from the menu then the user will select Monitor from the sub-menu.

The Correct Monitor form provides the capability to correct Monitor data that failed at least one table constraint validation and therefore could not be inserted into the production tables. This form will display the erroneous monitor data and any associated errors for the currently selected data record.

Correct Probe Obstructions

To access the Correct Probe Obstructions form the user will click the Correct link in the Menu Bar, this will open a drop down menu. Here the user will select Monitor Data from the menu then the user will select Probe Obs from the sub-menu.

The Correct Probe Obstructions form provides the capability to correct Probe Obstruction data that failed at least one table constraint validation and therefore could not be inserted into the production tables. This form will display the erroneous probe obstruction data and any associated errors for the currently selected data record.

Correct Sample Periods

To access the Correct Sample Periods form the user will click the Correct link in the Menu Bar, this will open a drop down menu. Here the user will select Monitor Data from the menu then the user will select Samp Period from the sub-menu.

The Correct Sample Periods form provides the capability to correct Sample Period data that failed at least one table constraint validation and therefore could not be inserted into the production tables. This form will display the erroneous sample period data and any associated errors for the currently selected data record.

Correct Sample Schedules

To access the Correct Sample Schedules form the user will click the Correct link in the Menu Bar, this will open a drop down menu. Here the user will select Monitor Data from the menu then the user will select SAmp Schedule from the sub-menu.

The Correct Sample Schedule form provides the capability to correct Sample Schedule data that failed at least one table constraint validation and therefore could not be inserted in to the production tables. This form will display the erroneous sample schedule data and any associated errors for the currently selected data record.

Correct Site

To access the Correct Site form the user will click the Correct link in the Menu Bar, this will open a drop down menu. Here the user will select Site Data from the menu then the user will select Site from the sub-menu.

The Correct Site form provides the capability to correct Site data that failed at least one table constraint validation and therefore could not be inserted into the production tables. This form will display the erroneous sample period data and any associated errors for the currently selected data record.

Correct Open Paths

To access the Correct Open Paths form the user will click the Correct link in the Menu Bar, this will open a drop down menu. Here the user will select Site Data from the menu then the user will select Open Path from the sub-menu.

The Correct Open Paths form provides the capability to correct Site Open Path data that failed at least one table constraint validation and therefore could not be inserted into the production tables. This form will display the erroneous site open path data and any associated errors for the currently selected data record.

Correct Site Tangent Road

To access the Correct Sites Tangent Roads form the user will click the Correct link in the Menu Bar, this will open a drop down menu. Here the user will select Site Data from the menu then the user will select Tangent Road from the sub-menu.

The Correct Sites Tangent Roads form provides the capability to correct Site data that failed at least one table constraint validation and therefore could not be inserted into the production tables. This form will display the erroneous site tangent road data and any associated errors for the currently selected data record.

Previous | Next