HomeMy WebLinkAbout14672 ORD - 12/20/1978jkh:12- 20- 78;lst
AN ORDINANCE
AUTHORIZING THE CITY MANAGER TO EXECUTE A CONTRACT
WITH INFORMATION ASSOCIATES, INC., TO IMPLEMENT A
UTILITY BATCH SYSTEM, ALL AS MORE FULLY SET FORTH
IN THE CONTRACT, A SUBSTANTIAL COPY OF WHICH IS
ATTACHED HERETO AND MADE A PART HEREOF, MARKED EXHIBIT
"A "; AND DECLARING AN EMERGENCY.
BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF CORPUS CHRISTI,
TEXAS:
SECTION 1. That the City Manager be and he is hereby authorized
to execute a contract with Information Associates, Inc., to implement a
utility batch system, all as more fully set forth in the contract, a substan-
tial copy of which is attached hereto and made a part hereof, marked
Exhibit "A ".
SECTION 2. The necessity to authorize execution of the aforesaid
contract at the earliest practicable date creates a public emergency and
an imperative public necessity requiring the suspension of the Charter rule
that no ordinance or resolution shall be passed finally on the date of
its introduction but that such ordinance or resolution shall be read at
three several meetings of the City Council, and the Mayor having declared
such emergency and necessity to exist, and having requested the suspension
of the Charter rule and that this ordinance be passed finally on the date
of its introduction and take effect and be in full force and effect from and
after its passage, IT IS ACCORDINGLY SO ORDAINED, this the a."20 day of
December, 1978.
ATTEST:
Cit "Secretary
APPROVED:
)DAY OF DECEMBER, 1978:
J. BRUCE AYCOCK, CITY ATTORNEY
By—
A, .
sistant C' ttorney
14672
MAYOR
THE CITY OF C US CHRISTI, TEXAS
WROFILMED'
I"JUL 0 81980
information associates, inc.
97 Humboldt St., Rochester, N. Y. 14609 716 288.6900
SYSTEMS 8 PROGRAMMING AGREEMENT
CUSTOMER City of Corpus Christi
317 People's Street
Corpus Christi, Texas 78408
SERVICES
CHARGES
I. SERVICES
CCC —01
DATE 12/8178
As described on the annexed Contract For Professional Services.
As described on the annexed contract for Professional Services.
This Agreement will cover all services rendered by IAI's systems personnel at the Customer's request, including
Special studies, programming and application design and development, systems analysis and design, implementation
planning and conversion, and data processing. The services will be as specified on the face hereof and as hereafter
ordered by the Customer pursuant to Work Orders approved by IAI. The services will be completed by the dates speci-
fied on the face hereof or on any future Work Orders, subject to any delay caused by events beyond IAI's control.
2. CHARGES
For the services specified herein, the Customer will pay IAI the charges set forth on the face hereof and on
future Work Orders. Payment of charges will be made by the Customer within 30 days after the receipt of IAI's
invoices. The Customer will pay all sales taxes and other taxes relating to the services being rendered to the Cus-
tomer for which IAI is required to collect by any taxing authority.
* 3. CUSTOMER SUPPORT
The Customer will supply satisfactory support without charge. Should the Customer ,`ail to supply the necessary
support, IAI reserves the right to charge the Customer for additional work at IAI's then current rates and for any
additional expenses incurred by reason thereof.
4. RIGHTS TO ITEMS
All material developed for the Customer other than material developed for use with IAI licensed Program Products,
will belong exclusively to the Customer upon completion of the services and payment of all charges by the Customer.
IAI shall be free to use any ideas, techniques or formulae for data processing, or any other handling or treat-
ment of data developed by IAI, in any way IAI may deem appropriate.
5. CONFIDENTIAL NATURE
All data relating to the Customer's business which is submitted to IAI will be kept confidential to the same ex-
tent that IAI keeps confidential data relating to its
r o
own business; provided, however, that if such data is in the
public domain or is already within IAI's possession o knwledge, IAI shall bear no responsibility for its disclosure.
IAI -170 -0 4 (12/78)
t ,
6. LIMITATION OF LIABILITY
In providing the Customer with the services, IAI is not accepting any responsibility for their utilization or for
any decisions which may be made in connection therewith. IAI does not make any express or implied warranties of mer-
chantability and fitness for any particular use. The liability of IAI, if any, relating to the performance of the
services specified herein will be limited to money damages in an amount equal to the charges for such services. In no
event will IAI be responsible for any consequential damages resulting from the use of the material developea hereunder,
even if IAI has been advised of the possibility of such damages. No claim hereunder may be brought by either par.
more than one year after the cause of the action has accrued.
* 7. ARBITRATION
Any controversy arising out of, or relating to, this agreement, or the breach thereof, will be settled by
arbitration in accordance with the rules of the American Arbitration Association at a hearing held in Rochester,
New York, and judgment upon the award rendered may be entered into any court having jurisdiction thereunder.
* 8. CONSTRUCTION
This Agreement constitutes the entire agreement between the parties relating to the services and is binding
upon their respective successors and transferees. No change shall be made in any of its terms, nor any provision
waived without the prior written consent of both parties. This Agreement will be construed and interpreted in
accordance with the laws of New York State.
9. INDEPENDENT CONTRACTOR
The Customer and IAI acknowledge that IAI is an independent contractor and not the agent of the Customer for any
purposes whatsoever. Furthermore, neither party has the authority to enter into any agreements or assume any obliga-
tions on behalf of the other party, and nothing herein shall be construed to establish a relationship of co- oartre,,
joint - venturer or principal -agent between IAI and the Customer.
- ACCEPTED:
CTTY OF C ^none rraRISTT
BY
ITS
DATE
IAI - 770 -04 (12/78)
INFORMATION ASSOCIATES, INC.
BY
DATE
ITS
APPROVALS: L )D M J
Sec'y kb Date 128/78
AGREEMENT CCC -Ol
DATE 12/8/78
Rider Annexed to
Systems & Programming Agreement
For
City of Corpus Christi
*Refer to Systems & Programming Agreement
1. Article 3, CUSTOMER SUPPORT change second sentence only, as follows:
Should the Customer fail to supply the necessary support, IAI
reserves the right after giving written notice and reasonable
Opportunity to cure to charge the Customer for additional
work at IAI's then current rates and for any additional
expenses incurred by reason thereof.
2. Article 7, ARBITRATION, is changed as follows:
Any controversy arising out of, or relating to, this agreement,
or the breach thereof, will be settled by arbitration in
accordance with the rules of the American Arbitration Association
at a hearing held in Corpus Christi, Texas, and judgment upon
the award rendered may be entered int
thereunder. o any court having jurisdiction
3. Article 8, CONSTRUCTION, is changed as follows:
This Agreement constitutes the entire agreement between the
parties relating to the services and is binding upon their
respective successors and transferees. No change shall be
made in any of its terms, nor any provision waived without the
prior written consent of both parties. This Agreement will be
construed and interpreted in accordance with the laws of the
state of Texas.
ACCEPTED:
CITY OF CORPUS CHRISTI
By
its
DATE
INFORMATION ASSOCIATES, INC.
BY
its
I
DATE
L _? M �
Secly kb Date 12/8/78
CONTRACT FOR PROFESSIONAL SERVICES
THE STATE OF TEXAS
-COUNTY OF NUECES
This contract (hereinafter called the "Contract "), is made and
:entered into by and between the City of Corpus Christi, Texas, a municipal
'corporation in Nueces County, Texas, acting under the laws of the State of
Texas, hereinafter called the "City ", and Information Associates, Inc. of
Rochester, New York, hereinafter called "IAI ", upon the following terms and
considerations:
1. Definitions. For purposes of this contract and related docu-
ments, the definitions and explanations contained in the Glossary attached
hereto and made a part of this contract, shall apply.
2. Venue. This contract is performable in Corpus Christi, Nueces
County, Texas, and shall be construed, enforced and performed in accordance
with the laws of the State of Texas.
3. Consultant. IAI will provide to the City professional ser-
vices to develop and place into operation a utility billing batch system, on-
line programs (optional), and related software as specified herein and as
hereafter ordered by City pursuant to work orders approved by IAI. IAI will
be the consultant and shall furnish its own staff.
4. Work Phases. IAI will develop and implement a Utility
Billing System through a phased approach described hereunder:
a. PHASE I: SYSTEM DEFINITION
During the initial phase of the project, a four to six week period,
the IAI project team will work closely with City's project coordinator and
its functional users to review and finalize the systems design specification
in the form of system flowcharts, program narratives, file layouts, and re-
port formats in a mutually agreeable format. An IAI systems analyst will
devote up to three days each week for the four to six week period, at City's
facility. City and IAI will review and sign off on the finalized documenta-
tion.
b. PHASE II: PROGRA14MING & UNIT TESTING
During this phase IAI will write, unit test, and debug the ANS
-COBOL programs specified herein on the program list in paragraph 5.
It is anticipated that during Phase II the IAI project manager
-will make up to four trips to City's facility of one to two days each, for such
purposes as review of the preliminary system outputs and review of project sta-
-tus with City's project coordinator.
IAI estimates that Phase II will require approximately 12 elapsed
weeks to complete. Such work will be performed at IAI's computer facility in
Rochester, New York.
c. Phase III: PARALLEL TESTING
Upon completion of unit testing activities, the project will move
into parallel testing. City and IAI will review, and sign off upon completion
of the parallel testing.
The parallel test activity will serve as the principal vehicle for
training and education of functional users.
During this phase, IAI and City will mutually agree upon and will
finalize the functional user documentation and computer operations documentation,
including batch recovery procedures to reflect actual operational conditions.
Upon completion of the parallel testing, the system will be ready for operation
and will move into an ongoing support mode.
It is estimated that Phase III will require six to eight elapsed
weeks to complete.
d. PHASE IV: POST- IMPLEMENTATION SUPPORT
During this phase of eight to twelve elapsed weeks, it is expected
that minor modifications will be made to programs and documentation, provided
such modifications were agreed to be within the scope of the system as defined
and approved in the Phase I specifications. IAI will furnish program support
to diagnose and correct program errors solely caused by IAI.
5. Program Support. The following list has been constructed to
reflect the programs and sorts that will make up the Utility Billing System.
Programs identified with an asterick ( *) are understood to be the responsibility
of the"City's data processing staff to write and implement. -
UTILITY BILLING SYSTEM
Programs to be written and implemented:
1. UTIP0010 - Maintenance Transaction Edit (Master File Maintenance Edit)
2. UTIS0015 - Valid Maintenance Transaction Sort (Master File Update and Edit)
3. UTIP0020 - Master File Update (Master File Update and Edit)
4. UTIS0025 - Table Maintenance Transaction Sort
5. UTIP0030 - Table File Update
*6.` UTIP0040 - Meter Reading Card Punch
*7. UTIP0050 - Meter Reading Cards to Disk
*8. UTIS0055 - Meter Reading Card Sort
*9. UTIS0060 - Meter Reading Card Edit
*10. UTIP0070 - Calculate Consumption & Update Master
*11. UTIP0080 - Exception Report Extract (Billing Exception)
*12. UTIS0085 - Exception Report Sort (Billing Exception)
*13. UTIP0090 - Exception Report Print (Billing Exception)
14. UTIP0100 - Billing Extract (Bills)
15. UTIS0105 - Deposit Applies /See Who Sort (Bills)
16. UTIP0110 - Deposit Applies /See Who Print (Bills)
17. UTIS0115 - Billing Register Sort (Billing Register)
18. UTIP0120 - Billing Register Print (Billing Register)
19. UTIS0125 - Bill Sort (Bills)
20A. UTIP0130 - Bill Print (Bills)
20B. UTIP0135 - History File Update (History File Update)
*21A. UTIP0140 - Cash Batch Balance
*21B. - Out -of- Balance Cash
22. UTIS0145 - Balance Cash Sort
23. UTIP0150 - Apply Cash; Unmatched Cash
24. UTIP0160 - Report Extract
25. UTIS0165 - Delinquency Sort (Delinquent Notices)
26. UTIP0170 - Delinquency Print (Delinquent Notices)
27. UTIS0175 - Source & Cycle Sort (Revenue Analysis)
28. UTIS0180 - Source & Cycle Print (Revenue Analysis)
29. UTIS0185 - Misc. Reports Sort
30. UTIP0190 - Misc. Reports Print (like format)
31. UTIS0195 - Cycle, Rate & Service Sort (Consumption Analysis)
32. UTIP0200 - Cycle, Rate & Service Prints (Consumption Analysis)
33. UTIP0205 - A/R Control & Deposit Sort (Accounts Receivable, Applied Deposits)
34. UTIP0210 - A/R Control *Deposit Print (Accounts Receivable, Applied Deposits)
*35. High /Lo Reports (High /Lo Billing)
36. Billing Report (High /Lo Billing)
37. Cash Distribution (Cash Distribution)
38. Cut List (Cut List)
39. Transfer Register (Transfer List)
*Programs to be written and implemented by the City's data Processing Staff.
These programs will be written in ANSCOBOL and will employ the external
sort concept. Normal ISAM file techniques will be used, but during Phase I, VSAM
will be taken into consideration.
The CICS utility will be used where data collection is required via
terminals. These sections will be written in conjunction with the City's Data Pro-
cessing staff as mutually agreed upon. Job Control Language and Source Code shall
be established and maintained on the IBM 3277 -2 terminals by means of an IBM Program
Products SPMOL -II.
6. Support to Consultant. The City shall, without charge, provide
the consultant with the following:
a. A general system description to be used by the consultant
as an outline of work to be completed.
b. Finalized file layouts and preliminary report layouts for
all required files and reports.
c. All programming work listed in paragraph 5 and marked by
an asterisk shall be performed by the City.
d. All required data to be used for parallel testing the new sy-
stem against the system presently operating.
e. Functional user manpower to accomplish the execution of the
parallel testing and for evaluation signoff of test results.
f. Overnight turnaround for keypunching and typing support as
required by the IAI project team while on site.
g. System software with the following features:
DOS /VS operating system
ANS COBOL
COBOL "SEARCH" VERB (table searching)
COBOL "CALL" VERB
COBOL "COPY" VERB
�:i
Index Sequential Access Method
h. Any other reasonably necessary support.
Additionally, City will ensure that such technical support as is
required for establishing libraries, creating test files, producing compilations
and executing tests will be provided in a timely manner.
7. Staffing. City will appoint a project coordinator in the person
of Mr. Marvin Koehl who will act as the primary interface with the IAI project team
and who will devote his time to this project in substantially the percentages indi-
cated:
Phase I, 30 -40%
Phase II, 10 -15%
Phase III, 30 -40%
Phase IV, As required
for the purpose of monitoring project status, for coordination of testing schedules,
and participation in the review and sign off of the systems design specifications
and the parallel test results. He will be responsible for reporting any problems
to the IAI project manager.
In the event City is unable to provide the services of Mr. Marvin
Koehl due to events beyond its control, the City will provide a project coordina-
tor of equivalent technical capability.
IAI will appoint as its project manager a systems consultant whose
primary responsibility will be that of meeting the project goals within the agreed -
upon timeframe. IAI will also provide additional technical resources as deemed
necessary by IAI during the various phases of the project.
8. Status Reporting. The IAI project manager and the City's project
coordinator will be responsible for informing City of the status of the project
through formal, written status reports which will be issued weekly or as otherwise
mutually agreed upon. Reports will be written in a mutually agreeable format and
will reflect last period accomplishments, next period expectations, and any diffi-
culties encountered or anticipated. Status reports will be issued to the Data
Processing Office, the Public Utilities Office, and the City Manager's Office.
In addition to written reporting, an ongoing verbal communica-
tion between project managers will be established and maintained in order to
resolve all matters in a timely manner.
9. Method of Payment. The total contract price is $62,400.00,
payable in the following installments:
First Payment upon Phase I completion . . . . . $12,300
Second Payment upon Phase II completion . . . . $29,800
Third Payment upon Phase III completion $ 8,000
Final Payment upon completion of all of the
contracted work and the utility billing sy-
stem has been in full production for a period
of 90 days (notwithstanding anything else
herein contained to the contrary) . . . . . . . $12,300
City will reimburse IAI for reasonable project related expenses,
including travel and living expenses, as incurred by IAI, but in no case shall
the City be required to reimburse for such expenses in excess of $15,000. Prior
to incurring any single expense in excess of $1,000 for which IAI expects to be
reimbursed, IAI shall notify the Data Processing Manager of the City of Corpus
Christi of its intention to incur such expense. If IAI should fail to give this
notification of such expense, City shall not be obligated to make any reimbursement
therefore unless City later makes or specifically agrees in writing to make such
reimbursement. IAI shall submit to the Data Processing Manager a monthly written
report of all expenses incurred for which IAI expects to be reimbursed.
10. Termination. Either party may terminate this agreement on written
notice to the other party provided that such notice is given at least ten (10)
business days prior to signoff of the completed phase. Termination will become
effective upon phase completion only. The City's obligation to pay charges
which are due will survive the termination but will be limited to the payments
described in paragraph 9 Method of Payment, for each phase completed, plus all
reimbursable expenses incurred by IAI up to the date of termination. The phases
referred to herein are those described in paragraph 4.
11. Avoidance of Dela . To avoid possible delay in the project sche-
dule, the City will:
a. Sign off upon each phase completion
b. Provide adequate turnaround time for keypunching and typing
services.
c. Review with IAI the Parallel testing.
d. Perform programming work in a timeframe which is consistent
with the project phases.
e. Provide IAI with adequate machine time and functional per-
sonnel time during Parallel testing.
f. City will request specification changes during Phase I only.
g. Assign qualified personnel to the project in the required
timeframe.
h. For the services specified herein, City will pay IAI the
charges provided for herein. Payment for such charges will
be made by City within 30 days after receipt of IAI's invoices.
Should such payment not be so made, work upon the next phase
will not commence until payment is made.
i. IAI shall not be responsible for any failure to perform its
covenants under this agreement due to causes beyond its con-
trol. Such causes shall include, but not be limited to acts
of God, riots, strikes, acts of federal, state or local Govern-
ment or any agency thereof, and judicial action.
12. Software. All software other than material developed for use with
IAI licensed Program Products, shall become the property of the City upon comple-
tion of the Phase IV. Upon final testing, IAI shall provide system flowcharts
and operator run instructions for each program. IAI shall also furnish the City
a narrative explaining the specific function of each program.
13. Modifications. This agreement constitutes the entire agreement
between the parties relating to the services and is binding upon their respective
successors and transferees. No change shall be made in any of its terms, nor any
provision waived without the written consent of both parties.
14. This contract, when signed by IAI and returned, shall constitute
said party's proposal. This contract does not become effective until awarded and
executed by the City.
EXECUTED in duplicate originals this the , day of ,
EXECUTED in duplicate originals this the _ day of ,
1978, by the authorized representatives of the parties.-
ATTEST: INFORMATION ASSOCIATES, INC.
Secretary
ATTEST: CITY OF CORPUS CHRISTI, TEXAS
By
City Secretary R. Marvin Townsend, City Manager
APPROVED:
DAY OF 197878:
J. Bruce Aycock, City Attorney
By
Assistant City Attorney
Director of Finance
GLOSSARY OF TERMS
Accounts Receivable
A monetary transaction against an account,
either billing, payment, adjustment, etc.
Applied Deposits
Are deposits received at the customer's initial
connection, that are applied to the customer's
final bill as payment.
Batch Systems
Systems, programs, or jobs which are collected
into groups prior to processing.
Billing Exception
Failure, for some reason, to produce a bill
for an account.
Billing Register
A summary report, produced by each billing
cycle, of each account in that particular cycle.
Bills
Invoices which are mailed to the customers
each month advising them of the amount of
utility services used that month and the cost
of those services.
Cash Distribution
The apportionment of the customer's payment
according to a calculated percentage based
upon the consumption of the services used.
CICS /VS
An acronym for Customer Information Control
Ystem /Virtual Storage and is a coding lan-
guage used for on -line processing.
COBOL
An acronym for Common Business Oriented Lan-
guage which has widespread use as a program-
ming language.
Consumption Analysis
A listing of consumption according to services
used.
CRT
An acronym for Cathode Ray Tube which is basic-
ally a television screen, with a keyboard,
used for entering and displaying programs and
data.
Cut List
A list of accounts for which service is to
be terminated for some reason.
Delinquent Notices
A second invoice sent to the utility customers
advising them that the prescribed date for
payment of their utility bill has passed.
Hardware
The physical equipment or devices forming a
computer and peripheral equipment, as opposed
to the programs (see Software).
Hi -Lo Billing
A listing of accounts for which current con-
sumption varies from average consumption by
more than a specified percentage.
History File
A file consisting of all accounts receivable
transactions occurring against an account
over a 13 -month period. -
History File Update & Edit
The editing of all accounts receivable infor-
mation for errors before updating the accounts
receivable master file.
"IBM Program Product, SPMOL II
A licensed software package which allows the
preparation of data and /or programs from a
terminal, thereby eliminating the use of
punched cards.
ISAM
An acronym for Index Sequential Access Method
and is type of storage in which data can be
retrieved or processed sequentially or randomly,
according to a predefined individual key within
a record.
Job Control Language
Statements which instruct the computer how to
process the job to be executed and the loca-
tion of the data to be processed.
Mark -Sense Capability
A technique for detecting special pencil marks
entered in special places on a punched card,
and automatically translating the marks into
punched holes.
Master File Maintenance & Edit
Routine processing of the utility files and
editing of all information for errors.
Master File Update & Edit
Routine processing of the utility files and
editing of all information for errors before
updating.
On -Line Programs
Are programs which are under control of the
Control Processing Unit and can be activated
from a terminal (CRT) as opposed to punched
cards.
Revenue Analysis
A listing of payments received disbursed by
types of service.
Software
Programs and routines used to extend the cap-
abilities of computers, as opposed to the
actual machinery (see Hardware).
Source Code
The original coding form in which a program
is prepared before being processed by the
computer.
Transfer Register
A listing of accounts which have changed from
one account to another.
VSAM
An acronym for Virtual Storage Access Method
and is a type oi' storage in which data is read
into main storage, as needed, and placed into _
secondary storage when not being used.
2
Corpus Christi, Texa
-CJ day of lg��
TO THE MEMBERS OF THE CITY COUNCIL
Corpus Christi, Texas
For the reasons set forth in the emergency clause of the foregoing ordinance,
a public emergency and imperative necessity exist for the suspension of the
Charter rule or requirement that no ordinance or resolution shall be passed
finally on the date it is introduced, and that such ordinance or resolution
shall be read at three meetings of the City Council; I, therefore, request
that you suspend said Charter rule or requirement and pass this ordinance
finally on the date it is introduced, or at the present meeting of the City
Council.
1 Respectfully,
14C3,,-2
!:�WRPOS CHRISTI, TEXAS
low•i.ng vote=
THE
The Charter rule was suspended
by
Gabe Lozano, Sr.
Bob Gulley
David Diaz
Ruth Gill
Joe Halt
Tony Juarez, Jr.
Edward L. Sample
The above ordinance was passed
by
Gabe Lozano, Sr.
Bob Gulley
David Diaz
Ruth Gill
Joe Holt
Tony Juarez, Jr.
Edward L. Sample
14C3,,-2
!:�WRPOS CHRISTI, TEXAS
low•i.ng vote=