CORRECT MONITOR REGULATION COMPLIANCE

The Correct Monitor Regulation Compliances form provides the capability to correct Monitor Regulation Compliance data that failed during a batch load and therefore could not be inserted into the production tables.

More information on Batch load formats can be found in the AQS Data Coding Manual at http://www.epa.gov/ttn/airs/airsaqs/manuals/manuals.htm

 

This form will display the erroneous monitor regulation compliance data and any associated errors for the currently selected data record.

REGULATION COMPLIANCES

The Correct Monitor Regulation Compliances screen allows the user to query and correct any data associated with the user’s Screening Group.

Data may be inserted, updated or deleted on this form.

This component consists of the following fields:

Tribal Ind

Tribal Indicator. Only visible in Tribal Mode. The first position in the data line, set to "TT", it indicates that the following field contains a Tribal Code rather than a County Code. If the Screening Group has non-tribal data entered this column will have the State Code.

Tribal Code

Only visible in Tribal Mode. A FIPS code that identifies one of the federally recognized Native American tribal agencies when the Tribal Ind is set to "TT". If your Screening Group also has non-tribal data this column will contain the County Code.

State Code

A FIPS code that identifies one of the 50 US states. May also indicate a Tribal Area (TT) or other country such as Canada (CC) or Mexico (80).

County Code

A FIPS code that identifies a county or the equivalent geo-political entity, such as a parish or independent city. May also be a Tribal Area, Canadian Province or Mexican State.

Site Id

Number used to uniquely identify a site within a county. Defined and maintained by the states or Tribal agencies. When this is a Tribal site care must be taken to ensure that the site ID is unique not only in the Tribal Area but also in all of the counties that the tribal area includes or crosses.

Parameter Code

A code assigned to a specific parameter being measured and/or analyzed.

POC

Parameter Occurrence Code - A numeric sequence number used to distinguish between different monitors at one site that are measuring the same parameter.

Action Ind

Indicates the type of action ('I'nsert, 'U'pdate or' D'elete) represented by the transaction.

Session Date

The date on which a data set is first processed by the load/edit/update process.

Regulation Code

The code for the EPA regulation.

Reg Ind Compl

The field that indicates the current status of compliance. Possible values are "YES", "NO", and "WAI".

Reg Compl Date

The data on which the current compliance status was assigned.

Exclusion Ind

Indicates whether a transaction is to be excluded from edit check processing.

Exclusion Date

Date on which the exclusion indicator was set.

Row Errors

 

Search and Replace