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.11.19 - 33839
MISCELLANEOUS RESOLUTION #20520 November 19, 2020 BY Commissioner Helaine Zack, Chairperson, Finance & Infrastructure Committee IN RE: INFORMATION TECHNOLOGY — FOURTH 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 Committee; and WHEREAS the Department of Information Technology has determined the Fourth Quarter 2020 development charges to be $1,002,751 96 for the General Fund/General Purpose County departments; and WHEREAS direct charges to Special Revenue and Proprietary Fund Departments are $1,181,531.61 and non -county agencies are $24,609.25 for the Fourth 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 Fourth Quarter 2020 Development Report and approves the Fourth Quarter appropriation transfer as specified on the attached schedule. BE IT FURTHER RESOLVED that the respective departmental Fiscal Year 2020 budgets are to be amended as specified in the attached detail schedule. Chairperson, on behalf of the Finance & Infrastructure Committee, I move the adoption of the foregoing resolution. Commissioner Helaine Za District #18 Chairperson, Finance & Infrastructure Committee FINANCE AND INFRASTRUCTURE COMMITTEE VOTE: Motion carried unanimously on a roll call vote. INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY FOURTH QUARTER 2020 4th Quarter CUST FUND# ACCOUNT DIVISION Jul - Sep Y.T.D. GOVERNMENTALFUNDS General Fund 11011 540 101 10100-3020201-121020-773630 5211 - District Court $4,253.40 $15,251.53 550 101 10100-3020301-121020-773630 5212 - District Court $4,253 40 $15,251.53 560 101 10100-3020401-121020-773630 5213 - District Court $4,253.40 $15,251 53 530 101 10100-3020501-121020-773630 5214 - District Court $4,25&05 $15,250.41 630 101 10100-1070801-114000-773630 Animal Control $27,271,90 $97,986A9 005 101 101 DO-5010101-180010-773630 Ed of Commissioners $11,806.25 $32,45025 508 101 10100-5010101-165015-773630 BOC-Legal Resource Center $371 25 $4,886.75 450 101 10100-1070901-113270-773630 Circuit Court Probation North $0.00 $174.00 184 101 10100-2010210-132300-773630 Clerk's - County Clerk $0.00 $0 00 718 101 10100-2010210-125000-773630 Clerk E-Services $728 00 $728.00 725 101 10100-2010201-180000-773630 Clerk/Reg -Adman $0.00 $0 00 291 101 10100-2010401-172190-773630 Clerk Register Admin $0 00 $0 00 722 101 10100-2010210-125000-773630 Clerk/Reg - EDMS (Imaging) $3,831 16 $15,015.36 440 101 10100-2010301-185010-773630 ClerklReg- Elections $6,802.00 $24,985 75 410 101 10100-2010501-125000-773630 Clerk/Reg - Jury Commission $0.00 $165.00 724 101 10100-2010210-125000-773630 Clerk/Reg - Legal Records $63,307 48 $208,153.49 726 101 10100-2010601-172190-773630 Clerk/Reg- Micrographics $61462 $3,304.28 723 101 10100-2010205-132305-773630 Clerk/Reg - Vital Statistics $19,120.90 $81,731 68 522 101 10100-1070401-113000-773630 Community Corrections Admin $24,46563 $102,579.01 620 101 10100-1010201-181010-773630 Compliance Office -Auditing $0.00 $0.00 430 101 10100-1010501-181020-773630 Corporation Counsel $34,064.25 $95,443.00 490 101 10100-3010402-135070-773630 CTS-FD-CT Services - Clinic $587 75 $3,319.50 606 101 10100-3010401-121220-773630 CTS-Faro Div -Judicial Support $1,470.0C $7,089.75 483 101 10100-3010403-121100-773630 CTS-FD-Judicial Support -ADM $160.90 $250.44 482 101 10100-3(110403-121240-773630 CTS-FD-Juvenile Support $0.00 $0.00 015 101 10100-1010101-181000-773630 County Executive $28,502.50 $130,879.00 495 101 10100-3010201-121110-773630 Courts -Business Division $0 00 $0.00 498 101 10100-3010301-121130-773630 Courts-GJ-Judicial Support $180,845.14 $727,539.34 502 101 10100-3010301-121180-773630 Courts-GJ-Jury Operations $134.73 $761.07 493 101 10100-3010101-121100-773630 Courts - Judical/Administration $8,970.58 $28,80783 188 101 10100-1090206-171000-773630 Economic Day & Comm Affairs $536,25 $932 25 785 101 10100-1090101-171000-773630 Economic Development & Community Affairs $577 50 $6,674.25 740 101 10100-1 D20501-173010-773630 Equalization Division $63,139.46 $319,467.87 046 101 10100-2010301-133095-773630 Elections-Pandemlc/COMD19 $9,852.50 $9,852 50 660 101 10100-1020601-182020-773630 Fiscal Services -Gen Fund $16,07842 $81,82580 900 101 10100-1060601-115090-773630 Homeland Security $33,824 00 $109,666.25 416 101 10100-1050403-183020-773630 HR Recruitment $0.00 $0 00 680 101 10100-1050401-183010-773630 Human Resources $11,234 78 $57,031 44 907 101 10100-5010303-165040-773630 Library - Library Admin $0.00 $0.00 824 101 10100-5010302-165020-773630 Library Services $0 00 $0.00 565 101 10100-1090108-171030-773630 Marketing & Communcations $120.75 $2,849 50 872 101 10100-1070601-132030-773630 Medical Examiner $10,67940 $65,201.69 296 101 10100-1070501-174000-773630 MSU - Digital Media Services $0.00 $0.00 710 101 10100-1060801-174000-773630 MSU Extension - Oakland $4L25 $330.00 Prepared by. Intormat= Technology, 1010520 Page 1 of 22 41h Quarter 2020 pdt CUST FUND# ACCOUNT 349 101 10100-4030501-112680-773630 648 101 101004030201-112580-773630 163 101 101004030901-115140-773630 775 101 10100-1090201-171000-773630 479 101 10100-3040101-121090-773630 512 101 10100-3040403-124010-773530 510 101 10100-3040403-124010-773630 481 101 10100-3040101-121060-773630 145 101 101004010101-122050-773630 690 101 10100-1020310-182090-773630 637 101 10100-1030803-184020-773630 650 101 10100-1020650-126020-773630 195 101 101004030301-112590-773630 191 101 101004030601-110000-773630 348 101 101004030301-112620-773630 988 101 101004030901-116240-773630 647 101 1010OA030601 -110000-773630 206 101 101004030901-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-1090702-132050-773630 730 101 10100-6010101-155010-773630 742 101 10100-6010101-149920-773630 203 101 10100-6010101-174452-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 12931 665 293 20293-1070901-112090-773630 668 293 20293-1070901-112010-773630 63600-1080101-152000-631365 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY FOURTH QUARTER 2020 4th Quarter DIVISION Jul- Sep Y.T.D. OCSD Admin Sew -Records Unit $165 00 $3,052 50 OCSD Admin Serv-Shenff Admin $0.00 $437.25 OCSO - CLEMIS Forensic Lab IMS $0.00 $0.00 Planning & Economic Development $6,841 25 $22,400 00 Probate FD Judicial Support $0.00 $0.00 Probate-Estates/Mental Health - EDMS (Imaging) $3,352 33 $13,138.58 Probate-Estates/Mental Health Support $16,586.90 $59,172.69 Probate -Family Division Judicial $0 00 $82 50 Prosecuting Attorney - General Prosecution $26,991.95 $63,282 35 Purchasing $1,402.50 $63,328.50 Records Retention $0 00 $0 00 Reimbursement Division $4,714.25 $24,873.00 OCSD-Corrective Sew -Admin $49,828A2 $249,256A3 Sheriff- CLEMIS $12,09598 $24,42932 Shenff- Corrective Sew Admin $0.00 $1,443.75 Sheriff- IFS Div Lab $1,432.00 $5,691.50 Shenff - Patrol Sew - LE Admin $0 00 $0 00 Sheriff - LE Support- Sew Admin $0.00 $no Support Services $3,13220 $16,765.07 Treasurer $70,610 98 $345,704.33 Treasurers - Banking RFP $0.00 $1,976.25 Treasurers - Landsale $0 00 $0.00 Treasurers Office-OakDocs $25,17625 $109,11975 Veterans Services $10,479.75 $54,405.75 Water Resource Commissioner $49,36415 $242,883.94 WRC - CAMS Software Support & Maintenance $0.00 $0 00 WRC EU Pub ED Adm Programs $0.00 $0.00 WRC GIS Layer $0 00 $0.00 WRC - Sod Erosion Software Sol $103.50 $103.50 Sub -Total Fund 101 $858,429 71 $3,582,632.20 Health $55.595.25 $347,507.00 Health Central Support $173.25 $5,964.75 Health Environmental $73,553 50 $278,454.39 Health Website Redesign $0.00 i$8 00 Oci Sub -Total Fund 221 $129,322 00 $631,066A4 Children's Village Children's Village Admin Sub -Total Fund 293 DEVELOPMENT FOR GOVERNMENTAL FUND APPROPRIATION $15,000.25 $62,470.38 $0 00 $0_00 $15,000 25 $621470 38 $1.002,751.96 $4.276.168.72 Prepared by Information Technology, 10IM= Page 2 of 22 4th Quader2020 pdf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY FOURTH QUARTER 2020 4th Quarter CUST FUND# ACCOUNT DIVISION Jul -Seo Y.T.D. SUB -TOTAL GOVERNMENTAL DEVELOPMENT APPROPRIATION: $1,002,751.96 $4,276,168.72 10100-9090101-196030-773630 Information Technology Development ($1 002 751.961 ($4 276 168 72) 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 $2,232.00 $33,660.00 935 Augusta SAW Grant $0.00 $0.00 073 Bicentennial Celebration Grant $0 00 $1,095.00 944 CAMP CTA DR Equipment $6,529.75 $36,441.50 669 CAMS/CVT Data Conversion $0 00 $0 00 055 CLEMIS $4,174.15 $60,102.13 699 CLEMIS - CAD $0.00 $0.00 448 CLEMIS/FRMS NON -BILLABLE $4,331 25 $34,485.00 056 CLEMIS FUND 63500 $27,311.50 $119,097.75 026 CLEMIS MIDC Bndge $19,689 50 $27,309.50 069 CLEMIS- Training $2773.00 $3,360.00 749 Clerk/Reg - CPL $0.00 $0 00 720 Clerk/Reg - Register Of Deeds $3,185.65 $31,753.69 719 Clerk/Rod Automation Fund $1,694.00 $43,728 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) $6,292.25 $7,656.25 937 COSDS SAW Grant $0 00 $451.50 471 Courts-FOC Exp-CS Enforcement - EDMS (Imaging) $0.00 $0 00 507 Courts-FOC Exp-CS Enforcement $36,683 58 $124,270 08 470 Courts-FOC EXP-FAM Counseling $319.00 $6,285.75 045 CV Radio System Replacement $5,445.00 $15,551.25 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 $5,099.25 $12,746 25 837 EDCA- MITradeSchool org Grant $0.00 $0.00 167 Edwards Drain SAW Grant $0.00 $0.00 100 Farmington Hills SIDS SAW $0.00 $1,791 50 210 Fire Records Management System $160 90 $1,240.44 750 FM&O $43,092A0 $133,51682 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 $1,851 25 $11,054.00 048 FM&O Bldg Security Enh Proj $0 00 $2,626.25 Prepared by Information Technology, 10/05120 Page 3 of 22 4th Quarter 2020 pdf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY FOURTH QUARTER 2020 4th Quarter CUST FUND# ACCOUNT DIVISION Jul - Sep Y.T.D. 757 FM-WK Re]/Jail MgWideo Conf $0.00 $0.00 963 FOC Security Audit $1 &20 $769 09 942 Franklin SAW Grant $0.00 $0.00 036 HACH WIMS Software Support $2,48250 $2,482.50 380 Health Immunization Grant $0.00 $0.00 173 Health - Lead Innovation Grant $0.00 $0.00 071 Health Lead PSA Grant $0 00 $9,741 25 117 Health-HepahSs A Prevention $0.00 $0.00 020 Henry Graham Drain SAW Grant $0.00 $0.00 947 HIPAA Enhancements 11 $21,895.50 $86,234.50 120 HR-Financial System Replacement $664,964.25 $2,273,818 50 214 ]AM Program $59,702 25 $333,087 75 338 Imaging Project $40,326.00 $172,591.25 751 IT Telephone Communications $0 00 $543.25 202 Jail Management System (JMS) $33,766.00 $43,911.25 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 $0.00 $9,641.75 192 Neptune Reports $0 00 $240.00 136 Oakland Township SOS 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 $0.00 $5,565 00 653 O.C. International Airport $7,796.25 $29,39175 934 OLV SOS SAW Grant $0.00 $0.00 255 Oracle Upg rade to l 9C $18,07150 $58,438.75 770 Parks and Recreation -Administration $8,126.25 $27,720 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 $000 $0.00 747 Pontiac - Water $0 00 $0.00 748 Pontiac - Sewer $0.00 $0.00 095 Pontiac Sewer $20.00 $465.00 936 Pontiac Water Asset Mgmt $0 00 $0.00 329 Pontiac WWTP Transaction $0.00 $0 00 906 Public Health Grant 795 $0.00 $0.00 791 Radio Communications - E911 $28,877 75 $128,494 25 695 Risk Management $12,738 00 $38,370.75 638 Tax Management System $0 00 $78,612.75 Pmpame by 1nfcrmaton Technology; 10/0&20 Pa9e4 of 22 4th Quarter2020 pdf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY FOURTH QUARTER 2020 4th Quarter CUST FUND# ACCOUNT DIVISION Jul - Sep Y.T.D. 601 Treasurers -DTRF $0.00 $0.00 973 UCC Program)) $35,73125 $156,710.50 115 UCC Program III - VOIP $59,198.50 $225,695 00 656 Water Resources Accounting $4,390.23 $7,642.05 731 Water Resource - Equipment $41250 $1,623.27 736 WmCan Central Storage Solution $0.00 $000 930 Water and Sewer -General Adm $5,772.50 $5,772.50 939 Water and Sewer General Administration $0.00 $0.00 974 Water and Sewer Gen Admin-WMU $0.00 $327 75 201 Water and Sewer Gen Adm - XC2 $000 $595.00 850 Workforce Dev Division $0.00 $000 281 WRC $0.00 $0.00 670 WRC Acctg - Crowder Prtct $0.00 $000 344 WRC Administration $0.00 $1,320.00 929 WRC Aeration Tank Rehab $000 $0.00 940 WRC-CAMP $536.25 $6,476.25 926 WRC CLINTON-OAKLAND SCADA $000 $0.00 932 WRC CLINTON-OAK SDS SCADA Main $0.00 $0.00 277 WRC-GWK PCF-WRC SCADA $000 $0.00 377 WRC - SAW ACACIA $000 Saw 382 WRC-SAW Birmingham $0.00 $000 379 WRC- SAW Commerce Township $000 $0.00 387 WRC - SAW Evergreen Farmington $GAO $0 G0 389 WRC - SAW Lake Orion $000 $0.00 388 WRC - SAW Novi $0.00 $0.00 386 WRC - SAW Orchard Lake $0.00 $000 674 WRC - SAW Grant Labor $000 $0.00 381 WRC SAW GWK $0.00 $0.00 895 WRC AGO $0.00 $000 734 WRC-AMR Support $82.50 $82.50 980 WRC Bingham Farms SAW $0.00 $0.00 745 WRC - COSDA Meter Replacement $000 $0.00 728 WRC - CO SDS SewMet $0.00 $0.00 168 WRC CRWRRF Admin Bldg Rehab $297 50 $2,276.00 729 WRC -EF SDS SewMet $0,00 $0.00 737 WRC - Data Application Pilot Pooect $0.00 $0.00 300 WRC - GIB Allocation by Labor $0.00 $000 277 WRC -GWK PCF-WRC SCADA $000 $0.00 295 WRC- HACH WIMS implementation $0.00 $10,629.00 894 WRC - HACH WIMS Implementation Phase it $0.00 $12,052 50 733 WRC- Hydro Drain Project $0.00 $0.00 671 WRC - Infrastructure Op Ar $000 $0.00 982 WRC Keego Harbor SAW $0.00 $000 299 WRC - MISS DIG Ticket Mgmt Sys $000 $0.00 981 WRC Oxford Twp SAW $000 $0.00 501 WRC Permitting Impl $742.50 $3,960-00 Prepared by Information Techndcgy, 10105120 Page 5 d22 4th Quarter 2020 pdf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY FOURTH QUARTER 2020 4th Quarter CUST FUND# ACCOUNT DIVISION Jul -Sep Y.T.D. 979 WRC Permitting Implementation $0 00 $6,442.00 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 $000 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 $0.00 $505.50 294 WRC - Sewer Fund $948 75 $4,908 75 067 WRC Utility Billing Replacement $1,897.50 $10,260.00 023 WRC Walled Lake Water $0.00 $0 00 024 WRC Walled Lake SDS $0 00 $0.00 121 WRC Website Standardization $1,872 75 $5,208 75 170 WRC WMU Meter Maintenance $0.00 $0.00 63600-10 80101-152000-631302 NON -COUNTY AGENCIES 63600-1080101-1520OM35017 SUB -TOTAL DIRECT CHARGES FOR DEVELOPMENT $1,181,531.61 $4479,748.57 TOTAL COUNTY DEVELOPMENT CHARGES $2.184,283.57 $8,755,917.29 Non -County Agencies S24.609.25 $55,119.78 Prepamd by information Technology 1010520 Page 6 122 4th Quarter 2020 ndf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT ! SUPPORT DETAIL - FOURTH QUARTER 2020 Ah Qtr 2020 custu GOVERNMENTAL FUNDS 630 ANIMAL CONTROL DIV 24017 SQL Server Supp-Animal Control $16090 95628 Animal Control 512,21775 95682 Dog System S14 99325 Animal Contml-Total $27,271 90 006 SO OF COMMISSIONERS 91404 BOC- Customer Support $1780625 Bd of Commissioners - Total $11,806 25 508 BOC-LEGAL RESOURCE CENTER 91405 BOC-Legal Resource Center 3$ 71 25 BOC-Legal Resource Center -Total $37t25 665 CHILDRENS VILLAGE 95665 Childrens Village $1500025 Childrens Village - Total $15,00025 668 CHILDREN'S VILLAGE ADMIN 97668 Childrens Vilage Admin $0 DO - - - Childrens Village Arl -Total $000 725 CLERK/REG -ADMIN 72500 Clerk -Admin $000 Clerk/Reg - Admin - Total WOO 718 CLERK/REG- ESERVICES 71800 E-Services 7$ 28-00 E-Services - Total $726 CC 440 CLERK/REG - ELECTIONS DIVISION 95443 Clerk/Reg - Elections Division $6,802 00 Clerk/Reg - Elections Division - Total $6,80200 727 CLERK/REG -EDMS IIMAGINGI 95168 Clerk/Reg- EDMS SpWamtenance/Upgrades $3,83116 13001 Clerk's - Efiling 000 Clerk/Reg - EDMS (Imaging) - Total $3,831 16 410 CLERKIREG - JURY COMMISSION 95512 Clerk/Reg - Jury Commission $000 Clerk/Reg - Jury Commission - Total $000 724 CLERK/REG - LEGAL RECORDS 95770 ClerklReg - Legal Records $9,42775 95189 Clerk Legai Records S53 879 73 Clerk/Reg - Legal Records - Total $63,307 48 726 CLERK/REG- MICROGRAPHICS 91002 Clerk/Reg- Micrographics 6$ 1462 ClerklReg - Micrographics - Total $614S2 291 CLERK REGISTER OF DEEDS ADMIN 95291 Clerk Register of Deeds $O.00 Clerk Register of Deeds - Total $0 00 723 CLERK/REG- VITAL STATISTICS 24015 SQL Server Supp - Vital Slats 35% $16090 95161 Clerk/Reg -Vital Statistics $18 960 00 Clerk - Vital Statistics - Total D1 I .' 11 $19,120 90 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - FOURTH QUARTER 2020 41th QV 2020 184 CLERK'S -COUNTY CLERK 96184 Clerk's - County Clerk $000 Clerk's - County Clerk - Total $0 00 522 COMM CORR-ADMIN ICOUNTYI 23003 Oracle Support -Comm Corr -52% $134.73 24012 SQL Server Supp- Community Corr 35% $160,90 52200 Comm Corr-Admin (County) $24,170 00 52201 Comm Corr -DW Support 000 Community Corrections - Total $24,465 63 620 COMPLIANCE OFFICE - AUDITING 44034 Auditing - New Development $000 95468 Auditing Intrnal Svc 0 00 Compliance Office - Auditing - Total $0 00 430 CORPORATION COUNSEL S5501 Corporation Counsel $34 064 25 Corporation Counsel - Total $34,064 25 015 COUNTY EXECUTIVE 95654 County Exec -Development $20,236.00 95656 County Executive Support $8,266 50 County Executive -Total $28,502.50 450 CIRC CT PRORATION - NORTH 80204 Circuit Court Probation - North $0 00 Circuit Court Probation - North -Total $0 00 495 CTS-BUSINESS DIVISION 12002 CCT-Courts/Criminal $0 00 23010 Oracle Support-CCTICTS CrIm Whse 26°% so DO CTS-Business Division -Total $0 00 490 CTS-FD-CT SERVICES -CLINIC 95171 CTS-FD-CT Services -Clinic 5$ 8775 CTS-FD-CT Services -Clinic - Total $587 75 506 CTS-FAM DIV-JUDICIAL SUPPT 95195 Circuit Court Admin $147000 Circuit Court Admin - Total $1,470 00 483 CTS-FOJUDICIAL SUPPORT -ADM 24009 SOL Sery Supp- CTS-Jud Sup Adm-35% 1S 60.90 CTS-FD-Judicial Support-Adm - Total $160 90 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 95179 CTS-Gen Juns-Judicial Suppt $18077777 23010 Oracle Supp-CCT/CTS $6737 CTS-Gen Juns-Judicial Suppt - Total $180,846A4 502 CTS-GJ-JURY OPERATIONS 23008 Oracle Support-CTS-GJ-Jury Operations 13473 CTS-GJ-Jury Operations - Total $134.73 493 CTSJUDICIALADMIN 13002 Courtts -Efllmg $D 00 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - FOURTH QUARTER 2020 49300 Courts Web Redesign 95174 CTS-Judicial Aomin CTS-Judicial Admm -Total 188 ECONONIC DEV & COMM AFFAIRS 98180 Economic Dev & Comm Affairs Economic Dev & Comm AHams - Total 785 FCON DEV & COMM AFFAIRS 36500 GIB Implementation Support C&E Dev 36501 CED Application -HAN Support 95785 Comm & Eco Developmt Econ Dev & Comm Affairs -Total 046 ELECTIONS-PANDEMICICOVID19 95046 Elections-Pandemic/COVIOI9 Elections-Pandemic/COVID19 - Total 740 EQUALIZATION 23012 Oracle Support -Equalization -52% 24005 SQL Sew Supp-Equeuraton - 10 5% 31075 Equal - Development 36505 GIS Implementation Support Equalization 36506 Equal Application/HW Support 36507 Equal Lams SupporUM 36601 Land System Enhancements - Equal (50%) 36701 Land System Maintenance - Equal (50%) 36801 Land System Support- Equal (50%) 36902 BS&A Orion Twp 50101 EQUAL(SS&A ANNUAL) 95562 Equalization -DW Support 95693 Equalization -System Maintenance 95699 BS&A Master Appraisal Sup/Mamt Equalization -Total 660 FISCAL SERVICES-GEN FUND 23001 Oracle Support -Fiscal Sew -156% 23013 Oracle Suppert-HR-Acctg/Budget-5.2% 24006 SQL Sew Sued - HR-Acctg - 1 75% 44021 FS-System/Customer Support 44022 FS - System Maintenance 44023 FS -System Enhancements 44024 FS - New Development 44602 Bond Disclosure - Fiscal (50%) 96001 Fiscal Sew - ACCtg 40 % 96003 Fiscal Sery - Budget 20% Fiscal Services Admin -Total 840 HEALTH DIVISION 36525 GIS Implementation Support Health 95562 User Support/Health 96842 Health - Adman Health -Total 4th Qtr 2020 $0 00 8$ 970 58 $8,970 58 5$ 3625 $536 25 $577 50 $0-00 0 00 $577 50 9 85 50 $9,852 50 $134 73 $482.62 $1 278.75 $412 50 $7,647 50 $8,053.75 $9,566A4 $4,356.28 $2,85064 $1,613.25 $0XI) $0 00 $0-00 $26 743 00 $404 13 $134.73 $80A6 $8,715 25 $0.00 $0 00 $123.75 $a.aa $4,413 40 22$ 0670 $0 00 $28,561 50 $27 033 75 $63,139A6 $1 Q078 42 $55,595 25 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2020 4th Qtr 2020 843 HEALTH - ENVIRONMENTAL 23005 Oracle Support - EH Projects - 5.2% $13473 24014 SQL Server Suppt- Ehealth 14% $64344 84200 EH - Projects $67,62208 84300 Ehealth Program IL15325 Health -Environmental -Total $73,553 50 183 HEALTH WEBSITE REDESIGN 96183 Health Website Redesign 0 00 Health Website Redesign -Total $0.00 900 HOMELAND SECURITY IHSDI 36545 GIS Implementation Support Homeland Security $0 00 36546 Homeland Security Application - H/W Support $12,609 75 95479 Homeland Security Customer $0 00 98990 Homeland Secunty $21,21425 Homeland Security - Total $33 824.00 680 HUMAN RESOURCES 23014 Oracle Support-HR-Personnel-62% $13473 24007 SQL Server Supp-HR-Personnel - 1,75 % $80 46 44044 HR- New Development $0 00 96002 Human Res -Personnel 40% $1101959 Human Resources - Total $11,234 78 907 LIBRARY -LIBRARY ADMIN 91405 Library Board 00 Library - Library Admin -Total $0,00 824 LIBRARY SERVICES 61001 Library Services $000 Library Sernces - Total $0 00 565 MARKETING&COMMUNICATIONS 56500 Marketing & Communications $12 75 Marketing & Communications - Total $120,75 872 MEDICAL EXAMINER 24002 SOL Server Support - Medical Exam -3.5% $16090 87202 Mad Exam - Cust Supt $10 518 50 Medical Examiner -Total $10,679,40 710 MSU EXTENSION - OAKLAND 95676 MSU Ext Equipment Maintenance $4125 MSU Extension - Oakland - Total $41,25 349 OCSD ADMIN SERV- RECORDS UNIT 97349 OCSD Admin Sew -Records Unit $16500 OCSD Admin Sew - Records Unit - Total $165 00 648 OCSD ADMIN SERV-SHERIFF ADMIN 97648 OCSD Admin Sew -Sheriff Admin $0 00 OCSD Admin Sew -Sheriff Admin -Total $0 00 988 OC SHERIFF'S - IFS DIV - LAB 16300 OCSO CLEMIS Forensic $1 432 00 OCSO CLEMIS Forensic -Total $1 43200 163 OCSO-CLEMIS FORENSIC I AB IMS 16300 OCSO-CLEMIS Forensic Lab 000 OCSO-CLEMIS Forensic Lab)MS -Total o... in,,. oo $0 00 n.. n.�»o. omn.,lf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - FOURTH QUARTER 2020 4th Qtr 2020 775 PLANNING & ECO DEVELOPMENT 95600 REDS Cust/System Support $6,84125 Planning & Eco Development - Total $6,841 25 512 PROB-ESTATES/MENTL HLTH EDMS (IMGI 95207 PC-E/MH EDMS Support & Mice $3 352 33 Prob-Est/Mntl HIM EDMS (Img) - Total $3,352 33 510 PROS-ESTATES/MENTL HLTH SUPPORT 24010 SQL Sery Supp-PCT-Est/Mental - 3 5% $160 90 92198 PC-E/MH Support-Dev $16,426 00 Prob-Est/Mntl Hlth Support -Total $16,586 90 481 PROB-FO JUDICIAL 95168 PC -Judicial Family Admin-Famtly Judges $0 00 Prob - FD Judicial - Total $000 479 PROB-FD JUDICIAL SUPPORT 95188 PC -Judicial Adm-Fam $000 PC -Judicial Adm-Faro -Total $OAO 145 PRnSEC_IITOR- GENFRAL PROSECUTION 24016 SQL Server Supp-Prosecutors 35% $160.90 95622 Prosecutor/Executive $8,078 25 95664 Prosecutor Warrants $1875180 97001 Prosecutor Data Proc $000 Prosecutor - Total $26,991 95 690 PURCHASING 44028 Pur-System Enhancements $Coe 44029 Pur-New Development $1 402 50 Compliance Office - Purchasing - Total $1,402 50 637 RECORDS RETENTION 44053 REC- System Enhancements OAO Records Retention - Total $000 650 REIMBURSEMENT DIV 95470 Reim System $3,516 00 95542 Reimburse User Support 11$ 9825 Reimbursement - Total $4,714 25 195 SHERIFF 12001 OCSD-Courts/Cnminal-50% $000 23009 Oracle Suppport - OCSD/CTS Cnm Whse-26% $6737 97163 OCSD-Corrective Sery $8,06475 97164 Sheriff - Development $41,69600 97165 S),enff-DW Support $000 98164 CLEMISSheriff 5000 Sheriff - Total $49,828 12 191 SHERIFF - CLEMIS 23015 Oracle Suppport-Sherrf/CLEMIS-52% $13473 96163 Sheriff - CLEMIS $11.96125 Sherr f - CLEMIS - Total $12,095 98 348 SHERIFF -CORRECTIVE SERV ADMIN 34800 Inmate Phone System 00 Sheriff - Corrective Sery Admm - Total $000 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2020 4th Qtr 2020 647 OCSD PATROL SERV ADMIN 97647 Sheriff - Patrol Sew Admin S0-00 Sheriff - Patrol Sew Admin - Total $0 00 445 SUPPORT SERVICES ADMIN 23002 Oracle Support -Supp Sew -52% $13473 24011 SQL Server Supp- Suppt Sentices 7% $32172 44500 Support Services Use $267575 Support Services - Total $3,132 20 60D TREASURERS OFFICE 23006 Oracle Support - Del Tax -52% $13473 23016 Oracle Support - Treasurer -10A% $26940 36516 Treasurer Application - HAN Support $0 00 36602 Land System Enhancements -Tress (50% $9.566 06 36702 Land System Maintenance - Tress (50% $4,356.22 36802 Land System Support- Tress (50%) $2,85061 44061 TreSyste nlCustomer Support $33,632 58 44062 Tre-System Maintenance $1,841 25 44063 Tr"ystem Enhancements $1,09400 44064 Tre-New Development $6,440 50 44080 Tre-DW Support $000 44082 Tre-DW Maintenance $0 00 44601 Bond Disclosure -Tress (50%) $0 00 50102 Tress(BS&A Annual $161325 91001 Treasurers-25% $20488 95008 Del Tax On Line $1 485 00 95303 Del Tax System Maintenance $0.00 95561 User Support)Del Tax $7,12260 95615 BS&A Annual Tax Support SO 00 Treasurer - Total $70,610.98 169 TREASURERS- BANKING RFP 96169 Treasurers - Banking RFP coo Treasurers - Banking RFP - Total $0 DO 627 TREASURER-LANDSALE 44033 Treasurer-Landsale .00 Treasurer -Landless - Total $0 00 978 TREASURERS OFFICE-OAKDOCS 95978 Treasurers - Oakdocs 2517626 Treasurers - Oakdocs -Total $25,176 25 910 VETERANS SERVICES 95651 Veterans Customer Support $10,257.00 95650 Veterans Seances-Eq 2$ 22 75 Veterans Services - Total $10,479 75 730 WATER RESOURCE COMMISSION 24008 SQL Server Supp-WRC 35% $160.90 28010 WRC-Customer Suppt $17,48200 28011 WRC Custom Application $3,960.00 86520 GIB Implementation Support WRC $7 773 75 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - FOURTH QUARTER 2020 4th Qtr 2020 36521 WRC Program Support $2598750 Water Resource Commissioner -Total 742 WRC CAMS SOFTWARE SUPP & MAINT 74200 WRC CAMS SOFTWARE Support $0 00 WRC CAMS SOFTWARE Supp & Maint -Total 203 WRC EU PUB ED ADM PROGRAMS 74203 WRC EU Pub Adm Programs 103 50 WRC EU Pub Adm Programs -Total 301 WRC - SOIL EROSION SOFTWARE SOL_ 74301 WRC - Soil Erosion Software Sal $0 00 WRC - Soil Erasion Software Sol -Total 540 5211-NOVI 95527 Dist Ct Supp -25% $4,25340 5211 District Court -Total 550 5212 CLARKSTON 95528 Dist Ct Supp -25% $4,25340 522 District Court -Total 560 52/3 ROCHESTER 95288 52 Dist Ct Div 3 $0 00 95529 Dist Ct Supp -25% $425340 5213 Distinct Court - Total 530 5214 TROY 95530 Dist Ct Supp -25% $4 253 05 52/4 District Court - Total Oust# DIRECT FUNDS (NON -GOVERNMENTAL FUNDSI 053 AIRPORT SPECIAL EVENTS 65350 Airport Special Events 000 Airport Special Events -Total 274 ASAP PASSPORT SYSTEM 97274 ASAP Passport System $0 00 ASAP Passport System - Total 672 ASSESSMENT & TAX 67200 Assessment & Tax 2$ 232 00 Assessment & Tax - Total 935 AUGUSTA SAW GRANT 37935 Augusta SAW Grant $0 00 Augusta SAW Grant -Total 944 CAMP CTA DR EQUIPMENT 37944 Camp CTA DR Equipment $6 529 75 Camp CTA DR Equipment - Total 055 CLEMIS 23004 Oracle Support- OakVdeo CLEMIS 52% $13473 23018 Creole Support- Sheriff CLEMIS 5.2% $134.36 24004 SQL Server Support -245% $1,12&06 90510 CLEMIS- Oakvideo Support $0.00 95430 CLEMIS Maintenance $cm $49,364.15 $0.00 $103.50 $0 00 $4,253 40 $4,253 40 $4.253.40 $1,002,578.71 $4,253 05 $0 00 $0 00 $2,232 00 $0.00 $6,529.75 026 CLEMIS MIDC BRIDGE 699 CLEMIS-CAD 056 CLEMIS FUND 63500 448 CLEMISIFRMS NON -BILLABLE 069 CLEMIS-TRAINING 669 CAMS/CVT DATA CONVERSION 749 CLERK/REG - CPL 720 CLERK/REG - ROD 719 CLERK/ROD AUTOMATION FUND 659 COLLABORATIVE ASSET MGT SYS 937 COSDS SAW GRANT 471 CTS-FOC-EXP-CS ENFORC-EDMS (IMGI 507 CTS-FCC EXP-CS ENFORCEMENT INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2020 95431 CLMS Enhancements 98003 CLEMIS User Support 98005 CLEMIS -E911 Support 98000 Poject Team CLEMIS - Total 91026 CLEMIS MIDC Bridge CLEMIS MIDC Bridge -Total 98006 CLEMIS - CAD Development CLEMIS - CAD - Total 63500 CLEMIS Fund CLEMIS 63500 Fund -Total 44800 CLEMIS/FRMS NON -BILL CLEMISIFRMS NON -BILL - Total 91069 CLEMIS-Training CLEMIS - Training - Total 66901 CAMS/CVT Data Conversion CAMS/CVT Data Conversion -Total 74900 Clerk/Reg -CPL Clerk/Reg - CPL - Total 24003 SOL Server Supp - ROD 3.5% 36510 GIB Implementaton Support 36511 ROD Application/HW Support 95493 ROD System Maintenance 95498 ClerklReg - ROD Clerk/Reg - ROD -Total 95719 Register of Deeds Automation Register of Deeds Automation -Total 65901 Collabortive Asset Mgt Sys Collabortive Asset Mgt Sys - Total 37937 COSDS SAW Grant COSDS SAW Grant - Total 92194 CTS-FOC-CS ENF-EDMS Support/Maintenance/Upgrades CTS-FOC Exp-CS Enforc-EDMS (Img) - Total 34044 CTS-FOC-CS-Enforce 4th Qtr 2020 $0 00 $2,779 00 $0.00 SO $19 689.50 $0 00 $27 311 50 331 25 2 773 00 $0.00 $0.00 $160 90 $0.00 $2,156 DD $0 00 8$ 68 75 1.694_00 0 00 $0 00 $0 00 $28 00 $4,17415 $19,689 50 $0.00 $27,311 50 $4,331 25 $2,773 00 $0.00 $0.00 $3,185 65 $1,694 00 $0 00 $0 00 $0.00 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2020 4th Qtr 2020 65410 FCC -Image Replace $580 00 92193 CTS-FOC-CS Enforc-Dev $32,72325 92194 CTS-FOC-CS Enf-EDMS $3 352 33 CTS-FOC Exp-CD Enforc-Dev-Total $36,683.58 470 CTS-FOC EXP-FAM COUNSELING 34041 CTS-FCC EXP-FAM Counseling $87 00 92195 CTS-FOC EXP-FAM Coun $232.00 CTS-FCC EXP-FAM Counseling -Total $319 00 521 COMM CORR -ADM IGRANTI 52100 Comm Corr Admin-GR $629225 Comm Corr- Adm (Grant) -Total $6,291 435 COMM DEV - HOUSING COUNSELOR 66104 Housing Counselor 000 Housing Counselor -Total $000 045 CV RADIO SYSTEM REPLACEMENT 95045 CV Radio System Replacement $5 445 00 CV Radio System Replacement Total $5,445 00 673 CYBER SECURITY FUND 67300 Cyber Security Fund $0-00 Cyber Security Fund - Total $0 00 931 DRAIN EQUIPMENT FUND 37931 Drain Equipment Fund $000 Drain Equipment Fund -Total $000 189 DRAIN EQUIPMENT FUND- POWERPLAN CONTRACT 35189 Drain Equipment Fund- Pcwerplan Contract 0.00 Drain Equipment Fund - Powerplan Contract - Total $000 933 DRAIN EQUIP MAP 37933 Dram Equip Map 5 0$ 99 25 Dram Equip Map - Total $5,099.25 837 EDCA- MITRADESCHOOL.ORG GRANT 83700 EDCA-MITRADESCHOOL $000 EDCA - MlTradeSchool.org Grant - Total $0.00 210 FIRE RECORDS MANAGEMENT SYSTEM 21010 Fire Records Mgmt Fund 531 $000 95404 FIRMS - Phase II Proj $000 24001 SQL Saw Supp-Fire R 1$ 60A0 Fire Records Management System - Total $160.90 750 FM&O 21001 Fac Maint & Oper $240.25 24013 SOL Server Supp -FM&C $160.90 75503 FMO Development $42 691 25 FM&O -Total $43 091 756 FM&O BUILDING MAINTENANCE 75600 FM&O Building Maintenance 0-00 FM&O Building Maintenance -Total $000 133 FM&O BUILDING MAINTENANCE SYSTEM 21133 FM&O Building Maintenance System $000 FM&O Building Maintenance System - Total $000 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2020 080 FMO BLDG MGMT SYSTEMS REPLACEMENT PH 2 963 FOB SFCURITY AUDIT 942 FRANKLIN SAW GRANT 038 HACH WIMS SOFTWARE SUPPORT 852 HEALTH CENTRAL SUPPORT 117 HEALTH- HEPATITIS A PREVENTION 380 HEALTH -IMMUNIZATION GRANT 947 HIPAA ENHANCEMENTS If 120 HR-FINANCIAL SYSTEM REPLACEMENT 214 IAM PROGRAM 338 IMAGING PROGRAM 751 IT -TELEPHONE COMM 202 JAIL MANAGEMENT SYSTEM fJMSI_ 112 MEDICAL MARIJUANA PSA 101 MEDICAL MARIJUANA MYSIDEWALK 113 MIDC CLEMIS DEV 21080 FMO Bldg Mgmt Systems Replacement Ph 2 FMO Bldg Mgmt Systems Replacement Ph 2 -Total 34963 FOC Security Audit FOC Security Audit - Total 37942 Franklin SAW Grant Franklin SAW Grant - Total 74038 HACH WIMS Software Support HACH WIMS Software Support - Total 95852 Health Central Support Health Central Support - Total 96117 Health-HEP A Prevention Health-HEP A Prevention -Total 38000 Health -Immunization Grant Health -Immunization Grant -Total 96947 HIPAA Enhancements ll HIPAA Enhancements It -Total 44120 HR-Financial System Replacement HR-Financial System Replacement - Total 21400 IAM Program IAM Prcgrem-Total 33800 Imaging Project Imaging Project -Total 75102 Tel Comm - Customer IT - Telephone Comm - Total 63202 Jail Management System (JMS) Jail Management System (JMS) - Total 96112 Medical Manjuana PSA Medical Mariivana PSA-Total 96101 Medical Marijuana Mysidewalk Medical Marijuana Mysidewalk - Total 91113 MIDC CLEMIS Dev MIDC CLEMIS Dev, - Total 4th Qtr 2020 $1 851 25 $1,851 25 t$ 8.20 $18 20 $0 00 Suff $2 482 50 $2,482 50 17325 $173 25 000 $om $0 00 $0 00 $21 89550 $21,895SO $664 964 25 $664,964 25 $59 7(l $69,702 25 $40 326 00 $40,326 00 a 00 $0 00 $33,766 00 $33,766 00 0.00 $0 00 000 $0 00 0.00 $0-00 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2020 41th Qtr 2020 634 OAKVIDEO UPGRADE MAJ 63400 CLEMIS-OakUdeo Upgrade $0.00 63401 IT - OakVideo Upgrade $0 00 OskVideo Upgrade RA) - Total $000 938 OAKWIN RADIO SYSTEM ENH 98938 OAKWW Radio System Enh Woo OAKWIN Radio System Enh -Total $000 653 O.C. INTN'L AIRPORT 36540 GIS Implementation Support $000 65301 Airport User Support $7,71375 65310 O.C. Airport -NeW Dev 8250 O C. Intnl Airport - Total $7,796 25 934 OLV SDS SAW GRANT 37934 OLV SDS SAW Grant $000 OLV SDS SAW Grant - Total $0 00 255 ORACLE UPGRADE TO 19C 63255 Oracle Upgrade to 19C $18 071 50 Oracle Upgrade to 19C - Total $18,071 50 770 PARKS AND RECREATION 36530 GIS Implementation Support - Parks $1,19&25 44066 PRADM-System/Customer Support $53625 44068 PRADM-System Enhancements $000 76100 P&R Administrative Services $000 95413 PRADM-Customer Support $6,39375 95416 PRRA - Rep Admin $000 95419 PRADM-Administrativn $000 Parks & Recreation - Total $8,126 25 867 P&R CAPITAL IMPROVEMENT 86700 P&R Capital Improvement 0.00 P&R Capital Improvement - Total Slim 925 P&R EMS UPGRADE 37925 P&R EMS Upgrade 0 00 P&R EMS Upgrade -Total $000 796 P&R FACILITIES & MAINTENANCE 79600 P&R Facilities & Maintenance $000 P&R Facilities & Maintenance -Total $000 442 P&R LYON OAKS CONF CTR CIP#2469 44200 P&R Lyon Oaks Conf Ctr CIP #2469 $000 P&R Lyon Oaks Cont Ctr CIP #2469 -Total $000 443 P&R LYON OAKS CONF CTR CIP#2468 44300 P&R Lyon Oaks Conf CTR CIP#2468 $000 P&R Lyon Oaks Cant CTR CIP#2468 -Total $000 454 P&R SPRINGFIELD OAKS CIP#2471 45400 P&R Springfield Oaks CIP#2471 $0 00 P&R Springfield Oaks CIP#2471 -Total $000 456 P&R SPRINGFIELD OAKS CIP#2470 45600 P&R Springfield Oaks CIP#2470 SO 00 P&R Spnngfield Oaks CIP#2470 - Total $0.00 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - FOURTH QUARTER 2020 4th Qtr 2020 457 P&R RED OAKS CLUBHOUSE GIPS2467 45700 P&R Red Oaks Clubhouse CIP#2467 $0 00 P&R Red Oaks Clubhouse CIP#2467 -Total $0.00 268 PONTIAC METER 74268 Pontiac Meter $000 Pontiac Meter - Total $0 00 747 PONTIAC WATER 74701 Pontiac BSA to WRC - Water $000 Pontac Water - Total $0 00 095 PONTIAC SEWER 74095 Pontiac Sewer $20 00 Pontiac Sewer - Total $20.00 748 PONTIAC SEWER 74702 Pontiac BSA to WRC-Sewer 000 Pontiac Sewer - Total $0.00 936 PONTIAC WATER ASSET MGMT 37936 Pontiac Water Asset Mgmt $0 00 Pontiac Water Asset Mgmt - Total $0 00 329 PONTIAC WWTP TRANSACTION 67329 Pontiac WWTP Transaction 0.00 Pontiac WWTP Transaction - Total $0 00 791 RADIO COMMUNICATIONS -F911 79101 Radio Communications -E911 $28.87775 Ral Communications - E911 -Total $28,877.75 695 RISK MANAGEMENT 44D36 RskSystem/Customer Support $12,738 00 Risk Management - Total $12,7a&00 638 TAX MANAGEMENT SYSTEM 63800 Tax Management System $0 00 Tax Management System -Total $0 00 973 UCC PROGRAM It 92973 UCC Program It $35,731 25 UCC Program II - Total $35,731 25 115 UCC PROGRAM III - VOIP 92115 UCC Program III - VOIP 59 19850 UCC Program It - VOIP - Total $59,19A50 656 WATER RESOURCES ACCTG 23011 Oracle Supp- Water &Sewer Acctg-5.2% $13473 95669 Water Resources Acct $q 25550 95671 Dram Water/Sewer BI $0 00 Water Resources Accounting -Total $4,390.23 731 WATER RESOURCE - EQUIPMENT 74501 Water Resound - Equipment 4S 12.50 Water Resouce - Equipment- Total $412 50 736 WINCAN CENTRAL STORAGE SOLUTION 73601 WmCan Central Storage Solution $0 00 WinCan Central Storage Solution -Total $0.00 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2020 4th Qtr 2020 930 WATER AND SEWER -GENERAL ADMIN 37930 Water and Sewer -General Admin $577250 Water and Sewer -General Admin -Total $5,77250 939 WATER AND SEWER GENERAL ADMINISTRATION 37939 Water and Sewer General Administration $000 Water and Sewer General Administration - Total $000 850 WORKFORCE DEV DIVISION 95670 Workforce Development $0-00 Workforce Development - Total $0.00 670 WRC ACCTG-CROWDER PRJCT 60001 WRC- Crowder NetBase Project $000 67000 WRC- Crowder NetBase Project $000 WHO Acctg - Crowder Prject - Total $000 929 WRC AERATION TANK REHAB 35700 WRC Aeration Tank Rehab $000 WRC Aeration Tank Rehab -Total $000 168 WRC CRWRRF ADMIN BLDG REHAB 33168 WRC CRWRRF Admin Bldg 2$ 97 50 WRC CRWRRF Admin Bldg -Total $297.50 501 WRC PERMITTING IMPL 74502 WRC Permitting Impl 7$42.50 WRC Permitting Imp] -Total $742 50 979 WRC PERMITTING IMPLEMENTATION 74979 WRC Permitting Implementation $000 WRC Permitting Implementation -Total $0.00 403 WRC-SAW BLOOMFIELD VILLAGE 33403 WRC-SAW Bloomfield Village $0.00 WRC - SAW Bloomfield Village - Total $000 358 WRC- SCADA MAINTENANCE 33358 WRC- SCADA Maintenance $000 WHO - SCADA Maintenance - Total $000 940 WRC-CAMP 37940 WRC - Camp 5$ 3625 WRC - Camp - Total $536.25 926 WRC CLINTON-OAKLAN❑ SCADA 33926 WRC Clinton -Oakland SCADA 0.00 WRC Clinton -Oakland SCADA - Total $000 932 WRC CLINTON-OAK SDS SCADA MAIN 37932 WRC Clinton -Oak SDS SCADA Main $000 WRC Clinton -Oak SDS SCADA Main -Total $0 00 281 WRC 74281 WRC $000 WRC -Total $000 377 WRC-SAW ACACIA 28674 WRC-SAW Acacia $000 WHO - SAW Acacia -Total $000 382 WRC SAW BIRMINGHAM 33382 WHO SAW Birmingham $000 WRC SAW Birmingham - Total $000 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - FOURTH QUARTER 2020 4th Qtr 2020 379 WRC-SAW COMMERCE TOWNSHIP 33379 WRC- SAW Commerce Township 0.00 WRC - SAW Commerce Township - Total $0.00 386 WRC-SAW ORCHARD LAKE 33385 WRC-SAW Orchard Lake $000 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 00 WRC SAW GWK -Total $000 686 WRC-SAW GRANT LABOR -COMMON TO AL I. 60002 WRC-SAW Grant Labor -Common to A)) $0.00 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 $8250 WRC - AMR Support - Total $82 50 745 WRC- COSDA METER REPLACEMFNT 74500 WRC- COOSA Meter Replacement $000 WRC - CODSA Meter Replacement - Total $000 728 WRC - CO SDS SEWMET 72201 MARS Enhancements- WRC C-0 0.00 WRC - CO SDS SewMet - Total $0.00 729 WRC - EF SOS SEWMET 72202 MARS Enhancements - WRC E-F $000 WRC - EF SDS SewMet - Total $000 737 WRC- DATA APPLICATION PILOT PRJ 73700 WRC- Data Applicaton Pilot Project $0 cc 73710 WRC - Data Appl Prj $000 WRC - Data Application Pilot Pp - Total $000 300 WRC-GIS ALLOCATION BY LABOR 73300 WRC-GIS Allocation by Labor $0 DO WRC-GIS Allocation by Labor - Total $000 277 WRC-GWK PCF-WRC SCADA 74277 WRC-GWK PCF-WRC SCADA 1900 WRC - GWK PCF-WRC SCADA- Total $0 00 295 WRC MACH WIMS IMPLEMENTATION 67296 WRC-HACH WIMS Implementation KOM WRC-HACH WIMS Implementation -Total $0.00 894 WRC -HACH WIMS IMPLEMENTATION 37894 WRC-HACHWIMS Implementation $00a WRC-HACH WIMS Implementation - Totai Sam 733 WRC-HYDRO DRAIN PROJECT 73301 WRC-Hydro Drain Project $0 00 WRC-Hydro Dram Project - Total $000 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2020 4th Qtr 2020 671 WRC-INFRASTRUCTURE OF 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 $0.00 739 WRC-SCADACOMMON 73900 WRC-SCADA Common $000 WRC - SCADA Common - Total $000 738 WRC- SCADA ENGINEERING ASSESSMT 73800 WRC- SCADA Engineering Assesmnt $000 WRC - SCADA Engmeenng Assesmt - Total $0 00 358 WRC- SCADA MAINTENANCE 33358 WRC- SCADA Maintenance $000 WRC - SCADA Maintenance - Total $000 294 WRC-SEWERFUND 74294 WRC - Sewer Fund 9$4875 WRC - Sewer Fund - Total $948 75 067 WRC UTILITY BILLING REPLACEMENT 33067 WRC Utility Billing Replacement 1 89750 WRC Utility Billing Replacement $1,897 50 023 WRC WALLED LAKE WATER 35023 WRC Walled Lake Water 000 WRC Walled Lake Water - Total $0.00 024 WRC WALLED LAKE SDS 35024 WRC Walled Lake SDS 000 WRC Walled Lake SDS -Total $000 $1,181,704.86 121 WRC WEBSITE STANDARDIZATION 33121 WRC Website Standardization 1,87275 WRC Website Standardization -Total $1,872.75 INFORMATION TECHNOLOGY DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2020 4th Quarter Y.T.D. Radio 18020 IT Radio $0.00 0.00 $0.00 $0.00 Application Services 17040 IT - TOS Fund $0.00 $0.00 17062 Pandemic Program - COVID-19 $313,602.50 $865,726.05 18000 IMACS Data Warehouse (Funded) $0.00 $0.00 19000 IT Application Services Planned Maint $308,305.25 $1,529,104.50 30001 IT Application Services Data Warehouse $14,407.25 $54,402.75 30002 IT Application Services Enhanced $10,659.50 $39,318.75 30003 IT Application Services GIS $98,379.75 $442,528.50 30004 IT Application Services eGovernment $406,390.10 $1,520,131.75 25108 Courts - Oakland Schools $0.00 $0.00 36901 BS&A Orion Twp - IT $0.00 0.00 App Services - Sub Total: $1,151.744.35 $4,451,212.30 Internal Services 19020 Internal Services Planned Main $13,919.50 $187,584.75 Internal Services - Sub -Total: $13,919.50 $187,584.75 $0.00 Technical Sys/Networking 19030 Tech Sys/Net Planned Maint $107,869.00 $365,728.30 23007 Oracle Support - IT Tech Systems 134.73 $761.07 23017 Oracle Support - IT Tech Systems 1.2% $31.11 $175.65 24018 SQL Sery Support - IT Tech Systems 2% $91.34 $142.11 25400 Oracle Administration $10,395.00 $18,480.00 95685 I.T. - Disaster Recovery $1,734.25 $2,501.50 95750 IT - SEP $130,174 50 $472,027.25 95755 I.T. - PeopleSoft Upgrade $0.00 $0�00 Tech Sys/Net - Sub -Total: $250,429.93 $859,815.88 Information Technology - Total: $1,416,093.78 $5,498,612.93 Prepared by. Information Technology; 10/05/20 Page 22 of 22 4th Quarter 2020.pdf DJJ89SEZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 TRRU 09/25/2020 CUSTOMER # 005 ED OF COMMISSIONERS ACCT PROJECT ACCT# DESCRIPTION PROJECT DESC 91404 BOC - CUSTOMER SUPPT DE9007CS 2019-20 eGovernment Customer Sup 91404 DOC - CUSTOMER SUPPT DE9162CF Citizen Engagement Budget - Fine 91404 BOC - CUSTOMER SUPPT DJ9010EB Finance/Admin Enhancement Budget 92404 BOC - CUSTOMER SUPPT DJ9182SE Finance/Admin Sizing Budget 91404 TOTAL HOURS CHARGE 26.50 3,663.00 2.SD 172,50 3.75 307.50 55.75 7,663.25 88.50 11,806.25 88.50 11,606.25 PAGE 1 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 2 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 14.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 010 INFO TECHNOLOGY ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 19000 APR SVCS PLANNED MAI DA8007PM 2018-20 HR Finance Planned Maint 172.25 26,265.25 19000 APR SVCS PLANNED MAI DBB007PM 201E-20 Courts Planned Maintenan 321.50 45,491.00 19000 APP SVCS PLANNED MAI DB9182KU Kofax Upgrade 2019-20 100.25 1D,305.75 19000 APP SVCS PLANNED MAI DES007PM 2018-20 eGovernment Planned Main 26.00 4,279.00 19000 APR SVCS PLANNED MAI DJ8007PM 2018-20 eCommerce Planned Mainte 34.75 5,384.25 19000 APP SVCS PLANNED MAI DJ900VPC PCI - Yearly Update (2020) 88.25 11,171.25 19000 APR SVCS PLANNED MAI D18007PM 2018-20 Infrastructure & GIS Pla 370.00 56,724.25 190DO APR SVCS PLANNED MAI DIBI62CC CAMS 15.3 Cloud Upgrade Phase 2 98.50 16,439.50 19000 APP SVCS PLANNED MAI D19182GD GIS Enterprise Apps & Infrastruc 5.50 907.50 19000 APP SVCS PLANNED MAI D19182GP GIS Enterprise Apps & Infrastruc 209.25 31,696.25 19000 APP SVCS PLANNED MAI D19162GQ GIS Enterprise Apps & Infrastruc 204.00 3D,678.50 19000 APP SVCS PLANNED MAI D58007PM 2018-20 Public & Environmental S 128.50 20,264.50 19000 APP SVCS PLANNED MAI D9B007PM 2018-20 Assessing & Tax Planned 323.00 40,683.25 19000 APP SVCS PLANNED MAI D99182IV Upgrade IVR Servers 57.00 7,995.00 19000 2,138.75 308,305.25 19020 INTERNAL SVC PLANNED DH8007PM 2018-20 IS PMO Planned Maintenan 3,00 495.00 19020 INTERNAL SVC PLANNED DR8007PM 2D18-20 IS Service Center Plante 4.25 701.25 19020 INTERNAL SVC PLANNED DR9181UP Telesoft Upgrade to Connect 79.50 12,723.25 19020 86.75 13,919.50 19030 TECH SYST PLANNED MA TS8007PM 2018-20 SEP Planned Maintenance 27,75 4,578.75 19030 TECH SYST PLANNED MA TT8007PM 2018-20 Enterprise Architecture 0.25 30.25 19030 TECH SYST PLANNED MA T38007PM 2018-20 DBA Planned Maintenance 374,50 57,802.50 19030 TECH SYST PLANNED MA TGB007PM 2018-20 Server Administration PI 380.00 45,457.50 19030 782.50 107,669.00 23007 ORACLE SUPPORT -IT TE T39007SM 2019-20 DBA System Maintenance 0.92 134.73 23007 0.92 134.73 23017 ORACLE SUPP-IT TECH T39007SM 2019-20 DBA System Maintenance 0.18 31.11 23017 0.1B 31.11 24018 SQL SERV SUPP-IT DEC T39007SM 2019-20 DBA System Maintenance 1.40 91.34 24018 1.40 91.34 25400 ORACLE ADMINISTRATIO T390D7SM 2019-20 DBA System Maintenance 63.00 10,395.00 25400 63.00 10,395.00 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 3 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 14.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 010 INFO TECHNOLOGY ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC NOURS CHARGE 30001 IT APR SVCS DATA WAR DE9007CS 2019-20 Courts Customer Support 79.25 13,076.25 30001 IT APP SVCS DATA WAR D19007CS 2019-20 Infrastructure & GIS Cus 0.25 41.25 30001 IT APT SVCS DATA WAR D99007CS 2019-20 Assessing & Tax Customer 10.00 1,289.75 30001 89.50 14,407.25 30002 IT APP SVCS ENHANCED DJ8182PM G2G Program Management 71.50 10,527.00 30002 IT APP SVCS ENHANCED DR9007CS 2019-20 IS Service Center Custom 2.50 132.50 30002 74.00 10,659.50 30003 IT APP SVCS CIS D19007CS 2019-20 Infrastructure & GIS Cus 658.50 87,161.25 30003 IT APP SVCS GIS D190070C Out County GIS Data Maintenance 1.25 206.25 30003 IT APP SVCS GIS D19007SM 2019-20 Infrastructure & GIS Sys 25.50 4,207.50 30003 IT APP SVCS GIS D19182CE CAMS Enterprise Enhancements 201 42.25 6,602.25 30003 IT APP SVCS GIS D99007SM 2D19-20 Assessing & Tax System 1.00 100.00 30003 IT APP SVCS GIS D99182SB Land Sizing Budget 0.50 82.50 30003 729.00 98,379.75 30004 IT APP SVCS E-GOVERN DE9007CS 2019-20 eGovernment Customer Sup 954.50 90,29B.00 30004 IT APR SVCS E-GOVERN DE9007SM 2019-20 eGovernment System Maint 62.00 10,230.00 30004 IT APP SVCS E-GOVERN DE9182CE Citizen Engagement Budget - IT 348.25 27,960.75 30004 IT APP SVCS E-GOVERN DE9182CR County Recognition and Initiativ 9.75 984.75 30004 IT APP SVCS E-GOVERN DE9182CS Content Management System Strate 1.00 165.00 30004 IT APP SVCS E-GOVERN DE9182SB eGovernment Sizing Budget 73.75 10,585.50 30004 IT APP SVCS E-GOVERN DE9191DM EDCA Digital Marketing Program 109.75 10,106.25 30004 IT APR SVCS E-GOVERN DJ0182PI G2GCS Participant Implementation 30004 IT APR SVCS E-GOVERN DJ0182SM eCommerce Redesign - Shop Migrat 207.00 26,620.00 30004 IT APP SVCS E-GOVERN DJ8182EB PIT Enhancement Budget 28.25 4,661.25 30004 IT APP SVCS E-GOVERN DJ8182GD G2G Program Development 80.00 9,300.50 30004 IT APP SVCS E-GOVERN DJ8182PI G2GCS Participant Implementation 199.00 23,889.75 30004 IT APP SVCS E-GOVERN DJ8182R2 eCommerce Redesign - Refund (Par 53.00 7,820.75 30004 IT APP SVCS E-GOVERN DJ9007CS 2019-20 eCommerce Customer Suppo 958.75 114,531.25 30004 IT APP SVCS E-GOVERN DJ9007SM 2019-20 eCommerce System Mainten 222.50 28,120.00 30004 IT APP SVCS E-GOVERN DJ9182RE eCommerce Redesign (Phase 2) - E 1.00 165.00 30004 IT APP SVCS E-GOVERN DR9007CS 2019-20 IS Service Center Custom 3.00 159.00 30004 IT APP SVCS E-GOVERN D99007TM 2019-20 Application Services Tea 98.25 16,211.25 30004 IT APP SVCS E-GOVERN TT8186CM G2G Cloud Solutions Marketing Bu 28.50 3,812.50 30004 IT APP SVCS E-GOVERN TT8186MP G2G Marketplace Marketing Budget 95.10 13,023.10 30004 IT APR SVCS E-GOVERN TTB186PD G2GCS Participant Development Bu 34.50 4,650.50 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 4 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 14.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 01D INFO TECHNOLOGY ACCT PROJECT ACCT# DESCRIPTION PROJECT DESC 30004 IT APR SVCS 2-GOVERN TTS166VI G2G Marketplace Vendor Implement 30004 IT APR SVCS E-GOVERN T390079M 2019-20 DBA System Maintenance 30004 95685 I.T. - DISASTER RECO DB8007PM 2018-20 Courts Planned Maintenan 95685 95750 I.T. - SEP DE8182AS SEP - Application Services Enhan 95750 I.T. - SEP DE9182CE Citizen Engagement Budget - IT 95750 I.T. - SEP TS8186SE SEP - Enhancements 2019-20 95750 I.T. - SEP TS9186CO SEP - Change Order Services 95750 I.T. - SEP TS9186SB SEP - Sizing Budget 95750 I.T. - SEP T68186TE SEP - TSN Enhancements 95750 TOTAL HOURS CHARGE 19.50 2,682.50 2.50 412.50 3,589.85 406,390.10 14.75 1,734.25 14.75 1,734.25 2.00 330.00 31.50 2,917.50 541.50 76,733.50 93.50 15,295.50 13.50 1,593.00 227.50 33,305,00 909.50 130,174.50 8,48D.10 1102,491.28 DJJ89SEZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 5 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 14.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER 4 015 COUNTY EXECUTIVE ACCT ACCT# DESCRIPTION PROJECT 95654 COUNTY EXEC-DEVELOPM DE9182CF 95654 COUNTY EXEC-DEVELOPM DJ9010EB 95654 95656 COUNTY EXECUTIVE SUP DE9007CS 95656 PROJECT TOTAL DESC HOURS CHARGE Citizen Engagement Budget - Fina 11B.50 16,482.25 Finance/Admin Enhancement Budget 26.75 3,753.75 145.25 20,236.00 2019-20 eGovernment Customer Sup 53.25 8,266.50 53.25 8,266.50 198.50 28,502.50 DJJB95EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 6 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 14.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 026 CLEMIS MIDC BRI➢GE ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 91D26 CLEMIS MIDC BRIDGE DG7183MI CLEMIS Michigan Indigent Defense 184.00 18,261.50 91026 184.00 18,261.50 184.0D 18,261.50 DJJ695EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/2B/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 038 HACH WIMS SOFTWARE SUPPORT ACCT ACCT# DESCRIPTION PROJECT 74038 HACH WIMS SOFTWARE S D59611D5 74038 PROJECT DESC WRC Development Budget 2019 - 20 TOTAL HOURS CHARGE 17.75 2,482.50 17.75 2,482.50 17.75 2,4B2.50 PAGE 7 14.52.04 DJJ895RZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/26/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THEN 09/25/2020 CUSTOMER # 045 CV RADIO SYSTEM REPLACEMENT ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 95045 CV RADIO SYSTEM REPL DL9183CV Children's Village Radio System 33.00 5,445.00 95045 33.00 5,445.00 33.00 5,445.00 PAGE 8 14,52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 14.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 046 ELECTIONS-PANDEMIC/COVIDI9 ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 95046 ELECTIONS-PANDEMIC/C DE9182CC Citizen Engagement Budget - Cour 68.75 9,852.50 95046 68.75 9,852.50 68.75 9,852.50 9 nJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 055 CLEMIS ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 23004 ORACLE SUPPORT -OAK V T39007SM 2019-20 DBA System Maintenance 0.92 134.73 23004 0.92 134.73 23018 ORACLE SUPP-SHERIFF T39007SM 2019-20 DBA System Maintenance 1.75 234,36 23018 1.75 134.36 24004 SQL SERV SUPP-CLEMIS T39007SM 2019-20 DBA System Maintenance 8.78 1,126.06 24004 8.78 1,126.06 95430 CLMS MAINTENANCE DG9007SM 2019-20 CLEMIS Support Services 95430 98003 USER SUPPORT-L/E DG9007CS 2019-20 CLEMIS Support Services 0.25 41.25 98003 USER SUPPORT-L/E DJ8182PI G20CS Participant Implementation 0.25 24.75 98003 USER SUPPORT-L/E DJ9007CS 2019-20 eCommerce Customer Suppo 24.75 2,713.00 98003 25.25 2,779.00 36.70 4,174.15 PAGE 10 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 056 CLEMIS ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 63500 CLEMIS FUND DF718311A CLM-DataCntrapt-Implement 20.50 2,355.50 63500 CLEMIS FUND DF9183E2 CAN Enhancement Budget 3.25 536.25 63500 CLEMIS FUND D49183CE CLEMIS SEP Enhancements 23.00 3,052.00 63500 CLEMIS FUND D49010BB CLEMIS Enhancement Budgets 8.25 1,282.25 63500 CLEMIS FUND TP91B6IB CLEMIS New Site Implementation B 94.25 10,337.25 63500 CLEMIS FUND TT9007PR 2019-20 Problem Management 94.75 9,748.25 63500 244.00 27,311.50 244.00 27,312.50 PAGE 11 14.52.04 DJJ89SEZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 062 PANDEMIC PROGRAM - COVID-19 ACCT ACCT# DESCRIPTION PROJECT 17062 PANDEMIC PROGRAM - C DE9007CV 17062 PANDEMIC PROGRAM - C DH9181DI 17062 PANDEMIC PROGRAM - C TT0186RW 17062 PROJECT DESC COVTD-19 Customer Support COVID-19 IT Remote Work Options HOURS 49.50 2,529.00 95.00 2,673,50 2,673.50 TOTAL CHARGE 3,812.50 298,425.00 11,365.00 313,602.50 313,602.50 PAGE 12 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 067 WRC UTILITY BILLING REPLACEMEN ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 33067 WRC-UTILITY BILLING D5961INI WRC Northstar Replacement Phase 11.50 1,897.50 11.50 1,897.50 33067 11.50 1,897.50 PAGE 13 14.52.04 DJJ89SEZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 14 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 24.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 069 CLEMIS - TRAINING ACCT PROJECT TOTAL ACCT# ➢ESCRIPTION PROJECT DESC HOURS CHARGE 91069 CLEMIS TRAINING DG7183MI CLEMIS Michigan Indigent Defense 47.00 2,773.00 91069 47.00 2,773.00 47.00 2,773.00 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 080 FMO BLDG MGMT SYSTEMS REP PH 2 ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 21080 FM&O BLDG MGMT SYS R D19147BM FMO BMS - Implementation Phase 2 12.25 1,851.25 21080 12.25 1,851.25 12.25 1.851.25 PAGE 15 14.52.04 GAR LAND COUNTY - OCIT JOUPORTUINVOICEYQUARTERLY DJJ895EZ-02 SUMMARY FOR DEVELOPMENT JP 09/28/20 CHARGES FOR PERIOD OF SERVICES 06/27/2020 TARU 09/25/2020 CUSTOMER # 081 REDFORD TOWNSHIP PD PROJECT HOURS ACCT PROJECT DESC ACCT# DESCRIPTION 0.50 D19007OC Out County GSS Data Maintenance 0,50 12081 REDFORD TOWNSHIP GIS 12081 0.50 TOTAL CHARGE 73.00 73.00 73.00 PAGE 16 14.52.04 UNTING ACC OAy,LAND COUNTY - 'IT JOB PPOROTINVOICE Y4UARTERLY / DJJ895EZ-02 SUMMARY FOR DEVELOPMENT CHARGESOF 5 PTHRUD 09(28/20 6/27/20220 09/25/2020 CUSTOMER # 095 PONTIAC SEWER TOTAL PROJECT HOURS CHARGE ACCT DESCRIPTION DESC PROJECT 0 25 20.00 ACCT# - 20 WRC Development Hudget 2019 0.25 20.00 74095 PONTIAC SEWER D59611DS 20.00 74095 0,25 PAGE 17 14.52.04 DJJ89SEZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 18 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 14.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER it 113 MIDC CLEMIS DEV GRANT ACCT PROJECT TOTAL ACCT# ➢ESCRIPTION PROJECT DESC HOURS CHARGE 91113 MIDC CLEMIS DEV GRAN DG7183MI CLEMIS Michigan Indigent Defense 11.00 1,428.00 91113 11.00 1,428.00 21.00 1,428.00 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 19 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 14.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 115 UCC PROGRAM III - VOIP ACCT ACCT# DESCRIPTION PROJECT PROJECT DESC TOTAL HOURS CHARGE 92115 UCC PROGRAM III - VO TP0186PI UCC2 - VoIP Pilot Implementation 470.25 50,770.50 92115 UCC PROGRAM III - VO TP9186WS UCC2 - Wireless Expansion - Sury 58.50 8,42B.00 92115 528.75 59,198.50 528.75 59,198.50 DJJ89SEZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 20 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 14.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 119 HURON TOWNSHIP PD ACCT ACCT# DESCRIPTION PROJECT PROJECT DESC TOTAL HOURS CHARGE 12119 HURON TOWNSHIP GIS D D19007OC Out County GIS Data Maintenance 0.50 73.00 12119 0.50 73.00 0.50 73.00 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 120 HR-FINANCIAL SYSTEM REPLACEMEN ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 44120 HR-FINANCIAL SYS REP DA0151AC FHCM Configuration Tenant Build 581.25 62,474.00 44120 HR-FINANCIAL SYS REP DA0151CI FHCM Financial IS/Job Acct Integ 87.50 13,504.75 44120 HR-FINANCIAL SYS REP DA0151FI FHCM Financial Integrations (FCM 279.00 22,665.25 44120 HR-FINANCIAL SYS REP DA0151IM FROM Workday Implementation Plan 1,642.75 201,314.00 44120 HR-FINANCIAL SYS REP DA0151IN FHCM Mobile & Integrations Imple 324.00 45,277.25 44120 HR-FINANCIAL SYS REP DA0151R2 FHCM End-tc-End Round 2 Tenant B 15.50 2,349.00 44120 HR-FINANCIAL SYS REP DA0151TX FHCM ADP Employment Tax Implemen 50.75 6,657.50 44120 HR-FINANCIAL SYS REP DA9151FA FHCM Architect & Configurations 1,145.25 112,117.25 44120 HR-FINANCIAL SYS REP DA9151FC FHCM Financial Crosswalk Integra 61.50 8,667.25 44120 HR-FINANCIAL SYS REP DA91SIGB FHCM Gold Tenant (HCM) 555.75 55,633.75 44120 HR-FINANCIAL SYS REP DA91SICK FHCM Okta Implementation (HCM) 442.25 55,494.00 44120 HR-FINANCIAL SYS REP DA9151RE FHCM Report Development (FCM/HCM 268.25 22,701.50 44120 HR-FINANCIAL SYS REP DA9151RI FHCM Reports & Integrations Deve 42.25 4,731.75 44120 HR-FINANCIAL SYS REP DJ8151PM FHCM Program Management 577.25 51,377.00 44120 6,073.25 664,964.25 6.073.25 664,964.25 PAGE 21 14.52.04 DJJ89SEZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 121 WHO WEBSITE STANDARDIZATION ACCT PROJECT TOTAL ACCT# ➢ESCRIPTION PROJECT DESC HOURS CHARGE 33121 WHO WEBSITE STANDARD DE9182CL Citizen Engagement Budget - Land 19.75 1,872.75 1975. 1,872.75 33121 29.75 1,872.75 PAGE 22 14.52.04 DJJ89SEZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 125 HURON COUNTY CENTRAL DISPATCH ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 12500 HURON COUNTY GIS DAT D19007OC Out County GIS Data Maintenance 0.25 36.50 12500 0.25 36.50 0.25 36.50 PAGE 23 14.52.04 DJJ89SEZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 24 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 14.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 145 PROSECUTOR'S OFFICE ACCT ACCT# DESCRIPTION 24016 SQL SERV SUPP-PROSEC 24016 95622 PROS\EXECUTIVE 95622 PROS\EXECUTIVE 95622 95664 PROSECUTOR WARRANTS 95664 PROSECUTOR WARRANTS 95664 PROJECT TOTAL PROJECT DESC HOURS CHARGE T39007SM 2019-20 DBA System Maintenance 1.22 160.90 1.22 160.90 DB9007CS 2019-20 Courts Customer Support 79.50 7,689.00 DB9007SM 2019-20 Courts System Maintenanc 2.75 389.25 82.25 8,078.25 DB9182SE Courts Sizing Budget 0.08 9.80 DB9413GW Prosecutors GIF and Warrants Stu 170.25 18,743.00 170.33 18,752.80 253.80 26,991.95 DJJ89SEZ-02 OAKLAND COUNTY - OCIT JOR ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 168 WRC ORNERY ADMIN BLDG REHAB ACCT PROJECT ACCT# DESCRIPTION PROJECT DESC 33168 WRC CRWRRF ADMIN BLD D59611D5 WRC Development Budget 2019 - 20 33168 HOURS 3.00 3.00 3.00 TOTAL CHARGE 297.50 297.50 297.50 PAGE 25 14,52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 TERN 09/25/2020 CUSTOMER # 188 ECONONIC DEV & COMM AFFAIRS ACCT ACCT# DESCRIPTION PROJECT 98180 EDCA - ONE STOP SHOP DJ9007CS 98180 PROJECT DESC 2019-20 eCommerce Customer Suppo TOTAL HOURS CHARGE 3.25 536.25 3.25 536.25 3.25 536.25 PAGE 26 14.52.04 DJJ89SEZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 191 OAKLAND COUNTYSHERIFF-CLEMIS ACCT PROJECT ACCT# DESCRIPTION PROJECT DESC 23015 ORACLE SUPP-OCSD-CLE T39007SM 2019-20 DBA System Maintenance 23015 96163 SHERIFF - CLEMIS D49010E13 CLEMIS Enhancement Budgets 96163 HOURS 0.92 0.92 78.25 78.25 79.17 TOTAL CHARGE 134.73 134.73 11,961.25 11,961.25 12,095.98 PAGE 27 14.52.04 DJZ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 195 OCSD-CORRECTIVE SERV - ADMIN ACCT# 23009 23009 97163 97163 97163 97163 97163 98164 98164 98164 98164 98164 98164 98164 98164 98164 98164 ACCT PROJECT DESCRIPTION PROJECT DESC ORACLE SUPP-OCSD/CTS T39007SM 2019-20 BHA System Maintenance OCSD-CORRECTIVE SERV DE9183CM Citizen Engagement Budget - CLEM OCSD-CORRECTIVE SERV DG0433IA Inmate Locator Replacement OCSD-CORRECTIVE SERV DG9183TV OCSO CCTV Storage OCSD-CORRECTIVE SERV D59007CS 2019-20 Public & Environmental S CLEMIS - SHERIFF DF8007PM 2018-20 PSA Planned Maintenance CLEMIS - SHERIFF DF9007CS 2019-20 PSA Customer Support CLEMIS - SHERIFF DF9183SE CLEMIS Sizing Budget CLEMIS - SHERIFF DG0161HP OCSO Helicopter Video 2020 CLEMIS - SHERIFF DG8007PM 2018-20 CLEMIS Support Services CLEMIS - SHERIFF DG9007CS 2019-20 CLEMIS Support Services CLEMIS - SHERIFF DG9007SM 2019-20 CLEMIS Support Services CLEMIS - SHERIFF DG9183TV OCSO CCTV Storage CLEMIS - SHERIFF D49010EB CLEMIS Enhancement Budgets HOURS 0.42 0.42 11.25 33.00 0.50 16.62 61.37 1.00 1.00 2.75 46.75 14.50 201.00 25.00 66.00 6.00 364.00 TOTAL CHARGE 67.37 67.37 1,730.25 4,174.75 82.50 2,077.25 8,064.75 165.00 165.00 419.25 7,713.75 2,122.50 16,731.75 2,512.00 10, 890.00 976.75 41,696.00 425.79 49,828.22 PAGE 28 14.52.04 DJJ895EZ-02 OAKTAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 202 JAIL MANAGEMENT SYSTEM (JMS) ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 63202 JAIL MANAGEMENT SYST DG9183J1 CLEMIS Jail Management System Ph 385.50 33,766.00 63202 385.50 33,766.00 385.50 33,766.00 PAGE 29 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 203 WRC EU PUB ED ADM PROGRAMS ACCT ACCT# DESCRIPTION PROJECT PROJECT DESC TOTAL HOURS CHARGE 74203 NBC EU PUB ED ADM PR DE9182CL Citizen Engagement Budget - Land 1.50 103.50 74203 1.50 103.50 1.50 103.50 PAGE 30 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 208 UMICH-POPULATION STUDIES CTR ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 12208 CJAR DATA TRANSFER DB9010EB Courts Justice Administration En 14.00 2,261.00 12208 14.00 2,261.00 14.00 2,261.00 PAGE 31 14.52.04 DJJ89SEZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/26/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 210 FIRE RECOR➢S MGMT FUND 531 ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 24001 SQL SERV SUPP-FIRE R T39007SM 2019-20 DBA System Maintenance 1.22 160.90 24001 1.22 160.90 95404 HEMS - PHASE II PROJ DF9183SB CLEMIS Sizing Budget 2.75 332.75 95404 FRMS - PHASE TI PROJ D49183E1 CFIRS Enhancement Budget 166.25 16,772.25 95404 169.00 17,105.00 170.22 27,265,90 PAGE 32 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 33 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 14.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER #} 214 IAM PROGRAM ACCT ACCT#{ DESCRIPTION 21400 TAM PROGRAM 21400 IAM PROGRAM 21400 PROJECT PROJECT DESC TT9186P2 IAM Implementation-App Integrati TT9186P3 IAM Implementation - Phase 3 TOTAL HOURS CHARGE 472.75 59,454.75 1.50 247.50 474.25 59,702.25 474.25 59,702.25 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 255 ORACLE UPGRADE TO 19C ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 63255 ORACLE UPGRADE TO 19 DF91830B Upgrade Oracle 11G database to 1 114.35 18,071.50 63255 114.35 18,071.50 114.35 18,071.50 PAGE 34 14.52.04 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM D-02 JJ895EZ JJ895EZ SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 09/28/20 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 269 LAPEER COUNTY CENTRAL DISPATCH PROJECT ACCT# ACCT DESCRIPTION PROJECT DESC HOURS 12269 LAPEER CTY CIS DATA D19007OC Out 0.50 County GIS Data Maintenance 0.50 12269 0.50 TOTAL CHARGE 73.00 73.00 73.00 PAGE 35 14.52.04 DJJ89SEZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/202D THRU 09/25/2020 CUSTOMER # 284 ST CLAIR COUNTY GIS DATA SVCS ACCT PROJECT ACCT# DESCRIPTION PROJECT DESC 12284 ST CLAIR COUNTY GIS D19007OC Out County GIS Data Maintenance 12284 TOTAL HOURS CHARGE 1.25 182.50 1.25 182.50 1.25 182.50 PAGE 36 24.52. 04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 37 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 24.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 294 WRC - SEWER FUND ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 74294 NBC - SEWER FUND D99182SB Land Sizing Budget 5.75 948.75 74294 5.75 948.75 5.75 948.75 DJO895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 338 IMAGING PROGRAM ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 33800 IMAGING PROJECT DE6312PM Imaging Program Management 21.75 3,061.00 33800 IMAGING PROJECT DE7182CT Imaging Program - Clerk, Circuit 206.25 30,247.7-9 33800 IMAGING PROJECT DE7182HR Imaging Program - Human Resource 2.00 224.00 33800 IMAGING PROJECT ➢B7182IC Imaging Program - Integrate Imag 0.25 41.25 33800 IMAGING PROJECT DE7182MF Imaging Program - Medical Examin 54.00 6,752.00 286.25 40,326.00 33800 286.25 40,326.00 PAGE 38 14.52.04 DJJ89SEZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 349 OCSD ADMIN SERV-RECORDS MGMT ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 97349 OCSD ADMIN SERV-RECO DJ9007CS 2019-20 eCommerce Customer Suppo 1.00 165.00 1.00 165.00 97349 1.00 165.00 PAGE 39 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 430 CORPORATION COUNSEL ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 95501 CORPORATION COUNSEL DJ9007CS 2019-20 eCommerce Customer Suppo 110.50 14,586.00 95501 CORPORATION COUNSEL DJ9007SM 2019-20 eCommerce System Mainten 11.75 1,938.75 95501 CORPORATION COUNSEL DJ9010ED Finance/Admin Enhancement Budget 130.50 17,539.50 95501 252.75 34,064.25 252.75 34,064.25 PAGE 40 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 440 CLERK/REG - ELECTIONS DIVISION ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 95443 CLERK/REG - ELECTION DB9007CS 2019-20 Courts Customer Support 40.50 5,352.25 95443 CLERK/REG - ELECTION DE9182CC Citizen Engagement Budget - Cour 15.00 1,449.75 95443 55.50 6,802.00 55.50 6,802.00 PAGE 41 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 445 SUPPORT SERVICES ADMIN ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 23002 ORACLE SUPPORT-SUPP T39007SM 2019-20 DBA System Maintenance 0.92 134.73 0.92 134.73 23002 24011 SQL SERV SUPP-SUPPOR T39007SM 2019-20 DBA System Maintenance 2.52 321.72 2.52 321.72 24011 44500 SUPPORT SERVICES USE DJ9007CS 2019-20 eCommerce Customer Suppo 4.25 582.00 44500 SUPPORT SERVICES USE DJ9182SE Finance/Admin Sizing Budget 14.75 2,093.75 44500 19.00 2,675.75 22.44 3,132.20 PAGE 42 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 448 CLEMIS/FRMS NON -BILLABLE ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 44800 CLEMIS/FRMS NON -BILL D49183MO CFIRS Mobile Pages 120.25 12,421.50 44800 120.25 12,421.50 120.25 12,421.50 PAGE 43 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 470 CTS-FOC EXP-FAM COUNSELING ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 34041 CTS-FOC-FAM COUNSELI DB9182SB Courts Sizing Budget 0.75 87.00 34041 0.75 87.00 92195 CTS-FOC-FAM COUNSELI DB9182SB Courts Sizing Budget 2.00 232.00 92195 2.00 232.00 2.75 319.00 PAGE 44 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 483 CTS-FD-JUDICIAL SUPPORT -ADM ACCT PROJECT ACCT# DESCRIPTION PROJECT DESC 24009 SQL SERV SUPP-CTS-JU T39007SM 2019-20 DBA System Maintenance 24009 TOTAL HOURS CHARGE 1.22 160.90 1.22 160.90 1.22 160.90 PAGE 45 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 490 CTS-FD-CT SERVICES -CLINIC ACCT ACCT# DESCRIPTION PROJECT 95171 CTS-CT SERV-CLINIC DB9182SE 95171 PROJECT DESC Courts Sizing Budget TOTAL HOURS CHARGE 4.75 587.75 4.75 587.75 4.75 587.75 PAGE 46 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 493 CTS-JUDICIAL ADMIN ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 95174 CTS-JUDICIAL ADMIN-E DB0314JS Circuit Court Judge Switch 2020 39.75 5,089.25 95174 CTS-JUDICIAL ADMIN-E DE9007SM 2019-20 Courts System Maintenanc 24.75 2,983.43 95174 CTS-JUDICIAL ADMIN-E DE9182SB Courts Sizing Budget 4.25 529.00 95174 CTS-JUDICIAL ADMIN-E TT9007PR 2019-20 Problem Management 2.80 345.80 95174 CTS-JUDICIAL ADMIN-E T39007SM 2019-20 DBA System Maintenance 0.14 23.10 95174 71.69 8,970.58 71.69 8,970-58 PAGE 47 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 498 CTS-GEN JURIS-JUDICAL SUPPT ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 23010 ORACLE SUPP-CCT/CTS T39007SM 2019-20 DBA System Maintenance 0.42 67.37 23010 0.42 67.37 95179 CTS-GJ-GENERAL SUPPT DE9007CS 2019-20 Courts Customer Support 908.75 103,460.25 95179 CTS-GJ-GENERAL SUPPT DE9007SM 2019-20 Courts System Maintenanc 40.75 5,779.50 95179 CTS-GJ-GENERAL SUPPT DB9010EB Courts Justice Administration En 93.25 12,574.75 95179 CTS-GJ-GENERAL SUPPT DB9212CS Case Management System Evaluatio 38.10 4,520-52 95179 CTS-GJ-GENERAL SUPPT DB9312CE CMO Case Evaluation Rewrite 239.50 21,716.25 95179 CTS-GJ-GENERAL SUPPT DE9312JR JOS Replacement 248.25 31,996-50 95179 CTS-GJ-GENERAL SUPPT DE9182CC Citizen Engagement Budget - Cour 5.00 730.00 95179 CTS-GJ-GENERAL SUPPT DJ9007CE 2019-20 eCommerce Customer Suppo 95179 1,573.60 180,777-77 1,574.02 180,845.14 PAGE 48 14.52. 04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 49 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 14.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 501 WRC PERMITTING IMPL ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 74502 WRC PERMITTING IMPL D59611D5 WRC Development Budget 2019 - 20 4.50 742.50 4.50 742.50 74502 4.50 742.50 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 502 CTS-GJ-JURY OPERATIONS ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 23008 ORACLE SUPPORT-CTS-G T39007SM 2019-20 DBA System Maintenance 0.92 134.73 23008 0.92 134.73 0.92 134.73 PAGE 50 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 506 CTS-FAM DIV-JUDICIAL SUPPT ACCT ACCT# DESCRIPTION PROJECT 95195 CIR CRT ADMIN DB9182SB 95195 PROJECT DESC Courts Sizing Budget TOTAL HOURS CHARGE 12.00 1,470.00 1200.1,470.00 12.00 1,470.00 PAGE 51 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 507 CTS-FCC EXP-CS ENFORCEMENT ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 34044 CTS-FOC-CS ENFORC-IM DE9182SB Courts Sizing Budget 0-25 28.00 34044 0.25 28.00 65410 FCC -IMAGE REPLACE-74 DE9182SB Courts Sizing Budget 5-00 580.00 65410 5.00 580.00 92193 CTS-FCC-CS ENFORC-DE DB9007CS 2019-20 Courts Customer Support 156.75 17,702.75 92193 CTS-FOC-CS ENFORC-DE DB9010E8 Courts Justice Administration En 59-25 9,078.00 92193 CTS-FOC-CS ENFORC-DE DF9182CC Citizen Engagement Budget - Cour 61.25 5,818.75 92193 CTS-FOC-CS ENFORC-DE DJ9007CS 2019-20 eCommerce Customer Snppo 1-25 123.75 92193 278.50 32,723.25 92194 CTS-FCC-CS ENF-EDMS DB9007SM 2019-20 Courts System Maintenanc 24.75 2,983.43 92194 CTS-FOC-CS ENF-EDMS TT9007PR 2019-20 Problem Management 2.80 345-80 92194 CTS-FOC-CS ENF-EDMS T39007SM 2019-20 DBA System Maintenance 0.14 23.10 92194 27.69 3,352.33 311-44 36,683.56 PAGE 52 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 508 BOC-LEGAL RESOURCE CENTER ACCT ACCT# DESCRIPTION PROJECT 91405 LIBRARY BOARD DJ9007CS 91405 PROJECT DESC 2019-20 eCommerce Customer Suppo TOTAL HOURS CHARGE 2.25 371.25 2.25 371.25 2.25 371.25 PAGE 53 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/202D THRU 09/25/2020 CUSTOMER # 510 PROB-EST/MENTL HLTH SUPPORT ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 24010 SQL SERV SUPP-PCT-ES T39007SM 2019-20 DBA System Maintenance 1.22 160.90 24010 1.22 160.90 92198 PC-E/MH SUPPORT-DEV D89007CS 2019-20 Courts Customer Support 143.25 14,369.25 92198 PC-E/MH SUPPORT-DEV DB9007SM 2019-20 Courts System Maintenanc 2.00 198.00 92198 PC-E/MH SUPPORT-➢EV DB9010EB Courts Justice Administration En 8.50 904.75 92198 PC-E/MH SUPPORT-DEV DB9182SB Courts Sizing Budget 7.50 879.75 92198 PC-E/MH SUPPORT-DEV DJ9007CS 2019-20 eCommerce Customer Suppo 0.75 74.25 92198 162.00 16,426.00 163.22 16,586.90 PAGE 54 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 TRRU 09/2S/2020 CUSTOMER # 512 PROD-EST/MENTL HLTH EDMS (IMG) ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 95207 PC-E/MH EDMS SUPPORT DR9007SM 2019-20 Courts System Maintenanc 24.75 2,983.43 95207 PC-E/MH EDMS SUPPORT TT9007PR 2019-20 Problem Management 2-80 345.80 95207 PC-E/MI4 EDMS SUPPORT T39007SM 2019-20 DBA System Maintenance 0.14 23.10 95207 27-69 3,352.33 27.69 3,352.33 PAGE 55 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 56 09/28/20 SUMMARY FOR ➢EVELOPMENT / SUPPORT INVOICE QUARTERLY 14.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 521 COMM CORR-ADM (GRANT) ACCT PROJECT ACCT# DESCRIPTION PROJECT DESC 52100 COMM CORR ADMIN - GR ➢B9010RB Courts Justice Administration En 52100 COMM CORR ADMIN - OR DE9120ER Mandates EB 52100 TOTAL HOURS CHARGE 44.00 5,846.25 3.00 446.00 47.00 6,292.25 47.00 6,292.25 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 57 09128120 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 14.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 522 COMM CORR-ADM (COUNTY) ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 23003 ORACLE SUPPORT-COMM T39007SM 2019-20 DBA System Maintenance 0.92 134.73 23003 0.92 134.73 24022 SQL SERV SUPP-COMM C T39007SM 2019-20 TEA System Maintenance 1.22 160-90 24012 1.22 160.90 52200 COMM CORR-ADMIN (COU D139007CS 2019-20 Courts Customer Support 155.00 19,104.75 52200 COMM CORR-ADMIN (COU DE9007SM 2019-20 Courts System Maintenanc 25.25 4,166.25 52200 COMM CORR-ADMIN (COU DB9182SB Courts Sizing Budget 7.75 899.00 52200 188.00 24,170.00 190.14 24,465.63 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 58 09/2B/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 14.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 530 52/4 TROY ACCT ACCT# DESCRIPTION PROJECT 95530 DIST CT SUPP - 250 5 DE9007CS 95530 DIST CT SUPP - 25% 5 DE9007SM 95530 DIST CT SUPP - 25e 5 DE9182SB 95530 PROJECT DESC 2019-20 Courts Customer Support 2019-20 Courts System Maintenanc Courts Sizing Budget TOTAL HOURS CHARGE 35.01 3,756.75 2.70 416.55 0.74 79.75 38.45 4,253.05 38.45 4,253.05 DJJ895EZ-02 OAYLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 540 52/1 - NOVI ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 95527 DIST CT SUPP - 25% 5 DE9007CS 2019-20 Courts Customer Support 33.58 3,757.00 95527 DIST CT BURP - 25% 5 DB9007SM 2019-20 Courts System Maintenanc 2.60 416.65 95527 DIST CT SUPP - 25% 5 DB9162SB Courts Sizing Budget 0.67 79.75 95527 36.85 4,253.40 36.85 4,253.40 PAGE 59 14.52.04 DJJ695EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 60 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 14.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 550 S2/2 CLARKSTON ACCT PROJECT ACCT# DESCRIPTION PROJECT DESC 95528 DIST CT SUPP - 25e 5 DE9007CS 2019-20 Courts Customer Support 95528 DIST CT SUPP - 25e 5 DB9007SM 2019-20 Courts System Maintenanc 95528 DIST CT SUPP - 25% 5 DP9182SB Courts Sizing Budget 95528 TOTAL HOURS CHARGE 33.58 3,757.00 2.60 416.65 0.67 79.75 36.85 4,253.40 36.B5 4,253.40 DJJ89SEZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 560 52/3 ROCHESTER ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 95529 DIST CT SUPP - 25s 5 DB9007CS 2019-20 Courts Customer Support 33.58 3,757.00 95529 DIST CT SUPP - 25% 5 DB9007SM 2019-20 Courts System Maintenanc 2.60 416.65 95529 DIST CT SUPP - 25e 5 DB9182SB Courts Sizing Budget 0.67 79.75 95529 36.85 4,253.40 36.85 4,253.40 PAGE 61 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 565 MARKETING ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 56500 MARKETING & COMMUNIC DE9182CF Citizen Engagement Budget - Fina 1.75 120.75 56500 1.75 220.75 1.75 120.75 PAGE 62 14,52.04 DJJ895EZ-D2 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 63 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 24.52,04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 600 TREASURERS OFFICE ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 23006 ORACLE SUPPORT -DEL T T39007SM 2019-20 DBA System Maintenance 0.92 134.73 23006 0.92 134.73 23016 ORACLE SUPP-TREASURE T39007SM 2019-20 DBA System Maintenance 1.86 269.40 23016 1.86 269.40 36602 LAND SYSTEM ENHANC - D9902ORB Land Enhancement Budgets 8.76 890.99 36602 LAND SYSTEM ENBANC - D99125MB AAT Mandate Program Budget 2019- 67.38 7,857.00 36602 LAND SYSTEM ENHANC - ➢99182DB BS&A Development Budget 2019-202 2.28 371.22 36602 LAND SYSTEM ENHANC - D99182SE Land Sizing Budget 3.40 446.85 36602 81.82 9,566.06 36702 LAND SYSTEM MAINT - D99007SM 2019-20 Assessing & Tax System 28.16 4,356.22 36702 28.16 4,356.22 36802 LAND SYSTEM SUPPORT D99007CS 2019-20 Assessing & Tax Customer 25.53 2,850.61 36802 25.53 2,850.61 44061 TRE-SYSTEM/CUSTOMER DB9007CS 2019-20 Courts Customer Support 59,75 6,529.75 44061 TRE-SYSTEM/CUSTOMER DB9007SM 2019-20 Courts System Maintenanc 24,75 2,983.43 44061 TRE-SYSTEM/CUSTOMER DJ9007CS 2019-20 eCommerce Customer Suppo 134.2E 17,296.00 44061 TRE-SYSTEM/CUSTOMER D19007CS 2019-20 Infrastructure & GIS Cus 0.50 82.50 44061 TRE-SYSTEM/CUSTOMER D99007CS 2019-20 Assessing & Tax Customer 46.00 6,372.00 44061 TRE-SYSTEM/CUSTOMER TT9007PR 2019-20 Problem Management 2.80 345.80 44061 TRE-SYSTEM/CUSTOMER T39007SM 2019-20 DBA Svstem Maintenance 0.14 23.10 44061 268.19 33,632.58 44062 TRE-SYSTEM MAINTENAN DJ9007SM 2019-20 eCommerce System Mainten 5.75 948.75 44062 TRE-SYSTEM MAINTENAN D99007SM 2019-20 Assessing & Tax System 6.00 892.50 44062 11.75 1,841.25 44063 TRE-SYSTEM ENHANCEME D99010EB Land Enhancement Budgets 10.00 1,094.00 44063 10.00 1,094.00 44064 TRE-NEW DEVELOPMENT DJ9182SE Finance/Admin Sizing Budget 37.00 5,599.00 44064 TRE-NEW DEVELOPMENT D99182SB Land Sizing Budget 5.50 841.50 44064 42.50 6,440.50 DJJ89SEZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 64 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 24.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 600 TREASURERS OFFICE ACCT ACCT# DESCRIPTION PROJECT 50102 TREAT (BS&A ANNUAL P D99182DR 50102 TREAS (BS&A ANNUAL P D99182SE 50102 91001 TREASURER'S-25% D99182SE 91001 95008 DEL TAX ON LINE T39007SM 95008 95561 USER SUPPORT/DEL TAX D99007CS 95561 PROJECT TOTAL DESC HOURS CHARGE BS&A Development Budget 2019-202 10.25 1,398.75 Land Sizing Budget 1.50 214.50 11.75 1,613.25 Land Sizing Budget 1.60 204.88 1.60 204.88 2019-20 DBA System Maintenance 9.00 1,4B5.00 9.00 1,485.00 2019-20 Assessing & Tax Customer 44.25 7,122.50 44.25 7,122.50 537.33 70,610.98 ➢JJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 630 ANIMAL CONTROL DIV ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 24017 SQL SERV SUPP-ANIMAL T39007SM 2019-20 DBA System Maintenance 1.22 160.90 24017 1.22 I60.90 95628 ANIMAL CONTROL DB9010EP Courts Justice Administration En 1.00 132.00 95628 ANIMAL CONTROL D19007CS 2019-20 Infrastructure & GIS Cus 1.50 247.50 95628 ANIMAL CONTROL D99178PL Animal Control OPLS Replacement 97.00 11,838.25 95628 99.50 12,217.75 95682 DOG SYSTEM DJ9007CS 2019-20 eCommerce Customer Suppo 7.00 2,065.75 95682 DOG SYSTEM ➢99007CS 2019-20 Assessing & Tax Customer 95.50 11,435.75 95682 DOG SYSTEM D99007SM 2019-20 Assessing & Tax System 21.25 2,391.75 95682 123.75 14,893.25 224.47 27,271.90 PAGE 65 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 650 REIMBURSEMENT DIV ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 95470 REIM SYSTEM DB9007CS 2019-20 Courts Customer Support 32.25 2,579.25 95470 REIM SYSTEM DJ9007CS 2019-20 eCommerce Customer Suppo 6.25 936.75 95470 37.50 3,516.00 95542 REIMBURSE USER SUPT DB9007SM 2019-20 Courts System Maintenanc 14.75 1,198.25 95542 14.75 1,198.25 52.25 4,714.25 PAGE 66 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 653 O.C. INTN'L AIRPORT ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 65301 AIRPORT USER SUPPORT D59007CS 2019-20 Public & Environmental S 46.75 7,713.75 65301 46.75 7,723.75 65310 O.C. AIRPORT - NEW D D99162SB Land Sizing Budget 0.50 82.50 65310 0.50 82.50 47.25 7,796.25 PAGE 67 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/202D TERN 09/25/2020 CUSTOMER # 656 WATER RESOURCES ACCTG ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 23011 ORACLE SUPP-WATER & T39007SM 2019-20 DBA System Maintenance 0.92 134.73 23011 0.92 134.73 95669 WATER RESOURCES ACCT D59007CS 2019-20 Public & Environmental S 9.50 2,567.50 95669 WATER RESOURCES ACCT D59007SM 2019-20 Public & Environmental S 3.50 379.50 95669 WATER RESOURCES ACCT T39007SM 2019-20 DBA System Maintenance 14.50 2,308.50 95669 27.50 4,255.50 28.42 4,390.23 PAGE 68 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 660 FISCAL SERVICES-GEN FUND ACCT# 23001 23001 23013 23013 24006 24006 44021 44021 44021 44024 44024 96001 96002 96001 96001 96001 96003 96003 96003 96003 96003 ACCT PROJECT DESCRIPTION PROJECT DESC ORACLE SUPPORT-FISCA T39007SM 2019-20 DBA System Maintenance ORACLE SUPP-HR-ACCTG T39007SM 2019-20 DBA System Maintenance SQL SERV SUPP-HR-ACC FS-SYSTEM/CUSTOMER S FS-SYSTEM/CUSTOMER S FS-NEW DEVELOPMENT FISCAL SRV - ACCTG FISCAL SRV - ACCTG FISCAL SRV - ACCTG FISCAL SRV - ACCTG FISCAL SRV - BUDGET FISCAL SRV - BUDGET FISCAL SRV - BUDGET FISCAL SRV - BUDGET T39007SM 2019-20 DBA System Maintenance DA9007CS 2019-20 HR Finance Customer Supp DJ9007CS 2019-20 eCommerce Customer Suppo DJ9182SE Finance/Admin Sizing Budget DA9007CS 2019-20 HR Finance Customer Supp ➢B9007CS 2019-20 Courts Customer Support DJ9010EB Finance/Admin Enhancement Budget T39007SM 2019-20 DBA System Maintenance DA9007CS 2019-20 HR Finance Customer Supp DB9007CS 2019-20 Courts Customer Support DJ9010EB Finance/Admin Enhancement Budget T39007SM 2019-20 DBA System Maintenance TOTAL HOURS CHARGE 2.83 404.13 2.83 404.13 0.92 134.73 0.92 134.73 0.55 80.46 0.55 80.46 58.50 8,690.50 0.25 24.75 58.75 8,715.25 0.75 123.75 0.75 123.75 14.20 2,126.30 11.90 1,369.50 6.20 818.60 0.60 99.00 32.90 4,413.40 7.10 1,063.15 5.95 684.75 3.10 409.30 0.30 49.50 16.45 2,206.70 113.15 16,078.42 PAGE 69 a 4.52, 04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 665 CHILDRENS VILLAGE ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 95665 CHILDRENS VILLAGE DE9007CS 2019-20 Courts Customer Support 0.25 41.25 95665 CHILDRENS VILLAGE DB9007SM 2019-20 Courts System Maintenanc 0.25 41.25 95665 CHILDRENS VILLAGE D29182SB Courts Sizing Budget 1.50 247.50 95665 CHILDRENS VILLAGE 059007CS 2019-20 Public & Environmental S 99.46 14,670.25 101.46 15,000.25 95665 101.46 15,000.25 PAGE 70 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 71 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 14.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 672 ASSESSMENT & TAX ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 67200 ASSESSMENT & TAX D99125BU BSA AWS Server Upgrade 18.50 2,232.00 67200 18.50 2,232.00 18.50 2,232.00 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 72 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 14.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THEN 09/25/2020 CUSTOMER # 680 HUMAN RESOURCES ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 23014 ORACLE SUPP-HR-PERSO T39007SM 2019-20 DBA System Maintenance 0.92 134.73 23014 0.92 134.73 24007 SQL SERV SUPP-HR-PER T39007SM 2019-20 DBA System Maintenance 0.55 80.46 24007 0.55 80.46 96002 HUMAN RES - PERSONNE DA9007CS 2019-20 HR Finance Customer Supp 14.20 2,126.30 96002 HUMAN RES - PERSONNE DB9007CS 2019-20 Courts Customer Support 11.90 1,369.50 96002 HUMAN RES - PERSONNE DB9007SM 2019-20 Courts System Maintenanc 25.14 2,983.04 96002 HUMAN RES - PERSONNE DE9182EE Employee Engagement Budget 31.50 3,089.25 96002 HUMAN RES - PERSONNE DE9182SE eGovernment Sizing Budget 1.00 165.00 96002 HUMAN RES - PERSONNE DJ9010EB Finance/Admin Enhancement Budget 6.20 818.60 96002 HUMAN RES - PERSONNE TT9007PR 2019-20 Problem Management 2.80 345.80 96002 HUMAN RES - PERSONNE T39007SM 2019-20 DBA System Maintenance 0.74 122.10 96002 93.48 11,019.59 94.95 11,234.78 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 690 PURCHASING ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 44029 PUR-NEW DEVELOPMENT DJ8112PS Procurement Solution 13.00 1,402.50 44029 13.00 1,402.50 13.00 1,402.50 PAGE 73 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 695 RISK MANAGEMENT ACCT PROJECT ACCT# DESCRIPTION PROJECT DESC HOURS 44036 RSK-SYSTEM/CUSTOMER DJ9007CS 2019-20 eCommerce Customer Suppo 96.75 44036 RSK-SYSTEM/CUSTOMER DJ9007SM 2019-20 eCommerce System Mainten 1.25 44036 96.00 TOTAL CHARGE 12,531.75 206.25 12,738.00 98.00 12,738.00 PAGE 74 14.52, 04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOE ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 710 MSU EXTENSION - OAKLAND ACCT ACCT# DESCRIPTION PROJECT 95676 MSU EXT EQUIPMENT MA DJ9007CS 95676 PROJECT DESC 2019-20 eCommerce Customer Suppo TOTAL HOURS CHARGE 0.25 41.25 0.25 41.25 0.25 41.25 PAGE 75 24.52.04 DJJ89SEZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 76 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 14.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 718 CLERK/REG - E-SERVICES ACCT ACCT# DESCRIPTION PROJECT PROJECT DESC TOTAL HOURS CHARGE 71800 E-SERVICES DB9120EB Mandates EB 6.50 728.00 71800 6.50 728.00 6.50 728.00 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 719 CLERK/ROD AUTOMATION FUND ACCT ACCT# DESCRIPTION PROJECT 95719 REGISTER OF DEEDS AU D99214RD 95719 PROJECT DESC Land Records and Super Index Rep TOTAL HOURS CHARGE 13.00 1,694.00 13.00 1,694.00 13.00 1,694.00 PAGE 77 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 78 09/26/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 14.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 720 CLERK/REG - ROD ACCT# 24003 24003 36511 36511 36511 95498 95498 ACCT DESCRIPTION PROJECT SQL SERV SUPP-ROD T39007SM ROD APPLICATION/HW S D19007CS ROD APPLICATION/HW S D99007CS CLERK/REG - ROD DJ9007CS PROJECT DESC 2019-20 DEA System Maintenance 2019-20 Infrastructure & GIS Cus 2019-20 Assessing & Tax Customer 2019-20 eCommerce Customer Suppo HOURS 1.22 1.22 8.25 5.75 14.00 6.50 6.50 olmm" TOTAL CHARGE 160.90 160.90 1,361.25 794.75 2,156.00 868.75 868.75 3.185.65 DJJ895BZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 722 CLERK/REG - EDMS (IMAGING) ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 95158 CLERK/REG-EDMS SPT/M DB9007SM 2019-20 Courts System Maintenanc 28.36 3,409.56 95158 CLERK/REG-EDMS SPT/M TT9007PR 2019-20 Problem Management 3.20 395.20 95158 CLERK/REG-EDMS SPT/M T39007SM 2019-20 DBA System Maintenance 0.16 26.40 95158 31.72 3,831.16 31.72 3,831.16 PAGE 79 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 723 CLERK/REG - VITAL STATISTICS ACCT PROJECT ACCT# DESCRIPTION PROJECT DESC 24015 SQL SERV SUPP-VITAL T39007SM 2019-20 IRA System Maintenance 24015 95162 CLERK/REG - VITAL ST D139007CS 2019-20 Courts Customer Support 95161 CLERK/REG - VITAL ST DB9007SM 2019-20 Courts System Maintenanc 95161 CLERK/REG - VITAL ST DB9182SB Courts Sizing Budget 95161 TOTAL HOURS CHARGE 1,22 160.90 1,22 160.90 139.50 17,303.25 2.50 412.50 10.51 1,244.25 152.51 18,960.00 153.73 19,120.90 PAGE 80 14.52.04 DJJ89SEZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 724 CLERK/REG - LEGAL RECORDS ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 95170 CLERK/REG - LEGAL RE DR9120EB Mandates ER 85.25 9,427.75 95170 85.25 9,427.75 95189 CLERK LEGAL RECORDS DB9007CS 2019-20 Courts Customer Support 276.75 33,828.25 95189 CLERK LEGAL RECORDS BB9007SM 2019-20 Courts System Maintenanc 2.00 198.00 95189 CLERK LEGAL RECORDS DB9010EB Courts Justice Administration En 103.00 14,550.50 95189 CLERK LEGAL RECORDS 0139182SB Courts Sizing Budget 6.74 782.50 95189 CLERK LEGAL RECORDS DB9212CS Case Management System Evaluatio 38.15 4,520.48 95189 426.64 53,879.73 511.89 63,307.48 PAGE 81 14.52.04 JJ895EZ OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM D-02 JJ895EZ SUWIARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 09/28/20 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 726 CLERK/REG - MICROGRAPHICS PROJECT TOTAL ACCT DESC HOURS CHARGE ACCT# DESCRIPTION PROJECT 4.90 614.62 91002 ROD-75% D99182SB Land Sizing Budget 4 90 614.62 91002 4.90 614.62 PAGE 62 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 TEED 09/25/2020 CUSTOMER # 730 WATER RESOURCE COMMISSION ACCT# ACCT DESCRIPTION PROJECT PROJECT DESC TOTAL HOURS CHARGE 24008 SQL SERV SUPP-WRC T39007SM 2019-20 DBA System Maintenance 1.22 24008 160.90 1.22 160.90 28010 WRC-CUSTOMER SUPPT D19007CS 2019-20 Infrastructure & GIS Cus 57.75 9,486.75 28010 WRC-CUSTOMER SUPPT D59007CS 2019-20 Public & Environmental S 49.00 7,832.50 28010 WRC-CUSTOMER SUPPT D59007SM 2019-20 Public & Environmental S 1.25 162.75 28010 108.00 17,482.00 28022 WRC CUSTOM APPLICATI D59611D5 WRC Development Budget 2019 - 20 31.25 3,960.00 28011 31.25 3,960.00 36520 GIS IMPLEMEN SUPPORT D19007CS 2019-20 Infrastructure & GIS Cus 36520 10.75 1,773.75 10.75 1,773.75 36521 WRC PROGRAM SUPPORT D59007CS 2019-20 Public & Environmental S 157.50 25,987.50 36521 257.50 25,987.50 308.72 49,364.15 PAGE 83 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 731 WATER RESOURCE - EQUIPMENT ACCT PROJECT ACCT# ➢ESCRIPTION PROJECT DESC 74501 WATER RESOURCES - OR D5961IDS NBC Development Budget 2019 - 20 74501 TOTAL HOURS CHARGE 2,50 412.50 2,50 412.50 2.50 412.50 PAGE 84 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOE ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 734 WRC - AMR SUPPORT ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT ➢EST HOURS CHARGE 73401 WRC - AMR SUPPORT D59007CS 2019-20 PubliC & Environmental S 0.50 82.50 0.50 82.50 73401 0.50 82.50 PAGE 85 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 740 EQUALIZATION ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 23012 ORACLE SUPP-EQUALIZA T39007SM 2019-20 DBA System Maintenance 0.92 134.73 23012 0.92 134.73 24005 SQL SERV SUPP-EQUALS T390079M 2019-20 DBA System Maintenance 3.74 482.62 24005 3.74 482.62 31075 EQUAL -DEVELOPMENT D99182SB Land Sizing Budget 9.75 1,278.75 31075 9.75 1,278.75 36505 CIS IMPLEMEN SUPPORT D19007CS 2019-20 Infrastructure & GIS Cus 2.50 412.50 36505 2.50 412.50 36506 EQUAL APPLICATION/HW D99007CS 2019-20 Assessing & Tax Customer 60.50 7,294.75 36506 EQUAL APPLICATION/HW D99007SM 2019-20 Assessing & Tax System 3.25 352.75 36506 63.75 7,647.50 36507 EQUAL LAMS SUPPORT/M D99007CS 2019-20 Assessing & Tax Customer 43.75 4,600.00 36507 EQUAL LAMS SUPPORT/M D99007SM 2019-20 Assessing & Tax System 32.75 3,453.75 36507 76.50 8,053.75 36601 LAND SYSTEM ENHANC - D99010ER Land Enhancement Budgets 8.74 891.01 36601 LAND SYSTEM ENHANC - D99125ME AAT Mandate Program Budget 2019- 67.12 7,857.25 36601 LAND SYSTEM ENHANC - D99182DE BS&A Development Budget 2019-202 2.22 371.28 36601 LAND SYSTEM ENHANC - D99182SB Land Sizing Budget 3.35 446.90 36601 81.43 9,566.44 36701 LAND SYSTEM MAINT - D99007SM 2019-20 Assessing & Tax System 28.09 4,356.28 36701 28.09 4,356.28 36801 LAND SYSTEM SUPPORT D99007CS 2019-20 Assessing & Tax Customer 25.47 2,850.64 36801 25.47 2,850.64 50101 EQUAL (BS&A ANNUAL P D99182DB BS&A Development Budget 2019-202 10.25 1,398.75 50101 EQUAL (BS&A ANNUAL P D99182SB Land Sizing Budget 1.50 214.50 50101 11.75 1,613.25 95699 BS&A MASTER APPRAISA D99007CS 2019-20 Assessing & Tax Customer 223.75 26,743.00 95699 223.75 26,743.00 PAGE 86 14.52.04 DJJ89SEZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 87 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 14.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU O9/25/2020 CUSTOMER # 740 EQUALIZATION ACCT ACCT# DESCRIPTION PROJECT PROJECT DESC HOURS 527.65 TOTAL CHARGE 63.139.46 DJJ89SEZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 88 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 14.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 750 F M & O ACCT ACCT# DESCRIPTION 21001 FAC MAINT & OPER 21001 24013 SQL SERV SUPP-FM&O 24013 75503 FMO DEVELOPMENT 75503 FMO DEVELOPMENT 75503 FMO DEVELOPMENT 75503 FMO DEVELOPMENT 75503 PROJECT TOTAL PROJECT DESC HOURS CHARGE D59007CS 2019-20 Public & Environmental S 1.46 240.25 1.46 240.25 T39007SM 2019-20 DBA System Maintenance 1.22 160.90 1.22 160.90 D10147CE FM CAMS Expansion 167.50 21,426.75 D19007CS 2019-20 Infrastructure & GIS Cus 127.25 20,786.25 D59007CS 2019-2D Public & Environmental S 1.75 230.75 1)99182SB Land Sizing Budget 1.50 247.50 298.00 42,691.25 300.68 43,092.40 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 770 PARKS AND RECREATION ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 36530 GIS IMPLEMEN SUPPORT D19007CS 2019-20 Infrastructure & GIS Cus 7.25 1,196.25 36530 7.25 1,196.25 44066 PRADM-SYS/OUST SUPPO D19007CS 2019-20 Infrastructure & GIS Cus 3.25 536.25 44066 3.25 536.25 95413 PRADM-CUSTOMER SUPPO D19007CS 2019-20 Infrastructure & GIS Cus 38.75 6,393.75 95413 38.75 6,393.75 49.25 8,126.25 PAGE 89 14.52.04 DJJ89SEZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 775 PLANNING & ECO DEVELOPMENT ACCT ACCT# DESCRIPTION PROJECT PROJECT DESC TOTAL HOURS CHARGE 95600 PEDS CUST/SYSTEM SUP DE9007CS 2019-20 eGovernment Customer Sup 39.25 6,476.25 95600 PEDS CUST/SYSTEM SUP D19007CS 2019-20 Infrastructure & GIS Cus 3.00 365.00 95600 42.25 6,841.25 42.25 6,841.25 PAGE 90 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 91 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 14.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 765 EDCA ADMINISTRATION ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 36500 GIS IMPLEMEN SUPPORT D19007CS 2019-20 Infrastructure & GIS Cus 3.50 577.50 36500 3.50 577.50 3.50 577.50 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 791 RADIO COMMUNICATIONS - E911 ACCT ACCT# ➢ESCRIPTION PROJECT 79101 RADIO COMMUNICATIONS DL9183NG 79101 RADIO COMMUNICATI0NS DL9183P2 79101 PROJECT DESC T2911 OAKWIN Radio System Enhancement TOTAL HOURS CHARGE 9.50 1,281.50 167.25 27,596.25 176.75 28,877.75 176.75 28,877.75 PAGE 92 14.52.04 DJJ89SEZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 800 OC ROAD COMM-BURLY HILLS ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 36550 GIS IMPLEM SUPPORT-R D19007CS 2019-20 Infrastructure & GIS Cus 12.00 1,959.00 36550 12.00 1,959.00 36555 RCOC SIGNAL MANAGEME D19182SM RCOC Traffic Signal Management 121.75 19,805.25 36555 121.75 19,805.25 133.75 21,764.25 PAGE 93 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 815 CANTON TOWNSHIP ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 81500 CANTON TWP - GIS DAT D190070C Out County GIS Data Maintenance 0.25 36.50 81500 - 0.25 36.50 0.25 36.50 PAGE 94 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 95 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 14.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 822 CITY OF PLYMOUTH ACCT ACCT# DESCRIPTION PROJECT PROJECT DESC TOTAL HOURS CHARGE 82200 CITY OF PLYMOUTH - G D19007OC Out County GIS Data Maintenance 0.50 73.00 82200 0.50 73.00 0.50 73.00 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 825 CITY OF DEARBORN ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 82500 CITY OF DEARBORN-GIS D19007OC Out County GIS Data Maintenance 0.25 36.50 82500 0.25 36.50 0.25 36.50 PAGE 96 24.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 97 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 14.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 840 HEALTH DIVISION ACCT ACCT# DESCRIPTION 95563 USER SUPPORT/HEALTH 95563 USER SUPPORT/HEALTH 95563 USER SUPPORT/HEALTH 95563 USER SUPPORT/HEALTH 95563 96842 HEALTH - ADMIN 96842 HEALTH - ADMIN 96842 HEALTH - ADMIN 96842 HEALTH - ADMIN 96842 HEALTH - ADMIN 96842 PROJECT TOTAL PROJECT DESC HOURS CHARGE ➢J9007CS 2019-20 eCommerce Customer Suppo 0.50 49.50 DJ9010EB Finance/Admin Enhancement Budget 18.75 2,304.75 D59007CS 2019-20 Public & Environmental S 154.25 22,348.25 D99010EE Land Enhancement Budgets 32.00 3,859.00 205.50 28,561.50 DJ9182SB Finance/Admin Sizing Budget 1.50 218.50 D50162EL Distributed eLearning Solution I 41.75 5,902.75 D59007CS 2019-20 Public & Environmental S 55.75 6,482.25 D59007SM 2019-20 Public & Environmental S 31.50 4,557.50 D98162AI EH Enterprise Imp - Accela Imple 63.75 9,872.75 194.25 27,033.75 399.75 55.595.25 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 843 HEALTH -ENVIRONMENTAL ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 23005 ORACLE SUPPORT -EH PR T39007SM 2019-20 ➢BA System Maintenance 0.92 134.73 23005 0.92 134.73 24014 SQL SERV SUPP-EHEALT T39007SM 2019-20 DBA System Maintenance 5.04 643.44 24014 5.04 643.44 84200 EH - PROJECTS DB9007CS 2019-20 Courts Customer Support 2.25 240.50 84200 EH - PROJECTS DB9007SM 2019-20 Courts System Maintenanc 24.75 2,983.43 84200 EH - PROJECTS D59007CS 2019-20 Public & Environmental S 453.25 49,628.75 84200 EH - PROJECTS D59007SM 2019-20 Public & Environmental S 131.50 14,070.50 84200 EH - PROJECTS TT9007PR 2019-20 Problem Management 2.80 345.80 84200 EH - PROJECTS T39007SM 2019-20 DBA System Maintenance 2.14 353.10 84200 616.69 67,622.08 84300 EHEALTH PROGRAM D19007CS 2019-20 Infrastructure & GIS Cus 0.75 123.75 84300 EHEALTH PROGRAM D99162MP OCHD Mandate Program Budget 2019 32.25 3,503.25 84300 EHEALTH PROGRAM D99182SB Land Sizing Budget 9.25 1,526.25 84300 41.25 5,153.25 663.90 73,553.50 PAGE 98 24.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOS ACCOUNTING SYSTEM PAGE 99 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 14.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 852 HEALTH CENTRAL SUPPORT ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 95852 HEALTH CENTRAL SUPPO DJ9007CS 2019-20 eCommerce Customer Suppo 1.25 173.25 95852 1.25 173.25 1.25 173.25 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09128120 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 872 MEDICAL EXAMINER ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 24002 SQL SERV SUPP-MED EX T39007SM 2019-20 DBA System Maintenance 1.22 160.90 24002 1.22 160.90 87202 MED EXAM - CUST SUPT DB9182SE Courts Sizing Budget 20.50 3,300.00 87202 MED EXAM - CUST SUPT DJ8176RP OCME Replacement Solution 29.75 4,001.25 87202 MED EXAM - CUST SUPT DJ9007CS 2019-20 eCommerce Customer Suppo 15.25 2,062.25 87202 MED EXAM - CUST SUPT T39007SM 2019-20 DBA System Maintenance 7.00 1,155.00 87202 72.50 10,518.50 73.72 10,679.40 PAGE 100 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 900 HOMELAND SECURITY (HSD) ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 36546 HOMELAND SECURITY AP D59007CS 2019-20 Public & Environmental S 74.00 12,210.00 36546 HOMELAND SECURITY AP O59007SM 2019-20 Public & Environmental S 3.25 399.75 36546 77.25 12,609.75 98990 HOMELAND SECURITY D59166SA Siren Management Application Rep 157.25 21,214.25 98990 157.25 21,214.25 234.50 33,824.00 PAGE 101 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 910 VETERANS SERVICES ACCT PROJECT TOTAL, ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 95650 VETERANS SERVICES-EQ DJ9173SR Veterans Services Soldier Relief 86.25 10,232.25 95650 VETERANS SERVICES-EQ DJ9182SB Finance/Admin Sizing Budget 0.25 24.75 95650 86.50 10,257.00 95651 VETERANS CUST SUPP DJ9007CS 2019-20 eCommerce Customer Suppo 1.75 222.75 95651 1.75 222.75 88.25 10.479.75 PAGE 102 14.52.04 DJJ89SEZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 930 WATER AND SEWER -GENERAL ADMIN ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 37930 WATER AND SEWER -GENE TT9007PR 2019-20 Problem Management 40.50 5,772.50 37930 40.50 5,772.50 40.50 5.772.50 PAGE 103 14.52.04 AND COUNTY - OCR JOB ACCOUNTING SYSTEM SUMMARY FDA DEVELOPMENT / SUPPORT INVOICE QUARTERLY OAIiL DJJ895EZ-02 CHARGES FOR PERIOD OF SERVICES o9/28/20 06/27/2020 THRU 09/25/2020 CUSTOMER # 933 DRAIN EQUIP MAP PROJECT HOURS ACCT DESC PROJECT 39.75 ACCT# DESCRIPTION - 20 37933 DRAIN EQUIPMENT MAP D5961ID5 WRC Development Budget 2019 39-�5 39.75 37933 TOTAL CHARGE 5,099.25 5,099.25 5.099.25 PAGE 104 14.52.04 DJJ89SEZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 105 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 14,52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 940 WRC - CAMP ACCT ACCT# DESCRIPTION 37940 WRC - CAMP 37940 WRC - CAMP 37940 PROJECT PROJECT DESC D5961152 NBC Asset Optimization Phase III D99182SE Land Sizing Budget TOTAL HOURS CHARGE 2.50 412.50 0.75 123.75 3.25 536.25 3.25 536.25 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 944 CAMP CIA DR EQUIP ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 37944 CAMP CIA DR EQUIP D5961IDS WRC Development Budget 2019 - 20 29.25 3,914.50 37944 CAMP CIA DR EQUIP D59611SZ NBC Asset Optimization Phase III 17.25 2,615.25 37944 46.50 6,529.75 46.50 6,529.75 PAGE 106 24.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 107 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 14.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 947 HIPAA ENHANCEMENTS II ACCT PROJECT TOTAL ACCT4 DESCRIPTION PROJECT DESC HOURS CHARGE 96947 HIPAA ENHANCEMENTS I D59182EA HIPAA External Risk Assessment 100.25 16,203.00 96947 HIPAA ENHANCEMENTS I D88182MI MyInsight Implementation 34.50 5,692.50 96947 134.75 21,895.50 134.75 21,895.50 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM JJ895EZ-02 D JJ895EZ SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 09/28/20 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 963 FOC SECURITY AUDIT PROJECT TOTAL ACCT DESC HOURS CHARGE ACCT# DESCRIPTION PROJECT 34963 FOC SECURITY AUDIT DB91825B Courts Sizing Budget 0.17 17 18.200 18.20 34963 0.17 18.20 PAGE 108 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM PAGE 109 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 14.52.04 CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 973 UCC PROGRAM II ACCT ACCT# DESCRIPTION 92973 UCC PROGRAM II 92973 UCC PROGRAM II 92973 PROJECT PROJECT DISC TP8186PM UCC2 - Program Management TP9186CS UCC2 - Network Replace Imp - CLE TOTAL HOURS CHARGE 47.00 7,123.00 319.75 28,608.25 366.75 35,731.25 366.75 35,731.25 OAKLAND COUNTY - 'IT JOB ACCOUNTING SYSTEM DJJ695EZ-02 SUMSgARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY 09/28/20 Cp /27/20220 PERIOD 09/25 5/2020 CUSTOMER # 97S TREASURERS OFFICE-OAK➢OCS PROJECT HOURS ACCT DESC DESCRIPTION PROJECT 175.25 ACCT# stem - Testing TREASURERS - OAKDOCS D9907ITS Tax Management SY 175.25 9597E 95976 175.25 TOTAL CEARGE 25,176.25 25,176.25 25,176.25 PAGE 110 14.52.04 DJJ895EZ-02 OAKLAND COUNTY - OCIT JOB ACCOUNTING SYSTEM 09/28/20 SUMMARY FOR DEVELOPMENT / SUPPORT INVOICE QUARTERLY CHARGES FOR PERIOD OF SERVICES 06/27/2020 THRU 09/25/2020 CUSTOMER # 988 OC SHERIFF'S - IFS DIV - LAB ACCT PROJECT TOTAL ACCT# DESCRIPTION PROJECT DESC HOURS CHARGE 16300 OCSO CLEMIS FORENSIC DG8007PM 2018-20 CLEMIS Support Services 13.75 1,432.00 16300 13.75 1,432.00 13.75 1,432.00 PAGE 111 14.52.04 Resolution #20520 November 19, 2020 Moved by Long seconded by Luebs the resolutions on the Consent Agend<! be adopted. AYES: Gingell, Hoffman, Jackson, Kochenderfer, Kowall, Kuhn, Long, Luebs, Markham, McGillivray, Middleton, Miller, Nelson, Powell, Quarles, Spisz, Taub, Weipert, Woodward, Zack, Gershenson. (21) NAYS: None. (0) A sufficient majority having voted in favor, the resolutions on the Consent Agenda were adopted. 4'-Ca&¢CL IIAEREe 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 November 19, 2020, with the original record thereof now remaining in my office. In Testimony Whereof, 1 have hereunto set my hand and affixed the seal of the Circuit Court at Pontiac, Michigan this 19'h day of November, 2020, Lisa Brown, Oakland County