Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Resolutions - 2014.07.31 - 21430
MISCELLANEOUS RESOLUTION #14118 July 31, 2014 BY: FINANCE COMMITTEE, TOM MIDDLETON, CHAIRPERSON IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY — THIRD QUARTER 2014 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 2014 development charges to be $1,118,276.05 for the General Fund/General Purpose County departments; and WHEREAS direct charges to Special Revenue and Proprietary fund departments are $458,846.13 and non-county agencies are $7,863.50 for the Third Quarter 2014; 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 2014 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 2014 budgets are to be amended as specified in the attached detail schedule. CE C9.11.41111,1TTE; /woo FINANCE COMMITTEE Motion carried unanimously on a roll call vote with Matis absent. 540 550 560 530 630 005 725 722 440 410 724 723 522 620 690 430 015 495 483 498 502 493 785 740 660 900 680 907 565 872 710 163 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 5213 - District Court 52/4 - District Court Animal Control Bd of Commissioners 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 County Executive Courts-Business Division Courts-FD-Judicial Support-Admin 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 Admin Marketing & Communcations Medical Examiner MSU Extension - Oakland OCSO - CLEMIS Forensic Lab IMS $2,375.21 $2,375.21 $2,375.21 $2,375.12 $129,007.70 $4,546.00 $4,540.25 $1,577.44 $1,741.00 $0.00 $14,859.50 $20,816.45 $20,304.46 $1,884.00 $0.00 $705.00 $162.00 $738.26 $1,075.95 $123,034.44 $1,476.51 $1,380.26 $10,404.50 $77,339.86 $80,653.78 $8,034,50 $23,997,53 $56.00 $9,689.54 $11,133.95 $0.00 $0.00 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 3RD QUARTER 2014 CUST # FUND # ACCOUNT # DIVISION 3rd Qtr 2014 Apr-Jun Y.T.D. GOVERNMENTAL FUNDS General Fund [101.1 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-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-1010101-181000-773630 10100-3010201-121110-773630 10100-3010403-121100-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-1010115-115090-773630 10100-1050401-183010-773630 10100-5010303-165040-773630 10100-1090108-171030-773630 10100-1070601-132030-773630 10100-1070501-174000-773630 10100-4030901-115140-773630 $6,109.87 $6,109.87 $6,109.87 $6,109.64 $177,148.58 $6,182.00 $8,401.25 $4,373.92 $3,353.00 $427.00 $43,453.00 $52,324.08 $69,078.93 $9,426.50 $0.00 $2,217,00 $662.00 $1,912.76 $3,049.08 $274,191.19 $3,825.35 $7,631.68 $32,308.00 $386,826.05 $189,152.91 $15,989.50 $56,834.99 $3,970.00 $36,532,38 $28,127.58 $716.00 $0.00 2 3rd Quarter 2014.pdf Prepared by; Information Technology; 07117/2014 Page 1 of 12 $208.00 $13,872.81 $1,380.26 $7,196.95 $696.00 $26,181.20 $2,086.50 $6,409.25 $93,163.26 $3,263.01 $11,499.21 $111,819.43 $5,429.00 $576.00 $78,816.20 $921,256.71 $3,532.00 $13,872.81 $3,827.18 $17,742.58 $2,564.00 $62,418.58 $2,194.50 $28,680.25 $268,485.26 $8,339.85 $21,562.88 $336,234.54 $5,429.00 $3,030.00 $216,542.33 $2,437,009.74 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 3RD QUARTER 2014 CUST # FUND # ACCOUNT # DIVISION 3rd Qtr 2014 Apr - Jun Y.T.D. 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 [2931 665 293 20293-1060501-112090-773630 668 293 20293-1060501-112010-773630 63600-1080101-152000-631365 10100-9090101-196030-773630 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 $33,553.75 $63,135.75 $156,835.59 $319,998.12 $190,389.34 $383,133.87 $6,630.00 $50,316.00 $0.00 $0.00 $6,630.00 $50,316.00 $1,118,276.05 $2.870,459.61 $1,118,276.05 $2,870,459.61 ($1,118,276.05) ($2,870,459.61) Prepared by; information Technology; 07/17/2014 Page 2 of 12 3rd Quarter 2014.pdf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 3RD QUARTER 2014 CUST # FUND # ACCOUNT # DIVISION 3rd Qtr 2014 Apr - Jun Y.T.D. TOTAL GOVERNMENTAL: $0.00 $0.00 NON-GOVERNMENTAL DIRECT CHARGES $150,304.50 $4,692.00 $27,137.76 $0.00 $5,490.00 $3,528.95 $21,280.00 $1,815.50 $1,380.26 ($11,730.50) $128,099.50 $0.00 $1,075.95 $18,112.45 $1,091.00 $0.00 $45,129.50 $2,539.00 $20,585.25 $0.00 $0.00 $1,532.00 $0.00 $3,696.00 $2,288.51 $0.00 $0.00 $750.00 $0.00 $0.00 672 Assessment & Tax 669 CAMS/CVT Data Conversion 055 CLEM1S 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 TeLepone Communications 634 Oak Video 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 546 UASI Grant (Homeland Security) 656 Water Resources Accounting 736 WinCan Central Storage Solution 670 WRC Acctg - Crowder Prjct 734 WRC - AMR Support 745 WRC - COSDA Meter Replacement 728 WRC - CO SDS SewMet Prepared by; Information Technology; 07/17/2014 Page 3 of 12 $490,020.75 $72,981.75 $78,830.04 $0.00 $35,435.50 $10,247.08 $50,901.00 $2,356.00 $3,827.18 $140,321.00 $383,889.50 $0.00 $3,049.08 $71,282.08 $1,091.00 $0.00 $161,723.50 $3,476.00 $51,579.28 $348.75 $348.75 $16,965.00 $54.00 $3,696.00 $6,707.85 $0.00 $0.00 $750.00 $0.00 $0.00 4 3rd Quarter 2014.pdf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 3RD QUARTER 2014 ACCOUNT # 63600-1080101-152000-631302 DIVISION WRC EF SDS SewMet WRC - Data Application Pilot Poject WRC - Infrastructure Op Ar WRC - SAW Grant Labor WRC SCADA Common WRC - SCADA Engineering Assessment 3rd Qtr 2014 Apr-Jun $0.00 $849.50 $0.00 $6,058.00 $23,141.00 $0.00 Y.T.D. $0.00 $2,070.50 $0.00 $6,058.00 $62,447.50 $0.00 CUST # FUND # 729 737 671 674 739 738 SUB-TOTAL DIRECT CHARGES FOR DEVELOPMENT $458,846.13 $1,660,457.09 TOTAL COUNTY DEVELOPMENT CHARGES $1,577,122.18 $4,530,916.70 NON-COUNTY AGENCIES 63600-1080101-152000-635017 Non-County Agencies $7,863.50 $8,390.00 5 3rd Quarter 2014.pdf Prepared by; Information Technology; 07/17/2014 Page 4 of 12 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2014 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 Childrens 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 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 23003 Oracle Support-Comm Corr 5.2% 24012 SQL Server Supp - Community Corr 3.5% 52200 Comm Corr-Admin (County) 52201 Comm Corr - DVV Support Community Corrections - Total 44034 Auditing - New Development 95468 Auditing Internal Srv - Cust Sup cust # GOVERNMENTAL FUNDS 630 ANIMAL CONTROL 005 SD OF COMMISSIONERS 665 CHILDRENS VILLAGE 668 CHILDRENS VILLAGE ADMIN 725 CLERK/FIEG - ADMIN 440 CLERK/REG - ELECTIONS DIVISION 722 CLERIC/REG - EDMS (IMAGING) 410 CLERK/REG - JURY COMMISSION 724 CLERK/REG - LEGAL RECORDS 723 CLERK - VITAL STATISTICS 522 COMMUNITY CORRECTIONS-ADMIN (CO) 620 COMPLIANCE OFFICE - AUDITING $1,075.95 109,616.25 18,315.50 $129,007.70 $4,546.00 $4,546.00 $6,630.00 $6,630.00 $0.00 $0.00 $3,825.25 $3,825.25 $1,741.00 $1,741.00 $1,093.20 $1,093.20 $0.00 $0.00 $11,648/5 $11,648.75 $921.57 19 881.50 $20,803.07 $1,476.51 1,075.95 17,752.00 0.00 $20,304.46 $3,339.50 2,319.00 (5 Prepared by; Information Technology, 07/17/2014 Page 5 of 12 3rd Quarter 2014.pdf $0.00 $5,658.50 $0.00 $705.00 $162.00 $705.00 $162.00 $0.00 566 22 $921.57 $123,034.44 $1,476.51 $3,031.05 $566.22 $921.57 $123,034,44 $1,476.51 $3,031.05 $252.00 10,728.00 0.00 $10,980.00 $1,132.43 2,764.44 32,087.25 14,461.00 33,408/5 3,095.50 539.00 208.25 24.50 0.00 15 360.00 $103,081.12 $4,429.66 1,476.51 538,06 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 12002 CCT-Courts/Criminal 23010 Oracle Support-CCT/CTS Crim Whse 2.6% CTS-Business Division - Total 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% 690 COMPLIANCE OFFICE - PURCHASING 430 CORPORATION COUNSEL 015 COUNTY EXECUTIVE 495 CTS-BUSINESS DIVISION 740 EQUALIZATION 660 FISCAL SERVICES ADMIN 483 CTS-FD-JUDICIAL SUPPORT-ADM 24009 SQL Serv Supp - CTS-Jud Sup Mm - 3.5% CTS-FD-Judicial Support-Adm - Total 498 CTS-GEN JURIS-JUDICIAL SUPPT 95179 CTS-Gen Juris-Judicial Suppt CTS-Gen June-Judicial Suppt - Total 502 CTS-GJ-JURY OPERATIONS 23008 Oracle Support-CTS-GJ-Jury Operations CTS-GJ-Jury Operations - Total 493 CTS-JUDICIAL ADMIN 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 7 Prepared by; Information Technology; 07/17/2014 Page 6 of 12 3rd Quarter 2014.pdf 44021 44022 44023 44024 44602 96001 96003 41,306.00 814.00 1,185.50 0.00 0.00 20,602.70 10.301 35 $80,653.78 FS-System/Customer Support FS - System Maintenance FS - System Enhancements FS - New Development Bond Disclosure - Fiscal (50%) Human Res - Acct 40% Human Res - Budget 20% Fiscal Services Admin - Total 8 3rd Quarter 2014.pdf Prepared by; Information Technology; 07/17/2014 Page 7 of 12 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 - HAN Support 98990 Homeland Security Homeland Security - Total 23014 Oracle Support-HR/Personnel - 5.2% 24007 SQL Server Suppport-HR/Personnel - 1.75% 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 Dd Equipment Maintenance MSU Extension - Oakland - Total 16300 OCSO-CLEMIS Forensic Lab OCSO-CLEMIS Forensic Lab IMS - Total 95600 PEDS Cust/System Support Planning 8, Eco Development - Total 840 HEALTH DIVISION 843 HEALTH - ENVIRONMENTAL 900 HOMELAND SECURITY 680 HUMAN RESOURCES 907 LIBRARY - LIBRARY ADMIN 565 MARKETING & COMMUNICATIONS 872 MEDICAL EXAMINER 710 MSU EXTENSION - OAKLAND 163 OCSO-CLEIVIIS FORENSIC LAB IMS 775 PLANNING & ECU DEVELOPMENT $0.00 12,874.25 20 679.50 $33,553.75 $1,476.51 4,303.32 139,956.76 11.099.00 $156,835.59 $0.00 4,248.50 3,786.00 $8,034.50 $1,476.51 538.06 21 982 96 $56.00 $9,689.54 $1,075.95 10 058 00 $0.00 $0.00 $670.00 $23,997.53 $56.00 $9,689.54 $11,133.95 $0,00 $0.00 $670.00 480 PROB-ESTATES/MENTL HLTH ADMIN 512 PROB-ESTATES/MENTL HLTH EDMS (IMG) 510 PROB-ESTATES/MENTL HLTH SUPPORT 481 PROB-FD JUDICIAL 195 SHERIFF 191 SHERIFF - CLEMIS 92197 Prob-E/MH ADM Day Prob-Estates/Mentl Hlth Admin - 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 1-1Ith Support - Total 95168 PC-Judicial Family Admin-Family Judges Prob FD Judicial - Total 24016 SQL Server Supp - Proescutors 3.5% 95622 Prosecutor/Executive 97001 Prosecutor Data Proc Prosecutor - Total 44053 REC - System Enhancements Records Retention - Total 95470 Reimbursement System 95542 Reimburse User Support Reimbursement - Total 12001 OCSD-Courts/Criminal - 50% 23009 Oracle Sup pport - OCSD/CTS Crim Whse - 2.6% 97163 Sheriff 97164 Sheriff - Development 97165 Sheriff-DW Support 98164 CLEMIS-Sheriff Sheriff - Total 23015 Oracle Suppport - Sheriff / CLEMIS -52% 96163 Sheriff - CLEM1S Sheriff - CLEM1S - Total 23002 Oracle Support - Supp Serv - 5.2% 24011 SQL Server Supp Suppt Services 7% 44500 Support Services Support Services - Total 145 PROSECUTOR - GENERAL PROSECUTION 637 RECORDS RETENTION 650 REIMBURSEMENT 445 SUPPORT SERVICES $13,872.81 $138026 $1,075.95 6121.00 $7,196.95 $934.00 $934.00 $1,075.95 20,884.25 4 221 00 $26,181.20 $2,086.50 $2,086.50 $6,01925 390.00 $6,409.25 $0.00 738.26 4,396.00 0.00 4,167.00 83 862.00 $93,163.26 $1,476.51 1 786.50 $3,263.01 $1,476.51 2,151.70 7.871.00 $11,499.21 600 TREASURER 23006 Oracle Support - Del Tax - 5.2% 23016 Oracle Support-Treasurer - 10.4% 36516 Treasurer Application H/W Support 36602 Land System Enhancements - Treas (50%) 36702 Land System Maintenance - Treas (50%) $1,132.43 2,264.80 15,970.00 3,095.50 539.00 9 Prepared by; Information Technology; 07/17/2014 Page 8 of 12 3rd Quarter 2014.pdf 208.25 12,762.05 4,212.00 29,696.75 0.00 0.00 15,480.40 122.00 4,056.50 17,462.50 5,593.50 $5,429.00 $576.00 $921.57 14,548.50 19,134.50 4,038.00 40,043.50 $2,375.21 $2,375.21 $0.00 2.375.21 $112,595.68 #REF! $576.00 $78,686.07 $2,375.21 $2,375.21 $2,375.21 36802 Land System Support - Treas (50%) 44061 Tre-System/Customer Support 44062 Tre-System Maintenance 44063 Tre-System Enhancements 44080 Tre-DVV Support 44082 Tre-DVV 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 - Landsale Treasurer - Landsale - Total 95651 Veterans Customer Support Veterans Services - Total 24008 SQL Server Supp - WRC 3.5% 28010 WRC - Customer Support 28011 Water Resource Commissioner Application 36520 GIS Implementation Support WRC 36521 WRC Application - HNV Support Water Resource Commissioner - Total 95527 DC Suprt- 52/1 - 25% 5211 District Court - Total 95528 DC Suprt- 5212 - 25% 52/2 District Court - Total 95288 52 Dist Ct Div 3 95529 DC Suprt - 52/3 - 25% 52/3 District Court - Total 627 TREASURERS - LANDSALE 910 VETERANS SERVICES 730 WATER RESOURCE COMMISSIONER 540 52/1 DISTRICT COURT - NOVI 550 5212 DISTRICT COURT - CLARKSTON 560 5213 DISTRICT COURT - ROCHESTER 530 52/4 DISTRICT COURT - TROY Cust # DIRECT FUNDS 95530 DC Suprt- 52/4 - 25% 52/4 District Court - Total $2,375.12 $2,375.12 672 ASSESSMENT & TAX 67200 Assessmenet & Tax Assessmenet & Tax - Total $189,411.75 $189,411.75 #REF! 055 CLEM'S 23004 Oracle Support - OakVideo CLEMIS 5.2% 23018 Oracle Support - Sheriff CLEWS 5.2% 24004 SQL Server Support - 24.5% $1,476.51 1,477.34 7,530.91 10 Prepared by; Information Technology; 07/1712014 Page 9 of 12 3rd Quarter 2014.pdf 13,176.00 0.00 1,647.00 1,830.00 $0.00 $5,490.00 $4,692.00 $21,280.00 $27,137.76 $0.00 $5,490.00 $4,692.00 $21,280.00 $921.57 $701.50 $57.00 $0.00 2.94700 $4,627.07 $1,380.26 ($11,730.50) $1 380.26 ($11,730.50) $1,815.50 $0.00 $127,690.50 $0.00 $0.00 1,075.95 $1,815.50 $127,690.50 $0.00 $1,075.95 95430 CLEMIS Maintenance 95431 CLMS Enhancements 98003 CLEMIS User Support 98005 CLEMIS E911 Support CLEMIS - Total 98006 CLEMIS - CAD Development CLEM - CAD Total 63500 CLEMIS Fund CLEMIS 63500 Fund - Total 66901 CAMS/CVT Data Conversion CAMS/CVT Data Conversion - Total 65901 Collabortive Asset Mgt Sys Collabortive Asset Mgt Sys - Total 24003 SQL Server Supp - ROD 3.5% 36510 GIS Implementation Support 36511 ROD Application - HNV Support 95493 ROD System Maintenance 95498 Clerk/Reg - ROD Clerk/Reg of Deeds - Total 92194 CTS-FOC-CS ENF-FDMS Support/Maintenance/Upgrades CTS-FOC Exp-CS Enforc-EDMS (Img) - Total 92193 CTS-FOC Exp-CD Enforc-Dev CTS-FOC Exp-CD Fnforc-Dev - Total 52100 Community Corrections Admin Grant 52102 Community Corrections - COMPAS App Comm Corr - Adm (Grant) - Total 67300 Cyber Security Fund Cyber Security Fund - Total 83700 EDCA - MITRADESCHOOL EDCA - MITradeSchool.org Grant - Total 21010 Fire Records Mgmt Fund 531 24001 SQL Server Support - FRMS 3.5% Fire Records Management System - Total 699 CLEM'S - CAD 056 CLEMIS FUND 63500 669 CAMS/CVT DATA CONVERSION 659 COLLABORATIVE ASSET MGT SYS 720 CLERK / REGISTER OF DEEDS 471 CTS-FOC-EXP-CS ENFORC-EDMS (IMG) 507 CTS-FOC EXP-CS ENFORCEMENT 521 COMM CORR - ADM (GRANT) 673 CYBER SECURITY FUND 837 EDCA MITRADESCHOOLORG GRANT 210 FIRE RECORDS MANAGEMENT SYSTEM 750 FM&O 21001 Facilities Maintenance & Operations $0.00 24013 SQL Server Supp - FM&O 921.57 11 Prepared by; Information Technology; 07/17/2014 Page 10 of 12 3rd Quarter 2014.pdf 75503 FM&O Development FM&O - Total 23 202.00 $24,123.57 751 IT - TELEPHONE COMMUNICATIONS 75102 Telephone Communications - Customer Support IT - Telephone Communications - Total $0.00 $0.00 634 OAK VIDEO UPGRADE (BA1 63400 CLEMES - Oak Video Upgrade $45,068.50 63401 IT - Oak Video Upgrade 61.00 Oak Video Upgrade (BA) - Total $45,129.50 653 D.C. INTNL AIRPORT 36540 GIS Implementation Support 65301 Airport User Support O.C. IntnlAirport - Total $0.00 $2 539.00 $2,539.00 770 PARKS AND RECREATION 747 PONTIAC WATER 748 PONTIAC SEWER 791 RADIO COMMUNICATIONS - E911 695 RISK MANAGEMENT 546 UASI GRANT (HOMELAND SECURITY) 656 WATER RESOURCES ACCOUNTING 736 WINCAN CENTRAL STORAGE SOLUTION 670 WRC ACCTG - CROWDER PRJCT 36530 GIS Implementation Support - Parks 44066 PRADM-System/Customer Support 44068 PRADM-System Enhancements 76100 P&R Administrative Services 95413 PRADM-Customer Support 95419 PRADM-Administration Parks & Recreation - Total 74701 Pontiac BSA to WRC - Water Pontiac Water - Total 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 12546 UASI Grant (Homeland Security) UASI Grant (Homeland Security) - Total 23011 Oracle Supp - Water & Sewer Acct'g - 5.2% 95669 Water Resources Accounting Water Resources Accounting - Total 73601 WinCan Central Storage Solution WinCan Central Storage Solution - Total 67000 WRC - Crowder NetBase Project WRC Acctg - Crowder Prject - Total $280.00 952.00 1,078.17 2,603.00 868.00 10.221.50 $0.00 $0.00 $8,174.00 $0.00 $3,696.00 $1,476.51 812.00 $0.00 $0.00 $16,002.67 $0.00 $0.00 $8,174.00 $0.00 $3,696.00 $2,288.51 $0.00 $0.00 745 WRC - COSDA METER REPLACEMENT 74500 WRC CODSA Meter Replacement $0.00 12 3rd Quarter 2014.pdf Prepared by; Information Technology; 07117/2014 Page 11 of 12 WRC CODSA Meter Replacement - Total $0.00 728 WRC - CO SDS SEWMET 72201 MARS Enhancements - WRC C-0 WRC - CO SDS SewMet - Total $0.00 $0.00 729 WRC - EF SDS SEWMET 72202 MARS Enhancements - WRC E-F $0.00 WRC - EF SOS SewMet - Total $0.00 737 WRC - DATA APPLICATION PILOT PRJ 73700 VVRC - Data Application Pilot Project 73710 WRC - Data Appl Prj VVRC - Data Application Pilot Pd - Total 67100 WRC -10 AR WRC - Infrastructure Op Ar - Total $0.00 849.50 671 WRC - INFRASTRUCTURE OP AR $0.00 $849.50 $0.00 674 WRC - SAW GRANT LABOR 739 WRC SCADA COMMON 738 WRC - SCADA ENGINEERING ASSESSMT 28674 WRC - SAW Grant Labor WRC - SAW Gran Labor - Total 73900 WRC - SCADA Common WRC SCADA Common - Total 73800 WRC - SCADA Engineering Assesmnt WRC - SCADA Engineering Assesmt - Total $6,058.00 $25.767.50 $0.00 $6,058.00 $25,767.50 $0.00 507,498.54 13 Prepared by; Information Technology; 07/17/2014 Page 12 of 12 3rd Quarter 2014.pdf Resolution #14178 Resolution #14178 Moved by Weipert supported by Quarles the resolutions (with fiscal notes attached) on the amended Consent Agenda be adopted (with accompanying reports being accepted). AYES: Dwyer, Gershenson, Gingell, Gosselin, Hatchett, Hoffman, Long, Matis, McGillivray, Middleton, Quarles, Runestad, Scott, Spisz, Taub, Weipert, Woodward, Zack, Bosnic, Crawford. (20) 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). ce-/ -1Y I HEREBY APPROVE THIS RESOLUTION CHIEF DEPUTY COUNTY EXECUTIVE ACTING PURSUANT TO MCL 46.659A (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 July 31, 2014, 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 31 st day of July 2014. Lisa Brown, Oakland County