Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Resolutions - 2017.02.15 - 22778
MISCELLANEOUS RESOLUTION #17033 February 15, 2017 BY: Commissioner Thomas Middleton, Chairperson, Finance Committee IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY — FIRST QUARTER 2017 DEVELOPMENT APPROPRIATION TRANSFER To the Oakland County Board of Commissioners Chairperson, Ladies and Gentlemen: 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 2017 development charges to be $944,889,75 for the General Fund/General Purpose County departments; and WHEREAS direct charges to Special Revenue and Proprietary fund departments are $585,608.40 and non-county agencies are $11,070.50 for the First Quarter 2017; 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 2017 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 2017 budgets are to be amended as specified in the attached detail schedule. Chairperson, on behalf of the Finance Committee, I move the adoption of the foregoing resolution. Commissioner Thomas Middleton, District #4 Chairperson, Finance Committee FINANCE COMMITTEE VOTE: Motion carried unanimously on a roll call vote with Bowman absent. INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 1st QUARTER 2017 1st Qtr 2017 GUST FUND# ACCOUNT DIVISION Oct - Dec Y.T.D. GOVERNMENTAL FUNDS General Fund [1011 540 101 10100-3020201-121020-773630 550 101 10100-3020301-121020-773630 560 101 10100-3020401-121020-773630 530 101 10100-3020501-121020-773630 630 101 10100-1070801-114000-773630 005 101 10100-5010101-180010-773630 450 101 10100-1070901-113270-773630 725 101 10100-2010201-180000-773630 722 101 10100-2010210-125000-773630 440 101 10100-2010301-185010-773630 410 101 10100-2010501-125000-773630 724 101 10100-2010210-125000-773630 723 101 10100-2010205-132305-773630 522 101 10100-1070401-113000-773630 620 101 10100-1010201-181010-773630 690 101 101 00-101 0210-182090-773630 430 101 10100-1010501-181020-773630 506 101 10100-3010401-121220-773630 483 101 10100-3010403-121100-773630 482 101 10100-3010403-121240-773630 015 101 10100-1010101-181000-773630 495 101 10100-3010201-121110-773630 498 101 10100-3010301-121130-773630 502 101 10100-3010301-121180-773630 493 101 10100-3010101-121100-773630 785 101 10100-1090101-171000-773630 740 101 10100-1020501-173010-773630 742 101 10100-6010101-149920-773630 660 101 10100-1020601-182020-773630 900 101 10100-1060601-115090-773630 680 101 101 00-1050401-18301 0-773630 907 101 10100-5010303-165040-773630 52/1 - District Court 52/2 - District Court 52/3 - District Court 52/4 - District Court Animal Control Bd of Commissioners Circuit Court Probation North Clerk/Reg - Admin Clerk.Reg - EDMS (Imaging) Clerk/Reg - Elections Clerk/Reg - Jury Commission Clerk/Reg - Legal Records Clerk/Reg - Vital Statistics Community Corrections Admin Compliance Office - Auditing Compliance Office - Purchasing Corporation Counsel CTS-Fam Div-Judicial Support CTS-FD-Judicial Support-ADM CTS-FD-Juvenile Support County Executive Courts-Business Division Courts-GJ-Judicial Support Courts-GJ-Jury Operations Courts - Judical / Administration Economic Development & Community Affairs Equalization Division WRC - CAMS Software Support & Maintenance Fiscal Services - Admin Homeland Security Human Resources Library - Library Admin $6,552.15 $6,552.15 $6,552.15 $6,551.55 $48,206.19 $678.50 $110.00 $0.00 $2,517.60 $4,145.50 $0.00 $22,229,00 $27,453.94 $18,786.01 $10,652.00 $8,444.25 $3,431.50 $0.00 $1,776.69 $0.00 $69.00 $955.74 $80,218.50 $1,911.32 $2,202.90 $12,797.00 $96,172.17 $160.00 $139,449.68 $10,176.25 $52,341.71 $3,466.25 $6,552.15 $6,552.15 $6,552.15 $6,551.55 $48,206.19 $678.50 $110.00 $0.00 $2,517.60 $4,145.50 $0.00 $22,229.00 $27,453.94 $18,786.01 $10,652.00 $8,444.25 $3,431.50 $0.00 $1,776.69 $0.00 $69.00 $955.74 $80,218.50 $1,911.32 $2,202.90 $12,797.00 $96,172,17 $160.00 $139,449.68 $10,176,25 $52,341.71 $3,466.25 Prepared by; Information Technology; 01/24117 Page 1 of 16 1st Quarter 2017.pdf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 1st QUARTER 2017 1st Qtr 2017 CUST FUND# ACCOUNT DIVISION Oct - Dec Y.T.D. 824 101 10100-5010302-165020-773630 565 101 10100-1090108-171030-773630 872 101 10100-1070601-132030-773630 710 101 10100-1070501-174000-773630 163 101 10100-4030901-115140-773630 775 101 10100-1090201-171000-773630 512 101 10100-3040403-124010-773630 510 101 10100-3040403-124010-773630 481 101 10100-3040101-121060-773630 145 101 10100-4010101-122050-773630 637 101 10100-1030803-184020-773630 650 101 10100-1020650-126020-773630 195 101 101 00-4030301-1 12590-773630 191 101 10100-4030601-110000-773630 348 101 10100-4030301-112620-773630 647 101 10100-4030601-110000-773630 445 101 101 00-1 030803-1 84025-773630 600 101 101 00-70 101 01-186040-773630 627 101 101 00-70101 10-186130-773630 910 101 10100-1070301-132050-773630 730 101 10100-6010101-155010-773630 301 101 10100-6010101-174250-773630 Health Fund [221] 840 221 20221-1060201-1 331 50-773630 843 221 20221-1060220-134390-773630 Juvenile Maintenance Fund [293] 665 293 20293-1060501-112090-773630 668 293 20293-1060501-112010-773630 Library Services Marketing & Communcations Medical Examiner MStJ Extension - Oakland OCSO CLEMIS Forensic Lab 1MS Planning & Economic Development Probate-Estates/Mental Health - EDMS (Imaging) Probate-Estates/Mental Health Support Probate-Family Division Judicial Prosecuting Attorney - General Prosecution Records Retention Reimbursement Division Sheriff Sheriff - CLEMIS Sheriff - Corrective Serv Admin Sheriff - Patrol Serv - LE Admin Support Services Treasurer Treasurers - Landsale Veterans Services Water Resource Commissioner WRC - Soil Erosion Software Sol Sub-Total Fund 101 Health Health Environmental Sub-Total Fund 221 Children's Village Children's Village Admin Sub-Total Fund 293 $771.00 $12,025.00 $6,759.69 $425.50 $69.00 $276.00 $2,202.90 $7,826.69 $246.00 $26,685.94 $0.00 $3,449.75 $43,838.99 $3,291.32 $0.00 $0.00 $6,533.65 $71,798.90 $0.00 $798.75 $46,688.19 $1,121.25 $809,368.22 $34,117.50 $71,103.78 $105,221.28 $30,300.25 $0.00 $30,300.25 $771.00 $12,025.00 $6,759.69 $425.50 $69.00 $276.00 $2,202.90 $7,826.69 $246,00 $26,685.94 $0.00 $3,449.75 $43,838,99 $3,291.32 $0.00 $0,00 $6,533.65 $71,798.90 $0.00 $798.75 $46,688.19 $1,121.25 $809,368.22 $34,117.50 $71,103.78 $105,221.28 $30,300.25 $0.00 $30,300.25 Prepared by; Information Technology; 01/24/17 Page 2 of 16 1st Quarter 2017.pdf $0.00 $20,694.75 $0.00 $37,892.11 $0.00 $122,037.75 $19,560.50 $0.00 $3,245.19 $0.00 $0.00 $2,202.90 $11,611.00 $116,455.00 $0.00 $4,694.69 $24,820.44 $0.00 $0.00 $38,441.50 $0.00 $0.00 $414.00 $0.00 $20,694,75 $0.00 $37,892.11 $0.00 $122,037.75 $19,560.50 $0.00 $3,245.19 $0.00 $0.00 $2,202.90 $11,611.00 $116,455.00 $0.00 $4,694.69 $24,820.44 $0.00 $0.00 $38,441.50 $0.00 $0.00 $414.00 1st Quarter 2017.pdf INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 1st QUARTER 2017 1st Qtr 2017 CUST FUND# ACCOUNT DIVISION! Oct - Dec Y.T.D. 63600-1080101-152000-631365 10100-9090101-196030-773630 NON-GOVERNMENTAL DIRECT CHARGES 274 672 669 055 699 448 056 749 720 659 521 471 507 673 837 210 750 756 380 338 751 634 653 Prepared by; Information Technology; 01124117 DEVELOPMENT FOR GOVERNMENTAL FUND APPROPRIATION SUB-TOTAL GOVERNMENTAL DEVELOPMENT APPROPRIATION: Information Technology Development TOTAL GOVERNMENTAL: ASAP Passport System Assessment & Tax CAMS/CVT Data Conversion CLEMIS CLEMIS - CAD CLEMIS/FRMS NON-BILLABLE CLEMIS FUND 63500 Clerk/Reg - CPL Clerk/Reg - Register Of Deeds Collaborative Asset Mgt Sys (CAMS) Community Corrections - Admin (Grant) Courts-FOC Exp-CS Enforcement EDMS (Imaging) Courts-FOC Exp-CS Enforcement Cyber Security Fund EDCA - MITradeSchool.org Grant Fire Records Management System: FM&O FM&O Building Maintenance Health Immunization Grant Imaging Project IT Telephone Communications OakVideo Upgrade (Building Authority) O.C. International Airport Page 3 of 16 $944,889.75 $944,889.75 $944,889.75 $944,889.75 ($944,889.75) ($944,889.75) $0.00 $0.00 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY. 1st QUARTER 2017 . 63600-1080101-152000-631302 DIVISION Parks and Recreation - Administration P&R Capital Improvement Pontiac - Meter Pontiac - Water Pontiac - Sewer Pontiac VWVTP Transaction Radio Communications - E911 Risk Management Tax Management System Water Resources Accounting VVinCan Central Storage Solution WRC Acctg - Crowder Pict WRC - SAW ACACIA WRC - SAW Commerce Township VVRC - SAW Grant Labor WRC - AMR Support WRC - COSDA Meter Replacement WRC - CO SDS SewMet WRC - EF SDS SewMet VVFRC - Data Application Pilot Poject WRC - GIS Allocation by Labor VVRC - GWK PCF-WRC SCADA VVIRC - HACH WIMS Implementation WRC - Hydro Drain Project VVRC - Infrastructure Op Ar WRC - MISS DIG Ticket Mgmt Sys WRC - SAW Grant Labor - Common to All 1NRC SCADA Common WRC - SCADA Engineering Assessment 1st Qtr 2017 Oct - Dec $17,912.25 $0.00 $1,316.00 $0.00 $0.00 $0.00 $166.50 $275.00 $108,341.00 $12,115.82 $0.00 $0.00 $10,072.50 $6,781.00 $0.00 $338.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $26,220.25 $0,00 $0.00 Y.T.D. $17,912.25 $0,00 $1,316.00 $0.00 $0.00 $0.00 $166.50 $275.00 $108,341,00 $12,115.82 $0.00 $0.00 $10,072.50 $6,781.00 $0.00 $338.25 $0,00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $26,220.25 $0.00 $0.00 CUST FUND# ACCOUNT 770 867 268 747 748 329 791 695 638 656 736 670 377 379 674 734 745 728 729 737 300 277 295 733 671 299 686 739 738 SUB-TOTAL DIRECT CHARGES FOR DEVELOPMENT $685,608.40 $585,608.40 TOTAL COUNTY DEVELOPMENT CHARGES $1,530,498.15 $1,530,498.16 Prepared by; information Technology; 01/24/17 Page 4 of 16 1st Quarter 2017.pdf CUST FUND# ACCOUNT INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 1st QUARTER 2017 DIVISION 1st Qtr 2017 Oct - Dec Y.T.D. NON-COUNTY AGENCIES 63600-1080101-152000-635017 Non-County Agencies $11,070.50 $11,070.50 Prepared by; Information Technology; 01124/17 Page 5 of 16 1 st Quarter 2017.pdf $1,776.69 $17,648,00 $28,781.50 $678.50 $30,300.25 $0.00 $0.00 $4,145.50 $2,517.60 $0.00 $22,229.00 $1,776.69 $25,67725 $1,911.32 $1,776.69 $15,098.00 $0.00 $48,206.19 $678.50 $30,300.25 $0,00 $0.00 $4,145.50 $2,517.60 $0.00 $22,229.00 $27,453.94 $18,786.01 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - FIRST QUARTER 2017 Cust # GOVERNMENTAL FUNDS 24017 SQL Server Supp - Animal Control 95628 Animal Control 95682 Dog System Animal Control-Total 91404 BOC - Customer Support Bd of Commissioners - Total 95565 Childrens Village Child rens Village - Total 97668 Child rens Village Admin Childrens Village Admin Total 72500 Clerk - Admin Clerk/Reg - Admin - Total 95443 Clerk/Reg - Elections Division Clerk/Reg - Elections Division - Total 95158 Clerk/Reg - EDMS SuppOrt/Maintenance/Upgrades Clerk/Reg - EDMS (Imaging) - Total 95512 Clerk/Reg - Jury Commission Clerk/Reg - Jury Commission - Total 95189 Circuit Court System Clerk/Reg - Legal Records - Total 24015 SQL Server Supp - Vital Etats 3.5% 95161 Clerk.Reg - Vital Statistic's Clerk - Vital Statistics - Tptal 23003 Oracle Support-Comm Corr - 5.2% 24012 SQL Server Supp - Community Corr 3.5% 52200 Comm Corr-Admin (County) 52201 Comm Corr - DW Support Community Corrections Total 630 ANIMAL CONTROL 005 BD OF COMMISSIONERS 665 CHILDRENS VILLAGE 668 CHILDREN'S VILLAGE ADMIN 725 CLERK/REG - ADMIN 440 CLERK/REG - ELECTIONS DIVISION 722 CLERK/REG - EDMS {IMAGING) 410 CLERK/REG - JURY COMMISSION 724 CLERK/REG - LEGAL RECORDS 723 CLERK - VITAL STATISTICS 522 COMMUNITY CORRECTIONS-ADNIIN {CO) 620 COMPLIANCE OFFICE - AUDITING 44034 Auditing - New Development $10,583.00 Prepared by; Information Technology; 01/24/17 Page 6 of 16 1st Quarter 2017.pdf $1,776.69 $0.00 $80,218.50 $1,911.32 $2202.90 $1,776.69 $0.00 $80,218.50 $1,911.32 $2,202.90 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - FIRST QUARTER 2017 690 COMPLIANCE OFFICE - PURCHASING 430 CORPORATION COUNSEL 015 COUNTY EXECUTIVE 450 CIRC CT PROBATION - NORTH 495 CTS-BUSINESS DIVISION 95468 Auditing Internal Srv - CUst Sup Compliance Office -Auditing - Total 44028 Purchasing System Enhancements Compliance Office - Purchasing - Total 95501 Corporation Counsel Corporation Counsel - Total 95656 County Executive Support County Executive - Total; 80204 Circuit Court Probation - North Circuit Court Probation - North - Total $69.00 $8,444.25 $3,431.50 $69,00 $110.00 $10,652.00 $8,444.25 $3,431.50 $69.00 $110.00 12002 CCT-Courts/Criminal 23010 Oracle Support-CCT/CTS Crim Whse 2.6% CTS-Business Division -Total $0.00 $955.74 $955.74 506 CTS-FAM DIV-JUDICIAL SUPPT 95187 CTS-Fam Div-Judicial Support CTS-Fam Div-Judicial Support - Total $0.00 $0.00 483 CTS-FD-JUDICIAL SUPPORT-ADM 24009 SQL Serv 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 JURIS-JUDICIAL SUPPT 95179 CTS-Gen Juris-Judicial Suppt CTS-Gen Juris-Judicial Suppt - Total 502 CTS-GJ-JURY OPERATIONS 23008 Oracle Support-CTS-GJ-Jury Operations CTS-GJ-Jury Operations - Total 493 CTS-JUDICIAL ADMIN 95174 CTS-Judicial Admin CTS-Judicial Admin -Total 785 ECONOMIC DEVELOPMENT & COMMUNITY AFFAIRS 36500 GIS Implementation Support C&E Dev 36501 CEO Application - li/W Support 95785 Comm & Eco Developmt Economic Development & Community Affairs - Total Prepared by; Information Technology; 01/24/17 Page 7 of 16 $1,809.25 $10,987.75 $0,00 $12,797.00 1st Quarter 2017.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2017 740 EQUALIZATION 23012 Oracle Support-Equalization - 5.2% 24005 SQL Server Supp-Equalization - 10.5% 31075 Equal Development 36505 GIS Implementation Support Equalization 36506 Equal Application - HNV1Support 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 ANNUAO 95562 Equalization - DW SuppOrt 95693 Equalization - System Maintenance 95699 BS&A Master Appraisal Bup/Maint Equalization - Total $1,911.32 $5,329.46 $31,641.75 $35.50 $32,335.25 $9,349.51 $2,944.25 $3,265.50 $0.00 $8,796.13 $0.00 $0.00 $563.50 $96,172.17 660 FISCAL SERVICES ADMIN 840 HEALTH DIVISION 843 HEALTH - ENVIRONMENTAL 900 HOMELAND SECURITY Prepared by; Information Technology; 01/24/17 23001 Oracle Support - Fiscal Serv - 15.6% 23013 Oracle Support - HR-Acetg/Budget - 5.2% 24006 SQL Serv Supp HR-ACctg - 1.75% 44021 FS-System/Customer Support 44022 FS - System Maintenance 44023 FS - System Enhancements 44024 FS - New Development 44602 Bond Disclosure - Fiscal (50%) 96001 Fiscal Serv Acctg 40%1 96003 Fiscal Serv - Budget 20% Fiscal Services Admin - [Total 36525 GIS Implementation Support Health 95563 User Support-Health 96842 Health Admin Health - Total 23005 Oracle Support - EH Projects - 5.2% 24014 SQL Server Suppt - Ehealth 14% 84200 EH Projects 84300 Ehealth Program Health-Environmental - total 36545 GIS Implementation Suriport Homeland Security 36546 Homeland Security Application - H/W Support 98990 Homeland Security Page 8 of 16 $5,734.07 $1,911.32 $888.39 $58,370.75 $1,536.50 $0.00 $0.00 $0.00 $47,339,10 $23,669.55 $139,449.68 $0.00 $14,300.50 $19,817.00 $34,117.50 $1,911.32 $7,105.56 $47,782.90 $14,304.00 $71,103.78 $1,199.25 $8,977.00 $0.00 1st Quarter 2017.pdf $1,911.32 $888.39 $0.00 $49.542.00 $38,441.50 $3,466.25 $771.00 $12,025.00 $1,776.69 $4,983.00 $425.50 $276.00 $2,202.90 $1,776.69 $6,050.00 $246.00 $10,176.25 $52,341,71 $38,441.50 $3,466.25 $771.00 $12,025.00 $6,759.69 $425.50 $69.00 $276.00 $2,202.90 $7,826.69 $246.00 let Quarter 2017.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - FIRST QUARTER 2017 680 HUMAN RESOURCES 338 IMAGING PROGRAM 907 LIBRARY - LIBRARY ADMIN 824 LIBRARY SERVICES 565 MARKETING & COMMUNICATIONS 872 MEDICAL EXAMINER 710 MSU EXTENSION - OAKLAND 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 Prepared by; Information Technology; 01/24/17 Homeland Security - Total 23014 Oracle Support-HR/PersOnnel - 5.2% 24007 SQL Server Suppport-HR/Personnel - 1.75% 44044 HR- New Development 96002 Human Res-Personnel 40% Human Resources - Total 33800 Imaging Project Imaging Project - Total 91405 Library Board Library - Library Admin -;Total 61001 Library Services Library Services - Total 1 56500 Marketing & Communications Marketing & Communications - Total 24002 SQL Server Support - MOical Exam - 3.5% 87202 Medical Examiner - Custbmer Support Medical Examiner - Total 95676 MSU Ext Equipment Maintenance MSU Extension - Oakland - Total 16300 OCSO-CLEMIS ForensiG Lab OCSO-CLEIVIIS Forensi6 Lab IMS - Total 95600 PEDS Cust/System Support Planning & Eco Developinent - Total 95207 PC-E/MH EDMS Support & Mtce Prob-Est/Mnd Hlth EDMS (Img) - Total 24010 SQL Serv Supp-PCT-Est/Mental - 3.5% 92198 Prob-Est/Mntl Hlth Support Prob-EstIMntl Htth Support - Total 95168 PC-Judicial Family Admin-Family Judges Prob - FD Judicial -Total Page 9 of 16 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2017 145 PROSECUTOR - GENERAL PROSECUTION 24016 SQL Server Supp - Proescutors 3.5% 95622 Prosecutor/Executive 97001 Prosecutor Data Proc Prosecutor - Total $1,776.69 $13,961.50 $10,947.75 $26,685.94 637 RECORDS RETENTION 44053 REC - System Enhancements 50.00 Records Retention - Total $0.00 95470 Reimbursement System 95542 Reimburse User Supper Reimbursement - Total 12001 OCSD-Courts/Criminal 750% 23009 Oracle Suppport - ocsprars Crim VVhse - 2.6% 97163 Sheriff 97164 Sheriff Development 97165 Sheriff-DW Support 98164 CLEMIS-Sheriff Sheriff -Total 23015 Oracle Suppport - Sheriff! CLEMIS - 52% 96163 Sheriff - CLEMIS Sheriff - CLEMIS - Total! 34800 Inmate Phone System Sheriff - Corrective Serv Admin - Total 97647 Sheriff- Patrol Serv-LE dmin Sheriff - Patrol Serv-LE dmin - Total 650 REIMBURSEMENT 195 SHERIFF 191 SHERIFF - CLEWS 348 SHERIFF - CORRECTIVE SERV ADMIN 647 OCSD PATROL SERV-LE ADMIN $2,35825 $1,091.50 $3,449.75 $0.00 $955.74 $887.00 $0.00 $0.00 $41,996.25 $43,838.99 $1,911.32 $1.380.00 $3,291.32 $0.00 $0.00 0.00 $0.00 445 SUPPORT SERVICES 600 TREASURER Prepared by; Information Technology; 01/24/17 23002 Oracle Support - Supp Serv - 5.2% 24011 SQL Server Supp Suppt. Services 7% 44500 Support Services Support Services - Total 23006 Oracle Support - Del Ta*- 5.2% 23016 Oracle Support - Treasui-er- 10.4% 36516 Treasurer Application - OW Support 36602 Land System Enhancernents - Treas (50%) 36702 Land System Maintenance Treas (50%) Page 10 of 16 $1,911.32 $3,552.83 $1,069.50 $6,533.65 $1,911.32 $3,822.57 $0.00 $9,349.49 $2,944.25 1st Quarter 2017.pdf $3,265.50 $24,303.15 $2,825.00 $1,518.00 $0.00 $0.00 $0.00 $0.00 $8,796.12 $1,230.00 $1,966.50 $9,867,00 $0.00 $0.00 $798.75 $1,776.69 $13,271.00 $12,644.00 $2,029.50 $16,967.00 160.00 $71,798.90 $0.00 $798.76 $46,688.19 $160.00 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - FIRST QUARTER 2017 36802 Land System Support - Treas (50%) 44061 Tre-System/Customer SOpport 44062 Tre-System Maintenance 44063 Tre-System Enhancements 44064 Tre-New Development I 44080 Tre-DVV Support 44082 Tre-DW Maintenance 44601 Bond Disclosure - TreasI(50%) 50102 TREAS )BS&A) ANNUAL 95008 Del Tax On Line 95303 Del Tax System Maintenance 95561 User Support/Del Tax 95615 BS&A Annual Tax SuppPrt Treasurer - Total 44083 Treasurer-Landsale Treasurer -Lan dsale - Total 95651 Veterans Customer Support Veterans Services - Total 24008 SQL Server Supp - VVRC 3.5% 28010 WRC - Customer Support 28011 Water Resource Commiesioner Application 36520 GIS Implementation SuPport WRC 36521 WRC Application - H/VV Support Water Resource Commissioner - Total 627 TREASURER - LANDSALE 910 VETERANS SERVICES 730 WATER RESOURCE COMMISSIONER 742 WRC - CAMS SOFTWARE SUPPORT & MAINTENANCE 74200 WRC CAMS SOFTWARE Support VVRC CAMS SOFTWARE Support - Total 301 WRC - SOIL EROSION SOFTWARE SOL 540 52/i DISTRICT COURT - NOVI 550 5212 DISTRICT COURT - CLARKSTON Prepared by; Information Technology; 01/24/17 74301 WRC - Soil Erosion Software Sol WRC - Soil Erosion Software Sol - Total 95527 DC Suprt- 52/1 - 25% 52/1 District Court - Total 95528 DC Suprt- 52/2 - 25% 5212 District Court - Total Page 11 of 16 1,121.25 $20,277.75 6552.15 $6,552.15 $6.552.15 $6,552.15 1st Quarter 2017.pdf $0.00 $6,552.15 $6,552.15 95288 52 Dist Ct Div 3 95529 DC Suprt - 52/3 - 25% 52/3 District Court - Total 560 5213 DISTRICT COURT - ROCHESTER 23004 23018 24004 95430 95431 98003 98005 98000 Oracle Support - OakVideo CLEMIS 5.2% Oracle Support - Sheriff ;LEMIS 5.2% SQL Server Support -24 5% CLEMIS Maintenance CLMS Enhancements CLEMIS User Support CLEMIS - E911 Support Poject Team CLEMIS - Total INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2017 530 52/4 DISTRICT COURT - TROY Cust # DIRECT FUNDS 274 ASAP PASSPORT SYSTEM 672 ASSESSMENT & TAX 055 CLEMIS 699 CLEMIS - CAD 056 CLEMIS FUND 63500 448 CLEMIS/FRMS NON-BILLABLE 669 CAMS/CVT DATA CONVERSION 749 CLERKIREG - CPL 720 CLERK! REGISTER OF DEEDS Prepared by; Information Technology; 01/24/17 95530 DC Sup it- 52/4 - 25% 52/4 District Court - Tote • 97274 ASAP Passport System ASAP Passport System Total 67200 Assessment & Tax Assessment & Tax - Total • 98006 CLEMIS - CAD DevelopMent CLEMIS - CAD - Total i 63500 CLEWS Fund CLEMIS 63500 Fund - Thtal • 44800 CLEMIS/FRMS NON-BILL CLEMIS/FRMS NON-BILL - Total 66901 CAMS/CVT Data Conv4sion CAMS/CVT Data Conversion - Total 74900 Clerk/Reg - CPL Clerk/Reg - CPL - Total 24003 SQL Server Supp - ROD 3.5% Page 12 of 16 $6,551.55 $6,551.55 $0.00 $20,694.75 $37,892.11 $0.00 $19,560.50 $122,037.75 $0.00 $0.00 $0.00 $20,694.75 $1,911.32 $1,911.27 $12,435.02 $19,782.00 $0.00 $345.00 $0.00 $1,507.50 $0.00 $19,560.50 $122,037.75 $0.00 $0.00 $1,776.69 1st Quarter 2017.pdf $0.00 $1,054.50 $0.00 $414.00 $0.00 $2,202.90 $11,611.00 $0.00 $116,455.00 $0.00 $483.00 $1,776.69 $2,435.00 $158.00 $1,776.69 $22,885.75 $0.00 $0.00 $0.00 $3,245.19 $0.00 $2,202.90 $11,611.00 $0,00 $116,455.00 $0.00 $4,694.69 $24,820.44 $0.00 $0.00 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2017 36510 GIS Implementation Support . 36511 ROD Application - HNV Support 95493 ROD System Maintenance 95498 Clerk/Reg - ROD Clerk/Reg of Deeds - Total • 65901 Col!abortive Asset Mgt Sys Col!abortive Asset Mgt Sys - Total 92194 CTS-FOC-CS ENF-EDIVIS Support/Maintenance/Upgrades CTS-FOC Exp-CS Enforc-EDMS (Img) - Total 92193 CTS-FOC Exp-CD Enforb-Dev CTS-FOC Exp-CD Enforb-Dev -Total 52100 Community Corrections C*Star EB Comm Corr Adm (Grant) - Total 67300 Cyber Security Fund Cyber Security Fund - Total • 83700 EDCA - MITRADESCHOOL EDCA MITradeSohool.Org Grant - Total • 21010 Fire Records Mgmt Fund 531 95404 SQL Server Support FRMS 3.5% 24001 FRMS - Phase II Proj Fire Records Management System - Total ,•• 1 21001 Facilities Maintenance &lOperations 24013 SQL Server Supp - FM&O 75503 FM&O Development FM&O - Total 75600 FM&O Building Maintenance FM&O Building Maintenance - Total 38000 Health-Immunization Grant Health-Immunization Grant - Total 75102 Telephone Communications - Customer Support 659 COLLABORATIVE ASSET MGT SYS 471 CTS-FOC-EXP-CS ENFORC-EDMS (IPAG) 507 CTS-FOC EXP-CS ENFORCEMENT 521 COMM CORR - ADM (GRANT) 673 CYBER SECURITY FUND 837 EDCA MITRADESCHOOLORG GRANT 210 FIRE RECORDS MANAGEMENT SYSTEM 750 FM&O 756 FM&O BUILDING MAINTENANCE 380 HEALTH-IMMUNIZATION GRANT 751 IT - TELEPHONE COMMUNICATIONS Prepared by; Information Technology; 01124/17 Page 13 of 16 1st Quarter 2017.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - FIRST QUARTER 2017 IT - Telephone Communications - Total $0.00 634 OAKVIDEO UPGRADE (BA) 653 0.C. INTNL AIRPORT 770 PARKS AND RECREATION 867 P&R CAPITAL IMPROVEMENT 268 PONTIAC METER 747 PONTIAC WATER 748 PONTIAC SEWER 791 RADIO COMMUNICATIONS - E911 695 RISK MANAGEMENT 638 TAX MANAGEMENT SYSTEM 656 WATER RESOURCES ACCOUNTING Prepared by; Information Technology; 01/24117 63400 CLEM'S OakVideo Upgrade 63401 IT - OakVideo Upgrade OakVideo Upgrade (BA):- Total 36540 GIS Implementation Support 65301 Airport User Support O.C. Mtn! Airport - Total 36530 GIS Implementation Support - Parks 44066 PRADM-System/Customer Support • 44068 PRADM-System Enhancements 76100 P&R Administrative Services 95413 PRADM-Customer SuppOrt • 95416 PRRA - Rec Admin 95419 PRADM-Administration Parks & Recreation Total 86700 R&R Capital Improvement ID&R Capital Improvement - Total 74268 Pontiac BSA to VVRC - Water Pontiac Meter - Total 74701 Pontiac BSA to VVRC - Water Pontiac Water - Total 74702 Pontiac BSA to VVRC Sewer Pontiac Sewer - 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 23011 Oracle Supp - Water & Sewer Acct'g - 5.2% 95669 Water Resources Accounting Page 14 of 16 $0.00 $0,00 $0.00 $0.00 $414.00 $414.00 $408.25 $8,603.50 $355.50 $0.00 $7,786.00 $769.00 $0.00 $17,912.25 $0.00 $0.00 $1,316.00 $1,316.00 $0.00 $0,00 $0.00 $0.00 $166,50 $166.50 $275.00 $108,341.00 $108,341.00 $1,911.32 $10,204.50 1st Quarter 2017.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2017 95671 Drain Water/Sewer 131 $0.00 Water Resources Accounting - Total $12,115.82 736 WINCAN CENTRAL STORAGE SOLUTION 670 WRC ACCTG - CROWDER PRJCT 377 WRC - SAW ACACIA 377 WRC - SAW Commerce Township 674 WRC - SAW GRANT LABOR 73601 WinCan Central Storage Solution WinCan Central Storage Solution - Total 60001 WRC - Crowder NetBase Project 67000 WRC - Crowder NetBase Project WRC Acctg - Crowder Prject - Total 28674 WRC - SAW ACACIA WRC - SAW ACACIA - Total 28674 WRC - SAW Commerce Township WRC - SAW Commerce Township Total 28674 WRC - SAW Grant Labor $0.00 $0.00 $0.00 $0.00 $10,072.50 $6,781.00 31a07250 $6,781.00 $0.00 Prepared by; Information Technology; 01/24/17 Page 15 of 16 1st Quarter 2017.pdf 18020 IT Radio FUND ACCOUNT 17040 IT - TOS Fund 18000 !MACS Data Warehouse (Funded) 19000 IT Application Services Planned Maint 30001 IT Application Services Data Warehouse 30002 IT Application Services Enhanced 30003 IT Application Services GIS 30004 IT Application Services eGovernment. 25108 Courts Oakland Schools 36901 BS&A Orion Twp - IT App Services - Sub Total: 19020 Internal Services Planned Main Internal Services - Sub-Total: 19030 TechlSys/Net Planned Maint 23007 Oracle Support - IT Tech Systems 23017 Oracle Support - IT Tech Systems 1.2% 24018 SQL1Serv Support - IT Tech Systems .2% 25400 Oracle Administration 95685 I.T. !Disaster Recovery 95750 LT. HSEP 95755 I.T. -1PeopleSoft Upgrade Tech Sys/Net - Sub-Total: Radio CU ST Application Services Internal Services Technical Sys/Networking Information Technology - Total: INFORMATION TECHNOLOGY DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2017 1st Quarter Y.T.D. $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $186,987.75 $186,987.75 $8,027.00 $8,027.00 $607.75 $607.75 $84,546.75 $84,546.75 $493,648.00 $493,648.00 $0.00 $0.00 $0.00 $0.00 $773,817.25 $773,817.25 $31,033.75 $31.033.75 $31,033.75 $31,033.75 $72,374.75 $72,374.75 $1,911.32 $1,911.32 441.07 $441.07 1,010.76 $1,010.76 9,589.50 $9,589.50 0.00 $0.00 0.00 $0.00 0.00 $0.00 $85,327.40 $85,327.40 $890,178.40 I $890,178.40 Prepared by; Information Technology; 01/24117 Page 16 of 16 1st Quarter 2017.pdf Resolution #17033 February 15, 2017 Moved by Fleming supported by McGillivray the resolutions (with fiscal notes attached) on the amended Consent Agenda be adopted (with accompanying reports being accepted). AYES: Crawford, Dwyer, Fleming, Gershenson, Gingell, Hoffman, Jackson, Kochenderfer, KowaII, Long, McGillivray, Middleton, Quarles, Spisz, Taub, Tietz, Weipert, Woodward, Zack, Berman, Bowman. (21) NAYS: None. (0) A sufficient majority having voted in favor, the resolutions (with fiscal notes attached) on the amended Consent Agenda were adopted (with accompanying reports being accepted). HEREBY APPROVt THIS RESOLUTION CHIEF DEPUTY COUNTY EXECUTIVE ACTING PURSUANT TO MCL 45.559A (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 15, 2017, 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 County of Oakland at Pontiac, Michigan this 15th day of February, 2017. Lisa Brown, Oakland County