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

-------