Agenda

Back to Calendar Return

AI- 45541

Commissioners Court

Meeting Date:	10/22/2018
Award of Shift Scheduling Software
Submitted By:	Greg Elliott
Department:	Information Technology
Request Type:	CONSENT	Agenda Area:	Award

Information

Department Action

The Collin County Information Technology department, on behalf of the Office of the Sheriff, recommends the award of Tyler Executime software as the third phase of the Access Control and Time Collection project to provide 24-hour shift scheduling functions. Funding is available under project BDR06210 / account code 0001-06019-0009-41-40-0000-809002.

Tyler Executime, part of the Tyler Technologies software family, provides advanced scheduling software which will automate and improve the complex shift scheduling required to keep the detention center operating within statutorily mandated parameters. As part of the Tyler solution set, the county will benefit from increased integration points between Tyler Munis (our ERP system), Tyler Odyssey (our case management and jail system), and Tyler Executime. This software will replace much of the manual activity required to develop detention officer schedules.

Existing integration points, both to PeopleSoft and KABA, will decrease the need for Collin County to develop interfaces between the systems and will allow the county to leverage Tyler for any required modifications needed to accommodate county specific business needs.

Purchasing Department Action

Commissioners' Court consideration and any action regarding approval of award of Contract 2018-198, Shift Scheduling Software to Tyler Technologies, Inc. per the Sourcewell (formerly known as National Joint Powers Alliance-NJPA) contract 110515-TTI Technology, Security & Communication Solutions, project total for Year 1 is $135,067.00 plus estimated travel expenses of $10,960.00; further authorize the Purchasing Agent to execute same. mc

Years 2 - 5 maintenance will be at the following rates:

Year 2 = $11,150.64

Year 3 = $11,373.65

Year 4 = $11,828.60

Year 5 = $12,301.74

HR and/or IT Action

Budget Department Action

Budgeted funds available. FY 2018 budgeted funds were carried over into FY 2019. 0001 - General Fund

Auditor's Office Action

Funds available in the General Fund.

Commissioners Court

Shift Scheduling Software (Contract No. 2018-198) to Tyler Technologies, Inc. and further authorize the Purchasing Agent to finalize and execute the License and Services Agreement for same, Information Technology.

Budget Information

Information about available funds

Budgeted:

Funds Available:

Adjustment:

Amount Available:

Unbudgeted:

Funds NOT Available:

Amendment:

Account Code(s) for Available Funds
1:	See Below

Fund Transfers

Remarks:

BDR06210 0001-06019-0009-41-40-0000-809002

Attachments
Court Order
Court Memo
Agreement
Microsoft Windows Server Operating System Compliance
Executive Summary
Evaluation Spreadsheet
Form 2270
Form 2252