HomeMy WebLinkAboutResolutions - 2001.03.08 - 26475MISCELLANEOUS RESOLUTION #01032 February 22, 2001
BY: General Government Committee, William R. Patterson, Chairperson
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FIRST QUARTER 2001
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 2001 data processing development charges to be $1,168,851
and the imaging development charge to be $44,564 for the General
Fund/General Purpose County departments; and
WHEREAS direct charges to Special Revenue and Proprietary fund
departments are $234,340 and non-county agencies are $42,273 for the
First Quarter 2001; 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 First Quarter 2001 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:
Motion carried unanimously on a roll call vote.
General Fund 11011
101 2-32-201200-20001-6030
101 2-32-301200-20001-6030
101 2-32-401200-20001-6030
101 2-32-501200-20001-6030
101 2-17-802200-10001-6030
101 2-21-220100-01000-6030
101 2-21-230100-01000-6030
101 2-21-250100-01000-6030
101 2-21-221000-01000-6030
101 2-21-240100-01000-6030
101 2-21-220500-01000-6030
101 2-35-242000-11000-6030
101 2-35-242000-42000-6030
101 2-35-242000-43000-6030
101 2-35-242000-44000-6030
101 2-35-243000-11000-6030
101 2-35-230000-21200-6030
101 2-35-230000-22100-6030
101 2-35-230000-31200-6030
101 2-35-230000-25000-6030
101 2-35-230000-22200-6030
101 2-35-210000-11000-6030
101 2-12-240000-44100-6030
101 2-12-601200-10001-6030
101 2-12-621200-10001-6030
101 2-16-912000-15000-6030
101 2-17-501200-10001-6030
101 2-15-402200-10001-6030
101 2-34-403200-40001-6030
101 2-34-403200-40005-6030
101 2-34-101200-31100-6030
101 2-34-101200-31200-6030
101 2-41-211000-10000-6030
101 2-12-401200-40010-6030
101 2-12-701200-10001-6030
101 2-43-023301-20000-6030
101 2-13-138201-00010-6030
101 2-22-221120-01000-6030
Friend of the Court Fund 12151
215 2-35-241215-71000-6030
215 2-35-241215-81000-6030
Health Fund 12211
221 2-16-201200-33100-6030
221 2-16-234200-54600-6030
221 2-16-220200-67000-6030
293 2-16-501200-25001-6030
18-636111-10000-0735
2-21-221000-01000-6039
2-35-241215-71000-6039
2-34-403200-40005-6039
18-636111-10000-0573
90-290000-25000-6030
ACCOUNT #
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
1ST QUARTER 2001
1st Qtr 2nd Qtr 3rd Qtr 4th Qtr
DIVISION Oct - Dec Jan - Mar Apr - June July - Sept Y T.D.
52/1 District Court
52/2 District Court
52/3 District Court
52/4 District Court
Animal Control
Clerk - Admin
Clerk - Elections
Clerk - Jury Commission
Clerk - Legal Records
Clerk - Register of Deeds
Clerk - Vital Statistics
Courts-FD-Court Services-Admin
Courts-FD-Court Services-Clinic
Courts-FD-Ccurt Services-Youth Assistance
Courts-FD-Court Services-Adoptions
Courts-FD-Judicial Support-Admin
Courts-GJ-Judicial Support
Courts-GJ-Assignment
Courts-GJ-Family Support
Courts-GJ-Legal
Courts-GJ-Mediation
Courts-Judicial Administration
Equalization Division
Fiscal Services - Admin
Fiscal Services - General
Medical Examiner
M.S.U. Extension - Oakland
Personnel
Probate-Estates/Mental Health Admin
Probate-Estates/Mental Health Support
Probate-FD-Judicial
Probate-FD-Judicial Support
Prosecuting Attorney
Purchasing
Reimbursement Division
Sheriff
Support Services
Treasurer
Sub-Total Fund 101
Courts-FOC-Exp-CS Enforcement
Courts-FOC Exp-Family Counseling
Sub-Total Fund 215
Health
Health - Clinic
Health Environmental
Sub-Total Fund 221
11,716.73 0.00 0.00 0.00 11,716.73
11,716.73 0.00 0.00 0.00 11,716.73
11,716.73 0.00 0.00 0.00 11,716.73
11,716.73 0.00 0.00 0.00 11,716.73
1,976.94 0.00 0.00 0.00 1,976.94
22.26 0.00 0.00 0.00 22.26
58,545.00 0.00 0.00 0.00 58,545.00
6,836.70 0.00 0.00 0.00 6,836.70
30,835.97 0.00 0.00 0.00 30,835.97
3,813.56 0.00 0.00 0.00 3,813.56
1,640.54 0.00 0.00 0.00 1,640.54
1,090.86 0.00 Imo 0.00 1,090.86
1,596.00 0.00 0.00 0.00 1,596.00
44.52 coo am 0.00 44.52
8,999.08 0.00 0.00 0.00 8,999.08
1,472.70 0.00 0.00 0.00 1,472.70
36,327.35 0.00 0.00 0.00 36,327.35
9,663.86 0.00 0.00 0.00 9,663.86
14,586.00 0.00 0.00 0.00 14,586.00
18,747.00 0.00 0.00 0.00 18,747.00
1,340.90 0.00 am 0.00 1,340.90
1,380.28 0.00 0.00 0.00 1,380.28
143,817.20 0.00 0.00 0.00 143,817.20
182,377.26 0.00 0.00 0.00 182,377.26
46,130.77 0.00 0.00 0.00 46,130.77
47,864.46 0.00 0.00 0.00 47,864.46
997.37 0.00 0.00 0.00 997.37
89,411.95 0.00 0.00 0.00 89,411.95
2,486.26 0.00 0.00 0.00 2,486.26
7,605.62 0.00 0.00 0.00 7,605.62
4,490.10 0.00 0.00 0.00 4,490.10
522.07 0.00 0.00 0.00 522.07
18,524.83 0.00 0.00 0.00 18,524.83
534.30 0.00 0.00 0.00 534.30
11,860.00 0.00 0.00 0.00 11,860.00
77,540.02 0.00 0.00 0.00 77,540.02
30,719.05 0.00 0.00 0.00 30,719.05
68 454.57 0.00 0.00 0.00 68 454.57
979,122.27 0.00 0.00 0.00 979,122.27
69,411.81 0.00 0.00 0.00 69,411.81
22 244.20 0.00 0.00 0.00 22 244.20
91,656.01 0.00 0.00 0.00 91,656.01
1,429.27 0.00 0.00 0.00 1,429.27
22,223.40 0.00 0.00 0.00 22,223.40
65 203.27 0.00 0.00 0.00 65 203.27
88,855.94 0.00 0.00 0.00 88,855.94
Juvenile Maintenance Fund 12931
Children's Village
Sub-Total Fund 293
DATA PROCESSING DEVELOPMENT FOR
GOVERNMENTAL FUND APPROPRIATION
Clerk Image
Courts-FOC Exp-CS Enforcement Image
Probate-Estates/Mental Health Image
TOTAL IMAGING DEVELOPMENT
APPROPRIATION
Information Technology Development
TOTAL GOVERNMENT:
9,216.71 0.00 0.00 0.00 9,216.71
9,216.71 0.00 0.00 0.00 9,216.71
1,168,850.93 0.00 0.00 0.00 1.168,850.93
14,072.96 0.00 0.00 0.00 14,072.96
18,034.70 0.00 0.00 0.00 18,034.70
12 455.94 0.00 0.00 0.00 12 455.94
44,563.60 0.00 0.00 0.00 44 563.60
(1,213,414.53) 0.00 0.00 0.00 (1,213,414.53)
$0.00 $0.00 $0.00 $0.00 0.00
Prepared by: Linda Munk, Info Tech; 1/30/2001; 9:04 AM 1fy2001.xlw
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT. SUMMARY
1ST QUARTER n01
ACCOUNT #
1st Qtr 2nd Qtr 3rd Qtr 4th Qtr
DIVISION Oct - Dec Jan - Mar Apr - June July - Sept Y.T.D.
Community Corrections
Community Development Grant
Facilities Maintenance & Operations
Health Immunization
Medical Care Facility
PA189 Projects
Parks and Recreation - Administration
Treasurer - 100% Tax Payment Fund
Water & Sewer Accounting
18-636111-10000-0715 DIRECT CHARGES FOR DATA
PROCESSING DEVELOPMENT
10,490.98 0.00 0.00 0.00 10,490.98
54.95 0.00 0.00 0.00 54.95
89.05 0.00 0.00 0.00 89.05
6,937.08 0.00 0.00 0.00 6,937.08
16,127.36 0.00 0.00 0.00 16,127.36
163,173.89 0.00 0.00 0.00 163,173.89
5,759.86 0.00 0.00 0.00 5,759.86
25,606.56 0.00 0.00 0.00 25,606.56
6,100.01 0.00 0.00 0.00 6,100.01
$234,339.74 $0.00 $0.00 $0.00 234,339.74
TOTAL DEVELOPMENT CHARGES $1.447.764.27 $0.00 $0.00 $0.00 1.447.764.27
18-636111-10000-0429 Sidwell 42 273.02 0.00 0.00 0.00 42 273.02
TOTAL NON-COUNTY AGENCIES 42 273.02 0.00 0.00 0.00 42 273.02
(Information Purposes Only) Information Technology 737,902.01 0.00 0.00 0.00 737 902.01
Prepared by: Linda Munk, Info Tech; 1/25/2001; 12:39 PM 1fy2001.xlw
722 CLERK - IMAGING 65420 Clerk - Image Replace - 21%
95158 Clerk - Imaging
Clerk - Imaging - Total
$13,093.40
979.56
$14,072.96
$6,836.70
$6,836.70
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER, F.Y. 2001
Cust # GOVERNMENTAL FUNDS
630 ANIMAL CONTROL 95682 Dog System $1,976.94
Animal Control - Total $1,976.94
665 CHILDRENS VILLAGE 95665 Childrens Village $9,216.71
Childrens Village - Total $9,216.71
725 CLERK - ADMIN 72500 Clerk - Admin $22.26
Clerk - Admin - Total $22.26
720 CLERK / REGISTER OF DEEDS 95493 Reg Deeds System Maintenance $1,340.58
95558 User Support/ROD 2 472.98
Clerk/Reg of Deeds - Total $3,813.56
440 CLERK ELECTIONS 95443 Elections $58.545.00
Elections - Total $58,545.00
410 CLERK - JURY COMMISSION 95512 Jury Commission
Jury Commission - Total
724 CLERK - LEGAL RECORDS 95170 Legal Division $13,109.05
95189 Circuit Ct System 17 726.92
Clerk - Legal records - Total $30,835.97
723 CLERK -VITAL STATISTICS 95161 Vital Stats Index $1,640.54
Clerk - Vital Statistics - Total $1,640.54
487 COURTS-FD-COURT SERVICES-ADMIN 95196 CTS-FD-Court Services-Admin $1,090.86
Courts FD Court Services Admin - Total $1,090.86
490 COURTS-FD-COURT SERVICES CLINIC 95171 CTS-FD-Court Services Clinic $1,596.00
Courts FD Court Services Clinic - Total $1,596.00
491 COURTS-FD-CT SERVICES YOUTH ASST 95172 CTS-FD-Ct Services Youth Asst $44.52
Courts FD Ct Services Youth Asst -Total $44.52
492 COURTS-FD-CT SERV-ADOPTIONS 95173 CTS-FD-Ct Serv-Adoptions $8,999.08
Courts FD Ct Serv Adoptions - Total $8,999.08
483 COURTS-FD-JUDICIAL SUPPORT-ADMIN 95193 CTS-FD-Judicial Support-Adm $1,472.70
Courts FD Judicial Suppt Adm - Total $1,472.70
507 COURTS-FCC EXP-CS ENFORCEMENT 92193 CTS-FOC Exp-CD Enforcement - Dev $69,411.81
Courts-FOC Exp-CS Enforcement - Total $69,411.81
471 COURTS-FOC-EXP-CS ENFORCE-IMAGE 92194 CTS-FOC Exp-CS Enf-Image-Dev $18,034.70
FOC Develop Image - Total $18,034.70
420 COURTS-GJ-FAMILY SUPPORT 95195 Cir Court Admin $5,682.00
95452 Assignment Clerk 8,904.00
Circuit Court - Total $14,586.00
498 COURTS-GJ-JUDICIAL SUPPORT 95179 CTS-Gen Juris-Judicial Suppt $36,327.35
Courts Gen Juris Judicial Suppt - Total $36,327.35
Prepared by: Linda Munk, Info Tech; 1/25/2001; 12:41 PM 1 1fy2001.xlw
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER, F.Y. 2001
Cust # GOVERNMENTAL FUNDS
499 COURTS-GJ-ASSIGNMENT 95180 CTS-GJ-Assignment $9,663.86
Courts-GJ-Assignment - Total
470 COURTS-FOC-FAMILY COUNSELING 34041 CTS-FOC Exp-Fam Counseling $928.74
92195 CTS-FOC Exp-Fam Couns-Dev 21 315.46
Friend of the Court - Total
503 COURTS-GJ-LEGAL 95184 CTS-GJ-Legal $18,747.00
Courts-GJ-Legal - Total
500 COURTS-GJ-MEDIATION 95181 CTS-GJ-Mediation $1,340.90
Courts-GJ-Mediation - Total
493 COURTS-JUDICIAL ADMIN 95174 CTS-Judicial Admin $1,380.28
Courts Judicial Admin - Total
740 EQUALIZATION 31075 Equal - Development $36,096.26
31078 EPP-Development 12,297.15
95559 User Support/Equal 16,857.78
95690 Personal Property 48,041.96
95693 Equal-System Maintenance 30 524.05
Equalization - Total
660 FISCAL SERVICES ADMIN 44021 FS-System/Customer Support $61,159.06
44022 FS-System Maintenance 31,806.24
96001 Human Services - Acct'g 89 411.96
Fiscal Services Admin - Total
670 FISCAL SERVICES - GENERAL 44076 Bud-System/Customer Support $1,424.80
96003 Human Resources - Budget 44 705 97
Fiscal Services - General - Total
$9,663.86
$22,244.20
$18,747.00
$1,340.90
$1,380.28
$143,817.20
$182,377.26
$46,130.77
840 HEALTH DEPARTMENT 37025 CHAMPS - P.O.P. $1,224.45
96842 Health - Admin 204.82
Health - Total $1,429.27
845 HEALTH - CLINIC 37007 Clinic $22,223.40
Health-Clinic - Total $22,223.40
$65,203.27
872 MEDICAL EXAMINER 87202 Med Exam - Gust Support $47,864.46
Medical Examiner - Total $47,864.46
710 M.S.U. EXTENSION 95676 Coop Ext Equipment Maintenance $997.37
M.S.U. Extension - Total $997.37
680 PERSONNEL - HUMAN RESOURCES DIV 96002 Human Res. - Personnel $89,411.95
Personnel - Total $89,411.95
843 HEALTH - ENVIRONMENTAL 37002 Environmental $756.93
84200 EH - Projects 64 446.34
Health-Environmental - Total
480 PROBATE-EST/MENTAL HEALTH ADM 92197 Prob-Est/Ment Hlth Adm-Dev $22.26
95200 Prob-Est/Ment Hlth Admin 2 464 00 _,...._:___
Prob-Est/Mnthl Hlth Admin - Total $2,486.26
Prepared by: Linda Munk, Info Tech; 1/25/2001; 12:41 PM 2 1 fy2001.xlw
$7,605.62
$7,605.62
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - FIRST QUARTER, F.Y. 2001
Cust # GOVERNMENTAL FUNDS
512 PROBATE-EST/MENTAL HEALTH IMAGE 95207 Prob-Est/Mntl Hlth Image
Prob-Est/Mntl Hlth Image - Total
$12,455.94
$12,455.94
510 PROBATE-ESTIMENTAL HEALTH SUPPO 92198 Prob-Est/Mentl Hlth Supt - Dev
Probate Est / Mental Health Support - Total
481 PROBATE-FD-JUDICIAL
479 PROBATE-FD JUDICIAL SUPPORT
145 PROSECUTOR
690 PURCHASING
650 REIMBURSEMENT
195 SHERIFF
445 SUPPORT SERVICES
600 TREASURER
540 52/1 DISTRICT COURT - NOVI
550 52/2 DISTRICT COURT - CLARKSTON
560 52/3 DISTRICT COURT - ROCHESTER
530 52/4 DISTRICT COURT - TROY
95168 Prob-FD Judicial
Probate -FD Judicial - Total
95188 Prob-FD Judicial Support
Probate Judicial Support - Total
95622 Pros\ Executive
Prosecutor - Total
44026 Pur-System /Customer Support
Purchasing - Total
95470 Reimbursement System
95542 Reimburse User Support
Reimbursement - Total
97163 Sheriff
Sheriff - Total
44500 Support Services User Support
Support Services - Total
Tre-Data Warehousing
Tre-System/Customer Support
Tre-System Maintenance
Del Tax System Maintenance
DTX-Enhance/Development
User Support/Del Tax
Treasurer - Total
95527 DC Suprt -25%-52/1
52/1 District Court - Total
95528 DC Suprt -25%-52/2
52/2 District Court - Total
95529 DC Suprt -25%-52/3
52/3 District Court - Total
95530 DC Suprt -25%-52/4
$4,490.10
$522.07
$18,524.83
$534.30
$1,918.80
9,941.20
$77,540.02
$30,719.05
$714.42
3,297.32
3,325.35
17,812.29
(10,716.70)
54,021.89
$11,716.73
$11,716.73
;11,716.73
$11,716.73
44012
44061
44062
95303
95313
95561
$4,490.10
$522.07
$18,524.83
$534.30
$11,860.00
$77,540.02
$30,719.05
$68,454.57
$11,716.73
$11,716.73
$11,716.73
Prepared by: Linda Munk, Info Tech; 1/25/2001; 12:41 PM 3 1fy2001.xlw
$10,490.98
$54.95
$89.05
$6,937.08
163,173.89
$5,759.86
$25,606.56
$6,100.01
$42,273.02
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER, F.Y. 2001
Cust # DIRECT FUNDS
657 COMMUNITY CORRECTIONS 65701 Community Corrections Grant $10,490.98
Community Corrections - Total
661 COMMUNITY AND HOME IMPROVEMENT 66103 Comm & Home Improvement User Suppor $54.95
Comm and Home Improvement - Total
750 FAC MAINT & OPERATIONS 75503 FM0 Development $89.05
FM&O - Total
380 HEALTH IMMUNIZATION - GRANT 38000 Health - Immunization $2,137.22
38100 Health - Regional Immunization 4,799.86
Health - Immunization - Total
010 INFORMATION TECHNOLOGY
Digital Information Service Center 25100 GIS - Administration 19,608.37
30001 IT Disc Data Warehouse 168,940.35
30002 IT DISC Enhanced Access 7,582.77
30003 IT DISC GIS 76,562.12
$272,693.61
Systems Develop/Support 25200 Open Systems Administration 5,330.65
25400 Oracle Administration 290,865.50
91516 CVT - New Development 144,617.39
95456 Equipment Inventory 4,719.67
Technical Sys/Networking 95689 Database Tech Support $19,675.19
870 MEDICAL CARE FACILITY 98873 MCF - Support $16,127.36
Medical Care Facility - Total
004 PA189 PROJECTS 90603 PA189 JIMS Circ Ct - 25% 40,793.48
90604 PA189 JIMS Probate - 25% 40,793.48
90605 PA189 JIMS Prosecutor - 25% 40,793.48
90606 PA189 JIMS 52/1 DC - .0625% 10,198.36
90607 PA189 JIMS 52/2 DC - .0625% 10,198.36
90608 PA189 JIMS 52/3 DC - .0625% 10,198.36
90609 PA189 JIMS 52/4 DC - .0625% 10,198.37
PA189 Projects - Total
- 770 PARKS & REC ADMINISTRATION 95419 PRADM-Administration $5,759.86
Parks & Rec Admin - Total
602 TREASURER-100% TAX PAYMENT FUND 95310 Del Tax Act 123 Project $25,606.56
Treasurer 100% Tax Pymt Fund - Total
656 WATER & SEWER ACCOUNTING 95669 Water & Sewer Acctg $6,100.01
Water & Sewer Acctg - Total
NON-COUNTY AGENCIES
$445,533.21
$19,675.19
$16,127.36
Prepared by: Linda Munk, Info Tech; 1/25/2001; 12:44 PM 4 1fy2001.xlw
Resolution #01032. February 22, 2001
The Chairperson referred the resolution to the Finance Committee. There
were no objections.
FISCAL NOTE (MISC. #01032) March 8, 2001
BY: FINANCE COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FIRST QUARTER 2001 DEVELOPMENT
APPROPRIATION TRANSFER
To the Oakland County Board of Commissioners
Chairperson, Ladies and Gentlemen:
Pursuant to Rule XII-C of this Board, the General Government Committee has
reviewed the above-reference resolution and finds:
1. The resolution authorizes appropriation and charge of Information
Technology First Quarter 2001 Development cost to benefiting
departments.
2. The first quarter data processing development charges are
$1,168,851; imaging development charges are $44,564 for General
Fund/General Purpose departments; direct charges to Special Revenue
and Proprietary fund departments are $234,340; and charges to non-
county agencies are $42,273.
3. The respective departmental fiscal year 2001 budgets should be
amended as specified in the attached detail report.
FINANCE COMMITTEE
FINANCE COMMITTF,F,
Motion carried unanimously on a roll call vote with Palmer, Taub, Amos and
Dingeldey absent.
Resolution #01032 March 8, 2001
Moved by Obrecht supported by Crawford the resolutions on the Consent
Agenda be adopted (with accompanying reports being accepted).
AYES: Appel, Brian, Causey-Mitchell, Coleman, Crawford, Dingeldey,
Douglas, Galloway, Garfield, Gregory, Law, McPherson, Melton, Millard, Moffitt,
Moss, Obrecht, Palmer, Patterson, Sever, Suarez, Taub, Webster, Amos. (24)
NAYS: None. (0)
A sufficient majority having voted therefor, the resolutions on the
Consent Agenda were adopted, with the accompanying reports being accepted.
I HE
;1r _y4.2.2.3
Brooks P orlon, County Executive Date
FOREGOING RESOLUTI,
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 March 8, 2001 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 8tIlooday ojeMarch, 2001.
%dk261.J41A!elgitedd
G.'William Caddell, County Clerk