Loading...
11-22-2010 Presentation: Police Computer SystemCAD /RMS Project NORCOM Dispatch Center Woodburn Police WOODBURN POLICE DEPARTMENT Integrity- Courage -Pride R Respect- Accountability- Service CAD i Computer Aided Dispatch Operated by NORCOM (5 Police, 11 Fire) iResides on City Owned IBM I- Series server i New World Systems Product System in- service since 1992 i Provides database of all emergency dispatch data for North Marion County Area for last 18 years Next Based System i NORCOM Agencies have approved and budgeted upgrade to Microsoft Server based system in 2009 WOODBURN POLICE DEPARTMENT \ . ; Integrity- Courage -Pride R Respect- Accountability- Service �. � RMS i Records Management System lOperated by WPD I Resides on same IBM server as CAD iNew World Systems Product i In service since 2002 iDatabase of all WPD calls for service since 2002 iSystem shared with Cities of Hubbard, Mt. Angel, & Silverton i Provides backbone for Mobile Data Terminals in police cars that supply information and reporting capabilities to all officers WOODBURN POLICE DEPARTMENT \ - ; Integrity- Courage -Pride R Respect- Accountability- Service �. � Issues with IBM I- Series Server i IBM's smallest mini - mainframe — Pros i Very stable Platform i Virtually Virus Free i Shared with Norcom (Shared expenses / no patch required) i NWS provides quality Public Safety System — Cons Dated technology and computer language Expensive to maintain /replace ($30k annually + $35 -40k to replace on 5 year basis as required) Cost prohibitive to training our own techs Vendors no longer upgrading software for I- Series Difficult to interface with Microsoft Servers for E- Commerce or web based collaborations i Norcom leaving this server WOODBURN POLICE DEPARTMENT �� Integrity- Courage -Pride R Respect- Accountability- Service �.� Microsoft Server Based System i Cons i Capital outlay to move from IBM i Security required to protect (Already exists in City Systems) i Pros Current technology being used by the rest of City of Woodburn (MS Servers) Less expensive to maintain /replace (Redundancy) City staff already trained to maintain other like systems All vendors providing upgrades for MS E- Commerce and web access built in Benefits of: better data sharing, flexibility, electronic documents and storage, easier navigation by end users, and ease of merging data with multiple other agencies. WOODBURN POLICE DEPARTMENT �� Integrity- Courage -Pride R Respect- Accountability- Service �.� New Wo Systems" iSeries Person Screen J d@I Regis Police Department 'LIVE' 9106Y07 Juvan,ilf Jack @t Naint @hzMCe 0llI M - AEGISPD Pec1:s PD Lock : N ,Jaekat p 0000301.29 J Name CUMN!INGlillm,upW10 "way NE. # Addrass 425 GLENGARY 0 City /State /tip WOLVERINE LAKE * 49990 'venue! r a Hain@ Phan@ p 2436241335 Work Phcn@ 9 : Racp . _ . . . : U R- Wh it@ S @x . . . . . M + Mat@ D.O.B. - . _ . , a Age , (Range) Y. U, M, D sacral 6mcurityl! 000000050 000 =00.0000 Ethnic 0rigin : + Height Mange) Reiglht (Range) Hair Celor * Ey@ Eclar Deiw@r Liedng& M: Dry Lic Type a S tarty + Expire Year F3 =Exit F4 =Prompt F7= kler•tz F- PSubset Rot F9- Activity FLO=Addl Char F1 - 0ancL&l F14 -Krawn Assot F1.5 -Hurd Shags 116 MA1ins F18-Fltdl, Nunrhws F19 =DL Char F20=CrinM Char F21=SHTH F22 =1;ddl Info F2A =Documents Hw WOODBURN POLICE DEPARTMENT 24/031 \ - ; Integrity- Courage -Pride R Respect- Accountability- Service �. � ® x a - 1 d Type Scar,Mark,Tattoo Description Save Delete Print Activity Audit Viewer NCIC Help Scar)Mark /Tattoo: Location: Type {' ScarOther [D escri6e) Chest Name and Address Other (Describe) Chest Description: • Tattod Last Name: First Name: Middle Name: Name Suffix: Affiliation: Bass Sal Rudolph F - Location: Verified /Unmatched Qualifier: Venue: Location Type: __j 22 WASHBOARD LN Ridgeland Address r Override GEO City: Ridgeland State: ZIP: 29936 Phone: Phone Type: 313 494 - x SC 3 - -5463 Residence i South Carolina Residence 09 -19 -05 Driver's License Date of Birth: Age: SSN: License: State: Expiration Date: Class of License: 0911 612005 15 33 10/17/1968 3� 743 -88 -1102 007981134 I SC - Operator South Carolina Operator �* Physical Characteristics Race: Sex: Height Range: Weight Range: Eye Color: Hair Color: White Male r Ft. In. To r Ft. In. 190 To BLU None White Male Blue N- :.>r., Cl School /Employer Info Rf 7 M O1Crime Specialties Rf Contact Info IF J Scars, Marks, Tattoo:f5g J ❑ New WJ� Open 615ave X Delete (D Cancel Location Type Scar,Mark,Tattoo Description J Scars, Marks, Tattoos Scar)Mark /Tattoo: Location: Type {' ScarOther [D escri6e) Chest f Mark Other (Describe) Chest Description: • Tattod Single Click displays -M �D related information x 09 -16 -05 0911 612005 14 57 ff � - ) Inteority- Couraoe -Pride A Resnect- Accountability- Service ( Project Planning NORCOM i Planning to upgrade CAD since 2007 i Unable to upgrade CAD without move to MS servers i WPD Life cycle of RMS has been studied since 2007 after most recent (- Series purchase (Next purchase due 2011 -12) Identified New World MS product as best selection in 2008 (only vendor with a method to readily convert data from IBM to MSP) Began discussions with vendor on combined project concept in Fall 2008 (CAD /RMS /Finance) Project tabled after Dec. 12, 2008 ■ Finance Department I Entered discussion when upgrade for Financial System was identified as a critical need this FY WOODBURN POLICE DEPARTMENT �� Integrity- Courage -Pride R Respect- Accountability- Service �.� Project Timing i Joint WPD, Norcom, Finance Dept. Project proposed due to: I Individual Departmental needs (Available operational efficiencies (Maintaining valuable databases i Current maintenance cost savings iReplacement cost savings (Vendor price concessions on joint project WOODBURN POLICE DEPARTMENT \ - ; Integrity- Courage -Pride R Respect- Accountability- Service �. � Current Financial System i Logos system in use since 2002 Operated on IBM Series platform Finance system provides — Human Resources, Payroll, Utility Billing, Business Licensing, Account Payable, Budgeting and General Ledger i Currently utilize third party provider for maintenance and warranty coverage i Finance Director to evaluate current processes and systems WOODBURN POLICE DEPARTMENT �.� Integrity- Courage -Pride R Respect- Accountability - Service A Financial System Comparison Finance specific — i Ability to utilize budgeting component within system (no longer need to utilize spreadsheet to build budget and then key into Logos) i `Real Time'data i On -line, e- commerce services i Improved security and rights limitations i Manager ability to review and analyze data WOODBURN POLICE DEPARTMENT �.� Integrity- Courage -Pride R Respect- Accountability - Service A I Session A - [24 x 80] New World Systems Corporation JRN RPPLICRTION UTILITIES Initial Menu for Jan Robertson 1. Financial System Main Menu 2. Financials TES[ 3. Fixed Rssets 11. CRPD Payroll - NEW 12. CRPD Payroll - NEW TEST 13. CRPD Payroll - OLD 14. CRPD Rdvanced Personnel Selection or command = = => 1 F3 =Exit F4= Prompt F6= Display a MW MM .VC Al. �In 31. MRCR Financial System Main Menu 32. MRCR Financials C i Session A - [24 a 80] 60. My Tasks CRPD - * *LIVE ** 70. Inquiry 11/18/08 Inquiry Menu 80. System Services Menu 90. Signoff Type a menu option number below, then press Enter. CRPD - * *LIVE ** FMOOOOSI 11/18/08 Financial Main Menu Rel 7.04 Type a menu option number below, then press Enter. 1. General Ledger Main Menu 7. Project /Grant Accounting Main Menu 2. Budgetary Reporting Main Menu 8. Revenue Accounting Main Menu 3. Annual Budget Processing Main Menu 9. Capital Assets Main Menu 4. Procurement Processing Main Menu 10. Government Reporting Main Menu 5. Accounts Payable Main Men 11 T- ,, --toru Management Main] Menu 6. Accounts Receivable Main O -1 Session A - [24 x 80] E6it File Type a menu option below: = = => 70 F3 =Exit F4= Prompt F12 =Can M3 MW GL131OS1 1. Financial Inquiry 7. Project Inquiry 2. Departmental Inquiry 8. Check Inquiry 3. Transaction Inquiry 4. Procurement Inquiry 5. Vendor Inquiry 6. Revenue Rccounting Inquiry 60. My Tasks 80. System Services Menu 90. Signoff Type a menu option below: = = => 5 F3 =Exit F4= Prompt F12= Cancel a MW Favorite: + © 1985, 2006 New World Systems Corp. 21/008 File Edit View Favorites Tools Help +f Back L J l "rJ 1 - Search Favorites - k- ...` Address http; f f 172,16.255.1Mogosf Go Links " Search Web - - - C�D Mail - Shopping - My Yahoo! - Q Answers - Games - Music - [}my Web - mySearch Type Purchase Orc Search For myReports (88) l Folder List C3 Current ( 25 ) C� Archive ( 63 ) New World Systems ar 011 '93.2cpof [Mute Start Time Completed nd Payment due 01!10!07 - ... 01l0T2007 12:00 AM in promised to pay utility ac... 01l0T2007 12.00 AM ued 01l0T2007 1:13 PM Inquiries ► General Ledger mySettings Customize Page View Change Password Email Notification Invoice E Purchas Receipts Requisit Requisit G1L Organizations 2006 - 00000099 2006 - 00000025 2006 - 00000003 myNew World 0 Log out rvedder A 71 Week _]All Open 4 4 January 2007 � F Sun Man Tue Wed Thu Fri Sat 31 011 02 041 091 10 11 05 06 13 07 08 1 12 14 15 16 17 18 19 20 21 22 23 24 25 25 27 28 29 30 31 01 02 03 041 05 06 07 08 091 10 Descril)tio Attach lel 04.103 - Finance Department.Budgeting mist supplies 04.101 - Finance Department.Accounting Desk and Chair 31 Office Supplies C Done Q Trusted sites 0 1 Session A - [24 x 80] CRPD * *TEST* *FAKE* *UNREAL ** 11/17/08 Work with Employee Detail Hours Pay Group . . . . B B Batch Number: NWSTEST Department /Sub -Dept: CCC Conejo Cnt Employee . . . � = 2821 Celeste Romanov HR2O8OS1 Reset: + Rate of Pay .0000 Status: Active Regular Hours: Premium Hours: Type options, ••• Employee Ho 2= Change 4= if Work Date . 6222008 + Sunday Opt Date FB =Exit F4 =P (2 Dec) Use Employee Project: Y (Y /N) Shift Worked . . . + Reason . . . . . . + Hours Code Hours . . . . . Other Pay . . . . . Separate Check . . . Job Classification . G/L Organization . . Project /Sub - Project : MR 0000 0000 28/001 fit LA 4w P &wNu M .g-j — 9 �.o in rb7e. t H c u - s Q LffT. m ary )n q Liyy . f i Sm lV,44.0 --OLO, il!MLL) Ir PhA 411 EQU -SLr-, aarwi , ro. mvm op I abl palk" I •PIKL) 4= .:S*79 aespm S:Kis I-IM[5 loomm ava MPMO :lP*L0 ROKA ' 4FM13 4 03EUP 10n JWFIKK) dGF.SM 1095 CO3 gi iVl alb"El P7Lppm qu Lc:arlka m lag -E tm lk i&mtmcj to: A= -W 94?NCI l;AOA W I a�4kw k Xa WN 40A ----------------------- 4 EH rd a - hv. F*m r I CA= t:? i Q—C—JM3a,t- a mmm E-D Fll Laa Cimu GJNU eh rht%.b. iL� it m D= N Kmmj r ,rkl 4 AOW pft&- I 1m� avow .g-j — 9 �.o in rb7e. t H c u - s Q LffT. m ary )n q Liyy . f i Sm lV,44.0 --OLO, il!MLL) Ir PhA 411 EQU -SLr-, aarwi , ro. mvm op I abl palk" I •PIKL) 4= .:S*79 aespm S:Kis I-IM[5 loomm rn3nip "rs ] :lP*L0 ROKA 46IO04 60a* 4FM13 4 03EUP 10n JWFIKK) dGF.SM 1095 CO3 gi iVl alb"El P7Lppm 4 54 3 W T0310 641 ad N M -tKIK" 127M2 i&mtmcj to: A= idw S ffm 211 Mps 94?NCI SIPOM - P 2 CO3 -120d fffim ft2mmdK Cp F F rhil dwirig, a specifiEd date range to ensue - lat in e Is not cl1 x9en riwe tliali LhE states Ellond - - be - of tires per ymt -P kmi r"mtkpMmu I V: ril.. a -Nm� pwowimm IVMxr. rqpwll P r3 I mi adm I IWIQ "dAl lljl� p6r-1 w Aue 1 WC4!Ax N r p CIM = ' In zim lopa Cow Qm Pfd OMMArmml IM didw t5r1711G fro! 1" Fl.r F - Iw , : F ----- Y ------------ - F �R IREG • FWP UWF� =1 I =I A F — — 0 F— ri 11W2 MVjFj.gWp - .3 : 2-r A !d A o ----------------------- im elf lves .MF — - — —A A Aue 0 +rr _ s Home 0Add to myFavorites myNew World 0 Log out rvedder New World Systems ❑ Reports for Ron Vedder J ❑ Current ❑ Archive J ❑ 2005 G!L J ❑ 2006 ❑ Financials ❑ Budget L� ❑ Budget Performance Report as of 12!31!05 3 _ ❑ Budget Performance Report ❑ Budget Worksheet Report ❑ Budget Worksheet Report ❑ Budget Transaction Report J ❑ Budget by Organization Report ❑ Budget Performance Report ❑ Budget Performance Report J ❑ Budget by Organization Report ❑ Budget Transaction Report ❑ Budget Worksheet Report J ❑ Budget by Function Report New %V0111 ('11y Revenue Budget Performance Report In Through Date: 123 U2004 Current Budget Less Prior Adopted Budget Amended Month YTd YTd YTd % Year A000urt Number Budget Amendments Budget Transactions Enoumbranoes Transactions Transactions Reo'd Total Fund: 909 - General Fund Department: 000 - Revenues 402.000 Taxes -Real 0.00 (423.800.00) (423.800.00) 0.00 0.00 0.00 (423.800.00) Property 490.000 Federal Grant 90.000.00 700,000.00 790.000.00 9.000.000.00 0.00 9.300.000.00 (590.000.00) 9 495.000 Taxes - Personal 920.000.00 0.00 920.000.00 0.00 0.00 0.00 920.000.00 Property 420.000 State Grants 5.000.00 0.00 5.000.00 0.00 0.00 305.332.99 (300.332.99)15.9 449.000 Tax -Prop- 0.00 0.00 0.00 0.00 0.00 0.00 0.00 ExoesseR I 442.000 Tax -Prop Coll 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Fee 444.000 Tax -Prop Adj 94.587.00 0.00 94.587.00 0.00 0.00 0.00 94.587.00 4415.000 Interest On Del Tx 92.000.00 0.00 92.000.00 0.00 0.00 0.00 92.000.00 470.000 License -Sign & 2.000.00 0.00 2.000.00 0.00 0.00 0.00 2.000.00 Awning 473.000 License - General 4.000.00 0.00 4.000.00 0.00 0.00 898.50 3.909.50 Contractor 4715.000 License - Electric 4.000.00 0.00 4.000.00 0.00 0.00 0.00 4.000.00 Contr 478.000 Lioense -Heat 4.000.00 0.00 4.000.00 0.00 0.00 0.00 4.000.00 Contractor 4815.000 License-Public 2.000.00 0.00 2.000.00 0.00 0.00 0.00 2.000.00 Vehicle 4 i i Q Trusted sites i+ w11e I [ Prin# El Choose Printer l Print Preview I• Decision Point i Accept Plan 1 -12 Months Financial System Implemented 12 -24 Months CAD /RMS implemented i Status Quo (Plan Rejected) Budget for "Patch" with CAD system when Norcom moves off I- Series (Estimate $35K plus annual updates) Budget for replacement of IBM I- series in 2011 -12 FY ($35- 40K estimate) Continue to budget $30K annually for maintenance of IBM -I series (+ loss of Norcom share of maintenance after they move to MS server $10k -$15k estimate) Establish new life cycle plan for RMS /Financial Systems WOODBURN POLICE DEPARTMENT �� Integrity- Courage -Pride R Respect- Accountability- Service �.� Questions? Teamwork Remember, upon the conduct of each depends the fate of all. -- Alexander the Great WOODBURN POLICE DEPARTMENT �� Integrity- Courage -Pride R Respect- Accountability- Service �.�