AQS Basics Loading data

1
AQS BasicsLoading data

• Help
• Getting Your Data In Online Updates
• Create a Site and Monitor, Define an Exceptional
  Event
• Data Formats
• Getting Your Data In Batch Overview
• Getting Your Data In When All Goes Well
• Getting Your Data In How to Correct What Went
  Wrong

2
Help

3
Helpdesk User Support

• EPA Helpdesk
• 866-411-4372 or epacallcenter_at_epa.gov
• Levels of support
• Level 1 password resets for AQSProd opens a
  problem ticket
• Level 2 AQS-specific issues ? Pamela and Donnie
• Level 3 server issues ? NCC
• Level 4 software and data issues ? AQS Team
• Exchange Network (EN) Helpdesk
• 888-890-1995 or nodehelpdesk_at_epa.cdx.net
• Supports
• Node (production) password resets / general Node
  support
• When in doubt, call the EPA Helpdesk

4
AQS Team
AQSTeam_at_epa.gov

• Robert Coats, team lead
• Bill Frietsche (QA audits)
• Way Poteat
• Chris Chapman
• Nick Mangus (Data Mart)
• Michael Hamlin (user registration)
• Angie Shatas

5
AQS Regional Contacts

• 1 Wendy McDougall
• [phone]
• 2 Henry Feingersh
• [phone]
• 3 Pauline DeVose
• [phone]
• 4 Darren Palmer
• [phone]
• 5 Jesse McGrath
• [phone]

6 Trisha Curran [phone] 7 James
Regehr [phone] 8 Joe Delwiche (303)
312-6448 9 Fletcher Clover [phone] 10
Jan Noel [phone]
6
AQS Documentation

• Manuals and Guides
• http//www.epa.gov/ttn/airs/airsaqs/manuals/
• Design Value Report (SO2)
• Submit Automation User Guide
• Data Dictionary
• Data Coding Manual
• AQS Input Transaction Formats
• Exceptional Event Tutorial
• Fundamentals User Guide
• Data Retrieval Manual
• Codes and Descriptions
• Memos and Software Release Notes
• http//www.epa.gov/ttn/airs/airsaqs/memos/

New/updated
Near term updates/overhaul
Longer term overhaul
7
From the Application

• Help From the Menu
• Topics
• Short-Cut Keys
• Display Error
• Field-Level Help

8
Getting Your Data In Online Updates

9
What can you update online?What should you?

• Data owned by your Screening Group
• Site/Monitor metadata
• Monitor Begin and End dates
• Exceptional Event definitions
• Exceptional Event other concurrences (RO only)
• Data -- update online if you can narrow it down
• Raw Measurements/Precision Accuracy Data
• Comments

10
Where Do I Start?
Session access You can only see data from
monitors YOU OWN You can change any data that YOU
OWN
11
How to update data online?

• You are in your Screening Group
• Go to Maintenance tab
• Select the type of data you want
• Site OR Monitor OR Event OR Sample Values
• Build the query
• specify filters (just like in Browse) to get
  only the records you want
• Execute the Query
• Scroll through the records and modify as needed
• For Site, Monitor, Event or PA data, can modify
  directly
• For Raw Data, must insert a new record with a
  U (then go through Stat/CR process)
• Save (Look for confirmation message)

12
Form Navigation
Previous Block
Next Block
First Record
Last Record
Previous Record
Next Record
Rollback Changes
Insert Record
Save Changes
Delete Record
Duplicate Record
Clear (Erase) Record
13
Save Rollback

• Rollback
• Throws away all changes back to the last time you
  Saved.
• Cannot undo a Rollback
• Save
• Your changes do not take effect until you save
• Look for the confirmation message at bottom left

14
Online MaintenanceCreate a Site and Monitor
Define an Exceptional Event Get Set up for Data

15
Where Do I Start?
Login
Screening Group Access If you are adding
information to AQS, you must be in a Screening
Group
16
Maintain
Maintain Site ? Create a new site online Maintain
Monitor ? Create new monitor(s) online Maintain
Event ? Define exceptional event(s) Associate
Raw Data with an event
AQS Maintain Form hints When you enter a form
in Maintain with the intent to create a new
record, remember to Cancel Query before
entering any data. Check Completeness will let
you know if any required information is
missing. You must add a monitor when adding a new
site. Use Create Monitor. To add multiple new
monitors, use the Duplicate Monitor
button. Save before leaving the form. Look for
a confirmation message at the bottom left of
screen.
17
Monitoring data to AQS What is required to
set-up a Site?

• Unique Site ID
• Metadata needed
• Latitude and longitude (in decimal degrees)
• Horizontal datum (what datum was used for
  lat/lon?)
• Horizontal method (how was lat/lon measured?)
• Horizontal accuracy (accuracy of lat/lon, in
  meters)
• Vertical measure (elevation, in meters)
• Vertical accuracy (accuracy of elevation, in
  meters)
• Vertical method (how elevation measured?)
• Street address, land use type and location
  setting
• Agency Role (agency that is supporting this site)
• Primary Monitor Period (for PM2.5, lead. SO2, NO2)

18
Maintain Site how to add a site

• You must create a site in AQS before you can
  submit raw data
• Identified by
• State Code-County Code-Site (06-073-5501) OR
  TT-Tribal Code-Site (TT-587-5501)
• Physical location
• Latitude and longitude?
• Street address?
• Local site name?
• Characteristics of the site
• Nearby Streets?
• Open Path Set Up?
• Need a Primary monitor?
• (PM2.5, lead. SO2 or NO2)
• Agency Roles
• Supporting Agency?
• Use the Tabs on the Form
• Basic
• Additional Site Data
• Agency Roles
• Tangent Roads

AQS Form hints Check Completeness will let
you know if any required information is
missing. You must add a monitor when adding a new
site. Use Create Monitor.
19
Monitoring data to AQS What is required to
set-up a Monitor?

• An established Site Parameter code POC
• Basic Monitor (Instrument) information (optional)
• Probe location
• Probe height (height of probe from ground)
• Probe horizontal distance (distance from probe to
  support)
• Probe vertical distance (vert. distance from
  probe to support)
• Sample period begin date
• Monitor type (SLAMS, Tribal, NCORE, IMPROVE. . )
  and begin date
• Agency roles and begin date
• Collecting Agency (who maintains the instrument
  in the field?)
• Analyzing Agency (Who (which lab) analyzes the
  filters?)
• PQAO (Primary Quality Assurance Organization)
  Agency (Who is responsible for QA, audits, etc?)
• Required for all pollutants make start date no
  earlier than 1/1/2007
• Reporting Agency (who reports the data to AQS?)
• Required for all pollutants
• Monitoring objective and applicable geographical
  area
• Required collection frequency and begin date
• Tangent Road
• Collocation information

20
Maintain Monitor how to add a monitor

• You must create a monitor for each parameter that
  will supply raw data
• Identified by
• State Code-County Code-Site-Parameter-Parameter
  Occurrence Code (06-073-5501-42153-1) OR
• TT-Tribal Code-Site-Parameter-POC
  (TT-587-5501-42153-1)
• (Think of the POC as a sequence number)
• About the Measurements for that
  Parameter/Pollutant
• When did Sampling Begin?
• Which Network(s) is this monitor in? (Monitor
  Type)
• Which Agencies run the Monitor?
• What are the Monitoring Objectives?
• Nearby Obstructions?
• Nearby Roads?
• If Collocated, which is the Primary?
• Frequency of Sampling?
• Use the Tabs on the Form
• Monitor Basic
• Sample Periods
• Monitor Type Assignments
• Agency Roles

AQS Form hints To add multiple new monitors,
use the Duplicate Monitor button.
21
Reference Data

• AQS uses codes
• Codes give Information about the Data in AQS
• AQS Codes and Descriptions on AQS website
• Standard Codes Used where Available
• Codes are Used to Identify
• States, Counties, Tribal Lands,
• Pollutants,
• Frequency of collection for a sample
• Length of time a sample represents
• Sample data (qualify the data or explain a null
  value)
• etc

• Parameter Codes
• O3 44201
• NO2 42602
• SO2 hourly 42401
• CO 42101
• PM2.5 88101
• PM10 STP 81102
• Lead (TSP) at LC FRM/FEM 14129
• Lead (PM10) at LC FRM/FEM 85129
• Units of Measure
• 001 µg/m3
• 007 ppm (parts per million)
• 008 ppb (parts per billion

• Collection Frequency Codes
• 1 Every Day
• 3 Every 3rd Day
• 6 Every 6th Day
• Duration Codes
• 7 24 Hours
• 1 1 Hour
• W 8-Hour Running Avg.
• X 24-Hour Block Avg.
• Y 3-Hour Block Avg.

22
Exceptional Events

• What is an exceptional event?
• The Federal Regulations (40 CFR Part 50.14)
  allow Ambient Air Quality Measurements that are
  Exceedances or Violations of the National Ambient
  Air Quality Standards (NAAQS) that are caused by
  an Exceptional Event to be excluded from
  Attainment demonstrations.
• What is the process in AQS?
• Reporting Agency flags data with exceptional
  Event Flag, and submits justification to EPA ?
  you put a request exclusion qualifier on your
  reported Raw Data
• Reporting Agency defines the Exceptional Event ?
  you define an Event in AQS (online only)
• Reporting Agency ties the flagged data to the
  defined Event ? you associate these in AQS
  (online only)
• Regional office either concurs with exclusion or
  non-concurs
• The result?
• AQS computes different summaries (daily,
  quarterly, and annual)
• Summaries either include or exclude the flagged
  data
• Summaries have a unique Exceptional Data Type
  ID
• This affects what shows on reports!
• AQS Reports will show either summary data marked
  with
• EDT ID 0
• 0 No data has been flagged OR
• EDT IDs 1, 2, and 5
• 1 The summary excludes all flagged data
• 2 The summary does not exclude any data
• 5 The summary excludes regionally concurred
  flagged data

23
Maintain Event how to add an event

• Event Identified by
• Screening Group Qualifier Code
• Event Begin and End Dates
• Event Description
• Define Event
• What request exclusion qualifier?
• Begin and end dates? (reqd)
• Description? (reqd)
• Comment (optional)

AQS Form hints Use the dropdowns to help
populate the data fields. Save before leaving
the form.
24
Maintain Event how to add an event

• Event Identified by
• Screening Group Qualifier Code
• Event Begin and End Dates
• Event Description
• Define Event
• What request exclusion qualifier?
• Begin and end dates? (reqd)
• Description? (reqd)
• Comment (optional)

25
Put it into practice Exercise 2.1
26
Data Formats

27
Data Formats Overview

• 2 types supported
• Pipe-delimited format
• 19 different formats one for each type of data
  supported through the system
• Data Input Formats for the Re-engineered AQS
• http//www.epa.gov/ttn/airs/airsaqs/manuals/
• XML
• AQS XML Schema definition can be found at
  http//www.exchangenetwork.net/exchanges/air/aqs.h
  tm

28
Map AQS Transaction Types to AQS screens
AA - AC
MA - MK
RP
RD
RA
RC
RB
29
Transaction Types (Site)
Data Formats
30
Transaction Types (Monitor)
MK Monitor Protocols
MB
MD
MF
MI
MA
MC
ME
MG
MJ
MA
MH
MAI23001000244201103AREAREGIONAL
SCALETOP OF BUILDING411Y22399
Data Formats
31
Transaction Types (Raw Data)
RD

• Virtually all RD is submitted via batch
• Add qualifiers to explain data
• Comments are not supported on RD transaction
• Only way to enter a comment is online

Data Formats
32
Delimited Transaction Common Fields

• Transaction Type always the 1st column
• Action Indicator always the 2nd column
• I INSERT
• U UPDATE
• D DELETE
• State Code always the 3rd column
• County Code always the 4th column
• Site ID always the 5th column

MAI23001000244201103AREAREGIONAL
SCALETOP OF BUILDING411Y22399
32
33
Pipe-Delimited vs XML Example

• AQS Site ID 01-001-9999
• Pollutant Measured Ozone
• POC (assigned as part of the monitor ID) 1
• Does this value already exist in the system? No
• What time period does this sample represent (the
  duration)? hour
• What kind of instrument was used? Dasibi 1008-AH
• When was the sample collected? June 10, 2006
• What time did sample begin (local standard time)
  100 PM
• Sample Concentration 0.050 parts per million
• Other qualifiers that you want to apply to data?
  No
• Would you like to specify an alternate Minimum
  Detection Limit for this sample? No
• Would you like to specify an uncertainty value
  with this sample? No

33
34
RDI0100199994420111007056200606101300
0.050
ltActionRawDataInsertgt ltSiteIdentifierDetailsgt lt
StateCodegt01lt/StateCodegt ltCountyCodegt001lt/County
Codegt ltSiteIdentifiergt9999lt/SiteIdentifiergt lt/S
iteIdentifierDetailsgt ltMonitorIdentifierDetailsgt
ltParameterCodegt44201lt/ParameterCodegt ltParamete
rOccurrenceCodegt1lt/ParameterOccurrenceCodegt lt/Mon
itorIdentifierDetailsgt ltTransactionProtocolDetail
sgt ltDurationCodegt1lt/DurationCodegt ltMethodCodegt
056lt/MethodCodegt ltUnitCodegt007lt/UnitCodegt lt/Tra
nsactionProtocolDetailsgt ltTransactionRDInsertDeta
ilsgt ltObservationDategt20060610lt/ObservationDategt
ltObservationStartTimegt1300lt/ObservationStartTi
megt ltRawValueInsertDetailsgt ltSampleValuegt0.05
0lt/SampleValuegt lt/RawValueInsertDetailsgt lt/Tran
sactionRDInsertDetailsgt lt/ActionRawDataInsertgt
34
Data Formats
35
XML Format

• As you can see, XML looks like HTML, but with
  some changes
• The HTML standard defines a fixed set of tags
  that define the data content and formatting.
• XML allows you to create your own tags, with the
  meanings that you define.
• XML Tradeoffs
• XML files are self describing
• XML files are bigger (100 X bigger, but
  compressible.)
• ENSC will wrap your flat (text) file with an
  XML header

35
36
Getting Your Data InBatch Overview

37
What Do You Mean By Batch Updates?

• Mass entry of data, so faster
• Data in AQS format (from datalogger, Agency
  system, other)
• Send the file to AQS
• Processing of the data happens without your
  interaction
• AQS notifies you via email on job completions
• AQS provides reports at the end of each process

38
Overall Process/Big Picture

• Collect Samples
• Validate the Data
• Format the Data
• Send data file to AQS Using the Exchange Network
  (ENSC)
• Load the data to AQS (includes error checking)
• Correct any errors reprocess
• Metadata non-raw data process is finished
• Raw data (sample measurements) are posted
• Data is then available to the public

Happens Outside of AQS
Raw Data Only
39
What Can Be Input by Batch?

• Can batch load
• Site information (all)
• Monitor information (all)
• Raw data
• Audit (precision bias) data
• Blanks and composite data
• Cannot batch load
• Comments (addl info on sites, monitors, audits,
  raw data values)
• Exceptional event definititions
• EPA concurrences (Regional user only)
• Primary monitor period designations (PM2.5)

40
File Processing with Batch Flow
1. Create file of ambient air data.
2. Transfer the file using the ENSC (Stage)
3. Automatically or manually process the file.

• 4. Either way, same processing steps in AQS.
• Raw Data (Load, Post)
• Non-raw Data (Load)

41
Where Do I Start?
42
Where To Go Next?
Next step is to transfer your file
43
ENSC
You can go directly here and bypass AQS
https//enservices.epa.gov/login.aspx
EN user ID is not your AQS ID it is the email
address on your AQS Security Profile (you
supplied it when you got your AQS account)
Step 1 login
Change in Email address? Call the EN Helpdesk.
Not your AQS pw (unless you manually synced them)
Need a pw reset? Call the EN Helpdesk.
44
ENSC (One time setup)
Step 2 On your first login
Step 3 From the Express Register box, type in
AQS and click on the Search button.
45
ENSC (One time setup)
Step 4 Choose Send Info to establish AQS as
the service that will receive the files.
Step 5 Suggest (optional but recommended) that
you go to the My Services Tab and check Make
this my Start page. This will then be your
starting point each time.
46
ENSC (Express Request)
Each time you submit a file, you will fill out an
Express Request AQS Submit
File to be submitted must be zipped
Supply if you want email notifications separately
from ENSC or if you want emails sent to a 3rd
party emails automatically go to the address in
your AQS profile
AQS ID
Screening group (owner of data)
Final Processing Step - Automate the process by
choosing the last step you want done - Default is
Post Can choose Post for both non-Raw and Raw
Data. If you do not have any errors during the
AQS processing, you are DONE.
Stop on Error Applies to Post. If an error is
encountered, AQS stops processing the file. If
you arent taking Raw Data through POST then this
setting is ignored.
Send Data the last step
This is the only way to messages related to
ENSC problems (Node is down, XML validation
failure) in cases when the file doesnt make it
to AQS.
47
File Processing of Data
R Relational Status S Stat Analysis
P Production Status

• Automatic file processing
• Minimizes time needed to handle a file Submit
  Automation project dont even have to log in to
  AQS
• Final Processing Step Post (ENSC default)
  supports automatic file handling
• Stop on Error Yes (ENSC default) is user
  preference
• Manual file processing
• You must change the defaults on ENSC form
• Final Processing Step Stage or Load
• Then kickoff each subsequent process (Load and/or
  Post) in AQS

48
Getting your Data InFile processing when all
goes wellnon Raw data

49
File Processing of non-Raw Data
R Relational Status S Stat Analysis
P Production Status
50
Batch form - Process by File
Process by file tab Only shows the last process
performed on a file
50
51
Batch form - History
History tab Shows all processes performed on a
file
51
52
Put it into Practice Exercise 2.2

• You will submit a file containing non-raw data
• You will use the Automatic process
• Final processing step Post
• Review the File Processing

52
53
Getting Your Data InFile Processing when all
goes wellRaw data

54
File Processing of Raw Data
Staging Tables
Production Tables - Preproduction Status
Production Tables - Production Status
R Relational Status S Stat Analysis
P Production Status
55
Batch Load step for Raw Data includes Stat CR

• Raw data goes through Statistical Evaluation
  Critical Review
• Evaluates data and flags anomalies.
• anomalies are not necessarily errors
• real errors that fit the rest of the data are not
  necessarily captured
• You are notified of the results of these through
• Stat CR Report
• Compares pre-production data to existing
  production data
• Statistical findings
• Critical Review findings
• Link to report is emailed to you
• Also available via Process by File or History
  tabs
• Scan Report
• Information on maximum values and validity flags
  for raw data
• Link to report is emailed to you
• Available via History tab

• using Shewhart test, Patterns test, and Gap test
  
• see http//www.epa.gov/ttn/airs/aqs/softw/AQSUserG
  uide.pdf

56
Batch Post step for Raw Data

• Raw data must go through Post step
• Makes data production status and publicly
  available
• Required when Raw Data is added or changed
• Online ? Save ? AQS will generate a file that
  you must process using the Batch form
• Batch ? Raw data requires the Post step
• You are notified of what was posted through
• Raw Data Inventory Report
• Information on data fields that were updated
• Reviewed by many submitters some save each
  report
• Link to report is emailed to you
• Also available via History tab

57
Tracking a file Process by File vs. History
Record counts for POST
Record counts for LOAD
Process by file tab shows the last process
performed on a file
List of files
User who ran the last job
Date and time of last process
Last process status
Total record counts for all jobs performed on
this file, not just the last job.
History tab Shows all processes performed on a
file
File name
Process run
Successes
Failures
Date and time of process
58
History
History tab Shows all processes performed on a
file
File name
Process run
Date and time of process
Successes
Failures
59
Stat CR Report

• Stat CR is automatically run after Load for Raw
  Data submissions
• If Job Type is CRST ? Stat CR Report is
  available

Only records that fail a test are reported
Report is stored for 15 days
After 15 days, must rerun
60
Scan Report

• Stat CR is automatically run after Load for Raw
  Data submissions
• If Job Type is CRST ? Scan Report is available

61
Raw Data Inventory Report

• Job Type is POST ? Raw Data Inventory Report is
  available

Report is stored for 15 days
After 15 days, must rerun
62
Put it into Practice Exercise 2.3

• You will submit a mixed file with non-Raw data
  and Raw data
• You will use the Automatic process
• Final processing step Post
• Go into AQS and look at the Batch form
• Process by File
• History

62
63
Getting Your Data InHow to Correct What Went
Wrong

64
Batch load When your file has errors

• AQS checks all incoming data
• Load process looks for relational and formatting
  anomalies
• Any data with errors goes to the Staging Tables
• Data with errors are prevented from getting all
  the way through to the Production Tables

64
65
What to do with failed transactions?
File name
Process run
Date and time of process
Successes
Failures
Final Processing Step Post File had
errors Stop on Error Yes ? all processing
stops Stop on Error No ? good data posts
bad data in Correct
66
Caveats

• A batch load job can end with a status of
  WARNING or ERROR
• WARNING does not prevent data from going into
  AQS
• E.g. Urbanized Area Code replaced by Geospatial
  Lookup
• ERROR does prevent data from going into AQS
• E.g., Invalid Protocol
• You must fix the data before it will go in.
• Some errors are typos/missing metadata
• Some errors require additional knowledge
• E.g., certain parameters (PM2.5, lead, SO2, NO2)
  require a primary monitor designation on the
  Maintain Site form because their data is
  combinable by site

67
Recap
Staging Tables
Production Tables - Preproduction Status
Production Tables - Production Status
R Relational Status S Stat Analysis
P Production Status

• Steps
• If There is No Raw Data and No Errors
• ENSC ? Load
• If There is No Raw Data and Errors
• Load ? Load ? Correct ? Load
• If There is Raw Data and No Errors
• ENSC? Load (includes Stat/CR) ? Post
• If There is Raw Data and Errors
• ENSC ? Load (includes Stat/CR) ? Correct ? Load ?
  Post
• Status of records will change with the steps run

68
Batch load When your file has errors
Staging Tables
Correct
Y
LOAD

• How to fix the data?
• Option 1 Use Correct (online editor that works
  against Staging)
• Option 2 Use Preproduction Report to get data
  back out in the delimited transaction format
  delete Preproduction data fix the transactions
  outside of AQS and resubmit

68
69
Batch load Using Correct to fix Data
Staging Tables

• Form available to correct every type of data
  input record
• Reports available

Correct
Y
LOAD
69
70
Batch load Using Correct Forms
Execute Query This will load all of this type of
data in the Staging tables for your Screening
Group. If you want to limit selection you must
put in selection values before the execute query.
Save
Read the error message(s) Error messages are the
same as in the error details report Many chose to
go straight to the Correct screens rather than
run a report. The column name is sometimes
informative.
Find, Analyze and fix the data Fixing the data
often requires knowledge of the nature of the
data and may require going back to data sources.
Exclude unfixed data Excluding unfixed data will
keep it from raising error flags during load.
70
71
Correct Features

• New transactions may be entered using Correct
  forms
• After making changes/additions on Correct screen,
  SAVE changes
• Delete All Selected button will delete
  according to Execute Query selection criteria
  for the form it will ignore subsequent changes.
• If you are a Screening Group Administrator, can
  use Delete by screening group to completely
  eliminate all records in staging tables for your
  screening group

Be sure this is what you want to do. It works
quickly and it deletes EVERYTHING for the
screening group, including data entered by other
users in your screening group.
71
72
Batch load Using Correct FormsDeleting Data
(cont.)
The highlighted record can be deleted from the
form. The record will be deleted from the Staging
Table database only after a SAVE.
All selected records will be deleted. The records
will be deleted from the Staging Table database
when the button is clicked.
72
73
Batch load Using Correct FormsDeleting Data
(cont.)

• Delete by Screening group

Delete By Screening Group will completely clear
ALL records owned by the Screening Group in the
Staging Tables.
73
74
Search Replace

• Not Search Replace as you may know it!
• Replaces ALL Queried Values in a given column
  Regardless of the Current Value

74
75
Load Corrected Data - Process by File tab

• Once data is corrected
• Load the file again
• Recheck for errors (Recs Failing to Load
  column)
• Identify errors using Load Summary and Error
  report
• Correct residual errors (Correct)
• Repeat until no errors occur

75
76
Exceptional Events

• What is an exceptional event?
• The Federal Regulations (40 CFR Part 50.14)
  allow Ambient Air Quality Measurements that are
  Exceedances or Violations of the National Ambient
  Air Quality Standards (NAAQS) that are caused by
  an Exceptional Event to be excluded from
  Attainment demonstrations.
• These steps are now done
• Reporting Agency flags data with exceptional
  Event Flag, and submits justification to EPA ?
  you put a special qualifier on your Raw Data
  value
• Reporting Agency defines the Exceptional Event ?
  you defined an Event in AQS using Maintain Event
• Time to do the last necessary step for the
  Reporting Agency
• Reporting Agency ties the flagged data to the
  defined Event ? you associate these in AQS using
  Maintain Event (online)
• When this step is complete, then the EPA Regional
  Office can take AQS action.
• Regional office either concurs with exclusion or
  non-concurs

77
Maintain Event how associate data

• Query in the Event
• Screening Group Qualifier Code
• Event Begin and End Dates
• Go to Associate Raw Data with Event tab
• Query Affected Monitors
• Associate Raw Data
• Use Associate All button or
• Do individually using Action dropdown

78
Put it into Practice Exercise 2.4

• You will submit a file with Raw data
• You will use the Automatic process
• Final processing step Post
• Go into AQS and look at the Batch form
• Process by File
• History
• Use the report and Correct to analyze and fix the
  errors
• Site/monitor does not exist
• Overlapping sample data
• Inactive monitor on date of entry
• Invalid Protocol
• Associate Raw data with an Event

78