The URL can be used to link to this page

Home My WebLink About2002-149 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 RESOLUTION NO. 2002-149 RESOLUTION OF THE CITY OF SAN BERNARDINO AUTHORIZING THE PURCHASING MANAGER TO AWARD AN ANNUAL PURCHASE ORDER AND SERVICE AGREEMENT, WITH TWO SINGLE YEAR RENEWAL OPTIONS, TO HARRIS COMPUTER SYSTEMS FOR MAINTENANCE AND SUPPORT OF UNIDA T A. SB+ AND FINANCIAL MODULES FOR THE CITY'S FINANCIAL SYSTEM AND THE MUNICIPAL WATER DEPARTMENT'S FINANCIAL SYSTEM. BE IT RESOLVED BY THE MAYOR AND COMMON COUNCIL OF THE CITY OF SAN BERNARDINO AS FOLLOWS: SECTION I: That Harris Computer Systems IS the sole source for maintenance and support of the City's Unidata, SB+ and linancial modules. Pursuant to this determination, the Purchasing Manager is hereby authorized to issue an Annual Purchase Order and Service Agreement (a copy of which is attached hereto as Exhibit "A" and incorporated in full herein), with two single year renewal options. to Harris Computer Systems in an amount not to exceed $57.161.30 for Fiscal Year 2002/2003 for maintenance and support of the City's Unidata. SB+ and linancial modules. Future year renewal options shall be contingent upon funds being approved in the City's budget for this service. SECTION 2: The authorization to execute the above referenced agreement order is rescinded if it is not issued within ninety (90) days of the passage of this resolution. I HEREBY CERTIFY thai the foregoing resolution was duly adopted by the Mayor and Common Council of the City of San Bernardino at a regular joint III III III 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 2002-149 RESOLUTION OF THE CITY OF SAN BERNARDINO AUTHORIZING THE PURCHASING MANAGER TO AWARD AN ANNUAL PURCHASE ORDER AND SERVICE AGREEMENT. WITH TWO SINGLE YEAR RENEWAL OPTIONS. TO HARRIS COMPUTER SYSTEMS FOR MA1NTENANCE AND SUPPORT OF UNlDATA. SB+ AND F1NANC1AL MODULES FOR THE CITY'S F1NANC1AL SYSTEM AND THE MUN1CIPAL WATER DEPARTMENT'S FINANC1AL SYSTEM. meeting thereof. held on the 3rd day of June . 2002. by the following vote. to wit: Council Members Aves Navs Abstain Absent ESTRADA -L LIEN X McGINNIS X DERRY X SUAREZ X - ANDERSON X MCCAMMACK X .2002. The foregoing resolution is hereby approved this Approved as to form and legal content: James F. Penman. City Attorney BY: ~~).fe1//~ U ~ 2002-149 300 North "D" Street. San Bernardino' CA 92418-0001 www.ci.san-bernardino.ca.us ;" January 31,2002 Tanya Bailie> Harris Computer i '11 cenirepoim Dr. Suite 200 Nepean, Ontario, Canada Dear Service Provider: The City of San Bernardino I.S. Division is preparing its annual budget. Please complete and return this quote letter on or before February 15th, 2002. Maintenance Period: July 1, 2002 through June 30, 2003 Maintenance of. Separate quotes for City and Water for: 1) Technical Services for application software 2) Unidata Annual license renewal fee/maintenance 3) Ar.nu~1 Rort fee Please include a copy of the maintenance agreement, terms and conditions, and any other documents pertinent to the iirTnual maintenance. Mail this comgleted quote letter and above document(s) to: IS Division, 4 h floor 300 North "D" Street San Bernardino, CA 92418 Authorized Vendor Representative 7/1102 - 6/30/03 annual maintenance fee: 1>"'5~ 1(.,\ 00 Signature: 11am.a: Title: Addressl: Address2 : Telephone: Fax: Email: )t~C.'1 >-.I.' &...--.u' l-4li~ m6":~. r ~~r\ llz: (0 ~ Dr .$ dQ:j "''-'. Or{ 6>1~-';>~,"-5Slt ....;)\41 "t:>' -;:)~ -'l.~-:n ........LH\I E.. t--...........r ,~r~ui'C. (OU, , Sales Tax: Shipping & Handling: Other (describe): Grand total: q S "I I bl,"lO Notice: I.S. will budget the grand total figure provided, and it cannot be increased at a later date. Failure to provide an all-inclusive grand total will result in receiving the lesser amount. For questions or commen,ts, your contact is: Name: Mark Yavomicky Email: yavornicky_ma@ci.san-bemardino.ca.us Fax: (909) 384-7236 Phone: (909) 384-5947 Thank youl Notice: The signed original copy of this letter must be mailed to us. If possible, please also email or fax a copy to the contact shown on the left. Thank you. Annual maintenance fee for 7/1/01 through 6/30/02 was $51,706.00 'qO? 1,100.00 37,430.00 .- 2002-149 San Bernardino Water 14,391.30 2,560.00 1,280.00 240.00 710.00 550.00 19,731.30 " 2002-149 . 1_ Schedule A HARRIS COMPUTER SYSTEMS Software Support Agreement Standard Guidelines ,. 200:?::t_49 Purpose The purpose of this document is to provide our customers with information on our standard coverage, the services which are included as part of your annual software support, a listing of call priorities, an outline of our escalation procedures, details on our current service rates. This document will serve as a guideline for the support department but will be superceded by an existing, signed software support contract where applicable. Harris reserves the right to make modifications to this document as required. Standard Support and Maintenance Services The services listed below are services that are included as part of your software support contract. . 800 Telephone support (8:00am - 8:00pm Eastern Standard Time, Monday to Friday) . "On Call" after hours support (Scheduled assistance for installations, upgrades & other special projects, there may be charges depending on the scope of work) . Technical troubleshooting Operating System Hardware Development tools/licenses . E-mail support call logging and notification . Free Harris eSupport access with the following on-line benefits: Log & close calls View & update calls Update contact information Access published documentation Access available downloads Access Support knowledge base . Standard software releases and updates Defect corrections (as warranted) Planned enhancements Payroll regulated changes Release notes . Limited training questions (15 minutes) . DB tuning / optimization . Customer Care Program Quarterly News Letter with support tips Technical support bulletins Communication on new products and services . Outstanding Calls Report with conference call as required . Design review for potential enhancements or custom modifications - free estimate . Assist with printer setup within the software provided it is setup correctly in the Operating System. 2002-149 " - 3 - Billable Support Services The services listed below are services that are out of scope of your software support contract and are therefore considered billable services. . On-site training . Extended telephone training . Forms redesign or creation (includes Bill Prints and Letters) . Changes to handheld interface or creation of new interface . Changes to pre-authorized payment (PAP) file . File imports/exports - Interfaces to other applications . Setting up test areas on tile server. . Custom modifications . Addition oftokens for Letters module . Setting up additional companies . Postal mode updates . Notice Prints . Reversal of custom code . Setting up new General Ledgers . Data conversions / global modification to setup table data . Upgrades of third party software . Database refreshes . Regular Project Management services Rates . $ I ,500/day or $200/hour Training Enhancements Custom Modifications Report Creation . Non-active clients $300 to log a call $200 per hour (minimum of I hour) . Handheld Interface - $5,000 . Test database set-up - $750 . Forms activation, $275 per form . Documentation: CD $50, Manual $75 - $100 2002-149 - 4- Call Priorities In an effort to assign our resources to incoming calls according to the urgency of the issue being reported, Harris Computer Systems has identified three types of call priorities, I, 2 & 3. A Priority I call is deemed by our support staff to be an Urgent or High Priority call, Priority 2 is classified as a Medium Priority and Priority 3 is deemed to be a Low Priority. The criteria used to establish guidelines for these calls is as follows: Priority 1 . System Down (HW, OS, Database, Application) . Inability to process Payroll checks . Inability to process Accounts Payable checks . Inability to process bills . Program errors without workarounds . Incorrect calculation errors impacting a majority of records . Aborted postings or error messages preventing data integration and update . Performance issues of severe nature impacting critical processes . Hand-held interface issues preventing billing Priority 2 . System errors that have workarounds . Calculation errors impacting a minority of records . Reports calculation issues . Printer related issues (related to interfaces with our software and not the printer itself) . Security issues . HH issues not preventing billing . Performance issues not impacting critical processes . Usability issues . Workstation connectivity issues (WS specific) Priority 3 . Report formatting issues . Training questions, how to, or implementing new processes . Aesthetic issues . Issues with workarounds for large majority of accounts . Recommendations for enhancements on system changes . Questions on documentation 2002-149 - 5 - Call Process In order to escalate your issue to the appropriate resource, it is important to ensure that your call has been logged. Below is our current process for logging calls within the support department. Call Process Place a support call through eSupport at httll://Sullllor1.harriscomputer.com or by email to: 'lIllllurt!l,harrisWlllllllter.WIll , by phone to 866-450-6696 or by fax to 613-723-1515. Your call must contain: Your company name, contact person, software product & version, module and/or menu selection, nature of issue, detailed description of your question or issue, Batch #, Journal #, Account # (if applicable) support call reference # (See Customer Log Form) U Harris eSupport or the Support Coordinator will provide you with a CalllD to track your issue and your call will be logged into our support tracking database. u Your call will be stored in a queue and the first available support representative will be assigned to deal with your issue. U As the support representative assigned to your call investigates your issue, you will be contacted and advised as to where the issue stands and the course of action that will be taken for resolution. Ifwe require additional information, you will be contacted by the assigned support representative to supply the information required. All correspondence and actions associated with your call will be tracked against the call in our support database. At any time, log onto eSupport to see the status of your call. U Once your issue has been resolved, you will receive an automated notification by email that your call has been closed. This email will contain the entire event history of the call from the time the call was created leading up to the resolution of the call. You also have the option of viewing both your open and closed calls on-line through eSupport. U If the issue needs to be escalated to a programmer, your issue will be logged into our Development database and you will be provided with a Tracker # to track the progress of your development issue. At this time, your support call will be closed and the Tracker # provided will become your new reference #. Issues escalated to Development will be scheduled for resolution and may not be resolved immediately depending on the nature of the issue. U Contact the support department at your convenience for a status update on your Development Issue. .' 2002-149 - 6- Escalation Procedures Our response times will vary based on call priorities. We do our best to ensure that we deal with incoming calls in the order that they are received. however calls will be escalated based on the urgency of the issue reported. Our escalation process is defined below. This process has been put into place to ensure that issues are being dealt with appropriately. If at any time you not satisfied with the resolution of your issue or the response to your call. please contact our Support Coordinator and we will have the appropriate individual follow up. Escalation Process Your call is logged with Harris Support U If your call is a Priority I and it has not been responded to within 4 hours. the support resources responsible for your call are notified by email and your call is escalated internally to a level I. Priority 2 calls will be escalated if not responded to within 12 hours and Priority 3 calls not responded to within 24 hours will be escalated. U If your Priority I call has not been responded to 4 hours after the designated timeframe, the Group Leaders are notified and your call is escalated to a level 2. U If your call has not been responded to after 5 hours from the designated timeframe, the Manager of Support is notified and your call is escalated to a level 3. U If your call has not been responded to after 6 hours from the designated timeframe, the VP of Support & Development is notified and your call is escalated to a level 4. U If your call has not been responded to after 7 hours from the designated timeframe, the Chief Operating Officer is notified and your call is escalated to a level 5, our final level of escalation. Appendix A 2002-149 - 7 - Below is a listing of Canadian Statutory Holidays for 200 I. Please note that Harris Support will be closed on designated days as outlined below, emergency support will be available in most cases when the US does not have a corresponding statutory holiday. New Year's Day Good Friday Victoria Day Canada Day Provincial/Civic Holiday Labour Day Thanksgiving Day Christmas Day Boxing Day January I April I May 20 July I August 5 September 2 October 14 December 25 December 26 Closed Emergency Support Emergency Support Emergency Support Emergency Support Closed Emergency Support Closed Closed 2002-149 - 8- Appendix B HARDWARE SUPPORT AGREEMENT Purpose The purpose of this document is to provide our customers with information on our standard coverage and the services which are included as part of your annual hardware support. This document will serve as a guideline for the support department but will be superceded by an existing, signed hardware support contract where applicable. Harris reserves the right to make modifications to this document as required. Standard Hardware Support and Maintenance Services The services listed below are services that are included as part of your hardware support contract. . 800 Telephone support (8:00am - 8:00pm Eastern Standard Time, Monday to Friday. . "On Call" after hours support (Scheduled assistance for installations, upgrades & other special projects, there may be charges depending on the scope of work) . Modem support (through one of our recommended methods of communication) . Technical troubleshooting On components listed on your Hardware Service Agreement Operating System Development tools/licenses . Limited training questions (15 minutes) . Creation of backup scripts / backup recovery . Recovering data resulting from system crashes . Recommendations on specific hardware requirements Billable Support Services The services listed below are services that are out of scope of your hardware support contract and are therefore considered billable services. Please note we do not provide Hardware support on any Printers. . On-site installation or upgrade of hardware or other components . Extended telephone training . Reconfiguring hardware and fileservers . Recovering data resulting from client error . Upgrading of hardware systems . Preventative maintenance monitoring or other services 2002-149 - 9- . Recommending or assisting with disaster recovery plans Rates . $1 ,500/day or $200/hour . Non-active clients $300 to log a call $200 per hour (minimum of I hour) Call Priorities In an effort to assign our resources to incoming calls according to the urgency of the issue being reported, Harris Computer Systems has identified three types of call priorities, I, 2 & 3. A Priority I call is deemed by our support staffto be an Urgent or High Priority call, Priority 2 is classified as a Medium Priority and Priority 3 is deemed to be a Low Priority. The criteria used to establish guidelines for these calls is as follows: Priority 1 . System Down (HW, OS, Database, Application) . File system full . Performance issues of severe nature impacting critical processes Priority 2 . System errors that have workarounds . Performance issues not impacting critical processes . Workstation connectivity issues (WS specific) . Backup problems Priority 3 . Recommendations for enhancements on system changes . Training on network of IS related functions Connection Methods To ensure we can effectively support our clients, we ask that a communication link is established and maintained between our two sites. It is the client's responsibility to ensure the connection is valid at your location so that Harris can connect to your site and resolve the issue at hand. Our recommended methods of connection are: . Internet . VPN . RAS . Direct Connection .' 2002-149 - 10- Appendix C THIRD PARTY SUPPORT AGREEMENT Purpose The purpose of this document is to provide our customers with information on our standard coverage and the services which are included as part of your annual 3'd party support. This document will serve as a guideline for the support department but will be superceded by an existing. signed contract where applicable. Harris reserves the right to make modifications to this document as required. Standard Third Party Support and Maintenance Services For those clients with Harris Computer Systems maintenance on 3"' party products, Harris will provide support as described below. Harris provides I ,( line support for all 3'd party products listed below and will escalate to the vendor if required. Please note that 3'd party installations & preventative maintenance services are not included as part of your maintenance unless otherwise indicated below. . Informix - Standard Engine & Online Engine databases. Support provided for Harris database related issues ODBC installation & connection to Harris databases Updating database to support new Harris software releases Entitlement to new Informix software shipments Initiallnformix installation & configuration . Unidata Entitlement to new Unidata software shipments Initial Unidata installation & configuration I" line support for troubleshooting Unidata related issues . GUI Entitlement to new GUI software releases Installation & configuration I" line support for troubleshooting GUI related issues . System Builder & SB+ Entitlement to new SB software releases Installation & configuration I" line support for troubleshooting SB related issues . Report Writer (Impromptu) Administrator & User License Initial installation & configuration of Impromptu software. Set up oflmpromptu and establishing a connection with the PUBS software Limited assistance in utilizing standard report writer functionality (15 min. max.) Data Dictionary Updates to catalog which reflect changes in PUBS upgrades Assistance in locating information within the catalog Direction on an existing report (a copy of the report is needed) 2002-149 -II - Billable 3rd Party Services . Informix upgrades & installations (other than at time of initial purchase) . Unidata upgrades & installations (other than at time of initial purchase) . Report Writer upgrades & installations (other than at time of initial purchase) . Re-establishmcnt of ODBC connection if connection was lost due to actions of non-Harris personnel. . ODBC connections to other 3" party products . Creation of custom reports . Report Writer training Rates . $ !,SOO/day or $200/hour . Non-active clients $300 to log a call $200 per hour (minimum of 1 hour)