vvEPA
              United States
              Environmental Protection
              Agency
              Office Of Water
              (WH-556F)
EPA/500/9-90/005
October 1990
Office Of Water
Administrative Systems
Compendium
            Water
           Programs
  Data for
  Decision
  Making
                              pit
                              f
                  Information Resources
                      Management:
                    Tools For Making
                 Water Program Decisions

-------
                              Administrative Systems Compendium                      FY 1990
                          Acknowledgements
3
                     This document was prepared for the U.S. Environmental
                     Protection Agency under Contract Number 68-W9-0039.
                     Ms. Wendy Blake-Coleman, of the Office of Resources
                     Management and Administration, served as the manager
                     for the project.

                     I would like to thank the Administrative Systems contacts
                     listed within the compendium who were instrumental in
                     supplying information about the systems and reviewing
                     the compendium.
                                          Mary E. Blakeslee
                                          Director
                                          Office of Resources Management
                                            and Administration
                           U.S. Environmental Protection ARency
                           Region 5, Library (PL-12J)
                           77 West Jackson Boulevard, 12th Floor
                           Chicago, IL  60604-3590
                                                                 Printed on Recycled Papei
     US. EPA/OW

-------
                  Administrative Systems Compendium                         FY 1990
                                  Table of Contents
                     Title
                     Acknowledgements	   i
                     Table of Contents	  iii
                     Introduction  	   1
                     Matrices  	   5
                     Administrative System Profiles	   9
                     Correspondence Systems 	   9
                     Personnel Management Systems	  13
                     Project Management Systems 	  15
                     Property and Equipment Inventory Systems 	  17
                     Publications Management Systems	  19
                     Regulation Development Systems	  22
                     Resource Tracking and Management Systems	  22
                          Budget 	  22
                          Contracts	  26
                          Resource Allocation Models 	  28
                          Training	  32
                          Travel	  33
                     Acronyms	  37

                     Appendix:
                     Index of Information Systems	  39
U.S. EPA/OW                                                             Hi

-------
                            Administrative Systems Compendium                        FY 1990
                            Introduction
             Overview     The use of office automation technology to improve staff
                            productivity and facilitate information exchange among Water
                            Program Offices is a key goal of the Water Program.  The ability
                            to meet this goal is improving as the number of Water staff
                            with access to PCs  increases. During Fiscal years 1989 and 1990,
                            the number of PCs in the Water Program increased from
                            approximately 300 to more than 600, providing virtually every
                            OW employee with access to a PC.  These workstations are
                            potentially powerful management tools, and provide an
                            opportunity for staff to automate many program and office
                            management functions that are routinely done manually.

                            Prior to developing this compendium, the Water Program
                            suspected that many people were not realizing the potential of
                            their PCs for office automation tasks, and as a result, were not
                            taking full advantage  of their machines.  The majority of the
                            staff used their PCs primarily to create word processing files and
                            spreadsheets. These are steps toward office automation;
                            however, there is a wider range of PC-based tools that the Water
                            Program can develop, including data base management systems,
                            analytical models and various types of tracking systems.

                            In interviews conducted during development of the Office of
                            Water Environmental and Program  Information Systems
                            Compendium, Office of Water staff indicated that many
                            administrative systems are available throughout the Office of
                            Water, but many staff are not aware of their availability.
                            Subsequently, the  Office of Water developed this document to
                            assist Water Program staff in locating existing administrative
                            systems that they can use to improve their productivity.
                            Furthermore, the Office of Water believes that increased
                            awareness of existing  systems will result in resource savings
                            since many existing systems can be modified to meet specialized
                            requirements, reducing the need to develop costly customized
                            applications.
U.S. EPA/OW

-------
                            Administrative Systems Compendium
                                                    FY 1990
                            Introduction
              Purpose
          Process for
      Developing the
         Compendium
              How the
      Compendium is
            Organized
 A key purpose of this compendium is to provide a technical
assistance tool to Water Program Managers, support staff, and
PC site coordinators that increases their awareness of the types
of routine office activities that can be automated and encourages
increased use of automation by providing a listing of existing
administrative systems in the Office of Water.  Other objectives
include:  improved intra- and inter-office communication of
office automation activities to reduce duplicative system
development efforts, and more effective use of limited
resources through  cross-program coordination on
administrative systems development.  It is hoped that this
document will serve as a starting point for cross-program
dialogue on:  additional administrative areas which might
benefit from  automation, joint assessments on information
needed for  applications in these administrative areas, and
development of generic administrative systems that can be
utilized across programs.

Interviews were held with approximately  100 Office of Water
staff to determine the types of information systems currently
used in each  Division of each Water Program Office. Water
staff worked  closely in the development of this compendium to
ensure that it accurately represents the administrative systems
maintained by the  Water Program. These staff provided
background material and reviewed drafts  of the system
narratives for accuracy.  Their contributions have helped
significantly in ensuring that the compendium provides a clear
and accurate  summary of the purpose and content of each
system.

This compendium contains an inventory  of approximately 100
administrative  systems maintained by the Headquarters Water
Program.  The term "system" is defined as an ordered and
comprehensive assemblage of information.  Most, but not all, of
the systems listed are automated.  They have been organized
into seven  categories that reflect major administrative tasks
carried out in the Water Program Offices.  These categories are:

   Correspondence Systems

   Personnel Management  Systems

   Project Management Systems

   Property and Equipment Inventory Systems
2
                                               U.S. EPA/OW

-------
                            Administrative Systems Compendium                        FY 1990
                            Introduction
                            m   Publications Management Systems

                               Regulation  Development Systems

                               Resource Tracking and Management Systems

                                   Budget

                                   Contracts

                                   Resource Allocation Models

                                   Training

                                --  Travel

                            A set of overview matrices serves as a tool with which users can
                            quickly identify the types and numbers of administrative
                            systems available in each of the seven Water Program Offices
                            and target those systems that warrant further investigation.
                            Each system entry  contains the name of the system; the division
                            in which it is located; whether the system  is PC-based,
                            mainframe-based, or non-automated; the type of software used;
                            and a page reference where more detailed information can be
                            found.

                            The main body of  the compendium consists of a narrative
                            section with short  descriptions of each system contained in the
                            overview matrix.  Each system narrative provides the name of
                            the system, the Program Office and Division responsible for its
                            operation, the hardware and software used, and a point of
                            contact.  A brief description summarizes the purpose of and the
                            type of information available from each system. The systems
                            are arranged alphabetically under each  major category within
                            the narrative section.

                            This document is a companion to The Office of Water
                            Environmental  and Program Information Systems
                            Compendium.  That document contains descriptions of
                            approximately 195 Water Program  information systems in the
                            following broad categories:

                               Environmental and  Program Areas

                               Outreach (e.g., hotlines, clearinghouses, and bulletin boards)


U.S.  EPA/OW                                                                          3

-------
                            Administrative Systems Compendium                        FY 1990
                            Introduction
                              Program and Information Management Tools (e.g., models,
                               analytical tools, and access tools)

                            The Office of Water Environmental and Program Information
                            Systems Compendium is available from the Office of Water.
4                                                                          U.S. EPA/OW

-------
         OVERVIEW MATRICES
OFFICE OF WATER SYSTEMS INVENTORY
        Administrative Systems
^^^^^ Office
Category ~"--^




Correspondence
Systems












Personnel
Management
Systems



Project
Management
Systems




Immediate
Office
Correspondence
Tracking System
(RMAO, PC, dBASE;
p.11)
Correspondence
Tracking System (WPO,
PC,dBASE;p.11)
















Office ol Water Priority
Workload Tracking
System (WPO, PC;
dBASE/Clipper;p.15)






ODW

Correspondence
Tracking System
(CSD;
Non-automated,p9)
Correspondence
Tracking System (10,
PC;dBASE;p.10)
Correspondence
Tracking System
(SPD; Non-automated:
p. 10)

Correspondence
Tracking System
(SPD/UICB; PC, PFS;
p.10)
Bi-Weekly Personnel
Status Report (PDED;
PC; WordPerfect;
D131
r l0/
Personnel Roster
(PDED; PC;
WordPerfect, p.13)
Workplan Milestone
Tracking System
(CSD; PC; dBASE;
p.16)






OGWP

Office Activities
Tracking System
(OATS) (10; PC; Lotus
Agenda; p13)











Personnel Tracking
System (GWMPS, PC,
Lotus 1 -2-3, p 14)





Office Activities
Tracking System (10;
PC; Lotus Agenda;
P-13)






OMEP

Correspondence
Tracking System (10;
PC, dBASE, p 10)



















Action Tracking
System (TSD; PC;
dBASE; p.15)







OWP






























OWRS

Correspondence
Tracking System (10,
PC; WordPerfect;
p12)
Correspondence
Tracking System
(ITD; PC;
WordPerfect; p.1 2)

Information Services
Section Tracking
System (AWPD;
Mainframe; TSO,
p.12)



Personnel Tracking
System (AED; PC;
Lotus! -2-3; p.1 4)





Division Activities
Tracking System
(AWPD; PC;
WordPerfect; p.1 5)






OWEP

Control
Correspondence Log
(PD; PC; WordPerfec
p.9)
Correspondence
Tracking System (10;
PC; dBASE; p.1 1)









Compressed Work
Week Tracking
System (PD, PC;
Lotus 1-2-3; p.1 3)




Internal ATS
Tracking System
(PD; PC;
WordPerfect; p.1 5)
Regional Special
Project Tracking
System (10; PC;
dBASE; p 16)
Work Assignment
Manager Data Base
(10; PC, dBASE;
p.16)
OMPC

Correspondence
Control Tracking
System (K); PC;
dBASE; p 9)











Personnel Roster
System (PAD; PC;
dBASE; p 14)

Personnel Status
Report (PAD; PC,
dBASE, p.1 4)










-------
                                             OVERVIEW MATRICES
                                    OFFICE OF WATER SYSTEMS INVENTORY
                                            Administrative Systems
I
^~"\^^Office
Category^*"^^




Property and
Equipment
Inventory
Systems









Publications
Management
Systems




Regulation
Development
Systems
Immediate
f\f f* :. _
Office
OW Immediate Office
Hardware and
Software Inventory
(RMAO,PC;dBASE,
p17)




















ODW














Health Advisory
Request Tracking
System (CSD, PC,
dBASE/FoxBASE;
p20)
Mailing List for Lab
Certification Bulletin
(TSD, PC, dBASE;
p20)




OGWP

Property Inventory
(GWMPS, PC, Lotus
1-2-3,p.19)










Automated Mailing List
(GWMPS, PC, Avery
List & Mail Plus; p 19)

Document Numbering
System (GWMPS, PC,
dBASE; p 19)
Publications Distribution
Tracking System
(GWMPS; PC; dBASE;
p21)


OMEP


























OWP

PC Inventory
System (10; PC;
Lotus 1 -2-3; p 17)






















OWRS

PC Inventory System
(AED; PC; Lotus
1-2-3;p.18)

PC Inventory System
(CSD; PC; Lotus
1-2-3;p18)
PC Inventory Tracking
System (AWPD, PC,
dBASE; p 18)
PC Tracking System
(ITD, PC, Lotus 1-2-3,
p18)
Automated Mailing
List for the Nonpomt
Source Program
(AWPD; PC; dBASE;
p19)
Document Numbering
System (AED; PC,
dBASE; p 20)



Control and Receipt
System lor Public
Comments (AED;
PC; dBASE; p.22)
OWEP

PC Inventory for the
Permit Division (PD;
PC; WordPerfect;
p17)

PC Inventory System
(ED; PC, dBASE IV;
p.17)





Mailing List for the
Pretreatment
Quarterly Newsletter
(PD; PC, dBASE,
p.21)





Regulation Status
Tracking System (PD,
PC, Lotus 1-2-3; p 22)

OMPC

PC Tracking Inventory
(MCD; PC; dBASE,
p.18)










Infrastructure
Financing Publications
Distnbution List (MFD,
PC; d BASE, p 20)

Onsight/Oversight
Mailing List (PAD, PC;
WordPerfect, p 21)







-------
I
        OVERVIEW MATRICES
OFFICE OF WATER SYSTEMS INVENTORY
        Administrative Systems
^^^^omce
Category --^
Resource
Tracking and
Management


T




(Budget)












(Contracts)






Immediate
Qf f  - _
Office
BUD 2 System (10;
PC, dBASE, p 22)
PC&B System
(RMAO, PC,
dBASE/Clipper; p.24)

























ODW

BUD 2 System
(PDED, PC; dBASE;
P-22)
PC&B System (PDED;
PC; dBASE/Clipper;
p24)

Status of Funds
System (PDED; PC,
Lotus 1 -2-3; p 25)









Contract Expenditure
Tracking Systems
(CSD; PC; Lotus
1-2-3;p.26)










OGWP

BUD 2 System
(GWMPS; PC; dBASE;
P22)
Internal Operating
Budget Tracking
System (GWMPS, PC;
Lotus! -2-3; p.23)

PC&B System
(GWMPS; PC;
dBASE/Clipper; p.24)
Printing Request
Tracking System
(GWMPS, PC, Lotus
1-2-3;p25)




Contract Tracking
System (GWMPS; PC
Lotus 1 -2-3, p.27)










OMEP

BUD 2 System
(PMSS, PC; dBASE;
P-22)
Extramural Funds
Tracking System
(PMSS; PC;
dBASE/Lotus1-2-3/
WordPerfect; p.23)

PC&B System
(PMSS, PC;
dBASE/Clipper; p.24)



















OWP

BUD 2 System (10;
PC, dBASE; p.22)
Headquarters
AC&C Expenditures
Tracking System
(K); PC; Lotus
1-2-3, p.23)

PC&B System (10;
PC; dBASE/Clipper;
p.24)
Regional AC&C
Expenditures
Tracking System
(10; PC; Lotus
1-2-3;p.25)














OWRS

BUD 2 System (AED;
PC, dBASE, p.22)
Internal Operating
Budget Tracking
System (AED; PC;
Lotus 1 -2-3; p.23)

Intramural Funds
Tracking System
(AWPD; PC; Lotus
1-2-3, p.24)
Intramural Funds
Tracking System
(ITD; PC, dBASE;
p.24)

PC&B System (AED;
PC; dBASE/Clipper;
p24)
Contract Expenditure
Tracking System
(AED; PC; Lotus
1-2-3,p26)

Contract Monitonng
System (AWPD; PC;
Lotus 1-2-3; p.27)






OWEP

BUD 2 System (10;
PC, dBASE; p.22)
PC&B System (10;
PC, dBASE/Clipper;
p.24)














Contract Tracking
System (ED; PC;
Lotus 1-2-3; p.27)
Contract Tracking
System (10; PC;
Lotus 1 -2-3 ;p 27)
Contract Tracking
System (PD; PC;
Lotus 1 -2-3; p.28)
Pretreatment
Contract Tracking
System (PD; PC;
Lotus 1 -2-3, p 28)
OMPC

BUD 2 System
(PAD; PC; dBASE,
p22)
PC&B System (PAD;
PC; dBASE/Clipper;
p.24)













Contract Expenditure
Tracking System
(PAD; PC; Lotus
1-2-3;p.26)

Corps of Engineers
(COEj Tracking
System (PAD; PC,
Lotus 1 -2-3, p 28)







-------
oo
                                             OVERVIEW MATRICES
                                     OFFICE OF WATER SYSTEMS INVENTORY
                                             Administrative Systems
">>"x->v^Office
Category **--^
Resource
Tracking and
Management
(Continued)



(Resource
Allocation
Models)












(Training)

(Travel)



Immediate
Office






















Travel Tracking
System (RMAO; PC;
Lotus 1-2-3, p35)




ODW
Public Water Systems
Supervision
Enforcement Workload
Model (SPD; PC; Lotus
1-2-3;p.29)

Public Water Systems
Supervision Program
Grant Allocation
Formula (SPD, PC,
Lotus 1 -2-3, p.29)
Public Water Systems
Supervision Workload
Model (SPD, PC; Lotus
1-2-3, p 30)

UIC Workload Model
(SPD; PC, Lotus 1-2-3,
p30)

Training Tracking
System
(CSD/HEB/STB;
Non-automated, p.32)
Travel Tracking
System (CSD; PC;
Lotus 1-2-3; p33)

Travel Tracking
System (SPD, PC,
Lotus 1-2-3; p.34)
OGWP






















Travel Tracking System
GWMPS; PC, Lotus
1-2-3; p.34)




OMEP
Workload Model
(PMSS, PC; Lotus
1-2-3;p.31)
Workload Models
(PMSS; PC, Lotus
1-2-3;p31)






















OWP






















Travel Tracking
System (10, PC,
Lotus 1-2-3; p35)




OWRS
Workload Model lor
Section 106 Grants
(AED; PC, Lotus
1-2-3;p31)
Workload Model lor
Water Quality
Management, Water
Monitoring, and
Standards and
Regulations FTEs
(AED, PC, Lotus
1-2-3,p32)












Travel Management
System (ITD, PC,
dBASE, p.33)

Travel Tracking
System (AWPD, PC,
Lotus 1-2-3; p35)
OWEP


















Training Activity
Tracking System (ED,
PC, dBASE IV, p 32)

Travel and S&E
Tracking System (PD;
PC; Lotus 1-2-3; p33)

Travel Tracking
System (ED; PC; Lotus
1-2-3/dBASEIV; p.35)
OMPC
Construction Grants
Outlay Model (MCD,
PC, BASIC; p 28)
ESP Regression
Model 1 (Outlay
Model) (MCD,
Mainframe, ESP; p 29

Regression Model 2
(Outlay Model) (MCD;
PC, Time Series
Process (TSP), p 30)

Slate Revolving Fund
Outlay Model (MCD,
PC, BASIC, p 30)

Workload Model
(MCD, PC, Lotus
1-2-3,p31)




Travel Tracking
System (PAD, MCD,
MFD; dBASE, p.34)





-------
                           Administrative Systems Compendium
                                               FY 1990
                           OW HQ Administrative  Systems
     Correspondence
             Systems:
Control Correspondence Log (PC, WordPerfect 4.2,
OWEP/PD)

This system tracks controlled correspondence, particularly
Congressionals. It contains the following information:
who sent the correspondence, date received, staff assigned
to respond, the date when the task was completed, and the
date the response was sent to the Permit Division or OWEP
Office Director for signature.

Contact:  Barbara Featherstone - (202) 475-9545

Correspondence Control Tracking System (PC, dBASE,
OMPC/IO)

The purpose of this system is to track controlled
correspondence.  The following information is tracked:
date received, who sent the correspondence, staff assigned
to respond, date response was completed, and the date the
material was sent to the Division Director, Office Director
or AA for signature.

Contacts:  Carolina Hicks - (202) 382-5856 and Linda Brooks
- (202) 382-5853

Correspondence Tracking System (Non-automated,
ODW/CSD)

This system enables staff to track controlled
correspondence, particularly Congressionals.  Material
assigned to Division Staff by the Division Director is also
tracked.  The system contains information on: the date the
correspondence was received, who originated the
correspondence, an identification code for each piece of
correspondence received, the date a response is required,
the staff assigned to  respond to the correspondence, the
date the response is completed and the date it is submitted
to management.

Contact:  Jannell Young - (202) 382-7575
U.S. EPA/OW
                                                    9

-------
                           Administrative Systems Compendium
                                               FY 1990
                           OW HQ Administrative Systems
    Correspondence
             Systems
         (Continued):
Correspondence Tracking System (PC, dBASE, ODW/IO)

This system enables staff to track controlled
correspondence, particularly Congressionals. It tracks
information on the status of material sent to Divisions by
either the Officer Director or Deputy Office Director.

Contact: Beverly Cook - (202) 382-5508

Correspondence Tracking System (Non-automated,
ODW/SPD)

The purpose of the system is to track responses to
controlled correspondence received by the State Programs
Division (e.g., Congressionals and other correspondence
with deadlines).  The system tracks the date material is
received, staff assigned to respond, and the date material is
signed or sent to management for signature.

Contact: Carolyn Acklin: (202) 382-5522

Correspondence Tracking System (PC, PFS,
ODW/SPD/UICB)

The purpose of this system is to track responses to
controlled correspondence and other correspondence
requiring responses by the UIC Branch (e.g.,
Congressionals). The system tracks the date the material
was received, staff assigned to respond, and the date
material is signed or sent to the management for signature.

Contact: Pam Janifer - (202) 382-5530

Correspondence Tracking System (PC, dBASE,
OMEP/IO)

The purpose of the system is to track responses to
controlled correspondence received by OMEP, such as
Congressionals and other correspondence that has
deadlines. The system tracks the date the material was
received, staff assigned to answer the correspondence, and
the date the material is signed or sent to management for
signature.

Contact:  Yvonne Turner - (202) 382-7166
10
                                          U.S. EPA/OW

-------
                            Administrative Systems Compendium
                                               FY 1990
                            OW HQ Administrative  Systems
     Correspondence
              Systems
          (Continued):
Correspondence Tracking System (PC, dBASE,
OW/IO/RMAO)

The purpose of this system is to track controlled
correspondence and to keep a record of all material
distributed to RMAO staff requiring a response. The
system tracks the date the material is received in the Office
and the date an action was taken to address the material.

Contact: Karen Perry - (202) 382- 5698

Correspondence Tracking System (PC, dBASE,
OW/IO/WPO)

This system tracks controlled correspondence and  keeps a
record of all material sent to the AA  and the DAA for
signature. Correspondence for  signature by the AA and the
DAA is tracked from the date it is received until the date it
is signed.  Information tracked  includes: the person
making the inquiry, the date the inquiry was received, the
staff assigned to respond, the date a response was received,
and the date the response is signed and sent.

Contact: June Price - (202) 382-5690

Correspondence Tracking System (PC, dBASE,
OWEP/IO)

The purpose of this system is to track controlled
correspondence, particularly Congressionals. Information
maintained includes: the name of the person who sent the
correspondence, date received, staff assigned to respond,
date the response was complete, and the date the material
was sent to the Office Director or AA for signature.

Contact:  Sharon Vanmeter - (202) 475-8488
U.S.  EPA/OW
                                                    11

-------
                           Administrative Systems Compendium
                                               FY 1990
                           OWHQ Administrative Systems
     Correspondence
             Sys ferns
         (Continued):
Correspondence Tracking System  (PC, WordPerfect,
OWRS/IO)

The purpose of this system is to track all correspondence
(both controlled and non-controlled) received in the
Immediate Office and to keep a record of all mail sent to
the Director and Deputy Director of OWRS.  Information
contained in the the system includes: date received,
control numbers (both OWRS assigned and others), due
date, and current status.

Contact: Georgette Brown and Shirley Harrison - (202) 382-
7040

Correspondence Tracking System  (PC, WordPerfect,
OWRS/ITD)

The purpose of the system is to track responses to
controlled correspondence, such  as Congressionals, as well
as other correspondence  that has deadlines.  The following
information is tracked: the date the  material was received,
the person assigned to answer the correspondence, and  the
date the material is signed or sent to management for
signature.

Contact: Carol Swann - (202) 382-7120

Information Services Section (ISS) Tracking System
(Mainframe,  TSO, OWRS/AWPD)

The purpose of this system is to  track the several hundred
requests that  ISS receives annually pertaining to water
quality data systems.  The system tracks the question asked,
the information management system to which the
question pertains, the date of the request, who responded
to the question, the date  of the response, and which data
base was used to respond.

Contact: Madeline Greene - (202) 382-7046
12
                                          U.S. EPA/OW

-------
                           Administrative Systems Compendium
                                               FY 1990
                           OWHQ Administrative Systems
     Correspondence
              Systems
         (Continued):
            Personnel
         Management
             Systems:
Office Activities Tracking System (OATS) (PC, Lotus
Agenda, OGWP/IO)

The purpose of the system is to track controlled
correspondence and  material distributed to the staff for the
Office Director's signature. Information contained in this
system includes: the date the material is received, the
person originating the correspondence, the staff assigned to
respond, and the date the response is sent.

Contact:  Vicki Gillespie - (202) 382-7077

Bi-Weekly Personnel Status Report (PC, WordPerfect
(being converted to dBASE),  ODW/PDED)

The purpose of this system is to help track status of hiring
new ODW employees. The system contains the status of
personnel actions being processed at the Personnel Office.
Once an effective date is provided by the Personnel Office,
the action is dropped from the report.

Contact:  Deborah Gentry - (202) 382-2436

Compressed Work Week Tracking System (PC, Lotus
1-2-3, OWEP/PD)

This system contains information to help track the
compressed work week schedule.  Information maintained
includes: employee's name, schedule, and any schedule
changes over the course of the year.

Contact:  Frank Hall - (202) 475-9545

Personnel Roster (PC,  WordPerfect (being converted to
dBASE), ODW/PDED)

The purpose of this  system is to track the employment
status of employees  in ODW.  This system provides a
monthly roster of current ODW employees and vacancies.
The information  is tracked by Divisions, Branches,  and
Sections.

Contact:  Deborah Gentry - (202) 382-2436
U.S. EPA/OW
                                                    13

-------
                           Administrative Systems Compendium
                                               FY 1990
                           OWHQ Administrative Systems
            Personnel
        Management
             Systems
         (Continued):
Personnel Roster System (PC, dBASE, OMPC/PAD)

This system contains the personnel records for each OMPC
employee. Information on each employee includes: title,
position, and employee type (e.g., permanent versus
temporary).  The system also tracks affirmative action,
trends for hiring and attrition, and dates for within grade
pay increases.

Contact: Betty West - (202) 382-5807

Personnel Status Report (PC, dBASE, OMPC/PAD)

This system provides summary reports by  date and by
Division for the number of reassignments, promotions,
resignations, retirements, or transfers in OMPC.  The
System enables OMPC to track the time required to
complete particular personnel transactions.

Contact: Betty West - (202) 382-5807

Personnel Tracking System (PC, Lotus 1-2-3,
OGWP/GWMPS)

This system  tracks the personnel recruitment process. The
system contains information on the type and classification
of the position being announced, when the recruitment
package is sent to the Client Services Office of the Water
Team, the closing date for the vacancy announcement,  and
the starting date for the applicant.

Contact: Lynn Burger - (202) 382-7077

Personnel Tracking System (PC, Lotus 1-2-3,
OWRS/AED)

This system  tracks the job announcement  process. The
system contains information on the type and classification
of the position being announced, the date the position
announcement is sent to the Client Services  Division, the
closing date for the position, and ranking  material.

Contact:  Donald Brady - (202) 382-5392
14
                                          U.S.  EPA/OW

-------
                            Administrative Systems Compendium
                                                                                FY 1990
                            OW HQ Administrative Systems
Project Management
             Systems:
Action Tracking System (PC, dBASE, OMEP/TSD)

The system enables the Division Director to track action
items and assignments.  It contains information on when
each assignment/action was initiated, the originator,
completion dates, the staff lead, and other contacts
necessary for the completion of the action.

Contact:  Betty Moore - (202) 475-7102

Division Activities Tracking System (PC, WordPerfect,
OWRS/AWPD)

This system contains information on  the status of staff
assignments within the Division.  The system tracks
assignments made from outside  the Division, who made
the assignment, the topic of the assignment, to whom it
was assigned, and  any comments received.

Contact:  Barbara Williams - (202) 382-7040

Internal  ATS Tracking System  (PC, WordPerfect,
OWEP/PD)

The purpose of this system is to track ongoing activities in
OWEP. The system contains information on: key
milestones, lead staff,  and the dates the activity was
completed.

Contact:  Frank Hall -  (202) 475-8328

Office of Water Priority Workload Tracking System (PC,
dBASE/Clipper, OW/IO/WPO)

This system tracks important Office of Water regulations,
Reports to Congress, and other major documents. The
system allows analysts and managers in the Water Policy
Office (WPO) to oversee major Office of Water events. The
system contains information for each priority (e.g., ATS or
DA scoping list), regulation title, ATS number, next action,
a comment field containing significant past actions, legal or
judicial deadline, and Notice of Proposed Rule Making
(NPRM) or final dates published in the Federal Register.

Contact:  Jack Clifford - (202) 382-5684
U.S. EPA/OW
                                                     15

-------
                           Administrative Systems Compendium
                                               FY  1990
                           OW HQ Administrative Systems
Project Management
             Systems
         (Continued):
Regional Special Project Tracking System (PC, dBASE,
OWEP/IO)

The purpose of this system is to track special projects
submitted by Regions for funding and the amount of
money being requested. In FY 1990, the system will be
enhanced so that OWEP can link the funds granted to the
amount requested and track the rate of spending against
amount funded. OWEP intends to track the quality of the
project developed against the specifications in the work
plan.

Contact: Ed Kramer - (202) 475-8494

Work Assignment  Manager Data Base (PC, dBASE,
OWEP/IO)

The purpose of this data base  is to maintain information
on the designated work assignment managers for OWEP's
three support contracts. Mailing labels for mailings of
invoices, monthly reports, award fee evaluation forms and
other general correspondence are generated from this data
base.  In addition, this data base contains information on
WAM training and certification.

Contact:  Ronald Coleman -  (202) 475-8491

Workplan Milestone Tracking System  (PC, dBASE,
ODW/CSD)

The system tracks  the major milestones contained in
workplans for each Branch of  the Criteria and Standards
Division. Selected  workplans  are updated weekly and a
report is disseminated at the ODW staff meeting. Work is
underway to produce a tracking report covering all
workplans. This system will be able to sort data by Branch,
by due date, or by workplan number.

Contact:  Pat Minami - (202) 475-9598
16
                                          U.S. EPA/OW

-------
                            Administrative Systems Compendium
                                               FY 1990
                            OW HQ Administrative Systems
         Property and
Equipment Inventory
             Systems:
OW Immediate Office Hardware and Software Inventory
(PC, dBASE, OW/IO/RMAO)

This system contains an inventory of the PCs in the
Immediate Office. For each PC, it includes the type of
machine, the EPA identification number,  location and staff
assigned, and software packages used. The same
information is maintained for the Office's peripherals.

Contact: Gloria Posey - (202) 382-3983

PC Inventory  for the  Permit Division (PC, WordPerfect,
OWEP/PD)

The purpose of this system is to maintain a current
inventory of PC equipment in the Permits Division of
OWEP.  The system tracks equipment by: individual to
whom it is assigned, EPA identification number, type of
keyboard, type of drive, monitor type, and the type of
software in the system.

Contact:  Frank Hall - (202) 475-8328

PC Inventory System (PC, dBASE IV, OWEP/ED)

This system maintains an inventory of all the PC
equipment in the Division. The equipment is classified by
the individual to whom it is assigned, type of keyboard,
type of drive, monitor type, and the type of software in the
system.

Contact: Roshell Whitley - (202) 475-8310

PC Inventory System (PC, Lotus 1-2-3, OWP/IO)

This system contains an inventory of PCs and associated
hardware in OWP. For each PC, it includes the EPA
identification number, the  type of equipment, the location
and staff assigned, and software packages used.

Contact: Joan Warren - (202) 475-7796
U.S. EPA/OW
                                                    17

-------
                            Administrative Systems Compendium
                                               FY 1990
                            OWHQ Administrative Systems
         Property and
Equipment Inventory
              Systems
         (Continued):
PC Inventory System (PC, Lotus 1-2-3, OWRS/AED)

The purpose of this system is to maintain a current
inventory of PCs in the Division.  This system contains
information on:  the serial numbers for PC, the location of
the equipment, and to whom it is assigned.

Contact: Donald Brady - (202) 382-5392

PC Inventory System (PC, Lotus 1-2-3, OWRS/CSD)

This system tracks the number of PCs in the Division, the
serial numbers for each, the location of the equipment, and
to whom it is assigned.

Contact: Lowell Keup - (202) 475-7305

PC Inventory Tracking System (PC,  dBASE,
OWRS/AWPD)

The purpose of  this system is to maintain the inventory of
all PCs, peripherals, terminals and software in the
Division. The following items are tracked: location,
custodian, serial numbers, property number,
manufacturer, and maintenance history.

Contact: Cynthia Warner - (202) 382-7040

PC Tracking Inventory (PC, dBASE, OMPC/MCD)

This system contains an inventory of the type  and number
of PCs in the Division.  For each PC, the system contains:
EPA identification number, location, staff to whom it is
assigned, and software packages installed.

Contact: Jannie Latta - (202) 382-5837

PC Tracking System (PC, Lotus 1-2-3, OWRS/ITD)

The purpose of this system is to maintain an inventory of
all PC  equipment in the Division.  The following items are
tracked: location, custodian, serial numbers, and property
numbers of all hardware and software.

Contact: Eric Strassler - (202) 382-7120
18
                                                                          U.S. EPA/OW

-------
                            Administrative Systems Compendium
                                               FY 1990
                            OWHQ Administrative Systems
         Property and
Equipment Inventory
              Systems
          (Continued):
          Publications
         Management
              Systems:
Property Inventory (PC, Lotus 1-2-3, OGWP/GWMPS)

The purpose of this system is to maintain a current
inventory of furniture in OGWP.  This system contains
information on the number and type of furniture in
OGWP, the location of specific pieces of furniture, and
their serial numbers.

Contact:  Marty Gooding - (202) 382-7707

Automated Mailing List (PC, Avery List & Mail Plus,
OGWP/GWMPS)

The purpose of this system is to facilitate the distribution of
OGWP documents.  This system stores names and
addresses of 20 categories of persons to whom OGWP
documents are sent. The system enables the user to sort
and combine the lists in a variety of ways and prints them
out in a variety of formats,  including mailing labels.

Contact: Jan Gallagher - (202) 382-7077

Automated Mailing List for the  Nonpoint  Source
Program (PC, dBASE, OWRS/AWPD)

This system maintains a record of people receiving the
technical bulletin "News Notes" and enables staff to
generate labels for mailings. The system contains over
3,500 names and addresses.

Contact: Hal Wise - (202) 382-7040

Document Numbering System (PC, dBASE,
OGWP/GWMPS)

This system is used to assign numbers to each OGWP
publication.  It contains the name and EPA number for
each document developed by OGWP.  The system also
allows OGWP to track publication requests by category of
requester (e.g., EPA Headquarters or Regions, Other
Federal, State, local, company, individual, International,
Other). It also tracks submissions to NTIS.

Contact: Jan Gallagher - (202) 382-7707
 U.S. EPA/OW
                                                    19

-------
                            Administrative Systems Compendium
                                                FY 1990
                            OWHQ Administrative Systems
          Publications
         Management
              Systems
          (Continued):
Document Numbering System (PC, dBASE, OWRS/AED)

This system assigns numbers to OWRS publications.  It
contains the name and EPA number for each OWRS
document.

Contact:  Beverly Randolph - (202) 382-5373

Health Advisory  Request Tracking System (HARTS)
(PC, dBASE/Foxbase, ODW/CSD)

The purpose of this system is to track requests for Health
Advisory documents  and requests to the Criteria and
Standards Division for technical assistance. The system
contains information on: who requests  the information,
topic of the request, and the guidance information sent to
the requester.

Contact:  Jennifer Orme - (202) 382-7571

Infrastructure Financing Publications Distribution  List
(PC, dBASE, OMPC/MFD)

This list contains a constantly expanding list of names and
addresses of individuals who receive the Clean Water
Financing Update (formerly the SRF Update). This is a
compilation of many smaller mailing lists from State and
Federal governments, non-profit organizations, the
academic community, and the private sector (primarily  the
financial  and  legal communities, consultants and
engineers). For publications with narrower audiences (e.g.,
SRF program managers), the data base allows users to select
only the groups they specify.  A directory lists all categories
of addresses (i.e., sublists) currently in the database.

Contact:  Tom Burson - (202) 475-8679

Mailing List for Lab Certification Bulletin (PC, dBASE,
ODW/TSD)

The purpose of this system is to maintain a mailing list of
Certified  Officers and other interested persons who receive
The Lab Certification Bulletin. Names and addresses of the
Certified  Officers reside in the system.

Contact: Ed Click - (513) 569-7939 or (FTS) 684-7939
20
                                          U.S.  EPA/OW

-------
                           Administrative Systems Compendium
                                               FY 1990
                           OW HQ Administrative Systems
         Publications
         Management
              Systems
         (Continued):
Mailing List for the Pretreatment Quarterly Newsletter
(PC, dBASE, OWEP/PD)

The purpose of this list is to maintain a record of people
receiving the quarterly pretreatment newsletter and to
enable staff to easily generate mailing labels. This
automated list contains the names of 1800 people who
receive the newsletter.

Contact: John Hopkins -  (202) 475-9527

Onsight/Oversight Mailing List (PC, WordPerfect,
OMPC/PAD)

This system contains names, addresses, and phone
numbers of OMPC's operator training network.  It includes
Regional, State, and local staff as well as National
Organization contacts. The system allows OMPC to
selectively produce mailing labels for all or  subsets of the
names in the data base for mailing the OMPC newsletter,
guidances, and other correspondence.

Contact: John Flowers - (202) 382-5822

Publications Distribution Tracking System (PC, dBASE,
OGWP/GWMPS)

This system keeps track of the number of requests received
for each of the OGWP documents, the requester's name,
the date of the request, the number of requests made, and
when the request was  filled.  The system is  used to help
plan how many documents  should be reprinted as well as
areas of interest to the public.

Contact: Jan Gallagher -  (202) 382-7077
U.S. EPA/OW
                                                   21

-------
                           Administrative Systems Compendium
                                              FY 1990
                           OWHQ Administrative Systems
           Regulation
         Development
             Systems:
   Resource Tracking
    and Management
             Systems:

               Budget:
Control and Receipt System for Public Comments
(CARPC) (PC, dBASE, OWRS/AED)

This system tracks responses received by OWRS on
regulations for which public comment has been requested.
For each regulation being tracked, the system contains a
summary of comments and information on who
submitted the comments.  Information in the system can
be accessed sequentially, by known author of comment, by
known comment topic, and by any key word or string of
key words designated by the Program Office. Additionally,
reports can be generated summarizing all comments from
a particular person and all persons who responded with
the same comment.

Contact: Chuck White - (202) 382-5411

Regulation Status Tracking System (PC, Lotus 1-2-3,
OWEP/PD)

The purpose of this system is to track the progress of
regulation development in OWEP. This system contains
information on  the development agendas for current
regulation development Workgroups and the status of the
regulation being developed from  the initiation of the
Workgroup through signature.

Contact: Frank Hall - (202) 475-9545

BUD 2 System (PC, dBASE, Used by all Program Offices)

The purpose of  this system is enable OW Program Offices
to easily and electronically generate BUD 2 forms for use in
the Agency budget development process. The system also
allows analytical assessments to be completed. This system
has been distributed to all  of the OW Program Offices.

Contacts: (OW/IO) Juanita Smith  - (202) 383-6226;
(ODW/PDED) Jane Ephremides - (202) 382-5513;
(OGWP/GWMPS) Clare Donaher  - (202) 382-5698; (PMSS)
Ray Baum - (202) 475-8580; (OWP/IO) Joan Warren - (202)
475-7796; (OWRS/AED) Donald Brady - (202) 382-5392;
OWEP/IO) Ed Kramer - (202) 382-5698; (OMPC/PAD)
Valeria Martin - (202) 382-5835
22
                                         U.S. EPA/OW

-------
                           Administrative Systems Compendium
                                              FY 1990
                           OW HQ Administrative Systems
  Resource Tracking
    and Management
             Systems:

               Budget
         (Continued):
Extramural Funds Tracking System (PC, dBASE/Lotus
1-2-3/WordPerfect, OMEP/PMSS)

The purpose of the system is to track extramural
expenditures of each Division against its budgeted line
item.  The dBASE system shows a detailed expenditure,
while the Lotus program and WordPerfect printout show a
summary expenditure of the whole office.

Contact: Ray Baum - (202) 475-8580

Headquarters AC&C Expenditures Tracking System (PC,
Lotus 1-2-3, OWP/IO)

The purpose of this system is is track the expenditure of
AC&C funds in OWP.  The system contains a listing of all
planned AC&C expenditures by OWP Divisions and the
Immediate Office. It has a column for actual commitments
and DCN number, purpose, title, and staff person. The
system provides  totals for each Division, the Immediate
Office, and the office as a whole.

Contact: Joan Warren - (202) 475-7796

Internal Operating Budget Tracking  System (PC, Lotus
1-2-3, OGWP/GWMPS)

The purpose of this system is to enable staff to track and
reconcile actual expenditures against those projected in the
operating  plan.   This information system contains the
annual approved operating plan and  obligations/payments
made against this plan on a monthly basis.

Contact: Marty Gooding - (202) 382-7077

Internal Operating Budget Tracking System (PC, Lotus
1-2-3, OWRS/AED)

This system contains back-up information for the OWRS
operating  budget and expenditures.

Contact: Donald Brady - (202) 382-5392
as. EPA/OW
                                                   23

-------
                           Administrative Systems Compendium
                                              FY 1990
                           OWHQ Administrative  Systems
   Resource  Tracking
    and Management
             Systems:

               Budget
         (Continued):
Intramural Funds Tracking System (PC, Lotus 1-2-3,
OWRS/AWPD)

The purpose of this system is to track expenditures
chronologically for all items covered under intramural
funds. They can then be sorted by specific categories, by
object class codes, and by document control numbers.

Contact: Pat Wilkins - (202) 382-7040

Intramural Funds Tracking System (PC, dBASE,
OWRS/ITD)

The purpose of this system is to track expenditures
chronologically for all items covered under intramural
funds. Expenditures can be sorted by specific categories, by
branch, and by section.

Contact: Carol Swann - (202) 382-7120

PC&B System (Personnel Compensation & Benefits)
(PC, dBASE/Clipper, Used by all OW Program Offices)

The purpose of this system is to project and to track
expenditures of dollars and utilization of FTEs. Each
Program Office in OW has been provided with a PC&B
system and maintains information within the system on
their personnel and benefits expenditures. Each Program
Office provides RMAO with a monthly report on their
expenditures. They are able to use the system to run
projection models.

Contacts:  (OW/IO) Juanita Smith - (202) 382-6226;
(ODW/PDED) Susan Hancks - (202) 382-5513;
(OGWP/GWMPS) Lynn Burger - (202) 382-7707;
(OMEP/PMSS) Lois Canada - (202) 382-8580; (OWP/IO) Joan
Warren -(202) 475-7796; (OWRS/AED) Donald Brady - (202)
382-5392; (OWEP/IO) Ed Kramer - (202) 475-8494; and
(OMPC/PAD) Bernie Mason - (202) 382-5801
24
                                         U.S.  EPA/OW

-------
                            Administrative Systems Compendium
                                               FY  1990
                            OW HQ Administrative Systems
   Resource Tracking
    and Management
             Systems:

               Budget
         (Continued):
Printing Request Tracking System (PC, Lotus 1-2-3,
OGWP/GWMPS)

This system is used to track printing requests in OGWP.  It
contains information on the number of printing requests
and associated costs, and maintains a record by date of the
total amount of funds remaining in this account.

Contact: Jan Gallagher -(202) 382-7077

Regional AC&C Expenditures Tracking System (PC,
Lotus 1-2-3, OWP/IO)

The purpose of this system is to track the expenditure of
AC&C funds by the Regional Offices of OWP. The system
provides totals for Regional AC&C expenditures held in
OWP's allowance.  The system does not list projects
individually.

Contact: Mary Hinton - (202) 475-7796

Status of Funds System (PC, Lotus 1-2-3, ODW/PDED)

This spreadsheet provides a monthly financial status on
ODW spending. The report is broken down at the Branch
and Division levels, and also  includes a summary page.
The report provides ODW with their current allowance,
cumulative expenditures, percentage of allowances, and
balances.

Contact: Linda Burnside - (202) 382-7384
U.S. EPA/OW
                                                   25

-------
                          Administrative Systems Compendium
                                              FY 1990
                           OW HQ Administrative  Systems
  Resource Tracking
    and Management
            Systems:

           Contracts?
Contract Expenditure Tracking System (PC, Lotus 1-2-3,
OMPC/PAD)

The purpose of this system is to track the expenditure of
dollars and hours for OMPC's LOE. The system contains
information on the authorized amount  of funds for the
contract per option period, and lists this information for
each individual work assignment in the contract. The
amount of funds expended and the number of hours used
are tracked monthly against  the total dollars and hours for
each work assignment.

Contact: Karen James - (202) 382-5804

Contract Expenditure Tracking System (PC, Lotus 1-2-3,
OWRS/AED)

Project Officers use this system to track work assignments
by the number of dollars and hours that are assigned and
spent, and by account.

Contact: Debra Nicoll -  (202) 382-5397

Contract Expenditure Tracking  Systems (PC, Lotus 1-2-3,
ODW/CSD)

The  purpose of these systems is to track the expenditure of
contract dollars in the service contract,  and the expenditure
of extramural funds as  a whole.  The Service Contract
Report contains information on dollars expended by DCN
and  by work assignment number.  The Extramural Funds
Expenditure Report shows line items broken down by
Division workplan number. Information available for
each line item  includes  total dollars budgeted. Each
amount budgeted is further  broken down by Branch with
the dollars spent and amount remaining totaled.

Contact: Pat Minami - (202)  475-9598
26
                                          U.S. EPA/OW

-------
                           Administrative Systems Compendium
                                              FY 1990
                            OW HQ Administrative Systems
  Resource Tracking
    and Management
             Systems:

            Contracts
         (Continued):
Contract Monitoring System (PC, Lotus 1-2-3, OWRS/
AWPD)

This system tracks financial activities within work
assignments and expenditures under the LOEs with the
following contractors: Tetratech, Dynamac, and Woodward
Clyde.  The system contains information on: DCN
numbers, Account numbers, amount of money originally
available in each work assignment, and a monthly balance
for each work assignment and the LOE as a whole.

Contact: Paulette Ballard - (202) 382-7085

Contract Tracking  System (PC, Lotus 1-2-3,
OGWP/GWMPS)

This system contains information on the financial aspects
of each LOE contract that OGWP manages. For each work
assignment, there is information on the total dollar
amount approved, the amount expended monthly, and the
remaining balance for the project.

Contact:  Miriam Bomblad - (202) 382-7077

Contract Tracking  System (PC, Lotus 1-2-3, OWEP/ED)

The purpose of this system is to track the funds expended
under OWEP's LOE in the Enforcement Division.  This
system contains the following information:  the name of
the contractor, amount of funds in the contract, amount of
funds allocated for each work assignment, name of each
task assignment manager, and expenditures of funds
against the total amount of funds in the contract.

Contact:  Elson Lim - (202) 475-8321

Contract Tracking  System (PC, Lotus 1-2-3, OWEP/IO)

The purpose of this system is to track the status of Work
Assignments under the LOE contract.  Information tracked
includes: dollars expended monthly on the contract against
the contract total, completion date  against milestones
specified in the Statement of Work, and the products
delivered against those specified in the Statement of Work.

Contact:  Ron  Coleman -  (202) 475-8491
U.S. EPA/OW
                                                   27

-------
                           Administrative Systems Compendium
                                              FY 1990
                           OWHQ Administrative Systems
  Resource Tracking
    and Management
             Systems:

            Contracts
         (Continued):
 Resource Allocation
               Models:
Contract Tracking System (PC, Lotus 1-2-3, OWEP/PD)

This system tracks both intramural and extramural funds
and the amount of the funds committed versus
uncommitted. This system contains information on: the
contractor, the amount in the contract, expenditures
against the total amount in the contract, and the name of
the contract manager.

Contact: Tim Dwyer - (202) 475-7056

Corps of Engineers  (COE) Tracking System (PC, Lotus 1-
2-3, OMPC/PAD)

The purpose of this system is to track the funds provided to
the Army Corp of Engineers to perform water quality
monitoring under an interagency agreement. This system
tracks the funds allotted to the COE, distributed to twelve
COE District Offices,  and tracks against funds distributed.

Contact: Karen James - (202) 382-5804

Pretreatment  Contract Tracking System (PC, Lotus 1-2-3,
OWEP/PD)

The purpose of this system is to track contractor
expenditures on the  pretreatment assignment. The  system
contains information on how many dollars and hours
were expended against the total allotted for each task.

Contact: John Hopkins - (202) 475-9525

Construction Grants Outlay Model (PC, BASIC,
OMPC/MCD)

The purpose of this system is to calculate multiple outlays
based on obligations and outlay curves for  the
Construction Grants.

Contact: Len Fitch -  (202) 382-5858
28
                                         U.S. EPA/OW

-------
                            Administrative Systems Compendium
                                               FY 1990
                            OW HQ Administrative Systems
   Resource Tracking
     and Management
             Systems:

 Resource Allocation
 Models (Continued):
ESP Regression Model 1 (Outlay Model) (Mainframe,
ESP, OMPC/MCD)

The purpose of this regression-based model is to calculate
how money will be paid out over a given fiscal year.
Calculations are based on historical, quarterly obligations
and outlays.

Contact: Melanie LaForce - (202) 382-5828

Public Water Systems Supervision Enforcement
Workload Model  (PC, Lotus 1-2-3,  ODW/SPD)

The purpose of the model is to distribute available FTEs
among the Regions. The model computes the number of
FTEs each Regions needs to operate its enforcement
program for the year. The ratio of total needs to available
resources is established for  each Region in assigning
available FTE resources. The model also estimates the
number of each type of enforcement action that could be
achieved with the available FTEs.

Contact: Craig Damron - (202) 382-5556

Public Water Systems Supervision Program Grant
Allocation Formula (PC, Lotus 1-2-3, ODW/SPD)

The purpose of the formula is to allocate PWSS grant
dollars to the States, Territories, and Indian Lands. The
formula computes the amount of grant dollars each is
eligible for based upon several factors including:
population, land area, and  numbers of community and
noncommunity systems.

Contact: Craig Damron - (202) 382-5556
U.S. EPA/OW
                                                                                   29

-------
                           Administrative Systems Compendium
                                               FY 1990
                           OWHQ Administrative  Systems
  Resource Tracking
    and Management
             Systems:

Resource Allocation
Models (Continued):
Public Water Systems Supervision Workload Model (PC,
Lotus 1-2-3, ODW/SPD)

The purpose of the model is to distribute available FTEs
among the Regions. Regional activities are listed,
prioritized, grouped and weighed to establish total needs
for the PWSS Regional Programs. The ratio of total needs
to available resources is established for each Region in
assigning available FTE resources.

Contact: Craig Damron - (202) 382-5556

Regression Model 2 (Outlay Model) (PC, Time Series
Process (TSP), OMPC/MCD)

The purpose of this regression-based model is to calculate
how money will be paid out over a given fiscal year.
Calculations are based on historical, quarterly obligations
and outlays.  This model will replace the mainframe-based
model ESP Regression Model 1.

Contact: Melanie LaForce - (202) 382-5828

State Revolving Fund (SRF) Outlay Model (PC, BASIC,
OMPC/MCD)

The purpose of this system is to calculate multiple outlays
based on obligations and outlay  curves for the SRF.

Contact: Len Fitch - (202) 382-5858

UIC Workload Model  (PC, Lotus 1-2-3, ODW/SPD/UICB)

The purpose of this system is to provide program
managers with a tool for making resource allocation
decisions based on program priorities, resource needs, and
actual performance. The model  consists of two parts: 1)
grant allocation for States; and 2) Regional FTE
distributions.

Contact:  Jentai Yang - (202) 382-5542
30
                                          U.S. EPA/OW

-------
                            Administrative Systems Compendium
                                               FY 1990
                            OW HQ Administrative Systems
   Resource Tracking
     and Management
              Systems:

 Resource Allocation
 Models (Continued):
Workload Model (PC, Lotus 1-2-3, OMEP/PMSS)

This system is used by Headquarters to help determine the
FTE distributions for the Regions and Headquarters.

Contact: Lois Canada - (202)475-8580

Workload Model (PC, Lotus 1-2-3, OMPC/MCD)

The purpose of this model is to calculate FTEs for the
coming year for the Regions.  FTEs are calculated using a
variety of factors such as: the number of projects in a
Region, the number of projects in each project phase, and
the size of the projects.

Contact: Len Fitch - (202) 382-5858

Workload Models (PC, Lotus 1-2-3, OMEP/PMSS)

These automated models are used  to determine the
distribution of Regional  Resources.

Contact: Lois Canada - (202) 475-8580

Workload Model for Section 106 Grants (PC, Lotus 1-2-3,
OWRS/AED)

The purpose of this formula is to allot Section 106 grant
resources to the States, Territories, Interstate Agencies, and
Indian Tribes based on the extent of their respective
pollution problems.  The allotment serves as a planning
target as States develop annual work programs.  The actual
grant amount is negotiated by the Regions and States.

Contact: Donald Brady - (202) 382-5392
as. EPA/OW
                                                                                  31

-------
                           Administrative Systems Compendium
                                               FY 1990
                            OWHQ Administrative Systems
  Resource  Tracking
    and Management
             Systems:

 Resource Allocation
 Models  (Continued):
             Training:
Workload Model for Water Quality Management, Water
Monitoring, and Standards and Regulations FTEs (PC,
Lotus 1-2-3, OWRS/AED)

The purpose of this model is to distribute available FTEs
among the Regions.  Regional activities are listed,
prioritized, grouped and weighted to establish the total
needs for these programs.  The model is used to set
priorities among activities and then to allocate available
resources to  the Regions.

Contact: Donald Brady - (202) 382-5392

Training Activity Tracking System (PC, dBASE IV,
OWEP/ED)

This system  tracks training in the Division. Information
in the system includes the names  of persons who attended
training in the current fiscal year,  the type of training, the
dates of training, and the  amount expended on training.

Contact:  Roshell Whitting - (202)  475-8310

Training Tracking System (Non-automated,
ODW/CSD/HEB/STB)

The system contains information  on training  activities
within the Division, by Branch. Information tracked
includes the name of person attending training, purpose of
the training, dates of the training, and the cost of the
training.

Contacts:  (HEB) Sheila Holcomb - (202) 382-7571; (STB)
Marcella Depont - (202) 382-3022; (IO) Denise Jackson - (202)
382-7575
32
                                          U.S. EPA/OW

-------
                           Administrative Systems Compendium
                                              FY 1990
                           OW HQ Administrative Systems
  Resource Tracking
    and Management
             Systems:

                Travel:
Travel and S&E Tracking System (PC, Lotus 1-2-3,
OWEP/PD)

This system consists of two files: one for tracking travel
expenses and one for tracking training expenditures.  The
travel component maintains the following information:
the name of the traveler, destination, dates traveling, the
DCN number, the amount approved on the TA, the
amount  actually expended, and a running total of the
travel funds expended during the fiscal year versus the
amount  available.  The training component contains
information on: the name of the trainee, the name of the
course, the dates of the course, the DCN number, the cost
of the course and the amount approved on the TA, and a
running total of the training funds expended during the
fiscal year versus the  amount available.

Contact: Kim Ogden - (202) 475-8328

Travel Management System (PC, dBASE,  OWRS/ITD)

This system contains  information on the name of traveler,
destination, dates of departure and return,  the DCN
number, the dollar amount approved on the TA, and the
actual expenditure. The amount expended is tracked
against the travel ceiling for the Division.

Contact: Carol Swann - (202) 382-7120

Travel Tracking System (PC, Lotus 1-2-3,  ODW/CSD)

This system contains  information on travel in the
Division, by Branch.  Information tracked includes: the
name  and  destination of the traveler, the amount of
money approved on the TA, the amount of money
claimed  on the voucher, and a running total  against the
travel ceiling.

Contact: Pat Minami - (202) 475-9598
U.S. EPA/OW
                                                   33

-------
                           Administrative Systems Compendium
                                               FY 1990
                           OW HQ Administrative Systems
  Resource Tracking
    and Management
             Systems:

  Travel (Continued):
Travel Tracking System (PC, Lotus 1-2-3, ODW/SPD)

The system tracks expenditures for both Branches within
SPD.  Information in the system includes: name and
destination of the traveler, the amount of money approved
on the TA, amount of funds actually expended on the
voucher, and expenditures against the Division's travel
ceiling. The UIC Branch maintains a separate accounting
of their expenditures.

Contacts:  (IO) Murlene Lash - (202) 382-5522 and (UIC) Pam
Janifer - (202) 382-5530

Travel Tracking System (PC, Lotus 1-2-3,
OGWP/GWMPS)

The purpose of this system is to track OGWP travel
expenditures. The system contains information on: the
name and destination of traveler, the DCN number, the
dollar  amount authorized for the trip, and the actual
expenditure. The amount expended is  tracked against the
travel  ceiling.

Contact:  Marty Gooding - (202) 382-7077

Travel Tracking System (PC, dBASE,  OMPC/A11
Divisions)

The purpose of this system is to track OMPC travel on a
monthly basis.  Information in the system includes: the
traveler's name  and destination, the dates traveled,  the
DCN number, the dollar amount approved on the TA, the
amount actually expended, and the running balance
against the travel ceiling.  This system is distributed to each
branch in the Division. The Branch Chiefs provide  the
Division Directors with a monthly travel status report.

Contacts:  (MFD) Valerie Barnes - (202)  382-7260; (MCD)
Jannie Latta - (202) 382-5837; and (PAD) Carolina Hicks -
(202) 382-5856
34
                                          U.S. EPA/OW

-------
                            Administrative Systems Compendium
                                               FY 1990
                            OWHQ Administrative Systems
   Resource Tracking
    and Management
             Systems:

  Travel (Continued):
Travel Tracking System (PC, Lotus 1-2-3, OW/IO/RMAO)

This system tracks travel activity within RMAO. It
contains information on: the traveler's name, destination,
dates of travel, amount of funds approved on the TA, and
actual expenditures by the traveler.

Contact: Gloria Posey - (202) 382-5698

Travel Tracking System (PC, Lotus 1-2-3/dBASE IV,
OWEP/ED)

The purpose of this system is to track the expenditure of
travel funds  in the Enforcement Division of OWEP.  This
system contains: the name and destination of the person
traveling, the DCN number, and an estimate and actual
dollar amount expended on  the trip.  The system also
tracks expenditures to date against the Division's travel
ceiling in a given year.

Contact: Beryl Roman - (202) 475-8310

Travel Tracking System (PC, Lotus 1-2-3, OWP/IO)

The system contains information on Office-wide travel.
Information tracked includes: the traveler's  name and
destination, the amount of money approved on the TA,
the amount actually expended on the voucher, and a
running total against the travel ceiling.

Contact: Joan Warren - (202) 475-7796

Travel Tracking System (PC, Lotus 1-2-3, OWRS/AWPD)

This system tracks the name and destination of the
traveler, DCN number, the dollar amount approved  for
the TA, and the actual amount expended.  The system also
tracks expenditures to  date against the travel ceiling in a
given fiscal year.

Contact: Pat Wilkins - (202) 382-7040
U.S. EPA/OW
                                                   35

-------
                         Administrative Systems Compendium
FY 1990
                         Acronyms
                         A A           Assistant Administrator
                         AAA          Associate Assistant Administrator
                         AC&C        Abatement Control and Compliance
                         A DP          Automated Data Processing
                         A ED          Analysis and Evaluation  Division (OWRS/OW)
                         ATS          Action Tracking System

                         AWPD        Assessment and Watershed Protection Division
                                       (OWRS/OW)
                         BASIC       Beginner's All-Purpose Symbolic Instructed
                                       Code
                         BUD-2       Budget Form 2
                         COE          U.S. Army Corps of Engineers
                         CSD          Criteria and  Standards Division (both in ODW
                                       and OWRS/OW)

                         DA           Deputy Administrator
                         DAA          Deputy Assistant Administrator
                         DON          Document Control Number
                         ED           Enforcement Division (OWEP/OW)
                         EPA          U.S. Environmental Protection Agency
                         FTE          Full Time  Equivalent (workyear)
                         FY           Fiscal Year

                         GWMPS      Ground Water Management and Policy Staff
                                       (OGWP/OW)
                         HARTS       Health Advisory Request Tracking System
                         HEB          Health Effects Branch(CSD/ODW/OW)
                         IO           Immediate Office (OW)
                         IRM          Information  Resources Management
                         ISS          Information  Service Selection
                         ITD          Industrial  Technology Division (OWRS/OW)

                         LOE          Level of Effort
                         MOD         Municipal Construction Division OMPC/OW)
                         MFD          Municipal Facilities Division (OMPC/OW)
                         NCC          National Computer Center
                         NPRM        Notice of Preliminary Rule Making
                         NTIS         National Technical Information Service
U.S. EPA/OW
     37

-------
                         Administrative Systems Compendium
                                     FY 1990
                         Acronyms
                         OATS
                         ODW
                         OGWP
                         OIRM
                         OMEP

                         OMPC
                         O1Y
                         OWEP
                         OWP
                         owns
                         PAD

                         PC
                         PC&B
                         PD
                         PDED

                         PMSS

                         PWSS
                          RMAO

                          S&E
                          SPD
                          SRF
                          STB
                          TA
                          TSD

                          TSO
                          TSP
                          TVA

                          UIC
                          UICB

                          WIC
                          WPO
Office Activities Training System
Office of Drinking Water
Office of Ground-Water Protection
Office of Information Resources Management
Office of Marine and Estuarine Protection

Office of Municipal Pollution Control
Office of Water
Office of Water Enforcement and Permits
Office of Wetlands Protection
Office of Water Resources and Standards
Planning and Analysis Division (OMPC/OW)

Personal Computer
Personnel Compensation and Benefits
Permit Division (OWEP/OW)
Program Development and Evaluation Division
(ODW/OW)
Policy and Management Support Staff
(OMEP/OW)
Public Water Systems Supervision
(SPD/ODW/OW)

Resources  Management and Administration
Office (IO/OW)
Salaries and Expenses
State Programs Division (ODW/OW)
State Revolving Fund
Science and Technology Branch
(CDS/ODW/OW)

Travel Authorization
Technical Support Division (both in ODW and
OMEP/OW)
Time Sharing Option
Time Series Process
Tennessee Valley Authority

Underground Injection Control
Underground Injection Control Branch
(SPD/ODW/OW)
Washington Information Center
Water Policy Office (IO/OW)
38
                               U.S. EPA/OW

-------
                          Administrative Systems Compendium                       FY 1990  '
                          Index
                                                                            Page
                          System                                         Number


                          Action Tracking System (OMEP/TSD)	  15

                          Automated Mailing List (OGWP/GWMPS)	  19

                          Automated Mailing List for the Nonpoint Source Program
                          (OWRS/AWPD)	  19

                          Bi-Weekly Personnel Status Report (ODW/PDED)	  13

                          BUD 2 System (OW/IO/RMAO, ODW/PDED,
                          OGWP/GWMPS, OMEP/PMSS, OWP/IO, OWRS/AED,
                          OWEP/IO, OMPC/PAD)	  22

                          Compressed Work Week Tracking System (OWEP/PD)	  13

                          Construction Grants Outlay Model (OMPC/MCD)	  28

                          Contract Expenditure Tracking System (OMPC/PAD)	  26

                          Contract Expenditure Tracking System (OWRS/AED)	  26

                          Contract Expenditure Tracking Systems (ODW/CSD)	  26

                          Contract Monitoring System (OWRS/AWPD)	  27

                          Contract Tracking System (OGWP/GWMPS)	  27

                          Contract Tracking System (OWEP/ED)	  27

                          Contract Tracking System (OWEP/IO)	  27

                          Contract Tracking System (OWEP/PD)	  28

                          Control and Receipt System for Public Comments
                          (CARPC) (OWRS/AED)	  22

                          Control Correspondence Log (OWEP/PD)	   9

                          Corps of Engineers (COE) Tracking System (OMPC/PAD)	  28

                          Correspondence Control Tracking System (OMPC/IO)	   9

                          Correspondence Tracking System (ODW/CSD)	   9


U.S. EPA/OW                                                                   39

-------
                          Administrative Systems Compendium                       FY 1990


                          Index

                                                                              Page
                          System                                           Number


                          Correspondence Tracking System (ODW/IO)	  10

                          Correspondence Tracking System (ODW/SPD)	  10

                          Correspondence Tracking System (ODW/SPD/UICB)	  10

                          Correspondence Tracking System (OMEP/IO)	  10

                          Correspondence Tracking System (OW/IO/RMAO)	  11

                          Correspondence Tracking System (OW/IO/WPO)	  11

                          Correspondence Tracking System (OWEP/IO)	  11

                          Correspondence Tracking System (OWRS/IO)	  12

                          Correspondence Tracking System (OWRS/ITD)	  12

                          Division Activities Tracking System (OWRS/AWPD)	  15

                          Document Numbering System (OGWP/GWMPS)	  19

                          Document Numbering System (OWRS/AED)	  20

                          ESP Regression Model 1 (Outlay Model) (OMPC/MCD)	  29

                          Extramural Funds Tracking System (OMEP/PMSS)	  23

                          Headquarters AC&C Expenditures Tracking System
                          (OWP/IO)	  23

                          Health Advisory Request Tracking System (HARTS)
                          (ODW/CSD)	  20

                          Information Services Section (ISS) Tracking System
                          (OWRS/AWPD)	  12

                          Infrastructure Financing Publications Distribution List
                          (OMPC/MFD)	 20

                          Internal ATS Tracking System (OWEP/PD)	 15

                          Internal Operating Budget  Tracking System
                           (OGWP/GWMPS)	 23


40                                                                     U.S. EPA/OW

-------
                           Administrative Systems Compendium                       FY 1990
                           Index

                                                                              Page
                           System                                           Number
                           Internal Operating Budget Tracking System (OWRS/AED)....  23

                           Intramural Funds Tracking System (OWRS/AWPD)	  24

                           Intramural Funds Tracking System (OWRS/ITD)	  24

                           Mailing List for Lab Certification Bulletin (ODW/TSD)	  20

                           Mailing List for the  Pretreatment Quarterly Newsletter
                           (OWEP/PD)	  21

                           Office Activities Tracking System (OATS) (OGWP/IO)	  13

                           Office of Water Priority Workload Tracking System
                           (OW/IO/WPO)	  15

                           Onsight/Oversight Mailing List (OMPC/PAD)	  21

                           OW Immediate Office Hardware and Software Inventory
                           (OW/IO/RMAO)	  17

                           PC Inventory for the Permit Division (OWEP/PD)	  17

                           PC Inventory System (OWEP/ED)	  17

                           PC Inventory System (OWP/IO)	  17

                           PC Inventory System (OWRS/AED)	  18

                           PC Inventory System (OWRS/CSD)	  18

                           PC Inventory Tracking System (OWRS/AWPD)	  18

                           PC Tracking Inventory (OMPC/MCD)	  18

                           PC Tracking System (OWRS/ITD)	  18

                           Personnel Compensation & Benefits (PC&B)  System
                           (OW/IO/RMAO, ODW/PDED, OGWP/GWMPS,
                           OMEP/PMSS, OWP/IO,  OWRS/AED, OWEP/IO,
                           OMPC/PAD)	  24

                           Personnel Roster (ODW/PDED)	  13
U.S. EPA/OW                                                                     41

-------
                          Administrative Systems Compendium                        FY 1990


                          Index

                                                                               Page
                          System                                           Number


                          Personnel Roster System (OMPC/IO)	 14

                          Personnel Status Report (OMPC/PAD)	 14

                          Personnel Tracking System (OGWP/GWMPS)	 14

                          Personnel Tracking System (OWRS/AED)	 14

                          Pretreatment Contract Tracking System (OWEP/PD)	 28

                          Printing Request Tracking System (OGWP/GWMPS)	 25

                          Property Inventory (OGWP/GWMPS)	 19

                          Publications Distribution Tracking System
                          (OGWP/GWMPS)	 21

                          Public Water Systems Supervision Enforcement
                          Workload Model (ODW/SPD/PWSS)	 29

                          Public Water Systems Supervision Program Grant
                          Allocation Formula (ODW/SPD/PWSS)	 29

                          Public Water Systems Supervision Workload Model
                          (ODW/SPD/PWSS)	 30

                          Regional AC&C Expenditures Tracking System (OWP/IO)	 25

                          Regional Special Project Tracking System  (OWEP/IO)	 16

                          Regression Model 2 (Outlay Model) (OMPC/MCD)	 30

                          Regulation Status Tracking System (OWEP/PD)	 22

                          State Revolving Fund (SRF) Outlay Model (OMPC/MCD)	 30

                          Status of Funds System (ODW/PDED)	 25

                          Training Activity Tracking System (OWEP/ED)	 32

                          Training Tracking System (ODW/CSD/HEB/STB)	 32

                          Travel and S&E Tracking System (OWEP/PD)	 33



42                                                                     U.S. EPA/OW

-------
                      Administrative Systems Compendium                       FY 1990
                      Index
                                                                          Page
                      System                                          Number
                      Travel Management System (OWRS/ITD)	  33

                      Travel Tracking System (ODW/CSD)	  33

                      Travel Tracking System (ODW/SPD)	  34

                      Travel Tracking System (OGWP/GWMPS)	  34

                      Travel Tracking System (OMPC/MFD, OMPC/MCD,
                      OMPC/PAD)	  34

                      Travel Tracking System (OW/IO/RMAO)	  35

                      Travel Tracking System (OWEP/ED)	  35

                      Travel Tracking System (OWP/IO)	  35

                      Travel Tracking System (OWRS/AWPD)	  35

                      UIC Workload Model (ODW/SPD/UICB)	  30

                      Work Assignment Manager Data Base (OWEP/IO)	  16

                      Workload Model (OMEP/PMSS)	  31

                      Workload Model (OMPC/MCD	  31

                      Workload Models (OMEP/PMSS)	  31

                      Workload Model for Section 106 Grants (OWRS/AED)	  31

                      Workload Model for Water Quality Management, Water
                      Monitoring, and Standards and Regulations FTEs
                      (OWRS/AED)	  32

                      Workplan Milestone Tracking System (ODW/CSD)	  16
EPA/OW                                                                     43

-------