HomeMy WebLinkAboutResolutions - 2021.02.18 - 34163MISCELLANEOUS RESOLUTION #21045 February 18, 2021
BY: Commissioner Gwen Markham, Chairperson, Finance Committee
IN RE: INFORMATION TECHNOLOGY — FIRST QUARTER 2021 DEVELOPMENT APPROPRIATION
TRANSFER
To the Oakland County Board of Commissioners
Chairperson, Ladies and Gentlemen:
WHEREAS all development costs are incorporated as a single appropriation within the non -departmental
budget, and then an amount equal to the actual expense is transferred to the user department with a
summary report to the Finance Committee; and
WHEREAS the Department of Information Technology has determined the First Quarter 2021
development charges to be $1,128,631,45 for the General Fund/General Purpose County departments;
and
WHEREAS direct charges to Special Revenue and Proprietary Fund departments are $971,510.70 and
non -County agencies are $6,004.25 for the First Quarter 2021: and
WHEREAS an appropriation transfer to General Fund/General Purpose County departments is needed to
fund these development charges.
NOW THEREFORE BE IT RESOLVED that the Oakland County Board of Commissioners has reviewed
the First Quarter 2021 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 2021 budgets are to be
amended as specified in the attached detailed schedule.
Chairperson, on behalf of the Finance Committee, I move the adoption of the foregoing resolution,
Ode- ( mla
Commissioner Gwen Markham, District 49
Chairperson, Finance Committee
FINANCE COMMITTEE VOTE:
Motion carried unanimously on a roll call vote.
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
FIRST QUARTER 2021
1st Quarter
CUST
FUND#
ACCOUNT
DIVISION
Oct - Dec
Y.T.D.
GOVERNMENTALFUNDS
General Fund 11011
540
101
10100-3020201-121020-773630
5211 - District Court
$2,709.22
$2,709.22
550
101
10100-3020301-121020-773630
52/2 - District Court
$2,709.22
$2,709.22
560
101
101003020401-121020-773630
5213 - District Court
$2,709.22
$2,709.22
530
101
10100-3020501-121020-773630
5214 - District Court
$2,708.84
$2,708.84
630
101
10100-1070801-114000-773630
Animal Control
$15,795.05
$15,795.05
005
101
10100-5010101-180010-773630
Bd of Commissioners
$10,439.00
$10,439.00
508
101
10100-5010101-165015-773630
BOC-Legal Resource Center
$0.00
$0.00
450
1D1
10100-1070901-113270-773630
Circuit Court Probation North
$174.00
$174.00
184
101
10100-2010210-132300-773630
Clerk's - County Clerk
$0.00
Woo
718
101
10100-2010210-125000-773630
Clerk EServices
$0.00
$0.00
725
101
10100-2010201-180000-773630
Clerk/Reg -Admin
Woo
$0.00
291
101
10100-2010401-172190-773630
Clerk Register Admin
$0.00
$0.00
722
101
10100-201 D210-125000-773630
Clerk/Reg -EDMS(Imaging)
$3,541.00
$3,541.00
440
101
10100-2010301-185D10-773630
Clerk/Reg - Elections
$4,794.25
$4,794.25
410
101
10100-2010501-125000-773630
Clerk/Reg - Jury Commission
$82.50
$82.50
724
101
10100-2010210-125000-773630
Clerk/Reg - Legal Records
$55,374.48
$55,374.48
726
101
10100-2010601-172190-773630
Clerk/Reg- Micrographics
$0.00
$0.00
723
101
10100-2010205-132305-773630
Clerk/Reg - Vital Statistics
$26,012.80
$26,012.80
522
101
10100-1070401-113D00-773630
Community Corrections Admin
$30,576.67
$30,576.67
620
101
10100-1010201-181 D10-773630
Compliance Office - Auditing
Woo
$D.00
430
101
10100-1010501-181020-773630
Corporation Counsel
$22,871.50
$22,871.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
$1,757.05
$1,757.05
482
101
10100-3010403-121240-773630
CTS-FD-Juvenile Support
$0.00
$0.00
015
101
10100-1010101-181000-773630
County Executive
$28,739.75
$28,739.75
495
101
10100-3010201-121110-773630
Courts -Business Division
$0.00
$0.00
498
101
10100-3010301-121130-773630
Courts-GJ-Judicial Support
$259,801.09
$259,801.09
502
101
10100-3010301-121180-773630
Courts-GJ-Jury Operations
$272.12
$272.12
493
101
10100-3010101-121100-773630
Courts - Judical/Administration
$21,713.41)
$21,713.40
188
101
10100-1090206-171000-773630
Economic Dev & Comm Affairs
Woo
$0.00
785
101
10100-1090101-1710DO-773630
Economic Development & Community Affairs
$1,113.75
$1,113.75
740
101
10100-1020501-173010-773630
Equalization Division
$85,827.74
$85,827.74
046
101
10100-2010301-133095-773630
Elections-Pandemlc/COVID19
$0.00
$0.00
660
101
10100-1020601-182020-773630
Fiscal Services -Gen Fund
$88,199.12
$88,199.12
900
101
10100-110101-115090-773630
Homeland Security
$12,091.50
$12,091.50
416
101
10100-1050403-183020-773630
HR Recruitment
$0.00
$0.00
680
101
10100-1050401-183010-773630
Human Resources
$46,238.77
$46,238.77
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 & Communications
$677.00
$677.00
872
101
10100-1070601-132030-773630
Medical Examiner
$7,939.80
$7,939.80
296
101
10100-1070501-174000-773630
MSU - Digital Media Services
$0.00
$0.00
Prepared
By: Information Technology; 01/21/21
Page 1 of 22
1st Quarter 2021.pdf
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
FIRST QUARTER 2021
1st Quarter
GUST
FUND#
ACCOUNT
DIVISION
Oct - Dec
Y.T.D,
710
1D1
10100-1060801-174000-773630
MSU Extension - Oakland
$0.00
$0.00
349
101
101004030501-112680-773630
OCSD Admin Sew -Records Unit
$167.50
$167.50
648
101
10100-4030201-112580-773630
OCSD Admin Serv-Sheriff Admin
$0.00
$0.00
163
101
101004030901-115140-773630
OCSO -CLEMIS Forensic Lab IMS
$0.00
$0.00
775
101
10100-1090201-171000-773630
Planning & Economic Development
$10,050.00
$10,050.00
479
101
10100-3040101-121090-773630
Probate FD Judicial Support
$0.00
$0.00
512
101
1010D-3040403-124010-773630
Probate-Estates/Mental Health - EDMS (Imaging)
$3,098.40
$3,098.40
510
101
10100-3040403-124010-773630
Probate-Estates/Mental Health Support
$8,485.05
$8,485.05
481
101
10100-3040101-121060-773630
Probate -Family Division Judicial
$0.00
$0.00
145
101
101004010101-122050-773630
Prosecuting Attorney - General Prosecution
$27,628.55
$27,628.55
690
101
10100-1020310-182090-773630
Purchasing
$350.50
$350.50
637
101
10100-1030803-184020-773630
Records Retention
$0.00
$0.00
650
101
10100-1020650-126020-773630
Reimbursement Division
$3,256.75
$3,256.75
195
101
101004030301-112590-773630
OCSD-Corrective Sery -Admin
$39,564.26
$39,564.26
191
101
10100-4030601-110000-773630
Sheriff - CLEMIS
$32,327.37
$32,327.37
348
101
101004030301-112620-773630
Sheriff- Corrective Sew Admin
$2,475.00
$2,475.00
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
1D1
101004030901-110040-773630
Sheriff - LE Support- Sew Admin
$0.00
$0.00
445
101
10100-103D803-184025-773630
Support Services
$1,654.46
$1,654.46
600
101
10100-7010101-186040-773630
Treasurer
$50,098.01
$50,098.01
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
$22A46.50
$22,446.50
910
101
1 010D-1 090702-132050-773630
Veterans Services
$785.50
$785.50
730
101
10100-6010101-155010-773630
Water Resource Commissioner
$39,784.05
$39,784.05
742
101
10100-6010101-149920-773630
WRC - CAMS Software Support & Maintenance
$805.00
$805.00
203
101
10100-6010101-174452-773630
WRC EU Pub ED Adm Programs
$D.00
$0.00
022
101
10100-6010101-174453-773630
WRC GIS Layer
$0.00
$0.00
301
1D1
10100-6010101-174250-773630
WRC- Soil Erosion Software Sol
SO_00
$0$000
Sub -Total Fund 101
$977,845.74
$977,845.74
Health Fund [2211.
840
221
20221-1060201-133150-773630
Health
$63,725.50
$63,725.50
852
221
20221-1060211-133150-773630
Health Central Support
$75.75
$75.75
843
221
20221-1060220-134390-773630
Health Environmental
$67,984.69
$67,984.69
183
221
20221-1060201-133150-773630
Health Website Redesign
$0.00
$0.00
239
221
20221-1060201-133095-773630
Pub Hlth-Pandemic/COVID19
$8,295.00
$8 295.00
Sub -Total Fund 221
$140,080.94
$140,080.94
Juvenile Maintenance Fund 12931
665
293
20293-1070901-112090-773630
Children's Village
$10,704.77
$10,704.77
668
293
20293-1070901-112010-773630
Children's Village Admin
$0.00
$0_00
Sub -Total Fund 293
$10,704.77
$10,704.77
Prepared By: Information Technology; 01/21/21
Page 2 of 22
1st Quarter 2021.pdf
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
FIRST QUARTER 2021
1st Quarter
CUST
FUND# ACCOUNT
DIVISION
Oct - Dec
Y.T.D.
63600-1080101-152000-631365
DEVELOPMENT FOR GOVERNMENTAL FUND
$1,128 631.45
$1,128,631.45
APPROPRIATION
SUB -TOTAL GOVERNMENTAL DEVELOPMENT
APPROPRIATION:
$1,128,631.45
$1,128,631.45
10100-9090101-196030-773630
Information Technology Development
($1 128 631 45)
(S1 128.631A5)
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
$181.50
$181.50
935
Augusta SAW Grant
$0.00
$0.00
073
Bicentennial Celebration Grant
$0.00
$0.00
944
CAMP CTA DR Equipment
$8,567.75
$8,567.75
669
CAMS/CVT Data Conversion
$0.00
$0.00
055
CLEMIS
$7,392 03
$7,392.03
699
CLEMIS - CAD
$0.00
$0.00
448
CLEMIS/FRMS NON -BILLABLE
$2,722.50
$2,722.50
056
CLEMIS FUND 63500
$16,260.50
$16,260.50
026
CLEMIS MIDC Bridge
$8,555.00
$8,555.00
069
CLEMIS-Training
$0.00
$0.00
749
Clerk/Reg -CPL
$0.00
$0.00
720
Clerk/Reg - Register Of Deeds
$5,296.80
$5,296.80
719
Clerk/Rod Automation Fund
$0.00
$0.00
659
Collaborative Asset Mgt Sys (CAMS)
$0.00
$0.00
435
Comm Dev - Housing Counselor
$0 00
$0 00
521
Community Corrections - Admin(Grant)
$0.00
$0.00
937
COSDS SAW Grant
$0.00
$0.00
471
Courts-FOC Exp-CS Enforcement - EDMS (Imaging)
$0.00
$0.00
507
Courts-FOC Fxp-CS Enforcement
$22,435.40
$22,435.40
470
Courts-FOC EXP-FAM Counseling
$0.00
$0.00
G45
CV Radio System Replacement
$2,722 50
$2,722.50
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,548.75
$1,548.75
837
EDCA- MlTradeSchool.org Grant
$0.00
$0.00
167
Edwards Drain SAW Grant
$0 00
$0.00
100
Farmington Hills SIDS SAW
$0.00
$0.00
210
Fire Records Management System
$5,535.80
$5,535.80
750
FM&O
$23,059.32
$23,059.32
756
FM&O Building Maintenance
$0.00
$0.00
Prepared By: Information Technology; 01/21/21
Page 3 of 22
1 st Quarter 2021.pdf
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
FIRST QUARTER 2021
1st 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
$3,533.50
$3,533.50
048
FM&O Bldg Security Enh Proj
$0.00
$0 00
757
FM-WK Rel/Jail Mgt/Video 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
$80.75
$80.75
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
020
Henry Graham Drain SAW Grant
$0.00
$0.00
947
HIPAA Enhancements II
$58,640.25
$58,640.25
120
HR-Financial System Replacement
$439,536 73
$439,536.73
214
]AM Program
$56,811.50
$56,811.50
338
Imaging Project
$16,599.50
$16,599.50
751
IT Telephone Communications
$185.50
$185.50
202
Jail Management System (,MS)
$23,325.00
$23,325.00
185
Leasetrack
$0.00
$0.00
112
Medical Marijuana PSA
$0.00
$0.00
101
Medical Marijuana Mysidewalk
$0 00
$0.00
113
MIDC Dev
$32,390.00
$32,390.00
192
Neptune Reports
$0.00
$0.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
$5,073.75
$5,073.75
934
OLV SDS SAW Grant
$0.00
$0.00
255
Oracle Upgrade to 19C
$15,855 25
$15,855.25
770
Parks and Recreation - Administration
$7,729.50
$7,729.50
867
P&R Capital Improvement
$0.00
$0.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 Ctr CIP#2468
$0.00
$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 W WTP Transaction
$0.00
$0.00
Prepared By: Information Technology; 01/21/21 Page 4 of 22
1 st Quarter 2021.pdf
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
FIRST QUARTER 2021
1st Quarter
CUST FUND# ACCOUNT
DIVISION
Oct - Dec
Y.T.D.
906
Public Health Grant 795
$0.00
$0 00
237
Public Safety Dashboard
$29,723.75
$29,723.75
791
Radio Communications - E911
$32,606.75
$32,606 75
695
Risk Management
$21,372.75
$21,372.75
638
Tax Management System
$0 00
$0.00
601
Treasurers - DTRF
$0.00
$0 00
973
UCC Program II
$31,407 25
$31,407.25
115
UCC Program III - VOIP
$50,764.75
$50,764 75
231
UCC Program IV - Wireless
$15,053.50
$15,053.50
656
Water Resources Accounting
$272.12
$272.12
731
Water Resource -Equipment
$0.00
$0.00
736
WinCan Central Storage Solution
$0.00
$0.00
930
Water and Sewer -General Adm
$701.25
$701.25
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
281
WRC
$0.00
$0.00
670
WRC Acctg - Crowder Poct
$0.00
$0.00
344
WRCAdministration
$0.00
$0.00
929
WRC Aeration Tank Rehab
$0.00
$0.00
940
WRC-CAMP
$2,175.75
$2,175.75
926
WRC CLINTON-OAKLAND SCADA
$0.00
$0.00
932
WRC CLINTON-OAK SDS SCADA Main
$0.00
$0.00
277
WRC-GWK PCF-WRC SCADA
$0.00
$0.00
377
WRC-SAWACACIA
$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
WRC AGO
$0 00
$0 00
734
WRC-AMR Support
$701.25
$701.25
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 BIDS SewMet
$0.00
$0 00
737
WRC - Data Application Pilot Polect
$0.00
$0.00
300
WRC - GIB 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
Prepared By: Information Technology, 01/21/21
Page 5 of 22
1 at Quarter 2021.pdf
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
FIRST QUARTER 2021
1st Quarter
CUST FUND# ACCOUNT
DIVISION
Oct - Dec
Y.T.D.
894
WRC - HACH WIMS Implementation Phase II
$0.00
$0 00
733
WRC - Hydro Drain Project
$0.00
$0.00
671
WRC - Infrastructure Op Ar
$0.00
$0.00
982
WRC Keego Harbor SAW
$0.00
$0.00
299
WRC - MISS DIG Ticket Mgmt Sys
$0.00
$0.00
236
WRC Oaklabnd Macomb Interceptor
$1,533.00
$1,533.00
981
WRC Oxford Twp SAW
$0.00
$0.00
501
WRC Permitting Imp[
$1,320.00
$1,320 00
979
WRC Permitting Implementation
$391.00
$391.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,722.50
$2,722.50
294
WRC-Sewer Fund
$7,190.25
$7,190.25
067
WRC Utility Billing Replacement
$6,897.50
$6,897 50
023
WRC Walled Lake Water
$0 00
$0.00
024
WRC Walled Lake BIDS
$0.00
$0.00
121
WRC Website Standardization
$2,638.25
$2,638.25
170
WRC WMU Meter Maintenance
$0.00
$0.00
63600-1080101-152000-631302
SUB -TOTAL DIRECT CHARGES FOR DEVELOPMENT
$971,510.70
$971.510.70
TOTAL COUNTY DEVELOPMENT CHARGES $2,100,142.15 $2,100,142.15
NON -COUNTY AGENCIES
63600-1080101-152000-635017 Non -County Agencies $6,004.25 60$ 04.25
Prepared By: Information Technology; 01/21/21 Page 6 of 22 1st Quarter 2021.pdf
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2021
cult# GOVERNMENTAL FUNDS
630
ANIMALCONTROL
24017
SQL Server Supp- Animal Control
95628
Animal Control
95682
Dog System
Animal Control -Total
005
BD OF COMMISSIONERS
91404
BOC - Customer Support
Ed of Commissioners - Total
508
BOC-LEGAL RESOURCE CENTER
61001
Library Services
91405
Library Board
BOC-Legal Resource Center -Total
665
CHILDRENS VILLAGE
95665
Childrens Village
Childrens Village - Total
668
CHILDREN'S VILLAGE ADMIN
97668
Childrens Village Admin
Children Village Admin - Total
725
CLERKIREG -ADMIN
72500
Clerk -Admin
Clerk/Reg - Admin - Total
440
CLERK/REG - ELECTIONS DIVISION
95443
Clerk/Reg - Elections Division
Clerk/Reg - Elections Division -Total
722
CLERKIREG - EDMS (IMAGING)
95158
Clerk/Reg - EDMS Support/Maintenance/Upgrades
13001
Clerk's-Efiling
Clerk/Reg - EDMS (Imaging) - Total
410
CLERKIREG-JURY COMMISSION
95512
Clerk/Reg - Jury Commission
Clerk/Reg - Jury Commission - Total
724
CLERK/REG - LEGAL RECORDS
95189
Circuit Court System
95170
Clerk/Reg - Legal Records
Clerk/Reg - Legal Records - Total
723
CLERK -VITAL STATISTICS
24015
SQL Server Supp - Vital Stats 3.5%
95161
Clerk.Reg -Vital Statistics
Clerk - Vital Statistics - Total
522
COMMUNITY CORRECTIONS-ADMIN (CO).
23003
Oracle Support -Comm Corr- 5.2%
Prepared
By: Information Technology; 01/21/21
Page 7 of 22
1st Qtr 2021
$30.30
$5,225 00
$10,539.75
$15,795.05
$10.439.00
$10,439.00
0.00
$0.00
$10,704.77
$10,704 77
$0.00
$0.00
$0.00
$0.00
4$ ,794.25
$4,794.25
$3,541.00
0.00
$3,541.00
$82.50
$82.50
$54,285.23
$1.089.25
$55,374.48
$30.30
$25.982.50
$26,012.80
$272.12
1 st Quarter 2021.pdf
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2021
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
44029
Pur-New Development
44028
Purchasing System Enhancements
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 DIV-JUDICIAL SUPPT
95187
CTS-Fam Div -Judicial Support
CTS-Fam Div -Judicial Support - Total
483
CTS-FDJUDICIAL SUPPORT -ADM
24009
SQL Sew Supp - CTS-Jud Sup Adm - 3.5%
95193
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 JURIS-JUDICIAL SUPPT
95179
CTS-Gen Juns-Judicial Suppt
23010
Oracle Support-CCT/CTS
CTS-Gen Juris-Judicial Suppt - Total
502
CTS-GJ-JURY OPERATIONS
23008
Oracle Support-CTS-GJ-Jury Operations
Prepared
By: Information Technology, 01/21/21
Page 8 of 22
$30.30
$30,274.25
$0.00
$30,576.67
$0.00
$0.00
$0.00
$0.00
$350.50
$350.50
$22,871.50
$22,871.50
$22,106 00
$6 633.75
$28,739.75
$174.00
$174.00
$0.00
S0.00
$0.00
$0 00
$0.00
$30.30
1 726 75
$1,757.05
$0.00
$0.00
$259,665.02
S136.07
$259,801.09
2$ 72.12
1st Quarter 2021.pdf
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2021
493 CTSJUDICIAL ADMIN
188 ECONOMIC DEV & COMM AFFAIRS
785 ECONOMIC DEVELOPMENT & COMMUNITY AFFAIRS
740 EQUALIZATION
660 FISCAL SERVICES-GEN FUND
Prepared By: Information Technology; 01/21/21
CTS-GJ-Jury Operations - Total
95174 CTS-Judicial Admin
13002 Courts - Efling
49300 Courts Web Redesign
CTS-Judicial Admin - Total
98180 EDCA - One Stop Shop
Economic Dev & Comm Affairs - Total
36500 GIS Implementation Support C&E Dev
36501 CED Application - H/W Support
95785 Comm & Eco Developmt
Economic Development & Community Affairs - Total
$272 12
$21,713.40
$0.00
$0 00
$21,713.40
$0.00
$0.00
$1,113.75
$0.00
$0 00
$1,113.75
23012
Oracle Support -Equalization - 5.2%
$272.12
24005
SOL Server Supp-Equalization - 10.5%
$90.88
31075
Equal - Development
$574.50
36505
GIS Implementation Support Equalization
$247.50
36506
Equal Application - H/W Support
$5,308.50
36507
Equal LAMS Support
$42,551.50
36601
Land System Enhancements - Equal (50%)
$7,389.85
36701
Land System Maintenance - Equal (50%)
$1,262.51
36801
Land System Support - Equal (50%)
$3,316.50
36902
BS&A Orion Twp
$0.00
50101
EQUAL (BS&A ANNUAL)
$220.63
95562
Equalization - DW Support
$0.00
95693
Equalization - System Maintenance
$0.00
95699
BS&A Master Appraisal Sup/Maint
$24.593.25
Equalization - Total
$85,827.74
23001
Oracle Support- Fiscal Sew - 15.6%
$816.35
23013
Oracle Support - HR-Acctg/Budget - 5.2%
$272.12
24006
SOL Sew Supp - HR-Acctg - 1.75%
$15.15
44021
FS-System/Customer Support
$13,804.25
44022
FS - System Maintenance
$495.00
44023
FS - System Enhancements
$10,441.25
44024
FS - New Development
$0.00
44602
Bond Disclosure - Fiscal (50%)
$0 00
96001
Fiscal Sew - Acctg 40%
$41,570.00
96003
Fiscal Sew - Budget 20%
$20,785.00
Fiscal Services -Gen Fund - Total
$88,199.12
Page 9 of 22
1st Quarter 2021.pdf
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2021
852
HEALTH CENTRAL SUPPORT
95852
Health Central Suppo
Health Central Support - Total
840
HEALTH DIVISION
36525
GIS Implementation Support Health
95563
User Support -Health
96842
Health Admin
Health - Total
843
HEALTH -ENVIRONMENTAL
23005
Oracle Support - EH Projects - 5.2%
24014
SQL Server Suppt - Ehealth 14%
84200
EH - Projects
84300
Ehealth Program
Health -Environmental -Total
183
HEALTH WEBSITE REDESIGN
96183
Health Website Redesign
Health Website Redesign - Total
900
HOMELAND SECURITY
36545
GIS Implementation Support Homeland Security
36546
Homeland Security Application - HM Support
98990
Homeland Security
Homeland Security -Total
680
HUMAN RESOURCES
23014
Oracle Support-HR/Personnel-52%
24007
SQL Server Suppport-HR/Personnel - 1.75%
44044
HR- New Development
96002
Human Res -Personnel 40%
Human Resources -Total
338
IMAGING PROGRAM
33800
Imaging Project
Imaging Project -Total
907
LIBRARY - LIBRARY ADMIN
91405
Library Board
Library - Library Admin -Total
824
LIBRARY SERVICES
61001
Library Services
Library Services - Total
565
MARKETING & COMMUNICATIONS
56500
Marketing & Communications
Marketing & Communications - Total
872
MEDICAL EXAMINER
24002
SQL Server Support- Medical Exam - 3.5%
Prepared
By: Information Technology; 01/21/21
Page 10 of 22
75.75
$75.75
$0.00
$17,964.50
$45,761.00
$63,725.50
$272.12
$121.17
$65,688.90
$1.902.50
$67,984.69
$0.00
$0.00
$0.00
$7,878.75
212.75
$12,091.50
$272.12
$15.15
$0.00
$45,951.50
$46,23&77
$0 00
$0.00
0.00
$0.00
$0.00
$0 00
$677 00
$677.00
$30.30
1st Quarter
2021.pdf
710 MSU EXTENSION - OAKLAND
349 OCSD ADMIN SERV-RECORDS MGMT
163 OCSO-CLEMIS FORENSIC LAB IMS
775 PLANNING & ECO DEVELOPMENT
512 PROB-ESTATES/MENTL HLTH EDMS (IMG)
510 PROB-ESTATES/MENTL HLTH SUPPORT
481 PROB-FD JUDICIAL
479 PROB-FD JUDICIAL SUPPORT
145 PROSECUTOR- GENERAL PROSECUTION
239 PUB HEALTH-PANDEMIC/COVIDI9
637 RECORDS RETENTION
650 REIMBURSEMENT
Prepared By: Information Technology; 01/21/21
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2021
87202
Medical Examiner- Customer Support
Medical Examiner -Total
95676
MSU Ext Equipment Maintenance
MSU Extension - Oakland - Total
97349
OCSD Admin Sew-Reco
OCSD Admin Serv-Records Mgmt -Total
16300
OCSO-CLEMIS Forensic Lab
OCSO-CLEMIS Forensic Lab IMS -Total
95600
PEDS CusUSystem Support
Planning & Eco Development - Total
95207
PC-E/MH EDMS Support & Mtce
Prob-Est/Mntl Hlth EDMS (Img) -Total
24010
SQL Sew Supp-PCT-Est/Mental - 3.5%
92198
Prob-Est/Mntl Hlth Support
Prob-Est/Mntl Hlth Support - Total
95168
PC -Judicial Family Admin-Family Judges
Prob - FD Judicial - Total
95188
Prob-FD Judicial Support
Prob-FD Judicial Support - Total
24016
SQL Server Supp - Proescutors 3.5%
95622
Prosecutor/Executive
97001
Prosecutor Data Proc
Prosecutor- Total
96239
Pub Health-Pandemic/COVIDI9
Pub Health-Pandemic/COVIDl 9 - Total
44053
REC - System Enhancements
Records Retention - Total
95470
Reimbursement System
95542
Reimburse User Support
Reimbursement - Total
Page 11 of 22
$7,909.50
$7,939.80
$0.00
$0.00
$167.50
$167.50
$0.00
$0.00
$10,050.00
$10,050.00
$3,098.40
$3,098.40
$30.30
$8.454.75
$8,485.05
0.00
$0.00
$0.00
$0.00
$30.30
$14,259.25
$13,339.00
$27,628.55
$8,295 00
$8,295.00
$0.00
$0.00
$3,228.75
$28.00
$3,256.75
1st Quarter
2021.pdf
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2021
648
OCSD ADMIN SERV-SHERIFF ADMIN
97648
OCSD Admin Sew -Sher
0.00
OCSD Admin Serv-Sheriff Admin - Total
$0.00
195
OCSD-CORRECTIVESERV-ADMIN
12001
OCSD-Courts/Criminal-50%
$0.00
23009
Oracle Suppport - OCSD/CTS Crim Whse-2.6%
$136.07
97163
Sheriff
$3,156.69
97164
Sheriff -Development
$0.00
97165
Sheriff-DW Support
$0.00
98164
CLEMIS-Sheriff
$36,271.50
Sheriff - Total
$39,56426
191
SHERIFF-CLEMIS
23015
Oracle Suppport- Sheriff /CLEMIS-5.2%
$272.12
96163
Sheriff -CLEMIS
$32,055.25
Sheriff - CLEMIS - Total
$32,327.37
348
SHERIFF -CORRECTIVE SERV ADMIN
34800
Inmate Phone System
$2,475.00
Sheriff - Corrective Sew Admin - Total
$2,475.00
988
OC SHERIFF'S - IFS DIV - LAB
16300
OC Sheriffs - IFS Div - Lab
SO_00
OC Sheriffs - IFS Div - Lab - Total
$0.00
647
OCSD PATROL SERV-LE ADMIN
97647
Sheriff- Patrol Serv-LE Admin
0.00
Sheriff - Patrol Sew -LE Admin - Total
$0.00
206
OCSD - LE SUPPORT SERV ADMIN
97206
OCSD - LE Support Sew Admin
SO00
OCSD- LE Support Sew Admin -Total
$0.00
445
SUPPORT SERVICES
23002
Oracle Support -Supp Sew -52%
$272.12
24011
SQL Server Supp - Suppt Services 7 %
$60.59
44500
Support Services
$1,321.75
Support Services - Total
$1,654.46
600
TREASURER
23006
Oracle Support - Del Tax - 5 2%
$272.12
23016
Oracle Support - Treasurer -10.4%
$544.23
36516
Treasurer Application - HAN Support
$0.00
36602
Land System Enhancements - Trees (50%)
$7,389.65
36702
Land System Maintenance -Treas (50%)
$1,262.49
36802
Land System Support -Treas (50%)
$3,316.50
44061
Tre-System/Customer Support
$27,730 15
44062
Tre-System Maintenance
$932.50
Prepared
By, Information Technology; 01 /21/21
Page 12 of 22
1 st Quarter 2021.pdf
169 TREASURERS -BANKING RFP
627 TREASURER- LANDSALE
978 TREASURERS OFFICE-OAKDOCS
910 VETERANS SERVICES
730 WATER RESOURCE COMMISSIONER
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2021
44063
44064
44080
44082
44601
50102
95008
95303
95561
95615
96169
44083
95978
95651
95650
24008
28007
28010
28011
36520
36521
742 WRC -CAMS SOFTWARE SUPPORT & MAINTENANCE 74200
301 WRC -SOIL EROSION SOFTWARE SOL
74301
Tre-System Enhancements
Tre-New Development
Tre-DW Support
Tre-DW Maintenance
Bond Disclosure - Trees (50 %)
TREAS)BSB.A)ANNUAL
Del Tax On Line
Del Tax System Maintenance
User SupporUDel Tax
BS&A Annual Tax Support
Treasurer - Total
Treasurers Banking
Treasurers Banking RFP
Treasurer-Landsale
Treasurer -Landsale - Total
Treasurers - OakDocs
Treasurers Office-OakDocs - Total
Veterans Customer Support
Veterans Services-Eq
Veterans Services - Total
SQL Server Supp - WRC 3.5 %
Water Resource Comm
WRC - Customer Support
Water Resource Commissioner Application
GIS Implementation Support WRC
WRC Application - HAN Support
Water Resource Commissioner - Total
WRC CAMS SOFTWARE Support
WRC CAMS SOFTWARE Support -Total
WRC - Soil Erosion Software Sol
WRC - Soil Erosion Software Sol -Total
540 5211 DISTRICT COURT-NOVI 95527 DC Suprt- 52/1 - 25%
Prepared By: Information Technology; 01/21/21 Page 13 of 22
$515.00
$0 00
$0.00
$0.00
$0.00
$220 62
$1,650.00
$100.00
$6,164.75
$0 00
$50,098.01
$0.00
$0 00
$0.00
$0.00
$22,446.50
$22,446.50
$785.50
$0.00
$785.50
$30 30
$20,613.75
$14,602.50
$1,320.00
$577.50
$2,640.00
$39,784.05
$805.00
$805.00
0 00
$0.00
$2.709 22
1 st Quarter
2021.pdf
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2021
550 5212 DISTRICT COURT - CLARKSTON
560 5213 DISTRICT COURT -ROCHESTER
530 5214 DISTRICT COURT -TROY
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
055 CLEMIS
699 CLEMIS -CAD
Prepared By: Information Technology; 01/21/21
52/1 District Court - Total
$2,709.22
95528
DC Suprt- 52/2 - 25%
$2,709.22
5212 District Court - Total
$2,709.22
95288
52 Dist Ct Div 3
$0.00
95529
DC Suprt - 52/3 - 25%
$2,709.22
52/3 District Court - Total
$2,709.22
95530
DC Suprt- 52/4 - 25%
$2 708.84
52/4 District Court - Total
$2,708.84
97274
ASAP Passport System
$0.00
ASAP Passport System - Total
$0.00
67200
Assessment & Tax
$181.50
Assessment & Tax - Total
$181.50
37935
Augusta SAW Grant
$0_00
Augusta SAW Grant -Total
$0.00
91073
Bicentennial Celebration Grant
0.00
Bicentennial Celebration Grant - Total
$0.00
37944
Camp CTA DR Equipment
$8,567.75
Camp CTA DR Equipment - Total
$8,567.75
23004
Oracle Support - OakVideo CLEMIS 5.2%
$272.12
23018
Oracle Support - Sheriff CLEMIS 5.2%
$272.04
24004
SQL Server Support - 24 5%
$212.05
95430
CLEMIS Maintenance
$0.00
95431
CLMS Enhancements
$0.00
98003
CLEMIS User Support
$6,512.07
98005
CLEMIS -E911 Support
$0.00
98000
Project Team
$123.75
CLEMIS - Total
$7,392.03
98006
CLEMIS - CAD Development
SO_00
CLEMIS - CAD - Total
$0.00
Page 14 of 22
1st Quarter
2021.pdf
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2021
056
CLEMIS FUND 63500
63500
CLEMIS Fund
$16.260.50
CLEMIS 63500 Fund - Total
$16,260.50
448
CLEMISIFRMS NON -BILLABLE_
44800
CLEMIS/FRMS NON -BILL
$2,722.50
CLEMIS/FRMS NON -BILL - Total
$2,722.50
026
CLEMIS MIDC BRIDGE
91026
CLEMIS MIDC Bridge
$8,555.00
CLEMIS MIDC Bridge -Total
$8,555.00
669
CAMSICVT DATA CONVERSION
66901
CAMS/CVT Data Conversion
$0.00
CAMS/CVT Data Conversion -Total
$0 00
749
CLERK/REG - CPL
74900
Clerk/Reg - CPL
$000
Clerk/Reg - CPL - Total
$0.00
720
CLERK / REGISTER OF DEEDS
24003
SQL Server Supp - ROD 3.5%
$30.30
36510
GIS Implementation Support
$0.00
36511
ROD Application - HNV Support
$2,407.25
95493
ROD System Maintenance
$0.00
95498
Clerk/Reg - ROD
$2 859 25
Clerk/Reg of Deeds -Total
$5,296.80
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
937
COSDS SAW GRANT
37937
COSDS SAW Grant
$0_00
COSDS SAW Grant - Total
$0.00
471
CTS-FOC-EXP-CS ENFORC-EDMS (IMGI
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
92193
CTS-FOC Exp-CD Enforc-Dev
$19,337.00
92194
CTS-FOC-CS ENF-EDMS
$3,098.40
CTS-FOC Exp-CD Enforc-Dev - Total
$22,435.40
521
COMM CORR -ADM (GRANTI
52102
Comm Corr-Adm (Grant)
$0.00
52100
Community Corrections C'Star EB
$0_00
Prepared
By: Information Technology; 01/21/21
Page 15 of 22
1st Quarter 2021 pdf
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
756 FM&O BUILDING MAINTENANCE
133 FM&O BUILDING MANAGEMENT
080 FMO BLDG MGMT SYSTEMS REP PH 2
963 FOC SECURITY AUDIT
Prepared By: information Technology, 01/21/21
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2021
Comm Corr - Adm (Grant) - Total
$0.00
95045
CV Radio Support Replacement
$2,722.50
CV Radio Support Replacement - Total
$2,722.50
67300
Cyber Security Fund
$000
Cyber Security Fund - Total
$0.00
37934
Drain Equipment Fund
$0_00
Drain Equipment Fund -Total
$0.00
37933
Dram Equip Map
1� 548.75
Drain Equip Map - Total
$1,548.75
83700
EDCA- MITRADESCHOOL
$0.00
EDCA - MITradeSchool.org Grant - Total
$0.00
33099
Farmington Hills SDS
$0 00
Farmington Hills SDS -Total
$0.00
21010
Fire Records Mgmt Fund 531
$0.00
95404
SQL Server Support- FRMS 3.5%
$5,505.50
24001
FIRMS - Phase II Proj
3$ 0.30
Fire Records Management System - Total
$5,535.80
21001
Facilities Maintenance & Operations
$320.52
24013
SQL Server Supp - FM&O
$30.30
75503
FM&O Development
$22 708.50
FM&O - Total
$23,059.32
75600
FM&O Building Maintenance
0.00
FM&O Building Maintenance - Total
$0.00
21133
FM&O Building Manage
$0_00
FM&O Building Manage - Total
$0.00
21080
FM&O Bldg Mgmt Sys Rep
$3,533.50
FMO BLDG MGMT SYSTEMS REP PH 2 - Total
$3,533.50
34963
FOC Security Audit
$0.00
FOC Security Audit - Total
$0.00
Page 16 of 22
1st Quarter 2021.pdf
942 FRANKLIN SAW GRANT
038 HACH WIMS SOFTWARE SUPPORT
380 HEALTH -IMMUNIZATION GRANT
173 HEALTH - LEAD INNOVATION GRANT
947 HIPAA ENHANCEMENTS II
120 HR-FINANCIAL SYSTEM REPLACEMENT
214 IAM PROGRAM
338 IMAGING PROJECT
751 IT - TELEPHONE COMMUNICATIONS
202 JAIL MANAGEMENT SYSTEM (JMS)
112 MEDICAL MARIJUANA PSA
113 MIDC DEV
136 OAKLAND TOWNSHIP SDS SAW
634 OAKVIDEO UPGRADE IBA)
Prepared By: Information Technology; 01/21/21
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2021
37942
Franklin SAW Grant
Franklin SAW Grant - Total
74038
HACH WIMS Software Support
HACH WIMS Software Support - Total
38000
Health -Immunization Grant
Health -Immunization Grant -Total
96173
Health - Lead Innovation
Health - Lead Innovation -Total
96947
HIPAA Enhancements II
HIPAA Enhancements II -Total
44120
HR-Financial Sys Rep
HR-Financial Sys Rep - Total
21400
]AM Program
[AM Program - Total
33800
Imaging Project
Imaging Project -Total
75102
Telephone Communications - Customer Support
IT - Telephone Communications - Total
63202
Jail Management System (JMS)
Jail Management System (JMS) - Total
96112
Medical Marijuana PSA
Medical Marijuana PSA - Total
91113
MIDC DEV
MIDC DEV -Total
33136
Oakland Township SDS
OAKLAND TOWNSHIP SDS SAW - Total
63400
CLEMIS- OakVideo Upgrade
63401
IT - OakVideo Upgrade
OakVideo Upgrade (BA) -Total
Page 17 of 22
$0.00
$0.00
80.75
$80.75
0.00
$0.00
$0.00
$0.00
$58,640.25
$58,640.25
$439,536.73
$439,536.73
$56,811.50
$56,811.50
$16,599 50
$16,599.50
$185.50
$185.50
$23 325 00
$23,325 00
0.00
$0.00
$32.390.00
$32,390.00
$0.00
$0.00
$0.00
0.00
$0 00
1st Quarter 2021.pdf
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2021
938
OAKWIN RADIO SYSTEM ENH
98938
OAKWIN Radio System Enh
0.00
OAKWIN Radio System Enh -Total
$0.00
653
O.C. INTNL AIRPORT
36540
GIS Implementation Support
$0 00
65301
Airport User Support
$5,073.75
65310
O.C. Airport - New D
SO_00
O.0 InmI Airport -Total
$5,073.75
934
OLV SDS SAW GRANT
37934
OLV SDS SAW Grant
$0 00
OLV SDS SAW Grant- Total
$0.00
255
ORACLE UPGRADE TO 19C
63255
Oracle Upgrade to 19C
$15,855.25
Oracle Upgrade to 19C - Total
$15,855.25
770
PARKS AND RECREATION
36530
GIS Implementation Support - Parks
$3,687.00
44066
PRADM-System/Customer Support
$330.00
44068
PRADM-System Enhancements
$0.00
76100
P&R Administrative Services
$0.00
95413
PRADM-Customer Support
$3,712.50
95416
PRRA -Rec Admin
$0.00
95419
PRADM-Administration
WOO
Parks & Recreation - Total
$7,729.50
867
P&R CAPITAL IMPROVEMENT
86700
P&R Capital Improvement
$0.00
P&R Capital Improvement - Total
$0.00
925
P&R EMS UPGRADE
37925
P&R EMS Upgrade
$0_00
P&R EMS Upgrade - Total
$0.00
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
SO_00
P&R Lyon Oaks Conf CTR CIP#2468 - Total
$0.00
454
P&R SPRINGFIELD OAKS CIP#2471
45400
P&R Springfield Oaks CIP#2471
$000
P&R Springfield Oaks CIP#2471 -Total
$0.00
456
P&R SPRINGFIELD OAKS CIP#2470
45600
P&R Springfield Oaks CIP#2470
0.00
P&R Springfield Oaks CIP#2470 - Total
$0.00
Prepared
By: Information Technology; 01/21/21
Page 18 of 22
1st Quarter
2021.pdf
457 P&R RED OAKS CLUBHOUSE CIP#2467
268 PONTIAC METER
747 PONTIAC WATER
748 PONTIAC SEWER
936 PONTIAC WATER ASSET MGMT
329 PONTIAC WWTP TRANSACTION
237 PUBLIC SAFETY DASHBOARD
791 RADIO COMMUNICATIONS - E911
695 RISK MANAGEMENT
638 TAX MANAGEMENT SYSTEM
973 UCC PROGRAM II
115 UCC PROGRAM III - VOW
231 UCC PROGRAM IV -WIRELESS
731 WATER RESOURCE- EQUIPMENT
Prepared By: Information Technology; 01/21/21
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2021
45700
P&R Red Oaks Clubhouse CIP#2467
P&R Red Oaks Clubhouse Cl P#2467 -Total
74268
Pontiac BSA to WRC - Water
Pontiac Meter - Total
74701
Pontiac BSA to WRC - Water
Pontiac Water - Total
74702
Pontiac BSA to WRC - Sewer
Pontiac Sewer - Total
37936
Pontiac Water Asset Mgmt
Pontiac Water Asset Mgmt - Total
67329
Pontiac WWiP Transaction
Pontiac WWTP Transaction - Total
65237
Public Safety Dashboard
Public Safety Dashboard - Total
79101
Radio Communications - E911
Radio Communications - E911 -Total
44036
Rsk-System Customer Support
Risk Management - Total
63800
Tax Management System
Tax Management System -Total
92973
UCC Program II
UCC Program II - Total
92115
UCC Program III - VOIP
UCC Program III - VOIP - Total
23100
UCC Program IV - Wireless
UCC Program IV - Wireless - Total
74501
Water Resources - OP
Water Resource - Equipment - Total
Page 19 of 22
$0.00
$0.00
$0.00
$0.00
S0.00
$0.00
0.00
$0.00
$0.00
$0.00
0.00
$0.00
$29,723.75
$29,723.75
$32,606.75
$32,606 75
$21,372.75
$21,372.75
0.00
$0 00
$31,407.25
$31,407.25
$50.764.75
$50,764.75
$15,053.50
$15,053 50
$0.00
$0.00
1 st Quarter
2021.pdf
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2021
656 WATER RESOURCES ACCOUNTING
23011
Oracle Supp - Water & Sewer Acct'g - 5.2%
95669
Water Resources Accounting
95671
Drain Water/Sewer BI
Water Resources Accounting - Total
736 WINCAN CENTRAL STORAGE SOLUTION
73601
WinCan Central Storage Solution
WinCan Central Storage Solution - Total
930 WATER AND SEWER -GENERAL ADMIN
37930
Water and Sewer -General Admin
Water and Sewer -General Admin -Total
939 WATER AND SEWER GENERAL ADMINISTRATION 37939
Water and Sewer General Administration
Water and Sewer General Administration - Total
974 WATER AND SEWER GEN ADMIN-WMU
37974
Water and Sewer Gen Admin-WMU
Water and Sewer Gen Admin-WMU -Total
201 WATER AND SEWER GEN ADM - XC2
35201
Water and Sewer Gen Ad
Water and Sewer Gen Adm - XC2 - Total
670 WRC ACCTG - CROWDER PRJCT
60001
WRC - Crowder NetBase Project
929 WRC AERATION TANK REHAB
940 WRC-CAMP
926 WRC CLINTON-OAKLAND SCADA
932 WRC CLINTON-OAK SDS SCADA MAIN
281 WRC
894 WRC - HACH WIMS IMPLEMENTATION
Prepared By: Information Technology; 01/21/21
67000
WRC - Crowder NetBase Protect
WRC Acctg - Crowder Prject - Total
35700
WRC Aeration Tank Rehab
WRC Aeration Tank Rehab - Total
37940
WRC - Camp
WRC - Camp - Total
33926
WRC Clinton -Oakland SCADA
WRC Clinton -Oakland SCADA - Total
37932
WRC Clinton -Oak SDS SCADA Main
WRC Clinton -Oak SDS SCADA Main -Total
74281
WRC
WRC - Total
37894
WRC-HACH WIMS Implementation
WRC-HACH WIMS Implementation - Total
Page 20 of 22
$272.12
$0.00
0.00
$272.12
$0.00
$0.00
$701.25
$701.25
$0 00
$0.00
$0.00
$0.00
0.00
$0 00
$0.00
0.00
$0.00
S0.00
$0.00
2 175.75
$2,175.75
$0.00
$0.00
0.00
$0.00
$0.00
$0.00
0.00
$0.00
1st Quarter
2021.pdf
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2021
982
WRC KEEGO HARBOR SAW
33982
WRC Keego Harbor SAW
WRC Keego Harbor SAW - Total
236
WRC OAKLAND MACOMB INTERCEPTOR
33236
WRC Oakland Macomb Interceptor
WRC Oakland Macomb Interceptor -Total
501
WRC PERMITTING IMPL
74502
WRC Permittting Impl
WRC Permittting Impl - Total
979
WRC PERMITTING IMPLEMENTATION
74979
WRC Permittfing Implementation
WRC Permittting Implementation -Total
377
WRC - SAW ACACIA
28674
WRC - SAW Acacia
33377
WRC - SAW Acacia
WRC - SAW Acacia - Total
382
WRC SAW BIRMINGHAM
33382
WRC SAW Birmingham
WRC SAW Birmingham -Total
403
WRC SAW BLOOMFIELD VILLAGE
33403
WRC SAW Bloomfield Village
WRC SAW Bloomfield Village - Total
379
WRC - SAW COMMERCE TOWNSHIP
33379
WRC - SAW Commerce Township
WRC - SAW Commerce Township - Total
387
WRC SAW EVERGREEN FARMINGTON
33387
WRC SAW Evergreen Farmington
WRC SAW Evergreen Farmington - Total
402
WRC SAW HURON ROUGE
33402
WRC SAW Huron Rouge
WRC SAW Huron Rouge - Total
389
WRC SAW LAKE ORION
33389
WRC SAW Lake Orion
WRC SAW Lake Orion - Total
388
WRC SAW NOVI
33388
WRC SAW Novi
WRC SAW Novi - Total
386
WRC - SAW ORCHARD LAKE
33386
WRC - SAW Orchard Lake
WRC - SAW Orchard Lake -Total
674
WRC - SAW GRANT LABOR
28674
WRC - SAW Grant Labor
Prepared
By: Information Technology, 01/21/21
Page 21 of 22
$0.00
$0.00
$1,533.00
$1,533 00
$1,320.00
$1,320.00
$391.00
$391.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
1st Quarter
2021.pdf
INFORMATION TECHNOLOGY
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2021
_1stQuarter I
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
$444,563.00
$444,563.00
18000
IMACS Data Warehouse (Funded)
$0.00
$0.00
19000
IT Application Services Planned Maint
$299,207.00
$299,207.00
30001
IT Application Services Data Warehouse
$8,418.25
$8,418.25
30002
IT Application Services Enhanced
$901.25
$901.25
30003
IT Application Services GIS
$117,041.75
$117,041.75
30004
IT Application Services eGovernment
$402,147.75
$402,147.75
25108
Courts - Oakland Schools
$0.00
$0.00
36901
BS&A Orion Twp - IT
$0.00
$0.00
App Services - Sub Total:
$1,272,279.00
$1,272,279.00
Internal Services
19020
Internal Services Planned Main
$20,961.75
$20,961.75
Internal Services - Sub -Total:
$20,961.75
$20,961.75
$0.00
Technical Sys/Networking
19030
Tech Sys/Net Planned Maint
$80,125.25
$80,125.25
23007
Oracle Support - IT Tech Systems
$272.12
$272.12
23017
Oracle Support - IT Tech Systems 11%
62.80
$62.80
24018
SQL Sery Support - IT Tech Systems 2%
17.21
$17.21
25400
Oracle Administration
5,362.50
$5,362.50
95685
I.T. - Disaster Recovery
69.25
$69.25
95750
I.T. - SEP
104,479.00
$104,479.00
95755
I.T. - PeopleSoft Upgrade
0.00
0.00
Tech Sys/Net - Sub -Total:
$190,388.13
$190,388.13
Information Technology - Total:
$1,483,628.88
$1,483,628.88
Prepared By: Information Technology; 01/21/21 Page 22 of 22 1st Quarter 2021.pdf
Resolution #21045
February 18, 2021
Moved by Nelson seconded by Weipert the resolutions on the Consent Agenda be
adopted.
AYES: Charles, Gershenson, Hoffman, Jackson, Joliat, Kochenderfer, Kowall,
Kuhn, Long, Luebs, Markham, McGillivray, Miller, Moss, Nelson, Powell, Spisz,
Weipert, Woodward, Cavell. (20)
NAYS: None. (0)
A sufficient majority having voted in favor, the resolutions on the Consent Agenda were
adopted.
Moved by Nelson seconded by Weipert MR #21047 be amended as follows:
Add all Commissioners as co-sponsors of the resolution:
A sufficient majority having voted in favor the amendment carried.
V.""
I HEREBY APPROVE THIS RESOLUTION
CHIEF DEPUTY COUNTY FXECUTIVL
ACTING PURSUANT TO MCL 45.555A (7)
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, Lisa Brown, Clerk of the County of Oakland, do hereby certify that the foregoing
resolution is a true and accurate copy of a resolution adopted by the Oakland County
Board of Commissioners on February 18, 2021, with the original record thereof now
remaining in my office.
In Testimony Whereof, I have hereunto set my hand and affixed the seal of the Circuit
Court at Pontiac, Michigan this 18th day of February 2021.
Lisa Brown, Oakland County
Resolution #21045
February 18, 2021
Moved by Nelson seconded by Weipert the resolutions on the Consent Agenda be
adopted.
AYES: Charles, Gershenson, Hoffman, Jackson, Joliat, Kochenderfer, Kowall,
Kuhn, Long, Luebs, Markham, McGillivray, Miller, Moss, Nelson, Powell, Spisz,
Weipert, Woodward, Cavell. (20)
NAYS: None. (0)
A sufficient majority having voted in favor, the resolutions on the Consent Agenda were
adopted.
Moved by Nelson seconded by Weipert MR #21047 be amended as follows:
Add all Commissioners as co-sponsors of the resolution.
A sufficient majority having voted in favor the amendment carried.
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 February 18, 2021, with the original record thereof now
remaining in my office.
in Testimony Whereof, I have hereunto set my hand and affixed the seal of the Circuit
Court at Pontiac, Michigan this 18'h day of February 2021.
Lisa Brown, Oakland County