Return to AQS Documents

Transaction Formats

AQS Transaction Formats

This page describes the input transaction formats for AQS data.

The first field of all input formats is the transaction type, i.e., "RD", which indicates the type of data in the record. (Valid transaction types are listed below.) The second field is the Action Indicator, i.e. "I" for insert, "U" for update, and "D" for delete, which indicates the requested database manipulation action. The next block of fields is the primary key information which usually includes the State Code (or Tribal Indicator), County Code (or Tribal Code), Site ID, Parameter, and POC. It may also include assessment type or agency identifier. The combination of key fields serves to uniquely identify the record.

All transactions are pipe delimited ("|"). If you need to report a given field as null, place two delimiters back to back ("||"). Text fields should not be enclosed with single or double quotation marks. A delimiter does not need to follow the final field in a record, so there will always be one less delimiter than fields for the given transaction type.

When changing a record, populate all the required fields. Once the required fields are included, it is not necessary to supply non-required information, and you also do not need to pad the transaction with delimiters.

Example: You need to only update probe height (which is the 13th field in the "Monitor Basic" transaction) and you can ignore empty trailing field delimiters in that row as long as none of these fields are required. A complete transaction would look like:

MA|U|01|005|0002|88502|5||||||2||||||||||||||||20060312|

But all that is required is this:

MA|U|01|005|0002|88502|5||||||2

Please Note the formatting rules described in this document are a "quick reference" and not comprehensive. For the full description of how AQS will validate your input, please refer to the Data Coding Manual (PDF).

Transaction types available for submission:



AA - Site Basic

Seq. Name Description Formatting Rules Required
1 Transaction Type Basic Site Info transaction identifier Must = AA Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
4 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
5 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
6 Latitude The angular distance north or south of the equator measured in decimal degrees. North is positive. Decimal, must be in county specified above Lat/Lon or UTM required
7 Longitude The angular distance east or west of the prime meridian measured in decimal degrees. East is positive. Decimal, must be in county specified above Lat/Lon or UTM required
8 UTM Zone The zone of the universal transverse Mercator (UTM) geographic system. Integer - 2 digit. Lat/Lon or UTM required
9 UTM Easting The easting UTM coordinate, expressed in meters. Decimal. Lat/Lon or UTM required
10 UTM Northing The northing UTM coordinate expressed in meters. Decimal. Lat/Lon or UTM required
11 Horizontal Collection Method Method used to determine the latitude/longitude or UTM coordinates. Must exist in LDP COLLECTION METHODS reference table. Insert
12 Horizontal Datum The geographic datum used as a baiss for lat/lon or UTM coordinates. Must exist in LDP HORIZONTA DATA reference table. Insert
13 Source Scale Identifies the ratio of a map distance to an actual distance. Decimal. If map is source
14 Horizontal Accuracy Description of the accuracy of the site coordinates, in meters. Decimal. Insert
15 Vertical Measure The elevation of the ground at the site, in meters above mean sea level (MSL). Decimal. Insert
16 Time Zone The name of the region representing an offset from Greenwich mean time (GMT). Must exist in TIME ZONES reference table. Insert
17 Agency Code Identifies the agency responsible for the operation of the monitoring site. Must exist in AGENCIES reference table. Insert
18 Street Address Specifies the building/street location of the monitoring site. Text. Insert
19 City Code The city within whose incorporated boundaries the monitoring site is located. Must exist in CITIES reference table. No
20 Urban Area Code The urbanized area (census defined) within which the monitoring site is located. Must exist in URBANIZED AREAS reference table. No
21 AQCR The Air Quality Control Region where the site is located. Must exist in AQCRs reference table. No
22 Land Use Type Categorization of the prevalent land use within 1/4 mile of the monitoring site. Must exist in LAND USE TYPES reference table. Insert
23 Location Setting A description of the environmental setting within which the site is located. Must exist in LOCATION SETTINGS reference table. Insert
24 Date Site Established The date on which an air monitoring site began collecting air quality data. YYYYMMDD. Insert
25 Date Site Terminated The date on which a monitoring site ceased to operate. YYYYMMDD. No
26 Zip Code The US Postal Service code of the site. Must exist in ZIP CODES reference table. No
27 Congressional District The Congressional district within which the site is located. Must exist in CONGRESSIONAL DISTRICTS reference table. No
28 Block The US Census Bureau block within which the site is located. Must exist in BLOCKS reference table. No
29 Block Group This field is ignored by AQS. N/A No
30 Census Tract The US Census Bureau tract within which the site is located. Must exist in BLOCKS reference table. No
31 Class I Area The Class One Area within which the site is located. Must exist in CLASS ONE AREAS reference table. No
32 Local Region The state-specific geographic/administrative area within which the site is located. Must exist in LOCAL REGIONS reference table. No
33 Local Site Name The locally defined name of the site. Text (up to 70 characters). No
34 HQ Evaluation Date The date on which the most recent headquarters (HQ) evaluation of the site occurred. YYYYMMDD. No
35 EPA Region Evaluation Date The date on which the most recent EPA Regional Evaluation of the site for siting criteria occurred. YYYYMMDD. No
36 Direction from Central Business District to Site A representation of the true, as opposed to magnetic, direction of the site from the central business district. Must exist in COMPASS SECTORS reference table. No
37 Distance from Central Business District to Site The distance, in kilometers, to the site from the center of the downtown central business district of the city in which the site is located. Decimal. No
38 Meteorological Site Type The type of meteorological station identified for the monitoring site. Required for PAMS sites. Must exist in MET SITE TYPES reference table. Conditional
39 Meteorological Site ID The AQS Site ID where meteorological data is collected, if not collected at this site. Must exist in AQS SITES table. If met site type provided
40 Distance to Meteorological Site The distance of the associated meteorological site from the air quality monitoring site, in meters. Decimal. If met site type provided
41 Direction to Meteorological Site A representation of the true, as opposed to magnetic, direction of the meteorological site from this site. Must exist in COMPASS SECTORS reference table. If met site type provided
42 Local Site ID Identification code used by a State, Tribe or Local agency, if different from the AQS Site ID. Text. No
43 Vertical Collection Method The method used to determine the vertical measure. Must exist in LDP VERTICAL METHODS reference table. Insert
44 Vertical Datum The geographic datum used as a baiss for vertical coordinates. Must exist in LDP VERTICAL DATA reference table. Insert
45 Vertical Accuracy Description of the accuracy of the Vertical Measure, reported in meters. Decimal. Insert

AB - Site Street

Seq. Name Description Formatting Rules Required
1 Transaction Type Site Street Info transaction identifier. Must = AB Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
4 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
5 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
6 Tangent Street Number Identifies a street near the site. Integer - 2 digit. Always
7 Street Name The name of the street. Text (up to 50 characters). Insert
8 Road Type The type of the street. Must exist in ROAD TYPES reference table. Insert
9 Traffic Count An estimate of the daily traffic volume on the street. Integer. Insert
10 Year of Traffic Count The year for which the traffic count value was estimated. Four digit year (YYYY). Insert
11 Direction from Site to Street The true direction from the site to the street at its nearest point. Must exist in COMPASS SECTORS reference table. Insert
12 Source of Traffic Count The method by which the traffic volume/flow count was obtained. Must exist in TRAFFIC VOLUME SOURCES reference table. No

AC - Site Open Path

Seq. Name Description Formatting Rules Required
1 Transaction Type Site Open Path Info transaction identifier. Must = AC Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
4 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
5 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
6 Open Path Number A unique numeric identifier for an open path at a site. Integer - 2 digit. Always
7 Direction from Receiver to Transmitter The true direction from the receiver to the transmitter at the site. Must exist in COMPASS SECTORS reference table. Insert
8 Beam Length The length of the beam projected between the transmitter and the receiver, in meters. Decimal. Insert
9 Height of Transmitter The height of the transmitter above the ground, in meters. Decimal. Insert
10 Height of Receiver The height of the receiver above the ground, in meters. Decimal. Insert
11 Minimum Beam Height The height of the beam at the lowest point from the ground, in meters. Decimal. Insert
12 Maximum Beam Height The height of the beam at the highest point from the ground, in meters. Decimal. Insert
13 Land Use Under Path The prevalent land use under the path of the beam. Must exist in LAND USE TYPES reference table. Insert

AD - Site Sampler

Seq. Name Description Formatting Rules Required
1 Transaction Type Site-Sampler transaction identifier. Must = AD Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
4 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
5 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
6 Sampler ID The user assigned unique name or id for the sampler at the site (e.g. Speciation-1). The user assigned unique name or id for the sampler at the site (e.g. Speciation-1). Always
7 Sampler Owner Agency code of the agency that owns the sampler. Must exist in AGENCIES reference table. Always
8 Manufacturer Equipment manufacturer. Text String (limited to 80 characters) Insert
9 Model Number Manufacturer's model number. Text String (limited to 40 characters) Optional
10 Serial Number Manufacturer's serial number. Text String (limited to 40 characters) Optional
11 Channel Count Number of distinct concurrent samples that can be taken by the sampler. Positive Number Optional
12 Begin Date Beginning of date range where the sampler is in use at the site. Date in 'YYYYMMDD' format Insert
13 End Date End of date range where the sampler is in use at the site. Date in 'YYYYMMDD' format Always

AE - Site Sampler Channel

Seq. Name Description Formatting Rules Required
1 Transaction Type Sampler-Channel transaction identifier. Must = AE Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
4 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
5 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
6 Sampler ID The user's unique name or id for the sampler at the site. Must exist for Site in database Always
7 Channel Number Number assigned to channel on sampler Positive Number; must be <= the channel count for the sampler Always
8 Filter Type Type of filter loaded into this channel in sampler (e.g. Quartz) Must exist in AQS FILTER_TYPES table. Optional
9 Target Flow Rate Nominal flow rate for channel Positive number Optional
10 Flow Units Units code of target flow rate Must exist in AQS Units table with unit type of "FLOW" Required if Target Flow Rate not null
11 Begin Date Beginning of date range where the channel has the specified metadata. Date in 'YYYYMMDD' format Always
12 End Date End of date range where the channel has the specified metadata. Date in 'YYYYMMDD' format Never

MA - Monitor Basic

Seq. Name Description Formatting Rules Required
1 Transaction Type Monitor Basic Info transaction identifier. Must = MA Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
4 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
5 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
6 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
7 POC Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. Must exist in MONITOR table for non-Insert actions. Always
8 Project Class The type of sampling performed by the monitor. Must exist in PROJECT TYPES reference table. No
9 Dominant Source The primary source of the pollutant being measured. Must exist in DOMINANT SOURCES reference table. No
10 Measurement Scale The geographic scope represented by the air quality measurements made by the monitor. Must exist in MEASUREMENT SCALES reference table. No
11 Open Path Number The specific open path number registered at the site that the monitoring data and monitor represent. Must exist in (site) OPEN PATH table. No
12 Probe Location Code A description of the location of the sampling probe. Must exist in PROBE LOCATIONS reference table. No
13 Probe Height The height of the sampling probe above the ground in meters. Decimal. No
14 Probe Horizontal Distance The horizontal distance, in meters, of the probe from its supports. Decimal. No
15 Probe Vertical Distance The vertical distance, in meters, of the probe from its supports. Decimal. No
16 Surrogate Indicator Indicates whether a Total Suspended Particulate (TSP) monitor serves as a surrogate monitor for PM-10. Must = Y or N. No
17 Unrestricted Air Flow Indicator Indication of whether the flow of air to the monitor is unrestricted. Must = Y or N. No
18 Sample Residence Time The time in seconds for the sample to move from the probe inlet to the monitor. Decimal. No
19 Worst Site Type Site type categorization for PM10 monitors. Must exist in WORST SITE TYPES reference table. No
20 Applicable NAAQS Indicator Indicates if data from monitor should be compared to either the short-term or annual NAAQS, or both Must = S, A, or B. No
21 Spatial Average Indicator Indicates if spatial averaging is to be performed on annual weighted means for sites in the same community monitoring zone. Must = Y or N. No
22 Schedule Exemption Indicator Indicates whether the sampling schedule differs from that required by the standard by approval of the Regional Administrator. Must = Y or N. No
23 Community Monitoring Zone A sequential number assigned to an optional averaging area. Integer - 4 digit. No
24 Pollutant Area Code - 1 Designation of pollutant areas to which the monitor is assigned. Must exist in POLLUTANT AREAS reference table. No
25 Pollutant Area Code - 2 Designation of pollutant areas to which the monitor is assigned. Must exist in POLLUTANT AREAS reference table. No
26 Pollutant Area Code - 3 Designation of pollutant areas to which the monitor is assigned. Must exist in POLLUTANT AREAS reference table. No
27 Pollutant Area Code - 4 Designation of pollutant areas to which the monitor is assigned. Must exist in POLLUTANT AREAS reference table. No
28 Pollutant Area Code - 5 Designation of pollutant areas to which the monitor is assigned. Must exist in POLLUTANT AREAS reference table. No
29 Close Date Can be supplied to AQS to end all subordinate monitor records. YYYYMMDD. No

MB - Monitor Sampling Period

Seq. Name Description Formatting Rules Required
1 Transaction Type Monitor Sampling Period transaction identifier. Must = MB Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
4 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
5 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
6 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
7 POC Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. Must exist in MONITOR table for non-Insert actions. Always
8 Date Sampling Began The date on which a distinct period of operations began. YYYYMMDD. Always
9 Date Sampling Ended The date on which a distinct period of operations ended. YYYYMMDD. No

MC - Monitor Type

Seq. Name Description Formatting Rules Required
1 Transaction Type Monitor Type Info transaction identifier. Must = MC Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
4 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
5 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
6 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
7 POC Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. Must exist in MONITOR table for non-Insert actions. Always
8 Monitor Type The monitor's administrative classification as determined by the purpose for the monitor in the agency sampling strategy. Must exist in MONITOR TYPES reference table. Always
9 Monitor Type Begin Date The date on which the monitor type assignment went into effect. YYYYMMDD. Always
10 Monitor Type End Date The date on which the monitor type assignment ceased being in effect. YYYYMMDD. No

MD - Monitor Agency Role

Seq. Name Description Formatting Rules Required
1 Transaction Type Monitor Agency Role transaction identifier. Must = MD Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
4 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
5 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
6 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
7 POC Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. Must exist in MONITOR table for non-Insert actions. Always
8 Agency Role Name Classification of the role of an agency with regard to the monitor. Must exist in AGENCY ROLES reference table. Insert
9 Agency Code Code representing the agency given the role. Must exist in AGENCIES reference table. Always
10 Agency Role Begin Date Date the role took effect. YYYYMMDD. Insert
11 Agency Role End Date Date the role ceased being in effect. YYYYMMDD. No

ME - Monitor Objective

Seq. Name Description Formatting Rules Required
1 Transaction Type Monitor Objective transaction identifier. Must = ME Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
4 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
5 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
6 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
7 POC Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. Must exist in MONITOR table for non-Insert actions. Always
8 Monitor Objective Type Identification of the reason for measuring air quality by the monitor. Must exist in MONITOR OBJECTIVE TYPES reference table. Always
9 Urban Area Represented The urbanized area from which the concentrations originated (not the location of the monitor). Must exist in URBANIZED AREAS reference table. Insert
10 MSA Represented This field is ignored by AQS. N/A No
11 CMSA Represented This field is ignored by AQS. N/A No
12 CBSA Represented The Core Based Statistical Area (CBSA) from which the concentrations originated, not the location of the monitor. Must exist in CORE BASED STATISTICAL AREAS reference table. CBSA or CSA required
13 CSA Represented The Combined Statistical Area (CSA) from which the concentrations originated, not the location of the monitor. Must exist in COMBINED STATISTICAL AREAS reference table. CBSA or CSA required

MF - Monitor Sampling Schedule

Seq. Name Description Formatting Rules Required
1 Transaction Type Monitor Sampling Schedule transaction identifier. Must = MF Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
4 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
5 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
6 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
7 POC Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. Must exist in MONITOR table for non-Insert actions. Always
8 Required Collection Frequency Code Code representing the sample collection freqency for PAMS and PM2.5 and PM10 Must exist in COLLECTION FREQUENCIES reference table. Always
9 Required Collection Frequency Begin Date The date on which the required collection frequency (RCF) went into effect. YYYYMMDD. Always
10 Required Collection Frequency End Date The date on which the required collection frequency (RCF) ceased being in effect. YYYYMMDD. No
11 Monthly Required Collection Frequency - Jan Specifies the collection frequency required within an indicated month. Integer - 12 digit. No
12 Monthly Required Collection Frequency - Feb Specifies the collection frequency required within an indicated month. Integer - 12 digit. No
13 Monthly Required Collection Frequency - Mar Specifies the collection frequency required within an indicated month. Integer - 12 digit. No
14 Monthly Required Collection Frequency - Apr Specifies the collection frequency required within an indicated month. Integer - 12 digit. No
15 Monthly Required Collection Frequency - May Specifies the collection frequency required within an indicated month. Integer - 12 digit. No
16 Monthly Required Collection Frequency - Jun Specifies the collection frequency required within an indicated month. Integer - 12 digit. No
17 Monthly Required Collection Frequency - Jul Specifies the collection frequency required within an indicated month. Integer - 12 digit. No
18 Monthly Required Collection Frequency - Aug Specifies the collection frequency required within an indicated month. Integer - 12 digit. No
19 Monthly Required Collection Frequency - Sep Specifies the collection frequency required within an indicated month. Integer - 12 digit. No
20 Monthly Required Collection Frequency - Oct Specifies the collection frequency required within an indicated month. Integer - 12 digit. No
21 Monthly Required Collection Frequency - Nov Specifies the collection frequency required within an indicated month. Integer - 12 digit. No
22 Monthly Required Collection Frequency - Dec Specifies the collection frequency required within an indicated month. Integer - 12 digit. No

MG - Monitor Tangent Road

Seq. Name Description Formatting Rules Required
1 Transaction Type Monitor Tangent Roads transaction identifier. Must = MG Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
4 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
5 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
6 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
7 POC Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. Must exist in MONITOR table for non-Insert actions. Always
8 Tangent Street Number Number from Site record identifying a nearby street. Must exist in site tangent street table. Always
9 Distance from Monitor to Tangent Road The distance in meters between the sensing of air sampling equipment at a monitoring site and the nearest edge of the roadway. Decimal. Unless Delete

MH - Monitor Obstruction

Seq. Name Description Formatting Rules Required
1 Transaction Type Monitor Obstruction Info transaction identifier. Must = MH Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
4 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
5 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
6 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
7 POC Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. Must exist in MONITOR table for non-Insert actions. Always
8 Probe Obstruction Type The type of obstruction responsible for the restricted air flow of a monitor. Must exist in PROBE OBSTRUCTION TYPES reference table. Always
9 Direction from Monitor to Probe Obstruction The true direction from the monitor to the obstruction. Must exist in COMPASS SECTORS reference table. Always
10 Distance from Monitor to Probe Obstruction The distance, in meters, between the probe and obstruction. Decimal. Always
11 Probe Obstruction Height The height, in meters, of the top of the obstruction above the probe. Decimal. Always

MI - Monitor Regulatory Compliance

Seq. Name Description Formatting Rules Required
1 Transaction Type Monitor Regulatory Compliance transaction identifier. Must = MI Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
4 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
5 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
6 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
7 POC Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. Must exist in MONITOR table for non-Insert actions. Always
8 Regulation Code Identification of an EPA regulation for which compliance documentation is required. Must exist in PARAMETER REGULATIONS reference table. Always
9 Compliance Indicator The compliance status of a monitor with respect to an EPA regulation. Must = Y or N. No
10 Compliance Date The date on which the current status of the monitor's compliance with the regulation was achieved. YYYYMMDD. No

MJ - Monitor Collocation Period

Seq. Name Description Formatting Rules Required
1 Transaction Type Monitor Collocation Period transaction identifier. Must = MJ Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
4 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
5 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
6 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
7 POC Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. Must exist in MONITOR table for non-Insert actions. Always
8 Collocation Begin Date The begin date when a collocated monitor pair recorded precision and accuracy data. YYYYMMDD. Always
9 Collocation End Date The end date when a collocated monitor pair recorded precision and accuracy data. YYYYMMDD. No
10 Distance from Primary Sampler The distance, in meters, between the samplers. Decimal. No
11 Primary Sampler Indicator Indicates if the monitor is the primary of the pair. Must = Y or N. Always

MM - Monitor Method

Seq. Name Description Formatting Rules Required
1 Transaction Type Monitor Method transaction identifier. Must = MM Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
4 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
5 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
6 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
7 POC Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. Must exist in MONITOR table for non-Insert actions. Always
8 Method Code The sampling methodology (i.e. method of collection and analysis) implemented by monitor. Must exist in SAMPLING METHODOLOGIES Reference table Always
9 Begin Date Beginning of date range where the monitor implements the specified method. YYYYMMDD. Always
10 End Date End of date range where the monitor implements the specified method. YYYYMMDD. No

MN - Monitor Network Affiliation

Seq. Name Description Formatting Rules Required
1 Transaction Type Monitor Network Affiliation transaction identifier. Must = MN Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
4 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
5 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
6 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
7 POC Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. Must exist in MONITOR table for non-Insert actions. Always
8 Network Name Monitoring network associated with monitor (e.g. NCORE, PAMS, NATTS) Must exist in MONITORING NETWORKS table. Always
9 Begin Date Beginning of date range where the monitor is affiliated with the specified network. YYYYMMDD. Always
10 End Date End of date range where the monitor affiliated with the specified network. YYYYMMDD. No

MO - Monitor Primary Period

Seq. Name Description Formatting Rules Required
1 Transaction Type Monitor Primary Period transaction identifier. Must = MO Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
4 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
5 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
6 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
7 POC Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. Must exist in MONITOR table for non-Insert actions. Always
8 Begin Date Beginning of date range where the monitor is the primary for the parameter at the site. YYYYMMDD. Always
9 End Date End of date range where the monitor the primary for the parameter at the site. YYYYMMDD. No

MP - Monitor Channel

Seq. Name Description Formatting Rules Required
1 Transaction Type Monitor Channel Info transaction identifier. Must = MP Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
4 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
5 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
6 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
7 POC Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. Must exist in MONITOR table for non-Insert actions. Always
8 Sampler ID The user's unique name or id for the sampler at the site. Must exist for Site in database Always
9 Channel Number Number assigned to channel on sampler Must be defined for Sampler in database Always
10 Begin Date Beginning of date range where the monitor is the primary for the parameter at the site. YYYYMMDD. Always
11 End Date End of date range where the monitor the primary for the parameter at the site. YYYYMMDD. No

MX - Monitor NAAQS Exclusion

Seq. Name Description Formatting Rules Required
1 Transaction Type Monitor NAAQS Exclusion transaction identifier. Must = MX Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
4 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
5 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
6 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
7 POC Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. Must exist in MONITOR table for non-Insert actions. Always
8 Pollutant Standard ID AQS Code for the specific NAAQS standard from which to exclude this monitor's data from design value calculations. Null means exclude from all standards. Integer. Must exist in POLLUTANT_PERIOD_STANDARDS Reference Table. No
9 Begin Date Beginning of date range where the monitor is the primary for the parameter at the site. YYYYMMDD. Always
10 End Date End of date range where the monitor the primary for the parameter at the site. YYYYMMDD. No
11 Comment Justification for NAAQS exclusion. Text, up to 2000 characters. Insert

RC - Raw Composite

Seq. Name Description Formatting Rules Required
1 Transaction Type Composite Raw Data transaction identifier. Must = RC Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
4 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
5 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
6 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
7 POC Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. Must exist in MONITOR table for non-Insert actions. Always
8 Reported Unit The unit of measure of the reported value. Must exist in UNITS reference table. Insert
9 Method Code Identifies a particular method for collecting and analyzing samples. Must exist in SAMPLING METHODOLOGIES reference table. Insert
10 Composite Year The calendar year for which the observation is reported. YYYY. Always
11 Composite Period Indicates the time period within the year to which the observation applies. Must exist in COMPOSITE TYPES reference table. Always
12 Number of Samples Indicates the number of samples that were combined to yield the composite sample value. Integer - 10 digit. Insert
13 Composite Type Indicates the time period over which samples are composited or the frequency of submitting composite samples. Must exist in COMPOSITE TYPES reference table. No
14 Reported Sample Value The value of a composite observation. Decimal. Insert
15 Monitor Protocol ID The ID used to distinguish combinations of sample duration, unit, method, collection frequency, composite type, and alternate method detectable limit (MDL) for a monitor. Must exist in MONITOR PROTOCOLS table for monitor. No
16 Qualifier Code - 1 Qualifications used to describe the composite raw data. Must exist in QUALIFIERS reference table. No
17 Qualifier Code - 2 Qualifications used to describe the composite raw data. Must exist in QUALIFIERS reference table. No
18 Qualifier Code - 3 Qualifications used to describe the composite raw data. Must exist in QUALIFIERS reference table. No
19 Qualifier Code - 4 Qualifications used to describe the composite raw data. Must exist in QUALIFIERS reference table. No
20 Qualifier Code - 5 Qualifications used to describe the composite raw data. Must exist in QUALIFIERS reference table. No
21 Qualifier Code - 6 Qualifications used to describe the composite raw data. Must exist in QUALIFIERS reference table. No
22 Qualifier Code - 7 Qualifications used to describe the composite raw data. Must exist in QUALIFIERS reference table. No
23 Qualifier Code - 8 Qualifications used to describe the composite raw data. Must exist in QUALIFIERS reference table. No
24 Qualifier Code - 9 Qualifications used to describe the composite raw data. Must exist in QUALIFIERS reference table. No
25 Qualifier Code - 10 Qualifications used to describe the composite raw data. Must exist in QUALIFIERS reference table. No
26 Alternate Method Detection Limit User supplied alternate to the federeal method detection limit (MDL). Decimal. No
27 Uncertaintly Value The value of method uncertainty associated with the sample. Decimal. No

RD - Raw Data

Seq. Name Description Formatting Rules Required
1 Transaction Type Raw Data Sample transaction identifier. Must = RD Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
4 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
5 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
6 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
7 POC Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. Must exist in MONITOR table for non-Insert actions. Always
8 Duration Code Represents the amount of time the monitor samples before reporting a measurement. Must exist in SAMPLE DURATIONS reference table. Insert
9 Reported Unit The unit of measure of the reported value. Must exist in UNITS reference table. Insert
10 Method Code Identifies a particular method for collecting and analyzing samples. Must exist in SAMPLING METHODOLOGIES reference table. Insert
11 Sample Date The calendar date for which the observation is being reported. YYYYMMDD. Always
12 Sample Begin Time The time at which the sampling for the reported observation began, in standard time at the location of the monitoring site. HH:MM. Always
13 Reported Sample Value The value of an observation being reported. Decimal. Sample value or null data code required
14 Null Data Code A code to explain why no sample value was reported. Must exist in QUALIFIERS reference table. Sample value or null data code required
15 Collection Frequency Code Indicates the elapsed time period between observations. Must exist in COLLECTION FREQUENCIES reference table. No
16 Monitor Protocol ID The ID used to distinguish combinations of sample duration, unit, method, collection frequency, composite type, and alternate method detectable limit (MDL) for a monitor. Must exist in MONITOR PROTOCOLS table for monitor. No
17 Qualifier Code - 1 Qualifications used to describe the raw data. Must exist in QUALIFIERS reference table. No
18 Qualifier Code - 2 Qualifications used to describe the raw data. Must exist in QUALIFIERS reference table. No
19 Qualifier Code - 3 Qualifications used to describe the raw data. Must exist in QUALIFIERS reference table. No
20 Qualifier Code - 4 Qualifications used to describe the raw data. Must exist in QUALIFIERS reference table. No
21 Qualifier Code - 5 Qualifications used to describe the raw data. Must exist in QUALIFIERS reference table. No
22 Qualifier Code - 6 Qualifications used to describe the raw data. Must exist in QUALIFIERS reference table. No
23 Qualifier Code - 7 Qualifications used to describe the raw data. Must exist in QUALIFIERS reference table. No
24 Qualifier Code - 8 Qualifications used to describe the raw data. Must exist in QUALIFIERS reference table. No
25 Qualifier Code - 9 Qualifications used to describe the raw data. Must exist in QUALIFIERS reference table. No
26 Qualifier Code - 10 Qualifications used to describe the raw data. Must exist in QUALIFIERS reference table. No
27 Alternate Method Detection Limit User supplied alternate to the federeal method detection limit (MDL). Decimal. No
28 Uncertaintly Value The value of method uncertainty associated with the sample. Decimal. No

RB - Raw Blanks

Seq. Name Description Formatting Rules Required
1 Transaction Type Blanks Data transaction identifier. Must = RB Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
4 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
5 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
6 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
7 POC Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. Must exist in MONITOR table for non-Insert actions. Always
8 Duration Code The period of time during which the blank sample value was collected. Must exist in SAMPLE DURATIONS reference table. Insert
9 Reported Unit The unit of measure of the reported value. Must exist in UNITS reference table. Insert
10 Method Code Identifies a particular method for collecting and analyzing samples. Must exist in SAMPLING METHODOLOGIES reference table. Insert
11 Blank Type Describes how the un-exposed filter was handled. Must = FIELD, TRIP, or LOT Always
12 Blank Date Date the blank was cycled into the sampler. YYYYMMDD. Always
13 Blank Time The begin time of blank cycling. HH:MM. Always
14 Blank Value The measured value of the parameter in the un-exposed filter. Decimal. Sample value or null data code required
15 Null Data Code This is a code to explain why no blank value was reported. Must exist in QUALIFIERS reference table. Sample value or null data code required
16 Qualifier Code - 1 Qualifications used to describe the blank data. Must exist in QUALIFIERS reference table. No
17 Qualifier Code - 2 Qualifications used to describe the blank data. Must exist in QUALIFIERS reference table. No
18 Qualifier Code - 3 Qualifications used to describe the blank data. Must exist in QUALIFIERS reference table. No
19 Qualifier Code - 4 Qualifications used to describe the blank data. Must exist in QUALIFIERS reference table. No
20 Qualifier Code - 5 Qualifications used to describe the blank data. Must exist in QUALIFIERS reference table. No
21 Qualifier Code - 6 Qualifications used to describe the blank data. Must exist in QUALIFIERS reference table. No
22 Qualifier Code - 7 Qualifications used to describe the blank data. Must exist in QUALIFIERS reference table. No
23 Qualifier Code - 8 Qualifications used to describe the blank data. Must exist in QUALIFIERS reference table. No
24 Qualifier Code - 9 Qualifications used to describe the blank data. Must exist in QUALIFIERS reference table. No
25 Qualifier Code - 10 Qualifications used to describe the blank data. Must exist in QUALIFIERS reference table. No
26 Alternate Method Detection Limit User supplied alternate to the federeal method detection limit (MDL). Decimal. No
27 Uncertaintly Value The value of method uncertainty associated with the sample. Decimal. No

QA - 1-Point QC

Seq. Name Description Formatting Rules Required
1 Transaction Type Quality Assurance transaction identifier. Must = QA Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 Assessment Type Indicates the specific QA assessment associated with the transaction. Must = 1-Point QC Always
4 Performing Agency Agency Code of organization performing assessment. Must exist in AGENCIES reference table. Optional; defaults to user agency
5 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
6 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
7 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
8 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
9 POC Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. Must exist in MONITOR table for non-Insert actions. Always
10 Assessment Date Date that the assessment was performed YYYYMMDD. Always
11 Assessment Number A unique number associated with an assessment performed at a site on a given day. Value should be "1" unless additional same assessments are performed. Integer. Always
12 Monitor Method Code The sampling methodology of the monitor being assessed. Must exist in SAMPLING METHODOLOGIES reference table. Insert
13 Reported Unit Units associated with the assessment concentrations (Monitor Concentration and Check Standard Concentration). Must exist in UNITS reference table, and unit code must be for Concentration units type. Unless Delete
14 Monitor Concentration The concentration value provided by the monitor being assessed. Decimal. Insert
15 Assessment Concentration The value of the known gas standard concentration. Decimal. Insert
16 Null Code Descriptive text similar to the null code on the RD transaction: e.g. A null code value is valid if it exists in the AQS list of qualifiers with the qualifier type of "NULL QC". Must be a valid Null Code. Optional
17 Comment Free form text describing the assesment or invalidation. Text, up to 2000 characters. Optional
18 Assessment Cylinder Producer New. Producer of cylinder used for 1-Point QC. The Assessment Cylinder Producer must be in the CYLINDER_PRODUCERS table in the database. Optional
19 Assessment Cylinder ID New. Cylinder ID of cylinder used for 1-Point QC. The combination of {Assessment_Cylinder_Producer, Assessment_Cylinder_ID} must exist in the CYLINDERS table in the database. Optional

QA - Annual PE

Seq. Name Description Formatting Rules Required
1 Transaction Type Quality Assurance transaction identifier. Must = QA Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 Assessment Type Indicates the specific QA assessment associated with the transaction. Must = Annual PE Always
4 Performing Agency Agency Code of organization performing assessment. Must exist in AGENCIES reference table. Optional; defaults to user agency
5 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
6 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
7 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
8 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
9 POC Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. Must exist in MONITOR table for non-Insert actions. Always
10 Assessment Date Date that the assessment was performed YYYYMMDD. Always
11 Assessment Number A unique number associated with an assessment performed at a site on a given day. Value should be "1" unless additional same assessments are performed. Integer. Always
12 Monitor Method Code The sampling methodology of the monitor being assessed. Must exist in SAMPLING METHODOLOGIES reference table. Insert
13 Reported Unit Units associated with the assessment concentrations (Monitor Concentration and Check Standard Concentration). Must exist in UNITS reference table, and unit code must be for Concentration units type. Unless Delete
14 Level 1 Monitor Concentration The concentration value provided by the monitor being assessed at level 1. Decimal. Insert
15 Level 1 Assessment Concentration The value of the known gas standard concentration in Audit Level 1. Decimal. Insert
16 Level 2 Monitor Concentration The concentration value provided by the monitor being assessed at level 2. Decimal. Insert
17 Level 2 Assessment Concentration The value of the known gas standard concentration in Audit Level 2. Decimal. Insert
18 Level 3 Monitor Concentration The concentration value provided by the monitor being assessed at level 3. Decimal. Insert
19 Level 3 Assessment Concentration The value of the known gas standard concentration in Audit Level 3. Decimal. Insert
20 Level 4 Monitor Concentration The concentration value provided by the monitor being assessed at level 4. Decimal. Insert
21 Level 4 Assessment Concentration The value of the known gas standard concentration in Audit Level 4. Decimal. Insert
22 Level 5 Monitor Concentration The concentration value provided by the monitor being assessed at level 5. Decimal. Insert
23 Level 5 Assessment Concentration The value of the known gas standard concentration in Audit Level 5. Decimal. Insert
24 Level 6 Monitor Concentration The concentration value provided by the monitor being assessed at level 6. Decimal. Insert
25 Level 6 Assessment Concentration The value of the known gas standard concentration in Audit Level 6. Decimal. Insert
26 Level 7 Monitor Concentration The concentration value provided by the monitor being assessed at level 7. Decimal. Insert
27 Level 7 Assessment Concentration The value of the known gas standard concentration in Audit Level 7. Decimal. Insert
28 Level 8 Monitor Concentration The concentration value provided by the monitor being assessed at level 8. Decimal. Insert
29 Level 8 Assessment Concentration The value of the known gas standard concentration in Audit Level 8. Decimal. Insert
30 Level 9 Monitor Concentration The concentration value provided by the monitor being assessed at level 9. Decimal. Insert
31 Level 9 Assessment Concentration The value of the known gas standard concentration in Audit Level 9. Decimal. Insert
32 Level 10 Monitor Concentration The concentration value provided by the monitor being assessed at level 10. Decimal. Insert
33 Level 10 Assessment Concentration The value of the known gas standard concentration in Audit Level 10. Decimal. Insert
34 Cylinder PGVP-ID New. Producer of cylinder used for QA Annual Performance Evaluations. The Cylinder PGVP-ID must be in the CYLINDERS table in the database. Corresponds to the PRODUCER_ID. Optional
35 Cylinder ID New. Cylinder ID of cylinder used for QA Annual Performance Evaluations The combination of {Assessment_Cylinder_Producer, Assessment_Cylinder_ID} must exist in the CYLINDERS table in the database. Optional

QA - Flow Rate Verification

Seq. Name Description Formatting Rules Required
1 Transaction Type Quality Assurance transaction identifier. Must = QA Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 Assessment Type Indicates the specific QA assessment associated with the transaction. Must = Flow Rate Verification Always
4 Performing Agency Agency Code of organization performing assessment. Must exist in AGENCIES reference table. Optional; defaults to user agency
5 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
6 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
7 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
8 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
9 POC Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. Must exist in MONITOR table for non-Insert actions. Always
10 Assessment Date Date that the assessment was performed YYYYMMDD. Always
11 Assessment Number A unique number associated with an assessment performed at a site on a given day. Value should be "1" unless additional same assessments are performed. Integer. Always
12 Monitor Method Code The sampling methodology of the monitor being assessed. Must exist in SAMPLING METHODOLOGIES reference table. Insert
13 Reported Unit Units associated with the assessment. Must exist in UNITS reference table, and unit code must be for Flow units type. Unless Delete
14 Monitor Flow Rate The measured flow rate provided by the monitor being assessed. Decimal. Insert
15 Assessment Flow Rate The flow rate of the flow transfer standard. Decimal. Insert

QA - Semi Annual Flow Rate Audit

Seq. Name Description Formatting Rules Required
1 Transaction Type Quality Assurance transaction identifier. Must = QA Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 Assessment Type Indicates the specific QA assessment associated with the transaction. Must = Semi-Annual Flow Rate Audit Always
4 Performing Agency Agency Code of organization performing assessment. Must exist in AGENCIES reference table. Optional; defaults to user agency
5 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
6 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
7 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
8 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
9 POC Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. Must exist in MONITOR table for non-Insert actions. Always
10 Assessment Date Date that the assessment was performed YYYYMMDD. Always
11 Assessment Number A unique number associated with an assessment performed at a site on a given day. Value should be "1" unless additional same assessments are performed. Integer. Always
12 Monitor Method Code The sampling methodology of the monitor being assessed. Must exist in SAMPLING METHODOLOGIES reference table. Insert
13 Reported Unit Units associated with the assessment. Must exist in UNITS reference table, and unit code must be for Flow units type. Unless Delete
14 Monitor Flow Rate The measured flow rate provided by the monitor being assessed. Decimal. Insert
15 Assessment Flow Rate The flow rate of the flow transfer standard. Decimal. Insert

QA - Flow Rate Verification for PMc

Seq. Name Description Formatting Rules Required
1 Transaction Type Quality Assurance transaction identifier. Must = QA Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 Assessment Type Indicates the specific QA assessment associated with the transaction. Must = PMc Flow Rate V Always
4 Performing Agency Agency Code of organization performing assessment. Must exist in AGENCIES reference table. Optional; defaults to user agency
5 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
6 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
7 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
8 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
9 POC Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. Must exist in MONITOR table for non-Insert actions. Always
10 Assessment Date Date that the assessment was performed YYYYMMDD. Always
11 Assessment Number A unique number associated with an assessment performed at a site on a given day. Value should be "1" unless additional same assessments are performed. Integer. Always
12 PM10 Monitor Method Code The sampling methodology of the PM10 monitor being assessed. Must exist in SAMPLING METHODOLOGIES reference table. Insert
13 Reported Unit Units associated with the assessment. Must exist in UNITS reference table, and unit code must be for Flow units type. Unless Delete
14 PM10 Monitor Flow Rate The measured flow rate provided by the monitor being assessed. Decimal. Insert
15 PM10 Assessment Flow Rate The flow rate of the flow transfer standard. Decimal. Insert
16 PM 2.5 Monitor Method Code The sampling methodology of the PM 2.5 monitor being assessed. Must exist in SAMPLING METHODOLOGIES reference table. Insert
17 PM 2.5 Monitor Flow Rate The measured flow rate provided by the monitor being assessed. Decimal. Insert
18 PM 2.5 Assessment Flow Rate The flow rate of the flow transfer standard. Decimal. Insert

QA - Semi Annual Flow Rate Audit for PMc

Seq. Name Description Formatting Rules Required
1 Transaction Type Quality Assurance transaction identifier. Must = QA Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 Assessment Type Indicates the specific QA assessment associated with the transaction. Must = PMc Semi Annual Flow Rate Audit Always
4 Performing Agency Agency Code of organization performing assessment. Must exist in AGENCIES reference table. Optional; defaults to user agency
5 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
6 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
7 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
8 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
9 POC Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. Must exist in MONITOR table for non-Insert actions. Always
10 Assessment Date Date that the assessment was performed YYYYMMDD. Always
11 Assessment Number A unique number associated with an assessment performed at a site on a given day. Value should be "1" unless additional same assessments are performed. Integer. Always
12 PM10 Monitor Method Code The sampling methodology of the PM10 monitor being assessed. Must exist in SAMPLING METHODOLOGIES reference table. Insert
13 Reported Unit Units associated with the assessment. Must exist in UNITS reference table, and unit code must be for Flow units type. Unless Delete
14 PM10 Monitor Flow Rate The measured flow rate provided by the monitor being assessed. Decimal. Insert
15 PM10 Assessment Flow Rate The flow rate of the flow transfer standard. Decimal. Insert
16 PM 2.5 Monitor Method Code The sampling methodology of the PM 2.5 monitor being assessed. Must exist in SAMPLING METHODOLOGIES reference table. Insert
17 PM 2.5 Monitor Flow Rate The measured flow rate provided by the monitor being assessed. Decimal. Insert
18 PM 2.5 Assessment Flow Rate The flow rate of the flow transfer standard. Decimal. Insert

QA - Performance Evaluation Program

Seq. Name Description Formatting Rules Required
1 Transaction Type Quality Assurance transaction identifier. Must = QA Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 Assessment Type Indicates the specific QA assessment associated with the transaction. Must = PEP Always
4 Performing Agency Agency Code of organization performing assessment. Must exist in AGENCIES reference table. Optional; defaults to user agency
5 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
6 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
7 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
8 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
9 POC Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. Must exist in MONITOR table for non-Insert actions. Always
10 Assessment Date Date that the assessment was performed YYYYMMDD. Always
11 Assessment Number A unique number associated with an assessment performed at a site on a given day. Value should be "1" unless additional same assessments are performed. Integer. Always
12 PEP Type Indicates where the PEP monitor is operated by the Audit Agency or by the Monitoring Agency. Must = INDEPENDENT or COLLOCATED Insert
13 Monitor Method Code The sampling methodology of the monitor being assessed. Must exist in SAMPLING METHODOLOGIES reference table. Insert
14 Reported Unit Units associated with the assessment concentration. Must exist in UNITS reference table, and unit code must be for Concentration units type. Unless Delete
15 Assessment Concentration The value reported by the PEP monitor for the Date-Time. Decimal. Insert

QA - National Performance Audit Program

Seq. Name Description Formatting Rules Required
1 Transaction Type Quality Assurance transaction identifier. Must = QA Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 Assessment Type Indicates the specific QA assessment associated with the transaction. Must = NPAP Always
4 Performing Agency Agency Code of organization performing assessment. Must exist in AGENCIES reference table. Optional; defaults to user agency
5 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
6 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
7 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
8 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
9 POC Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. Must exist in MONITOR table for non-Insert actions. Always
10 Assessment Date Date that the assessment was performed YYYYMMDD. Always
11 Assessment Number A unique number associated with an assessment performed at a site on a given day. Value should be "1" unless additional same assessments are performed. Integer. Always
12 NPAP Type Indicates where the PEP monitor is operated by the Audit Agency or by the Monitoring Agency. Must = TTP or BOA Insert
13 Monitor Method Code The sampling methodology of the monitor being assessed. Must exist in SAMPLING METHODOLOGIES reference table. Insert
14 Assessment Method Code For parameters other than Ozone, this is the method code of the CO monitor used to determine check gas dilution. Must exist in SAMPLING METHODOLOGIES reference table. Insert unless ozone
15 Reported Unit Units associated with the assessment concentrations (Monitor Concentration and Check Standard Concentration). Must exist in UNITS reference table, and unit code must be for Concentration units type. Unless Delete
16 Level 1 Monitor Concentration The concentration value provided by the monitor being assessed at level 1. Decimal. Insert
17 Level 1 Assessment Concentration The value of the known gas standard concentration in Audit Level 1. Decimal. Insert
18 Level 2 Monitor Concentration The concentration value provided by the monitor being assessed at level 2. Decimal. Insert
19 Level 2 Assessment Concentration The value of the known gas standard concentration in Audit Level 2. Decimal. Insert
20 Level 3 Monitor Concentration The concentration value provided by the monitor being assessed at level 3. Decimal. Insert
21 Level 3 Assessment Concentration The value of the known gas standard concentration in Audit Level 3. Decimal. Insert
22 Level 4 Monitor Concentration The concentration value provided by the monitor being assessed at level 4. Decimal. Insert
23 Level 4 Assessment Concentration The value of the known gas standard concentration in Audit Level 4. Decimal. Insert
24 Level 5 Monitor Concentration The concentration value provided by the monitor being assessed at level 5. Decimal. Insert
25 Level 5 Assessment Concentration The value of the known gas standard concentration in Audit Level 5. Decimal. Insert
26 Level 6 Monitor Concentration The concentration value provided by the monitor being assessed at level 6. Decimal. Insert
27 Level 6 Assessment Concentration The value of the known gas standard concentration in Audit Level 6. Decimal. Insert
28 Level 7 Monitor Concentration The concentration value provided by the monitor being assessed at level 7. Decimal. Insert
29 Level 7 Assessment Concentration The value of the known gas standard concentration in Audit Level 7. Decimal. Insert
30 Level 8 Monitor Concentration The concentration value provided by the monitor being assessed at level 8. Decimal. Insert
31 Level 8 Assessment Concentration The value of the known gas standard concentration in Audit Level 8. Decimal. Insert
32 Level 9 Monitor Concentration The concentration value provided by the monitor being assessed at level 9. Decimal. Insert
33 Level 9 Assessment Concentration The value of the known gas standard concentration in Audit Level 9. Decimal. Insert
34 Level 10 Monitor Concentration The concentration value provided by the monitor being assessed at level 10. Decimal. Insert
35 Level 10 Assessment Concentration The value of the known gas standard concentration in Audit Level 10. Decimal. Insert

QA - Field Proficiency Test

Seq. Name Description Formatting Rules Required
1 Transaction Type Quality Assurance transaction identifier. Must = QA Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 Assessment Type Indicates the specific QA assessment associated with the transaction. Must = Field Proficiency Test Always
4 Performing Agency Agency Code of organization performing assessment. Must exist in AGENCIES reference table. Optional; defaults to user agency
5 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
6 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
7 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
8 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
9 POC Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. Must exist in MONITOR table for non-Insert actions. Always
10 Assessment Date Date that the assessment was performed YYYYMMDD. Always
11 Assessment Number A unique number associated with an assessment performed at a site on a given day. Value should be "1" unless additional same assessments are performed. Integer. Always
12 Monitor Method Code The sampling methodology of the monitor being assessed. Must exist in SAMPLING METHODOLOGIES reference table. Insert
13 Reported Unit Units associated with the assessment. Must exist in UNITS reference table, and unit code must be for Concentration units type. Unless Delete
14 Monitor Concentration The concentration value provided by the monitor being assessed. Decimal. Insert
15 Assessment Concentration The known value of the analyte concentration. Decimal. Insert

QA - Duplicate

Seq. Name Description Formatting Rules Required
1 Transaction Type Quality Assurance transaction identifier. Must = QA Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 Assessment Type Indicates the specific QA assessment associated with the transaction. Must = Duplicate Always
4 Performing Agency Agency Code of organization performing assessment. Must exist in AGENCIES reference table. Optional; defaults to user agency
5 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
6 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
7 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
8 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
9 POC Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. Must exist in MONITOR table for non-Insert actions. Always
10 Assessment Date Date that the assessment was performed YYYYMMDD. Always
11 Assessment Number A unique number associated with an assessment performed at a site on a given day. Value should be "1" unless additional same assessments are performed. Integer. Always
12 Monitor Method Code The sampling methodology of the monitor being assessed. Must exist in SAMPLING METHODOLOGIES reference table. Insert
13 Reported Unit Units associated with the assessment. Must exist in UNITS reference table, and unit code must be for Concentration units type. Unless Delete
14 Duplicate Value 1 The concentration value provided by the monitor being assessed. Decimal. Insert
15 Duplicate Value 2 The concentration value provided by the monitor being assessed. Decimal. Insert
16 Duplicate Value 3 The concentration value provided by the monitor being assessed. Decimal. Insert
17 Duplicate Value 4 The concentration value provided by the monitor being assessed. Decimal. Insert
18 Duplicate Value 5 The concentration value provided by the monitor being assessed. Decimal. Insert

QA - Replicate

Seq. Name Description Formatting Rules Required
1 Transaction Type Quality Assurance transaction identifier. Must = QA Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 Assessment Type Indicates the specific QA assessment associated with the transaction. Must = Replicate Always
4 Performing Agency Agency Code of organization performing assessment. Must exist in AGENCIES reference table. Optional; defaults to user agency
5 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
6 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
7 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
8 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
9 POC Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. Must exist in MONITOR table for non-Insert actions. Always
10 Assessment Date Date that the assessment was performed YYYYMMDD. Always
11 Assessment Number A unique number associated with an assessment performed at a site on a given day. Value should be "1" unless additional same assessments are performed. Integer. Always
12 Monitor Method Code The sampling methodology of the monitor being assessed. Must exist in SAMPLING METHODOLOGIES reference table. Insert
13 Reported Unit Units associated with the assessment. Must exist in UNITS reference table, and unit code must be for Concentration units type. Unless Delete
14 Replicate Value 1 The concentration value provided by the monitor being assessed. Decimal. Insert
15 Replicate Value 2 The concentration value provided by the monitor being assessed. Decimal. Insert
16 Replicate Value 3 The concentration value provided by the monitor being assessed. Decimal. Insert
17 Replicate Value 4 The concentration value provided by the monitor being assessed. Decimal. Insert
18 Replicate Value 5 The concentration value provided by the monitor being assessed. Decimal. Insert

QA - Pb Analysis Audit

Seq. Name Description Formatting Rules Required
1 Transaction Type Quality Assurance transaction identifier. Must = QA Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 Assessment Type Indicates the specific QA assessment associated with the transaction. Must = Pb Analysis Audit Always
4 Performing Agency Agency Code of organization performing assessment. Must exist in AGENCIES reference table. Always
5 Primary Quality Assurance Organization Agency Code of organization responsible for the quality of data for Monitoring Organization. Must exist in AGENCIES Reference Table. Always
6 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
7 Assessment Date Date that the assessment was performed YYYYMMDD. Always
8 Assessment Number A unique number associated with an assessment performed at a site on a given day. Value should be "1" unless additional same assessments are performed. Integer. Always
9 Reported Unit Units for mass of lead on test strip. Required by Part 58.3.3.4.(c) to be unit code 077 (micrograms). Must = 077 Unless Delete
10 Laboratory Response Value 1 The mass of lead reported by lab for level 1. Decimal. Insert
11 Assessment Mass 1 The known mass of lead on the test strip for level 1. Decimal (must be in range of mass values for audit level 1 in AUDIT LEVELS table in database). Insert
12 Laboratory Response Value 2 The mass of lead reported by lab for level 2. Decimal. Insert
13 Assessment Mass 2 The known mass of lead on the test strip for level 2. Decimal (must be in range of mass values for audit level 1 in AUDIT LEVELS table in database). Insert

QA - Lab Proficiency Test

Seq. Name Description Formatting Rules Required
1 Transaction Type Quality Assurance transaction identifier. Must = QA Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 Assessment Type Indicates the specific QA assessment associated with the transaction. Must = Lab Proficiency Test Always
4 Performing Agency Agency Code of organization performing assessment. Must exist in AGENCIES reference table. Always
5 Primary Quality Assurance Organization Agency Code of organization responsible for the quality of data for Monitoring Organization. Must exist in AGENCIES Reference Table. Always
6 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
7 Assessment Date Date that the assessment was performed YYYYMMDD. Always
8 Assessment Number A unique number associated with an assessment performed at a site on a given day. Value should be "1" unless additional same assessments are performed. Integer. Always
9 Reported Unit Units of measure of analyte by Lab. Must exist in UNITS reference table. Unless Delete
10 Laboratory Response Value 1 The mass of analyte reported by Lab. Decimal. Insert
11 Assessment Mass 1 The known mass of analyte on the test media. Decimal. Insert

QA - Ambient Air Protocol Gas Verification Program

Seq. Name Description Formatting Rules Required
1 Transaction Type Quality Assurance transaction identifier. Must = QA Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 Assessment Type Indicates the specific QA assessment associated with the transaction. Must = AA-PGVP Always
4 Performing Agency Agency Code of organization performing assessment. Must exist in AGENCIES reference table. Always
5 Producer ID Unique identifier of organization that produced cylinder being assessed. Must exist in AAPGVP PRODUCERS reference table. Always
6 Cylinder ID Unique identifier (e.g. serial number) of gas cylinder being assessed. Text (up to 40 characters). Always
7 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
8 Assessment Date Date that the assessment was performed YYYYMMDD. Always
9 Assessment Number A unique number associated with an assessment performed at a site on a given day. Value should be "1" unless additional same assessments are performed. Integer. Always
10 Reported Unit Units of measure of analyte by Lab. Must exist in UNITS reference table. Unless Delete
11 Cylinder certified concentration Gas concentration specified by cylinder producer. Decimal, positive. Insert
12 Assessment Concentration Measured concentration of gas in cylinder. Decimal, positive. Insert

QA - Ozone SRP and Ozone Transfer Standard Verification

Seq. Name Description Formatting Rules Required
1 Transaction Type Quality Assurance transaction identifier. Must = QA Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 Assessment Type Indicates the specific QA assessment associated with the transaction. Must = SRP Always
4 Verification Type 6X6 is for the initial verification of a new standard ozone generator. "Standard" is for a routine SRP assessment. Must = 6X6 or Standard Always
5 Performing Agency Agency Code of organization performing assessment. Must exist in AGENCIES reference table. Always
6 Primary Quality Assurance Organization Agency Code of organization responsible for the quality of data for Monitoring Organization. Must exist in AGENCIES Reference Table. Always
7 Parameter The AQS parameter code. Must = 44201 Always
8 Authoritative standard ID Unique ID for Authoritative standard. Must exist on SRP STANDARDS reference table. Always
9 Authoritative Standard Level Primary EPA standard is Level 1, those validated against it are level 2, and those validated against level 2 standards are level 3. Number; must be 1, 2, or 3. Always
10 Transfer standard ID Unique ID code (serial number) for transfer standard Text (up to 40 characters). Always
11 Transfer Standard Level Level 1, 2, 3, 4 transfer standard has to be equal or a higher number then the Authoritative Standard Decimal; must be >= authoritative standard. Always
12 Assessment Date Date that the assessment was performed. YYYYMMDD. Always
13 Assessment Number A unique number associated with an assessment performed at a site on a given day. Value should be "1" unless additional assessments are performed. Integer. Always
14 Reported Unit Units associated with the assessment concentrations (Monitor Concentration and Check Standard Concentration). Must exist in UNITS reference table, and unit code must be for Concentration units type. Unless Delete
15 Transfer Standard Value 1 Measurement from instrument being assessed. Decimal. Insert
16 Authoritative Standard Value1 Measurement from authoritative standard instrument. Decimal. Insert
17 Transfer Standard Value 2 Measurement from instrument being assessed. Decimal. Insert
18 Authoritative Standard Value2 Measurement from authoritative standard instrument. Decimal. Insert
19 Transfer Standard Value 3 Measurement from instrument being assessed. Decimal. Insert
20 Authoritative Standard Value3 Measurement from authoritative standard instrument. Decimal. Insert
21 Transfer Standard Value 4 Measurement from instrument being assessed. Decimal. Insert
22 Authoritative Standard Value4 Measurement from authoritative standard instrument. Decimal. Insert
23 Transfer Standard Value 5 Measurement from instrument being assessed. Decimal. Insert
24 Authoritative Standard Value5 Measurement from authoritative standard instrument. Decimal. Insert
25 Transfer Standard Value 6 Measurement from instrument being assessed. Decimal. Insert
26 Authoritative Standard Value6 Measurement from authoritative standard instrument. Decimal. Insert
27 Transfer Standard Value 7 Measurement from instrument being assessed. Decimal. Insert
28 Authoritative Standard Value7 Measurement from authoritative standard instrument. Decimal. Insert
29 Transfer Standard Value 8 Measurement from instrument being assessed. Decimal. Insert
30 Authoritative Standard Value8 Measurement from authoritative standard instrument. Decimal. Insert
31 Transfer Standard Value 9 Measurement from instrument being assessed. Decimal. Insert
32 Authoritative Standard Value9 Measurement from authoritative standard instrument. Decimal. Insert
33 Transfer Standard Value 10 Measurement from instrument being assessed. Decimal. Insert
34 Authoritative Standard Value10 Measurement from authoritative standard instrument. Decimal. Insert

QA - Speciation Flow Rate Verification

Seq. Name Description Formatting Rules Required
1 Transaction Type Quality Assurance transaction identifier. Must = QA Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 Assessment Type Indicates the specific QA assessment associated with the transaction. Must = Speciation Flow Rate V Always
4 Performing Agency Agency Code of organization performing assessment. Must exist in AGENCIES reference table. Optional; defaults to user agency
5 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
6 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
7 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
8 Sampler ID The unique name or ID for the sampler at the site. Must exist for Site in database. Always
9 Channel Number Number assigned to channel on sampler Must be defined for Sampler in database. Always
10 Assessment Date Date that the assessment was performed YYYYMMDD. Always
11 Assessment Number A unique number associated with an assessment performed at a site on a given day. Value should be "1" unless additional same assessments are performed. Integer. Always
12 Reported Unit Units associated with the flow values. Must exist in UNITS reference table, and unit code must be for Flow units type. Unless Delete
13 Sampler Flow Rate The measured flow rate provided by the sampler being assessed. Decimal. Insert
14 Assessment Flow Rate The flow rate of the flow transfer standard. Decimal. Insert

QA - Speciation Semi-Annual Flow Rate Audit

Seq. Name Description Formatting Rules Required
1 Transaction Type Quality Assurance transaction identifier. Must = QA Always
2 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 Assessment Type Indicates the specific QA assessment associated with the transaction. Must = Speciation Flow Rate Audit Always
4 Performing Agency Agency Code of organization performing assessment. Must exist in AGENCIES reference table. Optional; defaults to user agency
5 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
6 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
7 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
8 Sampler ID The unique name or ID for the sampler at the site. Must exist for Site in database. Always
9 Channel Number Number assigned to channel on sampler Must be defined for Sampler in database. Always
10 Assessment Date Date that the assessment was performed YYYYMMDD. Always
11 Assessment Number A unique number associated with an assessment performed at a site on a given day. Value should be "1" unless additional same assessments are performed. Integer. Always
12 Reported Unit Units associated with the flow values. Must exist in UNITS reference table, and unit code must be for Flow units type. Unless Delete
13 Sampler Flow Rate The measured flow rate provided by the sampler being assessed. Decimal. Insert
14 Assessment Flow Rate The flow rate of the flow transfer standard. Decimal. Insert

QA - Zero Span

Seq. Name Description Formatting Rules Required
1 Transaction Type Quality Assurance transaction identifier. Must = QA Always
1 Action Indicator Indicator for Insert, Update, or Delete action. Must = I, U, or D Always
3 Assessment Type Indicates the specific QA assessment associated with the transaction. Must = Zero Span Always
4 Performing Agency Agency Code of organization performing assessment. Must exist in AGENCIES reference table. Optional; defaults to user agency
5 State Code / Tribal Indicator The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. Must exist in STATES Reference Table or be 'TT' for Tribal Site Always
6 County Code / Tribal Code The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table Always
7 Site Number Four digit number to uniquely identify site in county and/or tribe. Must exist in SITES table with {State Code, county Code} or Tribal Code Always
8 Parameter The AQS parameter code assigned to the monitor in AQS. Must exist in PARAMETERS reference table. Always
9 POC Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. Must exist in MONITOR table for non-Insert actions. Always
10 Assessment Date Date that the assessment was performed YYYYMMDD. Always
11 Assessment Number A unique number associated with an assessment performed at a site on a given day. Value should be "1" unless additional same assessments are performed. Integer. Always
12 Monitor Method Code The sampling methodology of the monitor being assessed. Must exist in SAMPLING METHODOLOGIES reference table. Insert
13 Reported Unit Units associated with the assessment concentrations (Monitor Concentration and Check Standard Concentration). Must exist in UNITS reference table, and unit code must be for Concentration units type. Unless Delete
14 Monitor Zero Value The concentration value provided by the monitor being assessed when exposed to zero concentration. Decimal. Unless Delete
15 Assessment Span Value The known concentration of the calibration gas at the target span of the monitor. Decimal. Unless Delete
16 Monitor Span Value The concentration value provided by the monitor being assessed when exposed to the span concentration. Decimal. Unless Delete
17 Null Code A code to explain why no monitor value was reported. Must exist in QUALIFIERS reference table. Monitor values or null data code required
18 Comment Free form text describing the assesment or invalidation. Text, up to 2000 characters. Optional