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.
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 objective data and any associated errors for the currently selected data record.
The Correct Monitor Objectives 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 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.
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.
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).
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.
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.
A code assigned to a specific parameter being measured and/or analyzed..
Parameter Occurrence Code - A numeric sequence number used to distinguish between different monitors at one site that are measuring the same parameter.
Indicates the type of action ('I'nsert, 'U'pdate or' D'elete) represented by the transaction.
The date on which the load/edit/update process first processes a data set.
A reason for measuring air quality at a monitor.
A code indicating in which of the established urbanized areas the site is located.
A demographic area, called Metropolitan Statistical Area, defined by the Census Bureau. An MSA must include 1) a city with > 50,000 residents, or 2) an Urbanized Area and total metropolitan population of > 100,000
A Census Bureau demographic category that has a population of > 1 million, and has separate component MSAs. (Component MSAs are called Primary MSAs or PMSAs.)
Indicates whether a transaction is to be excluded from edit check processing.
Date on which the exclusion indicator was set.