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.08.20 - 33592
MISCELLANEOUS RESOLUTION . #20329 August 20, 2020 BY: Commissioner Helaine Zack, Chairperson, Finance and Infrastructure Committee IN RE: INFORMATION TECHNOLOGY — THIRD 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 Third Quarter 2020 development charges to be $1,184,449.45 for the General Fund/General Purpose County departments; and WHEREAS direct charges to Special Revenue and Proprietary fund departments are $1,274,522.75 and non -county agencies are $11,471.28 for the Third 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 Third Quarter 2020 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 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 istrict #18 Chairperson, Finance and Infrastructure Committee FINANCE AND INFRASTRUCTURE COMMITTEE VOTE: Motion carried unanimously on a roll call vote. DUST FUND# 540 550 560 530 630 005 508 450 184 718 725 291 722 440 410 724 726 723 522 620 690 430 490 506 483 482 015 495 498 502 493 188 785 740 660 900 416 680 907 824 565 872 296 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 1D1 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 ACCOUNT GOVERNMENTALFUNDS General Fund [101] 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-5010101-165015-773630 10100-1070901-113270-773630 10100-2010210-132300-773630 10100-2010210-125000-773630 10100-2010201-180000-773630 10100-2010401-172190-T 3630 10100-2010210-125000-773630 10100-2010301-185010-773630 10100-2010501-125000-773630 10100-2010210-125000-773630 10100-2010601-172190-773630 10100-2010205-132305-773630 10100-1070401-113000-773630 10100-1010201-181010-773630 10100-1010210-182090-773630 10100-1010501-181020-773630 10100-3010402-135070-773630 10100-3010401421220-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-1090208-171000-773630 10100-1090101-171000-773630 10100-1020501-173010-773630 10100-1020601-182020-773630 10100-1060601-115090-773630 10100-1050403-183020-773630 10100-1050401-183010-773630 10100-5010303-165040-773630 10100-5010302-165020-773630 10100-1090108-171030-773630 10100-1070601-132030-773630 10100-1070501-174000-773630 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY THIRD QUARTER 2020 DIVISION 52/1 - District Court 52/2 - District Court 52/3 - District Court 52/4 - District Court Animal Control Bid of Commissioners BOC -Legal Resource Center Circuit Court Probation North Clerk's - County Clerk Clerk EServices Clerk/Reg - Admin Clerk Register Admin Clerk/Reg - EDMS (Imaging) Clark/Reg - Elections Clerk/Reg - Jury Commission Clerk/Reg - Legal Records clerk/Reg - Micrographics Clerk/Reg - Vital Statistics Community Corrections Admin Compliance Office - Auditing Compliance Office - Purchasing Corporation Counsel CTS -FD -CT Services - Clinic CTS-Fam Div-Jud,clal Support CTS -FD -Judicial Support ADM CTS -FD -Juvenile Support County Executive Courts -Business Division Courts-GJ�udicial Support Courts -GJ -Jury Operations Courts - Judicial / 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 & Communcations Medical Examiner MSU - Dlgrtal Media Services 3rd Quarter Apr -Jun $5,073 15 $5,073.15 $5,07315 $5,07280 $27 239 42 $4,79925 $211 75 $000 $000 $000 $000 $000 $3,14260 $9,878.75 $000 $54,486.51 $2,68966 $24,23616 $39 420 05 $000 $16,632.50 $23,478.25 $2,731 75 $5,61975 $867 $000 $14 682.25 S000 $201,44769 $94.38 $10,17529 $000 $371 25 $131,96535 $18 218 60 S24,44825 Woo $11,855.16 $000 $000 $6900 $10,35967 $000 Y.T.D. $10,99813 $10,998 13 $10,998 13 $10,99736 $70,71429 $20,64400 $4 515 50 $17400 $0 00 $000 $0.00 $000 $11,18420 $18 183 75 $16500 $144,84601 $2,689 66 S62,61078 $78,11338 $000 $61 92600 $61,37875 $2,73175 $5,61975 $89.54 $0.00 $102,37650 $000 $546,69420 S62634 $19,83725 $39600 $6,096.75 $256 328 41 $65,74735 $75,84225 $000 $45,79666 $000 $000 $2,72875 $54,52229 $000 Prepared By IrrH=aton Technology. 0712220 Page t e23 3rd Quarter 2020 xf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY THIRD QUARTER 2020 Prepared By InforrnaLon Teal 0722120 Pa9e2 o1 3,d Juarter 2020 pap 3rd Quarter OUST FUND# ACCOUNT DIVISION Apr - Jun Y.T.D. 710 101 10100-1070501-174000-773630 MSU E4eneon-Oakland $000 $28875 349 101 101004030501-112680-773630 OCSD Admin S., -Records Unit $23100 $2 887 50 648 101 101004030201-112580-773630 OCSD Armin S.,-ShefdPAdmin $O.00 $43725 163 101 101004030901-115140-773630 OCSO- CLEMIS Forensic Lab IMS $000 SOOO 775 101 10100-1090201-171000-773630 Planning& Economic Development $734250 $15,55875 479 101 10100-3D40101-121090-773630 Probate FD Judicial Support $000 $000 512 101 1D100-3040403-124010-773630 Probate-Estates/Mental Health - EDMS(imaging) $2,74979 $9,786.25 510 101 10100-3040403-124010-773630 Probate-Estates/Mental Health Support $13,80642 $42,585.79 481 101 10100-3040101-121060-773630 Probate -Family Division Judicial $8250 $8250 145 101 101004010101-122050-773630 Prosecutmg Attorney- General Prosecution $11,17953 $36,29040 637 101 10100-1030803-184020-773630 Records Retention $0.00 $000 650 101 10100-1020650-126020-773630 Reimbursement Division $10,17050 $20,15875 195 101 101004030301-112590-773630 OCSD-Correct1ve Sery - Admin $7401960 $199,42831 191 101 10100-4030601-110000-773630 Sheriff-CLEMIS $781388 $12,333.34 348 101 101004030301-112620-773630 Shenff- Corrective Sery Admm $144375 $1443.75 988 101 101004030901-116240-773630 Shenff - IFS Div Lab $120150 $4,25950 647 101 101004030601-110000-773630 Sheriff -Patrol Sery-LE Admin $0.00 $000 206 101 101004030901-110040-773630 Sheriff - LE Support- Sew Admin $0 DO $000 445 101 10100-1030803-184025-773630 Support Services $5,39996 $13,63287 600 101 10100-7010101-186040-773630 Treasurer $100,10329 $275,09335 169 101 10100-7010101-186080-773630 Treasurers -Banking RFP $000 $1,97525 627 101 10100-7010110-186130-773630 Treasurers - Landsale $000 $000 978 101 1010D-7010101-186050-773630 Treasurers Office-OakDocs $3356450 $83,94350 910 101 10100-1070301-132050-773630 Veterans Services $22,22100 $43,92EDO 730 101 10100-6010101-155010-773630 Water Resource Commissioner $69,95192 $19351979 742 101 10100-6010101-149920-7]3630 WRC - CAMS Software Support & Maintenance $000 $000 022 101 10100-6010101-174453-773630 WRC GIS Layer $000 $000 301 101 10100-6010101-174250-773630 WRC- Soil Erosion Software Sol $000 $000 Sub -Total Fund 101 $1,019,83585 $2,724,20249 Health Fund (2211 840 221 20221-1060201-133150-773630 Health $53,10800 $291,91175 852 221 20221-1060211-133150-773630 Health Central Support $91575 $5,79150 843 221 20221-10SD220-134390-773630 Health Environmental $8899082 5204,90089 183 221 20221-1060201-133150-773630 Health Website Redesign S000($860 001 Sub -Total Fund 221 $143,01457 $501,744.14 Juvenile Maintenance Fund 12931 665 293 20293-1060501-112090-773630 Children's Village $21,59903 $4747013 668 293 20293-1060501-112010-773630 Children's Village Admin $000 $000 Sub -Total Fund 293 $21,59903 $4747013 53600-1080101-152000-631365 DEVELOPMENT FOR GOVERNMENTAL FUND $1.184.449.45 $3273416.76 APPROPRIATION Prepared By InforrnaLon Teal 0722120 Pa9e2 o1 3,d Juarter 2020 pap INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY THIRD QUARTER 2020 3rd Quarter DUST FUND# ACCOUNT DIVISION Apr -Jun Y.T.D. SUB -TOTAL GOVERNMENTAL DEVELOPMENT APPROPRIATION: $1,184,449.45 $3,273,416.76 10100-9090101-196030-773630 Information Technology Development ($1184449451 1$3 273,416 761 TOTAL GOVERNMENTAL: $0.00 $0.00 NON-GOVERNMENTAL DIRECT CHARGES 053 Airport Special Events $000 $000 274 ASAP Passport System $000 $000 672 Assessment & Tax $30250 $31,42800 935 Augusta SAW Grant $0.00 $000 073 Bicentennial Celebration Grant $0.00 $1,09500 944 CAMP CTA DR Equipment $3,90000 $29,91L75 669 CAMS/CVT Data Conversion $000 $000 055 CLEMIS $14,76390 555,927.98 699 CLEMIS - CAD $000 $0.00 448 CLEMIS/FRMS NON -BILLABLE $2,22750 $30,15375 056 CLEMIS FUND 63500 $13,97250 $91,78625 026 CLEMIS MIDC Bridge $7,62000 $7 62D OD 069 CLEMIS-Training $58700 $58700 749 Clerk/Reg - CPL $000 $000 720 Clerk/Reg- Register Of Deeds $4,57817 $28.56804 719 Clerk/Rod Automation Fund $4,51700 $42,03400 659 Collaborative Asset Mgt Sys (CAMS) $000 $000 435 Comm Dev - Housing Counselor $000 $0.00 521 Community Corrections - Admin(Grant) $55100 $1,36400 937 COSDS SAW Grant $000 $45150 471 Courts -FOC Exp -CS Enforcement - EDMS (Imaging) $000 $000 507 Courts -FOC Exp -CS Enforcement $33,81329 $87,58650 470 Courts -FOC EXP -FAM Counseling $5,96675 $5,96675 045 CV Radio System Replacement $10,10625 $10,10625 673 Cyber Security Fund $000 $000 931 Drain Equipment Fund $000 $000 189 Drain Equipment Fund - Powerplan Contract $000 $000 933 Drain Equip Map $4,27225 $764700 837 EDCA - MlTradeSchool org Grant $000 $000 167 Edwards Drain SAW Grant $000 S000 100 Farmington Hills SDS SAW $000 S1,791 50 210 Fire Records Management System $99867 $1,07954 750 FM&O $32,92495 $90,42442 756 FM&O Building Maintenance $000 $0.00 133 FM&O Building Management System $0.00 $6,66925 080 FMO Bldg Mgmt Systems Rep Ph 2 $1,54400 $9,20275 048 FM&O Bldg Security Enh Prot $2,051 50 $2,626.25 Prepared By mrrraGon Terhno109y. 07/ Qt) Page 3 d23 3rd Quarter 2020,df INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY THIRD QUARTER 2020 3rd Quarter COST FUND# ACCOUNT DIVISION Apr-Jun YT.D. 757 FMWKRel/Jail MgtNideo Conf $000 $000 963 FOC Security Audit $75089 $75089 942 Franklin SAW Grant $0.00 $000 380 Health l mmuntoation Grant $000 $000 173 Health - Lead Innovation Grant $000 $000 071 Health Lead PSA Grant $6,825.00 $9,741.25 117 Health-HepaGLs A Prevention $000 $000 020 Henry Graham Dram SAW Grant $000 $000 947 HIPAA Enhancements 11 $14,14875 $6433900 120 HR-Financial System Replacement $711,96075 $1608,85425 214 IAM Program $95,33700 S273,385.50 338 Imaging Protect $55,747.25 $132,265.25 751 IT Telephone Communications $185.50 $54325 202 Jail Management System (,MS) $10,14525 $10,14525 185 Leasetrack $000 $000 112 Medical Man/uana PSA $0.00 ($860 001 101 Medical Manivana Mysidewalk $0.00 $000 113 MIDC CLEMIS Dev $2,33950 $9,641 75 192 Neptune Reports S24000 $24000 136 Oakland Township BOB SAW $000 $2,64000 634 CakVideo Upgrade (Building Authority) $0.00 $000 938 OAKWIN Radio System Enhancement $0.00 $000 043 OC Bicentennial Cal $000 $5,56500 653 O C International Airport $12,30975 $21 59550 934 OLV BOB SAW Grant $000 $0 00 255 Oracle Upgrade to 19C $40,36725 $40,36725 770 Parks and Recreation- Administration $5,23875 $19,59375 867 P&R Capital Improvement $0.00 $000 925 P&R EMS Upgrade $0.00 $000 796 P&R Facilities & Maintenance $000 $000 442 P&R Lyon Oaks Conf Cur Cl P#2469 $000 $000 443 P&R Lyon Oaks Conf Ctr Cl P42468 SO 00 $000 454 P&R Springfield Oaks CIP#2471 SO 00 $000 456 P&R Springfield Oaks CIP42470 $000 $000 457 P&R Red Oaks Clubhouse CIP#2467 $000 $000 268 Pontiac-Meter $000 $000 747 Pontiac -Water $000 $000 748 Pontiac -Sewer $000 $000 095 Pontiac Sewer $44500 $44500 936 Pontiac Water Asset Mgmt $000 $000 329 Pontiac W WTP Transaction $0.00 $000 906 Public Health Grant 795 $000 $000 791 Radio Communications-E911 $2856150 $99,61650 695 Risk Management S13.32375 $25,63275 638 Tax Management System $000 $78,61275 Prepamd By Intonnaimn Technology, 0722120 Page 4 of 23 3rtl Quader 2020 pdf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY THIRD QUARTER 2020 3rd Quarter CUST FUND# ACCOUNT DIVISION Apr - Jun Y.T.D. 601 Treasurers-DTRF $000 $000 973 UCC Program II $35,88875 $120,979.25 115 UCC Program 111-VOIP $80,03650 $16649650 656 Water Resources Accounting $1,57938 $3,25182 731 Water Resource - Equipment $33000 $1,21077 736 WlnCan Central Storage Solution $000 $000 930 Water and Sewer -General Adm $000 Woo 939 Water and Sewer General Administration $000 $0.00 974 Water and Sewer Gen Admin-WMU $000 $32775 201 Water and Sewer Gen Adm - XC2 $000 $59500 850 Workforce Dev Division $000 $000 281 WRC $000 $000 670 WRC Acct9 - Crowder Ppct $000 $000 344 WRC Administration $132000 $1,32000 929 WRC Aeration Tank Rehab $000 $0.00 940 WRC -CAMP $3,09375 $5,940.00 926 WRC CLINTON-OAKLAND SCADA $000 $000 932 WRC CLINTON-OAK SDS SCADA Main $000 $000 277 WRC-GWK PCF -WRC SCADA $000 $000 377 WRC -SAW ACACIA $000 5000 382 WRC -SAW Birmingham $000 $000 379 WRC- SAW Commerce Township $000 $000 387 WRC - SAW Evergreen Farmington S000 $0.00 389 WRC -SAW Lake One. $000 $000 3BB WRC -SAW Novi $000 $000 386 WRC -SAW Orchard Lake $000 $000 674 WRC - SAW Grant Labor $000 $000 381 WRC SAW GWK $000 $000 895 WRC AGO $000 $0.00 734 WRC -AMR Support $000 $0.00 980 WRC Bingham Farms SAW $000 $0.00 745 WRC- COSDA Meter Replacement $000 $0.00 728 WRC - CO SDS Seval $000 $000 168 WRC CRWRRF Admm Bldg Rehab $36200 $1,97850 729 WRC - EF SDS SewMet $000 $000 737 WRC- Data Application Pilot Polect $000 $000 300 WRC - GIS Allocation by Labor $000 $000 277 WRC -GWK PCF -WRC SCADA $000 $0.00 295 WRC- HACH WINS Implementation $000 $10,62900 894 WRC- HACH WIMS Implementation Phase 11 $2,18250 $12,05250 733 WRC- Hydro Drain Project $000 $000 671 WRC- Infrastructure Op Ar $000 $000 982 WRC Keego Harbor SAW $000 $000 299 WRC- MISS DIG Ticket Mgmt Sys $000 $000 981 WRC Oxford Twp SAW $000 S000 Prepared By Infomlat,on Technology, 07122120 Page 5 of 23 3r6 puatle12020 Odf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY THIRD QUARTER 2020 Prepared By brtortnation T.Chnology; 07/22120 Pa..6 of 23 3,1 tluaner 2020 pdf 3m Quarter CUST FUND# ACCOUNT DIVISION Apr - Jun V.T.D. 501 WRC Permitting Impl $66000 $3,217.50 979 WRC Permitting Implementation $701 25 $6,44200 990 WRC Regional Systems Un¢ $0 cc $000 986 WRC Royal Oak Twp SAW $000 $000 686 WRC - SAW Grant Labor - Common to All $000 $000 402 WRC SAW Huron Rouge $000 $000 403 WRC SAW Bloomfield Village $000 $47000 739 WRC -SCADA Common $000 $0.00 738 WRC -SCADA Engineering Assessment $000 $000 358 WRC - SCADA Maintenance $0 00 $50550 294 WRC - Sewer Fund $3,96000 $3,96000 067 WRC Utility Billing Replacement $764250 $6,36250 023 WRC Walled Lake Water $000 $000 024 WRC Walled Lake SDS S000 $0.00 121 WRC Webate Standardization $13800 $3,33600 170 WRC WMU Meter Maintenance $000 $000 63600-1080101-152000-631302 SUB -TOTAL DIRECT CHARGES FOR DEVELOPMENT $1,274522.75 $3,298,216.96 TOTAL COUNTY DEVELOPMENT CHARGES $2,456.972.20 $6.57163372 NON-COUNTYAGENCIES 63600-1080101-152000-635017 Non -County Agencies $1147128 $3051053 Prepared By brtortnation T.Chnology; 07/22120 Pa..6 of 23 3,1 tluaner 2020 pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2020 Cult# GOVERNMENTAL FUNDS 3rd Qtr 2020 630 ANIMAL CONTROL 24017 SOL Server Supp -Animal Control $667 95626 Ammal Control $11098 00 95662 Dog System $1613275 Animal ControlTotal$27 239 42 005 BD OF COMMISSIONERS 91404 BOC - Customer Support $479925 Bid of Commissioners - Total $4,79925 508 BOC -LEGAL RESOURCE CENTER 61001 BOC -Legal Resource Center $21175 BOC -Legal Resource Center - Total $21175 665 CHILDRENS VILLAGE 95665 Childrens Village $21,59903 Childress Village - Total $21,59903 668 CHILDREMS VILLAGE ADMIN 97668 Children Vilage Admin $000 Childrens Vllage Admin - Total $000 184 CLERKS - COUNTY CLERK 96184 Clerk's - County Clerk $000 Clerk's - County Clerk - Total $0 00 725 CLERK/REG- ADMIN_ 72500 Clerk - Admin $000 Clerk/Reg -Admin -Total $000 440 CLERKIREG - ELECTIONS DIVISION 95443 Clerk/Reg - Elections Division $9.878.75 Clerk/Reg - Elections Division -Total $9,87875 722 CLERK/REG-BOMB(IMAGING) 95158 Clerk/Reg- EDMS Suppor-Wavltenance/Upgratles $3,14260 13001 Clerk's Efiling $000 Clerk/Reg - EDMS (Imaging) - Total $3 14260 718 CLERK/REG - ESERVICES_ 71800 Clerk/Reg - EServices $000 Clerk/Reg - E -Services - Total $000 410 CLERK/REG - JURY COMMISSION 95512 Clerk/Reg - Jury Commission $000 Clerk/Reg -Jury Commission -Total $000 724 CLERK/REG-LEGAL RECORDS 95189 Circuit Court System $54 486 51 Clerk/Reg - Legal Records - Total $54,486 51 726 CLERK/REG- MICROGRAPHICS 91002 ROD -75% 268966 Clerk/Reg - Micrographics - Total $2,68966 Prepared By Inkrmation Technology, 07/22120 17 or 23 3rc Quarter ID20 ptlf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2020 291 CLERK REGISTER OF DEEDS ADMIN 95291 Clerk Register of Deeds Admin Woo Clerk Register of Deeds Admin -Total $000 723 CLERK- VITAL STATISTICS 24015 SOL Server Supp - Vital Stats 35% $8E7 95161 Clerk Reg - Vital Statistics $2422749 Clerk - Vital Statistics - Total $24,236.16 522 COMMUNITY CORRECTIONS -ADMIN ICOf 23003 CMoe Support- Comm Corr -52% $9438 24012 SOL Server Supp- Community Corr 3S% $667 52200 Comm Com -Admin (County) $39,31700 52201 Comm Carr -DW Support $000 Community Corrections - Total $39,42005 620 OFFICE -AUDITING 44034 Autllting - New Development $0.00 _COMPLIANCE 95466 Auditing lntemal Sry - Cl $000 Compliance Office - Auditing - Total $l 690 COMPLIANCE OFFICE -PURCHASING 44028 Purchasing System Enhancements $66000 44029 Pur -New Development $15,97250 Compliance Office - Purchasing - Total $16 632 50 430 CORPORATION COUNSEL 95501 Corporation Counsel $2347825 Corporation Counsel - Total $23,47525 015 COUNTY EXECUTIVE 95654 County Executive - Development $6,71025 95656 County Executive Support $5,97200 County Executive - Total $14,68225 450 CIRC CT PROBATION - NORTH 80204 Circuit Court Probation - North $0 00 Circuit Court Probation - North - Total $0 00 495 CTS -BUSINESS DIVISION 12002 CCT-Courts/Cnminal $000 23010 Oracle SupporCCT/CTS Chun Whse 26% $000 CTS-Busmess Divmon - Total $000 490 CTS -FD -CT SERVICES - CLINIC 95171 CTS -FD -CT Services - Clinic $273175 CTS -FD CT Services - Clinic - Total $2731 75 506 CTS -FAM DIV -JUDICIAL SUPPT 95195 Cmuit Court Admm56$ 1975 CTS-Fam 0,v -Judicial Support - Total $5,61975 483 CTS -FD -JUDICIAL SUPPORT -ADM 24009 SOL Sew Supp - CTS -Jud Sup Alm - 3 5% $867 CTS -FD -Judicial Supporl - Total $867 482 CTS -FD JUVENILE SUPPORT 48200 CTS -Jud Support -Juv Support $000 CTS -Jud Support -Juv Support - Total $000 Preparetl By Information Tti,logy, 07/22/20 Page 8 N 23 3k Quarter 2020 Of $201,44769 $94 38 $10,17529 $371 25 $131,96535 Pcii By Infortnailon Technology, nP12/ID Page 9 d23 aro Qu.rz, 2020 phf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2020 498 CTS-GENJURISJUDICIALSUPPT 14001 CTS -DW SuppoftCircuit $000 23010 Oracle Supp -CCT $47 19 12002 CCT-Courts/Criminal $000 95179 CTS -Gen Juns-Judicial Suppt $20140050 CTS -Gen JunsJudiaal Suppt-Total 502 CTS -GJ -JURY OPERATIONS 23008 Oracle Support -CTS -GJ -Jury Operations $9438 CTS -GJ -Jury Operations - Tom] 493 CTSJUDICIALADMIN 13002 Court's - Efiling $000 49300 Courts Web Redesign $000 95174 CTS -Judicial Admin $10.17529 CTS -Judicial Achim - Total 785 ECONOMIC DEVELOPMENT& COMMUNITY AFFAIRS 36500 GIS Implementation Support C&E Dev $37125 36501 CED Application - HM Support $000 95785 Comm & Eco Developmt $000 Economic Development & Community Affairs - Total 740 EQUALIZATION 23012 Oracle Support -Equalization -52% $9438 24005 SOL Server Supp -Equalization -105% $2599 31075 Equal -Development $4,49175 36505 GIS Implementation Support Equalization $1,36125 36506 Equal Apphcation - HAW Support $15,59425 36507 Equal LAMS Support $28,62600 36601 Land System Enhancements - Equal (50%) $16,31303 36701 Land System Maintenance - Equal (50%) $3,83290 36801 Land System Support -Equal (50%) $10,44965 36902 BS&A Orion Twp $000 50101 EQUAL(BS&AANNUAL) $8,04440 95562 Equalization - DW Support $0.00 95693 Equalization - System Maintenance $16500 95699 BS&A. Master Appraisal SuplMamt $42.966.75 Equalization - Total 660 FISCAL SERVICESADMIN 23001 Oracle Support -Fiscal Sew -15.6% $28314 23013 Oracle Support-HR-Acctg/6udget-52% $9438 24006 SOL Sery Sul -HR-Acctg-175% $433 44021 FS-System/Customer Support $7,00825 44022 FS- System Maintenance $0A0 44023 FS- System Enhancements $000 44024 FS - New Development $16500 44602 Bond Disclosure- Fiscal (50%) $000 96001 Fiscal Sew - Acctg 40% $7,109.00 96003 Fiscal Sery- Budget 20% $355450 $201,44769 $94 38 $10,17529 $371 25 $131,96535 Pcii By Infortnailon Technology, nP12/ID Page 9 d23 aro Qu.rz, 2020 phf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL -THIRD QUARTER 2020 Prepared By Information Technology, nL2220 Page 10 d23 3rd Quatler 2020 pdf F1scal Services Admm - Total $18 218 60 840 HEALTH DIVISION 36525 GIS Implementation Support Health $000 95563 User Support-Healih $25,742.00 96642 Health Admin $27 366 00 Health - Total $53,10800 852 HEALTH CENTRAL SUPPORT 95852 Health Central Support9$ 15 75 Health Central Support - Total $91575 843 HEALTH -ENVIRONMENTAL 23005 Cradle Support - EH Projects -52% $9438 24014 SOL Server Suppt- Ehealth 14% $3465 84200 EH - Projects $71,83329 84300 Ehealth Program $17,02850 Health -Environmental -Total $88,990.82 183 HEALTH WEBSITE REDESIGN 96183 Health Website Redesign $0.00 Health Website Redesign -Total $000 900 HOMELAND SECURITY 36545 GIS Implementation Support Homeland Security $000 36546 Homeland Security Application - H/W Support $14,27250 98990 Homeland Security $1017575 Homeland Security - Total $24,448 25 416 HR RECRUITMENT 98416 HR Recruitment $000 HR Recruitment -Total $000 680 HUMAN RESOURCES 23014 Oracle Support-HR/Personnel-52% $9438 24007 SQL Server Suppport-HR/Pers.crel - 1 75% $433 44044 HR -New Development $165.00 96002 Human Res -Personnel 40% $11,591 45 Human Resources - Total $11,85516 907 LIBRARY-LIBRARYADMIN 91405 Library Board $000 Library - Library Admin - Total $000 824 LIBRARYSERVICES 61001 Library Services $0_00 Library Services - Total $000 565 MARKETING & COMMUNICATIONS 56500 Marketing & Communications S6900 Marketing & Commumcamme - Total $6900 872 MEDICAL EXAMINER_ 24002 SQL Server Support - Metlical Exam -35% $667 87202 Medical Examiner - Customer Support $1035100 Medical Examiner -Total $10,35967 Prepared By Information Technology, nL2220 Page 10 d23 3rd Quatler 2020 pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2020 296 MSU - DIGITAL MEDIA SERVICES 22296 MSU - Digital Media Services $000 MSU - Digital Media Services - Total $000 710 MSU EXTENSION - OAKLAND 95676 MSU EM Equipment Maintenance $000 MSU Extension - Oakland -Total $000 648 OCSD ADMIN SERV -SHERIFF ADMIN 97648 OCSD Admin Serv-Shedfl Admin $0.00 OCSD Admin Sew -Sheriff Admin - Total $000 163 OCSO-CLEMIS FORENSIC LAB IMS 16300 OCSO-CLEMIS Forensic Lab $000 OCSO-CLEMIS Forensic Lab IMS - Total $000 775 PLANNING & ECO DEVELOPMENT 95600 PEDS CustlSystem Support $7,34250 Planning & Eco Development -Total $7,34250 512 PROB-ESTATESIMENTL HLTH EDMS (IMGj 95207 PC-EIMH EDMS Support & 1$2,74979 Prob-Est/Mntl Hith EDMS (Img) - Total $2,74979 510 PROB-ESTATESIMENTL HLTH SUPPORT 24010 SOL Sery Supp-PCT-Est/Mental - 3 5% $867 92198 Prob-Est/Mnd Hlth Support $1379775 Prob-Est/Mntl Hit Support -Total $13,806A2 479 PROS -FD JUDICIAL SUPPORT 95188 PRO&FD Judicial Support $0.00 PROB-FD Judicial Support - Total $0.00 481 PROB-FD JUDICIAL 95168 PC -Judicial Family Admin -Family Judges $8250 Prob - FD Judicial - Total $8250 145 PROSECUTOR- GENERAL PROSECUTION 24016 SOL Server Supp- Prosecutors 35% $867 95622 Prosecutor/Exacutwe $8,31500 97001 Prosecutor Data Proc $000 95664 Prosecutor Warrants2$ 855 86 Prosecutor- Total $11 17953 637 RECORDS RETENTION 44053 REC- System Enhancements $000 95636 Mail Room Woo Records Retenbco - Total $000 650 REIMBURSEMENT 95470 Reimbursement Syslem $6,61175 95542 Reimburse User Support $155875 Reimbursement -Total $10,17050 195 SHERIFF 12001 OCSD-Courts/Cnminal-50% $0.00 23009 Oracle Supppert -OCSD/CTS Cum White -26% $4719 97163 Shenh $28,91591 Prepared i on,.W4 Technology, 0122/20 Pagel 1 of23 3rd Quarter 2020 pdf $74,01960 $7,81388 $1 443 75 $1,201 50 $231 00 $000 $5,39996 Prepared By Inkrm.Wir TwUTy log, 07122/20 Page 12 of23 3rd Quader21 pdf INFORMATION TECHNOLOGY -RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2020 97164 Sheriff - Development $4505650 97165 Sheriff -0W Support $000 98164 CLEMIS-Sheriff $000 Sheriff -Total 191 SHERIFF-CLEMIS 23015 Oracle Suppport- Sherri /CLEMIS-52% $9438 96163 Sheriff -CLEMIS77$ 1950 Sheriff - CLEM IS - Total 348 SHERIFF -CORRECTIVE SERVADMIN 34800 Inmate Phone System $144375 Sheriff- Ccrreclive Sew Admin -Total 988 OC SHERIFF'S IFS DIV - LAB 16300 OCSO Clems Forensic $1,20150 OC Sheriffs IFS Div - Lab - Total 349 OCSD ADMIN SERV - RECORDS MGMT 97349 OCSD Atlmm Serv- Records Mgmt S231 00 OCSD Admin Be, - Records Mgmt - Total 647 OCSD PATROL SERV -LE ADMIN 97647 Sheriff- Pahnl Sew -LE Armin $000 Shenff- Patrol Sew -LE Admin - Total 445 SUPPORT SERVICES 23002 Oracle Support - Supp Sew -52% $9438 24011 SQL Server Supp - Supp: Services 7% $1733 44500 Support Services $528825 Support Services - Total 600 TREASURER 23006 Oracle Support - Del Tax -52% $9438 23016 Oracle Support -Treasurer -104% $18876 36516 Treasurer Application - H/W Support $000 36602 Land System Enhancements - Trees (50%) $16,31272 36702 Land System Maintenance - Tress (50%) $3,83285 36802 Land System Support - Tress (50%) $10,44960 44061 Tre-System/Customer Support $35,01679 44062 Tre-System Maintenance $3,76500 44063 Tre-System Enhancements $000 44064 Tre-New Development $6,13600 44080 Trei Support $000 44082 Trei Maintenance $0.00 44601 Bond Disclosure -Treas(50%) $000 50102 TREAS(BSBA ANNUAL) $8,04435 91001 Treasurers -25% $89659 95008 Del Tax On Line $49500 95303 Del Tax System Maintenance $000 95561 User Support/Del Tax $14,54125 95615 BSBA Annual Tax Support $33000 $74,01960 $7,81388 $1 443 75 $1,201 50 $231 00 $000 $5,39996 Prepared By Inkrm.Wir TwUTy log, 07122/20 Page 12 of23 3rd Quader21 pdf $000 $000 $5 073 15 $100,10329 INFORMATION TECHNOLOGY - RESERVE FUND $5 073 15 $507315 DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2020 $000 $5,073 15 $5,073 15 Treasurer -Total 169 TREASURER -BANKING RFP 96169 Treasurer -Banking RFP $1,86675 $2035425 Treasurer -Banking RFP -Total 627 TREASURER-LANDSALE 44063 Treasurer-Landsele $000 $8,63325 Treasurer -Landsale - Total 978 TREASURERS OFFICE-OAKDOCS 95978 Treasurers - OakDOcs $3,09375 $27,63750 Treasurers - CakDocs - Total 910 VETERANS SERVICES 95651 Veterans Customer Support $000 95650 Veterans Services Equipment Veterans Services - Toll 730 WATER RESOURCE COMMISSIONER 24006 SOL Server Supp-WRC35% 28007 Water Resource Commission 28009 WRC Administration 28010 WRC - Customer Support 28011 Water Resource Commissioner Application 36520 GIS Implementation Support WRC 36521 WRC Application - HAW Support Water Resource Commissioner - Total 742 WRC -CAMS SOFTWARE SUPPORTS, MAINTENANCE 74200 WRC CAMS SOFTWARE Support WRC CAMS SOFTWARE Support - Total 301 WRC- SOIL EROSION SOFTWARE SOL 74301 WRC- Soil Erosion Sottvogre Sol WHO - Soil Erosion Software Sol - Total 540 5211 DISTRICT COURT-NOVI 95527 DC Sul 5211-25% 5211 District Court - Total 550 5212 DISTRICT COURT - CLARKSTON 95528 DCSumt 52/2-25% 5212 District Court -Total 560 5213 DISTRICT COURT- ROCHESTER 95288 52 Dist Ct Div 3 95529 DC Suprt-5213-25% 5213 District Court - Total 530 5214 DISTRICT COURT -TROY 95530 DC Suprt-5214-25% 5214 District Court - Total custu DIRECT FUNDS $000 $000 $5 073 15 $100,10329 $000 $5 073 15 $507315 $000 $000 $5,073 15 $5,073 15 $0.00 $33,56450 $33,564.50 $1,86675 $2035425 $5,07280 $22,221 00 $867 $000 $8,63325 $24,42000 $6,15875 $3,09375 $27,63750 $69,951 92 $000 $000 $000 $000 $5 073 15 $5 073 15 $507315 $5,073 15 $5,073 15 0 00 $5,073 15 $507280 $5,07280 $1,184,449A5',, Prepared By I,rfonnaGnn Technology 0]22120 Page 13 M 23 3rd Quarter 2020 par INFORMATION TECHNOLOGY - RESERVE FUND Prepe,rd By Infotmappn Ia,hrrlpgy, f19@20 Page 14 023 3N Quarter 2020 pdf DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2020 274 ASAP PASSPORT SYSTEM 97274 ASAP Passport System $000 ASAP Passport System -Total $000 672 ASSESSMENT & TAX 67200 Assessment & Tax $30250 Assessment&Tax - Total $30250 935 AUGUSTA SAW GRANT 37935 Augusta SAW Grant 000 Augusta SAW Grant -Total $000 944 CAMP CTA DR EQUIPMENT 37944 Camp CTA DR Equipment $3,90000 Camp CTA DR Equipment - Total $3,90000 055 CLEMIS 23004 Oracle Support- OakVldeo CLEMIS 5.2% $9438 23018 Oracle Support- Sheriff CLEMIS 52% $9438 24004 SOL Server Support -24.5% $60.64 95430 CLEMIS Mamtenance $95600 95431 CLMS Enhancements $41 25 98003 CLEMIS User Support $13,51725 98005 CLEMIS-E911 Support $000 98000 Polect Team $000 CLEMIS - Total $1476390 699 CLEMIS - CAD 98006 CLEMIS - CAD Development 000 CLEMIS - CAD - Total $000 056 CLEMIS FUND 63500 63500 CLEMIS Fund $13 972 50 CLEMIS 63500 Fund - Total $13,972.50 448 CLEMISIFRMS NON -BILLABLE 44800 CLEMIS/FRMS NON -BILL $2.227 50 CLEMIS/FRMS NON -BILL - Total $2,22750 026 CLEMIS MIDC BRIDGE 91026 CLEMIS MCC Bridge $7.620 00 CLEMIS MIDC Bridge - Total $7,62000 069 CLEMIS - TRAINING 91069 CLEMIS-Training 56700 CLEMIS - Training - Total $58700 669 CAMS/CVT DATA CONVERSION 66901 CAMSICW Data Conversion 000 CAMS/CV7 Data Convemcn - Told) S000 749 CLERKIREG-CPL 74900 Clerk/Reg - CPL $000 Clerk/Reg - CPL - Total $000 720 CLERK/ REGISTER OF DEEDS 24003 SOL Server Supp - ROD 35% $867 Prepe,rd By Infotmappn Ia,hrrlpgy, f19@20 Page 14 023 3N Quarter 2020 pdf INFORMATION TECHNOLOGY -RESERVE FUND DEVELOPMENT 1 SUPPORT DETAIL - THIRD QUARTER 2020 5m Quarter 2020 pdf 36510 GIS Implementation Support $0.00 36511 ROD Appllcabon - HM Support $2,57400 95493 ROD System Maintenance $000 95498 Clerk/Reg -ROD1$ 99550 Clerk/Reg of Deeds - Total $457817 719 CLERKIROD AUTOMATION FUND 95719 Clerk/ROD Automation Fund $4 517 00 Clerk/ROD Automation Fund - Total $4,517X0 659 COLLABORATIVE ASSET MGT SYS 65901 Collabortive Asset Mgt Sys $000 Collabortive Asset Mgt Sys - Total $000 435 COMM DEV- HOUSING COUNSELOR 66104 Housing Counselor $000 Housing Counselor - Total $000 937 COSDS SAW GRANT 37937 COSDS SAW Grant $000 COSDS SAW Grant- Total $000 471 CTS -FOC -EXP -CS ENFORC-EDMS (IMM 92194 CTS -FOC -CS ENF-EDMS Support/Mamtenance/Upgrades $000 CTS -FOC Exp -CS Enforc-EDMS (Img) -Total $000 507 CTS -FOC EXP -CS ENFORCEMENT 34044 CTS -FOC -CS Enforc- Image $3,441 75 65410 FOC Image Replacement -74% $2,63950 92193 CTS -FOC Exp -CD Enforc-Dev $24,78225 92194 CTS -FOC Ent-EDMS $274979 CTS -FOC Exp -CD Enforc-Dev - Total $33,81329 470 CTS -FOC EXP -FAM COUNSELING 34041 CTS -FOC Fam Counseling $2,719.00 92195 CTS -FOC Fam Counseling - Dev3 2$ 4775 CTS -FOC Fam Counseling - Total $5,96675 521 COMM CORR -ADM tGRANT) 52100 Community Connections C'Star EB $551 00 Comm Cort -Adm (Grant) - Total $551 00 045 CV RADIO SYSTEM REPLACEMENT 95045 CV Radio System Replacement 10 10625 CV Radio System Replacement - Total $1010625 673 CYBER SECURITY FUND 87300 Cyber Secunty Fund $000 Cyber Secunty Fund - Total $000 931 DRAIN EQUIPMENT FUND 37931 Drain Equipment Fund $000 Drain Equipment Funtl - Total $0.00 933 DRAIN EQUIP MAP 37933 Drain Equip Map $4 277 25 Drain Equip Map - Total $4,27725 Prepared By InN mstipn Technology, 0722/20 Page 15 of 23 5m Quarter 2020 pdf INFORMATION TECHNOLOGY -RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2020 837 EDCA- MITRADESCHOOLORG GRANT 83700 EDCA- MITRADESCHOOL $000 EDCA- MlTradeSchool pig Grant - Total $000 167 EDWARDS DRAIN SAW GRANT 33167 Edwards Dram SAW Grant $000 Edwards Dem SAW Grant - Total $000 210 FIRE RECORDS MANAGEMENT SYSTEM 21010 Fire Records Mgmt Fund 531 $000 95404 SOL Sewer Support - FRMS 35% $99000 24001 FRMS - Phase II Prot $867 Fire Records Management System - Total $99867 750 FM&O 21001 Facil tes Maintenance & Operators $35678 24013 SOL Server Supp -FM&O $867 75503 FM&O Development $32 55950 FM&O -Total $32 924 95 756 FM&O BUILDING MAINTENANCE 75600 FM&O Building Maintenance $000 FM&C Building Maintenance - Total $000 133 FM&O BUILDING MANAGEMENT SYSTEM 21133 FM&O Building Manage $000 FM&O Building Manage - Total $000 080 FM&O BLDG MGMT SYSTEM REP PH 2 21080 FM&C Bldg Mgmt System Rep Ph 2 1 544 00 FM&C Bldg Mgmt System Rep Ph 2 -Total $1,544 00 048 FM&O SECURITY ENH PROJ 75046 FM&O Bldg Secmty Enh Frei 2051 50 FM&O Bldg Seculty Enh Prof - Total $2,051 50 757 FM/WK RELUAIL MGTIVIDEO CONF 75700 FAC MGMT-Video Arraignment $000 FM1WK Rel/Jail MgtNldeo Conf-Total1 $000 963 FOC SECURITY AUDIT 94963 FOC Secunty Audit $75089 FOC Security Audit - Total $75089 942 FRANKLIN SAW GRANT 37942 Franklin SAW Grant $000 Franklin SAW Grant - Total $000 809 HEALTH -CRI 80900 Health -CRI $000 Health -CRI -Total $000 117 HEALTH -HEPATITIS A PREVENTION 96117 Health - Hep A Prevention $000 Health - Hep A Prevention -Total $0 00 380 HEALTH -IMMUNIZATION GRANT 38000 Health -Immunization Grant $000 Health-Immun¢ation Grant- Total $000 Preparetl By Intormaton TecM1nology, 0712220 Page 16 M 23 3N Quarter 2020 pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT/SUPPORT DETAIL -THIRD QUARTER 2020 173 HEALTH -LEAD INNOVATION GRANT 96173 Health - Lead lnnoval on Grant $000 Health - Lead Innovator, Grant - Total $000 071 HEALTH LEAD PSA GRANT 96071 Health Lead PSA Grant6 8$ 25 00 Health Lead PSA Grant -Total $6 825 00 947 Hill ENHANCEMENTS II 96947 HIPAA Enhancements II $14,14875 HIPAA Enhancements h - Total $14,14875 120 HR -FINANCIAL SYSTEM REPLACEMENT 44120 HR -Financial Sys Rep $711,96075 HR-Fnanclal Sys Rep -Total $711,96075 214 IAM PROGRAM 21400 IAM Program $95 337 00 IAM Program -Total $95,33700 338 IMAGING PROJECT 33800 Imaging Project $55.74725 Imaging Project - Total $55,74725 751 IT -TELEPHONE COMMUNICATIONS 75102 Telephone Communications - Customer Support 518550 IT -Telephone Communications -Tota[ $18550 202 JAIL MGMT SYSTEM IDMS) 63202 Jail Mgmt System (JMS) $10 14525 Jail Mgmt System (JMS) - Total $10,14525 185 LEASETRACK REPLACEMENT 18500 Leasetrack Replacement $000 Leasetrack Replacement - Toni $000 112 MEDICAL MARIJUANA PSA 96112 Medical Marijuana PSA $000 Medical Marijuana PSA - Total $0.00 113 MIDC CLEMIS DEV 91113 MIDC CLEMIS Dev $2 339 50 MIDC: CLEMIS Day - Total $2,33950 192 NEPTUNE REPORTS 33192 Neptune Reports $24000 Neptune Reports - Total $24000 634 OAKVIDEO UPGRADE (BA) 63400 CLEMIS- OakVideo Upgrade $000 63401 IT - OakVideo Upgrade $000 OakVldeo Upgrade (BA) - Total $000 938 OAKWIN RADIO SYSTEM ENH 98936 OAKWIN Radio System Enh S000 OAKW IN Radio System Enh - Total $000 653 D.C. INTNL AIRPORT 36540 GIS Implementation Support $000 65310 O C Airport- New D $8,951 25 PrepareU By Ift,sfioo Technology 0712/20 Page 1) of 23 3N Quarter 2020 poll INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - THIRD QUARTER 2020 Prepared By Inkrmatlon Technology, 0]/2220 Page 18 of 23 3N Quarter 2020 act 65301 Airport User Support $3,35850 OC Intnl Airport - Total $1230975 934 OLV SDS SAW GRANT 37934 OLV SDS SAW Grant $000 OLV SDS SAW Grant- Total $000 255 ORACLE UPGRADE TO 19C 63255 Oracle Upgrade to 19C $40,36725 Oracle Upgrade to 19C -Total $40 367 25 770 PARKS AND RECREATION 36530 GIS Implementation Support -Parks $1,402.50 44066 PRADM-System/Customer Support $57750 44068 PRADMSystem Enhancements $000 76100 P&R Admlmstrative Services $000 77010 PRADM-Technology $000 95413 PRADM-Customer Support $3,25875 95416 PRRA - Ree Admin $000 95419 PRADM-Administration $000 Parks & Recreation - Total $5 238 75 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 $000 P&R EMS Upgrade - Total $000 796 P&R FACILITIES & MAINTENANCE 79600 P&R Facilities_ & Maintenance $0 00 P&R Facilities & Maintenance - Total $000 442 P&R LYON OAKS CONE CTR CIP#2469 44200 P&R Lyon Oaks Cont Ctr CIA #2469 $0.00 P&R Lyon Oaks Conf Ctr CIP #2469 - Tobi $000 443 P&R LYON OAKS CONE CTR CIP#2468 44300 P&R Lyon Oaks Conf CTR CIP#2468 S000 P&R Lyon Oaks Conf CTR CIP#2468 -Total $000 454 P&R SPRINGFIELD OAKS CIP#2471 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 $000 457 P&R RED OAKS CLUBHOUSE CIP#2467 45700 P&R Red Oaks Clubhouse CIP42467 $000 P&R Red Oaks Clubhouse CIP#2467 -Total $000 268 PONTIAC METER 74268 Pontiac BSA to WRC -Water $000 Pontiac Meter - Total $000 Prepared By Inkrmatlon Technology, 0]/2220 Page 18 of 23 3N Quarter 2020 act INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2020 747 PONTIAC WATER 74701 Pontac BSA to WRC - Water $000 Pontac Water -Total $000 748 PONTIAC SEWER 74702 Ponta. BSA to WRC -Sewer $000 Pontiac Sewer - Total $000 095 PONTIAC SEWER 74095 Pontiac Sewer 44500 Pontac Sewer - Total $44500 936 PONTIAC WATER ASSET MGMT 37936 Pontac Water Asset Mgmt $000 Pontac Water Asset Mgmt - Total $0 00 329 PONTIAC W WTP TRANSACTION 67329 Pontiac W WTP Transaction $000 Portage W WTP Transaction - Total $000 906 PUBLIC HEALTH GRANT 795 96906 Public Health Grant $000 Public Health Grant -Total $000 791 RADIOCOMMUNICATIONS -E911 79101 Radio Communications -E911 $28,56150 Radio Communications - E911 - Total $28,561 50 695 RISK MANAGEMENT 44036 Rsk-System Customer Support $13 323 75 Risk Management - Total $13r323 75 638 TAX MANAGEMENT SYSTEM 63800 Tax Management System $000 Tax Management System -Total $000 601 TREASURERS-DTRF 18050 Water Resource Apportionment $000 Treasurers - DTRF - Total $000 973 UCC PROGRAM 11 92973 UCC Program II $35,88875 UCC Program II - Total $35,88875 115 UCC PROGRAM III - VOW 92115 UCC Program 111 -VOW $80,036.50 UCC Program III - VOIP - Total $80,03650 656 WATER RESOURCES ACCOUNTING 23011 Oracle Supp - Water & Sewer A.fg - 5 2% $9438 95669 Wale, Resources Accounting $148500 95671 Dram Water/Sewer Bl $000 Water Resources Accounting - Total $1,57938 731 WATER RESOURCE - EOUIPMENT 74501 Water Resource - Equipment $33000 Water Resource - Equipment - Total $33000 736 WINCAN CENTRAL STORAGE SOLUTION 73601 WmCan Central Storage Solution $0$0 00 WmCan Central Storage Solution -Total $000 Prepared By Imes, on Technology, 0712220 Page 19 M23 3N Quaper 2020 Odt INFORMATION TECHNOLOGY -RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - THIRD QUARTER 2020 930 WATER AND SEWER -GENERAL ADMIN 37930 Water and Sewer -General Admin $000 Water and Sewer -General Admin - Total $000 939 WATER AND SEWER GENERAL ADMINISTRATION 37939 Water and Sewer General Adminetraton $000 Water and Sewer General Admmistration - Total $000 281 WRC 74281 WRC $000 WRC - Total $000 670 WRC ACOTG - CROWDER PRJCT 60001 WRC - Crowder NetBase Project $000 67000 WRC- Crowder NetBase Project $000 WRC Accig - Crowder Prject - Total $000 344 WRC ADMINISTRATION 75344 WRC Administra4on $132000 WRC Administrator -Total $1,32000 929 WRC AERATION TANK REHAB 35700 WRC Aeration Tank Rehab $000 WRC Aeration Tank Rehab - Total $000 895 WRC AGO 37895 WRC Ago $000 WRC Ago - Total $000 377 WRC - SAW ACACIA 33377 WRC -SAW ACACIA $000 WRC - SAW ACACIA - Total $000 940 WRC -CAMP 37940 WRC - Camp 309375 WRC - Camp - Total $3,09375 926 WRC CLINTON-OAKLAND SCADA 33926 WRC Clinton -Oakland SCALA $0_00 WRC Clinton -Oakland SCADA - Tom] $000 932 WRC CLINTON-OAK SDS SCADA MAIN 37932 WRC Clinton -Oak SDS SCADA Main $000 WRC Clinton -Oak SDS SCADA Main - Total $000 168 CRWRRF ADMIN BLDG REHAB 33168 WRC CRWRRF Admin Bldg Rehab $36200 _WRC WRC CRW RRF Admin Bldg Rehab - Total $35200 694 WRC- HACH WIMS IMPLEMENTATION 37894 WRC-HACH WIMS Implemendmcn $218250 WRC-HACH WIMS Implementation -Total $2182.50 377 WRC -SAW ACACIA 28674 WRC - SAW Acacia $000 WRC - SAW Acacia - Total $000 382 WRC SAW BIRMINGHAM 33382 WRCSAWBmnmgham $000 WRC SAW Birmingham - Total $0 00 Prepared By Infmmaren Technology, OA:2120 Page 20 of 23 3rd puafter 2020 pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL -THIRD QUARTER 2020 379 WRC - SAW COMMERCE TOWNSHIP 33379 WRC - SAW Comma..Tawnship $000 WRC - SAW Commerce Township - Total $000 386 WRC -SAW ORCHARD LAKE 33386 WRC -SAW Orchard Lake $000 WRC - SAW Orchard Lake - Total $000 674 WRC -SAW GRANT LABOR 28674 WRC -SAW Grant Labor $000 WRC -SAW Grant Labor - Total $000 381 WRC SAW GWK 33381 WRC SAW GWK $000 WRC SAW GWK - Total $000 686 WRC -SAW GRANT LABOR -COMMON TO ALL 60002 WRC -SAW Grant Labor - Common to All $000 12686 WRC -SAW Grant -Common to All $000 WRC -SAW Grant Labor Common to All -Total $0.00 734 WRC -AMR SUPPORT 73401 WRC -AMR Support $000 WRC -AMR Support - Total $000 745 WRC -COSDA METER REPLACEMENT 74500 WRC -CODSA Meter Replacement $000 WRC - CODSA Meter Replacement- Total $000 728 WRC - CO SDS SEWMET 72201 MARS Enhancements- WRC C -O $000 WRC - CO SDS SewMet - Total $000 729 WRC - EF SDS SEWMET 72202 MARS Enhancements - WRC E -F $000 WRC - EF SDS SewMet - Total $0.00 737 WRC- DATA APPLICATION PILOT PR -1 73700 WRC- Data Application Pilot Project $000 73710 WRC - Data Appi Pp $000 WRC - Data Application Pilot Prj - Total $000 300 WRC -GIS ALLOCATION BY LABOR 73300 WRC -GIS Allocation by Labor 000 WRC -GIS Allocation by Labor - Total $000 277 WRC-GWK PCF -WRC SCADA 74277 WRC -GWK PCF -WRC SCADA $000 WRC - GWK PCFWRCSCADA - Total $000 $000 295 WRC HACH WIMS IMPLEMENTATION 67295 WRC HACH WIMS Implementation $000 WRC-HACH WIMS Implementation -Total $000 733 WRC -HYDRO DRAIN PROJECT 73301 WRC Hydra Drain Project $000 WRC -Hydro Drain Project - Total $000 Prepared By Inkmaoion Technology, 07/2220 Pa9a 21 of 23 3rd LtuaRer 2030 pdf Prepared By Inh, naban Technobgy 07=0 Page 4 pf 23 3N paaeer 2020 rdf INFORMATION TECHNOLOGY, RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2020 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 000 WRC -MISS Dig Ticket Mgmt Sys - Total $000 979 WRC PERMITTING IMPLEMENTATION 74979 WRC Peomtbng Implementation $M1 25 WRC Permitting Implementation - Total $701 25 501 WRC PERMITTING IMPL 74502 WRC Permitting Impl $66000 WRC Permithng Impl -Total $66000 739 WRC-SCADACOMMON 73900 WRC -SCADA Common 000 WRC - SCADA Common - Total $000 358 WRC- SCADA MAINTENANCE 33358 WRC- SCADA Maintenance 1200 WRC - SCADA Maintenance - Total $0.00 738 WRC- SCADA ENGINEERING ASSFSSMT 73800 WRC- SCADA Engineering Assesmnt 000 WRC - SCADA Engineenng Assesmt - Total $000 294 WRC -SEWER FUND 74294 WRC - Sewer Fund $3.96000 WRC - Sewer Fund - Total $3,96000 067 WRC UTILITY BILLING REPLACEMENT 33067 WRC Utility Billing Replacement 1 642 50 WRC Utlity Brllmg Replacement- Total $1,64250 023 WRC WALLED LAKE WATER 35023 WRC Welled Lake Water 1200 WRC Walled Lake Water - Total $000 024 WRC WALLED LAKE SOS 35024 WRC Walled take SOS 19-0-0 WRC Walled Lake SDS - Total $000 121 WRC WEBSITE STANDARD17ATION 33121 WRC Website Standardization $13800 WRC Website Standardization -Total $13800 170 WRC WMU METER MAINTENANCIc 33170 WRC WMU Meter Maintenance $0 O0 WRC WMU Meter Maintenance - Total $0.00 $1,2]4,52Z.T6 Prepared By Inh, naban Technobgy 07=0 Page 4 pf 23 3N paaeer 2020 rdf INFORMATION TECHNOLOGY DEVELOPMENT/ SUPPORT DETAIL -THIRD QUARTER 2020 Prepared By: Information Technology, 07/22/20 Page 23 of 23 3rd Quarter 2020 pdf 3rd Quarter Y.T.D. Radio 18020 IT Radio _ $0 00 $0.0� $0.00 $0.00 Application Services 17040 IT - TOS Fund $0.00 $0.00 17062 Pandemic Program - COVID-19 $552,12355 $0.00 18000 (MACS Data Warehouse (Funded) $0.00 $0.00 19000 IT Application Services Planned Maint 348,071.75 $1,220,799.25 30001 IT Application Services Data Warehouse 10,545.50 $39,99550 30002 IT Application Services Enhanced 9.615.75 $28,659.25 30003 IT Application Services GIS 132,528.50 $344,14875 30004 IT Application Services eGovemment 323,927 65 $1.113,741.65 25108 Courts - Oakland Schools $0.00 $0.00 36901 BS&A Orlon Two - IT 0.00 $0.00 App Services - Sub Total: $1,376,812.70 $3,299,467.95 Internal Services 19020 Internal Services Planned Main $15,20750 $173.665.25 Internal Services - Sub -Total: $15,207.50 $173,665.25 $0.00 Technical Sys/Networking 19030 Tech Sys/Net Planned Maint $74,431.75 $257,859.30 23007 Oracle Support - IT Tech Systems 94.38 $626.34 23017 Oracle Support - IT Tech Systems 1.2% 21.78 $144.54 24018 SQL Sew Support - IT Tech Systems 2% 486 $50.77 25400 Oracle Administration 1,072.50 i $8,085 00 95685 I.T. - Disaster Recovery 767.25 $767.25 95750 1 T. - SEP 111,206.00 $341,852.75 95755 I.T. - PeopleSoft Upgrade 0.00 $000 Tech Sys/Net - Sub -Total: $187,598.52 $609,385.95 Information Technology - Total: 1,579,618.72 $4,082,519.15 Prepared By: Information Technology, 07/22/20 Page 23 of 23 3rd Quarter 2020 pdf Resolution #20329 August 20, 2020 Moved -by Quarles seconded-by-Kowall- the -resolutions on the amended ConsentAgenda-beadopted. AYES: Hoffman, Jackson, Kowall, Kuhn, Long, Luebs, Markham, McGillivray, Middleton, Miller, Nelson, Powell, Quarles, Spisz, Taub, Weipert, Woodward, Zack, Gershenson, Gingell. (20) NAYS: None. (0) A sufficient majority having voted in favor, the resolutions on the amended Consent Agenda were adopted. "^." L 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 20, 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 20th day of August, 2020, Lisa Bull Coun�