Loading...
HomeMy WebLinkAboutKansas City RFPGartner Gartner Consulting Prepared for City of Kansas City Request for Proposal for Public Safety Information Systems December 2001 Engagement: 220009530 5950 Canoga Avenue, Suite 600, Woodland Hills, CA D1367 +1-818-710-8855 Gartner Engagement: 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems Table of Contents I Gartner Consulting Entire contents C 2001 Gartner, Inc. For intemal use of City of Kansas City only. December 2001—Page i Gartner City of Kansas City Engagement: 220009530 Request for Proposal for Public Safety information Systems Table of Contents I. Rules of Preparation 1 A. Introduction 2 B. Request for Clarifications or Interpretations 3 C. Pre -Proposal Conference 4 D. Submission of Proposals 4 E. Supplemental Instructions or Changes 5 F. Taxes G. Minority and Women's Business Enterprises 5 H. Cost of Preparation of Proposal 5 I. Other Obligations 6 J. Demonstrations 6 K. Evaluation 7 L. Exceptions To The RFP 9 M. Confidentiality Of Documents 9 N. Contact With City Employees 9 O. Other General Conditions 9 II. Background and System Overview 11 A. Introduction 12 B. Goals and Objectives 16 C. Exhibits 18 III, Functional Requirements Overview and General Requirements 32 A. Glossary of Terms and Abbreviations 34 B. General Requirements 36 C. Usability 40 D. Security 43 E. Reports and Queries 47 F. On -Line Help and Documentation ; 51 G. Data Conversion 53 H. GIS Integration 55 IV. Computer Aided Dispatch (CAD) Functional Requirements 58 A. Response Instructions 59 B. Call Receipt and Incident Entry 65 C. Geofile and Address Verification 69 D. Real -Time Mapping 72 E. Incident Management... 75 F. General Dispatching 77 G. Unit and Incident Status Monitoring 80 H. Messaging Capabilities 82 I. System Administration 84 J. Supervision and Training 88 Gartner Consulting Entire contents ® 2001 Gartner, Inc. For intemal use of City of Kansas City only. December 2001—Page II Gartner Engagement: 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems K. On -Line Inquiries .• 89 L. Emergency Medical Services (EMS) ..91 V. Law Enforcement Records Management System Functional Requirements ..95 A. General Requirements 96 B. Master Files and Field Interviews 100 C. Incident and Crime Reporting 108 D. Arrest 112 E. Traffic 115 F. Properly and Evidence 122 G. Investigative Case Management 128 H. Crime Analysis 133 I. Warrants 136 J. Juvenile 139 K. Pawn 141 L. Jail Management 144 M. Imaging/Document Management 151 N. Mugshot System 155 VI. Fire Records Management System Functional Requirements ° 163 A. General Requirements 164 B. Incident Reporting i 167 C. Personnel 183 D. Apparatus, Equipment and Vehicle Maintenance 195 E. Supplies and Equipment Inventory 202 F. Fire Prevention 208 G. Training 227 VII. Mobile Data Computing (MDC) System Functional Requirements 232 A. Mobile Data Computer (MDC) System Functional Requirements .. 233 B. General Features and Functions for Mobile Data Computing 234 C. Mobile Data Dispatch Operations 240 D. Database Inquiries 245 E. Electronic Messaging 247 F. Automated Field Reporting 249 G. Electronic Mapping 252 H. Mobile Data System Reports and Output 254 1. Mobile Data System Security 255 J. Mobile Data System Logs and Audit Trails 256 K. Mobile Data System Performance and Redundancy 258 L. Automated Vehicle Location 259 VIII. Message Switch and Interface Requirements 260 A. Message Switch Functional Requirements 261 Gartner Consulting Entire contents © 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page ill Gartner City of Kansas City Engagement: 220009530 Request for Proposal for Public Safety Information Systems B. Interfaces .. 263 IX. Vendor Questionnaire 273 A. Checklist and Proposer Services . 275 B. Vendor General Information 277 C. Vendor References 279 D. Hardware 282 E. System Software 287 F. Application Software .290 G. Implementation and Project Management 305 • . l iuiiiii i^y JVy I. Warranty and Maintenance 311 J. Proposal/Contract Information 314 X. Proposer Cost Summary 317 A. Hardware Costs 319 B. System Software Costs 320 C. Application Software Costs 321 D. Other Costs 324 E. Optional Costs 324 F. Vendor Cost Summary 325 Appendix A — Sample Reports 327 Appendix B — Data Files for Conversion 336 Appendix C — Public Safety Information Systems Agreement .345 Appendix D — Minority and Women Business Enterprise 368 Gartner Consulting Entire contents © 2001 Gartner, inc. For internal use of City of Kansas City only. December 2001—Page iv Gartner City of Kansas City Engagement: 220009530 Request for Proposal for Public Safety Information Systems I. Rules of Preparation I. Rules of Preparation Gartner Consulting Entire contents © 2001 Gartner, Inc. For Internal use of City of Kansas City only. December 2001—Page 1 Gartner Engagement: 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems I. Rules of Preparation A. Introduction The City of Kansas City ("City") invites your company to submit a written proposal to provide comprehensive, fully integrated Public Safety Information Systems. Key components of the systems include Computer Aided Dispatch (CAD), Records Management System (RMS), including Jail Management, and Mobile Data Computer software (MDC), including Automated Field Reporting (AFR). Your proposal should include: • Appropriate application software to support Police CAD/RMS/MDC/AFR systems for a Department currently of 1,350 sworn and 644 civilian staff • Appropriate application software to support Fire CAD/RMS/MDC systems for 862 current Department employees, and approximately 100 additional employees to be funded by a special 15-year sales tax approved by voters on August 7, 2001 • The CAD system should support both Police and Fire • Appropriate application software to support the Municipal Correctional Institution (MCI) that regularly houses up to 330 inmates. • Server hardware to suppott the applications • Interfaces to a number of City and external systems • Project management, integration, installation and training services, including integration with existing systems and support for remote users • Maintenance and support services for the proposed systems. This Request for Proposal (RFP) states the overall scope of services desired, procurement terms and conditions, specific hardware and software requirements as well as vendor experience and qualifications to be provided. Section I — Provides the rules of preparation for proposals. Section II — Presents a brief background description of the City of Kansas City andits desired approach to implementing the Public Safety Information Systems. This section also contains a brief description of existing systems and networks installed at the key agencies involved. Section III — Provides instructions to vendors for responding to the detailed functional requirements section, and requests vendor responses to Public Safety Information Systems Global Functional Requirements. Section IV — Requests vendor responses to CAD Functional Requirements. Section V — Requests vendor responses to Law Enforcement RMS Functional Requirements. Section VI — Requests vendor responses to Fire RMS Functional Requirements. Section VII — Requests vendor responses to MDC, AFR and Automatic Vehicle Location (AVL) Functional Requirements. Gartner Consulting Entire contents ® 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 2 " Gartner Engagement: 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems I. Rules of Preparation Section VIII — Requests vendor responses to Message Switch and Interfaces Functional Requirements. Section IX — Requires vendor responses including company background and qualifications, specifications and capabilities of proposed systems, and services to be provided. Section X — Requires vendor responses for proposal cost information. Appendices — Includes representative reports, file layouts for data conversion and the City's 41e,..,r,,.e .,l,..,,.. 4 VVl %el WAWA., 'WWI 1L1.LLb L.. Your response should clearly detail how the equipment, software and services that you are proposing can best satisfy the City's requirements. The City requires a comprehensive solution with a prime contractor with legal, project management and financial responsibility for all hardware, software, integration and implementation services. One consolidated response with all cost items included in the cost summary shall be submitted. The prime contractor shall be the sole point of contact for the City with regard to contractual matters. This RFP is being provided on CD in Microsoft Word 2000 format to assist proposers in preparing their responses. However, failure to comply with or complete any portion of this request may result in rejection of a proposal. B. Request for Clarifications or Interpretations The City's project manager is Rick Brisbin of the Kansas City Information Technology Department. The City has hired Gartner Consulting to act as its consultants during systems planning and selection. Questions or comments regarding this RFP are to be directed to: Mr. Brian Hudson Gartner 5950 Canoga Avenue Suite 600 Woodland Hills, CA 91367-5051 (818) 710-5923 brian.hudson@gartner.com A prospective proposer may submit a request for clarification or interpretation of any aspect of the Request for Proposal. The City, in its judgement, may issue written addenda if it determines the answer to a question is relevant to all proposers. The City shall not be obligated to respond to requests for clarification or interpretations not received on a timely basis. Gartner Consulting Entire contents © 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 3 Gartner City of Kansas City Engagement: 220009530 Request for Proposal for Public Safety Information Systems I. Rules of Preparation C. Pre -Proposal Conference A pre -proposal conference will be held at 1:00 p.m. on January 11, 2001 on the Third Floor of the Information Technology Department, located at 1111 Locust Street, Kansas City, MO. Attendance at the pre -proposal conference is not mandatory; however, proposers are highly encouraged to be present. An optional tour of key City public safety facilities may be provided after the pre -proposal conference. In order for questions to be answered at the vendor conference they should be submitted in writing (electronic media preferred) at least live business days i11 ?Jl 1/H11{:Y. or jf7h! ('l1T1i'PrPnf'P Questions not submitted in advance of the conference may be asked but may or may not be answered at the conference itself. It is not the intention of the City to issue minutes or notes of the pre -proposal conference. However, written addenda or clarifications may be issued to all vendors attending the pre - proposal conference if deemed necessary by the City. • D. Submission of Proposals Under separate cover, please prepare and submit a Technical Proposal and a separate, sealed Project Cost Proposal. Vendors should provide one signed, along with eight (8) copies of both the Technical and Project Cost Proposals. The proposals containing the original signatures should clearly be marked "Original". The City requires hard copy. and electronic responses. The format of the RFP should be followed and all requested information submitted. Vendors are responsible for the completeness and accuracy of their proposal. A complete copy of. this RFP can also be downloaded from the City's website at www.kcmo.org. The Microsoft Word 2000 version of this RFP being provided may be used to prepare the hard copy response. In the event that any discrepancy between this RFP and the vendor proposal occurs, the RFP is the document of record. Proposals shall be sealed and be received no later than 4 p.m. on February 15, 2001. All proposals shall be submitted to: Mr. Rick Brisbin City of Kansas City, Missouri Information Technology Department 1111 Locust, Third Floor Kansas City, MO 64106 rick brisbin@kcmo.org Proposals received after the specified date and time may not be considered. To guard against premature opening, sealed proposals shall be submitted, plainly marked with the proposal title, vendor name, and time and date of the proposal submission deadline. Please note that there will be no public opening of proposals. Prices quoted in the proposal shall remain fixed and binding on the proposer for 180 days. Gartner Consulting Entire contents ® 2001 Gartner, Inc. For internal use of City of Kansas City? only. December 2001—Page 4 ' Gartner Engagement: 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems I, Rules of Preparation Upon receipt of vendor proposals, each vendor shall be presumed to be thoroughly familiar with all specifications and requirements of this RFP. The failure or omission to examine any form, instrument or document shall in no way relieve vendors from any obligation in respect to this RFP. E. Supplemental Instructions or Changes Any supplemental instructions or changes will be in the form of written addenda to this solicitation. Any addenda '1l d available ♦.. all + + addenda will be�mciuti:. a'v olio �. to alt pr�JJUe4ilV� ��ii�t iiti�i'Y iiYiiu•ir� inP nllp a , i date for submittal of proposals. It shall be presumed that any addenda so issued have been received by the proposer and such addenda shall become a part of the proposal submittal. Proposers who have not obtained this proposal solicitation document directly from the City shall be responsible for immediately notifying the City to receive all written addenda on a timely basis. Proposers who do not so notify the City and submit proposals without receipt of all addenda issued may be deemed to have submitted proposals not responsive to this request for proposal solicitation. F. Taxes Unless otherwise specified in this solicitation document, the proposer shall include and be responsible for paying all taxes, which shall be applicable to the goods or services or the. furnishing or sale thereof. G.Minority and Women's Business Enterprises Kansas City is committed to ensuring that minority and women's business enterprises (M/WBE) participate to the maximum extent possible in the performance of City contracts. M/WBE participation goals have been set for this contract and vendors must agree to comply with all requirements of the City's Minority and Women's Business Enterprise Program as enacted in City's Code Sections 38-84 through 38-100.4 and as hereinafter amended. Vendors shall make their best faith efforts in carrying out this policy by awarding any subcontracts that may become necessary to implement the City's policy under this contract. Vendor's compliance with this provision is a material part of this project, and vendors shall comply with the requirements shown in Appendix D incorporated into this proposal. Project M/WBE goals are identified in Section D. H. Cost of Preparation of Proposal The City will not pay costs incurred by proposing vendors in the proposal preparation, printing, demonstration or negotiation process. All costs shall be borne by the proposing vendor, with the exception of costs associated with City personnel visits to other sites. Gartner Consulting Entire contents C 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001--Page 5 ' Gartner Engagement: 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems I. Rules of Preparation I. Other Obligations The selected vendor will be required to enter into a written Agreement with the City. The City will require certain contractual obligations. These may include but are not limited to the following: 1. Status Reporting — The selected vendor will be required to attend, at a minimum, monthly status meetings and submit bi-monthly status reports covering such items as progress of work being performed, milestones attained, resources expended, problems encountered and corrective action taken, until final system acceptance. Status reports are to he in Gantt chart format. In addition, weekly status calls are also required. 2. Warranty — All equipment, software and workmanship are to be under warranty for a minimum of one year from the date of system acceptance. The warranty shall require the vendor to be responsible for all cost of parts, labor, field service, and pick up and delivery related to repairs or corrections during the warranty period. There is to be no cost to the City beyond those identified in the proposal. Costs — All costs should be detailed specifically in the Proposer Costs Summary.section of the proposal; vendor submission should be for a fixed price solution. Costs should he unbundled and separately listed. Vendors should fill out all appropriate cost pages. Proposals that do not detail specific costs on the forms provided in the Proposer Costs Stcrnmary section may be considered non -responsive. 4. Other - In a final contract, the City wants to obtain items such as performance gum antees system availability, response time, capacity, and detailed system acceptance criteria. Seine of the specific guarantees required are identified in the Vendor Questionnaire. section. The selected vendor should be prepared to negotiate the inclusion o#'such items within the scope of services and pricing. 5. Laws to be Observed — The selected vendor shall keep itself fully informed of and shall observe and comply with all applicable existing State and Federal Iaws and County.and City ordinances, regulations and codes, and those laws, ordinances, regulations and codes adopted during its performance of the work. 6. Payment Schedules — Payments for the proposed system shall be based on defined deliverables such as installation and training. No payments will be made in advance of work performed. No less than the remaining balance of twenty-five percent (25%) of the total purchase price shall be due upon final acceptance of the proposed system by the City. 7. Liquidated Damages — The City may include in the contract penalty provisions for non- performance. This may include liquidated damages at the rate of $500 per day. S. Selection — The final award of contract is subject to approval by the City acting through its Mayor and City Council. J. Demonstrations The City will require a thorough demonstration of all proposed software and systems by selected finalists. The City may also require finalist vendors to set up a representative system at the City Gartner Consulting Entire contents © 2001 Gartner, Inc. For internal use of City of Kansas Cityionly. December 2001—Page 6 Gartner City of Kansas City Engagement: 220009530 Request for Proposal for Public Safety Information Systems I. Rules of Preparation or nearby facility for the purpose of hands on evaluation of vendor software for a period of time. The vendor will also be required to demonstrate ad -hoc reporting capabilities on sample reports as defined by the City at the time of the demonstration. Additionally, the City may require visits to existing installations of comparable systems. K. Evaluation Evaluation of the proposals is expected to be completed within 90 days after they are opened. An ----°- evaluation team composed of 'Ct-C1F111 FI11Yr •' P. ' tv An(1 1fC rnny+yitantcr'n.•l., o.. evaluate proposals on a variety of quantitative and qualitative criteria. The proposal selected shall provide the most cost-effective approach that meets the City's requirements. The lowest price proposal will not necessarily be selected. The City reserves the right to reject any or all proposals, or to make no award. The City also reserves the right to require modifications to initial proposals or to make partial or multiple awards. The City further reserves the right to excuse technical defects in a proposal when, in the sole discretion of the City, such excuse is beneficial to the City. The City may award based au initial proposals received, without discussion of such proposals. Selected vendors may be invited to make oral presentations to City personnel. The vendor epresentative(s) attending the oral presentation: shallbe technically qualified to respond to questions related to the proposed system and its components. The criteria upon which the,evaluation of the proposals will be based includes, but is not limited to, the following: 1. Proposal • Completeness and thoroughness of the proposal. All required information should be provided, in the format specified. • The vendor's understanding of Kansas City's purpose, scope and objectives, including the applicability and quality of the vendor's approach. 2. Contract • The vendor's willingness to negotiate a contract, including payment terms, acceptable to the City of Kansas City. The number of exceptions taken to Kansas City's terms and conditions should be noted. 3. Costs • One-time costs. Although the low cost bidder may not necessarily be awarded the contract, costs are an important evaluation criteria. • Ongoing costs for maintenance and support. 4. Vendor Experience and Resources • The quality, relevance and number of references. Gartner Consulting Entire contents CD 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 7 Gartner Engagement: 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems 1. Rules of Preparation • The vendor's ability to successfully install the system, as demonstrated by installation of a similar system in at least one comparable jurisdiction within the past two years. Emphasis would be given to the specific capabilities required by the City. • The financial stability and resources of the vendor. 5. Application Software and Integration • Design, capability, and functionality of the proposed application software, including a quantitative analysis of the vendor's response to the RFP (i.e., the number of requirements incliirrieri in *he bane system, the ber t' requirements t al___,. l .. -1 .�•--• .. a..,...r>., waaa, number vi avr�ua14111411LJ i11GL L1UVU�'ll customization, and the number of requirements not provided). • The level of integration between modules. • The vendor's ability to interface with external systems. 6. Hardware Design/System Architecture Approach • Design, capability and functionality of the proposed hardware, including conformance with the City's architectural direction. The vendor's current technological position and future direction. implementation/Project Management • Level of assi stance to . be provided to the City by the vendor during the implementation process. +► Feasibility, timeliness and quality of the implementation schedule, and ability to meet the City's implementation deadlines. :. 1 f aining, Documentation and System Administration • The amount and extent of user training. • Quality and extent of the documentation to be provided. • The extent of the effort required to perform System Administration functions. 9. Customer Support/Warranty and Maintenance • The level of service and responsiveness that the vendor commits to providing the City of Kansas City. • QuaIifications, experience and technical expertise of the vendor's Customer Support staff. • Ability of the vendor to provide long-term maintenance support to the City. • The vendor's process for providing new releases of the software. The City reserves full discretion to determine the capability of proposers. Proposers .will provide, in a timely manner, any and all information that the City deems necessary to make such a decision. Gartner Consulting Entire contents ® 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 8 ' Gartner Engagement: 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems I. Rules of Preparation L. Exceptions To The RFP The format of the RFP should be followed and all requested information should be submitted as indicated. However, the City is receptive to any additional suggestions pertaining to services and system capabilities in addition to those contained in the RFP that the proposer believes would be useful to the City. Any exceptions to RFP terms and conditions should be included in writing in the vendor response. M.Confidentiality Of Documents All documents submitted as part of the vendor's proposal will be deemed confidential during the evaluation process. Vendor proposals will not be available for review by anyone other than the City/consultant evaluation team or its designated agents. There shall be no disclosure of any vendor's information to a competing vendor prior to award of the contract. Following award of contract, all proposals become public documents and are available for public viewing upon written request to the City. N. Contact With City Employees In order to .ensure Fair and objective evaluation, all questions related to this. RFP should he. addressed directlyto the City's consultant for this project. O..Cther General Conditions 1. Current Manufacture — Equipment furnished under this specification shall be standard • products of manufacturers regularly engaged in the production of such equipment and shall be the manufacturer's latest design. All material and equipment offered shall be new and unused. 2. Current Version — "Packaged" application and system software shall be the most current publisher or vendor's version, as of date of contract. However, no Beta test versions will be acceptable. 3. Prior Use — The City reserves the right to use equipment and material furnished under this,proposal prior to final acceptance. Such use shall not constitute acceptance of the work or any part thereof by the City. 4. Availability of Funds — In the event that sufficient funds are not available for the project, the City reserves the right to negotiate the scope of this contract, delay implementation, reject all proposals, or award another type of contract other than that required in this RFP. 5. Requirement to Meet All Proposal Provisions — Each proposer shall respond to all of the specifications and proposal terms and conditions. By virtue of the proposal submission, the proposer acknowledges agreement with and acceptance of all provisions of the Gartner Consulting Entire contents ® 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 9 Gartner City of Kansas City Engagement: 220009530 Request for Proposal for Public Safety Information Systems I. Rules of Preparation specifications except as expressly qualified in the proposal. Nonsubstantial deviations may be considered provided that the proposer submits a full description and explanation of and justification for the proposed deviations. Whether any proposed deviation is nonsubstantial will be determined by the City at its sole discretion. 6. Proposal Retention and Award — The City reserves the right to retain all proposals for a period of I80 days after the proposal opening date for examination and comparison. The City also reserves the right to determine and waive nonsubstantial irregularities in any proposal, to reject any or all proposals, and to make award as the interest of the City may Gartner Consulting Entire contents ® 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 10 ' Gartner Engagement: 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems II. Background and System Overview II. Background and System Overview Gartner Consulting Entire contents ® 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 11 Gartner Engagement: 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems II. Background and System Overview A. Introduction With a population of 441,545, the City of Kansas City provides a wide range of municipal services. Several agencies throughout the City are seeking to either replace or interface to new public safety systems as part of this project. The Kansas City Police Department (KCPD) serves as the law enforcement agency for the city while the Kansas City Fire Department (KCFD) serves the fire prevention, firefighting, rescue, inspection and EMS First Responder needs of the City. The KCPD is an independent state agency funded by the City, but controlled by the Board of Police CO III .Ippi inted by the i rovernor of iviiccniiri The K „'F D 1E a dep,..rtmcnt the City. The Metropolitan Ambulance Services Trust (MAST) is a not for profit public trust established by Kansas City to provide ambulance services throughout the greater Kansas City metropolitan area. MAST is a quasi -governmental agency totally separate from other public safety organizations in the city. Finally, the Municipal Correctional Institution (MCI) serves as a detention facility for approximately 8,500 — 9,500 inmates annually, who are sentenced by the Municipal Court. MCI houses 330 inmates at a time, who serve a maximum sentence of six months. Police The Police Department currently uses an in-house CAD system built on an IBM OSY390. mainframe. The system is over 18 years old and the Department intends to replace it as.part of this pi-ocureinent. Police currently uses an in -;souse developed RMS that is part of the ALERT system' (see description below). The existing RMS supports approximately 2,700 PCs and terminals and.runs on the IBM OS/390 mainframe. The existing CAD and RMS systems are not currently integrated. Police intends to acquire a new RMS as part of this project, which will then interface to the ALERT system. The Police Department uses a CML E9-1-1 system. Features utilized on this system include ANI/ALI, selective routing, speed dial, automatic transfer and agent observation. Within the Communications Center, there are currently 16 call taker positions. The call taker's primary function is to receive and enter incoming incidents. In addition to this primary function, call takers will also perform a variety of administrative functions. The call taker positions are not equipped with radio capability and do not perform radio dispatch tasks. Call takers do, however, routinely access and update incident and unit status information. There are currently 24 Police dispatcher positions. The Dispatchers primary function is to monitor and update unit and incident information. During normal operations, each of the dispatch positions is staffed with one dispatcher who is responsible for a specific geographic area. Occasionally, one dispatcher will handle more than one dispatch area from a single radio position. Dispatchers will frequently assist each other by monitoring and updating each other's units and incidents. The Police Department is currently using mobile data computers; Fire is not. Currently, Police has approximately 275 units equipped with SCA Premier MDT Version 3.5.12 mobile data software running on Panasonic CF-25 mobile data computers. The Department intends to upgrade to a newer version that runs on a 32-bit platform in early 2002. Police runs its mobile Gartner Consulting Entire contents ® 2001 Gartner Inc. For internal use of City of Kansas City only. December 2001—Page 12 Gartner Engagement: 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems 11. Background and System Overview data communications over a M/A Com 800 MHz trunked data network. At this time, Police MDC functions include CAD interfaces, basic messaging and queries. Automated Field Reporting, Automatic Vehicle Location and other applications are expected to be implemented in the future based on the systems being acquired in this procurement. The new Public Safety Information Systems are expected to utilize the existing Panasonic CF-25 mobile data computers and M/A Com 800 MHz data communications system. Fire The t r.___ n A n 1 _"--' 111E IJrese it 1' [I C l .A D k rl I rl-fll 11!se deve1oper1 system r n`ning on Unix c crs located __7 i KCFD Communications Center, with remote network printers located throughout the City, including at each of the 34 existing fire stations. Fire uses an in-house RMS for its records management functions. Fire's existing station alerting system is a Motorola INTRAC system and it is installed at each of the 34 existing stations. There are currently 6 call taker/dispatcher positions. The tall Taker/dispatcher primary function is to receive and enter incoming incidents. In addition to this primary function, call takers/dispatchers will also perform a variety of administrative functions. The Call Taker/Dispatchers primary function is to monitor and update unit and incident information. During normal operations, each of the di. patch positions is staffed with one dispatcher who is responsible for a specific geographic area. Occasionally, one dispatcher will handle:more than Dne dispatch 1rea from a single radio position. Dispatchers will frequently assist each other by monitoring and updating each other's units and incidents. Call taker/dispatchers are in frequent communication with MAST, the regional ambulance service, and need to share call.and . information between the. MAST American TriTech CAD system and the Fire CAD system. The exchange of information between the MAST and Fire CAD systems is strongly desired. MAST MAST provides emergency response and ambulance services for counties within the Kansas City :metropolitan area. It is the exclusive ambulance provider for Kansas City, Missouri•as well as Kansas City, Kansas. Operating a fleet of approximately 65 vehicles, MAST maintains its own radio, mobile data and CAD infrastructure separate from the City. MAST currently operates TriTech's CAD version 3.7.3 on approximately seven workstations at its communications center. Police and Fire want to interface their new CAD system to the existing TriTech system. Once complete and operational, the new CAD system, through its interface to the TriTech system, should be capable of creating new incidents in the TriTech system. The existing TriTech system should be capable of creating new incidents and updating existing incidents in the new Police and Fire CAD system. KIVA KIVA is a land information/permit and inspection system currently deployed citywide. Users rely on KIVA heavily for land information and permitting functions throughout the City. The City intends to interface the new integrated systems to this existing system. Gartner Consulting Entire contents © 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 13 Gartner City of Kansas City Engagement: 220009530 Request for Proposal for Public Safety Information Systems II. Background and System Overview Imaging System The Police Department currently uses an Eastman document imaging system (Version 3.2) to scan all Police reports. The Department is planning to migrate to Version 4.0 of the Eastman software before the end of 2001. Eastman's Version 4.0 software uses standard .tiff file formats. Some of the highlights of the existing imaging system include: • Compaq Proliant 3000 rack server (Primary Server) 768 MB of memory - .141 GB R 1 flllf .l'WATlTU 111P M H 1 1. - -•rr --- ------ - PII 333 MHz processor — NT 4.0 server — SQL server 7.0 Eastman software V. 3.2 • Compaq Proliant 3000 rack server (Archive Server) — 256 MB of memory yr yr 2I GB RAID 5 hot swappable HHD., Pl1 333 MHz processor NT 4.0 server SQL server 7.0 HP SureStore Worm Drive Model 160FX Eastman software V. 3,2 Currently, there are seven scan stations (one at each division and two at headquarters) and 100 view stations. After scanning reports into the system, the images are indexed with a screen scrape offa mainframe terminal session. Data stored is primarily CAD information: Another interface occurs within the Data Entry Section where images are pulled up and data is transferred from narrative and other areas from the report and electronically pushed on to a mainframe session to populate the accident, offense and other databases that reside on the mainframe. The Department is planning an upgrade to version 4.0, a 32-bit software platform before the end of 2001. Currently, there is 130 GB of data residing on the Optical Jukebox. Databases on the primary and archive servers run 290 MB and 150 MB respectively. The images themselves average 50K in size and are stored as Eastman software proprietary multipage TIFFs. These TIFF files cannot be viewed with standard TIFF viewers. There is no existing integration between the scanning stations and ALERT. Police anticipates either interfacing the new RMS to the existing system, replacing it with an imaging system acquired as part of this procurement. Gartner Consulting Entire contents C 2001 Gartner, Inc. For internal use of City of Kansas City'only. December 2001—Page 14 Gartner Engagement: 220009530 City of Kansas City Request for Proposal for Public Safety information Systems II. Background and System Overview Mugshot Systems There are three separate mugshot systems currently in use throughout the City: EPIC (Police), Syscon (MCI) and an in-house developed Access system (Juvenile). None of the existing mugshot systems has a significant level of existing integration with other internal or external systems. The existing functionality, age and quality of vendor support varies among the current systems. Currently, there are nine EPIC capture stations (four at KCPD headquarters, five at the various substations), one Syscon station at MCI and one in-house developed station in the Juvenile Division. There is no existing integration between the mugshot stations and ALERT. Pnlire anticipates repining existing mugshot systems around the new integrated system j. ..- j...._r ...t, its . ..pv.•... • systems around •.•\\M new •r a aw�a c\ e a r a�41J1 acquired through this procurement. The existing EPIC systems are Version 1.3.5 and run on SQL server 7.0. Images are standard beg files. ALERT ALERT is an extensive system that provides a variety of functions for KCPD, the Kansas City Municipal Court, and over 120 area law enforcement and justice agencies in Missouri and Kansas. It is maintained by KCPD technical staff and operates on a KCPD mainframe. Functions include: • Current KCPD RMS • Message switch interface to MULES (Missouri law enforcement message switch), which then provides access to NCIC, NLETS and MULES databases • Message switch interface to Missouri Department of Revenue, Kansas CJ1S and KCMO.org web server • Regional justice/law enforcement information system • KC Municipal Court uses ALERT to receive KCP.D reports, which initiate all Municipal Court cases An overview of ALERT system usage is provided below: [ALERT System Usage By Outside Agencies System Entry/Update Inquiry Only Timekeeping 2 agencies N/A Personnel 2 agencies NA CAD 3 agencies 31 agencies Alarms 1 agency N/A Offenses 3 agencies * Traffic 2 agencies * Arrests 18 agencies * Warrants 54 agencies * Stolen Auto 48 agencies * Probation Parole 19 agencies * Gartner Consulting Entire contents ® 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 15 Gartner Engagement: 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems II. Background and System Overview Pawn Broker 5 agencies 20 agencies Recovered Property KCPD 3 agencies Crime Lab KCPD 3 agencies Municipal Court (Financial) 2 agencies 2 agencies • Information displayed on various ALERT transactions as part of criminal history information. KCPD anticipates using the new RMS instead of ALERT for KCPD RMS functions. It anticipates interfacing with ALERT for message switching functions. GIS The City does not currently have an enterprise -wide GIS repository. Existing systems deployed throughout the City include ESRI, Intergraph and MapInfo. CAD and RMS systems being procured as part of this project are expected to have their own geofile that will'be built from the existing geofiles in use by the City. The City has recently released an RFP that will upgrade the City's GIS functionality. The goal of the GIS upgrade project is to have a geospatial data warehouse for its spatial data. MCI The Municipal Correctional Instit'itiun (MCI) currently utilizes separate money management and booking systems that are not integrated. Currently there is no integration between MCI's systems and those at the Police Department. The goal of the City is to replace the current MCI 'systems with a Jail Management System acquired through this procurement to integrate the jail with the records management. booking and other related components of the new integrated public safety ystem. B. Goals and Objectives The City's overall project goals include the following: • Enhance public safety by making more timely, accurate and complete information available to City, KCPD and MAST personnel • Utilize information technology to improve public safety service to the community • Increase productivity by eliminating redundancy and unnecessary tasks • Improve management and public policy decision making by increasing the ability to analyze public safety data • Allow for continuous upgrades of technology to support current and future core functional needs • Utilize and manage technology in a cost effective manner • Increase operational effectiveness via improved system training Gartner Consulting Entire contents ® 2001 Gartner, Ind: For internal use of City of Kansas City only. December 2001—Page 16 Gartner City of Kansas City Engagement: 220009530 Request for Proposal for Public Safety Information Systems II. Background and System Overview • Enhance internal communications through the use of information technology and improved business processes • Provide appropriate staffing levels to effectively manage and utilize new information systems • Improve sharing of information between City and external agencies. Vendor responsibilities for this project include the fallowing: _ Y i epiace the current separate nii�e and Fire CAD system is ....-..r.i. __. �. _-t....�.� .. systems with a �xu�l�+ 4W11�J1G11G11�1 VG, redundant CAD system that will interface with RMS, MDCs, E9-1-1, MAST CAD. KIVA, ALERT and indicated extemal systems. The new CAD systems will provide real- time mapping for call takers and dispatchers. • Replace the current separate Police and Fire RMS systems with comprehensive RMS systems for Police and Fire that will streamline data entry, improve quality and completeness of data, minimize redundant data entry and provide detailed search capabilities. Each RMS should interface with CAD. • Replace the current Jail Management System with a new Jail Management System integrated with Police RMS Provide mobile data software capabilities to the Police and Fire Departments. Utilize the ::urrent F ;lice Department SCA mobile data software or replace with a comprehensive, .fully -integrated mobile data software solution that will provide field access to critical data and automated field reporting software capabilities. The new Public Safety Information Systems are expected to utilize the Department's existing Panasonic CF-25 ,..mobile data computers and MIA Com 80O MHz data communications system. There are preliminary plans in place to upgrade and enhance the MDCs in the Department through a.separate procurement. The vendor is to propose all software to enable mobile data communications, including: Electronic dispatching between the Communications Centers and mobile devices Electronic messaging between mobile devices and other Police and Fire workstations RMS and CAD inquiries from MDCs - • In -vehicle mapping — Police Automated Field Reporting (AFR) system to enable online creation and submission of reports from MDCs to Police RMS — Other functions that the vendor considers appropriate for the MDC operation The selected vendor is expected to be responsible for the implementation of mobile data software both on a message switch host and MDCs. • The vendor is expected to provide message switching software and hardware that will allow access to the ALERT Network and other local, state and national databases. • The vendor is expected to replace the existing EPIC mugshot system and assume responsibility for converting existing mugshot and booking data from EPIC to the new system. Gartner Consulting Entire contents C 2001 Gartner, inc. For internal use of City of Kansas City only. December 2001—Page 17 Gartner City of Kansas City Engagement: 220009530 Request for Proposal for Public Safety Information Systems II. Background and System Overview • The vendor is expected to propose an integrated document imaging solution in one of the following ways: — Interface with the existing Police Eastman system (preferred) — Replace it as part of a fully integrated RMS as an option • Utilize/interface as needed with the City's GIS and land information systems (ESRI, KIVA, etc.) for geofile and mapping functions • The vendor will supply all necessary server hardware and system software. The City will provide the following system components: • Local and wide area data network infrastructure • Communications infrastructure and all in -vehicle hardware for mobile data communications • Desktop workstations. If network improvements to the City's infrastructure are necessary to implement any components of the proposed solution, vendors are encouraged to indicate these in their proposal. Minimum Performance Standards The City requires the proposed solution to meet the following minimum performance standards: • CAD response time — 2 seconds or less, 98% of the time, no operations to exceed 3 seconds a RMS response time — 2 seconds or less, 98% of the time, no operations to exceed 5 seconds • MDC response time — 2 seconds or less, 99% of the time, no operations to exceed 5 seconds, excluding network delays • Message switch — Provide costs for 99.999% (fault tolerant) and 99.99% (high availability), ability to do IP messaging, recognition and encryption • Online storage — store selected data files indefinitely as well as automated and manual purge dates for other data files and unit history details • AvailabiIity — 99.9% for CAD, 99% for RMS and 99% for MDC C. Exhibits • Exhibit l provides a projection of anticipated transaction and user volumes. • Exhibit 2 provides an overview of KCPD's organizational structure. • Exhibit 3 provides an overview of KCFD's organizational structure. • Exhibit 4 provides an overview of the City's current technology preferences. Gartner Consulting Entire contents © 2001 Gartner, Inc. For Internal use of City of Kansas City only. December 2001—Page 18 Gartner Engagement: 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems II. Background and System Overview • Exhibit 5 provides a list of current systems residing on the mainframe and maintained by the City. • Exhibit 6 provides an overview of the current KCPD systems architecture. • Exhibit 7 provides an overview of the current KCFD systems architecture. • Exhibit 8 provides an overview of the current KCPD data network. • Exhibit 9 provides an overview of the anticipated Kansas City integrated public safety systems architecture. Exhibit 1 presents volume information for sizing the processing and storage requirements of the new systems. In the cases where more accurate forecasts are not available, a standard 10% growth projection (indicated by an asterisk *) has been assumed for the given 5-year period. The proposed systems should be sized to meet the performance standards for the projected volumes plus a margin for unexpected volume growth. Volume Information i Service area in square miles Current (2001) Projected (2006) Police and Fire 317 317 . M.A.S.T. 433 (Primary service areas only) 433 (Primary service areas only) Service population . Police and Fire* 441,545 485,700 M.A.S:T.* 588,000 (Primary service areas only) 646,800 (Primary service areas only) Number of KCPD employees Fuil-tine sworn/uniformed* 1,350 1,600 Full-time civilian* 644 709 Number of KCFD employees 862 1,000 Number of requests for service for KCPD* 750,000 825,000 Number of calls received for KCFD 109,500 150,000 KCPD response areas 5 Patrol Divisions, 70 Beats 6 Patrol Divisions, 80 Beats Number of KCPD stations* 5 6 KCFD response areas 7 Batallion Districts, 55 Unit Response Areas, 9 Contract Areas 7 Batallion Districts, 65 Unit Response Areas, 9 Contract Areas 1 Number of KCFD stations* 34 . 38 Number of dispatched calls for service for KCPD 313,173 344,490 Number of dispatched calls for service for KCFD 52,328 70,000 Number of dispatched calls for service for MAST 65,000 — 75,000 75,000 Number of KCPD vehicles deployed in shift* 160 —170 176 -187 Total number of KCPD vehicles* 750 825 Gartner Consulting Entire contents ® 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 19 Gartner Engagement: 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems II. Background and System Overview Volume Information Current (2001) Projected (2006) Total number of KCFD vehicles 100 115 Total number of KCPD MDCs to be deployed* 275 400 Total number of KCFD MDCs to be deployed 60 70 Total number of KCPD CAD users* 95 total 105 total Call Takers* 16 per shift 19per shift Dispatchers* 23 per shift 25 per shift vuM Supci iscr'Y 3 oar they shill - I 3 drift per Total number of KCFD CAD users 22 26 CaII Takers/Dispatchers 5 per shift 6 per shift Supervisory 1 per shift 1 per shift Other 1 per shift 1 per shift Backup 3 per shift 1 per shift Total number of KCPD RMS users* 2,014 2,215 Number of pages scanned by KCPD per year* 600,000 - 650,000 660,000 MULES records checks per year* 3,220,000 3,542,000 NCIC records checks per year* 847,888 932,677 NCIC records checks per year from all ALERT agencies 3,142,129 3,456,342 Number of crime reports per year* 72,774 80,051 Number of KCPD case numbers per year* 132,252 145,477 Number of KCFD incident reports per year 52,328 57,175 Number of adult arrests* 64,675 71,143 Number of juvenile arrests* 3,648 4;013 Number of field interviews* 4,060 4,466 Traffic citations* 159,633 170,000 Parking violations* 117,461 120,000 Traffic accidents* 26,708 29,7,30 Evidence and property Items booked* 25,000 27,500 Items released/destroyed* 22,072 24,279 Municipal Court Number of concurrent users* 85 94 Annual number of warrants* 150,000 (All non- extraditable) 165,000 (All non - extraditable) . Annual number of citations* 240,000 - 280,000 264,000 - 308,000 Active cases* 150,000 165,000 Active warrants* 200,000+ 220,000+ Closed cases* 150,000 -- 200,000 165,000 - 220,000 Gartner Consulting Entire contents © 2001 Gartner, Inc! For Internal use of City of Kansas City only. December 2001-Page 20 Gartner Engagement 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems II. Background and System Overview Volume Information Current (2001 j Projected (2006) Total cases* 1,000,000+ 1,100,000+ Number of records* 1,000,000+ 1,100,000+ Number of files* 1,000,000+ 1,100,000+ Number of inmates received annually at MCI 8,500 — 9,500 11,000 —12,000 Number of beds at MCI 330 330 • Maximum sentence at MCI 6 months 6 months v..1.:t.:4 • \1..1..- J:rA111u1• J• • V1Y111\.J Gartner Consulting Entire contents C 2401 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 21 Gartner Engagement 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems IL Bankground and System Overview City of Kansas City Police Department ()Mee of Boa ref of Citizen P olicc Complaint, Cornrnissioners'' Vtunicirsal (naurf liaFcpn' Itt1 ; rtmCnl Sarc4".1. Uflicrr c)f POI ice , Pei%ate tNiiI:kers% t _icr�lsin� Scciinu I"_i�'�CCtFtE' iert-ti l`S BBltf c:Itt .1[1mi rliSr r.9t lf)F1 More•. Patrol ll tw s: Exhibit 2. KCF D Organization Chart tlttsti Hu 0.: Lions au Gartner Consulting Entire contents ® 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 22 Gartner Engagement 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems II. Background and System Overview City of Kai;,;:... tiny Fire Department rent Storeroom Manama -936 Cathy AMhre Ptaelnaslnra - 935 Jp Raga* Director! Fin Chid -100 Richard "Smoker' Dyer prknciaal Asa, to Director - 910 Richard Got Maishi it to Dhow 120 limner Resources Pet Rdwnhkhfer hhsalth p� Advaea- 621 Charlene Wright aa1Ro6 Man66er - 131 Theresa Fultz Storeroom Clerk - 937 BM 5min r— Payroll ChM 932 - Janette Davis 133 - Bridget Drew Assistant to Director - ace Fiance Leslie Ingram -Wright Ezscutive Secratary -118q Michelle Herdlm en Admidslrativa Atet. - 891 Leigh Stelgler-Mack Deputy Chid - 200 Community Ser Ices Bureau Jett Grote Mahlon Fie Marshal Cris Bosch Deputy choir -400 Technical Services Bursar Brad Hunaton Doody ChM -100 Professions' Development Bureau Peel Berardi $0psririleridsed -401 GonerwniaHcne Chuck 2adg Division Chief - 601 Trainhrg Pal Rhea CAM -10, Deputy Chief - 10113 r ta1 t C Dandy Chief goo Emergen y Operations Brae.. John Gernawn I Emergency Opsn6gn Buroau Psi Gilchrist Operations Bunsen EalerpeneY 'ps Ed i yaix1Woefer - i n Special Operations Bureau Domenic Sermons Ass, Fin Marshal -21Q Jun Duddy Fire k irsidloator 212 - Gary Dun 21S Graven -George 214 - Kevin Beck 215 -Tom kievlan ire ti l 220-233 Flee Educidar 250 - Dougg Joree 251 -Jerry Windsor ArknisistrativeAae!-201 Don Stain AdminkihetM Anar. - 293 Tricia Estrada Adm}riepmkM Assn - 293 Jan Paradigm Chief Olepate}nar 410 - Larry Gomnb 420-PMWWI 430 - Bob Mtltiddy 440 - Dina Ruch Ad iniekraivs Awl. - 491 May Medici Egedomatl Officer- 46Q Donee Maze Instructor 511 -Carolyn Michell 612 - David Hughes 613 - Mike Jordan 814 - Dwsyne Frankton 615 - Gwrtd Swofford 616 - Kenny Samuels 617 - James Dean Administrative Past - 691 Roberta Schley 1 Fleet Mallitenance -461 Tom Frank SCBA Technician - iq Randy Barttmloms Fedmnsrt Supper! -Mt) Pate Omani* illvlelev CSlef - 202 Public ReIBane Gsmoine Friends Asset MMnwr -470 Mire Moon I lamination Technology -480 Rick Wright Dlvblan Chief - Pio0ramDevelopmerd Battalion chiefs 42 - George Brennen 103 - Jim Abraham 104- Bill Gronluno 19S - Ed Colin 106 - Gary Birch 107 - John Hooky 106 -Phi Pitman Battalion Chiefs 102 - Geer Shepherd 103 - Mike Morrow 104 - John Bruno 105 - Floyd Dupree 106 - Mike Bracken 107 - Kevin Cochran 109 - Floyd Peoples Exhibit 3. KCFU erganization Chart the Nun Chiefs 102 - Tammy Walker 103 - M tee Pusateri f04 - Maak Felder 105 - ht stay Kim 106- B1 Hillis 107 - S. ors Atkin 106-Mks Eller Division Chid -301 Rererdous Materials Frank Talton* Hazwt Specialist - 310 Tom Setter Haute! Training' - 311 Bob Hicks Administrative Asst. - 391 Debra Miner Division ChM - 302 Airport Rescue Fine Fighting Anne Wedge ARFF Training' - 320 Mace Rowe Division Chief - 303 Emergency Medical Services Ed Pfeifer Administrative Asst. - 393 Sharon Haman IAMBS Training' - 350 Mike Booth Gartner Consulting Entire contents ® 2001 Gartner, Inc. . For internal use of City of Kansas City only. December 2001—Page 23 Gartner Engagement: 220009530 Server Operating System: City of Kansas City Request for Proposal for Public Safety Information Systems I1. Background and System Overview City of Kansas City Current Technology Preferences Database Management System: Server Hardware Architecture: Windows 2000 UNIX Oracle (preferred) IBM DB2 SQL Intel RISC Exhibit 4. Current Technology Preferences Gartner Consulting Enti►e contents C 2001 Gartner, Inc.' For internal use of City of Kansas City only. December 2001—Page 24 Gartner Engagement: 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems II. Background and System Overview Current Systems Residing on Mainframe Computer and Maintained by Kansas City Computer Services Unit Staff System Description Recommended Approach Alarm System Maintains a file of all alarm permits issued with any associated alarm dispatch incidents. Produces reports and provides permit information including numbers of false alarms and possible "no response Arrest System Provide replacement system as part of integrated solution or interface to existing custom Records arrest information by individual arrests for statistical and historical purposes. Basic Police System Provide arrest module in new integrated solution. Interface to existing ALERT system. Consists of the inquiries used to access criminal justice information and to enter, modify or cancel this data. Access to ALERT records can be made through name, address, vehicle license, social security number, case report number, or alert number inquiries. The responses to these inquiries may include warrant and pickup information, arrest records, stolen vehicles and licenses, descriptions of persons in the system including fingerprint classifications, offense information, ticket information, probation and parole, corrections information, and other data compiled in the course of investigation of crimes. Depending on the type of inquiry made, the terminal used, and the purpose of the inquiry, the response is tailored to return only the information pertinent to that request. This a very active system with a considerable amount of programming time required to handle new classifications of data, requests for new formats, special security considerations, and provisions to be made for new terminals and agencies. Message Routing Process: The ALERT system maintains a computer -controlled message switching network. All of the terminals on the ALERT system and the terminals on the State Highway Patrol Systems of Missouri and Kansas may exchange free form criminal justice related information and "pick-up" type messages by using the transaction code "MR" followed by a destination code, usually a terminal name. One of the features of this system is the ability to send a broadcast to a group of terminals or agencies by using group codes instead of a terminal name. For example, the "PU-R" group code will send the message to all agencies in the region. Message switching outside the ALERT system is handled in this program by providing access to NLETS. Interface to existing ALERT system. Gartner Consulting Entire contents © 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 25 Gartner Engagement: 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems II. Background and System Overview System Description Basic Police Data Validation: There are approximately eighty batch type programs that produce listings or tapes to be used in the validation of Basic Police data. These include listings of warrants and pickups, expired licenses, free format information, duplicate names and addresses, stolen autos, jacket information, criminal specialties, and penitentiary releases. There are also programs that process log -tape data and produce statistical listings. Transaction counts by terminal, activity by agency, and totals by transaction types are some of the types of information included. Recommended Approach Case Report Number (CRN) System Provides for the issuance and accountability of Case Report Numbers (CRN) as well as the logging of basic report information. Replace with new RMS. Census System Maintains a current and accurate file of all actual and intersection addresses in the city. This file includes all information required for an automated geocoding of census tract and block information as well as patrol reporting areas. Records entered into the ALERT databases are automatically coded with census tract/block and reporting area utilizing information contained in this system. Replace with new RMS. • . Civil Index System Provides an index to miscellaneous reports including: field interview forms, accidents occurring on private property, accidents occurring outside city limits, or accidents occurring at an unknown location. Replace with new RMS. Criminalistics Lab System Contains analysis requests, lab pages, and reports of findings, time accounting and billing information. This system includes the preparation of invoices for crime lab work completed for outside agencies. Replace with new RMS or interface to existing system Computer Aided Dispatch Records 9-1-1 call information and car/officer availability to facilitate the assignment and tracking of responses to calls for service. Replace with new CAD Dispatch Information System Allows the analysis of call -for -service workload as well as the self -initiated and administrative workload of patrol officers. Replace with new CAD DRAGNET System Collects information on suspected drug houses and enforcement techniques used on specific targets. Replace with new RMS. Felony Tracking System Tracks all felony offenses and the associated arrest dispositions by individual for the recording of statistical and historical data. An automated interface exists between the Circuit Court and the Police Department's data files. Interface to ALERT File Locator System Consists of a tracking system for use by Perpetrator Information Center and Narcotics and Vice Division personnel to maintain basic data on known offenders. Replace with new RMS. GATOR System Collects information from gangs, their members and Replace with new RMS. Gartner Consulting Entire contents C 2001 Gartner, Ind' For internal use of City of Kansas City only. December 2001—Page 26 Gartner Engagement: 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems II. Background and System Overview System Description Recommended Approach associates, locations and report numbers containing additional information. Jail System To facilitate the handling of inmates of MCI, the ALERT system has developed a jail system that utilizes on-line transactions and also provides a variety of listings. Entries are made in the computer based on booking including name and physical profile, ;ail ! VIa ♦ion . movement or release UdLC'. and descriptions of movements. Replace with new RMS. Municipal Court Docket System Contains data needed to print the Court Dockets and Officer Court Notifications. Interface to ALERT Offense Reporting System Records names of victims as well as statistical and historical information in the data files about each incident reported to the police. The system also produces all required reports for participation in the UCR system. Replace with new RMS. Probation and Parole System 1._____ • There are currently some agencies that maintain Probation and Parole information in the ALERT system. Automatic notification is provided to entering agencies of "hits" on their subjects. There are monthly listings used to validate Probation and Parole data and to provide automatic cancellation of expired records. Interface with new RMS. Recovered Property System Collects information on property recovered for safe keeping or as evidence. The system tracks dates and storage locations as well as custody exchanges and destruction of property. Replace with new RMS. 1 Traffic Ticket System Records the name of traffic violators as well as statistical and historical data about each incident. Replace with new RMS. Training Records System Collects information on all training provided to Police Department personnel. P.O.S.T. certified courses are flagged to provide necessary documentation required by the State. (Replace) Replace with new RMS. Vehicular Accident System Includes details of each vehicle accident record. Statistical and historical information are provided to the Traffic Division for enforcement purposes. Replace with new RMS. Warrant System Produces traffic reminder notices and traffic warrants when traffic citations are not paid within a prescribed number of days. Replace with new RMS. Exhibit 5. Current Kansas City Systems Gartner Consulting • Entire contents C 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 27 Gartner City of Kansas City Engagement: 220009530 Request for Proposal for Public Safety Information Systems II. Background and System Overview KCPD S/390 . LINE PRINTER r #_ 1 TAPE Token ring Getaway '..'R LAN Ericiaon j Radio System Kansas City Police Department REMOTE LINT CONTROLLER c FIBER RAID DISK L. KCMO S1390 TT,_ CN 44 UNT-l�l 1-1 CAD WORK \ STATIONS CORE ROUTER ti/. / KCPD WAN / KCPD REMOTE SITES REMOTE LINE CONTROLLER ALERT AGENCIES NCIC MULES NLTS �KDOR KANSAS NC:IC; NLTS MOOR KCPD STATIONS (CONVERTING TO IP WAN) ENA 8 SYSYNC NETWORK COAX ATTACHED TERMINALS a PRINTERS MUNICIPAL COURT TERMINALS ETHERNET FIBER BACKBONE FIREWALL 1 SBIS J Exhibit 6. Current System Architecture WORkSTATINS AND SERVERS Gartner Consulting Entire contents © 2001 Gartner, Inc.. For internal use of City of Kansas City only. December 2001—Page 28 Gartner City of Kansas City Engagement: 220009530 Request for Proposal for Public Safety Information Systems II. Background and System Overview Kansas City Fire Department The Kansas City Fire Department currently maintains a client -server system connecting all fire stations within the city limits. The system includes the following features: • Citrix Metaframe OS and licenses for 15 users and 20 additional user pack • Microsoft Office 97 license for 50 concurrent users • IBM license for 500 users for PCOMM (3270 emulation) • 50 Wyse Windows terminals A 50 HP Laserjet 2100 printers • 3 Intergraph servers located at ITD • Lotus Notes for 850 users a ISDN for approximately 40 field locations IS-Termsry Citrix Metaframe Local Print Queues Office 97, 3270 Emulation, Lotus notes Lotu3 I totes FR-Notes Lotus Notes Server Alarm Print Queues Core Router sklarm Print Queues Alarm Print ISDN Fire Statiup 1 - Cisco Router Exhibit 7. Current System Architecture Wyse Windows 'Terminal; . HP Laser Primer Telephone Fire Station 3 - Cisco Router Wyse Windows Terminal HP Laser Printer Telephone Fire Station 4 - Cisco Router Wyse Windows Terminal HP Laser Printer ii'urtry;kiion 106 6 C FAX Fire Station B - Cisco Router Wyse Windows Terminal' HP Laser Printer EiHtt iliac, ^ OF!'=i; FAX Fire Station Conrip - 26 Battalion Station Conrig • 7 Gartner Consulting Entire contents © 2001 Gartner, Inc. For Internal use of City of Kansas City only. December 2001—Page 29 Gartner City of Kansas City Engagement: 220009530 Request for Proposal for Public Safety Information Systems II. Background and System Overview T-1 T_ 5 Frame Relay, ■ R = Cisco 2503 ATM/DS3 20 MB Cell R -Cisco 804 Kansas City Police Department Data T-I Frame Relay/Cell Relay ■ 1 Tj \ 128K 12! PRI 1111 LoalW'<';'; 1 Cisco Rc dui "cl 7206 }12°X 1 .`OV .- .__.. • 64K 64K AP 64K 410 Privala Fiber {already in Exhibit 8. Data Network Gartner Consulting Entire contents ® 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 30 Gartner Engagement 220009530 PCs and Laptops GIS Mugshot System City of Kansas City "Request for Proposal for Public Safety Information Systems !I. Background and System Overview Proposed S) stems Ai eititcctur•e iJLETS MULES NCiC • O Q MDOR �KCJIS ALERTS (Mainframe) N. \\ KCMO.org KIVA Imaging System Message Switch Fire Substations Police Substations CAD Server(s) Police RMS Fire RMS Server(s) Server(s) ti City LAN Exhibit 9. Proposed Sysiem Architecture Gartner Consulting Entire contents C 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 31 Gartner Engagement: 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems III. Functional Requirements Overview and General Requirements III. Functional Requirements Overview and General Requirements .,.32 A. Glossary of Terms and Abbreviations 34 B. General Requirements 36 C. Usability 40 D. Security • 43 E. Reports and Queries 47 F. On -Line Help and Documentation 51 i 19ra r'nrs% re. • �M4 VVI If VI VIVI1 �� H. GIS Integration 55 Gartner Consulting Entire contents ® 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page i Gartner Engagement: 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems III. Functional Requirements Overview and General Requirements Ill. Functional Requirements Overview and General Requirements Gartner Consulting • Entire contents © 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 32 Gartner Engagement:220009530 City of Kansas City Request for Proposal for Public Safety Information Systems III. Functional Requirements Overview and General Requirements RESPONSE INSTRUCTIONS AND CODES The Functional Requirements sections of the RFP contain the detailed application requirements for the systems desired by the City. In responding to the requirements regarding functions, features, and reporting capabilities, the codes indicated below must be used wherever a bracket [ ] is located. Response Codes Definitions E — Existing Requirement will be met by proposed existing software that is installed and operational at other sites and can be demonstrated to the City. The cost of requirements receiving this Response Code is included in the cost of the base software. U — Under Development Requirement will be met by package software that is currently under development, in Beta test, or not yet released. The cost of requirements Under Development are included in the base software. M — Minor Modification Requirement will be met by proposed minor modifications to existing software or use of software tools such as application report writer, query, etc. This work shall be performed by the vendor, and additional costs, if any, shall be noted as described below. C — Major Customization Requirement will be met by major modifications to existing software or by new custom software programming. All work shall be performed by the vendor and additional costs, if any, shall be noted as described below. R — Report Writer Requirement could be met by the use of software tools, such as a report writer, query language or spreadsheet package. Work shall be performed by the City at the City's expense. X — Not Available Requirement cannot be provided. An explanation is to be included under Exceptions in the Vendor Response section. Notes: 1. An omitted response will be assumed to be the same as a response code of X [Not Available]. 2. Any deviation from the response codes will be deemed non -compliant. 3. Costs associated with each M and C response should be clearly shown in the margin to the right of the [ ]. 4. All costs associated with each M and C response must be included in the Cost Section. S. Where description or narrative is requested, vendors should specifically reference the narrative within vendor's proposal. Gartner Consulting Entire contents C 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 33 Gartner Engagement:220009530 City of Kansas City Request for Proposal for Public Safety Information Systems III. Functional Requirements Overview and General Requirements A. Glossary of Terms and Abbreviations The following is a list of some of the terminology that has a specific meaning in the context of this RFP: Calls for service Any incoming call, regardless of whether or not a dispatch was made Incidents Any call for service that resulted in a dispatch The following is a list of the abbreviations used in this document. AFR Automated Field Reporting AFRS Automated Field Reporting System ALS Advanced Life Support APR Annual Percentage Rate APN Assessor Parcel Number AVL Automatic Vehicle Location ASCII American Standard Code for Information Exchange BLS Basic Life Support BOLO Be on the lookout CAD Computer Aided Dispatch CAS Chemical Abstract Services CJIS Criminal Justice Information System COKC City of Kansas City COTS Custom off the shelf (software) DOT Department of Transportation DTMF Dual -Tone Multi -frequency EMS Emergency Medical Services MAC Missouri Administrative Code MULES Missouri Law Enforcement System FPC Fire Prevention Code FIR Field Incident Reporting FTP File Transfer Protocol GIS Geographic Information System GPS Global Positioning System GUI Graphical User Interface HAZMAT Hazardous Materials HMI Hazardous Materials Incident HTML Hypertext Markup Language MDC Mobile Data Computer NCIC National Crime Information Center NFIRS National Fire Incident Reporting System NFPA National Fire Protection Agency NFPAC National Fire Protection Association Code ODBC Open Database Connectivity Gartner Consulting Entire contents C 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 34 Gartner City of Kansas City Engagement: 220009530 Request for Proposal for Public Safety Information Systems III. Functional Requirements Overview and General Requirements PCMCIA Personal Computer Memory Card International Association PTT-ID Push to Talk ID RD-LAP Radio Data Link Access Protocol (Motorola technology) RMS Records Management System SCBA Self -Contained Breathing Apparatus SHOCAP Serious Habitual Offender Comprehensive Action Program SMT Scars, Marks and Tattoos SMTP Simple Mail Transfer Protocol TDD T eiecommunications Device tor the Deaf KCFD Kansas City Fire Department KCPD Kansas City Police Department TPW Trespass Warnings UCR Uniform Crime Reporting UCS Name of the currently used automated field reporting package VAMI Vehicle Additional Maintenance Item VIN Vehicle Identification Number XML Extensible Markup Language XTML Extensible Text Markup Language Gartner Consulting Entire contents ® 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 35 Gartner Engagement: 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems III. Functional Requirements Overview and General Requirements B. General Requirements 1. Introduction This section includes general requirements that apply to all proposed applications. Responses will be assumed to apply to each proposed application unless otherwise noted. 2. General Requirements a. All system components (CAD, RMS, MDC, etc.) should be seamlessly integrated to allow for ease of data entry and retrieval b. Ability to perform any system tasks from any authorized workstation c. Ability to print to any printer within the authorized network from any application d. Ability to print in landscape or portrait mode, as appropriate e. Ability to print in Large format or custom page sizes f. Ability to identify (e.g., highlight in a different color) required entry fields g. Ability to enter unlimited narrative (both incident and non -incident) with text wrap -around feature h. Ability to display all dates in MMDDYYYY format i. All date and time stamps must be system generated. j. Ability to enter an override date/time. All override date and time stamps must be clearly recorded and displayed as a manually entered override time. k. Ability to log and display all times in HH:MM:SS format (24 hour clock) 1. Ability to retain deleted table information with the capability to perform an archive and final purge m. Ability to establish and modify purge criteria Response E ] [ ] Gartner Consulting Entire contents ® 2001 Gartner, Inc, For internal use of City of Kansas City only. December 2001—Page 36 Gartner Engagement: 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems Ill. Functional Requirements Overview and General Requirements Response n. System administrator capability to selectively edit and purge information (e.g., premise information, etc.): (1) Purge single record (2) Purge group/all records (3) Purge all except specific records (T) AN.CE43011 pargcd (5) Date edited or purged o. Ability to generate hard copy listing of purged data p. Ability for system administrator to create new data elements to display data in different formats q. Ability for system administrator to create new data elements extracting only certain portions of data from another data element r. Ability for system administrator to create or change the way data is entered or displayed on screens and reports s. Ability for system administrator to use logic within entry screens and reports t. Ability to selectively print information (e.g., incident history, premise information, search results, etc.): (1) Print single record (2) Print group/all records (3) Print all except specific records u. Ability to have a multi jurisdictional agency capability for both CADIRMS systems for Police and Fire v. Ability for system administrator to create conditional fields/mandatory data elements based on user defined criteria w. Ability to add, change or modify data elements on any screen 3. Performance and Redundancy Note: Vendor must note any exceptions to the following functional Performance and Redundancy Requirements Gartner Consulting Entire contents © 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 37 Gartner Engagement: 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems ill. Functional Requirements Overview and General Requirements a. Ability to perform all administrative functions while the system is operational. Note: Vendor must specify any function that requires system downtime to complete. b Ability complete all administrative tune+ ( .+. te complete all KL1111111J�14�� Vf.. iuu�.vua ,..e. iGilUl l gCi mtilun, database maintenance) without causing system degradation (e.g., slowdown of system response times) c. Ability to support the execution of all system queries, excluding remote database inquiries (Le. MULES), in less than two seconds, 98% of the time. Note: Response time is measured from the time the transaction is initiated by the user, to the time the result is apparent to the user. Note: Vendor must indicate the maximum number of users the proposed system will support and meet the defined system performance criteria. d. Ability to support the maintenance of detailed incident and unit data online for seven (7) years e. Ability to archive data to off-line or near -line media at periodic intervals f. Ability to restore archive data for online access g. Ability to determine last known unit and incident status in the event of a catastrophic system failure. (e.g., remote external logging device or similar solution) h. in an attachment, please describe your solution. i. Ability to support continuous operation in the event of a single component failure, without user intervention j. Ability to support continuous data integrity in the event of a component or system failure. In the event of a component or system failure, no data shall be lost or corrupted Response [ ] 1 3 Gartner Consulting Entire contents ® 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 38 ' Gartner City of Kansas City Engagement: 220009530 Request for Proposal for Public Safety Information Systems III. Functional Requirements Overview and General Requirements k. Ability to enter incident information that was recorded manually during times that the system was unavailable 1. Ability to reset incident/case numbers to accommodate manual entry m. Ability to retroactively enter an incident if the system is down Response 1 Gartner Consulting Entire contents ® 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 39 Gartner Engagement: 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems III. Functional Requirements Overview and General Requirements C. Usability 1. Introduction This section includes functional requirements that apply to all proposed applications. Responses will be assumed to apply to each proposed application unless otherwise noted. 2. Usability Requirements a. Ability to easily navigate all data entry screens using either the keyboard (tab, function keys, accelerator keys, paging and scrolling) or mouse (point and click) b. Ability to use drag and drop, and point -and -click (pull -down menus) devices to invoke a function (e.g., dispatch units) e. Ability to perform all commands and system functions using either the keyboard (command line) or mouse (graphical user interface) d. Ability for all data to be entered in a non -case sensitive format Ability for data elements to he validated against valid entry values and a resultant error message displayed I. Ability to store data in a consistent format, regardless of the case in which it is entered g. Ability to move forward and backward to complete data fields without having to retype the entire field (e.g., insert and delete) h. Ability to type ahead prior to a screen appearing i. Provide consistent, common screen formats system -wide which display the following: (1) Current system date and time (2) Screen name/description (3) System name/description (4) Current screen number and total number of screens (e.g., page 1 of 3) (5) User ID Response [ Gartner Consulting Entire contents ® 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 40 Gartner City of Kansas City Engagement; 220009530 Request for Proposal for Public Safety Information Systems III. Functional Requirements Overview and General Requirements j. Ability to selectively import/export data to a PC workstation using a menu selection, function key, or command k. Minimize the number of screens used for data entry l.. Display system messages on a pop-up window, if desired m. Ability to accelerate routine data entry tasks with drop -down lists, auto- fill/auto-search and/or keyboard macros n. Ability to advise operator of data entry or command errors with clear and concise messages that include a suggested remedy o. Ability to select and edit data in text fields without having to reenter all of the data in the field p. Ability to cut and paste data between fields and across applications Ability to toggle or hot key to any screen, table or application Ability to automatically "save" and "log -off' via a liot button. or ''unction key or icon (tool bar) s. Ability to perform functions with minimal keystrokes Ability to advise user of possible spelling error with ability to select corrections and/or add to dictionary u. Provide standardized format for data elements (e.g., hair, color, race, cities, abbreviations) v. Ability to provide the user with feedback as to the success or failure of the users action w. Ability for users to configure their own workstation environment (e.g., sort status monitors) x. Ability to maximize the use of colors, reverse video, and audible tones to help users process information y. Ability to allow users to create custom entry screens z. Ability to enter associated persons information as follows: Response [ [' 7 [ ] [ ] [ 1 [ ] 1 l' [ . 1 .l [ [ ]�• [ [ Gartner Consulting Entire contents ® 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 41 Gartner Engagement: 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems Functional Requirements Overview and General Requirements Response (1) Address [ (2) Home Phone [ l (3) Business Phone with extension [ ] (4) Cell Phone [. ] (5) Pager [ ] aa. Date 4A Birth yCai iilu3t t t udb a RAM digit year; bb. Ability for user to define function keys [ ] cc. Ability to have split screen capability [ ] Gartner Consulting Entire contents ® 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 42 Gartner City of Kansas City Engagement: 220009530 Request for Proposal for Public Safety Information Systems III. Functional Requirements Overview and General Requirements D. Security 1. Introduction This section includes security and user profile requirements for all applications, including mobile data applications run on mobile data devices. Response 2. Security Requirements General Security a. Provide user security at the following levels: (1) Application/subsystem (2) Screen/transaction (3) Record (4) Field b. Ability to assign security access by either user ID or physical device (e.g.., PCs, terminals, etc.) or group of users (e.g., by shift, beat, etc.) Ability to define what information will display on screen by security level cl. Ability to limit by individual user the ability to print specific information e. Ability to prevent any external agency from having access to update, alter or delete data f. Ability to "hide" information from displaying (e.g., juvenile -related information, EMS reports). Information to hide should be user -defined. g. Ability to display any announcement (security or other) on the banner screen prior to login h. Ability to restrict user access or group access to files and data fields for specified transactions: (1) Inquiry (2) Add/create (3) Modify (4) Delete Gartner Consulting Entire contents © 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 43 Gartner Engagement: 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems III. Functional Requirements Overview and General Requirements (5) Print i. Ability to flag a data element as confidential information for security purposes Ability to highlight, flag, or otherwise alert users with the appropriate sccurit 4LLCS.1 ti ai a r'rcnrd f_r flat. PIPment is confidential information _ .a..wa information k. Ability to alert users without appropriate security access of "record not on file" when searching for a confidential item 1. Ability to alert users to seal an item if user -defined file parameters (Le., for sealing) are met m. Ability to note sealed items as "confidential" when included in a print n. Ability to sort sealed hems at the beginning/end when included in a ;ardcopy printout o. • Ability to approve -a record Ability to automatically lock a record after it has been approved .41...Ability to automatically log -off workstation after period of inactivity, definable by user or workstation r. Ability to disable automatic log -off for secured workstations (e.g., dispatch center) s. Ability to provide system generated warning message prior to disabling device or user, and extend or reset automatic sign -off timer t. Ability for supervisors to "sign -off" remote workstations and Mobile Data Computers u. Ability to display date and time of last session when user signs -on v. Ability to provide system generated message to system administrator or supervisor when a pre-set number of unsuccessful sign -on attempts have occurred. The message must include, at a minimum: (1) Workstation ID (2) Date and time Response ] [ ] C Gartner Consulting Entire contents © 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 44 Gartner Engagement: 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems III. Functional Requirements Overview and General Requirements (3) User ID and password attempted w. Ability to create security groups that contain users that share the same security profile x. Ability to define the number of allowed simultaneous user sign -on y. Ability to globally restrict access to operating system IDs and Passwords z. Ability to support a single user logon ID and password across the CAD, RMS and Mobile Data Computing systems. aa. Ability to prevent display, viewing and printing of passwords bb. Ability to maintain a history of de -activated user ids and prevent using de -activated user ids when adding new users Sign -on and sign -off procedure with passwords to control workstation use: (1) Password size shall he minimum 8 characters (2) Password should contain alpha, numeric and special (i.e., $, *, etc.) characters (3) Ability for individual system users to change their own password (4) Ability to prevent reuse of previous two passwords (5) Ability to require the user to change individual password at sign -on (6) Ability for the systems administrator to reset password. dd. Ability for users' security access to .be modified by a system administrator ee. Ability for all passwords to be changed at agency -defined intervals, by user, with the ability to set a global maximum time ff. Ability to mask passwords when typed and encrypt passwords when stored and sent User Profile gg. Ability to maintain user profiles, including: (1) User ID Response [ 1 [ 1 [ [ ]. [ [ 1 [ 1 Gartner Consulting Entire contents ® 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 45 Gartner Engagement: 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems III. Functional Requirements Overview and General Requirements (2) User name (3) Title/Role (e.g., Chief) (4) Location (5) Default printer location/address (6) Phone number or extension (7) Date of last update and User ID that performed the update hh. Auditing and Logs ii. Ability to log date, time and user ID associated with: (1) File maintenance transactions (e.g., create, read, add, update, delete transactions) (2) Transaction entries (3) Incident history (4) Unit history (5) Reason for any change or delete ;'6) Any report sent to a printer ,7) Override {8) Reason printed '9) Unsuccessful sign -on attempts )j. =vlaintain the following user security information and audit trail: (1) User ID (2) User name (3) Security level (4) Reason any information was deleted (5) Reason any information was changed or updated (6) Last inquiry, update or delete -date, time, user initials, transactions kk. Ability to track user sign-on/off times for time reporting purposes Response [ 1 [ 1 [ 1 1 [ 1 [. 1 [ 1 Gartner Consulting • Entire contents C 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 46 Gartner City of Kansas City Engagement: 220009530 Request for Proposal for Public Safety Information Systems ill. Functional Requirements Overview and General Requirements E. Reports and Queries 1. Introduction This section includes report, query and data mining requirements that apply to all applications. 2. Report and Query Requirements a. Ability to provide a consistent reporting and query tool in CAD/RMS b. Ability to perform all queries from desktop PCs and MDCs c. Ability to query on any data field d. Ability to query on free form text fields, such as freeform notes fields Ability to represent statistical data in graphical format 1. Provide name search capability via: (1) Wild cards (2) Soundex (first and last name) (3) Phonetically (4) Nicknames and monikers (5) Social Security Number (i) Full (ii) Partial (6) Date of birth (7) Age range (e.g., 20-25 years) (8) Any field or combination of fields (9) System number (Internal system generated tracking number) (10) Scars, Marks, and Tattoos (SMTs) (11) Driver's License Number g. Provide address search capability via: (1) Wild cards (2) Soundex (3) PhoneticaIly (4) Zip code (5) Any field or combination Response [ ] ] [ ] [ ] [ ] Gartner Consulting Entire contents ® 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 47 Gartner Engagement: 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems III. Functional Requirements Overview and General Requirements h. Ability to perform a string search on any narrative text i. Searches should not be case (upper/lower) sensitive j. Provide soundex and phonetical search capabilities on user -defined criteria (e.g., name, alias, address, etc.) k. Ability to schedule and automatically generate daily, weekly, monthly, annually, and user -defined date range reports based on the pre- determined scheduled, and based on request �. 'Ability to print all tables and screens (long and short versions) by ranges m. Ability to track and print the number of reports an operator has entered, changed, deleted or approved for a given time period :I. Ability to selectively edit and/or print information (1) Print single record (2) Print group/all records (3) Print all except specific records o. Ability to import/export data to an off -the -shelf spreadsheet and/ or word processing program (e.g., Excel, Word, as appropriate) p. Ability to retrieve data in one report from all directories and tables q. Ability to query from all dictionaries and tables in one query r. Capability when printing reports to: (1) Determine length of report prior to printing (e.g., number of pages) (2) Queue reports for later printing (3) Select printer (4) Specify number of copies (5) Specify page ranges and multiple pages (6) Specify portrait or landscape mode, where appropriate (7) Cancel report print jobs (8) Reason printed s. Ability to print selected reports with user -defined fields "masked" (This will eliminate the need for personnel to manually "white out" these Response [ 1 [ 1 [ 1 [ 1 [ 1 [ 1 Gartner Consulting Entire contents m 2001 Gartner, Inc. For Internal use of City of Kansas City only. December 2001—Page 48 Gartner Engagement' 220009530 City of Kansas City Request for Proposal for Public Safety Information Systems III, Functional Requirements Overview and General Requirements specified fields) t. Ability to send reports to screen (on-line viewing) u. Ability to electronically send/receive data, reports and/or supplements via e-mail v. Ability to electronically distribute all forms, notices, letters to interested parties; either via electronic mailing to other RMS-accessible parties or faxing to non-RMS accessible parties with faxing capabilities w. Ability to mail merge names and addresses into standard notices', letters and forms .x... Ability to print agency logos on reports and forms ;r. Provide tools to generate user -defined, customized screens, forms and .?ports 11/2.hility to import and export all data into each of the following formats: 14 ASCII MS Access MS Office Suite HTML a - XML XTML Report Generator Comma delineated flat file aa. Ability to create reports using relational criteria and logical operators (e.g., less than, greater than, equal to or less than and equal to, wild cards, Boolean operators, etc.) bb. Ability to create standard reports that can be made available to system users cc. Ability to define automatic generation of periodic reports: (1) By date (2) By day (3) Recurring every other day, week, etc. Response [ ]'• Gartner Consulting Entire contents © 2001 Gartner, Inc. For internal use of City of Kansas City only. December 2001—Page 49