HomeMy WebLinkAboutResolutions - 2009.03.05 - 9845MISCELLANEOUS RESOLUTION 1#09037
BY: FINANCE COMMITTEE, TOM MIDDLETON, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY — FIRST QUARTER 2009 DEVELOPMENT
APPROPRIATION TRANSFER
TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS
Chairperson, Ladies and Gentlemen:
WHEREAS all development cost is incorporated as a single appropriation within the non-
departmental budget and then an amount equal to the actual expense is transferred to the user
department with a summary report to the Finance Committee; and
WHEREAS the Department of Information Technology has determined the First Quarter 2009
development charges to be $1,233,994.20 and the imaging development charge to be $23,810.66 for the
General Fund/General Purpose County departments; and
WHEREAS direct charges to Special Revenue and Proprietary fund departments are
$630,786.38, non-governmental imaging development are $17,889.80, and non-county agencies are
$1,697.60 for the First Quarter 2009; and
WHEREAS an appropriation transfer to General Fund/General Purpose County departments is
needed to fund these development charges.
NOW THEREFORE BE IT RESOLVED that the Oakland County Board of Commissioners has
reviewed the First Quarter 2009 Development Report and approves the First Quarter appropriation
transfer as specified on the attached schedule.
BE IT FURTHER RESOLVED that the Board of Commissioners approves budget amendments to
respective departmental Fiscal Year 2009 budgets as specified in the attached detailed schedule.
(-NOCE
FINANCE COMMITTEE
Motion carried unanimously on a roll call vote with Gingel
Zack and Coulter absent.
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
1ST QUARTER 2009
DIVISION ACCOUNT #
GOVERNMENTAL FUNDS
General Fund 11
• 1st Qtr
Qct - Dec
2nd at 3rd Qtr 4th Qtr
Jan - Mar Apr - June July - Sept Y.T.D. CUST # FUND 4
540 '0'
550 '0'
560 0'
530 0-
030 0
820 '0'
725 • 0*
440 0-
410 0'
724 0-
720 0.
723 '0-
78:5 '0-
522 0
430 - 0-
495 '0
506
483 0
420 0-
498 •0
493 '0
015 0
900 0'
740 0'
660 '0
680 -
007 • 0'
872
710 '0
775 0-
510 0-
145 0
637 -
650 '0
653 0'
195 - 0-
191 0
445 0-
600 • 0
910 • 0-
730 0 -
00-302020 i
'21020-773630 52/1 •- District Court
0
.
00-302030 '21020-773630 52/2 - Distrld Court .
00-101020 ' 81010-773630 Auditing
00-201020 80000-773630
00-302040 ' 21020-773630 52/3- DisMot Court
00-302050 ' 21020-773530. 52/4 - District Court
00-107080 ' 14000-773630 Animal Control
Clerk - Admin
•
00-201030 - 85010-773630 Clerk - Elections
00-201050 -- 25000-773630 Clerk - Jury Commission
00-20102100 25000-773630 Clerk - Legal Records
00-2010401- 72190-773630 Clerk - Register at Deecis
00-2010205-- 32300-773630 Clerk - Vital Statistics
00-1090101- 71000-773630 Economic Development & Community Affairs
00-10.0401-- 13000-773630 Community Corrections Admin
00-10-0501- F020-773630 Corporalion Counsel
100-30 - 0201-2 2' 110-773630 Courts-Business Division
00-30- 0401-- 2- 220-773630 Courts-FD-Judicial Support
00-30 0403- 2' 100-773630 Courts-FD-Judicial Support-Admin
00-30- 0301- 2' 220-773630 COutts-GJ-FarnRy Support
00-30- 0301.: 2 130-773630 Courts-GJ-Judicial Support
00-30-0101- 2 100-773630 Courts- Judical i Administration
00-10- 0101- 8 000-773630 County Executive
00-10- 0115- 16090-773630 Emergency Response & Prep
00-1020501- 73010-773630 Equalization [Division
00-1020601- 82020-773630 Fiscal Services - Admin
00-1050401- 83010-773630 Human Resources
00-5010303-- 65040-773630 Library Admin
00-1070601- 32030-773630 Medical Examiner
00-1070501-' 74000-773630 MSU Extension - Oakland
00-1090201- 71000-773530 Henning & Economic Development '
00-3040403-' 24010-773630 Probate-Estates/Mental Health Support •
00-4010101-• 22050-773630 Prosecuting Attorney - General Prosecution
00,1030803- 84020-773630 Records Retention
00-1020701- 26020-773630 Reimbursement Division •
00-9010101-- 40364-773630 • Security Camera Project (GF)
00-4030301- 12590-773+330 Sheriff
00-4030601- 10000-773530 Sheriff- CLEWS
00-1030803- 84025-7731330 Support Services .
00_7010 t 01- 66040-773630 Treasurer
00-1070301- 32060-773630 Veterans Services
00-6010101- 55010-773530 %inter Resource Commissioner
Sub-Total Fund 101
$7,751.137
$7,76'1.87
$7,751,87
$7,751.89
$55,30027
50.00
$16,525.00
$3,723.00
51,570.41
$135,612.02
51,622.02
$0.00
5980.50
$17,064A3
$270.00
$2,307.95
$0.00
$2,669.02
50.00
$64,226.00
$4,472.45
$1,161.00
$9 S .50
$100,758.55
$99,730.05
$41,977.93
$2,390.00
$12,847.77
$306.50
$16,659.00
$5,603.02
$12,968.02
$2,867.00
$30,679.00
$192.50
$96,946.70
61,917.41
$6,495.18
5115,720.03
$91a.00
$106,633.07
$992,413.25 $0.00
$7,751.87
$7,751.87
$7,751.87
$7,751.139
555,300,27
$0.00
$15,525.00
$3.723.00
$1,570.41
5135,612.02
51.622.02
$0.00
$980.50
$17,064.43
$270.00
$2,307.05
$0.00
$2,869.02
$0.00
$54,226.00
$4,472.45
$1,151.00
$91.50
$100,758.55
$99,730.05
$41,077.03
52.390.00
$12 847.77
$305.00
616,659.00
$5.603.02
$12,968.02
$2,867.00
$39,679.00
$192.50
$98,948.70
$1,917,41
$6,495.18
$115,72a 03
$918.00
5195.63 a
$0.00 $0.00 5992,413.25
Page 1 of 3 1st Qtr 2009.xis Prepared by; intomation Technology; 2/5/2009
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
1ST QUARTER 2009
DIVISION GUST 0 FUND ACCOUNT 0
1st Qtr
Oct - Dec
2nd Qtr 3rd Ott- 4th Qtr
an - Mar Apr - June J4 - Sent LL.
Health Fund 12211'
840 221 20221-1060201-133150-773630
843 221 20221-1060220-134390-773530 .
Juveple Maintenance Fund12931
665 293 20293-1050501-112090-773630
63600- t080101-152000-631365
GOVERNMENTAL IMAGING
722 101 10100-2010210-125000-773639
512 101 10100-3040403-124010-773639
63600-1080101-152000-630903
10100-9090101-196030-773030
NON-GOVERNMENTAL
DIRECT CHARGES
669
055
056
719
659
507
210
760
757
750
803
751
653
187
770
791
601
546
Health
Health Environmental
Sub-Total Fund 221
Children's Village
Sub-Total Fund 203
DEVELOPMENT FOR GOVERNMENTAL FUND
APPROPRIATION
Clerk Image
Probate-EstatesiMental Health Image
TOTAL GOVERNMENTAL IMAGING
DEVELOPMENT APPROPRIATION
SUS-TOTAL GOVERNMENTAL !IMAGING
DEVELOPMENT APPROPRIATION:
Information Technology Development
TOTAL GOVERNMENT:
CAMS/CVT Data Conversion
CLEMIS
CLEMIS FUND moo
Cled0ROD Automation Fund
Coliaborattve Asset Mgt Sys (CAMS)
Courts-FOG Exp-CS Enforcement
Fire Records Management System
FM-BOG Wet)ca sting
FM-Wk RellJail Mgt/Video Cord`
F M & 0
Health - Bloterrorism Unit
IT - Telephone Comm
D.C. International Airport
OCSD - Jail visitation Project
Parks and Recreation - Administration
Radio Communications E911
Treasurer - DTRF
UASI Grant (ERP)
$22,226.50
tiM,,MAE
$239,806.95
$1,774.00,
$1,774.00
1,2,13,994.20
$14.865.76
S8.944,90
$21810,06
$1,257,804.86
IS1,257_894,86)
$0.00
$47,141.00
$54,831 22
$122.00
$12.925.50
$27,973.30
$17,497.00
$829.02
$0.00
$4,915.41
$8,758.52
$0.00
$4,056.50
$7,693.50
$000
$31,801.00
$871.00
$395,242.50
$220.00
$22,226.50
$217,550_„45
$0.00 $0.00 $0.00 $239,806.95
11.114M1
$0.00 $0.00 $0.00 81.774.00
50.00 $0.00 • Ha) ilijlaAji
814,855.76
$8.944,90
12,22 $23,910.66
$0.00 $0.00 $0.00 $1,257,804.56
$0.0Q $0.00 §0.00 £S1,257.04.8&
$0.00 $0.00 S0,00 ;0.00
$47,141.00
$54,831.22
$122.00
$12,925.50
$27,973.30
$17,497.00
$829.02
$0.00
$4,918.41
$6.758.52
$0.00
$4,056.50
$7,693.50
$0.00
$31,501.00
$871.00
$398,242,50
5220.00
$0.00 $0.00
Prepared 4; ;:olormation Technology; 25/2009 Page 2 of 3 let Qtr 2009.1ds
CUST # FUND ft
656
471
ACCOUNT #
63600-1080101-152000-631302
NON-GOVERNMENTAL IMAGING
,
2nd QV 3rd Qtr 4th Qtr
Mar or - June JILIN - Sept Y.T.D,
$14.9_05,91
Moo so.ps $0.00 $630.766.,38
$17.889.00
aft Prepared bl.; .nlorrnarpcn Technology; 2/512009 ist Utr 2009.xls Page 3013
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
1ST QUARTER 2009
let Qtr
!DIVISION Oct-Dec
Water & Sewer Accounting $14.905.91
SUP-TOTAL. DIRECT CHARGES FOR DEVELOPMENT $630,766.38
Courts-FOC Exp-CS Enforcement Image $17.889.80
83600-1060101-1520U-630903
NON-COUNTY AGENCIES
63600-1030101-152000-635017
TOTAL NON-GOVERNMENTAL IMAGING
DEVELOPMENT APPROPRIATION
TOTAL COUNTY DEVELOPMENT CHARGES
Non-County Agencies
$17,689.82 Slog $0.00 ;0.00 •$17,889.30
$1.906,4E1.04 $0.00 $0.00 min $1,906.43t04,
$1,697.50 $1,697,§o
TOTAL DEVELOPMENT CHARGES $1,903,178.54 $0.00 $0.00 $0.00 $1,908,176.54
ust # GOVERNMENTAL FUNDS
630 ANIMAL CONTROL
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - FIRST QUARTER 2009
24017 SQL Server Supp Animal Control $029.02 •
96628 Web License Registration 43,21125
95682 Dog System 11,260,0
Animal Control-Total $55.300.27
520 AUDITING 95468 Auditing - Customer Support MIN
Auditing - Total $0.00
666 CHILuREN8 ViLLAGc 95665 Childrens Village $1.774.00
Childrons Villa ge - Total 61,774.00
726 CLERK - AMIN 72500 Clerk - Admin $15,525.00
Clerk - Admln • - Total 515,525.00
440 CLERK - ELEC • TIONS 95443 Sections 63.73_AQ
Clerk - Elections - lotal $3.723.00
720 CLERK) REGIVER OF DEEDS 24003 SOL Server Supp - ROD 3.5% $1329.02
36510 GIS Implementation Support-ROD 427.00.
• 36511 ROD Application - NM Support 0,00
95493 Reg Deeds System Maintenance 0,00
95162 Clerk - DW Support 0.00
95163 Clerk - OW Maintenance 388.00
95558 User Support/ROD 0.00
95564 ROD - OW Support 0 00
Clerk/Reg °I Deeds - Total $1,522.02
722 CLERK - ItIAGING 13001 Clerk - eFiling - 50% $0.00
23007 Oracle Support-Clerk Image 5.2% 1,44841
65420 clerk - Image Replace ODD
95158 Clerk - imaging 13 417 35
Clerk - Imaging - Total $14,865.76
410 CL.,1684{ - JURY COMMISSION_ 23008 Oracle Support - Jury Comm - 5.7% $1,446.41
95512 Jury Commission 112.00
Clerk - Jury Commission - Total • $1,670,41
Nilo 1 GI 10 ist 2009.x3s Prepared by in. r.rnatlen Tecbrio1o5f,2/5/2aa9
724 CLERK • LEGAL RECORDS
723 CLERK - VITAL STATITICS
522 COMMUNITY CORRECTIONSADMIN (CO)
430 CORPORATION COUNSEL
015 COUNTY EXECITI1VE
495 CTS-13USINESS DIVISION
506 CTS-FEJ-JUDIC1AL SUPPORT
483gU=11)- .11iLacLLA SAMp_f_t_t -ADM.
420 CT1. - GJ - FAMILY SUPPORT
$829.02
134,7E131,20
50.00
$305.00
1,278.75
0.00
724.20
$0,00
$829.02
2,040.00
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - FIRST QUARTER 2009
24015 SQL Server Supp - Circuit Ct 3.5%
95189 Circuit Court System
Clerk - Legal Records - Toilat
95161 Clerk - Vital Statistics
Clerk - Vita( Statistics - Total
23003 Oracle Support-Comm Corr - 5.2% $1,448.41
24012 SQL Server Supp Community Corr 3-5% 829.02
52200 Comm ComAdmin (County) 14,614.50
52201 Comm Corr-DW Supp 172.50
Community Corrections - Total
95501 Corporation Counsel 1270.00
Corporation Counsel - Total
95654 County Exec - Development $1,100.00
95656 County Executive. Support
County Executive - Total
12002 Circuit Ct-Courts/Crlminal Warehouse 50%
14001 CTS-OW Support/Circuit Ct 75%
15001 CTS-DW taint/Circuit Cl - 75%
23010 Oracle Support-CCT/CTS CTim Whse 2.6%
CTS-BusIness Division - Total
95187 CTS-FD/Admin - Fam Suppt Staff
CTS-1D-Judicial Suport - Total
24009 SQL Serv Supp •- CT S-Jud Sup Mm - 3.5%
95193 CTS-FD-Judicial Suoport-Mm
CTS-FD-Judicial Support-Adm - Total
95195 Cir Crt Admin $0,00
Courts - GJ - Famly Support - Total
$135,612.02
$0.00
517,064.43
$270.00
$1,161.00
$2,307.95
$0.00
$2,869.02
$0.00
, 1st CIU 2009.xis Prepared by: rrnation Technol,ogy; 21512009 Page 2 of 10
en
900 EMgaggN_IDLIGEILEW_C RE 0 PA ON
740 EQU .WATION
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT SUPPORT DETAIL - FIRST QUARTER 200S
• 498 C S- .11-1F U T 95179 CTS-Gen Juris-Judicial Suppl $54.226.00
CTS-Gen Jun i s-Judicial Suppt - Total
493 .9. s 13002 CTS-efiling - 50% $0.00
95174 CTS-cludicial Admin 5.472,45
CTS-Judicial Admin - Total
785 ECONQMIC DEVELOPMENT & COMMUNITY AFFAIRS 36500 GS Implementation Support C&E Dev $980.50
36501 CEO Application - 111W Support 0.09
9-5785 Comm & Eco Devetopmt 2,02
Economic Development & Community Affairs - Total
$54,226.00
54,472.45
$980.50
35545 GIS implementation Support EMS $61.00
35546 ERP Application - I-VW Support 30.50
98990 En iergency Response QPQ
ERP - Total $91.50
$0.00
1,448.41
2,487.04
17,707.00
447.00
6,985.50
0,00
195.00
6,803.25
28,015.25
0.00
3,037.50
216.00
468.00
32.028.60
20001 IDIVIS Support-Equalization - 40%
23012 Oracle Support-Equalization - 5_2%
24005 SQL Server Supp-Equalization - 10.5%
31075 Equal Development
36505 GIS Implementation Support Equalization
36506 Equal Application: 1-1/W Support
36507 Equal LAMS Support/Mtce
36601 Land System Enhancements - Equal (50%)
35701 Land System Maintenance • Equal (50%)
36801 Land System Support Equal (50%)
95559 Llser Support/Equal
95562 Equalization - MA/ Support
95570 Equalization - DW Maintenance
95693 Equal-System Maintenance
95899 19S&A Master Appraisal Sup/Maint
Equalization - Total 5100,758.55
I Si Car 2009.7.1Z Prepared by: rOtraiailoo Technology; 215/2009 Page 3 of 10
660 FISCAL SEEtylcgS ADMIN
840 1-1ULTI- IISIQN
843 HEALTH - ENVIRONMENTAL
880 HUMAN RESOURC_I_S
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - FIRST QUARTER 2005
23001 'Oracle Support - Fiscal Serv - 16,6% $4,345.22
23013 Oracle Support - 1R-Acctg/Budget - 5.2% 1,448.41
24008 SQL Serv Supp HR-Acct - 1.75% 414.52
44021 FS-System/Customer Support 22,534.50
44022 FS-System Maintenance 6,284.00
44023 FS-System Enhancements 901.40
44024 FS-New Development 0.00
44076 BUD-System/Customer Support - 2,196.00
44077 BUD-System Maintenance 0.00
44079 FS - OW Support 1,798.50
44081 FS - OW Maintenance 0.1D0
96001 Human Res - Acct 40% 39,871.00
96003 Human Res - Budget 20% 19,935.50
Fiscal Services Admin Total
20002 IDMS Support - CHAMPS - 20% • $0.00
36525 GIS Implementation Support Health 1.964.00
37025 CHAMPS - P.O.E. 1.218.00
95663 User Support-Health 10,350.00
96842 . Health Admin 8.704.50
Health - Total
23005 Oracle Support - EH Projects 5.2% $1,448.41
24014 SQL Server Suppi - Ehealtts 14% 3,316.04
37002 Environmental 0.00
84200 EH - Projects 148,216.25
84300 Ehealth Program 65,599,75
health-Environmental - Total
23014 Oracle Support-HR/Personnel - 5.2% $1,448.41
24007 SQL Server Suppport-HR/Personnel - 1.75% 414.52
44041 PER-System/Customer Support 244.00
44042 HR-Systems Maintenance 0.00
44044 HR-New Development 0.00
95556 HR User Supt 0.00
96002 Human Res-Personnel 40% 19,871. 00
Human Resources - Total
$99,730.05
$22,226.50
$217,6804.'
$41,977.93
Ptspered by' 11.: 'dm-union Tethealogy; 21542005 Page 4 of 10 1st Cur 2009.xle
03
907 LIEIRAfty - LIBRARY ADMIN
872 MEDICAL EXAMINER
710 NISU EXTENSION - OAL(LANQ
775 ELAND_AIN ECONOMIC DE EL PMENT
12_,Lagssq
$2,390,00
$829,02
12 018,75
$12,847.77
$305,0Q
$305,00
916,171.00
122.00
366.00
618,669.00
512 PROE-ESTATESIMENTL ILIIJH IMAGE 95207 Prob-EstiMnti iitith image
Nob-Est/Ma HMI Image - Total
944A
$8,944.90
$829.132
4,774.00
$5,803.02
$829.02
10,004.00
2,135,00
S12,968.02
$0.00
427.00
2,440,00
$2,867.00
Prepared by: :::farmation Tedinalagy; 21512009 Page S erb0 1st Car 2009.1s
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT SUPPORT DETAIL - FIRST QUARTER 2009
91405 library Board
Library - Library Admin - Total
24002 SQL Server Support - Medical Exam - 3.5%
87202 Medical Examiner - Customer Support
Medical Examiner - Total
96676 MSU Ext Equipment Maintenance
MSU Extension - Oakland - Total
95600 PEDS-CustomerlSystem Support
95786 PEDS - OW Support
95737 PEDS - DW Maintenance
PODS - Total
510 PROB-ESTATE-SlMENIL FILTH SUPPORT
145 PROSECUT9R„- GENERAL PR,OSECUTION
837 RECORDS RETENTIQN
24010 SQL Seni Supp-PCT-EstiMental - 3.5%
92198 Prob-EstiMnd 1-1Ith Support
Prob-Est/Mntl frilth Support - Total
24016 SQL Server Supp - Proescutors 3,5%
95822 Prosecutor/Executive
97001 Prosecutor Data Proc
Prosecutor - TotaI
Rec-Sy stem Maintenance
Rec-System Enhancements
Rec.-New Development
Mail Room
Records Retention - Total
44052
44053
44054
96636
Co
445 SUPPORT SERVICES
600 TREASURER
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - FIRST QUARTER 2009
650 REIMBURSEMENT 95469 Reimbursement Division • $0.00
95470 Reimbursement System 35,165.00
95542 Reimburse User Support 4 514.0
Reimbursement- Total 539,679.00
663 §ECURITY CAMERA PROJECT (GF) 66300 Security Camera Project IGF) S192.60
Security Camera Project (GP) - Total $192.50
195 SHERIFF 12001 GCSD-Courts/Griminal Warehouse $305.00
23009 Grade Suppport - GGSDIGTS Grim Whse .- 2.8% 724,20
97153 Sheriff 81,666.00
97165 Sheriff-DW Support 13,848.50
97166 Sheriff-DW Maintenance 405.00
Sheriff-Total $96,948.70
191 SHERIFF - CI_F_M1S 23015 Oracle Suppport - Sheriff I CLEMIS - 5.2% $1,448.41
96163 Sheriff - GLENS 469,00
Sheriff - GLENIIS - Total 51,917.41
$1.448.41
1,658.02
3.388.75
23002 Oracle Support - Stipp Sent - 5.2%
24011 SQL Server Supp Suppt Services 7%
44500 Support Services
Support Services - Total $6,495.18
23006 Oracle Support - Del Tax - 5.2% $1,448.41
23016 Oracle Support - Treasurer - 10.4% 2,896.82
36515 GIS Implementation Support:1 reasurer 0.00
36516 Treasurer Application - HAN Support 7,855.00
36602 L and System Enhancements - Trcas (50%) 19-5 00
36702 Land System Maintenance - Trees (53% 6,803.25
36802 Land System Support - Trees (50%) 28,015.25
44061 Tula-System/Customer Supporl 3.592,30
44062 Tre-Systern Maintenance 366.00
44063 Tre-System Enhancements 0.00
44064 Ire-New Development 0.00
44480 Tre-(]W Support 11,582.00
44082 Tre-DW Maintenance 30.80
95008 Del Tax On Line 366.00
95303 Del Tax System Maintenance 5,868.00
95561 User Suppori/Del Tax 12,089.50
95615 13S&\ Annual Tex Support 30 512.00
Treasurer - Total $115,720.03
Prepared by:Ir.formation Technology 2i5120D5 Page 6 of 1C •tst Gtr 2099.:d5
730 WATER RESOURCE COMSSIONER
640 5211 (DISTRICT _QURT - (WV(
560 52/2 iSTR CT+KST
560 5213VISTRIcs COURT - ROCHESTER
530 5214 DLSTRICTgi ,A;a0
$829.02
0.00
4, .105.50
62,568.00
20 .439.00
18,291.5Q
$105,633.02
$106.56
0.00
7,645.31
$7,751.87
$106.56
0.00
7,e45.31
$7,751.87
6106.56
0.00
7.645 ,31
$7,751.57
5106.67
0.44
7,645, 32.
$7,751.59
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2009
910 VETERANS SERVICtS 95651 Veterans Customer Support $916.00
Veterans Services - Total $918.40
24008 SQL Server Supp - WRC 3.5%
28007 Water Resource Commissioner
28010 WRC - Customer Support
28011 . Water Resource Commissioner Application
36520 GIS Implementation Support VVRC
36521. WRC Application - HMV Support
Water Resource Commissioner - Total
14402 C TS-DW Support-5211 - 6.25%
16002 CTS-DW Maint 5211 - 0.25%
95527 DC Suprt- 52/1 25% •
5211 District Court - Total
14003 CTS-DVV Support-52/2 6.25%
15043 CTS-DVV Maint 52/2 - 8.25%
95628 DC Suprt- 5212 - 25%
52/2 District Court - Total
14004 CT S-DVV Support-5213 -
15.004 CTS-DW Maint 52/3 - 6.25%
95529 DC Suprt - 52/3 - 25%
52/3 District Court - Total
14005 CTS-DVV Support-52/4 - 6.25%
15005 CTS-DW Maint 52/4- 6.25%
95530 DC Suprt- 52/4 - 25%
5214 District Court -Total
Page 7 at 113 1st Qr 2009.xls Prepared by: ::...ornalLion Technology; 215/2009
• 20003 !DVS Support - 5.8%
23018 Oracle Support - Sheriff CLEWS 5.2%
24004 SQL Server Support - 24.5%
90507 CAD Customer Support
95409 CRISNET/CLEMIS LRM
95430 CLEMIS Maintenance
96431 CLEMIS Enhancements
95432 CLEMIS Ad hoc Reports
98003 CLEWS User Support
CLEMIS - Total
055 CLEFRIS $0.04
1,448.39
5,803.08
0.00
727.00
20,608.75
0.00
0.00
26-244.00
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT SUPPORT DETAIL - FiRsT QUARTER 2009
cu__Aft DIRECT FUNDS
654,831.22
056 CLEM FLU_ND 51500 53500 cLervis Fund $122.00
CI EMIS 63500 Fund - Total $122.00
719 g_EIRKIROO AUTOMATON FLINQ 95719 Register of Deeds Automation 112.95. 50
Clerk/ROD Automation Fund - Total $12,925.50
669 gAMS/cVT,DATA COSAIVERSION 66901 CAMSICVT Data Conversion $47,141.00
CAMS/CVr Data Conversion - Total $47,141,00
659VALAUSWIILASIELI)iglan 65901 Coliabortive Asset Mgt Sys $27,073.33
Collabortive Asset Mgt Sys - Total $27,973.30
471 -F C-EMEWIFORC-IM 92194 CTS-FOC-Exp-CS Enf-Irnage §17,1389,80
CTS-FOC Exp-CS Enf-Image - Total $17,589.80
607 CTS-FOC EXP-CSgNFORCENIENT 92193 CTS-F0c Exp-CD Entorc-Dev 117 497,_00
CTS-FOC Exp-CD Enforc Dev - Total $17.497.00
210 En c KUg_.Q.E1n.N.,LR.._Q.E.TE,GEmETYiVi 21010 Fire Records Mgmt Fund 531 $0.00
24001 SQL Server Support - FRMS 3.5% 829.02
Fire Records Management System - Total
750 r1/1$.0 21001 FM&O $1,365.00
24013 SQL Server Supp - FM&O 829.02
76503 FM&O Development 4,554.50
FM8k0 - Total
$829,02
$6,758,52
Prepbred by: Llormahun Iethnology; 2/5/2009 islUir 2009-As Prep a oi l0
760 FIV1 - BOG WEBCASTING
767 LLIAMELE6SEIJAIL IVPNITNIDEO CONE • 23004 Oracle Support - Oak Video - 5.2%
75700 Far Mgml - Video Arraignments
FM-Wk Rel/JA MgmtiVideo Conf - Total
$1,448.41
,.470.00
36530 01S Implementation Support - Parks $429.00
44066 PRADM-SysterniCustomer Support 4,625.00
44068 P R AD IV -System Enhancements 1,532-50
77010 PRADM-Tectinology Assessment 4,072.50
77100 Yr 1 - Program Management 10,063.00
77110 Yr 1 - Asset Theme Development 1,363,50
77120 Yr 1 - Network Connectivity 6,643_50
77130 Yr 1 - Hardware Refresh 1.437.50
95419 PR ADM-Administration 1.634.50
Parks & Recreation - Total 531,801.00
79101 Radio Communications - E911 $871.01
Radio Communications - E911 - Total $87100
18010 Treasurer's Office System
18050 Drain Apportionment
18060 Michigan Busines$ Tax
Treasurer DTRF - Total
770 PARKS AND RECREA.TION
791n itps2AN,LJNIcA N
601 TREASURER - MAP $287,737.00
47,586.00
62 919 50
$398,242.60
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2009
• 75000 FM - SOC WebcastIng $0.00
FM - BOG Weboaaling - Total $0.00
$4,918.41
$0.00
$35,746.25
$4,056.50
803HE_ Lnml- 0-AURft-BIV.101.1 80130 Health - Blaterrorism Unit $0.00
Health. Blotirrorism Unit - Total
777 1:LE T XXXXX Health. OCHD Communicable Disease Reporting $35.745.25
Health - CCHD Communicable Disease Reporting - Total
751 ST TELEPHOKE Qom 75102 Tel Comm - Customer Support §4.066.5Q
LT. - Telephone Comm - Total
663 0.c, INTERNATIONAL AIRPORT 36540 GIS implementation Support-Aviation $756.50
55301 Airport User Support 715.00
65310 O.C, Aliport - New Development D.222 00
D.C. International Airport-Total 67,693.50
187 OCSD - JAIL VISITATION PROJECT 97187 OCSD - Jail Visitation Project $0.00
OCSD - Jail Visitation Project - Total $0.00
Prepared by: Information Technology; 2/5J2009 Pa we 9 of 10 • ist It 2005dds
12546 UASI Grant (ERP) $220,00
UASI Grant (ERP) - Total $220.00
23011 Gracie Supp - Water & Sewer Accrg - 5.2%
95069 Water & Sewer Aocrg
Water & Sewer Acerg - Total
546 VAS! GRANT IERP)
656 WATER & SEWER ACCTO $1,448.41
13,457.50
$14,905.91
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - FIRST QUARTER 2009
Pape 10 at 10 1st Oir 2009.xls Prepared by: L.farmatian Tethnology; 2/5/Z009
Resolution #09037 March 5, 2009
Moved by Capello supported by Burns the resolutions (with fiscal notes attached) on the Consent Agenda
be adopted (with accompanying reports being accepted)
AYES: Burns, CapeIlo, Coulter, Douglas, Gershenson, Gingell, Gosselin, Greimel, Hatchett,
Jackson, Jacobsen, Long, McGillivray, Middleton, Nash, Potter, Potts, Runestad, Schwartz, Scott,
Woodward, Zack, Bullard. (23)
NAYS: None. (0)
A sufficient majority having voted in favor, the resolutions (with fiscal notes attached) on the Consent
Agenda were adopted (with accompanying reports being accepted).
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, Ruth Johnson, Clerk of the County of Oakland, do hereby certify that the foregoing resolution is a true
and accurate copy of a resolution adopted by the Oakland County Board of Commissioners on March 5,
2009, with the original record thereof now remaining in my office.
In Testimony Whereof, I have hereunto set my hand and affixed the seal of the County of Oakland at
Pontiac, Michigan this 5th day of March, 2009.
ede
Ruth Johnson, County Clerk