Loading...
HomeMy WebLinkAbout2000-457FILE REFERENCE FORM 2000-457 X Additional File Exists Additional File Contains Records Not Public, According to the Public Records Act Other FILE(S) Date Initials Amended by Ordinance No. 2003-118 05/13/03 JR ORDINANCE NO 00— AN ORDINANCE OF THE CITY COUNCIL OF THE CITY OF DENTON, TEXAS AU- THORIZING THE MAYOR OR CITY MANAGER TO EXECUTE THE ATTACHED AGREEMENT FOR PURCHASE, LICENSING, PROGRAMMING, IMPLEMENTATION, TRAINING, SERVICE AND SUPPORT OF FIRE AND POLICE SUPPORT SOFTWARE AND HARDWARE, BETWEEN THE CITY OF DENTON, TEXAS AND VISIONAIR, INC, A QUALIFIED INFORMATION SYSTEMS VENDOR ("QISV") OF THE STATE OF TEXAS, TO BE PAID FROM PREVIOUSLY BUDGETED FUNDS IN AN AMOUNT NOT TO EXCEED ONE MILLION, TWO HUNDRED THIRTY-SEVEN THOUSAND, NINE HUNDRED AND THIRTY-FOUR DOLLARS AND NINETY-FIVE CENTS ($1,237,934 95), AND PROVIDING FOR AN EFFECTIVE DATE, WHEREAS, the vendor for the services anticipated by the attached agreement is a Quali- fied Information Systems Vendor ("QISV") of the State of Texas, and WHEREAS, the contracted -for goods and services fall within the scope of said QISV status for the purposes of the Catalog Purchasing Method prescribed by Chapter 2157 of the Texas Government Code, and WHEREAS, upon the evaluation and recommendation of staff, the City Council has pre- viously determined that the contracted goods and services represent the best value obtainable for said goods and services, NOW, THEREFORE THE COUNCIL OF THE CITY OF DENTON HEREBY ORDAINS SECTION I That the City Council hereby authorizes the City Manager to execute an agreement between the City of Denton and Visionair, Inc, for purchase, licensing, programming implementation, training service and support of fire and police support software and hardware, substantially in the form of the attached documents, and further authorizes the expenditure of previously budgeted funds in an amount not to exceed One Million, Two Hundred Thirty -Seven Thousand, Nine Hundred And Thirty -Four Dollars And Ninety -Five Cents ($1,237,934 95), for that purpose SECTION II That this ordinance shall become effective immediately upon its passage and approval PASSED AND APPROVED this the h day ofkewx&�'_, 2000 EULINE BROCK, MAYOR ATTEST JENNIFER WALTERS, CITY SECRETARY BY APPROVED AS TO LEGAL FORM HERBERT L PROUTY, CITY ATTORNEY Page 2 Software License Agreement THIS AGREEMENT is made and entered into as of the Effective Date as defined herein between VISIONAIR INC (hereinafter referred to "OWNER") with its principal place of business at 5601 BARBADOS BLVD , P O BOX 9000, CASTLE HAYNE, NORTH CAROLINA, 28429-9000, and City of Denton (herein referred to as "CUSTOMER") with its principal place of business at 215 E MCKINNEY, DENTON, TX 76201 WHEREAS, CUSTOMER desires to obtain from OWNER, and OWNER desires to grant to CUSTOMER, a perpetual, non -transferable, non -assignable license to use the Licensed Software described herein, for its in-house use, upon payment of the License Fee Payment of the License Fee is solely for the right to use the Licensed Software pursuant to the terms and conditions on the face and attached addenda of this Agreement and does not constitute the purchase of the Licensed Software or of any title therein WHEREAS, this Agreement includes and incorporates the following Attachments Attachment "A" Payment Schedule Attachment "B" Itemized Quote Attachment "C" Statement of Work Attachment "D" Software Service Agreement Attachment "E" Network Hardware Specifications Attachment "F" Master Name Historical Summary Data Transfer Specifications Document Attachment "G" Geo Conversion Document Attachment "H" Insurance Requirements Attachment "I" Functional Requirements Attachment "J" Licensed Software Acceptance Plan Attachment "K" Escrow Services Agreement Attachment "L" VisionAIR Help Desk Document WHEREAS, use of the Licensed Software is restricted to City of Denton 215 E McKinney Denton, TX 76201 NOW, THEREFORE, in consideration of the mutual promises hereinafter set forth, the parties hereto agree as follows DEFINITIONS Page 1 1 1 "OWNER" or "VisionAIR" means VisionAIR Inc, a North Carolina corporation with a principal place of business at 5601 Barbados Blvd , P O Box 9000, Castle Hayne, North Carolina 28429-9000 1 2 "CUSTOMER" or "City" or "City of Denton" means the City of Denton, Texas, U S A with its principal place of business at 215 E McKinney, Denton, Texas 76266 1 3 "Effective Date" is the last date of signature of a party as set forth below 14 "Software" means a set of instructions consisting of symbolic languages, processes and logic routines in machine executable form used in the operation of computer equipment applied to the performance of specific tasks 15 "Licensed Software" means the Software in its entirety, including any Updates or part(s) thereof, listed on Attachment B Itemized Quote, Attachment C Statement of Work, and the Response to RFP portion of Attachment I 1 6 "Licensed Software Module" means a software application which can be licensed separately by Owner as a standalone product The Licensed Software Modules being licensed in this Agreement are Computer Aided Dispatch (CAD), Records Management System (RMS), Jail, Mobile, Fire, EMS and INFORM 1 7 "Eligible Computer System" means a designated computer with the Operating System/Programming Language as stated on Attachment C Statement of Work 18 "Use" means copying of all or any portion of the Licensed Software from storage units or media into a computer or using any software in the course of computer operation 1 9 "In-house" means used only for administrative purposes the City of Denton, Texas, which purposes shall include (a) use in any city -owned, leased, or other specifically designated city facilities of the City of Denton, Texas, and (b) use in serving other adjacent municipalities' public safety agencies within the County of Denton, Texas who are reasonably expected to become departments of the City of Denton, provided that said public safety agencies are reasonably expected to operate under the same ORI number as that designated for the City of Denton 1 10 "Trade Secret" or "Confidential Information" means any business, technical or other information disclosed by a party which, at the time of disclosure, (a) derives independent economic value, actual or potential, from not being generally known to, and not being readily ascertainable by proper means by, other persons who can obtain economic value from its disclosure or use, and (b) is the subject of efforts that are reasonable under the circumstances to maintain secrecy 1 11 "DP Professional" shall mean any individual or business which supplies others Page 2 with computer equipment, software or professional advice regarding such Computer manufacturers, dealers, distributors, retail stores, original equipment manufacturers ("OEMs"), independent sales organizations ("ISOs"), system integrators, software houses, and data processing consultants are examples of DP Professionals 1 12 "Documentation" means all printed or electronic documentation which OWNER customarily provides or makes available with the Licensed Software The parties agree that "Documentation" includes all Updates of such documentation and further specifically includes four (4) user's manuals, which detail the features and functionalities of the licensed software The parties further agree that "Documentation" includes any and all written communications from OWNER to CUSTOMER regarding the characteristics of the Licensed Software that may be integrated into this Agreement as Attachments, 1 13 "Update" means (a) any published revision or correction to the Documentation, and (b) any correction, enhancement, replacement, evolution or new release (including beta versions) of the Licensed Software, except for those reasonably designated as new products for which OWNER charges separately 114 "Software Services" means the services which OWNER provides to CUSTOMER pursuant to the terms and conditions set forth in Attachment D attached hereto 1 15 "Warranty Period" means the twelve (12) month period beginning on the date that each Licensed Software Module is first used operationally by the Customer 2 TITLE AND OWNERSHIP 21 The Licensed Software and the original and any copies thereof, in whole or in part, whether said original and copies are made by OWNER or CUSTOMER or anyone else and all copyright, patent and trade secret and other intellectual and proprietary rights therein are and remain the property of OWNER 22 CUSTOMER has been advised by OWNER that aspects of the Licensed Software are OWNER trade secrets These may include, but are not limited to, the following system design, modular program structure, system logic flow, file structure, video and report formats, coding techniques, and routines, file handling and special search techniques, video screen data entry handling and report and/or forms generation Notwithstanding this, it is expressly agreed and understood that CUSTOMER maintains the right to extract and convert its data, or to hire third parties to do so on its behalf, to interface with other applications and to generate reports, and the parties contract and agree that such activities shall not, by themselves, constitute an actionable tort with respect to OWNER's claimed trade secrets 23 CUSTOMER agrees to include on any copies made of the Licensed Software Page 3 the same notices of OWNER's ownership interests that appear on the original 3 SCOPE OF AUTHORIZED USE 31 For the License Fee, plus charges which are due and payable in accordance with Attachment A of this Agreement, OWNER shall furnish CUSTOMER with such copies of the Licensed Software, including Documentation, as needed by CUSTOMER for use (including backup) OWNER shall similarly furnish any Updates it may produce as soon as they become commercially available, and Updates shall be furnished so long as the a Software Service Agreement is in effect 32 It is specifically understood and agreed that OWNER shall not be authorized to undertake any work pursuant to this Agreement which would require additional payments by CUSTOMER for any charge, expense, or reimbursement above the maximum not to exceed fee of five thousand dollars ($5,000 00), without first having obtained written authorization from CUSTOMER 33 CUSTOMER is granted a perpetual, nontransferable, nonassignable license to use the Licensed Software for CUSTOMER's in-house use CUSTOMER shall not have the right to sublicense the Licensed Software in any manner 34 CUSTOMER shall not assign or otherwise transfer this License or the Licensed Software, or any part thereof, by operation of law or otherwise, directly or indirectly, including, but not limited to, transfers to any joint venture or combination arrangements with any other person or entity 35 CUSTOMER understands and agrees that it shall not use the Licensed Software in any other city or at any other site location, except those designated herein, without prior written authorization from OWNER 4 SOFTWARE SERVICE AGREEMENT 41 OWNER agrees to provide Software Services in accordance with the provisions of Attachment D (Software Service Agreement) for a period of no less than five years from the date on which the Customer first uses the Licensed Software operationally, and coverage under the Software Service Agreement begins The term of the Software Service Agreement is annual The Customer may elect to renew annually The parties agree that no Software Services fees are payable at any time OWNER is in breach of Software Services obligations 5 WARRANTY AND LIMITATION OF LIABILITY Page 4 51 Following delivery, "live" installation / configuration, and tender by OWNER of the Licensed Software as meeting the acceptance criteria, CUSTOMER shall have the period specified in Attachment J to conduct the tests described in Attachment J (Licensed Software Acceptance Plan) to determine whether the Licensed Software conforms to the Applicable Documentation Within the time frames specified in Attachment J, CUSTOMER shall (a) notify OWNER that it has accepted the Licensed Software, (b) notify OWNER that CUSTOMER has determined that the Licensed Software does not satisfy the Performance Criteria, that Customer has rejected the Licensed Software and OWNER shall refund the fees paid by CUSTOMER relating to such Licensed Software, or (c) request OWNER to rectify all deficiencies in the Licensed Software, in which case OWNER shall use reasonable efforts to rectify the deficiencies in a timely manner, and, until such time as CUSTOMER has accepted the Licensed Software, CUSTOMER shall be entitled to (1) reject the Licensed Software, in which case CUSTOMER shall return such Licensed Software and OWNER shall refund the fees paid by CUSTOMER, or (2) notify OWNER that it accepts the Licensed Software with deficiencies provided that in no event shall acceptance of the Licensed Software with deficiencies by CUSTOMER constitute a waiver of its right to have any non -conformity of the Licensed Software with respect to the Documentation corrected in accordance with the terms of any warranty or Software Services provided herein 52 (A) OWNER represents and warrants that, during the Warranty Period and thereafter for so long as CUSTOMER is under contract to receive Software Services, the Licensed Software will perform in accordance with the Documentation and this Agreement (B) OWNER further warrants that the Licensed Software contains no computer viruses, or other code or instructions, that modify, damage, disable or compromise the security of any CUSTOMER computer systems or networks (C) OWNER, further warrants that the Licensed Software will perform each of the functional requirements specified in Attachment I 53 (A) CUSTOMER ACKNOWLEDGES THAT THE LICENSED SOFTWARE IS OF SUCH COMPLEXITY THAT IT MAY CONTAIN INHERENT DEFECTS AND AGREES THAT AS OWNER'S LIABILITY AND AS CUSTOMER'S REMEDY, OWNER WILL PROVIDE ALL REASONABLE PROGRAMMING SERVICES TO CORRECT DOCUMENTED CODE ERRORS WHICH DIAGNOSIS INDICATED WERE CAUSED BY A DEFECT IN AN UNALTERED VERSION OF THE DELIVERED LICENSED SOFTWARE (B) The nontransferable warranty of Paragraph 5 3 (A) to provide all reasonable programming services to correct documented code errors which diagnosis indicated were caused by a defect in an unaltered version of the delivered Licensed Software is valid during the Warranty Period and thereafter for so long as CUSTOMER Page 5 is under contract to receive Software Services 54 If OWNER is unable, within the Warranty Period, to repair or replace any Licensed Software to a condition as warranted, CUSTOMER shall be entitled to a refund of license fees paid for the Licensed Software, upon return of the Licensed Software module(s) to OWNER Any claim of warranty must be made not more than thirty (30) days after the expiration of the Warranty Period 55 OWNER represents and warrants that it has the authority to enter into this Agreement and has obtained all rights and waivers necessary to grant the rights granted hereunder OWNER represents and warrants that the exercise of the rights granted in this Agreement does not infringe any third -party patent, copyright, trademark, trade secret, or other intellectual property right 56 OWNER shall, defend and indemnify CUSTOMER against any and all claims brought against CUSTOMER, and shall hold CUSTOMER harmless from all corresponding damages, liabilities, settlements, costs and expenses (including reasonable attorneys fees for independent counsel of CUSTOMER'S choosing), arising out of any claim that the exercise of any of the rights granted in this Agreement infringes any third -party patent, copyright, trademark, trade secret or other intellectual property right CUSTOMER shall give OWNER prompt notice of, and authority to defend or settle, any such claim and shall give, at OWNER's expense, reasonable information and assistance 57 When notified of an action or motion that seeks to restrict the exercise of any of the rights granted herein, OWNER may, (and in the case of a judgment, order or injunction that restricts the exercise of any of the rights granted herein, shall), at its option and expense, (a) obtain the right for CUSTOMER to exercise its rights in accordance with this Agreement, (b) substitute other non -infringing software with equivalent functional capabilities, or, (c) modify the Licensed Software, while retaining equivalent functional capabilities, so that it no longer infringes 58 OWNER shall have no liability to CUSTOMER under this Article in the event infringement of any third -party patent, copyright, trademark, trade secret or other intellectual property right arises solely from (a) components of a CUSTOMER Product or System not derived from Licensed Software, (b) compliance with CUSTOMER's specific designs, specifications or written instructions, other than those specified in Attachments C and I, (c) modification by CUSTOMER of Licensed Software, or (d) the combination of Licensed Software with equipment or software not authorized or provided by OWNER or otherwise approved by OWNER other than Licensed Software designed by OWNER to work with certain commercial hardware or other commercially available software 59 OWNER agrees to indemnify, defend and hold CUSTOMER, its officers, employees and agents, harmless from and against any and all claims, suits, causes of action, liability, damages, judgments or expenses, including, but not limited to, Page 6 reasonable attorney's fees and litigation costs for personal injuries (including, but not limited to, death) or property damage which arise out of the negligent act or omission of OWNER including, but not limited to, the negligent design, manufacture, installation, or servicing of any part of the Licensed Software Litigation costs include, but are not limited to the hiring of independent counsel of CUSTOMER'S choice 510 Except for the indemnification provisions of this Article, claims arising from either party's breach of its confidentiality obligations, and claims for bodily injury or tangible property damage caused by the fault of either party, OWNER's and CUSTOMER's liability for damages under this Agreement, whether arising in contract, tort, or otherwise, even if the breaching party has been advised of the possibility of such damages, shall not exceed the amount paid by CUSTOMER to OWNER herein IN NO EVENT SHALL ANY PARTY BE LIABLE FOR ANY INDIRECT, SPECIAL, OR CONSEQUENTIAL DAMAGES EVEN IF THE BREACHING PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES ) 511 OWNER further represents and warrants that the Licensed Software shall process dates prior to and after January 1, 2000, with no adverse impact on the functionality of the Licensed Software or the accuracy of any reports This date processing shall include, without limitation, internal date formats that have century recognition, calculations that accommodate same -century and multi -century formulas and date values, date interface values that reflect the century and calculations that accommodate the occurrence of leap years Date calculations will work correctly All date related calculations will recognize that dates containing years equal to or greater than 2000 are later than dates in the 1900s OWNER does not represent that the Licensed Software will be compatible with non -OWNER defined formats or interfaces, other than as specified in Attachment 1 512 Upon the execution of this Agreement by all parties, OWNER shall deliver the Licensed Software to CUSTOMER within 14 days, except components of the Licensed Software identified as under development under Section Vill of the Statement of Work (Attachment C) After delivery of the Licensed Software, the CUSTOMER, as a property licensed user, may begin installation and training at any time OWNER does provide additional installation and training services for the Licensed Software and will install and train the Licensed Software at CUSTOMER's request for the additional agreed upon fees listed in Attachment B 513 A) CUSTOMER acknowledgement CUSTOMER acknowledges that due to the dynamic nature of the information technology industry and frequent product replacements and/or upgrades developed independently by third party vendors, OWNER has no control over the turnover of product or obsolescence of technology of third party product CUSTOMER also acknowledges that OWNER develops its Hardware Specification Document based upon all of the third party product information available to it Therefore, with respect to third party hardware and software, CUSTOMER shall retain the responsibility for the costs of purchase and installation of upgrades necessary to maintain the functionality of the Licensed Software Additionally, Page 7 the accumulation of storage of records in CUSTOMER's database over an extended period of heavy use may require expanding the capacity and memory of the operating system in order to maintain performance at response times acceptable to the CUSTOMER Subject to all of the affirmative duties and obligations of OWNER under the Software Maintenance Agreement, it is the CUSTOMER's sole responsibility to maintain the operating system to ensure adequate response times B) OWNER acknowledgement OWNER acknowledges and agrees that it will maintain its status as a MicroSoft solutions provider OWNER will also maintain its Licensed Software to use the most currently released version(s) of Microsoft operating systems and database software designed to function on Client -Server architecture 514 OWNER shall, for the duration of its obligations under this Agreement, maintain the minimum insurance requirements specified in Attachment H, and shall furnish CUSTOMER with its certificates of insurance and copies of appropriate endorsements prior to commencement or continuation of any work or obligations under this Agreement OWNER shall cause the policies to name CUSTOMER and its employees as additional insureds with respect to operations to which this Agreement is applicable These policies shall expressly provide primary coverage to all insureds, and shall contain a cross -liability or a severabdity of interests clause that provides that the insurance applies separately to each insured and that the policy covers claims or suits by one insured against the other OWNER shall also cause the policies to contain an endorsement requiring that the issuer of such policy give notice via certified mad to CUSTOMER thirty (30) days prior to cancellation or nonrenewal of the coverage or upon any material change in coverage OWNER shall produce copies of all endorsements and certificates of insurance required under this section to CUSTOMER within ten (10) days of notification by CUSTOMER of award of Agreement and prior to the commencement of any work or obligation under the Agreement 6 CONFIDENTIALITY/NONDISCLOSURE 61 Subject to the requirements of the Texas Public Information Act, any Confidential Information received by a party shall be retained in confidence and shall be used, disclosed, and copied solely for the purposes of, and in accordance with, this Agreement The receiving party shall use the same degree of care as it uses to protect its own confidential information of a similar nature, but no less than reasonable care, to prevent the unauthorized use, disclosure or publication of the Confidential Information 62 CUSTOMER shall take all reasonable steps to keep the Licensed Software under adequate security to prevent unauthorized access, copies, or use made thereof, and CUSTOMER agrees to notify OWNER immediately of the existence of Page 8 circumstances surrounding any unauthorized knowledge, possession or use of the Licensed i Software 63 OWNER shall take all reasonable steps to keep CUSTOMER Records (including records referenced pursuant to statutory laws relating to privacy and confidentiality as now in existence or as hereafter amended or changed) under adequate security to ensure that no unauthorized access, copies, or use is made thereof, and OWNER agrees to notify CUSTOMER immediately of the existence of circumstances surrounding any unauthorized knowledge, possession or use of CUSTOMER Records 64 No party shall be bound by obligations restricting disclosure and use set forth in this Agreement with respect to Confidential Information, or any part thereof, which (a) was known by the receiving party prior to disclosure, (b) was lawfully in the public domain prior to its disclosure, or becomes publicly available other than through a breach of this Agreement, (c) was disclosed to the receiving party by a third party provided such third party, or any other party from whom such third party receives such information, is not in breach of any confidentiality obligation in respect of such information, (d) is independently developed by the receiving party, or (e) is disclosed when such disclosure is compelled pursuant to legal, judicial, or administrative proceedings, or otherwise required by law, subject to the receiving party using reasonable efforts to provide prior notice to the disclosing party to allow it to seek protective or other court orders OWNER expressly acknowledges that CUSTOMER's status as a municipality does not, in and of itself, automatically inject or render any information it possesses or has accumulated into or a part of the public domain 65 Notwithstanding any other provision of Section 6 of this Agreement, it is expressly agreed and understood that CUSTOMER may write, or allow third -party programmers, DP Professionals or software vendors to write, application software interfaces (APIs), routines or code for CUSTOMER's use, to allow CUSTOMER to share data between the Licensed Software and any other software application, and it is expressly agreed and understood by the parties that such action, by itself, shall not constitute a breach of any duty of confidentiality or non -disclosure 7 TERMINATION 71 in the event of a material breach or default by the CUSTOMER OR OWNER in the performance of this Agreement, the aggrieved party shall give written notice to the other party specifying the nature and extent of the breach The party in breach or default shall have thirty (30) days thereafter to cure any such curable breach or default If such breach or default is not cured within said thirty (30) day period, the termination of this Agreement shall become effective on the forty fifth (45) day following said written notice 72 The parties specifically agree that OWNER will be deemed to be in breach of its obligations to CUSTOMER, and CUSTOMER may terminate this Agreement by written notice to OWNER, if Page 9 (a) OWNER is unable, at any time during the Warranty Period specified in this Agreement, to correct any material malfunction, defect or nonconformity in the Licensed Software which prevents the Licensed Software from functioning in accordance with the Documentation and this Agreement, within thirty (30) days after CUSTOMER's notification to OWNER specifying in reasonable detail in what respects the Licensed Software fads to conform, (b) OWNER is unable to discharge any of its material maintenance obligations with respect to Licensed Software in accordance with the warranties for such maintenance set forth in the Software Services Agreement (Attachment D), or in any other maintenance agreement in effect between OWNER and CUSTOMER, within thirty (30) days after CUSTOMER's notification to OWNER specifying in reasonable detail in what respects the Licensed Software is not properly being maintained, (c) the sale, assignment, or other transfer by the OWNER, without the prior written consent of the CUSTOMER, of such of the OWNER's rights in the Licensed Software which prevents the OWNER from the discharge of its obligations with respect to the performance of the Licensed Software under this Agreement during the Warranty Period or with respect to the discharge of its maintenance obligations under any maintenance agreement in effect between OWNER and CUSTOMER, or (d) OWNER becomes insolvent, makes a general assignment for the benefit of creditors, files a voluntary petition of bankruptcy, suffers or permits the appointment of a receiver for its business or assets, becomes subject to any proceeding under any bankruptcy or insolvency law, whether domestic or foreign, or has wound up or liquidated its business voluntarily or otherwise, and CUSTOMER has compelling reasons to believe that such events will cause OWNER to fad to meet its warranty or maintenance obligations in the foreseeable future 73 (A) If the Agreement is terminated during the Warranty Period by CUSTOMER due to a default by OWNER, said termination unrelated to provision 7 2(d) of this Agreement (i e , OWNER's default due to insolvency), then, in addition to any other remedies at law or in equity available to CUSTOMER, CUSTOMER may elect (a) for OWNER to return payments it received for the Licensed Software and Software Services within fourteen (14) days of termination in which case CUSTOMER agrees not to obtain the release of the Deposit Materials pursuant to Attachment K (Escrow Services Agreement) and CUSTOMER agrees to return the Licensed Software to OWNER; or (b) to obtain the release of the Deposit Materials pursuant to Attachment K (Escrow Services Agreement) in which case CUSTOMER agrees not to receive a return of payments OWNER has received and CUSTOMER agrees to make payment in full for the software license fees for all Deposit Materials released (B) If the Agreement is terminated during the Warranty Period by CUSTOMER due to a default by OWNER under provision 7 2(d) of this Agreement (i e , OWNER's default due to insolvency), Page 10 then, in addition to any other remedies at law or in equity available to CUSTOMER, CUSTOMER may elect for OWNER to return payments it received for the Licensed Software and Software Services or to obtain the release of the Deposit Materials pursuant to Attachment K (Escrow Services Agreement) or both 74 In the event that this Agreement is terminated, each party shall forthwith return to the other party all papers, materials, and other properties of the other party then in its possession 75 The provisions of Sections 1 (Definitions), 5 5, 5 6, 5 7, 5 8, 6 (Confidentiality / Nondisclosure), 7 (Termination), 8 (Taxes), 9 1, 9 2, 9 4, 9 6, 9 7, 9 8, 9 10, 9 11, and 9 12 shall survive any termination 8 TAXES 81 CUSTOMER shall pay any and all taxes arising from or based upon the License Fee, this Agreement or CUSTOMER's future use of the Licensed Software, other than income taxes properly owed by OWNER, unless CUSTOMER makes a claim of tax exempt status In such a case, CUSTOMER shall provide OWNER with evidence documenting official tax-exempt status 9 INDEPENDENT CONTRACTOR RELATIONSHIP 91 OWNER shall act in the capacity of an independent contractor with respect to CUSTOMER OWNER shall not act as, nor represent itself as being, an agent of CUSTOMER, and shall not act as, nor represent itself as being authorized to commit CUSTOMER to any obligation 92 As an independent contractor, OWNER shall take direction from CUSTOMER related to the results to be achieved by OWNER during the term of this Agreement All such direction shall be consistent with the scope of services to be provided under this Agreement or any Addendum 93 As an independent contractor, neither OWNER nor its employees, agents, or contractors shall have the status of employees of CUSTOMER or its subsidiaries Neither OWNER nor its employees shall be eligible to participate in any employee benefit, group insurance, or executive compensation plans or bonus programs offered to employees of CUSTOMER CUSTOMER shall not provide social security, unemployment compensation insurance, worker's compensation insurance, disability insurance, or similar coverage, nor any other statutory benefits of employment to OWNER, Page 11 94 OWNER shall comply with all applicable State and Federal regulations including but not limited to the filing of all required State and Federal income tax and other related taxes 95 Nothing in this Agreement shall be construed to create a liability to any person who is not a party to this Agreement, and nothing herein shall waive any of the parties' defenses, both at law or equity, to any claim, cause of action, or litigation filed by anyone not a party to this Agreement, including the defense of governmental immunity, which defenses are hereby expressly reserved 10 GENERAL 10 1 Approval by CUSTOMER shall not constitute, nor be deemed a release of the responsibility and liability of OWNER, its employees, associates, agents, subcontractors, and subconsultants for the accuracy and competency of their designs or other work, nor shall such approval be deemed to be an assumption of such responsibility by CUSTOMER for any defect in the design or other work prepared by CONTRACTOR, its employees, subcontractors, agents, and consultants 102 This Agreement, together with all appendices or other attachments referenced herein, contains the entire agreement and understanding by and between the CUSTOMER and OWNER with respect to this project The parties hereto acknowledge that each has read this Agreement, understands it, and agrees to be bound by its terms No representations, promises, agreements or understandings, whether written or oral, relating to this agreement and not contained or referenced herein, shall be of any force or effect The parties further agree that this Agreement shall not be modified, except by a written agreement signed on behalf of both parties by their respective duly authorized representatives 103 If either party is required to engage in any proceedings, legal or otherwise to enforce its rights under this Agreement, the prevailing party shall be entitled to recover from the other, in addition to any other sums due, the reasonable attorneys fees, costs and necessary disbursements involved in said proceedings 10 4 OWNER is hereby authorized to make reasonable inquiries, with CUSTOMER's cooperation, concerning CUSTOMER's compliance with this Agreement 105 If CUSTOMER materially breaches any of its obligations with respect to limited use or confidentiality of the Licensed Software, OWNER may seek equitable relief to protect its interest therein, including, but not limited to, injunctive relief 106 OWNER shall not be liable for delays in any of its performance hereunder due to causes beyond its reasonable control including, but not limited to, acts of God or labor disturbances Page 12 107 If any term(s), provisions(s), or condition(s) of this Agreement is held by a court of competent jurisdiction to be invalid, void or unenforceable, the remainder of the provisions shall remain in full force and effect and in no way be affected, impaired or invalidated 108 This Agreement shall be governed by the laws of the State of Texas All claims concerning the validity, interpretation, or performance of any of its terms and provisions, or any of the rights or obligations of the parties hereto, shall be instituted and prosecuted in The State of Texas, County of Denton 10 9 This Agreement may be executed in multiple copies, with each executed copy constituting an original, but collectively constituting but a single document 1010 If this Agreement is not fully executed by CUSTOMER within ninety (90) days of dispatch by OWNER to CUSTOMER the offer contained herein shall terminate and any subsequent signing of this Agreement shall have no binding effect 10 11 The contract documents consist of this Agreement and its Attachments In the event of a conflict between the contract documents, the order of precedence shall be the provisions of the main body of this Agreement and then the Attachments and the Documentation in the following order Functional Requirements (1), Documentation, Statement of Work (C), Software Service Agreement (D), Itemized Quote (B), Payment Schedule (A), Network Hardware Specifications (E), Master Name Historical Summary Data Transfer Specifications Document (F), Geofile Conversion Document (G), Certificate of Insurance (H), Escrow Services Agreement (K), and then the Acceptance Plan Document (J) 10 12 OWNER offers an escrow enrollment plan as an added service to customers It is the CUSTOMER's responsibility to pay to the Escrow Agent the annual beneficiary maintenance fee in order to retain current status as an escrow beneficiary The escrow agreement shall be an agreement of the form prescribed in Attachment K (Escrow Services Agreement) Enrollment of the CUSTOMER in the escrow plan shall occur on or prior to the installation of the Licensed Software In the event that OWNER should materially default in its obligations to CUSTOMER, or terminate this Agreement other than as permitted in accordance with the language herein, excluding a good faith dispute regarding an uncured and material breach or default of this Agreement by CUSTOMER, then CUSTOMER shall be entitled to the release of Source Code in escrow The Source Code shall be used for continued use and maintenance of the software only All intellectual and proprietary rights shall continue to remain in OWNER subsequent to the release of the source code or termination of this Agreement Page 13 CUSTOMER acknowledges that advances in technology, software, and their operating platforms evolve over time and that support and maintenance programs evolve in response CUSTOMER also acknowledges that the introduction of new technology may require OWNER in future years to alter support and maintenance service in order to remain current with such technologies As such, the discontinuance of a specific product or version's support and maintenance program by OWNER, with at least two (2) year's prior notice, which is due to substantial advances in technology shall not constitute a failure or refusal on the part of OWNER to provide support and maintenance, so long as reasonable alternatives are offered to CUSTOMER by OWNER Nothing in this paragraph shall be construed to invalidate or supersede OWNER's affirmative obligation as set forth in §5 13(B), above 10 13 Each party represents that the person executing the Agreement on its behalf is a duly authorized representative with the specific authority to execute this Agreement IN WITNESS WHEREOF, the parties have executed this Agreement as of the day and year last signed below VISIONAIR, INC. Signature 'kc V4 lily/ Name Richard J Holloman Title President Date It / ItiI lobo City of Denton Signature h �� Name Michael W Jez Title City Manager Date /A/IL7/©-C) t 2 R 8 Oa) O w 0 0 S LO Vi � M fOD O 7i M N O pNppp L+f M r O E u) tpo w N O 0 Ln N Cli in 0 S E rn 64 v� r S E � 0 S C V1 N! 64 V7 Cc) 0 S0 p �Sp pSIn o 0o'0 ) r- cp aNO V �NN , M LON CO Cl) I M /A 64 IH 6% 64 fA H! IH 603.0 fA IA d N cc Yt o E N 2Y `� co C � o s O o �m o$ 75+ o Q O �+ o Q Q i5 V m U a m 5 U a L a 00. 0 t0 O O O 1 fR m M O O V en O O 0 0 LV fA O co o va 0 O O co m IN O N co N N 0 0 0 0 o 0 0 0 0 0 O O O O O Cl) 0 0 w a Cl) 0 LO LO C I� a) LO N N coN N M N Ol fA 69 If) 60) LA &A fH t9 fA fH 61! N d d oc _oc oc c o c o c o g + m + ((QQ O + 0 110 � b N 9 off � N}� O mSUa -imPUa o COr-0a P. \ K \ ƒ { / b k k vw sa 8 i kk co �} 8■ ) §5 ¥ \ } 2 88co 88 , .00 04 t 7 c ) 0 + §To §M\\C LL �_u� 2z0(L K § _ !( !Sc Ico !=•§sz )oc�:cc 'owKztX @ � $ k \ 7 ) e \ ) \ � § { ) i ! @ ) | ( ) 7>/ k ) f�§ E �)/ co CO E� a f�/ )ki Es2 2■m 2)§\o kE// )k)=$(_�£ §a0!§\ / )( CLM0 ®f; 13 a§;�/m )t:!!/ '�! "I S C3 M R 5601 Barbados Blvd , P 0 Box 9600, Castle Hayne, NC 28429-9000 Phone 512-306-0087 Fax 512-306-0091 Estimate Date December 12, 2000 Attachment "B": Itemized Quote Agency Information Remote Office Information Agency City of Denton Office VisionAIR, Inc Contact Tim Smith Contact Michael Pruner Email tim smith®cltyofdenton com Email michaelp@visionair com Address 610 E Hickory, Suite A Address 1 P O Box 340926 City Denton, TX 76205 City Austin, TX 78734 Phone 940.349-7267 Fax 940-349-8533 Phone 512-306-0087 Fax 512-306-0091 Computer Aided Dispatch Code Licenses Price Base CAD Package (pop under75,000) VPCS-7 7 $103,365 00 CAD Monitor - View Only VPCMON 30 $15,000 00 E911 Interface VPCE-5 5 $6,010 00 EMD Interface VEMD-5 5 $4,725 00 NCIC Link - Access Only VPCN-7 7 $6,435 00 Paging Link VPCP-7 7 $6,435 00 Rip And Run Interface VRIP-5 5 $6,010 00 Supervisor Position VPCS-3 3 $12,015 00 CAD Mapping VMAP-5 5 $16,290 00 Sub Total $178,285 00 Records Management System Code Licenses Price Base RMS Package (Pop under75,000) VPR140 40 $43,120 00 Bar Coding VBAR40 40 $8,580 00 Citations VPRC40 40 $8,580 00 Equipment Maintenance VPRE40 40 $8,580 00 Internal Affairs VPRI40 40 $8,580 00 Pawn VPRP40 40 $8,580 00 Towing VPT040 40 $8,580 00 Traffic Accidents VPRT40 40 $8,580 00 Wants and Warrants VPRW40 40 $8,580 00 Administration and Personnel VPRA-0 10 $5,720 00 Imaging/Mugshots VIMG20 20 $20,595 00 Narcotics and Intelligence VPRN-5 5 $4,005 00 Sub Total $142,080 00 Jail Jail Base Package Fingerprint Interface Code VPJA-5 VFING Licenses 5 5 Price $24,030 00 $10,000 00 Sub Total $34,030 00 Police Mobile Code Licenses Price Mobile/LAN Server Switch for Access from Mobile and LAN VMSGIC 100 $82,500 00 Client - NCIC Access from the LAN only VMBLA1 20 $11,000 00 Client - NCIC Access from the Mobile units VMBLA2 85 $93,500 00 In Car Mapping with AVL VMBLA4 85 $28,050 00 Mobile Access to Vision RMS VMBLA5 85 $28,050 00 Mobile Incident Report License VMBLA6 85 $18,700 00 Mobile Accident Report License VMBLA7 85 $18,700 00 Mobile Field Interview Report License VMBLFI 85 $18,700 00 Cad Interface For Silent Dispatch VMBLCAD 85 $18,700 00 Sub Total $317,900 00 Fire Mobile Code Licenses Price Client - NCIC Access from the Mobile units VFMBLA2 27 $29,700 00 In Car Mapping with AVL VFMBLA4 27 $8,910 00 Mobile Access to Vision FIRE VFMBLA5 27 $8,910 00 Mobile Incident Report License VFMBLA6 27 $5,940 00 Cad Interface For Silent Dispatch VFMBLCAD 27 $5,940 00 Sub Total $59,400 00 Fire Code Licenses Price Fire Module VFIR20 20 $27,460 00 Sub Total $27,460 00 Emergency Management System Code Licenses Price EMS Module VEMS20 20 $27,460 00 Sub Total $27,460 00 24x7 coverage is 24 hours a day, 365 days a year 8x5 coverage is regular business hours, 5 days a week Maintenance Code Years Price 24 x 7 CAD SW Maintenance M24CAD 1 $30,308 45 8 x 5 EMS SW Maintenance M8X5EMS 1 $1,029 60 8 x 5 Fire SW Maintenance M8X5FR 1 $3,295 20 8 x 5 Jail SW Maintenance M8X5JL 1 $4,083 60 24 x 7 Message Switch SW Maintenance M24MSW 1 $14,025 00 24 x 7 Police Mobile SW Maintenance M24MBL 1 $40,018 00 24 x 7 Fire Mobile SW Maintenance 8 x 5 RMS SW Maintenance M24MBL M8X5RMS 1 $10,098 00 1 $17,049 60 Sub Total $119,907 45 Installation Code Price CAD Software Installation INSCAD $2,500 00 CAD Project Management PMCAD $17,828 50 CAD Network Configuration NWCCAD $2,800 00 RMS Software Installation INSRMS $2,500 00 RMS Project Management PMRMS $14,208 00 RMS Network Configuration NWCRMS $3,000 00 Mobile Software Installation INSMBL $5,500 00 Mobile Project Management - Police PMMBL $31,790 00 Mobile Project Management - Fire PMFMBL $5,940 00 Mobile Network Configuration NWCMBL $6,000 00 Jail Software Installation INSJL $2,500 00 ]all Project Management PMJL $3,403 00 ]all Network Configuration NWCJL $2,500 00 EMS Software Installation INSEMS $2,500 00 EMS Project Management PMEMS $858 00 EMS Network Configuration NWCEMS $3,000 00 Fire Software Installation INSFR $2,500 00 Fire Project Management PMFR $2,746 00 Fire Network Configuration NWCFR $3,000 00 Sub Total $115,073 50 Training Code Days Price CAD System Administrator TCADSA2 400 $4,800 00 CAD Telecommunicator TCAD2 900 $10,800 00 CAD Training TCAD2 200 $2,400 00 CAD Training TCAD2-A 200 $2,400 00 CAD Advanced Sys Admin TCAD2 100 $1,200 00 CAD LIVE TCAD2 2 00 $2,400 00 RMS System Administration TRMSSA2 3 00 $3,600 00 RMS Case Reports TRMS2 700 $8,400 00 RMS Warrant TRMS2 100 $1,200 00 RMS Citation TRMS2 100 $1,200 00 RMS DMV/Accident W/ Vislo TRMS2 600 $7,200 00 RMS Administration and Personnel TRMS2 1 00 $1,200 00 RMS Pawn TRMS2 050 $600 00 RMS Towed Vehicle TRMS2 050 $600 00 RMS Intelligence TRMS2 100 $1,200 00 RMS Internal Affairs TRMS2 100 $1,200 00 RMS Equipment Maintenance TRMS2 200 $2,400 00 RMS Live TRMS2 200 $2,400 00 RMS Advanced TRMS2 200 $2,400 00 RMS Training TRMS2 200 $2,400 00 RMS Training TRMS2-A 500 $6,000 00 RMS Basic & Essentials TRMS2 200 $2,400 00 RMS Basic & Essentials TRMS2-A 500 $6,000 00 RMS Bar Coding for Evidence and Property TRMS2 050 $600 00 Jail System Administration TJLSA2 200 $2,400 00 Jail Booking with Imaging TJL2 400 $4,800 00 Jail Live TJL2 200 $2,400 00 Jail Live TJL2-A 200 $2,400 00 Mobile System Administration TMBLSA2 1 00 $1,200 00 Mobile for Officers/Records Personnel TMBL2 3 00 $3,600 00 Mobile for Telecommunicators TMBL2 100 $1,200 00 Mobile Training TMBL2 Soo $9,600 00 Mobile Training TMBL2-A 1000 $12,000 00 Mobile Base TMBL2 400 $4,800 00 Mobile Reporting TMBL2 400 $4,800 00 Mobile Reporting TMBL2-A 3 50 $4,200 00 System Administration for Fire and Setup TFRSA2 300 $3,600 00 Fire Incident / Calendar / Personnel TFR2 200 $2,400 00 Fire Crew TFR2 3 00 $3,600 00 Fire Budget TFR2 3 00 $3,600 00 Fire Site / Water Source / Equipment TFR2 200 $2,400 00 Fire LIVE TFR2 1 00 $1,200 00 Advanced Fire TFR2 0 50 $600 00 EMS Training TEMS2 1400 $16,800 00 EMS System Administration TEMSSA2 3 00 $3,600 00 Sub Total 138 50 $166,200 00 Conversions and Data Transfers Code Quantity Price CAD 3rd Party Geo Conversion DT-3PG 1 $3,000 00 RMS MNHS RVMNHS 1 $10,656 00 CAD 3rd Party Additional Tables DT-3PAT 1 $2,500 00 Sub Total $16,156 00 Options Code Quantity Price Encoder Interface VSI296 1 $10,000 00 Interface Estimate VS1107 1 $10,800 00 NCIC Pager Software and Services 10 Units * VSI294 1 $18,488 00 Paperless Reporting API VSI118 1 $10,000 00 Software Enhancements VSOF01 1 $9,600 00 Sub Total $58,688 00 Inform Code Licenses/Days Price Base Package 2 - Agency Hosts * VINF2-10 lOL $20,000 00 Inform Project Management PMINF2 10L $1,500 00 Inform 8X5 Maintenance M8X5INF2 10 IOL $1,200 00 Inform Network Configuration Services NWCINF2 10L $1,500 00 Inform Installation Services * INSINF2 3L $6,000 00 On -site VSI Technician Support * INSINF2-TS 2D $4,000 00 Sub Total $34,200 00 *Discount ($59,105 00) Grand Total $1,237,934 95 Prices are valid for 45 days from date of Estimate Prices DO NOT Include taxes VisionAIR, Inc Attachment "C" Statement of Work SECTION I. GENERAL INFORMATION AND CUSTOMER PROFILE A SALES REPRESENTATIVE INFORMATION NOTE- If this is a Mufti -Jurisdictional Customer, a Statement of Work must be completed for each Agency. VisionAlR Sales Representative Michael Pruner Date 11/17/00 VisionAIR Project Manager Lisa Clark PM Initials PM Approval Date B LEGAL ENTITY INFORMATION (For Contracting) LEGAL ENTITY NAME City of Denton Texas Street Address 601 E. Hickory, Suite A City Denton State TX Zip 76205 Telephone 940-349-8562 Fax 940-349-8533 Contact Alex Pettit To whom should the Contract Package be mailed Name Alex Pettit Title Director of Technology Services Telephone 940-349-8595 Complete Address same as above C CUSTOMER NAME / ADDRESS / TELEPHONE CUSTOMER NAME City of Denton PO# Customer Main Telephone 940-349-8562 Fax 940-349-8533 Training Room Telephone 940-349-7812 Finance Office Telephone 940-349-8533 CUSTOMER ADDRESS I STREET CITY STATE ZIP Location Address 601 E Hickory Denton TX 76205 Training Center Address 601 E Hickory Denton TX 76205 Shipping Address 601 E Hickory, Suite A Denton TX 76205 Mailing Address 601 E. Hickory, Suite A Denton TX 76205 Customer is located in what COUNTY Denton Is this a new VisionAlR Customer or a Current VisionAIR Z11 New Customer M Current Customer Customer If this is a Current VisionAIR Customer, is this a DOS to Windows UPGRADE Yes No Is this an Addendum to an existing License Lj Yes Z No Date Existing License Signed Additional Comments A Purchase Order, if not available at time of signing contract, is requested within 30-45 days of date of signing contract, payment schedule and other related contract items Please fax the Purchase Order to the attention of TJ in Accounts Receivable at 910-602-6190, or if available, please return with contract documents for processing. Revision 2 (06/23/00) VisionAIR, Inc Attachment "C" Statement of Work D. CUSTOMER ORI # / STATE SALES TAX INFORMATION / DOMAIN NAME NOTE. Customer must furnish VisionAlR with a Sales Tax Identification number and rate If exempt, Customer must provide Vision with a Sales Tax Exempt Certificate as verification of the exempt status The sales tax documentation must be provided to the Accounting Department at VisionAIR, Inc (1-910- 602-6190) upon signing of the Contract. ORI Number TX0610200 FDID# FD604 Jurisdiction # DPSN Domain Name CODPS State Sales Tax Status oTaxable Z Exempt (If exempt, Customer must provide Tax Exempt Certificate) If Taxable, Sales Tax Rate If Taxable, Sales Tax Identification # Additional Comments Tax Exempt #75-6000514 E CONTACT INFORMATION City Project Manager Tim Smith Title Customer Support Manager Email Address tint smhh@chyofdenton con, Telephone 940-349-7267 Fax 940-349-8533 Cell 940-391-4958 List the names and telephone numbers of personnel dedicated to the pro ect: List main contact above NAME TITLE PHONE EMAIL Gary Matheson Police Chief 940-349-7925 Gary Matheson@cityofdenton com Ross Chadwick Fire Chief 940-349-8101 erchadwi@cityofdenton com Joame Housewri ht Ca t of Support Services 940-349-7996 Joanie housewright@cityofdenton com David Wright LT of Support Services 940-349-7939 David Wright@cityofdenton com Sean Kirk Support Services 940-349-8181 Sean Kirk(&,cityofdenton com Brad Cole Battalion Chief 1 940-349-7285 1 bwcole cit ofdenton.com Additional Comments Any scope of work changes must be routed through Tim Smith or his desi nee F CUSTOMER PROFILE AGENCY TYPE Z 911 Center CKFire Sheriff EJail Private Sector M Police Airport Police EMS El Court College Other Multi -Jurisdictional / # of Jurisdictions Total # of Officers 194 Sworn Officers 135 Detective 24 Civilian 60 Patrol 84 Dispatch 18 Jail 6 Admm 48 Other 14 TotalPop Served 74,000 Day Population n/a Night Population n/a Seasonal Increase n/a Other Agency Website Cit ofDenton coin Indicate below the VislonAIR Public Safety Suite products the customer is automating CAD Z RMS 0 Mobile Data Z Jail Z Fire Court EMS E GEO Z Other Inform Additional Comments The customer acknowledges that housing data for VisionRMS, JAIL, FIRE, and/or COURT on the same server results in the sharing of common master index data including Master Name, Master Property, Master Vehicle, and Master Address In order to keep the master databases separate for each respective index agencies not choosing to share master index data must utilize separate servers G. HARDWARE VENDOR INFORMATION NOTE- The customer is responsible for providing hardware that meets VisionAIR specifications as described in the Hardware Network Specifications Document. These hardware requirements are necessary forsuccessful operation of the Windows NT version of the Vision applications software Hardware Vendor Dell Computer — workstations — Servers TBD Revision 2 (06/23/00) VisionAIR, Inc Attachment "C" Statement of Work Contact Name Tim Smith — City of Denton Telephone 940-349-7267 Street Address City State Zip Is hardware vendor NT Certified Yes No Proposed hardware installation date Hardware Maintenance Provider Dell on WS Phone 800-955-3355 Additional Comments H SITE ISSUES NOTE -The cable must be at least CAT 5, tested, and Certified VisionAIR does not provide cable installation Cable installation means pulling cables, installing termination plates in walls and floors. VisionAIR is not responsible for any cable work done by any third party vendor Transmission of data may be adversely affected by improper cable installation. -The Customer must provide VisionAIR with a report of cable verification (CATS Certification) -The Customer must provide VisionAIR with a diagram layout of the cable drop location, numbering, and relation to patch panel. Does customer have physical space for the staging of hardware configuration? Yes No If no, what modifications are planned and what is the planned completion date9 Has customer made arrangements for cabling? EYes No If no what is the'i lanned completion date9 Does customer have sufficient electrical outlets and power supply to accommodate new configuration of network and workstation hardware? NYes No Note one outlet per c u and one per monitor) Does customer have physical space for all network hardware componems9 (this includes workstations, server location must have room for racks etc Yes E No Is there an equipment room set aside for the rack, servers, hub, etc Yes No Is Customer aware that it is mandatory for them to have a dedicated phone line and modem for support connectivity S9Yes No Are notebook co uters or other portable computers to be used Yes No If yes, please explain how these computers will be used and how they will access the network LAN Based and CDPD Mobile Clients Additional Comments Customer will provide cable and layout drawing SECTION II. CAD INFORMATION / ❑ N/A NOTE- If the Message Switch is purchased, the Customer MUST purchase a Host Only License of NetOp Software. This allows VisionAIR Support to dial in to resolve support issues with the Message Number CAD c ls/ ear 107,000 Number of Dispatchers 18 Number of Call takers n/a Please indicate for each workstation or group of CAD positions (i e CAD Pos # 1-5), if the workstation is used by a call taker (C), dispatch (D), Supervisor (S) or CAD Monitor -View Only (V), Services available (i e , NCIC, Mapping; E911, or Message Switch (MS), Location of the workstation Revision 2 (06/23/00) VisionAIR, Inc Attachment "C"• Statement of Work Cal Position NEENNOM Message Swit run A. E911 INFORMATION/ ❑ N/A NOTE -Customer must procure activation of the ANI/ALI feed prior to VisionAIR configuration -Customer must provide cable for connection from Controller to CAD Server -Customer must provide V1sionAIR with the ANI/ALI layout in printed or electronic format -An E911 Vendor representative must be present during ANI/ALI activation. Agency Contact Name for ANI/ALI information Clovis George Tele hone 940-349-7975 Total number of positions receiving E911 5 Type of E911 Equipment CML E911 equipment vendor contact Denco 911- Dave McConnell Telephone 972-221-0911 ANI/ALI Source #1 contact name Mark Payne Telephone 972-221-0911 ANVALI Source #2 contact name Telephone PGR 972-321-1390 Additional Comments m a ne denco or B NCIC INFORMATION / ❑ N/A NOTE If terminal emulation will be used, the 3270 Terminal Emulation Software must be purchased and installed by the customer. Customer must provide VlsionAIR with written verification from the State regarding the activation The State, Customer and VisionAlR must agree upon activation date Additional terminal identifiers must be available for each workstation that will be accessing NCIC via Vision's message switch. Total number desired to receive NCIC 7 Vendor providing NCIC access list the State and County if that is appropriate TX DPS Contact name Moll WrI lit Telephone 512-424-2254 Typeof ueryformats NTag ZVIN NOLN NNarneandDOB Type of interface N Terminal Emulation (Toggle) Z Message Switch State Proprietary Software El Third Party Software Other Have State Protocols been ordered? N Yes H No Planned Activation Date Type of Protocol 0 TCP/IP N LU6 2 LQSNA 3270 LJLU2 Polhn Bi-S nc Additional Comments VisionAIR has TDA sheet from Customer/State of Texas. Revision 2 (06/23/00) VisionAIR, Inc Attachment "C"• Statement of Work C MAPPING INFORMATION / ❑ N/A NOTE- - VisionAIR does, not warrant the completeness or accuracy of the data/map information provided by any Third Party Map program. VisionAIR provides the interface only Attributes, characteristics and data provided via Arcview, MapInfo, or any other Map Programs sold through a third party vendor are not the responsibility of VisionAIR. The VlsionAlR Mapping Software Product does not include importing or transferring of existing map files to ArcView, MapInfo, or any other Map Program If file transfer/importing and/or digitization/manipulation of data provided by ArcView, MapInfo, or any other Map Program is required, these services must be detailed in the Statement of Work Please attach a complete explanation of such services to this document. -Customer must provide a sample of the street file prior to software installation Is Customer purchasing mapping capabilities from VisionAIR Z Yes No If yes, Customer must purchase ESRI Ma Ob ects Software License for each seat using mapping Current Map proam Lj MAPINFO N ARCVIEW Other Map file format tab, sh , etc slip # workstations sharing mapping ro ram Will mapping be used with RMS9 NYes No If yes, Customer must purchase The Omega Group's Crimeview license for each seat using mapping. Will mapping be used on same monitor as CAD? LjYes NNo Mapping Source contact name Anthony Caranna Telephone 940-349-7249 Additional Comments SECTION III. RMS INFORMATION / ❑ N/A A. RMS CRIME REPORTING / ❑ N/A NOTE- -Bar coding equipment must be on -site prior to software installation. -Scanning equipment must be on -site prior to software installation. -A licensed copy of Visio Technical Software is required for on line sketching with the Traffic Accident Module. Visio must be on each station that will be using the Traffic Accident Software for on line sketching. Visiq Standard allows for Crime Scene diagrams The Customer is responsible for purchasing the Visio Software. State Reporting Format Lj Generic NIBRS D Generic UCR State Specific What State TX Does the State a ce t electronic submission of crime reporting? 4Yes WNo Does the State mandate electronic submission of crime re ortin Yes LjNo Number of Incidents per year 9000 Number of Citations per year 40000 Number of Accidents per year 2800 Number of Arrests per year 6000 Will bar coding Will be used for Evidence/Proper Collections Yes No Will scanning capabilities be utilized for object attachment to cases Yes F1No Multi Jurisdictional LjYes NNo If yes, please complete the attached Multi -Jurisdictional Form Additional Comments B LAW IMAGING INFORMATION / ❑ N/A Revision 2 (06/23/00) VisionAIR, Inc Attachment "C" Statement of Work NOTE- -When using more than one image capturing workstation, customer must ensure consistent environmental factors at each station such as lighting, background color, camera type, etc -Imaging equipment must be on -site prior to software installation #mug shots or images per month 1100 Total number of workstations viewing images 5 # image capture positions 1 Additional Comments C. JAIL RMS INFORMATION / ❑ N/A NOTE: Bar coding equipment must be on -site prior to software installation # of incarcerations per year 5200 Max inmate capacity 50 # of Jailers 6 # of Jail Workstations 3 Commis 9 Yes No Want to automates Yes No Medical 9 Yes No Want to automate9 Yes No Imaging? Yes No Want to automate9 Yes No Bar Codin 9 Yes No Want to automate9 Yes No Multi Junsdictional Yes No If yes, please complete the Multi -Jurisdictional Form Will bar coding will be used for ElCell Checks LjCommissary Additional Comments D JAIL IMAGING INFORMATION / ❑ N/A NOTE -When using more than one image capturing workstation, customer must ensure consistent environmental factors at each station such as lighting, background color, camera type, etc -Imaging equipment must be on -site prior to software installation # mug shots or images per month 1100 Total number of workstations viewing images 5 # image capture positions 1 Additional Comments E FIRE RMS INFORMATION / ❑ N/A Contact name Brad Cole Telephone 940 349-7285 Address administration-212 W Sycamore Street, Denton, TX 76201 Number of calls for service per year 3000 Number of units on duty at one time 27 Number of incidents per year 3000 Number of departments 6 Stations Number of full time employees 155 Fire and EMS Target date to implement NIFRS 5 0 reporting?_ Multi Jurisdictional Yes Z No If yes, please complete the Multi -Jurisdictional Form Additional Comments F. EMS INFORMATION / ❑ N/A Contact name Brad Cole Telephone 940 349-7285 Address administration-212 W Sycamore Street Denton TX 76201 Number of calls for service per year 8000 Number of units on duty at one time 27 Revision 2 (06/23/00) VisionAIR, Inc Attachment "C" Statement of Work Number of incidents per year 8000 Number of departments 6 Stations Number of full time employees 155 Fire and EMS Additional Comments SECTION IV. COURT INFORMATION / ® N/A A MUNICIPAL COURT MODULE INFORMATION / ® N/A NOTE Tramm must be coordinated through the Vis►onAIR Court Department State Reporting Format State Specific What State Does the State accept electronic submission of Crime Reporting Yes 7 No Number of Citations per year Number of Warrants per year Is Customer a Beta Site H Yes No Multi Jurisdictional Lj Yes Lj No If yes, please complete the Multi -Jurisdictional Form Additional Comments SECTION V. MOBILE DATA / ❑ N/A NOTE Mobile Reporting works with Windows 2000 - Customer must provide Vis►onAIR with a copy of the interface specification VlslonAlR has on file - Customer must provide message key documentation VisionAIR has on file. - Customer must provide VisionAIR with the state assigned resources for the mobile data system, i e , terminal ID - If the Message Switch is licensed, the Customer MUST purchase a Host Only License of NetOp - Unless otherwise herein noted, the Message Switch will have four (4) capabilities Tag, VIN, OLN, Name and DOB If the customer wishes to change computer technologies in the future, Customer needs to consult with VisionAIR as different technologies may warrant different client versions - Customer must register modem EID's with CDPD provider for assignment of IP addresses. Must be activated at least 72 hours prior to software installation A. CURRENT MOBILE DATA VENDOR INFORMATION Current mobile data vendor Itronix, Datalux Current mobile data vendor contact Telephone B. MOBILE APPLICATIONS Indicate below the Mobile functionality associated with this purchase AVL Z Dispatch 0 Chat N Email N NCIC Z Field Reporting N RMS Mapping ❑Agency Specific Database Queries ❑ Other NOTE- Mobile Reporting works with Windows 2000. Indicate below the Mobile Applications being purchased from VisionAIR Integrated solution (CAD, RMS, Mobile) Lj Message switch and client LJ Message switch only ❑ Client only ❑Message switch/Client to other CAD ❑ Message switch/Client to other RMS Access to third party database NOTE Unless otherwise herein noted, the Message Switch will have four (4) capabilities- Tag, VIN, OLN, Name and DOB. Revision 2 (06/23/00) VisionAIR, Inc Attachment "C" Statement of Work Type of state forms for field re ortm Accident MField Interview Incident Total # of client licenses 112 # m Police vehicles 85 # CAD LAN based 7 # RMS LAN based 20 # m Fire vehicles 27 Type of Vehicles Crown Vic If LAN based Client Licenses are being purchased, have the RID/SID numonics been ordered Yes No C OTHER VENDOR INTERFACES Is VisionAIR providing an API to another vendor's CAD Yes EFNo If yes, what Vendor Contact Name Tele hone # Is VisionAIR providing an API to another vendor's RMS Yes ZNo If yes, what Vendor Contact Name Telephone # D. 3 PARTY SERVICES Computer technology to be used MTouch Screen Pen Base Ruggedized M Standard Other Explain other Type of Laptops. Datalux current) The laptop operating system is N Windows 2000 Type of GPS NStandard Differential Must also purchase AVL Management Workstation Who is providing GPS for AVL? OPEN Contact Telephone Who is installing GPS for AVL? City Radio Shop Contact Telephone Who is providing the mobile units? OPEN Contact Telephone Who is installing mobile units? City Radio Shop Contact Tele hone Type of mounts []SMC El Gamber Johnson G&J Other Who is installing mounts? City Radio Shop Contact I Telephone Type of modems Sierra wireless VRM 650 INET L Airlmk VRM600 LMRM Other Who is installing modems? City Radio Shop Contact I Telephone Type of telephony connection being provided L1 56 K Z Tl LFiber LOther Who is providing telephony equipment installation? AT&T Contact Tom Martin I Telephone 214-763-4535 NOTE If the customer wishes to change computer technologies in the future, Customer needs to consult with VisionAIR as different technologies may warrant different client versions E. STATE NETWORK COMMUNICATION PROTOCOL What communication protocol does the state use TCP/IP E LU6 2 SNA 3270 LU2 Pollmg By s nc UTS 60 State Technical Contact Name Molly Wright Telephone 512-424-2254 Revision 2 (06/23/00) VisionAIR, Inc Attachment "C"• Statement of Work F. WIRELESS TECHNOLOGY What wireless technology will be used EDAC DataRadio RNC 3000/6000 Z CDPD Other Explain Other If DataRadio, what version of DataRadio MRM firmware will be used9 Customer must have a radio box BDLC from DataRadio to program the modems If RNC 3000/6000, is it installed Yes No Projected installation date RNC 3000/6000 Contact Telephone If CDPD, who is the Provider AT&T (Customer must register modem EID's with CDPD provider for assignment of IP addresses Must be activated at least 72 hours prior to software installation. Wireless Provider Contact Tom Martin Telephone 214-763-4535 G ADDITIONAL MOBILE INFORMATION / NOTES Please describe any special functions which may be required for proper operation of this system, i e , customer ro rammm , county interfaces, mainframe interfaces, etc Additional Comments New Mobile computers will meet or exceed VisionAlR Specifications SECTION VI. INTERFACES WITH 3RD PARTY SOFTWARE / CUSTOM MODIFICATIONS/ ❑N/A A INTERFACES WITH 3RD PARTY SOFTWARE/❑N/A NOTES VisionAIR does not recommend installing WinBeep on the CAD Server When WinBeep is purchased, a 2"d Modem is required Customer must purchase the 3rd Party Software necessary to interact with VisionAlR interfaces, ie , WinBeep, Zetron, ProQA, DBI upload services • CAD/paging(WinBeep) ® Zetron Toning ® Fmgerprmtmg/AFIS ® ProQA for Windows/Medical Priority Dispatch System Software ❑ Vision RMS with other CAD n Vision Mobile with other CAD ® CrimeView ® Other See Below Additional Comments Toning/Alerting- The City of Denton plans to purchase a Zetron Toning System The ability for VisionCAD to interface will be based on the current VisionCAD Zetron Toning Interface AFIS/Fingerprinting.VisionAIR has deployed NEC AFIS in TX Court Interface for Warrant Transfer from CSI to VisionRMS Warrant Module, VisionPaperless Citation TXT File on message switch for CSI use, and Disposition Transfer form CSI to VisionRMS Citations will be outlined as an attachment to this SOW B. CUSTOM MODIFICATIONS / ®N/A Describe in detail any Custom Modifications purchased as part of this project SECTION VII. HISTORICAL DATA SECTION / ON/A A. CAD CONVERSION / ❑N/A NOTE Customer data must be provided at least 3 weeks prior to desired deliverable due date Data must be presented in the VisionAIR required format Is this a Vision DOS to NT Conversion or a Third Party Conversion DOS to NT OThird Part Revision 2 (06/23/00) VisionAIR, Inc Attachment "C" Statement of Work Is this a FULL CAD Conversion (Available to Vision DOS Customers only), or, a GEO Conversion FULL Available to Vision DOS Customers only) GEO Jurisdiction Name Do not exceed eight Characters DPSN List each 3` Party CAD Table to be converted Additional Comments Internal ALI conversion will also be completed by VisionAIR and has been priced in the quote as part number DT-3PAT Customer is responsible for placing data in desired format provided by VisionAIR B. MASTER NAME HISTORICAL SUMMARY (MNHS) / QN/A NOTE. VisionAIR uses the Master Name Historical Summary Methodology for handling historical data from other Records Management systems This method is explained in detail in the VISION RMS Master Name Historical Summary Methodology Document VisionAlR does not commit to the completion of the MNHS transfer of data before the customer's live date. Upon receipt of the customer's sample data, VisronAIR will issue an estimated completion date All customers desiring MNHS are solely responsible for the transfer of their data to a media source. Acceptable media types include CD-ROM, Zip drive(s), or Floppy disks using Pkzip or Winzip It is recommended that the customer maintain the current or old RMS system for a "lookup station" until all data has been transferred. VisionAIR will perform one transfer of data to MNHS per customer VisionAIR encourages each customer to provide sample data of at least, but no less than, Name data (Name _Table) and one or more of the Summary tables as specified in Section III of Attachment F (Historical Table Structures) Once the Data Transfer department has verified that all of the sample or final data submissions meet the specified MNHS format requirements then an estimated completion date can be issued Is the Customer pi ZYes LJNo What Product lines ZIRMS LJJail If the Customer is purchasing MNHS, has the Customer reviewed the attached VISION RMS Master Name Historical Summary (MNHS) Methodology Document and does the Customer agree to comply with the technical data format requirements outlined in the documents zYes Customer's Initials Date PLEASE COMPLETE THE FOLLOWING INFORMATION ABOUT THE CUSTOMER'S CURRENT DATA FORMAT - Data file Format SQL 7.0 Medium Data will be stored on CDROM Data File layout will be provided with data(including field definitions Yes L.JNo Customer Contact LT David Wright Coin an /Individual responsible for putting historical data in VisionAIR specified data file layout Indicate files to transfer Please complete the following information about the files to be transferred # of Records I Size of Files 600MB # of Years 3 Additional Comments Current RMS vendor: ICS/AMT Additional Tables/Information to be converted: Vehicle Information; Images and Narratives attached as Objects SECTION VIII. VISIONAIR APPLICATIONS NOTE. VisionAIR, Inc. provides software applications that are developed in house These applications are sold as "commercial off the shelf' software packages, but are subject to the specific warranty provisions set forth in the Software License Agreement, which shall govern over this document. Essentially, the Licensed Software is warranted to conform to VisionAlR's specifications and software documentation, and is further warranted to accomplish the Functional Requirements set forth in Attachment I of the Software License Agreement Revision 2 (06/23/00) 10 VisionAIR, Inc Attachment "C Statement of Work Are any of the VisionAlR Software Applications or Interfaces being purchased still under development ZYes No If yes, which ones; Fire Mobile, EMS Reporting and Court Interface for Warrant Transfer from CSI to VisionRMS Warrant Module, VisionPaperless Citation TXT File on message switch for CSI use, and Disposition Transfer form CSI to VlsionRMS Citations will be outlined as an attachment to this SOW What is the customer's understanding and expectations regarding this software until such time that it is released Products will be delivered upon release from VisionAIR QA department Additional comments SECTION IX. VISIONAIR SOFTWARE MAINTENANCE AND SUPPORT Software Maintenance and Support Services are provided through renewable contractual agreements and is offered on this agreement on a Premium Support 7 X 24 Seven Days Per Week / 24 Hours Per Da Agencies with these agreements are supplied with all updates and enhancements at no additional charge during the term of the agreement. Remote diagnostics and a toll free telephone support number are also included. To be able to perform remote diagnostics and to install executable changes to the software, the Customer must maintain a dedicated phone line and modem for the exclusive use of VisionAIR Su ort Software Maintenance and Support services become effective the date the Customer first uses the Licensed Software operationally ("Goes Live") The cost for 1" year software maintenance and support is included in this contract The agency will be provided with a renewal quote annually The Agency is responsible for renewing the coverage. Have VisionAIR and the Customer agreed to any terms or conditions regarding SW Maintenance and Support different than described above9 ZYes 7No If yes, describe in detail Additional comments Maintenance Agreement will true up to October 1" for Budget Typically, VisionAIR will pro rate each module during the first renewal term as to get the whole SSA on to the customer's fiscal year VisionAIR will limit increase of fees to 3% per year for three years SECTION X. TRAINING V►sionAIR will provide comprehensive training on the VisionAIR applications purchased as part of this project The Customer may elect to be trained at the VisionAIR Training Center (Brevard, NC) or ON SITE at a location provided by the Customer. CALCULATIONS OF TRAINING DAYS- Use the following formula for calculating the total training days for each module [(# of people to be trained) _ [(# of computers for training ) • (# of trainees per computer)]] • (Number of training days per module) = total number training days required or [(b) — (c • d) ] • ( a) = (e) total number of training days or 8— 2 . 2 •2 = 4 days (Always round up for partial days) NOTE. The # of training days Per Module is based on a MAXIMUM class size of 15 with no more than 2 people per terminal If there are more than 15 people to tram and more than two people per terminal, more training dals will be required. CAD TRAININ Software # # # # Total # Location of Training Training Trainees Computers Trainees/ Days — Days Available Terminal Training Per Module (b) (c) (d) (e) a CAD System 40 1 9 5 1 2 1 4 Z On -Site 0 VisionAIR Revision 2 (06/23/00) 11 VisionAIR, Inc Attachment "C" Statement of Work Administration - including NT/SQL Overview CAD 30 19 5 2 12 ® On -Site ❑ VisionAIR Telecommunicator Advanced CAD for 10 9 5 2 1 ® On -Site ❑ VisionAIR System Administrators* CAD LIVE** 2.0 NA NA NA 2 ® On -Site ❑ VlsionAlR CAD Consulting Day 10 NA NA NA 1 ® On -Site ❑ VisionAIR TOTAL DAYS ON -SITE FOR CAD 20 TOTAL DAYS AT VISIONAIR FOR CAD NOTES - *The Advanced CAD for SA class will include browse field orders, changing colors on dispatch screen, CAD Reports, and Ad -Hoc Reports The training should be completed Just before going LIVE ** One day of CAD LIVE will be used to clear tables and any other preparation required for going live RECORDS M AGEMENT SYSTEM TRAINING Software # # # # Total # Location of Training Training Trainees Computers Trainees/ Days — Days Available Terminal Training Per Module (b) (c) (d) (e) a RMS System 30 4 10 2 4 ® On -Site ❑ VisionAIR Administration including NT/SQL Overview RMS Basic & 10 179 10 2 14 ® On -Site ❑ VisionAIR Essentials* RMS Case Reports** to 33 10 2 4 ® On -Site ❑ VisionAIR Administration and 5 10 10 2 1 ® On -Site ❑ VisionAIR Personnel Bar Coding for 1 3 10 2 1 ® On -Site ❑ VisionAIR Evidence and Property Bike Registration 25 2 ❑ On -Site ❑ VisionAIR Budget Tracking 5 2 ❑ On -Site ❑ VisionAIR Citations 5 10 10 2 1 ® On -Site ❑ VisionAIR Civil 5 2 ❑ On -Site ❑ VisionAIR Equipment 10 3 10 2 1 ® On -Site ❑ VisionAIR Maintenance Gun Permits 25 2 ❑ On -Site ❑ VisionAIR Imagmg/Mugshots 5 30 10 2 3 ® On -Site ❑ VisionAIR Internal Affairs 5 1 10 2 1 ® On -Site ❑ VisionAIR Narcotics and 5 5 10 2 1 ® On -Site ❑ VisionAIR Intelligence Officer Activity Log 25 2 ❑ On -Site ❑ VlsionAlR Parking Tickets 1 25 2 ❑ On -Site ❑ VisionAIR Pawn 1 25 7 10 2 5 1 ® On -Site ❑ VisionAIR Revision 2 (06/23/00) 12 VisionAIR, Inc Attachment "C" Statement of Work Towing .25 2 10 2 5 ® On -Site ❑ VisionAIR Traffic Accident 15 15 10 2 3 ® On -Site ❑ VlsionAlR Reporting with Visio Wants and Warrants 25 18 10 2 5 ® On -Site ❑ VlsionAlR Mapping NA NA NA 2 NA ❑ On -Site ❑ VisionAIR RMS LIVE 10 NA NA NA 3 ® On -Site ❑ V►sionAIR Advanced RMS *** 1.0 35 NA 2 1 ® On -Site ❑ VIsionAIR RMS Consulting Day 1 1,0 NA NA 1 1 2 ® On -Site ❑ VlsionAlR TOTAL DAYS ON -SITE FOR RMS 415 TOTAL DAYS AT VISIONAIR FOR RMS NOTE: *The RMS Basic and Essentials Class needs to be attended by anyone who will be using the system The class will focus on the tool bar functions, searching techniques, and master indices ** The RMS Case Reports training includes. Case Mgt, Incident Arrest, Juvenile Custody, and Ibase Reporting. *** The Advanced RMS class includes advanced training on Ad Hoc Reports and Standard Reports and will take place after the Agency is LIVE. JAIL TRAININ # # # # Total # Location of Training Software Training Trainees Computers Trainees/ Days — Days Available Terminal Training Per (b) (c) (d) (e) Module a Jail System 2.0 4 10 2 2 ® On -Site ❑ VlsionAIR Administration and setup Jail Booking 20 15 10 2 4 ® On -Site ❑ VistonAIR whmagmg if applicable Jail Commissary w/ 05 2 ❑ On -Site ❑ VistonAIR Bar Coding, if applicable Jail Medical 05 15 10 2 1 ® On -Site ❑ VisionAIR Jail LIVE 20 NA I NA NA 2 ® On -Site ❑ VisionAIR Advanced Jail** 10 1 4 1 10 2 1 1 ® On -Site ❑ VisionAIR TOTAL DAYS ON -SITE FOR JAIL 10 TOTAL DAYS AT VISIONAIR FOR JAIL NOTE * The 2 days for JAIL LIVE Is based on 500 or less beds Training will increase 1 day per each 500 increments ** The Advanced JAIL class includes advanced training on Ad Hoc Reports and Standard reports MOBILE TRAINING Software # # # # Total # Location of Training Training Trainees Computers Trainees/ Days — Days Available Terminal Training Per Module (b) (c) (d) (e) a Mobile System 05 2 10 2 1 ® On -Site ❑ VisionAIR Administration Revision 2 (06/23/00) 13 VistonAIR, Inc Attachment "C" Statement of Work Mobile Base 0.5 265 10 2 19 ® On -Site VtstonAIR Mobile LIVE 10 NA NA NA 1 ® On -Site ❑ VtstonAIR including CAD Interface TOTAL DAYS ON•SITE MOBILE 21 TOTAL DAYS AT VISIONAIR FOR MOBILE Paperless Reporting 25 25 10 2 1 ® On -Site ❑ VtstonAIR System Administration Paperless Reporting* 1.0 226 10 2 1 14 1 ® On -Site ❑ VtstonAIR TOTAL DAYS ON -SITE PAPERLESS 15 TOTAL DAYS AT VISIONAIR FOR PAPERLESS NOTE * The training days per module for the Incident and Field Interview Reports is 0 5 days If the Agency is purchasing the Incident Field Interview and Accident Report, the required training is 10 day. FIRE TRAINING Software # # # # Total # Location of Training Training Trainees Computers Trainees/ Days — Days Available Terminal Training Per Module (b) (c) (d) (e) a System 30 3 10 2 3 ® On -Site ❑ VtstonAIR Administration for Fire & Setup* Fire Incident / 10 31 10 2 4 ® On -Site ❑ VtstonAIR Calendar Fire Personnel 10 9 10 2 1 ® On -Site ❑ VtstonAIR Fire Site / Water 1.0 34 10 2 4 ® On -Site ❑ VtstonAIR Source / Equipment Fire LIVE 10 1 NA 2 1 ® On -Site ❑ VtstonAIR Advanced Fire** 05 15 NA 1 2 1 ® On -Site ❑ VtstonAIR TOTAL DAYS ON -SITE FOR FIRE 14 TOTAL DAYS AT VISIONAIR FOR FIRE NOTE * If the Fire System Administrators have been trained on RMS System Administration, then only 2 days are required ** The Advanced FIRE class includes advanced training on Ad Hoc Reports and Standard reports EMS TRAINING Software # # # # Total # Location of Training Training Trainees Computers Trainees/ Days — Days Available Terminal Training Per Module (b) (c) (d) (e) a EMS Setup 2 4 10 2 2 ® On -Site ❑ VtstonAIR EMS Reporting 1 132 10 2 14 ®On -Site ❑VtstonAIR EMS Live 1 NA NA NA 1 ®On -Site ❑ VtstonAIR TOTAL DAYS ON -SITE FOR EMS 17 TOTAL DAYS AT VISIONAIR FOR EMS Revision 2 (06/23/00) 14 VisionAIR, Inc Attachment "C" Statement of Work Additional Training Infortttation A qualified VisionAIR Trainer will train during standard office hours (8.00 am to 5 00 pm) unless specified otherwise in this Statement of Work. The VisionAIR Trainer will provide hands on training and will provide handouts manualsq and documentation relevant to the software applications Training at VisionAIR Training Center Brevard, NC : When training at the VisionAIR Training Center, VisionAIR provides all hardware and materials necessary for training. Travel and related expenses are the responsibility of the customer. Will the Customer receive any training at the VisionAIR Training Centers Yes ONo How many trainees will the Customer send to the VisionAlR Training Center for training? Training On S►tep When training On Site, the VisionAlR Trainer will provide manuals and handouts relevant to the training. The Customer is responsible for the following unless specifically stated otherwise in this Statement of Work. providing adequate training facilities and all the hardware necessary for training, setting up the facilities for training; breaking down the facilities; and relocating the hardware to the appropriate place within the customer's facility at the completion of training Adequate facilities include, but are not limited to, the following physical space sufficient enough to accommodate the trainees, adequate electrical power and outlets; sufficient PC's for "Hands On" experience for each trainee (no more than 2 persons per PC recommended), and, installing the hardware to be used which includes setting up the hardware and installing all cables, power supply, telephone lines, etc Facilities should be ready for training to begin when the VisionAlR trainer arrives. Will the Customer receive any On -Site Tramm 9 Nyes No Training Center Location 601 E Hickory If the Customer will be trained ON SITE is there adequate physical space for training at the Customer location? Yes No If no, where will the training be heid9 Training Room Telephone # # where VisionAIR Trainer can be reached 940-349-7812 Have the travel and related expenses been included in the pricing for ON SITE Training Yes LNo NOTE- Unless Travel and Related Expenses have been included in the pricing for On Site training, the Customer will be billed the travel and related expenses incurred by the Vis►onAIR Trainer Has VisionAIR and the Customer agreed to any special arrangements or terms regarding training different than those described above? Yes ZNo If yes, describe in detail Additional comments Customer has the Option at their own expense to make Video Tape Copies of the Training Classes for their internal use. SECTION XI. CONFIGURATIONANSTALLATION NOTE Customer must provide VisionAIR with a detailed inventory list (both software and hardware) and a network d a ram as an attachment to the Statement of Work Network Configuration: The items delineated below must be complete before a network is considered functional This may be accomplished by the customer, a third party integrator, or the customer may purchase these services from VisionAIR 1 ) NT Server (PDC, BDC, VisionAIR Application • Security Configuration Server) • Service Pack Installation • Operating System Installation (NT Server) • TCP/IP Configuration • Additional NIC cards Installation (If Mirrored) Revision 2 (06/23/00) 15 VisionAIR, Inc Attachment "C" Statement of Work 2 ) Workstation • Tape device Installation (Admm PC) • Operating System Installation Windows 2000 • Modem configuration (Admm PC) • Service Pack Installation NOTE To preserve factory warranty, all integrated devices (e g additional processors in servers and/or workstations, memory) must be factory Installed or installed by factory -approved technicians V►sionAIR will not install integrated devices NOTE. The CAD Fax Server must utilize an external modem, not an internal DigiBoard modem NOTE Reference contract attachment, Network Hardware Specifications, "Setup Standards for Servers and Workstation" for detailed setup requirements Software Installation: VisionAIR representative will be responsible for installing VisionAIR developed Software products, as well as additional 3"1 party applications delineated below as part of Software Installation 1 ) NT Server • MS WINNT data dump (for backup purposes) • MS SQL Server • Backup Agent (if Seagate Backup is utilized) • VINCA (If Mirrored) • Seagate Executive Backup Software (BDC only) • VisionAIR Developed Products • Remote Access Service BDC Only) 2) Workstation • Snappy (for Imaging PC) • MS SQL Client • Seagate Executive Backup Software (Admm • VisionAIR Developed Products PC) • Visio (Sketching Software for Applicable PC's) • MS WINNT Backup (Admm PC if Seagate option not selected • Remote Access Service Adman P NOTE Customer will have the option of placing the tape drive and Backup Software on either the BDC or Administrator's Workstation. Customer will have the option of placing Remote Access Service on either the BDC or Administrator's Workstation Additional Services: The products and services listed below are not required to successfully install VisionAIR developed products, but may be purchased from VisionAIR to complete the configuration of the customer network 1) NT Servers • MS SNA Server (for NCIC access) • MS Exchange • MS SMS Server Configuration) 2 ) Workstations • Map Objects • Terminal Emulation • Crystal Reports • MS SNA Client (for NCIC access) • Email setup • Attachmate TCP/IP (NCIC access) • Crime View • Attachmate Pepgate (NCIC access SC only) • Wmbeep (paging software) • Rumba • MS SMS (Client Configuration) • Arcview Admm Station only) 2 ) Network peripherals • Jet Direct cards(Network Printing Capabilities) NOTE The network architecture is designed as an open system. The list of additional services is subject to change as third parties and VisionAIR continue to develop new products. Also, new technology may be introduced to g4prove customer productivity. Configuration/Iiistallationt Use the grid below to indicate the components of the network and the mstallation/confi ation services purchased from VisionAIR HARDWARE I # OF I SOFTWARE I NETWORK ADDITIONAL PRODUCTS COMPONENTS I COMPONENTS I INSTALLATION I CONFIGURATION AND SERVICES Revision 2 (06/23/00) 16 VisionAIR, Inc Attachment "C" Statement of Work SERVERS PDC 1 N/A NO BDC 1 N/A ES NO WmbeeRMS 2 YES NOES fYESES NO Co-StandbCAD 2 YES NO NO Co-StandbMESSAGE SWITCH 1 YES NOES NO SNA/NetOp SNA EYES NO On Message Switch Terminal Server 1 YES MNOVFS NO RMS Warm Spare Server 1 YES NO NT/S L WORKSTATIONS CAD 10 YES NO YES NO Plus 30 view only RMS 50 YES NOEYES NOFIRE 20 YES NOS NO JAIL 5 YES NOSEMS 20 YES NOSMOBILE 20 YES NOS NO LAPTOPS FIRE MOBILE 27 Z YES NO YES NO POLICE MOBILE 85 1 Z YES NO YES NO CONNECTIVITY: Type of Connectivity Hubs Switches 2 Routers Are all workstations located in the same physical location the same building Yes No Are all servers located in the same physical location the same buildir Yes No If No, include the locations of each server and each workstation Also, list the type of connectivity that currently exists between each location. E g. Modems TI lines, Fiber Optic, etc LOCATION CONNECTIVITYBAND WIDTH ADDITIONAL COMMENTS See attached location worksheet Have Travel and Related Expenses been included in the On Site Configuration/Installation cosh Z Yes No NOTE. Unless Travel and Related Expenses have been included in the installation/configuration pricing, the Customer will be billed the travel and related expenses incurred by the VisionAlR Technician Additional Comments See Attached Location Worksheet SECTION XII. PROJECT MANAGEMENT Revision 2 (06/23/00) 17 VisionAIR, Inc Attachment "C Statement of Work VisionAIR will assign a Project Manager to oversee and coordinate the implementation of this project The Project Manager will be the customer's point of contact throughout the implementation of the project The Project Manager duties include the following: -Track the status of current and pending milestones for the project schedule -Ensure the coordination of software installation dates -Ensure the coordination of training dates -Provide a liaison between VisionAIR and the Customer -Track and maintain a log of outstanding implementation issues -Maintain a master project schedule Explain in detail any special agreements made with the Customer regarding Project Management If Project Management requires on site services, have the travel and related expenses been included in the Project Management pricmg9 ®Yes ❑No NOTE. Travel and related expenses incurred by the VisionAIR Project Manager will be billed to the Customer unless included in the pricing. Additional Comments It is necessary for the Customer to sign off on the Work Completion Form's (WCF) as services are rendered and prior to the VisionAIR representative leaving the customer site The VisionAIR Project Manager must receive the signed Work Completion Form (WCF) prior to advancing to the next stage of implementation A signed WCF will denote deliver and completion of services rendered SECTION XIII. ADDITIONAL INFORMATION Use this space to provide any additional information or special agreements made regarding this project that are not covered elsewhere in this Statement of Work RIM Pagers. VisionAlR will provide 10 software licenses to Denton for the RIM pagers for TLETS access when TX DPS approves RIM pagers for TLETS access Note VisionAlR represents that the hardware, software, and services specified in this scope of work are necessary and sufficient to accomplish the functional requirements enumerated in Attachment "I" of the Software License Agreement, and CUSTOMER relies on VisionAIR's judgment in this regard In no event shall this document supercede or limit in any way VisionAIR's obligations to accomplish the functional requirements set forth in Attachment "I". Revision 2 (06/23/00) 18 ATTACHMENT "D" SOFTWARE SERVICE AGREEMENT City of Denton 601 East Hickory Denton, TX 76201 This SOFTWARE SERVICE AGREEMENT (hereinafter "Agreement') (incorporated in to the Software License Agreement of , 2000 as Attachment "D") is entered into by and between City of Denton (hereinafter "CUSTOMER") and VISIONAIR INC, a North Carolina based company with offices located at 5601 Barbados blvd , Post Office Box 9000, Castle Hayne, North Carolina 28429-9000 (hereinafter "VISIONAIR") VISIONAIR shall perform maintenance services on the Licensed Software and CUSTOMER shall accept and pay for such services, pursuant to the terms and conditions herein provided, Licensed Software shall mean the VISIONAIR software as described in the Quotation (Attachment "B") to the Software License Agreement), as such may hereafter be supplemented and as such Licensed Software may hereafter be updated with improvements, enhancements and modifications furnished to CUSTOMER by VISIONAIR 1 Term This agreement shall become effective on the date shown above (hereinafter "Effective Date"), and, unless sooner terminated as hereinafter provided, shall remain in full force and effect for an initial term of one (1) year from such date (hereinafter "Initial Term") 2 Automatic Renewal Upon expiration of the Initial Term, this Agreement shall be automatically extended on a month -to -month basis (hereinafter "Renewal Term") unless sixty (60) days prior to the expiration date of the Initial Term, or any Renewal Term, a party hereto gives written notice to the other party of its termination of the Agreement as of such expiration date 3 Maintenance Service Upon payment of the fees listed in the Quotation incorporated into the Software License Agreement as Attachment "B" (hereinafter "Quotation"), VISIONAIR shall use commercially reasonable efforts to provide Maintenance Service for the term of this Agreement The term "Maintenance Service" as used herein means Covered Maintenance and Billable Call Maintenance as hereinafter defined 4 Covered Maintenance The term "Covered Maintenance" as used herein means the periodic and on -call remedial maintenance VISIONAIR deems reasonably appropriate and necessary to keep the application software functioning properly Covered Maintenance shall include (a) Unlimited Telephone Support for the Licensed Software, utilizing an 800 line provided by VISIONAIR During the Initial Term, this telephone support will be available during the hours specified in the Quote (b) Initial fact-finding (Tier 1) support for 3rd party software embedded or used in conjunction with the application software (c) Correction of documented malfunctions ("bugs") in the application software (d) Assistance in installing updates and new releases of the Licensed Software on the CUSTOMER's servers (a) Processing CUSTOMER's request for changes to the Software A VISIONAIR Product Manager will define the CUSTOMER's request and submit it for consideration in future releases of the Software (f) Support to CUSTOMER while CUSTOMER is backing up its data Telephone support personnel are available to answer questions related to the Software and to provide remedies for "bugs" or defects within the Software When necessary, CUSTOMER will provide access to its network in order for to provide remote diagnostic services and to take corrective actions CUSTOMER will make available a dedicated telephone line and modem for use by VISIONAIR support If the problem cannot be resolved remotely, VISIONAIR will, if deemed necessary, come to CUSTOMER's site to correct the problem and restore the Licensed Software to its normal functioning state 5 Billable Call Maintenance The term "Billable Call Maintenance" as used herein means services provided by VISIONAIR that are not covered under Covered Maintenance The rate for this service shall be $75 00 per hour (the "Billable Call Rate") Hours expended may not exceed 8 hours without written authorization by CUSTOMER 6 Exclusions from Covered Maintenance Covered Maintenance does not include (a) Repair of damage not caused by VISIONAIR, including without limitation, damage resulting from accident, transportation, neglect or misuse, lightning, failure or fluctuation of electrical power, air conditioning or humidity control, telephone equipment or communication Imes failure, failure of foreign interconnect equipment, or causes other than normal operation procedures (b) Service which is impractical for VISIONAIR to render because of alterations in the Licensed Software made by persons other than VISIONAIR without receiving VISIONAIR's prior written approval, the connection of equipment and/or Software by mechanical or electrical means to another machine or device, or the physical inaccessibility of the equipment or Software (c) Any repair of any damage to the Licensed Software caused by software or firmware programming that is not provided or supported by VISIONAIR under section 5 7 Enhancements & Upgrade Support Covered Maintenance shall include standard upgrades and enhancements that are made to the Licensed Software VISIONAIR issues corrections, upgrades and enhancements to the software on an ongoing basis VISIONAIR will use commercially reasonable efforts to update the Licensed Software as necessary to stay compliant with State and Federal requirements for crime reporting and information access All modifications to the Licensed Software and related Documentation will be sent to the customer on standard electronic media (CD-ROM) and/or be installed as an executable utilizing the RAS connection 8 Chases to Customers (a) Charges for Covered Maintenance The applicable rates for Covered Maintenance are set forth in the Quotation (Attachment "B" to the Software License Agreement) (b) Charges for Billable Call Maintenance The hourly rate is as provided in Section 5 (c) Charges for Travel Upon prior written authorization, CUSTOMER shall pay for travel time and travel expense in connection with Billable Call Maintenance Travel time will be charged to the CUSTOMER at the Billable Call Rate Travel expense will be charged as incurred and includes tolls, parking and other out-of-pocket costs plus mileage at the then current rates There will be no additional charge to the CUSTOMER for travel expense incurred in connection with Covered Maintenance (d) Charge for Software License Changes All Covered Maintenance fees hereunder are subject to increase or decrease upon any change in number of concurrent user licenses or software modules licensed 9 Changes in Charges At least 120 days prior to the expiration of the Initial Term or any Renewal Term, VISIONAIR may make changes to the Covered Maintenance fees and the Billable Call Rate, such changes to be effective at the commencement of the immediately subsequent Renewal Term, if any CUSTOMER, may terminate this Agreement within sixty (60) days after receipt of the first invoice with changed charges by giving VISIONAIR sixty (60) days written notice of its intention to terminate, and this agreement will terminate as of the date for termination set forth in the CUSTOMER's notice to VISIONAIR or at the end of such sixty (60) day period, whichever last occurs 10 Poyment VISIONAIR will invoice the CUSTOMER in advance for each term, Initial or Renewal, for Covered Maintenance Such invoices will include pro rats charges or credits for any Covered Maintenance of Licensed Software installed or removed during the previous term or prior to the Effective Date VISIONAIR will invoice CUSTOMER for Billable Call Maintenance as incurred and CUSTOMER shall pay invoices for Covered Maintenance, including any invoices outstanding on the Effective Date of this Agreement, on or prior to the commencement of each term 11 Disclaimer of Warranty The warranties applicable to this Software Services Agreement are those contained within the Software License Agreement of which this attachment is a part 12 Limitation of Liability The parties agree that the limitations of liability applicable to this Software Services Agreement are those contained within the Software License Agreement of which this attachment is a part 13 Hardware and Network Upgrades CUSTOMER acknowledges that due to the dynamic nature of the information technology industry and frequent product replacements and/or upgrades developed independently by third party hardware and software vendors, VISIONAIR has no control over the turnover of product or obsolescence of technology of third party products CUSTOMER also acknowledges that VISIONAIR develops its Network Hardware Specification Document based upon all of the third party product information available to it Therefore, with respect to third party hardware and software, CUSTOMER shall retain the responsibility for the costs of purchase and installation of hardware and software upgrades necessary to maintain the functionality of the Licensed Software Additionally, the accumulation of storage of records in CUSTOMER's database over an extended period of heavy use may require expanding the capacity and memory of the operating system in order to maintain performance at response times acceptable to the CUSTOMER Subject to all of the affirmative duties and obligations of VISIONAIR under this Software Maintenance Agreement, it is the CUSTOMER's responsibility to maintain the operating system to ensure adequate response times Provided that VISIONAIR will maintain its Licensed Software to use the most currently released version (s) of Microsoft operating systems and database software designed to function on Client -Server architecture 14 Force Maieure Neither party shall be liable or deemed in default for any failure in performance hereunder resulting from any cause beyond its reasonable control 15 Termination for Non-payment If CUSTOMER is in default due to non-payment, and after VISIONAIR has given CUSTOMER written notice and such default is not cured after 15 days then VISIONAIR may terminate this agreement at any time upon written notice to CUSTOMER 16 Notices Any Notice, request, instruction or other document pertaining to this Agreement shall be sent to the appropriate party's address as set forth above, and shall be deemed to have been duly given or served if delivered in person or deposited in the United States mad, certified mail, return receipt requested 17 General This Agreement shall be governed by the laws of the State of Texas This Agreement constitutes the entire agreement between the parties hereto with respect to maintenance of the Licensed Software and shall supersede all previous or contemporaneous negotiations, commitments and writings with respect to matters set forth herein It may be only modified by writing signed by authorized representatives of both parties The terms and provisions of this Agreement shall prevail over any conflicting, additional or other terms appearing on any purchase order submitted by the CUSTOMER at any time VISIONAIR, INC 11 / Signature Name; Richard J Holloman Title President Date I'll id tcW CITY OF; TON Signatur Name Je Title City Mgnager Date ���[ q /0,0 July 10, 2000 Revision # 9 Attachment "E" Network Hardware Specifications VISION SOFTWARE NT NETWORK REQUIREMENTS The following guidelines are designed to set up successful NT networks There are wide variations and types of network designs Of these, Vision Software (VSI) will support the following network configurations 1 Enterprise Networks The Vision Public Safety Suite is designed to function in a multi -server environment commonly called an Enterprise Network This Network consists of the following servers • Primary Domain Controller Security manager for the network Single point of management for users, groups and access rights • Backup Domain Controller, (optional) Backup security manager for the network Seagate Backup Software (optional) Backup Tape Drive Device (optional) • SQL Server CAD Database Engine/Application Server for VSI CAD • SQL Server RMS/JAIL Database Engine/Application Server for VSI RMS/JAIL • Vision Message Switch Communications interface to Mobile or NCIC/State interface Supports VSI CAD, VSI MOBILE, VSI RMS interfaces to other data systems • Vision GEO Server Geographic (mapping) Server • SQL Server FIRE Database Engine/Application Server for VSI RMS/JAIL • Exchange Server Mail (Email) Page - I July 10, 2000 Revision # 9 RECOMMENDATIONS FOR NETWORKS USING VSI APPLICATIONS *** Microsoft Hardware Compatibility List (HCL) Hardware for ALL SERVERS and CLIENTS must be on the Microsoft Hardware Compatibility List (HCL) If the customer is procuring servers directly, and has acquired hardware that does not match the HCL, VSI cannot guarantee the performance of VSI applications Network Security VSI Application servers can be added to an existing Window NT security domain without difficulty The customer is responsible for management of the security domain A Primary Domain Controller (PDC) is highly recommended for security management if • The Network supports more than ten users, OR • The Network includes two or more servers A Backup Domain Controller is highly recommended if the customer is using a Primary Domain Controller It is not required, but if the PDC is down, the network security system is also not functional Limitations on Servers runnina VSI Applications VSI does not approve of other server services operating on the Server supporting the VSI Application This requirement is reiterated in the VSI Hardware Configuration Guide If the customer needs additional server services, an additional server must be added to the Network If the Customer fads to heed this requirement, VSI will not guarantee application performance in any way Hardware Reauirements and Suaaestions All SQL servers must have at least two hard drives and at least a dual channel SCSII controller The primary hard drive (the larger of the two drives, if they are not the same size) and one SCSII control channel will be used for the NT Operating System, SQL Server, Page File and data files for CAD or RMS applications The secondary hard drive and the other SCSII control channel will be used for the SQL Server transaction log The recommended file system is NTFS for all servers and clients When using a fault tolerant (high availability or clustered) server system, two network cards are required in each server With separate IP scheme and Wins disable on the second NIC The preferred network backbone structure is a 100MB/TX or greater Switched Network A Work Group using a 100MB/TX hub can be set up off the switched backbone The customer is responsible for installing the Network The Network must be certified in accordance with T568B standards VSI must have a copy of the Network Certification report, which states that the Customer's network meets or exceeds this standard If the Page - 2 July 10, 2000 Revision # 9 structure is not certified and Vision Software incurs costs evaluating the network, the customer will be billed for time and materials for this additional unplanned work The customer is responsible for any connections to third party equipment such as ANI/ALI controllers A technician from the third party vendor (or agency) must be on -site when the VSI application software is loaded on the Customer's Network This is to ensure that connectivity between with the VSI application server and the third party data system is correctly installed The customer is responsible for ensuring that each network server and client has an adequate power supply Adequate Un-interruptible Power Supply (UPS) systems to provide backup power to the network (servers and CAD clients, in particular) are highly recommended Optional Server Requirements SMS (Systems Management System) • SMS is highly recommended for networks with 25 or more clients as it significantly reduces system administration workload • Training and appropriate setup time is required to implement SMS • If SMS is used, it will reside on the Primary Domain Controller (PDC - the security server) No other server services should reside on the PDC • VSI can provide network system management remotely To do so, the contract between VSI and the Customer must include specific terms for this service • Also, in order for VSI to provide this service, the customer must have 1 SMS (Systems Management System) implemented on the network 2 Have at least a 56k Modem or an ISDN line/Modem to allow for remote system management Have Windows NT Server, Terminal Server Addition, OR NetOp Remote Control software (CrossTec Corp ) Exchange If the customer is using or plans to use Exchange, Exchange requires a dedicated server SNA If an SNA server is required, SNA can reside on the VSI Message Switch server or a server dedicated for SNA Backups & RAS services These services will reside on the Backup Domain Controller (BDC) or the Systems Administrator's workstation Depending on the type of backup device used (tape drive, etc ), a dedicated SCSII controller should be installed for better performance Page - 3 July 10, 2000 Revision # 9 • If used, 'open file" backup applications should reside on all servers • RAS-Modem connectivity should also be part of the Backup Domain Controller (BDC) or the Systems Administrator's workstation using a 56K Modem or an ISDN line/Modem • If using some form of Clustering the Connection Manager for CAD must be installed on the BDC • Please check with your Salesperson or Project Manager for the correct version of SQL Approved Software, Operating System, and Service Pack (SP) Workstation Windows, NT Workstation 4 0 with SP 6a Visio 5 0 (for on-line sketching) Snappy 3 0 (for Image transfer) Servers Windows NT Server 0 with SP 6a Windows NT Server, Terminal Server Addition 4 0 with SP 5 • Citrix MetaFrame 1 8 Windows NT SQL Server (check with your Salesperson or Project Manager for the correct version) SMS20 NetOp 6 0 (Host) Vince Co�Standby for NT 4 2(for Clustered Servers) Exchange 5 5 Bar Coding Equipment American Microsystem 800 648 4452 WWW B6RCODEPOWER COM Portable Data Terminal M3KY1-LAS-PS0010 Autosense ACC-0100 Case & Belt Strap CAS-3000-B Cable Shunt CBL-3015 Bar Code Printer (prints only bar code) Intermec Corp WWW INTERMEC COM Model # 3400 D Page - 4 July 10, 2000 Revision # 9 SETUP STANDARDS FOR SERVERS AND WORKSTATION Primary Domain Controller Hardware Optimal (see hardware requirements document) NT Server NT Server 4 0 w/ Service Pack 68 SMS / SQL Server (BackOffice) (optional) NT Resource Kit 2 Name = "Agency Name"_ PDC Domain = Agency supplied File System = NTFS Services Computer Browser (Default) NetBios Interface (Default) RPC Configuration (Default) Server (Default) Microsoft DHCP Server (Note Split range with BDC So range would be 1-150 and exclude 1-50 as static addresses Also set lease to 30 days Note Enable Maximize throughput for network applications (Server service) Windows Internet Naming Service (Primary WINS server, push pull partnership with BDC) Protocol Microsoft TCP/IP Note Must be a static TCP/IP number on servers Backup Domain Controller Hardware Optimal (see hardware requirements document) NT 4.0 Server NT Server 4 0 w/ Service Pack 6a NT Server, Terminal Server edition 4 0 w/Service Pack 5 (optional) Name = "Agency Name"_ BDC Domain = Whatever the PDC is set to File System = NTFS Services Default Services Plus RAS Microsoft DHCP Server (Backup) (Note Split range with PDC So range would be 150-254 Also set lease to 30 days Note Enable Maximize throughput for network applications (Server service) Windows Internet Naming Service (Backup push pull partner with PDC) Protocol Microsoft TCP/IP Note Must be a static TCP/IP number Page - 5 July 10, 2000 Revision # 9 SQL Server CAD or RMS Hardware Optimal (see hardware requirements document) NT 4.0 Server NT Server 4 0 w/ Service Pack 6a MS SQL Server Name _'Agency Name"_ CAD or "Agency Name"_ RMS Domain = Whatever the PDC is set to File System = NTFS Services Default Services Plus Note Enable Maximize throughput for network applications (Server service) Software SQL Installed according to VSI Documentation Vince Installed according to VSI Documentation Protocol Microsoft TCP/IP Note Must be a static TCP/IP number Message Switch Hardware Optimal (see hardware requirements document) NT 4.0 Server NT Server 4 0 w/ Service Pack 6a Name ="Agency Name"_ MSG Domain = Whatever the PDC is set to File System = NTFS Services Default Services Plus Note Enable Maximize throughput for network applications (Server service) Protocol Microsoft TCP/IP Note Must be a static TCP/IP number Page - 6 July 10, 2000 Revision # 9 CAD Workstation Hardware Optimal (see hardware requirements document) WInNT Workstation NT workstation 4 0 w/Service Pack 6a Name = CAD_1 etc Domain = Whatever the PDC is set to File System = NTFS Software Visio BackOffice Client CAD client installed according to VSI Documentation Protocol Microsoft TCP/IP Note must be a static TCP/IP number CAD Fax Server Hardware Optimal (see hardware requirements document) Note must be external Modem (DlgiBoard are not allowed) WinNT Workstabon NIT workstation 4 0 w/Service Pack 6a Name = CAD_1 etc Domain = Whatever the PDC is set to File System = NTFS Software Visio BackOffice Client CAD client installed according to VSI Documentation Protocol Microsoft TCP/IP Note must be a static TCP/IP number RMS Workstation Hardware Optimal (see hardware requirements document) WInNT Workstation NIT workstation 4 0 w/ Service Pack 6a Name = RMS_1 etc Domain = Whatever the PDC is set to Page - 7 July 10, 2000 Revision # 9 File System = NTFS Software Vislo BagkOfBce Client RMS Client installed according to VSI Documentation Protocol Microsoft TCP/IP Note Must be set for DHCP Administrators Workstation (If No BDC) Hardware Optimal (see hardware requirements document) WInNT Workstation NT workstation 4 0 w/ Service Pack 6a Name = Admin Domain = Whatever the PDC is set to File System = NTFS Software Vislo BackOffios Client CAD client installed according to VSI Documentation Services Default plus following Net Monitoring agent (This service is on the SMS CD, which is part of BackOffice) RAS Jet Direct if used Protocol Microsoft TCP/IP Note Must be set for DHCP Backup Depending on the type of backup device, a SCSII controller and hard drive are recommended for this client Page - 8 July 10, 2000 Revision # 9 PRE -INSTALLATION NETWORKMARDWARE CHECK LIST Network Backbone ➢ Depending on type of network ➢ 100MB TX ➢ CAT5 wired in T568B standards, Plenum or Non -Plenum depending on local building codes ➢ CAT5 Shielded/Grounded in all communications facilities, T568B standards ➢ Provide Vision Software with "Certification" results of installed and tested cable If Certification is not provided, VSI will install network as 10BT, 10 megabyte per second standards" Vision Software can provide certification of existing cable on a time and material basis Rates are based at $125hr labor plus materials for a two -man team plus travel and per -diem for certification only ➢ 106ase "T" ➢ CAT3, 4 or 5 Plenum or Non -Plenum depending on local budding codes wired in a standard "10BT" configuration This will only support 10 megabyte per second standards Server Room ➢ Sufficient power requirements to support ➢ UPS/Battery backup(s) ➢ Suaaested. Generator power for equipment rack(s) in case of power failure, or large enough UPS battery backups to keep equipment powered for 15 minutes for proper shut down ➢ Servers ➢ Monitors ➢ Hubs / Routers / Switching equipment ➢ Modems & dial in equipment ➢ Sufficient outlets ➢ (1) 110 three prong per piece of equipment ➢ Equipment Rack(s) ➢ Standard 19"w x 7' tall ➢ 19" x 24" footprint, per rack ➢ (4) Computers per Page - 9 July 10, 2000 Revision # 9 ANI/ALI Requirements ➢ Sufficient Documentation ➢ Make and Model of equipment ➢ Is there an RS232 port to output ALI to CAD system? ➢ Customer (or Telco company) to supply ALI layout in printed format, field layouts and spacing requirements to produce a functional database for CAD system ➢ Requirements for RS232 communications ➢ DCE or DTE circuit ➢ 9pin RS232 Female (vision end of cable) ➢ pins 1-(Frame GND) 2-(TX) 3-(RX) 5-(GND) ➢ Handshaking must be satisfied by ANI/ALI vendor's equipment Vision Software will provide an ACK character for each HEARTBEAT supplied, and ACK character for each ETX character received NCIC Connectivity ➢ Provide Contact and information for ➢ State NCIC computer information ➢ Type of Protocol utilized in the state examples are ➢ TCP/IP ➢ LU6 2 ➢ LU2 ➢ Polling BI-Sync ➢ SNA 3270 ➢ Locations of all terminal emulation's Pre -installation Computer/ Printer storage ➢ Customer will insure ➢ Sufficient on -site storage of all hardware pnor to installation Computer Printer Placement ➢ Customer will insure ➢ Sufficient power requirements are met for each location of a computer system ➢ Power outlets or power strip is provided ➢ Desks are removed of obstacles to place equipment ➢ Printer work areas are removed of obstacles to place equipment ➢ Network Cable within reasonable distance Trash ➢ Customer will insure ➢ Temporary placement of broken down boxes and Styrofoam during installation Trash receptacle/bin for final removal Page - 10 July 10, 2000 Revision # 9 Optimum Hardware Specifications Primary Domain Controller w/SMS (2) Intel Pro NIC, 144 Floppy Drive, MS Mouse, Keyboard, CD-ROM Drive NT BackOfflce Server Software w/SP6a, NT Resource Kit 1 - 50 users PIII 500 — 512kb Cache, 256mb Ram (2) 9gb SCSI HD (Raidl) HSwap SCSI Raid Controller — 16MB Cache 50 — 500 'Users (2) PIII 500 —1 mb Cache, 512mb Ram (3) 9gb SCSI HD (Rald5) HSwap SCSI Raid Controller —32MB Cache Cluster Dual Intel Pro NIC's 500 + Users (2) PIII 500 — 1 mb Cache, 1gb Ram (2) 9gb SCSI HD (Raid1) HSwap (3) 9gb SCSI HD (Raid5) HSwap Dual SCSI Raid Controller — 64MB Cache Cluster Dual Intel Pro NIC's Backup Domain Controller w/TS (2) Intel Pro 10/100mb NIC, 144 Floppy Drive, MS Mouse, Keyboard, CD-ROM Drive, (ext) 56k Modem Tape Backup Drive w/SCSI Adapter Cable, NT Terminal Server w/SP5 and Citnx MetaFrame 1 8 Ventas Backup Exec NT/2000 (Optional Multi Server) (Option Packs SQL Server Agent (1 per SQL license) and Open File Manager Agent (1 per Server)) Note: The below machines are listed as Dual and Quad processor If you are running all the above on the machines 1-5 users (2) PIII 500 - 512kb Cache, 512mb Ram (2) 9gb SCSI HD (Raidl) HSwap SCSI Raid Controller —16MB Cache 5-10 users (2) PIII 500 —1 mb Cache, 1 gb Ram (3) 9gb SCSI HD (Reid5) HSwap SCSI Raid Controller — 32MB Cache Cluster Dual Intel Pro NIC's 10-25 users (4) PIII 500 —1 mb Cache, 2gb Ram (2) 9gb SCSI HD (Raidl) HSwap (3) 9gb SCSI HD (Raid 5) HSwap Dual SCSI Raid Controller —64MB Cache Cluster Dual Intel Pro NIC's " Notes Exchange I Server should now be on It's own Hardware Server Page - 11 July 10, 2000 Revision # 9 CAD Servers (2) Intel Pro NIC, 144 Floppy Drive, MS Mouse, Keyboard, CD-ROM Drive Crossover Cable, NT Server w/SP6a, MS SQL Server Vince Co -Standby for NT V4 2 Note Only one NIC is needed if you are not clustering the machines 1-5 Users (2) PIII 500 — 1mb Cache, 512mb Ram (2) 9gb SCSI HD (Raid1) Hswap (OS) 9gb SCSI HD (Tlog), 9gb SCSI HD (Data) Dual Channel SCSI Raid Controller —32mb Cache SCSI Controller —16MB Cache 5-20 Users (2) PIII 500— 1mb Cache, 1gb Ram (2) 9gb SCSI HD (Raid1) Hswap (OS) 9gb SCSI HD (Tlog), (3) 9gb SCSI HD (Raid5) Hswap (Data) Dual Channel SCSI Raid Controller — 64mb Cache SCSI Controller —16MB Cache Cluster Dual Intel Pro NIC's 20-50 Users (2) PIII 500 —1mb Cache, 1gb Ram (2) 9gb SCSI HD (Raid1) Hswap (OS) (2) 9gb SCSI HD (Raid1) Hswap (Tlog) (3) 9gb SCSI HD (Raid5) Hswap (Data) Dual Channel SCSI Raid Controller —64mb Cache SCSI Raid Controller — 32MB Cache Cluster Dual Intel Pro NIC's Page - 12 July 10, 2000 Revision # 9 RMS / Fire/ Jail Servers (2) Intel Pro NIC, 144 Floppy Drive, MS Mouse, Keyboard, CD-ROM Drive Crossover Cable, NT Server w/SP6a, MS SQL Server Vince Co -Standby for NT V4 2 Note Only one NIC Is needed if you are not clustering the machines 1-5 Users (2) PIII 500 —1mb Cache, 512mb Ram (2) 9gb SCSI HD (Raid1) Hswap (OS) 9gb SCSI HD (Tlog), 9gb SCSI HD (Data) Dual Channel SCSI Raid Controller — 32mb Cache SCSI Controller —16MB Cache 5-40 Users (2) PIII 500 — 1 mb Cache, 1 gb Ram (2) 9gb SCSI HD (Raid1) Hswap (OS) 9gb SCSI HD (Tlog), (3) 9gb SCSI HD (Raids) Hswap (Data) Dual Channel SCSI Raid Controller —64mb Cache SCSI Controller —16MB Cache Cluster Dual Intel Pro NIC's 40-100 Users (2) PIII 500 —1 mb Cache, 1gb Ram (2) 9gb SCSI HD (Rald1) Hswap (OS) (2) 9gb SCSI HD (Raid1) Hswap (Tlog) (3) 9gb SCSI HD (Raids) Hswap (Data) Dual Channel SCSI Raid Controller —64mb Cache SCSI Raid Controller— 32MB Cache Cluster Dual Intel Pro NIC's Page - 13 July 10, 2000 Revision # 9 MSG Switch / SNA Server (2) Intel Pro NIC, 144 Floppy Drive, MS Mouse, Keyboard, CD-ROM Drive (1) Microgate SDLC card if SNA is installed NT Server w/SP6a PIII 500 - 512kb cache 512mb Ram (2) 9gb SCSI HD (Raidl) Hswap SCSI Raid Controller —16MB Cache CAD Workstations PIII 500 - 256kb cache, 128mb Ram *** If state Interfaces or 3rd party client software Is to be Installed then more memory is required 4gb IDE or SCSI HD Dual 17' Monitors Dual Video Graphics card NT Workstation w/SP6a Intel Pro NIC NT Server Access License or BackOffice Cal RMS/Fire/Jail Workstations PIII 500 - 256kb cache, 64mb Ram (128mb Ram if using for Imaging/ Scanning or Bar-coding) *** If state Interfaces or 3rd party client software Is to be Installed then more memory is required 4gb IDE or SCSI HD 15" Monitors NT Workstation w/SP6a Intel Pro NIC NT Server Access License or BackOffice Cal Vislo V5 Mobile laptops PII 300 64mb Ram *** If 3rd party client software is to be installed then more memory Is required 4gb HD NT Workstation w/SP6a NT Server Access License or BackOffice Cal All Printers LaserJet supporting PCL 4 and/or 5 Note Please make sure you have purchased or have a Hardware Vendor that can supply you will backup items mcase of emergency. This would include items like keyboards, hub/switch etc. Page - 14 2 m 1 o p W RS W w 11 y U Optimized System Specs for City of Denton Public Safety PDC and BDC 144 Floppy Drive, MS Mouse, Keyboard, CD-ROM Drive Windows NT Server w/SP6a, NT Resource Kit • Rack mounted • Redundant power supplies • Dual PIII Xeon 550 MHz+ o 1 MB or 2 MB L2 cache • 1 GB SDRAM Dual channel SCSI RAID controller — 64+ MB cache o Two 18 GB disks on first channel in RAID 1 array ■ OS o Two 18 GB disks on second channel in RAIDI array ■ Paging file o One Online hotspare Drive cage with two backplanes for support of dual channel RAID controller Dual NICs (that support NIC load balancing — such as Intel 82559+) Additionally for BDC • 56k Modem (for VisionAir remote dial in support) • Veritas Backup Exec 8 x (Optional Multi_Server) o Option Packs SQL Server Agent (1 per SQL license to be backed up) and Open File Manager Agent (1 per Server to be backed up) Terminal Server 144 Floppy Drive, MS Mouse, Keyboard, CD-ROM Drive Tape Backup Drive w/SCSI Adapter Cable, NT Terminal Server w/SP5 and Citrix MetaFrame 18 • Rack mounted • Redundant power supplies • Quad PIII Xeon 550 MHz+ o 1 MB or 2 MB L2 cache • 4 GB SDRAM • Dual channel SCSI RAID controller —128+ MB cache o Four 18 GB disks on first channel in RAID array ■ OS o Two 18 GB disks on second channel in RAID array ■ Paging file o One Online hotspare Drive cage with two backplanes for support of dual channel RAID controller Dual NICs (that support NIC load balancing — such as Intel 82559+) Message Switch 144 Floppy Drive, MS Mouse, Keyboard, CD-ROM Drive Windows NT Server w/SP6a, NT Resource Kit, Microsoft SNA Server • Only one of the below is needed when running SNA for the State Interface o Serengeti Sync+/AT SDLC Adapter for MS SNA 1-512-345-2211 o MicroGate SDLC for MS SNA 1-512-343-9046 Part # 172113 • Rack mounted • Redundant power supplies • Dual PIII Xeon 550 MHz+ o 1 MB or 2 MB L2 cache • $12 MB SDRAM • Dual channel SCSI RAID controller— 64+ MB cache o Two 18 GB disks on first channel in RAID 1 array ■ OS o Two 18 GB disks on second channel in RAID array ■ Paging file o One Online hotspare • Drive cage with two backplanes for support of dual channel RAID controller • Dual NICs (that support NIC load balancing —such as Intel 82559+) Inform Intranet IIS (Web) Server 144 Floppy Drive, MS Mouse, Keyboard, CD-ROM Drive Windows NT Server w/SP6a, NT Resource Kit, IIS 4 0 • Rack mounted • Redundant power supplies • Dual PIII Xeon 550 MHz+ o 1 MB or 2 MB L2 cache • 512 MB SDRAM • Dual channel SCSI RAID controller — 64+ MB cache o Two 18 GB disks on first channel in RAID 1 array ■ OS o Two 18 GB disks on second channel in RAID 1 array ■ Paging file o One Online hotspare • Drive cage with two backplanes for support of dual channel RAID controller • Dual NICs (that support NIC load balancing —such as Intel 82559+) Warm Spare Server 144 Floppy Drive, MS Mouse, Keyboard, CD-ROM Drive Windows NT Server w/SP6a, NT Resource Kit • Rack mounted • Redundant power supplies • Dual PIII Xeon 550 MHz+ o I MB or 2 MB L2 cache 1 GB SDRAM Dual channel SCSI RAID controller — 64+ MB cache o Two 18 GB disks on first channel in RAID 1 array ■ OS and paging file o Two 36 GB disks on second channel in RAID array ■ SQL and Vision database files o Two 18 GB disks on second channel in RAID array ■ Transaction log files o One Online hotspare Drive cage with two backplanes for support of dual channel RAID controller Dual NICs (that support NIC load balancing — such as Intel 82559+) VisionCAD and VisionRMS Servers Note You will need two VisionCAD Servers and two VisionRMS Servers 144 Floppy Drive, MS Mouse, Keyboard, CD-ROM Drive Windows NT Server w/SP6a, NT Resource Kit, MS SQL Server 7 0, Legato Co -Standby Server 4 3 (Vmca) • Rack mounted • Redundant power supplies • Quad PIII Xeon 550 MHz+ o 1 MB or 2 MB L2 cache • 4 GB SDRAM • Dual channel SCSI RAID controller —128+ MB cache o Four 18 GB disks on first channel in RAID 1 array ■ OS o Two 18 GB disks on second channel in RAID array ■ Paging file o One Online hotspare • Drive cage with two backplanes for support of dual channel RAID controller Dual NICs (that support NIC load balancing — such as Intel 82559+) • Additional NIC (for cluster heartbeat connection) • Crossover cable (for cluster heartbeat connection) • Fibre channel controller (for connection to shared storage fibre device) Fibre Channel Shared Storage Device (external storage) Note: You need two of these main devices — one for the RMS cluster and one for the CAD cluster. Plus you will probably need two expansion devices — one per main device (for additional storage space because main devices typically only hold 10 —12 disks). Note This device must support a configuration in which two Servers can actively share the storage simultaneously) (i a Dell PowerVault 650F) • Redundancy throughout (i a dual power supplies, dual Procs, dual bus — similar to Dell PowerVault 650F) • Rack mounted • Dual Processor or dual channel that can support or expand to 15 disks or more (i a Dell Powervault 630F) — 256+ MB cache o Six 18 GB disks on first processor or channel in RAID 0+1 array ■ SQL and Vision database files o Four 18 GB disks on second processor or channel in RAID 0+1 array ■ Transaction log files o Four 18 GB disks on second processor or channel in RAID 0+1 array ■ Tempdb o One 18 GB online hot spare (per enclosure, or device) o Note add additional disks, in parrs, to each RAID array for multiplied read/wnte performance An Ideal disk subsystem configuration for two clustered VlslonRMS or VlslonCAD servers option 01, best performancelfaulttolerance byChrlsVikher Server Cofiguration primary Sarver - two servers actively Clustered using Vince or Microsoft Cluster Server - appropriate RAM and CPU (s) Server's Internal disk Fld Mama18C81 Controller Nullaron aervar Partition and/ or Channel / t` Note The shaded boxes labeled with a number represent dlgerent partitions Ideally, they would also represent dhkI dhki separate channels, and for best performance, separate controllers RAID 1 RAID 1 OS and Pagefile SOL D 1 drive application C 1 drive objective This configuration maximizes the performance, longevity and redundancy of the disk subsystem in the following ways 1 spreading critical components of 10 out on their own physical disk controllers and/or channels of a controller 2 adding more disks to an array increases the potential number of disk reads and writes (10) per second 3 RAID 1 provides maximum redundancy of all RAID configurations 4 RAID 1r0 provide maximum redundancy combined with best 10 performance Shared External Storage fibre or SCSI External storage device's disk subsystem 1bn orsCSiwow1krh a#amal> raga d.1AW 1 R 3 RAID 110 RAID 1/0 Database Transaction flles Logs E 1 drive F 1 drive Pros 1 fastest performance 2 highly fault tolerant 3 Simple design 4 More flexibility in monitoring and resource allocation Cons 1 Most expensive RAID 1/0 Tempdb G 1 drive VISION RMS' MASTER NAME HISTORICAL SUMMARY (MNHS) METHODOLOGY VisfonAIRi INC. Attachment F VISION Master Name Historical Summary (MNHS) Methodoloev VislonAIR Inc 10110199 I. Introduction VisionAIR has developed a technology that incorporates customer legacy data into VlsionRMS in a way that retains its historical accuracy while ensuring the integrity of the VlsionRMS Records Management System VisionAIR's Data Transfer Services Department, VisionDTS, provides the customer with a snapshot of mission critical data from their previous system so that tins system may be removed from service while allowing for the data to be referenced on a day by day basis for as long as necessary Vision's methodology is to take the existing legacy data that has been mapped into a set of pre -defined table structures and load it into a self-contained SQL aware database External access to this data is provided for basic searches and generic reporting using either VisionAIR supplied tools or commercial off the shelf software 'Historical Data' consists of a variety of attributes pertaining to specific historical events such as arrests, citations, warrants, incidents, offenses, etc , which are associated with a name entity In a similar manner, narratives and unages may also be included and associated with name and summary records Historical data can be searched from within VisionRMS by any of the data fields and narrative text Customers are responsible for mapping their data to the specific table layouts provided in Section III (Historical Table Structures) of this document In the case of customers that are migrating from Vision's DOS version of RMS, this mapping has already been done All that is required is the delivery of the DOS data files to VistonDTS VisionDTS will then take the historical data, inspect it for validity, organize the data, create the appropriate database within indexed, normalized data tables, and return the data, with appropriate utility programs, to the customer If, for whatever reason the events in the Summary tables are not properly related to the names in the Name tables, or if the customer is unable to create the appropriate data files to provide to Vision&R, VuionAIR, may, for appropriate fees, be able to assist the customer in creating these files If VisionAIR is unable to mine the data off the legacy system, it is still incumbent upon the customer to supply this data to VisionAIR VisionAIR will assume no liability when it comes to extracting, compiling and deteimmmg/mterpreting relationships between data and data elements of thud party systems • Data Values are placed in the Historical Tables as delivered by the customer with no further validation to the data by VisionAIR • Master Name data can be accessed and selectively imported by the user into RMS from within the MNHS program • The Master Name Historical Summary is a static, non-eduable database • None of the customer data is automatically uploaded into the live RMS database by VisionDTS Page 7 of 21 Last Revision 11/20/00 9 12 AM VISION EMS: MASTER NAME HISTORICAL SUMMARY (MNHS) METHODOLOGY VislonAIR, INC. II File Formats & Media VisionAIR is capable of accepting a wide range of media types Magnetic tape has proven to be an unreliable transport medium, and, thus, can no longer be accepted VisionAIR will only accept data on media that is based off hard -drive or resilient drive technologies Examples of such media include CD- ROMs, Zip drives, 1 44MB Floppy Drives, JAZ Drives, 250MB Super Disks, etc As to file formats themselves, VisionAIR will accept any delimited ASCII file, XBASE database file structure (Paradox, Access, DBF, Excel, etc ) as well as any file format which can be accessed readily from WmdowsNT using industry standard Open Database Connectivity (ODBC) drivers The preferred data format is a Tab delimited text file Obscure database file types (ALLBase, Image, etc) must have ODBC drivers sent with them or we will be unable to process the files in an appropriate manner It is the customer's responsibility to ensure that VisionAIR has the appropriate WmdowsNT (ODBC) drivers to read their data III Historical Table Structures Page a of 21 Last Revision 11/20/00 9 12 AM VISION RMSI MASTER NAME HISTORICAL SUMMARY (MNHS) METHODOLOOY VtstonAIR, INC. Page 3 of 21 Last Revislom 11/20/00 9 12 AM VISION RMSI MASTER NAME HISTORICAL SUMMARY (MNHS) METHODOLOGY VisionAIR, INC. Page 4 of 21 Last Revisions 11/20/00 9 12 AM VISION EMS. MASTER NAME HISTORICAL SUMMARY (MNHS) METHODOLOGY VisfonAIR, INC. Page g of 21 Last Revisions 11/20/00 9 12 AM VISION RMSS MASTER NAME HISTORICAL SUMMARY (MNHS) METHODOLOGY VisfonAIR, INC. Page g of 21 Lase Revisiom 11/20/00 9 12 AM VISION RMSI MASTER NAME HISTORICAL SUMMARY (MNHS) METHODOLOGY VfsionAIR, INC. Page 7 of 21 Last Revlalom 11/20/00 9 12 AM VISION RMSC MASTER NAME HISTORICAL SUMMARY (MNHS) METHODOLOGY VisionAIR, INC. Page S of 21 Last Revisions 11/20/00 9.12 AM VISION RMSI MASTER NAME HISTORICAL SUMMARY (MNHS) METHODOLOGY VisionAIR, INC. Page 9 of 21 Lest Revwslom 11/20/00 9 12 AM VISION RMS: MASTER NAME HISTORICAL SUMMARY (MNHS) METHODOLOGY nsionAIR, INC. Page 10 of 21 Las! Revisions 11/20/00 9 12 AM VISION RMS! MASTER NAME HISTORICAL SUMMARY (MNHS) METHODOLOGY VisionAIR, INC. Pape 11 of 21 Lost Revisions 11/20/00 9 12 AM VISION RMSI MASTER NAME HISTORICAL SUMMARY (MNHS) METHODOLOGY VlsionAIR, INC. Page 74 of 47 Last Revisions 11/20/00 9 12 AM VISION RMSI MASTER NAME HISTORICAL SUMMARY (MNHS) METHODOLOGY VlsionAIR, INC. Page 19 at 21 Lest Revlslone 11/20/00 9 12 AM VISION RMSI MASTER NAME HISTORICAL SUMMARY (MNHS) METHODOLOGY VislonAIR, INC. II File Formats & Media Vision&,R is capable of accepting a wide range of media types Magnetic tape has proven to be an unreliable transport medium, and, thus, can no longer be accepted VisionAIR will only accept data on media that is based off hard -drive or resilient drive technologies Examples of such media include CD- ROMs, Zip drives, 1 44MB Floppy Drives, JAZ Drives, 250MB Super Disks, etc As to file formats themselves, VisionAIR will accept any delmuted ASCII file, XBASE database file structure (Paradox, Access, DBF, Excel, etc ) as well as any file format which can be accessed readily from WlndowsNT using industry standard Open Database Connectivity (ODBC) drivers The preferred data format is a Tab delmuted text file Obscure database file types (ALLBase, Image, etc) must have ODBC drivers sent with them or we will be unable to process the files in an appropriate manner It is the customer's responsibility to ensure that VissonAIR has the appropriate WmdowsNT (ODBC) drivers to read their data III Historical Table Structures NAME TABLE NOW—Poftchar 6 Ii .ii 1 w ts Virg Now a 1 [cn„ Ses— am u: toChar 10 ft caw Char is Clair Primaryphimessarther Allas Mi: 30 i{ .EI{• A i B 8W C1 :. i AfteawXm C 01 Char, i On to Dift Of l Page 2 of 21 Last Revisions 11/20/00 9 12 AM VISION RMSI MASTER NAME HISTORICAL SUMMARY (MNHS) METHODOLOGY ViseonAIR, INC. 1 e a b. r Ow 40 ompation a: ea asChu 4 AptUmAtutulAier m 5 ea °fma a y z.E 1 la a 5� eala t :i eJ i'ia � 4tlP1r.E8�:u a'iry a i — I: d tl91e 4 a xJa il� m a;: •i,: B a ��x� v� o Is a v v: a>ia is: raa � a is a:a a ca_: s, a d f is kCi 5.p 1a Rv:>n v�i Page 9 of 21 Last Revisions 11/20/00 9 12 AM VISION RMSI MASTER NAME HISTORICAL SUMMARY (MNHS) METHODOLOGY VistonAlR, INC. SummaARREST_-------__--- a i veutClw 10 Dateu d-waort fbrSummary t1 Cbar 20 AnefiltmuiltedonNungm C---------------:1Fei—�7 430 - ------_-- - ------ 20 ltrllat�IS 3�tr - - --- ------ - -- - At'msUC4SaJ*lg Ow 10 Atmtdlspositiou am 26 F�- --- -- �C�C40]t- - ---- ---- ---- -7 Daft —AMU Clin 10 Data ofArmist IDam C naud - Data RAMW_ Cesar 19 D4100fulow _ LYas cwNei — ---- - Addus CW 60 Addtm*fAnvd 0"—usi— —Rimil Ca-1Ly c We --- -- -- - Cliargo Chw 40 Description of Chatift () )D Char 5 molld—nvills a: I 9 :: xLn Lyle !,'::2 Ygoarm BUsarDeflead d- +:e 1 Defte1 =+fib } I # ' e l " b ml Y .�}dlA.l.[1�.'� tlYiJi :. P .i 35 UntDofilled ..d, U;; J /ow ►/-bee. 55 Userte01e1 d 11 0": 1 1: 255 I d P B 1 d d i d b: 1 1 d "ablo in NO no Page 4 of 29 Lest Revisions 11/20/00 9 12 AM VISION RMSO MASTER NAME HISTORICAL SUMMARY (MNHS) METHODOLOGY VisionAIR, INC. Summary CUSTODY 5mal Lulls* am to is vadd to fast &W forsumawy O0r ArreWTUM960UNUIllb" Kgy-lD aw 20 RamusuminwRomiltoom)o Ou 10 Axmt ftodtlft w- case swo colk-Amilar Clair 10 cassuotaw 6iiiii1le" At Chw =46�] plimci- Ow 10 D060fAmd [4*1 LAOF] I—ijft Dot -Ram" ow 10 D4ftoflulftn Addrm Cho 60 AddisnofAnvat Irina pw =,clw F-2 --1 bfAj:s Clw 60 DescittlancifQW90 Ko- 0AW—W chr S onmumm�ff on= Nmu 9011ll, cha to swulelumowdleft, jDand Ammul !H4zf—b=wi�= C. 2 YsswWo Go, am 20 UsarDaifimd Um ftWMtjw��i Clw 20 TJSWDeftwd - -- - - ---= MOM �� [-35--- allor 35 Uw Defined lt7lmw 35 u 1caw 95 UsaDeAwd II ODMMM Cjw 25$ Addhkwj spot for data to be atorad If SON tam not wyWkblo in thi6 lbt Page 5 of 21 Lost Revision: 11/20/00 9 12 AM VISION RMSS MASTER NAME HISTORICAL SUMMARY (NINHS) METHODOLOGY VisionAIR, INC. -SummqD�_ClTAHQY---- aw 10 Dift=ed to sort is for Swm=jx cbv 2o TwaactionNumber It Chu 20 RalwWO1mWRIM001164mm yJF;F0104yermsdammmut DmijUse Char 2 YesorWo stmw On 30 QwWftUftC0d*NUmbct-------- her 80 DmM*ftn0tWhW* i6elffift I cbu to Mar to ax ctw 10 cmatcbst/vto aw $ offfmiDuumber D� Ow 20 UswDfifimd [C—buirl F Ljoilm—Ndind— user PWA,(Tjflg, UWD'Awd Ow 20 F6irIE-20 WiwiWd�� Cbw Uw Ddhwd —jjFSw— et 5-m-1 F —�5 lum FAAM MOW char 55 UWD&'Wd a-p—mm-AWdsis talou owed if &M mm Pogo 6 of 21 Last Rovision: 11/20/00 9 12 AM VISION RMS: MASTER NAME HISTORICAL SUMMARY (MNHS) METHODOLOGY VtsfonAIR, INC. - I -- - �- — — y Aatglaeed 1@ ------------ ---- [--- m5m1 F�� Itelat� �� Cbw sd Make, Model, VIK Color, etc. e' Is i'e S:Se c n>.a i,` ICY B t ' e • 8. [" r4 � b3tt"e cim eu.•i : ® e Y 4a m.n:. s e f&a. Y.v,i n. Page 7 of 21 Last Revision:11/20/00 9 12 AM VISION RMSO MASTER NAME HISTORICAL SUMMARY (MNHS) METHODOLOGY VtsionAIR, INC. M NEON Page a of 21 Last Revision, 11/20/00 9 12 AM VISION RMS" I MASTER NAME HISTORICAL SUMMARY (MNHS) METHODOLOGY VisionAIR, INC. Summaq JAJLL_-- AWARm— —A IWW LA-41101000--ftWO I)tu-*t-A"At OW 10 aw '20 aw 20 Alert Char 10 Alert Cm--T of i4ill Waiting aw to -AwauftTrail— Balm* Chur F-5 Babm Ow—d- Char 10 WAftmoy phone -mad Char 10 CallNed ckw to couNutobar r�ICdLNwdw Date-ChInflud Ow 10 DaUlDooft" =Iw EK]pi—w-�-M-K Datar ow to no Released *77 a k., 7� Page 9 of 21 Lost Revisions 11/20/00 9 12 AM VISION RMS: MASTER NAME HISTORICAL SUMMARY (MNHS) METHODOLOGY VisionAIR, INC. - - - --- - - - --- - - - - - 1 Gh"k —Ow 10 +k Pl�ra„ 1t1 PhgSg 0�+ar - — --- -- `� [Tc i _ --- — Phmj)Wtw ow 10 N - -- --- — - [-- - — ig ----[�-� 1Q - --- -- ctw 10 _ low 13 1ta1 1y 0 a Mf ��i• : 1� II: 1 ��. ae ® 3 eau 1 e y,. e ! ,1 r�1�}� "'�1111 " ei, 1 �a IG a tl:bi:x 1 am 33 Lhiadaftd 1j ? Chi 3$_ Uwddbed_ tlsor_1Id1O(11 SS Ulsadefitied_ Page 10 of 21 Last Revision: 11/20/00 9.12 AM VISION RMS: MASTER NAME HISTORICAL SUMMARY (MNHS) METHODOLOGY VislonAlR1 INC. Cbgr 10 Data z-tl ao* thildfw9unumtry .1A C:: 4 TawAdottl4witff— Fd 1 ! - —AfAN ' u r,.. Ajjfia ens XAVJIb CIW 20 :n e i u',o: Cbw 20 CmIOCANurabor - e tl W aim :1 cho 2o WamutNumber 'jJi ; :} aka x y,'a, i v jn. 1 1' 1: 1 Chu '; bc: nXll x •"ci': 1 a a , 1 :A_—_ itl R• b' 81-1 ,a 1 Page i1 of 21 Last Revisions 11/20/00 9 12 AM VISION RMSI MASTER NAME HISTORICAL SUMMARY (MNHS) METNODOLOOY KsloaAIR, INC. Sammaw INTERVIEW TABLE Nam _ _ — —b-1 -- — e# sf aSC10 WmiewDato — --- -- -- L�waBt--_�(_irl F 15 1 fin— -- -- r Number ------ — -- I+ �: B 1 a nay: iti I Chu 235 1`I e d( 61f1110a - 3Chw 3S idllt Deflued g3 �aaw 33 Uaer Defined —..—_J -- —_ - ----- -- -- ----- it 35 ddkl iil)a 35 Ueervenned -- ter 5 A6 t — ----- Page 12 of 21 Last Revisions 11/20/00 9 12 AM VISION RMSI MASTER NAME HISTORICAL SUMMARY (BANNS) METHODOLOGY VisroRAIR, INC. Summaryh- ,1 row b :. t. a 00 KWJD !: a t o l aaw to ,t:rr b ! Ns.: to bit a k • 4 All'arlb 05 cut 10 taa•c! B I 0 t b 1 @ tl, r1 ,.�... lan IY. d a 1 Page 19 of 21 Last Revision 11/20/00 9 12 AM VISION RMSI MASTER NAME HISTORICAL SUMMARY (MNHS) METHODOLOGY VisionAIR, INC. IV Fields & User Deflued Fields There are 'User Defined' fields trade available to you for each of the 'Historical Data' tables The user - defined fields are intended for you to supplement those data fields that Vision has identified from our customer's requirement analysis User defined fields may be divided (notationally) and viewed as separate logical fields while they are, in fact, just one field A copious amount of storage space has been allocated, per record, for user comments and for the concatenation of legacy data fields, for which, the user finds to be of value and feels should be retained In addition, other data may be titled and organized into narratives attached to main records V Master Name Historical Summary (MNHS) Validated data will reside in a database repository accessible by a VisionAIR Application called MNHS, which will provide the end user with the capability of browsing, searching, and printing their historical data This data will also be accessible from within VisionRMS automatically during Master Name searches and via a point and click user interface, but only in a limited manner, and mainly for name searching and basic informational display The capability of cutting and pasting name and address information from the Historical data into VisumRMS will exist One record per activity will be processed Because the MNHS repository is currently stored in a Microsoft Access 7 0 database, this repository can either reside on a mapped HDD of a network File Server, or on the local drive of a required NT 4 0 Workstation(s) Connectivity to the database will be achieved using standard off the shelf connectivity tools supplied with VisionRMS The MNHS application will also be accessible via a desktop icon for each user requiring access to historical data It will be the responsibility of the customer's system administrator to assign appropriate Microsoft NT file level security rights to the MNHS database and for correctly configuring client machines Primary and secondary points -of -contact, having extensive knowledge of the customer legacy system and data should be assigned by the customer to assist in the conversion of their data Installation and perceived value provided by the MNHS application will depend on the ability of each individual customer to provide clean, accurate data with detailed information about that data The customer can expect a mmmial amount of down time during the installation of the MNHS database Page 14 of 21 Last Reviaioni 11/20/00 9 12 AM Main Screen VISION RMS7 MASTER NAME HISTORICAL SUMMARY (MNHS) MSTHODOLOOY VistonAIR, INC. Pape 18 of 21 Lest Revislom 11/20/00 9 12 AM Main Screen, More VISION RMSI MASTER NAME HISTORICAL SUMMARY (MNHS) METNODOLOOY VistonAIR, INC. Pape 76 of 21 Las! Revlslone 11/20/00 9 12 AM VISION RMSI MASTER NAME HISTORICAL SUMMARY (MNHS) METHODOLOGY VistonAIR, INC. Specific Summary Screen (1 of nine different types) Activity Sununary Page 17 of 21 Lest Revision: 11/20/00 9.12 AM Report Selectors VISION EMS: MASTER NAME HISTORICAL SUMMARY (MNHS) METHODOLOGY VisionAIR, INC. Page 1g of 21 Last Revlelom 11/20/00 9 12 AM VISION RMSI MASTER NAME HISTORICAL SUMMARY (MNHS) METHODOLOGY VrsionAIR, INC. Part of Activity Report Screen 1 Actlaky Summary Report KENNETH LEE ADAMS KENNETH LEE ADAMS Key ID KEY0000003 SON 704-27 7061 Dab Extend IOWA 998 62 HINTON AVE WEST COLUMBIA, FL y Comdry Place of Birth, Resident Y as oh 1OW1990 Ban 03N2A660 Jw Photo 1 2 :olor BAN Guests HaaCobr OLK Lensin Style L 000 melght 160 BWId M Skin M Merral 8 dt NM RA. Handed U to Wages A0000003n.JPC,A0000003e JPO NM EDWARD WELLS m Code Dose FINANCIAL CONSULTANT eyer At WEST COLUMBIA Obb FL 21p 11060 Plane a Obb FL Exp D Nan Type ylgm REP CPF $13100 EvordDab 19OU1A9 Involvenert Type SUBJECT Ref NW 15444 Officer 1 1640 Pago 19 of 21 Lost RwIslonn 11/20/00 9 12 AM 10AAS 11.20 m AM Sex M Race W EtMMcky Key & KEY0000007 VISION RMS: MASTER NAME HISTORICAL SUMMARY (MNHS) Screen Page No 1 Records 20 VisionAlR, INC. Summary Report by AddressfLocatlon and Date Where Addre s/Locatlon contains Main 'for dates 1996 1999 Type Link Date Involvement Reference Hum Description KeyJD CECILIA LATHAM , #1021, W; F, 44 (0324M954k 16 WES BURKHEAD, VINTON, TX 77076 DMV 7 109BA2129 DMVOINNER 98TRAF A560 to ecc 60VTH MAIN AVE KEY0001021 FREDDIE SIMPSON , # 16481 W; M, 44 (0628M964), 69 CLINTON LANE, PASADENA, CA 11702 DMV 0 15980229 DMVDRIVER 98TRAF ASS) lu ace SOUTH MAIN AVE KET0001808 JAMES HEDGER,#802,W;Mi60(0124M)48h428 NORTHWOODST,HOUSVILLE,TX DMV 15 1988M228 DMV OTHER 98TRAFV1550 lu we SOUTH MAN AVE KEY0000802 FRANCES LUSK LLOYD , # 1094; Wi F, 60 (1221M94O)i , COPPER HILL, TX DMV 18 1990AZIA DMV PASS 90TRAF A548 2u acc EASTMAINSTREET KEYOOOIO64 MARY A GALV AN , # 627, Nf; F, 60 (06A1M9O)i 2670 BLUEBIRD LANE, AMHERST, TX DMV 17 IMA220 DMVDRIVER 98TRAF ASO 2uacc EASTMAINSTREET KEYOODO627 JOHN ALLEMANG, #1B, W; M, 60 (12AIOM948) 4600 BAINAIOGE CT, CLUTE, FL 11763 DMV 18 190BA2128 DMV OWNER NTRAFAS48 2unc EASTMAINSTREET KEYOOM010 STEVEN COLE , # 347; W; M, 60 (04M7M940); 2222 S CHURCH ST, FORT JACKSON, OK DMV 19 1S88M228 DMVDPIVER 96TRAF A548 2uacc EASTMAINSTREET KEYODW347 HENRY HENDERSON, # see, W1 At 50 (01M1M948); 350 W FRANCES LANE, DANBURY, IN DMV 20 1998M228 DMVOTHER 96TRAF A50 2aacc EASTMAINSTREET KEY00008DO WAYNE SULLIVAN; #1728, W, M, 60 (07MOM946), 2710 S 21 SST, PORT ISEBELL, W V 18718 DMV 21 199BA2128 DMV OWNER 98TRAF A548 2uacc EASTMAINSTREET KEY0001728 MARK BROWN,#aO,W;Ak43(06MBR866k6700 UtONW000DR,HOUSVILLE,MN11081 DMV 98 19S M2/09 DMVDRVER 98TRAF ASO lu son EASTMAIN STREET KEY0000202 MICHAEL MORALES, #1248, W; M, 43 (8123M966h 492 SCOTLAND ON FORT JACKSON, UT 11766 DMV 98 199DA2108 DMU OWNER SOTRAF ASO tome EASTMAIN STREET KEY0001248 (Same as grid view) Addre es,Localion on highwary or and SOUTH MAIN on highwary or shot SOUTH MAIN on Nghwvy a shed SOUTH MAIN on Nghwary or sled EAST MAIN; on Nghwary or shot EAST MAN; on highway or Arad EAST MAN' on hyhwery or sled EAST MAN' on Nommy or shed EAST MAN on highway or Ahd EAST MAIN on Nghwary or Ared EAST MAN on highway or deal EAST MAN £ 98TRAY-ASS0lu scc -SOUTH HAIN AVE en highwsry or serest SOU 90TMF-ASSO lu ecc -SOUTH VAIN AVH on highwery or street SW 98TRAF-ASSO lu scc -SOUTH VAIN AVE on highwary or street SOU 7 DRY 0 1998/12/29 1998/12/29 DHV OVNER DHV DRIVER DHV lb 1998/12/29 DVV OTa6A DXVJ 1611999112128 DHV PASS 98TAAH-AS48 2u sac - BAST MAIN STREET on highwary or street HA DHV 17 1998/12/28 DHV DAIVBR 99TRAP-AS48 2u ecc - EAST MAIN STAHBT on highwary or street E DHV 18 1998/12/20 DAD OVNHA 98TUY-A548 2u scc - EAST MAIN STAHBT on highwary or street HA , DMV 19 1998/12/28 DMV DRIVER 98TMY-AS48 2u ecc - EAST MAIN STABHi on highwary or street 8A DMV DMV DKV 20 21 66 1998/12/28 1990/12/28 1999/12/06 DRY OTHER DMV OVNER DHV DRIVER DMV OWNER i^ 9STMP-AS48 98TRAY-AS48 99TRAF-AS40 98TRAF-AS48 90TMY-A540 2u no. - EAST HAIN STREET 2u scc - EAST RAIN STREET lu scc -BAST MAIN STREET lu ecc -BAST MAIN STRBHT lu ace -EAST MAIN STREET on highwary or serest EA on hlghwary or street HA on highwery or street HAS on highwary or street SAO on highwary or street HAS DMV DMV 68 1998/12/06 69 1999/12/06 DRY OTHER Page 20 of 21 Last Revisions 11/20/00 9 12 AM VISION RMSI MASTER NAME HISTORICAL SUMMARY (MNHS) METHODOLOGY VisionAIR, INC. V1 Future Plans At some future time, the Master Name Historical Summary will optionally reside in a Microsoft SQL 7 0 database gaming the ability therem, to transfer user validated, reportable data into VisionRMS, on an as need basis At which time this enhancement becomes available, the MNHS database will remain static and unchanged even in the event that records are posted to the live VisionRMS system for reporting purposes Conclusion Most of VisionAff s new customers and existing customers require data conversion of some kind Each customer has data that it considers Important and considers accessing that historical data, once they have progressed to VisionRMS for Windows NT, as essential Customers, by storing their legacy data utilizing the VisionAIR Master Name Historical Summary (MNHS) Methodology, have a quick, low -risk, and simplified way of accessing their legacy data, and, by keeping this historical repository separate, will not impact the processing performance and scalability of VisionRMS Page 21 of 21 Last Revlalom 11/20/00 9 12 AM VisionDTS Attachment `G" GEO Conversions 1111812000 Introduction The VisionDTS Department (Data Transfer Services) offers GEO Conversions for those customers who wish to extract their GEO data into a pre -defined table format provided by VISIONAIR Each Customer must provide their data in the format provided and the data must be Ascu txt, comma delimited Access databases and Excel Spreadsheets are also acceptable A file layout must be provided at the time the data is delivered If the customer is unable to provide a file layout, they must manually type out definitions for each field entry All data to be converted will be provided to VISIONAIR in one flat file, VISIONAIR is not responsible for merging multiple files in order to generate one GEO table Acceptable media types include CD or Zip disks only Tape Backups have proven to be an unreliable media source and therefore will not be accepted Customers must provide their data to the DTS department at least two weeks prior to V isionCAD System Administrator Training "'Please note that the GEO layout Is street speck and does not Include business names Business names are considered a LANDMARK and are not Included as part of a CEO Conversion, however, may be purchased as an additional conversion The following page includes the VisionCAD GEO table layout CHAR 18 CITY CITY NAME CHAR 30 STREET STREET NAME NUMBER 4 FROM —NUM LOW RANGE OF STREET ADDRESSES NUMBER 4 TO NUM HIGH RANGE OF STREET ADDRESSES CHAR 15 WATER_CO NAME OF COUNTY WIDE WATER CO THAT SERVICES THIS AREA CHAR 15 GAS_CO NAME OF COUNTY WIDE GAS CO THAT SERVICES THIS AREA CHAR 15 ELECTRIC —CO NAME OF COUNTY WIDE ELECTRIC CO THAT SERVICES THIS AREA CHAR 15 PHONE_CO NAME OF COUNTY WIDE PHONE CO THAT SERVICES THIS AREA CHAR 2 QUADRANT PRE -DIRECTIONAL CHAR 15 EVAC_ROUTE EVACUATION ROUTE CODE CHAR 255 DIRECTIONS DIRECTIONS CHAR 50 SPECIAL_COMMENTS SPECIAL COMMENTS CHAR 30 REFERENCE —POINT DIRECTIONS FROM A GIVEN LOCATION CHAR 20 CROSS_STREETI FROM CROSS STREET (LOW) CHAR 20 CROSS STREET2 TO CROSS STREET (HIGH) CHAR 5 ESN EMERGENCY SERVICE NUMBER CHAR 7 STATE —ROAD ALTERNATE NAME OR NUMBER FOR ROAD CHAR 5 GRID LOCAL MAP COORDINATES CHAR 1 ODD —EVEN ODD (0), EVEN (E) OR BOTH (B) SIDES OF STREET - Defaults to B if none CHAR 5 DISP_ZONE DISPATCH ZONE CHAR 5 EITERNAL_ESN INTERNAL RESPONSE AREA (IRA) CHAR 54 NEIGHBORHOOD SUB -DIVISION OR HOUSING DEVELOPMENT Internal Ali Layout Column name Type Length Prec ----- Scale Nullable ----- ----------- -----------•------------------ Phone_Num ------------------------------ varchar ------ 12 yes Business_Name varchar 30 yes Class varchar 1 yes City varchar 18 yes Last Name varchar 15 yes First —Name varchar 15 yes Middle Name varchar 15 yes Location varchar 60 yes State varchar 2 yes ZIP varchar 5 yes Mail varchar 18 yes —City Mail Location varchar 60 yes Mail —State varchar 2 yes Mail ZIP varchar 5 yes Reference —Point varchar 30 yes Special varchar 50 yes Directions varchar 255 yes Water_Co varchar 15 yes Gas varchar 15 yes —Co Electric_Co varchar 15 yes Electnc_Meter_Num varchar 12 yes Tract varchar 4 yes Tax varchar 30 yes —ID Num Occupants int 4 10 0 yes Disp_Zone varchar 5 yes Internal ESN (IRA) varchar 5 yes Junsdiction varchar 10 yes Alarm Co varchar 50 yes Alarm Co_Phone varchar 12 yes Alarm_Code varchar 12 yes Alarm varchar 20 yes —Type Apartment varchar 8 yes Floor varchar 5 yes Run —Zone —EMS varchar 10 yes Run —Zone —Fire varchar 10 yes ATTACHMENT "H" CITY OF DENTON INSURANCE REQUIREMENTS STANDARD PROVISIONS: Without limiting any of the other obligations or liabilities of the Owner, the Owner shall provide and maintain until the contracted work has been completed and accepted by the City of Denton, Owner, the minimum insurance coverage as indicated hereinafter As soon as practicable after notification of bid award, Owner shall file with the Purchasing Department satisfactory certificates of insurance, containing the bid number and title of the project Owner may, upon written request to the Purchasing Department, ask for clarification of any insurance requirements at any time, however, Owners are strongly advised to make such requests prior to bid opening, since the insurance requirements may not be modified or waived after bid opening unless a written exception has been submitted with the bid Owner shall not commence any work or deliver any material until he or she receives notocation that the contract has been accepted, approved, and signed by the City of Denton. All insurance policies proposed or obtained in satisfaction of these requirements shall comply with the following general specifications, and shall be maintained in compliance with these general specifications throughout the duration of the Contract, or longer, if so noted Each policy shall be issued by a company authorized to do business in the State of Texas with an A M Best Company rating of at least A Any deductibles or self -insured retentions shall be declared in the bid proposal If requested by the City, the insurer shall reduce or eliminate such deductibles or self -insured retentions with respect to the City, its officials, agents, employees and volunteers, or, the Owner shall procure a bond guaranteeing payment of losses and related investigations, claim administration and defense expenses Liability policies shall be endorsed to provide the following of Name as additional insured the City of Denton, its Officials, Agents, Employees and volunteers •• That such insurance is primary to any other insurance available to the additional insured with respect to claims covered under the policy and that this insurance applies separately to each insured against whom claim is made or suit is brought The inclusion of more than one insured shall not operate to increase the insurer's limit of liability • All policies shall be endorsed to read• "SAID POLICY SHALL NOT BE CANCELLED, NONRENEWED OR MATERIALLY CHANGE WITHOUT 30 DAYS ADVANCED WRITTEN NOTICE BEING GIVEN TO THE OWNER (CITY) EXCEPT WHEN THE POLICY IS BEING CANCELLED FOR NONPAYMENT OF PREMIUM IN WHICH CASE 10 DAYS ADVANCE WRITTEN NOTICE IS REQUIRED": • Should any of the required insurance be provided under a claims -made form, Owner shall maintain such coverage continuously throughout the tern of this contract and, without lapse, for a period of three years beyond the contract expiration, such that occurrences ansing during the contract term which give rise to claims made after expiration of the contract shall be covered • Should any of the required insurance be provided under a form of coverage that includes a general annual aggregate limit providing for claims investigation or legal defense costs to be included in the general annual aggregate limit, the Owner shall either double the occurrence limits or obtain Owners Protective Liability Insurance • Should any required insurance lapse during the contract term, requests for payments originating after such lapse shall not be processed until the City receives satisfactory evidence of reinstated coverage as required by this contract, effective as of the lapse date If insurance is not reinstated, City may, at its sole option, terminate this agreement effective on the date of the lapse All insurance policies proposed or obtained in satisfaction of this Contract shall additionally comply with the following marked specifications, and shall be maintained in compliance with these additional specifications throughout the duration of the Contract, or longer, tf so noted A General Liability Insurance• General Liability insurance with combined single limits of not less than $1,000,000 shall be provided and maintained by the Owner The policy shall be written on an occurrence basis either in a single policy or in a combination of underlying and umbrella or excess policies If the Commercial General Liability form (ISO Form CG 0001 current edition) is used • Coverage A shall include premises, operations, products, and completed operations, independent Owners, contractual liability covering this contract and broad form property damage coverage Coverage B shall include personal injury Coverage C, medical payments, is not required If the Comprehensive General Liability form (ISO Form GL 0002 Current Edition and ISO Form GL 0404) is used, it shall include at least Bodily injury and Property Damage Liability for premises, operations, products and completed operations, independent Owners and property damage resulting from explosion, collapse or underground (XCLI) exposures Broad form contractual liability (preferably by endorsement) covering this contract, personal injury liability and broad form property damage liability Automobile Liability Insurance• Owner shall provide Commercial Automobile Liability insurance with Combined Single Limits (CSL) of not less than $1,000,000 either in a single policy or in a combination of basic and umbrella or excess policies The policy will include bodily injury and property damage liability arising out of the operation, maintenance and use of all automobiles and mobile equipment used in conjunction with this contract Satisfaction of the above requirement shall be in the form of a policy endorsement for any auto, or all owned, hired and non -owned autos Workers Compensation Insurance Owner shall purchase and maintain Worker's Compensation insurance which, in addition to meeting the mimmum statutory requirements for issuance of such insurance, has Employer's Liability limits of at least $100,000 for each accident, $100,000 per each employee, and a $500,000 policy limit for occupational disease The City need not be named as an "Additional Insured" but the insurer shall agree to waive all rights of subrogation against the City, its officials, agents, employees and volunteers for any work performed for the City by the Named Insured For building or construction projects, the Owner shall comply with the provisions of Attachment 1 in accordance with §406 096 of the Texas Labor Code and rule 28TAC 110 110 of the Texas Worker's Compensation Commission (TWCC) Professional Liability Insurance Professional liability insurance with limits not less than $1,000,000 per claim with respect to negligent acts, errors or omissions in connection with professional services is required under this Agreement ATTACHMENT 1 [ ] Worker's Compensation Coverage for Building or Construction Projects for Governmental Entities A Definitions Certificate of coverage ("certificate") -A copy of a certificate of insurance, a certificate of authority to self -insure issued by the commission, or a coverage agreement (TWCC-81, TWCC-82, TWCC-83, or TWCC-84), showing statutory workers' compensation insurance coverage for the person's or entity's employees providing services on a project, for the duration of the project Duration of the project - includes the time from the beginning of the work on the project until the contractor's/person's work on the project has been completed and accepted by the governmental entity Persons providing services on the project ("subcontractor" in §406 096) - includes all persons or entities performing all or part of the services the contractor has undertaken to perform on the project, regardless of whether that person contracted directly with the contractor and regardless of whether that person has employees This includes, without limitation, independent contractors, subcontractors, leasing compames, motor carvers, owner - operators, employees of any such entity, or employees of any entity which furnishes persons to provide services on the project "Services" include, without limitation, providing, hauling, or delivering equipment or materials, or providing labor, transportation, or other service related to a project "Services" does not include activities unrelated to the project, such as food/beverage vendors, office supply deliveries, and delivery of portable toilets B The contractor shall provide coverage, based on proper reporting of classification codes and payroll amounts and filing of any overage agreements, which meets the statutory requirements of Texas Labor Code, Section 401 011(44) for all employees of the Contractor providing services on the project, for the duration of the project C The Contractor must provide a certificate of coverage to the governmental entity prior to being awarded the contract D If the coverage period shown on the contractor's current certificate of coverage ends during the duration of the project, the contractor must, prior to the end of the coverage period, file a new certificate of coverage with the governmental entity showing that coverage has been extended E The contractor shall obtain from each person providing services on a project, and provide to the governmental entity (1) a certificate of coverage, prior to that person beginning work on the project, so the governmental entity will have on file certificates of coverage showing coverage for all persons providing services on the project, and (2) no later than seven days after receipt by the contractor, a new certificate of coverage showing extension of coverage, if the coverage period shown on the current certificate of coverage ends during the duration of the project F The contractor shall retain all required certificates of coverage for the duration of the project and for one year thereafter G The contractor shall notify the governmental entity in writing by certified mail or personal delivery, within 10 days after the contractor knew or should have known, of any change that materially affects the provision of coverage of any person providing services on the project H The contractor shall post on each project site a notice, in the text, form and manner prescribed by the Texas Workers' Compensation Commission, informing all persons providing services on the project that they are required to be covered, and statmg how a person may verify coverage and report lack of coverage The contractor shall contractually require each person with whom it contracts to provide services on a project, to (1) provide coverage, based on proper reporting of classification codes and payroll amounts and filing of any coverage agreements, which meets the statutory requirements of Texas Labor Code, Section 401 011(44) for all of its employees providing services on the project, for the duration of the project, (2) provide to the contractor, prior to that person beginning work on the project, a certificate of coverage showing that coverage is being provided for all employees of the person providing services on the project, for the duration of the project, (3) provide the contractor, prior to the end of the coverage period, a new certificate of coverage showing extension of coverage, if the coverage period shown on the current certificate of coverage ends during the duration of the project, (4) obtain from each other person with whom it contracts, and provide to the contractor (a) a certificate of coverage, prior to the other person beginning work on the project, and (b) a new certificate of coverage showing extension of coverage, prior to the end of the coverage period, if the coverage period shown on the current certificate of coverage ends during the duration of the project, (5) retain all required certificates of coverage on file for the duration of the project and for one year thereafter, (6) notify the governmental entity in writing by certified mail or personal delivery, within 10 days after the person knew or should have known, of any change that materially affects the provision of coverage of any person providing services on the project, and (7) contractually require each person with whom it contracts, to perform as required by paragraphs (1) - (7), with the certificates of coverage to be provided to the person for whom they are providing services J By signing this contract or providing or causing to be provided a certificate of coverage, the contractor is representing to the governmental entity that all employees of the contractor who will provide services on the project will be covered by workers' compensation coverage for the duration of the project, that the coverage will be based on proper reporting of classification codes and payroll amounts, and that all coverage agreements will be filed with the appropriate insurance carver or, in the case of a self -insured, with the commission's Division of Self -Insurance Regulation Providing false or misleading information may subject the contractor to administrative penalties, criminal penalties, civil penalties, or other civil actions K The contractor's failure to comply with any of these provisions is a breach of contract by the contractor which entitles the governmental entity to declare the contract void if the contractor does not remedy the breach within ten days after receipt of notice of breach from the governmental entity ATTACHMENT 1% FUNCTIONAL REQUIREMENTS Public Safety Software System All requirements contained within this document shall refer to the public safety system operated by the City of Denton Fire and Police Departments The attached lists of system functions shall perform properly, and reliably, as installed on the public safety computer system operated by the City of Denton Fire and Police Departments Integration of individual elements shall be paramount All interfaces shall be seamless, to the highest extent possible System Security- 1 Shall limit access into all modules, as defined by user and password In addition, the on -site system administrator shall be able to designate, by user names and password, the user's ability to access records by jurisdiction, module and module table 2 Shall limit access, to juvenile records, as defined by user and password 3 Shall allow designated administrators in various departments to determine access and security for their user group, within their specific modules 4 Shall provide audit trails for changes to any and all fields, in all applications that tracks all additions, modifications and deletions per module table and field This information is date and time -stamped by module user Interfaces - Shall interface with the following 1 E911/Automated number identifier (ANI)/Automated letter identifier (ALI) Shall transfer all E911 information into CAD This interface includes the ability to view raw ANI/ALI data on the CAD screen prior to import to CAD, or auto import feature In addition CAD shall be able to store the last 50 or less (user defined number) ANI/ALI feeds at the local workstation 2 Encoding system/two-tone sequential paging (ZETRON) 1 3 Mapping {City of Denton/ESRI Graphic Information System (GIS) and CML) utilizing Mapobjects, a standard ESRI file format, to geographically display data utilizing Visionair's Maplink product 4 Transfer all current call for service information into VisionCAD, VisionMobile, and GEO, utilizing a tightly integrated data transfer schema which allows for call information to be freely transferred between from the telecommunicator's screen directly to the officers mobile unit Call location and other pertinent information shall be transferred seamlessly to an ESRI-based map for review by the telecommunicator Fire Mobile allows the officer to view water source data Mobile allows the officer to view AVL data 5 Alphanumeric paging, to transmit incident information via Airtouch/Venzon wireless paging service, using WINBEEP to transfer incident data to pagers In addition VisionMOBILE message switch shall be upgradeable to use interactive pagers from BellSouth to perform TLETS queries and dispatch functions Compliance is dependent on Airtouch/Venzon being supported by WINBEEP 6 Emergency Medical Priority Consultants' emergency medical dispatch ProQA for Windows software Shall transfer all gathered information from ProQA into CAD and map appropriately so as to facilitate access to all data, utilizing an interface to Medical Priority Consultants PRO Q/A product for Windows The interface shall allow the dispatcher to start a new Case from CAD with the EMD button on the home screen The data from the Case shall then be loaded into the call narrative in CAD to make it a permanent part of the Historical CAD call in addition, responses to PRO Q/A prompts shall be automatically transferred to the telecommunicator's narrative screen and made available to VisionMOBILE users assigned to the call in the field 7 Texas Law Enforcement Telecommunication System (TLETS), Texas Crime Information Center (TCIC), National Crime Information Center (NCIC), Dallas/Tarrant County Regional Database Shall transfer the following queries from CAD and Mobile direct from our Message Switch VEHICLE (License Plate or VIN), PERSON (Name, DOB and SEX or Driver's License Number), ARTICLES (Property), and GUN, into VisionCAD, and VisionMobile and map appropriately so as to facilitate access to all data In addition we telescope query to the Dallas Regional Database through TLETS For full TLETS/NCIC access and entry SNA server can be used on the Message Switch and CAD/RMS clients 8 1 Automated Fingerprint Identification System (AFIS), AFIS compatible fingerprinting workstations Transfer all gathered information from 2 workstations into JAIL and map appropriately so as to facilitate access to all data 9 Bar coding specific to Police/Jail/Property and Fire/EMS and mapped appropriately so as to facilitate access to all data 10 SweetSoft billing Transfer all demographic information from VisionEMS, and VisionCAD into SweetSoft and map appropriately so as to facilitate access to all data 11 Automatic Vehicle Locator (AVL)/Global Positioning System (GPS) Transfer all information gathered from AVL/GPS equipment, mounted in all mobile units, to a message switch, and into VisionCAD 12 Mobile data computers, with VisionSuite (all components), AVL/GPS Most information gathered through CAD shall be available to all Mobile users 13 Mobile field reporting, with VisionCAD, and VisionRMS All field reports shall be uploaded to the Message Switch wirelessly and then uploaded into RMS, or this can be accomplished by floppy disk (if desired) 14 Digital photo imaging, with Vision approved hardware Make all available imaging information retrievable through VisionRMS, and VisionFire This cannot be answered without knowing what kind of hardware is being used Snappy is required for this interface to work correctly 15 Automated citation devices, with VisionRMS, through a message switch, into CSI (existing court records), specifically, the ability to transfer citation information to the message switch from the field In turn, this file would be made available for access by the CSI application 16 Municipal court software, CSI- Court Specialists Software Inc with VisionMobile, through a message switch, into VisionRMS, current hardware/card reader, and Comtec Encore 3 printer Shall make all available information gathered through hardware/card reader retrievable by all users, provided Vision can obtain cooperation from CSI 17 VisionJail/Book-In, with Victim Information Notification Everyday (VINE) system VisionJail/Book-in shall provide an open API (Application Programming Interface) allowing VINE System to retrieve available Jail/Bookin information 18 Vision will provide City of Denton with a file definition of all necessary tables whereby Corona Solutions can access data from Vision application Shall make all available information retrievable by CADMine Computer Aided Dispatch 1 Shall provide immediate access to the mapping interface, through Integration with CAD Mapping or Vision GEO, Visionair's mapping programs, which allows calls and unit locations to be displayed on a map 2 Shall automatically accept ANI/ALI data from E911 3 Shall interface directly with VisionRMS, and eliminate duplicate entry of incident information in VisionFire, and VisionRMS 4 Shall select which fire station to send an alert and printouts for dispatching through an interface to the Zetron system to alert fire stations of dispatching 5 Shall link separate but related incidents on both open and closed calls The contents of the linked call shall be transferred to VisionRMS when the closed call data is pasted manually into the narrative of the closed call The linkage of the calls will only be available in the narrative in RMS 6 Shall dispatch before call information is completed 7 Shall detect and notify console operator of duplicate calls 8 Shall provide for dispatchers to override unit recommendations 9 Shall provide for dispatchers to add units to a call 10 Shall reassign a unit to a second call, and then go back to the previous call without limitation on the number of calls queued 11 Shall allow the user to set 'pre -planned' calls The user may define at which date/time he/she will be prompted to dispatch a unit for the planned call 12 Shall generate offense numbers automatically, or manually by the dispatcher 13 Shall generate a separate series of sequential offense/report numbers for both fire and police 14 Shall mark all notes related to an incident with user identification, date, and time 4 15,Shall transfer a call to another dispatcher with only partial information, before or after actual dispatch 16.Shall allow a CAD workstation to act as a call taker, dispatcher, or both, dependent upon the user login The only difference between the two would be the size and positions of windows 17 Shall allow the input of notes/information into another dispatcher's call, as the call is being dispatched 18 Shall allow the Supervisor to configure his/her workstation to show all calls in queue, regardless of type or assignment 19 Shall allow the selection of calls at will, from the calls holding for dispatch 20 Shall allow placing a call on hold to take a higher priority call 21 Shall notify dispatchers of hazards, prior calls, medical history, caution notes, warrants, by location If VisionCAD and VisionRMS are being used together, dispatchers will be warned of outstanding warrants for the complaint address The dispatchers shall be able to view the full warrant record Dispatchers shall be alerted to fire plans associated with an address entered for a call The historical calls database shall alert dispatchers to previous calls at complaint locations When calls are received, dispatchers shall be alerted to medical conditions, hazardous materials, and other conditions that exist at the caller location This information shall be stored in the internal ALI database 22 Shall allow the scheduling of calls into the future, and to modify and dispatch scheduled calls, at any time 23 Shall allow the change of display sort order, priority, units, status, etc 24 Shall standardize and customize display colors, window arrangements, including the capability to change the display colors, order of units, order of windows, etc This configuration shall be saved to the user's profile for future system use 25 Shall allow color -coding of dispatch screen display 26 Shall provide call templates based on whether the call is New, Miscellaneous, or Traffic Stop 27 Shall filter displayed calls by Fire/EMS/Police User can sort by priority Calls cannot be filtered by Unit Types. 28,Shall recommend units 29 Shall allow the display of available and assigned units 30,Shall allow the user to customize the colors for units displayed, and differentiate (by color, graphics, etc ) between types of units on display 31 Shall recall prior traffic stop information from TLETS, regional information, CAD, and RMS, utilizing the State's windows -compatible software 32 Shall recall prior traffic stop information by any or all of the following indicators license plate number, driver's license number, or name 33 Shall provide prior information on stops/incidents, including offenses, and calls for service 34 Shall track alarms (fire, burglar, panic, medical) and track false alarms 35 Shall allow the use of the same report number for both Fire and EMS The user can accomplish this by choosing to use the CAD Call Number as the report number 38 Shall change call type/location/etc , while maintaining a record of the original information in a searchable field 37 Shall generate an activity log by unit/officer/apparatus, which includes all other units, or apparatus that assisted Log shall include status and times 38 Shall track times, including call received, shipped, dispatched, enroute, on scene, open report, transported, at hospital, and available for all units/apparatus participating 39 Shall allow non -dispatch personnel to view, but not change, CAD Fire/Police status, incidents, details, without being able to change (for non - dispatch personnel), in real time, with automatic refresh 40 Shall validate data as it is being entered, and immediately suggest valid values when invalid data is entered 41 Shall override unverified addresses 42 Shall execute virtually all dispatch functions from the command line Shall provide on-line help for commands 43 Shall provide "be on the look out" (BOLO) alerts from CAD to Mobile Mobile users may utilize the narrative to send this information to CAD ON 44 Shall recommend both primary and backup units, based on call type, location, shifts, and standard operating procedures 45,Shall assign multiple aliases to an address, and convert to standardized address 46. Shall allow lists of locations for house watch and close patrol, by beat and district CAD provides data fields which maybe used for tracking beat and district The system provides a report generator which will allow a list to be generated 47 Shall respond to fire unit district changes 48 Shall create run cards for Fire and EMS 49 Shall activate alphanumeric paging by call type, or nature, for both Fire and Police, with an alphanumeric paging interface (WinBeep) and proper building of the table 50 Shall maintain emergency contact information, and make available to mobile users 51 Shall maintain a wrecker log to include normal rotation in the order from the company that has not been called in the longest time to the company that was called most recently CAD shall track wrecker responses 52 Shall allow capture of data regarding race or ethnicity of driver on traffic/field stops regardless of whether a citation or other action is taken at such time as, and in the form, same is indicated by the State of Texas as a reporting requirement Mapping 1 Shall pinpoint incident locations for CAD 2 Shall retrieve CAD incident data for an area within the radius of an incident 3 Shall define and locate cross -streets 4 Shall dispatch Police, Fire and EMS units/apparatus from map displayed in VisionCAD The dispatcher will be able to move an icon representative 7 of units/apparatus displayed on a map and dispatch the closet unit by dragging the icon onto the call screen 5 Shall mark fire hydrants, landmarks, etc on map Police Records Mananement System 1 Shall generate NIBRS reports to comply with the State of Texas reporting requirements and UCR reports, including Return A, Supplement to Return A and Property Stolen by Classification 2 Shall define offenses by CJIS(Texas penal) code and use CJIS code for data entry and allow system administrators the ability to work with, and define UCR and IBR system tables and codes through the system administration module code The system provides all state mandated codes, and these may not be edited by the user, to print state reporting errors 3 Shall distinguish a juvenile from an adult under both Texas and Federal Law and create a juvenile detention log that is required by the State Shall track and report juveniles separate from adults 4 Shall change arrest titles and offense titles to conform to statute changes without changing past arrest and offense records 5 Shall create track field interview information, and shall allow the user to create contact cards using the report generator 6 Shall be capable of displaying/listing all reports waiting for UCR coding Within VisionRMS, you can build an adhoc to display all cases that don't have UCR Codes in the offense and VisionAIR validation will display all validation errors for cases awaiting successful UCR coding 7 Shall create user -defined fields 8 Shall place embedded or linked objects (pictures, recordings, etc ) into case folders or attach to person or property record An object is considered any external digital file such as a photograph, video clip, sound clip, document, drawing, diagram, or spreadsheet 9 Shall display objects (mug shots, text documents, property pictures, etc ) on the screen 10,Shall secure permissions to files and folders based on an individual's user name and password 11, Shall retrieve/report calls for service (incidents) in Records even if no offense report is written 12 Shall provide an audit trail for record modification, which includes user, date, time and field An audit trail is a detailed record of all changes that have been made to a record The audit trail includes the date and time of the change, who made the change, and the "before" and "after" values of the changed field 13 Shall enter Modus Operandis (MO) information and search by MO 14 Shall generate an on -screen suspect lineup based on suspect physical characteristics entered by the end user The user will then print the on- screen lineup to a localized or networked printer 15 Shall track accident information and generate Texas DPS ST-3 report and supplements 16 Shall verify name entry against Master Name file to allow the user to avoid duplication 17 Shall provide a graphic body map to show scars, marks and tattoos, and piercing Shall attach photos of same to the incident/offense report 18 Shall provide separation of CID intelligence data in a separate database for specific groups of people within the organization 19 Shall provide reference files for employee information, SOP, etc , with search capabilities 20 Shall hide investigative notes when specified by an investigator The RMS user shall have the ability, with the associated rights, to designate a folder as 'confidential' Utilization of this option shall make the contents of the folder inaccessible by users other than the creator The folder creator shall have the option to designate other confidential folder readers as he/she deems necessary 21 Shall track asset seizures to final disposition 22 Shall search for incident/report by any field/multiple fields including date range, name, location, vehicle and officer, etc Jail/Book-In 1 Shall record inmate inventory and generate receipt for property 2 Shall maintain inmate medical and pharmacy records 3 Shall track bonds, releases and arraignments for each charge on each inmate 4 Shall report lad population and demographics by day or month, and to report duration of inmate stay for a specified period of time 5 Shall report previous arrests to book -in and previous classification status 6 Shall attach photos to inmate records and display on screen 7 Shall track potential hazards of concern for each inmate I e sex offenders, communicable disease(s), suicidal, escape risk, etc 8 Shall interface with V I N E (reference attachment I Interfaces- number 17) Alarm Permits 1 Shall track false alarms through use of complaint types and/or dispositions 2 Shall calculate excessive alarms for the purpose of billing with user definable period of time Report will require a redesign to allow the user to specify what number of alarms is considered "Excessive" 3 Shall allow user to create a complaint type to indicate locations without alarm permits where a response unit is dispatched The VisionCAD user may then create a report to display all locations, without permit, where an officer responded TCIC(NCIC TLETSINLETS 1 Shall be able to accept queries from desktop 10 2 Shall modify queries to conform to changes as the State of Texas phases in NCIC 2000 with NETCOM server 3 Shall be able to inquire, modify, locate, enter, cancel, and clear, from each dispatch CAD workstation, however VisionCAD provides the functionality to only query the desired information from NCIC 4 Shall inquire TCIC/NCIC/Regional database via Mobile Property/Evidence Shall barcode property by generating a barcode label based on end user's input The label will then be used in tracking bar-coded property 2 Shall track found property, recovered stolen property and evidentiary property from acquisition to disposal including location/possession to document the chain of custody The process will involve manual data entry as well as barcode scanning 3 Shall enable users to produce notification letters to owners of property available for release 4 Shall provide alerts at user -defined times when property and vehicles are eligible for disposal 5 Shall track impounded vehicles from impoundment to auction based on end user input Will generate a report of impounded vehicles and their dispositions 6 Shall attach digital pictures of found property, recovered stolen property and evidentiary property to the property's file in the evidence module Supervisor Approval 1 Shall allow user to display those reports to the officers that do not meet supervisor approval for both Police and Fire Personnel Scheduling/Tramina 11 1 Shall provide scheduling of training for Police/Fire/EMS based on user input Mobile 1 Shall update code tables from the server via wireless connection when Mobile version 3 0 is released System Administrator must be able to set the updates to run automatically or manually It is agree that payment for mobile product will not be held up waiting for deliver and installation of Mobile version 3 0 2 Shall assign keys based on most commonly used commands when Mobile version 3 0 is released 3 Shall be capable of changing fire districts and status from mobile terminal Interfacing with VisionFIRE will require an additional cost 4 Shall be able to select from a list of waiting calls where users can add themselves to that call 5 Police/Fire/EMS shall be able to add themselves to a call 6 Police/Fire/EMS shall be able to self -initiate their calls from Mobile Interfacing with NCIC and RMS queries are provided at an additional cost 7 Police/Fire/EMS will shall have "Messaging Capabilities " Messaging will be defined as car -to -car chat, car to dispatch chat, car -to -car e-mail and car to dispatch email 8 Display Police/Fire/EMS units in Mobile software on an in -car -map computer display, dependent on the user having AVL GPS All software is included in this contract 9 Allow for a minimum of 7 Imes of text, including unit status and pending calls to allow officers to see as much of the activity as possible without having to scroll up and down 10 AVL screens shall refresh either manually or within user -defined periods Status screens must be refreshed manually 11 Shall allow user to paste contact information and transmit to CAD system 12 12 Shall store information on laptop in case of transmission failure or message switch down time and be transmitted automatically when system is restored 13 Shall allow Fire mobile users to update budding details via LAN or Wireless communication in Mobile FIRE 14 Shall provide audible and visual alerts of location hazards, warrants, dispatches, TLETS returns, BOLOS, medical information, etc 15 Shall provide touch screen compliance 16 Shall produce accident reports and allow user to attach sketches of the accident by floppy disk from a desktop workstation utilizing third party software provided by customer Shall generate the Texas ST-3 report plus its supplements 17 Shall store all car -to -car and car -to -dispatch messages on the message switch 18 Shall display all units' status, as well as all CAD calls in queue, seven Imes at a time or more 19 Shall allow mobile uses to obtain transmittals of TLETS and other central agency database queries when drivers' license number, name or tag is entered 20 Shall provide the capability to set up messaging groups 21 Shall interface to magnetic strip or bar code reader for drivers' licenses when Mobile version 3 0 is released 22 Shall retrieve a list of locations for House Watches and Close Patrols by district in CAD 23 Capable of providing Police field reporting of Incidents, Offenses and Accidents 24 Shall provide for NFIRS-1 Basic Form reporting of Fire Incidents 25 Provide screen night vision dimming and black out modes 26 Shall enable entry and capture of data regarding race or ethnicity of driver on traffic/field stops regardless of whether a citation or other action is taken 13 Fire Records 1 Must be NFIRS 5 0 certified 2 Shall create and electronically transmit NFIRS reports 3 Shall flag any report which does not have all NFIRS required information 4 Shall provide NFIRS report sections becoming available based on information entered in previous fields 5 Shall provide incident data obtained from the CAD System 6 Shall validate addresses against CAD utilizing GEO Converter 7 Shall provide for fire inspection module to have separate security from fire reporting 8 Shall calculate run times, on scene times, etc , for each apparatus 9 Shall enable generation of activity reports by station, apparatus, shift and individual 10 Shall track mutual aide -total calls given and received 11 Shall track inventory of equipment and apparatus (SCBA, hoses, pumps, etc ) 12 Shall allow users to define and create testing schedules based on equipment maintenance recommendations and maintaining testing records for equipment and apparatus The Equipment section of the Fire Module shall also give customer ability to test equipment, and record repair and parts information Test records are always accessible by pressing the test button Test records must be completed before repair and parts records can be entered For all equipment tests (Ladder, SCBA, etc) the 'Tested By' field shall allow the user to either select values from the pull -down menu, or to enter free text of users choosing The Equipment Maintenance system of VisionRMS shall allow customer to define, schedule, and track equipment maintenance records The Equipment Maintenance system shall also allow customer to record equipment usage, maintenance costs, equipment fueling, physical inspections and performed maintenance Customer shall also be able to view projected maintenance schedules, print maintenance tickets, and enter purchase orders 14 13 Shall allow users to generate training schedules based on position requirements 14 Shall allow users to track certification expiration dates, and shall allow a report to be run which will list those certifications in need of renewal 15 Shall allow users to query and generate reports of training history for each individual and calculate training hours by date parameters 16 Shall track fire hydrant locations and maintain logs for painting, flow testing, and other maintenance activities 17 Shall track hazardous materials, sprinklers, premise information, etc by location and relay to CAD and mobile FIRE applications Fire Inspections 1 Shall generate inspection schedules daily, weekly, and/or monthly 2 Shall track violations and generate printed notifications 3 Shall provide fire inspection information to CAD and mobile FIRE Reportinsa (Pertaining to all modules) 1 Shall allow users to define and generate reports based on multiple incidents criteria (i a highest burglary occurrence), personnel and equipment activities, mutual aid, response times, etc 2 Shall allow users to store and recall created reports 3 Shall allow creation of redacted reports to be released to the public for both individual offenses and for cumulative press releases if customer utilizes paperless reporting 15 ATTACHMENT "J" Licensed Software Acceptance Plan STANDARDS OF PERFORMANCE AND ACCEPTANCE CRITERIA The installation and acceptance of the Licensed Software will be as described in Subparagraphs (a) through (e) of this section, which pertains to the installation of the Licensed Software a Application Software Certification- OWNER shall certify in writing to CUSTOMER when the application software is installed and ready to use per the Software License Agreement The Licensed Software will be considered installed and ready to use when OWNER demonstrates that the application software is operational on CUSTOMER'S computer hardware (the "Installation Date") b Performance Criteria and Period: The "Performance Period" shall constitute a period of fifteen (15) calendar days The Performance Period shall commence on the first workday after the Installation Date at which time the CUSTOMER first uses the Licensed Software operationally (the "First Use Date") If the Licensed Software is available for use ninety nine (99) percent or more of the time during the Performance Period, and the Licensed Software provides the features and functionality as described in Functional Requirements (Attachment I), then the Licensed Software shall be deemed to have met the Performance Criteria, and payment will be due in accordance with the Schedule of Payments (Attachment A) The average up -time effectiveness level is a percentage figure determined for a relevant period of time by dividing the time the system is operational and operating in accord with the Documentation by the total time elapsed during the relevant period under consideration and multiplying by 100 c Notice of Acceptance. If the CUSTOMER fails to give notice of acceptance or non -acceptance to OWNER within ten (10) working days after completion of the Performance Period, the Licensed Software shall be deemed accepted by the CUSTOMER, and payment will be due in accordance with the Schedule of Payments (Attachment A) d Non -Performance of Application Software If the Performance Criteria are not met during the Performance Period, then, as outlined in the Agreement, CUSTOMER may reject the Licensed Software CUSTOMER may also request OWNER to rectify observed deficiencies in the Licensed Software, in which case OWNER shall modify or fix the Licensed Software to meet the features and functionality set out in the Functional Requirements (Attachment 1) e Acceptance of Replacement Licensed Software: After delivery and upon completion of installation, OWNER shall certify in writing to the CUSTOMER that replacement Licensed Software has been installed, personnel trained, and the Licensed Software is ready to use This date shall thereafter constitute the Installation Date The Performance Period will commence again, as of the first workday date the CUSTOMER is able to use the Licensed Software operationally Section "c" shall apply after completion of the performance period Ds[TECHNOLOGY ESCROW SERVICES" An Ir m Mumun t ompa% Comprehensive Preferred Agreement Comprehensive Preferred offers the flexibility of a modifiable contract combined with premium protection for both the depositor and the beneficiary All parties will receive signed confirmations from DSI that every deposit has been inspected, an account history report every six months to notify them of the status of the escrow, and ongoing monitoring services to ensure compliance of contract terms Also included in this agreement is Level I Verification, DeposlTrack (a service that tracks, solicits and confirms all scheduled deposits) and DSI's Unlimited Update Service (which ensures that deposit materials stay current, accurate and usable at a fraction of the cost) Purpose DS!'s Comprehensive Preferred Agreement is generally used when Both parties agree that the highest level of escrow protection is needed The beneficiary wants to sign the agreement The beneficiary wants the option to request a release of deposit materials directly from DSI The beneficiary wants to negotiate unique release conditions, such as loss of support Features Comprehensive Preferred customers benefit from these unique features Level I Verification of deposit materials This includes documentation of the hardware and software environments needed to read the computer media, maintain the source code, and compile the source code DeposiTrack, which involves continual deposit maintenance DSI reminds the depositor semi- annually to make updates and notifies the beneficiary of any update activity • Unlimited deposit updates and/or replacements, plus one additional storage unit Tailored release conditions • Modification of terms for unique requirements • Written notification detailing the contents of the initial deposit and each update • Semi-annual account histories listing all deposit activity • DSI direct billmg to beneficiary • Technical verification options • Audit rights to both parties • Audit trail of deposit created through inspection, dating and time -stamping of all deposit materials Deposit inspection with signed receipt for both the depositor and beneficiary Grant of use rights and deposit content definition San Francisco Boston New York Chicago Dallas Atlanta San Diego Los Angeles Toronto London For More Information Call (800) 962-0652 © 1983,+999-Z000 DSI GM4CP003vl COMPREHENSIVE PREFERRED ESCROW AGREEMENT Account Number This Agreement is effective 20 among DSI Technology Escrow Services, Inc ("DSI"), ("Depositor") and ("Preferred Beneficiary"), who collectively may be referred to in this Agreement as "the parties " A Depositor and Preferred Beneficiary have entered or will enter into a license agreement, development agreement, and/or other agreement regarding certain proprietary technology of Depositor (referred to in this Agreement as "the License Agreement') B Depositor desires to avoid disclosure of its proprietary technology except under certain limited circumstances C The availability of the proprietary technology of Depositor is critical to Preferred Beneficiary in the conduct of its business and, therefore, Preferred Beneficiary needs access to the proprietary technology under certain limited circumstances D Depositor and Preferred Beneficiary desire to establish an escrow with DSI to provide for the retention, administration and controlled access of the proprietary technology materials of Depositor E The parties desire this Agreement to be supplementary to the License Agreement pursuant to 11 United States [Bankruptcy] Code, Section 365(n) ARTICLE 1 — DEPOSITS I l Obligation to Make Deposit. Upon the signing of this Agreement by the parties, Depositor shall deliver to DSI the proprietary technology and other materials ("Deposit Materials") required to be deposited by the License Agreement or, if the License Agreement does not identify the materials to be deposited with DSI, then such materials will be identified on an Exhibit A If Exhibit A is applicable, it is to be prepared and signed by Depositor and Preferred Beneficiary DSI shall have no obligation with respect to the preparation, signing or delivery of Exhibit A 12 Identification of Tangible Media. Prior to the delivery of the Deposit Materials to DSI, Depositor shall conspicuously label for identification each document, magnetic tape, disk, or other tangible media upon which the Deposit Materials are written or stored Additionally, Depositor shall complete Exhibit B to this Agreement by listing each such tangible media by the item label description, the type of media and the quantity The Exhibit B must be signed by Depositor and delivered to DSI with the Deposit Materials Unless and until Depositor makes the initial deposit with DSI, DSI shall have no obligation with respect to this Agreement, except the obligation to notify the parties regarding the status of the deposit account as required in Section 2 2 below 13 Denosit Inspection When DSI receives the Deposit Materials and the Exhibit B, DSI will conduct a deposit inspection by visually matching the labeling of the tangible media containing the m 1983, 4099-29 DSI GRWY4CE 03v1 Deposit Materials to the item descriptions and quantity listed on the Exhibit B In addition to the deposit inspection, Preferred Beneficiary may elect to cause a verification of the Deposit Materials in accordance with Section 16 below 14 Acceptance of Deposit At completion of the deposit inspection, if DSI determines that the labeling of the tangible media matches the item descriptions and quantity on Exhibit B, DSI will date and sign the Exhibit B and mail a copy thereof to Depositor and Preferred Beneficiary If DSI determines that the labeling does not match the item descriptions or quantity on the Exhibit B, DSI will (a) note the discrepancies in writing on the Exhibit B, (b) date and sign the Exhibit B with the exceptions noted, and (c) mail a copy of the Exhibit B to Depositor and Preferred Beneficiary DSI's acceptance of the deposit occurs upon the signing of the Exhibit B by DSI Delivery of the signed Exhibit B to Preferred Beneficiary is Preferred Beneficiary's notice that the Deposit Materials have been received and accepted by DSI 1 S Depositor's Representations Depositor represents as follows a Depositor lawfully possesses all of the Deposit Materials deposited with DSI, b With respect to all of the Deposit Materials, Depositor has the right and authority to grant to DSI and Preferred Beneficiary the rights as provided in this Agreement, C The Deposit Materials are not subject to any lien or other encumbrance, d The Deposit Materials consist of the proprietary technology and other materials identified either in the License Agreement or Exhibit A, as the case may be, and e The Deposit Materials are readable and useable in their current form or, if any portion of the Deposit Materials are encrypted, the decryption tools and decryption keys have also been deposited 16 Verification DSI shall perform a Level I verification of the Deposit Materials upon the initial deposit and for each update A verification determines, in different levels of detail, the accuracy, completeness, sufficiency and quality of the Deposit Materials A Level I venfication is defined as follows DSI will cause a technically qualified DSI employee to evaluate the Deposit Materials in order to identify (a) the hardware and software configurations reasonably necessary to maintain the Deposit Materials, (b) the hardware and software configurations reasonably necessary to compile the Deposit Materials, and (c) the compilation instructions DSI will then prepare and deliver to Depositor and Preferred Beneficiary a report describing the information so identified It shall be the responsibility of the Depositor, and not DSI, to ensure that the Deposit Materials contain the information so identified in DSI's report, as well as any other information that may be required in the License Agreement Preferred Beneficiary shall have the right, at Preferred Beneficiary's expense, to cause higher levels of verification of any Deposit Materials Preferred Beneficiary shall notify Depositor and DSI of Preferred Beneficiary's request for venfication Depositor shall have the right to be present at the verification If a verification is elected after the Deposit Materials have been delivered to DSI, then only DSI, or at DSI's election an independent person or company selected and supervised by DSI, may perform the venfication Page 2 GPW9 4 0 v l 1 7 Deposit Updates Unless otherwise provided by the License Agreement, Depositor shall update the Deposit Materials within 60 days of each release of a new version of the product which is subject to the License Agreement Such updates will be added to the existing deposit All deposit updates shall be listed on a new Exhibit B and the new Exhibit B shall be signed by Depositor Each Exhibit B will be held and maintained separately within the escrow account An independent record will be created which will document the activity for each Exhibit B The processing of all deposit updates shall be in accordance with Sections 12 through 16 above All references in this Agreement to the Deposit Materials shall include the initial Deposit Materials and any updates DSI shall notify Depositor in writing semi-annually of Depositor's obligation to make updated deposits Within 30 days of receipt of each such notice, Depositor shall certify in writing to DSI that (a) it has made the updated deposits as required in the immediately preceding paragraph, or (b) there has not been a release of a new version of the product since the last deposit After the 30 days, DSI shall notify Preferred Beneficiary that DSI has received (a) an updated deposit from Depositor, (b) a statement from Depositor advising there has not been a release of a new version of the product since the last deposit, or (c) no response from Depositor Unlimited deposit updates and two storage units are included in the fees for this Agreement 18 Removal of Deposit Matenals, The Deposit Materials may be removed and/or exchanged only on written instructions signed by Depositor and Preferred Beneficiary, or as otherwise provided in this Agreement ARTICLE 2 -- CONFIDENTIALITY AND RECORD KEEPING 2 1 Confidentiality DSI shall maintain the Deposit Materials in a secure, environmentally safe, locked facility which is accessible only to authorized representatives of DSI DSI shall have the obligation to reasonably protect the confidentiality of the Deposit Materials Except as provided in this Agreement, DSI shall not disclose, transfer, make available, or use the Deposit Materials DSI shall not disclose the content of this Agreement to any third party If DSI receives a subpoena or other order of a court or other judicial tribunal pertaining to the disclosure or release of the Deposit Materials, DSI will immediately notify the parties to this Agreement unless prohibited by law It shall be the responsibility of Deposit to challenge any such order, provided, however, that DSI does not waive its rights to present its position with respect to any such order DSI will not be required to disobey any court or other judicial tribunal order (See Section 7 S below for notices of requested orders ) 22 Status Reports. DSI will issue to Depositor and Preferred Beneficiary a report profiling the account history at least semi-annually DSI may provide copies of the account history pertaining to this Agreement upon the request of any party to this Agreement 2 3 Audit Rights. During the term of this Agreement, Depositor and Preferred Beneficiary shall each have the right to inspect the written records of DSI pertaining to this Agreement Any inspection shall be held during normal business hours and following reasonable prior notice ARTICLE 3 -- GRANT OF RIGHTS TO DSI Page GP# CP003vl 3 1 Title to Media Depositor hereby transfers to DSI the title to the media upon which the proprietary technology and materials are written or stored However, this transfer does not include the ownership of the proprietary technology and materials contained on the media such as any copyright, trade secret, patent or other intellectual property rights 3 2 $i2ht to Make Comes. DSI shall have the right to make copies of the Deposit Materials as reasonably necessary to perform this Agreement DSI shall copy all copyright, nondisclosure, and other proprietary notices and titles contained on the Deposit Materials onto any copies made by DSI With all Deposit Materials submitted to DSI, Depositor shall provide any and all instructions as may be necessary to duplicate the Deposit Materials including but not limited to the hardware and/or software needed 3 3 Rieht to Transfer Upon Release Depositor hereby grants to DSI the right to transfer the Deposit Materials to Preferred Beneficiary upon any release of the Deposit Materials for use by Preferred Beneficiary in accordance with Section 45 Except upon such a release or as otherwise provided in this Agreement, DSI shall not transfer the Deposit Materials ARTICLE 4 -- RELEASE OF DEPOSIT 41 Release Conditions As used in this Agreement, "Release Condition" shall mean the following a Depositor's failure to carry out obligations imposed on it pursuant to the license agreement, or b Depositor% failure to continue to do business in the ordinary course 4 2 Filme For Release. If Preferred Beneficiary believes in good faith that a Release Condition has occurred, Preferred Beneficiary may provide to DSI written notice of the occurrence of the Release Condition and a request for the release of the Deposit Materials Upon receipt of such notice, DSI shall provide a copy of the notice to Depositor by commercial express mail 4 3 Contrary Instructions From the date DSI malls the notice requesting release of the Deposit Materials, Depositor shall have ten business days to deliver to DSI contrary instructions "Contrary Instructions" shall mean the written representation by Depositor that a Release Condition has not occurred or has been cured Upon receipt of Contrary Instructions, DSI shall send a copy to Preferred Beneficiary by commercial express mail Additionally, DSI shall notify both Depositor and Preferred Beneficiary that there is a dispute to be resolved pursuant to the Dispute Resolution section (Section 7 3) of this Agreement Subject to Section 5 2, DSI will continue to store the Deposit Materials without release pending (a) joint instructions from Depositor and Preferred Beneficiary, (b) resolution pursuant to the Dispute Resolution provisions, or (c) order of a court 4 4 Release of Deuosit. If DSI does not receive Contrary Instructions from the Depositor, DSI is authorized to release the Deposit Materials to the Preferred Beneficiary or, if more than one beneficiary is registered to the deposit, to release a copy of the Deposit Materials to the Preferred Beneficiary However, DSI is entitled to receive any fees due DSI before making the release Any copying expense in excess of $300 will be chargeable to Preferred Beneficiary This Agreement will terminate upon the release of the Deposit Materials held by DSI Page 4 EP49v3CP003v1 4 5 Right to Use Following Release Unless otherwise provided in the License Agreement, upon release of the Deposit Materials in accordance with this Article 4, Preferred Beneficiary shall have the right to use the Deposit Materials for the sole purpose of continuing the benefits afforded to Preferred Beneficiary by the License Agreement Preferred Beneficiary shall be obligated to maintain the confidentiality of the released Deposit Materials ARTICLE 5 -- TERM AND TERMINATION 5 1 Term of Aareement. The initial term of this Agreement is for a period of one year Thereafteri this Agreement shall automatically renew from year-to-year unless (a) Depositor and Preferred Beneficiary jointly instruct DSI in writing that the Agreement is terminated, or (b) the Agreement is terminated by DSI for nonpayment in accordance with Section 5 2 If the Deposit Materials are subject to another escrow agreement with DSI, DSI reserves the right, after the initial one year term, to adjust the anniversary date of this Agreement to match the then prevailing anniversary date of such other escrow arrangements 5 2 Termination for Nonnavment In the event of the nonpayment of fees owed to DSI, DSI shall provide written notice of delinquency to all parties to this Agreement Any party to this Agreement shall have the right to make the payment to DSI to cure the default If the past due payment is not received in full by DSI within one month of the date of such notice, then DSI shall have the right to terminate this Agreement at any tune thereafter by sending written notice of termination to all parties DSI shall have no obligation to take any action under this Agreement so long as any payment due to DSI remains unpaid 5 3 Drsnosition of Deposit Materials Unon Termination. Upon termination of this Agreement, DSI shall destroy, return, or otherwise deliver the Deposit Materials in accordance with Depositor's instructions If there are no instructions, DSI may, at its sole discretion, destroy the Deposit Materials or return them to Depositor DSI shall have no obligation to return or destroy the Deposit Materials if the Deposit Materials are subject to another escrow agreement with DSI 5 4 Survival of Terms Following Termination Upon termination of this Agreement, the following provisions of this Agreement shall survive Depositor's Representations (Section 15), b The obligations of confidentiality with respect to the Deposit Materials, c The rights granted in the sections entitled Right to Transfer Upon Release (Section 3 3) and Right to Use Following Release (Section 4 5), if a release of the Deposit Materials has occurred prior to termination, d The obligation to pay DSI any fees and expenses due, The provisions of Article 7, and f Any provisions in this Agreement which specifically state they survive the termination or expiration of this Agreement Page 5 ARTICLE 6 -- DSI'S FEES 6 1 FRe Schedule DSI is entitled to be paid its standard fees and expenses applicable to the services provided DSI shall notify the party responsible for payment of DSI'S fees at least 60 days prior to any increase in fees For any service not listed on DSI's standard fee schedule, DSI will provide a quote prior to rendering the service, if requested 62 Pavment Terms. DSI shall not be required to perform any service unless the payment for such service and any outstanding balances owed to DSI are paid in full Fees are due upon receipt of a signed contract or receipt of the Deposit Materials whichever is earliest If invoiced fees are not paid, DSI may terminate this Agreement in accordance with Section 5 2 Late fees on past due amounts shall accrue interest at the rate of one and one-half percent per month (18% per annum) from the date of the invoice ARTICLE 7 -- LIABILITY AND DISPUTES 7 1 Wght to Rely on Instructions. DSI may act in reliance upon any instruction, instrument, or signature reasonably believed by DSI to be genuine DSI may assume that any employee of a party to this Agreement who gives any written notice, request, or instruction has the authority to do so DSI will not be required to inquire into the truth or evaluate the ment of any statement or representation contained in any notice or document DSI shall not be responsible for failure to act as a result of causes beyond the reasonable control of DSI 72 Indemnification Depositor agreWto mdemmfy, defend and hold harmless DSI from any and all clauns, actions, damages, arbitration fees and expenses, costs, attorney's fees and other liabilities ("Liabilities') incurred by DSI relating in any way to this escrow arrangement unless such Liabilities were caused solely by the negligence or willful misconduct of DSI 7 3 Dispute Resolution Any dispute relating to or ansing from this Agreement shall be resolved by arbitration under the Commercial Rules of the American Arbitration Association Three arbitrators shall be selected The Depositor and Preferred Beneficiary shall each select one arbitrator and the two chosen arbitrators shall select the thud arbitrator, or failing agreement on the selection of the thud arbitrator, the American Arbitration Association shall select the third arbitrator However, if DSI is a party to the arbitration, DSI shall select the thud arbitrator Fatless r' •'&Fni* IJ 8 A— The location for arbitration will be determined and agreed unom by the Deuositor and Prefened BCrieliCldr9 Any court having jurisdiction over the matter may enter judgment on the award of the arbitrator(s) Service of a petition to confirm the arbitration award may be made by First Class mail or by commercial express mail, to the attorney for the party or, if unrepresented, to the party at the last known business address 7 4 Controlling Law This Agreement is to be governed and construed in accordance with the laws of the State of GakfemiajSxag, without regard to its conflict of law provisions Page 6 6F99*KP003vl 7 5 Nptice of Reauested Order. If any party intends to obtain an order from the arbitrator or any court of competent jurisdiction which may direct DSI to take, or refrain from taking any action, that party shall a Give DSI at least two business days' prior notice of the hearing, b Include in any such order that, as a precondition to DSI's obligation, DSI be paid in full for any past due fees and be paid for the reasonable value of the services to be rendered pursuant to such order, and c Ensure that DSI not be required to deliver the original (as opposed to a copy) of the Deposit Materials if DSI may need to retain the original in its possession to fulfill any of its other duties ARTICLE 8 -- GENERAL PROVISIONS 8 1 EE, lire A=ement. This Agreement, which includes the Exhibits described herem, embodies the entire understanding among the parties with respect to its subject matter and supersedes all previous communications, representations or understandings, either oral or written DSI is not a party to the License Agreement between Depositor and Preferred Beneficiary and has no knowledge of any of the terms or provisions of any such License Agreement DSI's only obligations to Depositor or Preferred Beneficiary are as set forth in this Agreement No amendment or modification of this Agreement shall be valid or binding unless signed by all the parties hereto, except that Exhibit A need not be signed by DSI, Exhibit B need not be signed by Preferred Beneficiary and Exhibit C need not be signed 8 2 Notices All notices, invoices, payments, deposits and other documents and communications shall be given to the parties at the addresses specified in the attached Exhibit C It shall be the responsibility of the parties to notify each other as provided in this Section in the event of a change of address The parties shall have the right to rely on the last known address of the other parties Unless otherwise provided in this Agreement, all documents and communications may be delivered by Fast Class mad 8 3 Severabihty In the event any provision of this Agreement is found to be invalid, voidable or unenforceable, the parties agree that unless it materially affects the entire intent and purpose of this Agreement, such invalidity, voidability or unenforceability shall affect neither the validity of this Agreement nor the remaining provisions herem, and the provision in question shall be deemed to be replaced with a valid and enforceable provision most closely reflecting the intent and purpose of the original provision 84 SSliccessors This Agreement shall be binding upon and shall mure to the benefit of the successors and assigns of the parties However, DSI shall have no obligation in performing this Agreement to recognize any successor or assign of Depositor or Preferred Beneficiary unless DSI receives clear, authoritative and conclusive written evidence of the change of parties 8 5 Regulations Depositor ponsible for and warrant compliance with all applicable laws, rules and regulations, including but not limited to customs laws, import, export, and re-export laws and government regulations of any country from or to Page 7 GP99a�3CP003yl which the Deposit Materials may be delivered in accordance with the provisions of this Agreement Depositor Preferred Beneficiary By By Name Name Title Title Date Date DSI Technology Escrow Services, Inc By _ Name Title Date Page 8 EXHIBIT A MATERIALS TO BE DEPOSITED Account Number Depositor represents to Preferred Beneficiary that Deposit Materials delivered to DSI shall consist of the following Depositor Preferred Beneficiary B v By Name Tide Date Name Title Date Page 9 GF94+�3CP003v1 DESCRIPTION OF DEPOSIT MATERIALS Depositor Company Name Account Number Product Name Version _ (Product Name will appear as the Exhibit B Name on Account History report) DEPOSIT MATERIAL DESCRIPTION Quantity Media Type & Size Disk 3 5" or DAT tape in m CD-ROM Data cartridge tape TK 70 or_ tape Magnetic tape _ Documentation Other PRODUCT DESCRIPTION. Environment EXHIBIT B Label Description of Each Separate Item DEPOSIT MATERIAL INFORMATION Is the media or are any of the files encrypted? Yes t No and the decryption tools Encryption tool name Hardware required Software required Other required information I certify for Depositor that the above described Deposit Materials have been transmitted to DSI Signature _ Print Name Date If yes, please include any passwords Version DSI has inspected and accepted the above materials (any exceptions are noted above) Signature _ Print Name _ Date Accepted Exhibit E# t Send materials to DSI, 9265 Sky Park Ct, Suite 202, San Diego, CA 92123 (858) 499-1600 Page 10 43119' 3CP003v1 DESIGNATED CONTACT Account Number Notices, deposit material returns and communications to Depositor should be addressed to Company Name Address Contact Telephone Facsimile Invoices to Depositor should be addressed to Contact P O #, if required. Pursuant ro Section 16 Vertficatign Contact Telephone Notices and communications to Invoices to Preferred Beneficiary Preferred Beneficiary should be addressed to should be addressed to Company Name Address Contact Contact Telephone Facsimile P O #, if required Requests from Depositor or Preferred Beneficiary to change the designated contact should be given in writing by the designated contact or an authorized employee of Depositor or Preferred Beneficiary Contracts, Deposit Materials and notices to DSI should be addressed to DSI Technology Escrow Services, Inc Contract Administration 9265 Sky Park Court, Suite 202 San Diego, CA 92123 Telephone (858) 499-1600 Facsimile, (858) 694-1919 Page I Invoice inquiries and fee remittances to DSI should be addressed to DSI Technology Escrow Services, Inc Accounts Receivable PO Box 45 156 San Francisco, CA 941450156 (858) 499-1636 (858) 499-1637 GM*3 PC 003vL VisrorWR Attachment 11V VisionAIR Help Desk INTRODUCTION The function of the VisionAIR Help Desk is to provide efficient support to all VisionAIR customers This service includes a direct toll free telephone line for the exclusive use of our customers in reporting software problems and on-line Internet support VisionAIR's Help Desk is a 24-hour a day, 7 day a week, 365 days a year operation that provides service per a maintenance agreement with your agency You may choose Monday through Friday 8 X 5 or 24 X 7 support GETTING STARTED WITH THE HELP DESK Prior to placing Help Desk calls, each agency should register for accounts for all persons that will be calling Help Desk These accounts will enable you to register calls with the Help Desk, to place online submissions and query your service request tickets online Simply go to the web site and follow the instructions online We will need, at a minimum, the following information first and last name of the contact who will be calling, title, agency name, agency address, phone number, email address, fax number & agency dial up Information (if you know this, if not it will be collected at some point) PROCEDURES FOR REPORTING PROBLEMS The designated contacts should be the people submitting tickets to the Help Desk We recommend that they be knowledgeable about the application's software, the agency's Implementation of the software, and the hardware and network configuration for the site The key to quickly resolving any problem is documenting and reproducing it Reporting that the "system doesn't work" Is insufficient information and wastes the valuable time of you and the Support Technician in trying to obtain details to begin solving the problem The more specific you are about your problem, the more quickly we can resolve it You should know the information listed below and have it with you when you call Alternatively, you may fax or e-mail It to the Castle Hayne office or choose the online Customer Service Center located on our websits to electronically submit a service request Important information to document includes, but is not limited to • Product Type and Name • Function being performed (adding, modifying, deleting) • Other system activity (backup, running reports, ad -hoc searches) • Any print outs, screen dumps or error messages • Any work that was done to the network or hardware (adding disks, workstations, communication changes) • Anything that's changed since the system last functioned properly WHAT HAPPENS WHEN YOU CALL THE HELP DESK To submit a service request, you can call the toll free number (1-800-756-TECH) or you can go to the Customer Service Center and submit online When you call the toll free Support number, your call is answered by a Triage call -taker This person obtains all the necessary Information listed above, gives you a ticket number for reference to your issue and either directs your call directly to a Support Technician or assigns your issue to a technician that will call you back as soon as they are available Your call Is Initially assigned to a Level I Support Technician If they cannot resolve the Issue within 4 hours, it will be escalated to a Level II Support Technician A call that has been escalated or initially assigned to a Level II Support Technician on which significant progress has not been Page 1 Vislo,nAIR made within 4 hours will be escalated to a Support Level III Technician assigned to the Development Team The 4-hour escalation rule is defined as the time a technician is actively working on the Issue, not including the time your issue is queued in a pending status VisionAIR provides support services to our 24 X 7 maintenance plan customers using qualified staff members on a rotational schedule After normal business hours and on weekends, onstaff support technicians have the availability of paging Tier III Technicians in the event that their services are needed for call resolution HELP DESK TOOLS The VislonAIR Help Desk has at its disposal RAS (Remote Access Service) and NetOp remote control services in order to resolve your agency's Issues This software enables us to see processes running at your agency on any particular machine In addition there are times that the Help Desk will deploy patches or executables in order to resolve software issues The VlsionAIR Help Desk utilizes knowledge management software, Know, to log solutions to issues that have been previously reported This gives our technicians the ability to search for resolution to your requests for assistance VisionAIR is in the process of preparing to publish knowledge base information to our customers via the Internet The Help Desk has implemented interfaces that will allow us to receive and reply to help desk tickets via email and the Internet These interfaces will also allow for you to access a knowledge base of Information and download a variety of documents that you will find helpful Customer's will only be able to view the calls I Issues that have been submitted by your agency REPORTING A "DOWN" SYSTEM All Vision application programs are complex, Involving many different functions and accessing multiple databases on various systems Our customers come to rely upon the smooth functioning of the technology system and a "down" system disrupts their operations A "down" system has the highest priority of any Help Desk call, and the after hours Help Desk program was created to meet the needs of 24-hour critical emergency operations "Down" systems should NOT be reported via the Internet. E-mall or Fax, but always called in on the toll -free Help Desk line "Down" systems are defined as follows • Unable to log into the system from any workstation, or group of workstations (such as a remote site ) • All external Interfaces are non-functional • CAD personnel are unable to enter and update calls or change unit status • Jail operators are unable to book or release inmates • Mobile Client(s) not able to connect to the Message Switch (Mobile Support number 1-888- VSI-TECH) • User(s) not able to enter data The technician taking the lead working with the customer on a down system has priority access to additional network and SQL technical resources within the Support Department as well as the Development Teams responsible for the VisionAIR application affected RESPONSE TIME OBJECTIVES As referenced above, a "down" system is extremely disruptive to customer operations A "down" system has the highest priority of any Help Desk call, and the after hours Help Desk program was created to meet the needs of 24-hour critical emergency operations VisionAIR shall work continuously in response to a down system, and shall use all reasonable commercial efforts, until Page 2 VisionAIR an error correction is found and successfully implemented VisionAIR agrees to provide an error correction to a down system within one (1) calendar day of the down system being reported to VisionAIR by the customer Major Problems, such as the unavailability of a designated function, receive the next level of priority VisionAIR shall work continuously in response to a Major Problem, and shall use all reasonable commercial efforts, until an error correction is found and successfully implemented VisionAIR agrees to provide an error correction to a down system within two (2) calendar days of the Major Problem being reported to VisionAIR by the customer All other problems, such as an ad hoc report Issue, are Minor Problems and receive the lowest priority VlslonAIR shall use all reasonable commercial efforts until an error correction is found and successfully Implemented to these Minor Problems VisionAIR agrees to provide an error correction to a Minor Problem within fourteen (14) calendar days of the Minor Problem being reported to VlsionAlR by the customer The parties acknowledge the potentially idiosyncratic nature of problems in Licensed Software Also, the VlsionAIR Licensed Software is being used in combination with Customer's hardware, network connections and a number of third party software products, any aspect of which may be the cause of a system down The CUSTOMER and VisionAIR will work together to isolate the cause of the error VisionAIR will repair those errors which are covered services under the Software Service Agreement While the response times proposed constitute targeted goals to be met by the VisionAIR Help Desk for the benefit of CUSTOMER, it is understood that VisionAIR shall use all reasonable commercial efforts to respond to problems within the targeted response times ninety-five per cent (95%) of the time Sporadic failures to meet the targeted response times shall not constitute a failure to perform a material provision of this agreement Response time does not constitute a guarantee that Customer's system, which includes the hardware, network connectivity, third party software and the VlsionAIR Licensed Software will be fully operational any minimum percentage of the time BACKUP PROCEDURES & FAIL OVER It is critical that each agency understands the significance and importance of doing proper backups Industry standards have defined proper backups as being daily, weekly, monthly, quarterly and yearly Following proper storage procedures of that data will also ensure that in the event of hardware failure or disaster, the Help Desk can ensure that this data can be restored with minimal data loss The Help Desk cannot guarantee restoration of your lost data without proper backups The backup process actually has two parts The internal backup process used by SQL which creates a group of static files from which your entire database can be restored These files will be referred to as the backup set for the purposes of this document VisionAIR is responsible for the original creation of this backup set during your hardware installation and network configuration The location and schedule of the backup set on your server can be pinpointed through a support call covered under your maintenance Further consultation or the process of physically moving or copying the backup set to another media, i e a tape, is done on a billable basis as it is not covered under normal maintenance The physical state of your backup media or device is not the responsibility of VisionAIR In the event of server failure, restoration of the backup set is done on a billable basis VisionAIR recommends different types of fall over devices such as Co -Standby Server (formerly Vince), Clustering, etc The Help Desk has trained Co -Standby Server and Clustering personnel on staff to assist with your questions, however per your maintenance agreement, these are 1"tier support only products MAINTENANCE ON YOUR OWN Page 3 VisionAIR Backups are not the only type of System Maintenance you should perform Although your hardware is not part of the Vision maintenance plan, we suggest you setup monthly maintenance of your system Things such as Defragmentation programs, Virus Programs, and monitoring your event logs can assist you in maintaining a healthy network Often the Event Viewer can give a hint of a problem before It grows or if you notice the event viewer filling up, you may plan a re -boot of the servers and workstations at a convenient time HELP DESK PROCEDURES Support Technicians are knowledgeable about Vision application software and usually resolve their calls while the customer is on the line In order to track calls effectively, the Support Technicians maintain an on-line history of your call, including date and time of call, description of the problem, the current status of the call, if technical help has been requested and final disposition of the call All customers will be called back within 12 hours of initial receipt of the issue The Support Director and Support Managers, who also receive a monthly summary of number of calls by agency, review call reports daily Calls received by the Help Desk usually fall Into one of these categories • Questions about application software functionality Support Technicians will answer a limited amount of questions about the general operation of the applications software However, the Help Desk is not a substitute for training Customers who attempt to use the Help Desk as a training ground for new employees will be notified that the Help Desk is primarily for problem reporting and will be directed to a VlsionAIR Account Executive to generate a quote for additional training • Isolated Incidents Infrequently, isolated incidents are reported where a program does not function as It was designed Support Technicians will attempt to duplicate the incident on your system If they are unable to do so, you will be asked to call back when or if it reoccurs • Recurring problems / No program changes required Problems of this nature are resolved via our on-line diagnostics We will dial Into your site and make the necessary changes to correct the problem • Setup and software configuration Issues • Problems with software installation Installation of new or upgraded software may cause unexpected problems such as inadvertent disconnecting of an interface These problems are dealt with as soon as they are reported • Support responds to calls based on severity An example would be the following System Dawn would be a technicians highest priority, a portion of the system being unable to perform it's designated function would be next, an adhoc report issue would be the least priority of a technician's queue • Support Technicians also receive calls that fall into the category of software enhancements, i e, the software Is operating according to the documentation, but the user feels it should be changed The customer will be notified that this is a Request for Change and requires that a Software Issue Submission (SIS) form be filled out and submitted to the SIB Manager These are placed into a SIS queue and reviewed by the Help Desk, Development, QA, and the Product Managers These calls are considered closed SIS PROCEDURES Page 4 VlslonAIR In some cases you might be asked to submit a Software Issue Submission (SIS) This can be done via email, fax or through the Customer Service Center online A SIS is either a Request For Change (RFC) feature request, an Issue you deem to be a bug in the software or a federal or state mandated change You submit the issue via the SIS form, and then a combination of the Help Desk, QA, Development and Product Managers test your SIS and handle it accordingly If your issue Is found to be a bug, then you will be notified when it will be fixed If your Issue is a feature, you will be notified as well When submitting an SIS, you will need the following information Product Choose from our nine products CAD, RMS, MOBILE, JAIL, EMS, FIRE, GEO, Municipal Court, or Magistrate Warrant Control Module I e Incident, Arrest, General Edit, etc Screen Name Found in brackets at the top left corner of your screen State Version For RMS, FIRE, EMS, COURT and JAIL only Check the pabasew im file for the state version Build Version Click on the Help menu and choose the About option for this number Build Date This will be on the screen with the Build Version Operating System Windows NT, Windows 98, etc Agency Assigned Issue # If your agency assigns a number for tracking purposes, place it here The SIB process does not replace the Help Desk You should still call the Help Desk if you are in doubt and a Support Technician will let you know if he or she can fix the issue or you should submit an SIS In most cases, a Support Technician can submit the SIS for you WHAT IS COVERED BY YOUR MAINTANENCE AND WHAT IS NOT COVERED MAINTANENCE • Unlimited Telephone Support for the Licensed Software, utilizing a toll -free line provided by VISIonAIR During each term of your software maintenance agreement, this telephone support will be available during the hours specified in the Renewal Quotation for that particular term Standard 8 X 5 coverage is defined by the customer's time zone • Initial fact-finding (Tier 1) support for 3 d party software embedded or used in conjunction with the application software (i a Microsoft products, Visio, ArcView, W inBeep, Co -Standby Server, etc ) • Correction of documented malfunctions ("bugs") in the application software • Assistance in installing updates and new releases of the Licensed Software on your servers • Processing your request for changes to the Software via the SIS process • Standard upgrades and enhancements that are made to the Licensed Software VisionAIR issues corrections, upgrades and enhancements to the software on an ongoing basis VislonAIR will use commercially reasonable efforts to update the Licensed Software as necessary to stay compliant with State and Federal requirements for crime reporting and information access All modifications to the Licensed Software and related Documentation will be sent to the customer on standard electronic media (CD-ROM) and/or be installed as an executable utilizing the RAS connection When necessary, every agency will provide access to Its network in order for the Help Desk to provide remote diagnostic services and to take corrective actions Each Agency will make available a dedicated telephone line, modem and RAS connection for use by the Help Desk Additionally, each agency shall, If required by the Software License Agreement and/or Minimum Hardware Specifications, maintain the necessary remote navigation software on their network Page 5 VisionAIR (NetOp at the time of this Agreement) so that the Help Desk can properly access the VisionAIR software on your network BILLABLE SERVICES / NON- COVERED MAINTENANCE Support Technicians are not expected to be knowledgeable about the operating system or about internal program functions If you request Information of this nature, it will be logged and you will be contacted with an estimate to provide you assistance in this area Other billable services available are • Making changes or corrections to customer -established tables • Converting and I or recovering corrupted data files caused by hardware or operating system malfunctions • External system work beyond those hours provided for under your maintenance agreement • Data Migration services for new server or workstation Installs • Repair of damage not caused by VisionAIR, including without limitation, damage resulting from accident, transportation, neglect or misuse, lightning, failure or fluctuation of electrical power, air conditioning or humidity control, telephone equipment or communication lines failure, failure of foreign interconnect equipment, or causes other than normal operating procedures • Repair of damage caused by installation of non -approved third party software(s) • Service which is impractical for VisionAIR to render because of alterations in the Licensed Software made by persons other than VisionAIR without receiving VisionAIR's prior written approval, the connection of equipment and I or Software by mechanical or electrical means to another machine or device, or the physical inaccessibility of the equipment or Software • Any repair of damage to the Licensed Software caused by software or firmware programming that is not provided or supported by VlslonAIR • Creation of Ad Hoc Reports Billable services are provided at a standard rate of $75 00 per hour during standard business hours and $150 00 per hour during non -business hours Standard Business Hours are Monday through Friday, 8 a m to 5 p m in the customer's time zone Hours expended may not exceed 8 hours without written authorization by your agency Hourly rates are subject to change If at any time you feel that the Help Desk has not responded in a proper fashion, we encourage you to contact the Help Desk Director and I or Managers VisionAIR is committed to providing quality support to you and your input will provide us the needed information to make our Help Desk the best in our industry Page 6