HomeMy WebLinkAboutResolutions - 2015.05.06 - 21822MISCELLANEOUS RESOLUTION #15121 May 6, 2015
BY: Finance Committee, Tom Middleton, Chairperson
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY — SECOND QUARTER 2015
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 Second Quarter 2015
development charges to be $1,005,233.87 for the General Fund/General Purpose County departments;
and
WHEREAS direct charges to Special Revenue and Proprietary fund departments are $307,216.25 and
non-county agencies are $19,721.50 for the Second Quarter 2015; 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 2015 Development Report and approves the Second Quarter appropriation transfer
as specified on the attached schedule.
BE IT FURTHER RESOLVED that the respective departmental Fiscal Year 2015 budgets are to be
amended as specified in the attached detail schedule.
Chairperson, on behalf of the Finance Committee, I move the adoption of the foregoing resolution.
FINANCE COMMITTEE
FINANCE COMMITTEE VOTE:
Motion carried unanimously on a roll call vote.
540
550
560
530
630
005
450
725
722
440
410
724
723
522
620
690
430
483
015
495
498
502
493
785
740
660
900
680
907
565
872
710
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
52/1 - District Court
52/2 - District Court
52/3 - District Court
52/4 - District Court
Animal Control
Bd of Commissioners
Circuit Court Probation North
Clerk/Reg - Admin
Clerk.Reg - EDMS (Imaging)
Clerk/Reg - Elections
Clerk/Reg - Jury Commission
Clerk/Reg - Legal Records
Clerk/Reg - Vital Statistics
Community Corrections Admin
Compliance Office - Auditing
Compliance Office - Purchasing
Corporation Counsel
CTS-FD-Judicial Support-ADM
County Executive
Courts-Business Division
Courts-GJ-Judicial Support
Courts-GJ-Jury Operations
Courts - Judical / Administration
Economic Development & Community Affairs
Equalization Division
Fiscal Services - Admin
Homeland Security
Human Resources
Library - Library Adm in
Marketing & Corn muncations
Medical Examiner
MSU Extension - Oakland
$2,853.22
$2,853.22
$2,853.22
$2,852.84
$48,894.02
$1,270.00
$192.00
$0.00
$5,515.84
$320.00
$123.00
$20,871.50
$24,098.02
$19,955.80
$49.50
$1,499.75
$1,636.75
$1,170.27
$653.00
$718.01
$55,721.00
$1,436.03
$11,349.61
$38,087.75
$68,776.50
$91,968.85
$5,612.00
$46,204.27
$1,076.50
$24,208.00
$12,983.77
$99.00
$3,986.23
$3,986.23
$3,986.23
$3,985.56
$138,121.58
$1,270.00
$512.00
$0.00
$13,724.96
$567.00
$123.00
$33,645.75
$39,794.33
$42,722.92
$49.50
$5,199.75
$1,924.75
$2,162.79
$653.00
$1,221.30
$141,026.80
$2,442.59
$22,552.59
$45,235.25
$136,124.96
$182,909.15
$7,495.00
$86,460.60
$1,140.50
$50,668.00
$41,613.83
$163.00
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
2ND QUARTER 2016
2nd Qtr 2015
CUST # FUND # ACCOUNT # DIVISION Jan - Mar Y.T.D.
GOVERNMENTAL FUNDS
General Fund 0011
10100-3020201-121020-773630
10100-3020301-121020-773630
10100-3020401-121020-773630
10100-3020501-121020-773630
10100-1070801-114000-773630
10100-5010101-180010-773630
10100-1070901-113270-773630
10100-2010201-180000-773630
10100-2010210-125000-773630
10100-2010301-185010-773630
10100-2010501-125000-773630
10100-2010210-125000-773630
10100-2010205-132300-773630
10100-1070401-113000-773630
10100-1010201-181010-773630
10100-1010210-182090-773630
10100-1010501-181020-773630
10100-3010403-121100-773630
10100-1010101-181000-773630
10100-3010201-121110-773630
10100-3010301-121130-773630
10100-3010301-121180-773630
10100-3010101-121100-773630
10100-1090101-171000-773630
10100-1020501-173010-773630
10100-1020601-182020-773630
10100-1060601-115090-773630
10100-1050401-183010-773630
10100-5010303-165040-773630
10100-10901 08-171 030-773630
10100-1070601-132030-773630
10100-1070501-174000-773630
2
Prepared by; Information Technology; 4/15/2015 Page 1 of 15 2nd Quarter 2015 xls
$0.00
$1,155.00
$0.00
$4,826.36
$12,352.27
$1,476.00
$18,468.27
$6,175.75
$2,335.00
$91,048.01
$2,076.03
$12,207.09
$147,399.07
($8,368.50)
$128.00
$55,012.02
$842,193.61
$1,286.00
$1,155.00
$7,087.70
$12,009.34
$25,357.83
$1,968.00
$25,751.58
$6,175.75
$5,632.50
$171,943.80
$23,534.59
$21,221.49
$282,337.48
$0.00
$256.00
$101,423.58
$1,702,609.79
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
2ND QUARTER 2015
GUST # FUND # ACCOUNT # DIVISION
2nd Qtr 2015
Jan - Mar Y.T.D.
163 101 10100-4030901-115140-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
481 101 10100-3040101-121060-773630
145 101 10100-4010101-122050-773630
637 101 10100-1030803-184020-773630
650 101 10100-1020650-126020-773630
195 101 10100-4030301-112590-773630
191 101 10100-4030601-110000-773630
445 101 10100-1030803-184025-773630
600 101 10100-7010101-186040-773630
627 101 10100-7010110-186130-773630
910 101 10100-1070301-132050-773630
730 101 10100-6010101-155010-773630
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
668 293 20293-1060501-112010-773630
63600-1080101-152000-631365
10100-9090101-196030-773630
OCSO - CLEMIS Forensic Lab IMS
Planning & Economic Development
Probate-Estates/Mental Health Admin
Probate-Estates/Mental Health - EDMS (Imaging)
Probate-Estates/Mental Health Support
Probate-Family Division Judicial
Prosecuting Attorney - General Prosecution
Records Retention
Reimbursement Division
Sheriff
Sheriff - CLEMIS
Support Services
Treasurer
Treasurers - Landsale
Veterans Services
Water Resource Commissioner
Sub-Total Fund 101
Health
Health Environmental
Sub-Total Fund 221
Children's Village
Children's Village Admin
Sub-Total Fund 293
DEVELOPMENT FOR GOVERNMENTAL FUND
APPROPRIATION
SUB-TOTAL GOVERNMENTAL DEVELOPMENT
APPROPRIATION:
Information Technology Development
Prepared by; Information Technology; 4/15/2015 Page 2 of 15
$26,613.50 $58,036.50
$101,265.26 $194,745.72
$127,878.76 $252,782.22
$35,161.50 $40,685.50
$0.00 $0.00
$35,161.50 $40,685.50
$1,005,233.87 $1,996,077.51
$1,005,233.87 $1,996,077.51
( $1 005,233.87) ($1,996,077.51)
2nd Quarter 2015.xis
$11,359.25
$0.00
$12,878.05
$0.00
$49,472.00
$1,763.27
$0.00
$0.00
$4,826.36
$16,407.25
$137,418.25
$0.00
$1,170.27
$15,293.52
$0.00
$234.00
$0.00
$593.50
$13,665.00
$444.25
$0.00
$0.00
$0.00
$21,016.75
$0.00
$5,956.53
$0.00
$1,965.01
$6,408.00
$90.00
$52,635.00
$0.00
$26,740.27
$183.00
$95,322.00
$3,141.08
$0.00
$0.00
$12,009.34
$27,831.50
$223,632.50
$0.00
$2,162.83
$29,573.58
$0.00
$783.00
$0.00
$767.50
$22,876.00
$709.75
$946.00
$134.00
$61.00
$21,016.75
$0.00
$8,415.59
$0.00
$1,965.01
$6,408.00
$330.00
4
2nd Quarter 2015.xls
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
2ND QUARTER 2015
CUST # FUND # ACCOUNT # DIVISION
2nd Qtr 2015
Jan - Mar Y.T.D.
TOTAL GOVERNMENTAL: $0.00
NON-GOVERNMENTAL
DIRECT CHARGES
672 Assessment & Tax
669 CAMS/CVT Data Conversion
055 CLEMIS
699 CLEMIS - CAD
056 CLEMIS FUND 63500
720 Clerk/Reg - Register of Deeds
659 Collaborative Asset Mgt Sys (CAMS)
521 Community Corrections - Admin (Grant)
471 Courts-FOC Exp-CS Enforcement - EDMS (Imaging)
507 Courts-FOC Exp-CS Enforcement
673 Cyber Security Fund
837 EDCA- MITradeSchool.org Grant
210 Fire Records Management System
750 FM&O
756 FM&O Building Maintenance
751 IT Telephone Communications
634 OakVideo Upgrade (Building Authority)
653 O.C. International Airport
770 Parks and Recreation - Administration
747 Pontiac - Water
748 Pontiac - Sewer
791 Radio Communications - E911
695 Risk Management
638 Tax Management System
546 UASI Grant (Homeland Security)
656 Water Resources Accounting
736 WinCan Central Storage Solution
670 WRC Acctg - Crowder Prict
674 WRC - SAW Grant Labor
734 WRC - AMR Support
Prepared by; Information Technology; 4/15/2015 Page 3 of 15
2nd Qtr 2015
Jan - Mar
$0.00
$0.00
$0.00
$858.00
$0.00
$0.00
$654.99
$4,742.00
60.00
Y.T.D.
$0.00
$0.00
$0.00
$1,841.50
$0.00
$2,947.25
$654.99
$13,039.00
$0.00
$307,216.25 $556,126.44
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
2ND QUARTER 2016
ACCOUNT #
63600-108010'1-152000-631302
DIVISION
WRC - COSDA Meter Replacement
WRC - CO SDS SewMet
WRC EF SDS SewMet
WRC - Data Application Pilot Poject
WRC - Infrastructure Op Ar
WRC - SAW Grant Labor
WRC - SAW Grant Labor - Common to All
WRC - SCADA Common
WRC SCADA Engineering Assessment
SUB-TOTAL DIRECT CHARGES FOR DEVELOPMENT
CUST # FUND #
745
728
729
737
671
674
686
739
738
TOTAL COUNTY DEVELOPMENT CHARGES $1.312,450.12 $2,552,203.95
NON-COUNTY AGENCIES
63600-1080101-152000-635017 Non-County Agencies $19,721.50 $38,765.50
5
Prepared by; Information Technology; 4/15/2015 Page 4 of 15 2nd Quarter 2015.xls
$1,170.27
16,064.00
31 659 75
$1270.00
$35,161.50
$0.00
$0.00
$320.00
$1,170.27
$192.00
$0.00
$0.00
401.00
$5,515.84
$123.00
$20,871.50
$1,170.27
22,927.75
$48,894,02
$1,270.00
$35,161.50
$0.00
$0.00
$320.00
$1,763.27
$5,515.84
$123.00
$20,871.50
$24,098.02
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2016
Gust # GOVERNMENTAL FUNDS
24017 SQL Server Supp - Animal Control
95628 Web License Registration
95682 Dog System
Animal Control-Total
91404 BOC - Customer Support
Bd of Commissioners - Total
95665 Child rens Village
Childrens Village - Total
97668 Childrens Village Admin
Childrens Village Admin - Total
72500 Clerk - Admin
Clerk/Reg - Admin - Total
95443 Elections
Clerk/Reg - Elections Division - Total
24003 SQL Server Supp - ROD 3.5%
36510 GIS Implementation Support
36511 ROD Application - H/W Support
95493 ROD System Maintenance
95498 Clerk/Reg - ROD
Clerk/Reg of Deeds - Total
95158 Clerk/Reg - EDMS Support/Maintneance/Upgrades
Clerk/Reg - EDMS (Imaging) - Total
95512 Clerk/Reg - Jury Commission
Clerk/Reg - Jury Commission - Total
95189 Circuit Court System
Clerk/Reg - Legal Records - Total
24015 SQL Server Supp - Vital Stats 3.5%
95161 Clerk.Reg - Vital Statistics
Clerk - Vital Statistics - Total
630 ANIMAL CONTROL
005 BD OF COMMISSIONERS
665 CHILDRENS VILLAGE
668 CHILDRENS VILLAGE ADMIN
725 CLERK/REG - ADMIN
440 CLERK/REG - ELECTIONS DIVISION
720 CLERK / REGISTER OF DEEDS
722 CLERK/REG - EDMS (IMAGING)
410 CLERK/REG - JURY COMMISSION
724 CLERK/REG - LEGAL RECORDS
723 CLERK - VITAL STATISTICS
Prepared by: Information Technology; 4/15/2015 Page 5 of 15 2nd Quarter §15.xls
$1,436.03
1,170.27
17,349.50
0.00
$19,955.80
49.50
S1,499.75
$1.636.75
$653.00
$192.00
$0.00
718.01
$1,170.27
$55,721.00
61 436 03
$11,349.61
$49.50
$1,499.75
$1,636.75
$653.00
$192.00
$718.01
$1,170.27
$55,721.00
$1,436.03
$11,349.61
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - SECOND QUARTER 2015
522 COMMUNITY CORRECTIONS-ADMIN 1C0)
620 COMPLIANCE OFFICE - AUDITING
690 COMPLIANCE OFFICE - PURCHASING
430 CORPORATION COUNSEL
015 COUNTY EXECUTIVE
450 CIRC CT PROBATION - NORTH
495 CTS-BUSINESS DIVISION
483 CTS-FD-JUDICIAL SUPPORT-ADM
498 CTS-GEN JURIS-JUDICIAL SUPPT
502 CTS-GJ-JURY OPERATIONS
493 CTS-JUDICIAL ADMIN
23003 Oracle Support-Comm Corr - 5.2%
24012 SQL Server Supp - Community Corr 3.5%
52200 Comm Corr-Admin (County)
52201 Comm Corr - DW Support
Community Corrections - Total
44034 Auditing - New Development
95468 Auditing Internal Srv - Gust Sup
Compliance Office - Auditing - Total
44028 Purchasing System Enhancements
Compliance Office - Purchasing - Total
95501 Corporation Counsel
Corporation Counsel - Total
95656 County Executive Support
County Executive - Total
80204 Circuit Court Probation - North
Circuit Court Probation - North - Total
12002 CCT-Courts/Criminal
23010 Oracle Support-CCT/CTS Crim VVhse 2.6%
CTS-Business Division - Total
24009 SQL Serv Supp - CTS-Jud Sup Adm - 3.5%
CTS-FD-Judicial Sup port-Adm - Total
95179 CTS-Gen Juris-Judicial Suppt
CTS-Gen Juris-Judicial Suppt - Total
23008 Oracle Support-CTS-GJ-Jury Operations
CTS-GJ-Jury Operations - Total
95174 CTS-Judicial Admin
CTS-Judicial Admin - Total
785 ECONOMIC DEVELOPMENT & COMMUNITY AFFAIRS 36500 GIS Implementation Support C&E Dev
36501 CED Application - H/W Support
95785 Comm & Eco Developmt
Economic Development & Community Affairs - Total
$640.00
9,092.00
28 355 75
$38,087.75
Prepared by: Information Technology; 4/15/2015 Page 5 of 15 2nd Quarte4 7015.xls
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - SECOND QUARTER 2015
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
95693 Equalization - System Maintenance
95699 BS&A Master Appraisal Sup/Maint
Equalization - Total
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
44602 Bond Disclosure - Fiscal (50%)
96001 Fiscal Serv - Acctg 40%
96003 Fiscal Serv - Budget 20%
Fiscal Services Admin - Total
36525 GIS Implementation Support Health
95563 User Support-Health
96842 Health Admin
Health - Total
23005 Oracle Support - EH Projects - 5.2%
24014 SQL Server Suppt - Ehealth 14%
84200 EH - Projects
84300 Ehealth Program
Health-Environmental - Total
36545 GIS Implementation Support Homeland Security
36546 Homeland Security Application - HNV Support
98990 Homeland Security
Homeland Security - Total
740 EQUALIZATION
660 FISCAL SERVICES ADMIN
840 HEALTH DIVISION
843 HEALTH - ENVIRONMENTAL
900 HOMELAND SECURITY
$1,436.03
3,510.58
1,129.50
9,022.75
38,003.50
3,472.13
4,110.00
5,814.01
0.00
0.00
2.278.00
$68,776.50
$4,308.09
1,436.03
585.18
42,932.00
2,769.00
10,656.00
0.00
0.00
19,521.70
9,760.85
$91,968.85
$237.25
17,255.00
9,121.25
$26,613.50
$1,436.03
4,680.62
75,311.36
19.83725
$101,265.26
$0.00
5,072.00
540.00
$5,612.00
Prepared by: Information Technology; 4/15/2015
Page 7 0E15 2nd Quarter §15.xls
145 PROSECUTOR - GENERAL PROSECUTION
637 RECORDS RETENTION
24016 SQL Server Supp - Proescutors 3.5%
95622 Prosecutor/Executive
97001 Prosecutor Data Proc
Prosecutor - Total
44053 REC - System Enhancements
Records Retention - Total
18 468.27
$6.175.75
$18,468.27
$6,175.76
2nd Quarter 90 &xis
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2015
680 HUMAN RESOURCES
907 LIBRARY- LIBRARY ADMIN
565 MARKETING & COMMUNICATIONS
872 MEDICAL EXAMINER
710 MSU EXTENSION - OAKLAND
163 OCSO-CLEMIS FORENSIC LAB IMS
775 PLANNING & ECO DEVELOPMENT
512 PROB-ESTATESIMENTL HLTH EDMS (MG)
510 PROB-ESTATES/MENTL HLTH SUPPORT
481 PROB-FD JUDICIAL
23014 Oracle Support-HR/Personnel - 5.2%
24007 SQL Server Suppport-HR/Personnel - 1.75%
44044 HR- New Development
96002 Human Res-Personnel 40%
Human Resources - Total
91405 Library Board
Library - Library Admin - Total
56500 Marketing & Communications
Marketing & Communications - Total
24002 SQL Server Support - Medical Exam - 3.5%
87202 Medical Examiner Customer Support
Medical Examiner - Total
95676 MSU Ext Equipment Maintenance
MSU Extension - Oakland - Total
16300 OCSO-CLEMIS Forensic Lab
OCSO-CLEMIS Forensic Lab [MS - Total
95600 PEDS Cust/System Support
Planning & Eco Development - Total
95207 PC-E/MH EDMS Support & Mtce
Prob-Est/Mntl Hlth EDMS (Img)
24010 SQL Serv Supp-PCT-Est/Mental - 3.5%
92198 Prob-Est/Mntl Hlth Support
Prob-Est/Mntl Hlth Support Total
95168 PC-Judicial Family Admin-Family Judges
Prob - FD Judicial - Total
Prepared by: Information Technology; 4/15/2015 Page B of 15
$1,436.03
585.18
18,823.40
25,359.66
$1 076 50
$24,208.00
$1,170.27
11 813.50
$99.00
60.00
$1,155.00
$4826.36
$0.00
12,352.27
$1,476.00
$46,204.27
$1,076.50
$24,208.00
$12,983.77
$99.00
60.00
$1,155.00
$4,826.36
$12,352.27
$1,476.00
$0.00
0.00
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2015
95470 Reimbursement System
95542 Reimburse User Support
Reimbursement - Total
12001 OCSD-Courts/Criminal - 50%
23009 Oracle Suppport - OCSD/CTS Crim Whse - 2.6%
97163 Sheriff
97164 Sheriff - Development
97165 Sheriff-OW Support
98164 CLEMIS-Sheriff
Sheriff - Total
23015 Oracle Suppport - Sheriff / CLEM1S - 5.2%
96163 Sheriff - CLEMIS
Sheriff - CLEM'S - 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%
36516 Treasurer Application - HNV Support
36602 Land System Enhancements - Treas (50%)
36702 Land System Maintenance - Treas (50%)
36802 Land System Support - Treas (50%)
44061 Tre-System/Customer Support
44062 Tre-System Maintenance
44063 Tre-System Enhancements
44080 Tre-DW Support
44082 Tre-DW Maintenance
44601 Bond Disclosure - Treas (50%)
95008 Del Tax On Line
95303 Del Tax System Maintenance
95561 User Support/Del Tax
95615 BS&A Annual Tax Support
Treasurer - Total
44083 Treasurer-Landsate
Treasurer -Landsale - Total
95651 Veterans Customer Support
$2,335.00
0.00
$0.00
718.01
7,817.25
0.00
512.00
82,000.75
$1,436.03
640.00
$1,436.03
2,340.31
8,430.75
$1,436.03
2,872.07
10,240.00
3,472.12
4,110.00
5,813.99
22,895.36
24,297.00
45,273.00
0.00
0.00
0.00
0.00
1,664.00
15,552.00
9,773.50
-58.368.50
$128.00
650 REIMBURSEMENT
195 SHERIFF
191 SHERIFF - CLEMIS
445 SUPPORT SERVICES
600 TREASURER
627 TREASURER - LANDSALE
910 VETERANS SERVICES
$2,335.00
$91,048.01
$2,076.03
$12,207.09
$147,399.07
($8,368.50)
Prepared by: Information Technology; 4/15/2015 Page 9 0115 2nd Quail:IS:xis
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - SECOND QUARTER 2015
Veterans Services - Total $128.00
Prepared by Information Technology; 4/15/2015
Page 10 of 15 2nd Quartl115.xls
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - SECOND QUARTER 2015
730 WATER RESOURCE COMMISSIONER 24008 SQL Server Supp - WRC 3.5%
28010 VVRC - Customer Support
28011 Water Resource Commissioner Application
36520 GIS Implementation Support WRC
36521 WRC Application - H/VV Support
Water Resource Commissioner - Total
95527 DC Suprt- 52/1 - 25%
52/1 District Court - Total
95528 DC Suprt- 52/2 - 25%
52/2 District Court - Total
$1,170.27
10,828.00
9,641.00
4,282.00
29 090.75
540 5211 DISTRICT COURT - NOVI
2853.22
$55,012.02
$2,853.22
$2,853.22
550 52/2 DISTRICT COURT - CLARKSTON
$2.853.22
560 52/3 DISTRICT COURT - ROCHESTER 95288 52 Dist Ct Div 3
95529 DC Suprt - 52/3 - 25%
52/3 District Court - Total
$2,85322
0.00
$2,853.22
530 5214 DISTRICT COURT - TROY 95530 DC Suprt- 52/4 - 25% $2,852.84
52/4 District Court - Total $2,852.84
Prepared by: Information Technology: 4/15/2015 Page 11 of 15 2nd Quarl?15.)ds
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2015
Cust# DIRECT FUNDS
672 ASSESSMENT & TAX 67200 Assessment & Tax
Assessment & Tax - Total
$11,359.25
$11,359.25
23004 Oracle Support - OakVideo CLEMIS 5.2% $1,436.03
23018 Oracle Support - Sheriff CLEMIS 5.2% 1,436.07
24004 SQL Server Support - 24.5% 8,191.20
95430 CLEMIS Maintenance 904.00
95431 CLMS Enhancements 0.00
98003 CLEMIS User Support 910.75
98005 CLEWS E911 Support 0.00
CLEWS - Total $12,878.05
98006 CLEM1S - CAD Development $0.00
CLEM IS - CAD Total $0.00
63500 CLEM'S Fund $49,472.00
CLEMIS 63500 Fund - Total $49,472.00
66901 CAMS/CVT Data Conversion $0.00
CA1V1S/CVT Data Conversion - Total $0.00
65901 Collabortive Asset Mgt Sys $0.00
Collabortive Asset Mgt Sys - Total $0.00
92194 CTS-F0C-CS ENF-EDMS Support/Maintenance/Upgrades $4,826.36
CTS-FOC Exp-CS Enforc-EDMS (1mg) - Total $4,826.36
92193 CTS-FOC Exp-CD Enforc-Dev $16,407.25
CTS-FOC Exp-CD Enforc-Dev - Total $16,407.25
52102 Community Corrections - COMPAS App
Comm Corr - Adm (Grant) - Total $0.00
67300 Cyber Security Fund $137,418.25
Cyber Security Fund - Total $137,418.25
83700 EDCA - M ITRADESCHOOL $0.00
EDCA - MITradeSchool.org Grant - Total $0.00
055 CLEM'S
699 CLEMIS - CAD
056 CLEMIS FUND 63500
669 CAMS/CVT DATA CONVERSION
659 COLLABORATIVE ASSET MGT SYS
471 CTS-FOC-EXP-CS ENFORC-EDNIS (IMG)
507 CTS-FOC EXP-CS ENFORCEMENT
521 COMM CORR - ADM (GRANT)
673 CYBER SECURITY FUND
837 EDCA - MITRADESCHOOLORG GRANT
Prepared by: Information Technology; 4/15/2015 Page 12 of 15 2nd Quart1415:As
$0.00
1,170.27
$1,170.27
$0.00
1,170.27
14 123.25
$0.00
8234.00
$0.00
0.00
$128.00
8465.50
$15,293.52
$0.00
$234.00
$0.00
$593.50
$1,056.00
1,270.00
1,796.00
0.00
704.00
8 839.00
$444.25
$0.00
$0.00
$13,665.00
$444.25
$0.00
$0.00
$0.00
2nd Quart:14 5.)ds
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2015
21010 Fire Records Mgmt Fund 531
24001 SQL Server Support - FRMS 3.5%
Fire Records Management System - Total
21001 Facilities Maintenance & Operations
24013 SQL Server Supp - FM&O
75503 FM&O Development
FM&O - Total
75600 FM&O Building Maintenance
FM&O Building Maintenance - Total
75102 Telephone Communications - Customer Support
II- Telephone Communications - Total
63400 CLEM1S - OakVideo Upgrade
63401 IT - OakVideo Upgrade
OakVideo Upgrade (BA) - Total
36540 GIS Implementation Support
65301 Airport User Support
O.C. IntnlAirport - Total
210 FIRE RECORDS MANAGEMENT SYSTEM
750 FM&O
756 FM&O BUILDING MAINTENANCE
751 IT - TELEPHONE COMMUNICATIONS
634 OAKVIDEO UPGRADE (BA)
653 D.C. INTNL AIRPORT
770 PARKS AND RECREATION
747 PONTIAC WATER
36530 GIS Implementation Support - Parks
44066 PRADM-SystemlCustomer Support
44068 PRADM-System Enhancements
76100 P&R Administrative Services
95413 PRADM-Customer Support
95419 PRADM-Administration
Parks & Recreation - Total
74701 Pontiac BSA to VVRC - Water
Pontiac Water - Total
748 PONTIAC SEWER
791 RADIO COMMUNICATIONS - E911
695 RISK MANAGEMENT
Prepared by: Information Technology; 4/15/2015 Page 13 of 15
74702 Pontiac BSA to WRC - Sewer
Pontiac Sewer - Total
79101 Radio Communications - E911
Radio Communications - E911 - Total
44036 Rsk-System Customer Support
Risk Management - Total
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2015
638 TAX MANAGEMENT SYSTEM
656 WATER RESOURCES ACCOUNTING
63800 Tax Management System
Tax Management System - Total
23011 Oracle Supp - Water & Sewer Acct'g -5.2%
95669 Water Resources Accounting
95671 Drain Water/Sewer 13(
Water Resources Accounting - Total
$21,016.75
$1,436.03
394.50
4,126 00
$21,016.75
$5,956.53
Prepared by Information Technology; 4/15/2015 Page 14 of 15 2nd Quarti §15.)es
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2015
736 WINCAN CENTRAL STORAGE SOLUTION
670 WRC ACCTG - CROWDER PRJCT
674 WRC - SAW GRANT LABOR
686 WRC - SAW GRANT LABOR -COMMON TO ALL
734 WRC -AMR SUPPORT
745 WRC - COSDA METER REPLACEMENT
728 WRC - CO SDS SEWMET
729 WRC - EF SDS SEWMET
737 WRC - DATA APPLICATION PILOT PRJ
671 WRC - INFRASTRUCTURE OP AR
739 WRC - SCADA COMMON
738 WRC - SCADA ENGINEERING ASSESSMT
73601 WinCan Central Storage Solution
WinCan Central Storage Solution - Total
67000 WRC - Crowder NetBase Project
VVRC Acctg - Crowder Prject - Total
28674 WRC - SAW Grant Labor
WRC - SAW Grant Labor - Total
60002 WRC - SAW Grant Labor - Common to All
WRC - SAW Grant Labor Common to All- Total
73401 WRC - AMR Support
WRC - AMR Support - Total
74500 VVRC - CODSA Meter Replacement
WRC - CODSA Meter Replacement - Total
72201 MARS Enhancements - WRC C-0
VVRC - CO SDS SewMet - Total
72202 MARS Enhancements - WRC F-F
VVRC EF SDS SewMet - Total
73700 WRC - Data Application Pilot Project
73710 WRC - Data Appl Prj
WRC - Data Application Pilot Prj - Total
67100 WRC -10 AR
WRC - Infrastructure Op Ar - Total
73900 WRC - SCADA Common
WRC - SCADA Common - Total
73800 WRC - SCADA Engineering Assesmnt
WRC - SCADA Engineering Assesmt - Total
$0.00
$1.965.01
$6,408.00
$654.99
$90.00
$0.00
$0.00
$0.00
$0.00
858.00
$0.00
$4.742.00
$0.00
$0.00
$1,965.01
$6,408.00
$654.99
$90.00
$0.00
$0.00
$0.00
$858.00
$0.00
$4,742.00
$0.00
Prepared by: Information Technology; 4/15/2015
Page 15 of 15 2n1 Quarti§15-xls
Resolution #15121 May 6, 2015
Moved by Fleming supported by McGillivray the resolutions (with fiscal notes attached) on the amended
Consent Agenda be adopted (with accompanying reports being accepted).
AYES: Fleming, Gershenson, Gingell, Gosselin, Hoffman, Jackson, KowaII, Long, Matis,
McGillivray, Middleton, Scott, Spisz, Taub, Weipert, Woodward, Zack, Bowman, Crawford. (19)
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 THIS RESOLUTION
CHIEF DEPUTY COUNTY EXECUTIVE
ACTING PURSUANT TO MCL 45.559A (7)
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, Lisa Brown, 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 May 6, 2015,
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 6th day of May 2015.
Lisa Brown, Oakland County
7