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.05.12 - 35487
BOARD OF COMMISSIONERS May 12, 2022 MISCELLANEOUS RESOLUTION #22-153 Sponsored By: Gwen Markham Information Technology - Budget Amendment IT Development Report - 2nd 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 Second Quarter 2022 development charges to be $1,134,299.44 for the General Fund/General Purpose County departments; and WHEREAS direct charges to Special Revenue and Proprietary fund departments are $1,519,118.07 and non - county agencies are $4,704.25 for the Second Quarter 2022; 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 Second Quarter 2022 Development Report and approves the Second 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. Qlj�� Date: May 12, 2022 David Woodward, Commissioner At ''ppNA Date: May 18, 2022 Hilarie Chambers, Deputy County Executive II r Date: May 18, 2022 Lisa Brown, County Clerk / Register of Deeds COMMITTEE TRACKING 2022-05-04 Finance - Recommend to Board 2022-05-12 Full Board VOTE TRACKING Motioned by Commissioner Kristen Nelson seconded by Commissioner Michael Gingell to adopt the attached Budget Amendment: IT Development Report - 2nd 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, Charles Moss, Marcia Gershenson, William Miller III, Yolanda Smith Charles, Charles Cavell, Penny Luebs, Janet Jackson, Gary McGillivray, Robert Hoffman, Adam Kochenderfer (21) No: None (0) Abstain: None (0) Absent: (0) Passed ATTACHMENTS 1. IT Development Report - 2nd 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 May 12, 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 Court at Pontiac, Michigan on Thursday, May 12, 2022. Lisa Brown, Oakland Cowity Clerk /Register of Deeds INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY SECOND QUARTER 2022 2nd Quarter CUST FUND# ACCOUNT DIVISION Jan - Mar Y.T.D GOVERNMENTAL FUNDS General Fund r1011 540 101 10100-3020201-121020-773630 5211 - District Court $3,617.62 $8,783.11 550 101 10100-3020301-121020-773630 52/2 - District Court $3,617.62 $8,783.11 560 101 10100-3020401-121020-773630 52/3 - District Court $3,617.62 $8,783.11 530 101 10100-3020501-121020-773630 5214 - District Court $3,617.39 $8,782.42 630 101 10100-1070801-114000-773630 Animal Control $6,550.75 $10,728.12 005 101 10100-5010101-180010-773630 Bid of Commissioners $9,479.50 $17,565.00 508 101 10100-5010101-165015-773630 BOC-Legal Resource Center $0.00 $518.00 450 101 10100-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 $0.00 $0.00 725 101 10100-2010201-180000-773630 Clerk/Reg -Admin $0.00 $0.00 291 101 10100-2010401-172190-T73630 Clerk Register Admin $0.00 $0.00 722 101 10100-2010210-125000-773630 Clerk/Reg - EDMS (Imaging) $2,748.84 $6,092.12 440 101 10100-2010301-185010-773630 Clerk/Reg- Elections $694.75 $2,125.00 410 101 10100-2010501-125000-773630 Clerk/Reg - Jury Commission $0.00 $0.00 724 101 10100-2010210-125000-773630 Clerk/Reg - Legal Records $71,281.28 $181,426.78 726 101 10100-2010601-172190-773630 _ Clerk/Reg - Micrographics _ $0.00 $0.00 723 101 10100-2010205-132305-773630 Clerk/Reg - Vital Statistics $37,339.48 $64,434.08 522 101 10100-1070401-113000-773630 Community Corrections Admin $22,374.26 $60,344.97 361 101 10100-1210101A81000-773630 Communications Department -Dev $23,545.25. $31,577.00 620 101 10100-1010201-181010-773630 Compliance Office - Auditing $0.00 $0.00 430 101 10100-1010501-181020-773630 Corporation Counsel $16,884.25 $29,237.75 490 101 10100-3010402-135070-773630 CTS-FD-CT Services - Clinic $28.50 $28.50 506 101 10100-3010401-121220-T73630 CTS-Fam Div -Judicial Support $0.00 $0.00 483 101 10100-3010403-121100-773630 CTS-FD-Judicial Support -ADM $167.50 $228.87 482 101 10100-3010403-121240-773630 CTS-FD-Juvenile Support $393.00 $1,41225 015 101 10100-1010101-181000-773630 County Executive ($139.00) $22,94125 495 101 10100-3010201-121110-773630 Courts -Business Division $0.00 $0.00 499 101 10100-3010301-121130-773630 Courts-GJ-Judicial Support $223,586.51 $498,803.84 502 101 10100-3010301-121180-773630 Courts-GJ-Jury Operations $81.51 $245.60 493 101 10100-3010101-121100-773630 Courts - Judical/Administration $4,874.25 $15,867.14 188 101 10100-1090206-171000-773630 Economic Dev & Comm Affairs $0.00 $50.50 785 101 10100-1090101-171000-773630 Economic Development & Community Affairs $4,628.25 $11,283.25 740 101 10100-1020501-173010-773630 Equalization Division $&4,197.13 $207,099.05 011 101 10100-1110102-145000-773630 Emergency Management $247.50 $247.50 046 101 10100-2010301-133095-773630 Elections-Pandemic/COVI D 19 $0.00 $0.00 752 101 10100-1040801-148020-773630 Facility Engineering $1,443.75 $3,918.75 181 101 10100-1040801-140020-773630 FM&O Admin Support $2,850.00 $2,850.00 660 101 10100-1020601-182020-773630 Fiscal Services -Gen Fund $38,292.05 $89,265.89 900 101 10100-1110101-115090-773630 Emergency Mgmt/Homeland Security $10,998.75 $19,743.75 735 101 10100-6010101-155060-773630 General Fund Map $1,320.00 $1,320.00 562 101 10 100-1060 10 1 -133300-773630 Human Services - HS Admin Sew $11.808.00 $35,024.50 416 101 10100-1050403-183020-773630 HR Recruitment $0.00 $0.00 680 101 10100-1050401-183010-773630 Human Resources $23,833.43 $42,630.43 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 Prepared By Information Technology; 04/01122 Page 1 of 24 2nd euarter 2022 pdf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY SECOND QUARTER 2022 2nd Quarter CUST FUND# ACCOUNT DIVISION Jan - Mar Y.T.D. 565 101 10100-1090108-171030-TT3630 Marketing & Communcations $287.00 $512.50 872 101 10100-1070601-132030-773630 Medical Examiner $5,005.25 $5,639.37 409 101 10100-1010702-121170-T73630 MIDC OCIT Maint & Suppt $26,058.75 $32,547.75 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 $41.25 349 101 10100-4030501-112680-773630 OCSD Admin Sew -Records Unit $25.25 $25.25 648 101 10100-4030201-112580-773630 OCSD Admin Sew -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 $37,807.50 $63,396.25 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,405.25 $5,330.64 510 101 10100-3040403-124010-773630 Probate-Estates/Mental Health Support $12,408.75 $22,428.62 481 101 10100-3040101-121060-773630 Probate -Family Division Judicial $0.00 $0.00 145 101 101004010101-122050-773630 Prosecuting Attorney- General Prosecution $25,636.63 $53,888.25 690 101 10100-1020310-182090-773630 Purchasing $1,278.75 $1,773.75 637 101 10100-1030803-184020-773630 Records Retention $0.00 $0.00 650 101 10100-1020650-126020-773630 Reimbursement Division $3,513.25 $7,477.75 195 101 101004030301-112590-773630 OCSD-Corrective Sery - Armin $61,015.72 $123,478.19 1.91 101 10100-4030601-110000-773630 _ Sheriff - CLEMIS _ - $24,955.26 $44,337.60 348 101 10100-4030301-112620-773630 Sheriff- Corrective Sew Admin $6,31125 $22,811.25 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 101004030901-110040-773630 Sheriff - LE Support- Sew Admin $0.00 $0.00 445 101 10100-1030803-184025-773630 Support Services $12,313.97 $21,604.78 600 101 10100-7010101-186040-773630 Treasurer $76,752.86 $177,861.52 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 $54,466.00 $72,959.75 910 101 10100-1090702-132050-773630 Veterans Services $2.86725 $5,553.50 730 101 10100-6010101-155010-773630 Water Resource Commissioner $51,076.00 $73,957.62 742 101 10100-6010101-149920-773630 WRC- CAMS Software Support & Maintenance $197.50 $197.50 203 101 10100-6010101-174452-773530 WRC EU Pub ED Adm 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,018,403.18 $2,128,164.73 Health Fund f2211 840 221 20221-1060201-133150-773630 Health $55,710.50 $122,353.00 852 221 20221-1060211-133150-773630 Health Central Support $183.50 $537.00 843 221 20221-1060220-134390-773630 Health Environmental $46,221.91 $98,737.56 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 $000 Sub -Total Fund 221 $102,115.91 $221,627.56 Juvenile Maintenance Fund f2901 665 293 20293-1070901-112090-773630 Children's Village $13,780.35 $27,802.38 668 293 20293-1070901-112010-773630 Children's Village Admin $0.00 0.00 Sub -Total Fund 293 $13,780.35 $27,802.38 Prepared By Information Technology; 04l01/22 Page 2 of 24 2nd Quarter 2022.pdf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY SECOND QUARTER 2022 2nd Quarter CUST FUND# ACCOUNT DIVISION Jan - Mar Y.T.D. 63600-1080101-152000-631365 DEVELOPMENT FOR GOVERNMENTAL FUND $1,134,299.44 $2,377,594.67 APPROPRIATION SUB -TOTAL GOVERNMENTAL DEVELOPMENT APPROPRIATION: $1,134,299.44 $2,377,594.67 10100-9090101-196030-TT3630 Information Technology Development ($1134299,44) ($2377.594,67) TOTAL GOVERNMENTAL: $0.00 $0.00 NON -GOVERNMENTAL DIRECT CHARGES 053 Airport Special Events $0.00 $0.00 687 ARP HSD INV mgmt $5,370.25 $5,370.25 274 ASAP Passport System $0.00 $0.00 672 Assessment & Tax $25,437.75 $61,515.50 935 Augusta SAW Grant $0.00 $0.00 073 Bicentennial Celebration Grant $0.00 $0.00 944 - - CAMP CTA DR Equipment - $3,881,00 $8,983.75 - - 669 CAMS/CVT Data Conversion $0.00 $0.00 347 Childrens Village Camera - FMO $618.75 $4,661.25 309 - -Clean Slate - MlWorks! - - $0.00 $0.00 - 055 CLEMIS $469,932.84 $471,476.69 699 CLEMIS - CAD $177,977.00 $177,977.00 448 CLEMIS/FRMS NON -BILLABLE $0.00 $0.00 056 CLEMIS FUND 63500 $0.00 $4,498.50 026 CLEMIS MIDC Bridge $0.00 $0.00 069 CLEMIS- Training $0.00 $0.00 749 Clerk/Reg - CPL $56.00 $56.00 720 Clerk/Reg - Register Of Deeds $634.50 $12,042.87 719 Clerk/Rod Automation Fund $14,837.25 $14,837.25 659 Collaborative Asset Mgt Sys (CAMS) $165.00 $165.00 435 Comm Dev - Housing Counselor $0.00 $0.00 521 Community Corrections - Admin(Grant) $2,168.50 $5,959.75 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,836.00 $40,894.14 470 Courts-FOC EXP-FAM Counseling $0.00 $0.00 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 $1,659.25 $1,659.25 837 EDCA- MlTradeSchool.org Grant $0.00 $0.00 167 Edwards Drain SAW Grant $0.00 $0.00 100 Farmington Hills SUB SAW $0.00 $0.00 210 Fire Records Management System $16,484.50 $27,804.87 750 FM&O $29,355.85 $49,976.75 Prepared By; Infornahon Technology; 04101/22 Page 3 of 24 2nd Quarter 2022.pdf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY SECOND QUARTER 2022 2nd Quarter CUST FUND# ACCOUNT DIVISION Jan - Mar Y.T.D. 756 FM&O Building Maintenance $330.00 $330.00 133 FM&O Building Management System $0.00 $0.00 080 FMO Bldg Mgmt Systems Rep Ph 2 $0.00 $288.75 342 FMO Bldg Mgmt Systems Rep Ph 4 $2,615.50 $8,702.75 048 FM&O Bldg Security Enh Proj $0.00 $0.00 757 FM-WK Re]/Jail Mgt(Video Cent $0.00 $0.00 963 FOC Security Audit $92.62 $92.62 942 Franklin SAW Grant $0.00 $0.00 038 HACH WIMS Software Support $165.00 $165.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 $2,479.25 $37,792.00 120 HR-Financial System Replacement $223,133.75 $5%318.00 214 ]AM Program $6,255.00 $20,200.25 338 _ _ Imaging Project _ _ $41,54025 $134,510.00 751 IT Telephone Communications $0.00 $26.50 303 IT ARP Funding $9,585.75 $34,016.50 415 -IT/ARP Projects - $63,841.50 $66,569.50 - 202 Jail Management System (JMS) $7,430.25 $25,28125 185 Leasetrack $6,476.25 $15,840.00 112 Medical Marijuana PSA $0.00 $0.00 101 Medical Marijuana Mysidewalk $0.00 $0.00 698 MFD Rapt $18,650.50 $18,650.50 360 MIDC Application Mamt & Support $110.25 $39,824.75 113 MIDC Dev $0.00 $24,428.50 164 Neighborhood Housing Development $0.00 $0.00 661 Neighborhood Housing & Development $3,915.50 $3,915.50 192 Neptune Reports $0.00 $0.00 265 Oakvideo MIDC Support & Maintenance $0.00 $93.00 136 Oakland Township SIDS 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,372.50 $8,908.75 298 OCSO CCTV East Annex Storage $4,207.50 $5,403.75 302 OCSO CCTV Main Jail $0.00 $0.00 934 OLV BOB SAW Grant $0.00 $0.00 255 Oracle Upgrade to 19C $113,222.50 $206,203-75 770 Parks and Recreation - Administration $4,029.25 $7,816.75 867 P&R Capital Improvement $0.00 $0.00 372 P&R-Community Grants $127.75 $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 Cent Ctr CIP#2469 $0.00 $0.00 Prepared By Information Technology, 04101M Page 4 of 24 2nd Quarter 2022 pdf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY SECOND QUARTER 2022 2nd Quarter CUST FUND# ACCOUNT DIVISION Jan - Mar Y.T.D. 443 P&R Lyon Oaks Conf Ctr CIP#2468 $000 $0.00 454 P&R Springfield Oaks CIP#2471 $0.00 $0.00 456 P&R Springfield Oaks CIP#2470 $0.00 $0.00 457 P&R Red Oaks Clubhouse CIP#2467 $0.00 $0.00 268 Pontiac - Meter $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 WWTP Transaction $0.00 $0.00 906 Public Health Grant 795 $0.00 $0.00 237 Public Safety Dashboard $507.25 $2,570.00 791 Radio Communications - E911 $45,993.75 $104,074.50 695 Risk Management $13,491.00 $24,559.75 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 $116,892.50 $338,251.00 231 _ _ UCC Program IV -Wireless _ $17,67575 $36,466.50 _ 408 Veterans Services Grant Fund $378.75 $2,828.00 656 Water Resources Accounting $81.51 $245.60 731 - Water Resource- Equipment - $0.00 $0.00 736 WinCan Central Storage Solution $0.00 $0.00 930 Water and Sewer -General Ado $1,438.00 $14,738.75 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 $1,121.75 $2,675.25 281 WRC $0.00 $0.00 670 WRC Acctg - Crowder Prjct $0.00 $0.00 344 WRC Administration $495.00 $3,453.00 929 WRC Aeration Tank Rehab $0.00 $0.00 940 WRC-CAMP $118.50 $197.50 926 WRC CLINTON-OAKLAND SCADA $0.00 $0.00 932 WRC CLINTON-OAK SIDS SCADA Main $0.00 $0.00 277 WRC-GWK PCF-WRC SCADA $0.00 $0.00 3T7 WRC-SAW ACACIA $0.00 $0.00 820 WRC Manhole Inspection $764.50 $764.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 Prepared By: Information Technology; 04/01122 Page 5 of 24 2nd Quarter 2022 pdf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY SECOND QUARTER 2022 2nd Quarter CUST FUND# ACCOUNT DIVISION Jan - Mar Y.T.D. 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 728 WRC - CO BIDS SewMet $0.00 $0.00 168 WRC CRWRRF Admin Bldg Rehab $0.00 $0.00 729 WRC - EF SIDS 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 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 Protect $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 $0.00 $0.00 981 WRC Oxford Twp SAW $0.00 $0.00 501 WRC Permitting Impl $1,19625 $3,135.00 _979 _ _ WRC Permitting Implementation _ $0.00 $0.00 990 WRC Regional Systems Unit $0.00 $0.00 986 WRC Royal Oak Twp SAW $0.00 $0.00 686 .WRC-SAW Grant Labor -Common to All - $0.00 $0.00 402 WRC SAW Huron 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,062.50 $2,722.50 294 WRC - Sewer Fund $26,388.25 $34,428.00 067 WRC Utility Billing Replacement $8,415.00 $16.415.00 023 WRC Walled Lake Water $0.00 $0.00 024 WRC Walled Lake SUB $0.00 $0.00 121 WRC Website Standardization $102.50 $205.00 170 WRC W MU Meter Maintenance $0.00 $0.00 63600-1080101-152000-631302 NON -COUNTY AGENCIES 63600-1080101-152000-635017 SUB -TOTAL DIRECT CHARGES FOR DEVELOPMENT TOTAL COUNTY DEVELOPMENT CHARGES Non -County Agencies $1,519,118.07 $2.649,537.79 $2,653,417.51 $5,027,132.46 704.25 7 360.00 Prepared BT Informabon Technology. OV01122 Page 6 of 24 2nd Quarter 2022 pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2022 Cust # GOVERNMENTAL FUNDS 2nd Qtr 2022 630 ANIMAL CONTROL 24017 SOL Server Supp - Animal Control $167.50 95628 Animal Control $742.50 95682 Dog System $5,640.75 Animal Control -Total 005 BD OF COMMISSIONERS 91404 BOC - Customer Support $9,479.50 Ed of Commissioners - Total 508 BOC - LEGAL RESOURCE CENTER 61001 Library Services $0.00 91405 Library Board $0.00 BOC-Legal Resource Center - Total 665 CHILDRENS VILLAGE 95665 Childrens Village $13,780.35 Children Village - Total 668 CHILDREN'S VILLAGE ADMIN 97668 Childrens Village Admin $0.00 - - - Childrens Village Admin - Total - - 725 CLERK/REG -ADMIN 72500 Clerk -Admin 0.00 - - - Clerk/Reg- Admin - Total - - 440 CLERKIREG - ELECTIONS DIVISION 95443 Clerk/Reg - Elections Division $694.75 Clerk/Reg - Elections Division - Total 722 CLERK/REG - EDMS (IMAGING) 13001 Clerk's - Efiling $0.00 95158 Clerk/Reg - EDMS Support/Maintenance/Upgrades $2,748-84 Clerk/Reg - EDMS (Imaging) -Total 410 CLERK/REG - JURY COMMISSION 95512 Clerk/Reg - Jury Commission $000 Clerk/Reg - Jury Commission -Total 724 CLERK/REG - LEGAL RECORDS 21013 Legal Division - 50 % $393.00 31001 Clerk - Legal Div - 50% $3,410.78 95170 Clerk/Reg - Legal Records - Total $22,740.25 95189 Circuit Court System $44,737.25 Clerk/Reg - Legal Records -Total 723 CLERK- VITAL STATISTICS 24015 SOL Server Supp - Vital Slats 3.5% $167.50 95161 Clerk.Reg - Vital Statistics $37 171.98 Clerk - Vital Statistics - Total 361 COMMUNICATIONS DEPARTMENT - DEV 95361 Communications Department- Dev $23 545.25 Communications Department- Dev -Total 522 COMMUNITY CORRECTIONS-ADMIN (CO) 23003 Oracle Support -Comm Corr-5.2% $81.51 Prepared By Infovnalion Technology, 04/Ot/22 Page 7 of 24 $6,550.75 $9,479.50 $0.00 $13,780.35 $0.00 $0.00 $694.75 $2,748.84 $0.00 $71,281.28 $37,339.48 $23,545.25 2nd Quarter 2022.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2022 24012 SQL Server Supp - Community Corr 3.5 52200 Comm Corr-Admin (County) 52201 Comm Corr -DW Support Community Corrections - Total 620 COMPLIANCE OFFICE -AUDITING 44034 Auditing - New Development 95468 Auditing Internal Sw - Cust Sup Compliance Office - Auditing - Total 690 COMPLIANCE OFFICE - PURCHASING 44028 Purchasing System Enhancements 44029 Pur-New Development Compliance Office - Purchasing -Total 430 CORPORATION COUNSEL 95501 Corporation Counsel Corporation Counsel - Total 015 COUNTY EXECUTIVE 95654 County Exec -Development 95656 County Executive Support _ County Executive = Total 450 CIRC CT PROBATION -NORTH 80204 Circuit Court Probation - North - Circuit Court Probation - North -Total 495 CTS-BUSINESS DIVISION 12002 CCT-Courts/Criminal 23010 Oracle Support-CCT/CTS Crim Whse 2.6% CTS-Business Division - Total 506 CTS-FAM DIVJUDICIAL SUPPT 95187 CTS-Fam Div -Judicial Support CTS-Faun Div -Judicial Support -Total 490 CTS-FD-CT SERVICES - CLINIC 95171 CTS-FD-CT Services - Clinic CTS-FD-CT Services - Clinic - Total 483 CTS-FDJUDICIAL SUPPORT -ADM 24009 SOL Sew Supp - CTS-Jud Sup Adm - 3.5 CTS-FD-Judicial Support-Adm -Total 482 CTS-FD JUVENILE SUPPORT 48200 CTS-Jud Support -Juv Support CTS-Jud Support - Juv Support - Total 498 CTS-GEN JURISJUDICIAL SUPPT 23010 Oracle Supp-CCT/CTS 31002 CTS-GJ General Support 95179 CTS-Gen Juris-Judicial Suppt CTS-Gen Juns-Judicial Suppt -Total 502 CTS-GJJURY OPERATIONS 23008 Oracle Support-CTS-GJ-Jury Operations CTS-GJ-Jury Operations - Total 493 CTSJUDICIALADMIN 13002 Court's- Efiling Prepared By. Infoavaton Technology, 04/01/22 Page 8 of 24 $167.50 $22,125.25 0.00 $0.00 0.00 $1,278.75 $0.00 $16,884.25 ($4,511.50) 4 372.50 0.00 $0.00 0.00 $0.00 $28.50 67.50 $393.00 $40.77 $3,410.72 $220.135.02 81.51 $0.00 $22,374.26 $0.00 $1,278.75 $16,884.25 ($139.00) $0.00 $0.00 $0.00 $28.50 $167.50 $393.00 $223,586-51 $81.51 2nd Quarter 2022.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2022 188 ECONOMIC DEV & COMM AFFAIRS 785 ECONOMIC DEVELOPMENT & COMMUNITY AFFAIRS 740 EQUALIZATION 011 EMERGENCY MANAGEMENT 752 FACILITY ENGINEERING 660 FISCAL SERVICES ADMIN 735 GENERAL FUND MAP Prepared By Information Te hnology; 04101W 95174 CTS-Judicial Admin $4,874.25 CTSJudicial Admin - Total $4,874.25 98180 Economic Dev & Comm Affairs $0.00 Economic Dev & Comm Affairs - Total $0.00 36500 CIS Implementation Support C&E Dev $660.00 36501 CED Application -H/W Support $0.00 95785 Comm & Eco Developmt $2,772.00 96785 EDCAAdmimstration $1,196.25 Economic Development & Community Affairs - Total $4.628.25 23012 Oracle Support -Equalization - 5.2 % $81.51 24005 SQL Server Supp-Equalization - 10.5% $502.45 31075 Equal - Development $809.00 36505 GIS Implementation Support Equalization $82.50 36506 Equal Application - HN/ Support $7,605.50 36507 Equal LAMS Support $28,535.00 36601 Land System Enhancements - Equal (50%j $11,931.40 _ 36701 Land System Maintenance - Equal (50%) $1,558A3 36801 Land System Support- Equal (50%) $4,182.39 36902 BS&A Orion Twp - - - $0.00 - 50101 EQUAL (BS&A ANNUAL) $651.00 95562 Equalization -DW Support $0.00 95693 Equalization - System Maintenance $330.00 95699 BS&A Master Appraisal Sup/Maint $27 928.25 Equalization - Total $&4,197.13 95011 Emergency Management $247.50 Emergency Management - Total $247.50 75201 Facility Engineering $1,443.75 Facility Engineering - Total $1,443.75 23001 Oracle Support - Fiscal Sew - 15.6% $244.53 23013 Oracle Support -HR-Acctg/Budget-5.2% $81.51 24006 SQL Sery Supp - HR-Acctg - 1.75% $83.76 44021 FS-System/Customer Support $13,094.75 44022 FS- System Maintenance $0.00 44023 FS - System Enhancements $0.00 44024 FS - New Development $0.00 44602 Bond Disclosure - Fiscal (50%) $0.00 96001 Fiscal Sery - Acctg 40 % $16,525.00 96003 Fiscal Sery - Budget 20 % $8,262.50 Fiscal Services Admin - Total $38,292.05 74735 General Fund Map $1,320.00 General Fund Map -Total $1,320.00 Page 9 of 24 2nd Quarter 2022.pdf INFORMATION TECHNOLOGY- RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2022 840 HEALTH DIVISION 36526 GIS Implementation Support Health $0.00 95563 User Support -Health $23,22225 96842 Health Admin $32,488.25 Health - Total $55,710.50 852 HEALTH CENTRAL SUPPORT 95852 Health Central Support $183.50 Health Central Support -Total $183.50 843 HEALTH - ENVIRONMENTAL 23005 Oracle Support- EH Projects - 5.2% $81.51 24014 SQL Server Suppt- Ehealth 14% $669.90 84200 EH - Projects $45,305.50 84300 Ehealth Program 165.00 Health -Environmental - Total $46,221.91 183 HEALTH WEBSITE REDESIGN 96183 Health Website Redesign $0.00 Health W ebsite Redesign - Total $0.00 900 EMERGENCY MGMT/HOMELAND SECURITY 365_45 GIS Implementation Support Homeland Security _ $206.25 _ 36546 Homeland Security Application - HNV Support $11,040.00 98990 Homeland Security 247.50 - - - Homeland Security - Total - - $10,998.75 680 HUMAN RESOURCES 23014 Oracle Support-HRIPersonnel-52% $81.51 24007 SOL Server Suppport-HR/Personnel - 1.75% $83.76 44044 HR- New Development $0.00 96002 Human Res -Personnel 40% $23,668.16 Human Resources - Total $23S33.43 562 HUMAN SERVICES - HS ADMIN SERV 96561 Human Services - HIS Admin Sew $11.808.00 Human Services - HIS Admin Sew - Total $11,808.00 181 FM&O ADMIN SUPPORT 21181 FM&O Admin Support $2,850.00 FM&O Admin Support - Total $2,850.00 907 LIBRARY - LIBRARY ADMIN 91405 Library Board 0.00 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 $287.00 Marketing & Communications - Total $287.00 872 MEDICAL EXAMINER 24002 SOL Server Support- Medical Exam - 3.5% $167.50 87202 Medical Examiner- Customer Support $4,83775 Medical Examiner -Total $5,005.25 Prepared By: Infonnaton Technology: 041011 2 Page 10 of 24 2nd Quarter 2022 pelf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2022 409 MIDC OCIT MAINT/SUPP 67409 MIDC OCT Maint/Supp $26 058.75 MIDC OUT Maint/Supp -Total $26,058.75 296 MSU-DIGITAL MEDIA SERVICES 22296 MSU - Digital Media Services 0.00 MSU - Digital Media Services - Total $0.00 710 MSU EXTENSION -OAKLAND 95676 MSU Ext Equipment Maintenance $41.25 MSU Extension - Oakland - Total $41.25 349 OCSO ADMIN SERV - RECORDS MGMT 97349 OCSO Admin Sew - Records Mgmt $25.25 OCSO Admin Serv- Records Mgmt - Total $25.25 648 OCSO ADMIN SERV - SHERIFF ADMIN 97648 OCSO Admin Sew - Sheriff Admin 0.00 OCSO Admin Sew - Sheriff Admin - Total $0.00 163 OCSO-CLEMIS FORENSIC LAB IMS 16300 OCSO-CLEMIS Forensic Lab 0.00 OCSO-CLEMIS Forensic Lab IMS -Total $0.00 _ 775 PLANNING &. ECO DEVELOPMENT _ 95600 PEDS Cust/System Support _ $37,807.50 _ Planning & Eco Development - Total $37,807.50 512 PROB-ESTATES/MENTL HLTH EDMS (1MG) 95207 PC-E/MH EDMS Support & Mtce $2,405.25 - Prob-Est/Mntl Hlth EDMS (Img)-Total $2,40525 510 PROB-ESTATES/MENTL FILTH SUPPORT 24010 SOL Sew Supp-PCT-Est/Mental - 3.5 % $167.50 92198 Prob-Est/Mnd Filth Support $12,241.25 Prob-Est/Mntl Hlth Support - Total $12,408.75 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% $167.50 95622 Prosecutor/Executive $21,149.00 95623 Pros/Circuit $28.50 95664 Prosecutor Warrants $49.88 97001 Prosecutor Data Proc $4,241.75 Prosecutor - Total $25,636.63 239 PUB HLTH-PANDEMIC/COVIDI9 96239 Pub Hlth-Pandemic/Covid19 $0.00 Pub 1-ilth-Pandemic/Covld19 -Total $0.00 637 RECORDS RETENTION 44053 REC -System Enhancements 0.00 Records Retention - Total $0.00 650 REIMBURSEMENT 95470 Reimbursement System $3,513.25 95542 Reimburse User Support 0.00 Reimbursement - Total $3,513.25 Prepared By: Information Technology, 00101122 Page 11 of 24 2nd Quarter 2022.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2022 195 SHERIFF 12001 OCSD-Courts/Criminal-50% $0.00 23009 Oracle Suppport- OCSD/CTS Grim W hse - 2.6 % $40.77 97163 Sheriff $7,626.70 97164 Sheriff -Development $0.00 97165 Sheriff-DW Support $0.00 98164 CLEMIS-Sheriff $53,348.25 Sheriff - Total 191 SHERIFF - CLEMIS 23015 Oracle Suppport - Sheriff / CLEMIS - 5.2% $81.51 96163 Sheriff - CLEMIS $24,873.75 Sheriff - CLEMIS - Total 348 SHERIFF -CORRECTIVE SERV ADMIN 34800 Inmate Phone System $6,311.25 Sheriff - Corrective Sew Admin - Total 988 OC SHERIFF's - IFS DIV - LAB 16300 OCSO CLEMIS Forensic $0.00 OCSO CLEMIS Forensic - Total 647 OCSD PATROL SERV-LE ADMIN _ 97647 Sheriff - Patrol Sew -LE Admin $0.00 Sheriff - Patrol Sew -LE Admin - Total 445 SUPPORTSERVICES - 23002 Oracle Support -Supp Sew -5.2% - - $81.51 24011 SQL Server Supp - Suppt Services 7% $334.96 44500 Support Services $11,897.50 Support Services - Total 600 TREASURER 23006 Oracle Support - Del Tax -5.2% $81.51 23016 Oracle Support - Treasurer -10.4% $163.02 36516 Treasurer Application - HAW Support $0.00 36602 Land System Enhancements -Treas (50%) $11,931.35 36702 Land System Maintenance -Treas (50%) $1,558.12 36802 Land System Support -Treas(50%) $4,182.36 44061 Tre-System/Customer Support $42,51525 44062 Tre-System Maintenance $2,903.50 44063 Tre-System Enhancements $1,720.25 44064 Tre-New Development $430.50 44080 Tre-DW Support $0.00 44082 Tre-DW Maintenance $0.00 44601 Bond Disclosure - Trees (50%) $0.00 50102 TREAS(BS&A)ANNUAL $651.00 95008 Del Tax On Line $330.00 95303 Del Tax System Maintenance $0.00 95561 User Support/Del Tax $9,885.00 95615 BSBA Annual Tax Support $401.00 Treasurer - Total 169 TREASURERS -BANKING 96169 Treasurers -Banking RFP $000 Prepared By: InfonnaUen Technology; 04101/22 Page 12 of 24 $61,015.72 $24,95526 $6,311.25 $0.00 $0.00 $12,313.97 $76,752.86 2nd Quarter 2022.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2022 Treasurers -Banking RFP - Total $0.00 627 TREASURER-LANDSALE 44083 Treasurer-Landsale $0.00 Treasurer -Landsale - Total $0.00 978 TREASURERS OFFICE -OAKDOCS 95978 Treasurers Office-Oakdocs $54,466.00 Treasurers Office-Oakdocs - Total $54,466.00 910 VETERANS SERVICES 95650 Veterans Services Equipment $2,86725 95651 Veterans Customer Support 0.00 Veterans Services - Total $2,867.25 730 WATER RESOURCE COMMISSIONER 24008 SQL Server Supp-WRC 3.5% $167.50 28007 Water Resource Commission $40,227.00 28010 WRC-Customer Support $7,548.75 28011 Water Resource Commissioner Application $2,39025 36520 CIS Implementation Support WRC $742.50 36521 WRC Application -H/W Support $0.00 - Water Resource Commissioner - Total _ _ $51,076.00 742 WRC -CAMS SOFTWARE SUPPORT & MAINTENANCE 74200 WRC CAMS SOFTWARE Support $197.50 - WRC CAMS SOFTWARE Support - Total - - $197.50 022 WRC GIS LAYER 35022 WRC GIB Layer $000 WRC GIS Layer - Total $0.00 301 WRC - SOIL EROSION SOFTWARE SOL 74301 WRC - Soil Erosion Software Sol $0.00 WRC - Soil Erosion Software Sol - Total $0.00 540 52/1 DISTRICT COURT - NOVI 95527 DC Suprt- 52/1 - 25% $3,617.62 52/1 District Court - Total $3,617.62 550 5212 DISTRICT COURT - CLARKSTON 95528 DC Suprt- 52/2 - 25% $3,617.62 52/2 District Court - Total $3,617.62 560 5213 DISTRICT COURT - ROCHESTER 95288 52 Dist Ct Div 3 $3,617.62 95529 DC Suprt - 5213 - 25% $0.00 52/3 District Court - Total $3,617.62 530 5214 DISTRICT COURT -TROY 95530 DC Suprt- 52/4 - 25% $3 617.39 52/4 District Court - Total $3,617.39 cost# DIRECT FUNDS 687 ARP HSD INV MGMT 68701 ARP HSD INV Mgmt $5,370.25 ARP HSD INV Mgmt-Total$5,370.25 $1,134,299.44 Prepared By: Infor abon TeOnology; e4/g1I22 Page 13 of24 2nd Quarter 2D22.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2022 274 ASAP PASSPORT SYSTEM 97274 ASAP Passport System ASAP Passport System - Total 672 ASSESSMENT & TAX 67200 Assessment & Tax Assessment & Tax - Total 935 AUGUSTA SAW GRANT 37935 Augusta SAW Grant Augusta SAW Grant - Total 073 BICENTENNIAL CELEBRATION 91073 Bicentennial Celebration Grant Bicentennial Celebration Grant -Total 944 CAMP CTA DR EQUIPMENT 37944 Camp CTA DR Equipment Camp CTA DR Equipment - Total 347 CHILDRENS VILLAGE CAMERA- FMO 21347 Children Village Camera - FMO Childrens Village Camera - FMO - Total - 055 CLEMIS - - 23004 Oracle Support OakVideo CLEMIS 52% 23018 Oracle Support - Sheriff CLEMIS 5.2 24004 SQL Server Support - 24.5% - - 95430 CLEMIS Maintenance 95431 CLMS Enhancements 98000 Project Team 98003 CLEMIS User Support 98005 CLEMIS - E911 Support 98000 Poject Team CLEMIS - Total 699 CLEMIS - CAD 98006 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 669 CAMS/CVT DATA CONVERSION 66901 CAMS/CVT Data Conversion CAMS/CVT Data Conversion - Total 749 CLERK/REG - CPL 74900 Clerk/Reg - CPL Clerk/Reg - CPL - Total 720 CLERK / REGISTER OF DEEDS 24003 SQL Server Supp - ROD 3.5% 36510 GIS Implementation Support 36511 ROD Application - WIN Support Prepared By: Infonnaton Technology; g41n1/22 Page 14 of 24 0.00 $25,437.75 0.00 0.00 3 881.00 $618.75 - $Bt51 $81.48 $1,172.35 $709.25 $1,031 25 $493.00 $76,010.25 $358,385.50 $31 968.25 B,I m $m 977.00 $0.00 0.00 56.00 $167.50 $0.00 $635.00 $0.00 $25,437.75 $0.00 $0.00 $3,881.00 $618.75 $469,932.&4 $0.00 $177,977.00 $0.00 $0.00 $56.00 2nd Quarter 2022.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2022 95493 ROD System Maintenance $0.00 95498 Clerk/Reg - ROD r$1, 68.00) Clerk/Reg of Deeds - Total $634.50 719 CLERK/ROD AUTOMATION FUND 95719 Clerk/ROD Automation Fund $14,837.25 Clerk/ROD Automation Fund - Total $14,837.25 659 COLLABORATIVE ASSET MGT SYS 65901 Collabordve Asset Mgt Sys $165.00 Collabortive Asset Mgt Sys - Total $165.00 435 COMM DEV - HOUSING COUNSELOR 66104 Comm Dev - Housing Counselor 0.00 Comm Dev - Housing Counselor -Total $0.00 937 COSDS SAW GRANT 37937 COSDS SAW Grant $000 COSDS SAW Grant -Total $0.00 471 CTS-FOG-EXP-CS ENFORC-EDMS (IMG) 92194 CTS-FOC-CS ENF-EDMS Support/Maintenance/Upgrades $0.00 CTS-FOC Exp-CS Enforc-EDMS (Img)-Total $0.00 507 CTS-FOC EXP-CS ENFORCEMENT 65410 FOC-Image Replace $28.50 92193 CTS-FCC Exp-CD Enforc-Dev $18,402.25 _ _ 92194 CTS-FOC-CS ENF-EDMS $2,405.25 CTS-FCC Exp-CD Enforc-Dev - Total $20,836.00 521 COMM CORR-ADM (GRANTI 52100 Community Corrections C*Star EB $2,168.50 Comm Corr - Adm (Grant) - Total $2,168.50 045 CV RADIO SYSTEM REPLACEMENT 95045 CV Radio Sysem Replacement $000 CV Radio Sysem Replacement - Total $0.00 673 CYBER SECURITY FUND 67300 Cyber Security Fund $000 Cyber Security Fund - Total $0.00 931 DRAIN EQUIPMENT FUND 37934 Drain Equipment Fund $0.00 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 $1,659.25 Drain Equip Map - Total $1,659.25 837 EDCA- MITRADESCHOOL.ORG GRANT 83700 EDCA-MITRADESCHOOL $0.00 EDCA - MITradeSchool.org Grant - Total $0.00 167 EDWARDS DRAIN SAW GRANT 33167 Edwards Drain SAW Grant $0.00 Edwards Drain SAW Grant - Total $0.00 Prepared By. Infoanabcn Technology; 0M0112 Page 15 of 24 2nd Quarter 2022.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2022 100 FARMINGTON HILLS SDS SAW 33099 Farmington Hills SIDS SAW Farmington Hills SIDS SAW -Total 210 FIRE RECORDS MANAGEMENT SYSTEM 21010 Fire Records Mgmt Fund 531 95404 SOL Server Support - FIRMS 3.5% 24001 FRMS - Phase II Proj Fire Records Management System - Total 750 FM&O 21001 Facilities Maintenance & Operations 24013 SQL Server Supp -FM&O 75503 FM&O Development FM&O - Total 756 FM&O BUILDING MAINTENANCE 75600 FM&O Building Maintenance FM&O Building Maintenance -Total 133 FM&O BUILDING MANAGEMENT SYS 40400 FM&O Building Management Sys - FM&O Building -Management Sys - Total_ 048 FM&O BLDG SECURITY ENH PROJ 75048 FM&O Bldg Security Enh Prot - - FM&O Bldg Security Enh Proj - Total 080 FMO BLDG SYSTEMS REP PH 2 21080 FMO Bldg Systems Rep FMO Bldg Systems Rep - Total 342 FMO BLDG MGMT SYSTEMS REP PH 4 74342 FMO Bldg Systems Rep Ph 2 FMO Bldg Systems Rep Ph 2 - Total 963 FOC SECURITY AUDIT 34963 FOC Security Audit FOC Security Audit - Total 942 FRANKLIN SAW GRANT 37942 Franklin SAW Grant Franklin SAW Grant - Total 038 HACH WIMS SOFTWARE SUPPORT 74038 HACH WIMS Software Support HACH WIMS Software Support - Total 380 HEALTH -IMMUNIZATION GRANT 38000 Health -Immunization Grant Health -Immunization Grant - Total 173 _HEALTH- LEAD INNOVATION GRANT 96173 Health- Lead Innovation Grant Health - Lead Innovation Grant - Total 071 HEALTH LEAD PSA GRANT 96071 Health Lead PSA Grant Health Lead PSA Grant -Total 020 HENRY GRAHAM DRAIN SAW GRANT 35020 Henry Graham Drain SAW Grant Prepared By information Technology, D41012 Page 16 of 24 0.00 $167.50 $16,317.00 0.00 $2,438.35 $167.50 $26,750.00 $330.00 0.00 $0$000 $000 2 615.50 92.62 0.00 $165.00 0.00 0.00 0.00 $000 $0.00 $16,484.50 $29,355.85 $330.00 _$0.00 $0.00 $0.00 $2,615.50 $92.62 $0.00 $165.00 $0.00 $0.00 $0.00 2nd Quarter 2D22.pdf INFORMATION TECHNOLOGY- RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2022 947 HIPAA ENHANCEMENTS 120 HR-FINANCIAL SYS REP 214 ]AM PROGRAM 338 IMAGING PROJECT 303 IT ARP FUNDING 415 IT/ARP PROJECTS 751 IT -TELEPHONE COMMUNICATIONS 202 JAIL MANAGEMENT SYSTEM (JMS) 185 LEASETRACK REPLACEMENT 698 MFD REPL 360 MIDC APPLICATION MAINT & SUPPORT 113 MIDC CLEMIS DEV 661 NEIGHBORHOOD HOUSING & DEVELOPMENT 634 OAKVIDEO UPGRADE (BA) 938 OAKWIN RADIO SYSTEM ENH Prepared By: Infordiabon Technology; 04101122 Henry Graham Drain SAW Grant - Total $0.00 96947 HIPPA Enhancements II $2,479.25 HIPPA Enhancements 11- Total $2,479.25 44120 HR-Financial System Replacement $223,133.75 HR-Financial System Replacement -Total $223,133.75 21400 [AM Program $6,255.00 IAM Program - Total $6,255.00 33800 Imaging Project $41,540.25 Imaging Project -Total $41,540.25 17303 IT ARP Funding $9,585.75 IT ARP Funding - Totaal $9,585.75 97415 IT/ARP Projects $63,841.50 _ IT/ARP Projects - Total _ _ $63,841-50 75102 Telephone Communications - Customer Support $000 - IT- Telephone Communications - Total - - $0.00 63202 Jail Management System (JMS) $7,430.25 Jail Management System (JMS) - Total $7,430.25 18500 Leasetrack Replacement 6 47&25 Leasetrack Replacement - Total $6,476.25 90698 MFD Rep[ $18.650.50 MFD Repl - Total $18,650.50 67360 MIDC Application Maint & Support $110.25 MIDC Application Maint & Support - Total $110.25 91113 MIDC Clemis Dev $0.00 MIDC Clemis Dev - Total $0.00 66103 Neighborhood Housing & Development $3,915.50 Neighborhood Housing & Development -Total $3,915.50 63400 CLEMIS - OakVideo Upgrade $0.00 63401 IT - OakVideo Upgrade 0.00 OakVideo Upgrade (HA) -Total $0.00 98938 OAKWIN Radio System Enh 0.00 OAKW IN Radio System Enh -Total $0.00 Page 17 of 24 2nd Ouarter2022.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2022 043 OC BICENTENNIAL OAK200 96043 OC Bicentennial OAK200 $0.00 OC Bicentennial OAK200 - Total $0.00 653 O.C. INTNL AIRPORT 36540 GIS Implementation Support $0.00 65301 Airport User Support $4,372.50 65310 O.C. Airport- New Development $0.00 O.C. Intnl Airport - Total $4,372.50 298 OCSO CCTV EAST ANNEX STORAGE 97298 OCSO CCTV East Annex Storage $4,207.50 OCSO CCTV East Annex Storage - Total $4,207.50 302 OCSO CCTV MAIN JAIL 96302 OCSO CCTV Main Jail 0.00 OCSO CCTV Main Jail - Total $0.00 934 OLV SDS SAW GRANT 37934 OLV SIDS SAW Grant $0.00 OLV SIDS SAW Grant - Total $0.00 255 ORACLE UPGRADE TO 19C 63255 Oracle Upgrade to 19C $113,222.50 _ Oracle Upgrade to 19C-Total _ _ $113222.50 770 PARKS AND RECREATION 36530 GIS Implementation Support - Parks $371.25 - - 44066 PRADM-System/Customer Support - - $701,25 - 44068 PRADM-System Enhancements $0.00 76100 P&R Administrative Services $0.00 95413 PRADM-Customer Support $2,956.75 95416 PRRA -Rec Admin $0.00 95419 PRADM-Administration $0.00 Packs & Recreation - Total $4,02925 867 P&R CAPITAL IMPROVEMENT 86700 P&R Capital Improvement 0.00 P&R Capital Improvement -Total $0.00 372 P&R COMMUNITY GRANTS 77372 P&R Community Grants $127.75 P&R Community Grants - Total $127.75 925 P&R EMS UPGRADE 37925 P&R EMS Upgrade 0.00 P&R EMS Upgrade - 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 0.00 P&R Lyon Oaks Conf CTR CIP#2468-Total $0.00 454 P&R SPRINGFIELD OAKS CIP#2471 45400 P&R Springfield Oaks CIP92471 $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 Prepared By: Information Technology, 04101/22 Page 18 of 24 2nd Quarter 2022.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2022 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 BSA to W RC - Water 0.00 Pontiac Meter - Total $0.00 747 PONTIAC WATER 74701 Pontiac BSA to W RC - Water $0.00 Pontiac Water- Total $0.00 748 PONTIAC SEWER_ 74702 Pontiac BSA to WRC-Sewer $0.00 Pontiac Sewer - Total $0.00 936 PONTIAC WATER ASSET MGMT 37936 Pontiac Water Asset Mgmt 0.00 Pontiac Water Asset Mgmt - Total $0.00 906 PUBLIC HEALTH GRANT 795 96906 Public Health Grant 795 $0.00 _ _ Public Health -Grant 795 - Total _ _ _ $0.00 329 PONTIAC WWTP TRANSACTION 67329 Pontiac WWTP Transaction 0.00 Pontiac WWTP- Transaction -Total - S0.00 237 PUBLIC SAFETY TRANS BOARD 65237 Public Safety Trans Dashboard $507.25 Public Safety Trans Dashboard - Total $507.25 791 RADIO COMMUNICATIONS - E911 79101 Radio Communications - E911 $45,993.75 Radio Communications - E911 - Total $45,993.75 695 RISK MANAGEMENT 44036 Rsk-System Customer Support $13,491.00 44028 Risk -System Enhancement $0$000 Risk Management - Total $13,491.00 638 TAX MANAGEMENT SYSTEM 63800 Tax Management System $0.00 Tax Management System - Total $0.00 973 UCC PROGRAM 11 92973 UCC PROGRAM II $0.00 UCC PROGRAM II - Total $0.00 115 UCC PROGRAM III-VOIP 92115 UCC Program III - VOIP $116 892.50 UCC Program III - VOIP - Total $116,892.50 231 UCC PROGRAM IV -WIRELESS 23100 UCC Program IV - Wireless $17 675.75 UCC Program IV - Wireless - Total $17,675.75 408 VETEERANS SERVICES GRANT FUND 96408 Veterans Services Grant Fund $378.75 Veterans Services Grant Fund -Total $378.75 Pi,paied By: Inforrrabon Technology 04ID122 Page 19 of 24 end Quarter 2022.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2022 656 WATER RESOURCES ACCOUNTING 23011 Oracle Supp - Water & Sewer Acct'g - 5.2 % $81.51 95669 Water Resources Accounting $0.00 95671 Drain Water/Sewer Bl 0.00 Water Resources Accounting - Total $81.51 731 WATER RESOURCE - EQUIPMENT 74501 Water Resources - Ops and PC net 0.00 Water Resource - Equipment - Total $0.00 736 WINCAN CENTRAL STORAGE SOLUTION T3601 WmCan Central Storage Solution $0.00 WinCan Central Storage Solution - Total $0.00 930 WATER AND SEWER -GENERAL ADMIN 37930 Water and Sewer -General Admin $1,438.00 Water and Sewer -General Admin - Total $1,438.00 939 WATER AND SEWER GENERAL ADMINISTRATION 37939 Water and Sewer General Administration $0.00 Water and Sewer General Administration - Total $0.00 974 WATER AND SEWER GEN ADMIN-WMU 37974 Water and Sewer General Admin -WMU $0.00 Water and Sewer General Admin - WMU - Total _ _ $0.00 212 WORKFORCE DEV-CLEAN SLATE PROJ 95212 Workforce Dev-Clean Slate Proj 1 121.75 - - Workforce Dev-Clean Slate Proj - Total - - $1,121.75 670 WRC ACCTG - CROWDER PRJCT 60001 WRC - Crowder NetBase Project $0.00 67000 WRC- Crowder NetBase Project $000 WRC Acctg - Crowder Prject -Total $0.00 344 WRC ADMINISTRATION 75344 WRC Administration $495.00 WRC Administration - Total $495.00 929 WRC AERATION TANK REHAB 35700 WRC Aeration Tank Rehab $0.00 WRC Aeration Tank Rehab - Total $0.00 980 WRC BINGHAM FARMS SAW 33980 WRC Bingham Farms SAW 0.00 WRC Bingham Farms SAW -Total $0.00 377 WRC-SAW ACACIA 28674 WRC-SAW ACACIA $0.00 WRC - SAW ACACIA - Total $0.00 940 WRC-CAMP 37940 WRC - Camp 118.50 WRC - Camp - Total $118.50 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 Prepared By Information Technology, 04/01/22 Page 20 of 24 2nd Quarter=.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2022 168 WRC CRWRRF ADMIN BLDG REHAB 277 WRC-GWK PCF-WRC 281 WRC 820 WRC MANHOLE INSPECTION 501 WRC PERMITTING IMPL 979 WRC PERMITTING IMPLEMENTATION 236 WRC OAKLAND MACOMB INTERCEPTOR 981 WRC OXFORD TWP SAW 986 WRC ROYAL OAKTWP SAW 377 WRC-SAW ACACIA 382 WRC SAW BIRMINGHAM 379 WRC-SAW COMMERCE TOWNSHIP 386 WRC - SAW ORCHARD LAKE 674 WRC - SAW GRANT LABOR 381 WRC SAW GWK 686 WRC -SAW GRANT LABOR -COMMON TO ALL Prepared By Infoona6on Technology; MC I/22 33168 WRC CRWRRF Admin Bldg Rehab WRC CRWRRF Admin Bldg Rehab -Totals 74277 WRC-GWK PCF-WRC WRC-GWK PCF-WRC - Total 74281 WRC WRC -Total 74820 WRC Manhole Inspection WRC Manhole Inspection - Total 74502 WRC Permitting Impl WRC Permitting Impl -Total 74979 WRC Permitting Implementation WRC Permitting Implementation -Total 33236 WRC Oakland Macomb Interceptor _ WRC Oakland Macomb Interceptor - Total 33981 WRC Oxford Twp SAW WRC Oxford Twp SAW - Total 33986 WRC Royal Oak Twp SAW WRC Royal Oak Twp SAW - Total 28674 WRC-SAW Acacia WRC - SAW Acacia - Total 33382 WRC SAW Birmingham WRC SAW Birmingham - Total 33379 WRC- SAW Commerce Township WRC - SAW Commerce Township - Total 33386 WRC-SAW Orchard Lake WRC - SAW Orchard Lake - Total 28674 WRC-SAW Grant Labor WRC - SAW Grant Labor - Total 33381 WRC SAW GWK WRC SAW GWK - Total 60002 WRC-SAW Grant Labor -Common to All 12686 WRC-SAW Grant -Common to All WRC-SAW Grant Labor Common to All -Total Page 21 of 24 0.00 $0.00 0.00 $764.50 196.25 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 $764.50 $1,196.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 2nd QaaM, 2022.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2022 895 WRC AGO 734 WRC-AMRSUPPORT 745 WRC - CODDA METER REPLACEMENT 728 WRC-CO SDS SEWMET 729 WRC -EF SDS SEWMET 737 WRC - DATA APPLICATION PILOT PRJ 300 WRC-GIS ALLOCATION BY LABOR 277 WRC-GWK PCF-WRC SCADA 295 WRC HACH WIMS IMPLEMENTATION 894 WRC - HACH WIMS IMPLEMENTATION PHASE II 733 WRC-HYDRO DRAIN PROJECT 671 WRC -INFRASTRUCTURE OP AR 299 WRC-MISS DIG TICKET MGMT SYS 990 WRC REGIONAL SYSTEMS UNIT 387 WRC SAW EVERGREEN FARMINGTON Prepared By: Infonnadon Technology; 04I01122 37895 WRC AGO WRC AGO - Total 73401 WRC-AMR Support WRC - AMR Support - Total 74500 WRC - CODSA Meter Replacement WRC - CODSA Meter Replacement -Total 72201 MARS Enhancements - WRC C-O WRC - CO SDS SewMet - Total 72202 MARS Enhancements- WRC E-F WRC - EF SDS SewMet - Total 73700 WRC - Data Application Pilot Project 73710 WRC - Data Appl Fri WRC - Data Application Pilot Pd - Total 73300 WRC-GIS Allocation by Labor - WRC-GIS Allocation by Labor - Total 74277 WRC -GWK PCF-WRC SCADA WRC - GWK PCF-WRC SCADA - Total 67295 WRC-HACH WIMS Implementation WRC-HACH WIMS Implementation - Total 37894 WRC-HACH WIMS Implementation Phase II WRC-HACH WIMS Implementation Phase II - Total 73301 WRC-Hydro Drain Project WRC-Hydro Drain Project -Total 67100 WRC -10 AR WRC - Infrastructure Op Ar - Total 74299 WRC-MISS Dig Ticket Mgmt Sys WRC-MISS Dig Ticket Mgmt Sys - Total 37990 WRC Regional Systems Unit WRC Regional Systems Unit -Total 33387 WRC SAW Evergreen Farmington WRC SAW Evergreen Farmington - Total Page 22 of 24 $0.00 $ao0 $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 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 2nd Quarter 2022.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL -SECOND QUARTER 2022 389 WRC SAW LAKE ORION 33389 WRC SAW Lake Orion $0$000 WRC SAW Lake Orion - Total $0.00 402 WRC SAW HURON ROUGE 33402 W RC SAW Huron Rouge $0.00 WRC SAW Huron Rouge Total $0.00 403 WRC SAW BLOOMFIELD VILLAGE 33403 WRC SAW Bloomfield Village $0.00 WRC SAW Bloomfield Village - Total $0.00 739 WRC-SCADA COMMON 73900 WRC-SCADA Common $0.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 $2,062.50 WRC - SCADA Maintenance -Total $2,062.50 294 WRC-SEWERFUND _ _74294 WRC-Sewer Fund _ _ $26,388.25 WRC - Sewer Fund - Total $26,388.25 067 WRC UTILITY BILLING REPLACEMENT 33067 WRC Utility Billing Replacement - - 8 415.00 WRC Utility Billing Replacement - Total $8,415.00 121 WRC WEBSITE STANDARDIZATION 33121 WRC Website Standardization $102.00 WRC W ebsite Standardization - Total $102.50 170 WRC WMU METER MAINTENANCE 33170 WRC WMU Meter Maintenance $000 WRC WMU Meter Maintenance - Total $0.00 $1,519,118.07 Prepared By Information Technology, 04101/22 Page 23 of 24 2nd Quarter 2=pdf DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2022 2nd Quarter Y.T.D. Radio 18020 IT Radio $0.00 $0.00 $0.00 $0.00 Application Services 17040 IT - TOS Fund $0.00 $0.00 17062 Pandemic Program - COVID-19 $0.00 $24,947.25 18000 IMACS Data Warehouse (Funded) $0.00 $0.00 19000 IT Application Services Planned Maint $217,438.95 $486,763.95 30001 IT Application Services Data Warehouse $7,502.50 $18,692.50 30002 IT Application Services Enhanced $190.50 $203.75 30003 IT Application Services GIS $95,260.50 $192,36725 30004 IT Application Services eGovernment $337,990.10 $666,761.35 25108 Courts - Oakland Schools $0.00 $0.00 36901 BSBA Orion Twp - IT $0.00 $0.00 96302 -OCSO CCTV Main Jail $8,586.25 0.00 App Services - Sub Total: $666,968.80 $1,400,426.05 Internal Services 19020 Internal Services Planned Main $43,917.25 $84,268.5Q Internal Services - Sub -Total: $43,917.25 $84,268.50 $0.00 Technical Sys/Networking 19030 Tech Sys/Net Planned Maint $74,271.25 $292,520.75 23007 Oracle Support - IT Tech Systems $81.51 $245.60 23017 Oracle Support - IT Tech Systems 1.2% $18.81 $56.68 24018 SOL Sery Support - IT Tech Systems 2% $95.32 $130.13 25400 Oracle Administration $412.50 $1,320.00 95685 I.T. - Disaster Recovery $0.00 $0.00 95750 I.T. - SEP $135,762.75 $244,603.75 95755 I.T. - PeopleSoft Upgrade $0.00 $0.00 Tech Sys/Net - Sub -Total: $210,642.14 $538,876.91 Information Technology -Total: $921,528.19 $2,023,571.46 Prepared By: Information Technology, 04/01/22 Page 24 of 24 2nd Quarter 2022.pdf