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.11.10 - 34994
fro'AKLANDF CO U N T Y M I C H IGA N BOARD OF COMMISSIONERS November 10, 2021 MISCELLANEOUS RESOLUTION #21-450 Sponsored By: Gwen Markham IN RE: IT Development Report - 4th Quarter 2021 Chairperson and Members of the Board: WHEREAS all development costs are 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 2021 development charges to be $1,164,730.94 for the General Fund/General Purpose County departments; and WHEREAS direct charges to Special Revenue and Proprietary fund departments are $1,349,627.34, and non - County agencies are $10,147.75 for the Fourth Quarter of 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 has reviewed the Fourth Quarter 2021 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 2021 budgets are to be amended as specified in the attached, detailed schedule. Chairperson, the following Commissioners are sponsoring the foregoing Resolution: Gwen Markham. Date: November 16, 2021 David Woodward, Commissioner �4 Date: November 16, 2021 Hilarie Chambers, Deputy County Executive II 6 t &� Date: November 16, 2021 Lisa Brown, County Clerk / Register of Deeds COMMITTEE TRACKING 2021-11-03 Finance - recommend to Board 2021-11-10 Full Board VOTE TRACKING Motioned by Commissioner Christine Long seconded by Commissioner Kristen Nelson to adopt the attached Budget Amendment: IT Development Report - 4th Quarter 2021. Yes: David Woodward, Michael Gingell, Michael Spisz, Karen Joliat, Kristen Nelson, Eileen Kowall, Christine Long, Philip Weipert, Gwen Markham, Angela Powell, Chuck Moss, Marcia Gershenson, Yolanda Smith Charles, Charles Cavell, Penny Luebs, Janet Jackson, Robert Hoffman, Adam Kochenderfer (18) No: None (0) Abstain: None (0) Absent: (0) The Motion Passed. ATTACHMENTS Budget Amendment: IT Development Report - 4th Quarter 2021 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 10, 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 on Wednesday, November 10, 2021. Lisa Brown, Oakland Count) Clerk/Register of Deeds CUST FUND# ACCOUNT GOVERNMENTALFUNDS r:Pncral Fund 1`1011 540 101 10100-3020201-121020-773630 550 101 10100-3020301-121020-773630 560 101 10100-3020401-121020-773630 530 101 10100-3020501-121020-773630 630 101 10100-1070801-114000-773630 005 101 10100-5010101-180010-773630 508 101 10100-5010101-165015-773630 450 101 10100-1070901-113270-773630 184 101 10100-2010210-132300-773630 718 101 10100-2010210-125000-773630 725 101 10100-2010201-180000-773630 291 101 10100-2010401-172190-773630 722 101 10100-2010210-125000-773630 440 101 10100-2010301-185010-773630 410 101 10100-2010501-125000-773630 724 101 10100-2010210-125000-773630 726 101 10100-2010601-172190-773630 723 101 10100-2010205-132305-773630 522 101 10100-1070401-113000-773630 620 101 10100-1010201-181010-773630 430 101 10100-1010501-181020-773630 490 101 10100-3010402-135070-773630 506 101 10100-3010401-121220-773630 483 101 10100-3010403-121100-773630 482 101 10100-3010403-121240-773630 015 101 10100-1010101-181000-773630 495 101 10100-3010201-121110-773630 498 101 10100-3010301-121130-773630 502 101 10100-3010301-121180-773630 493 101 10100-3010101-121100-773630 188 101 10100-1090206-171000-773630 785 101 10100-1090101-171000-773630 740 101 10100-1020501-173010-773630 046 101 10100-2010301-133095-773630 752 101 10100-1040801-148020-773630 660 101 10100-1020601-182020-773630 900 101 10100-1110101-115090-773630 562 101 101GO- 1060101-133300-773630 416 101 10100-1050403-183020-773630 680 101 10100-1050401-183010-773630 907 101 10100-5010303-165040-773630 824 101 10100-5010302-165020-773630 565 101 10100-1090108-171030-773630 872 101 10100-1070601-132030-773630 296 101 10100-1060801-174000-773630 Prepared By Information Technology, 10ID7121 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY FOURTH QUARTER2021 DIVISION 52/1 - District Court 5212 - District Court 52/3 - District Court 52/4 - District Court Animal Control Bd of Commissioners BOC-Legal Resource Center Circuit Court Probation North Clerk's - County Clerk Clerk E-Services Clerk/Reg - Admin Clerk Register Admin Clerk/Reg - EDMS (Imaging) Clerk/Reg - Elections Clerk/Reg - Jury Commission Clerk/Reg - Legal Records Clerk/Reg - Micrographics Clerk/Reg - Vital Statistics Community Corrections Admin Compliance Office - Auditing Corporation Counsel CTS-FD-CT Services - Clinic CTS-Fam Div -Judicial Support CTS-FD-Judicial Support -ADM CTS-FD-Juvenile Support County Executive Courts -Business Division Courts-GJJudicial Support Courts-GJ-Jury Operations Courts - Judical / Administration Economic Dev & Comm Affairs Economic Development & Community Affairs Equalization Division Elections-Pandemic/COV ID19 Facility Engineering Fiscal Services -Gen Fund Emergency Mgmt/Homeland Security Human Services - HS Admin Sew HR Recruitment Human Resources Library - Library Admin Library Services Marketing & Communications Medical Examiner MSU - Digital Media Services Page 1 of 23 4th Quarter Jul - Sep $3,244.07 $3,244.07 $3,244.07 $3,243.79 $10,047.06 $15,060.00 $247.50 $156.00 $0.00 $715.75 $0.00 $0.00 $2,791.36 $1,723.75 $0.00 $75,495.41 $0.00 $31,683.91 $20,529.77 $0.00 $12,440.25 $0.00 $0.00 $153.06 ($3 330.99) $49,222.50 $0.00 $236,553.22 $102.96 $16,380.22 $0.00 $3,716.50 $133,024.21 $0.00 $371.25 $78,700.18 $10,984.75 $18,451.75 $0.00 $18,795.99 $0 00 $0.00 $6,329 00 $3,066 56 $0.00 Y,T,D. $16,293.57 $16,293.57 $16,293.57 $16,292.04 $43,576 24 $61,719.25 $536.25 $330.00 $0.00 $2,260.75 $0.00 $0.00 $14,420.80 $8,786.75 $907.50 $269,597.00 $0.00 $124,393.52 $102,336.69 $0.00 $66,101.50 $0 00 $0.00 $2,339 49 $6,997.09 $212,384.00 $0.00 $968,577.91 $1,031.45 $68,887.53 $91.75 $7,374.75 $425,753.30 $0.00 $371.25 $328,652.82 $52,445.00 $25,975.00 $0.00 $144,324.98 $0.00 $0.00 $7,006.00 $16,111.24 $0.00 4th Quarter 2021 per INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY FOURTH QUARTER 2021 4th Quarter CUST FUND# ACCOUNT DIVISION Jul - Sep Y.T.D. 710 101 10100-1060801-174000-773630 MSU Extension - Oakland $0.00 $82.50 349 101 101004030501-112680-773630 OCSD Admin Serv-Records Unit $0.00 $607.75 648 101 10100-4030201-112580-773630 OCSD Admin Serv-Sheriff Admin $0.00 $0 00 163 101 10100-4030901-115140-773630 OCSO - CLEMIS Forensic Lab IMS $0.00 $0.00 775 101 10100-1090201-171000-773630 Planning & Economic Development $21,540.75 $71,074.50 479 101 10100-3040101-121090-773630 Probate FD Judicial Support $0.00 $0.00 512 101 10100-3040403-124010-773630 Probate-Estates/Mental Health - EDMS (Imaging) $2,442.47 $12,618,28 510 101 10100-3040403-124010-773630 Probate-Estates/Mental Health Support $4,822.31 $32,666.74 481 101 10100-3040101-121060-773630 Probate -Family Division Judicial $0.00 $0.00 145 101 10100-4010101-122050-773630 Prosecuting Attorney - General Prosecution $15,494.31 $99,044.24 690 101 10100-1020310-182090-773630 Purchasing $0.00 $1,065.75 637 101 10100-1030803-184020-773630 Records Retention $0.00 $0.00 650 101 10100-1020650-126020-773630 Reimbursement Division $1,384.50 $18,244.25 195 101 10100-4030301-112590-773630 OCSD-Corrective Sew -Admin $44,057.98 $172,267.42 191 101 101004030601-110000-773630 Sheriff-CLEMIS $12,093.71 $80,900.70 348 101 10100-4030301-112620-773630 Sheriff - Corrective Sew Admen $5,813.00 $34,558.75 988 101 101004030901-116240-773630 Sheriff- IFS Div Lab $0.00 $0.00 647 101 101004030601-110000-773630 Sheriff - Patrol Sew - LE Admin $0.00 $0.00 206 101 1010OA030901-110040-773630 Sheriff - LE Support- Sew Admin $0.00 $0.00 445 101 10100-1030803-184025-773630 Support Services $12,381.79 $17,383.01 600 101 10100-7010101-186040-773630 Treasurer $111,389.39 $378,225.71 169 101 10100-7010101-186080-773630 Treasurers - Banking RFP $0.00 $0.00 627 101 10100-7010110-186130-773630 Treasurers - Landsale $0.00 $0.00 978 101 10100-7010101-186050-773630 Treasurers Office-OakDocs $9,119.00 $65,446.50 910 101 10100-1090702-132050-773630 Veterans Services $1 418.75 $11,954.25 730 101 10100-6010101-155010-773630 Water Resource Commissioner $44,453.31 $187,881.74 742 101 10100-6010101-149920-773630 WRC - CAMS Software Support & Maintenance $0.00 $805 00 203 101 10100-6010101-174452-773630 WRC EU Pub ED Adm Programs $0.00 $0.00 022 101 10100-6010101-174453-773630 WRC GIB Layer $0.00 $0.00 301 101 10100-6010101-174250-773630 WRC - Soil Erosion Software Sol $000 $000 Sub -Total Fund 101 $1,042,799.19 $4,213,289.65 Health Fund 12211 840 221 20221-1060201-133150-773630 Health $45,912.75 $208,63800 852 221 20221-1060211-133150-773630 Health Central Support $25.25 $192.75 843 221 20221-1060220-134390-773630 Health Environmental $59,936 33 $275,269.08 183 221 20221-1060201-133150-773630 Health Website Redesign $0.00 $0.00 239 221 20221-1060201-133095-773630 Pub Hlth-Pandemic/COVID19 $0.00 $8,660.00 Sub -Total Fund 221 $105,874.33 $492,759.83 Juvenile Maintenance Fund 12931 665 293 20293-1070901-112090-773630 Children's Village $16,057.42 $63,807.12 668 293 20293-1070901-112010-773630 Children's Village Admin 0.00 $0.00 Sub -Total Fund 293 $16,057.42 $63,807.12 63600-1080101-152000-631365 DEVELOPMENT FOR GOVERNMENTAL FUND $1 164,730.94 $4,769 856.60 APPROPRIATION Prepared By Information Technology, 10/07121 Page 2 of 23 4th Quarter 2021.pdf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY FOURTH QUARTER 2021 4th Quarter CUST FUND# ACCOUNT DIVISION Jul -Sep Y.T.D. SUB -TOTAL GOVERNMENTAL DEVELOPMENT APPROPRIATION: $1,164,730.94 $4,769,856.60 10100-9090101-196030-773630 Information Technology Development ($1.164.730.94) ($4 769 856 60) 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 $29,506.25 $38,454 75 935 Augusta SAW Grant $0.00 $0.00 073 Bicentennial Celebration Grant $0.00 $0.00 944 CAMP CTA DR Equipment $2,475.00 $24,765.75 669 CAMS/CVT Data Conversion $0.00 $0.00 347 Childrens Village Camera - FMO $2,103.75 $2,103.75 309 Clean Slate - MlWorks! $0.00 $16500 055 CLEMIS $7.115.94 $16,218.93 699 CLEMIS - CAD $0.00 $0.00 448 CLEMIS/FRMS NON -BILLABLE $0.00 $2,722.50 056 CLEMIS FUND 63500 $13,184.75 $56,326.00 026 CLEMIS MIDC Bridge $0.00 $8,555.00 069 CLEMIS- Training $0.00 $0.00 749 Clerk/Reg -CPL $0.00 $1,920.00 720 Clerk/Reg - Register Of Deeds $5,221.31 $23,230.99 719 Clerk/Rod Automation Fund $0.00 $0.00 659 Collaborative Asset Mgt Sys (CAMS) $0.00 $0.00 435 Comm Dev- Housing Counselor $0.00 $172.50 521 Community Corrections -Admin (Grant) $3,860.50 $3,860.50 937 COSDS SAW Grant $0.00 $0.00 471 Courts-FOC Exp-CS Enforcement- EDMS (Imaging) $0.00 $0.00 507 Courts-FOC Exp-CS Enforcement $20,794.22 $84,83T28 470 Courts-FOC EXP-FAM Counseling $0.00 $0.00 045 CV Radio System Replacement $0.00 $4,413.75 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 $0.00 $3,765.75 837 EDCA- MITradeSchool.org Grant $0.00 $0.00 167 Edwards Drain SAW Grant $0.00 $0.00 100 Farmington Hills SDS SAW $0.00 $0.00 210 Fire Records Management System $21,346.56 $31,103.74 750 FM&O $19,22T 48 $103,252.61 756 FM&O Building Maintenance $0.00 $0.00 133 FM&O Building Management System $0.00 $0.00 Prepared By: Information Technology, 10/07/21 Page 3 of 23 4th Quarter 2021 pdf CUST FUND# ACCOUNT 080 342 048 757 963 942 038 380 173 071 117 319 020 947 120 214 338 751 303 202 185 112 101 113 164 192 265 136 634 938 043 653 298 934 255 770 867 925 796 442 443 454 456 457 268 747 748 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY FOURTH QUARTER 2021 DIVISION FMO Bldg Mgmt Systems Rep Ph 2 FMO Bldg Mgmt Systems Rep Ph 4 FM&O Bldg Security Enh Pro) FM-WK Re[/Jail Mgt/Video Conf FOC Security Audit Franklin SAW Grant HACH WIMS Software Support Health Immunimbon Grant Health - Lead Innovation Grant Health Lead PSA Grant Health -Hepatitis A Prevention Health Medical Marijuana Henry Graham Drain SAW Grant HIPAA Enhancements II HR-Financial System Replacement LAM Program Imaging Project IT Telephone Communications IT ARP Funding Jail Management System (JMS) Leasetrack Medical Marijuana PSA Medical Marijuana Mysidewalk MIDC Dev Neighborhood Housing Development Neptune Reports Oakvideo MIDC Support & Maintenance Oakland Township SDS SAW OakVideo Upgrade (Building Authority) OAKWIN Radio System Enhancement O.C. Bicentennial Oak200 O.C. International Airport OCSO CCTV East Annex Storage OLV SDS SAW Grant Oracle Upgrade to 19C Parks and Recreation - Administration P&R Capital Improvement P&R EMS Upgrade P&R Facilities & Maintenance P&R Lyon Oaks Conf Ctr CIP#2469 P&R Lyon Oaks Conf Ctr CIP#2468 P&R Springfield Oaks CIP#2471 P&R Springfield Oaks CIP#2470 P&R Red Oaks Clubhouse CIP#2467 Pontiac - Meter Pontiac - Water Pontiac - Sewer 4th Quarter Jul - Se o Y.T.D. $6,80175 $29,137.75 $5,338.75 $5,338.75 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $288.75 $905.75 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7,210 00 $7,210.00 $0.00 $1,07250 $51,636.50 $150,764.00 $315,095.25 $1,595,52830 $44,366.75 $255,447.25 $49,768.50 $176,020.25 $26.50 $225.25 $7,020.50 $8,634.50 $14,556.25 $71,295.75 $7,796.25 $7,796.25 $0.00 $0.00 $0 00 $0.00 $272,985.25 $525,454.00 $661.12 $7,912.62 $0.00 $0.00 $1,953.00 $1,953.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7,159.25 $32,586.00 $10,848.75 $14,726.25 $0.00 $0.00 $43,986.25 $152,729.75 $3,630.00 $30,879.50 $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 $0.00 $0.00 $0.00 $0.00 $0.00 Prepared By: Information Technology, 10/07/21 Page 4 of 23 4th Quarter 2021 par INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY FOURTH QUARTER2021 4th Quarter CUST FUND# ACCOUNT DIVISION Jul - Sep Y.T.D. 095 Pontiac Sewer $0.00 $0.00 936 Pontiac Water Asset Mgmt $0.00 $0.00 329 Pontiac W WTP Transaction $0.00 $0.00 906 Public Health Grant 795 $0.00 $0.00 237 Public Safety Dashboard $5,745.00 $64,014.75 791 Radio Communications - E911 $45,796.50 $143,328.50 695 Risk Management $14,435.25 $60,270.50 638 Tax Management System $0.00 $0.00 601 Treasurers - DTRF $0.00 $0.00 973 UCC Program II $11,431.75 $102,680.00 115 UCC Program III - VOIP $250,260.75 $515,545.75 231 UCC Program IV- Wireless $4,485.00 $49,919.75 656 Water Resources Accounting $432.96 $1,361.45 731 Water Resource - Equipment $0.00 $701.25 736 Wirl Central Storage Solution $0.00 $0.00 930 Water and Sewer -General Adm $8,257.75 $26,203.00 939 Water and Sewer General Administration $0.00 $0.00 974 Water and Sewer Gen Admin-WMU $0.00 $0.00 201 Water and Sewer Gen Adm - XC2 $0 00 $0.00 850 Workforce Dev Division $0.00 $0.00 212 Workforce Dev-Clean Slate Proj $3,254.50 $11,767.75 281 WRC $0.00 $0.00 670 WRC Acctg - Crowder Prtct $0.00 $0.00 344 WRC Administration $1,815.50 $1,898.00 929 WRC Aeration Tank Rehab $0.00 $0.00 940 WRC - CAMP $0.00 $4,732.50 926 WRC CLINTON-OAKLAND SCADA $0.00 $0 00 932 WRC CLINTON-OAK SDS SCADA Main $0.00 $0 00 277 WRGGWK PCF-WRC SCADA $0.00 $0.00 377 WRC - SAW ACACIA $0.00 $0.00 382 WRC-SAW Birmingham $0.00 $0.00 379 WRC-SAW Commerce Township $0.00 $0.00 387 WRC- SAW Evergreen Farmington $0.00 $0.00 389 WRC - SAW Lake Orion $0.00 $0.00 388 WRC-SAW Novi $0.00 $0.00 386 WRC - SAW Orchard Lake $0 00 $0.00 674 WRC - SAW Grant Labor $0 00 $0.00 381 WRC SAW GWK $000 $0.00 895 WRCAGO $0.00 $0.00 734 WRC - AMR Support $0.00 $701.25 980 WRC Bingham Farms SAW $0.00 $0.00 745 WRC - COSDA Meter Replacement $0.00 $0.00 728 WRC - CO SDS SewMet $0.00 $0.00 168 WRC CRWRRF Admin Bldg Rehab $0.00 $0.00 729 WRC - EF SDS SewMet $0.00 $0.00 737 WRC - Data Application Pilot Poject $0.00 $0.00 300 WRC - GIS Allocation by Labor $0.00 $0.00 Prepared By: Information Technology, 10/D7/21 Page 5 of 23 4th Quarter 202Lpdf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY FOURTH QUARTER 2021 4th Quarter CUST FUND# ACCOUNT DIVISION Jul - Sep Y.T.D. 277 WRC -GWK PCF-WRC SCADA $0.00 $0.00 295 WRC- HACH WIMS Implementation $0.00 $0.00 894 WRC -HACH WIMS Implementation Phase II $0.00 $0.00 733 WRC - Hydro Drain Project $0.00 $0.00 671 WRC- Infrastructure Op Ar $0.00 $0.00 982 WRC Keego Harbor SAW $0.00 $0.00 299 WRC - MISS DIG Ticket Mgmt Sys $0.00 $0.00 236 WRC Oaklabnd Macomb Interceptor $1,314.00 $11,096.00 981 WRC Oxford Twp SAW $0.00 $0.00 501 WRC Permitting Impl $1,237.50 $5,568.75 979 WRC Permitting implementation $0.00 $3,940.75 990 WRC Regional Systems Unit $0.00 $0.00 986 WRC Royal Oak Twp SAW $0.00 $0.00 686 WRC - SAW Grant Labor - Common to All $0.00 $0.00 402 WRC SAW Honor Rouge $0.00 $0.00 403 WRC SAW Bloomfield Village $0.00 $0.00 739 WRC-SCADA Common $0.00 $0.00 738 WRC - SCADA Engineering Assessment $0.00 $0.00 358 WRC- SCADA Maintenance $2,021.25 $12,086.25 294 WRC - Sewer Fund $4,982.50 $18,988.25 067 WRC Utility Billing Replacement $18,109.75 $51,439.00 023 WRC Walled Lake Water $0.00 $0.00 024 WRC Walled Lake SDS $0.00 $0.00 121 WRC Website Standardization $82.25 $6,329.00 170 WRC WMU Meter Maintenance $0.00 $0.00 63600-1080101-152000-631302 SUB -TOTAL DIRECT CHARGES FOR DEVELOPMENT $1,349,62T.34 $4.574,060.67 TOTAL COUNTY DEVELOPMENT CHARGES $2,514 358.28 $9,343,91T.27 NON -COUNTY AGENCIES 63600-1080101-152000-635017 Non -County Agencies $10 147.75 $62,674.00 Prepared By Information Technology; 10/0/21 Page 6 of 23 4th Ql after 202Lpdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2021 4th Qtr 2021 cust# GOVERNMENTAL FUNDS 630 ANIMAL CONTROL DIV 24017 SQL Server Supp -Animal Control $153 06 95628 Animal Control $330.00 95682 Dog System $9,564.00 Animal Control -Total $10,047.06 005 BD OF COMMISSIONERS 91404 BOG - Customer Support $15 060 00 Bd of Commissioners - Total $15,060.00 508 BOC-LEGAL RESOURCE CENTER 91405 BOC-Legal Resource Center $247.50 BOC-Legal Resource Center - Total $247.50 665 CHILDRENS VILLAGE 95665 Chldrens Village $16057.42 Childrens Village - Total $16,057.42 668 CHILDREN'S VILLAGE ADMIN 97668 Childrens Village Admin $000 Childrens Village Admin - Total $0.00 725 CLERK/REG -ADMIN 72500 Clerk -Admin 0.00 Clerk/Reg - Admin - Total $0.00 718 CLERK/REG- ESERVICES 71800 E-Services $715.75 E-Services - Total $715.75 440 CLERK/REG- ELECTIONS DIVISION 95443 Clerk/Reg- Elections Division 172375 Clerk/Reg - Elections Division - Total $1,723.75 722 CLERK/REG- EDMS(IMAGING) 95158 Clerk/Reg- EDMS Spt(Mamtenance/Upgrades $2,791.36 13001 Clerk's -Filling 0.00 Clerk/Reg - EDMS (Imaging) - Total $2,791 36 410 CLERK/REG - JURY COMMISSION 95512 Clerla Reg -Jury Commission $000 ClerkJReg - Jury Commission - Total $0.00 724 CLERK/REG - LEGAL RECORDS 95170 Clerk/Reg - Legal Records $28 00 21013 Legal Division -50% ($3,331.01) 31001 Clerk Legal Div -50 $13,591.02 95189 Clerk Legal Records $65 207.40 Clerk/Reg - Legal Records - Total $75,495 41 726 CLERKIREG-MICROGRAPHICS 91002 Clerk/Reg- Micrographics $000 Clerk/Reg - Micrographics - Total $000 291 CLERK REGISTER OF DEEDS ADMIN 95291 Clerk Register of Deeds $000 Clerk Register of Deeds - Total $000 723 CLERK/REG-VITAL STATISTICS 24015 SQL Server Supp - Vital State 35% $153.06 Prepared By Informabon Technology, 10107,21 Page 7 of 23 4th Quarter 2021 pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2021 4th Qtr 2021 95161 Clerk/Reg - Vital Statistics $31 530.85 Clerk - Vital Statistics - Total $31,683.91 184 CLERK'S -COUNTY CLERK 95184 Clerk's - County Clerk 000 Clerk's - County Clerk- Total $0.00 522 COMM CORR-ADMIN (COUNTY) 23003 Oracle Support -Comm Corr- 5.2% $102 96 24012 SOL Server Supp- Community Corr 3.5°% $153.06 52200 Comm Corr-Admin (County) $20,273.75 52201 Comm Corr -DW Support 0.00 Community Corrections - Total $20,529 77 620 COMPLIANCE OFFICE -AUDITING 44034 Auditing - New Development $0.00 95468 Auditing Intrnal Svc 0 00 Compliance Office - Auditing - Total $0 00 430 CORPORATION COUNSEL 95501 Corporation Counsel $12440.25 Corporation Counsel - Total $12,440.25 015 COUNTY EXECUTIVE 95654 County Exec -Development $29,204.75 95655 County Executive Support $20,017 75 County Executive - Total $49,222.50 450 CIRC CT PROBATION - NORTH 80204 Circuit Court Probation - North $156.00 Circuit Court Probation - North - Total $156 00 495 CTS-BUSINESS DIVISION 12002 CCT-Courts/Criminal $0.00 23010 Oracle Support-CCT/CTS Corn Whse 2.6% $0_00 CTS-Business Division - Total $0.00 490 CTS-FD-CT SERVICES -CLINIC 95171 CTS-FD-CT Services -Clinic 0.00 CTS-FD-CT Services -Clinic - Total $0.00 506 CTS-FAM DIV-JUDICIAL SUPPT 95195 Circuit Court Admm 000 Circuit Court Admin - Total $o.00 483 CTS-FD-JUDICIAL SUPPORT -ADM 24009 SOL Sery Supp- CTS-Jud Sup Adm-3.5% $153.06 CTS-FD-Judicial Support-Adm - Total $153 O6 482 CTS-FD JUVENILE SUPPORT 48200 CTS-Jud Support -Juv Support ($3,330.99) CTS-Jud Support - Juv Support - Total ($3.330 9S) 498 CTS-GEN JURISJUDICIAL SUPPT 95179 CTS-Gen Juns-Judiaal Suppt $223,117.00 23010 Oracle Supp-CCT/CTS $51A9 12002 CCT-Courts/Criminal ($20625) 31002 CTS-GJ-General Support $13 590.98 CTS-Gen Juns-Judicial Suppt- Total $236,553 22 Prepared Syr Information Tec6nology; 10/0721 Page 8 of 23 4th Quarter 2021 odf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL • FOURTH QUARTER 2021 502 CTS-GJ-JURY OPERATIONS 23008 Oracle Support-CTS-GJ-Jury Operations CTS-GJ-Jury Operations - Total 493 CTS-JUDICIALADMIN 13002 Courts - Efiling 49300 Courts Web Redesign 95174 CTS-Judicial Admin CTS-Judicial Admin -Total 188 ECONONIC DEV & COMM AFFAIRS 98180 Economic Dev & Comm Affairs Economic Dev & Comm Affairs - Total 785 ECON DEV & COMM AFFAIRS 36500 GIS Implementation Support C&E Dev 36501 CED Application -H/W Support 95785 Comm & Eco Developmt Econ Dev & Comm Affairs -Total 046 ELECTIONS-PANDEMIGICOVIDI9 95046 Elections-Pandemic/COV1D19 Elections-Pandemlo/COVIDI 9 - Total 740 EQUALIZATION 23012 Oracle Support -Equalization -5.2% 24005 SQL Sery Supp-Equalization-10.5% 31075 Equal - Development 36505 GIS Implementation Support Equalization 36506 Equal Application/HW Support 36507 Equal Lams Support/M 36601 Land System Enhancements - Equal (50%) 36701 Land System Maintenance - Equal 150%) 36601 Land System Support- Equal (50%) 36902 BS&A Orion Twp 50101 EQUAL(BS&A ANNUAL) 95562 Equalization -DW Support 95693 Equalization -System Maintenance 95699 BS&A Master Appraisal Sup/Main Equalization - Total 752 FACILITY ENGINEERING 75201 Faahty Engineering 75504 DPW-FE Development 660 FISCAL SERVICES - GEN FUND 23001 Oracle Support - Fiscal Sery - 15.6 % 23013 Oracle Support -HR-Acctg/Budget-5.2% 24006 SQL Sery Supp-HR-Acclg-175% 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 -Acct940% Prepar.d 8y Infwmatron Techrrobgy, IOM?121 Page 9 & 23 4th Qtr 2021 $102.96 $102.96 $0.00 $0 00 $16,380.22 $16,380.22 D.00 $0.00 $412.50 $0.00 3 304 00 $3,716.50 $0.00 $0.00 $102.96 $459 14 $230.25 $165.00 $10,415 75 $23,015.00 $19,614.34 $1,305 01 $15,610.38 $0.00 $304.88 $0 00 $0.00 $61 801.50 $41.25 330.00 $308S8 $102,96 $76 54 $49,723.75 $660-00 $3,566.75 $0.00 $D.00 $16,174.20 $133,024 21 $3TT25 41h Ouarter=l pdt INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2021 4th Qtr 2021 96003 Fiscal Sew - Budget 20% $8087.10 Fiscal Services Admin - Total $78,700.18 852 HEALTH CENTRAL SUPPORT 95852 Health Central Support 2525 Health Central Support- Total $25 25 B40 HEALTH DIVISION 36526 GIS Implementation Support Health $0.00 95563 User Support/Health $36.702.25 96842 Health -Admin $9,21T50 Health - Total $45,912.75 843 HEALTH -ENVIRONMENTAL 23005 Oracle Support - EH Projects - 5.2% $102.96 24014 SQL Server Suppt- Ehealth 14% $612.15 84200 EH - Projects $57,901 22 84300 Ehealth Program 1$ 32000 Health -Environmental - Total $59,936 33 183 HEALTH WEBSITE REDESIGN 96183 Health Webslte Redesign 0 00 Health W ebsite Redesign - Total $0.00 900 HOMELAND SECURITY IHSDI 36545 CIS Implementation Support Homeland Security $288.75 36546 Homeland Security Application -HIW Support $10,69600 95479 Homeland Security Customer $0.00 98990 Homeland Security 0.00 Homeland Security -Total $10,984.75 562 HUMAN SERVICES - HS ADMIN SERVICES 96561 HumanServices - HS Admin Services $18 451.75 HumanServices -HS Admin Se ices -Total $18.45175 680 HUMAN RESOURCES 23014 Oracle Support-HR-Personnel-5.2% $102S6 24007 SQL Server Supp-HR-Personnel-175% $76.54 44044 HR- New Development $0.00 96002 Human Res -Personnel 40% $18 11649 Human Resources -Total $18,795.99 907 LIBRARY -LIBRARY ADMIN 91405 Library Board $000 Library - Library Admin - Total $0 00 824 LIBRARY SERVICES 61001 Library Services $0 00 Library Services -Total $0 00 565 MARKETING&COMMUNICATIONS 56500 Marketing & Communications $6329.00 Marketing & Communications - Total $6,329.00 872 MEDICAL EXAMINER 24002 SQL Server Support -Medical Exam -35% $153.06 87202 Mad Exam - Gust Supt $291&50 Medical Examiner - Total $3,066 56 Prc ar 9y lrrfir atan iechrrology, Colo]/21 Page 10 023 oh Quarter 2021 pat 710 MSU EXTENSION-OAKLAND 349 OCSD ADMIN SERV - RECORDS UNIT 648 OCSO ADMIN SERVSHERIFF ADMIN 968 OC SHERIFF'S - IFS DIV - LAB 163 OCSO-CLEMIS FORENSIC LAB IMS 775 PLANNING & ECO DEVELOPMENT 512 PROB-ESTATES/MENTL HLTH EDMS IIMG( 510 PROS-ESTATES/MENTL HLTH SUPPORT 481 PROB-FDJUDICIAL 479 PROB-FD JUDICIAL SUPPORT 145 PROSECUTOR- GENERAL PROSECUTION 690 PURCHASING 637 RECORDS RETENTION 650 REIMBURSEMENT DIV INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2021 95676 MSU Ext Equipment Maintenance MSU Extension - Oakland - Total 97349 OCSD Admin Sery - Records Unit OCSD Admin Sery - Records Unit- Total 97648 OCSD Admin Serv-SheriffAdmin OCSO Admin ServShenff Admm - Total 163DO OCSO CLEMIS Forensic OCSO CLEMIS Forensic - Total 16300 OCSO-CLEMIS Forensic Lab OCSO-CLEMIS Forensic Lab IMS -Total 05600 PEDS Gust/System Support Planning & Fee Development- Total 9520T PC-E/MH EOMS Support & Mice Prob-EsVMnd RUB EDMS (Img)- Total 24010 SOL SeN Supp-PCT-Est/Mental-3.5% 92198 PC-E/MH Support-Dev Prob-EsUMntl Hlth Support - Total 95168 PC -Judicial Family Admin-Family Judges Prob - FD Judicial - Total 95188 PC -Judicial Adm-Faro PGJudlclat Adm-Faro - Total 2401E SOL Server Supp- Proescutors 3.5% 95622 Prosecutor/Executive 95664 Prosecutor Warrants 97001 Prosecutor Data Proc Prosecutor - Total 44028 Pur-System Enhancements 44029 Fur -New Development Compliance Office - Purchasing- Total 44053 REG- System Enhancements Records Retention - Total 95470 Reim System 95542 Reimburse User Support Reimbursement - Total 4th Qtr 2021 $0.00 0.00 0.00 $0_00 0.00 121,540 75 2 442 47 $153.06 4 669.25 0.00 $0.00 $153.06 $16,229.25 $0 00 12 00 $0 00 0.00 0.00 $1,356.50 28.00 $0 00 $0.00 $0.00 $0 00 $0.00 $21,540 75 $2,442.47 $4,822.31 $0.00 $0 00 $15,494 31 $0.00 $0 00 $1,384.50 Prepamd By Infprmahon Technology, 10107/21 Page t t cif 23 4th Quarter 2021.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2021 4th Qtr 2021 195 SHERIFF 12001 OCSD-Courts/Criminal-50% ($206.25) 23009 Oracle Suppport - OCSD/CTS Cnm Whse-2.6% $51.49 97163 OCSD-Correciive Sew $1,02324 97164 Sheriff -Development $0.00 97165 Sheriff-DW Support $0.00 98164 CLEMIS-Sheriff $43,189.50 Sheriff - Total $44,057 98 191 SHERIFF-CLEMIS 23015 Oracle Suppport- Sheriff /CLEMIS-52% $102.96 96163 Sheriff-CLEMIS $11990.75 Sheriff - CLEMIS - Total $12,093 71 348 SHERIFF -CORRECTIVE SERV ADMIN 34800 Inmate Phone System $5,813.00 Sheriff - Corrective Sew Admin - Total $5,813 00 000 647 OCSD PATROL SERV ADMIN 97647 Sheriff - Patrol Sew Armin 0.00 Sheriff - Patrol Sew Admin - Total $0 00 445 SUPPORT SERVICES ADMIN 23002 Oracle Support -Supp Sew -5.2% $102.96 24011 SOL Server Supp- Suppt Services 7% $306.08 44500 Support Services Use $11972.75 Support Services - Total $12,381 79 600 TREASURERS OFFICE 23006 Oracle Support - Del Tax -5.2% $102.96 23016 Oracle Support - Treasurer -10.4% $205.92 36516 Treasurer Application -H/W Support $0.00 36602 Land System Enhancements - Trees (50%) $19.613.91 36702 Land System Maintenance - Trees (50%) $1,304.99 36802 Land System Support- Trees (50%) $15,610.37 44061 Tre-System Customer Support $38,527.47 44062 Tre-System Maintenance $1,687.50 44063 Tre-System Enhancements $6,307.00 44064 Tre-New Development $3,677.00 44080 Tre-DW Support $0.00 44082 Tre-DW Maintenance $0.00 44601 Bond Disclosure - Trees (50%) $0m 50102 Trees(BS&A Annual $304S7 91001 Treasurers-25% $0m 95008 Del Tax On Line $1,072.50 95303 Del Tax System Maintenance $2,137.00 95561 User Support/Del Tax $16,897.D0 95615 BS&A Annual Tax Support $394D.90 Treasurer - Total $111,389.39 169 TREASURERS -BANKING RFP 96169 Treasurers -Banking RFP 000 Treasurers - Banking RFP - Total $0.00 Prepared By. Indarmadon Technology, 10/07/21 Page 12 of 23 4m Quarter 2021 pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2021 4th Qtr 2021 627 TREASURER-LANDSALE 44083 Treasurer-Landsale $0.00 Treasurer -Landsale - Total $0.00 978 TREASURERS OFFICE-OAKDOCS 95978 Treasurers - Oakdocs 911900 Treasurers - Oakdocs - Total $9,11 S00 910 VETERANS SERVICES 95651 Veterans Customer Support $1,418.75 95650 Veterans Services-Eq 0.00 Veterans Services -Total $1,418.75 730 WATER RESOURCE COMMISSION 24008 SOL Server Supp - WRC 3.5% $153.06 28010 WRC-Customer Suppt $26,93&50 28011 WRC Custom Application $8,662.50 36520 GIS Implementation Support WRC $8,286.75 36521 WRC Program Support $412.50 Water Resource Commissioner- Total $44,453.31 742 WRC CAMS SOFTWARE SUPP & MAINT 74200 WRC CAMS SOFTWARE Support 0.00 WRC CAMS SOFTWARE Supp & Maint - Total $0.00 203 WRC EU PUB ED ADM PROGRAMS 74203 WRC EU Pub Adm Programs 0.00 WRC EU Pub Adm Programs -Total $0.00 301 WRC - SOIL EROSION SOFTWARE SOL 74301 WRC - Sall Erosion Software Sol 0.00 WRC - Soil Erosion Software Sol - Total $0.00 540 52/1-NOVI 95527 Dist Ct Supp -25% $3,244L07 5211 District Court -Total $3,24407 550 5212 CLARKSTON 95528 Dist Ct Supp -25% $3,244.07 52/2 District Court - Total $3,244.07 560 5213 ROCHESTER 95288 52 Dist Ct Div 3 $3,244.07 95529 Dist Ct Supp -25% $000 52/3 District Court - Total $3,244.07 530 5214 TROY 95530 Dist Ct Supp - 25 % 3 243 79 52/4 District Court - Total $3,24379 $1,1$4,730.94 oust# DIRECT FUNDS (NON -GOVERNMENTAL FUNDS) 053 AIRPORT SPECIAL EVENTS 65350 Airport Special Events 000 Airport Special Events - Total $0 00 274 ASAP PASSPORT SYSTEM 97274 ASAP Passport System 0.00 ASAP Passport System - Total $0.00 Prepared By Information Technology: 1 OW121 Page 13 of 23 41h Quarter 2091 Pat INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2021 672 ASSESSMENT & TAX 67200 Assessment & Tax Assessment & Tax - Total 935 AUGUSTA SAW GRANT 37935 Augusta SAW Grant Augusta SAW Grant - Total 944 CAMP LTA DR EQUIPMENT 37944 Camp CTA DR Equipment Camp CTA DR Equipment - Total 347 CHILDRENS VILLAGE CAMEERA- FMO 21347 Childrens Village Camera - FMO Childrens Village Camera - FMO - Total 055 CLEMIS 23004 Oracle Support- OakVideo CLEMIS 52% 23018 Oracle Support- Sheriff CLEMIS 52% 24004 SQL Server Support - 24.5% 90510 CLEMIS-Oakvideo Support 95430 CLEMIS Maintenance 95431 CLMS Enhancements 98003 CLEMIS User Support 98005 CLEMIS -E911 Support 98000 Poject Team CLEMIS - Total 026 CLEMIS MIDC BRIDGE 91026 CLEMIS MIDC Bridge CLEMIS MIDC Bridge - Total 699 CLEMIS - CAD 98D06 CLEMIS - CAD Development CLEMIS - CAD - Total 056 CLEMIS FUND 63500 63500 CLEMIS Fund CLEMIS 63500 Fund -Total 448 CLEMIS/FRMS NON -BILLABLE 44800 CLEMIS/FRMS NON -BILL CLEMIS/FRMS NON -BILL - Total 069 CLEMIS- TRAINING 91069 CLEMIS- Training CLEMIS - Training - Total 669 CAMSICVT DATA CONVERSION 66901 CAMS/CVT Data Conversion CAMS/CVT Data Conversion - Total 749 CLERK/REG -CPL 74900 Clerk/Reg - CPT Clerk/Reg - CPL - Total 720 CLERKIREG - ROD 24003 SQL Server Supp - ROD 3 5% 36510 GIS Implementation Support 36511 ROD Application/HW Support 4th Qtr 2021 $29 506.25 $0.00 2 475.00 2103.75 $102,96 $102.94 $1,071 29 $0.00 $0 00 $0.00 $2,910 00 $412.50 2 516.25 $0 00 $0.00 $13.184.75 0.00 $0.00 0.00 0.00 $153 06 $0 00 $1.155 00 $29,506.25 $aoo $2,475 00 $2,103 75 $7,115 94 $0 00 $0 00 $13,184 75 $0 00 $0 00 $0 00 $0.00 Prepared By. Information Technology, 10107/21 Page 14 of 23 4th Quarter 2021 pd1 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2021 4th Qtr 2021 95493 ROD System Maintenance $0 00 95498 Clerk/Rog - ROD $3 913.25 Clerk/Reg - ROD - Total $5,221.31 719 CLERX/RODAUTOMATION FUND 95719 Register of Deeds Automation 0.00 Register of Deeds Automation - Total $0.00 659 COLLABORATIVE ASSET MGT SYS 65901 Collabortive Asset Mgt Sys 0 00 Collabortive Asset Mgt Sys - Total $0 00 937 COWS SAW GRANT 37937 COSDS SAW Grant 0.00 COSDS SAW Grant - Total $0.00 471 CTS-FOC-EXP-CS ENFORC-EDMS (IMG) 92194 CTS-FOC-CS ENF-EDMS SupporUMaintenance/Upgrades 0.00 CTS-FOC Exp-CS Enforc-EDMS gmg) - Total $0.00 507 CTS-FOC EXP-CS ENFORCEMENT 34044 CTS-FOC-CS-Enforce $0 00 65410 FOC-Image Replace $0.00 92193 CTS-FOC-CS Enforc-Dev $18,351.75 92194 CTS-FOC-CS Enf-EDMS $2,442A7 CTS-FOC Exp-CD Enforc-Dev - Total $20,794.22 470 CTS-FOC EXP-FAM COUNSELING 34041 CTS-FOC EXP-FAM Counseling Won 92195 CTS-FOC EXP-FAM Coun $000 CTS-FOC EXP-FAM Counseling -Total $0 00 521 COMM CORR -ADM (GRANT) 52100 Comm Corr Admin - GR $3,860.50 Comm Corr - Adm (Grant) - Total $3,860.50 435 COMM DEV - HOUSING COUNSELOR 66104 Housing Counselor 0.00 Housing Counselor - Total $0.00 045 CV RADIO SYSTEM REPLACEMENT 95045 CV Radio System Replacement $0.00 CV Radio System Replacement Total $0 00 673 CYBER SECURITY FUND 67300 Cyber Security Fund 000 Cyber Security Fund - Total $0.00 931 DRAIN EQUIPMENT FUND 37931 Drain Equipment Fund D.DO Drain Equipment Fund - Total $0.00 189 DRAIN EQUIPMENT FUND- POWERPLAN CONTRACT 35189 Drain Equipment Fund- Powerplan Contract 0.00 Drain Equipment Fund - Powerplan Contract - Total $0 00 933 DRAIN EQUIP MAP 37933 Drain Equip Map $000 Drain Equip Map - Total $0 00 837 EDCA- MITRADESCHOOLORG GRANT 83700 EDCA- MITRADESCHOOL $000 Prepared By Information Technology, 10/07/21 Page 15 of 23 41T Quarter 2021 pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - FOURTH QUARTER 2021 4th Qtr 2021 EDCA - MITradeSchool.org Grant- Total $0.00 210 FIRE RECORDS MANAGEMENT SYSTEM 21010 Fire Records Mgmt Fund 531 $0.00 95404 FRMS-Phase 11 Prof $21,193.50 24001 SOL Sew Supp-Fire R 1$ 53.06 Fire Records Management System - Total $21,346.56 750 FM&O 21001 Fac Maint&Doer $396.92 24013 SQL Server Supp - FM&O $153.06 75503 FMO Development $18,677.50 FM&O - Total $19,227.48 756 FM&O BUILDING MAINTENANCE 75600 FM&O Building Maintenance 0.00 FM&O Building Maintenance - Total $0.00 133 FM&O BUILDING MAINTENANCE SYSTEM 21133 FM&O Building Maintenance System 0.00 FM&O Building Maintenance System - Total $0.00 080 FMO BLDG MGMT SYSTEMS REPLACEMENT PH 2 21080 FMO Bldg Mgmt Systems Replacement Ph 2 $6,80175 FMO Bldg Mgmt Systems Replacement Ph 2 - Total $6,801.75 342 FMO BLDG MGMT SYSTEMS REPLACEMENT PH 4 74342 FM&O Bldg Mgmt Systems Replacement Ph 4 $5,338.75 FM&O Bldg Mgmt Systems Replacement Ph 4 - Total $5,338.75 963 FOC SECURITY AUDIT 34963 FOC Security Audit 0.00 FOC Security Audit - Total $0.00 942 FRANKLIN SAW GRANT 37942 Franklin SAW Grant $0.00 Franklin SAW Grant - Total $0.00 038 HACH WIMS SOFTWARE SUPPORT 74038 HACH WIMS Software Support $288.75 HACH WIMS Software Support - Total $288.75 117 HEALTH - HEPATITIS A PREVENTION 96117 Health-HEP A Prevention 0.00 Health-HEP A Prevention - Total $0.00 380 HEALTH4MMUNI7ATION GRANT 38000 Health -Immunization Grant 000 Health -Immunization Grant -Total $0.00 319 HEALTH MEDICAL MARIJUANA 96319 Health Medical Marijuana 7 2$ 10.00 Health Medical Marijuana - Total $7,210.00 947 HIPAA ENHANCEMENTS II 96947 HIPAA Enhancements II $51 636 50 HIPAA Enhancements II - Total $51,636 50 120 HR-FINANCIAL SYSTEM REPLACEMENT 44120 FIR -Financial System Replacement $315 095.25 HR-Financial System Replacement -Total $315,095 25 Prepared By Information Technology, 10107/21 Page 16 of 23 4th Quarter 2021 pat INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2021 214 IAM PROGRAM 338 IMAGING PROGRAM 303 IT ARP FUNDING 751 IT - TELEPHONE COMM 202 JAIL MANAGEMENT SYSTEM (JMS) 185 LEASETRACK RELPLACEMENT 112 MEDICAL MARIJUANA PSA 101 MEDICAL MARIJUANA MYSIDEWALK 113 MIDC CLEMIS DEV 164 NEIGHBORHOOD HOUSING DEV 265 OAKVIDEO MIDC SUPPORT & MAINTENANCE 634 OAKVIDEO UPGRADE (BA) 938 OAKWIN RADIO SYSTEM ENH 653 O.C. INTN'L AIRPORT 298 OCSO CCTV EAST ANNEX STORAGE 4th Qtr 2021 21400 IAM Program $44,366.75 [AM Program -Total $44,36&75 33800 Imaging Project $49 768.50 Imaging Protect -Total $49,768.50 17303 IT ARP Funding $7,020.50 IT ARP Funding -Total $7,020.50 75102 Tel Comm - Customer $26.50 IT - Telephone Comm - Total $26 50 63202 Jail Management System (JMS) $14 556 25 Jail Management System (JMS) - Total $14,556.25 18500 Leaselrack Replacement $7,79625 Leasetrack Replacement- Total $7,796.25 96112 Medical Marijuana PSA 000 Medical Marijuana PSA-Total $0.00 96101 Medical Marijuana Mysidewalk 0.00 Medical Marijuana Mysidewalk - Total $0.00 91113 MIDC CLEMIS Dev 272,985.25 MIDC CLEMIS Dev - Total $272,985.25 95164 Neighborhood Housing Development 661.12 Neighborhood Housing Development $661.12 91265 Oakvideo MIDC Support & Maintenance 7 953.D0 Oakvideo MIDC Support & Maintenance - Total $1,953.00 63400 CLEMIS- OakVideo Upgrade $0.00 63401 IT - OakVideo Upgrade 0 00 Oakvideo Upgrade (BA) - Total $0.00 98938 OAKW IN Radio System Enh 0 00 OAKW IN Radio System Enh - Total $0.00 36540 GIS Implementation Support $0.00 65301 Airport User Support $7,15925 65310 O.C. Airport- New Dev $0 00 O.C. Intnl Airport - Total $7,159.25 97298 OCSO CCTV Annex Storage $10 848 75 OCSO CCTV Annex Storage - Total $10,848 75 Prepared By Intorma4on Technology; 10/07121 Page 17 of 23 4th Quarter 2021 pdt INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2021 4th Qtr 2021 934 OLV SDS SAW GRANT 37934 OLV SDS SAW Grant 0.00 OLV SDS SAW Grant- Total $0 00 255 ORACLE UPGRADE TO 19C 63255 Oracle Upgrade to 19C $43 986 25 Oracle Upgrade to 19C - Total $43,986.25 770 PARKS AND RECREATION 36530 CIS Implementation Support- Parks $412.50 44066 PRADM-System/Customer Support $4125 44068 PRADM-System Enhancements $41250 76100 P&R Administrative Services $0.00 95413 PRADM-Customer Support $2,76375 95416 PRRA-Red Admin $0.00 95419 PRADM-Adminlstration 000 Parks & Recreation - Total $0.00 $3,630 00 867 P&R CAPITAL IMPROVEMENT 86700 P&R Capital Improvement 0 00 P&R Capital Improvement - Total $0.00 925 P&R EMS UPGRADE 37925 P&R EMS Upgrade 0.00 P&R EMS Upgrade - Total $0.00 796 P&R FACILITIES & MAINTENANCE 79600 P&R Faclldies & Maintenance 0.00 P&R Facllges & Maintenance -Total $0.00 442 P&R LYON OAKS CONE CTR CIP#2469 44200 P&R Lyon Oaks Conf CV CIP #2469 0 00 P&R Lyon Oaks Cent Ctr CIP #2469 - Total $0.00 443 P&R LYON OAKS CONF CTR CIP#2468 44300 P&R Lyon Oaks Conf CTR CIP#2466 0.00 P&R Lyon Oaks Genf CTR CIP#2468 - Total $0 00 454 P&R SPRINGFIELD OAKS CIP#2471 45400 P&R Springfield Oaks CIP#2471 $0 00 P&R Springfield Oaks CIP#2471 - Total $0.00 456 P&R SPRINGFIELD OAKS CIP#2470 45600 P&R Springfield Oaks CIP#2470 0 00 P&R Springfield Oaks CIP#2470 - Total $0.00 457 P&R RED OAKS CLUBHOUSE CIP#2467 45700 P&R Red Oaks Clubhouse CIP#2467 0.00 P&R Red Oaks Clubhouse CIP#2467 - Total $0 00 268 PONTIAC METER 74268 Pontiac Meter 0.00 Pontiac Meter - Total $0.00 747 PONTIAC WATER 74701 Pontiac BSA to WRC-Water 000 Pontiac Water - Total $0.00 095 PONTIAC SEWER 74095 Pontiac Sewer $000 Pontiac Sewer - Total $0.00 Prepared By Information Technology, 10107/21 Page 18 of 23 4th Quarter 2021.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - FOURTH QUARTER 2021 4th Qtr 2021 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 W WTP TRANSACTION 67329 Pontiac W WTP Transaction 0.00 Pontiac W WTP Transaction - Total $0.00 237 PUBLIC SAFETY DASHBOARD 65237 Public Safety Dashboard $5,745.00 Public Safety Dashboard - Total $5,745.00 791 RADIO COMMUNICATIONS -E911 79101 Radio Communications -E911 $45,796.50 Radio Communications- E911 -Total $45,796.50 695 RISK MANAGEMENT 44036 Rsk-System/Customer Support $13,529.50 44038 Risk System Enhancement $905.75 Risk Management - Total $14,435 25 638 TAX MANAGEMENT SYSTEM 63800 Tax Management System $000 Tax Management System - Total $0 00 973 UCC PROGRAM II 92973 UCC Program II $11 431 75 UCC Program II -Total $11,431.75 115 UCC PROGRAM III - VOW 92115 UCC Program III - VOIP 250,260 75 UCC Program III - VOIP - Total $250,260.75 231 UCC PROGRAM IV - WIRELESS 231 DO UCC Program IV -Wireless 4,485.00 UCC Program IV - Wireless - Total $4,485.00 656 WATER RESOURCES ACCTG 23011 Oracle Supp - Water & Sewer Accfg - 5.2% $102.96 95669 Water Resources Acct $330.DO 95671 Drain Water/Sewer Bl 0.00 Water Resources Accounting - Total $432.96 731 WATER RESOURCE -EQUIPMENT 74501 Water Resouce- Equipment 0.00 Water Resouce - Equipment - Total $0.00 736 WINCAN CENTRAL STORAGE SOLUTION 73601 W inCan Central Storage Solution 0 DO W mCan Central Storage Solution - Total $0 00 930 WATER AND SEWER -GENERAL ADMIN 37930 Water and Sewer -General Admin $8.25775 Water and Sewer -General Admm - Total $8,257 75 939 WATER AND SEWER GENERAL ADMINISTRATION 37939 Water and Sewer General Administration $000 Water and Sewer General Administration -Total WOO Prepared By Information Technology, 10107/21 Page 19 of 23 401 Quarter 2021 pi f INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - FOURTH QUARTER 2021 212 WORKFORCE DEV-CLEAN SLATE PROJ 95212 Workforce Dev-Clean Slate Prof Workforce Dev-Clean Slate Proj - Total 850 WORKFORCE DEV DIVISION 95670 Workforce Development Workforce Development - Total 670 WRC ACCTG-CROWDER PRJCT 50001 WRC- Crowder NetBase Project 67000 WRC - Crowder NetBase Project WRC Acctg - Crowder Prject - Total 344 WRC ADMINISTRATION 75344 WRC Administration WRC Administration - Total 929 WRC AERATION TANK REHAB 35700 WRC Aeration Tank Rehab WRC Aeration Tank Rehab - Total 168 WRC CRWRRF ADMIN BLDG REHAB 33168 WRC CRWRRF Admin Bldg WRC CRWRRF Admin Bldg - Total 236 WRC OAKLAND MACOMB INTERCEPTOR 33235 WRC Oakland Macomb Interceptor WRC Oakland Macomb Interceptor - Total 501 WRC PERMITTING IMPL 745D2 WRC Permitting Imp] WRC Permitting Impl - Total 979 WRC PERMITTING IMPLEMENTATION 74979 WRC Permitting Implementation WRC Permitting Implementation - Total 403 WRC- SAW BLOOMFIELD VILLAGE 33403 WRC- SAW Bloomfield Village WRC - SAW Bloomfield Village - Total 358 WRC- SCADA MAINTENANCE 33358 WRC- SCADA Maintenance WRC - SCADA Maintenance - Total 940 WRC-CAMP 37940 WRC - Camp WRC - Camp - Total 926 WRC CLINTON-OAKLAND SCADA 33926 WRC Clinton -Oakland SCADA WRC Clinton -Oakland SCADA -Total 932 WRC CLINTON-OAK SDS SCADA MAIN 37932 WRC Clinton -Oak SIDS SCADA Main WRC Clinton -Oak SIDS SCADA Main - Total 281 WRC 74281 WRC WRC -Total 377 WRC - SAW ACACIA 28674 WRC - SAW Acacia 4th Qtr 2021 3 254 50 $3,254 50 0.00 $0 00 $0.00 0.00 $0.00 $1,815.50 $1,815.50 $0.00 $0.00 D.00 $0.00 314.00 $1,314.00 237 50 $1,237.50 $000 $0 00 $om $0 00 $2.021.25 $2,021.25 0.00 $0-00 0 00 $0.00 0.00 $0 00 0.00 $0.00 0 00 Prepared By Information Technology, 10107121 Page 20 of23 4th 0uarter 2021 fear INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2021 4th Qtr 2021 WRC - SAW Acacia - Total $0.00 382 WRC SAW BIRMINGHAM 33382 WRC SAW Birmingham $0.00 WRC SAW Birmingham - Total $0.00 379 WRC- SAW COMMERCE TOWNSHIP 33379 WRC- SAW Commerce Township 0.00 WRC - SAW Commerce Township - Total $0.00 386 WRC-SAW ORCHARD LAKE 33386 WRC-SAW Orchard Lake $0.00 W RC - SAW Orchard Lake - Total $0 00 674 WRC-SAW GRANT LABOR 28674 WRC-SAW Grant Labor 000 WRC - SAW Grant Labor - Total $0.00 381 WRC SAW GWK 33381 WRC SAW GWK $D.00 WRC SAW GWK - Total $0.00 686 WRC - SAW GRANT LABOR- COMMON TO ALL 60D02 WRC - SAW Grant Labor- Common to All $0.00 12586 WRC-SAW Grant -Common to All 0.00 WRC - SAW Grant Labor Common to AII- Total $D 00 734 WRC-AMR SUPPORT 73401 WRC-AMR Support $000 WRC - AMR Support - Total $0 00 745 WRC - COSDA METER REPLACEMENT 74500 WRC - CODSA Meter Replacement $0 00 WRC - CODSA Meter Replacement - Total $0.00 728 WRC-CO SDS SEWMET 722D1 MARS Enhancements - WRC C-O 000 WRC - CO SDS SewMet - Total $0.00 729 WRC -EF SDS SEWMET T2202 MARS Enhancements - WRC E-F 0.00 WRC - EF SDS SewMet- Total $0 00 737 WRC- DATA APPLICATION PILOT PRJ 73700 WRC- Data Application Pilot Project $0-00 T3710 WRC - Data Appl Ph 0.00 WRC - Data Application Pilot PO - Total $0 00 300 WRC-GIS ALLOCATION BY LABOR 73300 WRC-GIS Allocation by Labor $000 WRC-GIS Allocation by Labor - Total $0 00 277 WRC-GWK PCF-WRC SCADA 74277 WRC -GWK PCF-WRC SCADA $000 WRC - GWK PCF-WRC SCADA - Total $0.00 295 WRC HACH WIMS IMPLEMENTATION 67295 WRC-HACH WIMS Implementation 0.00 WRC-HACH WIMS Implementation - Total Sun 894 WRC- HACH WIMS IMPLEMENTATION 37894 WRC-HACH WIMS Implementation 000 WRC-HACH WIMS Implementation - Total $0.00 Prepared By Information Technology, 10107/21 Page 21 of 23 4tr Quarter 2021 pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2021 4th Qtr 2021 733 WRC-HYDRO DRAIN PROJECT 73301 WRC-Hydro Drain Project $000 WRC-Hydro Drain Project - Total $0 00 671 WRC- INFRASTRUCTURE OP AR 67100 WRC -10 AR 000 WRC - Infrastructure Op Ar - Total $0.00 299 WRC-MISS DIG TICKET MGMT SYS 74299 WRC-MISS Dig Ticket Mgmt Sys 0 00 WRC-MISS Dig Ticket Mgmt Sys - Total $0.00 739 WRC-SCADA COMMON 73900 WRC-SCADA Common D.00 WRC - SCADA Common - Total $0.00 738 WRC- SCADA ENGINEERING ASSESSMT 73800 WRC- SCADA Engineering Assesmnt 0.00 WRC - SCADA Engineering Assesmt - Total $0.00 358 WRC- SCADA MAINTENANCE 33358 WRC- SCADA Maintenance 0.00 WRC - SCADA Maintenance - Total $0 00 294 WRC-SEWERFUND 74294 WRC - Sewer Fund $4.98L50 WRC - Sewer Fund - Total $4,982.50 067 WRC UTILITY BILLING REPLACEMENT 33D67 WRC Utility Billing Replacement 18.109.75 WRC Utility Billing Replacement $18,109.75 023 WRC WALLED LAKE WATER 35023 WRC Walled Lake Water 0.00 WRC Walled Lake Water- Total $0.00 024 WRC WALLED LAKE SIDS 35024 WRC Walled Lake SDS 000 WRC Walled Lake SDS - Total $0.00 $1,34%627.34 121 WRC WEBSITE STANDARDIZATION 33121 WRC Website Standardization 8225 WRC Website Standardization - Total $82 25 Prepared By Informabon Technology, 10107/21 Page 22 of 23 4th Quarter 2021 pdf INFORMATION TECHNOLOGY DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2021 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 $120,346.25 $1,106,446.00 18000 IMACS Data Warehouse (Funded) $0.00 $0.00 19000 IT Application Services Planned Maint $321,490.25 $1,261,272.00 30001 IT Application Services Data Warehouse $17,098.25 $66,996.00 30002 IT Application Services Enhanced $145.75 $1,382.00 30003 IT Application Services GIS $92,310.00 $431,004.00 30004 IT Application Services eGovernment $478,955.75 $1,788,278.75 25108 Courts - Oakland Schools $0.00 $243.25 36901 BS&A Orion Twp - IT $0.00 $0.00 96302 OCSO CCTV Main Jail $20,988.0 $0.00 App Services - Sub Total: $1.030.346.25 $4,672,168.75 Internal Services 19020 Internal Services Planned Main $22,200.25 $61,277.75 Internal Services - Sub -Total: $22,200.25 $61,277.75 $0.00 Technical Sys/Networking 19030 Tech Sys/Net Planned Maint $103,913.00 $351,848.00 23007 Oracle Support- IT Tech Systems $102.96 $1,031.45 23017 Oracle Support - IT Tech Systems 1.2% $23.76 $233.03 24018 SQL Sery Support - IT Tech Systems 2% $87.10 $252.77 25400 Oracle Administration $165.00 $9,405.00 95685 I.T. - Disaster Recovery $453.75 $3,500.25 95750 I.T. - SEP $100,242.75 $381,438.00 95755 I.T. - PeopleSoft Upgrade 0.00 0.00 Tech Sys/Net - Sub -Total: $204,988.32 $747,713.50 Information Technology - Total: $1,257,534.82 $5,481,160.00 Prepared By: Information Technology; 10/07/21 Page 23 of 23 4th Quarter 2021.pdf