Loading...
HomeMy WebLinkAboutResolutions - 2015.11.12 - 22068MISCELLANEOUS RESOLUTION . #15273 November 12, 2015 BY: Finance Committee, Thomas Middleton, Chairperson IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY — FOURTH 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 Fourth Quarter 2015 development charges to be $946,133.43 for the General Fund/General Purpose County departments; and WHEREAS direct charges to Special Revenue and Proprietary fund departments are $521,333.47 and non-county agencies are $17,184.00 for the Fourth 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 Fourth Quarter 2015 Development Report and approves the Fourth 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 with Matis absent. INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 4TH QUARTER 2016 CUST # FUND # ACCOUNT # GOVERNMENTAL FUNDS General Fund moil 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 005 101 101 00-501 0101-180010-773630 450 101 10100-1070901-113270-773630 725 101 10100-2010201-180000-773630 722 101 10100-2010210-125000-773630 440 101 10100-201 0301-1 8501 0-773630 410 101 10100-2010501-125000-773630 724 101 10100-2010210-125000-773630 723 101 10100-2010205-132300-773630 522 101 10100-1070401-113000-773630 620 101 10100-1010201-181010-773630 690 101 10100-1010210-182090-773630 430 101 10100-1010501-181020-773630 483 101 10100-3010403-121100-773630 015 101 10100-1010101-181000-773630 495 101 10100-3010201-121110-773630 498 101 10100-3010301-121130-773630 502 101 10100-3010301-121180-773630 493 101 10100-3010101-121100-773630 785 101 10100-1 0901 01 -1 71 000-773630 740 101 10100-1020501-173010-773630 660 101 10100-1020601-182020-773630 900 101 10100-1060601-115090-773630 680 101 10100-1050401-183010-773630 907 101 10100-5010303-165040-773630 824 101 10100-501 0302-1 65020-773630 565 101 101 00-10901 08-171030-773630 872 101 10100-1070601-132030-773630 DIVISION 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 - Adm in 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 Admin Library Services Marketing & Communcations Medical Examiner 4th Qtr 2015 Jul - Sep $2,181.99 $2,181.99 $2,181.99 $2,181.78 $92,340.64 $362.25 $44.00 $0.00 $5,145.28 $2,902.75 $0.00 $24,638.50 $23,159.14 $5,436.12 $0.00 $1,889.00 $9,040.00 $1,304.39 $544.50 $1,088.14 $71,305.75 $1,920.23 $5,392.12 $28,534.00 $85,084.67 $74,834.33 $11,355.00 $92,280.32 $4,088.75 $1,304.50 $8,820.25 $5,796.89 Y.T.D. $8,378.64 $8,378.64 $8,378.64 $8,377.58 $326,121.30 $2,422.25 $620.00 $0.00 $22,850.00 $5,832.50 $246.00 $88,230.00 $82,727.55 $65,126.70 $49.50 $8,466.25 $20,343.50 $4,973.76 $1,279.00 $3,500.48 $275,741.80 $5,976.90 $43,622.25 $186,323.25 $289,357.06 $346,090.97 $20,587.50 $233,387.86 $14,002.25 $1,439.50 $78,572.50 $59,188.05 Prepared by; Information Technology; 10/20/2015 Page 1 of 13 4th Quarter 2015.xls $99.00 $0.00 $3,648.00 $0.00 $4,502.12 $13,118.89 $0.00 $14,003.74 $1,854.75 $2,285.75 $66,895.14 $4,864.23 $7,136.00 $11,239.85 $117,427.17 $632.00 $81.50 $34,408.89 $849,536.30 $390.00 $1,286.00 $4,803.00 $7,087.70 $19,993.75 $47,644.55 $2,859.75 $49,898.90 $15,169.25 $8,960.75 $327,585.73 $33,404.90 $19,720.00 $47,887.65 $516,450.63 $632.00 $557.25 $185,827.05 $3,510,751.04 CUST # FUND # ACCOUNT # INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 4TH QUARTER 2015 DIVISION 4th Qtr 2015 Jul - Sep Y.T.D. 710 101 10100-1070501-174000-773630 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 348 101 10100-4030301-112620-773630 445 101 10100-1030803-184025-773630 600 101 101 00-70101 01 -1 86040-773630 627 101 10100-7010110-186130-773630 910 101 10100-1070301-132050-773630 730 101 10100-6010101-155010-773630 Health Fund [2211 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 MSU Extension - Oakland 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 Sheriff - Corrective Serv Admin 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: $33,878,75 $127,159.50 $56,391.63 $353,111.67 $90,270.38 $480,271.17 $6,326.75 $79,240.50 $0.00 $0,00 $6,326.75 $79,240.50 $946,133.43 $4,070,262.71 $946,133.43 $4,070,262.71 Prepared by; Information Technology; 10/2012015 Page 2 of 13 4th Quarter 2015.xls ($946,133.43) ($4,070,262.71) $0.00 $0.00 $1,408.00 $21,535.50 $0.00 $18,592.80 $576.00 $27,392.00 $1,847.89 $1,353.50 $0.00 $40,526.50 $4,502.12 $23,907.90 $148,280.50 $0.00 $81,240.39 $52,707.14 $0.00 $63.00 $0.00 $458.25 $10,164.75 $2,587.50 ($1,840.00) $0.00 $2,385.50 $0.00 $54,015.25 $0.00 $1,408.00 $81,704.75 $0.00 $63,142.23 $1,911.00 $159,130.00 $7,037.30 $4,223.50 $0.00 $40,526.50 $19,993.75 $63,311.40 $488,488.00 $0.00 $93,037.80 $128,484.55 $0.00 $846.00 $0.00 $1,666.25 $50,303.25 $2,587.50 $479.75 $946.00 $2,519.50 $425.00 $119,783.25 $0.00 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 4TH QUARTER 2015 CUST # FUND # ACCOUNT # 10100-9090101-196030-773630 DIVISION Information Technology Development TOTAL GOVERNMENTAL: 4th Qtr 2015 Jul - Sep Y.T.D. 274 672 669 055 699 056 720 749 659 521 471 507 673 837 210 750 756 751 634 653 770 268 747 748 791 695 638 546 NON-GOVERNMENTAL DIRECT CHARGES ASAP Passport System Assessment & Tax CAMS/CVT Data Conversion CLEMIS CLEMIS - CAD CLEMIS FUND 63500 Clerk/Reg - Register of Deeds Clerk/Reg - CPL Collaborative Asset Mgt Sys (CAMS) Community Corrections - Admin (Grant) Courts-FOC Exp-CS Enforcement - EDMS (Imaging) Courts-FOC Exp-CS Enforcement Cyber Security Fund EDCA - MITradeSchool.org Grant Fire Records Management System FM&O FM&O Building Maintenance FT Telephone Communications OakVideo Upgrade (Building Authority) O.C. International Airport Parlcs and Recreation - Administration Pontiac - Meter Pontiac - Water Pontiac - Sewer Radio Communications - E911 Risk Management Tax Management System UASI Grant (Homeland Security) Page 3 of 13 4th Quarter 2015.xls Prepared by; Information Technology; 10/20/2015 4th Qtr 2015 Jul - Sep $5,013.23 $0.00 $517.50 $22,186.25 $57.50 $0.00 $0.00 $0.00 $30.00 $0.00 $0.00 $1,440.50 $384.00 $0.00 Y.T.D. $16,280.15 $0.00 $3,172.52 $35,992.50 $1,291.50 $0.00 $0.00 $0.00 $2,031.50 $0.00 $2,947.25 $2,325.48 $16,975.00 $0.00 63600-1080101-152000-631302 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 4TH QUARTER 2015 DIVISION Water Resources Accounting VVinCan Central Storage Solution VVRC Acctg - Crowder Prjct VVRC - SAW Grant Labor VVRC - AMR Support WRC - COSDA Meter Replacement WRC - CO SDS SewMet WRC - EF SOS SewMet VVRC - Data Application Pilot Poject WRC - Infrastructure Op Ar WRC - SAW Grant Labor VVRC - SAW Grant Labor - Common to All WRC - SCADA Common WRC SCADA Engineering Assessment CUST # FUND # 656 736 670 674 734 745 728 729 737 671 674 686 739 738 ACCOUNT # SUB-TOTAL DIRECT CHARGES FOR DEVELOPMENT $521,333.47 $1,412,971.18 TOTAL COUNTY DEVELOPMENT CHARGES $1,467,466,90 $5,483.233.89 NON-COUNTY AGENCIES 63600-1080101-152000-635017 Non-County Agencies $17,184.00 $72,118.75 Page 4 of 13 4th Quarter 2015.xls Prepared by; Information Technology; 10/20/2015 $1304.39 $69,966.00 $21,070.25 $92,340.64 $362.25 $6,326.75 $0.00 $0.00 $2,902.75 $362.25 56.326.75 $0.00 $0.00 $2.902.75 $5.145.28 $0.00 $24,638.50 $1,304.39 $21,854.75 $1,920.23 $1,304.39 $2,211.50 $0.00 $5,145.28 $0.00 $24,638.50 $23,159.14 $5,436.12 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2015 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 Cleric! Rag - 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 Sewer Supp - Vital Stets 3.5% 95161 Clerk.Reg - Vital Statistics Clerk - Vital Statistics - Total 23003 Oracle Support-Comm Corr - 5.2% 24012 SQL Sewer Supp - Community Corr 3.5% 52200 Comm Corr-Admin (County) 52201 Comm Corr- DVV Support Community Corrections - Total cust # GOVERNMENTAL FUNDS 630 ANIMAL CONTROL 005 BD OF COMMISSIONERS 665 CHILDRENS VILLAGE 668 CHILDRENS VILLAGE ADMIN 725 CLERK/REG - ADMIN 440 CLERK/REG - ELECTIONS DIVISION 722 CLERK/REG - EDMS (IMAGING) 410 CLERK/REG - JURY COMMISSION 724 CLERK/REG - LEGAL RECORDS 723 CLERK - VITAL STATISTICS 522 COMMUNITY CORRECTIONS-ADMIN (COI 620 COMPLIANCE OFFICE - AUDITING 44034 Auditing - New Development $0.00 Prepared by; Information Technology; 10120/2015 Page 5 01 13 4th Quarter 2015.xls 785 ECONOMIC DEVELOPMENT & COMMUNITY AFFAIRS 36500 GIS Implementation Support C&E Dev 36501 CED Application -1-1/W Support 95785 Comm & Eco Developmt Economic Development & Community Affairs - Total 95468 Auditing Internal Srv - Cust 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 OCT-Courts/Criminal 23010 Oracle Support-CCT/CTS Crim VVhse 2.6% CTS-Business Division - Total 24009 SQL Sew Supp CTS-Jud Sup Adm - 3_5% CTS-FD-Judicial Support-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 Adrnin - Total $0.00 $1,889.00 $9,040.00 $544.50 $44.00 $1,088.14 $1,304.39 $71,305.75 $1,920.23 $5,392.12 $28,534.00 690 COMPLIANCE OFFICE - PURCHASING 430 CORPORATION COUNSEL 016 COUNTY EXECUTIVE 450 C1RC 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-JUD1CIAL ADMIN $0.00 51.86900 $9 040.00 $544.50 $44.00 $128.00 $960.14 $1,304.39 $71,305.75 $1,920.23 $5,392.12 $512.00 $7,392.00 $20.630.00 740 EQUALIZATION 23012 Oracle Support-Equalization - 5.2% 24005 SQL Sewer 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 96699 BS&A Master Appraisal Sup/Maint $1,920.23 83,913.01 $11,141.50 $4,872.00 $25,733.75 812,038.03 $7,365.51 $7,070.14 $0.00 $0.00 $11.030.50 Page 6 of 13 4th Quarter 2015.xls Prepared by; Information Technology; 10/2012015 Equalization - Total $85,084.67 660 FISCAL SERVICES ADMIN 840 HEALTH DIVISION 843 HEALTH - ENVIRONMENTAL 500 HOMELAND SECURITY 680 HUMAN RESOURCES 907 LIBRARY - LIBRARY ADMIN 824 LIBRARY SERVICES 565 MARKETING & COMMUNICATIONS 872 MEDICAL EXAMINER 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 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 61001 Library Services Library Services - Total 56600 Marketing & Communications Marketing & Communications - Total 24002 SQL Server Support - Medical Exam - 3.5% 87202 Medical Examiner - Customer Support $5,760_78 $1,920.23 $652.27 $26,584.50 $5,819.00 $0.00 $0.00 $0.00 $22,731.70 $11.366.85 $0.00 $22,226.75 $11,653.00 $1,920.23 $5,217.24 $48,961.91 $292.25 $0.00 $632800 $5,027.00 $1,920.23 $652.27 $62,474.00 $27,233.82 $4,088.75 $1,304.50 $8.820.25 $1,304.39 $4,492.50 $74,834.33 $33,878.75 $56,391.63 $11,355.90 $92,280.32 $4,088.75 $1,304.50 $8,820.25 Page 7 of 13 4th Quarter 2015.xls Prepared by; Information Technology; 10/20/2015 710 MSU EXTENSION - OAKLAND Medical Examiner - Total 95676 MSU Ext Equipment Maintenance MSU Extension - Oakland - Total $99.00 $5,796.89 $99.00 163 OCSO-CLEMIS FORENSIC LAB 1MS 16300 OCSO-CLEMIS Forensic Lab OCSO-CLEMIS Forensic Lab IMS - Total 95600 PEDS Cust/System Support Planning & Eco Development - Total $0.00 775 PLANNING & ECO DEVELOPMENT 53 648.00 $0.00 $3,648.00 512 PROB-ESTATES/MENTL HLTH EDMS {NG) 95207 PC-E/MH EDMS Support & Mtce Prob-Est/NIntl Hlth EDMS (1mg) - Total $4 502 12 $4,502.12 510 PROS-ESTATES/MENTL HLTH SUPPORT 24010 SQL Serv Supp-PCT-Est/Mental - 3.5% 92198 Prob-Est/Mntl Hlth Support Prob-Est/Mntl Hlth Support - Total $1,304.39 $1181450 $13,118.89 481 PROB-FD JUDICIAL 95168 PC-Judicial Family Admin-Family Judges Prob - FD Judicial - Total $0.00 $0.00 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/Oriminal - 50% 23009 Oracle Suppport - OCSD/CTS Crim VVhse - 2.6% 97163 Sheriff 97164 Sheriff - Development 97165 Sheriff-DVV Support 98164 CLEMIS-Sheriff Sheriff - Total 23015 Oracle Suppport - Sheriff / CLEMIS - 5.2% 96163 Sheriff - CLEMIS Sheriff - CLEMIS - Total 34800 Inmate Phone System Sheriff - Corrective Serv Admin - Total 145 PROSECUTOR - GENERAL PROSECUTION 637 RECORDS RETENTION 650 REIMBURSEMENT 195 SHERIFF 191 SHERIFF - CLEMIS 348 SHERIFF - CORRECTIVE SERV ADMIN $1,304.39 $12,502.00 $197.35 $14,003.74 51 854.75 $1,854.75 $1,594.50 $691.25 $2,285.75 $128.00 $960.14 $1,629.25 $0.00 $1,632.00 $62,545.75 566,895.14 $1,920.23 $2.944.00 $4,864.23 57.135.00 $7,136.00 Prepared by; Information Technology; 10/20/2015 Page 8 of 13 4th Quarter 2015.xls $1,920.23 $2,608.62 $6 711.00 $11,239.85 $1,920.23 $3,840.50 $20,168.00 $12,037.97 $7,365.49 $7,070.11 $17,329.37 $4,934.50 $15,332.50 $1,751.50 $0.00 $0.00 $0.00 $0.00 $1,984.00 $17,120.00 $6,573.00 $632.00 $81.50 $1,304.39 $4,820.00 $5,597.00 $1,770.00 $20,917.50 $2 181.99 $2,181.99 $117,427.17 $632.00 $81.50 $34,408.89 $2,181.99 $2,181.99 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 - H/W Support 36602 Land System Enhancements - Tress (50%) 36702 Land System Maintenance - Treas (50%) 36802 Land System Support - Tress (50%) 44061 Tre-System/Customer Support 44062 Tre-System Maintenance 44063 Tre-System Enhancements 44064 Tre-New Development 44080 Tre-DVV 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-Landsale Treasurer -Landsale - Total 95651 Veterans Customer Support Veterans Services - Total 24008 SQL Server Supp - VVRC 3.5% 28010 WED - Customer Support 28011 Water Resource Commissioner Application 36520 GIS Implementation Support VVRC 36521 WRC Application - H/VV Support Water Resource Commissioner - Total 95527 DC Suprt- 5211 - 25% 52/1 District Court - Total 95528 DC Suprt- 5212 - 25% 52/2 District Court - Total 445 SUPPORT SERVICES 600 TREASURER 627 TREASURER - LAN DSALE 910 VETERANS SERVICES 730 WATER RESOURCE COMMISSIONER 540 52/1 DISTRICT COURT - NOVI 550 52/2 DISTRICT COURT - CLARKSTON 560 52/3 DISTRICT COURT - ROCHESTER 95288 52 Dist Ct Div 3 95529 DC Suprt - 52/3 - 25% 62/3 District Court - Total $0.00 $2,181.99 $2,181.99 Prepared by; Information Technology; 10/20/2015 Page 9 of 13 4th Quarter 2015.xls 95530 DC Suprt- 5214- 25% 52/4 District Court - Total 97274 ASAP Passport System ASAP Passport System - Total 67200 Assessment & Tax Assessment & Tax - Total 23004 Oracle Support - OakVideo CLEMIS 5.2% 23018 Oracle Support - Sheriff CLEMIS 5.2% 24004 SQL Server Support - 24.5% 95430 CLEMIS Maintenance 95431 CLMS Enhancements 98003 CLEWS User Support 98005 CLEMIS - E911 Support CLEMIS - Total 98006 CLEWS - CAD Development CLEMIS - CAD Total 63500 CLEWS Fund CLEMIS 63500 Fund - Total 24003 SQL Server Supp - ROD 3.5% 36510 GIS Implementation Support 36511 ROD Application - I-11W Support 95493 ROD System Maintenance 95498 Clerk/Reg - ROD Clark/Reg of Deeds - Total 74900 Clerk/Reg - CPL Clerk/Reg - CPL - Total 530 52/4 DISTRICT COURT - TROY cust # DIRECT FUNDS 274 ASAP PASSPORT SYSTEM 672 ASSESSMENT & TAX 055 CLEWS 699 CLEWS - CAD 056 CLEWS FUND 63500 720 CLERK [REGISTER OF DEEDS 749 CLERK/REG CPL $2 181 78 $218178 $1.408.00 $1408.00 $21,535_50 $21,535.50 $1,920.23 $1,920.57 $9,130.25 $3,253.75 $448.00 $1,920.00 $0.00 $18,592.60 $57600 $576.00 $27,392.00 $27,392.00 $1,304.39 $160.00 $383.50 $0.00 $0.00 $1,847.89 $135350 $1,353.50 669 CAMS/CVT DATA CONVERSION 659 COLLABORATIVE ASSET MGT SYS 66901 CAMS/CVT Data Conversion CAMS/OVT Data Conversion - Total $0.00 $0.00 65901 Collabortive Asset Mgt Sys Collabortive Asset Mgt Sys - Total $0.00 $0.00 471 CTS-FOC-EXP-CS ENFORC-EDMS (IMG) 92194 CTS-FOC-CS ENF-EDMS Support/Maintenance/Upgrades CTS-FOC Exp-CS Enfcrc-EDMS (Img) - Total $4 502.12 $4,502.12 Prepared by; Information Technology; 10120/2015 Page 10 of 13 4th Quarter 2015 xls 92193 CTS-FOG Exp-CD Enforc-Dev CTS-FOC Exp-CD Enforc-Dev - Total 52100 Community Corrections C"Star EB 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 95404 SQL Server Support - FRMS 3.5% 24001 FRMS - Phase II Proj Fire Records Management System - Total 21001 Facilities Maintenance & Operations 24013 SQL Server Supp - EMU) 75503 FM&O Development FM&O - Total 75600 FM&O Building Maintenance FM&O Building Maintenance - Total 75102 Telephone Communications - Customer Support IT - Telephone Communications - Total 507 CTS-FOC EXP-CS ENFORCEMENT 521 COMM CORR - ADM {GRANT1 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 $23,907.90 $23,907.90 $40 526.50 $40,526 50 $14828050 $14828050 $0.00 $0.00 $192.00 $79,744.00 $1 304.39 $81,240.39 $0.00 $1,304.39 $51 402 75 $52,707.14 $0.00 $0.00 $63.00 $63.00 634 OAKVIDEO UPGRADE (BAI 63400 CLEMIS - OakVideo Upgrade $0.00 63401 IT - OakVideo Upgrade $0.00 OakVideo Upgrade (BA) - Total $0.00 653 0.C. INTNL AIRPORT 36540 GIS Implementation Support 65301 Airport User Support O.C. Intl! Airport - Total $0.00 $458.25 $458.25 770 PARKS AND RECREATION 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 $320.00 $832.00 $0.00 $0.00 $0.00 $9.012.75 $10,164.75 268 PONTIAC METER 74268 Pontiac BSA to VVRC - Water Pontiac Meter - Total $2.587.50 $2,587.50 Prepared by; Information Technology; 10/20/2015 Page 11 of 13 4th Quarter 2015.xls f$1 .840.00) $0.00 $2,385.50 $0.00 $54015.25 $1,920.23 $2,837.00 $256.00 {S1,840,00) $0.00 $2,385.50 $0.00 $54,015.25 $5,013.23 74701 Pontiac BSA to VVRC - Water Pontiac Water - Total 74702 Pontiac BSA to VVRC - Sewer Pontiac Sewer - Total 79101 Radio Communications - E911 Radio Communications - E911 - Total 44036 Rsk-System Customer Support Risk Management - Total 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 BI Water Resources Accounting - Total 747 PONTIAC WATER 748 PONTIAC SEWER 791 RADIO COMMUNICATIONS -E911 695 RISK MANAGEMENT 638 TAX MANAGEMENT SYSTEM 656 WATER RESOURCES ACCOUNTING 736 W1NCAN CENTRAL STORAGE SOLUTION 73601 WinCan Central Storage Solution VVinCan Central Storage Solution - Total $0.00 $0.00 570 WRC ACCTG - CROWDER PIRJCT 60001 VVRC - Crowder NetBase Project 67000 WRC - Crowder NetBase Project VVRC Acctg - Crowder Prject - Total $517.50 $0.00 $517.50 674 WRC - SAW GRANT LABOR 28674 VVRC - SAW Grant Labor WRC -SAW Grant Labor-Total $22 186 25 $22,186.25 686 WRC - SAW GRANT LABOR - COMMON TO ALL 60002 VVRC - SAW Grant Labor - Common to All 12636 VVRC - SAW Grant - Common to All VVRC - SAW Grant Labor Common to All- Total $172.50 $1,268.00 $1,440.50 $57.50 734 WRC - AMR SUPPORT 73401 WRC - AMR Support WRC - AMR Support - Total $57.50 745 WRC - COSDA METER REPLACEMENT 728 WRC - CO SOS SEWMET 74500 WRC - CODSA Meter Replacement WRC - COOSA Meter Replacement - Total 72201 MARS Enhancements - WRC C-0 WRC - CO SDS SewMet - Total $0.00 $0.00 $0.00 $0.00 729 WRC - EF SOS SEWMET 72202 MARS Enhancements - VVRC E-F $0.00 VVRC - EF SOS SewMet - Total $0.00 Prepared by; Information Technology; 1012012015 Page 12 of 13 4th Quarter 2015.xls 737 WRC - DATA APPLICATION PILOT PRJ 73700 VVRG - Data Application Pilot Project 73710 VVRG - Data Appl Prj VVRC - Data Application Pilot Pr j - Total $0.00 $30.00 $30.00 671 WRC - INFRASTRUCTURE OP AR 739 WRC - SCADA COMMON 738 WRC - SCADA ENGINEERING ASSESSMT 67100 WRC - 10 AR VVRC - Infrastructure Op Ar - Total $0.00 $0.00 73900 VVRC - SCADA Common VVIRC - SCADA Common - Total 73800 WRC - SCADA Engineering Assesmnt WRC - SCADA Engineering Assesmt - Total $384.00 $384_00 $0.00 519,925.47 Prepared by; Information Technology; 1012012015 Page 13 of 13 4th Quarter 2015.xls Resolution #15273 November 12, 2015 Moved by Spisz supported by Quarles the resolutions (with fiscal notes attached) on the Consent Agenda be adopted (with accompanying reports being accepted). AYES: Dwyer, Fleming, Gershenson, Gingell, Gosselin, Hoffman, Jackson, KowaII, Long, McGillivray, Middleton, Quarles, Scott, Spisz, Taub, Weipert, Woodward, Zack, Bowman, Crawford. (20) NAYS: None. (0) A sufficient majority having voted in favor, the resolutions (with fiscal notes attached) on the Consent Agenda were adopted (with accompanying reports being accepted). Pi/ 3/(0- I HEREBY APPROVE THIS RESOLUTION CHIEF DEPUTY COUNTY EXECuTio; ACTING PURSUANT TO MCL. 46,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 November 12, 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 12th day of November 2015. Lisa Brown, Oakland County