Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Resolutions - 2017.08.10 - 23046
MISCELLANEOUS RESOLUTION #17225 August 10, 2017 BY: Commissioner Thomas Middleton, Chairperson, Finance Committee IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY — THIRD QUARTER 2017 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 2017 development charges to be $1,106,670.73 for the General Fund/General Purpose County departments; and WHEREAS direct charges to Special Revenue and Proprietary fund departments are $696,025.56 and non-county agencies are $31,292.25 for the Third Quarter 2017; 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 2017 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 2017 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. Commissioner Thomas Middleton, District #4 Chairperson, Finance Committee FINANCE COMMITTEE VOTE: Motion carried unanimously on a roll call vote with KowaII absent. 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-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 VVRC - CAMS Software Support & Maintenance Fiscal Services - Admin Homeland Security Human Resources Library - Library Admin Page 1 of 17 $14,293.14 $14,293.14 $14,293.14 $14,292.08 $122,820.69 $18,474.75 $194.00 $0.00 $5,969.40 $7,556,50 $345.00 $195,558.00 $121,671.44 $55,774,58 $20,510.50 $15,363.25 $12,586.50 $0.00 $5,120.44 $0.00 $432.50 $1,981.93 $275,775.89 $5,881.39 $5,223.23 $35,186.75 $228,865.88 $160.00 $436,847.25 $45,289.75 $199,437.49 $8,341.00 3rd Quarter 2017.pdf $3,819.08 $3,819.08 $3,819.08 $3,818.76 $46,010.99 $15,254.25 $84.00 $0.00 $1,427.88 $2,082.50 $345.00 $77,035.75 $44,056.99 $19,546.00 $4,887.50 $2,208.00 $4,447.25 $0.00 $1,574.74 $0.00 $69.00 $0.00 $114,231.64 $1,917.76 $1,249.40 $11,402.75 $53,927.95 $0.00 $140,111.90 $24,109.75 $82,990.15 $2,277.00 CUST FUND# ACCOUNT INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 3rd QUARTER 2017 DIVISION 3rd Qtr 2017 Apr - Jun Y.T.D. GOVERNMENTAL FUNDS General Fund [1011 540 101 10100-3020201-121020-773630 550 101 10100-3020301-121020-773630 560 101 10100-3020401-121020-773630 530 101 10100-3020501-121020-773630 630 101 10100-1070801-114000-773630 005 101 10100-5010101-180010-773630 450 101 10100-1070901-113270-773630 725 101 10100-2010201-180000-773630 722 101 10100-2010210-125000-773630 440 101 10100-2010301-185010-773630 410 101 10100-2010501-125000-773630 724 101 10100-2010210-125000-773630 723 101 10100-2010205-132305-773630 522 101 10100-1070401-113000-773630 620 101 10100-1010201-181010-773630 690 101 10100-1010210-182090-773630 430 101 10100- 10 10501-181020-773630 506 101 10100-3010401-121220-773630 483 101 10100-3010403-121100-773630 482 101 10100-3010403-121240-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-1090101-171000-773630 740 101 10100-1020501-173010-773630 742 101 10100-6010101-149920-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 Prepared by: Information Technology 07/24/2017 ACCOUNT 10100-5010302-165020-773630 10100-10901 08-171 030-773630 10100-1070601-132030-773630 10100-1070501-174000-773630 10100-1070501-174000-773630 10100-4030901-115140-773630 10100-1090201-171000-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-4030601-110000-773630 10100-1030803-184025-773630 10100-7010101-186040-773630 10100-7010110-186130-773630 10100-1070301-132050-773630 10100-6010101-1 5501 0-773630 10100-6010101-174250-773630 GUST FUND# 824 565 872 296 710 163 775 512 510 481 145 637 650 195 191 348 647 445 600 627 910 730 301 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 3rd Qtr 2017 Ayr - Jun $0.00 $1,519.00 $7,896.74 $82.50 $0.00 $823.50 $1,941.50 $1,249A0 $7,795.74 $369.00 $15,730.99 $5,658.00 $1,329.50 $55,034.15 $2,607.76 $0.00 $599.00 $10,954.72 $66,613.98 $37,721.50 $175.50 $67,415.99 $5,934.00 $957,976.62 $64,164.80 $63,636.56 $127,801.36 Y.T.D. $771.00 $44,436.00 $20,530.19 $797.50 $546.25 $892.50 $2,217.50 $5,223.23 $24,796.19 $861.00 $56,626.44 $6,417.00 $8,852.00 $166,479.08 $12,574.39 $0.00 $4,957.00 $27,851.17 $210,277.53 $37,721.50 $1,077.75 $212,054.44 $18,268.25 $2,746,767.52 $140,850.80 $212,532.98 $353,383.78 $20,892.75 $76,882.00 $0.00 10.00 $20,892.75 $76,882.00 3rd Quarter 2017.pdf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 3rd QUARTER 2017 DIVISION Library Services Marketing & Communcations Medical Examiner MSU - Digital Media Services MSU Extension - Oakland OCSO - CLEMIS Forensic Lab IMS Planning & Economic Development 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 Sheriff - Patrol Serv - LE Admin Support Services Treasurer Treasurers - Landsale Veterans Services Water Resource Commissioner WRC - Soil Erosion Software Sol Sub-Total Fund 101 Health Health Environmental Sub-Total Fund 221 Children's Village Children's Village Admin Sub-Total Fund 293 Page 2 of 17 Health Fund [2211 840 221 20221-1 060201-1 331 50-773630 843 221 2022 1-1 060220-1 34390-773630 Juvenile Maintenance Fund [2931 665 293 20293-1060501-112090-773630 668 293 20293-1060501-112010-773630 Prepared by: Information Technology 07/2412017 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 3rd QUARTER 2017 63600-1080101-152000-631365 10100-9090101-196030-773630 DIVISION DEVELOPMENT FOR GOVERNMENTAL FUND APPROPRIATION SUB-TOTAL GOVERNMENTAL DEVELOPMENT APPROPRIATION: information Technology Development TOTAL GOVERNMENTAL: ASAP Passport System Assessment & Tax 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) 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 Health Immunization Grant Imaging Project IT Telephone Communications OakVideo Upgrade (Building Authority) Page 3 of 17 CUST FUND# ACCOUNT NON-GOVERNMENTAL DIRECT CHARGES 274 672 669 055 699 448 056 749 720 659 521 471 507 673 837 210 750 756 380 338 751 634 Prepared by: Information Technology 07/24/2017 3rd Qtr 2017 Apr - Jun Y.T.D. $1,106,670.73 $3,177,033.30 $1,106,670.73 $3,177,033.30 ($1,106,670.73) ($3.177.033.30) $0.00 $0.00 $0.00 $0.00 $21,667.50 $55,223.25 $0.00 $0.00 $31,451.98 $114,585.38 $0.00 $0.00 $163,583.25 $418,647.25 $64,015.50 $123,442.50 $0.00 $0.00 $3,016.74 $10,095.44 $1,358.50 $3,935.00 $26,192.25 $28,326,75 $0.00 $3,973.83 $10,927.65 $32,795.40 $201,341.70 $493,903.40 $0.00 $0.00 $1,574.74 $10,108.44 $30,617.49 $96,150.94 $0.00 $0.00 $0.00 $0.00 $107,263.25 $199,022.75 $0.00 $0.00 $0.00 $0.00 3rd Quarter 2017.pdf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 3rd QUARTER 2017 DIVISION O.C. International Airport 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 VVVVTP Transaction Radio Communications E911 Risk Management Tax Management System Water Resources Accounting WirtCan Central Storage Solution WRC Acctg - Crowder Prjct WRC WRC CLINTON-OAKLAND SCADA WRC - SAW ACACIA WRC - SAW Birmingham WRC - SAW Commerce Township WRC - SAW Grant Labor WRC SAW GWK WRC - AMR Support WRC COSDA Meter Replacement WRC CO SOS SewMet WRC - EF SDS SewMet WRC - Data Application Pilot Poject WRC GIS Allocation by Labor WRC GWK PCF-WRC SCADA WRC - HACH WIMS Implementation 3rd Qtr 2017 Apr - Jun $1,000.50 $13,609.75 $0.00 $138.00 $78.00 $78.00 $195.00 $195.00 $728.00 $6,542.50 $0.00 $0.00 $0.00 $4,451.00 $34.50 ($9,650.50) $10,425.01 $0.00 $0.00 $1,165.50 $66.00 $0.00 $0.00 $0.00 $0.00 $0.00 $123.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Y.T.D. $2,578.00 $44,129.00 $0.00 $138.00 $104.00 $104.00 $221.00 $221.00 $780.00 $30,970.00 $0.00 $0.00 $0.00 $7,199.50 $309.50 $172,521.00 $29,764.14 $0.00 $0.00 $1,165.50 $56.00 $3,308.50 $3,242.00 $6,781.00 $0.00 $2,984.00 $1,168.50 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 CUST FUND# ACCOUNT 653 770 867 926 442 443 454 456 457 268 747 748 329 791 695 638 656 736 670 281 926 377 382 379 674 381 734 745 728 729 737 300 277 295 Prepared by: Information Technology 07/24/2017 Page 4 of 17 3rd Quarter 2017.pdf 3rd Qtr 2017 Apr Jun $0.00 $0.00 $0.00 $3,147.25 $698.50 $0.00 Y.T.D. $0.00 $0.00 $0.00 $48,958,25 $698.50 $0.00 63600-1 0801 01-152000-631302 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 3rd QUARTER 2017 DIVISION WRC - Hydro Drain Project VVRC - Infrastructure Op Ar WRC - MISS DIG Ticket Mgmt Sys VVRC - SAW Grant Labor Common to All WRC - SCADA Common WRC - SCADA Engineering Assessment CUST FUND# 733 671 299 686 739 738 ACCOUNT SUB-TOTAL DIRECT CHARGES FOR DEVELOPMENT $696,025.56 $1,947,611.72 TOTAL COUNTY DEVELOPMENT CHARGES $1,802,696.29 $5,124,645.02 NON-COUNTY AGENCIES 63600-1080101-152000-635017 Non-County Agencies $31,292.25 $65,196.25 Page 5 of 17 3rd Quarter 2017.pdf Prepared by: Information Technology 07/24/2017 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2017 91404 BOG - Customer Support Bd of Commissioners - Total 95665 Childrens Village Childrens Village- Total 72500 Clerk -Admin Clerk/Reg - Admin - Total 95443 Elections Clerk/Reg - Elections Division - Total 95158 Cleric/Reg - EDMS SupportiMaintneance/Upgrades Cleric/Reg - EDMS (Imaging) - Total 95612 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% 95151 Clerk.Reg - Vital Statistics Clerk - Vital Statistics - Total 23003 Oracle Support-Comm Curl- 5.2% 24012 SQL Server Supp - Community Corr 3.5% 52200 Comm Corr-Admin (County) 52201 Gomm Corr- DVV Support Community Corrections - Total 44034 Auditing - New Development 95468 Auditing Internal Srv - Gust Sup Compliance Office - Auditing - Total $46,010.99 $15,254.25 $20,892.75 $0.00 $2,082.50 $1,427.88 $345.00 $77.035.75 $44,056.99 $19,546,00 $4,887.50 cust te GOVERNMENTAL FUNDS GUST FUND 530 ANIMAL CONTROL 005 BD OF COMMISSIONERS 665 CHILDRENS VILLAGE 725 CLERK/REG - ADMIN 440 CLERK/REG - ELECTIONS DIVISION 722 CLERK/REG - EDMS (IMAGING) 410 CLERK1REG -JURY COMMISSION 724 CLERK/REG - LEGAL RECORDS 723 CLERK - VITAL STATISTICS 522 COMMUNITY CORRECTIONS-ADMIN (CO) 620 COMPLIANCE OFFICE - AUDMNG ACCOUNT 24017 95628 95682 SQL Server Supp - Animal Control Web License Registration Dog System Animal Control-Total 3rd Qtr 2017 $1,574.74 $17,326.75 $27,109.50 $15,254.25 $20,892.75 $0.00 $2.082,50 $1,427.88 $345.00 $77,035.75 $1,574.74 $42,482.25 $1,917.76 $1,574.74 $16,053.50 $0.00 $2,426.50 $2,461.00 690 COMPLIANCE OFFICE - PURCHASING 44028 Purchasing System Enhancements $2,208.00 Prepared by: Information Technology 07/24/2017 Page 6 of 17 3rd Quarter 2017.pdf 785 ECONOMIC DEVELOPMENT & COMMUNITY AFFAIRS 36500 GIS Implementation Support C&E Dev 36501 CEO Application - H/W Support 95785 Comm & Eco Developmt Economic Development & Community Affairs - Total Page 7 of 17 3rd Quarter 2017.pdf Prepared by: Information Technology 07124/2017 95501 Corporation Counsel Corporation Counsel - Total 95656 County Executive Support County Executive - Total 80704 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 95187 CTS-Fam Div-Judicial Support CTS-Fam Div-Judicial Support - Total 24009 SQL Seri/ Supp CTS-Jud Sup Adm - 3.5% CTS-FD-Judicial Support-Arim - Total 48200 CTS-FD-Judicial Support-Adm CTS-FD-Judicial Support-Adm - Total 12002 CCT-Courts/Criminal 23010 Oracle Supp-CCT/CTS 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 23012 Oracle Support-Equalization - 6.2% 24005 SQL Server Supp-Equalization - 10,5% 31075 Equal - Development 36505 GIS Implementation Support Equalization INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT (SUPPORT DETAIL - THIRD QUARTER 2017 95663 Purchasing Internal Services Compliance Office - Purchasing - Total $1,917.76 $4,723.69 $1,625.00 $330.25 $4 447.25 $69.00 $84.00 $0.00 $0,00 $0.00 $1,574.74 $0.00 $276.00 $958.89 $112996.75 51,917.76 $1,249.40 $2,708,00 $4,447.25 $69.00 $84.00 $0.00 $0.00 $1,574.74 $0.00 $114,231.64 $1,917.76 $1,249.40 430 CORPORATION COUNSEL 015 COUNTY EXECUTIVE 450 CIRC CT PROBATION - NORTH 495 CTS-BUSINESS DIVISION 506 CTS-FAM DIV-JUDICIAL SUPPT 483 CTS-FD-JUDICIAL SUPPORT-ADM 482 CTS-FD-JUVENILE SUPPORT 498 CTS-GEN JURIS-JUDICIAL SUPPT 502 CTS-GJ-JURY OPERATIONS 493 CTS-JUDICIAL ADMIN 740 EQUALIZATION $687.25 $10,715.50 $0.00 $11,402.75 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2017 36506 Equal Application - HNV Support 36601 Land System Enhancements - Equal (50%) 36701 Land System Maintenance - Equal (50%) 36801 Land System Support Equal (50%) 50101 Equal (BS&A Annual Processes) 95562 Equalization - DVV Support 95693 Equalization - System Maintenance 95699 BS&A Master Appraisal Sup/Maint Equalization - Total $22,200.00 $4,770.50 $275.00 $3,125.25 $7,504.50 $0,00 $0.00 $7,156.00 $63,927.95 660 FISCAL SERVICES ADMIN 840 HEALTH DIVISION 843 HEALTH - ENVIRONMENTAL 900 HOMELAND SECURITY 680 HUMAN RESOURCES 907 LIBRARY - LIBRARY ADMIN 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 ES - 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% 54200 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% 44044 HR- New Development 96002 Human Res-Personnel 40% Human Resources - Total 91405 Library Board $5,753.36 61,917.76 $787,43 $32,080.00 $7,892.00 $0.00 $0.00 $0.00 $61,120.90 $30,560,45 $0.00 $27,161.50 $37,003.30 $1,917.76 $6,297.90 $64,178.90 $1,242.00 $369.00 $13,977.75 $9,763.00 $1,917.76 $787.43 $0.00 $80,284.96 $2,277.00 $140,111.90 $64,164.80 $63,636.56 $24,109.75 $82,990.15 Page 8 of 17 3rd Quarter 2017.pdf Prepared by: Information Technology 07/24/2017 Page 9 of 17 3rd Quarter 2017.pdf Prepared by: Information Technology 07/24/2017 824 LIBRARY SERVICES 565 MARKETING & COMMUNICATIONS 872 MEDICAL EXAMINER 296 MSU - DIGITAL MEDIA SERVICES 710 IVISU EXTENSION - OAKLAND 163 OCSO-CLEMIS FORENSIC LAB IIVIS 775 PLANNING & ECU DEVELOPMENT 512 PROB-ESTATES/MENTL HLTH EDMS (INIG) 510 PROB-ESTATES/MENTL HLTH SUPPORT 481 PROB-FD JUDICIAL 145 PROSECUTOR - GENERAL PROSECUTION 637 RECORDS RETENTION 650 REIMBURSEMENT 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 & Fop Development - Total 95207 PC-F/MH EDMS Support & Woe Prob-Est/Mntl Hlth EDMS (Img) - Total 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 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 $0.00 $1519.00 $1,574.74 $6,322.00 $82.50 $0.00 $823.50 $1,941.50 $1,249.40 $1,574.74 $6.221.00 $369,00 $1,574.74 $14,156.25 $0.00 $5,658.00 $1,191.50 $138.00 $2,277.00 $0.00 $1,519.00 $7.896.74 $82.50 $0.00 $823.50 $1,941.60 $1,249.40 $7,795.74 $369.00 $15,730.99 $5,658.00 $1,329,50 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT /SUPPORT DETAIL -THIRD QUARTER 2017 Library - Library Admin - Total INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2017 195 SHERIFF 191 SHERIFF - CLEMIS 348 SHERIFF - CORRECTIVE SERV ADMIN 647 SHERIFF - PATROL SERV - LE ADMIN 445 SUPPORT SERVICES 600 TREASURER 627 TREASURER - LANDSALE 12001 OGSD-Courts/Criminal - 50% 23009 Oracle Suppport OCSD/GTS Grim VVhse - 2.6% 97163 Sheriff 97164 Sheriff Development 97165 Sheriff-DVV Support 98164 CLEMIS-Sheriff Sheriff- Total 23015 Oracle Suppport - Shenff / CLEMIS - 5.2% 96163 Sheriff- CLEWS Sheriff- CLEWS - Total 34800 Inmate Phone System Sheriff - Corrective Serv Admin - Total 97647 OGSD Patrol Serv - LE Admin Sheriff - Patrol Serv - LE Admin - 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 - HAN Support 36602 Land System Enhancements - Trees (50%) 367 02 Land System Maintenance - Tress (50%) 36802 Land System Support-Tress (50%) 44061 Tre-Systern/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 - Trees (50%) 50102 Treasurer (BS&A Annual Processes) 95008 Del Tax On Line 95303 Del Tax System Maintenance 95561 User Support/Del Tax 95615 DS&A Annual Tax Support Treasurer - Total 44083 Treasurer-Lendsale $276.00 $958.89 $18,743.01 $35,056.25 $0.00 $0.00 $1,917,76 $690.00 $0.00 $599.00 $1,917.76 $3,148.96 $5,885.00 $1,917.76 $3,835.57 $0.00 $4,770.50 $275,00 $3,125.25 $19,693.40 $7,962,00 $1,504.00 $1,830.00 $0.00 $0.00 $0.00 $7,804.50 $1,476.00 $621.00 $11,799,00 $0.00 $37,721.50 $55,034.15 $2,607.76 $0.00 $599.00 $10,954.72 $66,613.95 Prepared by: Information Technology 07/24/2017 Page 10 of 17 3rd Quarter 2017.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2017 Treasurer -Lan dsale - Total $37,721.50 VVRC - CAMS Software Support & Maintenance WRC GAMS Software Support & Maintenance - Total $0.00 $21,667.50 $1,917.76 $1,918.13 $11,021.59 $12,972.00 $0.00 52,967.00 $0.00 $21 667 50 Cust# DIRECT FUNDS 274 ASAP PASSPORT SYSTEM 672 ASSESSMENT & TAX 055 CLEWS 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 98000 Project Team Page 11 of 17 3rd Quarter 2017.pdf Prepared by: Information Technology 07/24/2017 95651 Veterans Customer Support Veterans Services - Total 24008 SQL Server Supp VVRC 3.5% 28010 VVRC - Customer Support 28011 Water Resource Commissioner Application 36520 GIS Implementation Support VVRC 36521 VVRC Application - ffl/W Support Water Resource Commissioner - Total 74301 VVRC - Soil Erosion Software Sol WRC - Soil Erosion Software Sol - Total 95527 DC Suprt- 5211 - 25% 52/1 District Court - Total 95528 DC Suprt- 52/2 - 25% 52/2 District Court - Total 95285 52 Dist Ct Div 3 95529 DC Suprt - 52/3 , 25% 52/3 District Court - Total 530 52/4 DISTRICT COURT - TROY 95530 DC Suprt- 52/4 - 25% 52/4 District Court - Total 1,106,670.73 910 VETERANS SERVICES 730 WATER RESOURCE COMMISSIONER 301 WIRC - SOIL EROSION SOFTWARE SOL 742 WRC - CAMS SOFTWARE SUPPORT & MAINTENANCE 540 52/1 DISTRICT COURT - NOVI 550 52/2 DISTRICT COURT - CLARKSTON 560 52/3 DISTRICT COURT - ROCHESTER $175.50 $175.50 $1,574.74 $23,792.25 $16,703,00 $2,331.00 $23.015.00 5.934.00 0.00 53,819.08 $3,819.08 $0.00 53.819.08 $67,415.99 $5,934.00 $0.00 $3,819.08 $3,819.08 $3,819.08 $3.818.76 53,818.76 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2017 98003 CLEMIS User Support 98005 CLEIVIIS - E911 Support CLEMIS - Total 599 CLEWS - CAD 055 CLEMIS FUND 63500 448 CLEMIS/FRMS NON-BILLABLE 720 CLERK / REGISTER OF DEEDS 749 CLERK/REG - CPL 669 CAMS/CVT DATA CONVERSION 659 COLLABORATIVE ASSET MGT SYS 98006 CLEMIS - CAD Development CLEMIS - CAD Total 63500 CLEMIS Fund CLEMIS 63500 Fund - Total 44800 CLEMIS/FRMS Non-Billable CLEMIS/FRMS - Total 24003 SQL Server Supp - ROD 3.5% 36510 GIS Implementation Support 36511 ROD Application - H/VV Support 95493 ROD System Maintenance 95498 Clerk/Reg - ROD Cleric/Reg of Deeds - Total 74900 Clerk/Reg - CPL Clerk/Reg - CPL - Total 66901 CAMS/CVT Data Conversion CAMS/CVT Data Conversion - Total 65901 Collabortive Asset Mgt Sys Collabortive Asset Mgt Sys - Total $655.50 $0.00 $64.015,50 163,58325 $1,574.74 $0.00 $1,028.00 $0.00 $414.00 $0.00 $0.00 $1.358.50 $31,451.98 $0.00 $64,015,50 $163,583.25 $3,016.74 $0.00 $0.00 $1,358.50 471 CTS-FOC-EXP-CS ENFORC-EDMS (IMG) 92194 CTS-FOC-CS ENF-EDMS Support/Maintenance/Upgrades CTS-FOC Exp-CS Enforc-EDMS (1rng) - Total $0.00 $0.00 507 CTS-FOC EXP-CS ENFORCEMENT 521 COMM CORR - ADM (GRANT) 673 CYBER SECURITY FUND 837 EDCA - MITRADESCHOOLORG GRANT 92193 CTS-FOC Exp-CD Enforc-Dev 92194 CTS-FOC-CS ENF-EDMS CTS-FOC Exp-CD Enforc-Dev - Total 52100 Community Corrections C*Star EB Comm Corr - Mm (Grant) - Total 67300 Cyber Security Fund Cyber Security Fund - Total 83700 EDCA MITRADESCHOOL EDCA - MITradeSchooLorg Grant - Total $9,678.25 $1.249.40 $26102.25 $201.341.70 $0.00 $10,927.65 $26,192,25 $201,341,70 $0.00 Prepared by: Information Technology 07/24/2017 Page 12 of 17 3rd Quarter 2017.pdf 36540 65301 65310 $0.00 $34.50 $966.00 $1,000.50 653 O.C. INTNL AIRPORT GIS Implementation Support Airport User Support OC Airport - New Development O.C. IntnlAirport - Total INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2017 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 - FM&O 75503 FM&O Development FM&O - Total 75600 FM&O Building Maintenance FM&O Building Maintenance -Total 38000 Health-Immunization Grant Health-Immunization Grant - Total 33800 Imaging Project Imaging Project - Total 75102 Telephone Communications - Customer Support IT - Telephone Communications - Total 63400 CLEM1S - OakVideo Upgrade 63401 IT - OakVideo Upgrade OakVideo Upgrade (BA) -Total 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 86700 P&R Capital Improvement P&R Capital Improvement - Total 44200 P&R Lyon Oaks Conf Ctr CIP#2469 P&R Lyon Oaks Conf Ctr C1P#2469 - Total Prepared by: Information Technology 07124/2017 Page 13 of 17 210 FIRE RECORDS MANAGEMENT SYSTEM 750 FM&O 756 FM&O BUILDING MAINTENANCE 380 HEALTH-IMMUNIZATION GRANT 338 IMAGING PROJECT 751 IT -TELEPHONE COMMUNICATIONS 634 OAKVIDEO UPGRADE IBA) $0.00 $0.00 $1574.74 $1,574.74 $415.50 $1,574.74 $28,627,25 $0.00 107 263.25 $0.00 $0,00 $0.00 $30,617.49 $0,00 $0.00 $107,263.25 $0.00 $0.00 770 PARKS AND RECREATION 867 P&R CAPITAL IMPROVEMENT 442 P&R LYON OAKS CONF CTR CIP#2469 $195.25 $4,672.50 $1,448.00 $0.00 $7,294,00 $0.00 $13,609.75 $0.00 $78.00 3rd Quarter 2017.pdf $0.00 78.00 578.00 78.00 195.00 $195,00 $195.00 195.00 728.00 $6,542.50 $0.00 $0.00 0.00 $4,451.00 $34.50 (59,650,501 $1,917.76 $3,507.26 $0.00 $728,00 $6,542.50 $0.00 $0.00 $0.00 $4,451,00 $34.50 ($9,550.50) $10,425.01 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - THIRD QUARTER 2017 44300 P&R Lyon Oaks Conf Ctr CIP#2468 P&R Lyon Oaks Gonf Gtr 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 P&R Red Oaks Clubhouse C1P#2467 - Total 74268 Pontiac BSA to WRC - Water Pontiac Meter - Total 74701 Pontiac BSA to WRC - Water Pontiac Water Total 74702 Pontiac BSA to WRC - Sewer Pontiac Sewer - Total 67329 Pontiac WWTP Transaction Pontiac VWVTP Transaction - 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 Accfg - 5.2% 95639 Water Resources Accounting 95671 Drain Water/Sewer B1 Water Resources Accounting - Total 443 P&R LYON OAKS CONF 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 268 PONTIAC METER 747 PONTIAC WATER 748 PONTIAC SEWER 329 PONTIAC WWTP TRANSACTION 791 RADIO COMMUNICATIONS - E911 695 RISK MANAGEMENT 638 TAX MANAGEMENT SYSTEM 656 WATER RESOURCES ACCOUNTING 736 WINCAN CENTRAL STORAGE SOLUTION 73601 WinCan Central Storage Solution Win Can Central Storage Solution - Total 50.00 $0.00 670 WRC ACCTG - CROWDER PRJCT 60001 VVRC - Crowder NetBase Project 67000 WRC - Crowder NetBase Project WRC Acctg - Crowder Prject - Total $0,00 $0,00 $0.00 Prepared by: information Technology 07/2412017 Page 14 of 17 3rd Quarter 2017.pdf $1,165.50 0.00 0.00 0.00 0.00 $0.00 $0.00 $3,147.25 $123.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,165.50 $0.00 $0.00 $0.00 $0.00 $0.00 $3,147.25 $123.00 $0.00 $0.00 $0.00 $0.00 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2017 281 WRC 377 WRC - SAW ACACIA 382 WRC SAW BIRMINGHAM 379 WRC - SAW COMMERCE TOWNSHIP 381 WRC SAW GWK 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 SOS SEWMET 729 WRC EF SDS SEWMET 737 WRC - DATA APPLICATION PILOT PIRJ 74281 VVRC VVR - Total 33377 VVRC - SAW ACACIA VVRC - SAW ACACIA - Total 33382 WRC - SAW Birmingham VV1RC - SAW Birmingham - Total 33379 VVRC - SAW Commerce Township WRC - SAW Commerce Township - Total 33381 VVRC SAW GWK WRC SAW GVVK - Total 28674 VVRC - SAW Grant Labor WRC - SAW Grant Labor - Total 60002 VVRC - SAW Grant Labor - Common to All 12686 WRC - SAW Grant - Common to All WRC - SAW Grant Labor Common to All- Total 73401 VVRC -AMR Support VVRC -AMR Support - Total 74500 VVRC CODSA Meter Replacement INRC - CODSA Meter Replacement - Total 72201 MARS Enhancements - WRC C-0 VVRC - CO SOS SewMet - Total 72202 MARS Enhancements - VVRC E-F WRC EF SOS SewMet - Total 73700 VVRC - Data Application Pilot Project 73710 VVRC - Data Appl Prj )NRC - Data Application Pilot Prj - Total 300 WRC - GIS ALLOCATION BY LABOR 73300 GIS Allocation By Labor 0.00 1NRC - GIS Allocation by Labor - Total $0.00 277 WRC-GWK PCF-WRC SCADA 74277 WRC - GVVK P CE-VVRC SCADA VVRC - GVVK PCF-VVRC SCADA - Total $0.00 $0,00 Prepared by: Information Technology 07/24/2017 Page 15 of 17 3rd Quarter 2017,pdf 295 WRC-HACH W1MS IMPLEMENTATION INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - THIRD QUARTER 2017 67295 VVRC - HACH VVIMS Implementation VVRC - HACH VVIMS Implementation - Total $0.00 $0.00 733 WRC - HYDRO DRAIN PROJECT 73301 VVRC - Hydro Drain Implementation $0.00 WRC - Hydro Drain Implementation - Total $0.00 671 WRC - INFRASTRUCTURE OP AR 299 WRC MISS DIG TICKET MGMT SYS 739 WRC - SCADA COMMON 738 WRC - SCADA ENGINEERING ASSESSMT 925 P&R EMS UPGRADE 926 WRC CLINTON-OAKLAND SCADA 67100 WRC -10 AR WRC - Infrastructure Op Ar - Total 74299 VVRC MISS DIG Ticket VVRC MISS DIG Ticket Mgmt Sys - Total 73900 VVRC - SCADA Common VVRC - SCADA Common - Total 73800 VVRC - SCADA Engineering Assesmnt VVRC - SCADA Engineering Assesmt - Total 37925 P&R EMS Upgrade P&R EMS Upgrade - Total 33926 VVRC CLINTON-OAKLAND SCADA WRC CLINTON-OAKLAND SCADA - Total $0.00 $0.00 0.00 $0.00 $698.50 $698.50 $0.00 $0.00 $138.00 $138.00 $56.00 $56.00 $696,025.56 Prepared by: Information Technology 07124/2017 Page 16 of 17 3rd Quarter 2017.pdf INFORMATION TECHNOLOGY DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2017 3rd Quarter Y.T.D. $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 231,347.00 $570,977.25 6,356.00 $24,143.50 640.75 $1,984.50 79,276.50 $247,962.00 566,087.25 $1,618,650.25 $0.00 $0.00 $0.00 $0.00 $883,707.50 $2,463,717.50 $56,166.50 $141,958.00 $56,166.50 $141,958.00 $103,832.50 $299,501.25 1,917.76 $5,881.39 442.54 $1,357.20 895.86 $2,913.34 7,689.00 $26,638.50 1,866.25 $2,142.25 0.00 $0.00 0.00 $0.00 $116,643.91 $338,433.93 1,056,517.91 I $2,944,109.43 Radio 18020 IT Radio GUST FUND ACCOUNT Application Services 17040 IT - TOS Fund 18000 IMACS 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 13S&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 Serv Support - IT Tech Systems 2% 25400 Oracle Administration 95685 LT. - Disaster Recovery 95750 I.T. - SEP 95755 I.T. - PeopleSoft Upgrade Tech Sys/Net - Sub-Total: Information Technology - Total: Prepared by: Information Technology 07/24/2017 Page 17 of 17 3rd Quarter 2017.pdf 0\117 Resolution #17225 August 10, 2017 Moved by Crawford supported by Quarles the resolutions (with fiscal notes attached) on the amended Consent Agenda be adopted (with accompanying reports being accepted). AYES: Crawford, Dwyer, Fleming, Gershenson, Gingell, Hoffman, Jackson, Kochenderfer, KowaIF , Long, McGillivray, Middleton, Quarles, Spisz, Taub, Tietz, Weipert, Zack, Berman, Bowman. (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). NERSBY 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 10, 2017, 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 10th day of August, 2017. Lisa Brown, Oakland County