I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
united States
Environmental Protection
Agency
Office of Information
Resources Management
Washington DC 20460
EPA/OIRM
EPA
FACILITY AND COMPANY TRACKING SYSTEM (FACTS)
USER'
n
DDDDDOnn
EPA
220/
1988.2
c.2
-------
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
J
FINAL
FACILITY AND COMPANY TRACKING SYSTEM (FACTS)
USER MANUAL
Prepared for:
U.S. Environmental Protection Agency
Prepared by:
SYCOM, Inc.
14532 Lee Road
Chanttlly, Virginia 22021
November 30, 1988
FINAL
HEADQUARTERS LIBRARY
ENVIRONMENTAL PROTECTION AGENCY
WASHINGTON. D.C. 20460
CO
OJ
CO
'JJ
-------
BLANK PAGE
-------
I
I
I
I
I
I
FACILITY AND COMPANY TRACKING SYSTEM (FACTS)
USER MANUAL
I
I
I
I
I
I
I
I
I
November 30, 1988
I
-------
BUNK PAGE
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
TABLE OF CONTENTS
TITLE PAGE
1. 0 INTRODUCTION 1-1
1.1 Background 1-1
1.2 Categories of Data in Facts 1-2
1.3 Available Facts Functions 1-2
1. 4 Purpose of Manual 1-2
1.5 Scope of Manual 1-3
1.6 Glossary of Acronyms 1-3
2.0 SYSTEM OVERVIEW 2-1
3.0 SYSTEM OPERATION AND USE 3-1
3 .1 System Access 3-1
3.1.1 Logon Procedures 3-1
3.1.2 Logon Procedures for Dialup
Users 3-7
3.1.3 Logon Procedures for PCs using
IRMALINK 3-8
3.1.4 Logoff Procedures 3-8
3.2 PF Key Definitions 3-9
3.3 Terminal Functions 3-10
3.3.1 Reports 3-12
3.3.2 Online Queries 3-23
3.3.3 Table Lookup 3-32
3.3.4 Data Extracts 3-38
3.3.5 Mailing Label Generation 3-44
4.0 Download Procedures 4-1
Appendix A - Priority Rates
Appendix B - Sample Reports
Appendix C - Data Extract Samples
Hi
-------
List of Figures
Figure
3-1
3-2
3-3
3-4
3-5
3-6
3-8
3-9
3-10
3-11
3-12
3-13
3-14
3-15
3-16
3-17
3-18
3-19
3-20
3-21
3-22
3-23
3-24
3-25
3-26
3-27
3-28
3-29
3-30
3-31
3-32
3-33
3-34
3-35
3-36
3-37
3-38
Description Page
Welcome Screen 3-2
U.S. EPA telecommunications Network
Menu 3-3
Production CICS Screen 3-4
CICS news Alert Facility Screen 3-5
Natural Logon Procedure Screen 3-6
FACTS Main Menu Screen 3-7
FINDS Function Menu 3-11
D&B or TRINET Function Menu 3-12
Report Generator Screen - Page 1 3-14
Report Generator Screen - Page 2 3-16
Batch opcions Screen 3-17
Selected Facilities Report Screen
- Page 1 3-18
Selected Facilities Report Screen
- Page 2 3-21
Batch Options Screen 3-22
Online Queries Menu Screen 3-23
Search Screen 3-24
Facilities List Screen 3-25
Single Facility Display Screen
- Page 1 3-26
Single Facility Display Screen
- Page 2 3-27
Online Queries Menu 3-28
Search FINDS Screen 3-29
Search Screen 3-30
Single Facility Display Screen
- Page 1 3-31
Single Facility Display Screen
- Page 2 3-32
Table Lookup Menu 3-33
SIC Table 3-34
SIC Code Screen 3-35
State Table 3-36
County Table 3-37
County Display Table 3-38
Data Extracts Menu 3-39
Batch Options Screen 3-41
Data Extracts Menu 3-42
Batch Options Screen 3-43
Mailing Label Generation Menu 3-44
Label Selection Screen 3-46
Label Generation Batch Options 3-47
IV
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
-------
SECTION 1.0
INTRODUCTION
-------
BLANK PAGE
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FACTS User Manual
Introduction
SECTION 1.0 INTRODUCTION
1.1 BACKGROUND
One of the essential functions of EPA is the regulation of the
industrial activities of U.S. companies. One of the most
difficult information management tasks we face is to get timely
and accurate information about these companies. Two of the best
compilations of information about U.S. companies are created by
DUN and Bradstreet (D&B) and TRINET. We have acquired these
databases and packaged them along with the Facility Index System
(FINDS) in an easy to use application called Facility and Company
Tracking System (FACTS). FINDS contains information about EPA
regulated facilities. DUN and Bradstreet and TRINET contain
information about U.S. companies. By analogy, if EPA was a
business, FINDS would be our customer list, D&B and TRINET would
be our potential customer list.
The information in FACTS can be used for a variety of regulatory
purposes especially enforcement and regulatory impact analysis.
In enforcement, the data can be used to determine companies that
did not comply with reporting requirements, to determine
potentially responsible parties and to target enforcement
actions. For regulatory impact analysis, the data can identify
the number of companies that would be affected by a new
regulation.
November 1988
-------
FACTS User Manual Introduction
I
1.2 CATEGORIES OF DATA IN FACTS
The company data from D&B and TRINET consist of:
Identifying Information *
Location m
Sales Figures
Employee Counts _
Industrial Classification J
Family Relationships
The facility data from FINDS consist of:
Identifying Information
Location
Cross-references to Regulatory Program Offices at EPA I
1.3 AVAILABLE FACTS FUNCTIONS |
FACTS offers the capability to: I
I
Produce Reports Based on Selected Data
Perform On-line Queries
Display Contents of Supporting Tables
Create Subsets of Data
Generate Mailing Labels
1.4 PURPOSE OF MANUAL
I
The purpose of this manual is to tielp you learn to operate the
FACTS system and to serve as reference material.
I
Page 1-2 November 1988
-------
1
1
FACTS User Manual
Introduction
1.5 SCOPE OF MANUAL
1
This manual contains a glossary of acronyms, a system overview,
access instructions, terminal functions, samples of query
statements,, descriptions of menu formats, procedures, input
1
1
1
|
*
1
1
1
1
I
required, output
options, default values, examples of proper and
improper system use, system files, and download procedures.
1.6 GLOSSARY OF
The following is
CICS
D&B
EPA
FACTS
FIMAS
FINDS
PF
IBM
MSA
OERR
OSW
PC
SAS
SIC
SMSA
TSO
U.S.
November 1988
ACRONYMS
a list acronyms used in this manual.
Customer Information Control System
DUN and Bradstreet
Environmental Protection Agency
Facility and Company Tracking System
Facility impact Monitoring & Analysis System
Facility Index System
Program Function
International Business Machines
Metropolitan Statistical Area
Office of Emergency and Remedial Response
Office of Solid Waste
Personal Computer
Statistical Analysis Software
Standard Industrial Classification
Standard Metropolitan Statistical Area
Time Share Option
United States
Page 1-3
-------
BLANK PAGE
-------
SECTION 2.0
SYSTEM OVERVIEW
-------
BLANK PAGE
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FACTS User Manual
System Overview
SECTION 2.0 SYSTEM OVERVIEW
FACTS is a "read only" system that provides efficient database
design by enabling you to select data elements to satisfy your
requirements. The files are structured to maximize flexibility
and efficiency. Descriptors and data elements are defined to
maximize retrieval efficiency.
The interface to the FINDS-TABLE will improve the accuracy of
data during update. The system is easy to learn and use with
consistent screen and report formats, simplified process flow,
and PF keys.
Page 2-1
November 1988
-------
BLANK PAGE
-------
SECTION 3,0
SYSTEM OPERATION AND USE
-------
BLANK PAGE
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FACTS User Manual
System Operation and Use
SECTION 3.0 SYSTEM OPERATION AND USE
FACTS operates on ~he IBM 3090 mainframe located at EPA
Headquarters. Users located at EPA Headquarters and state and
regional offices are connected through telecommunications.
3.1 SYSTEM ACCESS
To access the system, you will need one of the following types of
equipment:
o IBM 3270 or equivalent terminal connected to the
EPA Network
o Display Terminals or PCs with modems to dial in to
the EPA Network.
The log-on and log-off procedures are discussed below.
3.1.1 Logon Procedures
To logon to the FACTS system, follow the instructions listed.
1. At the Welcome screen (Figure 3-1), type ^m' 'and press
.
November 1988
Page 3-1
-------
FACTS User Manual System Operation and Use
WELCOME TO THE
U.S. ENVIRONMENTAL PROTECTION AGENCY
TELECOMMUNICATIONS NETWORK
ENTER COMMAND OR M FOR MENU
Figure 3-1
1
1
1
1
1
1
1
1
1
1
1
i
2. The U.S. EPA Telecommunications Network menu (Figure 3-
2) will be displayed.
*
i
i
i
i
Page 3-2 November 1988
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FACTS User Manual
System Operation and Use
US EPA TELECOMMUNICATIONS NETWORK MENU
13:34 Tuesday November 22, 1988
NATIONAL COMPUTER CENTER
PFKEY SELECTION
PF13 PCICS
PF14 DCICS
PF19 TSO
PF8 EMAIL
SERVICE
CICS - Production
CICS - Development
TSO - NCC
EMAIL Access
PFKEY
PF15
PF16
PF17
PF20
PF21
PF22
PF23
PF24
PF2
PF3
PF4
PF5
LOGICAL MAINFRAME
SELECTION
NY
DV
WI
SE
AT
DA
KC
PH
CI
BN
CH
SF
TSO
TSO
TSO
TSO
TSO
TSO
TSO
TSO
TSO
TSO
TSO
TSO
SERVICE
- New York LMF
- Denver NEIC LMF
- Wash Info Center
- Seattle LMF
- Atlanta LMF
- Dallas LMF
- Kansas City LMF
- Philadelphia LMF
- Cincinnati LMF
- Boston LMF
- Chicago LMF
- San Francisco LMF
Figure 3-2
3.
"PCICS"
Type "PCICS" or press 'PF-13'. The message "logon
accepted" will be displayed and the Production
CICS screen (Figure 3-3) will be displayed.
November 1988
Page 3-3
-------
PACTS User Manual
System Operation and Use
U.S. ENVIRONMENTAL PROTECTION AGENCY
PRODUCTION CICS
TERM- A2B6
NETNAMG- T22OOS25
USERID:
ACCOUNT:
FIMOS ID:
GROUP:
PASSWORDt
NEW PASSWORD: (OPTIONAL)
INITIAL TRANSACTION!
- NO NEWS (ENTER ANY CHARACTER TO SUPPRESS NEWS ALERTS)
PF1/13I HELP PF3/1S OR CLEARl TERMINATE SIBNON PFl£/2*« LQQOFF
Rgure 3-3
4. Type your USER-ID and press . The system will
automatically display your ACCOUNT, FIMAS ID, and your
GROUP.
5. Enter your password^ The ClCS-News Alert Facility
screen (Figure 3-4) will be displayed.
Page 3-4
November 1988
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
-------
1
FACTS User Manual
1
1
1
1
1
1
11/15/88
11/18/88
11/18/88
11/15/88
11/09/88
11/07/88
11/04/88
11/07/88
System Operation and Use
CICS NEWS ALERT FACILITY
PREFIX: {CICS, ADAS, ALERT, OR BLANK FOR ALL)
NCC-IBM MAINFRAME SEMINARS AT RTP ALERT11
THANKSGIVING HOLIDAY SCHEDULE ALERT12
ADABAS SUNDAY AFTERNOON UNAVAILABILITY ALERT2
CLIST DATA SET CHANGES IN TSO BATCH PROC ALERT3
DELETION OF DATASET SYS1 .PL1 .PL1BASE ALERT4
N'EW TSO KERMIT AVAILABLE FOR TESTING ALERTS
JOB OUTPUT PROTECTION MECHANISM ALERT7
INSTALLATION OF DF/HSM ALERTS
PF1/13: HELP PF3/1S: END ENTER: VIEW PF7/19: PREV PAGE PFB/20: NEXT PAGE
1
1
4
M A *
6. Press ;XPF 3/15' or to clear the screen.
7. Type xnssp'. The Natural Logon Procedure screen
{Figure 3-5) will be displayed.
November 1988
Page 3-5
-------
FACTS User Manual System Operation and Use
.*.»* MATURAL LCGON PROCEDURE ««**«
ENTER APPLICATION- ID: USER- ID: UTB
PASSWORD: MEW-PASSWORD:
FOR A LI2T CF APPLICATIONS CURRENTLY AVAILABLE FOR SELECTION,
2NTER ':?' AS THE APPLICATION- ID.
TO TERMINATE NATURAL, ENTER 'FIN' AS THE APPLICATION-ID.
FOR MORE KELP, £NTER A '?' AS THE APPLICATION-ID.
Figure 3-5
1
1
1
1
1
1
1
1
1
1
1
8. Type 'fact 21'; and press . The FACTS Main Menu I
screen (Figure 3-6) will be displayed.
1
1
1
I
Page 3-6 November 1988
1
-------
1
1
FACTS User Manual System Operation and Use
1
1
1
^^p
1
1
I
^PJ
1
1
3
1
NSSD U.S. ENVIRONMENTAL PROTECTION AGENCY 11/08/88
FACTSDEV FACILITY AND COMPANY TRACKING SYSTEM 11:55:14
FAMDOOP MAIN MENU FAMDOOM
i. FINDS
2. DUN & BRADSTREET
3 . TRINET
SELECT ONE OF THE ABOVE FUNCTIONS:
PF1/13 = HELP PF4/16 = EXIT
Figure 3-6
.1.2 Loaon Procedures for Dialup Users
If you are accessing the system using a PC with a modem and the
software communication package 'CROSSTALK', you will need to
do
* the following:
1
1
I
1
1
1. Make sure your communication settings are:
Data Bit = 7
Stop Bit = 1
Parity = Even
Emulation = VT100
November 1988 Page
3-7
-------
FACTS User Manual System Operation and Use
3.1.3
3.1.4
Use
F
2. Dial the access number for your area. You can get the
phone number from the Washington Information Center at
(202) 488-5900. 3e sure to ask for the number for the
protocol converter (CX-80) .
3. When you hear the connect signal, hold down the 'm'
key. When the system senses your response, it will
display the letters 'CX-80'. The Welcome screen
(Figure 3-1) will appear and you can proceed as
described in section 3.1.1.
Loaon Procedures for PCs usina IRMALINK.
1. Logon to your PC.
2. Transfer to the directory containing the IRMA software.
3. Start the terminal emulator. (Type E78 or press the two
shift keys simultaneously.) The welcome screen will be
displayed (Figure 3-1) . You can logon to the system
using instructions in section 3.1.3
Logoff Procedures
the following procedures to logoff of the system.
1. From the Main Menu, type XPF 4' or XPF 16'. The "NEXT"
prompt will be displayed.
2. At the "NEXT" prompt, type 'FIN' and press . A
blank screen will be displayed.
'age 3-8 November 1988
1
1
1
1
1
1
1
1
*
1
I
w
1
1
1
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FACTS User Manual
System Operation and Use
3. Type 'cssf logoff and the Welcome screen (See Figure
3-1) will be displayed.
3.2 PF KEY DEFINITIONS
The following PF keys are accessible for all of the FACTS
subsystems:
1. PF 1/13 Help
Will bring up the help screen, returns to screen in
process when is pressed.
2. PF 3/15 Previous Page
Returns to previous menu.
3. PF 4/16 Main Menu
Returns to FINDS, DUN & BRADSTREET, and TRINET menu.
4. PF 5/17 Restart List
Redisplays a series of screens starting at the
beginning of the list currently being displayed.
NOTE: Function keys and their use may be different for PCs
than for 3270 terminals. Consult your manual or
emulator instructions for specifics.
November 1988
Page 3-9
-------
I
FACTS User Manual System Operation and Use
3.3 TERMINAL FUNCTIONS
The FINDS, D&B, and TRINET menus perform mostly the same
functions and the procedures to use these functions are tt
basically the same for each subsystem.
From the Main Menu Screen, type either rl', X2', or X3' to select |
the subsystem you want to use. The next screen you see will be
either Figure 3-8 for the FINDS Function Menu or Figure 3-9 for I
the D&B or TRINET Function Menu, depending on the subsystem you
select. Note that the D&B menus are used in this manual to 8
represent both D&B and TRINET subsystems because they are
basically the same with minor differences. Each selection allows
you to select one of the four functions listed below:
o Reports m
o Online Queries
o Table Lookup
o Data Extracts
o Mailing Label Generation (D&B and TRINET menus only). I
o Reload Database (D&B and TRINET menus only). This is a
System Manager function and will not be addressed in
this manual. *
I
I
I
I
*
I
Page 3-10 November 1988
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
1
FACTS User Manual
System Operation and Use
NSSD
FACTSDEV
FAMFOQP
PF1/13 = HELP
U.S. ENVIRONMENTAL PROTECTION AGENCY i 1/08/88
FACILITY INDEX SYSTEM 11:55:36
FINDS FUNCTION FAMFOOM
REPORTS
2. ONLINE QUERIES
3. TABLE LOOKUP
4. DATA EXTRACTS (CREATES A FILE)
SELECT ONE OF THE ABOVE FUNCTIONS (1-4) : .
PF3/15 = FINDS MAIN MENU PF4/16 = MAIN MENU
Figure 3-8
November 1988
Page 3-11
-------
:ACTS User Manual
NSSD
FACTSDEV
FAMD01P
1
1
System Operation and Use
1
1
U.S. ENVIRONMENTAL PROTECTION AGENCY 11/08/88
FACILITY AND COMPANY TRACKING SYSTEM 12:13:47
DUN & BRADSTREET FUNCTION FAMD01M |
1. REPORTS
2. ONLINE QUERIES
3. TABLE LOOKUP
1
1
4. DATA EXTRACTS (CREATES A FILE)
5. MAILING LABEL GENERATION
6. RELOAD DATABASE
^^»
SELECT ONE OF THE ABOVE FUNCTIONS:
PF1/13 = HELP PF3/15 = D4B MAIN MENU
3.3.1
If you
general
lists of
D&B and
Figure 3-9
Reports
.:. i
PF4/16 = MAIN MENU
1
1
select Option 1 from the above menu, you will see a ~~
report screen that will enable you to generate printed
facilities.
TRINET allow you to select
M
records based on location/
SIC, SMSA, sales volume, or number of employees. These
subsystems also allow you to select a report break which must be
one of the selected sort criteria.
I
Page 3-12
November 1988
r
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FACTS User Manual
System Operation and Use
FINDS allows you to select by Location, Federal Facility, or
Program Office and gives you a choice of four report formats.
You must specify the selection criteria, sort sequence, and
report format. Selection Criteria is mandatory, Report Format
defaults to List, Sort defaults to State Name.
Follow the procedures listed below to use the Reports menu from
the subsystems.
DUN AND BRADSTREET AND TR1NET
D&B screens are used here because the screens are basically the
same for both D&B and TRINET. The procedures are the same.
1. On the Report Generator screen (Figure 3-10), enter the
SELECTION CRITERIA.
November 1988
Page 3-13
-------
FACTS User Manual
System Operation and Use
NSSD U.S. ENVIRONMENTAL PROTECTION AGENCY 11/08/88
FACTSDEV FACILITY AND COMPANY TRACKING SYSTEM 12:14:00
FARD03P DUN S. BRADSTREET
FUNCTION "ARD03M1
REPORT GENERATOR Page 1
SELECTION CRITERIA (SPECIFY ONE OR MORE OF
THE FOLLOWING)
REGION: STATE : (STATE IS REQUIRED FOR COUNTY NAME/CODE AND CITY)
AND CITY :
AND COUNTY NAME :
AND PRIMARY SIC CODE (RANGE) :
AND NUMBER OF EMPLOYEES (RANGE) :
AND SALES VOLUME (RANGE) :
/ COUNTY CODE :
*
TO / SMSA CODE :
TO
TO
PF1/13 - HELP PF3/15 = PREVIOUS MENU PF4/16 - MAIN
Figure 3-10
1
1
1
1
I
1
1
I
-
1
1
1
All selection criteria are optional but you must enter 1
at least one. The selection criteria can be any
combination of:
a. REGION - must be a
or right justified) .
b. STATE - must be
abbreviation.
c. CITY
Page 3-14
1
number between 1 and 10 (left
a valid 2-character state m
1
1
1
November 1988 _
-------
I
1
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FACTS User Manual
System Operation and Use
d. COUNTY NAME - muse exist on the County Table. If
a county name, county, code, or city is entered,
state is required. County Code must be a valid
county code for the state.
e. PRIMARY SIC - must be a valid entry on the SIC
Code Table.
f. SMSA
g. NUMBER OF EMPLOYEES
h. SALES VOLUME
NOTE: If a beginning of range (SIC CODE, NUMBER OF
EMPLOYEES, or SALES VOLUME) is specified, an end of range is
required. Beginning of range must be smaller than end of
range.
2. Press . The system will display the second
screen for this function (Figure 3-11).
November 1988
Page 3-15
-------
I
FACTS User Manual
System Operation and Use
NSSD U.S. ENVIRONMENTAL PROTECTION AGENCY 11/08/88
FACTSDEV FACILITY AND COMPANY TRACKING SYSTEM 12:14:00
FARD03P DUN & BRADSTREET FUNCTION FARD03M2
REPORT GENERATOR Page 2
REPORT FORMATS -
1. LIST OF FACILITIES (ONE LINE PER FACILITY)
2. DETAILED INFORMATION (FOUR LINES PER FACILITY)
(FORMAT WILL BE DEFAULTED TO ' 1' , IF ONLY REGION
SELECT ONE OF THE ABOVE REPORT FORMATS (1-2) :
SORT SEQUENCES (OPTIONAL) -
1. NAME 2. STATE
5. COUNTY 6. SALES VOLUME
SELECT A MAJOR SORT SEQUENCE (1-8)
SELECT A SECOND SORT SEQUENCE (1-8)
SELECT A THIRD SORT SEQUENCE (1-8)
ENTER DESIRED REPORT NAME :
PF1/13 « HELP PF3/15
3. CITY
7. NUMBER OF
- PRBV
WAS SELECTED)
4. SIC CODE
EMPLOYEES 8. ZIP CODE
PF4/16 - MAIN
Figure 3-11
3. Select a REPORT FORMAT by entering 1 or 2. Appendix B
contains samples of reports. If no number is entered,
1 is assumed.
4. Enter the number of the data item to be used as the
MAJOR SORT item on the report. The SORT criteria must
be between 1 and 5. If no SORT is selected, State and
County are assumed.
5. Enter the number of the data item to be used as the
SECOND SORT item on the report.
Page 3-16
November 1988
1
1
-------
1
1
FACTS User Manual
1
1
P
1
1
1
1
1
1
1
1
1
1
1
1
1
1
6. Enter the
THIRD SORT
7. Enter the
Pagebreak
System Operation and Use
number of the data item to be used as the
item on the report.
number of the data item to be used as e
control. The bi.. -K must be a number selectee
for SORT criteria. If no break is specified, none i£
assumed.
8. Press . The system will display the Batct
Options screen (Figure 3-12) .
NSSD U.S. ENVIRONMENTAL PROTECTION AGENCY 11/08/88
FACTSDEV FACILITY AND COMPANY TRACKING SYSTEM 12:14:32
FAZDQ3P BATCH OPTIONS FAZD03M
DEFAULT OPTIONS (CHANGE IF NECESSARY) :
ACCOUNT -
BIN -
DESTINATION - (EG. RMT255, N"7)
PRIORITY - 1
TIME - 02,00
PF3/15 = PREVIOUS MENU PF4/16 = MAIN MENU
November 1988
Figure 3-12
Page 3-1
-------
FACTS User Manual
System Operation and Use
9.
10
Enter ACCOUNT, BIN, and DESTINATION. Change PRIORITY
and TIME if desired. ACCOUNT, BIN, and DESTINATION
must be filled in. Appendix A shows the relative
charge factor for PRIORITY selected.
Press and the system will submit a batch job to
generate the report. Appendix B show sample reports.
FINDS
i.
Enter I for the Selected Facilities Report Screen
(Figure 3-13) .
NSSD U.S. ENVIRONMENTAL PROTECTION AGENCY
FACTSDEV FACILITY INDEX SYSTEM
FARF10P SELECTED FACILITIES LIST Page
SELECTION CRITERIA (SPECIFY ONE OR MORE OF THE FOLLOWING) :
REGION : . . AND
AND CITY :
AND COUNTY NAME : / COUI
AND FEDERAL FACILITY : . (Y OR BLANK)
AND REGULATED BY - 1. OFFICE OF SOLID WASTE (OSW)
2. WATER ENFORCEMENT AND PERMITS (OWEP)
3. AIR AND RADIATION (OAR)
4. PESTICIDES & TOXIC SUBSTANCES (OPTS)
5 . SUPERFUND (OERR)
6. ENF AND COMPLIANCE MONITORING (OECM)
7. DRINKING WATER (ODW)
8. CHEMICALS IN COMMERCE (OTS)
9. STATE PROGRAM OFFICES
SELECT FACILITIES REGULATED BY ALL OF THE SELECTED PROGRAMS
-OR- FACILITIES REGULATED BY ANY OF THE SELECTED PROGRAMS
PF1/13 - HELP PF3/15 = PREVIOUS MENU PF4/16
11/08/88
11:56:58
1 FARFIOM
STATE : . .
1TY CODE : ...
(Y OR BLANK)
(Y OR BLANK)
(Y OR BLANK)
(Y OR BLANK)
(Y OR BLANK)
(Y OR BLANK)
(Y OR BLANK)
(Y OR BLANK)
(Y OR BLANK)
(Y OR BLANK)
(Y OR BLANK)
= MAIN MENU
Figure 3-13
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Page 3-18
November 1988
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FACTS User Manual
System Operation and Use
2.
Enter the SELECTION CRITERIA. All selection criteria
are optional but you must enter at least one. The
selection criteria can be any combination of:
a.
b.
c.
d.
e.
REGION - must be a number between 1 and 10 (left
or right justified).
STATE - must
abbreviation.
be a valid 2-character state
COUNTY - name must exist on the County Table.
County Code must be a valid country code for the
state.
FEDERAL FACILITIES ONLY - must be xy' or blank.
PROGRAM OFFICES - must be xy' or blank. Indicate
whether the report will include only facilities
monitored by all of the selected program offices
or whether it will include facilities monitored
by any of the selected program offices.
If program offices are selected, one of the two
options, facilities monitored by all of the
selected program offices or facilities monitored
by any of the selected program offices must be
selected. Example: If ^Office of Solid Waste'
and 'Superfund' are selected with the all option,
a facility must be monitored by both OSW and OERR
to appear on the report. However, if OSW and OERR
are selected with the any option, the resulting
November 1988
Page 3-19
-------
FACTS User Manual
System Operation and Use
1
1
1
report will contain facilities monitored by either
OSW or OERR.
NOTE: A facility
on a report may be monitored by
other program offices in addition to the ones
indicated in the
example, the any
selection. If in the above
option is chosen for a MATRIX
format, the additional program offices will be
xX'd along with
either of the selected program
1
1
offices. This may appear to be confusing unless
you keep in mina the basic rules.
If no program offices are selected, facilities
will appear on
office monitors
the report regardless of which
them. This is equivalent to
selecting all program offices with the any option
and will cause the program to run more
efficiently.
3. Press . The
system will display the second
screen for this function {Figure 3-14) .
Page 3-20
November 1988
1
I
1
1
1
1
1
1
1
w
-------
FACTS User Manual
System Operation and Use
NSSD
FACTSDEV
FARF1QP
U.S. ENVIRONMENTAL PROTECTION AGENCY
FACILITY INDEX SYSTEM
SELECTED FACILITIES LIST
11/08/88
11:56:58
FARF10M2
REPORT FORMATS -
1. LIST OF FACILITIES (ONE LINE PER FACILITY)
2. MATRIX SHOWING PROGRAM OFFICES THAT MONITOR EACH FACILITY
3. MATRIX OF FACILITY IDS ASSIGNED BY PROGRAM OFFICES FOR EACH FACILITY
4. DETAILED INFORMATION (FOUR LINES PER FACILTY)
SELECT ONE OF THE ABOVE REPORT FORMATS (1-4) : .
SORT SEQUENCES (OPTIONAL) -
1. REGION 2. STATE 3. COUNTY
6. EPA ID 7. FACILITY NAME
SELECT A MAJOR SORT SEQUENCE (1-7) : .
SELECT A SECOND SORT SEQUENCE (1-7) : .
SELECT A THIRD SORT SEQUENCE (1-7) : .
4. CITY
5. ZIP CODE
PF1/13 = HELP
PF3/15 = PREVIOUS MENU
PF4/16 = MAIN MENU
Rgure 3-14
4. Select a REPORT FORMAT by entering a number between 1
and 4. If no number is entered, 1 is assumed.
Appendix B contains samples of reports.
5. Enter the number of the data item to be used as the
MAJOR SORT item on the report.
6. Enter the number of the data item to be used as the
SECOND SORT item on the report.
November 1988
Page 3-21
-------
1
FACTS User Manual System Operation and Use
1
7. Enter the number of trie data item to be used as the
THIRD SORT irem en the report .
8. Press . The system will display the Batch
Options screen (Figure 3-15} .
1
NSSD U.S. ENVIRONMENTAL PROTECTION AGENCY 11/08/88
FACTSDEV FACILITY AND COMPANY TRACKING SYSTEM 11:57:30
FAZF10P BATCH OPTIONS FAZD03M
DEFAULT OPTIONS (CHANGE IT NECESSARY) :
ACCOUNT -
BIN -
DESTINATION - (EG. RMT255, N7)
PRIORITY - 2
TIME - 00,15
PF3/15 = PREVIOUS MENU PF4/16 = MAIN MENU
1
1
1
1
figure 3-15
9. Enter ACCOUNT, BIN, and DESTINATION. Change PRIORITY
and TIME if desired. Press and the system will
submit a batch job to generate the report. The
ACCOUNT, BIN, and DESTINATION must be filled in.
Appendix B shows the relative charge factor for
PRIORITY selected.
I
I
I
I
I
Page 3-22
November 1988
-------
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
FACTS User Manual System Operation
and Use
3.3,2 Online Queries
This function includes search and display capabilities for
companies and their families-parents, subsidiaries, headquarters,
and branches. The procedures for using this function on the
*
subsystems are listed below.
DUN AND BRADSTREET AND TRINET
The D&B screens are used here. However, the TRINET screens are
essentially the same with minor differences.
1. From the D&B or TRINET Main Menu, select X2' . The
Online Queries menu screen (Figure 3-16) will be
displayed.
NSSD U.S. ENVIRONMENTAL PROTECTION AGENCY
FACTSDEV FACILITY AND COMPANY TRACKING SYSTEM
FAQD04PO DUN 6 BRADSTREET FUNCTION
ONLINE QUERIES MENU
1. SEARCH D S B FILE
2. DISPLAY DETAILED D 6 B INFORMATION
3. DISPLAY D&B PARENT/HQ COMPANY
4. DISPLAY D&B SUBSIDIARIES /BRANCHES
SELECT ONE OF THE ABOVE FUNCTIONS : _
(ENTER DUNS NUMBER FOR FUNCTIONS 2 - 4) :
11/08/88
12:15:31
FAQD04M1
PF1/13 = HELP PF3/1S = PREV PF4/16 = MAIN
Figure 3*16
November 1988
*
Page 3-23
-------
FACTS User Manual
System Operation and Use
2. Enter the desired number, 1-4. The Search screen
(Figure 3-17) will be displayed when Option 1 is
selected.
NSSD
FACTSDEV
FAQD04P1
U.S. ENVIRONMENTAL PROTECTION AGENCY
FACILITY AND COMPANY TRACKING SYSTEM
DUN & BRADSTREET FUNCTION
SEARCH D & B FILE
11/08/88
12:15:42
FAQD04M2
SELECTION CRITERIA (SPECIFY ONE OR MORE OF THE FOLLOWING):
STATE :
NAME :
COUNTY :
CITY :
SMSA CODE :
OR COUNTY CODE :
SIC CODE (RANGE)
PF1/13 = HELP
TO
PF3/1S - PREV
PF4/16 = MAIN
Figure 3-17
3. Enter the SELECTION CRITERIA. The selection criteria
can be one of or any combination of:
a. STATE
b. NAME
C. COUNTY or COUNTY CODE
Page 3-24
November 1988
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FACTS User Manual
System Operation and Use
d. CITY
e. SMSA CODE (D&B) or MSA CODE (TRINET)
f. SIC CODE
4. The Facilities List screen {Figure 3-18) will be
displayed.
NSSD U.S. ENVIRONMENTAL PROTECTION AGENCY
FACTSDEV FACILITY AND COMPANY TRACKING SYSTEM
FAQD04P2 DON & BRADSTREET FUNCTION
FACILITIES LIST PAGE NO.
1
2
3
4
5
6
7
8
9
10
11
12
NAME
BRYANTS CONVENIENT STO
FALLS CHURCH BOWL INC
ROARK OR JOHN WHITSON
MEDIAMATICS INC
PENDERSON ASSOCIATES IN
RENTAL UNF SVC OF LANC
LEMON TWIST OF VIRGINI
BESTPAK INC
S AND S INVESTMENTS
REYNOLDS ALUM BLDG PDT
SENTINEL SECURITY INC
HAYMARKET TOWN
ADDRESS
RT 2 BOX 497
6446 EDSALL RD
2500 N VAN DORN S
1500 WILSON OR SU
3231 FORTUNES RID
200 LOVERS LANE
756 C WALKER RD
HWY 15
9019 FOREST HILL
7130 GLEN FORREST
210-A PACKETS COO
14003LAKEVIEW DR
1
11/22/88
13:43:05
FAQD04M5
DUNS NO
SCOTTSVILLE
ALEXANDRIA
ALEXANDRIA
ARLINGTON
MIDLOTHIAN
CULPEPER
GREAT FALLS
FORK UNION
RICHMOND
RICHMOND
WILLIAMSBUR
HAYMARKET
VA
VA
VA
VA
VA
VA
VA
VA
VA
VA
VA
VA
24590
22312
22302
22290
23113
22701
22066
23055
23235
23226
23185
22069
001155126
001081553
001084045
001183565
001191097
001019793
001038546
001023670
001010982
001180223
001112853
001123694
SELECT FOR DETAIL SCREEN :
PF1/13 - HELP
PF3/15 - PREV
PF4/16
- MAIN
5.
Figure 3-18
Select a number from 1-12.. The Single Facility Display
screen (Figure 3-19) will be displayed.
November 1988
Page 3-25
-------
FACTS User Manual
NSSD
FINDDEVL
FIQD04P1
FACILITY NAME
SECONDARY NAME
System Operation and Use
U.S. ENVIRONMENTAL PROTECTION AGENCY 09/12/88
FACILITY AND COMPANY TRACKING SYSTEM 14:45:52
DUN £ BRADSTREET DISPLAY FIQ004M3
TELEPHONE
FACILITY ADDRESS CITY CODE
COUNTY CODE
MAILING ADDRESS
ULTIMATE DUNS
HQ/BR
NUMBER HEADQUARTER DUNS NUMBER
SUBSIDIARIES YEAR STARTED SMSA
LIKE OF BUSINESS MAUFACTURING
SIC CODES
CONTINUE TO NEXT PAGE (Y) : _ LIST SUBS/BRANCHES (Y) : _ LIST PARENT (Y) :
PF1/13 = HELP PF3/15 - PREV PF4/16 - MAIN .
Figure 3-19
1
1
1
1
1
I
I
1
I
1
1
1
6. Press to go to the next page. The next page
(Figure 3-20) will be displayed. Press to return to
the Facility
Page 3-26
Name Search screen.
*
1
1
1
1
1
November 1988
-------
1
1
FACTS User Manual System Operation and Use
1
1
1
1
1
1
1
I
NSSD U.S. ENVIRONMENTAL PROTECTION AGENCY 09/12/88
FINDDEVL FACILITY AND COMPANY TRACKING SYSTEM 14:45:52
FIQD04P1 DUN 6 BRADSTREET DISPLAY FIQD04M4
PRINCIPAL OFFICER/TITLE
SALES NET WORTH
EMPLOYEES THIS LOCATION TOTAL EMPLOYEES FOR COMPANY
BASE YEAR SALES BASE YEAR EMPLOYMENT
LIST SUBSIDIARIES {Y) _ LIST PARENT (Y)
PF1/13 - HELP PF3/15 - PREV PF4/16 - MAIN
Figure 3-20
* FINDS
1
1
1
1
1
1
1. From the FINDS Main Menu, type ^2' . The Online Queries
menu (Figure 3-21) will be displayed.
November 1988 Page 3-27
-------
FACTS User Manual
System Operation and Use
NSSD U.S. ENVIRONMENTAL PROTECTION AGENCY 11/08/88
FACTSDEV FACILITY INDEX SYSTEM 12:04:47
FAQFOOP ONLINE QUERIES MENU FAQFOOM
1. SEARCH FINDS DATABASE
2. DISPLAY DETAILED FACILITY INFORMATION
SELECT ONE OF
FOR OPTION 2,
AND PROGRAM C
THE ABOVE OPTIONS : .
ENTER EPA-ID :
OR PROGRAM OFFICE : 0.
FFICE FACILITY ID :
PFI/13 - HELP PF4/16 = MAIN MENU
1
, 1
1
1
1
1
1
1
1
1
1
1
Figure 3-21
2. Enter the desired selection number, *!' or '2' . Option
2 requires an EPA-ID number or a Program Office
Regional Facility-ID.
3. If Option
and
1 is selected, the Search FINDS menu (Figure 1
3-22) will be displayed. EPA-ID or Program Office
ID are required for Option 2.
Page 3-28
November
and
1
1
1988 i
-------
1
1 ,
1
1
1
1
w
1
1
1
1
1
1
1
1
1
=ACTS User Manual System Operation and Use
NSSD UNITED STATES ENVIRONMENTAL PROTECTION AGENCY 11/08/88
FACTSDEV FACILITY INDEX SYSTEM 12:04:59
FAQF10P SEARCH FINDS FAQF10M1
STARTING POINT FOR AN ALPHABETIC LIST CF FACILITIES:
STATE : . .
NAME '
RESTRICT THE SEARCH TO:
ZIP CODE : 0
PF1/13 » HELP PF3/15 - PREVIOUS SCREEN PF4/16 - MAIN MENU
Figure 3-22
4. Enter the State, Name, and Restriction. The next
Search screen will be displayed (Figure 3-23) .
You must enter at least the State in this screen.
November 1988 Page 3-29
-------
FACTS User Manual
System Operation and Use
NSSD UNITED STATES ENVIRONMENTAL PROTECTION AGENCY 11/08/88
FACTSDEV FACILITY INDEX SYSTEM 12:04:59
FAQF10P FACILITY NAME SEARCH FAQF10M2
SEARCHING FROM ' '
* FACILITY NAME
1 A A F E S NEWPORT NEWS
2 A M F BOWLING -COMPANIE
3 APAC - VIRGINIA INC FI
4 ATLANTIC YACHT BASIN
5 BLACK, W L & ASSOCIATE
6 CALL, DOUGLAS CO INC
7 CAMERON STATION
8 CHAUTAUQUA AIRLINES IN
9 COMPUGRAPHIC CORPORATI
10 CONAGRA FROZEN FOODS
11 DISPOSABEST
12 FELDSPAR CORP THE
SfiLECT FOR DETAIL SCREEN:
* ADDRESS <
231 ENTERPRISE D
DAVID ROAD
ROUTE 50 W 1.5 M
2615 BASIN ROAD
912-D LIVE OAK D
5741 BAYSIDE ROA
TEST STREET
LYNCHBURG MUNICI
4200 WILSON BLVD
ROUTE 240 WEST
10132 G COLVIN R
RT 1
* C I T Y
NEWPORT NEWS
MECHANICSVILLS
CHANTILLY
CHESAPEAKE
CHESAPEAKE
VIRGINIA BEACH
ALEXANDRIA
LYNCHBURG
ARLINGTON
CROZET
GREAT FALLS
MONTPELIER
*Z I ?* EPA-ID
23603 VA0210090015
23111 VAD982366213
22021 VAD053092268
23320 VAD003174133
23320 VAD982567323
23455 VAD081758377
22314 VA4210220139
24506 VAD982364689
22203 VAD98257S334
22932 VAD10172B525
22066 VAD122314412
23192 VAD046991089
PF3/15 » PREVIOUS MENU PF4/16 » MAIN MENU ENTER = ACCEPT INPUT/SCROLL FWD
Figure 3-23
5. Select a number from 1-12, press . The Single
Facility Display screen (Figure 3-24) will be
displayed.
Page 3-30
November 1988
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
-------
1
* FACTS User Manual
1
1
1
I
w
1
System Operation and Use
NSSD
FACTSDEV
FAQF20P
EPA ID NUMBER
FACILITY NAME
ADDRESS
COUNTY
OWNER TYPE
LATITUDE
LONGITUDE
SIC CODES
INDIAN LAND
COMMENTS
U.S. ENVIRONMENTAL PROTECTION AGENCY
FACILITY INDEX SYSTEM
SINGLE FACILITY DISPLAY (PAGE 1 OF 2)
VAD982366213
A M F BOWLING COMPANIES
DAVID ROAD
MECHANICSVILLE
HANOVER
PRIVATE
000000
0000000
0 : 0 : 0 :
N
PF3/15 » PREVIOUS MENU
INC
, VA 23111
CONG. DISTRICT :
OPERATOR TYPE :
LAT-LONG SOURCE :
LAT-LONG ACCURACY:
0 : 0 : 0
FEDERAL FACILITY :
a
:
PF4/16 - MAIN MENU
11/08/88
12:06:30
FAQF20M
0
F
I
I
I
I
I
I
I
Figure 3-24
6. Press for the next page (Figure 3-25)
November 1988
Page 3-31
-------
FACTS User Manual
System Operation and Use
NSSD U.
FACTSDEV
FAQF21P
S. ENVIRONMENTAL PROTECTION AGENCY 11/08/88
FACILITY INDEX SYSTEM 12:05:50
SOURCE PROGRAM OFFICE INFORMATION FAQF21M
VAD982366213 : A M F BOWLING COMPANIES INC DAVID ROAD
MEGHAN ICSVILLE 23111
OFFIC PROGRAM SYSTEM FACILITY-IDS USED BY SOURCE PROGRAM SYSTEMS
OSW SOLID WASTE
OWEP WATER ENF&PERMIT
OAR AIR & RADIATION
OPTS FIFRA/TSCA ENF
OERR SUPERFOND
OECM ENF6COMPL MONITOR
OH FEDERAL UNDERGRND
OTS TOXIC SUBST INVEN
STAT STATE PROGRAMS
ODW DRINKING WATER
OW SURFACE IMPOUND
HWDMS
PCS
CDS
FATES
CERCLA
DOCKET
FURS
CICIS
FRDS
SIA
VAD982366213
PF3/15 = PREVIOUS SCREEN PF4/16 - MAIN MENU
Figure 3-25
7. Type XPF 3/15' to return to previous screen or press
to go back to the Searching From screen.
3.3.3 Table Lookup
This function allows you to browse the state and county tables
from any of the subsystem menus (FINDS, D&B, TRINET). The FINDS
Table Lookup menus are used here as examples since all of the
menus are the same. The procedures for all subsystems as
follows.
Page 3-32
November 1988
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FACTS User Manual
System Operation and Use
1. From either of the subsystem main menus, type 3, and
press . The Table Lookup menu (Figure 3-26)
will be displayed.
NSSD
FACTSDEV
FATD05PO
S. ENVIRONMENTAL PROTECTION AGENCY
ITY AND COMPANY TRACKING SYSTEM
DUN & 3RADSTREET FUNCTION
TABLE LOOKUP
11/08/88
12:17:08
FATD05M1
1. SIC TABLE
2. STATE TABLE
3. COUNTY TABLE
SELECT ONE OF THE ABOVE FUNCTIONS
PF1/13 = HELP
PF4/16 = MAIN
Figure 3-26
2. If you select 1, the SIC Table (Figure 3-27) will be
displayed.
November 1988
Page 3-33
-------
FACTS User Manual
System Operation and Use
NSSD U.S. ENVIRONMENTAL PROTECTION AGENCY
FACTSDEV FACILITY AND COMPANY TRACKING SYSTEM
FATD05P1 TABLE LOOKUP
SIC TABLE
DISPLAY SIC VALUES
STARTING FROM SIC CODE :
PF1/13 = HELP PF3/15 - PREV PF4/16
11/08/88
12:17:22
FATD05M7
= MAIN
Rgure 3-27
3. Press and a SIC CODE screen (Figure 3-28) will
be displayed.
Page 3-34
November 1988
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FACTS User Manual
System Operation and Use
NSSD
FACTSDEV
FATD05P1
U.S. ENVIRONMENTAL PROTECTION AGENCY
FACILITY AND COMPANY TRACKING SYSTEM
TABLE LOOKUP
SIC TABLE
11/22/88
13:39:36
FATD05M8
SIC CODE DESCRIPTION
3111 Leather Tanning 4 Finishing-Mfrs
3131 Footwear Cut Stock-Mfrs
3142 House Slippers-Mfrs
3143 Men's Shoes Except Athletic-Mfrs
3144 Ladies' Shoes Except Athletic-Mfrs
3149 Footwear Except Rubber nec-Mfrs
3151 Leather Gloves & Mittens-Mfrs
3161 Luggage-Mfrs
3171 Womena' Handbags-Mfrs
3172 Personal Leather Goods-Mfrs
3199 Leather Goods nec-Mfrs
3211 Flat Glass-Mfrs
ENTER = NEXT PF3/1S = PREVS MENU PF4/16 = MAIN MENU PFS/17 = RE-START
4.
Figure 3-28
If you select 2 from the Table Lookup menu, the State
Table (Figure 3-29) will be displayed.
November 1988
Page 3-35
-------
FACTS User Manual
System Operation and Use
NSSD U.S. ENVIRONMENTAL PROTECTION AGENCY 11/08/88
FACTSDEV FACILITY INDEX SYSTEM 12:17:42
FATD05P2 STATE TABLE DISPLAY FATD05M6
STATE REGION
STATE NAME
AK 10 ALASKA
AL 0 4 ALABAMA
AR 06 ARKANSAS
AS 09 AMERICAN SAMOA
AZ 09 ARIZONA
CA 09 CALIFORNIA
CM 09 NORTHERN MARIANAS
CO 08 COLORADO
CT 01 CONNECTICUT
DC 03 DISTRICT OF COLUMBIA
DE 03 DELAWARE
FL 04 FLORIDA
ENTER = NEXT PF3/15 = PREVS MENU PF4/16 = MAIN MENU PF5/17 = RE-START
Rgure 3-29
1
1
1
1
1
1
1
1
1
1
4. If you select 3 from the Table Lookup menu, the County
Table (Figure 3-30) will
Page 3-36
be displayed.
^v
1
1
1
1
1
November 1988
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FACTS User Manual
System Operation and Use
NSSD
FACTSDEV
FATD05P3
STATE
U.S. ENVIRONMENTAL PROTECTION AGENCY 11/08/88
FACILITY AND COMPANY TRACKING SYSTEM 12:18:00
COUNTY TABLE DISPLAY FATD05M4
- ENTER THE STATE TO BE DISPLAYED -
PF3/15 = PREVIOUS MENU PF4/16 = MAIN MENU
Figure 3-30
5. From this menu, type the State. The next County
Display Table (Figure 3-31) will show information by
county in the state you selected.
November 1988
Page 3-37
-------
FACTS User Manual
System Operation and Use
NSSD
FACTSDEV
FATD05P3
STATE/COUN1
VA 001
VA 003
VA 005
VA 007
VA 009
VA Oil
VA 013
VA 015
VA 017
VA 019
VA 021
VA 023
ENTER- NEXT
U.S. ENVIRONMENTAL PROTECTION AGENCY 11/08/88
FACILITY INDEX SYSTEM 12:18:00
COUNTY TABLE DISPLAY FATD05M5
Y COUNTY NAME ABBREVIATION
ACCCMACK
ALBEMARLE
ALLEGHANY
AMELIA
AMHERST
APPOMATTOX
ARLINGTON
AUGUSTA
BATH
BEDFORD
BLAND
BOTETOURT
PF3/15 = PREVS MENU PF4/16 = MAIN MENU PF5/17 = RESTART LIST
Figure 3-31
3.3.4 Data Extracts
This function is provided to allow you to select portions of the
database to be extracted to a sequential disk file. You can
manipulate these files for statistical analysis using SAS, LOTUS,
or other PC software. You can also copy the sequential file to
diskette or tape and transfer it to your computer. Available
extract types are by: REGION, STATE, and PROGRAM OFFICE.
(Appendix C is a sample standard format of this file.) The
Page 3-38
November 1988
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
-------
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
FACTS User Manual
System Operation and Use
procedures for using this function on the subsystems are listed
below.
DUN AND BRADSTREET AND TRINET
1. From the D&B or TRINET main menu, type M' and press
. The Data Extracts (Figure 3-32) menu will be
displayed.
NSSD
FACTSDEV
FARD06P
U.S. ENVIRONMENTAL PROTECTION AGENCY 11/08/88
FACILITY AND COMPANY TRACKING SYSTEM 12:19:10
DUN & BRADSTREET FUNCTION FARD06M1
DATA EXTRACT MENU
SELECTION CRITERIA (SPECIFY ONE OR MORE OF THE FOLLOWING)
REGION: STATE : (STATE IS REQUIRED FOR COUNTY NAME/CODE AND CITY)
AND CITY :
AND COUNTY NAME : / COUNTY CODE :
AND PRIMARY SIC CODE (RANGE) : TO / SMSA CODE :
AND NUMBER OF
EMPLOYEES (RANGE) : TO
AND SALES VOLUME (RANGE) : TO
ENTER DESIRED FILE
PF1/13 = HELP
2. Enter the
of:
November 1988
NAME :
PF3/15 = PREVIOUS MENU PF4/16 = MAIN
Figure 3-32
selection criteria. It may be a combination
Page 3-39
-------
FACTS User Manual
System Operation and Use
a. REGION - if REGION is entered, STATE must be
entered.
b. STATE
c. CITY
d. COUNTY
e. COUNTY CODE
f. PRIMARY SIC CODE
g. NO. OF EMPLOYEES
h. SALES VOLUME
Enter the eight character unique portion of the
filename you wish to apply to your extract file. The
job output indicates which file name was generated for
your extract file.
After you press , the Batch Options screen
(Figure 3-33) will be displayed.
Page 3-40
November 1088
-------
1
1
FACTS User Manual System Operation
1
1
1
1
1
1
1
1
|
1HP
1
1
1
1
NSSD U.S. ENVIRONMENTAL PROTECTION AGENCY
FACTSDEV FACILITY AND COMPANY TRACKING SYSTEM
FAZD06P 3ATCH OPTIONS
DEFAULT OPTIONS {CHANGE IF NECESSARY) :
ACCOUNT - ....
FIMAS -
BIN -
DESTINATION - (EG. RMT255, N7)
PRIORITY - 1
TIME - 02,00
and Use
11/08/88
12:19:26
?AZD06M
PF3/15 = PREVIOUS MENU PF4/16 = MAIN MENU
Figure 3-33
4. Enter ACCOUNT, BIN, FIMAS, and DESTINATION.
From this
screen, you may press PF3/15 to go back to Data
Extracts menu or PF 4/16 to return to the
ACCOUNT, FIMAS, BIN, and DESTINATION must- be
Main Menu .
filled in.
NOTE: The system prompts you with a message that your
data has been extracted whenever you press
after its completion. It then continues
what you are current 1 ,,-orking on. The
November 1988
to process
job output
v
Page 341
-------
I
FACTS User Manual
System Operation and Use
indicates
extract f
FINDS
1. From the
The Data
NSSD
FACTSDEV
FARF40P
SELECTION CRITERIA
REGION
AND CITY
AND COUNTY NAME
1
which file name was generated for your _
ile.
1
1
1
FINDS Main Menu, type M' and press . »
Extracts menu (Figure 3-34) will
U.S. ENVIRONMENTAL PROTECTION AGENCY
FACILITY INDEX SYSTEM
DATA EXTRACTS MENU
(SPECIFY ONE OR MORE OF THE FOLLOWING) :
: . . AND
.
be displayed. _
1
1
11/08/88
12:10:49
FARF40M
STATE : ..
; / rOUNTV CODE : ...
AND FEDERAL FACILITY : .
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FACTS User Manual
System Operation and Use
3. After you press , the Batch Options screen
(Figure 3-35) will be displayed.
NSSD
FACTSDEV
FAZF40P
U.S. ENVIRONMENTAL PROTECTION AGENCY
FACILITY AND COMPANY TRACKING SYSTEM
BATCH OPTIONS
11/08/88
12:11:06
TAZD03M
DEFAULT OPTIONS (CHANGE ~~ NECESSARY):
ACCOUNT -
BIN -
DESTINATION -
PRIORITY -
TIME -
1
02,00
(EG. RMT255, N7)
PF3/15 = PREVIOUS MENU
PF4/16 = MAIN MENU
Figure 3-35
4. Enter ACCOUNT, BIN, and DESTINATION. From this
screen, you may press PF3/15 to go back to Data
Extracts menu or PF 4/16 to return to the Main Menu.
ACCOUNT, BIN, and DESTINATION must be filled in.
NOTE: The system prompts you with a message that your
data has been extracted whenever you press
after its completion. It then continues to process
what you are currently working on. The job output
November 1988 Page 343
-------
I
FACTS User Manual
System Operation and Use
indicates which file name was generated for your
extract file.
3.3.5 Mailing Label Generation (D&B and TRINET only)
This function generates mailing labels based on location,
selected SIC codes, SMSA, number of employees and/or sales
volume. Perform the following procedures to generate mailing
labels.
1. From the D&B or TRINET main menu, type X5', and press
. The Mailing Label"Generation menu (Figure 3-
36) will be displayed.
NSSD
FACTSDEV
FALD07P
U.S. ENVIRONMENTAL PROTECTION AGENCY
FACILITY AND COMPANY TRACKING SYSTEM
DUN & BRADSTREET FUNCTION
MAILING LABEL GENERATION
11/08/68
12:19:54
FALD07M1
SELECTION CRITERIA (SPECIFY ONE OR MORE OF THE FOLLOWING)
REGION: STATE : (STATE IS REQUIRED FOR COUNTY NAME/CODE AND CITY)
AND CITY :
/ COUNTY CODE :
/ SMSA CODE :
AND COUNTY NAME :
AND PRIMERY SIC CODE (RANGE) : ___
AND NUMBER OF EMPLOYEES (RANGE) :
AND SALES VOLUME (RANGE) :
TO
TO
TO
PF1/13 = HELP
(THE FILE WILL BE SORTED BY ZIP CODE)
._*H*BW»»««.^**B«H«~»»« *»**^ <__<
PF3/15 = PREVIOUS MENU
PF4/16 = MAIN
Figure 3-36
Page 344
November 1988
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
-------
I
FACTS User Manual System Operation and Use
I
I
I
I
I
I
I
I
I
2. Enter rhe SELECTION CRITERIA. Selection may be any or
a combination of the following:
a, REGION
b. STATE
C. CITY
d. COUNTY NAME
e. COUNTY CODE
f. SIC CODE
g. SMSA CODE (D&B) OR MSA CODE (TRINET)
h. NO OF EMPLOYEES
i. SALES VOLUME
3. Press and the Label Selection screen (Figure 3-
37) will be displayed. Select label types and press
.
I
I
I
November 1988 Page 3-45
-------
FACTS User Manual
System Operation and Use
NSSD
FACTSDEV
FALD07P
J.S. ENVIRONMENTAL PROTECTION AGENCY 11/22/88
FACILITY AND COMPANY TRACKING SYSTEM 13:40:53
DUN & BRADSTREET FUNCTION FALD07M2
MAILING LABEL GENERATION
LABEL SELECTION SCREEN
1. 1 UP {1 ACROSS ( 1.5' X 3' ) FORM 2306 }
2. 3 UP {3 ACROSS (1.5' X 3' ) FORM 2305 }
3. CHESIRE SHEET { 4 ACROSS 11 DOWN FORM 6311 }
SELECT ONE OF THE ABOVE LABEL TYPES: -
TITE HEADING:
PF1/13 = HELP
PF3/15 = PREVIOUS MENU
(OPTIONAL)
PF4/16
MAIN
4.
Figure 3-37
The Label Generation Batch Options (Figure 3-38) screen
will be displayed.
Page 3-46
November 1988
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
-------
1
1
FACTS
1
1
1
1
1
1
1
1
1
User Manual
System Operation and Use
NSSD U.S. ENVIRONMENTAL PROTECTION AGENCY 11/08/88
FACTSDEV FACILITY AND COMPANY
TRACKING SYSTEM 12:20 {14
FAZD07P1 LABEL GENERATION FI2D07M
DEFAULT OPTIONS (CHANGE IF NECESSARY) :
ACCOUNT -
SIN -
DESTINATION -
PRIORITY -
TIME -
PF3/15 = PREVIOUS MENU
Figure 3-38
. . i *
Nl (LABELS ONLY AVAILABLE AT RTP)
1
02,00
PF4/16 = MAIN MENU
5. Enter ACCOUNT, BIN, and DESTINATION. From this screen,
I
I
1
1
you may press PF3/15 to go
or PF 4/16 to return to the
back to Mailing Label menu
Main Menu.
NOTE: The system prompts you with a message that your
data has been extracted whenever you press
after its completion. It
then continues to process
what you are currently working on.
November 1988
* -
Page 347
-------
BLANK PAGE
-------
SECTION 4.0
DOWNLOAD PROCEDURES
-------
BLANK PAGE
-------
1
1
1
1
1
1
1
1
1
w
1
1
1
1
1
1
1
1
FACTS User Manual Download Procedures
SECTION 4.0 DOWNLOAD PROCEDURES
The following are download procedures for PCs connected
IRMALINK.
1. Logon to your PC.
via
2. Transfer to the directory containing the IRMA software.
3. Start the terminal emulator. (Type E78 or press
shift keys simultaneously.)
both
4. Logon to mainframe. At the READY prompt, return to
DOS.
5 . Type
'Receive pcfilename.ext dsname ASCII CRLF' .
Where:
Pcfilename.ext is your filename to receive data on
the PC.
Dsname (in quotes) is the dataset name of
file to be downloaded.
the
You will get a message informing you that the transfer
has begun. Wait for the end of transfer message.
6. To display the file, type:
'TYPE pcfilename'
November 1988 Page
'
4-1
-------
FACTS User Manual
Download Procedures
The screen will display the contents 80 characters at
a time and will look like the sample below.
001031491048054DALLAS COUNTY CHURCH STREET PO BOX99
SELMA AL36702 2058754401JOHN W JONES COUNTY GOVERNMEN
1819 200000000000 00000000000001800000180
0010 0 0 010479111
9121
001073055Q48054QUALITY AIR CONDITIONING & HTG101 OLD MONTGOMERY RD
SELMA AL36701 2058752520R E BLACKMON ONR HEATING AC CONT
1981 200000485000 00000000000000060000006
0010 0 0 010471711B
1711C
7. Return to the mainframe menu and continue processing or
logoff.
Page 4-2
November 1988
-------
APPENDIX A
PRIORITY RATES
-------
BLANK PAGE
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
5
4
3
2 (default)
Claea I
Class II
Class III
1 (all
classes
Weekends
WYLBOR/TSO
JOB SCHEDOLING/PRIORITY TABLE
Service Timed
ASAP
Better than 3
Better than 2
90% of all jobs
done in 30
minutes
90X of all jobs
done in 60
minutes
90% of all Jobs
done in 4 hours
overnight
See specific
priority above
No goal established
for WYLBUR; see
Section 3.4.1 for
TSO goals.
Coat M
6.0 times normal
2.0 times normal
1.5 times normal
1.0 times normal
1.0 times normal
1.0 times normal
.8 times normal
.5 times normal
2.5 time normal
-------
BLANK PAGE
-------
APPENDIX B
i
SAMPLE REPORTS
-------
BLANK PAGE
-------
I
I
I
Ul I
19 I
tn
H
U
ui
(9:
M w ui
Su,01
ui r n
H M Ul
o *: M
K -I
I P M
: u
fa. a
£ «*
S H
EX U U
Z Z ui
ui 3 tn
o
> »
ui a.
n o
H a
SS
V)
*
a
n
Z Q:
M Q Ul
Ul MO
« a
gn tn q
ui to <
(J Z IU 1
M
< o
i a «* w de w ui '
i«£u S Jin ;
in
r-
6
a ui
.
§-i H
< -i
U 01 3
s
0)
Q. tr- u
-. a
CM 5 -JW
a 5SM
-O < M H
it u n M
» U. (L
mm a x:
Ul O Ul
.. -i S D:
a < z H
o. £ H 3 <
O Z
Ul C
PC -2
0>ui SSE"U^S*>
5UI P4MOH
i-t z o
z « o n u
3 x x H u
o P a m
-i x -i ca M
iu an ** i
8«n en i
ui 01
§8..
ML Z Ul
o«o §;
I-
SSii
S
in
>.§»
3 o 10 a.
i m * o
i 01 tn q
i ui tn <
I ZUI I
M O! -I
'. o oi
ui 0t a
a tn tn a
a ui tn <
"gSi
u tn otn
? °i
> a.
>. u uj i
at ui
Q. Ul H
§^!2
u ma
M
S
in
o
cti
ui in
in in
in
M I >
;Hw
I
JOCUI
S
o
S:
8!
O
£
iu
-------
S
N.
m
o
N
v«
UJ IU
(0 >-
22
in
h~
U
u£
z ~
tO C
^ Ifcl ^*
isi
£"£
»1§w
H w iu
O *C M
£U t-
< M
j|5ri
< u
llo
Q S K
K U U
M Ui
> Q -1
ZZ iu
UJ < »0
M 1-
M
3ri
ii
tt.
-J 5
< u
« »
Ul
*.- 5 Kf
SS J i
am n t-
to o in
Ha *
(j a; o
< 3
U. M. ' "
Z K
5 iu
Ul MO
in >- C o a
< K 3 Ul O
S3 a: a
as «s t-
>- to S a: oe
< M K O O
a * a. u. in
H
g
Ik
3
i-
i
IU
K
SAMPLE
Ul
»-
M
O.
N
^
U
M
to
IU
QC
a
q
in
m
III
3
1
BE
IU
tR
g
i
a.
§
u
z
1-1
tD
Ul
QC
fO (O
D P
: M in
I 111 U K <
in in at i
h- at
: o M i
.00:
5 rug
"SfcSS!5 «25x.
> « !" Z < t »r »= z < "I
i a no. i
i *4 _1 O X »
: o ui o < e
>~H a a t M
a
S M
a iu
acocuj
: iu iut-t
!§
f*i m
£ S
§8! 5
85 P
U- M 3 M
°I2 Si
Q V>
ZUU
Sg85;
SHU!
O oe i
UPS-II
i Si *
SU CL M
3su..
:u:
i>-;
. «- _ Ul DC S U f
i M u O E-" £56 »-*u 8
i-l Utt_ Utuq-lu. XU
i- (» iu z ^ oe^- < iu
_ : a-i o u-i 5 o o m z e-U u m
±)&ua»-ai5MU^ uiu oceo szzxc
S o u z 5 6 < o < o -i-J o 3 zu-Sw 5
P w> S J o » OCZgxuui5uzQ«i-ixo H^Z
Sat- z < w £ 3 - uj t- o
i- ac E -J > f- 3 -j 3 3 « c z o M g u u-i K z <-< i-
-iJuuuuzaariuiuu«'«'«««''«>«><4>
oooooooooooooooooooooooo
-------
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
«
0
4
IU IU
35
a. o
in
u
US
Ul
10 E
< IU t-
3 >- £
M CM -«
IU B. 01 (J
8i*> in >-
0 -« «0
1- 0!
UK
< < U|
U.U. Q
o a
in > x: u a
25S S5 ?
< a: <3 t-
i_ a o a a
< M «£ a c
o -J a. u. at
i
u.
TRINET SAMPLE LIST
Ul
I
a.
w
M
M
U
ADDRESS
|
i
I
Be
Ul
8
E
S
COMPANY -N
REGION 1
2£§
S2S
r» e >r
Ul
Hil
3632 CHALONA DR
166 HINTER ST
126 STREETSBORO ST
8
£S
^
1- K «
a < iu
|SS
ill
eg -a -*
* o <0
ui « «r
CM in in
^ ^ ^
Se o
m M
a M in
1 O O O
-------
<0
03
p« X
m
e
M
O >-
< <
D. O
.
n iu
K
n. a
3rf
i
At
IA
IU
> M _ H
MB. N <
(ft O ** VI
i- oe
UK
< < UJ
fcu- 8
_ CJC
U UI
in > x: u
< a < w
§> m
lu m x t
IsT
i
w > a
o -i Z
UI M
" O K DC
5«« O IU «U O
IU u U U HI
W 0- M « _l
ut < < u. u. m
iu H m u. u. S
aemcoo a.
8
S
§
a M
5 5
3 O
i a o
-c -o
o< o
to a
. »
S
Kr*
K Z
IU IU
f 5 j
5 £ <
ED
>- »- iu i ja
5 2 -JOT M
fepjsi
o -i o < 3
u 3 i- in ee
rt y ^
> a ae
§.. 5 iu iu u
ui u u u 11
M |_ 11 M -J
IU K- I
am:
m
HZ
8 S
.
SSS58:
5» 3 IU IU (J
IU U U U M
. . . M 1>- IH M -I
u. u. £ (D < < u. u. m
u. u. 3 w ^ «rt u- u. 5
OOC KMEOOE
^ S335tt
i _< * £ j> pg^ «««
!M in E * iu t-t S w in u ZIU»UUO
1-1 ae >-M M u d at > M w u M a >-M w u
u in o i u. u. UMOH-U.U. u m a h- u. u.
M9OMu.M.ar i-H3aMu.iL.er >-i 3 o M u. u. or
m 01 < u o o x in (o «c o o o i in m < u o o 2:
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
-------
APPENDIX C
DATA EXTRACT FORMATS
-------
BLANK PAGE
-------
1
1
1
1
1
1
1
1
DUN AND BRADSTREET E
FIELD NAME
COMPANY NUMBER
REGION
CITY CODE
BUSINESS NAME
STREET ADDRESS
MAIL ADDRESS
CITY NAME
STATE
ZIP CODE
PHONE
OFFICER TITLE
LINE OF BUSINESS
YEAR STARTED
CREADIT RATING
SALES INDICATOR
EMPLOYEES INDICATOR
SALES VOLUME
NET WORTH INDICATOR
NET WORTH
EMPLOYEES HERE
TOTAL EMPLOYEES INDICATOR
TOTAL EMPLOYEES
SECOND NAME
BLANK
HQ NUMBER
PARENT NUMBER
ULTIMATE NUMBER
STATUS
SUBSIDIARY INDICATOR
MANUFACTUR INDICATOR
SMSA CODE
BASE YEAR SALE
BASE YEAR EMPLOYEE
STATE FIPS CODE
COUNTY FIPS CODE
SIC CODE-1
BLANK
SIC CODE2-6U)
SIC CODE2-6(2>
SIC CODE2-6O)
SIC CODE2-6(4)
SIC CODE2-6(5)
;XTRACT FILE '
TYPE
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
N
A/N
N
N
A/N
N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
(S) FORMAT
LENGTH
9
2
4
30
25
21
13
2
9
10
19
19
4
6
1
1
10
1
10
6
1
6
30
9
9
9
9
1
1
1
3
5
5
2
3
5
21
5
5
5
5
5
POSITION
001-009
010-011
012-015
016-045
046-070
071-091
092-104
105-106
107-115
116-125
126-144
145-163
164-167
168-173
174-174
175-175
176-185
186-186
187-196
197-202
202-202
203-209
210-239
240-248
249-257
258-266
267-275
275-275
276-276
277-277
278-280
281-285
286-290
291-292
293-295
296-301
302-322
323-327
328-332
333-337
338-342
343-347
-------
TRINET EXTRACT FILE(S) FORMAT
FIELD NAME
TYPE
LENGTH
POSITION
COMPANY NUMBER
REGION
BUSINESS NAME
STREET ADDRESS
CITY NAME
STATE
ZIP CODE
PHONE
OFFICER NAME
OFFICER TITLE
OFFICER LEVEL CODE
OFFICER DEP CODE
SALES TOTAL
SALES HERE
EMPLOYEES TOTAL
EMPLOYEES HERE
OLD COMPANY NUMBER
ULTIMATE NUMBER
TICKER SYMBOL
MSA CODE
PUBLIC PRIVATE INDICATOR
COMPANY RANKING
STATE FIPS CODE
COUNTY FIPS CODE
SIC CODE-1
SIC CODE2-6U)
SIC CODE2-6 (2)
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
N
N
N
N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
A/N
9
2
30
30
13
2
9
10
30
30
2
2
10
10
10
10
5
9
5
4
1
4
2
3
5
5
5
001-009
010-011
012-041
042-071
072-084
085-086
087-095
096-105
106-135
136-165
166-167
168-169
170-179
180-189
190-199
200-209
210-214
215-223
224-228
229-232
233-234
235-238
239-240
241-243
245-249
250-254
255-259
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
-------
APPENDIX D
SYSTEM FILES
-------
BLANK PAGE
-------
1
1
1
1
1
1
1
13:48:27 *CONCEPTUAL PREDICT* 88-12-05
- DISPLAY FILE AND ELEMENTARY FIELDS -
SEARCH-CRIT . : FILE=FACTS-DNB, TYPE=ALL, DBID=ALL, OWNER^ALL, KEY=ALL
FILE...: FACTS-DNB ADDED: 88-11-04
TYPE...: USER VIEW MODIFIED:
FILE-NR: 220
KEYS ...:,,,,,,,
ADABAS ATTRIBUTES
PRIMARY SEQUENCE FIELD:
CIPHERED : N (Y,N)
ADAM-FILE : N (Y/N)
SECURITY LEVEL ACCESS . :
SECURITY LEVEL UPDATE.:
T L DB NAME
1 AA COMPANY-NUMBER
1 AS BUSINESS -NAME
1 AG STATUS
1 AK SUBSIDIARY-IND
1 AM MNFCTRNG-IND
1 AQ REGION
1 AR SALES -INDICATOR
1 AS NET-WORTH-INDICATOR
1 AT EMPLOYEES-HERE-IND
1 AU EMPLOYEES -TOTAL- IND
1 AV COUNTY-FIPS-CODE
1 AW STATE-ABBR
1 AX STATE-FIPS-CODE
1 AY YEAR-STARTED
1 BB CITY-CODE
1 BD SMSA-CODE
1 BH CITY-NAME
1 BK ZIP -CODE
1 BO SIC-CODE-1
M 1 BQ SIC-CODE-2-6
1 BS STREET-ADDRESS
1 BU MAIL-ADDRESS
1 BW PHONE-NUMBER
1 BY HQ-NUMBER
1 CA PARENT-NUMBER
1 CC ULTIMATE-NUMBER
1 CE SALES -HERE
1 CG EMPLOYEES-HERE
1 CK LINE-OF-BUSINESS
1 CM CREDIT-RATING
1 CO NET-WORTH
1 CQ EMPLOYEES-TOTAL
1 CS SECOND-NAME
1 DO SALES-BASE-YEAR
1 DQ EMPLOYEES -BASE- YEAR
1 DS PRNCPL-OFFCR-TITLE
1 DO COMPANY-REPORT
1 ZB REGION-STATE-CNTY
1 ZC STATE-BSNSS
.F
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
N
N
A
A
N
N
A
N
N
A
A
A
A
LENG S DE VE REMARK
9.0 DE
30.0
1.0 F
1.0 F
1.0 F
2.0 F
1.0 F
1.0 F
1.0 F
1.0 F
3.0 F
2.0 F
2.0 F
4.0 F
4.0 F
3.0 F DE
13.0
9.0
5.0 F DE
5.0 N
30.0 N
27.0 N
10.0 N
9.0 N DE
9.0 N DE
9.0 N DE
10.0 N DE
10.0 N DE
19.0 N
6.0 N
10.0 N
10.0 N
30.0 N
5.0 N
5.0 N
19.0 N
12.0 N . .
7.0 SP
17.0 SP
-------
1 ZD BSNSS-NAME A 15.0 SB
13:48:27 *CONCEPTUAL PREDICT*
- DISPLAY FILE AND ELEMENTARY FIELDS -
SEARCH-CRIT. :FILE=FACTS-DNB, TYPE=ALL, DBID=ALL, OWNER=ALL, KEY=ALL
FILE: FACTS-DNB
T L DB NAME F LENG S DE VE REMARK
1 ZE SCNDRY-NAME A 17.0 SP
*
1
1
88-12-OB
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
-------
1
1
13:48:29 * C 0 N C E
1- DISPLAY
SEARCH-GRIT. :FILE=FACTS-TRINET,
FILE . . . : FACTS -TRINET
TYPE...: USER VIEW
FILE-NR: 221
KEYS . . . : ,,,,,,,
ADABAS ATTRIBUTES
PRIMARY SEQUENCE FIELD:
CIPHERED : N ( Y, N)
ADAM-FILE : N (Y,N)
1 SECURITY LEVEL ACCESS . :
SECURITY LEVEL UPDATE . :
T L DB NAME
11 AA COMPANY-NUMBER
1 AS BUSINESS -NAME
1 AO HQ-CODE
11 AQ REGION
1 AV COUNT Y-F IPS -CODE
1 AU STATE-ABBR
- 1 AX STATE-FIPS-CODE
1 BF MSA-CODE
" 1 BH CITY-NAME
1 BK ZIP-CODE
1 BO SIC-CODE-1
M.l BQ SIC-CODE-2-6
1 BS STREET-ADDRESS
11 BW PHONE-NUMBER
1 CC ULTIMATE-NUMBER
1 CE SALES-HERE
_ - 1 CG EMPLOYEES -HERE
1 CQ EMPLOYEES -TOTAL
* 1 CU SALES -TOTAL
1 CW OFFICER-NAME
11 CY OFFICER-TITLE
1 DB OFFICER-DEPT-CODE
1 DD OFFICER-LVL-CODE
11 DF OLD-COMPANY-NUMBER
1 DH PBLC-PRVT-IND
1 DK COMPANY-RANKING
1 DM TICKER-SYMBOL
1 DU COMPANY-REPORT
1 ZB REGION-STATE-CNTY
1
1
1
1
P T U A L
PREDICT* 88-12-05
FILE AND ELEMENTARY FIELDS -
TYPE=ALL, DBID=ALL, OWNER=ALL, KEY=ALL
F
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
N
N
N
N
A
A
A
A
A
A
A
A
A
A
ADDED: 88-09-15
MODIFIED:
LENG S DE VE REMARK
9.0 DE
30.0 DE
1.0 F
2.0 F
3.0 F
2.0 F
2.0 F
4.0 F DE
13.0
9.0
5.0 F DE
5.0 N
30.0 N
10.0 N
9.0 N DE
10.0 N DE
10.0 N DE
10.0 N
10.0 N
30.0 N
30.0 N
2.0 N
2.0 N
5.0 N
1.0 N
4.0 N
5.0 N
12.0 N
7.0 SP
-------
13:48:32 *CONCEPTUAL PREDICT*
- DISPLAY FILE AND ELEMENTARY FIELDS -
SEARCH-CRIT. : FIL£=FACTS -TABLE, TYPE=ALL, DBID=ALL, OWNER=ALL, KEY^ALL
FILE...: FACTS-TABLE ADDED:
TYPE...: USER VIEW MODIFIED:
FILE-NR: 222
KEYS . . . : ,,,,,,,
ADABAS ATTRIBUTES
PRIMARY SEQUENCE FIELD:
CIPHERED : N (Y,N)
ADAM-FILE : N (Y,N)
SECURITY LEVEL ACCESS.:
SECURITY LEVEL UPDATE.:
T L DB NAME F LENG S DE VE REMARK
1 AA SIC-CODE A 5.0 DE
1 AB SIC-DESCRIPTION A 48.0
1
88-12-0*
88-10-o|
|
1
1
1
1
1
1
1
1
1
1
1
1
1
1
-------
1
1
1
1
1
13:48:26 *CONCEPTUAL PREDICT*
- DISPLAY FILE AND ELEMENTARY FIELDS -
SEARCH-GRIT . :FILE=FACTS-STD, TYPE=ALL, DBID=ALL, OWNER=ALL, KEY=ALL
FILE. . . : FACTS-STD ADDED:
TYPE . . . : STANDARD MODIFIED :
FILE-NR:
KEYS . . . : ,,,,1,1
T L DB NAME F LENG S DE VE REMARK
1 AA COMPANY-NUMBER A 9.0
UNIQUE IDENTIFIER OF THE
COMPANY .
1 AC COMPANY-INDICATOR A 1.0
INDICATES IF DATA IF FROM
DUNS OR TRINET COMPANY
1 AS BUSINESS-NAME A 30.0
NAME OF THE ESTABLISHMENT.
1 AG STATUS A 1.0 F
THIS SHOWS THE COMPANY' S
ORGANIZATIONAL STATUS. BEING
S INGLE LOCAT ION ( 0 ) , HEAD
QUARTER (1), OR BRANCH (2).
1 AK SUBSIDIARY-IND A 1.0 F
CODE TO INDICATE IF A COMPANY
IS A SUBSIDIARY (3) OR NOT{0)
1 AM MNFCTRNG-IND A 1.0 F
THIS CODE TELLS WHETHER OR NOT
MANUFACTURING OPERATIONS ARE
DONE AT THE LOCATION.
1 AO HQ-CODE A 1.0 F
PROVIDES HEADQUARTERS STATUS.
1 THEY ARE :0, 1, 2, AND 3
1 AQ REGION A 2.0 F
TWO DIGIT REGION CODE.
1 AR SALES-INDICATOR A 1.0 F
IDICATES WHETHER ACTUAL OR
ESTIMATED. 0 - ACTUAL
1 = ESTIMATED
2 = UNAVAILABLE
1 AS NET -WORTH- INDICATOR A 1.0 F
INDICATES WHETHER ACTUAL OR
ESTIMATED. 0 = ACTUAL
1 = ESTIMATED
2 = UNAVAILABLE.
1 AT EMPLOYEES-HERE-IND A 1.0 F
INDICATES WHETHER ACTUAL OR
ESTIMATED. 0 = ACTUAL
1 = ESTIMATED
2 = UNAVAILABLE.
1 AU EMPLOYEES-TOTAL-IND A 1.0 F
INDICATES WHETHER ACTUAL OR
ESTIMATED. 0 .= ACTUAL
1 = ESTIMATED
2 = UNAVAILABLE.
88-12-05
88-07-22
88-09-15
.
-------
I
13:48:26 *CONCEPTUAL PREDICT* 88-12-0
- DISPLAY FILE AND ELEMENTARY FIELDS -
SEARCH-GRIT . :FILE=FACTS-STD, TYPE=ALL, DBID=ALL, OWNER=ALL, KEY=ALL
FILE: FACTS-STD
T L DB NAME F LENG S DE VE REMARK
1 AV COUNTY-FIPS-CODE A 3.0 F
THREE-DIGIT NUMERIC CODE TO
PLACE COUNTIES IN ALPHABETICAL
ORDER WITHIN STATES.
1 AW STATE-ABBR A 2.0 F
STATE ABBREVIATION FOR THE
PHYSICAL LOCATION OF THE
ESTABLISHMENT.
1 AX STATE -F IPS -CODE A 2.0 F
TWO-DIGIT NUMERIC CODE TO PUT
STATES IN ALPHABETICAL ORDER.
1 AY YEAR-STARTED A 4.0 F
SHOWS THE YEAR THAT THE
BUSINESS WAS STARTED.
1 BB CITY-CODE A 4 . 0 F
THIS FOUR-DIGIT CODE PUT
CITIES IN ALPHABETICAL
ORDER WITHIN STATE.
1 BD SMSA-CODE A 3.0 F
1 BF MSA-CODE A 4.0 F
THE FIPS CODE DESIGNATING THE
METROPOLITAN STATISTICAL AREA
(MSA) .
1 BH CITY-NAME A 13.0
CONTAINS THE NAME OF THE CITY
IN WHICH ESTABLISHMENT IS
PHYSICALLY LOCATED.
1 BK ZIP-CODE A 9.0
THE ZONE IMPROVMENT PLAN (ZIP).
1 BO SIC-CODE-1 A 5.0 F
THE STANDARD INDUSTRIAL CLASS-
IFICATION NUMBER.
M 1 BQ SIC-CODE-2-6 A 5.0 N
INDICATES HOW MANY SIC-CODES
ARE AVAILABLE FOR THIS COMPANY
1 BS STREET -ADDRESS A 30.0 N
THIS IS THE PHYSICAL LOCATION
OF THE ESTABLISHMENT.
1 BU MAIL-ADDRESS A 27.0 N
THIS FIELD IS USED IF MAILING
ADDRESS IS DIFFERENT FROM
PHYSICAL LOCATION, BASED ON
DB-MAIL-CODE .
1 BW PHONE -NUMBER A 10.0 N
TELEPHONE NUMBER OF THE
ESTABLISHMENT .
1 BY HQ-NUMBER 9.0 N
THE 9-DIGIT UNIQE DUNS NUMBER
1
I
I
-------
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
13:48:26 *CONCEPTUAL PREDICT* 88-12-05
- DISPLAY FILE AND ELEMENTARY FIELDS -
SEARCH-GRIT. :FILE=FACTS-STD, TYPE=*ALL, DBID=ALL, OWNER=ALL, KEY=ALL
FILE: FACTS-STD
T L DB NAME F LENG S DE VE REMARK
FOR THE HEAD QUARTER LOCATION
IF THIS ESTABLISHMENT IS A
BRANCH(IE. STATUS = 2)
1 CA PARENT-NUMBER A 9.0 N
THE DUNS NUMBER OF THE PARENT
COMPANY. THIS FIELD CAN BE
BLANK.
1 CC ULTIMATE-NUMBER A 9.0 N
THE DUNS NUMBER OF THE TOP
MOST FIRM OF A "FAMILY TREE"
GROUP OF COMPANIES. THIS FIELD
CAN BE BLANK.
1 CS SALES-HERE N 10.0 N
CONTAINS THE SALES VOLUME OF
COMPANY AT THIS LOCATION AS
REPORTED TO D&B.
1 CG EMPLOYEES-HERE N 10.0 N
CONTAINS THE TOTAL NUMBER OF
EMPLOYEE OF THE ORGANIZATION
BASED ON THE CODE IN THE
TOT-IND FIELD.
1 CK LINE-OF-BUSINESS A 19.0 N
ALPHA NARRATIVE ABBREVIATION
OF WHAT IS DONE AT THE
ESTABLISHMENT.
1 CM CREDIT-RATING A 6.0 N
THIS CONSIST OF A THREE-DIGIT
NUMERIC CODE FOLLOWED BY THE
THREE-DIGIT ALPHA-NUMERIC
SYMBOLS.
1 CO NET-WORTH N 10.0 N
CONTAINS TANGIBLE NET WORTH OF
COMPANY.
1 CQ EMPLOYEES-TOTAL N 10.0 N
COTAINS THE TOTAL NUMBER OF
EMPLOYEE OF THE ORGANIZATION
BASED ON THE CODE IN THE
TOT-IND FIELD.
1 CS SECOND-NAME A 30.0 N
THIS FIELD CONTAIN THE TRADE
STYLE OR DIVISIONAL NAME IF
ONE IS USED BY THE ESTABLISHM-
ENT.
1 CU SALES-TOTAL N 10.0 N
THIS IS EITHER THE SUM OF THE
OUTPUT VALUE OF ALL LOCATIONS -.
OF THE COMPANY OR THE CORPORA1
SALES BASED ON PUBLIC INFO.
-------
I
13:48:26 ^CONCEPTUAL PREDICT* 88-12-05
- DISPLAY FILE AND ELEMENTARY FIELDS - _
SEARCH-CRIT. :FILE=FACTS-STD, TYPE=ALL,DBID=ALL, OWNER=ALL,KEY=ALL
FILE: FACTS-STD
T L DB NAME F LENG S DE VE REMARK
1 CW OFFICER-NAME A 30.0 N
NAME OF THE HIGHEST RANKING
PERSON AT THE LOCATION.
1 CY OFFICER-TITLE A 30.0 N
TITLE OF THE PRINCIPAL OFFICER
1 DB OFFICER-DEPT-CODE A 2.0 N
THIS IS A CODE DESCRIBING THE
DEPARTMENT OF THE PRINCIPAL
OFFICER AND IS BASED ON TITLE.
1 DD OFFICER- LVL-CODE A 2.0 N
THIS IS A CODE DESCRIBING THE
LEVEL OF THE PRINCIPAL OFFICER
AND IS BASED ON TITLE.
1 DF OLD -COMPANY -NUMBER A 5.0 N
IS MAINTAINED FOR THE CUSTOMER
WHO HAVE NOT CONVERTED TO THE
NEW NUMBER.
1 DH PBLC-PRVT-IND A 1.0 N
THE CODE WILL INDICATE THE
TYPE BEING EITHER; PRIVATELY
HELD, PUBLICLY-HELD, OR
IMPLIES GOVMNT' ORGANIZATION.
1 DK COMPANY -RANKING A 4.0 N
THIS FIELD CONTAINS A CODE
DESCRIBING THE COMPANY'S
INDUSTRY AND RANK WITHIN
THE INDUSTRY.
1 DM TICKER-SYMBOL A 5.0 N
THE "TICKER" SYMBOL REPRESENT
COMPANIES TRADED ON PUBLIC
STOCK EXCHANGE.
1 DO SALES-BASE-YEAR N 5.0 N
THE ANNUAL SALES VOLUME FROM
DECEMBER FILE OF THE BASE YEAR
THE BASE YEAR IS THE YEAR FIVE
YEARS PREVIOUS TO THE TREND YR
1 DQ EMPLOYEES-BASE-YEAR N 5.0 N
TOTAL NUMBER OF EMPLOYEES FROM
DECEMBER FILE OF THE BASE YEAR
1 DS PRNCPL-OFFCR-TITLE A 19.0 N
NAME AND TITLE OF THE PERSON
REPORTED TO D&B AS FILLING THE
FUNCTION OF CHIEF EXECUTIVE AT
THIS LOCATION.
1 DU COMPANY-REPORT ' 12.0 N
1
I
I
I
1
------- |