Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Public Safety Software Recommendation
Copyrighted October 7, 2024 City of Dubuque ACTION ITEMS # 3. City Council ITEM TITLE: Public Safety Software Recommendation SUMMARY: City Manager recommending City Council approval to enter into a contract with CentralSquare Technologies for public safety software for the City of Dubuque and its partner public safety agencies and give authorization to the Mayor to sign the contract. SUGGUESTED Receive and File; Approve DISPOSITION: ATTACHMENTS: 1. MVM Memo 2. Staff Memo Requesting Public Safety Software Contract With CentralSquare 3. CST Signed - Dubuque Police Department - Solutions Agreement - MSA - 08012024ba1 - Clean Final TBE - 8.27.2024 Page 502 of 674 Masterpiece on the Mississippi TO: The Honorable Mayor and City Council Members FROM: Michael C. Van Milligen, City Manager SUBJECT: Public Safety Software Recommendation DATE: October 2, 2024 Dubuque bikd AH erla City 111111 2007•2012.2013 2017*2019 Chief of Police Jeremy Jensen is recommending City Council approval to enter into a contract with CentralSquare Technologies for public safety software for the City of Dubuque and its partner public safety agencies and give authorization to the Mayor to sign the contract. The City of Dubuque and Dubuque County agreed to again partner for this software replacement project. The total cost of the project will be split evenly between the City of Dubuque and Dubuque County. Total cost of the project was estimated at $3 million. As part of the FY25 budget process, the Dubuque City Council approved up to $1.5 million dollars to cover the City of Dubuque's portion of the project. CentralSquare has given a quote of $2,006,980.11 as the total cost of the replacement project. The cost will be split 50/50 between the City of Dubuque and Dubuque County. The cost to the City of Dubuque is $1,003,490.06 and will cover all departments of the City using the system (Police, Fire, and 911). The annual recurring subscription cost is $376,372.16 starting in FY26. This is also split 50/50 between the City and the County I concur with the recommendation and respectfully request Mayor and City Council approval. l. Mic ael C. Van Milligen MCVM:sv Attachment cc: Crenna Brumwell, City Attorney Cori Burbach, Assistant City Manager Jeremy Jensen, Chief of Police Harley Pothoff, Dubuque County Board of Supervisors Chair Joseph Kennedy, Dubuque County Sheriff Page 503 of 674 Masterpiece on the Mississippi Dubuque trail AII•America City I 1I 2007*2012*2013 2017*2019 TO: Mike Van Milligen, City Manager FROM: Jeremy Jensen, Chief of Police SUBJECT: Public Safety Software Recommendation DATE: September 30, 2024 INTRODUCTION: This memorandum recommends the City of Dubuque enter into a contract with CentralSquare Technologies for public safety software for the City of Dubuque and its partner public safety agencies. BACKGROUND: In 2014, the Dubuque Police Department, the 911 Emergency Communications Center, and the Dubuque County Sheriff's Office began using Sungard public safety software for the Report Management System (RMS), Jail Management System (JMS) and Computer Aided Dispatch (CAD). Since 2014 there have been astronomical changes in software technology. The current system is no longer supported as the company had been bought out and the technology was outdated. Based upon the ever -changing environment and needs, it was determined that a new software and software vendor should be acquired. The City of Dubuque and Dubuque County agreed to again partner for this software replacement project. The total cost of the project will be split evenly between the City of Dubuque and Dubuque County. Total cost of the project was estimated at $3 million. As part of the FY25 budget process, the Dubuque City Council approved up to $1.5 million dollars to cover the City of Dubuque's portion of the project. A committee was formed consisting of representatives from the Dubuque Police Department, the Dubuque Fire Department, City of Dubuque Information Services, 911 Emergency Communications Center, and the Dubuque County Sheriff's Office. A Request for Proposal (RFP) for the project was released in September 2023. Six (6) Page 504 of 674 vendors submitted responses. Responses were reviewed by the committee, and two (2) vendors were invited to Dubuque for product demonstrations. These two vendors were picked as they both had proposals to cover the three major areas of need (RMS, JMS, CAD). The two vendors selected for demonstrations were CentralSquare Technologies and Tyler Technologies. Committee members then conducted additional research into the companies, which included contacting other agencies using their products. Conference calls, video conferencing and site visits were conducted. The agencies consulted were the Arapahoe, TX Police Department, the Wichita Falls, TX Police Department, and the Des Moines, IA Police Department. Agencies were selected which were using the vast majority of the systems the City of Dubuque and Dubuque County would be using. Additionally, the agencies had to be fully operational or close to fully operational with the systems. Also, consulting agencies needed to have gone through a data migration from an old system to one of the vendors. After product demonstrations, research and interviews, the committee met and selected CentralSquare Technologies to be the provider of the replacement public safety software. CentralSquare has given a quote of $2,006,980.11 as the total cost of the replacement project. The cost will be split 50/50 between the City of Dubuque and Dubuque County. The cost to the City of Dubuque is $1,003,490.06 and will cover all departments of the City using the system (Police, Fire, and 911). The annual recurring subscription cost is $376,372.16 starting in FY26. This is also split 50/50 between the City and the County. The City of Dubuque Legal Department has reviewed and approved the contract language as submitted with this memo. CONCLUSION & RECOMMENDATION Based upon the RFP, selection process and contract negotiations, I am recommending that the City of Dubuque enter into a contract with CentralSquare Technologies to be the provider of replacement public safety software. ACTION REQUESTED: Review and signing of the contract with CentralSquare Technologies. Page 505 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 CentralSquare Solutions Agreement This CentralSquare Solutions Agreement (the "Agreement"), effective as of the latest date shown on the signature block below (the "Effective Date"), is entered into between CentralSquare Technologies, LLC with its principal place of business in Lake Mary, FL ("CentralSquare") and the City of Dubuque c/o Dubuque Police Department, IA ("Customer"), together with CentralSquare, the "Parties", and each, a "Party. WHEREAS, Customer entered into a prior agreement for Software products with Superion, LLC, a CentralSquare Technologies, LLC company; and WHEREAS, Customer is a currently licensed end user of the Superion Software; and WHEREAS, through asset purchase, CentralSquare is the owner of all Superion Software products, services, and contractual obligations; and WHEREAS, Customer desires to discontinue use of the Superion Software products and upgrade to the CentralSquare Software solution identified in Exhibit B to this Agreement; and WHEREAS, this Agreement shall replace and supersede any and all prior agreements directly related to the Superion Software products being replaced by this Agreement. WHEREAS, CentralSquare licenses and gives access to certain software applications ("Solutions") to its customers and also provides maintenance, support, migration, installation and other professional services; and WHEREAS, Customer desires to license and/or gain access to certain Solutions and receive professional services described herein, and CentralSquare desires to grant and provide Customer license and access to such offerings as well as to provide support and maintenance, subject to the terms and conditions set forth in this Agreement. NOW, THEREFORE, in consideration of the mutual covenants, terms, and conditions set forth herein, and for other good and valuable consideration, the receipt and sufficiency of which are hereby acknowledged, by the signatures of their duly authorized representative below, the Parties intending to be legally bound, agree to all of the following provisions and exhibits of this Agreement: CentralSquare Technologies, LLC City of Dubuque c/o Dubuque Police Department 1000 Business Center Drive Lake Mary, FL 32746 50 W. 13th St., City Hall, Dubuque, IA , 52001-486 Signed by. Brim, gaGrSOIA, By: rllstivg goc n Anderson Print Name: Brad M. Cavanagh Print Title: chief sales officer Print Title: Mayor Date Signed:8/27/2024 Date Signed: 10/08/2024 Solution: PSJ Enterprise Term. Initial Term. The Initial Term of this Agreement commences as of the Effective Date and will continue in effect for five Page 506 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 (5) year(s) from such date unless terminated earlier pursuant to any of the Agreement's express provisions (the "Initial Term"). Renewal Term. This Agreement will automatically renew for additional successive one (1) year terms unless earlier terminated pursuant to any of the Agreement's provisions (a "Renewal Term" and, collectively, with the Initial Term, the "Term"). Non -Renewal. Either Party may elect to end renewal of the Agreement by issuing a notice of non -renewal, in writing, to the other Party six (6) months prior to the expiration of the Agreement term. Fees. In consideration of the rights and services granted by CentralSquare to Customer under this Agreement, Customer shall make payments to CentralSquare pursuant to the amounts and payment terms outlined in Exhibit 1 (the Solution(s) and Services Fee Schedule). All invoices shall be billed and paid in U.S. dollars (USD) and in accordance with the terms set forth in Exhibit 1. If Customer delays an invoice payment for any reason, Customer shall promptly notify CentralSquare in writing the reasons for such delay. Unless otherwise agreed by both Parties, CentralSquare may apply any payment received to any delinquent amount outstanding. Page 507 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Standard Terms and Conditions 1. Definitions. Capitalized terms not otherwise defined in this Agreement have the meanings set forth below: 1.1. "Affiliate" means any other Entity that directly or indirectly, through one or more intermediaries, controls, is controlled by, or is under common control with, such Entity. 1.2. "Authorized User" means Customer's employees, consultants, contractors, and agents who are authorized by Customer to access and use the Solutions pursuant to this Agreement, and for whom access to the Solutions has been purchased. 1.3. "Baseline Solution" means the version of a Solution updated from time to time pursuant to CentralSquare's warranty services and maintenance, but without any other modification. 1.4. "CentralSquare Systems" means the information technology infrastructure used by or on behalf of CentralSquare to deliver the Solutions, including all computers, software, hardware, databases, electronic systems (including database management systems), and networks, whether operated directly by CentralSquare or through the use of third -party services. 1.5. "Customer Data" means information, data, and content, in any form or medium, collected, downloaded, or otherwise received, directly or indirectly from Customer, an Authorized User or end -users by or through the Solutions, provided the data is not personally identifiable and not identifiable to Customer. 1.6. "Customer Systems" means the Customer's information technology infrastructure, including computers, software, hardware, databases, electronic systems (including database management systems), and networks, whether operated by Customer or through the third -party services. 1.7. "Defect" means a material deviation between the Baseline Solution and its Documentation, for which Customer has given CentralSquare sufficient information to enable CentralSquare to replicate the deviation on a computer configuration that is both comparable to the Customer Systems and that is under CentralSquare's control. Further, with regard to any custom modification, Defect means a material deviation between the custom modification and the CentralSquare generated specification and Documentation for such custom modification, and for which Defect Customer has given CentralSquare sufficient information to enable CentralSquare to replicate the deviation on a computer configuration that is both comparable to the Customer Systems and that is under CentralSquare's control. 1.8. "Delivery" means: 1.8.1. For on -premise Solutions, Delivery shall be when CentralSquare delivers to Customer the initial copies of the Solutions outlined in Exhibit 1 by whichever the following applies and occurs first (a) electronic delivery, by posting it on CentralSquare's network for downloading, or similar suitable electronic file transfer method, or (b) physical shipment, such as on a disc or other suitable media transfer method, or (c) installation, or (d) delivery of managed services server. Physical shipment is on FOB - CentralSquare's shipping point, and electronic delivery is at the time CentralSquare provides Customer with access to download the Solutions. 1.8.2. For cloud -based Solutions Delivery shall be whichever the following applies and occurs first when Authorized Users have (a) received log -in access to the Solution or any module of the Solution or (b) received access to the Solution via a URL. 1.9. "Documentation" means any manuals, instructions, or other documents or materials that CentralSquare provides or makes available to Customer in any form or medium and which describe the functionality, components, features, or requirements of the Solution(s), including any aspect of its installation, configuration, integration, operation, use, support, or maintenance. 1.10. "End User Training" means the process of educating general users of the Software on the operation of the Software. 1.11. "Entity" means an individual, corporation, partnership, joint venture, limited liability entity, governmental authority, unincorporated organization, trust, association, or other organization. Page 508 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 1.12. "Hardware" means any equipment, computer systems, servers, storage devices, peripherals, and any other tangible assets purchased under this Agreement. 1.13. "Intellectual Property Rights" means any and all registered and unregistered rights granted, applied for, or otherwise now or hereafter in existence under or related to any patent, copyright, trademark, trade secret, database protection, or other intellectual property rights laws, and all similar or equivalent rights or forms of protection, in any part of the world. 1.14. "Managed Services Hardware" means any equipment, computer systems, servers, peripherals, and any other tangible asset purchased as a subscription under this Agreement. 1.15. "Maintenance" means optimization, error correction, modifications, and Updates (defined herein) to CentralSquare Solutions to correct any known Defects and improve performance. Maintenance will be provided for each Solution, the hours and details of which are described in Exhibit 2 (Maintenance and Support) 1.16. "New or Major Releases" means new versions of a Baseline Solution (e.g., version 4.0, 5.0 etc.) not provided as part of Maintenance. 1.17. "Personal Information" means any information that does or can identify a specific individual or by or from which a specific individual may be identified, contacted, or located. Personal Information includes all "nonpublic personal information" as defined under the Gramm -Leach -Bliley Act, "protected health information" as defined under the Health and Insurance Portability and Accountability Act of 1996, "Personal Data" as defined in the EU General Data Protection Regulation (GDPR 2018), "Personal Information" as defined under the Children's Online Privacy Protection Act of 1998, and all rules and regulations issued under any of the foregoing. 1.18. "Professional Services" means configuration, installation, implementation, development work, training or consulting services including custom modification programming, support relating to custom modifications, on -site support services, assistance with data transfers, system restarts and reinstallations provided by CentralSquare. 1.19. "Project Kickoff" is a meeting to occur shortly after contract execution between CentralSquare and Customer in which goals and objectives are set forth, all parties relevant team members are identified, and scope, timelines, and milestones are reviewed. 1.20. "Reliability Period" is the time period in which the Software is tested and confirmed reliable by successfully completed fifteen (15) continuous days in a live environment with no repeatable Priority 1 or Priority 2 issues as defined in Exhibit 2, unless otherwise agreed in a statement of work. 1.21. "Software" means the software program(s) (in object code format only) identified on Exhibit 1 (Solution(s) and Services Fee Schedule). The term "Software" excludes any Third -Party Software. 1.22. "Software Version" means the base or core version of the Solution Software that contains significant new features and significant fixes and is available to the Customer. The nomenclature used for updates and upgrades consists of major, minor, build, and fix and these correspond to the following digit locations of a release, a,b,c,d. An example of which would be 7.4.1.3, where the 7 refers to the major release, the 4 refers to the minor release, the 1 refers to the build, and the 3 refers to a fix. 1.23. "Solutions" means the software, Documentation, development work, CentralSquare Systems and any and all other information, data, documents, materials, works, and other content, devices, methods, processes, hardware, software, technologies and inventions, including any deliverables, technical or functional descriptions, requirements, plans, or reports, provided or used by CentralSquare or any Subcontractor in connection with Professional Services or Support Services rendered under this Agreement. 1.24. "Support Services" means Maintenance, Enhancements, implementation of New Releases, and general support efforts to respond to incidents reported by Customer in accordance with Exhibit 2 (Maintenance & Support) and Exhibit 8 (Managed Services Provisions), if applicable. 1.25. "Third -Party Materials" means materials and information, in any form or medium, including any software, documents, data, content, specifications, products, related services, equipment, or components of or relating to the Solutions that are not proprietary to CentralSquare. Page 509 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 2. License, Access, and Title. 2.1. License Grant. For any Solution designated as a "license" on Exhibit 1, Customer is granted a perpetual (unless terminated as provided herein), nontransferable, nonexclusive right and license to use the Software for Customer's own internal use for the applications described in the Statement of Work, in the applicable environment (e.g., production, test, training, or disaster recovery system) and in the quantity set forth in Exhibit 1. Additional software licenses purchased after the execution of this Agreement shall also be licensed in accordance with the provisions of this section. Customer shall not use, copy, rent, lease, sell, sublicense, modify, create derivative works from/of, or transfer any software, or permit others to do said acts, except as provided in this Agreement. Any such unauthorized use shall be void and may result in immediate and automatic termination of the applicable license. In such event, Customer shall not be entitled to a refund of any license fees paid. Notwithstanding, Customer shall be entitled to use software at the applicable designated location for the purpose of the application(s) described in the Statement of Work to provide services for itself and other Affiliate governmental agencies/entities, provided that the Software is installed and operated at only one physical location. The Software license granted in this Agreement or in connection with it are for object code only and do not include a license or any rights to source code whatsoever. 2.2. Access Grant. For any Solution designated as a "subscription" on Exhibit 1, so long as subscription fees are paid and current, (unless terminated as provided herein), Customer is granted a nontransferable, nonexclusive right to use the software for the Customer's own internal use for the applications described in the Statement of Work, in the applicable environment (e.g., production, test, training, or disaster recovery system) and in the quantity set forth in Exhibit 1. Additional CentralSquare software subscriptions purchased after the execution of this Agreement shall also be accessed in accordance with the provisions of this section. Customer shall not use, copy, rent, lease, sell, sublicense, modify, create derivative works from/of, or transfer any software, or permit others to do said acts, except as provided in this Agreement. Any such unauthorized use shall be void and may result in immediate and automatic termination of the applicable access. In such event, Customer shall not be entitled to a refund of any subscription fees paid. Notwithstanding, Customer shall be entitled to use software at the applicable designated location for the purpose of the application(s) described in the Statement of Work to provide services for itself and other Affiliate governmental agencies/entities. The subscription access granted in this Agreement or in connection with it are for object code only and do not include a license or any rights to source code whatsoever. 2.3. Documentation License. CentralSquare hereby grants to Customer a non-exclusive, non-sublicensable, non- transferable license to use the Documentation during the Term solely for Customer's internal business purposes in connection with its use of the Solutions. 2.4. Application Programming Interface "API". If the Customer has purchased any Application Programming Interface (API) license or subscription, Customer may use such API for Customer's own internal use to develop interfaces which enable interfacing with the applicable CentralSquare Software purchased herein. The development and use of such interfacing applications is specifically permitted under the use granted herein and shall not be deemed derivative works provided that they are not, in fact, derived from the CentralSquare Software or the ideas, methods of operation, processes, technology or know-how implemented therein. Other than the usage rights granted herein, Customer shall not acquire any right, title or interest in the CentralSquare Software or API by virtue of the interfacing of such applications, whether as joint owner, or otherwise. Should Customer desire to provide or share the API to a third -party, the third -party must enter into an API Access Agreement by and between the third -party and CentralSquare directly to govern the usage rights and restrictions of the applicable API. 2.5. Hardware. Subject to the terms and conditions of this Agreement, CentralSquare agrees to deliver, through hardware vendors, the Hardware itemized on Exhibit 1. The risk of loss or damage will pass to Customer upon the date of delivery to the Customer specified facility. Upon delivery and full satisfaction of the Hardware payment obligations, Hardware shall be deemed accepted and Customer will acquire good and clear title to Hardware. All Hardware manufacturer warranties will be passed through to Customer. CentralSquare expressly disclaims, and Customer hereby expressly waives all other Hardware warranties, express or implied, without limitation, warranties of merchantability and fitness for a particular purpose. Page 510 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 2.6. Managed Services Hardware. Subject to the terms and conditions of this Agreement, CentralSquare agrees to deliver the Managed Services Hardware itemized on Exhibit 1. So long as the applicable subscription fees are paid and current, Customer shall maintain a limited right in possessory interest in the Managed Services Hardware. No title in the Managed Services Hardware will pass to Customer at any time or for any reason. Customer agrees to maintain adequate insurance against fire, theft, or other loss for the Managed Services Hardware full insurable value. CentralSquare shall coordinate any defect or warranty claims in accordance with Exhibit 8. 2.7. Reservation of Rights. Nothing in this Agreement grants any right, title, or interest in or to any Intellectual Property Rights in or relating to the Solutions, or Third -Party Materials, whether expressly, by implication, estoppel, or otherwise. All right, title, and interest in the Solutions, and the Third -Party Materials are and will remain with CentralSquare and the respective rights holders. 3. Use Restrictions. Authorized Users shall not: 3.1. copy, modify, or create derivative works or improvements of the Solutions, or rent, lease, lend, sell, sublicense, assign, distribute, publish, transfer, or otherwise make available any Solutions to any Entity, including on or in connection with the internet or any time-sharing, service bureau, software as a service, cloud, or other technology or service; 3.2. reverse engineer, disassemble, decompile, decode, adapt, or otherwise attempt to derive or gain access to the source code of the Solutions, in whole or in part; 3.3. bypass or breach any security device or protection used by Solutions or access or use the Solutions other than by an Authorized User through the use of his or her own then valid access; 3.4. input, upload, transmit, or otherwise provide to or through the CentralSquare Systems, any information or materials that are unlawful or injurious, or contain, transmit, or activate any harmful code (any software, hardware, device, or other technology, including any virus, worm, malware, or other malicious computer code, the purpose or effect of which is to (a) permit unauthorized access to, or to destroy, disrupt, disable, distort, or otherwise harm or impede any (i) computer, software firmware, hardware, system or network; or (ii) any application or function of any of the foregoing or the security, integrity, confidentiality, or use of any data processed thereby; or (b) prevent Customer or any Authorized User from accessing or using the Solutions as intended by this Agreement; 3.5. damage, destroy, disrupt, disable, impair, interfere with, or otherwise impede or harm in any manner the CentralSquare Systems, or CentralSquare's provision of services to any third -party, in whole or in part; 3.6. remove, delete, alter, or obscure any trademarks, specifications, Documentation, warranties, or disclaimers, or any copyright, trademark, patent, or other intellectual property or proprietary rights notices from any Documentation or Solutions, including any copy thereof; 3.7. access or use the Solutions in any manner or for any purpose that infringes, misappropriates, or otherwise violates any Intellectual Property Right or other right of any third -party, or that violates any applicable law; 3.8. access or use the Solutions for purposes of competitive analysis of the Solutions, the development, provision, or use of a competing software service or product or any other purpose that is to CentralSquare's detriment or commercial disadvantage or otherwise access or use the Solutions beyond the scope of the authorization granted in Section 2. 4. Audit. 4.1. CentralSquare shall have the right to audit Customer's use of the Software to monitor compliance with this Agreement. Customer shall permit CentralSquare and its directors, officers, employees, and agents to have on -site access at Customer's premises (or remote access as the case may be) during normal business hours to such systems, books, and records for the purpose of verifying license counts, access counts, and overall compliance with this Agreement. Customer shall render reasonable cooperation to CentralSquare as requested. If as a result of any audit or inspection CentralSquare substantiates a deficiency or non- compliance, or if an audit reveals that Customer has exceeded the restrictions on use, Customer shall promptly reimburse CentralSquare for all its costs and expenses incurred to conduct such audit or inspection and be required to pay for any delinquencies in compliance and prompt payment of any underpayment of Fees. Page 511 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 5. Customer Obligations. 5.1. Customer Systems and Cooperation. Customer shall at all times during the Term: (a) set up, maintain, and operate in good repair all Customer Systems on or through which the Solutions are accessed or used; (b) provide CentralSquare Personnel with such access to Customer's premises and Customer Systems as is necessary for CentralSquare to perform the Support Services in accordance with the Support Standards and specifications and if required by CentralSquare, remote access in accordance with Exhibit 3 (CentralSquare Access Management Policy); and (c) provide all cooperation as CentralSquare may reasonably request to enable CentralSquare to exercise its rights and perform its obligations under this Agreement. 5.2. Effect of Customer Failure or Delay. CentralSquare is not responsible or liable for any delay or failure of performance caused in whole or in part by Customer's delay in performing, or failure to perform, any of its obligations under this Agreement. 5.3. Corrective Action and Notice. If Customer becomes aware of any actual or threatened activity prohibited by Section 6, Customer shall, and shall cause its Authorized Users to, immediately: (a) take all reasonable and lawful measures within their respective control that are necessary to stop the activity or threatened activity and to mitigate its effects (including, where applicable, by discontinuing and preventing any unauthorized access to the Solutions and permanently erasing from their systems and destroying any data to which any of them gained unauthorized access); and (b) notify CentralSquare of any such actual or threatened activity. 5.4. Maintaining Current Versions of CentralSquare Solutions. In accordance with Exhibit 2 (Maintenance & Support) and Exhibit 8 (Managed Services Provisions), if applicable. Customer shall install and/or use any New or Major Release within one year of being made available by CentralSquare to mitigate a performance problem, ineligibility for Support Services, or an infringement claim. 6. Professional Services. 6.1. Compliance with Customer Policies. While CentralSquare personnel are performing services at Customer's site, CentralSquare personnel will comply with Customer's reasonable procedures and site policies that are generally applicable to Customer's other suppliers providing similar services and that have been provided to CentralSquare in writing or in advance. 6.2. Contributed Material. In the process of CentralSquare's performing Professional Services, Customer may, from time to time, provide CentralSquare with designs, plans, or specifications, improvements, works or other material for inclusion in, or making modifications to, the Solutions, the Documentation or any other deliverables ("Contributed Material"). Customer grants to CentralSquare a nonexclusive, irrevocable, perpetual, transferable right, without the payment of any royalties or other compensation of any kind and without the right of attribution, for CentralSquare, CentralSquare's Affiliates and CentralSquare's licensees to make, use, sell and create derivative works of the Contributed Material. 6.3. Criminal Justice Information Services. To the extent permissible, the parties acknowledge that any employee of CentralSquare who has been granted Criminal Justice Information Services ("CJIS") clearance in any state within the United States shall be deemed to have satisfied the CJIS clearance requirements under this Agreement. This provision is based on the principle of reciprocity, recognizing the validity of CJIS clearance across state lines. Notwithstanding the foregoing, CentralSquare shall ensure that all employees comply with the applicable laws and regulations of the state in which services under this Agreement are performed. CentralSquare shall also ensure that all employees continue to meet the standards required for CJIS clearance and shall promptly notify Customer of any changes in an employee's CJIS clearance status. 7. Confidentiality. 7.1. Nondisclosure. The Parties agree, unless otherwise provided in this Agreement or required by law, not to use or make each other's Confidential Information available to any third party for any purpose other than as necessary to perform under this Agreement. "Confidential Information" means the Solution(s), Software, and customizations in any embodiment, and either Party's technical and business information relating to inventions or software, research and development, future product specifications, engineering processes, costs, profit or margin information, marketing and future business plans as well as any and all internal Page 512 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Customer and employee information, and any information exchanged by the Parties that is clearly marked with a confidential, private or proprietary legend or which, by its nature, is commonly understood to be confidential. 7.2. Exceptions. A Party's Confidential Information shall not include information that: (a) is or becomes publicly available through no act or omission of the recipient; (b) was in the recipient's lawful possession prior to the disclosure and was not obtained by the recipient either directly or indirectly from the disclosing Party; (c) is lawfully disclosed to the recipient by a third party without restriction on recipient's disclosure, and where recipient was not aware that the information was the confidential information of discloser; (d) is independently developed by the recipient without violation of this Agreement; or (e) is required to be disclosed by law as determined by Customer's legal counsel. 8. Security. 8.1. CentralSquare will implement commercially reasonable administrative, technical and physical safeguards designed to ensure the security and confidentiality of Customer Data, protect against any anticipated threats or hazards to the security or integrity of Customer Data, and protect against unauthorized access or use of Customer Data. CentralSquare will review and test such safeguards on no less than an annual basis. 8.2. Customer shall maintain, in connection with the operation or use of the Solutions, adequate technical and procedural access controls and system security requirements and devices, necessary for data privacy, confidentiality, integrity, authorization, authentication, non -repudiation, virus detection and eradication. 8.3. To the extent that Authorized Users are permitted to have access to the Solutions, Customer shall maintain agreements with such Authorized Users that adequately protect the confidentiality and Intellectual Property Rights of CentralSquare in the Solutions and Documentation and disclaim any liability or responsibility of CentralSquare with respect to such Authorized Users. 9. Personal Data. If CentralSquare processes or otherwise has access to any personal data or Personal Information on Customer's behalf when performing CentralSquare's obligations under this Agreement, then: 9.1. Customer shall be the data controller (where "data controller" means an entity which alone or jointly with others determines purposes for which and the manner in which any personal data are, or are to be, processed) and CentralSquare shall be a data processor (where "data processor" means an entity which processes the data only on behalf of the data controller and not for any purposes of its own); 9.2. Customer shall ensure that it has obtained all necessary consents and it is entitled to transfer the relevant personal data or Personal Information to CentralSquare so that CentralSquare may lawfully use, process and transfer the personal data and Personal Information in accordance with this Agreement on Customer's behalf, which may include CentralSquare processing and transferring the relevant personal data or Personal Information outside the country where Customer and the Authorized Users are located in order for CentralSquare to provide the Solutions and perform its other obligations under this Agreement; and 9.3. CentralSquare shall process personal data and information only in accordance with lawful and reasonable written instructions given by Customer and as set out in and in accordance with the terms of this Agreement; and 9.4. CentralSquare shall take reasonable steps to ensure that its employees, agents and contractors who may have access to Personal Information are persons who need to know / access the relevant Personal Information for valid business reasons; and 9.5. each Party shall take appropriate technical and organizational measures against unauthorized or unlawful processing of the personal data and Personal Information or its accidental loss, destruction or damage so that, having regard to the state of technological development and the cost of implementing any measures, the measures taken ensure a level of security appropriate to the harm that might result from such unauthorized or unlawful processing or accidental loss, destruction or damage in relation to the personal data and Personal Information and the nature of the personal data and Personal Information being protected. If necessary, the Parties will cooperate to document these measures taken. 10. Representations and Warranties. Page 513 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 10.1. Intellectual Property Warranty. CentralSquare represents and warrants that (a) it is the sole and exclusive owner of (or has the right to license) the software; (b) it has full and sufficient right, title and authority to grant the rights and/or licenses granted under this Agreement; (c) the software does not contain any materials developed by a third party used by CentralSquare except pursuant to a license agreement; and (d) the software does not infringe any patent, or copyright. 10.2. Intellectual Property Remedy. In the event that any third party asserts a claim of infringement against the Customer relating to the software contained in this Agreement, CentralSquare shall indemnify and defend the Customer pursuant to section 13.1 of this Agreement. In the case of any such claim of infringement, CentralSquare shall either, at its option, (1) procure for Customer the right to continue using the software; or (2) replace or modify the software so that that it becomes non -infringing, but equivalent in functionality and performance. 10.3. Software Warranty. CentralSquare warrants to Customer that: (i) for a period of one year from the Effective Date (the "Warranty Period") the Software will substantially conform in all material respects to the specifications set forth in the Documentation, when installed, operated and used as recommended in the Documentation and in accordance with this Agreement; and (ii) at the time of delivery the Software does not contain any virus or other malicious code. 10.4. Software Remedy. If, during the Warranty Period a warranty defect is confirmed in the CentralSquare Software, CentralSquare shall, at its option, reinstall the Software or correct the Defects. Defects that occur in the Software after the Warranty Period will be corrected pursuant to Exhibit 2 (Maintenance & Support) and Exhibit 8 (Managed Services Provisions), if applicable. 10.5. Services Warranty. CentralSquare warrants that the Professional Services delivered will substantially conform to the deliverables specified in the applicable statement of work and that all Professional Services will be performed in a professional and workmanlike manner consistent with industry standards for similar work. If Professional Services do not substantially conform to the deliverables, Customer shall notify CentralSquare of such non-conformance in writing, within 10 days from completion of Professional Service, and CentralSquare shall promptly repair the non -conforming deliverables. 10.6. Disclaimer of Warranty. EXCEPT FOR THE EXPRESS LIMITED WARRANTIES SET FORTH ABOVE, CENTRALSQUARE MAKES NO WARRANTIES WHATSOEVER, EXPRESSED OR IMPLIED, WITH REGARD TO THE INTELLECTUAL PROPERTY, SOFTWARE, PROFESSIONAL SERVICES, AND/OR ANY OTHER MATTER RELATING TO THIS AGREEMENT, AND THAT CENTRALSQUARE DISCLAIMS ALL WARRANTIES, WHETHER EXPRESS, IMPLIED, STATUTORY, OR OTHERWISE, INCLUDING ALL WARRANTIES ARISING FROM COURSE OF DEALING, USAGE OR TRADE PRACTICE, AND SPECIFICALLY DISCLAIMS IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR TITLE. FURTHER, CENTRALSQUARE EXPRESSLY DOES NOT WARRANT THAT A SOLUTION, ANY CUSTOM MODIFICATION OR ANY IMPROVEMENTS WILL BE USABLE BY CUSTOMER IF THE SOLUTION OR CUSTOM MODIFICATION HAS BEEN MODIFIED BY ANYONE OTHER THAN CENTRALSQUARE PERSONNEL, OR WILL BE ERROR FREE, WILL OPERATE WITHOUT INTERRUPTION OR WILL BE COMPATIBLE WITH ANY HARDWARE OR SOFTWARE EXCEPT TO THE EXTENT EXPRESSLY SET FORTH IN THE DOCUMENTATION. ALL THIRD -PARTY MATERIALS ARE PROVIDED "AS -IS" AND ANY REPRESENTATION OR WARRANTY OF OR CONCERNING ANY OF THEM IS STRICTLY BETWEEN CUSTOMER AND THE THIRD -PARTY. THIS AGREEMENT DOES NOT AMEND, OR MODIFY CENTRALSQUARE'S WARRANTY UNDER ANY AGREEMENT OR ANY CONDITIONS, LIMITATIONS, OR RESTRICTIONS THEREOF. 11. Notices. All notices and other communications required or permitted under this Agreement must be in writing and will be deemed given when delivered personally, sent by United States registered or certified mail, return receipt requested; transmitted by facsimile or email confirmed by first class mail, or sent by overnight courier. Notices must be sent to a Party at its address shown below, or to such other place as the Party may subsequently designate for its receipt of notices in writing by the other Party. If to CentralSqua CentralSquare Technologies, LLC 1000 Business Center Dr. Page 514 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 If to Customer: Lake Mary, FL 32746 Phone: 407-304-3235 Attention: Legal/Contracts City of Dubuque, Iowa c/o Dubuque Police Department 50 W. 13th St., City Hall Dubuque, IA 52001-4864 Phone: 563-543-0163 Email: smoore@cityofdubuque.org Attention: Stacey Moore 12. Force Majeure. Neither Party shall be responsible for failure to fulfill its obligations hereunder, or be liable for damages resulting from delay in performance as a result of war, fire, strike, riot or insurrection, natural disaster, pandemic or epidemic, delay of carriers, governmental order or regulation, complete or partial shutdown of plant, unavailability of equipment, software, or services from suppliers, default of a subcontractor or vendor to the Party if such default arises out of causes beyond the reasonable control of such subcontractor or vendor, the acts or omissions of the other Party, or its officers, directors, employees, agents, contractors, or elected officials, and/or other occurrences beyond the Party's reasonable control ("Excusable Delay" hereunder). In the event of such Excusable Delay, performance shall be extended on a day for day basis or as otherwise reasonably necessary to compensate for such delay. 13. Indemnification. 13.1. CentralSquare Indemnification. CentralSquare shall indemnify, defend, and hold harmless Customer from any and all Claims or liability, including attorneys' fees and costs, brought by a third party, allegedly arising out of, in connection with, or incident to any loss, damage or injury to persons or property or arising solely from a wrongful or negligent act, error or omission of CentralSquare, its employees, agents, contractors, or any subcontractor as a result of CentralSquare's or any subcontractor's performance pursuant to this Agreement; however, CentralSquare shall not be required to indemnify Customer for any claims caused to the extent of the negligence or wrongful act of Customer, its employees, agents, or contractors. Notwithstanding anything to the contrary in the foregoing, if a Claim or liability results from or is contributed to by the actions or omissions of Customer, or its employees, agents or contractors, CentralSquare's obligations under this provision shall be reduced to the extent of such actions or omissions based upon the principle of comparative fault. 13.2. Customer Indemnification. To the extent allowable by law, Customer shall indemnify, defend, and hold harmless CentralSquare from any and all Claims or liability, including attorneys' fees and costs, allegedly arising out of, in connection with, or incident to any loss, damage or injury to persons or property or arising solely from a wrongful or negligent act, error or omission of Customer, its employees, agents, contractors, or any subcontractor as a result of Customer's or any subcontractor's performance pursuant to this Agreement; however, Customer shall not be required to indemnify CentralSquare for any Claims or actions caused to the extent of the negligence or wrongful act of CentralSquare, its employees, agents, or contractors. Notwithstanding anything to the contrary in the foregoing, if a Claim or liability results from or is contributed to by the actions or omissions of CentralSquare, or its employees, agents or contractors, Customer's obligations under this provision shall be reduced to the extent of such actions or omissions based upon the principle of comparative fault. 13.3. "Claim" in this Section 13 means any claim, cause of action, demand, lawsuit, dispute, inquiry, audit, notice of violation, proceeding, litigation, citation, summons, subpoena or investigation of any nature, civil, criminal, administrative, regulatory or other, whether at law, in equity, or otherwise. 14. Termination. 14.1. Either Party may terminate this Agreement for a material breach in accordance with this subsection. In such event, the disputing Party shall deliver written notice of its intent to terminate along with a description in reasonable detail of the problems for which the disputing Party is invoking its right to terminate and the specific Page 515 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 requirement within this Agreement or any exhibit or schedule hereto that the disputing Party is relying upon. Following such notice, the Parties shall commence dispute resolution procedures in accordance with the dispute resolution procedure pursuant to Section 17. 14.2. CentralSquare shall have the right to terminate this Agreement based on Customer's failure to pay undisputed amounts due under this Agreement more than ninety (90) days after delivery of written notice of non-payment. 14.3. Customer shall have the right to terminate if the proper appropriation of funds for the continuation of this Agreement is not available for any fiscal year after the first fiscal year during the Term, then this Agreement may be terminated. To effect the termination of this Agreement, Customer shall, within forty-five (45) days following the beginning of the fiscal year for which the proper appropriation is not available, provide CentralSquare with written notice of the failure to obtain the proper appropriation of funds. Such notice shall be accompanied by the payment of all sums then owed CentralSquare under this Agreement, if any. 14.4. Customer may also terminate for convenience, in whole or in part, with or without cause, at any time by providing thirty (30) days written notice. Should Customer terminate for convenience during any twelve (12) month term, CentralSquare shall provide a pro -rated refund for any on -premise subscription asset designated on Exhibit 1, with "(OP)". Should Customer terminate for convenience, in whole or in part, any cloud hosted subscription asset, no pre -paid fees shall be returned, or pro -rated refund be given, for any remaining months on the then current term. Should Customer terminate for convenience, in whole or in part, any third -party asset, no pre -paid fees shall be returned, or pro -rated refund be given, for any remaining months on the then current term. 15. Effect of Termination or Expiration. On the expiration or earlier termination of this Agreement: 15.1. All rights, licenses, and authorizations granted to Customer hereunder will immediately terminate and Customer shall immediately cease all use of CentralSquare's Confidential Information and the Solutions, and within thirty (30) days deliver to CentralSquare, or at CentralSquare's request destroy and erase CentralSquare's Confidential Information from all systems Customer directly or indirectly controls; and 15.2. All licenses, access or subscription fees, services rendered but unpaid, and any amounts due by Customer to CentralSquare of any kind shall become immediately payable and due no later than thirty (30) days after the effective date of the termination or expiration, including anything that accrues within those thirty (30) days. 15.3. The provisions set forth in the following sections, and any other right or obligation of the Parties in this Agreement that, by its nature (including but not limited to: Use Restrictions, Confidential Information, Warranty Disclaimers, Indemnifications, & Limitations of Liability), will survive any expiration or termination of this Agreement. 15.4. In the event that Customer terminates this Agreement or cancels any portions of a project (as may be set forth in a Statement of Work) prior to Go Live (which shall be defined as "first use of a Solution or module of a Solution in a production environment, unless otherwise agreed by the Parties in a statement of work"), Customer shall pay for all Professional Services actually performed by CentralSquare on a time and materials basis, regardless of the payment terms in Exhibit 1. 15.5. Return of Customer Data. If Customer requests in writing at least ten (10) days prior to the effective date of expiration or earlier termination of this Agreement, CentralSquare shall within sixty (60) days following such expiration or termination, deliver to Customer in CentralSquare's standard format the then most recent version of Customer Data maintained by CentralSquare, provided that Customer has at that time paid all Fees then outstanding and any amounts payable after or as a result of such expiration or termination. 15.6. Deconversion. In the event of (i) expiration or earlier termination of this Agreement, or (ii) Customer no longer purchasing certain Solutions (including those indicated to be Third -Party Materials), if Customer requests assistance in the transfer of Customer Data to a different vendor's applications ("Deconversion"), CentralSquare will provide reasonable assistance. CentralSquare and Customer will negotiate in good faith to establish the relative roles and responsibilities of CentralSquare and Customer in effecting Deconversion, as well as the appropriate date for completion. CentralSquare shall be entitled to receive compensation for any additional consultation, services, software, and documentation required for Deconversion on a time and materials basis at CentralSquare's then standard rates. Page 516 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 15.7. Termination of this Agreement shall not relieve either Party of any other obligation incurred one to the other prior to termination. 16. Assignment. Neither this Agreement nor any rights or obligations hereunder shall be assigned or otherwise transferred by either Party without the prior written consent of the other Party, which consent will not be unreasonably withheld; provided however, that in the event of a merger or acquisition of all or substantially all of CentralSquare's assets, CentralSquare may assign this Agreement to an entity ready, willing and able to perform CentralSquare's executory obligations hereunder. 17. Dispute Resolution. Any dispute, controversy or claim arising out of or relating to this Agreement (each, a "Dispute"), including the breach, termination, or validity thereof, shall be resolved as follows: 17.1. Good Faith Negotiations. The Parties agree to send written notice to the other Party of any Dispute ("Dispute Notice"). After the other Party receives the Dispute Notice, the Parties agree to undertake good faith negotiations to resolve the Dispute. Each Party shall be responsible for its associated travel and other related costs. 17.2. Escalation to Mediation. If the Parties cannot resolve any Dispute through good faith negotiations, the dispute will be escalated to non -binding mediation, with the Parties acting in good faith to select a mediator and establishing the mediation process. The Parties agree the mediator's fees and expenses, and the mediator's costs incidental to the mediation, will be shared equally between the Parties. The Parties shall bear their own fees, expenses, and costs. 17.3. Confidential Mediation. The Parties further agree all written or oral offers, promises, conduct, and statements made in the course of the mediation are confidential, privileged, and inadmissible for any purpose in any litigation, arbitration or other proceeding involving the Parties. However, evidence that is otherwise admissible or discoverable shall not be rendered inadmissible or non -discoverable as a result of its use in the mediation. 17.4. Litigation. If the Parties cannot resolve a Dispute through mediation, then once an impasse is declared by the mediator either Party may pursue litigation. Exclusive venue for any action arising out of this Agreement shall be the Iowa District Court for Dubuque County. 17.5. This Agreement shall be interpreted and construed according to the laws of the State of Iowa. 18. Waiver/Severabilitv. The failure of any Party to enforce any of the provisions hereof will not be construed to be a waiver of the right of such Party thereafter to enforce such provisions. If any provision of this Agreement is found to be unenforceable, that provision will be enforced to the maximum extent possible, and the validity, legality and enforceability of the remaining provisions will not in any way be affected or impaired thereby. 19. LIABILITY. NOTWITHSTANDING ANY PROVISION WITHIN THIS AGREEMENT TO THE CONTRARY, AND REGARDLESS OF THE NUMBER OF LOSSES, WHETHER IN CONTRACT, EQUITY, STATUTE, TORT, NEGLIGENCE, OR OTHERWISE: 19.1. NEITHER PARTY SHALL HAVE LIABILITY TO THE OTHER PARTY FOR ANY SPECIAL, INDIRECT, INCIDENTAL, PUNITIVE, EXEMPLARY, LIQUIDATED, OR CONSEQUENTIAL DAMAGES OF ANY KIND INCLUDING BUT NOT LIMITED TO, REPLACEMENT COSTS, AND NEITHER PARTY SHALL BE LIABLE TO THE OTHER PARTY FOR LOSSES OF PROFIT, REVENUE, INCOME, BUSINESS, ANTICIPATED SAVINGS, DATA, AND REPUTATION, AND MORE GENERALLY, ANY LOSSES OF AN ECONOMIC OR FINANCIAL NATURE, REGARDLESS OF WHETHER SUCH LOSSES MAY BE DEEMED AS CONSEQUENTIAL OR ARISING DIRECTLY AND NATURALLY FROM THE INCIDENT GIVING RISE TO THE CLAIM, AND REGARDLESS OF WHETHER SUCH LOSSES ARE FORESEEABLE OR WHETHER EITHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH LOSSES; AND 19.2. CENTRALSQUARE'S TOTAL LIABILITY ARISING OUT OF OR IN CONNECTION WITH THIS AGREEMENT SHALL NOT EXCEED THE AMOUNT(S) ACTUALLY PAID BY CUSTOMER TO CENTRALSQUARE HEREUNDER FOR THE LAST TWELVE (12) MONTHS PRIOR TO THE DATE THE CLAIM AROSE. 20. Insurance. During the term of this Agreement, CentralSquare shall maintain insurance coverage covering its operations in accordance with Exhibit 4 and Insurance Schedule K (Certificate of Insurance (Evidence of Coverage)). CentralSquare shall include Customer as an additional insured on applicable insurance policies Page 517 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 provided under this Agreement. CentralSquare shall provide proof of current coverage during the term of this Agreement. 21. Third -Party Materials. CentralSquare may, from time to time, include third parties to perform services, provide software, or provide equipment. Customer acknowledges and agrees CentralSquare provides front-line support services for these Third -Party Materials, but these third parties assume all responsibility and liability in connection with the Third -Party Materials. CentralSquare is not authorized to make any representations or warranties that are binding upon the third -party or to engage in any other acts that are binding upon the third -party, except specifically that CentralSquare is authorized to represent third -party fees and to accept payment of such amounts from Customer on behalf of the third -party for as long as such third -party authorizes CentralSquare to do so. As a condition precedent to installing or accessing certain Third -Party Materials, Customer may be required to execute a click -through, shrink-wrap End User License Agreement ("EULA") or similar agreement provided by the Third - Party Materials provider. If mapping information is supplied with the CentralSquare Software, CentralSquare makes no representation or warranty as to the completeness or accuracy of the mapping data provided with the CentralSquare Software. The completeness or accuracy of such data is solely dependent on the information supplied by the Customer or the mapping database vendor to CentralSquare. All third -party materials are provided "as -is" and any representation or warranty concerning them is strictly between Customer and the third -party. 22. Subcontractors. CentralSquare may from time to time, in its discretion, and at its sole cost, engage third parties to perform services on its behalf including but not limited to Professional Services, Support Services, and/or provide software (each, a "Subcontractor"). CentralSquare shall be fully responsible for the acts of all subcontractors to the same extent it is responsible for the acts of its own employees. 23. Entire Agreement. This Agreement, and any Exhibits specifically incorporated therein by reference, constitute the entire agreement between the Parties with respect to the subject matter. These documents supersede and merge all previous and contemporaneous proposals of sale, communications, representations, understandings and agreements, whether oral or written, between the Parties with respect to the subject hereof. 24. Amendment. Either Party may, at any time during the term, request in writing changes to this agreement. The Parties shall evaluate and, if agreed, implement all such requested changes. No requested changes will be effective unless and until memorialized in either a CentralSquare issued add -on quote signed by Customer, or a written change order or amendment to this Agreement signed by both Parties. 25. No Third -Party Beneficiaries. This Agreement is for the sole benefit of the Parties and their respective successors and permitted assigns and nothing herein, express or implied, is intended to or shall confer on any other person any legal or equitable right, benefit, or remedy of any nature under or by reason of this Agreement. 26. Counterparts. This Agreement, and any amendments hereto, may be executed in several counterparts, each of which when so executed shall be deemed to be an original, and such counterparts shall constitute one and the same instrument. The Agreement (and any amendments) shall be considered properly executed by a Party if executed by that Party and transmitted by facsimile or other electronic means, such as DocuSign, Tagged Image Format Files (TIFF), or Portable Document Format (PDF). 27. Material Adverse Change. If any law, regulation, applicable standard, process, OEM requirement is changed or comes into force after the Effective Date, including but not limited to PCI standards or Americans with Disabilities Act compliance (collectively, a "Material Adverse Change"), which is not explicitly addressed within this Agreement and results in significant extra costs for either Party in relation to the performance of this Agreement, both Parties shall promptly meet, discuss in good faith, and agree upon reducing the technical, operational, and/or commercial impact of such Material Adverse Change. 28. Cooperative Purchases. This Agreement may be used by Customer Affiliates. CentralSquare agrees to offer similar services to other Affiliates under the same terms and conditions as stated herein except that the Fees may be negotiated between CentralSquare and other Affiliates based on the specific revenue expectations, agency reimbursed costs, and other Affiliate requirements. The Customer will in no way whatsoever incur any liability in relation to specifications, delivery, payment, or any other aspect of purchases by such Affiliates. CentralSquare and the Affiliate will enter into any such arrangement with an amendment to this Agreement. 29. Order of Precedence. Page 518 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 29.1. In the event of any conflict or inconsistency between this Agreement, the Exhibits, or any purchase order, then the following priority shall prevail: 29.1.1. The main body of this Agreement and any associated amendments, statements of work (including Exhibit 5 (Statement of Work)), or change orders and then the attached Exhibits to this Agreement in the order in which they appear. 29.2. Customer's purchase terms and conditions or CentralSquare's sales terms and conditions are not applicable and shall have no force or effect, whether referenced in any document in relation to this Agreement. 29.3. Incorporated Exhibits to this Agreement: Exhibit 1: Solution(s) and Services Fee Schedule Exhibit 2: Maintenance & Support Exhibit 3: CentralSquare Access Management Policy Exhibit 4: Insurance Schedule K Exhibit 5: Statement of Work Exhibit 6: Using/Accessing Agency Guidelines Exhibit 7: Service Level Commitments Exhibit 8: Third -Party Terms and Conditions (if applicable) Page 519 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 EXHIBIT 1 Solution(s) and Services Fee Schedule Quote #: Q-147017 WHAT SOFTWARE IS INCLUDED? CAD PRODUCT NAME QUANTITY UNIT PRICE TOTAL 1. CentralSquare Message Switch (OP) 1 9,500.00 9,500.00 Annual Subscription Fee 2. Enterprise CAD Archive Server 1 1,100.00 1,100.00 Software (OP) Annual Subscription Fee 3. Enterprise CAD Disaster Recovery 1 2,500.00 2,500.00 System (OP) Annual Subscription Fee 4. Enterprise CAD GISLink Utility Position 1 2,200.00 2,200.00 (OP) Annual Subscription Fee 5. Enterprise CAD Mapping (OP) Annual 10 200.00 2,000.00 Subscription Fee 6. Enterprise CAD Mapping Test or 2 200.00 400.00 Training (OP) Annual Subscription Fee 7. Enterprise CAD Position (OP) Annual 1 4,300.00 4,300.00 Subscription Fee 8. Enterprise CAD Routing Server - 1 1,300.00 1,300.00 Disaster Recovery (OP) Annual Subscription Fee 9. Enterprise CAD Routing Server - Test 1 1,300.00 1,300.00 or Trn. System (OP) Annual Subscription Fee 10. Enterprise CAD Routing Server (OP) 1 8,100.00 8,100.00 Annual Subscription Fee 11. Enterprise CAD Server Software (OP) 1 13,000.00 13,000.00 Annual Subscription Fee 12. Enterprise CAD Situational Awareness 1 4,300.00 4,300.00 Manager (SAM) (OP) Annual Subscription Fee 13. Enterprise CAD Test or Training System 1 2,500.00 2,500.00 (OP) Annual Subscription Fee 14. NCIC/State Query Position for 10 200.00 2,000.00 Enterprise CAD (OP) Annual Subscription Fee Page 520 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 CAD Software Total 54,500.00 USD CAD INTERFACES PRODUCT NAME QUANTITY UNIT PRICE TOTAL 15. Enterprise CAD Axon Evidence.com 1 4,700.00 4,700.00 Data Extract (OP) Annual Subscription Fee 16. Standard Alpha Numeric Paging 1 3,900.00 3,900.00 Interface (OP) Annual Subscription Fee 17. Standard ANI/ALI Interface (OP) Annual 1 3,900.00 3,900.00 Subscription Fee 18. Standard EMD Integration (OP) Annual 1 200.00 200.00 Subscription Fee 19. Standard Smart911 Interface (OP) 1 6,500.00 6,500.00 Annual Subscription Fee 20. Standard Station Alert/Printing (Rip- 1 13,000.00 13,000.00 and -Run) (OP) Annual Subscription Fee 21. Std Enterprise CAD to External Incident 1 6,500.00 6,500.00 Data Transfer (OP) Annual Subscription Fee 22. Std Enterprise CAD to External Incident 1 6,500.00 6,500.00 Data Transfer (OP) Annual Subscription Fee CAD Interfaces Software Total 45,200.00 USD CRIMEVIEW PRODUCT NAME QUANTITY UNIT PRICE 23. CrimeView Analytics: Informative (3 1 3,350.00 years data) CST System Subscription 24. CrimeView Analytics: Standard (3 years 1 3,125.00 data) CST System Subscription TOTAL 3,350.00 3,125.00 CrimeView Software Total 6,475.00 USD HARDWARE PRODUCT NAME QUANTITY UNIT PRICE TOTAL 25. eGroup Miscellaneous Software 1 359,736.62 359,736.62 License Fee Hardware Software Total 359,736.62 USD JMS PRODUCT NAME QUANTITY UNIT PRICE 26. Enterprise Jail Advanced (Agency Site 1 2,694.20 License) Annual Subscription Fee TOTAL 2,694.20 Page 521 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 27. Enterprise Jail Core (Agency Site 1 8,080.70 8,080.70 License) Annual Subscription Fee 28. Enterprise Jail Core Annual 1 6,480.65 6,480.65 Subscription Fee 29. Enterprise Jail Financial Core (Agency 1 0.00 0.00 Site License) Annual Subscription Fee 30. Enterprise Jail Financial Core Annual 1 0.00 0.00 Subscription Fee 31. Enterprise Jail NDEx Adapter (IB IEPD) 1 0.00 0.00 Annual Subscription Fee 32. Enterprise Jail Personnel Core (Agency 1 0.00 0.00 Site License) Annual Subscription Fee 33. Enterprise Jail Personnel Core Annual 1 0.00 0.00 Subscription Fee 34. Enterprise Jail Reporting Core Annual 1 0.00 0.00 Subscription Fee 35. Enterprise Jail Reporting Universal 1 0.00 0.00 Interface Engine Annual Subscription Fee 36. Enterprise Jail Time Synchronization 1 0.00 0.00 Interface Annual Subscription Fee JMS Software Total 17,255.55 USD JMS INTERFACES PRODUCT NAME QUANTITY UNIT PRICE TOTAL 37. Enterprise Jail Commissary Interface 1 1,927.96 1,927.96 (Export) Annual Subscription Fee 38. Enterprise Jail Guardl Interface (Import 1 5,891.50 5,891.50 and Export) Annual Subscription Fee 39. Enterprise Jail Inmate Phone Interface 1 1,927.96 1,927.96 (Export) Annual Subscription Fee 40. Enterprise Jail LiveScan/AFIS Interface 1 2,559.80 2,559.80 (Export) Annual Subscription Fee 41. Enterprise Jail VINE Interface (Export) 1 1,927.96 1,927.96 Annual Subscription Fee JMS Interfaces Software Total 14,235.18 USD MOBILE PRODUCT NAME QUANTITY UNIT PRICE TOTAL 42. Enterprise Mobile Base Position (OP) 18 300.00 5,400.00 Annual Subscription Fee 43. Enterprise Mobile Base Position w/ 125 400.00 50,000.00 CJIS/NCIC Forms (OP) Annual Subscription Fee 44. Enterprise Mobile Disaster Recovery 1 2,300.00 2,300.00 System (OP) Annual Subscription Fee Page 522 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 45. Enterprise Mobile Mapping (OP) Annual 143 100.00 14,300.00 Subscription Fee 46. Enterprise Mobile Mapping Test or 1 100.00 100.00 Training (OP) Annual Subscription Fee Mobile Software Total 93,800.00 USD RMS PRODUCT NAME QUANTITY UNIT PRICE TOTAL 49. CentralSquare Message Switch (OP) 1 9,500.00 9,500.00 Annual Subscription Fee 50. Enterprise RMS Accident (OP) Annual 1 5,600.00 5,600.00 Subscription Fee 51. Enterprise RMS Concurrent User 80 600.00 48,000.00 License (OP) Annual Subscription Fee 52. Enterprise RMS Disaster Recovery 1 1,700.00 1,700.00 System (OP) Annual Subscription Fee 53. Enterprise RMS Evidence and 1 5,600.00 5,600.00 Barcoding (OP) Annual Subscription Fee 54. Enterprise RMS GIS (With CAD) (OP) 1 0.00 0.00 Annual Subscription Fee 55. Enterprise RMS NIBRS Module (OP) 1 10,800.00 10,800.00 Annual Subscription 56. Enterprise RMS Reporting Server 1 1,100.00 1,100.00 License (OP) Annual Subscription Fee 57. Enterprise RMS Server Software (OP) 1 15,100.00 15,100.00 Annual Subscription Fee 58. Enterprise RMS Test or Training 1 1,700.00 1,700.00 System (OP) Annual Subscription Fee 59. NCIC/State Software Enterprise RMS 8 200.00 1,600.00 Concurrent User (OP) Annual Subscription Fee 60. Public Safety Citizen Reporting Annual 1 5,000.00 5,000.00 Subscription Fee RMS Software Total 105,700.00 USD RMS INTERFACES PRODUCT NAME QUANTITY UNIT PRICE TOTAL 61. Standard Axon Evidence.com 1 4,100.00 4,100.00 Integration (OP) Annual Subscription Fee 62. Standard BEAST Evidence Importer 1 5,500.00 5,500.00 (OP) Annual Subscription Fee 63. Standard BEAST Evidence Publisher 1 4,100.00 4,100.00 (OP) Annual Subscription Fee RMS Interfaces Software Total 13,700.00 USD Page 523 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 SOFTWARE SUMMARY Software Total 710,602.35 USD WHAT SERVICES ARE INCLUDED? HARDWARE DESCRIPTION TOTAL 1. eGroup Installation Services - Fixed Fee 48,800.00 Hardware Services Total 48,800.00 USD SERVICES DESCRIPTION TOTAL 2. Public Safety Consulting Services - Fixed Fee 173,160.00 3. Public Safety Data Conversion Services - Fixed Fee 242,385.00 4. Public Safety GIS/Analytics Services - Fixed Fee 59,280.00 5. Public Safety Project Management Services - Fixed Fee 142,935.00 6. Public Safety Technical Services - Fixed Fee 161,070.00 7. Public Safety Training Services - Fixed Fee 40,365.00 8. Public Safety Travel & Living Expenses Estimate 46,000.00 SERVICES SUMMARY WHAT HARDWARE IS INCLUDED? HARDWARE PRODUCT NAME 1. eGroup Miscellaneous Hardware 2. Shipping & Handling 3. System Integration Fee - HW Hardware Services Services Total 865,195.00 USD Services Total 913,995.00 USD QUANTITY UNIT PRICE TOTAL 1 252,646.01 252,646.01 1 5,052.92 5,052.92 1 99,177.39 99,177.39 Page 524 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Hardware Hardware Total 356,876.32 USD JMS HARDWARE PRODUCT NAME QUANTITY UNIT PRICE TOTAL 4. Enterprise Jail Production Server Annual Subscription Fee 1 9,548.79 9,548.79 5. Enterprise Jail Training/Testing Server Annual Subscription Fee 1 7,285.62 7,285.62 6. Enterprise Jail Warm Standby Server Annual Subscription Fee 1 8,672.03 8,672.03 HARDWARE SUMMARY QUOTE SUMMARY JMS Hardware Hardware Total 25,506.44 USD Hardware Total 382,382.76 USD Software Subtotal Services Subtotal Hardware Subtotal 710,602.35 USD 913,995.00 USD 382,382.76 USD Page 525 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 WHAT ARE THE RECURRING FEES? Quote Subtotal 2,006,980.11 USD Quote Total 2,006,980.11 USD TYPE AMOUNT FIRST YEAR MAINTENANCE TOTAL 0.00 FIRST YEAR SUBSCRIPTION TOTAL 376,372.17 FIRST YEAR RECURRING SERVICES TOTAL The amount totals for Maintenance and/or Subscription on this quote include only the first year of software use and maintenance. Renewal invoices will include this total plus any applicable uplift amount as outlined in the relevant purchase agreement. PAYMENT TERMS Travel & Living Expenses - Due as Incurred Page 526 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Payment Terms: Subscriptions: - If applicable, Annual Subscription Fees are due on the Delivery Date, and annually thereafter on the anniversary of the Delivery Date. - Annual Subscription Fees shall increase by 5% each year. Services: Payment Schedule: Implementation Services 30% Due on Effective Date 20% Due at Project Kickoff 15% Due at completion of 1st End User Training Session 30% Due at Go Live 5% Due at completion of Reliability Period If applicable, non -fixed fee professional services shall be due as incurred on a time and materials basis. Non -fixed fee professional services are not included in the percentages outlined in the above Payment Schedule. - If applicable, non -fixed fee travel expenses shall be due as incurred, invoiced monthly for the travel expenses of the preceding month. Non -fixed fee travel expenses are not included in the percentages outlined in the above Payment Schedule. - If applicable, Fixed Fee travel expenses are included in the percentages outlined in the above Payment Schedule. Hardware: - If applicable, Non -subscription Hardware Fees are due on the Effective Date. Licenses: - If applicable, License Fees are due on the Delivery Date. Support & Maintenance - If applicable, Support & Maintenance Fees are due annually, starting prior to the first anniversary of the Delivery Date and annually thereafter. Annual Software Maintenance Fees shall increase by 5% each year. - If applicable, legacy support and maintenance shall be due until the Delivery Date of the applicable replacement software. Any unused pre -paid support and maintenance shall be credited as a pro -rated amount towards the next applicable subscription software invoice due under this Agreement, or future invoice. Third Party: - If applicable, Third -Party Software Fees are due on the Effective Date. Third -Party software subscriptions and/or support fees shall be due annually thereafter on the anniversary of the Effective Date. Third -Party Software fees are subject to increase each year. - If applicable, Third -Party Services shall be due 50% at Effective Date, 25% at completion of 1st End User Training Session, and 25% at Go Live. Page 527 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Invoice Terms: CentralSquare shall provide an invoice for the items in the schedule above no less than thirty (30) days prior to the due date. ANCILLARY FEES a. Customer is responsible for paying all taxes relating to this Agreement. Applicable tax amounts (if any) are not included in the fees set forth in this Agreement. If Customer is exempt from the payment of any such taxes, Customer must provide CentralSquare valid proof of exemption; otherwise, CentralSquare will invoice Customer and Customer will pay to CentralSquare all such tax amounts. b. To the extent allowable by law, if Customer fails to make any payment when due, then CentralSquare may charge interest on the past due amount at the rate of 1.5% per month calculated daily and compounded monthly, or, if lower, the highest rate permitted under applicable law; and if such failure continues for 90 days following written notice thereof, CentralSquare may suspend performance or access until past due amounts have been paid. Page 528 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 EXHIBIT 2 Maintenance & Support This Maintenance & Support Exhibit describes support and maintenance relating to technical support that CentralSquare will provide to Customer during the Term of the Agreement. 1. Product Updates and Releases 1.1. Software Version. "Software Version" means the base or core version of the Software that contains significant new features and significant fixes and is available to the Customer. Software Versions may occur as the Software architecture changes or as new technologies are developed. The nomenclature used for updates and upgrades consists of major, minor, build, and fix and these correspond to the following digit locations of a release, a,b,c,d. An example of which would be 7.4.1.3, where the 7 refers to the major release, the 4 refers to the minor release, the 1 refers to the build, and the 3 refers to a fix. All Software Versions are provided and included as part of this Agreement. 1.2. Updates. From time to time CentralSquare may develop permanent fixes or solutions to known problems or bugs in the Software and incorporate them in a formal "Update" to the Software. If Customer is receiving technical support from CentralSquare on the general release date for an Update, CentralSquare will provide the Customer with the Update and related Documentation at no extra charge. Updates for custom configurations will be agreed upon by the Parties and outlined in a Statement of Work or Change Order. 1.3. Releases. Customer shall agree to install and/or use any New or Major Release within one year of being made available by CentralSquare to avoid or mitigate a performance problem, ineligibility for Support and Maintenance Services or infringement claim. All modifications, revisions and updates to the Software shall be furnished by means of new Releases of the Software and shall be accompanied by updates to the Documentation whenever CentralSquare determines, in its sole discretion, that such updates are necessary. 2. Support 2.1. CentralSquare shall provide to Customer support via toll -free phone number 833-278-7877 or via the CentralSquare Support Portal. CentralSquare shall provide to Customer, commercially reasonable efforts in solving errors reported by the Customer as well as making available an online support portal. Customer shall provide to CentralSquare reasonably detailed documentation and explanation, together with underlying data, to substantiate errors and to assist CentralSquare in its efforts to diagnose, reproduce and correct the error. Should either Party not be able to locate the error root cause and Customer and CentralSquare agree that on - site services are necessary to diagnose or resolve the problem CentralSquare shall provide a travel estimate and estimated hours in order to diagnose the reported error. 2.2. If after traveling onsite to diagnose a reported error and such reported error did not, in fact, exist or was not attributable to a defect in the Software provided by CentralSquare or an act or omission of CentralSquare, then Customer shall pay for CentralSquare's investigation, travel, and related services in accordance with provided estimate. Customer must provide CentralSquare with such facilities, equipment and support as are reasonably necessary for CentralSquare to perform its obligations under this Exhibit, including remote access in accordance with the Remote Access Policy. 3. Online Support Portal Online support is available via https://support.centralsquare.com/s/contact-us, offering Customer the ability to resolve its own problems with access to CentralSquare's most current information. Customer will need to enter its designated username and password to gain access to the technical support areas on CentralSquare's website. CentralSquare's technical support areas allow Customer to: (i) search an up-to-date knowledge base of technical support information, technical tips, and featured functions; and (ii) access answers to frequently asked questions (FAQ). 4. Exclusions from Technical Support Services CentralSquare shall have no support obligations to provide Support or Maintenance for Solutions that are not kept current to one version prior to the then current version of the Solution. CentralSquare shall have no support obligations with respect to any third -party hardware or software product not licensed or sold to Customer Page 529 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 by CentralSquare ("Nonqualified Product"). Customer shall be solely responsible for the compatibility and functioning of Nonqualified Products with the Software. 5. Customer Responsibilities In connection with CentralSquare's provision of technical support as described herein, Customer acknowledges that Customer has the responsibility to do each of the following: 5.1 Provide hardware, operating system and browser software that meets technical specifications, as well as a fast, stable, high-speed connection and remote connectivity for accessing the Solution. 5.2 Maintain any applicable computer system and associated peripheral equipment in good working order in accordance with the manufacturers' specifications, and ensure that any problems reported to CentralSquare are not due to hardware malfunction; 5.3 For CentralSquare Solutions that are implemented on Customer Systems, maintain the designated operating system at the latest code revision level reasonably deemed necessary by CentralSquare for proper operation of the Software; 5.4 Supply CentralSquare with access to and use of all information and facilities reasonably determined to be necessary by CentralSquare to render the technical support described herein; 5.5 Perform any test or procedures reasonably recommended by CentralSquare for the purpose of identifying and/or resolving any problems; 5.6 At all times follow routine operator procedures as specified in the Documentation or any error correction guidelines of CentralSquare posted on the CentralSquare website; 5.7 Customer shall remain solely responsible at all times for the safeguarding of Customer's proprietary, confidential, and classified information contained within Customer Systems; and 5.8 Reasonably ensure that the Customer Systems are isolated and free from viruses and malicious code that could cause harm before requesting or receiving remote support assistance. 6. priorities and Support Response Matrix The following priority matrix relates to software errors covered by this Agreement. Causes secondary to non - covered causes - such as hardware, network, and third -party products - are not included in this priority matrix and are outside the scope of this Exhibit. CentralSquare will make commercially reasonable efforts to respond to Software incidents for live remote based production systems using the following guidelines: Priority Issue Definition Response Time Priority 1 — Urgent The software is completely down and will not launch or function. Priority 1 issues must be called in via 833-278-7877 and will be immediately answered and managed by the first available representative. Priority 2 — Critical A high -impact problem that disrupts the customer's operation but there is capacity to remain productive and maintain necessary operations. Priority 2 issues must be called in via 833-278-7877 and will be immediately answered and managed by the first available representative. Priority 3 — Non -Critical A Software Error related to a user function which does not negatively impact the User from the use of the system. This includes system administrator functions or restriction of user workflow but does not significantly impact their job function. Priority 3 issues called in via 833-278-7877 will be immediately answered and managed by the first available representative. Non -Critical Priority 3 issues may also be reported via Https://support.centralsquare.com/s/contact-us Page 530 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Priority 4 — Minor Cosmetic or documentation errors, including Customer technical questions or usability questions. Priority 4 issues called in via 833-278-7877 will be immediately answered and managed by the first available representative. Minor Priority 4 issues may also be reported via Https://support.centralsquare.com/s/contact-us 7. Exceptions. CentralSquare shall not be responsible for failure to carry out its Support and Maintenance obligations under this Exhibit if the failure is caused by adverse impact due to: 7.1. defectiveness of the Customer's Systems (including but not limited to environment, hardware or ancillary systems), or due to Customer corrupt, incomplete, or inaccurate data reported to the Solution, or documented defect. 7.2. denial of reasonable access to Customer's System or premises preventing CentralSquare from addressing the issue. 7.3. material changes made to the usage of the Solution by Customer where CentralSquare has not agreed to such changes in advance and in writing or the modification or alteration, in any way, by Customer or its subcontractors, of communications links necessary to the proper performance of the Solution. 7.4. a Force Majeure event (as outlined in Section 12), or the negligence, intentional acts, or omissions of Customer or its agents. 8. Incident Resolution. Actual response times and resolutions may vary due to issue complexity and priority. For critical impact level and above, CentralSquare provides a continuous resolution effort until the issue is resolved. CentralSquare will make commercially reasonable efforts to resolve Software incidents for live remote based production systems using the following guidelines: Priority Resolution Process Resolution Time Priority 1 — Urgent CentralSquare will provide a CentralSquare will work continuously to provide the procedural or configuration Customer with a solution that allows the Customer to workaround or a code correction resume live operations on the production system. that allows the Customer to CentralSquare will either resolve the issue or provide a resume live operations on the resolution plan as soon as possible and not later than production System. twenty-four (24) hours after notification. Priority 2 — CentralSquare will provide a CentralSquare will work continuously to provide the procedural or configuration Customer with a solution that allows the Customer to Critical workaround or a code correction that allows the Customer to resume normal operations on the production System. resume normal operations on the CentralSquare will either resolve the issue or provide a production System. resolution plan as soon as possible and not later than thirty-six (36) hours after notification. Page 531 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Priority 3 — Non — CentralSquare will provide a CentralSquare will work to provide the Customer with a Critical procedural or configuration resolution which may include a workaround or code workaround that allows the correction within a timeframe that takes into Customer to resolve the problem. consideration the impact of the issue on the Customer and CentralSquare's User base. Priority 3 issues have priority scheduling in a subsequent release. Priority 4 — Minor If CentralSquare determines CentralSquare will work to provide the Customer with a that a reported Minor Priority resolution which may include a workaround or code error requires a code correction in a future release of the software. Priority 4 correction, such issues will be addressed in a subsequent release when applicable. issues have no defined resolution time. 9. Non -Production Environments. CentralSquare will make commercially reasonable efforts to provide fixes to non -production environment(s). Non -production environments are not included under the response or resolution tables provided in this Exhibit. 9.1. Maintenance. All non -production environment resolution processes will follow the structure and schedules outlined above for production environments. 9.2. Incidents and service requests. Non -production environment incidents are considered priority 3 or 4, dictated by circumstances and will be prioritized and scheduled subordinate to production environment service requests. 10. Training. Outside the scope of training services purchased, if any, Customer is responsible for the training and organization of its staff in the operation of the Software. 11. Development Work. Software support and maintenance does not include development work either (i) on software not licensed from CentralSquare or (ii) development work for enhancements or features that are outside the documented functionality of the Software, except such work as may be specifically purchased and outlined in the Agreement. CentralSquare retains all intellectual property rights in development work performed and Customer may request consulting and development work from CentralSquare as a separate billable service. 12. Technology Life Expectancy. Customer understands, acknowledges and agrees that the technology upon which the Hardware, Solution and Third -Party Software is based changes rapidly. Customer further acknowledges that CentralSquare will continue to improve the functionality and features of the Solution to improve legal compliance, accuracy, functionality and usability. As a result, CentralSquare does not represent or warrant that the Hardware, Solution and/or Third -Party Software provided to Customer under this Agreement or that the Customer Systems recommended by CentralSquare will function for an indefinite period of time. Rather, CentralSquare and Customer may, from time to time, analyze the functionality of the Hardware, Solution, Third -Party Software and Customer Systems in response to changes to determine whether Customer must upgrade the same. Customer upgrades may include without limitation, the installation of a new Release, additional disk storage and memory, and workstation and/or server upgrades. Customer upgrades may also include the installation and/or removal of Third - Party Software. Customer is solely responsible for all costs associated with future resources and upgrades. Page 532 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 EXHIBIT 3 CentralSquare Access Management Policy In order to provide secure, federally compliant connections to agency systems CentralSquare Technologies ("CentralSquare") requires BeyondTrust or SecureLink as the only approved methodology of connection. BeyondTrust and Securelink provide the necessary remote access in order to service and maintain CentralSquare products while adhering to the Federal Bureau of Investigations Criminal Justice Information Services requirements. Both solutions utilize two -factor authentication Federal Information Processing Standard Publication ("FIPS") 140- 2 validated cryptographic modules and AES encryption in 256-bit strengths. BeyondTrust and Securelink are addressed in turn via this Access Management Policy; Customers may choose which remote privileged access management solution will be utilized by CentralSquare. BeyondTrust The BeyondTrust remote support solution may be utilized via escorted session or a jump Customer. As for an escorted session, when an agency needs assistance from CentralSquare, the agency employee requesting assistance will receive verbal or email communication with a session key necessary to enable remote access. If a verbal key is provided, the user enters the session key after visiting https://securesupport.centralsquare.com. Jump Customers are a Windows service that can be stopped/started to facilitate a support session. Connections made via jump Customer can be active or passive. An active jump Customer is always available. A passive connection is enabled for a specific purpose and then disabled when not used. Regardless of the option selected, CentralSquare's support team will arrange a BeyondTrust session to establish the jump Customer. The jump Customer resides on the agency side on the installed device, where an agency administrator can manage. Instructions on how to enable/disable jump Customers can be provided upon request. A sample workflow of a passive jump Customer is provided below: Should an agency require support from CentralSquare, a call would be placed and/or a support ticket opened in the portal on the CentralSquare customer support website. Before accessing the agency's system and/or environment, the CentralSquare representative would send a notice of connection from the CentralSquare support portal instance. This notice can be sent to the individual at the agency that the CentralSquare representative is working with or other designated contacts as necessary. Upon receipt of the notice of connection, the agency personnel would enable the BeyondTrust jump Customer. The CentralSquare representative would then be admitted to the agency's system and/or environment to perform the necessary task. Upon completion of the task, the CentralSquare representative sends a notice of disconnection from the CentralSquare support portal instance. Upon receipt of the notice of disconnection, the agency personnel would then disable the BeyondTrust jump Customer. Securelink Similar to BeyondTrust's escorted session, Securelink may be utilized via "quick connect". To enable a quick connect session when an agency needs assistance from CentralSquare, the Agency employee requesting assistance will enter a key code in order to connect for screen sharing on a device. Similar to the jump Customer methodology, SecureLink may also be utilized via "gatekeeper". The sample workflow description for a jump Customer provided above is substantially similar to the workflow for gatekeeper. Summation BeyondTrust and Securelink allow customers the ability to monitor connectivity to the customer's network and maintain CJIS compliance while enabling CentralSquare to perform the necessary support functions. Page 533 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 EXHIBIT 4 Insurance Schedule K INSURANCE SCHEDULE K 1 CentralSquare shall furnish annually a signed Certificate of Insurance to the City of Dubuque, Iowa for the coverage required in Exhibit I prior to commencing work and at the end of the project if the term of work is longer than 60 days. Providers presenting annual certificates shall present a Certificate at the end ofea h project with the final billing. Each Certificate shall be prepared on the most current ACORD form approved by the Iowa Department of Insurance or an equivalent. Each certificate shall include a statement under Description of Operations as to why issued. E.g. Agreement dated 2. authorized to do business in Iowa and all carriers shall have a rating of A- or better in the current A.M. Best's Rating Guide. 3. Each Certificate shall be furnished to the Finance department of the City of Dubuque. 4. Failure to provide minimum coverage shall not be deemed a waiver of these requirements by the City of Dubuque. Failure to obtain or maintain the required insurance shall be considered a material breach of this agreement 5. Contractor shall require all subcontractors and sub -subcontractors to obtain and maintain during the performance of work insurance for the coverages described in this Insurance Schedule and shall obtain certificates of insurances from all such subcontractors and sub -subcontractors. Contractoragrees that it shall be liablefor the failure of a subcontractor and sub - subcontractor to obtain and maintain such coverages. The City may request a copy of such certificates from the Contractor. 6. All required endorsements shall be attached to the certificate. The certificate is due before the contract/agreement can be approved. 7. Whenever a specific ISO form is listed, an equivalent form may be substituted subject to the provider identifying and listing in writing all deviations and exclusions that differ from the ISO form. 8. Provider shall be required to carry the minimum coverage/limits, or greater if required by law or other legal agreement, in Exhibit I. If provider's limits of liability are higher than the required minimum limits then the provider's limits shall be this agreement's required limits. 9. Whenever an ISO form is referenced the current edition of the form must be used. 10. Contractor shall be responsible for deductibles and self -insured retention for payment of all policy premiums and other cost associated with the insurance policies required below. 11. All certificates of insurance must include agents name, phone number, and email address. 12. The City of Dubuque reserves the right to modify these requirements, including limits, based on changes in the risk or other special circumstances during the term of the agreement, subject to mutual agreement of the parties. Page 534 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 INSURANCE SCHEDULE K (continued) Jibit I A) TECHNOLOGY PROFESSIONAL LIABILITY $5,000,000 • _Yes No Coverage to include: 1) Errors and omissions, lost data and restoration and damages arising from incidents resulting from a failure of computer security to prevent a security breach. 2) Libel. slander. defamation, product disparagement, false arrest, detention, imprisonment, invasion of, or interference with right of privacy, plagiarism, piracy, misappropriation of name or idea, trespass, dilution or infringement of copyright, title, slogan, trademark, trade name, trade dress, logo, service mark or service name, and infliction of mental or emotion illness, anguish injury or distress from the incidences mentioned here in. 3) The unauthorized taking or use or unintentional disclosure of Personally Identifiable Information or a confidential and proprietary business trade secret. 4) The unintentional failure to timely disclosed an unauthorized taking or use or disclosure of Personally Identifiable Information in violation ofany Breach Notification law. 5) The unintentional violation of the named insured's privacy policy that directly results in a violation of any privacy law. a) Provide evidence of coverage for 3 years after completion of project B) CYBER LIABILITY/DATA BREACH $5,000,000 Coverage for First- and Third -Party liability including by not limited to lost data and restoration, loss of income and cyber breach. (DEPARTMENT MANAGER: FILL IN ALL BLANKS AND CHECK BOXES) 07312024ba I CST-2024-101831 Page 535 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 EXHIBIT 5 Statement of Work (Attached) 07312024ba I CST-2024-101831 Page 536 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1 E0 F,; CENTRALSQUARE STATEMENT OF WORK PSJ - Enterprise Dubuque Yll, lA 11 Version 10.0 1000 Business Center Drive, Lake Mary, FL 32746 407.304.3235 I Fax: 407.304.3301 I www.centralsquare.com Page 537 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 © 2024 CentralSquare Technologies, LLC Unpublished: Rights reserved under the copyright laws of the United States. All information in this document is proprietary and confidential and owned by CentralSquare Technologies, LLCTM. No part of this document may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of CentralSquare Technologies, LLC. Trademarks Microsoft, Windows, Microsoft Access, Microsoft Excel, Microsoft Exchange, and Microsoft Word are either registered trademarks or trademarks of Microsoft Corporation in the United States and other countries. CentralSquare Public Safety Suite — Enterprise, CentralSquare CAD Enterprise, CentralSquare Mobile Enterprise, CentralSquare Records Enterprise, CentralSquare Jail Enterprise, CentralSquare False Alarm Management, and CentralSquare Public Safety Analytics Enterprise are trademarks of CentralSquare Technologies, LLC. ArcGIS, ArcMap and ArcCatalog are registered trademarks of Environmental Systems Research Institute (Esri) in the United States and other countries. External Version - Document Control Date Version Details/Changes 4-16-24 1 Initial SOW Ann Marie Newton 4-30-24 2 1)- Section 4.2/System Installation: Added in sections that are applicable to client providing their own hardware, rather than CST. 2)- Section 4.2.5.2: Moved CentralSquare Responsibilities to come before Customer Responsibilities. 3)- Section 4.5.2: Added MobileX Enterprise Configuration. 4)- Section 4.6.2: Added Records Enterprise Pre -Configuration and Review. 5)- Section 4.7.2/Jail Admin: Changed one instance of Jail 6 to Jail Enterprise. 6)- Section 4.7.2/Jail Admin: Duration- Added 'contingent upon Jail modules'. 7)- Section 4.7.4/Jail FAT: Duration- Changed to 'As noted in Appendix Y — Workshop and Training Summary'. 8)- Section 4.7.6/Jail End User Training: Duration- Changed to 'As noted in Appendix Y — Workshop and Training Summary'. 9)- Section 4.7.7/Jail Reports Training: Duration- Changed to 'As noted in Appendix Y — Workshop and Training Summary'. Ann Marie Newton The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page ii Page 538 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 10)- Section 8.1: Removed 'Customer Success Manager (CSM)' and replaced with 'Support'. 11)-Appendix B: Accepted client redline 'Comtech'. 12)- Appendix B: Vendor field, removed 'RapidSOS from Rave Smart911'. 13)- Appendix B: Added CAD RapidSOS interface. 14)- Appendix B: Inserted interface document name for TraCS Citation and Crash Import interface, noted that we need to remove 'Black Hawk ' from the OSD. 15)- Appendix B: Added RMS Beast Evidence, Mugshot Importer, Axon Evidence.com Link interfaces. 16)- Appendix C: Go -Live Requirement: Added a note 'Custom interfaces are typically delivered post go -live, development would not start until a contract is executed. Made Product Management aware that interface is desired for go -live. Added that Raycom is their vendor. 17)- Appendix D: Added Jail Enterprise Provider. Changed 'Customer Providers' to 'Custom Provider'. 18)- Appendix E: Added language for inclusion of Subcontractor SOW for White Box Technologies for data conversion. 19)- Appendix Y: Changed 'Records Enterprise Pre -Configuration Questionnaire' to 'Records Enterprise Pre -Configuration and Review'. Added a note that Civil and Warrants training is for the SO only. Added Jail Enterprise Administration and Review Workshop. Added Jail Enterprise Functional Acceptance Testing. Noted that Jail End User training needs to be changed to Train -the -Trainer, per client request. Added the CAD, Mobile, Records Enterprise System Administration Training class at 3 days, remote. 20)- Appendix Z: Deleted CentralSquare data conversion language for CAD and RMS. Added RMS and Jail modules desired for conversion per the 4-29-24 data conversion scoping call. Added table to capture Dyersville PD, IA data conversion modules. 4-30-24 3 Call with client on 4-30-24 to review all edits made in version 2. We accepted only 'minor' redlines changes (such as typos) as client would like an opportunity to review all changes. Ann Marie Newton 5-2-24 4 1)- Accepted all changes noted in version 2 dated 4-30-24. SOW redline review call with client on 5-2-24, reviewed items 2 — 6 below. 2)- Appendix B: Added Standard External to CAD Enterprise - Premise interface for vendor First Due. Added Standard CAD to External Incident Data Transfer for vendor Fire Recovery. EMD: Confirm PowerPhone or Pro QA. Client confirmed ProQA. Confirm if interested in PulsePoint. Added Jail Guard]. Interface. Ann Marie Newton The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page iii Page 539 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 3)- Appendix C: Go -Live Requirement: Customer requires the interface be available for Go -Live. Development work is contingent upon contract execution, Customer approved Operational Scenario Document (OSD), and scheduling of resources. Added clarifying comment that the OSD must be signed before interface development work begins. 4)- Appendix E: Deleted eGroup as a subcontractor. 5)- Appendix Y: Client confirmed that CST will provide Jail End User training, rather than train -the -trainer. 6)- Appendix Z: RMS DC: Client to confirm up to 10 years of historical data is to be converted. Client confirmed 10 years. Added 'Definition of Module' for the newly added modules. Follow up call is needed. 5-8-24 5 Call with client on 5-8-24 to review all edits made in version 5. 1)- Section 1.1: Added introductory paragraphs for client review. 2)- Section 4.2.5.4: Added a comment that client uses Dell- RecoverPoint. 3)- Section 4.4.3.2.2: Added Customer responsibility (bullet b) to provide ESRI ArcGIS Pro licenses, version 2.9. (Client has ESRI now). 4)- Section 4.7: Add Jail modules that are part of this contract: Advanced (site license), Core (site license), Financial Core (site license), Personnel Core (site license), Reporting Core. Add on Administration (Core) to quote. 5)- Appendix B: Instances Contracted- added 'Test/Train' for the CAD and RMS interfaces, except PulsePoint (SQL view). Noted to include the following CAD interfaces in the quote: Standard External to CAD Enterprise- Premise and also added vendor ESO, Standard CAD to External Incident Data Transfer- Fire Recovery, and PulsePoint. Station Alert interface- added a note that there are differences in functionality (OS and Enterprise), provided the ICD for client review. BEAST Evidence- per the RMS interface scoping call on 5-3, the decision was made to remove this interface as the client did not see value in it. Mugshot Importer: revisited this interface after the RMS interface scoping call and determined it is not needed. The integration between RMS and Jail does include mugshots. Jail Time Synchronization Interface- updated the interface description. Noted to include the Guardl interface. 6)- Appendix C: Changed Raycom to Racom. Added the Livescan/AFIS interface and the Axon Link for Jail Enterprise- both are under evaluation by CST. 7)- Appendix Z: RMS DC: Added 'Other Event' to Gang. Removed references to 'Other Events Module: Maximum twenty-five (25) fields. Per field pricing over twenty-five (25) fields'. Added notes Ann Marie Newton The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page iv Page 540 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 for the modules that were reviewed on the May 7 RMS DC follow up call. Confirmed that Gun is summaries only. Added Concealed/Carry Weapon (CCW) for conversion. Added Vendor name- Shield Technology Corporation. Added Dyersville modules for conversion. Jail DC: Noted that the Personnel Advanced module / functionality is required in order to convert Personnel (training, certifications, recommendations). 5-9-24 6 Accepted all redline edits and resolved comments per the review call with the client on 5-8-24. Ann Marie Newton 5-10-24 7 New redlines/comments for client review: 1)- Appendix B: Citation/Crash: Added a note that an updated OSD will be provided to client during their implementation. 2)- Appendix C: Added a comment that CST is to provide FDD (Functional Description Document) to client. 3)- Appendix E: Added language to reference Appendix Z for the data conversion SOW. 4)- Appendix F: Added a new Appendix F to capture misc hardware to be provided by CST: Jail Enterprise camera package, qty of 2 and Records Enterprise Zebra desktop printer, qty of 1). 5)- Re-evaluated and updated some of the workshops/training classes based on updated vitals from client. 6)- Appendix Z: Added White Box data conversion summary, roles/responsibilities, assumptions/constraints, estimated key project milestones, source systems, target systems, in scope services, and out of scope services. Added a comment on RMS Sex Offender that generation of alerts is still under review. System Receipt is an open item as well. Ann Marie Newton 5-16-24 8 1) Appendix Z: Removed Dyersville DC from scope 2) Appendix Y: Changed the hours of the Crimeview Admin class from 6 to 12 hours. 3) Appendix A: Added Receipts Feature development 4) Appendix C: Updated the language of the Mugshot Customization to the Jail Livescan interface 5) Appendix C: Removed the Custom Jail Axon Evidence.com Interface Will Hayashi 5-22-24 9 1)- Accepted changes noted in versions 7 - 8, resolved open comments. 2)- Removed the draft watermark, FINAL SOW. Ann Marie Newton 6-25-24 10 1)- Splitting out Test/Train into two (2) separate environments on the quote. 2)- Appendix B and Appendix C: Changed Test/Train to Test only. Ann Marie Newton The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page v Page 541 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page vi Page 542 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Table of Contents DUBUQUE PD, IA 1 1 OVERVIEW 1 1.1 STATEMENT OF WORK 1 1.2 PROJECT IMPLEMENTATION DEFINITIONS 2 1.3 GENERAL CUSTOMER RESPONSIBILITIES 4 1.4 PROJECT EXCLUSIONS 6 2 PROJECT CONTROLLING PROCESSES 7 2.1 OVERVIEW 7 2.1.1. CentralSquare Responsibilities 8 2.1.2. Customer Responsibilities 8 2.2 CHANGE ORDER PROCESS 8 2.2.1. CentralSquare Responsibilities 9 2.2.2. Customer Responsibilities 9 2.3 PROJECT REPORTING 9 2.3.1. CentralSquare Responsibilities 10 2.3.2. Customer Responsibilities 10 2.4 DOCUMENT REVIEW 10 2.4.1. Documents Subject to Customer Approval 11 2.5 DOCUMENTS SUBJECT TO CUSTOMER REVIEW NOT REQUIRING APPROVAL 11 2.5.1. CentralSquare Responsibilities 11 2.5.2. Customer Responsibilities 11 2.6 THIRD PARTY MANAGEMENT 11 2.6.1. CentralSquare Responsibilities 12 2.6.2. Customer Responsibilities 12 3 PROJECT INITIATION AND PLANNING 13 3.1 OVERVIEW 13 3.1.1. CentralSquare Responsibilities 13 3.1.2. Customer Responsibilities 14 3.2 PROJECT KICK OFF 14 3.2.1. The CentralSquare Execution Process 14 3.2.2. CentralSquare Responsibilities 14 3.2.3. Customer Responsibilities 15 4 PROJECT EXECUTION 16 4.1 OVERVIEW 16 4.2 SYSTEM INSTALLATION 16 4.2.2. Review Hardware Specifications (On -Premise Components) 17 The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page vii Page 543 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 4.2.3. Procurement\Allocation of Hardware and Third -party Software (On -Premise Components) 18 4.2.4. Basic Server Integration (On -Premise) 18 4.2.5. System Installation (On -Premise) 21 4.3 IMPLEMENTATION OF ENTERPRISE SYSTEM INTERFACES 26 4.3.1. Enterprise Standard Interfaces - Implementation Overview 26 4.3.2. Enterprise Custom Interfaces - Implementation Overview 29 4.4 IMPLEMENTATION OF CAD ENTERPRISE 34 4.4.1. CAD Enterprise Implementation Process Overview 34 4.4.2. CAD Enterprise Base System Build 34 4.4.3. Geographical Information Services 35 4.4.4. CAD Enterprise Workshops 38 4.4.5. CAD Enterprise Functional Acceptance Testing (FAT) 38 4.4.6. CAD Enterprise Training 40 4.5 IMPLEMENTATION OF MOBILE ENTERPRISE 42 4.5.1. Implementation Process Overview 42 4.5.2. MobileX Enterprise Configuration 42 4.5.3. Mobile Enterprise Functional Testing 43 4.5.4. Mobile Enterprise Training 45 4.6 IMPLEMENTATION OF RECORDS ENTERPRISE 46 4.6.1. Records Enterprise Implementation Process Overview 46 4.6.2. Records Enterprise Pre -Configuration and Review 46 4.6.3. Records Enterprise Base System Build 47 4.6.4. Geographical Information Services 48 4.6.5. Records Enterprise Workshops 49 4.6.6. Records Enterprise Functional Acceptance Testing 50 4.6.7. Records Enterprise Training 52 4.7 IMPLEMENTATION OF JAIL ENTERPRISE 53 4.7.1. Jail Enterprise Implementation Process Overview 54 4.7.2. Jail Enterprise Administration and Review Workshop 55 4.7.3. Jail Enterprise Base System Build 56 4.7.4. Jail Enterprise Functional Acceptance Testing 57 4.7.5. Jail Enterprise Training 59 4.7.6. Jail Enterprise End User Training 60 4.7.7. Jail Enterprise Report Generation Training 61 4.8 IMPLEMENTATION OF COMMON IDENTITY MANAGEMENT (CIM) 62 4.8.1. CIM Configuration 62 4.9 SYSTEM INTEGRATION TESTING 64 4.9.1. CentralSquare Responsibilities 64 4.9.2. Customer Responsibilities 65 4.10 IMPLEMENTATION OF CITIZEN REPORTING 66 4.10.1. Citizen Reporting Implementation Process Overview 66 The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page viii Page 544 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 4.10.2. Citizen Reporting Base System Build 66 4.10.3. Citizen Reporting Training 67 4.11 IMPLEMENTATION OF CRIMEVIEW ANALYTICS 68 4.11.1. Crime ViewAnalytics Implementation Process Overview 68 4.11.2. Discovery 68 4.11.3. Code Mapping & Application Configuration 69 4.11.4. Initial Demonstration, Consultation, and Content Preparation 69 4.11.5. CrimeView Training 70 4.11.6. System Review 70 4.11.7. CrimeView Analytics Acceptance 71 5 SYSTEM AND SUBSYSTEM PRE GO -LIVE TASKS 72 5.1 OVERVIEW 72 5.1.1. CentralSquare Responsibilities 73 5.1.2. Customer Responsibilities 73 6 SYSTEM AND SUBSYSTEM GO -LIVE 74 6.1 OVERVIEW 74 6.1.1. CentralSquare Responsibilities 74 6.1.2. Customer Responsibilities 74 7 RELIABILITY PERIOD 76 7.1 OVERVIEW 76 7.1.1. CentralSquare Responsibilities 77 7.1.2. Customer Responsibilities 77 8 PROJECT CLOSURE 78 8.1 OVERVIEW 78 8.1.1. CentralSquare Responsibilities 78 8.1.2. Customer Responsibilities 78 9 APPENDIX A - CONTRACTED MODIFICATIONS TO STANDARD CENTRALSQUARE PRODUCTS 79 10 APPENDIX B - STANDARD CENTRALSQUARE INTERFACES 80 11 APPENDIX C - CUSTOM CENTRALSQUARE INTERFACES 91 12 APPENDIX D - MESSAGE SWITCH 93 13 APPENDIX E - SUBCONTRACTOR STATEMENT OF WORK 108 14 APPENDIX F — MISCELLANEOUS HARDWARE 109 15 APPENDIX J — CENTRALSQUARE CONNECTIVITY TO ENTERPRISE ON -PREMISE SYSTEMS 110 16 APPENDIX Y — WORKSHOP AND TRAINING SUMMARY 111 17 APPENDIX Z — DATA CONVERSIONS 115 The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page ix Page 545 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 17.1 DATA CONVERSION 115 17.1.1. CAD Data Conversion Overview 115 17.1.2. RMS Data Conversion Overview 115 17.1.3. Jail Data Conversion Overview 115 The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page x Page 546 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 1 OVERVIEW 1.1 Statement of Work CentralSquare and the Dubuque Law Enforcement Center (DLEC) are embarking on a collaborative initiative to enhance and streamline the data capture through the implementation of a comprehensive Computer Aided Dispatch (CAD), Mobile, Records Management (RMS), and Jail Management Solution (JMS). This project aims to migrate the existing ONESolution Suite to the Enterprise Suite that provides innovative technology for fast multi -agency, multi -discipline, and multi -jurisdictional with the most efficient and effective resource utilization capabilities. The success of this project will be measured by the seamless integration of CAD, Mobile, RMS, JMS, and the effective collaboration with the CentralSquare Professional Services organization. By achieving these objectives, this collaborative effort will empower DLEC with a state-of-the- art Public Safety Software Solution, facilitating improved incident management, enhanced coordination, and real-time data accessibility for informed decision -making. This Statement of Work (SOW) defines the services and deliverables that CentralSquare will be providing in accordance with the terms and conditions of the Agreement (the "Agreement") between CentralSquare Technologies, LLC (CentralSquare) and Dubuque PD, IA ("Customer"). This project description includes the services and deliverables specified by the Agreement, including if applicable, CentralSquare and services, Subcontractor activities, third -party products, and services for the implementation of the System and Subsystems specified in the Agreement (collectively the "Project"). Statement(s) of Work for applicable CentralSquare Subcontractor(s) are presented in Appendix E — Subcontractor(s) Statement(s) of Work. The framework of deliverables documented by this SOW for this Project is further defined through additional documents such as: Operational Scenario Documents (OSD); User and Administrator Documentation and training materials. The number and type of software licenses, products, or services provided by CentralSquare, or its Subcontractors are specifically listed in the Agreement and any reference within this document as well as Subcontractors' SOWs (if applicable) do not imply or convey a software, license, or services that are not explicitly listed in the Agreement. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 1 Page 547 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 1.2 Project Implementation Definitions Unless otherwise defined herein, capitalized terms within this document have the meanings described in the Definitions section of the Agreement. The following terms are used in this document. Since these terms may be used differently in other settings, these definitions are provided for clarity. ■ Agreement refers to the CentralSquare Solutions Agreement. ■ API is an acronym for Application Programing Interface. An API is a connection between computers or between computer programs. It is a type of software Interface, offering a service to other pieces of software. A document or standard that describes how to build or use such a connection or Interface is called an API specification. A computer system that meets this standard is said to implement or expose an API. The term API may refer either to the specification or to the implementation. ■ Change Order is a collective term for communicating and approving all changes in project scope. ■ Codefiles are the component fields within each product that define the data to be contained within each table. ■ Disaster Recovery (DR) is the process of preparing for and recovering from a disaster. An event that prevents a workload or system from fulfilling its business objectives in its primary deployed location is considered a disaster. ■ FBI CJIS Security Policy means the Federal Bureau of Investigations Criminal Justice Information System Security Policy. The essential premise of the CJIS Security Policy is to provide appropriate controls to protect the full lifecycle of criminal justice information (CJI), whether at rest or in transit. The CJIS Security Policy provides guidance for the creation, viewing, modification, transmission, dissemination, storage, and destruction of CJI. ■ FDD is an acronym for Functional Design Document, which is a document that will be developed by a Software Engineer for the purpose of documenting customer Interface requirements. ■ Functional Acceptance Test (FAT) is a test(s) of specific functionality of the Subsystems of the Enterprise System. ■ GIS is an acronym for Geographic Information System, which is a system for storing and manipulating geographical information on a computer. ■ Go -Live is defined as the event that occurs when the Customer first uses a Subsystem, an Interface or Modification in a live operational environment (i.e., production use). The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 2 Page 548 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration ■ Hardware means any equipment, computer system, servers, storage devices, peripherals, and any other tangible assets purchased under this Agreement. ■ Installation Service Request (ISR) documents servers required for the implementation and the servers' Hardware/virtual specifications. ■ Interface is the integration of a third -party software with CentralSquare software. Contracted deliverable interfaces are described in the Appendix B — Standard CentralSquare Interfaces, in Appendix C — Custom CentralSquare Interfaces, and the Agreement. ■ Modification means changes or additions from the standard version of the Software. The Modifications, if applicable, are described in Appendix A, Contracted Modifications to Standard CentralSquare Products. The CentralSquare Software is not custom software, and as such, at CentralSquare's discretion Modifications or enhancements to the standard version will be made available in a subsequent version release available to all CentralSquare customers; or as applicable, made available as a separate module or function, separately licensed and priced. ■ Operational Scenario Document (OSD) is a document that provides an operational description of an Interface, capability, or feature within the applicable CentralSquare solution. OSD documents are of two types: ❖ For standard Interfaces these documents are standard, published CentralSquare documents and are not specific to any Customer. • For customizations (custom Interfaces or custom Features) the OSD will provide a description in sufficient detail that both Customer and CentralSquare team mutually agree to the expected deliverable. ■ Post Go -Live means the event(s) that occurs after the Customer first uses a Subsystem, an Interface or Modification in a live operational environment (i.e., production use). ■ Pre Go -Live means the event(s) that occurs before the Customer first uses a Subsystem, an Interface or Modification in a live operational environment (i.e., production use). ■ Project collectively includes the services and deliverables specified by the Agreement, including if applicable, CentralSquare services, Subcontractor activities, third -party products, and services for the implementation of the System and Subsystems specified in the Agreement ■ Project Management Plan means collectively the Communications Management Plan; Risk Management Plan; and Change Management Plan that provide the criteria for managing those tasks within the Project. ■ Project Schedule means the mutually agreed upon schedule providing dates and timeframes for completion of tasks and deliverables during the course of this Project. The Project Schedule is subject to change at the mutual agreement of CentralSquare and Customer as further described in this SOW. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 3 Page 549 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration ■ SME is an acronym for Subject Matter Expert, an individual with a deep understanding of a particular topic. ■ Subsystem means each of the applications described in the Statement of Work including its equipment, other Hardware, and software. In most cases, the Subsystem software will share equipment. Applicable Enterprise core applications, e.g. CAD Enterprise, Mobile Enterprise, Records Enterprise, Jail Enterprise are defined as Subsystems. ■ System means collectively all Subsystem(s) (e.g. CAD, Mobile, Records, Jail) that make up the integrated computer system. ■ System Integration Test (SIT) is the scenario -based testing event to test the integration and end -to -end functionality of the system. ■ System Planning Guide provides system administrators and system planners with a single requirements reference. ■ Task Completion Reports (TCR) is a formal document presented to the Customer that acknowledges completion of a major task or event. ■ Work Hours: • Business hours are defined as Monday — Friday, 8:OOam-5:OOpm (local time) • Default training hours are defined as: ■ Remote Training: Monday - Friday, between 8:OOam-5:OOpm (local time) based on the actual duration of the class. ■ On Site Training: Tuesday — Friday, between 7:OOam-10:OOpm (local time) based on the actual duration of the class. ■ Alternate training schedules (e.g., Monday class starts for classes that would normally start on a Tuesday, multiple classes per day, evening, and weekend classes) are subject to additional cost. 1.3 General Customer Responsibilities In addition to those Customer responsibilities stated elsewhere in this SOW, Customer is responsible for the following: a) Electrical facilities — cabling, network communications, telephone, other voice/data connections and peripherals for system workstations and mobiles for production and training use. b) Providing information to CentralSquare staff on network infrastructure, including any firewalls within the overall network that the system will operate and necessary port access for the system to operate in accordance with CentralSquare documentation. c) The installation, configuration, maintenance (including patch management and upgrades of Microsoft software on Workstations and Mobiles. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 4 Page 550 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 j) Dubuque PD, IA ONESolution to Enterprise Migration d) Any Hardware and third -party software or services necessary for implementing the System that is not listed in the Agreement as a CentralSquare Deliverable (not listed as a line item in the Solution(s) and Services Fee Schedule of the Agreement). This includes workstations, server Hardware not included with managed server/hosted solutions, network equipment, telephone or TDD equipment, performance test software, Microsoft licenses, Hypervisor licenses, Disaster Recovery Software, and services required to extract legacy data and convert into acceptable data formats. e) Configuration, maintenance, testing, and supporting the third -party systems that Customer operates and which will be interfaced with as a part of this project. This project includes the Contracted Interfaces listed in Appendix B — Standard CentralSquare Interfaces and Appendix — Custom CentralSquare Interfaces. f) Consoles, furniture, or fixtures as well as any modifications to install equipment used for Systems or Subsystems specified by the Agreement into existing consoles, furniture, vehicles, or existing facilities. Installation of Workstations into consoles, furniture, vehicles or like items, is the responsibility of Customer. g) Customer is responsible for providing remote connectivity to CentralSquare for the purpose of installation, configuration, testing, and troubleshooting of any CentralSquare applications at Customer site. h) CentralSquare's approved remote connectivity methods are described in Appendix J. i) Connect and configure any third -party Hardware (including but not limited to: Bar Code Scanners, Bar Code Printers, Biometric Fingerprint Scanners, Signature Pads, and dongles) to Customer workstations, if these services are not explicitly sold in the System Agreement. Active participation of the appropriate personnel with the necessary background knowledge and availability in the Project implementation meetings and working sessions during the course of the Project. Examples of such implementation sessions are System Orientation, Validation and Readiness, FAT, Training, regular Project meetings, discussion regarding Interfaces, network planning and system installation planning. k) The provision of data as requested by CentralSquare. This information must be provided on a timely basis in order to meet the project timelines. This information will be provided in a format requested by CentralSquare staff in accordance with CentralSquare documentation. I) If Onsite Training is purchased, provide a facility with the required computer and audio- visual equipment for training. m) Provision of facilities and electrical power for CentralSquare staff while onsite. n) The project timeline will require a commitment by Customer staff to attend project meetings, attend training, and execute action items within the mutually agreed upon defined time parameters in the project schedule. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 5 Page 551 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 j) Dubuque PD, IA ONESolution to Enterprise Migration 1.4 Project Exclusions CentralSquare provides software applications that it develops. These applications are sold as is and are considered to be "Commercial Off the Shelf" (COTS) software packages. The functionality of these products will be based on CentralSquare's current design and functionality of these COTS products, unless otherwise indicated in the Agreement. a) Work, software, services, Hardware, Systems, Subsystems, product/software modifications, or any other deliverables not explicitly stated in the Agreement will not be included in the Project. b) Any modification to CentralSquare standard products or customizations to such products that are not explicitly stated in the Agreement are excluded from the scope of this Project. c) Changes in scope will only be executed through a mutually agreed upon Change Order Process, as described in the Project Management Plan. d) CentralSquare is not responsible for the deficiencies in Customer's internal or Contracted network to support Enterprise Suite workstations\mobiles. e) CentralSquare is not responsible for the deficiencies in Customer's network. f) CentralSquare is not responsible for the removal of the old (legacy) equipment, Hardware, furniture, consoles, cabling, as part of the Project implementation unless specifically stated in the Agreement and this SOW. g) This project does not include creation or modification of GIS data by CentralSquare staff. h) CentralSquare is not responsible for coordination, management, or covering the cost of any software, work, customization, coding or testing that is required to be performed by any third -party vendors engaged in the context of standard or custom interfaces, unless the work is defined under a Sub -Agreement with CentralSquare within the scope of this Agreement. i) CentralSquare is not responsible for the creation or modification of any Crystal Reports, SSRS Reports or other third -party reporting application. This includes changes to connection strings or the migration of custom reports. CentralSquare is not responsible for submitting NIBRS data to the State. Customer assumes responsibility to take the necessary steps within the Subsystem to submit NIBRS data monthly to the State unless otherwise noted in the Agreement. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 6 Page 552 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 2 PROJECT CONTROLLING PROCESSES Dubuque PD, IA ONESolution to Enterprise Migration 2.1 Overview Project Control is the process that includes completing regularly scheduled Project progress meetings and the use of regularly delivered Project progress reports, as well as implementing the processes needed for a Project Management Plan which includes the Communication Management, Risk Management, and Change Management plans. As part of the Controlling Processes, CentralSquare utilizes a series of measurements and management reviews to mitigate project risks. Checkpoints or milestones are planned into each phase of the Project to measure performance and determine if the Project is ready for the next phase. Checkpoints are key tasks that act as gates to the next phase of a project. A delay in a milestone may cause a delay in starting or completing subsequent tasks; in effect creating a risk to the overall Project. Therefore, CentralSquare's Project staff closely monitors checkpoint tasks and milestones and promptly notifies the Project Manager of any delay or failure with a milestone task. Milestone delays on the part of either party will trigger an overall review of Project activities so that risks can be assessed and properly managed. In the event that either party becomes aware of a delay, notification shall be provided to the other party as soon as reasonably possible. Evaluation of overall Project status at each checkpoint is essential to ensure that the Project is effectively progressing toward completion and that new risks are not being introduced. In many cases, Project activities leading to a checkpoint are interrelated to later scheduled tasks. Success at checkpoints diminishes the risk to the Project going forward. As part of the controlling process, upon completion of significant milestones and or tasks, CentralSquare will submit a Task Completion Report (TCR) to Customer. The TCR serves as a formal tool for the purpose of verifying with Customer that the work has been performed, services rendered, and products delivered according to the requirements specified within the SOW and/or related documents. TCRs are presented to Customer by CentralSquare's Project Manager for signature. Some TCRs may trigger a Project payment, in accordance with the payment terms within the Agreement. Upon execution of a TCR that is tied to a Project payment milestone, Customer will receive an invoice from CentralSquare's Accounting Department which must be paid based on the terms and conditions of the Agreement. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 7 Page 553 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration The TCR will include the following information: a) Description of Work performed, and products delivered. b) Comments noting any special circumstances. c) Product/Service deliverables listing the Agreement line items that are being recognized as delivered and will be invoiced. d) Related Payment Terms in accordance with the Agreement, for Agreement line items that will be invoiced relative to the TCR. 2.1.1. CentralSquare Responsibilities a) CentralSquare will prepare and submit TCRs for Customer's signature upon completion of the applicable task. b) TCRs that trigger a payment will include the payment amount in accordance with the Agreement payment schedule. 2.1.2. Customer Responsibilities a) The Customer for reviewing and approving all TCRs within a five (5) business day period from the time of receipt less any challenges to the validity of the report. b) In the event that the Customer disagrees with a TCR, Customer shall submit to CentralSquare a written explanation detailing why the Customer believes that the subject of the TCR and/or tasks have not been completed in accordance with the Agreement or this SOW. Such notification from the Customer shall be provided to the CentralSquare Project Manager within five (5) business days of receipt of the TCR. 2.2 Change Order Process Either party can request changes to the scope of the project at any time. Since a change may affect the price, project deliverables, this SOW, the supporting project schedule, and/or the terms of the Agreement for this SOW, both parties must approve each change in writing and agree on the impact each change may have on the Agreement and related attachments. The purpose of the Change Order process is to manage any significant changes to the Project as described in this SOW or related documents as referenced within the SOW. These changes may include but are not limited to a modification to Project scope, standard or custom products' functionality, CentralSquare and Customer's identified roles and responsibilities, Project payment terms, and modifications to the scope or delivery location of services within the Project. All significant changes must be documented through the Change Order process. The type of documentation needed will depend on the nature and significance of the change. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 8 Page 554 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration A Project Change Order will be the vehicle for communicating and approval of the changes. Whether initiated by Customer or CentralSquare, all Change Orders will be documented by the CentralSquare Project Manager. The Change Order shall describe the requested change, the party requesting the change, and the effect the change will have on the project, including the price, project deliverables, this SOW, the supporting project schedule, and/or the terms of the Agreement for this SOW. Once the Change Order is generated, Customer Project Manager and CentralSquare Project Manager will review the proposed change and communicate as necessary to answer any questions, and/or work to resolve any issues preventing acceptance of the Change Order by both parties. Upon the approval by both parties the Change Order will be authorized for implementation. The creation of some Change Orders may, depending upon the scope of the requested change, require fees for CentralSquare to properly investigate and scope of the requested change. If additional fees are required by CentralSquare to create a Change Order, those fees will be identified and communicated to Customer Project Manager prior to CentralSquare's investigation of the requested change. In such situations, CentralSquare will only proceed with the investigation required to create the Change Order if Customer has agreed to pay the additional fees associated with creation of the Change Order. 2.2.1. CentralSquare Responsibilities a) CentralSquare will capture the necessary information required to prepare Change Order and submit to the Customer. 2.2.2. Customer Responsibilities b) When applicable, Customer will identify the services or deliverables that will be subject to a Change Order, per the Agreement between both parties. c) When applicable, Customer will identify changes to application features or functionality, Interfaces, or any other Subsystems that will require a Change Order. This process may also include participation in the requirements process. d) Customer will approve and process Change Orders in a timely manner. 2.3 Project Reporting CentralSquare will provide Monthly Status Reports advising Customer Project Manager and key Customer Project Stakeholders of the progress and status of project activities. This report will include the significant accomplishments, planned activities, issues, and potential risks associated with CentralSquare and CentralSquare's Subcontractors' deliverables. The Project Status Reports will include the following: The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 9 Page 555 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration a) Accomplishments during the Reporting Period. b) Planned upcoming activities. c) Issues. d) Risks. e) Key Action Items. In addition, the CentralSquare Project Manager will provide the following: a) Bi-weekly status calls. b) Monthly status report and schedule updates. 2.3.1. CentralSquare Responsibilities a) Provide a written report of Project status once a month. b) Track issues and action items to closure. c) Conduct status calls every two weeks. d) Maintain an up-to-date Project Schedule. 2.3.2. Customer Responsibilities a) Review the written report of Project status and provide feedback within five (5) business days in order to ensure that the documentation is correct. b) Participate in Project status meetings. c) Ensure participation of personnel in tasks and meetings. 2.4 Document Review In the course of the Project, CentralSquare will deliver several documents to the Customer for review. These documents will include but are not limited to the Functional Acceptance Test Procedures, Project Schedule, OSD, and training materials for the Project. Approved documents are returned to the CentralSquare Project Manager. All documents will be provided via electronic copy. If Customer desires printed (hard copy) documentation, it is their responsibility to print and bind the desire copies. The CentralSquare Project Manager will retain a copy and provide the Customer with a copy. Should the Customer find any document unacceptable, Customer must provide specific reasons in writing to the CentralSquare Project Manager. CentralSquare can then assess any required corrective measures and make revisions or modifications to provide acceptable documents within a mutually satisfactory timeframe. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 10 Page 556 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration In order to ensure compliance with the Project Implementation Schedule, Customer is responsible for the review of such documents and providing any comments to CentralSquare within five (5) business days. 2.4.1. Documents Subject to Customer Approval a) Change Orders b) Operational Scenario Documents (OSD) c) Functional Acceptance Test Procedure documents d) Task Completion Reports (TCR) 2.5 Documents Subject to Customer Review not Requiring Approval Note: The Project Schedule and any changes hereto are to be mutually agreed upon between Customer and CentralSquare. a) Functional Design Documents (FDD) b) Status Reports c) Project Schedule 2.5.1. CentralSquare Responsibilities a) Distribute the documents to Customer. b) Coordinate the process to consolidate comments and edit documents. c) Manage the signoff process for applicable documents and the distribution of originals to Customer and CentralSquare for filing. 2.5.2. Customer Responsibilities a) Review the documents presented and provide the appropriate information back to CentralSquare within five (5) business days for configuration sheets, Change Orders and/or Sales Orders. b) Review the documents presented and provide the appropriate information back to CentralSquare within five (5) business days for requirements documents defined above. Unless unanticipated changes to the Project Schedule would warrant a shortened turn around. 2.6 Third Party Management CentralSquare will be responsible for the management of third parties that have been identified as Subcontractors within the Agreement. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 11 Page 557 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration As part of the Subcontractor agreement, all communications between those third parties and the Customer will be managed by CentralSquare. Any communication directly between Customer and third parties that may require or imply the promise of a material change in scope or responsibilities will not be acknowledged by CentralSquare unless an appropriate Change Order has been prepared. Conversely, the Customer will be responsible for the management of third parties that CentralSquare is not responsible for. The Customer will be responsible for the facilitation of discussions and the acquisition of materials from those third parties that are necessary for the configuration and development of the Customer's System. 2.6.1. CentralSquare Responsibilities a) Assume responsibility for third parties that are the responsibility of CentralSquare within the terms of the Agreement between CentralSquare and Customer. b) Process any Change Orders that may arise from a material change in scope where third parties are concerned. c) Inform Customer when configuration and or programming will require interaction and/or documentation from a third party which is not the responsibility of CentralSquare under the Agreement between CentralSquare and Customer. 2.6.2. Customer Responsibilities a) Work directly through CentralSquare with regard to third parties that are the responsibility of CentralSquare. b) Review, sign and process any Change Orders that may arise from a material change in scope where third parties are concerned. c) Facilitate interaction between CentralSquare and third parties not the responsibility of CentralSquare to include conference calls, answers to questions and documentation as requested. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 12 Page 558 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 3 PROJECT INITIATION AND PLANNING 3.1 Overview Project initiation and planning involves gathering the necessary Project specific information in order to produce a Project Management Plan and a Project Schedule. In short, Project Planning consists of those processes designated to establish when and how the Project will be implemented while further elaborating on project deliverables. Most of the information exchange between Customer and CentralSquare during this process is at a high-level and consists of interaction between both Project Managers and a small group of Project stakeholders. Major deliverables for the Project Planning phase are the specific Project Management Plans, and a baseline Project Schedule. The project must be managed in a manner that will allow for the adjusting the Project Management Plan and Project Schedule to address the circumstances that affect a project during Project Execution. As a result of these changes during the Project life cycle, Project Planning will overlap each subsequent process during the Project. Project Planning tasks will decrease in frequency as checkpoints are completed and as the Project nears Go -Live and Project completion. Note: The Project Schedule is a living document, subject to change during the course of the Project due to several factors such as change in Project scope, scheduling conflicts, delay in approving project documents, resource availability, etc. All changes to the Project Schedule will be discussed between both parties and will be incorporated within a published schedule upon approval from Customer and CentralSquare. 3.1.1. CentralSquare Responsibilities a) Assign a Project Manager to the Project to participate in initiation phase activities. b) Produce required documentation to support initiation activities (such as Operational Scenario Document (OSD), etc.). c) Identify and engage the CentralSquare Project team responsible for carrying out Project Execution. d) In collaboration with Customer, develop the Project Management Plan (includes the Communication Management Plan, Risk Management Plan, and Change Management Plan). e) Baseline the Project Schedule. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 13 Page 559 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration f) Prepare and submit the TCRs for Customer acceptance of the Project Management Plan as defined above. g) Develop and submit invoice for payment due at execution of the Agreement. 3.1.2. Customer Responsibilities a) Assign a Project Manager for the Project to participate in initiation phase activities. b) Identify and engage Customer's Project team. c) Review and comment on the CentralSquare Project Management Plan and the Project Schedule. d) Review and comment on CentralSquare provided documentation to support initiation activities. e) Approve the TCRs for the Project Management Plan within five (5) business days. 3.2 Project Kick Off During the planning phase, the CentralSquare Project Manager will hold a kickoff meeting with Customer's Project team. During the kickoff meeting, the CentralSquare Project Manager will provide an overview of the following: 3.2.1. The CentralSquare Execution Process a) A high-level description of project deliverables. b) Roles and responsibilities for the Project team members. c) A high-level review of the preliminary Project Schedule including projected Project milestones and checkpoints. d) Describe the work that has been either completed, is in progress or is due to begin within the immediate future. e) Review any project related questions from Customer's team. 3.2.2. CentralSquare Responsibilities a) Prepare the agenda and set a date for the kickoff that is convenient to Customer and CentralSquare Team. b) Distribute any documents that Customer should review in advance of the kickoff meeting. c) Conduct the kickoff meeting. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 14 Page 560 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 3.2.3. Customer Responsibilities a) Work with the CentralSquare Project Manager to facilitate scheduling a date for the kickoff meeting. b) Schedule the appropriate personnel from Customer's team to attend. This should also include key stakeholders that may not participate routinely in Project operations, but who have authority or responsibility over the Project. c) Provide adequate accommodations to include adequate seating and audio-visual equipment including a projector(s), screen, and whiteboard. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 15 Page 561 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 4 PROJECT EXECUTION 4.1 Overview Project Execution focuses on the development and delivery of project deliverables. processes will be iterative and consist of 1) a review of deliverable documents; 2) development, configuration, installation and testing of software and Hardware deliverables, and 3) delivery of Project related services such as project related training. These processes are iterative in nature with a number of checkpoints to evaluate project progress. Each deliverable has a closing process which consists of specific completion criteria. These deliverable closing processes are independent from the closing process of the Project. All installation and configuration of Hardware, as well as CentralSquare software upgrades for this project will be performed remotely. 4.2 System Installation Overview: System installation is one of the early processes in the Project implementation phase and has a significant impact on and critical dependency on several key activities. Cloud virtual provisioning will be the responsibility of CentralSquare. On -Premise Hardware provisioning is the responsibility of the Customer. Installation of CentralSquare software on on -premise Hardware is the responsibility of CentralSquare. This implementation will be on -premise. 4.2.1.1 On -Premise Components: CentralSquare will either purchase and provision the server Hardware via a partner, or if the Customer is purchasing the Hardware CentralSquare will give guidance on Hardware specifications for Customer purchasing. CentralSquare gives guidance on Virtual provisioning after On -Premise Hardware has been purchased and integrated into the Customer's network. CentralSquare utilizes a sizing and prerequisites document called an ISR (Installation Services Request) to convey specifications and guidelines for the Customer to create the virtual machines needed for software installation. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 16 Page 562 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration The administration services of the On -Premise environment is the responsibility of the Customer, including support, operation, and maintenance of the underlying infrastructure. On -Premise installation of CentralSquare software takes place after On -Premise servers are provisioned and prepared for installation. 4.2.2. Review Hardware Specifications (On -Premise Components) The Review of Hardware specifications is a review of the requirements for any On -Premise Components, be they servers, workstations or peripherals. The Review process is intended to function as an informational exercise for the Customer for any On -Premise Hardware sizing. 4.2.2.1 Customer Procured Server Hardware: CentralSquare and Customer will review the Hardware specifications and third -party software components to ensure that the correct Hardware and third -party software components are procured. CentralSquare will provide Customer with a Hardware sizing document listing the Hardware and third -party software specifications required for this Project. CentralSquare will provide an overview of deployment recommendations for the CentralSquare Enterprise Suite, to the Customer. CentralSquare will not reverse engineer third party Hardware quotes or Bills of Materials to certify specifications. 4.2.2.2 Workstation and Peripheral Hardware: CentralSquare will review workstation and any peripheral specifications with the Customer. 4.2.2.3 CentralSquare Responsibilities a) Provide Hardware Sizing\Third party -software documentation to Customer prior to the review meeting. b) Provide System Planning Guide to Customer prior to the review meeting. c) Schedule and participate in review meeting. 4.2.2.4 Customer Responsibilities a) Provide technical resources for the review meeting. b) Review and understand Hardware and third -party software documentation. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 17 Page 563 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 4.2.3. Procurement\Allocation of Hardware and Third -party Software (On - Premise Components) This task is for the net new procurement of Hardware and third -party software and equipment per the specifications provided by CentralSquare for the On -Premise components. If there is no net new Hardware purchase associated with the Agreement, either by CentralSquare or the Customer, this task represents the allocation of existing resources for On -Premise components by the Customer. 4.2.3.1 CentralSquare Responsibilities a) None. 4.2.3.2 Customer Responsibilities a) The Customer is responsible for the procurement of Hardware and third -party software based on the specifications from the Hardware and third -party software review. 4.2.4. Basic Server Integration (On -Premise) Basic server integration includes placing the servers in the racks, creating the virtual environment, provisioning virtual machines, joining them to the existing domain, and establishing remote connectivity capability via the CentralSquare remote support solution for authorized CentralSquare personnel to perform configuration. These activities will be coordinated between CentralSquare and Customer IT staff. Guidance will be provided by way of a technical kickoff meeting with CentralSquare's Technical Services Installation team and with the use of the ISR (Installation Services Request) process which organizes the information into CentralSquare's preferred format. To begin the software installation phase CentralSquare must have Customer -authorized remote connectivity to the servers, documentation of server names, IP addresses, Administrator Account Information (Username, Password), Services Account Information, and the location of 3rd Party Software media (such as SQL). If the connectivity, servers, server details, accounts and media are not ready two weeks prior to the scheduled installation, the Project may need to be rescheduled, which may have an impact on the overall Project timelines. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 18 Page 564 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 4.2.4.1 Customer Provided Basic Server Integration: Customer will perform basic server integration for all On -Premise servers. The site must be prepared and ready for the installation of CentralSquare software as detailed in CentralSquare's documentation including the System Planning Guide no later than two (2) weeks prior to the scheduled Installation date. Delay in providing this information in its complete form will result in a delay in the Installation and the activities that follow installation of the System. 4.2.4.2 CentralSquare Responsibilities (Customer provided Basic Server Integration) a) Host a technical kickoff meeting to review the requirements for Installation including the Installation Service Request (ISR) Document. b) Distribute the Installation Service Request (ISR) document to Customer. c) Assist in Customer in completing the ISR. d) Review the completed ISR prior to the installation. e) At least one (1) week prior to installation, a member of the CentralSquare Technical Services team will verify: (1) connectivity to Customer site via CentralSquare's remote support solution, (2) connectivity to each of the servers, and (3) access to all required security accounts. f) Prepare and submit a TCR for Customer review and approval upon completion of these activities. 4.2.4.3 Customer Responsibilities (Customer provided Basic Server Integration) a) Have appropriate subject matter experts attend the technical kickoff meeting. b) Provide the facility suitable to house Server Hardware and network infrastructure. c) Have a member of Customer's IT staff available while software/network configuration is being performed. d) Provide all horizontal and vertical cable runs, pathways, coring, access points, floor cutting or drilling, and related tasks related to cable and equipment installation. e) Provide all external Interface connection points, electrical power and other receptacles within manufacturer recommended distance of the equipment and all peripheral components. f) Provide electrical facilities (e.g., outlets, generator, and other electrical infrastructure facilities required for this project, including necessary maintenance. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 19 Page 565 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 g) Dubuque PD, IA ONESolution to Enterprise Migration Provide cabling (e.g., power, network, Interface, and other electrical and data transmission lines) required for this project, including necessary maintenance. All lines will be clearly identified and tested. h) Provide and install all data communication equipment, switches, routers, and other components necessary for system operation and maintenance, connection to remote sites to other systems, and to other agencies. i) Provide network/communications connections (e.g., LAN/WAN, commercial wireless, telephone, VPN, and other voice/data connections), and maintain ongoing network/communications charges associated with installation, operation or support of the proposed system including the establishment and maintenance of security accounts. j) Configuration and/or programming of network routers, switches, and bridges — this includes providing information to CentralSquare staff on any firewalls within the overall network that the system will operate and necessary port access for the system to operate in accordance with CentralSquare documentation. k) Provide TCP/IP communications and connection to the server equipment for any existing networks, workstations, mobiles, and printers that are to have access to the CentralSquare applications. I) Obtain all necessary IP addresses and schemes. m) Perform basic server integration including, but not limited to: i. Installation of servers in applicable racks. ii. Connecting servers to network switches. iii. When deploying a SAN, configure the applicable RAID configuration, create the LUN(s), and present them to the physical or virtual servers. iv. Installation and configuration of the virtual environment. v. Creation of Virtual Machines vi. Assign Server Names and IP Addresses to virtual machines vii. Install operating system software, perform Windows Genuine Advantage validation, and install all Windows Updates. viii. Provision of Domain and/or Joining servers to an existing Customer domain. ix. Enable and configure DNS, enable, and configure DHCP if required. n) Installation of CentralSquare prerequisite software. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 20 Page 566 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration o) Create and maintain any local, third party or public SSL certificates for the On - premise servers which require them, per CentralSquare documentation. Allow and establish CentralSquare access to all system administrative accounts on all servers running CentralSquare licensed Software. Gather all necessary configuration documentation which includes machine naming, IP addresses, Administrator Account information, Service(s) Account information, naming convention, and connectivity as prescribed in the Installation Services Request ISR) and return the ISR to CentralSquare. r) Provide CentralSquare with a high-level network diagram. The diagram should be provided prior to CentralSquare installation. s) Install all workstations and peripheral equipment, including scanners, printers, barcode readers, etc. p) q) t) Approve the applicable TCR. 4.2.5. System Installation (On -Premise) CentralSquare Technical Services Engineers will perform the CentralSquare software installation. These services will be performed remotely and include installation of the Contracted CentralSquare products as specified in the Basic Server Integration portion of the project. These installation activities will be coordinated between CentralSquare and Customer. CentralSquare will host a technical handoff meeting with the Customer to advise on ongoing maintenance of the on -premise system. If Customer does not follow the processes and procedures detailed in the CentralSquare System Planning Guide and technical handoff and this results in a need for reinstallation of the Hardware or software, the reinstallation effort will be performed at additional cost to Customer If determined to be because of a significant oversight deviating from the System Planning Guide and technical handoff. 4.2.5.1 Prerequisites for this Task: a) Completion of Basic Server Integration Task. b) Completed ISR. c) Completed High Level Network Diagram. d) Provision and Testing of Remote Access and Server User Accounts. e) Location of SQL Installation Media and Keys. f) Provision of SSL Certificates. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 21 Page 567 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 4.2.5.2 CentralSquare Responsibilities a) Install and configure Microsoft SQL to operate with each of the applicable CentralSquare product(s). b) Install and configure the applicable CentralSquare system(s) on the designated servers and applicable environments as specified in the Agreement. c) Integrate on -premise components to cloud installed components. d) Provide verbal support to Customer with self -installation procedures for the workstations. e) After completion of the initial installation and configuration of each major System (such as Records Enterprise servers), a member of Technical Services team provides a technical handoff meeting to the designated staff from Customer's information Technology team via a conference call. The following major topics will be discussed during this technical handoff: Proper procedures for performing System Backups: i. File Structure — Inclusions and exclusions ii. Databases iii. Moving backups to media iv. Procedures for refreshing test/training system (and related documentation) if applicable v. Approved configuration and use of Virus Scan software vi. Approved procedure for application of Windows updates vii. System Upgrade process and procedures viii. Support Website and CentralSquare list server access ix. Managing/Reviewing system logs (SQL and Event Logs) f) Provide a Network Layout Diagram of the installed servers. g) Provide a list of network ports and protocols utilized for the purpose of securing the system. h) Prepare and submit a TCR upon completion of the installation tasks and activities. 4.2.5.3 Customer Responsibilities a) Allocate appropriate onsite Project personnel to support CentralSquare personnel during configuration tasks as necessary and designate a primary point of contact to be available to address and answer questions that arise during the installation of the baseline application software. Appropriate Customer The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 22 Page 568 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration personnel include the necessary IT personnel and database administrator(s) as needed during installation. b) Customer is responsible for making the SQL media and license keys available to CentralSquare for installation. c) Have appropriate subject matter experts (usually Customer IT) attend the technical handoff meeting. d) Complete the configuration of workstations (after the installation of any contracted number of workstations by CentralSquare) using the Prerequisite Software Package and applicable Launch configurations. e) Put in place CentralSquare's recommended backup procedures as outlined in the System Planning Guide and ensure backup procedures are consistently followed beginning at the completion of this task. f) Install and configure virus scanning and other security software as outlined in the System Planning Guide. After completion of the initial installation and configuration of System servers, Customer will be responsible for maintaining the System based on CentralSquare System Planning Guide, and the technical handoff meeting and associated document from CentralSquare Technical Services department. g) h) Review and approve the TCR from the technical handoff meeting. 4.2.5.4 Disaster Recovery Provisioning (On -Premise) Disaster Recovery Licensing per product is required for any on -premise Disaster recovery solution, whether it is implemented by CentralSquare, a third party, the Customer or any combination of these. The licensing is for the right to use the software in a Disaster Scenario. Disaster Recovery is intended for core on -premise production system recovery and does not extend to replicated reporting systems or test\training systems. Disaster Recovery is not High Availability. Disaster Recovery is a process intended to stand up the entire on -premise setup at another location for operational continuity, not migrate individual servers or services on an ad -hoc basis. Disaster Recovery does not address downtime concerns due to software updates of any kind. The Disaster Recovery solution may contain some elements which do utilize a clustered High Availability approach, as supported by the CentralSquare Enterprise Suite, and as contracted for. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 23 Page 569 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Disaster Recovery is not a system intended to be used as backup software, point -in time snapshots, or for malware/ransomware recovery since the replication is an ongoing process. In the event where there is a significant failure of the primary server infrastructure, the Disaster Recovery environment allows staff to connect to a Disaster Recovery System located at a remote location to continue operations. This scenario is particularly applicable in situations that involve power and/or network outages, facility failure, and lack of access to the primary server environment. The synchronization between Primary and the Disaster Recovery server requires CentralSquare approved third -party Disaster Recovery Software product(s). If the license for this synchronization software is not explicitly listed in the Agreement (purchased through CentralSquare) the Customer is responsible for procurement of the required licenses for this software. If contracted to provide the Disaster Recovery replication software directly or via a CentralSquare Subcontractor, CentralSquare and/or CentralSquare's Subcontractor will provide the software, install the software and provide Disaster Recovery software training and\or documentation. If the Customer sources Disaster Recovery replication software, the Customer is responsible for providing the software, installation of the software, documenting the procedure and training any staff necessary for the failover operation. In all cases, whether the replication software is contracted via CentralSquare and\or CentralSquare Subcontractor or provided by the Customer, CentralSquare Technical Services staff will be available for One (1) Failover and Failback operation as part of this engagement. The Customer must ensure that trained personnel are available for failover/failback and that applicable documentation is carefully followed. lithe Failover and Failback operation is unsuccessful due to CentralSquare and/or Subcontractor misconfiguration or error, Failover and Failback testing will continue until there is a successful Failover and Failback operation. If the Failover and Failback operation is unsuccessful due to Customer configuration (including network issues between the sites, or between Customer software and the DR site), further tests with CentralSquare involvement will need to be contracted with a Change Order. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 24 Page 570 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration If the Customer's preference is to have multiple Failover and Failback tests with CentralSquare involvement, this can also be accommodated with a Change Order. All Failover and Failback tests are to take place in the pre -production environment. If a Post Go -Live Failover and Failback test is required, this will need to be specifically contracted for. Additional Information on Disaster Recovery is available in the Enterprise System Planning Guide. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 25 Page 571 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 4.3 Implementation of Enterprise System Interfaces 4.3.1. Enterprise Standard Interfaces - Implementation Overview Standard interfaces to be implemented (and designated environments) for this project are listed within the Agreement and Appendix B of this SOW. Standard Interfaces may require certain work to be completed in the system prior to implementation. This may include code table configuration, system hierarchy, template design and the configuration of servers, certificates and integrations required for Interface operation. Standard Interface FDD documents will detail network, third party and other prerequisites for Interface operation. Standard Interfaces are deployed in the pre -production environment (which becomes production at Go -Live). Disaster Recovery Interfaces for on -premise systems are also licensed in the Agreement and listed in Appendix B of this SOW. The Disaster Recovery system for on -premise Systems will include licensed Disaster Recovery Interface configurations if the Interface Servers are replicated at a Virtual Machine level, with the assumption that no re -configuration needs to occur to either the CentralSquare or third -party end points as a result of a failover. If the on -premise Disaster Recovery system contains separately configured, non - replicated, Interface servers then Interface configuration services will need to be included in the Agreement. 4.3.1.1 Standard Interfaces Major Task Description Schedule Standard Interfaces are replicated for Disaster Recovery with no end point configuration changes. CentralSquare and Customer will conduct Interface implementation tasks as indicated in the approved Project Schedule. Applicable Code Tables, configurations and Templates that must be built as part of the overall Project Schedule as a prerequisite for Interface deployment and/or testing will be detailed by the OSD. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 26 Page 572 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Functional Review Review of standard Interface functional specifications with CentralSquare, Customer's subject matter expert (SME), and third -party vendor to review the Operational Scenario Document (OSD). Installation and Configuration CentralSquare will install the Interface, configure and dry -run test the Interface. Functional Acceptance Testing CentralSquare will complete functional testing of the Interface with Customer and third party using a Functional Test document based solely on the OSD. Customer notates the Functional Test document to indicate which tests passed or did not pass based on the OSD. Any exceptions are resolved and re -tested. Sign Off Customer signs off on each Interface via a Task Completion Report (TCR) upon completion of Functional Test. Go -Live The interfaces are brought into production during system Go -Live. 4.3.1.2 Enterprise Standard Interfaces - Roles and Responsibilities 4.3.1.2.1 CentralSquare Responsibilities a) Review Interface OSD with Customer for each standard Interface. b) Prepare and submit a TCR to Customer documenting the delivery/review of the OSD. c) Assist with detailing configuration options for the Interface. d) Install, configure and pre -test each Interface based on the agreed -upon configurations. e) Assist Customer and third -party vendors to complete functional testing in accordance with Functional Test document. CentralSquare is not responsible for configuration of third -party systems. f) Prepare and submit a TCR documenting completion of Functional Test including any exceptions. Resolve Functional Test issues and re -run tests to confirm they have been resolved. g) The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 27 Page 573 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 4.3.1.2.2 Dubuque PD, IA ONESolution to Enterprise Migration Customer Responsibilities a) Participate in the review of OSDs for each standard Interface. b) Provide the information that is necessary to complete the configuration options for each Interface. c) Obtain the detailed documentation, schema, protocols, query specifications, sample files, and API access for each of the third -party applications that CentralSquare interfaces with and provide the documentation to CentralSquare. d) Act as the primary point of contact with third parties, including other vendors, state and/or local agencies that control products with which CentralSquare products will Interface with. e) Ensure connectivity on the designated protocols and ports to or from third party or Customer -hosted end points. f) Ensure design decisions and functional signoff decisions are made conclusively and in a timely fashion. Provide a point of contact/administrator for each/all standard interfaces with knowledge and experience of the work and data flows. h) Participate in the Functional Test with CentralSquare and third -party vendor and notate each test has passed, failed, or is not applicable. Validate data transferred to/from CentralSquare systems as part of the testing process of the Interface. g) i) Assist CentralSquare in documenting, testing, and resolving Functional Test exceptions. j) Review and approve applicable TCRs. Changes to the configuration of standard interfaces made by Customer may make the Interface non -supportable. As a result, troubleshooting efforts may be subject to additional cost. Customer will arrange for third party vendor participation for systems that will be interfaced with to ensure successful configuration and testing for end -end data flow. Customer is responsible for any services or software needed from third party systems to allow for interaction with the third -party system, or for connection to CentralSquare software in the absence of a third party API. CentralSquare is not responsible for cost associated for the API, any required third -party lab or certification testing, cost associated with required programming, custom work by third party vendors, or any license fees that may be required by third party vendors. No third -party Interface software will be installed on CentralSquare servers without the permission of CentralSquare. Note: Any changes required to Records Enterprise templates required for standard Interface work is the responsibility of Customer. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 28 Page 574 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Note: Modifications requested by Customer to a standard Interface may incur additional cost and could result in project delays, since modifications to standard interfaces are only released with a major software version. 4.3.2. Enterprise Custom Interfaces - Implementation Overview Custom interfaces to be implemented for this project are listed within the Agreement and Appendix C of this SOW. Custom Interfaces may require certain work to be completed in the system prior to implementation. This may include code table configuration, system hierarchy, template design and the configuration of servers, certificates and integrations required for Interface operation. Custom Interface OSD documents will detail network, third party and other prerequisites for Interface operation. Custom Interfaces are deployed in the pre -production environment (which becomes production at Go -Live). Interfaces are not deployed in test or training environments unless specified in the Agreement and Appendix C of this SOW. Disaster Recovery Interfaces for on -premise Systems are also licensed in the Agreement and listed in Appendix C of this SOW. The Disaster Recovery system for on -premise Systems will include licensed Disaster Recovery Interface configurations if the Interface Servers are replicated at a Virtual Machine level, with the assumption that no re -configuration needs to occur to either the CentralSquare or third -party end points as a result of a failover. If the on -premise Disaster Recovery system contains separately configured, non - replicated, Interface servers then Interface configuration services will need to be included in the Agreement. 4.3.2.1 Custom Interfaces Major Task Description Schedule Custom Interfaces are replicated for Disaster Recovery with no end point configuration changes. CentralSquare and Customer will conduct Interface implementation tasks as indicated in the approved Project Schedule. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 29 Page 575 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Applicable Code Tables, configurations and Templates that must be built as part of the overall Project Schedule as a prerequisite for Interface development and/or testing will be detailed by a CentralSquare Consultant or Software Engineer. Functional Review Review of custom Interface functional specifications with CentralSquare, Customer's subject matter expert (SME), and third -party vendor to develop the Operational Scenario Document (OSD). Customer must provide relevant information regarding the operation of the Interface with relation to its operation as well as any interaction with external systems. This is essential for accurate development of the OSD. Documentation Customer reviews and approves each OSD as a precursor to the start of Interface development. The approved OSDs will be used as a basis for development, configuration, and functional testing of each custom Interface. Development, Installation & Configuration After development concludes, CentralSquare will install and dry -run test each Interface. Functional Acceptance Testing CentralSquare will complete functional testing of the Interface with Customer and third party using a Functional Test document based solely on the approved OSD. Customer notates the Functional Test document to indicate which tests passed or did not pass based on the approved OSD. Any exceptions are resolved and re -tested. Sign Off Customer signs off on each Interface via a Task Completion Report (TCR) upon completion of FAT. Go -Live The interfaces are brought into production during system Go -Live. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 30 Page 576 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 4.3.2.2 Enterprise Custom Interfaces - Roles and Responsibilities 4.3.2.2.1 CentralSquare Responsibilities a) Create and provide OSDs to Customer for each custom Interface. b) Prepare and submit a TCR to Customer, documenting Customer's approval of each custom Interface OSD. c) Using the approved OSDs, complete development of each custom Interface. d) Install, configure and pre -test each custom Interface. e) Develop Functional Test documents based on the approved OSDs. f) Provide Functional Test documents to Customer for use during the Functional Test of each Interface. g) Assist Customer in conducting Functional Test in accordance with Functional Test documents. h) Resolve and retest any Functional Test exceptions. i) Prepare and submit a TCR to Customer, documenting completion of Functional Test for each Interface, including any Functional Test exceptions. 4.3.2.2.2 Customer Responsibilities a) Provide the information that is necessary for development of the OSD for each custom Interface. b) Obtain detailed documentation, schema, protocols, query specifications, sample files and API access for each of the third -party applications that CentralSquare interfaces with and provide the documentation to CentralSquare. c) Review and approve the TCRs for each OSD. d) Engage the third -party vendors as requested by CentralSquare. e) Act as the primary point of contact with third parties including other vendors, state agencies, and local agencies that control products with which CentralSquare products are to Interface with. f) Ensure connectivity on the designated protocols and ports to and from third party or Customer -hosted end points. Ensure design decisions and functional signoff decisions are made conclusively and in a timely fashion. h) Provide a point of contact for each Interface with knowledge and experience of the workflow and data. i) Participate in the Functional Test of each custom Interface. Validate data transferred to or from CentralSquare systems as part of the Interface. g) The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 31 Page 577 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration j) Document Functional tests passed, or failed, and assist CentralSquare in providing details regarding any exceptions. k) Assist in testing and verifying fixes for Functional Test exceptions. I) Review and approve applicable TCRs. Note: Any changes required to Records Enterprise templates required for custom Interface work is the responsibility of Customer. Note: Incomplete or inaccurate information, or delayed OSD approval may have a cascading effect on the Project Schedule, and result in a significant delay in completion of the project. Requirements changes for custom interfaces after approval of the OSD shall follow the Change Order Process and may be subject to additional cost and development time. Changes may also have a cascading effect on the project schedule, and result in delays to completion of the project. Customer is responsible for providing application programming Interface (API) documentation for the third -party system. The API must document the integration process for the level of Interface integration defined by CentralSquare's response to the RFP. The API must be compatible with the version of the third party software CentralSquare will b be interfacing with; the timeline for providing information must be concurrent with development of the OSD so any limitations associated with integration with the third -party applications can be taken into consideration. Customer is responsible for any services or software needed from third party systems required for integration with the third -party system. CentralSquare is not responsible for any cost associated for the API, any required third -party lab or certification testing, cost associated with required programming or custom work by a third -party vendor, or any license fees that may be required by the third -party vendor. The scope of functionality for the custom Interface is limited to: 1) the capability of the CentralSquare system being interfaced with and 2) the application programming Interface (API) capabilities of the external system being interfaced. Customer is responsible (when requested) for coordinating the execution of a standard Non -Disclosure Agreement (NDA provided by CentralSquare) between third party vendors and CentralSquare. The NDA must be completed as a prerequisite to sharing technical or other information/documentation, and before testing of the Interface can commence. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 32 Page 578 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Customer is responsible for coordinating the development of the vendor side of all interfaces to third party applications for interfaces for which the vendor is not a CentralSquare Subcontractor, based on the Agreement. CentralSquare is not responsible for the cost of any software, work, customization, coding, or testing that may be required to be performed by third party vendors associated with implementation of the custom Interface (unless the work is defined under a Sub -Agreement agreement with CentralSquare within the scope of the Agreement). No third -party Interface software will be installed on CentralSquare servers without the permission of CentralSquare. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 33 Page 579 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 4.4 Implementation of CAD Enterprise CAD Enterprise is implemented through a series of standard steps and process gates designed to ensure that operational needs are identified, configurations are verified, and tested to validate proper functionality prior to Go -Live. 4.4.1. CAD Enterprise Implementation Process Overview Major Task Description Workshops CentralSquare and Customer will conduct workshops as indicated in Appendix Y. Base System Build After initial build by CentralSquare, Customer assumes ownership of building and maintaining Codefiles. Functional Acceptance Testing Conducted prior to the start of End User Training. Training As indicated in Appendix Y. Go -Live The application is brought into production use. 4.4.2. CAD Enterprise Base System Build Major Task Description Overview Initial Codefile review and build by CentralSquare Consultant with active participation by Customer via periodic remote review sessions. CentralSquare Consultant will configure the System hierarchy based on call flow and operational processes as defined during System Orientation. Customer Participants CAD Administrators and core members of Customer implementation team who can address key points and make configuration decisions while participating in the Codefile building process. Output CentralSquare Consultant completes the base Codefile entry to a level that allows for evaluation of call flow and incident management functions, including: call -taking layout, system hierarchy, incident numbering, Incident/Unit displays. Validation via the Codefile building confirms completion of setup, limits the risk of rework, and ensures understanding of how information will translate for usage within CAD Enterprise. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 34 Page 580 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Some Codefiles that require local knowledge of the geography and physical location of business and high -risk areas of the community (such as response plans, premises, and caution note/hazard information) cannot be built by CentralSquare. Customer assumes responsibility for entering and geo- verifying some Codefile elements such as premises. The CentralSquare Consultant will provide consultation services throughout the project. Prerequisites Completion of CAD Enterprise System Orientation and receipt of requested Codefile data from Customer's completed SMS worksheet. 4.4.2.1 CentralSquare Responsibilities a) Monitor timely delivery, evaluate Codefiles submitted by Customer, and provide oversight with entry. b) Complete preliminary Codefile build of Customer's CAD Enterprise System as outlined in the Provisioning Guide. Codefile build will be entered based upon the applicable requirements provided by CentralSquare and responses from Customer. c) Facilitate updates to the Provisioning Guide. 4.4.2.2 Customer Responsibilities a) Provide timely input and updates to the SMS sheet to support Codefile building timelines. b) Participate in the Codefile validation conference call. c) Continue building System Codefiles (those not built by CentralSquare). 4.4.3. Geographical Information Services 4.4.3.1 Data Evaluation The CentralSquare GIS Analyst will perform a onetime evaluation of Customer - supplied GIS data layers to ensure they are formatted correctly for street -centerline display, address point usage, address functions, routing and Quickest Path Unit Recommendations, and CAD and Mobile map optimization. Upon completion of the analysis, the CentralSquare GIS Specialist will provide a report summarizing the findings. Note: The one-time GIS data evaluation by the CentralSquare Analyst only applies to custom map conversion of Customer -supplied data. If the Customer purchases The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 35 Page 581 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration TomTom data, the one-time GIS data evaluation is not required. The Customer will still need to provide the other required GIS data for the system, such as response areas and layers for the CAD and Mobile Maps. 4.4.3.1.1 CentralSquare Responsibilities a) Evaluate Customer -supplied GIS data. b) Provide and present a report summarizing the findings from GIS analysis services for CAD Enterprise. c) Prepare and submit a TCR upon completion of relevant activities. 4.4.3.1.2 Customer Responsibilities a) Provide the required GIS data in the required format, and per Project Schedule. b) Based on the Analysis Report provided by CentralSquare, make requested changes to mapping data to meet CentralSquare's GIS data requirements. c) Review and approve the appropriate TCR. 4.4.3.2 GIS Conversion and Mapping Configuration A CentralSquare GIS Analyst will convert the GIS data into the CAD system and configure up to 7 standard GIS layers for viewing on CAD and Mobile Enterprise. GISLink training will enable the Customer to create additional layers for use in CAD Enterprise and Mobile. Standard layers are limited to the following: a) Water line features (rivers, streams, creeks) b) Water polygon features (ocean, lakes, ponds) c) Airports d) Railroads e) Parks f) City Boundaries g) County Boundaries If Customer provides Response Area data to CentralSquare at the time of CAD map conversion, the CentralSquare GIS Analyst will import Response Areas into CAD Enterprise. GISLink training will provide Customer with the capability to add, delete, or modify Response Areas for ongoing GIS maintenance. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 36 Page 582 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 4.4.3.2.1 CentralSquare Responsibilities a) Perform mapping data conversion and import of Customer -supplied data into applicable licensed Systems and Subsystems. b) Configure routing and mapping components. c) Prepare and submit a TCR upon completion of relevant activities. 4.4.3.2.2 Customer Responsibilities a) After initial GIS conversion, assume responsibility for updating the data using CentralSquare provided GIS tools to ensure that data is up to date for Go -Live. b) Customer will need to provide ESRI ArcGIS Pro licenses, version 2.9. The ESRI ArcGIS Pro licenses do not need to be dedicated to CAD/Mobile, but they are required to maintain the maps for the CAD and Mobile systems. c) Review and approve the applicable TCR. 4.4.3.3 GISLink Utility Training Major Task Description Overview CentralSquare will provide hands-on training in usage of the GISLink and other GIS utilities. GISLink is a CAD Enterprise utility that consolidates GIS data -related tools for maintaining and using GIS data in CentralSquare products. The class prepares Customer personnel to import and manage existing GIS data used in CAD and Mobile Enterprise. Customer Participants GIS Administrator(s). Participants should not exceed four (4) per class. Output Students will learn how to use the GISLink utility to manage GIS data in CAD Enterprise. Prerequisite System installation to include GIS-related components and initial map installation to include at least one CAD Enterprise console with the GISLink utility installed on it. GIS knowledge and background; familiarity with ESRI tools. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 37 Page 583 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 4.4.4. CAD Enterprise Workshops After the CAD Enterprise operational review has been completed, CentralSquare will conduct one or more CAD Enterprise workshops. Workshops are an extension of the operational review and are specified in the Agreement. Refer to Appendix Y - Workshop and Training Summary for a complete listing applicable to this project. 4.4.4.1 CentralSquare Responsibilities a) Schedule workshops in accordance with Customer's availability and the Project Schedule. b) Prepare and distribute the meeting agendas and documents for Customer review or completion prior to each workshop. c) Conduct workshops based on the distributed agenda. d) Prepare and submit a TCR upon completion of the workshop. 4.4.4.2 Customer Responsibilities a) Provide adequate environment to conduct the workshop. b) Ensure participation of the appropriate personnel. c) Continue Codefile building activities as directed. d) Review and approve the applicable TCR. 4.4.5. CAD Enterprise Functional Acceptance Testing (FAT) Major Task Description Overview Customer leads and CentralSquare will assist with FAT, which is an activity occurring one time after OAR and prior to End User Training and Go -Live. FAT is conducted for the first phase going into production and is not repeated for subsequent phases. CentralSquare may organize at its discretion, separate breakout FAT sessions for subsections of the Functional Test documents that are applicable only to one agency (for example, applicable only to Law or Fire agencies). Each test will be executed once, and applicable users and agencies must attend the FAT session and conduct the tests. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 38 Page 584 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration The FAT process consists of running standard tests in a format designed to verify the functionality of CAD Enterprise. Functional Test documents are submitted and approved by the Customer prior to testing in acknowledgement that the test scenarios will be used to validate System functionality for pre- production and Post Go -Live assessment of features for Software Acceptance. Test sign off is a precursor to administration of the FAT. Following the completion of the FAT, any failure will be classified based on the following criteria: • Go -Live Issues: Issues in the subsystem identified during FAT with contractually required functionality that must be corrected prior to Go - Live. CentralSquare will research such identified issues and propose a plan for resolution. Go -Live Issues will be corrected prior to Go -Live. • Post Go -Live Issues: Issues in a subsystem with contractually required functionality that can be corrected after Go -Live. Customer and CentralSquare will mutually agree these issues may be addressed after Go -Live. CentralSquare will provide an estimated date for resolution of the issue Post Go -Live Completion of the Functional Test does not constitute Final System Acceptance. Customer Participants Key members of implementation team familiar with CAD Enterprise from various agencies and/or PSAPs. Duration As noted in Appendix Y — Workshop and Training Summary. Output Upon completion, Customer's CAD Enterprise system is acknowledged as having completed pre -production acceptance. Customer and CentralSquare will review FAT exceptions (if any), perform an assessment, and determine the timeline for remedying the exceptions (Go -Live versus Post Go -Live). CentralSquare will not train Customer's end users until the FAT has been conducted and TCR signoff has been received. Customer, with CentralSquare assistance as needed, will repeat failed test(s) following correction of issues that caused the test(s) to fail. A full retest of the System will not be conducted. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 39 Page 585 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 4.4.5.1 CentralSquare Responsibilities a) Deliver CentralSquare's standard FAT document to Customer for review no later than two (2) weeks prior to conducting the FAT. b) Provide a TCR to Customer to approve receipt of FAT documents and content thereof. c) Assist Customer in conducting FAT. d) Identify and document exceptions and passes to determine timeline to remedy exceptions (Go -Live versus Post Go -Live). e) Upon completion of the FAT, provide a TCR to the Customer for review and approval. FAT exceptions will be documented in the TCR. f) Schedule follow-up testing for validation of exceptions after correction and confirm/document the results via TCR. Provide a final TCR to Customer to confirm resolution of all Go -Live exceptions. g) 4.4.5.2 Customer Responsibilities a) Complete all predecessor tasks to include the base system installation and Codefile build required to conduct the FAT. b) Provide adequate environment to conduct the FAT. c) Review and signoff on the FAT test documents no later than one week prior to commencement of the FAT via TCR. d) Lead the FAT by providing operational SME's with the authority to provide validation of the tests have passed. It should be noted that this is not a training exercise so SME's should have system knowledge. e) Assist CentralSquare in documenting FAT results. f) Review and approve the applicable TCRs. 4.4.6. CAD Enterprise Training CAD Enterprise Training is conducted on consecutive weekdays during business hours. Alternate training schedules (e.g., Monday class starts for classes that would normally start on a Tuesday, multiple classes per day, evening, and weekend classes) are subject to additional cost. Training classes are conducted based on the quantities specified in the Agreement. The appearance of a course description in this Statement of Work does not mean a course will be conducted — it must be listed in the Agreement. Refer to Appendix Y - Workshop and Training Summary for a complete listing applicable to this project. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 40 Page 586 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration The training classes related to CAD Enterprise and its subsystems are classified into three general groups: Classes dependent upon specific Customer configurations and requirements; therefore, conducted on Customer's System after completion of the Functional Test and in preparation for Go -Live. CAD Enterprise Call Taker/Dispatcher User Training Course are examples. Classes such as GISLink are delivered to a specialized group within Customer's team throughout the Project to assist with implementation and maintenance of the System. Classes such as System Administration Training and CAD API Training that are not dependent upon Customer configurations and are generic in nature. These classes are offered on a regular schedule by CentralSquare (not by Customer), and as a remote activity, include attendees from different agencies. Refer to Appendix Y - Workshop and Training Summary for a complete listing applicable to this project. 4.4.6.1 CentralSquare Responsibilities (For All CAD Enterprise Training) a) Conduct training in increments of one (1), eight (8) hour day. b) Provide feedback to Customer Supervision as to the progress of the students. c) Prepare and submit a TCR upon completion of each type of training. 4.4.6.2 Customer Responsibilities (For All CAD Enterprise Training) a) Provide adequate environment for the execution of the training. b) Provide a supervisor for each class to respond to Customer -specific questions. c) Review and approve the applicable TCRs. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 41 Page 587 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 4.5 Implementation of Mobile Enterprise 4.5.1. Implementation Process Overview Major Task Description Overview CentralSquare Consultant will complete Mobile configuration options based on related options in CAD Enterprise and Mobile Configuration Sheet once servers are installed at Customer site. The same configurations are used as a base for the Functional Test document. Conversion and import of Mobile map and layers needed for Go -Live are also completed. All activities are performed remotely. Customer Participants CAD/Mobile Administrators and core members of Customer implementation team who can address key points and make decisions to complete Mobile System configuration. Output Completed Mobile configuration. The CentralSquare Consultant will provide ongoing consultation services. 4.5.2. MobileX Enterprise Configuration The CentralSquare MobileX Enterprise handheld device is an app designed to run on both iOS platforms and Android devices. Detailed incident and unit information is readily accessible from smartphones and tablets. 4.5.2.1.1 CentralSquare Responsibilities a) Provide the Customer with the applicable steps to download the MobileX Enterprise application from the Application store. b) Guide the Customer through the download process and the applicable configurations needed. c) Validate the MobileX Enterprise handheld device is working in the installed environment. d) Prepare and submit a TCR upon completion of the installation. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 42 Page 588 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 4.5.2.1.2 Customer Responsibilities a) Provide a list of agencies and number of licenses per agency for configuration. b) Perform all required network configurations as advised by the CentralSquare Consultant prior to the configuration event. c) For any staff member that is attending the Mobile Train -the -Trainer training session, the handheld device should be installed and configured prior to the class. d) Review and approve the applicable TCR. 4.5.3. Mobile Enterprise Functional Testing Major Task Description Overview Customer leads and CentralSquare will assist with FAT), which is an activity occurring in conjunction with the CAD FAT and prior to end user training and Go -Live. Since the focus of the FAT is functionality of the System but not a validation of Codefiles, it is not necessary that Mobile is completed prior to conducting the Functional Test. The FAT process consists of running standard tests in a format designed to verify the functionality of Mobile Enterprise. Functional Test documents are submitted and approved by Customer prior to testing in acknowledgement that the test scenarios will be used to validate System functionality for pre- production and Post Go -Live assessment of features for Software Acceptance. Script sign off is a precursor to administration of the Functional Test. Following the completion of the Functional Acceptance Test, any failure will be classified based on the following criteria: Go -Live Issues: Issues in the subsystem identified during Functional Acceptance Testing with contractually required functionality that must be corrected prior to Go -Live. CentralSquare will research such identified issues and propose a plan for resolution. Go -Live Issues will be corrected prior to Go -Live. Completion of the Functional Test does not constitute Final System Acceptance. Customer Participants Key members of implementation team familiar with Mobile Enterprise. Duration As noted in Appendix Y — Workshop and Training Summary. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 43 Page 589 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Output Dubuque PD, IA ONESolution to Enterprise Migration Upon completion, Customer's Mobile Enterprise system is acknowledged as having completed pre -production Acceptance. Customer and CentralSquare will review Functional Test exceptions (if any), perform an assessment, and determine the timeline for remedying the exceptions (pre versus Post Go -Live). CentralSquare will not train Customer's end users until the Functional Test has been conducted and TCR signoff has been received. Customer, with CentralSquare assistance as needed, will repeat failed test(s) following correction of issues that caused the test(s) to fail. A full retest of the System will not be conducted. 4.5.3.1 CentralSquare Responsibilities a) Deliver CentralSquare's standard Functional Test documents to Customer no later than two weeks prior to conducting the Functional Test. b) Provide a TCR to Customer to approve the receipt of the Functional Test documents. c) Install at least one Mobile Customer (device) to conduct the Functional Test. d) Assist Customer in conducting the Functional Test. e) Identify and document any exceptions discovered during the Functional Test. f) Upon completion of the Functional Test, provide a TCR to Customer for review and approval. Functional Test exceptions will be documented in the TCR. Schedule follow-up testing for validation of exceptions after correction and confirm/document the results via TCR. h) Provide a final TCR to Customer to confirm resolution of all Go -Live exceptions. g) 4.5.3.2 Customer Responsibilities a) Complete all predecessor tasks to include the base system installation and Codefile build required to conduct the Functional Acceptance Test. b) Provide adequate environment to conduct the Functional Test. c) Review and sign d) off on the Functional Test document, via TCR, no later than one (1) week prior to commencement of the Functional Test. e) Lead the Functional Test by providing operational Subject Matter Experts with the authority to provide validation that the tests have passed. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 44 Page 590 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration f) Assist CentralSquare in documenting Functional Test results. g) Review and approve the applicable TCRs. 4.5.4. Mobile Enterprise Training Mobile Enterprise Training classes are conducted based on the quantities specified in the Agreement and are conducted on consecutive weekdays during business hours. Alternate training schedules (multiple classes per day, evening, and weekend classes) are subject to additional charge. Training classes will only be delivered after the Functional Test has been completed and the results are documented and approved via TCR. CentralSquare trains a small group of trainers/users, who then train the balance of field users. Refer to Appendix Y - Workshop and Training Summary for a complete listing applicable to this project. 4.5.4.1 CentralSquare Responsibilities a) Schedule training classes. b) Conduct training classes. c) Prepare and submit a TCR to Customer upon completion. 4.5.4.2 Customer Responsibilities a) Schedule appropriate Customer staff to attend training. b) Provide adequate environment for the execution of training to include seating for each workstation and an overhead projector. c) Review and approve the applicable TCRs. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 45 Page 591 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 4.6 Implementation of Records Enterprise Records Enterprise is implemented through a series of standard steps and process gates designed to ensure that operational needs are identified, configurations are verified, and tested to validate the proper functionality prior to Go -Live. 4.6.1. Records Enterprise Implementation Process Overview Major Task Description System Orientation Initial activity to kick off work on deliverable. Workshops CentralSquare and Customer will conduct workshops as indicated in the approved Project Schedule. Base System Build After Records Enterprise Administration and Review Training, Customer assumes ownership of building and maintaining modules and templates. Functional Acceptance Testing Conducted prior to the start of End User Training. Training As indicated in the approved Project Schedule. Go -Live The application is brought into production use. 4.6.2. Records Enterprise Pre -Configuration and Review Major Task Description Overview The Pre -Configuration Questionnaire is a forum that provides CentralSquare and the Customer the opportunity to identify current operational practices that can continue to be utilized with little or no changes. The information garnered will be applied to the Provisioning Guide. Customer Participants Records Administrators and core members of Customer implementation team who can address key points and make business process decisions. CentralSquare Project Manager will work with Customer PM to determine the appropriate number of attendees for each breakout group. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 46 Page 592 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 4.6.2.1 CentralSquare Responsibilities a) Provide the Pre -Configuration Questionnaire. b) Schedule the review meeting in accordance with Customer's availability and the Project Schedule. c) Prepare and distribute meeting agendas and documents for Customer review or completion prior to each meeting. d) Conduct the meetings based on a distributed agenda. e) Document and assign owners and due dates to action items and track to closure. f) Prepare and submit a TCR upon completion of relevant activities. 4.6.2.2 Customer Responsibilities a) Ensure participation of key stakeholders and decision -makers in the process. b) Complete the Pre -Configuration Questionnaire. c) Attend review meeting with the appropriate key stakeholders and decision makers. d) Review and approve applicable TCRs. 4.6.3. Records Enterprise Base System Build Major Task Description Overview After completion of the Records Enterprise Administration and Review Training, and through subsequent workshops and training classes, Customer assumes ownership of completion and ongoing maintenance of system. Customer Participants Records Enterprise Administrators and core members of Customer implementation team who can address key points and make configuration decisions while participating in the system building process. Output After initial build by CentralSquare Consultant, Customer completes and maintains system files and templates, to include Personnel, Roles, Property Locations, and Violation Codes. CentralSquare delivers the Records Enterprise system with base NCIC and NIBRS codes. It is Customer's responsibility to complete NIBRS code -mapping to Violation Codes. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 47 Page 593 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration CentralSquare does not provide training or assistance with Customer's understanding of State or Federal IBRS requirements or laws. CentralSquare services are reserved exclusively to the configuration and use of Records Enterprise to collect and output state or federal required data. No conversion of historical incident data from UCR to NIBRS is included. As a result, there may be historical records that will contain missing NIBRS mandatory fields. The CentralSquare Consultant will provide ongoing consultation services. 4.6.3.1 CentralSquare Responsibilities a) Monitor and evaluate System build throughout implementation and provide guidance as needed. 4.6.3.2 Customer Responsibilities a) Provide timely input and updates to Templates, Workflows, Users, Roles, and System codes. b) Continue and complete building the Templates, Workflows, Users, Roles, and System files (those not built by CentralSquare). Note: Any changes required to Records Enterprise templates required for standard or custom Interface work is the responsibility of Customer. 4.6.4. Geographical Information Services 4.6.4.1 Data Evaluation The CentralSquare GIS Analyst will work with Customer to create the address locator packages and configure Records GIS services. Each GIS layer type (street centerlines and address points) must be delivered and maintained in a single layer. 4.6.4.2 CentralSquare Responsibilities a) Evaluate Customer -supplied GIS data to ensure it is formatted correctly for creation of the address locator packages. b) Create address locator packages and configure Records GIS services. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 48 Page 594 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration c) Prepare and submit a TCR upon completion. 4.6.4.3 Customer Responsibilities a) Provide data in the required format, and per Project Schedule. b) Based on the analysis provided by CentralSquare, make requested changes to mapping data to meet CentralSquare's GIS data requirements. c) Review and approve the appropriate TCR. 4.6.5. Records Enterprise Workshops CentralSquare will conduct Records Enterprise workshops after the Records Enterprise Administration and Review Training has been completed. Workshops are specified in the Agreement but include: Records Enterprise Workshop #1 — Templates #1 Review, configuration, and completion of the Incident, Arrest, Case Management, Crash, Citation (if applicable), Civil and/or Warrants (if applicable), Field Interview, and Other Event modules including the queues, templates, and code tables. Records Enterprise Workshop #2 — Records Administration/State Reporting Review, training and testing of the Records Administration tasks including the redaction, expungement, searching, validations, and State Reporting. Records Enterprise Workshop #3 — Property & Evidence Configuration and setup of the Evidence module to include: evidence storage locations, barcode labeling and scanning evidence, performing inventory, and tracking chain of custody for evidence items. Participants include key members of Customer's implementation team to include Records central and local administrators, and each key functional area, and should not exceed ten (10) students. Refer to Appendix Y - Workshop and Training Summary for a complete listing applicable to this project. 4.6.5.1 CentralSquare Responsibilities a) Schedule workshops in accordance with Customer's availability and the Project Schedule. b) Prepare and distribute the meeting agendas and documents for Customer review or completion prior to each workshop. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 49 Page 595 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration c) Conduct workshops based on the distributed agenda. d) Prepare and submit a TCR upon completion of the workshop. 4.6.5.2 Customer Responsibilities a) Provide adequate environment to conduct the workshop. b) Ensure participation of the appropriate personnel. c) Continue system building activities as directed. d) Review and approve the applicable TCR. 4.6.6. Records Enterprise Functional Acceptance Testing Major Task Description Overview Customer leads and CentralSquare will assist with FAT, which is an activity occurring prior to End User Training and Go -Live. Since the focus of the Functional Test is functionality of the System but not a validation of Codefiles, it is not necessary that all Codefiles be built prior to conducting the Functional Test. The Functional Test process consists of running standard tests in a format designed to verify the functionality of Records Enterprise. Functional Test documents are submitted and approved by Customer prior to testing in acknowledgement that the test scenarios will be used to validate System functionality for pre -production and Post Go -Live assessment of features for Software Acceptance. Script sign off is a precursor to administration of the Functional Test. CentralSquare may organize at its discretion, separate breakout Functional Test sessions for subsections of the Functional Test documents that are applicable only to one agency (for example, applicable only to a Sheriffs Department or single agency). Each test will be executed once, and all applicable users and agencies must attend the Functional Test session and observe the tests. Following the completion of the FAT, any failure will be classified based on the following criteria: Go -Live Issues: Issues in the subsystem identified during Functional Acceptance Testing with contractually required functionality that must be The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 50 Page 596 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration corrected prior to Go -Live. CentralSquare will research such identified issues and propose a plan for resolution. Go -Live Issues will be corrected prior to Go -Live. Post Go -Live Issues: Issues in a subsystem with contractually required functionality that can be corrected after Go -Live. Customer and CentralSquare will mutually agree these issues may be addressed after Go - Live. CentralSquare will provide an estimated date for resolution of the issue Post Go -Live Completion of the Functional Test does not constitute Final System Acceptance. Customer Participants Key members of the implementation team familiar with Records Enterprise and should not exceed five (5) per class. Output Upon completion, Customer's Records Enterprise system is acknowledged as having completed pre -production Acceptance. Customer and CentralSquare will review Functional Test exceptions (if any), perform an assessment, and determine the timeline for remedying the exceptions (pre versus Post Go -Live). CentralSquare will not begin training until the Functional Test has been conducted and TCR signoff has been received. Customer, with CentralSquare assistance as needed, will repeat failed test(s) following correction of issues that caused the test(s) to fail. A full retest of the System will not be conducted. 4.6.6.1 CentralSquare Responsibilities a) Deliver CentralSquare's standard Functional Test documents to Customer no later than two weeks prior to conducting the Functional Test. b) Provide a TCR to Customer to approve receipt of the Functional Test documents and content thereof. c) Assist Customer in conducting the Functional Test. d) Identify and document exceptions and assess to determine timeline to remedy exceptions (pre versus Post Go -Live). e) Upon completion of Functional Test, provide a TCR to Customer for review and approval. Functional Test exceptions will be documented in the TCR. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 51 Page 597 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration f) Schedule follow-up testing for validation of exceptions after correction and confirm/document the results via TCR. g) Provide a final TCR to Customer to confirm resolution of all Pre Go -Live exceptions. 4.6.6.2 Customer Responsibilities a) Complete all predecessor tasks to include the base system installation and code table entry and configuration to conduct the Functional Test. b) Provide adequate environment to conduct the Functional Test. c) Review and signoff on the Functional Test documents no later than one week prior to commencement of the Functional Test via TCR. d) Lead the Functional Test by providing operational subject matter experts with the authority to provide validation the tests have passed. e) Assist CentralSquare in documenting Functional Test results. f) Review and approve the applicable TCRs. 4.6.7. Records Enterprise Training Records Enterprise Training classes are conducted on consecutive weekdays during business hours (Tuesday -Friday). Alternate training schedules (multiple classes per day, evening, and weekend classes) are subject to additional cost. Training classes are conducted based on the quantities that are specified in the Agreement. The appearance of a course description in this Statement of Work does not mean a course will be conducted — it must be listed in the Agreement. Refer to Appendix Y - Workshop and Training Summary for a complete listing applicable to this project. 4.6.7.1 CentralSquare Responsibilities (for all Records Enterprise Training) a) Schedule the Records Enterprise Training class(es) in accordance with Customer's availability and the Project Schedule. b) Prepare and distribute agendas and documents prior to each meeting. c) Develop and provide the Records Enterprise Training Plan. d) Conduct session(s) per the Schedule. e) Prepare and submit a TCR upon completion of each class, or a group of consecutive classes. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 52 Page 598 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 4.6.7.2 Customer Responsibilities (for all Records Enterprise Training) a) Provide adequate environment for execution of training. b) Provide a Local Records Administrator for each class to answer agency specific questions related to the build of Customer's system and internal policies or workflow. c) Provide schedule for training remaining end users. d) Review and approve applicable TCRs. 4.7 Implementation of Jail Enterprise Jail Enterprise is implemented through a series of standard steps and process gates designed to ensure the operational needs of Customer are identified, configurations are verified, and the system is tested to validate the proper functionality of the system prior to Go -Live. Jail Enterprise Modules The software detailed in the following section includes, but is not limited to, the listed functionality. Jail (Core) • Booking, Intake, and Release Wizard • Cell Occupancy Log • Activities • Basic Bank • Issued Property • Medicine • Jail Billing • Bond Payments • Sentence calculation and Good Time Jail Reporting (Core) • Inmate Property • Victim Notification • Visitor logging • Jail Log • Shift Log • Court Events • Classification • Cell Recommendation • Inmate Classes and Transportation • Full audit trail • Pre -defined reports • Custom reports • Ad -hoc reports • Drag and drop report building • Export to PDF, XLS, XML, TXT • Custom data filters • Statistical analysis • Scheduled reports • COMSTAT compatible • Emailed reports The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 53 Page 599 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Jail Financial (Core) • Double -entry accounting • Automatic invoice creation • Configurable addition of fees based on Records workflow • Account reconciliation Jail Personnel (Core) • Receipt generation • Statement printing • Bulk Invoice Payments • Full audit trail • Personnel Log Jail Personnel Advanced • Full audit trail • Commendations • Disciplinary Actions • Positions • Promotions Jail Advanced • Service History • Training • Citizen Feedback • Advanced Inmate Bank • Expenses • Expungement Log • Sentence Reductions • Inmate Checks Jail Administration (Core) • Inmate Work Shifts • Stay Scheduling (Weekenders) • Multiple Facilities • Jail workflow • Custom Forms • Equipment • Fleet Management • Inventory Management • Purchase Requisitions • Service Dogs • Policy Manual • Full audit trail • Custom Forms 4.7.1. Jail Enterprise Implementation Process Overview Major Task Description Workshops CentralSquare and Customer will conduct workshops as indicated in the approved Project Schedule. Base System Build Customer assumes ownership of building and then maintaining Code Files. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 54 Page 600 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Functional Acceptance Testing Dubuque PD, IA ONESolution to Enterprise Migration Comprehensive functional testing is conducted prior to start of End User Training. Training As indicated via the approved Project Schedule. Go -Live The application is brought into production use. 4.7.2. Jail Enterprise Administration and Review Workshop Major Task Description Course Overview Hands-on course for Jail System Administrators which occurs once the system has been installed. Includes a demonstration of software functionality. System configuration, to include: cell location, inmate tracking, additional facilities, booking process, intakes, inmate management, keep separates. Customer Participants Jail Administrators and core members of Customer implementation team. Participants should not exceed ten (10) per class. Duration Up to four (4) days, contingent upon Jail modules. Output After the class concludes, ownership of the Jail Enterprise build transfers to Customer for completion and ongoing maintenance of Code Files. Customer will enter remaining code files, maintain users, and complete the Jail Enterprise build. Customer must keep Personnel, Offense Codes, Property Locations, etc. continuously updated to ensure they are in Go -Live ready status. The CentralSquare consultant will provide ongoing consultation services. 4.7.2.1 CentralSquare Responsibilities a) Schedule the Jail Enterprise Administration and Review Workshop in accordance with Customer's availability and the Project Schedule. b) Prepare and distribute the meeting agenda and documents for Customer review or completion to all required attendees two weeks prior to the training. c) Conduct the meetings based on the distributed agenda. d) Create a project checklist itemizing the tasks for completion throughout the implementation. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 55 Page 601 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration e) Prepare and submit a TCR upon completion of the training. 4.7.2.2 Customer Responsibilities a) Provide adequate environment to comfortably hold the training activities. b) Ensure participation of the appropriate personnel. c) Continue the code file building activities after completion of this training. d) Review and approve the applicable TCR. 4.7.3. Jail Enterprise Base System Build Major Task Description Overview After completion of the Jail Enterprise Administration and Review, and through subsequent workshops and training classes, Customer assumes ownership of completion and ongoing maintenance of system code files, personnel, and roles. Administration Module Training may include: Fleet Management Equipment Inventory Service Dogs Purchase Requisitions Policy Manual Citizen Feedback The CentralSquare Consultant will schedule remote sessions with Customer to ensure progress and address questions or concerns. Continual validation through implementation until FAT limits risk of error and rework. Customer Participants Jail Enterprise Administrators and core members of Customer implementation team who can address key points and make configuration decisions while participating in the system building process. Duration As noted in the Project Schedule. Output After initial build by CentralSquare Consultant, Customer completes and maintains system files and templates, to include Personnel, Roles, Property Locations, and Violation Codes. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 56 Page 602 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration CentralSquare delivers the Jail Enterprise system with base NCIC and NIBRS codes. It is Customer's responsibility to complete NIBRS code -mapping to Violation Codes. The CentralSquare Consultant will provide ongoing consultation services. 4.7.3.1 CentralSquare Responsibilities a) CentralSquare is responsible for the monitoring and evaluation of the System build throughout the implementation and provide guidance as needed. 4.7.3.2 Customer Responsibilities a) Provide timely input and updates to the Code tables, Users, Roles, and other applicable system codes. b) Continue building and maintaining the Users, Roles, and System Code Files (those not built by CentralSquare) through completion. 4.7.4. Jail Enterprise Functional Acceptance Testing Major Task Description Overview The CentralSquare Consultant assist Customer with Functional Test prior to the start of End User Training. The Functional Test is based on a standard CentralSquare document with standard content and format. Customer will receive document for review prior to conducting the Functional Test. CentralSquare may organize at its discretion, separate Functional Test breakout sessions for subsections that are applicable only to one agency (for example, applicable only to a Sheriff's Department or single agency). Each test will be executed once, and all applicable users and agencies must attend the Functional Test session. Following the completion of the FAT, any failure will be classified based on the following criteria: Go -Live Issues: Issues in the subsystem identified during Functional Acceptance Testing with contractually required functionality that must be corrected prior to Go -Live. CentralSquare will research such identified issues The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 57 Page 603 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration and propose a plan for resolution. Go -Live Issues will be corrected prior to Go - Live. Post -Go -Live Issues: Issues in a subsystem with contractually required functionality that can be corrected after Go -Live. Customer and CentralSquare will mutually agree these issues may be addressed after Go -Live. CentralSquare will provide an estimated date for resolution of the issue Post Go -Live Completion of the Functional Test does not constitute Final System Acceptance. Customer Participants Should include core members of Customer implementation team. Participants should not exceed five (5) per class. Duration As noted in Appendix Y - Workshop and Training Summary Output Customer denotes pass/fail or N/A for each test. Upon completion of the Functional Test, Customer and CentralSquare review the list of failures (if applicable) and perform an assessment to determine if any represent critical errors and determine the timeline to remedy critical issues (pre versus Post - Go -Live). Functional Test results are documented via TCR for verification and approval. Customer, with CentralSquare assistance as needed, will re -test failed tests to confirm correction of each issue. This process will not include a repeat of the entire Functional Test. 4.7.4.1 CentralSquare Responsibilities a) Deliver CentralSquare's standard Functional Test document to Customer no later than two weeks prior to conducting the Functional Test. b) Provide TCR to Customer to approve the receipt of the Functional Test document. c) Assist Customer in conducting the Functional Test in accordance with Functional Test document. d) Identify and document any issues discovered during the Functional Test. e) Upon completion of Functional Test, prepare and submit a TCR to Customer, including a list of any exceptions to Functional Test. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 58 Page 604 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 4.7.4.2 Customer Responsibilities a) Ensure timely completion of all predecessor tasks to include the base code table entry and configuration. b) Provide adequate environment to execute the Functional Test. c) Lead the Functional Test by providing operational subject matter experts. d) Assist CentralSquare in documenting Functional Test findings and results. e) Review and approve the appropriate TCRs. 4.7.5. Jail Enterprise Training Jail Enterprise Training classes are conducted on consecutive weekdays (Tuesday -Friday) during business hours. Alternate training schedules (multiple classes per day, evening, and weekend classes) will be subject to additional charge. Training classes will only be delivered after the Jail Enterprise Functional Test has been completed and the results are documented. Training will be scheduled within standard business hours (8:OOam to 5:OOpm local time, Tuesday through Friday). Refer to Appendix Y - Workshop and Training Summary for a complete listing applicable to this project. 4.7.5.1 CentralSquare Responsibilities a) Schedule the Jail Enterprise Training class(es) in accordance with Customer's availability and the Project Schedule. b) Prepare and distribute the meeting agendas and documents for Customer review or completion to all required attendees two weeks prior to each meeting. c) Conduct the training session(s) for the licensed product options on a mutually agreed -to schedule. d) Prepare and submit a TCR upon completion of each class, or a group of consecutive classes. 4.7.5.2 Customer Responsibilities a) Provide adequate environment for the execution of the training to include adequate seating for each workstation and an overhead projector. b) Provide a Local Jail Administrator for each class that can answer agency specific questions related to the build of Customer's system. c) Review and approve the applicable TCRs. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 59 Page 605 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 4.7.6. Jail Enterprise End User Training Major Task Description Overview Course content will reflect the features in Jail Enterprise that each functionality group will utilize and may include: Jail Booking/Release Jail Activities/Transportation/Head Count Jail Court Events/Bond Payments/Stay Scheduling Jail Incidents/Disciplinary Actions Jail Incidents/Disciplinary Actions/Case Entry Jail Medical Jail Advanced Inmate Bank (if purchased) Jail Extend (On Tablet) — Activities/Medical (if purchased) Customer Participants Participants from each applicable functionality group. Participants should not exceed ten (10) per class. Duration As noted in Appendix Y - Workshop and Training Summary. Output Prepares Customer staff for operation in a production environment. Prerequisite Completion of Suite Basic training and permission granted for the applicable feature and related tasks. Basic understanding of computers and Windows environment The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 60 Page 606 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 4.7.7. Jail Enterprise Report Generation Training Major Task Description Overview If purchased, CentralSquare will provide training on the Report Generator, which provides user the ability to create reports and define them either as recurring reports and/or as dashboard components. Participants will learn how to create a report, group/sort data, add a graph, and either create the report as a dashboard component or a recurring report. Customer Participants Participants from each applicable functionality group. Participants should not exceed ten (10) per class. Duration As noted in Appendix Y - Workshop and Training Summary. Output Prepares Customer staff for operation in a production environment. Prerequisite Completion of Suite Basic training and end user training for one of the following: CFS, Jail, or Records; must have permission granted for the applicable feature and related tasks. Basic understanding of computers and Windows environment The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 61 Page 607 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 4.8 Implementation of Common Identity Management (CIM) Once the Software Installation is complete, the CentralSquare Technical Services Engineer and Consultants will configure a Common Identity Management (CIM) instance in each environment that will provide identity management and authentication services for the Enterprise Suite applications. 4.8.1. CIM Configuration Major Task Description Overview CentralSquare, with the participation of the Customer, will configure CIM with roles. Mapping of CAD/Records roles to CIM roles. Linking the role mappings within CIM. Active Directory integration for each Active Directory domain which is to be integrated with CIM. Importing/associating CAD/Records users with CIM users. Customer Participants Administrators of the CAD/Records applications. Participants must be able to make decisions regarding configurations in the system for the CAD/Records applications. Testing of configurations deployed by CentralSquare. Training CIM Systems Administration Training Two (2) hour training performed remotely. Output CAD/Records user management will be centralized to the CIM application. Users will be able to use one (1) user account to access each of the systems. 4.8.1.1 CentralSquare Responsibilities a) Configure a Common Identity Management (CIM) instance in each environment. b) Schedule the working sessions in accordance with Customer's availability and the Project Schedule. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 62 Page 608 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 4.8.1.2 Dubuque PD, IA ONESolution to Enterprise Migration c) Conduct the working sessions based on the schedule and provide assignments as necessary to Customer. d) Ensure the module is functioning per the configuration. e) Conduct Administrative training. f) Prepare and submit a TCR upon completion of the deliverable. Customer Responsibilities a) Ensure participation of appropriate personnel for each scheduled activity. b) Complete all assignments on a timely basis. c) Review and approve the applicable TCR. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 63 Page 609 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 4.9 System Integration Testing Once the Functional Test is concluded for CAD Enterprise, Mobile Enterprise, Records Enterprise, and interfaces and in preparation for Go -Live, CentralSquare and Customer will conduct System Integration Testing, with CentralSquare assisting remotely. The System Integration Test will be conducted based on scenarios that test call flow from creation to final disposition in CAD and include CAD and Mobile Enterprise, and Interfaces that can be tested in the pre -production environment and are scheduled to Go -Live at the same time. It is recommended that Customer utilize sample calls from their legacy System. A small group of Customer staff (1-2 dispatchers and 1-2 Mobile field users) should participate in this test with CentralSquare Consultant. CentralSquare will work with Customer on defining a set of test scenarios to test the system based on Customer's practices; the scenarios must be signed off prior to commencement of the System Integration Test. A small group of Customer staff (1-2 Records staff and field users) should participate in this test. CentralSquare will work with Customer to refine the test scenario that test the system based on Customer's practices and must be signed off prior to commencement of the System Integration Test. At the completion without critical issues that prevent the System to be taken Live, Customer shall provide TCR approval that the System is ready for Go -Live. 4.9.1. CentralSquare Responsibilities a) Schedule System Integration Test with Customer. b) Assist Customer in preparing test scenarios based on Customer's practices, no later than six (6) weeks prior to conducting the System Integration Test. c) Deliver CentralSquare's standard System Integration Test document to Customer for review no later than two (2) weeks prior to conducting the System Integration Test. d) Provide a TCR to Customer to approve receipt of System Integration Test document and content thereof. e) Assist Customer in conducting the System Integration Test. f) Identify and document exceptions and passes to determine timeline to remedy exceptions (Go -Live versus Post Go Live). Upon completion of System Integration Test, provide a TCR to Customer for review and approval. System Integration Test exceptions will be documented in the TCR. h) Schedule follow-up testing for validation of exceptions after corrections and confirm/document the results via TCR. g) The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 64 Page 610 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration i) Provide a final TCR to Customer to confirm resolution of all Go -Live exceptions. 4.9.2. Customer Responsibilities a) Provide adequate environment to conduct the System Integration Test. b) Provide test systems (or pre -production systems) for all integrations and interfaces. If Customer cannot provide a test system CentralSquare must test using the production system. This testing includes, but is not limited to, test data entry in a production system. c) Provide test scenarios that closely simulate Customer's normal call flow no later than six (6) weeks prior to conducting the System Integration Test. d) Review and sign off on the System Integration Test document, via TCR, no later than one (1) week prior to commencement of the System Integration Test. e) Participate in conducting the System Integration Test by providing operational Subject Matter Experts with the authority to provide validation that the tests have passed.. f) Assist CentralSquare in documenting System Integration Test results. g) Review and approve the applicable TCRs. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 65 Page 611 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 4.10 Implementation of Citizen Reporting The Citizen Reporting implementation will begin when the Incident Module configuration has been completed and the overall Records Enterprise build is approximately 75% complete. When the configuration build has been completed and functionality verified, the module will allow citizens the ability to perform simple searches, download reports, and submit non - emergency incidents. Citizen Reporting is implemented through a series of standard steps and process gates designed to ensure that proper installation is completed, configurations are verified, and tested to validate the proper functionality prior to Go -Live. 4.10.1. Citizen Reporting Implementation Process Overview Major Task Description Overview CentralSquare will conduct working sessions with Customer to determine the proper configuration settings for the module, as well as the functionality associated with Incident reports submitted by Citizens via the portal. This will include building code tables, picklists, system settings and assignment of security permissions. Base System Build Upon completion of installation and working sessions, Customer assumes ownership of the base build. CentralSquare will provide guidance and support as applicable. Training As indicated in the approved Project Schedule. Go -Live The application is brought into production use. Pre -requisite Records Enterprise build is approximately 75% complete. 4.10.2. Citizen Reporting Base System Build Major Task Description Overview After completion of the Installation and initial working sessions, Customer assumes ownership of ongoing maintenance of system. Customer Participants Citizen Reporting Administrator and/or the Enterprise System Administrator who can address key points and make configuration decisions while participating in the system implementation process. Output After initial build by CentralSquare Consultant, Customer will monitor the installation and base build. Then, attend administration and user training (train the trainer) for the application. The CentralSquare Consultant will provide ongoing consultation services. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 66 Page 612 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 4.10.2.1 CentralSquare Responsibilities a) Conduct the working sessions based on the schedule and provide assignments as necessary to Customer. b) Ensure the module is functioning per the configuration. c) Prepare and submit a TCR upon completion of the deliverable. 4.10.2.2 Customer Responsibilities a) Ensure participation of appropriate personnel for each scheduled activity. b) Complete all assignments on a timely basis. c) Review and approve the applicable TCR. 4.10.3. Citizen Reporting Training Citizen Reporting training classes are conducted on consecutive weekdays during business hours (Tuesday -Friday). Alternate training schedules (multiple classes per day, evening, and weekend classes) are subject to additional cost. Training classes are conducted based on the quantities that are specified in the Agreement. Refer to Appendix Y - Workshop and Training Summary for a complete listing applicable to this project. 4.10.3.1 CentralSquare Responsibilities (for all Citizens Reporting Training) a) Schedule the Citizens Reporting Training class(es) in accordance with Customer's availability and the Project Schedule. b) Provide the training materials. c) Conduct session(s) per the Schedule. d) Prepare and submit a TCR upon completion of each class, or a group of consecutive classes. 4.10.3.2 Customer Responsibilities (for all Citizens Reporting Training) a) Provide adequate environment for execution of training. b) Provide an Administrator for each class to answer Customer specific questions related to the application's use, internal policies, or workflow. c) Provide schedule for training remaining end users. d) Review and approve applicable TCRs. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 67 Page 613 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 4.11 Implementation of CrimeView Analytics CrimeView Analytics will be implemented through a series of standard steps and process gates. 4.11.1. CrimeView Analytics Implementation Process Overview Major Task Description Discovery Discovery includes the Kickoff meeting and the requirements review & collection required for the implementation. Mapping and & Configuration CentralSquare will map Customer code values to standard categories to enable CrimeView map symbology. The CentralSquare GIS/Analytics Specialist will configure and automate the ETL (Extract, Transform, and Load) process that securely replicates data to the cloud CrimeView environment, and configure the user application. Demonstration After the completing the Mapping and Configuration, CentralSquare will provide Initial Demonstration, Consultation, and Content Preparation. Customer assumes ownership of the base system build at the conclusion of the demonstration, consultation & content preparation. Training As indicated in Appendix Y. System Review The system review period begins after the Administrator/Designer Training and closes ten (10) business days after Train the Trainer. Acceptance Application is accepted at conclusion of System Review. Prerequisite Enterprise applications in production. 4.11.2. Discovery The Discovery includes a kickoff meeting and the requirements review & collection. The Kickoff meeting provides a review of the application's functionality and project deliverables, Customer prerequisites, and implementation process. Furthermore, the Customer's preparation and delivery of prerequisites to the CentralSquare project team is a critical gate for starting implementation work. 4.11.2.1 CentralSquare Responsibilities a) Schedule and lead the meeting. b) Provide action items. c) CentralSquare is responsible for providing Hardware, GIS, and any other requirements details to Customer during and following the kickoff meeting. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 68 Page 614 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 4.11.2.2 Customer Responsibilities a) Configure the CrimeView import server and provide CentralSquare with a local administrator account. b) Collect and deliver the GIS data to be used for the application to CentralSquare. c) Configure Hardware, including creation of a CentralSquare local administrator account on the import server. d) Provide required GIS data. 4.11.3. Code Mapping & Application Configuration CentralSquare will map Customer code values to standard categories to enable CrimeView map symbology. The CentralSquare GIS/Analytics Specialist will configure and automate the ETL (Extract, Transform, and Load) process that securely replicates data to the cloud CrimeView environment, and configure the user application. 4.11.3.1 CentralSquare Responsibilities a) Extract code tables from Customer's CAD and/or Records Enterprise system and match to standard code sets. b) If necessary, provide Customer with an Excel document to review code mapping. c) Configure the ETL process and CrimeView application. d) Prepare standard dashboards for initial demonstration. 4.11.3.2 Customer Responsibilities a) Review and revise code mapping within five (5) business days. b) Respond to information, data, and assistance requests. c) Work with the CentralSquare Project Manager to facilitate a date for the Application Review Meeting. 4.11.4. Initial Demonstration, Consultation, and Content Preparation The CentralSquare GIS/Analytics Specialist will provide a short demonstration of the system with Customer's data and lead a discussion of Customer needs and how the system might meet those needs. 4.11.4.1 CentralSquare Responsibilities a) Schedule the initial demonstration in accordance with the Customer's availability and the Project Schedule. b) Schedule and lead the initial demonstration and collect Customer feedback. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 69 Page 615 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 4.11.4.2 Customer Responsibilities a) Customer is responsible for having the appropriate users and stakeholders attend the initial demonstration and participate in follow-up conversations. 4.11.5. CrimeView Training Training is conducted on consecutive weekdays during business hours. Alternate training schedules (e.g., Monday class starts for classes that would normally start on a Tuesday, multiple classes per day, evening, and weekend classes) are subject to additional cost. Training classes are conducted based on the quantities specified in the Agreement. The appearance of a course description in this Statement of Work does not mean a course will be conducted — it must be listed in the Agreement. Refer to Appendix Y - Workshop and Training Summary for a complete listing applicable to this project. 4.11.5.1 CentralSquare Responsibilities (for all Search Training) a) Schedule the Search Training class(es) in accordance with Customer's availability and the Project Schedule. b) Provide the training materials. c) Conduct session(s) per the Schedule. d) Prepare and submit a TCR upon completion of each class, or a group of consecutive classes. 4.11.5.2 Customer Responsibilities (for all Search Training) a) Provide adequate environment for execution of training. b) Provide an Administrator for each class to answer Customer specific questions related to the application's use, internal policies, or workflow. c) Provide schedule for training remaining end users. d) Review and approve applicable TCRs. 4.11.6. System Review The system review period begins after the Administrator/Designer Training and closes ten (10) business days after Train the Trainer. During the System Review, Customer is responsible for reviewing the application and informing the CentralSquare project team of any noticed or potential issues or deficiencies with the configuration or data. CentralSquare will address the reported items during and following the review period; CentralSquare responses will fall into one of the following categories: The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 70 Page 616 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration a) Item refers to something in the application or data import configuration that has been confirmed and fixed/changed. b) Further information or action from Customer is required to assess the item (a time window for Customer action will be provided). c) Item is a result of Customer's source data and requires Customer action to fix (a time window for Customer action will be provided). d) Item identifies a software bug that has been submitted for review and rectification. e) Item represents a requested enhancement to the software. Software enhancements are not included in the scope of the project but may be undertaken at CentralSquare's Product Management discretion. 4.11.6.1 CentralSquare Responsibilities a) Inform Customer that the System Review period has begun; provide the review items listed above. b) Receive and address all items/issues submitted by Customer during the System Review. c) Prepare and submit a TCR upon completion of each class, or a group of consecutive classes. 4.11.6.2 Customer Responsibilities a) Interact with the system and create new content after the Administrator/Designer Training. b) Inform the CentralSquare Project Manager of any questions, issues, or requested configuration changes. c) Review and approve applicable TCRs. 4.11.7. CrimeView Analytics Acceptance The Crime Analytics Dashboard application will be considered Accepted upon completion of the System Review. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 71 Page 617 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 5 SYSTEM AND SUBSYSTEM PRE GO -LIVE TASKS 5.1 Overview Preparation for cutover to live operations will be outlined in the weeks leading up to the Go -Live in the Project Schedule and in the Go -Live Plan. The Go -Live plan includes: a) The overall timeline for the event b) Products involved c) Roles and responsibilities d) Established meeting dates/times e) Issue reporting and escalation process f) Transition to support g) The communication plan CentralSquare will prepare a Pre Go -Live checklist for each Subsystem and the Interfaces, if applicable, identifying the activities that will ensure preparation. The list will identify both CentralSquare and Customer responsibilities for completing the Pre Go -Live activities. Training data will be purged from the system, and the system itself will be locked down. CentralSquare will provide the Customer with a Go -Live Authorization Letter. The Go - Live Authorization Letter confirms the system has been installed and tested, and that the Customer agrees to proceed with moving the system to live operation. It acknowledges sufficient user training has been completed, confirms software is functional for a live environment, and that none of the currently identified issues are critical to the Go -Live. This letter will list all the Subsystems and Interfaces, if applicable, scheduled for the Go -Live, as well as any exceptions. The date and time of the Go -Live is memorialized, along with assurance that the Customer's technical team and Subject Matter Experts will be available twenty four (24) hours a day to support the CAD/Mobile Enterprise Go -Live and standard business hours (8:OOam — 5:OOpm, Monday — Friday for Records and Jail Enterprise unless otherwise noted in the Agreement. The Customer must approve the Go -Live Authorization Letter no later than three (3) weeks prior to Go -Live. Approval of the letter is required. CentralSquare will invite the Customer to participate in a presentation to gain familiarity with the structure and methodologies of the Support Services Department. CentralSquare will assist in confirming that representatives designated by Customer needing access to enter and track support cases have credentials for CentralSquare access. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 72 Page 618 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 5.1.1. CentralSquare Responsibilities a) Schedule internal Go -Live readiness checks and internal team planning meetings. b) Prepare the Go -Live Plan for delivery to Customer. c) Prepare the Pre Go -Live checklist for delivery to Customer. d) Prepare the Go -Live Authorization Letter and deliver to Customer. e) Identify the participants for the Go -Live in accordance with the terms of the Agreement. f) Coordinate CentralSquare personnel in advance of the Go -Live date to complete final tasks as a part of the Go -Live preparations. 5.1.2. Customer Responsibilities a) Complete end user training needed to support the live use of Subsystems. b) Participate in review of the Go -Live Plan. c) Complete prerequisite tasks as directed by CentralSquare. d) Review and approve the Go -Live Authorization Letter no later than three (3) weeks prior to Go -Live. e) Develop a process for the identification of, research, reporting and resolution of issues. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 73 Page 619 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 6 SYSTEM AND SUBSYSTEM GO -LIVE 6.1 Overview Dubuque PD, IA ONESolution to Enterprise Migration Go -Live of the Enterprise Subsystems and the required Interfaces, if applicable, into a live operational environment (i.e., production use) is a highly orchestrated activity that will require resources from both Customer and CentralSquare teams. Go Live is conducted on consecutive weekdays (Monday -Friday). A Go Live that requires CentralSquare support that begins before or extends beyond weekdays (unless included in the Agreement) are subject to additional cost. The system is brought into production per the Go -Live Authorization Letter and the Go -Live Plan. During Go -Live, issues are reported and managed by CentralSquare with Customer's assistance. Upon cessation of Go -Live support by CentralSquare, the issues will be submitted by the Customer using CentralSquare's on-line support system, Salesforce. • "Go -Live" means the event that occurs when the Customer first uses a Subsystem in live operations. A separate Go -Live may take place with respect to each Subsystem, each Interface, and each Modification. • "Go -Live" means "first use in a non -test bed environment". 6.1.1. CentralSquare Responsibilities a) Assist Customer in placing the system into production. b) Assist Customer staff in usage of the system as well as documenting, reporting, and researching issues. c) Provide support during and after system Go -Live as specified within the Agreement. d) Prepare and submit TCR(s) upon first live operation of system in a live environment. e) If applicable, Post Go -Live deliverables will be managed to completion of delivery by the CentralSquare Project Manager per the Agreement. 6.1.2. Customer Responsibilities a) Place the software into production and begin operational use in accordance with the project schedule, Go -Live Plan, and Go -Live Authorization Letter. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 74 Page 620 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration b) Provide adequate persons for the supervision and assistance to end users during Go - Live and beyond the participation of the CentralSquare staff. c) Provide dedicated workstations for CentralSquare support staff use during Go -Live. d) Provide IT support to cover all Customer end user and CentralSquare staff hours of operation. e) Review and approve the applicable TCR(s). The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 75 Page 621 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 7 RELIABILITY PERIOD 7.1 Overview Upon Go -Live of each Subsystem(s), the Customer shall use the Subsystem(s) for a thirty (30) consecutive day period to verify operational functionality in a live (production) environment. The Reliability Period is completed when the Customer uses the Subsystem(s) for a thirty (30) consecutive day period without any Priority 1— Urgent or Priority 2 — Critical software errors (as those terms are defined in the Agreement). In the event that a Priority 1— Urgent or Priority 2 - Critical software error occurs during the Reliability Period, CentralSquare shall commence actions in accordance with the Agreement to correct the reported error. Note: If Subsystems do not Go -Live on the same day, or if agencies and/or PSAPs Go -Live in multiple phases, the Reliability Period for each Subsystem will start the first day that Subsystem goes live and is used in a production environment by any agency and/or PSAP. There will not be a separate Reliability Period as subsequent agencies and/or PSAPs Go -Live. In the event a Priority 1- Urgent software error occurs between day one (1) and day thirty (30) of the Reliability Period, the Reliability Period will be stopped and restarted at day one (1) once the software error has been resolved in accordance with the Agreement. In the event a Priority 2 - Critical software error occurs between day one (1) and day fifteen (15) of the Reliability Period, the Reliability Period will be stopped and restarted from day one (1) once the software error has been resolved in accordance with the Agreement. If the software error occurs between day fifteen (15) and day thirty (30), the Reliability Period will be stopped and restarted from the day the resolution has been provided in accordance with the Agreement. Priority 1- Urgent or Priority 2 — Critical software errors caused by factors that are outside of CentralSquare's control, and/or from variables which are outside the scope of CentralSquare's responsibilities, will not be counted Priority 1- Urgent or Priority 2 software errors. Examples of such issues could be, but are not limited to: • Power failures • Operator error • External network failure • Availability of components that are not provided by CentralSquare but Interface to/from the CentralSquare solution The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 76 Page 622 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration • Hardware or operating system software • Non-CentralSquare supplied software components introduced into the working environment During the Reliability Period, the Subsystem(s) will be frozen, (i.e., no changes, fixes, and/or updates will be applied, except those that are required to address downtime failures associated with the Reliability Period.). At the conclusion of the Reliability Period, as further defined in the Agreement, the Subsystem(s) will be deemed reliable by the Customer and CentralSquare. 7.1.1. CentralSquare Responsibilities a) Provide a TCR to the Customer to document the start of the Reliability Period upon Go -Live of the Subsystem(s). b) Address issues that are reported during this Reliability Period. c) Provide a TCR to the Customer to document any stops and restarts of the Reliability Period. d) Document Priority 3 — Non -Critical and Priority 4 — Minor software errors that are not considered "Reliability Period" issues to be addressed as part of the support and maintenance of the Subsystem. e) Provide the TCR to document completion of the Reliability Period of the Subsystem(s). 7.1.2. Customer Responsibilities a) Review and sign off on the TCR for documenting the start of the Reliability Period upon Go -Live of the Subsystem(s). b) Report issues to the CentralSquare Project Manager when they occur. c) Review and sign off on the TCR for documenting any stops and restarts of the Reliability Period. d) Approve and return the TCR documenting completion of the Reliability Period of the Subsystem(s). The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 77 Page 623 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 8 PROJECT CLOSURE 8.1 Overview Project closure activities commence when all project deliverables have been completed. Support of systems and subsystems will be transitioned to CentralSquare's Support and monitored per the Support Agreement. Major Task Description Post Go -Live Project Deliverables Once complete, ensure CentralSquare Project Manager will provide TCR to Customer for signoff of completed deliverables. Final Audit CentralSquare Project Manager will perform a final audit to ensure all Contractual obligations have been met. A final TCR will be provided to Customer to confirm the project is completed. Final Transition CentralSquare Project Manager performs final transition of Customer to Support who will become the primary conduit for entry, tracking, and resolution of system issues. Customer interaction is officially handed over from the CentralSquare Project Manager to the CentralSquare Support. Project Closure CentralSquare Project Manager performs administrative tasks to archive project documents and close the project. 8.1.1. CentralSquare Responsibilities a) Perform payment reconciliation, deliver final project TCRs which generate remaining invoices. b) Transition the CentralSquare point of contact from the Project Manager to Customer Support Department. c) Provide continued support based on terms of Agreement. 8.1.2. Customer Responsibilities a) Provide approval of final Project TCRs within five (5) business days. b) Process payment of final invoices. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 78 Page 624 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 9 Appendix A - Contracted Modifications to Standard CentralSquare Products Any modifications to standard CentralSquare products and standard system interfaces that are to be delivered through this Project are listed in the Agreement. The functional scope of any modification procured through the Agreement will be summarized in this Statement of Work and defined by an OSD for all items listed. Any and all modifications or enhancements that are not explicitly listed in the Agreement are not within the scope of this Project. Any modification to the functionality of standard CentralSquare products or interfaces, outside the scope of the Agreement, within the system, or subsystems, shall follow the Change Order Process as described in Change Order Process. Any post -approval changes to the requirements documented in the system OSDs or other documents are subject to a formal Change Order. Note: All enhancements and modifications to any of CentralSquare's standard products (including the Interfaces) will only be released with a major version of the applicable subsystem (i.e., CAD Enterprise and the like) based upon the relevance and dependency to these products. Note: Software versioning is the process of assigning either unique version names or unique version numbers to unique states of computer software while a service pack or patch is a piece of software designed to fix problems with or update a computer program or its supporting data. This includes fixing security vulnerabilities and other bugs. Note: Any changes to the requirements documented in approved System OSDs are subject to Change Order. CentralSquare will modify Records Enterprise to add a Receipts feature. The Records Enterprise Receipts feature is used to record payments, print receipts, and search for various record types for receipts. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 79 Page 625 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 10 Appendix B - Standard CentralSquare Interfaces The scope of functionality for these standard interfaces is limited to 1) the capability of the CentralSquare System being interfaced and 2) the capabilities of the external system being interfaced. Descriptions of each of the standard interfaces below will become the basis for the scope of detailed requirements, described in the FDD. Any changes in the requirements documented and approved in the System FDDs are subject to a Change Order. Standard Interfaces Standard Interfaces are included in the Agreement and listed in this SOW. If not explicitly listed in the Agreement, the Interface will not be installed and supported. Standard Interface Description Interface Name Standard ANI/ALI Interface Interface Description The CAD Enterprise E911, ANI/ALI Interface provides a one- way transfer and processing of data from the E911 Controller of the phone system to CAD Enterprise using one of the two available types of package structures: fixed position and delimited fields. The Interface is configurable to process various formats of ANI/ALI data streams —to include certain formats of TTY/TDD emergency calls. Vendor Comtech Subsystem CAD Direction Import Interface Document Name OSD — Standard ANI/ALI Interface Instances Contracted Production, Test Required for Go -Live Yes Standard Interface Description Interface Name Standard CAD to External Incident Data Transfer Interface Description The CAD Enterprise to External System Data Transfer Interface will provide a one-way data transfer of selected CAD Enterprise incident data fields from CAD Enterprise to a single Records Management System (RMS), Reporting Module, or other system external to the CAD Enterprise System. Note: CentralSquare has developed several separate configurations (i.e., data formats and transfer methods) for The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 80 Page 626 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration the Interface to support various external system vendors. Only one format is supported per implementation of the Interface. More than instance of the Interface may be implemented on a single CAD Enterprise system to support multiple vendors or multiple destinations for a single vendor. The output is in CentralSquare's proprietary file format. Vendor ESO Subsystem CAD Direction Export Interface Document Name OSD - CAD -to -External System Publisher Interface Instances Contracted Production, Test Required for Go -Live Yes Standard Interface Description Interface Name Standard EMD Integration Interface Description The CAD Enterprise EMD Integration provides integration between CAD Enterprise and the EMD application. CAD Enterprise allows the user to launch the EMD application automatically within the CAD Enterprise call -taking screen. When the user reaches the applicable field, the EMD application is opened as a window within CAD Enterprise allowing the user to complete the EMD session. Once key trigger points are reached, the incident type and priority are automatically updated. Note: One (1) client license is required per CAD workstation. Only one (1) interface is required for Police, Fire, and EMS. The EMD application must be purchased separately. Vendor Priority Dispatch, ProQA Subsystem CAD Direction Bi-Directional Interface Document Name N/A Instances Contracted Production, Test Required for Go -Live Yes The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 81 Page 627 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Standard Interface Description Interface Name Standard Alpha Numeric Paging Interface Interface Description The CAD Enterprise Paging Interface is a standard alphanumeric paging interface to provide text "paging" messages to a paging system vendor(s) using PET/TAP, WCTP, SMTP, or SNPP paging protocols, for delivery to the intended recipients. Vendor PageGate Subsystem CAD Direction Export Interface Document Name OSD — AlphaNumeric Paging Standard Interface Instances Contracted Production, Test Required for Go -Live Yes Standard Interface Description Interface Name Standard Smart911 Interface Interface Description The purpose of this interface is to provide the integration between CAD Enterprise and Smart911. CentralSquare will create a CAD-2-Smart911 interface service (also known as C2SS) to use in conjunction with the current standard CAD Enterprise ANIALI interface. Callers registered with Smart911 can provide information such as an address, phone number, caller, pets, medications, etc. When a 911 call comes in, the Smart911 system, like the CAD Enterprise ANIALI interface, receives the same minimal information. It then uses the phone number to determine if it belongs to a registered caller, then creates a ticket/event. Smart911 passes this ticket number to the CAD Enterprise Interface to associate it to an CAD Enterprise incident. When the CAD workstation or mobile user clicks on the ticket number, the caller's info will be displayed by the Smart911 system. Vendor Rave Smart911 Subsystem CAD Direction Bi-Directional Interface Document Name OSD - Standard Smart911 Interface Instances Contracted Production, Test Required for Go -Live Yes The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 82 Page 628 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Standard Interface Description Interface Name Standard Station Alert Interface Interface Description The CAD Enterprise Station Alerting Interface works with the Phoenix G2 Station Alerting (previously US Digital Designs). The Phoenix G2 Station Alerting System consists of a Communications Gateway that interfaces with CAD, allows system management and monitoring, communicates with Station Controller devices located in stations. Upon a CAD Enterprise System dispatch event, the CAD Enterprise Interface shall pass dispatch assignment information to the Phoenix G2 System. The Phoenix G2 Alerting System Server shall receive the CAD dispatch data and perform programmed station alerting functions for the stations involved. Vendor USDD Phoenix Subsystem CAD Direction Export Interface Document Name IRD - USDD Station Alerting Interface Instances Contracted Production, Test Required for Go -Live Yes Standard Interface Description Interface Name Enterprise CAD Axon Evidence.com Data Extract Interface Description CentralSquare will provide a SQL view and login that allows Axon to connect and query that view in order to obtain incident information such as Event ID, Address, Problem Nature, Responder information, Incident Disposition, and both dispatch and cleared call times. Vendor Axon Subsystem CAD Direction Export Interface Document Name N/A Instances Contracted Production, Test Required for Go -Live Yes The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 83 Page 629 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Standard Interface Description Interface Name Enterprise CAD SwissPhone Alert/Paging Interface Interface Description CAD Enterprise includes support of a robust automated and user -initiated paging capability that interfaces with NotePage / PageGate. Integration with the SwissPhone Paging system is also supported. Vendor PageGate Subsystem CAD Direction Export Interface Document Name OSD — AlphaNumeric Paging Standard Interface Instances Contracted Production, Test Required for Go -Live Yes Standard Interface Description Interface Name Standard RapidSOS Interface Interface Description The standard RapidSOS, service -based, interface works with the RapidSOS API. The API provides the ability for connecting clients to query the RapidSOS Clearinghouse server over public networks only when using TLS and tightly -controlled API keys. The API keys are used during the query process to authenticate the requestor to an agency that is authorized to retrieve caller location data. The Clearinghouse contains the information of callers that have: 1. The technical ability to deliver their location information to the Clearinghouse; 2. Placed a 911 call. The RapidSOS Clearinghouse server interfaces with CAD Enterprise through a host server using a REST Web Service (HTTPS). Once an Incident ID is assigned to a call incident that was created using ANI/ALI data, the Interface will query the Clearinghouse using the received ANI and return the location for that caller (if a location is available). Workflows on assigning an Incident ID to a call varies between agencies and will affect how this interface initially queries the Clearinghouse. Vendor RapidSOS Subsystem CAD Direction Import Interface Document Name OSD — Standard RapidSOS Interface Instances Contracted Production, Test Required for Go -Live Yes The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 84 Page 630 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Standard Interface Description Interface Name Standard External to CAD Enterprise- Premise Interface Description The External to CAD Enterprise Data Transfer Interface provides the ability to import and update premise records from an external source. This is a single directional interface from the external source to CAD Enterprise. The interface will enable information that is entered or edited on the external system to propagate to the CAD Enterprise system. Any premise information added or edited within the CAD Enterprise system will be allowed, but the changes will not be updated back to the external system. Vendor FirstDue, ESO Subsystem CAD Direction Import Interface Document Name OSD - External to CAD - Premise v2 Instances Contracted Production, Test Required for Go -Live Yes Standard Interface Description Interface Name Standard CAD to External Incident Data Transfer Interface Description The CAD Enterprise to External System Data Transfer Interface will provide a one-way data transfer of selected CAD Enterprise incident data fields from CAD Enterprise to a single Records Management System (RMS), Reporting Module, or other system external to the CAD Enterprise System. Note: CentralSquare has developed several separate configurations (i.e., data formats and transfer methods) for the Interface to support various external system vendors. Only one format is supported per implementation of the Interface. More than instance of the Interface may be implemented on a single CAD Enterprise system to support multiple vendors or multiple destinations for a single vendor. The output is in CentralSquare's proprietary file format. Vendor Fire Recovery Subsystem CAD Direction Export Interface Document Name OSD - CAD -to -External System Publisher Interface Instances Contracted Production, Test The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 85 Page 631 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Required for Go -Live Yes Standard Interface Description Interface Name PulsePoint Interface Description CentralSquare will provide PulsePoint with a SQL User on the CAD archive database in order for PulsePoint to create a SQL view with the data that they need and then they pull the data from that view. The CAD archive database is populated by the CAD production database using SQL replication in near real time so the data available to PulsePoint in the archive database is the same as the production database. Vendor PulsePoint Subsystem CAD Direction Export Interface Document Name N/A Instances Contracted Production only Required for Go -Live Yes Standard Interface Description Interface Name IA Standard TraCS Citation and Crash Import Interface Interface Description The CentralSquare IA TraCS Interface is a unidirectional interface that will import Citation, Warning, and Crash data from the TRACS system into Records Enterprise. Vendor TraCs Subsystem Records Direction Import Interface Document Name OSD - Black Hawk TRACS Importer Interface Instances Contracted Production, Test Required for Go -Live Yes Standard Interface Description Interface Name Axon Evidence.com Link Interface Interface Description The CentralSquare Evidence.com integration monitors Records Enterprise for when new cases are created from a CAD Call for Service, and automatically generates hyperlinks to videos in the Evidence.com system. These hyperlinks will appear in the case attachments section in Records Enterprise. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 86 Page 632 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Vendor Axon Subsystem Records Direction Import Interface Document Name OSD - Axon Evidence.com Interface v1.4 Instances Contracted Production/Test Required for Go -Live Yes Standard Interface Description Interface Name Enterprise Jail Inmate Phone Interface (Export) Interface Description This is a one-way interface from Jail Enterprise to the ICS inmate phone system. Jail Enterprise will send inmate demographic and location data as XML to the ICS Enforcer web service when an inmate is booked, released, changes jacket numbers, changes cell location, or has a master name record merged. Jail will also send the ICS Enforcer web service a weekly active inmates list to keep the two systems in sync. ICS configures and manages the ICS Enforcer web service. Vendor ICSolutions Subsystem Jail Direction Export Interface Document Name N/A Instances Contracted Production Required for Go -Live Yes Standard Interface Description Interface Name Enterprise Jail Commissary Interface Interface Description The interface between Jail Enterprise and the Keefe Commissary system is a one-way interface. Jail Enterprise will export inmate demographic data in XML, CSV, or JSON format. An alternative method may be selected by Keefe where data is exported from Jail to a network share or FTP location, accessible by Keefe. The data in this file will be imported into the Keefe commissary system via a process completely external to Jail Enterprise. The export will be setup by CentralSquare using the RESTfuI interface. Vendor Keefe Subsystem Jail Direction Export The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 87 Page 633 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Interface Document Name N/A Instances Contracted Production Required for Go -Live Yes Standard Interface Description Interface Name Enterprise Jail VINE Interface Interface Description The interface between Jail Enterprise to Appriss is a one-way interface. CentralSquare will create a read-only database connection for Appriss to access specific data views. Upon the completion of an inmate booking and when an inmate is released, inmate data will be made available through these views for consumption by Appriss. Appriss is responsible for querying these views for booking and release data, as well as daily active inmate population reports. CentralSquare will provide Appriss with database user information. Vendor Appriss VINE Victim Services Subsystem Jail Direction Export Interface Document Name N/A Instances Contracted Production Required for Go -Live Post Go -Live deliverable; Appriss needs Production data. Standard Interface Description Interface Name Enterprise Jail LiveScan/AFIS Interface Interface Description This is a two-way interface between Jail Enterprise and the IA AFIS Livescan system provided by Idemia. When an inmate is booked into Jail, a NIST file containing inmate booking and mugshot information is sent to the AFIS Livescan system via FTP. The Livescan imports the data file, pre -populating the booking record for submission to AFIS. A tracking number is then exported from LiveScan back to Jail Enterprise. Vendor Idemia Subsystem Jail Direction Bi-directional Interface Document Name N/A Instances Contracted Production Required for Go -Live Yes The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 88 Page 634 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Standard Interface Description Interface Name Enterprise Jail NDEx Adapter (IB IEPD) Interface Description This is an adapter that produces XML that is conformant to the N-DEx Incarceration/Booking (IB) IEPD. CentralSquare transmits data to the N-DEx web service via CentralSquare's existing N-DEx WSDL. Data transmission does not include all fields defined in the IEPD. Vendor Vendor neutral Subsystem Jail Direction Export Interface Document Name N/A Instances Contracted N/A Required for Go -Live N/A Standard Interface Description Interface Name Enterprise Jail Time Synchronization Interface Interface Description This is a server synchronization, which exists between the jail service and other Enterprise services. Vendor Vendor neutral Subsystem Jail Direction N/A Interface Document Name N/A Instances Contracted N/A Required for Go -Live N/A Standard Interface Description Interface Name Enterprise Jail Reporting Universal Interface Engine Interface Description Internal to the Jail Enterprise application, the reporting universal interface engine is used to fulfill the recurring report or RESTfuI interfaces. Vendor Vendor neutral Subsystem Jail Direction N/A Interface Document Name N/A Instances Contracted N/A Required for Go -Live N/A The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 89 Page 635 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Standard Interface Description Interface Name Guard 1 interface Interface Description This is a two-way interface from Guardl to Jail Enterprise. Jail Enterprise exports inmate and officer information including booking photos, cell locations and inmate alerts to a shared file location. Guardl consumes this information via a process external to Jail Enterprise. Guardl is responsible for deleting these files once consumed. Guardl exports inmate movement events, cell checks, inspections, inmate activities and inmate handouts to a shared file exchange where it is consumed by Jail Enterprise. Jail Enterprise is responsible for deleting these files once consumed. Upon successful import of this data from Guardl, Jail Enterprise creates inmate cell check entries, activity entries, shift log notes and inmate property updates. Vendor TimeKeeping Systems Subsystem Jail Direction Bi-directional Interface Document Name N/A Instances Contracted Production Required for Go -Live Yes The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 90 Page 636 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 11 Appendix C - Custom CentralSquare Interfaces The scope of functionality for custom interfaces is limited to 1) the capability of the CentralSquare System being interfaced and 2) the Application Programming Interface (API) capabilities of the external system being interfaced, and 3) what has been defined and approved in the Interface FDD. The approved FDD for each custom Interface is the basis for the scope of detailed requirements as well as testing and acceptance of the Interface. Any subsequent changes to approved FDDs are subject to Change Order and may impact the project timeline. Any post -approval changes to the requirements documented in the system OSDs or other documents are subject to a Change Order. Custom Interfaces Custom Interfaces are included in the Agreement and listed in this SOW. If not explicitly listed in the Agreement, the Interface will not be installed and supported. Custom Interface Description Interface Name Milestone Systems XProtect Video Management Interface Interface Description Integrate Milestone Systems XProtect into CAD Enterprise mapping where the dispatcher can view the real time camera(s) nearest to an incident event. Vendor Milestone Systems / Racom is their vendor. Subsystem CAD Direction Import Interface Document Name TBD Instances Contracted Production, Test Go -Live Requirement Customer requires the interface be available for Go -Live. Development work is contingent upon contract execution, Customer approved Operational Scenario Document (OSD), and scheduling of resources. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 91 Page 637 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Custom Interface Description Interface Name Modification to Iowa Livescan/AFIS Bi-Directional Interface Interface Description Request to modify the existing bidirectional Iowa Livescan interface to import Mugshots from the AFIS system back into Jail Enterprise. Note: Idemia must confirm mugshot data is available for import into Jail Enterprise. If the mugshots are not available, a change order will be required to remove this interface modification from the Agreement. Vendor Idemia Subsystem Jail Direction Import Functionality of Bi-Directional Interface Interface Document Name N/A Instances Contracted Production Go -Live Requirement Yes The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 92 Page 638 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 12 Appendix D - Message Switch The CentralSquare Message Switch is a component of the CentralSquare Suite which allows query and response transactions between CentralSquare Suite applications, the State, and some third -party data sources. CentralSquare Message Switch is a standalone application that can be accessed from any web application, or within a CentralSquare products, to centralize inquires to state switch systems, internal systems and/or other providers while reducing user interactions and data entry workflows. A Message Switch Provider is equivalent to a data source (such as a CentralSquare component like Records Enterprise, the State, or a SQL database). Message Switch Providers use Transactions to query the data source. A Message Switch Transaction can be considered the equivalent of an individual query or a combination (combo query which queries multiple Providers). Examples of individual queries would be Person by Name or Driver's License Number Transaction for the Provider Records Enterprise, or a Message key Transaction to the Provider State Justice Switch, or a Type of SQL Query to an external SQL database for a custom provider). Transactions are rolled up under each Provider. An example of a combination query would be a Transaction defined as a Combination Query of a Person query on both a State Provider and a SQL custom transaction (e.g., a Person by Name query which searches both the State, and an external SQL Data Source). Standard transactions are included in the project, subject to applicable access. Standard queries can be performed via the Enterprise suite applications graphical user interfaces as documented. The list of Message Switch Providers and associated Transactions included in this Agreement are as follows: The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 93 Page 639 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Standard Providers: Provider: Records Enterprise Standard Records Enterprise Transactions: Category Transaction Name Admin\Other Free Form Gun Gun Inquiry Vehicle Vehicle Inquiry Admin\Other Location Inquiry Person Person Inquiry Article Property Inquiry Provider: CAD Enterprise Standard CAD Enterprise Transactions: Category Transaction Name Admin\Other CAD Incident Inquiry Person CAD Person Inquiry Article CAD Property Inquiry Vehicle CAD Vehicle Inquiry Gun CAD Weapon Inquiry Vehicle Query Tow Request Person Query BOLO Person Vehicle Query BOLO Vehicle Provider: Jail Enterprise Standard Jail Enterprise Transaction: Category Transaction Name Person Person Inquiry (Mugshot, Jail Person Query) Provider: State Justice Switch (Iowa) Standard State Justice Switch Transactions (State/NLETS/NCIC transactions) For new State implementations where CentralSquare has not yet developed standard transactions, the Customer is responsible for providing State documentation for review by CentralSquare Product Management to identify standard state transactions. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 94 Page 640 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Transactions do not by default include record entry, modification, or update (Cancel, Clear, Locate) functionality. This functionality is available only if CentralSquare develops the queries as custom transactions as part of the Agreement. Standard State Justice Switch Transactions Category Message Key Transaction Name Gun XFG Felony Gun Cancel Gun XG Stolen Gun Cancel Gun XLG Lost Gun Cancel Gun XRG Recovered Gun Cancel Person XMPN Person With Information Supplemental Cancel Person XMP Person With Information Cancel Article XS Single Security Cancel Person XW Iowa Wanted Person Cancel Gun CFG Felony Gun Clear Gun CG Stolen Gun Clear Gun CLG Lost Gun Clear Gun CRG Recovered Gun Clear Article CS Single Security Clear Person ED Missing Person Dental Information Entry Person EMPN Person With Information Supplemental Entry Person EMP Person With Information Entry Person EIDC Identity Theft Entry - Caution Person EID Identity Theft Entry Person EIN Identity Theft Supplemental Entry Person MID Identity Theft Modify Person QID Identity Theft Inquiry Person XID Identity Theft Cancel Person XIN Identity Theft Supplemental Cancel Gun LFG Felony Gun Locate Gun LLG Lost Gun Locate Gun EFG Felony Gun Entry Gun ERG Recovered Gun Entry Gun ELG Lost Gun Entry Gun EG Stolen Gun Entry Gun LG Stolen Gun Locate Article LS Single Security Locate The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 95 Page 641 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Gun MFG Felony Gun Modify Gun MLG Lost Gun Modify Gun MRG Recovered Gun Modify Gun MG Stolen Gun Modify Person MD Missing Person Dental Information Modify Person MMP Person With Information Modify Article MS Single Security Modify Person MD Wanted Person Dental Information Modify Person MW Iowa Wanted Person Modify Person CW Iowa Wanted Person Clear Person EM Iowa Missing Person Entry Person EW Iowa Wanted Person Entry Vehicle QB Query Boat Gun QG Query Gun Article QS Query Securities Vehicle QV Query Stolen/Felony Vehicle/Plate/Part Person OW Iowa Wanted/Missing Person Inquiry AdminOther ACQ NLETS Prism Carrier Status Inquiry Vehicle AVQ NLETS Prism Vehicle Status Inquiry AdminOther GPQ NLETS Law Enforcement Information Sharing Service Query AdminOther CPQ NLETS Corrections Photo Inquiry Gun FGQ NLETS INTERPOL Gun Follow -Up Inquiry Person FPQ NLETS INTERPOL Persons Follow -Up Inquiry AdminOther FOC NLETS International Fuel Tax Transaction Inquiry AdminOther FTQ NLETS INTERPOL Travel Documents Follow -Up Inquiry Vehicle FVQ NLETS INTERPOL Vehicle Follow -Up Inquiry Vehicle GVQ NLETS VIN Check Inquiry Gun IGQ NLETS INTERPOL Gun Initial Inquiry Person IPQ NLETS INTERPOL Person Initial Inquiry AdminOther ITQ NLETS INTERPOL Travel Documents Initial Inquiry Vehicle IVQ NLETS INTERPOL Vehicle Initial Inquiry AdminOther PAQ NLETS Person Probation/Corrections/Parole All Inquiry AdminOther PBQ NLETS Person Probation Inquiry AdminOther PCQ NLETS Person Corrections Inquiry AdminOther RCQ NLETS Railroad Crossing Inquiry Person SOQ NLETS Sex Offender Inquiry Person SWQ NLETS State Warrant Query Person IAQ NLETS Immigration Alien Query AdminOther PPQ NLETS Person Parole Inquiry The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 96 Page 642 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Gun CWQ NLETS Concealed Weapons Permit Query Person FQ Out -Of -State Follow -Up Request Person IQ Out -Of -State Initial Request AdminOther HQ NLETS Weather and Road Conditions Query Vehicle GQ Query Aircraft Registration Vehicle VQ NLETS Canadian Vehicle File Query AdminOther TQ NLETS ORION File Query Vehicle MQ NLETS Hazardous Materials Query AdminOther NAQ NLETS NICB All Files Query AdminOther AM NLETS Administrative Message Vehicle SQ NLETS Snowmobile Registration Query Vehicle BQ Query Boat Registration Person DNQ NLETS Driver History Query By Name Only Person DQ NLETS Driver Record Query Person KQ NLETS Driver History Inquiry Person RNQ NLETS Vehicle Registration Query By Name Only Vehicle RQ NLETS Vehicle Registration Query Person UQ NLETS Canadian Driver Record Query AdminOther ACQ$ Test NLETS Prism Carrier Status Inquiry Vehicle AVQ$ Test NLETS Prism Vehicle Status Inquiry AdminOther GPQ$ Test NLETS Law Enforcement Information Sharing Service Query AdminOther CPQ$ Test NLETS Corrections Photo Inquiry Gun FGQ$ Test NLETS INTERPOL Gun Follow -Up Inquiry Person FPQ$ Test NLETS INTERPOL Persons Follow -Up Inquiry AdminOther FQC$ Test NLETS International Fuel Tax Transaction Inquiry AdminOther FTQ$ Test NLETS INTERPOL Travel Documents Follow -Up Inquiry Vehicle FVQ$ Test NLETS INTERPOL Vehicle Follow -Up Inquiry Vehicle GVQ$ Test NLETS VIN Check Inquiry Gun IGQ$ Test NLETS INTERPOL Gun Initial Inquiry Person IPQ$ Test NLETS INTERPOL Person Initial Inquiry AdminOther ITQ$ Test NLETS INTERPOL Travel Documents Initial Inquiry Vehicle IVQ$ Test NLETS INTERPOL Vehicle Initial Inquiry AdminOther PAQ$ Test NLETS Person Probation/Corrections/Parole All Inquiry AdminOther PBQ$ Test NLETS Person Probation Inquiry AdminOther PCQ$ Test NLETS Person Corrections Inquiry AdminOther RCQ$ Test NLETS Railroad Crossing Inquiry Person SWQ$ Test NLETS State Warrant Query Person IAQ$ Test NLETS Immigration Alien Query AdminOther PPQ$ Test NLETS Person Parole Inquiry The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 97 Page 643 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Gun CWQ$ Test NLETS Concealed Weapons Permit Query Vehicle GQ$ Test Query Aircraft Registration AdminOther NAQ$ Test NLETS NICB All Files Query Vehicle SQ$ Test NLETS Snowmobile Registration Query Vehicle RQ$ Test NLETS Vehicle Registration Query Person XMPN$ Test Person With Information Supplemental Cancel Person XMP$ Test Person With Information Cancel Person ED$ Test Missing Person Dental Information Entry Person EMPN$ Test Person With Information Supplemental Entry Person EMP$ Test Person With Information Entry Person MD$ Test Missing Person Dental Information Modify Person MMP$ Test Person With Information Modify Person MD$ Test Wanted Person Dental Information Modify Article LLAA Locate All Or Part Of Group - Lost (NCIC Record) Article MAA Modify Group Article - Stolen Article MA Modify Single Article - Stolen Article MLAA Modify Group Article - Lost Article MLA Modify Single Article - Lost AdminOther BOAT1 Iowa Boat Registration Inquiry Vehicle CB Clear Boat Vehicle XB Cancel Boat Vehicle LB Locate Boat Vehicle MB Modify Boat Vehicle EB Enter Boat AdminOther AM NLETS General Help File Query Article CAA Clear All Or Part Of Group - Stolen Article CAQ Canadian Article Inquiry Article CA Clear Single Article - Stolen Vehicle CBQ Canadian Boat Inquiry Gun CGQ Canadian Gun Inquiry Article CLAA Clear All Or Part Of Group - Lost Article CLA Clear Single Article - Lost Person CPO Iowa Protective Order Clear Person AM In -State Rejection Of Manual Search On Record Person AM In -State Response To Manual Search On Record Person AM Out -Of -State Administrative Rejection Person AR Out -Of -State Administrative Response Person AQ Out -Of -State Administrative Request Person AM In -State Request For Manual Search On Record The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 98 Page 644 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Person QH QH By SOC Or MNU Or SID To III Person RAPW Inquiry By DCI For Warrant Enhancement Person QMNI Master Name Index Inquiry By NAM/DOB/SEX Person QRI QRI - QR - CCH By FBI Person QR CCH And/Or III By DCI And/Or FBI Person QH CCH/III By NAM/DOB/SEX/RAC Or FBI Article CSQ Canadian Security Inquiry Article LAA Locate All Or Part Of Group - Stolen (NCIC Record) Article LA Locate Single Article - Stolen (NCIC Record) Article LLA Locate Single Article - Lost (NCIC Record) Person LW NCIC Missing Person Locate Person QM Iowa Missing Person By Physical Descriptors Inquiry Person KQ NLETS Commercial Driver History Inquiry AdminOther AM NLETS Help File Query Person YR NLETS Hit Confirmation Response - Missing Person Person YR NLETS Hit Confirmation Response - Protective Order Person YQ NLETS Hit Confirmation Request - Protective Order Article YR NLETS Hit Confirmation Response - Stolen Article Vehicle YR NLETS Hit Confirmation Response - Stolen Boat Gun YR NLETS Hit Confirmation Response - Stolen Gun Vehicle YR NLETS Hit Confirmation Response - Stolen Plate Vehicle YR NLETS Hit Confirmation Response - Stolen Part Vehicle YQ NLETS Hit Confirmation Request - Stolen Part Article YR NLETS Hit Confirmation Response - Stolen Security Article YQ NLETS Hit Confirmation Request - Stolen Security Article YQ NLETS Hit Confirmation Request - Stolen Article Gun YQ NLETS Hit Confirmation Request - Stolen Gun Vehicle YQ NLETS Hit Confirmation Request - Stolen Plate Vehicle YQ NLETS Hit Confirmation Request - Stolen Boat Vehicle YR NLETS Hit Confirmation Response - Stolen Vehicle Vehicle YQ NLETS Hit Confirmation Request - Stolen Vehicle Person YQ NLETS Hit Confirmation Request - Missing Person Person YR NLETS Hit Confirmation Response - Wanted Person Person YQ NLETS Hit Confirmation Request - Wanted Person Article CSS Group Security Clear Article ESS Group Security Enter Article LSS Group Security Locate Partial Article LSS Group Security Locate All Article ES Single Security Entry The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 99 Page 645 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Article MSS Group Security Modify Article XSS Group Security Cancel Vehicle CV Iowa Vehicle/Plate/Part Clear Person CW Iowa Missing Person Clear Vehicle LL Locate Vehicle License Plate In NCIC Vehicle LP Locate Vehicle Part In NCIC Vehicle LF Locate Felony Vehicle/Plate/Part In NCIC Vehicle LV Locate Vehicle In NCIC Person DLRQ Query Iowa Driver License by Name Person DLRQ Query Iowa Driver License by License Number Person DLRQ Query Iowa Driver License by SSN Person DQ NLETS Commercial Driver Status Inquiry Person DW Iowa Detainer Information Entry Article EAA Enter Group Article - Stolen Article EA Enter Single Article - Stolen AdminOther EDP Iowa Nics Denied Person Entry AdminOther EDV Iowa Validation Entry Article ELAA Enter Group Article - Lost Article ELA Enter Single Article - Lost Vehicle EL Iowa Vehicle Plate Entry Person ENPO Iowa Protective Order Supplemental Entry Person ED Iowa Wanted Person Dental Information Entry Person XNS Iowa Stolen/Fraudulent Identifiers Cancel Person ENS Iowa Stolen/Fraudulent Identifiers Entry Person XN Iowa Wanted Person Supplemental Cancel Person EN Iowa Wanted Person Supplemental Entry Person EN Iowa Missing Person Supplemental Entry Person EPOT Iowa Protective Order Entry Person EPO Protective Order Entry Vehicle EP Iowa Vehicle Part Entry Vehicle EV Iowa Stolen/Felony Vehicle Entry Vehicle EV Iowa Vehicle Towed Entry AdminOther IRPE Iowa Reciprocity Registration Inquiry Article LAA Locate All Or Part Of Group - Stolen (Iowa Record) Article LA Locate Single Article - Stolen (Iowa Record) Article LLAA Locate All Or Part Of Group - Lost (Iowa Record) Article LLA Locate Single Article - Lost (Iowa Record) Vehicle LV Locate Vehicle/Plate/Part In Iowa Person LW Iowa Missing Person Locate The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 100 Page 646 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Person LW Iowa Wanted Person Locate AdminOther MDP Iowa Nics Denied Person Modify Person MDW Iowa Detainer Information Modify Vehicle ML Iowa Vehicle Plate Modify Person MPO Iowa Protective Order Modify Vehicle MP Iowa Vehicle Part Modify Vehicle MV Iowa Vehicle Stolen/Felony/Towed Modify Person MW Iowa Missing Person Modify AdminOther QDR Icon By Doc Number Inquiry AdminOther QDV Iowa Validation File Inquiry Person QMVR Query Iowa Vehicle Registration Person QD Wanted/Missing Person And Driver License Inquiry (QD) Person QMVR Query Iowa Vehicle Registration by Name and Date of Birth Person QMVR Query Iowa Vehicle Registration by Name and License Number Person QMVR Query Iowa Vehicle Registration by Name and Social Security Number Vehicle QQ Iowa Stolen Vehicle and Vehicle Registration Inquiry Person QQ Wanted/Missing Person And Driver License Inquiry (QQ) Person DLRQ Query Iowa Driver License Article QA Query AdminOther SDP Iowa Nics Denied Person Supplemental Entry AdminOther SNOW Iowa SnowMobile / ATV Registration Inquiry Vehicle VQ NLETS Canadian Vehicle File Query By License Plate Vehicle VQ NLETS Canadian Vehicle File Query by Vehicle Identification Number Person WQ Canadian Wanted Person Inquiry Article XAA Cancel All Or Part Of Group - Stolen Article XA Cancel Single Article - Stolen AdminOther XDP Iowa Nics Denied Person Cancel Person XDW Iowa Detainer Information Cancel Article XLAA Cancel All Or Part Of Group - Lost Article XLA Cancel Single Article - Lost Person XNPO Iowa Protective Order Supplemental Cancel Person XN Iowa Missing Person Supplemental Cancel Vehicle XQ Canadian Stolen Registration Inquiry Vehicle XV Iowa Vehicle/Plate/Part Cancel Person XW Iowa Missing Person Cancel Gun XFG$ Test Felony Gun Cancel Gun XG$ Test Stolen Gun Cancel Gun XLG$ Test Lost Gun Cancel Gun XRG$ Test Recovered Gun Cancel The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 101 Page 647 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Article XS$ Test Single Security Cancel Person XW$ Test Iowa Wanted Person Cancel Gun CFG$ Test Felony Gun Clear Gun CG$ Test Stolen Gun Clear Gun CLG$ Test Lost Gun Clear Gun CRG$ Test Recovered Gun Clear Article CS$ Test Single Security Clear Person EIDC$ Test Identity Theft Entry - Caution Person EID$ Test Identity Theft Entry Person EIN$ Test Identity Theft Supplemental Entry Person MID$ Test Identity Theft Modify Person QID$ Test Identity Theft Inquiry Person XID$ Test Identity Theft Cancel Person XIN$ Test Identity Theft Supplemental Cancel Gun LFG$ Test Felony Gun Locate Gun LLG$ Test Lost Gun Locate Gun EFG$ Test Felony Gun Entry Gun ERG$ Test Recovered Gun Entry Gun ELG$ Test Lost Gun Entry Gun EG$ Test Stolen Gun Entry Gun LG$ Test Stolen Gun Locate Article LS$ Test Single Security Locate Gun MFG$ Test Felony Gun Modify Gun MLG$ Test Lost Gun Modify Gun MRG$ Test Recovered Gun Modify Gun MG$ Test Stolen Gun Modify Article MS$ Test Single Security Modify Person MW$ Test Iowa Wanted Person Modify Person CW$ Test Iowa Wanted Person Clear Person EM$ Test Iowa Missing Person Entry Person EW$ Test Iowa Wanted Person Entry Vehicle QB$ Test Query Boat Gun QG$ Test Query Gun Article QS$ Test Query Securities Vehicle QV$ Test Query Stolen/Felony Vehicle/Plate/Part Person QW$ Test Iowa Wanted/Missing Person Inquiry Person SOQ$ Test NLETS Sex Offender Inquiry Person FQ$ Test Out -Of -State Follow -Up Request Person IQ$ Test Out -Of -State Initial Request The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 102 Page 648 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration AdminOther HQ$ Test NLETS Weather and Road Conditions Query Vehicle VQ$ Test NLETS Canadian Vehicle File Query AdminOther TQ$ Test NLETS ORION File Query Vehicle MQ$ Test NLETS Hazardous Materials Query AdminOther AM$ Test NLETS Administrative Message Vehicle BQ$ Test Query Boat Registration Person DNQ$ Test NLETS Driver History Query By Name Only Person DQ$ Test NLETS Driver Record Query Person KQ$ Test NLETS Driver History Inquiry Person RNQ$ Test NLETS Vehicle Registration Query By Name Only Person UQ$ Test NLETS Canadian Driver Record Query Article LLAA$ Test Locate All Or Part Of Group - Lost (NCIC Record) Article MAA$ Test Modify Group Article - Stolen Article MA$ Test Modify Single Article - Stolen Article MLAA$ Test Modify Group Article - Lost Article MLA$ Test Modify Single Article - Lost AdminOther BOAT1$ Test Iowa Boat Registration Inquiry Vehicle CB$ Test Clear Boat Vehicle XB$ Test Cancel Boat Vehicle LB$ Test Locate Boat Vehicle MB$ Test Modify Boat Vehicle EB$ Test Enter Boat AdminOther AM$ Test NLETS General Help File Query Article CAA$ Test Clear All Or Part Of Group - Stolen Article CAQ$ Test Canadian Article Inquiry Article CA$ Test Clear Single Article - Stolen Vehicle CBQ$ Test Canadian Boat Inquiry Gun CGQ$ Test Canadian Gun Inquiry Article CLAA$ Test Clear All Or Part Of Group - Lost Article CLA$ Test Clear Single Article - Lost Person CPO$ Test Iowa Protective Order Clear Person AM$ Test In -State Rejection Of Manual Search On Record Person AM$ Test In -State Response To Manual Search On Record Person AM$ Test Out -Of -State Administrative Rejection Person AR$ Test Out -Of -State Administrative Response Person AQ$ Test Out -Of -State Administrative Request Person AM$ Test In -State Request For Manual Search On Record Person QH$ Test QH By SOC Or MNU Or SID To III Person RAPW$ Test Inquiry By DCI For Warrant Enhancement The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 103 Page 649 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Person QMNI$ Test Master Name Index Inquiry By NAM/DOB/SEX Person QRI$ Test QRI - QR - CCH By FBI Person QR$ Test CCH And/Or III By DCI And/Or FBI Person QH$ Test CCH/III By NAM/DOB/SEX/RAC Or FBI Article CSQ$ Test Canadian Security Inquiry Article LAA$ Test Locate All Or Part Of Group - Stolen (NCIC Record) Article LA$ Test Locate Single Article - Stolen (NCIC Record) Article LLA$ Test Locate Single Article - Lost (NCIC Record) Person LW$ Test NCIC Missing Person Locate Person QM$ Test Iowa Missing Person By Physical Descriptors Inquiry Person KQ$ Test NLETS Commercial Driver History Inquiry AdminOther AM$ Test NLETS Help File Query Person YR$ Test NLETS Hit Confirmation Response - Missing Person Person YR$ Test NLETS Hit Confirmation Response - Protective Order Person YQ$ Test NLETS Hit Confirmation Request - Protective Order Article YR$ Test NLETS Hit Confirmation Response - Stolen Article Vehicle YR$ Test NLETS Hit Confirmation Response - Stolen Boat Gun YR$ Test NLETS Hit Confirmation Response - Stolen Gun Vehicle YR$ Test NLETS Hit Confirmation Response - Stolen Plate Vehicle YR$ Test NLETS Hit Confirmation Response - Stolen Part Vehicle YQ$ Test NLETS Hit Confirmation Request - Stolen Part Article YR$ Test NLETS Hit Confirmation Response - Stolen Security Article YQ$ Test NLETS Hit Confirmation Request - Stolen Security Article YQ$ Test NLETS Hit Confirmation Request - Stolen Article Gun YQ$ Test NLETS Hit Confirmation Request - Stolen Gun Vehicle YQ$ Test NLETS Hit Confirmation Request - Stolen Plate Vehicle YQ$ Test NLETS Hit Confirmation Request - Stolen Boat Vehicle YR$ Test NLETS Hit Confirmation Response - Stolen Vehicle Vehicle YQ$ Test NLETS Hit Confirmation Request - Stolen Vehicle Person YQ$ Test NLETS Hit Confirmation Request - Missing Person Person YR$ Test NLETS Hit Confirmation Response - Wanted Person Person YQ$ Test NLETS Hit Confirmation Request - Wanted Person Article CSS$ Test Group Security Clear Article ESS$ Test Group Security Enter Article LSS$ Test Group Security Locate Partial Article LSS$ Test Group Security Locate All Article ES$ Test Single Security Entry Article MSS$ Test Group Security Modify Article XSS$ Test Group Security Cancel The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 104 Page 650 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Vehicle CV$ Test Iowa Vehicle/Plate/Part Clear Person CW$ Test Iowa Missing Person Clear Vehicle LL$ Test Locate Vehicle License Plate In NCIC Vehicle LP$ Test Locate Vehicle Part In NCIC Vehicle LF$ Test Locate Felony Vehicle/Plate/Part In NCIC Vehicle LV$ Test Locate Vehicle In NCIC Person DLRQ$ Test Query Iowa Driver License by Name Person DLRQ$ Test Query Iowa Driver License by License Number Person DLRQ$ Test Query Iowa Driver License by SSN Person DQ$ Test NLETS Commercial Driver Status Inquiry Person DW$ Test Iowa Detainer Information Entry Article EAA$ Test Enter Group Article - Stolen Article EA$ Test Enter Single Article - Stolen AdminOther EDP$ Test Iowa Nics Denied Person Entry AdminOther EDV$ Test Iowa Validation Entry Article ELAA$ Test Enter Group Article - Lost Article ELA$ Test Enter Single Article - Lost Vehicle EL$ Test Iowa Vehicle Plate Entry Person ENPO$ Test Iowa Protective Order Supplemental Entry Person ED$ Test Iowa Wanted Person Dental Information Entry Person XNS$ Test Iowa Stolen/Fraudulent Identifiers Cancel Person ENS$ Test Iowa Stolen/Fraudulent Identifiers Entry Person XN$ Test Iowa Wanted Person Supplemental Cancel Person EN$ Test Iowa Wanted Person Supplemental Entry Person EN$ Test Iowa Missing Person Supplemental Entry Person EPOT$ Test Iowa Protective Order Entry Person EPO$ Test Protective Order Entry Vehicle EP$ Test Iowa Vehicle Part Entry Vehicle EV$ Test Iowa Stolen/Felony Vehicle Entry Vehicle EV$ Test Iowa Vehicle Towed Entry AdminOther IRPE$ Test Iowa Reciprocity Registration Inquiry Article LAA$ Test Locate All Or Part Of Group - Stolen (Iowa Record) Article LA$ Test Locate Single Article - Stolen (Iowa Record) Article LLAA$ Test Locate All Or Part Of Group - Lost (Iowa Record) Article LLA$ Test Locate Single Article - Lost (Iowa Record) Vehicle LV$ Test Locate Vehicle/Plate/Part In Iowa Person LW$ Test Iowa Missing Person Locate Person LW$ Test Iowa Wanted Person Locate AdminOther MDP$ Test Iowa Nics Denied Person Modify The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 105 Page 651 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Person MDW$ Test Iowa Detainer Information Modify Vehicle ML$ Test Iowa Vehicle Plate Modify Person MPO$ Test Iowa Protective Order Modify Vehicle MP$ Test Iowa Vehicle Part Modify Vehicle MV$ Test Iowa Vehicle Stolen/Felony/Towed Modify Person MW$ Test Iowa Missing Person Modify AdminOther QDR$ Test Icon By Doc Number Inquiry AdminOther QDV$ Test Iowa Validation File Inquiry Person QMVR$ Test Query Iowa Vehicle Registration Person QD$ Test Wanted/Missing Person And Driver License Inquiry (QD) Person QMVR$ Test Query Iowa Vehicle Registration by Name and Date of Birth Person QMVR$ Test Query Iowa Vehicle Registration by Name and License Number Person QMVR$ Test Query Iowa Vehicle Registration by Name and Social Security Number Vehicle QQ$ Test Iowa Stolen Vehicle and Vehicle Registration Inquiry Person QQ$ Test Wanted/Missing Person And Driver License Inquiry (QQ) Person DLRQ$ Test Query Iowa Driver License Article QA$ Test Query AdminOther SDP$ Test Iowa Nics Denied Person Supplemental Entry AdminOther SNOW$ Test Iowa SnowMobile / ATV Registration Inquiry Vehicle VQ$ Test NLETS Canadian Vehicle File Query By License Plate Vehicle VQ$ Test NLETS Canadian Vehicle File Query by Vehicle Identification Number Person WQ$ Test Canadian Wanted Person Inquiry Article XAA$ Test Cancel All Or Part Of Group - Stolen Article XA$ Test Cancel Single Article - Stolen AdminOther XDP$ Test Iowa Nics Denied Person Cancel Person XDW$ Test Iowa Detainer Information Cancel Article XLAA$ Test Cancel All Or Part Of Group - Lost Article XLA$ Test Cancel Single Article - Lost Person XNPO$ Test Iowa Protective Order Supplemental Cancel Person XN$ Test Iowa Missing Person Supplemental Cancel Vehicle XQ$ Test Canadian Stolen Registration Inquiry Vehicle XV$ Test Iowa Vehicle/Plate/Part Cancel Person XW$ Test Iowa Missing Person Cancel Person QWI Query Wanted/Missing Person; Driver License and Criminal History Person QWI$ Test Query Wanted/Missing Person; Driver License and Criminal History The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 106 Page 652 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Custom State Justice Switch Transactions There are no custom State Justice Switch Transactions included as part of this Agreement. Custom Providers: Custom Providers allow the ability to access additional records management systems, warrant/court systems, or other accessible external databases. It is a requirement to have connectivity from the CentralSquare Message Switch to the RDBMS system and at least a login with Read access to the schema. A Subject Matter Expert in the schema will be required to either provide the SQL queries needed, and preferably design Stored Procedures on the third -party database to be used for the Transactions. If CentralSquare is contracted to write the queries or design Stored Procedures additional service hours will be needed. There are no Custom Providers included as part of this Agreement. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 107 Page 653 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 13 Appendix E - Subcontractor Statement of Work CentralSquare is including White Box Technologies as the identified subcontractor responsible for providing data conversion services for CAD, Records, and Jail Enterprise components. See Appendix Z — Data Conversions for the Statement of Work. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 108 Page 654 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 14 Appendix F — Miscellaneous Hardware The following hardware is included in the purchase and will be provided by CentralSquare: Description Quantity Jail Enterprise: Camera package for Mugshots- includes the InPhoto license, Canon camera, and power adapter. 2 Records Enterprise: Desktop printer, Zebra ZD421 (This module has Wi-fi and Ethernet options available). 1 The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 109 Page 655 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 15 Appendix J — CentralSquare Connectivity to Enterprise On -Premise systems Policy Customer Managed On -Premise Systems The BeyondTrust/Bomgar and/or SecureLink remote support solutions shall be the method of remote access to on -premise Customer systems and/or data. These solutions meet all requirements as contained in Section 5.5.6 of the FBI CJIS Security Policy (Remote Access). Use of either of these solutions enable Customer agencies to remain CJIS compliant for purposes of FBI and/or state regulatory agency audits. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 110 Page 656 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 16 Appendix Y — Workshop and Training Summary Training/Go-Live Deliverable Quantity Training(s)/Workshop(s) Included Remote/Onsite CAD Enterprise System Orientation 1 Three (3) day workshop Onsite CAD Enterprise Operational and Administrative Review (OAR) 1 Three (3) day workshop Onsite CAD Enterprise Administration (CAD Codefile Management) Training 1 Three (3) day workshop Remote GIS Link Training 1 Three (3) day training class for a maximum of four (4) participants. Remote CAD Enterprise Response Plan Workshop 1 Two (2) day workshop Remote CAD Enterprise Validation & Readiness Workshop 1 Two (2) day workshop Remote CAD Enterprise Functional Acceptance Testing 1 One (1) day testing event Remote CAD Enterprise Dispatch Supervisor Training 1 Three (3) day training class Onsite CAD Enterprise Call Taker/Dispatcher User Training 2 Two (2) day training class Remote CAD/Mobile Enterprise Onsite Go -Live Support Services 1 Two (2) day Go -Live Support — 1 CentralSquare Consultant per 12- hour shift, 2 shifts per day Onsite CAD Enterprise Post Go -Live Optimization and Advance Configuration Workshop 1 Three (3) day workshop Onsite Mobile Enterprise Functional Acceptance Testing 1 Four (4) hour testing event Remote Mobile Enterprise Administration Training 1 Three (3) day training class for a maximum of three (3) participants. Remote The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 111 Page 657 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Mobile Enterprise Train -the - Trainer Training (1 session for Law and 1 session for Fire) 2 Four (4) hour training class Remote Records Enterprise Pre- Configuration Questionnaire 1 One (1) day workshop Remote Records Enterprise Administration Review and Training Workshop 1 Three (3) day workshop Onsite Records Enterprise Workshop #1— Incident, Arrest, Case Management 1 Three (3) day workshop Onsite Records Enterprise Workshop #2 — Crash, Citation, Other Events, Field Interview 1 Three (3) day workshop Remote Records Enterprise Workshop #3 — Records Administration/State Reporting 1 Three (3) day workshop Onsite Records Enterprise Workshop #4 — Property & Evidence 1 Three (3) day workshop Onsite Records Enterprise Output Designer Workshop 1 Three (3) day workshop Onsite Records Enterprise Report Writing Training 1 Three (3) day workshop Onsite Records Enterprise Validation & Readiness Workshop 1 Three (3) day workshop Onsite Records Enterprise Functional Acceptance Testing 1 Three (3) day testing event Onsite Records Enterprise End User Training - Field Officers 1 Two (2) day training class Onsite Records Enterprise End User Training - Investigations 1 Two (2) day training class Remote Records Enterprise End User Training - Records 1 Three (3) day training class Onsite The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 112 Page 658 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Records Enterprise End User Training - Civil and Warrants Training (Sheriff's Office only) 1 Two (2) day training class Remote Records Enterprise End User Training — Property & Evidence Training 1 Two (2) day training class Onsite Records Enterprise Onsite Go- Live Support Services 1 Three (3) day Go -Live Support —1 CentralSquare Consultant per 8-hour day Onsite Records Enterprise Post Go -Live Optimization and Advance Configuration Workshop 1 Three (3) day workshop Onsite Jail Enterprise Functional Acceptance Testing 1 Six (6) hour testing event Remote Jail Enterprise Administration and Review Workshop Note: Duration is determined by modules. 1 Four (4) day workshop Remote Jail Enterprise Functional Acceptance Testing 1 Six (6) hour testing event Remote Jail Enterprise Administrator Training 1 One (1) hour training class Onsite Jail Enterprise End User Training 5 One (1) day training class Onsite Jail Enterprise Reports Training 1 Two (2) hour training class Onsite Jail Enterprise Go -Live Support Services 1 Four (4) day Go -Live Support with 1 CentralSquare Consultant per 8 hour day Onsite CAD, Mobile, Records, and Jail System Integration Testing (SIT) 1 Two (2) hour testing event Remote CrimeView Analytics Administrator/Designer Training 1 Twelve (12) hour training class Remote CrimeView Analytics Train-the- Trainer 1 Two (2) hour training class Remote The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 113 Page 659 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Police -to -Citizen Training 1 Four (4) hour training class Remote CAD, Mobile, Records Enterprise System Administration Training 1 Three (3) day training class Remote The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 114 Page 660 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration 17 Appendix Z — Data Conversions 17.1 Data Conversion 17.1.1. CAD Data Conversion Overview CAD Enterprise Data Conversion Source: Source 1: Dubuque PD, IA Source Vendor: ONESolution Source Database Type: SQL Server 17.1.2. RMS Data Conversion Overview RMS Enterprise Data Conversion Source: Source 1 Agency: Dubuque PD, IA Source 1 Vendor: ONESolution Source 1 Database Type: SQL Server Years: Up to ten (10) years of historical data 17.1.3. Jail Data Conversion Overview Jail Enterprise Data Conversion Source: Source 1 Agency: Dubuque SO, IA Source 1 Vendor: ONESolution Source 1 Database Type: SQL Server Project Summary: Conversion of source legacy data for use in CentralSquare CAD, Records, and Jail Enterprise. According to the availability and completeness of the source data and target modules, all of the fields and tables within the various functional areas will be populated to the fullest extent possible within the parameters outlined below. Where Agency/Dubuque Police (Dubuque) is referenced below, CentralSquare will assume the responsibility to work with Dubuque to complete the task. Roles and Responsibilities: CentralSquare • Project Manager and System Engineer ■ Manage project scope, schedule and performance, coordinate conversion activities with White Box. ■ Assist with adherence to schedule, and issue resolution. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 115 Page 661 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration ■ Inform White Box of issues impacting conversion. ■ Report conversion issues to White Box in a timely manner following a delivery, including necessary details to research and resolve. ■ Coordinate access for White Box to access customer's environment. ■ Facilitate Task Completion Reports and signatures for each of the milestones. Dubuque Police • CentralSquare to facilitate access to Agency Legacy System Subject Matter Expert and IT Support to: ■ Provide legacy data files to White Box. ■ Work with White Box to retrieve data and layout information from legacy system in either CSV, Flat Files with table header layouts or in a portable (e.g. SQL) format. ■ Inform White Box of issues impacting conversion, promptly answer technical and/or business operation questions. ■ Review, provide feedback and approve Table Mapping, Field and Code Documents. ■ With White Box assistance (if needed) thoroughly review mock conversions per schedule. Mandatory scheduled review sessions with White Box are required between the first and second iterations that will include all data being populated into the target modules. ■ Provide, generate, and validate source codes to target codes using the White Box online code mapper utility. White Box • Project Manager ■ Manage project scope, schedule, and performance, coordinate conversion activities with CentralSquare. • Data Analyst ■ Prepare Table Mapping, Field and Code Documents; deliver to Dubuque for review. ■ Work with CentralSquare and (as requested by CentralSquare) to develop the conversion rules and resolve issues identified during mock(s) and final conversion. ■ Schedule and conduct dedicated screen shares to assist Dubuque with code mapping and reviewing of mock data. • Engineer ■ Retrieve and prepare source data and set up other applicable systems. ■ Build, test, run conversion and deliver converted data to CentralSquare. ■ Load converted data into target database for customer testing. CentralSquare to assist with sync tools/utilities. If Dubuque does not agree to White Box access, this responsibility will be for CentralSquare Data Conversion Engineer. ■ Remove Dubuque data from White Box systems forty-five (45) days after Go -Live. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 116 Page 662 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Assumptions and Constraints: • This project includes up to three (3) mock iterations and a final go -live conversion for CAD, RMS, Jail, and a Gap Conversion for CAD (if required), consisting of the source data provided to White Box Technologies. Dubuque/CentralSquare will provide no more than three (3) source data dumps/backups consisting of: the initial CAD/RMS/Jail data backups used for building and reviewing the converted data, a backup used for CAD/RMS/Jail go -live and a backup used for the CAD Gap Conversion. Any additional backups requested by CentralSquare/Dubuque to be restored will result in a change request. Data must be in either a CSV, flat files with table header layouts or in a portable (e.g. SQL) format. • Data may be provided by CentralSquare/Dubuque using any of the following methods: Deliver to a secure FTP site, provided by White Box, Max file size is 100 GB. Save the files to a file location provided by CentralSquare or Dubuque; provide access for White Box to access and retrieve, or save the files on a hard drive and deliver to White Box. • CentralSquare will provide the code tables populated with Dubuque data prior to the first iteration to support the data mapping and conversion. White Box will not be creating or building codes or any code tables and is the responsibility of the Agency to validate their codes. All necessary code mapping must be completed prior to the first iteration delivery. If new codes are needed to be added to the target system, these will be identified during the code mapping validation process. • Images (mugshots/file attachments) included. • A project schedule will be developed and mutually agreed to during the initiation of this project. Any delay in the delivery of milestones or related sub -steps to the schedule, which is the responsibility of CentralSquare or Dubuque, can result in a day -for -day delay in subsequent milestones that White Box is responsible for. The period of performance begins from contract signing or a later date specified in the schedule to thirty (30) days after the final scheduled go - live. • Following a White Box deliverable, unless otherwise specified, CentralSquare or Dubuque (per schedule) has a set number of business days to report any issues. If White Box receives no response within that time, the deliverable will be considered accepted as delivered and if tied to a billable milestone, deliverable will be invoiced to CentralSquare. Issues reported after that period of time will be resolved on a case -by -case basis and may or may not be subject to additional charges and / or a change request. Requested changes or issues found after the go - live that were the result of not properly reviewing the converted data, will be subject to a change request. • White Box will not be responsible for de -duplication of legacy data with in-service data, although a Standard Name merge utility can be applied to the conversion. If it is decided that Dubuque does want a Name Merge to be done, White box will need the decision in writing signed by both Dubuque and CentralSquare. 100% success rate of duplicate records is not guaranteed. • Addresses that are part of the data conversion cannot be geo verified by White Box. If Geo verification is a requirement for Dubuque, Dubuque will need to conduct their own Geo verification testing. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 117 Page 663 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration • Code, configuration, and maintenance tables will not be populated in the target system by White Box. White Box will not be responsible for deleting any existing data in the configuration database. Any upgrades made to the target database during implementation will be a change request. Any new fields requested to be added after the last mock iteration that have not been reported previously will be a change request. • Work performed under this Statement of Work is under warranty by White Box for thirty (30) days following delivery of the final conversion. For any issues that are the direct result of a White Box error and found within the 30-day warranty period, White Box will fix those errors. Errors or omissions in converted data that result from application, database, source data changes or requested changes to the conversion logic made by CentralSquare or Dubuque following acceptance of any Spec Document, mock conversions, including not properly reviewing the data during the mock iterations or only reviewing partial data, the final go -live and found after the 30- day warranty period are not included in this Statement of Work and will be subject to a change request. Estimated Key Project Milestones: Milestone Deliver source data and code tables to White Box Deliver Table Mapping Document Deliver Code Mapping Utility Validate Source Codes to Target Codes Deliver first mock converted data Review of mock Converted data Deliver second mock converted data Review of mock converted data Deliver third mock converted data Review of mock converted data Deliver source data for go -live Deliver final converted CAD/RMS/Jail data Cut off for reporting post conversion issues (30 day Warranty Period, after delivery of data for go -live) Deliver source data for CAD Gap Conversion Deliver CAD Gap Conversion Responsibility Dubuque/CentralSquare White Box White Box Dubuque White Box Dubuque/CentralSquare White Box Dubuque/CentralSquare White Box Dubuque/CentralSquare Dubuque/CentralSquare White Box Dubuque/CentralSquare Dubuque/CentralSquare White Box Source System(s): • ONESolution CAD, RMS, and Jail • Number of Source Data Tables needing Analysis and Conversion: Up to 148 total source data tables for CAD, RMS, and Jail, only the most heavily used data tables containing over 1000 records per table are converted. (Lookup tables, code tables, and other source database tables that contain a minimal number of data fields and primarily exist for database normalization purposes do not count against this limit). The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 118 Page 664 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration • Source data delivered to White Box Technologies: Not received. Other similar project information was used to estimate scope and information provided by the Agency. All assumptions on number of tables being converted from the source databases will need to be verified once receiving copy of source database. Upon selection, a review of the data and scope will be confirmed to finalize the data conversion deliverable. If any additional data needs to be converted beyond the specified source data table count listed below, additional charges will apply. Target System(s): Target modules in scope: CAD: Module to be Converted Definition of Module Premise and Caution Notes CAD Premise Info and Caution Notes Incidents Up to ten (10) years of historical incident data Records: Module to be Converted Definition of Module Masters Master Person (Name and demographic information) Cases\Incidents Case\Incident Summaries Only Evidence Property and Evidence Module. Does not include Chain of Custody — only current status is converted. Arrests Arrest Module — Summaries Only Warrants Warrants Module — Summaries Only Attachments Attachments directly converted into the Records database. Attachments are tied to specific modules converted. Mugshots Mugshot Data Citations Citations Module- Summaries Only Field Interviews Field Interviews Module — Summaries Only Crash Crash Reports Module — Summaries Only Civil Civil Module — Summaries Only Calls for Service (Records) Calls for Service — Summaries Only. Calls for Service in Records represent the raw data received from the CAD system, stored in the Records database. Other Event Module: Intelligence Other Event Other Event Module: Internal Affairs Other Event Gun Permit Permits Module - Summaries Only Other Event Module: Sex Offender Other Event The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 119 Page 665 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration Other Event Module: Gang Other Event System Receipt Receipts Feature — Appendix A Other Event Module: Racial Profiling Other Event Other Event Module: Use of Force Other Event Other Event Module: Residential Security Other Event Other Event Module: K9 Other Event Impounds (Tow History) Impound Module Other Event Module: Daily Activity Logs Other Event Other Event Module: Pursuit Module Other Event Concealed/Carry Weapon (CCW) Permits Module - Summaries Only Jail: Modules to be Converted Inclusive of: Base (Names, Businesses, Business Contacts, Addresses, Address History, Phone book\Rolodex, Names Identification Types, Aliases, Vehicles). Jail (Jail Stays, Basic Hold Reasons, Sentence Hold Reasons, Hold Reasons, Cell Transfers, Inmate Activities, Victims, Inmate Property, Shift Log, Incidents, Disciplinary Actions, No Contacts). Personnel (training, certifications, recommendations) Mugshots Attachments Alerts will be generated on Master Names records based on existing alerts associated with the Master Name, including the Sex Offender module, Concealed Weapon/Gun permit module and Warrants. Modules Out of Scope: Any others not listed above, including any additional Target modules. Any additional source tables needed beyond the source tables listed above, or any additional data being populated into any other module will result in a change request for both time and cost and may require additional on -premise storage/hardware. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 120 Page 666 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Dubuque PD, IA ONESolution to Enterprise Migration In Scope Services: The following outlines the baseline services that are considered within the scope of this Statement of Work. Service Definition Data Conversion Changing digital data from one format to another so it can be used in another software application. The scope of this Statement of Work includes three mock conversions and a final go -live conversion for CAD, RMS, Jail, and a Gap Conversion for CAD (if required). Data Standardization Converting accepted (not misspellings) data values that represent the same information into a single unified, recognized, and accepted structure as required by the target system. Data Defaulting Based on predefined business rules, assigning a specific value to a field in the target database that is different than the corresponding value in the source database. Release Notes Report developed at the time of conversion data delivery that outlines mapping document version, the source and target database and application version, the tables and modules populated, and any known issues. Data Alteration Report Report to indicate records that have been truncated in order to insert into the database. The records are logged with the table, field, and primary key of the target record so that the full original value is not lost. Standard Name Merge White Box will perform a Standard Name Merge consisting of merging the data based on the following criteria: DOB; with one of the following unique identifiers, SSN, DL Number/DL State, FBI #, or State ID #. Image Conversion Converting digital images that were used in one application, for use in another software application. May also require changing the format of the images so that they function in the new application. Out of Scope Services: The following outlines the optional services that are considered outside the scope of this Statement of Work. CentralSquare/Dubuque is requested to submit a Change Request in order to include any of these optional services within the scope of this Statement of Work. Note that additional services may result in added cost and/or schedule delay. Service Additional Conversions/Go-Lives Address Validation Definition Re -run of the conversion process above and beyond those agreed to be within scope. Validates and standardizes address against USPS database. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 121 Page 667 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 Custom Reports Additional 3rd party Validation Data Cleansing Data Augmentation Enhanced Name Merge Convert to multiple databases Financial Conversion Preliminary Run of Converted Data Dubuque PD, IA ONESolution to Enterprise Migration Reports to indicate data that meets a certain criterion provided by CentralSquare / Dubuque. Review and correction of legacy data through use of third party commercially available reference applications to provide assurance that data is adequate for its intended use. Amending, correcting, removing, or defaulting inaccurate, incomplete, duplicated, or improperly formatted source data beyond that which is required to load the data properly in the target application. Adding new or derived data necessary or desired in the target system but not available in the source. (Also called data enrichment). This includes changing the intent of the source data. Any name merge applied that is outside of the Standard Name Merge criteria. Option to convert data to more than one target database. Any data that has financial components (fees, obligations, payments. interest etc.) that needs to be calculated, converted and populated into the target application. Option to analyze and run the Names section only before full conversion run to validate cleanliness and number of potential duplicates. The contents of this material are confidential and proprietary to CentralSquare Technologies, LLC and may not be reproduced, published, or disclosed to others without the prior written consent of CentralSquare Technologies, LLC. ©2024 CentralSquare Technologies, LLC Page 122 Page 668 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 EXHIBIT 6 Using/Accessing Agency Guidelines The following agencies are authorized to use the Customer's system in the quantities specified in Exhibit 1. Customer acknowledges and agrees to be responsible for these authorized agencies use of the System and to bind each authorized agency to all terms of the Agreement as reasonably applicable. In the event of breach, or threatened breach of the provisions of the Agreement, Supplier has no adequate contractual remedy with the Authorized agencies and accordingly shall be entitled to pursue remedy direct from the Customer. The Customer shall be the point of contact for each of these authorized agencies in the event that support services are required or requested by said authorized agency. Customer agrees to be responsible for all payment obligations incurred by any authorized agency inclusive of support and any additional purchases under the Change Order/Amendment processes as described in the Agreement. Accessing Agencies DUPD — Dubuque Police Dept. DCSO — Dubuque County Sheriffs Office ASPD — Asbury Police Dept. CAPD — Cascade Police Dept. DCCB — Dubuque County Conservation Board DYPD — Dyersville Police Dept. EPPD — Epworth Police Dept. FAPD — Farley Police Dept. PEPD — Peosta Police Dept. 07312024ba I CST-2024-101831 Page 669 of 674 Docusign Envelope ID: B702FA5B-0100-478D-9880-5EFFAFA9A1E0 EXHIBIT 7 Service Level Commitments The following applies to any non-OPS designated Software Subscriptions on Exhibit 1 as a cloud hosted Solution. 1. Service Level Commitments A. Availability. During any calendar month, the availability of the Solution shall be no less than 99.9%, excluding scheduled maintenance. CentralSquare shall provide Customer with prompt notification as soon as it becomes aware of any actual or potential unscheduled downtime of the Solution, as well as continual periodic updates during the unscheduled downtime regarding CentralSquare's progress in remedying the unavailability and estimated time at which the Solution shall be available. B. Measurement. Service availability is measured as the total time that the solutions are available during each calendar month for access by Customer ("Service Availability"). Service Availability measurement shall be applied to the production environment only, and the points of measurement for all monitoring shall be the servers and the internet connections at CentralSquare's hosted environment. C. Calculation. Service availability for a given month shall be calculated using the following calculation: I. The total number of minutes which the service was not available in a given month shall be subtracted from the total number of minutes available in the given month. The resulting figure is divided by the total number of minutes available in the given month. II. Service availability targets are subject to change due to the variance of the number of days in a month. III. The total number of minutes which the service was not available in a given month shall exclude minutes associated with scheduled or emergency maintenance. D. Remedy. If the service period target measurement is not met, then the customer shall be entitled to a credit calculated as follows: Service availability Credit percentage Less than 99.9% but greater than or equal to 99.0% 5% Less than 99.0% but greater than or equal to 95.0% 10% Less than 95% 20% Service Availability in the relevant Service Period Percentage Reduction in Monthly Fee for the Subsequent Service Period Less than 99.9% but greater than or equal to 99.0% 5% Less than 99.0% but greater than or equal to 95.0% 10% Less than 95% 20% E. Credit must be requested by the customer within sixty (60) days of the failed target. Any credit awarded shall be applied to the next applicable invoice. Customer shall not be eligible for credits where customer is more than thirty (30) days past due on their account. 2. Server Performance & Capacity. The standard provisioning of storage for the cloud solutions is 1 terabyte. If Customer requests to add additional Software, increase storage or processing requirements, and/or request additional environments, these requests will be evaluated and if additional resources are required to support modifications, additional fees may apply at per unit (gigabyte, hour, license, etc). 3. Non -Production Environments. Included in the subscription fee is access to the training environment during the hours of 8:00am — 4:00pm EST, Monday through Friday. Should the Customer require extended access for items such as internal training, CentralSquare can make exceptions provided that Customer provide reasonable advance written notice. CentralSquare will then work with the Customer to enable access in accordance with an agreed upon schedule. 07312024ba I CST-2024-101831 Page 670 of 674