HomeMy WebLinkAboutResolutions - 2009.05.07 - 9875MISCELLANEOUS RESOLUTION #39100 May 7, 2009
BY: FINANCE COMMITTEE, TOM MIDDLETON, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY — SECOND 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 Second
Quarter 2009 development charges to be $1,091,174.03 and the imaging development charge to
be $28,029.08 for the General Fund/General Purpose County departments; and
WHEREAS direct charges to Special Revenue and Proprietary fund departments are
$639,068.62, non-governmental imaging development are $19,622.32, and non-county agencies
are $1.230.00 for the Second Quarter 2009; and
WHEREAS an appropriation transfer to General Fund/General Purpose County
departments is needed to fund these development charges.
NOW THEREI-URE bE II RESOLVED that the Oakland County Board of Commissioners
has reviewed the Second Quarter 2009 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 2009 budgets
are to be amended as specified in the attached detail schedule
FINANCE COMMITTEE
-U4
FINANCE COMMITTEE
Motion carried unanimously on a roll call vote with Potter and Coulter absent.
GOVERNMENTAL FUNDS
General Funci 01
00-302020 -121020-773630
00-302030 11-121020-773630
0
00-302040 -121020-773630
0-302050 -121020-773630
00-107060 -114000-7731530
00-101020 -181010-773630
00-201020 1-180000-773630
00-201030 1-185010-773630
00-201050 - 25000-773630
00-2010210- 25000-773630
00-2010401- 72190-773630
00-2010205- 32300-773630
00-1090101- 71000-773830
00-1070401- 13000-773630
00-1010501- 81020-773630
00-3010201-121110-773630
00-3010401-121220-773630
00-3010403-121100-773630
0-3010301-121220-773630
0-3010301-121130-7731530
0-3010101-121100-773830
101014 t -181000-773634
00-1010115-115090-773630
-1020501-173010-773630
00-1020601-182020-773630
00-1450401-183010-773630
65040-773630
32030-773630
14000-773630
71000-773630
24010-773630
22050-773630
84020-773630
26020-773630
12590-773630
10000-773630
84025-773630
186040-773630
.32050413630
55010-773630
01
0
0
0
0
0
0
0
0
0
540 0 10
550 0' 10
560 0" 10
5.30 Or 10
630 0' 10
620 0' 10
725 0 10
440 0 10
410 0 10
724 0 10
720 0 10
723 0 10
785 0 10
622 '0 10
430 10 10
495 10' 10
506 10 10
483 101 10
420 10 10
4993
493 101
015
900
740 01
660 01
680 01
907 01
I
872 •0•
710
775
510
145
637
650
195
191
445
800
910
730 101 10
00-5010303-'
00-10701301-'
00-1070501-
00-1090201-
00-3040403-
00-4010101-
00-1030843-
00 -1020701-
00-4030301-
00-4030601-
00-1030803-
00-7010101-
00-1070301-
00-6010101-
Prepared by; Information Technology; 4/2112009 IT Quarterly DeueFoprrent erlling 2nd Qtr 2009. x1s
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
2ND QUARTER 2009
CUST 0 FUND # ACCOUNT # DIVISION
1st Car
Oct - Dec
2nd Car 3rd Qtr 4th Qtr
Jan - Aor - -.Kate July - Sept
5211 - District Court
5212 - District Court
52/3 District Court
52/4 - District Court
Animal Control
Auditing
Clerk - Admin
Clerk - Elections
Clerk - Jury Commission
Clerk - Legal Records
Clerk - Register of Deeds
Clerk - Vital Statistics
Economic Development & Community Affairs
Community Corrections Admin
Corporation Counsel
Courts-Business Division
Courts-FO-Judicial Support
Courts-FD-Judicial Support-Admin
Courts-GJ-Family Support
Coutts-GJ-Juclicial Support
Courts Judicel ir Administration
County Exevative
Emergency Response & Prep
Equalization Division
Fiscal Services - Admin
Human Resources
Library Admin
Medical Examiner
MSU Extension - Oakland
Planning & Economic Development
Probate-Estates/Mental Health Support
Prosecuting Attorney - General Prosecution
Records Retention
Reimbursement Division
Sheriff
Sheriff - CLEMIS
Support Services
Treasurer
Veterans Services
Water Resource Commissioner
Sub-Total Fund 101
Page 1 of 13
$7,751.87 $6,900.50 $14,652.37
$7,751.87 $6,900.50 $14,652.37
$7,751.97 $6,900.50 $14,652.37
$7,751.89 58.900,50 514,652.39
$55,300.27 $47,503,79 $102,809.06
$0.00 $0.00 $0.00
$15,525.00 59,439.00 523,064.00
$3,723.00 $1,333.00 $5,056.00
$1,570.41 $3,501.18 $5,071.59
$135,612.02 544,382.04 5179,974.06
51,622.02 55,161.54 56,7133.56
$0.00 50.00 $0.00
$980.50 $896.00 $1,878,50
$17,064.43 529,891.42 546,955,85
$270.00 $946.00 $1,216.00
$2,307.95 $1,750.60 $4,058.55
$0.00 $0.00 $0.00
$2,869.02 $2,013.54 $4,882.56
$0.00 $0.00 50.00
$54,226.00 $44,679.90 $98,905.90
$4,472.45 $40,283.58 $44,756.03
$1,161.00 $61.00
$01.50 $693.50 $785.00
$100,758.55 $142,628.03 5243,386.58
$99,730.05 $93,092.71 $192,822.76
$41,977.93 $27,588.75 $69,566.68
$2,390.00 $277.00 $2,867.00
$12,847.77 $11,343.54 $24,191.31
$305,00 $30.50 $335,50
$16,659.00 $3,635.50 $20,294.50
$5,603.02 $5,808.54 $11,409.56
$12,968.02 $14,409.04 $27,377.03
$2,867,00 $22,203.50 $25.070.50
$39,679.00 536,781.20 576,440.20
$96,948.70 597 985 60 $194,934.30
¶1,917.41 55,337.693 51,255.09
$6,495.18 $12,505.50 $19,000.68
5115,720.03 5120,093.10 $235,613.13
$918.00 $0.00 $918.00
5106,633.02 543,695 29 $150..u8..31
$992,220.75 5895,358.47 $0.00 $0.00 $1,687,579.22
2nd Qtr 3rd Qtr 4th Qtr
Jan - Mar ..".pr June July - Sept \(.T.D CUST # FUND # ACCOUNT #
1st Otr
DIVISION
840 221
843 221
Health Fund J2211
20221-1060201-133150-773630
20221-1060220-134390-773030
Juvenile fylaintenence Fund 12931
665 293 20293-1060501-112090-773630
63600-1080101-152000-631365
722 101
512 101
GOVERNMENTAL IMAGING
10100-2010210-125000-773639
10100-3040403-124010-773639
133600-1080101-152000-630903
NON-GOVERNMENTAL
D1FtECT CHARGES
569
055
056
719
659
507
210
760
757
750
811
751
653
187
770
523,810.85 328_,029.08 $0.00 $0-00 $51,839,74
51,257,612.36 $1,119,203.11 $0.00 $0.00 $2,376,815.47
.1Q•Q r I .n
$Q.08 1D.DO 19A0
$14,865.75 $18,217.92
8.944.90 p.811.16,
$33,083.68
$15.756_.06
$47,141 00 $30,922.50
$54.531 22 $42,488.45
$122.00 $0.00
$12,925.50 $51,543.00
$27,973.30 $37,770.00
$17,497.00 $13,552.10
$829.02 $3,489.04
$0.00 $0.00
$4.918.41 $22,813.18
$6,758.52 $5,144.54
$0.00 $0.00
$0.00 $2;705.50
$4,056.50 $11,254.50
$7,693.50 $8,738.50
$0.00 $0.00
$31,501.00 $40,913.35
$78,063.50
$97,317 70
$122,00
564,468.50
$65,743.30
$31,049.70
54,318,06
$0,00
$27,431.59
$11,903,06
$0.00
$15,311.00
$16,432.00
50.00
$72,714,35
Prepared by: Infofmation Technology: 4/21/2009 Laaerterly Pevelopment Billing 2nd Qtr 2009 xls
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
2ND QUARTER 2009
Health
Health Environmental
Sub-Total fund 221
Children's Village
Sub .Total Fund 293
DEVELOPMENT FOR GOVERNMENTAL FUND
APPROPRIATION
$22,226.50 524,428 50 546,655 00
$211,580.45 $110,208.05 $387,878,51
$239,806.95 $194,726.56 $0.00 $000 $434,533.51
51.77.4,00 $1.089.00 S240.63.00
$1,774.00 51.089,00 $0.00 $0.00 52.863.00
$1,23$,801,70 51,091,174,03 $0,00 $0.00 $2,.324&7813
10100-9090101-198030-773630
Clerk Image
Probate-Estates/Mental Health Image
TOTAL GOVERNMENTAL IMAGING
DEVELOPMENT APPROPRIATION
SUE-TOTAL GOVERNMENTAL I IMAGING
DEVELOPMENT APPROPRIATION:
Information Technology Development
TOTAL GOVERNMENT:
CAMSICVT Data Conversion
CLEM'S
CLEM1$ FUND 63500
ClerkiROD Automation Fund
Collaborative Asset Mgt Sys (CAMS)
Courts-FOC Exp-CS Enforcement
Fire Records Management System
FM-80C Weboasting
FM-V1tk Rel/Jail MglNideo Cont
F M & 0
Health - Bioterrorism Unit
Health - BT - CR1 Grant
IT - Telephone Comm
0.C, International Airport
OCSD Jail Vis4ation Project
Parks and Recreation - Administration
Page 2 of 13
ACCOUNT # CUST # FUND #
471 §_17 689.80 112...22 Courts-FCC E*p-CS Enforcement Image $37112.1Z
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
2ND QUARTER 2009
1st Qtr 2nd Qtr 3rd Qtr 4th Qtr
DIVISION Oct .-Dec 4flM pJune,101.7çp Y T.D.
791
663
601
546
656
Radio Communications E911
Security Camera Project (Radio Fund)
Treasurer - DTRF
UASI Grant (ERP)
Water & Sewer AocounErng
$871.00
$192.50
5398,242.50
$220.00
$14.905.91
$0.00
$110.00
$349,211.75
$0.00
$18.531.1§
$871.00
$302.50
$747,454.25
$220.00
$33.537.09
63600-1080101-152000-631302
NON-GOVERNMENTAL IMAGING
SUB-TOTAL DIRECT CHARGES FOR DEVELOPMENT $630,978.88 $639,068.62 $0.00 $0.00 271._ 47.50_
63600-1080101-15200-630903 TOTAL:NON-GOVERNMENTAL IMAGING
DEVELOPMENT APPROPRIATION
07,899.80 $19.622.32 $0.00 $0.00 $37,512-12
TOTAL COUNTY DEVELOPMENT CHARGES $1.906,481.04 $1.777.894.05 $0.00 $0.00 13.68417O99
NON-COUNTY AGENCIES
63600-1080101-152000-635017 Non-County Agencies $1,697.50 $1.230.00 $2.927.50
TOTAL DEVELOPMENT CHARGES $1,908,178.54 $1,779,124.06 $0.00 $0.00 $3,687,342.59
Page 3 of 1.3
Prepared iriformatton Technology; 4171/20C9 IT Quarterly Development Billing 2nd Qtr 2009,xis
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT 1 SUPPORT DETAIL - SECOND QUARTER 2009
Oust # GOVERNMENTAL FUNDS
630 ANIMAL CONTROL 24017 SQL Server Supp •• Animal Control $2,013.54
95628 Web License Reg .stration 32,757.00
95682 Dag System 12,74.2,5
Animal Control-Total $47,508.79
620 AUDITING 95468 Auditing - Customer Support NAQ
Auditing - Total $0.00
665 CHILDREN'S VILLAGE 95665 Children& Village 51,059.00
Chiidrens \Allege - Total $1,069.00
725 p.LERK - ADmIN 72500 Clerk - Admin 58,4 39_,DO
Clerk - Admin - Total $8,439.00
• 440 CLERK -ELECTIONS 95443 Elections $1.333,,Q0
Clerk - Elections - Total $1,333.00
720 CLERK / REGISTER OF DEEDS 20004 Dab, Customer Support - 20% $915.00
24003 SQL Serer Supp • ROD 3.5% 2013.64
36510 GIS Implementation Support-ROD 1,989.00
36511 ROD Application - I-VW Support 0.00
95493 Reg Deeds System Maintenance 0.00
95162 Clerk DW Support 0,00
95163 Clerk - DW Maintenance 244.00
95558 User Support/ROD 0.00
• 95564 ROD - IDW Support 0 (IQ
Clerk/Reg of Deeds - Total 55,161.54
722 CLERK - IMAGING 13001 Clerk - eFiting - 50% 50.00
23007 Oracle Support - Clerk Image 5.2% 3,501.18
65420 Clerk - Image Replace 0.00
95158 Clerk - Imaging 14 716.74.
Clerk -imaging - Total $16,217.92
410 CLERK - JURY C0MMI.5§,ION 23008 Oracle Support - Jury Comm - 5.2% 53,501.18
95512 Jury Commission 0.00
Clerk - Jury Commission - Total $3,501.18
Page 4 of 13
Precoted by; Infonnalion Technology; 4/2"//2009 IT Quartcrly Dereiopmeni Billing 2nd Ent 2009.205
$2,013.54
421_49.40
$44,362.94
$0.00
$0.00
$3,501 16
2,013.54
24,376.70
$29,891A2
$946,00
$948.00
($1,100.00)
..f
015 COUNTY EXECILTIVE 95854 County Exec - Development
95656 County Executive Support
County Executive - Total
506 CTS-FD-JUDICIAI_ SUPPORT
483 CIS-FP-JUDICIAL SUPPORT-ADM
$0.00
0.00
0,00
1.750.60
50,00
$2,013.54
$0,00
$1,750.60
$0.00
$2,013.54
$000
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 21:109
724 CLERK - LEQAL RECORDS
723 CLERK - VITAL STATITICS
522 COMMUNITY CORRECTIONS-ADMIN (CO)
430ggip.SMILLDf_j_1.
24015 SQL Server Supp - Circuit Ct 3.5%
95189 Circuit Court System
Clerk - Legal Records. Total
95161 Clerk-Vital Statistics
Clerk - Vital Statistics - Total
23003 Oracle Support-Comm Corr - 5.2%
24912 SQL Server Supp - Community Corr 3.5%
52200 Comm Corr-Admin (County)
52201 Comm Corr-DVV Supp
Community Corrections - Total
95501 Corporation Counsel
Corporation Counsel - Total
495 05-pusiNEss DIVISION
420 CTS - QJ - FAMILY SUPPORT
12002 Circuit CI-Courts/Criminal Warehouse 50%
14001 CTS-DW SupporliCircuit Ct - Z5%
15001 CTS-DWMaint/Circuit Ct - 75%
23010 Oracle Support-CCTICTS Grim VVhse 2.6%
CTS-Susiness Division - Total
95187 CTS-FD/Amin - Farn Suppt Staff
CTS-FD-Judicial Suport - Total
24009 SQL Serv Stipp - CTS-Jud Sup Adm 3.5%
95193 CTS-FD-Judicial Support-Adm
CTS-FD-Judicial Support-Adm - Total
95195 Cir Crt Admin
Courts - GJ - Family Support Total
Page 5 of 13
Prepared ay, Information Technology. 4r21‘2009 IT Quail-lady Development Billing 2nd Qtr 2009.xls
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - SECOND QUARTER 2009
498 CTS-GEN JURIS-JLIDICIAL SUPPT
493 CTS-JUDICIAL MJP
785 ECONOMIC DEVELpPMENT & COMMUNITY AFFAIRS
900 EMERGENCY RESPONSE & PREPAREDNEIS
740 EQUALIZATION
95179 CTS-Gen Juris-Judicial Stipp!
CTS-Gen Juris Suppt - Total
13002 CTS-eFiling - 50%
95174 CTS-Judicial Admin
CTS-Judicial Admin - Total
36500 GIS Implementation Support C&E Dev
36501 CED Application -1-I/W Support
95785 Comm & EC° Developmt
Economic Development & Community Affairs - Total
36545 GIS Implementation Support EMS
36546 ERP Application -1-1/W Support
98990 Emergency Response
ERP - Total
20001 IDMS Support-Equalization - 40%
23012 Oracle Support-Equalization - 5.2%
24005 SQL Server Supp-Equa5ization - 10.5%
31075 Equal - Development
36505 GIS Implementation Support Equalization
36506 Equal Application -11/W Support
36507 Equal LAMS SupporVilltce
36601 Land System Enhancements •- Equal (50%)
36701 Land System Maintenance - Equal (50%)
36801 Land System Support - Equal (50%)
95559 User Support/Equal
95562 Equalization - OW Support
95570 Equalization - OWMainianarice
95693 Equal-System Maintenance
95695 BS&A Master Appraisal Sup/Maint
Equalization - Total
$44 679 90
$0 00
40.263.58
$734.00
164.00
QQQ
$255.50
438.00
IIQL)
$1.830.00
3501.18
6.040.60
47.582 50
722.50
4,948.00
0.00
704 50
3,759.25
20.133.50
0.00
7,657.00
246.50
1,464.00
44 028.50
$44,679.90
$40,283.58
$89800
$693.50
$142,628.03
Paga 6 of 13
Prepared by. Information Technology. 4121,2009 11 Quarterly Development BrFling 2nd Qtr 2009 xis
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - SECOND QUARTER 2009
660 FISCAL SERVPCES ADMIN 23001 Oracle Support - Fiscal Serv - 15.6% $10,503.56
23013 Oracle Support.- HR-Acctg/Budget - 5,2% 3,501.18
24008 SQL Sery Supp HR-.Acctg - 1 75% 1,006.77
44021 FS-System/Customer Support 37,388.00
44022 FS-System Maintenance 5,734.00
44023 FS-Syatam EnhancernentS 0,00
44024 FS-New Development 0.00
44076 BUD-System/Customer Support 122.00
44077 BUD-System Maintenance 0,00
44079 FS - OW Support 216.90
44081 FS - OW Maintenance 0.00
98001 Human Res - Acct 40% 23,080 80
96003 Fluman Res - Budget 20% 11 540.40
Fiscal Services Admin - Total $93,092.71
840 HEALTH DIVISION 20002 1DMS Suppori - CHAMPS - 20% $915.00
36525 GIS Implementation Support Health 1,758,00
37025 CHAMPS - P.O.P. 216.00
95663 User Support-Health 14,465.50
96842 Health Admin 7 074 60
Health - Total
843 14W,LT1-1 -ENVIRONMENTAL 23005 Oracle Support - EH Projects - 5.2% $3,501.18
24014 SQL Server Suppt - El-metal 14% 8,05,4.12
37002 Environmental 0,00
84200 EF I - Projects 107,365.50
84300 Ehealth Program 5,1,1725
Health-Environmental - Total
080 HUMAN RESOURCES 23014 Orac1e Support-HR/Persortnel - 5.2% $3,501.18
24007 SQL Server Suppport-HR/Personnel - 1.75% 1,006.77
441041 PER-System/Customer Support 0.00
44042 HR-Systems Maintenance 0.00
44044 HR-New Development 0.00
95686 KR User Supt 0.00
95092 Human Res-Personnel 40% 23 080.80
Human Resources - Total
$24.428.50
$170,298.06
$27,588.75
Page 7 of 13
Prrportgi by; information Tecnnoiojjy: 4(2112009 IF Ouarteriy Developrrterti Bilting 2nd Qt! 2009 ads
$2,013.54
9,330.00
$11,343.54
$30.50
$2,537,50
a 00
1 098 00
$3,635 50
$9,811.16
$9,811.13
$2,013.34
3,793,0Q
$5,306.54
24016 SQL Server Stipp - Proescutors 3.5% $2,013.54
95E22 Prosecutor/Executive 6,631.00
97001 Prosecutor Data Proc §.2§4-5.2
Prosecutor - Total $14,409.04
44052 Rec- System Maintenance $0.00
44053 Rec- SystemEnhancements 1,342.00
44054 Rec-New Development 20,861.50
95636 Mail Room 0.00
Records Retention - Total $22,203.50.
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT SUPPORT DETAIL - SECOND QUARTER 2009
907 LIBRARY - LIBRARY ADMIN
872 MEDICAL EXAMINER
710 MSU BXTENSION - OAKLAND
775 PLANNING & ECONONIIC DEVELOPME T
512 PROB-ESTATES/MENTL FILTH IMA(4
310 PROB-ESTATESIMENTL HLTH SUPPORT
145 PROSECUTOR - GENERAL PROSECUTION
637 ggag RETENIION
24002 SQL Server Support - Medical Exam - 3.5%
87702 Medical Examiner - Customer Support
Medical Examiner - Total
95676 MStJ Ext Equipment Maintenance
MSIJ Extension - Oakland - Total
95600 PEDS-CustorneriSystem Support
95766 PEDS - DW Support
95787 PEDS - OW Maintenance
PEDS - Total
95207 Prob-Est/h/Intl I-11th Image
Prot-Est/Matt Filth Image - Total
24010 SQL Serv Supp-PCT-EsVMentat - 3.5%
92198 Prob-Ezt/Mntl HI* Support
Prob-EsVMntl Hhh Support Total
91405 Library Board $277.00_
Library - Library Admin • Total $277.00
Page 8 of 13
Prepared by: Information Technology; 4./2 1/20/n IT Quarterly Development Billing 2nd Otr 200S.xls
650 REIMINRSEMEN T
195 SHERIFF
191 SHERIFF - CLEMIS
445 SUPPORT SERVICES
600 TREASURER
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - SECOND QUARTER 2009
95469 Reimbursement Division $0.00
95470 Reimbursement System 35,419.20
95542 Reimburse User Support j342.00
Reimbursement - Total
12401 OCSD-Courts/Criminal Warehouse $0.00
23009 Grade Suppport - OCSD/CTS Crim Whse - 2.5% 1,750.60
97163 Sheriff 83,881.50
97165 Sheriff -DW Support 11,165.50
97166 Sheriff-D1N Maintenance 1,1E3.00
Sheriff - Total
23015 Oracle Suppport - •Sheriff it CLEMIS - 5.2% $3,601,113
96163 Sheriff - CLEWS 1,836.60.
Sheriff - CLEM1S Total
23002 Oracle Support - Supp Seri - 5.2% $3,501.18
24011 SQL server Supp - Suppt Services 7% 4,027.07
44500 Support Services 4,977.25
Support Services - Total
23006 Oracle Support Del Tax - 5.2% $3,501.18
23016 Oracle Support - Treasurer - 10" 7,002.37
36515 GIS Implementation Support-Treasurer 0.00
36516 Treasurer Application -1-1/W Support 8,113.00
35692 Land System Enhancements - Trees (50%) 704 50
36702 Land System Maintenance - Trees (50%) 3,769.25
36602 Land System Support - Trees (50%) 20.133 50
44051 Tre-SysterniCustorner Support. 7,156.00
44062 Tie System Maintenance 784.00
44083 Tre-System Enhancements 0.04
44064 Tie-New Dev&opment 0.00
44080 Tre-DW Support 16,664,50
44982 Tre-DW Maintenance 5,556.00
95008 Del Tax On line 2.074,00
95303 Del Tax System Maintenance 1,803 00
95561 User Support/Del Tax 7,142.00
95615 BS&A Annual Tax Support 35,689.80
Treasurer - Total
$36,761.20
397.985 60
$5,337.66
$12,505.50
$120,063.10
Page 9 of 13
Prepared by Information technology, 4/2112009 IT Quarterly Development Billing 2nd Qtr 7009.xlic
910 VETERANS SERVICE§
730 VVATER ESOUK COMMISSIONER
540 5211 DISTRICT COURT - NOVI
55( 52/2 DISTRICT COURT - CLARKSTON
560 AvA_Misici m
5114 DISTRICT COURT - TROY
$0.00
$2.013.54
492.00
14,627.50
(4,582.00)
20,726 75
10 417 50
$0.00
0.00
6.900.W
$0.00
0.00
$0.00
0.00
6,900.50
$0.00
0.00
6,9(}9.50
$o.00
$43,695.29
$6,900.50
$6,900.50
$6,900.50
$6,900,50
14003
15003
- 95528
14004
15004
95529
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2009
95651 Veterans Customer Support
Veterans Services - Total
24008 SQL Server Supp WRC 3.5%
28007 Water Resource Commissioner
26010 WRC - Customer Support
28011 Water Resource Commissioner Application
38520 GIS Implementation Support Vid'RC
36521 WRC Application - HM Support
Water Resource Commissioner - Total
14002 CTS-DVV Support-52/1 - 6.25%
15002 CTS-DW Maint 5211 - 6.25%
95527 DC Suort- 6211 - 25%
52/1 District Court - Total
CTS-OW Support-52/2 - 6.25%
CTS-DVV Mint 52/2 - 6.25%
DC Suprt- 5212 - 25%
52/2 District Court - Total
CTS-DVV Support-52/3 - 6.25%
CTS-OW Maint 5213 - 6.25%
DC Suprt - 52/3 - 25%
5213 District Court - Total
1 4005 CTS-DVV Support-5214 - 6,25%
15005 CIS-DW Main 5214 - 6.25°k
95530 DC Suprt- 5214 - 25%
5214 District Court - Total
Page 10 of 13
Piepaced by Information Technology. 412112009 IT Quarterly Ceveiopmen119iIhng 2nd Qtr 2009. xls
507 CTS-FOC EXP-CS ENFORCEMENT 92193 CTS-FOC Exp-CD Enforc-Dev $13,52,10_
CTS-FOC Exp-CD Enforc-Dev - Total
CTS-FOC Exp-CS Fnf-trnage - Total 519,622.32
$13,552.10
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - SECOND QUARTER 2009
Cust4t DIRECT FUNDS
055 pLemis 20003 IDMS Support - 5.6% 5915.00
23018 Oracle Support - Sheriff CLFMIS 5.2% 3,501.25
24004 SQL Server Support - 24.5% 14 094 73
90507 CAD Customer Support 0 00
95409 CRISNETiCI. FMIS LRINI 0.00
95430 CLEMIS Maintenance •11,663.50
95431 CLEWS Enhancements 0.00
95432 CLEWS Adhoc Reports 0.00
98003 CLEMIS User Support .12,312,90
CLEMIS - Total 542.486.48
056 CLUJ'S FUND 62500 63500 CLEMIS Fund $0.00
CLEM'S 63500 Fund - Total $0.00
719 CLERK/ROP ALITOMATIQN FUND 95719 Register of Deeds Automation 161,543,91
Clerk/ROD Automation Fund - Total $51 ,543.00
669 CAMS/CVT DATA CONVERSION 88901 CAMS/CVT Data Conversion §30_922.50
CAMS/CVT Data Conversion - Total $30,922.50
659 001.1,0ADORATIVE ASSET MGT SYS 05901 Collatiortive Asset Mgt Sys $37.770.00
Callaborlive Asset Mgt Sys Total $37,770.00
471 CTS-FOC-EXP-05 ENFORO-IMADE 92194 CTS-FOC-Exp-CS Enf-image $19.62Z34
210 FIljang013§1N.AgE/IA IIENI SYSTEM 21010 Fire Records Mgmt Fund 531 $1,475.50
24001 SQL Server Support.- FRMS 3,5% 2,013.54
Fire Records Management System - Total
750 FMISO 21001 FM&C
24013 501 Server Supp - Flk,48,0
75503 F-M&0 Development
FM&O - Tote/
$1,575.50
2,013,54
1,5b5.b0
$3,489.04
$5,144.54
Page 11 of 13
Prepared by. Intormation Technology, 4121/2009 IT Quarterly Development Elting 2nd Qtr 20119 Os
$0.00
$0,06
760 FM -1313C WEBCASTING 76000 FM - BOG Webcasting
FM - BOG Webcasting - Total
757 FM-WK RELEASEIJAIL MOMTNIDEO CONF
803 HEALTH-EMOTERRORISM UNIT
811 1-1E,ALTU=-CR1 GRANT
751 IT -TELEPHOHE COMM
653 0,C. INTERNATIONAL AIRPORT
187 OCSD -JAILSISITATION PROJECT
770 PARKS AND RECREATION
791 RADIO CQMMUNICATION - E011
663 SECURITY CAMERA PROJECT (RADIO FUND)
$3,501.18
19,012.00
50.00
n.788.50
111,254.5.2
522,513.18
$0.00
¶2,78850
$11,254.50
$5,636.00
328.00
2 775 50
$8,736.50
$0,00
12.'1Q
$676 50
4,124.60
1,044.00
0.00
6.736.50
6.648.75
7.580.50
10 151.00
5,233.50
$0.00
$110.00
$40,913.35
$0.00
$110.00
Prepared by. Informatinn Terchrolcgy, 4121/2009 IT Ouanerly oevelopment Billing 2nd Qtr 2009.xls
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2009
23004 Oracle Support - Oak Video - 5,2%
75700 Fac Mgmt - Video Arraignments
FM-Wk. Rel/Jail MgmtNideo Corti - Total
• 80130 Health - Bicterrorism Unit
Health - Bioterrorism Unit • Total
81100 Health - BT - CRI Grant
Health - BT - CRI Grant - 'Total
75102 Tel Comm - Customer Support
I.T. - Telephone Comm •• Total
36540 GiS Implementation Support-Avration
65301 Airport User Support
65310 O.C. Airport - New Development
0.C. internatiorial Airport-Total
97187 OCSD - Jail Visitation Project
OCSD - Jail Visitation Project - Total
36530 GIS Implementation Suppod - Parks
44066 PRADM-System/Custorner Support
44068 PRADM-System Enhancements
77010 PRADM-Technology Assessment
77100 Yr 1 - Program Management
77110 Yr 1 Asset Theme Development
77120 Yr 1 - Network Connectivity
77130 Yr 1 - Flardwatre Refresh
77140 Yr 1 - Point of Sale
95419 PRADM-Administration
Parks & Recreation --Total
79101 Radio Communications - EMI
Radio Communications - E911 - Total
66300 Security Camera Project (Radio Fund)
Security Camera Project (Radio Fund) - Total
Page 12 of 13
18010
16050
18069
$349,211.75
601 TREASURER - DTRF Treasurer's Office System
Drain Apportionment
Mictlion Business Tax
Treasurer OIRF - Total
$258,068.75
14,580.50
76.562.50
$0.09
$0 00
546 UASI GRANT. [ERP) 12546 llAS1 Grant (FRP
1.1ASI Grant (ERP Total
$3,501.15
1$.130.0C
$16 631,18
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2009
656 WATER & SEWER ACCIG 23011 Oracle Supp - Water 8, Sewer Acct'g - 6.2%
95669 Water & Sewer Acctg
Water & Sewer Acag - Total
Page 13 of 13
Plebat'ed by; Information Technology, 4/21/2009 II Quarterly Development Billing 2nd Qtr 2009.xf8
Resolution #09100 May 7, 2009
Moved by Middleton supported by Jackson the resolutions (with fiscal notes attached) on the Consent
Agenda be adopted (with accompanying reports being accepted).
AYES: Burns, Capello, Coleman, Coulter, Douglas, Gershenson, Gingell, Gosselin, Greimel,
Hatchett, Jackson, Jacobsen, McGillivray, Middleton, Nash, Potter. Runestad, Schwartz, Scott,
Woodward, Zack, Bullard. (22)
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).
I HEREBY APPJOVE THE FOREGOING RESOLUTION
5.--7„2/0
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 7,
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 7th day of May, 2009.
Gat
Ruth Johnson, County Clerk