Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Resolutions - 2018.08.09 - 23719
MISCELLANEOUS RESOLUTION #18289 August 9, 2018 BY: Commissioner Thomas Middleton, Chairperson, Finance Committee IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY — THIRD QUARTER 2018 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 2018 development charges to be $1,136,666.33 for the General Fund/General Purpose County departments; and WHEREAS direct charges to Special Revenue and Proprietary fund departments are $692,794.92 and non-county agencies are $7,426.25 for the Third Quarter 2018; 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 2018 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 2018 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. ommissioner Thomas Middleton, District #4 Chairperson, Finance Committee FINANCE COMMITTEE VOTE: Motion carried unanimously on a roll call vote. 540 550 560 530 630 005 450 184 718 725 291 722 440 410 724 723 522 620 690 430 506 483 482 015 495 498 502 493 785 740 660 900 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 CUST FUND# ACCOUNT INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY THIRD QUARTER 2018 DIVISION 3rd Quarter Apr -Jun Y.T.D. GOVERNMENTAL FUNDS General Fund 11011 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-2010210-132300-773630 10100-2010210-125000-773630 10100-2010201-180000-773630 10100-2010401-172190-773630 10100-2010210-125000-773630 10100-2010301-185010-773630 10100-2010501-125000-773630 10100-2010210-125000-773630 10100-2010205-132305-773630 10100-1070401-113000-773630 10100-1010201-181010-773630 10100-1010210-182090-773630 10100-1010501-181020-773630 10100-3010401-121220-773630 10100-3010403-121100-773630 10100-3010403-121240-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 5211 - District Court 5212 - District Court 52/3 - District Court 52/4 - District Court Animal Control Bd of Commissioners Circuit Court Probation North Clerk's - County Clerk Clerk E-Services Clerk/Reg - Admin Clerk Register 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-Fam Div-Judicial Support CTS-FD-Judicial Support-ADM CTS-FD-Juvenile Support 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 $5,032.38 $12,566.90 $5,032.38 $12,566.90 $5,032.38 $12,566.90 $5,031.36 $12,564.55 $38,094.46 $96,180.08 $14,946.75 $39,978.75 $31.00 $62.00 $1,176.27 $1,176.27 $2,445.00 $2,445.00 $0.00 $0.00 $6,281.81 $6,281.81 $2,636.05 $71,995.92 $2,764.17 $11,992.92 $0.00 $0.00 $50,194.75 $122,708,50 $17,089.70 $47,788.07 $30,168.96 $84,082.43 $188.50 $1,211.00 $12,217.75 $19,320.75 $8,324.25 $14,281.00 $0,00 $0.00 $33.46 $262.83 $0,00 $0.00 $110.25 $477.75 $0.00 $0.00 $132,231.88 $421,086.06 $26.75 $737.60 $24,313.73 $93,272.60 $1,141.50 $2,910.50 $77,981.07 $219,683.43 $119,048,84 $344,627.94 $22,116.50 $50,376,25 3rd Quarter 201B.pdf Prepared By: Information Technology, 71181201B Page 1 of 21 ACCOUNT 10100-1050401-183010-773630 10100-5010303-165040-773630 10100-5010302-165020-773630 10100-10901 08-1 71030-773630 10100-1070601-132030-773630 10100-1070501-174000-773630 10100-1070501-174000-773630 10100-4030901-115140-773630 10100-1090201-171000-773630 10100-3040101-121090-773630 10100-3040403-124010-773630 10100-3040403-124010-773630 10100-3040101-121060-773630 10100-4010101-122050-773630 10100-1030803-184020-773630 10100-1020650-126020-773630 10100-4030301-112590-773630 10100-4030601-110000-773630 10100-4030301-112620-773630 10100-4030901-116240-773630 10100-4030601-110000-773630 10100-4030901-110040-773630 10100-1030803-184025-773630 10100-7010101-186040-773630 10100-7010110-186130-773630 10100-1070301-132050-773630 10100-6010101-155010-773630 10100-6010101-149920-773630 10100-6010101-174250-773630 CUST FUND# 680 907 824 565 872 296 710 163 775 479 512 510 481 145 637 650 195 191 348 988 647 206 445 600 627 910 730 742 301 '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 3rd Quarter Apr -Jun $49,076.65 $388.25 $5,853.50 $606.50 $4,958.71 $1,742.25 $0.00 $0.00 $46,956.25 $1,638.75 $2,123.61 $4,358.96 $0,00 $18,498.08 $2,793.00 $6,177.50 $68,773.37 $4,552.75 $0.00 $3,727.25 $0.00 $0.00 $8,773.89 $87,882.89 $0.00 $2,967.75 $75,480.71 $1,659.00 $1,310.68 $983,992.20 Y.T.D. $144,361.77 $1,498.00 $13,977.50 $8,799.00 $30,292.83 $2,742.75 $36.75 $3,139.90 $69,560.00 $1,638.75 $4,929.33 $21,886.58 $0.00 $42,018.20 $2,793.00 $14,648.25 $195,701.99 $32,215.60 $0.00 $7,201.75 $11,962.75 $294.00 $16,551.59 $230,902.22 $3,198.50 $3,958.50 $206,097.33 $1,659.00 $5,886.81 $2,781,157.36 $38,886.50 $132,085.12 $61,033.13 $159,625.63 3rd Quarter 201B.pdf Health Fund 12211 840 221 20221-1060201-133150-773630 843 221 20221-1060220-134390-773630 Prepared By: Information Technotogy, 711812018 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY THIRD QUARTER 2018 DIVISION Human Resources Library - Library Admin Library Services Marketing & Communcations Medical Examiner MSU - Digital Media Services MSU Extension - Oakland OCSO - CLEWS Forensic Lab IMS Planning & Economic Development Probate ED Judicial Support 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 - CLEM1S Sheriff - Corrective Serv Adrnin Sheriff - IFS Div Lab Sheriff - Patrol Serv - LE Admin Sheriff - LE Support- Serv Admin Support Services Treasurer Treasurers - Landsale Veterans Services Water Resource Commissioner WRC - CAMS Software Support & Maintenance WRC - Soil Erosion Software Sol Sub-Total Fund 101 Health Health Environmental Page 2 of 21 3rd Quarter Apr -Jun $771.75 $100,691.38 $51,982.75 $0.00 $51,982.75 Y.T.D. $771.75 $292,482.50 $125,375.00 $0.00 $125,375.00 $1,136,666.33 $3,199,014.86 $1,136,666.33 $3,199,014.86 (31,136.666.33) ($3.199,014.86) $0.00 $0.00 $0.00 $0.00 $32,516.25 $103,896.25 $0.00 $160.00 $7,271.75 $20,948.75 $0.00 $0.00 $30,315.19 $66,596.39 $0.00 $0.00 $15,599.08 $60,544.33 $112,215.75 $273,925.75 $0.00 $0.00 $1,025.46 $3,789.33 $2,866.50 $2,946.50 $5,778.00 $5,778.00 $0.00 $120.00 $0.00 $0.00 3rd Quarter 2018.pdf Juvenile Maintenance Fund [2931 665 293 20293-1060501-112090-773630 668 293 20293-1060501-112010-773630 63600-1080101-152000-631365 10100-9090101-196030-773630 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY THIRD QUARTER 2018 DIVISION Health Website Redesign 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 TOTAL GOVERNMENTAL: ASAP Passport System Assessment & Tax Augusta SAW Grant CAMP CTA DR Equipment CAMS/CVT Data Conversion CLEMIS CLEMIS - CAD CLEMIS/FRMS NON-BILLABLE CLEMIS FUND 63500 Clerk/Reg - CPL Clerk/Reg - Register Of Deeds Collaborative Asset Mgt Sys (CAMS) Community Corrections - Admin (Grant) COSDS SAW Grant Courts-FOC Exp-CS Enforcement - EDMS (Imaging) Page 3 of 21 CUST FUND# ACCOUNT 183 221 20221-1060201-133150-773630 NON-GOVERNMENTAL DIRECT CHARGES 274 672 935 944 669 055 699 448 056 749 720 659 521 937 471 Prepared By: Information Technology, 7/1812018 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY THIRD QUARTER 2018 DIVISION Courts-FOC Exp-CS Enforcement Cyber Security Fund Drain Equipment Fund Drain Equip Map EDCA - MITradeSchool.org Grant Fire Records Management System FM&O FM&O Building Maintenance FOC Security Audit Franklin SAW Grant Health Immunization Grant HIPAA Enhancements II Imaging Project IT Telephone Communications Leasetrack OakVideo Upgrade (Building Authority) OAKWIN Radio System Enhancement O.C. International Airport OLV SDS SAW Grant Parks and Recreation - Administration P&R Capital Improvement P&R EMS Upgrade P&R Lyon Oaks Conf Ctr CIP#2469 P&R Lyon Oaks Conf Ctr CIP#2468 P&R Springfield Oaks CIP#2471 P&R Springfield Oaks CIP#2470 P&R Red Oaks Clubhouse CIP#2467 Pontiac - Meter Pontiac - Water Pontiac - Sewer Pontiac Water Asset Mgmt Pontiac VVVVTP Transaction Public Health Grant 795 Radio Communications - E911 3rd Quarter Apr - Jun $8,941.61 $0.00 $240.00 $0.00 $0.00 $1,452.46 $63,779.21 $0.00 $1,636.63 $0.00 $0.00 $156,488.50 $108,530.75 $0.00 $1,926.75 $0.00 $15,593.25 $453.25 $0.00 $19,286.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8,210.00 $0.00 $0.00 $0.00 $0.00 $9,230.00 $4,673.75 Y.T.D. $27,539.83 $0.00 $240.00 $0.00 $0.00 $1,965.83 $183,275.83 $0.00 $11,016.63 $0.00 $0.00 $406,282.25 $282,644.75 $330.00 $1,926.75 $0.00 $34,297.25 $3,607.75 $0.00 $49,085.25 $0.00 $260.00 $0.00 $0.00 $0.00 $0.00 $0.00 $35,948.00 $0.00 $0.00 $0.00 $0.00 $13,260.00 $34,995.75 GUST FUND# ACCOUNT 507 673 931 933 837 210 750 756 963 942 380 947 338 751 185 634 938 653 934 770 867 925 442 443 454 456 457 268 747 748 936 329 906 791 Prepared By: Information Technology, 7/18/2018 Page 4 of 21 3rd Quarter 2018.pdf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY THIRD QUARTER 2018 3rd Quarter CUST FUND# ACCOUNT DIVISION Apr -Jun Y.T.D. $73,50 $12,984.75 $34,023.50 $1,582.50 $0.00 $5,313.50 $2,596.75 $0.00 $0.00 $4,842.50 $2,092.75 $0.00 $0.00 $0.00 $1,200.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $840.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8,338.75 695 Risk Management 638 Tax Management System 973 UCC Program II 656 Water Resources Accounting 736 VVinCan Central Storage Solution 930 Water and Sewer-General Adm 939 Water and Sewer General Administration 974 Water and Sewer Gen Admin-WMU 670 WRC Acctg - Crowder Prjct 929 VVRC Aeration Tank Rehab 940 WRC - CAMP 926 WRC CLINTON-OAKLAND SCADA 932 WRC CLINTON-OAK SDS SCADA Main 281 WRC 377 WRC - SAW ACACIA 382 WRC - SAW Birmingham 379 VVRC - SAW Commerce Township 387 WRC - SAW Evergreen Farmington 389 WRC - SAW Lake Orion 388 WRC - SAW Novi 386 WRC - SAW Orchard Lake 674 WRC - SAW Grant Labor 381 WRC SAW GWK 895 WRC AGO 734 WRC - AMR Support 980 WRC Bingham Farms SAW 745 WRC - COSDA Meter Replacement 728 WRC CO SDS SewMet 729 WRC - EF SDS SewMet 737 WRC - Data Application Pilot Poject 300 WRC - GIS Allocation by Labor 277 WRC GWK PCF-WRC SCADA 295 WRC - HACK WIMS Implementation 894 WRC - HACH WIMS Implementation Phase 11 Prepared By: Information Technology, 7/18/2018 Page 5 of 21 $73.50 $54,466.75 $71,924.25 $6,275.85 $0.00 $5,313.50 $2,596.75 $112.00 $0,00 $6,485.50 $2,092.75 $800.00 $0.00 $0.00 $3,107.00 $360.00 $0.00 $3,948.75 $2,676.25 $4,565.50 $148.75 $0.00 $0.00 $2,020.00 $664.25 $2,461.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0,00 $0.00 $18,183.25 3rd Quarter 2018.pdf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY THIRD QUARTER 2018 ACCOUNT 63600-1 080101-1 52000-631 302 DIVISION WRC - Hydro Drain Project WRC - Infrastructure Op Ar VVRC - MISS DIG Ticket Mgmt Sys WRC Oxford Twp SAW WRC Permitting Implementation WRC Royal Oak Twp SAW WRC - SAW Grant Labor - Common to All WRC SAW Huron Rouge WRC SAW Bloomfield Village WRC - SCADA Common WRC - SCADA Engineering Assessment WRC - SCADA Maintenance 3rd Quarter Apr-Jun $0.00 $0.00 $0.00 $0.00 $8,050.78 $0.00 $2,782.50 $0.00 $0.00 $0.00 $0.00 $43.00 Y.T.D. $0.00 $0.00 $0.00 $2,620.25 $15,252.26 $160.00 $11,409.50 $2,383.75 $640.00 $0.00 $0.00 $3,982.25 GUST FUND# 733 671 299 981 979 986 686 402 403 739 738 368 SUB-TOTAL DIRECT CHARGES FOR DEVELOPMENT $692,794.92 $1,850,004.78 TOTAL COUNTY DEVELOPMENT CHARGES $1,829,461,25 $5,049,019.64 NON-COUNTY AGENCIES 63600-1080101-152000-635017 Non-County Agencies $7,426.25 $16,522.75 Prepared By: Information Technology, 7/1812018 Page 6 of 21 3rd Quarter 2018.pdf Page 7 of 21 3rd Quarter 2018.pdf Prepared By: Information Technology, 7/18/2018 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - THIRD QUARTER 2018 24017 SQL Server Supp - Animal Control 95628 Animal Control 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 96184 Clerk's - County Clerk Cleric's - County Clerk - Total 72500 Clerk -Admin Clerk/Reg - Admin - Total 95443 Clerk/Reg - Elections Division Clerk/Reg - Elections Division - Total 95158 Clerk/Reg - EDMS Support/Maintenance/Upgrades 13001 Clerk's Efiling Clerk/Reg - EDMS (Imaging) - Total 71800 Clerk/Reg - E-Services Clerk/Reg - E-Services - Total 95512 Clerk/Reg - Jury Commission Clerk/Reg - Jury Commission - Total 95189 Circuit Court System Clerk/Reg - Legal Records - Total 95291 Clerk Register of Deeds Admin Clerk Register of Deeds Admin - Total 24015 SQL Server Supp - Vital Stats 3.5% 95161 Clerk.Reg - Vital Statistics 3rd Qtr 2018 $33.46 $23,884.00 $14,177.00 $14 946.75 $51,982.75 $0.00 $1.176.27 $0.00 $2,764.17 $2,426.92 $209.13 $2.445.00 $0.00 $50,194.75 $6,281.81 $33.45 $17,056.24 Cust # GOVERNMENTAL FUNDS 630 ANIMAL CONTROL 005 BD OF COMMISSIONERS 665 CHILDRENS VILLAGE 668 CHILDREN'S VILLAGE ADMIN 184 CLERK'S - COUNTY CLERK 725 CLERK/REG - ADMIN 440 CLERK/REG - ELECTIONS DIVISION 722 CLERK/REG - EDMS (IMAGING) 718 CLERKIREG - E-SERVICES 410 CLERK/REG - JURY COMMISSION 724 CLERK/REG - LEGAL RECORDS 291 CLERK REGISTER OF DEEDS ADMIN 723 CLERK - VITAL STATISTICS $38,094.46 $14,946.75 $51,982.75 $0.00 $1,176.27 $0.00 $2,764.17 $2,636.05 $2,445.00 $0.00 $50,194.75 $6,281,81 $5,547.50 $6,670.25 $8.324.25 $110.25 $31.00 $12217.75 $8,324.25 $110.25 $31.00 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2018 Clerk - Vital Statistics - Total $17,089.70 522 COMMUNITY CORRECTIONS-ADM1N (CO) 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 $26/5 $33.46 $30,108.75 $0.00 $30,168.96 620 COMPLIANCE OFFICE - AUDITING 44034 Auditing - New Development $0.00 95468 Auditing Internal Srv - Cust Sup $188.50 Compliance Office - Auditing - Total $188.50 690 COMPLIANCE OFFICE - PURCHASING 430 CORPORATION COUNSEL 015 COUNTY EXECUTIVE 450 C1RC CT PROBATION - NORTH 44028 Purchasing System Enhancements 44029 Pur-New Development 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 495 CTS-BUSINESS DIVISION 12002 CCT-Courts/Criminal $0.00 23010 Oracle Support-CCT/CTS Crim Whse 2.6% $0.00 CTS-Business Division - Total $0.00 506 CTS-FAM DIV-JUDICIAL SUPPT 951954 Circuit Court Admin CTS-Pam Div-Judicial Support - Total $0,00 483 CTS-FD-JUDICIAL SUPPORT-ADM 24009 SQL Serv Supp - CTS-Jud Sup Adm - 3.5% $33.46 CTS-FD-Judicial Support-Adm - Total $3346 482 CTS-FD JUVENILE SUPPORT 48200 CTS-Jud Support - Juv Support $0.00 CTS-Jud Support Juv Support - Total $0.00 498 CTS-GEN JURIS-JUDICIAL SUPPT 14001 CTS-DW Support/Circuit 23010 Oracle Supp-CCT 95179 CTS-Gen Juris-Judicial Suppt CTS-Gen Juris-Judicial Suppt - Total $0.00 $13.37 $132,218.51 $132,231.88 502 CTS-GJ-JURY OPERATIONS 23008 Oracle Support-CTS-GJ-Jury Operations $26.75 Prepared By: Information Technology, 7/1812018 Page 8 of 21 3rd Quarter 2018.pdf 493 CTS-JUDICIAL ADMIN 13002 49300 95174 Court's - Efiling Courts Web Redesign CTS-Judicial Admin CTS-Judicial Admin - Total $209.12 $10,705.25 $13,399,36 $24,313.73 785 ECONOMIC DEVELOPMENT & COMMUNITY AFFAIRS 36500 GIS Implementation Support C&E Dev $1,141.50 36501 CED Application - HNV Support $0.00 95785 Comm & Eco Developmt $0.00 Economic Development & Community Affairs - Total $1.141.50 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - THIRD QUARTER 2018 CTS-GJ-Jury Operations - Total $26.75 23012 Oracle Support-Equalization - 5.2% 24005 SQL Server Supp-Equalization - 10.5% 31075 Equal - Development 36505 GIS Implementation Support Equalization 36506 Equal Application - HNV Support 36507 Equal LAMS Support 36601 Land System Enhancements - Equal (50%) 36701 Land System Maintenance - Equal (50%) 36801 Land System Support - Equal (50%) 36902 BS&A Orion Twp 50101 EQUAL (BS&A ANNUAL) 95562 Equalization - DVV 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 $26.75 $100.35 $8,826.00 $852.00 $8,362.50 $10,326.50 $14,329.84 $1,366.14 $5,431.39 $0.00 $6,356.85 $0.00 $0.00 $22.002.75 $77,981.07 $80.27 $26.75 $16.72 $31,942.00 $10,631.25 $3,932.25 $2,054.75 $0.00 $46,909.90 $23.454.95 $119,048.84 $0.00 $17,668.00 $21.218.50 $38,886.50 740 EQUALIZATION 660 FISCAL SERVICES ADMIN 840 HEALTH DIVISION Prepared By: Information Technology, 711812018 Page 9 of 21 3rd Quarter 2018.pdf $26.75 $133.77 $50,397.86 $10,474.75 $61,033.13 $771.75 $771.75 640425 $4,714.25 $16,998.00 $22,116.50 $26.75 $16.72 649,033.18 $0.00 $358.25 $5853.50 $606.50 $33.46 $4,925.25 $1,742.25 $0.00 $0.00 $46.956.25 $49,076.65 $38825 $5,853.50 $606.50 $4,958.71 $1,742.25 $0.00 $0.00 $46,956.25 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - THIRD QUARTER 2018 23005 Oracle Support - EH Projects - 5.2% 24014 SQL Server Suppt - Ehealth 14% 84200 EH - Projects 84300 Ehealth Program Health-Environmental - Total 96183 Health VVebsite Redesign Health VVebsite Redesign - Total 36545 GIS Implementation Support Homeland Security 36546 Homeland Security Application - H/VV Support 98990 Homeland Security Homeland Security - Total 23014 Oracle Support-RR/Personnel - 5.2% 24007 SQL Server Supppoit-HR/Personnel - 1,75% 44044 HR- New Development 96002 Human Res-Personnel 40% Human Resources - Total 91405 Library Board Library - Library Adrnin - Total 61001 Library Services Library Services - Total 56500 Marketing & Communications Marketing & Communications - Total 24002 SQL Server Support - Medical Exam - 3.5% 87202 Medical Examiner - Customer Support Medical Examiner - Total 22296 MSU - Digital Media Services MSU - Digital Media Services - Total 95676 MSU Ext Equipment Maintenance MSU Extension - Oakland - Total 16300 OCSO-CLEMIS Forensic Lab OCSO-CLEMIS Forensic Lab IMS - Total 95600 PEDS Cust/System Support Planning & Eco Development - Total 843 HEALTH - ENVIRONMENTAL 183 HEALTH WEBSITE REDESIGN 900 HOMELAND SECURITY 680 HUMAN RESOURCES 907 LIBRARY - LIBRARY ADMIN 824 LIBRARY SERVICES 565 MARKETING & COMMUNICATIONS 872 MEDICAL EXAMINER 296 MSU - DIGITAL MEDIA SERVICES 710 MSU EXTENSION - OAKLAND 163 OCSO-CLEMIS FORENSIC LAB IMS 775 PLANNING & ECO DEVELOPMENT Prepared By: Information Technology, 7/18/2018 Page 10 of 21 3rd Quarter 2018.pdf $3346 $4325.50 $1 638.75 $4,358.96 $1,638.75 $0.00 $0.00 $33.46 $10,145.50 $0.00 $8,319.12 $18,498.08 $2,793.00 $0.00 $2,793.00 $5,359.00 $818.50 $6.177.50 $0.00 $13.37 $10,072.00 $0.00 $0.00 $58,688.00 $68,773.37 $26,75 $4,526.00 $0.00 $3,727.25 $4,552.75 $0.00 $3,727.25 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - THIRD QUARTER 2018 512 PROB-ESTATES1MENTL HLTH EDMS (IMG) 95207 PC-EJIVIH EDMS Support & Mtce Prob-Est/Mntl (-11th EDMS (Img) - Total $2 123 61 $2,123.61 24010 SQL Serv Supp-PCT-Est/Mental - 3.5% 92198 Prob-Est/Mntl Hlth Support Prob-Esta/Intl Hlth Support- Total 95188 PROB-FD Judicial Support PRO B-FD Judicial 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 95664 Prosecutor Warrants Prosecutor - Total 44053 REC - System Enhancements 95636 Mail Room Records Retention - Total 95470 Reimbursement System 95542 Reimburse User Support Reimbursement - Total 12001 OCSD-CourtsfCriminal - 50% 23009 Oracle Suppport - OCSD/CTS Crim VVhse - 2.6% 97163 Sheriff 97164 Sheriff- Development 97165 Sheriff-DW Support 98164 CLEMIS-Sheriff Sheriff - Total 23015 Oracle Suppport - Sheriff CLEWS - 5.2% 96163 Sheriff CLEMIS Sheriff - CLEMIS - Total 34800 Inmate Phone System Sheriff - Corrective Serv Admin - Total 16300 OCSO Clemis Forensic OC Sheriffs IFS Div - Lab - Total 510 PROB-ESTATES/MENTL HLTH SUPPORT 479 PRO B-FD JUDICIAL SUPPORT 481 PROB-FD JUDICIAL 145 PROSECUTOR - GENERAL PROSECUTION 637 RECORDS RETENTION 650 REIMBURSEMENT 195 SHERIFF 191 SHERIFF - CLEMIS 348 SHERIFF - CORRECTIVE SERV ADMIN 988 OC SHERIFF'S IFS DIV - LAB Page 11 of 21 3rd Quarter 2018.pdf Prepared By: Information Technology, 7118/2018 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - THIRD QUARTER 2018 647 OCSD PATROL SERV-LE ADIVIIN 97647 Sheriff - Patrol Serv-LE Admin 0.00 Sheriff - Patrol Serv-LE Admin - Total $0.00 445 SUPPORT SERVICES 23002 Oracle Support - Supp Serv - 5.2% 24011 SQL Server Supp - Suppt Services 7% 44500 Support Services Support Services - Total $26.75 $66.89 $8,680.25 $8,773.89 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 - Trees (50%) 36802 Land System Support - Trees (50%) 44061 Tre-System/Customer Support 44062 Tre-System Maintenance 44063 Tre-System Enhancements 44064 Tre-New Development 44080 Tre-DVV Support 44082 Tre-DVV Maintenance 44601 Bond Disclosure - Treas (50%) 50102 TREAS (BSE.A ANNUAL) 95008 Del Tax On Line 95303 Del Tax System Maintenance 95561 User Support/Del Tax 95615 BS&A Annual Tax Support Treasurer - Total $26.75 $53.50 $0.00 $14,329.41 $1,366.11 $5,431.36 $38,934.11 $73.50 $147.00 $2,284.75 $0.00 $0.00 $0.00 $6,356,65 $1,476.00 $367.50 617,036.25 $0.00 $87,882.89 627 TREASURER - LANDSALE 44083 Treasurer-Landsale Treasurer -Landsale - Total $0.00 $0.00 910 VETERANS SERVICES 95651 Veterans Customer Support $282.00 95650 Veterans Services Equipment $2,685.75 Veterans Services - Total $2,967.75 730 WATER RESOURCE COMMISSIONER 24008 SQL Server Supp VVRC 3.5% 28007 Water Resource Commission 28010 WRC - Customer Support 28011 Water Resource Commissioner Application 36520 GIS Implementation Support VVRC 36521 VVRC Application - H/W Support Water Resource Commissioner - Total $33.46 $95.00 $11,820.00 $18,807.75 $3,234.75 341.48975 $75,480.71 Prepared By: Information Technology, 7/18/2018 Page 12 of 21 3rd Quarter 2018.pdf $0.00 $32.516.25 $0.00 $7,271.75 $26.75 $26.82 $234.12 $13,522.00 $0.00 $186.50 $0.00 $11,319.00 $0.00 $32,516.25 $0.00 $7,271.75 $30,315.19 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - THIRD QUARTER 2018 742 WRC - CAMS SOFTWARE SUPPORT & MAINTENANCE 74200 VVRC CAMS SOFTWARE Support WRC CAMS SOFTWARE Support - Total 1659.00 $1,659.00 301 WRC - SOIL EROSION SOFTWARE SQL 74301 VVRC - Soil Erosion Software Sol VVRC - Soil Erosion Software Sol - Total 1,310.68 $1,310.68 540 52/1 DISTRICT COURT - NOVI 95527 DC Suprt- 5211 - 25% 5211 District Court - Total $5,032.38 $5,032.38 550 52/2 DISTRICT COURT - CLARKSTON 95528 DC Suprt- 52/2 - 25% 52/2 District Court - Total $5,032.38 $5,032.38 $1,136,566.33 560 52/3 DISTRICT COURT - ROCHESTER 95288 52 Dist Cl Div 3 $0.00 95529 DC Suprt - 5213 - 25% $5032.38 52/3 District Court - Total $5,032.38 95530 DC Suprt- 52/4 - 25% 52/4 District Court - Total 97274 ASAP Passport System ASAP Passport System - Total 67200 Assessment & Tax Assessment & Tax - Total 37935 Augusta SAW Grant Augusta SAW Grant Total 37944 Camp CTA DR Equipment Camp CTA DR Equipment - Total 23004 Oracle Support - OakVideo CLEMIS 5.2% 23018 Oracle Support - Sheriff CLEMIS 5.2% 24004 SQL Server Support - 24.5% 95430 CLEM1S Maintenance 96431 CLMS Enhancements 98003 CLEMIS User Support 98005 CLEMIS - E911 Support 98000 Poject Team CLEMIS - Total 530 52/4 DISTRICT COURT - TROY cust# DIRECT FUNDS 274 ASAP PASSPORT SYSTEM 872 ASSESSMENT & TAX 935 AUGUSTA SAW GRANT 944 CAMP CIA DR EQUIPMENT 055 CLEMIS $5,031.35 $5,031.36 Prepared By: Information Technology, 7/18/2018 Page 13 of 21 3rd Quarter 21118.pdf $0.00 37937 COSDS SAW Grant COSDS SAW Grant - Total $0.00 937 COSDS SAW GRANT $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 Enforc-EDMS (Img) - Total $6,818.00 $2,123.61 $5,778.00 $0.00 $240.00 $8,941.61 $5,778.00 $0.00 $240.00 3rd Quarter 2018.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2018 699 CLEWS - CAD 056 CLEMIS FUND 63500 448 CLEMIS/FRMS NON-BILLABLE 669 CAMS/CVT DATA CONVERSION 749 CLERK/REG - CPL 720 CLERK / REGISTER OF DEEDS 659 COLLABORATIVE ASSET MGT sys 98006 CLEMIS - CAD Development CLEMIS - CAD - Total 63500 CLEM'S Fund CLEMIS 63500 Fund - Total 44800 CLEMIS/FRMS NON-BILL CLEMIS/FRMS NON-BILL - Total 66901 CAMS/CVT Data Conversion CAMS/CVT Data Conversion - Total 74900 Clerk/Reg - CPL Clerk/Reg CPL - 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 65901 Collabortive Asset Mgt Sys Collabortive Asset Mgt Sys - Total $0.00 3112.215.75 $15,599.08 $0.00 $0.00 $33.46 $0.00 $367.50 $0.00 $624.50 $2,866.50 $0.00 $112,215.75 $15,599,08 $0.00 $0.00 $1,025.46 62,666.50 92193 CTS-FOC Exp-CD Enforc-Dev 92194 CTS-FOC Enf-EDMS 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 37931 Drain Equipment Fund Drain Equipment Fund - Total Prepared By: Information Technology, 711812018 Page 14 of 21 507 CTS-FOC EXP-CS ENFORCEMENT 521 COMM CORR - ADM (GRANT) 673 CYBER SECURITY FUND 931 DRAIN EQUIPMENT FUND INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT SUPPORT DETAIL - THIRD QUARTER 2018 933 DRAIN EQUIP MAP 37933 Drain Equip Map Drain Equip Map - Total $0.00 837 EDCA - MITRADESCHOOLORG GRANT 83700 EDCA- MITRADESCHOOL EDCA- MITracieSchootorg Grant - Total $0.00 210 FIRE RECORDS MANAGEMENT SYSTEM 21010 Fire Records Mgmt Fund 531 95404 SQL San/el- Support - FRMS 3.5% 24001 FRMS - Phase II Proj Fire Records Management System - Total $735.00 $33.46 $684.00 $1,452.46 750 FM&O 756 FM&O BUILDING MAINTENANCE 757 FM/WK RELAJAIL MGT/VIDEO CONF 963 FOC SECURITY AUDIT 942 FRANKLIN SAW GRANT 809 HEALTH-CRI 380 HEALTH-IMMUNIZATION GRANT 947 HIPAA ENHANCEMENTS II 338 IMAGING PROJECT 751 IT - TELEPHONE COMMUNICATIONS 185 LEASETRACK REPLACEMENT Prepared By: Information Technology, 7118/2018 21001 Facilities Maintenance & Operations $2,061.00 24013 SQL Server Supp - FM&O $33.46 75503 FM&O Development $61,684.75 FM&O - Total $63,779.21 75600 FM&O Building Maintenance $0.00 FM&O Building Maintenance - Total $0.00 75700 FAC MGMT-Video Arraignment $0.00 FMNVK Rel/Jail Mgt/Video Cent - Total1 $0.00 94963 FOC Security Audit $1,636.63 FOC Security Audit - Total $1,636.63 37942 Franklin SAW Grant $0.00 Franklin SAW Grant - Total $0.00 80900 Health-CRI 0.00 Health-CRI - Total $0.00 38000 Health-Immunization Grant $0.00 Health-Immunization Grant - Total $0.00 96947 HIPAA Enhancements II $156488.50 HIPAA Enhancements ll - Total $156,488.50 33800 Imaging Project $108,530.75 Imaging Project - Total $108,530.75 75102 Telephone Communications - Customer Support $0.00 IT - Telephone Communications - Total $0.00 18500 Leasetrack Replacement 1 926 75 Page 15 of 21 3rd Quarter 201B.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - THIRD QUARTER 2018 Leasetrack Replacement - Total $1,926.75 634 OAKVIDEO UPGRADE (BAI 63400 CLEM1S OakVideo Upgrade $0.00 63401 IT- OakVideo Upgrade $0.00 OakVideo Upgrade (BA) - Total $0.00 938 OAKWIN RADIO SYSTEM ENH 98938 OAKVV1N Radio System Enh OAKW1N Radio System Enh - Total $15,593.25 $15,593.25 653 O.C. INTNL AIRPORT 36540 GIS Implementation Support 65301 Airport User Support 0.C. Intnl Airport - Total $0.00 $453.25 $453.25 934 OLV SOS SAW GRANT 37934 OLV SDS SAW Grant OLV SDS SAW Grant - Total $0.00 $0.00 770 PARKS AND RECREATION 867 P&R CAPITAL IMPROVEMENT 925 P&R EMS UPGRADE 442 P&R LYON OAKS CONF CTR CIP#2469 443 P&R LYON OAKS CONE CTR CIP#2468 454 P&R SPRINGFIELD OAKS CIP#2471 456 P&R SPRINGFIELD OAKS CIP#2470 457 P&R RED OAKS CLUBHOUSE CIP#2467 Prepared By: Information Technology, 7/18/2018 36530 GIS Implementation Support Parks 44066 PRADM-System/Customer Support 44068 PRADM-System Enhancements 76100 P&R Administrative Services 77010 PRADM-Technology 95413 PRADM-Customer Support 95416 PRRA - Rec Ad min 95419 PRADM-Administration Parks & Recreation - Total 86700 P&R Capital Improvement P&R Capital Improvement - Total 37925 P&R EMS Upgrade P&R EMS Upgrade - Total 44200 P&R Lyon Oaks Conf Ctr CIP #2469 P&R Lyon Oaks Conf Ctr CIP #2469 - Total 44300 P&R Lyon Oaks Conf CTR CIP#2468 P&R Lyon Oaks Conf CTR CIP#2468 - Total 45400 P&R Springfield Oaks CIP#2471 P&R Springfield Oaks CIP#2471 - Total 45600 P&R Springfield Oaks CIP#2470 P&R Springfield Oaks CIP#2470 - Total 45700 P&R Red Oaks Clubhouse CIP#2467 $299.25 $4,986.00 $514.50 $0.00 $0.00 $13,096.25 $390.00 $0.00 $19,286.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Page 16 of 21 3rd Quarter 2018.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - THIRD QUARTER 2018 P&R Red Oaks Clubhouse CIP#2467 - Total 268 PONTIAC METER 747 PONTIAC WATER 748 PONTIAC SEWER 936 PONTIAC WATER ASSET MGMT 329 PONTIAC WWTP TRANSACTION 906 PUBLIC HEALTH GRANT 795 791 RADIO COMMUNICATIONS - E911 695 RISK MANAGEMENT 638 TAX MANAGEMENT SYSTEM 601 TREASURERS - DTRF 973 UCC PROGRAM 11 656 WATER RESOURCES ACCOUNTING 736 WINCAN CENTRAL STORAGE SOLUTION 930 WATER AND SEWER-GENERAL ADMIN 74268 Pontiac BSA to VVRC - Water Pontiac Meter - Total 74701 Pontiac BSA to VVRC - Water Pontiac Water - Total 74702 Pontiac BSA to VVRC - Sewer Pontiac Sewer - Total 37936 Pontiac Water Asset Mgmt Pontiac Water Asset Mgmt - Total 67329 Pontiac VVVVTP Transaction Pontiac WWTP Transaction - Total 96906 Public Health Grant Public Health Grant - 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 18050 Water Resource Apportionment Treasurers - DTRF Total 92973 UCC Program II UCC Program II - Total 23011 Oracle Supp - Water & Sewer Accfg - 5.2% 96669 Water Resources Accounting 95671 Drain Water/Sewer BI Water Resources Accounting - Total 73601 VVinCan Central Storage Solution VVinCan Central Storage Solution - Total 37930 Water and Sewer-General Admin Water and Sewer-General Admin - Total $8,210.00 $9,230.00 $4,673.75 $73.50 $12,984.75 $0.00 $34,023.50 $26.75 $1,555.75 $0.00 $0.00 $5,313.50 $0.00 $8,210.00 $0.00 $0.00 $0.00 $0.00 $9,230.00 $4,673.75 $73.50 $12,984.75 $0.00 $34,023.50 $1,582.50 $0.00 $5,313.50 3rd Quarter 2018.pdf Prepared By: Information Technology, 711812018 Page 17 of 21 $0.00 $0.00 $4,842.50 $840.00 $1,200.00 $2,092.75 $0.00 $0.00 $0.00 $8.338.75 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4,842.50 $840.00 $1,200.00 $2,092.75 $0,00 $0.00 $0.00 $8,338.75 $0.00 $0.00 $0.00 $0.00 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2018 939 WATER AND SEWER GENERAL ADMINISTRATION 37939 Water and Sewer General Administration $2.596.75 Water and Sewer General Administration - Total $2596.75 670 WRC ACCTG - CROWDER PRJCT 929 WRC AERATION TANK REHAB 895 WRC AGO 377 WRC - SAW ACACIA 940 WRC - CAMP 926 WRC CLINTON-OAKLAND SCADA 932 WRC CLINTON-OAK SOS SCADA MAIN 281 WRC 894 WRC - HACH WIMS IMPLEMENTATION 377 WRC - SAW ACACIA 382 WRC SAW BIRMINGHAM 379 WRC - SAW COMMERCE TOWNSHIP 386 WRC - SAW ORCHARD LAKE 674 WRC - SAW GRANT LABOR Prepared By: Information Technology, 711812018 60001 VVRC - Crowder NetBase Project 67000 WRC - Crowder NetBase Project VVRC Acctg - Crowder Prject - Total 35700 VVRC Aeration Tank Rehab VVRC Aeration Tank Rehab - Total 37895 VVRC Ago WRC Ago - Total 33377 VVRC - SAW ACACIA WRC - SAW ACACIA - Total 37940 VVRC - Camp VVRC - Camp - Total 33926 WRC Clinton-Oakland SCADA VVRC Clinton-Oakland SCADA - Total 37932 VVRC Clinton-Oak SOS SCADA Main VVRC Clinton-Oak SDS SCADA Main - Total 74281 VVRC VVRC - Total 37894 VVRC-HACH WIMS Implementation VVRC-HACH WIMS Implementation - Total 28674 VVRC - SAW Acacia VVRC - SAW Acacia - Total 33382 VVRC SAW Birmingham VVRC SAW Birmingham - Total 33379 VVRC - SAW Commerce Township VVRC - SAW Commerce Township - Total 33386 WRC - SAW Orchard Lake VVRC - SAW Orchard Lake - Total 28674 VVRC - SAW Grant Labor Page 18 of 21 3rd Quarter 2018.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - THIRD QUARTER 2018 VVRC - SAW Grant Labor - Total $0.00 381 WRC SAW GWK 33381 VVRC SAW GVVK $0.00 VVRC SAW GVVK - Total $0.00 686 WRC - SAW GRANT LABOR - COMMON TO ALL 60002 VVRC - SAW Grant Labor - Common to All 12686 VVRC - SAW Grant - Common to Al] WRC - SAW Grant Labor Common to All- Total 73401 WRC - AMR Support WRC - AMR Support - Total $0.00 $2.782.50 734 WRC - AMR SUPPORT 745 WRC - COSDA METER REPLACEMENT 728 WRC CO SDS SEWMET 729 WRC - EF SDS SEWMET $0.00 $2,782.50 $0.00 $0.00 $0.00 $0,00 74500 VVRC - CODSA Meter Replacement VVRC - CODSA Meter Replacement - Total 72201 MARS Enhancements - VVRC C-0 VVRC - CO SDS SewMet - Total 72202 MARS Enhancements - VVRC E-F VVRC - EF SDS SewMet - Total $0.00 $0,00 $0.00 737 WRC - DATA APPLICATION PILOT PRJ 73700 VVRC - Data Application Pilot Project 73710 VVRC - Data Appl Prj WRC - Data Application Pilot Pr j - Total 73300 WRC-GIS Allocation by Labor VVRC-G1S Allocation by Labor - Total $0.00 300 WRC-GIS ALLOCATION BY LABOR $0.00 0.00 $0.00 $0.00 277 WRC-GWK PCF-WRC SCADA 74277 WRC - GWK PCF-WRC SCADA VVRC - GWK PCF-VVRC SCADA - Total $0.00 $0.00 295 WRC HACH WIMS IMPLEMENTATION 67295 VVRC-HACH VVIMS Implementation 0.00 VVRC-HACH VVIMS Implementation - Total $0.00 733 WRC-HYDRO DRAIN PROJECT 671 WRC - INFRASTRUCTURE OP AR 299 WRC-MISS DIG TICKET MGMT SYS 979 WRC PERMITTING IMPLEMENTATION Prepared By: Information Technology, 7/1812018 73301 VVRC-Hydro Drain Project 0.00 VVRC-Hydro Drain Project - Total $0.00 67100 VVRC -10 AR $0.00 VVRC - Infrastructure Op Ar - Total $0,00 74299 VVRC-MISS Dig Ticket Mgmt Sys $0.00 WRC-MISS Dig Ticket Mgmt Sys - Total $0.00 74979 VVRC Permitting Implementation $8 050.78 Page 19 of 21 3rd Quarter 2018.pdf 739 WRC - SCADA COMMON INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - THIRD QUARTER 2018 VVRC Permitting Implementation - Total 73900 VVRC - SCADA Common VVRC - SCADA Common - Total 80.00 $8,050.78 $0.00 $43.00 $0.00 358 WRC - SCADA MAINTENANCE 33358 WRC - SCADA Maintenance VVRC - SCADA Maintenance - Total 73800 VVRC - SCADA Engineering Assesrnnt VVRC - SCADA Engineering Assesrnt - Total $43.00 738 WRC - SCADA ENGINEERING ASSESSMT 80.00 $692,794.92 Prepared By: Information Technology, 7/18/2018 Page 20 of 21 3rd Quarter 2018.pdf INFORMATION TECHNOLOGY DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2018 3rd Quarter Y.T.D. $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 318,998.50 $840,928.80 13,275.50 $54,187.50 44,837.25 $45,075.75 66,056.75 $224,388.25 569,814.40 $1,726,454.10 $0.00 $0.00 $0.00 $0.00 $1,012,982.40 $2,891,034.40 $77,604.75 $202,387.75 $77,604.75 $202,387.75 $126,442.00 $287,417.50 26.75 $737.60 6.17 $170.18 18.87 $148.88 4,710.00 $12,213.00 0.00 $49,667.00 67,003.25 $182,974.50 0,00 $0.00 $198,207.04 $533,328.66 1,288,794.19 $3,626,750.81 Radio 18020 IT Radio CUST FUND ACCOUN Application Services 17040 IT - TOS Fund 18000 111/EACS Data Warehouse (Funded) 19000 IT Application Services Planned Maint 30001 IT Application Services Data Warehouse 30002 IT Application Services Enhanced 30003 IT Application Services GIS 30004 IT Application Services eGovernment 25108 Courts - Oakland Schools 36901 BS&A Orion Twp - IT App Services - Sub Total: Internal Services 19020 Internal Services Planned Main Internal Services =Sub-Total: Technical Sys/Networking 19030 Tech Sys/Net Planned Maint 23007 Oracle Support - IT Tech Systems 23017 Oracle Support - IT Tech Systems 1.2% 24018 SQL Sent Support - IT Tech Systems 2% 25400 Oracle Administration 95685 1.1. - Disaster Recovery 95750 I.T. - SEP 95755 1.1. - PeopleSoft Upgrade Tech Sys/Net - Sub-Total: Information Technology - Total: Prepared By: information Technology, 711812018 Page 21 of 21 3rd Quarter 2018.pdf Resolution #18289 August 9, 2018 Moved by Long supported by McGillivray the resolutions (with fiscal notes attached) be adopted with accompanying reports being accepted. AYES: Fleming, Gershenson, Gingell, Hoffman, Jackson, Kochenderfer, KowaII, Long, McGillivray, Middleton, Quarles, Spisz, Taub, Tietz, Weipert, Woodward, Zack, Berman, 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). 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 August 9, 2018, 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 9th day of August, 2018. Lisa Brown, Oakland County