The Correct Raw Data form corrects information about the concentrations of various air pollutants measured by air monitoring equipment 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 raw data and any associated errors for the currently selected data record.
The Correct Raw Data 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.
The code indicating the sampling interval used for the monitoring activities.
Unit of measurement from a transaction file used in reporting the given data.
Code that identifies a particular method for collecting and analyzing samples for the time period.
The date from a transaction file that the sample value was collected.
The time from a transaction file that the sample value was collected. Enter value in hours:minutes, using a twenty-four clock (HH24:MI).
The value from a transaction file of the sample expressed in reported units.
A code denoting a qualifier of the "null data" type. List of values is sorted by qualifier code and is limited to those available for the parameter code
A code denoting a collection frequency.
Identification number assigned by the monitor owner to identify that a particular protocol is using an alternate MDL.
A code denoting an event qualifier.
A code denoting a qualifier.
A code denoting a qualifier.
A code denoting a qualifier.
A code denoting a qualifier.
A code denoting a qualifier.
A code denoting a qualifier.
A code denoting a qualifier.
A code denoting a qualifier.
A code denoting a qualifier.
Indicates whether a transaction is to be excluded from edit check processing.
Date on which the exclusion indicator was set.