HomeMy WebLinkAboutResolutions - 2012.09.05 - 20525September 5, 2012
MISCELLANEOUS RESOLUTION 1 #12 -.3 - 8
BY: FINANCE COMMITTEE, TOM MIDDLETON, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - THIRD QUARTER 2012
DEVELOPMENT APPROPRIATION TRANSFER
TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS
Chairperson, Ladies and Gentlemen:
WHEREAS all 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
2012 development charges to be $1,102,045.63 for the General Fund/General Purpose County
departments; and
WHEREAS direct charges to Special Revenue and Proprietary fund departments are
S174,218.00 and non-county agencies are $15,759.50 for the Third Quarter 2012; 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 2012 Development Report and approves the
Third Quarter appropriation transfer as specified on the attached schedule.
BE IT FURTHER RESOLVED that the respective departmental Fiscal Year 2012 budgets
are to be amended as specified in the attached detail schedule.
Finance Committee Vote:
Motion carried unanimously on a roll call vote with Taub absent
CUST # FUND # ACCOUNT # DIVISION
1st Qtr 2012
Oct - Dec
2nd Qtr 2012
Jan - Mar
3rd Qtr 2012
Apr - Jun Y.T.D.
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
3RD QUARTER 2012
GOVERNMENTAL FUNDS
General Fund [1011
540 101 10100-3020201-121020-773630
550 101 10100-3020301-121020-773630
560 101 10100-3020401-121020-773630
530 101 10100-3020501-121020-773630
630 101 10100-1070801-114000-773630
620 101 10100-1010201-181010-773630
005 101 10100-5010101-180010-773630
725 101 10100-2010201-180000-773630
722 101 10100-2010210-125000-773630
440 101 10100-2010301-185010-773630
410 101 10100-2010501-125000-773630
724 101 10100-2010210-125000-773630
720 101 10100-2010401-172190-773630
723 101 10100-2010205-132300-773630
522 101 10100-1070401-113000-773630
430 101 10100-1010501-181020-773630
015 101 10100-1010101-181000-773630
495 101 10100-3010201-121110-773630
483 101 10100-3010403-121100-773630
474 101 10100-3010401-121240-773630
498 101 10100-3010301-121130-773630
502 101 10100-3010301-121180-773630
493 101 10100-3010101-121100-773630
785 101 10100-1090101-171000-773630
004 101 10100-1010101-196030-773630
740 101 10100-1020501-173010-773630
660 101 10100-1020601-182020-773630
900 101 10100-1010115-115090-773630
680 101 10100-1050401-183010-773630
907 101 10100-5010303-165040-773630
565 101 10100-1090108-171030-773630
872 101 10100-1070601-132030-773630
710 101 10100-1070501-174000-773630
206 101 10100-4030901-110040-773630
775 101 10100-1090201-171000-773630
480 101 10100-3040403-121080-773630
512 101 10100-3040403-124010-773630
510 101 10100-3040403-124010-773630
145 101 10100-4010101-122050-773630
650 101 10100-1020650-126020-773630
52/1 - District Court
52/2 - District Court
52/3 - District Court
52/4 - District Court
Animal Control
Auditing Division
Bd of Commissioners
Clerk/Reg - Admin
Clerk.Reg - EDIVIS (Imaging)
Clerk/Reg - Elections
Clerk/Reg - Jury Commission
Clerk/Reg - Legal Records
Clerk/Reg - Register of Deeds
Clerk/Reg - Vital Statistics
Community Corrections Admin
Corporation Counsel
County Executive
Courts-Business Division
Courts-ED-Judicial Support-Admin
Courts-ED-Juvenile Support
Courts-GJ-Judicial Support
Courts-GJ-Jury Operations
Courts - Judical / Administration
Economic Development & Community Affairs
Election Redistricting
Equalization Division
Fiscal Services Admin
Homeland Security
Human Resources
Library - Library Admin
Marketing & Communcations
Medical Examiner
MSU Extension - Oakland
OCSD - LE Support Serv Admin
Planning & Economic Development
Probate-Estates/Mental Health Admin
Probate-Estates/Mental Health - EDMS (Imaging)
Probate-Estates/Mental Health Support
Prosecuting Attorney - General Prosecution
Reimbursement Division
$4,572.65 $6,023.47 $16,081.31
$4,572.65 $6,023.47 $16,081.31
$4,572.65 $6,023.47 $16,081.31
$4,572.55 $6,023.34 $16,081.07
$21,980.72 $39,130.61 $45,199.36
$0.00 $0.00 $3,782.00
$14,430.50 $61.00 $1,220.00
$1,626.00 $5,118.00 $4,780.00
$0.00 $0.00 $1,871.68
$2,297.00 $1,649.75 $1,830.00
$122.00 $0.00 $122.00
$14,588.00 $15,636.00 $14,560.50
$833.72 $1,358.11 $3,239.11
$3,409.47 $6,838.61 $7,077.11
$44,952.91 $37,078.71 $32,410.42
$0.00 $183.00 $61.00
$0.00 $0.00 $61.00
$515.00 $668.44 $546.35
$681.22 $870.11 $1,060.61
$0.00 $1,856.00 $0.00
$31,996.00 $33,046.00 $42,510.25
$1,029.94 $1,214.85 $1,092.81
$2,561.30 $1,560.86 $1,637.72
$64,546.75 $75,144.50 $128,831.25
$152.50 $0.00 $1,995.75
$91,921.26 $71,686.19 $79,596.32
$50,090.61 $58,453.37 $59,026.66
$557.00 $529.75 $2,262.50
$25,237.30 $24,760.01 $26,273.90
$345.00 $244.00 $549.00
$0.00 $0.00 $9,310.00
$6,656.72 $3,922.11 $4,350.11
$122.00 $122.00 $162.00
$0.00 $0.00 $0.00
$0.00 $0.00 $2,217.00
$0.00 $0.00 $2,958.50
$0.00 $0.00 $1,637.72
$11,898.47 $4,656.11 $4,807.61
$33,976.47 $34,972.86 $19,177.11
$4,781.25 $3,611.75 $27,963.50
$26,677.43
$26,677.43
$26,677.43
$26,676.96
$106,310.69
$3.782.00
$15.711.50
$11,524.00
81 ,871.68
$5,776.75
$244.00
$44,784.50
$5,430.94
$17,325.19
$114,442.04
$244.00
$61.00
$1,729.79
$2,611.94
$1,856.00
$107,552.25
$3,337.60
$5,759.88
$268,522.50
$2,148.25
$243,203.77
$167,570.64
$3,349.25
$76,271.21
$1,138.00
$9,310.00
$14,928.94
$406.00
$0.00
$2,217.00
$2,958.50
$1,637.72
$21,362.19
$88,126.44
$36,356.50
Prepared by; Information Technology; 7/31/2012
CUST # FUND #
195 101
191 101
445 101
600 101
910 101
730 101
ACCOUNT #
10100-4030301-112590-773630
10100-4030601-110000-773630
10100-1030803-184025-773630
10100-7010101-186040-773630
10100-1070301-132050-773630
10100-6010101-155010-773630
2nd Qtr 2012
Jan - Mar
$98,925.94
$18,550.85
$4,332.39
$63,940.91
$183.00
$58,533.86
$692,933.40
63600-1080101-152000-631365
GOVERNMENTAL IMAGING
722 101 10100-2010210-125000-773639
512 101 1 0100-3040403-1 24010-773639
63600-1080101-152000-630903
$1,783.84
$1,560.86
NON-GOVERNMENTAL
DIRECT CHARGES
669
652
055
056
659
471
507
210
$41,571.75 $89,436.75 $189,889.50
$116,122.51 $115,996.28 $344,515.68
$157,694.26 $205,433.03 $534,405.18
$23,110.00 $10,739.50 5_48,490.25
$23,110.00 $10,739.50 $48,490.25
$873,737.66 $1,102,045.63 g;2 950,959.84
$3,344.70 $0.00 $8,833.20
$877,082.36 $1,102,045.63 $2,959,793.04
$0.00 $0.00 $0.00
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
3RD QUARTER 2012
Health Fund 12211
840 221 20221-1060201-133150-773630
843 221 20221-1 060220-1 34390-773630
Juvenile Maintenance Fund 12931
665 293 20293-1060501-112090-773630
10100-9090101-196030-773630
$7,952.50
$0.00
$20,171.24
$4,331.00
$78,291.00
$0.00
$24,862.25
$870.11
CAMS/CVT Data Conversion
CAMS/FM° (IT Implementation)
CLEM1S
CLEM1S FUND 63500
Collaborative Asset Mgt Sys (CAMS)
Courts-FOC Exp-CS Enforcement - EDMS (Imaging)
Courts-FOC Exp-CS Enforcement
Fire Records Management System
DIVISION
Sheriff
Sheriff - CLEMIS
Support Services
Treasurer
Veterans Services
Water Resource Commissioner
Sub-Total Fund 101
Health
Health Environmental
Sub-Total Fund 221
Children's Village
Sub-Total Fund 293
DEVELOPMENT FOR GOVERNMENTAL FUND
APPROPRIATION
Clerk/Reg Image
Probate-Estates/Mental Health Image
TOTAL GOVERNMENTAL IMAGING
DEVELOPMENT APPROPRIATION
SUB-TOTAL GOVERNMENTAL / IMAGING
DEVELOPMENT APPROPRIATION:
Information Technology Development
TOTAL GOVERNMENTAL:
1st Qtr 2012
Oct - Dec
$131,899.00
$6,885.94
$2,798.14
$154,772.50
$0.00
$43,302.72
$789,257.91
$58,881.00
$112,396.89
$171,277.89
$14,640.75
$14,640.75
$975,176.55
$2,927.20
$2,561.30
$5,488.50
$980,665.05
$0.00
$9,338.25
$0.00
$12,307.00
$8,601.00
$144,901.50
$0.00
$11,748.25
$681.22
3rd Qtr 2012
Apr-Jun Y.T.D.
$102,515.85 $333,340.79
$12,359.31 $37,796.10
$7,542.81 $14,673.34
$90,631.17 $309,344.58
$61.00 $244.00
$74,257.11 $176,093.69
$885,873,10 $2,368,064.41
$0.00 $4.711.04
$0.00 $4,122.16
$11,781.50 $:29,072.25
$0.00 $0.00
$28,274.50 $60,752.74
$5,612.00 $18,544.00
$57,371.00 $280,563.50
$1,637.72 $1,637.72
$11,860.25 $48,470.75
$1,060.61 $2,611.94
Prepared by; Information Technology; 713112012
GUST # FUND #
750
841
653
770
791
656
850
734
670
745
728
737
671
738
ACCOUNT #
63600-1080101-152000-631302
NON-GOVERNMENTAL IMAGING
63600-1080101-15200-630903
471
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
3RD QUARTER 2012
NON-COUNTY AGENCIES
63600-1080101-152000-635017
DIVISION
FM&O
Health - H1N1 Grant
D.C. Intnl Airport
Parks and Recreation - Administration
Radio Communications - E911
Water Resources Accounting
Workforce Dev Division
WRC - AMR Support
WRC Acctg - Crowder Prjct
WRC - COSDA Meter Replacement
WRC - CO SOS SewMet
VVRC - Data Application Pilot Poject
VVRC - Infrastructure Op Ar
VVRC - SCADA Engineering Assessment
SUB-TOTAL DIRECT CHARGES FOR DEVELOPMENT
Courts-FOC Exp-CS Enforcement Image
TOTAL NON-GOVERNMENTAL IMAGING
DEVELOPMENT APPROPRIATION
TOTAL COUNTY DEVELOPMENT CHARGES
Non-County Agencies
TOTAL DEVELOPMENT CHARGES
1st Qtr 2012
Oct - Dec
$3,092.22
$0.00
$1,376.00
$30,169.50
$19,235.50
$7,697.94
$0.00
$1,092.00
$305.00
$0.00
$0.00
81.494.50
$0.00
$1.311.50
$253,351.38
$2,561.30
$2,561.30
$1,236,577.73
$9,792.50
$1,246,370.23
2nd Qtr 2012
Jan - Mar
$4,265.11
$122.00
$2,809.00
$25,591.75
$0.00
$8,005.60
$0.00
$0.00
$610.00
$3,850.50
$0.00
$183.00
$0.00
$2,104.50
$1134,019.56
$1,560.86
$1,560.86
$1,062,662.78
$8,667.00
$1,071,329.78
3rd Qtr 2012
Apr - Jun
$12,999.61 $20,356.94
$0.00
$122.00 $4,307.00
$15,233.00 $70,994.25
$0.00 $19,235.50
$6,305.56 $22,009.10
$936.00 $936.00
$0.00 $1,092.00
$661.50 $1,576.50
$8,150.00 $12,000.50
$342.00 $342.00
$1,528.50 $3,206.00
$7,527.75 $7,527.75
$2,936.50 $6,352.50
$174,218.00 16:11,588.94
$0.00 $4,122.16
$0.00 $4,122.16
$1,276,263.63 1;3,575,504.14
$15,759.50 $34,219.00
$1,292,023.13 $3,61)9,723.14
Prepared by; Information Technology: 7131/2012
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT SUPPORT DETAIL - THIRD QUARTER 2012
Gust # GOVERNMENTAL FUNDS
630 ANIMAL CONTROL 24017 SQL Server Supp - Animal Control $1,060.61
95628 Web License Registration 18,556.75
95682 Dog System 25,582.00
Animal Control-Total
620 AUDITING DIVISION 95468 Auditing - Customer Support $3,782.00
Auditing Division - Total
005 BD OF COMMISSIONERS 91404 BOC - Customer Support $1,220.00
Bd of Commissioners - Total
665 CHILDRENS VILLAGE 95665 Childrens Village $10,739.50
Childrens Village - Total
725 CLERK/REG - ADMIN 72500 Clerk - Admin $4,780.00
Clerk/Reg - Admin - Total
440 CLERK/REG - ELECTIONS DIVISION 95443 Elections $1,830.00
Clerk/Reg - Elections Division - Total
720 CLERK! REGISTER OF DEEDS 24003 SQL Server Supp - ROD 3.5% $1,060.61
36510 GIS Implementation Support $366.00
36511 ROD Application - KW Support $1,324.50
95493 ROD System Maintenance $0.00
95498 Clerk/Reg - ROD 488.00
Clerk/Reg of Deeds - Total
722 CLERK/REG - EDMS (IMAGING) 95158 Clerk/Reg - EDMS Support/Maintneance/Upgrades $1,871.68
Clerk/Reg - EDMS (Imaging) - Total
410 CLERK/REG - JURY COMMISSION 95512 Clerk/Reg - Jury Commission $122.00
Clerk/Reg - Jury Commission - Total
724 CLERK/REG - LEGAL RECORDS 95189 Circuit Court System S14,560.50
Clerk/Reg - Legal Records - Total
723 CLERK - VITAL STATISTICS 24015 SQL Server Supp - Vital Stats 3.5% $1,060.61
95161
Clerk.Reg - Vital Statistics
Clerk - Vital Statistics - Total
6,016.50
$45,199.36
$3,782.00
$1,220.00
$10,739.50
$4,780.00
$1,830.00
$3,239.11
$1,871.68
$122.00
$14,560.50
$7,077.11
Prepared by; Information Technology; 7/31/2012
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2012
522 COMMUNITY CORRECTIONS-ADMIN (CO) 23003 Oracle Support-Comm Corr - 5.2% $1,092.81
24012 SQL Server Supp - Community Corr 3.5% 1,060.61
52200 Comm Corr-Admin (County) 29,769.00
52201 Comm Corr - DW Support 488.00
Community Corrections - Total
430 CORPORATION COUNSEL 95501 Corporation Counsel $61.00
Corporation Counsel - Total
015 COUNTY EXECUTIVE 95656 County Executive Support $61.00
County Executive - Total
495 CTS-BUSINESS DIVISION 12002 COT-Courts/Criminal $0.00
23010 Oracle Support-CCT/CTS Crim VVhse 2.6% $546.35
CTS-Business Division - Total
483 CTS-FD-JUDICIAL SUPPORT-ADM 24009 SQL Serv Supp - CTS-Jud Sup Adm - 3.5% $1,060.61
CTS-FD-Judicial Support-Adm - Total
474 CTS-FD-JUVENILE SUPPORT 95474 CTS-FD-Admin-Juvenile $0.00
CTS-FD-Admin-Juvenile Total
498 CTS-GEN JURIS-JUDICIAL SUPPT 95179 CTS-Gen Juris-Judicial Suppt $42,510.25
CTS-Gen Juris-Judicial Suppt - Total
502 CTS-GJ-JURY OPERATIONS 23008 Oracle Support-CTS-GJ-Jury Operations §:1,092.81
CTS-GJ-Jury Operations - Total
493 CTS-JUDICIAL ADMIN 95174 CTS-Judicial Admin $1,637.72
CTS-Judicial Admin - Total
$32,410.42
$61.00
$61.00
$546.35
$1,060.61
$0.00
$42,510.25
$1,092.81
$1,637.72
785 ECONOMIC DEVELOPMENT & COMMUNITY AFFAIRS 36500 GIS Implementation Support C&E Dev $0.00
36501 CED Application - H/W Support 16,691.25
95785 Comm & Eco Developmt 112,140.00
Economic Development & Community Affairs - Total $128,831.25
004 ELECTION REDISTRICTING 40000 Election Redistricting $1,995.75
Election Redistricting - Total $1,995.75
Prepared by; Information Technology; 7/31/2012
$59,026.66
$89,436.75
$1,092.81
4,242.00
97,764.97
12,896.50
$115,996.28
$2,262.50
$26,273.90
23001 Oracle Support - Fiscal Serv - 15.6% $3,278.23
23013 Oracle Support - HR-Acctg/Budget - 5.2% 1,092.81
24006 SQL Serv Supp - HR-Acctg - 1.75% 530.37
44021 FS-System/Customer Support 18,385.75
44023 FS - System Enhancements 1,220.00
96001 Human Res - Acct 40% 23,013.00
96003 Human Res - Budget 20% 11,506.50
Fiscal Services Admin - Total
36525 GIS Implementation Support Health $0.00
95563 User Support-Health 19,404.25
96842 Health Admin 70,032.50
Health - Total
36545 GIS Implementation Support Homeland Security $142.50
36546 Homeland Security Application - HNV Support 2,120.00
Homeland Security - Total
23014 Oracle Support-HR/Personnel - 5.2% $1,092.81
24007 SQL Server Suppport-HR/Personnel - 1.75% 530.37
96002 Human Res-Personnel 40% 24,650.72
Human Resources - Total
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT ! SUPPORT DETAIL - THIRD QUARTER 2012
740 EQUALIZATION
660 FISCAL SERVICES ADMIN
840 HEALTH DIVISION
843 HEALTH - ENVIRONMENTAL
900 HOMELAND SECURITY
680 HUMAN RESOURCES
23012 Oracle Support-Equalization - 5.2%
24005 SQL Server Supp-Equalization - 10.5%
31075 Equal - Development
36505 GIS Implementation Support Equalization
36506 Equal Application - H/W Support
36601 Land System Enhancements - Equal (50%)
36701 Land System Maintenance - Equal (50%)
36801 Land System Support - Equal (50%)
95562 Equalization - DW Support
95699 BS&A Master Appraisal Sup/Maint
Equalization - Total
23005 Oracle Support - EH Projects - 5.2%
24014 SQL Server Suppt - Ehealth 14%
84200 EH - Projects
84300 Ehealth Program
Health-Environmental - Total
$1.092.81
3,181.61
3,131.75
571.50
27,134.25
7,269.64
3,601,75
6,396.76
1,108.00
26,108.25
$79,596.32
Prepared by. Information Technology; 7/31/2012
145 PROSECUTOR - GENERAL PROSECUTION
650 REIMBURSEMENT
195 SHERIFF $0.00
$546.35
13,024.00
5,908.00
83,403.50
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT SUPPORT DETAIL - THIRD QUARTER 2012
907 LIBRARY - LIBRARY ADMIN 91405 Library Board $549.00
Library - Library Admin - Total $549.00
565 MARKETING & COMMUNICATIONS 56500 Marketing & Communications $9,310.00
Marketing & Communications - Total $9,310.00
872 MEDICAL EXAMINER 24002 SQL Server Support - Medical Exam - 3.5% $1,060.61
87202 Medical Examiner - Customer Support 3,289.50
Medical Examiner - Total $4,350.11
710 MSU EXTENSION - OAKLAND 95676 MSU Exi Equipment Maintenance $162.00
MSU Extension - Oakland - Total $162.00
775 PLANNING & ECO DEVELOPMENT 95600 PEDS Cust/System Support $2,217.00
Planning & Eco Development - Total $2,217.00
480 PROB-ESTATES/MENTL HLTH-ADMIN 92197 PC-E/MH Admin Development $2,958.50
Prob-Est/Mntl Hlth-Admin - Total $2,958.50
512 PROB-ESTATES/MENTL HLTH EDMS (IMG) 95207 PC-E/MH EDMS Support & Mtce $1,637.72
Prob-Est/Mntl Hlth EDMS (ling) $1,637.72
510 PROB-ESTATES/MENTL HLTH SUPPORT 24010 SQL Serv Supp-PCT-Est/Mental - 3.5% $1,060.61
92198 Prob-Est/Mntl Hlth Support 3,747.00
Prob-EsI/Mntl Hlth Support - Total $4,807.61
24016 SQL Server Supp - Proescutors 3.5% $1,060.61
95622 Prosecutor/Executive 17,030.00
97001 Prosecutor Data Proc 1,086.50
Prosecutor - Total
95470 Reimbursement System $27,963.50
95542 Reimburse User Support 0.00
Reimbursement - Total
$19,177.11
$27,963.50
12001 OCSD-Courts/Criminal - 50%
23009 Oracle Suppport - OCSD/CTS Crim Whse - 2.6%
97163 Sheriff
97164 Sheriff - Development
97165 Sheriff-DVV Support
98164 CLEMIS-Sheriff
Sheriff - Total $102,515.85
Prepared by; Information Technology; 7/31/2012
191 SHERIFF CLEMIS
445 SUPPORT SERVICES
600 TREASURER
$12,359.31
$7,542.81
$90,631.17
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT ! SUPPORT DETAIL - THIRD QUARTER 2012
910 VETERANS SERVICES
730 WATER RESOURCE COMMISSIONER
540 52/1 DISTRICT COURT - NOVI
550 52/2 DISTRICT COURT - CLARKSTON
560 5213 DISTRICT COURT - ROCHESTER
23015 Oracle Suppport - Sheriff! CLEMIS - 5.2% $1,092.81
96163 Sheriff - CLEMIS 11,266.50
Sheriff - CLEMIS - Total
23002 Oracle Support - Supp Serv - 5.2% $1,092.81
24011 SQL Server Supp - Suppt Services 7% 2,121.00
44500 Support Services 4 ,329 .00
Support Services - Total
23006 Oracle Support - Del Tax - 5.2% $1,092.81
23016 Oracle Support - Treasurer - 10.4% 2,185.54
36516 Treasurer Application - HAN Support 5,646.00
36602 Land System Enhancements - Treas (50%) 7,269.61
36702 Land System Maintenance - Treas (50%) 3,601.75
36802 Land System Support - Trees (50%) 6,396.74
44061 Tre-System/Customer Support 11,188.72
44062 Tre-System Maintenance 3,993.00
44063 Tre-System Enhancements 3,843.00
44080 Tre-DW Support 428.00
44082 Ire-OW Maintenance 196.00
95008 Del Tax On Line 122.00
95303 Del Tax System Maintenance 488.00
95561 User Support/Del Tax 28,199.00
95615 BS&A Annual Tax Support 15,981.00
Treasurer - Total
24008 SQL Server Supp - WRC 3.5% $1,060.61
28010 WRC - Customer Support 24,469.75
28011 Water Resource Commissioner Application 10,592.50
36520 GIS Implementation Support VVRC 2,051.75
36521 WRC Application - MN Support 36,082.50
Water Resource Commissioner - Total
95527 DC Supd- 52/1 - 25% 916,081.31
52/1 District Court - Total
95528 DC Supti- 52/2 - 25% $16.081.31
52/2 District Court - Total
95529 DC Suprt - 52/3 - 25% $16,081.31
52/3 District Court - Total
$74,257.11
$16,081.31
$16,081.31
$16,081.31
95651 Veterans Customer Support $61.00
Veterans Services - Total $61.00
Prepared by; Information Technology; 7/3112012
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2012
530 52/4 DISTRICT COURT - TROY 95530 DC Suprt- 52/4 - 25% 515,081.07
52/4 District Court - Total $16,081.07
Prepared by; Information Technology; 7/3112012
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - THIRD QUARTER 2012
cust # DIRECT FUNDS
055 CLEMIS 23004 Oracle Support - OakVideo CLEMIS 5.2% $1,092.81
23018 Oracle Support - Sheriff CLEMIS 5.2% 1,092.08
24004 SQL Server Support - 24.5% 7,423.61
95430 CLEMIS Maintenance 15,372.00
95431 CLMS Enhancements 1,037.00
98003 CLEMIS User Support 2,257.00
CLEMIS - Total
056 CLEMIS FUND 63500 63500 CLEMIS Fund $5,612.00
CLEMIS 63500 Fund - Total
669 CAMS/CVT DATA CONVERSION 66901 CAMS/CVT Data Conversion $11,781.50
CAMS/CVT Data Conversion - Total
659 COLLABORATIVE ASSET MGT SYS 65901 Collabortive Asset Mgt Sys $57.371.00
Collabortive Asset Mgt Sys - Total
471 CTS-FOC-EXP-CS ENFORC-EDMS (IMG) 92194 CTS-FOC-CS ENF-EDMS Support/Maintenance/Upgrades $1,637.72
CTS-FOC Exp-CS Enforc-EDMS (lmg) - Total
507 CTS-FOC EXP-CS ENFORCEMENT 92193 CTS-FOC Exp-CD Enforc-Dev $11,860.25
CTS-FOC Exp-CD Enforc-Dev - Total
210 FIRE RECORDS MANAGEMENT SYSTEM 21010 Fire Records Mgmt Fund 531 $0.00
24001 SQL Server Support - FRMS 3.5% 1,060.61
Fire Records Management System - Total
750 FM&O 21001 Facilities Maintenance & Operations $0.00
24013 SQL Server Supp - FM&O 1,060.61
75503 FM&O Development 11,939.00
FM&O - Total
841 HEALTH - HI N1 GRANT 84100 Health - H1N1 Grant ($122.00)
Health - H1N1 Grant - Total
$28,274.50
$5.612.00
$11,781.50
$57,371.00
$1,637.72
$11,860.25
$1,060.61
$12,999.61
Prepared by; Information Technology: 7/31/2012
$0.00
$122.00
$122.00
653 O.C. INTNL AIRPORT 36540 GIS Implementation Support - Aviation
65301 Airport User Support
0.0. Into! Airport - Total
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT SUPPORT DETAIL - THIRD QUARTER 2012
770 PARKS AND RECREATION
791 RADIO COMMUNICATIONS - E911
36530 GIS Implementation Support - Parks $503.00
44066 PRADM-System/Customer Support 631.00
44068 PRADM-System Enhancements 0.00
76100 P&R Administrative Services 6,375.00
95413 PRADM-Customer Support 2,580.00
95419 PRADM-Administration 5,144.00
Parks & Recreation - Total S15,233.00
79101 Radio Communications - E911 $0.00
Radio Communications - E911 - Total $0.00
656 WATER RESOURCES ACCOUNTING 23011 Oracle Supp - Water & Sewer Acct'g - 5.2% $1,092.81
95669 Water Resources Accounting 5,212.75
Water Resources Accounting - Total
850 WORKFORCE DEV DIVISION 95670 Employment & Training $936.00
Workforce Dev Division - Total
734 WRC - AMR SUPPORT 73401 VVRC - AMR Support $0.00
WRC - AMR Support - Total
670 WRC ACCTG - CROWDER PRJCT 67000 WRC - Crowder NetBase Project 5661.50
WRC Acctg - Crowder Prject - Total
745 WRC - COSDA METER REPLACEMENT 74500 WRC - CODSA Meter Replacement $8,150.00
VVRC - CODSA Meter Replacement - Total
728 WRC - CO SDS SEWMET 72800 VVRC - C:OSDS Maintenance $342.00
WRC - CO SDS SewMet - Total
737 WRC - DATA APPLICATION PILOT PRJ 73700 WRC - Data Application Pilot Project $1,528.50
WRC - Data Application Pilot Prj - Total
671 WRC - INFRASTRUCTURE OP AR 67100 WRC -10 AR $7,527.75
WRC Infrastructure Op Ar - Total
738 WRC - SCADA ENGINEERING ASSESSMT 73800 WRC - SCADA Engineering Assesmnt $2,936.50
VVRC - SCADA Engineering Assesmt - Total
$6,305.56
5936.00
$0.00
$661.50
$8,150.00
$342.00
$1,528.50
$7,527.75
$2,936.50
Prepared by; Information Technology; 7/31/2012
4
Resolution #12218 September 5, 2012
Moved by Dwyer supported by McGillivray the resolutions (with fiscal notes attached) on the Consent
Agenda be adopted.
AYES: Covey, Crawford, Dwyer, Gershenson, Gingell, Gosselin, Hatchett, Hoffman, Jackson,
Long, Matis, McGillivray, Middleton, Nash, Nuccio, Potts, River, Runestad, Scott, Taub, Weipert,
Woodward, Zack, Bosnic. (24)
NAYS: None. (0)
A sufficient majority having voted in favor, the resolutions (with fiscal notes attached) on the Consent
Agenda were adopted.
I HEREBY APPROVE THIS RESOLUTION
CHIEF DEPUTY COUNTY EXECUTIVE
ACTING PURSUANT TO MCL 45.559A (7)
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, Bill Bullard Jr., 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
September 5, 2012, 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 5th day of September, 2012.
/LLQK 1 94.
Bill Bullard Jr., Oakland County