HomeMy WebLinkAboutResolutions - 2010.05.05 - 10231401 PLO.
MISCELLANEOUS RESOLUTION #10090 May 5, 2010
BY: FINANCE COMMITTEE, TOM TVIIDDLETON, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY — SECOND 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 Second
Quarter 2010 development charges to be S1,218,815.40 and the imaging development charge to
be 517,890.25 for the General Fund/General Purpose County departments; and
WHEREAS direct charges to Special Revenue and Proprietary fund departments are
$489,319.75, non-governmental imaging development are $14,312.20, and non-county agencies
are $2,681.00 for the Second Quarter 2010; anc
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 Second Qua-ter 2010 Development Report and approves the
Second 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 speuiried in the attached detail schedule
p114NCE COMMITTEE
te4
FINANCE COMMITTEE
Motion carried unanimously on a roll call vote.
let Qtr
Uct - Dec NI, T.D. GUST* FUND*
2nd Qtr
Jan-Mat ACCOUNT Si
GOVERNMENTAL FUNDS
1NFORMATiON TECHNOLOGY
DEVELOPMENT SUMMARY
2ND QUARTER 2010
DIVISION
ieral Fund [1011
00-302020 -121020-773630
00-302030' -121020-773630
00-302040' -121020-773630
00-302050' -121020-773630
00-107080' -114000-773630
00-201020' -180000-773630
00-201030' -185010-773630
00-201050' -125000-773630
0100-2010210-'25000-773630
0100-2010401-4 72190-773830
0100-2010205-' 32300-773630
0100-1070401-' 13000-773630
0100-1010501-4 81020-773630
0100-3010201-' 21110-773630
0100-3010403-' 21100-773630
0100-3010301-' 21130-773630
0100-3010301-' 21180-773630
0100-3010101-121100-773630
0100-1090101-4
0100-1020501-4
0100-1020801-'
0100-1010115...
0100-1050401-'
0100-5010303-'
00-1079801-'
00-4030901..
O0-1090201.'
00-3040403-
00-4010101-'
00-1020401...
00-1030803-184020-773530
00-1020701-126020-773630
O0.4030301-112590-773630
00-4030501-110000-773630
00-1030803-184025-773830
00-7010101-186040-713630
004 070301-132050-773530
00-6010101-155010-773630
Ge
()0-1:
0.
0.
0.
0'
0'
0'
13
71000-773530
73010-773630
82020-773630
15090-773630
83010-773630
65040-773630
32030-773630
15140-773630
71000-773630
24010-773630
22050-773630
82090-773630
Page 1 of 3 IT Quarterly Development Bitting 2nd Qtr 2010.xts Prepared by; Intorrnation 1 echnology; 4/20/2010
540 101
550 101
560 101
530 101
630 101
725 101
440 101
410 101
724 101
720 0
723 0.
522 0 .
430 0.
495 0.
483 0'
498 0'
502 0'
493 0'
785 0'
740 0'
560 0'
900 0'
680 0'
907 0
372 0.
163 0'
775 0'
510 01
145 0'
690 0'
637
650
195 01
191 01
445 01
500 101
910 101
730 101
52/1 - District Court
52/2 - District Court
52/3 - District Court
5214 - District Court
Animal Control
Clerk - Adn-iin
Clerk - Elecliions
Clerk - Jury Commission
Clerk - Legal Records
Clerk - Register of Deeds
Clerk - Vital Statistics
Community Corrections Admin
Corporation Counsel
Courts-Business Division
Courts-FD-Judicial Support-Admin
Courts-Mt-Judicial Support
Courts-G,I-Jury Operations
Courts - Judical / Administration
Economic Development & Community Affairs
Equalization Division
Fiscal Services - Adrnin
Homeland Security
Human Resources
Library Admin
Medical Examiner
OCSO CLEWS Forensic Lab IMS
Planning & Economic Development
Pr .that e-EslalesiMerital Health Support
Prosecuting Attorney - General Prosecution
Purchasing
Records Retention
Reimbursement Division
Sheriff
Sheriff - CLEMIS
Support Services
Treasurer
Veterans Services
Water Resource Commissioner
$11,337.92 $12,550.47 $23,888.34
$11,337.92 $12,550.42 $23,1388.34
$11,331.92 $12,550.42 523,886.34
$11,337.74 $12,550.24 $23,887.98
$37,971.09 $42,463.81 $80,434.90
$23,758.00 $2,402.00 526,160,00.
$378.00 $230.00 $608,00
$2,087.05 $0.00 $2,037.06
$29,639.84 $29,706.50 $59,346.34
$25,219.54 $22,213.51 $48,493.05
$0.00 $3,381.31 $3,381.31
$31,098.40 $19,542.15 $50,640.55
$399.00 $881.00 51 ,250.00
$1,226.57 $424.42 $4,650.99
$1,438.34 $1,011.31 $2449.65
$71,958.00 $886,378.00 $158,336.00
$0.00 $848.84 $848.84
$6,770.27 $5,285.05 $12,056.32
$4,304.50 $5,805.50 $10,111.00
$179,487.36 $176,959.93 $356,147.29
$444,800.39 $92,015.32 $236,815.71
55,186.00 $427.00 $5,613.00
547,328.91 543,126.75 $90,455.67
$579.50 $610.00 $1,189.50
$6,205.84 $4,959.31 $11,165.15
$2,028.00 $1,014.00 $3,042.00
$108.00 $0.00 $108.00
$9,795.24 $27,355.31 $37,150.55
$6,664.34 620,800.31 $27,464.65
$0.00 $6,021.00 $6,021.00
$1,220.00 $4,752.00 $5,972.00
$10,577.00 $6,004.00 $16,681.00
$122,725.07 $103,215 92 $225,940,99
$3,671.56 $1,186.84 $4,83B 40
$16,624,03 $11,677.22 $23,301.25
$162,837.11 $144,608.99 $307,445.10
$162.00 $0.00 $152.00
$55.876,34 $593392.11 $115.768.85
-1
Y.T.D.
2nd Qtr
Jan - Mar
1st Qtr
Oct Dec DIVISION OUST # FUND # ACCOUNT It
$1,058,176.80 5975,443.12 $2,033,619.92
$48,241.20 $47,579.20
$169,009.54 $189.97198
$217,250.74 $237,560.28
$95,820.40
13Q8,980.62
$454,801.02
$1.465.50
$1,456.50
IEBn.S_Q
$5,822.00
$7.288.50
$7,288.50
$1275.894,04 $1.216.a15.40 $2.496,709.44
$13,430.87
$7,562.54
$10,734.15
$7.156.10
$24,165)02
$14,718M
620193,41 $17.690.25. S38,883.68
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
2ND QUARTER 2010
Health Fund12211
840 221 20221-1060201-133150-773630
843 221 20721-1060220-134390-773630
Juvenile Maintenance Fund EMI
555 293 20293-1060501-112090-773630
63600-1080101-152000-631355
GOVERNMENTAL IMAGING
722 101 10100-2010210-125000-773639
512 101 10100-3040403-124010-773659
63600-1080101-152000-630903
10100-90901011-196030-773630
Sub-Total Fund 101
Health
Health Environmental
Sub-Total Fund 221
Children's Village
Sub-Total Fund 293
DEVELOPMENT FOR GOVERNMENTAL FUND
APPROPRIATION
Verk Image
Probate-Estates/Mental I lealth Image
TOTAL GOVERNMENTAL IMAGING
DEVELOPMENT APPROPRIATION
SUB-TOTAL GOVERNMENTAL IMAGING
DEVELOPMENT APPROPRIATION:
Information Technology Development
TOTAL GOVERNMENTAL:
$1,297887.45 $1,236,705.65 $2,534,59310
($1297,887.45) 41,236.705.651 ($2,534,593.101
$lut moo span
Page 2 of 3 IT Quarterly Development Billing 2nd Qtr Prepared by; Information Technology: 4/20(2010
NON-GOVERNMENTAL
DIRECT CHARGES
63600-1080101-152000-831302
669
652
055
056
719
659
507
210
750
758
757
841
751
653
770
763
663
656
736
734
728
729
CUST FUND # ACCOUNT #
1st (Tr
Oct- Dec
2nd Qtr
Jan - NI4kr Y..T,f).
$13,693.50 512,574.60 $26,268.00
$0.00 $6,695,50 $6,695.50
$17,949.01 516,814.7.0 $34,763.21
$122.00 $244.00 5366.00
$71,778.70 $47,607.00 $119,385.70
$84,213.25 $141,04S 5275,268.25
510,109.25 $8,152,00 51. 8_261.25
$1,438.34 $1,011.31 $7,449.65
$20,349.84 $42,701..31 $63,051.15
$1,220.00 $62.50 $1,282.50
$99,908.06 $50,505.84 $150,413.90
$35,853.25 $3,751.00 $39,604.25
$14,991.25 $1,280.00 $16,251.25
$2,197.00 $4,422.50 $6,619.50
$72,637.26 $124,023.75 $196,661.00
$0.00 $8600 $86.00
$1,506.50 $494,00 $2,060,54
T13,019.55 $15,038.34 $29,057,90
$0.00 59,354.50 $9,354.54
$1,225.00 $1,735.50 $2,960.50
$3,452.49 $318.63 $3,771.11
4.516.52 $42.3? $4,998.89
$470,300.78 $489,310.75 5959,820.51
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
2ND QUARTER 2010
DIVISION
CAMS/CVT Data Conversion
CAMS/FMO (IT Implementation)
CLEMIS
CLEMIS FUND 63500
Clerk/ROD Automation Fund
Collaborative Asset Mgt Sys (CAMS)
Courts-Fr'. Exp-CS b emerrt
Fire Records Management System
F fvf & 0
FM-Jail Mgmt Replacement
FM-Wk R&/Jail MgtNideo Conf
Health -• H1N1 Grant
IT - Telephone Comm
D.C. international Airport
Parks and Recreation - Administration
P&R Lyon Oaks Golf Course
Security Camera Protect (Radio Fund)
Water & Sewer Accounting
WinCan Central Storage Solution
WRC - AMR Support
WRC - C-0 SOS SewMet
WRC - E-P 050 SewMet
SUB-TOTAL DIRECT CHARGES FOR DEVELOPMENT
471
NON-GOVERNMENTAL IMAGING
Courts FOC Exp-CS Enforcement Image 115,1408 $.-nt 21.222
63600-1080101-15200-630903 TOTAL NON-GOVERNMENTAL IMAGING
DEVELOPMENT APPROPRIATION
$15.175.08 ;14,312,20 $29,437.28
TOTAL COUNTY DEVELOPMENT CHARGES $1,783.313,29 }j7.6 $3 §23.650.89
NON-COUNTY AGENCIES
63600-1484101-152000-635017 Non-County Agencies
TOTAL DEVELOPMENT CHARGES
$274.50 52.681.00 52.955.50
51,783,587.79 51,743,018.60 $3,526,608.39
Prepared by; Information Technology; 4/20/2010 Pao 3 of 3 IT Cuarlerly Devpiopment Billing 2,iirJ Qir 7010,xls
724 CLERK -LEGAL RECORDS
723 CLERK - VITAL STATISTICS
51,011.31
17,277.00
24.175,50
)5.822.00
$2.402.00
$230.00
$1,964.20
1,011.31
(8.405.00)
28,849.00
Di4.0G
$0,00
0.00
0.00
10.734.15
$29.706,50
51 ,01 11 31
g,370.0(1
$42,453.81
$5,822.00
$2,402.00
$230.00
$22,273.51
$10,734.15
$20,796,50
83,381.31
INFORMATION TECHNOLOGY RESERVE FUND
DEVELOPMENT /SUPPORT DETAIL - SECOND QUARTER 2010
Oust GOVERNMENTAL FUND_S
665 CHILD RENS wLAgE
725 CLERK - ADM1N
440 CLERK -.§LECTKINA
720 Ch-ERK / REGISTER OF DEEDS
630 ANIMAL CONTROL
722 CLEW • IMAGIIIG
24017 501_ Server Sunni - Animal Control
95628 Web License Registration
95582 Dog System
Animal Control-Total
95665 Childrens Village
Chilth ens Village - Total
72500 Clerk - Admin
Clerk - Admin Total
96443 Elections
Clerk - Elections - Total
20004 IDIAS Support - Register of Deeds
24003 SQL Server Supp - ROD 3.5%
36510 GIS Implementation Support-ROD
38511 ROD Application - NW Support
95498 Clerk/Reg - ROD
Clerk/Rag of Deeds - Total
13001 Clerk - eFiling - 50%
23007 Oracle Support - Clerk Image 5.2%
66420 Cleik - Image Replace
95158 Clerk - imaging
Clerk - Imaging - Total
95189 Circuit Court System
Clerk Legal Records - Total
24015 SQL Server Supp - Vital Stats 3.5%
95161 Clerk.Reg - Vital Statistics
Clerk - Vital Statistics - Total
Preparied by Infonrnadon Tischncology, 4/2017010 Page 1 of #0 IT Quarterry Deveiopment BiNng 2nd Otr 2010.x4
1-11
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2010
522 COMMUNITY CQRBECTIONSIkOMIN (COI
430 CORPORATION COUNSEL
495 c_T_S-BUS/NESS DIVISION
483 SUPPRT-AQfiI
498 CTS-GEN JURIS-NOIC/AL SUPPT
493 CTS-JUDIcittl. ADMIN
502 eTS-0.1-JURY OPERATION1
785 MI %EcaMQ_ci NT & CQMMUr1ITYAFFAIS
23003 Oracle Support-Comm Corr - 5.2%
24012 SQL Server Supp - Community Corr 3.6%
52200 Comm Corr-Admin (County)
52201 Comm Corr-OW Supp
Community Corrections. - Total
95501 Corporation Counsel
Corporation Counsel - Total
12002 Circuit et-Courts/Criminal Warehouse 50%
14001 CTS-DW Support/Circuit et - 75%
15001 CTS-DVV Maint/Circuit Ct 75%
23010 Oracle Support-CCT/CIS Grim Whse 2.6%
CTS-Business Division.. Total
24009 SQL Serv Stipp - CTS-Jud Sup Adrn - 3.5%
95193 CTS-FD-Judicial Support-Adm
CTS-FD-Judiclal Support-Adrn - Total
95179 CTS-Gen Juris-Judicial Suppt
CIS-Gen Juris-Judicial Suppt - Total
CTS-e Filing - 50%
CTS-Juidicial AdmM
CIS-Judicial Adrnin - -total
23008 Oracle Support-CTS-GJ-Jury Operations
CTS-GJ-Jury Operations - Total
35500 015 Implementation Support C&E Dev
36501 CEO Application -1-1,W Support
95785 Comm & Eco Developmt
Economic Development & Community Affairs - I otal
$848.84
1,011.31
17,682.00
9,122
$19,542.15
1581.00
$881.00
$0.00
0.00
00
424.42
$424.42
$/ ,011.31
$1,011.31
$86.378.00
$86,378.00
$0.00
5,286.05
$5,286.05
$848,84
$848,84
$584.00
370-.50
4,852.00
85,806.50
13002
95174
Prepared Information Technology'. 4/20/2010 Frew 20(10 fr Quarloriy DeVaPpment ErliNna 2nd Orr 2010.Ais
740 gq1.1ALIWION
660 FISCAL FEMMES ADMIN
840 'MALI H DIVISION
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2010
20001 IDMS Support-Equalization - 40% $3,928.40
23012 Oracle Support-Equalization - 5.2% 848.84
24005 SL Server Supp-Equalization - 10.5% 3,033.69
31075 Equal - Development 44,388.25
36505 GIS Implementation Support Equalization 2,580.00
36506 Equal Application - HM! Support 23,055.50
36507 Equal LAMS Support/Mtce 0.00
36601 Land System Enhancements - Equal (50%) 0.00
36704 Land System Maintenance - Equal (60%) 11,354.75
36801 Land System Support - Equal (50%) 30.730.00
36902 SSAA Otion Twp - Equal (0%) 3,667.50
95559 User Support/Equal 0.00
95562 Equalization - OW Support 4,435•00
955/0 Equalization - DW Maintenance 108.00
96693 Equal-System Maintenance 793.00
95669 i3S8A Master Appraisal' Supfiv/aint 48.05740
Equalization - Total
23001 Oracle Support - Fiscal Serv - 15.6% 62,546.46
23013 Oracle Support - HR-AcctgiBudget- 5.2% 848.84
24006 SQL Senr Supp -• HR-Acctg - 1.75% 505 72
44021 FS-System/Customer Support 24,663.00
44022 FS-System Maintenance 244.00
44023 FS-System Enhancements 183.00
44024 FS-New Development 0.00
44076 BUD-SystemiCustomer Support 0.00
44077 BUD-System Maintenance 0.00
44079 rs IIVV Support 0.00
44081 FS - DVV Maintenance 0.00
06001 Ftuman Res - Acct 40% 42,016.20
96003 Human Res - Budget 20% 21.008A0
Fiscal Services Admin - Total
20002 IDMS Support - CHAMPS - 20% 31,964.20
36525 GIS Implementation Support Health 0.00
31025 CHAMPS - P.O.P. 208.00
95563 User Support-Health 10,619.00
96842 Health Actrnin 34 6_98 00
Health - T dal
$176,959.93
$92,015.3,
$47,579.20
Page 3 of 10 0 OtawlerFy Detedopmerit Bang 2nd Qir 2010.xle Prepared ay: Inlormallon Techmaogy, 4120/2010
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - SECOND QUARTER 2010
843 HEALTH - CNVIRONIVIENTAL 23005 Oracle Support - EH Projects - 5.2% 5848.84
24014 SQL Server Suppl - Ehealth 14% 4,04414
37002 Environmental 0.00
84200 EH-Projects 181,486,50
8430U Eheatth Program 3.591_00
Health Environmental - Total
900 HOMELAND SICLERITY 36545 GIS implementation Support Homeland Secufity $91.50
36546 Homeland Security Application - HIW Support 335.50
95479 Homeland Security Customer Support 0.00
98990 Hometand Security Nj_10
Homeland Security - Total
680 HUMAN RESOURCES 23014 Oracle Support-HR/Personnel - 5.2% $648.84
24007 SQL Server Support-HR/Personnel - 1.75% 505.72
44041 PER-System/Customer Support 0.00
44042 HR-Systems Maintenance 0.00
44044 HR-New Development 0.00
95556 FIR User Supt 0.00
96002 Human Res-Personnel 40% 41.77220
Human Resources - Total
90T LIBRARY - LIBRARY ADMIN 91405 Library Board 1610 00
Library - Library Adrnin - Total
872 MEDICAL EXAMINER 24002 SQL Server Support - Medical Exam - 3.5% $1,011.31
87202 Medical Examiner - Customer Support 1948.00
Medical Examiner - Total
153 OCSQ- CLEMIS FORENSV LAI3 IMS 16300 OCS0 CLEWS Forensic Lab IMS $1,014.00
OCSO CLEMIS Forensic Lab IMS - Total
617 pROB-ESTATESMIENTL HLTH IMAGE, 95207 Prob-Est/Mnt11-11th Image $7,156..10
Prob-Est/MntIlilth Image - Toial
510 pROB-JUTATES/MENTL HLTH SUPPORT 24010 SQL Sene Sum-PCT-EstiMental - 3.5% $1,u11.31
92198 Prob-Est/Mntl Hlth Support 26444,00
ob-Est/Mntl Hlth Support - Total
$189,971 GB
$427.00
$43,126.76
$610.00
$4,959.31
$1,014.00
$7,156.10
$27,355.31
Prepared by: Information Technology; 412012010 Page 4 of 10 IT Quarterly Development filling 2nd Q0 2010.,la
CC)
195 SHERIFF
191 S HERIF - CLEMIS
445 SUPPORT SERVICES
145 PROSECUTOR -__GENgftAk-YROSECUTION
690 PURCHASING
61,011.31
19,789.00
0.00,
;6.021,00
$0.00
4,752.00
0.00
0.00
$0.00
6,638.00
366.00
$0.00
424.42
92,172.00
10,349.50
270.00
$848,84
318.00
$848.84
2,022.38
8.80E00
$20,800.31
$5.021.00
$4,762.00
$6.004.00
$103,215.92
$1,156.54
$11,077.22.
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - SECOND QUARTER MO
637 RECORDS RETENTION
650 RE/MEWRSEMENT
24016 SQL Server Supp - Proesculors 3.5%
95622 Prosecutor/Executive
9/001 Prosecutor Data Frac
Prosecutor - Total
95663 Purchasing
Purchasing - TotaL
Rec-System Mainteharioe
Rec-Sysiern Enhancements
Rec-New Development
Mail Room
Records Retention - Total
Reimbursement Division
Reimbursement System
Reimburse User Support
Reimbursement - Total
12001 OCSD-Courts/Criminal Warehouse
23009 Oracle Support - OCSINC TS cum VVhse - 2.6%
97163 Sheriff
97155 Sheriff-LW Support
97166 Sherifl-DW Matntenance
Sheriff - Total
23015 Oracle Suppport - Sheriff I CLEMIS - 5.2%
96153 Sheriff- CLEWS
Sheriff - CLE.MIS - Total
23007 Oracle Support Supra Serv - 5.2%
24011 SQL Server Supp Suppt Services 7%
44500 Support Services
Support Services - Total
44052
44053
44054
95836
95469
95470
95542
Premix's! iy Inirienntlach Technolugy, 4/2012010 Page 5 of 10 IT Quallerly Developrnsnt Billing 2nd QV 2010.xIS
600 TREASURER
730 WATER RESOURCE commisstomER
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT 1 SUPPORT DETAIL - SECOND QUARTER 2010
23006 Oracle Support - Del Tax - 5.2% $848.84
23016 Oracle Support - Treasurer 10.4% 1,697.65
36515 GIS Impienrrentatron Support-Treasurer 0.00
36516 Treasurer Application - I-VW Support 13,a5FLoo
36602 Land System Erthancerrertle - Trees (50%) 0.00
36702 Land System Maintenance - Trees 150%) 11,354.75
36502 Land System Support - Trees (50%1 30,730.00
44061 Tre-SystemiCustomer Support 15,593,50
44062 Tre-System Maintenance 4,800.00
44003 Tie-System Enhancements 477.00
44064 Tre-New Development 12,544 00
44080 Tre-DW Support 15,795,00
44082 Tre-OW Maintenance 0.00
95008 Del lax On Una 0.00
95303 Del Tax System Maintenance 0.00
95561 User Support/Del Tax 17,753.00
95615 13SkA Annual Tax Support 22.157.2.5.
Treasurer - 1 otal
24008 SQL Server Supp -WRC 3.5% $1,011.31
28007 Water Resource Commissioner 0.00
28010 WR C - Customer Support 17,794.50
28011 Water Resource Commissioner Application 10,496.50
36520 G1S Implementation Support WRC 17,968.00
36521 WRC Application -11/W Support 12.522,00
Water Resource Commissioner - Total
$144,60.9g
$59,892.31
540 5211 _DISTRICT COURT - NQVI
650 52/2 DISTRICT COURT - CLARISSTQN
14007 CTS-DW Support-52/1 - 6.25%
15002 CTS-DW lvtaint 52/1 - 6.25%
95527 DC Suprt- 52/1 - 25%
5211 District Court - Total
14003 CTS-DW Support-52/2 - 6.25%
15003 CTS-DVV Ma int 5712 - 6.7.5%
95528 DC Suprt- 52/2 - 25%
52/2 District Court - Total
$0.00
0.00
12,550.42
$0.00
0,00
12,550.42
$12,560.42
$12,550.42
Prepared by Information Technology; 4,i21112010 Page 6 of 10 IT Quarter& Development DIffing 2nd air 2010.xts
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - SECOND QUARTER 2010
560 624 DISTRICT COURT - ROCHESTak
530 B214 DISTRICT COURT - TROY
14004 CTS-DW Support-5213 - 6.25%
15004 CTS-DW Maint 5213 - 6.25%
95529 DC Suprt - 523 - 25%
5213 District Court
14005 CTS-DW Suppor1-52/4 - 6.25%
15005 Crs-nw Mint 5214 - 6.25%
p5530 DC Suprt- 5214 - 25%
5214 District Court - iotI
$0,00
0.00
12,550.42
$0.00
0.00
12.150.24
$12,550.42
S 12550 24
Page 7 of 10 11 Quarterly Devallopment Eiging 2nd Ott Z.110.xls Prepared by. Information rechnoile. 4f2C12010
23018 Oracle Support - Sheriff CLEM1S 5.2% 848.57
24004 SQL Server Support - 24.5% 7,078.43
90501 CAD Customer Support 0.00
954139 CRISNET/CLEMIS LRM 0.00
95430 CLEMIS Maintenance 4499 D0
95431 CLEMIS Enhancements 0,00
95432 CLFMIS Adhoc Reports 0.00
913003 CLEWS User Support
CLEM'S - Total
056 CLEMIS FUND $3500 63500 CLEMIS Fund $244.00
CLEM(S 63500 Fund - Total
INFORMATION TECHNOLOCY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - SECOND QUARTER 2010
cust # DIRECT FUNDS
055 ,CLEM1S 20003 IDMS Support - 5.6% 51,964.20
$16.814.20
$244.00
719 CLERKIR013 AUTOMATION FUND 95719 Reg.ister of Deeds Automation $47.607.00
Cie rkfROD Automation Fund - Total $47,607.00
669 CAMS/CVT DATA PONVEI/glON 66901 CAMS/CVT Data Conversion $12..574.50
CAMS/CVT Data Conversion - Total $12,574.50
652 CAIMFM° JIT IMPLEMENTATION1 66901 CAMS/FM0 IIT Implementation) $6.695.50
CAMSIFM0 OT Implementation) - Total $6.695.50
659 COLLASOFtATIVE 45SET MOT SYS 65901 Coliabonlive Asset Mgt Sys $141045.00
Conk ortive Asset Mgt Sys - Total 5141.045.00
471 CTS-FOC-EXP-CS ENFORC-IMAGE 92194 CTS-FOC-Exp-CS FM-Image $14,312.29
CTS-F DC Exp-C S Ent-1m age - Total $14,312.20
507 CTS-FQC E(P-CS ENFORCEMDIT 92193 Grs-rac Exp-CD Entorc-Dev $1,152.00
CTS-FOC Exp-CD Entorc-Oev - Total $8.152.00
210 FIRE RECORDS MANAGEMENT SYSTkM 21010 Fire Records Mgmt Rani 631 S0.00
24001 SL Server Support - rRms 3.5% 1,011.31
Fire Records Management System - Total $1,011.31
Prepared by information Technology; 41200040 page 3 Of 10 Ii Quarterly Development Bilng 2nd Qtr 2010.xls
750 FNI&O
758 FM-04,1,1, MOAT REPLACEMENT
757M-VW* RELEASEIJAIL
841 HEALTH - H1N1 GRANT
751 IT - TL.gpiioNE COMM
653 CI,C, INTERNAT/ONAL AIRPORT
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - SECOND QUARTER 2010
21001 FM&O $11,051.50
24013 SQL Server Supp - FM&O 1,011,31
75503 FM&O Development 30.625,50
FM&O Total
75800 FM-Jail Mgmt Replacement ,52.5Q
Mgml Replacement - Total
23004 Oracle Support - Oak Video - 5.2% $848.64
75700 Fee Mgmt - Video Arraignments 49,557,00
FM-Wk R&/Jail MgmtfVideo Cont - Total
84100 Health -1-11N1 Gratrt 11/51 .P
Health -111 N1 Grant - 1 otal
15102 Tel Comm - Customer Support $1.260.00
I.T. - Telephone Comm - Total
38540 GIG Implementation Support-Aviation $990.00
65301 Airport User Support 1,267 00
56310 O.C. Airport - New Development Z.165.50
Q.C. International Airport - Total
$42,701.3f
$52.50
550,505.84
63,751.00
$1,260.00
$4,422.50
S2A27.50
4,426 00
2,215.00
0.00
0.00
17,492.00
3,182.00
0.00
25,552 75
3,452.50
55,599.50
0.00
14,E13.50
770 PARKS AND RECRA1JPN
763 P&R LYON OAK$ GOLF CSURSE
36530 GIS implementation Support - Parks
44066 FRADM-SystemiCustomer Support
44068 PRADfiA-System Enhancements
77010 PRADM-Technology Assessment
77100 Yr 1 - Program Managernent
77110 Yr 1 - Asset Theme Development
77120 Yr 1 - Network Connectivity
77130 Yr 1 - hardware Refresh
77140 Yr 1 - Pont of Sale System
77200 Yr 2 Program Management
77220 Yr 2 - Asset Mgmt Implementation
77230 Yr 2 - Customer Info Mgrnt Implementation
95419 FRADM-Administration
Parks & Recreation - Total $124,023 75
13600 P&R Lyon Oaks G.C.
P&R Lyon Oaks (kilt Course - Total $86.00
Prepared by. Information Technolggy, 4,2912010 Page 9o1 10 II Quarterly Day eloprnent Bing 2nd Qtr 2010.xls
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT SUPPORT DETAIL - SECOND QUARTER 2010
663 SECURITY CAMERA PROJECT (RADIO FUND 66300 Security Camera Project (Radio Fund) ;494.00
Security Camera Project (Radio F und) - Total
656 WATER & SEWER ACCTG 23011 Oracle Supp - Water & Sewer Acct'g - 52% $848.821
95669 Water & Sewer Acct'g
Water & Sewer Acct'g - Total
736 WINCAN CENTRAL STORAGE SOLUTION 73601 WinCan Central Storage Solution $9.354.50
WinCan Central Storage Solution - Total
734 WRC -AMR SUPPORT 73401 WRC - AMR Support $1.735.50
VViRC - AMR Support - Total
728 WRC - C-C) SOS SEWMET 72201 MARS Enhancements -43% $318.63
WRC - C-0 SDS SewMet - Total
729 WRC - E-F SOS SEWMET 72202 MARS Enhancements - 57% $422.37
WRC - F-F DSD SewMet - Total
$494.00
$16,038.34
$9,354.50
$1,736.50
$318.63
$422.37
Page 10 of 10 IT Quarterly Development Biling 2nd Qtr 2010.x1e Prepared by Inlormelion Technology. 4120/2010
Oft
Resolution #10090 May 5, 2010
Moved by Middleton supported by Potter the resolutions (with fiscal notes attached) on the Consent
Agenda be adopted (with accompanying reports being accepted).
Discussion followed.
Dan Stencil, Executive Officer of Parks and Recreation, addressed the Board.
AYES: Capelio. Coleman, Coulter, Douglas, Gershenson, Gingell, Gosselri, Greirnel, Hatchett,
Jackson, Jacoosen, Long, McGillivray, Middleton, Nash, Potter, Potts, Runestad, Schwartz, Scott,
Taub, Woodward, Zack, Bullard, Burns. (25)
NAYS: None. (0)
A sufficient majority roving voted in favor, the resolutions (with fiscal notes attached) on the Consent
Agenda were adopted (with accompanying reports being accepted).
I ItREBY APPRE,IRE FOREL* RESOLUTION
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 May 5,
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 5th day of May, 2010.
gat
Ruth Johnson, County Clerk