HomeMy WebLinkAboutResolutions - 2002.03.13 - 26842MISCELLANEOUS RESOLUTION #02022 February 21, 2002
BY: General Government Committee, William R. Patterson, Chairperson
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FIRST 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
First Quarter 2002 data processing development charges to be $1,075,090
and the imaging development charge to be $65,729 for the General
Fund/General Purpose County departments; and
WHEREAS direct charges to Special Revenue and Proprietary fund
departments are $347,265.81 and non-county agencies is $0 for the First
Quarter 2002; 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 2002 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
r
GENERAL GOVERNMENT COMMITTEE
Motion carried unanimously on a roll call vote with Webster and McPherson
absent.
ACCOUNT # DIVISION
1st Qtr
Oct - Dec
2nd Qtr
Jan - Mar
3rd Qtr
Apr - June
4th Qtr
July - Sept Y.T.D.
SUB-TOTAL GOVERNMENTAL ! IMAGING DEVELOPMENT APPROPRIATION: $1,140,819.00
Information Technology Development (51,140,819.00)
TOTAL GOVERNMENT: $0.00
* 1st Quarter invoiced in January 2002
Prepared by: Linda Munk, Info Tech; 1/28/2002; 4:23 PM
90-290000-25000-6030
INFORMATtON TECI1NOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY '
1ST QUARTER 2002
GOVERNMENTAL FUNDS
General Fund 0 011
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-21-230100-01000-6030
2-21-250100-01000-6030
2-21-221000-01000-6030
2-21-240100-11000-6030
2-21-220500-01000-6030
2-1 9-21 0000-10000-6030
2-35-220000-12000-6030
2-35-242000-11000-6030
2-35-242000-44000-6030
2-35-242000-41000-6030
2-35-243000-11000-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-12-240000-44100-6030
2-12-601200-10001-6030
2-12-621200-10001-6030
2-17-912000-15000-6030
2-15-402200-10001-6030
2-19-221000-10000-6030
2-34-403200-40005-6030
2-34-101200-31100-6030
2-34-101200-31200-6030
2-41-211000-10000-6030
2-12-401200-40010-6030
2-12-701200-10001-6030
2-43-023301-20000-6030
2-1 3-1 38201-00010-6030
2-22-221120-01000-6030
Health Fund 12211
2-16-201200-33100-6030
2-16-220200-67000-6030
18-636111-10000-0735
IMAGING
2-21-221000-01000-6039
2-35-243000-33000-6039
2-34-403200-40005-6039
18-636111-10000-0573
52/1 - District Court *
5212 - District Court *
52/3 - District Court *
52/4 - District Court *
Animal Control
Clerk - Elections
Clerk - Jury Commission
Clerk - Legal Records
Clerk - Register of Deeds
Clerk - Vital Statistics
Community & Economic Development
Courts-Business Division - JIMS
Courts-FD-Court Services-Admin
Courts-FD-Court Services-Adoptions
Courts-FD-Court Services-Casework
Courts-FD-Judicial Support-Admin
Courts-GJ-Judicial Support
Courts-GJ-Assignment
Courts-GJ-Family Support
Courts-GJ-Mediation
Courts-Judicial Administration *
Drain Commissioner
Equalization Division *
Fiscal Services - Admin *
Fiscal Services - General *
Medical Examiner
Personnel *
Planning and Economic Development *
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
Health
Health Environmental
Sub-Total Fund 221
DATA PROCESSING DEVELOPMENT FOR
GOVERNMENTAL FUND APPROPRIATION
Clerk Image
Courts-FD-Juv-Sup-Imaging
Probate-Estates/Mental Health Image
TOTAL IMAGING DEVELOPMENT
APPROPRIATION
$10,213.10
10,213.10
10,213.10
10,213.10
1,080.00
3,816.00
7,572.50
7,180.00
8,588.00
6,213.00
1,134.00
183.00
1,028.00
6,545.00
108.00
1,202.00
13,661.40
2,831.50
8,577.50
392.00
4,630.00
3,106.00
271,409.50
123,862.30
22,483.90
19,664.60
71,880.80
12,256.50
2,157.00
3,321.00
1,098.00
23,242.00
5,597.00
25,749.50
74,754.50
1,563.00
69,346.00
$847,085.90
20,358.80
204,027.30
$224,386.10
3,618.00
$3,618.00
$1,075,090.00
50,495.00
108.00
15,126.00
$65,729.00
$10,213.10
10,213.10
10,213.10
10,213.10
1,080.00
3,816.00
7,572.50
7,180.00
8,588.00
6,213.00
1,134.00
183.00
1,028.00
6,545.00
108.00
1,202.00
13,661.40
2,831.50
8,577.50
392.00
4,630.00
3,106.00
271,409.50
123,862.30
22,483.90
19,664.60
71,880.80
12,256.50
2,157.00
3,321.00
1,098.00
23,242.00
5,597.00
25,749.50
74,754.50
1,563.00
69,346.00
$847,085.90
20,358.80
204,027.30
$224,386.10
3,618.00
$3,618.00
$1,075,090.00
50,495.00
108.00
15 126.00
$65,729.00
$1,140,819.00
($1,140,819.00)
0.00
1st qtr 2002.xls
Juvenile Maintenance Fund 12931
2-16-501200-25001-6030 Children's Village
Sub-Total Fund 293
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
1ST QUARTER 2002
1st Qtr 2nd Qtr 3rd Qtr 4th Qtr
ACCOUNT # DIVISION Oct-Dec Jan-Mar Apr-June July-Sept Y.T.D.
NON-GOVERNMENTAL
DIRECT CHARGES CLEMIS *
Community Corrections
Courts-FOC-Exp-CS Enforcement
Courts-FOC Exp-CS Enforcement Image
Courts-FOC Exp-Family Counseling
Health Immunization
Materials Management
Medical Care Facility
PA189 Projects *
Parks and Recreation - Administration
Risk Management
Treasurer - 100% Tax Payment Fund
Water & Sewer Accounting
91,466.25
446.00
277.00
6,154.00
4,220.00
1,198.80
2,228.00
2,322.80
218,841.96
244.00
1,446.00
12,778.00
5,643.00
91,466.25
446.00
277.00
6,154.00
4,220.00
1,198.80
2,228.00
2,322.80
218,841.96
244.00
1,446.00
12,778.00
5,643.00
18-636111-10000-0715 SUB-TOTAL DIRECT CHARGES FOR DATA $347,265.81 $347,265.81
PROCESSING DEVELOPMENT
TOTAL COUNTY DEVELOPMENT CHARGES $1,488,084.81 $1,488,084.81
NON-COUNTY AGENCIES
18-636111-10000-0429 Non-County Agencies $0.00 $0.00
TOTAL DEVELOPMENT CHARGES $1,488,084.81 $1,488,084.81
1st Quarter invoiced in January 2002
Prepared by: Linda Munk, Info Tech; 1/28/2002; 4:24 PM 1st qtr 2002.xls
INFORMATION'TECHNOLOGY - RESERVE FUND •
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER, 2002
Gust # GOVERNMENTAL FUNDS
630 ANIMAL CONTROL DIVISION 95682 Dog System $1,080.00
Animal Control Division - Total $1,080.00
665 CHILDRENS VILLAGE 95665 Childrens Village $3,618.00
Childrens Village - Total $3,618.00
440 CLERK - ELECTIONS 95443 Elections $3,816.00
Clerk -Elections - Total $3,816.00
720 CLERK! REGISTER OF DEEDS 95493 Reg Deeds System Maintenance $3,517.00
95558 User Support/ROD 5,071.00
Clerk/Reg of Deeds - Total $8,588.00
722 CLERK - IMAGING 65420 Clerk - Image Replace - 21% $5,330.00
95158 Clerk - Imaging 45,165.00
Clerk - Imaging - Total $50,495.00
410 CLERK - JURY COMMISSION 95512 Jury Commission $7,572.50
Clerk -Jury Commission - Total $7,572.50
724 CLERK - LEGAL RECORDS 95170 Legal Division $3,510.00
95189 Circuit Court System 3,670.00
Clerk - Legal Records - Total $7,180.00
723 CLERK-VITAL STATISTICS 95161 Vital Stats Index $6,213.00
Clerk - Vital Statistics - Total $6,213.00
785 COMMUNITY & ECO DEVELOPMENT 95785 Comm & Eco Developmt $1,134.00
Community & Eco Dev - Total $1,134.00
495 CTS-BUSINESS DIV - JIMS 95176 CTS-Business Div - JIMS $183.00
CTS-Business Div - JIMS - Total $183.00
487 CTS-FD-COURT SERVICES-ADMIN 95196 CTS-FD-Ct Serv-Admin $1,028.00
CTS-FD-Ct Serv-Admin - Total $1,028.00
492 CTS-FD-CT SERV-ADOPTIONS 95173 CTS-FD-Ct Serv-Adoptions $6,545.00
CTS-FD-Ct Serv-Adoptions - Total $6,545.00
489 CTS-FD-CT SERV-CASEWORK 95197 CTS-FD-Ct Serv-Casework $108.00
CTS-FD-Ct Serv-Casework - Total $108.00
483 CTS-FD-JUDICIAL SUPPORT-ADM 95193 CTS-FD-Judicial Suport-Adm $1,202.00
CTS-FD-Judicial Suport-Adm - Total $1,202.00
488 CTS-FD-JUV SUPP-IMAGING 48201 CTS-FD-Juv Supp-Imaging $108.00
CTS-FD-Juv Supp-lmaging - Total $108.00
499 CTS-GJ-ASSIGNMENT 95180 CTS-GJ-Assignment $2,831.50
CTS-GJ-Assignment - Total $2,831.50
420 CTS - GJ - FAMILY SUPPORT 95195 Cir Crt Admin 8,577.50
Courts - GJ - Family Support - Total $8,577.50
498 CTS-GEN JURIS-JUDICIAL SUPPT 95179 CTS -Gen Juris-Judicial Suppt $13,661.40
CTS -Gen Juris-Judicial Suppt - Total $13,661.40
500 CTS-GJ-MEDIATION 95181 CTS-GJ-Mediation $392.00
CTS-GJ-Mediation - Total $392.00
493 CTS-JUDICIAL ADMIN 95174 CTS-Judicial Admin $4,630.00
CTS-Judicial Admin - Total $4,630.00
Prepared by: Linda Munk, Info Tech; 1/28/2002;
1 1st qtr 2002.xls
31075
31078
95559
95693
44021
44022
44023
44024
96001
37025
95563
96842
37002
84200
84300
$3,106.00
$3,106.00
$2,916.00
76,750.00
53,994.50
137,749.00
$271,409.50
$25,344.00
29,468.00
5,666.00
19,496.50
43,887.80
$123,862.30
$540.00
21,943.90
$22,483.90
$9,606.60
894.00
9,858.20
$20,358.80
$799.20
16,668.80
186,559.30
$19,664.60
$13,533.00
14,460.00
43,887.80
$12,256.50
$15,126.00
$2,157.00
$1,098.00
$3,321.00
$1,512.00
21,101.00
629.00
$204,027.30
$19,664.60
$71,880.80
$12,256.50
$15,126.00
$2,157.00
$1,098.00
$3,321.00
$23,242.00
• INFORMATION TECHNOLOGY - RESERVE .FUND •
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER, 2002
Gust # GOVERNMENTAL FUNDS
730 DRAIN COMMISSIONER
740 EQUALIZATION
660 FISCAL SERVICES ADMIN
670 FISCAL SERVICES - GENERAL
840 HEALTH DEPARTMENT
843 HEALTH - ENVIRONMENTAL
872 MEDICAL EXAMINER
680 PERSONNEL
512 PROB-ESTATES/MENTL HLTH IMAGE
510 PROB-ESTATES/MENTL HLTH SUPPORT
479 PROB-FD JUDICIAL SUPPORT
481 PROBATE-FD JUDICIAL
145 PROSECUTOR
28009 Drain - Administration
Drain Commissioner - Total
Equal - Development
EPP-Development
User Support/Equal
Equal-System Maintenance
Equalization - Total
FS-System/Customer Support
FS-System Maintenance
FS-System Enhancements
FS-New Development
Human Res-Acct
Fiscal Services Admin - Total
44076 BUD-System/Customer Support
96003 Human Res-Budget
Fiscal Services - General - Total
CHAMPS - P.O.P.
User Support / Health
Health - Admin
Health - Total
Environmental
EH - Projects
Ehealth Program
Health-Environmental - Total
87202 Med Exam - Cust Support
Medical Examiner - Total
PER-New Development
Personnel User Supt
Human Res-Personnel
Personnel - Total
Plan'g & Econ Dev-Data Warehouse
Planning & Eco Development - Total
95207 Prob-Est/Mntl Hlth Image
Prob-Est/Mntl Hlth Image - Total
92198 Prob-Est/Ment Hlth Support
Prob-Est/Ment Hlth Support - Total
95188 Prob-FD Judicial Sup
Prob-FD Judicial Sup - Total
95168 Prob-FD Judicial
Prob-FD Judicial - Total
95619 Prosecutor Enhancement Budget
95622 Prosecutor/Executive
97001 Prosecutor Data Proc
Prosecutor - Total
44044
95556
96002
775 PLANNING & ECONOMIC DEVELOPMENT 95608
Prepared by: Linda Munk, Info Tech; 1/28/2002;
2 1st qtr 2002.xls
95476
97163
97164
195 SHERIFF
' INFORMATION TECHNOLOGY - RESERVE FUND •
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER, 2002
Gust # GOVERNMENTAL FUNDS
690 PURCHASING
650 REIMBURSEMENT
44026 PUR-System/Customer Support
44028 PUR-System Enhancements
44029 PUR-New Development
Purchasing - Total
95470 Reimbursement System
95542 Reimburse User Support
Reimbursement - Total
$2,120.00
2,440.00
1 ,037.00
$5,597.00
$1,521.00
24,228.50
$25,749.50
Jail Management System
Sheriff
Sheriff - Development
Sheriff - Total
$183.00
73,881.50
690.00
$74,754.50
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
44500 Support Services
Support Services - Total
Tre-Data Warehousing
Ire-System/Customer Support
Tre-System Maintenance
Del Tax System Maintenance
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
52/3 District Court - Total
$1,563.00
$7,505.00
9,620.00
1,995.00
26,838.00
23,388.00
$10,213.10
$10,213.10
$10,213.10
$10,213.10
44012
44061
44062
95303
95561
$1,563.00
$69,346.00
$10,213.10
$10,213.10
$10,213.10
$10,213.10
Prepared by: Linda Munk, Info Tech: 1/28/2002;
3 1st qtr 2002.xls
• INFORMATION TECHNOLOGY - RESERVE -FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER, 2002
Gust # DIRECT FUNDS
055 CLEMIS 95432 CLMS Adhoc Reports $91,466.25
CLEMIS - Total $91,466.25
521 COMM CORR-ADM (GRANT) 65701 Community Corrections Grant $446.00
Community Corrections - Total $446.00
470 CTS-FOC EXP-FAM COUNSELING 92195 CTS-FOC Exp-Fam Couns-Dev $4,220.00
CTS-FOC Exp-Fam Couns-Dev - Total $4,220.00
507 CTS-FOC EXP-CS ENFORCEMENT 92193 CTS-FOC Exp-CD Enforc-Dev $277.00
CTS-FOC Exp-CD Enforc-Dev - Total $277.00
471 CTS-FOC-EXP-CS ENFORC-IMAGE 92194 CTS-FOC-Exp-CS Enf-Image $6,154.00
CTS-FOC Exp-CS Enf-lmage - Total $6,154.00
380 HEALTH IMMUNIZATION -GRANT 38000 Health - Immunization $1,198.80
Health - Immunization - Total $1,198.80
640 MATERIALS MANAGEMENT 95440 Materials Management $2,228.00
Materials Management - Total $2,228.00
870 MEDICAL CARE FACILITY 98873 MCF - Support $2,322.80
MCF - Support - Total $2,322.80
004 PA189 PROJECTS 90603 Circ Ct - JIMS Project - 25% $54,710.49
90604 Probate - JIMS Project - 25% 54,710.49
90605 Prosecutor - JIMS Project - 25% 54,710.49
90606 52/1 - JIMS Project - 6.25% 13,677.62
90607 52/2 - JIMS Project - 6.25% 13,677.62
90608 52/3 - JIMS Project - 6.25% 13,677.62
90609 52/4 - JIMS Project - 6.25% 13,677.63
$218,841.96
770 PARKS AND RECREATION 95419 PRADM-Administration $244.00
Parks & Recreation - Total $244.00
695 RISK MANAGEMENT 95695 Risk Management $1,446.00
Risk Management - Total $1,446.00
602 TREASURER-100% TAX PAYMENT FUND 95310 Del Tax Act 123 Project $12,778.00
Treasurer 100% Tax Pymt Fund - Total $12,778.00
656 WATER & SEWER ACCTG 95669 Water & Sewer Acct'g $5,643.00
Water & Sewer Acct'g - Total $5,643.00
NON-COUNTY AGENCIES $0.00
Prepared by: Linda Munk, Info Tech; 1/28/2002;
4 1st qtr 2002.xls
cQ
FISCAL NOTE (M.R. #02022) March 14, 2002
BY: FINANCE COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FIRST 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-reference resolution and finds:
1. The resolution appropriates and charges the Information Technology
First Quarter 2002 Development cost to benefiting departments.
2. The first quarter data processing development charges are
$1,075,090; imaging development charges are $65,729 for General
Fund/General Purpose departments; direct charges to Special Revenue
and Proprietary fund departments are $347,265.81; 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 deLail schedule.
FINANCE COMMITTEE
FINANCE COMMITTEE
Motion carried unanimously on a roll call vote with Palmer absent.
Resolution #02022 February 21, 2002
The Chairperson referred the resolution to the Finance Committee. There were no objections.
G. William Caddell, County Clerk
Resolution #02022 March 14, 2002
Moved by Palmer supported by Crawford the resolutions on the Consent Agenda be adopted with
accompanying reports being accepted.
AYES: Amos, Appel, Brian, Buckley, Causey-Mitchell, Coleman, Crawford, Dingeldey, Douglas,
Galloway, Garfield, Law, McPherson, Melton, Middleton, Moffitt, Moss, Obrecht, Palmer, Patterson, Sever,
Suarez, Taub, Webster. (24)
NAYS: None. (0)
A sufficient majority having voted therefore, the resolutions on the Consent Agenda were adopted with
accompanying reports being accepted.
....imosmaromoloronsommorm,
HERF.
L Patte
E FoRr(c.)ING REsou)-
Date
County Executkve_
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 14, 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 14th day of March, 2002.
