EPA-454/B-94-009
AIRS User's Guide
Volume AQ5:
Ad hoc Retrieval
CD
"=3-
CL
UJ
U. S. Environmental Protection Agency
Office of Air Quality Planning and Standards
Technical Support Division
National Air Data Branch
Research Triangle Park, North Carolina 27711
February 1994
-------
J
-------
Ad hex: Retrieval
AIRS User's Guide
Volume AQ5
TABLE OF CONTENTS
1.0 INTRODUCTION 1-1
2.0 THE AIR QUALITY DATABASE 2-1
2.1 Database Files Accessed by Ad hoc 2-2
2.2 Archiving Data 2-3
3.0 AIR QUALITY SUBSYSTEM AD HOC BATCH RETRIEVAL 3-1
3.1 Overview 3-1
3.2 General Procedures 3-6
3.2.1 Online Output Generation 3-6
3.2.2 Program Function Keys 3-9
3.2.3 ENTER Key 3-11
3.2.4 Batch Output Generation 3-12
3.2.5 Error Handling 3-20
3.2.6 Report Validation Procedures 3-21
3.3 Detailed Output Generation Procedures 3-22
3.3.1 Ad hoc Batch Report Menu 3-23
3.3.2 Report Criteria 3-25
3.3.3 Submit Report 3-29
3.3.4 Report Options 3-31
3.3.5 Output Fields 3-35
3.3.5.1 Data Listing Output Fields 3-36
3.3.5.2 Cross Tabulation Report Output Description 3-39
3.3.5.3 Cross Tabulation Output Fields 3-40
3.3.5.4 Workfile Output Fields 3-44
3.3.6 Select Criteria 3-47
3.3.7 Sort Criteria 3-52
3.3.8 JCL Parameters 3-55
3.3.9 Batch Job Submission 3-58
3.3.10 Criteria Disposition 3-61
3.4 Optimizing Data Selection 3-65
3.4.1 Field Abbreviations 3-65
3.4.2 Key Fields and File Levels 3-65
3.4.3 Output Criteria 3-65
3.4.4 Selection Criteria 3-66
September 1993
-------
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
List of Figures
Figure 3-1. Sample Data Listing Report 3-3
Figure 3-2. Sample Cross Tabulation Report 3-4
Figure 3-3. Online Steps in Ad hoc Batch Retrieval 3-7
Figure 3-4. Batch Steps in Ad hoc Batch Retrieval Function 3-13
Figure 3-5. Sample Criteria Report - Criteria Listing 3-14
Figure 3-6. Sample Criteria Report - Workfile Listing 3-15
Figure 3-7. Sample Extract Processing Summary Report 3-17
Figure 3-8. Sample Sort Processing Summary Report 3-18
Figure 3-9. Sample Cleanup Processing Summary Report 3-19
Figure 3-10. AIRS AQS Error Screen 3-20
Figure 3-11. Ad hoc Batch Report Screen 3-23
Figure 3-12. Report Criteria Screen 3-26
Figure 3-13. Submit Report Screen 3-29
Figure 3-14. Report Options Screen 3-31
Figure 3-15. Data Listing Output Fields Screen 3-36
Figure 3-16. Cross Tabulation Output Fields Screen 3-40
Figure 3-17. Workfile Output Fields Screen 3-44
Figure 3-18. Select Criteria Screen 3-47
Figure 3-19. Sort Criteria Screen 3-52
Figure 3-20. JCL Parameters Screen 3-55
Figure 3-21. Job Submission Screen 3-58
Figure 3-22. Criteria Disposition Screen 3-62
Appendices
APPENDIX A A-l
Appendix A.I
Field Abbreviation List in Logical Record Sequence A. 1-1
Appendix A.2
Field Abbreviation List in Field Name, File Name Sequence A.2-1
Appendix A.3
Field Abbreviation List in ABBR Sequence A.3-1
Appendix A.4
AQS File Cross-Reference for Common Fields A.4-1
Appendix A.5
File Level, Key Field/Abbreviation Cross-Reference A.5-1
Appendix A.6
Sample Ad hoc Batch Retrieval, Data Listing Report and A.6-1
Workfile - Appendix A.7
Sample Ad hoc Batch Retrieval, Work File Only A.7-1
Appendix A.8
Sample Ad hoc Batch Retrieval, Cross Tabulation Report A.8-1
September 1993
in
-------
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
1.0 INTRODUCTION
This manual explains the procedures used to create custom reports and work files from data stored in the
Air Quality (AQS) and Geographic Common (GCS) Subsystems of the Aerometric Information Retrieval
System (AIRS). AIRS is a computer-based system for handling the storage and retrieval of information
pertaining to airborne pollutants. It is administered by the U.S. Environmental Protection Agency, Office
of Air Quality Planning and Standards, Technical Support Division, National Air Data Branch, located
in Research Triangle Park, North Carolina. AIRS is installed on the IBM computer system at EPA's
National Computer Center in Research Triangle Park, North Carolina. AIRS employs the AD ABAS
database management system to manage its data files and the CICS teleprocessing monitor to provide the
interface between users and programs.
To extract data from the AIRS Air Quality and Geographic Common (Geo-Common) Subsystems, the
AIRS AQS Ad hoc Batch Retrieval is used. This manual provides step-by-step instructions for generating
custom AQS and GCS output. Custom output consists of ANY available AIRS database fields written
to a report or work file as specified by you. You must tell the system what fields to retrieve, and the
order they are to appear on the report and/or in the work file, and, if you are generating a report, what
the report title is and what the field headers are to be.
This manual has been prepared for users that wish to use AIRS AQS Ad hoc retrievals. It has been
written with the assumption that the users are familiar with batch job submission on the NCC-IBM
computer. The assumption has also been made that the users are familiar with the AIRS files and their
relationships. Instructions for logging on to AIRS AQS are provided in the AIRS User's Guide Volume
AQ4, Air Quality Data Retrieval.
This manual is divided into three sections: Introduction, the Air Quality (AQS) Database, and AQS Ad
hoc Batch Retrieval.
September 1993
1-1
Introduction
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
Other AIRS User's Guides that include additional information are as follows:
New Former
Volume Title Volume
AA1 AIRS System Description I
GC1 Geographic-Common Data Dictionary
GC2 Geographic-Common Codes and Values VII
GC3 Geographic-Common Data Storage
GC4 Geographic-Common Data Retrieval VI
AQ1 Air Quality Data Dictionary V
AQ2 Air Quality Data Coding II
AQ3 Air Quality Data Storage III
AQ4 Air Quality Standard Data Retrieval IV
AQ5 Air Quality Ad hoc Retrieval XII
AF1 Facility Data Dictionary
AF2 Facility Data Coding
AF3 Facility Data Storage
AF4 Facility Data Retrieval
AFS Ad hoc and Milestone Reporting
AMI Area/Mobile Source Data Dictionary
AM2 Area/Mobile Source Data Coding
AM3 Area/Mobile Data Storage
AM4 Area/Mobile Data Retrieval
AG1 AIRS Graphics User's Guide
Information about computer center procedures can be found in the 'NCC-IBM User's Guide'. Manuals
about specific software products such as ADABAS and NATURAL are available from software vendors.
Introduction 1-2 September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
2.0 THE AIR QUALITY DATABASE
To use Ad hoc Batch Retrieval you must have a thorough knowledge of the data contained in the AQ
files, and of the process for selecting those records to be included in your output. The information
presented in this section is background material that may help you use this function more effectively.
The AIRS database consists of a number of files, each containing a different type of data. Each file
"belongs" to one of the four main AIRS subsystems: Air Quality, Facility, Area/Mobile Source, and
Geo-Common. Ad hoc Batch Retrieval obtains information from the Air Quality and the Geo-Common
Files.
September 1993
2-1
The Air Quality Database
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
2.1 Pstflbase FilfS Accessed bv Ad hoc
Raw Data
Raw data values, the actual observations of pollutant concentrations or meteorological conditions reported
by monitoring stations, are stored in three files: Hourly, Daily, and Composite. The Hourly File holds
values measured at intervals shorter than 24 hours, the most common interval being one hour. Typically,
these values are measured by automated instruments that continuously measure the pollutant concentration
and derive average values for the hourly sampling interval. The Daily File stores values whose sampling
intervals are 24 hours or more; the most common interval is 24 hours. The values in the Daily File
usually are derived from a chemical analysis of a discrete object, such as a filter paper or a reagent
solution, that has been exposed to the ambient air for the duration of the sampling interval. The
Composite File contains values derived from multiple samples that were combined and analyzed as one.
The sampling intervals and methods of analysis for composite data are generally the same as those used
for data in the Daily File.
Summary Data
Two more Air Quality files hold summary information derived from or related to the reported raw data
values. They are the Summary and SLAMS Files. The Summary File contains quarterly and yearly
summaries of the data reported by each AQ monitor. The summaries are derived from raw data values
in the Hourly, Daily, and Composite Files, and include items of common interest such as the maximum
and the mean pollutant concentrations reported by a monitor. The SLAMS File contains similar annual
summaries for monitors at State and Local Air Monitoring Sites (SLAMS) and National Air Monitoring
Sites (NAMS). The information in the SLAMS File is supplied by the organizations that operate the
sites, who certify its accuracy.
Quality Control/Assurance Data
Three Air Quality files hold precision and accuracy information. They are the P/A Monitor Raw Data,
P/A Monitor Summary, and P/A Summary Files. The P/A Monitor Raw Data File contains precision
and accuracy audit results for monitors for a pollutant. The raw data values reflect the precision and
accuracy of the measurement process from which the measurement data is obtained. The P/A Monitor
Summary File contains yearly and quarterly summary statistics for individual monitors. The P/A RO
Summary File contains information about collective, or average, yearly and quarterly data for all of a
Reporting Organization's monitors, by pollutant. The P/A Monitor Summary and P/A RO Summary
Files monitors are operated by an individual agency, identified by state and reporting organization.
Other Data
Ad hoc Batch Retrieval uses three other database files for reference and control information. The AQ
Site File contains the ID codes and descriptions of all air quality monitors and the sites at which they are
located. The Gee-Common File contains the ID codes and descriptions of the other items used in AIRS,
such as states, pollutants, and units of measurement. Finally, the Table File holds information used to
control and coordinate the various AIRS activities, including Ad hoc Batch Retrieval.
The Air Quality Database 2-2 September 1993
-------
AIRS User's Guide
Volume AQS
Ad hoc Retrieval
Secured Data
AIRS is also capable of handling data considered private by the organization supplying it. Private data
might be produced during a special study. The sponsoring agency may not wish to make the data public
because non-standard techniques were used or because further analysis or investigation is needed. Private
data also might be provided by a corporation or other non-government entity operating its own air quality
monitors.
Access to private data in the AIRS database is restricted by passwords, so that only the organization
providing the data can retrieve it. In all other respects, private data is handled the same as normal, public
data.
The private air quality data is stored in four "secured" files that serve the same functions as their public
counterparts. They are the Hourly, Daily, Composite, and Summary Secured Files. Any Ad hoc Batch
Retrieval that obtains data from the public raw data and Summary files can also access the secured files.
However, the report will retrieve data from a secured file only if the appropriate password has been
provided.
2.2 Archiving Data
Because of the volume of raw Air Quality data, it will eventually be infeasible to store all of it in the
"online" AIRS database. To keep the disk file sizes manageable, older data can be unloaded to tape, or
"archived". Then, if it is necessary to use archived data, the AIRS database administrator can reload it
temporarily into the database.
Currently, the Hourly, Daily, and Composite Files contain all the raw data reported since 1957. There
are few enough values that archiving has not been necessary.
September 1993
2-3
The Air Quality Database
-------
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
3.0 AIR QUALITY SUBSYSTEM AD HOC BATCH RETRIEVAL
3.1 Overview
AQS Ad hoc Batch Retrieval is used to create custom reports and work files from the AIRS GCS and
AQS files. The process of creating a custom report or work file consists of an online component and a
batch component. The retrieval may be a one-time run, or stored with a user-specified name to be used
again. The retrieval criteria are similar to the report criteria for a standard AQS report. Retrieval
criteria consist of report options, output criteria, selection criteria, sort criteria, and JCL parameters.
The online component displays a series of user-friendly screens allowing the specification of retrieval
criteria for data selection and report generation. The batch component generates code to extract data
from the GCS and/or AQS files, perform data sorting, and generate a report and/or work file.
AQS Ad hoc Batch Retrieval can be accessed from option 3 on the AQS Main Menu. Instructions for
logging on to AIRS AQS are provided in the AIRS User's Guide Volume AQ4, Air Quality Data
Retrieval.
Two different types of reports are available. A Data Listing Report (Figure 3-1) lists the values of
specified database fields. A Cross Tabulation Report (Figure 3-2) is a two-dimensional matrix in which
the cells contain the number of records found having the specified values for each of two data fields.
The user must have a thorough knowledge of the data in the database and of the process for selecting
those data records to be included in the output. Steps in custom output design include entering:
the type of output to be developed and the output format;
the selection criteria to be used to limit the scope of the output data;
the sort sequence (fields) and sort order (ascending/descending) of the output data.
Ad hoc Batch Retrieval features include:
single- or double-spaced reports;
reports of up to 131 characters across, or two lines of up to 131 characters for a total of up to 262
characters;
automatically calculated column width for each field on the report and for total report width;
automatically calculated total record length for work files;
default field headers and lengths;
modifiable number of characters to be displayed for alphanumeric fields;
September 1993
3-1
AQS Ad hoc Batch Retrieval
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
subtotaling for Cross Tabulation Reports;
"quick paging" for multiple page criteria screens;
"insert" option for output and/or sort criteria screens;
evaluation condition help feature for the Select Criteria Screen;
maximum of 99 fields for each type of criteria;
abbreviated field names (ABBR) to specify database fields.
AQS Ad hoc Batch Retrieval 3-2 September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
09/24/93
AMP600R1
STATE
ABBR
AL
AL
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CO
CO
DE
FL
Ft
GA
GA
IA
IA
IL
IL
IL
IL
IN
IN
IN
IN
IN
KS
KS
KY
KY
KY
ICY
LA
LA
MA
HA
HA
COUNTY
NAME
MONTGOMERY CO
SHELBY CO
CONTRA COSTA
KERN CO
CC
SAN BERNARDINO CO
SANTA BARBARA
SANTA BARBARA
SANTA BARBARA
SANTA BARBARA
SANTA BARBARA
SANTA BARBARA
SANTA BARBARA
SANTA BARBARA
SANTA BARBARA
SANTA BARBARA
SANTA BARBARA
SUTTER CO
VENTURA CO
VENTURA CO
VENTURA CO
ADAMS CO
ADAMS CO
NEW CASTLE CO
LEON CO
PALM BEACH CO
MUSCOGEE CO
ROCKDALE CO
LINN CO
SCOTT CO
EFFINGHAM CO
NACOUPtN CO
MADISON CO
MONROC CO
HANCOCK CO
KNOX CO
KNOX CO
MARION CO
MORGAN CO
JEFFERSON CO
SEDSHICK CO
BOONE CO
FAYETTE CO
LIVINGSTON CO
MUHLENBERG CO
CAODO PAR
CO
CO
CO
co
CO
CO
CO
CO
CO
CO
CO
EAST BATON ROUGE PAR
HAMPDEN CO
HAMPSHIRE CO
MIDDLESEX CO
EPA AEROMETRIC INFORMATION RETRIEVAL SYSTEM (AIRS)
AIR QUALITY SUBSYSTEM
DATA LISTING REPORT
OZONE SITES CLASSIFIED AS RURAL AGRICULTURAL FOR 1986
CITY
SITE ID POC CODE
011011001 1 00000
011170004 1 00000
060131002 1 06210
06029000? 1 21544
060711101 1 B0994
060831010 1 69196
060831011 37036
060831012 15142
060831013 42524
06083)014 44210
060831015 29238
060831021 11446
060831030 15142
060813001 70182
060834004 82072
060835001 82072
061010002 57750
061110004 57372
061110005 53162
061113001 22370
080013001 00000
080013001 2 00000
100030018 1 00000
120730002 1 00000
120990006 1 00000
132151003
132470001
191131015
191632011
170491001
171170002
171192007
171332001
180590002
180630003
180830004
180970042
181090003
200870001
201730001
210150003
21067000}
211390003
211770005
220170001
220331001
250130003
250150002
250171801
00000
00000
00000
00000
00000
53039
00000
79150
24286
oooc:
0000 0
36000
00000
ooooc
00000
00000
ooooc
00000
00000
00000
00000
00765
01290
68225
CITY NAME
BETHEL ISLAND
EDISON
TWENTYNINE PALMS
SANTA MARIA
JALAMA
CONCEPTION
LOMPOC
LOS PADRES NATIONAL
GAVIOTA
CARPINTERIA
CONCEPCION
SANTA YNEZ
VANOENBERG AFB
VANDENBERG AFB
PLEASANT GROVE
PIRU
OAK VIEW
EL RIG
NILWOOD
WATERLOO
FDP.TVILLE
INDIANAPOLIS
AGAWA"
AMHERST
SUDBURY
STREET
ADDRESS
P.O. BOX 114, GRADY ALA. 36036
BEARDEN FARM
5SS1 BETHEL ISLAND RO, BETHEL ISLAND
JOHNSON FARM. EDISON, CA. 13320
6078 ADOBE RO.. THENTVNINE PALMS
BATTLES-BETTERAVIA RO, SANTA MARIA
JALAMA BEACH COUNTY PARK, JALAMA
POINT CONCEPTION LIGHTHOUSE, CONCEPCION
HS I P FACILITY-500 M SW, LOMPOC
PARADISE RD-LOS PADRES NF
GAVIOTA UEST-NV OF CHEVRON PLANT
GOBERNADOR RD. CARPINTERIA
GOVERNMENT PT. BIXBY RANCH. CONCEPCION
AIRPORT RD.. SANTA YNEZ
POINT ARGUELLO-NE OF SLC. VANDENBERG AFB
yATT RD. VANDENBERG AFB
4SW-7310 PACIFIC AVE. PLEASANT GROVE
2SW, 2815 TELEGRAPH RD. PIRU
5500 CASITAS PASS RD, NEAR OAK VIEW
RIO MESA SCHOOL. EL RIO
78TH AVE 1 STEELE ST - WELBY
78TH AVE I STEELE ST - MELBY
LUMS POND STATE PARK
BRANNERMAN RO AMD TOERR RD. BLDCKERFLA.
STATE ROAD 80 AT TWENTY MILE BEND
COLUMBUS CRIME LAB . US HWY 80. SPUR 22
CONYERS MONASTERY . 3780 GA HWV 212
HWY 13 NORTH OF MARION AT COUNTY HM RD.
HWY Z-30 1.5NILES N. OF ARGO
ROUTE 45 SOUTH. EFFINGNAM
IEPA TRAILER KEATON I DUBOIS
POAG ROAD, EDMARDSVILLE
U.S. OEPT. OF AG. BLOG.
HT VERNON SCHOOLS
1.0 MILES EAST OF 5R 41
PURDUE S.W. AG. CENTER - VINCENNES
8327 MANN ROAD
PARAGON ELENENTARY SCHOOL
FAA STATION
CO. FIRE STATIONI2 ,200 EAST 53RD ST.NORT
JCT KY 338 1 KY 536 EAST BEND K»'
IRON WORKS PIKE. HWt 353 LEXINGTON. KY.
HIGHWAY MAINTENANCE GARAGE US 60
TVA PARADISE 21 4.3 MI SSE PARADISE FP
KAGOOD ROAD ~
HIGHWAY 964
152 SOUTH WESTFIELO STREET, FEEDING HILL
SOLAR HABITAT, UNIVERSITY OF MA
WATER ROW RD GREAT MEADOWS NAT WILDLIFE
1ST
D
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
NAX
.115
.174
.120
.160
.090
.106
.089
.048
.141
.136
.135
.156
.108
.100
.096
.100
.140
.140
.150
.ISO
.071
.162
.120
.083
.102
.110
.165
.082
.097
.117
.121
.146
.116
.103
.116
.115
.112
.117
.110
.090
.141
.148
.130
.073
.100
.153
.127
.»:
.100
PAGE 1
PRIMARY
STANDARD
EXCEEDS
0
3
0
28
0
0
0
0
4
3
1
2
0
0
0
0
1
9
7
5
0
2
0
0
0
0
7
0
0
0
- 0
3
0
0
0
0
0
0
0
0
1
2
2
0
0
2
2
1
0
Figure 3-1. Sample Data Listing Report
September 1993
3-3
AQS Ad hoc Batch Retrieval
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
09/24/93
AMP600R4
EM AEROMETRIC INFORMATION RETRIEVAL SYSTEM (AIRS)
AIR QUALITY SUBSYSTEM
CROSS TABULATION REPORT
MONITOR TK«
PAGE
STATE NAME
CONNECT! CUT
MAINE
MASSACHUSETTS
NEM HAMPSHIRE
RHODE ISLAND
VERMONT
SUBTOTAL
RSN: 01
MONITOR TYPE
HAMS SLAMS OTHER SECURED UNKNOWN TOTAL
33
7
61
6
IS
2
1U
M
96
102
23
41
S62
346
671
80
23
127
1
3
3
0
0
0
2607
531
12SS
50?
424
189
336!
955
2086
690
US
359
124
1809
5S08
7936
NEW JERSEY
NEW YORK
PUERTO RICO
VIRGIN ISLANDS
SUBTOTAL
RGN: 02
35
76
14
0
120
560
44
8
417
758
107
20
1370
2690
526
79
1942
4084
701
107
TOTAL
125
249
742
1230
1302
3111
4665
10173
6834
14770
Figure 3-2. Sample Cross Tabulation Report
AQS Ad hoc Batch Retrieval
3-4
September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Hie abbreviated field name (ABBR) reduces the key strokes in entering fields for retrieval processing and
reduces the potential for error in the entering of the field name. Reference Appendix A for a list of the
field abbreviations foi AQS and GCS databases.
The terms "output specifications" and "report criteria" refer to the selections and specifications you enter
at your terminal that determine the content and characteristics of the Ad hoc report and/or work file.
Output specifications include the criteria for selecting and sorting data, options that affect report format
or the type(s) of output generated, and items pertinent to batch job submission, such as job name and job
priority.
Ad hoc Batch Retrieval provides a way for you to save output specifications for re-use at another time.
If you need to generate the same report periodically (monthly or quarterly) you can recall the saved
output specifications, make minor changes in the date selection, and submit the output specifications
without having to re-enter all the criteria. You may save the report criteria under your own user-ID.
You may subsequently also save these "private" criteria for read-only access by one other user, or by all
Ad hoc users.
A "work file" can be generated instead of, or in addition to, a report. A work file contains the same data
as a report. The purpose of a work file is to facilitate the transfer of information from the AIRS database
to some other entity.
September 1993
3-5
AQS Ad hoc Batch Retrieval
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
3.2 General Procedures
3.2.1 Online Output Generation
Figure 3-3 illustrates the sequence of steps in the online pan of batch retrieval generation. The boxes
in the figure represent the steps involved. Each step has screens that give you instructions, and validate
and accept your output specifications or display an error message if something is wrong. You cannot
proceed to die next screen in the online process until your specifications are valid. When you have
correctly specified the information for one step, the next step is invoked automatically. You can back
up to a previous step if necessary without losing any of the specifications you have entered in the current
step. At any of die four steps (Report Options through JCL Parameters), you can abort the output
generation request and return to the Report Selection step or skip to the Criteria Disposition step. This
allows you either to discard the partial output specifications or to save them.
The following paragraphs briefly describe each step and explain how it relates to the others. A detailed
description of each screen and how to use it is presented in Section 3.3.
Report Selection
The Ad hoc Batch Report Menu is the starting point for all Ad hoc output. Using this screen, you can
either: 1) enter the name of previously stored criteria, 2) enter a question mark (?) to select or delete
criteria from an alphabetical listing of criteria in your library, or 3) enter an asterisk (*) to select criteria
from the public file. You may enter new output criteria/specifications by leaving the criteria name blank.
If you select previously stored criteria that are valid (extra information saved with each set of
specifications indicates whether they have been validated completely when they were saved), a screen will
appear that will ask if you would like to submit the job without changing the criteria. If you say yes,
then the job is submitted and you will be asked for the disposition of the criteria.
Report Options
The Report Options step prompts you to choose the type of output to be generated. Your options are
Data Listing Report, Cross Tabulation Report, and Workfile. When selecting a Data Listing Report, line
spacing and column heading type must be selected. When selecting a Cross Tabulation Report, line
spacing must be specified.
Output Fields
The Output Fields step allows you to specify the fields to appear in your output. The format of these
screens will vary depending on the type of output chosen on the Report Options Screen. For Data Listing
Reports, the Data Listing Output Fields Screen is displayed and you are given the option of specifying
your own field headers, or of using the default field headers. If you choose a work file as the only
output, the Workfile Output Fields Screen is displayed. This screen offers no prompts for field headers.
The Cross Tabulation Output Fields Screen prompts you to specify row, column, and/or subtotal fields;
field headers and field lengths.
AQS Ad hoc Batch Retrieval 3-6 September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
PF9
GrltcrIB
Dfccxwltlon
GIODBI Function Keys
PF3 - ena
- mom menu
PF5 - terminate
PF6 - previous function
PF9 - enter la
gIspositi o n
Enter
OI tar la Name
Figure 3-3. Online Steps in Ad hoc Batch Retrieval
September 1993
3-7
AQS Ad hoc Batch Retrieval
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
Select Criteria
The Select Criteria step allows you to specify what data values are to be extracted from the database and
output on the report and/or work file. These selections generally consist of selections on particular
geographical areas, pollutants, and time periods. Any field and value from the GCS or AQS database
files can be used as a criterion for selecting records of interest. The only restriction is that at least one
key field from the database files must be included in your Select Criteria. This restriction is necessary
to reduce the number of records to be accessed, reducing the batch job run time.
Sort Criteria
The Sort Criteria step allows you to specify the sort sequence and order of your output fields. When the
Sort Criteria Screen is originally displayed, the fields specified on the Output Fields Screen are displayed
as die default sort sequence with an "ascending" sort order. You may change the sequence of fields, and
each field's sort order. However, only the fields specified on the Output Fields Screen can be used as
Sort Criteria. If a Cross Tabulation Report is selected, the sort sequence defaults to subtotal, row, and
column, and the Son Criteria Screen is not displayed.
JCL Parameters
The next step is to establish the JCL Parameters for the batch job. The JCL Parameter Screen is used
for the entry of these parameters. The parameters include items such as job name, account code, and job
priority. Default values are displayed for all items.
JobSubmission
The Job Submission step generates a batch jobstream based on your report criteria and JCL parameters,
then submits a batch job to generate the output. This step does not display a screen unless an error
occurs during job submission. (This is an extremely rare event.)
Criteria Disposition
The last step of the online component allows you to save your output specifications. After you indicate
your choice on the Criteria Disposition Screen, control returns to the Ad hoc Batch Report Menu. You
can select other output criteria or exit from AQS Ad hoc Batch Retrieval back to the AIRS AQS Main
Menu.
AQS Ad hoc Batch Retrieval 3-8 September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
3.2.2 Program Function Keys
Ad hoc Batch Retrieval uses nine program function (PF) keys. These keys enable you to:
insert new ABBRs into existing criteria;
display defaults;
move from one screen to another within Ad hoc Batch Retrieval;
move from one screen "page" to another;
cancel an Ad hoc Batch Retrieval;
terminate your AIRS session.
Not al! PF keys are available for every screen. The PF key options available for a particular screen are
listed across the bottom of the screen. If you should attempt to use a PF key that is not available, an
error message is displayed at the top of the screen, The PF keys used by the Ad hoc Batch Retrieval
Function are described below.
PF1 The PF1 key enables you to insert a field ABBR into existing Output or Sort Criteria. This
option is available on the Data Listing and ABBR Workfile Output Fields Screens and the
Sort Criteria Screen. A field may be inserted after any existing field, except the last field,
by positioning your cursor anywhere on an existing field ABBR and pressing the PF1 key.
Immediately after the field ABBR indicated by your cursor, a blank line for a field ABBR
will appear. To insert a field before the first field, position your cursor on the first
character of the first field ABBR, backspace one position, and press PFI.
PF2 The PF2 key enables you to display the default lengths and/or headers for fields listed on
your Output Fields Screens. When you press the PF2 key, defaults for all the fields
specified on the Output Fields Screen are retrieved. Default lengths and headers are
displayed only for fields that do not already have a value specified.
When an output field header or length specification is left blank, the default is automatically
retrieved for your output. The PF2 key option is not required in order to use defaults in
your output; it only allows you to see what the defaults are.
PF3 The PF3 key option is available on all AIRS screens; when this option is used in Ad hoc
Batch Retrieval before saving your criteria, all new specifications entered are lost. The PF3
key:
returns to the AQS Ad hoc Batch Report Menu from all Ad hoc Batch Retrieval
screens;
returns to the AQS Main Menu from the AQS Ad hoc Batch Report Menu;
September 1993
3-9
AQS Ad hoc Batch Retrieval
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
PF4 The PF4 key option is available on all AIRS screens. When this option is used in Ad hoc
Batch Retrieval before saving your criteria, all new specifications entered are lost. The PF4
key:
returns to the AQS Main Menu from all Ad hoc Batch Retrieval Screens;
returns to the AIRS Subsystem Menu from the AQS Main Menu.
PF5 The PF5 key option is available on all AIRS screens. The PF5 key terminates your AIRS
session. When this option is .used in Ad hoc Batch Retrieval before saving your criteria,
all new specifications entered are lost.
PF6 The PF6 key saves your specifications from the current screen without validating it first,
and redisplays the previous screen. This option is available on the Output Fields, Selection
Criteria, Son Criteria, JCL Parameters, and Job Disposition Screens.
PF7 The PF7 key is available on those screens consisting of multiple pages. It allows you to
scroll backward through your criteria, one page at a time. Before displaying the previous
page, specifications on the current page are validated. When the first error is detected, the
current screen is redisplayed with the cursor positioned on the invalid field. A message at
the top of the screen describes the error. After correcting the error, pressing PF7 again will
cause the previous screen to be displayed. The PF7 key is not a valid option for the first
page of a multiple-page screen.
PF8 The PF8 key is available on those screens consisting of multiple pages. It allows you to
scroll forward through your criteria, one page at a time. Before displaying the next page,
the specifications on the current page are validated. When the first error is detected, the
current page is redisplayed with the cursor positioned on the invalid field. A message at
the top of the screen describes the error. After correcting the error, pressing PF8 again will
cause the next screen to be displayed. The PF8 key is not a valid option for the last page
of a multiple-page screen.
Screen pages must be filled .in sequence. You may only page forward from a full screen.
If you use the PF8 key after erasing specifications from one or more screen entries, the
program fills the erased lines by moving up subsequent lines, and displays the modified
screen rather than paging forward. Lines are moved up from following screens to fill the
lines at the bottom of the modified screen.
PF9 The PF9 key skips to the Criteria Disposition Screen. It allows you to save output criteria
without submitting a batch job and without validating your specifications. You may save
criteria from any screen that allows you to enter output specifications. This includes the
Report Options, Output Fields, Selection Criteria, Sort Criteria, and JCL Parameters
Screens.
AQS Ad hoc Batch Retrieval 3-10 September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
3.2.3 ENTER Key
The ENTER key causes the input on the displayed screen to be validated. If your entries are correct,
ENTER moves you to the next step in the process. If an error in your criteria is detected, the screen is
redisplayed. The cursor is positioned on the first error detected and a message is displayed at the top of
the screen to describe the error. When your specifications have passed all edits, the Ad hoc Batch
Retrieval Function proceeds to the next step and displays the next screen.
Be careful not to use ENTER prematurely. For instance, suppose you have filled the first page of a
screen with criteria and you intend to enter more on the second page, but you want to validate the criteria
first. You should use the PF8 key, not ENTER. If your criteria are valid and you press ENTER, the
current step ends, and the next step is invoked and a different type of screen is displayed. (However,
you can return to the first page of the previous screen by using the PF6 key.)
September 1993
3-11
AQS Ad hoc Batch Retrieval
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
3.2.4 Batch Output Generation
Figure 3-4 illustrates a typical sequence of events in the batch part 01 retrieval generation. The boxes
in the figure represent the processes involved, which generally correspond to steps in the batch job.
Unless an error occurs during the batch processing, each step executes in sequence. Each step generates
a short report summarizing its processing. These "processing summary" reports can serve as an audit
trail in case of ambiguities or problems with the output.
The following paragraphs briefly describe each step and explain how it relates to other steps.
Generate Code
The Code Generator step evaluates the report criteria and generates an ADABAS/NATURAL program
to produce the required output. This program is executed in the next step, Data Extraction.
A Criteria Listing Report (Figure 3-5) is printed that lists the specifications from the Report Options,
Output Fields, Selection Criteria, and Sort Criteria Screens. For fields included on the Output Fields
Screen without a user-entered field length and header specification, the default length and header are
provided.
Although you do not have the option of specifying Sort Criteria for a Cross Tabulation Report, the default
Sort Criteria are included in the Criteria Listing Report. Cross Tabulation Report fields are always sorted
in ascending order and in subtotal, row, and column sequence.
If a work file was specified on the Report Options Screen, the name of the work file is included in the
Criteria Listing. A Workfile Listing is also generated. The Workfile Listing (Figure 3-6) provides a
layout, or format, of work file records that includes the following:
the starting position of each field;
the field definition: Format
X = alphanumeric
9 = numeric
S = signed numeric
. = position of imbedded decimal point,
Length
indicated within parentheses
the field abbreviation;
the field description.
the AQS or GCS field name, or "system-generated" to indicate a field created by the software; and
the name of the AQS or GCS file that contains the field.
When you have requested both a work file and a report, the work file record length will match the report
length. A "filler" will be included as the last field in your work file to bring the length to 131 or, for
a double-spaced two-line Data Listing Report, to 262 characters.
AQS Ad hoc Batch Retrieval 3-12 September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Ad hoc
Report Criteria
Generate
Code
Data
Extract
Data
Son i ng
Cr i ter ia
Cleanup
Criteria Reports
Cr i ter i a L i st i ng
Workf Me List i ng
Extract Processing
Summary Report
Sort Processing
Summary Report
Data
Report
i ng
C ust om i z ed Repor t
Cleanup Process
Summary Report
Figure 3-4. Batch Steps in Ad hoc Batch Retrieval Function
September 1993
3-13
AQS Ad hoc Batch Retrieval
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
09/24/93
AHSS92CG
RETORT :
FORMAT :
TITLE t
COMMENTS:
EM AEROMETRIC INFORMATION RETRIEVAL SYSTEM (AIRS)
AIR QUALITY SUBSrSTEM
AD HOC REPORT CRITERIA
CRITERIA LISTING
PAGE
CROSS TABULATION
SINGLE SPACED
MONITOR TYPE
THIS CRITERIA 6ENERATES A CROSS TABULATION REPORT GIVING
A COUNT OF MONITOR TYPES FOR REGION 1 AKD 2.
THIS CRITERIA HILL BE SAVED WITH THE NAME 'REGNHON'.
OUTPUT FIELDS
ABBR LENGTH HEADER I HEADER 2 HEADER 3
ABBR
-- SELECT CRITERIA
COND VALUE
ROW : STNH
COLUMN : NTYM
SUBTOTAL: RGCD
MONITOR
- COLUMN INFORMATION -
VALUE
STATE NAME
TYPE
RGN
1. RGCO GE 01
I. RGCD LE 02
3.
-- SORT —
ABBR (A/D)
RGCD A
STNM A
MTTM A
1. 1
2. 2
3. 3
4. 9
5. 0
HEADER
HAMS
SLAMS
OTHER
SECURED
UNKNOWN
Figure 3-5. Sample Criteria Report - Criteria Listing
AQS Ad hoc Batch Retrieval
3-14
September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
09/24/93
AHS691CG
EPA AEROMETRJC INFORMATION RETRIEVAL SYSTEM
AIR QUALITY SUBSYSTEM
AD HOC REPORT CRITERIA
WRKFILE LISTIN3
(AIRS)
PAGE
UORKFILE : PKBA5WD.OZONE.SITES.RURAL.AGR1RURL
RECORD FORMAT-. FE
RECORD LENGTH: 131
SLOCK StZE : 11397
FIRST FIELD FIELD
BYTE DEFINITION ABBR COMMENTS
AQS/GCS FIELD NAME
AQS/GCS FILE NAME
I 1(2] STAB STATE ABBREVIATION STATE-ABBREV
3 X(20) ARNC COUNTY NAME iysteii-gcncr
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
Data Extract
Your Select Criteria are used to search the database. When records meeting your Select Criteria are
found, values for those fields specified on your Output Fields Screen are copied from the database record
to a work file. The Ad hoc Extract Processing Summary Report (Figure 3-7) will notify you of the
number of work file records created by the data extraction step.
Data Sorting
Once the work file has been created, it must be sorted. Sorting the data selected for your output serves
two purposes. First, it arranges the information in an order that is compatible with the output format and
suits your needs. Second, if a Cross Tabulation Report was not selected, it ensures that there are no
duplicate entries in die output. (Duplicates could occur if your Selection Criteria caused the same data
to be selected more than once.)
If you select a work file as an output option, the sorted work file is retained as a catalogued dataset with
the name you specified. Otherwise, the work file is discarded at the end of the report generation batch
job.
Sort statistics are printed at the end of this step. This report lists the number of work file records sorted.
Figure 3-8 contains a sample Sort Processing Summary Report.
Data Reporting
The last main step of an Ad hoc Batch Retrieval job, after data selection and sorting, is the generation
of the custom report. The information appearing in a report comes from the sorted work file. A sorted
work file record corresponds to a logical entry of the report. Cross Tabulation Reports may also include
simple summary statistics (subtotals and totals) which are printed at significant breaks in the report. See
Figures 3-1 and 3-2 for a sample of the Data Listing and Cross Tabulation Reports.
Criteria Cleanup
The final phase of a batch retrieval generation is called "cleanup". When you request generation of an
Ad hoc output, the online programs create a "temporary" record in a file that holds your output
specifications. The batch programs use that information to generate the output. Since the record is no
longer needed after the output has been generated, the Cleanup Program deletes it from the file and
creates a record for system usage monitoring. The Cleanup Processing Summary Report (Figure 3-9)
identifies which records were deleted and created.
AQS Ad hoc Batch Retrieval 3-16 September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
09/24/93
EXTRACT
EPA AEROMETRIC INFORMATION RETRIEVAL SYSTEM (AIRS)
AIR QUALITY SUBSYSTEM
AD HOC EXTRACT PROCESSING SUMMARY
PAGE 1
114 RECORDS WERE WRITTEN TO THE UORXFIU
« • 'THE EXTRACT PROGRAM ( AMPKBS42 ) ENDED ON 09/24/93 AT 09:20:01.3
Figure 3-7. Sample Extract Processing Summary Report
September 1993
3-17
AQS Ad hoc Batch Retrieval
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
PLSORT OS SORT/MERGE REL 6.3-Z560E POKTYPE/SORT /SORT 09/24/93 09:39:17
PLS05JI SYSIN:
P1S3411; SORT FORNAT.CH,
PLS341I-. riELOS-(22.2.A.t.20,A.Zl.l.A)
PU034I SORT IN LRECL • 131. RECFN » FB. BLKSIZE • 11397
PL5104I HOWRY USED 1S48K, RESERVED 81
PLS313I RCO LENGTH IN 131. OUT 131
PLS034I SORTOUT LRECL • 131. RECFN • FB. BLKSIZE - 11397
PLS095I USABLE SORTVORK PRIHART SPACE • 4.094.400 BYTES. INCLUDING 2.047.200 IN HIPERSPACE
PL5096I NNAX ESTIMATE • 31.254 RCDS
PLS082I END SORT PHASE
PLSOB1I ENO SORT/MERGE. RCOS IN 14.770 OUT 14.770
PLS083I BYTES OUT 1,934.870
Figure 3-8. Sample Sort Processing Summary Report
AQS Ad hoc Batch Retrieval 3-18 September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
09/24/93
AKP600CU
EPA AEROMETfilC INFORMATION RETRIEVAL SrSTEK (AIRS)
AIR QUALITY SUBSYSTEM
AD HOC CLEANUP PROCESSING SUMMARY
PAGE 1
MSN
000614*4
N/A
N/A
00288067
RECORD TYPE
ADKOC-REPORT
ADHOC-ELEMENT
AOHOC-FILE
'G'
USER
ID
PKB
PKB
RECORD/REPORT
NAME
A9354S8
AMP600
REPORT
SELECT/REQUEST
DATE
09/24/93
09/24/93
ACTION
DELETED
ADDED
• * * PROGRAM AMP600CU TERMINATED SUCCESSFULLY ON 09/Z4/93 AT 09:39:32.7
Figure 3-9. Sample Cleanup Processing Summary Report
September 1993
3-19
AQS Ad hoc Batch Retrieval
-------
AIRS User's Guide
Ad hoc Retrieval Volume: AQ5
3.2.5 Error Handling
The programs for Ad hoc batch output generation are designed to detect errors and take appropriate
action. However, there are some error conditions that either could not be anticipated during program
design or cannot be "fixed" by you or the program. Such error conditions might arise due to a flaw in
the program, internal problems with the database or NATURAL, or hardware malfunctions,
If one of these "abnormal" errors occurs while you are using the online component of Ad hoc Batch
Retrieval, one of two things will occur. If the error condition is relatively benign, a message may appear
at the top of the screen mat includes "NATxxxx", where "xxxx" is a NATURAL error number. (This
is similar to the message you get on some screens when you use an invalid PF key.) You should try to
interpret the message and take the necessary action to correct the error.
If the error condition is serious enough to disrupt normal operation of the output program, the AIRS
Error Screen shown in Figure 3-10 will appear. There is nothing you can do to recover when this error
screen appears. Record the information on the screen (or print a screen image), press ENTER to
terminate your AIRS session, and contact the AIRS database administrator. (See Volume AA1 of the
AIRS User's Guide for the phone number and address.)
04/01/90 AIRS Error 19:04:58
An AIRS Program detected a Natural Error.
Record the information shown below and call the ADSA.
ERROR NUMBER: 131B
LINE NUMBER : 1200
PROGRAM NAME: AMS600E
Press ENTER to terminate.
Figure 3-10. AIRS AQS Error Screen
AQS Ad hoc Batch Retrieval 3-20 September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
3.2.6 Report Validation Procedures
All of the outputs of Ac hoc Batch Retrieval are generated by batch jobs that use specifications you enter
at your terminal for selecting and sorting data and for generating reports and/or flies. There are no
facilities within AIRS for monitoring the status of the batch jobs that you submit. NCC provides two
programs, or "processors", that you can use for checking the status of batch jobs and for viewing the
output before it is printed. These programs are SYSD for CICS and SDSF for TSO. Instructions for
using them are presented in Volume AQ3 of the AIRS User's Guide.
September 1993
3-21
AQS Ad hoc Batch Retrieval
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
3.3 Detailed Output Generation Procedures
To access the AQS Ad hoc Batch Retrieval, select Option 3 on the AIRS Air Quality Subsystem Main
Menu. This section describes the overall procedures for using the screens to specify output options,
select criteria, son criteria, and JCL parameters for Ad hoc Batch Retrievals, and how to save those
specifications. This section explains the mechanics of using the screens, which are similar to the standard
report screens discussed in Volume AQ4 of the AIRS User's Guide.
AQS Ad hoc Batch Retrieval 3-22 September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
3.3.1 Ad hoc Batch Report Menu
From the Ad hoc Batch Report Menu you can indicate that you want to create new output criteria, or you
can select previously stored output criteria to be reviewed, selected, and, depending on the criteria type
(i.e., user or public), modified, or deleted. Figure 3-11 contains a sample screen.
01/19/93
AIRS Air Ouality Subsystem
Ad Hoc Batch Report
AHP600
Please Enter Criteria Name, 7 or • (Optional):
?«user criteMa *=public criteria PF3=end PF4=main menu PF5=terminate
Figure 3-11. Ad hoc Batch Report Screen
September 1993
3-23
AQS Ad hoc Batch Retrieval
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
Instructions
You may enter one of the following responses on the Ad hoc Batch Report Menu and the resulting actions
are:
< blank > display of the Report Option Screen with defaults for new criteria
< criteria name> retrieval of named criteria from the user's library:
- valid criteria, Submit Report Screen is displayed
- non-valid criteria, Report Options Screen is displayed
? display of the Report Criteria Screen with an alphabetic listing of
your existing criteria
* display of the Report Criteria Screen with an alphabetic listing of
criteria available from the public library.
After entering the appropriate response, press the ENTER key to validate your response and to proceed
to the next screen.
Valid PF keys for the Ad hoc Batch Report Menu and the resulting actions are:
PF3 return to the AQS Main Menu
PF4 return to the AQS Main Menu
PF5 terminate the AIRS session
Using any of these PF keys terminates your report request; a report will not be generated.
Error Messages
When you enter an invalid response, or use a PF key not defined for the Ad hoc Batch Report Menu, a
message is displayed at the top of the screen to explain the error. Error messages are listed below in
alphabetical order.
NO CRITERIA NAMES AVAILABLE
You entered a "?" or an "*" to list existing private or public criteria and there are no existing
criteria.
PLEASE USE A VALID PF-KEY
You pressed a key that is not listed at the bottom of the screen.
THIS CRITERIA NAME IS NOT ON FILE
You have entered a criteria name that does not exist.
AQS Ad hoc Batch Retrieval 3-24 September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
3.3.2 Report Criteria
When you enter a question mark (? - Your library) or an asterisk (* - Public library) on the Ad hoc Batch
Report Screen, the Ad hoc Report Criteria Screen is displayed. Figure 3-12 (1,2, and 3) contains sample
screens. The screen lists up to 300 saved criteria names. Any existing criteria are listed in alphabetical
order, along with the date of last access and the report title. The date of last access reflects the latest of
the dates the criteria were created, the date last modified, or the date last submitted.
A highlighted message in the bottom left corner of your screen indicates whether the list of criteria names
continues on the next page. MORE CRITERIA NAMES indicates at least one more page is required to
list the criteria names. END OF CRITERIA NAMES indicates this is the last page used to list the
criteria names. The "or page number in the bottom right corner of this screen reminds you of the total
number of pages required to list the criteria names.
Instructions
You may enter one of the following options (in the "O" column) on the Report Criteria Screen. The
resulting actions are listed below.
< blank > display of the Report Options Screen with defaults for new criteria
S retrieval of criteria:
- valid criteria, Submit Report Screen is displayed
- non-valid criteria. Report Options Screen is displayed
D immediate deletion of marked criteria; you may delete any or all criteria listed
Note: Option "D" is not available if you entered "*" to list the public library.
? list criteria identity information. The data last submitted, date last modified, title,
and comment lines 1 - 4 are listed in a separate window (see Figure 3-12 (3 of 3)).
If the first three characters of the criteria name represent a user-id, the name and
phone number of the user also will be listed
Warning
Temporary criteria are created for each batch job submitted. The temporary criteria are
created with a criteria name beginning with an 'A* and trailed by numerical digits (e.g.,
A9999999). They are used and automatically deleted at completion of the batch job. If you
should delete temporary criteria before completion of the batch job, a 99001 error will be
generated and the job will not complete successfully. If the job is not completed
successfully, the user should delete the temporary criteria by entering "D" on the Report
Criteria Screen.
September 1993
3-25
AQS Ad hoc Batch Retrieval
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
04/06/90
Criteria
0 Naoe
JWB220
JWB230
JWB240
JHB260
JUB275
JWB280
JWB282
JUB300
JUB310
JWB350
JHB355
JWB370
~ JUB380
AIRS Air
Ad Hoc Report
Date of Last
Access
07/25/89
07/03/89
06/08/89
03/07/89
04/14/89
02/22/89
10/02/89
04/26/89
06/12/89
12/12/89
06/20/89
10/02/89
06/09/89
MORE CRITERIA NAMES
S=select D*delete
?»info PF3=end
Quality Subsystem
Criteria For User JWB
Report Title
AGENCY DESCRIPTION
OZONE SITES CLASSIFIED AS RURAL
FIPS AREA
ATTAINMENT DESCRIPTIONS
COLLECTION ANALYSIS DESCRIPTIONS
COMPOSITE SECURED DATA
COMPOSITE DESCRIPTIONS
DAILY SECURED
ROAD TYPE DESCRIPTION
DAILY DESCRIPTIONS
GEO-COMMON AGENCY RECORD
AHP600
GEO- COMMON COLLECTION-ANALYSIS RECORD
AIR QUALITY CONTROL REGION
Page 1
PF4>nain PF5=tertninate PF7=b»ck
Of 4
PF8=n»re
02/04/93
AIRS Air Quality Subsystem
Ad Hoc Report Criteria For ACS Public file
Report Title
AGENCY DESCRIPTION
OZONE SITES CLASSIFIED AS RURAL
FIPS AREA
ATTAINMENT DESCRIPTIONS
COLLECTION ANALYSIS DESCRIPTIONS
Date of Last
Access
07/25/89
07/03/89
06/08/89
03/07/89
04/14/89
AMP600
Criteria
Name
JUB220
JWB230
JUB240
JWB260
JW8275
END OF CRITERIA MANES
S^select D'delete ?»info
PF3*end PF4=main PF5=tenninate
Page 4 of 4
PF7=beek PF8=nwre
Figure 3-12. Report Criteria Screen (1 of 3) and (2 of 3)
AQS Ad hoc Batch Retrieval
3-26
September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
After entering your response, if applicable, press the ENTER key to validate your response and to
proceed to the next screen.
You may skip from one "page" to another, by changing the highlighted page number and pressing
ENTER.
Valid PF keys for the Report Criteria Screen and the resulting actions are:
PF3
PF4
PF5
PF7
PF8
return to the AQS Ad hoc Batch Report Menu
return to the AIRS AQS Main Menu
terminate the AIRS session
display the previous Report Criteria page
display the next Report Criteria page
Using the PF3, PF4, or PF5 key terminates your report request; a report will not be generated.
10/22/92
AIRS Air Quality Subsystem
Ad Hoc Report Criteria for User
AMP600
NHJ
Crii
N
BL*
NEW
NHJ
NHJ
PUB
AJthor: BOB LYON
Telephone: 919) 406-5005
BLYTEST1 Last Modified: 92/09/25 Last Submitted: / /
Title:
FR1. 9.25 11:U COPY NHJYUCB AS BLYTEST1 AS IF COPIED BY BLY
THIS IS A TEST USER CRITERIA. UP TO FOUR LINES OF USER-
ENTERED COMMENTS HAY BE ENTERED BY THE USER ON THE REPORT
OPTIONS SCREEN. THESE ARE DISPLAYED WHEN '?' IS ENTERED
ON THE CRITERIA SCREEN.
Press ENTER To Continue
S If
TO NH
UB TO
END OF CRITERIA NAMES
S'select 0«d«lete ?=nnfo PF3=end PF4=main
Page 1 of 1
= terminste PF7=back PF8*more
Figure 3-12. Report Criteria Screen (3 of 3)
September 1993
3-27
AQS Ad hoc Batch Retrieval
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
Error Messages
When you press ENTER, PF7, or PF8, your responses on all pages of the Report Criteria Screen are
validated. If you have incorrectly specified the selection or deletion of criteria, the screen is redisplayed
and the cursor is positioned on the entry which caused the error. A message at the top of the screen
explains the error. A message may also appear at the top of the screen if you make an error, such as
using a PF key that is not defined for the Report Criteria Screen. Error messages are listed below in
alphabetical order.
AUTO PAGING INVALID WITH
You have changed the screen page number and pressed either the PF7 or PF8 key. Only the
ENTER key is valid with the auto paging option.
DELETIONS FROM THE PUBLIC LIBRARY ARE RESTRICTED. CONTACT ADBA.
Criteria stored in the public library are protected from unauthorized deletion.
DO NOT ENTER AN OPTION ON A BLANK LINE
You may only enter an option in a row containing a criteria name.
ONLY ONE REPORT CRITERIA MAY BE SELECTED
You may delete any or all listed criteria; however, you may select only one criteria.
PF7 INVALID - THIS IS THE FIRST REPORT CRITERIA SCREEN
You cannot scroll backward from the first page of a screen.
PF8 INVALID - THIS IS THE FINAL REPORT CRITERIA SCREEN
You cannot scroll forward from the last page of a screen.
PLEASE ENTER A 'D' OR 'S' OR '?'
Enter a "D" to delete report criteria, an "S" to select report criteria, or a "?" to display up to four
lines of previously entered user comments. Any other value entered in the Options column is
invalid.
PLEASE USE A VALID PF-KEY
You pressed a key that is not listed at the bottom of the screen.
REQUESTED PAGE NUMBER IS INVALID
You have changed the screen page number either to zero or to a page number greater than the total
number of pages available. The "or page number indicates the total number of pages required to
list your criteria names.
SELECT OPTION INVALID WITH < PF-KEY >
You have entered "S" in the Options columns, followed by either PF7 or PF8. You should press
ENTER to complete your selection.
AQS Ad hoc Batch Retrieval 3-28 September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
3.3.3 Submit Report
When you enter a criteria name or select a criteria name displayed on the screen and the criteria are
valid, the Submit Report Screen is displayed. Valid criteria are determined by extra information saved
with each set of specifications, indicating whether they had been validated completely the last time they
were selected. Figure 3-13 contains a sample screen.
11/06/89
Report Name: At> HOC
AIRS Air Quality Subsystem
Siianft Report
AMP600
Criteria Name: CONPDESC
Criteria Status: CRITERIA ARE VALID FOR THIS REPORT
Submit JOB without changing criteria (Y or N)?t N
PF3=end
menu
PF5=terminate
Figure 3-13. Submit Report Screen
September 1993
3-29
AQS Ad hoc Batch Retrieval
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
Instructions
You may enter one of the following responses on the Submit Report Screen. The resulting actions are
listed below.
Y go to the Batch Job Submission step
N display of the Report Options Screen with the selected criteria options displayed for
review or modification.
After indicating with a "Y" or "N" whether you want to submit a job without reviewing the valid criteria
first, press the ENTER key to validate your response and to proceed.
The valid PF keys for the Submit Report Screen and the resulting actions are:
PF3 return to the AQS Ad hoc Batch Report Menu
PF4 return to the AIRS AQS Main Menu
PF5 terminate the AIRS session
Using the PF3, PF4, or PF5 key terminates your report request; a report will not be generated.
Error Messages
When you enter an invalid response, or use a PF key not defined for the Ad hoc Batch Report Menu, a
message is displayed at the top of the screen to explain the error. Error messages are listed below in
alphabetical order.
PLEASE ENTER 'Y' OR 'N'
You have entered a value other than "Y" or "N".
PLEASE USE A VALID PF-KEY
You pressed a key that is not listed at the bottom of the screen.
AQS Ad hoc Batch Retrieval 3-30 September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
3.3.4 Report Options
The Report Options Screen displays the output options available. The screen shown in Figure 3-14
illustrates the set of options. The output options pertain to the types of output that can be generated, and
for reports, the report format. Some options are mutually exclusive; others can be used together. Format
and headers are exclusive for the output option they are listed under. The workfile output option can be
selected with any of the output report options or can be the only output option.
The Report Options Screen includes default options for your convenience (single-spaced Data Listing
Report, with expanded headers). The defaults are displayed on the screen unless you have accessed
previously saved output specifications. In that case, your saved Report Options are displayed with the
name of the saved, output specifications appearing in the top right corner of the screen.
08/21/90
Report Name: AD HOC
Enter Title:
AIRS Air Quality Subsystem
Report Options
AMP600A
Criteria Name:
Choose at least one output:
X 1. Generate a date listing report (Select format and headers below):
X Single Spaced _ Double Spaced _ Double Spaced 2 Lines
X Expanded Headers _ A8BR Headers
_ 2. Generate a cross tabulation report (Select format below):
_ Single Spaced _ Double Spaced
3. Generate a uorkfile (Enter name below):
KUFASUD
Enter Comments (optional):
PF3=end
menu
PF5=terminate
PF9=eave criteria
Figure 3-14. Report Options Screen
September 1993
3-31
AQS Ad hoc Batch Retrieval
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
Instructions
A title is required for all criteria, even when choosing a work file as your only output. The title will
appear on the Report Criteria Screen to describe the corresponding criteria name and, when a report is
selected as output, at the top of each page of your report.
You must choose one of the following output options and you may choose option 3 with option 1 or 2:
Option 1 generate a printed data listing report
Option 2 generate a printed cross tabulation report
Option 3 generate a work file
When you choose to create a report, you must select a report format. Either single- or double-spaced
format may be chosen. A double-spaced two-line format is also available for Data Listing Reports.
When this option is chosen and your specifications on the Data Listing Output Fields Screen do not
require two lines, the report format is automatically changed to single-spaced format. For Data Listing
Reports you must also indicate whether you will be using the field descriptions (expanded headers that
are stored as defaults, or you can enter your own) or the field abbreviations (ABBR headers) as column
headers.
If you choose to generate a work file, you must enter a dataset name for the file. If you do not specify
a valid dataset name, the batch job for generating your report will fail. The Report Options program may
not detect some errors in dataset names, so it is important that you specify the name carefully. Following
are the guidelines for specifying a valid dataset name:
IBM dataset names consist of one or more parts, called qualifiers, each separated by a period. The
NCC-IBM computer center requires that the first qualifier consists of your account code or your
NCC user-ID and account code concatenated together. Subsequent qualifiers can be anything you
choose as long as they adhere to the following rules:
each qualifier has 1 - 8 characters
the first character is a letter
subsequent characters are either letters or numbers
The dataset name fields on the Report Options Screen allow entry of names with the format
"iiiaaaa.namel.name2.nameS.name4M. The highest level qualifier "iiiaaaa", consisting of your
NCC user-ID and account code, is fixed and you cannot change it. To specify a dataset name, you
must enter an additional qualifier in the "namel" field. You may enter additional qualifiers in the
"name2" through "name4" fields, as desired. The fields must be used in sequence; a "gap" is
invalid. Each qualifier must begin with a letter and consist of one through eight letters or
numerals; no special characters are allowed. Thus, AIRS dataset names always have at least two
qualifiers, and they may have as many as five qualifiers.
All datasets created by Ad hoc Batch Retrieval are written on disk. Tape datasets cannot be created
directly by Ad hoc Batch Retrieval, although disk files can be copied to tape, if necessary, with utility
programs provided by the computer center.
AQS Ad hoc Batch Retrieval 3-32 September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
You have the option of entering comments on the Report Options Screen to document the contents or the
purpose of your criteria. You are not required to enter comments. Your comments are not validated,
and are only included in your Criteria Listing Report. When you have entered comments and skipped
lines within the comments, the skipped lines are removed by the system.
When you have specified the output options as you want them and you are ready for them to be validated,
press the ENTER key If they are correct, an Output Fields Screen appears.
The PF keys recognized by the Report Options Screen and the resulting actions are:
PF3
PF4
PF5
PF9
return to the AQS Ad hoc Batch Report Menu
return to the AIRS AQS Main Menu
terminate the AIRS session
go to the Criteria Disposition Screen
Using any of these PF keys terminates your output request; a report will not be generated.
Error Messages
When you press ENTER, or when stored criteria are first displayed, the criteria specified on the Report
Options Screen are validated. If an error is found, the screen is redisplayed with the cursor positioned
on the invalid specification and with an explanatory message at the top of the screen. Error messages
are listed below in alphabetical order.
DATASET NAME CONTAINS AN INVALID CHARACTER
The specified clataset name contains at least one invalid character. Only letters or numerals are
valid. Special characters are not permitted.
DATASET NAME HS INVALID
A "gap" in the dataset name qualifiers is not permitted. The qualifiers must be used in sequence.
DATASET NAME NODES MUST NOT BEGIN WITH A NUMERIC VALUE
The specified dataset name consists of at least one qualifier beginning with a numeral. Each
qualifier must begin with a letter.
DATASET NAME NOT ALLOWED WITHOUT SPECIFYING OPTION 3
Report option 3 was not selected to generate a work file, but a work file dataset name was
specified.
HELD HEADERS ARE VALID ONLY WITH A DATA LISTING REPORT
A report header has been specified and option 1 was left blank.
PLEASE CHOOSE OPTION 1, 2, OR 3 FOR OUTPUT
No output report option was selected.
September 1993
3-33
AQS Ad hoc Batch Retrieval
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
PLEASE ENTER A VALID DATASET NAME
Report option 3 was selected to generate a work file, but a qualifier for the "namel" field was not
specified.
PLEASE ENTER BLANK OR "X"
A character other than "X" was used to select report options.
PLEASE SELECT EITHER REPORT OPTION 1 OR 2
Report option 1, to generate a Data Listing Report, and report option 2, to generate a Cross
Tabulation Report, were both selected.
PLEASE SELECT ONE FIELD HEADER (REQUIRED)
You chose a Data Listing Report and either did not specify a field header type at all or specified
both types of headers.
PLEASE SELECT ONE FORMAT FOR OPTION 1
You chose a Data Listing Report and either did not specify a format at all or specified multiple
formats.
PLEASE SELECT ONE FORMAT FOR OPTION 2
You chose a Cross Tabulation Report and either did not specify a format at alt or specified both
formats.
PLEASE USE A VALID PF-KEY
You pressed a key that is not listed at the bottom of the screen.
REPORT FORMAT NOT ALLOWED WITHOUT SPECIFYING OPTION 1
Report option 1 was not selected, but a format for a Data Listing Report was specified.
REPORT FORMAT NOT ALLOWED WITHOUT SPECIFYING OPTION 2
Report option 2 was not selected, but a format for a Cross Tabulation Report was specified.
REPORT TITLE IS REQUIRED
Report title was left blank.
AQS Ad hoc Batch Retrieval 3-34 September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
3.3.5 Output Fields
The Output Fields Screens allow you to specify up to 99 fields from the GCS and/or AQS files to be
output to your report and/or work file. These fields become columns in your report and/or work file.
You may also specify your own field headers and/or field lengths, or use the Ad hoc output field defaults
for the fields you have specified.
The format of the Output Fields Screen will vary depending on the type of output you selected on the
Report Options Screen. There are three of these formats, based on whether you specified a Data Listing
Report, Cross Tabulation Report, or Workfile only. If you requested a work file along with a report,
the work file will contain the same fields as the report. The Data Listing and Work File Output Fields
Screens consist of multiple pages. The pages must be filled in sequence. You may specify the same field
more than once. However, each time a field is duplicated in your output fields criteria, the field length
must also be duplicated. Therefore, the same field cannot be specified multiple times with different
lengths.
General Instructions
After specifying your output criteria, press the ENTER key to validate the criteria. If they are correct,
the Select Criteria Screen appears. If the criteria are incorrect, an error message appears at the top of
the screen.
The PF keys recognized by the Output Fields Screens and the resulting actions are:
PF1
PF2
PF3
PF4
PF5
PF6
PF7
PF8
PF9
aJlow insert of a new entry in existing criteria *
display appropriate output field defaults
return to the AQS Ad hoc Batch Report Menu
return to the AIRS AQS Main Menu
terminate the AIRS session
return to the Report Options Screen
display the previous Output Fields page *
display the next Output Fields page *
go to the Criteria Disposition Screen
An asterisk (*) indicates these options are not available for the Cross Tabulation Output Fields Screen;
they apply only to the Data Listing and Workfile Output Fields Screens. Use of PF3, PF4, PF5, or PF9
terminates your output request; a report will not be generated.
To skip through filled pages, change the highlighted page number, in the bottom right section of the
screen, to the number of the page to be skipped to and press ENTER. If you should change the page
number and press a key other than ENTER, an error message is displayed. If you should change the
page number to a value greater than the number of pages used to list your specifications, an error
message is also displayed. The page number does not reflect the total number of pages used to list your
criteria. It reflects the total number of pages required to specify 99 fields.
September 1993
3-35
AQS Ad hoc Batch Retrieval
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
3.3.5.1 Data Listing Output Fields
In addition to specifying report fields, the Data Listing Output Fields Screen allows you to specify the
field headers and the number of characters to be printed from each alphanumeric field. The screen is
shown in Figure 3-15.
The report column width is automatically calculated and displayed for each field in your Data Listing
Report. It reflects the length of the field or the length of the longest header line, whichever is longer,
plus one for the space needed to separate fields on your report. A space is not added for the last field
in your report. A running total of your report width is also automatically calculated and displayed.
Data Listing Reports may be up to 131 characters wide. A double-spaced two-line report consists of two
131-character lines for a possible total report width of 262 characters. When a double-spaced two-line
report is specified and the total report width exceeds 131, an asterisk (*) in "column width" on your
screen will indicate the last field appearing in the first line of your report. That column width value may
reflect an adjustment to bring the total number of characters for the first line of your report to 131. An
adjusted column width indicates that spaces may have been added after the last field in line one to avoid
splitting the field that now appears as the first field in the second line.
08/21/90 AIRS Air duality Subsystem AMP600A1
Data Listing Output Fields
Report Name: AD HOC Criteria Name:
Field Co lam
ASBR Length Width Header 1 Header 2 Header 3
Total Report Width: Maximum Uidth At towed: Page 1 of 9
PF1=insert PF2«defaults PFjzend PF4=main menu PF5=termirwte
PF6«report options PF7«beck PF8=more PF9=save criteria
Figure 3-15. Data Listing Output Fields Screen
AQS Ad hoc Batch Retrieval 3-36 September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
If a double-spaced two- line format is chosen on the Report Options Screen and the total report width does
not exceed 131 characters, the report format is automatically changed to a single-spaced format when you
press ENTER.
Instructions
Field headers may consist of up to three lines, and each header line may consist of up to 10 characters.
If you do not specify field lengths and headers, the defaults will be used. By pressing the PF2 key you
may review the defaults. This PF key can be pressed at any time to display the defaults of the field
abbreviations entered on the screen.
You may alter, delete, or add output field specifications to your existing criteria. To delete a field, you
must erase all specifications for the entire row. Any blank rows are automatically eliminated by having
subsequent rows, including rows from subsequent pages, moved up. New fields may be added at the end
of your existing criteria or inserted after any existing field except the last field specified in your criteria.
This insertion is accomplished by pressing the PF1 key to make a space to insert the new line on the
screen.
Error Messages
When you press ENTER, PF2, PF7, or PF8, or when stored criteria are first displayed, the criteria
specified on all pages of the Data Listing Output Fields Screen are validated. If an error is found, the
screen is redisplayed with the cursor positioned on the invalid specification and with an explanatory
message at the top lire of the screen. Error messages are listed below in alphabetical order.
ABBR REQUIRED WITH FIELD LENGTH AND/OR HEADERS
Either the FIELD LENGTH or a HEADER entry contains a value, and the ABBR entry is blank.
AUTO PAGING INVALID WITH
You have changed the screen page number and pressed either the PF7 or PF8 key. Only the
ENTER and PF2 keys are valid with the auto paging option.
ENTER OUTPUT FIELDS OR USE A PF-KEY TO ESCAPE
ENTER was pressed and no output fields are specified (because none were entered or all have been
erased).
INVALID CURSOR POSITION FOR AN INSERT
The PF1 key was pressed and the cursor is not in a valid position for an insert or the cursor is on
the last field listed.
INVALID FIELD ABBR ENTERED
Only ABBRs listed in Appendix A of the AIRS User's Guide are valid.
LENGTH FOR NUMERIC HELD MUST EQUAL THE DEFAULT LENGTH OF <999>
The output length specified for a numeric field cannot be different than the default length.
September 1993
3-37
AQS Ad hoc Batch Retrieval
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
NO ENTRIES AVAILABLE ON REQUESTED PAGE
You changed the page number to a page without any existing entries. The "OF" page number does
not reflect the total number of pages used to list your criteria. It reflects the total number of pages
required to specify 99 fields.
PF7 INVALID - THIS IS THE FIRST OUTPUT SCREEN
You cannot scroll backward from the first page of a screen.
PF8 INVALID - THIS IS THE FINAL OUTPUT SCREEN
You cannot scroll forward from the last page of a screen.
\
PLEASE FILL ALL LINES BEFORE GOING ON TO THE NEXT SCREEN
The PF8 key was pressed and fields have not been specified for all entries on the page.
PLEASE USE A VALID PF-KEY
You pressed a key that is not listed at the bottom of the screen.
REQUESTED PAGE NUMBER IS INVALID
You changed the screen page number either to zero or to a page number greater than the total
number of pages available. The "OF" page number indicates the total number of pages required
to specify 99 fields.
SPECIFIED FIELD LENGTH EXCEEDS FIELD DEFAULT LENGTH OF <999>
The length specified for the field is greater than the default length.
THE MAXIMUM NUMBER OF ABBRS ALLOWED HAS BEEN SPECIFIED
The PF1 key was pressed to insert a field and there are already 99 output field entries specified.
TOTAL REPORT WIDTH OF <9999> EXCEEDS <999> CHARACTERS
The sum of the lengths for the specified fields must be less than or equal to the total width
permitted for the selected output.
AQS Ad hoc Batch Retrieval 3-38 September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
3.3.5.2 Cross Tabulation Report Output Description
Figure 3-2 is an example of a typical Cross Tabulation Report. This report format is not designed
primarily to list data in the database. Instead, it is used to tabulate or "count" data from the database.
The report itself can be thought of as an arrangement of cells, each of which contains a numerical value.
The cells are arranged into rows and columns, similar to the cells of a spreadsheet.
Below is a simple example of a cross-tabulation analysis.
Fifth Graders at 7th Street Elementary School, bv Sex and Eve Color
Eye Color:
Brown
Blue
Hazel
Green
TOTAL
Male
25
22
18
10
75
Female
27
23
14
11
75
Total
52
45
32
21
150
This is an analysis of two variables: the column variable, sex, and the row variable, eye color. Each
cell is defined by its row value (brown, blue, hazel, or green) and its column value (male or female) and
contains the count of students with the same sex and eye color. Each row is totaled, giving the student
count for each eye color; each column is totaled, giving the number of males and the number of females.
Figure 3-2 is an Ad hoc Cross Tabulation report similar to the above example. The column variable is
MONITOR-TYPE, from the Monitor record. The row variable is STATE-NAME, from the Geo-
Common State record. There is a separate column for each of five values of MONITOR-TYPE: "1",
labeled NAMS; "2", labeled SLAMS; "3", labeled OTHER; "9", labeled SECURED; and "0", labeled
UNKNOWN. There is a row for each state. The numerical cells give the count of monitors having the
same MONITOR-TYPE and STATE-CODE.
You may observe that MONITOR-TYPE is a 1-digit field and STATE-CODE is a 2-character field, but
that in place of monitor type codes, "labels" such as "NAMS" and "SLAMS" are printed, and instead
of state codes, state names are printed. Further, the states are grouped by region, and there is a subtotal
for each region/monitor type combination. These report features are explained below.
September 1993
3-39
AQS Ad hoc Batch Retrieval
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
3.3.5.3 Cross Tabulation Output Fields
The layout of the Cross Tabulation Report in Figure 3-2 is determined by the Cross Tabulation Output
Fields screen shown in Figure 3-16:
• The column variable, MONITOR-TYPE, is determined by the ABBR MTYM in the
"Column :" field.
• The row variable, STATE-NAME, is determined by the ABBR STNM in the "Row :"
field.
Every value of the row variable, STATE-NAME, is allocated its own row on the report. However, you
must select which of the possible values of the column variable, e.g., MONITOR-TYPE, are to be
counted and reported. You use the Column Information section on the lower half of Figure 3-16 to:
• select the discrete values of the column variable to be reported,
• assign each to a column on your report (1st through 10th), and
• (if desired) give each column a column header.
OS/08/92
Report Name: AD HOC
ABBR
ROM : STNM
Column : MTYM
Subtotal: 8GCD
Value
1. 1
3. 3
5. 0
7.
9.
PF2=bcf»ults
PF6=report options
AIRS Air Quality Subsystem AMP600A2
Cross Tabulation Output Fields
Criteria Name:
Length Header 1 Header 2 Header 3
20 STATE NAME
MONITOR TYPE
2 RGN
Header Value Header
NAMS 2. 2 SLAMS
OTHER 4. 9 SECURED
UNKNOWN A.
8.
10.
PF3=end PF4=main menu PF5=terminste
PF9=save criteria
Figure 3-16. Cross Tabulation Output Fields Screen
AQS Ad hoc Batch Retrieval
3-40
September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
On Figure 3-16, the MONITOR-TYPE values 1, 2, 3, 9, and 0 are chosen for the report's four columns,
and appropriate headers are assigned to each column.
The states (Figure 3-2) are grouped by region. The "Subtotal:" field ABBR, RGCD, causes the report
to sort the states by region, and to report the regional subtotals.
Finally, you should be aware of the linkages between records and fields of the AIRS database upon which
Ad hoc depends. For this Cross Tabulation report, the select criteria specify REGION > 01 and
REGION > 02. Since REGION is a Monitor record field, these select criteria point to Monitor records.
On these Monitor records is MONITOR-TYPE, the column variable used for the report. But the row
variable, STATE-NAME, is not on the Monitor record — it is a field on the Geo-Common State record.
MONITOR-TYPE is associated with a state through the MONITOR-ID field on the Monitor record, the
first two characters of which are the STATE-CODE. STATE-CODE also exists on the Geo-Common
State record; therefore, it is a logical link between the Monitor record and the State record. Given any
Monitor record, Ad hoc can find a matching State record and, hence, STATE-NAME.
Instructions
"Row :" field: Choose the database field whose values will define the rows of your report with this
line of output specifications. Enter the ABBR for the field, the Length, or number of characters you want
to be printed as row labels, if this is an alphanumeric field. Using the spaces marked Header 1, Header
2, and Header 3, you may create a header that identifies the row field used in the analysis. If you do
not specify field headers and lengths, the defaults will be used. Press the PF2 key to review the defaults.
"Column :" field: Choose the database field whose values will define the columns of your report with
this line of output specifications. Enter the ABBR and, if desired, the header label parts 1, 2, and 3 to
identify the column field used in the analysis. Press PF2 for the defaults.
"Subtotal:" field: Choose a database field within which your rows may be grouped. For example, you
may group state by region, or county by state. As with the Row and Column fields, you may specify
the length of alphanumeric subtotal field values, and a three-part label.
Column Information: The Cross Tabulation report allocates one column for each discrete value of your
column field or variable. Referring to Figure 3-16, the column field MONITOR-TYPE can have a
number of discrete values: 0, 1,2, 3, etc. You might be interested in counting only one or a few of the
possible values. You must choose which of the possible values of your column field are to be allocated
a column on your report and to be counted.
Enter the values that jxe to be counted in the spaces labeled "Value". In Figure 3-16, these are 0, 1, 2,
3, and 9. Next, you may optionally enter your own column header text for each column. In Figure 3-
16, MONITOR-TYPE 9 is reported in column 4, and the column is labeled "SECURED". You must
specify at least one value for your column field in the "Column Information" section.
For most database fields, the values that you enter in the "Column Information" section are the same as
those you enter when entering data into AIRS, or those reported on the standard batch reports. There
are three notable exceptions to this, however: validity flags, sample or summary data values, and null
value codes. See: Section 3.4.4 for guidelines for handling these fields.
September 1993
3-41
AQS Ad hoc Batch Retrieval
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
You may alter, delete, or add column information entries to your existing criteria. To delete an entry,
you must erase all specifications for the entire entry. Any blank entries are eliminated by moving up
subsequent entries.
Error Messages
When you press ENTER or PF2, or when stored criteria are first displayed, the criteria specified on the
Cross Tabulation Output Fields Screen are validated. If an error is found, the screen is redisplayed with
the cursor positioned on the invalid specification and with an explanatory message at the top of the
screen. Error messages are listed below in alphabetical order.
COLUMN ABBR REQUIRED
The field ABBR for the column is blank.
DUPLICATE FIELD ABBRS MAY NOT BE SPECIFIED
The same field is specified for both the row and the subtotal.
ENTER OUTPUT FIELDS OR USE A PF-KEY TO ESCAPE
ENTER was pressed and no output fields are specified (because none were entered or all have been
erased).
FIELD ABBR IS INVALID FOR CROSS TABULATION
The column ABBR entered is for a sample with a decimal point. It cannot be used because sample
values are written to the work file in reported units.
FIELD VALUE EXCEEDS DEFAULT LENGTH OF <999>
The number of characters specified is greater than the field size.
FIELD VALUE INCOMPATIBLE WITH HELD FORMAT
An alphanumeric value is entered for a numeric field.
INVALID FIELD ABBR ENTERED
Only ABBRs listed in Appendix A are valid.
INVALID UNITS CODE
A field in which the value can be displayed in multiple units is selected and the specified units code
does not exist in the GCS Description record.
LENGTH FOR NUMERIC FIELD MUST EQUAL THE DEFAULT LENGTH OF <999>
The output length specified for a numeric field must be the same as the default length.
PLEASE USE A VALID PF-KEY
You pressed a key that is not listed at the bottom of the screen.
ONE VALUE IS REQUIRED
No column information values were specified.
AQS Ad hoc Batch Retrieval 3-42 September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
ROW ABBE REQUIRED
The field ABBR for the row is blank.
SPECIFIED FIELD LENGTH EXCEEDS FIELD DEFAULT LENGTH OF <999>
The length specified for the field is greater than the default length.
TOTAL REPORT WIDTH OF <9999> EXCEEDS <999> CHARACTERS
The sum of the lengths for the specified fields must be less than or equal to 131 characters.
USE SAME TWO CHARACTERS TO INDICATE UPPER CASE VALIDITY FLAG
A validity flag value is specified with two different characters.
VALUE REQUIRED WITH HEADER
Column information contains an entry with a header specified, but no corresponding value.
September 1993
3-43
AQS Ad hoc Batch Retrieval
-------
1
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
3.3.5.4 Worlrfile Output Fields
The Workfile Output Fields Screen is displayed only when you have selected a workfile as your only
output.
The Workfile Output Fields Screen allows you to specify your workfile fields and the number of
characters to be printed from each alphanumeric field. The screen is shown in Figure 3-17.
The total length of your work file record is automatically calculated and displayed. The record length
is calculated by accumulating the lengths of all fields specified. There is no restriction on the length of
your work file. It can be as long as needed to store up to 99 fields.
08/21/90
AIRS Air Quality Subsystem ANP600A3
Workfile Output fields
Report Nam
t: AD HOC
ABB* Length
1.
4. __
7.
10.
13.
16.
19.
22.
25.
28.
31.
ABBR
2.
5.
a.
11.
u.
17.
20.
23.
26.
29.
32.
Total Record Length:
PFUinsert
PF6«report
PF2«def«utts
options PF7«back
PF3*end
PF£*nore
Criteria Name:
Length ABBR Length
3.
6.
9.
12. ""
15.
18.
2U
24.
27. "
30.
_ 33. _
Page 1 of 3
PF4=fliain menu PF5=tenninate
PF9=save criteria
Figure 3-17. Workfile Output Fields Screen
AQS Ad hex; Batch Retrieval
3-44
September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Instructions
If you do not specify field lengths, the defaults will be used. Press the PF2 key to review the defaults.
You may alter, delete, or add work file output field specifications to your existing criteria. To delete a
field, you must also erase any field length specification for that entry. Blank entries are eliminated by
moving up subsequent entries, including entries from subsequent pages. New fields may be added at the
end of your existing criteria or inserted after any existing field except the last field specified in your
criteria by pressing the PF1 key.
Error Messages
When you press ENTER, PF2, PF7, or PF8, or when stored criteria are first displayed, the criteria
specified on all pages of the Workfile Output Fields Screen are validated. If an error is found, the screen
is redisplayed with the cursor positioned on the invalid specification and with an explanatory message at
the top of the screen. Error messages are listed below in alphabetical order.
ABBR REQUIRED WITH FIELD LENGTH
A field length was entered without specifying an ABBR.
AUTO PAGING INVALID WITH
You changed the screen page number and pressed either the PF7 or PF8 key. Only the ENTER
and PF2 keys are valid with the auto paging option.
ENTER OUTPUT FIELDS OR USE A PF-KEY TO ESCAPE
ENTER was pressed and no output fields are specified (because none were entered or all have been
erased).
INVALID FIELD AJBBR ENTERED
Only ABBRs listed in Appendix A are valid.
INVALID CURSOR POSITION FOR AN INSERT
The PF1 key was pressed and the cursor is not in a valid position for an insert or the cursor is on
the last field listed.
LENGTH FOR NUMERIC FIELD MUST EQUAL THE DEFAULT LENGTH OF < 999 >
The output length specified for a numeric field cannot be different from the default length.
NO ENTRIES AVAILABLE ON REQUESTED PAGE < nn >
You changed tfie screen page number to a page without any existing entries. The "OF" page
number does not reflect the total number of pages used to list your criteria. It reflects the total
number of pages required to specify 99 fields.
PF7 INVALID - THIS IS THE FIRST OUTPUT SCREEN
You cannot scroll backward from the first page of a screen.
September 1993
3-45
AQS Ad hoc Batch Retrieval
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
PF8 INVALID - TfflS IS THE FINAL OUTPUT SCREEN
You cannot scroll forward from the last page of a screen.
PLEASE FILL ALL LINES BEFORE GOING ON TO THE NEXT SCREEN
The PF8 key was pressed and fields have not been specified for all entries on the page.
PLEASE USE A VALID PF-KEY
You pressed a key that is not listed at the bottom of the screen.
REQUESTED PAGE NUMBER IS INVALID
You either changed the screen page number to zero or to a page number greater than the total
number of pages available. The "OF" page number indicates the total number of pages required
to specify 99 fields.
SPECIFIED FIELD LENGTH EXCEEDS FIELD DEFAULT LENGTH OF <999>
The length specified for the field is greater than the default length.
THE MAXIMUM NUMBER OF ABBRS ALLOWED HAS BEEN SPECIFIED
The PF1 key was pressed to insert a field and there are already 99 output field entries specified.
AQS Ad hoc Batch Retrieval 3-46 September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
3.3.6 Select Criteria
The Select Criteria Screen allows you to specify up to 99 GCS and/or AQS database fields and values
as extraction criteria for your output; at least one key field must be used. An evaluation condition must
also be included for each field specified. A field may be listed more than once to specify alternative
values or a range of values. The screen is shown in Figure 3-18.
Your Select Criteria Screen entries are treated as "AND" conditions. Select Criteria entries for a field
consisting of multiple CE conditions are treated as "OR" conditions when evaluating the specified field.
To be extracted for your output, the database record must meet one CE condition for each field specified
with multiple CE conditions, AND must meet all other Select Criteria with conditions other than CE (i.e.,
for Monitor Type CE 1, Monitor Type CE 2, State Code ME 25, the database record must have a State
Code of 25 AND a monitor type of 1 or 2).
08/21/W
Report Ni
AIRS Air Quality Subsystem
Select Criteria
AMP600B
AD HOC
ABBR Cond
Value
ABBR Cortd
Criteria Name:
Value
PF4*n»in menu
PF8=more
PF5=terminate
PF9=save criteria
Page 1 of 5
PF6=report options
Figure 3-18. Select Criteria Screen
September 1993
3-47
AQS Ad hoc Batch Retrieval
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
Instructions
The valid conditions that may be used in your Select Criteria are:
BL - blank or zero (for all fields, except those requiring a units code)
CE - can equal (for alternative values)
GE - greater than or equal to
GT - greater than
LE - less than or equal to
LT - less than
ME - must equal
MB - not blank (for alphanumeric fields only)
ME - not equal
SS - contains the substring (for alphanumeric fields only)
Evaluation conditions and descriptions can be displayed on the Select Criteria Screen by entering a
question mark (?) in the COND column and then pressing ENTER. When a "?" is entered in the left
COND column, the conditions are listed on the right side of your screen. When entered in the right
COND column, they are listed on the left. After reviewing the list of valid conditions, you must press
ENTER again to return your cursor to the COND entry containing the "?".
A field specification always requires that both a condition and an evaluation value be included, except
when using the NB and/or BL conditions. If you should specify either of these conditions with a value,
an error message will be displayed.
You may alter, delete, or add Select Criteria specifications to your existing criteria. To delete a field,
you must erase all specifications for that entry. Any blank entries are eliminated by moving up
subsequent entries, including entries from subsequent pages. New fields may be added at the end of your
existing criteria or inserted after any existing field except the last field specified in your criteria by
pressing PF1.
To select data for secured monitors (see Section 2.1), you must specify the monitor type field with a
condition of ME and a value of "9". You may not extract data for both secured and non-secured
monitors in the same criteria. (As discussed in Section 2.1, you also must supply a password, on the
AQS User Profile Screen, to select data for secured monitors.)
If unsecured monitor information is selected, an additional selection criterion will be generated, specifying
the monitor type field with a condition of NE and a value of "9".
To specify a value for validity flag evaluation, you must enter a single character for a lower-case value
evaluation. For upper-case value evaluation, two characters are required.
To evaluate a sample or summary data field, the field ABBR for the field with the decimal point (DP)
should always be used for selections based on a value of that field. See Section 3.4.4, Selection Criteria,
for an explanation of how to express the selection value. The field ABBR without the DP and the
associated decimal point indicator field ABBR are better used for output fields. A value that is stored
in AQS in units other than the unit specified in the Select Criteria will be converted to the specified unit
for comparison.
AQS Ad hoc Batch Retrieval 3-48 September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Once you have entered the appropriate select criteria, press the ENTER key to verify screen and proceed
to the next step, if no errors were found. If the Report Options to generate a Cross Tabulation Report
was selected, the JCL Parameters screen will be displayed; otherwise, the Sort Criteria screen will be
displayed.
Valid PF keys for the Select Criteria Screen and the resulting actions are:
PF3
PF4
PF5
PF6
PF7
PF8
PF9
return to the AQS Ad hoc Batch Report Menu
return to the AIRS AQS Main Menu
terminate the AIRS session
return to the first page of the Output Fields Criteria Screen
display the previous Select Criteria page
display the next Select Criteria page
go to the Criteria Disposition Screen
Using the PF3, PF4, PF5, or PF9 key terminates your report request; a report will not be generated.
To skip though filled pages in screens consisting of multiple pages, change the highlighted page number,
in the bottom right section of the screen, to the number of the page to be skipped to and press ENTER.
If you should change the page number and press a key other than ENTER, an error message is displayed.
If you should change the page number to a value greater than the number of pages used to list your
specifications, an error message is also displayed. The page number does not reflect the total number
of pages used to list your criteria. It reflects the total number of pages required to specify 99 fields.
Error Messages
When you press ENTER, PF7, or PF8, or when stored criteria are first displayed, the criteria specified
on all pages of the Select Criteria Screen are validated. If an error is found, the screen is redisplayed
with the cursor positioned on the invalid specification and with an explanatory message at the top of the
screen. Error messages are listed below in alphabetical order.
ABBR REQUIRED WITH COND OR VALUE
A condition and/or field value was entered without specifying an ABBR.
AUTO PAGING INVALID WITH
You changed the screen page number and pressed either the PF7 or PF8 key. Only the ENTER
key is valid with the auto paging option on this screen.
CONDITION REQUIRED
An evaluation condition is required with every field specified.
ENTER SELECTION CRITERIA OR USE A PF-KEY TO ESCAPE
ENTER was pressed and no Select Criteria are specified (because none has been entered or all have
been erased).
FIELD VALUE EXCEEDS ELEMENT LENGTH OF <99>
The number of characters specified is greater than the field size.
September 1993
3-49
AQS Ad hoc Batch Retrieval
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
FIELD VALUE INCOMPATIBLE WITH FIELD FORMAT
An alphanumeric value was specified for a numeric field.
INVALID CONDITION - ENTER A '?' TO LIST VALID CONDITIONS
You entered an invalid condition. Position your cursor in the COND column, enter a "?", and
press ENTER to review the list of valid conditions.
INVALID CONDITION FOR NUMERIC FIELD
A numeric field was specified with a condition of NB or SS.
INVALID FIELD ABBR ENTERED
Only ABBRs listed in Appendix A are valid.
INVALID UNITS CODE
A field in which the value can be displayed in multiple units is selected and the specified units code
does not exist in the GCS Description record.
NO ENTRIES AVAILABLE ON REQUESTED PAGE
You changed the screen page number to a page without any existing entries. The "OF" page
number does not reflect the total number of pages used to list your criteria. It reflects the total
number of pages required to specify 99 fields.
PF7 INVALID - THIS IS THE FIRST SELECT CRITERIA SCREEN
You cannot scroll backward from the first page of a screen.
PF8 INVALID - THIS IS THE FINAL SELECT CRITERIA SCREEN
You cannot scroll forward from the last page of a screen.
PLEASE FILL ALL LINES BEFORE GOING ON TO THE NEXT SCREEN
The PF8 key was pressed and fields have not been specified for all entries on the page.
PLEASE USE A VALID PF-KEY
You pressed a key that is not listed at the bottom of the screen.
REQUESTED PAGE NUMBER IS INVALID
You changed the screen page number either to zero or to a page number greater than the total
number of pages available. The "OF" page number indicates the total number of pages required
to specify 99 fields.
UNITS CODE MUST BE PART OF THE VALUE
A field in which the value can be displayed in multiple units is selected and no unit code (e.g., .125
(001)) is specified with the value field.
USE AT LEAST ONE KEY FIELD ABBR
At least one key field from a GCS or AQS record must be specified.
USE SAME TWO CHARACTERS TO INDICATE UPPER CASE VALIDITY FLAG
A validity flag value is specified with two different characters.
AQS Ad hoc Batch Retrieval 3-50 September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
VALUE NOT PERMITTED WITH CONDITION
A condition of NB or BL was entered with a field value specification.
VALUE REQUIRED WITH CONDITION
A condition other than NB or BL was entered without a field value specification.
September 1993
3-51
AQS Ad hoc Batch Retrieval
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
3.3.7 Sort Criteria
The Sort Criteria step allows you to specify the son sequence and sort order of up to 99 output fields.
When the Sort Criteria Screen is originally displayed, the fields you specified on either the Data Listing
or Workfile Output Fields Screen are duplicated as the default sort sequence for your output. The screen
is shown in Figure 3-19. All fields default to an "ascending" sort order. Only the fields specified in the
output fields screen can be used as son criteria. If the Cross Tabulation Report is selected, the sort
sequence is fixed as the subtotal, row, and column fields, and the Son Criteria Screen is not displayed.
The same field may not be specified multiple times in your Son Criteria. If you specified the same field
more than once in your Output Fields, only one occurrence of that field is included in the default Son
Criteria. The sequence in which the son fields are listed defines the son sequence of your output. The
first field specified designates the primary son field, the second field designates the secondary son field,
and so on. The order in which fields are specified in the Output Fields defines the order in which they
appear in the output.
Whenever you add or delete fields in the Output Fields (except duplicate occurrences of an existing field),
new default Son Criteria are generated.
08/21/90
AIRS Air Quality Subsystem
Sort Criteria
Report Name: AD HOC
A >
PF1
AS8R (A/0)
1.
4.
7.
10.
13.
16.
19.
&. "
25.
28.
31.
ascending (default)
•insert
PF6*setect criteria
ABBR (A/D)
2.
S.
e.
11.
u.
17. '
20.
23.
26.
29. '
32. '
0 - descending
PF3=end PF4=mein
PF7=baek PF8=more
AMP600C
Criteria Name:
A8BR
3.
6.
9. "
12.
15.
18.
21.
24.
27.
30.
33.
menu
(A/D)
Page 1 of
3
PF5*tenmnate
PF9»save
criteria
Figure 3-19. Sort Criteria Screen
AQS Ad hoc Batch Retrieval
3-52
September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Instructions
You may change the sequence in which fields are listed by:
erasing a field specification and entering specifications for another field;
using the PF1 key to create a blank entry and specifying the field to be "moved";
entering specifications at the end of your criteria.
Any deleted default specifications will automatically be appended to the end of your criteria as the least
significant sort fields to ensure that the son does not delete records that are not duplicated.
You may specify an ascending or descending sort order for each entry by entering an "A" or "D". Any
blank entries are eliminated by moving up subsequent entries, including entries from subsequent pages.
Once you have entered your son criteria on the screen, press ENTER to verify your specifications. If
all your criteria are valid, the Sort Criteria step ends and the JCL Parameters step begins.
The valid PF keys for the Sort Criteria Screen and the resulting actions are:
PF1
PF3
PF4
PF5
PF6
PF7
PF8
PF9
aJlow insert of a new entry in existing criteria
return to the AQS Ad hoc Batch Report Menu
icturn to the AIRS AQS Main Menu
terminate the AIRS session
return to the first page of the Selection Criteria Screen
display the previous Sort Criteria page
display the next Sort Criteria page
go to the Criteria Disposition Screen
Using the PF3, PF4, PF5, or PF9 key terminates your report request; a report will not be generated.
To skip though filled pages in screens consisting of multiple pages, change the highlighted page number,
in the bottom right section of the screen, to the number of the page to be skipped to and press ENTER.
If you should change the page number and press a key other than ENTER, an error message is displayed.
If you should change the page number to a value greater than the number of pages used to list your
specifications, an error message is also displayed. The page number does not reflect the total number
of pages used to list your criteria. It reflects the total number of pages required to specify 99 fields.
Error Message;
When you press ENTER, PF7, or PF8, or when stored criteria are first displayed, the criteria specified
on all pages of the Sort Criteria Screen are validated. If an error is found, the screen is redisplayed with
the cursor positioned on the invalid specification and with an explanatory message at the top of the
screen. Error messages are listed below in alphabetical order.
ABBR REQUIRED WITH SORT ORDER
A sort order has been entered without an ABBR specification.
September 1993
3-53
AQS Ad hoc Batch Retrieval
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
AUTO PAGING INVALID WITH
You changed the screen page number and pressed either the PF7 or PF8 key. Only the ENTER
and PF2 keys are valid with the auto paging option.
FIELD ABBR REPEATED
An ABBR may not be specified more than once.
INVALID CURSOR POSITION FOR AN INSERT
The PF1 key was pressed and the cursor is not in a valid position for an insert or the cursor is on
the last field listed.
INVALID FIELD ABBR ENTERED
Only ABBRs listed in Appendix A are valid.
INVALID FIELD SORT ORDER
The sort order must be "D" (descending order), "A" (ascending order), or blank (default to
ascending order).
NO ENTRIES AVAILABLE ON REQUESTED PAGE
You changed the screen page number to a page without any existing entries. The "OF" page
number does not reflect the total number of pages used to list your criteria. It reflects the total
number of pages required to specify 99 fields.
PF7 INVALID - THIS IS THE FIRST SORT CRITERIA SCREEN
You cannot scroll backward from the first page of a screen.
PF8 INVALID - THIS IS THE FINAL SORT CRITERIA SCREEN
You cannot scroll forward from the last page of a screen.
PLEASE FILL ALL LINES BEFORE GOING ON TO THE NEXT SCREEN
The PF8 key was pressed and fields have not been specified for all entries on the page.
PLEASE USE A VALID PF-KEY
You pressed a key that is not listed at the bottom of the screen.
REQUESTED PAGE NUMBER IS INVALID
You changed the screen page number either to zero or to a page number greater than the total
number of pages available. The "OF" page number indicates the total number of pages required
to specify 99 fields.
SORT ABBR DOES NOT EXIST AS AN OUTPUT ABBR
Only fields included in your Output Fields Criteria may be specified as sort fields.
THE MAXIMUM NUMBER OF ABBRS ALLOWED HAS BEEN SPECIFIED
The PF1 key was pressed to insert a field and there are already 99 sort fields specified.
AQS Ad hoc Batch Retrieval 3-54 September 1993
-------
AIRS User's Guide
Volume AQS
Ad hoc Retrieval
3.3.8 JCL Parameters
The JCL Parameters Screen is the means by which you specify job control information for the batch job
that will generate your output. Figure 3-20 shows a sample JCL Parameters Screen.
The fields of the JCL Parameters Screen pertain exclusively to the JCL for the batch job. They all have
default values that can be changed. You can find more information about these fields in Section 3 of the
AIRS AQS Data Retrieval, Volume AQ4 or in Section 4 of the NCC-IBM User's Guide.
08/21/90
Report Ni
AIRS Air Quality Subsystem
JCL Parameters
AMP6000
AD HOC
ENTER:
Criteria Name:
JOB Name KUF ADHOC
Account Code/UlD ASWD AIRSD
Time (HUM , SS) _2 , _
Priority 2
Message Class f
Number of Copies 2
Form Nunber §381
Room/Bin Number B132
Hold Output (Y/N) N
Printer Site Id RMTOOO
Press ENTER to sufamt JOB
PF3-end PF4=main menu PF5=terrainate PF6=previous function PF9=save criteria
Figure 3-20. JCL Parameters Screen
September 1993
3-55
AQS Ad hoc Batch Retrieval
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
Instructions
When you have specified the correct information on the JCL Parameters Screen, press the ENTER key.
The program checks each field of the screen. If it finds an error, it displays an error message at the top
of the screen and positions the cursor on the invalid field. Correct the error and press the ENTER key
again.
While the JCL Parameters Screen is displayed, you may use any of the following PF keys:
PFS return to the AQS Ad hoc Batch Report Menu
PF4 return to the AIRS AQS Main Menu
PFS terminate the AIRS session
PF6 return to the Sort Criteria Screen or, for a Cross Tabulation Report, to the Select
Criteria Screen
PF9 go to the Criteria Disposition Screen
Using the PF3, PF4, PFS, or PF9 key terminates your report request; a report will not be generated.
Error Messages
The messages listed below may occur while the JCL Parameters Screen is displayed. Correct the error
and press ENTER again or use one of the valid PF keys listed above to exit from the JCL Parameters
Screen.
JOB NAME MUST BE ALPHANUMERIC
JOB Name can be blank or from one to five letters and numbers, with no intervening spaces or
special characters such as "-".
PLEASE ENTER A PRIORITY OF 1, 2, OR 3
The only valid values for priority are 1, 2, or 3.
PLEASE ENTER A VALID FORM NUMBER
The field cannot contain embedded spaces.
PLEASE ENTER A VALID MESSAGE CLASS
The message class must be a letter or a number. Usual values are A and F.
PLEASE ENTER AN ACCOUNT CODE
The account code cannot be blank. Enter a four-character code.
PLEASE ENTER AN ALPHANUMERIC PRINTER SITE-ID
The printer site-ID must be alphanumeric. Examples of valid site-IDs are RMT321, LOCAL, N3,
and NTR100.
PLEASE ENTER TIME IN MINUTES, SECONDS
The minutes and seconds fields both contain zeros or spaces. At least one of these two fields must
contain a valid numeric value greater than zero.
AQS Ad hoc Batch Retrieval 3-56 September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
PLEASE ENTER VALID MINUTES
Minutes must be numeric in the range 000 through 999.
PLEASE ENTER VALID SECONDS
Seconds must be numeric in the range 00 through 59.
PLEASE ENTER "Y" OR "N"
Hold Output must be either "Y" to hold output or "N" to print output.
PLEASE USE A VALID PF-KEY
You pressed a key that is not listed at the bottom of the screen.
ROOM/BIN NUMBER MUST BE ALPHANUMERIC
Room/Bin Number must consist of letters and numbers.
THE NUMBER OF COPIES MUST BE IN THE RANGE OF 1 TO 99
The Number of Copies requested is not in the range of 01 through 99.
September 1993
3-57
AQS Ad hoc Batch Retrieval
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
3.3.9 Batch Job Submission
Hie batch job submission process submits a batch job. If submission of the job occurs without *rror, the
Criteria Disposition Screen wilt be displayed.
If the job submission fails, the Job Disposition Screen is displayed. A sample Job Disposition Screen is
shown in Figure 3-21. The screen briefly describes the error condition and suggests what you should do
in order to proceed. There are four error conditions: the account number you used is not valid;
something is wrong with the "internal card reader"; you have selected ABBRs from files that have no key
match; or fields from files of the same level were specified.
11/06/89
Deport Mam: AD HOC
AIRS Air Quality Subsystem
Job Disposition
ANP600E
Criteria Name:
UNABLE TO SUBMIT BATCH JOB
FIELDS FROM FILES OF THE SAME LEVEL SPECIFIED
PRESS PF6 TO CORRECT
PF3«end PF4=wain menu PF5=terminate PF8-JCL parms PF9=criteria
Figure 3-21. Job Submission Screen
AQS Ad hoc Batch Retrieval
3-58
September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Instructions
If the account code is wrong, you must return to the JCL Parameters Screen (via PF6) and correct it.
If the internal card reader is busy, you may be successful if you try the job submission again (by pressing
ENTER). If the internal card reader is "unavailable", trying again to submit the job is not likely to be
successful; probably you will have to save your report specifications and try to generate the output at
another time.
You can use the following PF keys to exit from the Job Disposition Screen:
PF3
PF4
PF5
PF6
PF9
return to the AQS Ad hoc Batch Report Menu
return to the AIRS AQS Main Menu
terminate the AIRS session
return to the JCL Parameters Screen
go to the Criteria Disposition Screen
Using any of these PF keys terminates your report request; a report will not be generated. Unless you
use the PF9 key, your report specifications will not be saved.
Error Messages
The following error messages may appear on the Job Disposition Screen:
FIELDS FROM FILES OF THE SAME LEVEL SPECIFIED
PRESS PF6 TO CORRECT
Fields specified in the output or selection criteria are from files with the same level number (see
Appendix A.5 for file levels). Return to the Output Fields and/or Select Criteria Screens (use PF6),
identify the fields, and correct.
FIELDS SELECTED FOR RETRIEVAL HAVE NO KEY MATCH
PRESS PF6 TO CORRECT
Fields specified in the output or selection criteria are from files that have no common fields in their
keys. Return to the Output Fields and/or Select Criteria Screens (use PF6), identify the fields, and
correct.
INTERNAL CARD READER IS BUSY
PRESS ENTER TO RETRY
The internal card reader may be temporarily overloaded. Press the ENTER key to try the job
submission again. If the failure persists, save your report specifications (use PF9) and try again
later.
INTERNAL CARD READER IS UNAVAILABLE
PRESS ENTER TO RETRY OR PF9 TO SAVE YOUR CRITERIA
Something is wrong with the internal card reader. Although you can try to submit the job again,
that is unlikely to be successful. Save your report specifications (use PF9) and try again later. You
should inform the AIRS database administrator if this error occurs.
September 1993
3-59
AQS Ad hoc Batch Retrieval
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
PLEASE USE A VALID PF-KEY
You pressed a key that is not listed at the bottom of the screen.
USER ACCOUNT CODE IS INVALID
PRESS PF6 TO CORRECT
The account code you specified is not valid for your user-ID. Return to the JCL Parameters Screen
(use PF6) and specify a valid account code, or save your report specifications (use PF9) and correct
the account at another time.
AQS Ad hoc Batch Retrieval 3-60 September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
3.3.10 Criteria Disposition
The Criteria Disposition Screen allows you to save your output specifications. This screen is displayed
after an Ad hoc Batch Retrieval job has been submitted, or after you interrupt the output submission
process by pressing the PF9 key on one of the preceding output specification screens.
The two formats of trie Criteria Disposition Screen are shown in Figure 3-22. The screen at the top of
the page is used when you have entered new output specifications and you did not use previously stored
criteria. The bottom screen is for use of previously saved output specifications. Both screens display
a job status message. If a batch job was submitted, the message gives its job number, such as "Job 5678
Submitted". It is a good practice to record the job number in case you need to contact the computer
center regarding the job. If you used the PF9 key to get to the Criteria Disposition Screen, the status
message says "job not submitted" to remind you that no output will be generated.
The screen for new output specifications is fairly simple. You just answer the question "Do you wish
to save the criteria?" by typing "y" for yes or "n" for no. The default answer "n" is displayed on the
screen; if you do not want to save the output specifications, simply press the ENTER key. To save your
specifications, answer "y" and type a name for them in the field provided. The name may be any
combination of 1-8 characters. If you answer "n", the name field must be blank.
The screen for previously saved output specifications has more options. First, you must specify what to
do with the "current" criteria. (If you have altered the saved criteria after reading them or if you are
using them with a different output, the current criteria are different from the "original" criteria.) You
can discard the current criteria, replace the original saved criteria with the current ones, or save the
current criteria with a different name. You make your choice by entering an "X" in the field provided
on the screen.
The default is option 1, to replace the original criteria with the current set. If you choose option 1, you
do not need to enter any other information on the Criteria Disposition Screen. If you choose to save the
current criteria with a new name (option 2), you must enter the new name in the field provided;
otherwise, the name field must be blank. Choose option 3 to save the current criteria to the public library
where others may use it. Choose option 4 to save the current criteria to the personal library of another
user. For options 3 and 4, your user-id will automatically become positions 1 - 3 of the name field.
(Note that you can, in effect, rename your criteria by saving the current criteria with a new name and
using the 'D' option on the Report Criteria Screen - AMP600 to delete the original criteria.)
To discard the current criteria, thereby leaving the original criteria intact, press PF3=end.
September 1993
3-61
AQS Ad hoc Batch Retrieval
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
01/19/93 AIRS Air Quality Subsystem AMP600F
Criteria Disposition
Report Kame: AD HOC
JOB Status : JOB 7720 SUBMITTED
Do you wish to save the criteria to your Library
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Instructions
After entering your choices on either Criteria Disposition Screen, press the ENTER key. If your entries
are valid, the program saves and/or deletes your output criteria, according to your specifications. If you
made an error, an error message appears at the top of the screen. Correct the mistake and press ENTER
again. The Ad hoc Batch Report Menu appears after your Criteria Disposition choices have been
processed.
If you do not wish to specify the disposition of your report criteria, you can exit from the Criteria
Disposition Screen by pressing one of these PF keys:
PF3
PF4
PF5
return to the AQS Ad hoc Batch Report Menu
return to the AIRS AQS Main Menu
terminate the AIRS session
If you use any of these; PF keys, the current output criteria are not saved and previously saved criteria
are not affected. If you use any other PF key or PA key, an error message appears at the top of the
screen and no action is taken with regard to disposition of output criteria. Note that you cannot use PF6
to back up to a previous screen from this screen.
Error Messages
The error messages listed below are displayed at the top of the Criteria Disposition Screen if you make
a mistake in specifying information.
"New Criteria" Screen
DO NOT ENTER A CRITERIA NAME FOR OPTION 'N'
The criteria name must be blank if you choose not to save the report criteria.
PLEASE ENTER 'Y OR 'N'
You must answer either "Y" or "N" to the question "Do you wish to save the criteria to your
library (Y or N)?".
PLEASE ENTER A CRITERIA NAME
If you choose tc save report criteria, you must enter a criteria name,
PLEASE USE A VALID PF-KEY
You pressed a key that is not listed at the bottom of the screen.
THIS CRITERIA NAME IS ALREADY ON FILE - PLEASE TRY AGAIN
The name you use when saving report criteria must be different from existing names. Enter a
different name or choose a different option.
September 1993
3-63
AQS Ad hoc Batch Retrieval
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
"Saved Criteria" Screen
PLEASE ENTER BLANK OR 'X'
You can not enter anything other than a blank or an "X".
PLEASE ENTER ONE OR MORE CRITERIA DISPOSITIONS
You must place an 'X' in at least one option.
PLEASE ENTER THE NEW CRITERIA NAME FOR YOUR LIBRARY
Option 2 requires a criteria name of 1 to 8 characters.
PLEASE ENTER USER IDENTIFICATION CODE
Be sure to verify the user-ID with the person that you intend to give a copy of the current criteria.
PLEASE ENTER A CRITERIA NAME
Option 4 requires a criteria name of 1 to 8 characters.
PLEASE ENTER A VALID USER IDENTIFICATION CODE
No match was found on the AIRS-TABLE-USER-PROFILE. Please check the user-ID and contact
the ADBA if necessary.
THIS CRITERIA NAME IS ALREADY ON FILE - PLEASE TRY AGAIN
You cannot 'replace' existing criteria with the same name in another user's library. You must, use
a new name or delete the existing criteria from the other user's library before you try again.
THIS CRITERIA NAME IS ALREADY ON FILE - PLEASE TRY AGAIN
Use option 1 to replace criteria with the same name. Use option 2 to save the current criteria to
your library under a different name.
PLEASE USE A VALID PF-KEY
You pressed a PF key not listed at the bottom of the screen.
AQS Ad hoc Batch Retrieval 3-64 September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
3.4 Optimizing Data Selection
The following sections provide additional information to assist you in specifying and interpreting an Ad
hoc retrieval, including efficiency considerations.
3.4.1 Field Abbreviations
To specify output fields and selection criteria, you must use a field abbreviation (ABBR). The
abbreviation identifies a field and file. Appendix A contains a list of the valid ABBR's for AQS and
GCS, and tables showing file level and key field ABBRs.
3.4.2 Key Fields and File Levels
When entering selection criteria, it is important to use the key fields from the one file - among all of the
files from which you are retrieving data - that has the highest file level. The use of key fields on the
Select Criteria Screen enables you to define the subset of data to retrieve from AQS or GCS (geographic,
pollutant, time period). By specifying selection criteria key field ABBRs from the file with the highest
possible file level, system access and job cost will both normally be reduced.
3.4.3 Output Criteria
This section contains a list of items that should be noted when specifying your Output Criteria and
evaluating your records.
• Values dependent on Units Code - values reported in units are output in the units in which
it is stored in the database. Therefore, you may want to output the units code.
• Multi-value fields - a detail output record will be generated for each occurrence of the
repeating field, i.e., Summary File Method Code repeats nine times for each record.
Therefore, if the records contain nine occurrences of Method Code, nine output records will
be generated. If a record only contains three occurrences, nine output records will be
generated; however, all but four unique records will be eliminated in the sort (three
containing the valued occurrences and one containing a blank occurrence). To eliminate the
blank occurrence, the selection criteria item Method Code NB, must be specified.
• Multi-value fields - if you select two multi-value fields with a different number of
occurrences, the field with the minimum number of occurrences is selected as the maximum
of occurrences for the retrieval. For example, if you select time period (five occurrences)
and method (nine occurrences) from the Summary File, five occurrences of time period and
method will be retrieved. The additional four occurrences of method will be ignored.
September 1993
3-65
AQS Ad hoc Batch Retrieval
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
Summary File time period indicator - the field abbreviation (ABBR) TIME field value
occurs five times for each record. The first occurrence is for year (Value YR) and
occurrences two through five are for the yearly quarters (Value Ql, Q2, Q3, Q4,
respectively). When specifying an Ad hoc Retrieval against the Summary File, to be able
to identify your data, you may want to enter a selection criteria condition against this field,
and also include this field in your output. By specifying TIME as an output field you will
be able to identify the time period that the summary data represents. By specifying TIME
as a selection criteria field you will be able to perform a ME condition to retrieve the
particular time period you wish to retrieve.
Output record uniqueness - there are several fields that make a record unique. Most of
these fields are the key fields indicated on your ABBR list, however not all these fields are
keys. If you fail to output certain fields for certain files, you may not be able to identify
the data you have retrieved. The following list identifies these fields, by file:
Summary File
EXCS - exceptional event flag
(0 - no exceptional event data exists,
1 - exceptional event data exists, but is not contained on this record,
2 - exceptional event data exists, and is contained on this record)
TIME - time period
(YR - year, Ql - first quarter,
Q2 - second quarter, Q3 - third quarter, Q4 - fourth quarter)
Hourly File
EXCH - exceptional event flag (running average data only)
(0 - no exceptional event data exists,
1 - exceptional event data exists, but is not contained on this record,
2 - exceptional event data exists, and is contained on this record)
3.4.4 Selection Criteria
This section contains a list of items that should be noted when specifying your Selection Criteria and
evaluating your output.
• To reduce the number of I/0's and the cost of a retrieval, it is recommended that you use
a key field abbreviation (reference Appendix A.S). It is also recommended that a ME, CE,
or a GE or GT with a LE or LT be used with a key field abbreviation.
• All entries (ABBR, COND, and VALUE) are linked with an 'AND' condition. All entries
for the same abbreviation with a CE are linked with an 'OR' condition.
STCM CE 01 - STCM CE 02
AQS Ad hoc Batch Retrieval 3-66 September 1993
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Validity flag
w - EPA Regional concurrence of exceptional event data
v - State entry of exceptional event data
As an example, say that ozone data is stored in the database under both parts per million
(units code = 007) and micrograms per cubic meter (units code = 001).
To select all values above the level of the National Ambient Air Quality Standard, you may
specify:
.125 (007) or +00000.12500 (007)
or
245.(001) or +00245.00000 (001)
When specifying a data value with the decimal point included, a units code is required to
indicate the units in which your selection value is expressed.
s99999.99999(uuu)
s - sign (required only for negative values)
9 - digit (you may drop leading and trailing zeros)
u - units code of value
Sample and Summary data values may be referenced in either of two ways:
1. As a value that contains its decimal point, or
2. As a value without its decimal point, paired with
the decimal indicator from the database record.
Null Value Codes - use the sample value without the DP for output and DP ABBR in
selection criteria with a BL condition. (Null value codes are stored with a blank DP.)
September 1993
3-61
AQS Ad hoc Batch Retrieval
-------
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
APPENDIX A
The following appendices are for AIRS AQS Ad hoc Batch Retrieval.
Appendix Description
A.I Field Abbreviation List in Logical Record Sequence
A.2 Field Abbreviation List in Field Name, File Name Sequence
A.3 Field Abbreviation List in Abbreviation Sequence
A.4 AQS File Cross-Reference for Common Fields
A.5 File Level, Key Field/Abbreviation Cross-Reference
A.6 Sample Ad hoc Batch Retrieval, Data Listing Report and Work File
A.7 Sample Ad hoc Batch Retrieval, Work File Only
A.8 Sample Ad hoc Batch Retrieval, Cross Tabulation Report
A-l
-------
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Appendix A.I
Field Abbreviation List in Logical Record Sequence
This appendix contains all the AQS and GCS field abbreviations listed by the logical record.
Air Quality Control Region (AQCR) (GCS)
Agency (GCS)
Attainment (GCS)
Collection and Analysis (GCS)
Composite Sample Value (AQS)
Daily Sample Value (AQS)
Descriptions (GCS)
EPA Region (GCS)
FIPS Area (GCS)
Hourly Sample Value (AQS)
Metropolitan Statistical Area (MSA) (GCS)
Monitor (AQS)
Parameter (GCS)
Parameter Standards (GCS)
P/A Monitor Sample Value (AQS)
P/A Monitor Summary (AQS)
P/A RO Summary (AQS)
Site and Monitor History (AQS)
State (GCS)
State and Local Air Monitoring Site (SLAMS) (AQS)
Sulfur Dioxide (SO:)
Carbon Dioxide (SO:)
Nitrogen Dioxide (NO,)
Ozone (O:)
Lead (PbJ
Paniculate Matter Total 0-1 Oam (PM10)
Urban Area (GCS)
A.1-1
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
Field Abbreviation List in Logical Record Sequence (1 of 15)
Agency tCCS) ABBR LENGTH
Agency Code AGCO 3 n
Agency Name AGKM 60
Agency Type Code AGTC 1
Reporting Organization Name for Monitor ROHM 60
State Code-FIPS STAG 2
AQ Control Region (CCS)
AOCR Code AQCR 3 n
AQCR Name AONH 54
AQCR Population AQPO 8 n
AQCR Size-Square Miles AOCT 7 n
AQCR Type Code AQCS 1
Attainment (GCS)
Attainment Status ATST 1
County Code-FIPS CCAT 3
Non-Attainment Total NATT 1
Parameter Code PCAT 5
Primary or Secondary Non-Attainment NAPS 1
State Code-FIPS SCAT 2
Collection and Analysis CGCS)
Conversion Factor to Standard Units CONV 10 n
Decimal Indicator for Standard Units DPIN 1
EPA Method Validity Flag Code VFCA 1
Interval INCD 1
Method Code Analysis Description ANYO 35
Method Code Collection Description COLL 30
Method of Collection Code MTCD 3 n
Minimum Detectable Value for Method HOCA 11 n
Parameter Code PCCA 5
Reference Equipment Description EQIP 30
Reference Method Code RMTH 13
Standard Units Code UTSS 3 n
State Code-FIPS (occurs 10 times} STCA 2
Units Code UNCO 3 n
Composite (AQS)
Composite Period CPRD 2 n
Composite Type Code CTYP 1
County Code-FIPS CNYC 3
Interval INVC 1
Method of Collection Code MTHC 3 n
Minimum Detectable Value MOCX 4 n
Minimum Detectable Value Decimal Indicator MOPC 1
Minimum Detectable Value with DP MDTC 7
Monitor identification Number MNIC 15
Monitor Type Code Hire 1
n*numeric
A. 1-2
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
F:ield Abbreviation List in Logical Record Sequency (2 of 15)
Composite (continued)
Null Value Reason Code
Number of Samples Used in Sample Value
Parameter Code
Parameter Occurrence Code
Sample Value
Sample Value Decimal Indicator
Sample Value Validity Flag
Sample Value with DP
Site Number Within County
State Code-FIPS
Units Code
Year
Daily Data (AQS)
County Code-FIPS
Day
Interval
Method of Collection Code
Ninimum Detectable Value
Minimum Detectable Value Decimal Indicator
Minimum Detectable Valt.« with DP
Monitor Identification Number
Monitor Type Code
Month
Null Value Reason Code
Parameter Code
Parameter Occurrence Code
Sample Value
Sample Value Decimal Indicator
Sample Value Start Hour
Sample Value Validity Flag
Sample Value with DP
Sampling Frequency
Site Number Withir County
State Code-HPS
Units Code
Year
ABBR
NVCC
SCNT
PLTC
POCC
SMCX
SDPC
VFGC
SMPC
SJTC
STCC
UNTC
YRRC
CNYD
DAYD
INVD
HTHO
MDDX
MOPD
MOID
MM ID
MTYD
HNTD
NVCO
PLTD
POCD
SMDX
SDPD
STNR
VFGD
SMPD
SFQD
S1TD
STCD
UNTO
YRRO
LEHSTH
2
5
1
4
1
2
7
4
2
3
2
3
2
1
3
5
1
7
15
1
2
A. I-3
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
Field Abbreviation List in Logical Record Sequence (3 of 15)
Description (GC5) ABBE LEH
Agency Type Code Description AGIO 60
Compass Sector Description for Site CPDS 10
Composite type Description for Composite Data CTDC 10
Exception Data Flag Indicator Description for SLAMS EXDL 30
Exception Data Flag Indicator Description for Surmary EXDS 30
Exception Data Flag Indicator Desscription EXDH 30
Interval Description for Composite INDC 30
Interval Description for Daily 1NDD 30
Interval Description for Hourly IMDK 30
Interval Description for SLAMS INDL 30
Interval Description for Summary INDS 30
Item Code ITCD 4
Item Code Description ITOS 60
Item Type Code ITEM 2
Land Use Code Description for Site IUDS 12
Location Setting Description for Site LOOS 25
Measurement Scale Code Description for Monitor NSDM 35
Mini nun Sampling Frequency Code Desc. for Suimary MMDS 20
Monitor Type Code Description for Composite MTDC 10
Monitor Type Code Description for Daily HTDO 10
Monitor Type Code Description for Hourly KTDH 10
Monitor Type Code Description for Monitor MTDM 10
Monitor Type Code Description for Surmary MTDS 10
Monitor Type Objective Code Description for Monitor MTOD 25
Monitoring Area Description for Monitor GOOH 30
Null Value Reason for Composite NVDC 35
Null Value Reason for Daily NVDO 35
Null Value Reason for Hourly NVDH 35
Project Class Code Description for Monitor CLDM 40
Required 24-Hour Sampling Freq. Code Desc.-State RSDM 20
Required 24-Hour Sampling Freq. Desc. - EPA for Monitor REDM 20
Road type Code Description for Nearby Roads for Monitor TYDM 60
Sample Value Validity Flag Description for Composite VFDC 40
Sample Value Validity Flag Description for Daily VFOD 40
Sample Value Validity Flag Description Hourly VFDH 40
Sampling Frequency for Daily Data SFDD 20
Sampling Frequency for SLAMS PMDL 20
Standard Units Code Description for Suimary UNDS 30
Summary Criteria Code Description for SLAMS N02 NOSD 60
Surmary Criteria Code Description for SLAMS Pb PBSD 60
Suimary Criteria Code Description for Suramary-EPA CRDE 60
Summary Criteria Code Description for Simnary-State CROS 60
Summary Criteria Description for SLAMS PM10 PMSE 60
Summary Criteria Description for SLAMS S02 SOSD 60
Units Code Description for Composite UKDC 30
Units Code Description for Daily UNDO 30
Units Code Description for Hourly UNOK 30
Units Code Description for SLAMS UNDL 30
Uorst Site Description for Monitor URDU 60
n*numer i c
A.1-4
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Field Abbreviation List in Logical Record Sequence (4 of 15)
EPA Region (GCS)
Region Code
Region Name
Region Population
Region Size-Square Miles
F1PS Area (GCS)
AQCR Code (occurs 3 times,)
City Codes in County-FI PS; (occurs 126 times)
City Code-FlPS
City Name
City Name for Monitor
City Population
City Population for Monitor
County Codes in City-FIPS (occurs 126 times)
County Code-FIPS
County Name
County Parameter Season Begin
County Parameter Season End (occurs 25 times)
County Population
County Population Percent Rural
County Size-Square Miles
Parameter Code (occurs 25 times)
State Code-FI PS
Hourly Date (AQS)
County Code-FI PS
Day
Exception Data Flag Indicator (Run. Avg. Data Only)
Hour
Interval
Method of Collection Code
Mimrrun Detectable Value
Minimum Detectable Value Decimal Indicator
Minimum Detectable Value with DP
Monitor Identification dumber
Monitor Type Code
Month
Null Value Reason Code
Parameter Code
Parameter Occurrence Code
Sample Value
Sample Value Decimal Indicator
Sample Value Validity Flag
Sample Value with DP
Site Number Within Coun-ry
State Code-FIPS
Units Code
Year
ABBE
REGH
RGNH
RCPO
RGSZ
AQCC
ARCR
AREA
ARNM
CYHM
ARPO
CYPO
ARCC
AREC
ARKC
PLBF
PLEF
ARPC
ARRC
AQSC
PLCF
STGF
CNYH
DAYH
EXCH
HURH
IHVK
MTHH
MDKX
MDPH
HDTH
MNIN
MTYH
MHTH
NVCH
PLTH
POCH
SHKX
SOPH
VFGH
SHPH
SITH
STCK
UWTK
YRRH
I.EMGTH
2 n
13
8 n
7 n
3 n
5
5
30
30
8 n
8 n
3
3
30
4 n
4 n
8 n
7 n
5
2
3
2
1
2
1
3 n
5 n
1
7
15
1
2
5
5
1
6
1
2
7
4
2
3 n
2
n=numeric
A. 1-5
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
Field Abbreviation List in Logical Record Sequence (5 of 15)
Metropolitan Stat. Area (GCS) ABBR LENG
CMSA CMSA 4
Metropolitan Statistical Area (MSA) Code HSAC 4
MSA Name MSAN 41
MSA Population MSAP 8 n
Monitor (AQS)
Action Type Code ATPY 3
Action Type Reason Code ATYR 2
Analyzing Laboratory Code ALCD 3 n
AOCR Code AQCH 3 n
Audit Date AUDI 8
City Code-FlPS CTYH 5 n
CMSA Represented CMSR 4 n
Collecting Laboratory Code CLCO 3 n
Consolidated Metropolitan Statistical Area CMSC 4 n
County Code-FI PS CNYM 3
Date of First Primary Standard Violation for PM10 PMVL 8
Pate Sampling Began DSGN 8
Date Sampling Ended DEND 8
Date Siting Criteria Met DCRT 6
Direction From Monitor ORHO 2
Distance From tnlet INLT 2 n
Distance From Road Nearby (Meters) (occurs 3 times) DSTR 4 n
Dominant Source of Pollutant Code DSCR 6
First Estimated Nunber of Exceedances Correction-EPA CORE 1
First Estimated Nunfcer of Exceedances Correction-State COBS 1
Height of Obstruction OBST 2 n
Horizontal Distance (from support) HODS 1 n
Measurement Scale Code MSCL 1
Metropolitan Statistical Area Code MSAH 4 n
Monitor Comments - 1 HCH1 62
Monitor Comments - 2 MCM2 62
Monitor Identification Number MON1 15
Monitor Open Path Number MOPN 1
Monitor Street Munber STNU 1
Monitor Type Code MTYM 1
Monitor Type Effective Date DMTM 6
Monitor Type Objective Code MT06 1
Monitoring Area Code GOHN 4 n
NSA Represented MSAR 4 n
Nonattainment Area NONA 5
Number of Scheduled Samples Per Month HUMS 2
Number Scheduled Samples per Month (occurs 12 times) NSKT 2 n
PAHS Required Sampling Frequency PAHS 1
Parameter Code PLTH 5
Parameter Occurrence Code POCM 1
Probe Height From Ground (Meters) PROS 3 n
Probe Location Code LOCA 1
Project Class Code CLSS 2
n=numeric
A.l-6
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Field Abbreviation List in Logical Record Sequency (6 of 15)
Monitor (AOS) (continued)
QA Effective Date
QA Plan Approved
Reference Method Used Begin Date
Reference Method Used Code
Region Code
Reporting Organization Eode
Reporting Organization effective Date
Reporting Organization Name for Monitor
Required 24-Hour Sampling Frequency Code EPA
Required 34-Hour Sampling Frequency Code State
Required Sampling frequency Effective Date-EPA
Required Sampling Frequency Effective Date-State
Screening File File-ID
Short Term Sampling Schedule Completion Date-EPA
Short Term Sampling Schedule Completion Date-State
Short Term Schedule Satisfied Code-State
Short Term Schedule Satisfied-EPA
Short Term Schedule Satisfied-State
Site Location Type
Site Nunber Within County
Siting Criteria Met Cod!
State Code-FIPS
Surrogate Flag-TSP/PH10
Type Obstruction
Unrestricted Air Flow
Urban Area Represented Code
Vertical Distance (From Support)
Worst Site Code
ABBR
DPAO
PAQA
MTDT
MTHU
RGCD
ROCD
ROED
ROHM
RSFE
RSFS
RSDE
DRSS
SCfiN
CMPE
CMPS
SCHS
SCHE
SCHS
SILO
SITU
SCRT
STCM
SURR
OBTY
A1RF
URBN
VERT
WRST
6
1
6
1
2 n
3 n
6
60
1
1
8
8
6
8
8
1
1
1
1
4
1
2
1
1
1
4 n
1 n
1
Parameter Standards (GCSj
Interval
Parameter Code
Primary Standard
Secondary Standard
Standard Units Code
State Code-FIPS
Parameter (CCS)
Chemical Abstract Service No
Parameter Abbreviation
Parameter Code
Parameter Name
Validity Flag (occurs 20 times)
1WTV
PCPS
PR IS
SECS
STDU
STPS
CASH
PLA8
PLLT
PLLN
VFLG
1
5
8 n
8 n
3 n
2 n
9
5
5
70
1
A. 1-7
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
Field Abbreviation List in Logical Record Sequence (7 of 15)
P/A Monitor Sample Vajue (AOS)
Actual (Known) Concentration Value for Level 1
Actual (Known) Concentration Value for Level 1 w/DP
Actual (Known) Concentration Value for Level 2
Actual (Known) Concentration Value for Level 2 w/DP
Actual (Known) Concentration Value for Level 3
Actual (Known) Concentration Value for Level 3 w/DP
Actual (Known) Concentration Value for Level 4
Actual (Known) Concentration Value for Level '4 w/DP
Actual (Known) Concentration Value for Level 5
Actual (Known) Concentration Value for Level 5 w/DP
Audit Classification
Audit Classification Description
County Code-FI PS
Day
Indicated (Observed) Concentration Value for Level 1
Indicated (Observed) Cone. Value for Level 1 w/DP
Indicated (Observed) Concentration Value for Level 2
Indicated (Observed) Cone. Value for Level 2 w/DP
Indicated (Observed) Concentration Value for Level 3
Indicated (Observed) Cone. Value for Level 3 w/DP
Indicated (Observed) Concentration Value for Level 4
Indicated (Observed) Cone. Value for Level 4 w/DP
Indicated (Observed) Concentration Value for Level 5
Indicated (Observed) Cone. Value for Level 5 w/DP
Interval
Interval Description
Level 1 Value Decimal Indicator
Level 2 Value Decimal Indicator
Level 3 Value Decimal Indicator
Level 4 Value Decimal Indicator
Level 5 Value Decimal Indicator
Local Primary Standard Source-Accuracy
Local Standard Source Description
Method of Collection Code
Monitor Identification Nuifcer
Monitor Type Code
Monitor Type Code Description for P/A Monitor Data
Month
Parameter Code
Parameter Occurrence Code
Site Number Within County
State Code-FI PS
Type of Accuracy Audit
Type of Audit Description
Type of Data
Units Code
Units Description
Year
Zero Span Value
Zero Span Value Decimal Indicator
Zero Span w/DP
ABBR
KXL1
KCL1
KXL2
KCL2
KXL3
KCL3
KXL4
KCL4
KXLS
KCL5
AUCP
AUDP
CNYP
DAYP
OXL1
OCL1
OXL2
OCL2
OXL3
OCL3
OXL4
OCU
OXL5
OCL5
IHVP
INDP
DPL1
DPL2
OPL3
DPL4
DPL5
LPSP
LPDP
KTHP
MNIP
MTYP
KTDP
MNTP
PLTP
POCP
S1TP
STCP
TYAP
TADP
TYDP
UNTP
UNDP
YRRP
2SVX
ZSDP
ZSW
LEHGIH
5 n
7
5 n
7
5 n
7
5 n
7
5 n
7
1
10
3
2
5 n
7
5 n
7
5 n
7
5 n
7
5 n
7
1
30
28
3 n
15
1
10
2
5
1
4
2
1
45
1
3 n
30
2
4 n
1
7
n=nuneric
A.l-8
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Field Abbreviation List in Logical Record Sequence (8 of 15)
P/A Monitor Sunmary (ACS)
Audit Classification
Audit Classification Description
Average Lower Probability Limits
Average Upper Probability Limits
Collocated Sites with Simples Below Limit
County Code-FtPS
Interval
Interval Description
Level 1, 2, and 3 Analyzer Multipoint Audits
Level 1 Accuracy Mean
Level 1 Accuracy Standa-d Deviation
Level 1 Analyzer Multipoint Audits
Level 1 Loner Probability Limit Average
Level 1 Upper Probability Limit Average
Level 2 Accuracy Mean
Level 2 Accuracy Standard Deviation
Level 2 Analyzer Multipoint Audits
Level 2 Lower Probability Limit Average
Level 2 Upper Probability Limit Average
Level 3 Accuracy Mean
Level 3 Accuracy Standard Deviation
Level 3 Analyzer Multipoint Audits
Level 3 Loner Probability Limit Average
Level 3 Upper Probability Limit Average
Level it Accuracy Mean
Level 4 Accuracy Standard Deviation
Level 4 Analyzer Multipoint Audits
Level 4 Lower Probability Limit Average
Level 4 Upper Probability Limit Average
Level 5 Accuracy Mean
Level 3 Accuracy Standard Deviation
Level 5 Analyzer Multipoint Audits
Level 5 Lower Probability Limit Average
Level 5 Upper Probability Limit Average
Local Primary Standard Source-Accuracy
Local Standard Source Description
Local Standard Source Description
Method of Collection Code
Monitor Data Recording Mode
Monitor Identification Nurber
Monitor Type Code
Monitor Type Code Description for P/A Monitor Sunmary
Parameter Code
Parameter Occurrence Code
Pollutant Average Number of Samplers
Precision Checks Included in Calculations
Precision Mean
Precision Standard Deviation
Reporting Organization Code
Site Number Within County
State Code-FI PS
Time Period
Type of Accuracy Audit
Type of Audit Description
Type of Audit Description
AIM
AUCN
AUON
ALPN
AUPN
CSBN
CMYK
INVN
IKON
MAAN
AM1N
AS1N
MAIN
LP1H
UP1H
AM2N
AS2N
MA2N
LP2N
UP2N
AM3N
AS3N
MA3M
LP3N
UP3N
AM4N
AS4N
MA4N
LP4N
UP4N
AM5N
AS5N
MA5N
LP5K
UP5N
LPSN
LPDk
LPDR
MTMN
TYDN
MNIN
MTYN
MTDM
PLTK
POCK
PAWN
PC IN
PMEN
PSDV
ROGN
SITN
STCN
T1MN
TYAN
TADR
TAON
LENGTH
1
10
3
3
5 n
3
1
30
4 n
12 n
12 n
4 n
3
3
12 n
12 n
4 n
3
3
12 n
12 n
4 n
3
3
12 n
12 n
4 n
3
3
12 n
12 n
4 n
3
3
1
28
28
3 n
1
15
1
10
5
1
5 n
4 n
12
10
3 n
4
2
2
1
45
45
n=numenc
A. 1-9
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
Field Abbreviation List in Logical Record Sequence (9 of IS)
P/A Monitor Suwnary (continued) ABBR LEMG
Units Code UNTN 3 n
Units Description UNDN 30
Valid Collocated Data Pairs VCON 4 n
Year YRRN 2
P/A Hep. Org. Surmary (ACS)
Average Collocated Sampler Sites ACSS 4 n
Average Lower Probability Limits ALPR 3
Average Number of Approved Analyzers ANAA 3 n
Average Upper Probability limits AUPR 3
Collocates Sites with Samples Below Limit CSBR 5 n
Level 1, 2, and 3 Analyzer Multipoint Audits MAAR 4 n
Level 1 Lower Probability Limit Average LP1R 3
Level 1 Upper Probability Limit Average UP1R 3
Level 2 Lower Probability Limit Average LP2R 3
Level 2 Upper Probability Limit Average UP2R 3
Level 3 Lower Probability Limit Average LP3R 3
Level 3 Upper Probability Limit Average UP3R 3
Level 4 Analyzer Multipoint Audits MAAR 4 n
Level 4 Lower Probability Limit Average LP4R 3
Level 4 Upper Probability Limit Average UP4R 3
Level 5 Analyzer Multipoint Audits MASR 4 n
Level 5 Lower Probability Limit Average LP5R 3
Level 5 Upper Probability Limit Average UP5R 3
Local Primary Standard Source-Accuracy LPSR 1
Monitor Data Recording Mode TYDR 1
Parameter Code PLTR 5
Pollutant Audits Performed on Network PAPR 4 n
Pollutant Average Number of Samplers PANR 5 n
Precision Checks included in Calculations PCIR 4 n
Reporting Organization Code ROGR 3 n
State Code-flPS STCR Z
Time Period TIKR 2
Type of Accuracy Audit TYAR 1
Valid Collocated Data Pairs VCDR 4 n
tear YRRR 2
Site CAQS)
Air Basin A1RB 2
Beam Length BLEN 4 n
Compass Sector (Direction from CBD) CPSS 2
County Code-fIPS CNTY 3 n
Date Last Updated by ACS UPDATE DTUP 6
Date Site Established DEST 8
Date Site Terminated DTRM 8
Datum DATU 2
Difference Between GMT and Standard Time DGMT 2
Direction of Meteorological Site DIRE 2
Direction to Street DRST 2
Direction to Transmitter DTRA 3
Distance From City (Kilometers) DCTY 3
Distance of Meteorological Site DIST 5 n
Elevation of Site Above Mean Sea Level EMSL 5 n
Estimated of Accuracy ACCU 10
Headquarters Evaluation Date HOEV 8
n=nuner i c
A.l-10
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Field Abbreviation List in Logical Record Sequency (10 of 15)
Site (A8S) (continued)
Land Use Code
Land Use Under Path
Latitude
Location Description
Location Setting Code
Longitude
Maximum Beam Height
Meteorological Site ID
Method of Determination
Him nun Bean Height
Open Path Number
Receiver Height
Regional Evaluation Date
Scale
Site Comments 1
Site Consents 2
Site Identification Nunber
Site Number Within County
State Code-FIPS
State or Local ID
Street Address
Street Name
Support Agency Code
Tangent Street Number
Traffic Flow
Transmitter Height
Type Meteorological Site
Type Road
Universal Transverse Mercator (UTM) System Zone
UTH Easting (Horizontal) Coordinate (Meters)
UTH Northing (Vertical) Coordinate (Meters)
Year of Traffic Flow
Site and Monitor History (AQS)
County Code-FIPS
Date Change Posted by AIRS AQS UPDATE
Monitor Identification Number
New Monitor Type Effective Date
Mew Reporting Organization Effective Date
New Required Sampling Frequency Effective Date-State
New Site or Monitor Detail Field Value
Old EPA Required Sampl'ng Frequency Code
Old EPA Required Sampling Frequency Effective Date
Old Moni tor Type Code
Old Monitor Type Effective Date
Old Reporting Organization Code
Old Reporting Organization Effective Date
Old Site or Monitor Detail Field Value
Old State Required Sampling Frequency Code
Old State Required Sampling Frequency Effective Date
Parameter Code
Parameter Occurrence Code
Required Sampling Freqjency Effective Date-EPA
Site Nunber Within County
Site or Monitor Field Name
State Code-FIPS
A8BR
LUSE
LAND
LATT
LOCO
LOCN
LONG
MAXH
MSID
DETR
MINH
OPNO
REHT
RGEV
SCAL
SCM1
SCK2
SIT1
SITE
STCS
STLO
STRT
STRM
SAGC
STNO
TRAF
THGT
TMS1
TYPR
UTHZ
UTHE
UTKN
TRYR
CNYT
CHGD
MM IT
NHTD
NROO
NSSD
NEWV
OSFE
OSED
OMTY
OHTD
OROG
OROD
OLDV
OSFS
OSSD
PLTT
POCT
NSED
S1TT
CHGF
STCT
LENGTH
1
1
11 n
68
1
12 n
2 n
9
10
2 n
1
2
8
6
68
68
9
4 n
2
10
40
20
3 n
1
6 n
2 n
1
1
2
8 n
7 n
3
6
15
8
8
8
8
1
8
1
8
3 r
8
8
1
8
5
1
8
4
2
2
n=numeric
A.1-1I
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
Field Abbreviation List in Logical Record Sequence (11 of 15)
State and local Air Monitoring Sites (SLAHS) JAPS) ABBS LENGTH
Monitor Identification Number MNU 15
(State/County/Site/Parameter/
Parameter Occurrence Code)
F1PS State Cod* STCL 2
FJPS County Code CNYL 3
Site Number Within County SJTL 4
Parameter Code PLTL 5
Parameter Occurrence Code POCL 1
Year YRRL 2
Interval IHVL 1
Method of Collection Code (occurs 5 times) HTML 3 n
Units Code UNTL 3 n
1-Hour Observations OSS1 4 n
24-Hour Observations DBS7 3 n
Exception Data Flag Indicator EXCl 1
Nuitoer of Observations per Concentration Range (1-9) FRQ1 4 n
FRQ2 4 n
FRQ3 4 n
FRQ4 4 n
FRQ5 4 r.
FRQ6 4 n
FRQ7 4 n
FRQ8 4 n
FRQ9 4 n
SO? Data
Decimal Indicator for SO, SODP 1
Highest 24-Hour Value S1XX 4 n
Highest 24-Hour Value with DP S1XK 6
Date of the Highest 24-Hour Value S1XD 4
Second Highest 24-Hour Value S2XX 4 n
Second Highest 24-Hour value with DP S2XK 6
Date of the Second Highest 24-Hour Value S2XD 4
Highest 3-Hour Average Value S1YX 4 n
Highest 3-Hour Average Value with DP S1YM 6
Date and Hour of the Highest 3-Hour Average Value S1YT 6
Second Highest 3-Hour Average Value S2YX 4 n
Second Highest 3-Hour Average Value with DP S2YH 6
Date and Hour of the Second Highest 3-Hour Average S2rT 6
Value
Secondary Standard 3-Hour Average Violations SSYV 4 n
Primary Standard 24-Hour Violations PSXV 4 n
Sample Value Average SOAX 4 n
Sample Value Average with DP SOAM 6
Sunnary Criteria Code SOSC 1
nsnunenc
A.l-12
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Field Abbreviation List in Logical Record Sequence (12 of 15)
State and Local Air Monitoring Sites (SLAMS) (AQS)
(continued)
CO Data
Decimal indicator for CO
Highest 1-Hour Value
Highest 1-Hour Value with DP
Date and Time of the Highest 1-Hour Value
Second Highest 1-Hour Value
Second Highest 1-Hour Value with DP
Date and Time of the Second Highest 1-Hour Value
Highest 8-Hour Average Value
Highest 8-Hour Average Value with DP
Date and Time of the Highest 8-Hour Average Value
Second Highest 8-Hour Average Value
Second Highest 8-Hour Average Value with DP
Date and Time of the Second Highest 8-Hour Average
Value
Primary Standard 1-Hour Violations
Primary Standard 6-Hour Average Violations
Second Highest 1-Hour Value
Second Highest 1-Hour Value with DP
Date and Time of the Second Highest 1-Hour Value
Highest 24-Hour Value
Highest 24-Hour Value with DP
Date of the Highest 24-Hour Value
NO? Data
Decimal Indicator for N!3V
Highest 1-Hour Value
Highest 1-Hour Value with DP
Date and Time of the Highest 1-Hour Value
Second Highest 24-Hour Value
Second Highest 24-Hour Value with DP
Date of the Second Highest 24-Hour Value
Sample Value Average
Sample Value Average with DP
Summary Criteria Code
ABBR
COOP
C11X
C11H
cm
C21X
C21H
C21T
C1ZX
CUM
C1ZT
C2ZX
C2ZM
C2ZT
CEX1
CEXZ
«21X
N21M
N21T
N1XX
N1XM
N1XD
NOOP
N11X
N11K
NUT
N2XX
N2XH
N2XD
NOAX
NOAM
NOSC
1
4 n
6
6
4 n
6
6
4 n
6
6
4 n
6
6
4 n
4 n
4 n
6
6
4 n
6
4
n=nuneric
A.l-13
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
Field Abbreviation List in Logical Record Sequence (13 of IS)
State arid local Air Monitoring Sites (SLAHS)(ACS) ABBR LEMG
(continued)
0, Data
Decimal Indicator for 03 030P 1
Highest Daily Value 031X 4 n
Highest Daily Value with DP 031H 6
Date of the Highest Daily Value 031T 6
Second Highest Daily Value . 032X 4 n
Second Highest Daily Value with DP 032M 6
Date of the Second Highest Daily Value 032T 6
Third Highest Daily Value 033X 4 n
Third Highest Daily Value with DP 033* 6
Date of the Third Highest Daily Value 033T 6
Fourth Highest Daily Value 034X 4 n
Fourth Highest Daily Value with DP 034M 6
Date of the fourth Highest Daily Value 034T 6
Primary Standard 1-Hour Violations 03EX 3 n
Pb Data
Decimal Indicator for Pb (occurs 4 tines) PBDP 1
Hunter of Samples in Quarter (occurs 4 times) PENS 2 n
Sample Value Average for Quarter (occurs 4 times) PBXA 5
Sample Value Avenge for Quarter with DP PBKX 6
(occurs 4 times)
Summary Criteria Code for Quarter (occurs 4 times) PBSC 1
Quarter (occurs 4 times) PBQR 1
PH.,. Data (occurrence specified or all)
Decimal Indicator for PM10 PHDP 1
Sample Value Average PMAX 4 n
Sample Value Average with DP PttAK 6
Sumnary Criteria Code PMSC 1
Sampling Frequency (occurs 4 times) PHSF 1
24-Hour Observation (occurs 4 times) PHXO T> n
Additional Observations (occurs 4 times) PMSO 3 n
Date Sampling Frequency Effective (occurs 4 times) PUDS 4
Primary Standard Violation (occurs 60 times) PHEX 4 n
Primary Standard Violation with DP (occurs 60 times) PHEV 6
Date of Violation (occurs 60 times) PMED 4
State (CCS)
Parameter Code (occurs 25 times) PCST 5
State Abbreviation STAB 2
State Code-FI PS STAT 2
State Name STNH 20
State Parameter Season End (occurs 25 times) PEST 4 n
State Pb Parameter Season Begin (occurs 25 times) PBST 4 n
State Population STPO 8 n
State Size-Square Miles STSZ 7 n
n*numeric
A.l-14
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Field Abbreviation List in Logical Record Sequence (14 of 15)
Summary Data
-------
AIRS User's Guide
Ad hoc Retrieval Volume AQ5
Field Abbreviation List in Logical Record Sequence (15 of 15)
Solitary Data (ACS) (continued) ABBR LENGTH
Seventy Percent!le P70X 6 n
Seventy Percent He Kith DP PC70 7
Site Nunfcer Within County SITS 4
Standard Units Code UNTS 3 n
State Code-FI PS STCY 2
Suimary Criteria Code-EPA CRTE 1
Suimary Criteria Code-State CRTF 1
Tenth Percentile PI OX 6 n
Tenth Percent)le with Dp PC10 7
Third Haxiiun Value MX3X 6 n
Third Maxiiun Value with DP MXV3 7
Thirty Percentile P30X 6 n
Thirty Percentile with DP PC30 7
Time Period (occurs 5 times) TIME 2
Valid Days VDAY 3 n
Year VRRS 2
Yearly Weighted Arithmetic Mean UTDX 7 n
Yearly Weighted Arithmetic Mean with DP WTDA 8
Urban Area (AQS) (CCS)
Urban Area Code UR8C 4
Urban Area Name URNM 45
Urban Area Population URNP 8 n
A.I-16
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Appendix A.2
Field Abbreviation List in Field Name, File Name Sequence
This appendix contains all the AQS and GCS field abbreviations in field name, file name sequence.
A.2-1
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
Field Abbreviation List in Field Name, File Name Sequence (1 of 14)
File Name
SLAMS
SLAMS
SLAMS
Monitor
Monitor
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor Sample Value
SLAMS
Agency (GCS)
Agency (GCS)
Agency (GCS)
Description (CCS)
Site
Monitor
AQ Control Region {GCS)
Monitor
FIPS Area (GCS)
AQ Control Region (GCS)
AQ Control Region (GCS)
AQ Control Region (GCS)
AQ Control Region (GCS)
Summary Data
Suimary Data
Sunmary Data
Smnery Date
Attainment (GCS)
P/A Monitor Sample Value
P/A Monitor Surinary
P/A Monitor Sample Value
P/A Monitor Summary
Monitor
P/A Rep. Org. Summary
P/A Monitor Summary
P/A Rep. Org. Summary
P/A Rep. Org. Summary
P/A Monitor Sunmary
P/A Rep. Org. Suimary
Site
Parameter (GCS)
FIPS Area (GCS)
FIPS Area (GCS)
Field Description ABBR
1-Hour Observations OBS1
24-Hour Observations OBS7
24-Hour Observations for PK10 (occurs 4 times) PMXO
Action Type Code ATPY
Action Type Reason Code ATYR
Actual (Known) Concentration Value for Level 1 KXL1
Actual (Known) Concentration Value for Level 1 w/DP KU1
Actual (Known) Concentration Value for Level 2 KXL2
Actual (Known) Concentration Value for Level 2 w/DP KCL2
Actual (Known) Concentration Value for level 3 KXL3
Actual (Known) Concentration Value for Level 3 w/DP KCL3
Actual (Known) Concentration Value for Level 4 KXL4
Actual (Known) Concentration Value for Level 4 w/DP KCL4
Actual (Known) Concentration Value for Level 5 KXL5
Actual (Known) Concentration Value for Level 5 w/DP KCL5
Additional Observations for PM10 (occurs 4 times) PNSD
Agency Code AGCD
Agency Name AGNH
Agency Type Code AGTC
Agency Type Code Description AGTD
Air Basin AIRS
Analyzing Laboratory Code ALCD
AOCR Code AQCR
AQCR Code AQCM
AOCR Code (occurs 3 times) AQCC
AOCR Name AQHH
AOCR Population AQPO
AOCR Size-Square Miles AOCT
AOCR Type Cooe AOCS
Arithmetic Mean ARMX
Arithmetic Mean with DP ARMN
Arithmetic Standard Deviation ARSX
Arithmetic Standard Deviation with DP ARSD
Attainment Status ATST
Audit Classification AUCP
Audit Classification AUCK
Audit Classification Description AUDP
Audit Classification Description AUDN
Ajdit Date AUDT
Average Collocated Sampler Sites ACSS
Average Lower Probability Limits ALPN
Average Lower Probability Limits ALPR
Average Number of Approved Analyzers ANAA
Average Upper Probability Limits AUPN
Average Upper Probability Limits AUPR
Beam Length BLEN
Chemical Abstract Service No CASN
City Codes in County-FIPS (occurs 126 times) ARCR
City Code-FIPS AREA
4 n
3 n
3 n
3
2
5 n
7
5 n
7
5 n
7
5 n
7
5 T
7
3 n
3 n
60
1
60
2
3 n
3 n
3 n
3 n
54
8 n
7 n
1
7
8
6
8
1
1
1
10
10
8
4
3
3
3
3
3
4
9
5
5
n
rt
n
n=numeric
A. 2-2
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Field Abbreviation List in Field Name, File Name Sequence (2 of 14)
File Name
Monitor
F1PS Area (CCS)
FIPS Area (CCS)
F1PS Area (GCS)
FIPS Area (CCS)
MSA (GCS)
Monitor
Monitor
P/A Monitor Sumtary
P/A Rep. Org. Summary
Description (GCS)
Site
Composite
Composite
Description (GCS)
Monitor
Collection and Analysis (GCS)
FIPS Area (GCS)
Attainment (GCS)
Composite
Daily Data
FIPS Area (GCS)
Hourly Data
Monitor
P/A Monitor Sample Value
P/A Monitor Summary
Site
Site and Monitor History
SLAMS
Summary Data
FIPS Area (GCS)
FIPS Area (GCS'i
FIPS Area (GCS)
FIPS Area (GCS)
FIPS Area (GCS)
FIPS Area (GCS)
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
Site and Monitor History
Site
Monitor
SLAMS
Field Description
City Code-FIPS
City Name
City Name for Monitor
City Population
City Population for Monitor
CMSA
CMSA Represented
Collecting Laboratory Code
Collocated Sites with Samples Below Limit
Collocates Sites with Samples Below Limit
Compass Sector Description for Site
Compass Sector (Direction from CBD)
Composite Period
Composite Type Code
Composite type Description for Composite Data
Consolidated Metropolitan Statistical Area
Conversion Factor to Standard Units
County Codes in City-FIPS (occurs 126 times)
County Code-FIPS
County Code-FJPS
County Code-FIPS
County Code-FIPS
County Code-FIPS
County Code-FIPS
County Code-FIPS
County Code-FIPS
County Code-FIPS
County Code-FIPS
County Code-FIPS
County Code-FIPS
County Name
County Parameter Season Begin
County Parameter Season End (occurs 25 times)
County Population
County Population Percent Rural
County Size-Square Miles
Date and Hour of the Highest 3-Hour Average 502
Date and Hour of the Second Highest 3-Hr Avg for S02
Date and Time of the Highest 1-Hour CO Value
Date arid Time of the Highest 1-Hour N02 Value
Date and Time of the Highest 8-Hour Average CO Value
Date and Time of the Second Highest 1-Hour CO Value
Date and Time of the Second Highest 1-Hour N02 Value
Date and Time of the Second Highest 8-Hour Avg CO Val.
Date Change Posted by AIRS AQS UPDATE
Date Last Updated by AQS UPDATE
Date of First Primary Standard Violation for PM1Q
Date of PM10 Violation (occurs 60 times)
ABBR
CTY*
ARNH
CTNM
ARPO
CYPO
CMSA
CMSR
CLCD
CSBN
CSBR
CPDS
CPSS
CPRD
CTYP
CTDC
CKSC
CONV
ARCC
CCAT
CNYC
CNYD
AREC
CNYH
CNYM
CNYP
CNYN
CMTY
CKYT
cm
CKYS
ARNC
PLBF
PLEF
ARPC
ARRC
AQSC
S1YT
S2YT
cm
N11T
C1ZT
C21T
N21T
C2ZT
CHGD
DTUP
PMVL
PMED
LCTH
5 n
30
30
8 n
8 n
4
4 n
3 n
5 n
5 n
10
2
2 n
1
10
4 n
10 n
3
3
3
3
3
3
3
3
3
3 n
3
3
3
30
4 n
4 n
8 n
4
7 n
6
6
6
6
6
6
6
6
6
8
8
4
n=nuroenc
A.2-3
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
Field Abbreviation List in Field Name, File Name Sequence (3 of 14)
File Hame
field Description
ABBR LGTH
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
Monitor
Monitor
SLAMS
Site
Site
Monitor
Site
Daily Data
Hourly Data
P/A Monitor Sample Value
Suimary Data
Surma ry Data
Suimary Data
Summary Data
SLAMS
Sunmary Data
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
Collection and Analysis (GCS)
Site
Monitor
Site
Site
Site
Site
Monitor
Monitor
Site
Monitor
Site
Collection and Analysis (GCS)
Suimary Date
Sumtary Data
Site
SLAMS
Summary Data
Description (GCS)
Description (GCS)
Description {GCS)
Date of the Fourth Highest Deity 03 Value
Date of the Highest 24-Hour N02 Value
Date of the Highest 24-Hour $02 Value
Date of the Highest Daily 03 Value
Date of the Second Highest 24-Hour K02 Value
Date of the Second Highest 24-Hour S02 Value
Date of the Second Highest Daily 03 Value
Date of the Third Highest Daily 03 Value
Date Samp I ing Began
Date Sampling Ended
Date Sampling Freq. Effective for PM10 (occurs 4 times)
Date Site Established
Date Site Terminated
Date Siting Criteria Met
Da tun
Day
Day
Day
Day and Time of First Maximum Value
Day and Time of Second Maximm Value
Days that Exceed Alert Level
Decimal Indicator
Decimal Indicator for CO
Decimal Indicator for Mean Values
Decimal indicator for N02
Decimal Indicator for 03
Decimal Indicator for Pb (occurs 4 times)
Decimal Indicator for PM10
Decimal Indicator for S02
Decimal Indicator for Standard Units
Difference Between GMT end Standard Time
Direction From Monitor
Direction of Meteorological Site
Direction to Street
Direction to Transmitter
Distance From City (Kilometers)
Distance From Inlet
Distance From Road Nearby (Meters) (occurs 3 times)
Distance of Meteorological Site
Dominant Source of Pollutant Code
Elevation of Site Above Mean Sea Level
EPA Method Validity Flag Code
Estimated Days Greater Then Standard-EPA
Estimated Days Greater Than Standard-State
Estimated of Accuracy
Exception Data Flag Indicator
Exception Data Flag Indicator
Exception Data Flag Indicator Description for SLAHS
Exception Data Flag Indicator Description for Sinmary
Exception Data Flag Indicator Description
034T
N1XD
S1XD
031 T
H2XO
$2X0
032T
033T
DBGN
DEND
PMDS
DEST
DTRM
DCRT
DATU
DAYD
DAYH
DAYP
MXT1
MXT2
XALT
DPIS
COOP
DPMS
HOOP
030P
PBDP
PMDP
SCOP
DPIN
DGHT
DRMO
DIRE
DRST
DTRA
DCTY
IKLT
DSTR
DIST
DSCR
EMSL
VFCA
ESTE
ESTD
ACCU
EXCL
EXCS
EXDL
EXDS
EXDH
6
4
4
6
4
4
6
6
8
a
4
a
a
6
2
2
2
2
6
6
3 n
1
1
1
1
1
1
1
1
1
2
2
2
2
3
3
2 r
4 r
5 n
6
5 n
1
6 n
6 n
10
1
1
30
30
30
n=numenc
A.2-4
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Field Abbreviation List in Field Name, File Name Sequence (4 of 14)
file Mame
Hourly Data
Surmary Data
Summary Data
Summary Data
Summary Data
Monitor
Monitor
Suimary Data
Surma ry Data
SLAMS
SLAMS
Summery Data
Summary Data
Summary Data
Summary Data
Surinary Data
Site
Monitor
SLAHS
SLAMS
SLAMS
SLAHS
SLAHS
SLAMS
SLAMS
SLAMS
SLAMS
SLAHS
SLAMS
SLAMS
SLAHS
SLAMS
Monitor
Hourly Data
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor S.ample Value
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor Sample value
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor Sample Value
Collection and Analysis (GCS)
Composite
Daily Data
field Description ABBR
Exception Data Flag Indicator (Run. Avg. Data Only) EXCN 1
Fifth Maximum Value MX5X 6 n
Fifth Maximum Value with DP MXVS 7
Fifty Percent)le P50X 6 n
Fifty Percentile with DP PC50 7
First Estimated Number of Exceedances Correct ion-EPA CORE 1
First Estimated Number of Exceedances Correction-State CORS 1
First Maximum Value MX1X 6 n
First Maximum Value with OP MXV1 7
Fourth Highest Daily 03 Value 034X 4 n
Fourth Highest Daily 03 Value with DP 034N 7
Fourth Maximum Value HX4X 6 n
Fourth Maximum Value with DP MXV4 7
Geometric Mean GHMX 7 n
Geometric Mean with DP GMMN 8
Geometric Standard Deviation GMSD 6 n
Headquarters Evaluation Date HOEV 8
Height of Obstruction OBST 2 n
Highest 1-Hour CO Value C11X 4 n
Highest 1-Hour CO Value with DP C11M 7
Highest 1-Hour N02 Value HIIX 4 n
Highest 1-Hour N02 Value with DP N11H 7
Highest 26-Hour N02 Value N1XX It n
Highest 24-Hour N02 Value uith DP N1XH 7
Highest 24-Hour 502 Value S1XX 4 n
Highest 24-Hour S02 Value with DP S1XM 7
Highest 3-Hour Average S02 Value S1YX 4 n
Highest 3-Hour Average S02 Value uith DP S1YM 7
Highest B-Hour Average CO Value C1ZX 4 n
Highest 8-Hour Average CO Value with DP C1ZM 7
Highest Daily 03 Value 031X 4 n
Highest Daily 03 Value with DP 031M 7
Horizontal Distance (from support) HODS 1 n
Hour HURH 2
Indicated (Observed) Concentration Value for Level 1 OXL1 5 n
Indicated (Observed) Cone. Value for Level 1 w/DP OCL1 7
Indicated (Observed) Concentration Value for Level 2 OXL2 5 n
Indicated (Observed) Cone. Value for Level 2 w/DP OCL2 7
Indicated (Observed) Concentration Value for Level 3 OXL3 5 n
Indicated (Observed) Cone. Value for Level 3 w/DP OCL3 7
Indicated (Observed) Concentration Value for Level 4 0X14 5 n
Indicated (Observed) Cone. Value for Level 4 w/DP OCL4 7
Indicated (Observed) Concentration Value for Level 5 OXL5 5 n
Indicated (Observed) Cone. Value for Level 5 w/DP OCL5 7
Interval INCD 1
Interval INVC 1
Interval INVD 1
n=numeric
A.2-5
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
Field Abbreviation List in Field Name, File Name Sequence (5 of 14)
Fite Mame
Hourly Data
Parameter Standards (CCS)
P/A Monitor Sample Value
P/A Monitor Surma ry
SLAMS
Sunmary Data
P/A Monitor Sample Value
P/A Monitor Summary
Description (CCS)
Description (GCS)
Description (GCS)
Description (GCS)
Description (GCS)
Description (GCS)
Description (GCS)
Description (GCS)
Site
Description (GCS)
Site
Site
P/A Monitor Sunmary
P/A Rep. Org. Summary
P/A Monitor Sunmary
P/A Monitor Sunmary
P/A Monitor Sunmary
P/A Monitor Summary
P/A Rep. Org. Sumnary
P/A Monitor Sumnary
P/A Rep. Org. Summary
P/A Monitor Sanple Value
P/A Monitor Sumnary
P/A Monitor Summary
P/A Monitor Summary
P/A Monitor Sunmary
P/A Rep. Org. Sunmary
P/A Monitor Summary
P/A Rep. Org. Summary
P/A Monitor Sample Value
P/A Monitor Summary
P/A Monitor Summary
P/A Monitor Summary
P/A Monitor Summary
P/A Rep. Org. Summary
P/A Monitor Sunmary
P/A Rep. Org. Sunmary
P/A Monitor Sample Value
P/A Monitor Summary
P/A Monitor Sunmary
Field Description
Interval
Interval
Interval
Interval
Interval
Interval
Interval Description
Interval Description
Interval Description for Composite
Interval Description for Daily
Interval Description for Hourly
Interval Description for SLAMS
Interval Description for Summary
Item Code
Item Code Description
Item Type Code
Land Use Code
Land Use Code Description for Site
Land Use Under Path
Latitude
Level , Z, and 3 Analyzer Multipoint Audits
Level , 2, and 3 Analyzer Multipoint Audits
Level Accuracy Mean
Level Accuracy Standard Deviation
Level Analyzer Multipoint Audits
Level 1 Lower Probability Limit Average
Level 1 Lower Probability Limit Average
Level 1 Upper Probability Limit Average
Level 1 Upper Probability Limit Average
Level 1 Value Decimal Indicator
Level 2 Accuracy Mean
Level 2 Accuracy Standard Deviation
Level 2 Analyzer Multipoint Audits
Level 2 Lower Probability Limit Average
Level 2 Lower Probability Limit Average
Level 2 Upper Probability Limit Average
Level 2 Upper Probability limit Average
Level 2 Value Decimal Indicator
Level 3 Accuracy Mean
Level 3 Accuracy Standard Deviation
Level 3 Analyzer Multipoint Audits
Level 3 Lower Probability Limit Average
Level 3 Lower Probability Limit Average
Level 3 Upper Probability Limit Average
Level 3 Upper Probability Limit Average
Level 3 Value Decimal Indicator
Level it Accuracy Mean
Level 4 Accuracy Standard Deviation
ABBR
INVK
I MTV
I MVP
1NVN
INVL
(NTS
INDP
1NDN
INDC
I HDD
INCH
INDL
INDS
1TCD
ITDS
ITEM
LUSE
LUDS
LAND
LATT
MAAN
MAAR
AH1H
AS1N
MAIN
LP1N
LP1R
UP1N
UPlfi
DPL1
AM2N
AS2N
HA2N
LP2N
LP2R
UP2N
UP2R
DPL2
AH3N
AS3N
MA3K
LP3N
LP3R
UP3M
UP3R
DPL3
AM4N
AS4N
12 n
12 n
4 n
3
3
3
3
1
12 n
12 n
4 n
3
3
3
3
1
12 n
12 n
4 n
3
3
3
3
1
12 n
12 n
nsnumeric
A.2-6
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Field Abbreviation List in Field Name, File Name Sequence (6 of 14)
File Name
P/A Monitor Summary
P/A Rep. Org. Summary
P/A Monitor Summary
P/A Rep. Org. S'Jimary
P/A Monitor Surmary
P/A Rep. Org. Sifimary
P/A Monitor Saroole Value
P/A Monitor Summary
P/A Monitor Suimary
P/A Monitor Suimary
P/A Rep. Org. Summary
P/A Monitor Summary
P/A Rep. Org. Suimary
P/A Monitor Summary
P/A Rep. Org. Sunnary
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor Summary
P/A Rep. Org. Summary
P/A Monitor Sample Value
P/A Monitor Surmary
P/A Monitor Sunnary
Site
Site
Description {GCS)
Site
Site
Monitor
Description (GCS)
Site
Collection and Analysis (GCS)
Collection and Analysis (GCS)
Collection and Analysis (GCS)
Composite
Daily Data
Hourly Data
P/A Monitor Sample Value
P/A Monitor Siitnary
SLAMS
Sunnary Data
Site
Monitor
Metropolitan Sirst. Area (GCS)
Site
Composite
Daily Data
Hourly Data
field Description
Level 4 Analyzer Multipoint Audits
Level 4 Analyzer Multipoint Audits
Level 4 Lower Probability Limit Average
Level 4 Lower Probability Limit Average
Level 4 Upper Probability Limit Average
Level 4 Upper Probability Limit Average
Level 4 Value Decimal Indicator
Level 5 Accuracy Mean
Level 5 Accuracy Standard Deviation
Level 5 Analyzer Multipoint Audits
Level 5 Analyzer Multipoint Audits
Level 5 Lower Probability Limit Average
Level 5 Lower Probability Limit Average
Level 5 Upper Probability Limit Average
Level 5 Upper Probability Limit Average
Level 5 Value Decimal Indicator
Local Primary Standard Source-Accuracy
Local Primary Standard Source-Accuracy
Local Primary Standard Source-Accuracy
Local Standard Source Description
Local Standard Source Description
Local Standard Source Description
Location Description
Location Setting Code
Location Setting Description for Site
Longitude
Maximum Beam Height
Measurement Scale Code
Measurement Scale Code Description for Monitor
Meteorological Site ID
Method Code Analysis Description
Method Code Collection Description
Method of Collection Code
Method of Collection Code
Method of Collection Code
Method of Collection Code
Method of Collection Code
Method of Collection Code
Method of Collection Code (occurs 5 tiroes)
Method of Collection Codes (occurs 9 times)
Method of Deterinination
Metropolitan Statistical Area Code
Metropolitan Statistical Area («SA) Code
Minimum Beam Height
Minimum Detectable Value
Minimum Detectable Value
Minimum Detectable Value
AB6R
MA4N
MA4R
LP4N
LP4R
UP4N
UP4R
DPL4
AM5N
AS5N
MA5N
MASK
LP5N
LP5R
UPSN
UP5R
DPL5
LPSP
LPSN
LPSR
LPDP
LPDN
LPDR
LOCD
LOCN
LODS
LONG
MAXH
MSCL
MSOM
MS ID
ANYD
COLL
MTCD
KTHC
MTHD
MTHH
MTHP
HTMti
HTHL
MTHS
DETR
MSAM
MSAC
MIMH
MDCX
MDDX
MDHX
LGTH
4 n
4 n
3
3
3
3
1
12 n
12 n
4 n
4 n
3
3
3
3
1
1
1
1
28
28
28
68
1
25
12 r.
2 n
1
35
9
35
30
3 n
3 n
n
n
n
3
3
3
3
3 n
3 n
10
4 n
4
2 n
4 n
5 n
5 n
n=numeric
A.2-7
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
Field Abbreviation List in Field Name, File Name Sequence (7 of 14)
File Name
Composite
Daily Data
Hourly Data
Collection and Analysis (CCS)
Composite
Daily Data
Hourly Data
Surmary Data
Description (CCS)
Suranary Data
Sinmary Data
Simaary Data
Monitor
Monitor
P/A Monitor Suimary
P/A Rep. Org. Summary
Composite
Daily Data
Hourly Data
Monitor
P/A Monitor Sample Value
P/A Monitor Suimary
Site and Monitor History
SLAMS
Suntnary Data
Monitor
Mom" tor
Composite
Daily Data
Hourly Data
Monitor
P/A Monitor Sample Value
P/A Monitor Suimary
Suimary Data
Description (CCS)
Description (GCS)
Description (GCS)
Description (GCS)
P/A Monitor Sample Value
P/A Monitor Surma ry
Description (GCS)
Monitor
Monitor
Description (GCS)
Monitor
Description (GCS)
Daily Data
Field Description ABBB ISTH
Minimun Detectable Value Decimal Indicator MDPC 1
MinimuTi Detectable Value Decimal Indicator MDPO 1
Minirrun Detectable Value Decimal Indicator MDPH 1
Mini run Detectable Value for Method MDCA It n
Mini nun Detectable Value with DP MDTC 7
Minimum Detectable Value with DP MDTD 7
Minimun Detectable Value with DP MOTK 7
Minimum -Sampling Frequency Code MHSF 1
Minimum Sampling Frequency Code Desc. for Suimary MNDS 20
Minimun Value MINX 6 n
Minimun Value with DP MINM 7
Missing Sample Values, Assumed Less Than Standard MISS 3 n
Monitor Comments - 1 HCM1 62
Monitor Comments - 2 MCMZ 62
Monitor Data Recording Mode TYDN 1
Monitor Data Recording Mode TYDH 1
Monitor Identification Number MNIC 15
Monitor Identification Nunber MN1D IS
Monitor Identification Nunber MNIH 15
Monitor Identification Nunber MON1 15
Monitor Identification Nunber MNIP 15
Monitor Identification Nunber MNIN 15
Monitor Identification Nunber MN1T 15
Monitor Identification Nunber MNIL 15
Monitor Identification Nunber MNIS 15
Monitor Open Path Nwnber MOPK
Monitor Street Number STNU
Monitor Type Code MTYC
Monitor Type Code MTYD
Monitor Type Code HTYH
Monitor Type Code MTYM
Konito- Type Code MTYP
Monitor Type Code KTYK
Monitor Type Code KTYS 1
Monitor Type Code Description for Composite MTDC 10
Monitor Type Code Description for Daily MTDD 10
Monitor Type Code Description for Hourly MTDH 10
Monitor Type Code Description for Monitor MTDM 10
Monitor Type Code Description for P/A Monitor Data MTDP 10
Monitor Type Code Description for P/A Monitor Summary MTDW 10
Monitor Type Code Description for Suimary MTDS 10
Monitor Type Effective Date DMTM 8
Monitor Type Objective Code MTOB 1
Monitor Type Objective Code Description for Monitor MTOO 25
Monitoring Area Code GOHN 4 n
Monitoring Area Description for Monitor GODM 30
Month MNTO 2
n=numerie
A.2-8
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Field Abbreviation List in Field Name, File Name Sequence (8 of 14)
file Name
Hourly Date
P/A Monitor Sample Value
Metropolitan Stat. Area (CCS)
Metropolitan Stat. Area (CCS)
Monitor
Site and Monitor History
Site and Monitor History
Site and Monitor History
Site and Monitor History
Summery Data
Summary Data
Summary Data
Summary Data
Sunmary Data
Surmary Data
Monitor
Attainment (CCS)
Sunmary Data
Composite
Daily Data
Hourly Data
Description (GCS)
Description (GCS}
Description (GCS)
Summary Data
SLAMS
Sunmary Data
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
Sunmary Data
Composite
Monitor
Sunmary Data
Monitor
Site and Monitor H-story
Site and Monitor H-story
Site and Monitor H story
Site and Monitor H-story
Field Description ABBE LGTH
Month MNTH 2
Month MNTP 2
MSA Name MSAN 41
MSA Population MSAP 8 n
MSA Represented KSAR 4 n
New Monitor Type Effective Date NMTD 6
New Reporting Organization Effective Date NROC 8
key Required Sampling Frequency Effective Date-State NSSP 8
New Site or Monitor Detail Field Value NEkV 8
Ninety Percentile P90X 6 n
Ninety Percentile with DP PC90 7
Ninety-Five Percentile P95X 6n
Ninety-Five Percent!" le with DP PC95 7
Ninety-Nine Percent!le P99X 6 n
Ninety-Nine Percentile with DP PC99 7
Nonattainment Area NONA 5
Non-Attainment Total NATT 1
Non-Overlapping Average Greater Than Standard OVLP 4 n
Null Value Reason Code NVCC 4
Null Value Reason Code NVCD 4
Null Value Reason Code NVCH 5
Null Value Reason for Composite NVDC 35
Null Value Reason for Daily NVDD 35
Null Value Reason for Hourly NVDH 35
Number of Exceptional Event Values FVAL 4 n
Number of Lead Samples in Qtr (occurs 4 times) PBNS 2 n
Number of Observations OBSC 4 n
Number of Observations per Concentration Range 1 FRQl 4 n
Nunber of Observations per Concentration Range 2 FRQ2 4 n
Number of Observations per Concentration Range 3 FRQ3 4 n
Number of Observations per Concentration Range 4 FR04 4 n
Number of Observations per Concentration Range 5 FRQ5 4 n
Number of Observations per Concentration Range 6 FRQ6 4 n
Number of Observations per Concentration Range 7 FRQ7 4 n
Number of Observations per Concentration Range 8 FRQS 4 n
Number of Observations per Concentration Range 9 FRQ9 4 n
Number of Reported Methods MTKN 1 n
Number of Samples Used in Sample Value SCNT 2 n
Number of Scheduled Samples Per Month NUKS 2
Number of Substitutions Using Half Minimum Detectable HALF 4 n
Number Scheduled Samples per Month (occurs 12 times) NSMT 2 n
Old EPA Required Sampling Frequency Code OSFE 1
Old EPA Required Sampling Frequency Effective Date OSED 8
Old Monitor Type Code OHTY 1
Old Monitor Type Effective Date OHTD 8
n=rHjneric
A.2-9
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
Field Abbreviation List in Field Name, File Name Sequence (9 of 14)
File Name
Site and Monitor History
Site and Monitor History
Site and Monitor History
Site and Monitor History
Site and Monitor History
Site
Monitor
Parameter (CCS)
Attainment (GCS)
Collection and Analysis (GCS)
Composite
Daily Data
Hourly Data
Monitor
Parameter Standards (GCS)
Parameter (GCS)
P/A Monitor Sample Value
P/A Monitor Summary
P/A Rep. Org. Suimary
Site and Monitor History
SLAMS
Summery Data
FIPS Area (GCS)
State (GCS)
Parameter (GCS)
Composite
Daily Data
Hourly Data
Monitor
P/A Monitor Sample Value
P/A Moni tor Summary
Site and Monitor History
SLAMS
Surinary Data
Suimary Data
P/A Rep. Org. Suimary
P/A Monitor Summary
P/A Rep. Org. Suimary
P/A Monitor Summary
P/A Rep. Org. Summary
P/A Monitor Sunmary
P/A Monitor Summary
Attainment (GCS>
Field Description ABBR UTH
Old Reporting Organization Code OROC 3 n
Old Reporting Organization Effective Date OR00 8
Old Site or Monitor Detail Field Value OLDV 8
Old State Required Sampling Frequency Code OSFS 1
Old State Required Sampling Frequency Effective Date OSSD 8
Open Path Umber WHO 1
PAMS Required Sampling Frequency PAHS 1
Parameter Abbreviation PLAB 5
Parameter Code PCAT 5
Parameter Code PCCA 5
Parameter Code PLTC 5
Parameter Code PLTO 5
Parameter Code PLTH 5
Parameter Code PLTH 5
Parameter Code PCPS 5
Parameter Code PLLT 5
Parameter Code PLTP S
Parameter Code PLTN 5
Parameter Code PLTR 5
Parameter Code PLTT 5
Parameter Code PLTL 5
Parameter Code PLTS 5
Parameter Code (occurs 25 times) PLCF 5
Parameter Code (occurs 25 times) PCST 5
Parameter Name PLLN 70
Parameter Occurrence Code POCC 1
Parameter Occurrence Code POCD 1
Parameter Occurrence Code POCK
Parameter Occurrence Code POCK
Parameter Occurrence Code POCP
Parameter Occurrence Code POCN
Parameter Occurrence Code POCT
Parameter Occurrence Code POCL
Parameter Occurrence Code POCS
Percentage of Observations POBS 3 n
Pollutant Audits Performed on Network PAPR 4 n
PoUutant Average Number of Samplers PANN 5 n
Pollutant Average Number of Samplers PANR 5 n
Precision Checks Included in Calculations PCIN 4 n
Precision Checks Included in Calculations PCIR 4 n
Precision Mean PMEN 12
Precision Standard Deviation PSOV 10
Primary or Secondary Non-Attainment NAPS 1
n=numeric
A.2-10
-------
AIRS User's Guide
Volume AQS
Ad hoc Retrieval
Field Abbreviation List in Field Name, File Name Sequence (10 of 14)
file Maine
Parameter Standards (CCS)
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
Surmary Data
SLAMS
Monitor
Monitor
Monitor
Description (CCS)
Monitor
Monitor
SLAMS
Site
Collection and Analysis
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
Field Abbreviation List in Field Name, File Name Sequence (11 of 14)
File Maine
Hourly Data
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
Composite
Daily Data
Hourly Data
Daily Data
Composite
Daily Data
Hourly Data
Description (GCS)
Description (GCS)
Description (GCS)
Composite
Daily Data
Hourly Data
Daily Data
Description (CCS)
SLAMS
Description (GCS)
Site
Monitor
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
Sunnary Data
Suimary Data
Parameter Standards (GCS)
SLAMS
Summary Data
Sunnary Data
Sunnary Data
Field Description
Sample Value
Sample Value Average for Pb (occurs 4 times)
Sample Value Average for S02
Sample Value Average with DP for Pb (occurs 4 times)
Sample Value Average with DP for PM10
Sample Value Average with DP for $02
Sample Value Average with PM10
Sample Value Decimal Indicator
Sample Value Decimal Indicator
Sample Value Decimal Indicator
Sample Value Start Hour
Sample Value Validity Flag
Sample Value Validity Flag
Sample Value Validity Flag
Sample Value Validity Flag Description for Composite
Sample Value Validity Flag Description for Daily
Sample Value Validity Flag Description Hourly
Sample Value with DP
Sample Value with DP
Sample Value with DP
Sampling Frequency
Sampling Frequency for Daily Data
Sampling Frequency for PM10 (occurs it times)
Sampling Frequency for SLAMS
Scale
Screening File File-10
Second Highest 1-Hour CO Value
Second Highest 1-Hour CO Value with DP
Second Highest 1-Hour N02 Value
Second Highest 1-Hour N02 Value with DP
Second Highest 24-Hour N02 Value
Second Highest 24-Hour M02 Value with DP
Second Highest 24-Hour S02 value
Second Highest 24-Hour S02 Value with DP
Second Highest 3-Hour Average S02 Value
Second Highest 3-Hour Average S02 Value with DP
Second Highest 8 CO Hour Average Value
Second Highest 8-Hour Average CO Value with DP
Second Highest Daily 03 Value
Second Highest Daily 03 Value with DP
Second Maxinun Value
Second Maximum Value with DP
Secondary Standard
Secondary Standard 3-Hour for S02 Average Violations
Secondary Standard Violations
Seventy Percentile
Seventy Percentile with DP
ABBS
SMHX
PBXA
SOAX
P8MX
PMAM
SOAM
PMAX
SDPC
SDPD
SDPH
STHR
VFGC
VFGD
VFGH
VFDC
VFDD
VFDH
SHPC
SMPD
SMPH
SFOD
SFDD
PMSF
PMDL
SCAL
SCRN
C21X
C21M
N21X
N21M
N2XX
N2XK
S2XX
S2XM
S2YX
S2YM
C2ZX
C22M
032X
032K
MX2X
MXV2
SECS
SSYV
ESEC
P70X
PC70
6
5 n
4 n
7
7
7
4 n
1
1
1
Z
2
2
2
40
40
40
7
7
7
1
20
1
20
6
6
4 n
7
4 n
7
4 n
7
4 ri
7
4 r
7
4 n
7
4 n
7
6 n
7
8 n
4 n
4 n
6 n
7
n=numeric
A.2-12
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Field Abbreviation List in Field Name, File Name Sequence {12 of 14)
File Name
Monitor
Monitor
Monitor
Monitor
Monitor
Site
Site
Site
Nonitor
Composite
Daily Data
Hourly Data
Monitor
P/A Monitor Sample Value
P/A Monitor Sunrnary
Site
Site and Monitor History
SLAMS
Sturnery Data
Site and Monitor History
Nonitor
Collection and Analysis (CCS)
Parameter Standards (GCS)
Summary Data
Description (GCS)
State
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
Field Abbreviation List in Field Name, File Name Sequence (13 of 14)
File Name
Site
Site
Description (CCS)
Description (CCS)
Description (CCS)
Description
SLAMS
SLAMS
SLAMS
SLAMS
Suimary Data
Suanary Data
Description (CCS)
Description (GCS)
Site
Monitor
Site
Suanary Data
Summary Data
SLAMS
SLAMS
Simnary Data
Simnary Data
Suimary Data
Suimary Data
P/A Monitor Skimary
P/A Rep. Org. Suimary
Suimary Data
Site
Site
Site
Monitor
P/A Monitor Sample Value
P/A Monitor Suimary
P/A Rep. Org. Suimary
P/A Monitor Sample Value
P/A Monitor Summary
P/A Monitor Suimary
P/A Monitor Sample Value
Site
Collection and Analysis (GCS)
Composite
Daily Data
Hourly Data
P/A Monitor Sample Value
P/A Monitor Suimary
SLAMS
field Description
Street Address
Street Name
Suimary Criteria Code Description for SLAMS N02
Surmary Criteria Code Description for SLAMS Pb
Suimary Criteria Code Description for Suimary-CPA
Suimary Criteria Code Description for Summary-State
Surma ry Criteria Code for N02
Summary Criteria Code for Pb (occurs 4 times)
Summary Criteria Code for PM10
Suimary Criteria Code for S02
Suimary Criteria Code-EPA
Suimary Criteria Code-State
Suimary Criteria Description for SLAMS PM10
Suimary Criteria Description for SLAMS S02
Support Agency Code
Surrogate Fleg-TSP/PM10
Tangent Street Number
Tenth Percentile
Tenth Percent!le with Dp
Third Highest Daily 03 Value
Third Highest Daily 03 Value with DP
Third Maximum Value
Third Maximum Value with DP
Thirty Percentile
Thirty Percentile with DP
Time Period
Time Period
Time Period (occurs 5 times)
Traffic Flow
Transmitter Height
Type Meteorological Site
Type Obstruction
Type of Accuracy Audit
of Accuracy Audit
of Accuracy Audit
of Audit Description
of Audit Description
of Audit Description
Data
ABBR
Type
Type
Type
Type
Type
Type
Type Road
Units Code
Units Code
Units Code
Units Code
Units Code
Units Code
Units Code
of
STRT
STRM
NOSD
PBSO
CRDE
CRDS
NOSC
PBSC
PMSC
SOSC
CRTE
CRTF
PHSE
SOSD
SAGC
SURR
STNO
P10X
PC10
033X
033*
MX3X
MXV3
P30X
PC30
TIMM
TIMR
TIME
TRAP
THGT
TMSI
OBTY
TYAP
TYAN
TYAR
TADP
TADR
TADN
TYDP
TYPR
UNCD
UNTC
UNTD
UNTH
UNTP
UNTN
UNTL
40
20
60
60
60
60
1
1
1
1
1
1
60
60
3 n
1
1
6 n
7
4 n
7
6 n
7
6 n
7
2
2
2
6 r
2 r
1
1
1
1
1
45
45
45
1
1
3 n
3 n
3 n
3 n
3 n
3 n
3 n
n=numeric
A.2-14
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Field Abbreviation List in Field Name, File Name Sequence (14 of 14)
File Man*
Description (CCS)
Description (CCS)
Description (GCS)
Description (GCS)
P/A Monitor Sample Value
P/A Monitor Summary
Site
Monitor
Urban Arta (CCS)
Urban Area (GCS)
Urban Area (GCS)
Mom tor
Site
Site
P/A Monitor Suimary
P/A Rep. Org. Summary
Surmary Data
Parameter (GCS)
Monitor
Monitor
Description (GCS)
Composite
Daily Data
Hourly Data
P/A Monitor Sample Value
P/A Monitor Summary
P/A Rep. Org. Surmery
SLAMS
Summary Data
Site
Summary Data
Summary Data
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor Sample Value
Field Description ABBR
Units Code Description for Composite UNDC
Units Code Description for Daily UNDO
Units Code Description for Hourly UNDH
Units Code Description for SLAMS UNOL
Units Description UNDP
Units Description UNDN
Universal Transverse Mercator (UTM) System Zone UTM2
Unrestricted Air Flow A1RF
Urban Area Code URBC
Urban Area Name URNM
Urban Area Population URNP
Urban Area Represented Code URBN
UTM Easting (Horizontal) Coordinate (Meters) UTME
UTM Northing (Vertical) Coordinate (Meters) UTMN
Valid Collocated Date Pairs VCDN
Valid Collocated Data Pairs VCDR
Valid Days VDAY
Validity flag (occurs 20 times) VFLG
Vertical Distance (From Support) VERT
Worst Site Code URST
Worst Site Description for Monitor WRDM
Year YRRC
Year YRRD
Year YftRH
Year YRRP
Year YRRN
Year YRRR
Year YRRL
Year YRRS
Year of Traffic Flow TRYR
Yearly Weighted Arithmetic Mean WTDX
Yearly Weighted Arithmetic Mean with DP WTDA
Zero Span Value ZSVX
Zero Span Value Decimal Indicator ZSDP
Zero Span w/DP ZSW
4
8
7
30
30
30
30
30
30
2
1
4
45
8 n
n
n
n
4 n
4 n
3 n
1
1 n
1
60
2
2
2
2
2
2
2
2
4
7 n
8
4 n
1
7
n=numeric
A.2-15
-------
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Appendix A.3
Field Abbreviation List in ABBR Sequence
This appendix contains a list of field abbreviations in ABBR sequence.
A.3-1
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
Field Abbreviation List in Abbreviation Sequence (1 of 14)
File name
Site
P/A Rep. Org. Summary
Agency (CCS)
Agency (GCS)
Agency (CCS)
Description (GCS)
Site
Monitor
Monitor
P/A Monitor Sunmry
P/A Rep. Org. Surmary
P/A Monitor Surma ry
P/A Monitor Surma ry
P/A Monitor Summary
P/A Monitor Suimary
P/A Monitor Suimary
P/A Rep. Org. Sunmary
Collection and Analysis (GCS)
FIPS Area (GCS)
Monitor
AQ Control Region (GCS)
AO Control Region (GCS)
AO Control Region (GCS)
AO Control Region (GCS)
AQ Control Region (GCS)
FIPS Area (GCS)
FIPS Area (GCS)
FIPS Area (GCS)
FIPS Area (GCS)
FIPS Area (GCS)
Suimary Data
Suimary Data
FIPS Area (GCS)
FIPS Area (GCS)
FIPS Area (GCS)
FiPS Area (GCS)
FIPS Area (GCS)
Surma ry Data
Suwnary Data
P/A Monitor Surma ry
P/A Monitor Suimary
P/A Monitor Surra ry
P/A Monitor Suimary
P/A Monitor Suimary
Monitor
Attainment (GCS)
Monitor
P/A Monitor Simnary
P/A Monitor Sample Value
P/A Monitor Suimary
P/A Monitor Sanple Value
Field Description
Estimated of Accuracy
Average Collocated Sampler Sites
Agency Code
Agency Name
Agency Type Code
Agency Type Code Description
Air Basin
Unrestricted Air Flow
Analyzing Laboratory Code
Average Lower Probability Limits
Average Lower Probability Limits
Level 1 Accuracy Mean
Level 2 Accuracy Mean
Level 3 Accuracy Mean
Level it Accuracy Mean
level 5 Accuracy Mean
Average Number of Approved Analyzers
Method Code Analysis Description
AQCR Code (occurs 3 times)
AOCR Code
AOCR Code
AOCR Type Code
AOCR Size-Square Miles
AOCR Name
AQCR Population
County Size-Square Miles
County Codes in City-FIPS (occurs 126 times)
City Codes in County-FIPS (occurs 126 times)
City Code-FIPS
County Code-FIPS
Arithmetic Mean with DP
Arithmetic Mean
County Name
City Name
County Population
City Population
County Population Percent Rural
Arithmetic Standard Deviation with DP
Arithmetic Standard Deviation
Level 1 Accuracy Standard Deviation
Level 2 Accuracy Standard Deviation
Level 3 Accuracy Standard Deviation
Level 4 Accuracy Standard Deviation
Level 5 Accuracy Standard Deviation
Action Type Code
Attainment Status
Action Type Reason Code
Audit Classification
Audit Classification
Audit Classification Description
Audit Classification Description
ABBR
ACCU
ACSS
AGCD
AGNM
AGTC
AGTD
AIRS
AIRF
ALCO
ALPN
ALPR
AM1N
AM2N
AM3N
AM4N
AM5N
ANAA
ANYD
AOCC
AOCM
AOCR
AOCS
AOCT
AONH
AOPO
AOSC
ARCC
ARCR
AREA
AREC
ARMN
ARMX
ARNC
ARNH
ARPC
ARPO
ARRC
ARSD
ARSX
AS1N
AS2N
AS3N
AS4N
AS5N
ATPY
ATST
ATYR
AUCN
AUCP
AUDN
AUDP
n
LGTH
10
4 n
3 n
60
1
60
2
1
3
3
3
12 n
12 n
12 n
12 n
12 n
3 n
35
3 n
3 ri
3 n
1
7 n
54
8 n
7 n
3
5
5
3
8
7 r
30
30
8 n
8 n
4
8
6 n
12 n
12 -i
12 ;i
12 n
12 n
3
1
2
1
1
10
10
n=nujneric
A.3-2
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Field Abbreviation List in Abbreviation Sequence (2 of 14)
o
File Name
Monitor
P/A Monitor Summery
P/A Rep. Org. Sturnery
Site
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
Parameter (GCS)
Attainment (GCS)
SLAMS
SLAMS
Site and Monitor History
Site and Monitor History
Monitor
Description (GCS)
Monitor
Monitor
Monitor
MSA (GCS)
Monitor
Monitor
Site
Composite
Daily Data
Hourly Data
SLAMS
Monitor
P/A Monitor Senary
P/A Monitor Sample Value
Summary Data
Site and Monitor History
SLAMS
Collection and Analysis (GCS)
Collection and Analysis (GCS)
Monitor
Monitor
Description (GCS)
Composite
Site
Description (GCS)
Description (GCS)
Summary Data
Summary Data
Field Description ABBR IGTM
Audit Date AUDI 8
Average Upper Probability Limits AUPN 3
Average Upper Probability Limits AUPR 3
Bean Length BLEN 4 n
Highest 1-Hour CO Value with DP C11M 7
Date and Time of the Highest 1-Hour CO Value C11T 6
Highest 1-Hour CO Value C11X 4 n
Highest 6-Hour Average CO Value with DP C1ZM 7
Date and Tine of the Highest 8-Hour Average CO Value C12T 6
Highest 8-Hour Average CO Value C12X 4 n
Second Highest 1-Hour CO Value with DP C21K 7
Date and Time of the Second Highest 1-Hour CO Value C21T 6
Second Highest 1-Hour CO Value C21X 4 n
Second Highest 8-Hour Average CO Value with DP C2ZM 7
Date and Time of the Second Highest 8-Hour Avg CO Val. C2ZT 6
Second Highest 8 CO Hour Average Value C22X 4 n
Chemical Abstract Service No CASN 9
County Code-FI PS CCAT 3
Primary Standard 1-Hour CO Violations CEX1 4 n
Primary Standard 8-Hour Average CO Violations CEXZ 4 n
Date Change Posted by AIRS ACS UPDATE CHGD 6
Site or Monitor Field Name CHGF 2
Collecting Laboratory Code CLCD 3 n
Project Class Code Description for Monitor CLDM 40
Project Class Code CLSS 2
Short Term Sampling Schedule Completion Date-EPA CMPE 8
Short Term Sampling Schedule Completion Date-State CMPS 8
CMSA CMSA 4
Consolidated Metropolitan Statistical Area CMSC 4 n
CMSA Represented CMSR 4 n
County Code-FI PS CNTT 3 n
County Code-FI PS CNYC 3
County Code-FIPS CNYD 3
County Code-FIPS CNYH 3
County Code-FIPS CNYL 3
County Code-FIPS CNYH 3
County Code-FIPS CNYN 3
County Code-FIPS CNYP 3
County Code-FIPS CNYS 3
County Code-FIPS CMYT 3
Decimal Indicator for CO COOP 1
Method Code Collection Description COLL 30
Conversion Factor to Standard Units CONV 10 n
First Estimated Number of Exceedances Correction-EPA CORE 1
First Estimated Number of Exceedances Correction-State CORS 1
Compass Sector Description for Site CPDS 10
Composite Period CPRD 2 n
Compass Sector (Direction from CBD) CPSS 2
Summary Criteria Code Description for Summary-EPA CRDE 60
Summary Criteria Code Description for Summary-State CRDS 60
Summary Criteria Code-EPA CRTE 1
Summary Criteria Code-State CRTF 1
n=numeric
A.3-3
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
Field Abbreviation List in Abbreviation Sequence (3 of 14)
file Name
P/A Monitor Swinery
P/A Rep. Org. Summary
Description (GCS)
Monitor
Composite
MPS Area (GCS)
FIPS Area (GCS)
Site
Daily Data
Hourly Data
P/A Monitor Sample Value
Monitor
Monitor
Site
Monitor
Site
Site
Site
Site
Site
Monitor
Monitor
Collection and Analysis (GCS)
Summary Data
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor Sample Value
Summary Data
Monitor
Monitor
Site
Monitor
Monitor
Site
Site
Site
Site
Summary Data
Collection and Analysis (GCS)
Summary Data
Summary Data
Summary Data
Hourly Data
SLAMS
Summary Data
Description (GCS)
Description {GCS)
Description (GCS)
Field Description ABBR L.GJTH
Collocated Sites with Samples Below limit CSBN 5 n
Collocates Sites with Samples Below Limit CSBR 5 n
Composite type Description for Composite Data CTDC 13
City Code-FlPS CUM 5 n
Composite Type Code CTYP 1
City Name for Monitor CYNK 30
City Population for Monitor CYPO 8 n
Datum OATU 2
Day DAYD 2
Day DAYH 2
Day DAYP 2
Date Sampling Began DBGN 8
Date Siting Criteria Met DCRT 6
Distance From City (Kilometers) DCTY 3
Date Sampling Ended OEND 8
Date Site Established DEST 8
Method of Determination DETR 1C
Difference Between GMT and Standard Time DGMT 2
Direction of Meteorological Site DIRE 2
Distance of Meteorological Site DIST 5 n
Monitor Type Effective Date DMTM 8
OA Effective Date DPAC 6
Indicator for Standard Units DPIN
Indicator DPIS
Value Decimal Indicator DPL1
2 Value Decimal Indicator DPL2
3 Value Decimal Indicator DPL3
A Value Decimal Indicator DPL4 1
5 Value Decimal Indicator DPL5 1
Decimal Indicator for Mean Values OPHS 1
Direction From Monitor DRMO 2
Required Sampling Frequency Effective Date-State DRSS 8
Direction to Street DRST 2
Dominant Source of Pollutant Code OSCR 6
Distance From Road Nearby (Meters) (occurs 3 times) DSTR 4 n
Direction to Transmitter DTRA 3
Date Site Terminated DTRH 8
Date Last Updated by ACS UPDATE DTUP 8
Elevation of Site Above Mean Sea Level EMSL 5 n
Primary Standard Violations EPRI 4 r<
Reference Equipment Description EOIP 30
Secondary Standard Violations ESEC 4 r
Estimated Days Greater Than Standard-State ESTD 6 n
Estimated Days Greater Than Standard-EPA ESTE 6 n
Exception Data Flag Indicator (Run. Avg. Data Only) EXCH 1
Exception Data Flag Indicator EXCL 1
Exception Data Flag Indicator EXCS 1
Exception Data Flag Indicator Desscription EXDH 30
Exception Data Flag Indicator Description for SLAMS EXDL 30
Exception Data Flag Indicator Description for Summary EXOS 30
Decimal
Decimal
Level 1
Level
Level
Level
Level
n=numeric
A.3-4
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Field Abbreviation List in Abbreviation Sequence (4 of 14)
File Name
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SIAMS
SLAMS
SLAMS
SLAMS
Swinery Data
Surmary Data
Surma ry Data
Surma ry Data
Description (C.CS)
Monitor
SuiFiary Data
Monitor
Site
Hourly Data
Collection and Analysis (CCS)
Description (CCS)
Description (CCS)
Description (CICS)
Description (CCS)
P/A Monitor Suimary
P/A Monitor Sample Value
Description (CCS)
Monitor
Suimary Data
Parameter Standards (CCS)
Composite
Daily Data
Hourly Data
SLAMS
P/A Monitor Summary
P/A Monitor Sample Value
Description (GCS)
Description (GCS)
Description (GCS)
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor Sample Value
F|eld Description ABBR
Number of Observations per Concentration Range 1 FRQ1
Number of Observations per Concentration Range 2 FRQ2
Number of Observations per Concentration Range 3 FR03
Number of Observations per Concentration Range 4 FRQ4
Number of Observations per Concentration Range 5 FRQ5
Number of Observations per Concentration Range 6 FRQ6
Number of Observations per Concentration Range 7 FR07
Number of Observations per Concentration Range 8 FRQ8
Number of Observations per Concentration Range 9 FRQ9
Number of Exceptional Event Values FVAL
Geometric Mean with DP GMMN
Geometric Mean GMMX
Geometric Standard Deviation GMSD
Monitoring Area Description for Monitor GOOM
Monitoring Area Code GOMN
Number of Substitutions Using Half Minimum Detectable HALF
Horizontal Distance (from support) HODS
Headquarters Evaluation Date HGEV
Hour HURH
interval INCD
Interval Description for Composite INDC
Interval Description for Daily I NOD
Interval Description for Hourly INDK
Interval Description for SLAMS 1NDL
Interval Description INDN
Interval Description INDP
Interval Description for Summary INDS
Distance From Inlet 1NLT
Interval IKTS
Interval INTV
Interval INVC
Interval INVD
Interval INVH
Interval INVL
Interval !NVN
Interval 1NVP
Item Code ITCD
Item Code Description ITDS
Item Type Code ITEM
Actual (Known) Concentration Value for Level 1 w/DP KCL1
Actual (Known) Concentration Value for Level 2 w/DP KCL2
Actual (Knogn) Concentration Value for Level 3 u/DP KCL3
Actual (Known) Concentration Value for Level 4 w/DP KCL4
Actual (Known) Concentration Value for Level 5 w/DP KCLS
Actual (Known) Concentration Value for Level 1 KXL1
Actual (Known) Concentration Value for Level 2 KXL2
Actual (Known) Concentration Value for Level 3 KXL3
Actual (Known) Concentration Value for Level 4 KXL4
Actual (Known) Concentration Value for Level 5 KXL5
LOTH
4 n
4 n
4 n
4 n
4 n
4 n
4 n
4 n
4 n
4 n
8
7 n
6 n
30
4 n
4 n
1 n
8
2
1
30
30
30
30
30
30
30
2 n
4
60
2
7
7
7
7
7
5
5
5
5
5
n=numeric
A. 3-5
-------
Ad hoc Retrieval
AERS User's Guide
Volume AQ5
Field Abbreviation List in Abbreviation Sequence (5 of 14)
file Mame
Site
Site
Monitor
Site
Site
Description (GCS)
Site
P/A Monitor Summary
P/A Rep. Org. Summary
P/A Monitor Summary
P/A Rep. Org. Swinery
P/A Monitor Summary
P/A Rep. Org. Summary
P/A Monitor Sumary
P/A Rep. Org. Sumary
P/A Monitor Summary
P/A Rep. Org. Summary
P/A Monitor Suimary
P/A Monitor Sample Value
P/A Monitor Summary
P/A Monitor Suimary
P/A Monitor Sample Value
P/A Rep. Org. Sumary
Description (GCS)
Site
P/A Monitor Summary
P/A Monitor Suimary
P/A Monitor Summary
P/A Monitor Summary
P/A Rep. Org. Surinary
P/A Moni tor Sumary
P/A Rep. Org. Summary
P/A Monitor Summary
P/A Rep. Ory. Sumary
Site
Monitor
Monitor
Collection and Analysis (GCS)
Composite
Daily Data
Hourly Data
Composite
Daily Data
Hourly Data
Composite
Daily Deta
Hourly Data
Site
Field Description
Land Use Under Path
Latitude
Probe Location Code
Location Description
Location Setting Code
Location Setting Description for Site
Longi tude
Level 1 Lower Probability Limit Average
Level 1 Lower Probability Limit Average
Level 2 Lower Probability Limit Average
Level 2 Lower Probability Limit Average
Level 3 Lower Probability Limit Average
Level 3 Lower Probability Limit Average
Level 4 Lower Probability Limit Average
Level 4 Lower Probability Limit Average
Level 5 Lower Probability Limit Average
Level 5 Lower Probability Limit Average
Local Standard Source Description
Local Standard Source Description
Local Standard Source Description
Local Primary Standard Source-Accuracy
Local Primary Standard Source-Accuracy
Local Primary Standard Source-Accuracy
Land Use Code Description for Site
Land Use Code
Level 1 Analyzer Multipoint Audits
Level 2 Analyzer Multipoint Audits
Level 3 Analyzer Multipoint Audits
Level 4 Analyzer Multipoint Audits
Level 4 Analyzer Multipoint Audits
Level 5 Analyzer Multipoint Audits
Level 5 Analyzer Multipoint Audits
Level 1, 2, and 3 Analyzer Multipoint Audits
Level 1, 2, and 3 Analyzer Multipoint Audits
Maximum Beam Height
Monitor Comments - 1
Monitor Conner-its - 2
Minimum Detectable Value for Method
Minimum Detectable Value
Minimum Detectable Value
Mini nun Detectable Value
Minimum Detectable Value Decimal Indicator
Minimum Detectable Value Decimal Indicator
Minimum Detectable Value Decimal Indicator
Minimum Detectable Value with DP
Minimum Detectable Value with DP
Minimum Detectable Value with DP
Minimum Beam Height
ABBR
LAND
LATT
LOCA
LOCO
LOCN
LOOS
LONG
LP1N
LP1R
LP2N
LP2R
LP3N
LP3R
LP4N
LP4R
LP5K
LP5R
LPDN
LPDP
LPDR
LPSN
LPSP
LPSR
LUDS
LUSE
MAIN
MA2N
MA3N
MA4N
MA4R
MA5N
MA5R
MAAN
MAAR
MAXH
MCM1
MCM2
MDCA
MDCX
HDDX
MDHX
MDPC
MDPD
MDPH
MDTC
MDTD
MDTH
MINH
LGTH
1
11 n
1
68
1
25
12 n
3
3
3
3
3
3
3
3
3
3
28
28
28
1
1
1
12
1
4
4
4
4
4
4
4
4
4
2
62
62
11 n
4 n
5 n
5 n
1
1
1
7
7
7
2 n
n*numeric
A.3-6
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Field Abbreviation List in Abbreviation Sequence (6 of 14)
File Name
Surrary Data
Surmary Data
Summery Data
Description (GCS)
Composite
Daily Data
Hourly Data
SLAMS
P/A Monitor Surmary
P/A Monitor Sample Value
Surmary Data
Site and Monitor History
Sumary Data
Daily Data
Hourly Data
P/A Monitor Sample Value
Monitor
Monitor
Metropolitan Stat. Area (GCS)
Monitor
Metropolitan Stat. Area (GCS)
Metropolitan Stat. Area (GCS)
Monitor
Monitor
Description (GCS)
Site
Collection and Analysis (GCS)
Description (GCS)
Description (GCS)
Description (GCS)
Description (GCS)
P/A Monitor Suimary
P/A Monitor Sample Value
Description (GCS)
Monitor
Composite
Daily Data
Hourly Data
SLAMS
Surmary Data
P/A Monitor Sample Value
Surma ry Data
Mom tor
P/A Monitor Summary
Monitor
Description (GCS)
Composite
Daily Data
Hourly Data
Monitor
field Description ABBR
Minimum Value with DP MINM
Minimum Value MINX
Missing Sample Values, Assured Less Than Standard MISS
Minimum Sampling Frequency Code Desc. for Summary MNDS
Monitor Identification Number MNIC
Monitor Identification Number MNID
Monitor Identification Number MNIH
Monitor Identification Number HNIL
Monitor Identification Number MN1N
Monitor Identification Number MNIP
Monitor Identification Number MNIS
Monitor Identification Number MNIT
Minimum Sampling Frequency Code MNSF
Month MHTD
Month MNTM
Month HNTP
Monitor Identification Number MONI
Monitor Open Path Number MOPN
Metropolitan Statistical Area (MSA) Code NSAC
Metropolitan Statistical Area Code MSAM
MSA Name MSAN
MSA Population MSAP
MSA Represented HSAR
Measurement Scale Code MSCL
Measurement Scale Code Description for Monitor MSDM
Meteorological Site ID MSID
Method of Collection Code MTCD
Monitor Type Code Description for Composite MTDC
Monitor Type Code Description for Daily MTDD
Monitor Type Code Description for Hourly MTDH
Monitor Type Code Description for Monitor MTDH
Monitor Type Code Description for P/A Monitor Summary MTDN
Monitor Type Code Description for P/A Monitor Date MTDP
Monitor Type Code Description for Summary MTDS
Reference Method Used Begin Date MTDT
Method of Collection Code MTKC
Method of Collection Code HTHD
Method of Collection Code MTHH
Method of Collection Code (occurs 5 times) MTHL
Number of Reported Methods MTHN
Method of Collection Code MTHP
Method of Collection Codes (occurs 9 times) MTHS
Reference Method Used Code MTHU
Method of Collection Code MTMN
Monitor Type Objective Code MTOB
Monitor Type Objective Code Description for Monitor MTOD
Monitor Type Code MTYC
Monitor Type Code MTYD
Monitor Type Code MTYH
Monitor Type Code MTtM
n-numeric
A.3-7
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
Field Abbreviation List in Abbreviation Sequence (7 of 14)
File Name
P/A Monitor Surmary
P/A Monitor Sample Value
Sutmary Data
Simnary Data
Sunmary Data
Suimary Data
Suimary Data
Sunmary Data
Suimary Data
Swinery Data
Suimary Data
Suimary Data
Suimary Data
Suimary Data
Sunmary Data
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
Attainment (CCS)
Attainment (GCS)
Site and Monitor History
Site and Monitor History
SLAMS
SLAMS
SLAMS
Monitor
SLAMS
Description {GCS)
Site and Monitor History
Site and Monitor History
Mom tor
Site and Monitor History
Monitor
Compos i te
Daily Data
Hourly Data
Description (GCS)
Description (GCS)
Description {GCS)
Field Description ABBR
Monitor Type Code HUN
Monitor Type Code MTYP
Monitor Type Code MTYS
First Maximun Value MX1X
Second Maximum Value MX2X 6 n
Third Maximum Value MX3X 6 n
Fourth Maximum Value MX4X 6 n
Fifth Maximum Value MX5X 6 n
Day and Time of First Maximun Value MXT1 6
Day and Tine of Second Maximum Value MXT2 6
First Maximum Value with DP MXVl 7
Second Maximun Value with DP MXV2 7
Third Maximun Value with DP MXV3 7
Fourth Haximun Value with DP MXV4 7
Fifth Maximun Value with DP MXV5 7
Highest 1-Hour H02 Value with DP N11K 7
Date and Time of the Highest 1-Hour N02 Value N11T 6
Highest 1-Hour H02 Value N11X 4 n
Date of the Highest 24-Hour N02 Value N1XD 4
Highest 24-Hour N02 Value with DP N1XK 7
Highest 24-Hour N02 Value N1XX 4 n
Second Highest 1-Hour N02 Value with DP N21M 7
Date and Time of the Second Highest 1-Hour N02 Value N21T 6
Second Highest 1-Hour M02 Value N21X 4 n
Date of the Second Highest 24-Hour N02 Value N2XD 4
Second Highest 24-Hour N02 Value with DP N2XH 7
Second Highest 24-Hour N02 Value N2XX 4 n
Primary or Secondary Non-Attainment NAPS 1
Non-Attainment Total NATT 1
New Site or Monitor Detail Field Value NEWV 6
New Monitor Type Effective Date NHTD 8
Sample N02 Value Average with DP NOAM 7
Sample N02 Value Average NOAX 4 n
Decimal indicator for N02 NOOP 1
Nonattainment Area NONA 5
Sunmary Criteria Code for N02 NOSC 1
Suimary Criteria Code Description for SLAMS N02 NOSD 60
New Reporting Organization Effective Date NROO 8
Required Sampling Frequency Effective Date-EPA NSED 8
Nunber Scheduled Samples per Month (occurs 12 times) NSMT 2 n
New Required Sampling Frequency Effective Date-State NSSD 8
Number of Scheduled Samples Per Month NUMS 2
Null Value Reason Code MVCC 4
Mull Value Reason Code NVCD 4
Mull value Reason Code NVCH 5
Null Value Reason for Composite NVDC 35
Null Value Reason for Daily NVDD 35
Null Value Reason for Hourly NVDH 35
n=numeric
A. 3-8
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Field Abbreviation List in Abbreviation Sequence (8 of 14)
file Name
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
Summary Data
Monitor
Monitor
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor Sample Value
Site and Monitor History
Site and Monitor History
Site and Monitor History
Site
Site and Monitor History
Site and Monitor History
Site and Monitor History
Site and Monitor History
Site and Monitor History
Site and Monitor History
Summary Data
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor Sample Value
P/A Monitor Sample Value
Summary Data
Summary Data
Surmary Data
Summary Data
Surma ry Data
Emmery Data
Summary Data
Monitor
Field Description
Highest Daily 03 Value with DP
Date of the Highest Daily 03 Value
Highest Daily 03 Value
Second Highest Daily 03 Value with DP
Date of the Second Highest Daily 03 Value
Second Highest Daily 03 Value
Third Highest Daily 03 Value with OP
Date of the Third Highest Daily 03 Value
Third Highest Daily 03 Value
Fourth Highest Daily 03 Value with DP
Date of the Fourth Highest Daily 03 Value
Fourth Highest Daily 03 Value
Decimal Indicator for 03
Primary Standard 1-Hour 03 Violations
1-Hour Observations
24-Hour Observations
Number of Observations
Height of Obstruction
Type Obstruction
Indicated (Observed) Cone
Indicated (Observed) Cone
Indicated (Observed) Cone
Indicated (Observed) Cone
Indicated (Observed) Cone
Old Site or Monitor Detai
Old Monitor Type Effective Date
Old Monitor Type Code
Open Path Number
Old Reporting Organization Effective Date
Old Reporting Organization Code
Old EPA Required Sampling Frequency Effective Date
Old EPA Required Sampling Frequency Code
Old State Required Sampling Frequency Code
Old State Required Sampling Frequency Effective Date
Non-Overlapping Average Greater Than Standard
Indicated (Observed) Concentration Value for Level 1
Indicated (Observed) Concentration Value for Level 2
Indicated (Observed) Concentration Value for Level 3
Indicated (ODserved) Concentration Value for Level 4
Indicated (Observed) Concentration Value for Level 5
Tenth Percent He
Thirty Percentile
Fifty Percentile
Seventy Percentile
Ninety Percentile
Ninety-Five Percentile
Ninety-Nine Percent!le
PAMS Required Sampling Frequency
Value for Level 1 u/DP
Value for Level 2 u/DP
Value for Level 3 u/DP
Value for Level 4 u/DP
Value for Level 5 u/DP
Field Value
ABBE
031M
031T
031X
032M
032T
03 2X
033*
033T
033X
034M
034T
034X
03DP
03EX
OSS1
OBS7
OBSC
OBST
OBTY
OCL1
OCL2
OCL3
OCU
OCL5
OLDV
OMTD
OMTr
OPNO
OROO
OROG
OSED
OSFE
OSFS
OSSO
OVLP
OXL1
OXL2
OXL3
OXL4
OXL5
PI OX
P30X
P50X
P70X
P90X
P95X
P99X
PAMS
LOTH
7
6
4 n
7
6
4 n
7
6
4 n
7
6
4 n
1
3 n
4 n
3 n
4 n
2 n
1
7
7
7
7
7
8
8
1
1
8
3 n
8
1
1
6
4
5
5
5
5
5
6
6
6 n
6 n
6 n
6 n
6 n
1
4»
n-numeric
A. 3-9
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
Field Abbreviation List in Abbreviation Sequence (9 of 14)
File name
P/A Monitor Sumnary
P/A Rep. Org. Summary
P/A Rep. Org. Summary
Monitor
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
Description (CCS)
State (GCS)
SLAMS
Summary Data
Summary Data
Summary Data
Summary Data
Surma ry Data
Summary Data
Surmary Data
Attainment (GCS)
Collection and Analysis (GCS)
P/A Monitor Summary
P/A Rep. Org. Sumnary
Parameter Standards (GCS)
State (GCS)
State (GCS)
Parameter (GCS)
FJPS Area (CCS)
FIPS Area (GCS)
FIPS Area (GCS)
Parameter (GCS)
Parameter (GCS)
Composite
Daily Data
Hourly Date
SLAMS
Monitor
P/A Monitor Summary
P/A Monitor Sample Value
P/A Rep. Org. Sumary
Sumnary Data
Site and Monitor History
SLAMS
SLAMS
Description (GCS)
SLAMS
SLAMS
SLAMS
P/A Monitor Summary
Field Description ABBR yjTJl
Pollutant Average Number of Samplers PANN 5 n
Pollutant Average Number of Samplers PANR 5 n
Pollutant Audits Performed on Network PAPR 4 n
QA Plan Approved PAQA 1
Decimal Indicator for Pb (occurs 4 times) PBDP 1
Sample Value Average with DP for Pb (occurs 4 times) PBMX 7
Number o< Lead Samples in Qtr (occurs 4 times) PBNS 2 n
Quarter ?b (occurs 4 tines) PBQR 1
Sumrnry Criteria Code for Pb (occurs 4 times) PBSC 1
Summary Criteria Code Description for SLAMS Pb PBSC 60
State Pb Parameter Season Begin (occurs 25 times) PBST 4 n
Sample Value Average for Pb (occurs 4 times) PBXA 5 n
Tenth Percent!le with Dp PC10 7
Thirty Percent!le with DP PC30 7
Fifty Percentile with DP PC50 7
Seventy Percentile with DP PC70 7
Ninety Percentile with DP PC90 7
Ninety-Five Percentile with DP PC95 7
Ninety-Nine Percentile with DP PC99 7
Parameter Code PCAT 5
Parameter Code PCCA 5
Precision Checks Included in Calculations PCIN 4 n
Precision Checks Included in Calculations PCIR 4 n
Parameter Code PCPS 5
Parameter Code (occurs 25 times) PCST 5
State Parameter Season End (occurs 25 times) PEST 4 n
Parameter Abbreviation PLAB 5
County Parameter Season Begin PLBF 4 n
Parameter Code (occurs 25 times) PLCF 5
County Parameter Season End (occurs 25 times) PLEF 4 n
Parameter Name PLLN 70
Parameter code PLLT 5
Parameter Code PLTC 5
Parameter Code PLTD 5
Parameter Code PLTK 5
Parameter Code PLTL 5
Parameter Code PLTM 5
Parameter Code PLTN 5
Parameter Code PLTP 5
Parameter Code PLTR 5
Parameter Code PLTS 5
Parameter Code PLTT 5
Sample Value Average with DP for PM10 PMAM 7
Sample Value Average with PM10 PHAX 4 n
Sampling Frequency for SLAMS PMDL 20
Decimal Indicator for PM10 PMDP 1
Date Sampling Freq. Effective for PH10 (occurs 4 times) PKDS 4
Date of PM10 Violation (occurs 60 times) PMEO 4
Precision Hean PKEN 12
^numeric
A.3-10
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Field Abbreviation List in Abbreviation Sequence (10 of 14)
File Name
SLAMS
SUMS
SLAMS
SLAMS
Description (CCS)
SLAMS
Monitor
SLAMS
Suimary Data
Composite
Daily Data
Hourly Data
SLAMS
Monitor
P/A Monitor Surmary
P/A Monitor Sample Value
Suronary Data
Site and Monitor History
Parameter Standards (CCS)
Monitor
P/A Monitor Sunnery
SLAMS
Description (GCS)
EPA Region (GCS)
Site
Monitor
Site
EPA Region (GCS)
EPA Region (GCS)
EPA Region (GCS)
Summary Data
Collection and Analysis (GCS)
Monitor
Monitor
P/A Monitor Summary
P/A Rep. Org. Summary
Monitor
Monitor
Description (GCS)
Monitor
Monitor
Field Description AJBR LGTH
Primary Standard Viol, w/ DP for PM10 (occurs 60 times) PMEV 7
Primary Standard Violation for PM10 (occurs 60 times) PMEX 4 n
Summary Criteria Code for PM10 PKSC 1
Additional Observations for PM10 (occurs 4 times) PMSD 3 n
Summary Criteria Description for SLAMS PM10 PMSE 60
Sampling Frequency for PM10 (occurs 4 times) PMSF 1
Date of First Primary Standard Violation for PM10 PMVL 6
24-Hour Observations for PM10 (occurs 4 times) PMXO 3 n
Percentage of Observations ROBS 3 n
Parameter Occurrence Code PQCC 1
Parameter Occurrence Code POCO 1
Parameter Occurrence Code POCH 1
Parameter Occurrence Code POCL 1
Parameter Occurrence Code POCH 1
Parameter Occurrence Code POCH 1
Parameter Occurrence Code POCP 1
Parameter Occurrence Code POCS 1
Parameter Occurrence Code POCT 1
Primary Standard PRIS 8 n
Probe Height From Ground (Meters) PR06 3 n
Precision Standard Deviation PSDV 10
Primary Standard 24-Hour Violations for S02 PSXV 4 n
Required 24-Hour Sampling Freq. Desc. • EPA for Monitor REDM 20
Region Code REGN 2 n
Receiver Height RENT 2
Region Code RGCD 2 n
Regional Evaluation Date RGEV 6
Region Name RGNM 13
Region Population RGPO 8 n
Region Size-Square Miles RGSZ 7 n
Required Monitoring Time RMNT 4 n
Reference Method Code RMTH 13
Reporting Organization Code ROCD 3 n
Reporting Organization Effective Date ROED 6
Reporting Organization Code ROGN 3 n
Reporting Organization Code ROGR 3 n
Reporting Organization Name for Monitor RONM 60
Required Sampling Frequency Effective Date-EPA RSDE 8
Required 24-Hour Sampling Freq. Code Desc.-State RSDM 20
Required 24-Hour Sampling Frequency Code EPA RSFE 1
Required 24-Hour Sampling Frequency Code State RSFS 1
n=numenc
A.3-11
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
Field Abbreviation List in Abbreviation Sequence (11 of 14)
File Maine
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
SLAMS
Site
Site
Attainment
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Field Abbreviation List in Abbreviation Sequence (12 of 14)
File Name
SLAMS
SLAMS
SLAMS
SLAMS
Description (GCS)
SLAMS
State (GCS)
Agency (GCS)
State (GCS)
Collection and Analysis (GCS)
Composite
Daily Data
Hourly Data
SLAMS
Monitor
P/A Monitor Summary
P/A Monitor Sample Value
P/A Rep. Org. Summary
Site
Site and Monitor History
Sunmary Data
Parameter Standards (GCS)
FIPS Area (GCS)
Daily Data
Site
State (GCS)
Site
Monitor
State (GCS)
Parameter Standards
Site
Site
State (GCS)
Monitor
P/A Monitor Suwnary
P/A Monitor Sample Value
P/A Monitor Summary
Site
Surmary Data
P/A Monitor Summary
P/A Rep. Org. Sunmary
Site
Site
Site
P/A Monitor Sumrary
P/A Monitor Sample Value
P/A Sep. Org. Summary
Description (GCS)
P/A Monitor Sunmary
P/A Monitor Sample Value
P/A Rep. Org. Summary
field Description ABBR LSTH
Sample Value Average with DP for S02 SOAM 7
Sample Value Average for S02 SOAX 4 n
Decimal Indicator for 502 SOCP 1
Sunmary Criteria Code for S02 SOSC 1
Sunmary Criteria Description for SLAMS S02 SOSD 60
Secondary Standard 3-Hour for S02 Average Violations SSYV 4 n
State Abbreviation STAB 2
State Code-FIPS STAG 2
State Code-FIPS STAT 2
State Code-FIPS (occurs 10 times) STCA 2
State Code-FIPS STCC 2
State Code-FIPS STCO 2
State Code-FIPS STCH 2
State Code-FIPS STCL 2
State Code-FIPS STCH 2
State Code-FIPS STCN 2
State Code-FIPS STCP 2
State Code-FIPS STCR 2
State Code-FIPS STCS 2
State Code-FIPS STCT 2
State Code-FIPS STCY 2
Standard Units Code STDU 3 n
State Code FIPS STGF 2
Sample Value Start Hour STHR 2
State or Local ID STLO 10
State Name STNH 20
Tangent Street Nutter STNO 1
Monitor Street Number STNU 1
State Population STPO 8 n
State Code-FlPS STPS 2 n
Street Name STRH 20
Street Address STRT 40
State Size-Square Miles STSZ 7 n
Surrogate Flag-TSP/PMlO SURR 1
Type of Audit Description TADN 45
Type of Audit Description TADP 45
Type of Audit Description TADR 45
Transmitter Height THGT 2 n
Time Period (occurs 5 times) TIME 2
Time Period TIMN 2
Time Period TIMR 2
Type Meteorological Site TMSI 1
Traffic Flow TRAP 6 n
Year of Traffic Flow TRYR 4
Type of Accuracy Audit TYAN 1
Type of Accuracy Audit TYAP 1
Type of Accuracy Audit TYAR 1
Road type Code Description for Nearby Roads for Monitor TYDM 60
Monitor Data Recording Mode TYDN 1
Type of Date TYDP 1
Monitor Data Recording Mode TYDR 1
n=numeric
A.3-13
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
Field Abbreviation List in Abbreviation Sequence (13 of 14)
file Name
Site
Collection and Analysis (CCS)
Description (CCS)
Description (GCS)
Description (GCS)
Description (GCS)
P/A Monitor Sunmary
P/A Monitor Sample Value
Description (GCS)
Composite
Daily Data
Hourly Data
SLAMS
P/A Monitor Sunnary
P/A Monitor Sample Value
Suimary Data
P/A Monitor Sutmsry
P/A Rep. Org. Suimary
P/A Monitor Suwnary
P/A Rep. Org. Sumury
P/A Monitor Surma ry
P/A Rep. Org. Suimary
P/A Monitor Sumary
P/A Rep. Org. Sunnary
P/A Monitor Summery
P/A Rep. Org. Sunnary
Urban Area (GCS)
Monitor
Urban Area (GCS)
Urban Area (GCS)
Site
Site
Site
Collection and Analysis (CCS)
P/A Monitor Sunnary
P/A Rep. Org. Suifnary
Sunnary Data
Monitor
Collection and Analysis (GCS)
Description (CCS)
Description (GCS)
Description (GCS)
Composite
Daily Data
Hourly Data
Parameter (GCS)
Description (GCS)
Monitor
Field Description
Type Road
Units Code
Units Code Description for Composite
Units Code Description for Daily
Units Code Description for Hourly
Units Code Description for SLAMS
Units Description
Units Description
Standard Units Code Description for Sunnary
Units Code
Units Code
Units Code
Units Code
Units Code
Units Code
Standard Units Code
Level 1 Upper Probability Limit Average
Level 1 Upper Probability Limit Average
Level 2 Upper Probability Limit Average
Level 2 Upper Probability Limit Average
Level 3 Upper Probability Limit Average
Level 3 Upper Probability Limit Average
Level 4 Upper Probability Limit Average
Level l, Upper Probability Limit Average
Level 5 Upper Probability Limit Average
Level 5 Upper Probability Limit Average
Urban Area Code
Urban Area Represented Code
Urban Area Name
Urban Area Population
UTH Easting (Horizontal) Coordinate (Meters)
UTH Northing (Vertical) Coordinate (Meters)
Universal Transverse Mercator (UTM) System Zone
Standard Units Code
Valid Collocated Data Pairs
Valid Collocated Data Pairs
Valid Days
Vertical Distance (From Support)
EPA Method Validity Flag Code
Sample Value Validity Flag Description for Composite
Sample Value Validity Flag Description for Daily
Sample Value Validity Flag Description Hourly
Sample Value Validity Flag
Sample Value Validity Flag
Sample Value Validity Flag
Validity Flag (occurs 20 times)
Worst Site Description for Monitor
Worst Site Code
ABBR
LJJH
TYPR
UNCO
UNDC
UNDO
UNDK
UNDL
UNDN
UNDP
UNDS
UNTC
UNTO
UNTH
UNTL
UNTN
UNTP
UNTS
UP1N
UP1R
UP2N
UP2R
UP3N
UP3R
UP4N
UP4R
UP5N
UP5R
URBC
URBN
URNM
URNP
UTME
UTMN
UTHZ
UTSS
VCDN
VCDR
VDAY
VERT
VFCA
VFDC
VFDO
VFDH
VFGC
VFGD
VFGK
VFLG
URDM
WRST
1
3 n
30
30
3d
3d
3d
3d
3d
3 n
3 n
3 n
3 n
3 n
3 n
3 n
3
3
3
3
3
3
3
3
3
3
4
4 n
45
8 n
8 n
7 n
2
3 n
4 n
4 n
3 n
1 n
1
40
40
40
2
2
2
1
60
1
n=nuneric
A.3-14
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Field Abbreviation List in Abbreviation Sequence (14 of 14)
File Name
Summary Data
Sumnery Data
Surmary Data
Composite
Daily Data
Hourly Data
SLAMS
P/A Monitor Sunwry
P/A Monitor Sample Value
P/A Rep. Org. Sumary
Suimary Data
P/A Monitor Sample Value
P/A Monitor SanpLe Value
P/A Monitor Sanple Value
Surma ry Data
Surma ry Data
Sumary Data
Composite
Daily Data
Hourly Data
SLAMS
P/A Monitor Summary
P/A Monitor Sanple Value
P/A Rep. Org. Surma ry
Surmary Data
P/A Monitor Sarrpte Value
P/A Monitor Sairple Value
P/A Monitor Sarrpte Value
Field Description
Yearly Weighted Arithmetic Mean with DP
Yearly Weighted Arithmetic Mean
Days that Exceed Alert level
Year
Year
Year
Year
Year
Year
Year
Year
Zero Span Value Decimal Indicator
Zero Span w/DP
Zero Span Value
Yearly Weighted Arithmetic Mean with OP
Yearly Weighted Arithmetic Mean
Days that Exceed Alert Level
Year
Year
Year
Year
Year
Year
Year
Year
Zero Span Value Decimal Indicator
Zero Span w/DP
Zero Span Value
ABBR
WTDA
W7DX
XALT
YRRC
YRRD
YRRH
YRRL
YRRN
YRRP
YRRR
YRRS
ZSDP
ZSW
ZSVX
WTDA
WTDX
XALT
YRRC
YRRD
YRRK
YRRL
YRRN
YRRP
YRRR
YfiRS
ZSDP
ZSW
ZSVX
LGTH
A.3-15
-------
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Appendix A.4
AQS File Cross-Reference for Common Fields
This appendix contains a list of fields that have more than one ABBR, because they occur in multiple
AQS files.
A.4-1
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
AQS File Cross-Reference for Common Fields
Field Description
County
Day
Decimal Indicator
Exceptional Data Flag
Interval
Method
Monitor ID
Monitor Type
Month
Null Value Code
Parameter
POC
Reporting Organization
Sample Value with no DP
Sample Value with DP
Site Number within County
State Code
Units
Validity Flag
Year
F I L
S
1
T
E
CNTY
SITE
STCS
M
0
N
I
T
0
R
CNYM
MOW I
MTYM
PLTM
POCK
ROCD
SITU
STCM
S
u
M
M
A
R
Y
CMYS
EXCS
INTS
MTHS
MNIS
MTYS
PITS
POCS
SITS
STCY
UNTS
YRRS
H
0
U
K
L
Y
CNYH
DAYH
SOPH
EXCH
INVH
HTHH
MNIK
HTTH
MNTH
NVCH
PLTH
POCH
SMKX
SMPH
SITH
STCH
UNTH
VFGH
YRRH
D
A
I
L
Y
CNYD
DAYD
SDPD
INVD
MTHD
MNID
MTYD
MNTD
NVCO
PLTD
POCD
SHDX
SMPD
SITD
STCO
UNTO
VFGO
YRRD
E N
C
0
H
P
0
S
1
T
E
CNYC
SOPC
INVC
MTHC
MNIC
MTYC
NVCC
PLTC
POCC
SHCX
SMPC
snc
STCC
UNTC
VFGC
YRRC
A M E
S
L
A
M
S
CNTL
INVL
MTHL
HN1L
PLTL
POOL
ROPA
SITL
STCL
UNTL
YRRL
P
A
S
K U
0 K
N K
I A
T R
0 Y
R
CNYN
INVN
MTMN
MNIN
MTYN
PLTN
POCN
ROCN
S1TN
STCN
UNTN
YRPN
P
A
R
A
w
D
A
T
A
CNYP
DAYP
INVP
HTHP
MNIP
MTYP
MNTP
PUP
POCP
SITP
STEP
UNTP
YRRP
P
A
R S
0 U
M
H
*
R
Y
PLTR
ROGR
STCR
YRRR
H
I
S
T
0
R
Y
C«YT
MNIT
OHTY
PLTT
POCT
OROG
SITT
STCT
A.4-2
-------
AIRS User's Guide
Volume AQS
Ad hoc Retrieval
Appendix A.5
File Level, Key Field/Abbreviation Cross-Reference
This appendix contain-; a list of key field ABBRs. Key field ABBRs are used when specifying select
criteria to identify the subset of data you wish to retrieve. For a more efficient batch job, use the key
field ABBRs from the files with the highest file level. This will make your batch job run more efficiently
by using fewer system resources.
o
A.5-1
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
File Level, Key Field/Abbreviation Cross-Reference
FILE NAME
Field Description
Air Quality Control Region
City Code
Composite Type
County
EPA Region Code
Interval
Method
Metropolitan
Statistical Area
Monitor Data
Recording Mode
Monitor ID
Monitor Type
Month
New Site or Monitor Field
Value
Old Site or Monitor Field
Value
Parameter
Reporting Org
Screening File Name
Site
Site or Monitor Field
Name
State Code
Support Agency Code
Units
Urban Area Code
Year
s
I
T
E
High-
9
M
0
N
I
T
0
R
c
8
AQCM
CTYM
S
U
H
M
A
R
Y
7
H
0
U
R
L
Y
-- F
6
D
A
I
L
Y
1 L E
6
C
0
H
P
0
S
I
T
E
. L E
6
S
L
A
M
S
: v E
5
P
A
s
M U
0 M
N M
1 A
T R
0 Y
n
L --•
4
P
A
R
A
y
D
*
T
3
P
A
R S
0 U
M
M
A
B
"
2
H
I
S
T
0
R
Y
>LOW<
i
1 !
CTYP
CNTY
RGCD
INTS INVH INVD
MTHH MTHD MTHC
MTHP
KSAH
TYDR
HONI MNIS MN1H KNID MNIC MNIL MNIN MNIP MK1T
MTYM MTYS KTYH MTYD
MNTH KNTP
NEUV
OLDV
ROOD
SCRN
PLTR
ROGR
SITE
STCS
SAGC
CHGF
STCR
UNTS UNTH UNTD UNTC UMTL UNTN UNTP
URBN
YRRS YRRH YRRD YRRC YRRL YRRN YRRP YRRR
A.5-2
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Appendix A.6
Sample Ad hoc Batch Retrieval, Data Listing Report and Work File
Generate a report and work file that contain:
• all national ozone monitors
• monitors located in a rural agricultural setting
• reporting data in 1986
• the yearly maximum value and number of primary
standard violations for each monitor
A.6-1
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
05/08/92 AIRS Air Quality SubsystM AHP600A
Report Options
Report Name: AD MX Criteria Name: AGRIRURL
Enter Title:
OZONE SITES CLASSIFIED AS RURAL AGRICULTURAL FOR 1986
Choose at least one output:
X 1. Generate a data listing report (Select format and headers below):
X Single Spaced Double Spaced Double Spaced 2 Lines
X Expended Headers ~ ABB* Headers
2. :Senerate a cross tabulation report {Select format below):
Single Spaced Double Spaced
X 3. Generate a uorkfile (Fnter name below):
8FCASVJD . ozone . sites . rural . agrirurl
Enter Comments (optional):
CRITERIA NAME = AGRIRORL
PF3=end PF4=main menu PF5=terminate PF9=save
criteria
Report Options Screen
05/08/92
AIRS Air Quality Subs/stem
AHP600A1
Date Listing Output Fields
Report Name: AD HOC
Total
PM*insert
PF6=report
Field Co I urn
ABSR Length Width
STAB 2 6
ARKC ?0 21
SITJ 9 10
POCS 1 4
CTTO 5 6
CYKH 50 21
STRT 40 41
MXV1 7 8
EPR1 J> 8
Report Width: 125
PF2*defaults
options PF7<4>ack
Criteria Name:
Header 1 Header 2 Header 3
STATE ABBR
COUNTY NAME
SITE ID
POC
CITY CODE
CITY NAME
STREET ADDRESS
1ST KAX
PRIMARY STANOARD_ EXCEEDS
Maximum width Allowed: 131 Page 1
AGRIRURL
of 9
PF3=end PF4=main menu PFS^terminate
PF8=more PF9-save criteria
Data Listing Output Fields Screen
A.6-2
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
05/08/92
Report Name: AD HOC
ABBR Cord
AIRS Air Quality Subsystem
Select Criteria
Value
ABBR Cond
Criteria M«
Value
AMP600B
AGRIRUHL
YUS ME: 86
LOCN ME: 3_I
TME HE YR
IUSE ME
PLTS ME
PF3=end
l>F7*beck
PF4=*»Bin menu
PF5=tenninete
PF9=save criteria
Page 1 of 5
PF6=report options
Select Criteria Screen
05/08/92
AIRS Air Quality Subsystem
Sort Criteria
Report Ntune: AD HOC
A
ABBR (A/D)
1 . STAB
4. POCS
7. STRT
10.
13.
16.
19.
22.
K.
ae. '
31.
= ascending (default)
PF1=insert
PF6>selei:t criteria
ABBR (A/0)
2. ARNC
3. CTYM
a. Hxvi
11.
H.
17.
20.
23.
26.
29.
32.
D x descending
PF3=end PF4=matn
PF7=back PFfl=more
Criteria Name:
ABBR
3. SITI
6. CYNH
9. EPR1
12.
15.
18.
21.
24.
27.
30.
33.
menu
(A/D)
Page 1 of
AHP600C
AGRIRURL
3
PF5=terminBte
PF9=save
criteria
Sort Criteria Screen
A.6-3
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
05/08/92
Report Na
AIRS Air Quality Subsystem
JCL Parameter*
AD HOC
ENTER:
Criteria Na
AMP600D
AGRIRURL
JOB Name
Account Code/UlO
Time (HMM . SS)
Priority v.
Message Class
Nurcber of Copies
form lhafeer
aocw/Bin NuMber
Hold Output (T/K)
Printer Site Id
BFC AGRIR
ASUD AIRSO
2 , _
f
E381
B132
y
RKTOOO
Press ENTEV to submit JOB
PF3=end PF4»»Bin »enu PF5=ter«in«te PF6
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
09/24/93
AKS691CG
EPA AERWETRIC INFORMATION RETRIEVAL srsTW (AIRS)
AIR QUALITY SUBSYSTEM
AD HOC REPORT CRITERIA
CRITERIA LISTING
PAGE
REPORT : DATA LISTING
FORMAT : SINGLE SPACED
HEADERS : EXPANDED
TITLE : OZONE SITES CLASSIFIED AS RURAL AGRICULTURAL FOB 1986
COMMENTS: CRITERIA NAME • AGRIRURL
HORKFILE: PKBASWD.OZONE.SITES.RURAL.AGRIRURL
1.
2.
3.
4.
5.
6.
7.
e.
9.
OUTPUT FIELDS
FIELD COLUMN
ABfifi LENGTH HIOTK HEADER 1 HEADER 2 HEADER 3
SELECT CRITERIA
ABBR COND VALUE
STAB
ARNC
SITI
POCS
CTTH
crNM
STRT
NXV1
EPfil
z
20
9
1
S
20
40
7
4
6
21
10
4
6
21
41
8
8 PRIMARY
STATF.
COUNTY
cm
STREET
STANDARD
ABBR
NAM;
SITE ID
POC
CODE
cm NAM:
ADDRESS
1ST MAX
EXCEEDS
tRRS
LUSE
LOCN
PLTS
TIKE
ME 8E
ME
ME
ME 44201
NE VR
- SORT —
ABBR (A/Dj
STAB
ARNC
SITI
POCS
CTTH
CVNH
STRT
HXV1
EPRi
TOTAL REPORT KIDTH: 125 MAXIMUM WIDTH ALLOWED; 131
Criteria Listing Report
A.6-5
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
09/24/93
AMS691CG
EPA AEROMETRIC INFORMATION RETRIEVAL SYSTEM (AIRS)
AID QUALITY SUBSYSTEM
AD HOC REPORT CRITERIA
WRKFILE LISTING
PAGE:
UORKFILE i PK8ASMD.OZONE.SITES.RURAL.ASRIRURL
RECORD FORMAT: FB
RECORD LENGTH: 131
BLOCK SIZE : 11397
FIRST FIELD FIELD
BYTE DEFINITION ABBR
COMMENTS
AQ5/GCS FIELD NAME
AQS/GCS FILE NAME
1 X{2) STAB STATE ABBREVIATION STATE-ABBREV
3 1(20} ARNC COUNTY NAME systcn-fcnertted
23 X(9) SITI SITE ID (STATE/COUKTT/SITE] iyltcn-gcncrited
32 X(l) POCS PARAMETER OCCURRENCE CODE POC
33 9(5) CTYN FIPS CITY CODE CITT
38 X(20) CYNM CITY NAME >yst«n-9«ntrated
58 X(40) STRT BUILDING/STREET ADDRESS STREET-ADDRESS
IS X(7) MXV1 1ST MAXIMUM VALUE WITH DP systen-fcncrited
105 9(4) EPRI PRIMARY STANDARD VIOLATIONS EXCEEO-STO-PRI
109 X(23) FILLER
AIRS-GEO-STATE
AIRS-GEO-FIPS-AREA
AM-SITE
AM-SUMMART
AM-HONITOR
AM-MONITOR
AM-SITE
AM-SUNHARv
AM.SUMMARY
Workfile Listing Report
A.6-6
-------
AIRS User's Guide
Volume AQ5 Ad hoc Retrieval
09/24/93 EPA AEROHETRIC INFORMATION RETRIEVAL SYSTEM (AIRS) PAGE 1
EXTRACT AIR QUAIITT SUBSYSTEM
AD HOC EXTRACT PROCESSING SUMMARY
114 RECORDS HERE WRITTEN TO THE WORKFRE
• * * THE EXTRACT PROGRAM ( AMPKB542 ) ENDED ON 09/Z4/93 AT 09:20:01.3 • * *
Extract Processing Summary Report
A. 6-7
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
PLSORT OS SORT/MERGE REL 6.3-Z560E PKBAGRIR/SORT /SORT
PLS05H SVSIN:
PIS341I: SORT FORNAT-CN,
PLS3411: FtaDS"{],2,A.3,20,A,23.9,A.32.1.A.32,5,A.38,2C,A.
PLS341I: M,40.A.98,7.A,105,4,A)
PLS341I: SUM FIELDS-HONE
PLS034I SORTIN LRECL • 131, RECFM • FB,
PLS104I MEMORY USED Z04K. RESERVED 8K
PLS313I RCO LENGTH IN 131, OUT 131
PLS034I SORTOUT LRECL • 131, RECFM . FB
PLS095I USABLE SORTHORK PRIMARY SPACE •
PLS096! NMAX ESTIMATE • 11.720 RCOS
PLSOei! END INCORE SORT. RCDS IN 114 OUT 114
PLS083I BYTES OUT 14,934
09/24/93 09(20:03
11397
BLKStZE • 113S?
1.53S.40G BYTES. INCLUDING 511,800 IN HIPERSPACE
Sort Processing Summary Report
A.6-8
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
09/24/93
ANP600R1
EPA AEROMETRIC INFORMATION RETRIEVAL SYSTEM (AIRS)
AIR QUALITY SUBSYSTEM
DATA LISTING REPORT
OZONE SITES CLASSIFIED AS RURAL AGRICULTURAL FOR 1986
STATE COUNTY
ASBR
*L
AL
C»
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CO
CO
DE
Fl
FL
GA
GA
IA
IA
IL
11
IL
IL
IN
IN
IN
IN
SS
KS
KS
KY
KY
ICY
KY
L*
U
MA
MA
MA
NAME
MONTGOMERY CO
SHELBY CO
CONTRA COSTA CO
KERh CO
SAN BERNARDINO CD
SANTA BARBARA CO
SANTA BARBARA CO
SANTA BARBARA CO
SANTA BARBARA CO
SANTA BARBARA CO
SANTA BARBARA CO
SANTA BARBARA CO
SANTA BARBARA CO
SANTA BARBARA CO
SANTA BARBARA CO
SANTA BARBARA CO
SUTTER CO
VENTURA CO
VENTURA CO
VENTURA CO
ADAMS CO
ADAMS CO
NEW CASTLE CO
LEON CO
PALM BEACH CO
NUSCOGEE CO
ROCHDALE CO
LINN CO
SCOTT CO
EFFINGHAK CO
NACOUPIN CO
MADISON CO
MONROE CO
HANCOCK CC
KNOX CO
KNOX CO
MARION CC
MORGAN CO
JEFFERSON CO
SEDGWICK CO
BOCNE CO
FAYETTE CO
LIVINGSTON CO
MUHLENBERG CO
CADOO PAR
EAST BATON ROUGE PAR
HAHPDEN CC
HAMPSHIRE CO
MIDDLESEX CO
SITE ID POC
(H1011001
011170004
060131002
060290007
C60711101
060831010
060831011 1
060831012 1
060831013 1
060831014 1
060831015 1
060831021
060831030
06DB33001
060834004
05083S001
Oc51010002
0«1110004
061110005 1
061113001 1
080013001 1
080013001 2
100030016 1
U0730002 1
120990006 1
1:2151003 1
1-2470001 1
151131015 1
191632011 1
170491001 1
171170002 1
171192007 2
171332001 1
180590CC2 1
180830003 2
180830004 2
183970042 1
181090003 1
203870001 1
201730001 1
210150003 1
210670001 1
211390003 1
211770006 1
220170001 2
220331001 2
250130003 1
250150002 1
25M71801 1
CITY
CODE CITY NAME
00000
ooooo
06210 BETHEL ISLAND
Z1544 EDISON
80994 TUENTYNINE PALMS
69196 SANTA MARIA
37036 J A LAM A
15142 COKCEPCiON
42524 LOKPOC
44210 LOS PADRES NATIONAL
29238 UVIOTA
11446 CARPINTERIA
15142 CONCEPCION
70182 SANTA TNE7.
82072 VANDENBERG AFB
82072 VANDENBERG AFB
57750 PLEASANT GROVE
57372 PIRU
53182 OAK VIEW
22370 EL RIO
OOOOD
OOOOO
OOOOO
OOOOO
00000
OOOOO
OOOOO
OOOOO
OOOOO
OOOOO
53039 NILWOOD
OOOOO
75150 WATERLOO
24286 FORTVILLE
OOOOO
ooooc
36000 INDIANAPOLIS
OOOOO
OOOOO
ooooc
ooooc
OOOOO
OOOOO
ooooc
ooooc
ooooc
00765 AGAW4"
01250 AMnERSI
68225 SUOBURt
STREET
ADDRESS
P.O. BOX 114, GRADY ALA. 36036
BEARDEN FARM
5551 BETHEL ISLAND RD. BETHEL ISLAND
JOHNSON FARM, EDISON. CA. 93320
6078 ADOBE RD., TUENTTNINE PALMS
BATTLES-BETTERAVIA RD, SANTA MARIA
JALAMA BEACH COUNTY PARK, J ALAN A
POINT CONCEPTION LIGHTHOUSE, CONCEPCION
HS 1 P FACILlTr-500 N SU. LOMPOC
PARADISE RO-LOS PADRES NF
GAVIOTA HEST-NU OF CHEVRON PLANT
GOBERNAOOR RD. CARPINTERIA
GOVERNMENT PT, BIXBY RANCH, CONCEPCION
AIRPORT RD., SANTA YNEZ
POINT ARGUELLO-NE OF SLC. VANDENBERG AFB
WATT RD, VANOENBERG AFB
4SW-7310 PACIFIC AVE, PLEASANT GROVE
2SW, 2815 TELEGRAPH RD, PIRU
S50C CASITAS PASS RD, NEAR OAK VIEW
RIO MESA SCHOOL. EL RIO
78TH AVE t STEELE ST - UELBY
78TH AVE t STEELE ST - WELBY
LUMS POND STATE PARK
BRANNERNAN RD AND TOERR RD. BLOCKERFLA.
STATE ROAD 80 AT TWENTY MILE BEND
COLUMBUS CRIME LAB , US HHY 80. SPUR 22
CONYERS MONASTERY . 3780 GA HWY 212
HWY 13 NORTH OF MARION AT COUNTY MM RO.
HWY 2-30 1. SMILES N. OF ARGO
ROUTE 45 SOUTH, EFFINGHAM
IEPA TRAILER NEATON I OUBOIS
POAG ROAD, EOWARDSVILLE
U.S. DEPT. OF A3. BLDG.
NT VERNOti SCHOOLS
1.0 MILES EAST OF SR 41
PURDUE S.W. AG. CENTER - VINCENNES
8327 MANN ROAD
PARAGON ELEMENTARY SCHOOL
FAA STATION
CO. FIRE STATIONS .200 EAST 53RD ST.NORT
JCT KY 338 I KY 536 EAST BEND KY
IRON WORKS PIKE. HWY 353 LEXINGTON. KY.
HIGHWAY MAINTENANCE GARAGE US 60
TVA PARAOISE 21 4.3 MI SSE PARADISE FP
HAGOOD ROAD ~
HIGHWAY 964
152 SOUTH WESTFIELO STREET. FEEDING HILL
SOLAR HABITAT, UNIVERSITY OF MA
MATER ROW RD GREAT MEADOWS NAT WILDLIFE
1ST MAX
0.115
0.174
0.120
0.16C
0.090
0.106
0.089
0.046
0.141
0.136
0.135
0.156
0.108
0.10D
0.09E
0.100
0.140
0.140
0.150
0.180
0.071
0.162
0.120
0.083
0.102
0.11C
0.165
0.082
0.097
0.117
0.121
0.145
0.1H
0.103
0.118
0.115
0.112
0.117
0.110
0.09C
0.141
0.146
0.130
0.073
0.100
0.153
0.127
0.130
0.100
PAGE 1
PRIMARY
STANDARD
EXCEEDS
0
3
0
28
0
0
0
0
4
3
1
2
0
0
0
0
1
9
7
5
0
2
0
0
0
0
7
0
0
0
0
3
c
0
0
0
0
0
0
0
1
2
2
0
0
2
2
1
0
Data Listing Report (1 of 3)
A.6-9
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
09/24/93
AMP600R1
STATE COUNTY
ABB* NAME
NO
HD
NO
MO
HD
HE
MI
Mt
HI
HI
MI
HI
NN
NO
HO
NC
NC
NC
NC
NC
NO
ME
NJ
NJ
NJ
NJ
KJ
NK
NY
NY
OH
OH
OH
OH
OK
OK
OK
OR
OR
OR
PI!
SC
sc
SC
sc
TN
TN
TN
TX
ANNE ARUNOEL CO
CARROLL CO
CHARLES CO
PRINCE GEORGES CO
HI COHI CO CO
HANCOCK CO
CLINTON CO
DICKINSON CO
DICKINSON CO
GENESEE CO
KENT CO
UASHTENAU CO
WASHINGTON CO
CLAY CO
ST CHARLES CO
CUMBERLAND CO
HART IN CO
MECKLENBURG CO
PERSON CO
HAKE CO
DUNN CO
DOUGLAS CO
GLOUCESTER CO
HUNTERDON CO
MIDDLESEX CO
MORRIS CO
OCEAN CO
DONA ANA CO
NIAGARA CO
HAYNE CO
CLARK CO
CLINTON CO
PORTAGE CO
PREBLE CO
MC CLAIN CO
TULSA CO
CLACKAHAS CO
COLUMBIA CO
LANE CO
NAD ION CO
FLORIDA CO
EDGEFIELD CO
GREENVILLE CO
PICKENS CO
RiCHLAND CO
HAMILTON CO
KNOX CO
SHELBY CO
CHAMBERS CO
SITE ID
240030014
240130001
240170010
240330002
240451004
230092003
EPA AEROHETRIC INFORMATION RETRIEVAL SYSTEM (AIRS)
AIR QUALITY SUBSYSTEM
DATA LISTING REPORT
OZONE SITES CLASSIFIED AS RURAL AGRICULTURAL FOR 19B6
CITY STREET
POC CODE CITY NAME
1 00000
1 00000
1 00000
1 34775 GREENBELT
1 00000
1 00000
260370001 2 OOCOO
2(0430901
260430902
260492001
260812001
261611001
271630027
1 00000
1 00000
1 00000
1 00000
1 71140 SALINE
1 00000
290470005 1 00000
291831002
370510001
371170099
371191009
371450099
371832001
3S02S0003
310550032
340150002
340190001
340230006
340273001
340290006
3 SOI 30008
360631006
361173001
390230001
390271001
391331001
391351001
400870073
401430174
410050004
410090004 1
410391007 1
1 00000
1 00000
1 00000
1 00000
1 00000
70540 HAKE FOREST
00000
37000 OMAN*
00000
23700 FLENINGTON
00000
00000
00000
00000
00000
00000
00000
00000
OOCOO
00000
00000
29600 GLENFOOL
10750 CANE»
OOOOC
00000
410470004 2 00000
720540001
450370001
450450007
450770002
450791001
470651011 1
470930021 1
471571004 1
480710900 1
00000
00000
30985 GREER
14950 CIEKSOK
00000
00000
00000
00300
OOOOC
ADDRESS 1ST
QUEEN ANNE AND HAYSON ROADS
1300 V. OLD LIBERTY ROAD. HINFIELD.MD
SO HD CORRECTIONAL CAMP. HUGHESVILLE MD
CODDARD SPACE FLIGHT CENTER
U OF HD AGRICULTURAL EXPERIMENTAL FARM
BALD HTN..DUANE PROP.-DEDHAM
8562 E STOLL RD. ROSE LAKE
CHAMPION SITE 11
CHAMPION SITE 12
UASHBURN RD
43S1 PARNELL AVE N£
8910 SALINE-MILAN RD
WITHROW ELEMENTARY SCHOOL
NWY33 I COUNTY HOME ROAD
GENERAL ELECTRIC STORE HIUAY 94 U ALTON
OLD US HWY 301 • ARMSTRONG JR HIGH
SB 1538 NC 171
29 W MECKLENBURG CAB CO
SR 1102 1 NC 49
HWY 96 HAKE FORREST HATER TREATMENT PLAN
DUNN CENTEX RURAL
11414 N 72ND ST NATION HEATHER SERVICE
CLARKSBORO. SHADY LANE REST HOME
RARITAN STP.RTE.613S. THREE BRIDGES
RYDERS LANE 1 LOG CABIN ROAD
BLOG.I1, BELL LABS, OFF ROUTE 513
COLLIERS HILLS, JACKSON TOWNSHIP
ST LUKES EPISCOPAL CK RT 1 (LA UNION)
NIODLEPORT STP, NORTH HARTLAND SD
WAYNE EDUCATIONAL CENTER, WILLIAMSON
5171 URSANA ROAD
LODGE RD. LAUREL OAKS CAREER CENTER
1570 RAVENNA ROAD
NATIONAL TRAILS SCHOOL
GOLDSBY TREE FARM
502 EAST 144TK. PL.
CARUS TMILER/SPANSLER K
SAUVIE ISLANQ-SSB/ROUU 1, BOX 44?
79980 DELIGHT VALLEY SCHOOL RD. SAGINAW
CASCADE JR NIGH 10226 MARION RD TURNER 0
PAJOML HARD. FLORIDA ADENTRC
TRENTON
SC 14 (STATE HIGHWAY)
CLEMSON CMS (CLEMSON U CAMPUS)
SANDHILL EXPERIMENTAL STATION; CLEMSON U
RIDGETRAIL RD.
9315 RUTLEDGE PIKE MASCOT TN 37806
6855 MUDVILLE RD. E DM0 NO ORGILL PARK
HATCHERVILLE ROAL
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
PAGE 2
PRIMARY
STANDARD
MAX EXCEEDS
.129
.I2£
.123
.131
.13C
.107
.103
.092
.090
.118
.109
.110
.098
.128
.140
.110
.107
.1S«
.110
.118
.074
.098
.139
.132
.159
.135
.159
.120
.118
.125
.137
.123
.125
.101
.092
.134
.136
.09?
.107
.112
.072
.051
.no
.106
.105
.128
.115
.159
.199
3
1
D
3
• 1
0
0
0
0
0
0
0
0
1
4
0
0
1
0
0
0
0
4
4
3
6
4
0
0
1
1
0
1
0
0
1
1
0
0
0
0
0
0
0
0
2
0
2
16
Data Listing Report (2 of 3)
A.6-10
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
09/24/93
AMP600R1
STATE
ABBR
TX
TX
TX
TX
TX
V*
VA
VA
VT
WA
WA
UA
WI
WI
VI
wv
COUNTY
NAME
CHAMBERS CO
CHAMBERS CO
0£KTON CO
HARRIS CO
TARRANT CO
FAUQUUR CO
HANOVER CO
NORTHAMPTON CO
BENNINGTON CO
KING CO
PIERCE CO
SNOHOMISK CO
COLUMBIA CO
MARATHON CO
SKEBOYGAN CO
GREENBRIER CO
EPA AEROMETR1C INFORMATION RETRIEVAL SYSTEM (AIRS)
AIR QUALITY SUBSYSTEM
DATA LISTING REPORT
OZONE SITES CLASSIFIED AS RURAL AGRICULTURAL FOR 1986
CITY
SITE ID WC CODE CITT NAME
480710902
480710903
481210054
482010029
484392003
510610002
£10850001
511310001
500030004
530337001
530530005
530612001
550210008
550730007
551171002
540250001
00000
00000
00000
ooooc
00000
00000
ooooo
00000
04750 BENNINGTON
22045 ENUMCLAW
00000
00000
26725 FORT UINNEBAGO
00000
7297S SHEBOYGAN
00000
STREET
ADDRESS
ALBRITTON ROAD
EAGLE FERRY ROAD
QUARTER MILE RD OFF KMT 121
16822 KITZMAN
FAA SITE OFF ALTA VISTA ROAD
RT6S1 C PHELPS WILDLIFE MANAGEMENT AREA
RT.627 1 RAVEN RUN ROAD, PUMP HOUSE LOT
CHERITON POST OFFICE, BATSIDE 1 STOAKLEY
AIRPORT RO, BENNINGTON, VERMONT
WEYERHAEUSER MILL/MAIN OFFICE BLDG
FIRE DEPT «21/8102 304TH. GRAHAM
SNOKOMISH CO. FIRE DIST «2 95Z1 84TH ST
WP1L COLUMBIA, GENRICH, EE 1 MILITARY RD
WIS PUB SE«V CO, INT MAST IN BROS I CREEK
WPIL SHEBOVGAN. [NT COUNTY CK I HWY V
1ST
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
MX
.152
.230
.150
.150
.150
.106
.120
.112
.115
.120
.110
.090
.086
.082
.123
.105
PAGE 3
PRIMARY
STANDARD
EXCEEDS
6
10
2
4
4
0
0
0
0
0
0
0
0
0
0
0
114 RECORDS WERE READ FROM THE WORKFILE
Data Listing Report (3 of 3)
A.6-11
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
05/24/93
AMP600CU
EPA AEROKETRIC INFORMATION RETRIEVAL SYSTEM (AIRS)
AIR QUALITY SUBSYSTEM
AD HOC CLEANUP PROCESSING SUMMARY
CAGE 1
•ISN
00061484
N/A
N/A
00288067
RECORD TYPE
ADHOC-REPORT
ADKOC-ELEHEKT
ADHOC-FILE
•G'
USER
10
PKB
P«
RECORD/REPORT
NAME
A93B488
AMP60D
3EPORT
SELECT/REQUEST
DATE
09/24/93
09/24/93
ACTION
DELETED
ADDED
PROGRAM AMP600CU TERMINATED SUCCESSFULLY ON OS/24/93 AT 09:39:32.7
Cleanup Processing Summary Report
A.6-12
-------
AIRS User's Guide
Volume AQ5 Ad hoc Retrieval
Appendix A.7
Sample Ad hoc Batch Retrieval, Work File Only
Generate a work file that contains:
collection and analysis data showing reference
equipment descriptions
carbon monoxide (CO) (42101)
hourly reporting interval (1)
A.7-1
-------
Ad hoc Retrieval
AIRS User's Guide
Volume A Q5
OS/08/92
Report ttane: M> HOC
AIRS Air Quality SuUystem
Report Options
AMPoOOA
Criteria Ni
Enter Title:
Collection Analysis_
Choose at least one output:
_ 1. Generate a data listing report (Select format and headers below):
~ Single Spaced Double Spaced Double Spaced 2 Lines
~ Expanded Header* ~ ABBR Headers
_ 2. Generate a cross tabulation report {Select format below):
_ Single Spaced _ Double Spaced
X 3. Generate a workfile (Enter name below):
BFCASUD . coll . anal . aeob .
Enter Comments (optional):
This criteria retrieves the airs-geo-ada file coll-anals
record for co (42101) interval 1.
this criteria Mill be saved with the name: collanal
PF3=end
PF4*main menu
PFS-terninate
PF9*save criteria
Report Options Screen
05/08/92 AIRS Air Quality Subsystem
Uorkfile Output Fields
Report Name: AD HOC Criteria Name:
ABBR Length
1 . PCCA 5
4. DPIN 1
7. VFCA 1
10. RHTH T3
13.
16.
19.
22.
25.
26.
31.
ABBR
2. HTCD
5. AKYD
8. MDCA
11. UTSS
14.
17. ~"
20.
23.
26.
29.
32.
Length ABBR
3 3. UMCO
35 6. COLL
11 9. EQIP
3 12. COHV
15.
18.
21.
24.
27.
30.
33.
Total Record Length: 142
PFlHnsert
PF6=report
PF2=defeults
options PF7=beck
PF3=end
PF8=more
PF4=main menu
PF9=save criteria
Length
3
Jo
30
10
—
Page 1
AMP600A3
of 3
PF5=term5nate
Workfile Output Fields Screen
A.7-2
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
05/08/92
Report Name: AD HOC
ABBR Cord
AIRS Air Quality Subsystem
Select Criteria
AHP600S
Value
PCCA XE 42101
EOIP MB ~
ABBR Cond
IHCO ME 1
Criteria Mi
Value
PF3=end
PF7»back
PF4=roain menu
PF5=terwinate
PF9=save criteria
Page 1 of 5
PF6=r*port options
Select Criteria Screen
05/08/92
AIRS Air duality Subsystem
Sort Criteria
Report Name: AD HOC
A -
PF1 =
ABBR (A/D)
1 . PCCA
4. DPiN
7. V.-CA
10. RHTH
13.
16.
19.
22.
25.
28.
31.
ascending (default)
'insert
PF6=select criteria
ABBR (A/D)
2. HTCD
5. AHYD
8. HDCA
11. UTSS
14.
17.
.20. " ~
23.
26.
29.
32.
D * descending
PF3=end PF4=main
PF7=back PFB=more
AHP600C
Criteria Name:
ABBR
3. UNCO
6. COLL
9. EQIP
12. COHV
15.
18.
21.
24.
27.
30.
33.
menu
(A/D)
Page 1 of 3
PF5=terminate
PF9=save criteria
Son Criteria Screen
A.7-3
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
05/08/92
Report Name: AD HOC
CUTER:
AIRS Air Ouality Subsystem
JCL Parameters
AMP6000
Criteria Name:
JOB Name
Accotnt Code/UIO
Tine (NMH , SS)
Priority
Message Class
floater of Copies
Fora Huaber
Room/Bin Nutter
Mold Output (Y/N)
Printer Site Id
BFC colt
ASWD AIKSD
f
B381
B132
T
RKTOOO
Press ENTER to submit JOB
PF3"end PF4=main menu PFSatenainate PF6-previous function PF9=save criteria
JCL Parameters Screen
A.7-4
-------
AIRS User's Guide
Volume AQ5 Ad hoc Retrieval
09/24/93 EPA AEROMETRIC INFORMATION RETRIEVAL SWEK (AIRS) PAGE 1
AMS693CG AIR QUALITY SUBSYSTEM
AD HOC REPORT CRITERIA
CRITERIA LISTING
REPORT : NO REPORT - MORALE ONL* WORKFILE: KBASW).COLL.ANAL.GEOB
TITLE : COLLECTION ANALTSrS
COWEKTS: THIS CRITERIA RETRIEVES THE AIRS-GEO-ADA FILE COLL-ANALS
RECORD FOR CO (4J101) INTERVAL 1.
THIS CRITERIA HILL BE SAVED WITH THE NAME: COLLANAL
... OUTPUT FIELDS --- SELECT CRITERIA -- SORT —
ABBS LENGTH ABBR CONC VALUE ABBR (A/0)
1. PCCA 5 PCCA ME «2101 PCCA
2. NTCO 3 INCD HE 1 MTCD
3. UNCO 3 EQIP NB UNCO
«. OPIN 1 DPIN
S. ANTD 35 ANro
6. COLL 30 COLL
7. VFCA 1 VFCA
8. HOCA 9 MOCA
9. EQIP 30 EQIP
10. RKTH 13 RHTH
11. UTSS 3 UTSS
1?. CONV 8 CONV
TOTAL RECORD LENGTH: 1(2
Criteria Listing Report
A. 7-5
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
09/24/93
AMS693CG
EPA AEROMETR1C INFORMATION RETRIEVAL SYSTEM (AIRS)
AIR QUALITY SUBSYSTEM
AO HOC REPORT CRITERIA
UORKFILE LISTIMG
PAGE
BORKFILE : PKBASVD.COLL.ANAL.GEOB
RECORD FORMAT: FB
RECORD LENGTH: 142
SLOCK SIZE : 11360
FIRST
em
i
6
9
12
13
48
78
79
88
118
131
134
FIELD
DEFINITION
MS
9(3
9(3
XI
X{3 !
X(30)
X(l)
S9(4).9(5)
X 30)
X 13
9 3)
9(4). 9(5)
FIELD
ABBR
PCCA
MTCO
UNCO
OP1N
ANYD
COLL
VFCA
MDCA
EQIP
RMTH
UTSS
CONV
COMMENTS
PARAMETER CODE
METHOD OF COLLECTION COOT
UNITS CODE
DECIMAL INDICATOR GEO-B
METHOD CODE ANALYSIS DESC
METHOD CODE COLLECTION DESC
EPA METHOD VALIDITY FLAG CODE
MIN DET VALUE FOR METHOD
REFERENCE EQUIPMENT DESC
REFERENCE METHOD CODE
STANDARD UNITS CODE
CONVERSION FACTOR
AQS/GCS FIELD NAME
PARA-CODE
METHOD-CODE
UNITS-COOE
DECIMAL- INDICATOR
METHOD-DESC-ANAL
NETHOD-DESC-COLL
METH-VAL-FLAG
»ystefi-9ener«t«d
REF-EQUIP-DESC
REF-HETNOD-CODE
UNITS-COD£-STD-COLL-ANAL
UNITS-CONV-FACTOR
AQS/GCS FILE NAME
AIRS-GEO-COLL-ANAL-METHOO
AIRS-CEO-COLL-ANAL-NETHQD
AIRS-GEO-COLL-ANAL-NETHOD
AIRS-GEO-COLL-ANAL-METHOD
AIRS-GEO-COLL-ANAL -METHOD
AIRS-GEO-COLL-ANAL-METHOD
AIRS-GEO-COLL-ANAL-METHOD
AI RS-GEO-COLL-ANAL -METHOD
AIRS-GEO-COLL-ANAL-METHOD
AIRS-GEO-COLL-ANAL-METHOD
AI RS-GEO-COLL-ANAL-NETHOD
AIRS-GEO-COLL-ANAL-METHOD
Workfile Listing Report
A.7-6
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
09/24/93
EXTRACT
EPA AEROMETRIC INFORMATION RETRIEVAL SYSTEM (AIRS)
AIR QUAUTr SUBSYSTEM
AD HOC EXTRACT PROCESSING SUMMARY
PAGE 1
114 RECORDS WERE WRITTEN TO THE WORKFRE
* « * TKE EXTRACT PROGRAM ( ANPKB542 ) ENDED ON 09/24/93 AT 09:20.'01.3 * • •
Extract Processing Summary Report
A. 7-7
-------
Ad hoc Retrieval
A»S User's Guide
Volume AQ5
PISORT os SORT/MERGE: REL $.3-2560f PJCWTYPE/SORT /SORT
PLS052I SYSIN:
PLS341I: SORT FORMAT-CH.
PLS341I) FIELDS-(22.I,A.I.20,A.21.1,A)
PIS034I SORTIN LRECl • 131. RECFM » FB. BUSIZI • 11397
PLS104I MEMORY USED 1548K. RESERVED 8K
PIS313I SCO LENGTH IN 131. OUT 131
PLS034J SORTOl/T IRECL • 131. RECFN • FB. BUSIZE . 11397
PLS095! USABLE SORTUORK PRIMARY SPACE • 4.094.40C BYTES.
PLS096I NMAX ESTIMATE • 31,254 RC05
PLSOS2I END SORT PHASE
PLS0811 END SORT/MERGE. RCDS IH 14,770 OUT H.77C
PLS083I BU£S OUT 1.934.870
09/24/93 09:39:17
INCLUDING 2.047,200 IN HIPERSCACE
Sort Processing Summary Report
A.7-8
-------
AIRS User's Guide
Volume AQ5 Ad hoc Retrieval
09/24/83 EPA AEROMETRIC INFORMATION RETRIEVAL SYSTEM (AIRS) PAGE
AMP600CU AIR QUALITY SUBSYSTEM
AD HOC CLEANUP PROCESSING SUMMARY
REPCf
USER RECORD/REPORT SELECT/REQUEST
•JSN RECORD TYPE ID NAME DATE ACTION
00061484 ADHOC-REPORT PKB A935488 09/24/93 DELETED
N/A AOHOC-ELEMENT
N/A AOHOC.FILE
OOZ88Q6' 'G PK6 ANP600 09/24/93 ADDED
• • • PROGRAM AMP600CU TERMINATED SUCCESSFULLY ON 09/ZV93 AT 09:39:32.7
Cleanup Processing Report
A. 7-9
-------
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
Appendix A.8
Sample Ad hoc Batch Retrieval, Cross Tabulation Report
Generate a report to show:
• number of monitors in EPA Regions 1 and 2 by State
• how many monitors are NAMS (1), SLAMS (2),Other (3),
Secured (9), and Unknown (0)
A.8-1
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
05/08/92
Report Name: AD HOC
Enter Title:
MONITOR TYPE
AIRS Air Quality Subsystem
Report Options
AMP600A
Criteria Na
Choose at (east one output:
_ 1. Generate a data listing report (Select format and headers below):
Single Spaced Double Spaced Double Spaced 2 Lines
3 Expanded Headers ~ ABBR Headers
X 2. Generate a cross tabulation report (Select format below):
X Single Spaced _ Double Spaced
3. Generate a workfile (Enter name below):
8FCASUD .
Enter Comments {optional):
THIS CRITERIA GENERATES A CROSS TABULATION REPORT GIVING
A COUNT Of MONITOR TYPES FOR REGION 1 AND 2. "
This criteria will be saved with the name 'regrmon'
PF3=end
PF4=main menu
Pf5=teroiinate
PF9=save criteria
Report Options Screen
05/08/92
Report Name: AD HOC
ABBR
Row : STNH
Column : MTYM
Subtotal : RGCO
Value
1. 1
3. 3
5. 0
7.
9.
PF2=defaults
PF6=report options
AIRS Air Quality Subsystem AMP600A2
Cross Tabulation Output Fields
Criteria Name:
Length Header 1 Header Z Header 3
20 STATE NAME
2
Header
NANS
OTHER
UNKNOWN
PF3=end
PF9=save
MONITOR TYPE
RGN
Value
2. 2
4. 9
6.
8.
10.
PF4=main menu
criteria
Header
SLAMS
SECURED
PFSstertninate
Cross Tabulation Output Fields
A.8-2
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
05/08/92
Report Name: AD HOC
ABBF! Cond
RGCC< GE 01
AIRS Air Quality Subsystem
Select Criteria
AMP600B
Value
PF4*main menu
ABBR Cond
RGCD LE 02
Criteria Name:
Value
PF5=terwinate
PF9=save criteria
Page 1 of 5
PF6=report options
Select Criteria Screen
05/06/92
Report Name: AD HOC
ENTER:
AIRS Air Quality Subsystem
JCL Parameters
AHP6DOO
Criteria Name:
JOB Name
Account Code/UlO
Time CM«H , SS)
Priority
Message Class
Number of Copies
Form Nuntoer
Room/Bin Kurtoer
Hold Output (Y/N)
Printer Site Id
BFC REGN
ASUD AIRSO
_2 , _
2
F
Z
8381
B132
Y
RHTOOO
Press ENTER to submit JOB
PF3=end PF4:°na{n menu PF5*terminate PF6=previous function PF9-save criteria
JCL Parameters Screen
A.8-3
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
09/24/93
AMS692CG
EPA AEROMETR1C INFORMATION RETRIEVAL SYSTEM (AIRS)
AIR QUALITT SUBSYSTEM
AO HOC REPORT CRITERIA
CRITERIA LUTING
PAGE
REPORT : CROSS TABULATION
FORMAT : SINGU? SPACED
TITLE : MONITOR Tm
COMMENTS: THIS CRITERIA GENERATES A CROSS TABULATION REPORT GIVING
A COUNT OF MONITOR TYPES FOR REGION 1 AN: 2.
THIS CRITERIA WILL BE SAVED WITH THE NAM- 'REGNMON'.
OUTPUT FIELDS
ABBR LENGTH HEADER 1 HEADER 2 HEA:ER 3
ABBR
SELECT CRITERIA
CONC VALUE
ROW • STNK
COLUMN : MT»M
SUBTOTAL: RGCO
20
2
MONITOR
STATE NAKE
TTPE
RGN
1. RGCO GE 01
2. RGCD LE 02
3.
- SORT —
ABBR (A/D)
RGCD A
STNM A
MTrM A
- COLUMN INFORMATION
VALUE
1. 1
2. 2
3. 3
4. 9
5. 0
HEADER
NANS
SLAKS
owe
SECURE:
UNXNOtil
Criteria Listing Report
A.8-4
-------
AIRS User's Guide
Volume AQ5 Ad hoc Retrieval
09/24/9- EPA AEDWfTRIC INFORMATION RETRIEVAL SYSTEM (AIRS) PAGE 1
EXTRACT AIR QUALITY SUBSYSTEM
AD HOC EXTRACT PROCESSING SUMMARY
114 RECORDS WERE WRITTEN TO THE HORKFILE
* • « THE EXTRACT PROGRAM ( AMPKB542 } ENDED ON 09/24/93 AT 09:20:01.3 • * *
Extract Processing Summary Report
A. 8-5
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
PL50RT OS SORT/MERGE RE.L 6.3-ZS6QE PKBHTYPE/SORT /SORT 09/21/93 09:39:17
PLS052I STSINt
PLS341I: SORT FORMAT-CH,
PLS3411: FIELDS-ttZ,!,A,l,ZO,A.!l.l,A)
PLS034I SORTIN LRECL • 131, RECFK « ft, BLKSIZE • 11397
PLS104I MEMORY USED 1S48K, RESERVED 8K
PIS313I RCD LENGTH IN 131, OUT 131
PLS034I SORTOUT LSECL • 131, RECFM • FB, BLKSIZE • 11397
PL5095! USABLE SORTYORK PR1HART SPACE • 4,094.400 BYTES, INCLUDING 2.047.200 IN HIPERSPACE
PLS096I NMAX ESTIMATE • 31.Z54 RCDS
PLS08?! END SORT PHASE
PLS08H END SORT/MERGE. KDS IN 14,770 OUT 14,770
(>LS083I BYTES OUT 1,934,870
Sort Processing Summary Report
A. 8-6
-------
AIRS User's Guide
Volume AQ5
Ad hoc Retrieval
09/24/93
AMP600R4
EPA AERWETRIC INFORMATION RETRIEVAL SYSTEM (AIRS)
AIR QUALITY SUBSYSTEM
CROSS TABULATION REPORT
MONITOR TYPE
PAGE
STATE KAME
CONNECTICUT
MAINE
MASSACHUSETTS
MEM HAMPSHIRE
RHODE ISLAND
VERMONT
SUBTOTAL
RGN: 01
MONITOR TYPE
NANS SLAMS OTHER SECURED UNKNOWN TOTAL
33
7
61
6
15
2
156
66
96
101
23
41
£62
346
671
80
23
127
1 2607
3 S31
3 1255
0 £02
0 424
0 189
3361
955
2066
690
465
359
124
488
1809
5508
7936
NEW JERSEY
NEW TORK
PUERTO RICO
VIRGIN ISLANDS
35
76
14
C
120
560
54
a
417
758
107
20
1370
2690
526
7S
1942
4084
701
107
SUBTOTAL
RGh: 02
125
742
1302
4665
6834
TOTAL
.'49
1230
3111
10173
14770
Cross Tabulation Report
A. 8-7
-------
Ad hoc Retrieval
AIRS User's Guide
Volume AQ5
09/24/93
AKP600CU
EPA AEROMETRIC INFORMATION RETRIEVAL SYSTEM (AIRS)
AIR QUALITY SUBSYSTEM
AD HOC CLEANUP PROCESSING SUMKA8T
PAGE 1
•ISN
00061484
N/A
N/A
0028806?
RECORD TTPE
ADHOC-REPORT
ADHOC-ELEKENT
ADNOC-FILE
USER
(0
PK8
PKB
RECORD/REPORT
NAME
A935488
ANPEOO
REPORT
SELECT/REQUEST
DATE
09/24/93
09/24/93
ACTION
DELETED
ADDED
* * PROGRAM AMP600CU TERMINATED SUCCESSFULLY ON 09/24/93 AT 09:39:32.7
Cleanup Processing Report
A.8-8
------- |