HomeMy WebLinkAboutContract 19873 CITY SECRET
CON TRAC r Ila
7
Contract Agreements
. .... .........
. ... .......
w$etween
T.E., Inc
..........
.............. - Vi ..........
.. ...... ..
......... ...
and t ....
he; ,
aw
...... .....
City of Ft . : ... .
.... . . .... .
Worth
Water ... Dept .
G
TABLE OF CONTENTS
1 . AGREEMENT FOR H.T.E. , INC. LICENSED PROGRAMS
2 . SUPPLEMENT TO AGREEMENT FOR H.T.E. , INC . LICENSED PROGRAMS
3 . SCHEDULE A: Pricing and Payment Summary
4 . SERVICE AGREEMENT
5 . Attachment A: Fort Worth Water Department
HTE Package Modification Estimates
6 . Attachment B: Fort Worth Water Department
CIS Project
HTE Anticipated Modifications
7 . Original Request for Proposal
8 . Test Scripts
9 . HTE Response to RFP Requirements Checklist
AGREEMENT FOR H.T.E.,INC.LICENSED PROGRAMS
This Agreement for Licensed Programs(the"Agreement")is made as of the later of the dates set forth opposite the executions appearing at
the end of this Agreement,by and between:
H.T.E.,INC.tH.T.E.),a Florida Corporation,with its pcipal place of
business at 390 North Orange Avenue, Suiterin20(70, Orlando FL 32801
A N D
CITY OF FORT WORTH
("Customer"),a
business at
D66h*iPoTN9o'Aon°f Fort Worth, TX 76102
H.T.E.and the Customer agree that when this Agreement is signed by the Customer and accepted by H.T.E.,the following terms and condi-
tions will apply to any Licensed Program Materials(as defined below)offered under this Agreement when ordered by the Customer and the
order is accepted as provided herein.Under these terms and conditions,H.T.E.will(1)furnish such Licensed Programs to the Customer,(2)
furnish Licensed Optional Materials(as defined below)in support of such Licensed Programs(3)grant to the Customer a non-transferable and
non-exclusive license in the United States and Puerto Rico to use the Licensed Program Materials,and(4)provide program services,all as
described herein.The Customer agrees with respect to the Licensed Programs to accept the responsibility for(1)their selection to achieve the
Customer's intended results,(2)their installation,(3)their use,and(4)the results obtained therefrom.The Customer also has the responsibility
for the selection of use of,and results obtained from,any other programs,programming,equipment,or services used with the Licensed Pro-
grams.
Specific Licensed Program Materials may be ordered under this Agreement by(1)a supplement to this Agreement(the"Supplement")sign-
ed by the Customer,(2)a written order,specifying the Licensed Program Materials and the designated Machine(as defined below),signed by
the Customer,or(3)such other ordering procedure as shall be designated by H.T.E.for the specific Licensed Program Materials.H.T.E.will
accept any such order under this Agreement by providing the Customer a Supplement specifying the supplemental terms applicable to such
Licensed Program Materials. Upon receipt of the Supplement by the Customer. H.T.E. shall thereby grant a non-transferable and non-
exclusive license in the United States and Puerto Rico for Licensed Program Materials subject to the terms and conditions of this Agreement.
Use of the Licensed Program Materials or the first payment of charges due hereunder,whichever first occurs following receipt of the Supple-
ment,will constitute the Customer's acceptance of the supplemental terms specified in the Supplement.Any terms which this Agreement states
are to be specified by H.T.E.for a Licensed Program and/or related Licensed Optional Materials will be stated in the Supplement for that
Licensed Program.
I.DEFINITIONS
1.01.The term"Licensed Program"shall mean a licensed data processing program or set of programs or routines and subroutines,con-
sisting of a series of instructions or statements in machine readable form,and/or licensed data base consisting of a systematized collection of
data in machine readable form and any related licensed materials such as,but not limited to,flow charts,logic diagrams and listing provided
for use in connection with the program.
1.02.The term"Licensed Optional Materials"shall mean any machine readable or printed material not included in the Licensed Program
and which is designated by H.T.E.as available under license to Customers who have licensed the program to which such optional materials
relate.
1.03.The term"Licensed Program Materials"shall mean both the Licensed Optional Materials and Licensed Program.
1.04.The term"Machine"shall mean that machine,or machines as the case may be,designated in an applicable Supplement.
1.05.The term"Restricted Materials"shall mean any Licensed Program Materials which are labeled"Restricted Materials of H.T.E.."
1.06.The term"use"shall mean copying any portion of the Licensed Program Materials into a machine and/or transmitting them to a
0016machine for processing of the machine instructions,statements or data contained in such materials.
II.LICENSE
2.01.General.Each license granted under this Agreement authorizes the Customer to:
a.Use the Licensed Program in machine readable form on the Machine or Machines and in conjunction
therewith to store the Licensed Program Materials in,transmit them through or display them on,units associated
with the Machine;
b.Utilize the Licensed Program Materials in printed form in support of the use of the Licensed Program;
and/or
c.Copy or translate the Licensed Program Materials in machine readable form into any machine readable
or printed form to provide sufficient copies to support the Customer's use of the Licensed Program as authoriz-
ed under this Agreement.Licensed Program Materials provided by H.T.E.in printed form,microfiche or other
non-machine readable form may not be copied.Additional copies may be obtained under license from H.T.E.at
the charges then in effect.
With respect to Restricted Materials, the authorizations granted under the preceding paragraphs of this section are limited solely to the
following purposes:
a.Making modifications to the Customer's products and/or programs so that they will function with the
Licensed Programs to which the Restricted Materials apply;
b.Making modifications,subject to the provisions of the section entitled"Permission to Modify,"to the
Licensed Programs to which the Restricted Materials apply;and/or
c.Assisting the Customer in problem determination,problem source identification and/or problem resolu-
tion activities associated with the use of the Licensed Programs to which the Restricted Materials apply.
A separate license is required for each Machine on which the Licensed Program will be used,except as provided in the following subsection
entitled"Temporary License Transfer."
For any Licensed Program that is a data base,the license granted in this section is further limited to permit access to such data base exclusively
by the Customer.Except as provided in the section entitled"Protection and Security of Licensed Program Materials,"the Customer shall not
make or permit any manner of access to any form of such data base,or part thereof,for the purpose of making available to any other person
any data contained in such data base.
The customer shall not use,print,copy,translate or display the Licensed Program Materials,in whole or in part,unless expressly authorized
in this Agreement.
The Customer shall not reverse assemble or reverse compile the Licensed Programs in whole or in part.
2.02.Temporary License Transfer.The Customer is authorized to transfer a license to and to use the Licensed Program Materials on:
a.A back-up machine when the designated Machine or an associated unit required for use of the Licensed
Program is temporarily inoperable until operable status is restored and processing on the back-up machine is
completed;or
b. Another machine for assembly or compilation of the Licensed Program Materials if the designated
Machine and its associate units do not provide the configuration required for assembly or compilation.
2.03.Change in Designated Machine.The Customer may notify H.T.E. of the Customer's intention to change the designation of the
Machine on which Licensed Program Materials are to be used.The change of designation will be effective upon the date set forth in the confir-
mation of change in designated Machine furnished to the Customer in writing by H.T.E.
2.04.Additional Licenses.Each additional license for a Licensed Program and/or Optional Licensed Materials already licensed by the
Customer under this Agreement must be ordered as described herein.
For additional licenses,in lieu of distribution from H.T.E.,the Customer may elect to copy those Licensed Program Materials previously
distributed to that Customer by H.T.E. in machine readable form.The Customer may make such copy upon receipt of a Supplement issued by
H.T.E.which designates the effective date for the additional license requested by the Customer.The testing period,if any,for such additional
license will commence on the effective date for the additional license.Permission to copy granted in this subsection does not apply to Licensed
Program Materials provided by H.T.E.in printed form.
For certain Licensed Programs,H.T.E.may offer the distributed systems license option(the"Distributed Systems License Option"or
"DSLO")under which licenses in addition to the initial license(the"Basic License")may be obtained for a DSLO charge.When ordering ad-
ditional licenses for such a Licensed Program,the Customer must designate whether an additional Basic License or DSLO License is requested.
For each DSLO License,the Customer will:
1.Copy those Licensed Program Materials previously distributed in machine readable form to the Customer by H.T.E.under the Basic
License and use such copies on the Machine designated in the Supplement;
2.Provide problem documentation to H.T.E.through the location of the Basic License;
3.At H.T.E.'s request,recreate any problems at the location of the Basic License,if Local Service or Local Assistance as specified by
H.T.E.is available for the Basic License;and
4.Distribute to,install and test on the DSLO designated Machine any new release,correction or bypass provided by H.T.E.to the Basic
License designated Machine.
Program services and the warranty,if any,for the Licensed Program will be provided for DSLO Licenses only through the Basic License
location and there will be no testing period for the DSLO Licenses.
Unless the Customer designates another Basic License,notice of discontinuance of a Basic License shall be notice of discontinuance of all
DSLO Licenses for that Basic License.
III.TERM *See Schedule A for additional language.
This Agreement is effective from the date on which it is accepted by H.T.E.and will remain in effect until terminated by the Customer
upon one(1)month's written notice,or by H.T.E.as set forth in this section.This Agreement may be terminated by the Customer only when
all Licensed Program Materials licensed hereunder are discontinued and Licensed Program Materials have been returned to H.T.E. or
destroyed.
Licenses granted under this Agreement may be discontinued by the Customer upon one(1)month's written notice,except that,during the
testing period,the Customer may discontinue any license at any time upon written notice effective immediately.
H.T.E.may discontinue any license or terminate this Agreement upon written notice effective immediately if the Customer fails to comply
with any of the terms and conditions of this Agreement.
Notice of discontinuance of any or all licenses shall not be considered notice of termination of this Agreement unless specifically stated.
Notice of discontinuance of any Licensed Program shall be notice of discontinuance of the license and of all Licensed Program Materials
obtained in connection therewith.
IV.CHARGES *See Schedule A for applicable charges.
4.01.General.The charges applicable to each Licensed Program will be specified by H.T.E.and will consist of a one time charge,an
upgrade charge,periodic charges and any initial charge and/or process charges.
Periodic charges,which may be monthly,quarterly,semi-annual or annual,will continue until the Licensed Program is discontinued.
However,for certain Licensed Programs,H.T.E.may specify a consecutive number of payments after which further periodic charges will be
waived.
For certain Licensed Programs, H.T.E.may designate one(1)or more replacement Licensed Programs.When a Licensed Program is
discontinued and replaced by the Customer with an H.T.E.designated replacement Licensed Program,an upgrade charge as specified by
H.T.E.will apply.
Any additional charges for program services for Licensed Programs will be at H.T.E.'s then applicable hourly service rates and minimum
charges and such services will be provided under the terms and conditions of this Agreement unless provided under separate written agreement
signed by the Customer and H.T.E.
4.02.Commencement and Invoicing of Charges.Periodic charges will continence on the day,Monday through Friday,following the end
of the testing period,or ten(10)days after shipment of the Licensed Program by H.T.E.if there is no testing period,except as set forth below in
this sub-section.Charges for a partial month's use will be prorated based on a thirty(30)day month.Other periodic charges will not be pro-
r rated and are not refundable in whole or in part. Periodic charges will be invoiced in advance.
Unless otherwise specified by IL'i.G,one time charges,initial charges and Licensed Optional Material charges will be due on the day,
Monday through Friday,following the end of the testing period,or ten(10)days after shipment of the Licensed Program Materials by H.T.E.
if there is no testing period,or if such period has expired,except as set forth below in this sub-section.
For additional licenses for which lite Customer has elected to make copies pursuant to the section entitled"Additional Licenses"and for
which there is no testing period,periodic charges will be due upon the effective date for additional license designated in the Supplement.
Process charges will be due upon receipt by the Customer of the Licensed Program Materials to which such charges apply and are not
refundable even if the Customer discontinues[tie Licensed Program prior to or during the testing period.
Payment will be made as stated in the invoice,to the address of the principal place of business of H.T.E.as stated above,or to such other
address as may be stated in the invoice.
4.03. Applicable Taxes. In addition to the charges clue under this Agreement, the Customer agrees to pay amounts equal to any taxes
resulting from this Agreement,or any activities hereunder,exclusive of taxes based on II.T.E.'s net income.
4.04.Price Changes.Periodic charges are subject to change by H.T.E.upon thirty(30)days written notice to the Customer.Any changes
in periodic charges become effective on the first clay of the period which commences on or after the effective date specified in the written notice
to Customer.
Initial charges,one-time charges,process or upgrade charges,and charges for Licensed Optional Materials are subject to change without
prior notice except that such charges shall not be increased if,prior to lite date of the notice,(i)the Licensed Program Materials had been ship-
ped by H.T.E.,or(ii)the Customer had copied Licensed Program Materials pursuant to the subsection entitled"Additional Licenses." In
addition,if the Customer's written order was received by I I.T.E.prior to the announcement of such increase in charges,such charges shall not
be increased if,within one(I)month after the(late of notice,shipment of the Licensed Program Materials occurs or the Customer copies
Licensed Program Materials pursuant to the subsection entitled"Additional Licenses."
If charges are increased for any Licensed Program Materials,file Customer may discontinue them in accordance with the provisions of this
Agreement;otherwise, the new charges will become effective.
V.SHIPMENT
The estimated shipment date for the Licensed Programs will be specified by I I.T.E. ILT.E.docs not,however,represent or warrant that
such shipment date will be met.
H.T.E.will notify lite Customer of the type of program storage media required for shipment.Unless returnable or disposable media are
used,the program storage media must be provided by Customer or ordered from H.T.E.at the applicable charge. Except when otherwise
specified by H.T.E.,the Licensed Program Materials will be shipped to the Customer without shipping charge.Any special shipment requested
by the Customer will be at Custuncr's expense,unless otherwise specified by II.T.E..
N'1.RISK OF LOSS
If Licensed Program Materials are lost or damaged during shipment from II.T.E.,II.T.E,will replace them and program storage media at
no additional charge to file Customer.
If Licensed Program Materials are lost or damaged while in the possession of the Customer, ILT.E.will replace them at the applicable
charges to the Customer,if any, for processing,distribution,and/or program storage media.
�11. LICENSED PROGRAM T1-STING *See Schedule A for applicable testing.
For each Licensed Program,H.T.E.will specify the testing period,if any,during the Licensed Program will be made available for non-
productive use.The purpose of the testing period is to permit the Customer to determine whether the Licensed Program functions selected by
the Customer operate together and to assist the Customer in determining whether the Licensed Program meets the Customer's requirements.
The testing period will begin ten(10)days after shipment of the Licensed Program by I LT.F.,or on the effective date for the additional license,
unless otherwise specified.
The Customer may discontinue the Licensed Program,upon written notice effective immediately,at any time during the testing period,in
which event periodic charges,one-time charges, initial charges, upgrade and Licensed Optional Materials charges will not be due. Process
charges,however, will be payable and charges for shipment of the Licensed Program Materials will not be refunded. Unless such notice of
discontinuance is given,the Customer will be deemed,at the end of the testing period,to have decided to retain the Licensed Program under the
provisions of this Agreement.
In the event that the Licensed Program is used for productive purposes during the testing period,the Customer will notify I I.T.E.and(tie
testing period will be deemed to have ended as of the date upon which the Customer commences productive use.
Subsequent releases,if any,of the licensed Program,which have the same program number,will be made available to the Customer for
productive use and/or fest on the designated Machine while the Customer continues productive use of a previous release on that Machine and
pays applicable charges therefore The Customer has the right to decide whether fo install any such release or continue use of a previous release
having given due regard to the provisions of the sections entitled"Program Services"and"Patent and Copyright Indemnity."
In the event of discontinuance of the Licensed Program and subsequent re-ordering of the same Licensed Program for the same machine
there will be no testing period for the subsequent license.
VIII.PROGRAM SFRVICFS
For each Licensed Program,I-I.T.E.will specify the type(s)and period(s)of program services,if any,to be provided without additional
charge for a current release of the Licensed Program.Program services will commence at the beginning of the Licensed Program testing period
or,if there is no testing period for that license,when periodic charges commence or other charges are due.Program services will be subject to
the provisions of the section entitled "Specified Operating Environment."
g.ol.Types of Service
a.Central Service—When Central Service is specified,H.T.ti,will provide a service location which will accept documentation,in a formal
prescribed by H.T.E„indicating that a problcrn is caused by a defect in[tie licensed Program.H.T.E.will respond to a defect in the unaltered
portion of a current release of the Licensed Program by issuing defect correction information(such as correction documentation),corrected
code,notice of availability of corrected code,or a restriction or a bypass.Unless Local Service is also specified for the Licensed Program,the
Customer will he responsible for the preparation and submission of documentation to Central Service.
H.T.E.may also establish a center(the"Support Center")to provide the Customer with telephone assistance in problem diagnosis and
resolution.When a Support Center is established for a Licensed Program and a problem occurs which the Customer believes is related to the
use of a Licensed Program,Customer will contact the Support Center and will perform appropriate problem definition activities and remedial
actions,as prescribed by the Support Center,prior to any dispatch of an H.T.E.representative.H.T.E.may also offer other services through
e/p.Support Centers with or without charge,as applicable.
ogr and the diagnosis of the designated H.T.E.representative indicates the problemis caused by a defect in the unaltered portio a cur-
nt release the Licensed Program,the H.T.E.representative will perform the following problem resolution activities:
1.attempt to rect or bypass the defect by providing the Customer with correction information issued c Central Service,if
available;or
2.submit documentation to t entral Service,if specified as available;and,in any eve ,
3.if the Licensed Program is inoperable, ke a reasonable attempt to resole c problem by applying a local fix or providing a
bypass.
c.Local Assistance—When Local Assistance is specified and t omer encounters a problem,which the Customer's diagnosis in-
dicates is caused by a defect in the unaltered portion of a curvee f the Licensed Program, the Customer may request H.T.E.'s
assistance in resolving the problem.Such assistance,if request ,will be provide a designated H.T.E.representative and may be subject to
the availability of personnel.This assistance may includ ut not extend beyond,th lowing problem resolution activities:
I,attempting to correct or bypass t efect by providing the Customer with correction t rmation issued by the Central Service,if
available;or
2.assisting the Cus cr with preparing documentation for submission to the Central Service,is specific available;and,in any
event.
3.i c Licensed Program is inoperable,making a reasonable attempt to resolve the problem by assisting the Customer in a ing a
8.02. Program Services Period.Each type of program service provided for each Licensed Program will be specified as available:
1.until discontinued by H.T.E.with a tninimum of six(6)months'written notice;or
2.until a designated calendar date;or
3.during the testing period;or
4.for a designated number of months for each license.In the event the Customer discontinues a Licensed Program and subsequently
re-orders the same Licensed Program for the same machine,the service period then in effect will be reduced by the number of mon-
ths for which such service was previously provided.
When a subsequent release of a Licensed Program which has the same program number becomes available, H.T.E. may discontinue pro-
gram services lbr any or all prior releases by notice effective un the date stated therein.
For any Licensed Program,H.T.E.shall have the right to charge for any of the foregoing program services to the extent they are not
specified as provided without additional charge.Other types of program services may be specified by H.T.E.for a Licensed Program.
H.T.E.shall also have the right to charge for any additional effort which results from providing program services of an altered Licensed
Program or for a release which is not current.
IX.PERMISSION TO MODIFY
The Customer may modify any Licensed Program Materials in machine readable form and/or merge such materials into other Licensed
Program Materials to form an updated work for the Customer's own use;provided that,upon discontinuance of the Licensed Program,the
Licensed Program Materials will be completely removed from the updated work and dealt with under this Agreement as if permission to modify
or merge had never been granted.Any portion of the Licensed Program Materials included in such an updated work will continue to be subject
to all terms to this Agreement.
X.PROTECTION AND SECURITY OF LICENSED PROGRAM MATERIALS
The Customer will take appropriate action,by instruction,agreement or otherwise,with any persons permitted access to the Licensed Pro-
grain Materials so as to enable the Customer to satisfy the Customer's obligation under this Agreement.
All copies of the Licensed Program Materials provided by H.T.E.or made by the Customer including translations,compilations,partial
copies within modifications,derivative works and updated works are the property of H.T.E.and may not be distributed by the Customer to
any other persons,including other licenses of the Licensed Program,without H.T.E.'s prior written consent.The Customer will reproduce and
include the H.T.E.'s prior written consent.The Customer will reproduce and include the H.T.E.copyright notice on any such copies.
The Customer will maintain records of the number and location of all copies of the Licensed Program Materials and will notify H.T.E.in
writing if the original or any copy of the Licensed Program Materials will be kept at a location other than that of the Machine designated in an
applicable Supplement.
The Customer will insure,prior to disposing of any media,that any Licensed Program Materials contained thereon have been erased or
otherwise destroyed.
The Customer will not provide or otherwise make available Licensed Program Materials in any form without H.T.E.'s prior written con-
sent except to Customer's employees,ILT.E.'s employees,or other persons during the period they are on the Customer's premises for purposes
specifically related to the Customer's authorized use of the Licensed Program Materials.
XL LICENSED PROGRAM SPECIFICATION
For each Licensed Program which is warranted,H.T.E.will publish,at the time that Licensed Program becomes generally available,a
document entitled"Licensed Program Specifications."Such Licensed Program Specifications may be updated by H.T.E.from time to time
and such updates may constitute a change in specifications.
XII.WARRANTY
Each Licensed Program which is designated in a Supplement as warranted will conform,when shipped to the Customer,to the Licensed
Program Specifications which are in effect for that Licensed Program at that time,provided the Licensed Program is properly used in a
Specified Operating Environment.If the Customer believes that(here is a defect in a Licensed Program such that it does not meet its Licensed
1 Program Specifications,the Customer must notify H.T.1:,while program services arc available for the program.I I.T.E.docs not warrant that
the functions contained in a Licensed Program will meet the Customer's requirements or will operate in the combinations which may be
selected for use by the Customer or that the operation of the Licensed Program will be uninterrupted or error free ert�ret-afl7+regraxrdefeeb
wiit-bc-correc tcd. e
All other Licensed Programs will be distributed on an"AS IS"and WITH ALL FAULTS"basis without warranty of any kind either
express or implied.
SEE ADDITIONAL WARRANTY TERMS ON SCHEDULE A. save and except
THE FOREGOING WARRANTIES ARE IN LIEU 01�ALL OTHER WARRANTIES,EXPRESS OR IMPL ^ ,tNetttBtt1e;Bt T
(3/NOT LIMITED TO,TI IF.IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
XIII.SPECIFIED OPERATING ENVIRONMENT
Each Licensed Program is designated to operate on one or more designated Machine types and,in most instances,in conjunction with
other designated equipment and programs.The Licensed Program Specifications for each warranted Licensed Program will state the environ-
ment in which the Licensed Program is designated to operate.For Licensed Programs distributed on an"AS IS"basis,the Specified Operating
Environment will be stated in a notice of availability of the Licensed Program.
Program services for a Licensed Program used in other than a Specified Operating Environment arc subject to limitations occasioned by
the differences between the Specified Operating Environment and the Customer's operating environment and by the extent of the local H.T.E.
representative's knowledge of the Customer's equipment and programs.Such program services will be subject to the following conditions:
1.When performing Local Service or Local Assistance,H.T.E.'s obligation is limited to having the local H.T.E.representative apply a
reasonable effort to provide program services as described in the applicable portion of the section entitled"Program Services."Furthermore,
the local H.T.E.representative will only be expected to operate a Machine designated in the Supplement. H.T.E.will have the right to charge
for any additional effort required to perform these program services.
2. Central Service will only respond to defects which will occur when Central Service operates the Licensed Program in a Specified
Operating Environment.
XIV.LIMITATION OF REMEDIES
H.T.E.'s entire liability and the Customer's exclusive remedy shall be a-s follows:
In all situations involving performance or non-performance of Licensed Programs furnished under this Agrccement, the Customer's
remedy is(1)the correction by H.T.E.of Licensed Program defects,or(2)if,after repeated efforts,H.T.E.is unable to make the Licensed
Program operate as warranted,the Customer shall be entitled to recover damages to the limits set forth in this section.
For any other claim concerning performance or nonperformance by H.T.E.pursuant to,or in any other way related to,the subject matter
of this Agreement and any Supplement hereto,the Customer shall be entitled to recover actual damages to the limits set forth in this section.
H.T.E.'s liability for damages to the Customer for any cause whatsoever,and regardless of the form of action,whether in contract or in tort
including negligence,shall be limited to an amount equal to the one-time charge paid for,or any charges which would be due for twelve(12)
months' use of,the Licensed Prograrn that caused the damages or that is the subject matter of,or is directly related to,the cause of action.
Such charges shall be those in effect when the cause of action arose and shall include any initial or process charges paid to FLT.E..This limita-
tion of liability will not apply to claims for copyright infringement of for personal injury or damage to real or tangible personal property caused
by H.T.E.'s negligence.
In no event will H.T.E.be liable for any damages arising from performance or non-performance of the Licensed Program during(he
Licensed Program testing period or for any damages caused by the Customer's failure to perform the Customer's responsibilities,or for any
los(profits,lost savings or other consequential damages,even if I-LT.E.has been advised of the possibility of such damages,or for any claim
against the Customer by any other party except as provided in the section entitled "Patent and Copyright indemnity."
^ XV.PATENT AND COPYRIGItT INDEMNITY *See Schedule A for new section.
\, fJ or copyriglit in (he United States or Puerto Rico and,subject to the limitation of liability set forth in the section entitled"Limi n of
V Remedies," . E.will pay all costs,damages and attorney's fees that a court finally awards as a result of such claim.To y for such
defense and payme», c Customer must:
I.give M.T.E, prompt writte lice of any such claim;and
2. allow H.T.E. to control, and fully coo to with FLT.E. in the defense and . ated settlement negotiations. However, if the
damages attributable to a claim of infringement of a p tin the United States ire"
Rico may exceed such limitation of liability,the
Customer may elect to defend against the claim provided that E.may participate in the defense andJor agrees to any settlement of
such claim.
The Customer agrees to allow H.T.E.,at H.T.E' ption and expense,if su lain has occurred or in I I.T.E.'s judgment is likely to
occur,to procure the right for the Customer t - uinuc using(he Licensed Program Ma Is or to replace or to modify them so that they
become non-infringing:and, if neither tc foregoing alternatives is available on terms%vhic farrreasonable in H.T.E.'s judgment, upon
written request,the Customer wi urn the Licensed Program Materials to I L'I'.G;and,for Licensed rams whose total charges are fully
paid,the Customer may rve a credit as established by I I.T.E..
FLT.: all have no obligation with respect to airy such claim based upon the Customer's modification of the erased Program
Matei,iaVs or their combination,operation or use with data or programs not furnished by 1I.T.E. or in other than the Specified'Operating
lin ironme+; 12's cia 4c obligalion to?lie Cusiomer regarding lFkc
XVI.RETURN OR DF_STRUC-FION OF LICENSED PROGRAM MATERIALS
Within one(1)month after the date of discontinuance orally licensed granted hereunder,unless the requirement is waived by H.T.E.,lire
Customer will certify in writing to II.T.E.that through the Customer's best effort,and to the best of the Customer's knowledge,the original
and all copies of the Licensed Program Materials received from H.T.E. or made in connection with such license have been returned or
destroyed.This requirement will apply to all copies in any form,including translations or compilations or partial copies within modifications,
derivative works and updated works,whether partial or complete,and whether or not modified or merged into other program materials as
authorized herein.Upon prior written authorization from H.T.E.,however,the Customer may retain a copy for archival purposes only.
The requirement to return or destroy will apply to a licensed data base;it will not apply to individual pieces of data obtained by Customer
from such data base and which constitute a minor portion of such data base.
When the Customer has licensed a new version of a Licensed Program,which carries a different program number,the Customer may
retain the prior version of the Licensed Program for a period not to exceed three(3)months following its date of discontinuance,to be used
only if a defect in the new version prevents its use.During this period,the Customer will pay only the applicable charges for the new version of
the Licensed Program.Within one(1)month following this three(3)month period,the Customer will certify in writing to H.T.E.that through '.q�
the Customer's best efforts,and to the best of the Customer's knowledge,the original and all copies of the prior verson received from H.T.E.
or made in connection with such prior version have been returned or destroyed as set forth above.
XVII.ADDITIONAL PRODUCTS AND SERVICES
In addition to the Licensed Program Materials and program services provided under this Agreement,H.T.E.offers other products and
services at separate charges under applicable written H.T.E.agreements.H.T.E.and the Customer agree that such products and services can-
not be the subject of an oral agreement.
XVIII.MISCELLANEOUS
18.01.Minding Agreement.The individual signing this Agreement and any Supplement thereto on behalf of Customer and Customer war-
rant that the execution and delivery of this Agreement and any Supplement have been duly authorized by all necessary action,that the Agree-
ment and any Supplement thereto are valid and binding obligations of Customer and that the execution delivery and performance of this
Agreement will not constitute a breach,violation or default under any articles of incorporation,by laws,decree,order,governmental permit,
license,agreement,indenture or instrument to which Customer is subject.
See Schedule A for new 18.02.
1146 IlFiQF WFitlell vaAgen,of 14-T-_E. Any attempt;a
18.03.Notices.Any notice required or permitted hereunder shall be deemed properly given at the time it is personally delivered or mailed
by certified mail,return receipt requested,to the address specified hereinabove of the party to be notified.Either party may change its address
for receiving notices by giving notice thereof in compliance with the terms of this sub-section.
18.04.F,ntire Agreement.This Agreement constitutes the entire Agreement and there are no representatives,conditions,warranties or col-
lateral agreements,express or implied,statutory or otherwise,with respect to this Agreement other than as contained herein.This Agreement
may not be modified,omitted or changed in any way except by written agreement duly signed by persons authorized to sign agreements on
behalf of[he Customer and of H.T.G.
18.05.Force Majeure.H.T.E.is not responsible for failure to have fulfilled its obligations under this Agreement due to causes beyond its �0
control.
18.06. Gentler. Terms referred to in the masculine shall include the feminine and the singular shall include plural, unless otherwise
specified.
18.07.Applicable Law.This Agreement shall be governed by the laws of[he Slate otAbTIQT—Texas.
18.08.Venue. In the event of suit by the Customer under[his Agreement against H.T.E.,then the venue of such suit shall be in rent
County, I4exide and the Customer hereby waives whatever rights he may have in the selection of venue.
Texas
`j1`"✓l Fg.
18.10.Attorneys Fees.The Customer shall promptly pay all costs of 1 I.T.E.of collection of any of the liabilities or enforcement of any of
[he obligations under this Agreement,including reasonable attorneys'fees and legal expenses(including attorneys'fees and legal expenses in
any appellate or bankruptcy proceeding).
18.11.Severability.If any of the provisions of this Agreement shall be deemed illegal,invalid,unconstitutional or unenforceable by any
court of law having competent jurisdiction,such decisions shall not invalidate or negate the other remaining provisions of this Agreement.
18.12.Section I leadings.The section headings provided in this Agreement are for convenience only and shall not be deemed It part of this
Agreement.
THE CUSTOMER ACKNOWLEDGES THAT HE HAS READ THIS AGREEMENT,UNDERSTANDS IT,AND AGREES TO ME
MOUND MY THE TERMS AND CONDITIONS.
IN WITNESS WHEREOF, the parties have hereunto set their hands on this,
date of H.T.E., INC.
in the presence of the following
two witnesses
As to H.T.E., INC. By:
D nnis W per, Vice President
August 31, 1993
Date:
As to Customer Name of Customer(typ or brint)
ATTEST:
By:
w ity Secretary
Date:
October 19, 1993
APPROVE TO,PM AN LEGALITY:
Assistant ity Attorney
Headquarters:
One duPont Centre,Suite 2000,390 N.Orange Ave.,Orlando,FL 32801 (407)841-3235
Application Solutions for Government x
SUPPLEMENT TO AGREEMENT OF H.T.E.. INC. LICENSED PROGRAMS
BY AND BETWEEN H.T,E., INC. and CITY OF FORT WORTH
SCHEDULE A
DUE UPON:
COMPLETION FINAL, SYSTEM
CONTRACT CONTRACT DELIVERY/ PROCESSING ACCEPTANCE
PRODUCT TOTAL EXECUTION AS INCURRED TRAINING TESTING
LICENSE FEES ill $ 362,400,00 362,400.00 $ $ $
Water Billing Package
Utility Billing
Land Management
Cash Receipts
Accounts Receivable
Loans Nodule
Work Orders/Fac, Kant.
Contract Bill. Module (2
.Implementation Assistance 51,600.00 141400,00 14,400.00 28,800.00
TRAINING
1304 hours @ $85/hr 110,840,00 21,710.00 27.?10.00 55.42D.00
CONVERSION
588 hours 9 $85/hr 45.980.00 4,958,00 44,982.00
CONTINUING EDUCATION
480 hours @ $85/hr 40,800,00 10.200,00 30.600,00
CASHERING SYSTEM 30,000.00 15,000.00 15,060.00
REPORT ANALYSIS
240 hours @ $B5/hr 20,400.00 10,200.00 10,200.00
MODIFICATIONS-UT-ESTIMATE
756 hours @ $85/hr. 64.260.00 40.162,50 8,032.50 16,065.00
--------------------------------------------------------------------------
?36.280.00 $ 489,070.50 $ 40,800.00 $ 50,142.50 $ 160,267.00
--------------------------------------------------------------------------
--------------------------------------------------------------------------
ll')This total includes an extended warranty period of one year from Utility Billing Final System Acceptance Testing, This
total also includes monthly planningiwrap-up sessions or training assistance - four days month for 18 months. Every
effort will be made to assign Rose Anne Hunter to this task.
p/"HTE warrants that they will support and maintain identified product modifications until they are placed into the base
Utility Billing product,
i2)Contract Billing Module is currently under development.
HTE is offering the City of Fort Worth a five 15i year maintenance contract at a cost of $189.000 with $31.800 to be
remitted upon contract execution and $151,200 to be remitted one year following the Final System Acceptance Testing Date.
For the initial five (5) year service fee, HTB offers to provide the City with one week of training each of the first
5 nears at no charge at the NTE Orlando facility. If the City desires training to be at the FWWD facilities, the City
will be responsible for actual travel and iiving expenses,
HTE grants the City the right to interview and approve HTE personnel assigned to the project at the City's expense.
City may request additional training hours at any time through final system acceptance at a rate of $85/hr. After final
system acceptance, additional hours can be requested at the then prevailing hourly rate charged by HTE for such services.
HTE warrants that the project start date will occur no later than two weeks from the acceptance of the Implementation
Plan provided there is no unreasonable delay in the acceptance of the implementation Plan from its completion.
HTE will provide a performance bond. This bond costs HTE $[1,168. If this bond is requested by the City the bond fee
will be passed to FWWD and due at contract execution.
SUPPLEMENT TO AGREEMENT OF H,T.E., INC. LICENSED PROGRAMS
BY AND BETWEEN H.T.E„ 3C. and CITY OF FORT WORTH
SCHEDULE A 'continued)
HTE agrees to make any of the anticipated modifications. as listed in Attachment B, for the Citv of Fort Worth at no
charge prior to final system acceptance.
Actual reasonable travel and living expenses are in addition to the prices quoted for the applications.
It is understood that no two systems and filestructures are exactly alike and there may be a need for some manual
conversion efforts to take place along with the electronic conversion. however Utility Billing and Land Management
conversion will not exceed the amount indicated above.
Cashiering System will consist of: 5 Register Tape Vaiidator,,Printer Model 53, 5 IPI2 Cash Drawers wiPlastic Monev
Trays; 5 OCR hand-held or wedge Scanners Model 833, 5 Steel Money Trays w/lock S lid, and 5 initial start-up packages,
Modifications will be controlled by the HTE "System Change Request" form which will be prepared for the Customer by the
HTE Project Manager responsible for that module, HTE will proceed on the °SCR° when the signed °SCR° is returned with
the Customer's authorization. Please see Attachment A which lists the identified modifications. Payment is due as
scheduled above.
Final System Acceptance Test: Upon completion of installation of the Utility Billing system i,e.g. software and
hardware! or no later than ninety 1901 days after productive use, a thirty 1301 day final system acceptance test shall
commence. If the system operates at the level of effectiveness as stated below and the specifications inciuded in HTE's
Proposal and associated documents; for ninety-five percent l95k} of the time during the test period. it shall be deemed
to have met the City's final acceptance test criteria for system performance.
with the assumptions and factors listed below, HTE will guarantee the system response time and batch processing time as
follows using the IBM AS/400 System Performance Tools i5738-PTI, Response time for data entry and inquiry is defined as
the time elapsed between pressing the carriage return or enter key and the appearance if the data recuested on the same
screen,
System Response Time: With 130 native active workstations t52561 and 244 non-native active workstations (32101 and based
on a peak usage of 65 native and 60 non-native AS/400 based simultanecus tasks being performed, the system shall respond
in one second or less 85$ of the time for normal functions as noted below. Data accessed on a less routine basis such as
online updates and file openings shah average response times in the i-2 second range.
Normal Functions Requiring One Second Response Time:
1. Customer Inquiries Service address profile
- Customer profile
2. Account Activation
3. Account Transfer
4. Termination of Water Services *'t
5. Deposit Calculation
If Customer opts to use 12 months history option on deposit calculation. the range could be from I-3 seconds.
6. Cash Receipts Entry
1, Deferred Payment Calculation and Arrangements
P, Look for Delinquent Account
9, Turn off/Turn on Fireiines
10. Solid Waste Rate Inquiries and Investigations
!l, Solid Waste Route Information
12. Cancel Rebili
13. Processing Rechecks
*}t 11/4/9 - Included in each of these functions is the verification and creation of of Work Orders. The user may
experience up to a 3 second response time for this portion of these functions.
Batch Processing Time: The systems shall produce nightly cycle billings in eight 18) hours or less,
Assumptions and Factors:
1. The database contains 3 years of history with 1 metered service and 3 flat rate services averaging 7,000 accounts
per nightly update.
2. The system has 44 disk drives 42,7Gb�,
3. The system has 3B4Mb of memory i6x64bi.
4, The test excludes when the system is being used far backing op, loading, heavey Query, E-Mail, PC Support. non-IBM
PC's development generation or the response times from non-native workstations and native workstations accessing the
IBM mainframe.
5, The response time test does not include react- communication time.
6. The test shall be run with oniv the contracted system and application software resident on the machine. Also, no
substantial changes are to be made in the IBR A,34c0 Operating System which would affect response time.
SUPPLEMENT TO AGREEMENT OF H.T.E.. INC. LICENSED PROGRAMS
BY AND BETWEEN N.T.E., INC. and CITY Of FORT WORTH
SCHEDULE A iContrnued)
The City shall notify HTS of the system acceptance or of any deficiency or non-conformity within ten IID) days after the
end of the final system acceptance period. If HTE does not receive this notice within ten (10) days, the acceptance test
will be deemed satisfactory.
Replacement of Non-Performing Components: If the City notifies HTE in writing before, or within ten (1001 days after the
test period, of any newly provided component failing to meet the criteria set forth herein other than cabling, NTE shall
at the request of the City, facilitate the replacement of the non-performing component at no cost to the City in order to
meet the level of effectiveness.
The following items are attachments to the contract:
Test Scripts
List of Modifications
List of Modifications Guaranteed from Other Clients
Completed Requirements Checklist
Test Script Video Tape
Request for Proposal
During the term of this Agreement and for a period of twenty-four (24i months after termination of this Agreement, the
Customer may not offer to hire or in any way employ orcompensate any of the employees of HTE or persons who have been
employed by HTS within the immediate past twenty-four i24) months without the prior written consent of HTE.
4W HTE encourages the full use of its integrated series of applications to maximize information efficiencies within the City
of Fort Worth. In addition to the applications above, HTE will offer a Professional Services Contract to the City to
include its full line of integrated software packages, custom modifications and any future application needs.
During the course of the implementation of the HTB products involved in this contract, several activities will be
conducted exclusively by the HPE personnel, If the need arises and outside services (sub-contracts) are required, HTE
will notify the City, to identify a potential Disadvantaged Business Enterprises {DBE) which HTE will give preferential
consideration for providing the applicable services,
MODIFICATIONS/CHANGES TO STANDARD LICENSE AGREEMENT
'SECTION III. TERM. Add:
Default: If the City fails to comply with any term or condition hereof. HTE shall give written notice stating with
particularity the term or condition that the City has failed to comply with. The City shall cure or commence to cure
such failure within 90 days from receipt of written notice. If the failure cannot be cured within the 90 day period, the
City shall continue to proceed diligently to cure such failure. In the event the City is unable to cure such failure
within the stated 90 day period, or fails to continue to proceed diligently to cure such failure, HTE may discontinue
any license or terminate this Agreement upon written notice effective upon receipt of same.
'SECTION XII. WARRANTY. HTE Warrants the product will perform as represented and specified in the attachments including:
the test scripts, completed requirements checklist, test script video tape, and modifications list.
'SECTION XV. PATENT AND COPYRIGHT INDEMNITY.
Patent Infringement: It is mutually agreed and understood that without exception the contract prices provided for herein
include all royalties or costs arising from patents, trademarks and copyrights in any way involved in the work. NTE shall
/'indemnify and save harmless the City from any and all claims for infringement by reason of the use of any such patented
design, device, material or process, or any trademark or copyright in connection with the work agreed to be performed
under this contract, and shall indemnify the City for any costs, expense, or damage which it may be obliged to pay by
reason of such infringement any time during the prosecution of the work or after completion of the work, provided,
however, that the City will assume the responsibility to defend any and all suits brought from the infringement of any
patent claimed to be infringed upon as a result of any modification that the City may have made to the licensed program.
City kgrees to give HTE prompt written notice of any such claim of patent infringement and allow HTE to control and
agrees to fully cooperate with HTE in the defense and all related settlement negotiations.
If the City is required to turn over the license program materials to HTB, HTE agrees to refund to City all payments
made hereunder, including but not limited to the cost of the licnese program together with any operation, maintenance
and training expenses incurred by the City.
SECTION XVIII. MISCELLANEOUS, SUBSECTION 18.02.
Assignment: Neither party hereto shah assign, transfer, sublet, convey, or otherwise dispose of this contract or
rights, title, or interest in or to same without the prior written consent of the other party, which consent shall not
be unreasonably withheld.
SECTION %VIII. MISCELLANEOUS, SUBSECTION 1B4O3. NEW PARAGRAPH:
If there is a conflict between documents the Supplement and Schedules will control.
Prices quoted above will be honored through September 30; 1993.
SUPPLEMENT TO AGREEMENT FOR H.T.E.,INC. LICENSED PROGRAMS
AND BRTY Or E �R Wj "IN(the"Customer")
1. Licensed Program Specifications and
Specified Operating Environment
AS/400 Utility Billing AS/400 Loans Module
AS/400 Land Management AS/400 Work Orders/Facility Management
AS/400 Cash Receipts AS/400 Contract Billing Module
AS/400 Accounts Receivable
II. Licensed Optional Materials(if any):
N/A
Ill. DSLO License: [ayR ] [not applicable]
IV. Designated Machine.
IBM AS/400 Model F70
V. Charges(as indicated by checking applicable box):
[X]One Time Charge:$ payable as follows:
See Schedule A
Op1b
[ ]Upgrade Charge:$ N/A
[ ]Periodic Charge:$ N/A payable[monthly]
[quarterly] [semi-annual] [annual]
( ]Initial Charge:$ N/A
N/A
[ ]Process Charge:$
[ ]DSLO Charge:$ N/A
[ ]Program Storage Media Charge:$ N/A
N/A
[ ]Special Services Charge:$
V1. Estimated Shipment Date:
HTE warrants the code will be shipped within 2 weeks of contract execution,
with the exception of the Contract Billing Module.
VII. Shipping Charge payable by[H.T.E.][Customer].
Special Shipping Charge payable by[H.T.E.] [Customer].
N/A
VIII. Testing Period: 30 days starting with the initial training session on each applicatior
IX. Warranty(according to applicable box as checked):
[X]Warranted as set forth in the Agreement.
[ ]AS IS
X. Program Services to be provided(check applicable box,complete period and provide description of Special Services,if any):
A.Type
[g] Central Service for period of 12 months from UT Final System Acceptance Testing.
[ ] Local Service for period of
[ ] Local Assistance for period of
[ ] Support Center for period of
B.Special Services:
[ ] Support commencing upon delivery of the Licensed Program to the Customer.All Licensed Programs will be installed
on a "best efforts;basis by both parties.
] Other as follows: This contract contemplates the use of standard licensed programs
specified. Any modifications thereto shall be provided for on a time and
materials basis by separate agreement, except as listed on Schedule A.
XI. Additional Licenses(if any):
A.Description:
B.Effective Date:
C. Basic License or Distributed Systems License Option
(indicate appropriate item):
IN WITNESS WHEREOF, the parties have hereunto set their hands on this,
date of
Signed,sealed and delivered
in the presence of the following
two witnesses:
As to Customer (Customer)
ATTEST:
By:
011 ON
Date: August 31, 1993
ICity Secretary
As to H.T.E.,INC. H.T.E.,
By:
Dennis J. W pper, Vice President
Date: October 19 1993
APPROV D O FORMANA LE ALITY
Assistant C ty AttorneyAssistant'City Manager
AW
Headquarters:
390 N. Orange Ave., Suite 2000, Orlando, FL 32801-1693 • (407) 841-3235
Application Solutions for Government
SERVICE AGREEMENT
SECTION 1
1. 1 IDENTIFICATION
This agreement between H.T.E. , Inc. (HTE) and City of Fort Worth
Water Department (Company) located at 1000 Throckmorton, Fort
Worth, TX 76102 , provides for Standard Software Service as
defined in Section 2 . 3 for the following HTE System(s ) and/or
Product(s) : AS/400 Utility Billing, Land Management, Cash
Receipts, Cash Receipts, Accounts Receivable, Loans Module, Work
Orders/Facility Mangement, Contract Billing Module.
1.2 TERM OF AGREEMENT
The five years of service which is provided by this Agreement
job, shall begin twelve ( 12 ) months following the date of acceptance
of the Utility Billing Final System Acceptance Testing as defined
in Schedule "A" of the Supplement to Agreement for H.T.E . , Inc.
Licensed Program of even date herewith.
1.3 SUMMARY
This Service Agreement provides to the Company:
NEW SOFTWARE - During the covered period, the Company will
receive each new Enhancement to the Standard Software that is
issued for the System(s) and/or Product(s) listed in Section 1 . 1 .
UPDATED DOCUMENTATION - Each new Standard Software release will
be accompanied by user and system documentation, reflecting the
software Enhancements .
STANDARD SOFTWARE - HTE will correct any problems encountered in
the Standard Software during the term of this Agreement.
A HOT-LINE SERVICE - An exclusive Hot-line is established for
consult-by-phone service to Client Services Department . A senior
technical staff member is available to answer any questions or
discuss system problems of concern to the Company.
INVOICE - The Company will be sent an invoice for the Standard
Awn, Software Service.
1.4 FEE
The five year prepaid fee for the Service ( for those
System( s ) and or Product(s ) listed in Section 1 . 1 ) is
$189 , 000 . 00 .
1 . 5 This document is composed of Section 1 and Section 2 .
SECTION 2
2 . 1 TERM
This agreement extends for a period of sixty months . Upon
the beginning of paid Software Service and in the event of
conflict with the terms of the License Agreement, the terms
of this Service Agreement shall govern.
2 .2 CHARGES AND TAXES
The Company agrees to pay all charges due under this
Agreement . The fee is due and payable at the prior to the
beginning of contract period. If HTE ' s assistance is
requested by the Company to correct a suspected error in the
Standard Software program logic or documentation, and it is
ultimately determined by HTE that no such error exists , the
Company shall compensate HTE for its services . Travel and
personnel time will be charged at HTE ' s established hourly
rate of $85 . 00 per hour. Additionally, compensation will be
expected for any reasonable living and travel costs .
2 .3 SUPPORT
HTE ' s policy is to make improvements in its Standard Software
on a regular basis in order to maintain its timely
applicability and competitive market ability. To this end,
HTE may, from time to time, make changes in operating
procedures , programming languages, general purpose library
programs , timing accessibility techniques , types of hardware
supportability, and other related programming and
documentation improvements . HTE shall provide to the
Company, as updates, at no additional charge, and on a timely
basis, the program logic and documentation for such Standard
Software Enhancements .
2 . 3 . 1 In the event the Company notifies HTE that it suspects
an error in the program logic or documentation which prevents
the continued accomplishment of the principal computing
functions of the System(s ) and/or Product(s ) , HTE shall use
its best efforts to confirm the existence of such error. If
ow' the existence of such error is confirmed to be in the
Standard Software, HTE shall correct it as part of its
obligation hereunder. If it is ultimately determined by HTE
that no such error exists, the Company shall compensate HTE
for its services . This compensation shall be based upon
HTE ' s hourly rate of $85 . 00 per hour, plus reimbursement for
reasonable travel and living expenses .
2 . 3 . 2 HTE ' s policy is to acknowledge oral or written
requests from the Company to provide assistance in
identifying and detecting problems , errors, and malfunctions
arising in connection with the Company ' s use of HTE ' s
computer application software systems . To assist HTE in
implementing its policy, the Company shall confirm, in
writing, an oral request for specific assistance within ten
( 10 ) days after such oral request is made . The Company shall
furnish to HTE adequate supporting documentation and details
to substantiate and to assist HTE in the identification and
detection of problems , errors , and malfunctions , arising from
the Company' s use of the System(s ) and/or Product ( s ) .
2 . 3 . 3 If an Enhancement, provided to the Company under this
Agreement, is dependent upon coding of a previous Enhancement
which the Company does not have, upon request, HTE will
provide assistance by mail or telephone in order to establish
coding that will permit continuity between the Company ' s
operating system and the new Enhancement .
t 2 . 3 . 4 The Company agrees to notify HTE of the need to have a
previous Enhancement in order to install a current
Enhancement .
2 . 3 . 5 In the event the Company requests any support other
than that included under the terms of this Agreement,
depending upon the availability of its personnel , HTE shall
use its best efforts to furnish it in accordance with the
current standard billing rates .
2 .4 COMPANY'S OBLIGATION
The Company acknowledges that the continued integrity of the
System( s ) and/or Product( s ) is dependent upon installation in
the program logic and documentation of all updates to the
System( s ) and/or Product(s ) which are provided by HTE to the
Company .
2 .5 REPRESENTATIONS OF COMPANY
The Company acknowledges HTE ' s representations that HTE has
expended substantial sums in creating its Systems and
Products , incurs substantial additional expense in
maintaining them, and as a result, has and will continue to
have substantial proprietary interest and valuable trade
secrets in them.
2 . 5 . 1 The Company further represents and warrants that it
shall not ( 1 ) at any time sell , assign, or otherwise transfer
eV'� HTE System( s ) and/or Product( s ) , parts of the System( s )
and/or Product( s ) , or updates, changes , improvements or
enhancements to the System( s ) and/or Product ( s ) , or parts
thereof , or ( 2 ) provide to any third party any support
described in this Agreement for the System( s ) and/or
Product( s ) . The Company shall hold in confidence the design
specifications and associated documentation of the System( s )
and/or Product ( s ) and shall disclose the System( s ) and/or
Product( s ) in confidence only to, and shall authorize the use
of the System( s ) and/or Product ( s ) in confidence only by, its
regular employees . Company further acknowledges that, in the
event of a breach or threatened breach by the Company of the
provisions of this paragraph, HTE has no adequate remedy in
money or damages , and, accordingly, shall be entitled to an
injunction against such breach or threatened breach .
2 . 5 . 2 The Company agrees that all rights granted in this
Agreement shall be cumulative and that no specifications in
the Agreement of any specific legal or equitable remedy in
the event of the breach or any provisions of this Agreement
shall be construed as a waiver of , or prohibition against,
any other legal or equitable remedy for such breach . The
waiver of any breach of any provision of this Agreement, or
of any remedy for any such breach, shall not preclude HTE
from thereafter exercising any rights ( including any remedy
previously waived) it has under this Agreement for the same
or any subsequent breach. If the Company waives any remedy,
then it should be bound by its waiver in accordance with
established law.
2 . 5 . 3 The representations and warranties shall survive the
execution of this Agreement, the delivery of any documents
and all transactions contemplated by this Agreement, and the
termination of this Agreement .
2.6 ASSIGNMENT
Neither this Agreement nor HTE System( s ) and/or Products ( s )
nor any rights granted by this Agreement to the Company shall
be assigned, transferred or otherwise disposed of by the
Company, in whole or in part, without the prior written
consent of HTE .
2 .7 LIABILITY
Because of the difficulty in ascertaining damages , it is
agreed that HTE liability to the Company for any losses or
damages, whether direct or indirect arising out of this
Agreement, shall not exceed the total amount billed and
billable to the Company, in no event shall HTE be liable for
any indirect, special , or consequential damages , economic
® loss in connection with, or arising out of this Agreement.
This paragraph shall supersede any paragraphs of this
Agreement which are inconsistent with it .
2 .8 SEVERABILITY
Each provision of this Agreement is severable from all other
provisions of this Agreement and, if one or more of the
provisions of this Agreement shall be declared invalid, the
remaining provision of this Agreement shall nevertheless
remain in full force and effect, provided, however, if
Paragraph 2 . 5 shall be declared invalid. Company shall
execute as soon as possible, a supplemental Agreement with
HTE which grants to HTE to the extent legally possible, the
protection afforded by said Paragraph .
2 .9 NON-EMPLOYMENT OF HTE EMPLOYEES
During the term of this Agreement and for a period of
twenty-four ( 24 ) months after termination of this Agreement,
the Company may not offer to hire or in any way employ or
compensate any of the employees of HTE or persons who have
been employed by HTE within the immediate past twenty-four
(24 ) months without the prior written consent of HTE .
2 . 10 GOVERNING LAW
The Agreement shall be governed by and in accordance with the
laws of the State of Texas .
2 . 11 AMOUNTS
All amounts referred to herein or otherwise payable pursuant
to any term of this agreement shall be United States of
America Dollars .
2 . 12 FINAL AGREEMENT
This Agreement supersedes all prior Agreements and
understandings between HTE and the Company relative to
support services for the System( s ) and/or Product(s ) and
shall not be changed orally. No change or attempted waiver
of any provision of this Agreement shall be binding unless
expressed in writing and signed by the party against whom the
same is sought to be enforced.
2 . 13 HEADINGS
The headings or titles of the Paragraphs in this Agreement
are for convenience only, are not a part of this Agreement,
and shall not be used as an aid in the construction of any
provision hereof .
2 . 14 COUNTERPARTS
All,
This Agreement may be executed in one or more counterparts ,
each of which shall constitute a single document .
2. 15 SIGNATURE
The parties, each acting with due authority, have executed
this Agreement by setting forth their respective signatures :
IN WITNESS WHEREOF, he partih hereunto set their hands on this
qtk, date of
Authori o the C t;�/_
Authorized by TE
Signature ure
Ass ' stant City Manager Dennis J. W' 1,er
Vice President/Finance
Date: October 19, 1993 Date: August 31, 1993
ATTEST:
City Secretary Contract Authorization
,//)�/ g - 9�
APPROVED S FORM AND LEGALITY: Date
�, Assistant Ci ttorney
MA-6 fER FILE-1
ACCQUNTMG.2
YRAfi`4VVRlA1d0MPUENC WORKS-1111 City of Fort Worth, Texas
xAIER nuMINISiAfayor and Council Communication
ENGINEERIN
DATE REFERENCE NUMBER LO(i NAME PAGE
09/07/93 C-13986 60BILLIN I
1 of 2
SUBJECT PURCHASE OF CUSTOMER INFORMATION AND BILLING SYSTEM AND
ACQUISITION OF CONSULTANT SERVICES
RECOMMENDATION:
It is recommended that the City Council:
1. Approve $2,876,932.00 for the purpose of replacing the current Water Department
Customer Information and Billing System, and
2. Authorize the City Manager to execute a purchase contract in the amount of
$1,031,755.00 with HTE, Inc., for a new Customer Information and Billing software
package and five year extended service agreement, and
3. Authorize the City Manager to execute various contracts with IBM in the total amount of
$1,306,416.00 providing for purchase of an AS/400 F70 computer and related services
and equipment and including $60,272.00 for the first year maintenance fees, and
4. Authorize the City Manager to execute a contract with MICON, Inc., in the amount of
$316,000.00 to provide technical assistance in managing the implementation of the
system.
DISCUSSION:
The Water Department's Customer Information and Billing System, which was developed in-
house in 1974, contains all data files that allow Fort Worth to maintain account information, bill
and collect payments from approximately 140,000 water, wastewater and/or solid waste
customers. The system is used not only by the Water Department, but provides customer
information to other City departments, such as Fire and Police.
In January of 1993, the City contracted with MICON, Inc., to assist the Water Department in
determining feasible alternatives to the aging current system. After extensive product testing
and reference verification, the recommended software vendor was determined to be HTE, Inc.,
at a cost of $842,755.00. These costs include the purchase of a basic product package, various
modifications, license fees, software for cash receipts, cashiering equipment and services for
conversion of data, training and a prepaid five-year extended maintenance agreement.
The HTE software operates on an IBM AS/400 computer. In addition to the purchase of an
AS/400 computer, contracts with IBM will provide various AS/400 system software. The City
will also be contracting with IBM for AS/400 support which includes access to the IBM's
recovery center in the event of the loss of operations; other IBM contracts provide for installation
of air conditioning, cabling, electrical power wiring and environmental equipment. Table 1 details
the IBM costs associated with their contracts. Operating the new billing system on this
minicomputer will also release disc space on the City's mainframe computer for other City
computer needs.
0 Printed on recycled paper
City of Fort Worth, Texas
Mayor and Council Communication
DATE REFERENCE NUMBER LOG NAME PAGE
09/07/93 C-13986 60BILLIN 2 of 2
SUBJECT PURCHASE OF CUSTOMER INFORMATION AND BILLING SYSTEM AND
ACQUISITION OF CONSULTANT SERVICES
Due to the complexity of replacing the system, the services of technical experts are included in
this project. The scope of work for MICON, Inc., will be to manage the implementation of the
system by developing and monitoring system test procedures, data conversion loading and
interfaces to existing systems. MICON, Inc., will be responsible for ensuring the system is free
of defects and suitable for the use intended. The cost for this service is $316,000.00.
The total estimated cost to install the system is $2,687,932.00, which includes $75,998.00
for miscellaneous hardware and other equipment, $146,763.00 for building renovation costs,
and possible contingencies such as additional software package modifications and training
expenses. The project will realize a pay-back in 35 months based on cost savings and cost
avoidance benefits of $1 ,102,000.00 a year.
The contractors have complied with the City's DBE policy.
FISCAL INFORMATION/CERTIFICATION:
The Director of Fiscal Services certifies that the funds required for this project are available in
the current capital budget of the Commercial Paper Fund - Water and Sewer.
MG:a
Submitted for City Manager's FUND ACCOUNT CENTER AMOUNT CITY SFCRETARY
Office by: (to)
PW77 531200 060770210020 $1,438,466.00 APPROVED
Mike Groomer 6140 PS46 531200 070460210020 $1,438,466.00 CITY COUNCIL
Originating Department Head:
f OCT ig 1993
Richard Sawey 8207 (from)
PW77 531200 060770210020 $1,438,466.00 �f..1. �
For Additional Information PS46 531200 070460210020 $1,438,466.00 � muT�al&a
Contact:
Richard Sawey 8207
Printed on recycled paper
ATTACHMENT A
FORT WORTH WATER DEPARTMENT
HTE PACKAGE MODIFICATION ESTIMATES
MOD NO. BRIEF DESCRIPTION HOURS $$ DISP. Accept$$
1 Additional Direction/Suffix Needed 40 3,400 Reject
2 Interface w/Address Verification File 16 1,360 Accept 1,360
3 Additional Meter Fields 32 2,720 Accept 2,720
4 Notify for water main break 24 2,040 Accept 2,040
5 Interface from Meter Inventoy to Fixed Assets 40 3,400 Reject
Change Name of"Warehouse Location"to
6 generic for meter destruction reason 8 680 Accept 680
Moved to
7 Generate read routes upon request #30
Produce report listing meters with consecutive
8 estimates 24 2,040 Accept 2,040
9 Code meter as DO NOT ESTIMATE 16 1,360 Accept 1,360
10 Provide credit scoring 32 2,720 Accept 2,720
11 Access Lab Services 40 3,400 Reject
Part B of Anaheim: Estimate after x number o
12 days if no read. 32 2,720 Accept 2,720
13 Default usage on new customer 16 1,360 Accept 1,360
14 Special bill messages by customer class No Mod
Mod. Adjustment Report for items over a dollar
15 amount or by type. 24 2,040 Accept 2,040
16 Custom Bill 40 3,400 Accept 3,400
17 Interdepartmental billing 32 2,720 Accept 2,720
18 Generate cash reports by payment type 24 2,040 Accept 2,040
19 Create tape for collection agencies 24 2,040 Reject
20 Add non-cash deposits 32 2,720 Accept 2,720
Base delinquency notices/bills on credit
21 history(hard/soft) 24 2,040 Accept 2,040
22 Adjust amount of deposit by credit history 40 3,400 Accept 3,400
23 Produce Letter of intent to file lien 40 3,400 Reject
Automatically generate tum-on WO from
24 cashier receiving full payment 8 680 Accept 680
25 Route resequencing by user defined routes 16 1,360 Acce t 1,360
Warning Screen when moving route to another
26 cycle 8 680 Accept 680
27 Online inquiry by grid coordinate No Mod
28 Automatically generate meter removal order 32 2,720 Accept 2,720
29 Complete multiple orders with one entry 24 2,040 Accept 2,040
Automatically generate orders for zero
30 consumption, etc. 40 3,400 Accept 3,400
31 Maintain effective dates on taxes 40 3,400 Reject
32 Rate modeling 80 6,800 No Mod
33 Maintain histo of rate code changes I INo Mod
Page 1
FORT WORTH WATER DEPARTMENT
HTE PACKAGE MODIFICATION ESTIMATES
MOD NO. BRIEF DESCRIPTION HOURS $$ DISP. Accept$$
34 Interface to Planning and Scheduling 40 3,400 Reed
Interface to Construction/Maintenance WO
35 System 40 3,400 Rejed
36 Add type of business field/BOD/TSS Calc. 40 3,400 Accept 3,400
No Mod/
37 Private Well Reed
38 Wholesale Sewer 200 17,000 Reed
39 Wholesale Water Reed
40 Interface to G/L 32 2,720 Accept 2,720
41 Interface from SCADA/daily average flow,etc. Reed
No Mod
42 Separate Street Name into name and type /Reed
No Mod
43 Validate Mailing Address /Re'ed
44 Split Customer Name 60 5,100 Accept 5,100
Modify Standard Reports 80 6,800 6,800
TOTALS: 1340 113,900 64,260
Page 2
FORT WORTH WATER DEPARTMENT
CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 1 REQUESTER: Eric Hammonds & Pete Velasquez
1. TEST SCRIPT/CONDITION ID: Test Script 1.6
2. MODIFICATION REQUESTED:
E
dditional direction/suffix code is needed to identify streets such as N. Loop 820 W.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
If this modification is not implemented, this information could be stored in the street name field. There was
initially a concern that this information was needed to tie to GIS, but it was determined that the S-code in the
COFW address verification file could be converted into the address cross-reference field and provide the
same uniqueness.
4. HTE COMMENT:
We have the following fields available for location address identification:
• Street number-7 digits
■ Qualifier- 5 characters
• Apt/Suite- 5 characters
• Direction-2 characters (code)
■ Street Name-22 characters
The Example of N. Loop 820 W. could be put into the fields as follows:
• Street Number-
■ Qualifier-W.
■ Apt/Suite-
■ Direction - N.
■ Street name- Loop 820
To add the additional direction/suffix code would be a modification to the Land Management(LM) application.
This affects not just the Utility Billing (UT) application, but all applications that interface to the LM.
The interface to the Water Department address file could still be accomplished by matching the addressing in
LM to how you address in the Water Department file.
5. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding, testing, documentation, etc.
TOTAL HOURS: TOTAL COST.
40 $3,400 tl
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT QUALIFICATION REJECT
X
1
FORT WORTH WATER DEPARTMENT
Aw CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
7. ACCEPTANCE QUALIFICATION STATEMENT:
ISS strongly recommends implementing this modification so that the HTE address matches the COFW
address verfication system format:
Block X(6)
Direction X(2)
Street X(20)
Type X(4)
Suffix X(2)
2
FORT WORTH WATER DEPARTMENT
00".CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 2 REQUESTER: Eric Hammonds & Pete Velasquez
1. TEST SCRIPT/CONDITION ID: Test Script 1.6
2. MODIFICATION REQUESTED:
At the time of conversion and periodically afterward, the HTE street dictionary should be loaded from the
COFW address verification file. Once the initial file is loaded, a report should be run periodically to list any
discrepancies between the two files, so that changes can be made to the HTE street dictionary. Another
approach would be to have the program that is run periodically actually perform adds, changes, deletes to the
HTE street dictionary.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
It is critical that the HTE street dictionary match the address verification file so that addresses are standard
throughout the City. Since the customer's mailing address defaults from the service address, this can also
affect postal rates, based on mailing address accuracy. It may be sufficient to periodically generate an error
report to identify any discrepancies, since addition of service addresses does not occur frequently.
4. HTE COMMENT:
(Custom) The following assumptions will be made with the cost estimate for this modification:
1. A file will be transferred to the AS/400 in a readable format.
2. A file layout and specifications will be provided by the Water Department.
Based on these assumptions, the following modification will be done:
1. A menu option to verify the file transferred to the AS/400 with the Land Management (LM) street
dictionary. A verify and update mode will be available. This will allow you to view what changes will be
made before updates are done. 16 Hours
2. An option is already available in LM to verify the street dictionary with the LM master file to ensure there
are matches. Changes can then be made manually for each location, or if multiple locations are involved,
mass change is also available.
3. To ensure that customer mailing addresses get updated, the system could verify that the customer mailing
address is the same as the location address. If the location address is updated, the customer address
could be updated at the same time. 16 Hours
S. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding, testing, documentation, etc.
TOTAL HOURS TOTAL COST'
16 $1,360
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT QUALIFICATION REJECT
X
3
FORT WORTH WATER DEPARTMENT
."',CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
7. ACCEPTANCE QUALIFICATION STATEMENT:
Eliminate HTE comment#3 from above. See attached information on service address verification file.
Aw
AW
4
FORT WORTH WATER DEPARTMENT
CUSTOMER INFORMATION SYSTEM PROJECT
riVIODIFICATION SPECIFICATION
MOD. NO: 3 REQUESTER: Gary Rockers, Field Ops
1. TEST SCRIPT/CONDITION ID: Test Script 3.1; Requirements Document P.30#485
2. MODIFICATION REQUESTED:
By meter, the following fields are required:
- Initial Cost
- Warranty Expiration Date
- Retirement Date
- Maintenance Date
(Original Estimate $2,720)
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
If this mod is not implemented, it will not be possible to track this on the system.
4. HTE COMMENT:
None.
S. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding, testing, documentation, etc.
TOTAL HOURS TOTAL COST
32 $2,720
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT-..-:.::. :b:: QUALIFICATION' REJECT
X
7. ACCEPTANCE QUALIFICATION STATEMENT:
5
FORT WORTH WATER DEPARTMENT
CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 4 REQUESTER: Vel Mercer
1. TEST SCRIPT/CONDITION ID: Requirements Document P. 34#24
2. MODIFICATION REQUESTED:
Ability to identify a water system or main to the service location. This can be accommodated by user defined
fields; however, it would be nice if a warning screen would pop-up when a service address is accessed which
is tied to a main for which a break has been identified. --MOD REVISED--SEE QUALIFICATION STATEMENT
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
This could be accommodated by querying on all locations that have the main associated with them.
4. HTE COMMENT:
Map number can be used in the Service characteristic field. This is available for each service. A modification
for the City of Anaheim will provide an inquiry function to look up by this filed. This field will become "user
defined"so you can identify the term for each service.
A modification would be required to have the system generate a "special note"to appear for each location that
has a main break. "Special notes" are displayed whenever you select a location that has this note tied to it. A
mass add function would need to be provided. This will also give you a history of these breaks at each
location. A mass change option to remove the "special note"would also be required so that when the main is
fixed, you can remove.
S. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding, testing, documentation, etc.
TOTAL HOURS TOTAL COST
24 $2,040
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT QUALIFICATION;; REJECT
X
7. ACCEPTANCE QUALIFICATION STATEMENT:
Instead of associating a leak with a main/tap and tying that to service location, provide the ability to identify a
range of blocks or service addresses as having a leak. A special note should pop up when one of these
addresses is accessed.
AW
6
FORT WORTH WATER DEPARTMENT
401, CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 5 REQUESTER: Kathy Gibson, Gary Rockers, Chris Taylor
1. TEST SCRIPT/CONDITION ID: Requirements Document p. 32#26
2. MODIFICATION REQUESTED:
F
an interface from meter inventory to Fixed Assets (MARS accounting system) on mainframe.
n regard to depreciating the value of meters. This is all the detail that is known at this time. Please
a "bestguess" estimate.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
This information would be entered manually into MARS.
4. HTE COMMENT:
(Custom) The following assumptions will be made for this estimate:
1. The Utility Billing (UT) system will provide a file of information for each meter.
2. The information must currently be available in the UT system for each meter.
3. The Water Department will be responsible for transmitting the file from the AS/400.
This is an estimate- Once further information is available, this will be adjusted to reflect the actual hours
needed.
5. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding, testing, documentation, etc.
TOTAL HOURS.:, TOTAL COST
40 $3,400
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPTQUALIFICATION; REJECT
X
7. ACCEPTANCE QUALIFICATION STATEMENT:
A01-
7
FORT WORTH WATER DEPARTMENT
,OW CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 6 REQUESTER: Randall More, Gary Rockers
1. TEST SCRIPT/CONDITION ID: Related to Test Script 4.3
2. MODIFICATION REQUESTED:
On the Screen UT550002, change the name of"warehouse location" field to something generic like
Disposition Code. This is needed to track the reason a meter was"junked" or destroyed.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
The fact that a meter had been destroyed would be available, but not the reason.
4. HTE COMMENT:
Allows the "warehouse" description in meter inventory to be user-defined.
5. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
,including analysis, coding, testing, documentation, etc.
TOTAL HOURS TOTALCOST
8 $680
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT QUALIFICATION =REJECT
X
7. ACCEPTANCE QUALIFICATION STATEMENT:
8
FORT WORTH WATER DEPARTMENT
..CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 7 REQUESTER:
1. TEST SCRIPT/CONDITION ID: Requirements Document P.33#8
2. MODIFICATION REQUESTED:
The system will generate individual read routes upon request (rechecks, field collections, etc.). Original price
listed was$4,080. — MOD DELETED-- See#30
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
Upon review of the exception lists, a meter reader comment code could be entered that would then generate
E-0
work order or a manual work order would need to be entered.
4. HTE COMMENT:
5. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding, testing, documentation, etc.
TOTAL HOURS TOTAL COST
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT ;QUALIFICATION REJECT
7. ACCEPTANCE QUALIFICATION STATEMENT:
Ab
9
FORT WORTH WATER DEPARTMENT
A.CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 8 REQUESTER:
1. TEST SCRIPT/CONDITION ID: Requirements Document P.3#16
2. MODIFICATION REQUESTED:
The system will produce a report that lists meters with consecutive estimated readings over a user specified
number. Original estimate was $2,040.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
A user written query could be generated to produce this report.
4. HTE COMMENT:
None.
5. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
,ow,including analysis, coding, testing, documentation, etc.
TOTAL HOURS TOTAL COST
24 $2,040
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT. . :QUALIFICATION REIECT
X
7. ACCEPTANCE QUALIFICATION STATEMENT:
This assumes that this report will be available to be generated and viewed online.
AN-
10
FORT WORTH WATER DEPARTMENT
,�. CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 9 REQUESTER:
1. TEST SCRIPT/CONDITION ID: Requirements document p. 35#27
2. MODIFICATION REQUESTED:
The system should allow a meter to be coded as DO NOT ESTIMATE which restricts estimating the reading.
Original estimate $1,360.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
There would be nothing tied to the meter to provide this information.
4. HTE COMMENT:
None.
5. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding, testing, documentation, etc.
TOTAL<HOURS TOTAL COST
16 $1,360
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT QUALIFICATION: 'REJECT
X
7. ACCEPTANCE QUALIFICATION STATEMENT:
This feature can be removed or added to the meter as required. This information should appear on the Work
Order.
11
FORT WORTH WATER DEPARTMENT
CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 10 REQUESTER:
1. TEST SCRIPT/CONDITION ID: Requirements Document P. 39#12
2. MODIFICATION REQUESTED:
The system should provide a mechanism for credit scoring capability, assigning points to various credit
offenses and defining the threshold for good credit and deposit refund. This should be displayed on main
credit inquiry screens. Original estimate $2,720.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
System currently provides total number of offenses, but these are not weighted based on type to provide a
total score.
4. HTE COMMENT:
None.
5MODIFICATION HOURS AND COSTS:
n,otal hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding,testing, documentation, etc.
TOTAL HOURS :TOTAL.COST:.,:*
32 $2,720
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT::.: ... REJECT
X
7. ACCEPTANCE QUALIFICATION STATEMENT:
12
FORT WORTH WATER DEPARTMENT
Aw CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 11 REQUESTER:
1. TEST SCRIPT/CONDITION ID: Requirements Document P. 48#17
2. MODIFICATION REQUESTED:
The ability is needed to access the Laboratory information system from UT to inquire on status of testing for
customer. It was decided that the Lab personnel would enter fees and perform billing through the A/R
subsystem or miscellaneous billing in UT. All that is needed is online inquiry of testing status.
One possibility is to download a file into predefined fields in UT for inquiry. The other possibility is that the
CSR toggles to the mainframe from the PC and accesses the Lab system directly. In the first case, Lab
services will need to track customer account number if it is not presently doing so.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
Customer Service Rep would have to call Lab Services for status of testing or would have to ask customer to
call Lab Services.
#'4. HTE COMMENT:
(Custom) The following assumptions are made regarding this modification:
1. A file is provided to the AS/400 in a readable format.
2. It has not been determined where this information will be stored but the assumption is that no additional
fields or files will need to be added to accommodate the information.
This is an estimate until actual file information is available.
5. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding, testing, documentation, etc.
TOTAL HOURS.
TOTAL COST :
40 $3,400
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT QUALIFICATION REJECT
X
a
13
FORT WORTH WATER DEPARTMENT
Awl'CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
7. ACCEPTANCE QUALIFICATION STATEMENT:
Alw
14
FORT WORTH WATER DEPARTMENT
CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 12 REQUESTER: Pat Grisafi
1. TEST SCRIPT/CONDITION ID: Test Script 8.1
2. MODIFICATION REQUESTED:
Related to mod being asked for by Anaheim.
Part A(already asked for by Anaheim). System should provide the ability to bill all accounts that have passed
high/low, etc. in a route book and leave the others to be corrected or estimated. Anything that passes the edit
should be billed, regardless of whether the whole book passes.
Part B (additional) If after a user-defined number of days, an account has not been corrected, go ahead and
bill it. If there is not a read, estimate it. Go ahead and estimate even if indicated as "DO NOT ESTIMATE"
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
If Part B is not implemented, the decision to go ahead and estimate would be determined by manual review.
4. HTE COMMENT:
None
5. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding,testing, documentation, etc.
TOTAL HOURS ;;TOTAL COST
32 $2,720
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT `QUALIFICATION` ;REJECT
X
7. ACCEPTANCE QUALIFICATION STATEMENT:
15
FORT WORTH WATER DEPARTMENT
AM CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 13 REQUESTER: Pat Grisafi and Donna Anderson
1. TEST SCRIPT/CONDITION ID: Test Script#8.7
2. MODIFICATION REQUESTED:
When a new customer is setup default the Default Usage field to a user defined consumption such as 900cf for
sewer average. This should be added to the system setup of Class. (UT00OU28 System Control
Maintenance)
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
177new customers, CSRs will have to tab down to bottom of screen and enter 900cf in Default Usage field.
4. HTE COMMENT:
The ability to indicate a default usage by class is already available. This is used when the system calculates
the WQ average for the cycle/routes. An option to use this on new customer setup is required.
5. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding, testing, documentation, etc.
TOTAL HOURS TOTAL COST
16 $1,360
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT QUALIFICA
TIONt REJECT
X
7. ACCEPTANCE QUALIFICATION STATEMENT:
16
FORT WORTH WATER DEPARTMENT
A. CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 14 REQUESTER:
1. TEST SCRIPT/CONDITION ID: Test Script#8.12
2. MODIFICATION REQUESTED:
Allow flexibility to send special bill messages to certain classes of customer. This is in addition to global bill
message.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
If this were not implemented, the City would be limited to only global special messages on the bill.
4. HTE COMMENT:
Already being done for City of Anaheim.
5. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
....including analysis, coding, testing, documentation, etc.
TOTAL HOURS TOTAL COST
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT QUALIFICATION: REJECT
7. ACCEPTANCE QUALIFICATION STATEMENT:
17
FORT WORTH WATER DEPARTMENT
CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 15 REQUESTER: Pat Grisafi
1. TEST SCRIPT/CONDITION ID: Test Script#8.23
2. MODIFICATION REQUESTED:
Modification to Adjustment Report to only show those items over a certain dollar amount or of a certain type.
This applies to Adjustments, Corrected Bills, Credit Balance Refunds, and Transfers.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
All adjustments of each type would appear on the various reports.
4. HTE COMMENT:
Based on RoseAnn's notes, you also requested that another person must sign off on adjustments over a
certain dollar amount. This would require a file change to track the authorized person to sign off the
adjustment along with the security set up required.
The system currently allows the person to enter and list the adjustments does not have to be the person to post
the adjustment to the accounts. This would allow you to have someone review all adjustments before posting.
This requires no modification.
5. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding, testing, documentation, etc.
;TOTAL HOURS :.:TOTAL COST
24 $2,040
S. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT ;QUALIFICATION REJECT
X
7. ACCEPTANCE QUALIFICATION STATEMENT:
l8
FORT WORTH WATER DEPARTMENT
op" CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 16 REQUESTER:
1. TEST SCRIPT/CONDITION ID: Requirements Document P. 70#89
2. MODIFICATION REQUESTED:
The bill provides comparable consumption from the prior year and daily averages. Original estimate $1,360.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED
Bill would not provide this information.
4. HTE COMMENT:
If a custom bill print is required, the cost would be 40 hours to customize the bill format and include the
comparison of consumption and daily average.
If the"base" bill print is used, the cost would be 16 hours to enhance the "base"format.
5. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding, testing, documentation, etc.
TOTAL HOURS TOTAL COST
40 (custom bill) $3,400
16 base mod $1,360
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT <QUALIFICATION REJECT
X
7. ACCEPTANCE QUALIFICATION STATEMENT:
Comparable consumption from the prior year, etc. may not be needed, however,the City would like the
custom bill. This assumes that this charge covers all modifications required to produce a custom bill.
19
FORT WORTH WATER DEPARTMENT
.AWCUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 17 REQUESTER: Pat Grisafi, Sally Willis
1. TEST SCRIPT/CONDITION ID: Test Script#8.25
2. MODIFICATION REQUESTED:
Phase II mod- For Inter-departmental billing; to generate journal entries-the mod would be to generate
adjusting journal entries.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
Joumal entries must be created manually.
4. HTE COMMENT:
A payment type of transaction would need to be applied to designated accounts. The accounts should be set
up with different receivable codes so that the appropriate accounting numbers can be assigned. At time of
billing, an automatic payment transaction would be created and updated so that the account would be zero
after the billing update.
5. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding, testing, documentation, etc.
TOTAL HOURS TOTAL COST
32 $2,720
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT t2UAttFiCAT10N` REJECT
X
7. ACCEPTANCE QUALIFICATION STATEMENT:
Change to Phase I Mod.
few
20
FORT WORTH WATER DEPARTMENT
CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 18 REQUESTER: Pat Grisafi, Vel Mercer
1. TEST SCRIPT/CONDITION ID: Test Script#10.4
2. MODIFICATION REQUESTED:
Provide flexibility to generate cash reports by specified payment type.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
Report will provide all payment types. I
4. HTE COMMENT:
Query could be used to generate different reports by payment type. The modification is based on a custom
report and prompt screen that will provide a range of dates and type of payment.
5. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding,testing, documentation, etc.
TOTAL HOURS TOTAL COST
24 $2,040
S. WATER DEPARTMENT MANAGEMENT APPROVAL:
;:ACCEPT
QUALIFICATION::,. REJECT
X
7. ACCEPTANCE QUALIFICATION STATEMENT:
If available for online generation and viewing.
21
FORT WORTH WATER DEPARTMENT
CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 19 REQUESTER: Pat Grisafi, Sharon Hams
1. TEST SCRIPT/CONDITION ID: Test Script#10.8
2. MODIFICATION REQUESTED:
[77addition to the report generated for collection agencies, an electronic medium (tape) is needed.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
Collection agency will receive information by report.
4. HTE COMMENT:
Query could be used to generate a file to send to the collection agency. The information to send and the file
format has not been identified. The modification is based on the assumption that all field information is
currently available.
5. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding, testing, documentation, etc.
TOTAL HOURS TOTAL COST
24 $2,040
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT QUALIFICATION.:: REJECT
X
7. ACCEPTANCE QUALIFICATION STATEMENT:
Revisit later.
AOW
22
FORT WORTH WATER DEPARTMENT
AVb,CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 20 REQUESTER: Pat Grisafi
1. TEST SCRIPT/CONDITION ID: Test Script 11.6
2. MODIFICATION REQUESTED:
On the deposit inquiry screen, add a field which will indicate that the customer has a non-cash deposit and the
type. A 2 digit alphanumeric field for user definable codes is needed.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
CSR will have to go to special notes to find out if customer has a non-cash deposit. The deposit screen will
only show no deposit paid.
4. HTE COMMENT:
An option to add a non-cash deposit should be done instead of just one field. Multiple types of deposits and
dates could be used for any service. This would provide greater flexibility. A code plus a date of return/refund
and transfer would then be available as well.
AOW
S. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding, testing, documentation, etc.
TOTAL HOURS: TOTAL COST
32 $2,720
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT QUALIFICATION REJECT
X
7. ACCEPTANCE QUALIFICATION STATEMENT:
23
FORT WORTH WATER DEPARTMENT
40b,CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 21 REQUESTER:
1. TEST SCRIPT/CONDITION ID: Requirements Document P.76#31
2. MODIFICATION REQUESTED:
The system will provide the flexibility to generate delinquency notices/bills by arrears and credit history.
Original estimate $2,040. If in arrears but good credit history, generate a soft notice, otherwise generate a
hard notice.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
n
same delinquency notice will be generated regardless of the customer's credit history.
4. HTE COMMENT:
None.
S. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
;ncluding analysis, coding, testing, documentation, etc.
TOTAL HOURS
TOTAL`COST"..,—.",-
24
OST ,24 $2,040
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT QUALIFICATION' REJECT
X
7. ACCEPTANCE QUALIFICATION STATEMENT:
24
FORT WORTH WATER DEPARTMENT
CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 22 REQUESTER:
1. TEST SCRIPT/CONDITION ID: Requirements Document P. 76#32
2. MODIFICATION REQUESTED:
When a customer is being assigned to a new location, the system should check the credit history for that
customer to determine if the customer has had prior service with the City. Based on "user-defined" criteria,
per Gass,the system would notify the customer service representative that additional deposits should be
collected for this customer. The amount of the deposit should be calculated based on prior history.
Example: If the customer has been in collection or written off at other locations in the City, the deposit would
be the average of the last 6 months charges times 3. This deposit would then cover 3 months of billings.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
Unknown.
4. HTE COMMENT:
The system allows for deposit calculations an displays this information at the time you set up a customer. If
the credit history indicates that an additional deposit is required, a message would display with the credit
history information. An option to calculate the additional deposit amount will be displayed.
The criteria for each class on what the credit criteria would be and how the additional deposit amount would be
calculated would need to be added to the system.
NOTE: There is a modification for the City of Anaheim that will allow you to specify, for customers on the cut
off list, or in the delinquency process, that do not have enough of a deposit on file to cover the unpaid charges,
to have an additional deposit amount calculated and set up to bill on the next bill.
5. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding, testing, documentation, etc.
TO.TAC HOURS' TOTAL COST
40 $3,400
S. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT QUALIFICATION REJECT
X
. ACCEPTANCE QUALIFICATION STATEMENT:
25
FORT WORTH WATER DEPARTMENT
CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 23 REQUESTER:
1. TEST SCRIPT/CONDITION ID: Requirements Document P. 76#33.
2. MODIFICATION REQUESTED:
F
ystem will automatically produce a letter of intent to file a lien after user specified parameters are
ed. Original estimate $3,400.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
Query/Office can be used to generate letter.
4. HTE COMMENT:
None.
5. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
: °gidn analysis, coding,testing, documentation, etc.
:TOTAL HOURS TOTAL COST
40 $3,400
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT .:::::QUALIFICATION.. :;:REJECT
X
7. ACCEPTANCE QUALIFICATION STATEMENT:
26
FORT WORTH WATER DEPARTMENT
Awk CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 24 REQUESTER: Pat Grisafi
1. TEST SCRIPT/CONDITION ID: Test Script 12.3
2. MODIFICATION REQUESTED:
Regarding upcoming Waco modification to automatically generate a tum-on work order from cashier receiving
full payment on turned-off customer-Add the feature that if customer pays a user-defined % of amount due,
same thing would happen.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
Tum-on work order would only be generated for customers paying balance in full.
4. HTE COMMENT:
None.
5. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding, testing, documentation, etc.
- TOTAL HOURS TOTAL COST
8 $680
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT .QUALIFICATION:; REJECT
X
7. ACCEPTANCE QUALIFICATION STATEMENT:
t
27
FORT WORTH WATER DEPARTMENT
AV" CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 25 REQUESTER: Tara Sims- Solid Waste.
1. TEST SCRIPT/CONDITION ID: Test Script 12.9
2. MODIFICATION REQUESTED:
On route resequencing - allow resequencing by user-defined service. Right now, resequencing is only allowed
for user-defined routes as a whole. This would require that each solid waste type of service would have to
have a different cycle/route in order to allow resequencing.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
Each solid waste service would have to use unique cycle routes in order to utilize the resequencing feature.
4. HTE COMMENT:
Provide the ability to specify a "route" code along with a cycle/route during the "user defined" cycle/route re-
sequencing.
5. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding, testing, documentation, etc.
TOTAL HOURS ; TOTAL COST
16 $1,360
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT QUALIFICATION REJECT
X
7. ACCEPTANCE QUALIFICATION STATEMENT:
To be financed by Solid Waste.
28
FORT WORTH WATER DEPARTMENT
CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 26 REQUESTER: Eric Hammonds, ISS
1. TEST SCRIPT/CONDITION ID: 12.9
2. MODIFICATION REQUESTED:
Phase II mod - Create warning screen during route resequencing when a route is being moved from one cycle
to another when you're doing something that might adversely affect billing like moving a route 1 from cycle 1
to route 1 cycle 5 after cycle 1 has been read and billed, but before cycle 5 has been read and billed.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
It would be very rare that a route is moved between cycles in the new system and should only be done after
very careful thought has been given to the financial impact. This should only be done by someone with full
understanding of the possible consequences who has been given proper authority.
4. HTE COMMENT:
None.
S. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding,testing, documentation, etc.
TOTAL`HOURS TOTAL COST
8 $680
S. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT. .. UALIFICATION> < REJECT
X
7. ACCEPTANCE QUALIFICATION STATEMENT:
,F
29
FORT WORTH WATER DEPARTMENT
CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 27 REQUESTER:
1. TEST SCRIPT/CONDITION ID: Requirements Document P.51 #14
2. MODIFICATION REQUESTED:
Provide online inquiry of orders by Grid Coordinate ($3,400) and requester.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
EThis access would not be provided online but could be provide through a query report if entered. Not sure if
these fields already exist or if there is a special notes area where they could be stored.
4. HTE COMMENT:
Land Management (LM) is currently extending the land information for multiple "user-defined" lookup fields.
The Grid Coordinate could be used as one of those lookup fields.
No Additional modification required. This enhancement should be available end of 1st quarter 94.
r5. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding,testing, documentation, etc.
TOTAL HOURS TOTAL COST
S. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT .. QUALIFICATION REJECT
X
7. ACCEPTANCE QUALIFICATION STATEMENT:
30
FORT WORTH WATER DEPARTMENT
CUSTOMER INFORMATION SYSTEM PROJECT
Om MODIFICATION SPECIFICATION
MOD. NO: 28 REQUESTER:
1. TEST SCRIPT/CONDITION ID:Requirements Document P. 52#28
2. MODIFICATION REQUESTED:
The system will automatically generate orders for meter removal after a user-defined period of time has
elapsed with no new customer assuming service. Original estimate ($3,400).
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
ris were not implemented this would have to be monitored manually through query reports.
5. HTE COMMENT:
This could be made an option with the processing of each cycle/route during billing time. An error message
could be listed and indicate that work order will be created. A user-defined number of days for each service
will be required.
6. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding, testing, documentation, etc.
:TOTAL HOURS TOTAL COST
32 $2,720
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT QUALIFICATION REJECT
X
7. ACCEPTANCE QUALIFICATION STATEMENT:
31
FORT WORTH WATER DEPARTMENT
Asuh CUSTOMER INFORMATION SYSTEM PROJECT
1MODIFICATION SPECIFICATION
MOD. NO: 29 REQUESTER:
1. TEST SCRIPT/CONDITION ID:Requirements Document P. 52#29
2. MODIFICATION REQUESTED:
[10e system will provide the capability to complete multiple orders with one entry by dates, WO types, or range
rder numbers. Original estimate $2,040.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
[7not implemented, each order would have to be initiated or closed individually.
4. HTE COMMENT:
A list of open work orders would be listed and an option to close all selected will be provided. A completion
date and code would be required; all selected work orders would then be updated.
Currently, the system allows listing online WOs by type, date range, etc. The modification would add a
PFKEY to this screen which would transfer to a mass entry screen of all the WOs that fit this criteria. On the
mass entry screen, it will be possible to select all WOs for completion or only certain WOs. WOs which
OOW require more information than date to complete would not be available for mass completion.
5. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding, testing, documentation, etc.
TOTAL HOURS <TOTAL COST.
24 $2,040
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT QUALIFICATION' REJECT
X
7. ACCEPTANCE QUALIFICATION STATEMENT:
32
FORT WORTH WATER DEPARTMENT
Alm CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 30 REQUESTER:
1. TEST SCRIPT/CONDITION ID: Requirements Document P. 53,#31
2. MODIFICATION REQUESTED:
The system should automatically will automatically generate orders as a result of Zero Consumption, High/Low
consumption, Exceeding user-defined number of consecutive estimated readings on active accounts, or
covered meters. (Original estimate $3,400).
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
These WO would be monitored (through query reports?) and initiated manually.
4. HTE COMMENT:
(Moved from#7) Provide an option to generate work orders based on Meter exceptions such as Hi/Lo, no
reading, etc. Each of these error/warning messages will be provided with a work order code to generate.
Changed from 48 to 40 from original estimate. Some base changes have been implemented to specify in the
t system control which error messages are to be printed,this function will be enhanced.
5. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding, testing, documentation, etc.
TOTALHOURS TOTAL COST
40 $3,400
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT QUALI!=!CATION REJECT
X
7. ACCEPTANCE QUALIFICATION STATEMENT:
A016
33
FORT WORTH WATER DEPARTMENT
CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 31 REQUESTER: Tara Sims and Eric Hammonds
1. TEST SCRIPT/CONDITION ID: No specific test script or requirement- regarding rates/taxes.
2. MODIFICATION REQUESTED:
F
II mod-the system should maintain an effective date on taxes so that a history of taxes can be
ined and can be set in advance.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
The tax history on a customer can be found in the bill history. The tax change occurs infrequently and can be
changed the night before it is to go into effect at the system-wide level.
4. HTE COMMENT:
None.
S. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
Amok'ncluding analysis, coding,testing, documentation, etc.
TOTAL HOURS ::TOTAL COST
40 $3,400
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT QUALIFICATION REJECT
X
7. ACCEPTANCE QUALIFICATION STATEMENT:
Revisit Later.
t
34
FORT WORTH WATER DEPARTMENT
CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 32 REQUESTER: Pat Grisafl, Syed Zaidi
1. TEST SCRIPT/CONDITION ID: Test Script 13.4;Also Requirements Document P. 46,#20,21,22
2. MODIFICATION REQUESTED:
To project revenue impact of a projected rate change over minimum of 1, preferably 3 years of data. Include
growth factor to project impact fees for wholesale, industrial customers. Apply percentage growth to class of
customers. Other factors include geographic and volume growth.
Similar to rate modeling in Essex County but not sure if similar enough.
Requirements documents mods p. 46, 20,21,22 were costed out at$6,800 and do not include the ability to
perform projections.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
Rate modeling would be performed on the PC.
4. HTE COMMENT:
Rate modeling will become available with a modification with Essex County. This will allow projects as well.
We will need your requirements to ensure that all criteria are met. I recommend leaving the estimated
amounts in the contract and we can reduce or exclude once we determine if any additional modification will be
required after review of Essex and Fort Worth in greater detail.
S. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding,testing, documentation, etc.
TOTAL'HOURS <: TOTAL COST
80 (may be able to reduce or $6,800
exclude
S. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT QUALIFICATION :REJECT ...
X
7. ACCEPTANCE QUALIFICATION STATEMENT:
Assumes the modification being made for Essex County provides the ability to change the rate and project the
revenue based on a rate change within selected cycle(s), route(s), and time period/range.
I
35
FORT WORTH WATER DEPARTMENT
t CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 33 REQUESTER:
1. TEST SCRIPT/CONDITION ID: Requirements Document, P.45#15
2. MODIFICATION REQUESTED:
The system will retain a history of rate code changes including Date of change, individual making change, and
ordinance number. Mod is to track user and ordinance number; original estimate is $2,040.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
This information would not be available.
4. HTE COMMENT:
The City of Anaheim requested a modification to track the date and user. Will add ordinance number at no
additional charge. Will need size of ordinance number to ensure the field is large enough to enter.
,ow 5. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding, testing, documentation, etc.
TOTAL HOURS TOTAL COST
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT QUALIFICATION REJECT
7. ACCEPTANCE QUALIFICATION STATEMENT:
36
FORT WORTH WATER DEPARTMENT
CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 34 REQUESTER: Pat Grisafi
1. TEST SCRIPT/CONDITION ID: Requirements Document p. 54#44
2. MODIFICATION REQUESTED:
Phase II mod -The system should provide an Interface to the Water Department's Planning and Scheduling
system to facilitate giving customers scheduled dates for service.
Would like to be able to identify an individual or a work order as well as a crew code-track productivity and
scheduling of work orders.
FW is planning to have a planning and scheduling system on the mainframe, however this system currently
does not exist. We want to allow$$ in the estimate for Phase II for a batch file being passed to or from the
system.
We also discussed using the HTE Work Order Facility Management system already proposed for tracking
some of this information.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
If not implemented,the proposed HTE Work Order system could be used to track some of the information.
4. HTE COMMENT:
There will be a modification done for the City of Anaheim that will allow for scheduling of work orders. To
transfer information between the Utility Billing (UT) and another non-HTE system is difficult to estimate since
the other system is not in place and it is unknown what type of information has to be supplied.
The following assumptions are made with this estimate:
1. No file of data changes are required in the UT system.
2. An extract program is provided to be sent to a non-HTE system with existing information
3. A comment element between the two systems must be available to ensure that proper linking is available.
This is an estimate which will require further review once all information is available.
5. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding, testing, documentation, etc.
TOTAL HOURS': TOTAL COST :
40 $3,400
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT QUALIFICATION REJECT
X
37
FORT WORTH WATER DEPARTMENT
oom CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
7. ACCEPTANCE QUALIFICATION STATEMENT:
38
FORT WORTH WATER DEPARTMENT
...,CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 35 REQUESTER: Pat Grisafi
1. TEST SCRIPT/CONDITION ID: Requirements document P.54, #45
2. MODIFICATION REQUESTED:
Phase II mod -The system will provide an interface with the Water Department's Construction/Maintenance
Work Order System.
This would be a batch interface to an existing mainframe custom work order system. No more details are
known at this point. Please give a "bestguess" estimate.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
If this were not implemented the impact is unknown due to the lack of definition of interface requirements at
this time.
4. HTE COMMENT:
The same assumptions as Mod. No. 34 are being made:
1. No file of data changes are required in the UT system.
2. An extract program is provided to be sent to a non-HTE system with existing information
3. A comment element between the two systems must be available to ensure that proper linking is available.
This is an estimate which will require further review once all information is available.
S. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding, testing, documentation, etc.
TOTAL HOURS >.. TOTAL COST
40 $3,400
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT QUALIFICATION REJECT
X
7. ACCEPTANCE QUALIFICATION STATEMENT:
Ani
39
FORT WORTH WATER DEPARTMENT
CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 36 REQUESTER:
1. TEST SCRIPT/CONDITION ID: Test Script 14.1
2. MODIFICATION REQUESTED:
Industrial Waste - Need a field to store/identify type of business for industrial waste so that a CSR could "?" on
field and ask commercial customer if they are one of the defined type of"industrial waste" businesses. This
will help identify IW customers for billing purposes.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
If this were not implemented all new commercial customers would have to be queried and individually
determined, whether through calling or other means whether or not this is an industrial customer.
4. HTE COMMENT:
Based on RoseAnn's notes, the calculation for the BOD/TSS needs to be reviewed and implemented into the
system. The "rate class"field can be used to defined the "type" of business. This is a 2 character, user-
defined field and is used to determine which "rate group"that is used to calculate the service.
Location surcharges are available currently for the accounts— you process a rate times the actual
consumption.
Modification is required for BOD/TSS readings and calculations. These have not been included in this
document and will need to be reviewed in detail for final analysis.
The estimate is based on prior knowledge of BOD/TSS and what is currently available within the system. The
assumption is that the information is already available within the system and that only the "calculation"would
need to be customized.
6. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding, testing, documentation, etc.
TOTALHOURS TOTAL COST
40 $3,400
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT QUALIFICATION REJECT
X
40
FORT WORTH WATER DEPARTMENT
/w''CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
7. ACCEPTANCE QUALIFICATION STATEMENT:
Will need further definition.
41
FORT WORTH WATER DEPARTMENT
oplhCUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 37 REQUESTER: Pat Grisafi, Syed Zaidi
1. TEST SCRIPT/CONDITION ID: Test Script 14.3
Z. MODIFICATION REQUESTED:
Private Well -A customer may have a private well and city water and use both in a particular month. Sewage
charges are based on water consumption, either from the well meter or the water meter. We discussed having
each one be a different service but needed to think about the possible impact. There may not be a mod
needed.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
Unknown.
4. HTE COMMENT:
The set up of two services will allow you to track who has wells and who is using city water. The system will
allow you to specify only one of the services to bill sewer service.
If the sewer is based on both meters for a given month, either a manual calculation of consumption would be
entered, or a "master location" for the sewer could be set up to add both meters together. This would have to
be done manually for the months that only bill one or the other or both. How and when is it determined which
water service to use for sewer?
No estimate given at this time until it is determined if any other requirements are needed.
5. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding, testing, documentation, etc.
TOTAL HOURS TOTAL COST
6. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT QUALIFICATION REJECT
X
7. ACCEPTANCE QUALIFICATION STATEMENT:
42
FORT WORTH WATER DEPARTMENT
ow CUSTOMER INFORMATION SYSTEM PROJECT
MODIFICATION SPECIFICATION
MOD. NO: 38 REQUESTER: Pat Grisafi, Syed Zaidi, Ron Miller
1. TEST SCRIPT/CONDITION ID: Test Script 14.5
2. MODIFICATION REQUESTED:
Wholesale Sewer: Wholesale customers are usually other cities and the bill is calculated using number of
residential and commercial customers x a set volume and also uses the totalized volume at the large meters.
Each city may have 4 totalizer meters. It seems that it will be possible to enter the information into the system
and bill without a modification by using the consumption by meter number to correspond to residential or
commercial volumes.
This needs internal discussion by HTE.
3. STATEMENT OF IMPACT IF NOT IMPLEMENTED:
Unknown.
4. HTE COMMENT:
(Custom) This would entail an entire sub-system to the Utility Billing system. Daily reads and contract prices
for an individual account is not part of the "base" application. RoseAnn stated that the actual billing and
tracking of dollars can be done, but the interface to the "SCADA"system as well as another bill format for
those customers would need to be customized.
This is an estimate and would need detailed specifications on all requirements before starting this modification.
At this point this would be "custom"to the Fort Worth Water Department and not included in the "base"
application.
5. MODIFICATION HOURS AND COSTS:
Total hours and costs associated with the modification. This includes any cost to be realized by the Water Department
including analysis, coding, testing, documentation, etc.
TOTAL HOURS TOTAL COST
200 . $17,000
S. WATER DEPARTMENT MANAGEMENT APPROVAL:
ACCEPT QUALIFICATION `REJECT
X
Agh-
43