HomeMy WebLinkAboutResolutions - 2022.02.24 - 35313•
BOARD OF COMMISSIONERS
February 24, 2022
MISCELLANEOUS RESOLUTION #22-041
Sponsored By: Gwen Markham
IN RE: Information Technology - Budget Amendment IT Development Report - 1st 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 First Quarter 2022 development
charges to be $1,243,295.23 for the General Fund/General Purpose County departments: and
WHEREAS direct charges to Special Revenue and Proprietary fund departments are $1,130,419.72 and non -
County agencies are $2,655.75 for the First 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
First Quarter 2022 Development Report and approves the First 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 February 25, 2022
David Woodward, Commissioner
Date: February 28, 2022
Hilarie Chambers, Deputy County Executive II
Date: March 01, 2022
Lisa Brown, County Clerk / Register of Deeds
COMMITTEE TRACKING
?022-02-09 Finance - recommend to Board
2022-02-24 Full Board
VOTE TRACKING
Motioned by Commissioner Penny Luebs seconded by Commissioner Karen Joliat to adopt the attached Budget
Amendment: IT Development Report - I st 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 Ill, Yolanda Smith Charles, Charles Cavell, Penny Luebs, Janet Jackson, Gary
McGillivray, Robert Hoffman (20)
No: None (0)
Abstain: None (0)
Absent: (0)
The Motion Passed.
ATTACHMENTS
IT Development Report - 1 st Quarter 2022
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
1, Lisa Brown, Cleric 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 February 24, 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, February 24, 2022.
Lisa Brown, Oakland Coanh, Clerk/Register ofDeeas
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
FIRST QUARTER 2022
1st Quarter
CUST FUND# ACCOUNT DIVISION Oct - Dec Y.T.D.
GOVERNMENTAL FUNDS
General Fund 11011
540
101
10100-3020201-121020-773630
52/1 - District Court
$5,165.49
$5,165.49
550
101
10100-3020301-121020-773630
5212 - District Court
$5,165.49
$5,165.49
560
101
10100-3020401 A 21020-773630
52/3 - District Court
$5,165A9
$5,165.49
530
101
10100-3020501-121020-773630
5214 - District Court
$5,165.03
$5,165.03
630
101
10100-1070801-114000-773630
Animal Control
$4,177.37
$4,171'.37
005
101
10100-5010101-180010-773630
Bell of Commissioners
$8,085.50
$8,085.50
508
101
10100-5010101-165015-773630
BOC-Legal Resource Center
$518.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-773630
Clerk Register Admin
$0.00
$0.00
722
101
10100-2010210-125000-773630
Clerk/Reg - EDMS (Imaging)
$3,343.28
$3,343.28
440
101
10100-2010301-185010-773630
Clerk/Reg- Elections
$1,430.25
$1,430.25
410
101
10100-2010501-125000-773630
Clerk/Reg - Jury Commission
$0.00
$0.00
724
101
10100-2010210-125000-773630
Clerk/Reg - Legal Records
$110,145.50
$110,145.50
726
101
10100-2010601-172190-773630
Clerk/Reg- Micrographics
$0.00
$0.00
723
101
10100-2010205-132305-773630
Clerk/Reg - Vital Statistics
$27,094.60
$27,094.60
522
101
10100-1070401-113000-773630
Community Corrections Admin
$37,970.71
$37,970.71
361
101
10100-1210101-181000-773630
Communications Department -Dev
$8,031.75
$8,03175
620
101
10100-1010201-181010-773630
Compliance Office - Auditing
$0.00
$0.00
430
101
10100-1010501-181020-773630
Corporation Counsel
$12,353.50
$12,353.50
490
101
10100-3010402.135070-773630
CTS-FD-CT Services - Clinic
$0.00
$0.00
506
101
10100-3010401-121220-773630
CTS-Fam Div -Judicial Support
$0.00
$0.00
483
101
10100-3010403-121100-773630
CTS-FD-Judicial Support -ADM
$61.37
$61.37
482
101
10100-3010403-121240-773630
CTS-FD-Juvenile Support
$1,01925
$1,019.25
015
101
10100-1 of 0101-181000-773630
County Executive
$23,080.26
$23,080.25
495
101
10100-3010201-121110-773630
Courts -Business Division
$0.00
$0.00
498
101
10100-3010301-121130-773630
Courts-GJ-Judicial Support
$275,217.33
$275,217.33
502
101
10100-3010301-121180-773630
Courts-GJ-Jury Operations
$164.09
$164.09
493
101
10100-3010101-121100-773630
Courts - Judical/Administration
$10,992.89
$10,992.89
188
101
10100-1090206-171000-773630
Economic Dev & Comm Affairs
$50.50
$50.50
785
101
10100-1090101-171000-773630
Economic Development & Community Affairs
$6,655.00
$6,656.00
740
101
10100-1020501-173010-773630
Equalization Division
$122,901.92
$122,901.92
046
101
10100-2010301-133095-773630
Elections-PandemldCOVIDI9
$0.00
$0.00
752
101
10100-1040801-148020-773630
Facility Engineering
$2,475.00
$2,475.00
660
101
10100-1020601-182020-773630
Fiscal Services -Gen Fund
$50,973.84
$50,973.84
900
101
10100-1110101-115090-773630
Emergency MgmUHomeland Security
$8,745.00
$8,745.00
562
101
10100-1060101-133300-773630
Human Services- HS Admin Sew
$23,216.50
$23,216.50
416
101
10100-1050403-183020-773630
HR Recruitment
$0.00
Koo
680
101
10100-1050401-183010-773630
Human Resources
$18,797.00
$18,797.00
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
$225.50
$225.50
872
101
10100-1070601-132030-773630
Medical Examiner
$834,12
$834.12
Prepared By: Information Technology, 01/13/2022 Page 1 of 23 1st Quarter 2022.pdf
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
FIRST QUARTER 2022
1st Quarter
CUST
FUND#
ACCOUNT
DIVISION
Oct - Dec
Y.T.D.
409
101
10100-1010702.121170-773630
MIDC OCIT Maint & Suppt
$6,489.00
$6,489.00
296
101
10100-1060801-174000-773630
MSU - Digital Media Services
$0.00
$0.00
710
101
10100-1060801-174000-773630
MSU Extension - Oakland
$0.00
$0.00
349
101
10100-4030501-112680-773630
OCSD Admin Sew -Records Unit
$0.00
$0.00
648
101
10100-4030201-112580-773630
OCSD Admin Serv-Sheriff Admin
$0.00
$0.00
163
101
101 00-4030901-1 15140-773630
OCSO - CLEMIS Forensic Lab IMS
$0.00
$0.00
775
101
10100-1090201-171000-773630
Planning & Economic Development
$25,588.75
$25,588.75
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,925.39
$2,925.39
510
101
10100-3040403-124010-773630
Probate-Estates/Mental Health Support
$10,019.87
$10,019.87
481
101
10100-3040101-121060-773630
Probate -Family Division Judicial
$0.00
$0.00
145
101
10100-4010101-122050-773630
Prosecuting Attorney- General Prosecution
$28,251.62
$28,251.62
690
101
10100-1020310-182090-773630
Purchasing
$495.00
$495.00
637
101
10100-1030803-184020-773630
Records Retention
$0.00
$0.00
650
101
10100-1020650-126020-773630
Reimbursement Division
$3,964.50
$3,964.50
195
101
101004030301-112590-773630
OCSD-Corrective Sery -Admin
$62,462.47
$62,462.47
191
101
10100-4030601-110000-773630
Sheriff-CLEMIS
$19,382.34
$19,382.34
348
101
10100-4030301-112620-773630
Sheriff- Corrective Sew Admin
$16,500.00
$16,500.00
988
101
101004030901-116240-773630
Sheriff - IFS Div Lab
$0.00
$0.00
647
101
101004030601A 10000-773630
Sheriff -Patrol Sery - LE Admin
$0.00
$0.00
206
101
101004030901-110040-773630
Sheriff - LE Support- Sew Admin
$0.00
$0.00
445
101
10 100- 1030803-1 84025-TT3630
Support Services
$9,290.81
$9,290.81
600
101
10100-7010101-186040-773630
Treasurer
$101,108.66
$101,108.66
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
$18,493.75
$18,493.75
910
101
10100-1090702-132050-773630
Veterans Services
$2,686.25
$2,686.25
730
101
10100-6010101-155010-773630
Water Resource Commissioner
$22,881.62
$22,881.62
742
101
10100-6010101-149920-773630
WRC - CAMS Software Support & Maintenance
$0.00
$0.00
203
101
10100-6010101-174452-773630
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,109,761.55
$1,109,761.55
Health Fund 12211
840
221
20221-1060201-133150-773630
Health
$66,642.50
$66,642.50
852
221
20221-1060211-133150-773630
Health Central Support
$353.50
$353.50
843
221
20221-1060220-134390-773630
Health Environmental
$52,515.65
$52,515.65
183
221
20221-1060201-133150-773630
Health Website Redesign
$0,00
$0.00
239
221
20221-1060201-133095-773630
Pub Hlth-Pandemlc/COVID19
$0`00
$0.00
Sub -Total Fund 221
$119,511,65
$119,511.65
Juvenile Maintenance Fund 12931
665
293
20293-1070901-112090-773630
Children's Village
$14,022,03
$14,022.03
668
293
20293-1070901-112010-773630
Children's Village Admin
$0.00
0.00
Sub -Total Fund 293
$14,022.03
$14,022.03
P2Cared ap. !n:orri,Aon TechaclojY; 01Ma2022 -;e 2 of 23 1st Quark: 2n22.pdf
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
FIRST QUARTER 2022
1 st Quarter
CUST FUND#
ACCOUNT
DIVISION
Oct - Dec
Y.T.D.
63600-1080101-152000-631365
DEVELOPMENT FOR GOVERNMENTAL FUND
$1,243,295.23
$1,243,295.23
APPROPRIATION
SUB -TOTAL GOVERNMENTAL DEVELOPMENT
APPROPRIATION:
$1,243,295,23
$1,243,295.23
10100-9090101-196030-773630
Information Technology Development
($1,243,295.23)
($1.243.295 23)
TOTAL GOVERNMENTAL:
0.00
$0.00
NON -GOVERNMENTAL
DIRECT CHARGES
053
Airport Special Events
$0.00
$0.00
274
ASAP Passport System
$0.00
$0.00
672
Assessment & Tax
$36,077.75
$36,077.75
935
Augusta SAW Grant
$0,00
$0.00
073
Bicentennial Celebration Grant
$0.00
$0.00
944
CAMP CTA DR Equipment
$5,102,75
$5,102.75
669
CAMS/CVT Data Conversion
$0,00
$0.00
347
Childrens Village Camera - FMO
$4,042.50
$4,042.50
309
Clean Slate- MlWorksl
$0,00
$0.00
055
CLEMIS
$1,543,85
$1,543.85
699
CLEMIS - CAD
$0.00
$0.00
448
CLEMIS/FIRMS NON -BILLABLE
$0,00
$0.00
056
CLEMIS FUND 63500
$4,498,50
$4,498.50
026
CLEMIS MIDC Bridge
$0,00
$0.00
069
CLEMIS- Training
$0.00
$0.00
749
Clerk/Reg -CPL
$0,00
$am
720
Clerk/Reg- Register Of Deeds
$11,408,37
$11,408.37
719
Cterk(Rod Automation Fund
$0.00
$0.00
659
Collaborative Asset Mgt Sys (CAMS)
$0.00
$0.00
435
Comm Dev - Housing Counselor
$0.00
$0.00
521
Community Corredions- Admin(Grant)
$3,791,25
$3,791.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-GS Enforcement
$20,058.14
$20,058.14
470
Courts -FOG 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
$0.00
$0.00
$37
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
$11,320 37
$11,320.37
750
FM&O
$20,620.90
$20,620.90
T56
FM&O Budding Maintenance
$0.00
$0.00
Prepared By Information Technology, 01/13/2022 Page 3 of 23 1at Quarter 2022.pdf
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
FIRST QUARTER 2022
1 at Quarter
CUST FUND# ACCOUNT DIVISION Oct - Dec Y.T.D.
133
FM&O Building Management System
$0.00
$0.00
080
FMO Bldg Mgmt Systems Rep Ph 2
$288.75
$288 75
342
FMO Bldg Mgmt Systems Rep Ph 4
$6,087.25
$6,087.25
048
FM&O Bldg Security Enh Proj
$0.00
$0.00
757
FM-WK Re]/Jail MgWideo Conf
$0.00
$0.00
963
FOC Security Audit
$0.00
$0.00
942
Franklin SAW Grant
$0.00
$0.00
038
HACH WIMS Software Support
$0.00
$0.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
$19
Health Medical Marijuana
$0.00
$0.00
020
Henry Graham Drain SAW Grant
$0.00
$0.00
947
HIPAA Enhancements II
$35,312.75
$35,312.75
120
HR-Financial System Replacement
$287,184.25
$287,184.25
214
IAM Program
$13,945.25
$13,945.25
338
Imaging Project
$92,969.75
$92,969.75
751
IT Telephone Communications
$26.50
$26.50
303
IT ARP Funding
$24,430.75
$24,430.75
415
IT/ARP Projects
$2,728.00
$2,728.00
202
Jail Management System (JMS)
$17,851.00
$17,851.00
185
Leasetrack
$9,363.75
$9,363.75
112
Medical Marijuana PSA
$0.00
$0.00
101
Medical Marijuana Mysidewalk
$0.00
$0.00
360
MIDC Application Maint & Support
$39,714.50
$39,714.50
113
MIDC Dev
$24,428,50
$24,428.50
164
Neighborhood Housing Development
$0.00
$0.00
192
Neptune Reports
$0.00
$0.00
265
Oakvideo MIDC Support & Maintenance
$93.00
$93.00
136
Oakland Township SDS 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,536,25
$4,536.25
298
OCSO CCTV East Annex Storage
$1,196,25
$1,196.25
934
OLV SDS SAW Grant
$0,00
$0.00
255
Oracle Upgrade to 19C
$92,981.25
$92,981.25
770
Parks and Recreation - Administration
$3,787.50
$3,787.50
S87
P&R Capital Improvement
$0.00
$0.00
372
P&R- Community Grants
$4,423.00
$4,423.00
925
P&R EMS Upgrade
$0.00
$0.00
796
P&R Facilities & Maintenance
$0.00
$0.00
442
P&R Lyon Oaks Conf Ctr CIP#2469
$0.00
$0.00
443
P&R Lyon Oaks Conf CU CIP#2468
$0.00
$0.00
454
P&R Springfield Oaks CIP#2471
$0.00
$0.00
456
P&R Springfield Oaks CIP42470
$0.00
$0.00
Prepared By: Information Technology: 01/13/2022
Page 4 of 23
st (Quarter 2022.pdf
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
FIRST QUARTER 2022
1st Quarter
CUST FUND# ACCOUNT DIVISION Oct - Dec Y.T.D.
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 Grant 795
$0.00
$0.00
237
Public Safety Dashboard
$2,062.75
$2,062.75
791
Radio Communications -E911
$58,080.75
$58,080.75
695
Risk Management
$11,068.75
$11,068.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
$221,358.50
$221,358.50
231
UCC Program IV - Wireless
$18,790.75
$18,790.75
408
Veterans Services Grant Fund
$2,449.25
$2,449.25
656
Water Resources Accounting
$164.09
$164.09
731
Water Resource - Equipment
$0.00
$0.00
736
WinCan Central Storage Solution
$0.00
$0.00
930
Water and Sewer -General Adm
$13,300.75
$13,300.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 Prot
$1,553.50
$1,553.50
281
WRC
$0.00
$0.00
670
WRC Acctg - Crowder POct
$0.00
$0.00
344
WRC Administration
$2,958.00
$2,958.00
929
WRC Aeration Tank Rehab
$0.00
$0.00
940
WRC-CAMP
$79.00
$79.00
926
WRC CLINTON-OAKLAND SCADA
$0.00
$0.00
932
WRC CLINTON-OAK SDS SCADA Main
$0.00
$0.00
P77
WRC-GWKPCF-WRC SCADA
$0.00
$0.00
377
WRC-SAW ACACIA
$0.00
$0.00
382
WRC-SAW Birmingham
$0.00
$0.00
379
WRC-SAW Commerce Township
$0.00
$0.00
387
WRC- SAW Evergreen Farmington
$0.00
$0.00
389
WRC-SAW Lake Orion
$0.00
$0.00
388
WRC-SAW Novi
$0.00
$0.00
386
WRC - SAW Orchard Lake
$0.00
$0.00
674
WRC - SAW Grant Labor
$0.00
$0.00
381
WRC SAW GWK
$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
Pmpared By nforrOon Technology: D1/13I2022
Page 5 of 23
1st Quarter 2022.ptlf
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
FIRST QUARTER 2022
1st Quarter
COST FUND# ACCOUNT DIVISION Oct - Dec Y.T.D.
728
WRC - CO SDS SewMet
$0.00
$0.00
168
WRC CRWRRFAdmin Bldg Rehab
$0.00
$0.00
729
WRC - EF SDS SewMet
$0.00
$0.00
737
WRC- Data Application Pilot Polect
$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 W IMS Implementation
$0.00
$0.00
894
WRC- HACH WIMS Implementation Phase ll
$0.00
$0.00
733
WRC - Hydro Drain Project
$0.00
$0.00
671
WRC - Infrastructure Op Ar
$0.00
$0.00
982
WRC Keego Harbor SAW
$0.00
$D.00
299
WRC - MISS DIG Ticket Mgmt Sys
$0.00
$0.00
236
WRC Oaklabnd Macomb Interceptor
$0.00
$0.00
981
WRC Oxford Two SAW
$0.00
$0.00
501
WRC Permitting Impl
$1,938.75
$1,938.75
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
$660.00
$660.00
294
WRC-Sewer Fund
$8,039.75
$8,039.75
067
WRC Utility Billing Replacement
$8,000.00
$8,000.00
023
WRC Walled Lake Water
$0.00
$0.00
024
WRC Walled Lake SDS
$0.00
$0.00
121
WRC Website Standardization
$102.50
$102.50
170
WRC WMU Meter Maintenance
$0.00
$0.00
63600-1080101-152000-631302 SUB -TOTAL DIRECT CHARGES FOR DEVELOPMENT
$1 130 419.72
$1,130,419.72
TOTAL COUNTY DEVELOPMENT CHARGES
$2,373,714.95
$2,373,714.95
NON -COUNTY AGENCIES
63600-1080101-152000-635017 Non -County Agencies
$2,655.75
12655.75
Prepared By: Information Technology: 01/13/2022 Page 6 of 23 1st Quarter 2022.odf
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2022
Cust# GOVERNMENTAL FUNDS
1st Otr2022
630
ANIMAL CONTROL
24017
SQL Server Supp - Animal Control
$61.37
95628
Animal Control
$153.75
95682
Dog System
$3,962.25
Animal Control -Total
$4,177.37
005
BD OF COMMISSIONERS
91404
BOC - Customer Support
$8,08550
Bd of Commissioners - Total
$8,085.50
508
BOC-LEGAL RESOURCE CENTER
61001
Library Services
91405
Library Board
$518.00
BOC-Legal Resource Center - Total
$518.00
665
CHILDRENS VILLAGE
95665
Childrens Village
$14 022.03
Children Village - Total
$14,022.03
668
CHILDREN'S VILLAGE ADMIN
97668
Childrens Village Admin
$0.00
Childrens Village Admin - Total
$0.00
725
CLERKIREG -ADMIN
72500
Clerk -Admin
$0.00
Clerk/Reg - Admin - Total
$0.00
440
CLERK/REG - ELECTIONS DIVISION
95443
Clerk/Reg - Elections Division
$1,430.25
Clerk/Reg - Elections Division - Total
$1,430.25
722
CLERK/REG - EDMS (IMAGING)
95158
Clerk/Reg - EDMS Support/Maintenance/Upgrades
$3,343.28
13001
Clerk's-Efiling
$0.00
Clerk/Reg - EDMS (Imaging) - Total
$3,343.28
410
CLERKIREG -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
$62,245.50
95170
Clerk/Reg - Legal Records
$42,819.50
21013
Legal Division - 50°%
$1,019.25
31001
Clerk Division - 50%
$4,061.25
Clerk/Reg - Legal Records - Total
$110,145 50
723
CLERK - VITAL STATISTICS
24015
SOL Server Supp - Vital State 3.5%
$61.37
95161
Clerk. Reg - Vital Statistics
$27,033.23
Clerk - Vital Statistics - Total
$27,094.60
Prepared By Information Technology; 01/13/2022
Page 7 of 23
1st Quarter 2022.pdf
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT i SUPPORT DETAIL - FIRST QUARTER 2022
522
COMMUNITY CORRECTIONS-ADMIN 1
23003
Oracle Support -Comm Corr- 5.2%
$164.09
24012
SQL Server Supp - Community Corr 3.5%
$61.37
52200
Comm Corr-Admin (County)
$37,745.25
52201
Comm Corr - DW Support
0.00
Community Corrections - Total
$37,970.71
361
COMMUNICATIONS DEPARTMENT- DEV
95361
Communications Department - Dev
$8,031.75
Communications Department - Dev - Total
$8,031.75
620
COMPLIANCE OFFICE -AUDITING
44034
Auditing - New Development
$0.00
95468
Auditing Internal Sry - Cust Sup
$0.00
Compliance Office - Auditing - Total
$0.00
690
COMPLIANCE OFFICE - PURCHASING
44029
Pur-New Development
$0.00
44028
Purchasing System Enhancements
$495.00
Compliance Office - Purchasing - Total
$495.00
430
CORPORATION COUNSEL_
95501
Corporation Counsel
$12,353.50
Corporation Counsel - Total
$12.353.50
015
COUNTY EXECUTIVE
95654
County Exec -Development
$18,29525
95656
County Executive Support
$4,785.00
County Executive - Total
$23,080.25
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 Whse 2.6%
0.00
CTS-Business Division - Total
$0.00
506
CTS-FAM DIVJUDICIAL SUPPT
95187
CTS-Faro Div -Judicial Support
$0.00
CTS-Faro Div -Judicial Support - Total
$0.00
483
CTS-FD-JUDICIAL SUPPORT -ADM
24009
SQL Sery Supp - CTS-Jud Sup Adm - 3.5%
$61.37
95193
0.00
CTS-FD-Judicial Support-Adm - Total
$61.37
482
CTS-FD JUVENILE SUPPORT
48200
CTS-Jud Support - Juv Support
$1,019.25
CTS-Jud Support - Juv Support - Total
$1,019.25
498
CTS-GEN JURISJUDICIAL SUPPT
95179
CTS-Gen Juris-Judicial Suppt
$271,074.02
31002
CTS-Gen Suppt
$4,061.25
Prepared By: Information Technology: 01/13/2022
Page 8 of 23
1st Quarter 202.pdf
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - FIRST QUARTER 2022
23010 Oracle Support-CCT/CTS
CTS-Gen Juris-Judicial Suppt- Total
502 CTS-GJ-JURY OPERATIONS 23008 Oracle Support-CTS-GJ-Jury Operations
CTS-GJ-Jury Operations - Total
493 CTSJUDICIAL ADMIN 95174 CTS-Judicial Admin
13002 Court's - Eflling
49300 Courts Web Redesign
CTS-Judicial Admin - Total
188 ECONOMIC DEV & COMM AFFAIRS. 98180 EDCA - One Stop Shop
Economic Dev & Comm Affairs - Total
786 ECONOMIC DEVELOPMENT & COMMUNITY AFFAIRS 36500 GIS Implementation Support C&E Dev
36501 CED Application - H/W Support
95785 Comm & Eco Developmt
Economic Development & Community Affairs - Total
740 EQUALIZATION
752 FACILITY ENGINEERING
660 FISCAL SERVICES-GEN FUND,
Prepared By Information Technology, 01/13/2022
23012
Oracle Support -Equalization - 5.2%
24005
SQL Server Supp-Equalization - 10.5%
31075
Equal - Development
36505
GIS Implementation Support Equalization
36506
Equal Application - H/W Support
36507
Equal LAMS Support
36601
Land System Enhancements - Equal (50%)
36701
Land System Maintenance - Equal (50%)
36801
Land System Support - Equal (50%)
36902
BS&A Orion Twp
50101
EQUAL(BS&A ANNUAL)
95562
Equalization - DW Support
95693
Equalization - System Maintenance
95699
BS&A Master Appraisal Sup/Maint
Equalization - Total
75201 Facility Engineering
Facility Engineering - Total
23001 Oracle Support - Fiscal Sew - 15.6%
23013 Oracle Support - HR-Acctg/Budget - 5.2%
24006 SQL Saw Supp - HR-Acctg - 1.75%
44021 FS-System/Customer Support
44022 FS - System Maintenance
Page 9 of 23
82.06
$275,217.33
164.09
$164.09
$10,992.89
$0.00
0.00
$10,992.89
50.50
$50.50
$571'.50
$0.00
6 077.50
$6,655.00
$164.09
$184.09
$4,257.75
$247.50
$8,017.00
$22,311.50
$18,085.74
$742.50
$10,508.25
$0.00
$0.00
$0.00
$0.00
$58 383.50
2 475.00
$492.26
$164.09
$30.69
$21,947.50
$5,171.50
$122,901.92
$2,475.00
let Quarter 2022.pdf
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - FIRST QUARTER 2022
44023
FS - System Enhancements
$0.00
44024
FS - New Development
$0.00
44602
Bond Disclosure - Fiscal (50%)
$0.00
96001
Fiscal Sery - Acctg 40%
$15,445.20
96003
Fiscal Sery - Budget 20%
L7,722.6
Fiscal Services -Gen Fund - Total
$50,973.84
852
HEALTH CENTRAL SUPPORT
95852
Health Central Suppo
$353.50
Health Central Support - Total
$353.50
840
HEALTH DIVISION
36525
GIS Implementation Support Health
$0.00
95563
User Support -Health
$28,263.00
96842
Health Admin
$38 379.50
Health - Total
$66,642.50
843
HEALTH - ENVIRONMENTAI,
23005
Oracle Support - EH Projects - 5.2%
$164.09
24014
SQL Server Suppt - Ehealth 14%
$245.42
84200
EH - Projects
$51,982.39
B4300
Ehealth Program
$123.75
Health -Environmental - Total
$52,515.65
183
HEALTH WESSITE REDESIGN
96183
Health Website Redesign
0.00
Health Website Redesign - Total
$0.00
900
HOMELAND SECURITY
36545
GIS implementation Support Homeland Security
$495.00
36546
Homeland Security Application - H/W Support
$8,002.50
98990
Homeland Security
$247.50
Homeland Security - Total
$8,745.00
680
HUMAN RESOURCES
23014
Oracle Support-HR/Personnel - 5.2%
$164.09
24007
SQL Server Suppport-HR/Personnel - 1,75%
$30.69
44044
HR- New Development
$0.00
96002
Human Res -Personnel 40%
$18,60222
Human Resources - Total
$18,797.00
562
HUMAN SERVICES - HS ADMIN SERV
96561
Human Services - HS Admin Services
$23,216.50
Human Services - HS Admin Services - Total
$23,216.50
338
IMAGING PROGRAM
33800
Imaging Project
$0.00
Imaging Project - Total
$0.00
907
LIBRARY -LIBRARY ADMIN
91405
Library Board
0.00
Library - Library Admin - Total
$0.00
Prepared By Information Technology; 0103/2022
Page 10 of 23
let Quarter 2022.pdf
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2022
824
LIBRARY SERVICES
61001
Library Services
$0.00
Library Services - Total
$0.00
565
MARKETING & COMMUNICATIONS
56500
Marketing & Communications
$225.50
Marketing & Communications - Total
$225.50
872
MEDICAL EXAMINER
24002
SQL Server Support - Medical Exam - 3.5%
$61.37
87202
Medical Examiner- Customer Support
$772.75
Medical Examiner - Total
$834 12
409
MIDC OCIT MAINT & SUPPT
67409
MIDC OCIT Maint & Suppt
$6,489.00
MIDC OCIT Maint & Suppt - Total
$6,489.00
710
MSU EXTENSION - OAKLAND
95676
MSU Ext Equipment Maintenance
$0.00
MSU Extension - Oakland - Total
$0.00
349
OCSD ADMIN SERV-RECORDS MGMT
97349
OCSD Admin Serv-Reco
$0.00
OCSD Admin Sew -Records Mamt - 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
$25,588.75
Planning & Eco Development - Total
$25,588.75
512
PROB-ESTATES/MENTL HLTH EDMS IIMGI
95207
PC-E/MH EDMS Support & Mice
$2,925.39
Prob-Est/Mntl Hlth EDMS (Img) - Total
$2,925.39
510
PROB-ESTATES/MENTL HLTH SUPPORT
24010
SOL Sew Supp-PCT-Est/Mental - 3.5%
$61.37
92198
Prob-Est/Mnd Hlth Support
$9 958.50
Prob-Est/Mnd Hith Support- Total
$10,019.87
481
PROB-FD JUDICIAL
95168
PC -Judicial Family Admin-Family Judges
0.00
Prob - FD Judicial - Total
$0.00
479
PROB-FD JUDICIAL SUPPORT
95188
Prob-FD Judicial Support
$0.00
Prob-FD Judicial Support - Total
$0.00
145
PROSECUTOR - GENERAL PROSECUTION
24016
SOL Server Supp - Proescutors 3.5°%
$61.37
Prepared
By Information Technology, 01/13/2022
Page 11 of 23
1st Quarter 2022.pdf
239 PUB HEALTH-PANDEMIC/COVIDI9
637 RECORDS RETENTION
650 REIMBURSEMENT
648 OCSD ADMIN SERV-SHERIFF ADMIN
195 OCSD-CORRECTIVE SERV -ADMIN
191 SHERIFF - CLEMIS
348 SHERIFF -CORRECTIVE SERV ADMIN
988 OC SHERIFF'S - IFS DIV - LAB
647 OCSD PATROL SERV-LE ADMIN
206 OCSD - LE SUPPORT SERV ADMIN
445 SUPPORT SERVICES
Prepared By: Information Technology; 01/13/2022
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - FIRST QUARTER 2022
95622
Prosecutor/Executive
95664
Prosecutor Warrants
97001
Prosecutor Data Proc
Prosecutor- Total
96239
Pub Health-Pandemic/COVID19
Pub Health-PandemiclCOVIDI9 - Total
44053
REC - System Enhancements
Records Retention - Total
95470
Reimbursement System
95542
Reimburse User Support
Reimbursement - Total
97548
OCSD Admin Serv-Sher
OCSD Admin Serv-Sheriff Admin - Total
12001
OCSD-Courts/Criminal - 50%
23009
Oracle Suppport - OCSD/CTS Crim W hse - 2.6%
97163
Sheriff
97164
Sheriff - Development
97165
Sheriff-DW Support
98164
CLEMIS-Sheriff
Sheriff - Total
23015
Oracle Suppport - Sheriff / CLEMIS - 5.2%
96163
Sheriff - CLEMIS
Sheriff - CLEMIS - Total
34800
Inmate Phone System
Sheriff - Corrective Sew Admin - Total
16300
OC Sheriffs - IFS Div - Lab
OC Sheriffs - IFS Div - Lab - Total
97647
Sheriff - Patrol Sew -LE Admin
Sheriff - Patrol Sew -LE Admin - Total
97206
OCSD - LE Support Sew Admin
OCSD - LE Support Sew Admin - Total
23002
Oracle Support - Supp Sew - 5.2%
Page 12 of 23
$27,366.25
$164.00
660.00
$28,251.62
0.00
$0.00
$0.00
$0.00
$3,510.75
453.75
$3,964.50
0.00
$0.00
$0.00
$82.06
$0.00
$10,026.16
$0.00
$52,354.25
$164.09
19 218.25
$16,500.00
$0.00
0.00
$0.00
$164.09
$62,462.47
$19,382.34
$16,500.00
$0.00
$0.00
$0.00
1st Quarter 2022.pdf
600 TREASURER
169 TREASURERS - BANKING RFP
627 TREASURER- LANDSALE
978 TREASURERS OFFICE-OAKDOCS
910 VETERANS SERVICES
730 WATER RESOURCE
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2022
24011
SQL Server Supp - Suppt Services 7%
$122.72
44500
Support Services
$9,004.00
Support Services - Total
$9.290.81
23006
Oracle Support - Del Tax - 5.2%
$164.09
23016
Oracle Support - Treasurer - 10A%
$328.17
36516
Treasurer Application - H/W Support
$0.00
36602
Land System Enhancements - Trees (50%)
$18,085.51
36702
Land System Maintenance - Trees (50%)
$742.50
36802
Land System Support - Tress (50%)
$10,508.25
44061
Tre-System/Customer Support
$42,056.39
44062
Tre-System Maintenance
$1,004.00
44063
Tre-System Enhancements
$11,205.50
44064
Tre-New Development
$328.00
44080
Tre-DW Support
$0.00
44082
Tre-DW Maintenance
$0.00
44601
Bond Disclosure - Tress (50%)
$0.00
50102
TREAS )BS&A) ANNUAL
$0.00
95008
Del Tax On Line
$1,650.00
95303
Del Tax System Maintenance
$0.00
95561
User Support/Del Tax
$11,541.25
95615
BS&A Annual Tax Support
$3,495.00
Treasurer - Total
$101,108.66
96169
Treasurers Banking
0.00
Treasurers Banking RFP
$0.00
44083
Treasurer-Landsale
0.00
Treasurer -Landsale - Total
$0.00
95978
Treasurers - OakDocs
$18 493.75
Treasurers Office-OakDocs - Total
$18,493.75
95651
Veterans Customer Support
$2,686.25
95650
Veterans Services-Eq
0.00
Veterans Services - Total
$2,686.25
24008
SQL Server Supp - W RC 3.5%
$61.37
28007
Water Resource Comm
$14,767.50
28010
W RC - Customer Support
$5,280.00
28011
Water Resource Commissioner Application
$2,731.50
36520
GIS Implementation Support WRC
$41.25
Prepared By: Information Technology, 01/13/2022 Page 13 of 23 1st Quarter 2022.pdf
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - FIRST QUARTER 2022
36521
WRC Application - HIW Support
Water Resource Commissioner - Total
742
WRC - CAMS SOFTWARE SUPPORT & MAINTENANCE
74200
WRC CAMS SOFTWARE Support
WRC CAMS SOFTWARE Support - Total
301
WRC - SOIL EROSION SOFTWARE SOL
74301
WRC - Soil Erosion Software Sol
WRC - Soil Erosion Software Sol - Total
540
5211 DISTRICT COURT - NOVI
95527
DC Suprt- 52/1 - 25%
5211 District Court - Total
550
5212 DISTRICT COURT - CLARKSTON.
95528
DC Suprt 52/2 - 25%
52/2 District Court - Total
560
52/3 DISTRICT COURT - ROCHESTER.
95288
52 Dist Ct Div 3
95529
DC Suprt - 52/3 - 25%
52/3 District Court - Total
530
5214 DISTRICT COURT - TROY
95530
DC Suprt- 52/4 - 25%
52/4 District Court - Total
Cust# NON -GOVERNMENTAL -DIRECT FUNDS
274 ASAP PASSPORT SYSTEM
672 ASSESSMENT & TAX
935 AUGUSTA SAW GRANT
073 BICENTENNIAL CELEBRATION GRANT
944 CAMP CTA DR EQUIPMENT
347 CHILDRENS VILLAGE CAMERA. FMO
Prepared By: Information Technology; 01/13/2022
97274 ASAP Passport System
ASAP Passport System - Total
67200
Assessment & Tau
Assessment & Tax - Total
31935
Augusta SAW Grant
Augusta SAW Grant - Total
91073
Bicentennial Celebration Grant
Bicentennial Celebration Grant - Total
37944
Camp CTA DR Equipment
Camp CTA DR Equipment - Total
21347
Childrens Village Camera - FMO
Childrens Village Camera - FMO - Total
Page 14 of 23
0.00
$0.00
0.00
$5,165.49
5 165.49
$5,165.49
0.00
5 165.03
0.00
$36,077.75
$0.00
0.00
5 102.75
042.50
$22,881 62
$0.00
$0.00
$5,165.49
$5,165.49
$5,165.49
$5,165.03
$0.00
$36,077.75
$0.00
$0.00
$5,102.75
$4,042.50
1 st Quarter 2022.pdf
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2022
055
CLEMIS
23004
Oracle Support - OakVideo CLEMIS 5.2%
$164.09
23018
Oracle Support - Sheriff CLEMIS 5.2%
$164.00
24004
SQL Server Support - 24.5%
$429.51
95430
CLEMIS Maintenance
$0.00
95431
CLMS Enhancements
$580.00
98003
CLEMIS User Support
$0.00
98005
CLEMIS - E911 Support
$0.00
98000
Project Team
$206.25
CLEMIS - Total
$1,543.85
699
CLEMIS - CAD
98006
CLEMIS - CAD Development
$0.00
CLEMIS - CAD - Total
$0.00
056
CLEMIS FUND 63500
63500
CLEMIS Fund
$4,498.50
CLEMIS 63500 Fund - Total
$4,498.50
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
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
0.00
Clerk/Reg - CPL - Total
$0.00
720
CLERK I REGISTER OF DEEDS
24003
SOL Server Supp - ROD 3.5%
$61.37
36510
GIS Implementation Support
$0.00
36511
ROD Application - H/W Support
$6,680.75
95493
ROD System Maintenance
$0.00
95498
Clerk/Reg - ROD
$4,666.25
Clerk/Reg of Deeds - Total
$11,408.37
719
CLERK/ROD AUTOMATION FUND
95719
Register of Deeds AU
0.00
Clerk/ROD Automation Fund - Total
$0.00
659
COLLABORATIVE ASSET MGT SYS
65901
Collabortive Asset Mgt Sys
0.00
Collabortive Asset Mgt Sys - Total
$0.00
Prepared By Information Technology; 01/13/2022
Page 15 of 23
1at Quarter 2022.pdf
937 COWS SAW GRANT
471 CTS-FOC-EXP-CS ENFORC-EDMS (IMG1
507 CTS-FOC EXP-CS ENFORCEMENT
521 COMM CORR-ADM (GRANT
045 CV RADIO SUPPORT REPLACEMENT
673 CYBER SECURITY FUND
931 DRAIN EQUIPMENT FUND
933 DRAIN EQUIP MAP
837 EDCA - MITRADESCHOOL.ORG GRANT
100 FARMINGTON HILLS SDS SAW
210 FIRE RECORDS MANAGEMENT SYSTEM
750 FM&O
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2022
37937 COSDS SAW Grant
COSDS SAW Grant - Total
92194 CTS-FOC-CS ENF-EDMS Support/Maintenance/Upgrades
CTS-FOC Exp-CS Enforc-EDMS (Img) - Total
92193 CTS-FOC Exp-CD Enforc-Dev
92194 CTS-FOC-CS ENF-EDMS
CTS-FOC Exp-CD Enforc-Dev - Total
52102 Comm Corr-Adm (Grant)
52100 Community Corrections C'Star EB
Comm Corr - Adm (Grant) - Total
95045 CV Radio Support Replacement
CV Radio Support Replacement - Total
67300 Cyber Security Fund
Cyber Security Fund - Total
37934 Drain Equipment Fund
Drain Equipment Fund - Total
37933 Drain Equip Map
Drain Equip Map -Total
83700 EDCA- MITRADESCHOOL
EDCA - MlTradeSchool.org Grant - Total
33099 Farmington Hills SDS
Farmington Hills SDS - Total
21010 Fire Records Mgmt Fund 531
95404 SQL Server Support - FIRMS 3.5%
24001 FRMS - Phase II Proj
Fire Records Management System - Total
21001 Facilities Maintenance & Operations
24013 SOL Server Supp - FM&O
75503 FM&O Development
FM&O - Total
0.00
0.00
$17,132.75
2 925.39
$0.00
3 791.25
$0.00
0.00
0.00
$0.00
0.00
OAO
$61.37
$11,259.00
$0.00
$2,128.78
$61.37
$18,430.75
$0.00
$0.00
$20,05&14
$3,791.25
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$11,320.37
$20,620.90
Prepared By: Information Technology; 01/13/2022
Page 16 of 23
1st Quarter 2022 par
756 FM&O BUILDING MAINTENANCE
133 FM&O BUILDING MANAGEMENT
080 FMO BLDG MGMT SYSTEMS REP PH 2
342 FMO BLDG MGMT SYSTEMS REP PH 4
963 FOC SECURITY AUDIT
942 FRANKLIN SAW GRANT
038 HACH WIMS SOFTWARE SUPPORT
380 HEALTH -IMMUNIZATION GRANT
173 HEALTH - LEAD INNOVATION GRANT,
319 HEALTH MEDICAL MARIJUANA
947 HIPAA ENHANCEMENTS II
120 HR-FINANCIAL SYSTEM REPLACEMENT.
214 IAM PROGRAM
338 IMAGING PROJECT
303 IT ARP FUNDING,
Prepared By Inforna6on Technology; 01/13/2022
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - FIRST QUARTER 2022
75600
FM&O Building Maintenance
$000
FM&O Building Maintenance - Total
$0.00
21133
FM&O Building Manage
$000
FM&O Building Manage - TOW
$9.00
21080
FM&O Bldg Mgmt Sys Rep
288.75
FMO Bldg Mgmt Systems Rep PH 2 - Total
$288.75
74342
FMO Bldg Mgmt Sys Rep Ph 4
$6,087.25
FMO Bldg Mgmt Sys Rep Ph 4 - Total
$6.087.25
34963
FOC Security Audit
0.00
FCC Security Audit - Total
$0.00
37942
Franklin SAW Grant
0.00
Franklin SAW Grant - Total
$0.00
74038
HACH WIMS Software Support
$0.00
HACH WIMS Software Support- Total
$0.00
38000
Health -Immunization Grant
$0.00
Health -Immunization Grant -Total
$0.00
96173
Health - Lead Innovation
0-00
Health - Lead Innovation - Total
$0.00
96319
Health Medical Marijuana
$0.00
Health Medical Marijuana - Total
$0.00
96947
HIPAA Enhancements II
$35,312.75
HIPAA Enhancements II - Total
$35,312.75
44120
HR-Financial Sys Rep
$287,184.25
HR-Financial Sys Rep - Total
$287,184.25
21400
IAM Program
$13,945.25
IAM Program - Total
$13,945.25
33800
Imaging Project
$92 969.75
Imaging Project - Total
$92,969.75
17303
IT ARP Funding
$24,430.75
Page 17 of 23
1st Quarter 2022.pdf
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - FIRST QUARTER 2022
IT ARP Funding - Total
415
ITIARP PROJECTS
97415
IT/ARP Projects
IT/ARP Projects - Total
751
IT - TELEPHONE COMMUNICATIONS
75102
Telephone Communications - Customer Support
IT - Telephone Communications - Total
202
JAIL MANAGEMENT SYSTEM (JMS)
63202
Jail Management System (JMS)
Jail Management System (JMS) - Total
185
LEASETRACK REPLACEMENT
18500
Leasetrack Replacement
Leasetrack Replacement - Total
112
MEDICAL MARIJUANA PSA
96112
Medical Marijuana PSA
Medical Marijuana PSA - Total
360
MIDC APPLICATION MAINT & SUPPORT
67360
MIDC Application Maint & Support
MIDC Application Maint & Support- Total
113
MIDC DEV
91113
MIDC DEV
MIDC DEV -Total
136
OAKLAND TOWNSHIP SDS SAW
33136
Oakland Township SDS
OAKLAND TOWNSHIP SDS SAW - Total
634
OAKVIDEO UPGRADE (BA),
63400
CLEMIS - OakVideo Upgrade
63401
IT - OakVideo Upgrade
OakVideo Upgrade (BA) - Total
938
OAKWIN RADIO SYSTEM ENH
98938
OAKWIN Radio System Enh
OAKWIN Radio System Enh - Total
653
O.C. INTNL AIRPORT
36540
GIS Implementation Support
65301
Airport User Support
65310
O.C. Airport - New D
O.C. Intnl Airport - Total
298
OCSO CCTV EAST ANNEX STORAGE
97298
OCSO CCTV East Annex Storage
OCSO CCTV East Annex Storage - Total
934
OLV SDS SAW GRANT
37934
OLV SDS SAW Grant
OLV SDS SAW Grant - Total
Prepared
By Information Technology; 01/13/2022
Page 18 of 23
$24,430.75
2 728.00
$2,728.00
26.50
$26.50
17 851.00
$17,851.00
9 363.75
$9,363.75
$0.00
$0.00
$39.714.50
$39,714.50
$24,428.50
$24,428.50
$0.00
$0.00
$0.00
$000
$0.00
0.00
$0.00
$0.00
$4,331.25
205.00
$4,536.25
$1, 196.25
$1,196.25
o.00
$0.00
1 st Quarter 2022 pdf
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2022
265 OAKVIDEO MIDC SUPPORT & MAINT
255 ORACLE UPGRADE TO 19C
770 PARKS AND RECREATION
867 P&R CAPITAL IMPROVEMENT
372 PARKS & RECREATION COMMUNITY GRANTS
925 P&R EMS UPGRADE
442 P&R LYON OAKS CONF CTR CIP#2469
443 P&R LYON OAKS CONF CTR CIP#2468
454 P&R SPRINGFIELD OAKS CIP#2471
456 P&R SPRINGFIELD OAKS CIP#2470
457 P&R RED OAKS CLUBHOUSE CIP#2467
268 PONTIAC METER
Prepared By: Information Technology, 01/13/2022
91265
Oakvideo MIDC Support & Malnt
$93.00
Oakvideo MIDC Support & Maint - Total
$93.00
63255
Oracle Upgrade to 19C
$92,981.25
Oracle Upgrade to 19C - Total
$92,981.25
36530
GIS Implementation Support - Parks
$735.00
44066
PRADM-System/Customer Support
$742.50
44068
PRADM-System Enhancements
$0.00
76100
P&R Administrative Services
$0.00
95413
PRADM-Customer Support
$2.310.00
95416
PRRA -Rec Admin
$0.00
95419
PRADM-Administration
$0.00
Parks & Recreation - Total
$3,787.50
86700
P&R Capital Improvement
$0.00
P&R Capital Improvement - Total
$0.00
77372
PR - Community Grants
$4,423.00
PR - Community Grants - Total
$4,423.00
37925
P&R EMS Upgrade
$000
P&R EMS Upgrade - Total
$0.00
44200
P&R Lyon Oaks Conf Ctr CIP #2469
0.00
P&R Lyon Oaks Conf Ctr CIP #2469 - Total
$0.00
44300
P&R Lyon Oaks Conf CTR CIP#2468
0.00
P&R Lyon Oaks Conf CTR CIP#2468 - Total
$0.00
45400
P&R Springfield Oaks CIP#2471
0.00
P&R Springfield Oaks CIP#2471 - Total
$0.00
45600
P&R Springfield Oaks CIP#2470
0 00
P&R Springfield Oaks CIP#2470 - Total
$0.00
45700
P&R Red Oaks Clubhouse CIP#2467
$0.00
P&R Red Oaks Clubhouse CIP#2467 - Total
$0.00
74268
Pontiac BSA to W RC - Water
$0.00
Pontiac Meter - Total
$0.00
Page 19 of 23
1st Quarter 2022.pdf
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2022
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
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
237
PUBLIC SAFETY DASHBOARD
65237
Public Safety Dashboard
$2,062.75
Public Safety Dashboard - Total
$2,062.75
791
RADIO COMMUNICATIONS - E911
79101
Radio Communications - E911
$58Q80.75
Radio Communications - E911 - Total
$58.080.75
695
RISK MANAGEMENT
44036
Rsk-System Customer Support
$9,296.75
44038
$1,772.00
Risk Management - Total
$11,068.75
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
$221,358.50
UCC Program III - VOIP - Total
$221,358.50
231
UCC PROGRAM IV - WIRELESS
23100
UCC Program IV - Wireless
$18,790.75
UCC Program IV - Wireless - Total
$18,790.15
408
VETERANS SERVICES GRANT FUND
96408
Veterans Services Grant Fund
$2,449.25
Veterans Services Grant Fund - Total
$2,449.25
731
WATER RESOURCE - EQUIPMENT
74501
Water Resources - OP
0.00
Water Resource - Equipment - Total
$0.00
656
WATER RESOURCES ACCOUNTING
23011
Oracle Supp - Water & Sewer AccVg - 5.2%
$164.09
95669
Water Resources Accounting
$0.00
95671
Drain Water/Sewer BI
0.00
Prepared By: Information Technology; 01/13/2022
Page 20 of 23
1st Quarter 2022.per,
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2022
Water Resources Accounting - Total
$164.09
736
WINCAN CENTRAL STORAGE SOLUTION
73601
WinCan Central Storage Solution
$0.00
W inCan Central Storage Solution - Total
$0.00
930
WATER AND SEWER -GENERAL ADMIN
37930
Water and Sewer -General Admin
$13300.75
Water and Sewer -General Admin - Total
$13,300.75
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 Gen Admin-WMU
$0.00
Water and Sewer Gen Admin-WMU - Total
$0.00
201
WATER AND SEWER GEN ADM - XC2
35201
Water and Sewer Gen Ad
$0.00
Water and Sewer Gen Adm - XC2 - Total
$0.00
212
WORKFORCE DEV - CLEAN SLATE PROJ
95212
Workforce Dev - Clean Slate Proj
$1,55150
Workforce Dev - Clean Slate Proj - Total
$1,553.50
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
929
WRC AERATION TANK REHAB
35700
WRC Aeration Tank Rehab
$0.00
WRC Aeraton Tank Rehab - Total
$0.00
940
WRC - CAMP
37940
WRC - Camp
$79.00
WRC - Camp - Total
$79.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
281
WRC
74281
WRC
0.00
WRC - Total
$0.00
344
WRC ADMINISTRATION
75344
WRC Administration
$2,958.00
WRC Administration - Total
$2,958.00
894
WRC- HACH WIMS IMPLEMENTATION
37894
WRC-HACH WIMS Implementation
0.00
Prepared
By Information Technology; 01/13=22
Page 21 of 23
1st Quarter 2022.pdf
982 WRC KEEGO HARBOR SAW
236 WRC OAKLAND MACOMB INTERCEPTOR.
501 WRC PERMITTING IMPL
979 WRC PERMITTING IMPLEMENTATION
377 WRC - SAW ACACIA
382 WRC SAW BIRMINGHAM
403 WRC SAW BLOOMFIELD VILLAGE
379 WRC - SAW COMMERCE TOWNSHIP
387 WRC SAW EVERGREEN FARMINGTON
402 WRC SAW HURON ROUGE
389 WRC SAW LAKE ORION
388 WRC SAW NOVI
386 WRC - SAW ORCHARD LAKE
674 WRC - SAW GRANT LABOR
Prepared By Inforn abon Technology; 01/13/2022
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - FIRST QUARYER 2022
WRC-HACH W I MS Implementation - Total
$0.00
33992
WRC Keego Harbor SAW
$0.00
WRC Keego Harbor SAW - Total
$0.00
33236
WRC Oakland Macomb Interceptor
0.00
WRC Oakland Macomb Interceptor - Total
$0.00
74502
WRC Pennittting Impl
$1,938.75
WRC Permitthng Impl - Total
$1,938.75
74979
WRC Permitting Implementation
SID.00
WRC Permittting Implementation - Total
$0.00
28674
WRC - SAW Acacia
$0.00
33377
WRC - SAW Acacia
0.00
WRC - SAW Acacia - Total
$0.00
33382
WRC SAW Birmingham
$0.00
WRC SAW Birmingham - Total
$0.00
33403
WRC SAW Bloomfield Village
$0.00
WRC SAW Bloomfield Village - Total
$0.00
33379
WRC - SAW Commerce Township
0.00
WRC - SAW Commerce Township - Total
$0.00
33387
WRC SAW Evergreen Farmington
$0.00
WRC SAW Evergreen Farmington - Total
$0.00
33402
WRC SAW Huron Rouge
0.00
WRC SAW Huron Rouge - Total
$0.00
33389
WRC SAW Lake Orion
0.00
WRC SAW Lake Orion - Total
$0.00
33388
WRC SAW Novi
$0.00
WRC SAW Novi - Total
$0.00
33386
WRC - SAW Orchard Lake
0.00
WRC - SAW Orchard Lake - Total
$0.00
28674
WRC - SAW Grant Labor
1A.00
Page 22 of 23
1st Quarter 2M.pdf
INFORMATION TECHNOLOGY
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2022
1stQuarter
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
$24,947.25
$24,947.25
18000
IMACS Data Warehouse (Funded)
$0.00
$0.00
19000
IT Application Services Planned Maint
$269,325.00
$269,325.00
30001
IT Application Services Data Warehouse
$11,190.00
$11,190.00
30002
IT Application Services Enhanced
$13.25
$13.25
30003
IT Application Services GIS
$97,106.75
$97,106.75
30004
IT Application Services eGovernment
$328,771.25
$328,771.25
25108
Courts - Oakland Schools
$0.00
$0.00
36901
BS&A Orion Twp - IT
$0.00
$0.00
96302
OCSO CCTV Main Jail
$2,103.75
0.00
App Services - Sub Total:
$733,457.25
$733,457.25
Internal Services
19020
Internal Services Planned Main
$40,351.25
$40,351.25
Internal Services - Sub -Total:
$40,351.25
$40,351.25
$0.00
Technical Sys/Networking
19030
Tech Sys/Net Planned Maint
$218,249.50
$218,249.50
23007
Oracle Support- IT Tech Systems
$164.09
$164.09
23017
Oracle Support - IT Tech Systems 1.2%
37.87
$37.87
24018
SQL Sery Support - IT Tech Systems 2%
34.81
$34.81
25400
Oracle Administration
907.50
$907.50
95685
I.T. - Disaster Recovery
0.00
$0.00
95750
I.T. - SEP
108,841.00
$108,841.00
95755
I.T. - PeopleSoft Upgrade
0.00
0.00
Tech Sys/Net - Sub -Total:
$328,234.77 ,
$328,234.77
Information Technology - Total: $1,102,043.27 1 $1,102,043.27
Prepared By: Information Technology; 01/13/2022 Page 23 of 23 1st Quarter 2022.pdf