Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Resolutions - 2020.06.04 - 33287
MISCELLANEOUS RESOLUTION #20174 June 4, 2020 BY: Commissioner Helaine Zack, Chairperson, Finance and Infrastructure Committee IN RE: INFORMATION TECHNOLOGY - SECOND QUARTER 2020 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 and Infrastructure Committee; and WHEREAS the Department of Information Technology has determined the Second Quarter 2020 development charges to be $1,091,545.73 for the General Fund/General Purpose County departments; and WHEREAS direct charges to Special Revenue and Proprietary fund departments are $1,081,224.78 and non -county agencies are $10,815.75 for the Second Quarter 2020; and WHEREAS an appropriation transfer to General Fund/General Purpose County departments is needed to fund these development charges. NOW THEREFORE BE IT RESOLVED that the Oakland County Board of Commissioners has reviewed the Second Quarter 2020 Development Report and approves the Second Quarter appropriation transfer as specified on the attached schedule. BE IT FURTHER RESOLVED that the respective departmental Fiscal Year 2020 budgets are to be amended as specified in the attached detail schedule. Chairperson, on behalf of the Finance and Infrastructure Committee, I move the adoption of the foregoing resolution. Commissioner Helaine Zack, District #18 Chairperson, Finance and Infrastructure Committee FINANCE AND INFRASTRUCTURE COMMITTEE VOTE: Motion carried unanimously on a roll call vote. CUST FUND# ACCOUNT 540 550 560 530 630 005 508 450 184 718 725 291 722 440 410 724 723 522 620 690 430 506 483 482 015 495 498 502 493 188 785 740 660 900 416 680 907 824 565 GOVERNMENTAL FUNDS General Fund 11011 101 10100-3020201-121020-773630 101 10100-3020301-121020-773630 101 10100-3020401-121020-773630 101 10100-3020501-121020-773630 101 10100-1070801-114000-773630 101 10100-5010101-180010-773630 101 10100-5010101-165015-773630 101 10100-1070901-113270-773630 101 10100-2010210-132300-773630 101 10100-2010210-125000-773630 101 10100-2010201-180000-773630 101 10100-2010401-172190-773630 101 10100-2010210-125000-773630 101 10100-2010301-185010-773630 101 10100-2010501-125000-773630 101 10100-2010210-125000-773630 101 10100-2010205-132305-773630 101 10100-1070401-113000-773630 101 10100-1010201-181010-773630 101 10100-1010210-182090-773630 101 10100-1010501-181020-773630 101 10100-3010401-121220-773630 101 10100-3010403-121100-773630 101 10100-3010403-121240-773630 101 10100-1010101-181000-773630 101 10100-3010201-121110-773630 101 10100-3010301-121130-773630 101 10100-3010301-121180-773630 101 10100-3010101-121100-773630 101 10100-1090206-171000-773630 101 10100-1090101-171000-773630 101 10100-1020501-173010-773630 101 10100-1020601-182020-773630 101 10100-1060601-115090-773630 101 10100-1050403-183020-773630 101 10100-1050401-183010-773630 101 10100-5010303-165040-773630 101 10100-5010302-165020-773630 101 10100-1090108-171030-773630 Prepared By: Information Technology; 04/21/20 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY SECOND QUARTER 2020 DIVISION 52/1 - District Court 52/2 - District Court 52/3 - District Court 52/4 - District Court Animal Control Bd of Commissioners BOC -Legal Resource Center 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 Dev & Comm Affairs Economic Development & Community Affairs Equalization Division Fiscal Services -Gen Fund Homeland Security HR Recruitment Human Resources Library - Library Admin Library Services Marketing & Communications Page 1 of 22 2nd Quarter Jan - Mar $3,546.30 $3,546.30 $3,546.30 $3,546.10 $15,598.98 $9,587.25 $1,872.75 $174.00 $0.00 $0.00 $0.00 $0.00 $5,238.76 $5,052.25 $165.00 $44,193.75 $25,126.73 $27,414.42 $0.00 $1,490.75 $17,448.75 $0.00 $51.98 $0.00 $42,547.50 $0.00 $187,542.62 $476.19 $7,209.44 $198.00 $3,139.25 $83,742.44 $21,087.36 $28,273.25 $0.00 $16,011.38 $0.00 $0.00 $736.25 Y.T.D. $5,924.98 $5,924.98 $5,924.98 $5,924.56 $43,474.87 $15,844.75 $4,303.75 $174.00 $0.00 $0.00 $0.00 $0.00 $8,041.60 $8,305.00 $165.00 $90,359.50 $38,374.62 $38,693.33 $0.00 $45,293.50 $37,900.50 $0.00 $80.87 $0.00 $87,694.25 $0.00 $345,246.51 $531.96 $9,661.96 $396.00 $5,725.50 $124,363.06 $47,528.78 $51,394.00 $0.00 $33,941.50 $0.00 $0.00 $2,659.75 2nd Quarter 2020.pdf CUST FUND# ACCOUNT 872 101 10100-1070601-132030-773630 296 101 10100-1070501-174000-773630 710 101 10100-1070501-174000-773630 349 101 10100-4030501-112680-773630 648 101 10100-4030201-112580-773630 163 101 10100-4030901-115140-773630 775 101 10100-1090201-171000-773630 479 101 10100-3040101-121090-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 988 101 10100-4030901-116240-773630 647 101 10100-4030601-110000-773630 206 101 10100-4030901-110040-773630 445 101 10100-1030803-184025-773630 600 101 10100-7010101-186040-773630 169 101 10100-7010101-186080-773630 627 101 10100-7010110-186130-773630 978 101 10100-7010101-186050-773630 910 101 10100-1070301-132050-773630 730 101 10100-6010101-155010-773630 742 101 10100-6010101-149920-773630 022 101 10100-6010101-174453-773630 301 101 10100-6010101-174250-773630 Health Fund 12211 840 221 20221-1060201-133150-773630 852 221 20221-1060211-133150-773630 843 221 20221-1060220-134390-773630 183 221 20221-1060201-133150-773630 Juvenile Maintenance Fund r2931 665 293 20293-1060501-112090-773630 Prepared By: Information Technology; 04/21/20 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY SECOND QUARTER 2020 2nd Quarter 2020 pdf 2nd Quarter DIVISION Jan - Mar Y.T.D. Medical Examiner $13,988.73 $44,162.62 MSU - Digital Media Services $0.00 $0.00 MSU Extension - Oakland $0.00 $288.75 OCSD Admin Sew -Records Unit $2,491.50 $2,656.50 OCSD Admin Sew -Sheriff Admin $198.75 $437.25 OCSO - CLEMIS Forensic Lab IMS $0.00 $0.00 Planning & Economic Development $4,609.00 $8,216.25 Probate FD Judicial Support $0.00 $0.00 Probate-Estates/Mental Health - EDMS (Imaging) $4,583.94 $7,036.46 Probate-Estates/Mental Health Support $15,294.73 $28,779.37 Probate -Family Division Judicial $0.00 $0.00 Prosecuting Attorney- General Prosecution $13,440.73 $25,110.87 Records Retention $0.00 $0.00 Reimbursement Division $2,058.25 $9,988.25 OCSD-Corrective Sew - Admin $71,450.22 $125,408.71 Sheriff - CLEMIS $3,226.19 $4,519.46 Sheriff - Corrective Saw Admin $0.00 $0.00 Sheriff - IFS Div Lab $1,547.50 $3,D58.00 Sheriff - Patrol Sew - LE Admin $0.00 $0.00 Sheriff - LE Support- Sew Admin $0.00 $0.00 Support Services $2,663.64 $8,232.91 Treasurer $85,523.94 $174,990.06 Treasurers -Banking RFP $1,149.00 $1,975.25 Treasurers-Landsale $0.00 $0.00 Treasurers Office-OakDocs $47,639.00 $50,379.00 Veterans Services $11,038.50 $21,705.00 Water Resource Commissioner $62,896.73 $123,567.87 WRC - CAMS Software Support & Maintenance $0.00 $0.00 WRC GIS Layer $0.00 $0.00 WRC - Soil Erosion Software Sol 0.00 $0.00 Sub -Total Fund 101 $902,364.40 $1,704,366.64 Health $97,173.25 $238,803.75 Health Central Support $2,986.50 $4,875.75 Health Environmental $71,822.78 $115,910.07 Health Website Redesign 0.00 860.00 Sub -Total Fund 221 $171,982.53 $358,729.57 Children's Village $17,198.80 $25,871.10 Page 2 of 22 2nd Quarter 2020 pdf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY SECOND QUARTER 2020 2nd Quarter 2020.pdf 2nd Quarter CUST FUND# ACCOUNT DIVISION Jan - Mar Y.T.D. 668 293 20293-1060501-112010-773630 Children's Village Admin $0.00 0.00 Sub -Total Fund 293 $17,198.80 $25,871.10 63600-1080101-152000-631365 DEVELOPMENT FOR GOVERNMENTAL FUND $1.091,545.73 $2,088,967.31 APPROPRIATION SUB -TOTAL GOVERNMENTAL DEVELOPMENT APPROPRIATION: $1,091,545.73 $2,088,967.31 10100-9090101-196030.773630 Information Technology Development ($1.091.545.73) ($2.088.967.31) TOTAL GOVERNMENTAL: $0.00 $0.00 NON-GOVERNMENTAL DIRECT CHARGES 053 Airport Special Events $0.00 $0.00 274 ASAP Passport System $0.00 $0.00 672 Assessment & Tax $154.00 $31,125.50 935 Augusta SAW Grant $0.00 $0.00 073 Bicentennial Celebration Grant $293.25 $1,095.00 944 CAMP CTA DR Equipment $13,267.25 $26,011.75 669 CAMS/CVT Data Conversion $0.00 $0.00 055 CLEMIS $24,376.16 $41,164.08 699 CLEMIS - CAD $0.00 $0.00 448 CLEMIS/FRMS NON -BILLABLE ($247.50) $27,926.25 056 CLEMIS FUND 63500 $43,482.75 $77,813.75 749 Clerk/Reg - CPL $0.00 $0.00 720 Clerk/Reg - Register Of Deeds $9,307.23 $23,989.87 719 Clerk/Rod Automation Fund $19,779.75 $37,517.00 659 Collaborative Asset Mgt Sys (CAMS) $0.00 $0.00 435 Comm Dev - Housing Counselor $0.00 $0.00 521 Community Corrections - Admin(Grant) $813.00 $813.00 937 COSDS SAW Grant $451.50 $451.50 471 Courts -FOC Exp -CS Enforcement - EDMS (Imaging) $0.00 $0.00 507 Courts -FOC Exp -CS Enforcement $29,076.69 $53,773.21 673 Cyber Security Fund $0.00 $0.00 931 Drain Equipment Fund $0.00 $0.00 189 Drain Equipment Fund - Powerplan Contract $0.00 $0.00 933 Drain Equip Map $3,369.75 $3,369.75 837 EDCA- MlTradeSchool.org Grant $0.00 $0.00 167 Edwards Drain SAW Grant $0.00 $0.00 100 Farmington Hills SDS SAW $61.50 $1,791.50 Prepared By: Information Technology: 04/21/20 Page 3 of 22 2nd Quarter 2020.pdf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY SECOND QUARTER 2020 2nd Quarter CUST FUND# ACCOUNT DIVISION Jan - Mar Y.T.D. 210 Fire Records Management System ($2,423.02) $80.87 750 FM&O $37,512.03 $57,499.47 756 FM&O Building Maintenance $0.00 $0.00 133 FM&O Building Management System $0.00 $6,669.25 080 FMO Bldg Mgmt Systems Rep Ph 2 $3,482.25 $7,658.75 048 FM&O Bldg Security Enh Proj $574.75 $574.75 963 FOC Security Audit $0.00 $0.00 942 Franklin SAW Grant $0.00 $0.00 380 Health Immunization Grant $0.00 $0.00 173 Health - Lead Innovation Grant $0.00 $0.00 071 Health Lead PSA Grant $2,916.25 $2,916.25 117 Health -Hepatitis A Prevention $0.00 $0.00 020 Henry Graham Drain SAW Grant $0.00 $0.00 947 HIPAA Enhancements 11 $20,388.50 $50,190.25 120 HR -Financial System Replacement $474,061.25 $896,893.50 214 IAM Program $138,007.50 $178,048.50 338 Imaging Project $43,101.75 $76,518.00 751 IT Telephone Communications $106.00 $357.75 185 Leasetrack $0.00 $0.00 112 Medical Marijuana PSA $0.00 ($860.00) 101 Medical Marijuana Mysidewalk $0.00 $0.00 113 MIDC CLEMIS Dev $6,426.50 $7,302.25 136 Oakland Township SDS SAW $0,00 $2,640.00 634 OakVideo Upgrade (Building Authority) $0.00 $0.00 938 OAKWIN Radio System Enhancement $0.00 $0.00 043 O.C. Bicentennial Oak200 $5,565.00 $5,565.00 653 O.C. International Airport $6,216.00 $9,285.75 934 OLV SDS SAW Grant $0.00 $0.00 770 Parks and Recreation -Administration $8,497.50 $14,355.00 867 P&R Capital Improvement $0.00 $0.00 925 P&R EMS Upgrade $0.00 $0.00 796 P&R Facilities & Maintenance $0.00 $0.00 442 P&R Lyon Oaks Conf Ctr CIP#2469 $0.00 $0.00 443 P&R Lyon Oaks Conf Ctr CIP#2468 $0.00 $0.00 454 P&R Springfield Oaks CIP#2471 $0.00 $0.00 456 P&R Springfield Oaks CIP#2470 $0.00 $0.00 457 P&R Red Oaks Clubhouse CIP#2467 $0.00 $0.00 268 Pontiac - Meter $0.00 $0.00 747 Pontiac - Water $0.00 $0.00 748 Pontiac - Sewer $0.00 $0.00 936 Pontiac Water Asset Mgmt $0.00 $0.00 Prepared By: Information Technology; 04/21/20 Page 4 of 22 2nd Quarter 2020.pdf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY SECOND QUARTER 2020 2nd Quarter 2020.pdf 2nd Quarter OUST FUND# ACCOUNT DIVISION Jan - Mar Y.T.D. 329 Pontiac W WTP Transaction $0.00 $0.00 906 Public Health Grant 795 $0.00 $0.00 791 Radio Communications - E911 $28,032.50 $71,055.00 695 Risk Management $6,063.75 $12,309.00 638 Tax Management System $39,979.75 $78,612.75 973 UCC Program II $42,319.75 $85,090.50 115 UCC Program III - VOIP $53,381.50 $86,460.00 656 Water Resources Accounting $1,342.44 $1,672.44 731 Water Resource - Equipment $247.50 $880.77 736 WinCan Central Storage Solution $0.00 $0.00 930 Water and Sewer -General Adm $0.00 $0.00 939 Water and Sewer General Administration $0.00 $0.00 974 Water and Sewer Gen Admin-WMU $327.75 $327.75 201 Water and Sewer Gen Adm -XC2 $0.00 $595.00 850 Workforce Dev Division $0.00 $0.00 281 WRC $0.00 $0.00 670 WRC Acctg - Crowder Prjct $0.00 $0.00 344 WRC Administration $0.00 $0.00 929 WRC Aeration Tank Rehab $0.00 $0.00 940 WRC -CAMP $1,155.00 $2,846.25 926 WRC CLINTON-OAKLAND SCADA $0.00 $0.00 932 WRC CLINTON-OAK SDS SCADA Main $0.00 $0.00 277 WRC-GWK PCF -WRC SCADA $0.00 $0.00 377 WRC - SAW ACACIA $0.00 $0.00 382 WRC -SAW Birmingham $0.00 $0.00 379 WRC - SAW Commerce Township $0.00 $0.00 387 WRC- SAW Evergreen Farmington $0.00 $0.00 389 WRC - SAW Lake Orion $0.00 $0.00 388 WRC - SAW Novi $0.00 $0.00 386 WRC - SAW Orchard Lake $0.00 $0.00 674 WRC - SAW Grant Labor $0.00 $0.00 381 WRC SAW GWK $0.00 $0.00 895 WRC AGO $0.00 $0.00 734 WRC -AMR Support $0.00 $0.00 980 WRC Bingham Farms SAW $0.00 $0.00 745 WRC - COSDA Meter Replacement $0.00 $0.00 728 WRC - CO SDS SewMet $0.00 $0.0D 168 WRC CRWRRF Admin Bldg Rehab $86.00 $1,616.50 729 WRC - EF SDS SewMet $0.00 $0.00 737 WRC - Data Application Pilot Poject $0.00 $0.00 300 WRC - GIS Allocation by Labor $0.00 $0.00 Prepared By: Information Technology; 04/21120 Page 5 of 22 2nd Quarter 2020.pdf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY SECOND QUARTER 2020 63600-1080101-152000-631302 NON -COUNTY AGENCIES 63600-1080101-152000-635017 SUB -TOTAL DIRECT CHARGES FOR DEVELOPMENT TOTAL COUNTY DEVELOPMENT CHARGES Non -County Agencies $1,081.224.78 $2,023.694.21 $2.172,770.51 $4.112,661.52 $10,815.75 $19,039.25 Prepared By Information Technology; 04/21/20 Page 6 of 22 2nd Quarter 2020.pdf 2nd Quarter CUST FUND# ACCOUNT DIVISION Jan - Mar Y.T.D. 277 WRC -GWK PCF -WRC SCADA $0.00 $0.00 295 WRC- HACH WIMS Implementation $0.00 $10,629.00 894 WRC - HACH WIMS Implementation Phase II $9,870.00 $9,870.00 733 WRC - Hydro Drain Project $0.00 $0.00 671 WRC - Infrastructure Op Ar $0.00 $0.00 982 WRC Keego Harbor SAW $0.00 $0.00 299 WRC - MISS DIG Ticket Mgmt Sys $0.00 $0.00 981 WRC Oxford Twp SAW $0.00 $0.00 501 WRC Permitting Impl $1,237.50 $2,557.50 979 WRC Permitting Implementation $1,320.00 $5,740.75 990 WRC Regional Systems Unit $0.00 $0.00 986 WRC Royal Oak Twp SAW $0.00 $0.00 686 WRC - SAW Grant Labor - Common to All $0.00 $0.00 402 WRC SAW Huron Rouge $0.00 $0.00 403 WRC SAW Bloomfield Village $0.00 $470.00 739 WRC - SCADA Common $0.00 $0.00 738 WRC - SCADA Engineering Assessment $0.00 $0.00 358 WRC- SCADA Maintenance $172.00 $505.50 067 WRC Utility Billing Replacement $6,720.00 $6,720.00 023 WRC Walled Lake Water $0.00 $0.00 024 WRC Walled Lake SDS $0.00 $0.00 121 WRC Website Standardization $351.75 $3,198.00 170 WRC WMU Meter Maintenance $0.00 $0.00 63600-1080101-152000-631302 NON -COUNTY AGENCIES 63600-1080101-152000-635017 SUB -TOTAL DIRECT CHARGES FOR DEVELOPMENT TOTAL COUNTY DEVELOPMENT CHARGES Non -County Agencies $1,081.224.78 $2,023.694.21 $2.172,770.51 $4.112,661.52 $10,815.75 $19,039.25 Prepared By Information Technology; 04/21/20 Page 6 of 22 2nd Quarter 2020.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2020 Cust a GOVERNMENTAL FUNDS 2nd Qtr 2020 630 ANIMAL CONTROL 24017 SQL Server Supp -Animal Control $51.98 95628 Animal Control $7,294.50 95682 Dog System8$ .252.50 Animal Control -Total $15,598.98 005 BD OF COMMISSIONERS 91404 BOC - Customer Support $9,587,25 Bd of Commissioners - Total $9,587.25 508 BOC- LEGAL RESOURCE CENTER 61001 Library Services $1,707.75 91405 Library Board $165,00 BOC -Legal Resource Center - Total $1,872.75 665 CHILDRENS VILLAGE 95665 Childrens Village $17.198.80 Childrens Village - Total $17,198.80 668 CHILDREN'S VILLAGE ADMIN 97668 Childrens Village Admin $0.00 Childrens Village Admin - Total $0.00 725 CLERK/REG - ADMIN 72500 Clerk - Admin $9.00 Clerk/Reg - Admin - Total $0.00 440 CLERKIREG - ELECTIONS DIVISION 95443 Clerk/Reg - Elections Division 5 052.25 Clerk/Reg - Elections Division - Total $5,052.25 722 CLERKIREG -EDMS (IMAGINGI, 13001 Clerk's -E51ing $0.00 95158 Clerk/Reg- EDMS Support/Maintenance/Upgrades5$ .238.76 Clerk/Reg - EDMS (Imaging) - Total $5,238.76 410 CLERK/REG - JURY COMMISSION 95512 Clerk/Reg - Jury Commission $165.00 ClerkfReg - Jury Commission - Total $165.00 724 CLERK/REG - LEGAL RECORDS 95189 Circuit Court System $44.193.75 Clerk/Reg - Legal Records - Total $44,193.75 723 CLERK- VITAL STATISTICS 24015 SQL Server Supp - Vital Stats 3.5% $51.98 95161 Clerk.Reg-Vital Statistics $25.074.75 Clerk - Vital Statistics - Total $25,126.73 522 COMMUNITY CORRECTIONS -ADMIN CO). 23003 Oracle Support -Comm Corr - 5.2% $476.19 24012 SQL Server Supp- Community Corr 3.5% $51.98 52200 Comm Corr -Admin (County) $26,886.25 52201 Comm Corr -DVJ Support $0.00 Community Corrections - Total $27,414.42 620 COMPLIANCE OFFICE -AUDITING 44034 Auditing - New Development $0.00 Prepared By: Information Technology; 04/21/20 Page 7 of 22 2nd Quarter 2020.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2020 95468 Auditing Internal Sw - Cust Sup $0.00 Compliance Office - Auditing - Total $0.00 690 COMPLIANCE OFFICE - PURCHASING 44028 Purchasing System Enhancements $146.00 44029 Pur -New Development $1,34475 Compliance Office - Purchasing - Total $1,490.75 430 CORPORATION COUNSEL 95501 Corporation Counsel $17,44875 Corporation Counsel - Total $17,448.75 015 COUNTY EXECUTIVE 95654 County Exec -Development $18,889.00 95656 County Executive Support $23,658.50 County Executive - Total $42,547.50 450 CIRC CT PROBATION - NORTH 80204 Circuit Court Probation - North $17400 Circuit Court Probation - North - Total $174.00 495 CTS -BUSINESS DIVISION 12002 CCT-Courts/Criminal $0.00 23010 Oracle Support-CCT/CTS Crim Whse 2.6% $000 CTS -Business Division - Total $0.00 506 CTS -FAM DW -JUDICIAL SUPPT 95187 CTS-Fam Div -Judicial Support $000 CTS-Fam Div -Judicial Support- Total $0.00 483 CTS-FDJUDICIAL SUPPORT•ADM 24009 SQL Sew Supp - CTS -Jud Sup Adm - 3.5% 151.98 CTS -FD -Judicial Support -Adm - Total $51.98 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 23010 Oracle Supp-CCT/CTS $238.12 95179 CTS -Gen Juris-Judicial Suppt $187.304.50 CTS -Gen Juns-Judicial Suppt- Total $187,542.62 502 CTS-GJJURY OPERATIONS 23008 Oracle Support -CTS -GJ -Jury Operations $476.19 CTS -GJ -Jury Operations - Total $476.19 493 CTS -JUDICIAL ADMIN 13002 Court's - Efiling $0.00 95174 CTS -Judicial Admin $7,209.44 CTS -Judicial Admin - Total $7,209.44 188 ECONOMIC DEV & COMM AFFAIRS 98180 Economic Dev & Comm Affairs $198.00 Economic Dev & Comm Affairs - Total $198.00 785 ECONOMIC DEVELOPMENT & COMMUNITY AFFAIRS 36500 GIS Implementation Support C&E Dev $495.00 36501 CED Application - HNV Support $0.00 95785 Comm & Eco Developmt $2.644.25 Prepared By: Information Technology; 04/21/20 Page 8 of 22 2nd Quarter 2020.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2020 Economic Development & Community Affairs - Total $3,139.25 740 EQUALIZATION 23012 Orade Support -Equalization - 5.2% $476.19 24005 SQL Server Supp -Equalization -10.5% $155.93 31075 Equal - Development $616.00 36505 GIS Implementation Support Equalization $288.75 36506 Equal Application - HfW Support $17,812.50 36507 Equal LAMS Support $10,563.25 36601 Land System Enhancements - Equal (50%) $9,689.41 36701 Land System Maintenance - Equal (50%) $1,410.01 36601 Land System Support - Equal (50%) $7,218.77 36902 BS&A Orion Twp $0.00 50101 EQUAL (BS&A ANNUAL) $860.63 95562 Equalization - DW Support $0.00 95693 Equalization - System Maintenance $0.00 95699 BS&A Master Appraisal Sup/Mamt $34.651 00 Equalization - Total $83,742,44 660 FISCAL SERVICES ADMIN 23001 Oracle Support - Fiscal Sew -15.6°/ $1,428.57 23013 Oracle Support - HR-Acctg/Budget - 5.2% $476.19 24006 SQL Sew Supp - HR-Acctg - 1.75% $2600 44021 FS-System/Customer Support $8,716.50 44022 FS - System Maintenance $73.00 44023 FS - System Enhancements $000 44024 FS - New Development $0.00 44602 Bond Disclosure - Fiscal (50%) $0.00 96001 Fiscal Sew - Acctg 40% $6,911.40 96003 Fiscal Sew - Budget 20% $3,455.70 Fiscal Services Admin - Total $21,087.36 840 HEALTH DIVISION 36525 GIS Implementation Support Health $0.00 95563 User Support -Health $25,747.25 96842 Health Admin71$ .426.00 Health - Total $97,173.25 852 HEALTH CENTRAL SUPPORT 95852 Health Central Support $2,986.50 Health Central Support - Total $2,986.50 843 HEALTH - ENVIRONMENTAL 23005 Oracle Support - EH Projects - 5.2% $476.19 24014 SQL Server Suppl- Ehealth 14% $207.90 84200 EH - Projects $67,418.44 84300 Ehealth Program3$ .720.25 Health -Environmental - Total $71,822.78 183 HEALTH WEBSITE REDESIGN 96183 Health Website Redesign $0.00 Health Website Redesign - Total $0.00 Prepared By: Information Technology: 04/21/20 Page 9 of 22 2nd Quarter 2020.pdf 900 HOMELAND SECURITY 680 HUMANRESOURCES 907 LIBRARY -LIBRARY ADMIN 824 LIBRARYSERVICES 565 MARKETING & COMMUNICATIONS 872 MEDICALEXAMINER 296 MSU -DIGITAL MEDIA SERVICES 710 MSU EXTENSION - OAKLAND 349 OCSO ADMIN SERV -RECORDS MGMT 648 OCSO ADMIN SERV - SHERIFF ADMIN 163 OCSO-CLEMIS FORENSIC LAB IMS 775 PLANNING & ECO DEVELOPMENT 512 PROS-ESTATESIMENTL HLTH EDMS (IMG 510 PROB-ESTATES/MENTL HLTH SUPPORT Prepared By: Information Technology; 04/21/ INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - SECOND QUARTER 2020 36545 20 GIS Implementation Support Homeland Security 36546 Homeland Security Application - HAN Support 98990 Homeland Security Homeland Security - Total 23014 Oracle Support-HR/Personnel -520/ 24007 SQL Server Suppport-HR/Personnel - 1.75% 44044 HR- New Development 96D02 Human Res -Personnel 40% Human Resources - Total 91405 Library Board Library - Library Admin - 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 97349 OCSO Admin Sew - Records Mgmt OCSO Admin Sew - Records Mgmt - Total 97646 OCSO Admin Sew - Sheriff Admin OCSO Admin Sew - Sheriff Admin - Total 16300 OCSO-CLEMIS Forensic Lab OCSO-CLEMIS Forensic Lab IMS - Total 95600 PEDS Cust/System Support Planning & Eco Development - Total 1 95207 PC-EJMH EDMS Support & Mlce Prob-Est/Mntl Hlth EDMS (Img) - Total 24010 SOL Sew Supp-PCT-EsUMental - 3.5% 92198 Pmb-ESUIV1nil Him Support Page 10 of 22 $247.50 $14,396.25 $13 629.50 $476.19 $26.00 $0.00 $15,509.19 $0.00 $000 736.25 $51.98 $13,936.75 $0.00 $0.00 $2,491.50 98.75 $0.00 $4,6090 $4,5133.94 $51.98 $15.242.75 $28,273.25 $16,011.38 $0.00 $000 $736.25 $13,988.73 $0.00 $0.00 $2,491.50 $198.75 $0.00 $4,609.00 $4,583.94 2nd Quarter 2020.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2020 Prob-Est/Mntl Hlth Support - Total $15,29473 481 PROB-FD JUDICIAL 95168 PC -Judicial Family Admin -Family Judges $0.00 Prob - FD Judicial - Total $0.00 145 PROSECUTOR -GENERAL PROSECUTION 24016 SQL Server Supp - Proescutors 3.5% $51.98 95622 Prosecutor/Executive $13,12175 95664 Prosecutor Warrants $0.00 97001 Prosecutor Data Proc $267.00 Prosecutor - Total $13,440.73 637 RECORDS RETENTION 44053 REC - System Enhancements $0.00 Records Retention - Total $0.00 650 REIMBURSEMENT 95470 Reimbursement System $2,05825 95542 Reimburse User Support 0.00 Reimbursement - Total $2,058.25 195 SHERIFF 12001 OCSD-Courts/Criminal - 50% $0.00 23009 Oracle Suppport -OCSD/CTS Crim Wnse-2.6% $238.12 97163 Sheriff $2,429,85 97164 Sheriff - Development $0.00 97165 Sheriff -DW Support $0.00 98164 CLEMIS-Sheriff $68.782.25 Sheriff - Total $71,450.22 191 SHERIFF-CLEMIS 23015 Oracle Suppport- Sheriff / CLEMIS - 5.2% $476.19 96163 Sheriff - CLEMIS 12,75000 Sheriff - CLEMIS - Total $3,226 19 348 SHERIFF -CORRECTIVE SERV ADMIN 34800 Inmate Phone System 0.00 Sheriff - Corrective Sew Admin - Total $0.00 988 OC SHERIFF's - IFS DIV - LAB 16300 OCSO CLEMIS Forensic $1,547.50 OCSO CLEMIS Forensic - Total $1,547.50 647 OCSD PATROL SERV -LE ADMIN 97647 Sheriff - Patrol Sew -LE Admin $0.00 Sheriff -Patrol Sew -LE Admin -Total $0.00 445 SUPPORT SERVICES 23002 Oracle Support - Supp Sery-5.2% $476.19 24011 SQL Server Supp - Suppt Services 7% $103.95 44500 Support Services2$ .083.50 Support Services - Total $2,663.64 600 TREASURER 23006 Oracle Support - Del Tax - 5 2% $476.19 23016 Oracle Support -Treasurer -104% $952.38 36516 Treasurer Application - H/W Support $0.00 Prepared By Information Technology; 04121/20 Page 11 of 22 2nd Quarter 2020.pdf 169 TREASURERS -BANKING 627 TREASURER-LANDSALE 978 TREASURERS OFFICE -OAKDOCS 910 VETERANS SERVICES 730 WATER RESOURCE COMMISSIONER INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2020 36602 36702 36802 44061 44062 44063 44064 44080 44082 44601 50102 95008 95303 95561 95615 96169 44083 95978 95650 95651 24008 28007 28010 28011 36520 36521 742 WRC -CAMS SOFTWARE SUPPORT & MAINTENANCE 74200 022 WRC GIS LAYER 35022 301 WRC -SOIL EROSION SOFTWARE SOL 74301 Land System Enhancements - Trees (50% Land System Maintenance - Trees (50%) Land System Support -Treas (50%) Tre-System/Customer Support Tre-System Maintenance Tre-System Enhancements Tre-New Development Tre-DW Support Tre-DW Maintenance Bond Disclosure - Tress 150%) TREAS(BS&A)ANNUAL Del Tax On Line Del Tax System Maintenance User Support/Del Tax BS&A Annual Tax Support Treasurer- Total Treasurers -Banking RFP Treasurers -Banking RFP - Total Treasurer-Landsale Treasurer -Landsale- Total Treasurers Office-Oakdocs Treasurers Office-Oakdocs - Total Veterans Services Equipment Veterans Customer Support Veterans Services - Total SQL Server Supp - WRC 3.5°% Water Resource Commission WRC - Customer Support Water Resource Commissioner Application GIS Implementation Support WRC WRC Application - H/W Support Water Resource Commissioner - Total WRC CAMS SOFTWARE Support WRC CAMS SOFTWARE Support - Total WRC GIS Layer WRC GIS Layer - Total WRC - Soil Erosion Software Sol VVRC - Soil Erosion Software Sol - Total Prepared By Information Technology; 04/21/20 Page 12 of 22 $9,689.34 $1,409.99 $7,218.73 $42,879.94 $6,253.75 $143.00 $000 $000 $000 $000 $86062 $000 $000 $15,47500 65.00 $85,52394 149.00 $1,149.00 $000 $0.00 $47,639.00 $47,639.00 $8,16150 $2,87700 $11,03850 $5198 $000 $20,48500 $5,60600 $1,03125 $35,72250 $62,89673 $0.00 $000 0.00 $0.00 $000 $0 00 2nd Quarter 2020 pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2020 540 52/1 DISTRICT COURT - NOVI 95527 DC Suprt- 52/1 - 25% $3,54630 52/1 District Court - Total $3,546.30 550 52/2 DISTRICT COURT - CLARKSTON 95528 DC Suprt- 52/2 - 250/ $3,546.30 52/2 District Court - Total $3,54630 560 52/3 DISTRICT COURT - ROCHESTER 95288 52 Dist Ct Div 3 $0.00 95529 DC Suprt - 52/3 - 25% 13 546 30 52/3 District Court - Total $3,546.30 530 52/4 DISTRICT COURT - TROY 95530 DC Suprt- 52/4 - 25% $3,54610 52/4 District Court- Total $3,54610 $1,091,545.73 Custa DIRECT FUNDS, 274 ASAP PASSPORT SYSTEM 97274 ASAP Passport System $0.00 ASAP Passport System - Total $0.00 672 ASSESSMENT & TAX 67200 Assessment & Tax $154.00 Assessment & Tax - Total $154.00 935 AUGUSTA SAW GRANT 37935 Augusta SAW Grant $000 Augusta SAW Grant- Total $0.00 073 BICENTENNIAL CELEBRATION 91073 Bicentennial Celebration Grant $293.25 Bicentennial Celebration Grant - Total $29325 944 CAMP CTA DR EQUIPMENT 37944 Camp CTA DR Equipment $13,267.25 Camp CTA DR Equipment - Total $13,267.25 055 CLEMIS 23004 Oracle Support- OakVideo CLEMIS 5.2% $476 19 23018 Oracle Support - Sheriff CLEMIS 5 2% $476.14 24004 SQL Server Support - 24.5% $363.83 95430 CLEMIS Maintenance $22,32225 95431 CLMS Enhancements $000 98000 Project Team $37125 98003 CLEMIS User Support $36650 98005 CLEMIS - E911 Support $0.00 98000 Poject Team $000 CLEMIS - Total $24,376.16 699 CLEMIS - CAD 98006 CLEMIS - CAD Development $0.00 CLEMIS - CAD - Total $000 056 CLEMIS FUND 63500 63500 CLEMIS Fund J43 —48Z_75 Prepared By: Information Technology; 04/21/20 Page 13 of 22 2nd Quarter 2020.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2020 CLEMIS 63500 Fund - Total $43,482.75 448 CLEMISIFRMS NON -BILLABLE 44600 CLEMIS/FRMS NON -BILL ($24750) CLEMIS/FRMS NON -BILL - Total ($24750) 669 CAMSICVT DATA CONVERSION 66901 CAMS/CVT Data Conversion 0.00 CAMS/CVT Data Conversion - Total $000 749 CLERK/REG - CPL 74900 Clerk/Reg - CPL $0.00 Clerk/Reg - CPL - Total $0.00 720 CLERK/ REGISTER OF DEEDS 24003 SQL Server Supp - ROD 3.5% $5198 36510 GIS Implementation Support $000 36511 ROD Application - H/vV Support $7,183.00 95493 ROD System Maintenance $0.00 95498 Clerk/Reg - ROD $2,07Z25 Clerk/Reg of Deeds - Total $9,30723 719 CLERK/ROD AUTOMATION FUND 95719 Clerk/ROD Automation Fund $19,77975 Clerk/ROD Automation Fund - Total $19,779.75 659 COLLABORATIVE ASSET MGT SYS 65901 Collabortrve Asset Mgt Sys $000 Collabortive Asset Mgt Sys - Total $0.00 937 COSDS SAW GRANT 37937 COSDS SAW Grant $45150 COSDS SAW Grant- Total $451.50 471 CTS -FOC -EXP -CS ENFORC-EDMS (IMGI 92194 CTS -FOC -CS ENF-EDMS Support/Maintenance/Upgrades $000 CTS -FOC Exp -CS Enforc-EDMS (Img) - Total $0.00 507 CTS -FOC EXP -CS ENFORCEMENT 92193 CTS -FOC Exp -CD Enforc-Dev $24,492.75 92194 CTS -FOC -CS ENF-EDMS $4,583.94 CTS -FOC Exp -CD Enforc-Dev - Total $29,076.69 521 COMM CORR - ADM (GRANT) 52100 Community Corrections C`Star EB $813.00 Comm Corr- Adm (Grant) - Total $81300 673 CYBER SECURITY FUND 67300 Cyber Security Fund 0.00 Cyber Security Fund - Total $000 931 DRAIN EQUIPMENT FUND 37934 Drain Equipment Fund 0.00 Drain Equipment Fund - Total $0.00 189 DRAIN EQUIPMENT FUND - POWERPLAN CONTRACT 35189 Drain Equipment Fund - Powerplan Contract $000 Drain Equipment Fund - Powerplan Contract - Total $0.00 Prepared By: Information Technology; 04/21/20 Page 14 of 22 2nd Quarter 2020.pdf 933 DRAIN EQUIP MAP 837 EDCA - MITRADESCHOOL.ORG GRANT 167 EDWARDS DRAIN SAW GRANT 100 FARMINGTON HILLS SDS SAW 210 FIRE RECORDS MANAGEMENT SYSTEM 750 FM&O 756 FM&O BUILDING MAINTENANCE 133 FM&O BUILDING MANAGEMENT SYS 048 FM&O BLDG SECURITY ENH PROJ 080 FMO BLDG SYSTEMS REP PH 2 963 FOC SECURITY AUDIT 942 FRANKLIN SAW GRANT 380 HEALTH -IMMUNIZATION GRANT 173 HEALTH - LEAD INNOVATION GRANT 071 HEALTH LEAD PSA GRANT Prepared By Information Technology; 04/21/20 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - SECOND QUARTER 2020 37933 Drain Equip Map Drain Equip Map - Total 83700 EDCA- MITRADESCHOOL EDCA - MITradeSchaol.org Grant - Total 33167 Edwards Drain SAW Grant Edwards Drain SAW Grant- Total 33099 Farmington Hills SDS SAW Farmington Hills SDS SAW - Total 21010 Fire Records Mgmt Fund 531 95404 SQL Server Support - FRMS 3 5% 24001 FRMS - Phase II Prot 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 40400 FM&O Building Management Sys FM&O Building Management Sys - Total 75048 FM&O Bldg Security Enh Prof FM&O Bldg Security Enh Prot - Total 2108D FMO Bldg Systems Rep FMO Bldg Systems Rep - Total 34963 FOC Security Audit FOC Security Audit - Total 37942 Franklin SAW Grant Franklin SAW Grant - Total 38000 Health -Immunization Grant Health -Immunization Grant - Total 96173 Health - Lead Innovation Grant Health - Lead Innovation Grant - Total 96071 Health Lead PSA Grant Page 15 of 22 $3,369.75 $3,369.75 $000 $0.00 $000 $000 61.50 $61.50 $000 ($2,47500) 51 98 ($2,42302) $1,83980 $51.98 $35,620.25 $37,51203 $000 $0.00 $000 $000 $57475 $57475 $3,48225 $3,48225 $000 $0.00 0.00 $000 $000 $o.00 $000 $000 $Z916 25 2nd Quarter 2020.pdf 020 HENRY GRAHAM DRAIN SAW GRANT 947 HIPAA ENHANCEMENTS 120 HR -FINANCIAL SYS REP 214 IAM PROGRAM 338 IMAGING PROJECT 751 IT - TELEPHONE COMMUNICATIONS 113 MIDC CLEMIS DEV 634 OAKVIDEO UPGRADE (BA) 938 OAKWIN RADIO SYSTEM ENH 043 OC BICENTENNIAL OAK200 653 O.C. INTNL AIRPORT 934 OLV SDS SAW GRANT 770 PARKS AND RECREATION Prepared By Information Technology; 04/21/20 INFORMATION TECHNOLOGY - RESERVEFUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2020 $2,91625 Health Lead PSA Grant - Total 35020 Henry Graham Drain SAW Grant Henry Graham Drain SAW Grant - Total 96947 HIPPA Enhancements II HIPPA Enhancements II - Total 44120 HR -Financial System Replacement HR -Financial System Replacement- Total 21400 IAM Program IAM Program - Total 33800 Imaging Project Imaging Project - Total 75102 Telephone Communications - Customer Support IT - Telephone Communications - Total 91113 MIDC Clemis Dev MIDC Clemis Dev - Total 63400 CLEMIS - OakVideo Upgrade 63401 IT - OakVideo Upgrade OakVideo Upgrade (BA) - Total 98938 OAKWIN Radio System Enh OAKWI N Radio System Enh - Total 96043 OC Bicentennial OAK200 OC Bicentennial OAK200 - Total 36540 GIS Implementation Support 65301 Airport User Support 65310 0 C Airport - New Development Saw OC Intnl Airport - Total 37934 OLV SDS SAW Grant OLV SDS SAW Grant - Total 36530 GIS Implementation Support- Parks 44066 PRADM-System/Customer Support 44068 PRADM-System Enhancements 76100 P&R Administrative Services 95413 PRADM-Customer Support 95416 PHRA -Rec Admin Page 16 of 22 2nd Quarter 2020 pdf $2,91625 0.00 $0.00 $20,38850 $20,38850 $474.061 25 $474,06125 $138.007 50 $138,007.50 $43.101 75 $43,101.75 06.00 $10600 16A26 50 $6,426.50 $0.00 0.00 Saw $000 $000 $5,565.00 $5,565.00 $0.00 $5,940.00 276.00 $6,216.00 0.00 $000 $1,03125 $1,48500 $0.00 $0.00 $5,981.25 $000 2nd Quarter 2020 pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2020 95419 PRADM-Administration $0.00 Parks & Recreation - Total $8,497.50 867 P&R CAPITAL IMPROVEMENT 86700 P&R Capital Improvement $000 P&R Capital Improvement - Total $000 925 P&R EMS UPGRADE 37925 P&R EMS Upgrade 0.00 P&R EMS Upgrade - Total $0.00 442 P&R LYON OAKS CONF CTR CIP#2469 44200 P&R Lyon Oaks Cont Ctr CIP #2469 $000 P&R Lyon Oaks Conf Ctr CIP #2469 - Total $0.00 443 P&R LYON OAKS CONF CTR CIP#2468 44300 P&R Lyon Oaks Cent CTR CIP#2468 0.00 P&R Lyon Oaks Cent CTR CIP#2468 - Total $000 454 P&R SPRINGFIELD OAKS CIP42471 45400 P&R Springfield Oaks CIP#2471 $000 P&R Springfield Oaks CIP#2471 - Total $0.00 456 P&R SPRINGFIELD OAKS CIP#2470 45600 P&R Springfield Oaks CIP#2470 $000 P&R Springfield Oaks CIP#2470 - Total $0.00 457 P&R RED OAKS CLUBHOUSE CIP#2467 45700 P&R Red Oaks Clubhouse CIP#2467 $000 P&R Red Oaks Clubhouse CIP#2467 - Total $000 268 PONTIAC METER 74268 Pontiac BSA to WRC - Water $000 Pontiac Meter - Total $0.00 747 PONTIAC WATER 74701 Pontiac BSA to WRC - Water $0.00 Pontiac Water - Total $0.00 748 PONTIAC SEWER 74702 Pontiac BSA to WRC - Sewer $000 Pontiac Sewer - Total $000 936 PONTIAC WATER ASSET MGMT 37936 Pontiac Water Asset Mgmt $0.00 Pontiac Water Asset Mgmt- Total $000 906 PUBLIC HEALTH GRANT 795 96906 Public Health Grant 795 0.00 Public Health Grant 795 - Total $0.00 329 PONTIAC WWTP TRANSACTION 67329 Pontiac WWiP Transaction 000 Pontiac WWiP Transaction - Total $000 791 RADIO COMMUNICATIONS - E911 79101 Radio Communications - E911 $28,03250 Radio Communications- E911 -Total $28,03250 695 RISK MANAGEMENT 44036 Rsk-System Customer Support $6,06375 Risk Management - Total $6,063.75 Prepared By: Information Technology; 04/21/20 Page 17 of 22 2nd Quarter 2020.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2020 638 TAX MANAGEMENT SYSTEM 973 UCC PROGRAM II 115 UCC PROGRAM III-VOIP 656 WATER RESOURCES ACCOUNTING 731 WATER RESOURCE - EQUIPMENT 736 WINCAN CENTRAL STORAGE SOLUTION 930 WATER AND SEWER -GENERAL ADMIN 939 WATER AND SEWER GENERAL ADMINISTRATION 974 WATER AND SEWER GEN ADMIN-WMU 670 WRC ACCTG- CROWDER PRJCT 344 WRC ADMINISTRATION 929 WRC AERATION TANK REHAB 980 WRC BINGHAM FARMS SAW 377 WRC -SAW ACACIA 940 WRC -CAMP Prepared By Information Technology, 04/21/20 63800 Tax Management System Tax Management System - Total 92973 UCC PROGRAM II UCC PROGRAM II - Total 92115 UCC Program III - VOIP UCC Program III - VOIP - Total 23011 Oracle Supp - Water & Sewer Accfg - 5.2% 95669 Water Resources Accounting 95671 Drain Water/Sewer BI Water Resources Accounting - Total 74501 Water Resources - Ops and PC net Water Resource - Equipment - Total 73601 WinCan Central Storage Solution WnCan Central Storage Solution - Total 37930 Water and Sewer -General Admin Water and Sewer -General Admin - Total 37939 Water and Sewer General Administration Water and Sewer General Administration - Total 37974 Water and Sewer General Admin - WMU Water and Sewer General Admin - WMU - Total 60001 WRC - Crowder NetBase Project 67000 WRC - Crowder NetBase Project WRC Acetg - Crowder Prject - Total 75344 WRC Administration WRC Administration - Total 35700 WRC Aeration Tank Rehab WRC Aeration Tank Rehab - Total 33980 WRC Bingham Farms SAW WRC Bingham Farms SAW - Total 28674 WRC - SAW ACACIA WRC - SAW ACACIA- Total 37940 WRC - Camp Page 18 of 22 $39.979.75 $39,979.75 $42.319.75 $42,319.75 $53,381.50 $53,381 50 $476.19 $866.25 $000 $1,34244 247.50 $247.50 $000 $0.00 $000 $000 $000 $000 327.75 $327.75 $0.00 $000 $0.00 $000 $000 $000 $0.0o $000 $000 $0.00 $0.00 $1,15500 2nd Quarter 2020.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2020 WRC - Camp - Total $1,155.00 926 WRC CLINTON-OAKLAND SCADA 33926 WRC Clinton -Oakland SCADA 0.00 WRC Clinton -Oakland SCADA - Total $0.00 932 WRC CLINTON-OAK SDS SCADA MAIN 37932 WRC Clinton -Oak SDS SCADA Main $0.00 WRC Clinton -Oak SDS SCADA Main - Total $000 168 WRC CRWRRF ADMIN BLDG REHAB 33168 WRC CRWRRF Admin Bldg Rehab8$ 6 00 WRC CRWRRF Admin Bldg Rehab - Totals $8600 277 WRC-GWK PCF -WRC 74277 WRC-GWK PCF -WRC 0.00 WRC-GWK PCF -WRC - Total $0.00 281 WRC 74281 WRC $0.00 WRC - Total $0.00 501 WRC PERMITTING IMPL 74502 WRC Permitting Impl $1,23750 WRC Permitting Imp[ -Total $1,237.50 979 WRC PERMITTING IMPLEMENTATION 74979 WRC Permitting Implementation1 3$ . 20 00 WRC Permitting Implementation - Total $1,320.00 981 WRC OXFORD TWP SAW 33981 WRC Oxford Twp SAW $0.00 WRC Oxford Twp SAW - Total $0.00 986 WRC ROYAL OAK TWP SAW 33986 WRC Royal Oak Twp SAW $000 WRC Royal Oak Twp SAW - Total $0.00 377 WRC - SAW ACACIA 28574 WRC - SAW Acacia $000 WRC - SAW Acacia - Total $000 382 WRC SAW BIRMINGHAM 33382 WRC SAW Birmingham $0.00 WRC SAW Birmingham - Total $0.00 379 WRC- SAW COMMERCE TOWNSHIP 33379 WRC- SAW Commerce Township 000 WRC - SAW Commerce Township - Total $0.00 386 WRC - SAW ORCHARD LAKE 33386 WRC - SAW Orchard Lake 0.00 WRC - SAW Orchard Lake - Total $0.00 674 WRC - SAW GRANT LABOR 28674 WRC - SAW Grant Labor $0.00 WRC - SAW Grant Labor - Total $0.00 381 WRC SAW GWK 33381 WRC SAW GWK $0.00 WRC SAW GWK - Total $000 Prepared By: Information Technology; 04/21/20 Page 19 of 22 2nd Quarter 2020.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2020 686 WRC -SAW GRANT LABOR - COMMON TO ALL 60002 WRC - SAW Grant Labor - Common to All $0.00 12686 WRC - SAW Grant - Common to All $0.00 WRC - SAW Grant Labor Common to All- Total $0.00 895 WRC AGO 37895 WRC AGO $0.00 WRC AGO - Total $000 734 WRC - AMR SUPPORT 73401 WRC - AMR Support $000 WRC - AMR Support - Total $000 745 WRC - COSDA METER REPLACEMENT 74500 WRC - COOSA Meter Replacement $0.00 WRC - COOSA Meter Replacement- Total $000 728 WRC - CO SDS SEWMET 72201 MARS Enhancements - WRC C -O 0.00 WRC - CO SDS SewMet - Total $0.00 729 WRC - EF SDS SEWMET 72202 MARS Enhancements - WRC E -F $000 WRC - EF SDS SewMet- Total $000 737 WRC - DATA APPLICATION PILOT PRJ 73700 WRC - Data Application Pilot Project $0.00 73710 WRC - Data Appl Pp $0.00 WRC - Data Application Pilot Pr1- Total $000 300 WRC -GIS ALLOCATION BY LABOR 73300 WRC -GIS Allocation by Labor $0.00 WRC -GIS Allocation by Labor - Total $0.00 277 WRC-GWK PCF -WRC SCADA 74277 WRC -GWK PCF -WRC SCADA WRC - GWK PCF -WRC SCADA - Total $000 $000 295 WRC HACH WIMS IMPLEMENTATION 67295 WRC-HACH WIMS Implementation $000 WRC-HACH WIMS Implementation - Total $0.00 894 WRC - HACH WIMS IMPLEMENTATION PHASE II 37894 WRC-HACH WIMS Implementation Phase II $9,870.00 WRC-HACH WIMS Implementation Phase II - Total $9,870.00 733 WRC -HYDRO DRAIN PROJECT 73301 WRC -Hydro Drain Project $000 WRC -Hydro Drain Project- Total $000 671 WRC - INFRASTRUCTURE OP AR 67100 WRC -10 AR $000 WRC - Infrastructure Op Ar - Total $000 299 WRC -MISS DIG TICKET MGMT SYS 74299 WRC -MISS Dig Ticket Mgmt Sys $0.00 WRC -MISS Dig Ticket Mgmt Sys - Total $0.00 990 WRC REGIONAL SYSTEMS UNIT 37990 WRC Regional Systems Unit $000 WRC Regional Systems Unit - Total $0.000 Prepared By. Information Technology; 04/21/20 Page 20 of 22 2nd Quarter 2020.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2020 387 WRC SAW EVERGREEN FARMINGTON 33387 WRC SAW Evergreen Farmington $0.00 WRC SAW Evergreen Farmington - Total $0.00 389 WRC SAW LAKE ORION 33389 WRC SAW Lake Orion $000 WRC SAW Lake Orion - Total $000 402 WRC SAW HURON ROUGE 33402 WRC SAW Huron Rouge $000 WRC SAW Huron Rouge Total $000 403 WRC SAW BLOOMFIELD VILLAGE 33403 WRC SAW Bloomfield Village $0.00 WRC SAW Bloomfield Village - Total $0.00 739 WRC-SCADA COMMON 73900 WRC -SCALA Common $000 WRC - SCADA Common - Total $000 738 WRC - SCADA ENGINEERING ASSESSMT 73800 WRC - SCADA Engineering Assesmnt $000 WRC - SCADA Engineering Assesmt- Total $000 358 WRC- SCADA MAINTENANCE 33358 WRC- SCADA Maintenance 17200 WRC - SCADA Maintenance - Total $172.00 067 WRC UTILITY BILLING REPLACEMENT 33067 WRC Utility Billing Replacement $6,72000 WRC Utility Billing Replacement - Total $6,72000 121 WRC WEBSITE STANDARDIZATION 33121 WRC Website Standardization 351 75 WRC Website Standardization - Total $351 75 170 WRC WMU METER MAINTENANCE 33170 WRC WMU Meter Maintenance 0.00 WRC WMU Meter Maintenance - Total $0.00 $1,081,224.78 Prepared By. Information Technology, 04/21/20 Page 21 of 22 2nd Quarter 2020.pdf INFORMATION TECHNOLOGY DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2020 Prepared By: Information Technology; 04/21/20 Page 22 of 22 2nd Quarter 2020.pdf 2nd Quarter I Y.T.D. Radio 18020 IT Radia 0.00 0.00 $0.00 $0.00 Application Services 17040 IT - TOS Fund $0.00 $0.00 18000 (MACS Data Warehouse (Funded) $0.00 $0.00 19000 IT Application Services Planned Maint $402,510.25 $872,727.50 30001 IT Application Services Data Warehouse $19,936.25 $29,450.00 30002 IT Application Services Enhanced $8,602.25 $19,043.50 30003 IT Application Services GIS $93,895.50 $211,620.25 30004 IT Application Services eGovernment $405,254.50 $789,814.00 25108 Courts - Oakland Schools $0.00 $0.00 36901 BS&A Orion Twp - IT 0.00 0.00 App Services - Sub Total: $930,198.75 $1,922,655.25 Internal Services 19020 Internal Services Planned Main $76,808.25 $158.457.75 Internal Services - Sub -Total: $76,808.25 $158,457.75 $0.00 Technical Sys/Networking 19030 Tech Sys/Net Planned Maint $90128.50 $183,427.55 23007 Oracle Support - IT Tech Systems $476.19 $531.96 23017 Oracle Support - IT Tech Systems 1.2% $109.89 $122.76 24018 SQL Sery Support - IT Tech Systems 2% $29.61 $45.91 25400 Oracle Administration $3,465.00 $7,012.50 95685 I.T. - Disaster Recovery $0.00 $0.00 95750 I.T. - SEP $105,759.50 $230,646.75 95755 I.T. - PeopleSoft Upgrade 0.00 0.00 Tech Sys/Net- Sub -Total: $199,968.69 $421,787.43 Information Technology - Total: $1,206,975.69 $2,502,900.43 Prepared By: Information Technology; 04/21/20 Page 22 of 22 2nd Quarter 2020.pdf Resolution #20174 June 4, 2020 Moved by Gershenson seconded by Luebs the resolutions on the amended Consent Agenda be adopted. Discussion followed. Vote on Consent Agenda, as amended: AYES: Hoffman, Jackson, Kochenderfer, Kowall, Kuhn, Long, Luebs, Markham, McGillivray, Middleton, Miller, Nelson, Powell, Quarles, Spisz, Taub, Weipert, Woodward, Zack, Gershenson. (20) NAYS: None. (0) A sufficient majority having voted in favor, the resolutions on the amended Consent Agenda were adopted. 41, QVETHIs RESOLUTION 1 HEREBY APPA 0141EF I)EPUTY COUNTT,' EXECUTIVE ACTING PURSUANT TO MCL 45.559A M 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 June 4, 2020, 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 Circuit Court at Pontiac, Michigan this 41h day of June, 2020. Lisa Brown, Oakland County