The Correct Site Open Path 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.
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 site open path data and any associated errors for the currently selected data record.
The Correct Open Paths 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 form 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.
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 site open path number for a site open path transaction.
The transmitter compass sector for a site open path transaction.
The beam length measurement for a site open path transaction.
The transmitter height for a site open path transaction.
The receiver height for a site open path transaction.
The minimum beam height for a site open path transaction.
The maximum beam height for a site open path transaction.
The land use type for a site open path transaction.
Indicates whether a transaction is to be excluded from edit check processing.
Date on which the exclusion indicator was set.