United Stales
Environmental Protection
Agency
Office of Air Quality
Planning And Standards
Research Triangle Park, NC 27711
EPA-450/2-89-018
July 1990
AIR
EIPA
GROSSWALK/AIR TOXIC EMISSION
FACTOR DATA BASE MANAGEMENT
SYSTEM USER'S MANUAL
-------
EPA-450/2-89-018
July 1990
CROSSWALK/AIR TOXIC EMISSION
FACTOR DATA BASE MANAGEMENT
SYSTEM USER'S MANUAL
By
Gary N. Patterson
Radian Corporation
Research Triangle Park, North Carolina 27709
U. S. ENVIRONMENTAL PROTECTION AGENCY
Office Of Air and Radiation
Office Of Air Quality Planning And Standards
Research Triangle Park, North Carolina 27711
-------
This report has been reviewed by the Office of Air Quality Planning
and Standards, U. S. Environmental Protection Agency, and has been
approved for publication. Mention of trade names or commercial
products does not constitute endorsement or recommendation for use.
EPA 450/2-89-018
-------
Table of Contents
Section Page
Disclaimer ii
List of Figures v
Definition of Terms : vi
1.0 Introduction 1
2.0 Getting Started 3
2.1 System Requirements 3
2.2 Enclosures Provided 3
2.3 Installing the System 4
2.4 First-time Execution 5
3.0 System Overview 7
3.1 Command Line Options 7
3.2 Menu System 11
3.2.1 Reporting 11
3.2.2 Modify Databases 11
3.2.3 File Management 13
3.2.4 System Utilities 13
3.3 Help System 13
4.0 Reporting 15
4.1 Report Design 15
4.1.1 Editing a Design 15
4.1.2 Clearing a Design 19
4.1.3 Saving a Design 19
4.2 Retrieve Design 19
4.3 Delete Design 21
4.4 Generate Report 21
4.5 Output Report 24
4.6 View Report 24
5.0 Modify Database 29
6.0 File Management 31
6.1 Change Directory 31
6.2 Delete File 31
6.3 View File 33
7.0 System Utilities 35
7.1 Backup Database 35
7.2 Restore Database 35
7.3 Inspect Database 37
cao.041
iii
-------
Table of Contents - Continued
Section
Appendices . . .
Appendix A
Appendix B
Appendix C
Appendix D
Appendix E
Appendix F
Keystroke Definitions
How the Search Works ,
System Development Tools ....
Database Organization
Database File Structures . . . . ,
Creating and Using DOS batch files
Page
39
41
43
45
47
49
55
cao.041
iv
-------
List of Figures
Figure Page
1 XATEF DBMS Introduction Screen 8
2 Introductory Screen with Data Preparation Message 8
3 Password Verification Error Message 10
4 Database Integrity Verification Error Message 10
5 XATEF DBMS Main Menu 12
6 Exit the Program and Return to DOS Confirmation Message 12
7 Help Information Available with the \H command line Option ... 14
8 Help Information Available with the Key 14
9 The Reports Menu of the Main Menu 16
10 The Edit Design Screen of the Reports Menu 16
11 An Pick List of Chemical Names 18
12 Column and Search Criteria for the Edit Design Screen 18
13 Enter the Report Design Name for Saving to Disk 20
14 Scrolling Window for Selecting a Report Design to Retrieve ... 22
15 Report Generation Progress Report 22
16 Report Generation Error Message 23
17 Scrolling View of a Generated Report 25
18 The Output Report Menu of the Reports Menu 27
19 The Modify Database Menu of the Main Menu 30
20 Password Entry and Verification Screen 30
21 The File Management Menu of the Main Menu 32
22 Scrolling Window for Selecting a New Current Subdirectory .... 32
23 Scrolling Window for .Selecting a File to View 34
24 Text Window Used to View a DOS ASCII File 34
25 The Utilities Menu of the Utilities Menu 36
26 The Backup Files Option of the Utilities Menu 36
27 Data Restoration Error Resulting from a Bad Backup Diskette .. 38
28 Database Inspection Warning Message 38
cao.041
-------
Definition of Terms
ASCII
ASCII file
Bit
Byte
CAS Number
DBMS
DOS
EF
EPA
KB
MB
Mhz
PC
Process
RAM
SCC
SIC code
Source
XATEF
American Standard Coding for Information Interchange.
A human-readable DOS file format.
A Binary digiT (0 or 1) used to store digital
information.
A series of eight bits used as the basic unit of
computer information. The ASCII table defines the
first one hundred twenty eight bytes (0-127 or
00000000 - 01111111).
Chemical Abstracts Services Number.
Data Base Management System.
Disk Operating System.
Emission Factor.
The United States Environmental Protection Agency.
Kilobyte (1,024 bytes).
Megabyte (1,048,576 bytes).
One million hertz.
Personal Computer.
Activity associated with an emission factor.
Random Access Memory
Source Category Code.
Standard Industrial Classification Code.
Activity associated with an emission factor process.
Crosswalk Air Toxic Emission Factor.
cao.041
VI
-------
1.0 INTRODUCTION
The Crosswalk Air Toxic Emission Factor (XATEF) Data Base Management
System (DBMS) is an IBM AT Personal Computer (PC) based application designed
to facilitate the rapid identification and cross-referencing of toxic air
pollutant/emission source associations and provide corresponding emission
factors for these associations as available. The XATEF DBMS derives its
information from the Standard Industrial Classification (SIC) - Source
Category Code (SCC)/pollutant cross-references found in Toxic Air
Pollutant/Source Crosswalk - A Screening Tool For Locating Possible Sources
Emitting Toxic Air Substances. Second Edition EPA-450/2-89-017; and the air
toxic emission factor collection found in Toxic Air Pollutant Emission Factors
- A Compilation for Selected Air Toxic Compounds and Sources. Second Edition
EPA-450/2-90-011.
The program has been written for the Noncriteria Pollutant Programs
Branch of the United States Environmental Protection Agency (EPA) by Radian
Corporation, Research Triangle Park.
This user's manual explains the general operation of the XATEF DBMS. It
provides the necessary instructions needed to access, update, and report
database cross-reference and air toxic emission factor information. As with
any computer program the user may need some practice to become familiar with
all aspects of the system. After a few sessions the user will understand the
database contents and the various procedures for retrieving information.
The system displays emission factor and cross-reference information in
the form of output tables on the computer screen, printer, or disk file.
Output table specifications consist of descriptive information for pollutants,
SICs, SCCs, industrial processes, and emission sources. Authorized users may
add, edit, and delete information in the database. The data files use a
standard format and might be altered by many programs currently available;
however, the system is equipped to detect and prevent the use of data files
modified externally.
cao.041
-------
cao.041
-------
2.0 GETTING STARTED
2.1 SYSTEM REQUIREMENTS
Use of the XATEF DBMS program requires:
An IBM (tm) AT PC or compatible machine that runs MS-DOS
(tm) or PC-DOS (tm) version 3.0 or later;
At least 640 KB of free RAM;
A fixed disk with at least 20 MB of storage; and
A high density 5 1/4 inch external disk drive.
2.2 ENCLOSURES PROVIDED
The XATEF DBMS is distributed on one high density (1.2 MB) 5 1/4 inch
diskette. This user's guide is also included on the distribution disk. The
disk contains one file called UNPACK.EXE. This file contains the following
files in compressed format:
XATEF.EXE The executable XATEF DBMS program
EFACTOR.DBF The emission factor description file
EFC_RRC.DBF The emission factor reference file
HELPMAST.DBF The help system information file
NEWXWALK.DBF The pollutant/SIC/SCC cross-reference file
POC_DESC.DBF The pollutant description file
REF_DESC.DBF The crosswalk reference description file
RPC_DESC.DBF The emission factor process description file
RRC_DESC.DBF The emission factor reference description file
RSC_DESC.DBF The emission factor source description file
SCC_DESC.DBF The SCC code description file
SIC_DESC.DBF The SIC code description file
HELPMAST.DBT The help system memo information file
REF_DESC.DBT The crosswalk reference memo file
RRC_DESC.DBT The emission factor reference memo file
USRGUIDE.DOC This user's guide as a DOS ASCII file
STAMP.MEM The database security file
README.BAT The file used to review recent updates
README.TXT The recent update text file
cao.041
-------
2.3 INSTALLING THE SYSTEM
The XATEF DBMS distribution diskette is not copy protected and the user
is encouraged to make backup copies before installation. Please refer to
Section 7.1 for instructions on performing a DOS diskette backup.
The instructions provided in this section assist the user in installing
the XATEF DBMS program and its associated data files onto the personal
computer's fixed disk. It is assumed that the computer has a floppy diskette
drive designated as drive A: and a fixed disk drive designated as drive C:.
If the user's system is configured otherwise, replace the alternate drive
designations (i.e., B, D, E, or F) in the instructions. The system is
intended to be operated with all program, database, and index files in the
same directory of the fixed drive. It is recommended that this directory be
named "\XATEF". If another name is to be used, substitute it in the following
instructions.
1. Log onto the fixed disk to contain the XATEF DBMS program
Type: C:
2. Create a new subdirectory to put the system into
Type: MD \XATEF
3. Copy the distribution diskettes to the new subdirectory
Type: COPY A:*.* C:\XATEF
After the diskette has been copied to the fixed drive, the files must be
unpacked. There should be one file called "UNPACK.EXE" in the "\XATEF"
subdirectory. To unpack the files
4. Change to the XATEF subdirectory
Type: CD \XATEF
5. Unpack the program and data files
Type: UNPACK
and wait for the files to be unpacked. When all of the files have been
unpacked the original packed file ("UNPACK.EXE") may be deleted.
cao.041
-------
If the preceding instructions have been followed, the system files have
been copied and unpacked to the fixed disk in a subdirectory of the root
directory named "\XATEF". To begin using the XATEF program, follow the
instructions in Section 2.4.
2.4 FIRST-TIME EXECUTION
To begin using the installed system, follow the instructions listed
below.
1. Log to the subdirectory containing all of the necessary files.
Type CD \XATEF
2. Begin program execution (i.e., run the program).
Type XATEF
The XATEF DBMS program will be invoked and the opening title screen will
appear (Figure 1). The first time the system is used a set of index files
will be built. This is done once every time the data is installed. It will
take about thirty minutes on an AT class machine running at 12 Mhz.
cao.041
-------
cao.OU
-------
3.0 SYSTEM OVERVIEW
The purpose of the XATEF DBMS is to allow an individual to locate and
estimate the magnitude of potential air toxic emissions from sources. XATEF
may be used to retrieve cross-references of pollutants and sources (both
general and specific), sets of emission factors, or both pollutant/source
cross references and emission factors.
The computer program is designed around a Main Menu accessed through the
backslash > key and located on the top row of the screen. The Main Menu
functions are Reporting, Database Modification, File Management, and System
Utilities.
At any time the user may press the help key to obtain specific help
concerning the system operation in progress. For a complete discussion of the
on-line Help utility please refer to Section 3.3 - Help System. The escape
key cancels an input operation in progress.
When the user starts the XATEF DBMS an introductory screen identifying
the computer program, EPA producing branch, and development contractor is
displayed (Figure 1). Any key may be pressed to begin. At this time the disk
drive will be checked to make sure all of the necessary data and index files
are present (Figure 2). If they are present, the system will check the date
stamps of the files to make sure that they have not been altered external to
the XATEF system. Authorized users will be asked to enter a password and
access will be granted or denied. If the files are not present or the date is
incorrect, the system will not be activated and control will be returned to
DOS.
3.1 COMMAND LINE OPTIONS
The command line options (or parameters) are set from DOS when the XATEF
program is begun. The options are placed following the name of the program
and are preceeded with a slash. The options are listed below.
Option Option Description
/a Autostart the program. That is, the main menu will appear after
system initialization without the user having to press a key.
Normally, an introduction screen appears and the user must press a
key to proceed with the system initialization. To bypass this
cao.041
-------
CROSSWALK AIR TOXIC EMISSION FACTOR DATA BASE MANAGEMENT SYSTEM
Written under contract from
UNITED STATES ENVIRONMENTAL PROTECTION AGENCY
Office of Air Quality Planning and Standards
Research Triangle Park, North Carolina 27711
by
RADIAN CORPORATION
Research Triangle Park, North Carolina 27709
-Key=Cont i nue—I
FIGURE 1. XATEF DBMS INTRODUCTORY SCREEN
CROSSWALK AIR TOXIC EMISSION FACTOR DATA BASE MANAGEMENT SYSTEM
Written under contract from
UNITED STATES ENVIRONMENTAL PROTECTION AGENCY
Please wait while the data files are prepared.
RADIAN CORPORATION
Research Triangle Park, North Carolina 27709
-Key=Cont i nue—
FIGURE 2. INTRODUCTORY SCREEN WITH DATA PREPARATION MESSAGE
cao.041
-------
user intervention and proceed directly to the main menu, use this
option.
/h Display this user manual (USRGUIDE.DOC) in a pop-up scrolling
window. This manual may also be viewed by using the View File
option of the File Management Menu. It may also be printed by
using the DOS PRINT or COPY command.
/m Use the monochrome display. This is useful when the system is
being used on a computer with a VGA monochrome monitor. These
computers sometimes recognize the monitor as VGA color and will
attempt to represent colors with different degrees of shading.
This sometimes washes out certain colors. Using the monochrome
option will insure that everything on the screen is visible.
/p Set the password when the system starts. This option is used if
the XATEF program is to be accessed and the data files have been
modified outside the system. When the data files are modified by
dBASE (tm) or some other program, the date stamps on the files are
altered. XATEF will recognize this alteration and will not allow
the program to be used. This checking can be avoided if the
password is entered correctly at the beginning of the program
(Figures 3 and 4).
/s Ignore the config.sys check. Every time the XATEF system is used,
the system configuration will be checked to make sure that the
proper number of files and buffers are available. If they are
not, the config.sys file will be changed and the system will be
re-configured. If the config.sys file has been marked as read-
only it cannot be changed and an error will result. If the
config.sys check is to be ignored, this switch must be used.
Some examples using command line options follow. Note that there needs
to be a slash character preceeding each command line option to be activated.
xatef /p/a This will activate the initial password entry window after
auto-starting and before data initialization.
xatef ma This will do nothing because there is no backslash
character preceeding the command line options.
xatef /m/s/a This will cause XATEF to auto-start, ignore the current
config.sys settings, and act as though a monochrome monitor were
attached to the computer.
xatef /a/s This will auto-start the system and ignore the current
config.sys settings.
If command line options are regularly used then the user may want to
create a DOS batch file to execute XATEF. See Appendix F for an explanation
of DOS batch files.
cao.041
-------
CROSSWALK AIR TOXIC EMISSION FACTOR DATA BASE MANAGEMENT SYSTEM
—(Password Verification Window)-
PIease
securi
screen
comple
Passwo
—{Failed Password Screen)-
The current password has
not been entered
correctly. Unlimited
access to the system has
not been granted.
-Esc=Continue
ow. For
n the
-Enter=Cont i nue—Esc=Abort—'
Research Triangle Park, North Carolina 27709
-Key=Cont i nue—
FIGURE 3. PASSWORD VERIFICATION ERROR MESSAGE
CROSSWALK AIR TOXIC EMISSION FACTOR DATA BASE MANAGEMENT SYSTEM
UNI
PI
I—Database Integrity Verificatic
The databases have been altered by
non-authorized personnel using
software other than XATEF DBMS. The
program will not allow access beyond
this point. Consult your database
administrator for instruction in
correcting the problem.
Esc=Continue-
Research Triangle Park, North Carolina 27709
-Key=Cont i nue—
FIGURE 4. DATABASE INTEGRITY VERIFICATION ERROR MESSAGE
cao.041
10
-------
3.2 MENU SYSTEM
The XATEF Main Menu, located on the top row of the screen, is activated
with the backslash > key, and has five options: Reporting, Modify
Databases, File Management, Utilities, and Quit (Figure 5). The Reporting
option is used to Design, Retrieve, Delete, Generate, Output, and View
crosswalk and emission factor reports. The Modify Database option is
available only to qualified (password holding) users and allows for the
insertion, deletion, and editing of data. The File Management option allows
the user to Delete files (if a subdirectory becomes full) and View ASCII text
files (such as report designs or reports saved in ASCII format.) The
Utilities option allows the user to check the Integrity of the current data,
Backup the data for security, and Restore previously stored data. The Quit
option is used to terminate the current session and return control to DOS.
The user is asked to confirm a Quit request (Figure 6).
3.2.1 Reporting
The Reporting option is used to Design, Retrieve, Delete, Generate,
Output, and View crosswalk and emission factor reports. Reports are designed
by selecting the fields to be included and specifying any search criteria for
those fields. The report will be built from the database exactly as designed.
Only the fields selected for use in the report will be included and they will
appear in the order specified. The report may be output to disk or printer
and will retain its specified design when transferred.
3.2.2 Modify Databases
The Modify Databases option is available only to qualified (password
holding) users and allows for the insertion, deletion, and editing of data.
After the user has correctly specified the password at some point during the
program (i.e. at the command line or Modify Database option), the Modify
Database Menu containing a descriptive name of each database file will appear.
The cursor keys may be used to highlight one of the files and it will be
opened for editing when the key is pressed.
To edit the database, place the highlight bar on the field to be edited
and press the key. The cursor will be turned on and the field may be
edited. The and keys insert and delete a record. When all of the
cao.041
11
-------
Reports Modify Database File Management Utilities Quit 9:36 am
Design and Generate Crosswalk and Emission Factor Reports
FIGURE 5. XATEF DBMS MAIN MENU
Reports Modify Database File Management Utilities Quit 9:42 am
Exit and Return to DOS
Exit the Database Management System and Return to DOS
FIGURE 6. EXIT THE PROGRAM AND RETURN TO DOS CONFIRMATION MESSAGE
cao.041
12
-------
editing is completed, press the key to save the edits and return to the
Database Selection Menu. The key may be used to abort edits and return
the data to its original state.
3.2.3 File Management
The File Management option allows the user to Delete files (if the disk
drive or a subdirectory becomes full) and View ASCII text files (such as
report designs or reports saved in ASCII format.) These options allow the
user to view an earlier report or make room on the disk for a new report
without exiting to DOS and losing a report they may have just generated.
3.2.4 System Utilities
The Utilities option allows the user to check the Integrity of the
current data, Backup the data for security, and Restore previously stored
data. The Integrity check will make sure that each record of each file in the
database is unique and the data links between the files are complete and
consistent. A series of DOS text files will be created that contain a summary
of the results. The Integrity check will take several hours and should be run
overnight or over the weekend. The Backup and Restore options perform the
expected tasks of writing and reading the database files to and from floppy
diskettes. This function is provided mainly for the user who has access to
the database modification routines. Those users who will not alter the data
have a backup in the form of their distribution diskettes.
3.3 HELP SYSTEM
The XATEF DBMS comes equipped with an on-line help system that is
activated with the key. The help system provides assistance anytime
input data or a selection is required from the user. A window containing help
information will remain on the screen until the user presses the key.
Help information may be obtained by using the key or command
line option. As discussed in Section 3.1, the command line option
displays this user's manual in a scrolling window (Figure 7). The help
information available with the key is similar to information presented on
specific features of XATEF in this user's manual. A single paragraph will be
displayed on the screen explaining the operation of a particular menu item or
aspect of the program. For example, Figure 8 shows the help screen for the
"Reports Option of the Main Menu".
cao.041
13
-------
The Crosswalk Air Toxic Emission Factor (XATEF) Data Base Management
System (DBMS) is an IBM AT Personal Computer (PC) based application desig
to facilitate the rapid identification and cross-referencing of toxic air
pollutant / emission source associations and provide corresponding etnissi
factors for these associations as available. The XATEF DBMS derives its
information from the Standard Industrial Classification (SIC) - Source
Category Classification (SCO / pollutant cross-references found in Toxic
Pollutant/Source Crosswalk - A Screening Tool For Locating Possible Sourc
Emitting Toxic Air Substances, Second Edition. EPA-450/2-89-017; and the
toxic emission factor collection found in Toxic Air Pollutant Emission
Factors - A Compilation for Selected Air Toxic Compounds and Sources, Sec
Edition, EPA-450/2-90-011.
The program has been written for the Noncriteria Pollutant Programs
Branch of the United States Environmental Protection Agency (EPA) by Radi
Corporation, Research Triangle Park.
-Key=Cont i nue—
FIGURE 7. HELP INFORMATION AVAILABLE WITH THE \H COMMAND LINE OPTION
Reports Modify Database File Management Utilities Quit
11 45 am
I—Help Information {MAINRPTUAITKEY3
This is the Reports Option of the
Main Menu. It is used to Design,
Save, and Retrieve Report Queries.
It is also used to Generate, Output,
and View Report Tables. Reports are
tabular and designed by selecting
the columns to be included and
specifying any filter criteria.
-€sc=Cont i nue—
Design and Generate Crosswalk and Emission Factor Reports
FIGURE 8. HELP INFORMATION AVAILABLE WITH THE KEY
cao.041
-------
4.0 REPORTING
Reports are designed by selecting the columns they are to contain. The
columns are selected in order from left to right. The report designs may be
saved to disk and quickly retrieved. The reports, once designed and
generated, may be output to disk as an ASCII, dBASE, or Lotus file; or printed
on a dot matrix or laser printer. Two types of emission factor reports are
available: a standard column report and an easy to read full page report.
4.1 REPORT DESIGN
To design a report (either by modifying an existing report or starting
from scratch), select the Edit Design option from the Reports Menu (Figure 9).
The Edit Design screen allows for report column Editing (selecting the report
columns and defining any search criteria), Clearing the current design, or
Saving the current design to disk (Figure 10).
4.1.1 Editing A Design
Edit Criteria is the selection chosen from the Edit Design Menu to
design a report. If the Edit Criteria option is selected, the database fields
available for a report are shown. The list of abbreviations for the database
fields is located vertically in the center of the screen with a highlight bar
on the first field. These fields will be referred to as report columns.
When editing the criteria, the and keys are used
to highlight a column for selection and the key acts as a toggle to
select/de-select the currently highlighted column name. If it is possible to
limit the search on a selected column, the cursor will be placed to the right
of the column name and search criteria may be entered. The search criteria
(search limitation string) may be characters or numbers that the database will
search on.
Search limitation strings are used to locate and extract subsets of the
defined report. There are three methods to limit the acceptable data for a
column: standard, exact, and extended. A search limitation string is defined
by first specifying the limit method, following it with a backslash character
("\"), and ending with a series of characters to be matched in the database.
cao.041
15
-------
Reports Modify Database File Management Utilities Quit
7:51 am
Edit Design
Retrieve Design
Delete Design
Generate Report
Output Report
View Report
Edit a Report Design by selecting Report Columns and Search Criteria
FIGURE 9. THE REPORTS MENU OF THE MAIN MENU
Reports Modify Database File Management Utilities Quit
7:51 am
Edit Design
Retrieve Design
Chemical Name
CAS Number
SIC Code
SIC Description
SCC Code
SCC Description
-
CHE
CAS
SIC
SID
SCC
SCO
Crosswalk Reference XRF
Emission Factor
EF Primary Source
EFA
EFP
EF Secondary Source EFS
EF Reference
EFR
•
=Toggle =List =Clear =Oone/Save
-------
The standard (or quick) search is the default method. If no method is
specified, the quick search will be assumed.
The default search (or quick search) looks for all records that begin
with the specified characters. The user may opt for this search by failing to
declare the search method or typing "Q\" in front of the search characters.
The user may choose to have an exact search by typing "E\" before the search
characters. The exact search looks for records that match the search
characters exactly. Finally, the user may specify an extended search by
typing "X\" before the search characters. The extended search locates all
records that have the search characters located anywhere in the database. An
example and explanation of all three searches is shown in Appendix B.
Once the search limitation string for a selected column has been typed,
press . If no criteria is needed for a column, just press to
continue. An empty search limitation string returns all data from the
database. When the criteria for a column has been completed, the highlight
bar will appear on the column that was selected and a star <*> will appear
beside it to show that it has been selected. To select another column for the
report, just cursor to it and repeat the above procedures.
Another option for selecting search criteria is the use of key.
When entering search criteria for a report column, a pick list can be
displayed with the key. The criteria can be selected by highlighting an
item and pressing the key. For example, if the "Chemical Name" report
column is selected and is pressed, a listing of all pollutants in the
database is shown and a specific compound can be selected for the search
criteria (Figure 11).
For several columns, criteria cannot be specified. If one of these
columns is selected, the cursor will not appear to the right of the name but
will remain on the column and a star <*> will appear to show that it has been
selected. All columns that have been selected will be listed horizontally in
a row at the bottom of the screen. The columns will be listed in the order in
which they were chosen (Figure 12).
The Edit Design screen may be exited by pressing the or key.
When the key is pressed, the user is prompted for an optional design
cao.041
17
-------
Reports Modify Database File Management Utilities Quit
7 52
1 1
POLLUTANT DESCRIPTION CAS NUMBER
2-Aminophenol
4-Aminophenol
2-Aminopyridine
Ammonia
Ammonium bromide
Ammonium carbamate
Ammonium chloride
Ammonium fluoride
Ammonium sulfate (2:1)
Amy I acetate
Amy I ami ne
Aniline
2-Anisidine
. Anisole
Anthracene
• Anthraquinone
95-55-6
123-30-8
504-29-0
7664-41-7
12124-97-9
1111-78-0
12125-02-9
1341-49-7
7783-20-2
628-63-7
110-58-7
62-53-3
90-04-0
100-66-3 •
120-12-7
84-65-1 J
[//]
RGURE 11. AN PICK LIST OF CHEMICAL NAMES
Reports Modify Database File Management Utilities Quit
7:52 am
Edit Design
Retrieve Design
Chemical Name
CAS Number
SIC Code
SIC Description
SCC Code
SCC Description
CHE* EXBENZENE
CAS*
SIC*
SID*
SCC
SCO
Crosswalk Reference XRF"
Emission Factor
EF Primary Source
EFA
EFP
EF Secondary Source EFS
EF Reference
EFR
CHE CAS SIC SID XRF
=Toggle =List =Clear =Done/Save =Abort
RGURE 12. COLUMN AND SEARCH CRITERIA FOR THE EDIT DESIGN SCREEN
cao.041
18
-------
filename. When the key is pressed, the user is asked whether any
changes are to be saved. If the changes are not retained, the most recent
report design will be restored.
4.1.2 Clearing A Design
If the design made during the Edit Design session is no longer wanted,
and the user wants to clear the design in order to start with a clean slate
for the design of another report, the key can be depressed. This option
clears all selected columns and any search limitation strings that were
entered in the design. The only way to restore a previous design is to have
saved it on disk (See Section 4.1.3) and retrieve it with the Retrieve Design
option (See Section 4.2).
4.1.3 Saving A Design
Once a report design has been defined it may be saved to a disk file by
pressing the key. A prompt will appear for the user to type in the
design name (Figure 13). The name may be no longer than eight characters.
The design will be saved with a ".DGN" extension in the \XATEF\DESIGN\
subdirectory. If a design by the same name already exists, the user will be
allowed to overwrite the previous design. If no design name is entered,
(default design names may be cleared by pressing the at the design
name prompt), the current design will be temporarily saved in memory without a
name. The user will be returned to the Reports Menu after the design name
prompt.
Note that a report design is saved as a DOS ASCII file. Thus, it is
possible to create and modify report designs with a standard text editor.
Examination of a report design created with the XATEF DBMS will reveal the
proper structure of the file.
4.2 RETRIEVE DESIGN
The Retrieve Design selection is used to retrieve a design that has been
saved under the Save Design (See Section 4.1.3) option. The arrow keys are
used to move the highlight bar to this selection. Pressing the key
will present the design files available to the user. The design files with
the extension ".DGN" will be listed in alphabetical order and include the
cao.041
19
-------
Reports Modify Database File Management Utilities Quit 7:53 am
Edit Design
Retrieve Design
Chemical Name
CAS Number
SIC Code
SIC Description
SCC Code
SCC Description
Crosswalk Reference
Emission Factor
EF Primary Source
EF Secondary Source
EF Reference
CHE* Ammonia
CAS*
SIC* 28
Enter the report design name—.
AMM23
-€nter=Accept—Esc=Abort—
EFP
EFS
EFR
CHE CAS SIC SID XRF
=Toggle =List =Clear =Done/Save =Abort
FIGURE 13. ENTER THE REPORT DESIGN NAME FOR SAVING TO DISK
cao.041
20
-------
filename, size, and date (Figure 14). The highlight bar can be moved to the
desired file by using the arrow keys or by typing the first letter of the
design name. The highlighted design file is retrieved by pressing the
key.
After pressing with the desired file highlighted, the Reporting
Menu will reappear. Selecting the Edit Design option at this time will
display the Edit Design Menu. The screen will reflect the contents of the
design file that was retrieved. If changes need to be made to the design,
proceed as instructed under the Edit Design (See Section 4.1.1) option.
4.3 DELETE DESIGN
The Delete Design option is used to delete a design that has been saved
under the Save Design (see Section 4.1.3) option. A scrolling window
containing the available report design will be displayed. The files will be
in alphabetical order and will include file name, size and date.
The user should highlight a design file for deletion. The highlight bar
can be moved to selected files by using the arrow keys or by typing the first
letter of the design name. After highlighting a file for deletion, the user
presses the key to remove the file. The user will be asked to verify
the deletion of the selected file.
4.4 GENERATE REPORT
Once a design is created, a report may be generated. If no design is
created and the user attempts to generate a report, the report generator will
issue an error message on the screen. Highlighting the Generate Report option
of the Reporting Menu and pressing will begin the search of the
database for the records that match the current design.
As the database is searched, a progress report will be displayed showing
the number of matches currently found (Figure 15). If no matches were found
for a particular design, an error message will appear on the screen (Figure
16). Otherwise, once all matches are found the Reporting Menu will be
reactivated and the user may choose to Output or View the report.
cao.041
21
-------
Reports Modify Database File Management Utilities Quit
7 53 am
AMM28.DGN
TEST1.DGN
TEST2.0GN
TEST3.DGN
TEST4.0GN
TESTS. DGN
TEST6.0GN
93 10-30-90
86 10-30-90
91 10-30-90
96 10-30-90
101 10-30-90
116 10-30-90
71 10-30-90
Retrieve a Previously Saved Report Design from Disk
FIGURE 14. SCROLLING WINDOW FOR SELECTING A REPORT DESIGN TO RETRIEVE
Edit Design
Retrieve Design
Delete Design
Generate Report
Output Report
View Report
Reports Modify Database File Management Utilities Quit
7:54 am
Press to pause or abort-
Please wait while the report is generated.
27 matches found—'
Generate the Report specified by the currently active Report Design
FIGURE 15. REPORT GENERATION PROGRESS REPORT
cao.041
22
-------
Reports Modify Database File Management Utilities Quit
8:51 am
Edit Design
Retrieve Design
Delete Design
Generate Report
Output Report
View Report
•Report Generation Error-
The Report was unable to be generated because
there was no match in the database for the
criteria specified in the report design.
-Esc=Continue—<
Generate the Report specified by the currently active Report Design
FIGURE 16. REPORT GENERATION ERROR MESSAGE
cao.O*!
23
-------
A report database search may be paused by pressing the key. The
user will be allowed to Abort or Continue. If the report search is aborted
all matches retrieved to that point will be retained.
If the report generation fails (no matches were found) the most recent
successful report generated in the current session (along with its design)
will be reinstated and may be Viewed or Output.
4.5 OUTPUT REPORT
The Output Report option is used to write the current report to a file
or print it. Once this option is chosen the user must decide whether to save
the current database report to a disk file or send it to the printer.
When selecting to save the file on disk the user must decide which kind
of file is best. The report may be written to a dBASE, ASCII, or Lotus 123
file. Once a particular file type is chosen, a prompt for the filename will
appear. The filename must be no longer than eight characters and no extension
should be entered with the name. Default extensions will be given
automatically. The extensions for dBASE, ASCII, and Lotus files will be
".DBF", ".ASC", and ".WK1", respectively.
After saving the report to a file, these files may be used outside the
XATEF DBMS through the particular software pertaining to that file. The files
will be saved in the \XATEF\OUTPUT\ subdirectory of the hard drive. If a
report has already been saved under the name given, the user will be allowed
to overwrite the previous report with the current report.
4.6 VIEW REPORT
Once a report has been generated it can be viewed. If the View Report
option of the Reporting Menu is selected, the report will appear on the screen
with the cursor positioned at the top of the report. To scroll through the
report use the arrow keys, the and keys, and the
and key combinations. The and keys may be used to
get to the beginning or end of a line, respectively (Figure 17).
cao.041
24
-------
Wednesday
Crosswalk Air Toxic Emission Factor
9 29
CAS Number SIC Code SIC Description
71-43-2
71-43-2
71-43-2
71-43-2
71-43-2
71-43-2
71-43-2
71-43-2
71-43-2
71-43-2
71-43-2
71-43-2
71-43-2
71-43-2
71-43-2
71-43-2
71-43-2
71-43-2
71-43-2
2231
2241
2251
2253
2254
2258
2259
2273
228
2281
2284
2299
23
232
2321
241
251
2514
2611
Broadwoven fabric mills, wool
Narrow fabric mills
Women's hosiery, except socks
Knit outerwear mills
Knit underwear mills
Lace & warp knit fabric mills
Knitting mills, nee
Carpets and rugs
Yarn and Thread Mills
Yarn spinning mills
Thread mills
Textile goods, nee
APPAREL AND OTHER TEXTILE PRODUCTS
Men's and Boys' Furnishings
Men's and boys' shirts
Logging
Household Furniture
Metal household furniture
Pulp mills
C///]
20/199
FIGURE 17. SCROLLING VIEW OF A GENERATED REPORT
cao.041
25
-------
The user may view the report on screen but is not allowed to edit any of
the information presented. Only qualified users are able to edit the contents
of the XATEF database and this is done under the Modify Database option of the
Main Menu.
If the reference information has been selected as a report column, a
description of the reference(s) for the currently highlighted report line can
be displayed by pressing the key. If the reference description(s)
require more than one window, the and keys are used to flip
between the windows.
When finished viewing the report on screen, press the backslash > key
to return to the Main Menu. The current report may be saved to disk or sent
to the printer (Figure 18). All other options of the Main Menu are also
activated.
cao.041
26
-------
Reports Modify Database File Management Utilities Quit
7:54 am
Edit Design
Retrieve Design
Delete Design
Generate Report
ASCII Disk File
dBASE Disk File
Lotus Disk File
Dot Matrix Printer
HP Laser Printer
Output the Current Report to a DOS ASCII file on Disk
FIGURE 18. THE OUTPUT REPORT MENU OF THE REPORTS MENU
cao.OAl
27
-------
cao.041
28
-------
5.0 MODIFY DATABASE
The XATEF DBMS allows anyone to create and view reports, but only those
users with access to the current password may alter, delete, or add new
information to the data files. A qualified password user may declare the
password from the command line or when the Modify Database option is selected
from the Main Menu. If the user knows in advance that editing is needed, the
XATEF DBMS should be started with the password option (/p). If the user did
not use the command line password option, the password will be requested when
the Modify Database option of the Main Menu is selected (Figure 19).
To use the command line password option, the user should begin the
program by typing (XATEF /p-"PASSWORD"). If a user leaves off the "PASSWORD"
and starts the program by typing (XATEF /p), they will be prompted to enter
the correct password. If the password is incorrect, the system will deny
entry and control will remain with DOS (Figure 3). If the password is
correct, the user will be allowed to enter the XATEF DBMS and modify the
database as desired.
The Modify Database Menu lists the files in the XATEF DBMS and allows
the user to select one for editing by highlighting it with the arrow keys and
pressing (Figure 20). The file is copied to a temporary work file and
displayed in a tabular format for editing. To edit a particular piece of
data, position the highlight bar over it and press . This will
activate the cursor and the keyboard for editing. Press when finished
editing the piece of data to re-activate the highlight bar and the navigation
(arrow) keys.
The and keys are used to insert and delete whole records
from the file. The , , , and keys are also available
for navigating the highlight bar to a particular record to be edited.
Press the key to save all edits and return to the Modify Database
Menu. Press the key to abort all edits, restore the file to its
original state, and return to the Modify Database Menu.
cao.041
29
-------
Reports Modify Database File Management Utilities Quit
9 39 am
I—(Password Verification Uindow)-
Please enter the current password below. For
security reasons it will not appear on the
screen as you type. Press Enter when
completed.
Password •->
-£nter=Cont i nue—Esc=Abort—'
Modify one of the XATEF Database System Files
FIGURE 19. THE MODIFY DATABASE MENU OF THE MAIN MENU
Reports Modify Database File Management Utilities Quit
9:38 am
Emission Factors
EF Process Descriptions
EF Source Descriptions
Emission Factor References
Crosswalk Relationships
Pollutant Descriptions
SIC Descriptions
SCC Descriptions
Crosswalk References
Modify emission factors and their associated information
FIGURE 20. PASSWORD ENTRY AND VERIFICATION SCREEN
cao.041
30
-------
6.0 FILE MANAGEMENT
The File Management option of the Main Menu allows the user to Change
the directory, Delete files (if the disk or a subdirectory becomes full), and
View ASCII text files (such as report designs or reports saved in ASCII
format) (Figure 21). All of the tasks in this section of the Main Menu can be
performed from the DOS prompt; however, this option allows the user to view an
earlier report or make room on the disk for a new report without losing a
large report recently generated.
6.1 CHANGE DIRECTORY
The Change Directory option allows the user to change the directory of
the current logical drive. When the Delete File (see section 6.2) or View
File options (see section 6.3) are selected, a list of the files in the
current directory are displayed in a scrolling selection window (Figure 22).
In order to delete or view a particular file, it may be necessary to change to
the directory where it is located. Note that the "." file in the directory
selection list refers to the current directory and the ".." refers to its
parent directory in the DOS directory tree. To change the directory from a
subdirectory to its parent directory, ".." can be selected.
6.2 DELETE FILE
The Delete File option of the File Management Menu allows the user to
delete an unwanted file. The file may be too large thus consuming too much
disk space or there may be too many files thus causing the DOS subdirectory to
overflow. A DOS subdirectory is limited in the number of files it can hold.
DOS will not allow more than a maximum number of files to reside in the same
subdirectory. This could prevent a report or report design from being saved
to disk.
To delete a file, first change the directory to the proper subdirectory
and then select the Delete File option of the File Management Menu. A list of
files (including their name, size, date, time, and attributes) will be
displayed with a highlight bar on the first file. The arrow keys are used to
move the highlight bar over the file to be deleted. When the key is
pressed, the currently highlighted file will be deleted from the disk.
cao.041
31
-------
Reports Modify Database File Management Utilities Quit
9 40 am
Change Directory
Delete File
View File
Change the Current Output and Input Sub-Directory
FIGURE 21. THE FILE MANAGEMENT MENU OF THE MAIN MENU
Reports Modify Database File Management Utilities Quit
9:53 am
DATA
DATACHK
DESIGN
OLDPRGS
OUTPUT
03-08-89
03-08-89
02-26-90
06-25-90
04-02-90
04-18-89
04-02-90
Change the Current Output and Input Sub-Directory
FIGURE 22. SCROLLING WINDOW FOR SELECTING A MEW CURRENT SUBDIRECTORY
cao.041
32
-------
6.3 VIEW FILE
The View File option of the File Management Menu uses a pop-up window to
allow the user to view a file stored in the current subdirectory of the
default logical drive. The window contains a list of all files in that
subdirectory (Figure 23). When the key is pressed, the currently
highlighted file will be displayed in a pop-up text window (Figure 24). If
the file is a standard DOS ASCII file, the user will be able to read it
without any problem. If the file is of any other type, the XATEF DBMS will
allow the user to view it; however, it may not be legible. The user may use
the arrow keys, the and keys, and the and keys to
maneuver the text around the window.
cao.041
33
-------
Reports Modify Database FiIe Management Utilities Quit 11:27 am
XATEF.MAP
FREOVER.PRG
RPTPROCS.PRG
RPTHANDL.PRG
CRIT STR.PRG
REFPROCS.PRG
CRIT OUT.PRG
CR!T~CHK.PRG
CRITERIA. PRG
DATA REP. PRG
VIDPROCS.PRG
NEWXUALK.CHK
30489 06-15-90 16:24:20 Archive
18557 06-19-90 13:44:40 Archive
96772 06-19-90 13:44:52 Archive
22677 06-19-90 13:44:48 Archive
12242 06-19-90 13:44:24 Archive
23407 06-19-90 13:44:46 Archive
29457 06-19-90 13:44:22 Archive
18385 06-19-90 13:44:20 Archive
19905 06-19-90 13:44:18 Archive
14040 06-23-90 07:55:48 Archive
11772 06-23-90 07:55:10 Archive
33574 06-23-90 17:54:40 Archive
Select and View a File from the Current Drive and Sub-Directory
FIGURE 23. SCROLLING WINDOW FOR SELECTING A FILE TO VIEW
Reports Modify Database File Management Utilities Quit
9 36 an
System: Crosswalk Air Toxic Emission Factor-DBMS
Author: Gary Patterson
06/25/90 10:09:29
Other File Summary
15 other files in the system
SPECIATE.EXE
LPATH+LNAME
&LPATH.&LNAME
&LPATH.&LBACK
+LNAME
REF.DESC.CHK
NEWXWALK.CHK
SIC DESC.CHK
Select and View a File from the Current Drive and Sub-Directory
FIGURE 24. TEXT WINDOW USED TO VIEW A DOS ASCII FILE
cao.041
-------
7.0 SYSTEM UTILITIES
The Utilities option of the XATEF DBMS Main Menu allows the user to
access some system periphery functions that are not required in the average
session. These functions include data Backup, Restore, and Integrity checking
(Figure 25). The average user will likely never use any of these functions;
however, they have been provided for the qualified user who will occasionally
modify the database and will therefore need to keep backups of the revisions
and check to make sure no inconsistencies have been introduced.
7.1 BACKUP DATABASE
When the user first receives the XATEF DBMS on floppy diskettes they
should immediately write protect them and make extra copies. The copies
should be used for installation and the originals should be kept in a safe
place for future reference.
To make copies of the distribution diskettes, the user should format the
appropriate number of disks and use the DOS diskcopy command. The user should
make sure that the backup disks are of the same type as the originals (i.e.
regular or high density) before formatting. To format a disk, the DOS format
command (FORMAT A:) should be used. After the new disks are formatted the
DOS diskcopy command (DISKCOPY A: B:) should be used to make the working
copies. Consult your DOS manual for further details.
When a qualified password user edits the database it is permanently
changed and hence become the new official version of the data. This makes it
crucial that a backup of the system be performed to protect against data loss
on the computer's fixed drive. Every time changes are made to the database,
the user should use the Backup Database option of the Utilities Menu to make a
distribution copy and file it away for safe keeping (Figure 26). The time
spent in this backup will be appreciated if the fixed disk ever fails and all
data revisions are lost.
7.2 RESTORE DATABASE
To restore the XATEF DBMS from diskette in the event of a computer disk
failure, the user should first delete all files ending in ".DBF", ".DBT", and
".NTX" from the XATEF subdirectory of the fixed drive. The DOS delete command
cao.041
35
-------
Reports Modify Database File Management Utilities Quit
9:41 am
Backup Files
Restore Files
Inspect Database
Backup the Database Files to Floppy Diskette
FIGURE 25. THE UTILITIES MENU OF THE MAIN MENU
Reports Modify Database File Management Utilities Quit
9:55 am
Source DriveXpath ... 0: \XATE F\
Target Drive A:
Number of 5 H" 360 Kb Diskettes ... 10
P ! 1 n f ! t — r : I __
EFACTOR.DBF *
Bytes:
To Copy ... 3,384,223
Copied 36,864
Completed 1 X
Please wait while the data are transfered to diskette
FIGURE 26. THE BACKUP FILES OPTION OF THE UTILITIES MENU
cao.041
36
-------
may be used to do this: (DELETE \XATEF\*.DBF), (DELETE \XATEF\*.DBT), and
(DELETE \XATEF\*.NTX) . The user should then obtain the most recent backup of
the computer system, select the Restore Database option of the Utility Menu,
and follow the instructions. If a defective or bad backup diskette is used,
the message shown in Figure 27 will appear on the screen.
The index files will have to be rebuilt when the database is restored.
This rebuilding will take about thirty minutes on a 12 Mhz AT class machine.
The XATEF DBMS will terminate itself when the restoration is finished in order
to rebuild the index files. This reindexing will be performed automatically
when the system is reactivated.
7.3 INSPECT DATABASE
The Inspect Database option of the Utilities Menu allows a user to check
the files composing the database and make sure that no inconsistencies exist
(Figure 28). The files are checked to make sure no records are duplicated and
necessary information is not missing. The files are also cross checked
between themselves to make sure that the links are in order. Things such as
an SIC code referenced in the crosswalk file that has no description in the
SIC description file are identified and itemized. A series of disk files are
created that show the results of the database inspection. These disk files
are stored in the \XATEF\DATACHK subdirectory in standard DOS ASCII file
format.
The database inspection is a very time consuming task and will take at
least ten hours to complete. It is therefore recommended that this option
only be run overnight or overweekend and that backups of the data are made
beforehand. Unpredictable results may occur if the power goes down while the
system is in the middle of its data verification.
cao.04i
37
-------
Reports Modify Database File Management Utilities Quit
10:24 am
Source Drive
Target Orive\path ..
B:
0:\XATEF\
•iles-
-Files-
-Files
i—Data Restore Error-
There is no diskette
in the drive or the
diskette is not a
backup disk.
-Esc=Continue—I
Bytes:
To Copy
Copied .
Completed
Please wait while the Data are Restored
FIGURE 27. DATA RESTORATION ERROR RESULTING FROM A BAD BACKUP DISKETTE
Reports Modify Database File Management Utilities Quit
9:57 am
—Database Inspection-
The automatic, internal validity
check of the the databases for
consistency and accuracy is very
time consuming. It will take about
eight hours on an AT machine running
at 12 Mhz. The program may generate
many pages of output in disk files.
It would be best to run this option
overnight.
-Key=Cont i nue—'
Inspect the Database Files for Consistency and Accuracy
FIGURE 28. DATABASE INSPECTION WARNING MESSAGE
cao.041
38
-------
APPENDICES
cao.041
39
-------
cao.041
40
-------
APPENDIX A
KEYSTROKE DEFINITIONS
Appendix A contains the complete list of possible keystrokes along with
their complete definition.
Key
Fl
F3
F4
F7
F8
F9
F10
Esc
Enter
UpArrow
DownArrow
PgUp
PgDn
Home
End
Ctrl-PgUp
Ctrl-PgDn
Alt-L
Alt-S
Alt-W
Definition
Obtain Help on the current system function.
Display pick list for selecting design criteria.
Clear design criteria when editing report design.
Move backward one memo when modifying a reference file.
Move forward one memo when modifying a reference file.
Display reference information about a report line.
Conclude the current operation successfully.
Cancel any operation or request of user input.
Conclude valid request of user input.
Move the highlight bar up one line.
Move the highlight bar down one line.
Move the highlight bar up one page.
Move the highlight bar down one page.
Move the highlight bar to the first column.
Move the highlight bar to the last column.
Move the highlight bar to the first page.
Move the highlight bar to the last page.
Display a pop-up list of values when modifying a file.
Select a value from a pop-up list when modifying a file.
Save a memo after editing when modifying a reference file.
cao.041
41
-------
cao.041
42
-------
APPENDIX B - HOW THE SEARCH WORKS
Appendix B describes the difference between the three basic types of
searches and the procedure to follow in specifying the particular one to use
in any given search.
When specifying search criteria for a particular report column the user
may select one of three search modes. These modes are called (1) Quick, (2)
Exact, and (3) Extended. These modes are initiated by placing the following
characters before search characters: (1) Quick - "Q\", (2) Exact - "E\", and
(3) Extended - "X\".
A Quick Search is the default search method and will be used unless the
user specifies otherwise. A Quick Search may be explicitly declared by
preceding any entered text with a "Q\". For instance, to perform a Quick
Search of pollutants whose name begins with "1,3", the user may enter "Q\l,3"
as the pollutant name search criteria. Of course, because a Quick Search is
the default search method, the user could have just entered "1,3" and received
the same report.
An Exact Search is similar to the Quick Search. If the pollutant name
search criteria is "1,3" the Quick Search will return all pollutants whose
name begins with "1,3" whereas the Exact Search will return the pollutant
whose name is exactly "1,3". This search is provided for the user who may
want "Benzene" but not "Benzene, Chloro-" or "Benzene, Ethyl-". An exact
search is performed by entering "E\" before the search characters.
Quick and Exact searches use the data indexes when performing their
task. This means that only those pollutants whose name begins with the search
text will be found. The use of the indexes dramatically increases performance
time because they contain a sorted listing of the data files and it eliminates
the need to search the entire file to find any matches. When the Quick or
Exact Search comes to a pollutant name greater than the text it is searching
for, it knows that there can be no more matches in the remainder of the entire
file. Thus Quick and Exact searches quickly and efficiently find every match
of the text entered by the user.
Suppose, however, that a user wanted to find every SIC whose description
contained the word "coal" or every emission factor source that contained the
cao.041
43
-------
word "fireplace". A Quick Search would not be able to do the job. It would
only find the data which began with the entered text. Quick Search would find
"coal combustion" and "coal production" but it would not find "utility boiler,
coal". To solve this problem a user may perform an extended search when
attempting to locate a pollutant name, SIC description, SCC description,
emission factor process description, or emission factor source description.
An Extended Search does not use any data index. It starts at the
beginning of the data file and examines every entry in sequence until it
reaches the end of the file. Within each record it thoroughly searches the
appropriate information to find the text entered by the user. It is as if
Extended Search creates a window containing the user text. This window is
started at the beginning of every record's information and moved one character
at a time until it reaches the end. It then moves the window to the next
record and repeats this procedure. If the window ever matches the information
underneath it, then the record is recognized as a valid match. In computer
jargon, Extended Search performs a substring search on the appropriate data
field to find a natch.
The only way to perform an Extended Search is to explicitly declare it
when entering text. If the user enters "X\" before any search restraint text,
an Extended Search will be performed. Thus an emission factor process
description search criteria defined as "X\coal" will find "coal combustion",
"coal production", and "utility boiler, coal" in addition to any other
processes containing the work "coal". The Extended Search is slow and
cumbersome, but very rigorous. It is left to the user to determine when an
Extended Search is appropriate.
cao.041
44
-------
APPENDIX C - SYSTEM DEVELOPMENT TOOLS
Appendix C describes the computer tools used in developing and
documenting the XATEF DBMS for the IBM AT PC.
The XATEF DBMS was written with Brief/dBrief, compiled with Clipper
Summer 87, and linked with Blinker 1.30. The FUNCKY library from dLESKO and a
Radian proprietary library were used for windowing, file access, and various
other sundry tasks. The source code is available upon request.
cao.041
45
-------
cao.OAl
46
-------
APPENDIX D - DATABASE ORGANIZATION
Appendix D displays a graphic representation of the overall database
organization.
cao.041
47
-------
R*_Cod«
Num 5,0
Scc.Cod*
Char 8
JSCC_OMC4
Char17
Scc_DMe3
Char 17
5cc_0«*c2 Bcc_0««c1
Char 17 Char17
Ste_Cod«
Char 4
Scc_Cod»
CharS
Efactor
Char 40
flpe.Cod*
Num 5.0
Rsc_Cod»
Num 5.0
R«f_OMC
MamolO
R«f_Cod«
Num 5,0
Poe_Cod«
Num 5,0
Poc_Cod«
Num 5,0
Sic_Cod«
Char 4
Scc.Cod«
CharS
SIC.OMC
Char 40
Ste_Cod«
Char 4
Rre_Cod«
Char 40
R*c_Cod«
Num 5,0
R*e_0««c
Char 70
Poc_0««c
Char 60
C«*_Numb«r
Char 9
Rtaca^Cod*
Char 9 I
Poc_Cod«
Num 5,0
Notaa
Char 100
Valid_N«d»
Log1
Rre.Cod*
Num 5
Rre_OMc
MwnolO
Rpc_Cod«
NimS.0
Rpe.0«ae
Char 60
cao.041
48
-------
APPENDIX E
DATABASE FILE STRUCTURES
Appendix E lists the internal file structure of every data file in the
database and includes mention of each index field.
System: Crosswalk Air Toxic Emission Factor DBMS
Database Structure Summary
10 databases in the system
POC_DESC.DBF
SIC_DESC.DBF
SCC_DESC.DBF
RPC_DESC.DBF
RSC_DESC.DBF
EFACTOR.DBF
NEWXWALK.DBF
REF_DESC.DBF
RRC_DESC.DBF
HELPMAST.DBF
Structure for database
Number of data records
Last updated
Field Field name Type
1 POC_CODE
2 POC_DESC
3 CAS_NUMBER
4 RTECS CODE
** Total **
POC_DESC.DBF
1151
04/23/90 at 10:00
Width Dec Start End
Numeric 5 15
Character 60 6 65
Character 9 66 74
Character 9 75 83
84
This database is associated with index file(s):
POC_DES1.NTX
POC_DES2.NTX
POC_DES3.NTX
POC_DES4.NTX
POC_DES5.NTX
POC DES6.NTX
(poc_code)
(UPPER(poc_desc))
(cas_number)
(UPPER(alphafirst(poc_desc)
(casdash(cas_number))
(rtecs_code)
Structure for database SIC_DESC.DBF
Number of data records 1515
Last updated 06/28/90 at 12:51
Field Field name Type Width Dec
1 SIC_CODE Character 4
2 SIC_DESC Character 40
** Total ** 45
Start
1
5
End
4
44
cao.041
49
-------
This database is associated with index file(s):
: SIC_DES1.NTX (sic_code)
: SIC DES2.NTX (UPPER(sic desc))
Structure for database
Number of data records
Last updated
Field Field name Type
1 SCC_CODE
2 SCC_DESC1
3 SCC_DESC2
4 SCC_DESC3
5 SCC_DESC4
** Total **
SCC_DESC.DBF
3393
06/28/90 at 12:51
Width Dec Start End
Character 8 18
Character 17 9 25
Character 17 26 42
Character 17 43 59
Character 17 60 76
77
This database is associated with index file(s):
: SCC_DES2.NTX (UPPER(scc_descl+scc_desc2+scc_desc3+scc_desc4))
: SCC_DES1.NTX (scc_code)
Structure for database RPC_DESC.DBF
Number of data records 428
Last updated 06/28/90 at 12:51
Field Field name Type Width Dec
1 RPC_CODE Numeric 5
2 RPC_DESC Character 60
** Total ** 66
Start
1
6
End
5
65
This database is associated with index file(s):
: RPC_DES1.NTX (rpc_code)
: RPC_DES2.NTX (UPPER(rpc_desc))
Structure for database RSC_DESC.DBF
Number of data records 1226
Last updated 06/28/90 at 12:51
Field Field name Type Width Dec
1 RSC_CODE Numeric 5
2 RSC DESC Character 70
Start
1
6
End
5
75
** Total **
76
This database is associated with index file(s):
: RSC_DES1.NTX (rsc_code)
: RSC DES2.NTX (UPPER(rsc desc))
cao.041
50
-------
Structure for database
Number of data records
Last up
Field Field name
1 EFACTOR
2 POC_CODE
3 SIC_CODE
4 SCC_CODE
5 RPC_CODE
6 RSC CODE
7 RRC~CODE
8 NOTES
9 VALID_NEDS
** Total **
ase EFACTOR. DBF
rds
3605
ted 06/28/90 at
Type Width
Character 40
Numeric
Character
Character
Numeric
Numeric
Character
Character
Logical
5
4
8
5
5
40
100
1
209
12:51
Dec
Start
1
41
46
50
58
63
68
108
208
End
40
45
49
57
62
67
107
207
208
This database is associated with index file(s)
EFACTOR2.NTX
EFACTOR3.NTX
EFACTOR4.NTX
EFACTOR5.NTX
EFACTOR6.NTX
EFACTOR1.NTX
(poc_code)
(sic_code)
(scc_code)
(rpc_code)
(rsc_code)
(index key not found)
Structure for database NEWXWALK
Number
Field
1
2
3
4
DBF
of data records 52464
Last updated 06/28/90 at 12:51
Field name Type Width Dec
SIC CODE Character 4
SCC CODE
POC CODE
REF~CODE
Character
Numeric
Numeric
** Total **
8
5
5
23
Start
1
5
13
18
End
4
12
17
22
This database is associated with index file(s):
XWALK345.NTX
XWALK354.NTX
XWALK435.NTX
XWALK453.NTX
XWALK534.NTX
XWALK543.NTX
(STR(poc_code,5,0)+sic_code+scc_code)
(STR(poc_code,5,0)+scc_code+sic_code)
(s ic_code+STR(poc_code,5,0)+scc_code)
(sic_code+scc_code+STR(poc_code ,5,0))
(scc_code+STR(poc_code,5,0)+sic_code)
(scc_code+sic_code+STR(poc_code,5,0))
Structure for database REF_DESC.DBF
Number of data records 29
Last updated 06/28/90 at 12:51
Field Field name Type Width Dec
1 REF_CODE Numeric 5
2 REF DESC Memo 10
** Total ** 16
Start
1
6
End
5
15
cao.041
51
-------
This database is associated with the memo file: REF_DESC.DBT
This database is associated with index file(s):
: REF DES1.NTX (ref code)
Structure for database
Number of data records
Last updated
Field Field name Type
RRC_DESC.DBF
165
06/28/90 at 12:51
Width Dec
1 RRC_CODE
2 RRC_DESC
** Total **
Numeric
Memo
5
10
16
Start
1
6
End
5
15
This database is associated with the memo file: RRC_DESC.DBT
This database is associated with index file(s):
: RRC DES1.NTX (rrc code)
Structure for database : HELPMAST.
Number
,DBF
of data records : 13
Last updated : 06/28/90
Field
1
2
3
Field name
HELPKEY
CALLPROG
HELPMSG
at 12:51
Type Width Dec
Character
Character
Memo
** Total **
10
8
10
29
Start
1
11
19
End
10
18
28
This database is associated with the memo file: HELPMAST.DBT
This database is associated with index file(s):
: HELPMAST.NTX (TRIM(UPPER(helpkey))+UPPER(callprog))
System: Crosswalk Air Toxic Emission Factor DBMS
Data Dictionary
Field Name
CALLPROG
CAS NUMBER
EFACTOR
HELPKEY
HELPMSG
NOTES
POC_CODE
POC DESC
REF_CODE
Type
C
C
C
C
M
C
N
C
N
Len
8
9
40 '
10
10
100
5
60
5
Dec
0
0
0
0
0
0
0
0
0
Database
HELPMAST. DBF
POC DESC. DBF
EFACTOR. DBF
HELPMAST. DBF
HELPMAST. DBF
EFACTOR. DBF
POC DESC. DBF
EFACTOR. DBF
NEWXWALK.DBF
POC DESC. DBF
REF DESC. DBF
NEWXWALK.DBF
cao.041
52
-------
REF_DESC
RPC_CODE
RPC_DESC
RRC_CODE
RRC_CODE
RRC_DESC
RSC_CODE
RSC_DESC
RTECS_CODE
SCC CODE
SCC_DESC1
SCC_DESC2
SCC_DESC3
SCC_DESC4
SIC CODE
SIC_DESC
VALID NEDS
M 10 0 REF_DESC.DBF
N 50 RPC_DESC.DBF
EFACTOR.DBF
C 60 0 RPC_DESC.DBF
N 50 RRC_DESC.DBF
C 40 0 EFACTOR.DBF
M 10 0 RRC_DESC.DBF
N 50 EFACTOR.DBF
RSC_DESC.DBF
C 70 0 RSC_DESC.DBF
C 90 POC_DESC.DBF
C 80 EFACTOR.DBF
NEWXWALK.DBF
SCC_DESC.DBF
C 17 0 SCC_DESC.DBF
C 17 0 SCC_DESC.DBF
C 17 0 SCC_DESC.DBF
C 17 0 SCC_DESC.DBF
C 40 EFACTOR.DBF
NEWXWALK.DBF
SIC_DESC.DBF
C 40 0 SIC_DESC.DBF
L 10 EFACTOR.DBF
cao.041
53
-------
cao.041
54
-------
APPENDIX F - CREATING AND USING DOS BATCH FILES
A DOS batch file is an ASCII text file containing one or more DOS
commands. These commands are the same ones that could be entered at the DOS
prompt. They may be stored in a file and are executed in a logically
sequential order by DOS when the file name is entered. They must be stored
with one command per line and the file name must have a ".BAT" extension.
An ASCII text file can be created by using the DOS COPY CON command, the
DOS EDLIN command, or a text editor/word processor. The COPY CON command will
be used in the example below. The EDLIN command is discussed in any DOS
manual. The COPY CON command has the following format: COPY CON .
The is the name of the file to create. Once the command is issued,
every line entered until is pressed will be stored in the
. The lines will be stored in ASCII format. is entered
by holding down the key and pressing the key.
To make a batch file called XAT.BAT that will automatically start the
XATEF DBMS type the following commands and information at the DOS prompt:
1. COPY CON XAT.BAT
2. CD \XATEF
3. XATEF [/A,/M,/P,/S]
4.
where the [/A,/M,/P,/S] represents the command line switches to use.
An ASCII text file called XAT.BAT has now been created. It may be
copied, viewed, and printed like any other file. This file is also a DOS
batch file because it has a ".BAT" extension. If XAT is entered at the DOS
prompt the commands stored in it will be executed.
cao.041
55
-------
TECHNICAL REPORT DATA
(Please read Instructions on the reverse before completing)
REPORT NO.
EPA-450/2-89-018
2.
3. RECIPIENT'S ACCESSION NO.
TITLE AND SUBTITLE
Crosswalk/Air Toxic Emission Factor Data
Base Management System User's Manual
5. REPORT DATE
August 1990
6. PERFORMING ORGANIZATION CODE
. AUTHOR(S)
8. PERFORMING ORGANIZATION REPORT NO
Gary N. Patterson
. PERFORMING ORGANIZATION NAME AND ADDRESS
Radian Corporation
Post Office Box 13000
Research Triangle Park, NC
10. PROGRAM ELEMENT NO.
27709
11. CONTRACT/GRANT NO.
68-02-4392
2. SPONSORING AGENCY NAME AND ADDRESS
U.S. Environmental Protection Agency
OAR, OAQPS, AQMD, NPPB, PCS (MD-15)
Research Triangle Park, NC 27711
13. TYPE OF REPORT AND PERIOD COVERED
Final
14. SPONSORING AGENCY CODE
S. SUPPLEMENTARY NOTES
EPA Project Officer: Anne A. Pope
6. ABSTRACT
This report presents instructions on the Crosswalk/Air Toxic
Emission Factor data management system (XATEF). The system was
designed to allow rapid identification and cross-referencing of
toxic air pollutant/emission source associations and to provide
corresponding emission factors for these associations as
available. The system contains Standard Industrial
Classification (SIC) code/Source Category Code (SCC)/pollutant
cross-references found in Toxic Air Pollutant/Source Crosswalk -
A Screening Tool For Locating Possible Sources Emitting Toxic Air
Substances. Second Edition. EPA-450/2-89-017; and air toxic
emission factors compiled in Toxic Air Pollutant Emission Factors
- A Compilation For Selected Air Toxic Compounds And Sources.
Second Edition. EPA-450/2-90-011. The program has modules that
allow users to search and download data to printers or files.
The purpose of this report is to document the usage of the
system. EPA is making available the system and data to agency -
users on one high density (1.2 MB) diskette.
7.
KEY WORDS AND DOCUMENT ANALYSIS
DESCRIPTORS
b.lOENTIFIERS/OPEN ENDED TERMS C. COSATI Field/Croup
Air Toxics
Emission Factors
Toxic Emissions
Pollutant/Source Associations
Data System
18. DISTRIBUTION STATEMENT
Unlimited
19. SECURITY CLASS (TIliS Report)
Unclassified
1. NO. OF
;ES
20. SECURITY CLASS (Tliispagei
Unclassified
22. PRICE
_6JL
EPA Fom 2220-1 (R«». 4-77) PREVIOUS EDITION it OBSOLETE
------- |