AQS (Air Quality System)

User Guide

2018


-------
I 		 ' ! 		 ! ¦>!."	io I i!!!!"I" .1 !! ¦" ll-" " ¦"!! 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	15

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.

©



Delete Error Tram



Enterthe users 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



0

a
£

0

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

3 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.

GkjAQS

Action Help Session
R 3 j& ^ Security
[2 Administration-Appli Beference

Retrieval Maintenance Critical Rev CErtification Batch Correct Main Menu

User Profile II M User Statistics

First Hame MICH/
Phone 919.5.,

Zip Code 127711.
County Code jo63

Appl Audits

Export Ca Dump Bucket
Approved Regional Methods
Mantain Monitoring Season

8nce Tables Maintain Roles User History

44 7 4 ~ i ~~ ±	^ I ?

-in X

TW Alexander

AQS User ID MSBROOKS

search friangle Park

J

Last

Street Address 2 j
State Code 11

BROOKS

EH User ID |BROOKS.MICHAELS
Fax |~

User Type Jh
Status Ind [p

E Mail |BROOKS.MICHAELS@EP.A

Agency Code pfToS
AQS Contact [fj

EPA Region Code	J

Tribal User
Delete Error Transaction

Change Your Oracle Passwords

AQS Wew 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+Qto cancel.

Record: 1/1

Enter-Qu..



The first line of the status bar is a message area, and the second line shows the AQS query
status. On forms that allow data to be entered or queried, the status bar shows the query status
of AQS.

10


-------
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.

U AQS

Action Help Session Admin Retrieval Maintenance Critical Rev Certification Batch correct Main Menu

i I liSIWII « t < ~ * ~~ ±xa^|p ^ | ?

12 Maintain - Monitors (Tennessee)

^]Djx]

Project Class
Meas Scale
Probe Location
Probe Vert Dist
Samp Res Time
Close Date

Dominant Source
Open Path Num
Probe Height
Surrogate Ind
Last Samp Date
:oring Agency (Owner)

Dd

Status Ind

rj

Probe Hor Dist |

Unrest Air Flow rj
Last Post Date [~

LOV (List of Values) Icon

Monitor Basic

Sample Periods

Type Assign.

Network Affiliations

Agency .Rales

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.

lid AQS

Action Help Session

y a j& a ¦

| Maintain - Monitors (Tennessee;

Admin Retrieval Maintenance Critical Rev Certification Batch correct Main Menu

i M BLB IS B t< ~ * » i x '31 ip <

Project Class
Meas Scale
Probe Location
Probe Vert Dist
Samp Res Time
Close Date

Stati

Cod* Find[%

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

<1



1 2l

Status Ind

Dist
ow

Find

OK

Cancel





1

Check Completeness Duplicate Monitor

^jnjxj

Monitor Basic

Sample Periods

Type Assign.

Network Affiliations

Agency Roles

Objectives

Req Frequencies

QA Collocation

Methods

Exclusions

Pollutant Area

Tangent Road

Probe Obs.

Reg Compliances

Protocols

Channels

Comments

11


-------
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

J Find %



State

Code State Name

State A±J

01

Alabama

AL V

02

Alaska

AK _f

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 wj


-------
Valid value- "*r State Code

. (H)

Find[%h

xJ

State Code

State Name

State £

¦A.

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

SC wj

-±J	4



I _!J

Find

OK

Cancel







In the example above "h" was typed into the Find field next to "%" (Wildcard Character) (1).
Then the Find button was clicked (2). This brought up only those states that contain an "h" in
their name.

Note] the search function executes best with the wildcard, there is no need to remove it from the Find field.

13


-------
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.

«V

fi-

Environmental Information

exchange services center

^Nutwork

- Network

Home

My Profile | Help | Contact Us | Logout*

Loyytid

.oooutj^BH^r

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 |

1

O



My Quick Links

Exchange Nebwork

Check your Submission (QA Services)
Exchange Nefovork 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 Security 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

Username:

Password:

Database:

Connect



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).

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

15


-------
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 AOS 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.

life] AQS

Action Help Session Admin Retrieval Maintenance Critical Rev CErtification Batch Correct Main Menu

H S m J -J D & % H « T i ~ i ~~ ± £ 3. f) I %

Select Session Access (Read Only)

a j-63-



f* [Read Only User!

C~ Screening Group Access

C User Support Screening Group Access

AQS Production Database with values from 1957 to present. Earliest raw data that is open for update: January 1, 2009

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. go v/ttn/air&'airsaqs/aqs_u serJn fo_rss.xml

Record: 1/1



16


-------
User Profile

Ail 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

Ha a	« t < ~ * ~~	^ j ?

Administration - Application Security (Tennessee)

User Profile Maintain Security | Security Reference Tables | Maintain Roles | User History

. n x

First Hame MICHAEL

Phone |

Initial [s
Street Address 1

Last |bROOKS

Zip Code 27711 	j

County Code I3 3

109 TW Alexander
City [Research Triangle Pari

AQS User ID [USBROOKS
EH User ID |BROOKS.MICHAELE
Fax f

User Type fn
Status Ind |p~



Street Address 2	j

State Code	|37

Aaencv Code	[Tios _J

AQS Contact	[fj

EPA Region Code

EMail BROOKS.MICHAELS©EPA	Tribal User f~

Delete Error Transaction

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.

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 Name	|MICHAEL
Phone

Zip Code	27711 	|

County Code	Cc?

AOS User ID	[mSBROOKS

EM User ID	I BROOKS. MICHAELS
Fax

Initial [s

Street Address 1 |i09 TW Alexander

City |Research "riangle Par-.

User Type
Status Ind [p~

'J

Last BROOKS

EMail |bROOKS.MICHAELS©EPa.

Street Address 2

State Code [s7
Agency Code [TToS
AQS Contact N

EPA Region Code
Tribal User

Delete Error Transaction

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)



_|n x

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 Submission of Data

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.)

•	Exceptional event definitions, data associations, and concurrence (for EPA staff only)

22


-------
Batch Data Submissions Flowchart

The following explains the data flow to AQS.

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://aas.epa.eov/aqsweb/documents/TransactionFormats.html

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

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

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 an Account

O ^

Help | Contact Us

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

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

My 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 |

I

EXCHANGE NETWORK SERVICES

Send, get, and download information from
Exchange Network partners | GO |

O

My Quick Links

Exchange Network

Check your Submission (OA Services)

Exchange Network Discovery Sen/ices (ENDS)

Production CDX Web

Check out our News Feed for the latest
on what's happening with the Exchange
Network Services Center

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 |

EXCHANGE NETWORK SERVICES

Send, get, arid 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

Mv Quick Links T

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 (?)

• 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. It 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

AQDERawData

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.

NewJerseyNodeVI Prod NJDEP

Send Info AQS

ProcessAQSDoc

Send Info AQS

Get Info	AQS

AQS Submit

Air Quality System Document Submissions NetNode2

AQS Submit: Send files to the Air Quality
System (AQS).

GetAQSRawDatalnsertByDate AQS - GetAQSRawDatalnsertByDate
Service

NGNProd2.Q

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
>

ielect 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:

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 will appear.



Env

e

ironmenlal Information

/change

Network

SERVICES CENTER



My Services Center

r ^
Exchange Network Services

r

News & Da

Request Received!

Your File AMP50lM280016-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>f2015 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.

Environmental Information

exchange

V Network

SERVICES CENTER

Logged In: brooks.michaels@epa.gov

My Profile | Help | Contact Us | Logout

-Network

Home

My Services Center Exchange Network Services News & Data Channels

MY SERVICES CENTER

Quickly access the services and querns yn» use
and check the status of your request: | GO |

EXCHANGE NETWORK SERVICES

Send, get, and download information from
Exchange Network partners | GO |

1

O

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

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 |

This will open the My Service Center interactive window.

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 My Quick Links

o

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 Svstem

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.)

32


-------
Batch Form Overview

After logging in to AQS the user will select Batch from the Menu Bar.

ffi AQS

Action Help Session Admin Retrieval Maintenance Critical Rev CEftification	Correct Main Menu

Ha si ll 31 a a % I ¦ l « t < ~ t ~~ ± x ± ip ^ ?

^ BATCH (Tennessee)

- IPI x<

Process by File

History

HISTORY AND STATUS

LOAD-

-POST-

Submission
Date

Records

In File Date (last)

Process
Status

'20141218 16:28 iEastmanNovember14.txt.zip j

120141212 15:53 |TN Oct Precision.txt.zip J BILLY PUGH

(20141211 11:08

TNOct2014continuous txt.zipjBILLY PUGH

120141202 12:05

(20141202 12:15

TN AQSReport Sep 2014.txt. (BILLY PUGH

|20141202 11:58

(20141125 14:42

(20141125 12:09
|20141125 12:24

(20141120 15:04

| (20140807 10:47 (RAQ22014.txt.zip

NYRStar Oct 2014.txt.zip (BILLY PUGH

PbTnq3.txt-zip

(BILLY PUGH

TDEC_AQS PM2.5_Septemt:[EVELYN HASKIN

Eastman Oct 2014AQSRepo (BILLY PUGH

ResoluteFP102014.txt.zip " (BILLY PUGH

Exide October 2014 Data.txt. (BILLY PUGH

Recs	StatfCR

Recs Failing	Finding	Records Skip'd

Loaded to Load	Count	to Post Monitors

|10798 ( 0 ( 5	10792 I 0

28 20141212 16:10 LOAD-COMPLETED

14136 (20141211 11:31 |POST-COMPLETED

(post-completed
|post-completed

2991 20141202 12:33
13680 |20141202 12:33

32 |20141202 11:59

657 |20141125 14:49

11166 120141125 12:27
10416 |20141125 12:25

20 (20141120 15:05

(post-completed
(post-completed
|post-completed

]CRST-COMPLETED
(CRST-COMPLETED

45 (20141117 15:43 |LOAD-COMPLETED f 21 f

BILLY PUGH

PROCESS CONTROL

Process selected file through:
Results and Reports:

Load

Load File

J

Load Summary and Errors |	Stat CR Report

Post File

Raw Data Inventory

r

PROCESS FLOW

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.

UIOTflDV A Kin OT ATI IO

1 Submission
Date

File Name User Name

Records
In File

Date (last)

Process
Status

20141218 16:28

EastmanNovember14.txt.zip

10806

20141218 16:39 [POST-COMPLETED

(20141212 15:53 ]TN 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 |TN AQSReport Sep 2014.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 lRAQ22014.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

o

n

14136

I o



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

|

10792

| 1





1 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.

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

, Load Summary and Errors j
.^Statistical and CritlcaJ Review (Stal CR)"*j

3 Inventory j

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.

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
venerated. 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

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.

0 CDA United states Air Quality Subsystem

Environmental Protection Agency LOdd Report

Load Detail

File Name : Jd_test_pm-1.txt.zip
Screening Group: Idaho

Jul. 23,2013

Site-Monitor ID: 16-041-0001-88101-4 Table Name: ST_RWV_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_R/*W_DATA
Transactions |l |161041 |0009|88101141111051181 (20130401 |01:00|2.1 III III 111111III 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_RWV_DATA
Trans actio HftD |l |16|041 |0009|88101 |4 |11105|181120130401 |02:00|4.5|| 11 II I III II III
Column	Error Description

Multiple Columns Monitor ID (State. County, Site, Parameter, PQC) not in database

Sita'Monitor ID: 16-041-0009-88101-4 Table Name: ST_R/>w_DATA
Trans actio n*D |l |161041 I0009188101 |4 |111051181120130401 |03:001-0.9 II1111111111111

Column	Error Description	Error Code

Mujtjple Columns Monitor ID (State, County, Site, Parameter, POC) not in database	"	-20405 |

v-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 | Stal 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 AQ.S.

•	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 QA 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.epa.Rov/aqsweb/documents/TransactionFormats.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

Section: Annual aries
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
ValGTSec 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 c3 ry IP roto 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

S u irii irii 3 ry M a x i m u m s
S ect i o in:: S u m m c3 ry IM a x i m u m s
Max Level
Max Sample Value
Max Coll Date

S ec t i o in:: S u inn inn 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



OA Transactions

~

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 Monitc jent 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 , iiriiocls

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 - ii ¦- II ¦ iir-riiii II ¦ 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 QA, 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.

Qy aqs

Action Help Session Admin Retrieval Maintenance Critical Rev CErtification Batch Correct Main Menu

El ai i H	11% ¦ « t < ~ * ~~ ± * -a ip ^ ?

55


-------
Query Data

The user will query data from the database in to the form.

l=d AQS

Action Help Session Admin Retrieva

Maintenance

Critical Rev CErtification Batch COrrect Main Menu

Ha * I £ K u H[¥

ft %

¦

« t 4 ~ * ~~ | ± x -a ^ 11? 11

[21 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 any field 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.

|J>|AQS

Action Help Session Admin Retrieval Maintenance Critical Rev CErtification Batch COrrect Main Menu

U sl-H I E3 n HI Jin % | ¦ | « T i	I ±	? \

[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 FIP3 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

~ a n e n ii I % a % I ¦ I « t < ~ * ~~ ± x -a ±] i ^ i ? i

m Correct - Raw Data (National Air Data Group)

State County	Site Parameter	Qualifier Qualifier Qualifier Qualifier Qualifier Qualifier

Code Code	Id Code POC Five	Six	Seven Eight	Nine	Ten

06 - |o29	- ||0007 |42601	- |pj jJ	jJ	jJ	jJ	jJ	- 11?

06 » 1029	||0007 (42601	» 1

06 J029	- l|0007 |42601	- |fl

06 ' ||029	• ||0007 |426d1

06 T [|029	T ||0007 142601	'

06 - 1029	' ||0007 |42601	- |T"

06 * j|029	* j|0007 142601	* 1

06 J029	" ||0007 |42601	- |fl~

06 - |[p29*	- ||0007 |42601	" |[T~

06 ' ||029	- ||0007 142601	- 1R~

JiJ

UDL

i i

if _

—j-

¦if

"jr

~^jr

Unc



Then presses the Search and Replace icon.

UfAQS

Action Help Session Admin Retrieval Maintenance Critical Rev Certification Batch correct Main Menu

H iS -E-

j i

%

5a

a 7 < ~ i ~~

X: "3. i] !P



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 getrieval Maintenance Critical Rev CErtification Batch Correct Main Menu

aa a ssr h 11 a I % h % ¦ « ? < ~ * ~~ ± t -a is ?n

| Correct - Raw Data (National Air Data Group)

County Site Parameter
Code Id Code

029 J_||0007 142601
029" • ||0007 |42601
029" - l|0007 | 42601
029 J 0007 | 4260
029" - |oOQ7 ] 42601
029 * ||0007 |42601
029" 'J0007 |42601 - T~_
029 2JI0007™ [tieoT j; pn
0007 142601 ' IF

0007 |42601 * 11 |

C3 Search and Replace

Qualifier
Six

Qualifier
Seven

Qualifier
Eight

Qualifier
Nine

Qualifier
Ten

"J

"dr _
"Ji—J
"J—J
"di—J

"J



Replace Item |ra w_D
Current Value (5

v.MDL

Column Name

New Value ||

Replace All

Replace

Cancel

M Di-

ll nc

"JF
_Js~

_iF

¦jjr



Jj

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.

Ui)AQS

f

Action Help Session Admi

His I m I ssr e h

n Retrieval Maintenance

m ^ a % i j

Critical Rev CErtification Batch COrrect Main Menu

44 t 4 ~ * | ± x S ^

?



"A

;orrect - Raw Data (National Air Data Group)

Other Correct Features

fflAQS

Action Help Session Admi

Q A 1JE 17% X n

n Retrieval Maintenance

Critical Re\

44 7

CErtification

4 ~ A

Batch Correct Mai
~~ | ± £ ^

Menu

JP 1 ^

?



[2 Correct - Raw Data (National Air Data Group)







[2 Correct - Raw Data (National Air Data Group)

0	^ fes k

±x a

(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 Action Session Duration
Code Code kl Code POC Ird Date Code

:

Column Name

Reported Method
Unit Code

J]_

Delete All Selected

Error Code Error Message

I	I	

Coll RptSamp Null Data C
Time Value Code C

51

ii

"i—J
"I—_

"i—J

"i _



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 will be identical for
all other QA transactions.

Select the Correct / QA Transactions / One-Point QC menu pick.

Main Menu



Site Data



9

a

Monitor Data





Raw









| QA Transactions

1 One Point QC

Blanks



Annual Performance Evaluation

Composite



Semi Annual Flow Rate Audit

Delete by Screening Group

Flow Rate Verification
PM-Coarse Flow Rate Verification





Main Menu



PM Coarse Semi Flow Rate Audit

Performance Evaluation Program

1 	

_ NPAP





Field Proficiency Test





Duplicate

;ment Assessment
Number

Performin
Agency

Replicate

t

Speciation Flow Rate Verification
Speciation Semi Annual Flow Rate Audit
- Pb Analysis Audit

Ml	 I	





i



Lab ProficiencyTest









- Ozone SRP and Standard Transfer Verifications
Ambient Air Protocol Gas Verification Program

IIHB



62


-------
y i> I AQS

[Action Help Session Admin Audit Retrieval Maintain Critical Rev Certification Batch Correct Main Menu

b -a »¦ .a a <%[¦[¦ si ii * 1 bl ± * a ii I % l ?

03 GENERIC CORRECT FORM (National Air Data Group)

Select file to view errors:

Submission
Date

Load OA Data

s_Count

c

1-Point QC











































Monitor
Method

Reported
Unit



Monitor
Cone.

Assessment
Cone.

Null Code

Comment
s ^



1

d Tribe Ind

Code

Code



Number

Code

Dat

e Number

Agency













-f '



_±]

zS

•



•





-



•

r~

-







-

1—

-

|	

-

1 1 B

4





~_J













































BS













































.













































1





























1





























































"ifc

























r~



1















BE

























r~



















)









































































































































1 tjL

























1













































I



















—1 »

























r~

















~

1

























r~

















	



















<1

I









































Ir

OW ERRORS







E M

















i	



























Li





I-

r~

















w

n

1

1



















\r~

i

1

























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 QA 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).

Submitting Corrected 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


-------
On I in-" i!11 .1 . I ¦ ¦¦'I - - ii I .ml '"! i

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

Air Data Gronn:

Basic Site Data j Additional Site Data Agency Roles Tangent Roads Open Paths

Comments

Primary Monitor Periods



Site Identification

State Code |q*|

County Code [055 J |Etowah

Site Id 0003

Status Ind

r

User Coordinates

Horizontal Datum |NAD27	Latitude 134.011111

UTM Zone fie

Standard Coordinates: Datum |

Horizontal Method jo27 	_J |unknown

Horizontal Accuracy ITT

(Meters) '

UTM Easting1587031

Latitude

Longitude (-36.0575

UTM Northing 3763590

Lookup Geography

P

Longitude

Source Map Scale (Non-GPS) [o~~

Vertical Measure 117%

(Meters; l"':,

Vertical Method |qoo

Jf UNKNOWN

Vertical Accuracy [n-

(Meters) 'u

Vertical Datum |UNKNOWN

Street Address jwALNUT PARK FIRE STATION

[Gadsden

Land Use Type	[INDUSTRIAL

City Code	|2S696

Urban Area Code	|iis0 	| |GADSDEN, AL

AQCR Code	|003

e Established I

(YYYYMMDD)

~ Location Setting |URBAN AND CENTER CITY __J

|003

J | EAST ALABAMA



119720101

Time Zone Name |CENTRAL

_J

Mgt







	1

Check Completeness



Create Monitor

D

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

| Maintain - Monitors (National Air Data Group)

Project Class
Meas Scale
Probe Location
Probe Vert Dist
Samp Res Time
Close Date

State
Code

County
Code

m

Dominant Source
Open Path Num
Probe Height
Surrogate Ind
Last Samp Date |19S81001
Monitoring Agency (Owner) fiToi"

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|rjational Air Data Group

Qualifier Code Qualifier Description

r

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

§§]Maintain - Raw Data (National Air Data Group}
Raw Data Comments

State County Site Parameter POC Begin Date: End Date:

Standard Units

Raw Data
Mp ID Date

Stat Reported Standard EPA Action Exclusion Null
Time bid Sample Value Sample Value Ind Ind Ind Data Code Description

Qualifier Code Qualifier Desc

£

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)

- nJi
-------
Maintain Accuracy

^Maintain Accuracy Data (National Air Data Group)



Accuracy Data

State	County Site Parameter POC	Begin Date	End Date

r^j	i _j i ¦ i j i	_d i		i	

Audit Type	Auc Audit Class Acc Date	Year Qtr	Accuracy Type

i	_j I _j i	i r	i _j

Local Pri Std

Audit Sample Id Expiration Date Audit Scheduled Zero Span Value

"J I	 I	 I	 I	

Monitor Protocol

Method

Unit

Duration

Jd r

m r

"J

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


-------
(gf:i

Action Help Session Adn^H^Bt Re'

b a

^Maintain Site (National Air Data Group)

ic Site Data I Additional Site Data Agency Roles Tangent Roads

aintain Critical Rev Certification Batch correct Main Menu

a 7 < ~ * »|± * sip ^I ?

Jo]*]

Open Paths

Comments Primary Monitor Periods

Site Identification

State Code (37 	| |North Carolina

County Code |o01 ~_l | Alamance

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)



_|d|x|

Basic Site Data | Additional Site Data | Agency Roles | Tangent Roads | Open Paths

Comments

I Primary Monitor Periods |





Site 37 |001 J0001

Sequence Num Comment





SUE LOCATED AT FIRE STATION 2 IN BURLINGTON,N.C.

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.

1 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-Point QC

•	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.





Action Help Session Admin Retrieval

Critical Rev C

03 IE %

|Site |

[2IAQS (National Air Data Group)

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

aa m af¥]¦ In< ? < ~ * ~~ i± x a^ ^

?

^Maintain Site (National Air Data Group)

-|n|x|

Basic Site Data

Additional Site Data |

Agency Roles j langent Roads | Open Paths | Comments j Primary Monitor Periods





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 rion-bolded fields.

^ Maintain Site (Re3d Only. Update/Insert not allowed.)





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 I

Latitude
UTM Easting|

Longitude
UTM Northing

Lookup Geography

Standard Coordinates: Datum |

Latitude

Longitude

Horizontal Method

Horizontal Accuracy

(Meters)

Vertical Measure

(Meters)
Vertical Method

jr

Source Map Scale (Non-GPS)

Vertical Accuracy
(Meters)

Vertical Datum

_l

Street Address
Land Use Type

City Code |~
Urban Area Code [
AQCR Code [

Site Established Date

(YYYYMMDD)

Owning Agency





_l

Location Setting



[

L

i



i

r

Time Zone Name

3-j

r

~

H

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

roia JR ^ B 11 m a % ¦: 1 \« t < ~ i ~~ 1 ± X; -a ^ ^

?

^Maintain Site (National Air Data Group)

- njxj

Basic Site Data

Additional Site Data j

Agency Roles | isngent Roads | Open Paths | Comments | Primary Monitor Periods

i



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)





- niJSi

; Basic Site Data; 1 Additional Site Data Agency Roles | Tangent Roads Open Paths |

Comments

| Primary Monitor Periods |



Site Identification

State Code 01

County Code fool 	| |Autauga	Site Id |i 001	Status Ird [

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

|l SUPPORTING

|1108

US EPA^OAQPS



11 |2CC1C1C1H

~1

I

¦ III

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)







- n|x|

i Basic Site Data j

Additional Site Data Agency Roles

Tangent Roads

Open Paths | Comments

Primary Monitor Periods



Site Identification

State Code Joi	|Alabama

County Code (ool J |Autauga

Site Id 1001

Status Ind

F

User Coordinates
Horizontal Datum |NAD27
UTM Zone

	I

Latitude 132.5367
UTM Easting [

Longitude|-S6.6483
UTM Northing

Lookup Geography

Standard Coordinates: Datum |naD83
Horizontal Method

Latitude

32.536B72

Longitude | -86.648285

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



50

|GPS

Source Map Scale (Non-GPS)

50

008

J [other-

Vertical Accuracy kn

(Meters) I

Vertical Datum |MEAN SEA-L _

889 Love Ln

COMMERCIAL

B

Location Setting RURAL



¦_ir

002

"J |COLUMBUS-PHENIX CfTY

20010101

Time Zone Name (CENTRAL



11 OS

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)

^]n]x|

State
Code

County
Code

Monitor Basic

Project Class
Meas Scale
Probe Location
Probe Vert Dist
Samp Res Time
Close Date

foi	|001	11001

J.

'¦i

Dominant Source
Open Path Num
Probe Height [
Surrogate Ind
Last Samp Date
Monitoring Agency (Owner)

F"_J

M

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.

ijy aqs

Action Help Session Admin Retrieval

Critical Rev C

~ a 1 m I t* e h h i %

Site

Monitor
Event

SamPle Values ~
Blanks

Concurrence Ind

[21 AQS (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

HSlf	% af%]| HI I a 7 < ~ 4 » ±. £ m £] ir | ^ | ?

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—_ir

State Code
County Code
Sampler Id
Begin Date

Manufacturer
Model Number
Serial Number

Sampler Channels
Channel

Number Filter Type

Target	Flow Begin End

Flow Rate	Unit Date Date

"_r

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 0 H zi CE3 ^ % B « T 4 ~ *	^ ?

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 set
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 COm

Site



i ~ a ~~ | ±

Monitor





Event





SamPle Values

[[

Raw Data!

Blanks



Composite Data

Concurrence Ind



Delete Preproduction Data

Sile Sampler
OA Assessments

~

c
-------
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

-Ste

County

Sito Haro

HOC gogin Dntoi End Dotoi

IT 1063 _^j 19999 188101

1

Standard Units

|l05

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

h

fi

120140220 00:00

If |2

|2

i ruin i

I*

I

r





I1

-

|20140214 00:00

|P |3

I3

r r





I

-

r

r





h

-

(20140208 00:00

F F~

ill

i i





I

-

r

i











I I

I

rr



r

I





i











I I

r

i i



r

I



I

i 1











I I

i

rr



r

I



I

i











I I

i

i



r

I



r

i











I II

r

r i



r

I



i i

1











I I

r

i i



r

I





i



~







I I

r

rr



r ]~~



i

I J























Qualifier Code

Qualifier Desc

Qualifier Type





-

: " -

1

1

Event Description



¦

— ¦

1

1 ~M\

L



-

r~

1

1

Event Comment



¦





I-

Monitor
Protocol

Method Unit Duration Coll Frequency Alt Mdl

[Tie " |ioT |7

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 Parameter POC Begin Date: End Date: Standard Units

[S7~ J_\ 1063 jJ I&9&9 ISSIOI _J H 1 I



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

IP I2

|2

|

.

r



-







|i

-

(20140214 |00:00

B |3

|3

nil











H



|2(H4020S 06:00

IP n

n

1—!=

rr



n

r
r
r
r
r

r
r





1	

I

I

r



r

I I

I







I 1



i

I I

I	

r i









1 II

i



I

I nil

i m

i i







i

1 II

i



r

I I

i

i 'i







i



i



i

I I

i

r [







i

¦ 1

i



i

I I

i

rr









1

~

i



J

I I

i

i i







I

1 J





















Qualifier Code

Qualifier Desc

i

Qualifier Type

Event Description

Association Date!



ir











I







in















Event Comment







|





—







r

Monitor
Protocol

Method Unit

Duration Coll Frequency

Alt Mdl



Event URL

lis 1105 |?

	J!

J







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.

^ Maintain - Raw D3ta (National Air Data Group)
Raw Data Comments

_j.njx

Standard Units

Raw Data
Mp ID Date

Reported
Sample Value Sample Value In

r

Valid values for Qualifier Code

JXJ

Monitor MeIr
Protocol I116

Duration Coll Frequency

f—i	r

Findj%

Code

loualifier Desc

| Qualifier Type

d

RA

African Dust

REQEXC



RB

Asian Dust

REQEXC



RC

Chem. Spills & Indust. 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

	J

RK

Infrequent Large Gatherings

REQEXC

Jil

<1



i

~J

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.

Critical Rev t

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.

^Maintain Exceptional Events (National Air Data Group)

Define Event	I Associate Raw Data with Event |

Screen Grp Name (National Air Data Group

Qualifier Code Qualifier Description	Event Begin Date Event End Date

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


-------
y>J AQS

Action Help Session Admin 1 Jhlaintenance Critical Rev Certification Batch Correct Main Menu

Hi I ^ -^f5| J a T < ~ * ^111 ±] III ?

^Maintain Exceptional Events (National Air Data Group)

Associate Raw Data with Event

Define Event
Screen Gjfr •""riieiNational Air Data Group







Event Begin Date

T iRH

| Fireworks

]2O140214

Event End Date

120140214

Event

Description

Comment

Firework display

Url

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."

||] Maintain Exceptional Events (National Air Data Group)

Define Event
Event Description

Associate Raw Data with Event;

Firework display
Screen Grp Name

National Air Data Group

Qualifier Code Qualifier Description

RH

State Code County Code Site ID

I _|

Fireworks

Parameter

POC

¦An}*]

Event Begin Date

120140214

Event End Date

|20140214

Query Affected Monitors

Monitor Key

Query By Date Range

Begin Date

Associate All

Disassociate All Reset Actions

# *

End Date Associated Unassociated 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 %

P.lonitor Key

37-06S-9&99-SS101-1

Son

Disassociate
No Action

Find

OK

Cancel



I I

Query Affected Monitors

e All

Disassociate All

Reset Actions

ociated Unassociated Action

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

|20140214 |20140214

1 1

) ILUJ.MMfc!

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 Date Associated Unassociated Action

-*¦ |l37-Q63-99&3-SSHH-1 J20140214 |20140214

|o

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 d

Site

Monitor
Event

SamPle Values

Plankc

~

i



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

aaim ^ * ia m ®[S] $ 11« t < ~ * ~~	^ ?

ra Maintain - EPA Concurrence Indicator (Region 4 Atlanta)

State County site Parameter

137 _jJ 1063 19999 jJ 188101
Screening troup Name

tV6M Iyps

	zl\

Begin Date End Date Applicable NAAQS Standard

M

Concur All

Deny All

Clear All

Concur
Ind

Monitor

Samp Begin
Date-time

Std Samp
Value

Std
Unit

Qualifier
Code

Qualifier Description

Applicable NAAQS
Standard

jk.

1

•

37-06 3-9999-S3101-1

20140214 00:00

|3

1105

|rh

| Fire works

|PM25 24-hour 2006





-

37-063-9999-88101-1

|20140214 00:00

I3

1105

|rh

| Fireworks

|PM25 Annual 2006





-

37-063-9999-88101-1

|20140214 00:00

|3

1105

|rh

| Fireworks

|PM25 24-hour 2013







37-063-9999-88101-1

(20140214 00:00

|3

1105

|rh

(Fireworks

|PM25 Annual 2013







I I

III I







I I

III I







I I

III I







I I

111 I







II I

I I I I

~





I I I I I I

Event Description

Concurrence Comment

| Fire work display
Event Comment

Event Url

Open URL

Concurrence Date

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

h a m	a « t < ~ 4	^ ?

Maintain - EPA Concurrence Indicator (Region 4 Atlanta)









State County sjte Parameter poc

Begin Date

End Date Applicable NAAQS Standard









|37 * I |063 » [9999 1 ||SS101 T |l











I

Screening Group Name Event Type Event Description













1





_LI ill









1





Concur All | Deny All Clear All













Concur

Samp Begin Std Samp

Std

Qualifier





Applicable NAAQS





nd



Monitor Date-time Value

Unit

Code

Qualifier Description



Standard





jk*.

L

•

37-06 3-9999-&3101-1 |20140214 00:00 |3

1105

|rh |

|Fire works



|PM25 24-hour 2006







-

37-063-9999-SS101-1 J20140214 00:00 |3

1105

|rh

| Fireworks



| PM25 Annual 2006







-

37-063-9999-S8101-1 |20140214 00:00 |3

1105

|rh

| Fireworks



|PU25 24-hour 2013







*

37-063-9999-58101 -1 J20140214 00:00 |3

1105

|rh

(Fireworks



|PM25 Annual 2013









I I

I I I

J	—	1









I I

I I I











r r r

II I I











i i

I I I

I









ii I

i ii ii





~





l l ill

I I





















Event Description

Concurrence Comment

Concurrence Date



Inr



display













Event Comment

































Event UrI











1





Open URL































5. If the region agrees with the exclusion they will enter Y in the 'Concur I lid' field.



Concur
nd

Monitor

jk.

Y T

37-063-95





37-063-9*9







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)
Site Sampler

Sampler Owner Agency [[ m	

State Code
County Code
Sampler Id

I-J



j

Site Number

M

Begin Date |

End Date

Number of Channels

_ n x

Manufacturer |
Model Number [~
Serial Number |

Sampler Channels
Channel

Number Filter Type

Target
Flow Rate

Flow
Unit

Begin
Date

* C

End
Date



"IT

Here the user should fill in the relative information.

Sampler Owner Agency	n—ji	r

State Code	~a i

County Code	I 	||	Site Number !

Sampler Id	I		|

Begin Date	j	End Date I	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 j i North Carolina Dept Of Environment And Natural Resources

137-035-0004

State Code

37 | |N0rth Carolina

County Code

035 11Catawba



Site Number

1 Sampler Id

MET-ONE-A



Begin Date

20020101 End Date I

Number of Channels |4

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

113 	|20020101

E id

6.7

QUARTZ

JT

|113 I20020101

pTrs [20020101"

JT

T

~_r

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
MP
MP
MP
MP
MP
MP
MP
MP
MP
MP
MP
MP
MP
MP
MP

|01|073
|01|073
|01|073
|01|073
|01|073
|01|073
|01|073
| 011073
|011073
|01|073
|01|073
|01|073
|01|073
|01|073
|01|073
|01 |073

|0023|
|0023|
|0023|
|0023|
|0023|
|0023|
10023|
10023 |
|0023|
|0023|
|0023|
|0023|
|0023|
|0023|
10023|
0023 |

88104|
88107|
88109|
88110|
88111|
88112|
88113|
88114|
88115|
88117|
88118|
88126|
88128|
88131|
88132 |
88136|

MET-
MET-
MET-
MET-
MET-
MET-
MET-
MET-
MET-
MET-
MET-
MET-
MET-
MET-
MET-
MET-

¦ONE
ONE
ONE
ONE
ONE
¦ONE
ONE
ONE
¦ONE
ONE
ONE
ONE
ONE
¦ONE
ONE
ONE

-A|l
-A|l
-A|l
-A|l
-A|l
-A|l
-A|l
-A|l
-A|l
-A|l
-A|l
-A|l
-A|l
-A|l
-A|l
-All

200101011
20010101|
20010101 |
20010101 |
20010101 |
200101011
20010101|
200101011
20010101 |
20010101 |
20010101 |
20010101 |
20010101 |
200101011
20010101|
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).

3 Standard Report Criteria Selection (National Air Data Group) AMP500
Criteria Set I Data Selection j Sort Order | Report Options j Retrieve Reports j

_=_!~ _xj

Criteria Set |

Owner |michaEL

[brooks

-1 Desc P

Type | PRIVATE

"d

t

y ||Report Name |EXTRACT SfTE/l/QNITOR DAT

Reports

Find[%

Rep_Report_Code

AMP410

AMP410S

AMP395

AMP 6 00

AMP355

G74

AMP435
AMP 430
AMP4S0
AMP504
AMP501
AMP503

AMP230
AMP 440
AMP390
AMP??on



Report_Name

AIR QUALITY INDEX REPORT

.AIR QUALITY SUMM ARY REPORT

AUDIT HISTORY REPORT

CERTIFICATION EVALU ATION .AND CONCL

COMBINED SITE SAMPLE VALUES

CR RAW DATA

DAILY SUMMARY REPORT

DATA COMPLETENESS REPORT

DESIGN VALUE REPORT

EXTRACT OA DATA

EXTRACT RAW DATA

EXTRACT SAMPLE BLANK DATA

EXTRACT SITE/MONITOR DATA

FREQUENCY DISTRIBUTION REPORT
MAXIMUM VALUES REPORT
MONITOR DESCRIPTION REPORT
MONITOR NFTWORK RFPORT ,

Find

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 (1*

Jational Air Data Group) AMP500



- In x

Criteria Set

Data Selection |

Sort Order

Report Options

Retrieve Reports



Monitor / Geographic Criteria

State
Code

County
Code

Site
Id

Parameter
Code

PQC

City
Code

AQCR

UAR

CBSA

CSA

EPA Region

|oi



073 -

0023

-



-

5

1

•



*



-



-



m



—



r



	—

	

—













1



























1





































1













i























1













i i i

i









































































i



	



	













_



_j











_



Protocol Criteria



Date Criteria









_ Parameter









Pollutant Type

| Co
-------
The user will then click on the Report Options tab. Then click the Uncheck All button on the form.

^Standard Report Criteria Selection (National .Air Data Grt

)UDl AMP500

-|n|x|

Criteria Set

Data Selection

Sort Order

[ Report Options |

Retrieve Reports



SITE MONITOR TRANSACTIONS







SITE basic

F

*

ACTION INDICATOR

1 INSERT

^1—





TANGENT STREETS

f?



XML SCHEMA VERSION

|2.2

-ll

OPEN PATHS

f?







MERGE PDF FILES

|yes



MONrrOR BASIC

F



1 J-J

MONrTOR SAMPLE PERIODS

17



! J

MONITOR TYPES

P





MONfTOR AGENCY ROLES

P



| J





MONITOR OBJECTIVES

P?



1 J

MONfTOR SAMPLING SCHEDULES

R





»

1

MONfTOR STREET INFORMATION

P







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

SITE BASIC

r



TANGENT STREETS

r



OPEN PATHS

r



MONfTOR BASIC

pj

		

MONITOR SAMPLE PERIODS

r



MONfTOR TYPES

r



MONfTOR AGENCY ROLES

r



MONfTOR OBJECTIVES

r

1

MONITOR SAMPLING SCHEDULES

r

L

MONfTOR STREET INFORMATION

r



Check All Uncheck All



111


-------
The user will then scroll down and select SITE SAMPLERS and SAMPLER CHANNELS.



SITE MONITOR TRANSACTIONS





MONITOR REGULATORY COMPLIANCES

r



MONfTOR COLLOCATION PERIODS

r



MONfTOR PROTOCOLS

r



MONfTOR METHODS

r



MONfTOR NETWORK AFFILIATIONS

r



PRIMARY MONfTOR PERIODS

r



MONfTOR NAAQS EXLUSIONS

r



SfTE 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

ft AD

Acti on

code

# AE

Acti on

code

# MA

Acti on

code

AD

I

01

073

0023

AD

I

01

073

0023

AE

I

01

073

0023

AE

I

01

073

0023

AE

I

01

073

0023

AE

I

01

073

0023

MA

I

01

073

0023

MA

I

01

073

0023

MA

I

01

073

0023

MA

I

01

073

0023

MA

I

01

073

0023

MA

I

01

073

0023

MA

I

01

073

0023

MA

I

01

073

0023

MA

I

01

073

0023

MA

I

01

073

0023

MA

I

01

073

0023

MA

I

01

073

002 3

MA

I

01

073

0023

MA

I

01

073

0023

MA

I

01

073

002 3

MA

I

01

073

0023

MA

I|01

073

0023

MA

1101

073

0023

MA

1101

073

0023

MA

Ijoi

073

002 3

MA

11 01

073

0023

MA

11 01

073

0023

M fli

T

n-t

A "7 D ! nn-> D

state codelcounty codelsite Number|sampler lD|samp1er owner ]Manuf acturer |Model Numbei

state codelcounty codelsite iDlsampler lD|channe1 Number|FiIter Type|Target Flow Rat'

state codelcounty codelsite id|Parameter|poc|Project cT ass | Dominant source |Measuremei

met-one-a|0013]Met one instruments|sass||4|20010101|

URG-A)0013|URG|3000N|]1|20070503]

MET-ONE-A|1]TEFLON|6.7|118]20010101|

MET-ONE-A|2|NYLON I 6. 71118|200101011

MET-ONE-A j 3 jQUARTZ|6. 71118|200101011

URG-A

68101

68102

68103

68104

68105

68106

88103

188115
i88117

QUARTZ|22|118]20070503|

I I

I I

AREA

NEIGHBORHOOD

Oil
I I

I I .
Ill

llll

Ill
11

I

I TOP OF BUILDING|4|||| | |1|||||0199|||||

I I

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

#	AE|Action codejstate codejcounty codejsite lD|sampler lD|ch.

#	MA|Action codejstate codejcounty codejsite iojPararneter|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 1

MA

I

01

073

0023

88104

5 1 1

MA

I

01

073

0023

88107

5 1 1

MA

I

01

073

0023

88109

5 1 1

MA

I

01

073

0023

88110

5 1 1

MA

I

01

073

0023

88111

5 1 1

MA

I

01

073

0023

88112

5 1 1

MA

I

01

073

0023

88113

5 1 1

MA

I

01

073

0023

88114

5 1 1

MA

I

01

073

0023

88115

5 1 1

MA

I

01

073

0023

88117

5 1 1

MA

I

01

073

0023

88118

5 1 1

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


-------
:ords

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


-------
Data Reports

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

REPORT_NAME

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.

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)	- !~! xl

Criteria Set Data Selection

Sort Order

| Report Options Retrieve Reports

Criteria Set |~

• 1 Desc r





Owner |uiCHAEL |BROOKS

Type 1 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	xj

Find[%

Rep_Report_Code

Report_Name

¦A.

AMP410

AIR QUALITY INDEX REPORT



AMP410S

AIR QUALITV' 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



AMP 50 3

EXTRACT SAMPLE BLANK DATA



AMP 500

EXTRACT SITE/MONITOR DATA



AMP230

FREQUENCY DISTRIBUTION REPORT



AMP440

MAXIMUM VALUES REPORT



AMP390

MDNITflR DESCRIPTION RFPDRT



hi I m



Find



OK

Cancel









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
F 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 I PDF	I

File Name P

119


-------
Data Selection Tab



Criteria Set

| Data Selection ]



Sort Order

Report Options Retrieve Reports







A.
~

State
Code

Count
Code

y

Site
Id

Parameter
Code

u

POC

onitor I Geographic Criteria

City AQCR UAR CBSA
Code Code Code Code

CSA EPA Region
Code Code





1















1



*

LLL









1

—















1





1













r



1



1



1





1

























1

	



1

















r



1



1







1

















r



1



1





	



1

















r



1



1







1

















n



1

_

1



I-

_



1



1















—

Protoc

Pollutant Type

:ol Criteria

Parameter
Code











.*.

Date Criteria

tart Date End Date
YYW MM DD YYYY MM

rrr i n

DD









—

i

JU 1	L 1





1













1



~



1



























Agency Role |PQAO	J

Agency

te Report

Monitor Network

3

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


-------
Dirt

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.

' s.llln III . il 	 I III.' I II,. I Oil

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 1

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


-------
Appendix A

Quick I	ie

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 appear.
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.

126


-------
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


-------