Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Resolutions - 2022.08.17 - 37533
• BOARD OF COMMISSIONERS August 17, 2022 MISCELLANEOUS RESOLE?TION #22-284 Sponsored By: Gwen Markham Information Technology - Budget Amendment IT Development Report - 3rd Quarter 2022 Chairperson and Members of the Board: 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 Third Quarter 2022 development charges to be $1,358,751.33 for the General Fund/General Purpose County departments: and WHEREAS direct charges to Special Revenue and Proprietary fund departments are $1,698,170,82 and non - county agencies are $3,040.00 for the Third Quarter 2022: and ';WHEREAS an appropriation transfer to General Fioi&General Purpose County departments is needed to fund these development charges. NOW THEREFORE BE IT RESOLVED that the Oakland County Board of Commissioners has reviewed the Third Quarter 2022 Development Report and approves the Third Quarter appropriation transfer as specified on the attached schedule. BE IT FURTHER RESOLVED that the respective departmental Fiscal Year 2022 budgets are to be amended as specified in the attached detailed schedule, Chairperson, the following Commissioners are sponsoring the foregoing Resolution: Gwen Markham. Date: August 17, 2022 David Woodward, Commissioner Date: August 18, 2022 9 'Hilarie Chambers, Deputy County Executive II Date: August 19, 2022 Lisa Brown, County Clerk / Register of Deeds COMMITTEE TRACKING 2022-08-10 Finance - recommend to Board 2022-08-17 Full Board VOTE TRACKING Motioned by Commissioner Charles Cavell seconded by Commissioner Michael Gingell to adopt the attached Budget Amendment: IT Development Report - 3rd Quarter 2022. Yes: David Woodward, Michael Gingell, Michael Spisz, Karen Joliat, Kristen Nelson, Eileen Kowall, Christine Long, Philip Weipert, Gwen Markham, Angela Powell, Thomas Kuhn, Chuck Moss, Marcia Gershenson, Yolanda Smith Charles, Charles Cavell, Penny Luebs, Janet Jackson, Gary McGillivray, Robert Hoffman, Adam Kochenderfer (20) No: None (0) Abstain: None (0) Absent: (0) Passed ATTACHMENTS IT Development Report - 3rd Quarter 2022 STATE OF MICHIGAN) COUNTY OF OAKLAND) I, Lisa Brown, Clerk of the County of Oakland, do hereby certify that the foregoing resolution is a true and accurate copy of a resolution adopted by the Oakland County Board of Commissioners on August 17, 2022. 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 Conn at Pontiac, Michigan on Wednesday, August 17, 2022. M Lisa Brown, Oakland Connor Clerk /Register of'Deeds INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY THIRD QUARTER 2022 3rd Quarter CUST FUND# ACCOUNT DIVISION Apr - Jun Y.T.D. GOVERNMENTALFUNDS General Fund 11011 540 101 10100-3020201-121020-773630 5211 - District Court $4,680.28 $13,463.39 550 101 10100-3020301-121020-773630 52/2 - District Court $4,680.28 $13,463.39 560 101 10100-3020401-121020-773630 5213 - District Court $4,680.28 $13,463.39 530 101 10100-3020501-121020-773630 52/4 - District Court $4,679.91 $13,462.33 630 101 10100-1070801-114000-773630 Animal Control $18,658.65 $29,386.77 005 101 10100-5010101-180010-773630 Bd of Commissioners $11,595.50 $29,160.50 508 101 10100-5010101-165015773630 BOC-Legal Resource Center $0.00 $518.00 450 101 101DO- 1070901-113270-773630 Circuit Court Probation North $0.00 $0.00 184 101 10100-2010210-132300-773630 Clerk's - County Clerk $0.00 $0.00 718 101 10100-2010210-125000-773630 Clerk E-Services $8,312.50 $8,312-50 725 101 10100-2010201-180000-773630 Clerk/Reg -Admin $0.00 $0.00 291 101 10100-2010401-172190-773630 Clerk Register Admin $0.00 $0.00 722 101 10100-2010210-125000-773630 Clerk/Reg - EDMS (Imaging) $7,342.68 $13,434.80 440 101 10100-2010301-185010-773630 Clerk/Reg - Elections $521.75 $2,646.75 410 101 10100-2010501-125000-773630 Clerk/Reg - Jury Commission $0.00 $0.00 724 101 10100-2010210-125000-773630 Clerk/Reg - Legal Records $60,364.61 $241,791.39 726 101 10100-2010601-172190-773630 Clerk/Reg- Micrographics $0.00 $0.00 - 723 101 10100-2010205-132305-773630 - Clerk/Reg - Vital Statistics - $23,277.01 $87,711.09 522 101 10100-1070401-113000-773630 Community Corrections Admin $12,411.85 $72,756.82 361 101 10100-1210101-181000-773630 Communications Department - Dee $20,285.25 $51,862.25 620 101 10100-1010201-181010-773630 Compliance Office - Auditing - $3,624.25- $3,624.25 430 101 10100-1010501-181020-773630 Corporation Counsel $30,248-50 $59,486.25 490 101 10100-3010402-135070-773630 CTS-FD-CT Services - Clinic $1,007.25 $1,035.75 506 101 10100-3010401-121220-773630 - CTS-Faro Div -Judicial Support $1,982.25 $1,98225 483 101 10100-3010403-121100-773630 CTS-FD-Judicial Support -ADM $60.65 $289.52 482 101 10100-3010403-121240-773630 CTS-FD-Juvenile Support $87.00 $1,499.25 015 101 10100-1010101-181000-773630 County Executive $10,270.50 $33,211.75 495 101 10100-3010201-121110-773630 Courts -Business Division $0.00 $0.00 498 101 10100-3010301-121130-773630 Courts-GJ-Judicial Support $221,054.38 $719,858.22 502 101 10100-3010301-121180-773630 Courts-GJ-Jury Operations $128.70 $374.30 493 101 10100-3010101-121100-773630 Courts - Judlcal/Administration $27,674.37 $43,541.51 188 101 10100-1090206-171000-773630 Economic Dev, & Comm Affairs $127.50 $178.00 785 101 10100-1090101-171000-773630 Economic Development & Community Affairs $53,355.75 $64,639-00 740 101 10100-1020501-173010-773630 Equalization Division $99,371-34 $306,470.39 011 101 10100-1110102-145000-773630 Emergency Management $0.00 $247.50 046 101 10100-2010301-133095-773630 Elections-Pandemic/COVIDI 9 $0.00 $0.00 011 101 10100-1110102-145000-773630 Emergency Management $10,147.50 $10,147.50 752 101 10100-1040801-148020-773630 Facility Engineering $2,062.50 $5,981.25 181 101 10100-1040801-140020-773630 FM&O Admin Support $15,251.25 $18,101.25 660 101 10100-1020601-182020-773630 Fiscal Services -Gen Fund $44,184.51 $133,450.40 900 101 10100-1110101-115090-773630 Emergency Mgmt/Homeland Security $12,171.00 $31,914.75 735 101 10100-6010101-155060-T73630 General Fund Map $660.00 $1,980-00 562 101 10100-1060101-133300-773630 Human Services- HS Admin Sew $9,130.75 $44,15525 416 101 10100-1050403-183020-773630 HR Recruitment $0.00 $0.00 680 101 10100-1050401-183010-773630 Human Resources $77,453.37 $120,083.80 907 101 10100-5010303-165040-773630 Library -Library Admin $0.00 $0.00 824 101 10100-5010302-165020-773630 Library Services $0.00 $0.00 565 101 10100-1090108-171030-773630 Marketing & Communcations $512.50 $1,025.00 Prepared By. Information Technology; 07/07/22 Page 1 of 26 3rd Quarter 2022.pdf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY THIRD QUARTER 2022 3rd Quarter CUST FUND# ACCOUNT DIVISION Apr - Jun Y.T.D. 872 101 10100-1070601-132030-773630 Medical Examiner $11,953.40 $17,792.77 409 101 10100-1010702-121170-773630 MIDC OCIT Maint & Suppt $20,504.75 $53,052.50 296 101 10100-1060801-174000-773630 MSU - Digital Media Services $0.00 $0.00 710 101 10100-1060801-174000-773630 MSU Extension - Oakland $41.25 $82.50 349 101 10100-4030501-112680-773630 OCSD Admin Serv-Records Unit $98.75 $124.00 648 101 10100-4030201-112580-773630 OCSD Admin Serv-Sheriff Admin $0.00 $0.00 919 101 10100-9090101-196030-773630 OCSO Body Camera IT Dev $21,285.00 $21,285.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 $34,506.00 $97,902.25 093 101 10100-3040101-121090-773630 Probate Court Admin $819.50 $819.50 479 101 10100-3040101-121090-773630 Probate FD Judicial Support - - $0.00 $0.00 512 101 101003040403-124010-773630 Probate-Estates/Mental Health - EDMS (Imaging) $6,424.87 $11,755.51 510 101 10100-3040403-124010-773630 Probate-Estates/Mental Health Support $15,936.90 $38,365.52 481 101 10100-3040101-121060-773630 Probate -Family Division Judicial $0.00 $0.00 145 101 10100-4010101-122050-773630 Prosecuting Attorney- General Prosecution $32,373.71 $86,261.96 690 101 10100-1020310-182090-773630 Purchasing $536.25 $2,310.00 637 101 10100-1030803-184020-773630 Records Retention $0.00 $0.00 650 101 10100-1020650-126020-773630 Reimbursement Division $2,367.00 $9,84475 195 101 10100-4030301-112590-773630 OCSD-Corrective Sery -Admin $62,679.88 $186,158-07 - 191 101 10100-4030601-110000-773630 - Sheriff- CLEMIS - $5,989.20 $50,326.80 348 101 10100-4030301-11262&T73630 Sheriff- Corrective Sew Admin $4,785.00 $27,59625 988 101 10100-4030901-116240-773630 Sheriff. -IFS Div Lab $0.00 $0.00 647 101 10100-4030601-110000-773630 Sheriff -Patrol Sery - LE Admin - $0.0D $0.00 206 101 10100-4030901-110040-773630 Sheriff - LE Support-SewAdmin $0.00 $0.00 445 101 10100-1030803-184025-773630 Support Services $17,491.73 $39,096.51 - 600 101 10100-7010101-186040-773630 - Treasurer - $98,126:51 $275,988-03 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 458 101 10100-7010101-186090-773630 Treasurers Office $5,472.25 $5,47225 978 101 10100-7010101-186050-773630 Treasurers Office-OakDocs $44,765.25 $117,725.00 910 101 10100-1090702-132050-773630 Veterans Services $4,411.50 $9,965.00 730 101 10100-6010101-155010-773630 Water Resource Commissioner $51,667.40 $125,625.02 742 101 10100-6010101-149920-773630 WRC - CAMS Software Support & Maintenance $5,247.00 $5,444.50 203 101 10100-6010101-174452-773630 WHO EU Pub ED Arm Programs $0.00 $0.00 022 101 10100-6010101-174453-773630 WRC GIS Layer $0.00 $0.00 301 101 10100-6010101-174250-773630 WRC - Soil Erosion Software Sol 0.00 0.00 Sub -Total Fund 101 $1,249,539.47 $3.377,70420 Health Fund 12211 840 221 10100-1060201-133150-773630 Health $42,268.25 $164,621.25 852 221 10100-1060211-133150-773630 Health Central Support $872.50 $1,409.50 843 221 10100-1060220-134390-773630 Health Environmental $44,524.87 $143,262-43 183 221 10100-1060201-133150-773630 Health Website Redesign $0.00 $0.00 239 221 10100-1060201-133095-773630 Pub Hlth-Pandemic/COVID19 $0.00 $0.00 Sub -Total Fund 221 $87,665.62 $309,293.18 Juvenile Maintenance Fund 1`2931 665 293 20293-1070901-112090-773630 Children's Village $21,54624 $49,348.62 668 293 20293-1070901-112010-773630 Children's Village Admin 0.00 0.00 Sub -Total Fund 293 $21,54624 $49,348.62 Prepared By Information Technology, 07I07c22 Page 2 of 26 3N Quaftr 2022.pdf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY THIRD QUARTER 2022 3rd Quarter CUST FUND# ACCOUNT DIVISION Apr -Jun Y.T.D. 63600-1080101-152000-631365 DEVELOPMENT FOR GOVERNMENTAL FUND $1,358,751.33 $3,736,346.00 APPROPRIATION SUB -TOTAL GOVERNMENTAL DEVELOPMENT APPROPRIATION: $1,358,751.33 $3,736,346.00 10100-9090101-196030-773630 Information Technology Development !$1 358.751.33) ($3.736 346.00) TOTAL GOVERNMENTAL: $0.00 WOO NON -GOVERNMENTAL - - - - - DIRECT CHARGES 053 Airport Special Events $0.00 $0.00 687 ARP HSD INV mgmt $15,981.75 $21,352.00 274 ASAP Passport System $0.00 $0.00 672 Assessment & Tax $0.00 $61,515.50 935 Augusta SAW Grant $0.00 $0.00 073 Bicentennial Celebration Grant $0.00 $0.00 944 CAMP CTA DR Equipment $1,870.00 $10,853.75 669 CAMS/CVT Data Conversion $0.00 $0.00 347 Childrens Village Camera - FMO $1,526.25 $6,187.50 309 Clean Slate - MlWorks! $0.00 $0.00 92 - - CLEMIS DEVELOPMENT - $458,266.63 $929,743.32 699 - CLEMIS - CAD $0.00 $177,977.00 448 CLEMIS/FRMS NON -BILLABLE $0.00 $0.00 056 - CLEMIS FUND 63500 _ $207,833.00 _ $212,33150 026 CLEMIS MIDC Bridge $0.00 $0.00 069 CLEMIS- Training $0.00 $0.00 749 Clerk/Reg - CPL $110.50 $166.50 720 Clerk/Reg - Register Of Deeds $2,636.90 $14,679.77 719 Clerk/Rod Automation Fund ($14,837.25) $0.00 659 Collaborative Asset Mgt Sys (CAMS) $1,443.75 $1,608.75 435 Comm Dev - Housing Counselor $0.00 $0.00 521 Community Corrections - Admin(Grant) $3,272.50 $9,232.25 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 $43,781.62 $84,675.76 470 Courts-FOC EXP-FAM Counseling $3,010.50 $3,010.50 045 CV Radio System Replacement $0.00 $0.00 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 $1,659.25 837 EDCA- MlTradeSchool.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 $44,550.40 $72,355.27 750 FM&O $27,587.89 $77,564.64 835 FMO BMS PH 5 $1,650.00 $1,650.00 Preparatl By. information Technology 07/0722 Page 3 of 26 3rd Quarter 2022.paf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY THIRD QUARTER 2022 3rd Quarter CUST FUND# ACCOUNT DIVISION Apr -Jun Y.T.D. 756 FM&O Building Maintenance $0.00 $330.00 133 FM&O Building Management System $0.00 $0.00 O80 FMO Bldg Mgmt Systems Rep Ph 2 $0.00 $288.75 342 FMO Bldg Mgmt Systems Rep Ph 4 $1,180.50 $9,883.25 048 FM&O Bldg Security Enh Proj $0.00 $0.00 757 FM-W K Re[/Jail Mgt/Video Conf $0.00 $0.00 963 FOC Security Audit $13,907.94 $14,000.56 942 Franklin SAW Grant $0.00 $0.00 038 HACH WIMS Software Support $121.00 $286.00 380 Health Immunization Grant $0.00 $0.00 173 - Health - Lead Innovation Grant $0.00 $0.00 071 Health Lead PSA Grant $0.00 $0.00 117 Health -Hepatitis A Prevention $0.00 $0.00 319 Health Medical Marijuana $0.00 $0.00 020 Henry Graham Drain SAW Grant $0.00 $0.00 947 HIPAA Enhancements II $7,276.00 $45,068.00 120 HR-Financial System Replacement $328,091.50 $838,409.50 214 IAM Program $8,453.75 $28,654.00 338 Imaging Project $34,610.00 $169,120.00 - 751 - - IT Telephone Communications - $0.100 $26.50 303 IT ARP Funding $0.00 $34,016.50 415 IT/ARP Projects $90,466.50 $157,036.00 889 = ITIM $0.00 $0.00 202 Jail Management System (JMS) $13,146.00 $38,427.25 185 Leasetrack $6,022.50 $21,862.50 112 - Medical Marijuana PSA $0.00 $0.00 101 Medical Marijuana Mysidewalk $0.00 $0.00 698 MFD Repl $3,904.75 $22,555.25 360 MIDC Application Maint & Support $110.25 $39,935.00 113 MIDC Dev $0.00 $24,428.50 164 Neighborhood Housing Development $0.00 $0.00 661 Neighborhood Housing & Development $1,496.50 $5,412.00 192 Neptune Reports $0.00 $0.00 265 Oakvideo MIDC Support & Maintenance $151.25 $244.25 136 Oakland Township BOB SAW $0.00 $0.00 634 OakVideo Upgrade (Building Authority) $0.00 $0.00 938 OAKWIN Radio System Enhancement $0.00 $0.00 043 O.C. Bicentennial Oak200 $0.00 $0.00 653 O.C. International Airport $4,371.00 $13,279.75 298 OCSO CCTV East Annex Storage $1,856.25 $7,260.00 302 OCSO CCTV Main Jail $0.00 $0.00 934 OLV SDS SAW Grant $0.00 $0.00 255 Oracle Upgrade to 19C $126,168.00 $332,371.75 770 Parks and Recreation - Administration $2,262.00 $10,078.75 867 P&R Capital Improvement $0.00 $0.00 372 P&R- Community Grants $0.00 $4,550.75 925 P&R EMS Upgrade $0.00 $0.00 796 P&R Facilities & Maintenance $0.00 $0.00 442 P&R Lyon Oaks Conf Ctr CIP#2469 $0.00 $0.00 443 P&R Lyon Oaks Conf Ctr CIP#2468 $0.00 $0.00 Prepared By: IMorrnation Technology, OVUM Page of 26 sod Quadcr2022pdf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY THIRD QUARTER 2022 3rd Quarter CUST FUND# ACCOUNT DIVISION Apr -Jun Y.T.D. 454 P&R Springfield Oaks CIP#2471 $0.00 $0.00 456 P&R Springfield Oaks CIP#2470 $0.00 $0.00 457 P&R Red Oaks Clubhouse CIP#2467 $0.00 $0.00 268 Pontiac - Meter $0.00 $0.00 747 Pontiac - Water $0.00 $0.00 748 Pontiac - Sewer $0.00 $0.00 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 Gent 795 $0.00 $0.00 237 _ Public Safety Dashboard _ $1,508.00 $4,07800 _ 791 Radio Communications -E911 $62,854.00 $166,928.50 695 Risk Management $13,183.75 $37,743.50 638 Tax Management System $0.00 $0.00 601 Treasurers -DTRF $0.00 $0.00 973 UCC Program II $0.00 $0.00 115 UCC Program III -VOIP $97,593.24 $435,844.24 231 UCC Program IV - Wireless $30,502.50 $66,969.00 408 Veterans Services Grant Fund $101.00 $2,929.00 656 - Water Resources Accounting - $12870 $374.30 - - - 731 Water Resource - Equipment $0.00 $0.00 736 W InCan Central Storage Solution $0.00 $0.00 _- 930 Water and Sewer -General Adm $6,572.00 $21,310.75 939 Water and Sewer General Administration $0.00 $0.00 974 Water and Sewer Gen Admm-WMU $0.00 $0.00 201 - - Water and Sewer Gen Adm -XC2 - $695.75 $695.75 850 Workforce Dev Division $0.00 $0.00 212 Workforce Dev-Clean Slate Proj $511.25 $3,186.50 281 WRC $0.00 $0.00 670 WRC Acctg- Crowder Prjct $0.00 $0.00 344 WRC Administration $0.00 $3,453.00 929 WRC Aeration Tank Rehab $0.00 $0.00 940 WRC-CAMP $1,815.00 $2,012.50 926 WRC CLINTON-OAKLAND SCADA $0.00 $0.00 932 WRC CLINTON-OAK BIDS SCADA Main $0.00 $0.00 277 WRC-GWK PCF-WRC SCADA $0.00 $0.00 377 WRC-SAWACACIA $0.00 $0.00 820 WRC Manhole Inspection $6,396.00 $7,160.50 382 WRC-SAW Birmingham $0.00 $0.00 379 WRC- SAW Commerce Township $0.00 $0.00 387 WRC- SAW Evergreen Farmington $0.00 $0.00 389 WRC-SAW Lake Orion $0.00 $0.00 388 WRC-SAW Novi $0.00 $0.00 386 WRC-SAW Orchard Lake $0.00 $0.00 674 WRC-SAW Grant Labor $0.00 $0.00 381 WRC SAW GWK $0.00 $0.00 895 WRCAGO $0.00 $0.00 734 WRC-AMR Support $0.00 $0.00 980 WRC Bingham Farms SAW $0.00 $0.00 745 WRC - COSDA Meter Replacement $0.00 $0.00 Prepared By: Information Technology, 07/07/22 Page 5 of 26 3N Quarter 2022 pnf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY THIRD QUARTER 2022 3rd Quarter CUST FUND# ACCOUNT DIVISION Apr Jun Y.T.D. 728 WRC - CO SDS SewMet $0.00 $0.00 168 WRC CRWRRF Admin Bldg Rehab $0.00 $0.00 729 WRC -EF BIDS 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 277 WRG -GWK PCF-WRC SCADA $0.00 $0,00 295 WRC- HACH WIMS Implementation $0.00 $0.00 894 WRC- HACH WIMS Implementation Phase 11 $0.00 $0.00 733 WRC - Hydro Drain Project $0.00 $0.00 671 WRC - Infrastructure Op An $0.00 $0.00 982 WRC Keego Harbor SAW - $0.00 $000 299 WRC - MISS DIG Ticket Mgmt Sys $0.00 $0.00 236 WRG Oaklabnd Macomb Interceptor $0.00 $0.00 981 WRC Oxford Twp SAW $0.00 $0.00 501 WRG Permitting Impl $1,688.50 $4,823.50 979 WRC Permitting Implementation $0.00 $0.00 990 WRC Regional Systems Unit $D.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 - - WRG SAW Huron Rauge - $0.00 $0.00 403 WRC SAW Bloomfield Village $0.00 $000 739 WRG - SCADA Common $0.00 $0.00 738 - WRC - SCADA Engineering Assessment _ $0.00 $0.00 358 _- WRG- SCADA Maintenance $2,565.75 $5,288.25 294 WRC-Sewer Fund $12,476.25 $46,904.25 067 - WRC Utility Billing Replacement - $16,868.50 $33,283-50 023 WRC Walled Lake Water $0.00 $0.00 024 WRC Walled Lake SOB $0.00 $0.00 121 WRC Website Standardization $430.50 $635.50 170 WRC WMU Meter Maintenance $0.00 $0.00 63600-1080101-152000-631302 SUB -TOTAL DIRECT CHARGES FOR DEVELOPMENT $1,698 170.82 $4,347,708.61 TOTAL COUNTY DEVELOPMENT CHARGES $3,056,922.15 $8 084 054.61 NON -COUNTY AGENCIES 63600-1080101-152000-635017 Non -County Agencies $3 040.00 $10 400.00 Prepared By: Intemation Technology; 07/07/22 Page 6 of 26 3r Quarter=.Pdt INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2022 cost# GOVERNMENTAL FUNDS 3rd Qtr 2022 630 ANIMAL CONTROL 24017 SQL Server Supp- Animal Control $60.65 95628 Animal Control $4,298.75 95682 Dog System $14,29925 Animal Control -Total $18,658.65 005 BD OF COMMISSIONERS 91404 BOC - Customer Support $11.595.50 - - Bid of Commissioners - Total - - $11,595.50 508 BOG -LEGAL RESOURCE CENTER 61001 BOC-Legal Resource Center 0.00 BOC-Legal Resource Center - Total $0.00 665 CHILDRENS VILLAGE 95665 Childrens Village $21.546.24 Childrens Village -Total $21,546.24 668 CHILDREN'S VILLAGE ADMIN 97668 Childrens Village Admin _ $0.00 _ Childrens Village Admin - Total moo 184: CLERK'S - COUNTY CLERK - 96184 Clerk's - County Clerk $0.00 - ' - Clerk's - County Clerk - Total $0.00 725 CLERK/REG -ADMIN 72.500 Clerk -Admin 0.00 _ - - Clerk/Reg -Admin - Total - - $0.00 - 440 CLERK/REG - ELECTIONS DIVISION 95443 Clerk/Reg - Elections Division $521.75 Clerk/Reg - Elections Division - Total $521.75 722 CLERK/REG - EDMS (IMAGING) 95158 Clerk/Reg - ELMS Support/Maintenance/Upgrades $7,342.68 13001 Clerk's Efiling 0.00 Clerk/Reg - ELMS (Imaging) - Total $7,342.68 718 CLERK/REG - E-SERVICES 71800 Clerk/Reg - E-Services $8,312.50 Clerk/Reg - E-Services - Total $8,312-50 410 CLERK/REG - JURY COMMISSION 95512 Clerk/Reg-Jury Commission 0.00 Clerk/Reg - Jury Commission - Total $0.00 724 CLERK/REG - LEGAL RECORDS 95189 Circuit Court System $34,274.73 21013 Legal Division - 50% $87.00 31001 Clerk Legal - 50 % $3,332.38 95170 Clerk/Reg - Legal Records $22,670.50 Clerk/Reg - Legal Records - Total $60,364.61 Prepared By: Information Technology, 07/07I22 Page 7 of 26 3rd Qo.rter 2022.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2022 726 CLERK/REG-MICROGRAPHICS 91002 ROD -75% 0.00 Clerk/Reg - Micrographics - Total $0.00 291 CLERK REGISTER OF DEEDS ADMIN 95291 Clerk Register of Deeds Admin 0.00 Clerk Register of Deeds Admin - Total $0.00 723 CLERK -VITAL STATISTICS 24015 SQL Server Supp - Vital Stats 3.5% $60.65 95161 Clerk -Reg - Vital Statistics $23 216.36 Clerk - Vital Statistics - Total $23,277.01 522 COMMUNITY CORRECTIONSADMIN fCO) 23003 Oracle Support -Comm Corr -5.2%_ _ $128.70 24012 SOL Server Supp- Community Corr 3.5% $60.65 52200 Comm Corr-Admin (County) $12,222.50 52201 Comm Corr- DW Support $000 Community Corrections - Total $12,411.85 361 COMMUNICATION DEPARTMENT DEV 95361 Communication Department Dev $20,285.25 Communication Department Dev - Total $20,28525 620 COMPLIANCE OFFICE -AUDITING 44034 Auditing - New Development $3,624.25 95468 Auditing Internal Sry - Cost Sup 0.00 Compliance Office - Auditing - Total $3,624.25 690 COMPLIANCE OFFICE - PURCHASING 44028 Purchasing System Enhancements $536.25 44029 Pur-New Development $0.00 - Compliance Office - Purchasing - Total $536.25- 430 CORPORATION COUNSEL 95501 Corporation Counsel $30,248.50 Corporation Counsel -Total $30,248.50 015 COUNTY EXECUTIVE 95654 County Executive- Development $8,208.00 95656 County Executive Support $2,062.50 County Executive - Total $10,270.50 450 CIRC CT PROBATION - NORTH 80204 Circuit Court Probation - North 0.00 Circuit Court Probation - North - Total $0.00 495 CTS-BUSINESS DIVISION 12002 CCT-Courts/Criminal $0.00 23010 Oracle Support-CCT/CTS Crim W hse 2.6% $000 CTS-Business Division - Total $0.00 490 CTS-FD-CT SERVICES -CLINIC 95171 CTS-FD-CT Services - Clinic $1,007.25 CTS-FD-CT Services - Clinic - Total $1,00725 506 CTS-FAM DIV-JUDICIAL SUPPT 95195 Circuit Court Admin $1,982.25 CTS-Fam Div -Judicial Support - Total $1,982.25 Prepared By: Information Technology; 07/07/22 Page 8 of 26 3od Quarter 2D22pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2022 483 CTS-FDJUDICIALSUPPORT-ADM 24009 SQL Saw Supp- CTS-Jud Sup Adm-3.5% $60.65 CTS-FDJudicial Support-Atlm - Total 482 CTS-FD JUVENILE SUPPORT 48200 CTSJud Support -Juv Support $87.00 CTS-Jud Support - Juv Support - Total 498 CTS-GEN JURISJUDICIAL SUPPT 14001 CTS-DW Support/Circuit $0.00 23010 Oracle Supp-CCT $64.35 12002 CCT-Courts/Criminal $0.00 - - 31002 CT GJ General Supporty - $3,332.37 95179 CTS-Gen Juris-Judicial Suppt $217,657.66 CTS-Gen Juris-Judicial Suppt - Total 502 CTS-GJJURY OPERATIONS 23008 Oracle Support-CTS-GJ-Jury Operations $128.70 CTS-GJ-Jury Operations - Total 493 CTSJUDICIALADMIN 13002 Courts - Efiling $0.00 49300 Courts Web Redesign $0.00 95174 CTS-Judicial Admin $27.674.37 CTSJudicial Admin - Total 188 ECONOMIC DEVELOPMENT & COMM AFFAIRS 981-80 EDCA - One Stop Shop - - $127 50 Economic Development & Comm Affairs - Total 785 ECONOMIC DEVELOPMENT & COMMUNITY AFFAIRS 36500 - CIS Implementation Support C&E Dev, $165.00 36501 GED Application - HIW Support $28.00 95785 Comm & Ere Developmt $53,162.75 Economic Development & Community Affairs - Total 011 EMERGENCY MANAGEMENT 95011 Emergency Mangement $10 147.50 Emergency Mangement - Total 740 EQUALIZATION 23012 Oracle Support -Equalization -5.2% $128.70 24005 SQL Server Supp-Equalization -10.5 % $181.93 31075 Equal - Development $10,762.75 36505 GIS Implementation Support Equalization $330.00 36506 Equal Application - H/W Support $20,417.00 36507 Equal LAMS Support $26,945.75 36601 Land System Enhancements - Equal (50%) $8,734.52 36701 Land System Maintenance - Equal (50%) $670.01 36801 Land System Support - Equal (50%) $3,555.63 36902 BS&A Orlon Twp $0.00 50101 EQUAL(SS&A ANNUAL) $6,911.05 95562 Equalization -DW Support $0.00 95693 Equalization - System Maintenance $0.00 $60.65 $87.00 $221,054.38 $128.70 $27,674.37 $127.50 $53,355.75 $10,147.50 Prepared By: Infounaton Technology; 07/07/22 Page 9 of 26 3rd Quarter 2022.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2022 95699 BS&A Master Appraisal Sup/Maint $20,734.00 Equalization - Total $99,371.34 752 FACILITY ENGINEERING 75201 Facility Engineering $2 062.50 Facility Engineering - Total $2,062.50 660 FISCAL SERVICES ADMIN 23001 Oracle Support - Fiscal Sew -15.6 % $386.10 23013 Oracle Support -HR-Acctg/Budget-5.2% $128.70 24006 SOL Sew Supp - HR-Acctg -1.75 % $30.33 44021 FSSystem/Customer Support $16,698.25 44022 FS- System Maintenance - $1,608.00 - 44023 FS- System Enhancements $0.00 44024 FS - New Development $0.00 44602 Bond Disclosure - Fiscal (50%) $0.00 96001 Fiscal Sew - Acctg 40 % $16,680.50 96003 Fiscal Sew - Budget 20 % $8,340.25 96005 Fiscal Services Acctg $312.38 Fiscal Services Admin - Total $44, 1&4.51 181 FM&O ADMIN SUPPORT 21181 FM&O Admin Support $15,251.25 $15,251.25 840 HEALTH DIVISION 36525 GIS Implementation Support Health $0.00 - - 95563 User Support -Health $11,408.50 - - 96842 Health Admin $30,859.75 Health - Total $42,268.25 852 HEALTH CENTRAL SUPPORT 95852 Health Central Support $872.50 Health Central Support - Total $872.50 843 HEALTH -ENVIRONMENTAL 23005 Oracle Support - EH Projects - 5.2% $128.70 24014 SOL Server Suppt- Ehealth 14% $242.55 84200 EH - Projects $42,338.62 84300 Ehealth Program $1,815.00 Health -Environmental - Total $44,524.87 183 HEALTH WEBSITE REDESIGN 96183 Health Website Redesign $0.00 Health W ebsite Redesign - Total $0.00 900 HOMELAND SECURITY 36545 GIS Implementation Support Homeland Security $288.75 36546 Homeland Security Application - H/W Support $11,88225 98990 Homeland Security $0.00 Homeland Security - Total $12,171.00 416 HR RECRUITMENT 98416 HR Recruitment $0.00 HR Recruitment- Total $0.00 Prepared By Inforrnafion Technology, 07/07/22 Page 10 of 26 3rd Ouaoer2022 pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2022 680 HUMAN RESOURCES 23014 Oracle Support-HR/Personnel-5.2% $128.70 24007 SOL Server Suppport-HR/Personnel -1.75% $30.33 44044 HR- New Development $8,14525 96002 Human Res -Personnel 40% $68,836.72 96006 Human Resources - Personnel $312.37 Human Resources - Total 562 HUMAN SERVICES - HS ADMIN SERV 96561 Human Services-HS Admin Sery $9,130.75 Human Services-HS Admin Sery - Total 907 LIBRARY -LIBRARY ADMIN 91405 Library Board 0.00 Library - Library Admin - Total 824 LIBRARY SERVICES 61001 Library Services $0.00 Library Services - Total 565 MARKETING & COMMUNICATIONS 56500 Marketing & Communications 512.50 Marketing & Communications - Total 872 MEDICAL EXAMINER 24002 SOL Server Support- Medical Exam - 3.5% $60.65 87202 Medical Examiner - Customer Support $11,892.75 - - Medical Examiner - Total - ' 409 MIDC OCIT MAIN/SUPPT 67409 MIDC OCIT Main/Suppt $20,504.75 - - MIDC OCIT Main/Suppt - Total - - 296 MSU - DIGITAL MEDIA SERVICES 22296 MSU - Digital Media Services 0.00 MSU - Digital Media Services - Total 710 MSU EXTENSION - OAKLAND 95676 MSU Ext Equipment Maintenance $41.25 MSU Extension - Oakland - Total 648 OCSD ADMIN SERVSHERIFF ADMIN 97648 OCSD Admin Serv-Sheriff Admin $0.00 OCSD Admin Serv-Sherfff Admin -Total 919 OCSO BODY CAMERA IT DEV 91900 OCSO Body Camera IT Dev $21 285.00 OCSO Body Camera IT Dev - Total 163 OCSO-CLEMIS FORENSIC LAB IMS 16300 OCSO-CLEMIS Forensic Lab 0.00 OCSO-CLEMIS Forensic Lab IMS - Total 775 PLANNING & ECO DEVELOPMENT 95600 PEES Cust/System Support $34 506.00 Planning & Eco Development - Total 093 PROBATE COURT ADMIN 95093 Probate Court Admin $819.50 $77,453.37 $9,130.75 $0.00 $0.00 $512.50 $11,953.40 $20,504.75- $0.00 $41.25 $0.00 $21,285.00 $0.00 $34,506.00 Prepared By Information Technology; 07/07/22 Page 11 of 26 31tl Quarter 2022.pdf INFORMATION TECHNOLOGY- RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2022 Probate Court Admin -Total $819.50 512 PROB-ESTATES/MENTL HLTH EDMS (IMG) 95207 PC-E/MH EDMS Support & Mtce $6 424.87 Prob-Est/Mntl Hlth EDMS (Img) - Total $6,424.87 510 PROB-ESTATES/MENTL HLTH SUPPORT 24010 SQL Sery Supp-PCT-Est/Mental - 3.5 % $60.65 92198 Prob-Est/Mntl Hlth Support $15 876.25 Prob-Est/Mntl Hlth Support - Total $15,936.90 479 PROB-FD JUDICIAL SUPPORT 95188 PROB-FD Judicial Support $000 _ PROB-FD Judicial Support - Total $0.00 481 PROB-FD JUDICIAL 95168 PC -Judicial Family Admin-Family Judges $0.00 Prob - FD Judicial - Total $0.00 145 PROSECUTOR - GENERAL PROSECUTION 24016 SOL Server Supp - Proescutors 3.5 % $60.65 95622 Prosecutor/Executive $16,563.00 95623 Pros/Circuit Ct $2,965.00 97001 Prosecutor Data Proc $5,296.00 _ 95664 Prosecutor Warrants _ $7,489.06 Prosecutor - Total $32,373.71 637 RECORDS RETENTION 44U53 REC - System Enhancements - $0.00 ' 95636 Mail Room $0.00 Records Retention - Total $0.00 650 REIMBURSEMENT 95470 Reimbursement System $2,106.00 95542 Reimburse User Support $261.00 Reimbursement - Total $2,367.00 195 SHERIFF 12001 OCSD-Courts/Criminal-50% $0.00 23009 Oracle Suppport - OCSD/CTS Cnm Whse-2.6% $64.35 97163 Sheriff $4,785.03 97164 Sheriff - Development $0.00 97165 Sheriff-DW Support $0.00 98164 CLEMIS-Sheriff $57830.50 Sheriff - Total $62,679.88 191 SHERIFF-CLEMIS 23015 Oracle Suppport- Sheriff /CLEMIS -52% $128.70 96163 Sheriff - CLEMIS 5$ 860.50 Sheriff - CLEMIS - Total $5,989.20 348 SHERIFF - CORRECTIVE SERV ADMIN 34800 Inmate Phone System $4,785.00 Sheriff - Corrective Sery Admin - Total $4,785.00 988 OC SHERIFF'S IFS DIV -LAB 16300 OCSO Clemis Forensic $0_00 Prepared By: Informabwn Technology, 07/07/22 Page 12 of 26 3rd Quarter 2022.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2022 OC Sheriffs IFS Div - Lab - Total $0.00 349 OCSD ADMIN SERV -RECORDS MGMT 97349 OCSD Admin Sew - Records Mgmt $98.75 OCSD Admin Sew - Records Mgmt- Total $98.75 647 OCSD PATROL SERV-LE ADMIN 97647 Sheriff - Patrol Sew -LE Admin 0.00 Sheriff - Patrol Sew -LE Admin -Total $0.00 445 SUPPORT SERVICES 23002 Oracle Support -Supp Sew -5.2% $128.70 24011 SQL Server Supp -Suppt Services 7% $12128 - 44500 Support Services $17,241.75 Support Services - Total $17,491.73 600 TREASURER 23006 Oracle Support -Del Tax-5.2% $128.70 23016 Oracle Support - Treasurer -10.4% $257.40 36516 Treasurer Application -H/W Support $0.00 36602 Land System Enhancements - Trees (50%) $8,734.48 36702 Land System Maintenance - Treas (50%) $669.99 36802 Land System Support - Tress (50%) $3,555.62 44061 Tre-System/Customer Support $65,387.37 44062 Tre-System Maintenance $2,564.25 ' 44063 TreSystem Enhancements - $4,838.50 44064 Tre-New Development $492.75 44080 Tre-DW Support _ $0.00 _ 44082 Tre-DW Maintenance $0.00 - 44601 Bond Disclosure - Treas (50%) $0.00 50102 TREAS (BS&A ANNUAL) $6,910.95 91001 Treasurers -25% $1,815.00 95008 Del Tax On Line $2,735.00 95303 Del Tax System Maintenance $36.50 95561 User Support/Del Tax $0.00 95615 BS&A Annual Tax Support $0.00 Treasurer - Total $98,126.51 169 TREASURER -BANKING RFP 96169 Treasurer -Banking RFP $0.00 Treasurer - Banking RFP - Total $0.00 627 TREASURER- LANDSALE 44083 Treasurer-Landsale $0.00 Treasurer -Landsale -Total $0.00 458 TREASURERS OFFICE 95458 Treasurers Office $5,472.25 Treasurers Office - Total $5,47225 978 TREASURERS OFFICE-OAKDOCS 95978 Treasurers - OakDocs $44,765.25 Treasurers - OakDocs - Total $44,765.25 Prepared By Information Technology, 07/07/22 Page 13 of 26 3rd Quarter 2022pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2022 910 VETERANS SERVICES 95651 Veterans Customer Support 95650 Veterans Services Equipment Veterans Services - Total 730 WATER RESOURCE COMMISSIONER 24008 SQL Server Supp - WRC 3.5 28007 Water Resource Commission 28009 WRC Administration 28010 WRC-Customer Support 28011 Water Resource Commissioner Application _ 36520 GIS Implementation Support WRC 36521 WRC Application - H/W Support Water Resource Commissioner - Total 742 WRC - CAMS SOFTWARE SUPPORT & MAINTENANCE 74200 WRC CAMS SOFTWARE Support WRC CAMS SOFTWARE Support - Total 735 WRC GEN FUND MAP 74735 WRC Gen Fund Map WRC Gen Fund Map - Total 301 WRC - SOIL EROSION SOFTWARE SOL 74301 WRC - Soil Erosion Software Sol WRC - Soil Erosion Software Sol -Total 540 52/1 DISTRICT COURT-NOVI 95527 DC Suprt- 52/1 - 25% - 52/1 District Court -Total - 550 52/2 DISTRICT COURT - CLARKSTON 95528 DC Suprt- 52/2 - 25 52/2 District Court - Total 560 5213 DISTRICT COURT - ROCHESTER 95288 52 Dist Ct Div 3 95529 DC Suprt - 52/3 - 25% 52/3 District Court- Total 530 52/4 DISTRICT COURT -TROY 95530 DC Suprt- 52f4 - 25% 5214 District Court - Total cult# DIRECT FUNDS 687 ARP HSD INV MGMT 274 ASAP PASSPORT SYSTEM 672 ASSESSMENT & TAX 68701 ARP HSD INV Mgmt ARP HSD INV Mgmt-Total 97274 ASAP Passport System ASAP Passport System - Total 67200 Assessment & Tax Prepared By: Infonnatlon Technology; 07107R2 Page 14 of 26 $3,547.50 864.00 $60.65 $35,802-00 $9,170-00 $0.00 $6,387.25 $247.50 0.00 5 247.00 $660.00 0.00 $4,680.28 $4,680.28 $0.00 4 68028 679.91 $15,98175 0.00 0.00 $4,411.50 $51,667.40 $5,247.00 $660.00 $0.00 $4,680.28 $4,680.28 $4,680.28 $4,679.91 $1,358,751.33 $15,981.75 $0.00 3M Quarter 2022.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2022 Assessment & Tar - Total $0.00 935 AUGUSTA SAW GRANT 37935 Augusta SAW Grant $000 Augusta SAW Grant - Total $0.00 944 CAMP CTA DR EQUIPMENT 37944 Camp CTA DR Equipment $1,870.00 Camp CTA DR Equipment - Total $1,870.00 347 CHILDRENS VILLAGE CAMERA- FMO 21347 Childrens Village Camera - FMO $1,526.25 Childrens Village Camera - FMO - Total $1,526.25 309 CLEAN SLATE -MIWORKS! 96309 Clean Slate - MlWorks! 0.00 Clean Slate - MIW orks! - Total $0.00 902 CLEMIS DEVELOPMENT 23004 Oracle Support- OakVideo CLEMIS 52% $128.70 23018 Oracle Support- Sheriff CLEMIS 5.2% $128.70 24004 SQL Server Support - 24.5% $424.48 90510 $1,623.00 95430 CLEMIS Maintenance _ $1,327.50 _ 95431 _ CLMS Enhancements $6,247.00 98003 CLEMIS User Support $39,047.25 98005 CLEMIS - E911 Support _ $381,293.00 - ' 98000 Poject Team - - -$28.047.00 ' CLEMIS -Total $458,266.63 699 CLEMIS - CAD - - 98006 CLEMIS-CAD Development 0.00 - CLEMIS - CAD - Total $0.00 056 CLEMIS FUND 63500 63500 CLEMIS Fund $207,833.00 CLEMIS 63500 Fund - Total $207,833.00 448 CLEMIS/FRMS NON -BILLABLE 44800 CLEMIS/FRMS NON -BILL $0.00 CLEMIS/FRMS NON -BILL -Total $0.00 026 CLEMIS MIDC BRIDGE 91026 CLEMIS MIDC Bridge 0.00 CLEMIS MIDC Bridge - Total $0.00 069 CLEMIS- TRAINING 91069 CLEMIS-Training 0.00 CLEMIS -Training - Total $0.00 669 CAMS/CVT DATA CONVERSION 66901 CAMS/CVT Data Conversion 0.00 CAMS/CVT Data Conversion - Total $0.00 749 CLERKIREG -CPL 74900 Clerk/Reg -CPL $110.50 Clerk/Reg - CPL - Total $110.50 Prepared By: Information Technology; 07107/22 Page 15 of 26 3rd Quarter 2022.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2022 720 CLERK / REGISTER OF DEEDS 24003 SOL Server Supp - ROD 3.5 % $60.65 36510 GIS Implementation Support $0.00 36511 ROD Application -H/1N Support $1,393.75 95493 ROD System Maintenance $0.00 95498 Clerk/Reg - ROD $1,182.50 Clerk/Reg of Deeds - Total 719 CLERK/ROD AUTOMATION FUND 95719 Clerk/ROD Automation Fund f$14.83725) Clerk/ROD Automation Fund - Total 659 COLLABORATIVE ASSET MGT SYS 65901 Collabortive Asset Mgt Sys _ 1 443.75 Collabortive Asset Mgt Sys - Total 435 COMM DEV - HOUSING COUNSELOR 66104 Housing Counselor 0.00 Housing Counselor- Total 937 COSDS SAW GRANT 37937 COSDS SAW Grant $0.00 COSDS SAW Grant - Total 471 CTS-FOC-EXP-CS ENFORC-EDMS (IMG) 92194 CTS-FOC-CS ENF-EDMS Support/Maintenance/Upgrades $0.00 CTS-FOC Exp-CS Enforc-EDMS (Img)-Total 507 CTS-FOC EXP-CS ENFORCEMENT 34044 CTS-FOC-CS Enforc - Image $0.00 65410 FOC-Image Replacement -74% $4,224.50 - - 92193 CTS-FOC Exp-CD Enforc-Dev $33,132.25 92194 CTS-FOC Enf-EDMS 6$ .424.87 CTS-FOC Eep-CD Enforc-Dev - Total 470 CTS-FOC EXP-FAM COUNSELING 34041 CTS-FOC Earn Counseling $0.00 92195 CTS-FOC Earn Counseling - Dev $3,010.50 CTS-FOC Earn Counseling - Total 521 COMM CORR -ADM (GRANT) 52100 Community Corrections CStar EB $3,272.50 Comm Corr - Ado (Grant) - Total 045 CV RADIO SYSTEM REPLACEMENT 95045 CV Radio System Replacement 0.00 CV Radio System Replacement - Total 673 CYBER SECURITY FUND 67300 Cyber Security Fund $0.00 Cyber Security Fund - Total 931 DRAIN EQUIPMENT FUND 37931 Drain Equipment Fund 0.00 Drain Equipment Fund - Total 933 DRAIN EQUIP MAP 37933 Drain Equip Map $0.00 $2,636.90 ($14,837.25) $1,443.75 $0.00 $0.00 $0.00 $43,781.62 $3,010.50 $3,272.50 $0.00 $0.00 $0.00 Prepared By Information Technology, 07/07/22 Page 16 of 26 3rd Quarter 2022.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2022 Drain Equip Map - Total $0.00 837 EDCA-MITRADESCHOOL.ORG GRANT 83700 EDCA-MITRADESCHOOL $0.00 EDCA - MlTradeSchool.org Grant -Total $0.00 167 EDWARDS DRAIN SAW GRANT 33167 Edwards Drain SAW Grant 0.00 Edwards Drain SAW Grant - Total $0.00 210 FIRE RECORDS MANAGEMENT SYSTEM 21010 Fire Records Mgmt Fund 531 $0.00 95404 SQL Server Support - FRMS 3.5 % $44,489.75 - 24001 FIRMS - Phase II Proj 60.65 Fire Records Management System -Total $44,550.40 750 FM&O 21001 Facilities Maintenance & Operations $412.49 24013 SQL Server Supp - FM&O $60.65 75503 FM&O Development $27,114.75 FM&O - Total $27,587.89 835 FM BMS_PH 5 _ _21835 FMO BMS PH 5 _ 1 650.00 FMO BMS PH 5-Total $1,650.00 756 FM&O BUILDING MAINTENANCE 75600 FM&O Building Maintenance $000 - FM&O Building Maintenance -Total - $0.00 133 FM&O BUILDING MANAGEMENT SYSTEM 21133 FM&O Building Manage $0.00 - - FM&O Building Manage -Total $0.00 080 FM&O BLDG MGMT SYSTEM REP PH 2 21080 FM&O Bldg Mgmt System Rep Ph 2 0.00 FM&O Bldg Mgmt System Rep Ph 2 - Total $0.00 342 FM&O BLDG MGMT SYSTEM REP PH 4 74342 FM&O Bldg Mgmt System Rep Ph 4 1,180.50 FM&O Bldg Mgmt System Rep Ph 4 - Total $1,180.50 048 FM&O SECURITY ENH PROD 75048 FM&O Bldg Secuity, Enh Proj 0.00 FM&O Bldg Secuity Enh Proj - Total $0.00 757 FM/WK REL/JAIL MGTNIDEO CONF 75700 FAC MGMT-Video Arraignment 0.00 FM/WK Rel/Jail Mgt/Video Cent-Totall $0.00 963 FOC SECURITY AUDIT 94963 FOC Security Audit $13 907.94 FOC Security Audit - Total $13,907.94 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 $121.00 Prepared By Information Technology, 07/07/22 Page 17 of 26 3rd Quarter 2022.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2022 HACH W IMS Software Support -Total $121.00 809 HEALTH-CRI 80900 Health-CRI $0.00 Health-CRI - Total $0.00 117 HEALTH -HEPATITIS A PREVENTION 96117 Health - Hap A Prevention $0.00 Health - Hop A Prevention - Total $0.00 380 HEALTH -IMMUNIZATION GRANT 38000 Health -Immunization Grant 0.00 Health -Immunization Grant -Total $0.00 173 HEALTH - LEAD INNOVATION GRANT 96173 Health - Lead Innovation Grant 0.00 Health - Lead Innovation Grant - Total $0.00 071 HEALTH LEAD PSA GRANT 96071 Health Lead PSA Grant 0.00 Health Lead PSA Grant - Total $0.00 947 HIPAA ENHANCEMENTS 11 96947 HIPAA Enhancements II $7,276.00 HIPAA Enhancements 11 -Total $7,276.00 120 HR-FINANCIAL SYSTEM REPLACEMENT 44120 HR-Financial Sys Rep $328,091.50 HR-Financial Sys Rep -Total $328,091.50 214 [AM PROGRAM 21400 ]AM Program $8,453.75 ]AM Program - Total $8,453.75 338 IMAGING PROJECT 33800 Imaging Project $34,610.00 Imaging Project - Total $34,610.00 415 IT/ARP PROJECTS 97415 ITIARP Projects $90,466.50 IT/ARP Projects - Total $90,466.50 303 IT ARP FUNDING 17303 IT ARP Funding $000 IT ARP Funding - Total $0.00 751 IT -TELEPHONE COMMUNICATIONS 75102 Telephone Communications - Customer Support 0.00 IT - Telephone Communications - Total $0.00 889 ITIM 17889 ITIM 0.00 ITIM - Total $0.00 202 JAIL MGMT SYSTEM (JMS) 63202 Jail Mgmt System (JMS) $13,146.00 Jail Mgmt System (JMS) -Total $13,146.00 185 LEASETRACK REPLACEMENT 18500 Leasetrack Replacement $6,022.50 Leasetrack Replacement - Total $6,022.50 Prepared By: nfor abon Technology: n710= Page 18 of 26 3rd Quarter 2022.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2022 112 MEDICAL MARIJUANA PSA 96112 Medical Marijuana PSA 0.00 Medical Marijuana PSA - Total $0.00 698 MFD REPL 90698 MFD Rep[ $3,904.75 MFD Rep[ - Total $3,904.75 113 MIDC CLEMIS DEV 91113 MIDC CLEMIS Day 0.00 MIDC CLEMIS Day - Total $0.00 360 APPLICATION SUPPORT & MAINT _ 67360 MIDC Application Support & Maintenance $110.25 _MIDC MIDC Application Support & Maintenance - Total $110.25 164 NEIGHBORHOOD HOUSING DEVELOPMENT 95164 Neighborhood Housing Development $0.00 Neighborhood Housing Development - Total $0.00 661 NEIGHBORHOOD HOUSING & DEVELOPMENT 66103 Neighborhood Housing & Development $1,496.50 Neighborhood Housing & Development - Total $1,496.50 192 NEPTUNE REPORTS 33192 Neptune Reports $0.00 Neptune Reports - Total $0.00 265 OAKVIDEO MIDC SUPPT & MAINT Q1265 Oakvideo MIDC Support & Maint $151.25 - Oakvideo MIDC Support & Maint - Total $151 25 634 OAKVIDEO UPGRADE (BA) 63400 CLEMIS - OakVideo Upgrade - $0.00 63401 IT - Oakvideo Upgrade $0.00 Oakvideo Upgrade (BA) -Total $0.00 938 RADIO SYSTEM ENH 98938 OAKW IN Radio System Enh $000 _OAKWIN OAKW IN Radio System Enh - Total $0.00 653 O.C. INTNL AIRPORT 36540 GIS Implementation Support $0.00 65310 O.C. Airport- New D $246.00 65301 Airport User Support $4,125.00 O.C. Intnl Airport- Total $4,371.00 298 OCSO CCTV EAST ANNEX STORAGE 97298 OCSO CCTV East Annex Storage $1,856.25 OCSO CCTV East Annex Storage - Total $1,856.25 934 OLV SDS SAW GRANT 37934 OLV SIDS SAW Grant 0100 OLV SIDS SAW Grant- Total $0.00 255 ORACLE UPGRADE TO 19C 63255 Oracle Upgrade to 19C $126 168.00 Oracle Upgrade to 19C - Total $126,168.00 Prepared By: Information Technology, OT107W Page 19 of 26 3rd Quarter 2022.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2022 770 PARKS AND RECREATION 36530 GIS Implementation Support - Parks $41.25 44066 PRADM-System/Customer Support $1,36125 44068 PRADM-System Enhancements $0.00 76100 P&R Administrative Services $0.00 77010 PRADM-Technology $0.00 95413 PRADM-Customer Support $859.50 95416 PRRA -Rec Admin $0.00 95419 PRADM-Administration $0.00 Parks & Recreation - Total $2,262.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 Facilities & Maintenance 0.00 P&R Facilities & Maintenance - Total $0.00 442 P&R LYON OAKS CONF CTR CIP#2469 44200 P&R Lyon Oaks Conf Ctr CIP #2469 $0.00 P&R Lyon Oaks Conf Ctr CIP #2469 - Total $0.00 443 P&R LYON OAKS CONF CTR CIP#2468 -44300 P&R Lyon Oaks Conf CTR CIP#2468 ' - - $000 - P&R Lyon Oaks Conf CTR CIP#2468 - Total $0.00 454 P&R SPRINGFIELD OAKS CIP#2471 - 45400 P&R Springfield Oaks CIP#2471 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 Cl P#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 BSA to WRC-Water $0.00 Pontiac Meter - Total $0.00 747 PONTIAC WATER 74701 Pontiac BSA to WRC - Water 0.00 Pontiac Water - Total $0.00 748 PONTIAC SEWER 74702 Pontiac BSA to WRC - Sewer 0.00 Pontiac Sewer - Total $0.00 095 PONTIAC SEWER 74095 Pontiac Sewer 0.00 Pontiac Sewer- Total $0.00 Prepared By Into.A.n Technology; 07/07/22 Page 20 of 26 3rd Quarter 2022.pdf INFORMATION TECHNOLOGY - RESERVEFUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2022 936 PONTIAC WATER ASSET MGMT 37936 Pontiac Water Asset Mgmt 0.00 Pontiac Water Asset Mgmt - Total $0.00 329 PONTIAC WWTP TRANSACTION 67329 Pontiac WWTP Transaction $0.00 Pontiac WWTP Transaction - Total $0.00 906 PUBLIC HEALTH GRANT 795 96906 Public Health Grant $0.00 Public Health Grant -Total $0.00 237 PUB SAFETY TRANS DASHBOARD 65237 Pub Safety Trans Dashboard jl1,508.00 - - _ Pub Safety Trans Dashboard -Total _ $1,508.00 791 RADIO COMMUNICATIONS -E911 79101 Radio Communications -E911 $62.854.00 Radio Communications - E911 - Total $62,854.00 695 RISK MANAGEMENT 44036 Rsk-System Customer Support $10,759.00 95695 Risk Management $2,424.75 Risk Management- Total $13,183.75 638 TAX MANAGEMENT SYSTEM 63800 Tax Management System 0.00 Tax Management System - Total $0.00 601 TREASURERS-DTRF - -18050 Water Resource Apportionment - $0.00 Treasurers -DTRF - Total - $0.00 973 UCC PROGRAM II - 92973 UCC Program II - $0.00 UCC Program II - Total $0.00 115 UCC PROGRAM III - VOIP 92115 UCC Program It - VOIP $97 593.24 UCC Program III - VOW - Total $97,593.24 231 UCC PROGRAM IV -WIRELESS 23100 UCC Program IV - Wireless $30.502.50 UCC Program IV - Wireless - Total $30,502.50 408 VETERANS SERVICES GRANT FUND 96408 Veterans Services Grant Fund $101.00 Veterans Services Grant Fund - Total $101.00 656 WATER RESOURCES ACCOUNTING 23011 Oracle Supp - Water & Sewer Acct'g - 5.2 % $128.70 95669 Water Resources Accounting $0.00 95671 Drain Water/Sewer BI 0.00 Water Resources Accounting -Total $128.70 731 WATER RESOURCE - EQUIPMENT 74501 Water Resource - Equipment $0.00 Water Resource - Equipment - Total $0.00 736 WINCAN CENTRAL STORAGE SOLUTION 73601 W inCan Central Storage Solution $0.00 Pmpared By: Information Technology; 07/0]/22 Page 21 of 26 3rd Quarter 20 Pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2022 WbCan Central Storage Solution - Total $0.00 930 WATER AND SEWER -GENERAL ADMIN 37930 Water and Sewer -General Admin $6,572.00 Water and Sewer -General Admin - Total $6,572.00 939 WATER AND SEWER GENERAL ADMINISTRATION 37939 Water and Sewer General Administration 0.00 Water and Sewer General Administration - Total $0.00 201 WATER & SEWER - GEN ADM XC2 35201 Water & Sewer Gen Adm XC2 $695.75 Water & Sewer Gen Adm XC2 - Total $695.75 212 WORKFORCE DEV-CLEAN SLATE PROD 95212 Workforce Dev - Clean Slate Proj $511.25 Workforce Dev - Clean Slate Prot - Total $511.25 281 WRC 74281 WRC 0.00 WRC - Total $0.00 670 WRC ACCTG - CROWDER PRJCT 60001 WRC - Crowder NetBase Project $0.00 67000 WRC - Crowder NetBase Project $0.00 WRC Acctg - Crowder Prject - Total $0.00 344 WRC ADMINISTRATION 75344 WRCAdminlstration $0.00 - WRC Administration - Total - - $0.00 929 WRC AERATION TANK REHAB 35700 WRC Aeration Tank Rehab 0.00 - - WRC Aeration Tank Rehab -Total - $0.00 895 WRCAGO 37895 WRCAgo 0.00 WRC Ago - Total $0.00 377 WRC-SAW ACACIA 33377 WRC-SAW ACACIA 0.00 WRC -SAW ACACIA- Total $0.00 940 WRC - CAMP 37940 WRC - Camp $1,815.00 WRC - Camp - Total $1,815.00 926 WRC CLINTON-OAKLAND SCADA 33926 WRC Clinton -Oakland SCADA 0.00 WRC Clinton -Oakland SCADA -Total $0.00 932 WRC CLINTON-OAK SDS SCADA MAIN 37932 WRC Clinton -Oak SDS SCADA Main $0.00 WRC Clinton -Oak SDS SCADA Main - Total $0.00 168 WRC CRWRRF ADMIN BLDG REHAB 33168 WRC CRWRRF Admin Bldg Rehab 0.00 WRC CRWRRF Admin Bldg Rehab -Total $0.00 894 WRC- HACH WIMS IMPLEMENTATION 37894 WRC-HACH WIMS Implementation $000 Prepared By Information Technology; 0710'= Page 22 of 26 3rd Quarter 2022.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2022 WRC-HACH W IMS Implementation - Total $0.00 377 WRC-SAW ACACIA 28674 WRC-SAW Acacia $0.00 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 WRC - SAW Orchard Lake - Total $0.00 674 WRC-SAW GRANT LABOR 28674 WRC-SAW Grant Labor $0.00 WRC - SAW Grant Labor - Total $0.00 381 WRC SAW GWK 33381 WRC SAW GWK 0.00 WRC SAW GWK - Total $0.00 686 WRC - SAW GRANT LABOR - COMMON TO ALL 60002 WRC - SAW Grant Labor - Common to All $0.00 - _ 12686 WRC - SAW Grant -Common to All 0.00 ' - WRC- SAW Grant Labor Common tvAll-Total $0.00 734 WRC-AMRSLIPPORT 73401 WRC-AMR Support $0.00 - - 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 72201 MARS Enhancements - WRC C-O 0.00 WRC - CO SDS SewMet - Total $0.00 729 WRC - EF SDS SEWMET 72202 MARS Enhancements - WRC E-F $0.00 WRC - EF SDS SewMet - Total $0.00 737 WRC - DATA APPLICATION PILOT PRJ 73700 WRC - Data Application Pilot Project $0.00 73710 W RC - Data Appl Prj $0.00 WRC - Data Application Pilot Prj - Total $0.00 300 WRC-GIS ALLOCATION BY LABOR 73300 WRC-GIS Allocation by Labor 0.00 WRC-GIS Allocation by Labor - Total $0.00 277 WRC-GWK PCF-WRC SCADA 74277 WRC-GWK PCF-WRC SCADA $0.00 WRC - GWK PCF-WRC SCADA - Total $0.00 $0.00 Prepared By: Information Technology 0T10= Page 23 of 26 3rd Quarter 2022.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2022 295 WRC HACH WIMS IMPLEMENTATION 67295 WRC-HACH WIMS Implementation $0.00 WRC-HACH WIMS Implementation - Total $0.00 733 WRC-HYDRO DRAIN PROJECT 73301 WRC-Hydro Drain Project $0.00 WRC-Hydro Drain Project -Total $0.00 671 WRC- INFRASTRUCTURE OP AR 67100 WRC-IOAR $0.00 WRC - Infrastructure Op Ar - Total $0.00 820 WRC MANHOLE INSPECTION CAMERA - 74820 WRC Manhole Inspection Camera $6,396.00 _ WRC Manhole Inspection Camera - Total $6,396.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 236 WRC OAKLAND MACOMB INTERCEPTOR 33236 WRC Oakland Macomb Interceptor $000 WRC Oakland Macomb Interceptor - Total $0.00 979 WRC PERMITTING IMPLEMENTATION 74979 WRC Permitting Implementation 0.00 WRC Permitting Implementation -Total $0.00 501 WRC PERMITTING IMPL - 74502 WRC Permitting Imp[ - $1,688.50 - WRC Permitting Impl - Total $1,688.50 739 WRC - SCADA COMMON - 73900 WRC - SCADA Common $0.00 WRC - SCADA Common - Total $0.00 358 WRC - SCADA MAINTENANCE 33358 WRC - SCADA Maintenance $2,565.75 WRC - SCADA Maintenance - Total $2,565.75 738 WRC - SCADA ENGINEERING ASSESSMT 73800 WRC - SCADA Engineering Assesmnt $0.00 WRC - SCADA Engineering Assesmt - Total $0.00 294 WRC-SEWERFUND 74294 WRC - Sewer Fund $12,47625 WRC - Sewer Fund - Total $12,47625 067 WRC UTILITY BILLING REPLACEMENT 33067 WRC Utility Billing Replacement 16,868.50 WRC Utility Billing Replacement -Total $16,868.50 023 WRC WALLED LAKE WATER 35023 WRC Walled Lake Water 0.00 WRC Walled Lake Water - Total $0.00 024 WRC WALLED LAKE SDS 35024 WRC Walled Lake BIDS 0.00 WRC Walled Lake BIDS - Total $0.00 Prepared By: Infonnafion Technology, 07/07122 Page 24 of 26 3rd Quarter 2022.pdf 12� 110 S430 y0 �O�OG.t .F,fse" PRIER ZiFOOOU2L �� $0 p0 S16gg;1t092 WFORM j1i SUPPpR e�eaMaa�aauon-�0ta UtiVE�-gyp g3N� WFIG`Nebsde MamtenBnnGe.7aM � l W ¢G W W Me et Matntena E05�StPN�ARG11�'j\ON 33110 W¢GW WRGIN P��a�edeY 1n otMa�� tefi"Dw9Y p7101122 ply 2502e 3rd Qyaae< 2°v-0, INFORMATION TECHNOLOGY DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2022 3rd 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 $0.00 $24,947.25 17889 ITIM $8,406.50 $8,406.50 18000 IMACS Data Warehouse (Funded) $0.00 $0.00 19000 IT Application Services Planned Maint 304,597.55 $791,361.50 30001 IT Application Services Data Warehouse 1,163.75 $19,856.25 30002 IT Application Services Enhanced 112.50 $316.25 30003 IT Application Services GIS 106,160.25 $298,527.50 30004 IT Application Services eGovernment 322,474.20 $989,235.55 25108 Courts - Oakland Schools $0.00 $0.00 36901 BSBA Orion Twp - IT $0.00 $0.00 96302 OCSO CCTV Main Jail $12,636.75 $23,326.75 App Services - Sub Total: $755,551.50 $2,155,977.55 Internal Services 19020 Internal Services Planned Main $4,282.50 $88,551.00 Internal Services - Sub -Total: $4,282.50 $88,551.00 $0.00 Technical Sys/Networking 19030 Tech Sys/Net Planned Maint $67,516.75 $360,037.50 23007 Oracle Support - IT Tech Systems 128.70 $374.30 23017 Oracle Support - IT Tech Systems 1.2% 29.70 $86.38 24018 SQL Sery Support- IT Tech Systems 2% 34.45 $164.58 25400 Oracle Administration 825.00 $2,145.00 95685 I.T. - Disaster Recovery 0.00 $0.00 95750 I.T. - SEP 202,661.00 $447,264.75 95755 I.T. - PeopleSoft Upgrade 0.00 $0.00 Tech Sys/Net - Sub -Total: $271,195.60 $810,072.51 Information Technology - Total: 1,031,029.60 $3,054,601.06 Prepared By: Information Technology; 07/07/22 Page 26 of 26 3rd Quarter 2022.pdf