AQS (Air Quality System)
User Guide
2018
Issue 2
-------
This User Guide is designed to familiarize the user with:
• The look and feel of AQS
• Running AQS
• Batch Loading data
• Creating and modifying site and monitor descriptive information
• Generating output information encompassing user data
Note] screen images may vary depending on the user's operating system and browser.
Contents
AQS at a Glance 8
Screen Layout 8
Icons 9
Menu Bar, Form Area, and Tabs 10
Status Bar 10
Lists of Values (LOV) 11
Exchange Network Service Center (ENSC) at a Glance 14
Screen Layout 14
Logging On 15
Logon Screen 15
Session Screen 16
User Profile 17
Password 18
Tribal User 19
Maintain Security 19
Maintain Security Reference Tables 20
Site ID Format 20
State Code 20
County Code 21
Tribal Code 21
Site Number 21
Batch Submission of Data 22
Batch Data Submission Overview 22
2
-------
Formats 22
Data Compatible with Batch 22
Batch Data Submissions Flowchart 23
Using the ENSC 24
Job Status 31
ENSC Subsequent Uses 31
Loading Files Using AQS 32
Batch Form Overview 33
Process by File Tab 34
Stage 38
Load 39
Load Summary and Errors Report 39
Statistical and Critical Review report 40
Load Errors 40
Raw Data 41
Post 41
Raw Data Inventory report 41
When Things Go Wrong 42
Type of Data in AQS 43
Site Data 43
Required Group 44
Monitor Data 44
Ambient Air Quality Data 44
Quality Assurance Data 45
Summary Data 45
Transaction Formats 45
Data Codes 45
Production Level Data 46
Browse 46
Annual Summary 46
Correct 48
Correct Overview 48
Rows Errors 50
3
-------
Correct Monitor Agency Roles 50
Correct Monitor Collocations 50
Correct Monitor Objectives 50
Correct Monitor Regulation Compliances 51
Correct Monitor Tangent Roads 51
Correct Monitor Types 51
Correct Monitor 51
Correct Probe Obstructions 52
Correct Sample Periods 52
Correct Sample Schedules 52
Correct Site 53
Correct Open Paths 53
Correct Site Tangent Road 53
Correct Raw Data 54
Open Correct Raw Data Form 54
Query Data 56
Edit Data 58
Search and Replace 59
Save the Data 60
Other Correct Features 60
Correct One-Point QC 62
Correct Composite Data 63
Correct Highlights 64
Submitting Corrected Data 64
On-Line Data Tools - Maintain 65
Maintain Overview 65
Maintain Site 67
Maintain Monitor 68
Entering New Monitor Data 69
Agency Roles 69
Maintain Event 70
Maintain Raw Data 71
4
-------
Maintain Precision 72
Maintain Accuracy 73
Maintain Comments 73
Maintain Site 75
How to use Maintain 75
Enter Site Basic Info 76
Status Indicators 78
Enter an Agency Role 79
Create a Monitor 80
Maintain Blanks 83
Add Site Samplers 84
Tangent Roads 85
Open Paths 86
Adding Events via Maintain 86
Maintain Event 86
Exceptional Event Rule 86
Event Process Workflow 87
Flag Values with Event Qualifiers 88
EDT ID 88
Event Qualifiers 88
Flagging Values via Batch Data 89
Flagging Values via Maintain 90
Defining an Exceptional Event 93
Using Maintain Event to Define and Associate Events 93
Associate Raw Data with Event 95
Query by Date 98
Add concurrence flag 99
Regional Administrator 99
Regional Office 99
Setting up and mapping monitors to samplers and sampler channels 104
Delete Obsolete Records 114
Data Reports 115
5
-------
List of Standard Reports 115
Generating Reports 117
Standard Reports Overview 117
Standard Reports Form 117
Criteria Set Tab 117
Data Selection Tab 120
Sort Order Tab 121
Report Options Tab 121
Retrieve Reports Tab 121
Running a Report 122
Report Submitted for Batch Processing 122
Report Status 122
Report Contents 122
California Dump Bucket 122
Form Security 123
Form Operation 123
Output 123
Logging Off 123
Learn more, service, and support 124
Appendix A 125
Quick Reference Guide 125
Tips 125
Changing Passwords 125
Browse Data 125
Changing Raw Data Values 125
Deleting Raw Data Records 125
Changing Site/Monitor Data 126
Using Correct to Change Records in the Staging Tables 126
Uploading Data Using Batch 126
Creating Reports 126
Inputting Raw Values Using Maintain 127
Insert a New Site/Monitor Using Maintain 127
6
-------
7
-------
AQS at a Glance
Screen Layout
This portion of the guide describes the parts of the AQS application screen.
Hi
qa
s -E3-
Action Help Session Admin Retrieval Maintenance Critical Rev CErtification Batch Correct Main Menu
jL li _ck L ¦ 1 _ T_ _i _ It _ *_ ill j
Administration-Application Security (Tennessee) -In x
I I
User Profile
Maintain Security Security Reference Tables Maintain Roles User History
O
c
(W
First Hame MICHAEL
Phone
27711
Zip Code
County Code 063
Initial s
Street Address 1
City |Research Triangle Park
109 TW Alexander
AQS User ID MSBROOKS
EH User ID BROOKS.MICHAELS
I
Fax
User Type
Status Ind
EMail
"J
Last
Street Address 2
State Code
Agency Code
AQS Contact
EPA Region Code
Tribal User
| BROOKS. MICH AELS@EP£
Delete Error Tran;
OS
J
J
AQS New Password:
Change Your Oracle Passwords
Confirm password
Enterthe user's Last Name.
Record: 1/1
OK
1. AQS Title Bar
2. Menu Bar
3. Icons
4. Form Title Bar
5. Tabs
6. Form Area
7. Status Bar
8. Required Field
a. Required fields are indicated by the holding of the field name throughout AQS.
Note] the user should be able to see the entire screen with the exception of some of the longer records that require
scrolling to view. If some of the screen seems to be missing (and there's no scroll bar), the user should verify the
resolution; 1280x1024 is the recommended minimum resolution.
8
-------
Icons
Here is a listing of all Icons and their associated function.
H
Copy
Paste
Enter Query
0
¦
£
E
m
m
&
Save
Print Screen
Exit
Edit
Cut
Copy
Paste
Enter Query
Execute Query
Cancel Query
Calendar
Previous Block
First Record
Previous Record
Next Record
Last Record
Next Block
Insert Record / Row
Remove Record / Row
Duplicate Record
Clear Record
Rollback Record
Search and Replace
Help
Note] hovering the mouse pointer over an icon will display its name.
9
-------
Menu Bar, Form Area, and Tabs
Every menu item in the Menu Bar corresponds to a form within the Form Area. There may be
multiple Tabs within a form. Tabs are used to display additional information related to the
selected menu item.
The screen capture below shows that the Admin menu item was selected from the Menu Bar
and the Security menu items was selected form the drop down menu opening up the Security
form in the Form Area and the User Profile tab is highlighted allowing the user to interface with
the User Profile portion of the Security form.
LibjAQS
Action Help Session
H Si IS- ^ ^ Security
[^Administration - Appli Reference
Retrieval Maintenance Critical Rev CErtification Batch Correct Main Menu
User Profile
First Hame mich^
Phone 919 5.
, User Statistics
Appl Audits
Export Ca Dump Bucket
Zip Code 127711.
County Code jo63
Approved Regional Methods
Mantain Monitoring Season
ii J i ~ * ~~ i X
¦a & I ^ I ?
snce Tables Maintain Roles User History
Last |bR00KS
TW Alexander
AOS User ID MSBROOKS
EH User ID |BROOKS.MICHAELS
Fax f
search Triangle Part
User Type (h*
Status Ind [p
EMail ] B ROOKS. MICH AELS@EP,a Tribal User F
Delete Error Transaction
Street Address 2 |
State Code IF
Agency Code pfTo
AOS Contact
EPA Region Code
Pj
J
- ~ x
Change Your Oracle Passwords
AQS New Password:
Confirm password:
OK
Note] Tabs will be located at either the top or right side of the Form Area.
Status Bar
Enter a query; press F8 to execute, Ctrl-i-Q to cancel.
Record: 1/1 Enter-Qu...
-------
Lists of Values (LOV)
Whenever the user is required to populate data in AQS and the field contents must be one of a
specific list of values, AQS presents an LOV (List of Values) icon. The LOV icon is a grey square
with a downward pointing triangle in it.
Uaqs
Action Help
Session Admin Retrieval Maintenance Critical Rev Certification Batch correct Main Menu
HI I. illil ft ft % 1 I « T 4 ~ * ~~ | ± xii ^>111?
^2 Maintain - Monitors (Tennessee)
Project Class
Meas Scale
Probe Location
Probe Vert Dist
Samp Res Time
Close Date
County
Parameter
Site Id
Dominant Source
Open Path Num
Probe Height
Surrogate Ind
Last Samp Date
:oring Agency (Owner)
ri
Status Ind
Probe Hor Dist |
Unrest Air Flow rj
Last Post Date |
LOV (List of Values) Icon
Monitor Basic
Sample Periods
Type Assign.
Network Affiliations
Agency Roles
Objectives
Req Frequencies
OA Collocation
When the LOV icon is clicked the list of valid values is presented. State Code LOV Icon was
selected opening up the Valid Values pop-up window.
Ifd AQS
Action Help Session Admin Retrieval Maintenance Critical Rev CErtification Batch correct Main Menu
H a I JL I a mi % a m 4 ~ * ~~ ± x -a i ^ ^
) Maintain - Monitors (Tennessee) {Valid values for State Code} _*!
Project Class
Meas Scale
Probe Location
Probe Vert Dist
Samp Res Time
Close Date
Statf
Cod< Finq%
State Code
State Name
State A.
01
Alabama
AL
02
Alaska
AK
04
Arizona
AZ
05
Arkansas
AR
06
California
CA
08
Colorado
CO
09
Connecticut
CT
10
Delaware
DE
11
District Of Columbia
DC
12
Florida
FL
13
Georgia
GA
-------
The Valid Values pop-up window allows the user to manually scroll (1) through the list or use the
Find function (2) to narrow down the selection.
Valid values for State Code
«>Valid vali
® r
Find %
State
Code State Name
State A
¦A.
01
Alabama
AL
02
Alaska
AK
04
Arizona
AZ
05
Arkansas
AR
06
California
CA
08
Colorado
CO
09
Connecticut
CT
10
Delaware
DE
11
District Of Columbia
DC
12
Florida
FL
13
Georgia
OA
-------
Valid valu
State Code
Find %h
*J
State Code
State Name
State A±J
15
Hawaii
HI
16
Idaho
ID
25
Massachusetts
MA
26
Michigan
Ml
33
New Hampshire
NH
37
North Carolina
NC
38
North Dakota
ND
39
Ohio
OH
40
Oklahoma
OK
44
Rhode Island
Rl
45
South Carolina
so h
-------
Exchange Network Service Center (ENSC) at a Glance
All files must be submitted to AQS through the National Environmental Information Exchange
Network (the "Exchange Network"). Typically, they are submitted through a common interface,
the Exchange Network Service Center (ENSC).
Note] the ENSC is provided by the Exchange Network Governing Board to allow files to be submitted to EPA national
regulatory programs. Because it is not part of AQS it has a different look and feel that is described below.
Screen Layout
The first step in any interactive batch data submission to AQS takes place at the ENSC.
Environmental information
exchange services center
Network
l_ illirnl In Iniml nil Ii ii I niTn|i i in.
My Profile | Help | Contact Us | Logout
Logj
c
Home
Exchange Network Services News & Data Channels
MY SERVICES CENTER
Quickly access the services and queries you use
and check the status of your requests | GO |
EXCHANGE NETWORK SERVICES
Send, get, and download information from
Exchange Network partners | GO |
NEWS & DATA CHANNELS
View news and data feeds from Exchange Network
partners, subscribe to channels of interest, or
contribute your own content to these channels | GO |
X
o
My Quick Links
» Exchange Network
» Check your Submission (OA Services)
» Exchange Network Discovery Services (ENDS)
» Production CDX Web
Check out our News Feed for the latest
on what's happening with the Exchange
Network Services Center
EPA Home | Privacy and Securit,1 Notice | Contact Us
1. ENSC Title Bar
2. Quick Access Links
3. Tabs
4. Interactive Window
Note] details about how to use the ENSC are in the "Batch" section.
14
-------
Logging On
The AQS application can be accessed through the application website https://epa.gov/aqs
Note] the user may be prompted with warning messages when attempting to run AQS.
• If prompted to trust or install a certificate the user should click YES.
• If prompted to block potentially unsafe components the user should click NO.
Logon Screen
^Logon ~! x|
Username:
Password:
Database: aqsprod
Connect I Exit
The Air Quality System (AQS) is a United States Environmental Protection Agency (EPA) computer system
which may be accessed and used for authorized purposes only. Unauthorized access or use of this computer
system may subject violators to criminal, civil, and/or administrative action. All information on this computer
system may be monitored, recorded, read, copied, and disclosed to and by authorized personnel for
official purposes, including law enforcement. Access or use of this computer system by any person, whether
authorized or unauthorized, constitutes consent to these terms. AQS is exclusively for the use of federal, State,
Territorial, and Tribal environmental agency employees and their delegatees working in their official capacities.
Note] the first time AQS runs, the application may take several minutes to load.
The user will enter the User ID into the Username Field (1) and enter the user's password into
the Password Field (2). The Database Field (3) is auto populated with the database that the user
will connect to; normally this will not change.
Once both the User ID and Password have been entered, the user will press the Enter key or click
the Connect Button (4).
Logging into AQS - Training Video
15
-------
Session Screen
After successful logon the user will be taken to the Session Screen where the user will have the
option to continue as Read Only User or Screening Group Access. A screening Group roughly
corresponds to an agency or similar organization. Users may be assigned to more than one
screening group.
Read Only User:
• This allows access to all of the data in production status in the AQS database. It does NOT
allow the user to view any data that is still being processed (i.e., "pre-production" data)
or update any data.
Screening Group Access:
• Allows users of the selected screening group to view both production and pre-production
data for monitors owned by that screening group. Each monitor and all data for that
monitor is owned by only one screening group. Only users with update authority may
insert, update, or delete data for the screening group. While using this mode, the user
cannot view data owned by other screening groups.
lid AQS r^H~B~||^|
Action Help Session Admin Retrieval Maintenance Critical Rev CErtification Batch Correct Main Menu
H A m I -A 11 IB fe t i ~ 4 ~~ I m ii p | ^ | ? II
[2 Select Session Access (Read Only) I — <~!'x|
[Read Only User!
f" Screening Group Access
P User Support Screening Group Access
AQS Production Database with values from 1957 to present. Earliest raw data that is open for update: January 1, 20U9
Method code 600 has been converted to 200 for Oxides of Nitrogen. Method
codes (574, 590, 591, and 599) have been converted to (674, 690, 691, 699)
for oxides of nitrogen. The old method codes are no longer available.
Technical Support is available from the EPA Call Center, via email at
EPACALLCENTER@epa.gov or phone at (866) 411-4372. (Use voice menu pick 9.)
Please ensure you have subscribed to the AQS News Feed at:
http://w w w.epa. gov/ttn/airs/airsaqs'aqs_user_info_rss.xml
Record: 1/1
-------
User Profile
All AQS users have a user profile that was created by an AQS administrator. The user should
periodically review this information to ensure it is up-to-date.
From the Menu Bar the user should click Admin. This will open a Dropdown Menu, at this point
the user should click Security, This will open the User Profile Form in the Form Area, The user
should verify that their user information is correct.
Note] required fields are indicated by the holding of the field name throughout AQS.
Action Help Session Admin Retrieval Maintenance Critical Rev Certification Batch Correct Main Menu
0S 1 ^ a: jS 13 *§] & % I ¦ « t < ~ * ~~ ± I ^ ? 11
[2 Administration - Application Security (Tennessee)
User Profile Maintain Security I Security Reference Tables I Maintain Roles
User History
Jnjxj
First Hame MICHAEL
Phone |
Zip Code 27711
County Code
Initial |s~~
"J
Street Address 1 |l 09 TW Alexander
City |Research Triangle Park
063
AQS User ID | MSB ROOKS
EH User ID I BROOKS.MICHAELS
Fax f
User Type
Status Ind
a
Last
Street Address 2
State Code
Agency Code
AQS Contact
| EPA Region Code
EMail |BROOKS.MICHAELS©EPA Tribal User
Delete Error Transaction
BROOKS
11 OS
33
M
9
Change Your Oracle Passwords
AQS New Password:
Confirm password:
OK
17
-------
Password
At the bottom section of the User Profile Form there is a change password area. To change the
password the user will type the new desired password into the New Password field and then
retype it in the Confirm password field. Clicking the OK button will implement the change.
Change Your Oracle Passwords
AOS New Password: | Confirm password: OK
EPA IT Password Security Policies
Specific rules in this policy require the following:
1. Passwords shall be at least twelve (12) non-blank characters long.
2. All passwords, including initial passwords, shall be composed of a minimum of one
character from at least three (3) of the following four (4) categories:
a. English uppercase letters (e.g. A-Z);
b. English lowercase letters (e.g. a-z);
c. Non-alphanumeric special characters (e.g. I, #, $, %, etc); and
d. Base 10 digits/numerals (e.g. 0-9).
3. Passwords shall not contain any of the following:
a. Dictionary words (e.g. computer, work) or common names (e.g. Betty, Fred,
Rover);
b. Portions of associated account names (e.g. user ID, login name);
c. Consecutive character strings (e.g. abcdef, 12345);
d. Simple keyboard patterns (e.g. QWERTY, asdfgh); and
e. Generic passwords (i.e. passwords consisting of a variation of the word
"password" [e.g. P@ssw0rdl]).
4. At least 50% of the characters shall be changed when new passwords are created.
5. Passwords may not be reused for 24 generations.
Note] For security reasons passwords must be changed at least every 60 days. It is important that AQS users maintain
their passwords in an active status. Inactive passwords will be locked if they are not used within 30 days.
18
-------
Tribal User
If the user prefers to have the geographic portion of the site ID in AQS presented in terms of
Tribal ID rather than Federal Information Processing Standard (FIPS) State - FIPS County ID, the
user can set that preference in the User Profile Form.
User Profile
Maintain Security Security Reference Tables Maintain Roles User History
First Hame |MICHAEL Initial |s Last [bROOKS
Phone Street Address 1 |i09 TW Alexander Street Address 2
Zip Code 27711 | City |Research Triangle Park State Code IF
County Code C=: Agency Code |nos
AOS User ID [mSBROOKS User TVPe IB J AQS Contact [fj
EN User ID BROOKS. MICHAELS Statuslnd^J EPA Region Code J~ J
I EMail |BROOKS.MICHAELS@EP^ Tribal User fTJ
Delete Error Transaction 1 |
Select the checkbox labeled Tribal User.
After making the Tribal User selection the user must click the Save button or press F10 on their
keyboard to save the selection.
Tribal users are not required to do this, however any user may opt to be a tribal user. This option
can be deselected at anytime.
Being a Tribal user will change the format of Site IDs on all AQS forms and reports. Instead of the
default geographic format of:
State FIPS Code - County FIPS Code - Site Number
Sites will be displayed in the following format:
TT - Tribal Code - Site Number
The "TT" is an indicator that the next field is a tribal code and not a county code. The Tribal Code
is the Bureau of Indian Affairs (BIA) Tribal code. AQS is not allowed to establish non-BIA codes for
tribes.
Maintain Security
This is found under the Admin section on the Menu Bar then select Security then the Maintain
Security tab. This tab allows the Data Administrator and Application Administrator to select,
insert, update, and delete user assignments to Screening Groups and application roles.
19
-------
[21 Administration - Application Security (National Air Data Group)
_ ~ x
! S
User Profile j Maintain Security;
Security Reference Tables Maintain Roles
User History
Maintain Security
Screening Group Name
-
AAD
-
SAN JOAQUIN VALLEY AIR POLLUTION CONTROL DISTRICT
AAX
-
SONOMA TECHNOLOGY, INC.
—
AAY
-
UPPER SKAGrT INDIAN TRIBE OF WA
ABG
-
THE WIND RIVER RESERVATION
~
ABG
-
CONFEDERATED TRIBES OF CLUSI
Role Users
Oracle User Screening Group Name
DEVELOPER
EOB
Alaska
DEVELOPER
-
EOB
-
North Dakota
-
—
DEVELOPER
-
EOB
-
Ohio
-
ADMIN HQ
-
FRX
-
SHARED MB-BA
-
~
ADMIN HQ
"
FRX
"
National Park Service
-
Maintain Security Reference Tables
This is found under the Admin section on the Menu Bar then select Security then the Security
Reference Tables tab. This tab allows Data Administrators to maintain the security reference
tables. Here the Data Administrator can create, update and delete new user types, Screening
Group types, and Screening Groups.
Site ID Format
State Code
A two digit FIPS code that identifies one of the 50 US states. May also indicate a Tribal Area (TT)
or other country such as Canada (CC) or Mexico (80).
20
-------
C le
A three digit FIPS code that identifies a county or the equivalent geo-political entity, such as a
parish or independent city.
Tribal Code
Only visible in Tribal Mode. A two digit FIPS code that identifies one of the federally recognized
Native American tribal agencies when the Tribal Ind is set to "TT". If your Screening Group also
has non-tribal data this column will contain the County Code.
Site Number
A four digit number used to uniquely identify a site within a county. Defined and maintained by
the states or Tribal agencies. When this is a Tribal site care must be taken to ensure that the site
ID is unique not only in the Tribal Area but also in all of the counties that the tribal area includes
or crosses.
21
-------
Batch
Understanding of Batch Submission of Data - Training Video
Batch Data Submission Overview
Batch submission is loading a batch of data records all at the same time.
The advantages of batch loading data are:
• It allows for mass entry of data
• Processing of valid data happens without human interaction
• The system will notify the user when the process is complete
• Provides the user with results detailing the outcome
There are a number of steps used to submit data from a text file into the AQS database, those
steps depend on the type of data involved. The big picture process involves:
• Transfer - move a data file to the EPA using the Exchange Network (node or ENSC)
• Load - Run a batch process to Load this data into the AQS database
• Post - For raw data only, after reviewing the results of load, flag data as production-ready
(available to all)
• The process described here is for completing a batch submission using AQS interactively.
An alternative is to use an organization's node on the Exchange Network. For
instructions on how to do that, see the AQS Flow Configuration Document on the
Exchange Network website.
Formats
There are two data formats that may be submitted:
• AQS transactions - the AQS pipe delimited transaction format introduced in 2001
• XML - structured text data with
The format used will depend on what data acquisition system and/or analytical labs is available
to the user. The vast majority of users take advantage of the AQS transaction format.
Data Compatible with Batch
Not all data in AQS can be loaded via the batch process. Flere is a list of the types of data
that can be loaded via batch:
• Site data
• Monitor data
• Raw (sample) data
• Quality Assurance data
Flere are the types of data that cannot be loaded via batch:
• Comments (describing sites, monitors, audits, events, etc.)
22
-------
• Exceptional event definitions, data associations, and concurrence (for EPA staff only)
Batch Data Submissions Flowchart
The following explains the data flow to AQS.
r~
/n| /-»
1 riaH Qi immar\/
G+o+io+ir'01 onH 1
Ra
\/
POST
DON
Dan/ Rata
Step 1 (File):
Create file of ambient air data. Valid options are either text files (.txt) using the familiar delimited
"Data Input Formats" or XML files (.xml) using the AQS Schema.
Note] Data Input formats can be found in here:
https://aqs.epa.Rov/aqsweb/documents/rransactionFormats.html
Diagnose <
LOAD
23
-------
Step 2 (ENSC):
Transfer the file to AQS using the Exchange Network Services Center (ENSC).
There are two process control options from the ENSC:
Option 1 - Manually process: logon to AQS, choose the Screening Group, and proceed to
the Batch screen.
Option 2 - Automatically process: use the ENSC exclusively, bypass AQS and process all
data via the ENSC.
Step 3 (STAGE):
Processes the file into AQS.
Step 4 (LOAD):
For anything other than Raw Data (i.e. sample measurements) if there were no errors in the file
the processing is complete. For Raw Data, the LOAD step also performs STAT/CR (Statistical and
Critical Review).
Step 5 (POST):
Moves data from where it can only be seen by members of the relative screening group to
where it can be seen by any AQS user (and any EPA web application, and thus the public). It also
updates all of the summary values (e.g., NAAQS durations, Daily, Annual, and Design Value if
applicable) that the raw data contributes to. This also means that it will be used by EPA in any
calculations (completeness, compliance, etc.).
Using the ENSC
The ENSC is at https://enservices.epa.gov/login.aspx. There is also a button on the AQS Batch
Form Area that will open this web page.
0416
20141125 12:25
CRST-COMPLETED
10416
I o
I 9
20
|20141120 15:05
CRST-COMPLETED
| 20
0
1
Jl
|20141117 15:43
LOAD-COMPLETED
21
0
I
10416
Post
Post File
Other
Show User Log
Goto ENSC
Stat CR Report
Raw Data Inventory
Refresh Sessions
24
-------
A file can be submitted through an organization's node to AQS via the Exchange Network with
processing instructions (The user's IT department will have to set this up) or a file can be
submitted manually.
For manually submitting a file the following instructions are provided.
The user will login to ENSC with the production Exchange Network account and password.
Environmental Information
ejfchange services center
Network
Help | Contact Us
SERVICES CENTER
The Exchange Network Services Center is a web-based tool designed to allow Exchange Network
users to easily send, get and download information from other partners on the network.
Note: to access this tool, you must already have an Exchange Network user account assigned to
you.
Request 3n Account
O ^
default T Not sure?
Login
Forgot Username or Password
Warning Notice
This application is part of a United States Environmental Protection Agency (EPA) computer system, which is for authorized use only. Unauthorized access or
use of this computer system may subject violators to criminal, civil, and/or administrative action. All information on this computer system may be monitored,
recorded, read, copied, and disclosed by and to authorized personnel for official purposes, including law enforcement. Access or use of this computer system by
any person, whether authorized or unauthorized, constitutes consent to these terms.
EPA Home | Privacy and Security Notice | Contact Us
Logging into ENSC - Training Video
Using the ESNC to Submit Files to AQS - Training Video
25
-------
The first time a user logs into the ENSC they will need to add the AQS connection service to their
list of services. In order to add the AQS connection the user will select the Exchange Network
Services tab or click the 'Go' button on the Interactive Window area labeled EXCHANGE
NETWORK SERVICES.
Environmental Information
exchange services center
Network
Logged In: brooks.michaels@epa.gov
Mv Profile | Help | Contact Us | Logout
Home
Exchange Network Services News & Data Channels
MY SERVICES CENTER
Quickly access the services and queries you use
and check the status of your requests | GO |
1
EXCHANGE NETWORK SERVICES
Send, get, and download information from
Exchange Network partners | GO |
O
NEWS & DATA CHANNELS
View news and data feeds from Exchange Network
partners, subscribe to channels of interest, or
contribute your own content to these channels | GO |
My Quick Links
Exchange Network
Check your Submission (QA Services)
Exchange Network Discovery Services (ENDS)
Production CDX Web
Check out our News Feed for the latest
on what's happening with the Exchange
Network Services Center
EXCHANGE NETWORK SERVICES
Send, get, and download information from
Exchange Network partners GO
26
-------
At this point the user will type AQS into the search field of the Express Request box.
Exchange Network Services
News & Data Channels
My Quick Links ~
Use either the Step-by-Step OR Express approach to send. get. or download information from the Exchange Network.
CHOOSE
Guide Me Step-by-Step Q
(recommended for novice users) Express Request Q
(recommended for advanced users)
Step 1: Choose the Type of Transaction to Perform 0
• Send information to a system on the Exchange Network
Get information that is stored on the Exchange Network
Download a document from the Exchange Network. You must know
the Transaction ID or Document ID to perform a download
OR
Search for a Service by Keyword
AQS|
OR
Browse our entire Services Directory
Browse Services Directory
The Service Directory window will open displaying a list of choices. The user will click the Send
Info link for the AQS Submit service.
Services Directory
This directory runs from Exchange Network Discovery Service (ENDS) metadata, ft requires the commitment of our Network to keep it up to date and useful. For
the BETA version, the Services Directory contains only services that support Submit. Query: Solicit, and Download operations. Select the name of the Service
you wish to use.
Filter By: Keyword(s)
AQS
Get Info AQDE
Send Info AQS
Send Info AQS
Get Info AQS
AQDERawData
ProcessAQSDoc
AQS Submit
1 -13 of 13
< Previous 1 Next >
Service
Dataflow
Service Name
Service Description
Node
Service
Transaction
Provider
Queries or Solicits the Raw Data for the
AQDE Flow. The return is an XML file that
conforms to the AQS Version 2.0 Schema.
NewJersevNodeVI Prod NJDEP
Air Quality System Document Submissions NetNode2
AQS Submit: Send files to the Air Quality
System (AQS).
GetAQSRawDatalnsertByDate AQS - GetAQSRawDatalnsertByDate
Service
NGNProdZO
NV
U.S.
Environmental
Protection
Agency
U.S.
Environmental
Protection
Agency
Nevada
Division of
Environmental
Protection
(NDEP)
27
-------
The user will then complete the Express Request form.
Express Request: AQS Submit
K
t'
lelect a Document to Upload (max. size 1 GB):
Choose File No file chosen
Enter Sender's Email Address to Notify of Transaction Status Changes:
AQS User ID:
)
)
)
:
Additional Data Flow Specific Information:
Screening Group:
rileType:
rinal Processing Step:
Stop On Error:
Provide information (metadata) about this Document (recommended)
Cancel
SEND DATA
50 Test User Screening Group
6. The Choose File button allows the user to select a document from their local computer or
network.
7. File transfer information will be sent to the email address the user inputs into this field.
The user can input one or multiple email addresses (this field is optional). Multiple email
addresses must be seperated by commas.
8. The user must input the AQS User ID assigned.
9. The user will select, from a drop down menu, the screening group the user is submitting
data for.
10. The user will select the appropriate file type (format) from the drop down menu.
a. AQS text transactions (MA, RD, etc.) are flat files.
28
-------
11. The Final Processing step is where the user provides AQS with instructions on how far to
process the file before stopping and waiting for the user to log on and review/complete
processing.
a. Stage copies the data from the submitted file into the AQS database, but does no
processing of the contents of the file. If an error is reported during the stage
process, the problem must be fixed in the user's data file and resubmitted.
b. Load moves the submitted data into the AQS database and performs field
validation (i.e. is each field on each transaction valid) and relational checks (i.e. is
pre-requisite data present). If errors occur during the load process, the user can
fix the error in AQS via the Correct Forms or the user can correct the problem in
their own database and start the process over.
i. Some data can complete the load process while other data has errors.
ii. For Raw Data Only: AQS runs a variety of statistical tests on the data to
look for statistical anomalies (outliers). The user will receive warnings (not
errors) if the data is flagged by a statistical check.
c. For Raw Data Only: Post changes the status of the data from where it can only
be seen by members of the user's screening group to where it can be seen by any
AQS user. Also, all of the relevant summary values will be updated in this step.
i. The user cannot have an error during the Post process.
ii. To process the file as far as possible, select Post.
12. The user will select either 'Yes' or 'No' for the Stop on Error processing command.
a. Yes prompts AQS to examine the results of the stage and load programs (both for
errors and warnings) and stop any additional processing of the file if there are any
errors or warnings in the data.
b. No prompts AQS to process all the data it can through the final processing step
you selected.
13. The user can optionally provide additional data by expanding the Provide information
(metadata) about this Document but it is not necessary. AQS will not store this additional
metadata.
14. After the user has entered values for all of these fields the user should click the Send
button to begin the AQS submit process.
29
-------
After the user clicks the Send button the 'Request Received!' screen wiil appear.
Env
e
iranmenlal Information
/change
^-Network
SERVICES CENTER
My Services Center
r ^
Exchange Network Services
r
News & Da
Request Received!
Your File AMP501_1280016-0.txt has been received.
The following Transaction ID has been assigned to this request:
_299d b c2f-62c4-4f 8f-8c5d -115362017425
Current Status of Request:
Transaction Status
Service Name
Transaction Type
Date
Processing
AQS Submit
Send Information
3/2/2015 2:58 PM
What would you like to do next?
View the Status of this request in My Activity
Complete another Transaction using this same Service
Complete another ~ransaction using a different Service
Add this Service to My Quick Links
Log out of the Services Center
The screen will display the status and a transaction ID. From here the user can select a link under
the 'What would you like to do next?' header. An email, from cdx@epa.gov, containing the file
transfer information will be sent to the email address or addresses the user input into the 'Enter
Sender's Email Address to Notify of Transaction Status Changes:' field. AQS will also send the
user (to the address AQS has on record) an email summarizing all processing with links to
reports.
30
-------
Job Status
The values for the Job Status reflect how the batch job ran. They are:
Ran
Job completed
Not Run Yet
Job has not run yet.
Failed Before Run
Some error occurred that caused the job not to run. User should
contact support.
Failed During Run
Some error occurred during the execution of the module. User
should contact support.
ENSC Subsequent Uses
After the initial submittal all subsequent submittals can be processed through the 'My Service
Center' interactive window. After logging into ENSC the user will select the My Service Center
tab or click the 'Go' button on the Interactive Window area labeled MY SERVICE CENTER.
Logged In: brooks.michaels@epa.gov
Mv Profile | Help | Contact Us | Logout
My Quick Links Manage
» Exchange Network
» Check your Submission (QA Services)
>> Exchange Network Discovery Services (ENDS)
» Production CDX Web
~ Check out our News Feed for the latest
on what's happening with the Exchange
Network Services Center
This will open the My Service Center interactive window.
Environmental Information
exchange services center
V Nptwnrk
iiulAoiti
News & D
MY SERVICES CENTER
Quickly access the services and queries you
and check the status of your request! | GO |
EXCHANGE NETWORK SERVICES
Send, get, and download information from
Exchange Network partners | GO |
O
NEWS & DATA CHANNELS
View news and data feeds from Exchange Network
partners, subscribe to channels of interest, or
contribute your own content to these channels | GO |
31
-------
Environmental Information
exchange
Network
SERVICES CENTER
Logged In: brooks.michaels@epa.gov
Mv Profile | Help | Contact Us | Logout
My Service
0
tv I Mv Ch.
Exchange Network Services News & Data Channels
My Services | Mv EPA Activity | Mv Channels
Make this my Start page
Mv Quick Links ~
© Add this page to Mv Quick Links
My Services
Access services you have used before. Use a New Service
a>
All Send Info Get Info Download My Queries
Find a Service:
• My Services Services Directory
Service Name
Service Description
\|P
Publisher
RSS-
Last Used
enabled
NGNProd2.0/AQS/AQS
AQS Submit: Send files to the Air Quality System
U.S. Environmental Protection
No
3/2/2015 2:58:04
Submit
(AQS).
Agency
PM
1. To send data to AOS the user will select the 'Service Name' ending in AQS Submit.
a. The user should verify that the 'Service Description' shows AQS Submit: Send files
to the Air Quality System (AQS).
2. The user can see previous submissions by selecting the 'My EPA Activity' link.
3. The user has the option to make this page the Start page, reducing the necessary steps
for submitting data.
Loading Files Using AQS
This section covers the file processing functions available within AQS. This section assumes that a
file that has been through the stage process, but has gone no further in AQS. (This would be the
case if the Final Processing Step from the ENSC was Stage.)
Loading Files Using AQS - Training Video
32
-------
Batch Form Overview
After logging in to AQS the user will select Batch from the Menu Bar.
Lij aqs
y Help Session Admin Retrieval Maintenance Critical Rev CErtification Correct Main Menu
08 II 4 0.11 El Ih % I ¦ « t < ~ * ~~ i * |p % ?
^BATCH (Tennessee)
Process by File
History
T
HISTORY AND STATUS
Submission
Date
Records
In File Date (last)
Process
Status
LOAD-
Recs
-POST-
Stat/CR
Recs Failing Finding Records Skip'd Records
Loaded to Load Count to Post Monitors Posted
[20141218 16.28 EastmanNovember14 txt zip IISIHiMlUfflil
| 10806 |20141218 16:39 |POST-COMPLETED |10798
~or
5
i hi r
0 10792
|20141212 15:53 |TN Oct Precision.txt.zip (BILLY PUGH
28 |20141212 16:10 LOAD-COMPLETED | 28 |
—r
i i
I
|2014-1211 11:00 (TNOct2014continuous.txt zip|BILLY PUGH
14136 (20141211 11:31 |POST-COMPLETED |14136 |
~~0
i 11
0 |14136
|20141202 12:05 lNYRStarOct2014.txt.zip |BILLY PUGH
| 2991 (20141202 12:33 |POST-COMPLETED | 2991 |
o r
0
2986 .
0 | 2986
(20141202 12:15 |TN AQSReport Sep 2014.txt. JBILLY PUGH
13680 |20141202 12:33 |POST-COMPLETED |12960 |
or
0
| 12960 P
0 |12960
|20141202 11:58 |PbTnq3.txt.zip ]BILLY PUGH
32(20141202 11:59 |POST-COMPLETED | 32 |
nt
~~0
I 30 |
0 | 30
(20141125 14:42 |TDEC_AQS PM2.5_Septemt|EVELYN HASKIN
657 |20141125 14:49 [POST-COMPLETED | 587 |
IbF
0
i 571 r
0 | 571
|20141125 12:09 |Eastman Oct 2014AQSRepo (BILLY PUGH
11166(20141125 12:27 |POST-COMPLETED 111166 |
~r
~~6
126 r
~~0 |11160
|20141125 12:24 lResoluteFP102014.txt.zip |BILLY PUGH
| 10416 |20141125 12:25 |CRST-COMPLETED (10416 |
9
| 10416 I
o f~
(20141120 15:04 |Exide October 2014 Data.txt. |BILLY PUGH
| 20 (20141120 15:05 (CRST-COMPLETED !| 20 |
T
I 20 |
o r
|20140807 10:47 |RAQ22014.txt.zip ]BILLY PUGH
45(20141117 15:43 LOAD-COMPLETED | 21 |
or
I I I
Other
Show User Log
Post File
Goto ENSC
Raw Data Inventory
Stat CR Report
Refresh Sessions
PROCESS FLOW
R3w\Y
fcrmc. ¦'
Summary
II J £irnr-_-
PROCESS CONTROL Load
Process selected file through: Load File |
Results and Reports: Load Summary and Errors
DwgnQsi? and
fix problem
Row Dam inventory j
Statistical and Critical Review (SlalCR) J
AQS Batch Form Overview - I raininfi Video
33
-------
Process by File Tab
The "Process by File" tab shows a summary of all of the processing that has been performed by
AQS for a submitted file.
The AQS Batch "Process by File" tab has 5 main areas.
1, File processing History and Status area.
UlCTflDV A Kin OT ATI IO
1 Submission
Date
Records
File Name User Name in File
Date (last)
Process
Status
20141218 16:28
EastmanNovember14.txt.zip
10806
20141218 16:39
POST-COMPLETED
(20141212 15:53
JTN Oct Precision.txt.zip |BILLY PUGH
28
20141212 16:10
LOAD-COMPLETED
|20141211 11:08
TNOct2014continuous.txt.zip BILLY PUGH
| 14136
20141211 11:31
POST-COMPLETED
(20141202 12:05
NYRStar Oct 2014.txt.zip
BILLY PUGH
2991
20141202 12:33
POST-COMPLETED
|20141202 12:15
JTN AQSReport Sep2014.txt. (BILLY PUGH
| 13680
20141202 12:33
POST-COMPLETED
|20141202 11:58
PbTnq3.txt.zip BILLY PUGH
32
20141202 11:59
POST-COMPLETED
(20141125 14:42
TDEC_AQS PM2.5_Septemt
EVELYN HASKIN
657
20141125 14:49
POST-COMPLETED
(20141125 12:09 [Eastman Oct 2014AQSRepo (BILLY PUGH
11166
20141125 12:27
POST-COMPLETED
|20141125 12:24
lResoluteFP102014.txt.zip BILLY PUGH
| 10416
20141125 12:25
CRST-COMPLETED
(20141120 15:04
Exide October 2014 Data.txt.
BILLY PUGH
20
20141120 15:05
CRST-COMPLETED
|20140807 10:47 jRAQ22014.txt.zip (BILLY PUGH
45
|20141117 15:43
(load-completed
The History and Status area shows a list of the files that have been submitted and the most
recent action performed. There is one row per file.
There are six columns in this area, and they are:
• Submission Date: This indicates the original date and time the file was staged to AQS (the
format: YYYYMMDD HH:mm where HH is on the 24 hour clock and Eastern Time).
• File Name: The name of the file.
• User name: The name of the last user in the agency who initiated a processing step for
this file.
• Records in file: The total number of transactions in the file (records if it is a flat file, the
equivalent for XML).
• Date (last): The last time an action was performed on this file.
• Process Status: The most recent process initiated for this file and the status of that
process.
o Process can be:
¦ Stage = Converting data from submitted format to AQS database format
¦ Load = Loading data into AQS database
¦ CRST = Critical Review and Statistical Tests
¦ Post = Incorporate data in to summaries and make data public.
34
-------
o Status can be:
¦ Submitted (meaning it is waiting to execute)
¦ Active (actively processing)
¦ Error (completed with errors)
¦ Completed (completed with no errors)
2. Load processing results summary.
i nan
Recs
Recs Failing
Loaded to Load
StatfCR
Finding
Count
10798
o
I &
28
I o
m\
14136
0
0
2991
0
I 0
12960
0
0
32
0
0
587
18
0
11166
0
6
10416
0
9
20
o
1
21
o
I
The Load processing results summary. This area provides a summary of what happened to each
record (transaction) in the file during all of the load processes.
There are three columns in this area, and they are:
• Recs Loaded: The total number of records from this file that have been successfully
loaded into AQS. Keep in mind, Load means different things for different types of data.
For everything but raw data, it means it is now fully into AQS. Raw data: the data still
needs to be posted.
• Recs Failing to Load: The number of records that could not be loaded into AQS due to
some kind of error. The "Recs Loaded" plus the value in this column should equal the
number of records in the file.
• StatCR Finding Count: The number of records that raised concern during Statistical and
Critical Review process (StatCR). The StatCR process is run automatically every time the
load process is run with Raw Data. It compares new data to old data and expected
ranges, etc. and presents any "findings" of possible outliers or other problematic data.
These are not errors, they are oddities in the data flagged for user information.
35
-------
3. Post processing results summary.
nn^T
Records Skip'd
to Post Monitors
Records
Posted
| 10792
|0
10792
I
I 1
0
14136
| 2986
0
2986
12960
0
12960
30
0
30
571
0
571
126
0
11160
10416
0
20
0
I
The Post processing results summary area provides a summary of the file with respect to the
POST processes.
There are three columns in this area, and they are:
• Records to Post: The total number of Raw Data records from this file that need to be
posted (the number of successfully loaded raw data records). If this number is more than
zero, the Post process needs to be executed to complete the submission of this data to
AQS.
• Skip'd Monitors: The number of monitors for which the posting of data was skipped
during processing. This should only happen if another user is editing or submitting data
for the same monitors.
• Records Posted: The number of records for which post processing completed
successfully. When this number matches the "Records to Post" column for the file,
processing is complete.
36
-------
4. Process control - where results can be reviewed and additional processes performed on
files.
PROCESS CONTROL
Load
Post
Other
Show User Log
Process selected file through:
Load File
Post File
Goto ENSC
Results and Reports:
Load Summary and Errors
Stat CR Report
Raw Data Inventory
Refresh Sessions
The Process control area allows the user to review results of earlier processed files and perform
additional processing. The process control area only acts on the file (row) that is highlighted on
the top part of the form.
Depending on the status of the file, certain areas will be unavailable (grayed out). The processing
of files is controlled on the horizontal row labeled "Process selected file through"
The user can select either load or post. Selecting post will perform load processing on the file if
necessary.
The available reports generated by each process are shown below the process. For example, the
load process generates two reports, the Load Summary and Errors report and the Stat CR Report.
The post process generates only one report, the Raw Data Inventory report.
Stat CR Report
Raw Data Inventory
Load Summary and Errors
PROCESS CONTROL
Results and Reports:
Process selected file through:
Load File
Load
Post File
Post
Refresh Sessions |
Show User Log
Goto ENSC
Other
Note] Reports can only be retrieved within two weeks of the Submission Date.
The last group of buttons in the Process Control area are labeled 'Other', they perform the
following actions:
• Show User Log: This opens the same file that was emailed to the user (summarizing the
most recent processing on the file) in a browser window.
• Goto ENSC: This opens an ENSC (file submission) window in a browser window.
• Refresh Sessions: This updates all of the information on the top part of the screen. If the
user is waiting for a job to finish, the user can press this button rather than reloading the
entire form to get updated information.
37
-------
5. Process flow - A reminder of how AQS processes a file.
PROCESS FLOW
Correct
FILE
ENSC
Stage
Load
Errors?
DONE
Raw Dam Inventc
IStatistical and Critical Review (Stat CR)
Stage
The first step is to Stage the data file. This means to transfer the file to AQS via the Exchange
Network and then to convert the data to the AQS database format.
The following are the most common errors that can occur with Stage:
1. If the file never shows up on the Batch form, then there was a transfer error and AQS
never received the file.
a. To diagnose: Review the status email from the Exchange Network and contact
the Exchange Network Node Help Desk. (Email: nodehelpdesk@epacdx.net.
Phone: (888) 890-1995).
2. All Stage failures where AQS actually receives the file result in the status, "UPLOAD-
FATAL" on the batch form. The email from the Exchange Network will provide a status
that can be interpreted as follows:
a. "E_AccessDenied: Access Denied" This means that the AQS user-id provided on
the ENSC submission form is not authorized for the Exchange Network user-id
that submitted the file. The user can configure this on the AQS Admin/Security
form.
b. "E_LoaderNoProcess: AQSLOAD process is not active." This means that the AQS
batch process started, but did not finish. Contact the EPA Call Center (Email:
epacallcenter(5)epa.gov, Phone: (866) 411-4372) for assistance.
c. "E_LoaderStartLimitExceeded: AQSLOAD start time limit has been exceeded."
This means that the user's account is not set up properly for batch submissions.
Contact the EPA Call Center for assistance.
d. "E_AccessDenied: Unknown AQS User Id specified. Access Denied." This means
that an invalid AQS user-id was provided on the ENSC submit form.
e. "EJnvalidScreeningGroup: Invalid Screening Group" This means that the user is
not authorized for the selected screening group. The user should check the
screening group provided and correct if incorrect, or contact the EPA Call center if
the user needs access to that screening group.
38
-------
Load
After the file has been staged, it can be loaded. Loading the file moves the submitted data into
the main AQS database and performs field validation and relational (e.g., is pre-requisite data
present) checks.
PROCESS CONTROL
Load
Process selected file through:
Load File
The Statistical Tests and Critical Review (sometimes abbreviated StatCR or CRST) process is also
performed at the end of the load step for Raw Data.
This process compares data to other values and expected ranges, etc. and presents any
"findings" of possible outliers or other problems. These "findings" are not errors, they are really
indications of a data point that is an outlier. The data may be fine, but the user should be alerted
to any potential problems.
— load
Recs Stat/CR
Recs Failing Finding
Loaded to Load Count
10798
Note] the results of the StatCR process can change over time. For example, the data representing an incomplete
calendar quarter may be different from a complete calendar quarter (this includes data in the submitted file plus any
data already in AQS).
The Load process generates the "Load Summary and Errors" report and the "Statistical and
Critical Review" report.
Also, the fields in the Load Status area at the top of the form will be updated and the system will
send the user an email with a summary of processing and links to all reports that were
generated. This includes a link to a file that only contains the records in error.
Results and Reports: Load Summary and Errors | Stat CR Report
Load Summary and Errors Report
This report contains two parts. Load Summary and Load Detail.
The first is a table summarizing, by transaction type, the number of records in error and the
number of records loaded (in the column labeled "Pre-Production") and the number of records
posted. Recall, raw data records will be loaded (to pre-production) and any records that are not
raw data will be posted if they are not in error.
39
-------
The second part of this report details any errors in the data on a record by record basis. The
data, in transaction format, will be presented along with the error related to that record. If there
are more than a few thousand errors in the file, the system stops listing them so the report will
not include all of them.
Statistical and Critical Review report
The second report generated by the load process contains information about irregularities in the
processed data. These are not errors, but warnings (or "findings").This report will list the
monitor, the date/time, and the problem with any data values.
Load Errors
The "Records Failing to Load" column at the top of the screen or the Load Summary and Errors
report will show the user if there are load errors.
Recs
Failing
to Load
13392
~~0
Results and Reports:
Load Summary and Errors
Clicking the Load Summary and Errors button will open the LOAD Report in a separate browser
window. The third page of this report is where the Load Detail can be found.
C FPAUm>IdSut" Air Quality Subsystem
V/LlT^ Environmental Protection Agency [_03Cl Report
Load Detail
File Name : _id_test_pm-1.txt.zip
Screening Group: Idaho
Jul. 23,2013
Sit&'Monitor ID: 16-041-0001-88101-4 Table Name: ST_R/tyV_DATA ^
Transactions |l |161041 10001 |88101 |4 |11105|181120130401 |00:00 |5200.0111111111111111 \
Column Error Description
Error Code
Relational Standard value falls outside absolute value range for the parameter.
-20723 |
Site Monitor ID: 16-041-0009-88101-4 Table Name: ST_RWV_DATA
Transactions |l |161041 |0009|88101141111051181 (20130401 |01:00|2.1111111111111111 2
Column Error Description
Error Code
Multiple Columns Monitor ID (State, County, Site, Parameter, POC) not in database
-20405 |
Site'Monitor ID: 16-041-0009-88101-4 Table Name: ST_R WV_DATA
Trans actio II^D |l |16|041 |0009|88101 |4 |11105|181120130401 |02:00|4.5|| 11II11II11III
Column Error Description
Multiple Columns Monitor ID (State. County, Site, Parameter, PQC) not in database
Site/Monitor ID: 16-041-0009-88101-4 Table Name: st_r/jw_data
Tl «1 IIS actio liRD |l |161041 I0009188101 |4 |111051181120130401 |03:001-0.9111111111111111
Column Error Description Error Code
Multiple Columns Monitor ID (State, County, Site, Parameter, POC) not in database " -20405 |
\.V- —
1. The raw data value is outside the acceptable values (the wrong unit code in the file).
2. An incorrect site ID on the raw data transaction.
Error Code
-20405 |
40
-------
If errors occurred during the load process, there are two ways that the data can be fixed. The
first is to fix it in AQS via the Correct option in the Menu Bar. (How to use Correct to edit the
data is covered elsewhere.) The second option is to use the link to the file of error transactions
from the batch job email, to download the file, fix the errors, and resubmit.
Raw Data
If the user's file contains raw data the user must complete the Post process. If the file contains
no raw data the data has been placed in the public part of the AQS database and the file process
is complete.
Post
The post process is necessary for raw data. It moves data from where it can only be seen by
members of a select screening group to where it can be seen by any AQS user (and any EPA web
application, and thus the public). It also updates all of the summary values (e.g., NAAQS
durations, Daily, Annual, and Design Value if applicable) that the raw data contributes to.
It is built into the process as a stopping point to allow for review of any load errors or statistical
findings before making the data public.
Note] when the user Posts a file, it is run through both the Load (including the StatCR) and Post processes in AQS. This
is to ensure that all the data in a file is processed together and no "stragglers" are left behind in our multi-step
process. The unfortunate side effect of this is that older Load Summary and Error and Stat CR reports will be
overwritten with new (and perhaps empty) results. If a prior version of these reports is needed, it can be obtained
using the history tab. (All reports are deleted from AQS after two weeks.)
Raw Data Inventory report
The Post process generates the Raw Data Inventory report. This report is a count by monitor and
calendar quarter of the types of data actions (insert, update, and delete) that were taken by
AQS.
PROCESS CONTROL
Load
Post
Process selected file through:
Results and Reports:
Load File
Post File
Load Summary and Errors
Stat CR Report
Raw Data inventory ;|
After running the Post process the submittal of raw data is complete.
41
-------
When Things Go Wrong
Unfortunately, not all files will be submitted in one step from the ENSC. Files may have an error
that causes batch processing to stop (whether the entire file stops processing or just the records
in error depends on the "Stop on Error" setting at the ENSC).
Note] in the second quarter of 2013:
• 7,800 files, containing 50 million transactions total, were submitted to AQS.
• 25% of files with Raw Data transactions had a raw data error.
• 50% of files without Raw Data had an error (e.g., site, monitor, or OA data error).
• A file with an error was re-processed (corrected and re-loaded) an average of 1.5 times.
When things go wrong the user can use the AQS 'Correct' (which is covered in the Correct
section of this document) or the user can fix the data on the user's end either in the file or in the
database and regenerate the file.
42
-------
Type of Data in AGS
Site Data
Site information refers to the geographical location where monitoring occurs. This includes the
following types of information: latitude and longitude coordinates, what geopolitical entities at
location (e.g. county, city, EPA Region, etc), local site name, and street address. Information
about nearby roads is also stored with the site information.
Identified by:
AQS generally list site IDs in the following way:
SS-CCC-NNNN
SS is the State FIPS (Federal Information Processing Standards) Code, CCC is the County FIPS
Code, and NNNN is the Site Number within the county.
Note] leading zeros are always included.
Example:
01-089-0014
Alabama, Madison County, Site Number 14.
Tribal site IDs do not list state and county. They are listed in the following way:
TT-BBB-NNNN
TT is two capital Ts to denote Tribal, BBB is the BIA (Bureau of Indian Affairs) Tribal code,
and NNNN is the Site Number within the tribal lands.
Example:
TT-007-7002
Tribal, St. Regis Band of Mohawk Indians of New York, Site Number 7002.
43
-------
Required Group
Locational data is required but only one or the other of the methods is to be used. The user may
choose to define a site by Latitude/Longitude or UTM, not both. Whatever is provided will be
used to calculate the other value. In Tribal Mod, UTM data is read only so only
Latitude/Longitude values are accepted.
Monitor Data
For the purposes of AQS, a monitor does not refer to a specific piece of equipment. Instead, it
reflects that a given pollutant (or other parameter) is being measured at a given site. Monitor
description information covers several different types of information about how the monitor is
configured. Such as:
When was the monitor operational? How high is the probe? Where is the probe located? How
close is this monitor to the highway? What monitoring networks does it belong to? What is the
objective of this monitor? Who owns and operates this monitor?
Identified by:
The site where the monitor is located, the pollutant code, and POC (Parameter Occurrence
Code), which is used to uniquely identify a monitor if there is more than one device measuring
the same pollutant at the same site.
For example monitor IDs are usually written in the following way:
SS-CCC-NNNN-PPPPP-Q
Which is the Site ID plus, PPPPP being the AQS 5-digit parameter code, and Q is the POC.
For example:
01-089-0014-44201-2
Alabama, Madison County, Site Number 14, ozone monitor, POC 2.
Ambient Air Quality Data
Raw data, also called sample data, is by far the most abundant data in the database. The raw
data are the individual ambient air quality measurements collected from the monitors.
Identified by:
The monitor where the measurement was taken and the time when the sample was taken.
44
-------
Quality Assurance Data
Quality Assurance (QA) data consists of the set of audits that are utilized to verify that the
measurement uncertainty (error) associated with sample measurements (raw data) is within
acceptable limits. For the regulatory pollutants, the process is defined by Title 40 of the Code of
Federal Regulations, Part 58, Appendix A. Other specialized programs, such as the Chemical
Speciation Network (CSN) have their own QA requirements. AQS supports a set of QA
transactions for submitting this information.
Identified by:
The monitor or lab where the quality check was taken and the date-time of the check.
Summary Data
All of the data is submitted to AQS for one primary purpose: to determine the exposure of
populations to certain pollutants. Since most of the health-related measurements are couched
averages of various time lengths, the system creates multiple levels of summaries of the raw
data. The data is summarized on a daily, quarterly, and annual basis. Additionally, if there is a
national standard for pollutant with a special averaging time (such as a running 8-hour average
for example), the system will create these summarized averages as well.
Transaction Formats
The first field of all input formats is the transaction type, i.e., "RD", which indicates the type of
data in the record. 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. Valid
transaction types can be found at:
https://aqs.ep3.Rov/aqsweb/documents/TransactionForn1ats.html
Data Codes
Data codes and related user documentation can be found in the AQS Data Coding Manual. The
AQS Data Coding Manual is housed on the AQS website: https://www.epa.gov/aqs.
45
-------
Production Level Data
Browse
There are five Browse Functions, found under the Retrieval section of the Menu Bar. Each of
them provides the user with read-only access to specific production level data related to the
specific form. The user has the option to select a limited range of data on each of the forms by
selecting specific query filters, which vary from form to form.
The five Browse Forms are:
Annual Summary
Approved Regional Methods
Monitoring Seasons
Parameters
Sample Methodology
Annual Summary
The Browse Annual Summary form, found under the Retrieval section of the Menu Bar, gives the
user the ability to query and browse through production-level Annual Summary Data. The user
can limit the data retrieved by entering specific selection criteria on the form.
The available criteria are displayed on the form under two different tabs:
Tab: Monitor
S ect i o in: A in in u a II S u m m a r i es
State Code
County Code
Site ID
Parameter Code
POC
Summary Year
Duration Code
EDT
Pollutant Std
Obs Cnt Lt Half MDL
Observation Pet
Geom Std Dv
Arith Std Dv
Geometric Mean
Arithmetic Mean
Min Sample Value
Observation Cnt
46
-------
Sum Method Cnt
Direct Entry Ind
Criteria Ind
Null Data Obs Cnt
Cert Ind
Valid Day Cnt
Exp Data Cnt
Val GT Pri Std
Val GT Sec Std
Est Days GT Std
Days GT Alert Level
Non-Overlap GT
Miss Days LT Std
Req Mon Cnt
Weighted Mean
Ans Type
S ect i o in:: S u m m a iry IP ro to c o II s
Mp Id
Coll Freq Code
Comp Type
Alt MDL
Parameter Code
Parameter Desc
Method Code
Coll Desc
Anal Desc
Duration Code
Duration Desc
Rep Unit
Rep Unit Desc
Std Unit
Std Unit Desc
Tab: Summary Maxim urns
Section:: 5u irn ma iry IMaxi inn u irris
Max Level
Max Sample Value
Max Coll Date
S ec t i o in:: S u irn irn a ry IP e re e in t i II es
Percentile Num
Percentile Sample Value
47
-------
Correct
Correct Overview
Correct within AQS is used to modify data that has been staged (uploaded) but not yet fully
loaded into the AQS database. Correct only works on data that has been staged and not yet
loaded.
L=d AQS
Action Help Session Admin Retrieval Maintenance Critical Rev Certification Batch |CQrrect| Main Menu
When data is submitted it is first placed in an area of the system call the "Staging Tables". Once
data has been successfully processed by the AQS Load program it is no longer available to
Correct.
Since each transaction is formatted differently (has a different number of fields with different
content), there is a Correct form for each transaction type.
To access a correct form the user will click the Correct link in the Menu Bar, this will open a drop
down menu. Here the user will select the particular form from the menu or sub-menu.
Main Menu
Site Data
~
Monitor Data
~
Raw
QATransactions
~
Blanks
Composite
Delete by Screening Group
Main Menu
Under Site Data:
• Site
• Open Path
• Tangent Road
• Site Sampler
• Sampler Channel
Under Monitor Data:
• Monitor
• Samp Period
48
-------
• Types
• Objectives
• Samp Schedule
• Probe Obs
• Reg Compliance
• Collocation
• Protocol
• Agency
• Tangent Road
• Monitor Network Affiliations
• Primary Monitor Period
• Monitor Channel
• Monitor Method
• Monitor Exclusion
Under QA Transactions:
• One Point QC
• Annual Performance Evaluation
• Semi Annual Flow Rate Audit
• Flow Rate Verification
• PM-Coarse Flow Rate Verification
• PM Coarse Semi Flow Rate Audit
• Performance Evaluation Program
• NPAP
• Field Proficiency Test
• Duplicate
• Replicate
• Speciation Flow Rate Verification
• Speciation Semi Annual Flow Rate Audit
• Pb Analysis Audit
• Lab Proficiency Test
• Ozone SRP and Standard Transfer Verifications
• Ambient Air Protocol Gas Verification Program
49
-------
Rows Errors
The Row Errors block in the form indicates the errors or conditions on the current Correct Form
row that prevented that data from properly loading.
The data displayed on the Row Errors screen is for display only (errors may not be updated or
deleted) and applies only to the currently selected Correct row. Row Errors will not exist for data
records being inserted.
Correct Monitor Agency Roles
To access the Correct Monitor Agency Roles form the user will click the Correct link in the Menu
Bar, this will open a drop down menu. Here the user will select Monitor Data from the menu
then the user will select Monitor Agency Role from the sub-menu.
The Correct Monitor Agency Roles form provides the capability to correct data that failed at least
one table constraint validation and therefore could not be inserted into the production tables.
This form will display the erroneous monitor agency role data and any associated errors for the
currently selected data record.
Correct Monitor Collocations
To access the Correct Monitor Collocations form the user will click the Correct link in the Menu
Bar, this will open a drop down menu. Here the user will select Monitor Data from the menu
then the user will select Collocation from the sub-menu.
The Correct Monitor Collocations form provides the capability to correct Monitor Collocation
data that failed at least one table constraint validation and therefore could not be inserted into
the production tables. This form will display the erroneous monitor collocation data and any
associated errors for the currently selected data record.
Correct Monitor Objectives
To access the Correct Monitor Collocations form the user will click the Correct link in the Menu
Bar, this will open a drop down menu. Here the user will select Monitor Data from the menu
then the user will select Objective from the sub-menu.
The Correct Monitor Objectives form provides the capability to correct Monitor Objective data
that failed at least one table constraint validation and therefore could not be inserted into the
production tables. This form will display the erroneous monitor objective data and any
associated errors for the currently selected data record.
50
-------
Correct Monitor Regulation Compliances
To access the Correct Monitor Regulation Compliances form the user will click the Correct link in
the Menu Bar, this will open a drop down menu. Here the user will select Monitor Data from the
menu then the user will select Reg Compliance from the sub-menu.
The Correct Monitor Regulation Compliances form provides the capability to correct Monitor
Regulation Compliance data that failed at least one table constraint validation and therefore
could not be inserted into the production tables. This form will display the erroneous monitor
regulation compliance data and any associated errors for the currently selected data record.
Correct Monitor Tangent Roads
To access the Correct Monitor Tangent Roads form the user will click the Correct link in the
Menu Bar, this will open a drop down menu. Here the user will select Monitor Data from the
menu then the user will select TaNgent Road from the sub-menu.
The Correct Monitor Tangent Roads form provides the capability to correct Monitor Tangent
Roads data that failed at least one table constraint validation and therefore could not be inserted
into the production tables. This form will display the erroneous monitor tangent road data and
any associated errors for the currently selected data record.
Correct Monitor Types
To access the Correct Monitor Types form the user will click the Correct link in the Menu Bar,
this will open a drop down menu. Here the user will select Monitor Data from the menu then the
user will select Types from the sub-menu.
The Correct Monitor Types form provides the capability to correct Monitor Types data that failed
at least one table constraint validation and therefore could not be inserted into the production
tables. This form will display the erroneous monitor type data and any associated errors for the
currently selected data record.
Correct Monitor
To access the Correct Monitor form the user will click the Correct link in the Menu Bar, this will
open a drop down menu. Here the user will select Monitor Data from the menu then the user
will select Monitor from the sub-menu.
The Correct Monitor form provides the capability to correct Monitor data that failed at least one
table constraint validation and therefore could not be inserted into the production tables. This
form will display the erroneous monitor data and any associated errors for the currently selected
data record.
51
-------
Correct Probe Obstructions
To access the Correct Probe Obstructions form the user will click the Correct link in the Menu
Bar, this will open a drop down menu. Here the user will select Monitor Data from the menu
then the user will select Probe Obs from the sub-menu.
The Correct Probe Obstructions form provides the capability to correct Probe Obstruction data
that failed at least one table constraint validation and therefore could not be inserted into the
production tables. This form will display the erroneous probe obstruction data and any
associated errors for the currently selected data record.
Correct . lie Periods
To access the Correct Sample Periods form the user will click the Correct link in the Menu Bar,
this will open a drop down menu. Here the user will select Monitor Data from the menu then the
user will select Samp Period from the sub-menu.
The Correct Sample Periods form provides the capability to correct Sample Period data that
failed at least one table constraint validation and therefore could not be inserted into the
production tables. This form will display the erroneous sample period data and any associated
errors for the currently selected data record.
Correct Sample Schedules
To access the Correct Sample Schedules form the user will click the Correct link in the Menu Bar,
this will open a drop down menu. Here the user will select Monitor Data from the menu then the
user will select SAmp Schedule from the sub-menu.
The Correct Sample Schedules form provides the capability to correct Sample Schedule data that
failed at least one table constraint validation and therefore could not be inserted into the
production tables. This form will display the erroneous sample schedule data and any associated
errors for the currently selected data record.
52
-------
Correct Site
To access the Correct Sites form the user will click the Correct link in the Menu Bar, this will open
a drop down menu. Here the user will select Site Data from the menu then the user will select
Site from the sub-menu.
The Correct Sites form provides the capability to correct Site data that failed at least one table
constraint validation and therefore could not be inserted into the production tables. This form
will display the erroneous site data and any associated errors for the currently selected data
record.
Correct Open Paths
To access the Correct Open Paths form the user will click the Correct link in the Menu Bar, this
will open a drop down menu. Here the user will select Site Data from the menu then the user will
select Open Path from the sub-menu.
The Correct Open Paths form provides the capability to correct Site Open Path data that failed at
least one table constraint validation and therefore could not be inserted into the production
tables. This form will display the erroneous site open path data and any associated errors for the
currently selected data record.
Correct Site Tange id
To access the Correct Sites Tangent Roads form the user will click the Correct link in the Menu
Bar, this will open a drop down menu. Here the user will select Site Data from the menu then the
user will select Tangent Road from the sub-menu.
The Correct Sites Tangent Roads form provides the capability to correct Site data that failed at
least one table constraint validation and therefore could not be inserted into the production
tables. This form will display the erroneous site tangent road data and any associated errors for
the currently selected data record.
53
-------
Correct Raw Data
This section covers how to correct Raw Data.
Note] correcting other transaction types (with the exception of OA, which is described later) will work identically.
Procedure Overview
1. The user will select the correct form from the menu or sub-menu
2. The user will query the data requiring correcting from the AQS database
3. The user will edit the data
4. The user will save the data back to the AQS staging area
Open Correct Raw Data Form
To access the Raw Data Form the user will click the Correct link in the Menu Bar, this will open a
drop down menu. Flere the user will click the Raw link from the menu.
Main Menu
Site Data
~
Monitor Data
~
|Raw|
OA Transactions
~
Blanks
Composite
Delete by Screening Group
Majri Menu
54
-------
This will open the Raw Data Form.
[&JAQS
Action Help Session Admin Retrieval Maintenance Critical Rev CErtification Batch Correct Main Menu
El 91 i H % IIS ¦ « t < ~ * ~~ ± x -a & * ?
Correct - Raw Data (National Air Data Group)
State County Site Parameter
Code Code
Action Session
Date
Duration
Code
Reported Method
Code
Coll
Date
Coll Rpt Samp Null Data
Time Value
Code
POC Ind
Unit
Code
Delete All Selected
Error Code Error Message
Column Name
55
-------
Query Data
The user will query data from the database in to the form.
L=il AQS
Action Help Session Admin Retrieval Maintenance Critical Rev CErtification Batch correct Main Menu
Ha m ivfBii
« t < ~ 4 ^ p ^ ?
Correct - Raw Data (National Air Data Group)
The principle buttons used for query operations are:
(1) Enter Query (2) Execute Query (3) Cancel Query
Enter Query
When the form opens it defaults to query mode as evidenced by "Enter Query" in the status bar
at the bottom. It assumes the user wants to bring data from the AQS database into the form and
allows the user to query all data or limit the data by inputing specific parameters. If the user
would prefer to enter data manually then the user must click the cancel query button. However,
once the user has begun to enter data manually the query function is no longer available unless
the user clears the form.
The purpose of the Enter Query function is to bring data from the database into the form, edit it,
and save it back into the AQS database.
Entering values into anyfield will allow the user to narrow searches. For example, if the user
wanted only data for a specific state, the user would enter the corresponding a state code. If the
user wanted data for just one parameter in a specific state the user would enter the state code
and a parameter code.
A correct form will never bring back data not loaded by the user's screening group.
Once the user has entered query criteria the user will execute the query to bring the data from
AQS into the form.
56
-------
Execute Query
This button retrieves all of the user's screening group data, matching the query criteria, into the
Correct form. If no query criteria was entered all data from the screening group will be returned.
Note] all records in the staging tables the match the query criteria will be returned. In the old-style correct forms,
there is no way to retrieve only the data that was submitted in a specific file.
To retrieve all the queried data to the form the user will click the Last Record button, otherwise
the data is retrieved on screen/page at a time.
[Jd aqs
Action Help Session Admin Retrieval Maintenance Critical Rev CErtification Batch COrrect Main Menu
U a|J31 I & E31 SHJili H I ¦ I a 7 <
[2 Correct - Raw Data [National Air Data Group)
The status bar at the bottom left of the screen will display the number of records retrieved from
the database to the form.
A FIRS code that identifies one of the 50 states or other countries. - LOV
Record: 58360/58360
... List ofValu...
-------
Edit Data
Once the data is in the form changes can be made to it. There are two ways to do this.
Edit options
1. Type Over
Edit the data field by field (box by box) on the screen. The user will select text or place the
cursor where necessary and insert, delete, or replace text.
2. Global replace
Perform a "search and replace" in a single column. The user does this by placing the cursor in
the value to be replaced.
Action Help Session Admin Retrieval Maintenance Critical Rev CErtification Batch Correct Main Menu
< ~ * ~~ ± x. -a £1 ^ I ? 11
Correct - Raw Data (National Air Data Group)
County
Q29 '
D29 "
029 T
Site Parameter Qualifier
Id Code POC Five
0007 142601 » |T"
501
Qualifier Qualifier Qualifier Qualifier Qualifier
0007 42601
0007 42601
0007 42601
029 T ||0007 142601
029 * ]|0007 [42601
029 - ||0Q07 [42601
029 *
_ 0007 [42601
029 ' |l0007 |42601 '
029 ' |0007 142601 -
RFil
J
Six Seven Eight
_lT~
I
-if
"Ir _
:J=if
""dr
4 ,
—if
Nine
:zT
~dr
-j-
"jr
"jr
Ten
Eg
MDL
Unc
1 ¦
P
Then presses the Search and Replace icon.
[jfeJAQS
Action Help Session Admin Retrieval Maintenance Critical Rev CErtification Batch COrrect Main Menu
e a
m
1# M
s
a
%
& %
1
a t
i ~ 4 ~~
X- s
lP
?
3 Correct - Raw Data (National Air Data Group)
58
-------
This will bring up a window that will allow the user to replace every occurrence in that column
for all data retrieved by the query.
Note] this operation does not work like any other program; "Replace" and "Replace All" replace every value in that
column with the new value, not just the ones with the "Current Value".
Action Help Session Admin Retrieval Maintenance Critical Rev CErtification Batch Correct Main Menu
Ha m iiiiii ¦ « t i ~ i ~~ ± * -a :*] *> ^ I ? 11
| Correct - Raw Data (National Air Data Group)
County Site Parameter
Code Id Code
029 ^ |l0007 142501
029" " ||0007 [42601
029" "l|0007 |42601
029 J0007 14260
025 ~ 0007 42801
Qualifier
Qualifier
Six
Qualifier
Seven
Qualifier
Eight
Qualifier
Nine
Qualifier
029 - to007 |42601
029 - ||0007 |i2S0
029 - ||0007 142601 -
0007 |42601
0007 142©01
| Search and Replace
Replace Item |ra',\_CA~
Current Value [5
k.MDL
Column Name
New Value |
Replace All
Replace
Cancel
Search and Replace
Search and Replace allows the user to search within the specified column and replace specific
values with a new value or to replace all values in the column with a new value.
The Replace Item is automatically populated with the name of the column the user was on
before launching the Search and Replace. The Current Value field is automatically populated with
the value of the column the user was on prior to launching the search and replace.
59
-------
Save the Data
After the data has been edited it is still only in the form until it is saved. Clicking the save icon will
save the changes to the database.
Waqs
Actioi
0
n Help Session Admi
|s JE B i
n Retrieval Maintenance
[0 ^ ft %1 11
Critical Rev CErtification Batch correct Main Menu
44 t 4 ~ i » ^
l?l
Correct-Raw Data (National Air Data Group)
Other Correct Features
L=il AQS
Action Help Session Admin Retrieval Maintenance Critical Rev CErtification
B
44 7 4 ~ 4 ~~ l±, £ "S £]
Batch Correct Main Menu
f>\ ^ ?
| Correct - Raw Data (National Air Data Group)
CI—0 w
± x m
(1) Insert Record (2) Remove Record (3) Duplicate Record (4) Clear Record
Insert Record: Inserts a new blank record after the highlighted one.
Remove Record: Deletes the highlighted record.
Duplicate Record: Duplicates a record.
Clear Record: Deletes all of the contents of the fields, but not the record.
Note] when transactions are inserted, they are associated with an "on-line" session rather than a previously submitted
file. On the Batch form they will be in a file named "ONLINE_UUU_NNNN"; where "UUU" is the user's AQS user-id and
'NNNN' is a unique number.
60
-------
The Delete AN Selected button
Correct - Raw Data (National Air Data Group)
State County Site Parameter
Code Code
Action Session
Date
Duration
Code
Reported Method
Unit
Coll
Date
Coll
Time Value
RptSamp Null Data
Code
Code
POCInd
jrr_
ttl
Code
Delete All Selected
Column Name
Error Code Error Message
This button deletes all records that were returned by the query.
Note] this deletes all records that are listed in the display not just the selected records on the screen.
61
-------
Correct One-Point QC
This section covers how to correct 1-Point QC transactions. The procedure wiii be identical for
all other QA transactions.
Select the Correct / QA Transactions / One-Point QC menu pick.
Correct
Main Menu
Site Data
*?
A
Monitor Data
Raw
QA Transactions
1 One Point QC
Blanks
Composite
Annual Performance Evaluation
Semi Annual Flow Rate Audit
Delete by Screening Group
Flow Rate Verification
PM-Coarse Flow Rate Verification
PM Coarse Semi Flow Rate Audit
Main Menu
Performance Evaluation Program
_ NPAP
Field Proficiency Test
Duplicate
Replicate
c
Speciation Flow Rate Verification
Speciation Semi Annual Flow Rate Audit
Pb Analysis Audit
Lab Proficiency Test
Ozone SRP and Standard Transfer Verifications
- Ambient Air Protocol Gas Verification Program
ment Assessment Performin
Number Agency
r
i
i
62
-------
y i> I AQS
[Action Help Session Admin Audit Retrieval Maintain Critical Rev Certification Batch Correct Main Menu
B -A ¦ 5 & %|BIIII I*»l±$ISB8§lSl:I
s GENERIC CORRECT FORM (National Air Data Group)
Select file to view errors:
Submission
Load OA Data
s_Count
|1-Point QC
~ z\
"_J
: -
¦
State Code/ County Tribal Site Parameter Poc Assessment Assessment Performing
Tribe Ind Code Code Number Code Date Number Agency
¦
m
«F
Monitor
Method
Monitor
Cone.
Assessment
Cone.
-
ow ERRORS
Frrnr rj;
-pH,
1. The User will select the file with errors to be corrected
2. Error Messages for the selected transactions will show up in the Row Errors section
3. Then click the "Load OA Data" button
4. Edit the data retrieved (and/or insert new records)
5. Click the Save icon
Correct Composite Data
The Correct Composite Data form, found under the Correct section on the Menu Bar, will display
the erroneous composite data and any associated errors for the currently selected data record.
This form allows the user to correct information about the concentrations of various air
pollutants measured by air monitoring equipment for multiple samples that are combined and
analyzed as a single sample that failed at least one table constraint validation and therefore
could not be inserted into the production tables. This form allows the user to query and correct
63
-------
any data associated with the user's screening group. Data may be inserted, updated, or deleted
on this form.
Correct Highlights
• Only data that has not yet been loaded into AQS (the staging tables).
• The user can only see data in the user's respective screening group.
• All changes must be saved (including deletes).
Submittii rected Data
After the user has made the changes and saved them using the correct forms the data will need
to be loaded into AQS. In order to do this the user will:
1. Go back to the Batch form.
2. Highlight the records associated with the file whose data was being corrected.
3. Press the Load File or Post File buttons, depending on what processes needs to be ran.
The process status and the Load and Post record counts will update just as for any other batch
process.
64
-------
¦Mi I n I- ¦ I ¦ - i j I > • >1 - Maintain
Maintain Overview
Maintain allows the user to:
1. Enter new data into the database (without having to go through the batch load process)
2. Edit data in the database (i.e. Insert, Update, or Delete)
Correct and Maintain are very similar in operation - they are a series of forms that allow you to
edit data.
There are also a few important differences between Correct and Maintain:
Correct
Operates on data not yet loaded into AQS
Forms mirror the structure of the text
transactions
Generally one row for each transaction
Data not checked for errors until it is Loaded
User can only see data in respective screening
group
Maintain
Operates directly on the AQS database
Forms mirror the structure of the AQS
database
Forms are laid out to be easier to read and
contain more data
Data checked for errors when it is saved
If logged in as read only, the user can see any
production status data
Maintain is useful for the following tasks:
1. Creating site and monitor records.
1. Lists-of-values make it unnecessary to know codes
2. Site form has Check Completeness and Create Monitor buttons
3. Monitor form has Check Completeness and Duplicate monitor buttons
4. Each "subordinate" record is displayed as a separate tab
5. The user can close monitor by entering a close date and saving the record - all
subordinate records will automatically be populated with end dates.
65
-------
2. Entering small amounts of data into AQS.
1. Data you would rather type than create a transaction and use the load process for
2. Data that you don't have transactions for
3. Entering data for which there are not transactions defined
1. E.g. Events
66
-------
Maintain Site
^1 Maintain Site (National Air Data Group)
_ n x
j Basic Site Data j
Additional Site Data
Agency Roles Tangent Roads
Open Paths
Comments
Primary Monitor Periods
Site Identification
State Code Iq*|
County Code [055 J |Etowah
Site Id [
0003
Status Ind
r
User Coordinates
Horizontal Datum |NA.D27 Latituiie |j4.011111
UTM Zone [16
Standard Coordinates: Datum |
Horizontal Method jo27 _J |Unknown
Horizontal Accuracy CT
[Meters) 1
UTM Easting 1587031
Latitude
Longitude (-36.0575
UTM Northing 3763590
Lookup Geography
P
Longitude
Source Map Scale (Non-GPS) fo~
Vertical Measure 117%
(Meters; l"':,
Vertical Method |ooo
Jf UNKNOWN
Vertical Accuracy [n-
(Meters) 'u
Vertical Datum (UNKNOWN
Street Address |WALNUT PARK FIRE STATION
Land Use Type |INDUSTRIAL
City Code |28696
Urban Area Code fiiso | |gADSDEN, AL
[Gadsden
~ Location Setting |URBAN AND CENTER CITY __J
AQCR Code |003
(YYYYMMDD)
Owning Agency |q01 3
10 0 3
J | EAST ALABAMA
119720101
Time Zone Name |CENTRAL
fii
J 0 013
J |aI Dept Of Env Mgt | || ]
Check Completeness
Create Monitor
P
The Maintain Site form is used to enter or edit all data relating to a site. This includes data from
the site basic transaction and all of the site subordinate transactions.
(1) On this form, data from each transaction type is included under a separate tab.
(2) Lookup Geography button allows the geographic coordinates in either latitude and
longitude or UTM (Universal Transverse Mercator) to be entered. When this button is
clicked, the EPA standard coordinates (lat/lon in the NAD83 datum) are calculated and
populated. Also, much of the other geographic data is populated (city, zip, etc.)
(3) The Check Completeness button can help the user determine if AQS thinks that data
needed to make a site "complete" is present. This is a convenience to help the user keep
track of what to do next, but does not have to be used.
(4) Once the user has completely entered (and saved) site data, the user may create a
monitor with as much data as possible pre populated in the Maintain Monitor form by
clicking the Create Monitor button.
67
-------
Maintain Monitor
I Maintain - Monitors (National Air Data Group)
-!~! *1
Project Class
Meas Scale
Probe Location
Probe Vert Dist
Samp Res Time
Close Date
State
Code
m
County
Code
POC
F
Dominant Source |
Open Path Num
Probe Height [5
Surrogate Ind
Last Samp Date |19S81001
Monitoring Agency (Owner)
9
Probe Hor Dist
Unrest Air Flow
Last Post Date
T |[u^P^Iational Exposure Researct
Monitor Basic
Sample Periods
Type Assign.
Network Affiliations
Agency Roles
Objectives
Req Frequencies
OA Collocation
Methods
Exc usions
Pollutant Area
Tangent Road
Probe Obs
Reg Compliances
Protocols
Check Completeness
Duplicate Monitor
Channe s
Comments
This is found under the Maintain section on the Menu Bar then select Monitor. It provides the
ability to directly view all monitor data in the database when the user has selected (or defaulted
to) the Read Only Screening Group Monitor information is maintained in the database to
describe the pollutants measured at the Air Quality Monitoring Station.
The term "monitor" may be misunderstood. In AQS the term does not refer to a device but to
the pollutant measured by a device.
The Maintain Monitor form is also used to enter or edit all data relating to a monitor. Data
security rules are enforced so that only the owner of the data has modify access to their data.
This includes data from the monitor basic transaction and all of the site subordinate
transactions.
(1) On this form, data from each transaction type is included under a separate tab.
(2) The Check Completeness button can help the user determine if AQS thinks that data
needed to make a monitor "complete" is present. This can be more convenient than
attempting to save the record and getting a series of errors.
(3) Once the user has completely entered (and saved) data for a monitor the user may
create a duplicate of that monitor with as much data as possible pre-populated in the
Maintain Monitor form by clicking the Duplicate Monitor button. This is convenient for
creating a collocated monitor, or series of speciation monitors, etc.
68
-------
Entering New Monitor Data
To create a new monitor record in the database the user will need to edit query mode before
entering data in the various fields. This is done one of in three ways:
will put the user in data input mode.
will give the user a blank form to enter data. This is often used when monitor
records have already been selected.
will make a copy of the monitor currently displayed in the form. The
user will be prompted to enter a new Parameter or POC. Most of the values of the monitor data
visible when clicked on the Duplicate Monitor button will be copied to the new monitor record.
To maintain the Agency Roles, Sampling Periods, Objectives, Monitor Types, Tangent Roads,
Probe Obstructions, Regulation Compliance, Required Collection Frequency, Collocation, or
Comments data associated with the selected Monitor record, the user will select the
corresponding tab.
Agency Roles
This is found under the Maintain section on the Menu Bar then select Monitor then the Agency
Roles tab. All agency roles now require begin dates. Legacy data only required begin dates for
REPORTING roles. Modification of any legacy monitor data will force the setting of begin dates
for all roles before a save will be executed.
The Monitor Agency Roles tab allows the user to insert or update production Agency Role data
associated with the Monitor record that the user selected in the Monitor Basic tab. All existing
Agency Role records are displayed when the tab is opened. The user can insert or update
Agency Role data in this module. However, Agency Role data is deleted through batch submittal.
69
-------
Maintain Event
3 Maintain Exceptional Events (National Air Data Group)
Define Event Associate Raw Data with Event
Screen Grp Name|National Air Data Group
Qualifier Code Qualifier Description
I U I
Event Begin Date
Event End Date
Event
Description
Comment
Exceptional events do not have a transaction type in AQS. Therefore the Maintain Event form
must be used to enter and update event information that will be used to apply for exclusions.
70
-------
Maintain Raw Data
|g Maintain - Raw Data (National Air Data Group}
Raw Data Comments
State County Site Parameter POC Begin Date: End Date:
i—r i—— i
Standard Units
Raw Data
Mp ID Date
Stat Reported Standard EPA Action Exclusion Null
Time Ind Sample Value Sample Value Ind Ind Ind Data Code Description
r
n
i
r
i
i
r r
•r
i
r
r
1
i
i
i 1
i
r
r
i
i
i i
i
i
i
i
i i
i
i
i
i
i i
i
i
r
I
i
r r
i
r
i
i
I
i
i
i i
i
i
i
i i
r
i
i i
Jj
_
i
11
l
i i
r r
Uncertainty
Value
Qualifier Code Qualifier Desc
I
£
Qualifier Type
Monitor
Protocol
Method Unit Duration Coll Frequency Alt Mdl
Event Description
Association Date I
"J
Event Comment
Event URL
Select Sample Values from the Maintain menu item then select Raw Data from the Select Sample
Values sub-menu item. This is very similar to the Correct Raw Data screen except that instead of
an area for displaying errors there is an additional area for qualifier, protocol, and event
information.
71
-------
Maintain Precision
^Maintain Precision Data (National Air Data Group)
r
i
i
Ml
1
Ml
1
HI
~
_l 1
1
1
Precision Date
Precision a
Precision Sample kJ
Precision Data Tvoe
Indicated Method Indicated Unit Indicated Duration Indicated Value
Ui—
Actual Method Actual Unit Actual Duration Actual Value
_ll JI
The user will likely use this form to enter or edit QA data.
72
-------
Maintain Accuracy
] Maintain Accuracy Data (National Air Data Group)
Begin Date End Date
Accuracy Data
State County Site Parameter POC
r^j i i—_d i—j i—_j
Audit Type Auc Audit Class Acc Date Year
_J I I"
"J
Local Pri Std
Qtr Accuracy Type
r i j
Audit Sample Id Expiration Date Audit Scheduled Zero Span Value
"J I I I I
Monitor Protocol
Method
Unit
Duration
Jd r
'm r
¦
Accuracy Audits
Audit id
Previous jUI— JJ Next
Level Number
Actual Value Indicated Value
The user will likely use this form to enter or edit QA data.
Maintain Comments
Comments are associated with Sites, Monitors, Raw Data qualifiers (they are attached to the
qualifier code, not the raw data value itself) and Composite Data qualifiers. The Maintain
Comments screen (or tab, depending on the form) allows you to insert or update Comments
associated with the record that you selected. All existing Comment records are displayed when
the screen is opened.
73
-------
(gti
Action Help Session Adn^H^Bt Re'
B a I m I E
^Maintain Site (National Air Data Group)
ic Site Data j Additional Site Data Agency Roles Tangent Roads
aintain Critical Rev Certification Batch correct Main Menu
Open Paths
Comments Primary Monitor Periods
Site Identification
State Code (37 | |North Carolina
County Code |o01 _||a1 amance
Site Id |o001
Status Ind
IT
User Coordinates
To display a specific Comment or group of Comment records associated with the current record
(1) the user will press the Enter Query key then, (2) enter the criteria. (3) After the necessary
criteria is entered the user will click the Execute Query key. This allows the specific Comment
records to be displayed.
The user will then click the Comments tab, opening up the Comments Form Area.
^Maintain Site (National Air Data Group)
¦Jnixi
Basic Site Data | Additional Site Data ] Agency Roles | Tangent Roads | Open Paths
Comments
I Primary Monitor Periods |
Site 37 |D01 |o001
Sequence Num Comment
The user may use the Up arrow and Down arrow buttons to scroll through the records which
have been queried. Comment data can be inserted, updated, or deleted in this module.
This component consists of the following fields:
Sequence Num
Sequence Number identifier for multi-row comments.
Comment
Free text for ad-hoc comments.
74
-------
Maintain Site
This section describes how to use the maintain forms to create a new site in AQS.
How to use Maintain
The procedure for using Maintain is the same as for Correct.
1. The user will open the maintain form
2. Query the data to edit from the AQS database into the form
3. Edit the data
4. Save the data back to the AQS database
To enter new data (rather than query old data) the user will click the Cancel Query icon and
begin entering new data.
bfeJAQS
Action Help Session Admin Retrieval [Maintenance] Critical Rev Certification Batch Correct Main Menu
To access a maintain form the user will click the Maintain link in the Menu Bar, this will open a
drop down menu. Here the user will select the particular form from the menu or sub-menu.
I Critical Rev
Site
Monitor
Event
SamPle Values ~
Blanks
Concurrence Ind
Sile Sampler
QAAssessments ~
Monitoring Seasons
Main Menu
Under Sample Values:
• Raw Data
• Composite Data
• Delete Production Data
Under QA Assessments:
• 1-PointQC
• Field Proficiency Tests
75
-------
• Flow Rate Verification
• PEP
• Semi Annual Flow Rate Audit
• Annual Performance Evaluation
• NPAP Assessment
• Duplicate Assessment
• Replicate Assessment
• PMc Flow Rate Verification
• PMc Semi Flow Rate Audit
• Speciation Flow Rate Verification
• Speciation Semi Annual Flow Rate Audit
• Lead Analysis Audit
• Lab Proficiency Test
• AA-PGVP Assessment
• Ozone SRP Assessment
• Audits of Data Quality
• Technical Systems Audits
• QA Project Plans
• Quality Management Plans
Enter Site Basic Info
To access the Site form the user will click the Maintain link in the Menu Bar, this will open a drop
down menu. Flere the user will select Site from the drop down menu.
|J?J AQS
Action Help Session Admin Retrieval
B
m xa ¦ %
[3 AQS (National Air Data Group)
Maintain
Critical Rev
|Site |
Monitor
Event
SamPle Values
Blanks
Concurrence Ind
Sile Sampler
OA Assessments
Monitoring Seasons
Main Menu
To create a new Site the user will first click the Cancel Query icon.
76
-------
Action Help Session Admin Retrieval Maintenance Critical Rev CErtification Batch correct Main Menu
b a je £ k a 01 m apU] aim* < ~ 4 ~~ I ± * a ii & ^.
?
^Maintain Site (National Air Data Group)
- ^xj|
Basic Site Data
Additional Site Data |
Agency Roles | langent Roads | Open Paths | Comments | Primary Monitor Periods
1
The user then needs to fill in all of the required fields. Required fields are indicated by the
holding of the field name.
Note] on this form, there are very few non-bolded fields.
^ Maintain Site (Re3d Only. Update/Insert not allowed.)
- ~! *J
Basic Site Data
Additional Site Data | Agency Roles
Tangent Roads ] Open Paths
Comments
Primary Monitor Periods |
Site Identification
State Code ([
County Code
_ir
Site Id f
Status Ind
r
User Coordinates
Horizontal Datum
UTM Zone
J
Latitude
UTM Eastingf
Longitude
UTM Northing
Lookup Geography
Standard Coordinates: Datum
Latitude
Longitude
Horizontal Method
Horizontal Accuracy
(Meters)
Vertical Measure
(Meters^
(Meters)
Vertical P.lethod
jr
Source Map Scale (Non-GPS)
Vertical Accuracy
(Meters)
Vertical Datum
_l
Street Address
Land Use Type
City Code |~
Urban Area Code |
AQCR Code [
_|l
Location Setting
"_l
Site Established Date
(YYYYMMDD)
Owning Agency
1 JIU1
i
r
Time Zone Name
3-j
r
~
li
Check Completeness
Create Monitor
Once all of the required fields are populated the user should click the Save icon.
Action Help Session Admin Retrieval Maintenance Critical Rev CErtification Batch correct Main Menu
fBja n ^ %: i a % a %ii i m j < ~ * ~~ i ± ^ m 3a & ^
?
^Maintain Site (National Air Data Group)
- D x
Basic Site Data
Additional Site Data
Agency Roles | i angent Roads | Open Paths | Comments | Primary Monitor Periods
The status bar (at the bottom left of the screen) should indicate that a record has been applied
and saved.
77
-------
At this point the site is still incomplete as additional information is required, such as Supporting
Agency Role and at least one Monitor record.
Status Indicators
On the Basic Site Data tab the Status Ind(icator) field will show a value of "F".
Maintain Site (National Air Data Group)
_|n
*l
; Basic Site Data; 1 Additional Site Data | Agency Roles | Tangent Roads Open Paths
Comments | Primary Monitor Periods |
Site Identification
State Code |oi | |Alabama
County Code |ooi |Autauga
Site Id 11001
Status Irid |f
Status Indicators are very important in AQS. Every time data is put into AQS the system performs
a variety of checks on that data:
1. Is each value a valid value (within acceptable ranges)?
2. Is the format correct (e.g., number versus text)?
3. Are mandatory fields present?
4. Is prerequisite data present (e.g., a monitor must exist before raw data can be loaded)?
5. Is co-requisite data present (e.g., a site must have a Supporting Agency Role, a raw data
value must have a Sample Begin Time)?
6. Did raw data undergo the Statistical and Critical Review checks?
Depending on the answers to these questions, (almost) all incoming data is assigned a Status
Indicator. This value may change as the data progresses through software checks.
78
-------
Status Indicators and their meanings:
Status Indicator
Status
Meaning
F
Fields Valid
The individual data elements (fields) are valid (ranges,
formats, etc.).
R
Relationally
Valid
Prerequisite and co-requisite data is present and
complete.
S
Stats Checked
This data has been through the Statistical and Critical
Review process.
1
Inactive
This data is no longer relevant. We inactivate some
data rather than delete it to keep audit trails.
P
Production
This data is has successfully been submitted to AQS.
The reporting requirement has been met. This data is
available to anyone.
Enter an Agency Role
The user will click the Agency Roles tab. This will open up the Agency Roles form. The user will
populate the Agency Role, Agency Code, and Begin Date fields. Once this is complete the user
should click the save icon and verify that the save was successful on the status bar.
Agency Role
Agency Code
Agency Desc
Begin Date End Date
.A.
SUPPORTING
|1108
US EPA^OAQPS
¦I2CC1IMC1H
1 1
I
¦ 1 I II
79
-------
Create a Monitor
To create a monitor the user will click the Create Monitor button at the bottom of the Basic Site
Data tab from the Maintain Site form or access the Maintain Monitor from the Maintenance
menu.
^Maintain Site (National Air Data Group)
-|ngj
i Basic Site Data
Additional Site Data ] Agency Roles
Tangent Roads
Open Paths ] Comments
Primary Monitor Periods
Site Identification
State Code J01 |Alabama
County Code |ool | |Autauga
Site Id 11 o01
Status Ind
F
User Coordinates
Horizontal Datum |NAD27
UTM Zone
Latitude 132.5367
UTM Easting [
Longitude]-S6.6483
UTM Northing
Lookup Geography
Standard Coordinates: Datum |naD83
Horizontal Method
Latitude
32.536372
Longitude | -SS.6482S5
Horizontal Accuracy
(Meters)
Vertical Measure
(Meters)
Vertical Method
Street Address
Land Use Type
City Code
Urban Area Code
AQCR Code
Site Established Date
(YYYYMMDD)
Owning Agency
103
B
50
GPS
Source Map Scale (Non-GPS)
50
008
j |OTHER
Vertical Accuracy kn
(Meters) 1
Vertical Datum |MEAH SEA-L _
339 Love Ln
COMMERCIAL
B
Location Setting RURAL
_ir
002
"J |COLUMBUS-PHENIX CfTY
20010101
Time Zone flame (CENTRAL
_l
1103
J
USEPA/OAQPS
Check Completeness
Create Monitor
80
-------
Once this button is clicked either of these will cause AQS to open the Monitor Basic tab of the
Maintain Monitors form.
[2 Maintain - Monitors (National Air Data Group)
State
Code
I5TJ
County
Code
Parameter
Code
Monitor Basic
Project Class
Meas Scale |
Probe Location f
Probe Vert Dist |~~
Samp Res Time |~~
'¦i
Close Date |~
Dominant Source
Open Path Num
Probe Height [
Surrogate Ind
Last Samp Date
Monitoring Agency (Owner)
F"_J
3
Probe Hor Dist
Check Completeness Duplicate Monitor
Sample Periods
Type Assign.
Network Affiliations
Agency Roles
Objectives
Req Frequencies
OA Collocation
Methods
Exclusions
Pollutant Area
Tangent Road
Probe Obs.
Reg Compliances
Protocols
Channels
Comments
Once all mandatory data is entered in this tab (by adding Parameter Code and POC (Parameter
Occurrence Code)) then remainder of the tabs become available for editing (go from grayed out
to selectable).
Note] on this form, the Save icon is grayed out (not selectable) until you enter all mandatory fields.
Note] that the Check Completeness button stays grayed out even though the required Monitor Basic information is
populated. To activate the Check Completeness button the user must navigate away from the Monitor Basic tab and
back to it.
To complete data entry for the monitor the user can either click on each of the tabs and fill in
the required fields (indicated with bold field names) or click the Check Completeness button for
a to-do list. Once all required fields are populated the user should click the Save icon.
The following are a brief description of each of the tabs on the form:
Sample Periods: Sample periods are the time periods (date ranges) of operation of a monitor.
(Required for all monitors)
Type Assign: The Type Assignments is the administrative classification of the monitor. (Required
for all monitors) Possible values are:
SLAMS:
SPM:
State and Local Air Monitoring Station: Regulatory monitor operated by a
state or local agency.
Special Purpose Monitor: A monitor for a regulated parameter but that is
not used for meeting the minimal requirements of Part 58.
TRIBAL:
Regulatory monitor operated by a recognized Native American tribe.
81
-------
INDUSTRIAL: Monitor operated by an industrial organization (rather than a
governmental organization)
EPA: Monitor operated by the EPA itself.
NON-EPA FEDERAL: Monitor operated by another Federal Agency.
OTFIER: Monitor for a pollutant/parameter not required by Part 58. (i.e. not
addressed by the Clean Air Act)
Network Affiliations: Optional. Network program under which the monitor is operated, e.g.
NCORE or PAMS.
Agency Roles: The real-world organizations/agencies with specific responsibilities for a monitor.
(Required for all monitors) Possible values are as follows:
• PQAO: Primary Quality Assurance Organization - Agency responsible for QA of the
monitoring process at the monitor. Required
• Reporting: Agency responsible for submitting the sample measurements for the
monitor to AQS. Required
• Collecting: Agency that collects samples from the monitor (if different from the
above) Optional
• Analyzing: Agency that analyzes samples from the monitor (if different from the
above) Optional
• Certifying: Agency responsible for sending an annual letter to the EPA that the data
submitted to AQS for the monitor is complete and correct. Required for monitors
required by Part 58.
• Audit: Agency responsible for submitting Quality Assurance audits to AQS.
Objectives: The purpose for measuring air quality data by the monitor. (Required for monitors
defined in Part 58)
Req Frequencies: For manual method monitors (e.g. filter based monitors), how often the
monitor collects samples. Required for all manual method monitors.
QA Collocation: If the monitor is paired with another monitor for Quality Assurance (as defined in
Part 58 Appendix A), this provides the date range and defines whether the
monitor is the primary monitor or the QA monitor. Optional.
Methods: This defines the sampling and analysis method used to analyze monitor data.
Required.
Exclusions: Used to indicate that the monitor is excluded from Design Value calculations.
Optional
Pollutant Area: Used to indicate the administrative area (e.g. Monitor Planning Area) associated
with the monitor. Optional
82
-------
Tangent Road: Used to indicate the distance to roads that are adjacent to the monitoring site.
Optional
Probe Obs: Used to indicate that there is an external object that obstructs the free flow of air to
the monitor. Optional
Reg. Compliance: Used to indicate the date when the monitor met the requirements of each of
the appendices of Part 58. Optional
Protocols: Informational Only. Used to indicate if there is an alternate method detection limit
for the method used by the monitor. Optional
Channels: For monitors associated with speciation analysis (i.e. analysis of the chemicals on a
filter), this indicates which sampler and channel on the sampler is used by the
monitor. Optional
Comments: Free form test. Optional
Maintain Blanks
The user will find this under the Maintain section on the Menu Bar. The Maintain Blanks form
displays all blanks data for the Screening Group. Unlike similar forms in the AQS application the
top block in the form that is used for selection does not control the display area below once the
select has been done. All blanks data for all monitors selected is displayed.
Blank data is the record of the pre-use value for filters or other similar components used in
monitors. The "tare" value is another term that is used to describe this value.
Protocol information describes the method, unit, and duration used to determine the blank
value. This does not have to be the same as the protocol used by the monitor to report pollutant
values.
83
-------
Add Site Samplers
To access the Site Samplers form the user will click the Maintain link in the Menu Bar, this will
open a drop down menu. Here the user will select Site Samper from the drop down menu.
i=y aqs
Action Help Session Admin Retrieval
Critical Rev C
~ a 1 m I e n b I %
Site
Monitor
Event
SamPle Values ~
Blanks
Concurrence Ind
jSAQS (National Air Data Group)
SiTe Samplerl
OA Assessments ~
Monitoring Seasons
Majn Menu
To create a new Site Sampler the user will first click the Cancel Query icon.
Action Help Session Admin Retrieval Maintenance Critical Rev CErtification Batch correct Main Menu
qs jr ii m &PHI ¦ « T < ?
84
-------
The user then needs to fill in all of the required fields. Required fields are indicated by the
holding of the field name.
^Maintain Site Samplers (National Air Data Group)
Site Sampler
Sampler Owner Agency i—jr
State Code
County Code
3jr
Sampler Id
-IU
Begin Date
End Date |~
Number of Channels |~
Site Number
Manufacturer |~
Model Number |~
Serial Number |~
Channel
Number Filter Type
Target
Flow Rate
Flow
Unit
Begin End
Date Date
-
J
1
1
1
1
1
¦
1
J
1
J
1
I
_r
r
I
~
j
1
Once all of the required fields are populated the user should click the Save icon.
Action Help Session Admin Retrieval Maintenance Critical Rev Certification Batch correct Main Menu
fals je jeg ^ a % m « * < ~ * ~~ ^ ^ ?
The status bar (at the bottom left of the screen) should indicate that a record has been applied
and saved.
Tangent Roads
This is found under the Maintain section on the Menu Bar then select Site then the Tangent
Roads tab. The Maintain Site Tangent Roads tab allows the user to insert or update production
tangent road data associated with the Site record that was selected in the Maintain Basic Site
Data window. All existing Tangent Road records are displayed when the window is opened. To
display a specific tangent road or group of tangent roads associated with the current site, the
user should click the Enter Query icon and enter the criteria. Clicking the Execute Query icon will
display the selected Tangent Road records. The user should use the Previous Record (Left Arrow)
85
-------
icon and the Next Record (Down arrow) icon to scroll through the records that have been
queried. Tangent Road data can be inserted or updated in this module. Tangent Road data is
deleted through batch submittal.
Open Paths
This is found under the Maintain section on the Menu Bar then select Site then the Open Paths
tab. The Maintain Site Open Paths tab allows the user to insert or update production open path
data associated with the Site record that has been selected in the Maintain Basic Site Data
window. All existing Open Path records are displayed when the window is opened. To display a
specific open path or group of open path records associated with the current site the user
should click press the Enter Query icon and enter the selection criteria. Clicking the Execute
Query icon will display the specific Open Path records. The user should use the Previous Record
(Left Arrow) icon and the Next Record (Down arrow) icon to scroll through the records that have
been queried. Open Path data can be inserted or updated in this module. Open Path data is
deleted through batch submittal.
Adding Events via Maintain
Maintain Event
This section will describe how to use the maintain forms to create a new exceptional event and
associate it with raw data. This section of the document is separate from the Maintain section
because it is a special case - there are currently no AQS transactions for events, so the only way
to enter this data is via the maintain forms.
Exceptional Event Rule
The Exceptional Event Rule (EER) was published March 22, 2007 and became effective May 21,
2007. The EER allows the ambient air quality data which is submitted to AQS and used in making
regulatory decisions, to be, in some cases, flagged and, where appropriate, excluded from
calculations in determining whether or not an area has attained the standard. The data flagged
as "exceptional" must have been affected by an exceptional event, which is defined as an event
that affects air quality, is not reasonably controllable or preventable, is an event caused by
human activity that is unlikely to recur at a particular location or a natural event, and is
determined by the EPA in accordance with 40CFR 50.14 to be an exceptional event.
86
-------
Event Process Workflow
This section outlines exceptional event related steps occur and in what order. Not all of these
steps involve AQS. Steps that are performed within AQS are in italics. How to use AQS to perform
these functions is covered next.
1. Event happens. The real-world exceptional event occurs.
2. Event affects data. Ambient air quality is affected by the exceptional event and measured
by monitor reporting to AQS.
3. Should data be excluded? Reporting agency investigates and determines that there is
cause to suspect exceptional event influence on the sample measurement(s)
4. Data is flagged. Reporting agency adds a Request Exclusion qualifier to the affected
sample measurements in AQS to flag the data in AQS as suspected of being influenced by
the exceptional event (note: the flagging of data can occur either before or after the data
is submitted to AQS; reporting agency has until July 1st of the year following the year in
which the flagged measurement occurred to add an exceptional event qualifier flag)
5. Event is defined. Reporting agency enters the initial Event description; AQS responds by
creating the event record (note: reporting agency has until July 1st of the year following
the year in which the flagged measurement occurred to add an initial description of the
exceptional event)
6. Associate data with event. Reporting agency accesses AQS to associate the appropriate
flagged values with the Event (AQS saves date of association;
7. Justify exclusion request. Reporting agency can take up to 3 years from the time of the
event to conduct analysis, hold public review, prepare justification documentation and
submit documentation to the EPA. For appropriate flagged measurements, the reporting
agency develops documentation that the exceedance was caused by the exceptional
event.
1. A clear causal relationship exists between the event and the measurement;
2. The measurement is in excess of normal historical fluctuations, including
background;
3. There would not have been an exceedance or violation if the event had not
occurred;
4. The required public comment process has been followed;
5. The documentation package includes references to specific exceedances of a
specific NAAQS.
8. Submit package. Reporting agency submits (via hardcopy or electronic means) the
required justification documentation for affected measurements to their EPA Regional
Office
9. Regional Review. EPA Regional Administrator reviews documentation with respect to:
87
-------
1. Validity of event occurrence;
2. Causal relationship to the monitoring data (exceedances) under consideration
10. EPA Concurrence Indicator Updated. Regional administrator accesses AQS to Concur or
Deny with the exclusion request, with respect to the specific NAAQS
11. Exclude Data. AQS re-computes affected summaries.
Fll with Event Qualifiers
Sample values (raw data) can be flagged using either the Batch process or Maintain forms.
EDT ID
An identification code indicating the Exceptional Data Type or Event Qualifier Code type for a
raw or composite data point. "Concurrence" is a flag set by the EPA Region indicating agreement
with the Exceptional Data qualifier. EDTs are represented with a numeric value.
Event Qualifiers
The qualifiers are currently broken into 4 different types:
1. Quality Assurance
QA qualifiers are indicators of data validation. The "V" qualifier to indicate validated data
is used on all parameters. The other QA qualifiers are normally only used for PM2.5.
These qualifiers are used to indicate that while the indicated QA procedure may have
cast doubts on the validity of the data, upon review it is considered valid. Raw data
records for invalid data are entered with no data value. Such null data entries should be
qualified with a null value code (see below).
2. Exceptional Events
"An exceptional event is defined as an event that is not expected to recur routinely at a
given location, or that is possibly uncontrollable or unrealistic to control through the SIP
process... What is exceptional in one area of the country may not be exceptional in
another." (EPA Guideline on the Identification and Use of Air Quality Data Affected by
Exceptional Events, OAQPS, EPA-450/4-86-007, July 1986)
In the AQS systems, exceptional events are considered to be "anthropogenic". All other
causes are considered to be "Natural events" described below. AQS makes no finer
distinction between intentional and unintentional exceptional events other than to
describe the event itself.
88
-------
3. Natural Events
Natural events that can influence raw data values include Metrological events such as
high winds, inversions, intrusions or drought. Geological events such as volcanoes are
included along with some seasonal events such as Forest fires and High pollen count.
Note that "Prescribed burning" is an Intentional Anthropogenic Event while "Forest
fires" are considered Natural Events.
4. Null Data Values
Null Data Values explain the cause of null values that occur for reasons other than
levels being below a device's minimum detection limit. These include power failures,
equipment damage and human error. Note that there is a difference between NULL
and ZERO in the database. Zero is a reported value indicating undetectable pollutant
levels for the device. Null indicates a missing, invalid or unknown value.
5. Comments
Comments can be attached to any Qualifier code to further describe an event, if
necessary. This ability to attach comments applies to all qualifiers.
Note] for further guidance refer to:
• 40 CFR, part 50, Appendix K
• Section 188(f) of the 1990 Clean Air Act Amendments which modify some of the Appendix K based guidelines
of 1986.
• MEMORANDUM: Areas Affected by PM-10 Natural Events, FROM: Mary Nichols, Assistant Administrator for
Air and Radiation. This memorandum clarifies apparent conflicts between Appendix K, the Exceptional Events
Guideline from 1986 and Section 188(f)
Flagging Values via Batch Data
6. Create transactions that have Request Exclusion Qualifiers (see the Data Coding Manual
for details) appropriate to the event type.
1. The transactions can be Insert transactions for new data or Update or Replace
transactions for data already in AQS.
7. Load this data using the Batch process.
89
-------
Flagging Values via Maintain
1. The reporting agency user determines that a specific sample measurement (or small
of measurements) is affected by an exceptional event.
2. The user decides whether to flag the sample measurement with the Informational
Qualifier ("INFORM") or the Request Exclusion Qualifier ("REQEXC") for the event.
3. The user queries the measurement. In AQS, Maintain -> Sample Values -> Raw Data
Critical Rev
CErtifi cation Batch COrrt
Site
4 ~ i ~~ | JL :
Monitor
Event
SamPle Values
E|
Raw Data!
Blanks
L
Composite Data
Concurrence Ind
Delete Preproduction Data
Sile Sampler
OA Assessments
~
^ •
Monitoring Seasons
-------
4. The user will then use the Query tool to select the sample measurement to which the
user wants to add (or modify) the qualifier code. (State, County, Site, Parameter and/or
Begin and End Dates. Then Execute Query)
|§ Maintain - Raw Data (National Air Data Group!
Raw Data
Comments
County
Eito Parnmotor TOG gogin Dn
End Dntoi
US' 1063 19999 188101 m
M
Standard Units
fiiT
Raw Data
Stat Reported
Standard
EPA ActionExclusion Null
Uncertainty
Mp ID
Date Time
Ind Sample Value
Sample Value
Ind Ind
nd Data Code
Description
Value
A.
1
B
120140220 00:00
|P |2
\2
1 1
~ I
1
1
r
h
-
|20140214 00:00
|P |3
|i
rr
~
r r
-
r
r
h
. it-
|20140208 00:00
|p h
h
r i
-l
r r
-
r
i
I I
r
i i
r r
i
i
I I
i
i i
r r
i
i 1
I I
i
rr
Hi
r
i
I I
i
i i
r r
i
I I
i
rr
r r
r
1
I I
i
i i
r r
1
1
~
I I
i
rr
r r
!¦
i
£
~r
Qualifier Type
V
Monitor
Protocol
Method Unit Duration Coll Frequency Alt Mdl
n
T
Event Description
I
Event Comment
Association Date I
m
Event URL
91
-------
5. The user wiii then add an exceptional event qualifier to the raw data record.
The user will select the record to add the exceptional event to by clicking the record field,
the respective record should now be highlighted.
^Maintain - Raw Data (National Air Data Group)
Raw Data | Comments |
State County Site Pa
rameter POC
5101 ' 1
Begin Date: End Date: Standard Units
137 1063 jJ |999-9 |S
1
¦
|1GS
Raw Data
Mp ID Date Time
Stat Reported
Ind Sample Value
Standard EPA Action Exclusion Null
Sample Value Ind Ind ind Data Code
Description
Uncertainty
Value
-
1
- 1120140220 00:00
|p |2
12
|
=
r
H
r
|i
|20140214|00:00
IS |3
I
H
T2TTT4!T205"TTn: H'O'
IP 11
m
1
r
r
—
—
n
r
r
r
r
r
r
r
"
1
I
I
I I
r~
I
i
I I
i
I
I
r
r
III
i
i
r
r
I I
] -m
r
r
—
i
i
i
I I
i
i
i
i
I I
i
n
~
i
r
I I
i
i
i
c
lualifier Code Qualifier Desc
Qualifier Type
Event Description
¦
l
1
1
•
Event Comment
—
I-
r~
r
Monitor
Protocol
Method Unit
Duration Coll Frequency
Alt Mdl
Event URL
116 Jl 05 |7
II
ji
At this point the user will select the appropriate code from the (1) Qualifier Code drop
down menu. This will open a (2) pop-up, for the user to select the exceptional event.
jJnlisJl
^Maintain - Raw Data (National Air Data Group)
Raw Data Comments
State County
37 11 lo€3
: c ; C 1
Begin Date: End Date:
L
Standard Units
Raw Data
Mp ID Date Time
_ j20140220 00:00
120140214 00:00
z::i:::: ,:i:
Qualifier Desc
Stat
Ind
F
Reported
Sample Value
Standard EP
Sample Value In
2
la
1
\p
3
r~
|p
1
ii
1
I
i
1
m
r
1
i
I
i
1
i
1
1
i
1
1
i
1
Qualifier Type
Monitor r,ieir
Protocol I116
Duration Coll Frequency Alt Mdl
Valid values for Qualifier Code
Findj%
Code
(Qualifier Desc
(Qualifier Type
J
RA
African Dust
REQEXC
RB
Asian Dust
REQEXC
RC
Chem. Spills & Indus! Accidents
REQEXC
RD
Cleanup After a Major Disaster
REQEXC
RE
Demolition
REQEXC
RF
Fire - Canadian
REQEXC
RG
Fire - Mexico/Central America
REQEXC
RH
Fireworks
REQEXC
Rl
High Pollen Count
REQEXC
1
RJ
High Winds
REQEXC
RK
Infrequent Large Gatherings
REQEXC
zi
<1
i
Jj
OK
Cancel
1
Note] Exclusion Qualifier ("REQEXC") codes all begin with the letter 'R'.
92
-------
Then, the user will save the changes by clicking the Save icon.
The sample value now has an exceptional event qualifier. Before this sample is visible to the
Regional Office for concurrence purposes, the sample values must be associated with an
Exceptional Event. (See the next section.)
Defining an Exceptional Event
Exceptional events must be described and documented in order for EPA regional office to concur
on affected data requests. This documentation must be completed in AQS via online forms.
Users do not have to define an exceptional event as a prerequisite to flagging measurement data
with the qualifier code. However, if a user requests concurrence from EPA for flagged data to be
excluded, then the exceptional event needs to be defined before the concurrence flags can be
set.
In order to add exceptional events the user must be in the screening group that "owns" the data
and the user must have the authority to edit raw data and event data.
The event can be defined either via Maintain Exceptional Events (recommended if it is anticipate
that this event will affect many sample values) or via Maintain Raw for each sample value.
Using Maintain Event to Define and Associate Events
The user will click Maintain on the Menu Bar. This will open the drop down and the user will then
select Event. This will open up the Maintain Exceptional Events form.
J Critical Rev C
Site
Monitor
Event
SamPle Values ~
Blanks
Concurrence Ind
Sile Sampler
OA Assessments ~
Monitoring Seasons
Main Menu |
Required information to define an exceptional event:
• Qualifier Code (this is the type of event and are selected from the drop down -
these map to the REQEXC type qualifiers).
• Event Description.
93
-------
Optional information:
• Event Begin Date.
• Event End Date.
• Comment.
• URL.
3Maintain Exceptional Events (National Air Data Group)
Define Event Associate Raw Data with Event
Screen Grp Name|National Air Data Group
Qualifier Code Qualifier Description
m
Event Begin Date Event End Date
Event
Description
Comment
Url
On the Define Event tab the user will:
1. Use the drop down on "Qualifier Code" to select the type of exceptional event - required
1. The "Qualifier Description" field will be populated with the description matching
the Qualifier Code selection.
2. Add an "Event Begin Date" and "Event End Date" in YYYYMMDD format - optional
1. Usually exceptional events have a distinct begin and end date.
3. "Event Description" - comment field - required
4. "Comment" - comment field - optional
5. "URL" - add a link to a webpage to add additional explanatory materials - optional
94
-------
M AQS
Action Help Session Admin | Jhlaintenance Critical Rev CErtification Batch Correct Main Menu
Hi I 4E1 ¦ I a t < ~ ~ ± x m ^ ^ | ^ | ?
^Maintain Exceptional Events (National Air Data Group) - !~! x
Associate Raw Data with Event
Define Event
Screen G
ie National Air Data Group
n.ialifipr rrtrip nimlifipr r>P«=rrintinn
RH
"_l
Fireworks
Event Begin Date
20140214
Event End Date
120140214
Event
Description
Comment
Url
Firework display
If there is an existing Exceptional Event, then the user can query the event by:
1. Entering the qualifier code and/or the event description.
2. Submitting the query using the "Execute Query" icon.
The events that match the query criteria will display on the Define Event tab.
Associate Raw Data with Event
To associated raw data with an event the user will select the Associate Raw Data with Event tab.
^Maintain Exceptional Event
s (National Air Data Group)
Define Event
i Associate Raw Data with Event;
95
-------
To see which monitors are associated with this event, or to associate a monitor with this event,
the user will select "Query Affected Monitors."
g] Maintain Exceptional Events (National Air Data Group)
_ n x
Define Event
Event Description
! Associate Raw Data with Event!
Firework display
Screen Grp Name
(National Air Data Group
Qualifier Code Qualifier Description
RH
Fireworks
Event Begin Date Event End Date
(20140214 (20140214
State Code County Code Site ID
Parameter
POC
¦ ¦
Query Affected Monitors
Query By Date Range
Associate All
Disassociate All
Monitor Key
Begin Date
End Date
# #
Associated Unassociated
Reset Actions
Action
96
-------
In order for the user to associate any unassociated monitors with the event, the Action LOV
button must be clicked for the respective row.
State Code Co
r
r
r
r
Find %
Monitor Key
37-063-S&99-&S101-1
Action
Associate
Disassociate
No Action
Find
OK
Cancel
I I
Query Affected Monitors
e All
Disassociate All
Reset Actions
Delated Unassociated Action
0
LP
This will open a pop-up that allows the user to select 'Associate' to associate the affected
monitor/s. Then the user will click 'OK'.
Find|%
| Action
1 Associate
Disassociate
No Action
Find
OK
Cancel
97
-------
At this point the user will notice that the monitor will now display in the '# Associated' column.
#
#
Monitor Key
Begin Date End Date
Associated
Jnassociated Action
* |l 3 7-063-&&&9-SS101-1
120140214 (20140214
1 I
) |!M!.!JMfc! |
Once the user verifies that all information is correct the 'Save' icon should be clicked.
The sample measurements that match these criteria and that were flagged with the qualifier flag
are now available for the Regional Office to set the concurrence indicators via the Maintain
Concurrence menu in AQS.
Query by Date
The user can also query the events by date. After the monitor data has been retrieved by the
'Query Affected Monitors' button, the user can change the Begin Date and/or End Date values.
Then click the 'Query By Date Range' button. The flagged data available will be limited to that
which falls between these new dates.
Query By Date Range
Associate All Disassociate All Reset Actions
Monitor Key
# #
Begin Date End D>ate Associated Unassociated Action
37-063-999&-88101-1 |20140214 |20140214
I'j
98
-------
Add concurrence flag
Regional Administrator
The Regional Administrator role has the ability to update the EPA_Concurrence_lnd field on the
RAW_DATA table for any state within their region. Their designated region is specified on the
AIRS_USER_PROFILE table. The Regional Administrator also has sole update privilege for the
Regional Evaluation Date on the Site record.
Regional Office
An EPA Regional Office AQS user can add a concurrence flag to signify that they concur with the
exclusion of sample measurements due to an exceptional event. This concurrence can only be
done via online forms.
A "Concur" flag means that the Regional Office concurs with the exclusion. A "Deny" means that
the Regional Office does not concur with the exclusion.
Certification is preserved when data is Concurred or Non-Concurred. The Certification of a
Monitor-Year is only removed when the concentration value of a sample measurement is
updated, but not when other fields are updated.
Sample values can be concurred/non-concurred based on different existing standards:
Pollutant
Standards
03
8-hour 2008
1-hour Daily 2005
8-hour 1997
S02
24-hour 1971
3-hour 1971
Annual 1971
N02
Annual 1971
CO
8-hour 1971
1-hour 1971
Pb
Quarterly 1978
PM10
24-hour 2006
PM2.5
24-hour 2006
Annual 2006
99
-------
Work Flow
1. The Regional Office user evaluates the documentation for a sample measurement that was
flagged as being affected by an exceptional event.
2. The Regional Office user will use the Maintain Concurrence form in AQS to query the
affected sample measurements and to set the concurrence flag. To access this portion of
AQS, the user must have the correct authorization. An authorized Regional Office user would
have access to all the monitors in that region. From the Menu Bar, the user will click
'Maintain' then select 'Concurrence Ind'.
Maintain
Critical Rev (j
Site
Monitor
Event
SamPle Values
Planks
~
Concurrence Ind
Sile Sampler
OA Assessments ~
Monitoring Seasons
100
-------
3. Query the affected sample measurements:
Action Help Session Admin Retrieval Maintain Critical Rev Certification Batch Correct Main Menu
H fl IJR & K d MI ^0% HI a J < ~ * ~~ ± * a I ^ I ?
Maintain - EPA Concurrence indicator (Region 4 Atlanta)
State County site Parameter poc
137 _jJ |063 19999 - | |SS101 - | pi
Screening kroupName cveiu i ype tvem Description
II
Begin Date End Date Applicable NAAQS Standard
r
"_l
Concur All
Deny All
Clear All
Concur
Ind
Monitor
Samp Begin
Date-time
37-06 3-9999-&8101-1
~ |20'
Std Samp
Value
Std Qualifier
Unit Code Qualifier Description
140214 00:00
1105 [RH |Fireworks
Applicable NAAQS
Standard
37-063-9999-BS101-1
20140214 00:00
37-063-9999-&S101-1
20140214 00:00
37-063-9999-SB101-1
20140214 00:00
105 RH
105 RH
105 RH
Fireworks
Fireworks
Fireworks
PM25 24-hour 2006
PU25Annual 2006
PU25 24-hour 2Q13
PM25 Annual 2013
Event Description
Concurrence Comment
| Fire work display
Event Comment
Event Url
Open URL
Concurrence Date 1
101
-------
4. Where applicable, the concurrence flag can be set for a particular standard.
Action Help Session Admin Retrieval Maintain Critical Rev Certification Batch Correct Main Menu
oaim ** i 111 m a % i « t < ~ * ~~ ± * ^ & i ^ i ?
12 Maintain - EPA Concurrence indicator (Region 4 Atlanta)
State County site Parameter poc
Begin Date
End Date
Applicable NAAQS Standard
|37 * I 1063 T | ]9999 1 ||8S101 * I 1
I
I
_|
Screening Group Name Event Type Event Description
1
_LI i±1
Concur All | Deny AD Clear All
Concur
Samp Begin Std Samp
Std
Qualifier
Applicable NAAQS
nd
Monitor Date-time Value
Unit
Code
Qualifier Description
Standard
jt.
1
*
37-063-9999-S3101-1 (20140214 00:00 |3
|l 05
|rh
| Fireworks
|PM25 24-hour 2006
37-063-9999-SS101 -1 (20140214 00:00 |3
1105
|rh
(Fireworks
|PM25 Annual 2006
-
37-063-9999-SS101-1 |20140214 00:00 |3
1105
|rh
| Fireworks
| PU25 24-hour 2013
-
37-063-9999-SS101-1 (20140214 00:00 |3
1105
)rh
(Fireworks
|PM25 Annual 2013
III
J —
I I III | 1
r r r r
i i il l i
ii I ill I 1
~
1 il ii' I i li I
Event Description
Concurrence Comment
Concurrence Date
Fir
djsf
lay
Event Comment
I
Event UrI
I
Open URL
5. If the region agrees with the exclusion they will enter 'Y' in the 'Concur Ind' field.
Concur
nd
Monitor
.a.
Y T
37-063-95
37-063-99
Note] a "Concur" flag means that the Regional Office concurs with the exclusion. A "Deny" means that the Regional
Office does not concur with the exclusion.
102
-------
6. The Regional Office will save the changes using the "Save" icon.
The addition of an exceptional event qualifier flag to sample values initiates (during the POST
process) the re-computation of all of the summaries:
• At monitor-level:
o NAAQS Averages
o Daily Summaries
o Quarterly Summaries
o Annual Summaries
• At site-level:
o Daily Summaries
o Quarterly Summaries
o Annual Summaries
103
-------
Setting up and mapping monitors to samplers and sampler channels
This walk thru will explain how a user can create and load the necessary transaction to associate
speciation samplers with monitors so that flow quality assurance data can be submitted.
A sampler is the physical piece of equipment.
This is the top of a sampler with 8 channels, 3 of which are being used.
-------
Here the sampler cover is down and the filters can be seen in three of the channels.
In AQS, a monitor is defined as a parameter measured at a site. Thus each filter will be
associated with a monitor for each parameter that the filter is analyzed for (typically between 3
and 60 parameters for each filter).
Note] this tutorial assumes that the user has already setup the samplers and sampler channels.
105
-------
The user should verify the samplers and sampler channels are setup. To do this the user will
open the Maintain Site Samplers form. After logging in to AQS the user will select Maintain from
the Menu Bar then select Site Samper from the drop down menu. This will open a blank Maintain
Site Samplers form.
^Maintain Site Samplers (National Air Data Group) - n|xj
Site Sampler
Sampler Owner Agency | ~w :
State Code
County Code
Sampler Id
Begin Date
l~J
jr
Site Number
L=L
_J
End Date
Number of Channels |
Manufacturer
Model Number
Serial Number
Sampler Channels
Channel
Number Filter Type
Target
Flo w Rate
Flow
Unit
Begin
Date
End
Date
Here the user should fill in the relative information.
Sampler Owner Agency I—J
State Code I-J f
County Code \
Sampler Id i
Begin Date
"J
End Date
Site Number
JU
Number of Channels
Manufacturer |~
Model Number |
Serial Number [
106
-------
Then the user will click the Execute Query icon. This will populate the form and allow the user to
verify Samplers and Sampler Channels.
^Maintain Site Samplers (National Air Data Group)
Site Sampler
Sampler Owner Agency mar _i f North Carolina Dept Of Environment And Natural Resources
|37-Q35-QQ04
State Code
37 | |North Carolina
County Code
035 11 Catawba
Site Number
1 Sampler Id
MET-ONE-A
Begin Date
20020101 End Date I
Number of Channels |4
"J
Manufacturer |Met One Instruments
Model Number |sASS
Serial Number
Sampler Channels
Channel
Number Filter Type
A li [teflon
Target Flow
Flow Rate Unit
>7
NYLON
Begin
Date
118 |20020101
E d
6.7
QUARTZ
jr
1113 120020101
pMS |20020101
T
~_r
;jr
s
If there are multiple samplers the user can click the Next Record icon to move to the next
sampler.
107
-------
In order to set up and map monitors to samplers and sampler channels the user will create a text
document containing AQS Monitor Channel (MP) transactions. Each transaction should contain:
1. Transaction Type, which will be MP, for monitor channel
2. Action Code, which will be I, for insert
3. State Code
4. County Code
5. Site ID
6. Parameter
7. POC
8. Sampler ID
9. Channel Number
10. Begin Date, this is the begin date for the affiliation of the monitor to the sampler.
MP
T
"01
073
0023
88104"5
MET-ONE-A
1'
200101011
MP
I
01
073
002 3
88107 5
MET-ONE-A
1
20010101;
MP
01
07 3
0023
88109 5
MET-ONE-A
1
20010101•
MP
T
01
07 3
002 3
88110 ' 5
MET-ONE-A
1
20010101
MP
—
01
073
0023
88111 5
MET-ONE-A
1
20010101"
MP
I
01
073
002 3
88112,5
MET-ONE-A
1
20010101
MP
I
01
07 3
0023
8811315
MET-ONE-A
1
20010101
MP
01
073
002 3
88114 I 5
MET-ONE-A
1
20010101?
MP
I
01
07 3
002 3
8811515
MET-ONE-A
1
20010101:
MP
I
01
073
0023
88117[5
MET-ONE-A
1
20010101•
MP
'01
073
002 3
8811815
MET-ONE-A
1
20010101-
MP
I
01
07 3
002 3
8812615
MET-ONE-A
1
20010101'
MP
01
073
0023
8812815
MET-ONE-A
1
20010101"
MP
I
01
07 3
0023
8813115
MET-ONE-A
1
20010101¦
MP
I
01
07 3
002 3
8813215
MET-ONE-A
1
20010101;
MP
T
01
073
0023
8813615
MET-ONE-A
1
20010101;
108
-------
The user may also run a report that will list transaction for all samplers, sampler channels, and
parameters associated with his site to assist in the creation of the text file.
The user will select Retrieval from the Menu Bar then select Standard Report Selection from the
drop down menu. This will open the Standard Report Criteria Selection form. In the Report Code
field the user will use the drop down to select the Extract Site/Monitor Data Report (AMP 500).
^Standard Report Criteria Selection (National Air Data Group ; AMP500
Criteria Set Data Selection | Sort Order | Report Options j Retrieve Reports |
~ x
Criteria Set |
Owner |MICHAEL
"J
Desc
BROOKS
Type (PRIVATE
J
ptepor^octe "IT
^Report Name |EXTRACT SFTE/MONTOR DATA
Reports
Findj%
AMP440
AMP390
AMP??nn
Rep_Report_Code
Report_Name
AMP410
AIR QUALITY INDEX REPORT
AMP41 OS
AIR QUALITY SUMMARY REPORT
AMP395
AUDIT HISTORY REPORT
AMP600
CERTIFICATION EVALUATION AND CONCL
AMP355
COMBINED SITE SAMPLE VALUES
G74
CR RAW DATA
AMP435
DAILY SUMMARY REPORT
AMP430
DATA COMPLETENESS REPORT
AMP480
DESIGN VALUE REPORT
AMP504
EXTRACT OA DATA
AMP501
EXTRACT RAW DATA
AMP503
EXTRACT SAMPLE BLANK DATA
AMP500
EXTRACT SITE/MONITOR DATA
M.AXIMUM VALUES REPORT
MONITOR DESCRIPTION REPORT
MONITOR NFTWORK RFPORT ,
OK
Cancel
109
-------
After this selection is made the user will click the Data Selection tab. The user will then fill in all
the relative fields. In Protocol Criteria area of the form the user will choose ALL for pollutant
type.
^Standard Report Criteria Selection (Is
Jational Air Data Group) AMP500
aoiKi
Criteria Set
Data Selection |
Sort Order Report Options
Retrieve Reports
Monitor I Geographic Criteria
State County Site Parameter City AQCR UAR
Code Code jd Code PQC Code
CBSA
CSA
EPA Region
— r
01
W
073 -
0023
--
-
5
T~
*
-
I—
*
-
-r
|
hi
J
—
—
—
_
_
_j
| j
Protocol Criteria
Date Criteria
_ Parameter
Pollutant Type
| Code
•
!
|
i
—
i
Screening Group
i
~
i
i
d
Monitor Network
Monitor Type
Generate Report
110
-------
The user will then click on the Report Options tab. Then click the Uncheck All button on the form.
^Standard Recort Criteria Selection (National .Air Data Group^AMPSOO
-ln|x|
Criteria Set | Data Selection | Sort Order | Report Opt
ons || Retrieve Reports j
SITE MONITOR TRANSACTIONS
SITE BASIC
17
<*¦
ACTION INDICATOR 1 INSERT
-1 —
TANGENT STREETS
F
XML SCHEMA VERSIUN |2.2
z\
OPEN PATHS
F
MERGE PDF FILES |YES
MONITOR BASIC
F
1 J-J
MONITOR SAMPLE PERIODS
F
! J
MONITOR TYPES
F
MONITOR AGENCY ROLES
F
| J
MONITOR OBJECTIVES
F
I _l
MONITOR SAMPLING SCHEDULES
F
~
I
MONITOR STREET INFORMATION
F
Check All ^^nchec^AI^
Generate Report
The user will then select MONITOR BASIC by clicking the check box to the right of the selection.
SITE MONITOR TRANSACTIONS
A
STE BASIC
r
TANGENT STREETS
r
OPEN PATHS
r
MONITOR BASIC
pj
MONITOR SAMPLE PERIODS
r
MONITOR TYPES
r
MONITOR AGENCY ROLES
r
MONITOR OBJECTIVES
r
MONITOR SAMPLING SCHEDULES
r
-rJ
MONITOR STREET INFORMATION
r
Check All Uncheck All
Ill
-------
The user will then scroll down and select SITE SAMPLERS and SAMPLER CHANNELS.
SITE MONITOR TRANSACTIONS
MONITOR REGULATORY COMPLIANCES
r
MONfTOR COLLOCATION PERIODS
r
MONITOR PROTOCOLS
r
|MONITOR METHODS
r
MONfTOR NETWORK AFFILIATIONS
r
PRIMARY MONfTOR PERIODS
r
MONfTOR NAAQS EXLUSIONS
r
SITE SAMPLERS
M
SAMPLER CHANNELS
M
~
MONfTOR CHANNELS
r
Check All UncheckAII
The user will then click the Generate Report button. The user may use this information in
creating the text file needed to create and map the monitors to the appropriate samplers and
sampler channels.
AMP500_1492623-0.txt - Notepad
File Edit Format View Help
f AD
Action code
# AE
Action code
# MA
Action code
AD
I
01
073 |0023
AD
I
01
07310023
AE
I
01
07310023
AE
I
01
073|0023
AE
I
01
07310023
AE
I
01
07310023
MA
I
01
073 10023
MA
I
01
073 0023
MA
I
01
073|0023
MA
I
01
073(0023
MA
I
01
07310023
MA
I
01
073)0023
MA
I
01
07310023
MA
I
01
07310023
MA
I
01
073(0023
MA
I
01
073(0023
MA
I
01
07310023
MA
I
01
073(0023
MA
I
01
07310023
MA
I
01
073(0023
MA
I
01
073(0023
MA
I
01
073(0023
MA
I|01
073(0023
MA
1101
07310023
MA
1101
07310023
MA
Ijoi
07310023
MA
11 01
073 10023
MA
11 01
073(0023
M fli
T
n-t
at d a rim :>
state code [county codelsite Number |sampler lD(samp1er owner |Manufacturer |Model Numbei
state codelcounty codelsite iDlsampler lD|channe1 Number|Filter Type|Target Flow Rat'
state codelcounty codelsite id | Parameter j poc | Project cl ass I Domi nant source |Measuremei
met-one-a|0013|Met one instruments|sass||4120010101|
URG-A)0013|URG]3000N||1|20070503|
MET-ONE-A ] 11 TEFLON | 6. 7 1118 l| 200101011
MET-ONE-A|2 j NYLON|6.71118|200101011
MET-ONE-A j 3 j QUARTZ|6. 71118|200101011
URG-A
68101
68102
68103
68104
68105
68106
68107
68108
81102
86101
88102
88103
88104
88107
88109
88110
88111
88112
88113
88114
88115
88117
QUARTZ|22|118
AREA(NEIGHBORHOOD
1 1
II
1 I
II
210
III
200705031
I
III
I TOP OF BUILOING|4||||| |1|||||0199|| |||
II
112
-------
Here the user can see the three selections that were made:
1. AD is Site Sampler
2. AE is Sampler Channel
3. MA is Monitor Basic
AMP500_1492623-0.txt - Notepad
File Edit Format View Help
^ AD|Action code|state code|county code|site Number|sampler II
# AEIAction codejstate codejcounty codejsite ID|sampler lD|ch.
# MA|Action codejstate codejcounty codejsite ID|Parameter|poc
And all of the Parameters associated with the site.
MA
I
01
073
0023
Tmr
5| 1
MA
I
01
073
0023
88103
5| 1
MA
I
01
073
0023
88104
5 1 1
MA
I
01
073
0023
88107
5| 1
MA
I
01
073
0023
88109
5| 1
MA
I
01
073
0023
88110
5| 1
MA
I
01
073
0023
88111
5 1 1
MA
I
01
073
0023
88112
5| 1
MA
I
01
073
0023
88113
5 1 1
MA
I
01
073
0023
88114
51 1
MA
I
01
073
0023
88115
5 1 1
MA
I
01
073
0023
88117
5 | |
MA
I
01
073
0023
88118
5 | |
The MA transactions can be used as a template to create the MP transactions described earlier.
The MA transactions will contain the monitor identifier (state + county + site + parameter + POC)
for all monitors at the site. These can be edited, duplicated, etc. to create the necessary valid
MP transactions.
After the user creates the text file he can then submit it through the ENSC (Exchange Network
Services Center). Once the submission is complete all of the monitors should be appropriately
mapped to the samplers and sampler channels.
113
-------
Delete Obsolete Records
In order to delete obsolete records in AQS the user will open the Delete Obsolete Records form
area. To access this form the user will click Critical Rev on the Menu Bar, which will open the
drop down where the user will then select Delete Obsolete Records. This will open the Critical
Review - Delete Obsolete Records form. Here the user will click the Delete Obsolete Records tab.
The data administrator will have the ability to delete records from the critical review areas. It is
anticipated that this will be utilized every six months based on the "Date of Update" field. These
records will be deleted from the critical review tables.
The Data Administrator can select a date range and the Critical Review Raw Data records will be
deleted for all Critical Review Records within the specified range, based on the Date of Update.
To use the Delete Obsolete Function the user must enter Query Mode.
This can be done by selecting the Enter Query icon located on the menu. Selecting the Execute
Query icon executes the query after entering your desired parameters. To exit Query Mode
select the Cancel Query Mode icon or press Ctrl-Q on your keyboard.
Note: When in Query Mode all menu items are locked except for context sensitive help.
114
-------
Dati Drts
List of Standard Reports
This is a table of all standard reports.
Most reports have a minimum set of required selection criteria, without which they will not run.
For Parameter, either a specific parameter number or Pollutant Type group name (such as
CRITERIA or ALL) is required. For Geography, any geographical specification on the active
selection tab is acceptable.
REPORT_CODE
REPORTJNIAME
DATE
PARAMETER
GEO
AMP025
Screening Group Inventory
AMP220D
MONITOR NETWORK
Y
Y
Y
AMP230
FREQUENCY DISTRIBUTION REPORT
Y
Y
Y
AMP251
QA Raw Assessment Report
AMP256
QA Data Quality Indicator report
AMP260
REDUCED FREQUENCY DISTR REPORT
Y
Y
Y
AMP300
VIOLATION DAY COUNT REPORT
Y
Y
Y
AMP350
RAW DATA REPORT
Y
Y
AMP350MX
RAW DATA MAX VALUES REPORT
Y
Y
Y
AMP350NW
RAW DATA NAAQS AVERAGES
Y
Y
Y
AMP350P
RAW DATA REPORT PREPRODUCTION
Y
Y
AMP355
Combined Site Sample Values
AMP360
Raw Data Qualifier Report
115
-------
AMP380
SITE DESCRIPTION REPORT
Y
AMP390
MONITOR DESCRIPTION REPORT
Y
Y
AMP410
AIR QUALITY INDEX REPORT
Y
Y
AMP410S
AIR QUALITY SUMMARY REPORT
Y
Y
Y
AMP430
DATA COMPLETENESS REPORT
Y
Y
Y
AMP435
DAILY SUMMARY REPORT
Y
Y
Y
AMP440
MAXIMUM VALUES REPORT
Y
Y
Y
AMP450
QUICKLOOK CRITERIA PARAMETERS
Y
Y
Y
AMP450NC
QUICKLOOK ALL PARAMETERS
Y
Y
Y
AMP470
Raw Values by Year
AMP480
DESIGN VALUE REPORT
Y
Y
Y
AMP500
EXTRACT SITE/MONITOR DATA
Y
Y
AMP501
EXTRACT RAW DATA
Y
Y
Y
AMP503
EXTRACT BLANKS DATA
Y
Y
Y
AMP504
Extract QA Data
AMP600
Certification Evaluation and
Concurrence
G74
CR Raw Data
116
-------
Generating Reports
Reports are found under the Retrieval section located on the Menu Bar.
Under Retrieval there are a number of Browse reports where you can view data on the system.
Browse reports are for reviewing information and are not designed for exporting or printing
data.
Standard Reports Overview
In AQS, the most common way to view data is via Standard Reports. These are pre-defined
reports that show most of the data in AQS.
This section gives a brief overview of how to use the reports function of AQS.
Standard Reports Form
Criteria Set Tab
AQS Standard Reports are under Retrieval in the Menu Bar. To navigate to them, the user will
click 'Retrieval' form the Menu Bar then select 'STandard Report Selection' from the drop-down.
Action Help Session Admin
Ha JU 7^3
g] Standard Report Criteria Sell
Criteria Set
Data Sele
QUALIFIER COUNTS BY MOt
MERGE PDF FILES
QUALIFIER CODE
CONCURRENCE STATUS
QUALIFIER TYPES
Retrieval
Maintain Critical Rev CErt
Browse Annual Summary
Browse Approved Regional Methods
BRowse Monitoring Season
BrOwse Sample Methodology
BroWse State Threshold
BrowSe Parameter
BrowsE Audits
summary Data Extraction
SJandard Report Selection
Main Menu
This will open the 'Standard Report Criteria Selection' form.
117
-------
The user will click the LQV associated with the Report Code field.
^Standard Report Criteria Selection (National Air Data Group) — I ~! xl
Criteria Set Data Selection
Sort Order
| Report Options Retrieve Reports
Criteria Set |~
-»1 Desc r
Owner |M|CHAEL |BROOKS
Type (PRIVATE
^1
Report Code [
^Jj Report Name l~~
r
r
r
r
C Run Online
(' Send via Email
Report Outputs
Generate Report
This will open a pop-up providing the user with a list of reports to choose from.
Reports x|
Find[%
Rep_Report_Code
Report_Name
A
AMP410
AIR QUALITY INDEX REPORT
AMP410S
AIR QUALITY SUMMARY REPORT
AMP600
CERTIFICATION EVALUATION AND CONCL
AMP355
COMBINED SITE SAMPLE VALUES
G74
CR RAW DATA
AMP435
DAILY SUMMARY REPORT
AMP430
DATA COMPLETENESS REPORT
AMP255
DATA QUALITY INDICATOR REPORT
AMP480
DESIGN VALUE REPORT
AMP502
EXTRACT P/A DATA
AMP504
EXTRACT QA DATA
AMP501
EXTRACT RAW DATA
AMP503
EXTRACT SAMPLE BLANK DATA
AMP500
EXTRACT SITE/MONITOR DATA
AMP230
FREQUENCY DISTRIBUTION REPORT
AMP440
MAXIMUM VALUES REPORT
1
AMP.TQH
MONITOR DFRnRIPTIDN RFPDRT
M
1
OK
Cancel
1
118
-------
Once the user has done this the mode the report will run in needs to be determined.
Report Code |AMP410
(* Run Online
C Send via Email
If the user selects 'Run Online' the report will be delivered to the user's browser and the user
must stay on-line to retrieve the report.
If 'Send via Email' is selected, AQS will email the report to the address in the user profile. This is
called a "batch" report (just like batch load, it can be working while the user is not logged in).
After the user selects a Report Code the Print Format will be show. Also, if the user selected
'Send via Email' then the File Name will be shown.
Report Outputs
P REPORT
r WORKFILE
r
r
Output Formats
There are generally two Report Output options available, however there may sometimes be
more.
Report
This is a formatted report designed to be read. It is associated with the PDF format.
Workfile
This is a text file of tabular data (with a header) for things like spreadsheets to read. Each AQS
report has its own distinct workfile format.
XML
This is a tagged text file of nested data designed for computers to read.
The user may select as many of the Report Outputs as desired. If multiple selections are made,
the same data will be sent in different formats.
File Name
If Send via Email was selected the user must give it a short file name in order to have AQS email
the report when it is complete.
Print Format
|PDF
File Name P
119
-------
Data Selection Tab
Criteria Set
Data Selection
Sort Order
Report Options Retrieve Reports
County
Code
Parameter
Code
c c e
Monitor / Geographic Criteria
City AQCR UAR
POC Code Code Code
n
i—u\
i j
CBSA
Code
CSA
Code
EPA Region
Code
Pollutant Type
Protocol Criteria
Parameter
Code
Date Criteria
Start Date End Date
YYYY MM DD YYYY MM DD
^r
r
~rr
~rr
Monitor Network
Agency Role |PQA0
"J
J
Agency
Generate Report
The form is divided up into several blocks, each with their own bold header: Monitor/Geographic
Criteria, Protocol Criteria, Date Criteria, Monitor Network, and Agency Role. Some blocks may
have default values populated depending on the report you have selected.
Each of these blocks allows the user to enter selection criteria for the selected report. Only data
that matches criteria will be included in the report. There are a few things to keep in mind when
entering selection criteria:
• Certain minimum criteria are required. These vary by report, so the fields are not bolded
(like correct and maintain forms). If not have enough criteria have been entered, an error
message will be generated.
• The more criteria entered the less data will be returned, and the faster the report will
run.
• Entering a criteria means produce those values. Leaving a criteria blank means produce
all values.
o For example, entering a state code will return data for all monitors in the state.
120
-------
o Entering a state code and a county code and a parameter code will return data for
just that parameter in that county,
o Entering a pollutant type or parameter code will return data just for it. Leaving it
blank will return data for all parameters.
Sort Order Tab
Each report in AQS includes a default sort order (usually the order of display). For some reports,
this can be altered using the Sort Order tab. Sort columns can be moved up or down in the sort
order by highlighting them and pressing the up or down arrow buttons. Columns may not be
added to the sort order.
Report Options Tab
Each report in AQS includes a default set of options that can be changed. To change the options,
the user will select different values for the options by using the LOV (drop down) associated with
each.
Some reports (with NAAQS related data) will also include some information (that is not
adjustable) about which standards will be represented in the data.
Retrieve Reports Tab
This tab keeps a history of recent reports that have been run (going back 30 days). This tab can
be used to check on the status of a long-running batch report. It can also be used to download
the output of previous reports that may have been misplaced. This is the only way to view an
online report after the user has exited the Report Progress popup.
The user will need to refresh this view after opening the Retrieve Reports Tab. The user will click
the Refresh Query button to update the view to the latest status.
Note] all reports submitted under the user's name are displayed.
In order to retrieve a report the user can highlight the desired report in the list and then click on
the Retrieve Report button.
Any report in the correct state may be stopped from this form. The User will highlight the
desired report line and then click the Cancel Report button to cancel the report. The user may
find this helpful when a large amount of data has been selected and the report is not needed.
The Delete Report button will delete the selected report. This is not requires as the report listing
will periodically be cleaned up as a part of routine maintenance.
Note] reports in this list will not remain available for extended periods.
121
-------
oirt
After the report and output options have been chosen and all of the selection criteria (and
optionally adjusted the sort order and changed options) have been entered, the report is ready
to be run.
Note] every tab on the Standard Reports form (except Retrieve Reports) has a Generate Report button.
After the Generate Report button has been clicked the application may jump back to where the
user last had his cursor or to the Criteria Set tab - this is normal.
Report Submitted for Batch Processing
If the report was run in batch mode (emailed to the user when completed), this is the pop-up
that will be displayed.
Report Status
If the report was run on-line, the pop-up will display the stage and percent complete of the
report. The report can be canceled if an error was made or it is taking too long. When the on-line
report is done it will be delivered to the user's browser. If the output is a Report it will appear in
a new tab. If the output is a workfile or XML the browser will prompt the user to download a
zipped file.
Report Contents
All reports contain a PDF cover page echoing the selection criteria.
If the only output is PDF files, this page will be added to the beginning.
If the output includes non-PDF output, all files will be zipped into a single archive that includes
the cover page echoing the selection criteria and one or more files with the results (depending
on the report and the outputs). All of the files will begin with the File Name entered on the
Criteria Set tab and include suffixes and extensions.
California Dump Bucket
The California Dump Bucket creates an output file that contains any changes to California related
data. These changes can come from the AQS batch data load facility (Load, Stat_CR and Post) or
from the on-line maintain facilities within AQS. In any case, whenever production-level data
related to California is modified, a record is written to the dump bucket table.
122
-------
This tool exports these modified records to a text file that is used by the California Air Resources
Board (CARB). The form queries in the records in the DUMP_BUCKET table and displays them
counted and grouped by export date. The displayed fields are Export Date and Record Count.
Form Security
The Export CA Dump Bucket option is only available to AQS users in a Screening Group with a
CA_DUMP_USER role.
Form Operation
The user will click on any previously exported date, or click on NOT EXPORTED in the Export Date
column.
The user may export all selected records by pressing the appropriate button. The destination
choices for exporting these records are Email or Online. Previously exported records can be
deleted when the user selects the desired date line and clicks Delete. Not Exported records
cannot be deleted.
Output
The output is a text file with the same format as AQS batch input transactions. A record count
shows the number of records that were written. The export date in the DUMP_BUCKET table will
be updated with the new export date.
Logging Off
AQS can be closed (and logged off) by clicking on either the usual window close button (the red X
on the top right for windows users) or the Exit icon.
The user may be asked whether to commit/save changes or exit. The user should answer
appropriately.
The user may also exit AQS by closing the browser window that AQS is running in, however it
should be noted that this closes AQS without it prompting if the user would like to save any
changes.
123
-------
Learn more, service, and support
Refer to the following resources to get more AQS support.
To learn about
Do this
General Use
Password Reset
Reporting problems
Contact the AQS Help Desk
M-F 8am-6:30pm EST 866.411.4372 opt 9
epacallcenterPepa.Rov
M-F 6am-9pm EST
Loading Data
Go to Loading Data in AQS
Detailed information
about data in the database
Go to AQS Data Dictionary
AQS related material
Go to Manuals and Guides
Updating the User's Guide
Contact Mr. Michael S. Brooks
User Updates
Go to AQS RSS feed
AQS XML file construction
Go to Exchange Network
124
-------
Appendix A
Quick Reference Guide
Tips
• Passwords must be changed every 90 days.
• When using reports, be as specific as possible in providing criteria.
• "%" is the wildcard for Oracle queries.
• Date format is: YYYYMMDD
• Under Maintain, if you are logged on in a screening group, you can only access records
assigned to your screening group.
Changing Passwords
1. From the Main Menu, click Admin, then Security.
2. Enter new AQS password and Confirm password, click 'Ok'.
Browse Data
1. From the Main Menu, select Maintain.
2. Select the type of data you want to browse: Site, Monitor, Sample Values (Raw Data)...
3. Enter criteria for limiting the data (For example, state, county, site...).
4. Click the Execute Query button.
Changing Raw Data Values
1. From the Main Menu, click Maintain, Sample Values, and then Raw Data.
2. Enter monitor identifying information, date range, and click Execute Query.
3. Click on field in Raw Data area to change.
4. Change incorrect value.
5. Click Save icon.
Deleting Raw Data Records
1. From the Main Menu, click Maintain, Sample Values, and then Raw Data.
2. Enter monitor identifying information, date range, and click Execute Query.
3. Click on field in Raw Data area to delete.
4. Click Remove Record icon.
5. Click Save icon.
125
-------
Changing Site/Monitor Data
1. From the Main Menu, click Maintain, then Monitor.
2. Enter Site/Monitor identifying information.
3. Click Execute Query.
4. Make changes.
5. Click Save icon.
Note] changing site data is the same except you would specify Site from the Maintain option.
Using Correct to Change Records in the Staging Tables
1. From the Main Menu, click Correct, then Raw.
2. Enter identifying information, then Execute Query.
3. Correct errors.
4. Click Save icon.
5. Navigate to Batch screen.
6. Click the'Load File'button.
Uploading Data Using Batch
1. Select Screening Group Access and Screening Group.
2. From the Main Menu, select Batch.
3. Click 'Goto ENSC' and login to the Exchange Network.
4. Click'My Service Center'.
5. Select the 'Service Name' ending in AQS Submit.
6. Select a Document to Upload.
7. Fill in all other fields and then click 'SEND DATA'
8. After clicking the Send button the 'Request Received!' screen will appea
Creating Reports
1. From the Main Menu click Retrieval then Standard Reports Selection.
2. Provide Report Code on Criteria Set tab.
3. Choose to run the report online or have it sent via Email.
4. Provide selection criteria on Data Selections tab.
5. If necessary, complete Sort Order and Report Options tabs.
6. Click 'Generate Report' on Criteria Set tab.
-------
Inputting Raw Values Using Maintain
1. From the Main Menu, click Maintain, Sample Values, and then Raw Data.
2. Enter monitor identifying information and then click Execute Query.
3. On Raw Data tab, click on one of the records in the 'Raw Data' area of the screen.
4. Click Insert Record icon in top menu and enter new information.
5. Click the Save icon.
Insert a New Site/Monitor Using Maintain
1. From within Screening Group, click Maintain, and then Site.
2. Click Cancel Query button.
3. On Basic Site Data tab, provide State, County Code, and Site ID.
4. Complete information on Required and Optional tabs of Maintain Site Data screen (Basic
Site Data, Agency Roles...).
5. Click Save.
6. Click Create Monitor button.
7. Provide information on Monitor Basic tab as well as other tabs. (Several required fields).
8. Click Save button.
9. Verify that Site & Monitor have been entered by clicking from Main Menu, Maintain, Site
and Monitor.
10. Enter State, County, Site ID, and then click Execute Query.
11. Site/Monitor should be displayed.
127
------- |