HomeMy WebLinkAboutResolutions - 2006.08.31 - 28079• MISCELLANEOUS RESOLUTION 106159 August 3, 2006
BY: GENERAL GOVERNMENT COMMITTEE, WILLIAM PATTERSON, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - THIRD 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 Third Quarter 2006 data processing development charges to be
$1,601,853.51 and the imaging development charge to be $69,564.03 for
the General Fund/General Purpose County departments; and
WHEREAS direct charges to Special Revenue and Proprietary fund
departments are $117,870.71 and non-county agencies are $732.00 for the
Third 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 Third Quarter 2006 Data Processing
Development Report and approves the Third 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
4,tikayn )2 ()6d 44.41-e-11
GENERAL GOVERNMENT COMMITTEE VOTE:
Motion carried on a roll call vote with Molnar and Coulter absent.
GOVERNMENTAL FUNDS
clogogy_dryll101.1
10100-3020201-121020-773630
10100-3020205-113290-773630
10100-3020301-121020-773630
10100-3020305-113290-773630
10100-3020401-121020-773630
10100-3020406-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-172160-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-773830
10100-3010402-121100-773630
10100-3010402-135080-773630
10100-3010401-121220-773630
10100-3010403.121100-773630
10100-3010301-121140-773630
10100-3010301-121160-773630
10100-3010301-121220-773630
10100-3010301-121110-773630
10100-3010301-121130-773630
10100-3010301-121150-773630
10100-3010101-121100-773830
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-5010303-165040-773630
10100-1030850-184030-773630
10100-1070601-132030-773830
10100-1070501-174000-773830
10100-1090201-171000-773630
10100-3040101-121080-773630
10100-3040403-124010-773830
10100-3040101-121060-773830
10100-3040101-121070-773630
10100-4010101-122050-7734330
10100-1020401-182090-773630
10100-1030803-184020-773530
10100-1020701-126020-773530
10100-4030301-112590-773630
10100-4030601-110009-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
622 101
430 101
495 101
474 101
464 101
467 101
402 101
506 101
483 101
489 101
501 101
420 101
498 101
498 101
500 101
493 101
015 101
730 101
900 101
740 101
755 101
660 101
680 101
907 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
SUB-TOTAL GOVERNMENTAL (IMAGING DEVELOPMENT APPROPRIATION: ;1,479,482.57 ,499,181.46 ,671.417.54
1$l,479,482,57) 151,499181.401 131.671,417 541
TOTAL GOVERNMENT: $0,00 $0.00 $0.00
1010040901014 98030-773830 Information Technology Development
INI-UHMA I ION I EGFINULUUY
DATA PROCESSING DEVELOPMENT SUMMARY
3RD QUARTER 2006
ACCOUNT #
• •
1st Qtr 2nd Off 3rd Qtr 401 Qtr
DIVISION Oct - Dec Jan - Mar July - Sept Y.T.D.
52/1 - Distnct Court
5211 • District Court - Probotio-,
52/2 - District Court
52/2 - 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 Deees
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-Adopt one
Gourts-FD-Judicial Support
Courts-FD-Judicial Support-Admin
Courts-CJ-Assignment
COURTS SJ-Crtminal Case Support
Courts-CJ-Family Support
Courts-General Jurisdiction
Courts-GJ-Judicial Support
Courts-GJ-Mediation
Courts - Judical / Administration
County Executive
Drain Commissioner
Emergency Response & Prep Unit
Equalization Division
FacHities Management
Fiscal Services - Admin
Human Resources
Library Admin
Materials Management - Gen Fund
Medical Examiner
MSU Extension - Oakland
Planning & Economic Development
Probate - Judicial Admtn
Probate-Estates/Mental Health Support
Probate-FD-Judicial
Probate-ED-Judicial Support
Prosecuting Attorney - General Prosecution
Purchasing
Records Retentior,
Reimbursement Division
Sheriff
Sheriff - CLEMIS
Support Services
Treasurer
Sub-Total Fund 101
$10,756.64 $5,045.63 $5,841.53 $24,643.80
$4,208.75 $1,185.88 $1,671.50 $7,065.13
$10,756.64 $8.045.63 $5,841.53 $24,643.80
$4,208.75 $1,185.88 $1,671.50 $7,066.13
$10.756.64 $8.045.63 $5.841.53 $24,643.80
$4,208.75 $1,185.88 $1,671.50 $7,066.11
$10.756.58 $8.045.61 $5,841.53 $24,643.72
$4208.75 $1,185.88 $1,671.50 $7,066.13
$76,017.00 $25,542.00 $25,946.00 $127,505.00
$366.00 $0.00 $244.00 $610.00
$6,679.50 $1,098.00 $2,379.00 $10,156.50
$0.00 $0.00 $6,941.00 $6,941.00
$4,468.00 $5,897.00 $18,270.00 $28,635.00
$7,383.93 $7,755.013 57.665.48 $22,804.49
$24,014.00 $35,451.00 $29.628.50 $90,093.50
$3,506.20 $5,755.20 $2,236.00 $11,497.40
$2,290.00 $3,977.60 $9.126.50 $15,394.00
$3.641.53 $2,806.00 $3,740.50 $10,188.00
$31,340.93 $68,499.58 578,35E48 $178,196.99
$1,732.00 $488.00 $1,403.00 $3,623.00
$2,567.03 $9,359.54 $927412 $21,200.69
$0.03 $0.00 $11,192.00 $11,192.00
$0.00 $0.00 $0.00 $0,00
$0.00 $0.00 $0.00 $0.00
$7.529.00 $0.00 $0.00 $7.529.00
$7,814.00 $3,024.00 $8,114.50 $18,952.50
$4,367.31 $5,104.16 $8,486.11 $17.959,58
$2,391.00 $805.00 $2,267.00 $E453.00
$0.00 $4,725.00 $1,690.00 $6,415.00
56,744.00 59,657.50 $9,218.00 $25,619,50
$324.00 $385,00 $162.00 $871.00
$20,026.50 $28,902.50 $45,589.00 $94.518.00
$6,890.00 $1,259.00 $5,929.50 514,078,50
$32,330.25 $22,453,55 $22,237.45 $77.021.25
$0.00 $0,00 $0.00 $0.00
$59,585.00 $91,503.00 $552,259.50 5203.347.50
$2,897.50 $1,830.00 $2,196.00 $6.923.50
$100,586.44 $86,140.81 $97,647.71 $2284,374.96
$0.00 $0,00 $0.03 $0.00
$138,552.29 $197,114.87 $301.408.52 $837,075.68
$55,378.62 $97,217.66 $99,736.32 $252.332.60
$0.00 $0.00 $1,647.00
$000 $0.00 $24,40 $24.40
$77.160.11 $80.035.33 $85,708.23 $242,903.67
$0.00 $0.00 $0.00 $00.00
$108.00 $0.00 $366.00 $474.00
$461.07 $7,622.50 $0.00 $8,083.57
$3,388.28 $3,697.17 $5.658.10 $12,743,55
$190.00 $526.00 $1.150.00 $1,868.00
$0,00 $0.00 $0.00 $0.00
$23.397.17 $46,289.50 $18,941.00 $88,627.67
$4,212.00 $0.00 $0.00 $4,212.00
$9.696.00 $15,414.00 $18.542.00 543,652.50
$11,681.00 $6,171.00 $222,001.20 $39,863.20
$76.052.96 $59,938.04 $97,036.24. $233,02724
$27.343.41 $10,210.00 $10,862.99 $48,416.40
$7.725.93 $4,988.08 $15,068.08 $27,780.09
$68,541.83 $54,920.08 $85,094.98 $226.556.89
$999,251.26 ;1,044,488.65 $1255,488.53 $0.00 $3,299,228,44
I-lealth Fund 12211
840 221 20221-1050201-133150-773830
843 221 20221-1080220-134390-773630
,luvenile Maintenance Fund [2931
665 293 20293-1060501-112090-773630
63600-1080101-152000-631365
IMAGING
722 10100-2010210-125000-773639
471 27100-3010404-126030-773639
512 10100-3040403-124010-773639
63600-1080101-152000-630903
Health
Health Environmental
Sub-Total Fund 221
Children's Village
Sub-Total Fund 283
DATA PROCESSING DEVELOPMENT FOR
GOVERNMENTAL FUND APPROPRIATION
Clerk Image
Courts-FOC Exp-CS Enforcement Image
Probate-Estates/Mental Health Image
TOTAL IMAGING DEVELOPMENT
APPROPRIATION
$61,628.20 ;42,175.70 $29,812.00
$343,181.43 $342,236.58 $314,6$5.9Q
$394,809.63 $384,412.28 $344,447.98
1,17.00 $1,458.00 $1,917.00
$4,745 00 $1,458.00 $1,917.00
51,398,805,89 $1.430.358.93 51.601,853,51
$71,973.18 $54.738.23 $58,852.83
56.622,50 $10,603.70 $7527.80
$2,081.00 $3,480.60 $3183.40
$80.67568 $68,822.53 $69.564.03
$123.615,90
$1.000.053.99
$0.00 $1,123,669.89
58,120 00
$0.00 $8,120.00
12,% $4.431.018.33
$185,564.24
$24,754.00
$8.745.00
$219,063.24
$0.00 $4,650,081.57
$0.00 1$4,650.081,571
$0.00 ELM
Prepared by, Information Technology; 7/6/2006 3rd Qtr 2006.xls
st Qtr 2nd Qtr 3rd Qtr 4th Qtr
DIVISION Oct - Dec Jan - Mar - June July - $eal ACCOUNT # Y.T.D.
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
3RD QUARTER 2006
NON-GOVERNMENTAL
DIRECT CHARGES
055 CLEMIS 0.43.570.81 $39,015.23 $38,384.64 $120.970,68
056 CLEMIS FUND 63500 $0.00 $0.00 $0.00 $0,00
096 CLEMIS 2005 IBIS Grant $732.00 $549.00 $488.00 $1,769.00
719 ClerldROD Automation Fund $21.630.00 $35.625.00 $5,114.00 $62,369.00
521 Community Corrections (Grant) $0.00 $0.00 $0.00 $0.00
661 Community & Home improvement $0 00 $0.00 $366.00 $366.00
470 Courts-FOC Exp-Family Counseling $0 00 $0.00 $0.00 $0.00
507 Courts-FOC Exp-CS Enforcement $97600 $3.111.00 $4,087,00 $8,174.00
210 Fire Records Management System $496561 $2,847.83 $4,396.73 $12,230,17
757 FM-Wk Rel/Jail Mgt/Video Con( $28.079 93 $12,546.08 $6,912.48 0.47,53849
758 FM-Jail figmt Replacement $48800 $954.00 $0.00 $1442.00
754 F M & 0 0.1.87800 0.0.00 $2,526.00 $4.404.00
759 F M & 0-Safely Overhead $000 $0.00 $0.00 $0.00
655 Gararge $2401400 $27,891.00 $6,489.00 $58,394.00
809 Health - Sip Flu Clinic Grant $000 $0,00 $10,914.00
360 Health - Immunization Grant $2.666 00 $4,266,00 $4,698.00 $11,530.00
751 IT - Telephone Communications $000 $0,00 $0.00 $0.00
662 Major Department Support Project Fund $359,632.10 $108.204,20 $19,703.15 $487,539.45
870 Medical Care Facility $7.538 61 $3.164,33 $3,800.23 $14,503.17
248 Medical Care Facility - Pharmacy $0.00 $0.00 $0.00 $0.00
651 O.C. International Airport-GRE Grant $0.00 $0,00 $0.00 $0.00
653 O.C. International Airport $683.00 $7,214.00 $1,952.00 $9,849.00
770 Parks and Recreation - Administration $0.00 $1,082.00 $1.938.00 $3,020.00
790 Radio Communications $0.00 $0.00 $0.00 $0.00
696 Risk Management $0.00 $0.00 $61.00 $61.00
602 Treasurer -100% Tax Paymt Fund ($1,485.50) $527.00 ($527.00) ($1.485.50)
656 Water & Sewer Accounting $5,06593 $6,341.08 $6,567.48 517,974.49
850 Workforce Development $0.00 $0.00 $0.00 Ea
631300-1080101-152000-631302 SUB-TOTAL DIRECT CHARGES FOR DATA $500,354.49 $253.337.75 $117,870.71 ala ;871.512.95
PROCESSING DEVELOPMENT
TOTAL COUNTY DEVELOPMENT CHARGES $1.979.837.06 $1.752,519,21 $1,789.288.25 $0.00 15.521.614,52
NON-COUNTY AGENCIES
836004080101-152000-835017 Non-County Agencies $2,215.00 $1,114.50 V32.00 $4.061.50
TOTAL DEVELOPMENT CHARGES $1,982,052.06 $1,753,833.71 $1,790,020.25 $0.00 $5,525,706.02
Prepared by Information Technoiogy. 7/6/2006 3rd Qtr 2006,xls
$22,225.25
4,981.48
13,451.50
18.194.60
$4,981.48
2,684.00
$29,628.50
$9,126.50
$4,981.48
71,854.00
1,521.00
$579.50
3,161,00
0,00
$1,403.00
$6.783.38
$2,490.74
$9,274.12
$0.00
$0.00
3rd Qtr 2006.xte
$0,00
$0.00
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER, 2006
Cust # GOVERNMENTAL FUNDS
005 BOARD OF COMMISSIONERS 91404 BOC-Cust Supt $2,379.00
BOC - Total
630 ANIMAL CONTROL 95628 Web License Registration $2,755.00
95682 Dog System 23 191.00
Animal Control-Total
$2,379.00
$25.946.00
620 AUDITING 44032 Auditing-System Maintenance $0.00
95468 Auditing-Gust Su pt 244.00
Auditing - Total $244.00
665 CHILDRENS VILLAGE 95665 Childrens Village $1,917.00
Childrens Village - Total $1.917.00
725 CLERK - ADMIN 72500 Clerk - Admin $6,941.00
Clerk - Admin - Total $6,941.00
440 CLERK - ELECTIONS 95443 Elections $18,270.00
Clerk -Elections - Total $18,270.00
720 CLERK / REGISTER OF DEEDS 20004 IDMS Support - Register of Deeds $488.00
36510 GIS Implementation Support-ROD 335.50
36511 ROD Application - HIM Support 396.50
95493 Reg Deeds System Maintenance 0.00
95162 Clerk - DW Support 1,016.00
95558 User Support/ROD 0.00
95564 ROD - DW Support 0.00
Clerk/Reg of Deeds - Total $2,238.00
722 CLERK - IMAGING
410 CLERK-JURY COMMISSION
724 CLERK - LEGAL RECORDS
723 CLERK - VITAL STATISTICS
522 COMMUNITY CORRECTIONS-ADMIN IC01
785 COMMUNITY & ECO DEVELOPMENT
430 CORPORATION COUNSEL
13001 Clerk - eFiling - 50%
23007 Oracle Support - Clerk Image
65420 Clerk - Image Replace
95158 Clerk - Imaging
Clerk - Imaging - Total
23008 Oracle Support - Jury Comm
95512 Jury Commission
Clerk -Jury Commission - Total
95189 Circuit Court System
Clerk - Legal Records - Total
95161 Vital Stets Index
Clerk - Vital Statistics - Total
23003 Oracle Support-Comm Corr
52200 Comm Corr-Admin (County)
52201 Comm Corr-DW Supp
Community Corrections - Total
36500 GIS Implementation Support C&E Dev
36501 CEO Application - HNV Support
95785 Comm & Eco Developmt
Community & Eco Dev - Total
95501 Corporation Counsel
$58.852.83
$7,665.48
$29,628.50
$9,126.50
$78,356.48
$3,740.50
Corporation Counsel - Total $1.403.00
495 CTS-BUSINESS DIVISION
487 CTS-FD-CT SERV-ADMIN
492 CTS-FD-CT SERV-ADOPTIONS
Prepared by: Information Technology; 71612006
14001 DW Support - Circuit Court
23010 Oracle Support-CCT/CTS Grim Whse
CTS-Business Division - 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
$0.00
9,504.00
18,753.00
24,002.50
0.00
$52,259.50
$976.00
4,981.48
3,476.23
0.00
12,170.50
5,277.00
18,355.00
5,566.00
621.00
16,955.50
29 269.00
$97,647.71
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER, 2006
505 CTS-FD-JUDICIAL 95186 CTS-FD/ADMIN-Family Judges $0.00
CTS-FD-Judicial - Total $0.00
506 CTS-FD-JUDICIAL SUPPORT 95187 CTS-FD/Admin - Fam Suppt Staff $8,114.50
CTS-FD-Judicial Suport - Total $8.114.50
483 CTS-FD-JUDICIAL SUPPORT-ADM 24009 SQL Serv Supp - CTS-Jud Sup Adm $1,738.11
95193 CTS-FD-Judicial Suport-Adm 6750.00
CTS-FD-Judicial Suport-Adm - Total $8,488.11
484 CTS-FD-JUVENILE REFEREES 95191 CTS-FD-Admin-Juvenile Referees $0.00
CTS-FD-Juvenile Referees - Total $0.00
474 CTS-FD-JUVENILE SUPPORT 95474 CTS-FD-Admin-Juvenile Support $11,192.00
CTS-FD-Juvenile Support - Total $11,192.00
499 CTS-GJ-ASSIGNMENT 95180 CTS-GJ-Assignment $2.257.00
CTS-GJ-Assignment - Total $2,257.00
501 CTS-GJ-CRIMINAL CASE SUPPORT 95182 CTS-'3J-Criminal Case Support $1.690.00
CTS-GJ-Criminal Case Support - Total $1.690.00
420 CTS GJ - FAMILY SUPPORT 95195 Cir Crt Admin $9.218.00
Courts - GJ - Family Support - Total $9,218.00
496 CTS -GENERAL JURISDICTION 95208 CTS DW Maintenance $162.00
CTS - General Jurisdiction - Total $162.00
498 CTS-GEN JURIS-JUDICIAL SUPPT 95179 CTS -Gen June-Judicial Suppt $45.589.00
CTS -Gen June-Judicial Suppt - Total $45,589.00
500 CTS-GJ-MEDIATION 95181 CTS-GJ-Mediation $5,929.50
CTS-GJ-Mediation - Total $5,929.50
493 CTS-JUDICIAL ADMIN 13002 Courts - eFiling 50% $22,225.25
95174 CTS-Judicial Admin 10% 12.20
CTS-Judicial Admin - Total $22.237.45
730 DRAIN COMMISSIONER
740 EQUALIZATION
28007 Drain Commissioner
28011 Drain Commissioner Application
36520 GIS Implementation Support Drain
36521 ()CDC Application - HNV Support
95669 Water & Sewer Accounting
Drain Commissioner - Total
20001 IDMS Support-Equalization
23012 Oracle Support-Equalization
24005 SQL Server Supp-Equalization
31075 Equal - Development
36505 GIS Implementation Support Equalization
36506 Equal Application - HNV Support
95559 User Support/Equal
95562 Equalization - OW Support
95570 Equalization - OW Maintenance
95693 Equal-System Maintenance
95699 BS&A Master Appraisal Sup/Maint
Equalization - Total
$2,196.00
900 EMERGENCY RESPONSE & PREPAREDNESS 36545 GIS Implementation Support EMS $2,196.00
36546 ERP Application - H/W Support 0.00
98990 Emergency Response $0.00
ERP - Total
755 FACILITIES MANAGEMENT 91500 FM - System Support $0.00
Facilities Mgmt - Total $0.00
Prepared by Information Technology; 7/612006 3rd Otr 2006.xls
$9,962.96
14,499.66
1,400.87
674.49
64,646.50
59,585.50
20,339.00
0.00
0.00
1,921.50
0.00
85,585.36
42,792.68
$301,408.52
$29,812.00
$314.635.98
840 HEALTH DEPARTMENT 20002 IDMS Support - CHAMPS $488.00
36525 GIS Implementation Support Health 15,796.00
37025 CHAMPS - P.O.P. 4,752.00
96842 Health Admin 8776.00
Health - Total
843 HEALTH - ENVIRONMENTAL, 23005 Oracle Support - EH Projects $4,981.48
37002 Environmental 2,484.00
84200 EH - Projects 205,205.00
84300 Ehealth Program 101 965.50
Health-Environmental - Total
680 HUMAN RESOURCES 23014 Oracle Support-HR/Personnel $9,696.09
$99,736.32
$1.647.00
641 MATERIALS MGMT-GEN SUPPORT SERV 95440 Materials Management $24.40
Materials Mgmt-Gen Fund - Total $24.40
24007 SQL Server Suppport-HR/Personnel 1,400.87
44042 PER-Systems Maintenance 2,580.00
95556 Personnel User Supt 474.00
96002 Human Res-Personnel 40% 85 585.36
Personnel - Total
907 LIBRARY - ADMINISTRATION 91405 Library - Admin $1.647.00
Library - Admin - Total
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL • THIRD QUARTER, 2006
660 FISCAL SERVICES ADMIN 23001 Oracle Support - Fiscal Serv
23013 Oracle Support - HR-Acctg/Budget
24006 SQL Serv Supp - HR-Acctg
24008 SQL Serv Supp - Buoget
44021 FS-System/Customer Support
44022 FS-System Maintenance
44023 FS-System Enhancements
44024 FS-New Development
44077 BUD-System Maintenance
44079 FS - OW Support
44081 FS - OW Maintenance
96001 Human Res-Acct 40%
96003 Human Res.-Budget 20%
Fiscal Services Admin - Total
872 MEDICAL EXAMINER 24002 SQL Server Support - Medical Exam $3,476.23
87202 Medical Examiner - Customer Support 82.232.00
Medical Examiner - Total
710 MSU EXTENSION -OAKLAND 95676 MSU Ext Equipment Maintenance $0.00
MSU Extension - Oakland - Total
775 PLANNING & ECONOMIC DEVELOPMENT 95786 PEDS - DW Support $386.00
PEDS - Total
$85,708.23
$0.00
$366.00
512 PROB-ESTATES/MENTL HUTH IMAGE 95207 Prob-Est/Mntl Hlth Image $3,183.40
Prob-Est/Mntl Hlth Image - Total $3,183.40
$0.00
509 PROB-JUDICIAL ADMIN 95165 PC-Judicial Admin-Admin Serv $0.00
Prob-Judicial Admin - Total
510 PROB-ESTATES/MENTL HLTH SUPPORT 24010 SQL Serv Supp-PCT-Est/Mental $1.738.10
92198 Prob-Est/Mntl Hlth Support 3.920,00
Prob-Est/Mntl Filth Support - Total
481 PROBATE-FD JUDICIAL 95168 Prob-FD Judicial $1,150.00
Prob-FD Judicial - Total
95188 PROB-FD Judicial Support 512Q
PROB-FD Judicial Support - Total
479 PROI3-FD-JUDICIAL SUPPORT
$5.658.10
$1,150.00
$0.00
Prepared by: Information Technology, 7/612006 3rd Qtr 2006.xls
145 PROSECUTOR - GENERAL PROSECUTION
690 PURCHASING
637 RECORDS RETENTION
650 REIMBURSEMENT
195 SHERIFF
191 SHERIFF - CLEMIS
445 SUPPORT SERVICES
600 TREASURER
$0.00
0.00
$0.00
$0.00
18,542.00
0.00
$18,542.00
$4,981.49
5.881.50
$10,882.99
$4,981.48
10 086.60
$15,068.08
$1.671.50
$1,671.50
61,671.50
$1,671.50
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - THIRD QUARTER, 2006
95622 Prosecutor/Executive $17,969.00
97001 Prosecutor Data Proc 972.00
Prosecutor-Total $18.941 00
44026 PUR-System/Customer Support
44027 PUR-System Maintenance
Purchasing - Total
44052 Rec-System Maintenance
44054 Rec-New Development
95636 Mail Room
Rec-New Development - Total
95469 Reimbursement State Mandate $11,168.00
95470 Reimbursement System 7,012.20
95542 Reimburse User Support 3,821.00
Reimbursement - Total $22.001,20
23009 Oracle Suppport - OCSD/CTS Crim Whse $2,490.74
97163 Sheriff 80,710.00
97164 Sheriff-Development 0.00
97165 Sheriff-OW Support 12.248.50
97166 Sheriff-OW Maintenance 1,587.00
Sheriff - Total $97,036.24
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 $4,981.48
36515 GIS Implementation Support-Treasurer 427.00
36516 Treasurer Application - HAN Support 30,097,00
44061 Tre-System/Customer Support 122.00
44062 Tre-System Maintenance 11.638.00
44080 Tre-DW Support 15,695.00
44082 Tre-DW Maintenance 5,292.00
95008 Del Tax On Line 732.00
95303 Del Tax System Maintenance 18,110.50
95561 User Support/Der Tax 0.00
Treasurer - Total $85,094.98
540 52/1 DISTRICT COURT - NOVI 14002 DW Support - 52/1
95527 DC Suprt-25%-5211
52/1 District Court - Total
$565.28
5,276.25
$5,841.53
541 5211 DISTRICT COURT - NOVI - PROBATION 94542 DC Probation Support - 52/1 - 25%
52/1 District Court - Probation - Total
550 5212 DISTRICT COURT - CLARKSTON 14003 OW Support - 52/2
95528 DC Suprt-25%-5212
52/2 District Court - Total
$565.28
5,276.25
$5,841.53
551 52/2 DISTRICT COURT - CLARKSTON - PROBAT 94552 DC Probation Support - 52/2 - 25%
52/2 District Court - Probation - Total
560 6213 DISTRICT COURT - ROCHESTER 14004 DW Support - 52/3 $565.28
95529 DC Suprt-25%-52/3 5,276.25
52/3 District Court - Total $5,841.53
Prepared by: Information Technology; 7/6/2006 3rd Qtr 2006.xls
$565.28
5,276.25
$5841.53
$1,671.50
$1.671.50
INFORMATION TECHNOLOGY - RESERVE FUND ,
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER, 2006
561 52/3 DISTRICT COURT - ROCHESTER - PROBAT 94562 DC Probation Support - 52/3 - 25% $1,671,50
52/3 District Court - Probation - Total $1,671.50
530 52/4 DISTRICT COURT - TROY 14005 DW Support - 52/4
95530 DC Supd-25%-5214
52/4 District Court - Total
531 5214 DISTRICT COURT - TROY- PROBATION 94532 DC Probation Support - 52/4 - 25%
52/4 District Court - Probation - Total
Gust # DIRECT FUNDS
055 CLEMIS 20003 IDMS Support $488.00
24004 SQL Server Support 31,026.64
95409 CRISNET/CLEMIS LRM 682.00
95430 CLEMIS Maintenance 6,188.00
95431 CLEMIS Enhancements 0.00
CLEMIS - Total $38,384.64
056 CLEMIS FUND 63500 63500 CLEMIS Fund $0.00
CLEMIS Fund - Total $0.00
096 CLEMIS 2005 IBIS GRANT 63596 2004 Federal Approp - IBIS Project $488.00
CLEMIS 2004 IBIS Grant - Total $488.00
719 CLERK/ROD AUTOMATION FUND 95719 Register of Deeds Automation $5.114.00
Register of Deeds Automation - Total $5,114.00
661 COMMUNITY & HOME IMPROVEMENT 66103 Community & Home Improvement $366.00
Community & Home Improvement - Total $368.00
471 CTS-FOC-EXP-CS ENFORC-IMAGE 92194 CTS-FOC-Exp-CS Enf-image $7,527.60
CTS-FOC Exp-CS Enf-Image - Total $7.527.80
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 $4.087.00
CTS-FOC Exp-CD Enforc-Dev - Total $4,087.00
210 FIRE RECORDS MANAGEMENT SYSTEM 21010 Fire Records Mgmt Fund 531 $920.50
24001 SQL Server Support - FRMS 3,476.23
Fire Records Mgmt - Total $4,396.73
750 FM&O 21001 FM&O $122.00
75503 FM&O Development 2,404.00
FM&O - Total $2,526.00
757 FM-WK RELEASE/JAIL MGMTNIDEO CONF 23004 Oracle Support - Oak Video $4,981,48
75700 Fac Mgmt - Video Arraignments 1,931.00
FM-Wk Rel/Jail MgmtNideo Conf - Total $6,912.48
758 FM - JAIL MGMT REPLACEMENT 75800 FM - Jail Mgmt Replacement MOO
FM - Jail Mgmt Replacement - Total $0.00
655 GARAGE 44057 GAR - Systems Maintenance $6,489.00
44058 GAR - Systems Enhancements 0,00
Garage - Total $6489.00
809 HEALTH - BIO FLU CLINIC GRANT 80900 Health - Bio Flu Clinic $10,914.00
Health - Bio Flu Clinic - Total $10,914,00
380 HEALTH IMMUNIZATION - GRANT 38000 Health - Immunization $4,698.00
Health - Immunization - Total $4,698.00
Prepared by: information Technology; 7/812006 31d Qtr 2006.xis
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER, 2006
662 MAJOR DEPT SUPP PROJ FUND 66200 e-Financial-Peoplesoft Implementation $19.703.15
e-Financial-Peoplesoft Implem-Total $19,703.15
870 MEDICAL CARE FACILITY 24003 SQL Server Support - tvICF $3,476.23
98873 MCF - Support 324.00
MCF - Support - Total $3,800.23
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 $732.00
65301 Airport User Support 1,220.00
Airport User Support - Total $1,952.00
770 PARKS AND RECREATION 36530 GIS Implementation Support-Parks $1,098.00
95419 PRADM-Administration 840.00
Parks & Recreation - Total $1,938.00
790 RADIO COMMUNICATION 79001 Radio Communications $0.00
Radio Communications - Total $0.00
895 RISK MANAGEMENT 44036 RSK-System/Customer Support $61.00
95695 Risk Management 0.00
Risk Management - Total $61.00
602 TREASURER-100% TAX PAYMT FUND 99002 Treasurer's Office ($527.00)
Treasurer's Office - Total ($527.00)
656 WATER & SEWER ACCTG 23011 Oracle Supp - Water & Sewer Acct'g $4,981.48
95669 Water & Sewer Acct'g 1,586.00
Water & Sewer Acct'g - Total $6,567.48
850 WORKFORCE DEVELOPMENT 95670 Workforce Development $0.00
Workforce Development - Total $0.00
Prepared by Information Technotogy; 7/6/2006 3,1 Qtr 2006.xls
FISCAL NOTE (MISC. #06159) August 31, 2006
BY: FINANCE COMMITTEE, CHUCK MOSS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - THIRD QUARTER 2006
DEVELOPMENT APPROPRIATION TRANSFER
TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS
Chairperson, Ladies and Gentlemen:
Pursuant to Rule X11-C of this Board, the Finance Committee has
reviewed the above-referenced resolution and finds:
1. The resolution appropriates and charges the Information
Technology Third Quarter 2006 Development cost to benefiting
departments.
2. The third quarter data processing development charges are
$1,601,853.51; Imaging Development charges are $69,564.03 for
General Fund/General Purpose departments; direct charges to
Special Revenue and Proprietary fund departments are
$117,870.71 and charges to non-county agencies are $732.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 #06159 August 3, 2006
The Chairperson referred the resolution to the Finance Committee. There were no objections.
•P"
Resolution #06159 August 31, 2006
Moved by Palmer supported by Zack the resolutions (with fiscal notes attached) on the Consent Agenda,
be adopted (with accompanying reports being accepted).
AYES: Coleman, Coulter, Crawford, Douglas, Gershensen, 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, were adopted (with accompanying reports being accepted).
INN ANN TIE FOREGOING Efi0011111
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 August 31, 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 31st day of August, 2006.
n.'Countv CIE RullaJohnsit5n ;County Clerk