HomeMy WebLinkAboutResolutions - 2008.06.12 - 9502MISCELLANEOUS RESOLUTION 108100 May 22, 2008
BY: GENERAL GOVERNMENT COMMITTEE, CHRIST:NE LONG, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - SECOND QUARTER 2008
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 :nformatLon Technology has determined
the Second Quarter 2008 development charges to be $1,415,882.10 and the
imaging development charge to be $1,832.97 for the General Fund/General
Purpose County departments; a:Ti
WHEREAS direct charges to SpeCiai Revenue and Proprietary fund
departments are $471,837.72, non-governmental imaging development are
$195.20, and non-county agencies are $36G.00 for the Second Quarter
2008; and
WHEREAS an appropriation transfer to General Fund/General Purpose
County departments is needed to fund these development charges.
NOW THEREFORE BE 17 RESOLVED that the Oakland County Board of
Commissioners has reviewed the Second Quarter 2008 Development Report
and approves the Second Quarter appropriation transfer as specified on
the attached schedule.
Chairperson, on behalf of the General Government Committee, I
move the adoption of the foregoing resolution.
GENERAL GOVERNMENT COMMITTEE
GENERAL GOVERNMENT COMMITTEE VOTE:
Motion carried unan::.mously on a roll call vote with Hatchett, Crawford,
Potts and Suarez absent.
COST # FUND # ACCOUNT #
1 st Otr 2nd Otr
Oct - Dec Jan - Mar
3rd Citr 4th Otr
Apr - June July - Sept DIVISION Y.T.D.
GOVERNMENTAL FUNDS
Gel Fund [101]
0C-302020 -' 21020-773630
00-302030 - 21020-773630
00-302040 - 21020-773630
00-302050 21020-773630
00-107080 - 14000-773630
00-101020 - 81010-773630
00-501010 - 80010-773630
00-201020 80000-773630
00-201030 -, 85010-773630
00-201050 - 25000-773630
00-2010210- 25000-773630
00-2010401 72190-773630
00-1090101- 71000-773630
00-1010401 13000 773630
00-1010501-
00 30
00 30
00-30'
00-30
00-30
00-.30
06-10
0201-
0401 •
0403-
0301
0301-
0101-
0'01-
00 6010101-
00-10'10115-
0(1-1020501-
00-1020601-
00-1050401-
00-5010303
0-1070601-
0-1070501-
67800-9011502-
0-1090201-
0-3040403-
0-3040101-
0-4010101-
0-1030803-
0-1020701-
0-4030301-
0-403060 1-
0-1030803-
0-7010101-
540
550
.560
.530
6.30
620
005
725
440
410
12,1
7110
522
430
495
506
.483
420
498
•93
015
730
900
080
90-7
872
710
003
775
510
461
145
637
050
195
191
445
(7,00
0
0
0
0
0
0
0
0
0
0
0
II
ri
U
El
8 1020-773630
2 r110 773630
2 220-773630
2 100-773630
2 220-773630
2 130-773630
2 100-773630
8 000-773630
5b010-773630
15090 773630
73010 773630
82020-773630
83010-773630
65040 773630
32030-773630
74000-773630
3190-773630
1000-773630
4010-773630
1060-773630
2050-773630
020 773630
6020-773630
12590-773630
0000-773630
030-773630
6040-773630
2-
2
2
2
2
2
8
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
2ND QUARTER 2008
52/1 - District Court
52/2 - District Court
5213 - 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
Fconomlc Development & Community Affairs
Community Corrections Acfmin
Corporation Counsel
Courts-Business Division
Courts-FD-Judicial Support
Courts-FD-Judicial Support-Admin
Courts-GJ-Famlly Support
Courts GJ-Judicial Support
Courts - Judical 1 Administration
County Executive
Drain Commissioner
Emergency Response & Prep
Ecluali,,ation Division
Fiscal Services - Admin
hiernan Resources
Library Adrnin
Medical Examiner
MSU Extension - Oakland
OC Retirees Assocation
Planning & Economic Development
Probate EstatesilvtenLal Health Support
Probate-FD-Judicial
Prosecuting Attorney - General Prosecution'
Records Retention
Reimbursement Division
Siieriff
Sheriff OLEMIS
Support Services
Treasurer
Sub-Total Fund 101
511,757.17 59,531.66
$11,757.17 $9,531.66
$11,757.17 $9,531.65
511,757.11 $9,531.64
551,562.11 561,825.60
50.00 5793.00
$0.00 $122.00
55,470.00 $0.00
55,455.00 57,646.00
$2,690.79 $3,588.97
$119,711.11 $117,216.85
$2,866.41 $6,446 50
53,182.00 $488.00
S14.302.40 556,425.82
$421.00 $610.00
$3,031.27 $6,582.11
$366.00 $7,989.00
$9,748.61 $9,306.10
$5,811.00 $3,693.00
$37,234.50 $69,467.75
$122.00 $48.80
591 50 5305.00
$71,127.36 $122414.40
$2,569 50 $2,895 00
$120,67.c.1 00 $103,668.08
$245,135.60 $126.481.?
$58,135.95 $44,251.33
$0.00 $732.00
512,152.61 $15,246.35
$30.50 $30.50
$0.00 $6,672.60
$1,464.00 $1,830.00
$8,087.61 $17,336,10
$0.00 $95.00
$14,446.11 $27,607.10
$5,162.25 $16,466.25
$9851.40 $20,717.00
$75,527.39 $94,970.13
53,910.79 54,625.91
$13,551.51 $13,130.68
$175,192.63 $142,241.39
51,132,12.4.59 $1,151,152.82 $0.00 3000
521,288.83
$21,288.83
$21,288.83
$21,28815
5113,387.11
$793.00
$122.00
$5,470.00
$13 101.00
$6,279.76
$236,927.96
$9,312.91
$3670.00
$70,128.22
$'1 .037.00
$9,613.38
$8,355.00
$19,054.71
$9,504.00
$106,702.25
$170.80
$396- 50
5193,601.76
35,464 50
3230,341.14
$371,617.42
$102,387.28
5732.00
$27,398.96
$61.00
$5,,672.60
$3,294.00
$25,423.71
$Q5.00
$42,053.21
$21,628.50
$30,568.40
$170,497.52
$8,536.76
$26,682.19
5317,434.02
$2,283,277A1
Page I of 3 2nd Otr 2008 xis Fri:pared by; leformatinn Techr iiI Kiy, 4/28/200P
CUST # FUND # ACCOUNT #
1st Qtr
Oct - Dtis
2nd Qtr
Jan - Mar
3rd Qtr 4th Qtr
Ap_r June July-Sept DIVISION Y.T.D.
$29,021.30
„467.21
$271,488.51
$35,481.90
p28.820.38
$264,302.28
$64,503.20
54712_07.59
$535,790.79 $0.00 $0.00
$427.00 $427.00 $854.1:1Q
$427.00 $427.00 $0.00 $0.00 $84.0
$1.404440.10 $i,415.88210 $0.00 $0.00 )2,819,92220
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
2ND QUARTER 2008
Health Fund 12211
840 221 20221-1060201-133150-773630
843 221 20221-1060220-134390-773630
/uvenile Maintenance Fund 12931
665 293 20293 1060501-112090-773630
63600-1060101-152000-631365
Health
Health Environmental
Sub-Total Fund 221
Children's Village
Sub-Total Fund 293
DEVELOPMENT FOR GOVERNMENTAL FUND
APPROPRIATION
722 101
512 101
GOVERNMENTAL IMAGING
10 100-2010210-1 25000-773639
10100-3040403 124010-773639
Clerk Image $8,742.79 $3. (35 37 $12,478.16
Probate-Estates/Mental Health Image $244,130 $97.60 $341.60
63600-1080101-152000 630903 TOTAL GOVERNMENTAL IMAGING
DEVELOPMENT APPROPRIATION
$8,986.79 $3,832.97 $0.00_ $0.00 $12,819.76
10100-9090101-196030-773630
SUB-TOTAL GOVERNMENTAL / IMAGING
DEVELOPMENT APPROPRIATION:. $1,413,026.89 $1,419,715.07 $0.00 $0.00 $2,832,741.96
Information Technology Development ($1,413 026.M ($1 .4,1,VLI an 0.00 $0.00 {$2,832 741.k)
TOTAL GOVERNMENT: $0.00 icp.00 $0.1311 $0.00 $0,0111
Page 2 of 3 2nd Qtr 2008 xis Prepared by. Information Technology, 4/28/7008
ACCOUNT # GUST # FUND #
NON-GOVERNMENTAL
DIRECT CHARGES
05:5
056
096
659
507
210
760
757
750
acL3
653
66.3
El(11
546
556
63600-1080101-152000-631302
NON-GOVERNMENTAL IMAGING
17 I $.488.00 $195.20 $58 20 Courts-FCC Exp -CS Enforcement Image
DIVISION
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
2N D QUARTER 2008
1st Qtr
Oct - Dec
2nd Qtr
Jan - Mar
3rd Qtr 4th Qtr
&E - June July - Sept
5110,430.35
$1,494,00
$0.60
$6,1360.00
$51,23790
$5,202.-71
$20,374.00
$35,39076
$12,347.46
$4,592.50
$671,00
$8,997.50
$7.000.25
$122.00
$21,153.50
$474,825.55
$3,738.50
$33,525.51
$7_98,972.51
CLEWS $53,370.87 $57,059.48
CLEMIS FUND 63500 $504.00 $090.00
CLEM'S 2005 IBIS Grant $366.00 ($366.00)
Collaborative Asset Mg1 Sys (CAMS) $0.00 $6,860.00
Courts-FOC Exp-CS Enforcement $13,509.00 $37,728.00
Fire Records Management System $2,517.11 52,685.60
FM-BOG Webcasting 617,626.00 $2,548.00
Fl-Wk Rd/Jail Mgt/Video Conf S29.242.79 57.147.97
F M & 0 $5,434.86 $6,912.60
Health - Flioterrorisin Unit $0.00 $4,592.50
C.C. International Airport $427.00 $244.00
Parks and Recre.ation • Administration $2,714.50 $6,283.00
Radio Corriniurlications Egli $2,312.00 $4..688.25
Risk tilana gement $122 00 $0.00
Security Camera Project (GF) $8,348.00 $12,815..50
Treasurer - DIRF 5176,003.90 $296,821.65
UASI Grant (ERP) $110.00 $3,628.50
Water & Sewer Accounting 512,325.79 $21.198.72
SUB-TOTAL DIRECT CHARGES FOR DEVELOPMENT $327„134.82 5471,837.77 $0.00 $0.00
63600-1080101-15200-630903
NON-COUNTY AGENCIES
63600-1080101-152000-635017
TOTAL NON-GOVERNMENTAL IMAGING 5488.00 $195.20 $0.00 $0.00 $68120
DEVELOPMENT APPROPRIATION
TOTAL COUNTY DEVELOPMENT CHARGES $1,740,649.71 51.891,748.04 $0.00 $0.00 $3,632.397.75
, -
Non-County Agencies $518.5S) $366.00 $884.50
TOTAL DEVELOPMENT CHARGES $1,741,168.21 $1,892,114.04 $0.00 $0.00 $3,633,282.25
Page 3 rag .3 2n.J Qtr 2008 *k Prepared by, Information Technology; 4/28/2008
Cust # GOVERNMENTAL FUNDS
630 ANIMAL CONTROL 24017 SQL Server SLpp - Animal Control $2,255.10
95628 Web License Registratioil 52.'l70.00
95682 Dog System 7,400.50
Animal Control-Total
620 AUDITING 95468 Auditing - Customer Support $793.00
Auditing - Total
005 BOARD OF COMMISSIONERS 91404 BOC - Customer Support $122,00.
BOC - Total
CHILDRENS VII LAGE 95665 Childrens Village $42 /,00,
Childrens Village - Total
:25 CLERK - AMIN 72500 Clerk Admin $0.00
Clerk - Admin - Total
440 CLERK - ELECTIONS 95443 Elections $L646.00
Clerk - Elections - Total
720 CLERK /REGISTER OF DEEDS 20004 lDMS Support Register of Deeds $939.40
24003 SQL Server •Supp ROD 3.5% 2,255.10
36510 GIS Implementation Support ROD 1,910.00
.36511 ROD Application - I1/W Support 0.00
95493 Reg Deeds System Maintenance 0.00
95162 Clerk - DW Support 1,098.00
95163 Clerk - DVV Maintenance 244.00
95558 User Support/ROD 0.00
95564 ROD - OW Support. (100
Clerk/Reg of Deeds - Total
/22 CLERK - IMAGING 13001 Clerk - eFiling - 50% $0.00
23007 Oracle Support - Clerk Image 5.2% 3,588.97
65420 Clerk - Image Replace 0.00
95158 Clerk - Imaging 146.40
Clerk - Imaging - Total
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT SUPPORT DETAIL - SECOND QUARTER, 2008
410 CLERK -JURY COMMISSION $3,588.97
0.00
23008 Oracie Support - Jury Comvil- 5.2%
95512 Jury Commission
Clerk - Jury Commission - Total
$61,825.60
$793.00
$122. 00
$427 00
$0.00
$7..646. 00
$6,446.50
$3,735.37
$3,588.97
Page 1 of 9 2nd (DV 2008 As PreparQd by Information TechnNogy, 428/2008
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER, 2008
724 CLERK - LEGAL RECORDS
522 COMMUNITY CORRECTIONS-ADM1N 'CO)
24015 SQL Server Stipp - Circuit Ct 3.5%
95189 Circuit Court System
Cleric - Legal Records - Total
23003 Oracle Support-Comm Corr - 5.2%
24012 SQL Server Supp - Community Corr 3.5%
52200 Comm Corr-Admin (County)
52201 Comm Corr-DW Supp
Community Corrections - Total
$2,255.10
114M1,75
$3,588,97
2,255.10
48,409.75
2 172.00
5117,216,85
$56,425.82
785 COMMUNITY & ECO DEVELOPMENT 36500 GIS Implementation Support C&E Dev $457,50
36501 CED Application - HAN Suppun 30.50
95785 Comm & Eco Developmt 0.00
Community a Eco Dev - total
430 CORPORATION COUNSEL 95501 Corporation Counsel $610.00
Corporation Counsel - Total
015 COUNTY EXECUTIVE 95656 County Executive Support 1305.00
County Executive Support - Total
495 CTS-BUSINESS ENVISION 12002 Circuit Ct-Courts/Crirninal Warehouse 50% SC.00
14001 CIS-OW SLlpportiCircuit Ct • 75% 4,504.13
15001 C S OW MaintiCircuit CF - 7.5% 283.5e
23010 Oracle Support-CCT/CIS Grim Whse 2.43% 1;104.48
CTS-Business Division - 'total
$488.00
$610.00
$305.00
$6,582.11
506 CTS-FD-JUDICIAL SUPPORT 95187 CTS FD/Adrnin - Fam Suppl Staff $7,989.00
CTS-FD•Judicial Supon - Total
483 CTS-FD-JUDICIAL SUPPORT-ADM 24009 SQL Serv Supp - CTS-Jud Sup Adm - 3.5% $2,255.10
95193 CTS-FD-Judicial Supporl-Adm 7,051.00
CTS-FD-Judicial Suppon-Adm Iota!
420 CTS - GJ - FAMILY SUPPORT 95195 Or Cr! Admin 53,693_Q0
Courts - GJ - Family Support - Total
498 CTS-GEN JURIS-JUDICIAL SUPPT 95179 CTS-Gen Juris-Judicial Suppt $69 467.75
CTS-Gen Juris-Judicial Suppt - Total
$7,989.00
$9,306.10
$3,693.00
$69,467.75
Page 7 of 9 2nd QV 2038.xls /prepared by: tnforrnalian Technology; 4/28/2008
493 CTS-JUDICIAL ADMIN
730 DRAIN COMMISSIONER
900 EMERGENCY RESPONSE & PREPAREDNESS
740 EQUALIZATION
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - SECOND QUARTER, 2008
13002 CTS-eFiling - 50% $0.00
95174 CTS-Judicial Admin 48.80
CIS-Judicial Adrnin - Total
24008 SQL Server Supp - Drain 3.5% $2,255.10
28009 Drain Administration 0.00
28010 Drain - Customer Support 24,407.50
28011 Drain Commissioner Application 67,082.80
36520 GIS Implementation Support Drain 4,566.00
36521 OCDC Application •- I-I/W Support 24,163.00
95669 Water & Sewer Accounting 0.00
Drain Commissioner - Total
36545 GiS Implementation Support EMS $1,799.50
36546 ERP Application - HAN Support 1.09550
98990 Emergency Response 0.0Q
ERP - Total
20001 IDMS Support-Equalizaton - 40% $1,878.80
23012 Oracle Support-Equalization - 5.2% 3,588.97
24005 SOI. Server Supp-Equalization - 10.5% 6,765.31
31075 Equal - Development 0.00
36505 GIS Implementation Support Equalization 65.00
36506 Equal Application tifW Support 12,505.00
36507 Equal LAMS SupportiMtco 0 00
36601 Land System Enhancements - Equal (50%) 4,581.00
36701 Land System Maintenance - Equal (50%) 3,757.25
36801 Land System Support - Equal (50%) 29,000.25
95559 User SupportfEqual 0.00
95562 Equalization - DW Support 7,204.50
95570 Equalization - DW Maintenance 216.00
95693 Equal-System Maintenance 244.00
95699 BS8A Master Appraisal Sup/Maint 33 862.00
Equalization - Total
$48 80
$122,474.40
$2,895.00
$103,668.08
rage3c!9 2nd (2tr 2008.xls F'repared by Information Technology; 4i28n2008
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER, 2008
660 FISCAL SERVICES ADMIN 23001 Oracle Support - Fiscal Serv - 15.6% $10,766.89
23013 Oracle Support - HR•AcctgiBudget - 5.2% 3,588.97
24006 SQL Serv Supp HR-Acctg - 1.75% 1,127.56
44021 IS-SystemiCristomer Support 23,817.00
44022 FS-System Maintenance (33,069.30)
44023 FS-System Enhancaments 59,071.50
44024 FS-New Development 5,608.00
44076 BUD-System/Customer Support 61.00
44077 BUD-System Maintenance 0.00
44079 ES - DW Support 6,309.00
44081 Is DW Maintenance 0.00
96001 Human Res - Acct 40% 32,800.80
96003 Human Res - Midget 20% 16 400.40
Fiscal Services Ai-1min - Total
840 HEALTH DIVISION 20002 IUMS Support - CHAMPS - 20% $939.40
36525 GIS Implementation Support I. lealth 0.00
37025 CHAMPS - P.O.P. 3,024.00
95563 User Support-Health 19,343.00
96842 Health Admin 12175.50
Health Total
843 HEALTH - ENVIRONMENTAL 23005 Oracle Support - Ft I Projects 5.2% 33 588 gr
74014 SQL Server Suppt - Fhnalth 14% 9,1120 41
37002 Environmental 0 tO
84200 EH Projects 181,851 50
84300 Ehealth Program n 34,359 50
tlealth-Environmental row!
680 HUMAN RESOURCES 23014 Oracle Support-HR/Personnel - 5.2% $3,588.97
24007 SQL Server Suppport-HR/Personnel•1.75% 1,127.56
44041 PER-Sys temiCuslomer Support 662.00
44042 HR-Systems Maintenance 216.00
44044 HR-New Development 0.00
65556 HR User Supt 0.00
96002 Human Res-Personnel 40% 38 656.80
Human Resources - Total
$126,481.82
$3548190
$228,820 38
$44,251 23
Page 4 of 9 2rd Qtr 2008 xis rrepored by Information Technolegy. 4/28/240P
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER, 2008
907 LIBRARY - LIBRARY ADMIN 91405 Library Board $732.00
Library - Library Admin - Total $732.00
872 MEDICAL EXAMINER 24002 SQL Server Support - Medical Exam - 3.5% $2,255.10
87202 Medical Examiner - Customer Support 12 ,991.2,5
Medical Examiner - Total
710 MSU EXTENSION - OAKLAND 95876 MSU Et Equipment Maintenance 530.5c
MSU Extension - Oakland - Total
003 OC RETIREES ASSOCIATION 98872 CC Retrees Assoc $5,672.60
CC Retirees Assoc - Total
$15,246.35
$30.50
$5,672.60
775 PLANNING & ECONOMIC DEVELOPMENT 95786 PEC)S - DW Support $1,098.00
95787 PEPS - DW Maintenance 732.00
PEDS - Total
481 PROB-FD JUDICIAL 95168 PC-Judicial Adrn - Family Judges $95.00
Prob-FD Judicial - Total
!-)12 PROB-ESTATES/MENTL HLTI-I IMAGE 95207 Prob-Est/Mntl Hlth rriage $97.60
Prob-Est/Mnti 111th iiige - Total
510 PROB-ESTATES/MENTL HLTH SUPPORT 24010 SQL Serv Supp T-Fst/Marrtal 3.5% $2,255 10
92198 Prob-EstAtinti Hlth Support 15,081.00
Prob-Est/Mntl Hlth Support - Total
145 PROSECUTOR - GENERAL PROSECUTION 24016 SQL Server Supp - Proesculors 3.5% $2,255.10
95622 Prosecutor/Executive 17,252,00
97001 Prosecutor Data Proc 5100.09
Prosecutor - Total
637 RECORDS RETENTION 44052 Rec-System Maintenance $0.00
44053 Rec-System Enhancements 4,952.25
44054 Rec-New Development 11,514.00
95636 Mail Room C.00
Records Retention - Iota!
$1,830 00
$95.00
CO
$17,336.10
$27.607.10
$16,466.25
F'reparft1 by Information Technology; 4..28F2008 Page 5 of 9 2nd Qtr 2008 xis
650 REIMBURSEMENT
195 SHERIFF
191 SHERIFF - GLEMIS
445 SUPPORT SERVICES
4j0 TREASURER
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER, 2008
95469 Reimbursement Division $0.00
95470 Reimbursement System 10,054.00
95542 Reimburse User Support 10 663.00
Reimbursement - Total
12001 OCSD-Courts/Criminal Warehouse $0.00
231309 Oracle Suppport OCSID/CTS Crim Whse - 2.6% 1, 794.48
97163 Sheriff 19,322.90
97165 Sheriff-DW Support 12,832. 75
97166 Sheriff-OW Maintenance 1,920.00
Sheriff - Total
23015 Oracle Suppport - Sheriff I CL EMIS - 5.2% $3.588 0'
96153 Sheriff- CLEM IS 41,.037.00
Sheriff - CLFIVIIS - Total
23002 Oracle Support - Sum Serv - 5.2% $3,588.97
24011 SQL Server Supp - Suppt Services 7% 4,510.21
44500 Support Services 5,031.50
Support Services - Total
23006 Oracle Support - Del Tax - 5.2% $3,588.97
23016 Oracle Support - Treasurer - 10.4% 7.177.92
36515 CIS Implementation Support -Treasurer (LOU
36516 I reasurer Application - I Support 7,151.00
36602 Land System Enhancements - Treas (50%) 4,581.00
36702 Land System Maintenance - I reas (50%) 3,757.25
36802 Land System Support - Treas (50%) 29,000 25
44061 'Ire-System/Customer Support 16,015.50
44062 Tre-System Maintenance 7,182.06
44063 Tre-System Enhancements 7,334.00
44064 Tre-New Development 5.00
44080 Tre-DW Support 7,869.00
44082 Tre-DW Maintenance 7,407,00
95008 Del Tax On Line 458.00
95303 Del Tax System Maintenance 6,273.00
95561 User Support/Del Tax 10,317.00
95615 BSSLA Annual Tax Support p8,488.5P
Treasurer - Total
$20,717.00
$94,970 13
$4,625 97
$13,130.68
$142,241.39
PAIDP 6 of 9 2nd Qtr 2006 xls Prrmared by Information Technology., 4,28..2008
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - SECOND QUARTER, 2008
540 52/1 DISTRICT COURT - NOVI
550 5212 DISTRICT COURT - CLARKSTON
b60 52/3 DISTRICT COURT- ROCHESTER
530 52/4 DISTRICT COURT - TROY
14002 CTS-DW Support-52/1 - 6.25%
15002 CTS-DW Maint 52/1 - 6.25%
95527 DC Suprt- 52/1 - 25%
52/1 District Court - Tolal
14003 CTS-DW Support-52/2 - 6.25%
15003 CTS-DW Maint 5212 - 6.25%
95528 DC Suprt- 5212 - 25%
5212 District Court - Total
14004 CTS-DW Support-5213 - 6.25%
15004 CTS-DW Main 52/3 - 6.25%
95529 DC Suprt - 5713 - 25%
5213 District Court - Total
14005 C Suppor1-52/4 - 6.25%
15005 CTS-DW Main! 5214 - 6.25%
95530 DC Suprt- 52/4 - 25%
52/4 Districk Court - Total
$375.34
23.63
9,132.69
$375.34
23.63
9 13Z69
$375.34
.23,63
9,132.69
$375.35
23.61
9,132,58
$9,531.66
$9,631.66
$9,531 66
$9,531.64
Frepared b Infoffnation recbnology: 4/28/2008 Page7 of 9 2nd Qtr 2008.xls
Oust g DIRECT FUNDS
055 CLEWS
056 CLEM'S FUND 63500
096 CLEMIS 2005 IBIS GRANT
659 COLLABORATIVE ASSET MGT SYS
71 CTS-FOC-EXP-CS ENFORC-IMAGE
'50 7 CTS-FOC EXP-CS ENFORCEMENT
21E71 FIRE RECORDS MANAGEMENT SYSTEM
750 FM&O
760 FM - BOC WEBCASTING
$2,685.60
$6,912.60
$2,548.00
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT f SUPPORT DETAIL - SECOND QUARTER, 2008
20003 IDMS Support - 56% $939 40
23018 Oracle Support - Sheriff CLEMIS 5.2% 3,588 86
24004 SQL Server Support - 24.5% 15.785 72
90507 CAD Customer Support 0.00
95409 CRISNET/CLEMIS 1.RM 0.00
95430 CLEWS Maintenance 2,939.50
95431 CLEMIS Enharic.ements 2,876.00
95432 CLEMIS Adhoc. Reports 0 00
98003 CLEMIS User Support 3093090
CLEWS - Total
63500 CLEM4S Fund $990.00
Cl FMIS 63500 Fund Total
63596 2005 Federal Approp IBIS Project {$366.00)
CLEMIS 2005 IBIS Grant Total
65901 Collabortive Asset Mgt Sys $6,860.00
Collobortive Asset Mgt Sys total
02194 CIS•FOC Exp-CS Enf Image $19520
CIS-FOC Ey) CS E-it-Irnage - Total
92103 CTS-TOC Exp-CD Enforc-Dev 13 r,728.00
CTS-FOC Exp-CD Enforc-Dev Total
21010 Fire Records Mgmt Fund 531
24001 SQL Server Support - FRMS 3.5%
Fire Records Mgmt - Total
21001 FM&O
24013 SQL Server Supp - FM8,0
75503 FM&O Development
FM&O - Total
76000 FM - BOC Webca sting
FM - BOC Webcasting - Total
$430.50
2.255,10
$0.00
2.255.10
4.57-510
$57,059 48
8990.00
($366.00)
$6,860.00
$19b 20
$37,728 00
Prepared by: Information Technology; 4128.P2008 F'a 8 of 9 2nd Qtr 2008 xI5
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - SECOND QUARTER, 2008
757 FM-WK RELEASE/JAIL MGMTNIDEO CONF
803 HEALTH-BIOTERRORISM UNIT
653 O.C. INTERNATIONAL AIRPORT
7 0 PARKS AND RECREATION
791 RADIO COMMUNICATION - E911
695 RISK MANAGEMENT
1:0 SECURITY CAMERA PROJECT (GF)
P•Ci TREASURER - DTRF
546 UASI GRANT (ERP)
656 WATER & SEWER ACCTG
23004 Oracle Support •- Oak Video 5.2%
75700 Fac Mgmt - Video Arraignments
FM-Wk Reli..lail MgmlNideo Conf • Total
80130 Health - Bioterrorism Unit
Health - Bioterrorism Unit - Total
36540 GIS Implementation Support-Aviation
65301 Airport User Support
0.0. International Airport- total
36534 GIS Implementation Support Parks
44066 PRADM-SysterniCustorner Support
770 10 PRADM Technology Assessment
Parks & Recreation - Fetal
79101 Radio Communications •- E911
Radio Communications •- E911 - Total
44036 RSK-Systern!Customer Support
95695 Risk Management
Risk Management - Total
66300 Security Camera Project (GF)
Security Camera Project (GE) - Total
Treasurer's Office System
Drain Apportionment
Treasurer DTRF - Total
12546 UASI Grant (ERP)
UAS1 Grant (ERP) - Total
23011 Oracle Supp - Water & Sewer Acct'g - 5.2%
95669 Water & Sewer Accrg
Water & Sewer Accrg . Total
$3,588 97
3 559.00
$4.592_50
$30.50
213.50
$122.00
610.00
5,551 00
$4,.688.25
$0.00
0.00
512 1550
$289.803 90
7Q17 75
$.3,.628.50
$3,588.97
17_ 609,75
18010
18050
$7,147.97
$4,592.50
$244.00
$6,263.00
$4„688.25
$0.00
$12.815.50
$296,821.65
$3,626.50
$21,198 72
Prepared la), fnformation Technology, 4/28,2008 2nd Oa 20013 As Page 9 of 9
'
Resolution #08100 May 22, 2008
The Chairperson referred the resolution to the Finance Committee. There were no objections.
FISCAL NOTE (MISC. 4081C0) June 12, 2008
BY: FINANCE COMMITTEE, MIKE ROGERS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - SECOND QUARTER 2008
DEVELOPMENT APPROPRIATION TRANSFER
TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS
Chairperson, Ladies and Gentlemen:
Pursuant to Rule X=I-C of this Board, the Finance Committee has
reviewed the above-referenced resolution and finds:
1. The resolution appropriates and charges the Information
Technology Second Quarter 2008 Development cost to benefiting
departments.
2. The second quarter development charges are $1,415,882.10;
imaging development charges arc $3,832.97 for General
Fund/General Purpose departments; direct charges to Special
Revenue and Proprietary fund departments are $471,837,77, non-
governmental imaging development are $195.20, and charges to
non-county agencies are $366.00.
3. The respective departmental Fiscal Year 2008 budgets are to be
amended as specified in the attached detail schedule.
FINANC COMMIT E
FINANCE COMMTITEE
Motion carried unanimously on a roll cal= vote.
c.././7/41/
Resolution #08100 June 12, 2008
fvloved by Rogers supported by Nash the resolutions (wtth fiscal notes attached) on the amended
Consent Agenda be adopted (with accompanying reports being accepted).
AYES: Coulter, Crawford, Douglas, Gershenson. Gingell, Gosselin. Gregory, Greirnel, Hatchett,
Jacobsen, Kowa, Long, Middleton, Nash, Potter. Potts. Rogers, Scott, Spector, Woodward,
Zack, Bullard, Burns. (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 being accepted).
WEBY APPROVJ THE FOREGOING RESOLUTION
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
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 June
12, 2008, 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 June, 2008, eae
Ruth Johnson, County Clerk