Loading...
HomeMy WebLinkAboutINTERGRAPH PUBLIC SAFETY INC. - 2003-04-07V 2; s-k m JWOF HUNTINGTON BEACH* MEETING DATE: April 7, 2003 DEPARTMENT ID NUMBER:PD - 03-007 Council/Agency Meeting Held: o Deferred/Continued to: Approved ❑ Conditionally Approved ❑ Denied City Clerk's Signa re Council Meeting Date: _o_/ April 7, 2003 Department ID Number: PD - 03-007 CITY OF HUNTINGTON BEACH REQUEST FOR COUNCIL ACTION N =- SUBMITTED TO: HONORABLE MAYOR AND CITY COUNCIL MEMBERS �- SUBMITTED BY: Ray Silver, City Administrators Kenneth W. Small, Chief of Police PREPARED BY: Shari Freidenrich, City Treasur t1nco William P. Workman, Assistant City AdministratorSUBJECT: Approve the Contract with Intergraph Public Safety orated for a Police Computer Aided Dispatch 1 Records Management System (CADIRMS). Statement of Issue, Funding Source, Recommended Action, Alternative Action(a), Analysis, Environmental Status, Attachment(s) Statement of Issue: The Police Department was authorized by Council to replace and upgrade its Computer Aided Dispatch / Records Management System (CADIRMS) in ,tune 2001. Through a competitive bid process, Intergraph Public Safety, a CADIRMS provider, was tentatively selected. Prior to the actual purchase, the Department required that the vendor first provide a thorough Detail Design for its review and evaluation. This phase of the project is now complete after extensive document refinement and contract negotiations. The Police Department requests Council authorization to enter into contract with Integraph for the purchase of a CAD/RMS. Funding Source: Funding sources are budgeted in the following accounts: 1) $1,656,784 Union Bank Escrow Account # 2740013443 (Grant Funded) 2) 389,916 SLESF Grant 01102 acct. # 88870101 3) 386,647 SLESF Grant 02/03 acct. # 87070101 4) 7,918 LLEBG Grant 99100 acct. # 89670101 5) 61,652 LLEBG Grant 00/01 acct. # 89770101 6) 213,816 Holly/Seacliff Development Fees acct. # 30770101 $2,716,733 Total RCA-Intergraph.doc -2- 3/20/2003 3:57 PM REREST FOR COUNCIL ACTIOP MEETING DATE: April 7, 2003 DEPARTMENT ID NUMBER:PD - 03-007 Recommended Action: 1. Approve and authorize the Mayor and City Clerk to execute the contract with the City of Huntington Beach and Intergraph Public Safety, Inc., and; 2. Authorize the City Treasurer to release escrow funds from Union Bank payable to Intergraph Public Safety and authorize the Police Chief to approve the expenditure of the grant funds, and; 3. Assign the Police Department's Systems Group Manager as Project Manager and require signatures of both the Project Manager and the City's Information Services Director authorization to approve Acceptance Testing, Change Orders, Notifications, System Sign - off, release of funds and progress payments per contract schedule, and; 4. Authorize The Police Department's Systems Group Manager to upgrade Uninterruptible Power Supply in a joint project with the City's Information Systems Department and enter into a service agreement with Anderson & Howard Electric to redistribute electrical power in Communications, the Computer and EOC rooms and install additional emergency generator supply service; 5. Approve hiring a part-time, temporary GIS Intern not to exceed 1000 hrs. during the course of the project that will be funded within total project cost to provide data elements for mapping. Alternative Action(s): 1. Do not approve and authorize the Mayor and City Clerk to execute the contract with the City of Huntington Beach and Intergraph and direct staff accordingly. Analysis: By 1999, the Police Department's CADIRMS system had become obsolete. It was installed in 1988 and had exceeded its useful life. So in 1999, Council - approved the Police Department's request to replace and upgrade its system. Shortly thereafter, the Department was notified by its maintenance provider that they had discovered Y2K non-compliance problems. Due to its mission critical importance those problems had to be addressed, but it delayed system replacement for two years. Because two years had elapsed since Council originally approved the CADIRMS replacement, the Department chose to return to Council again to reaffirm its commitment to this project. On June 18, 2001, Council authorized the appropriation of funds for the replacement of the Police Department's CADIRMS System. The Police Department issued a Request for Proposal from CADIRMS vendors and received five responses. The Police Department, with the assistance of its consultant, selected the Intergraph Public Safety CADIRMS product. RCA-intergraph.doc -3- 3/26/2003 2:22 PM RESEST FOR COUNCIL ACTI09 MEETING DATE: April 7, 2003 DEPARTMENT ID NUMBER:PD - 03-007 Intergraph began Phase I of this project in March 2002 by preparing a Detail Design Specification. For ten months Police Department personnel worked very closely with Intergraph personnel to refine the design specifications to ensure that all requirements were fully included and recorded in writing. Final negotiations regarding pricing and specifications are complete. The Police Department is confident that Intergraph will provide a quality product that will meet all its needs. In May 2002, Council reviewed and approved an RCA to establish an escrow account for the SLESF funds due to spending deadline. Prior to fiscal year 2000-2001, the State had very liberal policies on the time frame allowed to expend SLESF grants. With the funding for fiscal year 2000-2001, the State instituted a two-year cap on the time frame to expend grants. The State also included any funds that municipalities had saved from previous Fiscal Years. In order to meet the spending deadline of June 30, 2002, the Police Department requested and received authorization by the SLESF Oversight Committee to place the accumulated SLESF funds into an escrow account for one additional year. The funds are currently in an escrow account with the City Treasurer authorized to release payment. The Police Department has been planning the purchase of a new CAD/RMS for several years. This project was partially delayed in order for the Police Department to accumulate the f unds to pay for the purchase. At this time, the Police Department has accumulated enough law enforcement grants to fully fund the project. Although the purchase price is expected to come in close to the price quoted, a $326,904 contingency has been added to the project to cover unanticipated costs. This project also includes upgrading the Uninterruptible Power Supply (UPS) and the red istributionlbalance of the electrical supply and emergency generator supply service throughout the Police Department and City Hall. The CADIRMS system will provide a technologically advanced system that will increase reliability and effectiveness for the Police Department. One of the features available with the new CADIRMS will be Field Reporting. This feature will allow officers to write reports in the field and transmit them to the station in a paperless process without leaving their assigned patrol areas. However, for Field Reporting to work the Mobile Data Computers in the vehicles will need to be replaced. Since this is a separate but related acquisition, the Department presents this project to Council in two phases. Phase I is represented by this RCA to replace the CAD/RMS. Phase II will be brought to Council at a later date for authorization to replace the Mobile Data Computers once system design has been completed. The estimated cost for the replacement of these mobile computers will be approximately $1,100,000 and will be paid from a combination of an existing public safety facility fund, technology grants and the McDonnell Douglas settlement fees. No general fund monies will be required for the either the CADIRMS or the Mobile Data Computer replacement projects. Expenditures for Phase I and preliminary budget figures for Phase II are identified under the Project Cost section of this RCA. RCA-Intergraph.doc -4- 3126/2003 2:22 PM RESEST FOR COUNCIL ACTIOP MEETING DATE: April 7, 2003 Criteria Used to Select Intergraph DEPARTMENT ID NUMBER:PD - 03-007 The Department received five responses to its RFP. Those were from: GEAC, Intergraph, PRC, Printrak and Tiburon. Vendors were asked to respond to a series of questions regarding their systems' functionality that was later used as part of the selection criteria. The areas of functionality that were evaluated included General System Design, Records Management, Computer Aided Dispatch, Incident Reporting, Case Management, Property & Evidence, Traffic, Alarm, Pawn, Personnel & Training and Crime Analysis. Using these responses and also considering system functionality, interface integration, operating system, cost and system migration capabilities, we with the assistance of our consultants RCC determined that Intergraph was the best choice by a unanimous decision of our team and our consultants. Benefits that will be gained from this replacement The Department's CADIRMS lacks many contemporary features. Replacement of this system will provide the following enhanced features that are not available in the current system. Automated Field Reporting Mapping Global Positioning System (if used) Mainstream Database Product (SQL) - More easily Interfaces with Existing and Emerging Technologies Jail Booking Interface allows for pre -booking in the field Automated Report Distribution and Workflow Routing for Case Management Crime Analysis and DOJ Reporting Upgrading from a Text Base Interface to an easier to use Windows appearing screen (GUI - Graphic User Interface) Improved Access to Database Information and Closely Integrated Modules System is Highly Configurable by the User Fire Module is an easily added feature Proiect Cost The following is a description of expenditures and a listing of funding sources for both Phase I, the CADIRMS and Phase II, the Mobile Data Computer projects. Phase I (Represented by this RCA) Expenditures Personnel Services Salaries (1) 0 OT $ 43,000 GIS Intern 15,000 Funding Sources Escrow Account SLESF 01102 SLESF 02103 $1,656,784 $ 389,916 $ 386,647 RCA-Intergraph.doc -5- 3/26/2003 2:22 PM RAREST FOR COUNCIL ACTIOP MEETING DATE: April 7, 2003 DEPARTMENT ID NUMBER:PD - 03-007 subtotal $ 58,000 Operating Expenses Equipment Supplies $ 83,182 Prof. Services (2) $1,159,765 Training $ 34,000 subtotal $1,276,947 Capital Expenditures Software $ 708,344 Hardware $ 232,197 Licenses $ 35,284 Taxes 79,057 subtotal $1,054,882 Contingency costs 326,904 Total Phase I Project Expenses $2,716,733 Phase 11 LLEBG 99100 $ 7,918 LLEBG 00101 $ 61,652 Holly/Seacliff DV $ 213,816 Total Phase I Funding $2,716,733 This phase will be brought to Council in mach greater detail in a separate RCA once system configuration has been finalized. Although these costs are preliminary, the Department is confident they represent accurate total projected expenses. Expenditures Personnel Services (1) $ 0 Operating Expenses Prof. Services S 74,500 Capital Expenditures Hardware $ 896,000 Contingency Costs $ 146,000 Total Phase II Project Expenses$1,116,500 Total for both proiects $ 3,833,233 Funding Sources Holly Seacliff DV $ 493,184 Settlement Fees $ 623,318 Total Phase II Funding $ 1,116,500 Required Funding $ 3,833,233 (1) No additional staff will be required for the installation or maintenance of either of these phases. (2) The greatest cost for Phase I is in Professional Services which represents 42% of the project costs. This includes staging, programming, installation, training, etc. Software costs for phase I represent 26% while Hardware represents 8% of total costs. The balance of costs are in Licenses, Taxes, Training, etc. which total 24% of project costs. RCA-Intergraph.doc -6- 3/2612003 2:22 PM REREST FOR COUNCIL ACTIOV MEETING DATE: April 7, 2003 Post Implementation Costs DEPARTMENT ID NUMBER:PD - 03-007 Maintenance costs will increase approximately $30,000 annually due to the additional number of modules and increased functionality. The Department will offset these costs from savings in radio maintenance in the first two years due to the replacement of the Mobile Data Computers. Major Milestone Project Schedule Contract Approval Implementation Plan Acceptance Test Plan for CAD Acceptance Test Plan for RMS Install CAD Install RMS Live CAD & Mobile Operation Acceptance Live RMS Acceptance Final System Acceptance Milestone Payment Schedule 0 Months 2 " 3 " 3 " 8 10 " 12 " 14 " 16 " • Fifteen percent (15%) of the total purchase price due upon contract signing. • Twenty percent (20%) of the total purchase price due upon purchase of hardware. • Twenty percent (20%) of the total purchase price due upon SYSTEM setup at the IPS staging site. • Five percent (5%) of total purchase price due upon delivery of IILEADS False Alarm module screen shots to Huntington Beach. • Fifteen percent (15%) of the total purchase price due upon notification by the City that the IICAD SYSTEM including custom IICAD interfaces has successfully passed the IICAD Acceptance Tests on the SYSTEM installed at Huntington Beach. • Five percent (5%) of the total purchase price due upon successful IICAD SYSTEM Cutover. • Five percent (5%) of the total purchase price due upon notification by the City that the IILEADS SYSTEM including custom IILEADS interfaces has successfully passed the IILEADS Acceptance Tests on the SYSTEM installed at Huntington Beach. • Five percent (5%) of the total purchase price due upon successful IILEADS SYSTEM Cutover. • Ten percent (10%) of the total purchase price due upon completion of the reliability period following IILEADS SYSTEM cutover. RCA-Intergraph.doc -7- 3/26/2003 2:22 PM RENEST FOR COUNCIL ACTIOP MEETING DATE: April 7, 2003 DEPARTMENT ID NUMBER:PD - 03-007 • Ten percent (10%) of the total purchase price due upon completion of the reliability. Environmental Status: NIA Attachment(s): RCA Author: Jim Moore RCA-Intergraph.doc -8- 3/26/2003 2:22 PM • ATTACHMENT #1 0 - 6 -- -'.� 1 1i CITY OF HUNTINGTON BEACH 2000 MAIN STREET CALIFORNIA 92648 OFFICE OF THE CITY CLERK CONNIE BROCKWAY CITY CLERK April 10, 2003 Contracts Manager Intergraph Public Safety, Inc. 241 Disk Drive Madison, AL 35758 Dear Mr. Coupland: The City Council of the City of Huntington Beach at the meeting held April 10, 2003, approved the Professional Service Contract between the City and Intergraph Public Safety, Inc. for .a Police Computer Aided Dispatch 1 Records Management System (CAD/RMS) Enclosed a duly executed copy of the Professional Contract Agreement for your records. Sincerely, Connie Brockway City Clerk Enclosure: Agreement G:followup:agnntltrJMHZ 800 1 Telephone: 714.536.5227 M • • PROFESSIONAL SERVICES CONTRACT BETWEEN THE CITY OF HUNTINGTON BEACH AND II`TERGRAPH PUBLIC SAFETY, INC. THIS AGREEMENT is made and entered into this 7th day of April 2003, by and between the City of Huntington Beach, a municipal corporation of the State of California, hereinafter referred to as "CITY," and Intergraph Public Safety, Inc., a Delaware corporation, hereinafter referred to as "CONSULTANT." WHEREAS, CITY desires to engage the services of a consultant to assist with the Design Phase of the CAD/RMS System; and Pursuant to documentation on file in the office of the City Clerk, the provisions of the Huntington Beach Municipal Code, Chapter 3.03, relating to procurement of professional service contracts have been complied with; and CONSULTANT has been selected to perform said services, NOW, THEREFORE, it is agreed by CITY and CONSULTANT as follows: WORK STATEMENT CONSULTANT shall provide all services as described in the mutually agreed upon Detailed Design Document dated January 7, 2003 which is hereinafter referred to as Exhibit "A", which is attached hereto and incorporated into this AGREEMENT by this reference. These services shall sometimes hereinafter be referred to as the "PROJECT." CONSULTANT hereby designates D. Fabacher who shall represent it and be its sole contact and agent in all consultations with CITY during the performance of this AGREEMENT. 2. CITY STAFF ASSISTANCE CITY shall assign a staff coordinator to work directly with CONSULTANT in the Performance of this AGREEMENT. 3. TIME OF PERFORMANCE Time is of the essence of this AGREEMENT. The services of CONSULTANT are to commence as soon as practicable after the execution of this AGREEMENT by CITY (the "Commencement Date"). All tasks specified in Exhibit "A" shall be completed no later than eighteen (18) months from the Commencement Date of this AGREEMENT. These times may be extended with the 0 0. written permission of CITY. The time for performance of the tasks identified in Exhibit "A" are generally to be shown in the Scope of Services on the Work Program/Project Schedule. This schedule may be amended to benefit the PROJECT if mutually agreed by CITY and CONSULTANT. 4. COMPENSATION In consideration of the performance of the services described herein, CITY agrees to pay CONSULTANT a fee not to exceed Two million one hundred thousand three hundred and seven dollars ($2,100,307.00) specified in Item VIII of Exhibit A. The CONSULTANT shall provide an escrow account as described in the mutually agreed upon Escrow Account Document which is hereinafter referred to as Exhibit `B", which is attached hereto and incorporated into this AGREEMENT by this reference. 5. PRIORITIES In the event there are any conflicts or inconsistencies between this AGREEMENT, the CITY's RFP, or the CONSULTANT's Proposal, the following order of precedence shall govern: 1) AGREEMENT including exhibits, 2) IPS Modification Requests Document 3) the CONSULTANT's Proposal, and 4) the CITY's RFP. 6. EXT WORK In the event CITY requires additional services not included in Exhibit "A," or changes in the scope of services described in Exhibit "A," CONSULTANT will undertake such work only after receiving written authorization from CITY. Additional compensation for such extra work shall be allowed only if the prior written approval of CITY is obtained. METHOD OF PAYMENT A. CONSULTANT shall he entitled to milestone payments toward the fixed fee set forth herein in accordance with the following payment schedules: • Fifteen percent (15%) of the total purchase price due upon contract signing. • Twenty percent (20%) of the total purchase price due upon purchase of hardware. • Twenty percent (20%) of the total purchase price due upon SYSTEM setup at the IPS staging site. • Five percent (5%) of total purchase price due upon delivery of I/LEADS False Alarm module screen shots to Huntington Beach. 2 • Fifteen percent (15%) of the total purchase price due upon notification by the City that the I/CAD SYSTEM including custom I/CAD interfaces has successfully passed the I/CAD Acceptance Tests on the SYSTEM installed at Huntington Beach. • Five percent (5%) of the total purchase price due upon successful I/CAD SYSTEM Cutover. • Five percent (5%) of the total purchase price due upon notification by the City that the I/LEADS SYSTEM including custom IILEADS interfaces has successfully passed the I/LEADS Acceptance Tests on the SYSTEM installed at Huntington Beach. • Five percent (5%) of the total purchase price due upon successful I/LEADS SYSTEM Cutover. • Ten percent (10%) of the total purchase price due upon completion of the reliability period following I/LEADS SYSTEM cutover. B. CONSULTANT shall submit to CITY an release of funds document ("Release") for each milestone payment due. Such Release shall: 1) Reference this AGREEMENT; 2) Describe the services performed; 3) Show the total amount of the payment due; 4) Include a certification by a principal member of CONSULTANT's firm that the work has been performed in accordance with the provisions of this AGREEMENT; and 5) For all payments include an estimate of the percentage of work completed. C. Upon submission of any such Release, if CITY is satisfied that CONSULTANT is making satisfactory progress toward completion of tasks in accordance with this AGREEMENT, CITY shall promptly approve the Release. , Such approval shall not be unreasonably withheld. If CITY does not approve the Release, CITY shall notify CONSULTANT in writing of the reasons for non -approval within seven (7) calendar days of receipt of the Release, and the schedule of performance set forth in Exhibit "A" shall be suspended until the parties agree that past performance by CONSULTANT is in, or has been brought into compliance or until this AGREEMENT is terminated as provided herein. D. Any billings for extra work or additional services authorized by CITY shall be invoiced separately to CITY. Such invoice shall contain all of the information required above, and in addition shall list the hours expended and hourly rate charged for such time. Such invoices shall be approved by CITY if the work performed is in accordance with the extra work or additional services requested, and if CITY is satisfied that the statement of hours worked and costs incurred is accurate. Such approval shall not be unreasonably withheld. Any dispute between the parties concerning payment of such an invoice shall be treated as separate and apart from the ongoing performance of the remainder of this AGREEMENT. 8. DISPOSITION OF PLANS ESTIMATES AND OTHER DOCUMENTS CONSULTANT agrees that all materials prepared hereunder, including all original drawings, designs, reports, both field and office notices, calculations, maps, memoranda, letters and other documents, shall be turned over to CITY upon termination of this AGREEMENT or upon PROJECT completion, whichever shall occur first. In the event this AGREEMENT is terminated, said materials may be used by CITY in the completion of the PROJECT or as it otherwise sees fit. Title to said materials shall pass to CITY upon payment of fees determined to be earned by CONSULTANT to the point of termination or completion of the PROJECT, whichever is applicable. CONSULTANT shall be entitled to retain copies of all data prepared hereunder. 9. HOLD HARMLESS CONSULTANT shall protect, defend, indemnify and hold harmless CITY, its officers, officials, employees, and agents from and against all injuries, death, loss, damages, claims, suits, judgments, expenses, costs (including without limitation, costs and fees of litigation of every nature) arising out of the Consultant's negligent acts, omissions, or willful misconduct in connection with performance of this AGREEMENT or its failure to comply with any of its obligations contained in this AGREEMENT except such loss or damage which was caused by the sole negligence or willful misconduct of CITY. to. WORKERS' COMPENSATION INSURANCE Pursuant to California Labor Code Section 1861, CONSULTANT acknowledges awareness of Section 3700 et seq. of said Code, which requires every employer to be insured against liability for workers' compensation; CONSULTANT covenants that it will comply with such provisions prior to commencing performance of the work hereunder. 4 CONSULTANT shall maintain workers' compensation insurance in an amount of not less than One Hundred Thousand Dollars (S100,000) bodily injury by accident, each occurrence, One Hundred Thousand Dollars ($100,000) bodily injury by disease, each employee, Two Hundred Fifty Thousand Dollars ($250,000) bodily injury by disease, policy limit. CONSULTANT shall require all subcontractors to provide such workers' compensation insurance for all of the subcontractors' employees. CONSULTANT shall furnish to CITY a certificate of waiver of subrogation under the terms of the workers' compensation insurance and CONSULTANT shall similarly require all subcontractors to waive subrogation. II. GENERAL LIABILITY INSURANCE In addition to the workers' compensation insurance and CONSULTANT's covenant to indemnify CITY, CONSULTANT shall obtain and furnish to CITY, a policy of general public liability insurance, including motor vehicle coverage covering the PROJECT. Said policy shall indemnify CONSULTANT, its officers, agents and employees, while acting within the scope of their duties, against any and all claims arising out of or in connection with the PROJECT, and shall provide coverage in not less than the following amount: combined single limit bodily injury and property damage, including products/completed operations liability and blanket contractual liability, of S 1,000,000 per occurrence. If coverage is provided under a form which includes a designated general aggregate limit, the aggregate limit must be no less than S 1,000,000 for this PROJECT. Said policy shall name CITY, its agents, its officers, employees and volunteers as Additional Insureds, and shall specifically provide that any other insurance coverage which may be applicable to the PROJECT shall be deemed excess coverage and that CONSULTANT's insurance shall be primary. Under no circumstances shall the above -mentioned insurance contain a self -insured retention, or a "deductible" or any other similar form of limitation on the required coverage. 12. ERRORS AND OMISSIONS LIABILITY INSURANCE CONSULTANT shall furnish Errors and Omissions liability insurance covering the work performed by it hereunder. Said coverage for CONSULTANT's Errors and Omissions liability in an amount not less than $1,000,000 per occurrence and in the aggregate. A claims -made policy shall be acceptable if the policy further provides that: A. The policy retroactive date coincides with or precedes the contractor's start of work (including subsequent policies purchased as renewals or replacements). B. CONSULTANT will make every effort to maintain similar insurance during the required extended period of coverage following project completion, including the requirement of adding all additional insureds. C. If insurance is terminated for any reason, CONSULTANT agrees to purchase an extended reporting provision of at least two (2) years to report claims arising from work performed in connection with this AGREEMENT. D. The reporting of circumstances or incidents that might give rise to future claims. 13. CERTIFICATES OF INSURANCE Prior to commencing performance of the work hereunder, CONSULTANT shall furnish to CITY certificates of insurance subject to approval of the City Attorney evidencing the foregoing insurance coverages as required by this AGREEMENT; said certificates shall: A. provide the name and policy number of each carrier and policy; B. shall state that the policy is currently in force; and C. shall promise that such policies shall not be suspended, voided or canceled by either party, reduced in coverage or in limits except after thirty (30) days prior written notice from CONSULTANT; however, ten (10) days prior written notice from CONSULTANT in the event of cancellation for nonpayment of premium. CONSULTANT shall maintain the foregoing insurance coverages in force until the work under this AGREEMENT is fully completed and accepted by CITY. The requirement for carrying the foregoing insurance coverages shall not derogate from the provisions for indemnification of CITY by CONSULTANT under the AGREEMENT. CITY or its representative shall at all times have the right to demand the original or a copy of all said policies of insurance. CONSULTANT shall pay, in a prompt and timely manner, the premiums on all insurance hereinabove required. Z 14. INDEPENDENT CONTRACTOR CONSULTANT is, and shall be, acting at all times in the performance of this AGREEMENT as an independent contractor. CONSULTANT shall secure at its expense, and be responsible for any and all payment of all taxes, social security, state disability insurance compensation, unemployment compensation and other payroll deductions for CONSULTANT and its officers, agents and employees and all business licenses, if any, in connection with the services to be performed hereunder. 15. TERMINATION OF AGREEMENT All work required hereunder shall be performed in a good and workmanlike manner. CITY may terminate CONSULTANT's services hereunder at any time with or without cause, and whether or not PROJECT is fully complete. Any termination of this AGREEMENT by CITY shall be made in writing, notice of which shall be delivered to CONSULTANT as provided herein. 16. ASSIGNMENT AND DELEGATION This AGREEMENT is a personal service contract and the work hereunder shall not be assigned, delegated, or subcontracted by CONSULTANT to any other person or entity without the consent of CITY. If an assignment, delegation, or subcontract is approved, all approved assignees, delegate and sub -consultants must satisfy the insurance requirements as set forth in Sections 9 and 10 hereinabove. 17. CITY EMPLOYEES AND OFFICIALS CONSULTANT shall employ no CITY official nor any regular CITY employee in the work performed pursuant to this AGREEMENT. No officer or employee of CITY shall have any financial interest in this AGREEMENT in violation of the applicable provisions of the California Government Code. 18. NOTICES Any notice or special instructions required to be given in writing under this AGREEMENT shall be given either by personal delivery to CONSULTANT's agent (as designated in Section I hereinabove) or to CITY's Systems Group Manager as the situation shall warrant, or by enclosing the same in a sealed envelope, postage prepaid, and depositing the same in the United States 7 • • Postal Service, addressed as follows: TO CITY: Jim Moore, Systems Group Manager City of Huntington Beach Police Department 2000 Main Street Huntington Beach, CA 92648 19. IMMIGRATION TO CONSULTANT: Contracts Manager Intergraph Public Safety, Inc. 241 Disk Drive Madison, AL 35758 CONSULTANT shall be responsible for full compliance with the immigration and naturalization laws of the United States and shall, in particular, comply with the provisions of the United States Code regarding employment verification. 20. LEGAL SERVICES SUBCONTRACTING PROHIBITED CONSULTANT and CITY agree that CITY is not liable for payment of any subcontractor work involving legal services, and that such legal services are expressly outside the scope of services contemplated hereunder. CONSULTANT understands that pursuant to Huntington Beach City Charter Section 309, the City Attorney is the exclusive legal counsel for CITY; and CITY shall not be liable for payment of any legal services expenses incurred by CONSULTANT. 21. ATTORNTEY'S FEES In the event suit is brought by either party to enforce the terms and provisions of this AGREEMENT or to secure the performance hereof, each party shall bear its own attorney's fees. 22. FORCE MAJEURE For the purpose hereof, force majeure shall be any of the following events: acts of God or the public enemy; compliance with any order, rule, regulation, decree, or request of any governmental authority or agency or person purporting to act therefore; acts of war, public disorder, rebellion, terrorism or sabotage; floods, hurricanes or other storms; strikes or labor disputes; or any other cause, whether or not of the class or kind specifically named or referred to herein, not within the reasonable control of the Party affected. A delay in or failure of performance of either Party shall not constitute a default hereunder nor be the basis for, or give rise to, any claim for damages, if and to the extent such delay or failure is caused by force maleure. 8 • The Party who is prevented from performing by force majeure (i) shall be obligated, within a period not to exceed fourteen (14) days after the occurrence or detection of such event, to give notice to the other Party setting forth in reasonable detail the nature thereof and the anticipated extent of the delay, and (ii) shall remedy such cause as soon as reasonably possible. 23. WARRANTY CONSULTANT shall provide qualified and able personnel to provide the Deliverables delineated in Exhibit A. 24. SOFTWARE ESCROW SERVICE CONSULTANT shall provide software escrow service in accordance with Exhibit "C", which is attached hereto and incorporated into this AGREEMENT by this reference. 25. SOFTWARE MAINTENANCE FEES CONSULTANT shall have the right to increase the fee charged for each annual maintenance period by no more than the annual percentage change of the Los Angeles Metropolitan District Consumer Price Index or five percent (5%) more than the fee charge for the preceding annual maintenance period, whichever is less. 26. DUPLICATE ORIGINAL The original of this Agreement and one or more copies hereto have been prepared and signed in counterparts as duplicate originals, each of which so executed shall, irrespective of the date of its execution and delivery, be deemed an original. Each duplicate original shall be deemed an original instrument as against any party who has signed it. 27. ENTIRE AGREEMENT This Agreement constitutes the entire agreement between the Parties hereto with regard to the subject matter hereof. This Agreement supersedes any and all prior discussions and/or representations, whether written or oral, and no reference to prior dealings may be used to in any way modify the expressed understandings of this Agreement. This Agreement may not be amended or modified unless so done in writing signed by authorized representatives of both Parties. IN WITNESS WHEREOF, the parties hereto have caused this Agreement to be executed by and through their authorized office the day, month and year first above written, LJ • II;TERGRAPH PUBLIC SAFETY, INC., a Delaware corporation � 0 By: 6:�41z� R er O. Coupland ITS: (circle one) Chairm resident ice President AND By: I Larry La ter ITS: (circle one) Secret 1 ief Financial Officer Asst. Secretary - Treasurer REVIEWED AND APPROVED: City A ministrator CITY OF HUNTINGTON' BEACH, a municipal corporation of the State of California Mayor ATTEST: /A i APPROVED AS TO FORS: '4zt'� �/� Jtia fib Cit Attorney tj1$iD3 INITIATED AND APPROVED: Police Chief Feq-1A-2003 07:58 From-IHTERGRAPIi C& IONT .... vvr7 BI\V, PROLIJCER Marah USA Inc. 3475 Piedmont Road N.E. Atlanta, GA 20305 Atin: Tins DeVincenzo (404) 995-2532 INSUA&D Intergraph Corporation Attu: Diana Millar Mail Stop IW 2003.0001 huntavilie, AL 35694 + T-514 P-002/002 F-168 LR t hKI II•I_4ATE OF I URANCE C6R_000 42Q,? Q _ _ 47L-OOQ84�$27-0 THIS 4.Ei+�TIFICAIE 15 rSSU40 AS A NATTER OF INFORMATION ONL+' AMP CChFERti NO 204TS UPON THE CERTWIcATE rIQLA%OTHER THAN ThOSE PROVIDED IN THE P0L,C'r.:HI5 CERTiROATE DOES NOT AUGND. EXT6N:I OR ALTER IN! COV11RAO6 AAPORD@O NY me POLICIES DESCRIeeD HEREX COMPANIES AFFORDING COVERAGE L-OMF'ATiY �^•• ��� •^ A FEDERAL !NSURANCE CO I:OMFANY ^� 8 GREAT NORTHERN INSURANCI? CO C HARTFORD CASUALTY INS CO COMPANY ' D COYERA13ES This cerliFeate Eupersedas and replocus any pryviously IOSUad aartiticote for the policy period !toted beiow. 6 T IRIS 15 TO CERTIFY THAT POI•ICIEB OF tN6URA.NCE DeSCAMUD HeRHIN HAVE ORFN MSUEO TO TkE INSUR60 NAMED MEREM FOR YFI° F06ICr PERrOO INCICATED. 1REQU14"ENT, TERM OR CONDITION oT ANY CONTRACT OR OT}II_R DOCumENT wi-I m RESPECT TO Y@HICm YHE CER1&iCA7G MAY DE ISSUED OR MAY t ERTAIN. THE INSURANCE AFr1ORDED BY TSE PDXIFS DESCHISED h9REM r5 SuEkJeE T TO ALL -1111; T&RMS. (WNDMNS AKCI EXCLUSIONS OF SUCH POLICIES. LIMITS SHOWN AIAY NAVE BMN REOuCED OY PAID CLAUAS CO �POLICY EPPECTIYB POLICY EXPIRATION LTR TYPE OF rivSURANCG POLCY NHMBER DATE (MMtprrYYI DATE tMNr001YYt LIMITS A OGNEkALUASIUIYY I35334115 (}$r39r02 D6f30rD3 II VRALAGGKGATE $ 2,13130•000 } RA (�'C'O'MNERCrALG61�EtL1ANu Y t j I LgD�00 OGT$-COMProPA4G $ 2,0,000 I I ; C4A1M5 MADE OCCUR I I I PEAWNAL A ADv INJUR'-Y-- } S 1,000.000 L J OWINFR S 3 COh7RACTC1M PROT f I i E doCCuRRENCC I$ 1,000,000 GtvinonlLk LrA6ru7r '73229357 (AO: !3 X ANY AVYO 173229856 tVA) y _ ALL OwNaD AUTOS SCH&OULEO AUTOS r HIRED AUTOS AP Rl '�• NON -OWNED AUTOS GARAGE uAwuTV `^ ANY AUTO q ` ` �I;xceSs LtaaHrrr 79749855 k UWIRELLA FORM QTHER TITAN UMMEL{AA FORM A yYAR O PEN I AND i Ern PLOVERS' LIABILITY Ti rg PROPRIETOR! 7 I< nTN2A1!CAFCu7NE INCI, - 0, RICERSARf!. ,- EXCL 11374IR T - EXCOSS Workers' CompensatiOrt ,Employer Lability FIRA DAMAGE (XAy ale' r, I S _ INCLUDED MLO EXp An n $ 10,004 06/30/02 Od130103 I COMBINED aNGIR LYMIT 000.040 06/30/02 406/30103 i BODILY INJURY (Prx Peres) f I F RODILY INJURY 15 (Pc , x�3an53 PROPERTY DAMAGE $ I ye r hGG RATt} $ — - -------•-, `► 10t5130/02 10850103 EACH OCCU NCB ArGREGATe $ 6_y000.000 S 6.000.000 I06136r02 - I I RIi1 i0103 f i X R uMl E EL EACH ACr1DE:NY 1 1,000,t100 P-LDISEASE-POLICYLIM(r S 1,000.0000 EL DESEA4M -15ACH EMPLOYI E� $ i.000,000 tA�. CA) 06130/02 0611003 EL - $1,000,000 Each Aecident I EL • S 1.000,000 Polity limit IEL - S1,D00,000 Ezell Employee OI:gCRIPTION OF OPERATtONS1LOCA7tONB1V8HICLESISPBCIAL ITEMS I•JM115 NAY HE SUBJECT TO DEOUCTjoLiB OR RETENTIONSi Cerijrc_Nu ho:der5 Agenia, Of iCeis, 2nd EinplDyeeu, dre A1611amNl Imkareda erS reepi Fl Ic Coneial Liabilly, aS rzgairtsd by writtr r! DontfaGE. Waiver of Subrogation applies to Workers Compensation C6RT11 ICATS HOLDER- CANCELLATION ENOULO AM• 01 THIi POLIC,r6 DESCROW MENB.L NO CANC46.BJ BEFyTC TPIE EXM RATION aAT9 TrISA11W. Tnv- 5\Sv1LLK r l.ik',15H1 YAr€RACf Wi6j. MAt Ul v. Y K,TT61L NOT= 10 1KE " City of Hantinglon 6earn r•FPTIrrrfF ••r'1i60?.m-rn,.FPF,v r1LRJrfL7t,+Gnkkl6r,YsWCk.'rArMhKYs�Rf'n@IN11ppi(pa<Jq[t�ldlkt�lyADR+ Alm; J,rn Moore 2.00 Mium Street .rrlwvcpK7uYrYRWaTdrk 4MRa:kILIFKpC<WRuc�Yt}+rrAa.n,awxaacxx+serrLn�ti.rr.,naBAn►�rsm+s+Sx+tAx ►+unionp:nn tlua mh, k.:A 61_tl4o AXxXy}iX)cxXXAX RAa+(XAAXAXXAXXXXAAXXXK)LXAAXXXXXXAxXXgXXxXxx}AXXAXXXr X.KX MAR Sr+i,SA I m_ - 1Jawei$ i4q J�/7UGPp r hui,l arly .lrmeneb%l a- RiskArtIvy_- MIJI1I9144) VALID AS OF: 071J'lciz _ U 4 j-9, ZOOZ SZDVUKDO SdI QT69 D£L 9SZ 3Fd £T:80 £OOZf6T1Z4 a y • f Exhibit A Computer Aided Dispatch I/LEADS Police Records Management Systems Mobile Data Application System Detailed Design Document For City of Huntington Beach, CA Prepared by Intergraph Public Safety January 7, 2003 Version 6.0 Item I CAD, RMS, and MDAS Scope Of Work Item II Cad System Detailed Design Item III I/Leads RMS System Detailed Design Item IV IPS Training Catalog Item V Cad Command Line Reference Item VI Phase I Question And Answers Item VII System Diagram Item VIII Detailed Pricing Detail Item IX Change List [ON F i L,-E IN Gir.l Gl.Gi2.l<'s O FFICE� Exhibit A Computer Aided Dispatch I/LEADS Police Records Management Systems Mobile Data Application System Detailed Design Document For City of Huntington Beach, CA Prepared by Intergraph Public Safety January 7, 2003 Version 6.0 Item I CAD, RMS, and MDAS Scope Of Work Item II Cad System Detailed Design Item III I/Leads RMS System Detailed Design Item IV IPS Training Catalog Item V Cad Command Line Reference Item VI Phase I Question And Answers Item VII System Diagram Item VIII Detailed Pricing Detail Item IX Change List • • ITEM I CAD and RMS Statement of Work For City of Huntington Beach, CA Prepared by Intergraph Public Safety March 11 th, 2003 0 Item I - CAD & RMS Scope of Work •Huntington Beach, CA Table of Contents 1. INTRODUCTION AND DOCUMENT PURPOSE.....................................................................................I 2. DEFINITIONS.................................................................. ..................1 3. SCOPE..........................................................................................................................................................3 4. PRICING DETAIL.......................................................................................................................................3 5. GENERAL ASSUMPTIONS AND CONDITIONS....................................................................................3 6. SYSTEM ADMINISTRATION...................................................................................................................3 7. HARDWARE AND NTTWORK.................................................................................................................3 7.1. HARDWARE..................................................................................................... ....3 ............ ................................... 7.1.1. RMS Server Configuration ............................................ ................... ...4 7.1.2. Minimum RMS Workstation Specifications........................................................................................4 7.1.3. CAD Server Configuration.................................................................................................................4 ................................. 7.1.4. CAD Workstation Specifications.................................................. .....................5 7.2. NETWORKS.......................................................................................... ...5 .... .......... . 7.3. OPERATING SYSTEM..............................................................................................................................6 7.4. DATABASE SOFTWARE ...........................................................................................................................6 8. I/LEADS - POLICE RMS............................................................................................................................7 8.1. INSTALLATION..................................................................................................................7 9. IICAD - COMPUTER AIDED DISPATCH SYSTEM................................................................................7 9.1. INSTALLATION....................................................................................................................... .....7 10. DATA CONVERSION............................................................................................................................. 10.1. IPS SERVICES ....................................................................................................................................7 10.2. CITY RESPONSIBILITIES......................................................................................................................8 11. IMPLEMENTATION........................................................... .................................... ..— ......... .................. 8 11.1. CITY PROVIDED SUPPORT STAFF.......................................................................................................9 11.2. PROJECT PLAN.................................................................................................................................10 11.3. TRAitiING PLAN...............................................................................................................................39 11.3.1. 1/LEADS Training.................................................................................... 11.3.2. 1/CAD Training...............................................................................................................................40 11.4. Go LIVE PLAN.................................................................................................................................40 11.5. PERFORMANCE STANDARDS............................................................................................................40 11.6. PROJECT SCHEDULE........................................................................................................................41 12. RFP CLARIFICATIONS - GENERAL..................................................................................................41 ItcmI-HBGenera1_Designv12.doc Page I i • Item 1- CAD & RMS Scope of Work Huntington Beach, CA 1. Introduction and Document Purpose The purpose of this document is to present technical information concerning the proposed Intergraph Public Safety, Inc. Computer Aided Dispatch System (I/CAD), I/LEADS Police Records Management System (RMIS) and Mobil Data Application System (MDAS) to the City of Huntington Beach, CA. This document contains or refers to confidential information. This document will be presented in several sections. Section I (this section) will present the general overall system design. Separate sections will present detailed technical information about the CAD, RMS, and MDAS systems respectively. 2. Definitions Agency Huntington Beach Police Department. Application All or any portion of IPS' computer software programs as listed in Item VIII (Pricing Software Detail), whether in machine readable or printed form including any corrections or updates thereto and all associated documentation. CAD IPS Computer Aided Dispatch system software. COTS Commercial Off —the- Shelf. DSD The Detailed Design Document is defined as Items I through Item IX that has been developed to document desired workflow or configuration of the System. GIS A geographic information system that allows for the display of map information and geographic related file -based data. 1/LEADS Intergraph Law Enforcement Automated Data System (Records Management System). IINZARS Management Analysis Reporting System - Software product for Police RMS. Integrations The interface between the RMS and other computer applications, which will cause data elements to be passed to and from the RMS to the other application, populating certain data elements to the RMS and other applications. Pricing Detail The latest official Intergraph pricing spreadsheet sent to the City of Huntington Beach. IPS Intergraph Public Safety, Inc. LAN (Local Area Network) Microcomputers joined by a standardized network protocol into a well-defined group. Huntington Beach The end user and operator of the systems being installed Or the City Printer A hardeopy device writing characters or images to paper; draft, near letter or letter quality; impact, pen plotter, or laser driven. Project Schedule The official project schedule, inclusive of all agreed upon activities or Schedule RNIS Records Management System SOW The Statement of Work defining the tasks and equipment to be delivered (this document). ItemI-HBGeneral_Designvl2.doc Page l Item I - CAD & RMS Swpe of ViTrk Otuntington. Beach, CA WAN Groups of interconnected LANs. Workstation A computer device that provides software program execution environment used for executing the CAD or RMS software applications or in some cases, general-purpose software applications. I/NetViewer A browser -based product that allows personnel throughout the agency to access dispatch information needed without having special I/CAD software installed on their computers. I/Dispatcher Software providing both calltaking and dispatching functionality. Contract Written agreement between Intergraph Public Safety, Inc. and City of Huntington Beach, California. I/Mobile Software which resides on each mobile data computer, connecting the mobile user to the I/CAD System and to other mobile data computers. ItemI-1113General_Designvl2.doc Page 2 Item I - CAI) & RMS Scope 0 ork is Huntington Beach, CA 3. Scope This document, along with specifically referenced documents, shall describe and be known as the Statement of Work (SOW) for the City of Huntington Beach Public Safety CAD/RMS project and shall be suitable for accomplishment of the tasks and delivery of the items specifically contained or referenced herein. 4. Pricing Detail See Item VIII — Pricing Detail and Summary 5. General Assumptions and Conditions The Pricing Detail submitted to the City reflects the implementation of the COTS version of all listed software. Only in those cases where explicit modification to COTS Software is identified in the following Sections, the Detailed Design Document (DSD) or the Pricing Detail reflects specific cost for a specific function is there considered to be an obligation by IPS to modify the standard deliverable software. Otherwise, functional descriptions found in this document are present to describe the then current COTS operations. IPS products operate under the Windows 2000 operating system and will soon be supporting Windows XP. Because of the cost of upgrading complete system software, the purchase of operating system and operating software will be agreed upon by IPS and the City. Based on the dates in the Implementation Plan, a decision can be made whether use Windows 2000 or Windows XP as the operating platform. There are no cost implications if the decision is made before hardware and operating software is ordered. The City will provide all operating software including but not limited to products such as Windows 2000, MS Office Professional, Microsoft SQL Server that are required for proper operation of priced IPS software excluding the operating software bid by IPS. Refer to Item VIII for a complete list of IPS bid operating software. 6. System Administration The City will have System Administrators fully in charge of the day-to-day technical issues and configurations of the both the CAD & RMS systems. As with any large computer system there must be technical personnel committed to the project, trained to run and maintain the system, build reports and add configuration changes as needed. IPS has included the implementation time and formal training necessary to teach System Administration personnel how to maintain the CAD and Records systems. 7. Hardware and Network The City will provide RMS workstation hardware and network connectivity. 7.1. Hardware IPS will provide all CAD workstations and all CAD and RMS servers as outlined in Item VIII of the DSD. The City will be responsible for providing all INetviewer and RMS workstations. Servers will be shipped to IPS headquarters staging area in Huntsville, Alabama for initial setup and configuration of appropriate CAD and I/LEADS products. In the present proposed configuration this includes (2) CAD Database Servers, 1 Interface Communication Server, I Netviewer Server, 1 Archive Server and a Dual Server Cluster for the I/LEADS Police RMS system. The proposed Communications Server will be shipped directly to the City site where all communications software will be installed & configured by IPS personnel during normal on -site implementation. If any required software to be provided by the City or its supplier is not available at time of staging, the server configuration will be done on site. When staging is complete, all configured hardware will be shipped to the City at the City's expense, if purchased from a third party. Iteml-HBGeneral_DesignvI2.doe Page 3 Item I - CAD & RMS Scope ofWork • Huntington Beach, CA 7.1.1. RMS Server Configuration IPS will rpovide two Servers that will be configured as a Microsoft cluster Server. The "Clustered Server" will be attached to a Shared Raid Drive array. Both servers in the Cluster will have Microsoft SQL Server installed but the Microsoft SQL Server control files and all of the data files will reside on the shared Raid drive. This configuration will provide the City with the most cost effective method of redundancy and failover for the RMS application. The exact configuration will be determined by a mutually agreed upon discussion between the City System Administrator and IPS Implementation team. This server configuration will not require user intervention to perform an application switchover at the server level in the event of a single server failure. Users will have to exit the client application and log back in. RMS Server Hardware Components Two Dell 6600 PowerEdge Rackmount Servers each with: • Quad 1.5 GHz Xeon Pentium processors • 6GB RANI • 2-18GB IOK HDs • 2-10/100 NICs • One External Raid Array • Storage Array with 12-36GB driver (this is the minimum number of drives) • Windows 2000 Advanced Server 7.1.2. Minimum RMS Workstation Specifications The City is responsible for providing I/LEADS client workstations. The minimum hardware specifications are listed below. • Intel 500 MHz Pentium II processor or higher • 64 MB minimum - 128 MB RANI recommended • 200 MB hard disk free space after all applications are installed • 15 inch monitor capable of displaying minimum of 800 by 600 video resolution - 1024 X 768 resolution and a 17" monitor recommended. • Network interface 7.1.3. CAD Server Configuration The CAD system will consist of five (5) servers: one (1) dedicated as the Primary CAD Database Server; one (1) as the Secondary CAD Database Server; one (1) as the Interface/Communications Server; one (1) as the Archive Server ;and one (1) as the I/1`etViewer server. The Primary and Secondary CAD Servers are configured so that each transaction is written to both databases at the same time. If the Primary server has a malfunction the Secondary continues processing as normal. A notice is sent to the supervisor stating that one of the servers is down and the system is in single mode. There is no interruption in CAD operations. The NetViewer Server will be configured with a third copy of the CAD database whereas updates from the live CAD databases are sent to the I/NetViewer server on a configurable time period. All users of the I/NetViewer application accessing the NetViewer server will view this delayed data. All updates done via I/1`etViewer will be committed to the live CAD database as to keep critical information up to date to the calltakers and dispatchers. ItemI-HBGeneral_Designvl2.doc Page 4 Item I - CAb & RMS Scope ofpork *Huntington Beach, CA Each server will be configured with a RAID (Redundant Array of Independent Disks) disk configuration, to allow for the utmost reliability and disaster protection. This disk configuration is typically hardware driven, and utilities are provided by the server vendor for use in maintenance of the RAID disk array. IPS recommends 9 -- 12 months of data be maintained on the live CAD servers. Older data will be archived to a separate, dedicated server. CAD Server Hardware Components Dell 6600 PowerEdge Rackmount Servers each with: • Quad 1.5Ghz Xeon Pentium Processors • 1GB of RAM • 4 - 36GB Hard Disks • 10/100 NIC • Windows 2000 Server Operating System 7.1.4. CAD Workstation Specifications IPS will provide eight (8) CAD Workstations. Seven (7) are designated as calltaker/dispatcher positions and one (1) is designated as a supervisor positions. All hardware needed for system administration is to be provided by the City. • Dell Precision 340 workstations: • Single 2.OGHz Pentium 4 processor • 256MB of RAM • 40GB Hard disk • 10/100 NIC • Dual - 21" Monitors • Windows 2000 Workstation Operating System 7.2. Networks The City of Huntington Beach is responsible for providing and maintaining the network for the CAD and RMS system. The CAD and RMS network requires the TCP/IP protocol, and each machine in the network must be configured with static configuration parameters (iP address, subnet mask, gateway, etc.). DHCP can be used for configuring members of the CAD and RMS network, but the City must ensure that the lease expiration parameters are set so that the address does not expire. If DHCP is used elsewhere in the City's network, and the City chooses NOT to use it for the CAD machines, the City must exclude the addresses for CAD machines from the scope. The City LAN and WAN are in place to support the final configuration. IPS network administrators will review the City Network Diagrams including all remote sites to verify that the current LAN will provide mission critical response time to IPS bid applications. If necessary and very early in the project implementation, recommendations will be made to upgrade the existing remote site connections to provide adequate bandwidth for effective operation of IPS bid software. Access to the servers must be at least as follows: YCAD — 128kbps dedicated bandwidth per client I/LEADS — 128kpbs dedicated bandwidth per client I/Netviewer/NetDispatch — 56kbps dedicated bandwidth per cliebt I/Informer — 128kpbs dedicated bandwidth per client 1/Mobile — 9600bps wireless RF bandwidth Iteml-HBGeneral_Designvl2.doc Page 5 4PItem I - CAD & RMS Scope of Work Huntington Beach, CA 7.3. Operating System The current operating system utilized by the I/CAD System is Microsoft Windows 2000. All delivered Intergraph applications are dependent on this version. If new applications outside the IICAD suite are loaded on the system, the System Administrator will need to verify that the applications will run with Windows 2000. Service Packs are also available from Microsoft to update Windows 2000 with the latest fixes, drivers, and patches. The latest server packs may not be compatible with IPS' system. Checks must be completed with IPS Implementation Engineer, IPS Help Desk, or the City's System Administrator before loading any Service Packs. IPS software is currently certified against Service Pack 1. Windows 2000 Domain The CAD network is usually configured in Windows 2000 Active Directory services to provide a set of services that are included in Windows 2000 Server. A directory service is a network service that identifies all resources on the network and makes them accessible to users and applications. Active Directory services include the directory, which stores information about all network resources, as well as the services that make the information available and useful. The resources stored in the directory, such as user data, printers, servers, groups, computers, and security policies, are known as objects. Active Directory services organize resources hierarchically in domains. A domain is a logical grouping of servers and other network resources under a single domain name. The domain is the basic unit of replication and security in a Windows 2000-based network. Each domain includes one or more domain controllers. A domain controller is a computer running Windows 2000 Server that stores a complete replica of the domain directory. To simplify administration, all domain controllers in the domain are peers, unlike the previous NT domain which had PDC (Primary Domain Controller) and BDC (Backup Domain Controller) servers. Administrators can make changes, such as adding user accounts, to any domain controller, and the updates are replicated to all other domain controllers in the domain. Active Directory services further simplify administration by providing a single point of administration for all objects on the network. Since Active Directory services provide a single point of logon for all network resources, an administrator can log on to one computer and administer objects on any computer in the network. Working in a domain environment provides the System Administrator with a centralized method of adding users and groups to the environment. Once a user account is added to the domain, Windows 2000 can be accessed from any workstation or server in the domain. A rich set of tools are provided in Windows 2000 sever for managing the resources in the domain. Once Active Directory has been installed and configured, several tools are added to the Administrative Tools Program Group for managing resources. Tools are included to create and manage user and group accounts, computer accounts, organizational units, printers, shared folders, and domain security policies. These tools are described in the Windows 2000 Server documentation. 7.4. Database Software The database engine used for the IICAD System is Microsoft SQL Server. Microsoft SQL Server is an industry standard relational database management system, used in enterprise -wide mission -critical applications for robust and real time data storage and retrieval. The option of using of Microsoft SQL Server database platform is included in the proposal to the City. The Microsoft SQL Server software will be loaded on the Primary and Secondary CAD Servers. The Microsoft SQL Server application must also reside on any server that houses the I/NetViewer or I/NetDispatcher applications. In this case I/NetViewer and I/NetDispatcher will reside on their own servers. Iteml-HBGeneral_DesignvI2.doc Page 6 Item I - CAD & RMS Scope olork *Huntington Beach, CA 8. IILEADS - Police RMS IPS' Law Enforcement Automated Data System (IILEADS) is a Police records management system. The product runs on Windows 2000 Operating System and uses the Microsoft Windows GUI. 8.1. Installation IPS will install the IILEADS RMS client software modules on 15 of City furnished PC's meeting the requirements as set forth in the next section of this document. IPS personnel will train one or more designated City staff of the City on the installation of IILEADS and it will be the responsibility of the trained City staff to install IILEADS client on the remainder of the City furnished PC's to the level of software licenses as priced. The workstations to be loaded with the IILEADS RMS client software must have access to the IILEADS server via the network. In addition to the above specified fifteen (15) individual RMS client software installations, IPS will install the IILEADS RMS server software and interfaces on the IILEADS RMS server(s). Also, IILEADS RMS database software will be installed during this process along with any City purchased operating software that is needed. IPS will train the System Administrator on this installation and startup process for future reference and administration of the Police RMS system. These procedures will also be provided in hard copy documentation. Hands-on training will provide the needed skills to maintain the I/LEADS RMS system and make changes on a continuing basis. 9. I/CAD - Computer Aided Dispatch System IPS Computer Aided Dispatch System (I/CAD System) runs on Windows 2000 and uses the Windows GUI. 9.1. Installation IPS implementation team will configure the eight (8) Dispatcher workstations with all the required software (operating system, databases and application software) and install them in the City's Communications Dispatch Center. The City has purchased one hundred (100) concurrent user licenses of UNetViewer. IPS will install the server side software for IINetViewer and train City personnel in the setup process of the Internet Explorer client so that the one hundred (100) concurrent I/NetViewer clients can access the U etViewer server software. The City has purchased five (5) concurrent user licenses of I/NetDispatcher. IPS will install the server side of the IhletDispatcher software and train City personnel in the setup process of the Internet Explorer client so that the five (5) concurrent I/Dispatcher users can access the I/Dispatcher server software. One (1) of the I/NetDispatcher licenses will be used at the remote station located within the vicinity of Huntington Beach pier. The other four (4) IINetDispatcher locations and the one hundred (100) I/NetViewer locations will be determined by City personnel during the implementation phase of the project. 10. Data Conversion 10.1. IPS Services • IPS will convert Alarm Permit data, False Alarm Response data and property data to the new IILEADS RMS. • Convert full data set • General consulting as required The conversion process is initiated with an on -site visit as soon as possible after the contract is signed. The primary objective of this visit is to finalize the set of items to be converted, obtain and review file formats of all data to be extracted, meet data conversion team members, discuss respective Iteml-HBGeneral_Designvl2.doc Page 7 ►D & RMS Scope of Work Huntington Beach, CA sponsibilities and review details on the data conversion process including system dependences that ill need resolution before the conversion can be completed. An I/Leads Data Conversion Guide is -ovided to the customer at this meeting. tilizing the legacy file layouts provided by the customer a detail mapping matrix will be developed ,fining how each legacy data item will be mapped into the I/Leads schema. The mapping matrixes are armally created as Excel worksheets and will be provided to the customer for review. After the matrixes are completed a joint Mapping Design review is conducted with bath IPS and the customer participating. Once the matrixes are accepted as correct, the customer will extract and delivery to IPS a representative sample of all data to be converted. IPS will develop any needed conversion scripts required to transform the legacy data into I/Leads data types, convert the sample data and load into the I/Leads schema. These scripts are normally developed in the FoxPro scripting language and are designed to load into the Leads FoxPro training database tables. Once converted, the FoxPro tables are exported into flat files which are used as SQL*Loader input files which is the tool used to import into the Leads SQL schema. The converted sample data will be installed on the customer's RMS or training server and a joint IPS and City quality audit of the converted data will be performed. After any discrepancies or required changes are identified, corrected and accepted by the appropriate party, the customer will extract and deliver the full set of data and the conversion process as described is repeated until a mutually acceptable level of data conversion is attainded. 10.2. City Responsibilities During the data conversion process the City is responsible for the following: • Provide file layouts and individual field descriptions • Extract and deliver sample audit data and full data set • Joint [IPS and City] audit of converted sample data set • Answer legacy data questions and provide additional data as required • Verify data accuracy and integrity upon completion of conversion. The City is responsible and expected to dedicate personnel to the project that are knowledgeable with the content and format of the legacy data and who can act as the primary interface to IPS on the City's behalf. As a joint participant the City will provide the detail file layouts and formats to IPS, extract and delivery the legacy data, respond in a timely manner to legacy data questions that arise, provide system configuration information and audit the mapping matrixes and sample data conversions. Please note the City has decided not to convert CAD data. The City can run a separate application (such as a terminal emulation application) on the CAD workstation to access the GEAC CAD system. 11. Implementation The successful implementation of this project requires resources from the City as well as IPS. Below is a description of the responsibilities of resources, which must be provided by the City. Note, a single person may fulfill more then one resource role. IPS Team Huntington Beach Team °-IRWRTURRB',_acL�€z:.�z.z'&�EEec.xN.Rz-Lz i4 i.�Ri'.2�'?ztt H _s_ Project Manager Project Manager ItemI-HBGeneral Designvl2.d c Page 8 ) & RMS Scope of Work Huntington Beach, CA Map/GIs Map/GIS Lead Construction Lead Interface Development Lead Implementation'' S Lead Training Lead System Administrators MI; .,.C{�....:�zadIT..t#'%t� Agency Trainers £ (its 3es=s T l f y- 40 1122 2 Subject Matter Experts Organizational Structure for IPS and Huntington Beach Project Teams 11.1. City Provided Support Staff Project Manager: The Project Manager will work directly with IPS to coordinate all activities on the Project. This person will provide the technical vision for the Project and assure that this is consistent with the overall City direction. The Project Manager will be responsible for communications with Agency executives and coordinate any support requirements from the executive team. System Administrator(s): System Administrator(s) will be responsible for: 1. Working with IPS during the installation and configuration of the Project Software including the client and server operating software, Microsoft SQL Server, and application software. 2. With the assistance of IPS, be capable of managing the configurations of the system to assure that the System does not have any mismatched Software versions. 3. Provide general PC support to client users 4. Completion of system backups in case data recovery is required. Map/GIS Lead: The Map/GIS Lead provides detailed map information to IPS personnel for the initial map build. This person will also maintain the map and map tables for the City once the initial build is complete. Agency Trainer(s): The Agency Trainer(s) provide system expertise for on going training of new personnel and refresher training as needed. Each supported agency should have designated trainer(s) to support on going user needs. Agency trainer(s) are trained by IPS staff prior to providing training to other City Personnel. Database Administrator: 1temI-HBGeneral—Design 12. doc Page 9 Item I - CAD & RMS Scope Ark *Huntington Beach, CA The Database Administrator will be primarily responsible for the configuration of Microsoft SQL Server and maintaining the Project data in an Microsoft SQL Server environment. This person should be experienced with Microsoft SQL Server systems and all of the details surrounding the care and maintenance of this data. Network Administrator: The Network Administrator will be primarily responsible for the configuration of network and coordinating the system's inclusion in the City's network environment. This person should be experienced with network equipment and all of the details surrounding the care and maintenance of the Windows 2000-based network. 11.2. Project Plan During the initial implementation of phase 2 of this project, the project plan will be refined based on mutual input and concurrence by both the City and IPS. The project plan is a course of action that is used to guide the progress of the system implementation project. Project performance and status is monitored against this plan. Project Kickoff. Objective. Refine project schedules and procedures. Task Description. The project will be initiated with a Project Kickoff including all key IPS and City project participants. The objectives of this first multi -day meeting are: I. To introduce all project participants. 2. Review roles of key participants. 3. Establish a clear chain of communication and authority. 4. Establish a project action item log process. S. Review overall project scope and objectives. 6. Review resource and scheduling requirements. 7. Review and collect Application Program Interface, API, and Data. 8. Finalize Hardware Requirements. 9. Conduct site surveys. 10. Review and modify the preliminary Project Schedule based on City input. 11. Review and modify the preliminary Implementation Project Schedule based on City input. Responsibilities. IPS will designate a Project Manager (PM) who will direct IPS' efforts and serve as the primary point of contact for the City. The responsibilities of the IPS Project Manager include: a. Maintain project communications with the City's Project Manager. b. Manage the efforts of IPS staff and coordinate IPS activities with the City's project team members. c. Measure, evaluate, and report the progress against the Project Schedule. d. Resolve deviations from the Project Schedule. e. Monitor the project to ensure that support resources are available as scheduled and as identified in the contract. f. Coordinate and oversee the installation of all licensed Intergraph Public Safety application software. g. Review and administer change control procedures through the City's Project Manager, commonly referenced as a "Project Change Request", PCP, issued by IPS Project Manager. h. Conduct status meetings in person, via telephone, or email with the City's Project Manager on a bimonthly basis, or as may otherwise be reasonably required to discuss project status. i. Provide timely responses to issues related to project progress raised by the City's Project Manager. j. Prepare and submit a monthly status report that identifies the activities of the previous month, as item] -HBGeneral_DesignvI2.doc Page 10 Item I - CAD & RMS Scope Ark Wuntington Beach, CA well as activities planned for the current month, including an updated Project Schedule. k. Work with City personnel in designing and approving of the format of an action item log to be used in conjunction with the Project Schedule. The purpose of the log is to identify outstanding issues, provide continual status updates on specific tasks and to identify responsibilities of the parties. The City will designate a PM who will direct City efforts and serve as the primary point of contact for IPS. The responsibilities of the City's PM include: a. Maintain project communications with IPS Project Manager. b. Identify the efforts required of City staff to meet the City's task requirements and milestones in the Statement of Work and Project Schedule. c. Review the preliminary Project Schedule with IPS Project Manager and assist in developing a detailed Project Schedule defining the detailed tasks and a schedule of IPS and City's responsibilities. d. Measure and evaluate progress against the Project Schedule. e. Monitor the project to insure that support resources are available as scheduled. f. Attend status meetings with IPS Project Manager. g. Provide timely responses to issues related to project progress raised by IPS Project Manager. h. Liaison and coordinate with other City agencies, other governmental agencies and the City's vendors, IPS and common carriers. i. Review and administer change control procedures, hardware and software certification, and all related project tasks required to maintain the implementation schedule. j. Approve and release payments as detailed in the Project Schedule. k. Ensure that all appropriate City personnel attend and actively participate in the Project Kickoff Sessions. 1. Assign one or more personnel who will work with IPS staff as needed for the duration of the project. including at least one system administrator, one database administrator, and one representative from the police department. m. Ensure acceptable Standard Change Request and Approval Letter(s) are approved by authorized signature(s). n. Work with IPS personnel in designing and approving of the format of an action item log to be used in conjunction with the project schedule. The purpose of the log is to identify outstanding issues, provide continual status updates on specific tasks and to identify responsibilities of the parties. Completion Criteria. This task is considered complete when the Project Kickoff Session has been held with IPS representatives in attendance. Finalize Hardware Requirements and Conduct Site Survey 1 Preparation. Objective. Validate and finalize the City's hardware and third -party software requirements. Task Description. IPS will determine the required hardware configuration for accuracy and completeness. This validation step will also include verification of hardware, operating system software, and third -party software. Responsibilities. IPS will: a. Verify with City personnel, IPS recommended computer processor(s), operating system software, third -party software, all associated workstations, printers, communications and related components. b. Review the City's existing communications environment to ensure compatibility with the Iteml-HBGcneral_DesignvI2.doc Page I I Item I - CAD & RMS Seope #rk *Huntington Beach, CA equipment and subsystems proposed, and make recommendations as applicable to meeting these requirements. c. Pre -plan installation activities with City. d. Determine the hardware and software items detailed in the deliverables list assigned to IPS. The City will: a. Provide, upon request, information on existing hardware and operating system software components and terminal networks, as well as projected utilization statistics and other information as is reasonably required to validate final hardware requirements. b. Review the final hardware and operating system software configuration with IPS Project Team. c. Review IPS recommendations regarding any existing communications networks and workstations and make agreed upon modifications to ensure compatibility with the equipment and system to be installed. d. Determine the hardware and software items detailed in the deliverables list assigned to the City. Completion Criteria. This task is considered complete when the final hardware and operating system software configuration is complete, and all parties have a clear understanding of their deliverables. Refine/Adjust Project Schedule, Objective. Refine/Adjust the Project Schedule as necessary. Task Description. The objective of this task is to Refine and adjust the preliminary Project Schedule based upon the requirements identified and the associated project objectives, plans, schedules, approvals, priorities and inter -dependencies among tasks. The Project Schedule will be finalized and mutually agreed upon between the parties as soon as possible. The resulting document defines the specific project tasks to be completed and, documents the final Project Schedule for each subsystem to be implemented. IPS will: a. Review with City personnel the identified implementation tasks, priorities, inter -dependencies and other requirements needed to establish the final Project Schedule. b. Refine the preliminary Project Schedule document and deliver it to the City within (60) sixty days of the Project Kickoff Meeting. The Project Schedule will be provided in Microsoft Project 2000 software., If, upon City's review, there are documented deficiencies, IPS will correct the deficiencies and return to City for review within fourteen (14) days. c. Review the Project Schedule with City personnel and make changes and/or corrections that are mutually agreed upon. d. IPS will not place orders for hardware, software or other substantial contract components without obtaining prior approval from City, which approval the City will not unreasonably withhold. Delays in the project resulting from City's delay in approving such orders will result corresponding extension to affected portions of the final, mutually agreed upon by the City and IPS project implementation plan. The City will: a. Analyze with IPS project personnel the identified requirements and make such implementation decisions as are reasonably required to finalize the Project Schedule. b. Review the preliminary Project Schedule and identify in writing any specific deficiencies found within thirty (30) calendar days of receipt. c. Review the final hardware and operating system software configurations with IPS project team. Approve IPS placement of orders or process orders for hardware, software or other substantial contract components as soon as reasonably possible considering City and IPS responsibilities under the Statement of Work and the project's schedule. City agrees that each delay in the project ItemI-HBGeneral_Designv 12.doc Page 12 i Item I - CAD & kMS Scope of Work *Huntington Beach, CA resulting from City's delay in approving or processing such orders will result in a corresponding extension to affected portions of the project implementation plan. Completion Criteria. This task is considered complete upon mutual agreement in writing by the City and IPS to implement in accordance with the final project schedule that has been developed. The agreed upon final project schedule will become the governing project schedule incorporated into the contract, but is subject to change upon mutual agreement of the City and IPS. Computer Aided Dispatch Subsystem. Conduct CAD Pre -configuration Workshop (I/CAD System Overview). Objective, Provides an overview of the various CAD database files and the requirements for gathering the data to build the CAD database. Task Description. IPS will meet with City personnel to provide information on the data elements that must be collected by the City prior to conducting the CAD Configuration Training (CADDBM Training). IPS will show City personnel the configuration options available. IPS will: a. Conduct a functional overview including a live demonstration of CAD system functionality. b. Review with City personnel the specific CAD application functionality and database files for which information must be collected to configure the system. C. Describe/demonstrate certain functionality that can be parameterized to meet the City's operations and assist City personnel with making appropriate configuration decisions. The City will: a. Assign dispatch, agency and GIS personnel to attend the pre -configuration workshop. b. Inform IPS of the number of trainees attending the pre -configuration workshop and provide the facilities. c. Identify the City's CAD system administrator and assign him/her to attend the pre -configuration workshop. Completion Criteria. This task is considered complete when IPS has identified to the City the configurable options for the CAD application. GeoFile Build Workshop (I/CAD Map Fundamentals Workshop). Objective. To initiate the development of a final map for use by IICAD, utilizing the existing GIS base sources for the City. Task Description. The workshop will enable IPS to review and collect existing GIS data, digital street files, and others map sources to be used for the creation of the CAD Map. IPS mapping personnel will facilitate this workshop on -site. The map sources and ensuing database to be created will consist of the City's geographical area and City's emergency services response areas as of the date of contract execution. The City will gather the service boundary information after the I/CAD Map Fundamentals Workshop and deliver the source maps to IPS. Iteml-HBGeneral_Designv 12.doc Page 13 • Item I - CAD & RMS Scope of Work *Huntington Beach, CA Responsibilities. IPS will: a. Cotiduct an on -site source evaluation to evaluate source data and source maps. b. After assessing the data, source maps, and issues discussed during Kick-off, IPS will outline the data that will be required to create the CAD map. c. Inform the City of the preferred GIS file format and form of transmission. The City will: a. Supply IPS with existing GIS, digital, and/or other source mapping data. b. Appoint a GeoFile system administrator to be the single point of contact with IPS to resolve all GeoFile issues and appoint a backup GeoFile coordinator to receive training. c. Ensure that all necessary GIS resources are made available to IPS. d. Carefully review the final GeoFile requirements with IPS personnel Completion Criteria. This task is considered complete once the City and IPS have completed the I/CAD Map Fundamentals Workshop. CAD Hardware Configuration and Base Software Installation Staging. Objective. Order, receive, install and test all principal hardware components, load third party software, install base CAD application at IPS facility. Task bescription. During this hardware configuration phase, IPS and City will order the contracted hardware components. The CAD servers will be shipped to IPS Huntsville, Alabama facility where the CAD software will be installed. All applicable baseline CAD application software (excluding interface software), as well as equipment vendor's operating system software, necessary for this phase of the project to be completed, will be loaded on the server equipment. IPS and City will order the contracted workstations, which are first shipped to IPS pre -determined facility where IPS CAD workstation software will be installed. The CAD workstation software will be the late4t available release of The CAD software and will include pertinent interfaces. Responsibilities: IPS will: a. Provide the City with the most current workstation and printer minimum requirements and specifications. b. Provide the City with an inventory list, including serial numbers, of equipment delivered to City. Th(, inventory list will be provided when the items are delivered to the City. c. Install the computer hardware, operating system software and application software at IPS Huntsville, Alabama facility. d. Assume responsibility for all IPS server software installation and testing. e. As4ist the City with coordinating the installation of software on any City -owned hardware that will be used to load baseline software (i.e., existing servers, laptops, etc.). f. Acquire contracted hardware and software. g. Install the required equipment vendor operating system software on the servers and associated equipment. h. Install the baseline CAD licensed software within this configuration. i. Test the initial operation of the baseline CAD subsystem. j. Provide written certification of successful installation. The City will: a. Acquire City provided hardware and software, if applicable. Iteml-HBGeneral_DesignvI2.doc Page 14 0 Item I - CAD & RMS Scope of Work *Huntington Beach, CA b. Ship City -provided hardware and software components to the IPS Huntsville, Alabama facility. c. Provide IPS with an inventory list, including serial numbers, of equipment ordered by and delivered by the City. d. Be available to address and answer questions that arise during the installation of the baseline CAD application software. e. City will complete a IPS provided workstation configuration worksheet f. City will provide IPS with server and workstation node names and static IP addresses. Completion Criteria. This task is considered complete when the hardware, software, and third party software have been installed at IPS facility and the related hardware has been certified by IPS to be operational to specification. Install CAD Equipment On -Site. Objective. Transfer all CAD computer equipment and software to the City's facilities. IPS will install the CAD applications software on all CAD workstations and connect the CAD workstations to the CAD server to test CAD on the LAN, facilitate base software certification, and to provide a training area. Task Description. All CAD contracted hardware and software will be delivered to the City's facilities. Any additional CAD hardware and software components included as a contract deliverable will be ordered and delivered at this time. Once on -site, the CAD servers will be installed in the computer room and the City wit] inspect the servers for installation acceptance. The CAD workstations will be installed and connected to the CAD server to test CAD on the LAN, facilitate base software certification, and to provide a training area. Responsibilities. IPS will: a. Assume responsibility for the transportation and final site installation of the contracted CAD hardware and operating system software configuration. b. Deliver the contracted equipment to the City's designated location, with installation of deliverable central computer hardware, and workstations, printers, modems, and communications equipment (if applicable, and related to the CAD server or other IPS-provided server hardware). c. Order any remaining IPS-supplied CAD equipment necessary for the next phases of application software testing, with installation in the City's designated location. d. Install and test, with the City's assistance, the remaining IPS-supplied equipment. e. Provide the City with the training necessary to equip City personnel with the ability to install the CAD workstation software on any workstations that may be acquired in the future. f. Manage installation of the contracted network and certify the network. The City will: a. Provide a site adequate for the installation, operation and maintenance of all computer server(s), workstation(s) and related peripheral equipment. These facilities will be made available at least two (2) weeks prior to the scheduled installation dates to allow for timely installation. b. Assume responsibility for any console modifications required for mounting or placement of display terminals and time displays. c. Provide all cable runs, pathways, coring, access points, floor cutting or drilling and related tasks related to cable and equipment installation. d. Provide all City -supplied telephone, external interface connection points, electrical power and other receptacles within manufacturer recommended distance of the equipment and all peripheral components. e. Provide adequate air conditioning for the operation of the computer equipment and all peripheral components. f. Provide and install all communication lines, modems, hubs and routers, cabling, equipment and ItemI-HBGeneral_Designvl2.doc Page 15 Item I - CAD & ItMS Scope of Work *Huntington Beach, CA other components necessary for system operation and maintenance that are not identified as deliverable products in the contract. g. Provide the E-911 equipment and any other City -provided computer interfaces with connection points at a location convenient to the server equipment. h. Install and verify operation of all locally mounted time source interface equipment, including mounting outside antenna. i. Provide E-911 equipment that can support a digital CAD interface. j. Assume responsibility for any equipment, software or modifications to E-911 and logging recorders to accept synchronized time input data. k. Provide TCP/IP communications and connection to the hub equipment provided in support for any existing networks, workstations and printers that are to have access to the CAD applications. L Provide and install a minimum of one (1) dial -up telephone lines with modular connections convenient to the server equipment for the purpose of remote hardware and software support. m. Allow secure remote IPS access for dial -in (Virtual Private Network or equivalent) access to all development and system administrator accounts on all servers running IPS licensed software. n. Install and test any remote workstations and communications equipment other than those installed by IPS. o. Install the CAD workstation software on any local and remote workstations beyond the number to be installed by IPS. p. Install all remote terminals, workstations, printers and modems other than those installed by IPS. Completion Criteria. This task is considered complete when the CAD subsystem is installed on the City's premises and verified by the City's Project Manager to be operating in accordance with Hardware/base system software acceptance plan criteria. CAD Configuration Training (CADDBM Training). Objective. Instruct City personnel on configuration requirements for functional operation of the CAD subsystem. Task Description. Conduct a 3-day training course for designated City personnel so City personnel acquire the knowledge necessary to enter all the data in the CAD database tables (incident types, status codes, vehicle configuration, etc.), to configure the available parameters to meet the City's operational needs of the CAD system (fire run cards, traffic stops, call stacking options, etc.). Responsibilities. IPS will; a. Instruct up to twelve (12) City personnel, including the CAD system administrator, on completing the entry of data in the CAD database tables. b. Instruct training participants on the configuration options for system functionality. c. Provide phone support for participants of the class after training has been completed. d. Upon notification by the City that all configuration has been completed, the assigned IPS engineer will work with the City to confirm parameters and databases are accurate and complete. e. Bulk load configuration data provided by the City in electronic format. The City will: a. Assign appropriate personnel, to include the CAD system administrator and other participants of the CAD Pre -Configuration Workshop, to attend the CAD Configuration training course. b. Customize the bulk -loaded data in the CAD database tables prior to the certification of the system as ready for training. Completion Criteria. This task is considered complete when IPS has provided the described training to City personnel and the system is ready for training. Iteml-HBGeneral_Designv 12.doc Page 16 Item I - CAD & RMS Scope of 014untington Beach, CA P CAD On -Site Configuration Support. Objective. On -site configuration support for trained City personnel on configuration requirements, tasks and methods to achieve functional operation of the CAD system. Task Description, On -site support and consultation for designated City personnel so City personnel can apply the configuration training and knowledge necessary to enter all the data in the CAD database tables (incident types, status codes, vehicle configuration, etc.), to provide oversight and guidance as related to configurable parameters available to meet the City's operational needs of the CAD system (fire run cards, traffic stops, call stacking options, etc.), and to provide assistance in the development of status windows for display of desired incident and unit information (pending call queues, active unit display, etc.). This task is completed over many months of on site visits and phone support consultation. Responsibilities. IPS will: a. Provide on -site, when applicable, assistance for all configuration trained City personnel, including the CAD system administrator, on completing the entry of data in the CAD database tables. b. Provide support for trained participants on the configuration options for system functionality. c. Provide on -site when applicable, support for participants of the configuration class during normal business hours. d. Upon notification by the City that all configuration has been completed, the assigned IPS engineer will work with the City to confirm parameters and databases are accurate and complete. The City will: a. Assign appropriate personnel, to include the CAD system administrator and other participants of the CAD Pre -Configuration Workshop, to work with the on -site IPS engineer. b. Provide work environment with analog phone access for use of the on -site IPS engineer. c. Customize the bulk -loaded data to complete the entry of all data in the CAD database tables prior to the certification of the system as ready for training. Completion Criteria. This task is considered complete when IPS and City certify that the system is configured to operate in the manner specified in the contract documents and passes Acceptance Test. CAD Subsystem Interfaces. Objective. Develop, install and test all CAD Subsystem Interfaces. Task Description. Once the equipment and software have been installed on the City's premises, all remaining local and remote interfaces as specified in the list of deliverables in the contract documents will be developed, installed and tested. Responsibilities. IPS will: a. Design, develop, transfer, install, and unit test all software required for the CAD subsystem interfaces described in the Component and Price Exhibit, resulting in their operating in accordance with the interface control documents. b. Identify all required information on record layouts and documents necessary to establish interfaces with all local and remote systems and facilities within a mutually agreed upon number of days following project kick-off. ItemI-HBGeneral_Designv12.doe Page 17 0 Item I - CAD & RMS Scope of Work Huntington Beach, CA The City will: a. Provide requested information on record layouts and documents necessary to establish interfaces with all local and remote systems and facilities within a mutually agreed upon number of days before scheduled interface work. b. Provide and install all communications lines and equipment that are not IPS provided deliverables. c. The City will make best efforts to ensure that necessary certifications and approvals will be completed by the City at least thirty (30) calendar days prior to scheduled interface implementation. d. Provide all required liaison support with the agencies and vendors required to support the interfaces. e. Ensure that the necessary technical support is made available for installation, testing and demonstration of the interfaces. Completion Criteria. This task is considered complete when each interface is installed and unit tested. The operation or availability of the external system or third -party software is necessary for task completion. Deliver the CAD Documentation. Objective. Deliver the CAD Documentation to include training guides, reference guides, configuration guides, system administration manuals and related standard documentation. Documentation for any contracted customization will be included as separate documentation. Task Description. Deliver standard CAD documentation, documentation for. any contracted customization and documentation on completed CAD interfaces. Responsibilities. IPS will: 1. Deliver one (1) digital copy of the CAD Subsystem guides, manuals and related documents for the installed software. 2. Supplement the interface control document, as required. The City will: a. Provide written acknowledgement of receipt of documentation. b. Review the CAD specification and interface control documents (described above) submitted by IPS and identify in writing any specific errors and/or omissions found within thirty (30) calendar days of receipt. c. Is able to make unlimited copies of supplied documentation for City usage Completion Criteria. This task is considered complete upon delivery of the standard CAD documentation and interface control documents. Develop CAD Subsystem Acceptance Test Plan. Objective. Develop a mutually agreeable CAD Subsystem Acceptance Test Plan (ATP). Task Description. The Acceptance Test Plan will include the following sections: a. Define all applicable functions and features of CAD and describe how those items wilt be verified. b. Define Level 1, Level 2, and Level 3 errors. Level 1 errors must be fixed before tests can be successfully passed. Level 2 errors must be fixed during the extended warranty period. Level 3 will be fixed in a mutually agreed upon timeframe.. ItemI-HBGeneral_Designvl2.doc Page 18 0 Item I - CAD & RIMS Scope of Work *Huntington Beach, CA c. Define the procedures for certifying that subsystem hardware is functioning correctly (computer hardware acceptance/certification) d. Define the specific interfaces in the CAD system and describe how these interfaces will be verified e. Define throughput measures (e.g., number of peak incidents to be processed, retrieval of archival data under load, etc.) that will be used to verify the specified system response times and throughput. f. Define the reliability period during which the system will operate as specified without encountering any significant downtimes or response timelthroughput degradation. Responsibilities. IPS will develop an initial draft Acceptance Test Plan for review by the City. The City will review the initial draft for the Acceptance Test Plan and work with IPS to define a mutually acceptable final ATP. Completion Criteria. This task is considered complete when IPS and City have approved and signed off on the Acceptance Test Plan. CAD Subsystem Database Testing. Objective. Perform tests of the final CAD databases to certify that the system is ready for training. Task Description. Test and verify the various tabular and geographic databases developed for the City's CAD system as defined in the Acceptance Test Plan. Responsibilities. IPS will a. Provide support for the CAD Subsystem Database Testing during the acceptance test as described in the Acceptance Test Plan. The City will: a. Generate production database files as specified in this implementation plan and the contract. b. Perform the CAD Subsystem Database acceptance test as described in the Acceptance Test Plan c. Certify the results of the test. Completion Criteria. This task is considered complete when the CAD databases have been demonstrated to operate in accordance with the Acceptance Test Plan. CAD Subsystem Functional Testing. Objective. Perform functional tests of CAD. Task Description. Test and verify the applicable functions and features of CAD as defined in the Acceptance Test Plan. Responsibilities. IPS will provide support for the functional CAD Subsystem during the acceptance test as described in the Acceptance Test Plan. The City will: ItcmJ,HBGcnera1_Designv12.doc Page 19 Item I - CAD & RMS Scope of Work •Huntington Beach, CA a. Generate production data files needed for functional testing. b. Perform the functional CAD acceptance test as described in the Acceptance Test Plan. Completion Criteria. This task is considered complete when CAD has been demonstrated to function in accordance with the Acceptance Test Plan Attachment. Final CAD Subsystem Equipment Installation. Objective. Install all remaining cables, modems, hubs, routers, printers, workstations and other equipment required for production operation. Task Description. Prior to CAD Subsystem Integration Testing, all remaining computer, communications and related components will be installed. Responsibilities. IPS will: a. Deliver all remaining IPS-supplied equipment, if applicable. b. Install all remaining IPS-supplied network, cabling and associated equipment, if applicable. The City will: a. Provide, configure and install all remaining equipment not provided by IPS prior to IPS' arrival for monitoring subsystem integration testing. b. Complete any required console and related modifications. c. Provide and install all network cables not provided by IPS and verify both network and PC operation. d. Perform any site modifications to allow successful equipment installation e. Provide and install all necessary UPS equipment not provided by IPS. f. Install and verify the operation of all City -installed workstation operating system software. Completion Criteria. This task is complete when the complete CAD equipment configuration is verified and validated by City personnel. CAD Subsystem Integration Testing. Objective. Perform integration testing of the CAD subsystem and interfaces. Task Description. Test and validate all internal and external interfaces to ensure that the combined CAD subsystem operates as defined in the contract documents, CAD documentation, and the interface control documents and in accordance with the Acceptance Test Plan. City staff will conduct the initial and all remedial integration testing with monitoring by IPS personnel on -site. Responsibilities. IPS will: a. Certify the interfaces as ready for integration testing. b. Test and validate all inter -system communications between installed IPS systems and between IPS (if installed) and non-IPS systems, according to the contract documents, CAD documentation, and the interface control documents. c. Assist the City in testing each interface. d. Review and correct any discrepancies that are identified by the City as quickly as practical and prior to final system acceptance and payment. 1tcmI-HBGenera1_Designvl2.doc Page 20 Item I - CAD & RMS Scope offork •Huntington Beach, CA e. Provide any required software or documentation corrections as quickly as practical to correct the discrepancies prior to CAD Final Certification. The City will: a. Conduct test procedures and verify all inter -system communications between installed IPS systems (if installed) and non-IPS systems to ensure conformance with the approved CAD documentation, and the interface control documents. b. Identify in writing each discrepancy between subsystem and the CAD documentation, and the interface control documents within thirty (30) calendar days. c. Work with IPS to identify the type of correction needed to ensure that each subsystem and ancillary system conforms to the CAD documentation and the interface control documents. Completion Criteria. This task is considered complete when the internal and external interfaces and other IPS licensed software described in the Component and Price Exhibit have been verified operational according to the CAD Acceptance Test Plan, contract specifications and the interface control documents. In the event the performance of an internal or external interface cannot be demonstrated due to factors beyond IPS' control, i.e. the availability of connectivity to an external interface, the degree to which IPS software or IPS-provided connectivity is available or provided to support the interface shall be deemed conditionally complete and considered complete for purposes of recognizing performance or payment milestones. However, performance and payment for these non -tested interfaces shall not be deemed complete and payable until final testing is successfully completed CAD Subsystem Throughput and Response Time Testing. Objective. Perform throughput and response time tests of CAD. Task Description. Test and verify the throughput and response times of the CAD system under load as defined in the Acceptance Test Plan. Responsibilities. IN will: a. Generate and provide Testing Software as specified in the Acceptance Test Plan that will create incidents, dispatch, enroute, arrive, and clear units from those incidents to simulate load. b. Provide support for the CAD Subsystem Throughput and Response Time testing as described in the Acceptance Test Plan. The City will: a. Generate production data files needed for throughput and response time testing. b. Perform the CAD Subsystem Throughput and Response Time testing as described in the Acceptance Test Plan. Completion Criteria. This task is considered complete when CAD has been demonstrated to respond and provide the throughput specified in the Acceptance Test Plan Attachment. CAD Technical/User Training and Documentation. Objective. Conduct CAD technical and user training. Task Description. IPS will conduct their standard training courses to thoroughly train City personnel on the use of the CAD subsystem and City Technical personnel on the operation and support of CAD subsystem as ItemI-HBGeneral_Designv12.doc Page 21 Item I - CAD & RMS Scope offork •Huntington Beach, CA described in the Training Plan. Completion Criteria. This task is considered complete when the scheduled technical and user training on the installed CAD subsystem is completed. CAD Production Cutover. Objective. Place CAD into Production Operation. Task Description. Auer Database certification, user training and functional integration and throughput testing is complete, IPS and the City will certify the CAD subsystem as operational and ready for production operation and assist the City in placing the subsystem into productive use. IPS personnel will be on site for pre -live cut and post -live cut support. IFS personnel will also fine-tune the CAD software application for optimal performance. After live cut, IPS software warranty period and the 30-day reliability test period will begin. Responsibilities. IPS will: a. Develop a mutually agreeable CAD cutover plan b. Assist the City staff in placing CAD into a production status as specified in the CAD cutover plan. c. Monitor the initial operation of CAD and answer any operational questions raised by the City. d. Assist the training staff in utilizing the subsystem and the computer operations staff in supporting the subsystem. The City will: a. Acquire training on fundamental support applications needed to properly maintain the CAD system such as SQL (Structure Query Language), Microsoft SQL Server, Microsoft Access (for report writing if the City chooses this application for its report writing), basic Windows 2000 server and client. b. Place the software into production and begin operational use in consultation with IPS and in accordance with the Project Schedule. c. Ensure end -users are properly trained and ready for CAD subsystem cutover. Completion Criteria. This task is considered complete when: a. The CAD cutover plan is accepted by the City. b. CAD is placed into production operation. CAD Subsystem Reliability Testing. Objective. Verify the level of reliability of CAD in a production environment. Task Description. CAD will demonstrate critical subsystem availability levels that meet or exceed the reliability criteria described in the Acceptance Test Plan. Responsibilities. IPS will provide support for the CAD Subsystem reliability testing during the reliability test period as described in the Acceptance Test Plan. If during the reliability test cycle the City identifies a reproducible system error that requires a system or software upgrade, IPS will suspend reliability testing until the correction is implemented. The reliability test cycle will restart once the software ItemI-HBGeneral_Designvl2.doc Page 22 Item I - CAD & RMS Scope of OGork *Huntington Beach, CA patch/upgrade is implemented. The City will: a. Report any critical system failures, as described in the Acceptance Test Plan, promptly to IPS. b. Operate the CAD subsystem in a manner consistent with its specifications, the Contract and the Acceptance Test Plan. Completion Criteria. This task is considered complete after CAD has demonstrated during the test period that it meets or exceeds the reliability criteria described in the Acceptance Test Plan. CAD Final Acceptance Objective. Certify completion of the CAD subsystem installation. Task Description. Acknowledgement of system acceptance based on the acceptance criteria described in the Acceptance Test Plan. Completion Criteria. This task is considered complete when the CAD subsystem reliability test, as described in the Acceptance Test Plan, has been successfully completed. Law Enforcement Records Management Subsystem. Conduct RMS Pre -configuration Workshop (I/Leads Subsystem Overview). Objective. Provides an overview of the various RMS databases, files, and the requirements for gathering the data to build the new RMS database. Task Description. IPS will meet with City personnel to provide information on the data elements that must be collected by the City prior to conducting the RMS Configuration Training. IPS will show City personnel the configuration options available. IPS will: a. Conduct a functional overview including a live demonstration of RMS system functionality. b. Review with City personnel the specific RMS application functionality and database files for which information must be collected to configure the system. c. Describe/demonstrate certain functionality that can be parameterized to meet the City's operations and assist City personnel with making appropriate configuration decisions. The City will: a. Assign appropriate records personnel to attend the pre -configuration workshop. b. Inform IPS of the number of trainees attending the pre -configuration workshop and provide the facilities. c. Identify the City's RMS system administrator and assign him/her to attend the pre -configuration workshop. Completion Criteria. This task is considered complete when IPS has identified to the City the configurable options for the RMS application. ItemI-HBGeneral_Designvl2.doc Page 23 Item I - CAD & RMS Scope of Work *Huntington Beach, CA RMS Hardware Configuration and Base Software Installation. Objective. Order, receive, install and test all principal hardware components, load third party software, install base RMS application at IPS facility. Task Description. During this phase, IPS and City will order the contracted hardware components. The RMS servers will be shipped to IPS Huntsville, Alabama pre -determined facility where the RMS software will be installed. All applicable baseline RMS application software, as well as equipment vendor's operating system software, necessary for this phase of the project to be completed, will be loaded on the server equipment. Responsibilities: IPS will: a. Provide the City with an inventory list, including serial numbers, of equipment ordered by and delivered to IPS. The general inventory list will be provided when the items are delivered to the City. b. Install the computer hardware, operating system software and application software at IPS Huntsville, Alabama facility. c. Assume responsibility for all IPS server software installation and testing. d. Assist the City with coordinating the installation of software on any City -owned hardware that will be used to load baseline software (i.e., existing servers, laptops, etc.). e. Acquire contracted hardware and software. f. Install the required equipment vendor operating system software on the servers and associated equipment. g. Install the baseline RMS licensed software within this configuration. h. Test the initial operation of the baseline RMS subsystem. i. Provide written certification of successful installation. The City will: a. Acquire contracted hardware and software, if applicable. b. Ship City -provided hardware and software components to the ITS Huntsville, Alabama facility. e. Provide IPS with an inventory list, including serial numbers, of equipment ordered by and delivered to the City. d. Be available to address and answer questions that arise during the installation of the baseline RMS application software. Completion Criteria. This task is considered complete when the hardware, IPS software, and third party software have been installed at IPS facility and the related hardware has been certified by IPS to be operational to specification. Install RMS Equipment. Objective. Transfer all RMS computer equipment and software to the City's facilities. Task Description. All contracted hardware and software will be delivered to the City's facilities. Any additional RMS hardware and software components included as a contract deliverable will be ordered and delivered at this time. Once on -site, the RMS servers will be installed in the computer room and the City will inspect the servers for acceptance. The RMS training workstations will be installed and connected to the RMS server to test CAD on the LAN, facilitate base software certification, and to provide a training area. Fifteen (15) City provided workstations will be installed with the RMS application software and Iteml-HBGeneral_Designvl2.doc Page 24 Item I - CAD & RMS Scope of Work l OHuntington Beach, CA 1 connected to the RMS server to test RMS on the LAN, facilitate base software certification, and to provide a training area. Responsibilities. IPS will: a. Assume responsibility for the transportation and final site installation of the contracted RMS hardware and operating system software configuration. b. Deliver the contracted equipment to the City's designated location, with installation of deliverable central computer hardware, and workstations, printers, modems, and communications equipment (if applicable, and related to the RMS server or other IPS-provided server hardware). c. Order any remaining IPS-supplied RMS equipment necessary for the next phases of application software testing, with installation in the City's designated location. d. InstalI and test, with the City's assistance, the remaining IPS-supplied equipment. e. Provide the City with the training necessary to equip City personnel with the ability to install the RMS workstation software on the remaining RMS workstations. The City will: a. Provide a site adequate for the installation, operation and maintenance of all computer server(s), workstation(s) and related peripheral equipment. These facilities will be made available at least two (2) weeks prior to the scheduled installation dates to allow for timely installation. b. Assume responsibility for any console modifications required for mounting or placement of display terminals and time displays. c. Provide all cable runs, pathways, coring, access points, floor cutting or drilling and related tasks related to cable and equipment installation. d. Provide all City -supplied telephone, external interface connection points, electrical power and other receptacles within manufacturer recommendcd distance of the equipment and all peripheral components. e. Provide adequate air conditioning for the operation of the computer equipment and all peripheral components. f. Provide and install all communication lines, modems, hubs and routers, cabling, equipment and other components necessary for system operation and maintenance that are not identified as deliverable products in the contract. g. Install and verify operation of all locally mounted time source interface equipment, including mounting outside antenna. h. Provide TCP/IP communications and connection to the hub equipment provided in support of any existing networks, workstations and printers that are to have access to the RMS applications. i. Install and test any remote workstations and communications equipment. j. Install the RMS workstation software on any local and remote workstations beyond the number to be installed by IPS. q. Install all remote terminals, workstations, printers and modems. r. Provide secure dial -in access using a Virtual Private Network (VPN) or equivalent for IPS remote diagnostic and maintenance of the RMS subsystem. Completion Criteria. This task is considered complete when the IZMS subsystem is installed on the City's premises and verified by the City's Project Manager to be operating in accordance with the RMS Hardware/Base system Acceptance Test Plan specification. RMS Configuration Training (PLEADS SYSGUI Training). Objective. Instruct City personnel on configuration requirements for functional operation of the RMS subsystem. Task Description. Conduct a two (2) day training course for designated City personnel so City personnel acquire the knowledge necessary to configure the RMS system to meet the City's needs including adding additional Item]-HBGeneral_DesignvI2.doc Page 25 Item I - CAD & RMS Scope o0 ork .Huntington Beach, CA data fields, reconfiguring screen layout and tab order, and adding additional pages to modules. This class will also teach the creation of narrative templates for use in any narrative text field in I/LEADS. Responsibilities. IPS will: a. Instruct up to six (6) City personnel, including the RMS system administrator, on completing the entry of data in the RML S database tables. b. Instruct training participants on the configuration options for system functionality. c. Provide phone support for participants of the class after training has been completed. d. Bulk load configuration data provided by the City in electronic format, if feasible. The City will: a. Assign appropriate personnel, to include the RMS system administrator and other participants of the RMS Pre -Configuration Workshop, to attend the RMS Configuration training course. b. Customize bulk -loaded data as necessary to complete the entry of all data necessary in the RMS database tables as well as module screen layout and data fields necessary prior to the certification of the system as ready for training.. Completion Criteria. This task is considered complete when IPS has provided the described training to City personnel and the system passes its ready for training certification in accordance with the Acceptance Test Plan. RMS On -Site Configuration Support. Objective. On -Site configuration support for trained City personnel on configuration requirements, tasks and methods to achieve operation of the RMS system, Task Description On -site support and consultation for designated City personnel so City personnel can apply the configuration training and knowledge necessary to enter all the data in the RMS database tables (statute code lists, validation pick -lists, employee information, etc.), to provide oversight and guidance as related to configurable parameters available to meet the City's operational needs of the RMS system (case assignment rules, approval levels, case number formatting, etc.). This task is completed over many months of on site visits and phone support consultation. Responsibilities. IPS will: a. Provide on -site, when applicable, instruction for all configuration trained City personnel, including the RMS system administrator, on completing the entry of data in the RMS database tables.- b. Provide support for trained participants on the configuration options for system functionality. c. Provide on -site, when applicable, support for participants of the configuration class during normal business work hours. d. Upon notification by the City that all configuration has been completed, the assigned IPS engineer will work with the City to confirm parameters and databases are accurate and complete as specified in the Acceptance Test Plan. The City will: a. Assign appropriate personnel, to include the RMS system administrator and other participants of the RMS Pre -Configuration Workshop, to work with the on -site IPS engineer. b. Provide work environment with analog phone access for use of the on -site IPS engineer. Completion Criteria. This task is considered complete when IPS and City certify that the system is configured to operate in the manner specified and passes the Acceptance Test Plan. ItemI-HBGeneral_Designv12.doc Page 26 Item I - CAD & RMS Scope It& *Huntington Beach, CA RMS Subsystem Interfaces. Objective. Develop, install and test all RMS Subsystem Interfaces. Task Description. Once the equipment and software have been installed on the City's premises, all remaining local and remote interfaces as specified in the list of deliverables in the contract documents will be developed, installed and tested. Responsibilities. IPS will: a. Design, develop, transfer, install, and unit test all software required for the RMS subsystem interfaces described in the Component and Price Exhibit, resulting in their operating in accordance with the interface control documents. b. Identify all required information on record layouts and documents necessary to establish interfaces with all local and remote systems and facilities within a mutually agreed upon number of days prior to installation. The City will: a. Provide requested information on record layouts and documents necessary to establish interfaces with all local and remote systems and facilities at least thirty (30) calendar days prior to scheduled interface work. b. Provide all required liaison support with the agencies and vendors required to support the interfaces. c. The City will make best efforts to ensure that necessary certifications and approvals will be completed by the City at least thirty (30) calendar days prior to scheduled interface implementation. d. Provide all required liaison support with the agencies and vendors required to support the interfaces. e. Ensure that the necessary technical support is made available for installation, testing and demonstration of the interfaces. Completion Criteria. This task is considered complete when each interface is installed, unit tested, and passes Acceptance Test Plan criteria for the interfaces. The operation or availability of the external system or third -party software is necessary for task completion. Deliver the RMS Documentation. Objective. Deliver the RMS Documentation to include training guides, reference guides, configuration guides, system administration manuals and related standard documentation. Documentation for any contracted customization will be included as separate documentation. Task bescription. Deliver standard RMS documentation, documentation for any contracted customization and documentation on completed RMS interfaces. Responsibilities. IPS will: a. Deliver standard RMS guides, manuals and related documents. b. Provide customization on any required customizations for the City. c. Supplement the interface control document, as required. ItemI-HBGeneral_DesignvI2.doc Page 27 Item I - CAD & RMS Scope ofWork 0 Huntington Beach, CA The City will a. Review the RMS specification and interface control documents (described above) submitted by IPS and identify in writing any specific errors and/or omissions found within thirty (30) calendar days of receipt. b. Is able to make unlimited copies of supplied documentation for City usage Completion Criteria. This task is considered complete upon delivery of the standard RMS documentation, documentation on any required customization and interface control documents. Develop RMS Acceptance Test Plan. Objective. Develop a mutually agreeable RMS Acceptance Test Plan. Task Description. The Acceptance Test Plan (ATP) will include the following sections: a. Define all applicable functions and features of RMS and describe how those items will be verified. b. Define Level 1, Level 2, and Level 3 errors. Level I errors must be fixed before tests can be successfully passed. Level 2 errors must be fixed during the extended warranty period. Level 3 will be fixed in a mutually agreed upon timeframe.. c. Define the procedures for certifying that subsystem hardware is functioning correctly (computer hardware acceptance/certification) d. Define the specific data that will be used to configure the RMS database tables (statute code lists, validation pick -lists, employee information, etc.) and describe how these RMS database tables will be verified. e. Define the specific interfaces in the RMS system and describe how these interfaces will be verified f. Define throughput measures and response times that will be used to verify the specified system response times and throughput. g. Define the reliability period during which the system will operate as specified without encountering any significant downtimes or response time/throughput degradation. Responsibilities. IPS will develop an initial draft Acceptance Test Plan for review by the City. The City will review the initial draft for the Acceptance Test Plan and work with IPS to define a mutually acceptable final ATP. Completion Criteria. This task is considered complete when IPS and City have approved and signed off on the Acceptance Test Plan. RMS Subsystem Database Testing. Objective. Perform tests of the final RMS databases to certify that the system is ready for training. Task Description. Test and verify the various tabular databases developed by the City for the City's RMS system as specified in the Acceptance Test Plan. Responsibilities. IPS will a. Provide support for the RMS Subsystem Database Testing during the acceptance test as described in the Acceptance Test Plan. ItemI-FIBGeneral_Designv12.doe Page 28 Item I - CAD & RMS Scope ofWork *Huntington Beach, CA The City will: a. Generate production database files as specified in this implementation plan and the contract. b. Perform the RMS Subsystem Database acceptance test as described in the Acceptance Test Plan c. Certify the results of the test. Completion Criteria. This task is considered complete when the RMS databases have been demonstrated to operate in accordance with the Acceptance Test Plan. RMS Subsystem Functional Testing. Objective. Perform functional tests of RMS. Task Description. Test and verify the applicable functions and features of RMS as defined in the Acceptance Test Plan. Responsibilities. IPS will provide support for the functional RMS Subsystem during the acceptance test as described in the Acceptance Test Plan. The City will: a. Generate production data files needed for functional testing. b. Perform the functional RMS acceptance test as described in the Acceptance Test Plan. Completion Criteria. This task is considered complete when RMS has been demonstrated to function in accordance with the Acceptance Test Plan. Final RMS Equipment Installation. Objective. Install all remaining cables, modems, hubs, routers, printers, workstations and other equipment required for production operation. Task Description. Prior to RMS Subsystem Integration Testing, all remaining computer, communications and related components will be installed. Responsibilities. IPS will: a. Deliver all remaining IPS-supplied equipment. b. Install all remaining IPS-supplied network, cabling and associated equipment. The City will: a. Provide, configure and install all remaining equipment not provided by IPS prior to IPS' arrival for monitoring subsystem integration testing. b. Provide and install all network cables not provided by IPS and verify both network and PC operation. c. Perform any site modifications to allow successful equipment installation d. Provide and install all necessary UPS equipment not provided by IPS. e. Install and verify the operation of all City -installed workstation and operating system software. Completion Criteria. ItemI-fIBGeneral—Designv12.doe Page 29 Item I - CAD & RMS Scope of Work •Huntington Beach, CA This task is complete when the RMS configuration is tested and validated by City personnel. RMS Subsystem Integration Testing. Objective. Perform integration testing of the RMS subsystem and interfaces. Task Description. Test and validate all internal and external interfaces to ensure that the combined RMS subsystem operates as defined in the contract documents, RMS documentation, and the interface control documents and in accordance with the Acceptance Test Plan. City staff will conduct the initial and all remedial integration testing with monitoring by IPS personnel on -site. Responsibilities. IPS will: a. Certify the interfaces as ready for integration testing. b. Test and validate all inter -system communications between installed IPS systems and between IPS (if installed) and non-lPS systems, according to the contract documents, RMS documentation, and the interface control documents. c. Assist the City in testing each interface. d. Review and correct any discrepancies that are identified by the City as quickly as possible and prior to final system acceptance and payment. e. Provide any required software or documentation corrections as quickly as possible to correct the discrepancies prior to Final RMS Certification. The City will: a. Conduct test procedures and verify all inter -system communications between installed IPS systems (if installed) and non-IPS systems to ensure conformance with the approved RMS documentation, the interface control documents and the contract specification. b. Identify in writing each discrepancy between subsystem and ancillary system functionality and the RyiS documentation, and the interface control documents within thirty (30) calendar days. c. Work with IPS to identify the type of correction needed to ensure that each subsystem and ancillary system conforms to the RMS documentation, the interface control documents and the contract specifications. Completion Criteria. This task is considered complete when the internal and external interfaces and other IPS licensed software described in the Component and Price Exhibit has been verified operational according to the RMS Acceptance Test Plan documentation, contract specifications and the interface control documents. In the event the performance of an internal or external interface cannot be demonstrated due to factors beyond IPS' control, i.e. the availability of connectivity to an external interface, the degree to which IPS software or IPS-provided connectivity is available or provided to support the interface shall be deemed conditionally complete and considered complete for purposes of recognizing performance or payment milestones. However, performance and payment for these non -tested interfaces shall not be deemed complete and payable until final testing is successfully completed. RMS Subsystem Throughput and Response Time Testing. Objective. Perform throughput and response time tests of RMS. Task Description. Test and verify the throughput and response times of the RMS system under load as defined in the Acceptance Test Plan. Responsibilities. Items-I-I13General_DesignvI2.doc Page 30 Item I - CAD & RMS Scope of Work *Huntington Beach, CA IPS will: a. Provide support for the RMS Subsystem Throughput and Response Time testing as described in the Acceptance Test Plan. The City will: a. Generate production data files and personnel to generate load needed for throughput and response time testing. b. Perform the RMS Subsystem Throughput and Response Time testing as described in the Acceptance Test Plan. Completion Criteria. This task is considered complete when RMS has been demonstrated to respond and provide the throughput specified in the Acceptance Test Plan. RMS Technical/User Training and Documentation. Objective. Conduct the RMS technical and user training. Task Description. IPS will conduct their standard training courses to thoroughly train City Training personnel on the use of the RMS subsystem and City Technical personnel on the operation and support of RMS subsystem as described in the Training Plan. Completion Criteria. This task is considered complete when the scheduled technical and user training on the installed IZMS subsystem is completed. RMS Production Cutover. Objective. Place the RMS into Production Operation. Task Description. After database certification, user training , functional, integration and throughput testing are complete, IPS and the City will certify the RMS subsystem as operational and ready for production operation and assist the City in placing the subsystem into productive use. IPS personnel will be on site for pre -live cut and post -live cut support. IPS personnel will also fine-tune the RMS software application for optimal performance. After live cut, IPS software warranty period and the 30-day reliability test period will begin. Responsibilities. IPS will: A. Develop a mutually agreeable RMS cutover plan. b. Assist the City staff in placing the RMS into a production status as specified in the RMS cutover plan. e. Monitor the initial operation of the RMS and answer any operational questions raised by the City. d. Assist the training staff in utilizing the subsystem and the computer operations staff in supporting the subsystem. The City will: a. Acquire training on fundamental support applications needed to properly maintain the RMS system such as SQL (Structure Query Language), Microsoft SQL Server, Microsoft Access (for report writing if the City chooses this application for its report writing), basic Windows 2000 server and client. b. Place the software into production and begin operational use in consultation with IPS and in ItemI-HBGeneral_DesignvI2.doc Page 31 Item i - CAD & RMS Scope of Work *Huntington Beach, CA accordance with the Project Schedule. c. Ensure end -users are properly trained and ready for RMS subsystem cutover. Completion Criteria. This task is considered complete when: a. The RMS cutover plan is accepted by the City. b. RMS is placed into production operation. RMS Subsystem Reliability Testing. Objective. Verify the level of reliability of the RMS in a production environment. Task Description. The RMS will demonstrate critical subsystem availability levels that meet or exceed the reliability criteria described in the Acceptance Test Plan. Responsibilities. IPS will provide support for the RMS Subsystem reliability testing during the reliability test period as described in the Acceptance Test Plan. If during the reliability test cycle the City identifies a reproducible system error that requires a system or software upgrade, IPS will suspend reliability testing until the correction is implemented. The reliability test cycle will restart once the software patch/upgrade is implemented. The City will: a. Report any significant system failures, as described in the Acceptance Test Plan, promptly to IPS. b. Operate the RMS subsystem in a manner consistent with its specifications, the Contract and the Acceptance Test Plan. Completion Criteria. This task is considered complete after RMS has demonstrated during the test period that it meets or exceeds the reliability criteria described in the Acceptance Test Plan. RMS Final Acceptance, Objective. Certify completion of the RMS subsystem installation. Task Description, Acknowledgement of system acceptance based on the acceptance criteria described in the Acceptance Test Plan. Completion Criteria. This task is considered complete when the RMS subsystem reliability test, as described in the Acceptance Test Plan, has been met successfully completed. Mobile Data Application Subsystem (MDAS) Conduct MDAS Configuration Objective. Provide an overview of the various MDAS configuration options. Task Description. IPS will meet with City personnel to provide information and assistance with the various configuration options available on the I/Mobile and I/LEADS AFR applications. Iteml-HBGeneral_DesignvI2.doc Page 32 Item I - CAD & RMS Scope of Work *Huntington Beach, CA IPS will: a. Review with City personnel the specific MDAS application functionality. b. Describe/demonstrate certain functionality that can be parameterized to meet the City's operations and assist City personnel with making appropriate configuration decisions. The City will: a. Assign appropriate City personnel to attend the pre -configuration workshop. b. Identify the City's MDAS system administrator and assign him/her to attend the pre -configuration workshop. c. Inform IPS of the number of City personnel participants and provide the facilities. Completion Criteria. This task is considered complete when IPS has identified to the City the configurable options for the MDAS application. MDAS Base Software Installation. Objective. Install base MDAS application at IPS facility. Task Description. During this phase, all server hardware will be delivered as part of the CAD server delivery. All applicable baseline MDAS application software, as well as equipment vendor's operating system software, necessary for this phase of the project to be completed, will be loaded on the server. No mobile computers will be loaded at this time. That task will be performed on site on five (5) City provided mobile computers. Responsibilities: IPS will: a. Install the application software at IPS Huntsville, Alabama facility. b. Acquire contracted hardware and software. c. Install the baseline MDAS licensed software within this configuration. d. Test the initial operation of the baseline MDAS subsystem. e. Provide written certification of successful installation. The City will: a. Acquire any required operating system and any other required/specified software. b. Ship City -provided software components to IPS facility. c. Be available to address and answer questions that arise during the installation of the baseline MDAS application software. Completion Criteria. This task is considered complete when the software and third party software have been installed at IPS facility. Install MDAS Equipment. Objective. Transfer all RMS computer equipment and software to the City's facilities. Task Description. All contracted hardware and software will be delivered to the City's facilities. Any additional MDAS hardware and software components included as a contract deliverable will be ordered and delivered at this time. Once on -site, the MDAS servers will be installed in the computer room and the City will inspect the servers for acceptance. The MDAS training mobile data computers will be installed and connected to the MDAS server to test the system, the wireless network infrastructure, facilitate base ItemI-HBGeneral_Designvl2.doc Page 33 Item I - CAD & RMS Scope Mork Huntington Beach, CA software certification, and to provide a training area. Five (5) City provided mobile data computers will be installed with the MDAS application software and connected to the MDAS server to test the mobile data application subsystem and the wireless network, facilitate base software certification, and to provide a training area. Responsibilities. IFS will: a. Assume responsibility for the transportation and final site installation of the contracted MDAS hardware and operating system software configuration. b. Deliver the contracted equipment to the City's designated location, with installation of deliverable central computer hardware, and workstations, printers, modems, and communications equipment (if applicable, and related to the MDAS server or other IPS-provided server hardware). c. Order any remaining IPS-supplied MDAS equipment necessary for the next phases of application software testing, with installation in the City's designated location. d. Install and test, with the City's assistance, the remaining IPS-supplied equipment. e. Provide the City with the training necessary to equip City personnel with the ability to install the MDAS software on the remaining MDAS mobile data computers. The City will: a. Provide a site adequate for the installation, operation and maintenance of all computer server(s), workstation(s) and related peripheral equipment. These facilities will be made available at least two (2) weeks prior to the scheduled installation dates to allow for timely installation. b. Provide all cable runs, pathways, coring, access points, floor cutting or drilling and related tasks related to cable and equipment installation. c. Provide all City -supplied telephone, external interface connection points, electrical power and other receptacles within manufacturer recommended distance of the equipment and all peripheral components. d. Provide adequate air conditioning for the operation of the computer equipment and all peripheral components. e. Provide and install all communication lines, modems, hubs and routers, cabling, equipment and other components necessary for system operation and maintenance that are not identified as deliverable products in the contract. f. Install and verify operation of all locally mounted time source interface equipment, including mounting outside antenna. k. Provide TCP/IP communications and connection to the hub equipment provided in support for any existing networks, workstations and printers that are to have access to the MDAS applications. 1. Install and test any remote workstations and communications equipment. m. Install the MDAS software on any mobile data computers beyond the number to be installed by IPS. s. Provide secure dial -in access using a Virtual Private Network (VPN) or equivalent for IPS remote diagnostic and maintenance of the MDAS subsystem. Completion Criteria. This task is considered complete when the MDAS is installed on the City's premises and verified by the City's Project Manager to be operating in accordance with the MDAS Hardware/Base system Acceptance Test Plan specification. MDAS Configuration Training (I/Mobile Training). Objective. Instruct City personnel on configuration requirements for functional operation of the MDAS subsystem. Task Description. Conduct a two (2) day training course for designated City personnel so City personnel acquire the knowledge necessary to configure the MDAS to meet the City's needs including adding additional data ItemI-HBGeneral_Designvl2.doc Page 34 Item I - CAD & RMS Scope Rork *Huntington Beach, CA fields, reconfiguring screen layout and tab order, and adding additional pages to modules. This class will also teach the creation of narrative templates for use in any narrative text field in LMobile. Responsibilities. IPS will: a. Instruct up to six (6) City personnel, including the MDAS system administrator, on completing the entry of data in the MDAS database tables. b. Instruct training participants on the configuration options for system functionality. c. Provide phone support for participants of the class after training has been completed. The City will: a. Assign appropriate personnel, to include the MDAS system administrator and other participants of the RMS Pre -Configuration Workshop, to attend the MDAS Configuration training course. b. Complete the entry of all data necessary in the MDAS database tables as well as module screen layout and data fields necessary prior to the certification of the system as ready for training. Completion Criteria. This task is considered complete when IPS has provided the described training to City personnel and the system passes its ready for training certification in accordance with the Acceptance Test Plan. MDAS Configuration Support. Objective. Configuration support for trained City personnel on configuration requirements, tasks and methods to achieve operation of the MDAS system. Task Description. Support and consultation for designated City personnel so City personnel can apply the configuration training and knowledge necessary to enter all the data in the MDAS database tables (statute code lists, validation pick -lists, employee information, etc.), to provide oversight and guidance as related to configurable parameters available to meet the City's operational needs of the MDAS. This task may include both on site visits and phone support consultation. Responsibilities. IPS will: a. Provide on -site or telephone -based instruction for all configuration trained City personnel, including the MDAS system administrator, on completing the entry of data in the MDAS database tables. b. Provide support for trained participants on the configuration options for system functionality. c. Upon notification by the City that all configuration has been completed, the assigned IPS engineer will work with the City to confirm parameters and databases are accurate and complete as specified in the Acceptance Test Plan. The City will: a. Assign appropriate personnel, to include the MDAS system administrator and other participants of the MDAS Pre -Configuration Workshop, to work with the on -site IPS engineer. b. Provide work environment with analog phone access for use of the on -site IPS engineer. Completion Criteria. This task is considered complete when IPS and City certify that the system is configured to operate in the manner specified and passes the pre -training portion of the Acceptance Test Plan. MDAS Interfaces. Objective. ItemI-HBGeneral_DesignvI2.doc Page 35 0 Item I - CAD & RMS Scope of eHuntington Beach CA P Develop, install and test all MDAS Interfaces. Task Description. Once the equipment and software have been installed on the City's premises, all remaining local and remote interfaces as specified in the list of deliverables in the contract documents will be developed, installed and tested. Responsibilities. IPS will: a. Design, develop, transfer, install, and unit test all software required for the MDAS interfaces described in the Component and Price Exhibit, resulting in their operating in accordance with the interface control documents. b. Identify all required information on record layouts and documents necessary to establish interfaces with all local and remote systems and facilities prior to installation. The City will: a. Provide requested information on record layouts and documents necessary to establish interfaces with all local and remote systems and facilities at least thirty (30) calendar days prior to scheduled interface work. b. Provide all required liaison support with the agencies and vendors required to support the interfaces. c. The City will make best efforts to ensure that necessary certifications and approvals will be completed by the City at least thirty (30) calendar days prior to scheduled interface implementation. d. Provide all required liaison support with the agencies and vendors required to support the interfaces. e. Ensure that the necessary technical support is made available for installation, testing and demonstration of the interfaces. Completion Criteria. This task is considered complete when each interface is installed, unit tested and passes Acceptance Test Plan criteria for the interfaces. The operation or availability of the external system or third -party software is necessary for task completion. Deliver the MDAS Documentation. Objective. Deliver the MDAS Documentation to include training guides, reference guides, configuration guides, system administration manuals and related standard documentation. Documentation for any contracted customization will be included as separate documentation. Task Description. Deliver the standard MDAS documentation, documentation for any contracted customization and documentation on completed MDAS interfaces. Responsibilities. IPS will: a. Deliver the standard MDAS guides, manuals and related documents. b. Provide documentation on any required customizations for the City. c. Supplement the interface control document, as needed. The City will a. Review the MDAS specification and interface control documents (described above) submitted by IPS and identify in writing any specific errors and/or omissions found within thirty (30) calendar days of receipt. Iteml-HBGenerai_DesignvI2.doc Page 36 Item I - CAD & RMS Scope of p k *Huntington Beach, CA b. Is able to make unlimited copies of supplied documentation for City usage Completion Criteria. This task is considered complete upon delivery of the standard MDAS documentation, documentation on any required customization and interface control documents. Develop MDAS Acceptance Test Plan. Objective. Develop a mutually agreeable MDAS Acceptance Test Plan. Task Description. The Acceptance Test Plan (ATP) will include the following sections: a. Define all applicable functions and features of MDAS and describe how those items will be verified. b. Define Level 1, Level 2, and Level 3 errors. Level 1 errors must be fixed before tests can be successfully passed. Level 2 errors must he fixed during the extended warranty period. Level 3 will be fixed in a mutually agreed upon timeframe.. c. Define the procedures for certifying that subsystem hardware is functioning correctly (computer hardware acceptance/certification) d. Define the specific interfaces in the MDAS and describe how these interfaces will be verified e. Define throughput measures and response times that will be used to verify the specified system response times and throughput. f. Define the reliability period during which the system will operate as specified without encountering any significant downtimes or response time/throughput degradation. Responsibilities. IFS will develop an initial draft Acceptance Test Plan for review by the City. The City will review the initial draft for the Acceptance Test Plan and work with IPS to define a mutually acceptable final ATP. Completion Criteria. This task is considered complete when IPS and City have approved and signed off on the Acceptance Test Plan. MDAS Functional Testing. Objective. Perform functional tests of the MDAS. Task Description. Test and verify the applicable functions and features of the MDAS as defined in the Acceptance Test Plan. Responsibilities. IPS will provide support for the functional MDAS during the acceptance test as described in the Acceptance Test Plan. The City will: a. Generate production data files needed for functional testing. b. Perform the functional MDAS acceptance test as described in the Acceptance Test Plan. Completion Criteria. Items-HBGeneral_DesignvI2.doc Page 37 0 Item I - CAD & RMS Scope of Work *Huntington Beach, CA This task is considered complete when MDAS has been demonstrated to function in accordance with the Acceptance Test Plan. MDAS Technical/User Training and Documentation. Objective. Conduct the MDAS technical and user training. Task Description. IPS will conduct their standard training courses to thoroughly train City Training personnel on the use of the MDAS subsystem and City Technical personnel on the operation and support of the MDAS subsystem as described in the Training Plan. Completion Criteria. This task is considered complete when the scheduled technical and user training on each installed MDAS module is completed. MDAS Production Cutover. Objective. Place the MDAS into Production Operation. Task Description. Auer user training , functional testing , and integration testing is complete, IPS will certify the MDAS subsystem as operational and ready for production operation and assist the City in placing the subsystem into productive use. IPS personnel will be on site for pre -live cut and post -live cut support. IPS personnel will also fine-tune the MDAS software application for optimal performance. After live cut, IPS software warranty period and the 30-day reliability test period will begin. Responsibilities. IPS will: a. Develop a mutually agreeable MDAS cutover plan. b. Assist the City staff in placing the MDAS into a production status as specified in the MDAS cutover plan. c. Monitor the initial operation of the MDAS and answer any operational questions raised by the City. d. Assist the training staff in utilizing the subsystem and the computer operations staff in supporting the subsystem. The City will: a. Place the software into production and begin operational use in consultation with IPS and in accordance with the Project Schedule. b. Ensure end -users are properly trained and ready for MDAS subsystem cutover. Completion Criteria. This task is considered complete when a. The MDAS cutover plan is accepted by the City. b. The MDAS is placed into production operation. MDAS Subsystem Reliability Testing. Objective. Verify the level of reliability of the MDAS in a production environment. Task Description. Iteml-HBGeneral_DesignvI2.doc Page 38 item I - CAD & RMS Scope of Work *Huntington Beach, CA The MDAS will demonstrate critical subsystem availability levels that meet or exceed the reliability criteria described in the Acceptance Test Plan. Responsibilities. ITS will provide support for the MDAS reliability testing during the reliability test period as described in the Acceptance Test Plan. If during the reliability test cycle the City identifies a reproducible system error that requires a system or software upgrade, IPS will suspend reliability testing until the correction is implemented. The reliability test cycle will restart once the software patch/upgrade is implemented. The City will: a. Report any significant system failures, as described in the Acceptance Test Plan, promptly to IPS. b. Operate the RMS subsystem in a manner consistent with its specifications, the Contract and the Acceptance Test Plan. Completion Criteria. This task is considered complete after the MDAS has demonstrated critical system availability levels during the test period that meet or exceed the reliability criteria described in the Acceptance Test Plan. Final System Acceptance. Objective. Certify completion of the CAD, RMS and MDAS subsystem installations. Task Description. Acknowledgement of system acceptance based on the acceptance criteria described in the Acceptance Test Plan Section. Completion Criteria. This task is considered complete when a. The CAD, RMS and MDAS reliability tests are completed successfully b. The CAD, RMS and MDAS are fully integrated/interfaced with each other as specified herein and in the Acceptance Test Plan and contract. 11.3. Training Plan The Training plan is a comprehensive list of the purchased classes and suggested attendees. The initial plan is included here and may be refined as necessary during phase II of the project. The following is a list of training courses provided by IPS to the City of Huntington Beach. The Training Course Catalog included in the Detailed Design Document contains details of each course. In addition to the courses listed in this document a provision is being made for two general CAD and RMS additional "customized courses". The content of these courses will be determined during the course of system implementation. These training classes will be incorporated in the project schedule to best fit the many schedule issues facing the City and provide for a smooth transition into the new system. 11.3.1. IILEADS Training • I/MARS User • WARS Administrator • I/LEADS Administrator • I/LEADS SysGUI Workshop • I/LEADS Train -the -Trainer Iteml-HBGeneral_DesignvI2.doc Page 39 4 Item I - CAD & RMS Scope of Pork •Huntington Beach, CA • I/LEADS Field Reporting • I/L.EADS System Overview 11.3.2. IICAD Training • IICAD System & Data Overview • IICAD Train -the -Trainer • IICAD System Administrator I • IICAD System Administrator II • IICAD Database Maintenance (CADDBM) • IINetViewer and I/NetDispatcher Train -the -Trainer • I/Mobile Train -the -Trainer • Supporting Windows 2000 for IPS Systems • IICAD Map Fundamentals Workshop • IICAD Map Tools (CADTools) • IICAD Map Maintenance • MicroStation Fundamentals for Mappers 11.4. Go Live Plan The Go Live Plan is a list of items, descriptions, suggestions, and possibly work flows recommended by IPS for a successful startup of the CAD, RMS, and MDAS systems. The plan requires assistance from the City to allow for agency specific actions and personnel scheduling. Although IPS will be making planning recommendations and providing Go Live assistance on site, the City shall properly plan and staff in a manner to ensure successful transition to the new systems. 11.5. Performance Standards The Performance Standard set forth below shall apply to the SYSTEM. Reliability Standard: The SYSTEM shall be fully operational and available for use by the CITY as set forth herein, excluding scheduled downtime, external interface failures, and network outages not caused by the SYSTEM, provided the SYSTEM is installed, using the hardware in accordance with proposed. a. CADS —Ninety-nine and nine tenths percent (99.9%) of the time. b. MDS--Ninety-five percent (95%) of the time. c. RMS—Ninety-seven percent (97%) of the time. Load Capability. The SYSTEM shall handle at least one hundred and forty (140) incidents per hour. IPS agrees to add testing of one hundred and forty (140) incidents per hour to the Acceptance Test Plan. As part of the Acceptance Test, the CITY will generate the activity by using real or test case events that simulate standard operation. Resi2onse Time Standard: CAD provides sub -second response times to 90% of calltaking and dispatching commands, including the dialogs and the map. Queries are less than 5 seconds 90% of the time and are performed in the background to not interface with calltaking and dispatching commands, and notifying the operator when they are complete. Query performance excludes queries to external systems whose performance is beyond the control of CAD and IPS. Reports may take from seconds to minutes, depending on data volumes and report complexity, but also run in the background. A separate but related subject is that of system loading. IPS agrees to simulate a load equal to that projected for the City, to show how the system performs under that load, using the City's system, as part of acceptance testing. Items-HBGeneral—Designvl2.doc Page 40 Item I - CAD & RMS Scope of Work *Huntington Beach, CA Performance Evaluation Results If the Performance Standard is not achieved as defined in this Paragraph, the CITY will provide IPS written notification documenting that the SYSTEM does not meet the Performance Standard. IPS shall provide the following at no additional expense to the CITY: a. IPS shall assist the CITY in evaluating the existing SYSTEM configuration and make recommendations for actions. IPS shall make every effort to maximize the performance of the SYSTEM. b. In the event that IPS determines that the SYSTEM fails to perform on properly functioning hardware provided by IPS, ITS will upgrade the hardware. 11.6. Project Schedule During the initial phase of the project, a comprehensive schedule will be developed with the City to cover all the tasks and milestones of the project. This schedule will become the guidepost of the entire project, showing what's been finished and what's coming next. Final scheduling can only be completed after a complete project review and evaluation has been completed. The final schedule is a mutual effort and is agreed upon by all parties. 12. RI`P Clarifications - General Ref: Item #3 — Proposed system should be GUI based and Internet/browser based for extended users The proposed system is GUI -based. Internet/browser-based interfaces are currently supported only through export of data from the system to a different database. For example, one that can use Active Server Pages, such as Microsoft ACCESS. IPS maintains an open and active position with respect to the use of Internet technologies for I/LEADS. Ref: Item #7 — All system entry, display, inquiry, and report screen formats must be user -definable, and the Vendor must provide all software tools necessary to create or alter these forms. Dialogs will be configured to the City with minor changes during implementation. Creating new reports can be made using Microsoft ACCESS, which is included. Ref: Item #15 - The system should provide the capability to display any information subordinate to the primary search key without losing the primary search key. A return to primary record screen should be invoked with a single keystroke (i.e., ESCAPE back to previous screen). When queries are done a summary list is maintained and used on the primary key. The list can be returned by hitting a button or using the next & previous buttons on a form. Ref: Item #16 - Provide user the ability to define the order and content of entry screens and automatically populate matching fields from screen to screen (Auto -branching) IILEADS is based on a standard Microsoft Windows GUI. The order and content of entry screens is determined by selecting a module, followed by entry of required data fields typically displayed in tabs. Tabs are generally activated as required fields are entered, otherwise, they can be related in the preferred order. Matching fields are populated from control to control. IPS will assist the City in configuring the tab order to facilitate easy data entry. Ref: Item # 3943 - Provide audit trail of database updates capturing the following information: Audit trails are provided that enable a properly authorized user to inspect the time a field is modified, the id of the person making the modification, node from which the change is made. In some cases, a pre and post value is maintained as well as the type of transaction being audited. IPS asserts this meets the requirement as stated. Ref: Item #56 — An entire database response can be printed on request, regardless of the page currently displayed. A screen can be printed on request using screen printing options. However, it must first be selected and populated via a query. Item1-HBGeneral_Designvl2.doc Page 41 Item I - CAD & RMS Scope offork *Huntington Beach, CA Ref: Item #57 - Selected portions of a displayed message can be printed on request. This is supported only by cut & paste utilizing another tool such as MS WordPad Ref: Item #81 - New features of upgrade or enhanced releases support toggle "on" or "off' for each new feature or function. This is true in most cases. Add -in and configuration options support this. In some cases, new features are enabled as -is and the City cannot toggle these. Ref: Item #82 - !Menus are supported as a training aid but are not required for system operation. Ii'LEADS provides a Windows -compliant GUI. Menus are required for system operation. Alternatives are provided for some windows in the form of buttons that can, for example, open a module. Ref: Item # 104-106 — The system has an interface allowing the capability of Time Synchronization with voice recorder and VESTA telephone system. IPS will provide a copy of the XNTP software (publicly available software from University of Delaware) that IPS has ported and tested on Windows NT. This software provides the interface to an external clock device (such as the Spectracom Netclock/GPS), plus an executable that allows other CAD workstations to be synchronized from the timeserver via XNTP. This interface requires an RS-232 serial port on the communications server. Other devices in the communications center may be synchronized from this master timeserver. If they are personal computers running Windows NT or Windows 2000, the XNTP process may be used to perform synchronization. Spectracom's TimeTap Time Distribution Modules may be used to connect a device that accepts time code data stream in Format 0 or Format 1 over an RS-232 connection. Up to 32 TimeTap modules may be connected to the Spectracom NetClock/2 time source, providing RS-232 time feeds for up to 32 distinct devices in the dispatch center. Ref: Item #179 - User agency can choose to use County switch provided forms or forms created by user in RNIS system. User agency can continue to use current forms, but if they do, they will not have a method for linking County switch to an I/CAD event. Use of I/Informer would provide this linkage. Ref: Item #180 - User capability to maintain forms Inquiry and interface access to external systems without vendor support. This can be done by the City but server interface maintenance requires vendor support. Ref: Item # 188 - Responses in a queue can be printed. Need more information. In I/LEADS, a response to a message is read via the organizer window. The user has the option to print, clear, or save the response with a link to the item queried. Ref: Item #191 - Recovery of an NCIC entered stolen vehicle automatically generates Locate or Clear message depending upon ORI. Users can create, locate, and/or clear stolen vehicle, property, etc. templates. Once the messages are created, they are available via a toolbar selection from the associated module. It requires a specific action by the user to invoke the message; it is not fully automatic. Ref: Item # 217 - Produce current "hot sheet" of stolen or wanted vehicles based on local database records. IPS will produce a custom report to meet this requirement @ No Charge. Ref: Item #226 - E9-1-1 ANIIALI - File Transfer E9-1-1 ANIIALI Information will transfer into the City of Huntington Beach IPS I -CAD from the Verizon 9- 1-1 system via the ANIIALI interface. IPS I -CAD will meet FCC Docket No. 94-102 and 99-245 Phase I and Phase II wireless requirements, properly populating IPS I -CAD fields and displaying the wireless ALIIANI information for FCC Phase I and Phase II standards. There will be no additional charge to the City of Huntington Beach to have IPS configure the interface that properly transfers all FCC Phase I and Phase II ItemI-HBGeneral_Designvl2.doc Page 42 Item I - CAD & RMS Scope of Work Huntington Beach, CA wireless information fields to IPS CADS. This cost will be covered under initial implementation and/or yearly maintenance agreement. At implementation, IPS will configure a function key that transfers (dumps) the 139-1-1 information into the 1-CADS. Iteml-HBGeneral_DesignvI2.doc Page 43 • ITEM II CAD System Detailed Design For City of Huntington Beach, CA Prepared by Intergraph Public Safety Revised 1.2/19/02 Item II - CADS stem Detailed Desi n Wuntington Beach, CA Y g Table of Contents 1. CAD Overview....................................................................................................................................... 3 I.I. CAD Application Software........................................................................... .......................... .... 3 1.2. CAD Map Creation...................................................................................................................... 3 1.3. CAD Functionality .......................... ............ 1.4. General Features.......................................................................................................................... 4 1.5. Calltaking.................................................... ................................................................................5 I.G. Dispatching..................................................................................................................................6 1.7. Command Line Entry..................................................................................................................8 1.8. CAD Standard Reports................................................................................................................ 8 2. I/NetViewer.................................................................................................. 1044 3. lNe tDi spatcher................................................................................................................................. 1044 4. CAD Interface Software................................................................. .. 114-2 4.1. I/Mobile................................................................................................................................. 114-2 4.2. I/Mobile Data Terminal......................................................................................................... 124-3 4.3. I/Informer.............................................................................................. 1344 4.4. I/Page..................................................................................................................................... 1546 4.5. I/TDD ..................................... ............................................................................................... 154-6 4.6. I/PTT....................................................................................I............. .. 154-6 5. I/CAD RFP Clarifications................................................................................................................. 164-7 ItemII-HBCAD_Designv9.doc Page 2 0 Item II - CAD System Detailed Design g *Huntington Beach, CA 1. CAD Overview 1.1. CAD Application Software The I/CAD system includes a suite of applications. These software applications are usually categorized as either Application Software or Interface Software. The following section will describe details about the Application Software components. CAD Application software will be delivered to you on a custom-made CD and your IPS Implementation Engineer will copy these applications into a folder on one of your servers, and then share that folder so it is available over the network. This share is sometimes referred as the IPS delivery share. Any time that IPS issues new or upgraded software it will be delivered to this share and then distributed to the locations within the system. The price sheet details the list of IPS software required on each server and workstation in your CAD system. 1.2. CAD Map Creation IPS will build the CAD system based upon address verification supplied by a GIS department. This address verification will be based on one or both of two methods: street segment data and/or parcel point -in -polygon address data. IPS will configure, at implementation, a hybrid of the two methods, if requested by the City of Huntington Beach PD. The data is critical because it will basically run the CAD data entry process. The mapping solution will display center lines and meet FCC Docket No. 94-102 and 99-245 Phase I and Phase II wireless requirements, The IPS mapping system will have the ability to define a street in multiple reporting districts and multiple jurisdictions (see attached diagrams). The IPS mapping system uses center location at cross streets. The reporting district and beat will be determined by either 1) the polygon that the intersection falls or 2) the City can specify a specific reporting district for the intersection to fall in. If the dispatcher wishes, the dispatcher can manually update the address point of the call to whatever corner of the intersection they would like and whichever reporting district polygon that point falls within will be the reporting district for response. A description of the map conversion process is provided in the CAD DSD. IPS will need to receive the intended intelligent street and parcel data and analyze it for structural integrity and content. During this implementation stage IPS will validate for format of the database information received, and possible graphical inadequacies. Once the implementation analysis has been achieved, IPS will report back to the City with the results, and then continue to train the City in both map maintenance and manipulation. The three courses bid for the system (Map Workshop, CADTools Training, and Map Maintenance Training), will cover the investigation and creation of the dataset, regular maintenance of the system, and then how to incorporate those changes into live CAD, with no detrimental affect to the CAD users. ItemII-14BCAD—Designv9.doc Page 3 0 Item 1I • CAD System Detailed Design *Huntington Beach, CA 1.3. CAD Functionality 1.4. General Features When dispatchers are responsible for handling both call -taking and dispatching operations, the I/Dispatcher product is used; when the separation of call -taking and dispatching duties is required, the I/Dispatcher software module is proposed. I/Dispatcher is essentially a subset of the I/Dispatcher software but retains only the commands needed to support call entry and event creation and the routing of calls to a dispatcher. It provides a low-cost product for customers desiring to separate the calltaking and dispatching functions and can be supported using either a single- or dual -monitor workstation configuration. In either configuration, windows are used to display both data entry forms and the integrated graphical map. In the typical dispatch setting, a dual -monitor workstation is recommended, with one screen often displaying the graphical map and the other displaying dialog boxes, forms, or windows supporting the dispatching operation. The following picture illustrates the dual -monitor dispatching environment. A single mouse and keyboard are used to communicate with both monitors. Windows and icons can be moved as operator needs dictate. Windows, including the map window, may also be dismissed, resized, and minimized. To activate a window, the operator simply clicks anywhere on the window and the title bar changes color to visually indicate that the window is active. The operator can also easily switch to another window by using the ALT/TAB keys to cycle through open applications. The spatial relationship of emergency vehicles to incident locations is displayed on the map, complete with roadways and jurisdictional boundaries. Dispatchers can quickly identify the most appropriate response personnel and judge the fastest and safest route to the event. The IICAD System uses both graphic and non -graphic information to determine real-time vehicle position, provide automatic dispatch recommendations, and assist in optimal path planning. The I/CAD map is very robust. There is no practical limit to the amount of information that can be displayed on the fully interactive, intelligent map. In addition to streets and highways, the map can display building footprints, HazMat (hazardous information) flags, fire hydrants, power lines, rivers, lakes, and railroad lines. These intelligent maps are not just pictures on a screen —they are "smart" maps. All information regarding map features that has been stored in database records is available for immediate data recall. The operator can query the system by simply pointing and clicking on symbols on the map. Using the street network, the system can route units to locations by the shortest time, shortest distance, fewest turns or intersections, and minimum risk involved. When a dispatcher has closed a street, the system can route units around the closure. Master Clock Functions CAD Server 2 IPS will provide a copy of the XNTP software (publicly available software from University of Delaware) that IPS has ported and tested on Windows 2000 & I`T. This software provides the interface to an external clock device (a Speetraeom Netelock/GPS is proposed), plus an executable that allows other CAD workstations to be synchronized from the timeserver via XNTP, The master clock allows CAD to synchronize & track Call Time Received, Time Dispatched, Enroute time, Arrive on scene time, and Response times. This interface requires an RS-232 serial port on the communications server; please be sure that one is available for this purpose.The system has an interface allowing the capability of Time Synchronization with voice recorder and Vesta telephone system. IPS will ensure that the XNTP software and executable reliably synchronize the CAD workstations, avoiding skewed computations for Call Time Received, Time Dispatched, Enroute time, Arrive on scene time, and response times. ItemII-HBCAD_Dcsignv9.doc Page 4 Item 11- CAD System Detailed Design -'Huntington Beach, CA 1.5. Calitaking Whether a dispatcher or calltaker takes the call for service, I/Dispatcher automates a process that dramatically reduces human error. In multi -agency communication centers, each agency can customize the forms to accommodate their own methods of gathering and recording information. I/Dispatcher onscreen forms show operators what information to record. The ANUALI (automatic number identification / automatic location information) data from the Enhanced 911(E9-1-1) telephone database is immediately loaded into the form. After validating the location and type of event with the caller, the touch of a button sends this basic information to a dispatcher. The calltaker can then gather additional details. Calitaking Features Event location Calltakers can enter locations in several ways, including specific addresses, street intersections, commonplace names, or aliases. Or locations can be entered graphically by using the mouse to identify a point on the integrated map. When a location is verified, I/CAD automatically zooms in on the map and places a pointer at the reported location, providing immediate feedback on current activity. When a misspelled, sound -alike, or alias street name is entered,, the system presents a list of correctly spelled possible choices. If the event location as entered is insufficient for positive identification, a list of likely choices is displayed. The Location Verify command will also provide the calltaker with information on stationer beat, proposed dispatcher assignment, jurisdiction, and subdivision. Event types Event types vary by jurisdiction and agency. I/CAD allows each agency to customize the event types it uses, such as 10-codes and abbreviated -name codes. An experienced calltaker can, at the touch of a button, bring up an associated list to make a selection. An event type will supply the calltaker with information on priority and response (police, fire, medical, or a combination) and will carry with it valuable information for use by the dispatcher. E9-1-1 call processing when interfaced with E9-1-1, the system automatically downloads ANI/ALI data to the appropriate fields. E9-1-1 ANUALI Information will transfer into the City of Huntington Beach IPS I -CAD from the Verizon 9-1-1 system via the ANI/ALI interface. The IPS I -CAD will meet FCC Docket No. 94-102 and 99-245 Phase I and Phase II wireless requirements, properly populating IPS 1- CAD fields and displaying the wireless ALUANI information for FCC Phase I and Phase II standards. There will be no additional charge to the City of Huntington Beach to have IPS configure the interface that properly transfers all FCC Phase I and Phase II wireless information fields to the IPS CADS. This cost will be covered under initial implementation and/or yearly maintenance agreement. At implementation, IPS will configure a function key that transfers (dumps) the E94-1 information into the I -CADS. If necessary, however, E94-linformation automatically transferred to the dialog can be overridden by the operator. Remarks Calltakers can enter specific remarks associated with an event. This feature is invaluable in better defining situations that responding units are likely to encounter. Calltakers can also access customizable supplemental forms to enter suspect information, vehicle information, or patient statistics that can be searched later. Location of Interest When a calltaker enters a new event, the system starts a Location of Interest (LOI) check. LOI checks VCAD and appropriate external systems for:information pertinent to the location of the event. For VCAD-based information, this is not a matter of simply looking up and down the same block or the next block. With powerful graphics -based location processing, VCAD actually looks ItemIl-HBCAD Designv9.doc Page 5 0 Item II - CAD System Detailed Design *Huntington Beach, CA around the neighborhood. Any operator looking at an event after the LOI is completed can simply select the highlighted LOI button to access background information. Imagine HAZMAT records, medical histories, and major -call records being automatically found and available at the touch of a button. Information sharing Through a variety of tools included in I/CAD, calltakers can effectively and efficiently share information with dispatchers, administrators, and field units. Messaging, broadcasts, road closures, hospital status, real-time updates to hazardous condition locations, and more are available to the calltaker. Interactive map display Operators can display a map on the workstation screen that shows the coverage area and all active incident locations. Incidents are automatically flagged onscreen as soon as the calltaker verifies the location. The flag remains onscreen as long as the event is active. The calltaker can select multiple map views and display them in different windows. Enhanced calltaking performance Calltakers can increase their efficiency by using a number of tools provided, including: • Copying Events - Calltakers can generate a new event from an existing event in multiservice environments. • Dgpllcate Call Detection - New event processing looks around the neighborhood for an existing activity. A calltaker can associate the information he or she receives to an existing event or create a new response. • Nqn-Standard Event Record Entry — Emergency Event, Hot Call, Scheduled Event, and Advised (Record Only) can be assigned at the touch of a button. • Event Cancellation - Once the event is routed to a dispatcher, a cancellation may be requested. However, even if an event is cancelled, the event history is never deleted from thQ system database. • Multiple Call Processing Capability - For peak times when more calls are received than cats be immediately processed, I/Dispatcher provides the flexibility to take partial information on a low -priority call, set it aside, and answer a higher priority call. Other dispatchers do not see the low -priority call until the calltaker creates the event, and the calltaker is not required to repeat the same questions to the caller or re-enter information. Stacked calls are monitored by I/CAD and the operator is reminded of pending calls with alarms. • Hot Calls - The "Hot Call" processing capability allows an operator to designate a call as one demanding immediate response, sending it to the dispatcher while the calltaker continues to gather information. 1.6. Dispatching When I/Dispatcher is combined with I/Calltaker, System Status Planning, System Status Monitoring, radio interfaces, and powerful reporting tools, agencies can be confident that the correct information is available to help them make the right decision. The IPS Intel and Windows NT/2000 platform allows dispatchers to use their existing PC knowledge, quickly adapting to the IPS user-friendly I/CAD System. ItemII-HBCAD_Dc8ignv9.doc Page 6 Item II - CAD System Detailed Design 'Huntington Beach, CA DisaatchineFeatures Recommend units -I/Dispatcher provides several ways for the dispatcher to recommend units. The beat and station order is the standard for most responses. But where flexibility is needed, I/Dispatcher can make recommendations by the closest unit (real distance, not "as the crow flies") or by special equipment needs. Integrated mapping The I/CAD map is the most robust in the industry. There is no technical limitation on the amount of information that can be displayed on the fully interactive intelligent map. In addition to streets and highways, building footprints, HAZMAT flags, fire hydrants, power lines, rivers, lakes, railroad lines, and much more can be displayed. IPS intelligent maps are not just pictures on a page. They are "smart" features that can include extensive database records for immediate data recall. The dispatcher can query the system by simply pointing and clicking on symbols on the map. Using the street network, the system canroute units to locations by the shortest time, shortest distance, fewest turns or intersections, and minimum risk involved. Pending events As new calls for service arrive, dispatchers are presented with meaningful summaries, plus an easy -to -view graphic representation of what is happening in the area. An indicator is activated that denotes new event information, and the touch of a button displays the new event. Pending event summaries can be sorted to appear in any style the dispatcher prefers, with the standard being the event of the highest priority. Selecting events Selecting an event to be reviewed for action has never been easier — whether it's a New Event, Updated Event, Late Response, or others, simply touch a button. The dispatcher can select any event at any time by specifying the event or unit assigned within the enhanced graphical user interface (GUI) or the command line. Holding events I/Dispatcher is completely flexible when it comes to processing events: schedule an event for later - action (even tomorrow or next week), hold an event for a specific time, or assign multiple events to the same unit. Other options exist to aid the dispatcher in times of heavy demand. Location of Interest An integral part of I/CAD is Location of Interest (LOI). This powerful query tool runs automatically in the background every time an event is entered. Searches of I/CAD database references are fast and efficient. Unit status As with many of today's advanced CAD Systems, I/CAD allows the dispatcher to track the full array of unit activity. However, I/CAD goes beyond simple Dispatch, Enroute, and Arrive functions. Commands such as Available of Pager, Available First Responder, Available on an Event, Unit Warnings and several others are provided to improve dispatcher productivity. The link between text status displays and graphic status displays is seamless. Transferring events and units A dispatcher can transfer any available unit or an event and all its units to another dispatcher. Once transferred, units display at the new workstation like those already controlled there. Unassigned events can be transferred to other agencies as well. ItemH-HBCAD Designv9.doc Page 7 • Item II - CAD System Detailed Design Huntington Beach, CA Information sharing A dispatcher can ensure that all information is recorded and available. Road closures, hospital status, temporary LOI records, and real-time and scheduled messaging are just some of the information available. Deployment plan initiation The system can store multiple dispatch or deployment plans for different agencies and situations. A single command activates a new deployment plan, automatically changing the way the system makes its response recommendations and backup beat assignments. Reporting flexibility I/Dispatcher comes with a standard set of output reports summarizing police, fire, EMS, and communications center operations activity. The summaries include events by type, average response time, multi -alarm incidents, out -of -service times, event handling times, calls per hour, and unit workload averages. Included with the system are the tools that allow agencies to easily customize reports to meet their particular needs. Through the use of the SQL Server database, the IICAD system can store any number of records for an agency's use, such as personnel records or building floor plans. With our proven interfaces, the system can also access external databases, including the National Crime Information Center, the National Law Enforcement Telecommunications System, and state and local databases. 1.7. Command Line Entry The City of Huntington Beach has requested that CAD be configured for command line and macro use. Please refer to the document titled CAD Command Line Reference for a list of the command line entries available in the CAD COTS product. Additional command line entries, including macros, may be configured at the specific request and mutually agreed upon format between the City and IPS project managers. 1.8. CAD Standard Reports The report module in the IICAD System includes a set of 18 generic, standard reports. Others may be written on -site with tools provided with the system. Standard reports are requested using dialogs that resemble other dialogs used in the database and map maintenance and in IICAD. The following paragraphs briefly describe the reports delivered with the IICAD System: • Event Snapshot --provides a snapshot of pending events, unit status, and a chronology of events, comments, and unit activity over a specified timeframe • Events by Type --calculates the number and type of events, per agency, that have been processed within a user -specified timeframe. The data is ordered by event type code within the agency • Events by Source and Priority —provides the number of incidents by agency, priority, and call source, that have occurred within a user -specified timeframe • Events by Source, Day of Week, and Hour of Day ---compiles a listing of events by the day of the week and the hour of day in which the events occurred, according to the agency and call source. The reporting timeframe can be user -defined • Event Handling Time —lists the number and type of events, per agency, computing the average and maximum times used to address the events. The reporting timeframe can be user -defined • Event Register —catalogs detailed information, by agency, regarding events and provides the event type, location, event receipt time, beat, emergency service zone (ESZ), and the dispatch group that addressed the event. Unit information is also delineated, Itemlf-HBCAD_Designv9.doc Page 8 • Item II - CAD System Detailed Design 611untington Beach, CA including the units assigned to each event, unit dispatch time, unit arrival time, time the unit became available, and the personnel. staffing the units. The City has mentioned 4 different reports that are needed. Daily Log, Briefing Log, Officer Activity, and Golden West log. IPS will produce the Officer Activity Log report. The Event Register Report includes all fields on the Daily Press Log with the exception of DR # and Disposition Code. City system administrator will add the additional fields if still required. The Event Register Report includes all fields on the Briefing Log with the exception reporting party name, reporting parry address, and reporting party phone ##, DR#, and disposition code. City system administrator will add the additional fields if still required. The City will produce the Golden West Log report. • Calls for Service —lists, by agency, the number of calls for service by day of week for a user -specified timeframe • Calls per Hour of Day ---provides, by agency, an hourly breakout of the number of calls for service received over a user -specified timeframe • Address Validation --provides information on addresses that are unverified as part of dispatching operations. This report can then be used as a tool to update the geofile and map data • Average Response Time per Hour of Day --computes, by agency and hour of day, a summary of the number of calls received and the average length of time that was required to respond. The reporting timeframe can be user -defined • Logged On Duty Time --calculates the amount of time operators have been logged onto the I/CAD System. The information is reported by agency, operator name, and day of the week within a user -specified timeframe • Logged On Duty Position —provides information on operator position assignments over a user -specified period of time. The information is reported by operator, terminal identification (ID), and day of week of the assignments • Unit Workload —lists, by agency, each unit and the number of events that unit has responded to over a user -specified timeframe • Units' Time In Service —chronicles, by agency, the logged on time, time spent on assignment, and the time spent out of service for each unit. The reporting timeframe can be user -defined • Operator History --provides a historical listing of the events that specific operators have addressed within a user -specified period of time. The information is listed by operator ID and contains event data, such as the event number, date and time of event, and any remarks associated with the event • Officer History —provides a historical listing of the events that specific officers have handled over a user -specified period of time. The information is ordered by officer ID and contains event data, such as the event number, date and time of the event, and any remarks associated with the event • Wrecker Rotation —provides an index of wrecker companies that are available for service calls. The report lists the companies in the order in which they should be called by placing the wrecker company with the oldest date at the top of the list • Wrecker Information —itemizes wrecker company services. Information provided includes company name, equipment, phone number, date last used, and availability ItemIl-HBCAD_Designv9.doe Page 9 • Item 1I - CAD System Detailed Design 614untington Beach, CA 2. ffletViewer liNetViewer allows personnel throughout your agency to get to the dispatch information they need without having special CAD software installed on their computers. A user can access current and historical information from the Intergraph Public Safety Computer Aided Dispatch (I/CAD) System in a very secure manner. I/NetViewer is an excellent means for providing remote users with a view into the system, for retrieving information on units and pending and active events, and for initiating limited activities in the system. I/NetViewer relies on standard intranet technology. Installation, updates, and maintenance of the software are accomplished from a single, central site, making it unnecessary to maintain software on remote computers. The access provided by IJNetViewer is strictly controlled by a sophisticated security system. User access is restricted at both the application level and the operating system level. The system uses 128-bit, dual -key encrypted Internet security, allowing access to authorized users only. I/NctViewer also enables you to initiate limited activities in the I/CAD System. Using the browser software, you can create a call for service, place a unit in or out of service, update personnel lineups, and send a message to any user on the system, including mobile users, In addition to providing a view of the agency's resources and workload, I/NetViewer allows you to accomplish a number of other tasks. Using the browser interface, you can retrieve historical information — for example, a listing of a particular unit's activities for the past week or the number of traffic accidents reported during a particular month. I/NetViewer also permits you to access operational information to determine who is on duty, what special equipment they have in their vehicles, and any specific skills they have, such as speaking foreign languages. UNetViewer Features: • Monitor pending events and unit status. • Display an I/CAD map with appropriate windowing operations to view location of events and units. • Configure monitor display and the map within a single browser page. • Query unit and event details, including supplemental event information. • Create a simple I/CAD event and add comments. • Take individual units in and out of service. Display and edit unit personnel, equipment, location, and mileage and receive VCAD messages among calltakers, dispatchers, MDTs, pagers, and other I/N`TetViewer clients. • Create, update, and view I/CAD lineups. • Query unit history, summary, equipment, roster, and lineups. • Search for events or supplemental information. • Query signed -on users and database status. 3. I/NetDispatcher VNetDispatcher represents a powerful extension of Intergraph Public Safety's popular LNetViewer product. It takes the capability of INetViewer and creates a tool for use by the "non -power" dispatch user in creating calls, assigning resources, and managing the call to final resolution, all via the standard Microsoft Internet Explorer. Locations remote from the Communications Center, such as Police Precincts, can use the I/NetDispatcher product on leased or dial -up connections; yet still have access to a wide range of event and mobile resource management functions. Itemll-HBCAD_DesignAdoc Page 10 Item I1- CAD System Detailed Design Wuntington Beach, CA IINetDispatcher Features Additional commands available in the I/NetDispatcher product allow the user to: • Dispatch Units • Update Unit Statuses • Clear Units from Events • Dispatch Assign Events to Units • Preempt Units • Put Events on Hold • Update Event Location and Incident Type • Cancel Events • I/NetDispatcher includes a unique graphic user interface, including dynamic context driven popup menus and drag -and -drop functionality. 4. CAD Interface Software The following Interfaces will be installed on the Communications Server • IlMobile — Mobile Data Client • M/ OT — Mobile Data Interface Module • L'Informer — Interface to OC switch for NCIC, CJIS,NLETS,OCATS,DMV and VL.EADS •. I/Tracker — CAD AVL interface from Trimble Placer 450 GPS receivers via IlMobile 4.1. IlMobile IlMobile is designed to extend the power of the IPS Computer Aided Dispatch (I/CAD) system to mobile users. IlMobile provides capabilities for voiceless dispatch, status updates, messaging, and queries to a variety of systems such as CLETS. It also interfaces with automatic vehicle location hardware and provides extensive map capabilities, including the ability to query locations and validate addresses. IlMobile is used by a variety of police agencies. It provides notification of assignments and allows users to request additional information. By enabling users to post status updates, perform ad -hoc queries, and send messages, dispatchers are freed from routine tasks. The AVL (not proposed for this system put capable of future expansion) and mapping capabilities assist with better recommendations, routing, and providing assistance. IlMobile is integrated with the I/CAD map to display events, other units, road closures, and various symbols (such as hydrants for a fire application or transformers for a utility application). The officer can query the map to determine location or to request the best route to an event or set of events. Map overlays can be added to provide more detailed information. IlMobile performs door-to-door routing in the vehicle (reducing the radio traffic) and can give written or verbal directions. With a GPS receiver attached, IlMobile provides in -vehicle navigation, including verbal directions on upcoming turns and a trip computer indicating information such as the length of the route, distance to the next turn, and expected travel time. No GPS receivers have been proposed for this system. IlMobile communicates with IPS' Mobile Data Terminal (I/MI DT), the primary interface to CAD for mobile computing, dispatch messages, status updates, and messaging. I/MDT provides the message switch for routing data to other interfaces. As the native client application for I/MDT, IlMobile exploits every function available through the I/MDT interface. When used with a GPS receiver, IlMobile will track the location of the vehicle on the map. IlMobile uses the GPS position and the I/CAD map to automatically determine the current address. This information is pre -filled on forms requiring the location. In normal operation, the officer verifies the calculated location; however, this location can be automatically transmitted when in pursuit or if an officer is in distress. The map is integrated with reports, enabling an officer to query events and see the results depicted on the map. An officer may desire to see traffic stops made over the last 4 hours and where they ItemlI-HBCAD—Designv9.doe Page 11 0 Item II - CAD System Detailed Design Wuntington Beach, CA were located or to display the location of all incidents dispatched to a certain unit during the last shift. The reports support context -sensitive, follow-up queries such as location -of -interest searches, event details, or centering the map on the location. Mobile Features • Protects officers by providing warnings about previous incidents, hazardous materials or wanted persons. • Provides additional information to users such as medical triage or electrical switch plans. • Information can be provided from the field to assist dispatchers in managing the incident and for use by RMS systems such as I/LEADS. • Integrated with I/Informer to provide query and update capability to CLETS, RMS, and a variety of other systems. • Through [/Informer, IlMobile automatically alerts dispatchers in response to queries so they are aware of any potential dangers. • Through external API, [/Mobile serves as a transport for IILEADS Field Reporting. • Dispatch -assign enables multiple jobs or events to be dispatched, for example, to allow transport of multiple individuals. This is also called stacking calls on an officer. This is a configuration issue that the City can choose to implement or not. 4.2. IlMobile Data Terminal The IlMobile Data Terminal interface (I/MDT) is the native interface supporting Mobile Data Computer (MDC) clients. I/MDT provides MDC's with an interface into the Intergraph Public Safety Computer Aided Dispatch (I/CAD) System and supports status updates, field event creation, event updates, text messaging, and a variety of outbound reports such as dispatch reports and query results. I/MDT provides the interface between the I/CAD System and any MDC. The IPS IlMobile software is the client software that has been co -developed with I/MDT, and is the preferred client. I/MDT acts as a gateway to route external database requests such as to state/national crime databases (through I/Informer) and provides automatic vehicle location updates (through I/Tracker) from the mobile client. All status updates, event creation, and updates are logged by [/MDT and time -stamped, which is synchronized with the I/CAD System. The times at the mobile client are used for local information only. In addition, i/MDT communicates with a variety of proprietary radio systems. I/MDT provides a message switch that supports access to other systems and the MDCs. This increases throughput and reliability as well as eliminating the need for a separate message switch. If required, however, I/MDT will communicate with other third -party message switches. Features • IIMDT supports car -to -car and bi-directional text messaging with I/CAD operators. All messages are logged in the tiCAD database for later reporting. • I/MDT is used whenever a mobile data computer has been connected to the I/CAD • System. • I/MDT enables voiceless dispatch, status updates, text messaging, and outbound reports. • Manages message delivery, with automatic retrying, maintenance of delivery statistics, handling of undeliverable messages, and broadcast groups. • Interfaces MDC's with I/Informer for state queries and with I/Tracker (not proposed) for automatic vehicle location through GPS satellites. • Supports redundancy, automatically switching to alternate computer in case of a hardware failure. Itemll-HBCAD Dcsignv9.doc Page 12 • Item II - CAD System Detailed Design OHuntington Beach, CA CAD TO MDT FUNCTIONALITY Dispatch Unit Event Information Event Update Information Field Event Information Unit Status Change Notification MDT Messaging MDT To CAD FUNCTIONALITY Add Event Comments Add Unit History Comments Create Field Event (eg., Traffic Stop) Recall Dispatch Event Search Query Event by Event Number Query Pending Events by Dispatch Group Location of Interest Unit Control Functions MDT Sign -on to CAD MDT Change Password MDT Sign -off MDT Lock and Unlock Change Location Send Message Add Special Contact Cancel Special Contact Unit Contact (Unit Contact Timer) Unit Emergency Unit Status Arrive Unit Available on Event Available on Foot Available on Pager Available on Radio Available in Quarters Clear Unit Enroute Unit Transport Arrive Unit Unavailable for Recommend Into Service Out of Service Unit Summary Unit History Equipment Search General Queries Skill Search Who Find Operator 4.3. Illnformer I/Informer provides users of the Intergraph Public Safety (IPS) product suite their "window" to the outside world. Through lllnformer, users can query external databases, either directly via a forms - driven interface or automatically from the Intergraph Public Safety Computer Aided Dispatch Item1I-HBCAD_Designv9.doc Page 13 i Item II - CAD System Detailed Design 1814untington Beach, CA (I/CAD) and the Law Enforcement Automated Data System — Records Management System (I/LEADS-RMS) user interfaces. IlInformer is typically used to assist Public Safety personnel in gathering pertinent information related to vehicles, persons, and property stored in a remote database. Dispatchers, Calltakers, and mobile units (in conjunction with V.MDT) are the primary users; however, it is also currently used by Court officials, Records Management personnel, and administrative users if they have the necessary logon authorization from the data provider. Because IlInformer is a native Windows application, users are quickly comfortable with its operation and navigation of query dialogs and responses. The automatic query capability of IlInformer provides responses without requiring officers to make specific requests. IlInformer is designed to operate seamlessly within the I/CAD environment, and it integrates the IPSI/Dispatcher, I/Mobile and I/LEADS-RMS products with external systems and other various IPS modules. IlInformer, working with the IPS I/LEADS-RMS, provides a seamless textual and image query capability. The converse is also true, in that I/LEADS can use IlInformer to allow RMS users to query state and local databases such as NCIC and NLETS to aid in their records management workflows. IlInformer quickly retrieves information related to operator licenses, vehicle registration, property status, and historical location of interest information. By distributing critical hit information to a broad range of recipients, IlInformer can be used to notify more personnel of potentially dangerous situations. And, its automatic queries reduce officer workloads. IlInformer, when deployed through the I/Mobile solution, allows officers to issue queries directly to their state message switch and local RMS datastores without having to radio the dispatcher to perform the query. This allows the officer to obtain the information quicker and allows the dispatcher to perform other activities that could be more critical in nature. The I/Informer architecture is scalable to accommodate future data query needs. A site can initially deploy one copy of IlInformer to the standard state message switch for NCIC/NLETS query capability and, over time, add additional database query capability as the conditions warrant. Informer Features IlInformer consists of a server component for the communications server and client components intended to work either in a standalone capacity or with I/Calltaker, I/Dispatcher, I/Mobile, and/or I/LEADS clients. IlInformer provides a set of configurable dialogs used to execute ad hoc queries on state and national information databases, local RMS systems, and other peripheral databases; for example, the National Crime Information Center (NCIC) in the United States, Hazardous Materials databases, and the IPS I/LEADS-RMS product. In addition, IlInformer may be configured to automatically initiate queries to a state or national database in support of commands in the I/CAD System (for example, "Vehicle Stop" and "Supplemental Information'). Results from these queries are returned to a dialog and may be automatically attached to an event. All queries and responses may be logged in the I/CAD database for later review. Responses may also be sent as a message or forwarded to a printer. IlInformer allows for configurable Hit Detection functionality such that any response from a remote database can be interrogated for a particular string of text. If a match is found, IlInformer can initiate certain actions such as using standard Windows Messaging capabilities to inform other desktops and mobile units of the hit, direct text email through any email server, and/or send a page to an individual or group. ItemlI-HBCAD_Designv9.doc Page 14 • Item II - CAD System Detailed Design *Huntington Beach, CA Special features include • Customizable hit detection capability, providing various actions when a hit has occurred. • Image display capabilities (provided the datastore being accessed can deliver images). • Multiple datastore query/update capability. • Through a single query/entry dialog, the system can asynchronously hit multiple datastores completely transparent to the user. • Native Windows application - no intensive end user training required. • Support for a variety of remote protocols, including SNA LU6.2, TCP/IP, DMPP-2020, NCIC2000, ODBC, etc. • Dynamic query construction and command line submissions for state message switches that support fixed length queries. • Centralized storage of queries and responses, allowing customized reports to be generated for who ran which queries, at which times, and what the responses were, and which event the response was related to. The Informer configuration for the City of Huntington Beach will interface/query the Orange County Message Switch. The City will choose 10 separate transactions (query types) that IPS will install during implementation of the Informer interface. The message switch will direct the queries to NCIC, CTIS, NLETS, OCATS and DMV. In addition to the Orange County Message Switch queries will be also be directed to the I/LEADS database. 4.4. I/Page I/Page has been removed from the scope of the project. 4.5. IITDD I/TDD has been removed from the scope of the project. 4.6. IIPTT I/PTT has been removed from the scope of the project. 4.7. I/Tracker The I/Tracker interface will communicate with the City provided Trimble Placer 450 GPS receiver through I/Mobile. The City will need to connect the GPS port on the Placer 450 to the mobile data computer via serial cable. I/Mobile will then receive GPS data from the Placer 450 every second. The GPS coordinate data will be appended to I/Mobile messages and then passed through IIMDT to the I/Tracker interface, which in turn displays unit locations correctly on the I/Dispatcher map. If after a configurable amount of time, I/Mobile does not generate a standard CAD message, I/Mobile will transmit a GPS coordinate specific message to I/Tracker. Below is a diagram outlining the connection and flow of data. ItemlI-H$CAD—Designv9.doc Page 15 %~'1 Item II - CAD System Detailed Design -Huntington Huntington Beach, CA Trlmblel�lacer450 VMobile LRs232 10spatcher VDispatcher 5. I/CAD RFP Clarifications CAD Section Motorola RF Network Mspatcher u Macker DT Ref: Item #128 - Assignment of default priority based upon call for service, geographic area, and specific location. Event priority is determined by call for service type. The user can change the priority of the call but cannot change the RD or beat without changing the location of the call. Ref: Item #130 - Allow "override" of priority entry by calltaker regardless of default setting except when a multiple agency response is recommended. The override function of a priority is not limited to whether the call is a multi agency response or not Ref: Item #189 - The operator may resume entry of a suspended incident by a selection process to allow uninterrupted work flow and selection of highest priority of suspended incident(s). ItemII-HBCAD_Designv9.doc Page 16 • Item Il - CAD System Detailed Design 011untington Beach, CA The operator may select any call from the queue to complete it. Ref: Item #257 - The act of supplementing a call will cause the call to be displayed as a call "not yet presented" with a flag Indicating the reason for the re -display of the call. When a call is supplemented, there are other indicators other than showing the call as "not yet presented" Ref: Item #258 - A cancellation request will cause the call to be displayed as a call "not yet presented" with a flag indicating the cancellation request. A separate indicator button will indicate there is a call that was requested to be cancelled. Ref: Item #619 -The dispatcher can, via a command code, activate an interface between the CAD and the Alphapage system to send standard Incident information to a specific group(s) This Information will be user -defined by agency at time of system implementation and may included. IPS has proposed I/Page to support alphanumeric paging. The City is responsible for providing any phone lines, modems, etc. required to establish the connection with the paging terminal(s). The City is also responsible for providing complete and accurate documentation for the paging system interface. Special Vote on I/Page Each distinct paging controller requires an additional license of I/Page. The City may elect to utilize more than one paging provider for alphanumeric paging using the Telocator Alphanumeric Paging Protocol (TAP), and these will be considered as a single paging controller for licensing purposes (connection may be via a dedicated or dial up line). I/Page has been removed from the scope of the Project thus this requirement is not supported. ItemIl-H13CAD_Designv9.doe Page 17 0 • ITEM III ULEADS RMS System Detailed Design for City of Huntington Beach, CA Prepared by Intergraph Public Safety Item III - I/LEADS RMS System�I]etailed Design *Huntington Beach, CA Table of Contents 1. Overview .............................................................................................................................................. 4-5 1.1. RMS Design Features................................................................................................................ 4-5 1.2. Modularity................................................................................................................................. 56 1.3. Organizer................................................................................................................................... 56 1.4. Scheduler Module...................................................................................................................... 56 1.5. Export Module........................................................................................................................... 56 1.6. Import Module........................................................................................................................... 56 1.7. Notifications Module................................................................................................................. 6.7. I.8. Expungement of Records........................................................................................................... 67 1.9. Locking Records........................................................................................................................ 6_7 1.10. Securing Records....................................................................................................................... 67 1.11. Purging Records........................................................................................................................ 67 1.12. Fleet Management Module........................................................................................................ 67 1.13. Police Stores Module.................................................................................................................. 7 1.14. Inventory Management Module................................................................................................ 78 1.15. Names Module........................................................................................................................... 78 1.16. Vehicle Module................................................................................... .................................... .. 78 1.17. Calls for Service Module....................................................................... ....................... 89 1.18. Incident Module......................................................................................................................... 89 1.19. Arrest Module............................................................................................................................ 89 1.20. Property/Evidence Collection Module....................................................................................... 84 1.21. Property/Evidence Management Module .................................................... ........... 89 1.22. Known Offender...................................................................................................................... 94-0 1.23. Pawnshop Module................................................................................................................... 94-0 1.24. Pawn Watch Module............................................................................................................. 1044 1.25. Field Contact Module............................................................................................................ 1044 1.26. Citation Module..................................................................................................................... 104 1.27. Warrant Module..................................................................................................................... 1044- 1.28. Case Management Module.................................................................................................... 1044 1.29. Bike Registration Module...................................................................................................... 1044 1.30. Employee Module.................................................................................................................. 10-14 1.31. Dissemination Management Module..................................................................................... 114-? 1.32. Alarm Permit Module............................................................................................................ 114-2 1.33. Location Module................................................................................................................... 1141 1.34. Field Reporting...................................................................................................................... 1143 1.35. Gun Permits Module.............................................................................................................. 124-3 1.36. Concealed Weapon Module................................................................................................... 1244 1.37. Civil Process Module............................................................................................................. 12-13 1.38. Involvements Module............................................................................................................ 1213 1.39. Memo Templates................................................................................................................... 1244' 1.40. Access Privilege.................................................................................................................... 134-4 1.41. Searching and Sorting Features............................................................................................. 134-4 1.42. Code Table Selection Features.............................................................................................. 134-4 1.43. Online Help System............................................................................................................... 134-4 1.44. Imaging ................................................................ 1344 1.45. Reporting from I/LEADS RYIS................................................ ....... ... ..................... I............. 14-14 1.45.1. I/LEADS RMS Standard Reports......................................................................................... 14-1-3 1,45.2. I/MARS Standard Reports.................................................................................................... 21 2-2 1.46. I/LEADS Customized Reports.............................................................................................. 222-3 1,46.1. California MVA Report ........................................................................................................ 2223 1.46.2. California Stolen Vehicle Report.......................................................................................... 23-4 1.46.3. Missing Persons Report ...................................................................................... 23-4 1.46.4. Uniform Crime Reporting Customizations........................................................................... 23?4 1.47. I/LEADS Interfaces...............................................................................................................23-4 Item III - I/LEADS WS System Detailed Design Wuntington Beach, CA 1.47.1. Booking Data Transfer from IMAGIS............................................... ' 25 1,47.2. CLETS Access from FLEADS............................................................................................. 242-5 2. VLEADS RFP Clarifications............................................................................................................ 242-5 • Item III - IILEADS RMS System Detailed Design *Huntington Beach, CA 1. Overview 1.1. RMS Design Features Any large organization faces the continual and sometimes overwhelming job of creating and maintaining information. For public safety systems, the added challenge of providing it to organizations which use that information to produce public policies demands that the system be prgductive, easy to use, and able to assist the user in ensuring the accuracy of the information. Out of many years of experience, public safety agencies have evolved paper forms by which they gather and manage this information. While this is accepted practice, it increases the workload and in many cases aggravates the errors because of the complex relationships among the forms that must share information. Once an error is introduced, it affects all of the reports that depend on correct data. This is the "ripple effect": an error automatically ripples across the database and immediately degrades any processes or decisions that depend on it. A badly automated database or process worsens the situation by rippling invisibly at the speed of light. The aim of modern database design is to improve accepted practice, for example, ensuring that automatic error checking is always done. With these improvements come more effective means to analyze the content and meaning of the information collection. To cope with the complexity of collecting, managing and analyzing public safety information, several techniques are applied by the IAS RMS developers: • Graphical User Interface - use of familiar industry standard desktop GUIs to enhance production and reduce the costs of training. • Modularity - applying modern relational database design techniques such as normalization to analyze the information and relationships among pieces of information, Then divide these into efficient modules and ensure that information can be stored once and reused as needed. • Involvements - applying relational techniques to ensure that navigating and uncovering related information is easy and natural thus, enhancing the power of the reports to assist in an investigation. • Query By Example - applying modern forms interface techniques to make searching for information easy and natural and to limit the side effects of inexact searches, thus reducing system resource consumption and increasing productivity. • Validation Rules - using database rules to verify that information entered is correct and corresponds to other entries. For example, if a date of birth is given, the age of the individual is automatically calculated and inserted. If the user chooses to insert the age, it is validated against the date of birth to ensure it is correct. • Interfaces to Other Sources - Computer -Aided Dispatch (CAD) systems collect incident information that is automatically inserted into the records management system, thus capturing the information as early and accurately as possible and providing it to the processes that use it to drive other processes such as policy making, what -if simulations, and scenario design. 4 Item III - I/LEADS RMS System Detailed Design ' Huntington Beach, CA 1.2. Modularity Modularity is a simple concept, but has profound effects on the organizational efficiency of the system. The modular design process is straightforward: decompose the system into individual pieces of information; then use these to create a functional software module. Typically, an information component consists of: • Topic - the particular content that a module handles -for example, names, offenses, and incidents. • Data Fields - where values about a particular topic are entered - for example, name, City, and state ZIP codes. • Validation Rules - rules for ensuring data integrity • Relationships - links to other modules that must share information RMS is designed so that each functional module that is, the software and its graphical user interface corresponds to the organization of the information it must capture. Functional modules are organized around a base module. The base module enables each functional module and provides common services to all of them. A commercial database engine provides the enabling relational database technology and the user interface design tools. The user interface is seamless and enables easy navigation of each module based on the operation in progress. For example, if information about a person is required while a user is filling in an incident report, the Names module opens automatically and provides the personal information needed to complete the incident report. 1.3. Organizer The Organizer window has the look and feel of Microsoft® Outlook. The Organizer serves as the primary communications method between the system and users. The Organizer keeps track of Incidents to be reported on, approved/unapproved incidents, notifications from internal and external databases, and messages within I/LEADS including responses from NLETS and NCIC. One look provides users the status of reports assigned to them, such as whether a report is pending or returned for edits. Using drag and drop, links to incidents and notifications can easily be added and managed by users. 1.4. Scheduler Module The Scheduler module enables users to schedule tasks continuously or intermittently as required without program changes. For example, the property/evidence unit may have created a specific spreadsheet to track release and/or disposal of items in their custody. Scheduler allows the users to have the spreadsheet called and populated daily and ready in their inbox without intervention. Any process, such as reports and external programs can be scheduled and called automatically by the program. 1.5. Export Module The Export module allows the user to configure information exports with triggers. For example, new arrest records approved or general exports can be called by the Scheduler process. Export reduces the administrative time needed to configure and manage the I/LEADS system by automating extraction of data and allowing new extraction to be created without programming. 1.6. Import Module The I/LEADS Import module creates, modifies, and manually runs import definitions. An import definition is a collection of settings that indicate how a certain type of external data is to be imported into the I/LEADS database. Some sites may have no import definitions, while others have several import definitions. The software includes: • An extensive set of helperfunctions which simplify many common operations such as name Item III - ULEADS RMS S stem Detailed Design Huntington Beach, CA Y _g matching and vehicle matching Database transaction support to avoid partial imports when an import error is detected. The database transaction can commit or rollback all records created or updated during a particular import. During the preparation of this document ITS has proposed a data conversion study for the Property and Alarm Permit records in the City's current system. If the study progresses to the point of actually converting records the import module will plan an important part in that conversion. 1.7. Notifications Module The Notifications module enables users to determine when a person assigned in Case Management will receive notice that a change has been made to their case. While primarily applied to Case Management, a notification can be created to notify any person or group of an action. 1.8. Expungement of Records Expungement of records enables approved users to remove name references from Incidents and related modules. Demographic data on the name is retained in the Names module. Data that identities the name is removed and stored in a user defined secured file for complete removal or put in storage for later retrieval if required. Name data is also removed from any narrative created within IILEADS. An expungement notice alerts the user that the original name has been removed. 1.9. Locking Records Record locking is provided by either of two methods: • Automatically through the user -defined approval process where, after a certain number of reviews and approvals, the record is locked • Interactively through a button that enables an approved user to lock the record regardless of its approval level When locked, the record data and referenced data cannot be edited except for certain fields such as Case Status. This process does not preclude updates of the original referenced data, such as a change of address for a name in the record. The locking process remembers the point in time for referenced data. This ensures that the correct data is used when viewed, printed, or reported. 1.10.Securing Records Securing enables an authorized user to restrict records access to the user or to an authorized group of users. For example, an investigations unit could restrict access to an incident to only those members in that group. Attempts to access the record show the person requesting access that the record is secured, and who secured it. 1.11.Purging Records The Purge Function feature deletes a configurable subset of data from the central I/LEADS database. The deleted data is then compressed using a ZIP -compatible format and placed in a "Purged" directory on the FLEADS database server. The Purge Function command can only be run by authorized users (typically a System Administrator). It can be used to configure the rules that determine which records are to be deleted. An Application Add In function allows the user to recover any purged data from the media containing the ZIP -compatible purge file. 1.12.Fleet Management Module The Fleet Management module is an integrated process enabling users to purchase, manage, and maintain their fleet of vehicles. Easy to use graphical forms show all vehicles, their costs, dates of purchase and in service, and all equipment assigned to the vehicle. Maintenance functions track all costs and maintenance of all items assigned to the unit. The single interface allows managers to quickly review the fleet and make appropriate decisions regarding their status and use. 6 Item III - IILEADS RMS Systetetailed Design *Huntington Beach, CA 1.13,Police Stores Module The Police Stores module provides inventory functions for all of the issued or purchased items provided by the department. The status of all equipment, either on hand or issued, is recorded along with reorder points and inventory reports. 1.14.lnventory Management Module The Inventory module allows the user to track all information required to order and store an inventory item. It shows whether the item applies to the jail commissary and issue items, police store and issue items, or general inventory. You can also track the retail price and tax rate, how much is currently on hand and a reorder point, storage location, and vendor and manufacturer information. 1.1S.Names Module The Names module serves as the interface to the Master Names Index and is a key reusable core component of L(LEADS-FLMS. Any IILEADS module that must enter, display, or edit name information can directly access the Names module. The primary function of the Eames module is to store the names of individuals, gangs, aliases, businesses, and so forth, and to provide the user with an interface for entering, viewing, and searching individual or business information. The system maintains current and historical information for each name entry. Multiple contact information for the person is Iinked to the name through the IILEADS Involvement system. Information associated with the named individual, business, organization, gang, or other name type can be entered into the form and linked through the database to other events of interest. When the Names module is accessed from any other module, the full add and edit features are available, privileges permitting. The IILEADS-RMS relational database design ensures that the data entered in all IILEADS modules are consistent and maintain referential integrity. When a name is entered, an automatic text and Soundex (sound alike) search is performed, A pick list of applicable names is presented to the user. The user can review the names and determine if the requested name is already in the system or if a new name must be entered. If the name is found, the Use button can be selected to add a link to the existing name. If the name is to be added, the link will be established after all the data is entered. Locations can be entered and referenced as names that provide a consistent location for businesses. The common geofile referencing system used by IILEADS and IICAD ensures that businesses that share common names in multiple locations, such as franchise names, are uniquely identified. The Names module supports a full -featured process allowing a complete history of any modification or addition to the Names module. Modifications or additions to a name may include aliases/monikers, associates, physical characteristics, and modes operandi. IILEADS also provides the unique ability to search on any element and, if there is an item in the person's history matching the query, the historical information is displayed. IILEADS uses the alias feature to link name files in the Master Names Index. Whenever there are future entries or queries using the false name, the system will automatically show the user the correct name and indicate the name is linked to an alias. This method allows the preservation of data connected with the false name and proper data for future associations. 1.1$.Vehicle Module The Vehicle module enables users to maintain a master vehicle database that interacts with other modules in IILEADS-RMS. The user is always able to determine a vehicle's current UCR status Item III - I/LEADS RMS Systeetailed Design g Wuntington Beach, CA within the system, as it is automatically updated through status changes made from the Arrest or Incident modules. Records entered into the Vehicle module become part of the Involvement system and enable the user to explore relationships among people, vehicles, and incidents. I/LEADS has a Master Vehicle Index (MVI) containing all vehicle information. Pointers from other modules reference the MVI to reduce data entry, validate data, and guarantee an audit trail of transactions system -wide. Vehicle information can also be captured in other modules and stored in the MVI to avoid redundant data. 1.17.Cails for Service Module The Calls for Service (CFS) module captures the call type, event location, and the officer assigned to the call for service. The Calls for Service module can collect data on involvements and persons related to the CFS. A narrative section allows users to enter descriptive information about the CFS. 1.18.lncident Module The IILEADS Incident/Investigation module provides a means of entering and maintaining offense reports that have been filed with an agency. The RMS Incident module provides the primary data collection process and ensures a comprehensive preliminary investigation of a crime incident. Initial data capture for incident reports will come from the integration between CAD and I/LEADS or all data can be entered directly. Incidents may be linked to all master indexes including the Property Master Index, and the Accident, Citation, and Case Management modules as needed. The module creates records that point to the names, vehicle, and property records. This provides access to all information associated with an incident. 1.19.Arrest Module The Arrest module enables the user to enter and maintain arrest events within the agency. This module provides access to the I/LEADS Involvement system and the relationships among modules such as Names and Vehicle to increase the effectiveness of I/LEADS-RMS as a powerful investigation tool. I/LEADS captures detailed information about an arrest including multiple charges. The data is captured in a format consistent with NIBRS and UCR reporting requirements. Some examples of data collected in the incident module that is related to the arrest module are offender relationships, drug substance abuse and weapons. The I/LEADS system captures data on Modus Operandi. A section in the Incidents module is used to document actions occurring during an incident. A selection form is used to select classes of M.O. and specific M.O. descriptors and to add new descriptors. The Names Master Index provides for an unlimited number of M.O. descriptors to be associated with each name. 1.20.Property/Evidence Collection Module The Property/Evidence Collection module enables the user to keep a record of property in the custody of the agency or to record information about property that has been reported stolen, lost or damaged. The IILEADS system tracks property and its status related to incidents and supports direct entry of property information into the module. 1.21.Property/Evidence Management Module The Evidence/Property Management module maintains collection records for items taken into custody and provides the management tools necessary to track chain of custody and disposition of items. Evidence/Property Management ensures proper reporting to UCR and NIBRS and provides functionality necessary to manage the Evidence/Property room. Item III - IILEADS RMS S stem Detailed Design n g Huntington Beach, CA Information can be entered directly into the Property/Evidence Management module or from the Incident or the Arrest module using the Related Property form. During data entry, the system does cross checking against existing property records and the Pawnshop module. The Property and Evidence collection and management modules work independently of each other allowing some department personnel to code Type of Loss as one type in one module and another department to code the same piece of evidence as a separate type in the other module for instance as in NIBRS reporting. 1.22.Known Offender Known Offenders collects information to track known and registered offenders, such as: • Offender types, for example, sex offender, drug offender, or arson offender • General name information associated with the Names module • Charges, including charges brought in other cities or states • The registration status of offender • Location of offender • Location of requester, when a request is made for offender information Additionally, using Known Offenders, you can: • Register offenders • Send and receive notifications of events and schedules based on status • Notify and publish offender information to different media and formats 1.23.Pawnshop Module The VLEADS Pawnshop module tracks all property received by pawnshops. Any items pawned are automatically checked against the Property module to determine if the property has been listed as stolen or lost. 0 Item III - MEADS RMS System Detailed Design *Huntington Beach, CA 1.24.Pawn Watch Module The Pawn Watch module enables the user to create and maintain a list of items that may be pawned or persons associated with pawned items. This module is used by agencies to create information to enable pawnshop owners and personnel watch for the items listed. 1.25.Pield Contact Module The Field Contact module enables the user to enter and maintain records for field investigations of persons contacted in an investigation. Field Contact cards are entered through a dedicated module in the RMS system. Currently the Field Contact module allows one name per contact to be entered into the system. However, any number of persons can be related using the Involvement system. This prevents the number of persons or things from being limited by static fields. When entered, the association will be by type of involvement, such as Suspicious Persons, as indicated in the Reason field. 1.26.Citation Module IILEADS currently allows all types of citations to be entered into the system. The module enables user to maintain a log of all citations and warnings issued by an agency. The module is incorporated into the Involvement system and enables the user to attach vehicle and name relations to a citation event. Names and vehicles are automatically validated against the Names and Vehicle Master Indexes. The module links established data rather than storing the data in the citation tables. California State specific fields will be added to appropriate modules via the Sysgui Interface. 1.27.Warrant Module The Warrant module enables efficient management of warrants within an agency. Many features are supported such as linking a warrant to an incident through the Incident module and warrant tracking. The Warrant module participates in the I/LEADS Involvement system. 1.28.Case Management Module IILEADS Case Management module allows an agency to have close control over case assignments and the status of pending cases by allowing a supervisor to review all incident data and enter or update information. The module also contains a Recommend Assign dialog box that allows supervisors to enter weighted averages to determine case assignment. Members of the court can be allowed restricted access to specific modules as a member of a user group. This would allow entering and editing data based on the user group's permissions. Information maintained within the work group is available to other units in a read-only mode to allow for monitoring case status. Updates are only allowed with the appropriate security authorization. 1.29.81ke Registration Module This module enables the user to register and check the registration of bicycles. The Involvement system can be used to check the involvement of the owner of the registered bike with other activities, properties, vehicles, incidents, and so forth tracked by IILEADS-RMS. 1.30.Employee Module The Employee Records of IILEADS is designed as both an employee records database, and to track issued equipment, special job skills, education, and employee personnel actions. The Officer lists used in other modules of the IILEADS system are created using the information entered here including telephone/address lists for emergency contact. The employee records section is the source for personnel data used throughout the I/L.EADS system. The employee records table provides the system with job assignment information, which is used to generate Officer lists in the records functions. 10 Item III - IILEADS RMS Systeoetailed Design *Huntington Beach, CA 1.31.Dissemination Management Module The Dissemination Management (DM) module is used to track IILEADS reports that have been viewed or printed. Information on the requesting individual, the officer involved, the disposition of the dissemination, the report title, the number of copies requested, any receipts that were dispersed, and miscellaneous information can be tracked within the DM module. DM will be activated whenever a report is viewed or printed, depending on the environment setting, DM Level. This setting can be modified on the Dissemination Management page under the Tools/Site menu. The DM Level can be None, Required, or Optional. When a Report is generated from a Report form, and DM is Optional, a Dissemination button will appear on the form and may be selected if necessary. If the report is not generated from a Reports form, then the DM module will always appear unless the DM Level is none. Involvements are automatically created for a report that is based on a unique row in a module. This is true only for modules that pass this information to DM. 1.32.Alarm Permit Module The Alarm Permit module will be configured to conform to the Huntington Beach Alarm Permit Flowchart provided by the City to IPS. This process will necessitate rewriting portions of the existing Alarm Permit Module and will not be available until the third quarter of 2003 or release of version 5.8 of IILEADS which ever occurs first. See the Change List for detailed customizations to be performed on the Alarm Permit module. 1.33.Location Module The Location module of IILEADS enables an agency to keep track of unique locations that may exist for an entity (module) within their scope. The location of a person's house, the scene of an accident, or the place of an arrest, for example, may be tracked in the Location module. When a module refers to a location, an involvement is created between the entity and the location automatically. The entries into the Location table are done transparently to the user in each module. As a user enters the address, the string is parsed into components and verified against the CAD map, if available. The parsed location is then queried in the Location table. If the location exists then the Location ID is returned. If the location does not exist, a new row is created in the location table and the new Location ID is returned. The Location ID is then placed into the column of the row of the referencing module. 1.34.Field Reporting IPS has proposed the use of the Field Reporting Module within the IILEADS application to satisfy the field reporting requirements of the City. The Field Reporting Module is comprised of the following applications: Field Reporting Client Field Reporting allows police officers in the field to use mobile computers to create and modify Field Reports, typically Incident reports, Traffic Accident reports, and Field Contacts. Field Reports are periodically transmitted to the central IILEADS database for review, approval, and inclusion in the master IILEADS database. By using Field Reporting, agencies can reduce or eliminate the use of paper forms. This reduces workload since the data no longer has to be transcribed from paper forms into the central RMS, and eliminates many data transcription errors. Note: If a mobile client docks to a networked client and runs IILEADS to access the central IILEADS database, the client is treated as a LAN -based client, To do this, create a special Item III - I/LEADS RMS SysteVetailed Design *Huntington Beach, CA shortcut that points to the I/LEADS product directory on the IILEADS database server. Field Reporting Server Periodically, field reports must be transferred to the I/LEADS database for review, approval, and inclusion. Conversely, mobile clients must also be updated to reflect changes in the database. Field reports can be transferred directly by docking the mobile unit to any workstation on the network, over a wireless (Radio Frequency--RF) network, or from removable media such as floppy or ZIP disks. To send data from the server to the mobile client, you must define rules for extracting specific records and then post the records to an update file in the server outbox before the data can be transferred. IMPORTANT: Because updates the mobile client receives can overwrite data in the local database, the mobile user should always send updates before receiving them. To prevent the overwriting of unsent field reports when the mobile client tries to receive data, I/LEADS checks the local database for new or changed records and automatically starts the Send dialog box to force the sending or saving of updates. Field reports received by the server are managed by the Inbox Agent, which runs in the background to merge updates received from mobile clients. 1.35.Gun Permits Module The Gun Permit module of IILEADS enables an agency to keep track of Gun Permit requests and issuance. This module enables the user to add multiple permits for one application and to maintain close control over the issuance of permits. 1.36.Concealed Weapon Module The Concealed Weapon module of IILEADS allows an agency to keep track of the application and issuance of permits for carrying concealed weapons. This module allows the user to add multiple permits for one application and to maintain close control over the issuance of permits. 1.37.Civil Process Module The VLEADS Civil Process module enables an agency to enter and maintain civil process information. Among other features, the Civil Execution worksheet's applied interests and due amounts are easily calculated after entering appropriate data. The Civil Process module also enables a user to easily maintain service tracking events related to the civil paper. 1.38.Involvements Module Involvements are data relationships maintained by IILEADS. This feature reduces both the number of modules required for maintaining information and the likelihood of mistakes or overlooked information through linking and normalization. Once the records are part of the Involvement system, I/LEADS-RMS becomes a more powerful tool for conducting investigations. A summary list is displayed listing every involvement of that name in the system. Double clicking on any of the records in the summary list will display the detailed form associated with the record. 1.39.Memo Templates I/LEADS has the ability to define multiple templates for most notes and narrative fields in the product. The template can be entered and modified by any user with administrative privileges. To access the template, right -click the appropriate field editing button. This will bring up a dialog box to add or modify templates and their appearance. The templates are agency specific. When the field editing button is left -clicked, I/LEADS checks to see if the field is empty. If so, it will check to see if templates have been defined for this field. If no template is defined, a blank 12 Item III - IILEADS RMS Systefletailed Design ISHuntington Beach, CA edit window is opened. If only one template is defined, the edit window with the contents of that template is opened. If more than one template is defined, a menu appears containing the available templates in the defined order. The user can then select which template to insert. 1.40.Access Privilege I/LEADS secures access to authorized information among workstations and user groups by assigning access privileges to each workstation within a specified user group. A forms interface enables a high level of flexibility in assigning permissions to workstations and personnel assigned to user groups. Ease of access to authorized information is ensured by forms that seamlessly integrate the presentation, navigation, search, and identification processes. 1.41.Searching and Sorting Features Using the best commercial practices for relational databases, I/LEADS all data items in separate data fields and are searchable through the same form the data is entered in. Query By Example rules enable accessible and flexible data entry, navigation, and retrieval. Because QBE enables the use of the data entry form for searching, training and errors are reduced. I/LEADS provides powerful, easy to use Query By Example search capabilities to help retrieve records when only a limited amount of information is known or to assist in the investigative process. The same forms used for data entry are also used for formulating inquiries. Every field, including narrative fields, can be used to search the database. Different sort keys are provided, including the standard keys such as less than, greater than, sounds like, and pattern matching. A form is provided that enables the user to select the criteria for a search, sort, or retrieval operation. The user can enter as little or as much information into a field to use for searching the database. Clicking the right mouse button enables'the user to select the search user to apply from a popup menu. 1.42.Code Table Selection Features Code table selections are direct and simple in I/LEADS-RMS. For each field on a form where standard specific responses are required, pressing the F2 key or entering a question mark in the blank field opens a browse form. Using the mouse or keyboard, the user can select codes from the lists in the form. The system administrator can use the same code form to add codes or customize codes for the local municipality or agency without programming. I/LEADS uses forced choice on those data items where a response is mandated by Uniform Crime Reporting (UCR) or National Incident -Based Reporting System (1`'IBRS) requirements (such as M Ur F for sex of a person). On those items where multiple choices are required, the table is shown when the field is blank and the Enter key is pressed or when the user places a question mark in the field and presses the Enter key. Either process will return a scrollable code table, key in part of the item, and press Enter when the item is highlighted, or use a mouse to scroll through the selections and select the required item with a double click. 1.43.Online Help System I/LEADS-RMS uses the MicrosoftV Windows help system to provide help at the module and form level. This ensures that navigation of help is quick and consistent throughout IILEADS. In the browse mode, on-line help runs at the same time as I/LEADS, in different windows. The User can switch from window to window by using the ALTy-TAB keys to switch among windows as needed. 1.44.1maging I/LEADS has the ability to attach files to include images to any of the available modules. The images can be attached, reviewed, and edited through the RMS graphical user interface. File types 13 Item III - IIL.EADS RMS Systegetailed Design 91-luntington Beach, CA supported are any OLE II automation with the proper viewer installed on the workstation running IILEADS. 1.45.Reporting from i1LEADS RMS The ability to extract, operate on, and present information is a critical need for all organizations. An extensive number of stock reports are included with RMS. A list of the stock reports provided in I/L.EADS and I/MARS is included in this section. Additionally, users can create ad hoc reports that are customizable, can be viewed, and can be printed, simply by selecting fields on the form. After searching for the record, in view mode, click the Option button, which displays the Report Option form. Included with IILEADS is a tool to allow the City to modify the layout of default reports. It is the responsibility of the City to use this tool to make any modifications needed. 1.45.1. i1LEADS RMS Standard Reports -Alarm Permits Alarm Permits by Status All Calls for Service, Linked by Involvement Alarm Permits by Bill Status Alarms Linked by Permit Address, Disposition Search Alarms Linked by Permit Address, Incident Type Search Alarms Linked by Involvement, Disposition Search Alarms Linked by Involvement, Incident Type Search Alarm Permit Bills Alarm Permits by Type False Alarm Calls for Service, Linked by Involvement False Alarm Fines, Bulk Mailing Generate and Print Alarm Fines Alarm Exception Report Alert All Band E Business B and E Motor Vehicle B and E Motor Vehicle Theft Residential B and E Robberies - Business Robberies - Persons Bicycle Reizistration Bicycle Registration Listing by Owner Bicycle Registration Listing by Registration Number Ausinesses Vendors Listing Manufacturers Listing Call For Service Call For Service Operations Report (Agency) Call For Service Operations Report (Call Nature) Call For Service By Classification and Call Nature 14 Item III - I/LEADS RMS Systefetailed Design OHuntington Beach, CA Officer Activity Report (Order by Date) Case Management CID Workload Statistics By Review Date CID Workload Statistics By Status Date Case Assignment and Clearance By Misdemeanor and Felony Case Assignment and Clearance Monthly Report Case Cleared Report By Investigator Case List By Status Case Log By Case Number Order Cases Reviewed By Type Due Date Report By Investigator (Active Case Only) Incident Report Log With All Offenses Investigator Assignment and Clearance Monthly Report Investigator Report By Case Assigned Investigator Report By Case Status Open Cases By Investigator Aging Report Open Cases Not Assigned Statute of Limitations for Misdemeanor Cases Overdue Cases without Supplements Investigator All Case Activities Casb Reports Consolidated Cash Settlement Report (Receipt # order) Consolidated Cash Settlement Summary Report Miscellaneous Cash Settlement Report atalog Listing Catalog Listing by Group Code Catalog Listing by Vendor Catalog Listing by Applying to Jail Commissary Catalog Listing by Applying to Jail Issue Catalog Listing by Applying to Police Issue Catalog Listing by Applying to Inventory Citations List of Citations Ordered By Charge Citation Charge Summary By Date Range Citation Disposition Summary By Date Range List of Citations Ordered By Date Civil Pa ers Active Civil Paper By Agency Specified Category Active Civil Paper By City - (Name of City) Active Civil Paper By Court Date Active Civil Paper By Officer Active Civil Paper By Serve To Person Active Civil Paper By Status Date Civil Papers By Agency Specified Category Civil Papers By City Civil Papers By Disposition Status 15 Item III - I/LEADS RMS Systevetailed Design Huntington Beach, CA Civil Papers By Officer Civil Papers Cash Balance By Type of Paper Civil Papers Received/Served Statistics by Document Type Civil Processing Receipt (for editing report purpose only) Civil Served Statistics By Officer Closed (Inactive) Civil Papers Service Fee Deposit Report Service Statistics By Officer Daily Residences with Multiple Burglaries Dissemination Management Dissemination Report Employees Emergency Personnel Information Card (Half a page with Photo) Employee Detail (One page per employee with Photo) Employee Separated with the Department Employee Training Expenses Report Employee Training Records by Course Title Equipment Issued By Equipment Type List of Employees For Type of Equipment NOT Issued List of Employees NOT Trained by Course Title List: ID, Name, Address f Division, Section, Phone Numbers List: ID, Name, Address / Emergency contact information List: ID, Name, Address 1 SSN, Dob, Age, Sex, Race List: ID, Name, Address, Phone Numbers For Emergency On -Call Staff List: ID, Name, Division, Section, Work Phone Number List: ID, Name, Rank, Units, Date Hired, Sworn, Division, Section Equipment General Equipment Issue Summary by Officer # Field Contact Field Contact By Reason Summary Report Field Contact Report (With Contact Names) Field Contact Report (With No Contact Names) Fleet Vehicle Fleet Vehicle Summary Report by Vehicle # Fleet Vehicle Summary Report by Asset Tag # Fleet Vehicle Accessories Summary Report by Vehicle # Fleet Vehicle Accessories Summary Report by Asset Tag # Fleet Vehicle Service Summary Report by Vehicle # Fleet Vehicle Service Summary Report by Service Items Fleet Vehicle Service Items List Fleet Vehicle Service History Report by Vehicle # Fleet Vehicle Service History Report by Service Items Grp Calls For Service By Call Priority 16 Item III - I/LEADS PMS Systeoetailed Design *Huntington Beach, CA Calls For Service By Day Of Week Calls For Service By Hour Of Day Calls For Service By Tract Calls For Service By Zone Five-year Part I Crime Trend Analysis Incidents By Day of Week Incidents By Hour Of Day Incidents By Month Incidents By Officer Incidents By Responding Zone Previous Year 12-month Part I Crime Three-year Part I Crime Trend Analysis Arrests by Day of Week Arrests by Month Calls For Service By Hour Of Day Incidents By Hour Of Day Incidents By Month Arrests by Day of Week Arrests by Month Gun Permits Gun Permit Applications by Date Pistol Permits Approved -Not Issued Report Gun Permits Cash Settlement Report Gun Permit Form (for form edit only) Gun Permits Issued (Permit Number order) Gun Permits Issued by Issued Date Gun Permits Issued by Permit Number (Address, Race, Sex - Name order Gun Permits Issued by Permit Number (Name order) Gun Permits Statistical Report Gun Permit Applicant Summary Gun Permit / Concealed Weapon History for Weapon (edit only) Weapon Reported Lost/Stolen Report (for edit only) Misdemeanor incidents Misdemeanor Incident Card Miscellaneous Incident Card Nance Re arts Name Detail Name Detail RAP Sheet Report Missing Person Report - ACTIVE Missing Person Report - INACTIVE Pawnshop Pawnshop Report Ordered By Item Description Pawnshop Report Ordered By Name Stolen Property to Pawned Property Serial # Match Pawnwatch Pawnshop Watch Matching Report (for form edit only) 17 Item III - I/LEADS RMS Syste�Detailed Design I *Huntington Beach, CA Parking Tickets Parking Tickets Vehicle W No Owner Parking Tickets Overdue Payment List Parking Tickets PAID Report Parking Tickets UNPAID Report Probation/Parole Probation/Parole Listing Probation/Parole Arrest Hit List Property and Evidence All Property By Responsible Officer Evidence Disposition Form By Officer Evidence List Case Number On -hand Property Aging Report (By Aging Date) On -hand Property Aging Report (By Property Name) On -hand Property Aging Report (By Storage Location) On -hand Property By Owner On -hand Property By Responsible Officer On -hand Property By Storage Location Property Inventory List Property List By Status Property Next Action Report ProDerty Re orts All Property By Responsible Officer Evidence Disposition Form By Officer Notice to Owner (Local Status = Eligible to release to owner) On -hand Property Aging Report (By Aging Date) On -hand Property Aging Report (By Property ?Name) On -hand Property Aging Report (By Storage Location) On -hand Property By Owner On -hand Property By Responsible Officer On -hand Property By Storage Location Property Inventory List Property List By Status Property Next Action Report PropertyNehicie List By Status Purge Report (Local Status = Disposed) Property Voucher All Property By Responsible Officer Rejected Voucher Summary Format Rejected Voucher Detailed Format Seci rit y Checks Security Check By Zone Security Check By Zone Security Check Letter List (By Ending Date) Security Check Request Blank Form 18 Item III-11LEADS RMS Systwetailed Design • Huntington Beach, CA Storage Location Report Storage Locations for Commissary System Audit Report System Audit Report Traffic Accidents Major Traffic Accidents Report Motor Vehicle Accidents by Day and Time Break Down by Involvement Type and Injury Class Major Traffic Accidents Report by Intersection Motor Vehicle Accidents by Day, Time and Intersection Motor Vehicle Accidents by Day, Time and History Motor Vehicle by Day, Time and Factor Dangerous Intersections Report UCR Reports Monthly - Return A Monthly - Domestic Violence -Related Calls For Assistance Monthly -Number of Violent Crimes Against Senior Citizens Monthly - LEOKA Report Monthly - Supplementary Homicide Report Arrest Register - Adults (Race, Sex, and Age) Arrest Register - Juveniles (Race, Sex, and Age) Monthly Returns of Arson Offenses Monthly Returns of Domestic Violence Offenses Quarterly Hate Crime Report Return A - Property Stolen by Classification Return A - Additional Analysis of Larceny and Auto Theft Monthly Return - Evaluation of Stolen Property Monthly Arrest Report - Adult Monthly Arrest Report - Juvenile Vehicle Reports All Property By Responsible Officer Notice to Officer Notice to Owner (Impounded Vehicle) On -hand Vehicle Aging Report (By Storage Location) On -hand Vehicle By Officer On -hand Vehicle By Owner On -hand Vehicle By Storage Location Vehicle Inventory List (Items with Tag #) Vehicle List By Status Vehicle Next Action Report Impounded Vehicles in Custody Vehicles Towed/Impounded by Date Wants and Warrants Active Wanted By Officer Active Wanted By Wan Persarr Active Wanted List Active Warrants By City - (Name of City) 19 Item III - VLEADS RMS Syste9etailed Design *Huntington Beach, CA Warrants By City All Warrants By Officer Closed (Inactive) Wanted List Wanted List By Disposition Status Wanted Person's Vehicle List (Active) Warrant Card (For editing report purpose only) Warrant Disposition Statistics By Officer Warrant Received/Served Statistics by Division Warrant Received/Served Statistics by Document Type Warrant Served Statistics By Officer Active Wanted In Jail Weapons and Permits Concealed Weapon Application Approved - Not Issued Concealed Weapon Application By Date Concealed Weapon Application Cash Settlement Report Concealed Weapon Application Denied Concealed Weapon Application In Process Concealed Weapon Permit Issued (By Permit Order) Finger Print Card Editing Only In processing CW Application Over 75 Days Release Of Health Records Form (for form edit only) Gun Permit / Concealed Weapon History for Weapon (edit only) Weapon Reported Lost/Stolen Report (for edit only) 20 Item III - I/LEADS RMS Systetetailed Design Wuntington Beach, CA 1.45.2. WARS Standard Reports Default I/MARS reports are divided into two categories: Center Performance that assists decision makers in the management of resources, and Resource Utilization assists management in the utilization and deployment of field resources. Center Performance The default reports within the area of Center Performance are as follows. + Time to Enter Events This report measures the performances of calltakers by calculating the time required by an operator to enter data associated with an event. Time to Enter Events is defined as the amount of time elapsing between the time the event is accepted and the time the event is created. + Calltaker Accuracy The Calltaker Accuracy report computes the number of modifications to event data entered by the calltaker. Counts of the number of event type code changes and the number of address re-entries are provided. + Calltaker Workload This report calculates the number of events handled by calltakers from a designated logged -on time. + Time to Dispatch The Time to Dispatch reports measure the performances of dispatchers by calculating the amount of time required to send the first unit to an event after receiving a notification of the call from the calltaker. Total Time to Dispatch This report measures the overall performance of center personnel by calculating the time required to dispatch the first unit to an event after the initial call is received. + Dispatcher Workload Dispatcher Workload reports the number of events handled by a dispatcher from a designated logged on time. Event Statistics List This report groups a designated number of events by any combination of the defined selection criteria. + Event List This report provides a textual display of detailed information related to an event. + Event Chronology This report displays key occurrences in the progression of an event from creation to closure. Resource Utilization The default reports within the Resource Utilization area are as follows. + Unit Workload The following Unit Workload reports may be generated: Available by Agency Available Time by Dispatch Group Available Time by Unit Events Dispatched by Day of the Week Events Dispatched by the Hour of the Day Transports by Day of the Week Unit Response by Day of the Week 21 i Item III - IILEADS RMS System Detailed Design *Huntington Beach, CA • Demand Analysis The Demand Analysis report measures unit demand during each hour of the day. This report also displays the average event completion time during each hour of the day. Planned Coverage The Planned Coverage report correlates planned unit load to actual unit load for each hour of a specified day. • Event Handling Time This report provides an indication of the efficiency of unit personnel by computing the time elapsed between unit arrival at an event site and the time the event is cleared. • Response to Emergency Events This report calculates the time elapsed between a dispatcher's assignment of a unit to an event and the time the unit actually leaves enroute to the event. First Responding Unit Time The First Responding Unit Time report calculates the time elapsed between the dispatch of units to the event site and the time the first unit arrives on site. • Arrival to Transport Time This report calculates the amount of time elapsed between the arrival time of a unit and the time transport begins. Transport to Clear Time The Transport to Clear report computes the amount of time elapsed between the beginning of a unit's transport of a patient to a hospital and the unit's arrival at the hospital. • Create to Transport Arrive This report computes that amount of time elapsed between initial receipt of a call and delivery of a patient to the hospital. • Hospital Diversion The Hospital Diversion report displays the times in which units were diverted from primary hospitals to secondary hospitals. Event Statistics List This report displays the number of events that meet defined selection criteria. • Event List The Event List report details event information. • Event Chronology The Event Chronology report provides a historical synopsis of event progression. 1.46.1/LEADS Customized Reports Three customized reports were proposed by IPS. They are the California Accident Report, California Stolen Vehicle Report and Huntington Beach Missing Persons Report. Each is described in their respective sections below. 1.46.1. California MVA Report The requested accident report is the standard California Accident Report. The requested custom report requires a custom layout and a custom form for data collection. The report generated by I/LEADS will contain all the data fields currently contained on the California State Report CHP-555. This report will be prepared for viewing and printing. The City will be responsible for the actual transmittal of the State required report to the State. IPS requires a current copy of the report and written description of each field on the report with specifications for valid data and a contact person to provide additional information, if needed. 22 0 Item III - I/LEADS RMS System Detailed Design Huntington Beach, CA 1.46.2. California Stolen Vehicle Report The requested custom report requires a custom layout and a custom form for data collection. The report generated by IILEADS will contain all the data fields currently contained on the California State Report CHP-180. This report will be prepared for viewing and printing. The City will be responsible for the actual transmittal of the report to the State, if required to do so. IPS has a current copy of the report and but will need written description of each field on the report with specifications for valid data and a contact person to provide additional information. 1.46.3. Missing Persons Report The requested custom report requires a custom layout and a custom form for data collection. The report generated by I/LEADS will contain all the data fields currently contained on the current City Missing Person Report. IPS requires a current copy of each of these reports and written description of each field on the report with specifications for valid data and a contact person to provide additional information, if needed. 1.46.4. Uniform Crime Reporting Customizations Any UCR customizations not specifically stated in the RFP or this document must be mutually agreed upon between the City, in consultation with Huntington Beach UCR staff, and IPS. However, IPS agrees to provide to the City without additional costs beyond our yearly maintenance and warranty agreement any CA UCR required changes and/or updates that affect this customization so that CA UCR certification of the submitting departments is not endangered. IPS personnel will work with representatives from the City and the State of California to ensure the certification of Huntington Beach departments and that the formats and edit checks are compliant, and accepted by the State of California within an acceptable time period mutually agreed upon between the City and IPS during the development of the Implementation Plan. UCR data are exported in the CA UCR specific file format as outlined in the specifications received from the state. This export file is then output to the local hard disk for electronic submission to CA UCR and floppy disk. It is also printable. Once data is entered in a report, City personnel Specialist (or end user) will be able to verify if data entered will pass CA UCR submission: CA UCR checks can be run against a single incident, or against a group of incidents (data -range selectable). City personnel (or end user) will have ability to check work to see if required fields were overlooked or if there are any edit check errors. These fields and/or errors will be displayed so personnel can make corrections prior to incident record update. When it is time to run monthly submissions to the state, a program must be in place to validate the data. This function will allow supervisors to double check completed report data by City personnel (or end user). Any omissions or edit check errors will be displayed. Supervisor can make sure corrections are completed prior to submission to the state. 1,47.1I1-EADS Interfaces 23 • Item III - IILEADS RMS System Detailed Design *Huntington Beach, CA 1.47.1. Booking Data Transfer from IMAGIS IPS bids the development of an IILEADS Import Definition in ASCII delimited text to import data collected in the IMAGIS jail booking system into the IILEADS Arrest module. The import is restricted to data and data types as defined in the IILEADS database current on delivery of the product. The customer shall provide an authoritative contact for the duration of the development and implementation of this functionality to help define and test the interface. The City is responsible for providing the data export from the City's IMAGIS system. 1.47.2. CLETS Access from I/LEADS The City will access CLETS from the existing terminals in the records division. There will be no integration between CLETS and IILEADS. 2. IILEADS RFP Clarifications RDBMS Section Ref: Item #5 - Interface to existing field reporting data entry system IPS has proposed that Huntington Beach utilize the Field Reporting Module in IILEADS. Ref: Item #8 - Internal and standalone pawn processing IPS has proposed that Huntington Beach utilize the IILEADS Pawn Processing module. Ref: Item #11 - Internal affairs management ULEADS supports this through creation of an agency entity that then can set all access and security privileges for its use of IILEADS modules. Ref: Item #12 — Customized self -actualized system builder that enables users to design and implement additional modules The IILEADS GUI Customization tools enables the user to modify the properties of fields and controls and add fields to existing tables and forms. It does not enable the user to create new modules. Ref: Item #13,14 - Statistical report writing package for upper management Beyond the reports provided as part of the IILEADS standard deliverable, IPS recommends the use of third party reporting packages such as MS Access or Crystal Reports. IILEADS customers have a demonstrable record of success with these packages. Ref: Item #22, The system must comply with Federal regulations and state statutes for the electronic storage of Information on individuals IPS asserts that IILEADS complies with such regulations and statutes at customer sites where implemented. During Phase I, the customer must submit ali relevant regulations and statute conditions for consideration to ensure the IILEADS software meets these regulations or to develop the response. If the customer does not submit all relevant regulations before a contract is issued contract change order(s) may be required to comply with this requirement. Ref: Item #29 - Provides automatic query and update capability to all external databases used by the Police Department based on user defined criteria As stated, this requirement is too broad. See responses for particular databases in the RFP. IILEADS provides an Exportlimport capability by which users can specify, schedule and initiate manual or automatic imports and exports of data to one of several supported formats for getting data from an external database 24 Item III - I/LEADS RMS System Detailed Design Huntington Beach, CA or sending data to an external database. For query access, ODBC support is required of systems that need access to the PLEADS database. Ref: Item #34 - Include modules for Internal Affairs, Use of Force Monitoring and Applicant Files I/LEADS supports this through creation of an agency entity that then can set all access and security privileges for its use of PLEADS modules. Use of Force Monitoring requirements was not studied in Phase 1 to determine the costs of implementing support for this. IPS does not understand "applicant files" and needs more information if the City wishes to pursue this requirement. Ref: Item #36 - Provide a user definable character code to maintain the relationship, the type of name or named code from the data entry screen to the name data. PLEADS supported extensible and configurable code tables for use in validating data. Ref: Item #109 - Place a flag against an individual requiring automatic notification of public safety personnel should contact be made. Supported with BOLO alerts. However, what is likely wanted here is use of the Notification through the Organizer. The user would enter a name into the Names Module, then set the notification subscription flag. Ref: Item #110 - Flag can be placed requiring hit on exact name and at least one numeric Identifier. Name only Ref: Item #111 - Flag can be placed requiring hit on exact name only or possible name" match. Name only but can use AKA for possible name match. Ref: Item #1 l3 - Level of notification (immediate, routine, etc.) Notification proceeds as soon as the record flagged is accessed Ref: Item #114 - Immediate notification will send a system message, with character attributes, to the workstation on which the user requesting the flag is logged. A procedure for further notification will be invoked if user requesting the flag is not logged on. A notification is sent to the Organizer and will be presented when the user logs on. Ref: Item #116 - The system should provide the option to display Incident specific information from the name inquiry screen via hyperlink or drill down. The information can be accessed via opening other modules or through the Involvements Explorer which supports a treeview of involvement types. Clicking on a treeview leaf opens the information in the browser window and works in the same way as a hyperlink control. Ref: Item #117 - Any name inquiry carrying no numeric identifier will only automatically initiate a local database warrant check. NCIC/CJIS warrant checks can be made through a form. It is not automatically initiated by a name inquiry using numeric identifiers. Ref: Item #118 - Local database warrant check will default to a system -wide search unless user applies agency code for a specific search. A warrant check is applied to any agency for which the user has access rights unless restricted by the query conditions. Ref: Item # 119 - Any name Inquiry carrying one or more numeric identifiers will automatically initiate loc4i database and NCICICJIS warrant checks. NCIC/CJIS warrant checks can be made through a form. It is not automatically initiated by a name inquiry using numeric identifiers. 25 • Item III - I/LEADS RMS System Detailed Design *Huntington Beach, CA Ref: Item #230 - Inquiry on a name should provide a candidate screen displaying the actor code and all activity associated with the name, such as: multiple cases, warrant, vehicles, field interviews, property, associated locations, etc. IPS interprets the term "actor code" with codes such as victim, offender, etc. I/LEADS fully supports this feature through the involvements subsystem. Ref: Item #231 - The name inquiry candidate screen should display Identifying Information such as name, DOB, sex, race, actor code, and the Individual's identification number or the incident associated with the name if no identification number has been assigned. IPS interprets the term "actor code" with codes such as victim, offender, etc. I/LEADS fully supports this feature through the Tames Module and the involvements subsystem. Ref: Item #203 -The system should be able to attach several names to a single vehicle and indicate position of occupancy. Fully supported for Accidents. For Field Interviews, the positions of passengers is indicated in the Notes field Ref: Item #207, #223 - Create and maintain FI records containing base Master Name Relational Database fields and the following: Juvenile Consultations Persons interviewed are recorded in the Master Names Index and are flagged for Juvenile status Ref: Item #252 - Print list of registered ex-felon/sex offenders in accordance with state regulations. A custom report will be created to conform to the State of California regulations for registered ex-felon/sex offenders. The customer is required to provide all necessary documentation of the regulations and form format. The report will include information in accordance with the I/LEADS schema current on delivery of the product. Traffic Section Ref: Item #10 - Export citation and collision information to geographic display for management analysis. With the use of the integrated map display within I/LEADS, data can be analyzed directly within IILEADS without having to export the data to another location or database. If exporting data is ultimately needed, the I/LEADS export module can be used to extract data. Ref: Item #98 - Track requests from citizens for action related to traffic such as but not limited to speed complaints, reckless driving, abandoned vehicles. This can be supported through the Call For Service Module by extending the code list for call types. This can be done by the customer system administrator. A special report can be created by the customer using a third party report generator such as MS Access enabling the customer to track these CFS call types. Ref: Item #99 - Track citations issued as a result of service requests. This can be supported through the Call For Service Module by extending the code list for call types. This can be done by the customer system administrator. A special report can be created by the customer using a third party report generator such as MS Access enabling the customer to track these CFS call types. Ref: Item #101 - Compare citation locations and types with accident locations and types IPS will create a custom report based on the related citation, location and accident codes currently supported in I/LEADS. I cident & Crime Reporting Section Ref, Item # 16 - At a minimum, the report processing system must be capable of maintaining the following information on line LATILON 26 0 Item III - IIL.EADS RMS System Detailed Design 411-funtington Beach, CA IPS can support this by adding a Location Comment field to the Incident form which would preserve the original entry of LAT/LON. This input is typically converted to XY coordinates on entry. Ref: Item # 73 - At a minimum, the report processing system must be capable of maintaining the following information on line Video. A field can be added to a form by the customer using 1/LEADS GUI Customization that adds the name, or number or any owner applied identifier for a video tape. 27 r1 U 0 IV - COURSE CATALOG C SA I10011�/ IPS TRAINING CATALOG For City of Huntington Beach Prepared by Intergraph Public Safety TRAMING SER VICES C em IV- COURSE CATALOG FETY Table of Contents TRAI NIAG SERVICES I/CADTRAIN-THE-TRAINER(IPST2002).................................................................................................................3 I/LEADS TRAIN-THE-TRA[NER(IPST2203)............................................................................................................. 4 I/LEADS SYSGUI WORKSHOP(IPST2208)............................................................................................................ 5 I/LEADS ADMINISTRATOR(IPST2202).............................. ... .................................................................................. 6 /LEADS SYSTEM OVERVIEW(IPST2209)............................................................................................................... 7 /LEADS FIELD REPORTING (IPST2210)............................................................................... DATA AND SYSTEM OVERVIEW FOR I/CAD(IPSTI001)........................................................................................... 9 MAP FLNDAMENTALS WORKSHOP FOR I/CAD(IPST1002).................................................................................... 10 I/MARS USER(IPST2101)............................................................................... ...................................................... 1 I I/MARS ADMINISTRATOR(IPST2102)...............................................................................................................1.1. 12 I/NETVIEWER-I/NETDISPATCHER (IPST2401)....................................................................................................... 13 I/MOBILE USER (IPST2501)................................................................................................................................... 14 SYSTEM ADMINISTRATION I FOR I/CAD(IPST3101).............................................................................................. 15 SYSTEM ADMINISTRATION iI FOR I/CAD SYSTEMS (IPST3107)............................................................................ 17 SUPPORTING AND ADMINISTERING WINDOWS 2000 FOR IPS SYSTEMS(IPST3106)............................................... 18 CADDBM USER(IPST3102)............................................................................................... CADTOOLSUSER(IPST3103)................................................................................................................................ 20 MAP MAINTENANCE FOR I/CAD SYSTEMS(IPST3104).......................................................................................... 21 ........................................... IPS CUSTOMIZED TRAINING (IPST4XXX)............................................................... ... 22 M[CROSTATION FLNDAMFNTALS FOR MAPPERS (TSYS5002)................................................................................ 23 I NTEFE H „ein COURSE CATALOG PUBLIC SAFETY TRA INING SER VICEV I/CAD Train -the -Trainer (IPST2002) The 1/CAD "Train -the -"Trainer course is presented to customer staff that will be responsible for local agency training. This intensive course familiarizes customer -selected training staff with all features of'the CAI) I/Calltaker and I/Dispatcher applications, as well as I/NetViewer and/or I/NetDispatcher, and the skills required to impart this knowledge to others. User aspects of interfaces to external systems will also be introduced. This course has occasionally been taught early in the I/CAD project, serving more as an "WAD familiarization" session, rather than a typical trainer course. This type of arrangement is possible through agreement by the customer's project manager and the training manager. The complete "Drain -the -"Trainer agenda is a combination of I/CAD Calltaking Essentials, I/CAD Dispatching Essentials, ICAD Supervisor, and I/CAD Advanced user. Additional topics cover training issues and fundamentals unique to I/CAD specific instruction. Major Topics b Calltaking Operations b Mapping, Routing, and utilities b Dispatching Operations b Supervisor Functions in CAD b I/NetViewer- I/NetDispatcher Operations (if necessary as part ofthe customer's system) b Interfaces for Users (I/Informer, 1/1'age, I/FST, I/MDT) * System -related Supervisor Tasks, such as Database Recovery and 'Troubleshooting b 'Training Concepts for CAI) * Configurable System Options Prerequisites * Responsibility for supervision or training Method Conducted on -site by 11"S personnel Task Classifications System Administrator and "Training personnel Project Phase Should be conducted after the I/CAD database and I/CAD map have been created. If IPS is not conducting operator training, this class is recommended to be held at a minimum of one month before operator training commences to allow the customer's trainers adequate time to prepare Duration 80 hours Student Capacity Six, with a maximum of one student per workstation 1NTERGWH ... !m 1 V - COURSE CATALOG PUBLIC SAFETY TRAININGSF.RVICF..S ULEADS Train -the -Trainer (IPST2203) /LEADS 'I'rain-the-"I'rainer is presented to personnel responsible for local agency training. 'I'he course familiarizes records and patrol personnel with the basic features of 1/LEADS and provides the skills required to impart this knowledge to others. Major Topics * Interface Basics b Involvement Subsystem * Data F.ntry * Queries and Reports b 'braining Concepts Prerequisites b Responsibility for RMS supervision or training Method Conducted on -site by IPS personnel Task Classifications I/I.F.ADS Operator, System Administrator, and 'I'raining personnel Project Phase After the database tables have been created Duration 32 hours Student Capacity 12, with a maximum of two students per workstation 1 NTERGW H „e t IV - ('0URSI. ('AIAL 0(; PUBLIC SAFETY TRAININGSF.RVIC'P'.S ULEADS SYSGUI Workshop (IPST2208) The I/I.EADS SYSGUI Workshop provides a system administrator with methods to modify the I/LEADS product to conform more to local requirements and needs. The workshop provides the administrator the tools needed to perform these modifications. It should be noted material covered during this workshop affects the product and database directly and can have a negative impact if improperly performed. Major Topics b Understanding Local Requirements for Implementing I/LEADS b System 'Fools b System Components b Overview of I/I.EADS Modules b Configuration Tools b Documentation Prerequisites * System Administrator, Management, Supervisor, Trainer or decision making position * Responsibility for administration of I/LEADS * Set-up of minimal I/LF,ADS hardware and software Method Conducted on -site by HIS personnel Task Classifications System Administrator, and Management personnel Project Phase Immediately after I/LEADS Administrator Training and before any User or "Frain -the -Trainer training Duration 16 hours Student Capacity "Three 1 NTERGW H „rm /V - COURSE CATALOG PUBLIC SAFETY TRAINING SERVICE.V I/LEADS Administrator (IPST2202) I/LEADS Administrator Training is presented to personnel responsible for maintaining I/LEADS. The course familiarizes administrative personnel with the basic features of l/LEADS and how to maintain the various data used by the system. Major Topics b I/LEADS Software Installation b I/Leads Software Configuration * Controlling Access b Data Collection * Working with the Database * Basics of F ield Reporting b Loading Add -ins * Installing/Configuring I/LEADS Link Prerequisites b Responsibility for installation and local implementation of the I/LEADS System b Responsibility for supporting and administering an Oracle database Method Conducted on -site by HIS personnel Task Classifications I/LEADS, System Administrator, and 'Graining personnel Project Phase Immediately before or during the database creation phase Duration 24 hours Student Capacity Six, with a maximum of two students per workstation 1 NTERGWH PUBLIC SAFETY �m lV - COURSE CA7ALOG TRAINING SERVICE.V I/LEADS System Overview (IPST2209) The 1/LEADS System Overview seminar provides a system preview and guidance to System Administrators and managers of the customer's implementation team. Data collection and local configuration of the I/LEADS database is vital to ensure the system is ready for future training classes. This seminar provides the customer's implementation team with the information needed to begin data collection and configuration of the database prior to training courses such as System Administrator and Train -the -'Trainer. The overview will also focus on the agency determining which modules will be trained to which users. Since not all users will be trained on all modules, during the overview the agency can begin to develop their training plan requirements. Special emphasis is placed upon building the User / Group Administration and [JCR to Statutes tables. "There will not be "hands-on" at this early stage. Major Topics b Understanding Local Requirements for Implementing 1/1,EADS b System Tools and Components a Overview of I/LEADS Modules b Demo of I/LEADS Software b Local System Configuration b Configuration Tools * UCR to Statutes 'fable * System Ncklist "fables Prerequisites b System Administrator, Management, Supervisor, Trainer or decision -making position Knowledge of local 113R / UCR requirements b Set-up of minimal I/LEADS hardware and software Method Conducted on -site by HIS personnel Task Classifications System Administrator, Management, Supervisor and Training personnel Project Phase Immediately after appropriate delivery and set-up of minimal I/LEADS hardware and software Duration 16 hours Student Capacity Based on the customer's requirements, available hardware and projection systems a NTERGWH IV - ('0URSE CATALOG PUBLIC SAFETY TRAINING SF.RVICES ULEADS Field Reporting (IPST2210) 1/LEADS Field Reporting 'Training is presented to personnel responsible for entering data or querying I/LEADS in a tield environment. 'I'he course familiarizes patrol personnel with the basic features of I/LE.ADS Field Reporting capabilities. Major Topics b Interface Basics * Involvement Subsystem b Searching b Data Entry b Reports & Queries b 'Transferring Data Prerequisites b Responsibility for Incident creation in a Field Environment Method Conducted on -site by HIS personnel Task Classifications I/LEADS Operator, System Administrator, and "Training personnel Project Phase After I/LEADS database tables have been created Duration 16 hours Student Capacity 12, with a maximum of two students per workstation 1 NTERG H I,CM IV- CY)(/R.SE (A7A[.(X, PUBLIC SAFETY TRAININGSF.RVICE.S Data and System Overview for I/CAD (IPST1001) The Data and System Overview is a workshop designed to give guidance to the customer's implementation team in the tasks necessary to design, define, and gather the data necessary for the effective and efficient building of'the I/CAD or InService database and map. A detailed overview ofthe system components is included, along with a discussion of'available configuration and customization options. Critical data components that must be supplied by the customer are extensively described and discussed so that the impending data collection process occurs with ease and the necessary data is ready for input during the CADDI3M course. Managerial, technical support, and operations personnel should all be participants in this seminar to ensure that all essential input is received for successful system definition. 'typically this workshop is combined with the Map Fundamentals Workshop, and portions of'each are conducted concurrently. Major Topics * System Components and Terminology b Database Structure including Table Building/'Fable Functions b Data Collection and Quality Control b Configuration Tools and Process b Map Functionality * Workflow/Resource Allocation and Information Exchange Prerequisites a Management, decision making, or data collection/data entry position * Appropriate delivery and setup of minimal I/CAD hardware, as arranged with the instructor Method Conducted on -site by IN personnel Task Classifications System Administrator, Mapping Support, Database Support, Senior User and/or Supervisor, "Braining, and Management personnel Project Phase Immediately after design acceptance Duration 28-32 hours; If scheduled in conjunction with Map Fundamentals workshop, may be extended to 36 hours, dependent upon instructor analysis of customer requirements and configuration Student Capacity Based on the customer's requirements, available hardware, and projection systems availability 1 NTERGWH PUBLIC SAFETY „em IV - COURSE CATALOG TRAINING SF.RVICE.S Map Fundamentals Workshop for I/CAD (IPST1002) 'Fhe Map Fundamentals Workshop seminar focuses on the building of the land base used in I/CAD, as well as identifying the participation and relationship of' IPS personnel in this activity. It also identifies the geometrical map needs and database structure necessary to run the I/CAD or InService System. Address verification methods and requirements, response area (beat/zone/district) definition, and the quality of the customer's intended source map data are all topics introduced and discussed in this session. "I'his workshop is customized to each system's map source and may require site visits and pilot data from the current map source, though no map translation or hands-on map work is actually performed during this time. "I'he definition of' an InService customer's migration workflow, which includes those tasks necessary to translate or import data from the AM/FM GIS source, is not part of this workshop. "Those tasks are defined as custom procedures for every customer and will be laid out in a separate consulting session. Major Topics b Database Uesign and Setup as it Relates to Address Verification * Map Requirement Definition * Translation (if necessary) of Data to the Necessary Format b Definition of' Personnel, Resource, and Scheduling Requirements b Identification of Data Workflow and Map Validation Routines b Future Enhancements Prerequisites b Beat/'Lone/District and dispatch understanding * System Administration responsibility or responsibility for map creation/editing * Possible site visits and pilot data Method Conducted on -site by IPS personnel Task Classifications System Administrator, Mapping Support, Database Support, and Project Management personnel for all involved agencies Project Phase Immediately after design acceptance; typically conducted in conjunction with the Data and System Overview workshop Duration 16 hours; I iowever, if scheduled in conjunction with Data and System Overview workshop, one day is conducted with entire workshop audience, and the other day will focus on mapping support staff only and may include an off -site visit to review map source and data Student Capacity Based on the customer' requirements, available hardware, and projection system availability item IV- CURSE C'AT ALOG PUBLIC SAFETY TRAINING SF_RVICE.V UMARS User (IPST2101) The I/MARS User course familiarizes the user with the basics of'analyzing data with the I/Viewer module of I/MARS. The basics of the application interface, and the use of I/MARS to create various output types are covered, along with minimal configuration and customization. Major Topics b Application Component Overview * Creating Map Output b Creating Chart Output * Creating Spreadsheet Output b Creating Report Output b Customizing Output b Saving Options Prerequisites * familiarity with Windows user interface * Understanding of the basic concepts of' CAD, CAD and/or RMS event data * Responsibility for event/call analysis reporting, or the use of such information Method Conducted on -site by IPS personnel Task Classifications System Administrator, Mapping Support, Database Support, and 'Draining personnel; any personnel responsible for performing event data analysis Project Phase Approximately one month or later after live CAD/CAD/RMS operations Duration 8 hours Student Capacity 12, with a maximum of two students per workstation 1NTERGWH PUBLIC SAFETY ucm IV- COURSE CATALOG TRAINING SERVICES UMARS Administrator (IPST2102) I/MARS Administrator "Training is presented to personnel responsible for the administration and support of the I/MARS suite of applications. The course familiarizes administrative personnel with the maintenance, support, and customization of the I/MARS product, plus the maintenance of the various data used by the system. Configuration of 1/MARS with I/Administrator and I/Analyst is covered, along with the customization of applications for use with I/Viewer. Major Topics b Installation and Setup of I/MARS b Configuring I/MARS * Using I/Analyst to Customize Applications b Managing Security for Users and 'fopics a Managing Software Upgrades and Version Control, especially with respect to the database Prerequisites b I/MARS user training (IPST2101) b Familiarization of CAD/CAD/RMS database model and data b Training in or equivalent knowledge of I/CAD or I/CAD System Administrator, Oracle SQL, ODBC/SQLNet concepts, Microsoft Access, Microsoft Excel, and Microsoft Windows 2000 Method Conducted on -site by IPS personnel Task Classifications System Administrator, Database Support, or other personnel responsible for reporting and analysis requirements definition and management Project Phase Approximately one month or later after live CAD/CAD/RMS operations Duration 16 hours Student Capacity Six, with a maximum of two students per workstation r J NTERGWH crenr IV - COURSE ('ATALUG PUBLIC SAFETY TRAININGSERVICES I/NetViewer-I/NetDispatcher (IPST2401) 1/NetViewer and I/NetDispatcher training is presented directly to personnel responsible for operations, either I/CAD or I/CAD at a remote facility. It familiarizes personnel with the commands used in the 1/NetViewer and/or I/NetDispatcher application during event entry and inquiry operations. Laboratory exercises are included with each module to provide additional experience in workstation operation. 'I'his course is required for proper system operation with 1/NetViewer and/or 1/NetDispatcher and can also be taught by graduates of the I/CAD or I/CAD 'I'rain-the-'I'rainer courses. Major Topics b Event Entry Operations b Inquiry Commands b Unit or Crew Operations b Setting User Preferences b Other Utilities Prerequisites * Knowledge of'appropriate system (either public safety or utility) terminology b Knowledge and familiarity with Windows user interface b Knowledge and familiarity with at least Internet Explorer version 4.0 Method Conducted by IPS personnel either on -site or in I luntsville Task Classifications Operator, System Administrator, Mapping Support, Database Support, "Draining, and Management personnel Project Phase Should be complete with adequate time to prepare for cutover Duration 8 hours Student Capacity 12, with a maximum of two students per workstation INTERGWH iiem IV - c'OURSE CATALOG PUBLIC SAFETY TRAININGSF.RVICES UMobile User (IPST2501) I/Mobile User training is designed to train field users in the use of the I/Mobile product. (Note: I/Mobile Administration is included during the System Administrator 'Training, and pertinent topics covered during the regular I/CAD or [/CAD Train -the -'Drainer and Operator/User courses. This session is for field users who have not been trained as I/CAD operators. Major Topics b Use ol' I/Mobile on MC'Ds, MDTs, or laptops b Unit Status Changes b Inquiries Prerequisites b Responsibility for mobile computing operations Method Conducted on -site by IPS personnel Task Classifications Field User personnel Project Phase After I/CAD or 1/CAD Operator/User training is complete, and before cutover Duration 6 to 8 hours, dependent upon customer needs Student Capacity 12, with a maximum of two students per workstation INTERGW H PUBLIC SAFETY „em lV - COURSE, CATALOG TRAINING SERVICES System Administration I for I/CAD (IPST3101) The System Administration I course is an intensive course designed for individuals responsible for the technical administration, management, or support of the I/CAD or InService System. "fhe System Administrator should be designated early in the project, as their involvement full time in the installation and implementation of'the system is critical to each agency's success and the overall success of the I/CAD or InService System. Students receive both classroom training and hands-on experience enabling them to perform the basic functions associated with the day-to-day operation and support of an I/CAD or InService System. Please note the stated prerequisites and student capacity, as strict adherence to these is essential to the successful completion of this course. Major Topics b I Iardware Layout b Network ("fCP/1P) Configuration b Database Introduction, including Oracle Setup and RADO Configuration and Use a Software Component Overview and Installation b Changing Parameter Settings b Command Line Configuration a Customizing the I/CAD GUI with C++ b Maintaining I/CAD Configurations Prerequisites Strong adherence to the following prerequisites is absolutely mandatory: b Responsibility for the installation and implementation of the I/CAD System b Working knowledge of an operating system, such as Windows 98/ME/XP, or Windows NT/2000; Working knowledge ofmajor networking components, including clients, servers, local area networks, network adapter cards, drivers, protocols, and network operating systems b Proficiency using the Windows 2000 interface, including the ability to use Windows Explorer to locate, create, and manipulate folders and files, create shortcuts, map network drives, and configure the desktop environment a Knowledge of basic computer hardware components, including computer memory, hard disks, central processing units (CPUs), communication and printer ports, display adapters, and pointing devices a CADTools User (if -appropriate), CADDBM User, and all appropriate database/operating system training as necessary (unique per customer) b Attendees of this course must attend the System Administration II course, taught later in the project to obtain full system administration training. I ent IV - COURSE (A7ALOG PUBLIC SAFETY TRAINING SERVICES System Administration I for I/CAD (IPST3101) (cont'd) Method Conducted by INS personnel on -site or in I luntsville Task Classifications System Administrator, Mapping Support, Database Support, and 'training personnel Project Phase After CADDBM training is completed and before user or "Train-the- "I'rainer training commences. Duration 40 hours Student Capacity Six, with a maximum of two students per workstation 1NTERGWH em IV - C'OUR.SE CATALOG PUBLIC SAFETY TRAININGSERVICE.S System Administration II for I/CAD Systems (IPST3107) "I'he I/CAD System Administration II course covers the administration of interfaces, including configuration and troubleshooting procedures. Other topics are also covered to provide additional methods of I/CAD application configuration, including macros and print templates. Please note the stated prerequisites and student capacity, as strict adherence to these is essential to the successful completion of'this course. If time permits, review of'topics covered in System Administration I may also be part of' this course. Major Topics b "Troubleshooting b Database Redundancy b Creating I/CAD Command Macros a Modifying Message files b Updating Print 'Templates b Managing Interfaces Using ISM b Configuring External Messages with ESMD b Configuring and Maintaining Interfaces b I/NetViewer & I/NetDispatcher Administration Prerequisites b It is mandatory that attendees of this course will have completed the System Administration I course. Method Conducted by IPS personnel on -site or in Huntsville Task Classifications System Administrator, Mapping Support, Database Support, and "Draining personnel Project Phase Just prior to live operations and after interface installation is complete and configuration issues have been resolved Duration 40 hours Student Capacity Six, with a maximum of two students per workstation I NTEf-7WH „em IV - COURSE CATALOG PUBLIC SAFETY TRAINING,SERVICF.S Supporting and Administering Windows 2000 for IPS Systems (IPST3106) This course provides students with the knowledge and skills necessary to perform post - installation and day-to-day administration tasks as related to the Microsoft Windows 2000-based network used in the I/CAD and I/CAI) System. It is intended for support professionals who install, customize, configure, and support the system and is tailored to cover those Microsoft Windows 2000 topics essential to the successful maintenance and support of the I/CAD System. Major Topics b Installing and Configuring Windows 2000 Server and Windows 2000 Professional * TCP/II', DNS and Active Directory b Managing File Resources (Network and Local) a Disk Management and Disaster Protection * Installing and Configuring the Network Environment, including DIICP, WINS b Performance Analysis and 'Troubleshooting "Tools Prerequisites b Responsibility for installation and implementation of the system b Working knowledge of an operating system, such as Microsoft MS-DOS, UNIX, Windows version 3.x, Windows for Workgroups, Windows 98/ME, or Windows NT/2000; Working knowledge of major networking components, including clients, servers, local area networks, network adapter cards, drivers, protocols, and network operating systems b Proficiency using the Windows 98/ME or Windows NT 4.0, or Windows 2000 interface, including the ability to use Windows Explorer to locate, create, and manipulate folders and files, create shortcuts, and configure the desktop environment b Knowledge of basic computer hardware components, including computer memory, hard disks, central processing units (CPUs), communication and printer ports, display adapters, and pointing devices Method Conducted by IPS personnel either on -site or in I luntsville Task Classifications System Administrator, Mapping Support, Database Support, and System Support personnel Project Phase This training should begin before the operator classes begin, soon after the full hardware configuration is delivered on -site Duration 32 hours Student Capacity Six, with a maximum of two students per workstation 1 NTERGWH „em IV - COURSE (A TA L PUBLIC SAFETY TRAINING SERVICES CADDBM User (IPST3102) 'I'he CADDI3M User course is presented to customer personnel responsible for the creation and maintenance of the I/CAD or InService System database. Students will utilize actual data from their agency to create segments of a working database and will receive hands-on practice in data entry, update, deletion, and inquiry. Major Topics * Collection and Entry of Data b Navigating CADDI3M Dialogs b 'I'able I3uilding b Auditing CADDBM Use b Quality Control Prerequisites b Responsibility for data entry b Knowledge of basic terminology and data tables b Data and System Overview Method Conducted on -site by IPS personnel Task Classifications System Administrator, Database Support, and "Training personnel; anyone else who will be maintaining data for WAD and InService Project Phase After the map is ready for operations Duration 24 hours Student Capacity 12, with a maximum of two students per workstation a NTERGW H V - c OUR.4F. CA7ALOG PUBLIC SAFETY TRA INING SER VICE,'Y CADTools User (IPST3103) The CADTools User course is presented to personnel responsible for the creation and maintenance of the I/CAD or InService street map. As part of CADTools training, students will use actual data from their agency to create segments ofa working database and will receive hands-on practice in entering, updating, deleting, and inquiry. Major Topics b Street Map Overview * Map -related Database Structures * Address Verification b Polygon -based lleployment Plans a Street Network Applications b CAD'I'ools/MicroStation Introduction * Map Editing 'fools * Intersection and Segment Manipulations b Special Address Manipulations * Enhancements and Reference Files b Remap Application/Showmap Application Prerequisites b Responsibility for data entry and/or map editing b Knowledge of basic I/CAD or InService terminology and data tables * Familiarity with area geography and operational requirements b Familiarity with MicroStation to aid in the understanding and retention of CADTools concepts. It is best that all students will have taken the MicroStation for Mappers ('I'SYS5002) course to meet this prerequisite; see Additional "Training Options section for information on this course. Method Conducted on -site by IPS personnel Task Classifications System Administrator, Mapping Support, Database Support, and 'Training personnel Project Phase After the map is ready for operations Duration 32 hours Student Capacity Six, with a maximum of two students per workstation .I NTERGWH „em IV - ("0URSE CATALOG PUBLIC SAFETY TRA INING SER VICEV Map Maintenance for UCAD Systems (IPST3104) The Map Maintenance course familiarizes and emphasizes the map maintenance workflow to be carried out at the particular customer site. It will be a highly customized class, with subject matter depending upon several important variables, such as whether the agency is maintaining its own map data, whether a local GIS provider is maintaining the map (and in what format), whether translation software is needed to make the workflow easier, and the frequency with which updates will be completed. "I'his informal class will leave the responsible System Administrators with a workflow and document to complete the process successfully themselves. "I'he class will be conducted using the designated map maintenance workstation, and all required mapping software (depends on customer's system) must be installed and functional. This course will not cover the migration tasks necessary for importing AM/FM type data into the InService system. 'Fhose tasks will be detailed in a separate consulting session. Major Topics * Collection and Entry of Data b Map Validation and Network Building Routines a 'Table Building, Restructuring, and Updating b Quality Control a Re -mapping and Loading of New Map Data on User Workstations and Servers Prerequisites b System Administration and/or responsibility for map creation/maintenance b Complete familiarity with the process of map creation as it relates to the customer's data, including knowledge of basic terminology and data tables b MicroStation and MGI; familiarity, or completion of courses MicroStation for Mappers ('I'SYS5002) and MGE Foundations ('TMAP2100); see Additional "Training Options for more information on these courses. b Data and System Overview and Map Fundamentals Workshop Method Conducted on -site by IPS personnel Task Classifications System Administrator and Mapping Support. Possible involvement by Database Support, and Project Management personnel Project Phase After the method and theory of the the customer's actual map maintenance has been resolved and before cutover Duration 24 to 40 hours, dependent upon customer needs Student Capacity Six, with a maximum of two students per workstation a NTErRGWH ,.en► IV - C'OURSE FATALOG PUBLIC SAFETY TRAININGSERVICF_S IPS Customized Training (IPST4XXX) Customized training is often requested by a customer when existing course offerings do not cover the detail needed, or often times, cover too much detail for the customer's target audience. Such courses will be designed and created according to those specialized needs after consulting with the customer to ascertain the exact content desire. Major Topics Dependant upon the customer's requirements for customized training Prerequisites * Knowledge of basic public safety terminology b Knowledge and familiarity with Windows user interface Method Conducted on -site by HIS personnel Task Classifications All Project Phase All operator training should be completed two weeks before parallel operation Duration As necessary Student Capacity Based on the customer's requirements aNTERGWH PUBLIC SAFETY uem IV - CURSE CA7ALOG TRAINING SERVICES MicroStation Fundamentals for Mappers (TSYS5002) MicroStation Fundamentals for Mappers is designed for first time users. The course will cover basic Windows Nf/2000 manipulations in addition to the MicroStation 21) graphics commands. The last day of the course is a discussion of relational databases, the Intergraph Relational Interface System and how to tie it all together. The course has extensive hands-on exercises to reinforce concepts presented by the instructor. This course is not designed for System or Database creators; they are encouraged to take the system/database courses. Major Topics b Computer and Design File Setup b Basic Windows NT/2000 Manipulations/Commands b Design Klement Placement a Precision Input b Design Element Manipulation b Digitizing * Cells b Text Placement b Reference Files b 3 D Overview b Introduction to Relational Databases and RIS Prerequisites * Familiarity with Windows operation Method Conducted at the Intergraph I leadquarters training facility or a regional Intergraph training facility Task Classifications System Administrator, Mapping Support, and Database Support Project Phase This training should start when the project starts. Priority should be on implementation team members Duration 40 hours Student Capacity Based on the customer's requirements INTERGWH 'Jem IV - COURSE CATALOG PUBLIC SAFETY TRAINING SF.R]VICES I/CAD Report Writing 1/CAD Report Writing is presented to personnel responsible for the administration and support of writing custom CAI) reports. This class involves schema information from where the typical data tables and fields will be pulled, software used in how to write reports (Access, SQI„ etc...), and then practical time with the customer to get them started. Major Topics * Installation and Setup of I/CAD Reports b Configuring I/CAD Reports b Example report writing b "Fable structure and data descriptions Prerequisites b "Training in or equivalent knowledge of I/CAD or I/CAD System Administrator, Oracle SQI„ 0DI3C/SQI,Net concepts, Microsoft Access, Microsoft I'Acel, and Microsoft Windows 2000 Method Conducted on -site by HIS personnel Task Classifications System Administrator, Database Support, or other personnel responsible for reporting and analysis requirements definition and management 24 hours Duration Student Capacity Six, with a maximum of two students per workstation ITEM V CAD Command Line/Macro Reference Document For City of Huntington Beach Prepared by Intergraph Public Safety Revised 10/31/02 Item V -CAD Command Line Reference • City of Angton Beach, CA Preface During the Phase I of the project, IPS CAD implementation personnel customized certain command line entries to allow City personnel to test out command line functionality. This had limited success due to a lack of information provided to City personnel. IPS personnel will snake changes to this file to accommodate the City's workflow, to the extent that is supported by the base CAD system. IPS personnel will also train administrative personnel within the City to edit this file and make their own configuration changes. The configuration of command line and macro functionality will be a joint effort between the City and IPS. Description This file defines the localized command key -ins. Blank lines and lines with "" in the first position are ignored. The first word on each line is the command key for the software. It MUST NOT be modified. The second field is the command class. There are sixteen classes available, which are numbered (for historical reasons) 49 to 64. The delivered defaults are: Class 49 for Supervisor commands Class 50 for Dispatcher commands Class 51 for Calltaker commands (Usually a supervisor will have access to all three classes, a dispatcher will have access to dispatcher and calltaker classes, and a calltaker will have access to only the calltaker class.) The third field on each line specifies any parameters that may be configured as optional or mandatory. A minus sign before a parameter letter means the parameter is optional. A plus sign means mandatory. You may not add or remove parameters from each command, but you may change the optional/mandatory flag. The optional/mandatory flags apply to the command no matter if it is invoked by keyin, menu selection, or toolbar button. The actual parameter letters and their meaning depend on the command, but usually "M" means mileage and "C" means comment. The rest of the words on each line are the command key -in, and may be configured to meet the city's needs. Alternate key -in definitions are separated by commas. The order of this file is not important to the software. After the command key -in, you may specify command switches for parameters that may be entered positionally. Then, if a user keys in that command and one or more parameters without switches, the specified switches will automatically be inserted. Example: DISPLEV 51 - DEV, Display Event -E The keyin: display event 211 would be converted to: DISPLAY EVENT -E 211 The positional parameters apply to the command, not the a specific alternate key -in. So in the example "DEV 211" would work as well. Example: LNCLR 50-M-C-DClear Unit, CLR -U -M -D -C The keyin: CLR l A 12 22456 GONE "No one there" would be converted to: CLR -U 1Al2 -M 22456 -D GONE -C "No one there" This version also allows the command to be entered later in the command line, so the keyin "1Al2 CLR" would be converted to "CLR -U lAl2". However, if the 2 • Item V - CAD Command Line Reference City of Aington Beach, CA PosParamDelim parameter is set to something other than the default, the command must always come first on the command line. Different keyins can be configured to run the same command but with different command line arguments. For example, the Field Event command can be configured to have separate keyins for the Subject Stop, Subject Pursuit, Traffic Stop, and Traffic Pursuit options. The following example illustrates this feature. FLDEVT 50 Field Event, FEV FLDEVT 50 Traffic Stop +TS FLDEVT 50 Traffic Pursuit ­TP FLDEVT 50 Subject Stop -SS FLDEVT 50 Subject Pursuit+SP The "+" preceding TS, TP, SS, and SP indicates that these are command line options that should be added to the command line by default, without requiring the CAD operator to key them in specifically. So, keying in "Traffic Stop" on the command line is the same as keying in "Field Event -TS." Positional parameters can be combined with default parameters in the same configuration, e.g. FLDEVT 50 Traffic Stop +TS -U In this configuration, keying in "Traffic Stop U1" is the same as keying in "Field Event -TS -U U1." If default parameters are configured for the command line, they can also include hardcoded values if needed. Consider the following example configuration. FLDEVT 50 Traffic Pursuit +TP +C "Pursuit in progress" In this configuration, keying in "Traffic Pursuit" is the same as keying in 'Field Event -TP -C "Pursuit in progress".' If a command line is used repeatedly, one execution after another, the command line can be configured to automatically appear in the command keyin field immediately after execution, saving the CAD operator from keying the entire command sequence in again. Additionally, specific parameters can be included in the command keyin field based on the parameter values entered for the previous command execution. The following example configuration demonstrates this functionality. ADDEVCOM 51 -u Add Event Comments, EVC The lower case %u" in the list of optional parameters identifies this command line as one to automatically place in the command keyin field after execution. In addition, if a unit was specified in the previous execution, that same unit will appear again in the command keyin field. Thus, after executing the command "EVC -U U 1 -C comments", the characters "EVC -U U I " will appear in the keyin field again, saving the CAD operator several keystrokes when entering further event comments for that unit. Note that the command line option must be listed in lower case in the optional parameter list in order to activate this functionality. ACCADEV 51 - Accept Advised Event ACCCLEV 51 -C Accept Closed Event ACCEMGEV 51 - Accept Emergency Event ACCEVT 51 - Accept Event ACCHOT 51 - Accept Hot Call ACCLV 51 - Accept Location Verify ACTMAP 51 - Activate Map #### Acknowledge Unit #### # Configurable Options: L - location, M - mileage, C - comment ACKUNIT 50 -L-M-C Acknowledge Unit ADDEVCOM 51 - Add Event Comments 3 0 Item V - CAD Command Line Reference City of Angton Beach, CA ADDSCR 51 - Add Scratch ADDSPSIT 50 - Add Special Situation ADDSUPP 51 - Add Supplemental Information #### Add Unit History #### # Configurable input: C - comment ADDUHIS 50 -C-V-S-E-L-D-T-1-2-34 Add Unit History AGRRESP 51 - Agreed Response ANIALI 51 - ANI ALI ANIDEMO 51 - ANI Demo #### Arrive Unit #### # Configurable Options: L - location, M - mileage, C - comment # N - use case number functionality, I - case number ID # T - time in status (alarm time) ARRVUNIT 50 -L-M-C-N-1-T Arrive Unit ASI 51 - Automatic Supplemental Information #### Assign Result Code #### # Configurable Options: D - detailed event type, Q - qualifier ASRESCD 51 +D+Q Assign Result Code ASSCASE 51 - Assign Case Number #### Assist Unit #### # Configurable Options: M - mileage ASSIST 50 -M Assist Unit AUTOFF 51 - Autolevels Off AUTON 51 - Autolevels On AVLOFF 50 - AVL Off AVLON 50 - AVL On AVONEV 50 - AAvaiiable On Event -U BRDDEL 50 - Broadcast Delete, BCSTDEL BRDHOLD 50 - Broadcast and Hold, BCSTHOLD BRDINFO 51 - Broadcast Information, BCSTINFO BRDl\CAI\ 50 - Broadcast and Cancel, BCSTCAN BRDSRCH 50 - Broadcast Search, BCSTSRCH BRDSUM 51 - Broadcast Summary CANCASE 50 - Cancel Case Number, CASEX CANEV 50 -C Cancel Event, CANEV CANREQ 51 +C Cancel Request, CAREQ CANSCHEV 50 - Cancel Scheduled Event, CNSE CHDEPLO 50 +A+D Change Deployment Table, CHNGDEPTBL CHDISPO 50 - Change Disposition Code, CDC CHGAVST 50 - CAS, Change Available Status -U -S CHGUNST 50 - CUS, Change Unit Status -U -S -A CHLOC 50 -L-M-A-U Change Location, UL -U -L CHNUM 50 - Change Unit Number, CHNGUNIT CHOP 51 - Change Operator, CHNGOP CHPASS 51 - Change Password, CHNGPW CHPRT 51 - Change Printer #### Clear Event #### # Configurable Options: M - mileage, C - comment D - disposition code CLREVT 50 -M-C-D Clear Event, CLEV CLRFNC 51 - Clear Fence CLREVT 50 - Close Event, CLOEV CMACRO 51 - Create Macro, CMACRO COORDRO 51 - Coordinates COPYEV 51 - COEV, Copy Event CREASSEV 51 - CAE, Create Associated Event CRREVT 51 - CEV, Create Event, -I -L -T +X 4 • Item V - CAD Command Line Reference City of 1-10 ngton Beach, CA CRESCHEV 51 - Create Scheduled Event, CSE CRVBL 51 - Create Verbal Instructions, CVBINST DA 50 - Dispatch Assigned, DA DATOP 50 - Dispatch Assigned Top DBGDOFF 51 - DBG DEPTH OFF DBGDON 51 - DBG DEPTH ON DBGOFF 51 - DEBUG OFF DBGON 51 - DEBUG ON DBGSEV 51 - DBG SHOW EVENT DBGSFL 51 - DBG SHOW FILTERS DBGSLOC 51 - DBG SHOW LOCATION DBGSMD 51 - DBG SHOW MODE DBGSUN 50 - DBG SHOW UNIT DBGTREE 51 - DBG TREE DBSTAT 51 - Database Status, DBST DEFRND 49 - Define Remote Node, REMOTE DEFRTE 51 - Define Router, DFROT DFNODE 51 -A-R Define Node, DEFNODE DISCAD 51 - DISCAD, Display CAD DISPDG 51 - DDG, Display Dispatch Group DISPLEV 51 - DEV, Display Event -E DISPLINE 50 - LINEUP, Lineup Display DISPLOI 51 - Display Location of Interest, LOI DISPNUM 49 - Display Numbers, DN DISPTASKF 50 +T Dispatch Taskforce, DT #### Dispatch Unit #### # Configurable Options: L - location, M - mileage, C - continent DISPUNIT 50 -L-M-C Dispatch Unit, DSPU DIVCLEAR 51 - DC, Divert Clear # Configurable Options: T - divert type, P - authorizing individual, # N - call back number, C - comments DIVHOSP 51 -T-P-N-C DH, Divert Hospital DLGCPY 51 - Dialog Copy, DLGCPY DLRTE 51 -W-N Display Last Route, DISROT DLVW 51 - Delete View -N DMPCMD 51 - DBG SHOW COMMANDS # Post display - see also PDON and PDOFF DPOST 50 - Toggle Post Display DRDCL 51 - Toggle Road Closure Display DRDCLON 51 - Road Closure Display On, RCDISPON DRDCLOF 5I -. Road Closure Display Off, RCDISPOFF DRELOCU 50 - Display Relocated Units, DRU #### Duplicate and Cancel #### # required input: -E event to stay -X event to cancel DUPNCAN 50 +E+X-CDuplicate and Cancel, DUPCAN ECHO 51 - Echo ELAPSE 51 +E-A Elapsed Time Report EMACRO 51 -N Execute Macro #### Enroute Unit #### # Configurable Options: L - location, M - mileage, C - comment ENRTUNIT 50 -L-M-C Enroute Unit EQII\Q 51 - EQINQ, Equipment inquiry ERASEUN 50 +U Erase Unit ERASEV 51 +E Erase Event ERASYM 51 - Erase Symbol ETAOFF 50 - ETA OFF 61 • Item V - CAD Command Line Reference City of Aington Beach, CA ETAON 50 - ETA OIL ETRPUR 50 - Event Traffic Pursuit ETRSTOP 50 - Event Traffic Stop EVCHRON 51 - EVCHRON, Event Chronology EVSRCH 51 - Event Search EVSUM 51 - ESUM, Event Summary EXCHANGE 50 - Exchange Unit EXEC 51 - Xec EXEV 49 - Exempt Event EXIT 51 - Exit FINDCLS 49 -E-U-X-Y-F-N-D-M Find Closest, FINDCLS FINDOP 51 - Find Operator, FINDOP FIRECTR 50 - FCTR, Fire Under Contra) FIT 51 - FIT FLDEVT 50 - Field Event, FEV FLDEVT 50 -U-L-T A -U -L +T "ADMIN" FLDEVT 50 - 0 -U -L +TS FLDEVT 50 - E -U -L +TP FLDEVT 50 -SPERSO FEVP -U -L-SPERSO +TS FLDEVT 50 -$VEHIC FEW -U -L -$VEHIC +TS FLDEVT 50 -$PERSO-SVEHIC FEVB -U -L-SPERSO -SVEHIC +TS FLDEVT 50 -SPERSO-SVEHIC T -U -$VEHIC -L +TS $PERSO -P -PERSO -NME SVEHIC -V -VEHIC -LICENSE FNCCIR 51 - Place Fence Circle FNCREC 51 - Place Fence Rectangle FNCPOLY 51 - Place Fence Polygon FNCRPT 51 - Fence Report FOCUSDLG 51 - Set Dialog Focus -T FPFORM 51 - FPrint Form FRELN 50 - Free Unit, FRUN FREV 51 - Free Event, FREV GENROUTE 51 - GENRT, Generate Route GLOB 51 +T-C GLOB, Global Time GRAF 51 - GRAF, Graphic Location Entry GRACR 51 - Create Graphics GRAED 51 - Edit Graphics GRADL 51 - Delete Graphics GRADS 51 - Display Graphics GRAFR 51 - Free Graphics GRTALM 50 - Update Alarm Level, UPA HELP 51 - Help Default HLPCON 51 - Help Context HLPIDX 51 - Help Index HLPUSE 51 - Help Using HOLDEV 51 - HEV, Hold Event INCIDENTCMDS 50 -S-E Incident Command Tracking INITCB 50 - CBK, Initiate Callback INITRT 51 - Initiate Router #### Into Service #### # Configurable Options: L - location, M - mileage, C - continent ]NSERV 50 -L-M-C In Service IQAI 51 - 1QA Start IQA2 51 - IQA Resume KEYEN 51 - NE= KEYEN2 51 - SEN= 2 0 Item V -CAD Command Line Reference City of Ha}liington Beach, CA KEYLL 51 - LL= KEYLL2 51 - SLL= KEYXY 51 - YX= LATE 50 - LATE RUN, LATERUN LDVW 51 - Load View -N LINK 50 - LINK, Link Case Number LOCDOFF 51 - LOCDISOFF, Location Display Off LOCDON 51 - LOCDISON, Location Display On LOCWOFF 51 - Location Window Off, LOCWINOFF LOCWON 51 - Location Window On, LOCWINON #### Log Off Unit #### # Configurable Options: L - location, M - mileage, C - comment LOFUNIT 50 -L-M-C Logoff Unit LOGONGRP 50 - Logon Group #### Logon Unit #### # Configurable Options: U - Unit id, L - Lineup LOGONUNIT 51 -U-L Logon Unit, LOGU MANTIME 50 - Manual Times, TIMES MAPLEV 51 - Level MODLD 51 - Load Module -F -C -M -T -P MODUNLD 51 - Unload Module -F MONEV 51 - MEV, Monitor Event -E MOVEV 51 - Move Event, MVEV -E MOVUN 50 - Move Unit -E MSRD 51 - Measure Distance MVDN 51 - Move Down -E MVLEFT 51 - Move Left MVRT 51 - Move Right MVUP 51 - Move Up NEARBY 51 - Nearby Events, NEV NEWCMDW 51 - New Command Window, NEWCMDW NEWMAP 51 - New Map View ##0 Unit Out of Service #### # Configurable Options: L - location, M - mileage, C - comment OUTSERV 50 -L-M-C Out Of Service PAGE 51 - Page PDON 50 - Post Display On PDOFF 50 - Post Display Off PLACEUN 50 +U Place Unit, PLU PLACEV 51 +E Place Event, PLEV PLALLEV 51 - Place All Events, PLALLEV PLALLUN 50 - Place All Units, PLALLU PLASYM 51 - Place Symbol #### Preempt #### # Configurable Options: L - location, M - mileage, C - continent PREEMPT 50 -L-M-C PREEMPT, PR PREEMPTEV 51 - Preempt Event, PREV PRIMUNIT 50 -E Primary Unit PRTCFG 49 - Print Configuration PRTFORM 51 -T Print Form PRTMAP 51 - Print Map PRTPRV 51 - Print Preview PRTSU 51 - Print Setup PRTTXT 51 - Print Text File QRDCL 51 - QRC, Query Road Closure QRYPOST 50 - Query Post, QP 7 • Item V - CAD Command Lim Reference City of Angton Beach, CA QRYSTR 51 - QS, Query Street RASTATT 51 - Attach Raster File RASTDET 51 - Detach Raster File RCVMSG 51 - Receive Message, RECMSG RDCLS 51 +T-D-E-S-O-N-F-C Close Road, CLOSERD RDOPN 51 - Open Road RECANI 51 - Recall ANI, RECALLANI RECMSG 51 - Receive Message, RECMSG REFATT 51 - Attach Reference File REFAUTO 51 - Reference Autolevels REFBIP 51 - Refresh BIP REFCAD 51 - REFCAD, Refresh Cad REFDET 51 - Detach Reference File REFFIT 51 - Reference Fit REFLEV 51 - Reference Level REFONOFF 51 - Reference Display REFRTE 51 - Refresh Router, REFROT RELOC 50 - Relocate Unit, R RELOCBK 50 - Relocate Back Unit, RBU REOPNEV 51 +C REOEV, Reopen Event RETLOI 51 - RETLOI, Retrieve Location of Interest RETMSG 51 - RETMSG, Retrieve Message RETSCR 51 +C+T Retrieve Scratch, RETSCR REQMOVEUP 50 +G Request move up,REQMOVEUP REVATTR 49 - Review Attributes REVCAN 49 +C RCR, Revoke Cancel Request RGLOB 5I - Reset Global Time, RGLOB ROTHIS 51 - Rotational History, ROTHIS ROTREQ 51 - Rotational Service Request, ROTSERRQU ROTRR 51 - Retrieve Rotational Service Request, RETROTSERREQ RSCHEV 51 - Recurring Scheduled Events, RSE #### Toggle Response Time #### # Configurable Options: none RSPTIME 49 - Toggle Response Time, TRT #### Response Time On (AKA Clear) #### # Configurable Options: none RSPTMCL 49 - Response Time On, Response Time Clear, RTON #### Response Time Off (AKA Down) #### # Configurable Options: none RSPTMDN 49 - Response Time Off, Response Time Down, RTOFF RTCOPY 51 - Round Trip Copy, RTC RTEDIST 51 - Minimum Distance, MINDIST RTEINT 51 - Minimum Intersections, MININT RTERISK 51 - Minimum Risk, MINRiSK RTETIME 51 - Minimum Time, MINTIME RTETURN 51 - Minimum Turns, MINTURN SALERT 51 - SALERT, Station Alert SCANREQ 51 - SCANREQEV, Select Cancel Request SCHCMD 51 - SCHCMD, Schedule Command SCHSUM 51 - Scheduled Summary, SCHSUM SECACC 49 +E+F-U-G Event Security Access SELEV 51 - Select Event, SEV SELREC 50 - Select and Recommend Unit SELSCHEV 51 - Select Scheduled Event, SSE SELSTK 51 - Select Stacked Event, SSK SELTOP 51 - Select Top Event, STEV • Item V - CAD Command Line Reference City of Angton Beach, CA SELUPEV 51 - Select Updated Event, UUPEV SIGNOFF 51 - Sign Off, SIGNOFF SITFN`D 51 - Situation Found, SF SKILLINQ 51 - Skill Inquiry, SKILLINQ SNDMSG 51 - Send Message, SENDMSG SNEV 51 - Select New Event, SNEV SOVEV 51 - Select Overdue Event, SOEV SUPSRCH 51 - SIS, Supplemental Information Search SWNTFIL 51 - Switch Network File, SWNETFI SVVW 51 - Save View -N #### Transport Arrive #### # Configurable Options: L - location, M - mileage, C - comment TRANSARRIVE 50 -L-M-C Transport Arrive, TRNSARV ## Trauma Registry is not configured in the default delivery # TRAUMA 50 - Trauma Registry, TREG TRDEST 51 +E+L Transport Destination, TRDEST TREY 51 - Transfer Event, TREV #### Unit Clear #### # Configurable Options: M - mileage, C - comment D - disposition code UNCLR 50 -M-C-D Clear Unit, CLR -U -M -D -C UNCONTACT 50 +U-L-M-T-C CU, Unit Contact UNCOV 50 - Cover Unit, CVU UNEMG 51 - UE, Unit Emergency UNHIS 50 - UH, Unit History UNINFO 50 - Ul, Unit Information UNITAVAIL 50 - UNA, Unit Availability -U UNITCONT 50 - UNC UNITCOVER 50 - UNCU, Unit Cover Unit -U UNITDEPLOY 50 - UND, Unit Deployment -U UNITEVT 50 - UEN, Unit Event Route UNITGEN 50 - UNG, Unit General -U UNITGRP 50 -U-E-R-A UGR, Unit Group -U -R -A UNITPERSL 50 - UNP, Unit Personnel -U UNITPROP 50 - Unit Properties, UNPROP, UP, Update Unit UNITREC 50 -C-B-S Recommend Unit, RU UNITRESP 50 - UNR, Unit Response -U UNITSHFT 50 - UNS, Unit Shin -U -D -T -L UNITTHIRD 50 - UNTR, Unit Third Rider -U UNITTRANSF 50 +U+G-A-L-M-C Transfer Unit, TRU UNITVEHIC 50 - UV, Unit Vehicle -U #### Transport Unit #### # Configurable Options: U - unit, L - location, # C - comment, M - mileage, P - priority UNITTRANSP 50 +U+L-V-VD-NV-C-M-N-T-P TPU, Transport Unit #### Transport Update #### # Configurable Options: U - unit, L - location, P - priority, M - mileage UNITTRUPD 50 +UTL-V-VD-NV-M-N-T-P-PC-LCTPUD, Transport Update UNROST 51 - ROSTER, Unit Roster Display UNSUM 50 - Unit Summary, USU UPCA.NR 51 - UPCANRBQEV, Update Cancel Request UPDEV 51 - UEV, Update Event UPDSCRTBL 49 - Update Scratch Table Retention UPDSEV 51 - Update Scheduled Event, UPSE UPDTEV 51 - Update Top Event, UPTEV UPDVIEW 51 - Update All VERIFY 51 - V, Verify Location LS 0 Item V - CAD Command Line Reference City of *Ington Beach, CA VFTEXT 51 - View Full Text, VFTEXT VWATT 51 - View Attached File WHO 51 - Who WINADDR 51 - WINA, Window Address WIl`AREA 51 - Window Area WINCENT 51 - Window Center WfNEV 51 - Window Event, WINEV WINLOC 51 - Window Location, WINLOC WTNSTR 51 - Window Street, WINST WINLUN 50 - Window Unit, WINUN #### With Patient #### # Configurable Options: L - location, M - mileage, C - comment WITHPATiENT 50 -L-M-C With Patient, WP WKLOAD 50 - Unit Work Load, UWL XREF 50 - CR, Cross Reference XREFEVCAN 50 -E-U can cross ref, Cancel Cross Reference XXAVL 50 - Toggle AVL XXETA 50 - Toggle ETA XXGLOB 51 - Toggle Global Time XXLDIS 51 - Toggle Location Display XXLEV 51 - Toggle Autolevels XXLWIN 51 - Toggle Location Window XYLOC 51 - XY Location ENTRY, XYLOC ZOOMIN 51 - ZOOM IN ZOOMOUT 51 - ZOOM OUT 1Q • • ITEM VI Phase I Question and Answers For City of Huntington Beach, CA Prepared by Intergraph Public Safety February 12th, 2002 0 Item VI — Phase I Question d Answer Ontington Beach, CA Number Module Issue Resolution Property Convert most recent Property data IPS will convert Property data in accordance with entered since rehosting beginning Item I section 10 Data Conversion. 111100. Alarm Provide an Alarm module that will meet IPS will modify the Alarm Permit Module to meet our needs. the requirements outlined by the City as documented in the Change List.. Alarm Convert Alarm data. IPS will convert Alarm data in accordance with Item I section 10 Data Conversion. 4 RMS Issue not Can an officer in the field receive an IN IILEADS field reporting, an officer would get a CAD Alert if a detective initiates Tracking? notification that the detective had issued a tracking on a particular alert. This notification would be sent to the officers organizer as well as the detective would get the notification that the officer had "touched" the alert on the person, vehicle, etc. 5 NetViewer Can the screen automatically refresh? This will be done during implementation on a limited number of workstations. IPS will configure all IINetViewer users to point against a separate database that will be periodically updated with data from the live database. In this configuration, IPS will configure IINetViewer clients to automatically refresh every x (this time frame will be mutually agreed upon between IPS and the City during project implementation) minutes. Each clients refresh timer is started when the client logs onto NetViewer. This will not have a performance impact on the live CAD database but may have an impact on the local area network based on the number of IINetViewer clients that are logged on at any one time. IPS is not responsible for performance impacts related to the large amount of network traffic generated by the IINetViewer automatic refresh. RMS Can NCIC inquiries be done from Yes, with the Informer client loaded on the individual stations in Records? workstation. Jail Jail Interface Jail will use IMAGIS for Booking. Records will use Intergraph's arrest module. A separate Jail Interface is currently being investigated that will allow skeletal booking data to be transferred from the booking system to the IILEADS arrest module. IPS has requested interface information from Imagis. As of 6/27102, no technical specifications ItemVI-phaseIQAv9.docRemV1 .,h sore.+,.n I Page 2 40 Item VI — Phase I Question d Answer Ontington Beach, CA 8 Report Writing UCS interface 9 RMS Preservation of RMS data in skeletal files in event of system crash. 10 Maintenance Who is responsible when a failure occurs? 11 Property Entering property and maintaining data integrity 12 13 18 19 23 have been received. IPS has proposed the City use the integrated IILEADS Field Reporting. System Data and Database files are backed up on a daily basis. Specific procedures supplied by IPS, however HB personnel are responsible for all backup tasks. If RMS is down before data is transferred from CAD, the flag in CAD is not reset. When RMS is brought back up, the data will be transferred to RMS via the link. IPS is also proposing a clustered server environment which will minimize the possibility of a total system crash. Intergraph will cover all maintenance for hardware and software purchased through IRS according to a separate Contract Maintenance agreement IILEADS maintains master indexes that data is validated against. Some care must be taken when entering data so these indexes do not get cluttered with duplicate data. A process will need to be instituted by the City to ensure minimal duplication is performed. Traffic Does Intergraph have a CHP 555 IPS is proposing a Custom Accident Report that Accident Report? will conform to the CHP 555 Report RMS Modify LOC search to auto return Yes, This can be configured. involvements, not just addresses req. opening each RMS Can partial phone numbers be Yes, This can be configured. searched? RMS Can alerts for gang or vehicles be set to No, expiring these alerts is a manual process. expire by a certain date? Mapping Addressing must be provided for mapping feature. IPS will build the CAD system based upon address verification supplied by a GIS department. This address verification will be based on one or both of two methods: street segment data and/or parcel point-inpolygon address data. IPS will configure, at implementation, a hybrid of the two methods, if requested by the City of Huntington Beach PD. The mapping solution will display center lines and meet FCC Docket No. 94-102 and 99-245 Phase I and Phase li wireless requirements, The IPS mapping system will have the ability to define a street in multiple reporting districts and multiple jurisdictions (see attached diagrams). The reporting district and beat will be determined by either 1) the polygon ItcmVl-phaseIQAv9.docTtemV1 .,1,aselQ Ay9 Page 3 0 Item VI — Phase I Question d Answer Ontington Beach, CA 24 25 that the intersection falls or 2) the City can specify a specific reporting district for the intersection to fall in. If the dispatcher wishes, the dispatcher can manually update the address point of the call to whatever corner of the intersection they would like and whichever reporting district polygon that point falls within will be the reporting district for response. A description of the map conversion process is provided in the CAD DSD. (see IPS project modification request form, contract attachment #23 for additional information). Illnformer Can Informer run both name and DL# on 2 of the 10 informer transaction types can be a traffic stop? configured to perform this action. CAD Can we code locations with a hostile Yes, text files can be attached to location to symbol? indicate this information. 29 CAD Query other officer's calls in Imobile. 30 CAD Can Imobile interact with RMS? 33 CAD Can a unit generate a signal indicating pursuit? The Unit Summary command in IlMobile will allow officers to query the current status of all officers in their dispatch group. If an officer is on a call, this will be noted. Yes, utilizing the Illnformer interface to I/LEADS via IlMobile. The officer can generate a field event indicating Traffic Pursuit. This will then be indicated to the dispatcher by the fact the officer is on a call with a type of TP or whatever incident code the City would like to use. 37 Informer Further clarification on limitations of Please refer to the CAD DSD for this information. Informer. 38 CAD/RMS Need quote for converting locations, IPS will convert Property data in accordance with recent property and master names files. Item I section 10 Data Conversion. Locations and Master Name Files are not part of this conversion. 39 40 IlMobile Further clarification of these two Illnformer modules and their functionality. RMS Link locations with involvements Please refer to the CAD DSD for this information. All locations that are associated with incidents, names, vehicles, arrest, citations, accidents, and property are automatically created as an involvement. A user can manually associate a location as an involvement also. 41 Add PC 293 (a) Advisement on Incident This field can be added to the incident report via report the SysGui utility. Item V I-phaseIQAv9.doc1temV1 phase3QAv9 Page 4 9 Item VI — Phase I Question d Answer Ontington Beach, CA 42 Confirm Intergraph has fields for assault, Some of these fields are captured in other weapons, hate crimes and gang on Inc. modules. IPS will configure these additional fields rep. on the incident report. 43 Does "last known secure" mean Yes "Occurred" and can it be changed on Incident report 44 Change "at found" to "discovered" on Yes incident report 45 Include occupation and employer name IPS will configure these additional fields on the and address for victim on Incident report incident report. 46 Include employer/business name for IPS will configure these additional fields on the suspect on Incident report incident report. 47 Recommend inv. Involvement on IPS will duplicate the City's Missing Person Report. missing persons report 48 RMS Unable to enter into Known Offenders This module is part of the IILE=ADS base system. module to test sex reg. data 49 Next of kin and prev. convictions on Yes Registrant form 50 Where is Investigative Analysis captured This information is contained on the Incident form on Incident report itself. 51 Is it possible to include a field for type of Yes, Data is contained on the standard Incident Incident report report. 52 RMS Does Incident report include restricted Yes, This is a part of the normal workflow of the info for flagging juv. Involvement incident Module. 53 RMS Does location include cross Yes this is currently supported in the Incident streets/intersections on Incident report Module 54 RMS Would CSI info be captured in a This could be accomplished via the use of the supplemental report Narrative Templates feature or using Microsoft Word templates attached to an incident. 55 Should victim or suspect vehicle info be Yes included on Incident report 56 RMS Does veh. module capture RO name Yes, this is a part of the normal workflow of the and what if unknown Vehicle Module. 57 RMS Is "traveled by" for suspect captured Yes, This can be added via SysGUI. somewhere in Incident report 58 RMS Does Arrest module capture Yes, This can be added via SysGUI. "cite/release" info 59 RMS is "relations to victim" captured in Yes, this is a normal function in Names module. Incident or Names module 60 RMS is ganginame and city captured in gangs Yes mod 61 RMS Is adult, juv, male, female, bin#, off log It was determined these fields may not be and rd necessary in Arrest mod necessary on the arrest report. The City will analyze what data is necessary. Once this analysis is done, the City and IPS will work out a mutually agreeable resolution. ItemVI-DhaseI0Av9.doc e I Page 5 Item VI — Phase I Question d Answer Ontington Beach, CA 62 Clothing and right or left hand info in This data can be viewed through a link to Names Arrest mod 63 Emergency notification in Arrest mod This information is contained in master name record 64 Medically cleared, search by, date & This data is collected in the IFS JMS application time booked in Arrest mod not Arrest the arrest module. The City is analyzing whether this data is really needed in the arrest report. 65 Juv. school, par. notif., whom, by, date & This data is collected in the IFS JMS application time, school status, grade, prob. ofc. in not Arrest the arrest module. The City is analyzing Arr whether this data is really needed in the arrest report. 66 Bonding company info in arrest mod This data is collected in the IPS JMS application not Arrest the arrest module. The City is analyzing whether this data is really needed in the arrest report. 67 Add additional arrest dispositions in This data is collected in the IPS JMS application Arrest mod not Arrest the arrest module. The City is analyzing whether this data is really needed in the arrest report. 68 Are photo by and prints by necessary in This data is collected in the IPS JMS application Arrest mod not Arrest the arrest module. The City is analyzing whether this data is really needed in the arrest report. 69 Transporting officer and juvenile This data is collected in the IPS JMS application released to in Arrest mod not Arrest the arrest module. The City is analyzing whether this data is really needed in the arrest report. 70 Sr. pet. Ofc. review field This data is collected in the IPS JMS application not Arrest the arrest module. The City is analyzing whether this data is really needed in the arrest report. 71 CAD Accept event using enter key and field This will be configured by the IPS Implementation data using enter key rather than tab key specialist. IPS will configure the tab flow to go to the "accept event" button once the location field and event type fields are entered. The "accept event" button can also be programmed on a function key. The "accept button" would be highlighted so the dispatcher would only have to hit the enter key and the call would display in pending events. Once the "accept event" button is entered, the event will remain on the dispatcher's screen, and the cursor will move to the remarks field so the dispatcher can add comments to the event. (see IPS project modification request form, contract attachment #71 for additional information). 72 CAD Need phone number field for location 9/19/02 — The final resolution on this issue is that telephone number that transfers to the IPS CAD implementation lead will add another ILeads phone number field to the main dispatch form. It will be called "Location phone number". It will correspond to the clrnum column in the database to ensure it is transferred to IILEADS to enable proper false alarm processing. The old reporting party (RP) "Callers Phone number" field will then ItemVl-phaseIQAv9.doc I Page 6 0 Item VI — Phase I Question and Answer Ontington BeachQ, CA 73 74 75 76 be mapped to a new field in the database. It will not be transferred to I/LEADS. The configuration of AniAli will be determined during implementation as to which field gets populated with the phone number from the calling party. (see IPS project modification request form, contract attachment #72 for additional information). CAD Create separate field for RD and a This can be configured for display, but the City will separate field for Beat in the call/event have to display the information in separate fields. I/Dispatch entry mask. The Verify For clarification purposes, -Taylor Edge determined Location function will execute to find the that the HBPD term "RD" is the same as the ESZ RD, Beat/Response Area, Dispatch field in CAD and HBPD term Beat is the "Area" field Group, X/Y coordinates of the location, in the agency control box in CAD. Additional etc. This information will transfer to information was received by HBPD from Chris Firth {LEADS and can be searched and and Jim Savage that would provide a means to retrieved in CAD and Ileads display the RD in the display box that holds location information. The city would like to receive additional information and examine this option outlined in IPS project modification request form, contract attachment #73 for additional information). The ESZ field in CAD can be configured to display on the dispatch form (I/Dispatch entry mask), but not in the agency control box. According to Taylor Edge, It will be a separate field. Both "RD" and "Beat" are transferred to IILEADS and can be searched and retrieved in both CADS and ILEADS. Command line driven field events once created will be displayed in the I/Dispatcher entry/review mask. CAD Add field in Agency Control Box for This will be done during implementation. IPS will primary unit assigned configure the City of Huntington Beach CADS to assign the primary unit a 741 designator through unit property so that the primary unit displays in a separate column in the agency control box (see IPS project modification request form, contract attachment #74 for additional information). CAD Dispatcher can enter a Mutual Aid unit IPS CAD will allow a unit to be logged on without call sign and/or HBPD unit call sign in an employee ID, provided the unit call sign has IPS I -CAD w/o employee ID been entered into the database. When the emergency is over then via Unit Properties the operator can enter the Employee ID. The operator can log on Mutual Aid units that are not in the database in I -CAD. The I -Net dispatch software does not support this function. (see IPS project modification request form, contract attachment #75 for additional information). CAD Ability to display canned messages on a This can be done via the Schedule Message scheduled basis. Request that the IPS I- Command in CAD. IPS I -CADS will have the ability CADS have the ability to program to program canned messages that appear on canned messages that appear on CADS CADS screens (as a message) as a reminder to all screens as a reminder to all users users currently logged on. These messages will be currently logged on. These messages programmed to appear on a daily, weekly or can be programmed to appear on a monthly basis at a specific hour. (See IPS project daily, weekly or monthly basis at a modification request form, contract attachment #76 3temVI- hasel Av9.doc Page 7 0 Item VI — Phase I Question and Answer lontington Beach, CA specific hour. 77 CAD Can I -CCTV run as a client on WC and Comm Ctr workstations 78 CAD Do fields in Sup. Info. interface with Informer & clarif. of queries & CAD interface 79 CAD CLETS queries thru CAD are documented auto. In remarks of event 80 RMS Can detectives query CLETS thru RIMS 81 CAD Person queries hits 6 systems to OC switch. Is that one tab in Informer 82 CAD CLETS returns and MDC messages show associated unit 83 CAD Can CAD send queried CLETS returns automatically to associated unit, as well as append to an event. for additional information). This was determined to be out of the scope of the project. The existing controls and monitors for cameras will persist. (See IPS project modification request form, contract attachment #77 for additional information). Yes, person, vehicle, or property data entered into supplemental information in CAD is interfaced to I/Informer. Once data is entered into supplemental information, automatic queries can be generated to query the databases connected via Illnformer. (See IPS project modification request form, contract attachment #78 for additional information). IF data is entered into supplemental information and an automatic Informer CLETS query is run. The Informer CLETS replies are automatically attached to an event, but are stored in a separate location rather than in events comments. CLETS queries thru CAD are NOT automatically documented in the remarks of an event. (See IPS project modification request form, contract attachment #79 for additional information). Yes,Via the Illnformer client on the records workstation. It was noted in the comments on the initial draft of the DSD by the City that direct access to CLETS from IILEADS was not needed. (See IPS project modification request form, contract attachment #80 for additional information). There are no cost savings to be realized by the City by Irvine PD having this functionality also. Yes, Illnformer will submit one query to the OC message switch and the OC message switch will query the 6 different systems. (See IPS project modification request form, contract attachment #81 for additional information). MDC messages do show the associated unit (the unit from which the message was sent). CLETS returns will show the associated unit as long as it is entered at the time the query was performed. IPS will configure any additional fields necessary in I - Informer that will allow the dispatcher to enter the associated unit at the time the query is performed, if necessary. CLETS returns initiated with Illnformer can be attached to the incident. (See IPS project modification request form, contract attachment #82 for additional information). No. CLETS returns would not be automatically sent to the associated unit if the query was done ad hoc, if the unit was assigned to an incident, the query was performed from adding the data to supplemental information and the officer performed a "recalled dispatch" on the incident from the ltetnVI-Phase10Av9.doc1teii V1 „i.,,se!Q 9 I Page 8 s Item VI — Phase I Question and Answer Intington Beach ,A C 84 CAD How do CLETS queries display in CAD and Informer MDC., the officer could manually call up the CLETS return. The CLETS return will automatically append to an event as part of Location of Interest data that is associated to the event. (See IPS project modification request form, contract attachment #83 for additional information). If CLETS queries are initiated by entering supplemental information, the responses are display in Location of Interest. IF ad hoc queries are performed, those responses are returned to the I/Informer client application. If the operator then attaches the return to an event, the information will then be displayed in Location of Interest. IPS will work with HBPD to display CLETS queries in an agreeable format; similar to current CLETS return formats. (See IPS project modification request form, contract attachment #84 for additional information). 85 CAD Allow CAD to update Ileads but still keep The CFS upload to I/LEADS can be configured to CAD event open happen either after the incident is closed or after a specific amount of time. (See IPS project modification request form, contract attachment #85 for additional information). 86 CAD Dispatch and Change unit status for Yes, this can be configured. IPS will configure this multiple units from command line at implementation for the City of Huntington Beach Police Department. (See IPS project modification request form, contract attachment #86 for additional information). 87 CAD For traffic pursuits format via command Yes, this can be configured via a macro. IPS will line entry, can event format display once configure this at implementation for the City of entered & cursur go to remarks field Huntington Beach Police Department. (See IPS project modification request form, contract attachment #87 for additional information). 88 CAD All mouse -driven commands can be duplicated on command line IPS will create command line entry for all mutually agreeable commands. Such commands that utilize the map cannot be done purely from the command line. Some interaction with the CAD user interface is required. IPS cannot duplicate every mouse -driven command through the use of command line. Command line cannot be used within the I -Informer module and command line cannot be used for data entry in most person, vehicle, and/or property data fields entered into supplemental information fields in I -CAD call/event I/Dispatch entry mask and in most I/Dispatch event formats (I/Dispatch incident entry mask, traffic stop, traffic pursuit, etc.). Manual data entry into these fields is required. See IPS project modification request form, contract attachment #88 for additional information). ItemVl- hasel Av9.doc1tem ,1 rhase!QAY9 I Page 9 • Item VI — Phase I Question and Answer Otington Beach, CA 89 CAD Command line entry can use unit call Events can be selected from the command line by sign rather than event for retrieval and specifying the unit id. For example, Select Event -u display 2C. This would select the event that unit 2C is currently on. IPS will configure this at implementation for the City of Huntington Beach Police Department. See IPS project modification request form, contract attachment #89 for additional information). 90 CAD Modify command line entry and design To associate a CLETS query to a unit when unit is macros that work in CAD and I -Informer on a call, the add supplemental information mods. command line should be used. When a unit is not on a call, a command line entry will be used to bring up Informer form and then the dispatcher will then fill in the fields in the form. Minimum keystrokes are the goal. Command line cannot be - used within the I -Informer module and command line cannot be used for data entry in most person, vehicle, and/or property data fields entered into supplemental information fields in I -CAD call/event IlDispatch entry mask and in most IlDispatch event formats (IlDispatch incident entry mask, traffic stop, traffic pursuit, etc.). Manual data entry into these fields is required. See IPS project modification request form, contract attachment #90 for additional information). 91 CAD Modify command line entry & design IPS will configure the City of Huntington Beach macros in I -CAD & 1-Informer withiout Police Department I -CAD system for heavy the need of using delimiters, wild card command line and macro usage. The use of search characters, etc. quotation marks is will not be required. The use of a wildcard characters in a location is will only be required if an operator wants to search for an exact string match. See IPS project modification request form, contract attachment #91 for additional Information). 92 CAD System auto returns cursor to command Yes, This can be configured. IPS will configure this line for next command line request at implementation for the City of Huntington Beach Police Department. See IPS project modification request form, contract attachment #92 for additional information). 93 CAD Multiple case numbers will transfer to Yes. This can be configured. IPS will configure this CSF and skeletal for a single CAD event at implementation for the City of Huntington Beach Police Department. See IPS project modification request form, contract attachment #93 for additional information). 94 CAD Emerg call displays on secondary Yes, This can be configured. IPS will configure this screen and not main dispatch screen at implementation for the City of Huntington Beach Police Department. See IPS project modification request form, contract attachment #94 for additional information). 1temVI-phase1QAv9.doc I Page I C 0 Item VI — Phase I Question and Answer Ontington Beach, CA 95 CAD Event search recognizes month so end Yes, This can be configured. IPS will configure this user only has to enter day at implementation for the City of Huntington Beach Police Department. See IPS project modification request form, contract attachment #95 for additional information). 96 CAD Can IPS I -CAD populate location field on Yes, This can be configured. IPS will configure this status w/prior officer location in a "failure at implementation for the City of Huntington Beach to respond" situation Police Department. See IPS project modification request form, contract attachment #96 for additional information). 4A N ., CAD Can "felony car stop" + oth mods and Warr queries be added to field event format This functionality can be configured using the existing options on the field event dialog. If subject stop is not used by the City, that option can be configured a Felony car stop with a different event type code. The querying of persons would have to be executed as a separate command but could be associated to that car stop. See IPS project modification request form, contract attachment #97 for additional information). CAD Will held calls skew call receiptldisp and Yes. Held calls time will skew the statistical reports unit disp/arrive stat reports for call receipt to call dispatched time and unit 99 CAD CAD to display calltaker/dispatcher initials and time stamp of remarks in event entry 100 CAD Can LOI screen be configured to allow previous and next button as in display event 101 CAD All mouse -driven commands can be dispatch time to unit on scene times. During implementation, IPS will remove the held calls tab and option on pull down menus in I -CAD, and the City should experiment with different commands to achieve the proper results. IPS will ensure that changing of type codes, situation found codes and disposition codes will not improperly reflect the call receipt to call dispatched time and unit dispatch time to unit on scene times. IPS will ensure that the XNTP software that provides the interface to an external clock device (HBPD Spectracom Netclock), plus an executable provided by IPS that allows other CAD workstations to be synchronized from the timeserver via XNTP, will reliably synchronize the CAD workstations; avoiding skewed computations for tracked Call Time Received, Time Dispatched, Enroute time, Arrive on scene time, and response times. See IPS project modification request form, contract attachment #98 for additional information). Yes, This can be configured. IPS will configure this at implementation for the City of Huntington Beach Police Department. See IPS project modification request form, contract attachment #99 for additional information). No, this is not currently available. See IPS project modification request form, contract attachment #100 for additional information). IPS will create macros for all mutually agreeable Item VI- haseI Av9.docItemV 1 phase!QAy9 I Page 11 0 Item VI — Phase I Question and Answer Intington Beach, CA duplicated through the use of a macro commands. Such commands that utilize the map cannot be done purely through building macros. Some interaction with the CAD user interface is required. IPS cannot duplicate every mouse -driven command through the use of macros. Macros cannot be used within the I -Informer module and macros cannot be used for data entry in most person, vehicle, and/or property data fields entered into supplemental information fields in I -CAD call/event I/Dispatch entry mask and in most IlDispatch event formats (I/Dispatch incident entry mask, traffic stop, traffic pursuit, etc.). Manual data entry into these fields is required. See IPS project modification request form, contract attachment #101 for additional information). 102 CAD Does CAD have ability to recog direction Huntington Beach to check with Mesa to see how abbrev for RD & beat such as SE they did this. The COTS IPS software does not Bea/Ada provide this capability. The default location for an event created at an intersection is the NW corner of the intersection. See IPS project modification request form, contract attachment #102 for additional information). 103 CAD Can CAD provide addl info for cross Huntington Beach to check with Mesa to see how streets ie bch/taylor shows taylor 2 blks they did this. The COTS IPS software does not n of ... provide this capability. See IPS project modification request form, contract attachment #103 for additional information). 104 CAD Send event to all units that may not be This can be done via the Send Message assigned to call command. IPS will configure this at implementation for the City of Huntington Beach Police Department. See IPS project modification request form, contract attachment #104 for additional information). 105 CAD Are there other background color options Not interactively via I/Mobile, but Windows settings for MDC other than day or night settings can override the colors scheme. See IPS project modification request form, contract attachment #105 for additional information). 106 CAD Officer can send dispo from MDC to dispatch and it appends into the call automatic Yes. When an officer clears a call with the Clear Unit command from the MDC, the officer has the ability to assign a disposition code to the call. This disposition code is then automatically associated to the call. IlMobile can be configured to disallow the Clear Unit command if HBPD does not want officers clearing themselves from the scene of a call. IlMobile does not offer the ability for the officer to assign a disposition code without clearing themselves from a call. Any unit on a call can append notes to the call. The dispatcher can remove the primary unit from the call without clearing or disposing the call given that another unit is assigned to the call. IPS will configure this at 1temV1-phaseI0Av9.doc1temV1 .,hase!QAO I Page 12 0 Item VI — Phase I Question and Answer Ontington Beach, CA 107 CAD Emerg activation button from MDC to CAD automatically sends message to all MDCs and dispatch 108 109 110 implementation for the City of Huntington Beach Police Department. See IPS project modification request form, contract attachment #106 for additional information). Yes, This can be configured to send to all of the dispatch positions, all units in the emergency unit's Dispatch group and/or to all MDCs. IPS will configure this at implementation for the City of Huntington Beach Police Department. See IPS project modification request form, contract attachment #107 for additional information). CAD When failure to respond is used & event This would be done via the Send Message created, can call be sent to all MDCs command with attached event details similar to the logged process described in item 111 below utilizing macros. IPS will configure this at implementation for the City of Huntington Beach Police Department. See IPS project modification request form, contract attachment #108 for additional information). CAD Unit call sign shows on CAD or radio This is a function of the IIPTT interface. I/PTT has monitor when ofcr keys mobile or been removed from the scope of the project. See handheld rad IPS project modification request form, contract attachment #109 for additional information). CAD Req MDC login have ID#, unit call sign, password etc & capture info in CAD/RMS 111 CAD Current CADS When event assigned to ofcr, squad sgt is sent call automatically wlout being assigned to the call. This is because the system has the ability to recognize squads and sergeants assigned to the squad. Yes, This can MDC log -on can be configured. At implementation, IPS will configure MDC log -on with mandatory fields. However, the base I -CAD product only transfers skills from the personnel ID table in CADDBM. I/Mobile does have fields to capture handheld radio id's. The existing vehicle definition tables and update lineup records screen in CADDBM do not have fields for mobile radio serial numbers and do not transfer this data to the I -Mobile product. See IPS project modification request form, contract attachment #110 for additional information). No. The IPS I -CAD software does not provide this capability. The dispatcher could use the Send Message command to do this. A macro could be configured that would in essence execute the dispatch unit command and then a command line send message to a squad sgt. The macro command line would be something like this: D <unit id to be dispatched> <unit id of squad supervisor>. IPS will configure this at implementation for the City of Huntington Beach Police Department. See IPS project modification request form, contract attachment #111 for additional information). ItemVl-phase1OAv9.dochefn 1 phase!QAY9 ! Page 12 0 Item VI - Phase I Question and Answer Ontington Beach, CA 112 113 CAD Unit alarm sent thru MDC to field sgt No. This functionality is not available in the system. when timer runs out and flashes or lights Another option would be for a dispatcher to in dispatch manually send a message via command line to the field sgt when an alarm is activated. This command line would not be a macro but a pure CAD Send Message command line. IPS will configure this at implementation for the City of Huntington Beach Police Department. See IPS project modification request form, contract attachment #112 for additional information). CAD Can MDC be programmed to display or turn off "system" updates like in CAD This is a systemwide MDC configuration parameter that is either turned on or off. This cannot be done interactively. If is possible to configure the system for the dispatcher top see system notes but not the mobile user. See IPS project modification request form, contract attachment #113 for additional information). 114 CAD Need equivalency in IPS I -CADS Yes, Send Message functionality can send memos product that captures current capabilities in I -CADS but does not provide all the features in the I -CADS memo system. Does IPS requested. Send message does not have the ability I -CADS offer any type of memo system to monitor the status of the e-mail that was sent, in I -CADS similar to an e-mail that the number of queues sent, date and time sent, enables lengthy narrative to be sent to date and time read, date and time deleted and an individual or a defined group and other drilldown capabilities. See IPS project allows sender to monitor the status of modification request form, contract attachment the e-mail that was sent, the number of #114 for additional information). queues sent, date and time sent, date and time read, date and time deleted? (see attached copies of current CADS screens, drilldown capabilities and information available through the existing CADS memo system. 115 CAD Manually send CAD call for service This is accomplished through normal printing (event) to a fire station printer thru CAD function provided by Windows. The caveat is the fire stations must be accessible via the network. The dispatcher would do a standard print command from CAD but specify the appropriate fire station printer one the print dialog appears. IPS will configure this at implementation for the City of Huntington Beach Police Department within the bounds of the City's existing network. See IPS project modification request form, contract attachment #115 for additional information). 116 CAD Need info on paging system interfaced Manual pages can be sent via the Send Message to CAD and list of agencies using command. I/Page has been removed from the product scope of the project thus paging from CAD is not supported. See IPS project modification request form, contract attachment #116 for additional information). Item VI-phaseIOAv9.docRemVV-I-phaselQAv9 I Page 14 .• Item VI — Phase I Question and Answer Ittington Beach, CA 117 CAD Ability to page forward or backward in a Yes. See IPS project modification request form, call contract attachment #117 for additional information). 118 CAD Can cancellation request appear in The cancel request is recorded in the remarks area remarks field of call as well as the only. In addition, the unit status monitor and "system" side pending events monitor will display a "C" in the update column indicating to the dispatcher that a cancel request has been made. See IPS project modification request form, contract attachment #118 for additional information). 119 CAD Add situation found to the event entry Yes, This can be configured. IPS will configure this form at implementation for the City of Huntington Beach Police Department. See IPS project modification request form, contract attachment #119 for additional information). 120 CAD IPS I -CAD should capture dialer, personnel information, info & SOP files wlout going into RMS. (see attached copies of current CADS screens, drilidown capabilities and information available through dialer files, SOP files, information files and personnel information files. The IPS I -CAD software does not provide this capability. This type of information can be captured and retrieved from the Scratch Pad in CAD in a limited capacity for SOP and information files. IPS I -CADS does not have a product that mirrors the capabilities of a dialer file, and information files. Another alternative that IPS customers have used for dialer file needs is called AZZ card file. AZZ card file offers a rolodex type of software for telephone queries. This AZZ card file product is outside of the CAD product but is compatible with the application. If requested at implementation, IPS will configure a button on the CAD dispatch screen to start this application. AZZ card file is a third party product not sold by IPS. The City would need to purchase this product if the standard scratch pad functionality is not feasible. See IPS project modification request form, contract attachment #120 for additional information). 121 CAD Display unit call signs on unit status Creating major and minor groups and subgroups monitor w/field sgts stacked above will meet this request. IPS will configure this at squad assignments & south implementation for the City of Huntington Beach squads/sergeants stacked above north Police Department. See IPS project modification squadslsergeants request form, contract attachment #121 for additional information). 122 CAD Can fields be prog for warrant quer from Person fields cannot be configured in the traffic traf stop event similar to veh lie and state stop command. A separate command would be run fids to associate a person to the traffic stop. Another alternative is to develop a macro that combines the traffic stop command and add supplemental person command into one to enable this behavior_ IPS will configure this at implementation for the City of Huntington Beach Police Department. See IPS project modification request form, contract attachment #122 for additional information). ItemVl- haseI Av9.doc I Page If 0 Item VI — Phase 1 Question and Answer Intington Beach, CA 123 CAD Can a help function or wild card search This help function is not supported when a call is be used in the type code field as a call is being entered. (See IPS project modification being entered request form, contract attachment #123 for additional information). 124 CAD Need addl info how CAD tracks shift Lineups are maintained via CADDBM and/or roster, call signs & assoc names radio I/NetViewer. IPS will work with the City to Ids, etc. and does it interface to determine the best use of the system to personnel roster in I -LEADS? accomplish your goals. There is no interface to I/LEADS. (See IPS project modification request form, contract attachment #124 for additional information). 125 CAD Request CAD system provide the Ability Yes, The event register report which is part of to provide Watch Commanders/Patrol IICAD Repots, can produce the needed data fields sergeants with daily briefing logs, with for the Briefing Log with the exception of reporting narratives on certain types of calls based party name, reporting party address, and reporting on type codes, dispositions, situation, party phone #, DR#, and disposition code. City found, etc system administrator will add the additional fields if still required (See IPS project modification request form, contract attachment #125 for additional information). 126 CAD The Watch Commanders/Patrol IPS will create fields in the vehicle definitic n tables, Sergeants need to Query the system to will track the status of fleet vehicles (such as obtain printout for status on all fleet available, out of service mechanical, out o service vehicles and find out what patrol radio). IPS will configure a column in the i init vehicles are currently in use during a status monitor to display the car id of the L nit. The shift Garage will be able to update the Vehicle ecord to indicate its status. The City will write a report to compare which vehicles are in use and which vehicles are available. This was decided in the conference call of 1/22/03. (See IPS project modification request form, contract attachment #126 for additional information). 127 CAD Remarks field will be configured to IPS will configure at implementation a larger display a larger remarks field in the remarks display area in the event form to meet event form. HBPD's needs. See IPS project modification request form, contract attachment #127 for additional information). 128 CAD E9-1-1 ANI/ALI Information will transfer E9-1-1 ANIIALI Information will transfer into the into the City of Huntington Beach IPS I- City of Huntington Beach IPS [-CAD from the CAD from the Verizon system via the Verizon 9-1-1 system via the ANIIALI interface. ANIIALI interface. The IPS I -CAD will The IPS I -CAD will meet FCC Docket No. 94- meet FCC Docket No. 94-102 and 99- 102 and 99-245 Phase I and Phase II wireless 245 Phase I and Phase II wireless requirements, properly populating IPS I -CAD requirements, properly populating IPS I- fields and displaying the wireless ALI/ANI CAD fields and displaying the wireless information for FCC Phase I and Phase II ALIIANI information for FCC Phase I and standards. There will be no additional charge to Phase II standards. the City of Huntington Beach to have IPS configure the interface that properly transfers all FCC Phase I and Phase II wireless information fields to the IPS CADS. This cost will be covered under initial implementation and/or yearly maintenance agreement. At implementation, IPS will configure a function ItemVI-phaselOAv9.docI etHV1 phase!QAYa I Page 1( 0 Item VI — Phase I Question and Answer Ontington Beach, CA key that transfers (dumps) the E9-1-1 information into the I -CADS. See IPS project modification request form, contract attachment #128 for additional information). 129 CAD Configure 1-CAD to receive duplicate E9-1-1 ANIIALI Information from the Verizon 9-1-1 data sets of Verizon E9-1-1 ANIIALI system via the ANIIALI interface sends two sets of information that will populate both duplicate data. IPS will configure the City of location, location telephone number Huntington Beach IPS I -CAD to transfer these two fields and reporting party, reporting party sets of duplicate data into the location/location telephone number fields. phone number fields and the reporting party/reporting party phone number fields. These fields will automatically populate with the E9-1-1 ANIIALI information when a preprogrammed function key is depressed. This will be configured by IPS at implementation. IPS does not need nor want duplicate data sets. One data stream can be processed and multiple fields populated from a single piece of data. See IPS project modification request form, contract attachment #129 for additional information). 130 CAD Confirm that the IPS I -CADS can be IPS will configure the City of Huntington Beach IPS configured to receive solicited and I -CADS to receive all solicited and unsolicited unsolicited messages from the Orange messages routed through the Orange County County ELETE terminal in the HBPD Message Switch. (See IPS project modification Records Unit and all messages routed request form, contract attachment #130 for through the Orange County Message additional information). Switch (OCMS), such as CLETS, NLETS, etc. 131 CAD Confirm lPS I -CADS and I -Mobile can be Yes. IPS will configure the I -CADS to automatically configured to automatically send a send to all MDCs and all dispatch positions a CLETS return to all MDCs and all CLETS return based on hit detection words defined dispatch positions when stolen vehicles, by the City of Huntington Beach Police felony vehicles, etc. are ran through Department. The CLETS return will indicate the CLETS. associated unit that ran the query. (See IPS project modification request form, contract attachment #131 for additional information). 132 CAD Confirm IPS I -CAD has the ability to yes, this is supported. See IPS project define case numbers and event modification request form, contract attachment numbers with a numbering system that #132 for additional information). defines the year and confirm the IPS I - CAD software can reset the case numbers and event numbers for each year. 133 CAD Confirm installation and configuration of IPS will perform this task. archival software and hardware and automatic archival setup will be done at implementation. ItemVl-phaseIQAv9.doc teFnV, .,hase!QAY9 I Page 1, Sp�traconx NetCtork$2 Rrceiyqr Server Rack and Components CAD Server Specifications Dell 66CX) RnwprEdge Rackmount Servers each with: Qucid 1,5GHz Pentium Xe0r, Froceslors lG8 of RAM 4 - 36C8 Hard ;risks '01100 me Wirdows 2000 Server Operabng System Mic;rnsoft SQL Server Netviewer$,eiver Specifications Dell 6600 PmverEdge Racket ount Servers each with, Quad 1,5GHP PCMiurn XtIon Froces5ofs "GB of RAM 4 _ 36GB Hard Disks 101100 NIC Windows 2000 Server Operating System Micrusaft SOL Server InterfaceiCommunications Server Specifications DO 6600 PoweerEdge Rackm.ount Servers each with: Quad 1.5GHz Pentium Xeon Processors GB of RAM 4 - 36GB Hard Disks 101100 NIC Wndows 2000 Server Operating System CITY OF"HUNTINGTON BEACH, CA CAD/RMS/NtO1111,E SYSTEM CONFICURATION RMS Cluster Server Specifications Dell 6"0 PowerEdge Ra(,,krr,,*)vnt Servers eachwift Quad 1.5CHz Pentium Xeor, Processors 6 GB RAM 2. t 8GB Hard Disks Storage Artsywith 10-36GB dfive,,,, ioiloo NIC Windows 20W. AdvortCed Server 05 105c,rosoft SOL Server gnlagm Booking sy-51em Archive Server Specifications Dell 6600 Pow e.TEdge Rackmm,,rt Servers eachwift QuM I.SGHz Pentium Xecr, Processors !G8 of RAM 4 - 36GS Hard Disks 10,1100 HIC Wir^dovv s 2000 Server Operatirg System klicrosoft,50,1, Server Communications Center Workstations Dell Precision 350 2.66 Gliz Pentium 4 Processors 256MB RAM 4GG6 Disk 214nch monitors Interfaces AnVAii VInformer (OCSO Message Swjtch�) IlInformer (l,'LEADS RMS) VNIDIT (MDC interface) VXNTP (Master Clock interface) VGADLin(CAD to RMS InterfAce) Imagis soaking Data Interface 0 SO rssaqe I Dispurcher Work ladonry 0y N) / MutursAa MobRe coca nimlications January 7, 2003 Note: All RM,51AFervieWo., workstations are provided by the C4 per RFP. VLEADS fir"Virs furl' d/ititfitF`f'TRfI RMS Workstation (Recommended) Dell Precision 340 2.0 Gflz Pentium 4 Processors 256MB RAM, 40GE Disk rnonito VNetviewer and 11 MetDispatcher Workstation (Recommended) Dell Precision 340 2,0 GHz Pert!Urn 4 Processor's 256MB RAN! 4OGB Disk 17-inch monitor -- 1 111iViltile and VLFAIDS AFR NVorkstations, (Qfy it) Concurrent each) Page I .1idS{ MP"'..., is s § fib£ £, ,Y i f E ££ {. .. �. ,q'( l lh} 3> .. ££ £P .. ..£..1s?£ WAD Database Server#I Dell PowerEdge 6600, Rackmount CAD 1 $ 15,986 $ 15,986 4 (1.5GHz) Intel Xeon Processors IMB Cache I GB RAM, ECC RAID with 4 - 36 Gigabyte Drives CD ROM Drive 100 Basc-T Ready Microsoft Windows 2000 Server (includes 5 client access lie.) Network Cable VExecutive I/CAD Database Server Software CAD 1 $ 35,000 $ 35,000 VC" Database Server #Z Dell PowerEdge 6600, Rackmount CAD f $ 16,821 $ 16,821 4 (1.5GHz) Intel Xeon Processors IMB Cache I GB RAM, ECC RAID with 4 - 36 Gigabyte Drives CD ROM Drive 100 Base-T Ready Microsoft Windows 2000 Server (includes 5 client access lie.) Network Cable 40/80GB DLT Tape Drive I/Executive 2 I/CAD Redundant Database Server Software CAD 1 $ 25,000 $ 25,000 Microsoft Visual C++ Administrative Tool CAD 1 $ 523 $ 523 Microsoft Office Developers Edition Reports Administrative Tool CAD 1 $ 978 $ 978 Communicationsanterface Server Dell PowerEdge 6600, Rackmount CAD 1 $ 15,986 $ 15,986 4 (1.5GHz) Intel Xeon Processors 1 MB Cache I I GB RAM, ECC RAID with 4 - 36 Gigabyte Drives CD ROM 100 Base-T Ready Microsoft Windows 2000 Server (includes 5 client access lie.) Network Cable I/NctDis atcber 5 concurrent users UCAD Net Dispatching CAD 1 $ 25,000 $ 25,000 Interface Products, including Im 'lementation & Travel I/Informee CIC/CJIS/NLETS/OCATS/DM CAD 1 $ 56,250 $ 56,250 I/MDT Mobile Data Terminals interface Module MDC 1 $ 65,500 $ 65,500 I/Tracker AVL CAD 1 $ 61,250 $ 61,250 I/MARS-Server Management Re ortin - Server Module CAD 1 $ 25,000 $ 25,000 XNTP Master Clock interface CAD 1 $ 2,300 $ 2,300 Police RMS Servers Cluster Configuration 04 Dell PowerEdge 6650, Rackmount PRMS 2 $ 24,461 $ 49,922 4 (1.5GHz) Intel Xeon Processors IMB Cache 6 GB RAM, ECC 2 - 18 Gigabyte Drives/server One External RAID Storage Array with 12 -36GB drives CD ROM 100 Base-T Ready Microsoft Windows 2000 Advanced Server (includes 25 client access lie.) Network Cable I/LEADS - Server Police RMS - Base Module PRMS 1 $ 20,000 $ 20,000 I/LEADS - Incident Based Reporting for UCR Police RMS Module PRMS 1 $ 10,000 $ 10,000 VLEADS CAD Link Police RMS Link with CAD PRMS 1 $ 10,000 $ 10,000 Ulnformcr to IILEADS CAD Oucry to VLEADS PRMS 1 $ 51,250 $ 51,250 MS Visual FoxPro Prof. RMS Database Administration Tool PRMS 1 $ 518 $ 518 3120/2003 Intergraph Public Safety Pricing Quote Page t of 4 }}{ff■�'"..} F S£yyly�y� £ ££ M 4 .`>*"`..., NetViewer Server Dell PowerEdge 6600, Rackmount CAD 1 $ 15,986 $ 15,986 4 (1.5GHz) Intel Xcon Processors 1MB Cache I GB RAM RAID with 4 - 36 Gigabyte Drives CD ROM 100 Base-T Ready Microsoft Windows 2000 Server (includes 5 client access lie.) Network Cable I/NetViewee 100 concurrent users UCAD Data inguiEy CAD 1 $ 90,000 $ 90,000 UBacku Baeku S stem Module CAD 1 $ 25,000 $ 25,000 Archive Server Dell PowerEdge 6600, Rackmount CAD 1 $ 15,986 $ 15,986 4 (1.5GHz) Intel Xcon Processors IMB Cache 1 GB RAM, ECC RAID with 4 - 36 Gigabyte Drives CD ROM Drive 100 Base-T Ready Microsoft Windows 2000 Server (includes 5 client access lie.) Network Cable Dispatcher Workstations Dell Precision 350 Workstation CAD 7 $ 3,379 $ 23,651 2.66 GHz Pentium 4 256MB RAM ATI Video Card 40 Gigabyte Disk Network Ready Microsoft Windows XP Professional Keyboard, Mouse, Sound Card Dual 21-Inch CRT Monitors 50 Foot UTP Cat 5 Network Cable UDis atcher IPS CAD Software CAD 7 $ 15,000 $ 105,000 Supervisor Workstation Dell Precision 350 Workstation CAD 1 $ 3,379 $ 3,379 2.66 GHz Pentium 4 256MB RAM ATI Video Card 40 Gigabyte Disk Network Ready Microsoft Windows XP Professional Keyboard, Mouse, Sound Card Dual 21-Inch CRT Monitors 50 Foot UTP Cat 5 Network Cable IfDis atcher IPS CAD Software CAD 1 $ 15,000 $ 15,000 IlMARS - Client Reporting Client Module CAD 1 $ 1000 $ 1,000 MS Office Professional Reporting Tool CAD 1 $ 575 $ 575 MGE Basic Nucleus MMing Tool CAD 1 $ 2,000 $ 2,000 MGE Basic Administrator Ma in Tool CAD 1 $ 4,000 $ 4,000 MGE Base Mapper - Bundle Mapping Tool CAD 1 $ 3,000 $ 3,000 MicroStation CAD Map Editing Tool CAD 1 $ 4,795 $ 4,795 Training Workstations Software I/Dis atcher for Training IPS CAD Software CAD 2 $ 7,500 $ 15,000 "S Workstations Software I/LEADS - RMS Concurrent Client Licenses for Desktop Police RMS Client Module PRMS 100 $ 1,500 $ 150,000 Mikde'Com titers Software I/I EADS -RMS Concurrent Client Licenses for MDC lPolice RMS Client Module M C 50 $ 1,500 $ 75,00a I/Mobile Concurrent Licenses MDT Client Module &MC 50 $ 1,000 $ 50,000 3/2012003 Intergraph Public Safety Pricing Quote Page 2 of 4 NetClock/GP5 Master Sync Clbek i',' �J� -._...... �X'�`. £3xx:. >.,.iO£.ii£E£Ii rI:£Ru.,. £ i } iiti NetClock/GPS Master Clock Model 8183 w/antenna 8225 GPS Ant. Surge Suppressor Model 8226 GPS Ant. Preamplifier Model 8227 Ant. Mount for flat roof, Model 8213 CA07100, 100 ft. RG-213 Ant. Cable Time Tap, Model 8179T , 9-pin TimeView 230, Model 8175 Display Clock DTMS, Device Time Manager Software for WIN 2000 TS1, TimeSet Software for WIN 2000 Installation CAD 1 $ 11,762 $ 11,762 Other Equipment Dell 42U rack with single PDU,common monitor/ke board/mouse COM 2 $ 4,409 $ 8,818 Trimble Placer 450 GPS Reciever MDC 100 $ 549 $ 54,900 Project M m, Im 1, & Training Services including TraYcI Services: Project Management COM 1 $ 310,500 $ 310,500 CAD Implementation CAD 1 $ 112,000 $ 112,000 Police RMS Im lementation PRMS 1 $ 131,750 $ 131,750 MUping Implementation CAD 1 $ 17,250 $ 17,250 RMS Data Conversion PRMS I $ 30,500 $ 30,500 I/Mobile Im lementation PRMS 1 $ 8,250 $ 8,250 Audit Trail Stud PCR16982 PRMS 1 $ 5,750 $ 5,750 Ex-felon/sex offenders report PCR16991 PRMS I $ 11,500 $ 11,500 Citation Re art PCR1700I PRMS I $ 11,500 $ 11,500 I/LEADS incident rep2rt mods PCR21085 PRMS 1 $ 5,750 $ 5 750 Custom California Accident Report PCR21086 PRMS 1 $ 5,750 $ 5,750 Custom Missing Person Re ort PCR21089 PRMS 1 $ 17,250 $ 17,250 Alarm Permit Module Mods PCRs 21134, 21380-21391,21394-21398 PRMS 1 $ 23,000 $ 23,000 Imo is Jail Interface PCRs 21129, 21871 PRMS 1 $ 53,500 $ 53,500 CA 180 - Stolen Vehicel Report PCR21275 PRMS 1 $ 17,250 $ 17,250 U load Alarm Permit PCR21392 PRMS I $ 25,500 $ 25,500 Police Daily Log Re rt CR21833 PRMS t $ 5,750 $ 5,750 Public Safetv Training: Classes UCAD System and Data Overview CAD 1 $ 11,250 $ 11,250 UCAD Map Fundamentals Workshop UCAD Train -the -Trainer CAD CAD 1 2 $ 6,000 $ 11,250 $ 6,000 $ 22,500 CAD Report Writing CAD 1 $ 5,950 $ 5,950 I/MARS- User CAD I $ 1,750 $ 1,750 I/MARS-Administrator CAD 1 $ 9,500 $ 9,500 PLEADS Administrator PRMS 1 I $ 7,750 $ 7,750 I/LEADS Train -the -Trainee PRMS I $ 11,250 $ 11,250 PLEADS SYSGUI Worksho PRMS I $ 6,000 $ 6,000 PLEADS System Overview PRMS 1 $ 6,000 $ 6,000 I/Mobile User CAD 1 $ 6,000 $ 6,000 AFR Training CAD I $ 6,000 $ 6,000 UNetDis atcher & lNetViewerTraining CAD 1 $ 3,500 $ 3,500 §Morting & Administering Windows 2000 for IPS Systems Includes materials CAD 1 $ 10,300 $ 10,300 UCAD System Administrator Training CAD 1 $ 11,250 $ 11,250 UCAD System Administrator II Training CAD t $ 11,250 $ 11,250 I/CAD Database Maintenance CADDBM Trainin CAD I $ 7,750 $ 7,750 PCAD Map Tools CADTools Training CAD 1 $ 9,500 $ 9 500 I/CAD Map Maintenance CAD 1 $ 11,250 $ I1„250 IPS Customized Training CAD 2 $ 11,250 $ 22,500 MicroStation Fundamentals for Mappers CAD l $ I I,250 $ 11,250 3/2012003 Intergraph Public Safety Pricing Quote Page 3 of 4 91 ys"ifilO i 021303�iilfil�l�l.i.,!!�iiii��l���liT'I B MUM Installation, Shipping, Insurance, -Escrow; BondWa anty 1';. Shipping and Insurance COM I S 2,312 $ 2,312 Hardware Staging and Installation COM I S 29,150 S 29,150 Performance Bond COM I S 18,903 $ 18,903 Source Code Escrow Administration Fee COM I IS 500 S 500 IntogEh Software Warran!X during im E lcmcntation period CAD I IS 2.700 S 2,700 TOTAUSYS-MINASUPRICE4 11111118, 1 1 Sdb=Total E*16*vi of SYWhi Wi W S. 2,20SM2 One Time System Discount COM S (220,595) Sub -Total Eidusive"d Extended :11ill 1 tAiff �iJ ,1jl S ; 1,995,357 Extended Hardware Warranty for 12 months 7x24,4 hour response included with hardware price COM I Included Extended Software Warranty for 12 months COM I S 114,950 Grand -Total Exclisive"or.�,Taxii',�4Maintenan�eAiid Q itions !—T 1� �� � 1; 1 qWrH!W 0,1,4X: i14 h, H", AIVIV:J + j� IM,14 tl;11�111 r a &A3,100,307, Taxes on Hardware and Software only 7.75% - TAX I S 79,057 NT4 11100 4NN14MIN.111 if! 25 E iv 5 T£ iIINEMX� IT 10104 't T11h A, J 10.4 4 T,i RIMINI! i till First Year Hardware Maintenance after Extended Warranty 7x24,4 hour response included with hardware price COM I Included First Year Software Maintenance after Extended Warranty COM I S 120,698 Total f6e.lit.YiifMaintenance ikftif.E:itiiidid i�1!11112!11t HPIiII0. VIV120969811 !---. . ---- -- . '- --- -.- --- - -- ---- CAD Sub -System - CAD S 915,679 Police RNIS Sub -System PRMS S 674,690 Mobile Sub -System MDC S 245,400 E100,307 Common Items com S 264,538 5 Total Cost for Complete System S 2 LL can nrovide a areselected.) General Services lApplication programming and dcvelor)mcntlwcck COM I S 5,7501 S 5,750 MGE Foundations Training 1On-site COM I S 13.0001 S 13,000 Pawn Slip Processing I I COM I I I $ 11,5001 S 11500 RAIS or Neffiewer Workstation' Dcll Precision 350 Workstation PRMS 1 $ 1,886 $1,886 2.26 GHz Pcntium 4 256MB RAM ATI Video Card 20 Gigabyte Disk Network Ready Microsoft Windows XP Professional Keyboard, Mouse, Sound Card Single 17-Inch CRT Monitor 150 Foot UTP Cat 5 Network Cable 3120/2003 Intergraph Public Safety Pricing Ouole Page 4 of 4 E ITEM IX IPS Change List For City of Huntington Beach, CA Prepared by Intergraph Public Safety • 4tqTEr-X5WH PUBLIC SAFETY Introduction Intergraph Public Safety is providing Commercial Off The Shelf (COTS) software to the City of Huntington Beach. Only items outlined in this document will be customized for the City. All other functionality outlined in the DSD will be achieved with the standard IPS products as priced in Item VIII - Customer Pricing. itemIX-change lisM.doc Page I • NTERGWH PUBLIC SAFETY Product Commitment Request ##: 16982 Request: General System Features — Audit Trail item number 194 of the Huntington Beach RFP. Services Provided: Because of the broad nature of the this requirement, IPS proposes a 1 week study to determine the audit requirements of the State of California, NCIC and the City of Huntington Beach. Once those requirements have been analyzed, IPS will present the findings to the City. IPS and the City will come to a mutually agreeable solution if it is discovered that not all audit requirements are met by the base system. Price: $5,750 itemIX-change HsM.doc Page 2 NTFr.WH PUBLIC SAFETY Product Commitment Request #: 16991 Request: RDBMS — Reports and Output item number 252 of the Huntington Beach RFP. Services Provided: IPS will create a report to conform to the State of California regulations for registered ex- felon/sex offenders. The City is required to provide all necessary documentation of the regulations and form format. The report will include information in accordance with the I/LEADS schema current on delivery of the product and any subsequent customer added fields. Price: $11,500 itemIX-change H M5.doc Page 3 • TEPGWH PUBLIC SAFETY Product Commitment Request #: 17001 Request: Traffic Reports and Output item number 101 of the Huntington Beach RFP. Services Provided: IPS will create a report to conform to compare citation locations and accident types and locations. IPS will work with the City to define the format of this report. The report will include information in accordance with the PLEADS schema current on delivery of the product and any subsequent customer added fields. Price: $11,500 itemlX-change lisnv5.doc Page 4 TERGWH PUBLIC SAFETY Product Commitment Request #: 21085 Request: Custom data fields to the standard I/LEADS incident report. Services Provided: Based on City analysis of the current I/LEADS incident report, it was determined that 1 I fields do not exist. IPS will create the 1 I City identified data fields on the incident module forms and will add those fields to the City configured VLEADS incident report. Price: $5,750 itemlX-change listv5.doc Page 5 4�NTERGWH PUBLIC SAFETY Product Commitment Request #: 21086 Request: Duplicate the CA 555 Accident Report to be output by ULEADS. This would include the CA 556 report that is a narrative supplement. Services Provided: The requested custom report requires a custom layout and a custom form for data collection. The report generated by ULEADS will contain all the data fields currently contained on the California State Report CHP-555. This report will be prepared for viewing and printing. The City will be responsible for the actual transmittal of the State required report to the State. IPS requires a current copy of the report and written description of each field on the report with specifications for valid data and a contact person to provide additional information, if needed. Price: $5,750 itemIX-change listO.doc Page 6 • NTEFGWH PUBLIC SAFETY Product Commitment Request #: 21089 Request: Duplicate the Huntington Beach Missing Person report. Services Provided: The requested custom report requires a custom layout and a custom form for data collection. The report generated by PLEADS will contain all the data fields currently contained on the current City Missing Person Report. IPS requires a current copy of each of these reports and written description of each field on the report with specifications for valid data and a contact person to provide additional information, if needed. The City is responsible for actual transmittal of the report to the State, if required to do so. This report will be prepared for viewing and printing. Price: $17,250 itemIX-change listv5.doc Page 7 4�NTEFGWH PUBLIC SAFETY Product Commitment Request #: 21129 and 21871 Request: Data interface between PLEADS and Imagis Jail Booking system Services Provided: The City shall provide an authoritative contact for the duration of the development and implementation of this functionality to help define and test the interface. The City is responsible for providing all data needed from the City's IMAGIS system. CABS to I/LEADS workflow IPS bids the development of an PLEADS Import Definition in ASCII delimited text to import data collected in the IMAGIS jail booking system into the PLEADS Arrest module. The import is restricted to data and data types as defined in the PLEADS database current on delivery of the product. Photos taken in CABS will be manually imported by the end user into the PLEADS system. PLEADS to CABS workflow IPS bids the development of a one-way interface to the Imagis CABS system. The proposed interface will export demographic information and the most current I/LEADS photograph set, if one exists, from the I/Leads Master Names table to a local directory or a directory that can be accessed via a UNC path. The exported demographic file will be ASCII format or some other mutually agreed upon format. Up to eight images will be exported based on the number of images that exist for the I/LEADS name record being exported. The image file format will be JPEG or some other mutually agreed upon format. The file naming convention will be determined at a later point and be mutually agreed upon by IPS and the City. This export will be triggered by a button that will be added to the PLEADS Master Name Form. The user will be required to activate the Name Record to be exported, via the PLEADS Names Module, and then select the new Export Name button. This does not include any services or software that may be required by the Imagis CABS system to support this interface (e.g. reading and processing the file sent from PLeads). pricei��$TBD item[X-change listO.doc Page 8 NTERGWH PUBLIC SAFETY Product Commitment Request #: 21134 Request: Please provide enhancements to the alarm module of ULEADS to fit the City requirements. IPS bases the work scoping on the Alarm Workflow documentation provided during the Phase I demonstrations and False Alarm Permit specification document. Services Provided: IPS will enhance the I/LEADS alarm module to meet the City of Huntington Beach's alarm management needs. IPS has also identified the specific requirement(s) [line #] from the Huntington Beach False Alarm Permit specifications that are inclusive of PCR 21134 cost. Please see the following line # and IPS response: • Line #4; Phone -indexed, searchable IPS will add up to three phone number fields on the alarm permit module to Iink that alarm permit to a phone number and allow the user to search the Alarm Permit module based on these phone numbers. • Line #7, False Alarm Summary —linked to False Alarm Response file IPS will configure alarm related Call for Service records be linked to an alarm permit record. The user can then use the involvement browser to see/access any alarm permit record related to a Call for Service record. • Line #8, When a new permit is being created, the system will automatically verify whether any duplicate permits have been issued by looking up location and phone number. IPS will add code that will verify when a new permit is being created, that it is not a duplicate permit [for location and phone number]. Currently, IPS checks only for location. • Line #12; By Permit Mailing Address —partial or full IPS will add a mailing address to the alarm permit module. • Line #13; By Permit Phone Number IPS will add up to three phone number fields on the alarm permit module to link that alarm permit to a phone number and allow the user to search the Alarm Permit module based on these phone numbers. itemlX-change listO.doc Page 9 NTERGWH PUBLIC SAFETY • Line #14; By Permit Issued Date IPS will change the Alarm Permit module to allow the user to search for alarm permits based on the status date. • Line #18, Generate active alarm permits by Commercial, Residential, Exempt or Pending type IPS will create a report combining active alarm permits with issued and expiration date for each of the type listed (Commercial, Residential, Exempt or Pending Type). • Line 419, Issue and Expiration dates based on user defined criteria IPS will create a report combining active alarm permits with issued and expiration date for each of the type listed (Commercial, Residential, Exempt or Pending Type). • Line #20, Generate mailing label for new and renewal permits IPS will create a report of mailing labels for new and renewal permits that adhere to the Avery brand -mailing label. • Line #23; If CAD calls have been processed, the system will issue a warning box IPS will add a field to indicate whether a call for service is alarm related. If call for service is alarm related, this field will be "checked" • Line #25, Verify CAD call phone number with Alarm Permit phone number IPS will change the "Exception Report' in the Alarm Permit module to look for false alarms call in the Calls for Service table. If any false alarms are found, the system will check for any matching alarm permit records based on location as well as phone number(s). Currently, IPS checks only for location. • Line #31; Once the false alarm is confirmed, the system will calculate the fine amount based on a pre -defined formula IPS will first design an interface for the user to create their configurable false alarm fine amounts (i.e. alarms 1-4 $0 charge; alarms 5-10 $5 each; alarms 11-15 $20 each). Once the false alarm is confirmed the system will calculate the number of false alarms in the given time frame (previous 365 days since issue date) and properly create a billing record for the matching alarm permit. Line 432; This pre -defined formula is configurable IPS will first design an interface for the user to create their configurable false alarm fine amounts (i.e. alarms 1-4 $0 charge; alarms 5-10 $5 each; alarms I1-15 $20 each). Once the false alarm is confirmed the system will calculate the number of false alarms in the given time frame (previous 365 days since issue date) and properly create a billing record for the matching alarm permit. itemlX-change listv5.doc Page 10 • NTEFr.3WH PUBLIC SAFETY The formula is configurable. • Line #40; Generate detailed/summary false alarm response and fine reports by a selected date range IPS will generate this report based on the sample provided by the City. • Line #41; Generate False Alarm Response reports and Fine reports by location IPS will generate this report based on the sample provided by the City. • Line #42, Convert/download selected false alarm response data into ASCII and EXCEL file format IPS will write export definitions to export the alarm permit response information. • Line #43; The system will merge Alarm Permits into one account and combine and re- calculate the false alarm fines IPS will provide a "button" on the Alarm Permit form to allow the user to merge two alarm permit records, including their involvements and billing records. Because of the complexity of the billing process (billing table), IPS will provide a report of the billing records before the merge and give the user a message/notification that they should review the new alarm permit and adjust their billing records accordingly. • Line #47, Alarm Application Transmittal — A form sent to notify businesses or individuals of Police response to a location where a valid alarm permit does not exist IPS will add a new "letter" to the Alarm Permit module. • Line #48; Failure To Pay — A form sent to notify businesses or individuals of outstanding alarm fines or Permit fees IPS will add a new "letter" to the Alarm Permit module. • Line #49; Non -Response Status — A form sent to notify a business or individual advising that the Police Department will not respond to any alarms at their location IPS will add a new "letter" to the Alarm Permit module. • Line #50, No -Permit Non -Response — A form sent to notify a business or individual advising the Police Department will not respond to any alarms at their location IPS will add a new "letter" to the Alarm Permit module. itemlX-change HsM.doc Page 11 NTERGWH PUBLIC SAFETY Line #52; Alarm Permit Suspension — This form is notification to a business or individual that response for alarms is suspended due to an excessive number of alarms at the location, or failure to obtain an alarm permit or pay outstanding fine invoices IPS will add a new "letter" to the Alarm Permit module. NOTE: The processing of commercial burglar alarms that come in as "HOT" must be made as a manual entry in the alarm billing module. This was discussed on site on 10/9/02 during an onsite meeting with Carol Phelps and Jim Carr in attendance and was agreeable. Price: $23,000 itemIX-change listv5.doc Page 12 • 4�NTERGWH PUBLIC SAFETY Product Commitment Request #: 21275 Request: Duplicate the CA 180 Stolen Vehicle Report to be output by PLEADS. Services Provided: The requested custom report requires a custom layout and a custom form for data collection. The report generated by PLEADS will contain all the data fields currently contained on the California State Report CHP-180. This report will be prepared for viewing and printing. The City will be responsible for the actual transmittal of the report to the State, if required to do so. IPS has a current copy of the report and but will need written description of each field on the report with specifications for valid data and a contact person to provide additional information. Price: $17,250 itemIX-change listv5.doc Page 13 • NTERGWH PUBLIC SAFETY Product Commitment Request #: 21392 Request: Upload Alarm Permit data. Services Provided: IPS has bid services to design, code, test, and implement the upload of Alarm Permits into the CAD Special Situation table. Price: $25,500 itemIX-change IistO.doc Page 14 NTEFGWH PUBLIC SAFETY Product Commitment Request #: 21529 Request: Convert Alarm Permit data, False Alarm Response data and property data to the ULEADS system. Services Provided: • Create mapping matrices • Design review of maps with Customer • Joint [IPS and Customer] audit of sample data set converted • Convert full data set • General consulting as required Price: $30,500 itemIX-change listO.doc Page 15 �NTERGWH PUBLIC SAFETY Product Commitment Request #: 21833 Request: Produce the Huntington Beach Police Daily Log Report Services Provided: IPS will replicate the City's standard report based on the data being captured by CAD. The report will be built solely from CAD data. The primary table used will be the LTN-HI (unit history) table in the CAD database. In order to track officer activity, the officer will be required to put themselves or have the dispatcher put them out of service on specific details. If an officer is writing a report, then officer or dispatcher will need to status the unit as out of service with a type of "report" for example. If there are other types of activities the officer needs to track to be printed on this report, the officer will need to put out of service with a particular type code in order to capture this in the CAD system. The out of service codes per type will be tallied on the report. If a field is not captured in CAD, it will not be able to be printed on the report. Price: $5,750 itemIX-change fist-O.doc Page 16 Exhibit B —Escrow Account Document Consultant shall establish an escrow account with the SouthTrust Bank of Alabama ("Escrow Agent") for the purpose of depositing the advanced payment of S 1,656,784.36 from Union Bank Escrow Account, $7,917.60 from City of Huntington Beach LLEBG Grant 99/00 plus interest and $61,652 from City of Huntington Beach LLEBG Grant 00/01 plus interest for a total of S1,726,353.90 plus interest, paid by Union Bank and the City of Huntington Beach to Consultant for the purchase and installation of a Computed - Aided Dispatch and Records Management System. The City shall pay all fees associated with this escrow account. Any cash funds or cash proceeds shall be deposited by the Escrow Agent in a non interest bearing account, in institutions which are federally insured for deposits in the amount of Escrow. Escrow Agent shall release the funds upon the receipt of instructions from Consultant, reciting the following: At such time that Consultant has met a payment milestone as defined in this Agreement, as is evidenced by a release of funds document ("Release") approved by the City of Huntington Beach that the milestone has been completed and accepted by the City, Consultant shall provide a copy of the Release to Escrow Agent. Upon presentment of the Release by IPS, Escrow Agent shall release the payment funds in an amount due per the terms of this Agreement. .7 • Exhibit C Software Escrow Agreement IFS shall provide all Source Code and any updates or fixes for the application software that the Customer has purchased from IPS for safekeeping with an escrow agent of IPS's choosing. The software source deposited with the escrow agent will be a snapshot of all source code maintained by IPS in the form of a Microsoft Visual Source Safe Archive. In this way, as Beneficiary of the Escrow agreement, the customer will have access to all source code of the products that they own for all versions of the software. Upon taking possession of the source code, the customer will have the right to use the source for products that they own in the versions currently installed on their system or any subsequent versions in the archive. IPS will make a deposit of the Source Safe Archive with the escrow agent once every six months. The Customer hereby agrees to pay the yearly standard fee for a Beneficiary of the source code. Customer shall have access to the Source Code in the event IPS becomes unable to, or otherwise fails to, maintain the software during the warranty period or during the maintenance period or if Licensor decides to stop support of the software application(s), or IPS becomes bankrupt. Upon the Customer taking possession of the Source Code, the Customer hereby agrees as follows: The Customer accepts full and total responsibility for the safe keeping of the source code. The Customer agrees that such Source Code shall be subject to the restrictions of transfer, sale, and reproduction placed on the software itself as stated in the software license signed by all parties. 2. The customer agrees to only use source code related to applications for which they own a license. There will be source from other applications in the archive. The Customer agrees that any unauthorized release of the Source Code will cause irreparable harm to IPS. Therefore the Customer agrees to compensate IPS for any and all damages IPS suffers, to include reasnnahte attamey's fees, resulting directly os indirectly from, but mat limited to, the miss -handling, miss -use, or theft of the source code, regardless of intent, or the absence thereof, by the Customer, its employees, former employees, agents and third party associates if so ordered by the court. Notwithstanding the foregoing, the Customer agrees that IPS is entitled to an immediate injunction to stop any further alleged or actual disclosure. No license under any trademark, patent, copyright, or any other intellectual property right, is, either granted or implied by the disclosure of the Source Code to the Customer. IPS' disclosure of the source code to the Customer shall not constitute any representation, warranty, assurance, guarantee or inducement by IPS to the Customer of any kind, and, in particular, with respect to the non - infringement of trademarks, patents, copyrights, or any other intellectual property rights, or other rights of third persons or of IPS. 5. IPS will not be responsible for maintaining the Source Code. Furthermore, IPS will not be liable for any consequences related to the use of Source Code modified by the Customer. A TTACHME.NT #2 • • •�, CITY OF HUNTINGTON BEACH INTERDEPARTMENTAL COMMUNICA TION To: Ray Silver, City Administrator From: Clay Martin, Director Of Administrative Services Subject: FIS 2003-21 — Approve Purchase of Intergraph's Police Computer Aided Dispatch / Records Management System Date: February 19, 2003 As required by Resolution 4832, this Fiscal Impact Statement has been prepared for "Approve Purchase of Intergraph's Police Computer Aided Dispatch / Records Management System". If the City Council approves this request (total appropriation $2,716,733) there will be no effect on any fund's unappropriated fund balance because all amounts are covered by an escrow account and/or existing appropriations. Clay Ma n Dire r of Administrative Services