HomeMy WebLinkAboutResolutions - 2005.09.01 - 27988MISCELLANEOUS RESOLUTION #05159 August 18, 2005
BY: GENERAL GOVERNMENT COMMITTEE, WILLIAM PATTERSON, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - THIRD QUARTER 2005
DEVELOPMENT APPROPRIATION TRANSFER
TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS
Chairperson, Ladies and Gentlemen:
WHEREAS all data processing 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 2005 data processing development charges to be
$1,191,499.20 and the imaging development charge to be $56,305.25 for
the General Fund/General Purpose County departments; and
WHEREAS direct charges to Special Revenue and Proprietary fund
departments are $447,684.00 and non-county agencies are $0 for the
Third Quarter 2005; 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 2005 Data Processing
Development Report and approves the Third 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
14)0, k PottZ,v,
General Government Committee Vote:
Motion carried on a roll call vote with Long, KowaII, Molnar and Coulter absent.
GOVERNMENTAL FUNDS
General Fund 11011
2-32-20120020001-8030
2-32-205200-2000843030
2-32-301200-20001-6030
2-32-305200-20006-6030
2-32-401200-20001-0030
2-32-405200-20008-0030
2-32-501200-20001-8030
2-32-505200-2000043030
2-17-802200-80001-8030
2-11-220100-10000-6030
2-21-220100-10000-6030
2-21-230100-31000-6030
2-21-250100-01000-6030
2-21-221000-01000-8030
2-21-240100-11000-8030
2-21-220600-40000-6030
2-19-210000-10000-6030
2-17-402200-70001-8030
2-11-25010020000-6030
2-36-220000-12000-8030
2-35-244000-33000-8030
2-35-243000-32000-6030
2-35-242000-11000-6030
2-35-242000-44000-6030
2-35-243000-11000-6030
2-36-230000-22100-6030
2-35-230000-31200-6030
2-35-230000-12000-6030
2-35-230000-2120043030
2-35-230000-22200-6030
2-35-210000-11000-6030
2-11-210100-01000-0030
2-81-211001-10000-8030
2-11-101112-65001-8030
2-12-240000-41000-0030
2-14-210000-10000-6030
2-12-501200-26000-6030
2-15-402200-10001-8030
2-13-138502-15100-6030
2-17-912000-1 6000-6030
2-17-501200.50000-8030
2-19-221000-10000-8030
2-34-101200-40001-6030
2-34-403200-40005-0030
2-34-101200-31100-6030
2-34-101200-3120043030
2-41-211000-41700-6030
2-12-401200-40010-6030
2-13-138203-12000-6030
2-12-701200.34000-8030
2-43-023301-20000-6030
2-43-023801-30000-6030
2-13-138203-15100-0030
2-22-221120.01000-6030
Health Fund12211
2-16-201200-33100-8030
2-113-220200-67000-6030
18-636111-10000-0735
IMAGING
722 2-21-221000-01000-8039
512 2-34-403200.40005-6039
184538111-10000-0573
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
3RD QUARTER 2005
1st Otr
22zialE ACCOUNT DIVISION
2nd Ott'
Jan - lider
3rd Qtr
Aor - June
4th Ott
July- Sect Y.T.D,
540 101
541 101
550 101
551 101
560 101
561 101
530 10/
531 101
830 101
620 101
726 101
440 101
410 101
724 101
720 101
723 101
786 101
522 101
430 101
495 101
474 101
484 101
487 101
492 101
483 101
499 101
420 101
496 101
498 101
500 101
493 101
015 101
730 101
900 101
740 101
755 /01
680 '101
680 101
641 101
872 101
710 101
775 101
509 101
510 101
481 101
479 101
145 101
690 101
637 101
650 101
195 101
191 101
446 101
600 101
840 221
843 221
665 293
52/1 - District Court
5211 - District Court - Probation
52/2 - District Court
52/2 - District Court - Probation
52/3 - District Court
52/3 • District Court - Probation
52/4 - District Court
52/4 - District Court - Probation
Animal Control
Auditing
Clerk - Admin
Clerk - Elections
Clerk - Jury Commission
Clerk - Legal Records
Clerk - Register of Deeds
Clerk - Vital Statistics
Community & Economic Development
Oornmunity Corrections Admin
'Corporation Counsel
Courts-Business Division
Courts-FD Juvenile Support
Courts-FD Juvenile Referees
Courts-FD-Court Services-Admin
Courts-FD-Court Services-Adoptions
Courts-FD-Judiclal Support-Acknin
Courts-GJ-Assignment
Courts-GJ-Family Support
Courts-0.J-JIMS
Courts-GJ-Judicial Support
Courts-GJ-Mecliation
Courts - Judical / Administration
County Executive
Drain Commissioner
Emergency Response & Prep Unit
Equalization Division
FacINties Management
Fiscal Services - Adrnin
Human Resources
Materials Management - Gen Fund
Medical Examiner
MSU Extension - Oakland
Planning 8 Economic Development
Probate - Judicial Admin
Probate-Estates/Mental Health Support
Probate-FD-Judidal
Probate-FD-Judidel Support
Prosecuting Attorney - General Prosecution
Purchasing
Records Retention
Reimbursement Division
Sheriff
Sheriff - CLEWS
Support Services
Treasurer
Sub-Total Fund 101
Heatth
1-lealth Environmental
Sub-Total Fund 221
DATA PROCESSING DEVELOPMENT FOR
GOVERNMENTAL FUND APPROPRIATION
Clerk Image
Probate-F.staterimental Health Image
TOTAL IMAGING DEVELOPMENT
APPROPRIATION
58.764.83 57,766.86 56,451.45 $22.971.73
$30.50 $2,286.25 $1,5819.75 $3,886.50
$8.754,83 $7,785.85 $6,451.45 522,971.73
$30.50 $2,28625 $1,589.75 $3.886.50
58754.83 57,765.85 $6,451.45 $22,971.73
$30.50 $2,26025 $1,589.75 $3,886.50
58,754.55 $7,766.66 $6,451.45 $22,971.65
$30.50 $2,26625 $1,589.75 $3,888.50
$11,400.00 $13,018.00 $68,032.50 $82.450.50
$244.00 $,0.00 $122.00 $366.00
$4,275,00 $1,753.50 $0.00 $6,028.50
53,538.00 $24,438.00 $20,225.00 $48201.00
$4,906.87 $4,241.19 $8,565.75 $17,713.81
$30,300.00 $41,309.20 $22,857.20 $94,466.40
$4,855.80 $4,608.80 $1,488.40 $10,952.60
$6,455.00 $3,799.00 $5,527.00 515,881.00
$44,725.50 ($81.00) $244.00 $4,908.50
$35,302.87 $24,730.89 $16,488.75 $76.522.31
$1,098.00 $976.00 $3,552.00 $5,626.00
$5,684.88 $1,216.09 $2,099.38 $8,980,35
$0.00 $0.00 $0.00 $0.00
$13,513.25 $0.00 $0.00 $13,513.25
$0.00 $0.00 $0.00 $0.00
55,174.00 $7,452.00 $27212.50 $39,838.50
$7,184.85 $2,827.95 $1,827.16 $11,839.96
$21.354.25 $17,522.00 $15,578.00 $64,454.25
$0.00 $0.00 $2,074.00 $2,074.00
$3,834.50 $3.502.00 $1,722.00 $9,058.60
$33,836.50 $37,407.00 317.588.00 $88,831.50
$26,073.50 $3,533.00 $3,402.00 $33,088,50
$38.80 $97.80 $9,424.50 $9,558.70
50.00 $0.00 $0.00 $0.00
$38,977.00 $442,373.50 $46,351.00 $125,701.50
$7.427.00 $751,00 $3,004.00 $11,182.00
$189,425.28 $132,180.78 $93,411.39 $415,017.45
$108.00 $3,540.00 $2,379.00 $86,027,00
$166,479.43 $146,435.54 $93.171.65 $40608062
$49,428.77 $71,429.34 $52,978,64 $173,836.85
$244.00 $1220.00 $432.00 $1,898.00
$13,990,71 538,862.14 $70,605.50 $123,348 44
$732.00 ($732.00) $0,00 $0.00
$1,830.00 513,412.00 $244800 $17,688.00
$9,896.45 $0.00 $0.00 $9.896.45
$77,028,35 $6,188.97 $3232,16 $17,049.48
523,588.00 $5,453.00 $11,820.00 $440,881.00
$0.00 50.00 $00.00 $00.00
$10,947.45 $8,657.50 $28,197,00 $45,801.95
$3,132.00 $1298,00 $8,048,00 $10,478.00
$6,290,00 $5,884.00 $6,389.00 $17.543,00
514,958.40 $12,581.40 $5,88540 $33,415,20
$42,718.43 $72,017.00 575,44988 $240,185,31
$8,803.843 $4,705.22 $10,118,60 523,627.58
$4,322.47 $5,005.19 $8,879.75 $18207.41
;33.778.87 W.184.19 ;37.43175 $999.394.81
5940,620.08 $831,923.19 $806205.55 $0.00 $2,678.808.82
$34.382.80 $28,100.10 $54,252.40 $116.741.10
;5,604.87 399.00770 3327.43525 3432.107.91
$339.987.47 $127,173.89 $381,887.05 $0.00 $548,849.01
iz,214,00 RIMS& 12,15000 $9,420.00
$2214.00 $3.680.00 $3,546.00 $0.00 59,420.00
$982.021.55 Se82.757.00 11.151.49020 19.00 53.137.077,83
$47,554.87 $34.682.99 553,95625 $138,093.91
32,93520 ;1868.20 52.349,00 18.152.0
850,489,87 537.451.19 $55.30525 12,9 $144,244.31
Juvenile Maintenance Fund12931
2-16-501200-25001-6030 ChIldrurrs Village
Sub-Total Fund 293
SUB-TOTAL GOVERNMENTAL I IMAGING DEVELOPMENT APPROPRIATION:
IrktrumtrionTedwidogyDevelopment
TOTAL GOVERNMENT:
$1,033,311.42 51,000,20827 $1,247,804.45 $0.00 $3,281.324,14
f$1.033.311,42) (51.000208.27) (51.247.804.45) bug (53281.324,14)
p_sgi
$0.00 _o a22
90-290000-25000-8030
Prepared WInfennalkarrectati009: riZa.a.P3 SeirrOt(2005.itle"--
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
3RD QUARTER 2005
Ist Otr 2nd Otr 3rd Otr 4th Qtr
ACCOUNT f DIVISION ctqz..Q.eg Jan ._:_tear kir - Arne Jul,/ - Sept
NON-GOVERNMENTAL
DIRECT CHARGES
055 CLENIS 536,179,36 538,382.23 530,974.12 $105.515.70
056 CLEMIS FUND 83500 $1,484.00 $13,044.00 523,673.50 $38.181.50
861 Community & Home Improvement $0.00 $0.00 $206.00 $206.00
103 COPSMORE Grant - Excess Match $39,804.00 (539,804.00) 5000 $aw
471 Courts-FOG Exp-CS Enforcement Image $7,386.40 $9,122.40 $5,742.00 $22250.80
470 Courts-FOC Exp-Family Counseling 50.00 50.00 50.00 Wm
507 Courts-FOC Exp-CS Enforcement Image $1,220.00 $1,342.00 51,52500 $4,087.00
210 Fire Records Management System $22,413.71 53,421.89 $3,103.84 $8.039.44
757 FM-Wk ReU,lall Mgt/Video Cord $57,993.37 $53,241.19 $34,094.75 $145.329.31
758 FM-Jail Mgmt Replacement $0.00 56,076,00 $5,071.00 $11,751.00
750 FM&O $0.00 $1,741.00 $12,749.20 $14,49020
759 F M & 0-Safety Overhead $0.00 $648.00 50.00 $646.00
380 Health - Immunization Grant $1,782.00 $1,556.00 $2241.00 $5,680.00
751 IT - Telephone CommunicationS $0,00 $122.00 $0.60 $122.00
662 Major Department Support Project Fund 5384.031,20 $1135,176.60 1313,483.00 5882,669.80
870 Medical Care Facility $8,938.71 $3,895.89 $3,604.34 $14,438,94
248 Medical Care Facility - Pharmacy $3,294.00 $1,134.00 $1,060.00 $5,508.00
651 0.C. International Airport-GRE Grant $0.00 10.00 $0.00 $0,00
653 o.c. International Airport $1.857,00 $413.00 5415.50 52,685.50
770 Parks and Recreation - Administration $108,00 $108.00 $1244.00 $1,460.00
790 Radio Communications .. $9.730.00 $207.00 $0,00 $9,937.00
695 Risk Management $00.00 50.00 $0.00 $000
656 Water & Sewer Accounting $4.550.87 53,530.19 58,074.76 $16,155.81
850 Worldorce Development $122.00 $0.00 50,00 5122,00
18-638111-10000-0715 SUB-TOTAL DIRECT CHARGES FOR DATA $538.052.81 $26325529 F447,584.09 WAR 51270.105.00
PROCESSING DEVELOPMENT
TOTAL COUNTY DEVELOPMENT CHARGES 51.572.274.03 $1253.456,55 51.095,6110,45 50,00 54.551.420.14
NON-COUNTY AGENCIES
16-636111-100004429 Non-County Agencies Kr& ELM 12,22 14-22 NA4
TOTAL DEVELOPMENT CHARGES 51,572,274.03 51,253,41343.66 51095,11118.45 $0.00 $4,551,421.14
Y.T D,
Prepared by; Inforrnaton Tectwloicww. 7/22J2005 aria* 2005 win
cyst # GOVERNMENTAL FUNDS
630 ANIMAL CONTROL
620 AUDMNG
655 CHILDRENS viLLAGg
725 CLERK - ADMIN
440 CLERK. ELEC1ION4
720 CLERK REGISTER OF DEEDS
$50,193.50
7.539.00
$122.00
$3.546.00
1192
$20225.00
$58,032.50
$122.00
$3,546.00
$0.00
$20,225.00
81,488.40
$75640
366.00
0.00
244.00
0.00
0.00
12ZSLQ
13001
23007
65420
95158
$53,956.25
Clerk • eFiling • 50%
Oracle Support - Clerk Image
Clerk - Image Replace - 21%
Clerk • imaging
Clerk - imaging - Total
722 CLERK - IMAGING $9,424.50
3,532.75
12,844.00
27.855.00
23003
52200
52201
36500
95785
95501
$3.532.75
4.733.00
121.017.212
$5.627.00
$3,832.75
12,658.00
422
$244.00
2.24
$3.55293
$183.00
1,916,38
Ksr_o
$27212.50
)0,00
$1,275.18
352.00
$8.565.75
$22,85720
$6.827.00
$16,488,75
$244.00
$3,552.00
$2,099.38
$0.00
$27.212.50
$0.00
51,627,16
INFORMATION TECHNOLOGY. RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - THIRD QUARTER, 21:105
95628 Web License Registration
95682 Dog System
Anknal Control-Total
95468 Audiling-Cust Supt
Audtting - Total
95665 Childrens Village
Childrens Village - Total
72500 Clerk - Admin
Clerk - Admin - Total
95443 Elections
Clerk -Elections - Total
20004 IDMS Support - Register of Deeds - 20%
36510 GIS Implementation Support-ROD
95493 Reg Deeds System Maintenance
95162 Clerk - DW Support
95163 Clerk - DW Maintenance
95558 User Support/ROD
95564 ROD - DW Support
Clerk/Reg of Deeds - Total
410 CLERK- JURY COMMISSION
724 CLERK - LEGAL RECORDS
723 CLERK • VITAL STA11S11CS
522 COMMUNITY CORRECTIONS-ADMIN (COI
785 COMMUNITY & EGO DEVELOPMENT
430 CORPORATION COUNSEL
495 CTS-BUS1NESS DIV - JIMS
487 CTS-FD-CT SERV-ADMIN
492 CTS-FD-CT SERV-ADOPTIONS
505 C1).01CMI.
483 CTS-FD-JUDICIAL SUPPORT-ADM
23008 Oracle Support - Jury Comm
95512 Jury Commission
Clerk -Jury Commission - Total
95189 Circuit Court System
Clerk - Legal Records - Total
95161 Vital Stats Index
Clerk - Vital Statistics - Total
Oracle Support-Cohn Corr
Comm Corr-Admin (County)
Comm Corr-DW Supp
Community Corrections - Total
GIS Implementation Support C&E Dev
Comm & Eco Developmt
Community & Eco Dev - Total
Corporation Counsel
Corporation Counsel - Total
12001 Courts/Criminal Warehouse
23010 Oracle Support-CCT/CTS Corn Whse
90603 JIMS - Circuit Court 25%
CTS-Business Div- JIMS - Total
95196 CTS-FD-Ct Serv - Admin
CTS-FD-Ct Serv-Admin - Total
95173 CTS-FD-Ct Serv-Adoptions
CTS-FD-Ct Serv-Adopbons - Total
96185 CTS-FDIADMIN-Famity Judges
CTS-FD-Judicial - Total
24009 SQL Serv Supp - CTS-Jud Sup Mm
95193 CTS-FD-Judicial Suport•Adm
CTS-FD•Judicial Suport-Adm - Total
•Prepared by; intomaition Technology; 7/2212005
95191 CTS-FD-Admin-Juvenile Referees $0,00
CTS-FO-JuvenHe Referees - Total $0.00
95474 CTS-FO-Admin-Juvenile Support $0.00
CTS-FD-Juvenlie Support - Total $0.00
95180 CTS-GJ-Assignment ;15.578,90
CTS-GJ-Assignment - Total 615,578,00
95195 Cir C.rt Alin* $2 074 00
Courts - GJ - Family Support • Total $2,074.00
95208 CTS OW Maintenance $1 722 00
CTS - GJ • JIMS - Total $1,722.00
95179 CTS -Gen Jurls-Judicial Suppt $17 588 00
CTS -Gen Juris-Judicial Suppt • Total $17,588.00
95181 CTS-GJ-Medlation $3.462,90
CTS-GJ-Mecliation - Total $3.462.00
13002 CTS-Judicial Admin onling - 50% $9,424.50
95174 CTS-Judicial AdrnIn 2,92
CTS-Judicial Admin - Total
28007 Drain Ccannissioner $0.00
28011 Drain Commissioner AppliCallon 32526.00
36520 GIS Implementation Support Drain 13.825.00
95889 Water & Sewer Accounting 2,94
Drain Commissioner - Total
$9,424.50
$46,351.00
20001 IDMS Support-Equalization -40% $1,512.80
23012 Gracie Support-Equallzation • 5.6% 3,832.75
24006 SQL server Supp-Equalization - 6.7% 2.550.34
31075 Equal-Development 2,174,00
36505 GIS implementation Support Equalization 6,202.00
95559 User Support/Equal 8,754.50
95562 Equalization - OW Support 13,488.50
95570 Equalization - OW Maintenance 5.294.00
95693 Equal-System Maintenance 11,913.00
95699 BS&A Master Appraisal Sup/Maint 7.681,59
Equalization - Total $9&411.39
91500 FM - System Support 12.379,00
Facilities Mgmt - Total $2,379.00
' INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER, 2005
484 CTS-FD•JUVENILE REFEREES
474 CTS-FD-JUVENILE SUPPORT
499 CTS-GJASSIGMMENT
420 CTS -04- FAMILY SUPPORT
496 CTS GJ JIM1
49e CTS-GEN JURIS-JUDICIAL SUPPT
500 CTS-GJ-MEDIATION
493 CTS-JUDICIAL ADMIN
730 PRAIN COMMISSIONER
740 gQUALMATION
755 FACILITIES MANAGEMENT
660 FISCAL SERVICES ADMIII
840 HEALTH DEPARTMENT
23001 Oracle Support - Fiscal Serv
23013 Oracle Support -1-11R-Acctgaluaget
24006 SQL Serv Supp - HR-Acctg
24008 SQL Serv SuPP - Budget
44021 FS-System/Customer Support
44022 FS-System Maintenance
44023 FS-System Enhancements
44024 FS-New Development
44077 BUD-System Maintenance
44079 FS - OW Support
44081 FS - OW Maintenance
96001 Human Res-Acct 40%
96003 Human Res.-Budget 20%
Fiscal Services Admin - Total
20002 IDMS Support - CHAMPS - 20%
36525 GIS implementation Support Health
37025 CHAMPS - POP.
96842 Health Adrian
Health - Total
$7,665.50
11,156.05
1,027.75
494.85
18,618.00
12,427.00
0.00
0.00
0.00
549.00
0.00
27,489.00
13.744,50
$756.40
5,186.00
15,929.00
32.361,0o
900 flYIERGENCY RESPONSES PREPAREDNCIU 36545 GIS Implementation Support EMS $3,004.00
98990
Emergency Response
ERP - Total $3,004.00
$93,171.65
$54.252.40
Prepared by: Information Technology: 7122/2005 ilQtr 2005.sis
$327,43525
$52,978.54
$432.00
$70,505.59
$0.00
145 PROSECUTOR- GENERAL PROSECVT1QN 90605 JIMS - Prosecutor 25% $0.00
95622 Prosecutor/Executive 13,021.00
97001 Prosecutor Dela Prue 13.178..00
Prosecutor • Total
44026 PUR-System/Gustomer Support
44027 PUR-System Maintenance
Purchasing - Total
44052 Rec.-System Maintenance
44054 Rec-New Development
95636 Mall Room
Rec-New Development • Total
95470 Reimbursement System
95542 Reimburse User Support
Reimbursement - Total
$26,197.00
$6,048.00
$8,389.00
$5,865.40
690 PURCHASING
637 RECORDS RETENTION
650 REIMBURSEMENT
$864.00
5.184,00
$1.525.00
4.290,00
574.00
$573.40
5.292,00
' INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL. THIRD QUARTER, 2005
843 HEALTH - ENVIRONMENTAL
680 HUMAN RESOURCES
641 MATERIALS MGMT-GEN SUPPORLSERV
872 MEDICALEXAMINER
710 fASU EXTENSION - OAKLAND
23005 Oracle Support - EH Projects - 5.6%
37002 Environmentai
84200 EH - Projects
84300 Ehealth Program
Health-Environmental - Total
23014 Oracle Support-HR/Personnel
24007 SQL Server Suppport-HR/Personnel
44042 PER-Systems Maintenance
95556 Personnel User Supt
96002 Human Res-Personnel 40%
Personnel - Total
95440 Materials Management
Materials Mgmt-Gen Fund - Total
24002 SQL Server Support - Medical Exam - 6.7%
87202 Medical Examiner - Customer Support
Medical Examiner - Total
95676 MSU Ext Equipment Maintenance
MSU Extension Oakland - Total
$3,832,75
2,106.00
142,140.50
179.356.00
$7,460.19
1,027.75
108.00
1,265.00
43.117,60
falLE2
$2,550.34
67,95525
775 PLANNING & ECONOMIC DEVELOPMENT 95786 PEDS - DW Support S2446.00
95787 PECS - DW Maintenance 2,21
PECS - Total $2,446.00
512 PROB-ESTATES/MENTL HLTH IMAGC 95207 Prob-Estantl Illth Image ;2.349.00
Prob-Est/Mntt 111th Image - Total $2,349.00
509 PROS-JUDICIAL ADMIN 90604 JIMS Probate 25% $0.00
95165 PC-Judicial Admin-Mmin Serv
Prob-Judicial Admit*, - Total
510 PROP-ESTATES/MENTL HLTH SUPPORT 24010 SQL Serv Supp-PCT-Est/Mental $1,275.16
92198 Prob-Est/Mnti Illth Support j.957.00
Prob-Est/Mntl HIM Support - Toter $3,232.16
481 PROBATE-FD JUDICIAL 95168 Prob-FD Judicial 111 820.00
Prob-FO Judicial Total $11,820.00
479 PROB-FDIUDICIAL SUPPORT 95188 PROS-PD Judicial Support ELM
PROB-FD Judicial Support -Total $0.00
$0.00
195 SHERIFF 12001 OGSD Gourts/Griminal Warehouse $183.00
23009 Oracle Suppport - OCSD/CTS Grim Whse 1,916,38
97163 Sheri 62,330,50
97164 Sherlff-Development 1,582.00
97165 Sheriff-DW Support 2257.00
97166 Sherifl-DW Maintenance 7.181,00
Shertff - Total $75,449.58
Prepared by Information Technology 7/22/2005
$3,832.75
6.285.75
$10.118.50
$3,832.75
5.047,00
$8,879,75
;1.589,75
$1,589.75
51,5E9.75
$1,589.75
530 pm DISTRICT COURT - TROY 90609 JIMS - 57J4 DC - 6.25%
95530 DC Supd-25%-52/4
52/4 District Court - Total
$0.00
6.451.45
$6,451,45
$1,589.75
$1,589.75
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - THIRD QUARTER, 2005
191 SHERIFF - CLEFAIS
445 SUPPORT SERVICES
600 TREASURER
23015 Oracle Suppport - Sheriff / CLEWS
96163 Sheriff • CLEWS
Sheriff - CLEMIS - Total
23002 Oracle Support - Supp Sew
44500 Support Services
Support Services - Total
23006 Oracle Support • Del Tax $3,832.75
36515 GIS Implementation Support-Treasurer 6,954.00
44061 Ire-System/Customer Support 4,627.00
44062 Tie-System Maintenance 366.00
44063 Tie-System Enhancement 0.00
44064 Ire-New Development 3,050.00
44080 Tre-OW Support 1,057,00
44082 Ire-OW Maintenance 648.00
95005 Del Tax On Line 854.00
95303 Del Tax System Maintenance 15.043.00
95561 User Support/Del Tax QQ
Treasurer - Total 637,431.75
541 52/1 DISTRICT COURT • NOVI • PROBATION 94542 DC Probation Support - 5211 - 25%
52/1 District Court - Probation - Total
540 52/1 DISTRICT COURT - NOVI
550 52/2 DISTRICT COURT • CLARKSTON
90606 JIMS • 52/1 DC- 6.25%
95527 DC Suprt-25%-52/1
52/1 District Court - Total
90607 JIMS - 52/2 DC • 6.25%
95528 DC Suprt-2556-5212
52/2 District Court - Total
$0,00
6,451,45
$6,451.45
$1.589.75
$1,589.75
$0.00
6.451,44
$6,451.45
551 5212 DISTRICT COURT • CLARKSTON • PROBA1 94552 DC Probation Support - 52/2 - 25%
52/2 District Court - Probation - Total
560 52/3 DISTRICT COURT- ROCHESTER 90608 JIMS -5213 DC - 6.25%
95529 DC Suprt-25%-52/3
52/3 District Court - Total
$0.00
6,451,45
66,451.45
561 6213 DISTRICT COURT - ROCHESTER PROBA1 94562 DC Probation Support • 62/3 - 25%
52/3 District Court - Probation - Total
531 5214 DISTRICT COURT - TROY - PROBATION 94532 DC Probation Support - 52/4 - 25%
52/4 District Court - Probation - Total
....PrePareatiG Inforruation-leohnolormat22/200g
$756.40
22,762,72
1.647.00
5.808.00
$15377,50
ORAIM
$5.742,00
K.Q.Q
$0.00
;1.525,00
$1,525.00
$553.50
$3,103.84
($427.00)
13,17620
$12,749.20
$3832.75
30262,00
$5,673.00
$2241.00
10,42
$0.00
$313.453,0Q
$313483.00
$2,550.34
1.054.00
$1.060.00
$415.50
$488.00
756.0.0
$1.244.00
$0.00
$0ox*
ELw
$0.00
83.832.78
4242.00
$8.074.75
$30,974.12
$15,377.50
$206.00
$0.00
$5,742.00
$34,094.75
$5,673.00
$0.00
$2241.00
$3.604.34
$1,080.00
$415.50
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL • THIRD QUARTER, 2005
Cust # DIRECT FUNDS
055 CLEMIS
056 CLEMIS FUND 63500
661 COMMUNITY & HOME IMPROVEMENT
103 COPSMORE GRANT - EXCESS MATCH
471 CTS-FOC•EXP•CS ENFORC-IMAGt
470 CTS-FOC•EXP-FAM COUNSEUNG
507 CTS-FOC EXP•CS ENFORCEMENT
210 FIRE RECORDS MANAGEMENT SYSTEM
750 FM&O
757 FM-WK RELEASE/JAIL MONTT/VIDEO CONF
758 FM - JAIL MGMT REPLACEMENT
759 FM&O -SAFETY OVERHEAD
380 HEALTH IMMUNIZATION -GRANT
751 JT • TELEPHONE COMMUNICATIONS
662 MAJOR DEPT SUPP PROJ FUND
870 MEDICAL CARE_EACILMI
248 MEDICAL CARE FACILITY - PHARMACY
653 0.0. INTERNATIONAL AIRPORT
770 PARKS AND RECREATION
790 RADIO COMMUNICATION
695 FISK MANAGEMENT
656 WATER & SEWER ACCTG
850 WORKFORCE DEVELOPMENT
IDMS Support
SQL Server Support
CRISNET/CLEMIS LRM
CLEMIS Maintenance
CLEMIS - Total
CLEMIS Fund
CLEWS Fund - Total
66103 Comm Dev User Supt
63103 COPSMORE Grant - Excess Match
COPSMORE Grant. Excess Match • Total
92194 CTS-F0C-Exp-CS Enf -Image
CTS-FOC Exp-CS Enf-lmage - Total
92195 CTS-FOC•Exp-Fam Counseling
CTS-FOC•Exp-Fam Counseling - Total
92193 CTS-FOC Exp-CD Wu' i...Dev
CTS-FOC Exp-CD Enforc-Dev • Total
21010 Fire Records Mgmt Fund 531
24001 SQL Server Support - FRMS
Fire Records Mgmt - Total
21001 FM&O
75503 FM&O Development
FM&O - Total
23004 Oracle Support - Oak Video - 5.6%
75700 Fac Mgmt - Video Arraignments
FM-Wk Rel/Jall Mg4nWideo Conf - Total
75800 FM - Jail Mgmt Replacement
FM • Jail Mgmt Replacement - Total
75900 FM - Bomb Notification SW Upg
FM - Bomb No6ficallon SW Upg • Total
38000 Health - Immunization
75102 Tel Comm - Customer Support
Tel Comm - Customer Support - Total
66200 e•Financlal-Peoplesoft Implementation
e-Financial-Peoplesoft Implem-Total
24003 SQL Server Support - MCF - 6.7
98873 MCF - Support
MCF - Support • Total
98248 MCF - Pharmacy
MCF - Pharmacy - Total
36540 CIS Implementation Support-Aviation
Airport User Support • Total
36530 GIS Implementation Support - Parks
95419 PRADM-Administration
Parks & Recreation - Total
79001 Radio Communications
Radio Communications - Total
44036 RSK-System/Custorner Support
95695 Risk Management
Risk Management - Total
23011 Oracle Supp • Water & Sewer Acct'g
96669 Water & Sewer Accrg
Water & Sewer Accrg - Total
95670 Employment & Training
Workforce Development - Total
20003
24004
95409
95430
63500
Heatth - Immunization - Total Heatth - Immunization - Total
Prepared by, information Technotogy: 7122/2005
FISCAL NOTE (MISC. #05159) September 1, 2005
BY: FINANCE COMMITTEE, CHUCK MOSS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - THIRD QUARTER 2005
DEVELOPMENT APPROPRIATION TRANSFER
TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS
Chairperson, Ladies and Gentlemen:
Pursuant to Rule XII-C of this Board, the Finance Committee has
reviewed the above-referenced resolution and finds:
1. The resolution appropriates and charges the Information
Technology Third Quarter 2005 Development cost to benefiting
departments.
2. The third quarter data processing development charges are
$1,191,499.20; imaging development charges are $56,305.25 for
General Fund/General Purpose departments; direct charges to
Special Revenue and Proprietary fund departments are
$447,884.00 and charges to non-county agencies are $0.
3. The respective departmental Fiscal Year 2005 budgets are to be
amended as specified in the attached detail schedule.
FINANCE COMMITTEE
FINANCE COMMITTEE:
Motion carried unanimously on a roll call vote.
Resolution #05159 August 18, 2005
The Chairperson referred the resolution to the Finance Committee. There were no objections.
Ruth Johnsbn, County Clerk
Resolution #05159 September 1, 2005
Moved by Nash supported by Long the resolutions on the Consent Agenda be adopted (with
accompanying reports being accepted).
AYES: Coleman, Coulter, Crawford, Douglas, Gershenson, Gregory, Hatchett, Jamian, KowaII,
Long, Melton, Middleton, Molnar, Moss, Nash, Palmer, Patterson, Rogers, Scott, Suarez, Wilson,
Woodward, Zack, Bullard. (24)
NAYS: None. (0)
A sufficient majority having voted in favor, the resolutions on the Consent Agenda, were adopted (with
accompanying reports being accepted).
APPROVE TIE FORMA RESOLU11011
OreiL) PA-- g`i
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 September 1, 2005
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 1st day of September, 2005.