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

-------