United States
            Environmental Protection
            Agency
             Office Of Water
             (WH-547)
EPA 430/09-91-017
Revised July 1991
c/EPA
State Revolving Fund
Grants Information And
Control System (SRF GICS)

Instruction Manual
                                     Printed on Recycled Paper

-------
SRF GICS INSTRUCTION MANUAL
For Information On :
Who Should Use This Manual Section 1. :
Introduction
How to Use This Manual Section 1 :
Introduction
Overview of the SRF GICS Section 1 :
Relationship Introduction
Source Documents Section 2.1 :
- Application for Federal Assistance Information Sources
- EPA Assistance Agreement/Amendment
- Project Priority List
- Intended Use Plan
- Annual Report
Relating SRF Source Documents Section 2.1 :
to GICS Information Sources
An Overview of SRF-specific Section 2.2 :
Data Entry Screens in GICS Data Entry
When to Access GICS Data Entry Section22 :
Data Entry
Which Data Entry Screens to Access Sectiori22 :
Data Entry
What are the Informational Needs Section 3J .
of the EPA Information Needs
Names of the SRF National Reports Section 3.2
Report Summary
Select Logic Criteria for National Section 3.2
Reports Select Logic Criteria

-------
SRF GIGS INSTRUCTION MANUAL
For Information On : _____
________________ Go To:
Section 3.2
SRF National Reports Format SRF GIGS Reports
Section 4.1
SRF State Optional System Introduction to Optional
Pilot System
Section 4.2
SRF State Optional System Screens Data Entry Screens
Section 4.3
SRF Optional Reports SRF State Optional
Reports

-------
SRF GIGS INSTRUCTION MANUAL
Table of Contents
PAGE
PREFACE
SECTION 1 : INTRODUCTION 1
1 .1 Purpose and Uses of
Instruction Manual 2
1.2 Other Available References 5
1.3 OverviewofSRFandGlCS 6
SECTION 2 : SRF GIGS REQUIRED DATA ELEMENTS 12
2.1 Information Sources 1 4
2.2 Data Entry 26
SECTION 3 : SRF GIGS REPORTS 69
3.1 EPA’s SRF National Information Needs 70
3.2 SRF GICS National Reports 76
SECTION 4 : SRF STATE OPTIONAL SYSTEM 132
4.1 Introduction to SRF State Optional
System 133
4.2 SRF State Optional Data Entry
System Screens 1 36
4.3 SRF State Pilot Optional Reports 144

-------
SRF GICS INSTRUCTION MANUAL
Table of Contents
EXHIBITS PAGE
1.3.1 Capitalization Grant Phases and GICS 8
1.3.2 SRF Flowof Funds 11
2.1.1 SRF GICS Specific Source Documents 1 7
2.1.2 Sources of Information 20
2.2.1 SRFandGICS 29
2.2.2 Interrelationship of Data Entry Screens 31
2.2.3 Data Entry Screens 33
2.2.4 SRF Source Data Elements 45
2.2.5 Data Element List by GICS Screen 58
3.1.1 Enviromental Protection Agency’s SRF
Information Needs 72
3.2.1 SAF GICS Report Summary 78
3.2.2 SRF GICS Report Select Logic Criteria 80
3.2.3 SRF GICS Reports 100
4.1.1 SRF State Optional System and GICS 135
4.2.1 SRF State Optional Data Entry System
Screens 137
4.3.1 SRF State Pilot Optional Reports 1 45

-------
SRF GICS Instruction Manual
SECTION 1. INTRODUC11ON
Introduction Section 1 of this Instruction Manual provides
information on the purpose and uses of this manual,
other available references, and an overview of the
relationship between the State Revolving Fund (SRF)
program and the Grants information and Control
System (GICS).
Contents of Section 1 has been organized as follows:
This Section
For Information
On:
See Section:
See Exhibit:
What this manual
1 .1
Purpose and
provides
Uses of
Instruction
Manual
Other reference
1.2
Other
resources
Available
References
Overview of SRF
and
1.3
Overview of
1.3.1
Capitalization
GIGS
SRF and GIGS
Grant Phases
and GICS
1.3.2
SRF Flow of
Funds
1

-------
SRF GICS Instruction Manual
1.1 Purpose and Uses of Instruction Manual
Purpose
What is It? It is a manual that provides information on the flow of
capitalization grant and State Revolving Fund (SRF)
project level information through the Grants Information
and Control System (GICS). It highlights the relevant
SRF source documents and the data elements required
to be entered into GICS.
Why was it
Developed? This manual was developed to introduce potential users
of the State Revolving Fund - Grants Information and
Control System (SRF GICS) to the system and to support
the SRF GICS training effort at the State and EPA
Regional Office levels.
How Will It
Help People
In their Work? This manual was designed to instruct initial users in the
relationship between the SRF information source
documents and the applicable SAF GICS data entry
screens and reports. It acts as a reference guide by
providing tables and other exhibits on SRF GICS, with
minimal emphasis on narrative descriptions.
What Does The
Manual Not
Provide? This manual does not describe the specific procedures of
logging on to the system, entering data, responding to
error messages, or generating reports (this information
is provided in the SRF GICS Users Guide from the Office
of Information Resource Management). It also does not
provide detailed system documentation (this information
is provided in the SRF GICS Detailed Design document
from the Office of Information Resource Management).
2

-------
SRF GICS Instruction Manual
1.1 Purpose and Uses of Instruction Manual (continued)
Uses
Who Will Use
This Manual? The primary users of this manual will be the EPA
Headquarters, Regional Office and State staff members
involved in the SRF program.
How Will
They Use It? o Executives will use this manual as a high-level
system overview to provide an understanding of the
GICS capabilities for SRF processing and
management of the SRF program.
o Mid-level managers will use it to understand the
aspects of the system that will be used by their
staff in their daily processing activities.
o Individuals who will actually be responsible for the
day-to-day data processing activities will use it
as a quick reference guide.
How Is This
Manual
Organized? Each part of this manual provides the EPA Headquarters,
Regional Office, and State Office staff members with
different types of information. Following are
suggestions for uses of each part.
3

-------
SRF GICS Instruction Manual
1.1 Purpose and Uses of Instruction Manual (continued)
SECTiON USES
Section 1: 0 To obtain a high-level understanding of the
Introduction relationship between the SRF program and
GICS
o To become familiar with the use of GICS
for SRF information processing
Section 2: o To become familiar with the sources
SRF G CS Required of SRF data
Data Elements o To determine which SRF documents
provide SRF data for GICS data entry
o To become familiar with the SRF
data elements required to be entered into
GICS
o To become familiar with the SRF GICS
data entry screens
o To determine which GICS data entry
screens are used to enter SRF data
Section 3: o To become familiar with the GICS
SRF GIGS Reports SRF Reports
o To determine which SRF GIGS reports
will be most useful
o To provide a how-to reference on
reading reports
Section 4: 0 To become familiar with the SRF GIGS
SRF GICS Optional optional data entry screens
Data Elements 0 To determine which GICS data entry
screens are used to enter optional SRF data
elements.
4

-------
SRF GICS Instruction Manual
1.2 Other Available References
The EPA Headquarters has prepared a series of
documents related to GICS and the SRF program that should
be used along with this Instruction Manual to further
supplement your knowledge of GIGS and SRF:
o SRF Initial Guidance - Programmatic guidance
based on legislation (does not address the GICS
relationship)
o SRF Regulations - Implements the SRF legislation (does
not address the GICS relationship).
o SRF Management Manual - Describes in detail the SRF
source documents and how the SRF will be managed.
The SRF Management Manual contains all significant
guidance or regulatory materials which pertain to the
SRF program, as well as examples of the various SRF
documents.
o SRF GICS Detailed Design Document - Defines the data
entry process for SRF GICS. Copies can be obtained from
the Office of Information Resource Management.
o SAF GICS Users Guide - Provides detailed
system procedures on data entry, report generation,
and error messages. Copies can be obtained from the
Office of Information Resource Management
o GIGS Data Element Dictionary - Provides a listing
and definitions of GICS data elements. The SRF data
element dictionary is a subset of this dictionary.
Copies can be obtained from the Office of information
Resource Management.
o SRF GIGS Reports Library - Provides a listing of all
Construction Grants and SRF National reports and aids
users in locating and generating these reports.

-------
SRF GICS Instruction Manual
1.3 Overview of SRF and GICS
Title VI of the Clean Water Act (CWA) authorizes the EPA to make
capitalization grants to States for establishing State Water Pollution
Control Revolving Funds (SRFs). States can provide loans and other forms
of financial assistance (excluding grants) to local municipalities for CWA
projects from the SRF. EPA does not have a role in administering the SRF
funds at the project level, therefore, a minimal amount of grant and
project data is required to be tracked at the Federal level. The EPA’s
Grants Information and Control System (GICS) has been enhanced to
capture the SRF data required by the EPA.
The data to be entered into GICS is a small subset of SRF-related
information that is reported in the State-submitted documents required
by the 1987 CWA amendments. The data entered into GICS will enable the
EPA to:
o Manage its SRF Capitalization Grant Program,
o Provide a Basis for its Required Outlay Projections, and
o Meet its Responsibilities for Congressional and National
reporting.
This section provides an overview of the SRF program and its
relationship to GICS.
Other In addition to the information addressed in Section 1
Available of this Instruction Manual, other reference resources
References that provide related information include:
o SRF Management Manual
o SRF GICS Users Guide
o SRF GICS Reports Library
6

-------
SRF GIGS Instruction Manual
Exhibit 1.3.1 CapitalizatIon Grant Phases and GICS
The SRF Implementation can be divided into four general phases:
o !re -App lication
o Application/Agreement, consisting of
- Application
- Award
- Amendments
o SRF Operation
o Annual Review
This exhibit focuses on the steps occurring in each of these phases
and the required types of data entered into GICS. The State and Regional
Office responsibilities are highlighted. The data may be entered into GICS
at the State or Regional Office level.
For further information on identifying the SRF data elements
required for GIGS processing, the documents which provide the data, and
the related GICS data entry screens, see Section 2, GIGS Required Data
Elements.
7

-------
CAPITALIZATION GRANT PHASES AND GICS
ExhIbit 1.3.1
Page 1 of 2
STATE
Develop legislation, regulations.
and operating procedures for
establishing SRF.
Conduct pr.llmIna,y
negotiations with EPA
Prepare Op.rath g Agreement
(OA) (optional)
Prepare Project Priority Ust (PPL)
and Intended Use Plan (IUP)
(Obtain Public Input)
REGIONAL
OFFiCES
i’ Conduct prelIminary
negotiations with State
REQUIRED
TYPES OF DATA
ENTERED IN GICS
- PR. Is . raarsd k GlOB
Prepare Grant Application
Submit:
• Grant ApplIcation
• Operating Agreement (optional)
• intended Use Plan
Recelpi of Grant Award —
IUP
Grant
Review applicatIon and suppovtlng
documentation.
Officially notify State of
Capllallzatlori Grant award and
amount obligated by EPA.
Project Level IdentIfication
(financial and program
i n formation)
Grant Identification
Information
Grant IdentIfIcatIon
and
Grani Financial Information
z
0
I-
C,
-
a.
a.
iLi
a.
z
0
C.,
a.
a.
I-
z
w
uJ
z
0
C.)
-j
a.
a.
8

-------
CAPITALIZATION GRANT PHASES AND GICS
Exhibit 1.3.1
Page 2 of 2
.
STATE
REGIONAL
OFFICES
REQUIRED
TYPES OF DATA
ENTERED IN GICS
w






U
1
Q.
0.
4
0 )

ut

z
IM
4
.
State requests Amendment to Grant
(May be requested at anytime —
based on circumstances
affecting grant)
Evaluate Amendment request
-
Accept or Reject change
to Grant Award
Grant Identification
and
Grant Financial Information
z
0



Estimate dsbursements and
cash ó’aws
Provide financial Assistance
Monitor projects
PAanageSRF
DIebureert n1 and cash draw
ealmates wSI be ue.d as a basis
On 5 Ofl outlay
Annual
Prepare Annual Report Project Level Identification
Report Financial and
Program Information
Assess success of SRF performance
by comparing proposed to astual
use of fund.
Determine extent to which SRF is
achieving the Intent of the
Clean Water Act
Assess compliance with Grant
Agreement
Assess financial status of SRF
9

-------
SRF GIGS Instruction Manual
Exhibit 1.3.2 SRF Flow of Funds
Each SRF is a legally authorized revolving fund established to
provide the financing needed to maintain water quaLity. The source of
funds that are administered by the SRF include:
o Capitalization Grants
o 20% State Match
o Excess State Match (Overmatch)
o State Bond Issues
o Investment Interest
o Principal and Interest from Municipality Loan Repayments
These funds are then distributed to municipalities for CWA projects,
in the form of loans or other financial assistance (excluding grants). The
repayment of the prinicipal and interest of loans is recycled through the
SRF to fund additional CWA projects.
This exhibit depicts the flow of funds through the SRF.
10

-------
SRF FLOW OF I
iIDS
Exhibit 1.3.2
FUND SOURCES
20% State _____
Match
I
—WI. I . _...I.
STATE REVOLVING FUNDS
STATE CAPITOL
—
Loan Repayments
Principal/Interest
P I I . . , :
,_.I._..._ I
LOANS TO MUNICIPALITIES
FOR CWA PROJECTS
II - - .
I
Capitalization
Grants
I II II I II II I till I II 111 1 1 I liii 1111111 It li ii I ill It I liii
Excess
State Match
State Bond
Issues
Investment
Interest
I
-I-
.1.
-I—
11

-------
SRF GICS Instruction Manual
SECTION 2. GICS REQUIRED DATA ELEMENTS
Introduction The State Revolving Fund information processing
requires States to report information about its SRF
to the appropriate EPA Regional Office. Section 2
of this Instruction Manua’ defines the data that
is required for GICS.
Contents of This section identifies the SRF data elements required
This Section for GICS processing, the documents which provide
the data, and the related GICS data entry screens. In
order to most clearly present the SRF information
required for GICS, Section 2 has been organized
as follows:
For Inlormat%on On:
See Section:
See Exhibit:
Source documents
2.1
Information
2.1.1
SRF GICS Specific
providing Lnformation
Sources
Source Documents
for data entry
2.1.2
Sources of
information
Overview of SRF
2.2
Data Entry
2.2.1
SRFandGIcS
Information
processing
2.2.2
Interrelationship
of Data Entry
Screens
Relationship between
2.2
Data Entry
2.2.3
Data Entry Screens
source documents and
the data entry
2.2.4
SRF Source Data
screens
Elements
2.2.5
Data Element
List by GICS
Screen
12

-------
SRF GICS Instruction Manual
SECTION DATA ELEMENTS
Other In addition to the information addressed in Section 2 of
Available this Instruction Manual, other reference resources
References that provide related information include:
o SRF Management Manual - Describes the SRF source
documents and how the SRF will be managed
o SRF GICS Detail Design Document - Defines the data
entry process for SRI GICS. Copies can be obtained
from the Office of Information Resource
Management.
o SRF GICS Users Guide - Provides detailed
system procedures on data entry, report generation,
and error messages
o SRF GICS Reports Library - Provides a listing of all
Construction Grants and SRF National reports and
aids users in locating and generating these reports.
13

-------
SRF GICS Instruction Manual
2.1 Information Sources
This section identifies the sources of information required by the EPA
to be captured in the Grants Information and Control System (GICS).
The Information Sources section is designed to familiarize you
with the:
o SRF-specific source documents
o Required data
SRF-Specific Source Documents
Information to be stored in GICS is a small subset of the information
submitted to EPA for the SRF program. Information on the State Revolving
Fund will generally be available for entry into GICS from the following
five SRF documents:
o Project Priority List - Identifies potential publicly owned
treatment works (POTW) and SRF projects and their priority
for assistance (Funding may not follow PPL order.)
o Grant Applicatioi - Requests SRF grant assistance for the
State’s SRF program’s fiscal year
o Intended Use Plan - Sets forth the goals and describes the
activities planned for the fund during the upcoming State’s SRF
program’s fiscal year
o Grant Agreement - Sets forth the conditions under which the
State agrees to conduct the SRF program and fixes the amount
of funds EPA will obligate for this purpose
o Annual Report - Describes the activities of the fund for the
previous State’s SRF program’s fiscal year
14

-------
SRF GICS Instruction Manual
Reauired Data
Each State may apply for capitalization grant funds under Title VI.
The EPA requires certain information to be entered into GICS to assist in
effectively managing the State Water Pollution Control Revolving Funds
(SRFs) and in responding to Congressional reporting requirements. This
data is categorized as follows:
Capitalization
Grant Specific information on the SRF
capitalization grant awarded to the
State including identifi ation and
financial information
SRF Project Essential characteristics of all projects
assisted by the SRF including identification,
financial, and program information
The following chart summarizes the source documents that provide
information on planned and actual activities for the grants and projects:
PLANNED ACTUAL
ACTIVITIES ACTIVITIES
CAPITALIZATION
GRANT
INFORMATION
APPLICATION FOR
FEDERAL
ASSISTANCE
EPA ASSISTANCE
AGREEMENT/
AMENDMEM
SRF PROJECT
INFORMATION
PROJECT PRIORITY
LIST (PPL)
INTENDED USE
(IUP)
ANNUAL REPORT
15

-------
SRF GICS instruction Manual
Exhibit 2.1.1. GICS SRF Specific Source Documents
The SRF program is a State-oriented program. All information
concerning the capitalization grants and individual projects is submitted
by the Stat to the appropriate EPA Regional Office. Each State operates
its respective fund in the fiscal year of its choice. The State’s SRF grant
fiscal year may be that of the Federal government or of its own choosing.
The EPA requires that certain information is submitted in order to
provide grant monies to the States. With the exception of the Application
for Federal Assistance and the Grant Agreement/Amendment forms, there
are no standard formELts to follow in submitting the required information.
The SRF Management Manual provides useful examples of reporting
formats to assist the States in providing the required information not
inc’uded on the standard forms.
This exhibit summarizes the source documents containing the
information to be included, how often the document is submitted to the
EPA, and the document format.
16

-------
• SRFGICS SPECIFIC RCE I OCUMENTS
SUBMISSION
DOCWB ff DESCRIP11ON FREQJBICY FORMAT
PROJECT 0 Identifies potential o One-time o Varies with State;
PRIORITY Construction and SRF Submission must provide
LIST (PPL) projects specific data for
entry into GICS
o Establishes Priorities
for Assistance
APPLICATION
FOR FEDERAL
ASSISTANCE
o Requests SRF Grant
Assistance for the
Year
o Annually
o Amendments may be
made at any time
o 0MB SF-424
INTENDED
USE PLAN
(IUP)
o Identifies Goals and
Planned Activities
of the SRF for the
Upcoming Year
o Activities identified
must be on PPL (except
for 319 and 320
projects)
o Annually
o Varies with State;
must provide
specific data for
entry into GICS
17

-------
Exhibit 2.1.1
SRFGICS SPECIFIC SOURCE DOCUMENTS Page 2 of 2
DO L1AB 1T
DESCRIPTK*1
SUBMISSION
FRB B4CY
FORMAT
.
EPA
ASSISTANCE
AGREEMENT!
AMB 1DM 1T
o Actual Grant Award
o Identifies the Conditions
under which the State
agrees to conduct the
SRF program
o Identifies the funds
EPA obligates for this
purpose
o With each Grant
Application or
Amendment
.
.
o EPA Form
5700-20A
ANNUAL
REPORT
o Identifies the Actual
Activities of the SRF
for the Previous Year
o Annually - within
90 days of the end
of the fiscal year
in which payments
were made
o Varies with State;
must provide
specific data for
entry into GICS
18

-------
SRF GICS Instruction Manual
ExhibIt 2.1.2 Sources of Information
This exhibit provides sample copies of the two, standard forms (the
Application for Federal Assistance and the EPA Assistance
Agreement/Amendment) and the data required for entry into GICS to be
included in other source documents submitted by the States to the EPA
Regional Offices. The data elements provided by the other source
documents are presented in a chart since each State will prepare these
documents in their own established format.
The data elements that are entered into GICS are highlighted with an
arrow on the two standard forms. Only the data elements that are enteted
into SRF GICS for the first time, from each of the two standard forms, are
highlighted. Similarly, only those data elements that are entered into SRF
GICS for the first time from the sample formats are displayed. For
further information on relating the data elements from the source
documents to the GICS data entry screens, see Section 2.2, Data Entry.
Additional detailed information and source document examples are
provided in the SRF Management Manual.
19

-------
SOURCES OF INFORMATION
Exhibit 2.1 .2
Page 1 of6
APPUCATION FOR
FEDERAL ASSISTANCE
&
881711
I
I —__ RIlS
-
-
O t V PLJlR______
CS7g000l-Rg
p
Const ction Grants Division
..----- I-
——_____ — — —
P.O. Box U
City. County. New Watsr XXUX
— —---- - — ——
Eiisaative Director
(m)ux .xxu
t i. __.___ —— ——
1oIoI IaIoIo(aIoLoioI
p. — —--— ——
‘
a i — —
£ -i_.
S .—.
t _ —-_
c a —— c’—
——a- —
£ — S C
-
t-
P

—
U.S. Enviroi ntaI Prot.ctio n Agency
New Water Water Pollution Control Revolvii
Fund as described in this application and
th attached Intended Use Plan and Pa at
Sci,e ale
•• Ca’. Grant for Stat. Revolvin
St - - — —
Stats of New Water
II . i—w- ‘4 — —
I ‘- -—-—-
88/10/01 3/01/01 AU. AU.
It !
:-i :
is..a- — — -
•
20.000.000
fl — S -J I D IIU
II lI _ . ‘WI rP-
88/06/01
0
0 on ‘-. i.e us uya,v
—:i
$ a
S a
4.000.000
£
s a
s a
.
,,. s .u —. — — — -
ov. D i .
i!T
‘4. O0 .9 B •
s — —. — —— — —. .ia.. s —. — W
—- — -— • s 1T — — S —
r rx1xxi r I £xea tive Director
h I( T T x
a___su irt1
xx—xx—xx
- .— — - — —
—
w$ __ 3
20
I v .
C.

-------
SOURCES OF INFORMATION
Exhibit 2.1.2
Page 2 of 6
EP D C A tP . 4•e. 0? %*. . . --
21
. IC NO. 2 OS NIiNSSS
u.s. SNVI O SN *I. P seitcYt oN ouNCV CS
EPA AWZTAIIC* AQCIIMINTIAMINOMINT COTS OP ONANO 4.N*, O OATS —
•a$? S. a1anOZ NO CATION SNO $TION xxixxi xx I xxixxixx
a. £OSSS SNT ? • 5 •e. PA, SNV MSTNQ O
eu__ I = . LflhI SI C, N XXXXXXXX
‘ -.-— I A $ • -- rr u o. ACTION
—- . I Niw Gravrt
a. OselpasNy
a. •avsu
Iew Watar OsDarwi.nt of Environ. Protec.

City, New

XX—XXXXXXX St ataw de
New Water Watar Oevelopm.nt Coa iizion
P.O. Box U
City, t e Water XXX
IS.
State Aaency
I I •msacr aosaai oso TU IPNONS NO.
3. CONSUlTANT IVWV C.- ._ ...iu....
xXXxx XXXXXXXXxX
Executive Director
N/A
I i. I SSU 1NO OPPICS IelNsSISI Is. Us PNSJ$CTJITATS OPPSCSR ONO TUI.UNONS NO.
EPA Region a... XXXIX XXXXXXXXXXXX
City. L4sv bZatsr egiOn
City. Stat. IXIZZIX (Xfl XX.XXXX
IL UP S CQNS ISPA%. S T 5I .. Ø. IS STATS * % 10 ‘CL... j - 517. PIS OP SC1INC S PNO.aCT SYSPWWFCO
1a noekirvij202l R2 -184 XX —XTxX-XXI1 I NM I N/A
IS WTA?%ITONV *% VIIONTVV
Clean Water Act, as anndsd
Title VI lAd Section 205(o)
*5. OUSU A *NTNONSTV it. ITUP 1.3$ STU S SV Ca_ ._.._ 0.1..
1._v. —

40 CR Part 31 I
S. — 0 U
33. Pos.mc? TITLI ANO OUCR.PYIQ.
The State of New Water Water Pollution Control Revolving Fund under Title V! of the
Cloan Water Act.
- - ta p.o.IScT 0 CATION l4 • ONI
-- - -
StatowIda. - Statewid .
1 C...._. —
All
a. SIJOOS? P 1 5105
3 5. IST*NCS PUOSSS C1U* J _ .YS. S UNf 35. PNOa&CT PUNIOS
BL4S8 Can. (r1mt1 f r SPF I N /A
lfliflhiPR..flhiflhiOl
St. CONNISNITY P0PIJS.ATIOU .vr co as. oi* . SUSSIT P55 100 COST
I
a. TOTA%. ,0s CY P 15 103
.
,0a%.
•UIIOZ
•O5 I5 SNOSO
iNN ACTION • £MlN 50
a.SPA*I- IT
N/A
ç7flppfl Øflfl N /A
si. Us
N/A
N/A N/A
a. u- .. v s_
P i/l
N /A N/A
N/A
a. e
N /A
i s . a___ .CJ eJ — MM 1 NjA N/A
*a.seici s 4See p.31 NIl 4.0 00,Ofl O Nil
I I/l N/A
3?. aN c.s n. . over match) N/A I 4.000.000 I N/A
, annnnnn MIA
,,w_— a_.____— . 5. C I N. N _ • OlsoN el - . OS$ N A I
L LL

-------
Exhibit 2.1.2
Page 3 of 6
SOURCES OF INFORMATION
GRANT NO. CS7900 0j .—8g
PART Ill - AWARD CONDiTIONS
The prmcap.l ‘PARTS of Subchapter B applicable to this grant are
PART 31 Uniform Administrative Requirements for Grants and Cooperative Agreements to Sure and Local
Governmenu and PART 32 Debarmeni and Suspension under EPA Asstsiancc Programs.’
‘The Stare Conthbuüon consists of:
A. Ca $4 , 000,000
B. Previous Tide VI Eligible Assistance -0-
( B- )
C. Previous Cash Overmatch (Banked) -0-
35 Total
The grantee agrees to accept payment from EPA (as increases to the amount of funds av2II h1e from
the Automated Clearing House (ACE)) in quarterly installnienis in accordance with the following
schedule:
October 15, 1988 $2,042,000
Januacy.5. 1989 4,175,000
April 23 989- 4,325,000
July 10, 1989 5,667,000
October 3, 1989 2,000.000
J2nn ry 11. 1990 1,125.000
April 23. 1990 666.000
July l. 1990 0
October 5. 1990 0
J im ry 8, 1991 0
April 12. 1991 0
Once a payment has been made. EPA will not reduce that ACE ceiling.
IPA P.’. 7SO ZGA “A .3* V
22

-------
Exhibit 2.1.2
Page 4 of 6
SOURCES OF INFORMATION
Project Priority List
o Project Number
o Permit Number
o Assistance Recipient’s Name
and Address
o Project County Name
o Project Funding Status
o Assistance Recipient’s Congressional
District
o Authority/FaciI ty No.
o Multiple Facilities Code
o State Project Priority List Fiscal Year
o Indian Id
23

-------
Exhibit 2.1.2
Page 5 of 6
SOURCES OF INFORMATION
Intended Use Plan
o State FY Date
o Project Number
o Permit Number
o Assistance Recipient’s Name,
Address, Congressional District
o Project County Name
o Program Code
o Authority/Facility No.
o Multiple Facilities Code
o IUP Fiscal Year
o Loan Interest Rate
o Binding Commitment
Targeted Amount
Targeted Date
o Indian Id
o National Municipal Policy: First Use
Projects
o WWT Eligible Cost Categories
o Assistance Types
o Initiation of Operation
The IUP is the first source document with identifying and
financial data elements for all 319 and 320 projects.
24

-------
Exhibit 2.1.2
Page 6 of 6
SOURCES OF INFORMATION
Annual Report
o State FY Date
o Project Number
o Annual Report Date
o Loan Interest Rate
o Binding Commitment
Actual Amount
Actual Date
o WWT Eligible Cost Categories
o National Municipal Policy: First Use
Projects
o Identify Title- U Equivalency Projects
o Affirmative Project Performance
Certification
o Construction Start Date
o Assistance Types
o Initiation of Operation
25

-------
SRF GICS Instruction Manual
2.2 Data Entry
This section relates the information source documents described in
Section 2.1, Source Information, to the SRF-specific GICS data entry
screens.
The data entry section is designed to:
o Familiarize you with the SRF-specific GICS Information
Processing
o Familiarize you with the SRF-specific GICS data entry screens
o Help you determine when to access each of the data entry
screens
o Familiarize you with the type of information entered on
each screen
o Relate the appropriate source documents to the SRF-specific
GICS data entry screens
28

-------
SRF GICS Instruction Manual
The features and benefits of the
SRF-specific GICS screens are:
GIGS FEATURE
WHAT This MEANS TO YOU
o
Data Entry Screens
o
Limits duplicate data entry
are Interrelated
by carrying key data from one
data entry screen to another
during a data entry session
o
Unique SRF-specific
Data Entry Screens
o
Customized Screens pertinent
to SRF source information
aid in data entry
o
SRF Data is stored by
o
Retrieval of Information
Capitalization Grant
is facilitated by one key
and/or SRF Project Number
element
a
On-line Edits and
Validations
o
Quality Assurance of data
entry information
For detailed procedures on entering data into GICS, consult the SRF
GIGS Users Guide.
27

-------
SRF GIGS Instruction Manual
Exhibit 2.2.1 SRF and GICS
This exhibit provides an overview of
source documents (identified in Section
entered into SRF-specific GICS screens.
database. Information may be accessed
additions and modifications or retrieved
GICS processing. Data from the
2.1, SourcQ. Information), is
This data is stored in the GICS
through the data entry screens for
for inquiry and reporting.
2B

-------
flE n
DATA ENTRY SCREENS
Exhibit 2.2.
SRF NATIONAL REPORTS
U s
29

-------
SRF GICS Instruction Manual
Exhibit 2.2.2 interrelationship of Data Entry Screens
This exhibit depicts the structure and interrelationship of the SRF-
specific GICS screens. The information entered by users in the Main Menu
determines which screens are accessed. In order to gain access to either
Grant or Project Data Screens, the user enters a Grant Number into the
Main Menu. The grant number is a 9-position number, the structure of
which determines whether Capitalization Grant or SRF Project Data
Screens are accessed.
Capitalization Grant Data Screens SRF Project Data Screens
— — — — — — — — — a — — — —
TT TT ‘ p
State Id State Id
Serial Number Serial Number
Grant 0001 Sequence Number 0001 - 9999 Sequence Number
Grant.FiscalYear 01.99
Amendment Amendment
Designator Designator
Users also specify on the Main Menu whether grant or amendment
records are to be selected.
Additional detailed information on capitalization grant and SRF
project numbering is provided in the SRF Management Manual.
30

-------
SRF GIGS Instruction Manual
Exhibit 2.2.2
Interralatinnshir
øf Data Entry Scraan
CAPITALIZATION
GRANT DATA
SCREENS
Grant Record
CAP GRANT
ADDCHANGE
MENU
SRFGAP
APPLICATION
DL
IC
H
SRF CAP GRANT
FINANCIAL
INFORMATION
PRE-AWARD
SRF CAP GRANT
FINANCIAL
INFORMA T ION
POST-AWARD
r
SRF
MENU
Amendment Record
CAP GRANT
AMENDMENT
ADDICHANGE
MENU
SRF CAP
GRAM
AMENDMENT
APPLICATION
SRF CAP GRANT
AMENDMENT
FINANCIAL
INFORMATION
PRE-AWARD
SRF CAP GRANT
AMENDMENT
FINANCIAL
INFORMATION
POST-AWARD
]
I
I
Note: Help screens are av&lable for ear’ t’ ” ta entry creens.
SRF
PROJECT DATA
SCREENS
L
[
[
[
31

-------
SRF GICS Instruction Manual
ExhIbit 2.2.3 Data Entry Screens
The SRF data that is included in the source documents is entered into
GICS. Each screen is shown with a description of its purpose, the type of
informatióñ entered, and source(s) of information to be entered. The
type of information that is displayed on the data entry screens will vary,
depending upon the current status of the grant. If the grant is in the pre-
award phase, current targeted data is reflected on the pre-award
screens; if the grant has been awarded, both current and cumulative data
is reflected on the post-award screens.
To make the entry, use, and understanding of the information stored
in GIGS easier, the data for grants and projects has been divided into
three categories:
o Identification - Provides a description of the grantee or
assistance recipient. Examples of information in this category
include the State name, the region, and the SRF assistance
recipient.
o Financial - Provides information about the grant award or
assistance amount. Examples include the payment schedule,
State match and loan repayment interest rate.
o Program - Provides project and grant information relating to
specIfic requirements for the SRF grant program management.
Examples of information in this category include the type of
assistance provided and the identification of Title II
equivalency projects.
32

-------
SRF MAIN MENU
PURPOSE:
TYPE OF
INFORMATION
ENTERED:
SOURCE(S):
Select appropriate screen for data entry by
entering the capitalization grant or SRF
project number and the type of transaction
you wish to process.
Grant and Project Identification data
Application for Federal Assistance -
EPA Assistance Agreement/Amendment
Project Priority List (PPL)
Intended Use Plan (IUP)
Annual Report
Exhibit
Page 1
2.2.3
of 11
GLUMAIN1 GL7 VOJN1 GIC P.F DATA ENTRY SYSTEM
_____________________ t IN MENU - NATIONAL
PROJECT RECORD - ADD PA
BROWSE. . . PB
CHANGE. . . PC
DELETE. . . PD
MAJOR KEY CHANGE -
910409
ADD AA
BROWSE. . . AB
CHANGE. . . AC
DELETE. . . AD
AMENDMENT RECORD -
PROJECT.. . . PK
AMENDMENT. . AK
ENTER SELECTION ==>
ENTER GRANT-NO ==>
PC
470493050
SCREEN (OPTIONAL) ==>
RECORD-TYPE = > C
FF1 - HELP PF4 = NASTE. IENU PF9 LOGON FF].1 = SEARCH ‘XX’ = EXIT
33

-------
SRF CAP GRANT APPLICATION Exhibit 2.2.3
Page 2 of 11
GW1SAP1 GL1 3AP1 GICS DATA dTMZ BTSTE( LA8T UPPATI:
_________________________ S CAP R T APPLICATICU _________________________
NTXT SCSZZN: SiX
PSOGAMI : AUTBORXT! : STATZ-AP—XD ______________
______________________________ RZGXO!1
STATS? ________________________ CI ? ! _______________
STATS ZIP ; __________ SRI-?ISCA — ! ZAR
APPLICATICU-UC-DATS:
au uS—MmPD TD
pyi— ip i P72-NAT? SCAZAT PA2-WPZSB scpW
PY3PRTVIdUS I U Pf4I IN I NU
PURPOSE: Enter Capitalization Grant Identification data to
record preiiminary grant information in GICS.
TYPE OF
INFORMATION
ENTERED: Grant Identification data
SOURCE(S): Application for Federal Assistance
EPA Assistance Agreement/Amendment
34

-------
SRF CAP GRANT FINANCIAL
DATA (PRE-AWARD )
OLU1STX1 GU S7I1 01CR DAfl TRI S STD( L 3T UPDAfl:
NZXT ScRZU: SRI CP GRMT TINMCIAL DATA- PRZ- PD
ORIGINAL CUIIULPiTIVI
- 3 ____________ 3
WATCH-cASH 3 ____________
W ATCE-ASST-BAI D 3 _____________ 1 1 wJ PD-CD/DAfl:
M ATCB-CASR-BAN D 3 ____________ 3
WATCH-P.XQDIRZD I ___________
T NDS-RZQDXRZD 1 ___________ 3 AWAPDZD
VZBWATCH I ____________ I
PAfl NTS: 87/1 ____ 1 _________ 3
UAR/ OTR 87/2 ____ ] 3
DATZ 87/3 ____ 3 ________ 3
A)IOVW? 87/4 ____ 3 _________ 3
88/i ____ 3 —________ I
88/2 ____ 3 ________ 1
88/3 ____ 3 _________ 3
88/1 ____ 1 _________
89/i ____ I _________
89/2 ____ 3 _________
89/3 ____ 1 _________
ZNTU:UPDATZ PIi: LP P12:NRXT PT3:PRZV P74:WAII PA2:RZTRZSH P16:OVZRBIDZ
t
PURPOSE: Enter Capitalization Grant Financial data to record
- grant award information in GICS.
TYPE OF
INFORMATION
ENTERED: Grant Financial data
SOURCE(S): EPA Assistance Agreement/Amendment
NOTE: There are two versions of this screen, Pre-Award and
Post-Award. This is the Pre-Award version, which
allows the user to enter financial information and 1 award’
the grant.
35

-------
SRF CAP GRANT FINANCIAL
DATA (POST-AWARD )
GLU1S s1 GI1I I8AS1 GICS DATA TU SYBTEI IISST VPD fl:
T ScRUN SRi C P OPAS? M’ ) T TIN DATE- POST—M SP.D
___ OPXGXNAL CUIIULUXVZ
I___
I _______ I
1 TCS—ASST—BA D 1 _____________ 1
1 ___________ 1
____ 1 ______________ 3
3 ______________ 3 kWARD-cD/D TZ:
OVZ TcR 3 ____
PZX1 TS: 87/1 ____ 3 ________ 3
YUP./QTR 87 / 2 ______ - ____________ I
87 / 3 _____ ___________ 3
87/1 ____ 3 _______
88/1 ____ 3 ‘ 1
88/2 ____ 3 ________ 1
88/3 ____ 1 1
88/4 ____ 1 _________ 1
89/1 ____ 3 ________ 3
89/2 ____ 3 ________ 3
89/3 ____ 3 — ______ 3
Z TSR:UPDP .2I PT1: LP P72:NRXT Pi3:PRZV Pf4: 9A2:PXTPUE PT6:OVZRSXDZ
PURPOSE: Displays Original Award and Cumulative Financial
amounts for Capital Grant awards and allows user to
TYPE OF correct financial data.
iNFORMATION
ENTERED: Grant Financial data
SOURCE(S): EPA Assistance Agreement/Amendment
NOTE: There are two versions of this screen, Pre-Award and
Post-Award. This is the Post-Award version which
displays the complete set of financial data, and allows
the user to modify any of the original financia’ values.
36

-------
RF CAP GRANT AMENDMENT Exhibit 2.2.3
APPLICATION (GRANT NOT AWARDED ) Page 5 of 11
GLU1SAA1 GZMMM1 GICS DATA ENTRY SYSTEN LAST UPDATE:
___________________ SR I CAP GRANT A3 NDMRNT APPLICATION _____________________
NEXT SCREEN: SA N
NA1 : STATE: REGION
SR I-TIS CAL-UAR : STATE—A N-ID ______________
APP LICATION-REC-DATI: ______ A RD-CD : —
CURRENT PRO3ECT A NDNENT
(TARGETED) (CHANGE)
JUNDS—AWARDED
MATCH-CASH
MATCH—ASST—BANTED
MATCH—CASH-RANTED
MATCH—REQUIRED
OVERMATCH
PT ]. = HELP P12 — NEXT SCREEN PAT - P.EJRESH
P13 — P 5EV NENU P 1 4 - MAIN I U ENTER — UPDATE SCREEN
PURPOSE: Enter Capitalization Grant Amendment data to
update information for amendments to the
original grant award In GICS. Current Project
(Targeted) amounts are entered.
TYPE OF
IN FORMATION
ENTERED: Grant Identification data
SOURCE(S): Application for Federal Assistance
EPA Assistance Agreement/Amendment
NOTE: There are two versions of this screen, one displaying
targeted amounts for projects with grants not yet
awarded, and the other displaying awarded cumulatives
for projects with awarded grants. This screen is
for projects with grants not yet awarded.
37

-------
SRF CAP GRANT AMENDMENT Exhibit 2.2.3
APPLICATION (GRANT AWARDED ) Page 6 of 11
GLUISAA1 GIMASAA1 GXCS DATA SRTRX SYST LAST UPDATZ:
____________________ SPY CAP GRAST M’ ’ ? APPLICATIOS _____________________
NZXT ScAZIN; SAS
STATS: PZGIOP
SR Y-fl$CAL—YZAR : STATI-AP-ID _____________
APPLICATION-RZC-DATZ: AWARD-cD : — _____
CUPPZNT PROuThCT
(AWARDED CUWS) (CHANGE)
UMuS-AWAPDZD
) TCH-CASE
TCE—A8ST—B A N
)I ATCH-CASE-B A NZID
WATCH-REQUIRED
OVZ T H
P71 ZIL? P72 • NEXT SCREEN ____ PAR — REFRESH
P73 — PREy ) U P74 — WAIN &z — UPDATE
PURPOSE: Enter Capitalization Grant Amendment data for
amendments to the original grant award in GIGS.
Current Project (Awarded Cum) amounts are displayed.
TYPE OF
INFORMATION
ENTERED: Grant Identification data
SOURCE(S): Application for Federal Assistance
EPA Assistance Agreement/Amendment
NOTE: There are two versions of this screen, one displaying
targeted amounts for projects with grants not yet
awarded, and the other displaying awarded cumulatives
for projects with awarded grants. This screen is for
projects with awarded grants.
“a

-------
SRF CAP GRANT AMENDMENT 2.23
FINANCIAL DATA (PRE-AWARD
GL 1SAS1 G1 kSAS]. QICS D&Tk ENTRY SY8TEN LiST UPURTE:
NEXT SCRZ : ) SRI CAP GM T Ri D) T JINAX DR PRXMIAPD
NiNE: ORIGINAL CD)WLATXVZ
3 ___________ 1
I TC8-CASE ___________ 3 AXARD-cD/DATZ:
NATCB-ASST—NANEND 3 3
1aTCH-CASB—BA)J D 3 _____________ 1
MiTCH-REQUIRED 3 ____________ 3 CAP GRANT/
TUNDS-PEQUIR ED 3 ____________ 3 RJIARD-CD/DATZ:
OVEP1 TCE 3 3
PAYNENTS: 87/1 ____ .3 ________ 3
YEAR/QTR 87 / 2 ______ ____________ 3
DATE 87 / 3 ______ 3 __________ — I ANENDi TS:
AMOUNT 87/4 _____ 3 _________ 3
U/i ____ 3 _________ 3
88/2 ____ 3 _________ 3
88/3 ____ 3 _________ 1
88/4 ____ 3 _________ 3
89/1 ____ 3 _________ 3
89/2 ____ 3 _________ 3
89 / 3 _____ 3 — 3 P112: Iz put Assistanos
ENTER: UPDATE P11 : LP P72 :NZXT P13: P8EV P71 :NAIN PA2 : REFRESH P16: OVERRIDE
A
PURPOSE: Enter Capitalization Grant Amendment Financial
data to update information for amendments to
the original grant awarded in GICS. Current Project
TYPE OF (Targeted) amounts are displayed.
INFORMATION
ENTERED: Grant Financial data
SOURCE(S): EPA Assistance Agreement/Amendment
NOTE: There are two versions of this screen, Pre-Award
and Post-Award. This is the Pre-Award version,
which allows the user to enter Cap Grant
Amendment Financial data, and awardu the amendment.
39

-------
SRF CAP GRANT AMENDMENT
FINANCIAL DATA (POST-AWARD )
GW1BAS1 GIMABAB1 QICS DATA ?RY BYBT LAP? DPDAPZ:
BL(? BCRW : BR? CAP GRAB ? BI D3 T TINAB DA2&— PO3?- 3mRD
____ ORIG M 1 CUMUL TIVZ
rU uS—MmRDZD 3 _____________ 3
I ___________
) TCR—As8T—BAB D 3 _____________
1 TCE-CA3B-3AD 3 ___________
TcE—RZQ5IRZD 3 ______________ I CAP GP.APT/
3 ____________
OVZR TCB I ____
PAY3 T8: 87/3. 3 _________ 3
YZAR/Q’ZR 87 / 2 1 ____________ 3
DAT? 87 / 3 1 ____________ 3 A ND3 B ?B:
87/4 1 ________ 1
!I I I ________ I
89/i _________ 3
89/2 _________ 3
89/3 ________ 3
.UPDA2Z PTi:BRL P?2:IZXT P?3:PRZV P ?4: PA2:RZTRZBB
PURPOSE: Displays Capitalization Grant Amendment Financial
data for amendments to the original grant award
in GICS. Allows user to correct Financial data.
TYPE OF
INFORMATION
ENTERED: Grant Financial data
SOURCE(S): EPA Assistance Agreement/Amendment
NOTE: There are two versions of this screen, Pre-Award
and Post-Award. This is the Post-Award version,
which displays the complete set of financial data
and allows the user to modify any of the original
financial values.
40

-------
SRF PROJECT INFORMATION
GPU3SPR1 GPMASPR1 GICS DATA ENTRY SYSTEM LAST UPDATE:
_________________________ SRF PROJECT INFORMATION ___________________________
NEXT SCREEN: SPA
PROGRAM PERMIT : P _________ PROJECT-ID ____________
Pr ZORITY—FY : — MULTI-FACILITIES : — FACILITY _________
FUNDING—STATUS : — INDIAN—CODE : — INTENDED—USE—PLAN—FY
FIRST—USE—CODE : — EQUIVALENCY — ANNUAL-RPT—DATE ______
NAME : ________________________________________ REGION
STREET : _____________________________ CITY _________________
STATE : ZIP : _________ COUNTY _______________
CONG—DISTRICTS: — (Enter ‘ALL’ or use fields below for district numbers)
PROJECT-TYPE: — — SRF—ASSISTANCE—TYPE: — — — — INTEREST—RATE: ______
BINDING—DATE-TARGET ______ BINDING—ANT-TARGET ____________
BINDING-DATE-ACTUAL ______ BINDING-ANT-ACTUAL ____________
WWT-START-CD — ______
PERFORMANCE-CD — ______ INITIATE—OPERATION—CD: —
PF1 — HELP PF2 - NEXT SCREEN PA2 - REFRESH
PF4 — MAIN MENU PF3 - PREV MENU  — UPDATE SCREEN
PURPOSE: Enter Project Identification data to record
information on projects funded by the SRF program.
TYPE OF
INFORMATION
ENTERED: • Project Identification data
SOURCE(S): Project Priority List
Intended Use Plan
(Includes 319 and 320 project data)
Annual Report
41

-------
F COST/ASSISTANCE TYPES
Exhibit 2.2.3
Page 10 of 11
NAME
ST:
:
PROJECT—ID:
BINDING CO ITME
BINDING—DATE—TARGET:
BtNDING-AM? TARGET
BINDING-DATE-ACTUAL:
BINDING-N !-ACTUAL
NT
SRF—ASSISTANCE—TYPE
LOANS
REFINANCING
INSURANCE : —
GUARANTEES : —
(ENTER X IN ALL TYPES
THAT
APPLY
PROJECT-TYPE:
GPU3SPA1 GPMASPA1
NEXT SCREEN: MEN
GICS DATA ENTRY SYSTEM
SRF Co t/Msistancs Types
LAST UPDATE:
WWT COST CAT QRI S (ixr 212)
CATI ___________
CATII ___________
CAT— l i lA ___________
CAT—IllS ___________
CAT-IVA ___________
CAT—IVB ____________
CATV ___________
STORM-SEWER-COST ___________
TOTAL WWT ——————————> (212):
ESTUARY—COST (320):
MON—POINT-SOURCE-COST (319): —
I
I
PF1 — -iELP
PF4 - MAIN MENU
FFZ — NEAT SCRAEN
PF3 - P9EV MENU
 - UPDATE
PA2 —
SCREEN
PURPOSE:
TYPE OF
INFORMATION
ENTERED:
Enter Project Cost data to provide
information on SRF projects either currently
funded or proposed.
SOURCE(S):
Project Financial data
Intended Use Plan
Annual Report
42

-------
SRF PROJECT MULTIPLES Exhthit2 .3
GPU3SMU1 GPMASMU1 GICS DATA ENTRY SYSTEM LAST UPDATE:
_________________________ SRF PROJECT MULTIPLES ___________________________
NEXT SCREEN: MEN
PERMITS:P P P P _____ P
p p p p _____ p
FACILITIES: _________
PF1—HELP PF3—PREVMENU
PF4 - MAIN MENU  — UPDATE
PURPOSE: Enter SRF Project Multiples for the Permit and
Facilities codes.
TYPE OF
INFORMATION
ENTERED: Project Identification data
SOURCE(S): Intended Use Plan
43

-------
SRF GIGS Instruction Manual
Exhibit 2.2.4 SRF Source Data Elements
This exhibit depicts the relationship between the source documents
discussed in Section 2.1 and the SRF-specific GIGS screens.
Circled letters are used to identify the specific source document
data that Is entered into the screen data field.
44

-------
SRF SOURCE DATA I..LEMENTS
Exhib . ‘.4
Page 1 u, 12
—
uc r ro
‘ NmI! MV,sT Nc1
I. =
r
I I ——
i ( )
U .
j —
—
t’ tsvi- n -_._.mi P t tI Cs ti Ctlii Griuli Dlvii lea
— — ._ —
-
lis.cut lvi Directsr
CiS . iaI ’. Ns Water flUX (UX)UX.UU
I _ — —
1T1—ieInieieIeIeIaI
• S —_—
—-—--- ‘ — —u
•
e a—— a •
. t_
• 0 0 s
• S C
•
U.S. I.vireiat.1 Prolection * SSICy
Ii I U 41 SI $
Cop. Gnat for State Ss ivia, F I
—
Water Water Psilution Costrel Us,slv$u
PsI 5$ Isieritad is iii . S i P t Icitlie d
tta attactad latesdud Use Plea sad P$ MI
IrP s 4i
$ — — •
State if Pew Water
— S
I
!iIiOi LAIIOI 1 PAL !
I• -—
• a a S
— =— — . s
a
1 1 10 5101
• .wQ - • sS’I
0 - u,S_
i,OO0.
•
I
S — a
—
•
a a
I
S S •I.
0 0”
J , ItI)
S • — — —
.____ __—__ ————.
511 1 1 tuiaitivs Dirietor
•
fl
SW1SSM
T icilSi: 5 7 1
C li 0 5*5 ? *PILIC*?I05 —
SIPLIC*?I05-UC-D l iui
I
C I I I
U?-TISC It-yw
:
asapo-ci
,13.PUVI05$ S vrs a i v ?U PDATi
u- Il—li
45

-------
SRF SOURCE DATA ELEMENTS
Exhibit 2.2.4
Page 2 of 12
I • IICI .S I I IC
11- ’CJSI UII-aISM CS7I0001.fl I uijiwi
Mau uvs-- I - r V I. i.... .. . ... . . ‘.
? ,._ sv ,•IsA? _u_*m I I IXIUIU
•LP*V T 1M
3. I. I
IS . I IC
City, Nst r (U

stat._ v
IiI.a.S i(Is ii IS I.S T
hA
I I I S leW 10*01 S•ICS• lee
I
uui zuuzuuu
I (PA, 1 1,ius JL
• strict
-
— __-___-- • 1 1 ,a fl .W a .. a . . ..wrW
i I 1*1 151* I us
-U-.- ——— — ——
eis*eie.r a U ..sa... * t*o . *e ,sm..0, us sv u • ues , 111,01 - -
I. v
Clue svt.r Act, as maisI
Till. Vi Iscel.. ($1.) CPU Part 3* i —
is -
05951 ale
Thu (tata if Use u Ssr Vats, Psiluti . . Cuitril Useslete, Peed eedsr Till. Vi if lii .
Cl Watar Pc I.
a..s s, •l*,le I Sl
tiq. 4...dI
Sri.,, fas• t ( P Ill
m.iLuj
tainh,u ..aiaeI ,sI
W iib lePW5AWISl59 U * S?* 5 ISSSV ICIIOS 111? 0SI*e le S0 PI .S3CW
* 1 * 1 5 0N I CYSle I llS 1
P 1
I
P. Sll
I
1. . .. ‘ W 1 14 WA
WA a lA WA
114 V t
S. liii. S.I N SA 4 5 14
543 Ill 144
,e.. .. ., ..4sesr .k 1 i c , 1 4 4
1 WA UI - WA
a 05 1, I 15* 5* Sl 5
I • I

....5
.S I 1* ll C ’ S S S II S C e . ..
swlsnI iu sn1
en? It2Iic : n?
SV 5 D&fl SITU UUSI UI?
517 I icU? V JC1*L DATA— PU—AP)
csxsm& cenLi em
nT -uQ5IuD
PIUDS-IIQUIUD
ensign
van
I
I
ann- F va ?ut
172: 551?
5T / 1
57 / 2
57 I 3
57 / 4
S. / 1
SI / 2
I. / 3
Is / 4
SI 9 1
SI / 2
SI / 3
mu :
1 71: flIt
113:PUV 174:flXI 1A2 :UnlU 1ri :OYmXDI
46

-------
SRF SOURCE DATA ELEMENTS
Exhibit 2.2.4
Page 3 of 12
PART II I. AWARD cDNDmoMs
Thi ptr ?ARU ____ B d i i i
P* ? i llnlfoim Mmin ve R4q . .ieeei for Oien end Coopeisthe Apecunena to Sieti end Lotol
PART 32 DmLen.ei* end S-qj’iuIou under EPA nr
Th Sc .nuibuXe ceenae of:
. c
I . Pruetone 1 ils VI E111 bL. -e
C. Prn ,L.. . ca Ov uiaccb (Binked)
°°°:
33 Ten1
I The gientos sgi to p.ymcnl liven EPA ( en 6 . .& . en the - .- of fundu .v l.tde li
dee Aoiotrd CIcW if en o (AOl)) ii ‘ ‘ . o b bieealtmena ii into ith the fofloo’fog
dw.ihile:
October 13. 1988
h ey!. 1919
A 23. 3989
July 10. 1989
October 3. 1989
— H. 1990
AM 23. 1990
July I. 1990
October 5, 1990
Jaimivy 8 , 1991
Aped 12, 1991
$2.0t2 .000
4.l73i OD
4,325,000
5.667.000
2,000000
l.l2 00O
666,000
0
0
0
0
Onto a pe)ineen ha, been made, EPA will not eedieee thee ACII ceIhth 1 .
OLOISFU 0 14U1V Ii
wee
ruunu-au,.PDID
N ITCI-CMi
010$ 012* DT1I uaawe 1102 0P0 102:
U2 CAP 051$? wnoui caTa— Pfl—InePD
011 02W. COI IATXVZ
rUiDi-U UIP1D
Dna—to’
- ‘ un
(I
57 I 1
S., I I
t37 / I
01 / I
00 I 1
i / 1
II I 3
ii / 4
SC I I
IS I 2
S. $ 3
Sri:
3 23: 1 0 1?
P 23: 2e v PV4:W ,11 PP.2:UflUI 2tI:OVIIPID I
uPa . to..ISa
47

-------
W-flacaL-Tw
mucaTx -p.sc-c
r
evimuici
Exhibit 2.2.4
Page4 of 12
flOT i:
i?AU-U—ZD 2
•p.
I )
u,ucA PON
Is ___
I s it
SRF SOURCE DATA ELEMENTS
QWilUI — — 1 S! D&U U T .i.w
u i c13 uuuu . u. mn URUQTZ
UP
iSSI UN,
Sk1RJS • —

I c i nnnt-
—t—-
frr flut. hf h Lu . _ ti1 Pr.dI
iuuIricti,Ø Grpnts Dir. ilioft
.
Ssi
Cai ety 1 New Nitir *3*1*
-
-
£iuewtive DIrIUsr
(w)u Iuu
‘.
a
£
S S —
C £
S
‘
p •__ • _ -_
• •
•ogfl Io I loI el unTo]
a — a
0 0
iu S C
.
a
U.3. (nv1. .uI Prot.ctIu Aquc)r
IL I . I1 I I
CLP. irut or sut. *.v.vi.
I Vitir Psilitisu Coutrol Ns,i1,lj
PiM U dsscrlbsl ii tMi .9 llcSilsi UI
iNs ettiched IUIIM.d lies P1•. UI P 1
k Ns I.
— .
Stat, of New Viler
-

3101101 I ALL ALL
•
—
UPs
I a .
0101101
a- _______
s u Q .s -=as. sup
Q -
S
-
e a
-
S — a
S a
p
. SIaa1a
o au
•L_ a.Iat
S Ia
a a. a—•i--ia. u
— Ps’ -_a. L J_ ___
. o——-__—_
1*11313 J Easaitivu 01r.ctar J ’
flu
CVUUT ua ic
(tU TUI
v. . u s i a
ars • niv
—
U. • W.Th a-i
v* . upruup
• SPOIl!
48

-------
Exhibit 2.4
SRF SOURCE DATA ELEMENTS
Page 5 of 12
- FN.— .1 - I.SSOSI
J IT& N s.aI usT.. .a 7
I
s4 o oC .0 O
CSfl000I-4
OS
1010111
L
So’s W 0
1 31011
• loll
1111 111
lL1V .
-i l .3 P& UWNU1O
— — I I --—---
r __ ____ ___
IITII1I
- - r- — J a i
3 UI NI
tiNe lI1&lr S.psr s of is.i,s.. Pretac.
P.O. .z U
Cltj, xVotarWU
T; ———-- —————-iw———N:INelsT——•
ftsswi
II OOS ISIOOIIOSS OS
UN It flUkZUU
liac.i vo Olr.t$N
S PS U
Ulter Ester ,si iit C Isslss,
P .O. I So U
Clt ,,NtqWrnr IU
.3

II. I.TOST IOSFI L_ O S4 •
Nil
. N US. ItI4
EPA I*4IC g_
CItE. s. t tir
IS s aT*iS 00 5*50 SOS
I O U 100 10 110
.: l_ .JL
- 555%. N L& I S IS IL tt rt - (1 1L.,II,I,II.
- t*z.0igt . .W ” - ila n.mt.im I alt 1 r
SVSIEUSV 1I5r N. 5j .TOSP SO7 5V 00005 • JöST00 I UI VC_.

ties. Wster Ml, .3 M.d v — u
Title TB *40 Mcli i. 1011 .) 40 CFR Pin 31
fr —
—a-- -
a ..sav v,t ozarvio
Ths hue c2 Isc, Ester Vster Polletiss Ceotnol Isvslviaç fund under Tills V I if its
Close usvvl Mt.
N. 5 5 5* 11 5SOT 55 S. UIW.
I — -
St atiwI N e 1 *11
I L ll*55U t SS p u s a na so. e.saj(.i..us N. 5 5 5T . 50
ups. rn .. r. n fir Ill - lftrnIJM..a1 _IOI_1QI
I V. $5 15u10 .0 51 15 iN. leTsi SNIST vials sssv •.V 5* 555*1? peass 6051
•U
N.00 5 O S.a .v . a.
4a 0 . s .
N. -—-: ‘ “
55555 £5505 155 OCflOu O1N350 f5Ts
. 44 044
. 44 I 01 0 11
1 4
N. 5 v ..55
044 “4 0 14
44 0 44
*I-uc v- {M. .2) 4 4 -O0O. 044
.43 I 0 41 511
5? 550r..4Q,qr asLth) tIP I i . .
N. 05555 also eso I
EFT! : ’
S C 555
r
-4.
49
I — , - - — —-— ., — — —— —--r—---—
-- - - - i,,.S..aSV.55
I I 1 EsvGri,ut
szai ui q!1ONPfl SICS oafl
PUt lelUt : PU SAP CAP CUPS
INN:
SIl O S —A I IAUW
aicicui
N.fCA-AIi?-fll
Nl —UQUZUD
VVN $-UQUZUD
cvlW Scl
iPIl ?1: Si I 1
sal/CU I? / I
US E lI
PIOUS 171*
IS / I
S. ,
S. I 3
Is / S
SI / I
I I / I
so / 3
lAST SIDITli
MT* SU fl
CPUI*flfl
laJ.D—CS/DAfl .
CAP lOll?!
aN.PD-cl/DITI:
3 512: input &asLstaals
__________ I
__________ I
___________ I
_________ I
__________ 1
__________ I
Ifl BID 3 12: 510 ff3311? U I :U PU:IEVPIU prS:OVUhZCZ

-------
PART UI. AWARD COIDrTIONS
SRE SOURCE DATA ELEMENTS
Exhibit 2.2.4
Page 6 of 12
lb I c*p AR11 of Si*h . 3 to ihli
PART 31 lJaIforrn AdrnInI rnivs Requlorrncxoi (or Oiuu. aiul Cooperrni s Agw to Stae .n4 Local
PAST 32 ‘Debrnrn t and Su nsian uial EPA P08zw . ’
1 $ tS Cosilbidoa cansiw., of:
A. ca*
8. ow ThIc V I EI1g*’ A ,sir f
C. Ptev rn ca Ovutniicb (Dv*ad)
s4 1
3 ITcnd
I. Th canto . ap to • psymsoc born EPA (as to die amount of (with avaalsblo b
die A i mated ClemWg Ho. s (AQI)) ‘ quietedy mo1bnanto In arnoI nce with die mollowi
scl i edide
Ocwbor Ii. 1988
1 i 5. 1989
A1 23, 1989
July 10. 1989
bcr 3, 1989
hmwiy 11. 1990
ApdZ 23. 1990
July I. 1990
toberI , 1990
Jamany 8. 1991
Apsil 12. 1991
$2D42,000
4.17 1.000
4 325 . 000
Th67 . 0O0
2.000.000
l. 12SiXX I
666.000
0
0
0
0
OLOLSU1 O’ 1 orun LU? VPDU?;
UU? SCuD : — .a cu MV I l U D&3k— PU—
ORZOIUL CwWLUIVI
PVID$—kI SUD3D
U?cI-Ce*I
OVE w i LIC .
P13:PUV Pr4: m
cr 1: UILP
__________ I
(Inca a poynicat has hoes rnsle. EPA will not ,edi c that AOl coiling.
(I
Cu ocu ?l
UAPD-cD/DAu:
97 / 1
•7 1 2
•7 / 2
57 F a
S. I I
U / 2
IS I I
I I F I
I , I I
•5 / 3
S. I S
uASDsD
TIRUPDUI
Pr2:IU!
crt2 Input ka.Latsao.
p12:lUUfl PTI:OVD*1tS
5p . ....sr
soul

-------
SRF SOURCE DMTA ELEMENTS
Project Priority List
o Project Number
o Permit Number
o AssIstance Recipient’s Name
and Address _______
o Project County Name
o Project Funding Status
o Assistance Recipient’s Congressional _______ ________________ _____________
District
o AuthoritylFacliity No.
o Multiple Facilities Code
o State Project Priority List _____
o Indian Pd ____
GPU SPRI GPNASPRI
GICS DATA ENTRY SYSTEM
SRF PROJECT INFORMATION
PERMIT P _________
MULTI-FACILITIES
IND!M-CODE
EQUIVALENCY : —
stxr SCI L N; SPA
PROGRAM
PRIORITY-PT : —
FUNDING-STA1US
FIRST—USE-CODE —
NAME _________
STRUT ________
STATE
CONG—DISTR!CTS —
LAST UPDATE;
Fiscal Year
PROJECT-ID ___________
FACILITY _________
INTENDED-USE—PLAN—FT
AIINUAL-RPT-DA1E —
REGIOtI
____________________ CITY _________________
ZIP : _________ COUNTY ________________
(Ent.r ALL’ or us. fi.lds bsiow for district nuith.r.I
PROJE -ThET g, siis iN F fP1T TiiTiWEii— tr — —
BINDING-DATE—TARGET
BINDING-DATE-ACTUAL
wWT-S TART-CD
PERPORMAMCE-cD
Pri • HELP
PFI — MAIN MENU
PIN • MINT SCREEN
P11 — PRIV MENU
BIND !NC-AMT-TAJtGET ___________
BINDING-AMY—ACTUAL ____________
LNZTI AT!-OflPATIOI I-CO: — _____
cINTU, — UPDATE
PA2 •
SCREEN
51

-------
SRF SOURCE DATA ELEMENTS
Intended Use Plan
o State FY Date
o Project Number
o Permit Number
o Assistance Reciplen?s Name,
Address. Congressional District
o Project County Name _____ _______
o Program Code
o Authority/Facility No.
o Multiple Facilities Code
o IUP Fiscal Year _____ _________
o Loan Interest Rate
o BindIng Commitment
Targeted Amount ____
Targeted Date ____
o Indian Id
o National Municipal Policy: First Use
Projects
o WWT Eligble Cost Categories
o Assistance Types
o Initiation of Operation
The IUP Is the first source document with IdsntIf lng and
financial data elements for all 319 and 320 proJects.
GPU3SPRL GPNA$PR1
NEXT SCREEII: SPA
01CC DATA ERTEY SYSTEM
SR i PROJECT INFORMATION
PROGRAM
PRIORITY—VT : —
FUNDING-S TAVJS7
FIRST-USE-CODE
lAST UPDATE:
PERMIT P ________
ISILTI—FACILITEES
1 10KM-CODE : —
EQUIVALENCY : —
STREET
PROJECT—ID ___________
FACILITY ________
IN TE I ID ED-US E—PLA N— VY
ANNUAJe RPTDAfl ______
__________________ CITY: __________
STATE : ZIP: ______ COUNTY: _________
CONG—O!STRTCTE. — 4Eiit.r ‘ALL’ or uss I L.Id. bs ow for dt.trtct nt srs)
o -fM rKsThrA I Ei-Thr : T -L TiT — — -‘
REGION
RINDING-DATE-TAIGIT
RINDINC-DATE-ACTUAL i
WI-START-CO
PEUOPMANCE-CD
PF1 • 145L1
• 14111 emo
PU • NEXT SCREEN
P13 • P1EV MENU
IN ITI ATE-OPERAT IOU-CDt — _____
(CITU — UPDA?U
r •
SCREEN
52

-------
SRF SOURCE DATA ELEMENTS Exhibit 2.2.4
Page 9 of 12
Annual Report
o State FY Date
o Project Number
o Annual Report Date
o Loan Interest Rate
o BindIng Commitment ______ _________
Actual Amount
ACtual Date
o WWT Eligible Cost Categories ____
o National Municipal Policy: First Use
Projects
o Identify Title II Equivalency Projects ____
o Affirmative Project Performance ____ ________
Certification
o Construction Start Date ____
o Assistance Typos
o Initiation of Operation
GPU3SPRI GPNASPRL
NEXT SCREEN: SPA
GICS DATA ENTRY !YS1
SRT PROJECT INFOP$ATIOIS
PROGRAM
PRIORITY-FT
FUNDING—STATUS
FIRST—USE-CODE : —
LAST UPDATE:
PERMIT : P _________
HUL?I—FACILITIES
INDIAN—CODE
EQUIVALENCY —
NAI _____
STRUT _____
STATE
CONG—OISTPICTS: —
PROJECT-ED ___________
FACILITY _________
INTENDED-USE—PLAN—FT
?JINUAL-RPTOATE : —
__________________ CITY _______________
ZIP: ______ tOUNTY: __________
(Ent.r NLL or us. heidi btiow for dL.trict nu .b.rsI
REGION
BXNDIWG—DATE—?ARGET
B INDI1IG-DAT E&CTO AL
WIPT—START-CO
PERFORMANCE-CO
PROJECT—TYPE: — — SR?—ASSISTA NCE-1TPEi — — — INTEREST-RATE: _____ I
rn • HELP
— IN P ISU
RIND INC-Al IT-TARGET ___________
BINDING-ANT—ACTUAL __________
VFi — NEAT i I(LEJI
PF3 — PREV MENU
IHITI&fl-OflRAUON-CD;
INTEN) — UPDATE
PA2 — REFRESH
SCREEN
53

-------
Exhibit 2.2.4
SRF SOURCE DATA ELEMENTS Page 10 of 12
Project Priority List
o Project Number
o Permit Number ______
o Assistance Recipient’s Name _____
and Address ________ ________
o Project County Name ____
o Project Funding Status _________
o AssIstance Recipient’s Congressional
District _________
o Authority/Facility No. _________
o Multiple Facilities Code
o State Project Priority List ________
o Indian Id
GPU3SPA1 GPNASPA1
NEXT SCREEN: HEN
GICS DATA ENTRY SYSTEM
SRI Coatlkaststanc. Typ..
NAla :
ST: —
PROJECT—ID:
N W?
COST
CATEGORIES
ITTPE-212)
LAST UPDATE:
Fiscal Year
• BINDING CO)IIITMENT _______
BINDING-DATE—TARGET: ______
IIND INC-OAT E-AC?UAL : _____
BIND II IG-AIPT-ACTUAL __________
CAT-I ___________
CAT—fl ___________
CAT—lI lA ___________
CAT-IllS ___________
CAT-I VA ___________
CAT-IVI ___________
CAT-V ___________
STORM-SEWER-COST __________
TOTAL WIlT ————————— 1212): _____________
ESTUARY-COST (320): ___________
NON—POIN?-SOORCE—cOST (319) ___________
as. —a.... £fl I £ ra
LOANS
REFINANCING
INSURANCE
GUARANTEES : —
(ENTER X IN ALL TYPES THAT APPLY
rn
—
PU
— NEXT
SCREEN
PAZ — REFRESH
iFS • MAIN I U
UI • PREY
HERD CUTER) •
UPDATE SCREEN
54

-------
SRF SOURCE DATA ELEMENTS
Exhibit 2.2.4
Page 11 of 12
Annual Report
o State FY Date
o Project Number
o Annual Report Date
o Loan Interest Rate
o Binding Commitment
Actual Amount
Actual Date
o WWT Eligible Cost Categories
o National Municipal Policy: First Use
Projects
o Identify Title II Equivalency Projects
o Affirmative Project Performance
Certification
o Construction Start Date
o Assistance Types
o Initiation of Operation
NAME:
5?:
PROJECT—ID:
N W?
COST
CATEGORIES
TYPE—212I
GPU3SPA1 GPMASPAI
NEXT SCREENs HEN
GICS DATA ENTRY SYSTEM
SB? Co.tlA.ststaaic. Typ..
LAS? UPDATE:
______ BINDING COAMITMENT —
BINDING-DATE-TARGET: ______
BINDING-AMY—TARGET ____________
CAT-I
CAT—I!
CAT-lilA
CAT—IllS
CAT-IVA
CAT- IVE
CAT-V
BINDING-DATE-ACTUAL: ______
BINDING-AMY-ACTUAL ____________
STOAM-SEW ER-COST ____________
TOTAL NW? ————————‘ (2l2 : ____________
ESTUARY—COST 13201: __________
Imu—POINr-SOURCE—COST 13191: ____________
Jul —na... SflhIt I. rE
LOANS : —
REFINANCING : —
INSURANCE : —
GUARANTEES
P11 — H&LV
Pr4 • MAIN MENU
lINTEl N IN ALL TYPES THAT APPLY
— NIAT 5CREIN
P13 - PRZV MENU
EUTER) • UPDATE
VA4 — RXFKIIX
Scull’
55

-------
Exhibit 2.2.4
SRF SOURCE DATA ELEMENTS Page 12 of 12
Intended Use Plan
o StateFYDate
o Project Number
o Permit Number . GPU3SNUt GPMASMU1 GICS DATA EIITMY SYSTEM LAST UPDATE:
o Assistance Recipient’s Name, NEXT SCREEN: MEN 5 5 ? PROJECT MULTIPLES ______________________
Address, Congressional District
o Project County Name
o Program Code PERXITS p ______ p ______ P ______ P ______ P ______
p ____ p ____ p _____ p ____ p ____
o AuthorIty/Facility No.
o MultIple Facilities Code
o IUP Fiscal Year
o Loan Interest Rate FACILITIES:
o BindIng Commitment
Targeted Amount
Targeted Date
o indian Id ______________________________________________
o NatIonal Municipal Policy: First Use Pr’ - - PREy MuU
m • 4 555 555W (SITES) • UPDATE
Projects
o WWT Eligible Cost Categories
o AssIstance Types
o InitIation of Operation
The IUP Is the first source document with idendfying and
financial data elements for all 319 and 320 projects.
56

-------
SRF GICS instruction Manual
ExhIbit 2.2.5 Data Element List by GICS Screen
This matrix lists by screen, each data element found on the screen.
In most instances, the screen data fields are either input or output
fields, depending upon whether the grant or project is targeted or
awarded. The Award Code on the data screens indicates whether the
grant or project is targeted (T) or awarded (A). When periorming data
entry during the targeted phase, data entry is allowed in certain fields;
once the award has been made and entered into the data base, the data is
displayed in certain fields. Display-only screen data fields are indicated
in the Comments section of this matrix.
The matrix includes the following information:
o Menu/Screen Name - the name of the menu or screen
o Data Element Name - the name of the data element found on the
screen
o Source Document - indicates which source documents provide
the data to be entered on this screen for Input-only data
elements. The numbers in the Application and
Award/Amendments column indicate the actual box on the form
that provides the data.
o Comments - specifies additional information related to
the screen data field
The SRF GICS project screens (SRF Priority List/Application and SRF
Cost/Assistance Types) indicate that data is entered from the Project
Priority List (PPL), Intended Use Plan (IUP) and Annual Report.
SRF project data is generally first entered from the PPL. The 319 and
320 projects are not included on the PPL, therefore, the identifying and
financial data related to these projects must be entered from the IUP and
the Annual Report.
57

-------
DATA ELEMENT LIST BY GICS SCREEN - GRANT/PROJECT INFORMATION
.
EXHIBIT 22.5
SOURCE
DOOJMBflS
MENU!
___
SCREEN
DATA ELEMENT
AWARD!
ANNUAL
NAME
(As Appears on Screen)
APPLICATION
AMEM)MENTS
PPL
IUP
REPORT
OTHEF
COMMEPifIS
MAIN MENU
GRANT-NO
4 (GN)
1 (GN)
RI
R i
RI
Grant Number = GN
- SERIAL NUMBER
4 (GN)
1 (GN)
RI
R I
RI
Prolect Number = PH
- SEQUENCE NUMBER
4 (GN)
1 (GN)
RI
RI
RI
-AMENDMENT DESIGNATOR
4 (GN)
I (Gil)
RI
RI
RI
RECO1 TYPE
8 (GN)
7 (GN)
—
*
Must enter identifying information on Main Menu
to access all data entry screens
._______
0I

-------
(1)
-n
C)
C,)
5.
0)
C
a
0
C
DATA ELEMEPqIr LIST BY GICS SCREEN - Gc ANTIPROJEcr INFORMATtON
(J1
CD
EXHIBIT_2.2.5
.
DOcUM
MENU1
SCREEN
DATA ELEMENT
AWARD!
ANNUAL
NAME
(As Appears on Screen)
APPUCATION
AMENDMENTS
PPL
IUP
REPORT
OTHER
COMMENTS
SRF CAP
NUPvEER
Display Only
GRANT
PRD( AM
System Generated
APPUCATION
AUTHORFTV
Display Only
STATE-AP-ID
3
NA?vE
5
N
System Generated
STREET
5
CWY
5
STATE
System Generated
ZIP
5
SAF-FISCAL-VEAR
System Generated
APPL-REC-DATE
4
AWARD-CD
3
FUNDS-AWARDED
Display Only
CUM -A WARD
Display Only —

-------
SO( cE
DO UMEN
S
MENU!
SCREEN
NAME
DATA ELEMENT
(As Appears on Screen)
APPLICATION
AWARD!
AMENDMENTS
PPL
IUP
ANNUAL
REPORT
OTIEFi
COMMENTS
RF CAP
3RANT
FINANCIAL
1FORMATION
GIANT NUhEER
NAIvE
AWARD-CDIDATE
AWAE1DEDNvENDIvENIS
Display Only
Display Only
Display Only
System Calculated
PRE-AWARD)
ORIGINAL AWARD
Display Only
- FUNDS-AWARDED
30
.___________
- MATCH-CASH
35A
- MATCH-ASST-BANKED
35B
- MATCH-CASH-BANKED
35C
- MATCH-REQUIRED
______
System Calculated
• FUNDS-REQUIRED
System Calculated
-OVERMATCH
37
PAYMENT
- YEARIQTR
System Generated
• DATE
x
- AMOUNT
x
CUMULATIVES
- FUNDS-AWARDED
System Calculated
- MATCH-CASH
System Calculated
- MATCH-ASST-BANKED
System: Calculated
- MATCH-CASH-BANKED
System Calculated
- MATCH-REQUIRED
System Calculated
- FUNDS-REQUIRED
System Calculated
-OVERMATCH
System Calculated
PAYMENT
- AMOUNT
System Calculated
DATA ELEMENT LIST BY GICS SCREEN - GRANTIPROJECT INFORMATION
EXHIBIT 2.2.5
0: ’
0
C,)
-n
C,
(I)
5.
cn
C
a
5.
0)
C
0)

-------
DATA ELEMENT LIST BY GICS SCREEN - GRANIIPROJECT INFORMATION
•
EXHIBIT 2.2.5
SO(RlcE
O UMENI
$
•
MENU!
SCREBI
DATA ELEMENT
AWARD!
ANNUAL
NAME
(As Appears on Screen)
APPLICATION
AMEM)MENTS
PPL
IUP
REPORT
OTHER
COMMEN1S
SRF CAP
ANF NUMEER
____________
Display Only
Display Only
FINANCIAL
AWARD-CD/DATE
Display Only
INFORMATION
AWARDED NvENDI,EN1S
System Calculated
POST-AWARD)
ORIGINAL AWARD
Display Only
• FUNDS-AWARDED
Display Only
- MATCH-CASH
Display Only
- MATCH-ASST-BANKED
Display Only
- MATCH-CASH-BANKED
Display Only
- MATCH-REQUIRED
System Calculated
- FUNDS-REQUIRED
System Calculated
____________
- OVERMATCH
Display Only
PAYMENT
Display_Only
.
.
System Generated
- DATE
Display Only
[ ____________
- AMOUNT
Display Only
CUMULATIVES
I
- FUNDS-AWARDED
System Calculated
- MATCH-CASH
System• Calculated
- MATCH-ASST-BANKED
- MATCH-CASH-BANKED
- MATCH-REQUIRED
System Calculated
.
System Calculated
System Calculated
- FUNDS-REQUIRED
-OVERMATCH
PAYbENT
System Calculated
System Calculated
-AMOUNT
_____
System Calculated
0 )

-------
(1)
.n..
G)
C,,
-‘
C
0
p)
C
0)
DATA ELEMENT LIST BY GICS SCREEN - GRANT/PROJECT INFORMATION
0 )
‘U
EXHIBIT_2.2.5
- -
an
..
DATA ELEMENT
AWARD!
ANNUAL
(Ai Appeara on Screen)
APPUCATION
AMENDMENTS
PPL
IUP
REPORT
OTHEF
CDMM9ITS
TNU?I4UB
Display Only
tW
Display Only
STATE
Display Only
REC DN
Display Only
(A) FFISCAU YEAR
_______
System Generated
STATE-AP-ID
3
APPL-REC -DATE
4
AWARD-CD
3
CURRENTPR)JECT(IARGETED)
- FUNDS AWARDED
Display Only
- MATCH-CASH
Display Only
- MATCH-ASST-BANKED
Display Only
- MATCH-CASH-BANKED
Display Only
- MATCH-REQUIRED
Display Only
-OVERMATCH
Display Only
NDMENT (CHANGE)
- FUNDS AWARDED
Display Only
Display Only
- MATCH-CASH
Display Only
- MATCH-ASST-BANKED
Display Only
- MATCH-CASH-BANKED
Display Only
- MATCH-REQUIRED
- OVERMATCH
Display Only
Display Only

-------
DATA ELEMENT LIST BY GICS SCREEN - GRANT/PROJECT INFORMATION
0 )
MENU!
SCR N
NAME
DATA ELEMENT
(As ADDears on Screen)
DO UMEt
APPLICATION
S
AWARD!
AIWJr I tIT
U
ppL
ANNUAL
‘UP
REPORT
OTHER
cOMME S
EXHIBIT 2.2.5
SRF CAP
G APffNUI UER
Display Only
GRANT
NAME
Display Only
AMENDMENT
STATE
Display Only
APPLICATION
ON
Display Only
(8)
RF-FISCAL-YEAR
System Generated
TATE-AP-ID
3
APPL-REC-DATE
4
AWARD-CD
3
CURRENT PROJECT (AWARDED CtJMS)
- FUNDS AWARDED
Display Only
- MATCH-CASH
Display Only
- MATCH-ASST-BANKED
Display Only
- MATCH-CASH-BANKED
Display Only
- MATCH-REQUIRED
Display Only
- OVERMATCH
Display Only
AMENDMENT (CHANGE)
Display Only
- FUNDS AWARDED
__________
Display Only
- MATCH-CASH
Display Only
- MATCH-ASST-BANKED
Display Only
- MATCH-CASH-BANKED
Display Only
- MATCH-REQUIRED
Display Only
- OVERMATCH
Display Only

-------
C)
DATA ELEMENT LIST BY GICS SCREEN - GRANT/PROJECT INFORMATION
M NU
a.————
I MM
IJM I 1% ELtiutM I
(As Aooeer, on Screen)
—— —
‘wJMtrl
AI’PLICATION
RWA KU!
AMEMIMENIS
PPL
NINUAL
‘UP
—na—
h rvii I
“Int’l
a——a——a—
wviivuw i
-------.
————-
—-
—.
—.
SRF CAP
uw i r1Li1v EI
Display Only
GRANI
AWARD-CD/DATE
3
MENI3MEN1
CAP-GRANT/AWARD-CD/DATE
Generated
fINANCIAL
MWNCEDNVENDIWEPUS
System
NFORMAT 1ON
System
(PRE-AWARD)
MMENDMENT( HANGEj
- FUNDS-AWARDED
30
- MATCH-CASH
35A
- MATCH-ASST-BANKED
35B
- MATCH-CASH-BANKED
35C
- MATCH-REQUIRED
Calculated
- FUNDS-REQUIRED
System
-OVERMATCH
37
System Calculated
PAY!vENF
- YEARIQTR
- DATE
x
System Generated
-AMOUNT
“
NEW CUMULATIVES
.
- FUNDS-AWARDED
- MATCH-CASH
System Calculated
- MATCH-ASST-BANKED
System Calculated
- MATCH-CASH-BANKED
System Calculated
- MATCH-REQUIRED
System Calculated
- FUNDS-REQUIRED
System Calculated
- OVERMATCH
System Calculated
PAYMENT
- AMOUNT
System Calculated

-------
DATA ELEMENT LIST BY GICS SCREEN - GRANT/PROJECT INFORMATION
0 )
U I
SOURCE
000JMENIS
•.
MENU!
ANNUAL
SCREEN
DATA ELEMENT
AWARD!
REPORT
OTHER
COMMENTS
NAME
(As Appears on Screen)
APPLICATION
AMENDMENTS
PPL
SRF CAP
Display Only
GRANT
GRANT N1JIVEER
Display Only
ØMENDMENI
AWARD-CD/DATE
System Generated
FINANCIAL
CAP-GRANT/AWARD-CD/DATE
System Calculated
NFORMAT1ON
AWN DEDN NDtvENTS
Display Only
POST-AWARD)
NNvE
AIvENDP6ENT (CHANGE TO AWARD
- FUNDS-AWARDED
Display Only
Display Only
- MATCH-CASH
- MATCH-ASST-BANKED
Display Only
Display Only
- MATCH-CASH-BANKED
— —
System Calculated
- MATCH-REQUIRED
System Calculated
- FUNDS-REQUIRED
Display Only
-OVERMATCH
PAThENT
Generated
- YEARFQTR
- DATE
- AMOUNT
I’IEW CUMJLA11VES
System
Display Only
Display Only
- FUNDS AWARDED
- MATCH-CASH
System
System Calculated
Calculated
- MATCH-ASST-BANKED
Calculated
•___________
- MATCH-CASH-BANKED
- MATCH-REQUIRED
- FUNDS-REQUIRED
- OVERMATCH
PAY? ENT
System
System Calculated
System Calculated
System Calculated
- AMOUNT
System Calculated

-------
0)
0)
MENU!
SCR
DATA ELEMENT LIST BY GICS SCREEN - GRANT/PROJECT INFORMATION
NAME
DATA ELEMENT
(As ADD0SrS on Screen)
SC
DOc UMEN1
APPLICATION
S
AWARD!
AIW I Irr
r.u.w.fl. U —
PPL
ANNUAL
‘Up
RF R1
uiI
COMMENIS
(1)
11• .
C,
(1)
5.
(I)
C
a
0
0)
C
0)
EXHIBIT_2.2.5
SRF PROJECT
GRANT NUfVEER (PR)JECT NO)
INFORMATION
PRO( V M
Display Only
PERMIT
X
X
Display Only
PROJECT-ID
X
PRIORITY-FY
X
State Use Only
MULTI-FACILITIES
X
FACILITY
X
X
X
FUNDING-STATUS
X
IAN- cODE
X
X
, NTE ED-USE-PLAN-FY
x
FR 1-USE-CODE
X
X
A UAL-RPT-DATE
X
NMsE_________
X
X
I GlON
STF T
X
X
Display Only
CnY
x
x
S ATE
zP
X
X
Display Only
C(1R41V
X
X
CONG-DISTRICTS
X
X
PROJECT-TYPE
RF-ASSISTANCE-TYPE
Display Only
Display
— NIE ST-RATE
X
X
Only
G-DATE-TARGET
-___________ N -DATE-ACTUAL
Display Only
-AMT-TARGET
Only
-AMI-ACTUAL
Display Only
WW 1-START-CD
Display Only
pErFOFvvt NcE -cO
X
NITIATE-OPERATION-CD
x
x

-------
DATA ELEMENT UST BY GICS SCREEN - GRANTIPROJECT INFORMATION
EXHIBIT 2.2.5
COMME B
SRF COST!
GRANT NUMBER (PROJECT NO)
Display Only
ASSISTANCE
NDING-DATE-TARGET
x
TYPES
NDING-AMT-TARGET
x
NDING-DATE -ACTUAL
x
.___________
NDING-AMT-ACTUAL
NAIvE
Display Only
ST
System Generated
PROJECT-ID
Display Only
WWTCOSTCATEGORES
(TYPE = 212):
x
x
-CAT-I
x
I.

- CAT-Il
x
x
- CAT-lIlA
x
x
- CAT-lllB
x
x
_____________
- CAT-IVA
x
x
.___________
- CAT-IVB
x
x
- CAT-V
x
x
- STORM-SEWER-COST
x
x
- TOTAL WWT > (212)
System. Calculated
ESTUARY-COST (320)
x
x
NON-POINT-SOURCE-COST (319)
x
x
SRF-ASSISTANCE-TYPES:
- LOANS
x
x
.
- REFINANCING
x
x
- INSURANCE
x
x
-GUARANTEES
x
x
PROJECT-TYPE
Display_Only
Il ’lIui
NAME
(As Abosars on Scmen
SOURCE DOCUMENTS
APPLICATION
DATA ELEMENT AWARD! ANNUAL
AIWIIT I ITQ
PpL
IUP
REPORT OTHER

-------
DATA ELEMENT UST BY GICS SCREEN - GRANT/PROJECT INFORMATION
EXHIBIT 2.2.5
MM B
C)
C)
MENU!
SC EM
NAME
DATA ELEMENT
(As Appears on Screen)
- -
r iri a wi
APPLICATION
AWARD!
u urPaT
PPL
ANNUAL
‘UP
REPORT
O1HEFI
SRF PROJECT
PROJECT-ID
X
MULTIPLES
PERMITS: P
X
(10 BLANK FIELDS TO ENTER
MULTIPLES IN)
FACILITIES:
x
(10 BLANK FIELDS TO ENTER
MULTIPLES IN)

-------
SRF GICS Instruction Manual
SECTION 3.0 SRF GICS NATIONAL REPORTS
Introduction The SRF data entered into GICS is. stored in the GICS
database and is available for subsequent report
generation. SRF National report formats have been
created to provide detailed and summarized information
on capitalization grants and SRF projects. SRF Priority
List information is included in the Construction Grants
National Priority List Reports. Both Construction
Grants and SRF Priority List information is included in
the reports.
Contents of This section identifies EPA’s SRF National information
This Section needs and describes each of the SRF reports. The SRF
Report formats are included with suggestions on how to
use the reports. Section 3 is organized as shown:
For Information On:
See Section:
See Exhibit:
The EPA’ s SRF
3.1
EPA’s SRF
3.1.1
EPA’s SRF
Information Needs
National
Information
Needs
National Reporting
Requirements
The SRF GICS
3.2
SRF GIGS
3.2.1
SRF GIGS National
National Reports
National
Reports
Report Summary
The SRF GICS National
Report Select Logic
Criteria and Data
Elements
3.2
SRFGICS
National
Reports
3.2.2
•
SRF GIGS National
Report Select Logic
Criteria
The SRF GIGS National
Reports and their Uses
3.2
SRFGICS
National
3.2.3
SRF GICS National
Reports
- ----- --
Reports

69

-------
SRF GICS Instruction Manual
3.1 EPA’S SRF National Information Needs
This section identifies the EPA’s SRF National information needs.
The SRF National Information Needs section is designed to identify:
o The EPA’s SRF National information needs
o How GICS meets these needs through reports
70

-------
SRF GICS Instruction Manual
3.1.1 Environmental Protection Agency’s
SRF National Reporting Requirements
Title VI of the Clean Water Act (CWA) authorizes the EPA to make
capitalization grants to States for establishing State Water Pollution
Control Revolving Funds (SRFs). EPA does not have a role in
administering the SRF funds at the project level, therefore, a minimal
amount of grant and project data is required to be tracked at the Federal
level. However 1 it is EPA’s role to:
o Manage its SRF Capitalization Grant Program,
o Provide a Basis for its Required Outlay Projections, and
o Meet its Responsibilities for Congressional and National
reporting.
The purpose of providing standard report formats is to assist the
EPA in meeting these requirements on the Regional and National levels.
This exhibit summarizes the SRF National reporting requirements,
describing the type of information needed by the EPA Headquarters and
Regional Offices, and the related SRF GICS reports that provide th
information.
71

-------
ENVIRONMENTAL PROTECTION AGENCY’S
SRF NATIONAL REPORTING REQUIREMENTS
Information
Need
Reporting Level
Specific Information Need:
Related
SRF GICS Reports
Manage SRF
EPA
Headquarters
o
Track Progress of SRF program
National SRF
Capitalization
from a National perspective
Capitalization
Grant Program
Grant Summary
o
o
Provide aggregate level information
to identify patterns and trends or to
make comparisons among regions or
States which will serve to guide
program judgments
Assist in developing grants
management policy
National Project
Summary to Date
National Assistance
Type Summary to
Date
0
Provide information to serve as a basis
for developing or modifying policies
.
in SRF program
Exhibit 3.1.1
Page 1 of 4
(1)
11
G)
C / )
C
0
0)
C
0)

-------
C l)
11
G)
0
(I)
(I)
C
a
0
C
ENVIRONMENTAL PROTECTION AGENCY’S
SRF NATIONAL REPORTING REQUIREMENTS
ExhIbit 3.1.1
Page 2 of 4
C,)
Information
N d
Reporting Level
Specific Information Need:
Related
GICS SRF Reports
Manage SRF
Capitalization
Grant Program
EPA
EPA
Headquarters
Regional Offices
0
0
0
o
AssIst in the grant, application
review process
Provide Project Priority List
Information
Assist In grant negotiation
process between States and Region
Provide information to facilitate
the grant agreement process
SRF Capitalization
Grant Summary for
Regions
Annual Report Status
of Binding
Commitments
Project Level
Milestones for 212
Projects
0
0
Provide Information on the
Implementation of the State’s
SRF programs to assist In the
Annual Review
Provide aggregate level
information to identify patterns
and trends or make comparisons
among States which will serve
to guide program judgements
Regional Project
Summary to Date
State Project
Summary to Date
.
Regional Assistance
Type Summary to Date
Detailed Grant Data
Detailed Project
Data
SRF Project Records Cost
Categories

-------
ENVIRONMENTAL PROTECTION AGENCY’S
Exhibit 3.1.1
SRF NATIONAL REPORTiNG REQUIREMENTS page3of4
Information
N d
Re
porting Level
Specific Information Need:
Related
GICS SRF Reports
Provide
EPA
Headquarters
o
Assist
in
estimating
outlays
Annual Report
Status
Basis for
EPA
Regional Offices
of Binding
the EPA’s
Commitments
Required
Outlay
Projections

-------
(1)
:i
‘1
C)
C)
C l)
(I)
C
0
C
ENVIRONMENTAL PROTECTION AGENCY’S
SRF NATIONAL REPORTING REQUIREMENTS
Information
Related
Need
Reporting Level
Specific
Information Need:
.
GICS SRF Reports
SRF Report
to Congress
Exhibit 3.1.1
Page 4 of 4
EPA Headquarters
o Assist in assessing the financial
status and operations of the
SRF program
o Provide information on the status of
the SRF implementation
o Provide information to support
the preparation of the
SRF Program Report to
Congress
National SRF
Capitalization
Grant Summary
SRF Capitalization
Grant Summary
for Regions
National Project
Summary to Date

-------
SRF GICS Instruction Manual
3.2 SRF GICS National Reports
This section identifies the SRF National reporjs generated from
GICS. The SRF GICS National Reports Section is designed to familiarize
you with the:
o SRF GICS Report Select Logic Criteria
o SRF GICS standard report formats
o SRF GICS report data elements
o Uses of the SRF GIGS reports
76

-------
SRF GICS Instruction Manual
Exhibit 3.2.1 SRF GICS National Report Summary
This exhibit summarizes the SRF National reports generated from
GICS, including a description of the information provided.
77

-------
SRF GIGS Instruction Manual
SRF GICS NATIONAL REPORT SUMMARY Exhibit 3.2.1
REPORT DESCRIPTION
STATE REVOLVING FUND CAP identifies financial Infomalion for capitalization grant by
GRANT DETAIL REPORT (0600) State.
NATIONAL SRF CAPITALIZATION Lists, by Region, the number of States that have received at
GRANT SUMMARY (0601) least one capitalization grant, the cumulative EPA funds
awarded, and the components of the State match.
SRF CAPITALiZATION GP Pff Lists the capitalization grants that each State, within a
SUMMARY FOR REGION oc IN Region, has received over a specified time period, cumulative
FY XX (0602) EPA funds awarded, the components of the State match, and
the beginning/e. ’ding dates.
STATE REVOLVING FUND PROJECT Lists all National data element Information for projects
DETAIL REPORT (0610) funded by SRF
ANNUAL REPORT STATUS List of binding commitments for projects with payment
OF BINDING CO ENTS quarters one year ago or more from the award date. Report
(0611) will Indicate whether binding commitments have been made
for 120% of payments in the first year.
PROJECT LEVEL MILESTONES Lists the SRF projects per State, IdentifyIng the equivalency
FOR 212 PROJECTS (0612) projects, binding commitment actual date and amounts,
and other project information.
NATIONAL PROJECT SUMMARY TO Lists the number of projects and dollar amounts of projects
DATE FOR PROJECTS wmi for each project type by Region. The percentage of each
TARGETED OR ACTUAL BINDING project type is calculated.
COMMITMENTS (0613)
REGION XX SUMMARY TO DATE Lists the number of projects and dollar amounts of projects
FOR PROJECTS WIN ACTUAL OR for each project type by State within a Region. The
TARGETED BINDING percentage of each project type is calculated.
COMMITMENTS (0614)
STATE PROJECT SUMMARY TO Lists the number of projects and dollar amounts of projects
DATE FOR PROJECTS WITH ACTUAL for each project type by State. The percentage of each project
OR TARGETED BINDING type is calculated.
COMMITMENTS (0615)
NATIONAL ASSISTANCE TYPE Lists the number of projects for each assistance type and
SUMMARY TO DATE FOR PROJECTS the dollar amount, by Region, and calculates the percentage
WflH ACTUAL OR TARGETED of each assistance type.
BINDING COMMITMENTS (0616)
REGION XX ASSISTANCE TYPE Lists the number of projects for each assistance type and
SUMMARY TO DATE WITH ACTUAL the dollar amount, by State, and calculates the percentage
OR TARGETED BINDING (0617) of each assistance type.
SRF PROJECT RECORDSCOST Lists SRF projects with actual binding commitments by
CATEGORIES BINDING DATE- Grant Number, identifying the Interest rate and the dollar
ACTUAL FROM X)000CX THRU amounts disbursed, by cost category.
XXXXXX (0618 )
78

-------
SRF GIGS Instruction Manual
Exhibit 3.2.2 SRF GICS National Report Select Logic Criteria
This exhibit provides the SRF GICS Report Select Logic Criteria for the
SRF National reports. Select Logic Criteria is used in the development of a
report. The following information is identified for each report:
o Report Title - Formal report titles
o Report Number - Number of report
o Select Logic - The select criteria for the report; this identifies what
type of data records will be used to generate the report
o Sort By - Sorting sequence of the data records
o ADABAS Name - Identifies the data element name as defined in the SRF
GICS Data Element Dictionary
o Column Heading - Identifies the proposed column heading to be
displayed on the report
79

-------
SRF GIGS Instruction Manual
SRF GICS NATIONAL REPORT SELECT Exhibit 3.2.2
LOGIC CRITERIA Page 1 of 19
REPORT TifLE: STATE REVOLVING FUND CAP GRANT DETML REPORT
REPORT NUMBER: 0600
SELECT LOGIC: PROGRAM CS AND
CAP-GRANT NE BLANK
SORT BY: STATE
DISPLAY: ADABAS NAME: COLUMN HEADING
I REPORT NUPI6BER (AS PART OF HEADER)
2 REPORT DATE (AS PART OF HEADER)
3 GRANT-NO “GRANT NUMBER”
4 AUTHORITY “LEGIS AUTH”
5 SRF-FISCAL-YEAR “STATE Fr
APPLICANT INFORMATION:
6 NAME APPLICANT NAME”
7 STREET “APPLICANT STREET”
8 CflY “APPLICANT CITY”
9 STATE “APPLICANT STATE”
1 0 ZIP “APPLICANT ZIP CODE”
11 STATE-AP-ID “ST 1D”
1 2 ION “REGION
FINANCE:
1 3 CUM-A WARD “CUM-A WARD”
14 FUNDS-AWARDED “EPA AWARD”
15 MATCH-REQUIRED “MATCH REQ 20%
1 6 MATCH-CASH “MATCH-CASH
80

-------
SRF GICS Instruction Manual
F-
SRF GICS NATIONAL REPORT SELECT Exhibit 3.2.2
LOGIC CRITERIA Page 20119
REPORT TITLE STATE REVOLVING FUND CAP GRANT DE PJL REPORT
REPORT NUMBER: 0600
SELECT LOGIC: PROGRAM - CS AND
CAP-GRANT NE BLANK
SORT BY: STATE
DISPLAY: ADABAS NAME: COLUMN HEADING
17 MATCH-ASSIT-BANKED “MATCH ASST BK”
1 8 MATCH-CASH-BANKED “MATCH CASH BK”
19 a’IEI v1ATcH “ fERMATCH
20 FUNDS-REQUIRED “GRANT +20% MATCH”
21 APPLICATION-REC-DATE “APPL RECEIPT”
22 AWARD-CODE “GRANT AWARD”
AWARD-DATE
PAYMENT SCHEDULE:
23 PAVMENT-OTR “QUARTER”
24 PAYMENT “AMOUNT’
25 PAYMENT-DATE “DATE”
81

-------
SRF GIGS Instruction Manual
SRF GICS NATIONAL REPORT SELECT Exhibit 3.2.2..
LOGIC CRITERIA Page 3 of 19
REPORT TITLE: NXflONAL SRF CAPITALIZATION GRANT SUMMARY
REPORT NUMBER: 0601
SELECT LOGIC: PROGRAM ” ”CS AND
RECORD-TYPE - C OR N AND
AUThORITY-3S AND
AWARD-CODE - ‘A’ AND
CAP-GRANT NE BLANK
SORT BY: RB3ION
DISPLAY: ADABAS NAME: COLUMN HEADING
I REPORT NUMBER (AS PART OF HEADER)
2 REPORT DATE (AS PART OF HEADER)
3 AWARD-CODE A, “NUMBER OF STATES WHICH
(COUNTER) IECEFVED ONE OR MORE GRANTS”
4 GUM-AWARD “CUMULAlIVE EPA FUNDS AWARDED”
5 MATCH-CASH “CASH - CURRENT YEAR’
6 MATCH-ASSIT-BANKED “PREVIOUS TITLE VI ELIGiBLE
ASSISTANCE - (BANKED)”
3 MATCH-CASH-BANKED “PREVIOUS CASH OVERMATCH
(BANKED)”
8 MATCH-REQUIRED “20% STATE MATCH TOTAL”
9 OVEFVVIATCH “STATE OVERMATCH”
10 TOTAL BY COLUMN (TOTALS BY COLUMN)
82

-------
SRF GICS Instruction Manual
SRF GICS NATIONAL REPORT SELECT Exhibit 3.2.2
LOGIC CRITERIA Page 4o119
REPORT TITLE: SRF CAPITALIZATION GRANT SUMMARY FOR REGION XX IN F? XX
REPORT NUMBER: 0602
SELECT LOGIC: PROGRAM-CS AND
RECORD-TYPE = C OR N AND
AUTHORITY - 3S AND
AWARD-CODE - ‘A’ AND
CAP-GRANT NE BLANK
REGION -)O( AND
FISCAL YEAR - XX
SORT BY: STATE
DISPLAY: ADABAS NAME: COLUMN HEADING
1 REPORT NUMBER (AS PART OF HEADER)
2 REPORTDATE (ASPARTOFI4 J R)
3 GUM-AWARD “CUMULATIVE EPA FUNDS AWARDED”
4 MATCH-CASH “CASH - CURRENT YEAR”
5 MATCH-ASSIT-BANKED “PREVIOUS TITLE VI ELIGIBLE
ASSISTANCE - (BANKED)”
6 MATCH-CASH-BANKED “PREViOUS CASH QVERMATCH
(BANKED)”
7 . MATCH-REOUIRED “20% STATE MATCH TOTAL”
8 O /ERMATCH “STATE OVERMATCH”
9 TOTAL BY COLUMN (TOTALS BY COLUMN)
83

-------
SRF GICS Instruction Manual
SRF GICS NATIONAL REPORT SELECT Exhibit 3.2.2•.
LOGIC CRITERIA Page 5of 19
REPORT TITLE: STATE REVOLViNG FUND PROJECT DETAIL. REPORT
REPORT. JUMBER: 0610
SELECT LOGIC: PROGRAM- CS AND
CAP-GRANT - BLANK AND
RECORD-riPE - C OR N
SORT BY: STATE
DISPLAY: ADBASE NAME: COLUMN HEADING
1 REPORTNUMBER (AS PART OF HEADER)
2 REPORT DATE (AS PART OF HEADER)
3 GRANT-NO “PROJECT NUMBER”
4 FACIL ES “FACILITIES”
5 MULTIPLE FACILITIES “MULT FAG CODE”
6 PERMITS “PERMITS”
APPLICANT INFORMATION:
7 NAME “APPLICANT NAME”
8 STREET “APPLICANT STREET”
9 CITY “APPLICANT CI1Y”
10 STATE “APPLICANT STATE”
11 ZIP “APPLICANT ZIP CODE”
1 2 CONG-DISTRICTS “CONG DISTS”
1 3 PROJECT-ID “ST-PROJ-ID
14 R 3ICN “REGION”
1 5 COLNI? “COUNTY”
84

-------
SRF GICS Instruction Manual
-
- .
SRF GICS NATIONAL REPORT SELECT Exhibit
3.2.2
LOGIC CRITERIA
Page 60119
REPORT TITLE: STATE REVOLVING FUND PRQJEGT DETML REPORT
REPORT NUMBER: 0610
DISPLAY: ADABAS NAME: COLUMN HEADING:
PLANNING:
16 INDIAN INDIAN
17 INDIAN -CODE •INDIAN CODE
1 8 PRIORITY-FV P.L. FY”
1 9 FIRST-USE-CODE FIRST USE
20 EOUWAIB4CY EOU /ALENCr
21 SRF-ASSISTANCE -TYPE ASST TYPE
22 PROJECT-TYPE PROJECT TYPES
FINANCE:
23 BINDING-AMT-TARGET UBIND COMM TG AMT
24 BIN DING-AMT-ACTUAL BIND COMM AC AMT
25 INTEREST RATE INTEREST RATE
NEEDS CATEGORIES:
26 CAT-I CAT-I
27 CAT-Il UCAT.IIU
28 CAT-lilA CAT-IIIA
29 CAT-IIIB CAT-IIIB
30 CAT-I VA CATIVA
31 CAT-IVB CAT-IVB
32 CAT-V CAT-V
85

-------
SRF GIGS instruction Manual
SRF GICS NATIONAL REPORT SELECT Exhibit 3.2.2
LOGIC CRITERIA Page 7 of 19
REPORT TITLE: STATE REVOLVING FUND PROJECT DETAIL REPORT
REPORT NUMBER: 0610
DISPLAY: ADABAS NAME: COLUMN HEADING
PROJECT STATUS:
33 STORM-SEWER-COST STORM-SEW 0
34 NON-POINT-SOURCE-COST 0 NON-POINr
35 ESTUARY-COST ESTUARIES
36 FUNDING STATUS •P.L. STATUS 0
37 INTENDED-USE-PLAN-FY IUP F
38 BiNDING-COMM-DATE-TARGET •BIND COMM TG Dr
39 BINDING-COMM-DATE-ACTUAL B1ND COMM AC DT
40 ANNUAL-RPT-DATE ANNUAL RPT
41 WWT-START-DATE 0 00NST START’
43 INmATE-OPERATiON-CODE INIAT OF OP ER 0
INmATE-OPERATION-DATE
44 PERFORMANCE-CODE PERF CERT’
PERFORMANCE-DATE
-A
86

-------
SRF GICS Instruction Manual
SRF GICS NATIONAL REPORT SELECT Exhibit 3.2.2
LOGIC CRITERIA Page 80119
REPORT TITLE: ANNUAL REPORT STATUS OF BINDING COMMITMENTS
REPORT NUMBER: 0611
SELECT LOGIC: PROGRJAM CS AND
CAPITAUZAT1ON RECORDS:
CAP-GRANT NE BLANK AND
RECORD-TYPE - C OR N AND
(CUMULATIVE PAYMENT QUARTER GT BLANK AND
PAYMENT GT ZERO)
and
PAYMENT-OTR MUST BE AT LEAST 1 YEAR PREVIOUS
TO THE CURRENT FiSCAL YEAR/QUARTER
PRQJECT RECORDS:
CAP-GRANT BLANK AND
BINDING-DATE-ACTUAL GT ZERO
SORT BY: REGION, STATE
DISPLAY: ADABAS NAME: COLUMN HEADING
I REPORT NUMBER (AS PART OF HEADER)
2 REPORT DATE (AS ARTOF HEADER)
3 PAYMENT-QTR “FEDERAL FY OTR OF PAYMENT”
4 PAYMENT “PAYMENT AMOUNT FOR QTR ”
5 CALCULATE: “CUMULATIVE PA” ‘IENr
(CUMULATIVE TOTAL
OF PAYMENT)
6 BINDING-AMT-ACTUAL “ACTUAL CUMULATIVE BINDING
COMMITMENTS”
7 CALCULATE:
(PAYMENT-OTR/BIN DING- “CUMULATIVE BINDING % OF
AMT-ACTUAL) X (100) PAYMENT FOR ThE QUARTER”

-------
SRF GICS Instruction Manual
REPORT NUMBER
REPORT DATE
REGION
STATE
GRANT-NO
NAME
EQUIVALENCY (DISPLAY ‘Y’
OR ‘BLANK FOR EACH PROJEC1)
8 BINDING-DATE-ACTUAL
WWT-START-DATE
INITIATE-OPERATION-DATE
PERFORMANCE-CODE
PERFORMANCE-DATE
SRF-ASS 1STANCE-TYPE
COLUMN HEADING
(AS PART OF HEADER)
(AS PART OF HEADER)
(AS PART OF HEADER)
(AS PART OF HEADER)
PROJECT NUMBER’
PROJECT NAME’
N EQUIVALENCY PROJECT’
‘BINDING COMMITMENT ACTUAL
DATE
‘BINDING COMMITMENT ACTUAL
AMOUNT
“CONST START DATE’
‘INITIATE OPERATIONS DATE’
‘AFFIRM PROJECT PERFORM
CERT’
ASST TYPE’
SRF GICS NATIONAL REPORT SELECT ExhIbit 3.2.2.
LOGIC CRITERIA Page 9 of 19
PROJECT LEVEL MILESTONES FOR 212 PROJECTS
0612
PROGRAM - CS AND
CAP-GRANT - BLANK AND
RECORD-TYPE - C OR N AND
PROJECT-TYPE - 212
REGION, STATE
ADABAS NAME:
REPORT TITLE:
REPORT NUMBER:
SELECT LOGIC:
SORT BY:
DISPLAY:
I
2
3
4
5
6
7
9 BINDING-AMT-ACTUAL
10
11
12
13
88

-------
SRF GICS Instruction Manual
SRF GICS NATIONAL REPORT SELECT ExhIbit 3.2.2
LOGIC CRITERIA Page lOot 19
REPORT TITLE: NATIONAL PROJECTS SUMMARY TO DATE FOR PROJECTS WITH
AC1UAL OR TARGETED BINDING COMMTMENTS
REPORT NUMBER: 0613
SELECT LOGIC: PROGRAM -CS AND
CAP-GRANT - BLANK AND
RECORD-TYPE - C OR N AND
BINDING-DATE-ACTUAL GT ZERO OR
BINDING-DATE-TARGET GT ZERO
SORT BY: REGION
DISPLAY: ADABAS NAME: COLUMN HEADING
1 REPORT NUMBER (AS PART OF HEADER)
2 REPORT DATE (AS PART OF HEADER)
NUMBER OF PROJECTS
3 IF FIRST-USE-CODE y, “212 FIRST USE”
(COUNTER)
4 IF FIRST-USE-CODE BLANK, “212 NON FIRST USE”
(COUNTER)
5 IF EQUIVALENCY y, “212 EQUIVALENCY”
(COUNTER)
6 IF EQUIVALENCY = BLANK, “212 NOT EQUIVALENCY”
(COUNTER)
CALCULATE:
7 “TOTAL 212 PROJECTS”
‘FIRST-USE-CODE V , .‘
‘FIRST-USE-CODE - BLANK’ - TOTAL
8 IF NON-POINT-SOURCE-COST “319 NON-POINT SOURCE”
NE BLANK, (COUNTER)
9 IF ESTUARY-COST NE BLANK, “320 ESTUARY”
(COUNTER)
10 TOTAL ALL COWMNS TOTAL BY COWt it 1
CALCULATE:
11
(REGIONAL TOTALS1TOTAL 212) PERCENTAGE BY CowM J
X (100) FOR212PROJECTS
(REGIONAL TOTALS TOTAL PERCENTAGE BY COWM J
212+319+320) X (100) FOR3 I9PROJECTS
( REGIONAL TOTALS1 OTAL PERCENTAGE BY COLUMN
89

-------
SRF GICS Instruction Manual
SRF GICS NATIONAL REPORT SELECT Exhibit 3.2.2•.
LOGIC CRITERIA Page 11 of 19
REPORT TITLE: NATIONAL PROJECTS SUMMARY TO DATE FOR PROJECTS wrr
ACTUAL OR TARGETED BINDING COMMITMENTS
REPORT NUMBER: 0613
DISPLAY: ADABAS NAME COLUMN HEADING
DOLLAR AMOUNT OF
PROJECTS
12 IF FIRST-USE-CODE - V, DISPLAY “212 FIRST USE”
BINDING-AMT-ACTUAL OR
BINDI NG-AMT-TARGET
13 IF FIRST-USE-CODE = BLANK, M212 NON FIRST USE”
DISPLAY IS BLANK
1 4 IF EQUIVALENCY V. DISPLAY “212 EQUIVALENCY”
BIN DING-AMT-ACTUAL OR
BIN DING-AMT-TARGET
1 5 IF EQUiVALENCY = BLANK “212 NOT EQUIVALENCY”
DISPLAY IS BLANK
1 6 CALCULATE: “TOTAL 212 PROJECTS TM
‘FIRST-USE-CODE - V ‘+
‘FIRST-USE-CODE - BLANK
BINDING-AMT-ACTUAL OR
BINDING-AMT-TARGEr
1 7 NON-POINT-SOURCE-COST “319 NON-POINT SOURCE”
(ACCUMULATE BY REGION)
1 8 ESTUARY-COST NE BLANK, “320 ESTUARY”
(ACCUMULATE BY REGION)
19 TOTAL ALL COLUMNS TOTAL BY COLUMN
20 CALCULATE:
(REGIONAL TOTALS#TOTAL PERCENTN3E BY OOWMN
212) X (100) FOR2I2PROJECTS
(REGIONAL TOTALS(TOTAL PERCENThGE BY COWMN
212+319+320) X (100) FOR319PROJECTS
(REGIONAL TOTALSIrOTAL.S PERCEY ffPGE BY OOWMN
212+319+320) X (100) F 0R320 PROJECTS
90

-------
SRF GICS Instruction Manual
SRF GICS NATIONAL REPORT SELECT ExhibIt 3.2.2
LOGIC CRITERIA Page l2of 19
REPORT TITLE: REG!ON)O( SUMMARYTO DATE FOR PROJECTS WITHTARGETED
OR ACTUAL BINDING COMMIThIENTS
REPORT NUMBER: 0614
SELECT LOGIC: PROGRAM-CS AND
CAP-GRANT - BLANK AND
RECORD-TYPE C OR N AND
BINDING-DATE-ACTUAL GT ZERO OR
BINDING-DATE TARGET GI ZERO
SORT BY: STATE
DISPLAY: ADABAS NAME: COLUMN HEADING
1 REPORT NUMBER (AS PART OF HEADER)
2 REPORT DATE (AS PART OF HEADER)
NUMBER OF PROJECTS
3 IF FIRST-USE-CODE - 212 FIRST USE
(COUNTER)
4 IF FIRST-USE-CODE - BLANK, TM212 NON FIRST USE TM
(COUNTER)
5 IF EQU IVALENCY -V, U212 EOUIVALENC
(COUNTER)
6 IF EQUIVALENCY - V. 212 NOT EOUIVALENC
(COUNTER)
7 CALCULATE: •TOTAL212 PROJECTS
‘FIRST-USE-CODE - V ‘+
‘FIRST-USE-CODE - BLANK’
- TOTAL
8 IF NON-POINT-SOURCE-COST 319 NON-POINT SOURCE
NE BLANK, (COUNTER)
9 IF ESTUARY-COST NE BLANK. U320 ESTUARY
(COUNTER)
10 TOTALALLCOLUMNS TOTAL BY COWMN
CALCULATE:
11
(STATE TOTALS/TOTAL 212) PERCENTAGE BY COLLNN
X (100) FOR 212 PROJECTS
(STATE TOTALS/TOTAL PERCENTAGE BY COUJAN
212+319+320) X (100) FOR 319 PROJECTS
(STATE TOTALS/TOTAL PERCENTAGE BY COL.IIVIN
91

-------
SRF GICS Instruction Manual
SRF GICS NATIONAL REPORT SELECT ExhibIt 3.2.2
LOGIC CRITERIA Page 13 of 19
REPORT TITLE: REGION )0( SUMMARY TO DATE FOR PROJECTS WITH
BiNDING COMMITMENTS
REPORT NUMBER: 0614
DISPLAY: ADABAS NAME: COLUMN HEADING
DOLLAR AMOUNT OF
PROJECTS
1 2 iF FIRST-USE-CODE Y, DISPLAY 212 FIRST USE”
BINDING-AMT-AC1UAL OR
BINDING-AMT-TARGET
(ACCUMULATE BY REGION)
1 3 IF FIRST-USE-CODE BLANK, oispi v “212 NON FIRST UsE”
BIN DING-AMT-ACTUAL OR
BINDING-AMT-TARGET
(ACCUMULATE BY REGION)
1 4 IF EQUIVALENCY -V, DISPLAY “212 EQUIVALENCY”
BIN DING-AMT-ACTUAL OR
B INDING-AMT-TARGET
(ACCUMULATE BY REGION)
1 5 IF EQUIVALENCY NE y, “212 NOT EQUIVALENCY”
BINDING-AMT-ACTUAL OR
BINDING-AMT-TARC3ET
(ACCUMULATE BY REGION)
1 6 CALCULATE: “TOTAL 212 PROJECTS”
‘FIRST-USE-CODE Y ‘+
‘FIRST-USE-CODE BLANK’ - TOTAL
1 7 NON-POINT-SOURCE-COST “319 NON-POINT SOURCE”
(ACCUMULATE BY REGION)
1 8 ESTUARY-COST NE B, “320 ESTUARY”
(ACCUMULATE BY REGION)
19 TOTAL i cow s TOTAL BY COWMN
20 CALCULATE:
(STATE TOTALS(TOTAL 212) PERCENTAGE BY COLUMN
X (100) F0R212 PROJECTS
(STATE TOTALSf TOTAL PERCENTAGE BY CCWMN
212+319+320) X (100) FOR 319 PROJECTS
(STATE TOTALS( OTAL PERCENTAGE BY COLUMN
212+319+320) X (100) F 0R320 PROJECTS
92

-------
SRF GICS Instruction Manual
SRF GICS NATIONAL REPORT SELECT
LOGIC CRITERIA
PROGRAM CS AND
RECORD-1YPE - C OR N AND
CAP-GRANT - BLANK AND
BINDING-DATE-ACTUAL GT ZERO OR
BINDING DATE TARGET GT ZERO
FiSCAL YEAR WITHIN A STATE
ADABAS NAME:
Exhibit 3.2.2
Page 14 of 19
REPORT NUMBER (AS PART OF HEADER)
REPORT DATE
IF FIRST-USE-CODE V.
(COUNTER)
IF FIRST-USE-CODE = BLANK,
(COUNTER)
IF EQUIVALENCY =
(COUNTER)
IF EQUIVALENCY = BLANK,
(COUNTER)
CALCU LATE:
‘FIRST-USE-CODE - V ‘+
‘FIRST-USE-CODE - BLANK’ TOTAL
IF NON-POINT-SOURCE-COST
NE BLANK, (COUNTER)
IF ESTUARY-COST NE BLANK,
(COUNTER)
TOTAL ALL COLUMNS
CALCULATE:
(FISCAL YEAR TOTALS/TOTAL
212) X (100)
(FISCAL YEAR TOTAL& OTAL
212+319+320) X (100)
(FISCAL YEAR TOTALS/TOTAL
212+319+320) X (100)
(AS PART OF HEADER)
NUMBER OF PROJECTS
‘212 FIRST USE’
‘212 NON FIRST USE’
‘212 EQUIVALENCY’
‘212 NOT EQUIVALENCY’
‘TOTAL 212 PROJECTS’
‘319 NON-POINT SOURCE’
‘320 ESTUARY’
TOTAL BY COLUMN
PERCENTAGE BY COLUMN
FOR 212 PROJECTS
PERCENTAGE BY COLUMN
FOR 319 PROJECTS
PERCENTAGE BY COLUMN
FOR 320 PROJECTS
REPORT TITLE: STATE PROJECT SUMMARY TO DATE FOR PROJECTS WITH
ACTUAL OR TARGEIED BINDING COMMITMENTS
REPORT NUMBER: 0615
COLUMN HEADING
SELECT LOGIC:
SORT BY:
DISPLAY:
I
2
3
4
5
6
7
8
9
10
11
-4
93

-------
SRF GICS Instruction Manual
SRF GICS NATIONAL REPORT SELECT ExhIbit 3.2.2
LOGIC CRITERIA Page 15 of 19
REPORT TITLE: STATE PROJECT SUMMARY TO DATE FOR PROJECTS WIN
ACTUAL OR TARGETED BINDING COMMITMENTS
REPORT NUMBER: 0615
DISPLAY: ADABAS NAME: COLUMN HEADING
DOLLAR AMOUNT OF
PROJ ECTS
1 2 IF FIRST-USE-CODE - Vt DISPLAY “212 FIRST USE”
BINDING-AMT-ACTUAL OR
BINDING-AMT-TARGET
(ACCUMULATE BY REGION)
13 IF FIRST-USE-CODE BLANK, “212 NON FIRST USE”
BINDING-AMT-ACTUAL OR
BINDING-AMT-TARGET
(ACCUMULATE BY REGION)
14 IF EQUIVALENCY - Y, DISPLAY “212 EQUIVALENCY”
BIN DING-AMT-ACTUAL OR
BINDING-AMT-TARGET
(ACCUMULATE BY REGION)
15 IF EQUIVALENCY NE V, “212 NOT EQUIVALENCY”
BINDING-AMT-ACTUAL OR
BINDING-AMT-TARGET
(ACCUMULATE BY REGION)
1 6 CALCULATE: “TOTAL 212 PRoJECTS”
‘FIRST-USE-CODE - V ‘+
‘FIRST-USE-CODE - BLANK’
- TOTAL
17 NON-POINT-SOURCE-COST •319 NON-POINT SOURCE”
(ACCUMULATE BY REGION)
1 8 ESTUARY-COST NE BLANK, “320 ESTUARY”
(ACCUMULATE BY REGION)
19 TOTAL ALL COLUMNS TOTALBY COLUMN
20 CALCULATE:
(FISCAL YEAR TOTALS/TOTAL PERCBJTAGE BY COWMN
212) X (100) FOR2 I2PROJECTS
(FISCAL YEAR TOTALS/TOTAL PERCENTAGE BY COWMN
212+319+320) X (100) FOR319PROJECTS
(FISCAL YEAR TOTALS/TOTAL PERCENTAGE BY COLUMN
212+319+320) X (100) F0R320 PROJECTS
94

-------
SRF GICS Instruction Manual
SRF GICS NATIONAL REPORT SELECT Exhibit 3.2.2
LOGIC CRITERIA Page 16 of 19
REPORT TITLE: NATIONAL ASSISTANCE TYPE SUMMARY TO DATE FOR PRQJECTS
WITH ACTUAL OR TARGETED BINDING COMMITMENTS
REPORT NUMBER: 0616
SELECT LOGIC: PROGRAM =CS AND
CAP-GRANT BLANK AND
RECORD TYPE=CORNAND
BINDING-DATE•ft DTUAL GT ZERO OR
BINDING:DAT - GET GT ZERO AND
SRF-ASSISTANCE-TYPE LRIGI OR I
SORT BY: RE ON
DIS PLAY: ADABAS NAME: COLUMN HEADING
I REPORT NUMBER (, S PART OF HEADER)
2 REPORT DATE (AS PART OF HEADER)
NUMBER OF ASSISTANCE
PROJECTS
3 IF SRF-ASSISTANCE-TYPE - L LOANS”
(COUNTER)
4 IF SRF-ASSISTANCE-TYPE - R, REFINANCED EXISTING DEBT
(COUNTER)
5 IF SRF-ASSISTANCE-TYPE - G, “GUARANrEES OF LOCAL DEBT
(COUNTER)
6 IF SRF-ASSISTANCE-TYPE - I , “INSURANCE”
(COUNTER)
ASSISTANCE DOLLARS
7 BINDING-AMT-ACTUAL “BINDING COMMITMENT AMOUNT
8 TOTALS BY COW TOTALS BY COWIvt4
CALCULATE: PERCENTAGE BYCOW
(REGIONAL TOTAL&TOTAL ALL
COLUMNS) X (100)
95

-------
SRF GIGS Instruction Manual
SRF GICS NATIONAL REPORT SELECT Exhibit 3.2.2
LOGIC CRITERIA Page 17 of 19
RE PORT TifLE: REGION XX ASSISTANCE TYPE SUMMARY TO DATE WITH
ACTUAL OR TARGETED BINDiNG COMMITMENTS
REPORT NUMBER: 0617
SELECT LOGIC: PROGRAM ‘.CS AND
CAP-GRANT - BLANK AND
RECORD-TYPE- C OR NAND
BINDING-DATE-ACTUAL GT ZERO OR
BINDING-DATE-TARGET GT ZERO AND
SRF-ASSISTANCE-TYPE - LR,G, OR I
SORT BY: STATE
DISPLAY; ADABAS NAME: COLUMN HEADING:
1 REPORT NU ER (AS PART OF HEADER)
2 REPORT DATE (AS PART OF HEADER)
NUMBER OF ASSISTANCE
PROJECTS
3 IF SRF-ASSISTANCE-TYPE - L “LOANS”
(COUNTER)
4 IF SRF-ASSISTANCE-TVPE - R, “REFINANCED EXIS11NG DEB1
(COUNTER)
5 IF SRF-ASSISTANCE-TYPE - G, “GUARANTEES OF LOCAL DEB
(COUNTER)
6 IF SRF-ASSISTANCE-TYPE - I, ‘INSURANCE”
(COUNTER)
ASSISTANCE DOLLARS
BINDING .AMT-ACTUAL “BINDING COMMITMENT
AMOUNT”
8 TOTALS BY COWMN TOTALS BY COWP*I
9 CALCULATE:
PERCENTAGE BY COWMN
(STATE TOTALS/TOTALS ALL
COLUMNS) X (100)
a -
96

-------
SRF GIGS Instruction Manual
SRF GICS NATIONAL REPORT SELECT ExhIbit 3.2.2
LOGIC CRITERIA Page 18 of 19
REPORT TITLE: SRF PRQJECT RECORDS COST CATEGORIES BINDING
DATE - ACTUAL FROM )0000(X THRU )0000CX
REPORT NUMBER: 0618
SELECT LOGIC: PROGRAM - CS AND
RECORD-TYPE - C OR N AND
BINDING-AMT-ACTUAL GT ZERO AND
BINDING-DATE-ACTUAL WITHIN A
CERTJ JN DATE RANGE (DATE RANGEI
TO DATE-RANGE 2)
PROJECT NO.
ADABAS NAME:
REPORT NAME
REPORT DATE
STATE
REG
GRANT-NO
NAME
INTEREST RATE
8 CAT-I
9 CAT-Il
10 CAT-lIlA
11 CAT-I IIB
1 2 CAT-I VA
13 CATIV-B
14 CAT-V
SORT BY:
DISPLAY:
1
2
3
4
5
6
7
COLUMN HEADING:
(AS PART OF HEADER)
(AS PART OF HEADER)
(AS PART OF HEADER)
(AS PART OF HEADER)
“GRANT-NO’
‘NAME’
INTEREST RATE”
WEDS CATEGORIES:
‘CAT I ’
‘CAT-I I’
‘CAT-lilA’
‘CAT-IIIB’
‘CAT-I VA’
‘CAT-IVB ’
‘CAT-V’
-4
97

-------
SRF GICS Instruction Manual
SRF GICS NATIONAL REPORT SELECT ExhibIt 3.2.2
LOGIC CRITERIA Page 19 of 19
REPORT TITLE: SRF PROJECT RECORDS COST CATEGORIES BiNDING
DATE - AC1UAL FROM )00000( ThRU )OOOO0
REPORT NUMBER: 0618
DISPLAY: ADABAS NAME: COLUMN HEADING:
15 STORM-SEWER-COST “STORM-SEWER-COST”
1 6 NON-POINT-SOURCE-COST “NON-POINT-SOURCE”
1 7 ESTUARY .COST ESTUARY-CO3T ”
CALCULATE:
1 8 TOTAL ALL COLUMNS “XX ST SUMMARY”
CALCULATE:
19 TOTAL PROJECTS “COUNT”
98

-------
SRF GICS Instruction Manual
Exhibit 3.2.3 SRF GICS National Reports
This exhibit provides samples of the SRF GICS National reports.
Each National report is provided with a description of the purpose of the
report, the type of information provided by the report and a description
of the data elements included on the report.
99

-------
SRF GiGS Instruction Manual
SRF GICS NATIONAL REPORTS — Exhibit 3.2.3
Page 1 of 32
REPORT TITLE: STATE REVOLVING FUND CAP GRANT DETAL REPORT
REPORT NUMBER: 0600
PURPOSE: To Provide SRF Capitalization Information
TYPE OF
IN FORMATION: SRF Capitalization Grant National Data Elements information
The following information is provided for each State:
DATA ELEMENT: DESCRIPTION:
Grant Number The Financial Assistance Identification Number assigned to
identify grant
Legislative Authonly Identifies the Clean Water Act: Title VI as the authority under
which the proposed grant is to be funded
State F? The beginning date of the fiscal year selected by the state
receving a State Fund Capitalization Grant
Applicant InformatIon:
Applicant Name The Name of the local government who received the award
Applicant Address Current address of the local government
State ID Grant application identifier assigned by a state or local
government to a grant for control purposes
Region EPA region that the state is located in
FInance:
Cum-Award Total amount of capitalization grant funds awarded to the state
EPA-Award Actual amount of EPA funds awarded
100

-------
SRF GICS Instruction Manual
SRF GICS NATIONAL REPORTS Exhibit 3.2.3
Page 2 of 32
REPORT TITLE: STATE REVOLViNG FUND CAP GRANT DETAIL REPORT
REPORT NUMBER: 0600
DATA ELEMENT: DESCRIPTION:
State Match Contributions Indicates the dollar amounts for each type
of State Match contribution
Six types of Contributions:
-Match Req 20%
-Match Cash
-Match Asst Banked
-Match Cash Banked
-Overmatch
-Grant+20% Match
Grant Status Defines the current status of the Grant
Application Receipt The actual date of the receipt of the application by the EPA
Grant Award The date related to the Target or Event code contained in
Final Award and Approval Code
Payment Schedule:
Payment Quarter Quarters in which payments to the SRF are to be made
Amount The quarterly payment amounts to the SRF
Payment Date The date on which payments to the SRF are to be made
101

-------
SRF G1CS Instruction Manual
Exhibit 3.2.3
Page 3 0132
STATE REVOLVING FI .R CAP GRANT PAGE:
DETAIL REPORT
GRANT STATUS: AMARDED
APPL RECEIPT (Li): A 88/06i16 GRANT AMARD (1.5): A 86/09/20
PAYMENT SCHEDULE:
- QUARTER (VOl
1/66
2/86
3/88
4/66
1/ 69
3/89
4/69
1/90
2/90
3/90
AP1 .MT ISP)
28,194,250
DATE (114)
A
1
91—04-04
RPT-NO: SRF-0600
GRANT 1It ER £01): C5 .090P01,N,88.D
STATE
FY
lIP):
91/10/01
1.1513 AUTH 106): 35
APPLICANT INFORMATION:
COI1IECTI UT D.E.P.
165 CAPITOL AVE.
HARTFORD CT 06106
ST ID tR9): 821123015A
REGION (17): 01
FINANCE:
CL I I AMARD (19): 28,194.250
EPA AMARD (31); 28,194.250
STATE MATCH CONTRIBUTION
MATCH REQ (207.) (5 . )): B,636 850
MATCH CASH ( 5k): 5.638.830
MATCH *581 Bk
MATCH CASH Bk (GM):
OVERMATCH (ON): 3,021.150
GRANT.20X MATCH (GO): 33,833.100

102

-------
SRF GICS Instruction Manual
Exhibit 3.2.3
SRF GICS NATIONAL REPORTS Page 4 of 32
REPORT TITLE: NA11ONAL SRF CAPITALIZATION GRANT SUMMARY
REPORT NUMBER: 0601
PURPOSE: To provide capitalization grant summary information for
all regions.
TYPE OF
INFORMATION: Capitalization Grant Financial data
The following information is provided for each State:
DATA ELEMENT: DESCRIPTION:
State The States which received capitalization grant funds
Cumulative EPA Total amount of capitalization grant funds awarded to each
Funds Awarded State
Cash - Current The total dollar amount of that portion of the 20% State
Year match which is contributed in cash for each State
within a Region
Previous Title VI The total dollar amount of that portion of the State
Eligible Assistance 20% required match that is satisfied by projects
previously funded by each State and which meet Title VI
requirements within a Region
Previous Cash The total dollar amount of that portion of each State’s
Overmatch 20% required match that has been banked from
previous year’s cash overmatches within a Region
20% State Match The total dollar amount of each State’s 20% match.
This is equal to the sum of:
Cash - Current Year + Previous Title VI Eligible Assistance +
Previous Cash Overmatch
State Overmatch The total dollar amount of the State Match Contribution in
excesss of the required 20% State match within a Region
103

-------
P.
Exhibit 3.2.3
Page 5 of 32
SIP-Nil
PLOI DATE: 04/09/ SI
NATIONAL SIP CAPITALIZATION WANT SISITARY
MISER OF STATES CTSIJUTIVE CAIN PREVIflIPS TITLE VI PREVIOUS CAIN lOX STATE STATE
SIUCH RECEIVED ONE EPA F1J 3 -CONRENT CLIGAI)LE ASSISTANCE OVERIIATCN flATCN OVERNATCI I
lESION ON TORE WANTS AWARDED TEAR I 8*18110 1 I 8*1 11 (0 ) TOTAL
II 6 193,740.407 57,539.512 1,108,501 58,740.093 0,806,637
i i 5 319,363,3I0 57.034.261 57,834,261
II I 109.420.049 31.896,626 33.896,678 178,410
0
04 I 133,429.595 106,665,919 106,685.91!
I I 6 341,500,827 47,155,101 47,255.101 88,693
S 5 351,114,641 70.044,595 1,711,680 71,461,916 40,611
07 4 106.460.567 11.296.111 21,296.111
08 6 111.395.377 21,4? ,014 1S.663,15 925,489
I, 4 279,911,276 55.963,055 82.832.09i 43,984,394
II 4 84.597.892 36.919,576 I6,9 1,. 176
TOTAL II 7,619,376.I10 489,935.822 2.920.261 487,594,777 54.494,496
A

-------
SRF GICS Instruction Manual
SRF GICS NATIONAL REPORTS Exhibit 3.2.3
Page 6ot32
REPORT TITLE: SRF CAPflALIZA11ON GRANT SUMMARYFOR REGION )OC IN FY )O(
REPORT NUMBER: 0602
PURPOSE: To provide capitalization grant summary information for
all States receiving SRF funds
TYPE OF
INFORMATION: Capitalization Grant Financial data
The following information is provided for each State:
DATA ELEMENT: DESCRIPTION:
State The States which received capitalization grant funds
Cumulative EPA Total amount of capitalization grant funds awarded to each
Funds Awarded State
Cash - Current The total dollar amount of that portion of the 20% State
Year match which is contributed in cash for each State
within a Region
Previous Title VI The total dollar amount of that portion of the State
Eligible Assistance 20% required match that is satisfied by projects
previously funded by each State and which meet Title VI
requirements within a Region
Previous Cash The total dollar amount of that portion of each State’s
Overmatch 20% required match that has been banked from
previous year’s cash overmatches within a Region
20% State Match The total dollar amount of each State’s 20% match.
This is equal to the sum of:
Cash - Current Year + Previous Title VI Eligible Assistance +
Previous Cash Overmatch
State Overmatch The total dollar amount of the State Match Contribution in
excesss of the required 20% State match within a Region
105

-------
Exhibit 3.2.3
Page 7 of 32
PAGE s 3
S I? CAPITAL1ZAUGI GPAIff SIEttARY FOR REGIGI It FOR ALL FT’S
SI ?060 1
m u OAT h 04109F91
CIfl It.AT IVE CASK PREVIOUS TITLE VI PREVIOUS CASH lOX STATE
I PA P 1 1 03 CWRENT ILIGIOLE ASSISTAICE OVIRPIATCI I MATCH STATE
ITATI AWARDED YEAR (SAWED) IBAIO (ED I TOTAL OVERMATCI I
CT 93, 508 .032 19,7 11 ,609 19 .70 1 ,609 3,636.389
It 14.892.795 1,970.159 1.978,539 317. 101
0
0 MA 126,4 16 .101 25,291,240 tO .flI ,24 1
III 19,119,0 15 3,961.962 3,961,961
0 1 13.375 ,4*1 1,671.696 1.675,696
VT 0.695 143 1 ,931,446 1,106,581 4.330.0 27 1, 9 13,067
0 10 1W) TOTAL 193,740 ,4 17 1.208,581 58,748.093 0,006.637

-------
SRF GICS Instruction Manual
r-
SRF GICS NATIONAL REPORTS Exhibit 3.2.3
Page 8 of 32
REPORT TITLE: STATE REVOLVING FUND PR( JECT DETAiL REPORT
REPORT NUMBER: 0610
PURPOSE: To provide SRF project information
TYPE OF
INFORMATION: SRF National Project Data Eement information
The following information is provided for each State:
DATA ELEMENT: DESCRIPTION:
Project Number The Financial Assistance Identification Number assigned to
identify each loan
Facilities Identifies the Wastewater Treatment facilities and cognizant
Wastewater Treatment authorities related to a SRF project
Multiple Facilities Identifies when the scope of work of either a proposed or awarded
— grant project or SRF project will address the needs
represented by more than one authority/facilitly number
Permits Permit Number relating to the SRF project
Applicant Information:
Applicant Name The Name of the local government who received the award
Applicant Address Current address of the local government
Congressional Congressional District impacted by a SAP project
Districts
State Project ID Identifier available to be assigned by the state to each project
provided assistance by the SRF
Reg ion EPA region that the state is located in
County Major County in which the project is sited
Indian Identities the project as an Indian Project
Indian Code Identifier assigned by the state to each project that is
provided assistance by the SRF
107

-------
SRF GICS Instruction Manual
SRF GICS NATIONAL REPORTS Exhibit 3.2.3
Page 9 of 32
REPORT TITLE: STATE REVOLViNG RiND PROJECT DE AJL REPORT
REPORT NUMBER: 0610
DATA ELEMENT: DESCRIPTION:
Planning:
P.L. FY Year of the state’s SRF Priority List
First Use A project assisted through the SRF which is Identified as a National
Municipal Policy Project which addresses the requirement for “first
use” of funds to assure maintenance of progress towards compliance
with enforceable requirements of the Clean Water Act
Equivalency SRF Projects which meet Title II equivalency requirements
as determined by the state in the Annual Report
Asst Type Type of financial assistance provided for SRF projects
Project Type Identifies the statutory category of projects assisted by the SRF
Binding commitment The Target amount of the binding commitments
Target Amount
Binding Commitment The Actual amount of the binding commitments
Actual Amount
Loan Interest Rate Interest Rate used for repayment of loans for a project
funded through the SRF
Needs Categories:
Cat-I Portion of the eiigibie cost of a Wastewater Treatment
Construction or SRF project that is required to provide
secondary treatment” or “best practicable wastewater
treatment technology”
Cat-Il Portion of the eligible cost of a Wastewater Treatment
Construction or SRF project that is required to achieve
treatment levels more stringent than secondary
Cat-lilA Portion of the eligible cost of a Wastewater Treatment
Construction or. SRF project that is required for the correction
of sewer system infiltration/inflow problems
108

-------
SRF GICS Instruction Manual
SRF GICS NATIONAL REPORTS Exhibit 3.2.3
Page lOOt 32
REPORT TITLE: STATE REVOLVING FUND PROJECT DETPJL REPORT
REPORT NUMBER: 0610
DATA ELEMENT: DESCRIPTION:
Cat-IIIB Portion of the eligible cost of a Wastewater Treatment
Construction or SRF project that is required for the
replacement and/or major rehabilitation of existing sewer
systems
Cat-I VA Portion of the eligible cost of a Wastewater Treatment
Construction or SRF project that is required for
construction of new collector sewer systems
Cat -IVB Portion of the eligible cost of a Wastewater Treatment
Construction or SRF project that is required for
construction of new interceptor sewers and transmission
pumping stations necessary for the bulk transport
of wastewater
Cat-V Portion of the eligible cost of a Wastewater Treatment
Construction or SRF project that is required for
construction of facilities to prevent and/or control
periodic bypassing of untreated wastes from combined
sewers in order to achieve water quality objectives
Storm Sewer Cost Amount of assistance provided from the SRF for
Wastewater Treatment works for control of pollutant
discharges from separate storm sewer systems as
defined in the Clean Water Act
Non-Point Source Cost Portion of the cost of a project assisted by the SRF
which implements a management program established
under Section 319 of Clean Water Act
Estuaries Portion of the cost of a project assisted by the SRF
used for the development and implementation of
a conservation and management plan under Section
320 of the Clean Water Act
109

-------
SRF GICS Instruction Manual
SRF GICS NATIONAL REPORTS Exhibit 3.2.3
Page 11 of 32
REPORT TITLE: STATE REVOLViNG FUND PROJECT DETAIL REPORT
REPORT NUMBER: 0610
DATA ELEMENT: DESCRIPTION:
Project Status:
P.L. Status identifies the p ,ject as a State Revolving Fund Project
IUP FY Latest fiscal year in which the Intended Use Plan
(IUP) is submitted to the EPA Regional Office
Binding Commitment The Target date of the binding commitments
Target Date
Binding Commitment The Actual date of the binding commitments
Actual Date
Annual Report Date of the most recent Annual Report submitted to
the EPA regional office for the SRF
Const Start Indicates the date that construction began
lnit of Oper Indicates either the target event code and date for which
operations are scheduled to begin or the actual date if
the operations have begun
Perf Cert A target or event code and date representing the current
status of the certification to EPA that the project is actually
meeting its performance standards
110

-------
SRF GICS Instruction Manual
Exhibit 3.2.3
Page 12 of 32
STATE REVOLVING FIJ PAGE: 1
PROJECT DETAIL REPORT
RPT-NO: SRF-0610 91-04-04
PROJECT
t.afreER
101):
CS,470493,K,05,0
PACIUTIES
(LE):
471016006
PIlL? PAC
CODE
(PA):
PERMITS
(LF):
P Th00?4970
APPLICANT INFORMATION:
NASHVILLE, CITY OF
211 I1410N ST
NASHVILLE TN 37201
CONG DISTS: (YE): 5
ST-PROJ ID (LC): PLAIIIING:
REGION (17): 04 P.L. FT 157): 91
C J (TY (15): DAVIDSON FIRST USE (FU):
INGIAN (PD): EQUIVALENCY (FV):
INGIAN CODE (LC): ASST TYPE 1 (D):
PROJECT TYPE (Vt): 212
FINANCE: NEEDS CATEGORIES:
BIPC CCI I I TG ANT (OR): 5,625,000 CAT—I (TO):
BING COI?( AC AlIT (GM): CAT-I l (Ti):
INTEREST-RATE (YB): CAT-lilA (T2):
CAT—IllS (Y3):
CAT-IVA (Y4):
CAT-IVB (Y5): 5,625,000
CAT-V (Y6):
STORM SEN (TA):
NON-POINT (YB):
ESTUARIES ITCh
PROJECT STATUS:
TARGETED
P.L. STATUS
(34):
S
IUP FT
(VA):
B 1P CCIII TG
Dy
(ZR):
90/06/30
SING COIRI AC
DT
(IS):
A HJAL RPT
(ZR):
CONST START
(MO):
INIAT OF OPER
(N7):
PERF CERT
(LA):
111

-------
SRF GIGS Instruction Manual
SRF GICS NATIONAL REPORTS Exhibit 3.2.3•
Page 13 of 32
REPORT TITLE: ANNUAL REPORT STATUS OF BINDING COMMITMENTS
REPORT NUMBER: 0611
PURPOSE: To report capitalization grant payment and binding
commitment data for each State. Report will indicate whether
binding commitments have been made for 120% of payments
in the first year
TYPE OF
INFORMATION: Capitalization Grant Financial data
The following information is provided for each State:
DATA ELEMENT: DESCRIPTION:
Federal F? Otr of The quarters in which payments to the State Revolving Fund
Payment are to be made.
Payment Amount for The quarterly payments to the State Revolving Fund.
OTR
Cumulative Payment Calculates the total of all payments to the State Revolving Fund.
Actual Cumulative Total amount of commitments to a project by the State
Binding Commitments Revolving Fund
Cumulative Binding % Calculates the percentage of cumulative binding commitments
Of Payment For the based upon the payments received during the stated quarter.
Quarter
112

-------
C I)
Exhibit 3.2.3 i i
Pagel4of32 6)
C ,
CI)
C l )
a’
C
a
0
REfltI , OFF-loll AMIJAL REPORT STATUS OP PAGE: I
Citelic CII9IITMLNTS
mm un $ wnns
RESIGI: 01 STATE: CT C
FEDERAL PAYMENT M I m iC CIII SlICING CUIJLATIVE DIICIIC
FT RIP OF anoimr CIUJLATIVE COP OI IT I IENTS CORPESPOCING TO X OF PAYMENT
PATIENT FOR P75 PAYMENT FOR QIR C I II PAYMENTS FOR TIlE QTR
C O 1/06 20.l94.250 20. 194.250 9 .3 14. 145 9,314.145 33.03
3/09 21.343 ,055 49.576.135 19.704.261 19.010.406 56.53
2/99 9,974,359 59,552,494 39 ,523.52? 60,541.933 £15.09
3/99 315,960 59.926.454 42,043.52? 109,565.46 1 *02.06
---4

-------
SRF GICS Instruction Manual
SRF GICS NATIONAL REPORTS Exhibit 3.2.3
Page 15 of 32
REPORT TITLE: PROJECT LEVEL MILESTONES FOR 212 PROJECTS
REPORT NUMBER: 0612
PURPOSE: To provide project level milestone information on all 212
SRF projects funded by a State for the fiscal year
TYPE OF
INFORMATION: SRF Project Financial Data
The following information is provided for each State:
DATA ELEMENT: DESCRIPTION:
Project Number The SRF Project number
Project Name The SRF Project name
Equivalency Project Indicates whether the SRF Project is an equivalency project
or not
Binding Commitment The Actual date of the binding commitment amount
Actual Date
Binding Commitment The Actual amount of the binding commitments
Actual Amount
Construct Start Date Indicates the date that construction began
Initiation of Indicates either the target date for which operations are
Operations Date scheduled to begin or the actual date if operations have begun
Affirmative Project A report or event code and date representing the
Performance current status of the certification to EPA that the
Certification project is actually meeting its performance standards
Assistance Type Indicates the type of assistance provided for the SRF project
by the State
114

-------
U’
UE T let
mio oa i
0102011. I I
PROJECT
MISER
090* 57050
090 *960 20
090*97060
090199010
090*99020
090206020
09 1206 130
0901110*0
090116010
090226030
090226020
090237010
090250020
090150010
190151030
090153010
090159010
190166030
190171010
110271020
090175010
090163030
09E 1670 10
0 9 029 *0*0
190194 110
090296010
090295010
190197020
1 9 1 1 7030
090297040
090297050
190297060
09 13000*0
090304020
090 306 0 I I
090309010
090509030
091311010
090111010
090313030 -
091314010
alP—OSlO
04/09/9*
STATE. CT
66/Il/ l I
90/06/0*
I l/Il/ U
69/01/07
69/02/07
67/I l/IL
09/02/03
90/0 1/ I l
1,411,965 90/06/01 93/06/01
26,700,000 90/06/01 93/06/01
1,046,965 69/04/IS 69/12/31
160,032 90/06/0* 92/12/3*
9,276,622 90/05/*4 92/05/31
9.314.145 66/04/01 90/03/01
10.206.140 09/03/IS 91/15/31
9,365.771 90/05/Il 93/12/31
L
I .
L
I.
L
(I)
‘1
C)
c i)
U)
-9
C
0
0
p)
C
p)
PROJECT LEVEL IULEST01IES FOR Ill PROJECTS
Exhibit 3.2.3
Page 16 of 32
PA66t 1
BItI lING 81 t I lING AFfIRM
COIIIITIIEIIT CON 1TItEHT COIST INITIATE PROJECT
ACTUAL ACTUAL SI ART OPERATIONS PERfORM ASST
DATE AII IIJ IT DATE DATE CERT TYPE
PROJECT IQUVALENCY
HA ItI PROJECT
tIlRNI fl, CITY OF
ORO01IFIEW, TONI OF
BRISTOL, CITE OF
OAISLtIY, CITY OF Y
D*NOIWT, CITY C l ’ Y
HEN HAVEN. CITY OP
lIEN HAVEN, CITY OF Y
CUILFORD. 70111 OF
IRIOGEPORT. CITY OF
0RIOGEPORT, CITY 0 ?
PLYIICITII, TOSII OF V
lilt IHAITFORDI
MIODLETOIII. CITY Of y
MIODLEIONI. CITY OF
ORAIIGE. TUSh 0?
IREENIICH. TOShI 0?
CANTON. TOSII OF
IIlITH HAVEN, TOSlI Of
STOHIISTOSI, TUSh 0?
HORDI IRAIIPOND. TUSh OF
STAFFORD, TOSlI 0?
OXFORD, TONI 0 ?
NAUGATUCX. BOROUGH OF
HARTFORD, CITY 0’
RIDGEPIELO. TOSlI 0? V
RIDUFIELD. TONI 0? V
VERNON, TUSh Of
EAST LYIIE. TOSII OP V
EAST LTIIE. TOSII Op y
EAST LTME. TUSh OF V
EAST LYIIE, 10511 0?
EAST LYNE, TONI OF
MADISON, TONI OF
CHESHIRE, TONI OP
CLINTON. TUSh OF
SEYHOUG, 20511 OF
SEYMOIM, TONI OF
BRUOPLYN. Th dI 0?
SPRAOIJE, ‘ . J)5 0?
SPRAGUE. T ’N14 0?
SALISOORY. 10111 OF
L
L
L
L
L
69/04/IL
1,724,750
69/06/26
91/10131
69/06/IS
0.624,346
L
90/05/09 *3,437.156 90/05/09 92/1*/07 I

-------
SRF GICS Instruction Manual
SRF GICS NATIONAL REPORTS Exhibit 3.2.3
Page hot 32
REPORT TITLE: NATiONAL PROJECTS SUMMARY TO DATE FOR PROJECTS W TH
TARGETED OR ACTUAL BIND G COMMITMENTS
REPORT NUMBER: 0613
PURPOSE: To provide a National Summary of the number of SRF projects
and the dollar amount of assistance for each type of project at
the Regional and National levels
TYPE OF
INFORMATION: SRF Project Financial Data
The following information is provided for each State:
DATA ELEMENT: DESCRiPTION:
Project Type Indicates the number and dollar amounts of each type of
project by Region:
Six types of SRF Projects:
- 212 First Use
- 212 Non-First Use
- 212 Equivalency
- 212 Non-Equivalency
- 319 Non-Point Source
- 320 Estuary
Total Number of Indicates the total number of each of the types of projects
Projects
Percentage of Calculates the percentage of each of the types of projects
Total Projects on a National level
Total Dollar Amount Indicates the total amount provided for each type of project
Percentage of Total Calculates the percentage of the assistance dollar amount
Dollars funded for each type of project on a National level.
(i.e., 212 percentages are a percentage of total 212 projects.
319/320 percentages are the percentages of the total
212+319+320 projects.)
116

-------
Exhibit 3.2.3
Page 18 of 32
581-0613
IATIONAL PROJECT It1ARY TO DATE VON PROJECTS NIT)I BIlmINO C I1Ifl?ENT5
04/19 /91
PU ER OF PROJECTS
PROJECT Il l I I 2 H ON 319
T YP ! FIRST FIRST 212 212 HOT TOTAL 112 NON-PRINT 320
lESION USE USE EQUIVALENCY EQUIVALENCY PROJECTS SOONCE ESTUARY
II II 9 ii 9 20
02 Il 50 IS 52 61
93 7 6 I 7
04 13 I ll 33 I II 134
0S 3 16 16 I 19
.6 6 6 6
07 6 14 17 3 20
06 5 26 30 I 31
—& 09 0 8 8
I I 1 3 3 I 4
TOTAL 56 260 133 163 316
PERCNT 17.72 62.17 42.08 51.91
DOLLAR AIIOLWT Of PROJECTS
PROJECT II ! LIZIION 319
TYP! FIRST FIRST Il l Ill NOT TOTAL II I HON-POINT 320
lESION USE USE EQUIVALENCY EQUIVALENCY PROJECTS S MCE ESTUARY
01 73.112.094 55 ,5 57.315 73.712.094 55.557,310 129.269.409
02 202.438.672 386.413.416 266.131.311 322.720.957 590,052.286
03 23,207,672 13 .121.672 60,000 23,207,672
04 II. 79,549 411,315,364 101,700.906 322.708,001 424,494,913
00 41.030.001 3.713.0D0 122,180.000 3,443,000 123.631 ,000
04 100,002.766,421 100,002,108.4!I I00 ,002,768 ,42 1
07 11.403.00 1 22.964.206 34.630.009 5.537.206 40.367.206
I I 4.105,000 37.233.204 37,911,264 1.500.000 41,416.204
99 109,691,661 209,091,001 209.091,001
I I 4,063,700 12,959,350 12,959,360 4,063,700 11,023,050
TOTAL 334.640.215 I0I.250.3 03.959 674,603,661 100.930.290.467 101,604,944.154
PEPCHT 0.34 0.66 99.33

-------
r
Exhibit 3.2.3
Page 190132
IMTIUIAL PROJECT fl?1UT TO DATI F PROJECTS Mi ni TARGITEO SIlCIlS CfltIIIUEHTS
0409/91
MRmER OF PROJECTS
98OJVCT 2*2 2 1 2 1 C M 319
TYPE FIRST FIRST 2 *2 2*2 NOT TOTAL 212 NON -PO uT 320
RESIN USE USE EQUIVALENCY EQUIVALENCY PROJECTS S OIflE 25JU l11
II 25 25 23
I i 4 110 7 I I ? 314
II 42 16 16 42
N 9 662 *7 674 6 9*
05 5 *73 37 121 1 70
N 242 24* 241
07 3 39 62 62
85 I I * 00 33 78 111
S t 253 253 2 33
I I 2 * 77 7 91 98 2
—a TUTU. 53 1762 209 1406 ISIS 7
flDIT 2.92 97. 17 1131 68.48 0. 1*
DOLLAR AI IOIJIT OF PROJECTS
PROJECT 2 *2 2 1 2 1 CM 319
TY P E FIRST FIRST 212 212 NOT TOTAL 212 NON-SI lT 320
125131 USE USE EQUIVALENCY EQUIVALENCY PROJECTS %IPCE ES tW I T
f t 92 ,149 * 137 92. 149.137 92,149.137
01 314.245.308 378.072.109 349.504.664 343,612,713 693. 117.411
03 132.444.360 69.916,01! 62.528.545 132,446,560
04 21.644.649 2.261.617.223 469.181.649 1,834,066423 2.303.261.672
N 70.329.006 060.461.357 333.777.250 395.236.007 931,014,387
06 122. 110.841 322.071.641 522.070.841
07 3.450.000 72.060.611 75.310.6 1 1 75,310,61 1
N 4,311,100 1 14.951,4 13 31 ,651.000 157 .611 493 189,261.493
69 7.329.935.506 7.325.935.500 7.525.935.506
16 15.960.980 73.121.103 19.932.461 71.629.942 91.762 ,403 1 ,310.000
TOTAL 429.939.837 12424 ,410,563 I.33 1,294,099 t1.203,053.32 1 12.554,350,220 1.350.000
PE ROft 3.42 96.57 *0.76 89.23 6.01
L

-------
SRF GICS Instruction Manual
SRF GICS NATIONAL REPORTS Exhibit 3.2.3
Page 20 of 32
REPORT TITLE: REGION XX SUMMARY TO DATE FOR PRQJECTS wmi
ACTUAL OR TARGETED BINDING COMMFTMENTS
REPORT NUMBER: 0614
PURPOSE: To provide a Regional Summary of the number of SRF projects
and the dollar amount of assistance for each typo of project
within a State.
TYPE OF
INFORMATION: SRF Project Financial Data
The following information is provided for each State:
DATA ELEMENT: DESCRIPTION:
Types of Projects Indicates the number and dollar amounts of each type of
project by State:
Six types of SRF Projects:
- 212 First Use
- 212 Non-First Use
- 212 Equivalency
- 212 Non-Equivalency
- 319 Non-Point Source
- 320 Estuary
Total Number of . Indicates the total number of each of the types of projects
Projects
Percentage of Total Calculates the percentage of each of the types of projects
Projects on a Regional level
Total Dollar Amount Indicates the total amount provided for each type of project
Percentage of Total Calculates the percentage of the assistance dollar amount
Dollars funded for each type of project on a Regional level
(i.e., 212 percentages are a percentage of total 212 projects.
319/320 percentages are the percentages of the total
212+319+320 projects)
119

-------
REGION SI SIflIART TO DATE FON PROJECTS WITh 511511€ COIS IIflIENTS
PAGE :
Exhibit 3.2.3
Page 21 o 132
E
E l ? EIEICN
FIRST FIRST El ?
USE USE EQUIVALENCY
11 5 H
II 9 I I
55.50 45.00 55.00
MISER OF PROJECTS
319
El! NOT TOTAL EIE l O t -PRINT 3E 0
EQUIVALENCY PROJECTS SOLOICE EST U SRY
S I I
3 3
I I
ED
45. SD
DOLLAR AISIIJIT OF PROJECTS
tIE EIENON 3l
FIRST FIRST E IE EU lOT TOTAL El! NON-POINT HO
USE USE ESIJIVALEICT ESJIVALEI€T PROJECTS SOUSCE ES WART

TS YIE ,D94 40 ,167,097 7S ,TIE,094 40,167,09? 113,079,991
5 .0 0 9 14 10 5,519,411 5 ,519.410
9.fl0 ,00S 9.SSD, 1 1S 9,SSO. DD S
7 5,?IE ,094 15.517 , 515 73,7IE.S94 55,557.311 1E9 ,E69.4D9
57.0$ itS? 57.0 ! 4E.97
SRF-06 14
. 4 ,0 , /SI
-s
F ’ , )
0
PROJECT
TYPE
STATE
CT
I I
M I
TOTAL
i.
PROJECT
TYPE
STATE
CT
N
MI
TOTAL
PE n n

-------
C l )
Exhibit 3.2.3
Page22o 132
C )
C l)
•P- 16 14 PAGE g I
(1 )
110101 01 OR9IART TO DATE FOR PROJECTS Mliii TARGETEO •IICIIC C(flIITEMTS
MROER OF PROJECTS g
fl flCT 212104 319
nfl FIRST FIRST RI ! RI! ICT TOTAL 212 101- P RINt 320 0)
STATE USE USE EQUIVALEHCT EQUIVALEHCY PROJECTS SOIPCE ESTUARY
C
It IS 15 IS
I II 5 5 S —
II 4 4 4
-L Vt I I I
—S TOTAL 25 25 25
PERCNT 100.10 100.00
DOLLAR AIURIT OF PROJECTS
PROJICT 21! 21210 1 319
UN FIRST FIRSt 2 12 212 l OT TOTAL LI! 101-PRINT 320
STATE USE USE EWIVALENCY EWIVALEICT PROJECTS SOI CE ESTUARY
It 60,1 1 1.356 60.7 11.336 60,715.356
I I I 16.321.144 16,321,144 16.321.144
RI 13.702 ,63 ? 13.762.637 13.762.631
VT 1,331.010 1.330,011 1,330,000
TOTAL 92.149, 13 ? 92,149.13? 92,149.13?
PEROI T 111.10 110.00

-------
SRF GICS Instruction Manual
SRF GICS NATIONAL REPORTS Exhibit 3.2.3W
Page 23 of 32
REPORT TITLE: STATE PROJECT SUMMARY TO DATE FOR PROJECTS WITh
ACTUAL OR TARGETED BINDING COMMITMENTS
REPORTNUMBER: 0615
PURPOSE: To provide a State Summary of the number of SRF projects
and the dollar amount of assistance for each type of project
for one or more fiscal years
TYPE OF
INFORMATION: SRF Project Financial Data
The following information is provided for each State:
DATA ELEMENT: DESCRIPTION:
Types of Projects Indicates the number and dollar amount of each type of project
by fiscal year:
Six types of SRF Projects:
- 212 First Use
- 212 Non-First Use
- 212 Equivalency
- 212 Non-Equivalency
- 319 Non-Point Source
- 320 Estuary
Total Number of Indicates the total number of each of the types of projects
Projects
Percentage of Total Calculates the percentage of each of the types of projects
Projects for a fiscal year
Percentage of Total Calculates the percentage of each of the types of projects
Projects for each fiscal year
Total Dollar Amount Indicates the total amount provided for each type of project
Percentage of Total Calculates the percentage of the assistance dollar amount
Dollars funded for each type of project for a fiscal year (i.e.. 212
percentages are a percentage of total 212 projects.
319/320 percentages are the percentages of the total
212+319+320 projects.)
122

-------
Exhibit 3.2.3
Page 24 of 32
—F-HIS
VIII DAT! 04/09/91
01 1101 : II STATE: ME
STAT! SalARY TO DATE FOR PROJECTS 1 11Th 0 1101% COISIITTIENTS
MAtER OF PROJECTS
il l 2 1 2 1 1D M 3 19
FIRST FIRST 212 212 lOT TOTAL i i i NON-PRINT 320
USE USE EQUIVALENCY EQUIVALENCY PROJECTS SOIWCE EStUARY
3 3 3
3 3 3
100.00 100.05
DOLLAR ANOIMT OF PROJECTS
Eli 21211DM 319
FIRST FIRST 212 212 NOT TOTAL 212 10 1-PRINT
US! USE EQUIVALENCY EQUIVALENCY PROJECTS 5 0 1 1 W!
S,5S9 4l0 3 .509 , 410 S,5 09,4 1 e
1 ,009 , 4 10 5.809,416 5.009,410
*00.00 100.00
320
ES IUARY

I ’ )
C*)
PROJECT
TYPE
PIt’YP
9,
TOTAL
man
PAGE:
3
PROJECT
TYPE
‘I on ’
N
TOTAL
man

-------
(1 )
Exhibit 3.2.3 71
Page25of32
0
C l )
0 )
I-
S OP-OAtS PAGE s 2
STATE SIflhARY TO DATE FOR PROJECTS 11 1Th TARGETED lIMPING COPIIIThINTS C
Pill DATE 04/19/91 —.
RESIWII I I STATEs NO 0

MISER OF PROJECTS
p3
PROJECT 2 12 212 1 511 3 19
TTPE FIRST FIRST L I I II ? NOT TOTAL II! MIl-POINT 320 C
P15/YR USE USE EQUIVALEICT EQUIVALENCY PROJECTS 90ISCE EStUARY p3
90 I I I
—t 91 9 9 9
r TOTAl. I I 5 I I
PEROIT 100.00 100.00
DOLLAR A1IOLRIT OF PROJECTS
PROJECT 212 2125511 319
TYPE PIRST FIRST II ! 212 NOT TOTAL El! NON-PRINT 320
P1 5/YR USE USE EQUIVALENCY EQUIVALENCY PROJECTS SOIMCE ESTUARY
90 1, 01.417 2.01.417 2, 6 51.417
91 42,424.939 42,424.939 42.424,939
ft 15.639.000 11.639 ,000 15,639,000
TOTAL 60.7 1 5,356 60,715.356 60.715356
PERUI1 ’ 101.00 1 11.01

-------
SRF GIGS Instruction Manual
SRF GICS NATIONAL REPORTS Exhibit 3.2.3
Page 26 of 32
REPORT TITLE: NATiONAL ASSISTANCE TYPE SUMMARY TO DATE FOR PRGJECTS
WITH ACTUAL OR TARGETED BINDING COMMITMENTS
REPORT NUMBER: 0616
PURPOSE: To provide a National Summary of the number of SRF projects
and the dollar amounts received, by each type of assistance
used in a Region.
TYPE OF
INFORMATION: SRF Project Financial Data
The following information is provided for each State:
DATA ELEMENT: DESCRIPTION:
Number of Assistance Projects (by Region):
Indicates the number of loans
Refinanced Existing Debt Indicates number of projects receiving aid in the
form of refinancing of existing debt
Guarantees of Local Debt Indicates number of projects receiving aid in the
form of guarantees of local debt
Insurance Indicates number of projects receiving aid in the
form of insurance
Assistance Dollars (by RegIon):
Binding Commitment Amount Indicates the total dollar amount of binding
commitments
Total Number of Projects Indicates the total number of projects in each
category Nationally
Percentage of Total Projects Calculates the percentage of the National total
represented by each project type
125

-------
p Exhibit 3.2.3
DATEi Page 27 of 32
NATI 4AL ASSI!TAiCE TYPE UEURT TO lATE FOR PROJECT! WITH TARGETED STillING COIEIITMEHTS
IUllER 0? A!!ISTAPCE PROJECT! A3!ISTAIICI DOLLAR!
PIF 1NAICED CUAPNITEES STIllING
IXI3TINS Of LOCAL COS IUThENT
LOAN! 0 1ST 01ST IN!WAPCE M 1IT
I I 31.433.711
It 1 1 4 6 9 693,117,417
SI I I I 396,048,549
S O 169 1 I.IlI,03 ! ,937
SI ? 2 I!S.S i2,II!
.4
51 61 7 2.! 03.6 1S
SI I I ! I 1l4.543. 143
S 42 I 19 0, 0 17.000
IS to I ,I, iet,403
_&
TOTAL SI) SI
0) RIRDIT 11.21
NATIONAL AIIIITAICE TYPE USURY TO DATE FOR PROJECT) WITh SEllING CCI!IITICNTI
IUIER OF A!1I!TAICE PROJECT! A!!I!TAICE DOLLAR!
IEFINIJCE O WARANTEE! SIDOIN!
EXI!TINS Of LOCAL CUIZUENT
LONII PEST PEST IW!IINICE 11 1 1 1ff
SI 16 ltS,7 14,9 9 1
St 31 7 4 4 1, 993,t5$
SI I 23.928,48
04 II ? IS O0l, !7 !.36 !
SI I I 2 lU, ISI.SSS
56 I 1 1.314.196
07 I? 34,830.000
08 30 47,4 3,97 5
09
II 4 17.021. 585
TOTAL 241 26 I ,234,13I,6 9 6
ReRan 93.02 10.0?

-------
SRF GICS Instruction Manual
SRF GICS NATIONAL REPORTS Exhibit 3.2.3
Page 28 of 32
REPORT T1T LE: REGION )0( ASSISTANCE TYPE SUMMARY TO DATE WITH ACTUAL
OR TARGETED BINDiNG COMMITMENTS
REPORT NUMBER: 0617
PURPOSE: To provide a Regional Summary of the number of SRF projects
and the dollar amounts received, by each type of assistance
provided by the State
TYPE OF
INFORMATION: SRF Project Financial Data
The following information is provided for each State:
DATA ELEMENT: DESCRIPTION:
Number of Assistance Projects (by State):
Loans Indicates the number of loans
Refinancing Existing Debt Indicates number of projects receMng aid in the
form of refinancing existing debt
Guarantees of Local Debt Indicates number of projects receiving aid in the
form of guarantees of local debt
Insurance Indicates number of projects receiving aid in the
form of insurance
Assistance Dollars (by State):
Binding Commitment Amount Indicates the total dollar amount of binding
commitments
Total Number of Projects Indicates the total number of projects in e 3
category Nationally
Percentage of Total Projects Calculates the percentage of the National total
represented by each project type
127

-------
(I )
Exhibit 3.2.3
Page 2901 32 Q
C)
(1)
!IP-NI1 P*!I. I
OATh O .’lS/ I
PEOTmI SI ASSISTANCE TYPS SIDIl*fl TO DAT! FOP PROJECTS WITH FAUlTED IINSItC COI!IITWIKTS C
a
IU EI Of’ ASSISTNC! PROJECTS ASSISTANCE DOLLARS 0
REFINANCED WARNIUIS SDWIWI
IXISTINS OP LOCAL CCImTTH!NT
LOAN! DES? DEPT IN MNCE AIIOfIIT
III S 1 5,32 1. 144 C
II 4 hL1U, 537
VT I 1.US.SOS —
- A
TOTAL 1 5 31 .433,751
N PIPCNT ISS.00
PESIOfI 51 ASSISTANCE TIP! IUIUDY TO DATE PDP PROJECTS flITS SINSIJ SIITWINT$
IIRUIP 0 ? ASSISTANCE PROJECTS AI !ISTNC! 50U.ARU
PVIHANCIO JARANTEES SIICINI
EXISTII 0 ? LOCAL COfUIIThENTS
LOANS DES? DEPT INUIMA CE AISSIIT
CT 1 I 1 13.S7 5.SSI
ME I 45 5,000
II I I 5 , 1 51,005
TOTAL 16 p U3.7 14,0S1
PEU NT U.U LI II

-------
SRF GICS Instruction Manual
-
SRF GICS NATIONAL REPORTS Exhibit 3.2.3
Page 3001 32
REPORT TITLE: SAP PRQJECT RE RDS COST CATEGORIES
BINDING DATE -ACTUAL FROM X)0000C ThRU )00000(
REPORT NUMBER: 0618
PURPOSE: Lists SRF projects with actual binding commitments by Grant
Number, identifying the interest rate and the dollar amount
disbursed, by cost category
TYPE OF
INFORMATION: SRF Project Financial Data
The following information is provided for each State:
DATA ELEMENT: DESCRIPTION:
Grant-No The Financial Assistance Number assigned to identify
the grant
Name The Name of the local government that received the award
Interest Rate Interest Rate used for repayment of the SRF loan
CAT I Indicates the total dollar amount of assistance in cost
Category I. which is the portion of eligible project costs
required to provide secondary treatment or best
practible wastewater treatment technoIog
CAT II Indicates the total dollar amount of assistance in cost
Category II, which is the portion of eligible project costs
required to achieve treatment levels more stringent
than secondary
CAT lIlA Indicates the total dollar amount of assistance in cost
Category lIlA, which is the portion of eligible project costs
required for the correction of sewer system infiltration/
inflow problems
CATIIIB Indicates the total dollar amount of assistance in cost
Category lllB, which is the portion of eligible project costs
required for the replacement and/or major rehabilitation
of existing sewer systems
CXflVA Indicates the total dollar amount of assistance in cost
Category IVA which is the portion of eligible project costs
required for construction of new collector sewer systems
—
129

-------
SRF GICS Instruction Manual
SRF GICS NATIONAL REPORTS Exhibit 3.2.3
Page 31 of 32
REPORT TITLE: S PI DJECT RECORDSCOSTCATEGORES
BINDING DATE - ACTUAL FROM )00000C THRU )0000(X
REPORT NUMBER: 0618
DATA ELEMENT: DESCRIPTION:
CAT IVB Indicates the total dollar amount of assistance in cost
Category IVB, which Is the portion of eligible project costs
required for construction of new interceptor sewers and
transmission pumping stations necessary for the bulk
transport of wastewater
CATV Indicates the total dollar amount of assistance in cost
Category V , which is the portion of eligible project costs
required for construction of facilities to prevent and/or
control periodic bypassing of untreated wastes from
combined sewers in order to achieve water quality objectives
STORM-SEWER-COST Indicates the total dollar amount of assistance in the Storm
Sewer Cost category, which is the amount of assistance
provided for control of pollutant discharges from separate
storm sewer systems as defined in the Clean Water Act
NON-POiNT-SOURCE Indicates the total dollar amount of assistance in the Non.
Point Source Cost category, which is the portion of eligible
project costs which implements a management program
established under Section 319 of the Clean Water Act
ESTUARY-COST Indicates the total dollar amount of assistance in the Estuaries
Cost category, which is the portion of eligible project
costs which are used for development and Implementation of
a conservation and management plan under Section 320 of
the Clean Water Act
ST sulvii,IARY Indicates the total dollar amount of assistance provided
State-wide in each of the Cost categories
J IIT The total number of projects financed for al Cost categories
State-wide
130

-------
Exhibit 3.2.3
Page 32 of 32
PAGE 7
Rfl-Iti 0fl-0630
Ri m-OAT h 01-04-09 STAR REVOLVING flit PROGEAM
OVATE. NJ SOP PROJECT RECOR O S COST CATEGORIES
REGLWIs 02 OHCUC-DATE-ACTUAI. FROM 870103 ThOU 910409
WANT-It INTREST CAT 1 1T h CAT IIIAIT2I CAT EVAIT4) CAT V 176) NON-POINT-SI%CEIT BI
(01 ) NA Il ! RATE CAT 11111) CAT 1110( U) CAT IVSIT3I STORM-SIKER—COSTITA) ESflJART-COSTITC)
141704020 CR19 TSISiIP-ICOO 0.000 2.990.647
33,301 ,401
140731050 CAPE MAY ECIOflY NSA 0.900
22. 190,600
140770010 NEST PATERS5I OWWG 0.000 1 .03 0.150
160700010 UVINOSTOM. TOI IISNEP 0.000
14 ,562.034
140010010 IIS*R TOIRORIIP lO lA 0.000 5,170 ,600
144016010 OERNAROSYEUE ONESIG 0.000 4.930.640
-â 96
o 161020010 0ERKELET NEIW UO T O M 7.700
6 .121 .000
100074010 PRILUPSOISO, TONI 0 0.000 345.356
707.250
141070010 SOMERSET RARITAN VAt 0.000 0.010.641
000900010 STA fF O RD NSA 0.000 1 ,430,033
1600316)0 IMRREN. TO*ISHIP Of 0.000
6.379.504
140935130 NIOIITSTOIRI. OWSJGN 0.000
3.903.376
NJ IT tROMP! 170.453.401 10.937.441 30.316.736 0.600,000
145 ,411.379 12,199,607 169,005.159
WRITr 56
PROGRAM * CS, RIICINO-AKT-ACflML ‘ 0, Alt 0 11tE1C-DATE-ACflIAL NI T HIN THE USER SUPPLIED RANGE Alt RECORD-TYPE • C OR N
I .

-------
SRF GICS Instruction Manual
SECTION 4.0 SRF STATE OPTIONAL SYSTEM
Introduction The SRF State Optional System was developed to
assist States in the management of their project
level data under the State Revolving Fund (SRF).
The SRF State Optional System consists of two
subsystems: the SRF State Optional Data Entry and
the SRF State Pilot Optional Repc ing Systems.
These systems provide States with enhanced
reporting capaiilities through the use of the
existing GICS database.
Contents of This section describes the SRF State Optional Data
This Section Entry and the SRF State Pilot Optional Reporting
System. It will identify the system screens and
describe each of the related reports.
------
-
—
For Information On:
See Section:
See Exhibit:
Introduction to the
4.1
Introduction to
4.1.1
SRF State Optional
SRF State Optional
the SRF State
System and GICS
System
Optional System
Overview of SRF
4.2
SRF State
4.2.1
SRF State Optional
State Optional Data
Optional System
Data Entry System
Entry System Screens
Data Entry
Screens
-
Screens
The SRF State
4.3
SRF State
4.3.1
SRF State Pilot
Pilot Optional
Pilot Optional
Optional Reports
System Reports
Reports
and their uses
-
— -----
-
132

-------
SRF GICS Instruction Manual
4.1 INTRODUCTION TO SRF STATE OPTiONAL SYSTEM
The 1987 Water Quality Act phased out EPA’s Construction
Grants program and shifted responsibility of construction financing
to States through the establishment of the SRF program. The EPA
will award grants to States as seed money in establishing self-
substaining State Revolving Funds. Each SRF will provide loans and
other forms of assistance, except grants, to local goverr 1 ments.
The changes to the Construction Grants program altered the
reporting requirements at Federal, Regional and State levels. The
new information requirements were divided into the Nationally-
required data elements and State optional data elements. GICS was
enhanced in two phases to incorporate each set of data elements.
SRF GICS currently includes the Nationally required data
elements, associated National reports, the State optional data
elements and the SRF State Pilot Optional Reporting System. The
purpose of the SRF State Pilot Optional Reporting System
implementation was to develop reports from the SRF State Optional
data elements based on the the Pilot State’s Reporting Requirements.
The system provides an illustration of how one State, Arkansas,
chose to implement the State Optional Data Elements to meet State,
Regional and National reporting requirements.
The Office of Information Resources Management (OIRM) in
support of the Office of Wastewater Enforcement and Compliance
(OWEC) has developed a Pilot State Revolving Fund (SRF) Workstation
with the State of Colorado to provide for management and reporting
of integrated State and Federal data. OWEC has established an SRF
Workstation Workgroup to review, evaluate, and define requirements
for a standard SRF Workstation to be made available to all States
using the Colorado Pilot Workstation as a model. This will provide
States with the reporting capability for SRF financial management,
SRF program management and SRF project management. The
workstation could also provide for automated creation of SRF
reporting documents.
133

-------
SRF GICS Instruction Manual
Exhibit 4.1.1, SRF State Optional System and GICS, depicts the
SRF State Optional System Data Entry System Screens and the
reports that were developed through the SRF State Pilot Optional
Reporting System.
For more detailed information regarding the State Optional
System see the SRF State Optional Data Entry System Users Guide,
or the SRF State Pilot Optional Reporting System Implementation
Report.
134

-------
SRF STATE OPTIONAL SYSTEM AND GICS
EXHIBIT
4.1.1
SRF (OPTIONAL) MAIN
ru )u IRlIuruuu’4u-
PLANNING STAGE SCREEN 1
/ ‘POST AWARDffARGETING ’
oc s c J sTM pCiEEN
/ PLANISPECS HISTORY
1 PUS I AWAHUJIAHU1 I IN(5’\
- CONSTRJC11 N SCREEN )
I. .ana a.I . ..aan..
iri rt I P..RI rilD I A1T
riiuJt i I..uwIrLt i iu i
‘ PROJECT AMENDMENT ‘
AT /
PROJECT AMENDMENT
a r I kTA ,inr I
MB 4ORAN XJM OF
AG tvENT
SUBMITTAL DATES
STATUS OF
ACTIVE
PROJECTS
DATA ENTRY SCREENS
N )
KEY FI D HAM SC N
____________—
PRIORITY LIST!
L APPLICATION SCFEEPL
REPORTS
GICS
DATA
BASE
I
C,,
C ,’
IACTIVE PROJECTS
.PJSORtED BY PROJEC
NAME
APPLICATION
I,Irr D&1AT1r j
PERMITS & FACILITIES
F
P0LmCALDISIHk. 1 5
I
)
PHOJE T CUNSUL IAN I
I
PRQJECTCCS1S SCREEN
I
- ASSISTANCE TYPES
)
=- RI ON LINE PROJECT
. ........... Jl INFO ATION
‘]DISPLAY
‘j ffALiZATION
SRF PROJECT
IDENTIFICATION
DATA
SRF PROJECT
FINANCIAL DATA ‘
si
—. — ._ sc i
)
UI UI1 tN I bUMNV I1T
— rn rv 11 IS
DIAMEN E Nis
• TOTAL NIwnH PROJECT LQ N
• PROJECT IIAMENDMENIS
•FWOIU ii
HI PRIORFIV UST
ii FI JECISSc 1Ib
flu BYCON ONAL
m DISTRICT

-------
SFIF GIGS Instruction Manual
4.2 SRF STATE OPTIONAL DATA ENTRY SYSTEM SCREENS
The SRF State Optional Data Entry System was developed to
incorporate the SRF State Optional Data elements into the GICS
database.
Exhibit 4.2.1, SRF State Optional Data Entry System Screens,
identifies the SRF State Optional data entry screens, the type of
data entered on the group of screens, and the purpose of each group.
The screens can be classified as either Project Record or
Amendment Record screens. Additionally, the data entered or
maintained on each screen may be informational financial or
tracking.
136

-------
SRF GICS Instruction Manual
AREA:
PURPOSE:
SRF STATE OPTIONAL SYSTEM
This describes the basic screen layout of the optional
system. This system is divided Into two areas: the
Project Record and the Project Amendment Record.
137

-------
SRF GICS Instruction Manual
SRF STATE OPTIONAL DATA ENTRY
SYSTEM SCREENS
Exhibit 4.2.1
Page 2of7
AREA:
DATA ENTERED:
INFORMATION DATA
PURPOSE:
Data related to SRF projects, from project conception
to completion such as the projects’ State or Federal
Districts, and the key individuals Involved In the
project.
To maintain and provide basic SRF project related
Information for effective Project Management and
Reporting.
138

-------
SRF GICS Instruction Manual
F
SRF STATE OPTIONAL DATA ENTRY
SYSTEM SCREENS
Exhibit 4.2.1
Page 3 of 7
L
.4
AREA:
FINANCIAL DATA
DATA ENTERED:
PURPOSE:
Financial Data related to individual SRF Projects such
as cost and disbursement Information.
To maintain and provide financial data for effective
project management and reporting of the SRF funded
projects
139

-------
SRF GICS Instruction Manual
SRF STATE OPTIONAL DATA ENTRY
SYSTEM SCREENS
ExhibIt 4.2.1
Page 4017
AREA:
TRACKING DATA
DATA ENTERED:
PURPOSE:
Data related to the status, receipt and review of various
documents used n the planning, design, inspection and
- . construction process.
To maintain and provide milestone tracking information
of ndividua! SRF funded projects for effective Project
Management and Reporting.
140

-------
SRF GIGS Instruction Manual
SRF STATE OPTIONAL DATA ENTRY
SYSTEM SCREENS
ExhibIt 4.2.1
Page 5 of 7
AREA:
DATA ENTERED:
PURPOSE:
INFORMATION DATA
Non-financial data related to amending an SRF project
record.
To maintain and provide basic project SRF amendment
Information.
141

-------
SRF GICS Instruction Manual
SRF STATE OPTIONAL DATA ENTRY
SYSTEM SCREENS
ExhIbit 4.2.1
Page 6 of 7
AREA:
DATA ENTERED:
PURPOSE:
FINANCIAL DATA
Financial data related to admendments to SRF Projects.
To maintain and provide amendment estimate and actual
data on SRF projects.
142

-------
SRF GICS Instruction Manual
SRF STATE OPTIONAL DATA ENTRY
SYSTEM SCREENS
ExhibIt 4.2.1
Page 7 of 7
AREA:
DATA ENTERED:
PURPOSE:
HELP SCREENS
The system allows for on-line help access through PF1’.
The Help Screen describes each data field and what type
of information is entered in the field.
143

-------
SRF GICS Instruction Manual
4.3 SRF STATE PILOT OPTIONAL REPORTS
The seven SRF State Pilot Optional Report were developed in
conjunction with the State of Arkansas as part of the SRF State
Pilot Optional Reporting System Implementation. Exhibit 4.3.1, SRF
State Pilot Optional Reports, provides a sample copy of the reports
describes the purpose of the reports, type of information the reports
contain, and the data elements.
144

-------
SRF GICS Instruction Manual
Exhibit 4.3.1
SRF STATE PILOT OPTIONAL REPORTS Page 1 of 26
REPORT TITLE: ACT 1VE PROJECTS SORTED BY PROJECT NAME
REPORT NUMBER: SRO1
PURPOSE: Easy reference to identify active projects and the assigned
Project Manager and Engineer
TYPE OF
INFORMATION: SRF State Optional Proiect Data
The following information is provided at the State Level:
DATA ELEMENT: DESCRIPTION:
Project Number The Financial Assistance Identification Number assigned
to identify each pre-application, unsolicited proposal,
application and awarded grant or loan
Project Name The Project Name
Project Manager Identifies the person designated by the Municipality to
serve as the responsible contact for the assistance
agreement
Project Officer Official designated as the principle contact and is
resposible for performance and coordination of project
monitoring
Binding Commitment The dale of the target information defining the legal
Target Date obligation by the State to the local recipients
Binding Commitment The date of the actual information defining the legal
Actual Date obligation by the State to the local recipients
Award Code/Date The target or event code and date representing the
current status Final Award and Approval -
Applicant Community Name of the Applicant’s principal representative for
Represent a WWT Construction or SRF Assistance agreement
Consultant Identities the SRF Project’s consultant
145

-------
L.
DAYS S -U-ll
lU-Rh
STAT. . Al
1 0J 1C1 NOJECY
11 1111 1 NAN
. IRICATII £ MT LOIN ISCORD
PROJICT $1 101111 *1*110 ANIICANT CONSULTANT.
OTFICID CCISIHNNT Call DAT I CONUIITY IIPIIUNTATIVI
1* 1 ; 1, acru t
31*11 PIVOIVIIO P1*0
ACTIVI PROJECTS SOIlED I V PROJICT NAN
PROJECT
‘ M IAMI
DAli I
Exhibit 4.3.1
Page 20126
-a
A
a)
SINUSII AUSTIN. CITY OF
a i oezv
III11SCNIL S. ClIME
5111141.
lSI 6hlSS1NT01l. CITY OF
a 141113
1101 111 1*1 5TH. MA
I$ 1411ftI SENIUI. CITY 01
A INSTIl
110111 ! 1*15(11, NA
INOIN
AFFILIATED
111117 13 1 SIHIONVIL1E, Cliv IN
A 511111
STEVE IEI ISCNV. N
PIC1000NIN 111111*
151155115 SINCI0000 SAY. HWY 7
A 111111
I. J. PATIENSON,
AFFILIA IID (lOIN
•1I3 IIl (*1111*11. CITY 01
A 7 5 35
KEY CR01151. MAYOR
AFFIIIAIID (huN
lull,.,. CAVE CUT, CITY OF
a 515415
LOUIS N. SIIPIII.
ENVIIONIENIAL TI
151111031 COIlED $ IAUVIILI.
£ 151 1 11
NIX I SAYUSS, PU
IWIAFFEY, iomi I
5 15 11 1515 SEONEN. CITY OF
SII IISSIS 110111, CITY IN
A 511111
A 155035
NUTSON 151(111000.
DalE bail, MAYO
ICC IILLAIO CONSU
NAIIIIN3, J01*I I.
•1l11lI3I EIOICA INAINIS. CITY
S1S14lIII FAYITTEVIILI. CITY I
SHMIIZS ,aatisvlut, CITY I
0534113 , FAIIIIEVJU I . c ity •
11Sl0 IN FFFFFFF
S1Sll’.Ill FIIPPIN. CITY 0 ?
111111111 HACKETT. CITY IN
511111535 NaRUSOISS, CITY IN
511511031 HANRISON. CITY IN
115411111 HElEN SF 111115, CITY
511011535 MDXII. tIlT IN
111351111 JACKIONVIILI. CITY S
SISSISSIS 1101 1110111DM II I 5$
01111511 lAKE VILIaSI. CITY S
S 111111111 lITTLE POCK IADANI P
135116131 lITTlE POCK hUFFED F
SISSIISIS LOWELL. CITY IN
111117131 P10110TH INAIIN. CITY
111194111 MANILA. CITY 0?
119461515 MAUIIALL. CI I! 01
511515135 IOLSOISIM
111115031 1011111011. CITY U I
551111515 PINJITAIN Vilil. CITY
551511111 ISIJITAIN VIEM. CITY
555415115 011110. 10111 OF
515)44535 PAIAI01JID, CITY OP
551 116111 P1* 1 100 1, CITY OF
• 554$ 53• PlINY 310
11547 1131 PIaINvIIII. Cliv or
511555135 PUJNIVIILI. CItY IN
111011111 100113. CITY 0 ?
111111111 ‘MAlt!, CITY IN
55511015 ISEIIDAII. CITY OP .
• 111713515 5111111010. CITY IN
511116141 SNIIODALI. CITY IN
VENTER. DAVID
111511*. (110!
111531
551135 101631
A $410 11
A 141011
a SIIYiP
A 110411
A laSt ?)
A 5SS$1
A 5401 11
£ N0S ?
A 171011
A $11110
A 115151
A 141131
a SIDAF O
A $61135
A 550924
A STI llS
A S1I ?7
A •75 35
A $10955
A 141111
A 1356??
A 531331
A 141131
£ lIS 3I
A 151 135
A 79191$
£ 5451??
A 5311 11
A 515511
A 171511
A 1)1110
A 565015
A 515115
NICNAID SCHOININA
JAMES PIIIIUIST11I,
JAMES NIIIINIICH,
JAMES PIOIIHSICH.
110 115 lUCItE!, HA
CNEI’MIE UMNIS.
N. P. MADDOX, I I.
DAiSY NAINISS. 11*
S. F. ONIECK
JIll! I. FLIPPO.
II. ia. J0 101001 1,
C011&IV CAIII15N.
JACK A. 1110115. N
D C C III COIDITT. N
1 11111 COlDlY!, N
OLIN I I. 100111
JEAN PACI. MAY10
CLIF10ID VIACH. 11
MT VAISIIPOOL, N
111*1101 N01t*CX. N
SAlt! PEKUIN. CHA
JAMES CAIN. MAYaN
JAISS (*111, MAY10
JOHN 1 1*010 1 !. NA
LAIN! NATION, MAll
115111 NAIL, MAYO
PUS! 1. 1*01111.
MELVA FOHO. NAval
DILLY P. DEANS.
TOIl 1. ICALISTII
CIAI1I€1 5111101.
DALTON NAIU I. NA
*111011 PALMI
N. 1151101 all.
IICCIUUANI CSIU
CI( 1M HIlL AS I
CN 1M MI I I AISOCI
(NEIl NYU £13101
CHill NIU £51101
ENOINOEPINI SIIV
NAI01INI-NIll (IS
ICCIELLAIS CONNI
P11151011TH IIILLIA
1014.011 11411411
TOISOIIIP 51111011
ChIT 114114115.
NAL01S $ NATFIEL
ENVIP01IIENTAL YE
INVII01IIIITAL TI
$6lVil $ CARVES
IICDONANTN 111111*
ISNISEIIII. TAIlS
MAY13. IOSI IYN
INVIP01NVNTAI TI
ci i i lSIlSilIlS
101111115 1, TAIS
ICCIELLAIO C0 101
ICCI IIIA IS CWIIU
AT FIIIATID 114111
• aci I VIAT I
ICC000SIIN NILLIA
AIF10D 114114111
AIF10I 110114111
PIALONI I MAYFTIL
P11150011TH NILLIA
1111101151 1. YAMI
PINIIIIIEI. 1*111
1011111111. Thu
IIC1’ ”Il 111111*’
:

-------
SRF GICS Instruction Manual
Exhibit 4.3.1
SRF STATE PILOT OPTIONAL REPORTS Page 3 of 26
REPORT TITLE: STATUS OFAC11VE PROJECTS
REPORT NUMBER: SRO2
PURPOSE: Easy reference to monitor major milestone dates for active
projects
TYPE OF
INFORMATION: SRF State Optional Project Data
The following information is provided at the State Level:
DATA ELEMENT: DESCRIPTION:
Project Number The Anancial Assistance Identification Number assigned
to identify each pro-application, unsolicited proposal,
application, and awarded grant or loan
r ject Type Identifies the SRF State Project type
Project Name The Project Name
Project Manager Identifies the person designated by the Municipality to
serve as the responsible contact for the assistance
agreement
Binding Commitment The date of the target information defining the legal
Target Date obligation by the State to the local recipients
Binding Commitment The date of the actual information defining the legal
Actual Date obligation by the State to the local recipients
Award Code Date The target or event code and date representing the
current status of the Final Award and Approval
Construction Start The target or event code and date representing the
Code current status of Construction
Physical Completion The target or event code and date representing the
Code current status of the projected or actual physical
completion of the project
mit of Operations The target or event code and date representing the
Code current status of the initiation of operations
147

-------
SRF GICS Instruction Manual
-
ExhibIt 4.3.1
SRF STATE PILOT OPTIONAL REPORTS Page 40126
REPORT TITLE: STATUS OF ACTIVE PROJECTS (cart)
REPORT NUMBER: SRO2
DATA ELEMENT: DESCRIPTION:
Perform Certification The target or event code and date representing the
Code Date current status of the certification to EPA that the
project is actually meeting its performance standards
Admin Completion The target or event code and date representing the
Code Date current status 01 the request to the authorized auditing
authority to perform a final audit of the assistance
agreement
Audit Completion The target or event code and date representing the
Code date current status of the final audit of the assistance
agreement
148

-------
a)
Exhibit 4.3.1 ii
Dali I • -ll -Il
uNITs 541-1801 StAll RIVOLVINO 7 510 P Page 5 of 26 C)
sTall s 18 staiui or acuvi Psojicts
SINOINO C01IST PIT INIT Pa0J Pill *011111 £10 11 0
PUOIICT PIOJ P IOJICT POOJICT COPTtIIINNT DAIS AWARD 11*8! COLI!i OPSI C 1 ITIFICATION C01 LlYt COMPISI8
0301 5 1 TIPU N*II1 Iwlali l 1*161 ! ICIUaL c iii coot DAIS CONS DAli CONI 01ff £111 DAlI CONE cats COOt SATE
•as, ooss AUS tIN. CII ! 0? a 190629 * $20120 I 111111 1 $01211 1 $90111
S
1114901)1 1 111 1011. CIII 0 ? a 680921 A 13061 , A 611111 a 670921 1 $60911 I 590810
011890040 UNION. CIII il a sions £ 541114 8 1,1111 A 171911 1 $1192) I 091115 C
181817111 S INICIIVIII1. CITY 0 a llI lI A 111617 a bull A 161119 a 071119 a sssiii I 091631 0
011181131 atmcsslooo oat. son a •isos a •ziio a susie a susie N 161111 a siseis I •we l
•$ 1179 1 10 C*IINAGI. ciii or a no ii a 705115 a ssseit a osseit A 111116 A 111110 0
05181 11)1 cavu CIII. CIII or a eui se a sasais I easels T $10611 I 69M30 I 191111
sesuisi. £01115 I $*s$VILL I. a ;uiis a iasezs iio.sn, a 761901 a sosoti a suits
051611515 0501* 511. CII! 0? a ssi,io a stasis a $45111 a iooius a 060929 T 191619
011119115 eivsoi, CITY 0? a issue a sas is a asesis a issue 1 090650 7 hills
u.3 7..1. tiona spuuios. CIT a 190911 a Islill I 600110 1 105931 1 0909)0 1 191110
111161111 FAYS ITIVI ILE. CITI a 181911 a s izte I 051031 1 111111 1 191111 1 900455
111166111 78Y SITIVIU S. CIII a 191117 a 18111$ I us$11 1 111111 1 511111 1 911451 C
0111605). raTiTIlvIut. CII ! a 165411 a Us7 14 T 101111 1 181111 I 011 1) 1 1 911451
110119191 IF,???? a 711111 a 170111
511114131 1IIPPIN. CII ! OF a •ussi a oauss a siius a 110911 T 000930 1 591111
118111111 NaCEITI, CIII I, a 181911 a 115711 a easasi a 545185 a s;saz a si. u 11 15171$
111891111 *arnsssas. CITY or a assai’ a s iaii a 160111 A 181116 T 510111 1 095935
111181111 11*111111. CITY 0 ? a sis si a iis i 1 190111 1 911711 7 911701 1 191611 T 900430
111611111 115010 $111101. CITY a 111929 a 515526 A 565684 A 545614 1 $71618 a 575823 1 $91211
111671111 111111. CItY 0? A 051015 A 580110 1 191311 1 190111 I 911)11 T 591101
111111011 JaCRIOI*I1iE. CII! a 840915 a 010753 I 680910 1 000115 I 1659 )5 T 1911)1
511866010 1*11 11*19111011 II I I a 510129 A 58018) A $51001 A $51115 a ieiiis a 061119 7 $91911
111111111 1*1 VIUA15. CUT! a 541915 a 515515 1 $01011 T 051011 1 ShIll T 191111 1 111111
0180115)0 ill 111115 • 1*8*111 US$11 I $91111 1 191811 T 911111 1 911115 1 911715
111416111 111116 POCK UPPIO A 110916 a 511801 I 151111 a siseti 1 16S910
181611111 1011811. CITY 01 A 515980 A SaSh, I $91717 1 595181 T 900727
158117111 Is*IIOTN 111110. CIT A 150917 A 560519 A 111117 A 07*257 I $11111 1 $90331
110391111 ft*III IA. CIII or a $71931 1111931 1 590h10 I 595,15 1 hOShIS
111811111 I1*IIIIAL I. CII! or a 110911 A 151111 A $75129 A 171711 T 111719 7 111119
111111110 11100(0)11 A 111911 A 515915 a 661111 A 171111 1 1119)1 1 $51131
111111111 NONIllION. CIII 0? A 510682 A 515081 A 56 )1 11 a seas; A 111 115 a asiii I 091911
IsIsillIl 101111*119 VIIII. CITY a aisiis a 111321 A 161116 A 16110$ * $10100 *fl7IS00 I 191111
111111111 Iøh1!aIN VI ISI. CITY a •eo is A 671611 A 110611 A 110414 1 890806 I $90719
151671111 OPPEIO. 10511 0? * 000915 *1049111 N 181111 II 161111 1 111910 1 011611
050)81515 paoawuLD. CIII 0? a 751111 A 16 * 201 a 661111 A 141211 T 160111
111)16111 pia hOOt. CIII 0? a ;to zs a 110451 A 510111 A 110111 a 111111 1 111111
511419011 PUllEY $10 A 040927 A 1109)0 £ 170611 a a;se s 1 680625 1660925
111671110 PIIINVISN. CITY 0? * 1)0711 * suits a 01 101 1 a eiiss I 151019 I $90109
181111110 PIIJIEIYILII. CITY 0 a 071011 T 1111)1 1 191111 1 191111 1 911111 1 911111 1 911611
111816511 10611$. CITY 0? A 171111 a sussis 1 1109)0 I 110911 T 111911 I 691111 1 911610
014417111 haitI 1 CIII 0? a 511111 * $91315 A 545651 A 16111) T)h)0$II T 1119)1 I 91111)
011411111 115110*11. CIII 0? A 185910 A 111613 * 185614 a uiisi I $91151 I 191611
181111111 Ill 111111000. CIII CI 091111 191611 1 911111 1 11111$
111106141 1P 11180A1 1. CItY 0? a 560909 * 541111 1 US$11 a 140111 T 191311 T 091611
115411111 SUSAIIOAP Ill. A 171911 1 MIllS I $11915 1 59191$ T W ’1 T 111111 T 911911

-------
SRF GICS Instruction Manual
Exhibit 4.3.1
SRF STATE PILOT OPTIONAL REPORTS Page 6 of 26
REPORT TITLE: MEMORANDUM OF AGREEMENT SUBMIT1AL DATES REPORT
REPORT NUMBER: SRO3
PURPOSE: Target date monitonng repoil, used as a reminder to notify City
Officials of upcoming submittal of documents.
TYPE OF
INFORMATION: SRF State Optional Project Data
The following information is provided at the State Level:
DATA ELEMENT: DESCRIPTION:
Project Manager Identifies the person designated by the Municipality to
serve as the responsible contact for the assistance
agreement
Project Number The Financial Assistance Identification Number assigned
to identify each pre application, unsolicited proposal,
application awarded grant loan
Project Name The Project Name
Facility Plan The target or event code and date representing the
Receipt Code Date receipt of the facility plan
Plan/Specs The target or event code and date representing the
Receipt Code Date Milestone record used to track multiple plans and
specifications per project
UCS Receipt The target or event code and date representing the
Code Date receipt of the user charges system
SUO Receipt The target or event code and date representing the
Code Date receipt of the sewer user ordinance
Applic Receipt The target or event code and date representing the
Code Date receipt of an application for a WWT construction or SRF
assistance agreement in the State Office
150

-------
. , C l)
Exhibit 4.3.1 i i
Page7of26 0
C l )
(I )
1
C
a
0
OATh SI- U - I l h*IOAIOJI OP AUREEMEN! SLRIIIITAL DATES IEPWT PUtt I
REPRRT. 560-OS) II iTED SAT, RAISE 505*55 INSU 900*0*
STATEs AR SORtED IV PROJECT HAIt I
TACILITT PtAN-IPICS tiC) 315 APPLIC C
PROJECT PROJECT PROJECT PUN RECEIPT RECEIPT RECEIPT RECEIPT UCEIPT —
SANUER aIRIER CD DATE CD DAtE CD 0*11 CD DATE CD DATE

oussios n ut ILMEP. CIIT OP .1 59100) .1 69*00) •T 09500)
sooseons TuC EEUIIAN. CUT OP at OURS) .1 095001 •T 09 *00)
— s 0)01091)S IHA IICI HILLS. CITE OP uT 09*001 Ut 09500) •T 59*00) T 901410
(1) 90010)030 )&SIRIiiOD. LIT! OP UI 10011* T 900105 T 900)05
-s
AN ‘a IISICATES A DATE T hAI PAILS UIIIIIN THE HANIT DATES P IuS *1 On)
ISHI p m
SI l OS) Efl CRISITIM DETECTED IN MATISAL Sill
I -

-------
SRF GICS Instruction Manual
Exh bit 4.3.1
SRF STATE PILOT OPTIONAL REPORTS Page 80126
REPORT TITLE: ON-UNE PROJECT INFORMATION DISPLAY
REPORT NUMBER: SRO4 (this is an on-line display only)
PURPOSE: Quick on-line look at any project to see latest data in major
milestones fields
TYPE OF
INFORMATION: SRF State Optional Project Data
The following information is provided at the State Level:
DATA ELEMENT: DESCRIPTION:
Project Number The Financial Assistance Identification Number assigned
to identify each pre-application, unsolicited proposal,
application, and awarded grant or loan
Project Name The Project Name
Facility Plan The target or event code and date representing receipt
Receipt Code/Date of the facility plan
Facilities Plan The target or event code and date representing the
Revd Code/Date review of the facility plan
Binding Commitment The date of the target information defining the legal
Target Date obligation by the State to the local recipients
Binding Commitment The target amount c i the legal obligabon by the State
Target Amount to the local recipients
Binding Commitment The date of the actual information defining the legal
Actual Date obligation by the State to the local recipients
Binding Commitment The target amount of the legal obligation by the State
Actual Amount to the local recipients
Physical Completion The target or event code and date representing the
Code/Date projected, or actual, physical completion of the project
Performance The target or event code and date related to the target or
Certification event code contained in the Performance Certification
Code/Date
152

-------
SRF GICS Instruction Manual
Exhibit 4.3.1
SRF STATE PILOT OPTIONAL REPORTS Page 9 of 26
REPORT TITLE: ON-LINE PROJECT INFORMATION DISPLAY (corn.)
REPORT NUMBER: SRO4 (this is an on-line display only)
DATA ELEMENT: DESCRIPTION:
Plan/Specs: The Milestone record used to track multiple plans and
Receipt Code/Date specifications per project
Review Code/Date
Cumulative The cumulative amount of disbursements made under a
Disbursements Amount SRF Assistance Agreement as of the latest approved date
Cumulative The Cumulative Disbursements as a percentage of the
Disbursements Percent total project amount
Construction Start The target or event code and date related to the start
Code/Date of construction
Administrative Completion The target or event code and date representing the
Code/Date current status of the request to the authorized auditing
authority to perform a final audit of the assistance
agreement
Application Recd The target or event code and date representing the
Code/Date receipt of an application for a WWT construction or
SRF assistance agreement
Inspection Target or event code and date representing the current
Code/Date status of the most recent recognized on-site inspection
Percent Complete The percentage of construction estimated by the
consulting engineer to be physically complete as of
WWT Construction Certification Date
Initiation of Operation The target or event code and date related to the target or
Code/Date event code contained in the Initiation of Operations
Audit Completion The target or event code and date representing the
Code Date current status of the final audit of the assistance
agreement
153

-------
MORE
STATE REVOLVING FUND
ONLINE PROJECT INFORNATION
PROJECT NO: 050001900 NAME: STATE POLLUTION CONTROL AUTHORITY
FACILITES PLAN PLAN SPECS APPLICATION REC
RECD CD: DATE: RECD CD: DATE: CODE:
REV CD: DATE: REVD CD: DATE: DATE:
BINDING COPIIITHENT CUMULUTIVE INSP ErTION
TARGET DATE: DISBURSFJ4FZ IS CD: DATE:
AMOUNT: AMOUNT: PERCENT COMPLETE
ACTUAL DATE: PERCENT:
AMOUPr I’:
PHYSICAL COMPLETION CONSTRUCTION START INIT OF OPERATION
CD: DATE: CD: DATE: CD: DATE:
PERFORMANCE ADMINISTRATIVE AUDIT
CUTI FICATION COMPLETION COMPLETION
CD: DATE: CD: DATE: CD: DATE:
PRESS ENTER TO CONTINUE
Exhibit 4.3.1
Page 10 of 26

-------
SRF GICS Instruction Manual
SRF STATE OPTIONAL REPORTING SYSTEM
DATA ENTRY SCREENS
REPORT TITLE: CAPffALIZA11ON GRANT/AMENDMENTS WITH PROJECT
LOANS AMENDMENTS
REPORT NUMBER: SRO5
PURPOSE: Ties all loans and loan amendments to the capitalization
grant and capitalization grant amendments from which they
were made
TYPE OF
INFORMATION: SRF State Optional Project Data
The following information is provided at the State Level:
DATA ELEMENT: DESCRIPTION:
Grant Number The Financial Assistance Identification Number assigned
to identify the Capitalization Grant
Award Code Date The target or event code and date representing the
Final Award and Approval
Cumulative Award The cumulative amount of capitalization grant funds awarded to
the State
Funds Awarded The actual amount of funds awarded
Total Grant + 20% Total amount of capitalization grant funds awarded to
State Match the State + the 20% required State matching funds
Project Number The Financial Assistance Identification Number assigned
to identify each pre-application, unsolicited proposal,
application, and awarded grant or loan
Project Name The Project Name
Binding Commitment The date of the actual information defining the legal
Actual Date obligation by the State to the local recipients
Binding Commitment The target amount of the legal obligation by the State
Actual Amount to the local recipients
Loan Interest Rate Interest Rate used for repayment of loans for a
SRF-funded project
155

-------
Exhibit 4.3.1
0*71 19-Il—IS paIf
uelSuis l o s-Nh uai uivoivzt 11010 Page 12 of 26
StAll s SI UfltAIIZ*7l10I NAIII1#DJIIKIUNT$ 11011 10SJICI 10*II&’*IKIKIU$I5 l
TOTAL 01*111 0001 110 10*11
MAN! PIC010 *11*10 CIIIJLATIVI 1110$ I 117 17*11 PIOJICI CINIITIINT 111711131
1101510 TIN CI 0*71 *1 1*10 *11*1010 0 *7t h 1 1*10 ACTUAL PAtS
OATS *11011 1 1
101 11 1-MI CAP 11*117 * 111911 11,191,111 21.191. 111 31.53). III C01IKCTICUI 0. 5. 1.
11 1 1 1 1-UI *11110 7 913111
1110 10 CAP 1 1*111 MINI-Ill
MINI-IN CAP 10*117 TIlT PROJECT
11 1 11 1-Ni NOJICT * S OIlS) ISIS 1. 1 5 1 SIlTS PO IIUTI11I C15ITUO
011331-Ill PROJECT 7 761116 1. 0 4 . 3 1 1 1.201.931 11 11 1*10. CUT S F
707 PROJ !.119.3 1 1 1,3 1 1, 931
1110 10 CAP 11*117 IhlIhl-Ul
1 0111 1-NI CAP 10*111 A SWill Sill 1.111 1.151 11*11 ISLLUTIKI C10fI0
11101 1-9 11 *1010 A 101319
—‘ I MINI-Ill * 1 110 A 191314
107 0 1 110
NiNe-Ill PR0.KCT 7 1*1711 1.3 1 0.931 1,301.931 11011110*11. CIII 10
M I SI CAP NAN? 1115 5 1-9 11
MINI- UI CI ? 10*141 7 SWill II I
M I CAD MANY 111111-HI
IlMil-HI CAP 0 1*1 11 A 191114 3I.hlS.ihS 31.SSI.i0h 4l.S l4.hSi 11*11 P011111110 £011110
iIIlSI-93I *1110 A 091)1* ailS..
u s C , C I ? 10*111 hhIIl1-9)l
111111-991 CAP GIANT A 591616 I,Ilh,iiI l.SlS.ISI l.lIl.IhS *10*115*5 OIlY C l 11*110
111111-701 *1110 A 19161* 11.111
115 11 tSP MMI I •iliII— W
110*7 PIll
MT9NP SlIM CSSITIM SITICISS IN 11*1111*1110

-------
SRF GICS Instruction Manual
Exhibit 4.3.1
SRF STATE PILOT OPTIONAL REPORTS Page 13 of 26
REPORT TITLE: STATE REVOLVING FUNDTOTAL PROJECT RECORDS CHANGED
SINCE XX(XX(XX
REPORT NUMBER: SRO6
PURPOSE: To provide a listing of all data elements :lated to a SRF
Project Record
TYPE OF
INFORMATION: SRF State Optional Project Data and Nationally Required
Data Elements
The following information is provided at the State Level:
DATA ELEMENT: DESCRIPTION:
Grant Number . The Capitalization Grant serial number used to fund this
particular SRF Assistance Agreement
Type A code identifying the statutory category of projects assisted
by SRF
Project Step Code Code identifing the specific type of project undertaken
as part of the SRF Assistance Agreement
Name The name of the local government who received the award
Representative Name of the principal representative of the applicant for a
WWT construction or SRF assistance
Address The current address of the local government receiving the award
City The current City of the local government receiving the award
State The cur.ent State of the local government receiving the award
Zip The current Zip Code of the local government receiving the award
Description The title or description of the project for which EPA or
SRF support is requested
Amount Requested Estimate of the total funds requested to carry out the
proposed project during the current budget period
Funds The actual amount of funds awarded or decreased from an
Awarded assistance agreement to the applicant
-—
157

-------
SRF GICS Instruction Manual
Exhibit 4.3.1
SRF STATE PILOT OPTIONAL REPORTS Page 14 of 25
REPORT TITLE: STATE REVOLVING FUND TOTAL PROJECT RECORDS CHANGED
SINCE XX/XXJXX (cont)
REPORT NUMBER: SRO6
DATA ELEMENT: DESCRIPTION:
CAT I Portion of the el ible cost of a wastewater treatment
BPWTT construction or SRF project that is required to provide
“secondary treatment” or “best practicable wastewater
treatment technology”
CAT II Portion of the eligible cost of a wastewater treatment
>BPWTT construction or SRF project that is required to achieve
treatment levels more stringent than secondary
CAT lilA Portion of the eligible cost of a wastewater treatment
ui construction or SRF project that is required for the correction
of sewer system infiltration/inflow problems
CAT IIIB Portion of the eligible cost of a wastewater treatment
Rehab construction or SRF project that is required for the replacement
an/or major rehabilitation of existing sewer systems
CAT TVA Portion of the eligible cost of a wastewater treatment
Collection construction or SRF project that is required for construction of
new collector sewer systems
CATV Portion of the eligible cost of a wastewater treatment
Overflow construction or SRF project that is required for construction
of facilities to prevent and/or control periodic bypassing of
untreated wastes from combined sewers in order to achieve
water quality objectives
Total Project Cost The total estimated current cost of the project
Priority The priority points assigned by a State to a proposed project
List Points appearing on the State Project Priority List
Priority The priority assigned by a State to a proposed project appearing
List Rank on the State Project Priority List
Priority The year associated with the proposed project appearing on
List Year the State Project Priority List
158

-------
SRF GIGS Instruction Manual
Exhibit 4.3.1
SRF STATE PILOT OPTIONAL REPORTS Page l5of 26
REPORT TITLE: STATE REVOLVING FUND TOTAL PROJECT RECORDS CHANGED
SINCE XX/XX/XX (cont)
REPORT NUMBER: SRO6
DATA ELEMENT: DESCRIPTION:
State Receipt A target or event code and date representing the current
Application status of the receipt of an application for a SRF Assistance
Agreement by the State
Pre Close Conference Future data element
Assistance Acceptance A target or event code and date representing the current
status of the acceptance of the assistance agreement
Facility Plan - A target or event code and date representing the current
Receipt status of the receipt of the Facilities Plan
Facility Plan - A target or event code and date representing the current
Reviewed status of the review of the Facilities Plan
Infiltration/Inflow A target or event code and date representing the current
Analysis - Receipt stajus of the receipt of the Infiltration/Inflow analysis
Infiltration/Inflow A target or event code and date representing the current
Analysis - Review status of the review of the Infiltration/Inflow analysis
Sewer Systems A target or event code and date representing the current
Evaluation - Receipt status of the receipt of the Sewer System Evaluation
Sewer Systems A target or event code and date representing the current
Evaluation - Review status of the review of the Sewer System Evaluation
Operations and A target or event code and date representing the current
Maintenance status of the receipt of the Operations and Maintenance
Manual -Receipt Manual
Operations and A target or event code and date representing the current
Maintenance status of the review of the Operations and Maintenance
Manual -Review Manual
Plan of Operation A target or event code and date representing the current
- Receipt status of the receipt of the Plan of Operation
159

-------
SRF GIGS Instruction Manual
Exhibit 4.3.1
SRF STATE PILOT OPTIONAL REPORTS Page l6of 28
REPORT TITLE: STATE REVOLVING RiND TOTAL PROJECT RECORDS CHANGED
SINCE XXIXX/XX (cont)
REPORT NUMBER: SRO6
DATA ELEMENT: DESCRIPTION:
Plan of Operation A target or event code and date representing the current status
- Review of the review of the Plan of Operation
SUO - Feceipt A target or event code and date representing the current status
of the receipt of the Sewer Use Ordinance
SUO - Review A target or event code and date representing the current status
of the adaption of the Sewer Use Ordinance
UCS - Receipt A target or event code and date representing the current status
of the receipt of the User Charges System
UCS - Review A target or event code and date representing the current status
of the adaption of the User Charges System
Late P&S A milestone record used to track multiple plans and specifications
per project
I
Fin Env Imp A target or event code and date representing the current status of
the Final Enviromental Impact Statement
V/E Dollar The amount of Net Capital Dollars Saved by a Value
Amount S eci Engineering Project
V/E Report A target or event code and date representing the current status
Receipt, of the receipt of the Recipient’s Value Engineering Report
VIE Report. . A target or event code and date representing the current status
Review of the adaption of the Recipient’s Value Engineering
Report
Mtion Step The code and date identifying the current status and/or disposition
Code Date of a prospective project, application, or active completed project
for which assistance has been requested or given
Authorized Facility A unique number which identifies the wastewater treatment
Number facilities and the cognizant wastewater treatment authorities
related to a SRF project
160

-------
SRF GICS Instruction Manual
- -
Exhibit 4.3.1
SRF STATE PILOT OPTIONAL REPORTS Page 170126
REPORT TITLE: STATE REVOLVNG FUND TOTAL PROJECT RECORDS CHANGED
SINCE XX/XX/XX (cant)
REPORT NUMBER: SRO6
DATA ELEMENT: DESCRIPTION:
Capital Grant Year The year uf the capitalization grant used to fund this
particular Assistance Agreement
Region The EPA region of the local government receiving the
award
Congressional The Congressional District of the local government
District receiving the award
County The county of the local government receiving the award
Municipality Census A code indicating the population of the political jurisdiction
applying for assistance agreement
Permit The permit number relating to the SRF project
POP at Award A code indicating the population of the political jurisdiction
at the award of the assistance agreement
Interest Rate The interest rate used for repayment of loans for a project
funded through the SRF
Cum Disbursements The cumulative amount of disbursements made under a SRF
Assistance Agreement
State Rec Code Date A milestone target or event code and date used to track
latest disbursements per project
State Approval A milestone record used to track State Approval Date
for the latest disbursements per project
161

-------
SRF GICS Instruction Manual
Exhibit 4.3.1
SRF STATE PILOT OPTIONAL REPORTS Page 1801 26
REPORT TITLE: STATE REVOLVING RiND TOTAL PROJECT RECORDS CHANGED
SINCE XX/XX/XX (corn)
REPORT NUMBER: SRO6
DATA ELEMENT: DESCRIPTION:
State Pay Code Date A milestone target or event code and date used to track the
State Pay Code Date for the latest disbursements per project
Disbursement The current amount of the payments by the cognizant State
Amount office for a WWT construction or SRF assistance agreement
Binding Commit The date of the target Information defining the legal
Target Date obligations by the State to the local recipients
Binding Commit The amount of the target information defining the legal
Target Amount obligations by the State to the local recipients
Binding Commit The date of the actual information defining the legal
Actual Date obligations by the State to the local recipients
Binding Commit The amount of the actual information defining the legal
Actual Amount obligations by the State to the local recipients
Latest Bid Package A target and event codes and date representing the current
Receipt status of the receipt of the Latest Bid Package
First Bid Package A target of event code and date representing the current
Applied status of the review of the First Bid Package
Construction Start A target or event code and date representing the start of
Code’Oate construction
Start Last Contract A target or event code and date representing the start of
Ccda’Date construction for the last significant contract for the project
Percentage Construction The percentage of construction estimated to be physically
Complete completed as of the date shown in Construction Progress
Certificate
Construction Progress The date the authorized official certifies the percent of
Certificate project construction completed
-r
162

-------
SRF GICS Instruction Manual
Exhibit 4.3.1
SRF STATE PILOT OPTIONAL REPORTS Page 19 of 26
REPORT TITLE: STATE REVOLVING FUND TOTAL PROJECT RECORDS CHANGED
SINCE XX/XX/XX (cont)
REPORT NUMBER: SRO6
DATA ELEMENT: DESCRIPTION:
Physical Complete A target or bvent code and date representing the current
status of the projected or actual physical completion of the
project
Initiation of A target or event code and date for which operations are
Operation scheduled to begin or the actual date if the operations have
begun
Original Project The orginal target or event code and date representing the
Performance status of the certification to EPA that the project is actually
Certificate meeting its performance standards
Project The current target or event code and date representing the
Performance status of the certification to EPA that the project is actually
Certificate meeting its performance standards
Startup Service The target or event code and date representing the current
Start status of the projected or actual start of start-up services
at a WWT facility
Startup Service The target or event code and date representing the current
Completion status of the projected or actual completion of start-up
services at a WWT facility
Inspection Type A target or event code representing the current status of the
Co most recent on-site inspection
Inspection Date The date of the most recent on-site inspection
Percentage The percent of construction estimated by the inspector to be
Complete physically complete
Inspector The initials of the inspector of the most recent on-site
inspection
--
163

-------
SRF GICS Instruction Manual
Exhibit 4.3.1
Page 20 of 26
SRF STATE PILOT OPTIONAL REPORTS
REPORT TITLE: STATE REVOLVING FUND TOTAL PROJECT RECORDS CHANGED
SINCE XX/XXIXX (cont)
REPORT NUMBER: SR06
DATA ELEMENT: DESCRIPTION:
Multi Facility The unique number which idenify the Wastewater Treatment
Code/Date facilities and authorities related to a SRF project
Funding Status A code identifying the funding status of a project based on its
position on the accepted State Project Priority List
Indian Tribal A code identifying American Indian tribal applicants or
recipients of EPA financial asistance.
Special Project A code Identifying a grant, amendment, or other
Identifier Code assistance which includes funds for a variety of special
purposes
Consultant Code A code identifying the consultant responsible for the project
Project Manager The person designated by the Municipality to serve as the
responsible contact for the assistance agreement
Project Officer The official designated in the assistance/amendment as
the Agency’s principal contact with the recipient on a
particular project
NE Agreement A target or event code and date representing the current
Plan Rec status of the receipt of the engineering agreement for the
planning portion of the construction project
NE Agreement A target or event code and date representing the current
Plan Rev status of the approval of the engineering agreement for
the planning portion of the construction project
A/E Agreement A target or event code and date representing the current
Design Rec status of the receipt of the engineering agreement for the
designing portion of the construction project
164

-------
SRF GICS Instruction Manual
Exhibit 4.3.1
Page 21 of 26
SRF STATE PILOT OPTIONAL REPORTS
REPORT TITLE: STATE REVOLViNG FUNDTOTAL PROJECT RECORDS CHANGED
SINCE XX/XX/XX (cont) -
REPORT NUMBER: SRO6
DATA ELEMENT: DESCRIPTION:
NE Agreement A target or event code and date representing the current
Design Rev status of the approval of the engineering agreement for the
designing portion of the construction project
NE Agreement A target or event code and date representing the current
Const Rec status of the receipt of the engineering agreement for the
construction portion of the construction project
NE Agreement A target or event code and date representing the current
Const Rev status of the approval of the engineering agreement for
the construction portion of the construction project
Engr Comments A description of the engineer’s comments
Program Code A code indentifying the specific EPA Financial Assistance
Program applicable to this application or award
First Use A code identifying a project that is meeting the requirements
for 1irst use* of funds
Facility River A code designating the hydrologic planning area in which the
Basin Code discharge point of a wastewater treatment facility is located
State Engineer The initials of the State engineer who is assigned to the
project -
Small Comm A code indicating whether a WWT construction project may
be funded from the set-aside for alternative systems for small
communities for States with a rural population of 25% or
more, or for any non-rural state at the request of the Governor
and approval of Regional Administrator
Equivalency Identifies SRF projects which meet Title II equivalency
• requirements, as determine by the State in the Annual Report
165

-------
SRF GIGS Instruction Manual
- -
Exhibit 4.3.1
SRF STATE PILOT OPTIONAL REPORTS Page 22 of 26
REPORT TITLE: STATE REVOLVING FUND TOTAL PROJECT RECORDS CHANGED
SINCE XX/XX1XX (corn)
REPORT NUMBER: SRO6
DATA’ ELEMENT: DESCRIPTION:
Assistance Type A type of financial assistance provided for SRF projects
SRF Project Type A number identifying the statutory category of projects
assisted by the SRF
Sect 319 Proj Portion of the cost of a project assisted by the SRF
which implements a management program established
under Section 319 of Clean Water Act
Sect 320 Proj Portion of the cost of a project assisted by the SRF
used for the development and implementation of
a conservation and management plan under Section
320 of the Clean Water Act
Storm Sewers Amount of assistance provided from the SRF for
Wastewater Treatment works for control of pollutant
discharges from separate storm sewer systems as
defined in the Clean Water Act
Initial Administration The target or event code and date representing the initial
Completion Code/Date status of the request to the authorized auditing authority
to perform the final audit
Administration Completion The target or event code and date representing the’ current
Code/Date status of the request to the authorized auditing authority to
perform the final audit
Final Determination The target or event code and date representing the current
Letter Code/Date status of the sending of a final determination letter by
Action Official -
Final Audit Completion The target or event code and date representing the current
Code/Date status of the final audit of the Assistance Agreement
166

-------
SRF GICS Instruction Manual
Exhibit 4.3.1
SRF STATE PILOT OPTIONAL REPORTS Page 23 of 26
REPORT TITLE: STATE REVOLVING FUND TOTAL PROJECT RECORDS CHANGa)
SINCE XX XX/XX (cont)
REPORT NUMBER: SRO6
DATA ELEMENT: . DESCRIPTION:
Assist Agreement The target or event code and date representing the current
Close-out Code/Date status of the of the administrative close-out of the
assistance agreement
Identification Number A number which identifies the the SRF project
SRF Number A number which identifies the the SRF project where the
State Identification number is different from the project
number
IUP FY Intended Use Plan fiscal year
Annual Report The date of the most recent annual report submitted to the
EPA regional office for the SRF
Upper House/ The number(s) of the State Upper House/Senate District
Senate In which the applicant is located
Lower House/ The number(s) of the State Lower House/Senate District
Senate in which the applicant is located
A
167

-------
r
up i-. t Sil-ii01
111*1 t *0
MT-IUu 011054001 TiN, N
STIPISPIt I
S O ON (Ill: 11511111 PILl IN OPT
101* 1
ISP (lilt
— Ill Pt IILAOIiffiIA
CITY (IS It PI (ILAO IINII*
STATIII II , *0 ZIPI ISI I S IS?
0101 Stilt TISTIPS IF NP
01111 CIdDTUY OS I. I 04011*
*1 (1W/PALS (U I,
CAP NANT VIAl
PlOWS (lilt S I
LOIN lIST (lilt S S I I S
cOIlflI (Ill 11 111*0SLN IA
liii C1I01J1INI ,
PIUT S (Cut
1011.11 MC COIFAIt P0% C I (Ill, C i IS I .
FIIIIS ITATUSIt a nuT USEIPUI. USFS.
1001055 TI lL (lilt 0 50 SAIZNI ISI,
IPCL NOJ IIIflIt 11*11 EN01AZIt
tSUU ITNIISSII t
PUOJtCT 11155*01 1 t
NOJECTSuIct Il U Sl ,
NIT 1 1101(5110 (Is) ,
PIPSI *55 (0010 (lilt
CAT 1 001111 (TIlt
CAT II )SPWTT (Tilt
C I I 11 1* 111 (flIt
Cal 11Th U IN*0lYIlt
CAT IVA LOU ( ISIs
CU II I 1 1 (11W (TIlt
CAT V OVI IPINU UI
TOTA l. NJ COSTI lilt
P.1. POINTS INS). SIll
P.1. INS (I SIs
P.1. VI I I (Silt N
STATS USC APPUPII ,
NI CLOU CUNI Is
MOIST ACCIPT (lilt
NI IISTNI s IK I IVIS
PM PINS (hid,
I/I 05101 (lilt
OOSS (MOlt
0155 lI*liMLflOIPt
P 5.055 OP OPSUIJi
0% (hIlls
( S (MEl.
tAil PSI SPlit
Pill 1W 101(114 1
V/ I INST IAVIIH10II
VS S OPT 0KV (lA)
V/I OPT lETS (Nil:
NP AT *11100 (SIll.
11(1101ST IAT IITSIt
aM UPSOIUIIINTS .
IATIST SININWUNTSNU
stall PlC Cult
STATS APNOVAI.
STATS PAY LW/ST.
5101(1(11 AlIT
MIALI (1010(311:
11051 VALEICTI PV I ,
ASSIST TIPS (Lilt
5- NP PQOJ TVPHVCI :
SEC III P0OJ ITCh
SIC? UI PUOJflClt
510% 11001$ (TAP.
IH 1T AOMIN 10 L (II ).
*0 511W C10 L1II (Nil:
FINAL 51111 111110 (kIlt
FINAL 1(1111 (10101 INilt
ASSIST A llIS CLOSI (NI.
1100100 C00IIT TAOiST SATI ( I II ,
SWSIIU COIlS!? T A O i ST MSIJIT(SQI.
11105010 ll1T ACflML OATS (lilt 110121
SII0%U lflf MIIOIL NWIN SUIt 1.111.111
LATE ST iii N I UlCIlil):
PIJIT 515 *0 APPOSL 1It
CONI1IETION 11101 (hIlt
START LAST (10510 SILl.
PUCTIST COIST COI10(10l
UT 0000 CIII (341.
NYUCAL CWLITS (I S Is
11111 OF 00 50*11011 (Wilt
0111 NJ PlOP CIIT(kOl.
A lliS PSi PIIF CIUTIKAI:
STMT%P 1501 STAUINIs
51 1 01 W Shy COIPL(NSIt
• USTII ! IISPICTIOI( U
U10P TIPS cOOS.
INIP SATI
PIlLOW? £10101 t -
INIP SCT 0 1 ’
SINUS 0%I (T IN I154W-S -S II TISTI)S PItA PUS NP 5011
STAll PIVOLVIIS PINS
TOTAL NSJICT lIaMSI C L S 111(1 11111$
PAIl, 7
SAil. N -Il- I l
Exhibit 4.3.1
Page 24 of 26
lISP FT(VAIt
*5511*1 OPTS 10),
(JPPSS NO 1JII/S INATS:
lUll HOUSE/SENATI.
0)
0)
1, 15 1 .51 1
111111 511
11(1111
( (I II I
uNFIt
( 1171 t
(1171.
(MO”
(INS I.
A/h *0%I INNT PLAN I CC
A’S AM IIINNT 553101 SECt
*/ 5 *tIl1(N ! LOST PlC

‘IV ,
IEVt
‘IV :
lilT PIN

-------
SRF GICS Instruction Manual
SRF STATE OPTIONAL REPORTING SYSTEM Page 25 of 26
DATA ENTRY SCREENS
R EPORT TITLE: PRIORITY LIST PROJECTS SORTED BY CONGRESSIONAL
DISTRICT
REPORT NUMBER: SRO7
Shows ptiority list activity in individual Congressional
PURPOSE: Districts
TYPE OF
INFORMATION: SRF State Optional Project Data
The following information is provided at the State Level:
DATA ELEMENT: DESCRIPTION:
Congressional The Congressional District of the project
District
Project Number The Financial Assistance Identification Number assigned
to identify each pre-application. unsolicited proposal,
application, and awarded grant or loan
- Project Type Identifies the SRF State Project type
Project Name The project name
County The county of the project
Binding Commitment The date of the target information defining the legal
Target Date obligation by the State to the local recipients
Binding Commitment The target amount of the legal obligation by the State
Target Amount to the local recipients
169

-------
V
Exhibit 4.3.1
Page 26 of 26
1*111 • -u-ii UI, uo icTi scuits sy csiscsu lssi. sisTu lci
I t, SIS.TuIP ULSCTSI HEAL Till II
51515 . ll I I1S ST CTu iIII *I SISIIICT, PUOJICT HIll
1 11.111
- coiviuirnir
I1ISSIUO*L PROJICT PUOICT PUOJICT TASSEl
UI1UICT 11111 TIPS HIll csair s auaa
I SSSUDIS l . tITY 55 CUWUAS U III% HUll
I SNfl SSI I MADlUOS, Clii OP 1111 11 Il lYli IN,Sl l
11511 1 IF PUOJICT P15 DISTISCI I 2
I 11 16fl 13 1 NYMIT, CITY CF 5111 1 1 3P1S1 SHIllS
IIIUIICFPUOJICTFDI SI IICT I I
I SINUIIU IIOCIIUIL CII! CF NIOlI AN. 5Il
551111 OF NOJICT P15 DUTUICT I I
4 • SN I TII S £IiN iIIll , CITY CF J IU EUICH H u h A i ,lll
• IJUN I I S 1515111. CITY IF LAPATITTI 43111$ IHi lN
SaltS CF PUDJUCI’ P15 D1$IUICY 4 1
115* PIll
UOTIISI 1515 callYill I I IIC TII S I 11111*1 liii
L -

-------