HomeMy WebLinkAboutResolutions - 2006.03.22 - 28189March 9, 2006
MISCELLANEOUS RESOLUTION 106040
BY: GENERAL GOVERNMENT COMMITTEE, WILLIAM PATTERSON, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FIRST QUARTER 2006
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 2006 data processing development charges to be
$1,398,805.89 and the imaging development charge to be $74,054.18 for
the General Fund/General Purpose County departments; and
WHEREAS direct charges to Special Revenue and Proprietary fund
departments are $506,976.99 and non-county agencies are $2,215.00 for
the First Quarter 2006; 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 2006 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 unanimous roll call vote with Long, Crawford and
Coulter absent
Y.T.D.
4th Qtr
July • Sent
3rd Qtr
Aor -June
GOVERNMENTAL FUNDS
General Fund moil
10100-3020201-121020-773630
10100-3020205-113290-773630
10100-3020301-121020-773630
10100-3020305-113290-773630
10100-3020401-121020-773630
10100-3020405-113290-773630
10100-3020501-121020-773630
10100-3020505-113290-773630
10100-1070801-114000-773630
10100-1010201-181010-773630
10100-5010101-180010-773630
10100-2010201-180000-773630
10100-2010301-185010-773630
10100-2010501-125000-773630
10100-2010210-125000-773630
10100-2010401-172190-773630
10100-2010205-132300-773630
10100-1090101-171000-773630
10100-1070401-113000-773630
10100-1010501-181020-773630
10100-3010201-121110-773630
10100-3010401-121240-773630
10100-3010403-121230-773630
10100-3010402-121100-773630
10100-3010402-135080-773630
10100-3010401-121220-773630
10100-3010403-121100-773630
10100-3010301-121140-773630
10100-3010301-121220-773630
10100-3010301-121110-773630
10100-3010301-121130-773630
10100-3010301-121150-773630
10100-3010101-121100-773630
10100-1010101-181000-773630
10100-6010101-155010-773630
10100-1010115-115090-773630
10100-1020501-173010-773630
10100-1040101-140000-773630
10100-1020601-182020-773630
10100-1050401-183010-773630
10100-1030850-184030-773630
10100-1070601-132030-773630
10100-1070501-174000-773630
10100-1090201-171000-773630
10100-3040101-121080-773630
10100-3040403-124010-773630
10100-3040101-121060-773630
10100-3040101-121070-773630
10100-4010101-122050-773630
10100-1020401-182090-773630
10100-1030803-184020-773630
10100-1020701-126020-773630
10100-4030301-112590-773630
10100-4030601-110000-773630
10100-1030803-184030-773630
10100-7010101-186040-773630
540 101
541 101
550 101
551 101
560 101
561 101
530 101
531 101
630 101
620 101
005 101
725 101
440 101
410 101
724 101
720 101
723 101
785 101
522 101
430 101
495 101
474 101
484 101
487 101
492 101
506 101
483 101
499 101
420 101
496 101
498 101
500 101
493 101
015 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
Health Fund 1221I
840 221 20221-1060201-133150-773630
843 221 20221-1060220-134390-773630
Juvenile Maintenance Fund 12931
665 293 20293-1060501-112090-773630
63600-1080101-152000-631365
IMAGING
722 10100-2010210-125000-773639
512 10100-3040403-124010-773639
63600-1080101-152000-630903
ACCOUNT #
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
1ST QUARTER 2006
' 1st Qtr
DIVISION pot - Dec
2nd Qti'
Jan - Mar
10100-9090101-196030-773630
SUB-TOTAL GOVERNMENTAL! IMAGING DEVELOPMENT APPROPRIATION:
52/1 - District Court
52/1 District Court - Probation
5212 - District Court
5212 - District Court - Probation
52/3 - District Court
52/3 - District Court - Probation
52/4 - District Court
52/4 - District Court - Probation
Animal Control
Auditing
Board of Commissioners
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-Judicial Support
Courts-FD-Judicial Support-Admin
Courts-GJ-Assignment
Courts-GJ-Family Support
Courts-GJ-JIMS
Courts-GJ-Judicial Support
Courts-GJ-Mediation
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 Retention
Reimbursement Division
Sheriff
Sheriff - CLEMIS
Support Services
Treasurer
Sub-Total Fund 101
Health
Health Environmental
Sub-Total Fund 221
Children's Village
Sub-Total Fund 293
DATA PROCESSING DEVELOPMENT FOR
GOVERNMENTAL FUND APPROPRIATION
Clerk Image
Probate-Estates/Mental Health Image
TOTAL IMAGING DEVELOPMENT
APPROPRIATION
Information Technology Development
TOTAL GOVERNMENT:
$10,756.64
$4,208.75
$10,756.64
$4,208.75
$10,756.64
$4,208.75
$10,756.58
$4,208.75
$76,017.00
$366.00
$6,679.50
$0.00
$4,468.00
$7,383.93
$24,014.00
$3,506.20
$2,290.00
$3,641.50
$31,340.93
$1,732.00
$2,567.03
$0.00
$0.00
$0.00
$7,529.00
$7,814.00
$4,367.31
$2,391.00
$6,744.00
$324.00
$20,026.50
$6,890.00
$32,330.25
$0.00
$59,585.00
$2,897.50
$100,586.44
$0.00
$138,552.29
. $55,378.62
$0.00
$77,160.11
$0.00
$108.00
$461.07
$3,388.28
$190.00
$0.00
$23,397.17
$4,212.00
$9,696.00
$11,691.00
$76,052.96
$27,343.41
$7,725.93
$88,541.83
$999,251.26
$51,628.20
$343.181.43
$394,809.63
$4.745 00
$4,745.00
$1.398.805.89
$71,973.18
$2 081.00
$74.054.18
$1,472,860.07
151.472,860.07)
19-Q2
$0.00 $0.00 $0.00
$0.00 $0.00 $0.00
$0.00 $0.00 $0.00
10-Q11 JUN IDAQ
1.11,22 111111 1.140
$0.00 $0.00 $0.00
$0.00 12.124 KZ)
111_,Q11 1.112.Q 1142
$10,756.64
$4,208.75
$10,756.64
$4,208.75
$10,756.64
$4,208.75
$10,756.58
$4,208.75
$76,017.00
$366.00
$6,679.50
$0.00
$4,468.00
$7,383.93
$24,014.00
$3,506.20
$2,290.00
$3,641.50
$31,340.93
$1,732.00
$2,567.03
$0.00
$0.00
$0.00
$7,529.00
$7,814.00
$4,367.31
$2,391.00
$6,744.00
$324.00
$20,026.50
$6,890.00
$32,330.25
$0.00
$59,585.00
$2,897.50
$100,586.44
$0.00
$138,552.29
$55,378.62
$0.00
$77,160.11
$0.00
$108.00
$461.07
$3,388.28
$190.00
$0.00
$23,397.17
$4,212.00
$9,696.00
$11,691.00
$76,052.96
$27,343.41
$7,725.93
$88.541,83
$999,251.26
$51,628.20
$343.181.43
$394,809.63
201 745.0Q
$4,745.00
31.398.805.8Q
$71,973.18
$2.081.00
$74,054.18
$1,472,860.07
M.472.860.071
11114
Prepared by; Information Technology; 1/20/2006 1st IX 2006.xls
1st QV 2nd Qtr
Oct - DeQ Jan - Mar DIVISION ACCOUNT #
3rd Otr
Aor - June
4th Otr
July - Seot
sug
1.12.4
$0.00 1.0-Q2
$0.00
}QM
1/42
114.111
$0.00
6506.976.99
TOTAL COUNTY DEVELOPMENT CHARGES 61.979,837.06
$2.215.00
SUB-TOTAL DIRECT CHARGES FOR DATA
PROCESSING DEVELOPMENT
Non-County Agencies
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
1ST,QUARTER 2006
055
056
096
719
521
661
471
470
507
210
757
758
750
759
655
380
751
662
870
248
651
653
770
790
695
602
656
850
$0.00
NON-GOVERNMENTAL
DIRECT CHARGES
63600-1080101-152000-631302
NON-COUNTY AGENCIES
63600-1080101-152000435017
CLEWS
CLEWS FUND 63500
CLEWS 2004 IBIS Grant
Clerk/ROD Automation Fund
Community Corrections (Grant)
Community & Home Improvement
Courts-FOC Exp-CS Enforcement Image
Courts-FOC Exp-Family Counseling
Courts-FOC Exp-CS Enforcement Image
Fire Records Management System
FM-Wk Rel/Jail MgtNideo Conf
FM-Jail Mgmt Replacement
FM&O
F M & 0-Safely Overhead
Gararge
Health - Immunization Grant
IT - Telephone Communications
Major Department Support Project Fund
Medical Care Facility
Medical Care Facility - Pharmacy
O.C. International Airport-GRE Grant
O.C. International Airport
Parks and Recreation - Administration
Radio Communications
Risk Management
Treasurer -100% Tax Paymt Fund
Water & Sewer Accounting
Workforce Development
$43,570.81
$0.00
$732.00
$21,630.00
$0.00
$0.00
$6,622.50
$0.00
$976.00
$4,985.61
$28,079.93
$488.00
$1,878.00
$0.00
$24,014.00
$2,566.00
$0.00
$359,632.10
$7,538.61
$0.00
$0.00
$683.00
$0.00
$0.00
$0.00
($1,485.50)
$5,065.93
$0.00
61,982,052.06
$43,570.81
$0.00
$732.00
$21,630.00
$0.00
$0.00
$6,622.50
$0.00
$976.00
$4,985.61
$28,079.93
$488.00
$1,878.00
$0.00
$24,014.00
$2,566.00
$0.00
$359,632.10
$7,538.61
$0.00
$0.00
$683.00
$0.00
$0.00
$0.00
($1,485.50)
$5,065.93
$0.00
6506.976.99
S1.979.837.06
$2.215.0Q
61,982,052.06 TOTAL DEVELOPMENT CHARGES
Prepared by; Information Technology; 1/2012006 1st Qtr 2006.xls
$6.679.50
$6,679.50
Cust# GOVERNMENTAL FUNDS
005 BOARD OF COMMISSIONERS 91404 BOC-Cust Supt
BOC - Total
630 ANIMAL CONTROL
620 AUDITING
665 CHILDRENS VILLAGE
725 CLERK - ADMIN
440 CLERK - ELECTIONS
720 CLERK! REGISTER OF DEEDS
$366.00
$4.745.00
$0-00
$4.468.00
23007
13001
65420
95158
23008
95512
$4,211.93
3.172.00
$24.014.00
$2.290.00
$7,383.93
$24,014.00
$2,290.00
$4,211.93
25,374.00
1.755.00
$31,340.93
$518.50
3,123.00
0.00
$3,641.50
$1.732.00
$1,732.00
$2,105.96
461.07
$2,567.03
$0.00
$7,529.00
$0.00
$7.529.00
INFORMATION TECHNOLOGY - RESERVE FUNI
DEVELOPMENT! SUPPORT DETAIL - FIRST QUARTER, 200
Web License Registration
Dog System
Animal Control-Total
44032 Auditing-System Maintenance
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
36511 ROD Application - H/W Support
95493 Reg Deeds System Maintenance
95162 Clerk - DW Support
95558 User Support/ROD
95564 ROD - OW Support
Clerk/Reg of Deeds - Total
$40,317.00
35,700.00
$76,017.00
$366.00
$4,745.00
$0.00
$4,468.00
$683.20
1,204.00
488.00
0.00
915.00
0.00
216.00
$3,506.20
95628
95682
722 CLERK - IMAGING Oracle Support - Clerk Image
Clerk - eFiling - 50%
Clerk - Image Replace
Clerk - Imaging
Clerk - Imaging - Total
$4,211.93
32,330.25
18,765.00
16.666.00
$71,973.18
410 CLERK - JURY COMMISSION
724 CLERK - LEGAL RECORDS
723 CLERK - VITAL STATISTICS
522 COMMUNITY CORRECTIONS-ADMIN (C01
785 COMMUNITY & ECO DEVELOPMENT
430 CORPORATION COUNSEL
495 CTS-BUSINESS DIV - JIMS
487 CTS-FD-CT SERV-ADMIN
492 CTS-FD-CT SERV-ADOPTIONS
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
36501 CED Application - H/W Support
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
23003
52200
52201
Prepared by Information Technology; 1)20/2006 1st Ott 2006.xls
$0.00
$7,814.00
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - FIRST QUARTER, 200E
505 CTS-FD-JUDICIAL 95186 CTS-FD/ADMIN-Family Judges $0.00
CTS-FD-Judicial - Total
506 CTS-FD-JUDICIAL SUPPORT 95187 CTS-FD/Admin - Fam Suppt Staff $7,814.00
CTS-FD-Judicial Suport - Total
483 CTS-FD-JUDICIAL SUPPORT-ADM 24009 SQL Serv Supp - CTS-Jud Sup Adm $2,002.31
95193 CTS-FD-Judicial Suport-Adm 2.365.00
CTS-FD-Judicial Suport-Adm - Total
484 CTS-FD-JUVENILE REFEREES 95191 CTS-FD-Admin-Juvenile Referees $0.00
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 $2.391.00
CTS-GJ-Assignment - Total
420 CTS - GJ -FAMILY SUPPORT 95195 Cir Crt Admin $6.744.00
Courts - GJ - Family Support - Total
496 CTS - GJ - JIMS 95208 CTS - DW Maintenance $324.00
CTS - GJ - JIMS - Total
498 CTS-GEN JURIS-JUDICIAL SUPPT 95179 CTS -Gen Juris-Judicial Suppt $20,026.50
CTS -Gen Juris-Judicial Suppt - Total
500 CTS-GJ-MEDIATION 95181 CTS-GJ-Mediation $6.890.00
CTS-GJ-Mediation - Total
493 CTS-JUDICIAL ADMIN 95174 CTS-Judicial Admin $32.330.25
CTS-Judicial Admin - Total
730 DRAIN COMMISSIONER 28007 Drain Commissioner $864.00
28011 Drain Commissioner Application 30,780.00
36520 GIS Implementation Support Drain 24,204.00
36521 OCDC Application - H/W Support 3,737.00
95669 Water & Sewer Accounting 0.00
Drain Commissioner - Total
900 EMERGENCY RESPONSE & PREPAREDNESS 36545 GIS Implementation Support EMS $2,775.50
36546 ERP Application - H/W Support 122.00
98990 Emergency Response $0.00
ERP - Total
$4,367.31
$0.00
$0.00
$2,391.00
$6,744.00
$324.00
$20,026.50
$6,890.00
$32,330.25
$59,585.00
$2,897.50
740 EQUALIZATION 20001 IDMS Support-Equalization
23012 Oracle Support-Equalization
24005 SQL Server Supp-Equalization
31075 Equal - Development
36505 GIS Implementation Support Equalization
36506 Equal Application - H/W Support
95559 User Support/Equal
95562 Equalization - DW Support
95570 Equalization - DW Maintenance
95693 Equal-System Maintenance
95699 BS&A Master Appraisal Sup/Maint
Equalization - Total
$1,366.40
4,211.93
4,004.61
0.00
781.50
3,593.00
5,949.50
20,765.50
783.00
16,006.50
43.124.50
$100,586.44
755 FACILITIES MANAGEMENT 91500 FM - System Support $0.00
Facilities Mgmt - Total $0.00
Prepared by: Information Technology; 1/20/2006 1st Qtr 2006.xls
$8,423.86
12,259.72
1,613.80
777.01
30,647.00
24,021.00
366.00
0.00
0.00
213.50
0.00
40,153.60
20,076.80
$138,552.29
$683.20
32,190.00
9,293.00
9.462.00
$51,628.20
23005 Oracle Support - EH Projects $4,211.93
37002 Environmental 4,090.00
84200 EH - Projects 223,472.50
84300 Ehealth Program 111,407.00
Health-Environmental - Total
23014 Oracle Support-HR/Personnel $8,198.22
24007 SQL Server Suppport-HR/Personnel 1,613.80
44042 PER-Systems Maintenance 206.00
95556 Personnel User Supt 1,134.00
96002 Human Res-Personnel 40% 44226.60
Personnel - Total
$343,181.43
$55,378.62
95440 Materials Management $0.00
Materials Mgmt-Gen Fund - Total $0.00
24002 SQL Server Support - Medical Exam
87202 Medical Examiner - Customer Support
Medical Examiner - Total
95676 MSU Ext Equipment Maintenance
MSU Extension - Oakland - Total
95786 PEDS - DW Support
PEDS - Total
95207 Prob-Est/Mntl Hlth Image
Prob-EsVMntl Hlth Image - Total
90604 JIMS Probate 25%
95165 PC-Judicial Admin-Admin Serv
Prob-Judicial Admin - Total
24010 SQL Serv Supp-PCT-Est/Mental
92198 Prob-Est/Mntl Hlth Support
Prob-Est/Mntl Hlth Support - Total
95168 Prob-FD Judicial
Prob-FD Judicial - Total
95188 PROB-FD Judicial Support $0.00
PROB-FD Judicial Support - Total
$4,004.61
73.155.50
$0.00
$108.00
$2.081.00
$461.07
0.00
$2,002.28
1.386.00
$190.00
$77,160.11
$0.00
$108.00
$2,081.00
$461.07
$3,388.28
$190.00
$0.00
. INFORMATION TECHNOLOGY RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER, 200E
660 FISCAL SERVICES ADMIN 23001 Oracle Support - Fiscal Sen./
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
840 HEALTH DEPARTMENT
843 HEALTH - ENVIRONMENTAL
680 HUMAN RESOURCES
641 MATERIALS MGMT-GEN SUPPORT SERV
872 MEDICAL EXAMINER
710 MSU EXTENSION - OAKLAND
775 PLANNING & ECONOMIC DEVELOPMENT
512 pROB-ESTATES/MENTL HLTH IMAGE
509 PROB-JUDICIAL ADMIN
510 PROB-ESTATES/MENTL HLTH SUPPORT
481 PROBATE-FD JUDICIAL
479 PROB-FD-JUDICIAL SUPPORT
20002 IDMS Support - CHAMPS
36525 GIS Implementation Support Health
37025 CHAMPS - P.O.P.
96842 Health Admin
Health - Total
Prepared by: Information Technology; 1/20/2006 1st Qtr 2006.xls
145 PROSECUTOR - GENERAL PROSECUTION JIMS - Prosecutor 25%
Prosecutor/Executive
Prosecutor Data Proc
Prosecutor - Total
$461.07
17,806.10
5.130.00
$23,397.17
90605
95622
97001
540 52/1 DISTRICT COURT. NOW 90606
95527
JIMS - 52/1 DC - 6.25%
DC Suprt-25%-52/1
52/1 District Court - Total
$115.28
10.641,36
$10,756.64
' INFORMATION TECHNOLOGY - RESERVE FUNC •
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER, 200E
690 PURCHASING 44026 PUR-System/Customer Support
44027 PUR-System Maintenance
Purchasing - Total
$2,592.00
1.620.0Q
$4,212.00
637 RECORDS RETENTION 44052
44054
95636
Rec-System Maintenance
Rec-New Development
Mail Room
Rec-New Development - Total
$2,526.00
7,170.00
12,(11
$9,696.00
650 REIMBURSEMENT
195 SHERIFF
191 SHERIFF- CLEMIS
445 SUPPORT SERVICES
600 TREASURER
95470 Reimbursement System
95542 Reimburse User Support
Reimbursement Total
23009 Oracle Suppport - OCSD/CTS Crim Whse
97163 Sheriff
97164 Sheriff-Development
97165 Sheriff-DW Support
97166 Sheriff-DW Maintenance
Sheriff - Total
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
36515 GIS Implementation Support-Treasurer
36516 Treasurer Application - H/W Support
44061 Tre-System/Customer Support
44062 Tre-System Maintenance
44080 Tre-DW Support
44082 Tre-DW Maintenance
95008 Del Tax On Line
95303 Del Tax System Maintenance
95561 User Support/Del Tax
Treasurer - Total
$3,072.00
8.619.00
$11,691.00
$2,105.96
47,765.00
0.00
25,898.00
284.00
$76,052.96
$4,211.91
23.131.50
$27,343.41
$4,211.93
3.514.00
$7,725.93
$4,211.93
4,896.00
18,507.50
315.40
20,882.50
29,765.00
1,690.00
732.00
7,541.50
0.00
$88,541.83
541 52/1 DISTRICT COURT. NOVI - PROBATION
550 52/2 DISTRICT COURT - CLARKSTON
94542 DC Probation Support - 52/1 - 25%
52/1 District Court - Probation - Total
90607 JIMS - 52/2 DC - 6.25%
95528 DC Suprt-25%-52/2
52/2 District Court - Total
$4.208.75
$4,208.75
$115.28
10.641,36
$10,756.64
551 52/2 DISTRICT COURT- CLARKSTON - PROBAT 94552 DC Probation Support - 52/2 - 25%
52/2 District Court - Probation - Total
$4.208.75
$4,208.75
560 52/3 DISTRICT COURT- ROCHESTER 90608 JIMS - 52/3 DC - 6.25%
95529 DC Suprt-25%-52/3
5213 District Court - Total
$115.28
10.641.36
$10,756.64
Prepared by: Information Technology; 1120/2006 1st Qtr 2006.xls
$4.208.75
$4,208.75
INFORMATION TECHNOLOGY - RESERVE FUNC
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER, 200E
561 52/3 DISTRICT COURT - ROCHESTER - PROBAT 94562 DC Probation Support - 52/3 - 25%
52/3 District Court - Probation - Total
530 52/4 DISTRICT COURT - TROY
531 52/4 DISTRICT COURT - TROY - PROBATION
Cust # DIRECT FUNDS
90609 JIMS - 52/4 DC - 6.25%
95530 DC Suprt-25%-52/4
52/4 District Court - Total
94532 DC Probation Support - 52/4 - 25%
52/4 District Court - Probation - Total
$115.26
10.641.32
$10,756.58
$4208.75
$4,208.75
055 CLEMIS 20003 IDMS Support $683.20
24004 SQL Server Support 35,742.61
95409 CRISNET/CLEMIS LRM 0.00
95430 CLEMIS Maintenance 5,325.00
95431 CLEMIS Enhancements 1.820.00
CLEMIS - Total $43,570.81
056 CLEMIS FUND 63500 63500 CLEMIS Fund $0.00
CLEMIS Fund - Total $0.00
096 CLEMIS 2004 IBIS GRANT 63596 2004 Federal Approp - IBIS Project $732.00
CLEMIS 2004 IBIS Grant - Total $732.00
719 CLERK/ROD AUTOMATION FUND 95719 Register of Deeds Automation $21.630.00
Register of Deeds Automation - Total $21,630.00
471 CTS-FOC-EXP-CS ENFORC-IMAG 92194 CTS-FOC-Exp-CS Enf-Image $6,622.50
CTS-FOC Exp-CS Enf-Image - Total $6,622.50
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 $976.00
CTS-FOC Exp-CD Enforc-Dev - Total $976.00
210 FIRE RECORDS MANAGEMENT SYSTEM 21010 Fire Records Mgmt Fund 531 $981.00
24001 SQL Server Support - FRMS 4.004.61
Fire Records Mgmt - Total $4,985.61
750 FM8,0 21001 FM&O $244.00
75503 FM&O Development 1.634.00
FM&O - Total $1,878.00
757 FM-WK RELEASE/JAIL MGMTNIDEO CONF 23004 Oracle Support - Oak Video $4,211.93
75700 Fac Mgmt - Video Arraignments 23.868.00
FM-Wk Rel/Jail MgmtNideo Conf - Total $28,079.93
758 FM - JAIL MGMT REPLACEMENT 75800 FM - Jail Mgmt Replacement $488.00
FM - Jail Mgmt Replacement - Total $488.00
655 GARAG 44057 GAR - Systems Maintenance $12,245.00
44058 GAR - Systems Enhancements 11.769.00
Garage - Total $24,014.00
380 HEALTH IMMUNIZATION - GRANT 38000 Health - Immunization $2.566.00
Health - Immunization - Total $2,566.00
Prepared by. Information Technology; 1/20/2006 1st Qtr 2006.xls
INFORMATION TECHNOLOGY.- RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER, 200E
662 MAJOR DEPT SUPP PROJ FUND 66200 e-Financial-Peoplesoft Implementation $359.632.10
e-Financial-Peoplesoft Implem-Total $359,632.10
870 MEDICAL CARE FACILITY 24003 SQL Server Support - MCF $4,004.61
98873 MCF - Support 3.534.0Q
MCF - Support - Total $7,538.61
248 MEDICAL CARE FACILITY - PHARMACY 98248 MCF - Pharmacy $0.00
MCF - Pharmacy - Total $0.00
653 O.C. INTERNATIONAL AIRPORT 36540 GIS Implementation Support-Aviation $683.00
Airport User Support - Total $683.00
770 PARKS AND RECREATION 95419 PRADM-Administration $0.00
Parks & Recreation - Total $0.00
790 RADIO COMMUNICATION 79001 Radio Communications $0.0Q
Radio Communications - Total $0.00
695 RISK MANAGEMENT 44036 RSK-System/Customer Support $0.00
95695 Risk Management 0.00
Risk Management - Total $0.00
602 TREASURER-100% TAX PAYMT FUND 99002 Treasurers Office ($1485.50)
Treasurers Office - Total ($1,485.50)
656 WATER & SEWER ACCTG 23011 Oracle Supp - Water & Sewer Acct'g $4,211.93
95669 Water & Sewer Acct'g 854.00
Water & Sewer Acct'g - Total $5,065.93
850 WORKFORCE DEVELOPMENT 95670 Workforce Development $0.00
Workforce Development - Total $0.00
Prepared by: Information Technology; 1/2012006 1st Otr 2006.xls
FISCAL NOTE (MISC. #06040) March 23, 2006
BY: FINANCE COMMITTEE, CHUCK MOSS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FIRST QUARTER 2006
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 2006 Development cost to benefiting
departments.
2. The first quarter data processing development charges are
$1,398,805.89; imaging development charges are $74,054.18 for
General Fund/General Purpose departments; direct charges to
Special Revenue and Proprietary fund departments are
$506,976.99 and charges to non-county agencies are $2,215.00.
3. The respective departmental Fiscal Year 2006 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 #06040 March 9, 2006
The Chairperson referred the resolution to the Finance Committee. There were no objections.
,--
Ruth—J75h-ri§Orn, County Clerk
Resolution #06040 March 23, 2006
Moved by Scott supported by Gregory the resolutions (with fiscal notes attached) on the Consent Agenda
be adopted (with accompanying reports being accepted).
AYES: Coleman, Coulter, Crawford, Douglas, Gregory, Hatchett, Jamian, 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 in favor, the resolutions (with fiscal notes attached) on the Consent
Agenda (with accompanying reports being accepted) were adopted.
I HEREBY APPROVE THE FORBIN RESOLUION
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 23, 2006,
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 23rd day of March, 2006.