HomeMy WebLinkAboutResolutions - 2009.08.12 - 9697MISCELLANEOUS RESOLUTION #09163 August 12, 2009
BY: FINANCE COMMITTEE, TOM MIDDLETON, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY — THIRD 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 Third Quarter
2009 development charges to be $1,287,253.41 and the imaging development charge to be
$30,413.89 for the General Fund/General Purpose County departments; and
WHEREAS direct charges to Special Revenue and Proprietary fund departments are
$423,742.29, non-governmental imaging development are $21,407.40, and non-county agencies
are $3,943.30 for the Third 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 Third Quarter 2009 Development Report and approves the Third 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
FINA CE C9M-MITTEE
iM
FINANCE COMMITTEE
Motion carried unanimously on a roll call vote with Gingell absent.
00-1070401-11
00-1010501-18
00-3010201-12
00-3410401-12
00-3010403-12
000-773530
020-773630
110-773630
220-773630
100-773630
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
101
101
101
DIVISION CUST * FUND# ACCOUNT
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
3RD WARIER 2009
1st Car
gq- Dec
2nd Qtr 3rd Ctr 4th Qtr
Jan Mar Apr - June
540
550
560
530
630
620
005
725
440
410
724
720
723
785
522
430
495
506
483
420
498
493
015
900
740
660
680
907
872
711)
775
610
481
145
637
650
195
191
206
445
600
910
10
10
10
10
10
10
10
10
10
10
10
10
10
01
01
01
01
01
0
0
0
0
0
0
0
01
01
ol
GOVERNMENTAL FUNDS
41%4_1101
00-3020201-121020-113630
-121020-773630
-121020-773630
-121020-773630
-114000-773630
-181010-773630
I 00-501010 -160010-773630
00-201020 -180000-773630
00-201030 -185010-773630
00-7010501-125000-773630
00-2010210-125000-773630
00-2010401-1 72 190-773630
00-2010205-132300-773630
00-1090101-171000-773630
I 0100-3010301-12 220-773630
0100-3010301-12 130-773630
0100-3014101-12 100-773630
0100-1010101-18 000-773630
0100-1010115-115090-773630
0 00-1020501-173010-773630
O 00-1020601-182020-773530
0 04-1050401-163010-773630
0' 00-5010303-165040-773534
0' 00-1070601-132030-773630
0 130-10/0501-' 74000 773630
0' 00-1090201-1 71000-773630
0'00-3040403-1 24010-773630
0 00- 040101-'210507731530
O 00- 010101-'22050-773630
O 00- 030803-184020-773530
O 00- 020701-'26020-773630
O 00 030301-'12590-773630
0 00 030601-1 10000-773630
D 00- 030901-'10040-773530
O 00- 030603-1 84025-773630
0, 00- 010101-186040-773630
0i 00-1070301-', 32050-773630
5211 - District Court
52/2 - District Court
52/3 - District Court
52/4 - District Court
Animal Control
Auditing
Board of Commissioners
Clerk - Admin
Clerk - Elections
Clerk - Jury Commission
Clerk - Legal Records
Clerk - Register of Deeds
Clerk - Vital Statistics
Economic Development & Community At airs
Community Corrections Admirr
Corporation Counsel
Courts-Business Division
Courls-FD-Judicial Support
Courts-FD-Judicial Support-Admin
Courts-al-Family Support
Courts-GJ-Judicial Support
Courts - Judical 1 Administration
County Executive
Emergency Response 8 Prep
Equalization Division
Fiscal Services Admin
Human Resources
ibrary Admin
Medical Fxaminer
MSU Extension - Oakland
Planning & Economic Development
Probate-Estates/Mental Health Support
Probate-I-D Judicial
Prosecuting Attorney - General Pr osecution
Records Retention
Reimbursement (Division
Sheriff $96,948.70
Sheriff - CLEMIS
Sheriff - LE Support Services Adrrun
Support Services
Tweasurer
Veterans Services
$7,751.87 $6,900.50 18,512.38 $23,164.75
$7,751.87 $6.900.50 $8,512.38 523,164.75
$7,751.87 $5,900.50 58,512,38 $23.164,75
57,761.89 $6,900.54 $8,612,36 $23,164.75
$55,300.27 547,508.79 $60.653,01 $163,462.47
50.00 10.00 1610.00 1610.00
$0.00 $0.00 $311,00 $311.00
$15,525.00 58,439.00 $11,142,00 $35,106.00
$3,723.00 $1,333.00 $3,615,00 $8,671.00
$1,57041 $3.501.18 $3,654,64 $8,726.23
$135,612.02 $44,362.94 $26,920.51 $206,895.47
$1,622.02 $5,161.54 $10,924.81 $17,708.37
$0.00 $0.00 15,994.00 55.994.00
$980.50 $898.00 $847.00 12,52550
$17,064.43 $29,891.42 560,594.05 $107,549.90
$270.00 $946.00 $392.00 11,608.00
$2,307.95 $1,750.60 52,040.82 16,099.37
$0.00 $0.00 $0.00 $0.00
$2,869.02 $2,013.54 $2,144.51 $7,027,07
$0.00 $0.00 $000 $0.00
154.226,00 $44.679.90 $63,010.00 $161,915.90
$4,472.45 $40,283.58 $96,510.35 5141266.38
$1,151.00 (11.100.00) $30.50 $91.50
$91.50 $693.50 $30.50 $815.50
$100,758.55 $142,628.03 5130,893,13 $374,284.71
$99,730.05 $93,092.71 $97,362.30 $290.185.06
$41,977.93 127,586.75 $18,012.29 167.578.97
$2,390.00 $277.00 $122.00 $2789.00
$12,847.77 . $11,343.54 $11,121.51 $35,312.82
$305.00 $30.50 $30.50 5306.00
$16,659.00 $3,635.80 12,192.00 522,486.50
$5,603.02 $5,806.54 $5,054.91 $16,464.47
$0.00 10.00 5122.00 5122.00
$12,958.02 $14,409.04 $14,676.01 $42,053.07
$2,867.00 $22,203.50 $34,883.25 559,953.75
$39,679.00 $36,761.20 $17,317.90 $93,758,10
$97,985.60 1104,613.32 1299,550.62
$1,917.41 $5,337.68 $7,776.14 515,03023
$0.00 Woo $1,188.00 $1,188.40
$6,495.18 512,505.50 $12,513.65 $31,514.33
$115,720.03 $120,093.10 $142,054.04 $377,867,17
$918.01) $0.00 $54.00 $972.00
00-302030
00-302040
00-302050
00-107080
00-101020
Prepared by Mtn' matron lechnology, 7129/2009 Page 1 or 13 IT Cuarterly Development Bierr9 3rd cllr 2039 ids
r
CUST# FUND ACCOUNT 0
1st air 2nd Qtr
Oct - Dec Jan Mar
3rd Qtr
Apr - June
4th Qtr
uly - Szot DIVISION
$106,533.02 $43.695.29 $91.773.31
$992.220.75 $895,358.47 $1,075,041.46
$242-101 .62
$0.00 $2,962,520.58
$24,428.50
$217.58p 45 $170,296.06
$239,806.95 $194,725.56
$1,774.00 51.089.00
$1,774.00 $1,089 OD
$25,219.80
$1$5,655.65
$213,935.45
$1,276.50
¶1,276.50
$71,934.80
$573.534.15
$0.00 $645,468.96
$0.00 $4,139.50
.$1.233,801.70 $1.091.174,03 }1.267.253,41 $0.00 $3,612,229.14
$14,865.76 $18,217.92
$8,944.90 $9.811.16
$19,710.19
$10,703.70
$52,793.87
$29.459.76
$23.810,14 $28.029.06 $30,413.39 ILK $82,253.63
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
3RD QUARTER 2009
•
730 101 10100-6010101-155010-773620
Health Fund 12211
840 221 20221-1050201-133150-7i:3530
843 221 20221-1060220-134390-773630
juvenilc Maintenance Fund 12931
665 293 20293-1060501-112090-773630
63600-10801131-15200G-631365
GOVERNMENTAL IMAGING
722 101 10100-2010210-125000-773639
512 101 101 00-3040403-1 2401 0-773639
63000-1080101-152000-630903
10100-9090101-196030-773630
Water Resource Commissioner
Sub-Total Fund 101
Health $22.226.50
Health Environmental
Sub-1 otal Fund 221
Children's Village
Sub-Total Fund 293
DEVELOPMENT FOR GOVERNMENTAL FUND
APPROPRIATION
Clerk Image
Probate-Estates/Mental Heaith Image
TOTAL GOVERNMENTAL IMAGING
DEVELOPMENT APPROPRIATION
SUB-TOTAL GOVERNMENTAL I IMAGING
DEVELOPMENT APPROPRIATION:
Information Technology Development
TOTAL GOVERNMENT:
$1,257,612.36 $1,119,203,11 $1,317,967.30 50.00 $3,694,482.77
151257 612 36_1 51 119,203.111 ;51, 3l7,967.3D) $0.00 S3.694.45 72:j
so.oq $0,40 19.:02 $0.00 $0.00
669
055
056
719
659
661
507
210
750
757
750
803
811
751
653
187
NON-GOVERNMENTAL
DIRECT CHARGES
CAMS/CVT Data Cnnversion
Cl EM IS
CLEMIS FUND 63500
Clerk/ROD Automation Fund
Collaborative Asset Mgt Sys (CAMS)
Community & Home Improvement
Courts-FOC Exp-CS Enforcement
Fire Records Management System
FM-BOC Webcasting
FM-Wk MgWideo Cont
FM & 0
health - Bioteirorisrn Unit
Health - BT- CRI Grant
11 - -re/epitome Comm
O.C. International Airpon
OCSD - Jail Visitation Project
$47,141.0D $30.922.50 $27,526.70
554,83122 $42,456.48 $38,057.43
$122.00 $0.00 $2,562.00
$12,925,50 851,543.00 $86,763.00
$27,973.30 $37,770.00 $44,949,70
$0.00 $0.00 $122.00
$17,497.00 $13,552.10 $8,772.00
$829.02 $3,489_04 $2,636.51
$0.00 $000 $0.00
$4,918.41 $22,513.18 $38,697.54
$6,758.52 $5,144.54 $5,194.51
$0.00 $0.00 ¶0.00
$0.00 $2,788.50 $45,856.50
$4,086.50 $11,254.50 511,837.00
$7,693,50 $8,738.50 $4,647.00
$0.30 $0,00 $0.00
$105,590.20
$135,375.13
$2,684.00
5151,231.50
$110,693.00
$122.00
$39,821.10
$5,954.57
$0.00
$66,129.23
$17,097.57
$0.00
$48,655.00
$27,148.00
$21,079.00
¶0.00
Prepared by, 'Information Technology: 7/23/2009 Page 2 0113 IT Quarterly Development Bluing 3rd Qtr 2009.ids
ACCOUNT # CUST # FUND #
770
791
663
601
546
656
63600-1080101 -152000-831302
NON-GOVERNMENTAL IMAGING
Courts-FOC Exp-CS Enforcement Image $17,889.80 $19.622.32 $2.1.40.7.40 $51319.52 471
Prepared by. hoormatinn Technology, 7i'29r2009 Page 3 of 13 IT Quarterly Development Billing 3rd Qtr 2009.xls
•-
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
3RD QUARTER 2009
1st Olr 2nd Qtr 3rd Qtr 4th Qtr.
DIVISION Oct - Dec Jan - Mar Apr • June July - Sept Y. 1..
Parks and Recreation - Administration
Radio Communications F911
Security Camera Project (Radio Fund)
Treasurer - DTRF
UASI Grant (ERP)
Water & Sewer Accounting
SUB-TOTAL DIRECT CHARGES FOR DEVELOPMENT
$31.801.00 $4091335 $10988250 $182,596.55
$871.00 $0.03 $0.00 $871.00
$192.50 $110.03 $4.240.50 $4,543.00
$398,242.50 $349,211.75 cS?5 753.59 $721,695.66
$220.00 50.00 50.00 $220.00
$14,905.91 118,531.18 $17.745.89 $_,1 282.98
$530.978.88 $639.068.62 ;423,742.29 $0.00 $1,593.789.79
63600-1080101 -15200-630903 TOTAL NON-GOVERNMENTAL IMAGING
DEVELOPMENT APPROPRIATION
TOTAL COUNTY DEVELOPMENT CHARGES
17,889.80 $19,622,32 $21,407.40 $0.00 $58,919.52
$1,906,481.04 S1.777,894.95 $1 762,816.99 $9.90 $5,447,192.08
NON-COUNTY AGENCIES
63600-1080101 152000-635017 Non-County Agencies
TOTAL DEVELOPMENT CHARGES
$1,697.50 $1,230.00 11943.30 $6.879,80
$1,908,178.54 $1,779,124.06 $1,766,700.29 $9.00 $5,464,062.88
500,553.01
ci.51# GOVERNMENTAL FUNDS
630 ANIMAL CONTROL $7,144.51
40,694.25
17 514.25
24017 SQL Server Supp - Animal Control
95678 Web bir.ense Registration
95652 Dog System
Animal Conti ol- T ol al
$366.00
2-44.00
$311.30
$1.2 /6.5i
$11,142.00
$3615.00
$719.60
2,144 61
7,816.50
0.00
0.00
0.00
122.40
122.00
0.00
0 00
$0.00
3,6.54.64
0 00
16 055 55
$610.00
$311.00
$1,276.50
$11,142,00
$3,615.00
$10 924.31
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2009
520 AUDITING 44034 Auciting - New Development
95458
Auditing Customer Support
Auditing - Total
005 $D OF COMMISSIONERS 91404 BCC - Customer Support
Bd of Commissioners - Total
555 CHILDRENSN1LLAGE 95665 Childrens Village
Ctilld,ens Village - Total
725 CLERK • ADMIN 72500 Clerk - Adrnin
Clerk Admin - Total
440 CLERK - ELECTIONS 95443 Elections
Clerk - Elections - Total
120 CLERK REGISTER OF DEEDS 20004 DBA Customer Support 20%
24003 SQL Server Supp - ROD 3.5%
36510 GIS Implementation 544:tart-ROD
36511 ROD Application - HW S pporl.
95493 Reg Deeds System Maintenance
95162 Clerk - OW Suppoit
95163 Clerk - DW Maintenance
95492 ROD - System Maintenance
95553 User SupporUROD
95564 ROD - DW Support
Clerk/Reg of Deeds - total
727 CLERK - IMAGING
410 CLERK. - JURY commissiort
Pi epared by Information Technology; 1,29(2005
13001 Clerk - eFiling 50%
23007 Oracle Support . Clerk !made 52%
65420 Clerk - Image Replace
95158 Clerk - Imaging
Clerk Imaging - Total
23008 Oracle Support.- Jury Comm - 5.2% $3,654.64
95512 Jury Commission 0.00
Clerk - Jury Commission - Total
Peige 4 ot 13 LT Quarterly DevelunmAnr bsNin 3rri Otr TC09 xl$
$19.710 19
$3.654.64
I I.
724 CLERK - LVAL. RECORDS 24015 SQL Serv-er Supp - Circuit Ct 3.5%
95189 Circuit Court System
Clerk - Legal Records - Total
$2.144.51
a42_7 0:I
$26.920.51
55 994 00
$3,994 0.0
430 CORPORATION COUNSEL
015 COUNTY EXECUTIVE
$2,144 51
0.00
$2,144.51
NI eared by. Infcfmsb.un Tethnolosgy, 729t2009 13. Dwit.41urytteiL diing3rxi Otr
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - THIRD QUARTER 2009
723 cLERK - VITAL STATITICS 95161 Clerk - Vital Statistics
Clerk - Veal Statistics Total
522 COMMUNITY CORRECTIONS-ADMIN (C01 23003 Oracle Support-Comm Corr - 5.2% $3,654 64
24012 SQL Server Supp - Community Corr 3.5% 2,144 Si
52200 Comm Corr-Admin {County) 54,794 90
52201 Comm Cor NOW Supp LCD
Community Corrections - Total $60.594.05
95501 Corporation Counsel $392.00
Corporation Counsel - Total $392.00
95554 County Exec - Developinerit $0.00
95656 County Executwe Support 30.50
County F.xecutive - $30 4,0
495 CTS-BUSINESS DIVISION
505 CTS-FD-JUDICIAL SUPPORT
12002 Ciru.uit Ct-Courts/Criminal Warehouse 50% $213.50
• 14001 C,IS-OVV SupporLoCircuil. Cl - 75% 0.00
15001 Maint/Circuit Cl - 75% 0.00
23010 Oracle Suppolf-CCT/CTS CI-1m %%se 2.6% 1821.32
CTS-Business Division - Total $2,040.82
951S7 Cl S-F DOA mon - Fam Suppt Staff $0.00
CTS-FD-Judicial Suport - Total $0.00
483 CTS-FO-JUOICIAL SUPPORT-ADM
420 CTS OJ - FAMILY SUPPORT
24009 SQL Serv Supp - CTS-Jud Sup Adm - 3.5%
95193 CTS-FD-Judicial Support-Adro
CTS-FD-Judicial Supporl-Ado - Total
951 95 Cir Crt Adman $0 02
Courts-fl - Family support . Total $0.00
PRgt' 5 or
900 EMERGENCY RESPONSE & PREPAREDNESS
740 pQUALIZATION
Prepared by Ink:4'600n re.chnology, TI220019 Page6 of $3 IT Overierly Development Dilltng and Oh 2009 xls
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - THIRD QUARTER 2009
493 CTS-EN JURIS-JUDIC1AL SUPPT 95179 CTS-Gen Juns-Judicial Suppt
CTS-Gen ‘Juris-Judicial Suppt - Total
493 CTS-JUDICIAL ADMIN
785 .COl`ikOMIC DEVELOPMENT & COMMUNITY AFFAIRS 36600 GIS implementation Support C&E Dev
30501 CED Appl cation - HA Support
95785 Comm & co Developmt
Econolni.c Development & Community Affairs - Total
13002 CTS-eFiling - 50%
95174 CTS Judicial Admin
CTS-Judic.rat Admin - Tolal
36545 C..11S Implementation Suppo-1 EMS
36546 ERP Application - HMV Support
98990 Emergency Response
ERP - Total
20031 1DMS Support-Equalization 40%
23012 Oracle Support-Equalization - 2%
24005 SQL Server Supp-Equatization - 10.5%
313/5 Equai - Developmerio.
36505 GIS Implementation Support Equalization
36506 Equal Application - HAN Support
36507 Equal LAMS Support/We
36501 Land System Enharic,ements - Equal (54%)
36701 Land System Maintenance- Equal (50%)
36801 Land System Support - Equal (50%)
95559 User Support/Equal
95562 Equalization. DVr Suppoil
95570 Equalization - OW Maintenance
95693 Equal-System Maintenance
95699 9S&A %taste, Apprassat Sup2Maint
rquali7ation - Total
$,63,q1Q.U.
Vico
a510 35
$478.00
219.00
0.00
$30.50
0.00
S1,439 50
3,654.64
6,433.51
21,500.00
527.50
10,856.50
0 00
1,096.76
8,58-i .53
23,508.13
0.00
5,088 50
0.00
510.00
47 571,50
$5301000
$96 510.35
5647.00
530.50
$130,593.13
23001 Oracle Support - FiacalServ - 15.6% $10,963.91
23013 Oracle Support - I-IR-AG:Ng/Budget -5 2% 3,654.64
2006 . SQL Serv Supp - HR-Act g - 1.75% 1,072 25
4-021 FS-System/Customer Support 55,469.40
4 , 022 FS-System Maintenance 3,995 00
4.023 FS-System Enhancements 1,547.00
4 024 FS-New Development 3.00
4 076 BUD-System/Customer Support 0.00
4-077 BUD-System Maintenance 0.00
4-079 rs - DIN Support 612.00
4. 081 FS - OW Maintenance 0.00
96001 Human Res - Acct 40% 13 163 40
96003 Human Ties- B-udget 201'0 .5,51 .70
Fiscal Services Adrnin - Total
560 FISCAL SERVICES AMIN
$9/ 362 30
$719.80
871 OD
702 00
1t295
11 ,691.50
63,654.64
8,578 01
0.00
157,274.75
16 146.25
$3,654.64
1,072.25
122.00
0.00
0.00
0.00
13 163.40
$25,779 80
$185,665.65
$18,012.29
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT SUPPORT DETAIL - THIRD QUARTER 2009
840 HEALTH DIVISION
843 HEALTH - ENVIRCIMENIAL_
680 HUMAN RESOURCES
20002 IDMS Support - CHAMPS - 20%
35575 GIS Implementation Support llealth
37025 CHAMPS. P 0 P
95563 User Support-Health
96842 Health Admm
Health - Total
23005 Gracie Support - EH Ptcjects - 5 2%
24014 SQL Server Si. ppt - Ehealth 14%
31002 Environmental
64200 EH - Projects
84300 Ehealth Program
Health-Environmental - Total
23014 Orade Support-HR/Personnel - 5.2%
24007 SQL Server Suppport-11R/Personnel - 1,75%
44041 PER.SysterniCuslerrer Support
44047 hiR-Systerns Maintenance
44044 HR-New Development
95556 HR User Supt
96002 Human Res-Personnel 40%
Human Resources - Total
Page 7 of 13 IT Ouederly Dovollopmerd Eliihria 34d CrIr 2009 4K Prepared by Infoimalon -rectumIfx2s , e29f20,09
907 LIBRARY - LIBRA.R.Y. ADMIN
872 MEDICAL EXAMINER
$2 197.00
$122 00
$10,703.70
S5,054 91
$14,615.01
epared by Iniarmation Technology 7/29,2409 Page 8 el 13 IT a Arterly Develdprl.tdt Billing 3rd Qtr 2009 Ids
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT ! SUPPORT DETAIL, - THIRD QUARTER 2009
710 MSU EXTENSION -DA)S_LAND
91405 Library Board $122.00
library - Library Admin - iota! S122.0L1
24002 SQL Server Support - Medical Exam - 3.5% S2.144.51
87202 Medical Examiner - Customer Support 8,977.00
Medical Examiner Total $11,121.51
95676 IVISU Ext Equnpment Maintenance $30.50
MSU Extension - Oakland - Total $30.50
775 PLANNING 0. ECONOMIC DEVELOPMENT
481 PROB-FD JUDiCIAL
512 PROB-ESTATESIMENTL FILTH IMAGE
514 PROB-ES1ATSJEMTL H TH SkJPPQRT
145 PROSECUTOR - OEIVERAL PROSECUTION
637 RECORDS RETENTION
95600 REDS-Customer/System Support $1,338.00
95736 PEUS - DIN Support 0.00
95767 PEDS - DVV Maintenance 854.00
PEDS - Total
95158 PC-Judicial Mm-Family Judges 122 JJQ
Prob-F ID Judicial - Total
95707 prob-p.stiMntl 1111h Image 110,703 70
Prob-Estirvintl Hlth Image - Total
24010 SOL Serv Supp.PCT-Est/Mental - 3.5% $2,144.51
62198 Plati-EstIMnt1 HMI Support 2,910.40
Prob-EstiMntl Hlth Support - Total
24016 SQL Server Supp - Proescutors 3,5% $2,144.51
95622 Proseculor/Ex ecJlive 9,57300
97001 Prosecutor Data Proc 958.50
Prosecutor - Total
44052 Rec-System Ma.ntenance S0.00
44053 Rec-System Enhancements 976.00
44054 Rec-New Development 33,907.25
95636 Mail Room 0.00
Roc:ads Retention - Total $34,883.25
650 REIMBURSEMENT
195F§IgFilFF
191 SHERIFF - CLEMIS
206 SHERIFF - LE SUPPORT SERV ADNIIN
445 2J_U PP OR T SERVICES
600 TIREASUP FR
67.775.14
$1,188.00
Preps, ed by fnfcrmation Technology, 7/2912009 Page 9 of /3 IT 'Quarterly Development Dlling 3val OSI 2.009.X19
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2009
95469 R.eirribursement Division $0.00
95470 R.eirribursement Syslem 17,317.90
95542 Reimburse User Support 0.00
Reimburse! nent - Total
12001 C)C Sn -Courts/C nrninal Warehouse $713.50
23009 Oracle Suppport OCSEVC TS Crim VVise - 2.5% 1,327.32
97163 Sherff 93,516.50
97165 S*erift-DW Support 9057..00
97166 Sheriff-OW Maintenance 0.00
Sheriff Tatar
23015 Oracle Suppport - Sheriff / CLEMIS -5.2% $3,654.64
96163 Sheriff - CLE.MIS 4,12950
Sheriff - CLEWS - lotal
20600 Results. Application Reporting $1 188 00
Sheriff - LE Support Serv Almin - Total
23002 Oracle Supyort - Supp Serv - 5.2% $3,654.64
24011 SQL Server Supp - Suppt Services 7% 4,259.01
44500 Support Services 4,570.00
Support Serv'ces - Total
23006 Oracle Support - Del Tax - 5.7% $3,654.64
23016 Oracle Support - Treasurer - 10.4% 7,309.28
36515 GIS Implementation Support-Treasurer 0.00
36515 Treasurer Application - HAN Support 10,248.00
36602 Land System Enhancements - Tress c50%) I 096.75
36702 Land System Maintenance • Treas (50%) 8,581.50
36802 Lard System Support - Trees 50%)1 23,508.12
44061 Fre-System/Customer Support 17,006.50
44052 Tre-System Maintenance 1,170.00
44063 Tre-System Ennaricements 0.00
44064 Tie-New Development 1,041.00
44080 Tre-DW Support 14,333.00
44062 Tre-DW Maintenance 852 00
55008 Del Tax On Line 366.00
95303 Del Tax System Maintenance 6.344.00
95561 User SupporlfDel Tax 15,850.00
95615 BS&A Annual Tax Support 35.493.25
reasurer Total
$17,317 90
6104,616 32
$12.51365
$112,054.f:,,4
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - THIRD QUARTER 2009
910 VETERANS aRVICEZ 95551 Veterans Customer Support $54.00
Veterans Services - To131 $54 00
730 WATER REWURCE COMMISSIONER 24008 SQL Server Supp VVRC 3.5% 52,144.b1
28007 Water Resource Commissioner 246.00
28010 VVRC - Customer Support 34,47'3 50
28011 Water Resource Commissioner Application 20,120.00
36520 GIS1mplernertation Support WRC 25,324.60
36521 WRC Application -11/W Support 1464.80
Waler Resource Commissioner - Total $21,773 31
540 52/1 DISTRICT COURT - NOVI 14002 CT Sr DW Support-52/1 - 6.25% $0.00
15002 C1S-DW Mai nt 52;1 - 6,25% 0.00
95527 DC Supri.• 5211 - 25% 8, 512. 38
5711 Dist lot Court - Total
550 5212 DISTRICT COURT - CLARKSTON 14003 CTS-DW Support-521? • 5.25% 50.00
15003 Cl S-OW Maint 52/2 - 625% 0.00
95528 DC Sul:rt. 5212 - 25% 8,512.38
5212 District Court - Total
563 52/3 DISTRICT COURT - ROCHESTER 14004 CTS-1W Support-52/3 - 6.25% $000
15004 CTS-DW Maint 5203 - 6.25% 0.00
95529 DC Suprt - 52/3- 25% 512,38
52/3 District Court - Total
530 5214 DISTRICT COURT - TROY 14005 CTS-DW Support-5214 - 6.25% 50.00
15005 CTS-DW Maint 52/4 - 6.75% 0.03
95530 DC Suprt- 5214 - 25% 5,517.36
52/4 District Court. Total
$8.512.38
$8,512.36
$8,512.38
58,512.38
Pi epar !red by {Mee MailOn -r ethnology. 7125/2009 Page 10 o 13 IT Querleth Development Billtng 3ra ON 2009 AS
PI egarad t totormation 1 e.thnola%• 7£7.9t701719 Page 41 of i IT Quarterly Dev'eloprnen!BAng 3rd Qtr 20C9.xls
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2009
c05,t it DIRECT FUNDS
055 CLEMIS 20003 IDMS Support - 5 6',1, $719.80
23018 Oracle skrouit - Sheriff CLEMIS 52% 3.654.61
24004 SQL Server Support :24 5% 15,011.52
90507 CAD Customer Support 0.00
95409 CRISNET1CLEMIS LRM 000
95430 CI .EMIS Maintenance 18,671.50
95431 CLEWS Enhancements 0.00
96432 CLE MIS Adhoc Reports 000
98003 CLEMIS User Support U.0.0
CLEM'S -• Total $38,057.43
056 CLEM* FUND 63500 63500 Ct.EMIS Fund $2,562.00
CLEMIS 63500 Fund - Total 52 562.00
719 CLERKIROO AUTOMATION FUND 95719 Register of Deeds Autoiilattion 1$6,763.00
Clerk/ROD Automation Fund - Total $85,763.0(1
669 CAMS/CVT DATA CONVERSION 56901 CAMSICVT Data Conversion $27 526 /0
CAMS/CVT Data Conversion. - Total $21,526.71)
559 COLLABORATIVE ASSET MOT SYS 55901 Goilabortive Asset Mgt Sys $44,949.79
Collattorlive Asset Mgi. Sys - Total $44,949. /(.)
661 COMMUN & HMF IMPROVEMENT 66103 COMM Dev User Support $122.00
Commurt & ilome Improvement - Total $122.00
471 CTS-FOC-EXP-CS ENFORC-IMAGL 92194 C:TS-FOC-Fxp-GS E.nf-Image $21.437.43
CTS-FOC Exp-CS Ent-Image - Total 621,407.40
507 CTS-FOC EP-CS E.NFORCEME9T 92193 CTS-PZIC Enfotc-Dev $8,772,90
CIS-POC Exp-CD F.ntorc.-Dev - 1 otal $8.772.00
210 FIRE RECORDS MANAGEMOT SYSTEM 21010 Fire Records Mgmt Fund 531 $497.00
24001 SQL Server S.ipporl - FRMS 3.5% 2 144.51
FiCe. Records Management %Stein - Total $2636 51
SL) FIVISO 21001 h Mg.° $122.00
24013 SQL Seiver Sum - FM&O 2.144 51
75503 FM1.0 Development 2 928 00
1M60 - Total $5 194,51
50.00
76000 I-M - SOC Webcasting
rm - SOC Webcast ng - Total
750 FM - BOC WEEIQASTING
$3,6b4.64
.3543 00
$000
456l50
Lf 1_ 8372,2
$2,185.00
61.00
1401,00
$0.00
$758.50
2,156.50
252.50
0 00
5,521.75
21,884.00
42.958.25
10,750.25
15,243 75
2 114,00
8,143.VU
$3.0_0
$4,240.50
1122.190 84)
20,032.00
76,400.25
$38,597.64
$0.00
$45,866.50
$11 837.00
54,647.00
$0.00
5109.532.50
$0.00
$4,240.50
Piepaitwl by Infaimalion 1eel-mology.(729)21)09 Page 12, or 13 11 QUalleriy DerelopmtnlerlItng 3rd Oh 2904 xis
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - THIRD QUARTER 2009
757 FM-WK RELEASE1JAK, MGMTNIDEQ CONF
303 HEALTH-SIOTERRORISM UNIT
811 HEALTH - PT - CRI GRANT
751 JT - TELEPHONE COMM
653 Q.C. INT ERNATIONAL AIRPORT
187 OCSO - JAIL VISITATION PROJECT
770 ',ARKS AND RECReAT(ON
791 RADIO COMMIUNICATI9N - ESTI
653 SECURITY CAMERA PROJECT (RAOI(;) FUND)
601 TREASURER- DTRF
23004 Oracle Support - Oak Video - 5.2%
75/00 Fac Mgmt - Video Arraignments
FM-Wk Fel/Jail Mgmt/Video Cora Total
80133 Health - Sioterrorism Unit
Health Bioterrorism Unit - Total
Health - PT - CRI Grant
Health - ST - CFI Grant - Total
76102 Tel Comni - Customer Support
IT. - Telephone Comm Total
36540 GIS Implementation Support-Aviation
65301 Airport User Support
65310 0 C. Aleporl - New Development
0.0. International Airport-Total
97187 OCSD - Jail Visitation Project
OCSD - Jail Visitation Project - Total
36530 GIS Implementation Support - Parks
44066 PRADM-SysterniCuslomer Support
44068 PRADM-System Enhancements
77010 PRADM-Technology Assessment
77130 Yr 1 - Program Management
77110 Yr 1 - Asset Theme Development
77120 Yr 1 - Network C;onneclivity
77130 Yr 1 - Hardware PetreSn
77140 Yr 1 - Point of Sale
77200 Yr 2 - Program Management
95419 PRADM41,dministra'.ion
Parks & Recreation - Total
79101 Radio Communications - F911
Radio C•omminications - E911 - 1 otal
66300 Security Camera Project (Radio Fund)
Security Camera Project ,Radio Fund) • Total
Treasurer's Office System
Drain Apportionment
Michigan Business Tax
Treasurer DTRF - Total
81100
18010
18050
18060
$3,654.64
14 091 25
$1e,745 89
656 WATER RESOURCES ACCT 23011 Oracle Supp - Water & Sewer Acct 5 2%.
95659 VVater Resources Aczt.g
Water Resources Acct q • Iota'
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT SUPPORT DETAIL - THIRD QUARTER 2009
546 UASI GRANT (ERP) 12546 UASI Grant (ERP)
UASI Grant LRP) - Total $0.00
Pacl. 13 013 IT Quarterly Del or mentalling 3rd Qtr 2009 xls Preparf,t1 by Irlatmation 7tchrsolngy, 1729.'2009
v/r/s7
Resolution #09163 August 12, 2009
Moved by Middleton supported by Schwartz the resolutions (with fiscal notes attached) on the amended
Consent Agenda be adopted (with accompanying reports being accepted).
AYES: Burns, Coleman, Coulter, Douglas. Gershenson, Gingell, Gosselin, Grelmel, Hatchett,
Jackson, Jacobsen, McGillivray, Middleton, Nash, Potter, Potts. Runestad, Schwartz, Scott,
Taub, Woodward, Zack, Bullard. (23)
NAYS: None. (0)
A sufficient majority having voted in favor, the resolutions (with fiscal notes attached) on the amended
Consent Agenda were adopted (with accompanying reports-trethg-acce-pted).
I HEIN APPROVE THE FOREGOING 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 August
12, 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 12th day of August, 2009.
t
Ruth Johnson, County Clerk
I