HomeMy WebLinkAboutResolutions - 2007.04.26 - 28322MISCELLANEOUS RESOLUTION #101075 April 5, 2007
BY: GENERAL GOVERNMENT COMMITTEE, CHRISTINE LONG, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FIRST QUARTER 2007
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 2007 data processing development charges to be
$1,539,657.88 and the imaging development charge to be $179,755.88 for
the General Fund/General Purpose County departments; and
WHEREAS direct charges to Special Revenue and Proprietary Fund
departments are $130,584.19, non-governmental imaging development is
$19,496.25, and non-county agencies are $1,344.00 for the First Quarter
2007; 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 2007 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 roll call vote with Hatchett absent.
2nd 07 1st Qtr
Oct-Dec DIVISION LT,21
Otr • 4th Qtr
Ant-June juiv - Seel ACCOUNT is
1-leanh Fund 12211
840 221 20221-1080201-135150-773630
843 221 20221-1050220-134390-773630
Juvenile Maintenance Fund 12931
665 293 20293-1060501-112090-773630
$6,971.45
$0.00
18,971.45
10.00
$6,971.45
$0.00
$6,971 40
$0.00
59.570.50
1305.00
$732.04
518,942.00
$42,941.00
$5,501.13
137,785.50
$18,382.20
$19,744.50
$40,817.25
$48,820.03
$8,488.00
$8,433.32
$0.00
$0.00
$0.00
$0.00
$0.00
$3,929.28
10.00
$3,418.00
$000
/34,429.00
$8,534,20
$3.051.50
$0.00
163,107.54
$2,348.50
$123,347.80
$0.00
1275.868.37
$120,788.19
11,098.00
10.00
$27271.07
11.403.00
51,891.00
$0.00
$5,723.26
$0.00
$0.00
$12,472.00
$000
)8,148.00
116256.00
$106,721.07
$9,473.80
$18,5136.13
$103,251,63
)122.00
$0.00 $0.04 50,00 $1,233,452.70
$7,960.80
5207.185.35
$0.00 $0.00 $0.00 $305,746.18
1459,00
$0.00 $0.00 $0.00 $450.00
$0.00 $0.00 12,2 11,539,657.89
$179,511.58
$244.00
$0,00 ;kg $179,755.88
$0.00 $0.00 $0.00 01,710,413.76
$0.00 ELN )0 OQ f$1,719.413.76)
E_Lo.,2 199Q $0.00 $0.09
UM I UtVtwrivitil st)MMfrier41
1ST QUARTER 2007
540 101
541 101
550 101
551 141
NO 101
5131 101
530 101
531 101
030 101
824 101
005 101
725 101
440 101
410 101
724 101
720 101
723 101
765 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
060 101
880 101
907 101
541 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
010 101
GOVERNMENTAL FUNDS
General f und 11011
10100-3020201-121020-773630
10100-3020205-113290-773630
10100-3020301-121020-773630
10100-3020305-113290-773830
10100-3020401.121020-773830
10100-3020405-113290-773630
101043020501-121020-773830
101043020505-113294773830
10100-1070801-114004773630
10100-1010201-181010-773830
10100-5010101-180010-773830
10100-2010201-180004773830
10100-2010301-185010-773530
10100-2010501-125000-773830
10100-2010210-125000-773830
10100-2010401.172190-773630
10100-2010205-132304773630
10100-1090101-171000-773630
10100-1074401-113000-773830
10100-1010501-181020-773630
101043010201-121110-773630
10100-3014401-121240-773830
10100-3014103-121234773630
10100-3010402-121104773630
10100-3010402-135080-773830
10100-3010401-121220-773630
10100-3010403-121100-773630
10100-3010301-121140-773630
10100-3010301-121224773830
10100-3010301-121110-773830
10100-3010301-121130-773630
19100-3010301-121150-773830
10100-3010101-121100-773630
10100-1010101-161000-773530
10100-0010101-155010.773830
10100-1010115-115090-773830
10100-1020501-173010-773830
10100-1040101-140000-773630
101004020501082020-773830
101004050401-183010-773830
10100-5010303-185040-773830
10100-1030850-184030-773830
10100-1070601-132030-773830
10100-1070591-174004773630
10100-1000201-171000-773830
10100-3040191-121080-773830
10100-3040403-124010-773030
10100-3040101-121000-773830
10100-3040101-121070-773630
10100-4010101-122050-773630
10100-1020401-182090-773630
10100-1030803-184020-773830
10100-1020701-120020-773830
101004030301-112590-773630
10100-4030001-110000-773830
10100-1030803-184030-773630
10100-7014101-186040-773630
10100-1070301-132050-773634
63600-1080101-152000-631365
43600-1080101.152000-630403
52/1 • District Court
5211 • District Court - Probation
5212 District Court
52/2 - District Court • Probation
52/3 - District Court
52)3- District Court - Probation
5214 - District Court
5214 Mallet Court - Probation
Animal Control
Auditing
Board of Commissioners
Cleric- Admen
C4erk - Elections
Clerk - Jury Commission
Clerk • Legal Records
Clerk - Register of Deeds
Clerk - Vitat Statistics
Economic Development & Community Affairs
Community Corrections Admin
Corporation Counsel
Courts-Business Division
Courts-FD Juvenile Support
Courts-FD Juvenile Referees
Courts-FD-Court Services-Admit'.
Courts-FD-Court Services-Adopoons
Courts-FD-Judicl Support
Couns-FD-Judicial Support-Admen
Courts-GJ-Assignment
Courts-CJ-Famlly Support
Courts-General Jurisdiction
Courts-GJ-Judicial Support
Courts-GJ-Mediation
Courts - Judecal / Administration
County Executive
Drain Commissioner
Emergency Response & Prep
Equalization Division
Facilities Management
Fiscal Services - Adrnin
Human Resources
Library Admen
Materials Management - Gen Fund
Medical Examiner
MSLI Extension - Oakland
Planning & Economic Development
Probate - Judicial Admen
Probate-Estates/Mental Health Support
Probate-FD-Judicial
Probate-FE.Judicral Supaort
Prosecuting Attorney - General Prosecution
Purchasing
Records Retention
Reimbursement Division
Sheriff
Sheriff - CLEMIS
Support Services
Treasurer
Veterans Services
Sub-Total Fund 101
Health
Health Enveronmental
Sub-Total Fund 221
Children's Village
Sub-Total Fund 293
DATA PROCESSING DEVELOPMENT FOR
GOVERNMENTAL FUND APPROPRIATION
Cleric Image
Probate-Estates/Mental Healtn image
TOTAL GOVERNMENTAL IMAGING
DEVELOPMENT APPROPRIATION
TOTAL GOVERNMENT:
GOVERNMENTAL IMAGING
722 10100-2010210-125000-773639
512 101043040403-124010-773539
$6.971.45
$0.00
56,971.45
$0.00
$5,971.45
$0.00
56,971,40
$0.00
$9,570.50
$305.00
$732.00
516.942.00
$42,941.00
$5,601,13
$37,78550
$18.382.20
$19,744.50
$40,617.25
$448.629.83
18,468.00
$6,433.32
50.04
$0.00
10.00
$000
$0.00
13,929.28
$0,00
$3.416,09
$0.30
$34,429.00
$8.53420
$3.051.50
$0.00
$6310750
52.346 50
$123,347.60
£0 00
$275,868,37
$120,788.19
$1 098.00
50.00
$27,271.07
$140300
$1,891.00
$0 00
$5,723.28
$0.00
$0.00
$12.412.09
$0.00
$5,146.00
$16,256.00
$106.721.07
$9.473.00
$16,565.13
$103,251.63
)122.00
$1.233,452.70
$7,960.80
$297,785,38
$305.746.18
$459.00
$4459.00
$1-539,657.88
5179.511 88
5244.90
$179,755.88
$1,719.41176
$0.00
SUB-TOTAL GOVERNMENTAL I IMAGING DEVELOPMENT APPROPRIATION:
$1.719,413 76 10100-9090101 -196030-773530 Information Technology Development a1.719,413.76)
Prboared by information Technoiogy 1/412007 Is' Ott 2047.xIS
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
1ST QUARTER 2007
1st Qtr 2nd Qtr 3rd QV 4th Qtr
ACCOUNT DIVISION Oct - ZeC Jan - Mar Afar • Ame Juiv - Sent 'LTD.
NON-GOVERNMENTAL
DIRECT CHARGES
055 C,LEMIS $68,40579 $68,405.79
056 CLEMIS FUND 63500 50,00 10.00
096 CLEWS 2005 IBIS Grant $356.00 5366,00
719 Clerk/ROD AutornaUon Fund $0.00 $0.00
661 Community & Home Improvement $671.00 $671.00
470 Courts-FOC Exp-Family Counseling 50.00 $0.00
507 Courts-FOC Exp-CS Enforcement 56.806.00 $6,606.00
210 Fire Records Management System $4,203.07 $4.203.07
757 FM-Wk Rel/Jail MatNideo Cant $11,738,13 $11,738.13
758 FM-Jall Mann Replacement $0.00 $0.00
750 F AI & 0 53,755.00 53,755.00
555 Gararge $3,714,00 $3,714.00
380 Health - immunization Grant $0.00 $0.00
662 Maim Department Support Prefect Fund 54,758,00 $4,756.00
870 Medical Care Fackity $3.553,57 $3,1353.57
248 Medical Care Facility - Pharmacy $0.00 50.00
1353 O.C. International Airport $1,792,00 $1,792.00
770 Parks and Recreation - Administration 5366,00 5368.00
790 Radio Communications $000 $0.00
595 Risk Management $0.00 $0.00
601 Treasurer - DTRF $10,844.50 510,844,50
602 Treasurer -100% Tax Paymt Fund $366,00 $368.00
656 Water & Sewer AccounaN $8.840.13 $8,840.13
850 Workforce Development 305.00 ;305.00
63600-1080101-152040-831302 SUB-TOTAL DIRECT CHARGES FOR DATA $130,584,19 $0.00 $Q,QQ $0.00 5130.0042
PROCESSING DEVELOPMENT
NON-GOVERNMENTAL IMAGING
471 Courts-FOG Exp-CS Enforcement Image $19,495,25 $19496,25
63800-1080101-152000-630903 TOTAL NON-GOVERNMENTAL IMAGING $19,496.25 10.00 E0,221 $0.00 $19,496.25
DEVELOPMENT APPROPRIAllON
TOTAL COUNTY DEVELOPMENT CHARGES ;1,050494.20 $0.00 $0.00 ;0,00 $1,880.494.20
NON-COUNTY AGENCIES
63600-1080101-152000-635017 Non-County Agencies 51,344,40 11,m4 00
TOTAL DEVELOPMENT CHARGES $1,070,8311.20 $0.00 $0.00 $0.00 $1,870,838-20
1St Oa 2007.X.5 Prepared by: Purnmabon Team-100yr 114/2007
$732.00
$732,00
91404 BOO-Gust Supt
BOC - Total
005 BOARD OF COMMISSIONERS
13001 Clerk - eFiling - 50%
23007 Oracle Support - Clerk Image
65420 Clerk • Image Replace
95158 Clerk - Imaging
Clerk - Imaging - Total
722 CLERK - IMAGING $2,929.50
4,930.13
0.00
171,652.25
• INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER, 2007.
cust #_GOVERNMENTAL FUNDS
630 ANIMAL CONTROL 95628 We License Registration $1040400
95682 Dog System (833.501
Animal Control-Total $9,570.50
620 AUDITING 95468 Auditing-Customer Support $305.00
Auditing - Total $305.00
665 CHILDRENS VILLAGE 95665 Childrens Village $459.00
Childrens Village - Total $459.00
725 CLERK - ADMIN 72500 Clerk - Admin $16,942,00
Clerk - Admin - Total $16,942.00
440 CLERK -ELECTIONS 95443 Elections 1.42.941.00
Clerk -Elections - Total $42,941.00
720 CLERK / REGISTER OF DEEDS 20004 IDMS Support - Register of Deeds $317.20
36510 GIS Implementation Support-ROD 6,741,00
36511 ROD Application - li/VV Support 427,00
95493 Reg Deeds System Maintenance 0.00
95162 Clerk - OW Support 9,494.00
95163 Clerk - OW Maintenance 1,403,00
95558 User Support/ROD 0.00
95564 ROD - DW Support 0 00
Clerk/Reg of Deeds - Total $18.382.20
$179,511.88
410 CLERK - JURY COMMISSION 23008 Oracle Support - Jury Comm - 5.6% $4.930.13
95512 Jury Commission 671.00
Clerk -Jury Commission - Total $5,601.13
724 CLERK - LEGAL RECORDS 95189 Circuit Court System $37,785.50
Clerk - Legal Records - Total $37,785.50
723 CLERK - VITAL STATISTICS 95161 Vital Stets Index $19,744.50
Clerk - \Mat Statistics - Total $19,744.50
522 COMMUNITY CORRECTIONS-ADMIN (C01 23003 Oracle Support-Comm Gorr - 5.6% $4.930.13
52200 Comm Corr-Admin (County) 43.062.50
52201 Comm Corr-OW Supp 837.00,
Community Corrections - 7otal $48,829.63
785 COMMUNITY & EGO DEVELOPMENT
430 CORPORATION COUNSEL
36500 GIS Implementation Support C&E Dev $30.50
36501 CEO Application - HNV Support 610 00
95785 Comm & Eco Developmt 39 976.75
Community & Eco Dev - Total $40.617.25
95501 Corporation Counsel $8,488.00
Corporation Counsel - Total 88,468.00
495 CTS-BUSINESS DIVISION 14001 CTS-DW Support/Circuit Ct - 75% $3.907.50
15001 CTS-DW MaInt/Circuit Ct - 75% 60.75
23010 Oracle Support-CCT/CTS Cnm Wrise 2,465.07
CTS-Business Division - Total
487 CTS-FD-CT SERV-ADMIN 95195 CTS-FD-Ct Serv - Admin $0.00
CTS-FD-Ct Serv-Admin Total
492 CTS-FD-CT SERV-ADOPTIONS 95173 CTS-FD-Ct Serv-Adoptions $0.00
CTS-FD-Ct Serv-Adoptions - Total
505 CTS-FD-JUDICIAL 95186 CTS-FD/ADMIN-Family Judges $0.00
Prepared by' Information Technology. 1/4/2007
$6,433.32
$0.00
$0.00
lot Otr 2007.xy
CTS-FD-Judicial - Total
95187 CTS-FD/Admin Fam Suppt Staff $0.00
CTS-FD-Judicial Suport - Total
506 CTS-FD-JUDICIAL SUPPORT
$0.00
$0.00
$8,788.00
24.882.00
11 .236.00
18.221.50
0.09
$63,107.50
36545 GIS Implementation Support EMS $1,220.00
36546 ERP Application -1-i/W Support 1,128.50
98990 Emergency ResPonse ESO
ERP - Total
20001 IDMS Support-Equalization - 40% $834.40
23012 Oracle Support-Equalization - 5.6% 4,930.13
24005 SQL Server Supp-Equalization - 6.7% 3,772,57
31075 Equal - Development 0.00
36605 GIS Implementation Support Equalization 51.00
36506 Equal Application - H/W Support 8,894.50
36507 Equal LAMS Support/Mtce 11.789.50
95559 User Support/Equal 19.267.00
95562 Equalization - DW Support 12.544.00
95570 Equalization DW Maintenance 880.00
95693 Equal-System Maintenance 15,954,00
95699 BS&A Master Appraisal Sup/Maint 44 620.50
Equalization - Total
$2,348.50
$123.347.60
91500 FM - System Support NSO
Facilities Mgmt - Total $0.00
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - FIRST QUARTER, 2007
483 CTS-FD-JUDICIAL SUPPORT-ADM 24009 SQL Sew Supp - CTS-Jud Sup Mm 3.35% $1.888.28
95193 CTS-FD-Judicial Suport-Acm 2,043.00
CTS-FD-Judicial Suport-Aam - Total $3,929.28
484 CTS-FD-JUVENILE REFEREES 95191 CTS-FD-Admin-Juvenile Referees $0.00
CTS-FD-Juvenile Referees - Total $0.00
$0.00
499 CTS-GJ-ASSIGNMENT 95180 CTS-GJ-Assignment $0.00
CTS-GJ-Assignment - Total $0,00
$3,416.00
496 CTS - GJ 95208 CTS - DW Maintenance $0.00
CTS - GJ - Total $0,00
$34.429.00
500 CTS-GJ-MEDIATION 95181 CTS-GJ-Mediation $8,534.20
CTS-GJ-Mediation - Total $8,534.20
474 CTS-FD-JUVENILE SUPPORT 95474 CTS-FD-Admin-JuvenHe Support $0.00
CTS-FD-Juvenile Support - Total
420 CTS - GJ - FAMILY SUPPORT 95195 Cir Crt Admin $3,416,00
Courts - GJ - Family Support-Total
498 CTS-GEN JURIS-JUDICIAL SUPPT 95179 CTS -Gen Juris-Judicial Suppt $34,429.00
CTS -Gen Juris-Judicial Suppt - Total
493 CTS-JUDICIAL ADMIN 13002 CTS-eFiling - 50% 52.929,50
95174 CTS-Judicial Aanin 122.00
CTS-Judicial Admin - Total $3,051.50
730 DRAIN COMMISSIONER
900 EMERGENCY RESPONSE & PREPAREDNESS
740 EQUALIZATION
755 FACILITIES MANAGEMENT
660 FISCAL SERVICES AMIN
28009 Drain Administration
28011 Drain Commissioner Application
36620 GIS Implementation Support Drain
36621 OCDC Application - HniV Support
95669 Water & Sewer Accounting
Drain Commissioner - Total
23001 Oracle Support - Fiscal Serv - 11,2%
23013 Oracle Support - HR-Acctg/Budget - 16.3%
24006 SQL Sew Supp - HR-Acotg - 2.7%
24008 SQL Sew Supp - Budget - 1.3%
44021 FS-System/Customer Support
44022 FS-System Maintenance
44023 FS-System Enhancements
44024 FS-New Development
44077 BUD-System Maintenance
$9.860.25
14.350.20
1,520.29
731.99
35.408.00
66.203.00
0.00
0.00
0.00
Prepared by Intonrtatton Technology, 1412007 151 Qtr 2007.xls
$275.868.37
44079 FS - DW Support
44081 FS - OW Maintenance
96001 Human Res-Acct 40%
96003 Human Res.-Budget 20%
Fiscal Services Admin - Total
2,287.50
0.00
97,004.76
46.50238
$0.00
0.00
90,00
44026 PUR-System/Customer Support
44027 PUR-System Maintenance
Purchasing - Total
690 PURCHASING
$0.00
8.146 00
0.00
$8,146.00
1st Otr 2007.xls
• INFORMATION TECHNOLOGY RESERVE FUND -
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER, 2007
840 HEALTH DIVISION 20002 IDMS Support - CHAMPS - 20% $317.20
36525 GIS Implementation Support Health 4,328.00
37025 CHAMPS - P.O.P. 2,640.60
96842 Health Admin 675.00
Health-Total $7,960.80
843 HEALTH - ENVIRONMENTAL 23005 Oracle Support - EH Projects - 5.6% $4.930.13
37002 Environmental 0.00
84200 EH - Projects 262,501,25
84300 Ehealth Program 30 354.00
Health-Environmental - Total $297,785.38
680 HUMAN RESOURCES 23014 Oracle Support-HP/Personnel- 10.9% 59.596.14
24007 SQL Server Suppport-HR/Personnel - 2.7% 1,520.29
44042 PER-Systems Maintenance 2,280.00
44044 PER-New Development 9,758.00
95556 Personnel User Supt 629.00
96002 Human Res-Personnel 40% 97,004.76
Human Resources - Total $120,788.19
907 LIBRARY - ADMIN 91405 Library Board $1,098.00
Library Admin - Total $1,098,00
641 MATERIALS MGMT-GEN SUPPORT srFtv 95440 Materials Management $0.00
Materials Mgmt-Gen Fund - Total $0.00
872 MEDICAL EXAMINER 24002 SQL Server Support - Medical Exam - 6.7% $3,772.57
87202 Medical Examiner - Customer Support 23 498,50
Medical Examiner - Total $27,271.07
710 MSU EXTENSION - OAKLAND 95676 MSU Ext Equipment Maintenance $1,403.00
MSU Extension - Oakland - Total $1,403.00
775 PLANNING & ECONOMIC DEVELOPMENT 95786 PEDS - OW Support $671.00
95787 PEDS - DW Maintenance 1,220.00
PEDS - Total 51,891.00
512 PROB-ESTATES/MENTL HLTH IMAGE 95207 Prob-Est/Mntl Hlth Image $244.00
Prob-Est/Mntl Hlth Image - Total $244.00
509 PROB-JUDICIAL ADMIN 95165 PC-Judicial Admin-Admin Serv 50.00
Prob-Judicial Admin - Total $0.00
510 PROB-ESTATES/MENTL HLTH SUPPORT 24010 SQL Serv Supp-PCT-Est/Mental - 3.35% $1,886.28
92198 Prob-Est/Mntl Hlth Support 3,837.00
Prob-Est/Mnti Hlth Support - Total $5,723.28
481 PROBATE-FD JUDICIAL 95168 Prob-FD Judicial $0.00
Prob-FD Judicial - Total $0.00
479 PROB-FD-JUDICIAL SUPPORT 95188 PROB-FD Judicial Support $0,00
PROB-FD Judicial Support - Total $0.00
145 PROSECUTOR - GENERAL PROSECUTION 95622 Prosecutor/Executive $9,071,00
97001 Prosecutor Data Proc 3,401.00
Prosecutor - Total $12,472.00
637 RECORDS RETENTION
Prepared by Inforrnatlon Technology. 114/2007
44052 Rec-System Maintenance
44054 Rec-New Development
95636 Mail Room
Records Retention - Total
$430.00
12,439.00
3,387.00
$2465.07
94,091.00
6,255.50
3.909.50
$4,930.10
4,543.50
$16,256.00
$106,721.07
$9,473.60
$16,566,13
650 REIMBURSEMENT
195 SHERIFF
191 SHERIFF CLEMIS
445 SUPPORT SERVICES
600 TREASURER
910 VETERANS SERVICES
540 5211 DISTRICT COURT. NOVI $325.63
5.07
§,640.75
$6,971.45
$6,971.40
$325.61
5.04
6,640.75
530 5214 DISTRICT COURT - TROY 14005 CTS-DW Support-52/4 - 6.25%
15005 CTS-DW Maint 52/4 - 6.25%
95530 DC Suprt- 52/4 - 25%
52/4 District Court - Total
055 CLEMIS $317.20
33,671.59
0.00
20003 IDMS Support - 5.6%
24004 SQL Server Support - 59.8%
95409 CRISNET/CLEIvi IS LRIVI
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER, 2007
95469 Reimbursement Division
95470 Reimbursement System
95542 Reimburse User Support
Reimbursement - Total
23009 Oracle Suppport - OCSD/CTS Grim Whse - 2.8%
97163 Sheriff
97165 Sheriff-OW Support
97166 Sheriff-OW Maintenance
Sheriff - Total
23015 Oracle Suppport - Sheriff / CLEMIS - 5.6%
96163 Sheriff - CLEMIS
Sheriff - CLEMIS - Total
23002 Oracle Support - Supp Serv - 5.6% $4.930.13
44500 Support Services 11 636.00
Support Services - Total
$4,930.13
122.00
12.977.50
878.00
7,185.00
44,649.00
16,438.00
880.00
2,196.00
13,016.00
0,00
23006 Oracle Support - Del Tax - 5.6%
36515 GIS Implementation Support-Treasurer
36516 Treasurer Application - H/W Support
44061 Tre-Systern/Customer Support
44062 Tre-System Maintenance
44064 Tre-New Development
44080 Tre-DW Support
44082 Ire-OW Maintenance
95008 Del Tax On Line
95303 Del Tax System Maintenance
95561 User Support/Del Tax
Treasurer - Total
14002 CTS-DW Sopport-52/1 - 6.25%
15002 CTS-DW Malt 52/1 - 6.25%
95527 DC Suprt- 52/1 - 25%
52/1 District Court - Total
$103,251.63
95651 Veterans Gust Support $122.00
Veterans Services - Total $12200
541 52/1 DISTRICT COURT • NOVI - PROBATION 94542 DC Probation Support - 52/1 - 25% $0.00
5211 District Court - Probation - Total $0.00
550 52/2 DISTRICT COURT • CLARKSTON 14003 CTS-DW Support-52/2 - 6.25%
15003 CTS•DW Malt 52/2 - 6.25%
95528 DC Suprt- 5212- 25%
52/2 District Court - Total
$325.63
5.07
§.640.75
$6,971.45
551 52/2 DISTRICT COURT - CLARKSTON - PROBATIC 94552 DC Probation Support - 5212 - 25% )0.00
52/2 District Court - Probation - Total
560 52/3 DISTRICT COURT • ROCHESTER 14004 CTS-DW Support-52/3 - 6.25% $325.63
15004 CTS-DW Mont 52/3 - 6.25% 5.07
95529 DC Suprt - 52/3 - 25% 6,640.75
52/3 District Court - Total $6,971.45
561 52/3 DISTRICT COURT - ROCHESTER - PROBATIr 94562 DC Probation Support - 52/3 - 25% $0.00
52/3 District Court - Probation - Total $0.00
531 5214 DISTRICT COURT • TROY - PROBATION 94532 DC Probation Support - 52/4 - 25% $0.00
5214 District Court - Probation - Total $0.00
Gust # DIRECT FUNDS
Prepared by' Information Technology 11412007 15t Otr 2007.xls
$430.50
3,772.57
$4,203.07
$671.00
3,084.00
$3.755.00
$4,930.13
5,808.00
$11,738.13
$0.00 758 FM - JAIL MGMT REPLACEMENT
655 GARAGE
380 HEALTH IMMUNIZATION - GRANT
662 MAJOR DEPT SUPP PROJ FUND
870 MEDICAL CARE FACILITY
$3,714.00
0.00
248 MEDICAL CARE FACILITY - PHARMACY 98248 MCF - Pharmacy
MCF - Pharmacy - Total
$0.00
$0.00
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - FIRST QUARTER, 2007
056 CLEMIS FUND 63500
096 CLEMIS 2005 IBIS GRANT
661 COMMUN & HOME IMPROVEMENT
719 CLERK/ROD AUTOMATION FUND
471 CTS-FOC-EXP-CS ENFORC-IMAGE
470 CTS-FOC-EXP-FAM COUNSELING
507 CTS-FOC EXP-CS ENFORCEMENT
210 FIRE RECORDS MANAGEMENT SYSTEM
95430 CLEMIS Maintenance 3.853.00
95431 CLEMIS Enhancements 0.00
98003 CLEMIS User Support 30,564.040
CLEMIS - Total $68,405 79
63500 CLEMIS Fund $0,00
CLEMIS 63500 Fund - Total
63596 2005 Federal Approp - IBIS Project $366.00
CLEMIS 2005 IBIS Grant - Total $366.00
66103 Comm Day User Support $671.00
Commun & Home Improvement - Total $671.00
95719 Register of Deeds Automation Nji_o
Clerk/ROD Automation Fund - Total $0.00
92194 CTS-FOC-Exp-CS Enf-Image $19,496.25
CTS-FOC Exp-CS Enf-Image - Total $19,496.25
92195 CTS-FOC-Exp-Fam Counseling $0.00
CTS-FOC-Exp-Fam Counseling - Total $0.00
92193 CTS-FOC Exp-CD Enforc-Dev $6,606.00
CTS-FOC Exp-CD Enforc-Dev - Total $6,606.00
21010 Fire Records Mgmt Fund 531
24001 SQL Server Support - FRMS
Fire Records Mgmt - Total
750 FM&O
757 FM-WK RELEASE/JAIL MGMTNIDEO CONF
21001 FM&O
75503 FM&O Development
FM&O - Total
23004 Oracle Support - Oak Video - 5.6%
75700 Fac Mgmt - Video Arraignments
FM-Wk Rel/Jail MgmtNideo Gonf - Total
75800 FM - Jail Mgmt Replacement
FM - Jail Mgmt Replacement - Total
44057 GAR - Systems Maintenance
44058 GAR - Systems Enhancements
Garage - Total
38000 Health - Immunization
Health - Immunization - Total
66200 e-Financial-Peoplesoft Implementation $4.758.00
Major Dept Supp Proj Fund - Total
24003 SQL Server Support - MCF - 6.7%
98873 MCF - Support
MCF - Total
$3.772.57
81.00
$0.00
$3,714.00
$0.00
$4,758.00
$3.853.57
653 O.C. INTERNATIONAL AIRPORT 36540 GIS Implementation Support-Aviation $1.609.00
65301 Airport User Support 183,00
O.C. International Airport-Total
770 PARKS AND RECREATION 95419 PRADM-Administration $366.00
Parks & Recreation - Total
790 RADIO COMMUNICATION 79001 Radio Communications $0.00
Radio Communications - Total
695 RISK MANAGEMENT 44036 RSK-System/Customer Support $0.00
95695 Risk Management 0.00
Risk Management - Total
$1,792.00
$366.00
$0.00
$0.00
Prepared by Wort-nation Technotogy. 1/4/2007 151 Qtr 2507 xis
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER, 2007
601 TREASURER - DTRF 18010 Treasurer's Office System $10,844.50
Treasurer DTRF - Total $10,844.50
602 TREASURER-100% TAX PAYMT FUND 99002 Treasurer's Office $386.00
Treasurer 100% Tax Pmt Fund - Total $366.00
656 WATER & SEWER ACCTG 23011 °rave Supp - Water & Sewer Acctg - 5.6% $4,930.13
95669 Water & Sewer Accro 3,910.00
Water & Sewer Accfg - Total $8,840.13
850 WORKFORCE DEVELOPMENT 95670 Workforce Development 305.02
Workforce Development - Total $305.00
Preparea by Information TechnoiNy. 1/412007 1st 0112007.xls
Resolution #07075 April 5, 2007
The Chairperson referred the resolution to the Finance Committee. There were no objections.
FISCAL NOTE (MISC. #07075) April 26, 2007
BY: FINANCE COMMITTEE, MIKE ROGERS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FIRST QUARTER 2007
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 2007 Development cost to benefiting
departments.
2. The first quarter data processing development charges are
$1,539,657.88; imaging development charges are $179,755.88 for
General Fund/General Purpose departments; direct charges to
Special Revenue and Proprietary fund departments are
$130,584.19, non-governmental imaging development are
$19,496.25, and charges to non-county agencies are $1,344.00.
3. The respective departmental Fiscal Year 2007 budgets are to be
amended as specified in the attached detail schedule.
FINANCE COMMITTEE
FINANCE COMMITTEE
Motion carried unanimously on a roll call vote with Coulter absent.
664isu
'On, County Clerk
Resolution #07075 April 26, 2007
Moved by Middleton supported by Gershenson the resolutions (with fiscal notes attached) on the
amended Consent Agenda, be adopted (with accompanying reports being accepted).
AYES: Burns, Coleman, Coulter, Crawford, Douglas, Gershenson, Gingell, Gosselin, Gregory,
Greimel, Hatchett, Jacobsen, KowaII, Long, Middleton, Nash, Potter, Potts, Rogers, Scott,
Spector, Suarez, Woodward, Zack, Bullard. (25)
NAYS: None. (0)
A sufficient majority having voted in favor, the resolutions (with fiscal notes attached) on the amended
Consent Agenda, were adopted (with accompanying reports being accepted).
I HEREBY APPROVE THE FOREGOING RESOLUTION
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 April 26, 2007, 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 26th day of April. 2007.