The URL can be used to link to this page

Browse Search

Home My WebLink About20140802.tiffCor40, %--Rocl BOARD OF COUNTY COMMISSIONERS PASS -AROUND REVIEW PASS -AROUND TITLE: 2024 Renewal for Harris / Realware Software DEPARTMENT: Information Technology PERSON REQUESTING: Ryan Rose DATE: 12/723 Brief description of the problem/issue: This agreement propose to renew software services for Harris/Realware, the Appraisal system used by the Weld County Assessor. The agreement has been reviewed by the County Attorney's office, and the software costs are included in the annual fiscal year budget. What options exist for the Board? 1) Approval Renewal of this software 2) Schedule a work session to discuss options Consequences: Operationally critical software for the Assessor's Office Impacts: Renewal allows for continued operations Cost (Current Fiscal Year/Ongoing or Subsequent Fiscal Years: $239,369 Recommendation: It is the recommendation of the Department of Information Technology and the recommendation of the County Assessor to renew this software for another calendar year. Support Recommendation Schedule Place on BOCC Agenda Work Session Perry L. Buck, Pro-Tem Mike Freeman, Chair Scott K. James Kevin D. Ross Lori Saine Other/Comments: Cor6O- Ple,r)ds- 12A$l23 cc: OnBase, �T Valad1a3 201 -off I�C�UZ Cheryl Hoffman From: Sent: To: Subject: Cheryl Hoffman Wednesday, December 13, 2023 12:30 PM Cheryl Hoffman 8 Passarounds Today 11:56 AM Hi mike, I just sent you 8 pass arounds. Could you please review? I hope you're having a wonderful time Cheryl, I just reviewed all 8 and I am good with all of them. Mike Thank you mike. That's all I need. ' Delivered !Cheryl- L. Hoffman Deputy Clerk to the Board 1150 O Street/P.O. Box 758 Greeley, CO 80632 Tel: (970) 400.4227 choffman@weld.gov r)i HARRIS N.. 1 GOVERN Harris Govern 2721 Council Tree Ave, Suite 248 Fort Collins, CO 80525 Sales Phone: (972) 882-1858 Support Phone: (972)265-730o CONTRACT AGREEMENT EXTENSION/RENEWAL BETWEEN THE WELD COUNTY DEPARTMENT OF INFORMATION TECHNOLOGY AND HARRIS SYSTEMS USA, Inc. This Agreement Extension/Renewal ("Renewal"), made and entered into 18th of December, by and between the Board of Weld County Commissioners, on behalf of the Weld County Department of Information Technology, hereinafter referred to as the "Department", and Harris Systems USA, Inc, hereinafter referred to as the "Contractor". WHEREAS the parties entered into an agreement (the "Original Agreement") identified by the Weld County Clerk to the Board of County Commissioners as document No.2014-0802, approved on 4/2/2014. WHEREAS the parties hereby agree to extend the term of the Original Agreement in accordance with the terms of the Original Agreement, which is incorporated by reference herein, as well as the terms provided herein. NOW THEREFORE, in consideration of the premises, the parties hereto covenant and agree as follows: The parties agree to extend the Original Agreement for an additional 1 -year period which will begin January 1, 2024 and will end of December 31, 2024. The Renewal, including invoices for the 2024 maintenance, constitutes the entire understanding between the parties. All other terms and conditions of the Original Agreement remain unchanged. IN WITNESS WHEREOF, the parties hereto have duly executed the Agreement as of the day, month, and year first above written. CONTRACTOR: Mark Tesreau, VP Client Services Printed Name Signature ATTEST:-- ,f CI • ;"`" BOARD OF COUNTY COMMISSIONERS Weld County Clerk to the Board BY: WELD COUNTY, COLORADO Deputy Clerk f the r �'�[ �\ Perry L. Bud', Chair Pro-Tem DEC 1 8 2023 j`�•HARRIS GOVERN 2024 Summary Maintenance Statement Weld County Assessor Billing Cycle: January Harris Govern 2721 Council Tree Ave #248 Fort Collins, CO 80525 Phone: 972-881-1858 Fax: 214-722-0019 Year Software or Service 2024 RealWare 2024 Marshall & Swift Maintenance 2024 Matix Maintenance 2024 Marshall & Swift Admin Maintenance Subcategory Amount $147,818.00 $44,697.00 $31,495.00 $15,359.00 239,369.00 Please note that this 2024 Summary Maintenance Statement is not a bill. Any changes to your services may affect the estimate provided. The Summary Maintenance Statement includes all maintenance products and services associated with the client account, even those not currently live. Duplicate products or services will be removed once migration to a new product or service is complete. If you have Marshall & Swift or Cloud Hosting maintenance included, please note that the values provided are estimates based on your current usage. If you expect significant growth in your jurisdiction, please estimate higher. Billing for these services is based on actual parcel counts and is billed annually in January of each year. If you area client that is subject to sales tax on your software purchases, please be aware that this is not included in the estimate. Beginning in 2024, BIS Consultants' products and services will be billed annually. Harris Govern does not support IT -related issues without an active IT Maintenance contract. Please be advised that the information provided in this Maintenance Statement is confidential and intended only for the entity or individual to whom it is addressed. The statement was printed on 10/13/2023. Contract Form Entity Information Entity Name* HARRIS SYSTEMS USA INC Contract Name* 2024 RENEWAL FOR REALWARE Contract Status CTB REVIEW Entity ID" @00034077 ❑ New Entity? Contract ID 7690 Contract Lead * JMUNDT Contract Lead Email jmundt@co.weld.co.us Parent Contract ID Requires Board Approval YES Department Project # Contract Description* ANNUAL RENEWAL FOR REALWARE, MARSHALL & SWIFT, AND MATIX MAINTENANCE FOR THE COUNTY ASSESSOR. Contract Description 2 Contract Type* AGREEMENT Amount* $239,369.00 Renewable* NO Automatic Renewal Grant IGA Department INFORMATION TECHNOLOGY-GIS Department Email CM- InformationTechnologyGI S@weldgov.com Department Head Email CM- InformationTechnologyGI S- DeptHead@weldgov.com County Attorney GENERAL COUNTY ATTORNEY EMAIL County Attorney Email CM- COUNTYATTORNEY@WEL DGOV.COM Requested BOCC Agenda Due Date Date* 12/14/2023 12/18/2023 Will a work session with BOCC be required?* NO Does Contract require Purchasing Dept. to be included? If this is a renewal enter previous Contract ID If this is part of a MSA enter MSA Contract ID Note: the Previous Contract Number and Master Services Agreement Number should be left blank if those contracts are not in OnBase Contract Dates Effective Date Review Date* Renewal Date 11/01/2024 Termination Notice Period Contact Information Committed Delivery Date Expiration Date* 12/31/2024 Contact Info Contact Name Contact Type Contact Email Contact Phone 1 Contact Phone 2 Purchasing Purchasing Approver Purchasing Approved Date CONSENT 12/14/2023 Approval Process Department Head Finance Approver Legal Counsel RYAN ROSE CONSENT CONSENT DH Approved Date Finance Approved Date Legal Counsel Approved Date 12/14/2023 12/14/2023 12/14/2023 Final Approval BOCC Approved Tyler Ref # AG 121823 BOCC Signed Date Originator JMUNDT BOCC Agenda Date 12/18/2023 Coytho. d1VItotTh BOARD OF COUNTY COMMISSIONERS PASS -AROUND REVIEW. PASS -AROUND TITLE: 2023 Software Renewal - Realware / Harris Government DEPARTMENT: Information Technology PERSON REQUESTING: Ryan Rose rr DATE: 11/7/22 Brief description of the problem/issue: The attached contract renewal will enable the Assessor's Office to continue the use of Assessment Software and related services provided by Harris Government. This software is critical to the Assessor's office for multiple business functions. The County Attorney's Office has reviewed this agreement, and the associated software costs were properly budgeted for through the standard budget cycle. What options exist for the Board? (include consequences, impacts, costs, etc. of options): 1) Sign agreement extending the use of the software for calendar year 2023. Recommendation: The Department of Information Technology and the County Assessor recommend to renew this software agreeement. Perry L. Buck Mike Freeman, Pro -Tern Scott K. James, Chair Steve Moreno Lori Saine °Mill- AlfOa- Agorove Recommendation Work Session Schedule Other/Comments: CC, A 4 4.$‘ Cri) Ill/G/aA JTOO6Z " HARRIS V..- GOVERN Harris Govern 76o North Watters Road, Suite loo Allen,, 75013 Phone: 972.881-1858 Fax:214.722.0019 CONTRACT AGREEMENT EXTENSION/RENEWAL BETWEEN THE WELD COUNTY DEPARTMENT OF INFORMATION TECHNOLOGY AND HARRIS SYSTEMS USA, Inc. 41� -q This Agreement Extension/Renewal ("Renewal"), � made and entered into /6:7 of 0290 , by and between the Board of Weld County Commissioners, on behalf of the Weld County Department of Information Technology, hereinafter referred to as the "Department", and Harris Systems USA, Inc, hereinafter referred to as the "Contractor". WHEREAS the parties entered into an agreement (the "Original Agreement") identified by the Weld County Clerk to the Board of County Commissioners as document No.2014-0802, approved on 4/2/2014. WHEREAS the parties hereby agree to extend the term of the Original Agreement in accordance with the terms of the Original Agreement, which is incorporated by reference herein, as well as the terms provided herein. NOW THEREFORE, in consideration of the premises, the parties hereto covenant and agree as follows: • The parties agree to extend the Original Agreement for an additional 1-vear period which will begin January 1, 2023 and will end of December 31, 2023. • The Renewal, including invoices for the 2023 maintenance, constitutes the entire understanding between the parties. The following change is hereby made to the Contract Documents: • All other terms and conditions of the Original Agreement remain unchanged. IN WITNESS WHEREOF, the parties hereto have duly executed the Agreement as of the day, month, and year first above written. CONTRACTOR: Mark Tesreau, VP Client Services Printed Name Signature ATTEST: dC1Ofeti .d0;(1 BOARD OF COUNTY COMMISSIONERS Weld County Clerk to the Board WELD COUNTY, COLORADO BY: Deputy Clerk Chair , Scott K. James �..; 1 G "IN;;;"HAoRRIS 2023 Summary Maintenance Statement Weld County Assessor Harris Govern 2721 Council Tree Ave #248 Fort Collins, CO 80525 Phone: 972-881-1858 Fax: 214-722-0019 Year Software or Service 2023 RealWare 2023 Marshall & Swift Maintenance 2023 Matix Maintenance 2023 Marshall & Swift Admin Maintenance 2023 Mobile Field Device Maintenance Fee 2023 Cloud Hosting Fee 2023 Mobile Field Device Server Maintenance Fee 2023 Mobile Advanced Mapping Maintenance Amount $134,380.12 $42,125.00 $29,162.02 $14,743.75 $14,500.00 $10,400.00 $9,000.00 $2,375.00 256,685.89 This is not a bill. The Maintenance Summary Statement is used to notify Harris Govern Customers about the 2023 maintenance increases for your particular billing cycle. This statement was printed as of 9/16/2022. Any additions or removal of services may change these posted rates including any applicable replacement of services with BIS Consulting products in relation to our webservices partnership. If you have Marshall & Swift or Cloud Hosting maintenance included, please be aware that these values are estimates based on your current usage. If you anticipate large growth in your county, please estimate higher. Billing for these services are based on actual parcel counts and is billed annually in January of each year. If you are in a county that charges sales tax on your software purchases, please be aware that this is not included in this estimate. Asa reminder, we do not support IT related issues outside issues relating to Hams Govern software if county does not have an active IT Maintenance contract . Information provided in Maintenance Statement is confidential and intended for the entity or individual to whom it is addressed. Contract Form Entity Information New Contract Request Entity Name. HARRIS SYSTEMS USA INC Contract Name" 2023 ANNUAL REALWARE RENEWAL Contract Status CTE REVIEW Entity ID. 00034077 Contract ID 6473 Contract Lead. JMUNDT Contract Lead Email jmundtTco.weld.co.us Contract Description* ANNUAL RENEWAL FOR REALWARE AND ASSOCIATED SERVICES FROM HARRIS Contract Description 2 Contract Type. AGREEMENT Amount. $256,685.89 Renewable NO Automatic Renewal Grant !GA Department INFORMATION TECHNOLOGY-GIS Department Email CM - I nformationTech nologyGISO' weldgov.corn Department Head Email CM- InformationTechnologyGIS- DeptHead0weldgov.com County Attorney GENERAL COUNTY" ATTORNEY EMAIL County Attorney Email CM- COU NTYATTO RN EYO WELDG OV.COM New Entity? Requested BOCC Agenda Date. 11/16/2022 Parent Contract ID Requires Board Approval YES Department Project # Due Date 1 1 12;'2022 Will a work session with BOCC be required?* NO Does Contract require Purchasing Dept. to be included? If this is a renewal enter previous Contract ID If this is part of a NSA enter MSA Contract ID Note: the Previous Contract Number and Master Services Agreement Number should be left blank if those contracts are not in OnBase Contract Dates Effective Date Review Date. 10 ©1,2022 Renewal Date Termination Notice Period Contact Information Committed Delivery Date Expiration Date* 12:31/2023 Contact Info Contact Name Contact Type Contact Email Contact Phone 1 Contact Phone 2 Purchasing Purchasing Approver Purchasing Approved Date CONSENT 11 10;`2022 Approval Process Department Head Finance Approver Legal Counsel RYAN ROSE CONSENT CONSENT DH Approved Date Finance Approved Date Legal Counsel Approved Date 11,`10/2022 11;10!2022 11?10,/2022 Final Approval BOCC Approved Tyler Ref # AG 111622 BOCC Signed Date BOCC Agenda Date 11116/2022 Originator JMUNDT MEMORANDUM coYha�a:15m TO: Esther Gesick, Clerk to the Board Sept 16, 2021 FROM: Ryan Rose, Chief Information Officer SUBJECT: Harris Systems USA, Inc. Agreement Harris Systems USA, Inc. provides software that is used by Weld County. The Assessor's Office uses this software to manage their day-to-day tasks. The attached agreement between the Board Of County Commissioners and Harris Systems USA, Inc. is to extend their annual maintenance agreement. The cost was budgeted and the agreement was reviewed by Legal. We ask that the BOCC approve the agreement as submitted. Con 09/Z-7/zoit I 'ST On3a2e Oct I 1:1 /GA 20l0$UZ c1OOoZ BOARD OF COUNTY COMMISSIONERS PASS -AROUND REVIEW PASS -AROUND TITLE: Harris Systems USA, Inc. Agreement DEPARTMENT: Information Technology PERSON REQUESTING: Ryan Rose, CIO IL DATE: 9/8/2021 Brief description of the problem/issue: Harris Systems USA, Inc. provides software that is utilized by the Assessor's Office to run their day-to-day operations. This agreement is to extend the support for these applications. What options exist for the Board? (include consequences, impacts, costs, etc. of options): This provider specializes in providing this software which will be utilized by the Assessor's Office to manage their daily tasks. Recommendation: The annaul cost for the maintenance is $248,619.56. The contract has been reviewed by Legal. It is recommended that the BOCC approve the agreement. Perry L. Buck Mike Freeman Scott K. James, Pro-Tem Steve Moreno, Chair Lori Saine Approve Schedule Recommendation Work Session Other/Comments: f'!i HARRIS �,.O GOVERN Harris Govern 76o North Watters Road, Suite 100 Allen, TX 75013 Phone: 972.881-1858 Fax: 214.722.0019 CONTRACT AGREEMENT EXTENSION/RENEWAL BETWEEN THE WELD COUNTY DEPARTMENT OF INFORMATION TECHNOLOGY AND HARRIS SYSTEMS USA, Inc. This Agreement Extension/Renewal ("Renewal"), made and entered into 2144'► of Se tiNixV ?,OZi , by and between the Board of Weld County Commissioners, on behalf of the Weld County Department of Information Technology, hereinafter referred to as the "Department", and Harris Systems USA, Inc, hereinafter referred to as the "Contractor". WHEREAS the parties entered into an agreement (the "Original Agreement") identified by the Weld County Clerk to the Board of County Commissioners as document No.2014-0802, approved on 4/2/2014. WHEREAS the parties hereby agree to extend the term of the Original Agreement in accordance with the terms of the Original Agreement, which is incorporated by reference herein, as well as the terms provided herein. NOW THEREFORE, in consideration of the premises, the parties hereto covenant and agree as follows: • The parties agree to extend the Original Agreement for an additional 1 year period which will begin January 1, 2022 and will end of December 31, 2022. • The Renewal, including invoices for the 2022 maintenance, constitutes the entire understanding between the parties. • All other terms and conditions of the Original Agreement remain unchanged. IN WITNESS WHEREOF, the parties hereto have duly executed the Agreement as of the day, month, and year first above written. CONTRACTOR: Angela Keeton Printed Name Signature ATTEST:04) ‘14.40:BOARD OF COUNTY COMMISSIONERS Weld County Clerk to the Board WELD COUNTY, COLORADO Deputy Clerk to the Boar 1T' �J Steve Moreno, Chair SEP 2 7 2021 f'! H ORRIS 2022 Summary Maintenance Statement Weld County Assessor Harris Govern 2721 Council Tree Ave #248 Fort Collins, CO 80525 Phone: 972-881-1858 Fax: 214-722-0019 Year Software or Service Amount 2022 Realware Maintenance 2022 Marshall & Swift Maintenance 2022 Matix Maintenance 2022 Mobile Field Device Maintenance Fee 2022 Marshall & Swift Admin Maintenance 2022 Cloud Hosting Fee 2022 Mobile Field Device Server Maintenance Fee 2022 Mobile Advanced Mapping Maintenance $133,049.63 $37,135.49 $29,162.02 $14,500.00 $12,997.42 $10,400.00 $9,000.00 $2,375.00 248,619.56 Information provided in Maintenance Statement is intended for the entity or individual to whom it is addressed. Information provided is confidential. This is not a bill. The Maintenance Summary Statement is used to notify Harris Govern Customers about the 2022 maintenance increases for your particular billing cycle. Any additions or removal of services may change these posted rates. If you have Marshall & Swift or Cloud Hosting maintenance included, please be aware that these values are estimates based on your current usage. If you anticipate large growth in your county, please estimate higher. Billing for these services are based on actual parcel counts and is billed annually in January of each year. If you are in a county that charges sales tax on your software purchases, please be aware that this is not included in this estimate. Contract Form New Contract Request Entity Information Entity Name* HARRIS SYSTEMS USA INC. Entity ID' ¢.00034077 Contract Name* HARRIS SYSTEMS USA SUPPORT AGREEMENT Contract Status CTB REVIEW Contract Description* 2022 EXTENSION OF SUPPORT FOR APPLICATION (REALWARE) Contract Description 2 Contract Type AGREEMENT Amount * $248,619.56 Renewable* YES Automatic Renewal Grant IGA Department INFORMATION TECHNOLOGY-GIS Department Email CM- InformationTechnologyGI5 weldgov.com Department Head Email CM- InformationTechnologyGIS- DeptHeadgweldgov.com County Attorney GENERAL COUNTY ATTORNEY EMAIL County Attorney Email CM- COU NTYATTORN EY gWELDG OV.COM ❑ New Entity? Contract ID 5255 Contract Lead* MTRUSLOW Contract Lead Email mtruslowco.weId.co.us Requested BOCC Agenda Date* 09:'22:`2021 Parent Contract ID Requires Board Approval YES Department Project # Due Date 09.1 8%2021 Will a work session with BOCC be required?* NO Does Contract require Purchasing Dept. to be included? NO If this is a renewal enter previous Contract ID If this is part of a MSA enter MSA Contract ID Note: the Previous Contract Number and Master Services Agreement Number should be left blank if those contracts are not in On Base Contract Dates Effective Date 01 ±01;'2022 Review Date* 09 01 2022 Termination Notice Period Committed Delivery Date Contact Information Contact Info Contact Name Purchasing Renewal Date 01/012023 Expiration Date Contact Type Contact Email Contact Phone 1 Contact Phone 2 Purchasing Approver Purchasing Approved Date CONSENT 09 22 2021 Approval Process Department Head RYAN ROSE DH Approved Date 09122:2021 Final Approval BOCC Approved BOCC Signed Date BOCC Agenda Date 09`27x2021 Originator MTRUSLOW Finance Approver CONSENT Legal Counsel CONSENT Finance Approved Date Legal Counsel Approved Date 09: 22 r 2021 09.'22, 2021 Tyler Ref # AG092721 MEMORANDUM TO: Esther Gesick, Clerk to the Board July 15, 2020 FROM: Ryan Rose, Chief Information Officer g< SUBJECT: Harris Systems USA, Inc. Annual Maintenance Extension Harris Systems USA, Inc. provides software to the Weld County. The software is used by the Assessor's Office to manage property assessments and conduct their daily business. The attached agreement between the Board Of County Commissioners and Harris Systems USA, Inc is for the annual maintenance support of the software and has been reviewed by Legal. The requested amount for this service is $239,935.72 and was budgeted for in the 2020 budget cycle. We ask that the BOCC approve the agreement as submitted. 1 cc:MT ZT OnbokFsc O%O IDI&O BOARD OF COUNTY COMMISSIONERS PASS -AROUND REVIEW PASS -AROUND TITLE: Harris Systems USA, Inc. Annual Support Agreement DEPARTMENT: Information Technology DATE: 7/13/2020 PERSON REQUESTING: Ryan Rose, CIO Brief description of the problem/issue: Harris Systems USA, Inc. provides software to Weld County for property assessment. The software is used by the Assessor's Office to manage property assessment and to conduct their daily business. This agreement is to extend the support for the Harris products used by the Assessor's Office for and additional year. What options exist for the Board? (include consequences, impacts, costs, etc. of options): The Board has the option to proceed forward with extending this agreement or to terminate it. Recommendation: This vendor specializes in this software. The cost for this request is $239,935.72. The project was budgeted for the 2021 budget cycle and the contract has been reviewed by Legal. Mike Freeman, Chair Scott K. James Barbara Kirkmeyer Steve Moreno, Pro -Tern Kevin D. Ross Aoprove Schedule l commendation Work Session Other/Comments; HARRIS GOVERN Harris Govern 76o North Wafters Road, Suite loo Allen, TX 75013 Phone: g72.881-1858 Fax: 214.722.0019 CONTRACT AGREEMENT EXTENSION/RENEWAL BETWEEN THE WELD COUNTY DEPARTMENT OF INFORMATION TECHNOLOGY AND HARRIS SYSTEMS USA, Inc. min( qThis Agreement Extension/Renewal ("Renewal"), made and entered into /Q of v�--- O�00,140 , by and between the Board of Weld County Commissioners, on behalf of the Weld County artment of Information Technology, hereinafter referred to as the "Department", and Harris Systems USA, Inc, hereinafter referred to as the "Contractor". WHEREAS the parties entered into an agreement (the "Original Agreement") identified by the Weld County Clerk to the Board of County Commissioners as document No.2014-0802, approved on 4/212014. WHEREAS the parties hereby agree to extend the term of the Original Agreement in accordance with the terms of the Original Agreement, which is incorporated by reference herein, as well as the terms provided herein. NOW THEREFORE, in consideration of the premises, the parties hereto covenant and agree as follows: • The parties agree to extend the Original Agreement for an additional 1 year period which will begin January 1, 2021 and will end of December 31, 2021. • The Renewal, including invoices for the 2021 maintenance, constitutes the entire understanding between the parties. The following change is hereby made to the Contract Documents: • All other terms and conditions of the Original Agreement remain unchanged. IN WITNESS WHEREOF, the parties hereto have duly executed the Agreement as of the day, month, and year first above written. CONTRACTOR: Angela Keeton Printed Name .i/ Signature ATTEST: diedait) �• '��r.c+;K. BOARD OF COUNTY COMMISSIONERS Weld County Clerk to the Board WELD COUNTY, COLORADO ottLen4.0aiiityluk. Deputy Clerk to the Board Chair - Mike Freeman AUG 10 2020 2Q/ 1„. 0g € - % HARRIS GOVERN 2021 Summary Maintenance Statement Weld County Assessor Harris Govern 2721 Council Tree Ave #248 Fort Collins, CO 80525 Phone: 972-881-1858 Fax: 214-722-0019 Year Software or Service Amount 2021 Realware Maintenance 2021 Marshall & Swift Maintenance 2021 Matix Maintenance 2021 Mobile Field Device Maintenance Fee 2021 Marshall & Swift Admin Maintenance 2021 FTC - Cloud Hosting Fee 2021 Mobile Field Device Server Maintenance Fee 2021 Mobile Advanced Mapping Maintenance $128,861.63 $34,485.00 $28,244.09 $14,500.00 $12,070.00 $10,400.00 $9,000.00 $2,375.00 239,935.72 Information provided in Maintenance Statement is intended for the entity or individual to whom it is addressed. Information provided is confidential. This is not a bill. The Maintenance Summary Statement is used to notify Harris Govern Customers about the 2021 maintenance increases for your particular billing cycle. Any additions or removal of services may change these posted rates. If you have Marshall & Swift or Cloud Hosting maintenance included, please be aware that these values are estimates based on your current usage. Billing for these services are based on actual parcel counts and is billed in January of each year. If you are in a county that charges sales tax on your software purchases, please be aware that this is not included in this estimate. Contract Form New Contract Request Entity Information Entity Name* HARRIS SYSTEMS USA INC Entity ID* @00034077 Contract Name* HARRIS SYSTEMS ANNUAL MAINTENANCE 2021 Contract Status CM REVIEW ❑ New Entity? Contract ID 3916 Contract Lead* MTRUSLOW Contract Lead Email nittuslow@coweld co us Contract Description* ANNUAL MAINTENANCE AGREEMENT FOR HARRIS SYSTEM SUPPORT Contract Description 2 Contract Type* AGREEMENT Amount* $239.935.72 Renewable* YES Automatic Renewal Grant ICA Department INFORMATION TECHNOLOGY-GIS Department Email C M- InformationTechnologyGIS@w eldgov.com Department Head Email CM-InformationTechnologyGIS- DeptHead@weldgov.com County Attorney GENERAL COUNTY ATTORNEY EMAIL County Attorney Email CM- COUNTYATTO RN EY@WELD GOV.COM Requested BOCC Agenda Date* 0720;2020 Parent Contract ID Requires Board Approval YES Department Project # Due Date 071162020 Will a work session with BOCC be required?* NO Does Contract require Purchasing Dept. to be included? If this is a renewal enter previous Contract ID If this is part of a MSA enter MSA Contract ID Note: the Previous Contract Number and Master Services Agreement Number should be left blank if those contracts are not in OnBase Contract Dates Effective Date Termination Notice Period Review Date* 06/01/2021 Committed Delivery Date Renewal Date* 01/0112022 Expiration Date Contact Information Contact Info Contact Name Purchasing Purchasing Approver CONSENT Approval Process Department Head RYAN ROSE DH Approved Date 08/04/2020 Final Approval BOCC Approved BOCC Signed Date BOCC Agenda Date 0810;2020 Originator MTRUSLOA' Contact Type Contact Email Finance Approver CONSENT Contact Phone 1 Purchasing Approved Date 08/04'2020 Finance Approved Date 08/04/2020 Tyler Ref # AG 081020 Legal Counsel CONSENT Contact Phone 2 Legal Counsel Approved Date 08/042020 Submit Con+rote+ MEMORANDUM TO: Esther Gesick, Clerk to the Board Dec 4, 2019 FROM: Ryan Rose, Chief Information Officer SUBJECT: Harris Systems USA, Inc. RR =I) 44-3.90 Harris Systems USA, Inc provides software to the Assessor's Office for our Realware application. The software is used by the Assessor's Office for their daily functions. The current contract goes through 2019. This amendment is to extend it through December 31, 2020. The agreement was approved by Legal and budgeted in the 2020 budget cycle. The cost for this annual support is $196,895.79. We ask that the BOCC approve the agreement as submitted. Conse-nt CAreig- hilt/i9 1 With O019 -08-0Q C-T©OO� BOARD OF COUNTY COMMISSIONERS PASS -AROUND REVIEW PASS -AROUND TITLE: Harris Systems USA, Inc. Annual Software Support DEPARTMENT: Information Technology DATE: 11/14/19 PERSON REQUESTING: Ryan Rose Brief description of the problem/issue: Harris Systems USA, Inc provides software to the Assessor's Office for our Realware application. The software is used by the Assessor's Office for their daily functions. The current contract goes through 2019. This amendment is to extend it through December 31, 2020. What options exist for the Board? (include consequences, impacts, costs, etc. of options): This provider specializes in selling and supporting this software. Options for the Board are to either approve this purchase or hold off on approving it. Recommendation: This agreement was reviewed by legal and budgeted in the 2020 budget cycle. The cost for this annual support is $196,895.79. We recommend the Board approve the request. Sean P. Conway Mike Freeman, Pro-Tem Scott K. James Barbara Kirkrneyer, Chair Steve Moreno Approve Schedule Recommendation Work Session Other/Comments: HARRIS GOVERN Harris Govern 76o North Watters Road, Suite 100 Allen, TX 75oi3 Phone: 972.881.1858 Fax: 226,722.0019 CONTRACT AGREEMENT EXTENSION/RENEWAL BETWEEN THE WELD COUNTY DEPARTMENT OF INFORMATION TECHNOLOGY AND HARRIS SYSTEMS USA, Inc, This Agreement Extension/Renewal ("Renewal"), made and entered into ( (+hof D )0 I'1 , by and between the Board of Weld County Commissioners, on behalf of the Weld County Department of Information Technology, hereinafter referred to as the "Department", and Harris Systems USA, Inc, hereinafter referred to as the "Contractor". WHEREAS the patties entered into an agreement (the "Original Agreement") identified by the Weld County Clerk to the Board of County Commissioners as document No.2014-0802, approved on 4/2/2014, WHEREAS the parties hereby agree to extend the term of the Original Agreement in accordance with the terms of the Original Agreement, which Is Incorporated by reference herein, as well as the terms provided herein. NOW THEREFORE, in consideration of the premises, the parties hereto covenant and agree as follows: • The parties agree to extend the Original Agreement for an additional 1 year period which will begin January 1. 202Q and will end of December 31. 202Q. • The Renewal, including invoices for the 2020 maintenance, constitutes the entire understanding between the parties. The following change is hereby made to the Contract Documents: • All other terms and conditions of the Original Agreement remain unchanged. IN WITNESS WHEREOF, the parties hereto have duly executed the Agreement as of the day, month, and year first above written. CONTRACTOR: A \ke L { Or Printed Name ATTEST: Weld Con) ty Clerk to the Boar ddritiv ..do%.k. BY: Deputy Clerk BOARD OF COUNTY COMMISSIONERS WELD COUNTY, COLORAD Barbara Kirkmey•r, Chair DEC 1 1 2019 o2o/<71- O lib 9— tJ Uri ' P 1 C C1 (rd HARRIS Remit To: Harris Systems USA Inc. PO BOX 74008484 Chicago, IL 60674-8484 Received: Okay To Pay: Date: Project #: Ticket #: tianrlet _ "ode: taln1rsc• Bill To Weld County Assessor 1401 N. 17th Ave. Greeley, CO 60631 USA Invoice MN14043073 Date 11/14/2019 Page 1 of 1 Ship To Weld County Assessor 1401 N. 17th Ave. Greeley, CO 80631 USA PO Number Customer No. Salesperson ID Shipping Method Payment Tenns WEL20 LOCAL DELIVERY MN JAN Ordered w Item Number Description Unit Price Est Price 1.00 CCI - MAINT RealWare Support and Maintenance: January 2020 to December US$123,312.57 US$123,312.57 2020 1.00 CCI - MAINT Matix Support and Maintenance: January 2020 to December 2020 US$27,027.84 US$27,027.84 Subtotal US$150,340.41 Misc US$0.00 Tax US$0.00 Freight US$0.00 Invoice Questions? Please call Evelyn Campbell at 613-226-5511 ext 2264 OR e-mail Trade Discount US$0.00 ECampbell©harriscomputer.com Total US$150,340,41 HARRIS Remit To: Harris Systems USA Inc. PO BOX 74008484 Chicago, IL 60674-8484 Bill To Received: Okay To Pay: Date: Project #: Ticket #: #3 ticlt. Code. Notes: Weld County Assessor 1401 N. 17th Ave. Greeley, CO 80831 USA Invoice MN14043072 Date 11/14/2019 Page 1 of 1 Ship To Weld County Assessor 1401 N. 17th Ave. Greeley, CO 80631 USA PO Number Customer No. Salesperson ID Shipping Method Payment Terms WEL20 LOCAL DELIVERY MN JAN Ordered Item Number Description Unit Price Ext Price 1,00 CCI - TPM Marshall & Swift Maintenance for the Period: January 2020 to US$34,485.47 US$34,485.47 December 2020 1.00 CCI - TPM Marshall & Swift Admin Maintenance for the Period : January 2020 to Demember 2020 US$12,069.91 US$12,089.91 v Subtotal US$46,555.38 Misc US$0.00 Tax US$0.00 Freight US$0.00 Invoice Questions? Please call Evelyn Campbell at 613-226.5511 ext 2284 OR e-mail Trade Discount US$0.00 Total US$48,555.38 ECampbell(dUharriscomputer.com Contract Form New Contract Reques ❑ New Entity? Entity Name* HARRIS SYSTEMS USA INC Contract Name* HARRIS SYSTEMS USA 2020 RENEWAL Contract Status CTB REVIEW Contract Description* SUPPORT RENEWAL FOR 2020 Contract Description 2 Contract Type* AGREEMENT Amount* $196,895.79 Renewable* YES Automatic Renewal Grant Entity ID* @00034077 Department INFORMATION TECHNOLOGY-GIS Department Email CM- InformationTechnologyGlS@w eldgov.corn Depari.rrient Head Email CM-lnformationTeclinoiogyGIS-- DeptHead@weldgov.com County Attorney GENERAL COUNTY ATTORNEY EMAIL County Attorney Email CM- COUNTYATTORNEY@WELD GOV.COM If this is a renewal enter previous Contract ID If this is part of a MSA enter MSA Contract ID Contract ID 3290 Contract Lead* MTRUSLOW Contract Lead Email nitruslow({k� co.weld.cc.us Requested BOCC Agenda Date' 12/1112019 Parent Contract ID Requires Board Approval YES Department Project # Due Date 12107/2019 Will a work session with BOCC be required?* NO Does Contract require Purchasing Dept. to be included? Note: the Previous Contract Number and Master Services Agreement Number should be left blank if those contracts are not in OnBase Effective Date 01/01/2020 Termination Notice Period Review Date* 11/02/2020 Committed Delivery Date Renewal Date* 01 /01Q021 Expiration Date Contact Lion Contact Name Purchasing Purchasing Approver CONSENT Department Head RYAN ROSE DH Approved Date 12/09/2419 Final `Approval BOCC Approved BOCC Signed Date BOCC Agenda Date 12/11/2419 Originator MTRUSLOW Contact Type Contact Email Finance Approver CONSENT Contact Phone 1 Purchasing Approved Date 12/09/2019 Finance Approved Date 12/09/2019 Tyler Ref # AG 121119 Legal Counsel CONSENT Contact Phone 2 Legal Counsel Approved Date 12/09/2019 /D a99z MEMORANDUM TO: Esther Gesick, Clerk to the Board July 15, 2019 FROM: Ryan Rose, Chief Information Officer SUBJECT: Harris Govern SOW Harris Govern provides software to Weld County The software is used by the Assessor's Office to manage their daily functions. The attached agreement between the Board of County Commissioners and Harris Govern is for the purchase and implementation of Harris Govern's mobile solution for the Assessor's staff. The requested amount is $155,225.00. The cost was budgeted for in the 2019 project budget. We ask that the BOCC approve the agreement as submitted. 1 do i4-- a oz� ZTDoc� �2. BOARD OF COUNTY COMMISSIONERS PASS -AROUND REVIEW PASS -AROUND TITLE: Harris Govern SOW DEPARTMENT: Information Technology PERSON REQUESTING: Ryan Rose DATE: 7/3/19 Brief description of the problem/issue: Harris Govern provides software to Weld County. The software is used by the Assessor's Office to manage their daily functions. This request is to purchase and implement Harris Govern's mobile solution for the Assessor's staff. What options exist for the Board? (include consequences, impacts, costs, etc. of options): This provider specializes in selling and supporting this software. This software integrates in with the existing Assessor software. Recommendation: This agreement was reviewed by Legal and the cost was budgeted for fiscal 2019. We recommend the Board approve the request for $155,225.00. Approve Recommendation Sean P. Conway Mike Freeman, Pro-Tem Scott K. James Barbara Kirkmeyer, Chair Steve Moreno Schedule Work Session Other/Comments: HARRIS GOVERN Statement of Work Harris Govern — Weld County, CO: Harris Govern Mobile Implementation February 20, 2019 v.5.0 1 Project Summary This Statement of Work is an attachment to the Professional Services Agreement signed by Harris Systems USA, Inc., herein referred to as 'Harris Govern', and Weld County, CO, herein referred to as 'County', and all actions directed herein shall be performed in accordance to the Terms and Conditions stated within the Professional Services Agreement. This document contains the overall approach and Statement of Work (SOW) for the planning, implementation, training, go -live, and post go -live project activities for Harris Govern Mobile. The Harris Govern mobile solution includes the integration and implementation of Data Cloud Solutions (DCS) CAMACloud© tools with the Harris Govern RealWare product. Page 1 of 8 `-� HAQRRNS 2 Statement of Work 2.1 Project Management Harris Govern will provide project coordination services to manage the implementation of the Harris Govern Mobile application in the County. The Harris Govern Project Coordinator (PC) responsibilities are as follows. 1. Manage the activities of Harris Govern staff, as specified in this Statement of Work. 2. Manage the Project Tasks outlined in this Statement of Work. 3. Coordinate activities related to the planning, implementation, training, go -live and post go -live project task for the Harris Govern Mobile deployment. 4. Establish a communication plan with the County PM. 5. Coordinate activities with Data Cloud Solutions (DCS). Harris Govern is subcontracting Data Cloud Solutions' services and the Harris Govern PC is responsible for all communications and the coordination of activities with Data Cloud Solutions. 6. Ensure that Harris Govern communicates to the desired County attendees for invitation in advance of a task or event; and that Harris Govern is present for all applicable meetings. 7. Review and provide feedback on all draft and updated documents; in general, Harris Govern should attempt to provide feedback within five (5) Business Days of receiving the documents. 8. Provide electronic copies of agendas and presentation for any meeting that Harris Govern is leading (onsite or remotely). 9. Create, review, and update all documents within the timeframe specified in the review process for all draft documents. 10. Ensure appropriate Harris Govern team members attend all project meetings as required. County Responsibilities The list below describes County's responsibilities during the implementation of this project; 1, Provide Servers and a Real Ware test environment for all necessary software and data installations that have the requisite software, operating system, and other support components installed per the System Requirements specified in Exhibit B. 2. Ensure hardware, per HARRIS requirements, and are installed properly and made available to Harris for configuration prior to the installation of any HARRIS software Deliverable per the system requirements specified in Exhibit B. 3. Provide Remote access to the approved HARRIS Team members, consistent with County policy and where County agrees in advance to provide such connectivity. Harris Govern will adhere to security protocols required by the County. 4. Provide logistics for software installation on servers. 5. Provide adequate departmental resources to support the project task and timeline while taking into consideration daily and periodic departmental work requirements. Page 2 of 8 HARRIS GOVERN 6. Provide adequate facilities and equipment for Training. 7. The County shall have responsibility for overall Project management of County resources and will provide direction to all County resources involved in the project. 8. All direct communication between the County and Harris Govern personnel will be copied to the Harris Govern PC and the County's PM and staff, as agreed upon. 9. The County will ensure Harris Govern Mobile users are scheduled to use the application immediately following training. Based on Harris's experience, failure to do often results in a poor product adoption rate and the need for additional training which would require additional funding by the County. 3 Project Deliverables Summary The purpose of this project is to implement the Harris Govern Mobile solution in the County. The following deliverables are required to complete this implementation. 1. jiarris Govern Mobile Software & Services Harris Govern will deliver the software and services as specified in item 5_1 —Software. 2. Training Agenda and Schedule Harris Govern will review a training agenda and schedule with the County at least 3 weeks prior to the planned training event. 4 Software, Infrastructure & Security 4.1 Software Harris Govern will provide the Software listed below Software Suite, Version & Module for RealWare Describe Purpose, Functionality & Expected Operation of Software RealWare The current release of RealWare that supports the current version of Harris Govern Mobile will be installed at the County. Harris Govern Mobile Schema A new database schema for the RealWare (aka. Encompass) database which contains summarized RealWare production data. Harris Mobile Sync Service A new windows service that synchronizes data between the RealWare production schema and the Harris Govern Mobile Schema, Harris Govern Mobile A native iO5 application for collecting and managing CAMA data in the field. Page 3 of 8 IJ HARRIS IP GOVERN Third Party Software provided by Harris Govern Version/Model/Description Harris Govern Admin Module Access to a web -based application allowing Appraisal Managers to manage data collected in the field through the Harris Govern Mobile application. DCS Mobile Sync Service A windows service installed on the County's RealWare application server which synchronizes data between the Harris Govern Mobile Schema and the Amazon Web Services database. 4.2 infrastructure On -Premise: Harris Govern will install/upgrade all On -Premise software and services on the existing County infrastructure unless otherwise directed by the County. County will ensure the infrastructure hosting the DCS Mobile Sync Service meets the requirements defined in Exhibit B. Amazon Web Services (AWS) Database: Harris Govern will configure and verify a new AWS Database environment for the County's mobile environment. 4.3 Security/Access Harris Govern will cooperate with the County and provide information that the County may request in order to determine appropriate security and network access restrictions and verify Harris Govern's compliance with the Client security standards. 5 Project Implementation Activities This section defines the Harris Govern professional service activities and expected durations required to implement RealWare for the Client. Note that some of these activities will take place concurrently. 5.1 Project Initiation, Planning: Upon contract execution, Harris Govern will schedule a project kickoff with the County. During the project kickoff Harris Govern will present the training agenda, training schedule and confirm the County's implementation and training dates. 5.2 Server Installation/Configuration: This consists of Harris Govern technical personnel configuring the server and all other required computer hardware and devices, including, but not limited to the following (a) configuring Windows Server (b) configuring Internet Information Server (IIS) services (c) configuring MS SQL Server (d) adding application users. • Remote connectivity and network accessibility will be administered by the county's technical staff. • Harris Govern will complete and verify the configuration of the AWS database. 5.3 Product Configuration: This consists of product configuration management. 5.4 RealWare client and Harris Govern Mobile Configuration: This consists of Harris Govern technical personnel configuring and testing the mobile application's configuration and services. Page 4of8 t*. HARRIS on G • Technical staff will at this time also upgrade the RealWare database, RealWare middle -tier, install Data Synchronization services, and configure the County's data on the server including PC configuration as necessary to support the Harris Govern Mobile system • Harris Govern will complete the final Go -Live configuration 1 week before go -live. 5.5 Product Training — Go -Live: • Product Training consists of a Harris Govern product specialists conducting onsite training on field device configuration, management and usage. • Training will occur during the Go -Live week. • Training will be delivered in both a classroom environment and out in the field. 5.6 Post Go -Live Support: • Product issues will be documented and prioritized in the Harris Govern Support system. • Product meetings to review and manage issues will continue for up to 30 calendar days after go -live. • All support items will be managed by Harris Govern under the existing MSLA Agreement with the County. The County is not responsible for reporting issues to Harris Govern Third Party partners as a result of this implementation. 6 Project Schedule The implementation of Harris Govern mobile includes the following project tasks and durations. Harris Govern may require 60 to 90 days to kickoff the project following the contract execution. Task Duration Owners Contract Signature 0 days Harris, County Project Kickoff 2 hrs Harris, County Installation and Configuration 5 days Harris Training & Go -Live 3 days Harris, County Page 5 of 8 l,. HARRIS 7 Agreement IN WITNESS WHEREOF, the parties have executed this Statement of Work as of the Effective Date. HARRIS GOVERN Address: 760 N Watters Road Suite 100 Allerlr-IX 75013 By: Name: Robert Wood Title: Vice President, Sales Page 6 of 8 WELD COUNTY, CO Address: By: Name: lMt/ Barbara Kirkm yer Title: BOCC Chair JUL 242019 020/4_ oroot. `�t HARRIS on Exhibit A: Licensed Software, Professional Services and Payment Schedule 1. License Software, Professional Services Costs ONE TIME FEES: Qty Unit Cost Total Harris Govern Mobile Mobile License —Server 1 $ 36,000.00 $ 36,000.00 Harris Govern Mobile Mobile Client Licenses 20 $ 2,900.00 $ 58,000.00 Advanced Mapping User License 20 $ 475.00 $ 9,500.00 Professional Services — Server Setup & Device Setup & Device Training 1 $ 9,450.00 $ 9,450.00 Professional Services — Travel 1 $ 1,000.00 $ 1,000.00 Professional Services — Cloud Provisioning and Setup 1 $ 2,500.00 $ 2,500.00 Professional Services - Advanced Mapping Setup 1 $ 2,500.00 $ 2,500.00 TOTAL ONE TIME FEES: $ 118,950.00 ANNUAL FEES Qty Unit Cost Total Harris Govern Mobile Mobile Server Field Device Maintenance Fee - effective once Mobile training is completed. 1 $ 9,000.00 $ 9,000.00 Harris Govern Mobile Mobile Client Field Device Maintenance Fee - effective once Mobile traininj is completed. 20 $ 725.00 $ 14,500.00 Cloud hosting Fee ($.08 per Property Parcel count) - effective once Cloud Provisioning is completed 130,000 $ 0.08 $ 10,400.00 Advanced Mapping Maintenance 20 118.75 2,375.00 20 $ 118.75 $ 2,375.00 TOTAL ANNUAL FEES: Notes: All Server configurations will be performed remotely Training methods - All training is performed onsite at the client office Additional Training can be purchased at the current PS hourly rate if needed Any customization would be billable on a time and material basis Wireless internet suggested in customer office for this service and is not provided as part of this estimate. * Estimated Real Property Parcel Count is 130,000 $ 36,275.00 2. Payment Schedule Licensed Software and Professional Services. HARRIS GOVERN shall deliver the following Licensed Software and professional services to Licensee. Harris Govern will invoice Licensee in accordance with the following schedule based upon the occurrence of the events as specified below. Payment Event Amount Payment #1 Completion of Harris Govern Mobile installation and Training Payment in Full for all Licenses and Services Page 7 of 8 r`_LHARRIS Exhibit B: Harris Govern Mobile System Requirements Harris Govern Mobile requires the following system requirements 1. Field Device Requirements: • Apple iPad Pro 12.9" LTE • Apple iPad Pro 11.0" LTE • Storage Recommendation: Minimum storage option is acceptable. • Active Cellular plan/service is required 2. Data Synchronization Services Requirements: The following Items are required to host the Data Synchronization services for both Harris Govern Mobile and CAMACIoud. 3. Server Recommended Specifications: • Server OS: Windows 2012 • RAM: 16GB • CPU: 4 Core 4. Server Location and Installation Requirements: • ODBC access to the database using a connection string • This can be setup on a different machine than the database server as long as it has ODBC access 5. Service Account Requirements: The data synchronization services requires a service account with the following permissions. • Full Admin access to the RealWare file system (picture directory, sketch directory if applicable) • If files are on a remote server then the following will be required 1. Server Name and Domain 2. Account Username 3. Account Password 4. UNC Path Harris Govern will grant database permissions to the service account that will allow it to perform the following actions in the Real Ware database: • CREATE/DROP CAMACIoud TRIGGER privileges • CREATE/DROP CAMACIoud SEQUENCE privileges • CREATE/DROP/INSERT INTO CAMACIoud TABLE privileges • CREATE/DROP CAMACIoud VIEW privileges Page 8 of 8 Contract Form New Contract Request Entity Information Entity Name* HARRIS SYSTEMS USA INC Contract Name* HARRIS MOBILE CONTRACT Contract Status CTB REVIEW Entity ID"' @fJDO34077 ❑ New Entity? Contract ID 2992 Contract Lead* MTRUSLOW Contract Lead Email mtruslow@coweld co us Contract Description* CONTRACT TO PURCHASE AND IMPLEMENT HARRIS MOBILE SOLUTION Contract Description 2 Contract Type* AGREEMENT Amount* $155 225.00 Renewable* YES Automatic Renewal Grant IGA Department INFORMATION TEt HNOLOGY-GIS Department Email C M- I nforrnatio nTec h nology Gl Sg ,h. e' d Gov. cor.. Department Head Email CM-inforrnat onTec hnologyGIS- DeptHead weidgov.coc' County Attorney GENERAL COUNTY ATTORNEY EMAIL County Attorney Email CCUNT'YAT T ORNEY @VELD GCV COI 1 Requested BOCC Agenda Date 07,'22, 2019 Parent Contract ID Requires Board Approval YES Department Project # Due Date 07110/2019 Will a work session with BOCC be required?* NO Does Contract require Purchasing Dept. to be included? If this is a renewal enter previous Contract ID tf this is part of a MSA enter MSA Contract ID Note the Previous Contract Number and Master Services Agreement Number should be left blank if those contracts are not in OnE ase Contract Dates Effective Date Review Date* 05/01/2020 Termination Notice Period Committed Delivery Date 05(01 2020 Renewal Date* 07'22.2020 Expiration Date Contact Information Contact Info Contact Name Purchasing Purchasing Approver CONSENT Approval Process Department Head RYAN ROSE DH Approved Date 07/22/2019 Final Approval BOCC Approved BOCC Signed Date BOCC Agenda Date 07`2412019 Originator MTRUSLOV;' Contact Type Contact Email Finance Approver CONSENT Contact Phone 1 Purchasing Approved Date 07/2212019 Finance Approved Date 07/22/2019 Tyler Ref # AG 072419 Legal Counsel CONSENT Contact Phone 2 Legal Counsel Approved Date 07/22'2019 Submit MEMORANDUM TO: Esther Gesick, Clerk to the Board Dec 5, 2018 FROM: Ryan Rose, Chief Information Officer SUBJECT: Harris Systems USA, Inc. Annual Maintenance Agreement Harris Systems USA, Inc. provides software to Weld County. The software is used by the Assessor's Office to manage their daily tasks. The attached agreement between the Board Of County Commissioners and Harris Systems USA, Inc. is for the annual maintenance renewal for their software. The requested amount is $187,429.10 for the maintenance. The cost was budgeted for in the Assessor's Office budget. We ask that the BOCC approve the agreement as submitted. UY‘S50\ii. NARA-OL. I— 9— IR 1 Gc: ,,t -r-) / 9 /9 mow/ -4 6- sToao BOARD OF COUNTY COMMISSIONERS PASS -AROUND REVIEW PASS -AROUND TITLE: Harris Systems USA, Inc. Annual Support Agreement DEPARTMENT: Information Technology DATE: November 28, 2018 PERSON REQUESTING: Ryan Rose Brief description of the problem/issue: Harris Systems USA, Inc. provides software to Weld County for property assessment. The software is used by the Assessor's Office to manage property assessment and to conduct their daily business. This agreement is to extend the support for the Harris products used by Assessor's Office for an additional year. The requested amount for this service is $187,429.10. What options exist for the Board? (include consequences, impacts, costs, etc. of options): This provider specializes in selling and supporting this software which will be utilized by the Assessor's Office to conduct their daily business. Recommendation: The requested amount was budgeted for in the Assessor's Office budget. It is recommended that the BOCC approve the agreement for the above specified amount. Approve Recommendation Sean P. Conway Julie A. Cozad Mike Freeman Barbara Kirlaneyer, Pro -Tern Steve Moreno, Chair Schedule Work Session Other/Comments: CONTRACT AGREEMENT EXTENSION/RENEWAL BETWEEN THE WELD COUNTY DEPARTMENT OF Information Technology AND Harris Systems USA, Inc._ This Agreement Extension/Renewal ("Renewal"), made and entered into 6th day of December, 2018, by and between the Board of Weld County Commissioners, on behalf of the Weld County Department of Information Technoloav, hereinafter referred to as the "Department", and Harris Systems USA. Inc, hereinafter referred to as the "Contractor". WHEREAS the parties entered into an agreement (the "Original Agreement") identified by the Weld County Clerk to the Board of County Commissioners as document No. 2014-0802, approved on 4/2/2014. WHEREAS the parties hereby agree to extend the term of the Original Agreement in accordance with the terms of the Original Agreement, which is incorporated by reference herein, as well as the terms provided herein. NOW THEREFORE, in consideration of the premises, the parties hereto covenant and agree as follows: • The Original Agreement will end on December 31. 2018. • The parties agree to extend the Original Agreement for an additional 1 year period, which will begin January 1. 2019, and will end on December 31. 2019. • The Renewal, the Invoices dated 11/20/18 and 11/21/18, together with the Original Agreement, constitutes the entire understanding between the parties. The following change is hereby made to the Contract Documents: • All other terms and conditions of the Original Agreement remain unchanged. IN WITNESS WHEREOF, the parties hereto have duly executed the Agreement as of the day, month, and year first above written. CONTRACTOR: nt e.1A.. U,Ccion avP tJi P ' Arne Signature ATTEST: Weld Co BY: Deputy Clerk '. the Board BOARD OF COUNTY COMMISSIONERS WE COUNTY, COLOR 141-1—L4_, Barbara Kirkmeyer, Chaf'r JAN S 2019 APPR s VED AS TO SUB E ected i al or Department Head ao(9-og©a HARRIS Remit To: Harris Systems USA Inc. PO BOX 74008484 Chicago, IL 60674-8484 Received: Okay To Pay: Date: Project #: Ticket #: Banner Code: Notes: Bill To Weld County Assessor 1401 N. 17th Ave. Greeley, CO 80631 USA Invoice MN14042702 Date 11/20/2018 Page 1 of 1 Ship To Weld County Assessor 1401 N. 17th Ave, Greeley, CO 80631 USA PO Number Customer No Salesperson ID Shipping Method Payment Terms WEL20 LOCAL DELIVERY MN JAN Ordered Item Number Description Unit Price Ext Price 1.00 NOTE Coverage period 01/01/2019 - 12/31/2019: January 2019 to US$0.00 US$0.00 December 2019 1.00 CCI - MAINT RealWare Support and Maintenance: January 2019 to December US$118,589.78 US$118,589.78 2019 1.00 CCI - MAINT Matz Support and Maintenance: January 2019 to December 2019 US$25,988.31 US$25,988.31 • Subtotal US$144,558.09 Misc US$0.00 Tax US$0.00 Freight US$0.00 Invoice Questions? Please call Evelyn Campbell at 613-226-5511 ext 2264 OR e-mail Trade Discount US$0.00 US$144,558,09 ECampbell©harriscomputer.com Total el HARRIS Remit To: Harris Systems USA Inc. PO BOX 74008484 Chicago, IL 60674-8484 Received: Okay To Pay: Date: Project #: Ticket #: Banner Code: Notes: Bill To Weld County Assessor 1401 N. 17th Ave. Greeley, CO 80631 USA i Invoice Date Page MN14042728 11/21/2018 1 of 1 Ship To Weld County Assessor 1401 N. 17th Ave. Greeley, CO 80831 USA i PO Number Customer No. Salesperson ID Shipping Method Payment Terms WEL20 LOCAL DELIVERY MN JAN Ordered Item Number Description Unit Price Ed Price 1.00 1.00 CCI - TPM CCI - TPM Marshall & Swift Maintenance for the Period January 1, 2019 - December 31, 2019: Marshall & SwiftAdmin Maintenance for the Period January 1, 2019 - December 31, 2019: US$31,756.30 US$11,114.71 US$31,756.30 US$11,114.71 • Invoice Questions? Please call Evelyn Campbell at 613-226-5511 ext 2264 OR e-mail ECampbell@harriscomputer.com Subtotal Misc Tax Freight Trade Discount Total US$42,871.01 US$0 00 US$0.00 US$0.00 US$0.00 US$42,871.01 Crmira.<t tD�" �s83 MEMORANDUM TO: Esther Gesick, Clerk to the Board Dec 18, 2017 FROM: Ryan Rose, Chief Information Officer SUBJECT: Harris Systems USA, Inc. Annual Maintenance Harris Systems USA, Inc. provides software to our Assessor's Office which they utilize to manage property assessment and to conduct their daily business. This agreement is to extend the support for the Realware application and the Marshall and Swift products used by the Assessor's Office for an additional year. The requested amount is $177,871.18 and was budgeted for in the Assessor Office's budget. We ask that the BOCC approve the agreement as submitted. 1 /02, -/F -/2/Y/7 /a,4-17 BOARD OF COUNTY COMMISSIONERS PASSaROUND REVIEW/ WORK SESSION REQUEST RE: Harris Systems USA, Inc. Annual Support Agreement DATE; December 5, 2017 DEPARTMENT: Information Technology PERSON REQUEST1hIG. Ryan Rose ciCafte. Brief description of the problem/issue: Harris Systems USA, Inc. provides software to Weld County for property assessment. The software is used by the Assessor's Office to manage property assessment and to conduct their daily business. This agreement is to extend the support for the Harris products used by Assessor's Office for an additional year. The requested amount for this service is $177,871.18. What options exist for the Board? (Include consequences, impacts, costs, etc. of options) This provider specializes in selling and supporting this software which will be utilized by the Assessor's Office to conduct their daily business. Recommendation: The requested amount was budgeted for in the Assessor's Office budget. It is recommended that the BOCC approve the agreement for the above specified amount. Approve pam . ndation Julie Cozad, Chair Sean P. Conway Mike Freeman Steve Moreno Barbara Kirkmeyer Schedule Work Session n.dt..._ a Other/Comments: VV.• I.\AV. /14.1\L L.•ILI• I S.n. L.11JIVI\11\LI\L VW MI- IJL IVYLL111 THE WELD COUNTY DEPARTMENT OF Information Technology AND Harris Systems USA, Inc._ This Agreement Extension/Renewal ("Renewal"), made and entered into 6th day of December, 2017, by and between the Board of Weld County Commissioners, on behalf of the Weld County Department of Information Technology, hereinafter referred to as the "Department", and Harris Systems USA. Inc, hereinafter referred to as the "Contractor". WHEREAS the parties entered into an agreement (the "Original Agreement") identified by the Weld County Clerk to the Board of County Commissioners as document No. 20140802, approved on 4/2/2014. WHEREAS the parties hereby agree to extend the term of the Original Agreement in accordance with the terms of the Original Agreement, which is incorporated by reference herein, as well as the terms provided herein. NOW THEREFORE, In consideration of the premises, the parties hereto covenant and agree as follows: • The Original Agreement will end on December 31. 2017. • The parties agree to extend the Original Agreement for an additional 1 year period, which will begin January 1. 2018, and will end on December 31, 2018. • The Renewal, the Invoices dated 11/24/17, together with the Original Agreement, constitutes the entire understanding between the parties. The following change is hereby made to the Contract Documents: • All other terms and conditions of the Original Agreement remain unchanged. IN WITNESS WHEREOF, the parties hereto have duly executed the Agreement as of the day, month, and year first above written. CONTRACTOR: Printed Name Angela Keeton, VP of Client Services Signature ATTEST: Weld C . ' n lerk to the Board BY: Deputy Clerk the Board BOARD OF COUNTY COMMISSIONERS ELD COUNTY, COLOR 0 Zee' 182017 clal or Department Head cz /47L-, 0 ea2-- HARRIS Remit To; Harris Systems USA Inc. 62133 Collections Center Drive Chicago, IL 60693-0621 Received: Okay To Pay: Date: Project #: Ticket #: Banner Code. Notes: Bill To Weld County Assessor 1401 N. 17th Ave. Greeley, CO 80631 USA MN 140422/1 11/24/2017 If 1 Invoice Date Page Weld County Assessor 1401 N. 17th Ave. Greeley, CO 80631 USA PQ Number Customer No_ Salesperson ID Shipping Method Payment Terms WEL20 --.- LOCAL DELIVERY MN JAN Ordered Item Number Description 1.00 CCI - TPM 1.00 CCI - TPM Marshall & Swift Maintenance for the Period January 1, 2018 - December 31, 2018 Marshall & Swift Admin Maintenance for the Period January 1, 2018 - December 31, 2018 Invoice Questions? Please call Maryna Vyatkina at 1-888-847-7747 ext 2384 OR e-mail mvyatkina a@harrisccmputer.com Unit Price US$29,405.00 US$10,291.75 Subtotal Misc Tax Freight Trade Discount Total Ext Price US$29,405.00 US$10,291.75 US$39,696.75 US$0.00 us$0.00 US$0.00 US$0.00 US$39, 696.75 Invoice Date Page MN /4042190 11/24/2017 1 of 1 Ship To ;Mot HARRIS Remit To: Harris Systems USA Inc 62133 Collections Center Drive Chicago, IL 60693-0621 Received 41 "la Pay: M pipet Banner Code: Bill To 'WV Weld County Assessor 1401 N. 17th Ave. Greeley, CO 80631 USA PO Number Ordered Item Number Larturattottiatriaritsaioactscoak 1.00 NOTE 1.00 CCI - MAINT 1.00 CCI - MAINT 4 otos Salesperson ID W EL20 Description Coverage period 01/01/2018 -12/31/2018 RealWare Support and Maintenance Matix Support and Maintenance Invoice Questions? Please call Maryna Vyatkina at 1-888-847-7747 ext 2384 OR e-mail mvyatkina@harriscomputer.com Weld County Assessor 1401 N. 17th Ave. Greeley, CO 80631 USA Shipping Method LOCAL DELIVERY woloompowssurrowavonsasses Payment Terms MN JAN Unit Price US$0.00 US$113,333.76 US$24,840.67 Subtotal Misc Tax Freight Trade Discount Total Ext Price US$0.00 US$113,333.76 US$24,840.67 US$138,174.43 US$0.00 US$0.00 US$0.00 US$0.00 US$138,174.43 BOARD OF COUNTY COMMISSIONERS PASS -AROUND REVIEW/ WORK SESSION REQUEST RE: Oracle to MS SQL Server Database Migration DATE: June 27, 2017 DEPARTMENT: Information Technology PERSON REQUESTING: Ryan Rose Brief description of the problem/issue: Harris Govern provides Harris Assessor software to Weld County. The software is used by the Weld County Assessor's Office to manage their daily tasks. The application currently utilizes an Oracle database platform. Migrating it to Microsoft SQL Server database will be more cost effective. The attached agreement between the Board of Weld County Commissioners and Harris Govern provides funding for the migration of the database from an Oracle platform to a Microsoft database platform. The associated cost is $13,300.00. What options exist for the Board? (Include consequences, impacts, costs, etc. of options) This application runs on both Oracle and Microsoft database platforms. Our strategic direction is to move all our applications that utilize Oracle databases to our enterprise Microsoft SQL Server database environment. Recommendation: The agreement has been reviewed and approved by the Assessor's Office. It is recommended that the BOCC approve the agreement for the above specified amount. Julie Cozad, Chair Sean P. Conway Mike Freeman Steve Moreno Barbara Kirkmeyer Approve Recommendation dem Schedule Work Session Other/Comments: 1-- /O --/7 OKat TTO�� CONTRACT AGREEMENT EXTENSION/RENEWAL BETWEEN THE WELD COUNTY DEPARTMENT OF Information Technology AND Harris Govern This Agreement Amendment made and entered into 1st day of July, 2017, by and between the Board of Weld County Commissioners, on behalf of the Weld County Department of Information Technology, hereinafter referred to as the "Department", and Harris Govern, hereinafter referred to as the "Contractor". WHEREAS the parties entered into an agreement (the "Original Agreement") identified by the Weld County Clerk to the Board of County Commissioners as document No. 2014-0802, approved on 04/01/2014. NOW THEREFORE, in consideration of the premises, the parties hereto covenant and agree as follows: • The Database Migration Statement of Work, which is incorporated herein, together with the Original Agreement, constitutes the entire understanding between the parties. • All other terms and conditions of the Original Agreement remain unchanged. IN WITNESS WHEREOF, the parties hereto have duly executed the Agreement as of the day, month, and year first above written. CONTRACTOR: Robert Wood Printed Name Signature ATTEST: diatrAvv usde4;4 Weld .untyerk to the Boar BY: Deputy Cler ) o the Board BOARD OF COUNTY COMMISSIONERS WELD COUNTY, COLORADO di;I2? Julie Cozad, Chair APPROVED AS TO SUBSTANCE: 2 0 da) 619aSba Elected Officialvbr Department H 020 4-- 0 :Oat, Weld County, CO Database Migration Oracle to MS SQL Server Statement of Work Abstract Implementation steps necessary for a successful database migration of the RealWare Product from an Oracle database platform to Microsoft SQL Server. Harris Govern 6/26/2017 Harris Govern SOW — Oracle to MS SQL Server OHARRIS 1. Table of Contents Harris Govern Responsibilities 2 Customer Responsibilities 2 II. Overview 3 ill. Project Contacts 3 IV. Test Migration - Implementation Tasks 4 A. Pre -Test implementation Tasks — Owner: Jurisdiction 4 B. Test Migration Tasks — Owner: Harris Govern .. 4 C. Test Deployment Tasks — Owner: Jurisdiction 4 D. Test Deployment Tasks — Owner: Harris Govern 4 E. Test Environment Verification Tasks — Owner: Jurisdiction 5 V. Production Migration - Implementation Tasks 5 A. Pre -Production Implementation I asks — Owner: Jurisdiction 5 B. Production Migration Tasks — Owner: Harris Govern 5 C. Production Deployment Tasks — Owner: Jurisdiction 5 D. Production Deployment Inks —Owner: Harris Govern 6 E. Production Environment Verification Tasks — Owner: Jurisdiction 6 VI. Implementation Schedule 6 VII. System Requirements 7 VIII. Disaster recovery 7 A. Database revert of the production environment 7 IX. Payment Milestones 8 X. Optional and Custom Services (not Included) 8 XI. Agreement 9 Page 1 of 9 Harris Govern SOW — Oracle to MS SQL Server Introduction to Statement of Work (SOW) HARRIS This document contains the overall approach and Statement of Work (SOW) far the planning and data migration project activities. Harris Govern Responsibilities The list below describes Harris's responsibilities that may not be listed elsewhere in this Statement of Work, during the implementation of this Project. 1. The HARRIS PM will manage the activities of HARRIS staff, as specified in this Statement of Work. 2. HARRIS will have responsibility for Harris's Project Tasks outlined in this Statement of Work. Contractual and administrative communications will flow through the County's PM and the HARRIS PM. The HARRIS PM will coordinate the Harris's software configuration, custom software and integration development, testing and integration tasks, and will manage Harris's day-to-day technical activities related to implementation of the System. 3. All direct communication between HARRIS and the County personnel will be copied to the HARRIS PM and the County's PM and staff, as agreed upon. 4. Ensure HARRIS communicates the desired County attendees for Invitation in advance, and that HARRIS is present, for all applicable meetings. 5. Create, review, and update all documents within the timeframe specified in the review process for all draft documents. Customer Responsibilities The list below describes the responsibilities that may not be listed elsewhere in this Statement of Work, during the implementation of this Project. 1. The Assessor Project Manager will function as the COUNTY PROJECT MANAGER. Assessor Project Manager shall provide all resources necessary for overall project management and shall work with Harris to Insure that all aspects of the migration project are being completed per schedule. 2. The Assessor Project Manager shall make arrangements to satisfy Harris's requested logistics of all meetings (conference room, projector, access to System, etc.). 3. The Assessor Project Manager shall provide servers for all software and data installations that have the requisite software, operating system, and other support components installed. 4. The County IT administrator shall ensure LAN/WAN access, Internet access, network hardware, and all network parameters are configured correctly. 5. The Assessor Project Manager shall ensure Database Management Software (DBMS) matches service release per Harris's requirement and is installed properly and configured prior to installation of any HARRIS software deliverables. 6. The Assessor Project Manager shall provide remote access to the approved HARRIS Team members, consistent with County policy and where County agrees in advance to provide such connectivity. 7. The Assessor Project Manager shall provide logistics for software installation on servers. 8. The Assessor Project Manager shall review and provide feedback on all draft documents; in general, the County should attempt to provide feedback within five (S) Business Days of receiving the documents. 9. The Assessor Project Manager shall ensure County attendees are invited in advance and are present, or accounted for via a suitable replacement If necessary, for all applicable meetings. Page 2 of 9 Harris Govern SOW — Oracle to MS SQL Server Cik HARRIS 10. The Assessor Project Manager shall provide adequate departmental resources to support the project timeline while taking into consideration daily and periodic departmental work requirements. 11. The Assessor Project Manager shall provide adequate facilities and equipment for Training (if contracted). 12. All direct communication between the County and HARRIS personnel will be copied to the HARRIS PM and the Assessor Project Manager, as agreed upon. II. Overview The purpose of this document is to communicate the Implementation plan for a migration of the Real Ware database data from an Oracle database platform to Microsoft SQL Server by Harris Govern. The dates specified for each can be adjusted to fit the Jurisdiction's needs. III. Project Contacts Harris Govem's Primary Point of Escalation: Bart Gordon — bgordon#harriscomptuer.com — Direct: 970-416-6048 Harris Govern's IT & Support Point of Contact: Stan Owens — sowens@harrlscomputer.com Jurisdiction's Assessor Primary Point of Contact Jon Troyer—Jtmyer@co.weld.co.us — Direct: 970-400-3665 Jurisdiction's IT Primary Point of Contact: Stan Sadusky— ssadusky@co.weld.co.us —Direct: 970-400-2533 Copy Jon Troyer on all emails List of those that should receive Project Status updates: ❑ KoClifton—aciifton@harriscomputer.com ❑ Stan Owens - sowens@harriscomputer.com ❑ MaryTruslow-mtrusloweco.weld.co.us ❑ Stan Sadusky-ssadusky@to.weld.coms ❑ Jeff Pepin - jpepineco.weld.co.us ❑ Brenda Danes - bdones@co.weld.co.us ❑ Jon Troyer-jtroyer@co.weld.co.us Page 3 of 9 Harris Govern SOW — Oracle to MS SQL Server OHARRIS IV. Test Migration - Implementation Tasks The purpose of the Test Migration is to migrate a complete database copy from Oracle to MSSQL for testing purposes. A. Pre -Test Implementation Tasks — Owner: Jurisdiction Activities that need to be completed prior project to kick off. Time frame: Jurisdiction dependent ❑ Use Run FIND ALL_DUPS.sgl to find and correct dupes that will not migrate. ❑ I.E. Case differences and spaces ❑ Necessary hardware is ready for implementation of new MsSql database. ❑ Necessary software installed on designated hardware. ❑ OS version:_ TBD _ MsSql version:_TBD_ ❑ Upload a recent backup of the production database to fm.caloredoatsternveartewn using an FTP client that supports SFTP. B. Test Migration Tasks — Owner: Harris Govern Time frame: 7 days ❑ Prepare database on Harris' site for the migration process. • Migrate database from Oracle to MsSql. ❑ Smoke test MsSql database to ensure proper operation. ❑ Place newly migrated MsSql database on FTP for Jurisdiction to download. ❑ Supply Login and Orphaned Users scripts. C. Test Deployment Tasks — Owner: Jurisdiction Time frame: 1/2 day ❑ Download new database from ftp.coloradocustomware.com using an FTP client that supports SFTP. ❑ Import new database into new MsSql database instance. ❑ Run create logins script. ❑ Run orphaned users script. D. Test Deployment Task? — Owner: Harris Govern Time frame: 1/2 day ❑ Verify access to the test environment. ❑ Deploy new Apps and Services to support the new test environment. ❑ Verify operation using the following tests: ❑ Database login success ❑ App login success ❑ Search for an account ❑ Test Image service ❑ Test ProcessRW service ❑ Test Calculation service ❑ Test Encompass API ❑ Harris informs Jurisdiction once test deployment is ready for user testing. Page 4 of 9 Harris Govern SOW — Oracle to MS SQL Server ti HARRIS E. Test Environment Verification Tasks — Owner: Jurisdiction Time frame: Jurisdiction dependent ❑ Jurisdiction to run the tests they have identified to ensure proper operation. All further deployment tasks are on hold until Harris receives written notification from Jurisdiction that the test tasks the Jurisdiction determined were necessary, have been completed and a schedule can be set for the production implementation. O Jurisdiction will need to verify and test all list builder queries & custom reports and re -write those that have incompatible syntax for MsSql. ❑ Verify Security Roles and Users migrated successfully. ❑ Jurisdiction's Assessor Primary Point of Contact confirms and communicates in writing with Harris' Primary Point of Escalation that the Jurisdiction has signed off on the test verification, V. Production Migration - Implementation Tasks A. Pre -Production Implementation Tasks — Owner: Jurisdiction Activities Ural. need to be completed for a successful Go -Live with MsSql Time frame: Jurisdiction dependent ❑ Determine a week where Production can be down a 4:00pm Tuesday, through Friday evening. 0 Harris starts at 4:00pm on a Tuesday to ensure a successful Go-Uve by the next Monday. ❑ Upload a current backup of the production database that was taken after the blackout period to itsgatighlemffinauxe.using an FTP client that supports SFTP. Cl Harris will need after hours and weekend contacts for IT and a RW App user. U Upload a backup of final Production Oracle database to ftsCOloradoaistOmweresom using an FTP client that supports SFTP. B. Production Migration Tasks — Owner: Harris Govern Time frame: 3 days U Prepare production database on Harris' site for the migration process. ❑ Migrate production database from Oracle to MsSql. ❑ Smoke test MsSql database to ensure proper operation. O Backup new MsSql database and place on FTP. ❑ Notify Jurisdiction that MsSql database is on FTP and ready for them. C. Production Deployment Tasks — Owner: Jurisdiction Time frame: 1/2 day IT Download new database from ftp.coloradocustomware.com using an FTP client that supports SFTP ❑ Import new database into new MsSql database instance. ❑ Run orphaned users script. Page 5 of 9 Harris Govern SOW — Oracle to MS SQL Server D. Production Deployment Tasks — Owner: Harris Govern Time frame: 2 Hours O Verify access to the production environment. O Deploy new Apps and Services to support the production environment. ❑ Verify operation using the following tests: O Database login success O App login success ❑ Search for an account ❑ Test Image service O Test ProcessRW service ❑ Test Calculation service 11 Test Encompass API ❑ Migrate the Oracle Database service for Prod. ❑ Inform Jurisdiction once the production deployment is ready for user testing. HARRIS E. Production Environment Verification Tasks — Owner: Jurisdiction Time frame: Jurisdiction dependent O Jurisdiction to run the tests they have Identified to ensure proper operation. ❑ Import custom reports and test. ❑ Update LB queries that were re -written O Jurisdiction confirms and communicates to Harris Govern that Jurisdiction has signed off on the production implementation and that the black period has ended. VI. Implementation Schedule Task Name Oracle to MSSQL Migration Pre -Test Implementation Tasks Test Migration Tasks Test Deployment Tasks Test Deployment Tasks Test Environment Verification Tasks Correct issues & Verification Pre -Production Implementation Tasks Production Migration Tasks Production Deployment Tasks Production Deployment Tasks Production Environment Verification Tasks Duration Start 57.75 days Mon 7/17/17 5 days Mon 7/17/17 7 days Mon 7/24/17 0.5 days Wed 8/2/17 0.5 days Wed 8/2/17 20 days Thu 8/3/17 14 days Thu 8/31/17 1 day Tue 9/26/17 3 days Wed 9/27/17 0.5 days Mon 10/2/17 0.25 days Mon 10/2/17 S days Mon 10/2/17 Finish Wed 10/4/17 Fri 7/21/17 Tue 8/1/17 Wed 8/2/17 Wed 8/2/17 Wed 8/30/17 Wed 9/20/17 Tue 9/26/17 Fri 9/29/17 Mon 10/2/17 Mon 10/2/17 Mon 10/9/17 Resource Names Weld Harris Govern Weld Harris Govern Weld Harris Govern Weld Harris Govern Weld Harris Govern Weld Page 6 of 9 Harris Govern SOW — Oracle to MS SQL Server O HARRIS VII. System Requirements Recommended configuration If Incorporated into current shared environment: Database Sarver Rots Recommended Configurations Description RDBMS - MsSgI • MsSql version 2014 Database Storage • Latest Windows Server version supported by MsSql 2014 • Maximum CPU allocation • 64GB of allocated memory • 150GB — Root Drive • 300GB— DB Log Drive • 1.211 — DB Data Drive VIII. Disaster recovery A. Database revert of the production environment 1. All work done on MsSql will be lost. 2. All references to the MsSql App and services will be removed. 3. The Oracle Apps, Services and database will be re -enabled. 4. Work will resume in Oracle from the start of the blackout period. Page 7 of 9 Harris Govern SOW -- Oracle to MS SQL Server IX. Payment Milestones Ci HARRIS Payment Milestones Amount Payment Milestone 1- Invoked on SOW approveland signature by County (20% Total) $2,660.00 Payment Milestone 2 - Invoiced when Test sample delivered (see detail below) $6,720.00 Oracle to MS SQL Server Migration Sample (Testi PM kickoff and quote $175 DBA migration tasks (Test) $7,000 IT test deployment (Test) $700 PM management (Test) $525 Milestone 2 — Sub Total $8,400 Less 20% (Pre- Paid ) (-$1,680) Milestone 2 — Total $6,720 Payment Milestone 3 — Invoiced on delivery of production migration DB $3,920.00 Oracle to MS SQl. Server Migration Final Final DBA migration tasks $4,200 Final IT test deployment $700 Milestone 3 — Sub Total $4,900 Less 20% (Pre- Paid ) (-$980) Milestone 3 —Total $3,920 X. Optional and Custom Services (not included) Category Service Cost Estimate Notes Migration (additional test) DBA tasks migration g $4,200 Subject to possible discounts Migration (additional test) IT deployment tasks $700 Subject to possible discounts Page 8 of 9 Harris Govern SOW — Oracle to MS SQL Server XI. Agreement WITNESS WHEREOF, the parties have executed this Purchase Order as of the Effective Date. HARRIS GOVERN Address: 760 N Watters Road Suite 100 Allen, TX 75013 By: Name: Robert Wood Title: Vice President, Sales ()HARRIS WELD COUNTY, CO Address: Board of Weld County Commissioners Weld County Administration Building 1150 0 Street Greeley, CO 80631 By: Name: Julie A. Cozad Title: Chair Page 9 of 9 aaloes RESOLUTION RE: APPROVE MASTER LICENSE AND SERVICE AGREEMENT AND AUTHORIZE CHAIR TO SIGN - HARRIS SYSTEMS USA, INC. WHEREAS, the Board of County Commissioners of Weld County, Colorado, pursuant to Colorado statute and the Weld County Home Rule Charter, is vested with the authority of administering the affairs of Weld County, Colorado, and WHEREAS, the Board has been presented with a Master License and Service Agreement between the County of Weld, State of Colorado, by and through the Board of County Commissioners of Weld County, on behalf of the Department of Information Technology, and Harris Systems, Inc., commencing January 1, 2014, with terms and conditions being as stated in said master service agreement, and WHEREAS, after review, the Board deems it advisable to approve said agreement, a copy of which is attached hereto and incorporated herein by reference. NOW, THEREFORE, BE IT RESOLVED by the Board of County Commissioners of Weld County, Colorado, that the Master License and Service Agreement between the County of Weld, State of Colorado, by and through the Board of County Commissioners of Weld County, on behalf of the Department of Information Technology, and Harris Systems USA, Inc., be, and hereby is, approved. BE IT FURTHER RESOLVED by the Board that the Chair be, and hereby is, authorized to sign said agreement. The above and foregoing Resolution was, on motion duly made and seconded, adopted by the following vote on the 17th day of March, A.D., 2014, nunc pro tunc January 1, 2014. BOARD OF COUNTY COMMISSIONERS WELD COUNTY, COLORADO ATTEST: thaw :K• Weld County Clerk to the Boa BY AP Date of signature: CC: re (g- 4 IVEL Doug a$ R demaher, Chair Z4 luti� /!L z arbara Kirkmeyed, Pro-Tem / William F. Garcia 2014-0802 DP0017 MEMORANDUM TO: Esther Gesick, Clerk to the Board March 13, 2014 FROM: Ryan Rose, Chief Information Officer SUBJECT: Harris Systems Inc. Master Service Agreement and Annual Maintenance The Harris Systems Inc. Master Service Agreement has been reviewed by Weld County legal and the associated annual maintenance listed on Purchase Order 1 for $139,601 is budgeted for fiscal year 2014. Harris Systems Inc. provides the RealWare® application and support for the Weld County Assessors Office. With the above information, I recommend the board approve the annual maintenance renewal for the Harris Systems Inc. 2014-0802 HARRIS SYSTEMS USA, INC. MASTER LICENSE AND SERVICES AGREEMENT This Master License and Services Agreement (this "Agreement") is made and entered into on January 1, 2014 ("Effective Date") by and between HARRIS SYSTEMS USA, Inc., and BOARD OF COUNTY COMMISSIONERS OF THE COUNTY OF WELD, STATE OF COLORADO ("Licensee"). 1. DEFINITIONS. 1.1 "Purchase Order" has the meaning set forth in Section 2. 1.2 "Licensed Software" means the proprietary HARRIS SYSTEMS USA, INC. software (in object code format only) and related documentation that is identified in any mutually agreed upon Purchase Order. 1.3 "Business Unit" means the specific county division or operations unit identified in a Purchase. Order for which Licensee is authorized to use the Licensed Software. 1.4 "Intellectual Property Rights" meansany and all rights, whether or not registered, that may exist from time to time in this or any other jurisdiction under patent law, copyright law, moral rights law, publicity rights law, trade secret law, trademark law, unfair competition law or other similar protections. 1.5 "Support Call" means any request from Licensee for technical assistance with the Licensed Software. Request may be initiated through a phone call or by utilizing the HARRIS SYSTEMS USA, Inc. online support call service request system. 2. PURCHASE ORDERS. 2.1. Licensee may issue to HARRIS SYSTEMS USA, INC, written Purchase Orders identifying the Licensed Software (as defined above) and services Licensee desires to obtain from HARRIS SYSTEMS USA, INC. (the "Purchase Order(s)"). Such Purchase Orders shall be consistent with the terms and conditions of this Agreement. it is the parties' intent that the initial version of each Purchase Order shall be generated by HARRIS SYSTEMS USA, INC.. HARRIS SYSTEMS USA, INC. shall accept any mutually agreeable Purchase Orders or alterations thereto which do not establish new or conflicting terms and conditions from those set forth in this Agreement and the exhibit(s) attached hereto or entered into pursuant to the terms of this Agreement. In the event of a conflict between the terms of this Agreement and a Purchase Order, the applicable terms of this Agreement shall prevail over the conflicting terms of such Purchase Order. HARRIS SYSTEMS USA, INC. may reject a Purchase Order that does not meet the conditions described above by promptly providing to Licensee a written explanation of the reasons for such rejection. In order to be valid, all Purchase Orders submitted by licensee must be substantially in the form of Purchase Order attached hereto and shall be executed by authorized representatives of each party prior to taking effect. Each executed Purchase Order shall be attached hereto and incorporated herein as Purchase Order 1, 2, et seq. 3. LICENSE. 3.1. Grant of License. Subject to the terms of this Agreement and any applicable Purchase Order, HARRIS SYSTEMS USA, INC. hereby grants to Licensee a non-exclusive, non -transferable, non- sublicenseable, restricted license to use the Licensed Software for internal purposes only, for the specific business purposes (herein defined as all property valuation and record -keeping functions) and Business Unit {if applicable), and during the license term specified in a Purchase Order (the "License"). The License permits employees and authorized users of Licensee to use the Licensed Software. 3.2 Prohibited Uses, Licensee may not (i) transfer all or any portion of the Licensed Software - and may not permit use by third parties or utilize software to perform work for other counties, (ii) reinstall or use the Licensed Software or documentation following the expiration or termination of this Agreement unless it enters into an additional license agreement with HARRIS SYSTEMS USA, INC., (iii) attempt to circumvent any technical devices of the License Software that are directed at, or have the effect of, enforcing the terms of this Agreement, (iv) make copies of the Licensed Software other than for backup; training, testing or other internal support reasons, or (v) modify, create derivative works, translate, decompile or create or attempt to create, by reverse engineering or otherwise, the source code from the object code supplied to Licensee. Licensee may not remove, modify or obscure any copyright, trade secret, confidentiality, trademark, service mark or other proprietary rights, notice or legend on any copy of the Licensed Software, the media on which it is contained, or related data, documentation or other HARRIS SYSTEMS USA, INC. COMPANY CONFIDENTIAL Page 1 of 10 materials. Licensee may not market, sell, lend, rent, lease, or otherwise distribute the Licensed Software. Except as otherwise expressly provided herein, Licensee may not assign, sublicense or otherwise transfer any rights in or to the Licensed Software. The Licensed Software shall not be used under any circumstance whatsoever directly or indirectly in a computer service business or service bureau or in a rental or commercial timesharing arrangement. 3.3 Designated Hardware. Licensee agrees to operate the Licensed Software on hardware meeting or exceeding the requirements as specified in a Purchase Order or recommended by HARRIS SYSTEMS USA, INC.. Licensee. acknowledges and agrees that the License is restricted to county operations only, and that the Licensed Software may not be installed on hardware not owned and operated by Licensee. 4. SERVICES. 4.1. Professional Services. HARRIS SYSTEMS USA, INC. shall provide professional services ("Services") as described in Purchase Orders to assist with data conversion, system implementation and configuration, customization, and installation, or in connection with other activities as may be described in Purchase Orders. Subject to the mutual agreement of the parties in a Purchase Order, HARRIS SYSTEMS USA, INC. personnel will perform these Services at the rate and charges set forth on such Purchase Order. Licensee shall reimburse HARRIS SYSTEMS USA, INC. HARRIS SYSTEMS USA, INC. shall make all efforts to eliminate the need for travel. 4.2 Maintenance and Support Services. HARRIS SYSTEMS USA, INC. shall provide maintenance and support services ("Maintenance") as described in Purchase Orders to maintain the Licensed Software in compliance with State Property Tax legislation and to provide technical. support, Licensed Software updates, and other services as described in Purchase Orders. Unless otherwise set forth in an applicable Purchase Order, Support Calls, as defined in section 1.5, for service will be provided during normal business hours which includes the hours of 7:00 a.m. through 6:00 p.m. Mountain Standard Time Monday through. Friday), and will be responded to in a maximum of 2 hours from the time the call was placed. If Licensee discontinues Maintenance services for any reason, and Licensee desires to resume such services in the future, the parties may enter into an agreement under such terms and conditions as each determines to be acceptable. 5. FEES AND EXPENSES. 5.1. In consideration for the' License and the Services and Maintenance to be provided by HARRIS SYSTEMS USA, INC., Licensee shall pay the fees as indicated in the applicable Purchase Order. Licensee will pay these fees within thirty (30) days of the date of the invoice, unless otherwise provided in the Purchase Order. Thereafter, all past due balances shall accrue interest at the rate of 1% per month. 6 PROPRIETARY RIGHTS AND CONFIDENTIALITY. 6.1. Licensee understands and agrees that the Licensed Software, related data, documentation, and all other information and materials provided by HARRIS SYSTEMS USA, INC. to Licensee (the "Proprietary Information") are confidential and that HARRIS SYSTEMS USA, INC. has and will have exclusive Intellectual Property Rights in such Proprietary Information: For purposes of this Agreement, "Proprietary Information" shall include all third -party information provided by HARRIS SYSTEMS USA, INC. to Licensee. Licensee acknowledges and agrees that no title or ownership of: the Licensed Software or any of HARRIS SYSTEMS USA, INC.'S Intellectual Property Rights is transferred to. Licensee by this Agreement and that the Licensed Software and all Intellectual Property Rights are and will remain the exclusive property of HARRIS SYSTEMS USA, INC.. Except as otherwise expressly set forth in any Purchase Order, HARRIS SYSTEMS USA; INC. shall own all right, title, and interest in and to all Deliverables that are written or created by HARRIS SYSTEMS USA, INC, personnel alone or jointly with Licensee or third parties in connection with this Agreement. "Deliverable" shall mean any work product, software, co -development, analysis, or other deliverable(s) produced for or delivered to Licensee under this Agreement in connection with a Purchase Order. 6.2. Licensee agrees not to make any claim or representation of ownership of any of the Licensed Software and all related data, documentation and other materials, including any Deliverables. Subject only to the rights expressly granted to Licensee under this Agreement according to the non-exclusive License herein, all rights, title and interest in and to the Licensed Software including without limitation the Proprietary Rights will remain with and belong exclusively to HARRIS SYSTEMS USA, INC.: This is a software license agreement and not an agreement for the sale of the Licensed Software, 6.3. Subject to the requirements imposed on Licensee, by Colo. Rev. Statutes §§24-72-201, et seq., (Colorado Open Records Act) and all judicial decisions rendered pursuant to said statutes, HARRIS SYSTEMS USA, INC. COMPANY CONFIDENTIAL Page 2of10 Licensee agrees to keep all Licensed Software (including all data, documentation and other materials subject to copyright protection) and other confidential information of HARRIS SYSTEMS. USA, INC. confidential and agrees not to sell, assign, distribute or disclose any Licensed Software or any portion of the Licensed Software to any other person or entity. Licensee agrees to advise its employees, agents and consultants of the confidential and proprietary nature of the Licensed Software (including all related data, documentation and other materials) and of the restrictions imposed by this Agreement, and agrees to confine access to Licensee's employees, agents and consultants solely on a need -to -know basis, subject to all restrictions imposed by this Agreement Demonstrating the capability of the system to, competing vendors, and/or competing agents shall be a disclosure of the Licensed Software that constitutes a material breach of this Agreement. 6.4. HARRIS SYSTEMS USA, INC. agrees to keep confidential all of Licensee's confidential information, and agrees not to sell, assign, distribute or disclose any such confidential information to any other person or entity without seeking written permission from the Licensee. HARRIS SYSTEMS USA, INC. agrees to advise its employees, agents, and consultants of the confidential and proprietary nature of such confidential information and of the restrictions imposed by this Agreement, and agrees to confine access to HARRIS SYSTEMS USA, INC.'a employees, agents and consultants solely on a need -to -know basis, subject to all restrictions imposed by this Agreement. HARRIS SYSTEMS USA, INC. acknowledges that Licensee is subject to the Colorado Open Records Act, Colo. Rev. Statues .5§24-72-201. et seq., and that some records, as defined therein, shall be released in accordance with the statute. 6.5. The provisions of this Section 6 apply to the Licensed Software as originally delivered by HARRIS SYSTEMS USA, INC: and as modified or otherwise enhanced and to any data, documentation, other materials and information regarding the Licensed Software that has been given to Licensee prior to the Effective Date, and apply to Licensee and to all employees, agents; consultants and affiliates of Licensee. 6.6. Licensee agrees to assist HARRIS SYSTEMS USA, INC. in stopping and preventing any possession or use of the Licensed Software (including all related Harris Systems data, documentation and other materials) by any person or entity not authorized by this Agreement to have such possession or use The parties agree that any breach of the provisions of this Section 6 will cause substantial damages, that the amount of such damages is difficult to determine with precision, and that any remedies at law forsuch a breach will entitle the owner of the confidential information or Proprietary information as the case may be, in addition to any other remedies it may have, to temporary and permanent injunctive and other relief, without the necessity of posting bond or proving actual damages. 7. INDEMNITY. 7.1. The Licensee cannot and by this Agreement does not agree to indemnify, hold harmless, exonerate or assume the defense of HARRIS SYSTEMS USA, INC. or any other person or entity whatsoever for any purpose whatsoever. HARRIS SYSTEMS USA, INC. shall defend, indemnify and hold harmless the Licensee, its commissioners, officials, officers, directors, agents, and employees from any and all claims, demands, suits, actions or proceedings of any kind or nature whatsoever, including workers' compensation claims, in any way resulting from or arising from this Agreement; provided, however, that HARRIS SYSTEMS USA, INC. need not indemnify or save harmless the Licensee, its officers, agents and employees from damages resulting from the sole negligence of the Licensee's commissioners, officials, officers, directors, agents, and employees or from those infringement claims specifically listed in section 7.2. The indemnity provided hereunder shall not apply to amounts paid in settlement of any claim if such settlement is made without HARRIS SYSTEMS USA, INC.'S prior written consent. 7.2. HARRIS SYSTEMS USA, INC, will have no obligation to Licensee for any infringement claim that arises from: (i) any modification to the Licensed Software by anyone other than HARRIS SYSTEMS USA, INC. unless approved in writing by HARRIS SYSTEMS USA, INC.; (ii) modifications made by HARRIS SYSTEMS USA, INC. at Licensee's request in compliance with Licensee's design, specifications or instructions to which HARRIS SYSTEMS USA INC: has expressed written objections; (iii) use of the Licensed Software other than as specified in this Agreement or in the applicable documentation; (iv) use of the Licensed Software in conjunction with third -party software, hardware or data other than that with which the Licensed Software is specifically designed to be used, solely as expressly specified in the documentation or this Agreement, or (v) use of a prior version of the Licensed Software, if the infringement claim could have been avoided by the use of the current version of the Licensed Software. 7.3. if an infringement.: claim arises, or in HARRIS SYSTEMS USA, INC.'S reasonable opinion HARRIS SYSTEMS USA INC. COMPANY CONFIDENTIAL Page 3 of 10 is likely to arise, HARRIS SYSTEMS USA, INC. may at its own expense obtain for Licensee the right to continue using the Licensed Software; modify the Licensed Software to make it non- infringing, or substitute other Licensed Software of substantially similar capability and functionality. If none of these options are reasonably available to HARRIS SYSTEMS USA, INC., HARRIS? SYSTEMS USA, INC. may terminate the License for the. infringing Licensed Software and refund to Licensee the License fee paid for the infringing Licensed Software, less a reasonable charge, not to exceed One Thousand Dollars ($1;000.00), for Licensee's use of the Licensed Software prior to such termination. THIS SECTION 7 STATES THE ENTIRE OBLIGATION OF HARRIS SYSTEMS USA, INC. AND THE EXCLUSIVE REMEDIES OF LICENSEE WITH RESPECT TO ANY CLAIMS OF INFRINGEMENT OR INTELECTUAL PROPERTY RIGHTS VIOLATIONS. State, county or other public funds payable under this Agreement shall not be used for the acquisition, operation or maintenance of computer software in violation of federal copyright laws or applicable licensing restrictions. HARRIS SYSTEMS USA, INC. hereby certifies and warrants that, during the term of this Agreement and any extensions thereof, HARRIS SYSTEMS USA, INC. has and shall maintain in place appropriate systems and controls to prevent such improper use of public funds. If Licensee determines that HARRIS SYSTEMS USA, INC. is in violation of this provision, Licensee may exercise any remedy available at law or equity or under this Agreement, including, without limitation, immediate termination of the Agreement and any remedy consistent with Federal copyright laws or applicable licensing restrictions. a. WARRANTY AND LIMITATION OF LIABILITY. HARRIS SYSTEMS USA INC. warrants that as of the Effective Date of this Agreement, (i) it has the authority to grant the License extended under this Agreement to Licensee; (ii) any Services provided under this Agreement and any Purchase Orders wilt be performed in a professional and workmanlike manner; and (iii) the Licensed Software will conform substantially toits documentation for ninety (90) days from delivery. Licensee's sole remedy for a breach of the express warranties in this section shall be repair or replacement of the Licensed Software or reperformance of any applicable Services within a reasonable time. HARRIS SYSTEMS USA, INC. MAKES NO OTHER WARRANTIES OR REPRESENTATIONS WITH RESPECT TO THE LICENSED SOFTWARE OR ANY SERVICES TO BE PROVIDED UNDER THIS AGREEMENT OR ANY APPLICABLE PURCHASE ORDER, WHETHER EXPRESS, IMPLIED, STATUTORY OR OTHERWISE, IN FACT OR IN LAW, INCLUDING WITHOUT LIMITATION ANY IMPLIED WARRANTIES OF MERCHANTABILITY, NON -INFRINGEMENT OR FITNESS FOR A PARTICULAR PURPOSE. HARRIS SYSTEMS USA, INC. DOES NOT WARRANT THAT THE PRODUCT WILL OPERATE WITHOUT INTERRUPTION OR BE ERROR FREE. EXCEPT AS EXPRESSLY PROVIDED IN THIS AGREEMENT OR ANY APPLICABLE PURCHASE ORDER, HARRIS SYSTEMS USA, INC. HAS NO DUTY TO UPDATE, MAINTAIN OR PROVIDE ANY ENHANCEMENTS FOR THE LICENSED SOFTWARE. EXCEPT FOR DAMAGES ARISING FROM THE BREACH OF EITHER PARTY'S INTELLECTUAL PROPERTY OR PROPRIETARY RIGHTS OR THE CONFIDENTIAL OBLIGATIONS SET FORTH HEREIN: NEITHER PARTY SHALL BE I CABLE TO THE OTHER OR ANY THIRD PARTY FOR DAMAGES IN EXCESS OF ANY AMOUNTS ACTUALLY PAID TO HARRIS SYSTEMS USA, INC. HEREUNDER. NEITHER PARTY SHALL BE LIABLE TO THE OTHER PARTY FOR ANY SPECIAL, CONSEQUENTIAL, INDIRECT, PUNITIVE OR EXEMPLARY DAMAGES, LOST PROFITS OR LOST SAVINGS, EVEN IF THE OTHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. It is expressly understood and agreed that the enforcement of the terms and conditions of this Agreement, and all rights of action relating to such enforcement, shall be strictly reserved to the undersigned parties and nothing in this Agreement shall give or allow any claim or right of action whatsoever by any other person not included in this Agreement. It Is the express intention of the undersigned parties that any person other than the undersigned parties receiving services or benefits under this Agreement shall bean incidental beneficiary' only and that neither party can claim against the other party an amount or type of damage claim not permitted under this Article 7 for the benefit of any other third party._ 9. TERM AND TERMINATION. 91_ The term of this Agreement shall begin on the Effective Date and continue in effect until terminated as provided herein. In the event that either party fails at any to comply with any of its obligations under this Agreement and fails to cure such breach within sixty (60) calendar days after the giving of a written notice of breach that describes in reasonable detail the alleged breach, the other party may terminate this Agreement effective on the 615' day after the original written notice of breach unless some interim arrangement has been reached HARRIS SYSTEMS USA, INC. COMPANY CONFIDENTIAL. rage 4 of 10' between the parties during the 60 -day cure period. If Licensee breaches any provision of Section 3 or Section 6, HARRIS SYSTEMS USA, INC. may terminate this Agreement immediately upon written notice to Licensee. Upon termination by HARRIS SYSTEMS USA, INC., Licensee shall immediately destroy all copies of the Licensed Software, and certify to HARRIS SYSTEMS USA, INC. that it has retained no copies of the Licensed Software. Upon termination, regardless of the reason for termination, Licensee shall pay HARRIS SYSTEMS USA, INC. all undisputed Fees or expenses then due or incurred up to the time of termination. The rights and responsibilities of the parties pursuant to paragraphs 3.2, 5 6, the limitation of liability provisions of paragraph 8, and paragraph 10 shall survive the expiration or termination of this Agreement. If HARRIS SYSTEMS USA, INC. breaches any provision of this Agreement and/or decides to discontinue the sale and Maintenance of the Licensed Software, Licensee may continue the use the Licensed Software as -is, and shall take on the responsibility of any future Maintenance, 9.2 NON -APPROPRIATION. HARRIS. SYSTEMS USA, INC. acknowledges that Licensee is a governmental entity and the contract validity is based upon the availability of public funding under the authority of its statutory mandate. In the event that public funds are not appropriated for the performance of Licensee's obligations under this Agreement, then this Agreement shall automatically expire without penalty to Licensee thirty (30) days after written notice to HARRIS SYSTEMS USA, INC. of the non -appropriation of public funds Licensee is not under obligation to make any future apportionment or allocation to this Agreement nor is anything set forth herein this section 9.2 a limitation of liability for HARRIS SYSTEMS USA, INC.. Any potential expenditure for this Agreement outside the current fiscal year is subjectto future annual appropriation of funds for any such proposed expenditure. 9.3 VOID. The parties agree that where section 10.14 applies, the Agreement does not terminate but is deemed to be void ab initio with no clauses of this Agreement surviving. 10. MISCELLANEOUS. 10.1. Neither party will be liable for any failure to comply with or delay in performance of this Agreement where failure or delay is caused by or results from any events beyond its control, including but not limited to, fire, flood, earthquake, accident, civil disturbances, acts of any governmental entity, war, shortages, embargoes, strikes (other than those occurring in the workforce of the party claiming relief, or the workforces of its subcontractors), transportation delays, or acts of God. 10.2. This Agreement will inure to the benefit of and be binding upon the parties and their respective successors and permitted assigns; provided however, that (i) Licensee may not assign or otherwise transfer this Agreement or any of its rights and/or obligations hereunder without the prior written consent of HARRIS SYSTEMS USA, INC., and (ii) HARRIS SYSTEMS USA, INC, may only transfer or assign its rights and obligations under this Agreement to an affiliate, in connection with a merger or acquisition or in connection with a corporate reorganization with the prior consent of Licensee.. 10.3. This Agreement constitutes the full and complete understanding and agreement of HARRIS SYSTEMS USA, INC. and Licensee and supersedes all prior negotiations,understandings and agreements pertaining to the subject matter of this Agreement. This Agreement will be supplemented by one or more Purchase Orders, which will be deemed to be part of this Agreement when signed by each party. 10.4. No delay, omission or failure to exercise any right or remedy under this Agreement will be deemed to be a waiver of such right or remedy or acquiescence to the event giving rise to such right or remedy, but every such right and remedy may be exercised from time to time and so often as may be deemed expedient by the party exercising such right or remedy. 10.5. HARRIS SYSTEMS USA, INC. is an independent contractor and is free to perform services for other clients. Notwithstanding any provision of this Agreement, all personnel assigned by Harris Systems USA, inc. to perform work under this Agreement shall be and remain at all times, employees of Harris Systems USA, Inc. for all purposes. HARRIS SYSTEMS USA, 1NC. IS NOT ENTITLED TO WORKERS' COMPENSATION OR UNEMPLOYMENT BENEFITS THROUGH THE COUNTY AND IS OBLIGATED TO PAY FEDERAL AND STATE INCOME TAX ON ANY MONIES EARNED PURSUANT TO THE CONTRACT RELATIONSHIP. HARRIS SYSTEMS USA, INC. shall have the following responsibilities with regard to workers' compensation and unemployment compensation insurance matters: (a) provide and keep in force worker's, compensation and unemployment compensation insurance in the amounts required by law and (b) provide proof thereof when requested to do so by the Licensee. 10.6: This' Agreement will be governed by and construed in accordance with the laws of the United HARRIS SYSTEMS USA, INC. COMPANY CONFIDENTIAL Page 5 of 10 States and the State of Colorado, without respect to conflict of laws principles. The parties hereby irrevocably consent to the exclusive jurisdiction of the 19th Judicial District of the State of Colorado, and to the Federal District Courts for Colorado (if the State Court lacks jurisdiction), for the commencement or maintenance of any action between the parties arising hereunder. The parties agree that the United Nations Convention on Contracts for the International Sale of Goods (1980) is specifically excluded from application to this Agreement. 10.7. If any provision of this Agreement or compliance by any of the parties with any provision of this Agreement constitutes a violation of any law, or is or becomes unenforceable or void, then such provision, to the extent only that it is in violation of law, unenforceable or void, shall be deemed modified as necessary so that it is no longer in violation of law, unenforceable or void, and such provision will be enforced to the fullest extent permitted by law. If such modification is not possible, such provision, to the extent that it is in violation of law, unenforceable or void, shall be deemed severed from the remaining provisions of this Agreement, which provisions will remain in full force and effect. 10.8. 1n the event that any provision of this Agreement is held to be illegal, invalid or unenforceable, under present or future laws; then (i) such provision will be fully severable and this Agreement will be construed and enforced as if such illegal, invalid or unenforceable provision were not a part hereof, (ii) the remaining provisions of this Agreement will remain in full force and effect and will not be affected by such illegal, invalid or unenforceable provision or by its severance from this Agreement, and (iii) if both parties agree (except in relation to HARRIS SYSTEMS USA, INC.'s Intellectual Property Rights and Article 7, in which case the following shall be automatic), there will be added automatically as a part of this Agreement a provision similar in terms to such illegal, invalid or unenforceable provision as may be possible and still be legal, valid and enforceable. If the parties cannot agree on a replacement provision within thirty (30) days of the date the provision is severed, no provision will be added, and the Agreement will continue under as set forth in (i) and (ii) above. 10.9. The parties may make disclosures regarding this Agreementrequired by legal, accounting, or regulatory agencies. Subject to the confidentiality restrictions set forth in Section 6 above and applicable law, the parties may create and distribute media releases, public announcements, or make public disclosures regarding the existence of the Agreement and such releases, announcements and disclosures may include the name trademark or logo of either of the parties, and be posted on the parties respective web sites. 10.10. This Agreement will become effective only upon execution of this Agreement by an authorized officer of HARRIS SYSTEMS USA, INC.. and Licensee. 10.11. Any notice or communication required or permitted to be given hereunder may be delivered by hand, deposited with an overnight courier, sent by confirmed facsimile, or mailed by registered or certified mail, return receipt requested, postage prepaid, in each case to the address of the receiving party indicated below, or at such other address as may hereafter by furnished in writing by either party hereto to the other. Such notice will be deemed to have been given as of (i) the date it is delivered in the case of delivery by hand or overnight delivery, (ii) on the date of facsimile if sent by confirmed facsimile, and (iii) three (3) days after deposit in the mail in the case of certified mail delivery. Copies of ali notices to HARRIS SYSTEMS USA, INC. shall be sent to: HARRIS SYSTEMS USA, Inc., 2600 Technology Drive, Suite 900, Plano, TX 75074. Copies . of all notices to Licensee shall be sent to: Weld County Assessor, Christopher Woodruff, 1400 North 17 Avenue, Greeley, Colorado, 80631. 10.12. The Uniform Computer Information Transactions Act does. not apply to this Agreement. 10.13. This Agreement may be executed in two or more counterparts, each of which shall be deemed an original, and all of which together shall constitute one and the same instrument. 10.14 This Agreement and the rights associated with it are contingent upon the consummation of an Asset Purchase Agreement dated as of September 6, 2013 that will result in Harris Systems USA Inc. obtaining the rights to permit it to provide the licenses and services as described herein.. In the event that Harris SYSTEMS USA Inc. does not consummate the transactions contemplated by that certain Asset Purchase Agreement, by and among the parties set forth on the signature pages attached thereto, this Agreement will be null and void ab inifio and the Licensee shall have no action, claim or demand against N. Harris Computer Corporation OR HARRIS SYSTEMS USA Inc. or any other person as a consequence of such event and the Licensee would have no corresponding obligations. 10.15 Reimbursable Expenses. Harris shall be reimbursed for actual expenses incurred while performing services at the Greeley offices of the HARRIS SYSTEMS USA, INC. COMPANY CONFIDENTIAL Page 6 or i0 'Weld' County Assessor. Reimbursable expenses include the following: hotel, (based upon average hotel rates: in, Greeley, Colorado or actual Greeley hotel costs, whichever is less), meals, car rental, and airfare. Expenses related to alcoholic beverages will not be reimbursed. 11. NO WAIVER OF GOVERNMENTAL IMMUNITY ACT: The parties hereto understand and agree that the County, its commissioners, officials, officers, directors, agents and employees, are relying on, and do not waive or intend to waive by any provisions of this Agreement, the monetary limitations or any other rights, immunities and. protections provided by the Colorado Governmental, immunity Act, ;'§§ 24-10-101 to. 120. C.R.S,; or otherwise available to the County. 12. CONFLICT OF INTEREST: HARRIS SYSTEMS USA;. INC,.:' agrees that noOfficial, officer or employee. of 'the Licensee shall have any personal or beneficial interest whatsoever in the services or property described herein, and HARRIS, SYSTEMS USA, INC further agrees not to hire, pay;; or contract for services, Qr any official, officer or employee of the Licensee. A conflict of interest shall include transactions, activities or conduct that would affect the judgment, actions or work of HARRIS SYSTEMS USA, INC. by placing HARRIS SYSTEMS USA, INC.'S own interests, or the interest of any party with whom HARRIS SYSTEMS USA, INC. has a contractual arrangement, in conflict with those of Licensee. 13. ATTORNEY'S FEES/LEGAL COSTS .In the event of a dispute between Licensee and HARRIS SYSTEMS USA,, INC.,:concerning this Agreement,, the parties agree that neither party shall be liable to or responsible for .the payment of attorney fees and/or legal costs.: incurred by: or on behalf of the other party. HARRIS SYSTEMS USA. INC.. COMPANY CONr'IDENTIAL Page 7 of 10 IN WITNESS WHEREOF, the parties have executed this Agreement as of the Effective Date. HARRIS SYSTEMS USA, INC. Address: 2600 Technology Drive, Ste 900 Plano, Texas 75074 By: Name: Dean deVilleneuve Title: Executive Vice President BOARD OF COUNTY COMMISSIONERS OF THE COUNTY OF WELD Address: 1400 N. 17th Ave Greeley, CO 80631 nu p C Name: Douglas Title: Chair Rademacher Date: MAR 1 7 2014 HARRIS SYSTEMS USA. INC. COMPANY CONFIDENTIAL Page 8 of 10 Purchase Order 1 Maintenance This Purchase Order 1 ("Purchase Order") to the HARRIS SYSTEMS USA, INC, Master License and Services Agreement. ("Agreement") is effective as of January 1, 2014 ("Effective Date") by HARRIS SYSTEMS USA, Inc., and BOARD OF COUNTY COMMISSIONERS OF THE COUNTY OF WELD, STATE OF COLORADO ("Licensee") pursuant to the terms of the Agreement. Capitalized terms used but undefined in this Purchase Order shall have the meanings assigned to them in the Agreement. 1. HARRIS SYSTEMS USA, INC. will provide the following Maintenance services as of the Effective Date: A. Unlimited phone, internet, and email support during normal business hours for two (2) contacts. B. Licensed Software updates as needed to stay in compliance with relevant legislation, as determined by HARRIS SYSTEMS USA INC. in consultation with Licensee. C. General product enhancements provided to all Maintenance customers. 2. Licensee shall be invoiced annually with payment due on or before January 1 for the following year's Maintenance services. The Maintenance fees for the Initial Term (as defined below) shall be the pro rata amount of HARRIS SYSTEMS USA, INC.'s set Maintenance fee for the then current year. 3. Payment of the Maintenance fees are required to be paid by Licensee as specified in the Agreement. Payment of the Maintenance fee is due within thirty (30) days after the receipt of HARRIS SYSTEMS USA, INC.'s invoice by Licensee. Inn event shall Licensee be liable for payment under this Agreement for any amount in excess of the amounts stated in section 4 for the Initial Term. The Licensee is not under obligation to make any future apportionment or allocation to this Agreement nor is anything set forth in this Purchase Order a limitation of liability for HARRIS SYSTEMS USA, INC, Any potential expenditure for this Agreement outside the current fiscal year is subject to future annual appropriation of funds for any such proposed expenditure. 4. Annual Maintenance fees for the period January 1 2014 through December 31 2014 are set forth below and will be prorated based on the current support terms listed in 4A below. Proration of Maintenance fees will only be granted if Licensee has paid CCi for all current Maintenance fees as of the effective date of this Agreement. Otherwise, the Maintenance fees shall be those "Annual Fees" as listed, below. Product Annual Fee Fee Due January 1 2014 Matix Support S20,633.00 $20,633.00 RealWare Support $94,138.00 $94,138.00 M&S Cost Tables $20,305.00 $20,305.00 M&S Admin Cost $4,525.00 $4,525.00 Total Maintenance $139,601.00 $139,601.00 5, The Maintenance term shall begin immediately as of the Effective Date and continue for period ending at the end of the day on December 31'4 , 2014. ("Initial Term"). Upon expiration of the Initial Term, this Purchase Order shall automatically renew for successive. periods of one (1) year ("Subsequent Terms") on January 151 of the subsequent year and ending at the end of the day on December 3151 of the same year unless either party provides the other party with written notice of its intent not to renew at least ninety (60) days prior to the expiration of the then current term that such term will not be renewed. Where such notice is not provided, the payment for the Maintenance fee related to each Subsequent Term is due by January 151 of the relevant Subsequent Tenn, and Licensee shall be obligated to pay the Maintenance fee for the entire Subsequent Term. 6. In the event a material change in legislation requires a substantial amount of development effort by HARRIS SYSTEMS USA, INC., as determined by HARRIS SYSTEMS USA, INC. with client consultation, HARRIS SYSTEMS USA, INC. reserves the right to impose a one-time Legislative Compliance Fee which shall be a fee that is in addition to the Maintenance fee detailed above and which may invoiced at any time during the Initial Term or any Subsequent Term, but no more than once in any given term. Compliance Fee shall not exceed 20% of the Maintenance Fee detailed above. 7. For any Subsequent Term, maintenance fees may be adjusted with 180 days' notice, unless this Purchase Order specifies the pricing of any Subsequent Term. HARRIS SYSTEMS USA. INC. COMPANY CONFIDENTIAL Page 9 of 10 Harris Govern SOW — Oracle to MS SQL Server et HARRIS X1. Agreement WITNESS WHEREOF, the parties have executed this Purchase Order as of the Effective Date. HARRIS GOVERN Address: 760 N Watters Road Suite 100 Allen, TX 75013 By: Name: Robert Wood Title: Vice President, Sales WELD COUNTY, CO Address: Board of Weld County Commissioners Weld County Administration Building 1150 0 Street Greeley, CO 80631 By: Name: Julie A. Cozad Title: Chair Page 9 of 9 o2O / 7 a Ivo2-� Hello