Loading...
HomeMy WebLinkAboutResolutions - 2012.11.28 - 20611MISCELLANEOUS RESOLUTION#12286. November 28, 2012 BY: FINANCE COMMITTEE, TOM MIDDLETON, CHAIRPERSON IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY — FOURTH QUARTER 2012 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 Fourth Quarter 2012 development charges to be $961,172.74 for the General Fund/General Purpose County departments; and WHEREAS direct charges to Special Revenue and Proprietary fund departments are $142,260.07 and non-county agencies are $10,696.50 for the Fourth Quarter 2012; 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 Fourth Quarter 2012 Development Report and approves the Fourth Quarter appropriation transfer as specified on the attached schedule. BE IT FURTHER RESOLVED that the respective departmental Fiscal Year 2012 budgets are to be amended as specified in the attached detail schedule. BE IT FURTHER RESOLVED that the Board of Commissioners approves Information Technology utilizing up to 1,000 hours of staff and professional services within a fiscal year to work on unfunded mandates; actual hours will be reported in the Information Technology Quarterly Development resolution beginning in FY 2013. FINANCE COMMITTEE Motion carried unanimously on a roll call vote with Potts absent. ACCOUNT # CUST # FUND # 1 F1,9pared by; Information Technology; 10/26/2012 BOC Doyelopment Billing Report 4th Qtr 7012 xlsy, INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 4TH QUARTER 2012 lst Qtr 2012 2nd Qtr 2012 3rd Qtr 2012 4th Qtr 2012 DIVISION Oct - Dec Jan - Mar Apr - Jun Jul - Sep Y.T.D. 540 101 550 101 560 101 530 101 630 101 620 101 005 101 725 101 722 101 440 101 410 101 724 101 720 101 723 101 522 101 430 101 015 101 495 101 483 101 474 101 498 101 502 101 493 101 785 101 004 101 740 101 660 101 900 101 680 101 907 101 565 101 872 101 710 101 206 101 775 101 480 101 512 101 510 101 145 101 650 101 195 101 191 101 445 101 600 101 910 101 GOVERNMENTAL FUNDS General Fund 0011 10100-3020201-121020-773630 10100-3020301-121020-773630 10100-3020401-121020-773630 10100-3020501-121020-773630 10100-1070801-114000-773630 10100-1 01020 1-1 81010-773630 10100-5010101-180010-773630 10100-2010201-180000-773630 10100-2010210-125000-773630 10100-2010301-185010-773630 10100-2010501-125000-773630 10100-2010210-125000-773630 10100-2010401-172190-773630 10100-2010205-132300-773630 10100-1070401-113000-773630 10100-1010501-181020-773630 10100- 10 10 10 1-181000-773630 10100-3010201-121110-773630 10100-3010403-121100-773630 10100-3010401-121240-773630 10100-3010301-121130-773630 10100-3010301-121180-773630 10100-3010101-121100-773630 10100-1090101-171000-773630 10100-1010101-196030-773630 10100-1020501-173010-773630 10100-1020601-182020-773630 10100-1010115-115090-773630 10100-1050401-183010-773630 10100-5010303-165040-773630 10100-1090108-171030-773630 10100-1070601-132030-773630 10100-1070501-174000-773630 10100-4030901-110040-773630 10100-1090201-171000-773630 10100-3040403-121080-773630 10100-3040403-124010-773630 10100-3040403-124010-773630 10100-4010101-122050-773630 10100-1020650-126020-773630 10100-4030301-112590-773630 10100-4030601-110000-773630 10100-1030803-184025-773630 10100-7010101-1 86040- 773630 10100-1070301-132050-773630 52/1 - District Court 52/2 - District Court 52/3 - District Court 52/4 - District Court Animal Control Auditing Division Ed of Commissioners Clerk/Reg - Admin Clerk.Reg - EDMS (Imaging) Clerk/Reg - Elections Clerk/Reg - Jury Commission Clerk/Reg - Legal Records Clerk/Reg - Register of Deeds Clerk/Reg - Vital Statistics Community Corrections Admin Corporation Counsel County Executive Courts-Business Division Courts-ED-Judicial Support-Adrnin Courts-FD-Juvenile Support Courts-GJ-Judicial Support Courts-GJ-Jury Operations Courts - Judea! / Administration Economic Development & Community Affairs Election Redistricting Equalization Division Fiscal Services - Admin Homeland Security Human Resources Library - Library Admin Marketing & Communcations Medical Examiner MSU Extension - Oakland OCSD - LE Support Serv Admin Planning & Economic Development Probate-Estates/Mental Health Admin Probate-Estates/Mental Health - EDMS (Imaging) Probate-Estates/Mental Health Support Prosecuting Attorney - General Prosecution Reimbursement Division Sheriff Sheriff - CLEM1S Support Services Treasurer Veterans Services $4,572.65 $6,023.47 $16,081.31 $15,872.32 $42,549.75 $4,572.65 $6,023.47 $16,081.31 $15,872.32 $42,549.75 $4,572.65 $6,023.47 $16,081,31 $16,604.32 $43,281.75 $4,572.55 $6,023.34 $16,081.07 $15,872.04 $42,549.00 $21,980_72 $39,130.61 $45,199.36 $7,868.53 $114,179.22 $0.00 $0.00 $3,782.00 $0.00 $3,782.00 $14,430.50 $61.00 $1,220.00 $4,342.00 $20,053.50 $1,626.00 $5,118.00 $4,780.00 $1,188.00 $12,712.00 $0.00 $0.00 $1,871.68 $3,635.76 $5,507.44 $2,297.00 $1,649.75 $1,830.00 $1,900.50 $7,677.25 $122.00 $0.00 $122.00 $0.00 $244.00 $14,588.00 $15,636.00 $14,560.50 $14,262.00 $59,046.50 $833.72 $1,358.11 $3,239.11 $2,194.78 $7,625.72 $3,409.47 $6,838.61 $7,077.11 $9,449.28 $26,774.47 $44,952.91 $37,078.71 $32,410.42 $34,082.29 $148,524.33 $0.00 $183.00 $61.00 $291.00 $535.00 $0.00 $0.00 $61.00 $108.00 $169.00 $515.00 $668.44 $546.35 $525.75 $2,255.54 $681.22 $870.11 $1,060.61 $731.28 $3,343.22 $0.00 $1,856.00 $0.00 $0.00 $1,856.09 $31,996.00 $33,046.00 $42,510.25 $70,104.00 $177,656.25 $1,029.94 $1,214.85 $1,092.81 $1,051.51 $4,389.11 $2,561.30 $1,560.86 $1,637.72 $3,181.29 $8,941.17 $64,546.75 $75,144.50 $128,831.25 $12,998.75 $281,521.25 $152.50 $0.00 $1,995.75 $0.00 $2,148.25 $91,921.26 $71,686.19 $79,596.32 $71,805.95 $315,009.72 $50,090.61 $58,453.37 $59,026.66 $51,261.77 $218,832.41 $557.00 $529.75 $2,262.50 $1,047.00 $4,396.25 $25,237.30 $24,760.01 $26,273.90 $18,618.52 $94,889.73 $345.00 $244.00 $549.00 $183.00 $1,321.00 $0.00 $0.00 $9,310.00 $6,146.50 $15,456.50 $6,656.72 $3,922.11 $4,350.11 $3,347.78 $18.276.72 $122.00 $122.00 $162.00 $648.00 $1,054.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2,217.00 $2,162.00 $4.379.00 $0.00 $0.00 $2,958.50 $0.00 $2,958.50 $0.00 $0.00 $1,637.72 $3,181.29 $4,819.01 $11,898.47 $4,656,11 $4,807.61 $5,914.28 $27,276.47 $33,976.47 $34,972.86 $19,177.11 $18,093.28 $106,219.72 $4,781.25 $3,611.75 $27,963.50 $19,098.50 $55,455.00 $131,899.00 $98,925.94 $102,515.85 $70,433.75 $403,774.54 $6,885.94 $18,550,85 $12,350.31 $12,735.01 $50,531.11 $2,798.14 $4,332.39 $7,542.81 $3,661.99 $18,335.33 $154,772.50 $63,940.91 $90,631.17 $122,152,92 $431,497.50 $9.00 $18300 $61.00 $0.00 $244.00 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 4TH QUARTER 2012 1st Otr 2012 2nd Otr 2012 3rd Qtr 2012 4th Otr 2012 CUST # ruNn # ACCOUNT # DIVISION Oct - Dec Jan - Mar i"jor - Jun Jul - Sep Y.T.D. 730 101 101on 6010101-155010-773630 Water Resource Commissioner Sub-Total Fund 101 $43.302.72 $58,533.86 $74,257.11 $60,038.98 $235,132.67 $789,257.91 $692,933.40 $885,873.10 $702,666.24 $3,070,730.65 Health Fund 12211 840 221 20221-1060201 -133150-773630 I lealth $58,881.00 $41,571.75 $89,436.75 $114,572.00 $304,461.50 843 221 20221-1060220-134390-773630 Health Environmental $112 396.89 $116.122.51 $115,996.28 $137,526.50 $482,042.18 Sub-Total Fund 221 $171,277.89 $157,694.26 $205,433.03 $252,098.50 $786,503.68 Juvenile Maintenance Fund_12931 665 293 20293-1060501-112090-773630 Children's Village $14.640.75 $23,110.00 $10,739.50 $6,408.00 $54,898.25 Sub-Total Fund 293 $14,640.75 $23,110.00 $10,739.50 $6,408.00 $54,898.25 63600-1080101-152000-631365 DEVELOPMENT FOR GOVERNMENTAL FUND $975,176.55 $873,737.66 $1,102,045.63 $961,172.74 $3,912,132.58 APPROPRIATION GOVERNMENTAL IMAGING 722 101 10100-2010210-125000-773639 512 101 10100-3040403-124010-773639 Clerk/Reg Image Probate-Estates/Mental Health Image $2,927.20 $1,783.84 $0.00 $0.00 $4,711.04 $2,561.30 $1.560.86 $0.00 $0.00 $122.16 63600-1080101 -152000-630903 TOTAL GOVERNMENTAL IMAGING $5,488.50 $3,344.70 $0.00 $0.00 $8,833.20 DEVELOPMENT APPROPRIATION SUB-TOTAL GOVERNMENTAL / IMAGING DEVELOPMENT APPROPRIATION: $980,665,05 $877,982.15 $1,102,045.63 $961,172.74 $3,920,965.78'. '10100-9090101-196030-773630 Information Technology Development 05) ($377.08::•;.;6) : ) 74) f‘$3,:r.p0.265.76! TOTAL GOVERNMENTAL: $0.00 $0,00 $0.00 $0.00 $000 NON-GOVERNMENTAL DIRECT CHARGES 672 Assessment & Tax 669 CAMS/CVT Data Conversion 652 CAMS/FM° (IT Implementation) 055 CLEMIS 056 CLEM'S FUND 63500 659 Collaborative Asset Mgt Sys (CAMS) 471 Courts-FOC Exp-CS Enforcement - EDMS (Imaging) 507 Courts-FOC Exp-CS Enforcement 837 EDCA - MITradeSchool.org Grant 210 Fire Records Management System 750 FM&O 841 Health - H1N1 Grant 653 O.C. Intnl Airport 770 Parks and Recreation - Administration 747 Pontiac - Water 748 Pontiac - Sewer 791 Radio Communications - E911 656 Water Resources Accounting Pr•-- - • h`../7 Info!mation Technology: 10/2612012 $0.00 $0.09 $0.00 $19,623.75 $19,623.75 $9,339.25 $7,952.50 $11,781.50 $673.00 $29,745.25 $0.00 $0.00 $0.00 $0.00 $0.00 $12,307.00 $20,171.24 $28,274.50 $18,434.86 $79,187.60 $8,601.00 $4,331.00 $5,612.00 $4,666.00 $23,210.00 $144,901.50 $78,291.00 - $57,371.00 $20,256.50 $3110,820.00 $0.00 . $0.00 $1,637.72 $3,181.29 $4,819.01 $11,748.25 , $24,862.25 $11,860.25 $16,152.50 $64,623.25 $0.00 $0.00 $0.00 $3,169.00 $3.169.00 $681.22 $070.11 $1,060.61 $975.28 $3,587.22 $3,092.22 54,255.11 512,999.61 $10,866.63 $31,223.57 $0.00 $122.00 (5122.00) $0.00 $0.00 $1,376.00 $2,809.00 $122.00 $0,00 $4,307.00 $30,169.50 $25,591.75 $15,233.00 $15,321.00 $86,315.25 $0.00 $0.00 $0.00 $4,193.25 $4,193.25 $0.00 $0.00 $0.00 $4,193.25 $4,193.25 $19,235.50 $0,00 $0.00 $1,585.00 $20,821.50 $7,697.94 78,005.66 .76,305.55 $2,626.26 524,635.36 3 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 4TH QUARTER 2012 1st Qtr 2012 2nd Oft 20'12 3rd Qtr 2012 4th Qtr 2012 CUST # FUND # ACCOUNT # DIVISION Oct-Dec Jan-Mar Apr-Jun Jul-Sep Y.T.D. . 850 Workforce Dev Division $0.00 $0.00 $936.00 ($936.00) $0.00 734 VVRC - AMR Support $1,092,00 $0.00 $0.00 $0.00 $1,092.00 670 WRC Acctg - Crowder Prjct $305.00 $610.00 $661.50 $9,860.50 $11,437.00 , 745 WRC - COSDA Meter Replacement $0.00 $3,850.50 $8,150.00 $4,193.50 $16,194.00 728 WRC - CO SDS SewMet $0.00 $0.00 $342.00 $1,795.50 $2,137.50 737 VVRC - Data Application Pilot Poject $1,494.50 $183.00 $1,528.50 $399.00 $3,605.00 671 WRC - Infrastructure Op Ar $0.00 $0.00 $7,527.75 $943.50 $8,471.25 738 WRC - SCADA Engineering Assessment $1,311.50 $2,104.50 $2,936.50 $85.50 $6,438.00 63600-1080101-152000-631302 SUB-TOTAL DIRECT CHARGES FOR DEVELOPMENT $253,35t38 $184,019.56 $174,218.00 $142,260.07 $753,849.01 NON-GOVERNMENTAL IMAGING 471 Courts-FOC Exp-CS Enforcement Image $2,561.30 $1,560.86 $0.00 $0.00 $4,122.16 63600-1080101-15200-630903 TOTAL NON-GOVERNMENTAL IMAGING $2,561.30 $1,560.86 $0.00 $0.00 $4,122.16 DEVELOPMENT APPROPRIATION TOTAL COUNTY DEVELOPMENT CHARGES $1,236,577.73 $1,062,662.78 $1,276,263.63 $1,103,432.81 $4,678,936.95 NON-COUNTY AGENCIES 63600-1080101-152000-635017 Non-County Agencies $9,792.50 $8.667.00 $15.759.50 $10,696.50 $44,915.50 TOTAL DEVELOPMENT CHARGES $1,246,370.23 $1,071,329.78 $1,292,023.13 $1,114,129.31 $4,723,852,45 BOO D'7.,..'7:Topment Billing Report 4th Oh 2912.xlsx Prepared by Inforrontion 'Technology; 10/2612012 oust # GOVERNMENTAL FUNDS 630 ANIMAL CONTROL 005 BD OF COMMISSIONERS 665 CHILDRENS VILLAGE 725 CLERK/REG - ADMIN 440 CLERK/REG - ELECTIONS DIVISION 720 CLERK! REGISTER OF DEEDS 24003 SQL Server Stipp - ROD 3.5% $731.28 36510 GIS Implementation Support $271.00 36511 ROD Application - HAN Support $704.50 95493 ROD System Maintenance $0.00 95498 Clerk/Reg - ROD 488.00 Clerk/Reg of Deeds - Total 722 CLERK/REG - EDMS (IMAGING) 95158 Clerk/Reg - EDMS SupporUMaintneance/Upgrades $3,635.76 Clerk/Reg EDMS (Imaging) - Total 724 CLERK/REG - LEGAL RECORDS 95189 Circuit Court System $14,262.00 Clerk/Reg - Legal Records - Total 723 CLERK - viTAL STATISTICS 24015 SQL Server Supp - Vital Stets 3.5% $731.28 95161 Clerk.Reg - Vital Statistics 8,718.00 Clerk - Vital Statistics - Total ECnC ' 1 Pmpared by: Information rechnology: 1012e/2012 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2011 $731.28 14,741.50 (7,604.252 24017 SQL Server Supp - Animal Control 95628 Web License Registration 95682 Dog System Animal Control-Total 91404 BOC - Customer Support $4,342.00 Bd of Commissioners - Total 95665 Childrens Village $6,408.00 Childrens Village - Total 72500 Clerk - Admin $1,188.00 Clerk/Reg - Admin - Total 95443 Elections $1.900.50 Clerk/Reg - Elections Division - Total $7,868.53 $4,342.00 $6,408.00 $1,188.00 $1,900.50 $2,194.78 $3,635.76 $14,262.00 $9,449.28 23003 Oracle Support-Comm Corr - 5.2% $1,051.51 24012 SQL Server Supp - Community Corr 3.5% 731.28 52200 Comm Corr-Admin (County) 32,299.50 52201 Comm Corr - DVV Support 0.00 Community Corr actions - Total $34,082.29 430 CORPORATION COUNSEL 95501 Corporation .)upsel U91.00, - Total $291.00 Rupoi ,111 Cilr- 2912.x'sx 522 COMMUNITY CORRECTIONS-ADMIN (CO) INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - FOURTH QUARTER 2012 015 COUNTY EXECUTIVE 95656 County Executive Support $108.00 County Executive - Total $108.00 495 CTS-BUSINESS DIVISION 12002 CCT-Courts/Criminal $0.00 23010 Oracle Support-CCT/CTS Crirn Whse 2.6% $525.75 CIS-Business Division - Total 483 CTS-FD-JUDICIAL SUPPORT-ADM 24009 SQL Serv Supp - CTS-Jud Sup Adm - 3.5% $731.28 CTS-FD-Judicial Support-Adm - Total 498 CTS-GEN JURIS-JUDICIAL SUPPT 95179 CTS-Gen June-Judicial Suppt $70,104.00 CTS-Gen Juris-Judicial Suppt - Total 502 CTS-GJ-JURY OPERATIONS 23008 Oracle Support-CTS-GJ-Jury Operations $1,051.51 CTS-GJ-Jury Operations - Total 493 CTS-JUDICIAL ADMIN 95174 CTS-Judicial Admin $3.181.29 CTS-Judicial Adrnin - Total 785 ECONOMIC DEVELOPMENT & COMMUNITY AFFAIRS 36500 GIS Implementation Support C&E Dev $0.00 36501 CEO Application - MN Support 11,958.25 95785 Comm & Eco Deve.loprnt 1.040.50 Economic Development & Community Affairs - Total 740 EQUALIZATION 23012 Oracle Support-Equalization -5.2% $1,051.51 24005 SQL Server Supp-Equalization - 10.5% 2,193.76 31075 Equal - Development 0.00 36505 GIS Implementation Support Equalization 61.00 36506 Equal Application - HU Support 16,016.50 36601 Land System Enhancements - Equal (50%) 29,650.43 36701 Land System Maintenance - Equal (50%) 2,686.25 36801 Land System Support - Equal (50%) 3,884.50 95562 Equalization - DW Support 366 00 95699 BS&A Master Appraisal Sup/Maint 15.896.00 Equalization - Total $525.75 $731.28 $70,104.00 $1,051.51 $3,181.29 $12,998.75 $71.805.95 pr,[,,,,,d tr,rwrmtion Techno17..gy; 1,)/2.3/7012 11 FICnC F.!.epo.rt 4th at).- 221Z 660 FISCAL SERVICES ADMIN 840 HEALTH DIVISION 843 HEALTH - ENVIRONMENTAL 900 HOMELAND SECURITY INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - FOURTH QUARTER 2012 23001 Oracle Support - Fiscal Seri - 15.6% $3,154.54 23013 Oracle Support - HR-AcctgiBudget - 5.2% 1.051.51 24006 SQL Serv Supp - HR-Acctg - 1.75% 365.72 44021 FS-System/Customer Support 15,290.00 44023 FS - System Enhancements 10,370.00 96001 Human Res - Acct 40% 14,020.00 96003 Human Res - Budget 20% 7.010.00 Fiscal Services Admin - Total 36525 GIS Implementation Support Health $52.50 95563 User Support-Health 65,892.25 96842 Health Admin 48,627.25 Health - Total 23005 Oracle Support - EH Projects - 5.2% $1,051,51 24014 SQL Server Suppt - Ehealth 14% 2,924.95 84200 EH - Projects 52,856.04 84300 Ehealth Program 80,694.00 Health-Environmental - Total 36545 GIS Implementation Support Homeland Security $180.00 36546 Homeland Security Application - HAN Support 867.00 Homeland Security - Total $51,261.77 $11 4,572.00 $137,526.50 $1,047.00 680 HUMAN RESOURCES 907 LIBRARY- LIBRARY AMIN 565 MARKETING & COMMUNICATIONS 23014 Oracle Support-HR/Personnel - 5.2% $1,051.51 24007 SQL Server Suppport-HR/Personnel - 1.75% 365.72 96002 Human Res-Personnel 40% 17,201.29 Human Resources - Total $18,618.52 91405 Library Board $183.00 Library - Library Artinin - Total $183.00 56500 Marketing & Communications $6.146.50 Marketing & Communications - Total $6,146.50 by: !!-. formatinn technology; 1 .7.,'2.1Y20'12 Pepe[t I 872 MEDICAL EXAMINER 710 MSU EXTENSION - OAKLAND 775 PLANNING & ECO DEVELOPMENT 512 PROB•ESTATES/MENTL HLTH EDMS omg 510 PROB-ESTATES/MENTL HLTH SUPPORT $731.28 2.616.50 $648.00 $2,162.00 $3,181.29 $731.28 5.183.00 $5,914.28 $3,347.78 $648.00 $2,162.00 $3.181.29 $0.00 $525.75 1,159.00 0.00 3,089.00 65,660.00 $70,433.75 24016 SQL Server Strop - Proescutors 3.5% $731.28 95622 Prosecutor/Executive 16.009.00 97001 Prosecutor Data Proc 1,353.00 Prosecutor - Total 95470 Reimbursement System $19,098.50 95542 Reimburse User Support 0.00 Reimbursement - Total $18,093.28 $19,098.50 145 PROSECUTOR - GENERAL PROSECUTION 650 REIMBURSEMENT INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 20`1 195 SHERIFF 24002 SQL Server Support - Medical Exam - 3.5% 87202 Medical Examiner - Customer Support Medical Examiner - Total 95676 MSU Ext Equipment Maintenance MSU Extension - Oakland - Total 95600 PEDS CustiSystem Support Planning & Eco Development - Total 95207 PC-E./MI-1E0MS Support & Mtce Pr-oh-Est/Mutt Filth EDMS (Img) 24010 SQL Serv Supp-PCT-Est/Mentel - 3.5% 92198 Prob-EsI/Mnll Hlth Support Prob-Est/Mntl Hlth Support - Total 12001 OCSD-Courts/Criminal - 50% 23009 Oracle Suppport - OCSD/CTS COTTIVVhse - 2.6% 97163 Sheriff 97164 Sheriff - Den.,71opment 97165 Sheriff-DVV Support 98164 CLEM1S-Sheriff • Sheriff - Total Bctrt rt,•;elortnnitt- 011llng Report 4t,f-, Otr 2212.ftlsx Freporni by: Infotortion Technology; 10(25,2012 191 SHERIFF - CLEMIS 445 SUPPORT SERVICES 600 TREASURER 730 WATER RESOURCE COMMISSIONER INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT/SUPPORT DETAIL - FOURTH QUARTER 2012 23015 Oracle Support - Sheriff! CLEMIS - 5.2% $1,051.51 96163 Sheriff - CLENIIS 11,683.50 Sheriff - CLEMIS - Total 23002 Oracle Support - Supp Serv - 5.2% $1,051.51 24011 SQL Server Supp - Suppt Services 7% 1,462.48 44500 Support Services 1,148.00 Support Services - Total 23006 Oracle Support - Del Tax - 5.2% $1,051.51 23016 Oracle Support - Treasurer - 10,4% 2,103.05 36516 Treasurer Application - H/VV Support 4491.00 36602 Land System Enhancements - Tress (50%) 29,650.32 36702 Land System Maintenance - Trees (50%) 2,686.25 36802 Land System Support - Tress (50%) 3,884.50 44061 Tre-SysterniCustorner Support 12,623.79 44062 Tre-System Maintenance 10,549.00 44063 Tre-System Enhancements 11,710.00 44080 Tre-DVV Support 305.00 44082 Tre-DVV Maintenance 0.00 95008 Del Tax On Line 122.00 95303 Del Tax System Maintenance 7,411.50 95561 User Support/Del Tax 28,698.00 95615 BS&A Annual Tax Support 6,867.00 Treasurer - Total 24008 SQL Server Stipp - WRC 3.5% $731.28 28010 1NRC - Customer Support - 31,886.20 28011 Water Resource Commissioner Application 7,252.00 36520 GIS Implementation Support WRC 2,365.50 36521 VVRC Application - Fi/W Support 17,804.00 Water Resource Commissioner - Total $12,735.01 $3,661.99 $122,152.92 $60,038.98 WW-r ,7rii rtatrelopment Eti'lOrg Report ttter ft ;2' Prep:wed !-2.y: I1f2 T19lier1 Technology: 1012512012 $15,872.32 $15,872.32 $15,872.32 $15,872.32 $732.00 15,872.32 $16,604.32 $15,872.04 $15,872.04 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 20 12 540 52/1 DISTRICT COURT - NOVI 550 52/2 DISTRICT COURT - CLARKSTON 560 52/3 DISTRICT COURT - ROCHESTER 530 5214 DISTRICT COURT - TROY 95527 DC Suprt- 52/1 - 25% 52/1 District Court - Total 95528 DC Suprt- 52/2 - 25% 52/2 District Court - Total 95288 52 Dist Ct Div 3 95529 DC Suprt 52/3 - 25% 52/3 District Court - Total 95530 DC Suprt- 52/4 - 25% 52/4 District Court - Total Soc rt...!:::IiiUng Report 4t111.)ir 72'17 ReparPd by Ifl ,crumtion tochn7fogy; 10/2ry7012 cust # DIRECT FUNDS 672 ASSESSMENT & TAX 055 CLEWS 056 CLEMIS FUND 63500 669 CAMSiCVT DATA CONVERSION 659 COLLABORATIVE ASSET MGT SYS 471 CTS-FOC-EXP-CS ENFORC-EDMS (IMG1 507 CTS-FOC EXP-CS ENFORCEMENT 23004 Oracle Support - OakVideo CLEMIS 5.2% 23018 Oracle Support - Sheriff CLEMIS 5.2% 24004 SQL Server Support - 24.5% 95430 CLEMIS Maintenance 95431 CLMS Enhancements 98003 CLEMIS User Support CLEMIS - Total $1,051.51 1,051.64 5.118.71 7,919.00 2,928.00 366.00 837 EDCA, - MITRADESCHOOLORG GRANT 83700 EDCA - MITRADESCHOOL EDCA - MITradeSchooLorg Grant - Total $3,169.00 $244.00 731.28 $975.28 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - FOURTH QUARTER 2012 67200 Assessmenet & Tax $19,623.75 Assessme,net & Tax - Total $19,623.75 $18,434.86 63500 CLEMIS Fund $4,666.00 CLEMIS 63500 Fund - Total $4,666.00 66901 CAMS/CVI Data Conversion $673.00 CAMS/CVT Data Conversion - Total $673.00 65901 Collabortive Asset Mgt Sys $20,256.50 Collabortive Asset Mgt Sys - Total $20,256.50 92194 CTS-FOC-CS ENF-EDMS Support/Maintenance/Upgrades $3,181.29 CTS-FOC Exp-CS Enforc-EDMS (Img) - Total $3,181.29 92193 CTS-FOC Exp-CD Enforc-Dev $16,152.50 CTS-FOC Exp-CD Enforc-Dev - Total $16,152.50 $3,169 00 210 FIRE RECORDS MANAGEMENT SYSTEM 21010 Fire Records Mgmt Fund 531 24001 SQL Server Support - FRMS 3.5% Fire Records Management System - Total 750 FM&O 21001 Facilities Maintenance & Operations $3,318.75 24013 SQL Server Stipp - FM&O 731.28 75503 FM&O Development 6,816.60 FM&O - Total $1086663 'pared by: Infcrmation TechnclogY; 10/26/2012 .roe 1 1 :311 1 OCT:, b/Fr,.../Th-Tmnrt 9Wing Ri7.7port /Ith Qtr 2012.X.F5X '11 365'30 GIS Irnple.rnenlation Support - Parks $2,429.50 44066 PRADM-SysterniCustorner Support 761.50 44068 PRP,D1v1-System Enhancements 0.00 76100 P&R Administrative Services 2,044.00 95413 PRADM-Customer Support 3,218.50 95419 PRADTv1-Administration 6,867.50 Parks & Recreation - Total 74701 Pontiac BSA to VVRC - Water $4,193.25 Pontiac Water - Total 74702 Pontiac BSA to WRC - Sewer $4,193.25 Pontiac Sewer - Total 79101 Radio Communications - E911 $1,586.00 Radio Communications - E911 - Total 656 WATER RESOURCES ACCOUNTING 23011 Oracle Supp - Water & Sewer Acct'g - 5.2% 95669 Water Resources Accounting Water Resources Accounting - Total $1,051.51 1,574.75 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 201'2 770 PARKS AND RECREATION 747 PONTIAC WATER 748 PONTIAC SEWER 791 RADIO COMMUNICATIONS - Egli 850 WORKFORCE DEV DIVISION 670 VVRC ACCTG - CROWDER PRJCT 745 WRC COSDA METER REPLACEMENT 728 VVRC - CO SOS SEWMET 737 VVRC - DATA APPLICATION PILOT PRJ 671 VVRC - 114FRASTRUCTURE OP AR 738 VVRC - SCADA ENGINEERING ASSESSMT 95670 Employment & Training VVorktorce Dev Division - Total 67000 WRC - Crowder NetBase Project WRC Acctg - Crowder Prject - Total 74500 WRC - CODSA Meter Replacement VVRC CODSA Meter Replacement - Total 72800 VVRC - COSDS Maintenance WRC - CO SDS SewMet - Total 73700 VVRC - Daia Application Pilot Project VVRC - Data Application Pilot Prj - Total 67100 VVRC -10 AR WRC - InfrostriTcture Op Ar - Total 73800 WRC scADA Engineering Assesmnt VVRC - SCADA Engineering Assesrnt - Total t$936.,90'1 $9.860.50 84,193.50 $1,795.50 $399,00 $943.50 $85.50 $15,321.00 $4,193.25 $4,193.25 $1,586.00 $2,626.26 f_1) $9,800.50 $4,193.50 - $1,795.50 $399.00 $943.50 $85.50 ! BOO 5n riercrtlUl!-M- 2017n.x1=3,-, Pr,pilred f7y: TF,chnn!,gy; In/25;2012 Resolution #12286 November 28, 2012 Moved by Crawford supported by McGillivray the resolutions (with fiscal notes attached) on the amended Consent Agenda be adopted (with accompanying reports being accepted). AYES: Crawford, Dwyer, Gershenson, Gingell, Gosselin, Hatchett, Hoffman, Jackson, Long, Matis, McGillivray, Middleton, Nash, Nuccio, Potts, Quarles, River, Runestad, Scott, Taub, Weipert, Woodward, Zack, Bosnic, Covey. (25) 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). I HEREBY APPROVE THIS RESOLUT CHIEF DEPUTY COUNTY EXECUTIVE ACTING PURSUANT TO MCL 45.559A (7) i 11 .3 1 t STATE OF MICHIGAN) COUNTY OF OAKLAND) I, Bill Bullard Jr., 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 November 28, 2012, 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 28th day of November, 2012. Bill Bullard Jr., Oakland County J'e(