HomeMy WebLinkAboutResolutions - 2005.03.10 - 27895MISCELLANEOUS RESOLUTION #05027 February 17, 2005
BY: GENERAL GOVERNMENT COMMITTEE, WILLIAM PATTERSON, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FIRST 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 First Quarter 2005 data processing development charges to be
$982,821.55 and the imaging development charge to be $50,489.87 for the
General Fund/General Purpose County departments; and
WHEREAS direct charges to Special Revenue and Proprietary fund
departments are $538,962.61 and non-county agencies are $0 for the
First Quarter 2005; and
WHEREAS an appropriation transfer to General Fund/General Purpose
County departments is needed to fund these development charges; and
NOW THEREFORE BE IT RESOLVED that the Oakland County Board of
Commissioners has reviewed the First Quarter 2005 Data Processing
Development Report and approves the First 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 on a roll call vote with Crawford absent.
ACCOUNT # DIVISION
1st Crtr
Oct - Dec
2nd Qtr
Jan - Mar
3rd Qtr
6,or - June
4th Ott
July - Shot
18-636111-10000-0735 DATA PROCESSING DEVELOPMENT FOR
GOVERNMENTAL FUND APPROPRIATION
$9112.821.33
12931
Children's Village
Sub-Total Fund 293
Juvenile Maintenance Fund 12931
665 293 2-16-501200-25001-6030 $2.214.00
$2,214.00
$0.00 $0.00 $0.00
$34,382.60
15.604.87
$39,987.47
$2,214.00
$000 $0.00 $0.00 $2,214.00
$0.00 $8,00 R.L0 5082.821.55
$47,554.67
12.935.20,
INFORMATION TECHNOLOGY
DATA PROCESSINci DEVELOPMENT SUMMARY
1ST QUARTER 2005
540 101
541 131
550 101
551 101
560 101
561 101
530 101
531 101
630 101
620 101
725 101
440 101
410 101
724 101
720 101
723 101
785 101
622 101
430 101
495 101
474 101
484 101
487 101
492 101
483 101
499 101
496 101
498 101
500 101
493 101
016 101
730 101
900 101
740 101
755 101
660 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
445 101
600 101
GOVERNMENTAL FUNDS
General Fund 11011
2-32-201200-20001-6030
2-32-205200-20006-13030
2-32-301200-20001-6030
2-32-305200-20006-6030
2-32-401200-20001-6030
2-32-406200-20006-6030
2-32-501200-20001-6030
2-32-505200-20006-8030
2-17-802200-80001-6030
2-11-220100-10000-6030
2-21-220100-10000-6030
2-21-230100-31000-6030
2-21-250100-0100043030
2-21-221000-01000-6030
2-21-240100-11000-6030
2-21-220500-40000-6030
2-19-210000-10000-6030
2-17-402200-70001-6030
2-11-250100-20000-6030
2-35-220000-12000-6030
2-35-244000-33000-6030
2-35-243000-32000-6030
2-35-242000-11000-6030
2-35-242000-44000-6030
2-35-243000-11000-6030
2-35-230000-22100-6030
2-35-230000-12000-6030
2-35-230000-21200-6030
2-35-230000-22200-6030
2-35-210000-11000-6030
2-11-210100-01000-6030
2-61-211001-10000-6030
241-101112-65001-8030
2-12-240000-41000-6030
2-14-210000-1000043030
2-12-601200-25000-6030
2-15-402200-10001-6030
2-13-138502-1510043030
2-17-912000-15000-6030
2-17-501200-50000-8030
2-19-221000-10000-6030
2-34-101200-40001-8030
2-34-403200-40005-6030
2-34-101200-31100-8030
2-34-101200-31200-6030
2-41-211000-4170043030
2-12-401200-4001013030
2-13-138203-12000-6030
2-12-701200-3400043030
2-43-023301-20000-6030
2-43-023601-30000-6030
2-13-138203-1510043030
2-22-221120-01000-6030
6211 - District Court
52/1 District Court - Probation
52/2 - District Court
52/2- District Court Probation
52/3 - District Court
62/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
Community 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-Admin
Courts-GJ-Assigornent
Courts-GJ-JIMS
Courts-GJ-Judicial Support
Courts-GJ-k4ediabon
Courts - Judical Administration
County Executive
Drain Commissioner
Emergency Response & Prep Unit
Equalization Division
Facilities Management
Fiscal Services - Admin
Human Resources
Materials Management Gen Fund
Medical Examiner
MSU Extension - Oakland
Planning & Economic Development
Probate - Judicial AdmIn
Probate-Estates/Mental Health Support
Probate-FD-Judicial
Probate-FD-Judicial Support
Prosecuting Attorney - General Prosecution
Purchasing
Records Retenbon
Reimbursement Division
Sheriff
Sheriff - CLEMIS
Support Services
Treasurer
Sub-Total Fund 101
$8,754.63
$30.50
$8,754.63
$30.50
$8,754.63
$30.50
$8,754.55
$30.50
$11400.00
$244.00
$4,275.00
$3,538.00
$4,906.87
$30,300.00
$4,855.60
$6,455.00
$4,725.50
535,302.87
$1,098.00
$5,664.88
30.00
$13,513.25
$0.00
$5,174.00
$7,184.65
$21,354.25
$3,834.50
$33,836.50
$26,073.50
$36.60
$0.00
$38,977.00
$7,427.00
$189,425.28
$108.00
$166,479,43
$49,428.77
$244.00
$13,990.71
$732.00
$1,830.00
19,896.45
$7,628.35
123,588.00
$0.00
$10.947.45
$3,132.00
$5.290.00
$14,958.40
$92.718.43
$8.803.86
$4.322.47
$33,778.87
$ 940,620.08
$8,754.63
$30.50
$8,754.63
$30.50
$8,754.63
$30.50
$8,754.66
$30.130
$11,400.00
$244.00
$4.275.00
$3,538.00
$4,908.87
$30,300.00
$4,855.80
$6,455.00
$4,726.50
$35,302.87
11,098.00
$5,864.88
10.00
$13,513.25
$0.40
$5,174.00
$7,184.85
$21,354.25
$3,834.50
$33,836.50
$26,073.50
$36.60
$0,00
$36,977,00
$7,427,00
$189,425.28
1108.00
$166,479.43
$49,428.77
$244.00
$13,9110.71
$732.00
$1,830.00
$9,896.45
$7,828.35
$23,588.00
$0.00
510,947.45
$3,132.00
$5,290.00
$14,9513.40
$92.718.43
$8,803.88
$4,322.47
$33,778.87
$0.00 $0.00 $0.00 $940,620.08
Health Fund 12211
840 221 2-16-201200-33100-6030
843 221 2-16-220200-67000-6030
IMAGING
722 2-21-221000-01000-6039
512 2-34-403200-40005-6039
18-636111-10000-0573
Health
Health Environmental
Sub-Total Fund 221
Clerk Image
Probate-Estates/Mental Health Image
TOTAL IMAGING DEVELOPMENT
APPROPRIATION
$34,382.60
$5,604.87
139,987.47
$47,554.67
;2,935.20
$50,489.87 $0.00 $0.00 $50,489.87
SUB-TOTAL GOVERNMENTAL! WAGING DEVELOPMENT APPROPRIATION; $1,033,311.42
90-290000-25000-6030 Information Technology Development 01.033.311.421
TOTAL GOVERNMENT: $0.00
$0.00 $0.00 50,00 #1,033,311.42
$0.00 tiN $0 .00 151.033.311 421
kao son
$0.00 om
Prepared by; Informabon Technology-, 1/12/2005 Revised 1St Qtr 2005.xls
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
1ST QUARTER 2005
1st Qtr 2rie Ott 3rd Qtr 4111 Qtr
ACCOUNT* DIVISION Oct-Dec Jan - Mar Act-June - Seot
NON-GOVERNMENTAL
DIRECT CHARGES
055 CLEMIS $3617935 $36,179.35
056 CLEMIS FUND 63500 $1,464.00 $1,404.00
103 COPSMORE Grant - Excess Match $39,894.00 $39,894.00
471 Courts-FOC Exp-CS Enforcement Image $7,386.40 $7,386.40
470 Courts-FOC Exp-Family Counseling $0.00 $0.00
507 Courts-FCC Exp-CS Enforcement Image $1,220.00 51,220.00
210 Fire Records Management System $2,413.71 $2,413.71
757 FM-Wk FteVJail MgVVicleo Goof $57,993.37 $57,993.37
750 FM8,0 $000 $0.00
380 Health - Immunization Grant $1,782.00 $1,782.00
751 IT - Telephone Communications $000 $0.00
662 Major Department Support Project Fund $364,031.20 $364,031.20
870 Medical Care Facility $6,936.71 $6,936.71
248 Medical Care Facility - Pharmacy $3,294.00 $3,294.00
651 0.0. International Airport-GRE Grant $0.00 $0.00
653 O.C. International Airport 51,857.00 $1.857.00
770 Parks and Recreation - Administration $106.00 $108.00
790 Radio Communications 59,730.00 $9,730.00
695 Risk Management $0.00 $0.00
656 Water & Sewer Accounting $4,550.87 $4,550.87
850 Workforce Development $122.00 $122.00
18-636111-10000-0715 SUB-TOTAL DIRECT CHARGES FOR DATA $538,962.61 $0.00 WA DM $538.962.0t
PROCESSING DEVELOPMENT
TOTAL COUNTY DEVELOPMENT CHARGES $1.572.274.03 $0.00 $0.00 50.00 51.572274.03
NON-COUNTY AGENCIES
18-636111-10000-0429 Non-County Agencies 11).,2.8 $0.00 $0.00 $0.00 $0.06
TOTAL DEVELOPMENT CHARGES $1,572,274.03 $0.00 $0.00 $0.00 $1,572,274.03
YT ,
Prepared by: Information Technology; 1/1212005 Revised 1st Qtr 2005.xls
23007
65420
95158
$47,554.67
Oracle Support - Clerk Image
Clerk - Image Replace - 21%
Clerk - Imaging
Clerk - Imaging - Total
722 CLERK - IMAGING $1,914.87
$8,986.00
36.653.80
$1,914.87
2,992.00
30.300.00
$6,455.00
$1,914.87
33,266.00
122.00
$4,176.50
549.00
$1,098.00
$957.43
4,707.45
$0.00
$5,174.00
$0.00
$627.35
6,557.50
$4,906.87
$30,300.00
$6,455.00
$35,302.87
$4,725.50
$1.098.00
$5.664.88
$0.00
$5,174.00
$0.00
$7,184.85
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT SUPPORT DETAIL • FIRST QUARTER, 2005
cust # GOVERNMENTAL FUNDS
630 ANIMAL CONTROL
620 AUDITING
665 CHILDRENS VILLAGB
725 CLERK - ADMIN
440 CLERK - ELECTIONS
720 CLERK! REGISTER OF DEEDS
95682 Dog System
Animal Control-Total
95468 Auditing-Cust Supt
Auditing - Total
95665 Childrens Village
Childrens Village - Total
72500 Clerk - Admin
Clerk - Admin - Total
95443 Elections
Clerk -Elections - Total
20004 IDMS Support - Register of Deeds
36510 GIS Implementation Support-ROD
95493 Reg Deeds System Maintenance
95162 Clerk - DW Support
95558 User Support/ROD
95564 ROD - DW Support
CleddReg of Deeds - Total
$11,400.0Q
$244.00
$2.214.00
$4,275.00
$3.538.00
$341.60
2,379.00
0.00
427.00
1,586.00
122.00
$11,400.00
$244,00
$2,214.00
$4,275.00
$3,538.00
$4,855.60
410 CLERK - JURY COMMISSION
724 CLERK - LEGAL RECORDS
723 CLERK - VITAL STATISTICS
522 COMMUNITY CORRECTIONS-ADMIN (COI
785 COMMUNITY & ECO DEVELOPMENT
430 CORPORATION COUNSEL
495 CTS-BUSINESS DIV - JIMS
487 CTS-FD-CT SERV-ADMIN
492 CTS-FD-CT SERV-AD OPTIONS
505 CTS-FD-JUDICIAL
483 CTS-FD-JUDICIAL SUPPORT-ADM
Oracle Support - Jury Comm
Jury Commission
Clerk -Jury Commission - Total
95189 Circuit Court System
Clerk - Legal Records - Total
95161 Vital Stats Index
Clerk - Vital Statistics - Total
Oracle Support-Comm Corr
Comm Corr-Admin (County)
Comm Corr-DW Supp
Community Corrections - Total
36500 GIS Implementation Support C&E Dev
95785 Comm & Eco Developmt
Community & Eco Dev - Total
95501 Corporation Counsel
Corporation Counsel - Total
23010 Oracle Support-CCT/CTS Crim 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-Adoptions - Total
95186 CTS-FD/ADtvlIN-Family Judges
CTS-FD-Judicial - Total
24009 SQL Serv Supp - CTS-Jud Sup Adm
95193 CTS-FD-Judicial Suport-Adm
CTS-FD-Judicial Suport-Adm - Total
23008
95512
23003
52200
52201
Prepared by: Information Technology; 1/12/2005 5 Revised is? Qtr 2005.xls
$7.427.00
$0.00
$683.20
1,914.87
1,254.71
86,471.50
7,686.00
17,202.50
1,830.00
25,428.50
25,517.00
21 437.00
660 FISCAL SERVICES ADMIN
840 HEALTH DEPARTMENT
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - FIRST QUARTER, 2005
484 CTS-FD-JUVENILE REFEREES 95191 CTS-FD-Admin-Juvenile Referees $13,513.25
CTS-FD-Juvenile Referees - Total
474 CTS-FD-JUVENILE SUPPORT 95474 CTS-FD-Admin-Juvenile Support $0.00
CTS-FD-Juvenile Support - Total
499 CTS-GJ-ASSIGNMENT 95180 CTS-GJ-Assignment $21.354.25
CTS-GJ-Assignment - Total
420 CTS GJ - FAMILY SUPPORT 95195 Cir Crt Admin $0.00
Courts - GJ - Family Support - Total
496 CTS - GJ JIMS 95208 CTS - OW Maintenance $3,834.50
CTS - GJ - JIMS - Total
498 CTS-GEN JURIS-JUDICIAL SUPPT 95179 CTS -Gen Juris-Judicial Suppt $33,836.50
CTS -Gen Juris-Judicial Suppt - Total
500 CTS-GJ-MEDIATION 95181 CTS-GJ-Mediation $26,073.50
CTS-GJ-Mediation - Total
493 CTS-JUDICIAL ADMIN 95174 CTS-Judicial Admin $36.60,
CTS-Judicial Admin - Total
730 DRAIN COMMISSIONER 28007 Drain Commissioner $2916.00
28011 Drain Commissioner Application 0.00
36520 GIS Implementation Support Drain 34,061.00
95669 Water & Sewer Accounting 0.00
Drain Commissioner - Total
$13,513.25
$0.00
$21,354.25
$0.00
$3,834.50
$33,836.50
$26,073.50
$36.60
$38,977.00
900 EMERGENCY RESPONSE & PREPAREDNESS 36545 GIS Implementation Support EMS
98990 Emergency Response
ERP -Total $7,427.00
740 EQUALIZATION 20001 IDMS Support-Equalization
23012 Oracle Support-Equalization
24005 SQL Server Supp-Equalization
31075 Equal - Development
36505 GIS Implementation Support Equalization
95559 User Support/Equal
95562 Equalization - OW Support
95570 Equalization - DW Maintenance
95693 Equal-System Maintenance
95699 BS&A Master Appraisal Sup/Maint
Equalization - Total $189,425.28
755 FACILITIES MANAGEMENT 91500 FM - System Support $108.00
Facilities Mgmt - Total $108,00
$3,829.73
5,573.62
505.63
243.45
47,859.00
41,123.00
0.00
0.00
848.00
183.00
244.00
44,180.00
22 090.00
23001 Oracle Support - Fiscal Serv
23013 Oracle Support - HR-Acctg/Budget
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 - DW Support
44081 FS DW Maintenance
96001 Human Res-Acct 40%
96003 Human Res.-Budget 20%
Fiscal Services Admin - Total $166,479,43
20002 IDMS Support - CHAMPS $341.60
36525 GIS Implementation Support Health $3,272.00
37025 CHAMPS - P.O.P. 8,586.00
96842 Health Admin 22 183 00
Health - Total $34,382.60
Prepared by Information Technology: 1/12/2005 6 Revised 1st Qtr 2005.xls
$432.00
2,700.00
$498.40
14,460,00
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL -FIRST QUARTER, 2005
843 HEALTH - ENVIRONMENTAL 23005 Oracle Support - EH Projects $1,914.87
37002 Environmental $432.00
84200 EH - Projects 3,258.00
84300 Ehealth Program 0_00
Health-Environmental - Total $5,604.87
680 HUMAN RESOURCES 23014 Oracle Support-HR/Personnel $3,727.14
24007 SQL Server Suppport-HR/Personnel $505.63
44042 PER-Systems Maintenance 54.00
95556 Personnel User Supt 962.00
96002 Human Res-Personnel 40% 44 180.00
Personnel - Total $49428.77
641 MATERIALS MGMT-GEN SUPPORT SERV 95440 Materials Management $244.00
Materials Mgmt-Gen Fund - Total $244.00
872 MEDICAL EXAMINER 24002 SQL Server Support - Medical Exam $1,254.71
87202 Medical Examiner-Customer Support 12,736.00
Medical Examiner - Total $13,990.71
710 MSU EXTENSION - OAKLAND 95676 MSU Ext Equipment Maintenance $732.00
MSU Extension - Oakland - Total $732.00
775 PLANNING & ECONOMIC DEVELOPMENT 95786 PEDS - OW Support $1,830.00
REDS - Total $1,830.00
512 PROB-ESTATES/MENTL HLTH IMAGE 95207 Prob-Est/Mntl Hith Image $2,935.20
Prob-Est/Mntl Hith Image - Total $2,935.20
509 PROS-JUDICIAL ADMIN 90604 JIMS Probate 25% $4,707.45
95165 PC-Judicial Admin-Admin Serv 5,189.00
Prob-Judicial Admin - Total $9,896.45
510 PROB-ESTATES/MENTL HLTH SUPPORT 24010 SQL Serv Supp-PCT-Est/Mental $627.35
92198 Prob-Est/Mntl Hlth Support 7,001.00
Prob-Est/Mntl Hlth Support - Total $7,628.35
481 PROBATE-FD JUDICIAL 95168 Prob-FD Judicial $23.588.00
Prob-FD Judicial - Total $23,588.00
479 PROB-FD-JUDICIAL SUPPORT 95188 PROB-FD Judicial Support 11.0_0
PROB-FD Judicial Support - Total $0.00
145 PROSECUTOR - GENERAL PROSECUTION 90605 JIMS - Prosecutor 25% $4,707.45
95622 Prosecutor/Executive 5,790.00
97001 Prosecutor Data Proc 450 00
Prosecutor - Total $10,947.45
690 PURCHASING
637 RECORDS RETENTION
650 REIMBURSEMENT
195 SHERIFF
44026 PUR-System/Customer Support
44027 PUR-System Maintenance
Purchasing - Total
44054 Rec-New Development $5,060.00
95636 Mail Room 1230.00
Rec-New Development - Total
95470 Reimbursement System
95542 Reimburse User Support
Reimbursement - Total
23009 Oracle Suppport - OCSD/CTS Crim Whse $957.43
97163 Sheriff 38,888.00
97184 Sheriff-Development 26,524.00
97165 Sheriff-OW Support 10,684.00
97166 Sheriff-OW Maintenance $15,665.00
Sheriff - Total
$3,132.00
$5,290.00
$14,958.40
$92,718.43
Prepared by: Information Technology; 1/12/2005 7 Revised 1st Qtr 2005.xls
23015 Oracle Suppport - Sheriff / CLEMIS
96163 Sheriff - CLEMIS
Sheriff - CLEMIS - Total
23002 Oracle Support - Supp Serv
44500 Support Services
Support Services - Total
23006 Oracle Support - Del Tax 1,914.87
36515 GIS Implementation Support-Treasurer 0.00
44061 Tre-System/Customer Support 1,690.00
44062 Tre-System Maintenance 122.00
44063 Tre-System Enhancement 3,782.00
44082 Tre-DW Maintenance 162.00
95008 Del Tax On Line 1,098.00
95303 Del Tax System Maintenance 22,814.00
95561 User Support/Del Tax 2,196.00
Treasurer - Total
90606 JIMS - 52/1 DC - 6.25%
95527 DC Suprt-25%-52/1
52/1 District Court - Total
541 52/1 DISTRICT COURT - NOVI - PROBATION 94542 DC Probation Support - 52/1 - 25%
52/1 District Court - Probation - Total
90607 JIMS -5212 DC - 6.25%
95528 DC Suprt-25%-52/2
52/2 District Court - Total
551 5212 DISTRICT COURT - CLARKSTON - PROBAT 94552 DC Probation Support - 52/2 - 25% $30.50
52/2 District Court - Probation - Total
90608 JIMS .52/3 DC - 6.25%
95529 DC Suprt-25%-52/3
52/3 District Court - Total
561 5213 DISTRICT COURT - ROCHESTER - PROBAT 94562 DC Probation Support -52/3 - 25%
52/3 District Court - Probation - Total
90609 JIMS - 52/4 DC - 6.25%
95530 DC Suprt-25%-52/4
52/4 District Court - Total
531 52/4 DISTRICT COURT - TROY - PROBATION 94532 DC Probation Support - 52/4 - 25%
52/4 District Court - Probation - Total
550 52/2 DISTRICT COURT- CLARKSTON
560 52/3 DISTRICT COURT - ROCHESTER
530 52/4 DISTRICT COURT. TROY
$8,803,86
$4,322.47
$33,778.87
$8,754.63
$30.50
$8,754.63
$30.50
$8,754.63
$30.50
$8,754.55
$30.50
191 SHERIFF - CLEMIS
445 SUPPORT SERVICES
600 TREASURER
540 52/1 DISTRICT COURT - NOVI
$1,914.86
6.88900
$1,914.87
2,407.60
$1,176.88
7,577.75
$30.50
$1.176.88
7.577.75
$1,176.88
7.577.75
$1,176.80
7577.75
$30.50
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL • FIRST QUARTER, 2005
Prepared by; Information Technology: 1/12/2005 8 Revised 1st Qtr 2005.xls
21001 FM&O $0.00
75503 FM&O Development $0.00
FM&O - Total
750 FM&O
$0.00
$1,914.87
56 078.50
$1.782.00
653 O.C. INTERNATIONAL AIRPORT 36540 GIS Implementation Support-Aviation $1,857.00
Airport User Support - Total
770 PARKS AND RECREATION 95419 PRADM-Administration $108.00
Parks & Recreation - Total
790 RADIO COMMUNICATION 79001 Radio Communications $9,730.00
Radio Communications - Total
695 RISK MANAGEMENT 44036 RSK-System/Customer Support $0.00
95695 Risk Management $0.00
Risk Management - Total
$57,993.37
$1,782.00
$364,031.20
$6.936.71
$1.857.00
$108.00
$9,730.00
$0.00
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - FIRST QUARTER, 2005
cust # DIRECT FUNDS
055 CLEMIS 20003 IDMS Support $341.60
$36,179,35
056 CLEMIS FUND 63500 63500 CLEMIS Fund $1,464.00
CLEMIS Fund - Total $1,464.00
103 COPSMORE GRANT - EXCESS MATCH 63103 COPSMORE Grant - Excess Match $39,894.00
COPSMORE Grant - Excess Match - Total $39,894,00
471 CTS-FOC-EXP-CS ENFORC-IMAGE 92194 CTS-FOC-Exp-CS Enf-Image $7,386.40
CTS-FOC Exp-CS EM-Image - Total $7,386.40
470 CTS-FOC-EXP-FAM COUNSELING 92195 CTS-FOC-Exp-Fam Counseling $0.00
CTS-FOC-Exp-Fam Counseling - Total $0,00
507 CTS-FOC EXP-CS ENFORCEMENT 92193 CTS-FOC Exp-CD Enforc-Dev $1,220.00
CTS-FOC Exp-CD Enforc-Dev - Total $1.220.00
24004 SQL Server Support 11,198.75
95409 CRISNET/CLEMIS LRM 8,487.00
95430 CLEMIS Maintenance 16 152.00
CLEMIS - Total
210 FIRE RECORDS MANAGEMENT SYSTEM 21010 Fire Records Mgmt Fund 531 $1,159.00
24001 SQL Server Support - FRMS $1,254,71
Fire Records Mgmt - Total $2,413.71
757 FM-WK RELEASE/JAIL MGMTNIDEO CONF
380 HEALTH IMMUNIZATION - GRANT
862 MAJOR DEPT SUPP PROJ FUND
870 MEDICAL CARE FACILITY
248 MEDICAL CARE FACILITY - PHARMACY
23004 Oracle Support - Oak Video
75700 Fac Mgmt - Video Arraignments
FM-Wk ReVJall lvtgmtNideo Conf - Total
38000 Health - Immunization
Health - Immunization - Total
66200 e-Financial-Peoplesoft Implementation $364.031.20
e-Financial-Peoplesoft Implem-Total
24003 SQL Server Support - MCF $1,254.71
98873 MCF - Support j5,682.00
MCF - Support - Total
98248 MCF - Pharmacy $1294.00
MCF - Pharmacy - Total $3,294.00
656 WATER & SEWER ACCTG 23011 Oracle Supp - Water & Sewer Acct'g $1,914,87
95669 Water & Sewer Acct'g 2,836.00
Water & Sewer Acct'g - Total $4,550.87
850 WORKFORCE DEVELOPMENT 95670 Employment & Training $122.00
Workforce Development - Total $122.00
Prepared by; Information Technology; 1/12/2005 9 Revised 1st Qtr 2005.xls
Resolution #05027 February 17, 2005
The Chairperson referred the resolution to the Finance Committee. There were no objections.
FISCAL NOTE (MISC. #05027) March 10, 2005
BY: FINANCE COMMITTEE, CHUCK MOSS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FIRST 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 First Quarter 2005 Development cost to benefiting
departments.
2. The First quarter data processing development charges are
$982,821.55; imaging development charges are $50,489.87 for
General Fund/General Purpose departments; direct charges to
Special Revenue and Proprietary fund departments are
$538,962.61 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 #05027 March 10, 2005
Moved by Molnar supported by Melton the resolutions on the Consent Agenda, be adopted (with
accompanying reports being accepted).
AYES: Coleman, Coulter, Crawford, Douglas, Gershenson, Gregory, Hatchett, KowaII, Long,
Melton, Middleton, Molnar, Moss, Nash, Palmer, Patterson, Potter, Rogers, Scott, Suarez,
Wilson, Woodward, Zack, Bullard. (24)
NAYS: None. (0)
A sufficient majority having voted therefore, the resolutions on the Consent Agenda, were adopted (with
accompanying reports being accepted).
I }EBY APPROVE THE FOREGOING MUM
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 March 10, 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 10th day of March, 2005.