HomeMy WebLinkAboutResolutions - 2007.06.14 - 28438MISCELLANEOUS RESOLUTION #07133 May 24, 2007
BY: GENERAL GOVERNMENT COMMITTEE, CHRISTINE LONG, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - SECOND 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 Second Quarter 2007 data processing development charges to be
$1,158,828.69 and the imaging development charge to be $17,498.24 for
the General Fund/General Purpose County departments; and
WHEREAS direct charges to Special Revenue and Proprietary fund
departments are $279,221.72, non-governmental imaging development are
$97.60, and non-county agencies are $372.10 for the Second 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 Second Quarter 2007 Data Processing
Development Report and approves the Second 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
E_I kAa. LOT
GENERAL GOVERNMENT COMMITTEE VOTE:
Motion carried on a roll call vote with Jacobsen and Gregory absent.
DIVISION Y.T.D.
3rd Qtr
Apr - June
4th Qtr
July - Sept
lot Qtr 2nd Qtr
Oct - Dec Jan - Mar MST*, FUND # ACCOUNT #
Health Fund 12211
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
GOVERNMENTAL IMAGING
722 10100-2010210-125000-773639
512 10100-3040403-124010-773639
63600-1080101-152000-630903
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY '
2ND QUARTER 2007
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
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
910 101
GOVERNMENTAL FUNDS
General Fund 11011
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
10109-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-5010303-165040-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
10100-1070301-132050-773630
52/1 - District Court
52/1 - District Court - Probation
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 Deeds
Clerk - Vital 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-Admin
Courts-FD-Court Services-Adoptions
Courts-FD-Judicial Support
Courts-FD-Judicial Support-Admin
Courts-GJ-Assignment
Courts-GJ-Family Support
Courts-General Jurisdiction
Courts-GJ-Judicial Support
Courts-GJ-Mediation
Courts - Judical / Administration
County Executive
Drain Commissioner
Emergency Response & Prep
Equalization Division
Facilities Management
Fiscal Services - Admin
Human Resources
Library Admin
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
Veterans Services
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 GOVERNMENTAL IMAGING
DEVELOPMENT APPROPRIATION
$6,971.45 $6,815.25
$0.00 $0.00
$6,971.45 $6,815.25
$0.00 $0.00
$6,971 45 $6,815.25
$0.00 $0.00
$6,971.40 $6,815.25
$0.00 $0.00
$9,570.50 $23,686.12
$305.00 $122.00
$732.00 $0.00
$16,942.00 $801.00
$42,941.00 $3,371.00
$5,601 13 $3,326.24
$37,785.50 $47,642.12
$18,382.20 $21,764.12
$19,744.50 $0.00
$40,617.25 $9,646.50
$48,829 63 $59,555.86
$8,468.00 $2,379.00
$6,433 32 $10,986.62
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $732.00
$3,929.28 $5,299.12
$0.00 $0.00
$3,416 00 $17,373.50
$0.00 $0.00
$34,429.00 $33,567.00
$8,534.20 $0.00
$3,051.50 $24.40
$0.00 $0.00
$63,107.50 $66,816.87
$2,348.50 $1,738.50
$123,347.60 $139,139.84
$0.00 $0.00
$275,868.37 $139,904.01
$120,788.19 $38,398.80
$1,098.00 $2,964.00
$0.00 $0.00
$27,271.07 $28,032.62
$1,403 00 $0.00
$1,891.00 $976.00
$0.00 $0.00
$5,723.28 $4,601.12
$0.00 $0.00
$0.00 $0.00
$12,472.00 $16,260.12
$0.00 $0.00
$8,146.00 $8,418.00
$16,256.00 $4,392.00
$106,721.07 $98,515.62
$9,473.60 $5,160.24
$16,566.13 $16,299.48
$103,251.63 $39,227.96
$122.00 $0.00
91,233,452 70 $878,382 78
$7,960.80 $7,840.00
$297785.38 $266,468.71
$305,746.18 5274,308.71
$45900 $6,137 20
$45900 $6,137 20
$1,539,657.88 $1,158,828.69
5179.511 88 $17,449.44
$24400 $4880
$179,755.88 $17,498.24
$13,786.70
$0.00
$13,786.70
$0.00
$13,786.70
$0.00
$13,786.65
$0.00
$33,256.62
$427.00
$732.00
$17,743.00
$46,312.00
$8,927.37
$85,427.82
$40,146.32
$19,744.50
$50,263.75
$108,385.49
$10,847.00
517,419.94
$0.00
$0.00
$0.00
$0.00
$732.00
$9,228.40
$0.00
$20,789.50
$0.00
$67,996.00
58,534.20
$3,075.90
$0.00
$129,924.37
$4,087.00
$262,487.44
$0.00
$415,772.38
$159,186.99
$4,062.00
$0.00
$55,303.69
$1,403.00
$2,867.00
$0.00
$10,324.40
$0.00
$0.00
$28,732.12
$0.00
$16,564.00
$20,648D0
$205,236.69
$14,633.84
$32,865.61
$142,479.59
$122.00
$0.00 $0.00 $2,111,835.48
$15,800.80
$564,254.09
$0.00 $0.00 $580,054.89
$6.596.20
$0.00 $0.00 $6,596.20
$0.00 $0.00 $2,698,486.57
$196,961.32
$292.80
$0.00 $0.00 $197,254.12
SUB-TOTAL GOVERNMENTAL / IMAGING DEVELOPMENT APPROPRIATION:
Information Technology Development
TOTAL GOVERNMENT:
$1,719,413.76 $1,176,326.93
($1,719,413 76) ($1,176,326 93)
lig() 113,012
$0.00 $0.00 52,895,740.69
$0.00 $0.00 (52.895.740.69)
$0.00 $0.00 $0.00
10100-9090101-196030-773630
Prepared by; Information Technology: 5/14/2007 2nd Qtr 2007.xls
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT 5UMMARY
2ND QUARTER 2007
CUST # FUND # ACCOUNT # DIVISION
1st Qtr
Oct - Dec
2nd Qtr
Jan - Mar
3rd Qtr
Apr - June
4th Qtr
July - Sept Y.T.D.
NON-GOVERNMENTAL
DIRECT CHARGES
055 CLEMIS $68,405.79 $53,493.00 $121,898.79
056 CLEMIS FUND 63500 $0.00 $0.00 $0,00
096 CLEMIS 2005 IBIS Grant $36600 $2,928,00 $3,294.00
719 Clerk/ROD Automation Fund $0.00 $0.00 $0.00
661 Community & Home Improvement $671.00 $122.00 $793.00
470 Courts-FOC Exp-Family Counseling $000 $0,00 $0.00
507 Courts-FOC Exp-CS Enforcement $6,606 00 $6,143.00 $12,749.00
210 Fire Records Management System $4,203.07 52,326.62 $6,529.69
757 FM-Wk Rel/Jail Mgt/Video Conf $11,738 13 $3,697.24 $15,435.37
758 FM-Jail Mgmt Replacement $030 $0.00 $0.00
750 F M & 0 $3.755.00 $4,030,12 $7,785.12
655 Gararge $3,714 00 $0.00 $3,714.00
380 Health - Immunization Grant $0.00 $0.00 $0.00
662 Major Department Support Project Fund $4,758.00 $17,790.00 $22,548.00
870 Medical Care Facility $3.853 57 $0.00 $3,853.57
248 Medical Care Facility - Pharmacy $0.00 $0.00 $0.00
653 DC International Airport $1,792.00 $732.00 $2,524.00
770 Parks and Recreation - Administration $366.00 $1,922.00 $2,288.00
790 Radio Communications $0.00 $0.00 $0.00
695 Risk Management $0 00 $488,00 $488.00
663 ' Security Camera Project (OF) $0.00 $23,475,00 $23,475.00
601 Treasurer - DTRF $10,844.50 $157,460.00 $168,304.50
602 Treasurer -100% Tax Paymt Fund $366.00 $183.00 $549.00
656 Water & Sewer Accounting $8.840 13 $4,431.74 $13,271.87
850 Workforce Development $305.00 $0.00 $305.00
63600-1080101-152000-631302 SUB-TOTAL DIRECT CHARGES FOR DATA $130,584.19 $279,221.72 $0.00 $0.00 $409,805.91
PROCESSING DEVELOPMENT
NON-GOVERNMENTAL IMAGING
471 Courts-FOC Exp-CS Enforcement Image $19,496.25 $97.60 $19,593.85
63600-1080101-15200-630903 TOTAL NON-GOVERNMENTAL IMAGING $19,496.25 $97.60 $0.00 $0.00 $19,593.85
DEVELOPMENT APPROPRIATION
TOTAL COUNTY DEVELOPMENT CHARGES $1,869,494.20 $1,455,646.25 $0.00 $0.00 $3,325,140.45
NON-COUNTY AGENCIES
63600-1080101-152000-635017 Non-County Agencies $1,344.00 $372,10 $1,716.10
TOTAL DEVELOPMENT CHARGES 51,870,838.20 $1,456,018.35 $0.00 $0.00 $3,326,856.55
Prepared by; Information Technology; 5/14/2007 2nd Qtr 2007.xls
$0.00
$0.00
91404 BOC-Cust Supt
BOC - Total
005 BOARD OF COMMISSIONERS
$1,773.12
9,277.00
12636.00
$122.00
$6,137.20
$801.00
$3,371.00
$23,686.12
$122.00
$6,137.20
$801 00
$1,220.00
1,773.12
1,465.00
61.00
0.00
16,635.00
610.00
0.00
0.00
$21,764.12
$0.00
3,265.24
0.00
14,184.20
$17,449.44
$3,265.24
61.00
$3,326 24
$1,773.12
45.869.00
$47,642.12
$3,265.24
1,773.12
53,707.50
810.00
$59,555.86
$1,432.00
1,310.00
6,904.50
$9,646 50
$2,379.00
$91.50
5,112.75
4,149.75
1,632.62
$10,986.62
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - SECOND QUARTER, 2007
Gust # GOVERNMENTAL FUNDS
630 ANIMAL CONTROL
620 AUDITING
665 CHILDRENS VILLAGE
725 CLERK - ADMIN
440 CLERK - ELECTIONS
720 CLERK! REGISTER OF DEEDS
722 CLERK - IMAGING
410 CLERK -JURY COMMISSION
724 CLERK - LEGAL RECORDS
723 CLERK - VITAL STATISTICS
24017 SQL Server Supp - Animal Control
95628 Web License Registration
95682 Dog System
Animal Control-Total
95468 Auditing-Customer Support
Auditing - Total
95665 Childrens Village
Childrens Village - Total
72500 Clerk - Admin
Clerk - Admin - Total
95443 Elections
20004 IDMS Support - Register of Deeds
24003 SQL Server Supp - ROD 3.5%
36510 GIS Implementation Support-ROD
36511 ROD Application - H/VV Support
95493 Reg Deeds System Maintenance
95162 Clerk - DW Support
95163 Clerk - DW Maintenance
95558 User Support/ROD
95564 ROD - DW Support
Clerk/Reg of Deeds - Total
13001 Clerk - eFiling - 50%
23007 Oracle Support - Clerk Image 5.2%
65420 Clerk - Image Replace
95158 Clerk - Imaging
Clerk - Imaging - Total
23008 Orade Support - Jury Comm - 5.2%
95512 Jury Commission
Clerk -Jury Commission - Total
24015 SQI Server Supp - Circuit Ct 3.5%
95189 Circuit Court System
Clerk - Legal Records - Total
95161 Vital Stats Index $0.00
Clerk -Elections - Total $3,371.00
Clerk - Vital Statistics - Total $0.00
522 COMMUNITY CORRECTIONS-ADMIN (CO)
785 COMMUNITY & ECO DEVELOPMENT
430 CORPORATION COUNSEL
23003 Oracle Support-Comm Corr - 5.2%
24012 SQL Server Supp - Community Corr 3.5%
52200 Comm Corr-Admin (County)
52201 Comm Corr-DW Supp
Community Corrections - Total
36500 GIS Implementation Support C&E Dev
36501 CEO Application - HAN Support
95785 Comm & Eco Developmt
Community & Eco Dev - Total
95501 Corporation Counsel
Corporation Counsel - Total $2,379.00
495 CTS-BUSINESS DIVISION 12002 Circuit Ct-Courts/Criminal Warehouse 50%
14001 CTS-DW Support/Circuit Ct - 75%
15001 CTS-DW Maint/Circuit Ct - 75%
23010 Oracle Support-CCT/CTS Crim Whse 2.6%
CTS-Business Division - Total
487 CTS-FD-CT SERV-ADMIN 95196 CTS-FD-Ct Serv - Admin $0.00
CTS-FD-Ct Serv-Admin - Total $0.00
Prepared by: Information Technology; 5/14/2007 2nd Qtr 2007 xls
$1,773.12
17,925.00
29,664.25
8,641.50
8,813.00
0.00
$66,816.87
$884.50
854.00
$0.00
$1,738.50
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - SECOND QUARTER, 2007
492 CTS-FD-CT SERV-ADOPTIONS 95173 CTS-FD-Ct Serv-Adoptions $0.00
CTS-FD-Ct Serv-Adoptions - Total $0.00
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 $732.00
CTS-FD-Judicial Suport - Total $732.00
483 CTS-FD-JUDICIAL SUPPORT-ADM 24009 SQL Serv Supp - CTS-Jud Sup Adm -35% $1,773.12
95193 CTS-FD-Judicial Suport-Adm 3,526.00
CTS-FD-Judicial Suport-Adm - Total $5,299.12
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 $0.00
CTS-FD-Juvenile Support - Total $0.00
499 CTS-GJ-ASSIGNMENT 95180 CTS-GJ-Assignment $0.00
CTS-GJ-Assignment - Total $0.00
420 CTS - GJ - FAMILY SUPPORT 95195 Cir Crt Admin $17,373.50
Courts - GJ - Family Support - Total $17,373.50
496 CTS - GJ 95208 CTS - DVV Maintenance $0.00
CTS - GJ - Total $0.00
498 CTS-GEN JURIS-JUDICIAL SUPPT 95179 CTS -Gen Juris-Judicial Suppt $33,567.00
CTS -Gen Juris-Judicial Suppt - Total $33,567.00
500 CTS-GJ-MEDIATION 95181 CTS-GJ-Mediation $0.00
CTS-GJ-Mediation - Total $0.00
493 CTS-JUDICIAL ADMIN 13002 CTS-eFiling - 50% $0.00
95174 CTS-Judicial Admin 24.40
CTS-Judicial Admin - Total $24.40
730 DRAIN COMMISSIONER
900 EMERGENCY RESPONSE & PREPAREDNESS
740 EQUALIZATION
24008 SQL Server Supp - Drain 3.5%
28009 Drain Administration
28011 Drain Commissioner Application
36520 GIS Implementation Support Drain
36521 OCDC Application - H/VV Support
95669 Water & Sewer Accounting
Drain Commissioner - Total
36545 GIS Implementation Support EMS
36546 ERP Application - H/VV Support
98990 Emergency Response
ERP - Total
$139,139.84
20001 IDMS Support-Equalization - 40% $2,440.00
23012 Oracle Support-Equalization - 5.2% 3,265.24
24005 SQL Server Supp-Equalization - 10.5% 5,319.35
31075 Equal - Development 0.00
36505 GIS Implementation Support Equalization 457.50
36506 Equal Application - HM/ Support 3,492.50
36507 Equal LAMS Support/Mtce 50,051.25
95559 User SupporUEqual 9,211.00
95562 Equalization - DW Support 8,988.00
95570 Equalization - OW Maintenance 108.00
95693 Equal-System Maintenance 17,703.00
95699 BS&A Master Appraisal Sup/Maint 38 104.00
Equalization - Total
755 FACILITIES MANAGEMENT 91500 FM - System Support $0.00
Facilities Mgmt - Total $0.00
Prepared by: Information Technology 5/14/2007 2nd Qtr 2007.xls
$9,795.71
3,265.24
886.56
56,678.00
8,923.00
3,787.00
1,464.00
0.00
10,244.00
0.00
29,907.00
14.953.50
$139,904.01
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER, 2007
660 FISCAL SERVICES ADMIN 23001 Oracle Support - Fiscal Serv - 15.6%
23013 Oracle Support - HR-Acctg/Budget - 5.2%
24006 SQL Serv Supp - HR-Acctg - 1.75%
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 DIVISION 20002 I DMS Support - CHAMPS - 20% $1,220.00
36525 GIS Implementation Support Health 4,676.00
37025 CHAMPS- P.O.P. 1,404.00
96842 Health Admin 540.00
Health - Total $7,840.00
843 HEALTH - ENVIRONMENTAL 23005 Oracle Support - EH Projects - 5.2% $3,265.24
24014 SQL Server Suppt - Ehealth 14% 7,092.47
37002 Environmental 0.00
84200 EH - Projects 252,831.50
84300 Ehealth Program 3,279.50
Health-Environmental - Total $266,468.71
680 HUMAN RESOURCES 23014 Oracle Support-HR/Personnel - 5.2% $3,265.24
24007 SQL Server Suppport-HR/Personnel - 1.75% 886.56
44042 PER-Systems Maintenance 1,380.00
44044 PER-New Development 2,291.00
95556 Personnel User Supt 669.00
96002 Human Res-Personnel 40% 29 907.00
Human Resources - Total $38,398.80
907 LIBRARY - ADMIN 91405 Library Board $2,964.00
Library Admin - Total $2,964.00
641 MATERIALS MGMT-GEN SUPPORT SERV 95440 Materials Management $0.00_
Materials Mgmt-Gen Fund - Total $0.00
872 MEDICAL EXAMINER 24002 SQL Server Support - Medical Exam - 3.5% $1,773.12
87202 Medical Examiner - Customer Support 26,259.50
Medical Examiner - Total $28,032.62
710 MSU EXTENSION - OAKLAND 95676 MSU Ext Equipment Maintenance $0.00
MSU Extension - Oakland - Total $0.00
775 PLANNING & ECONOMIC DEVELOPMENT 95786 PEDS - DW Support $976.00
95787 PEDS - DW Maintenance 0.00
PEDS - Total $976.00
512 PROB-ESTATES/MENTL HLTH IMAGE 95207 Prob-Est/Mntl Hlth Image $48.80.
Prob-Est/Mntl Hlth Image - Total $48.80
509 PROB-JUDICIAL ADMIN 95165 PC-Judicial Admin-Admin Serv
Prob-Judicial Admin - Total $0.00
510 PROB-ESTATES/MENTL HLTH SUPPORT 24010 SQL Serv Supp-PCT-Est/Mental - 3.5% $1,773.12
92198 Prob-Est/Mntl Hlth Support 2,828.00
Prob-Est/Mntl Hlth Support - Total $4,601.12
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
Prepared by: Information Technology: 5/14/2007 2nd Qtr 2007.xls
$0.00
0.00
$0.00
44026 PUR-System/Customer Support
44027 PUR-System Maintenance
Purchasing - Total
690 PURCHASING
637 RECORDS RETENTION
650 REIMBURSEMENT
195 SHERIFF
191 SHERIFF - CLEMIS
445 SUPPORT SERVICES
600 TREASURER
910 VETERANS SERVICES
540 52/1 DISTRICT COURT - NOVI
541 52/1 DISTRICT COURT - NOVI - PROBATION
550 52/2 DISTRICT COURT - CLARKSTON
$0.00
8,418.00
0.00
$8,418.00
$0.00
1,708.00
2,684.00
$4,392.00
$91.50
1,632.62
80,964.00
11,746.50
4.081.00
$98,515.62
$3,265.24
1,895.00
$5,160.24
$3,265.24
3,546.24
9.488.00
$16,299.48
$3,265.24
6,530.47
579.50
16,522.75
1,272.00
9,326.50
(45,259.00)
10,028.00
24,160.50
610.00
12,192.00
0.00
$39,227.96
$0.00
$0.00
$426.06
345.81
6.043.38
$6,815.25
$0.00
$0.00
$426.06
345.81
6,043.38
$6,815.25
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER, 2007
145 PROSECUTOR - GENERAL PROSECUTION 24016 SQL Server Supp - Proescutors 3.5%
95622 Prosecutor/Executive
97001 Prosecutor Data Proc
Prosecutor - Total
$1,773.12
12,678.00
1.809.00
$16,260.12
44052 Rec-System Maintenance
44054 Rec-New Development
95636 Mail Room
Records Retention - Total
95469 Reimbursement Division
95470 Reimbursement System
95542 Reimburse User Support
Reimbursement - Total
12001 OCSD-Courts/Criminal Warehouse
23009 Oracle Suppport - OCSD/CTS Crim Whse - 2.6%
97163 Sheriff
97165 Sheriff-DW Support
97166 Sheriff-DW Maintenance
Sheriff - Total
23015 Oracle Suppport - Sheriff / CLEMIS - 5.2%
96163 Sheriff - CLEMIS
Sheriff - CLEMIS - Total
23002 Oracle Support - Supp Serv - 5.2%
24011 SQL Server Supp - Suppt Services 7%
44500 Support Services
Support Services - Total
23006 Oracle Support - Del Tax - 5.2%
23016 Oracle Support - Treasurer - 10.4%
36515 GIS Implementation Support-Treasurer
36516 Treasurer Application - HAN Support
44061 Tre-System/Customer Support
44062 Tre-System Maintenance
44064 Tre-New Development
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
95651 Veterans Gust Support
Veterans Services - Total
14002 CTS-DW Support-52/1 -6 25%
15002 CTS-DW Maint 52/1 - 6.25%
95527 DC Suprt- 52/1 - 25%
52/1 District Court - Total
94542 DC Probation Support - 52/1 - 25%
52/1 District Court - Probation - Total
14003 CTS-DW Support-52/2 - 6.25%
15003 CTS-DW Maint 52/2 -6.25%
95528 DC Suprt- 52/2 - 25%
52/2 District Court - Total
551 52/2 DISTRICT COURT - CLARKSTON - PROBATIC 94552 DC Probation Support - 52/2 - 25% $0.00
52/2 District Court - Probation - Total $0.00
Prepared by: Information Technology; 5/14/2007 2nd Qtr 2007 xis
$53,493.00
$0.00
$2,928.00
$122.00
$0.00
$97.60
$0.00
$6,143.00
$0.00
0.00
$0.00
,
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER, 2007
560 52/3 DISTRICT COURT - ROCHESTER 14004 CTS-DW Support-52/3 - 6.25%
15004 CTS-DW Maint 52/3 - 6.25%
95529 DC Suprt - 52/3 - 25%
52/3 District Court - Total
$426.06
345.81
6,043.38
$6,815.25
561 52/3 DISTRICT COURT - ROCHESTER - PROBATK 94562 DC Probation Support - 52/3 - 25%
52/3 District Court - Probation - Total $0.00
$0.00
530 62/4 DISTRICT COURT - TROY 14005 CTS-DW Support-52/4 - 6.25% $426.07
15005 CTS-DW Maint 52/4 - 6.25% 345.82
95530 DC Suprt- 52/4 - 25% 6,043.36
52/4 District Court - Total $6,815.25
531 52/4 DISTRICT COURT - TROY - PROBATION 94532 DC Probation Support - 52/4 - 25% $0.00
52/4 District Court - Probation - Total $0.00
cust # DIRECT FUNDS
055 CLEMIS 20003 IDMS Support - 5.6% $1,220.00
23018 Oracle Support - Sheriff CLEMIS 5.2% 3,265.18
24004 SQL Server Support - 24.5% 12,411.82
95409 CRISNET/CLEMIS LRM 0.00
95430 CLEMIS Maintenance 8,246.00
95431 CLEMIS Enhancements 0.00
98003 CLEMIS User Support 28 350.00
CLEMIS - Total
056 CLEMIS FUND 63500 63500 CLEMIS Fund $0.00
CLEMIS 63500 Fund - Total
096 CLEMIS 2005 IBIS GRANT 63596 2005 Federal Approp - IBIS Project $2,928.00
CLEMIS 2005 IBIS Grant - Total
661 COMMUN & HOME IMPROVEMENT 66103 Comm Dev User Support 1122.00
Commun & Home Improvement - Total
719 CLERK/ROD AUTOMATION FUND 95719 Register of Deeds Automation $0.00
Clerk/ROD Automation Fund - Total
471 CTS-FOC-EXP-CS ENFORC-IMAGE 92194 CTS-FOC-Exp-CS Enf-Image $97.60
CTS-FOC Exp-CS Enf-Image - Total
470 CTS-FOC-EXP-FAM COUNSELING 92195 CTS-FOC-Exp-Fam Counseling $0.00
CTS-FOC-Exp-Fam Counseling - Total
507 CTS-FOC EXP-CS ENFORCEMENT 92193 CTS-FOC Exp-CD Enforc-Dev $6,143.00
CTS-FOC Exp-CD Enforc-Dev - Total
210 FIRE RECORDS MANAGEMENT SYSTEM 21010 Fire Records Mgmt Fund 531 $553.50
24001 SQL Server Support - FRMS 3.5% 1 ,773.12
Fire Records Mgmt - Total $2,326.62
750 FM&O 21001 FM&O $0.00
24013 SQL Server Supp - FM&O 1,773.12
75503 FM&O Development 2,257.00
FM&O - Total
757 FM-WK RELEASE/JAIL MGMTNIDEO CONF 23004 Oracle Support - Oak Video - 5.2% $3,265.24
75700 Fac Mgmt - Video Arraignments 432.00
FM-Wk Rd/Jail Mgmt/Video Conf - Total
$4,030.12
$3,697.24
758 FM - JAIL MGMT REPLACEMENT 75800 FM - Jail Mgmt Replacement $0.00
FM - Jail Mgmt Replacement - Total $0.00
655 GARAGE
380 HEALTH IMMUNIZATION - GRANT
Prepared by: Information Technology; 5/14/2007
44057 GAR - Systems Maintenance
44058 GAR - Systems Enhancements
Garage - Total
38000 Health - Immunization $0.00
Health - Immunization - Total $0.00
2nd Qtr 2007.xls
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - SECOND QUARTER, 2007
662 MAJOR DEPT SUPP PROJ FUND 66200 e-Financial-Peoplesoft Implementation $17,790.00
Major Dept Supp Proj Fund - Total $17,790.00
870 MEDICAL CARE FACILITY 98873 MCF - Support $0.00
MCF - Total $0.00
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 0.00
O.C. International Airport-Total $732.00
770 PARKS AND RECREATION 95419 PRADM-Administration $1,922.00
Parks & Recreation - Total $1,922.00
790 RADIO COMMUNICATION 79001 Radio Communications $0.00
Radio Communications - Total $0.00
695 RISK MANAGEMENT 44036 RSK-System/Customer Support $488.00
95695 Risk Management 0.00
Risk Management - Total $488.00
603 SECURITY CAMERA PROJECT (GF) 66300 Security Camera Project (GF) $23,475.00
Security Camera Project (GF) - Total $23,475.00
601 TREASURER - DTRF 18010 Treasurer's Office System $157,460.00
Treasurer DTRF - Total $157,460.00
602 TREASURER-100% TAX PAYMT FUND 99002 Treasurer's Office $183.00
Treasurer 100% Tax Pmt Fund - Total $183.00
656 WATER & SEWER ACCTG 23011 Oracle Supp - Water & Sewer Acct'g - 5.2% $3,265.24
95669 Water & Sewer Acct'g 1,166.50
Water & Sewer Acct'g - Total $4,431.74
850 WORKFORCE DEVELOPMENT 95670 Workforce Development $0.00
Workforce Development - Total $0.00
Prepared by: Information Technology; 5/1412007 2nd Qtr 2007 xls
Resolution #07133 May 24, 2007
The Chairperson referred the resolution to the Finance Committee. There were no objections.
FISCAL NOTE (MISC. #07133) June 14, 2007
BY: FINANCE COMMITTEE, MIKE ROGERS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - SECOND 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 Second Quarter 2007 Development cost to benefiting
departments.
2. The second quarter data processing development charges are
$1,158,828.69; imaging development charges are $17,498.24 for
General Fund/General Purpose departments; direct charges to
Special Revenue and Proprietary fund departments are
$279,221.72, non-governmental imaging development are $97.60,
and charges to non-county agencies are $372.10.
3. The respective departmental Fiscal Year 2007 budgets are to be
amended as specified in the attached detail schedule.
FINANCE COMMITTEE
Motion carried unanimously on a roll call vote.
6/2 0/0
, County Clerk Rut
Resolution #07133 June 14, 2007
Moved by Rogers supported by Potts the resolutions (with fiscal notes attached) on the amended
Consent Agenda, be adopted.
AYES: Burns, Coulter, Crawford, Douglas, Gershenson, Gingell, Gosselin, Gregory, Greimel,
Hatchett, Jacobsen, KowaII, Long, Middleton, Nash, Potts, Rogers, Scott, Spector, Suarez,
Woodward, Zack, Bullard. (23)
NAYS: None. (0)
A sufficient majority having voted in favor, the resolutions (with fiscal notes attached) on the amended
Consent Agenda, were adopted.
I HEREBY APPROV THE FOREANG RESCIIITION
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 June 14, 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 14th day of June, 2007.