Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Resolutions - 2021.05.26 - 34516
MISCELLANEOUS RESOLUTION#21197 May 26, 2021 BY: Commissioner Gwen Markham, Chairperson, Finance Committee IN RE: INFORMATION TECHNOLOGY — SECOND QUARTER 2021 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 Second Quarter 2021 development charges to be $1,166,261.44 for the General Fund/General Purpose County departments; and WHEREAS direct charges to Special Revenue and Proprietary fund departments are $1,159,928.31 and non -county agencies are $21,745.75 for the Second Quarter 2021; 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 approves the Second Quarter 2021 Development Report and authorizes the Second Quarter appropriation transfer as specified on the attached schedule. BE IT FURTHER RESOLVED that the respective departmental Fiscal Year 2021 budgets are to be amended as specified in the attached detail schedule. Chairperson, on behalf of the Finance Committee, I move the adoption of the foregoing resolution. Commissioner Gwen Markham, District #9 Chairperson, Finance Committee FINANCE COMMITTEE VOTE: Motion carried unanimously on a roll call vote. DUST FUND# 540 550 560 530 630 005 508 450 184 718 725 291 722 440 410 724 726 723 522 620 430 490 506 483 482 015 495 498 502 493 188 785 740 046 660 900 562 416 680 907 824 565 872 296 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 ACCOUNT GOVERNMENTAL FUNDS General Fund 11011 10100-3020201-121020-773630 10100-3020301-121020-773630 10100-3020401-121020-773630 10100-3020501-121020-773630 10100-1070801-114000-773630 10100-5010101-180010-773630 111100-5010101-165015-773630 10100-1070901-113270-773630 10100-2010210-132300-773630 10100-2010210-125000-773630 10100-2010201-180000-773630 10100-2010401-172190-773630 10100-2010210-125000-773630 10100-2010301-185010-T 3630 10100-2010501-125000-773630 10100-2010210-125000-773630 10100-2010601-172190-773630 10100-2010205-132305-773630 10100-1070401-113000-773630 10100-1010201-181010-773630 10100-1010501-181020-773630 10100-301G402-135070-773630 10100-301 G401-121220-773630 10100-3010403-121100-773630 10100-3010403-121240-773630 10100-1010101-181000-773630 10100-3010201-121110-773630 10100-3010301-121130-773630 10100-3010301-121180-773630 10100-3010101-121100-773630 10100-1090206-171000-773630 10100-1090101-171000-773630 10100-1020501-173010-773630 10100-2010301-133095-773630 10100-1020601-182020-773630 10100-1110101-115090-773630 10100-1060101-133300-773630 10100-1050403-183020-773630 10100-1050401-183010-773630 10100-5010303-165040-773630 10100-5010302-165020-773630 10100-1090108-171030-773630 10100-1070601-132030-773630 10100-1060801-174000-773630 Prepared By Inronraton Tadinology, 04/1521 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY SECOND QUARTER 2021 DIVISION 5211 - District Court 5212 - District Court 52/3 - Dlstnct Court 52/4 - District Court Animal Control Ed of Commissioners BOC-Legal Resource Center Circuit Court Probation North Clerk's - County Clerk Clerk E-Services Clerk/Reg - Admin Clerk Register Admin Clerk/Reg - EDMS (Imaging) Clerk/Reg - Elections Clerk/Reg - Jury Commission Clerk/Reg - Legal Records Clerk/Reg - Micrographics Clerk/Reg - Vital Statistics Community Corrections Admin Compliance Office - AudRmg Corporation Counsel CTS-FD-CT Services - Clinic CTS-Fam Div -Judicial Support CTS-FD-Judicial Support -ADM CTS-FO-Juvenile Support County Executive Courts -Business Division Courts-GJ-Judicial Support Courts-GJ-Jury Operations Courts - Judic ll / Administration Economic Day & Comm Affairs Economic Development & Community Affairs Equalization Division Elections Pandemic/COVID19 Fiscal Services -Gen Fund Emergency Mgmt/Homeland Security Human Services - HS Admin Sery HR Recruitment Human Resources Library - Library Admin Library Services Marketing & Communcations Medical Examiner MSU - Digital Media Services Page 1 or 23 2nd Quarter Jan - Mar $4,815 34 $4 615 34 $4,815 34 $4,814.98 $10,008 75 $20,094 00 $0 00 $0 00 $0 00 $0 00 $0.00 $0 00 $3,36R24 $380 50 $0 00 $65,791 53 $0 00 $29,625.24 $24,513.84 $0 00 $15,741 75 $0 00 $0 00 $220 00 $2,509 85 $49,11850 $0 00 $244,782.95 $519 09 $12,46010 $50 50 $1,361 25 $85,241 08 $0 00 $71,954 55 $12,168 75 $3,480 75 $0 00 $35,611 39 $0 00 $0 00 $0 00 $2,406.50 $0.00 Y.T D. $7,524 56 $7,524.56 $7,524 56 $7,523 82 $25.803 80 $30,533 00 $0.00 $174 00 $0.00 $0 00 $0 00 $0 00 $6,910 24 $5,174 75 $82.50 $121,166 01 $0 00 $55,638 04 $55 090 51 $0 00 $38,613 25 $0.00 $0.00 $1,977 05 $2,509 85 $77 858 25 $0 00 $504,584.04 $791 21 $34,173.50 $50.50 $2,475 00 $171,068 82 $0 00 $160,153.67 $24,260 25 $3,480 75 $0.00 $81,850.16 $0 00 $0 00 $677 00 $10,346 30 $0 00 2rd nuatler2021.ptl1 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY SECOND QUARTER 2021 2nd Quarter CUST FUND# ACCOUNT DIVISION Jan - Mar Y.T.D 710 101 10100-1060801-174000-773630 MSU Extension - Oakland $82.50 $8250 349 101 101004030501-112680-773630 OCSD Admen Serv-Records Unit $2525 $19275 648 101 101004030201-112580-773630 OCSD Admen Serv-Sheriff Admen $000 $000 163 101 101004W0901-115140-773630 OCSO- CLEMIS Forensic Lab IMS $000 $000 775 101 10100-1090201-171000-773630 Planning& Economic Development $20,99075 $31,04075 479 101 10100-3040101-121090-773630 Probate FD Judicial Support $0.00 $000 512 101 10100-3040403-124010-773630 Probate-Estates/Mental Health - EDMS (Imaging) $2,94810 $6 046 50 510 101 10100-3040403-124010-773630 Probate-Estates/Mental Health Support $9 401 75 $17,886 80 481 101 10100-3040101-121060-773630 Probate -Family Division Judicial $000 $000 145 101 10100ADIC101-122050-773630 Prosecuting Attomey- General Prosecution $25,39175 $53,02030 690 101 10100-1020310-182090-773630 Purchasing $8575 $43625 637 101 10100-1030803-1 B4020-773630 Records Retention $000 $000 650 101 10100-1020650-126020-773630 Reimbursement Division $1153500 $14,79175 195 101 101004030301-112590-773630 OCSD-Corrective Serv-Admen $5794911 $97,51337 191 101 101004030601-110000-773630 Sl-CLEMIS $19,77784 352,105.21 348 101 101004030301-112620-773630 Sheriff Corrective Serv, Admen $8,32700 $10,801 988 101 101004030901-116240-773630 Sheriff- IFS Div Lab $0 00 $000 647 101 101004030601-110000-773630 Sheriff -Patrol Serv-LE Admen $000 $000 206 101 101004030901-110040-773630 Shenff - LE Support-Sery Admen Saw $000 445 101 10100-1030803-1 B4025-773630 Support Services $136054 $3,01500 600 101 10100-7010101-186040-773630 Treasurer $183 S135,548.84 169 101 10100-7010101-186080-773630 Treasurers- Banking RFP $0 00 $0.00 627 101 10100-7010110-186130-773830 Treasurers - Landsale $000 $000 978 101 10100-7010101-186050-773630 Treasurers Offce-OakDocs $24,403.25 $4684975 910 101 10100-1090702-132050-773630 Veterans Services $9,12625 $9,91175 730 101 10100-6010101-155010-773630 Water Resource Commissioner $4094725 $80,73130 742 101 10100-6010101-149920-773630 WRC - CAMS Software Support & Maintenance $000 $805 00 203 101 10100-6010101-174452-773630 WRC EU Pub ED Adm Programs $000 $000 022 101 10100-6010101-174453-773630 WRC GIS Layer $000 $000 301 101 10100-6010101-174250-773630 WRC - Bud Erosion Software Sol $000 $000 Sub -Total Fund 101 $1,028,47403 $2,006,31977 Health Fund f2211 840 221 20221-1080201-133150-773630 Health $50,92850 $114,65400 852 221 20221-1060211-133150-773630 Health Central Support $66 50 $142 25 843 221 20221-1060220-134390-773630 Health Environmental $69,2l $13726728 183 221 20221-1060201-133150-773630 Health Waders Redesign $000 $000 239 221 20221-1060201-133095-773630 Pub Hlth-Pandemic/COVIDI9 36500 $8,66000 Sub -Total Fund 221 $120,642 59 $260,723.53 Juvenile Maintenance Fund f2g31 665 293 20293-1070901-112090-773630 Children's Village $17,14482 $27,84959 668 293 20293-1070901-112010-773630 Children's Village Admen $000 S000 Sub -Total Fund 293 S17,14482 $2784959 63600-1080101-152000-631385 DEVELOPMENT FOR GOVERNMENTAL FUND $7166261.44 $2294,892.89 Prepared By: Information Tecrrology, g4I15121 Page 2 of 23 2no Quad,2021 pdf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY SECOND QUARTER 2021 2nd Quarter CUST FUND# ACCOUNT DIVISION Jan - Mar V.T.D. APPROPRIATION SUB -TOTAL GOVERNMENTAL DEVELOPMENT APPROPRIATION: $1,166,261.44 $2,294,892.89 10100-9090101-196030-773630 Information Technology Development 81 "i66 261 44l i $2 294 622 391 TOTAL GOVERNMENTAL: 0.00 0.00 NON -GOVERNMENTAL DIRECT CHARGES 053 Airport Special Events $000 $000 274 ASAP Passport System $000 $000 672 Assessment & Tax $60 50 $242 00 935 Augusta SAW Grant $000 $000 073 ¢ennial Celebration Grant $000 $000 944 CAMP CTA DR Equipment $10,09850 $1866625 669 CAMS/CVT Data Conversion $0.00 $000 055 CLEMIS I$4-,"_-, $6,970 76 699 CLEMIS - CAD $000 $000 448 CLEMIS/FRMS NON -BILLABLE $000 $2,722.50 056 CLEMIS FUND 63500 $13,24925 $29,50975 026 CLEMIS MIDC Bridge $0 00 $8 555 OD 069 CLEMIS -Traming $0.00 $000 749 Clerk/Reg -CPL $0.00 $000 720 Clerk/Reg- Register Of Deeds $4,97875 $10,275.55 719 Clerk/Rod Automation Fund $000 $000 659 Collaborative Asset Mgt Sys (CAMS) $000 $000 435 Comm Dev - Housing Counselor $172 50 $172 50 521 Community Corrections - Admin (Grant) $000 $000 937 COSDS SAW Grant $000 $000 471 Courts-FOC Exp-CS Enforcement- EDMS (Imaging) $000 $000 507 Courts-FOC Exp-C$ Enforcement $18,97960 $4141500 470 Courts-FOC EXP-FAM Counseling $000 $0 DO 045 CV Radio System Replacement $1,69125 $4,41375 673 Cyber Security Fund $000 $000 931 Drain Equipment Fund $0 00 $000 189 Drain Equipment Funtl- Poverplan Contract $000 $000 933 Dram Equip Map $904.00 52,452 75 837 EDCA- MlTmdeSchool org Grant $000 $000 167 Edwards Dram SAW Grant $000 $000 100 Farmington Hills BIDS SAW $0 00 $000 210 Fire Records Management System $4 012 00 $9,547 80 750 FM&O $2862632 $51,68564 756 FM&O Building Maintenance $0.00 $000 133 FM&O Building Management System $000 $000 080 FMO Bldg Mgmt Systems Rep Ph 2 $4,300 25 $7,833 75 Pra,ad By. ii,Prmatmn Teer,ebgy. 04115I21 Page 3 N23 2,d Quarc,2021 mf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY SECOND QUARTER 2021 2nd Quarter GUST FUND# ACCOUNT DIVISION Jan - Mar Y.T.D. 048 FM&O Bldg Security Enh Prol $0 00 $000 757 FM-WK Rel/Jail Mgt[Vdeo Conf S0 00 $0 00 963 FOG Secunty Audit $000 $D 00 942 Franklin SAW Grant $000 $000 038 HACH WIMS Software Support $49500 $57575 380 Health Immum ration Grant $000 $000 173 Health - Lead Innovation Grant $0 DO $000 071 Health Lead PSA Grant SO 00 $000 117 Health -Hepatitis A Prevention SOOD $000 020 Henry Graham Dram SAW Grant $1,072 50 $1,072 50 947 HIPAA Enhancements 11 $37,06&50 $95,703 75 120 HR-Financial System Replacement $466,767 07 $906303 80 214 IAM Program $93,950.00 $150,761 50 338 Imaging Project $56,570.75 $73,17025 751 IT Telephone Communications $000 $185 50 202 Jail Management System (JMS) $11,759 DO $35,084 00 185 Leasetrack $000 $000 112 Medical Marijuana PSA $000 $000 101 Medical Marijuana Mysidewalk $000 $0.00 113 MIDC Dev $89,92675 S119,45125 192 Neptune Reports $000 $000 136 Oakland Township BIDS SAW Woo $0.00 634 OakVidec Upgrade (Building Authority) $0.00 SOGO 938 OAKWIN Radio System Enhancement $000 $000 043 OC Bicentennial Oak200 $000 $000 653 OC International Airport $9,19875 $1427250 934 OLV SDS SAW Grant $000 $000 255 Oracle Upgrade to 19C $61,82575 $77,681 Do 770 Parks and Recreation - Administration $10,10625 $17,83575 867 P&R Capital Improvement $000 $000 925 P&R EMS Upgrade $000 $000 796 P&R Facilities & Maintenance $000 $000 442 P&R Lyon Oaks Conf Ctr CIP#2469 $000 $000 443 P&R Lyon Oaks Conf Ctr CIP#2468 $000 $000 454 P&R Springfield Oaks CIP#2471 $000 $000 456 P&R Springfield Oaks CIP#2470 $0.00 $000 457 P&R Red Oaks Clubhouse CIP#2467 $000 $000 268 Pontiac - Meter $000 $000 747 Pontiac - Water $000 $000 748 Pontiac - Sewer $000 $000 095 Pontiac Sewer $000 $000 936 Pontiac Water Asset Mgm[ $000 $000 329 Pontiac WWTP Transaction $000 $000 906 Public Health Grant 795 $000 $0.00 237 Public Safety Dashboard $22 063 25 S51,787 00 791 Radio Communications -E911 $3868975 $7129650 Prepared By Infonnaeon TeWnology, 04A5121 Pare 4 of 23 2nd Quarter 2021 OIN INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY SECOND QUARTER 2021 2nd Quarter GUST FUND# ACCOUNT DIVISION Jan - Mar Y.T.D. 695 Risk Management $1648150 $37,85425 638 Tax Management System $000 $0.00 601 Treasurers -DTRF $000 $000 973 UCC Program II $33,396 00 $64,803 25 115 UCC Program III - VOW $63,96750 $114,73225 231 UCC Program IV - Wireless $28,77525 $43,82875 656 Water Resources Accounting 551909 $791 21 731 Water Resource - Equipment $61875 S61875 736 WlnCan Central Storage Solution $0.00 $000 930 Water and Sewer -General Adm $3,48625 $4,18750 939 Water and Sewer General Administration $000 $0.00 974 Water and Sewer Gen Admin-WMU $000 $0.00 201 Water and Sewer Gen Adm -XC2 $000 $000 850 Workforce Dev Division $000 $0.00 212 Workforce Dev-Clean Slate Prol $2,681 25 $2,681 25 281 WRC $000 $000 670 WRC Acto g - Crowder Prjct $0 00 $0 00 344 WRC Administration $82.50 $8250 929 WRC Aeration Tank Rehab $000 $000 940 WRC-CAMP $1,08700 $3,26275 926 WRC CLINTON-OAKLAND SCADA $000 $000 932 WRC CLINTON-OAK SDS SCADA Main $000 $000 277 WRC GWK PCF-WRC SCADA $000 $om 377 WRC-SAW ACACIA $000 $000 382 WRC - SAW Birmingham $000 $000 379 WRC-SAW Commerce Township $000 $000 387 WRC- SAW Evergreen Farmington $000 Sol 389 WRC-SAW Lake Orion $000 $000 388 WRC-SAW Novi $000 $000 386 WRC - SAW Orchard Lake $000 $000 674 WRC - SAW Grant Labor $000 $000 381 WRC SAW GWK $000 $000 895 WRC AGO $000 $000 734 WRC - AMR Support $000 $70125 980 WRC Bingham Farms SAW $000 $000 745 WRC- COSDA Meter Replacement $000 $0.00 728 WRC - CO SDS SewMet $000 $000 168 WRC CRWRRF April Bldg Rehab $000 $000 729 WRC -EF SDS SewMet $000 $000 737 WRC - Data Application Pilot Poject $000 $000 300 WRC - GIS Allocation by Labor $000 $000 277 WRC -GWK PCF-WRC SCADA $000 S000 295 WRC - HACH WIMS Implementation $000 $000 894 WRC - HACH WIMS Implementation Phase II $000 $000 733 WRC - Hydra Drain Project $0 00 $000 671 WRC - Infrastructure Op Ar $0 00 $000 Prepaa,d By Information Teorrology, 0411501 Page 5 of 23 2rd Quarter 2921.pdf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY SECOND QUARTER 2021 2nd Quarter CUST FUND# ACCOUNT DIVISION Jan - Mar Y.T.D. 982 WRC Keego Harbor SAW $000 $0.00 299 WRC - MISS DIG Ticket Mgmt Sys $000 $000 236 WRC Oaklati Macomb Interceptor $4,59900 $6,13200 981 WRC OxFord Tw SAW $000 $000 501 WRC Permitting lmpl $1,32000 $2,64000 979 WRC Permitting Implementation $1, 02075 $1,41175 990 WRC Regional Systems Unit $000 $000 986 WRC Royal Oak Twp SAW $000 $000 686 WRC - SAW Grant Labor- Common to All $000 $0.00 402 WRC SAW Huron Rouge $000 $000 403 WRC SAW Bloomfield Village $000 $0.00 739 WRC -SCADA Common $000 $0.00 738 WRC -SCADA Engineering Assessment $000 $000 358 WRC- SCADA Maintenance $2,97000 $5,69250 294 WRC -Serrt2r Fund $3,10300 $10,293.25 067 WRC Utility Billing Replacement $8,67800 $15,575-50 023 WRC Walled Lake Water $000 $000 024 WRC Walled Lake BIDS $000 $0.00 121 WRC Website Standardization $1,00250 $3,640.75 170 WRC WMU Meter Maintenance $000 $000 63600-1080101-152000-631302 SUB -TOTAL DIRECT CHARGES FOR DEVELOPMENT $1,159,928.31 $2,128,575.51 TOTAL COUNTY DEVELOPMENT CHARGES $2326189.75 $4,423,468.40 NON -COUNTY AGENCIES 63600-1080101-152000-635017 Non -County Agencies $21 74575 527.750 00 Prepared By: Infom arm Tetlmvlvgy, W/15121 Page 6 of 23 2nd Quarter 202tptlf INFORMATION TECHNOLOGY -RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - SECOND QUARTER 2021 Oust# GOVERNMENTAL FUNDS end Otr 2021 630 ANIMAL CONTROL 24017 SQL Server Supp- Animal Control $6200 95628 Animal Control $5,678 00 95682 Dog System $4,27875 Animal Control -Total $10,008.75 005 BD OF COMMISSIONERS 91404 BOG - Customer Support $2009400 Bd of Commissioners - Total $20,094 00 503 BOC- LEGAL RESOURCE CENTER 61001 Library Services $000 91405 Library Board $0.00 BOG -Legal Resource Center - Total $000 665 CHILDRENS VILLAGE 95665 Childrens Village $1714482 Childrens Village -Total $17 144 82 668 CHILDREN'S VILLAGE ADMIN 97668 Childrens Village Atlmin $0.00 Childrens Village Admm - Total $000 725 CLERWREG-ADMIN 72600 Clerk -Atlmin $000 Clerk/Reg - Atlmin - Total $0.00 440 CLERKIREG- ELECTIONS DIVISION 95443 Clerk/Reg- Elections Division $38050 Clerk/Reg - Elections Division - Total $380 50 722 CLERK/REG -EDMS IIMAGINGI 13001 Clerk's -Efilmg $000 95158 Clerk/Reg- EDMS Support/Maintenance/Upgrades 3$ 36924 Clerk/Reg - EDMS (Imaging) - Total $3,369 24 410 CLERKIREG - JURY COMMISSION 95512 Clerk/Reg - Jury Commission $000 Clerk/Reg - Jury Commission - Total $000 724 CLERK/REG - LEGAL RECORDS 21013 Legal Division -50% $250990 95170 Clerk/Reg - Legal Records - Total $6,23025 95189 Circuit Court System $5505138 Clerk/Reg - Legal Records - Total $65,791 53 723 CLERK -VITAL STATISTICS 24015 SOL Server Supp - Vital State 35% $5200 95161 Clerk Reg - Vital Statistics $29,57324 Clerk - Vital Statistics - Total $29,625 24 522 COMMUNITYCORRECTIONS-ADMIN/COI 23003 Oracle Support -Comm Corr -52% $51909 24012 SOL Server Supp- Community Corr 3.5% $5200 52200 Comm CorrAdin in (Ca a nty) $23,942.75 52201 Comm Corr -DW Support $000 Community Corrections - Total $24 513 84 Prepared By Inlonnaton Technology, 04/15121 Page 7 of 23 21ftl Quatler 2021 pdf INFORMATION TECHNOLOGY -RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2021 620 COMPLIANCE OFFICE -AUDITING 44034 Auditing - New Development 95468 Auditing Internal Sry - Oust Sup Compliance Office - Auditing - Total 690 COMPLIANCE OFFICE - PURCHASING 44028 Purchasing System Enhancements 44029 Pur-New Development Compliance Office - Purchasing -Total 430 CORPORATION COUNSEL 95501 Corporation Counsel Corporation Counsel - Total 015 COUNTY EXECUTIVE 95654 County ExecDevelopment 95656 County Executive Support County Executive - Total 450 CIRC CT PROBATION - NORTH 80204 Circuit Court Probation - North Cmwt Court Pori - North - Tatal 495 CTS-BUSINESS DIVISION 12002 CCT-Courts/Cmmnal 23010 Oracle Support-CCT/CTS Com Whse 26% CTS-Busmess Division -Total 506 CTS-FAM DIVJUDICIAL SUPPT 95187 CTS-Fam DivJudlclal Support CTS-Fam Div-Judlaal Support - Total 483 CTS-FDJUDICIAL SUPPORT -ADM 24009 SQL Sery Supp- CTS-Jud Sup Adm-35% CTS-FD-Judicial Support-Adm -Total 482 CTS-FO JUVENILE SUPPORT 48200 CTS-Jutl Support- Juv Support CTS-Jutl Support- Juv Support -Total 498 CTS-GEN JURISJUDICIAL SUPPT 23010 Oracle Supp-CCT/CTS 95179 CTS-Gen Juns-Judlasl Suppt CTS-Gen Juns-Judicial Suppt-Total 502 CTS-GJJURYOPERATIONS 23008 Oracle Support-CTS-GJ-Jury Operators CTS-GJ-Jury Operations - Total 493 CTSJUDICIAL AOMIN 13002 Court's -Efilmg 95174 CTS-Judicial Admm CTS-Judlaal Admin - Total 188 ECONOMIC DEV & COMM AFFAIRS 98180 Economic Dev & Comm Affairs Economic Dev & Comm Affairs - Total 785 ECONOMIC DEVELOPMENT& COMMUNITY AFFAIRS 36500 GISlmplementation Support C&EDev 36501 CED Application -HM Support Prepared By Information Technology, 0411521 Page 8 N 23 $GAO $0 00 $0 00 $29 75 $56 00 $85 75 $15 741 75 $15 741 75 $49, 11850 $0 00 $49,118 50 $0 00 $0 00 $0 00 $0 00 $0 00 $0.00 $0 00 $220 00 $220 00 $2 509 85 $2,509-85 $259 57 $244,523 38 $244,782 95 $519 09 $519 09 $0 00 S12 460 10 $12,46010 5$ 050 $50.50 $1,361 25 $0 00 end ouane12021 oar INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT 1 SUPPORT DETAIL -SECOND QUARTER 2021 95785 Comm 8 Eco Developmt $0 00 Economic Development & Community Affelrs -Total 740 EQUALIZATION 23012 Cracle Support-Equalization-5.2% $51909 24005 SQL Server Supp-Equahzahon-10.5% $15595 31075 Equal - Development $5,30875 36505 CIS Implementation Support Equahzahon $37125 36506 Equal Applicator - HIM Support $4,123 00 36507 Equal LAMS Support $14,53425 36601 Land System Enhancement - Equal (50%) $28,40263 36701 Land System Maintenance - Equal (50%) $1 785 01 36801 Land System Support- Equal (50%) $4,941 40 36902 BSBA Orion Twp $000 50101 EQUAL(BSSA ANNUAL) $1,17200 95562 Equalization -DW Support $000 95693 Equalization - System Maintenance $000 95699 1 Master Appraisal Sup/Mamt $23 927 75 Equalization - Total 660 FISCAL SERVICES ADMIN 23001 Oracle SnppOrt - Fiscal Sew -156% $1,55727 23013 Oracle Support -HR-Acctg/Budget-52% $51909 24006 SQL Sew Supp-HR-Acctg-175% $2599 44021 FS-System/Customer Support $12,18725 44022 FS- System Maintenance $338250 44023 FS- System Enhancements $6,105.00 44024 FS - New Development $000 44602 Bond Disclosure -Fiscal (50%) $000 96001 Fiscal Sew -Acctg 40% $32,11830 96003 Fiscal Sew -Budget2l $1605915 Rscal Services Admp1- Total 840 HEALTH DIVISION 36525 CIS Implementation Support Health $000 95563 User Support -Health $16,02200 96842 Health Admm $3490650 Health -Total 852 HEALTH CENTRAL SUPPORT 95852 Health Central Support $fib 50 Health Central Support -TOMI 943 HEALTH -ENVIRONMENTAL 23005 Oracle Support -EH Projects -52% $51909 24014 SQLServer Suppb Ehealthl4% $20790 84200 EH - Projects $68,51435 84300 Ehealih Program 4$ 1 25 Health -Environmental - Total 183 HEALTH WEBSITE REDESIGN 96183 Health Websde Redesign Health Website Redesign -Total Prepared By InfmmaLon TeGnplopy 04I1521 Page 9 of 23 $1,361 25 $86,241 08 $71 95455 $50,928 50 $66 50 $69,282 59 $0.00 2rd puaM r 2021 pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2021 900 EMERGENCY MGMT/HOMELAND SECURITY 36545 GIS Implementation Support Homeland Security 680 HUMAN RESOURCES 562 HUMAN SERVICES - HS ADMIN SERV 907 LIBRARY -LIBRARY ADMIN 824 LIBRARYSERVICES 565 MARKETING & COMMUNICATIONS 872 MEDICAL EXAMINER 296 MSU-DIGITAL MEDIA SERVICES 710 MSU EXTENSION -OAKLAND 349 OCSO ADMIN SERV - RECORDS MGMT 648 OCSO ADMIN SERV -SHERIFF ADMIN 163 OCSO-CLEMIS FORENSIC LAB IMS 775 PLANNING & ECO DEVELOPMENT 512 PROB-ESTATES/MENTL HLTH EONS fIM Pmparetl By Information Technology, 06t1521 36546 G1 Homeland Security Application - H/W Support 98990 Homeland Security Homeland Security -Total 23014 Oracle Support-HR/Personnel-52% 24007 SOL Sewer Suppport-HR/Personnel-175% 440" HR-New Development 96002 Human Res -Personnel 40% Human Resources -Total 96561 Human Services -HS Admin Sew Human Services- HS Admm Sery - Total 91405 Library Board Library - Library Atlmin - Total 61001 Library Services Library Services - Total 56500 Marketing & Communications Marketing & Communications - Total 24002 SQL Server Support -Medical Exam -3E% 87202 Medical Exemmer- Customer Support Medical Examiner - Total 22296 MSU - Digital Media Services MSU - Digital Media Services -Total 95676 MSU Ext Equipment Maintenance MSU Extension - Oakland - Total 97349 OCSO Admm Sew - Records Mgmt OCSO Atlmin Sery - Records Mgmt- Total 97648 OCSO Admin Sery - Sheriff Admin OCSO Atlmin Sew - Sheriff Atlmin - Total 16300 OCSO-CLEMIS Forensic Lab OCSO-CLEMIS Forensic Lab IMS - Total 95600 PEGS Cust/System Support Planning & Eco Development - Total 95207 PC-E/MH EDMS Support & Mine P.d-Est/Mntl Hlth EDMS (lmg) - Total Page 10 of 23 $0 00 $12 168 75 $0 00 $519 09 $25 99 $0.00 $35 066 31 $3 480 75 $0 00 $0 00 $0 00 $52 00 2 354 50 $0.00 $82 50 $25 25 $0 00 $0 00 $20 990 75 294810 $12,168 75 $35,611 39 $3,480 75 $0 00 $0-00 $000 $2,406 50 $0 00 $82 50 $25 25 $0 00 $0 00 $20 990.75 $2,94810 2rd Quarter 2021 pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2021 510 PROB-ESTATES/MENTL HLTH SUPPORT 24010 SQLSew Supp-PCT-Est/Mental-35% $5200 92198 Prob-Est/Mntl Hith Support $9.349 75 Prob-EsLMntl Hhh Support - Total $9,401 75 481 PROS-FD JUDICIAL 95168 PC -Judicial Family Admin-Family Judges $000 Prob - FD Judicial - Total $000 145 PROSECUTOR- GENERAL PROSECUTION 24016 SQL Sewer Supp-Prosecutors 35% $5200 95622 Prosecutor/Executwe $22,86275 95664 Prosecutor Warrants $345.00 97001 Prosecutor Data Proc 21$ 32 00 Prosecutor- Total $25 391 75 239 PUB HLTH-PMDEMICICOVID19 96239 Pub Hlth-PBadem,0CovnJ19 $365 00 Pub Hlth-Pandemic/Ccv,J19-Total $36500 637 RECORDS RETENTION 44053 REC- System Enhancements $000 Records Retention -Total $000 650 REIMBURSEMENT 95470 Reimbursement System $11,303.00 95542 Reimburse User Support $23200 Reimbursement - Total $11,535 00 195 SHERIFF 12001 OCSD-Courts/Criminal-50% $0-00 23009 Oracle Suppport- OCSWCTS Crim Whse-26% $25957 97163 Shenff $4,63754 97164 Shenff- Development $53,05200 97165 Shenff-DW Support $000 98164 CLEMIS-Shenff $000 Sheriff - Total $57,94911 191 SHERIFF - CLEMIS 23015 Oracle Su ppport-Sheriff /CLEMIS-52% $51909 96163 Sheriff - CLEMIS $1925875 Sheriff - CLEMIS - Total $19,777 84 348 SHERIFF -CORRECTIVESERVADMIN 34800 Inmate Phone System $832700 Shenff - Corrective Sery Admin - Total $8,327 00 986 OC SHERIFF. -IFS DIV-LAB 16300 OCSO CLEMIS Forensic $000 OCSO CLEMIS Forensic - Total $000 647 OCSD PATROL SERV-LE ADMIN 97647 Sheriff- Patrol Serv-LE Ad min $000 Sheriff- Patrol Sew -LE Ad min -Total $000 445 SUPPORTSERVICES_ 23002 Oracle Support-Supp Serv-52% $51909 24011 SQLSewer Supp-Suppt Sewoes7% $10395 44500 Support Services $737.50 Prepared By Information Technology, 04/15121 Fare 11 N 23 2nd QuaMrzo21 pdf INFORMATION TECHNOLOGY- RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2021 Support Services -Total 600 TREASURER 23006 Oracle Support -Del Tax- 52% 23016 Oracle Support - Treasurer- 10.4% 36516 Treasurer Application-HIW Support 36602 Land System Enhancements -Trees (50%) 36702 Land System Maintenance - Trees (50%) 36802 Land System Support-Treas (50%) 44061 Tre-SystemACustomer Support 44062 Tre-System Maintenance 44063 Tre-System Enhancements 44064 Ti-New Deyelopment 44080 Tre-DW Support 44082 Tre-DW Maintenance 44601 Bond Disclosure- Trees (50%) 50102 TREAS(B58A) ANNUAL 95008 Del Tax On Line 95303 Del Tax System Maintenance 95561 User Supporu Del Tax 95615 BS&A Annual Tax Support Treasurer - Total 169 TREASURERS -BANKING 96169 Treasurers -Banking RFP Treasurere-Bankmg RFP-Total 627 TREASURER-LANDSALE 44083 Treasurer-Landsale Treasurer-Landsale- Total 978 TREASURERS OFFICE - OAKDOCS 95978 Treasurers Office-Oakdcm Treasurers Office-Oakdocs - Total 910 VETERANS SERVICES 95650 Veterans Services Equipment 95651 Veterans Customer Support Veterans Services - Total 730 WATER RESOURCE COMMISSIONER 24008 SOL Server Supp- WRC 35% 28007 Water Resource Commission 28010 WRC-Customer Support 28011 Water Resource Commissioner Application 36520 GIS Implementation Support WRC 36521 WRC Application - HAW Support Water Resource Commissioner - Total 742 WRC-CAMS SOFTWARE SUPPORT&MAINTENANCE 74200 WRC CAMS SOFTWARE Support WRC CAMS SOFTWARE Support - Total 022 WRC GIS LAVER 35022 WRC GIS Layer Prepared By I fomaition'reGhnolegy,W15V Page 12 of 23 $1, 36054 $519 09 $1,03818 $0 00 $28,402 12 $1,784.99 $4,941.35 $31 19835 $2,288 50 $2,007 00 $0 00 $0.00 $0A0 $0-00 $1,172 00 $1,567 50 $0 00 $10,531 75 $0 00 $85 450 83 $0 00 $0 00 6 00 $0 00 $24 403 25 $24,403 25 $0 00 $9,126 25 $9,126 25 $52 00 $20,377.50 $14 536 50 $5,610.00 $371 25 $0 00 $40,947 25 Woo $0.00 $0 00 2nd Ouader2021 Pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2021 WRC GIS Layer- Total $000 301 WRC-SOIL EROSION SOFTWARE SOL 74301 WRC- Sell Erosion Software Sol $000 WRC - Sol[ Erosion Software Sol -Total $000 54O 52/1 DISTRICT COURT-NOVI 95527 DC Suprt-52/1-25% $4,81534 52/1 District Court -Total $4,81534 550 5212 DISTRICT COURT -CLARKSTON 95528 DC Suprt-52/2-25% 48$ 1534 52/2 DISMCt Court - Total $4 815 34 560 5V3 DISTRICT COURT-ROCHESTER 96288 52 Dist Ct Dlv3 $4,81534 95529 DC Suprt - 5213 - 25% 000 5213 District Court- Total $4,81534 530 5214 DISTRICT COURT -TROY 95530 DC SuprL 52/4-25% 48$ 1498 52A Distnct Court - Total $4,814 98 $11166,261_44 Cust# DIRECT FUNDS 274 ASAP PASSPORT SYSTEM 97274 ASAP Passport System $000 ASAP Passport System -Total moo 672 ASSESSMENT & TAX 67200 Assessment & Tax $6050 Assessment & Tax -Total $60 50 935 AUGUSTA SAW GRANT 37935 Augusta SAW Grant $000 Augusta SAW Grant - Total $000 073 BICENTENNIAL CELEBRATION 91073 Bicentennial Celebration Grant $000 B¢entenmal Celebration Gral Total $000 944 CAMP CTA DR EQUIPMENT 37944 Camp CTA DR Equipment $1009850 Camp CTA DR Equipment - Total $10,098 50 055 CLEMIS 23004 Oracle Support- OakVideo CLEMIS 52% $51909 23018 Oracle Support- Sheriff CLEM IS 52% $51904 24004 SOL Server Support - 24.5% $36385 95430 CLEMIS Maintenance 515000 95431 CLMS Enhancements $000 98000 Project Team $4125 98003 CLEMIS User Support $= O 1- _' 'i 98005 CLEMIS-E911 Support $000 98000 Prlect Team $0-00 CLEMIS - Total i il_ i ?], 699 CLEMIS-CAD 98006 CLEMIS - CAD Development $000 Prepared By Infoonati0n Technology, 04/15W Pare 13 M 23 2nd puaMr 2021 Of INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2021 CLEMIS - CAD - Total $000 056 CLEMIS FUND 63500 63500 CLEMIS Fund $13 249 25 CLEMIS 63500 Fund -Total $13,24925 448 CLEMIS/FRMS NON -BILLABLE_ 44800 CLEMISIFRMS NON -BILL $000 CLEMIS/FRMS NON -BILL - Tool $000 669 CAMS/CVT DATA CONVERSION 66901 CAMS/CVT Data Conversion $000 CAMS/CVT Data Conversion - Total $000 749 CLERK/REG-CPL 74900 Clerk/Reg -CPL $000 Clerk/Reg - CPL - Total $000 720 CLERK REGISTER OF DEEDS 24003 SQL Server Supp - ROD 35% $5200 36510 GIB Implementation Support $000 36511 ROD Applicator - HM Support $1,930 50 95493 ROD System Maintenance $000 95498 Clerk/Reg - ROD 2 996 25 ClerklReg of Deeds - Total $4,978 75 719 CLERKIROD AUTOMATION FUND 95719 Clerk/ROD Automaton Fund $000 Clerk/ROD Automaton Fund -Total $000 659 COLLABOa ll ASSET MST SYS 65901 Collabortve Asset Mgt Sys $000 Collabortive Asset Mgt Sys - Total $000 435 COMM DEV- HOUSING COUNSELOR 66104 Comm Dev-HousingCounselor $17250 Comm Dev-Housing Counselor -Total $17250 937 COSDS SAW GRANT 37937 COSDS SAW Grant $000 COSDS SAW Grant - Total $000 471 CTS-FOC-EXP-CS ENFORC-EDMS NMG) 92194 CTS-FOC-CS ENF-EDMS SupportlMaintenancmUpgrades $000 CTS-FOC Exp-CS Enfom-EDMS (ling) - Total $000 507 CTS-FOC EXP-CS ENFORCEMENT 92193 CTS-FOC Exp-CD Enforo-Dev $16,03L50 92194 CTS-FOC-CS ENF-EDMS 2 9,$ 48 10 CTS-FOC Exp-CO Enforc-Dev - Total $18 979 60 521 COMM CORR-ADM IGRANTI 52100 Community Corrections C*Star EB $000 Comm Corr - Adm (Grant) - Total $000 045 CV RADIO SYSTEM REPLACEMENT 95045 CV Radio Sysem Replacement $1,691 25 CV Radio Sysem Replacement - Total $1,691 25 673 CYBER SECURITY FUND 67300 Cyber Security Fund $000 Prepared By Inf.-.1.n Technology, 0o115121 Page 16 of 23 2nd 0...12021 pdf INFORMATION TECHNOLOGY -RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2021 Cyber Secunty Fund - Total $000 231 DRAIN EQUIPMENT FUND 37934 Drain Equipment Fund $000 Dram Equipment Fund - Total $000 189 DRAIN EQUIPMENT FUND- POWERPLAN CONTRACT 36189 Drain Equipment Funtl- Powerplan Contract $000 Drain Equipment Fund - Powerplan Contract- Total $000 933 DRAIN EQUIP MAP 37933 Drain Equip Map $904 00 Dram Equip Map -Total $904 00 837 EDCA- MITRADESCHOOL-ORG GRANT 83700 EDCA- MITRADESCHOOL $000 EDCA - MITradeSchool org Grant - Total $0.00 167 EDWARDS DRAIN SAW GRANT 33167 Edwards Drain SAW Grant $000 Edwards Dram SAW Grant- Total $000 100 FARMINGTON HILLS SDS SAW 33099 Farmington Hills SOS SAW $000 Farmington Hills SDS SAW -Total $000 210 FIRE RECORDS MANAGEMENT SYSTEM 21010 Fire Records Mgmt Fund 531 $52 00 95404 SOL Server Support -FRMS 35% $3,96000 24001 FRMS - Phase II Frei S0 00 Fire Records Management System - Total $4,012 00 750 FM&O 21001 Facilities Maintenance & Operations $920 07 24013 SOL Server Supp -FM&O $52.00 75503 FM&O Development S2765425 FM&O - Total $28,626 32 756 FM&O BUILDING MAINTENANCE 75600 FM&O Building Maintenance $000 FM&O Building Mamtenance - Total $000 133 FM&O BUILDING MANAGEMENT SYS 40400 FM&O Building Management Sys $000 FM&O Building Management Sys - Total $000 048 Fli BLDG SECURITY ENH PROJ 75048 FM&O Bldg Security Enh Prot $000 FM&O Bldg Security Enh Prot -Total $000 080 FMO BLDG SYSTEMS REP PH 2 21080 FMO Bldg Systems Rep $4 300 25 FMO Bldg Systems Rep -Total $4,30025 963 FOC SECURITY AUDIT 34963 FOG Security Audit 000 FOG Security Audit - Total $000 942 FRANKLIN SAW GRANT 37942 Franklin SAW Grant $000 Franklin SAW Grant - Total $000 Prepared By Inbrmabon Teane-y, 0411521 Page 15 of 23 2ntl Quacer 2021 pdf 038 HACH WHIMS SOFTWARE SUPPORT 380 HEALTH -IMMUNIZATION GRANT 173 HEALTH- LEAD INNOVATION GRANT 071 HEALTH LEAD PSA GRANT 020 HENRY GRAHAM BRAIN SAW GRANT 947 HIPAA ENHANCEMENTS 120 HR-FINANCIAL SYS REP 214 IAM PROGRAM 338 IMAGING PROJECT 751 IT - TELEPHONE COMMUNICATIONS 202 JAIL MANAGEMENT SYSTEM (JMS) 113 MIDC CLEMIS DEV 634 OAKVIDEO UPGRADE (BA) 938 OAKWIN RADIO SYSTEM ENH 043 OC BICENTENNIAL OAK200 653 O.C.INTNLAIRPORT Prepared By Information Technology 04115121 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT 1 SUPPORT DETAIL - SECOND QUARTER 2021 74038 HACH WINS Software Support HACH WIMS Software Support - Total 38000 Health -Immunization Grant Health -Immunization Grant - Total 96173 Health - Lead Innovation Gant Health - Lead Innovator Grant - Total 96071 Health Lead PSA Gant Health Lead PSA Gant -Total 35020 Henry Graham Dram SAW Grant Henry Graham Drain SAW Grant - Total 96947 HIPPA Enhancements II HIPPA Enhancements II -Total 44120 HR-Financial System Replacement HR-Financial System Replacement - Total 21400 IAM Progam IAM Progam - Total 33800 Imaging Project Imaging Project -Total 75102 Telephone Communications - Customer Support IT - Telephone Communications - Total 63202 Jail Management System (JMS) Jail Management System (JMS) - Total 91113 MIDC Clams Dev MIDC Clemis Dev - Total 63400 CLEMIS- OakVideo Upgrade 63401 IT - Oak Video Upgrade OakVideo Upgrade (BA) - Total 98938 GAKWIN Radio System Enh OAKW IN Radio System Enh -Total 96043 OC Bicentennial OAK200 OC Bicentennial OAK200-Total 36540 GIS Implementaton Support 65301 Airport User Support Page 16 of 23 495 00 $0 00 $0 00 $0 00 $1.072 50 $37 063 50 $466 767 07 $93 950 00 $56 570 75 $0 00 $11,759 00 $89 926 75 $0 00 $0 00 $0-00 $0 00 $0 00 $9198 75 $495 00 $0 00 $0 00 $0 00 $1,67z50 $37,063 50 $466,767 07 $93,950 00 $56,570.75 $0 00 $11 759 00 $89,926 75 $000 $0 00 $0 00 2nd Quaner2021 ptlf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2021 65310 O C Airport - New Development $000 OC Intnl Alrport - Total $9,19&75 934 OLV SDS SAW GRANT 37934 OLV BIDS SAW Grant $000 OLV BOB SAW Grant - Total $000 255 ORACLE UPGRADE TO 19C 63255 Oracle Upgrade to 19C $61 82575 Oracle Upgrade to 19C - Total $61,825.75 770 PARKS AND RECREATION 36530 GIS Implementation Support -Parks $57750 44066 PRADMSystem/Customer Support $20625 44068 PRADMSystem Enhancements $5 032 50 76100 P&R Administrative Services $000 95413 PRADM-Customer Support $4,29000 95416 PRRA -Rec Admm $000 95419 PRADM-Administration $000 Parks & Recreation - Total $10,106 25 867 P&R CAPITAL IMPROVEMENT 86700 P&R Capital Improvement $000 P&R Capital Improvement -Total $000 925 P&R EMS UPGRADE 37925 P&R EMS Upgrade $000 P&R EMS Upgrade - Total $000 442 P&R LYON OAKS CONE CTR CIP#2469 44200 P&R Lyon Oaks Conf Ctr CIP #2469 $0_00 P&R Lyon Oaks Dorf Ctr DIE #2469 - Total $000 443 P&R LYON OAKS CONE CTR CIP#2468 44300 P&R Lyon Oaks Dorf CTR CIP#2468 $000 P&R Lyon Oaks Cent CTR CIP42468 - Total $000 454 P&R SPRINGFIELD OAKS CIP#2471 45400 P&R Springfield Oaks CIP#2471 $000 P&R Springfield Oaks CIP#2471 -Total $000 456 P&R SPRINGFIELD OAKS CIP#2470 45600 P&R Springfield Oaks CIP#2470 $0_00 P&R Spnngfieltl Oaks CIP#2470 - Total $000 457 P&R RED OAKS CLUBHOUSE GIPK467 45700 P&R Red Oaks Clubhouse Cliche 7 $000 P&R Retl Oaks Clubhouse CIP#2467 -Total $000 268 PONTIAC METER 74268 Pontiac BSA to WRC- Water S0 00 Pontiac Meter - Total $000 747 PONTIAC WATER 74701 Pontiac BSA to WRC - Water $000 Pontiac Water - Total $0.00 748 PONTIAC SEWER 74702 Pontiac BSA to WRC-Sewer $000 Pontiac Sewer - Total $000 Prepared By Ir ,nallon Technology, W15/21 Page 17 M23 2nd Quarar2021 P& INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2021 936 PONTIAC WATER ASSET MGMT 37936 Pontiac Water Asset Mgmt 0.00 Pontiac Water Asset Mgmt-Total $000 906 PU BLIC HEALTH GRANT 795 96906 Public Health Grant 795 $000 Public Health Grant 795 - Total $000 329 PONTIAC WWTP TRANSACTION 67329 Pontiac WWiP Transaction $0_00 Pontiac W WTP Transaction - Total $0 00 237 PUBLIC SAFETY TRANS BOARD 65237 Public Safety Trans Dashboard $22 063 25 Public Safety Trans Dashboard - Total $22 063 25 791 RADIO COMMUNICATIONS -E911 79101 Radio Commumcations-E911 $3868975 Radio Communications - E911 - Total $38,689 75 695 RISK MANAGEMENT 44036 Rsk-System Customer Support $12,69425 44028 Risk -System Enhancement $378725 Risk Management -Total $16,481 50 638 TAX MANAGEMENT SYSTEM 63800 Tax Management System $000 Tax Management System - Total $000 973 UCC PROGRAM II 92973 UCC PROGRAM II $33,396 00 UCC PROGRAM II - Total $33,396 00 115 UCC PROGRAM III-VOIP 92115 UCC Program III - VOIP $63 967 50 UCC Program III - VOIP - Total $63,967 50 231 UCC PROGRAM IV - WIRELESS 23100 UCC Program IV - Wireless $2877525 UCC Program IV - Wireless - Total $28,77525 656 WATER RESOURCES ACCOUNTING 23011 Oracle Supp- Water&Sewer Accfg-52% $61909 95669 Water Resources Accounting $000 95671 Drain WaterlSewer Bl $000 Water Resources Accounting - Total $519 09 731 WATER RESOURCE - EQUIPMENT 74501 Water Resources -Ops and PC net 61875 Water Resource - Equipment - Total $618 75 736 WINCAN CENTRAL STORAGE SOLUTION 73601 WmCan Central Storage Solution $000 WIrCan Central Storage Solution - Total $000 930 WATER AND SEWER -GENERAL ADMIN 37930 Water and Sewer -General Admin 348625 Water and Sewer -General Admin - Total $3,486 25 939 WATER AND SEWER GENERAL ADMINISTRATION 37939 Water and Sewer General Administration $000 Water and Sewer General Administration - Total $000 Prepared By Information Technology, M11521 Page 18 of 23 end gnarrer9021 pat 974 WATER AND SEWER GEN ADMIN-WMU 212 WORKFORCE DEV-CLEAN SLATE PROJ 670 WRC ACCTG- CROWDER PRJCT 344 WRCADMINISTRATION 929 WRC AERATION TANK REHAB 980 WRC BINGHAM FARMS SAW 377 WRC-SAW ACACIA 940 WRC-CAMP 926 WRC CLINTON-OAKLAND SCADA 932 WRC CLINTON-OAK SOS SCADA MAIN 168 WRC CRWRRF ADMIN BLDG REHAB 277 WRC-GWK PCF-WRC 281 WRC 501 WRC PERMITTING IMPL 979 WRC PERMITTING IMPLEMENTATION 236 WRC OAKLAND MACOMB INTERCEPTOR Prepared By line manan Technology, 04/15121 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2021 37974 Water and Sewer General Admin -WMU Water and Sewer General Admin - WMU - Total 95212 Workforce De,Clean Slate Prot Workforce De,Clean Slate Proj -Total 60001 WRC- Crowder NetBase Project 67000 WRC- Crowder NetBase Project WRC Acctg - Crowder Prlect- Total 75344 WRC Admimstrabon WRC Admmistrahon - Total 35700 WRC Aeration Tank Rehab WHO Aeration Tank Rehab - Total 33980 WRC Bingham Farms SAW WHO Bingham Famrs SAW -Total 28674 WRC-SAW ACACIA WRC - SAW ACACIA - Total 37940 WRC-Camp WRC - Camp - Total 33926 WRC Clinton -Oakland SCADA WRC Clinton -Oakland SCADA - Total 37932 WRC Clinton -Oak SDS SCADA Main WHO Clinton -Oak SDS SCADA Main -Total 33168 WRC CRWRRF Admin Bldg Rehab WRC CRWRRF Admin Bldg Rehab - Totals 74277 WRC-GWK PCF-WRC WRC-GWK PCF-WRC - Total 74281 WRC WRC - Total 74502 WRC Permitting lmpl WRC Permitting Im PI -Total 74979 WRC Permitting Implementation WRC Permitting Implementation -Total 33236 WRC Oakland Macomb Interceptor WHO Oakland Macomb Interceptor - Total Page 19 of 23 $0 00 681 25 $0 00 $0 00 S82 50 $0 00 $0 00 $0 00 $1 08700 $0 00 $0 00 $0 00 $0 00 $0 00 $1 32000 $1 02075 $4,599 00 $0 00 $2 681 25 $0 00 $82.50 $0 00 $0m $0 00 $1 08700 $0 00 $0 00 $000 $0 00 $0.00 $1,32000 $1,020 75 $4 599-00 2nd Quarter 2021 odf INFORMATION TECHNOLOGY -RESERVE FUND DEVELOPMENT / SUPPORT DETAIL -SECOND QUARTER 2021 981 WRC OXFORD TWP SAW 986 WRC ROYAL OAK TWP SAW 377 WRC-SAW ACACIA 382 WRC SAW BIRMINGHAM 379 WRC- SAW COMMERCE TOWNSHIP 386 WRC-SAW ORCHARD LAKE 674 WRC-SAW GRANT ABOR 381 WRC SAW GINK 686 WRC-SAW GRANT LABOR -COMMON TO ALL 895 WRC AGO 734 WRC-AMR SUPPORT 745 WRC- COSDA l �FPI.ACEMENT 728 WRC - CO SOS SEWMET 729 WRC -EF SOS SEWMET 737 WRC- DATA APPLICATION PILOT PRJ Prepared By lydbrooion Tec rQlogp 0411021 33981 WRC Oxford Twp SAW WRC Oxford Two SAW -Total 33986 WRC Royal Oak Twp SAW WRC Royal Oak Twp SAW -Total 28674 WRC - SAW Acacia WRC - SAW Acacia - Total 33382 WRC SAW Birmingham WRC SAW Birmmgham - Total 33379 WRC-SAW Commerce Township WRC - SAW Commece Township - Total 33386 WRC - SAW Orchard Lake WRC-SAW Onol Lake - Total 28674 WRC-SAW Grant Labor WRC - SAW Grant Labor - Total 33381 WRC SAW GWK WRC SAW GWK - Total 60002 WRC-SAW Grant Labor -Common to All 12686 WRC-SAW Grant -Common to All WRC - SAW Grant Labor Common to All- Total 37895 WRCAGO WRC AGO - Total 73401 WRC-AMR Support WRC-AMR Support - Total 74500 WRC- CO DSA M eter Replacement WRC - CO DSA Meter Replacement - Total 72201 MARS Enhancements - WRC C-O WRC - CO SOS SewMet - Total 72202 MARS Enhancements - WRC E-F WRC - EF SDS SewMet - Total 73700 WRC- Data Application Pilot Project 73710 WRC - Data Al Prj WRC - Data Application Pilot Pp - Total Page 20 N 23 $0 00 $0.00 $0 00 $a 00 $0 00 $0 00 $0 00 $0 00 $0 00 $0 00 $0 00 0 00 $0 00 $0 00 $0 00 $0 00 $0 00 $0 00 $0-00 $0 00 $0.00 Woo $0.00 $0 00 $000 $0 00 $0 00 $0 00 $0 00 $0.00 $0 00 $0 00 end Quader2021 par INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - SECOND QUARTER 2021 300 WRC-GIS ALLOCATION BY LABOR 73300 WRGGIS Allocation by Labor $000 WRC-GIS Allocaton by Labor - Total $000 277 WRC-GWKPCF-WRCSCADA 74277 WRC- GWK PCF-WRC SCADA WRC - GWK PCF-WRC SCADA- Total $000 $000 295 WRC HACH WIMS IMPLEMENTATION 67295 WRGHACH WIMS Implementabon $000 WRGHACH WIMS Implementation - Total $0-00 894 WRC-HACH WIMS IMPLEMENTATION PHASE II 37894 WRC-HACH WIMS Implementation Phase II $000 WRC-HACH WIMS Implementation Phase II -Total $000 733 WRC-HYDRO DRAIN PROJECT 73301 WRGHydm Dram Project $000 WRGHydm Dram Project - Total $000 671 WRC- INFRASTRUCTURE OF AR 67100 WRC -10 AS $000 WRC - Infrastructure Op An - Total $000 299 WRC-MISS DIG TICKET MGMT SYS 74299 WRC-MISS Dig Ticket Mgmt Sys $000 WRC-MISS Dig Ticket Mgmt Sys - Total $000 990 WRC REGIONAL SYSTEMS UNIT 37990 WRC Regional Systems Unit $000 WRC Regional Systems Unit - Total $000 387 WRC SAW EVERGREEN FARMINGTON 33387 WRC SAW Evergreen Farmington $000 WRC SAW Evergreen Farmington -Total $000 389 WRC SAW LAKE ORION 33389 WRC SAW Lake Orion $000 WRC SAW Lake Orlon - Total $0.00 402 WRC SAW HURON ROUGE 33402 WRC SAW Humn Rouge $000 WRC SAW Huron Rouge Total $000 403 WRC SAW BLOOMFIELD VILLAGE 33403 WRC SAW Bloomfield Village $000 WRC SAW Bloomfield Village - Total $0 00 739 WRC -SCADA COMMON 73900 WRC-SCADA Common $0.00 WRC - SCADA Common - Total $000 738 WRC- SCADA ENGINEERING ASSESSMIT 73800 WRC- SCADA Engineering Asseemot $000 WRC - SCADA Engineenn9 Assesmt- Total $000 358 WRC- SCADA MAINTENANCE 33358 WRC- SCADA Maintenance $297000 WRC - SCADA Maintenance - Total $2,970 00 294 WRC-SEWERFUND 74294 WRC - Sewer Fund $310300 WRC - Sewer Fund - Total $3 103-00 Prepared By Infmma4on Technology, 04115121 Page 21 of 23 2nd Quarter 2021 pot INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - SECOND QUARTER 2021 067 WRC UTILITY BILLING REPLACEMENT 33067 WRC Utlllty Billing Replacement WRC Utility Billing Replacement - Total 121 WRC WESSITE STANDARDIZATION 33121 WRC Webade Standardization WRC Webste Standardlzabon - Total 170 WRC WMU METER MAINTENANCE 33170 WRC WMU Meter Maintenance WRC WMU Meter Maintenance - Total s$ 678 00 $6,678 00 $1,002 50 $1,002 50 $000 $0 00 $1Q59,928.31 Prep aretl By Infonnallon Technology, 04/1521 Page 22 of 23 one Quarter2021 pdf INFORMATION TECHNOLOGY DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2021 2nd 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 $342,576.25 $787,139.25 18000 IMACS Data Warehouse (Funded) $0 00 $0 00 19000 IT Application Services Planned Maint $351,115 25 $650,322.25 30001 IT Application Services Data Warehouse $21,242 00 $29,660.25 30002 IT Application Services Enhanced $106.00 $1,00725 30003 IT Application Services GIS $106,432.50 $223,474.25 30004 IT Application Services eGovernment $468,101.00 $870,248.75 25108 Courts - Oakland Schools $0.00 $0.00 36901 BS&A Orion Twp - IT 0.00 0.00 App Services - Sub Total: $1,289,573.00 $2,561,852.00 Internal Services 19020 Internal Services Planned Main 6$ 890.25 $27.852 00 Internal Services - Sub -Total: $6,890.25 $27,852.00 $0.00 Technical Sys/Networking 19030 Tech Sys/Net Planned Maint $86,391.00 $166,516.25 23007 Oracle Support - IT Tech Systems $519.09 $791.21 23017 Oracle Support - IT Tech Systems 1.2% $119.79 $182.59 24018 SQL Sery Support - IT Tech Systems 2 % $29.37 $46.58 25400 Oracle Administration $2,805.00 $8,167.50 95685 I.T. - Disaster Recovery $2,977.25 $3,046.50 95750 I.T. - SEP $87,736.75 $192,215.75 95755 I.T. - PeopleSoft Upgrade $0_00 $0 00 Tech Sys/Net - Sub -Total: $180,578.25 $370,966.38 Information Technology - Total: $1,477,041.50 $2,960,670.38 Prepared By Information Technology, 04/15/21 Page 23 of 23 2nd Quarter 2021 pdf Resolution #21197 May 26, 2021 Moved by Moss seconded by Luebs the resolutions on the amended Consent Agenda be adopted (with accompanying reports being accepted). AYES: Charles, Gershenson, Hoffman, Jackson, Joliat, Kochenderfer, Kowall, Kuhn, Long, Luebs, Markham, McGillivray, Miller, Moss, Nelson, Powell, Spisz, Weipert, Woodward, Cavell. (20) NAYS: None. (0) A sufficient majority having voted in favor, the resolutions on the amended Consent Agenda were adopted (with accompanying reports being accepted). "W, -a (�L I HEREBY APPROVE THIS RESOLUTION CHIEF DEPUTY COUNTY EXECUTIVE ACTING PURSUANT TO MCL 45.559A (7) STATE OF MICHIGAN) COUNTY OF OAKLAND) I, Lisa Brown, Clerk of the County of Oakland, do hereby certify that the foregoing resolution is a true and accurate copy of a resolution adopted by the Oakland County Board of Commissioners on May 26, 2021, with the original record thereof now remaining in my office. In Testimony Whereof, I have hereunto set my hand and affixed the seal of the Circuit Court at Pontiac, Michigan this 26day of May, 2021. Lisa Brown, Oakland County