HomeMy WebLinkAboutResolutions - 2010.02.02 - 10082MISCELLANEOUS RESOLUTION #10018 February 2, 2010
BY: FINANCE COMMITTEE, TOM mIDDLETON, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY — FIRST QUARTER 2010
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
2010 development charges to be $1,276,894.04 and the imaging development charge to be
$20,993.41 for the General Fund/General Purpose County departments; and
WHEREAS direct charges to Special Revenue and Proprietary fund departments are
$470,300.76, non-governmental imaging development are $15,125.08, and non-county agencies
are $274.50 for the First Quarter 2010; 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 2010 Development Report and approves the First
Quarter appropriation transfer as specified on the attached schedule.
BE IT FURTHER RESOLVED that the respective departmental Fiscal Year 2010 budgets
are to be amended as specified in the attached detail schedule
FINANCE COMMITTEE
FINANCE COMMITTEE
Motion carried unanimously on a roll call vote with Potter absent.
540
550
560
530
630
620
005
725
440
410
724
720
522
430
495
483
498
493
785
740
660
900
680
907
8/2
163
775
510
481
145
637
650
195
191
445
600
910
730
101
101
101
101
0'
o
Cro:
0
0
01
10
110
0
0
0
0
0
0
0
10
10
10
10
10
10
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
1ST QUARTER 2010
CUST# FUND ACCOUNT 0
GOVERNMENTAL FUNDS
gpiteral F undil 01 j
10100-302020°-121020-773630
10100-302030' -121020-773630
10100-302040' -121020-773630
10100-302050' -121020-773630
10100-107080- 14000-773630
10100-101020' -" 81010-773630
10100-501010' -' 80010-7 /3530
10100-201020' -' 80000-773630
0100-201030' -' 85010-773630
0100-201050 25000-773630
0100-2010210-' 25000-773630
0100-2010401-' 72190-773630
0100-1 070401- ' 13000-773630
0100-1010501- 81020-773630
0100-3010201- 21110-773630
0100-3010403- 21100-773530
10100-3010301-121130-773630
10100-3010101-121100-773630
00-1090101-171000-773630
00-1020501-173010-773630
00-1020601-182020-773630
00-1010115-1/5090-773630
00-1050401-183010-773630
00-5010303-165040-773630
00-1070601 -132030-773630
00-4030901-115140.773630
71000473530
24010-773630
21060-773630
22050-773630
84020-773630
26020-773630
12590-773630
10000-773630
84025-773630
86040-71'3830
00-1070301-132050-773630
00-6010101-155010-773630
DIVISION
52/1 - District Court
52/2 - District Court
6213 - District Court
5214 - District Court
Animal Control
Auditing
Board ol Commissioners
Clerk - Admin
Clerk - Elections
Clerk - Jury Commission
Clerk - Legal Records
Clerk - Register of Deeds
Community Corrections Admin
Corporation Counsel
Courts-Business Division
Courts-FD-Judicial SupporlAdmin
Courts-GJ-Judicial Support
Coutts - Judical (Administration
Economic Development & Community Affairs
Equalization Division
Fiscal Seri ices - Admin
Homeland Security
Human Resources
Library Adrnin
Medical Examiner
0080 CLEM1S Forensic Lab 1MS
Planning & Economic Development
Probate-Estates/Mental Health Support
Probate •FD Judicial
Prosecuting Attorney General Prosecution
Records Retention
Reimbursement Division
Sheriff $122,
Sheriff - CLEWS
Support Services
Tieasurer
Veterans Services
Water Resource Commissioner
1st Otr 2010
Oct - Dec
$11,337.92 $11,337.92
$11,337.92 $11,337.92
$11,337.92 $11,337.92
$11,337.74 $11,337.74
$37,971.09 $37,971.09
$0.00 $100
$0.00 $0.00
$23,758.00 $23,758.00
$318.00 $378.00
$2,037.06 $2,087.06
529,639.84 129,639.84
$23,219,54 $26,219.54
$31,098.40 $31,098.40
$399.00 $399.00
$1,226.57 $1,226.57
$1,433.34 $1,438.34
$71,958,00 $71,958.00
$6,770.27 $6,770.27
$4,304.50 $4,304,50
$179,137.39 $179,187.36
5144,800.39 8144,800-39
$5,186.00 $5.16.00
$47,328.91 $47,328.91
$579.50 $579.50
$6,205.84 $6,205.84
$2,028.00 $2,028.00
$108.00 $108.00
$9,795.24 $9,795.24
$000 $0.00
$6,664.34 $6,664.34
$1,220.00 $1,220 00
$10,571.00 110,577.00
125.07 $122,725.07
$3,671.56 $3,671.56
$16,624.03 116,624.03
$162,837.11 8162,837.11
$162.00 $162.00
$55,875.14 $55,876.34
03-1090201--
00-3040403-'
00-3040101-'
00-4010101-'
00-1030803-'
00-1020701-'
30-4030301-'
00-4030601-
00-1030803-'
00-7010100i-•
Piepaied by; Information Technology; 1120/2010 Page 1 of 13 1st Oir 2010 xis
1st Otr 2010
Qct - Dec CUST # FUND # DIVISION ACCOUNT #
INFORMATION FECHNOLOGY
DEVELOPMENT SUMMARY'
1ST QUARTER 2010
840 711
943 221
Health Fund [2'l
20221-1060201-133150-773630
20221-1060220-134390-773630
Sub-Total Fund 101
Health $48,
Health Environmental
Sub-Total Fund 221
$1,058,176.80 $1,058,176.90
241.20 $48241 20
$169.,009.,54 $109,[109.54
$217,250.74 $217..25a74
Juvenile Maintenance Fund F293
665 293 20293-1060501-112090-773830
83600-1080101-152000-631395
GOVERNMENTAL IMAGING
722 101 10100-2010210-125000-773639
512 101 10100-3040403-124010-773639
Children's Village
Sub Total Fund 293
DEVELOPMENT FOR GOVERNMENTAL FUND
APPROPRIATION
Clerk Imago
Probate-Estates/Mental Health Image
$1 ,466.50
$1,466.50
$13,430.87
$1,62.54
1,486.50
$1,486.50
$13,430.87
$7,562.54
)1,276.894.04 $1,275,994.04
63600-1080101-152000-030903
10100-9090101-196030-773530
TAL GOVERNMENTAL IMAGING
DEVELOPMENT APPROPRIATION
SUB-TOTAL GOVERNMENTAL I IMAGING
DEVELOPMENT APPROPRIATION:
information Technology Development
TOTAL GOVERNMENTAL:
$20.99141 $20,993.41
$1,297,381.45 $1,291,887.4-5
a_j_z9( 337 45,) 1$1
97 _7 4
;0.00
Prepared by; Informaloit Tedwology, 1120/2010 lr Qtr 2j10ds Page 2 of 13
DIVISION Y.T.D.
1st Qtr 2010
Oct - Deur. GUST # FUND # ACCOUNT #
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
1ST QUARTER 2010
NON-GOVERNMENTAL
DIRECT CHARGES
669 CA1V1S/CVT Data Conversion $1369350 $13,593.50
055 CLEMIS $17,949.01 $17,949.01
056 C.LEMIS FUND 63500 $'2200 $122.00
095 CLEMIS IBIS Fund $0.00 $0.00
719 ClerkiROD Automation Fund $71,778.70 $71,778.70
659 Collaborative Asset Mgt Sys (CAMS) $84,213.25 $84,213.25
507 Courts-FOC Exp-CS Enforcement $10,109.25 $10,109.25
210 Fire Records Management System $1,438.34 $1,438.34
750 F. M & 0 120,349.84 $20,349.84
753 FM-Jail tv1gmt Replacement $1,220.00 $1,220.00
757 FM-Wk ReWail MgtNideo Conf $99,908.06 $99,908.06
811 Health - BI - CRI Grant $0.00 $0.00
841 Health -1-11141 Grant $35,853.25 $35,853.25
751 IT- Telephone Comm $14,991.25 $14,991.25
653 D C, International Airport $2,197.00 $2,197.00
770 Parks and Recreation - Administration $72,637.25 $72,637.25
663 Security Camera Project (Radio Fund) $1,566.50 $1,566.50
601 Treasurer - DTRF $0.00 $0.00
656 Water & Sewer Accounting $13,019.56 $13,019.56
734 WRC -AMR Suppoit $1,225.00 $1,225.00
728 WRC - C-0 SIDS SewMe1 $3,452.48 $3,452.48
729 WRC - E-F DSD SewMet $4.576.52, $4,576.52
03600-1090101-152000-631302 SUB-TOTAL DIRECT CHARGES FOR DEVELOPMENT $470,300.76 $470,300.76
NON-GOVERNMENTAL IMAGING
Courts-FOC Exp-CS Entorceineni Image $15,125.08 V5 125.08
63600-1080101-15200-630903 TOTAL NON-GOVERNMENTAL IMAGING ;15,125.08 $15,125.08
DEVELOPMENT APPROPRIATION
TOTAL COUNTY DEVELOPMENT CHARGES $1,783,313.29 $1,783,313.23
NON-COUNTY AGENCIES
53600-1080101-152000635017 Non-County Agencies $274,50. $274.50
TOTAL DEVELOPMENT CHARGES $1,783,687.79 $1,783,537.79
471
Prepared by information Technology; 1/20/2010 Page 3 of 13 1st Qtr 2010.As
4+.
c List # GOVERNMENTAL FUNDS
630 ANIMAL CON] ROIL
665 CHILDRENS VILLAGE
725 CLERK - MAW
440 CLERK - ELECTIONS
720 CLERK REGIS1ER OF DEEDS
722 CLERK - IMAGING
410 CLERK -.Nig COMMISSION
i°24 CLERK -LEGAL RECORDS
INFORPAAT1ON TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - FIRST QUARTER 2010
24017 SQL Server Supp - Animal Control $1,438.34
95623 Web License Registration 22,3a9.010
95682 Dog System 14223.75
Anima? Corttruq-Tata/
95665 Children% Village LI 466 50
Childrens Village - Total
72500 Clerk - Admin $23,758.0p
Clerk - Admin - 1 °tat
95443 Elections $373.00
Clerk - Eleclions - total
20004 IDMS Support - Regisler of Deeds $927.20
24003 SQL Server Supp - ROD 3,5% 1,438,34
36510 GIS Implementation Support-ROD 13,208.00
35511 Pon Application HM/ Support 9,610 00
95493 Reg Deeds System Maintenance 976.00
951E2 Clerk-DWSuppuut 041C
95163 Clerk - OW Maintenance 0%00
95558 User Support/ROD 0.00
95564 ROD - DVs/ Support 0.00
Glerkilleg of Lieeds - Total
13001 Clerk - eFihng - 50% $0.00
23007 Oracle Support - Clerk Image 5.2% 2,087.06
65420 Clerk Image Replace 0.01
95158 Clerk- Imaging 11143.1
Clerk - Imaging - Total
$3797109
$1,466.50
$23,758.00
$378.00
$26,219.54
$13,430.87
$2,081.06
0 00
$1,435.34
28 201.1.1
23008 Oracle Support - Jury Comm -
95512 Jury Commission
Clerk Jury Commission - Total
24015 SQL Server Stipp - Circuit Ct 3.5%
95189 Circuit Court System
Clerk - Legal Records - Total
$2,087.06
$29,639.84
l'repareld by: hitorinalkon Technology: 1i20t7010 Pagm 4 ot 13 154 thr AM.) IS
Lu
399 00
$39.00
95501 Corporation Counsel
Corporation. Cplinset - Total
430 CORPORATION COUNSEL
$18300
0.00
0.00
1,043.57
$1,228.57
$1,438.34
a.912
571,958.0Q
$0,00
c..770.27
$678.50
921.50
2 704.50
$1,438.34
$71 ,958.00
$6,770.27
$4,304.50
Prepared by Information Technology; 1.'2.0/2010 Page 6 of 13 1st QV 2010 xls
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - FIRST QUARTER 2010
522 commurcry CORRECTIONS-ADM1N ICO) 23003 Oracle Support-Comm Corr - 5.2%
24012 SQL Server Supp - Community Corr 3.5%
52200 Comm Corr-Admin (County)
52201 Comm Con-DW Supp
Community Collections - Total
$2,387.06
1,438.34
27.573.00
12._02
$31,098.40
495 CTS-BUSINESS DIVISION
483 CTS-FO-JUDICIAL SUPPORT-ADM
498 CTS-EN JURIS-JUDICIAL SUPPT
493 CTS-JUDICIAL ADMIN
785 gcoNomic DEvEk.QpmENT & COMMUNITY AFFAIRS
12002 Circuit Ct-Courtsienminal Warehouse 50%
14001 CTS-DW SupportiCirmit CL - 75%
15001 Cl S-DVV MaintiCircuil et - 75%
23010 Oracle Support-CeTiCTS Crim Whse 2.6%
CTS Business Division - Total
24009 SQL Serv Supp - CTS-Jud Sup Adm - 3.5%
95193 CTS-FD-Judicial Support-Adm
CTS-FD-Judicial Support-Adm - Total
95179 CTS-Gen Juris-Judicial Suppt
CTS-Gen Juns-Judical Suppt - Total
13002 CTS--eFiling - 50%
95174 CTS-Judiclal Admin
CTS-Judicial Admin - Total
36500 GIS Implementation Support C&F Dev
36501 CEO Application - I1Ni Support
95785 Comm & Eco Developmt
Economic Development & Community Affairs - Total
CX,
740 EQUALIZATION
660 FISCAL SERVICES ADMIN
840 HEALTH DIVISION
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER MO
20001 IDMS Support-Equakzation - 40% 51,354.40
23012 Oracle Support-Equalization - 5 2% 2,087.06
24005 SQL Server 3upp-Pqualtration - 10.5% 4,314.77
31075 Equal - Development 65.022.25
35505 GIS Implementation Support Equalization 1,379,00
.15506 Equal Applicatron - HAN Support 20,831.26
36507 Equal LAMS SupportiMtc.e 0.00
36601 Land System Enhancements - (50%) 0.00
36701 Land System Maintenance - Equal (50%) 12,247 88
35801 Land System Support Equal (50%) 20,148.25
35902 BSS.A Orion Twp - Equal (50%) 232.50
95550 User Support/Equal 0.00
95562 Equalization - OW Support 2,998.00
95570 Equalization - OW Maintenance 392.00
95693 Equal-System Maintenance 3,416.00
95699 BSRA Master Appraisal SupiMaint 4464.00
Equalization - Total
23001 Oracle Support - Fiscal Sew - 15.6% $5,261.18
23013 Oracle Support - HR-A.cctg/Budget - 52% 2,087.06
24006 SQl_ Sen., Supp - IIR-Acctg - 1.75% 719.25
44021 FS-Systern/Customer Support 5157000
44022 FS-System Maintenance 3,843.00
44073 FS-Syslem Enhancements 3,843,00
44024 FS-New Developmerq 0.00
44075 BUD •System/Customer Support 0 00
44077 BUD-System TVIaintenar ice 0.00
44079 FS - DW Support 0.00
44051 FS - OW Maintenance 0.00
96001 Human Res - Acct 40% 44,278.60
96003 Human Res - Budget 20u,i, 22,139,30
Fiscal Services Admin Total
70002 IOMS Support - CHAMPS - 20% $927.20
36b.e5 GlS Implementation SUIpport I lealth 270.00
37025 CHAMPS - P.O.P. 108.00
95563 User Support-Health 7,165.25
96842 Health Admin ,39_,769.75
Health - Total
$179,187:36
S144,800,39
$48,24120
epar ed Ey hlormalion 1 echnology. 1.20/21113 P'acie 5 or 13 1st 01.1 21t3 kts
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2010
843 )1EALTH - ENVIRONMENTAL 23005 Oracle Support - EH Protects - 5.2% $2,037.06
24014 SQL Server Suppt - Ehealth 14% 5,752.83
37002 Environmental 0.00
84200 EH - Projects 160,92E1.60
84300 Ehealth Program 341.00
Health-Environmental - Total
900 HOMELAND SECURITY 36545 GIS Implementation Support Homeland Security $91.50
36546 Homeland Security Application - 111W Support 214 50
95479 Homeland Security Customer Support 4,880.00
98990 Homeland Security 0.00
ERR - Total
680 HUMAN RESOURCES 23014 Oracle Support-I-IR/Personnel - 5.2% $2,087.06
24007 SQL Server Suppport-HR/Personnel - 1 75% 719.25
44041 PER-System/Customer Support 0.00
44042 FIR-Systems Maintenance 0.00
44044 HR-New Development 0.00
95555 HR User Supt 0.00
96002 Human Res-Personnel 40% 44,522.60
Human Resources - Total
907 LIBRARY - LIBRARY ADMff 91405 Library Boatd $579.50
Library - Library Admin - Total
872 MEDICAL, EXAMINER 24092 SQL Server Support - Medical Exam - 3.5% $1,438.34
81202 Medical Examine' - Customer Support 4,767,50
Medical Examiner - Total
r75 PLANNING & ECONOMIC DEVELOPMENT 95600 PEDS-Customerf%stern Support S10a.00
95786 REDS - DVV Support 0.00
95787 REDS - my Maintenance 0.00
REDS - Total
512 PROB-ESTATESIMENTL HLTH IMAGE 95207 P.rob-EstVInt11411h Image $7.562,4
Prob-EstiMntl Hlth Image - Total
510 PROD-EST AT ES/MeNTL HLTH SUPPORT 24010 SQL Serv Supp-PCT-Cst/MenIal - 3.5% $1,433 34
92198 Proh-Eq1Nntl Hlth Support
Prob-EstfMntl Hlth Support Totai
$169.00c1 54
$5,186.00
$47,328.91
$579.50
$5,205.84
5108.00
$7,562.54
$9,795.24
rage of 13 1s1 C211 ',010 xis epered by hnlormalion 1 ochnorogy. vaoi.zoia
145 PROSECUTOR - GENERAL PROSECUTION
637 RECORDS RVE1TIOts1
650 REIMBURSEMENT
195 SHERIFF
191 SHERIFF -CLEMIS
445 SUPPORT SERVICE,,
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT ! SUPPORT DETAIL - FIRST QUARTER MD
24056 SQL Seer Supp - Prcesculors 3.5% $1,438.34
95622 Pr CICecuto r/Executive 4,280 00
97001 Prosecutor Data Proc 946.00
Prosecutor - Total
44052 f-tec-Systern fvfaintenance $0.00
44053 Rec-Systern Enhancements 1220.00
44054 Rec-New Development 0.00
95636 Mail Room
Records Retention - Total
95469 Reimbursement Division $0.00
95470 Reimbursement System 9:235.00
95542 Reimburse User Support 1 342.00
Reimbursement - Total
12001 OCSD-Courts,+Criminal Warehouse S183.00
23009 Oracle Suppport - OCSD/CTS Crim VVhse - 2.6% 1,04357
97163 Sheriff 109,638.00
97165 Sheriff-OW Support 11,860.50
97166 Sheriff-MN Maintenance 0,00
Sheriff - Total
23015 Oracle Su ppport - Sheriff! CLEMIS - 5.2% $2,087.06
96163 Sheriff CLERCS 1,564.50
Sheriff - CLEMIS Total
23002 Oracle Support - Supp Serv - 6.2% S2.087.06
74011 SQL Server Supp - Suppt Services 7% 2,876.47
44600 Support Services 11.650 50
Support Services - Total
$6,664.34
$1,220.00
$10,577.00
$122,725.07
$3,671.56
$16,624.03
Pr,valed by . Inrormalion 1 ethnology; 1.z012010 Page S 01 13 1st U1P 2010 )15
600 TREASURER
910 VETERANS scrivices
730 WATER RESOURCE COMMISSIONER
540 5211 DISTRICT COURT - NOVI
550 5212 DISTRICT COURT - CLARIKS1ON
INFORMATION TECHNOLOGY RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2010
23006 Oracle Support - Del lax - 5.2% $2,08 /06
73016 Oracle Support - Treasurer - 104% 4,174.18
36515 GIS Implementation Support-Treasurer 0.00
35516 Treasurer Application - HNV Support 15,799.00
35602 Land System Enhancements - Trees (50%) 0.00
36702 Land System Maintenance - Trees r,50%) 12,247.87
36802 Land System Support - 1 reas (50%) 20,148,25
44061 Ire-System/Customer Support 18,440.00
44062 I re-System Maintenance 713.50
44053 Tre-System Enhancements 0.00
44054 Tre-New Development 11,228.00
44080 Tie-OW Support 15,303.00
44082 Tre-DW Maintenance 0.04
95008 Del Tax On Line 510.00
95303 Del Tax System Maintenance 15,255.50
96561 User Support/Del Tax 11,232.00
95615 B,S8A Annual lax Support 32,597.75
Treasurer - Total
95651 Veterans Customer Suipport $152.0Q
Veterans Services - Total
24008 SQL Server Supp WRC 3.5% $1,438.34
28007 Water Resource Commissioner 0.00
28010 WRC - Customer Support 15,260 50
28011 Water Resource Commissioner Apprication 12,902.50
36520 GIS Implementation Supparl WRC 18,652.00
36621 VVR.0 Application - 111W Support 6,623.00
Water Resource Commissioner - Total
14002 C1S-DVV Support-5211 - 6,25% $0.00
15002 CTS-DVV Maint 5711 - 6.25% 0.00
95527 DC Suprt- 52/1 - 25% 11 337.92
52/1 District Court - Total
14003 C1S-D1/V Support-52/2 - 6.25% 50.00
1 5003 CTS OW Mint 5212 - 6.25% 0.00
95528 DC Supitt- 52/2 - 25% 11,337.92
5212 District Court - lotal
$162,537.11
$162.00
$55,876.34
$11,337.92
$11,337.92
Pagn 0 o1 13 1st Ott 2.010 )gs Prepared by larc.rmation 'T echnology: 1.'2072010
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - FIRST QUARTER 2010
560 52/3 DISTRICT COURT - ROCHESTER
530 52/4 DISTRICT =JET - TROY
14004 CTS-DVV Suppuirt-52/3 - 6.25%
15004 CTS-DVV Mint 5213 -
95529 DC &wit - 5713 - 25%
52/3 Distlict Court - Total
14005 CFS-L)Vrf Support-5214 - 6.25%
15005 CTS-DW holant 5214 - 6.25%
95530 DC Suprt- 52/4 - 25%
5214 District Cowl - Total
$1,00
0.00
11,,N.7.92
$0.00
0.00
11 337.74
t1,337.92
$11,337,74
Pi opured by illIDImattan leebuskIgy, I:70/2-010 rags 10 01 13 1st t.-ttr 201U..xls
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - FIRST QUARTER 2010
Cu,t ft DIRECT FUNDS
055 CLEMIS 20003 IDMS Support - 56% $927 20
23018 Oracle Support - Sheriff CLEIVIIS 5.2% 2,087.16
24004 SQL Server Support - 24.5% 10,067.65
90507 CAD Cuslomer Sli pport 0.00
95409 CRISNET/CLEMIS LRM 0.00
95430 CIE MIS Maintenance 3,417.00
95431 CLEMIS Enhancements 0.00
95482 CLEMIS Adhoc Reports 0.00
98003 CLEMIS User Support 1 .450.00
CLEMIS - Total
056 CLEMIS FUND 63500 63500 CLEMIS Fund 5122.00
CLE MIS 53500 Fund - Total
719 CLERK/RQD AUTOMATION FUND 95719 Register of Deeds Automation $71,778.70
Clerk/ROD Automation Fund - Total
659 CAMS/CVT DATA CO_NVERSION 66901 CAIVIS/CVT Data Conversion $13,693.50
CAMSXVT Data Conversion - -row
659 COLLABORATIVE ASSET MGT SYS 65901 Coliabortive Asset Mgt Sys $84,213.25
Collabortive Asset Mgt Sys - Total
471 CTS-FOC-EXP-CS ENFORC-IMAGE 92194 Cl S-FOC-Exp-CS Ent-Image $15,125.08
CIS-FOC Exp-CS Enf-Image - Total
507 CTS-FOC EXP-Cp ENFORCEMENT 92193 CI S-FOG Exp-CD Enforc-Dev $10,109.25
CTS-FOC Exp-CD Enforc-Dev - Total
210 FIRE RECORDS MANAGEMENT SYSTEM 21010 Fire Records Mgmt Fund 531 $0,00
24001 SQL Server Support - FRMS 3.5% 1,438.34
Fire Records Management System - Total
750 FMSO 21001 FM&O $4,026.50
24013 SQL Server Supp - FM&O 1 438 34
75503 F M&O Development 14885,00
Frvmo - Total
$17,949.01
$122.00
$71,77810
S13,693.50
$84,213.25
$15,125.08
$10,109.25
$1,438.34
$20,349.84
Prepared by- Information Technology l70/2010 Page 11 of 13 1St Otr2010.xIS
758 FM-JAIL MGMT REPLACEMENT
757 FM-WK RELEASE:JAIL MGMT/VIDEO CONF
663 SECURITY CAMLHA PRQJECT (RADIO FUND1
656 WATER & SP.WER ACCT`
$1,229.00
$99,908.06
$35,853.25
$14,991.25
$2,197.00
$2,028.00
572.6372.5
$1,566.50
$13,019.56
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - FIRST QUARTER 2010
841 HEALTH - H1N1 GRANT
751 IT TEITEPHONE COMM
653 D.C. INTERNATIONAL AIRF'OH1 .
163 OCSO - CLEWS FORENSIC LAB IMS
770 PARKS AND RECftATION
75800 FM•Jail Mgmt Replacement E1,220.06
FM-Jail Mgmt Replacement - Total
23004 Oracle Suppoit - Oak Video - 5.2% 52.087.05
75700 Fac: Mgmt - Video Arraignments 97,321,00
rm-vvk Relt,Jarl Mgmt./Vhieo Cent - Total
94100 Health - H1N1 Grant $35,653.25
Health Hi N1 Giant - Total
75102 Tel Comm - Customer Support $14,991.25
I.T. - T MRphone Comm - Total
36540 GIS Implementation Supped-Aviation U14.50
65301 Airport User Support 335.50
65310 O.C.Airpori - New Development 1,647.0t)
D.C. International Airport - Total
16300 OCSO CIEMIS Forensic Lab IIVIS $2,028.00
OCSO CLEMIS Forensic Lab IMS - Total
36530 GIS Implementation Support - Parks $1.614 50
44066 PRADM-SystemplCustomer Support 5.673 .50
44068 PRADM-System Fnhancerrents 0.00
77010 PRADM-Technology Assessment LW
77100 Yr 1 - Program Management 3./96.75
77110 Yr I - Asset Theme Development 15,646.25
77120 Yr 1 - Network Connectivity 9,962.50
77130 Yr 1 Hardware Refresh 0.00
77140 Yr 1 - Point of Sale. System 17,078.00
77200 Yr 2 - Progi am Management 4..118 75
77230 Yr 2 - Customer Info Mgrnt Implementation 1.560.00
95419 PRADM-Admrnistration 1 ,197.Q0
Parks & Recroathon Total
66300 Security Carnern Project 1,Radio Fund) $1,506 50
Security Camera Project (Radio Fund) - -fetal
23011 Oracle Supp Water & Sewer Accig - 5.2% $2,087.96
95669 Water & Sewer Ar,:erg 10,9? .50
Water & Sewer Ar:ct'g - Total
'repaid by lirlouriatian le,..twolagy; 112012010 Page 12 or13 isr. Oil 2010.x:Is
U.)
134 MC - AMR SUPPORT
12S - C-0 SOS SWME'r
729 VVRC E-F SDS SEWMET
$1 .225.00
$3,452.48
$4,676.52
$1,225.00
$3,452A8
$&57S52
Prepared IDy 'illumination 1 echnology; 12012010 1st Otr 2010.xls Page, 13 of 13
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2010
73401 VVRC -AMR Support
VVRC - AMR Support - Total
7Z201 MARS Enhancemenls - 43%
VVRC - C-0 SDS SewMet - Total
72202 MAHS Enhancements - $7%
WRC - E-F L)S0 SewMet - Total
Resolution #10018 February 2, 2010
Moved by Capello supported by Woodward the resolutions (with fiscal notes attached) on the Consent
Agenda be adopted (with accompanying repoil buiny dtxupted).
AYES: Capello, Coleman, Coulter, Douglas, Gershenson, Gingell, Gosselin, Greimel, Hatchett,
Jackson, Jacobsen, Long, McGillivray. Middleton, Nash. Potts, Runestad, Schwartz, Scott, Taub,
Woodward, Zack, Bullard, Burns. (24)
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).
Y APPROVE DE FOREGONG RESI.IJOON
--47
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
February 2, 2010, 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 2nd day of February, 2010.
I z / /
eat
Ruth Johnson, County Clerk