United States
Environmental Protection
Agency
Office of Enforcement and
Compliance Assurance
Washington, DC 20460
March 1996
&EPAI IDEA Basic Training
Course
Student Booklet
Integrated
Data For
Enforcement
Analysis
-------
Disclaimer
The information and examples contained
within this manual are strictly for training
purposes, with no basis in fact regarding any
actual or ongoing enforcement initiative(s).
The "screen shots" and examples that appear in
this manual are only intended to illustrate the
uses and functions of IDEA and do not contain
enforcement sensitive information.
-------
Preface
The IDEA Basic Training Student Booklet is designed to provide
step-by-step instructions for individuals who want to become IDEA
users. This booklet includes instruction on IDEA processing and
the NCC/TBM (mainframe) environment. Previous experience with
the mainframe is not necessary. In depth information about the
topics presented in the IDEA Basic Training Student Booklet can be
obtained from the IDEA User's Guide.
The IDEA Basic Training Student Booklet was originally designed
to accompany the instructor-led IDEA Basic Training Course. It
has been revised as a self-paced workbook.
Additional information can be obtained by contacting:
EPA's Office of Enforcement and Compliance Assurance
IDEA User Support and Training
401 M Street, SW (M/C 2222-A)
Washington, D.C. 20460
Telephone:
9:00 am - 5:00 pm, Eastern
Monday through Friday .
202 564-2475
-------
Table of Contents
Student Exercises . 1
Logging on to the Mainframe . . 1
National Computer Center Menu System 1
EPA TSO Logon Menu Screen 2
IDEA Welcome Screen 3
Running a Menu Interface Query 4
Interface Selection Screen • 4
Main Menu Interface Screen 5
Location Menu 6
Pollutants Menu 9
Noncompliance Menu 13
Three Search Types 16
Input and Report Selection 16
IDEA Standard Report Formats 17
Query Status Screen 18
IDEA Report 1A in Browse Mode . . . 19
ISPF Commands for Navigating IDEA Reports 20
Print/Save Parameter Screen 21
Running a Keyword GO Names Query . . 24
Interface Selection Screen 24
Input Library Selection Screen 25
Member List . 26
Member List Commands . . 27
Edit Screen 27
Name Selection Menu 28
Name Selection Menu Returns 30
GO Names Keyword Query 31
Report Syntax and Query Execution 33
Query Status Screen 34
Report 1A in Browse Mode 34
ISPF Commands -35
Using Your Home ZIP Code in a GO Names Query .......... 36
Editing a GO Names Query <•. .......... 37
Interface Selection Screen 37
Input Library Selection Screen . 38
Member List Selection Screen 39
-------
Edit Screen . . 40
Name Selection Menu 41
Name Selection Menu - Counts Returned 41
Name Selection Menu - Return Names Selection . 43
Edit Screen - Names Returned 44
Edit Screen - Block Copy Line Command . 45
Edit Screen - CUT Command 46
CUT Default Values Screen . 47
Member List Screen - Creating a Member 48
Edit Screen - PASTE Command 49
Edit Screen - Exclude (EX) Command 50
Edit Screen - Delete Not-Excluded (NX) Command ...... 51
Edit Screen - FIND ALL Command . 52
KODAK Facilities Retrieved 52
Copy LOGIC Member 53
Executing the GO Command . . . 54
Query Status Screen . . . . . 55
Summary of GO NamesCommand 56
Running a Keyword GO Menu A Query . . . 57
Member List Screen - Create Member 57
Edit Screen - GO Menu A Command 58
Main Menu Interface Screen . 59
Noncompliance Menu Screen . 60
Main Menu Interface Screen - Noncompliance Keywords
..... 61
Input and Report Selection Menu 62
Edit Screen - Noncompliance Keywords 63
Edit Screen - Block DELETE Command 64
Edit Screen - Noncompliance Keywords 65
Edit Screen - COPY Command . . . 66
Query Status Screen 67
Summary of GO MenuA Command 68
Combining GO Names-and GO MenuA 68
Summary .69
Logging Off . . . . .v.. .70
Log and List Data Set Screen . . i . 71
-------
Student Exercises
Logging on to the Mainframe
IDEA is accessed through EPA's National Computer Center's (NCC) mainframe
computer. Logging on to this system requires a user ID and a password. Once logged
in, you must.indicate which facility or program you intend to use.
Indicate that you want to go to TSO by typing T at the COMMAND line as shown
below:
HETttfttif . IJ.i. ft-Bttttt'OA ftgancy $ata: 67/27/93
**ryu System 14:36:3*
Terminal: T231S31t
toffBodf; #2S0lC»fr
entff- set)ott or conttand and than pros* EKTElt,.
1» tMFORHATIOK ttetrt tt*i User McftO*
2. SYSTEM MENU System Selection Mnu
3, MAit, SPA Etact-romc Nail for S270
*m.ICATI0W Application H#nu
5. iNTEK-Aeenor lr>tar-A««n£Y Application* m*i
6. MJBUC fc A«*** jjapHsaticrw Nanu
WMHN6;. Dm uu of tills comput«r 1« for official towrwwnt business only,
Unauthorized use of this, eoaputer fs * cri«in»l offense under Hti« is
Umted States code, 8«ctt«n Ml, arat wy syfcjsct violators to • fine of
tp to 510,000, or l^risorwfcnt of up to 10 years, or both.
COrattand »**> T
Optional Quid; logon - USCfHB «»«»
• PAS8W3W #»»>
fVFtWfelp FS/?t7«a«fraah
Figure 1. National Computer Center Menu System
The menu system will then present you with the EPA TSO LOGON MENU SCREEN
(see Figure 2). At this menu screen, you identify who you are, what account is to be
billed for your computer session, and set several user parameters. Once entered, the
computer establishes a profile and "remembers" all the parameters for the next logon
session. Figure 2 indicates the required parameters.
Student Booklet
1
-------
EPA2 T«VE LOGON —TOVKm
Wt/Pftt «•» twtp PT3/P-F1S »»> Logoff PM **• Attention M2 =»> Resfca*
EHT5R LOGO# WR/W6TER.S OaOW: 8ACP iOGON PAftAMETEBSt
OSE1UO «»« ***
PASSWORD "i» ******** NEW PASSWOMJ *«»
P80CEDURC *»«> SfPATSO C3H3UP IBCIfl >»»>
ACCT »»* «*¦» ****
nxAs w*» j^sYf sj# Mwct *«»» ****
size ««> svsaur cm **•»
COKMM® »»«>
ENTER AM »6" SEJHBE MC* OPTIOK OESlftCP BELOW
-WXAiL -ttOHOTJCS -WJSUAKART 'CAHCtl
Figure 2. EPA TSO Logon Menu Screen
The required fields are:
1. User ID: three characters; issued by TSSMS Office.
2. Password: six to eight characters with at least one number.
3. Procedure: use SEPATSO
4. Account Number: four characters; issued by TSSMS Office
5. FIMAS: five characters; use IESYP
6. Bin Number: four characters; from your ADP Coordinator,
or use M**» where *** is your User ID.
The first time you logon, you must change your initial password by tabbing to the
NEW PASSWORD input field and entering a new password. You will be asked to re-
enter this new password to confirm it.
For any logon session, you have only three opportunities to enter your password.
After the third attempt, your user ID will be revoked.
2
IDEA
-------
When you have successfully logged on, you will see a series of NEWS ALERT
messages followed by the TSO READY prompt.
At the READY prompt, type IDEA. Press < Enter >. The IDEA WELCOME
SCREENwill appear (see Figure 3).
Mnu
CONNftNft *«*> SCSOU tma> CS£
* > *
•
1111IX1
DOOBft
EEEKE
AAAA
*
*
I
0
B
t
A A
*
«
£
&
D
€fE6
AAMAA
*
*
»
&
e
A A
*
IMHJI
aa
Ml
ttesEf
A k
*
•• :i"j: :M £ •: - •: & * '< *£% i;:: < :•&& >v $':3 :•<;-*•
* Enter on* of the foiU*St* or th* COMKAW Hi* *
j; SiK-ji; j; s •;;; % j^SssisS;;^ i s siii i Kit® WMii isiSIS' ISii ii i: '&&%&&$;
« 0 ' SfctsbM* Status H - fc«tpnn» info 9 ~ M»«f 9€*
Figure 3. IDEA Welcome Screen
To move to the INTERFACE SELECTION SCREEN, press < Enter >.
Student Booklet
3
-------
Running a Menu Interface Query
The easiest way to build a query is to use the IDEA Menu Interface. This interface
allows users to scroll through different categories and select criteria to be used in a
query search. This section will focus on navigating the IDEA Menu Interface.
Queries developed using the Menu-Interface can range in scope and complexity from a
broad one-category, one-database search to a very specific six-category, eight-database
search.
To access the Menu A Interface, type A at the ENTER INTERFACE OPTION prompt
which appears at the bottom of the INTERFACE SELECTION SCREEN (see Figure 4).
IWQlMCg StlECnt* SOtte*
!P£A currently supports tw Interface which to construct snd
run queries. They in described briefly betdy.
- If - KSVU0&~MUK Interface: »iSW-Uk«« fuU-powar later fee*;
» MaxImjR ft«x(bU1ty anrf compiete database varlatot e access,*
» Uw* tft* POP text editor to coratruct fceyw$r#v#lti* queries;
** JntarfwMi for running facility nam seerches <*00 MACS* J.
A - MENU A Interface*. » tfses selection mnus «nd pop-up Kinefov&;
» Proritl« c$rt$ort/v»lUe U*ts ftm whith to build
> » Swiir to but i«m flaxMsillty tb»r>
SQTf; la order to uu this interface, ym (aust ba ®bt« to u&«
your taraiftfrt's Pf Key equivalents for "End", "Up*, and Domt^
(Sm the 10EA ttslpl
-------
Date: 07/27/93
Craate/Add a query by altering mi
^ LocitJon
Pottutaftta
^ Industry
w #onconpU*rtce
~ £nf (see Figure 6).
Student Booklet
11
5
-------
UBte: 07;27/93 IDEK User;
Create/ Add a query byenterfng an *8" r*xt to:
Location . ^ 'Hor»5 * ' .
^ ?CitUt«Vt9
~ Industry
^ noncompliance
__ Enforcswent
lacUity Status
__ Run Guw'y
^ ciw tmry
_ Sflve Query
R»triev« Query
ffKVIl; H£U>.
*FK3/!5: EJ» •
PFK7/1Vi £»?« Up
PfKB/20: <>»(• Ocwn
Figure 6. Choosing the Location Menu
Selecting LOCATION will prompt a new screen to "pop-up" on top of the Menu
SCREEN {see Figure 7).
Date: 07/27/93 1PM Uwr: tfW
t rirri shaft CT/#>i N clwir?" (VN»: W -
Cr*»te/Add a qt*ry t ftata Elaw&nt* Vatuw
S location t -
tutant* I
3 Jf*k»try f tart** Jt* ^ {8«bb« «l MbIohrJ -
ttonccapHance * ' # (IrttKvidint
WiWBiMM sllf v:;- ;:i ^
?: ;;;; ;;r;:;i; ^ 4:i ;l s M ? t
* /
. ,v-^.' ' M4*< ^ I 111 I •: ¦ .... -.V -
^ Xu^
-------
Up to ten states can be selected in the LOCATION menu. To select a state, place the
postal abbreviation on the underscore line after STATE =.
Move the cursor back to the FINISHED? (Y/N) prompt using the key and
type Y. Figure 8 illustrates what your screen will look like once a state has been
selected.
0*t#i «t/50/« ' JDEA Uwri «?&
: ,r 'ft
t Mrr»sfc«*7 iVH)i H tY/Ws i
Craate/Asfc! a query i &at» ELeoeotft ' Vtluet
a location , t
_ PoUtftaftts- 4
~ industry + fusion t« _ - ^ <*««* «f'K«8lorw>
^ toncompif«oce < * „
Rut Query
; Clw «u»ry
S«Vt outry
^ Retrieve Query
ȣti>
PH3/1SJ *»
vmmi p«9« up
PfX0/2th Page Horn
Figure 8. State Codes
After you complete your location selection and exit the LOCATION Menu, the MAIN
MENU INTERFACE SCREEN will look like this:
Student Booklet
7
-------
Date: 08/30/93
IDEA
User: UiO
Sreate/A »*
Location:
. St»t«(«>
ftun Ouery
^ Clear Qvery
^ S4v» Ouaryr
~ tetrt«v« Quflry
«*?/«; HCLP
P«a/15: EW
PF*7/»j Paj* Up
PKB/ttOi Page Down
Figure 9. Main Menu Interface Screen
The next step is to select the POLLUTANTS category by placing an S on the
underscore next to POLLUTANTS and pressing < Enter >. This will prompt a new
menu to appear (see Figure 10).
The pollutant we are looking for is lead; the source of the data is the Toxic Chemical
Release Inventory System. Figure 10 shows that a question mark can be placed in the
CHEMICAL CODES field to prompt a list of chemical codes to pop-up (see Figure
11). You may scroll through this list, using PF8 (down) or PF7 (up), and < Tab > to
the underscore next to the appropriate code. Chemical codes can be selected by
placing an S on the underscore and typing Y at the FINISHED? (Y/N) prompt.
8
IDEA
-------
D»t«s 07/27/93 IDEA uwri UiO
t Mm'atwtf? WW; K CUar? «/*): N I
Cr«ate I Systaw Data Eltawna V«t«a !
— tOC t -~ - f
S Pol ( AFS (Air) Pdltutaftt Codas « - .___ '
__ tnd f Pollutant Classification * ^ I
__ (ten \ At tain/Non-Attain * I
6»f t Pollutwt Coapt, Status « 2 « m-Z !
Fac t PCS (WaterJ Haas^/Viot. furiWHft « . -. .. J ¦
* Violation Types * ___ " |
t ftCRIS {Solid Waste) Uasre Codes • ^ I
I Wa*U Amt. > IK .. . . 5
f , ' % Uaet* PratM* * • f_i__ j
i T6t {Toxic RaleaM) Oiemtcal Codes> ® 7 *
Rt*i f ReLeasa Mediun = I
_ Cle f ' Reporting Tsara » \ I
- — iaV ' fletaaae Amount tlrv lb#, > IN - - »
_ S«t — r-——-*
Pftt/13; HttP ~ . '
PHOA53; €W> . ,
PFK7/H>: P»iJ« Up . - k :
PfK$/«»f Psw 0«« „
Figure 10. Pollutants Menu
Compare the length of the NEXT VALUE line with that of an actual data value in the
pick list. If the VALUES line is longer (as in this case), you can type a word(s) for
which you want to search on the VALUES line, IDEA will display the TRI chemical
codes that contain the word(s). In this case, type LEAD as in Figure 11.
Bfftei 07/29/95
f
traate 1
^ toe 1
$ Pol t
— lnd t
i
PaC ~
""" t
%
4
V ' I
' Sun »
ILcu t
*
— ***''
PfKt/11:
PfKl/15;
PFK7/19H
P«B/W;
ftiV
Syatsaak
AFS
PCS
P»3* l)p
Pag* Oowt ...
thesical Codes
Codas and nams of e*i«#fi:aU -or eh«mic«l categories
f towtarf? Vatuei tE«J_
S Cod* ttacriptfot'
00007507D ACETMJJ£KYW'
000060355 ACEIUtDE
GC0O67641 ACET<*£
oeooTsosa AC£TONmiu
000107G2B ACROteitf
oooo79o&t u:nu»m
QQ0G7WO7 ACRYLIC ACfB
0Q010T151 ACRtiOtiTWU « -
000309602 ALB*IK
000107186 *U?t AlOOHOL
woic7!9i mui ato«iog
0001HJ27 AlPHA-«A(^t«n.WlHE
007429905 AUMliK* (fUK Qft 0U£t)
0G13U&) ftl^VUN OXJCE C?!5ftOUS FORM>
00766407 mt0(tU
tmxtiw MiTHAtE (30LU?iCN>
Figure 11. Chemical Code List
Student Booklet
9
-------
Place an S next to LEAD and LEAD COMPOUNDS (see Figure 12). Press
< Home > to get to the FINISHED? prompt and type Y. Press < Enter >.
Dates 07/29/93
| ChcMical Code#
I Hnlsfcad? {Y/k i Codes anct fumes of cfta«ricat» or clwaicM cat*goH«s
— J
»
Create t Systewt
, „ toe 1 —¦»—
S Pot f AfS
mi/13: reup , .
PFK3/1S; €K0
9tt7f%9i foe*: Up »
PfK&/20: *>»»• »wn
Fin>ah»d? Cf/ti); * mxt V«tu«:
S Code Description
1 --
I s
I s
*
I
007439921 UAD
K429 LEW COHWllWS
Figure 12. Lead Chemical Codes
After you exit the CHEMICAL CODES Menu, the codes for Lead and Lead
Compounds will automatically be entered into the POLLUTANTS Menu.
Next, provide the range, in pounds, of TRIS lead release. As illustrated by Figure 13,
to select those facilities releasing greater than 10000 pounds, supply 10000 as the low
end of the range, and 99999999 as the high end under RELEASE AMOUNT (in lbs.).
10
IDEA
-------
Data; 0tmm IW?fc Unr:
pDilUtarttB
» Finish**# ami * Cl«»r? «/IO: tf mPf t25
Cr«#ce t Systfems S«t» £t events Values
__ Loc I
a ! A#$ <*irj PMiutwn is«Sfe# ¦ -
^ tnd I ^olfcuttwi CtwisHlc*t*on « ZZZZZZ '
^ 4ton 1 Att*Sn/Vori*ktt*ln » __ _ _ _
€nf t , MUtton* Status * ZZZZ
Me f PCS (Water) Hess./Viol* <*#fan«e** ¦
* Vlp1«i«n Typ«» ® ¦
i IKRIS <8oUd ««tei Waste Code* «
J Va&te Amt. IK '
¦M :'::C; :« ': Hi H ? i^®*"- i-f^&^iii: li '-t? £*:'¦'5Si0 iiS &v:
t T81 (toxfe Ch«»?c»l C«tee * i52o 00743992!
__ RtJl 1 RclsBat Modiua * _
_ Cle 1 Report {ns T«w» « ZZS~Z~. LZ-
_ Say t Release Aactnf tin tl*.> IK 10000 99999999
_ Ret » — — 1
«K1/tt{ H£LP
P*K3/1St Em.
#>1*7/19: P«9« Op .
PfKS/J&i 9t>g» Bom
Exit the POLLUTANTS MENU SCREEN by pressing to get to the
Figure 13. Pollutants Menu
FINISHED? prompt. Type Y and press < Enter >.
Student Booklet
11
-------
Figure 14 illustrates what your screen should look like after you exit the POLLUTANTS
menu.
est*; ot/som
JOftl
Usar;
Create/Add a query by entering aft "S* next tot
Location « Wore: *
Tel tut Ants : :: YOU: hav« treated * quary, using the following cj*i tafia:
— Industry-
tondonpt f$nc*-
^ Enforcaiaant , . St»tai ^ W
fat!lity Status
(wn «u»ry
^ Clear flwery
Save Oyery
^ ftatriava Quary
*f*V13: IfftP
9fKi/15: £W
PFX7/19: faga Up
PFK6/20: *>*9» Pwn
Location:
. St»tai
tolUitasvUt
« (TBI) Cfwwlcat Hme
. (titi) to***:
W420, 007439921
10000 - 99999997
Figure 14. Main Menu Interface Screen
The next step is to tell IDEA to limit the search to "Significant Noncompliers." Select
NONCOMPLIANCE from the Menu Interface, and the NONCOMPLIANCE (NC)
menu will appear.
12
IDEA
-------
P$t«: £>7/27/93 JDFA user: «JD
^)fortcoraplf«r»C6 ; « s
Create/A I l*wU) System Oata Clement Values t
„ t«e«t t - - I
^fcilu t 2 or tore Ail Z at tore Laws: RC , $lfC {
^ Endts t CM AFS In vfoUtion "* ~ i
$ K«nc« f Sijrrif leant V/ofcatlan Status ^ {
_^€nfw + EPA Compliance Status * 3 ~ , 1
— Cacil 1 S<9Bi#ic«ftt Ka®1 * 1 , Z '
I Mt PCS R«portabls MoocwpM ewce ~ ~ '
I $i pntf fcarvt KortcotapJiaocGi ^ J
1 Cyrrmt Veer 1st Su*rt«r ¦ 3«..»«,.» J
t KoncaapUanc*: 2nd &i*rf«r « ~ ~ |
t Jr«g» Bonn „
Figure 15. Noncompliance Menu
To select significant noncompliers (SNCs), move the cursor down to each individual
media section, i.e., CAA, CWA, RCRA, FLFRA, TSCA, and EPCRA, and select the
line indicating significant violation/SNC status. Figure 16 illustrates this step.
Student Booklet
13
-------
Ottet 97/HStfS
Cr«ate/A
^ toeat
_ wt u
— T«**»
s tteoco
enfor,
_ N«U
_ *ufi «
ZZ Clear
Sa*t
Z ***"
p rxvi3{
PFKS/tti
pea/m
PfKB/Ztli
t Hntsfxvft ;
t Lault) Syttem
'¦ XOFA
•«¦—•¦« HahconpKaoee <8C>
* Clwt X
&at4 El«ftent»
UsWs UIO
Yslues
2 P* ~
Unresolved Migh ft-Sority Violsrior® e
FiFRA: HC _ SWT .*
TSCA Y HC SKC *
EPCSA (S15>: KG " SKC i
Figure 16. Significant Noncompliance
Exit the NONCOMPLIANCE MENU SCREEN by pressing < Home > to get to the
FINISHED? prompt. Type Y and press < Enter > .
14
IDEA
-------
The MAIN MENU INTERFACE SCREEN now looks the same as Figure 17.
P#tej 09/Z2/95
IDEA
User; #13
Create/Add * query
_ Location
_ Peltutanti
_ Industry
KoncoMplfanc«
Enfwc«wot
^ fac\ISty Status
«ufery
^ Citar Ouery
Saw Ouery
~ R»tri«vfl query
P*KV13s WLP
P*KV15;
P«?/19s Pag« Up
FFKe/28: P«se Own
fey entepfog an next to*
Mora: *
fOu h«v« treated a query, using tttfe foUo»fir>Q criteria)
koo, mmni
190QQ - 9999999?
Location:
. Stat«i VA, !*>'
P*»ltutam«j'
„ CTSI) Chanleai Km;
. CtftU teountj
HonegtrpHaneaj
. tAFS) 8 significant Soocoaplianc*
. CttC#> OnresOW«t tion toapH«nc«,
* C*tCO> TCSA - Significant Won CtMpttancs
r tKCO EPCM * Significant Hon ConpUans*
Figure 17. Main Menu Interface Screen
At this point, you've completed building a query. To run the query place an S on the
underscore next to RUN QUERY.
Before you continue, it is important to understand the difference between linked search
and nonlinked searches.
A LINKED search allows you to find information about a facility in a program office
database as long as the program office has reported the facility to FINDS. If the
program office has not done so, information about the facility contained in its database
is accessible only through a nonlinked search of that database.
A NONLINKED search is appropriate if you only want information from a particular
program office database. Choosing simultaneous LINKED and NONLINKED searches
will ensure that you get both kinds of data.
Student Booklet
15
-------
Figure 18. Three Search Types
Type
Description
Linked
Locates data about all sites with
specified characteristics through FINDS.
Nonlinked
Locates data about all sites with
specified characteristics in individual
program office databases.
Linked
Nonlinked
Locates data about all sites with
specified characteristics through FINDS
and in individual program office
databases.
When you command IDEA to run your search, a pop-up box called INPUT AND
REPORT SELECTION will appear. This screen provides you with the opportunity to
choose a linked or nonlinked search and to pick up to four different Standard Reports.
Notice that the defaults are set for a LINKED search and REPORT 1A (see Figure 19).
0«t*> 03/03/04
IOTA
UMf: yio
ft query fey »n
_ Location
froUutaftta
3 industry
Ifencttplfftrtte
iMli Znfwemtnt
^ facility $t*
*$» mst tin
IIP PI ? i I ? I lisp U PI'i ¦! -! P$;l
fou cr«ete<* * query, -ua the faitcrltsrUt
Ucati Ofti
. Stet«;
VA, M»
t Sun Ouery
w. Ctw Query I
^ A*Y* Ouery t Rtporr
~ *«rtriev« flu* 1
PfKI/13; NEtP J Y 1A
P«3/15» «W t $ 18
PfKT/ih ^ 2
PfKB/20: 4>ae» B t ^ SUWWK
input tnrf Report Selection
Input
V UNXEB tnt49ri»t«d 0 m
( ^ KOWJdfgO ton* attd Dam
«epi}*-t W.
8«port
Report 2
Swmry *»port
t «1
~ W9
t
~
*
t ation
t lance
* tones
twet
Figure 19. Input and Report Selection
16
IDEA
-------
After choosing a linked, nonlinked, or linked nonlinked query, the next step is to select
the format for your report. Figure 20 lists and describes the four different types of
reports that IDEA can generate.
Figure 20. IDEA Standard Report Formats
IDEA Reports
There are currently four standard IDEA report formats: 1 A, 1B, 2, and Summary
REPORTIA
A brief report of individual facilities. Organized by the linked database, IDEA displays
the facility name and database identifier, location and other business information,
noncompliance or violation status, and enforcement information.
REPORT IB
A more detailed presentation of information on individual facilities, including historical
and programmatic data such as dates and results of inspections, specific toxic
. substances reported, and details of enforcement actions.
REPORT 2
A linked docket table that indicates whether each facility is listed as a significant
noncomplier or high priority violator.
REPORT SUMMARY
Provides total facility counts by program and EPA region; sum of facilities that are in
compliance and not in compliance by program and total numbers of enforcement actions
by program, and total toxic substance release information for the selected facilities.
To select a report format, move the cursor to the underscore mark to the left of the desired
report and type S. Once you are satisfied with the report format and search criteria, press
< Enter > to instruct IDEA to run your query. For example, if you want a detailed report
on your search, type S on the underscore mark to the left of Report IB and press
. After the IDEA completes its initial facility selection, the QUERY STATUS
SCREEN shown in Figure 21 will appear.
Student Booklet
17
-------
CCtMftMO ««>
SUES? STATUS $CHB#
10»4?jML79 - 2 ftcHltf* selected a*f In ft«»
Cotinti (percentage*.), by -database, Of facilities- but
excluded because they wre not praswH in F1WS:
TW 15 C 1>
PM ?T C 10)
«£R H C t>
H* 0 ( 0)
AFS 315 ( 2?>
#C0 452 <
Press £MTER to continue, END *0 ftttitt) Xt frt«rt
Figure 21. Query Status Screen
The QUERY STATUS SCREEN shows the number of facilities that were selected by IDEA,
based oh your selection criteria and the linked/nonlinked input qualifier.
If a facility count of zero is returned, pressing < Enter > will take you back to the Menu
Interface where you can modify your query. Similarly, if the facility count is higher or
lower than you expected, pressing the PF3 key or typing END at the command line will
return the cursor to the Menu Interface where the query can be modified.
18
IDEA
-------
If a facility count other than zero is returned and IDEA reports were selected, pressing
< Enter > will take you to the BROWSE SCREEN where you can view the reports your
query has generated. Figure 22 shows an example of IDEA Standard Report 1A. This
report contains information about facilities which meet our query criteria.
8R0WS£ - H- In Proarass MX 000025 UNE 06000000 COt 001 080
tmttm
eomwrtd ffllMTO to print, or SAVf to uv» to
»¦»«*«¦»«*«»«*«««««~«»»»«»»»»*«~»«~ jgp. Qp 0ATA «*»*«»)» »«»»»«»«~ «*>***•+***+****¦¦»+
1 U.S. PfiOtEC
WTKKATgj DATA F*CJUT¥«SP£C1HC CO
FtlftS Id: HM161S?058$ ftt. Katot MX CREEK figHKJtt Zm**t City; 8
, A<*dres&; n 5KAUW0QD * tOOO KEHBO $B> *fj>i
CfYtl Socket Cm&n Ham Cft&« Kudber Type Ca*» t«u Ovratt S
COX CWJElf RfcttVIMfi CO fl3-89-0110 16 TSCA
?M W: 2?22«CXC*fcTD«K futility *i>n*i tQK «E6K «efif>SttB SO.
Yd Cttent Count Air n hit Water UG Inj, tarx* «JtW Oft-
t9«e i 255 0 ^ $ O « &
&UHS KtWbef: 1615705® Mttast CO* Cttflt, COKPAMi 8«arta* ta $1K
Figure 22. IDEA Report 1A in Browse Mode
Student Booklet
19
-------
The following commands are used in navigating IDEA reports.
Figure 23. ISPF Commands for Navigating IDEA Reports
Commands
Descriptions
UP
PF7/PF19
Scrolls up by the amount set al the SCROLL prompt, or by the
number of lines entered al the COMMAND prompt
DOWN
PF8/PF20
Scrolls down by the amount set at the SCROLL prompt or by
the number of lines entered al the COMMAND prompt
LEFT
PF10/PF22
Scrolls left by the amount set al the SCROLL prompt or by the
number of lines entered at the COMMAND prompt
RIGHT
PFl 1/PF23
Scrolls right by the amount set at the SCROLL prompt or by
the number of lines entered at the COMMAND prompt
F.ND
PF3/TF15
Saves and returns to the previous screen
SWAP
PF9/PF21
Moves the cursor from a position in one screen to the same
position in another using the split-screen mode
SW
Switches from once specified report to another.'
MANEUVERLNG THE CURSOR
Arrow keys,'
• Use arrow key? for all directions.
~ Use key to move to the next input field.
• Use to move to the lop-left input field.
M(ax) t- UP
M(ax) * DOWN
I M(»x) + RIGHT
Scrolls up to the first top line of a report;
Scrolls down to the last bottom line of a report;
Scrolls to the right marge of a report;
Scroll* to the left marge of a report
20
IDEA
-------
To print or save the report, you must issue a PRINTO or SAVE command on the
command line. The PRINT/SAVE PARAMETER SCREEN will pop-up. See Figure 24.
WCMS6 - Report: 1*
CONHAW ««> priftt<3
in MX 000025 LIKE 00000000 COt 001 080
—- PHnt/S#v«> P*raa»t«r Scrwm •-
from line to line
fum }
Addres
CJvti 6
TBI »*
for {rfitwjf#
Bin
De«tir»tiorv »«*~ K01&
No» of copt«s »«*¦»»
Tor saving enter DStt or &$Kme«befn&fte)
Yd Cfcem Count Mr frt Air W6W U0 I«|» L«nd KITV off-
1992 I 25* & 5 O $ &
WS tenbert W570585 Matfci $
-------
You must supply the following parameters at this screen:
1.
From line no.
to line no.:
Starting line number; for the entire report, always
use 1.
Ending line number (MAX).
For Printing:
3. Bin:
4. Destination:
5. No. of copies:
For Saving:
Four character code indicating location for the
printout.
The printer ID where you want the report to go;
default is the HOLD queue.
Default is one copy.
6. DSN or DSN(member)
The dataset name under which to store the report;
the default is UIDACCT.***, where UTD is your
User ID, ACCT is your account, and *** is the
name (up to eight characters) you type in at the
prompt. If you want the report saved to your
library, type: QUERY.SPECSC"**), where.*** is a
member name that you provide.
Successfully completing this screen will return the cursor to the BROWSE SCREEN with
a message in the right-hand corner stating either: "PRINT COMPLETE" or "SAVED."
22
IDEA
-------
To return to the Menu Interface
To return to the MENU INTERFACE SCREEN, press the PF3 key, or type END then
< Enter > at the command line.
To save the Query
To save a query, select the SAVE QUERY option off the Main Menu, then enter a query
name (up to eight characters) and an optional description (up to 40 characters).
To exit the Menu Interface
To Exit the Menu Interface, press the PF3 key. IDEA will return to the INTERFACE
SELECTION SCREEN.
Student Booklet
23
-------
Running a Keyword GO Names Query
The easiest way to build a case screening query, i.e., look for only certain facilities by
their name, is to use the GO Names feature of the IDEA Keyword Interface. The
Keyword Interface allows you complete flexibility in constructing the selection criteria to
be used in your search. The GO Names NAME SELECTION MENU allows you to select
facilities based on their facility name(s) and location, then automatically builds a keyword-
structured query for you. This section of the Student Booklet, Running a Keyword GO
Names Query, will focus on navigating the IDEA Keyword Interface and the GO Names
feature.
The first step is to enter the Keyword Interface through the INTERFACE SELECTION
SCREEN. As Figure 25 illustrates, type K for the Keyword Interface at the ENTER
INTERFACE OPTION prompt in the INTERFACE SELECTION SCREEN.
.—. i#T$nrj«:e sstfcno* senega -
COWARD
JOt* cwrently supports two interface nit* ufricfc to construct and
. run queHet. They are described briefly btlow.
X - K£VWOK>»VAtUE Interface: » *ISW=-Hie»» fuU-power interface;
» Maximum flexibility ant complete €S">«
A - XEW A Interface: »~ Usw selection menus end pep-up -windat»;
» ?rovide» oprioft/vttu* Hst$ fro# tAicK to build queriee;
» tester te us*, but teea fieri bllity than KEYNGBS-VALUE,
NOTE; in order to use thi» interface, you mst be ebte te use
your t*r»{rial's W Key equivtient* for *£nd*, *Up»»f end "Sown".
{See the 105* KelpUr* for wofe tnfprwrtton on Ff Keys).
tnter Interface: Option «•*>.*
Figure 25. Interface Selection Screen
24
IDEA
-------
The Keyword Interface operates within a mainframe word processor. It first requires you
to tell it where to look (called libraries) for existing queries (called members), or where
you want to save new queries. The Interface defaults to a library called
UIDACCT.QUERY.SPECS, where UID is your user ID and ACCT is your mainframe
account number (see Figure 26).
LiWW** SElfCTKW SCKEEH —Q7/K/93 17.03<*XS)
COMMKB
Ubrar-y ttaac *»#* giDAeeT.OuEM.SPeca
Ubr»l*y «•«> Sttft
KOTii if "sku*, raese is m wshmuiy o# sm eoaaicr
- tttt pof soiroft
for Only
Tr«du **** 805
Biroctory 00ft "
Figure 26. Input Library Selection Screen
If you want to use the default library, press < Enter >.
If you want to change to a different library, type the different library name over the
default, then press < Enter >.
If you want to create a new library, make sure the library name is unique (change it if
necessary), and change the library status to NEW; press .
Student Booklet
25
-------
Once the library is selected, the next screen displays the contents of the library as a
"MEMBER LIST." This list displays the member name, the date and time that it was
created or last changed, an optional description of the member's contents, and the user ID
of the person who created the member (see Figure 27).
ne»« tist —ujDAtfJA-.otgRY.srees ts to 3* of
command *—» € apuuis scaou ess
NAME CHAMG60 9CS£IUmaK
931120347
'MEUfllE 93D913.1534 Keu Ftte Sxaspte Query
NEUQUE8Y 930913.1535 Example of Keywords
: NEU2 : 93102V. 1547 IC«Uy Run Sartitatiorv Query '
K£W3 931029.1530 IfoncoftpHtnce tC«y»or«te
MEWt 931S29.1550 Koncwrpliance Keyvofdt (APS)
NEW6 931029.155? Go Kernes XeviU* Chwrtcals
«U7 931029.1552 tolly feti Semtattoft
MEW9 931029.1553 Partial Query Logic 'flora'
ttPGES 931019.1645
f>Atm 931005.1555
PHIL 931029.1555 PttitMei^i* lUtttf t CW#**
PKILA 931029,1556 PMtactelpM* fUctHc Coapany
PB!t£C 931029.1556 Wiilacfelpfeia gietttit CoB^ery
PKJtfcLEC ssittt.m?
PICO 931029.1556 Pico Battery Conparty Ouery
PfOfitl 931207.1243
SKOW 931029.1557 Go Mams — «fcona»f>
-------
Figure 28. Member List Commands
B
= Browse/Read the query; no editing possible.
E(orS)
= Edit/Select an existing query or create a new one
in the editor.
R
= Rename the query.
U
= . Update the query description.
D
= Delete the query from the MEMBER LIST.
After you select a query or create a new query, press < Enter >. IDEA will bring up the
edit screen illustrated in Figure 29.
e>JT UUMCC?,«»llYkSP5D5{8PUll«>*- Dt,w> *
CCNHW» **»;» «***#*#*»
comas m an
SCftOU »*» FABE
WTTCX Of ttAU
Figure 29. Edit Screen
Student Booklet
27
-------
As an example, we will use IDEA'S GO Names feature to search for a facility in your
area. The facility was selected at random, strictly as an illustrative but real example, for
IDEA training purposes only. For this course we will use Blue Plains as our example.
First, open a new query member at the MEMBER LIST screen by typing E BPLAINS on
the COMMAND Line, followed by < Enter >.
To access the GO Names function, use or to place: the cursor at the
COMMAND prompt and type GO NAMES. Press < Enter>.
The NAME SELECTION MENU SCREEN will appear for building a name-based query.
As Figure 30 illustrates, GO Names gives IDEA users the option of conducting a search
according to facility name, location or a combination of the two.
HAKE SSJsCTIQ# m*J
COKKAKP
Mmk **«*
Worcf* *=»«* MX
Kor* lest-l jlutly nanu «hen words fwvw 3 or fewer eertfonB(it»(T/N> m<*> M
otlwr values that my b« togfcttw and
result AfcDed kftft the n*» above -
Ot ***» NtMO «•«*
cou0ty(3sccc> *=»»> **«>
Regi on ***> »»»> vm> mt> #**>>> **«>
J[(! Code esat? iraa> msk>
Figure 30. Name Selection Menu
28 IDEA
-------
1.
Name:
2.
State:
3.
County:
The "Name Selection Menu" options include:
A single or multiple-word facility or company name.
A two-character postal abbreviation for a state.
A two-character state abbreviation plus a three-digit F1PS county
code number.
ZIP Code: A five-character postal ZIP code.
The locational criteria are ORed together and are then ANDed with name criteria. Here
is how IDEA sees this logic:
NAME and (Slate or County or Region or ZIP Code)
To begin, enter the name qualifier: Blue Plains (we could be more specific by using
additional qualifiers for the name and location, but this example allows us to use some of
the editor commands later). Press .
— SAME SCtKTIO# -— ............
CONtMl# **»>
Nans *»*> BUJ? PUUK
*KW{r«KAUYA*T>
nor# rwnoa «h«n uordfe l»#v« 3 or con»«wtt»{VN> «•»•» N
OttMP ntuaa that my bt 0Re<3 and tf»
r«sglt ANDed kfch the ftaoe ®bove
$t6tetSS) or rc*> mo " •*«»
Courvty{SSCCCj *»«>¦
Regjtxt •"»> #iw ***? #»*> «»k>
214* CPd# ***> M3SB? M»J» ***»
Figure 31. Company Name and State Qualifiers
Student Booklet
29
-------
IDEA will then return a count of names that match the qualifiers -
that "sound like" Blue Plains.
- facilities with words
*Awr SEtsCtig* ww - -
OMHANO »*»
Mute «•> SLUE fUMKS
Wafdt »•> Alt
Her* t*s»-Uk»ty ww wfort nortfe hav» 3 er fvmt canto*»««~ *
Other vati*s ttat any is* ORed totwt^sr ami the
rtwili AHDed ttith the rune above
Of «»t) «x*> «t*» ' MD
C«Mn£y<$8:co ¦»*» "»*>» «»> «*»> ««*»
?:! :|f 1£; ;3 'i!:???!: :: S'lil
ZIP Code *a*> ea*» 8**» t»»» ««*>
10 mm* sfiected
(trtum times to fc»ryr * »n» tt
Figure 32. Name Selection Menu Returns
A line will appear at the bottom of the NAME SELECTION MENU SCREEN asking you
to select a query building option. It reads, RETURN NAMES TO QUERY: Y(ES),
A(LL), M(AX). Your choice here will determine the level of facility name comments that
will be included in the query. Since the number of returns is small, for this example,
choose M.
IDEA will then return to the word processor, i.e., the editor, and fill it with the query in
the keyword syntax. You then look over the query, and identify the facility of interest
from the list of names. The Blue Plains records start on line number 6. Use the function
keys PF8 (down) and PF7 (up) to scroll through the rest of the query.
30
IDEA
-------
Notice the keyword syntax: an OUTPUT statement (selecting Report 1A), an INPUT
statement, and a SELECT statement consisting of the database code (FIN), the field name
(EPID = EPA ID Number), and operator (=), and then a listing of EPA ID Numbers,
separated by commas. The commas are treated as "OR"s. To the right of each EPA ID
Number are the characters "/*" indicating that everything to the right is a comment and
is ignored by the computer. Following the "!*" is the name of the facility from each
linked data system and its address.
BUT Wl V*OW. OXRY. SPECS {B LUC) - COLUMNS 001 072
CCNKAM9 *"»» * SCROLL «>*> tfALf
«***•*. :'*• it***~•*•**• ' Qf PATA *****************+*********+**
00)001 /* 840720 1133 >ne& Se&refc found » rtaw&a. ~/
000002 /* Wmi BLUE PiAlKS */
00GG05 OUTPUT ftEPOftT 1A
000604 WPUT litBCEB
000005 SR.E.CT
000004 OCOSSI10629?^ f* fitue PLAINS WASTEWATER T«EAt*NT HHtt tRC* DCDOOQ797
¦ 000007 /* 5000 OVERLOOK AVE SU */
000005 f* WCMIKTat 0C 20032 »Wt V
o®>B09 ^ o c owr of pwsiic yours pcw mm dow506#>7>
000010 f* 4T» St & IK HIU1/U* 0* Jfcrf V
OGOOT? /* UAStt{tt6T0lt 0C 20005 05 OCX */
>060012 J* J). C. BEPT* Of PUBLIC HWKS fiES {PCS 0COO211W) V
000013 i* UASttittfitttt 0 C 60 03 001 */
oooot4 r* eisTRtci of cocohbj* «>«auc w«s> muMZ
- 000015 /« 5000 OVERLOOK AVgNUE */
: oooot6 j* wsmmno* PC 20032 as */
000017 }* BLUf PiAlttS SEtfASE TREATMENT PLAUT
-------
Since we only want records linked to the facility that we are interested in, we need to
delete the lines that contain EPA ID Numbers for other facilities. To do this, use the ISPF
block delete command. This is done by placing two D's (DD) on the number of the first
line of the text block you want to delete (see Figure 34). Move to the last line of the block
you want to delete and place two D's in the number string. Once you have completed
these two steps, press < Enter >. The editor will delete the specified lines. To learn
more ISPF Line Editing Commands, refer to Chapter 9, Managing Keyword Queries and
the ISPF Editor in the IDEA User's Guide.
SD1T •— WLVA0S6.aCEIW.SI>£CS<8U}£) - COLUMNS £»! 872
tu> OdKJU osxe>
000058 MI0EJU?39!9, /» 8U1E PLAINS SOM6E TREATMENT PU*T <0CK 03>87-O3O«) «
/* fittg PUJBS SIMS? tJ>eAT«J BUS PLMHS SHW*fi£ T8EAT*0 V
000051
000052
000053
000054
000055
00005(4
060057
86095ft
£>00059
000068
O0 V
f* H/i set* 2, tu*m 51$, (to «
/* MXLS 91A1HB K$ 0? 191
f* ttUS RAi«E cm OF 84998393) V
/* «ee? T3ts »w
*/
m*»m ¦; »»*•••*»»«**••#»<«»•««~•«««<»** :¦ aoTTOM Of! DATA i
Figure 34. ISPF Delete Commands.
32
IDEA
-------
If you want to see additional reports, type in the report syntax on line four, e.g.,
OUTPUT REPORT 1A REPORT IB (see Figure 35).
To run this query and generate the reports, type GO at the command line.
ant --- - — couxm oot m
CMum »» . KHOtl «n>
G000G1 t* «0720 !?33 Hones Search found $ Mete*. V
1)00062 /* Now: BlUE FU>WS *J
000005 OUTPUT «EPt»T U KEPOKT 18
000004 1WU? UKKH>
(J0GCG5
000006
00000?
00000ft
<»0Q09
ooooto
ooooit
WJ0O12
000013
00001*
000)1$
000016
mm?
«001*
000019
OOOOSK
G00021
SELECT flU.CPJp-
0O)S>81106297, /»
r
/*
/*
/*
8iU£ PUtHS VASTEWAT6S t«*T#£NS PU,tft JftCft OC&00079?
50Q0 ovg(h.oo v
/*.. UAStfUGTOH DC DC 03 001 */
i* OJSTRJCt Of- COUJWM cmuc WORKS} «C0 »G3#422
/» saoq ov?iH.ootc mum ¦ v
f* UASITHGtON DC 20052 05 V
/* MM PUklHS «WAG£ ?ftgM*£K? Pt*#T ia3#J9««1CH71
/» 590 OVERLOOK AVENUE" V
/V NASMWTOK - fitZOOR 0* V
/* DISTRICT Of COtUMflU 6W Of W#L»£ U»K 103f!9S
/* WATER £ SgUEft UTltt* *DHIl»r5O00 CVmOOT •/
Figure 35. Report Syntax and Query Execution
Student Booklet
33
-------
From here, IDEA will process your GO Names Query and present a QUERY STATUS
SCREEN (see Figure 36).
WSRT STATUS S«SEK
CONKW®
QPrtttOr.te - 6 ftcfMeft* Minted and i* HMOS
Counts (percentages), fay databaa*, of 4»eUit?es fi«i*cted but
«xctuded because they were rot pnwent in f 5H&S;
m a < 8>
Pr«£B CNTCR to contino#, £M to return to stkft
Figure 36. Query Status Screen
The report, Report 1A, that returns might look like this:
Sft€US& - Report; ifr CmpUt*--* MAX 000102 U«£ 0000 iHVAUJ) CO#***
CGKKAW *«*>
Issue cawwnd P8INTI? to prfnt, or SAV6 to *&* to Mt
Zip:
mi*
tmi& aaattef Wt 0C&0GQ797W
#<*.EwU,
Ho.iltm
INmt «.« ftAJItt WAST£UATES T«AT»E»T PLAKT
0
0
Vfr F«?iU«y StatuSr SPV7 MQ
tr
&' -
Owner Operator T*p»r P €xi*fc» Bott: W79/T or PUfiUC WORKS BftA OHM
CK92
r
t
f*> facfUty Status: «W NO -
cm
1
t
Ow*r Operator Type*. P fxitt. 0»tei
cm
\ \«
D
Figure 37. Report 1A in Browse Mode
34
IDEA
-------
The following figure contains the ISPF commands that can be issued at the COMMAND
prompt in Edit and/or Browse mode (as indicated).
Figure 38. ISPF Commands
(default values)
Command
Mode
Description
ISPF HELP
PF1/TF13
Edit &
Browse
Display! information about the current screen
SPLIT SCREEN
PF2/PF14
Edit &
Browse
Splits the screen into two ISPF sessions.
END
PF3/PF1J
Edit
Saves changes and returns to the previous screen.
Browse
Returns to the previous screen.
RETURN
PF4/PF16
Edit &
Browse
Returns directly to the previous Primary Option
Menu. 1
REFIND
PFJ/TF17
Edit &
Browie
Repeats the previous FIND command.
RECHANGE
PF6/PF18
Edit
Repeats the previous CHANGE command.
UP
PF7/PFI9
Edit &
Browse
Scrolls up by the amount set at the SCROLL or
COMMAND prompt
DOWN
PF8/PF20
Edit &
Browse
Scrolls down by the amount set at the SCROLL or
COMMAND prompt
SWAP
PF9/PF21
Edit &
Browse
Moves the cursor from one screen to the other in the
split-screen mode.
LEFT
PF10/PF22
Edft&
Browse
Scrolls left by the amount set at the SCROLL or
COMMAND prompt
RIGHT
PF11/PF23
Edit &
Browse
Scrolls right by the amount set at the SCROLL or
COMMAND prompt.
RETRIEVE
PF12/PF24
Edit &
Browse
Move* the cursor to the first input field on the screen
and retrieves the last command entered
FIND
Edit &
Browse
Locates the first line containing a specified character
or string of characters.
CHANGE
Edit
Changes the first occurrence of a characters) to
another characters).
SAVE
Edit
Savea your work and remains in the edit session.
Browse
Refer to the Saving Reports portion of the Query
Status Screen section.
CANCEL
Edit
Ends an edit session without saving any changes.
Student Booklet
35
-------
Using Your Home ZIP Code in a GO Names Query
As another example to demonstrate the GO Names utility, we will conduct a search based
on your home ZIP code. Using the key, move the cursor down to a ZIP code
field. Type in your home ZIP code.
HAME StLKTlOK KM) -
COMMAND
tfftns «**>
word* ft«qu Au.
More tw-litwty rmm #l»n «e«te tov# 3 or f«wer «>r»coent*{Y/»<> *»»» X
Ottvsr vtlufts that my ba O&ed tog»t)w and the
result *W>«d vfch the mm ataov*
$t8(ct$S.} Of •»*> **«4p s-tkaste gmaV
County{S$€C£) ***** *»«~ ***?¦ •***
**»>- feast? »#*»> *a*» mmshV weft?
Zlf Code Y3UR zip «**> *»*> ass> ***»
Figure 39. Using Your ZIP Code in GO Names
Once you have entered your ZIP code, press < Enter >. IDEA will return the number
of facility counts associated with your ZIP code. You may now choose how much
information you want to see in the Keyword editor. Y will return facility names and
FINDS ID numbers only. A will return facility name, FINDS ID numbers, and addresses.
M will return each name and address associated with a particular FINDS ID number.
Enter Y, A, or M on the RETURN NAMES TO QUERY: Y(ES), A(LL), M(AX) line.
Press < Enter >. IDEA will now return facility information from your ZIP code to the
Keyword editor. Type GO on the COMMAND line to see a report on these facilities.
36
IDEA
-------
Editing a GO Names Query
iinwAea seucno# sage* -
cowa*®
iOEA currently support* two inter faces wltto to construct and
ruft querie*. Ttrty W# d«scribed briefly below,
K « «rw«tt>-VALUe lftt«r#»cer » fuJi'Sowf
y> Hexfuw* ItatlMMty #nrt complete -ctetabwwt variable access;*
» tls«6 the K)f text editor to construct keyworct/vaEue queries;
» Irtterfsco for runMn# facHity mm twwrcka# ("W MMES").
* - MEM* A >~ «sw selection ma*» and pop-up window;
» Provides opti orv/vjlua iljits ftm bUHtf
*> Saai«r to us», but Iwa fiaxibHfty than K£fWfl(©'-V*t«E..
HOTE: in orf Key equivelem* for "End*., end "0tsutfl.
{See the i0€* Mpline -for nor* Information on Pt Keys).
Enter Interface Option «*> X
Figure 40. Interface Selection Screen
From the INTERFACE SELECTION SCREEN, press < Enter > to use the Keyword
Interface. (Note: this accepts the default value ofK- Keyword Interface). The INPUT
LIBRARY SELECTION SCREEN appears.
Student Booklet
37
-------
s—- /*pyt irwway silsctjq# scwes —
CONH*(© .»>
iibfiry Mane »»> *KT«1tt.aU6*Y>SPfCS
tfbrafy St»ttiifS$ir/tt«te/dld) »»*> Sttfc
for **«& Only
Tf»ck* »«*> 0(5
Directory slocks **«* 008
Figure 41. Input Library Selection Screen
From the INPUT LIBRARY SELECTION SCREEN, press < Enter > to move to the
MEMBER LIST SCREEN (see Figure 42). (Note; this accepts the default library specified
in the LIBRARY NAME prompt.)
38
IDEA
-------
*EM8£R UST *, XXTQPKCh-WSRY. SPECS ROW 1 TO & Of 6
COM*$ «"» f <00*< 5C#CiL »» PAGE
USS UFT OF *A*E.
XAH£ ftUttlttft - &6SCMMH* 10 '
WMS - $40t2S.1&24 Oun 1 ftradstrwt - United T«ch XXT
6XAWU 945119 k 112A E*«Bple ^&CA CK»ry-~KC J>«w*r Pi»m# XXT '
(WHES 960125 J 02J So- Hanfts Qucry SxaqpU m
$KIW>ET *D12$.1S# tton'CMpltanee i.Ofl$C XXI
TEST XXT
TftY 946120.0936 *XT
«»t«I»-«I>«I|H»»* to move to the EDIT SCREEN (KODAK) (see Figure 43).
Student Booklet
39
-------
a>n X!CTOP»».««R*-SPtCS
C0MMAH6 %st> QO ItAttELS
-JQp-.£p
<»t m.
3CKS.L **#» CSS
p
Figure 43. Edit Screen
From the EDIT SCREEN (KODAK), type GO NAMES at the COMMAND prompt. Press
< Enter > to move to the NAME SELECTION MENU SCREEN (see Figure 44).
40 IDEA
-------
&at« options
- HAW SCISCTIO*
CCHKAHO axc>
Mane «¦»> fcQOAfc
*»r«nts(t/!0 «**> N
Other values that teay b* Ofted tag^thw ami th«
result ANQect *ith the nam «bov*
St9te($$) or aHII> «ao» «a®» sao> mi)
Cour>ty ns>
*#*> «**)• aao «oa> *raa> «**> *»«&>
' -ZIP tOdt ¦¦ I":':":".':* '• :. : ¦:;
Figure 44. Name Selection Menu
From the NAME SELECTION MENU SCREEN, type KODAK at the NAME prompt.
Press < Enter >. The NAME SELECTION MENU SCREEN returns with the number of
names selected (see Figure 45).
Oat* Option*
«»—. MAHE SEtlCTlOK mw
CCWW» »*3t>
Mam KOOAK
Vor ««»*> »**» ¦»*» ««*»
ZIP Cod* ***> »=*> »»«> m*> a#*»
2D9 ra*$ selected
ftetyrp »Mb#» to ACU), W*x) *»"* Corp. *=«* »
Figure 45. Name Selection Menu - Counts Returned
Student Booklet
41
-------
D«tA Options
„ KAMT aLecnt*
2 t« AH •vaHatoU t
t. exclude E*« I
V©r$ r«KAlU»flf> ««» AU.
MM~< t6s»-I1 tely natoes When word* have 2 Of con«onar*tS0 tm*> g
Otter r»lues th»t aay be Oiled together «nd the
result AHOcd with th« nam above
StBtetSS) or «»*» w»»» «a*> as«> a»»»
County(SSCCC) »¦*» *»•> *»**
tie^tOft im*> fcva> x*!*> Xtm> anlK> ntwi>
ZiP Code ms> *»*> H3is> icm» g»ttr>
289 Mks Selected
flet&fn Mantes to thMryt Vlee)*, AtlU, B(**> «*>
Figure 46. Name Selection Menu - Data Options Selection
To eliminate the Emergency Response Notification System (ERNS) data, press < Home >
to position the cursor on the Data Options field. Press < Enter > to activate the pull-
down menu.. Type 2 to eliminate ERNS data and press < Enter >.
The NAME SELECTION MENU SCREEN returns with the number of names selected (see
Figure 47).
42
IDEA
-------
o*t# options
— — HAME SCLECTIOH -
camm
ttam «•*¦» KODAK
Mowte R«qufr*c«Al.l/AKr> »•» AU
~tor® i Bsa-U k*ly naae* srfvefi words, have 2 or fet«f ror*pr*nt3{¥^M) «»*> M *
Oth*r th«t My b* Ofi«d ti>5«thw »nS ch«
result AMOod with ttm mm «twv»
**St8te.! w; i | ;•#»:' i; f j i i; U y \ I"*** U F- j?-;y .? 151 \ ? i Nl \«11S l>
Coor>ty ¦ ¦ ***» *»«w **** «*
0ft Scs> ies> «is> «bs> nx> «ta^ tssV
?:: \ifcisi:k-:|:;: f•<¦ 'i:;;:.11|vjis
\77 nam *elcct«d
fttttttk HMes to fetery; *, AtU), M(ax> *«> Y 'S&tp* **»?> M
Figure 47. Name Selection Menu - Return Names Selection
Type Y at the RETURN NAMES TO QUERY prompt. Press < Enter >. The EDIT
SCREEN(KODAK) returns.
Student Booklet
43
-------
-T COUJMGI 061 072
„ SCROii »«*> CSK
177 nam**. */
€611 -7" »«QWtt,«UaW.»ECS<>toOA»!:>
.,ttWWhtt:.WM»,,,,,,,
OOOOCt r* 950130 1*1* Names S*«rch found
000002 /• Nam; IC0WMC »/
008)02 OUfPUT SgPOST 1A
000004 IJWJT IIIUCEO
OOOOfiS SELECT ftD.£PI&a
600066 Al®00926191$, /* ALL AtASKA# SEAfQQOS !«g S:
0G00B7 AKH00947B017, /* FAROS S£AfOGOS !KC S:
0000oe AKP009490012, /* €A$T POiKT S£Af«» CO 5:
300009 AKB021829478, f UESTERK ALASKA CiSHERifS It£ Sj
600010 A»04ttT»6tf4 /* ALASKA PACIFIC SFAfOQOSJNC 8:
DQOOIt AKBM2A78982, J* KOOIAfc SteCWC AS5K IK ttCft «00^4789«2i */
000012 AKD061680631, /* JHTSRNATJQttAt SEA«X»S Of AJC S: K001AK f*C(UTY CS
000013 AKD063376974, /• KittS CfiAB IMC KODIAX fAC {OCR AKB063376W) V
000014 AKD067442798, /* KOPJAJC ISiAMO BOfiO SO {MC8 i10#WK0722KX062 f> *f
008)15 A(®089941454, /* JffSlK StAfOCOS IKC Ss KODIAK G936a63l9, /« ALASKA «ESM SEAFOODS MC S> KOOiAfc FAC! tJ Tt t«S
60001ft AKP099833459, /• ALASKA ONSHORE ftStERJES Si KODIAK fACitHT CPE*
DO 0019 AKD9ffiJ975841j /* KODiAK 01LFIEU) KAUL£8$ IMC A»CMSA$£ 98097
<8)0021 AKE980986855, f* OCR A KOQiAK fftASfcllti STATIC* «8* A*559809»68S5) */
SJAR OF XCOIAK cs
KODIAK FAC!LITY
KOOIAK (StiSIMl)
KQOtAK (WR1WJ
cs
(PCS
CFC$
Figure 48. Edit Screen - Names Returned
IDEA'S GO Names utility uses a soundex algorithm to search for facilities. It takes the
first character of the name and the next three distinct consonants and searches for facility
names that match them in an effort to find facilities that sound like the one you entered.
If a facility name matches this pattern, it will appear in the list that is returned to the EDIT
SCREEN.
Soundex Search Algorithm for KODAK: KODAK
For example, you entered KODAK. IDEA will search for facilities whose names contain
the characters K, D, and K. Therefore both KODAK and KODIAK facilities'are
retrieved. The required query statements of OUTPUT, INPUT, and SELECT are also
returned.
In the following steps, we will use editing techniques (including block copy, cut, paste,
and find commands) to delete the KODIAK facilities while retaining the KODAK
facilities.
44
IDEA
-------
6D1T v-- X!C90PW.aUSRT«SPECS(l»0Jl*K CQUMNS 001 072
COMMAND **»>- , SCMiX «*•* tSk
»**#*# jQp P&?A *****•************~********+***
000(851 /» 950W W8 «*>** $<*rci» foOn* 177 iSMte*, •/
000002 /* Ram: KODAK V -
CC 03 OUTPUT KEWSt U
900004 INPUT MH*a»
CC OS SELECT FIK.EPJB*
000006 *KO0W26m», /~ A Li ALASKA* SEAfOOOS i«C S: STAR Of K0CIUC (9 (F
000007 AKB0D9478017, f* FAROS SEAFOODS IMC S( JMO!A« #ACIUTY {PCS
00000® MJJO0949OOW> f EAST POJMT S6AFOQB CO S; KOPIAK fACIUTT (PCS
OOQGC9 A«S021629479r (* WESTERN AUSKA flWERlES «t St XCOIAX. tSURIMO (PCS
000010 AXJHHr»8<17, /« ALASKA fACmC SlAfOCM }*£ - 8: KOOfA* (SURIHl) {PCS
OG&M AK004247B9S2, Kf»lA«C d£Cr»lC «S« i«C <*C8AtCDM2>47«982> «/
000012 JKDO6t60<»5t, f IKTEfiNATiONAt StAKWOS OfAK «; KOOIAK fACUITY (PCS .
080C15 AJ®0633769?4, /* KING CJtAS INC MMAK FAC (Rt* AKB0&337«?4> V
OOCOH mMTAZ798, t* KOOIAK tSLANO BOM $0 <>K3> TT<»19W07E2HX002 1} */
000015 AK00WMHS4, /~ UttttN SEAFOODS INC $; tOOlAK (PJfi8 0«£5 . /* AIL AIA9CAK SEAFOODS WC $: K»MK FACttm (PCS
00061? - 4*009368631"^ /* ALASKA tftES* SEAfOOOS !*C Si KODIAK. fAfifim (PCS
OOOOtS AK5>099a35$59r /• ALASKA ONSHORE fJS«ERJES ' 3: KOOJAK IACUW {PCS
000019 AXS9B0975841, J* KOOTAK OJLfKLD 8AULERS1NC ARQKORAQ! (Rtt AOWBQWSS
000028 AKD980976617* /* KOOIAK OILFIELD HAULERS I IK PRUWWC 8A? to line 000003. Type CC. to line 000005.. Type CC.
Student Booklet
45
-------
mt *— >QCW».QU»T.SP«S CUT 8CSCU **o> CSfc
\TT nmtm$. */
Si 5TA* Of JO»l*X CS 067iMrm/~/* WXUAK IStAW SOW SO nW19W>?22#Xf»2 1) */
QOOBTS AKD0699414S4, /* OttStil SEAFOODS |*C Sc KQDJA* (f>5ER G«) , i+ KODIAK OJLflELD JWUtSftS IKC AltfRMAGS CSC* AO9809758
060020 *»©93Q9?«}?, f* KOOIAK GtLfKtD «AUL£M I*C PWWKf BAY <*CR AJ®98G97
00QG21 AJCD9B098&855, f* DE«A KOSJAK. TSACJCIKG STATION 9&0986855> ~/
Figure SO. Edit Screen - CUT Command
Press to return to the COMMAND prompt. Type CUT. Press .
Lines 000003 - 000005 are placed in a nondisplayed buffer. In the upper right hand comer
of the screen, ISPF returns the message "3 lines cut."
Press PF3 to exit and save the KODAK query. The MEMBER LIST SCREEN returns.
46
IDEA
-------
»*—,—cm prowpt and m defaults •— arc* reouirsj new
COMAW- ««•> ,
Action *a*x> ACtf>, REPLACE, or folsnk for (fefMitt
COT tabl* nanc«««> any two sharer*' nm» for tfcia one t1«e
blank for delaufct
Wi **ie 1000 any nuaber K» re 99999 for tfiit <** ti*tt
ADO or K£PkftC£ '
PASTE default »**> KEEP of ZERO
CUT table mwww*' u nytw character name for dfcfeutt
CUT sfte Hait*w»> 1QH) any nudber 1K> to 99999 far default
A8& #Ht add CUT tines to- the end of previous cut lines if my.
REPLACE will, clear any previous CUT |tr>es ortd yep I act- then witfc.
newly off I fpes.
KEEP wilt keep previously CUT lines after *¦ PASTE operation to
be used by « later PASTE or added to by later CUT operations. .
2EK9 Hill delate previously Oil ;iries after * PASTE op«r«tiOft.
Figure 51. CUT Default Screen
Note: The default values for the CUT command must be specified the first time that the
CUT command is entered.
OJt preopt nnd'M^
COMMA MI
Action , «•**> rnf tfSPWCg, Of Man* fpr tfefaylt
CUT t«Me fttwe*w» any two character tune for this one t1*»
blank for default
cur $$te'liialt«i**> 1000 any nu>ter TOO to W* for tMa a* t(«e
Set default CUT and PASTf actions:
CUT default *««» replace «s> of *$PtAC£
PASTf default *•*> tero KEEP or iE«0 -
CUT tafeir mm**** Aft , any two olwracttr naa» for default
CUT Si** Uaut«*» 1000 *ny nusiser KR> to 99999 for default
/©8 *Hl add COT Um* to th» and «f previous CUT Unas if wry.
8B*W0I *1U clear any previous $/? lines and replse* then uitft
rtenly CU? Hnw,*
kfgP wlU Keep prevfoutly CUT line* after a PASTE operation t4"„
b» UMd by » I star PASTE or added to by Uter CUT operations*
2E*0 Kill delete previously CUT lines after » PASTE operate.
Figure 52. CUT Default Values Screen
to the CUT default prompt. Type REPLACE and type ZERO at the PASTE
default prompt. Press PF3 to save and exit the CUT DEFAULT SCREEN.
Student Booklet
47
-------
NEWER UST mOPMCUNifW.SPSCS «E3*£8 CREATED
COMKAKB ww» £ LOGIC 6CK0U ">»* PAGE
NAME C#Allfi«* &£$C«!?nO* ID
KODAK W01E5.t03? XXT
NAME? 94Q125»?02S Co Manet Ou#ry EMfflpt« XXT
S#lPP6T 940125,102^ (fon-Conpl i anc* toa»« XXT
rest «oti9. i«? *xt
TRT *401».0«6 XXT
»:«*»mAmjtM.*** »~»»»« »*»~»»»*»»> ftOTTOK Of DATA
Figure 53. Member List Screen - Creating a Member
From the MEMBER LIST SCREEN, create a member to retrieve and save the lines that
were placed in the buffer. Type E LOGIC at the COMMAND prompt. Press
< Enter >. The EDIT SCREEN (LOGIC) appears.
48
IDEA
-------
BMt XKWW*0Um,$P€CS -—'—- - C&UKft Oft! 071
txmm ««*> PASTf s c$*
*#***#*•#***#*
UlHt
' ;:f:; :; ::*:-V: -::i :'-V:"::!::':^ Ci*^:iv:V.^:i"-V:^::' :7 P[<:- :• :i:;: ^-:*^
: $$ |fhj; ii to :i:;i ; '?M i i :i f I!: :¦•: ::;i; £1 UM££ :i P $ l& I ^ q i;-?;:"; ?i| U >'&¦} <{H ••
i;.:: ^-U fwrf xi: 7^
; M W^W>M li y ;|li";: ;; i:i?v::; III t |:;|ii|l?:;|||:| jjf \ ;i jj ^ :;. til 1 ^': :r $5?-:j:£:<-i::! ? ^ §:V:>-::1 ^::i?:::|.>: r';:: ri>:ij:=.' 1= :
~^:h:-;i;-:^^ i: i: ; | {: h;:; ^ f ^ ^ I": d • > : i: I: ^ K:; H: :^-^ V >. J: ::: ^<4::<::^:-:: ::=::^^ H:!:::-:.:i
•;^;|t;i;|f:*.;i:!-i:c:iv:^.!:6:: 5:ti:1:.i:' :|?*$-:'vi -? 'i;?=*: J:i:H^>§::::!t? "Ji >1?5 H :lliT:^:!: tW^?: •:':::S:?:?;H^
:ii!:$iki£ijfj:jj£y^:^^ •: I j:/;-::;• ••;}>W i:*:E- !:;^i-?:!:;l:X:i: >' :I" :!??":
*****;::;•;;iv??^.v;r-:£:;f;:;;;:: ^ ¦• r-i-;M\?:js:i;hUMW^Mii:^';••
<~»»<»
uiru
>> ftt\
H1MI
*»+**» *»»»»*»»>¦»»+»*»»»*«»«•»~»»»» 9QIT0H OP DATA
Figure 54. Edit Screen - PASTE Command
From the EDIT SCREEN (LOGIC), type PASTE at the COMMAND prompt.
to the line control position containing ******. Type A (After). Press < Enter >. The
3 lines contained in the buffer are written to the screen.
Press PF3 to exit and save this member. The MEMBER LIST SCREEN returns.
From the MEMBER LIST SCREEN, select the KODAK member. Type E KODAK at the
COMMAND prompt. Press < Enter >. The EDIT SCREEN (KODAK) returns.
Student Booklet
49
-------
a>n XXT<*W.«£ft?.:^C$«OOAK> - — cotuws -001 <572
CCMHAKO »«=> exCttJDE. ALL KODAK , SCWU "»> C$«
****** 1Qf> Qf »~*****»»**» **~»***»***»**»*»*
0OQOOi ' f* «40t2S t03D Kane* S«arrf) found 1 n na«es. •/
000002 /* Kaee; WBAK V
000003 OUTPUT 8EP0BT U
000004 INPUT LINKED
000005 SELECT HK.ePiD*
000006 VWC00l»2619ie> /«
00000? AKDOG947B017,
OOOOOa *D009*900tt,
000009 AKD82162M7B,
0000W AH>04tt38«r,
OOOOtl AXDG42t>789S2,
0QQ012 MP06168 OWIj,
0OOG>J 4*0063376974,
QOOGH A®0N«t4M,
000015 AJCD09t7MA49,
OOOQtt AJ3X3W686319,
000017 A*S699S35659(
OOOOW AtttfBWTSflO,
oooow mvmrmr,
000020 «DVB0986S55,
000071 A*098t77D62Tr
AU ALASKA* S£AFOOG$. ISC
PA#OS SEAIOCOS IMC
SAST frMUt SEAfOCD CO
WESTER* ALASKA f!&IEKie$ IMC
f* ALASKA PACIFIC SEAFOODS I IE
/* KCD1AJC EtECWIC AJ«f IXC <«8)
/*
f*
f*
S-5 STAR Of KOOIAT (S
St K001AT FACltirr (PCS
s: cgwak facility «/
DEM ICODlAlt TRACKING STATIC* . All lines that contain the name "KODAK" are removed from
the screen. ISPF returns a message in the right hand comer of the screen: ### CHARS
"KODAK", which tells the number of hidden lines. Press to return to the
COMMAND prompt.
50
IDEA
-------
£0!7 »--- XXTO»».flUERrPCC3«KOOAJ<> 127 t*A*S "JOTWC*
COMMA Iffii «**> OSLCTE ALi NX SCtOiL **** P4SE
: ***************************** TOP L*lfS>
000003 OITPUT R£K»t 1A
000004 INPUT LittKEB
000005
setect m.eptD*
060006
A«®0092&!9t&,
000007
AKD00947B017,
i*
000006
MSO0H90012,
r
900009
moi\&Knr
/*
000010
/*
OQODtl
JU3>04^789B2,
i*
000012
AKD06168083J,
f
000013
¦ AR&06U7697*,
r*
000014
AKD089MHW,
/*
000015
AXS091744649,
J*
000016
AKD0«5686319,
r*
00001?
AK0099&3J65*,
AHtfeOWWt,'
j*
000010
t*
000019
JUCB9EJ976617,
i*
000020
jU®9aQ98&&55,
r*
000021
/aCD9817706JTr
f*
FAftOS S£AfOCOS fHC
EAST POINT SEAFOOD CO
if STA* Of MS1U (S t*
St KOfclAif M&lUtr nC StAFOOPS IMC Si KGB! AT CSWHIJ) {?«
KC01AK CUCTttiC A$SK IMC **00 */
iNTEWfAT IGNAi S£A?QQ6S Of A* «; tt»SA* fACJittY «
KOOtAK OILFIELD HAULERS 1KC ARCHORAM */
Figure 56. Edit Screen - Delete Not-Excluded (NX) Command
Delete the KODIAK facilities. Type DELETE ALL NX at the COMMAND prompt.
Press < Enter >. ISPF returns the message: KM LINES DELETED". Between the TOP
OF DATA and the BOTTOM OF DATA indicators, the message: "### Line(s) not
displayed" appears in place of the original lines (see Figure 57).
Student Booklet
51
-------
KMT xre«PW.9?*ltT.SrcCS{K)D«C) 44 UME3 OfL£T5&
COMMAND a«ta> HMD AU *00A* SOtoLt m»» PAfi£
««»»«« *******4******«****»»«*»»«»«* :f OP Of1 BATH *"*****~*»*~*«***«»**'"'**»»**»
- 124 «h »i»wyc&
****** *>•#**'¦ ***»*»*w***w***»*«**** of BATA
Figure 57. Edit Screen - FIND ALL Command
Retrieve the KODAK facilities. Type FIND ALL KODAK at the COMMAND prompt.
Press < Enter >. Press to return to the COMMAND prompt.
SO ft XXTOWW.WERY .SP£CS{KOOAK) 127 OMRS 'KODAK.1
COMMAND *v*r - SCSOtl PA£l
¦¦:****** :; ***»***»**********«»***«l**»Hl*:YQp::Of^BAy^************** ****************
QBQQM /* ttiwwT KODAK */
900092 48906923486*1 f* ARK EASTMAN DTV EASTMAN t®« CO <8C8) V
OOOOOJ CA0028874Z53, f* EASTMAN KOOA* CO V
000005 OUXJ54B54377, /« EASTMAN KODAK CO t&GL M & CtJt */
9CXKB7 CA0981J96369, f* CASTMAN KOOAJf COHPAMY (««> V
000009 CAO98WW50O, /* VEHBATW A K0&AK CCWANlf {R«> V
000009 CA&9ST46256?, y* VEftBAlItt A tCODAK CGKPAHY (8CSJ «/
0000)0 CA5J98HtfW3?, f* SM* WS1C8 EASTHA* KODAK {8C*> V
QOQOH CAD99073896T, /* CASTMAN KODAK CO V
£XXMT5 C0O983?9«Q7, /* KODAK BUSINESS $€ftVJC£S IS# <*«> •/
OOOOte «ibea146244, /* Eastman kodak company */
9DQG19 „ CA0075935^66, J* KODAK PIWCESStNO tABOMTOM iDSR> */
000020 K{000f71957«, J* EASTMAN KOOAK. COHPAOT MK7G t, CIST* CT* (Mtil) */
000021 HJSC776728B9, J* EASTMAN KODAK PfiOCfSSUG IA BORA TORY CH*i V
Figure 58. KODAK Facilities Retrieved
52
IDEA
-------
et>IT XXTOPW.outRT.SPECS(K00«) , — 127 OtAHS 'KODAK1
COMMAND *«=» COPY tOGIC ... SC80U ««*> MS£
*#•***:: ygp ;Qf< $£1$ **<^****************«********
* OC1 /* fee*: KCCAK ~/
000002 AS£>0#>234&e4, /- ARK EASTMAN DI¥ EASTMAN KODAK CO C*CS3 V
000GC5 CAM28S74253, f* £A5TMAN KODAK CO •/
000004 C*W>43066?19, /« XOOA* process rsc UWMT«rr (KCR> v
000005 CAD0548S4377, /• EASTHAK K£X>A* CO *£& M& 9 CTR */
000006 CAD07&5<$2$5?, /* EASTMAN KODAK COKPAHT *ESt Oi$T*l& CTR (SC*> */
000007 CA0981396369, /» EASTMAN KODAK CONfttttV («*> V
000006 CAD96146250O, {* VERBATIM k KOOAK COW Mir (BOO */
OffiDOOT CtoWl462567, /~ VERBATIM A KODAK COKPMV (*CB> */
OOOOtO /* SPIN MWTCS EASTMAR KODAK {#«> */ -
DOQOtl CA&99073398T r f* EASTMAN MOAT CO (8») */
ocoot* cccwwsm, r* easthan kodak cokpaht v
0000VJ C00075J4165&, i* KODAK COLORADO MViSiOM (RCft> V
OGO&tA tt»9«*992«, r EASTMAN KODAK COMPANY (PCK/wr> V
0000£00983794207, /* KODAK 3US1XESS 3£R¥lceS ISM («£») *y
OOOOtt COIDEA14&K4, (* EASTMAN KODAK COMPANY <*f=S) V
6)1249393X5, f* KODAK 1MAG1KS SERVICES <8Cft) V
OOOOtt «AD033£2$T99, /* SASTMAJi KODAK COMPANY $EB OIST CTfr <8CX> */
00CC1? GA0075V39&Sfrr /* KOOAK PROCESSING LABORATORY W8) •/
000020 IH900T719574, /« EASTMAN WEAK COMPANY HICTG & OH SIR CTK <*C8) +/
0000^1 tt!&0776??889, /* 6ASTHAN KODAK PROCSSSING tABORATlX* (MK> *f
Figure 59. Copy LOGIC Member
From the EDIT SCREEN(KODAK) complete the query by retrieving the previously saved
query statements. Type COPY LOGIC at the COMMAND prompt. < Tab > to line
000001. Type A (for After). Press . The query statements of INPUT,
OUTPUT, and SELECT are placed in the KODAK member.
In this example, we know that IDEA will retrieve facilities based upon the FINDS EPA
ID (due to the SELECT FIN.EPID= statement). The comma (,) between facility IDs is
used to OR the selection. We need to make sure the last line of the query does not have
a comma.
Press to return to the COMMAND prompt. Type MAX. Press PF8 (PAGE
DOWN). to the last line of data. Delete the comma (,).
Student Booklet
53
-------
SHT XXTOW«.Ql£Ry,SPtCS
COHHAl© «**> GO
: «»***# TflP fly : nilt
000001 /*«*« ******
000002 OUTPUT REPORT U
0000© iHPUt UMfEQ
00000* seuct m.ewo*
—COPT c creptete
scscu ess
***************** *.****•.¦** «.«»>*
OOOQDS
A*0Qff3234884,
/*
000006
GW02887WS3,
t*
OGOOO?
CAM43 086719,
r
oooooa
CAOOW654377,
r
000009
CA0076542557,
t*
oeoow
CAW6W4**,
i*
OOGBtl
CAD9614625D0,
t*
OOOOtt
CAD9aiW2567,
f*
OOOGV5
CAD9BK63037,
f*
oooou
CAD*90738981,
/*
OGOOV5
<*JM07Q651to.
/~
000014
C000783416S3>
r
000017
COM 804992 48,
/*
oooote
«JW63»420r,
j*
coooi*
CMDEA146264,
i*
000020
OS5t2;W«23/
r>
000021
fiA£>033625Wr
/*
ARK. EASTNA* DW EA8THAK KODAK CO <#£*) */
EA3TWW KODAK £0 (C£«f> *f
KODAK MOCCSSWS tMOftATQtt (JfCS) *f
SASTM* KOOAK CO RStH. Ht 0 CTR <8CS> V
IASTKAK XOOAJT CCHWtK* *£61, SHS7R1S £T« <8CRi V
SAStMA* KflOAiC im>M* < RCR) *J
V£86ATI# A KOCAK «*8>AKr <*C8) */
VERBATI# A KODAK CGWAWT <*C8) */
SPJ* tt(YSt$S PASOU* KODAK (t&) *1 ,
€MTKA* KODAK CO (8«> */
EASTMAN KODAK CCMMKV {OCK/&E?} */
KODAK CQtOSADO OIVISJOK •/
KODAK 8USIHKS SERVICES IBM CRJ»> V
IASTMAK KCOAK COMCAST UW») «/
KODAK IMAGIKS SERVICES {8C*> */
CASTNAK KODAK CCNWUtY SEK SiST CI* <*CS> */
Figure 60. Executing the GO Command
Press to return to the COMMAND prompt. Run the query. Type GO at the
COMMAND prompt. Press < Enter >. The QUERY STATUS SCREEN returns with the
message: ### Facilities Selected and in FINDS.
54
IDEA
-------
— OtgRV 3UTUS
txmm ««*>•
- ^ 10sS;5a.59 - 1M facUitlW #eitct«d Wd {ft
Cottiti (pefc«fttas«;, by cotvti rtus, EMS to raturfc to start
Figure 61. Query Status Screen
From the QUERY STATUS SCREEN, press PF3 to exit this screen. The EDIT
SCREEN(KODAK) returns. Press PF3 to save and exit this screen. The MEMBER LIST
SCREEN returns.
Student Booklet
55
-------
Summary of GO Names Command
GO Names allows you to form a query by entering a company name and/or location (state,
county, EPA region, or ZIP code). To use GO Names, you must be in the Keyword
Interface EDIT SCREEN.
ACCESSING GO NAMES
Type GO Names at the COMMAND prompt, and press < Enter >.
SELECTING QUERY CRITERIA
At the NAME SELECTION MENU, type a facility name and/or geographical area
for which you want to search, and press < Enter >. IDEA will then execute the
GO Names search and display the count of facilities found.:
Before IDEA generates a list of facilities, you must select how you want them to
be returned to the query and whether or not you want corporate profile information
on them. When selecting how the facilities will be returned to your query, you
have the following options:
Y(es) Returns the FINDS number plus the facility name and the source database
name.
A(ll) Returns the same data as Y(es) plus the facility name in each of the
databases to which it is linked in FINDS and the source database names.
M(ax) Returns everything in A(ll) plus the address for the facility in each of the
databases and its EPA region.
After making these selections, press . The facilities from your GO
Names search will appear on the EDIT SCREEN added to the beginning of your
query.
RUNNING YOUR QUERY
Type GO at the COMMAND prompt. The query you have constructed will be
executed, and the QUERY STATUS SCREEN will appear.
56
IDEA,
-------
Running a Keyword GO MenuA Query
In this exercise, we will create a new member that will contain the Noncompliance Keywords
retrieved using the GO MenuA utility. The member will be named SNIPPET as it will contain
a tidbit of information.
MSI * XXTOPHO.aUEtlf. SPECS KM 1 TO « # 8-
CWttftlft mm** e SUtPPtT SOttU w»» FACT
US£ t€FT Of MAM.
KM*
CfiAWSD SCSttiPlKW
IB
BUMS
«OT25.tG35>
XXI
EXAMPLE
$40t1?.t124 fcxwpte 10EA liuwy • *C P«w»r Mant*
XXT
KODAK
940125.1034
XXT
19GIC
WH25„tQ32
XXT
WH3.W2S &> M QiMr? Ex****
xxt
mr
Tar
twr
94Qt2«U»3$
xxr
2t?
WT 25,1035
XXT
*» • % a a. 'a ^ < A ' . ' 1 'g a a'fc'j'l'fc'* A * - '1 fll'l' 1 *—1» ^ ^ ~ -a 4 1 ¦ j A-V' *¦ • ^ » . .. • - . . -
^ wfTw»**iwwwiiw»fw?tfwiwniww>!Wff' 'aOTTiiB'''Or''DATA'¦ wiwuwwiMijiinoiw.iiii'inni.F
Figure 62. Member List Screen - Create Member
From the MEMBER LIST SCREEN, create a new member. Type E SNIPPET at the
COMMAND prompt. Press The EDIT SCREEN(SNIPPET) returns.
Student Booklet
SI
-------
8>n— xxTOPmtQW:fn'.sP€es SO HEJW* ' SWQU CW
t»Cf DATA
*•»*** gQTTON OF MtA *****************************
Figure 63. Edit Screen - GO MenuA Command
Type GO MENUA at the COMMAND prompt. Press . The MAIN MENU
INTERFACE SCREEN appears.
/
/
58
IDEA
-------
o«*(H ai/s/«
IDEA
U*#r: **r
Cnwte/udd ft query by «rit*rfn8 w? r*xt to»
Itiearioft
^ PoU-utafvta
Industry
si UoncorapHanc#
^ £itfor
Horei
Figure 64. Main Menu Interface Screen
From the MAIN MENU INTERFACE SCREEN, to the Noncompliance category.
TypeS. Press .
Student Booklet
59
-------
Betet 01/25/94
Zl
^ Indu*
a Konco
Enfor
"Z ^»CH
2 or met *U
CM Af$
o*
J>CS
t F^ishetf? tWJ;
( Uw(#5 Syttm
j
~
t
1
»
t
t
t
*
I
~
f
1
»
I
f
t
t
IDEA
(fencortpltanc*
? Clew? t *
Sat* £i«mnts
U*er: xxr
VaiUM
Run «
—
_ fterr!
PFO/15:
P?*8/20: >aee Do*t
*C«A
f!HA -
13CA '
tPCM3TJ
WW*
NC&d
#C
: :*PPrV-::
2 or Mor* Uwfl?
in ViatMioft
Significant Violation Status
IP* Cm?U anc» »
violation fit4% *
fceporta&t* NoOCfiapilane*
HcocowpHanee
^rr«nt r«w 1st «
HcncaapUsncs: 2nd fluwtar *
, Vd barter *
*
^nfejotved VM«tl«w : *C 5 S*C
Figure 65. Noncompliance Menu Screen
From the NONCOMPLIANCE MENU SCREEN, select noncompliers (NCs) and significant
noncompliers (SNCs) for each media section (GAA, CWA, RCRA, FIFRA TSCA and
EPCRA313). Each media defines Noncompliers differently
to
CAA
to
CWA
to
RCRA
FIFRA
TSCA
EPCRA
IN VIOLATION, type S
SIGNIFICANT VIOLATION STATUS, type S.
REPORTABLE NONCOMPLIANCE, type S.
SIGNIFICANT NONCOMPLIANCE, type S.
UNRESOLVED VIOLATIONS, type S
UNRESOLVED HIGH PRIORITY VIOLATIONS, type S.
NC, type S. SNC, type S.
NC, type S. SNC, type S.
NG, type S. SNC, type S.
Type Y at the FINISHED? (Y/N) prompt. Press . The MAIN MENU INTERFACE
SCREEN returns with the query criteria displayed.
60
IDEA
-------
»atk: 01/25/94
IDEA.
Ua*r: *XT
Cnwte/Add a query
Location
~ foUutant*
Industry -
_ *onccwpHanc«
Sirforcfwit
_ Facility statu»
3^ *un 9*ry
tt*ar «o»ry
_ Sa*» «u8Py
aatrfa*# 0u«ry
P«1/13: HttP
mJ/?Sj EW>
fss» Up
Pf*8/fth ?a0e SMI
fey entering m "S" mxt tor
Heret ~
You hove cr«atcd » quary^ utins tiie foUo*Sng er Iter fat
tioneocpUoree:
> (APS) In Vtatatta*
< «F$> Significant VioiatidS> leportabia KooepnpiiarK#
„ (PCS) Significant pioflwsptiafw*
(RClt) Unr«$DtMd Violation t««. Iti$i Priority)
« CRCR) Unresolyad Ki$< Priority Violation
. Ota» HFHA - Mgn CoKptlanc*
V <#a>X PJWA. » significant Hob Compliance
„ (MS) TCSA. • Hod Cpnpitancb
, C>KD> TCSA ' significant CoBplianee
. (bCD> tPCRA - Nocv Catpliwca
, EPCRA - Significant Nor* Compliant#
Figure 66. Main Menu Interface Screen - Noncompliance Keywords
Run the query. From the MAIN MENU INTERFACE SCREEN, to RUN QUERY
prompt. Type S. Press . The INPUT AND REPORT SELECTION SCREEN
appears.
Student Booklet
61
-------
Batet 01/25/94
IDK
Ltort xxr
Cr*ate/Wd a <*»ry by w>;er?n6 «* "S" t* , 7ou hav» erwud a qptry, using th« foil caring crft«rf»t
iIndustry! ¦¦.:i;\Ii:s*s?:Hf£^ i# < 3 & $ !i&Si
22 noncompliance . itorewaptiarfc*?
Enforcoaem . ». IMS) In (notation
3 facility $t* •»—*-**¦. -
i !iiiput »nd Report Selection f .
^ :=i! ^ :!:::=;^;:::::^:: I; :i y I :i jN :i I; :l; :1 S; ;! ;ji:l;l:::::;c 0 :i li;s=i;
I Irpyt \ flfe Pri«rfty>
I -—— » at Ion
I * tiKXED Integrated Pttta i
a Run
«K?/19: P«g» 0 <;T ~ !~ Jeport 2 t
PfkB/ZO: P i SU»W*r Suranary «#p. The. EDIT
SCREEN(SNIPPET) returns with the query statements (INPUT, OUTPUT, and SELECT)
and the Noncompliance and Significant Noncompliance keywords.
62
IDEA
-------
££>!T —• XXTOt>»te,aO€ftt-SPECii£T)
ixmm ***>¦
C&UfcMS Mi 072
SCROLL **«? C$$
iop of tun
000001 J*'
000002 /~
oaaooa y»
000004 I*
000005 /*
ooooo*, /*
ooooor /»
Keywords 0tn»r«t«d ty N«nu A Intwface
W4,0t.» HU2.» - -
V
*v
*/
V
»/
mum output *es>o*r ia
000009 INPUT UttCED SEUCt
000010 { f* parer* befors JtentA keywords 1tr C0rv«rt1ette» In fttf th«r co&fnfng
0000t1 f* IfcnecwpHwwe kayvord# */
ooaot? «*fsj>cst«t,6rr,Brtf ok or
oooow ts,T * fcs.>wn«* & «$.iacc®m> or
0000W OtOLCWlOWl 0* *C8.ttV!Ql*9} at
oooot* or
000014 <«C0»U.«SU»T AM> ^WTKCO.SWro*) £* *» H&.WCafi Olt
DOOOt? {KC&,,U«SLA»6 Aim #0T KCO.SSOn OK OK».tiOi$UMf JU»
000014 I f* p«r«n After MeauA- kty«ord» fee eenvMtitnc* tn furthsr tsabtaSnft
.##****•: fog W'; #*~**•*<»*****~**~~***~,
Figure 68. Edit Screen - Noncompliance Keywords
Student Booklet
63
-------
£0!T XXTOPHO.QlfcftT .SPEC^StUPPtT) - CQUMMS «H 072
CQHHWe **»>• 3CJK8.t CSX
<»»*»» **~«****«****»«»»•~***~*»»~# top Of BATA >***»«** »<*»»«*» w»»mhhh
60 «« — — 'V
0Q0M2 f* */
0GQGC3 /» Kaywofds gwmratcd by Hku A Intarfgcft V
000004 t* ' ' *t
flOOOOS J* Wi.Gt.» tt,42-0S V
oocxm /* v
000007 '»"•*/
DD (SIS OUTPUT *fW»T 1A
000009 «&
000010 ( /* J*re« befara Ment* kaywordt f <*
OOODW OR
OOOOt^ .LE65StA»F AW #0t NO>,$HC*Y> OR {HC^LEGmAf A«0 Xa>.S#£=Y> W
OOOOU <«O.UMStA*T AMD «0T MCO.SM£«Y) OS CKC&.tf GJSU'T AMD «B.010(f) Oft
000017 {K».t£OmA«€, AN8 NOT NC8.SKC«¥> OK Y})) -
OODDTf,) f* peren »ft«r >tenuA keywords for e«vw»|tnc« fit further cittbtainct
' BOTTOM Of DATA
Figure 69. Edit Screen - Block DELETE Command
- In the following steps, we will show how to combine a corporate facility query (KODAK)
with noncompliance logic. The query appearing in the EDIT SCR F.F.N(SNIPPE T) could now
be executed, as it satisfies the query syntax rules. However, the results of this query would
be mammoth and thus of little or no value. To refine this query, we will edit SNIPPET to
contain only noncompliance logic and add the boolean operator of AND We will then save
this noncompliance logic and copy it to the KODAK member.
The query statements (OUTPUT, INPUT, SELECT) and noncompliance keywords have been
returned to the EDITSCREEN(SNIPPET). Since we will be adding the noncompliance logic
to our KODAK query (which already has the query statements), we must delete these
statements from this query.
to line 000001. Type DD. to line 000008. Type DD. Press .
to the INPUT keyword.
Add the boolean operator AND to the beginning of this query. Type AND; the
remaining part of the line. Press . Press PF3 to exit and save the SNIPPET query.
The MEMBER LIST SCREEN returns.
64
IDEA
-------
an ---• XXTOPt».a«Bt.SreCS(S#JK>tTi CQttMfS 001 D7Z
cctmm ws*' sc«)U «*>** cs*
¦ fQp :ftf: f: :*»««»»»*»»**» * »«* »«»> >«*»>«<»»
4090» MO
000002 I /* parts* before £mk* k«yu&ftfe for corvarrtene* l« ftifdMf canbtjtfng
Q0Q003 ifc)ocorapU«nce Iwywrtt* */
000004 .L£M$U»f m> HOT KP.SW>r> Oft AM? Kra.swYn 0*
000008 {UC&tlE&tStAK? AKD MOT HCD-SHE"*) at C»c&. t£G J SU= t AM> HC&.SKCs'O OR
ooooe9 {KOMC or im.imsurt m ma>.aK*ym
00001G ) f* p«rert after MenUA keywords for c,» iM fc BOfTOH Of »*<¦* WHfc* iMfr
Figure 70. Edit Screen - Noncompliance Keywords
From IheMEMBER LIST SCREEN, select the KODAK member. .Type E KODAK at the
COMMAND prompt. Press . The EDIT SCREEN(KODAK) returns.
Student Booklet
65
-------
KUt"--* XxrOWtt.OJMY .SPECSOtCOAK) - '» cotuMHSOOi on
comim «*=»>• copy skippet - scwu **«*¦ csg
000! TO m98737«25, f* WOA* RAKOtA WC <«CR) */
000W m9Bn?91(M, /* KODAK SANAA UIC'{8C*> *f
0001' *>*D987J«106a, /~ KODAK CAfilSfiSAM t*Cfi> ~/
ooom psoseTWissa,. /* wwur express xisa {8«> */
0001H PR0987381340, /* KODAK RAKJtA t*C <8Ct) */ ¦
ooom «we?»ttHv /* wcak wwoa j»c cacio v
0001M PRD9Smi605, KODAK RAHOU IMC •/
000)17 **09*7301615, V* KODAK! KAMQiA IXC.r MCfc WWEMiaP WtE <«RJ V
000118 SCC06932SCSrr /* EASTMUt KOOA* CO OWOUMA EAST
0001W SC09675W34, f* EA3THA* KORAJC COMPANY 00733B2B2r /* EASTMAN KODAK COHPAKV TEXAS EASTMAN »« EASTMAN CH to the last line. Type A (for After). Press . ISPF will return the message
COPY/MOVE PENDING. Press to return to the COMMAND prompt. Type
COPY SNIPPET. Press ISPF returns the message COPY complete. The queries
are now combined
Run the query. Type GO at the COMMAND prompt. Press . The QUERY
STATUS SCREEN returns with the message: ### Facilities Selected and in FINDS.
66
IDEA
-------
- fiUESt STttfUf stftee*
comm
1fr:45t13«S0 - 14 »«4«cted and H(»8
Courts < percentages), by database, of focUftt** wt«ct«d but
excluded bwcttise tftey ate a not pre£t**t i« flW5t .,
fin b t o) m wfi t w
«S 212 c «> *C* 78 < t)
*CBt 2044? ( 33)
Prtsa tHTER to cootlno*, 6(© to MNf» to start
Figure 72. Query Status Screen
Press PF3 to exit the QUERY STATUS SCREEN. Press PF3 to save and exit the EDIT
SCREEN(KODAK).
Student Booklet
67
-------
Summary of GO MenuA Command
The GO MenuA utility allows you to build a query in the Menu Interface and edit it in the
Keyword Interface. To use GO MenuA, you must be in the Keyword Interface EDIT
SCREEN.
ACCESSING GO MENUA
Type GO MenuA at the COMMAND prompt, and press < Enter >. IDEA will
display the MAIN MENU SCREEN of the Menu Interface. For information on
building a query with the Menu Interface, refer to the Menu Interface section.
RETURNING TO THE KEYWORD INTERFACE
Select RUN QUERY on the MAIN MENU SCREEN, choose the type of search and
the report format you want, and press < Enter >. The EDIT SCREEN of the
Keyword Interface will appear.
EDITING YOUR QUERY
For a list of commands to use in the EDIT SCREEN, refer to the Line Editing
Commands chart in the Keyword Interface section.
RUNNING YOUR QUERY
Type GO, and press < Enter > at the COMMAND prompt.
Combining GO Names and GO MenuA
• Use GO MenuA before GO Names to build a query that combines the two.
• Before running your combined queries, insert the word AND between the two
queries and delete the INPUT, OUTPUT, and SELECT lines in the second query
in order to preserve proper query syntax.
68
IDEA
-------
Summary
At this point, you should be familiar with some of IDEA'S basic features such as the Menu
Interface and the GO Names utility. Test your skills by answering these questions.
1. How do you access IDEA from the EPA mainframe?
2. How do you select the Menu Interface?
3. How do you generate an IDEA query using the Menu Interface?
4. How do you select the Keyword Interface?
5. How do you set up a member? Why do you need to?
6. How do you access the GO Names facility?
7. Why does GO Names return information to the Keyword editor?
8. How do you get a report from a GO Names query?
9. How can you switch from one report to another?
10. How do you navigate IDEA reports?
Student Booklet
69
-------
Logging Off
To exit IDEA at any time follow these procedures:
~ Use the END command or PF3 key to back out of the program screen by screen
until you reach the TSO READY prompt, type LOGOFF, and press < Enter >
to exit the IBM Mainframe.
~ Use the RETURN command (PF4 key) to return directly to the OFFICE OF
ENFORCEMENT DATA INTEGRATION PRIMARY MENU. You may then type I
(for IDEA) at the OPTION prompt to get back to the IDEA WELCOME
SCREEN, or type X to exit to the TSO READY prompt. Type LOGOFF at the
READY prompt, and press < Enter > to exit the IBM Mainframe.
~ Type =X at the COMMAND line to go directly to the TSO READY prompt.
Type LOGOFF, and press < Enter > to exit the IBM Mainframe.
When an ISPF session is initiated for a user, the system creates two datasets, LOG and
LIST, in which information can be recorded during the ISPF session. This activity
happens without direct user participation. When you attempt to leave the IBM Mainframe,
the screen shown in Figure 73 may appear before you reach the TSO READY prompt.
On this screen, you are asked to specify how you wish to dispose of the LOG/LIST
datasets.
70
IDEA
-------
\»- SPECm »i$PCSlIJOU OF tOB AK3 U$T CATA &7
CQMttW ***>
LOG DATA WT OPHWS
UST SAT* XT DPTIOW
Procw» option «*» 0
symot ct«sa »" a
Process option **~» ft
STSOUT elaa*' **»*
local prtntar !9 «»*> 8605
I oca* printer 10 «««»
Lines per page ***> SO
Primary pages »»*>
Secondary page* »»»> 200
Lines per pa$e **»> 60
~rijBiwy pagw ***> 0
Secondary pages «»*» 0
VM.TD PR0C£S€ OPTIONS;
P& - Print dot* set and delete 0 * Berate ttet# set twitft$«t printing
K K«p
Kit * K^ep data set and allocate new data Ml
S1AT»«*T mfOMttTSOK: tSequirerf ior lyste* printer)
«¦*> //P«» *B «0W>,fSTRAW*
i Mt A •• - *> % **
Figure 73. Log and List Data Set Screen
To exit this screen, should it appear, type D at the LOG DATA SET PROCESS OPTION
prompt and press to move the cursor to the LIST DATA SET PROCESS
OPTION prompt. Type D, and press < Enter >. The. READY prompt will appear.
To exit the IBM mainframe, type LOGOFF and press < Enter > at the READY prompt.
xst>» //* -
¦*sm> ff+ -
//*
Student Booklet
71
------- |