City of Columbus - File #: 1473-2010

• File #: 1473-2010
• Version: 1
• Type: Ordinance
• Status: Passed
• File created: 10/4/2010
• In control: Administration Committee
• On agenda: 11/1/2010
• Final action: 11/4/2010
• Title: To authorize the Director of the Department of Finance and Management for the Department of Technology to establish a purchase order with Lawson Software to purchase Lawson Process Flow Integrator (PFI) software licenses and training as part of the Columbus Human Resource Information System (CHRIS); in accordance with the sole source provisions of the Columbus City Code; and to authorize the expenditure of $27,500.00 from the Department of Technology Information Services Capital Improvement Fund. ($27,500.00)

Date	Ver.	Action By	Action	Result
11/4/2010	1	CITY CLERK	Attest
11/3/2010	1	MAYOR	Signed
11/1/2010	1	Columbus City Council	Approved	Pass
11/1/2010	1	COUNCIL PRESIDENT	Signed
10/22/2010	1	Auditor Reviewer	Reviewed and Approved
10/22/2010	1	CITY AUDITOR	Reviewed and Approved
10/22/2010	1	Technology Drafter	Sent for Approval
10/22/2010	1	CITY ATTORNEY	Reviewed and Approved
10/22/2010	1	Technology Drafter	Sent to Clerk's Office for Council
10/21/2010	1	FINANCE DIRECTOR	Reviewed and Approved
10/21/2010	1	Technology Drafter	Sent for Approval
10/20/2010	1	Finance Reviewer	Reviewed and Approved
10/20/2010	1	Finance Reviewer	Sent for Approval
10/20/2010	1	Finance - Purchasing Reviewer	Reviewed and Approved
10/19/2010	1	ODI DIRECTOR	Reviewed and Approved
10/19/2010	1	Technology Drafter	Sent for Approval
10/18/2010	1	Technology Drafter	Sent for Approval
10/18/2010	1	EBOCO Reviewer	Sent for Approval
10/15/2010	1	Technology Drafter	Sent for Approval
10/15/2010	1	TECHNOLOGY DIRECTOR	Reviewed and Approved

Explanation

BACKGROUND
This legislation authorizes the Director of the Department of Finance and Management to establish a purchase order for the Department of Technology with Lawson Software, to purchase licenses and training for the Lawson Process Flow Integrator (PFI) software. As part of the Columbus Human Resources Information System (CHRIS), this new software will enable the City to integrate the Lawson CHRIS software with other applications utilized as part of CHRIS using a tool specially developed by Lawson for use with its software products. Lawson PFI will also enable integration with other non-Lawson systems (e.g., existing time-keeping systems) currently utilized throughout the City.

As part of the original Lawson Software purchase, associated with purchase order EL007511, the City purchased Lawson Process Flow Professional as part of the Lawson Business Intelligence Suite. Since then, it has been discovered that this software product does not enable the City to automate some key business processes, including the electronic approval of payroll by appointing authorities and the electronic approval of personnel actions. Both of these functions are required before the City can complete Phase I of the CHRIS project. The new Lawson Process Flow Integrator will enable the necessary automation. Furthermore, Lawson Software will no longer support Process Flow Professional after May 31, 2011, so it is necessary to upgrade to the next-generation Process Flow Integrator software.

The initial software license cost is $40,000.00, however, with a $21,500.00 discount off the regular price of Lawson PFI, which Lawson will honor until November 8, 2010, the purchase price is $27,500.00 ($18,500.00 for software licenses and $9,000.00 for training). The initial maintenance coverage period associated with this purchase will begin the date the purchase order is certified by the Columbus City Auditor through May 31, 2011. Subsequent annual maintenance cost...