Loading...
HomeMy WebLinkAboutResolutions - 2009.11.12 - 9890MISCELLANEOUS RESOLUTION #09262 November 12, 2009 BY: FINANCE COMMITTEE, TOM MIDDLETON, CHAIRPERSON IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY — FOURTH QUARTER 2009 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 2009 development charges to be $1,207,251.22 and the imaging development charge to be $25,205.39 for the General Fund/General Purpose County departments; and WHEREAS direct charges to Special Revenue and Proprietary fund departments are $459,688.20, non-governmental imaging development are $17,535.48, and non-county agencies are $1,719.00 for the Fourth Quarter 2009: 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 2009 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 2009 budgets are to be amended as specified in the attached detail schedule. FIN CE COMMITTEE FINANCE COMMITTEE Motion carried unanimously on a roll call vote with Potter absent. CUST # FUND* ACCOUNT* DIVISION 1st Dir Dot- DeO 2nd Otr .Jri - Mar 3rd Qtr Apr - June 4th Qtr Juke - Sept T.D. GOVERNMENTAL FUNDS Geineral Fund _0011 Cl 10100-30202014 21020-773630 0 00-3020301- 21020-773030 0 00-3020401- 21020-773630 0 00-302050 - 21020-773630 0 00-107080 - 14000-773630 0 00-10 028' 81010-773630 9 00-50. 010 - 80010..773630 0 00-20 0201 80000-773630 0' 00-20 0301- 85010-77363V 0 00-20' 0501- 25000-773630 0 00-20Y 0210- 25000-77.3530 0 00-20' 0401- 72190-773630 0. 00-20' 0205- 32300-773630 0 00-1070401- 13000-773630 0' 00-10/0501- 81020-773630 0 , 00-3010201-, 21110-773630 0 0-3010403-, 21100-773630 0:10-3010301- 21130-773630 0 1 0-3010101-, 21100-773530 .10 10-1010101: 81000-773630 0 10-1090101 - 71000-773630 1 1 0-1020501- 73010-773630 1 1 C 1 10-1020601- 82020-773630 0 104010115- 15090-773630 0 ,10-1050401-• ;3010-773630 1 0 160-5010303- , .5040-773630 0 j10-1070601- 2030-773630 ' 0 10-1070501-1 4000-773630 00. 1090201-1 1000-773630 • 0 110-3040403- 4010-773630 0 I 0-3040 101- P1060-773630 • Cr 10-4010101- ..2(.150.-773530 0 10-1030803- ;4020-773630 0 110-1020701- ..6020-773630 0 P0-4030301- 2590-773530 10 10-4030601- 0000-773630 10 10-4030901- 0040-773630 10 10-1030803- :4025-7736m 10 10-7010101-• :6040-773630 10100 1070301-132050-773630 10100-5010101-155010-773030 540 550 560 530 630 620 006 725 440 410 724 720 723 522 430 495 483 498 493 015 785 740 660 900 680 907 872 710 775 510 481 145 637 650 195 191 206 445 603 910 730 0 0 0 0 0 0 0 0 0 0 0 0 0 1 II su 0 0 1 0 0 0 0 0 a 0 0 G 0 0 a a 0' 0 0 0' 0 0 10.1 10 10 IO• WI 101 101 Health Fund 12211, Prepared by: information Technology; 10/2112009 130C Report 4th Quarter 2009 xis INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 4TH QUARTER 2009 52/1 - District Court 52/2 - District Court 52(3 - District Court 5214 - District Court Animal Control Auditing Board of Commissioners Clerk - Adnnin Clerk - Elections Clerk -Jury Commission Clerk - Legal Records Clerk - Register of Deeds Clerk - Vital Statistics Community Corrections Adman Corporation Counsel Courts-Business Division Courts-PO-Judicial SUpport-Admin Courts-GJ-Judicial Support Courts - „tactical/ Administration County Executive Economic Development 4 Community Affairs Equalization Division iscai Services - Admin omeland Security uman Resources ibrary AdmIn edical Examiner SU Extension - Oakland arrning a Economic Development rotate-Estatesitilental Health Support robate-FD Judicial rosecuting Attorney - General Prosecution ecords Retention eimbursement Division Sheriff Sheriff - CLEM'S Sheriff - LE Support Services Adtrun Support Services Treasurer Vetereal* Services Water Resource Commissioner Sub- Iola! Fund 101 $7,751.87 $7,751,87 $7,751.87 $7,751.89 $55,300 27 $0.00 $0.00 515,525.00 $3,723.00 $1,570,41 $135,612.02 $1.622.02 $0.00 $17,064.43 5270.00 $2,307.95 $2,869.02 $54,226.00 $4,472.45 $1,161.00 $980 50 $100,758.55 599,730.05 $91.50 $41,977.93 $2.390.40 512.847.77 $305.00 $16,659.00 $5.603.02 $0.00 512,968.02 $2,867.00 $39,679.00 596,948.70 $1,917.41 $0.00 56,495.18 $115,720.03 $918.00 $106,533.02 $992,220.75 $690050 $8,512.38 $6,900,50 $8,512.38 $6,900.50 $8.512.38 $6,900.50 18,512.36 $47,508.79 $50,653.01 $0.00 $610.00 $0.00 $311.00 $8,439.00 $11,142.00 $1,333.00 $3,615.00 $3,501.18 $3.654,64 $44,362.94 $26,920.51 $5,161.54 $10,924,51 $0.00 $5.994.00 $29,891.42 $60,594.05 $946.00 $392.00 $1,750.60 $2,040.82 $2,013.64 $2.144.51 $44,679.90 583,010.00 $40.283.58 $06,510.35 t$1,100 00) 330.50 $898.00 $647.00 $142,628,03 $130,898.13 $93,092,71 $97,362.30 $693.50 $30.50 527.588.75 $18.012.29 $277.00 $122.00 $11,343.54 $11,121.51 $30.50 $30.50 $3,635.50 $2,192.00 55,806.54 $5,054,91 $0.00 5122.00 5)4,409.04 $14,676.01 $22,203.50 $34,883.25 $36,761.20 $17,317.90 597.955.60 3104,616.3.2 $5,337.68 57,775.14 $0.00 $1,188.00 $12,505.50 $12.513.65 $120,09,3.10 5142,054.04 $0.00 $54.00 s_43.Qq5.79 51J 73.31 $895,358.47 51.075.041.46 $7,0213.01 $30,192.76 $7,028.01 $30,192.76 57,028.01 $30,192.76 $7,027.97 530,192.72 $52,263.44 $215,730.5? 3183.00 3793.00 $81.00 $392.00 $28,837.50 $63,943.50 $1,030.00 59,701.00 $3,408.04 $12,134.22 $22,319.44 3229,214.91 $21.151.04 $38,859.41 50.00 ¶5.994.00 $52,397.73 $159,941.53 $863.50 $2,471.50 $1,704.02 $7,803.39 $2,111.94 $9,139.01 556.360.00 5218,295.90 $40,235.87 $181,502.25 $0.00 $91,50 $3,288.50 $5,814.00 5155,342.31 5532,027 02 $104.920.12 $395.105.18 $152.50 $968.00 $15,729.01 $103,307-98 $213.50 $3,002.50 510,143.94 545.456.76 $0.00 $366.00 $945.00 $23,431.50 $12,155.94 $28,651.41 $61.00 $183.00 $23,095.44 355,148.51 55,492 •.'30 565,446.25 $16,701.00 $110,459.90 585,475.52 $385,026.14 54.908.54 519 938.77 $0.00 $1,188.00 $13,518.41 $45,032.74 3172.801.35 $550,668.52 $54.00 51.026.00 $65.579.52 $.3_0Z141-31 $1,004,693.59 53,987.314.27 ACCOUNT CliST # FUND # 840 221 20221-1060201-133150-773630 843 221 20221-1060220-134390-773630 Juvenile Maimenano F_und f2931 665 293 20293-1060501-112090-773630 63600-1080101-152000-631365 GOVERNMENTAL IMAGING 722 101 10100-2010210-125000-773639 512 101 10100-3040403-124010-773639 63600-1080101-152000-630903 Prepared 0y, Information Technotagy,1C/21.2005 BCC Report 41h Quarter 2009.xl5 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 4TH QUARTER 2009 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr DIVISION Oct: Dec Jan-Mar Apr • June Jul/ - Sem 10160-9090101-195030-773630 Health Heallh Environmental Sub-Total Fund 221 Children's Village Sub- total Fund 293 DEVELOPMENT FOR GOVERNMENTAL FUND APPROPRIATION Clerk Image Probale-EstalestMental Health Image TOTAL GOVERNMENTAL IMAGING DEVELOPMENT APPROPRIATION SUB-TOTAL GOVERNMENTAL I IMAGING DEVELOPMENT APPROPRIATION: Information Technology Development TOTAL GOVERNMENT: $22,226.50 $24,428.50 $25,279.80 $12.513.10 $84,447.90 $217,580.45 1170,298.06 5185,655.65 $187_4976.03 5761,510.19 $239,806.95 $194,726.56 5210,935.45 $200,489.13 5845,958.09 .51 4774.00 5 1 .089.00 $1.276 ..5_g $2,068.60 $6,208.00 51,774.00 51,089.00 $1276.50 $2,068.50 $6,208.00 $1,233,801.70 41,091.174_01 ;1,237%213,41 $1,207,251.22 54,819,480.36 $14,865 76 $18,217.92 $19,710.19 516 437.65 569,231.52 $8,944.90 $9.1311.16 $10.70,3,70 $8,767.74 523,810.66 528,029.08 82P,414.89 $2,205,39 $107,459,02 $1,257,812:38 $1119,203.11 $i,317,887.30 $1,232.4$8.81 $4,826,939.38 (1.7,612..36l 51, 19,2_Qa 1 1) L$1 317 667 30t L$1,232,456,011 (.$4 926•939_11.1 $0.00 $0.00 50,00 $0,00 669 055 056 096 719 659 661 507 210 750 757 81/ 751 653 770 791 663 601 546 656 NON-GOVERNMENTAL DIRECT CHARGES CAIVISICVT Data Conversion CLEWS CLEMIS FUND 63500 CLEMIS OS Fund Clerk/ROD Aulornation Fund Collaborative Asset Mgt Sys (CAMS) Community & Home Improvement Courts-r0C [.p-CS Enforcement Fire Records Management System FM & FM-Wk Rel/Jail MgtVideo Conf Health - BT CRI Grant IT - Telephone Comm 0,C. International Airport Parks and Recreation - Administration Radio Communications E-911 Security Camera Protect (Radio Fund) Treasurer - OTRF UASI Grant (Homeland Security) Water & Sewer Accounting $47, l41.00 554.831.22 $122.00 $0.00 512,925.50 $27,973.30 $0.00 $17,497.00 5829.02 $6,758.52 34.918.41 $0.00 $4,056.50 $7,693.50 $31,801.00 $871.00 $192.50 5398,242.50 $220.00 $14,9_05.91 530,922-50 527,526.70 324,771 50 $42,486.48 $38,057.43 532,113.13 $0.00 $2,562,00 Si ,594.00 $0.00 $0.00 $732.00 $51,543.00 $56,763.00 $85,136.25 $37,770.00 $44,949.70 $58,368.50 $0.00 $122.00 $0.00 $13,552.10 $8,772,00 $3.810.00 $3,489.04 $2,636.51 $2.357.44 $5,144.54 $5,194.51 $15.199.69 $22,513.18 $38,697.64 $40.354.54 $2,788.50 $45,866.50 $77,331.75 511.254 50 $11.837.00 516,350 00 58,738.50 $4,647.00 53,985.50 $40,913.35 $109.882.50 $72.894.75 $0.00 $0.00 50.00 $110.00 $4,240.50 $1,347.50 $349,211.75 1,325 758,91 $60,400,11 50.00 50 00 50.00 $'I,631.15 5174745,89 $12.941.54 $130,361.70 $167,48826 $4.278.00 5732.00 $236.367.75 $169.061.50 $122.00 $43,631 10 $9,312.01 $32.297.26 5106,483.77 $75,986.75 $43,498.00 525,064.50 $255,491.60 5871.00 $5,890.50 $782,095.77 $220.00 564,224.52 $52,268.44 cut* GOVERNNItNTAL FUNDS 630 ANIMAL CONTROL S2.111.94 29,367.00 20.789.5Q 24017 SOL Server Supp Aninial Control 95028 Web License Registration 95682 Dog System Animal Control-Total INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT i SUPPORT DETAIL - FOURTH QUARTER 2009 620 AUDITING 44034 Audititvg - New DevelOpmenli 50.00 95458 Auditing - Customer Support 183.00 Auditing Total 005 D if._31S.Q.141115.LQ111 NER 91404 EIOC - Customer Si ipport se1.00 BO of Commissioners - 'Total 655 CHILDRENS ALLAGg 95665 ClAdrens Village $2_,068.5G Childrens Village - Total 725 CLRK - ADMIN /25430 Clerk - Admin $28,837.50 Clerk - Admin - Total 440 CLERK ELECTION* 95443 Fleotrov $t.030 CO e Clerk - Elections - Total 720 CLERK I REGISTER OF _DEEDS 20004 DBA Customer Support - 20% $1,012.60 24003 SQL Server Supp - ROD 3 5% 2.11194 36510 GIS Implementation Support-R013 17,284.5,D 36511 ROD Application -1,1M Support 0.00 95493 Reg Deeds System Maintenance 0.00 95162 Clerk - LAN Support 0.00 95163 Clerk - OW Maintenance 0.00 95493 ROD - System Maintenance 732 00 95555 User SupportiROD 0.00 95564 ROD - OW Support Q.,LQ Cleric/Reg of Deeds I Mal S183.00 $81.00 52,068 50 $28,637.50 $1,030.00 .21.l51,04 722 CLERK - IMAQING 13001 Clerk - eFiling - 50% $0.00 23007 Oracle Support.- Clerk /mage 52% 3..786.04 6420 Clerk - Image Replace 1100 9515A Clerk Imaging 13.151 51 Clerk - Imaging - Total $15.437.65 410 CLERK - JURY COMMISSION 23008 ()rade Support - Jun,' Comm - 5.2% $3.786 04 95512 Jury Commission 127,00 Clerk - Jury Commission rota! $3.408.04 Prepered ty Intormatran Tschrrolagy, 10/2 U2009 BOC Report 4th Quartet 2049. xis $593_00 1,623.00 1,0/2.59 5:3,288.50 20001 1DMS support -Equalization - 40% 23012 Oracle Support-Equalizatior - 5.2% 24005 SQL Server Supp-Equalization 10,5% 31075 Equal - Development 36505 015 Implementation Support Equalization 36506 Equal Application - t INV Support 35507 Equal LA165 SupportthItce 36501 Land System Enhancements - Equal (50%1 36701 Land System Maintenance - Equal (50%) 36801 Land System Support - Equal (505'c) 95559 User Support/Equal 95562 Equalization - DtAl Support 95570 Eaualization - DW Maintenance 95693 Equal-System Maintenance 95699 BSgA Master Appraisal Sup.I.A.aint Equalization - Total 23001 Oracle Support - Fiscal Serv - 15.5% $9,858.11 23013 Oracle Support - HR-Acctg/Budge.t 5.2% 3.286.04 24066 SQL Serv Supp -11R-Aoctig - 1.75% 1,055.97 44021 FS-System/Customer Support 65 690 50 44022 FS-Systern Maintenance 6,241.00 44023 FS-System Enhancements 1,706.00 44024 FS-New Development 0.0.0 44075 BUD-System/Custoiner Support 0.00 4407/ BUD-System Maintenance 0.00 440/9 FS - OW Support 9.00 44081 FS -1:101Maintenance 0.00 96001 Human Res - Acct 40% 11.367.00 9E003 Human Res - Budget 20% 5695.50 Fiscal Services Admin - Total $2.025.20 3,286.04 6.33581 50,477.50 123_00 21,191.50 0.00 0.00 S.:323.63 18,171.88 0.00 6,035.00 305.00 1,891.00 4Z175.75 5158,342_31 $104,920.12 740 EQUALIZATION 660 FISCAL SERVICES A!..PMIN Prepared by Iriorrnatron Tactirollogy, r2ocsi BCC Fimpori 411, Quarter 20n9 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT 1 SUPPORT DETAIL FOURTH QUARTER 200 785 Ecsvomic DEVELQPMENT 3 COMMUNITY AFFAIFiS 36500 GIS Implementation Support C&E hey 36501 CEO Application -1-1/W Support 96785 Comm & Eco Developmt Econornic Development & Community .Affairs - iota! INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - FOURTH QUARTER 2009 710 MSU EXTENSION - OAK LAN_p 95576 MSU Ext Equipment Maintenance ,Cg,Q1 MSU Extension - Oakland - Total $0.00 775 PLANNING S ECONOMIC OEVELOPMENT 95600 PEDS-Custonner/Syslem Support $945.00 95786 PEDS - DtAI Support 0 0C 95757 PEDS - OW Maintenance PEDS - Total 461 PRO-FD JUDICIAL 95165 PC-Judicial Adm-Farntly Judges Prob-FD Judicial Total 612 PROB-ESTATSiMOTL Ht.T11 IMAGE 95207 Prob-EstiMntl HIM Image $8.761.74 Prob-Est/Mnd Filth Image - Total 510 PROS-ESTATES/MENTL FILTH SUPPORT 24010 SQL Sen., Supp-PCT-Est/rvlerital - 3.5% $2,111.94 92193 Prob-EstiMnil Hlth Support 11075.00 Prob-EsI/Mntl Hlth Support - Total 145 PROSECUTOR • GENERAL PROSECUTION 24015 SQL Server Supp - Proescutors 3.5 ;.+1 $2,111 94 95622 Prosecutor/Executive 12.186,00 97001 Prosecutor Data Proc S.797 50 Prosecutor - -fetal 637 RECORDS RETENTION 44052 Rec-System Maintenance $0. 00 44053 Rec-System Enhance.ments 305.00 44054 Rec-New Development 5,187.50 95536 Mail Room Records Retention - 'total 650 REIMBURSEMENT 95469 Reimbursement Div'sion $0 OD 9.470 Reimbursement System 16,701.80 95542 Remburse User Support 0.00 Reimbursement - Total $945 00 $61.00 $6,7157 74 $12,186.94 $23,095.44 $5,492.50 $16,701.80 BOC RePort d11,, Quarter 2009:15 Pfepared 131 Information rethnciagy: /0/2 1;20iN 52,111 94 0.00 32,336 25 9820.50 14 932.00 6,379.0Q 56b,579.69 $0.00 0.00 .7,028.01 $7,028.01 $0.00 0 00 $7,028.01 $0.00 0 00 7,028.Q1 $7.023 01 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - FOURTH QUARTER 2009 910 VETERAN* SERVICES 95651 Veterans Customer Support $54 00 Veterans Services - Total $54 00 73C WATER RESOURCE COMMISSIONER 24008 SOL Server Supp WC 3.5% 2.9007 Water Resource Commissioner 23010 VVRC Customer Support 28011 Water Resource Commissioner Application 36.520 015 Imr,olerrientation Su oport WRC 36521 %ARC Application - HAN Support VValer Resource cOrftlrliS wrier -Ot2i 540 5211 OISTRICT COVRT - NOVI 650 $212 DISTRICT COURT - CLARKSTON S6C 5213 DISTRICT COURT - ROCHE*TER b30 52/4 DISTRICT COURT - TROY 14002 CTS-DW Support-5211 - 6.25% 15002 CTS-DVV Maipt 52/1- 6.25% 95527 DC Suprt..- 5211 25% 52/1 District Court - Total 1 4003 C.IS-DW Support-52/2 - 6.25% 15003 CTS-DWMaint 5212 • 6.25% 95528 DC Suprt- 52/2- 25% 5212 District Court - Total 14004 CTS-DW Support-52/3 - 6.25% 1500.4 C FS-OW Main! 52/3 - 6.25% 95529 DC Suprt - 52/3 - 25% 5213 District Court - Total 14005 C TS-13W Support-52/4 - 6.25% $0 00 15005 CS-OW Maint 52/4 - 6.25% 0.00 95530 DC Suprt- 5214 - 25% 7.1)27.97 5214 District Court Total $7,027.97 Prepared Cy. irecninslion TeChndoCr, I0,212009 BOG Repen 4th Quarter 200.x INFORMATFON TECHNOLOGY - RESERVE FUND DEVELOPMENT i SUPPORT DETAIL - FOURTH QUARTER 2009 /50 FM8.0 21001 FM&O $1,796.50 24013 SOL Server Supp - FM&O 2 111,94 75503 FM&O Development 1129 l.2 F-M&O - Total $15, 199.69 757 FM-WK RELEASE/JAIL MGMTTYJDEO CONF 23004 Oracle Support - Oak Video - 5 29"0 $3,286.04 75700 Fac Mgmt - Video krargnments 37 06E.50 Reli,lail MgmtVideo Con ` • Total $40354.54 811 HEALTH - OT gRANT 81100 Health - 6T - CR1 Grant $27.7.,i31 75 Health • Br - CRI Grant - Fotal $27,3i75 751 IT - TELEPHONE COMM 75102 Tel Comm - Customer Support $16,350 40. - Telephone Corwin - Total $1635000 653 9C, INTERNAT10Wrt. AIRPORT 36540 GIS Implementatirm Support-Aviatron $1,271.00 65301 Airport User Support 305.00 65310 O(.:. Airport - Now Development 2,409.50 O.C. tnternational Airport-Total $3,985,50 770 PARKS AND REC _FA TION 36530 015 Implementation Support - Parks 52,419 00 44066 PRADM-SystemiCustomer Support 843.50 44068 PRADM-System Enhancernents 5,770.513 77010 PRADM- technology As/sessment 0.00 • 77100 Yr 1 - Program Management 6,744.75 77110 Yr 1 • Asset Theme Development 14,234.25 77120 Yr 1 - Network Connectivity 18,289. 25 77130 Yr 1 - P-ardware Refresh 3,378,25 77'140 Yr 1 - Paull of Sale 12,662.26 77200 Yr 2 - Program Management 852.50 95419 PRAM/I-Admtration 7 700.5Q Parks & Recreation - Total $72,894.75 791 RADIO J:10 79101 Radio Communications - 2911 $0.00 Radio Communications - 2911 - Total $0.00 Prepared by Inturmetion Technology, IN? i .1009 HOG Report 4th Quarter 2009 kis 560,400 11 180 I C Treasurers Office System 18054 Drain Apportionment 18060 Michigan Bvsiness FaK Trea5ure• TRF - total 601 TREASURER - DTIRF $0 00 40.991.61 10,408.50 INFORMATION TECHNOLOGY - RESERVE FUND VEVELOPMENT I SUPPORT DETAIL - FOURTH QUARTER 2009 663 SECURITY CAMERA PROJOT (PAM FUND.) 66300 Security Camera Project (Rad.o Fund), $1.347.50 Secigity Camera Plidied (Radio Fund) - Iota) 51.347 50 $0.00 546 UA511 GRANT (HOMELAND 5flCUR1TY) 12546 UASI Grarit (Homeland SecLaity) VAS( Grant (Homeland Secority) - Total $0.00 656 WATER RESOURCES ACOTQ 73011 Oracle Supp •- Water & Sewer Acctg $3.286.04 96669 Water Resources Acctg 9&55.50 Water Resources Acctg - Total $12,941.54 Prepared by irorwmaann Techor:angy. 10121 201:1•9 ROC Report dth Gemlor 2009 xis INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - FOURTH QUARTER 2009 cut2 DIRECT FUNDS 669 CAMI1CVT DATA CONVERSIO4 66901 CAMSCVT Data Converszn $24,771.50 CAMS,1C‘fr !Data ConyersIon - Total $24.771,50 05!, CLEWS 20003 IDMS Support - 5.6% $1012.60 230Th Oracle Support Shorif Ct EMS 5.2% 3,285.98 24004 SQL Server Support - 24.5% 14,753.55 90807 CAD Cuszomer Support C.00 95409 CRISINIST/GUEMIS LRM 244.00 05430 Cf. EM1S Maintenance 72,787 00 95431 CLEM'S Enhancements 0.00 95432 CLEWS Mho c Reports 0.00 98003 CLEWS User Support 00I3 CLEWS - Total 056 CLEMIS PUNS 11500 63500 CLEMIS Fund 11594 DO CLEM1S €3500 Fund - Total 098 CLEMIS 1131 OftANT 83596 CLEM IBIS Grant 2..00 CILEMIS IBIS Grant - 719 Sl..gaKfROO AUTOMATION F 95719 Register of Deeds AuromatiOn $85.136.25 ClerkdROC Automation Fund - Total 659 c0LAI5ORATIVE A5SkT MOT Vs 65907 CollabortIve Asset Mgt Sys $58,368 51:1 Colabortive Asset Mgt Sys - Total 661 COMMVN & HOME IMPROVEMENT 66103 Comm Ocv User Support Commun & I-kmrre Improvement - 'Total 471 CT5-F9C-EXP-CS ENPORC-$MAGE 92194 CIS-FOC-1p-CS Ent-image 117,535.48 CTS-FOO Ent-Image - Total 507,g111.12c_cp _FORC FA NT 92193 CTS-FOC Exp-CD Enforc-Dev $3,8102_Q CIS-FOC Exp-CD Entorc-Dev - Total 2113 REC ROS1IVIMEM YST 11.11 21010 F4e Records Mgmt Fuld 531 $245.50 24001 SQL Server Support - FIRMS 3,594 2 111.94 Fire Records Management System - Total $32,113.13 $1.594.00 $732.00 585:136.25 $58.368.50 90.00 $17,535.48 $3,810.00 52357,44 Prppa442c1 by' ihiarnyeliorl Ti.ohno/ogy, 7001,2009 ZOO Report 4Th Cormier i'2001 OCSD-Courts/Gornm91 Warehouse $61.00 23909 ()rade stippport GC$DCTS Crirn Ulto.se 2.6% ,643.02 97163 Sheriff 74,406.50 97165 Sheriff-OW Suppoi. 9 149 DO 17166 Sheriff-OW Maintenance Sheriff - Total 23015 Ora cie Suppcort - Sheriff 1 CLEMIS 5 2% 3.3,285.04 95153 Sherllt -CI EMS 1 62.50 8f Triff - C.LEMIS - Total 585,475.2 $408.54 20600 Results Application Reportin2 $0.00 Sheriff - LE Support Serv Admin - Total' S0.00 206 SHERWF - LE *11PPORT SqRV A DMIN 195 SHERIFF 191 SHERIFF - CLEWS 4 5 SUPPORT SERVICES 600 TREASURER $3,286.04 4,223 37 50 $13,518.41 $3,286.04 6,572.07 677.00 7930.00 0.00 6,32.162 18.171 67 27,650.25 5.562.00 2.628.00 6.381.00 1.'1,822.00 .3050 1,708.00 15,476.50 18,223 50 42,054.00 $112,801.35 tro-URMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2009 23002 OracIe Support - Sup Sew - 5.2% 24011 SQL Server Supp - Suppt Services 7% 44500 Support Services Support Services - Total 23008 Or ode Support - Det 'Fax - 5.2% 23016 Oracle Support - 'Treasurer 10.4% 36515 GIS Implementation Support- t reosurcr 365115 Treasurer Application - HAN Support 18602 Land System Enhancements . Trees Sisrt.,,} 36702 Land System fvlaintenance. Treas (50%) 36802 Land System Support - Trees (50%) 44061 Tra-Systenleustomer Support 44062 •re-System Maintenance 44063 Tre-Stem Enhancements 4.4054 Tre-New Development 44080 Tre-OW Support 44092 Tre-DW Maintenance 96098 De; Tax On Line 05303 Del Tax System Maintenance 95661 User &ippon)Del Tax 955.15 8S8,A Anotkai Tax Support Treasurer - Toial Tecraul ROC Repnri 4th 01,zoar 200? kis orep4red iDtal-rmizor, .og7, 10/21.,2005. 840 HEALTH DIVISION 843 HEALTH • ENVIRONMENTAL 900 HOMELAND SECURITY 680 HUMAN RESOURCES $1,012 50 270.00 108.00 5,13250 S.,990.00 $3,286.04 8,447 74 C.00 136,971.25 _30.269.00 $12513 10 5157,97603 $30.50 122.00 0.00 $152.50 53,286.04 1,055.97 0 04 0.00 0.00 0.00 ii1111.00 $15.720.01 $213.50 52 111 54 8,032.00 $713.50 $10,14394 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - FOURTH QUARTER 2009 877 MEDICAL EXAMINER 907 LIBRARY - LIBRARY ADMIN 20002 1DMS Support - CHAMPS - 20% 36525 GIS Implementation Support Health 37025 CHAMPS P.O.P. 95563 User Support. Health 96842 Health Adrrin Health - Total 23005 Oracle Support - EH Projects - 5.2% 24014 SQL Serer Suppt - Ehealth 14% 3 1002 En vironmental 84200 FH - Projects 84.300 Ehealth Program Health-Envirgnmental - Total 36545 GIS Implementation Support Homeland Security 36546 Homeland Sacunty Application - HIW Support 98990 Homeland Security Home!and Security - Total 23014 Dradie Suppol-HR/Personnal - 5.2% 24007 SQL Server Supppott-HRiPersoanel - 1.75% 44041 PER-System/Customer Support 44042 HR-Systems Maintenance 44044 HR-New Development 95556 HR User Supt 56002 Human Res-Personnel 40% Human Resources - Total Library Board diva:7 - Library Admin - Total .24002 SQL Server Support - Medical Exam • 3.5% 87202 Med;cal Examiner - Customer Support Medical Examiner - rota! 9140b Prepaied by intormaton Technology 10/21/2009 EICC Rep orl 4th Curter 200g.xls OC $7,111.94 ‘2,20 I. $22,319.49 9.51F1 C1orI- Vital Statistics SQ. 0 Clerk - Vital Sta'Jstics - Total $0.00 23003 Orade Support Comm Corr - 5.7% $3,236.04 24012 SQL Server Supp - .Cornrrunity Corr 3.5% 2,111.99 52200 Comm Corr-Arrerr0 (County) 46,999 76 5220.1 Comm Cort-EAN Supp 0.00 Communily Corrections - Total $52,397..73 95501 Corporation Counsel La53.50 Corporation Counsel - TotaI 5863 50 $0.00 $0.00 015 ,OlLJNTY EXECUTIVE 95654 County Exec.- Development 95656 County Executive Support County Executive - Total 498 CTS-GEN JURIIS-JUDICIAL SUPPT 493 CTS-JUDICIAL ADRIN INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - FOURTH QUARTER 2009 724 CJ.ERK - LEGALRECOR_pS 723 CLERK - VITAL STATMCS 522 COMMUNITY CORRECTIONS-ADMINfC01 430 CORPORA -IR:Ai COUNSEL 24015 SQL Server Stipp - Circuit Ct .3.5% 95189 Cecuit Court System Clerk - Legal Records • Total 495 CTS-13USINESS DIVISION 483 cTS-FID-,..11,12CIALSVPP0PtI-AOtil 12002 Circuit Ct-Courks/CrIminal Warehouse 50% $61.00 14001 CTS-OW Supportleirouit Ct - 75% 0.00 16001 C r S-DW MaimiCircuit Ct - 75% 0.00 230W Oracle Support-CCT/CTS Crim WIrse 2.6% 1,643.02 CTS Business Division - Total $1.709 02 29009 SQL Serv Stipp - CTS-Jud Sup Adm - 3.5% $2,111.94 95193 CIS-VD-Judicial Support-Adrn 191 I S-PD-Judicial Support-Ad ir . Total $2,11,94 95179 C TS-Gen Juris-Jud.cial Stipp( W.380.00 CTS-Gen Juris-Judicial Suppt - Total $56,380.00 13002 CTS-eFiling - 50% $0.00 95174 C rS Judicial Adinrn 40 235,87 CTS-Judlc,alAdmin - Total 540,235.87 Prppared by. IntcEtylabort nclmology• 11:J21/2009 130C Repol 4th Quarter 2D9 xis INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 4TH QUARTER 2009 151 Qtr 2nd Qtr 3rd Qtr 4th Qtr ACCOUNT X DIVISION Oct: Dec Jan - Mar Aor - Arne AIN - Sect Y.T.D. 63600-1-030101-152000-631302 SUB-TOTAL DIRECT CHARGES FOR DEVELOPMENT $_630,978.88 $639.068.6a $423.742.29 $459,688,20 $2,153,477,99 NON-GOVERNMENTAL INIAGING 471 Courts-FOC. Exp-CS Enforcemert Image L12„889.81) .$19,622.32 $21,40_7.2.4Q t7535.45 vo. 455,00 CIJST# FUND* p7,839.ao 63600-1060101-15200-630903 TOTAL NON-GOVERNMENTAL IMAGING DEVELOPMENT APPROPRIATION $15,,622.32 $21,497.413 $17,535.48 $76,455.00 TOTAL COUNTY DEVELOPMENT CHARGES $1905.48104 $1,777,894.05 $1,762,816-98 11,709,680.29 $7,156,072.37 $1,697,50 NON-COUNTY AGENCIES 63600-1060101-152000-635017 Nun-County AgencieS $1,23a,00 $3,943.30 $1,719.00 5e5soze TOTAL DEVELOPMENT CHARGES $1,908,178.64 $1.779,124.05 $1,766,7150.29 $1,711,399.29 $7,155,462.17 Prepared by. Information Technology. iioi7t.P2005 HOC IReptirr4t Quarter 2009 cis Resolution #09262 November 12, 2009 Moved by Middleton supported by Gershenson the resolutions (with fiscal notes attached) on the amended Consent Agenda be adopted (with accompanying reports being accepted). AYES: Cabello, Coulter, Douglas, Gershenson, Gingeil, Gosselin, Greimel, Hatchett. Jackson, Jacobsen, Long, McGillivray, Middleton, Nash, Potter, Potts, Runestad, Schwartz, Scott, Taub, Woodward. Zack, Bullard, Burns. (24) 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 APPROVJ,THE FOREGOING RESOLUTION J STATE OF MICHIGAN) COUNTY OF OAKLAND) I, Ruth Johnson, 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 12, 2009, 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 12th day of November, 2009. eat Ruth Johnson, County Clerk