header-left
File #: 0649-2007    Version: 1
Type: Ordinance Status: Passed
File created: 4/16/2007 In control: Administration Committee
On agenda: 6/4/2007 Final action: 6/11/2007
Title: To amend the 2007 Capital Improvements Budget; to authorize the transfer of money within the Water Works Enlargement Voted 1991 Bonds Fund, the Voted Street Lighting and Electricity Distribution Improvements Fund, the Voted Storm Sewer Bond Fund and the Voted Sanitary Bond Fund; to authorize the Director of the Department of Technology on behalf of the Department of Public Utilities, to modify the contract with Ventyx Inc., for software licenses, upgrades and related services; to authorize the Director of the Department of Technology to modify past, present and future contracts and purchase orders with Indus Utility Systems, Inc. to Ventyx Inc.; to authorize the expenditure of $577,000.00 from the Department of Public Utilities' Capital Improvement Funds for this purpose; and to declare an emergency. ($577,000.00)
Date Ver.Action ByActionResultAction DetailsMeeting Details
6/11/20071 CITY CLERK Attest  Action details Meeting details
6/8/20071 MAYOR Signed  Action details Meeting details
6/4/20071 Columbus City Council ApprovedPass Action details Meeting details
6/4/20071 COUNCIL PRESIDENT Signed  Action details Meeting details
5/22/20071 Finance Reviewer Reviewed and Approved  Action details Meeting details
5/22/20071 Finance Reviewer Reviewed and Approved  Action details Meeting details
5/22/20071 FINANCE DIRECTOR Reviewed and Approved  Action details Meeting details
5/22/20071 Utilities Drafter Sent for Approval  Action details Meeting details
5/22/20071 CITY ATTORNEY Reviewed and Approved  Action details Meeting details
5/22/20071 Utilities Drafter Sent to Clerk's Office for Council  Action details Meeting details
5/22/20071 Technology Drafter Sent to Clerk's Office for Council  Action details Meeting details
5/21/20071 Utilities Drafter Sent for Approval  Action details Meeting details
5/21/20071 Technology Drafter Sent for Approval  Action details Meeting details
5/21/20071 Auditor Reviewer Reviewed and Approved  Action details Meeting details
5/21/20071 CITY AUDITOR Reviewed and Approved  Action details Meeting details
5/21/20071 Utilities Drafter Sent for Approval  Action details Meeting details
5/18/20071 Auditor Reviewer Reviewed and Disapproved  Action details Meeting details
5/18/20071 Technology Drafter Sent for Approval  Action details Meeting details
5/17/20071 FINANCE DIRECTOR Reviewed and Approved  Action details Meeting details
5/17/20071 Utilities Drafter Sent for Approval  Action details Meeting details
5/16/20071 Finance Reviewer Reviewed and Approved  Action details Meeting details
5/16/20071 Finance Reviewer Reviewed and Approved  Action details Meeting details
5/14/20071 ODI DIRECTOR Reviewed and Approved  Action details Meeting details
5/14/20071 Utilities Drafter Sent for Approval  Action details Meeting details
5/14/20071 Technology Drafter Sent for Approval  Action details Meeting details
5/10/20071 EBOCO Reviewer Reviewed and Approved  Action details Meeting details
5/3/20071 Technology Drafter Sent for Approval  Action details Meeting details
5/2/20071 TECHNOLOGY DIRECTOR Reviewed and Approved  Action details Meeting details
5/1/20071 Technology Drafter Sent for Approval  Action details Meeting details
4/26/20071 UTILITIES DIRECTOR Reviewed and Approved  Action details Meeting details
4/26/20071 Utilities Drafter Sent for Approval  Action details Meeting details
4/24/20071 Utilities Reviewer Reviewed and Approved  Action details Meeting details
4/24/20071 Utilities Reviewer Sent for Approval  Action details Meeting details
Explanation
 
BACKGROUND:   
This ordinance will allow the Department of Technology (DoT) to modify a contract with Ventyx Inc. (Ventyx), formerly known as Indus Utility Systems, Inc. (Indus); it will provide the change of the company name and Federal Identification (FID) number for contracts and purchase orders currently in process and established with Indus Utility Systems, Inc. (Indus).  This ordinance will authorize the assignment of all past, present and future business done by the City of Columbus with Indus Utility Systems, Inc., FID 23-2296631 to Ventyx Inc., FID 94-3273443; with the contract compliance expiring on 06/19/2008.  
 
The modification, associated with this ordinance will provide upgrades and related services to existing software licenses.  This upgrade is needed to continue with the migration of the Department of Public Utilities Water and Sewer Information Management System (WASIMS).  The current WASIMS system was implemented in 1999 and was implemented only to support the billing of City water, sewer and stormwater customers.  The current system is old and outdated by current data processing standards; it is very limited in that special software must be used to access and use the system.  Additionally, the current electricity billing system is older than the WASIMS system.  It is imperative that this system be replaced due to the aged equipment and the non-standard computer language in which it is written.
 
During fiscal year 2000, the original contract, initiated in 1994, was assumed by the Department of Technology along with the operations and maintenance responsibilities.  The original contract, Section 12, provides for modifications and changes in scope of service.  Authorizing this contract modification, in the amount of $577,000, will allow DoT, on behalf of the Department of Public Utilities, to implement and install upgrades and related services to an existing system, currently supported by Ventyx.  The upgrades will allow the Department of Public Utilities to move to a system that will be readily accessible with only an Internet browser.  Also, the upgrades will allow DPU to retire the current electricity billing system and replace it with the new WASIMS.  Without the upgrades and modification, the current system will remain difficult to access and use, which may cause for potential failure of the current electric billing system; thus creating a negative impact to customer service.  
 
The software licenses have been in use for several years and are currently being supported at version Banner 3.1.1.  This software licenses upgrades are necessary to implement a key goal of the Department of Public Utilities' Technology Master Plan, which recommends that the Department of Public Utilities standardize on one billing system for both water and electric power services.  In addition to providing the necessary functionality for successful implementation, the upgrades will greatly increase customer service.
 
Funds for this upgrade, totaling $577,000, have been identified in the Department of Public Utilities' Capital Improvements Fund.
 
 
FISCAL IMPACT:  Thus far this year, The Department of Technology has written legislation, Ordinance # 0674-2007, to approve the expenditure of $307,611.00 for annual renewal of services provided by Ventyx (formerly known as Indus).  Prior to the passage of Ordinance # 0674-2007, the Department of Technology, on behalf of the Department of Public Utilities encumbered an aggregate total of $2,380,536.10 with Indus for software license, support, upgrades, maintenance and related services.  The expenditure, in the amount of $577,000 for the software licenses, upgrades and related services, has been identified in the Department of Public Utilities' Capital Improvement Budget. Approval of this ordinance will bring the contract aggregate total to $3,265,147.10.
 
EMERGENCY:
This service is a key goal of the overall Department of Public Utilities Technology Master Plan and emergency legislation is being requested so that the implementation of upgrade can be accomplished without interruption or delays.
 
CONTRACT COMPLIANCE:   94-3273443  Expiration: 06/19/2008
 
 
Title
 
To amend the 2007 Capital Improvements Budget; to authorize the transfer of money within the Water Works Enlargement Voted 1991 Bonds Fund, the Voted Street Lighting and Electricity Distribution Improvements Fund, the Voted Storm Sewer Bond Fund and the Voted Sanitary Bond Fund; to authorize the Director of the Department of Technology on behalf of the Department of Public Utilities, to modify  the contract with Ventyx Inc., for software licenses, upgrades and related services; to authorize the Director of the Department of Technology to modify past, present and future contracts and purchase orders with Indus Utility Systems, Inc. to Ventyx Inc.; to authorize the expenditure of $577,000.00 from the Department of Public Utilities' Capital Improvement Funds for this purpose; and to declare an emergency. ($577,000.00)  
 
Body
 
WHEREAS, Indus Utility Systems, Inc. (Indus) and the Department of Public Utilities executed contract CT-15918 in 1994 under Ordinance 1996-94 for Technical Agreement (TCP Agreement) and Technical Currency Support Services, and
 
WHEREAS, this legislation authorizes the Department of Technology (DoT) on behalf of the Department of Public Utilities to modify contract CT-15918 with Ventyx Inc., formerly known as Indus Utility Systems, Inc. (Indus), for software licenses, upgrades and related services, associated with the Water and Sewer Information Management System (WASIMS); and
 
WHEREAS, this ordinance will authorize the assignment of all past, present and future business done by the City of Columbus with Indus Utility Systems, Inc., FID 23-2296631 to Ventyx Inc., FID 94-3273443; with the contract compliance expiring on 06/19/2008; and  
 
WHEREAS, it is necessary to authorize amendments to the 2007 Capital Improvements Budget for purposes of providing sufficient funding and spending authority for the aforementioned project expenditure; and
 
WHEREAS, it is necessary to transfer money within the Water Works Enlargement Voted 1991 Bonds Fund; Voted Street Lighting and Electricity Distribution Improvements Fund; Voted Storm Sewer Bond Fund; and Voted Sanitary Bond Fund; and
 
WHEREAS, authorizing this contract modification, in the amount of $577,000, will allow for upgrades and related services so that two old data systems can be retired or updated; and
 
WHEREAS, an emergency exits in the usual daily operation of the Department of Technology on behalf of the Department of Public Utilities, Division of Water in that it is immediately necessary to modify a contract with Indus Utility Systems, Inc. for software licenses, upgrades and related services, associated with the Water and Sewer Information Management System (WASIMS) for the preservation of public health, peace, property and safety; now, therefore,
 
BE IT ORDAINED BY THE COUNCIL OF THE CITY OF COLUMBUS:
 
 
SECTION 1: That the Director of the Department of Technology, on behalf of the Department of Public Utilities, Water Division be and is hereby authorized to modify all past, present and future contracts and purchase orders pursuant to those contracts to reflect the change of the company name FID number from Indus Utility Systems, Inc. (23-2296631) to Ventyx Inc. (94-3273443), for licenses upgrades and related services, for the Water and Sewer Information Management System (WASIMS).
 
 
SECTION 2: That the expenditure of $577,000.00 or so much thereof as may be necessary is hereby authorized to be expended from:
 
Division of Power and Water (Water):
Dept. 60 | Div. 09 | Fund No. 606 | Fund Name: Water Works Enlargement Voted 1991 Bonds Fund | Project No. 690374 | OCA 642900 | OL1 06 | OL3 6649 | Amount $207,720
 
Division of Power and Water (Power):
Dept. 60 | Div. 07 | Fund No. 553 | Fund Name: Voted Street Lighting and Electricity Distribution Improvements Fund | Project No. 670638 | OCA 670638 | OL1 06 | OL3 6649 | Amount $11,540
 
Division of Sewerage and Drainage (Stormwater):
Dept. 60 | Div. 15 | Fund No. 685 | Fund Name: Voted Storm Sewer Bond Fund | Project No. 611006 | OCA 681006 | OL1 06 | OL3 6649 | Amount $150,020
 
Division of Sewerage and Drainage (Sanitary):
Dept. 60 | Div. 05 | Fund No. 664 | Fund Name: Voted Sanitary Bond Fund | Project No. 650003 | OCA 664003| OL1 06 | OL3 6649 | Amount $207,720
 
 
SECTION 3: That the 2007 Capital Improvements Budget is hereby amended as follows:
 
Division of Power and Water (Water):
Project No. | Project Name | Current Authority | Revised Authority | (change)
 
690374 | Water and Sewer Information Management System | $200,520 | $207,720 | (+$7,200) |  (amending after Jordan's seen 0704-07)
690236 | Water Main Rehabilitation | $12,438,607 | $12,431,407 | (-$7,200) |  (amending after Jordan's seen 0704-07)
 
Division of Power and Water (Power):
Project No. | Project Name | Current Authority | Revised Authority | (change)
 
670638 | Computer System Upgrades | $11,140 | $11,540 | (+$400) |   (amending after Jordan's seen 0704-07)
670060 | Morse Rd. 138KV Line | $224,618 | $224,218 | (-$400) |   (amending after Jordan's seen 0704-07)
 
Division of Sewerage and Drainage (Stormwater):
Project No. | Project Name | Current Authority | Revised Authority | (change)
 
611006 | Water and Sewer Information Management System | $0 | $150,020 | (+$150,020)
610994 | McDannald Estates SSI | $2,209,950 | $2,059,930 | (-$150,020)
 
Division of Sewerage and Drainage (Sanitary):
Project No. | Project Name | Current Authority | Revised Authority | (change)
 
650003 | Water and Sewer Information Management System | $0 | $207,720 | (+$207,720)
650704 | OSIS Augment Sewer, Whittier-JPWWTP| $10,083,000 | $9,875,280 |(-$207,720)
 
 
SECTION 4:  That the City Auditor is hereby authorized to transfer cash as follows:
 
Division of Power and Water (Water):
Dept./Div.: 60-09
Fund No. 606
Fund Name: Water Works Enlargement Voted 1991 Bonds Fund
OL1: 06
OL3: 6649
 
TRANSFER FROM:
Project No | Project Name | OCA Code | Amount
690236 | Water Main Rehabilitation | 642900 | -$200,520 (Jordan's already seen this)
690450 | Griggs Booster Station | 690450 | -$7,200 (new transfer)
 
TRANSFER TO:      
Project No | Project Name | OCA Code | Amount
690374 | Water and Sewer Information Management System | 642900 | +$200,520 (Jordan's already seen this)
690374 | Water and Sewer Information Management System | 642900 | +$7,200 (new transfer)
 
 
Division of Power and Water (Power):
Dept./Div.: 60-07
Fund No. 553
Fund Name: Voted Street Lighting and Electricity Distribution Improvements Fund
OL1: 06
OL3: 6649
 
TRANSFER FROM:
Project No | Project Name | OCA Code | Amount
670060 | Morse Rd. 138KV Line | 675207 | -$11,140 (Jordan's already seen this)
670060 | Morse Rd. 138KV Line | 675207 | -$400 (new transfer)
 
TRANSFER TO:      
Project No | Project Name | OCA Code | Amount
670638 | Computer System Upgrades | 670638 | +$11,140 (Jordan's already seen this)
670638 | Computer System Upgrades | 670638 | +$400 (new transfer)
 
 
Division of Sewerage and Drainage (Stormwater):
Dept./Div.: 60-15
Fund No. 685
Fund Name: Voted Storm Sewer Bond Fund
OL1: 06
OL3: 6649
 
TRANSFER FROM:
Project No | Project Name | OCA Code | Amount
610994 | McDannald Estates SSI | 610994 | -$150,020
 
TRANSFER TO:      
Project No | Project Name | OCA Code | Amount
611006 | Water and Sewer Information Management System | 681006 | +$150,020
 
 
Division of Sewerage and Drainage (Sanitary):
Dept./Div.: 60-05
Fund No. 664
Fund Name: Voted Sanitary Bond Fund
OL1: 06
OL3: 6649
 
TRANSFER FROM:
Project No | Project Name | OCA Code | Amount
650704 | OSIS Augment Sewer, Whittier - JPWWTP | 664704 | -$207,720
 
TRANSFER TO:      
Project No | Project Name | OCA Code | Amount
650003 | Water and Sewer Information Management System | 664003 | +$207,720
 
 
SECTION 5:  That the City Auditor is authorized to make any acounting changes to revise the funding source for all contracts or contract modifications associated with this Ordinance.
 
 
SECTION 6:  That for the reasons stated in the preamble hereto, which is hereby made a part hereof, this ordinance is hereby declared to be an emergency measure and shall take effect and be in force from and after its passage and approval by the Mayor, or ten days after passage if the Mayor neither approves nor vetoes the same.