HomeMy WebLinkAboutResolutions - 2002.12.12 - 26736MISCELLANEOUS RESOLUTION 102281 November 21, 2002
BY: GENERAL GOVERNMENT COMMITTEE, WILLIAM PATTERSON, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FOURTH QUARTER 2002
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 Fourth Quarter 2002 data processing development charges to be
$1,670,122.66 and the imaging development charge to be $64,281.50 for
the General Fund/General Purpose County departments; and
WHEREAS direct charges to Special Revenue and Proprietary fund
departments are ($269,903.57) and non-county agencies are $0 for the
Fourth Quarter 2002; and
WHEREAS an appropriation transfer to General Fund/General Purpose
County departments is needed to fund these development charges; and
WHEREAS an appropriation transfer of $99,627.00 to Fire Records
Management Fund (FRMS) is needed. This represents the previously agreed
to 75% General Fund contribution to the FRMS to offset the ongoing
expenses (the CVTs provide 25%).
NOW THEREFORE BE IT RESOLVED that the Oakland County Board of
Commissioners has reviewed the Fourth Quarter 2002 Data Processing
Development Report and approves the Fourth Quarter appropriation
transfer as specified on the attached schedule along with the transfer
to FRMS.
Chairperson, on behalf of the General Government Committee, I
move the adoption of the foregoing resolution.
GENERAL GOVERNMENT COMMITTEE
GENERAL GOVERNMENT COMMITTEE
Motion carried unanimously on a roll call vote with Taub, Moss,
Middleton and Melton absent.
Year End Adjustments applied to Revised 4th Quarter Development Report
Non
Governmental Governmental
Cust. # Customer Name Credit Debit
004 PA189 ($387,149.71)
495 Courts-Business Div-JIMS 96,787.42
509 Prob-Judicial Admin 96,787.43
145 Prosecutor-Gen Prosecution 73,545.42
Prosecutor-Admin 23,242.00
540 52/1 District Court 24,196.86
550 52/2 District Court 24,196.86
560 52/3 District Court 24,196.86
530 52/4 District Court 24,196.86 387,149.71
640 Materials Management (2,228.00)
641 Materials Mgmt - Gen Fund 2,228.00
• 600 Treasurer (864.00)
Delinquent Tax Revolving Fund 864.00
These were prepared via Journal Voucher
757 FM-Wk Release/Jail MgmtNideo Conf 5,490.00 This is being processed as a Due To/From
Prepared by Linda Munk; I.T.; 10/29/2002 4th qtr 2002-rev.xls
ACCOUNT # DIVISION
1st Qtr
Oct-Dec
2nd Qtr
Jan - Mar
3rd Qtr
Apr - June
4th Qtr
July - Sept
Health Fund 1221)
2-16-201200-33100-6030
2-16-234200-54600-6030
2-16-220200-67000-6030
Health
Health - Clinic
Health Environmental
Sub-Total Fund 221
20,358.80 4,623.80
244.00
269 487.80
$274,355.60
$2,093.00
$1,708.00
$36,891.40
$40,692.40
35,118.00
0.00
24.611,00
$59,729.00
62,193.60
1,952.00
535.017.50
599,163.10
204.027.30
$224,388.10
INFORMATION -1-QH1401LOGV
DATA PROCESSING DEVELOPMENT SUMMARY
4TH QUARTER 2002
GOVERNMENTAL FUNDS
General Fund 11011
2-32-201200-20001-6030
2-32-301200-20001-6030
2-32-401200-20001-6030
2-32-501200-20001-6030
2-17-802200-80001-6030
2-11-220100-10000-6030
2-51-211000-10000-8030
2-21-230100-31000-6030
2-21-250100-01000-6030
2-21-221000-01000-6030
2-21-240100-11000-6030
2-21-220500-40000-6030
2-17-402200-70001-6030
2-19-210000-10000-6030
2-11-250100-20000-6030
2-35-220000-12000-6030
2-35-242000-11000-6030
2-35-242000-44000-6030
2-35-242000-41000-6030
2-35-244000-31100-6030
2-35-243000-11000-6030
2-35-244000-33000-6030
2-35-230000-21200-6030
2-35-230000-22100-6030
2-35-230000-31200-6030
2-35-230000-22200-6030
2-35-210000-11000-6030
2-61-211001-10000-6030
2-11-101112-65001-6030
2-12-240000-41000-6030
2-12-601200-10001-6030
2-12-621200-10001-6030
2-51-233000-53500-6030
2-13-138502-15100-6030
2-17-912000-15000-6030
2-17-501200-50001-6030
2-15-402200-10001-6030
2-19-221000-10000-6030
2-34-403200-40001-6030
2-34-403200-40005-6030
2-34-101200-31100-6030
2-34-101200-40001-6030
2-34-101200-31200-6030
2-41-211000-41700-6030
2-41-211000-41100-6030
2-12-401200-40010-6030
2-12-701200-10001-6030
2-43-023301-20000-6030
2-13-138201-15100-6030
2-22-221120-01000-6030
2-17-302200-30001-6030
52/1 - District Court • **** $10,213.10 $11,954.25
52/2 - District Court • **** 10,213.10 11,954.25
52/3 - District Court • -** 10,213.10 11,954.25
52/4 - District Court ***• 10,213.10 11,954.25
Animal Control 1,080.00 205.20
Auditing
Board of Commissioners
Clerk - Elections 3,816.00 9,805.00
Clerk - Jury Commission 7,572.50 3,269.00
Clerk - Legal Records 7,180.00 7,015.50
Clerk - Register of Deeds 8,588.00 35,927.00
Clerk - Vital Statistics 8,213.00 13,272.00
Community Corrections Admin
Community & Economic Development 1,134.00 7,896.50
Corporation Counsel
Courts-Business Division - JIMS 183.00 4,534.00
Courts-FD-Court Services-Admin 1,028.00 4,611.00
Courts-FD-Court Services-Adoptions 8,545.00 9,904.00
Courts-FD-Court Services-Casework 108.00 184.00
Courts-FD - Judicial
Courts-FD-Judicial Support-Admin 1,202.00 1,742.00
Courts-FD Juvenile Support
Courts-GJ-Judicial Support 13,681.40 22,263.00
Courts-GJ-Assignment 2,831.50 2,638.00
Courts-GJ-Family Support 8,577.50 5,016.00
Courts-GJ-Mediation 392.00 299.00
Courts-Judicial Administration • 4,630.00 42,894.00
Drain Commissioner 3,106.00 0.00
Emergency Response & Prep Unit 13,741.25
Equalization Division • 271,409.50 243,743.00
Fiscal Services - Admin • 123,862.30 291,992.30
Fiscal Services - General • 22,483.90 0.00
Library - Admin
Materials Management - Gen Fund 14,530.25
Medical Examiner 19,664.60 9,961.80
MSU Extension - Oakland
Personnel • 71,880.80 135,563.20
Planning and Economic Development 12,256.50 4,416.00
Probate - Estates/Mental Health Admin
Probate-Estates/Mental Health Support 2,157.00 1,156.00
Probate-FD-Judicial 3,321.00 2,366.00
Probate - Judicial Admin ****
Probate-FD-Judicial Support 1,098.00 366.00
Prosecuting Attorney - General Prosecution **** 23,242.00 20,354.50
Prosecuting Attorney - Administration
Purchasing 5,597.00 16,745.25
Reimbursement Division 25,749.50 24,057.00
Sheriff 74,754.50 66,788.00
Support Services 1,563.00 1,136.00
Treasurer 69 346.00 107 738.50
Veterans
Sub-Total Fund 101 $847,085.90 $1,173,947.25
$27,923.91 $33,760.72
27,923.91 33,760.72
27,923.91 33,760.72
27,923.88 33,760.67
0.00 486.00
427.00 1,708.00
122.00 0.00
1,028.50 47,432.50
8,438.00 9,917.00
7,186.00 6,989.00
7,226.00 13,903.70
17,504.00 2,078.50
72,406.00 70,986.00
32,253.90 19,176.50
13,238.00 (13,238.00)
56,863.3 118,493.31
1,432.00 0.00
6,542.00 17,693.50
0.00 0.00
1,870.40
1,089.00 831.00
582.00 1,361.00
15,684.50 15,100.00
916.00 2,906.00
736.00 2,439.00
603.00 61.00
11,596.00 1,432.00
610.00 58,557.00
600.00 6,617.00
253,102.50 240,946.00
237,163.50 249,681.90
0.00 0.00
122.00 0.00
723.00 8,711.75
16,052.40 2,484.00
244.00 0.00
150,977.00 161,349.10
122.00 (122.00)
1,380.00 0.00
2,361.00 0.00
2,028.00 3,668.40
54,032.13 107,943.81
915.00 0.00
82,593.13 98,130.31
23,242.00
1,512.00 1,080.00
16,067.90 20,230.25
56,386.50 47,711.50
2,809.00 1,328.00
101,073.50 122,491.40
122.00 (122,00)
$1,348,565.20 $1,610,393.66
$83,851.98
83,851.98
83,851.98
83,851.90
1,771.20
2,135.00
122.00
62,082.00
29,198.50
28,370,50
65,844.70
39,065.50
143,392.00
60,460.90
0.00
180,073.44
7,071.00
40,684.50
292.00
1,670.40
4,864.00
1,943.00
66,708.90
9,291.50
16,7138.50
1,355.00
60,552.00
62,273.00
20,958.25
1,009,201.00
902,700.00
22,483.90
122.00
23,965.00
48,162.80
244.00
519,770.10
16,672.50
1,380.00
5,674.00
11,383.40
161,975.94
2,379.00
224,319.94
23,242.00
24,934.25
86,104.65
245,640.50
6,834.00
400,649.40
0.00
4,979,992.01
Juvenile Maintenance Fund 12931
2-16-501200-25001-6030 Children's Village 3 618.00 2 538.00 $270.00 0.00 6.426.00
Sub-Total Fund 293 $3,618.00 $2,538.00 $270.00 $0.00 8,428.00
18-636111-10000-0735 DATA PROCESSING DEVELOPMENT FOR $1,075,090.00 $1,450,840.85 $1,389,527.60 $1,670,122.88 $5,585,581.11
GOVERNMENTAL FUND APPROPRIATION
Clerk Image 50,495.00 51,111.00 $18,279.00 81,547.50 181,432.50
Courts-FD-Juv-Sup-Imaging 108.00 108.00 648.00 216.00 1 080.00
Probate-Estates/Mental Health Image 15,128.00 20__ 043 00
3 641.00 2,518.00 41,328.00
18-636111-10000-0573 TOTAL IMAGING DEVELOPMENT $65,729.00 $71,252.00 $22,568.00 $64,281.50 $223,840.50
APPROPRIATION
SUB-TOTAL GOVERNMENTAL! IMAGING DEVELOPMENT APPROPRIATION: $1,140,819.00 $1,522,102.85 $1,412,095.60 $1,734,404.16 $5,809,421.61
90-290000-25000-6030 Information Technology Development W.140.819.00) ($1.522.102 85) ($1,412,09S.60) (51.734.404.16) (55.809,421.61)
TOTAL GOVERNMENT: $0.00 $0.00 $0.00 $0.00 0.00
• 1st Quarter invoiced in January 2002
**** Journal Voucher prepared redistributing PA 189 over commitment
Journal Vouchers prepared transferring funds from Materials Management Fund to General Fund
IMAGING
2-21-221000-01000-6039
2-35-243000-33000-6039
2-34-403200-40005-6039
Prepared by: Lisa Schmidt, Info Tech; 10/29/2002; 10:47 AM 4th qtr 2002-rev.xls
1st Qtr 2nd Qtr 3rd Qtr
ACCOUNT 9 DIVISION Oct - Dec Jan - Mar Apr - June Y.T.D.
4th QV
July - Sept
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
4TH QUARTER 2002
NON-GOVERNMENTAL
DIRECT CHARGES CLEMIS • $91,466.25 $2,590.00 $0.30 0.00 594056.25
Community Corrections 446.00 5,946.00 0.00 0.00 6,392.00
Courts-FOC-Exp-CS Enforcement 277.00 2,026.00 366.30 169.00 2838.00
Courts-FOC Exp-CS Enforcement Image 6,154.00 12,085.00 7,490.30 8,063.00 33,792.00
Courts-FOC Exp-Family Counseling 4220.00 0.00 460.30 0.00 4,680.00
Fire Records Management System '• 54,460.00 24,948.00 35,424.00 114,832.00
FM-IM( Rel/Jail Mgt/Vido Conf 5,490.00 5,490.00
FM & 0 366.00 0.00 1,403.00 1,769.00
Health Immunization 1,198.80 2,467.80 1,242.00 729.00 5,637.60
Materials Management ***** 2,228.00 0.00 0.00 (2,228.00) 0.00
Medical Care Facility 2,322.80 8,813.60 7,518.20 6,360.00 25,014.80
O.C. International Airport 122.00 0.00 122.00
PA189 Projects • **** 218,841.96 217,819.50 0.00 (387,149.71) 49,511.75
- -, Parks and Recreation - Administration 244.00 34,788.80 4,457.00 (16,575.40)- 22,914.40
Risk Management 1,446.00 2,662.00 21,274.00 46,313.54 71,695.54
Treasurer - 100% Tax Payment Fund 12,778.00 2,125.00 3,075.00 244.00 18,222.00
Treasurers Delinquent Tax Revolving Fund 864.00 864.00
• Water & Sewer Accounting 5 643 00 4700 72,733.10 31,112.00 114,063.10
I Workforce Development 122 00 (122.00) 0.00
18-636111-10000-0715 SUB-TOTAL DIRECT CHARGES FOR DATA $347.265.81 $350,724.70 $143.807.30 (5269.903.57) $571,894.24
PROCESSING DEVELOPMENT
TOTAL COUNTY DEVELOPMENT CHARGES $1,488,084.81 $1,872,827.55 $1,555,902.90 $1,464,500.59 $6,381,315.85
NON-COUNTY AGENCIES
18-636111-10000-0429 Non-County Agencies $0.00 $0.00 $0.00 $0.00 $0.00
TOTAL DEVELOPMENT CHARGES $1,488,084.81 $1,872,827.55 $1,555,902.90 $1,464,500.59 $6,381,315.86
• lot Quarter invoiced in January 2002
" 1st Qtr $28,676; 2nd Qtr $24,246
**** Journal Voucher prepared redistributing PA 189 over commitment
•••"'• Journal Vouchers prepared transferring funds from Materials Management Fund to General Fund
Prepared by Lisa Schmidt, Info Tech; 10129/2002; 10:47 AM 4th qtr 2002-rev.xls
36510 GIS Implementation Support-ROD
95493 Reg Deeds System Maintenance
95498 Clerk/Reg of Deeds
95558 User Support/ROD
Clerk/Reg of Deeds - Total
$810.00
3,782.00
5,011.20
4,300.50
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2002
Gust* GOVERNMENTAL FUNDS
630 ANIMAL CONTROL
620 AUDITING
440 CLERK - ELECTIONS
720 CLERK / REGISTER OF DEEDS
722 CLERK - IMAGING
410 CLERK - JURY COMMISSION
724 CLERK - LEGAL RECORDS
723 CLERK - VITAL STATISTICS
522 COMMUNITY CORRECTIONS-ADMIN (CO)
785 COMMUNITY & ECO DEVELOPMENT
430 CORPORATION COUNSEL*"
495 CTS-BUSINESS DIV -JIMS
492 CTS-FD-CT SERV-ADOPTIONS
505 CTS-FD-JUDICIAL
483 CTS-FD-JUDICIAL SUPPORT-ADM
474 CTS-FD-JUVENILE SUPPORT
488 CTS-FD-JUV SUPP-IMAGING
65420 Clerk - Image Replace - 21%
95158 Clerk - Imaging
Clerk - Imaging - Total
95512 Jury Commission
Clerk -Jury Commission - Total
95170 Legal Division
95189 Circuit Court System
Clerk - Legal Records - Total
95161 Vital Stats Index
Clerk - Vital Statistics - Total
52200 Comm Corr-Admin (County)
Community Corrections - Total
36500 GIS Implementation Support C&E Dev
95785 Comm & Eco Developmt
Community & Eco Dev - Total
95501 Corporation Counsel
Corporation Counsel - Total
90603 JIMS - Circuit Court - 25%
90603 JIMS - Circuit Court - 25% ****
95176 CTS-Business Div - JIMS
CTS-Business Div - JIMS - Total
95173 CTS-FD-Ct Serv-Adoptions
CTS-FD-Ct Serv-Adoptions - Total
95186 CTS-FD/ADMIN-Family Judges
CTS-FD-Judicial - Total
95193 CTS-FD-Judicial Suport-Adm
CTS-FD-Judicial Suport-Adm - Total
95474 CTS-FD-Admin-Juvenile Support
CTS-FD-Juvenile Support - Total
48201 CTS-FD-Juv Supp-Imaging
CTS-FD-Juv Supp-Imaging - Total
$6,548.00
54 999.50
$9,917.00
$244.00
6,745.00
$2,076.50
$70,986.00
$4,312.00
14 864.50
($13,238.00)
$11,156.39
96,787.42
10 549.50
$17,693.50
$1,670.40
$831.00
$1,361.00
$216.00
95682 Dog System $486.00
Animal Control-Total $486.00
95468 Auditing-Cust Supt $1,708.00
Auditing - Total $1,708.00
95443 Elections $47,432.50
Clerk -Elections - Total $47,432.50
$13,903.70
$61,547.50
$9,917.00
$6,989.00
$2,076.50
$70,986.00
$19,176.50
($13,238.00)
$118,493.31
$17,693.50
$1,670.40
$831.00
$1,361.00
$216.00
Prepared by Lisa Schmidt: Info Tech: 10/29/2002 1 4th qtr 2002-rev.xls
$8,711.75
$2,484.00
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2002
Gust* GOVERNMENTAL FUNDS
499 CTS-GJ-ASSIGNMENT 95180 CTS-GJ-Assignment $2,906.00
CTS-GJ-Assignment - Total $2,906.00
420 CTS - GJ - FAMILY SUPPORT 95195 Cir Crt Admin $2,439.00
Courts - GJ - Family Support - Total $2,439.00
$15,100.00
500 CTS-GJ-MEDIATION 95181 CTS-GJ-Mediation $61.00
CTS-GJ-Mediation - Total $61.00
493 CTS-JUDICIAL ADMIN 95174 CTS-Judicial Admin $1,432.00
CTS-Judicial Admin - Total $1,432.00
730 DRAIN COMMISSIONER 28009 Drain Commissioner $183.00
498 CTS-GEN JURIS-JUDICIAL SUPPT 95179 CTS -Gen Juris-Judicial Suppt $15,100.00
CTS -Gen Juris-Judicial Suppt - Total
28011 Drain Commissioner Application 45,306.00
36520 GIS Implementation Support Drain 13 068.00
Drain Commissioner - Total
900 EMERGENCY RESPONSE & PREPAREDNESS 36545 GIS Implementation Support EMS $6,617.00
EMS - Total
740 EQUALIZATION 31075 Equal - Development $17,768.00
36505 GIS Implementation Support Equalization 6,787.50
95559 User Support/Equal 53,706.50
95693 Equal-System Maintenance 162 684.00
Equalization - Total
660 FISCAL SERVICES ADMIN 44021 FS-System/Customer Support $35,349.00
44022 FS-System Maintenance 37,132.50
44023 FS-System Enhancements 42,564.00
44024 FS-New Development 23,074.00
44077 BUD-System Maintenance 432.00
95702 PSMS-Fiscal Services-25% 5,962.75
95703 PSMS-Budget-25% 5,962.75
96001 Human Res-Acct 66,136.60
96003 Human Res.-Budget 33 068.30
Fiscal Services Admin - Total
840 HEALTH DEPARTMENT 36525 GIS Implementation Support Health $610.00
37025 CHAMPS - P.O.P. 26,456.00
96842 Health - Admin 8,052.00
Health - Total
843 HEALTH - ENVIRONMENTAL 37002 Environmental $216.00
84200 EH - Projects 24,395.00
Health-Environmental - Total
641 MATERIALS MGMT-GEN SUPPORT SERV 95440 Materials Management $521.00
95440 Materials Management 2,228.00
95704 PSMS-Materials Mgmt-25% 5,962.75
Materials Mgmt-Gen Fund - Total
872 MEDICAL EXAMINER 87202 Med Exam - Cust Support $2,484.00
Medical Examiner - Total
680 PERSONNEL 44043 PER-System Enhancements $108.00
95556 Personnel User Supt 4,040.00
96002 Human Res-Personnel 157 201.10
Personnel - Total
$58,557.00
$6,617.00
$240,946.00
$249,681.90
$35,118.00
$24,611.00
$161,349.10
Prepared by Lisa Schmidt: Info Tech; 10/29/2002 2 4th qtr 2002-rev.xls
195 SHERIFF
445 SUPPORT SERVICES
97163 Sheriff 47,495.50
97164 Sheriff - Development 216.00
Sheriff - Total $47,711.50
44500 Support Services $1,326.00
Support Services - Total $1,326.00
600 TREASURER
910 VETERANS SERVICES*
540 5211 DISTRICT COURT - NOVI
550 52/2 DISTRICT COURT - CLARKSTON
$122,491.40
($122.00)
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2002
Gust* GOVERNMENTAL FUNDS
775 PLANNING & ECONOMIC DEVELOPMENT* 95600 Customer / System Support -$122.00
Planning & Eco Development - Total ($122.00)
509 PROB-JUDICIAL ADMIN 90604 JIMS Probate 25% $11,156.38
90604 JIMS Probate 25% **** 96 787.43
Prob-Judicial Admin - Total $107,943.81
612 PROB-ESTATES/MENTL HLTH IMAGE 95207 Prob-Est/Mntl Hlth Image $2,518.00
Prob-Est/Mntl Hlth Image - Total $2,518.00
481 PROBATE-FD JUDICIAL 95168 Prob-FD Judicial $3,668.40
Prob-FD Judicial - Total $3,668.40
145 PROSECUTOR - GENERAL PROSECUTION 90605 JIMS - Prosecutor 25% $11,156.39
90605 JIMS - Prosecutor 25% **** 73,545.42
95619 PROMIS 648.00
95622 Prosecutor/Executive 12,719.50
97001 Prosecutor Data Proc 61.00
Prosecutor - Total $98,130.31
PROSECUTOR - ADMINISTRATION 90605 JIMS - Prosecutor 25% **** $23,242.00
Prosecutor Admin - Total $23,242.00
690 PURCHASING 44026 PUR-System/Customer Support $432.00
44027 PUR-System Maintenance 648.00
Purchasing - Total $1,080.00
650 REIMBURSEMENT 95470 Reimbursement System $7,578.00
95542 Reimburse User Support 6,689.50
95701 PSMS-Purchasing - 25% 5,962.75
Reimbursement - Total $20,230.25
44061 Tre-System/Customer Support 3,697.40
44062 Tre-System Maintenance 10,118.00
44063 Tre-System Enhancements 16,440.00
95303 Del Tax System Maintenance 39,266.00
95561 User Support/Del Tax 53,834.00
Delinquent Tax Revolving Fund Transfer (864.00)
Treasurer - Total
95651 Veterans Cust Supp ($122.00)
Veterans - Total
90606 JIMS - 5211 DC - 6.25% $2,789.11
90606 JIMS - 52/1 DC - 6.25% **** 24,196.86
95527 DC Suprt-25%-52/1 6,774.75
52/1 District Court - Total
90607 JIMS - 52/2 DC - 6.25% $2,789.11
90607 JIMS - 52/2 DC - 6.25% **** 24,196.86
95528 DC Suprt-25%-52/2 6,774.75
52/2 District Court - Total
$33,760.72
$33,760.72
Prepared by Lisa Schmidt: Info Tech: 10/29/2002 3 4th qtr 2002-rev.xls
$2,789.11
24,196.86
6.774.75
$33,760.72
$2,789.06
24,196.86
6,774.75
$33,760.67
INFORMATION TECHNOLOGY. RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2002
Cust # GOVERNMENTAL FUNDS
560 5213 DISTRICT COURT. ROCHESTER
530 5214 DISTRICT COURT. TROY
90608 JIMS - 52/3 DC - 6.25%
90608 JIMS - 52/3 DC - 6.25% ****
95529 DC Suprt-25%-52/3
52/3 District Court - Total
90609 JIMS - 52/4 DC - 6.25%
90609 JIMS - 52/4 DC - 6.25% ****
95530 DC Suprt-25%-52/4
52/4 District Court - Total
4 4th qtr 2002-rev.xls Prepared by Lisa Schmidt; Info Tech; 10/29/2002
$169.00
$8,063.00
$35,424.00
$5,490.00
$169.00
$8,063.00
$35,424.00
$5,490.00
$23,444.50
7,019.50
648.00
$31,112.00
($122.00)
$0.00
($122.00)
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2002
Cust # DIRECT FUNDS
507 CTS-FOC EXP-CS ENFORCEMENT 92193 CTS-FOC Exp-CD Enforc-Dev
CTS-FOC Exp-CD Enforc-Dev - Total
471 CTS-FOC-EXP-CS ENFORC-IMAGE 92194 CTS-FOC-Exp-CS Enf-Image
CTS-FOC Exp-CS Enf-Image - Total
210 FIRE RECORDS MANAGEMENT SYSTEM 21010 Fire Records Mg mt Fund 531
Fire Records Mgmt - Total
757 FM-WK RELEASE/JAIL MGMTNIDEO CONF 75700 Fac Mgmt - Video Arraignments
FM-Wk Rel/Jail MgmtNideo Conf - Total
750 FM&O
380 HEALTH IMMUNIZATION - GRANT
640 MATERIALS MANAGEMENT
870 MEDICAL CARE FACILITY
004 PA 189
770 PARKS AND RECREATION **
695 RISK MANAGEMENT***
602 TREASURER-100% TAX PAYMENT FUND
TREASURERS DEL TAX REVOLVING FUND
656 WATER & SEWER ACCTG
850 WORKFORCE DEV DIVISION *
NON-COUNTY AGENCIES
21001 FM&O I $1,281.00
75503 FMO Development 122.00
FM&O - Total
38000 Health - Immunization $729.00
Health - Immunization - Total
95440 Materials Management ($2,228.00)
Materials Management - Total
98873 MCF - Support $6,360.00
MCF - Support - Total
• 90601 JIMS Project **** ($387,149.711
PA 189- Total
36530 GIS Implementation Support Parks Dept $427.00
95419 PRADM-Administration (17,002.40)
Parks & Recreation - Total ($16,575.40)
95695 Risk Management $46,313.54
Risk Management - Total $46,313.54
95310 Del Tax Act 123 Project $244.00
Treasurer 100% Tax Pymt Fund - Total $244.00
Treasurers Del Tax Revolving Tax Fund $864.00
$864.00
44049 WS-New Development
95669 Water & Sewer Acct'g
95671 Drain Water/Sewer Billing
Water & Sewer Acct'g - Total
95670 Emp & Trn
Workforce Dev Division - Total
$1,403.00
$729.00
($2,228.00)
$6,360.00
($387,149.71)
* Corrections to 3rd Quarter Development
** Parks & Recreation received a credit after disputing 2nd Quarter Development charges.
*** $13,238 credited to Corporation Counsel and debited to Risk Management
**** Journal Vouchers prepared to redistribute PA189 over commitment
Journal Vouchers prepared transferring from Materials Management Fund to General Fund
Prepared by Lisa Schmidt; Info Tech; 10/29/2002 5 4th qtr 2002-rev.xls
30001 IT Disc Data Warehouse
30002 IT DISC Enhanced Access
30003 IT DISC GIS
30004 IT DISC E-Government
36500 GIS Implemen Support - CED
36505 GIS lmplemen Support-Equal
36510 GIS Implemen Support-ROD
36520 GIS Implemen Support-Drain
36625 GIS Implemen Support-Health
36530 GIS Implemen Support - Parks
36545 GIS Implemen Support-EMS
DISC - Sub-Total:
91516 CVT - New Development
95456 Equipment Inventory
Sys Dev Support - Sub Total:
25200 Open Systems Administration
25400 Oracle Administration
95685 I.T. - Disaster Recovery
95689 Database Tech Support
Tech Sys/Net - Sub-Total:
Digital Information Service Center
Systems Develop/Support
Technical Sys/Networking
Information Technology - Total:
INFORMATION TECHNOLGY
DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2002
1st Quarter I 2nd Quarter 3rd Quarter I 4th Quarter H Y.T.D. I
$88,875.50 $85,831.00 $8,752.00 $10,353.00 $193,811.50
36,713.50 15,377.00 $5,005.50 $28,190.50 85,286.50
84,721.00 92,698.00 $101,407.50 $96,875.00 375,701.50
$16,682.00 $50,132.00 66,814.00
1,350.00 1,080.00 $2,538.00 $0.00 4,968.00
1,080.00 864.00 $1,471.50 $0.00 3,415.50
972.00 $0.00 972.00
1,674.00 62,316.00 $60,966.00 $0.00 124,956.00
216.00 $702.00 $0.00 918.00
$324.00 $0.00 324.00
3,942.00 18,529.00 16 532.50 0.00 39 003.50
$218,356.00 $277,883.00 $214,381.00 $185,550.50 $896,170.50
45,479.00 32,803.00 ' 25,620.00 4,514.00 108,416.00
540.00 324.00 2,403.00 1,323.00 4,590.00
$46,019.00 $33,127.00 $28,023.00 $5,837.00 $113,006.00
$5,246.00 $2,684.00 $12,749.00 $10,431.00 $31,110.00
283,412.00 182,008.00 $296,906.00 $188,612.00 950,938.00
406.00 1,122.00 704.00 1,816.00 4,048.00
20,489.00 19 276.00 16,104.00 41 175 00 97,044.00
$309,553.00 $205,090.00 $326,463.00 $242,034.00 $1,083,140.00
$573,928.00 $516,100.00 $568,867.00 $433,421.50 $2,092,316.50
Prepared by Lisa Schmidt; Info Tech; 10/29/2002 4th qtr 2002-rev.xls
Resolution #02281 November 21, 2002
The Chairperson referred the resolution to the Finance Committee. There were no objections.
$99,627
($99,627)
$0
FISCAL NOTE (MISC. #02281) December 12, 2002
BY: FINANCE COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FOURTH QUARTER 2002
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 Fourth Quarter 2002 Development cost to benefiting
departments.
2. The fourth quarter data processing development charges are
$1,670,122.66; imaging development charges are $64,281.50 for
General Fund/General Purpose departments; direct charges to
Special Revenue and Proprietary fund departments are
($269,903.57); and charges to non-county agencies are $0.
3. The respective departmental Fiscal Year 2002 budgets are to be
amended as specified in the attached detail schedule.
4. Additionally, the Fire Records Management (FRMS) Fund is to be
reimbursed $99,627.00. This represents the previously agreed
to 75 96 General Fund contribution to the FRMS Fund to offset
the ongoing expenses (the CVTs provide the remaining 25%).
This transaction is in addition to those in the attached
schedule. A worksheet is attached to summarize transfers.
General Fund (101)
90-290000-25000-6030 IT Development Appropriation
90-310000-40000-8001 Operating Transfer Out
Fire Records Management Fund (531)
23-531003-531001-1701 Operating Transfer In
Change in Fund Balance
($99,627)
$99,627
$0
FINANCE COMMITTEE
FINANCE COMMITTEE
Motion carried unanimously on a roll call vote with Taub and Melton
absent.
FOREGONG FIES01. '
PAfterson. Cculty Executive Date
'../r7r1""
G. William Caddell, County Clerk
Resolution #02281 December 12, 2002
Moved by Sever supported by Suarez the resolutions on the Consent Agenda, be adopted (with
accompanying reports being accepted).
AYES: Brian, Buckley, Causey-Mitchell, Crawford, Dingeldey, Douglas, Galloway, Gregory, Law,
McPherson, Melton, Middleton, Moffitt, Moss, Obrecht, Palmer, Patterson, Sever, Suarez,
Webster, Appel. (21)
NAYS: None. (0)
A sufficient majority having voted therefore, the resolutions on the Consent Agenda, were adopted (with
accompanying reports being accepted).
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, G. William Caddell, 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
December 12, 2002, 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 December, 2002.