Loading...
HomeMy WebLinkAboutResolutions - 2008.11.20 - 9588as a single then an amount department with has determined MISCELLANEOUS RESOLUTION #08244. BY: GENERAL GOVERNMENT- COMMITTEE., CHRIS7INE LONG, CHA/RPERSON November 6, 2008 IN RE; DEPARTMENT OF INFORMATION TECHNOLOGY FOURTH QUARTER 2008 DEVELOPMENT APPROPRIATION TRANSFER TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS Chairperson, Ladies and Gentlemen: WHEREAS all development cost is incorporated appropriatiOn within the non-departmental budget, and equal to the actual expense is transferred to the user a summary report to the Yinance Committee; and WHEREAS the Department of Znformation Technology the Fourth Quarter 2008 development charges to be $1,518,8$3.37 and the imaging development charge to be $15,676,52 for the General Fund/General Purpose County departments; and WHEREAS direct charges to Special Revenue and Proprietary fund departments are $701,952.39, non-governmental imaging development are $10,353.60, and non-county agencies are $1,533.00 for the Fourth Quarter 2008; and WHEREAS an appropri.atzion 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 2008 Development Report and approves the Fourth Quarter appropriation transfer as specified on the attached schedule. Chairperson, on behalf of the General Government Committee, I move the adopt -lon of the foregoing resoution. GENERAL GOVERNMENT COMMITTEE GENERAL GOVERNMENT COMMITTEE VOTE: Motion carried unanimously on a roll call vote with Gingen, Clark and Gregory absent. DIVIStON ACCOUNT # GUST # FU!-113# INFORMAPON TECHNOLOGY DEVELOPMENT SUMMARY 4TH QUARTER 2008 1st Ott Oct - Dec 2nd Qtr 3rd Qtr 41h Qtr Jan - Mar Apr June July - GOVERNMENTAL FUNDS General•Fund1101j 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 620 101 10100-1010201-181010-773630 005 101 10100-5010101-180010-773530 725 101 10100-2010201-180000-773630 440 101 10100-2010301-185010-773630 410 101 10100-2010501-125000-773630 724 101 10100-2010210-125000-773630 120 101 10100-2010401-172190-773630 123 101 10100-2010205-132300-773630 7 85 101 19100 -1090101-171300-7736:30 522 101 1 010010704011 13000-7735'30 430 131 101001010501-151023-173630 195 101 10100-3010201-121110-773630 506 101 10100-3013401-121220-7/ 3630 483 101 10100-3010403-121100-773630 420 101 10100-3010301-121220-773630 498 101 10100-3010301-121130-773630 . 493 101 10100-3010101-121100-773630 015 101 10100-1010101-161000-773639 730 101 10100-0010101-1550107(3630 903 101 10100-1010115-115090-773630 /10 101 13100-1020501-173010-773630 663 101 10100-1020601-18202U-173630 680 101 10100-1050401-183010-773630 90? 101 101005010303-165340-773630 877 101 13103-1070601-132030-T73530 710 101 10100-1070501-174000-7(3530 003 101 67800-9011502-183190-773630 775 101 10100-1090201-171000-773630 513 101 10100-3040403-124010-773630 181 101 10/00-3010101-121060-773630 145 101 10100-4010101-122050-773630 637 101 10100-1030803-184020-773630 650 101 10100-1020701-126020-773630 663 101 10100-9010101-140354-773630 195 101 10100-4030301-112590-773630 191 101 10100-4030601 -110000-773630 445 101 10100-1030803-184025-773630 500 101 10100-7010101-186040-773630 52/1 - District Court 5212 - District Court 52/3 - District Court 52/4 - District Court Animal Control Auditing Board of Commissioners Clerk - Adm in Clerk - Elections Clerk - Jury Commission Clerk - Legal Records Clerk - Register of Deeds Clerk Vital Statistics Economic Developmei it & Community Anairs Community Corrections Admin Cot poratiun Counsel Courts-Business Division Courts-FD-Judiciat Support Courls-FO-Judiciat Supporl-Acimin Courts-GJ-Family Support Courts-GJ Judicial Support Courts - Judical I. Administration County Executive Drain Commissioner Emergency Response 3 Prep Equali7ration Division Fiscal Services - Admin Human Resources Library Acimi• • Medical Examiner MSU Extension - Oakland QC Retirees As-sociat1ort 1s1 & 2nd Qtr Planning & Economic Development Probate-Estates/Mental Health Support Probate-FD-Judicial Prosecuting Attorney - General Prosecution Records Retention Reimbursement Division Security Camera Project (GE) 3rd Oft Sheriff SherlIt - CLEMIS Support Services Treasurer Sub-Total Fund 101 $11,757 17 $11,75/.17 $11,757.17 $11,757.11 $51,552.11 $0.00 $0.00 55,470.00 $5,455.00 $2,690.79 $119,711 1/ $286641 $0.00 $3,182.00 $14,302.40 $427.31) $3,031.27 $368.00 $9,748.61 $5,811.00 537.231.50 $122.00 $91.50 $11,127.36 52,569 50 $126,679.06 $245.135.60 $58,135.95 $0.00 $12,152.61 $30.50 $0.00 $1,464.00 $8,087.61 $0.00 $14,446.11 $5.152,25 $9,851.40 $0.00 $75,527.39 $3,910./9 $13,551.51 $175,192.63 $1,132,124.59 $9,531.66 $9,239.44 $8,116.57 $38,646.84 $9,531.66 $9,239.44 $8,118.57 $38,646.84 $9,531.66 $9,239.44 $8,118.57 $38,646,84 $9,531.64 $9,230.43 88,118.51 $38,646.72 $61,825.60 $69,220.75 $35,439.70 $268,048.16 $793.00 $510.00 $2,169.40 $3,562.40 8122.00 $356,00 $0.00 $488.00 • $0.00 $3,246,00 $9,227.00 $11,943.00 $7,646.00 $7,369.00 $6,628.00 $27,59800 $3,588.97 84,501.12 $3,161.52 814,042.40 $117,216.65 $113,899.00 $150,746.95 $501,573.9? 86,448.50 $4 .681.70 $414996 518,144 56 $0.00 $40,835.00 $9,140.00 $49,776.00 $488.00 83,019.50 53,175.50 59,865.00 $55/125.82 $65,544.62 $27032 97 $163,358,81 $610.00 $244,00 $122.00 $1,403.00 $6.582 11 $6,110.32 $4,891.51 $20,615.21 $7,999.00 $0.00 $3,538.00 $11,693.00 $9.306.10 $14,982.50 $12,16195 $46,198.16 $3.693.00 $17,178.50 $7,057.50 $33,740.00 $69,467.75 $72,965.00 556,552.00 $238,219.25 $48.80 $1,16220 $2,538.40 $3,921.40 5305 00 $305.00 $0.00 $701.50 $122,474.40 5171,671 25 5105,346,20 $473,621.21 $2,895.00 82,650 00 5862.00 $9,166.50 $103,668.08 $139,135.29 $142,413.09 $511,895.52 $126,481.82 $110,816.95 $107.591 .16 $590,027.53 $44,251.33 $44,012.37 $38,570.29 $184,969.94 $732.00 $0.00 82.192.00 $2,924.00 $15,246.35 $16,041.00 $16,638.45 $60,078.41 $30.50 $244.00 $30.50 $335.50 $0.00 $0.00 $0.00 $0.00 $1,830.00 $3,050.00 $1,464.00 $7,808.00 817,336.10 $23,727.50 $8,537.95 $57,689.16 $95.00 80.00 80.00 $95.00 $27,607 10 533,008.00 $35,714.45 $110,775,66 $16,466,25 525,684.50 82.379.00 549,897.00 $20,717.00 $3668500 539,733.40 5106,986.83 $0.00 $8,069.50 $1,988.50 $10,058.00 $94,970.13 $34,431.07 $103,170.26 $338,104.85 $4,625.97 $4,723.12 $4,503.52 $17,763.40 $13,130.68 517,742.11 511,522.41 $55,946.71 5142,241.39 $152,097.43 $167,588 29 $637719.74 $1,145,480.22 $1.317,590.05 $1,213,539.07 $4,808,733.93 Prepared by: Information Techrology; 10/16,2008 Page 1 01 3 4th Otr 2008 y CUS1 # FUND ACCOUNT 1# DIVISION 1s1 Otr Oct - Dec 2nd Grr Jan Mar 3rd Qtr 41h Qtr pr-June ,Igly Y.T.D. Health F und.(221.1 840 221 20221-1060201-133155-773630 943 221 20221-1060220-134390-773530 $35,481.90 $228.82039 $264,30228 $14,690.70 $297,926.60 $312,617.30 Hea1111 $29,021.30 Health Environmental E242,46T.21 Sub-Total Fund 221 $271,488.51 $32,034.50 $111,228.40 E53,917.80 11.038,131.99 $300,952.30 $1,149,360.39 Juvenile Meintenanca Fund T293 6'65 293 20293-1060501-112090-773630 Children's Village Sub-Total Fund 293 $427.00 $366.00 $4.3s2 $5612.00 $366.00 $4,392.00 $5,812.00 S427.03 $427.00 $427.00 $8742 79 12.14.00 $3.735.37 $7.965.72 $97.60 $224.2 $10,499.72 15 176.80 $30,93.60 11,042.80 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 4TH QUARTER 2006 DEVELOPMENT FOR GOVERNMENTAL FUND $j.404,040.10 11410 209.50 $1,630,573.35 $1.518,883.37 15.963,706.32 APPROPRIATION 63600-1080101-152000-631365 GOVERNMENTAL IMAGING 727 101 10100.2010210-125000473539 512 101 10100-3040403-124010-773639 63600 1030101-152000-039903 10100-9090101-196030-773630 Clerk Image Probate-F.states/Mental Health Image S LOB-TOTA L GOVERNMENTAL I IMAGING DEVELOPMENT APPROPRIATION: Information lechnotogy Developmeiri TOTAL GOVERNMENT: $3,832.97 $10.290.12 $15676.52 $38,786.40 $1,413,026.89 $1,414,042.47 S1,640,863.47 $1,534,559.89 $6,002,492.72 ($1,413,026.89} f$1,414,042.471 (51,640,863.4M j4,559._6a1 1.16 4)2 492.72) $0.00, $0.011 so.og $0.00 $0.00 TOTAL GOVERNMENTAL IMAGING $8,966.79 DEVELOPMENT APPROPRIATION Prepared by; 1q1erroatien technology; 10116/2008 Page 2 of '3 4Th Otr 2008.4s GUST # FUND # ACCOUNT # DIVISION 1st Olr Oct - Dec 2nd Qtr Jan - Mar 3rd Car Apr - June 4th Ott July - Sept Y.T.D. 659 355 056 306 659 .507 210 760 757 150 803 751 053 0D3 187 770 791 695 563 501 545 656 63600- 080101-152.000.631302 NON-GOVERNMENTAL IMAGING 171 63600-1080101-15200-630303 tNFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 4TI i QUARTER 2008 NON-GOVERNMENTAL DIRECT CHARGES CAIVISIGV1 Data Conversion $0.00 • $0.00 59,549.25 $62,999.00 $72.548.25 CLENIIS $53,370.87 $57,059.48 $90,474.83 $72.595.20 8273,500.38 CLEMIS FUND 63500 $504.00 $990.00 $755,50 $976.00 $3,225.50 CLEMIS 2005 ISIS Grant $360.00 ($365.00) $0.00 $0.00 $0:00 Collaborative Asset Mgt Sys (CAMS) $0.00 $6,860.00 $37,273.25 $29,494.75 $73,628 00 Courts-FOC Exp-CS Enforcement $13,509.00 $37,728.00 $35,349.00 $26,174.00 $112,751.00 Fire Records Management System $2.517.11 $2,585.60 $3,514.50 $1.953.95 $10,671.16 FM-90C Weticasting $17,826.00 $2,548.04 $854.00 $122.00 $21,35000 FM-Vtili Rol/Jail MgiAfitieo Cont $29,242.79 $7,147.97 $12,051.12 $8,659.52 $57,061 40 1: MS 0 55,434.86 $6,912.80 89,636 50 $3,123.95 $5,107.91 Healih - Bioterrorism Unil $0.00 $4,592.50 $11,956.50 85,576.00 $22,121i.50 IT - Telephone Comm 50 00 80.00 $0.00 $122.00 $122.00 0..C. Internationat Airooit $47700 8244.00 $113.50 $854.00 $1,698.50 01".: Retirees Association 3rd Qtr $0.00 $5,572.60 $3.526.00 $0.00 $9,193.60 (..)CS•D • Jail Visitation Project $0.00 $0.00 $6C,567:50 .$13,047.50 $73,615.00 Parks and Recreation - Administration $2,714.50 86,233.00 $10,113.00 $7,243.50 . $26,354.00 Radio Communications E911 $2,312.00 $4,698.25. $548,75 $889.25 $8,438.25 Risk Management $122.00 $0.00 $0.00 $0.00 $122.00 Security Camera Project (GF) 1st & 2n0 Oh- $3,348.00 $12,815.50 $0.00 $0.00 $21,163.50 Treasurer - DTRF $173,003.90 $296,821.55 $421,334.45 $437,736.75 $1,333,896.75 IJASI Grant (ERF) $110.00 $3,628.50 $728.00 $592.00 $5,058.50 Water & Seer Acciarinting 512 326.79 RW98.72 $41.321.37 $29 /83.02 $.104 609.90 SUB-TOTAL DIRECT CHARGFS FOR DEVELOPMENT f327 134.8;, i477,510.37 $749,648.02 $701,952.39 2,256,245,60 Courts-FOC Exp-CS Enforcement Image TOTAL NON-GOVERNMENTAL IMAGING DEVELOPMENT APPROPRIATION L488.09 a95.20 $1648.80 $1003 60 $15,685.60 $488,00 $195,20 $4,648-80 $10.353.60 $15,685.60 TOTAL COUNTY DEVELOPMENT CHARGES $1,740,649,71 $1,891,748.04 $2,395,16.29 $2,246,865.88 $8,274,423.92 NON-COUNTY AGENCIES 63600-1080101-152000-635017 Non-County Agencies TOTAL DEVELOPMENT CHARGES $518.50 366.00 E3_,885.00 $1,533.00 $6,302.50 $1,741,168.21 $1,892,114.04 $2,399.045.29 $2,248,398.88 $8,280,726.42 Preored by; Ififormation Techncrogy; 1011012008 P0rje Oa 4tfi Qtr 21305 xis INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - FOURTH QUARTER, 2008 cust # GOVERNMENTAL FUNDS 630 ANIMAL CONTROL 24017 SQL Sorver Supp - Animal Control $1,953.95 95620 Web License /Registration 64,204.25 95682 Dog System 19,201.5Q Animal Control-Total 620 AUDITING 95458 Auditing - Customer Support $2 159.40 Auditing - total 005 BOARD OF COMMISSIONERS 91404 BOC - Customer Support $SLIZIO BOC - Total 665 CHILDRENS VILLAGE 05065 Childrens Vitiarge $4 392 00 Chili-liens 'Village Total i'25 CLERK - ADMIN 72500 Clerk - Adrnh 3,227.,00 Clerk - Adinn - Total 440 CLERK -ELECTIONS 95443 Elections $6.528.00 Clerk - Elections - Total 720 CLERK/REGISTER OF DEEDS 20004 IDIV1S Support - Register of Deeds $488.00 24003 SQL Server Suop - ROD 3.5% 1,953.95 35510 GIS implemoritatIon Support-ROD 0.00 36511 ROD Application -1--i/W Support 0.00 95493 Reg Deeds System Maintenance 0.00 95162 Clerk OW Support 510.00 95153 Clerk - DW Maintenance 1,098.00 95558 User Support/ROD 0.00 95554 ROD - DW Support Q.00 CleskiReg of Deeds - Total 722 CLERK - IMAGING 13001 Cle,c- eFiling - 50% $0.00 23007 Oracle Support - Clerk Image 5.2% 2,734.52 65420 Clerk - Image Replace 0.00 95158 Clerk - Imaging 7,765.20 Clerk - Imaging - Total 410 CLERK - JURY COMMISSION 23008 Oracle Support - Jury Comm 5.2% $2,734.52 95512 Jury Commission 427.00 Clerk - Jury Commission - Total $85,439.70 S2,159.40 $0.00 $4,392.00 $9,227.00 $5,628.00 $4,149,95 $10,499.72 $3,161.52 Prepaled by Information TolOwscriogy, 19f1&2005 raw'? al /0 4th CM 2006 .n Is INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - FOURTH QUARTER, 2008 724 CLERK - LEGAL RECORDS 24015 SQL Server Supp - Circuit CI 3.5% $1,95395 95189 Circuit Court System 148 793 00 Clerk - Legal Records - Total 723 CLERK - VITAL STATITICS 95161 Clerk - Vital Statistics 9,140.00 Clerk - \AIM Statistics - Total 522 COMMUNITY CORRECTIONS-ADMIN (CO) 23003 Oracle Support-Comm Corr - 5.2% $2,734.52 24012 SQL Server Supp - Community Corr 3,5% 1,953.95 52200 Comm Corr-Admin (County) 20,30950 52201 Comm Corr-DW Supp Community Corrections - Total 795 ECONOMIC DEVELOPMENT & COMMUNITY AFFAIRS 36500 GIS Implemontation Support C&E Dev $2,959.50 36501 CED Application - HAN Support 216.00 95785 Comni& Eco Developml gA0 Economic Development & Community Affairs - Total 430 CORPORATION COUNSEL 95501 Corporation Counsel -$12g,0Q Corporation Counsel - Total 015 COUNTY EXECUTIVE 95656 County Exeuutive Support. County Executive • Total 495 CTS-SUSINESS DIVISION 12002 Oil CI-CourisiCriminal Warehouse 50% $0.00 14001 CTS-DW Support/Circuit Ct - 75% 3,38f .00 15001 CTS-OW MaintiCircuit CI - 75% 137,25 23010 Oracle SLIpporl-CCT/CTS Grim Whse 2.6% 1,357.26 CTS-Business Division - Total 506 CTS-FD-JUDICIAL SUPPORT 95187 CTS-FD/Admrn - Earn Suppt Staff 53, 5 38 . 0 CTS-FD-Judicial &port -• Total 483 CTS-FD-JUDICIAL SUPPORT-ADM 24009 SQL SDI'S, Supp CTS-Jud Sup Mm - 3.5% $1,953.95 95193 CTS-FD-Judicial Support-Mm 10„207.00 CTS-FD-Judicial Support-Mm - Total 420 CTS GJ FAM1L'Y SUPPORT 95195 Cir Crl AdmFri $7.057.50 Courts - GJ - Family Support - Total $150,746.95 $9,140.00 $27,082.97 $3,175.50 $122.00 $0.00 $4,891.51 $3,538.00 $12,160.95 $7,057.50 Pogo 2 or is 4th air 2008,xls Prep:Ired Infommtion Technology. 1011V2308 $56,552.00 $0.00 2,585.40 $56,552.00 $2,588.40 5103,348.20 $852.00 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2008 498 CTS-GEN JURISIUDICIAL SUPPT 95179 CTS-Gen Juris-Judicial Suppt CTS-Gen Juris-Judicial Suppt - Total 13002 CTS-eFiling - 50% 95174 CTS-Judicial Admin CTS-Judiciat Admin - Totai 493 CTS-JUDICIAL ADMIN 730 DRAIN COMMISSIONER 24008 SQL Server Supp - Drain 3.5% • $1,953.95 28007 Drain Commissioner 324.00 28010 Drain - Customer Support 13,056.50 28011 Drain Commlssioner Appiication 41,151.50 36520 GIS implementation Support Drain 12,817.00 • 36521 OCDC Application - I VW Support 38,985.25 95569 Water 8 Sewnr Amounting 0.00 Drain Commissioner - Total 900 EMERGENCY RESPONSE & PREPAREDNESS $488.00 364.00 .09 36545 GIS Implementation Support EMS 36546 ERR Application - HAN Support 98990 Emergency Response ERP - Total 740 EQUALIZATION 20001 !MIS Support Equali7ation - 40% $976.00 23012 Oracle Support•Equalization - 5.2% 2,734.52 24005 SO! Servw Supp.E.qualization - 10.5% 5,861,84 31075 Equal - Dr.rveloptriont 8,413,50 36505 GIS Impleinentation Support Equalization 2,870.50 36506 Equal Application •• HNV Support 8.581.00 36507 Equal LAMS SupportiMtce 0.00 36601 Land System Enha.ncernents - Equal (50%) 1,217.50 36701 Land System Maintenance - Equal (50%) 4,97300 36801 Land System Support - Equal (50%) 34,007_23 95559 User SupportiEquai 0.00 95562 Equatization - OW Support 1,419.00 95570 Equalization - DW Maintenance 0.00 95693 Equal-System n Maintenance 1,464.00 96699 ES&A Master Appraisal Sup/Maint 69 595.00 Equalization - Total $142,413.09 Prepared by- totormatioli TechnoLogy; 10,(1C42008 Rego 3 of 10 4th Qtr 2008,xls 660 FISCAL sEgyreEs ADMIN 840 HEALTH DIVISION 943 HEALTF-F - ENVIRONMENTAL 680 HUMAN RESOURCES INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2006 23001 Oracle Support - Fiscal Serv - 15.6% $8,203.57 23013 Oracle Support - HR-AccigAgudget - 52% 2,734.52 24006 SQL Serv Supp - HR-Accig - 1.75% 975.97 44021 FS-System/Customer Support 23,507.00 44022 FS-System Maintenance 3,736.00 44023 FS-System Enhancements 11,456,90 44024 FS-New Development 0.00 44076 BUD-System/Customer Support 3,660.00 44077 BUD-System Maintenance 0.00 44079 ES - DVV Support 3,202.00 44081 FS - DW Maintenance 0.00 96001 Human Res - Accl 40% 33.342.60 96003 Human Res - Budgr.at 20% 16 671.4Q Services Admin - Total 20002 tOMS Support - CHAMPS - 20% $488.00 36525 G)S Implementation Support Health 0.00 37025 CHAMPS - P.O.P.1,728,00 95563 User Suppoti-Health 19,228.00 96842 • Health Admin 10 520.50 Health - Total 23005 Oracle Support - EH Projects - 52% $2,734 52 24014 SQL Server Suppl Eneallin 14% 7815,79 37002 Erivit onmental 0.00 84200 EH - Projects 233,774.50 84300 Ehealth Program 24 593.00 Health-Environmental - Totar 23014 Oracle Support-IIR/Personnel - 5..2% $2,734.52 24007 SQL Server Suppport-HR/Personnel - 1.75% 976.97 44041 PER-SystemiCustomer Support 1,300.00 44042 HR-Systems Maintenance 216.00 44044 HR-New Development 0.00 95556 HR User Supt 0.00 96002 Human Res-Personnel 40% 33,342.80 human Resources - Total $107,591.16 $32,034.50 S268,917.80 $38,570.29 Prepared by: rnformution TechnoPogy; 10/10/2008 Page 4 of 11) 4th Ott 2008.xfs 907 LIBRARY - LIBRARY ADMIN 872 MEDICAL EXAMINER 710 MSU EXTENSION - OAKLANI? 770 PLANNING & ECONOMIC DEVELOPMENT 481 PROB-FD JUDICIAL 512 PROB-ESTATES/MENTL HLTH IMAGE 510 PROB-ESTATES/MENTL MTH SUPPORT ?'10 PROSECUTOR - GENERAL PROSECUTION 637 RECORDS RETENT/ON INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - FOURTH QUARTER, 2008 91405 Library Board $2 192.00 Library - Library Adrnin - Total $2,192.00 24002 SQl, Server Support - Medical Exam - 3,5% $1,953.95 87202 Medical Examiner - Customer Support 14,684.50 Medical Examiner - Total $16,638.45 95676 IVISU Ext Equipment Maintenance $30.50 NISU Extension - Oakland Total $30.50 95786 REDS - DVV Support $854.00 95787 REDS - DVV Maintenance 610.00 PEDS - Total 96168 PC-Judicial Adm - Family Judges K3.00 Prob-FD Judicial - Total 95207 Prob-Est/Mntl Hithi Image $5,176.80 Prob-Est/Mntl Filth Image - Total 24010 SQL Serv Supp-PCT-EsUMental - 3.5% $1,953.95 92198 Prob-Est/Mnd Hlth Support 6 584.00 Prob-Est/IVInti Hlth Support - Total 24016 SQL Server Stipp - Proeseutors 3.5% $1,953.95 95622 Prosecutor/Executive 24,155.50 97001 Prosecutor Data Roc 9,605.00 Prosecutor - Total 44052 Rec-Systorn Maintenance $0.00 44053 • Rec-System Enhancements 0.00 • 44054 Rec-New Development 2379.00 95636 Mail Room 0.00. • Records Retention - Total $1,464.00 $0.00 $5,176.80 $8,537.95 $35,714..45 $2,379.00 Page 5 of 10 4th QV 2,203.x% Prepot or/ by: I Wor motion Tectuiology; 10I1 1€42008 650 REIMBURSEMENT 663 SECURITY CAMERA PROJECT IGF) 195 SHERIFF 191 SHERIFF - CLEMIS 445 SUPPORT SERVICES 510 TREASURER INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - FOURTH QUARTER, 2008 95469 Reimbursement DiViSiOn $0.00 95470 Reimbursement System 23,285.413 95542 Reimburse User Support 16 448.00 Reimbursement - Total 66300 Security Camera Project (GF) $1,985 50 Security Camera Project (GF) - Total 12001 OCSD-Courts/Crinninal Warehouse $0.00 23009 Oracle Support - OCSD1CTS Crim VVhse - 2.5% 1,367,26 97163 Sheriff 78,130,00 97165 Sheriff.DW Support 23,313,00 97156 Sheriff DIN Maintenance 366.00 Sheriff - Total 23015 Dade Suppport - Shei iff / CLEMIS - 5.2% $2,734.52 96153 SheriIf • CLEWS 1 769.00 She' ift - CLEivIIS -1 otal 23002 Oracle Support -• Supp Sen/ - 5.2% $2,734.52 24011 SQL Server Supp - Suppt Services 7% 3,907.89 44500 Support Services 4,680.00 Support Semces • Total 23006 Oracle Support - Del Tax- 5.2% $2,734 52 23016 Oracle. Support - Treasurer - 10.4% 5,459.05 36515 GIS Implementation Support-i reasurer 0.0D 36516 1 reasixer Application'- HNV Support 12,135.00 36602 Land System Enhancements - Trees (50%) 1,217.50 36702 Land System Maintenance - Treas (50%) 4,973.00 36802 Land System Suppoit Trees (50%) 34,007.22 4406/ Tre-System/Customer Support 4,725.50 44062 Tre-System riAainlenance 2,951.50 44063 re-System Enhancements 0.00 44064 Tre-New Development 0.00 44060 Tre-OW Support 7,679 50 440132 Tre-DW Maintenance 1,340.00 95006 Del Tax On Line 2,315.00 95303 Del Tax System Maintenance 4,790.00 95561 User Support/Del Tax 17,966.50 95615 BS&A Annual Tax Support 65,281.00 Treasurer - Total $39,733.40 $1,988.50 $103,176.26 $4,503.52 $11,522.41 $157,568.29 Prepw•ed by !n(oimnttoc Technatogy, ea2O53 Page ot 10 4th Qtr 2008.xls INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL FOURTH QUARTER, 2008 540 5211 DISTRICT COURT NOVI 550 52/2 DISTRICT COURT - CLARKSTON 560 52/3 DISTRICT COURT - ROCHESTER 530 5214 DISTRICT COURT - TROY 14002 CTS-DW Support-5211 - 6.25% 15002 CTS-OW Maint 52/1 - 6.25% 95527 DC Suprt- 52/1 - 25% 52/1 District Court - Total 14003 CTS-DW Support-52/2 - 6.25% 15003 CTS-DW Nlaint 52/2 - 6.25% 95526 DC Suprl- 5212 - 25% 52/2 Dis1rict Count - Total 14004 CIS- DW S upport-52i3 - 6.25% 15004 CTS-DW Maiot 5213 - 6.25% 95529 DC Supg - 52/3 - 25% 5213 illistrk.:t Court - Tutal 14005 CTS-DW Support-5214 - 6.25% 15005 CTS-DW Maint 52/4 - 6.25% 95530 DC Sup/1- 52/4 - 25% 52/4 District Court - Total $282.25 11.44 7 824.88 $282.25 11.44 7B24.88 $282.25 11,44 7 824,88 $282.25 11.43 L$24.86 $8,116.57 $8,118.57 $8,118.57 $8,118.54 PrepaTvd IIainuznTocluva1ogy, 10qi5+200,13 page o1 10 tth 01( 2008.xls 20003 IDMS Support 5.6% 23018 Oracle Support - Sherin CLEMIS 5.2% 24004 SQL Server Support - 24.5% 90507 CAD Customer Support 95409 CRISNET/CLEMIS LRM 95430 CI EMIS Maintenance 95431 CLEWS Enhaficements 95432 CLCMIS Adhoc Reports 98003 CL [MIS User Support CLEWS - Total 53500 Ct EMIS Fund 2976.00 CL DO'S 63500 Fund - otal 63596 2005 Federal Approp IBIS Protect CLEMIS 2005 IBIS Grant - Total $488.00 2,734.58 13,677.62 0.00 244.00 25,751.00 000 0.00 29 700 00 572,595.20 $976.00 $0.00 66901 CAMS/CVT Data Conversion $62,999.00 CAMSICVT Data Conversion - Total $62,999.00 65901 Collaborlive Asset Mgt Sys $_29_,494.75 Collabortive Asset Mg' Sys - Total $29,494.75 92194 CTS-FOC Exp-CS En-Image $1_053.60 CIS-FOC Exp-CS Ent-Image - Total $10,353.60 92193 CTS-FOC Exp-CD Entorc-Dev $261,174.00 CTS-FOC Exp-CD Enforc-Dev - Total $26,174.00 21010 Fite Records Mgmt Fund 531 $0.00 24001 SQL Server Support - FRMS 3.5% 1 953.95 His Records Management. System - Total $1,953.95 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2008 Oust # DIRECT FUNDS 055 CLEWS 050 CLEMIS FUND 63500 096 CLEMIS 2005 IBIS GRANT 659 CAMS/CVT DATA CONVERSION 659 COLLABORATIVE ASSET MGT SYS 471 CTS-FOC-EXP-CS ENFORC-IMAGE 507 CTS-FOC EXP-CS ENFORCEMENT 210 FIRE RECORDS MANAGEMENT SYSTEM 750 FM&O 21001 FM&O $0.00 24013 SQL Server Supp - FM&O 1,953,95 75503 FM8,0 Development 1,170.00 FM8:0 - Total $3,123.95 Page 13. of 10 4th ()ft' 2008.xls hrepated Dy: Intatmatiou Technofogy; 10;16,2008 $122.00 $8,669.52 $5,576.00 $122.00 760 FM --BOC WEBCASTING 757 FM-WK RELEASE/JAIL MGMTNIDEO CONF 803 HEALTH-BIOTERRORISM UNIT 751 IT - TELEPHONE COMM 053 0.0 • INTERNATIONAL AIRPORT $0,00 0.00 $0.00 44036 RSK-SystemiCustorner Support 95595 Risk Management Risk Management - Total 695 RISK MANAGEMENT INFORMATION TECFINOLOGY - RESERVE FUND DEVELOPMENT SUPPORT DETAIL - FOURTH QUARTER, 2008 76000 FM - Ei0C Wehcasting 1122.00 FM - BOC Webeasting - Total 003 OC RETIREES ASSOCIATION 187 OCSD - JAIL VISITATION PROJECT 770 PARKS AND RECREATION 791 RADIO COMMUNICATION - E911 23004 Oracle Support - Oak Video - 5,2% $2,734.52 75700 Fac Mgmt - Video Arraignments 5 935.00 FM-Wk Rel/Jail MgmtAiideo Conf - Total 80130 Health - Bioterrorism Unit $5,676.00 Health - Bioterrorisrn Unit Total 75102 Tel Comm - Customer Support $122.00 LT.. Telephone Comm - Total 30540 GIS Implementation Support-Aviation $0.00 6530/ Airport User Support 854.00 0.C. International Air por1-1 otal $1354.00 98872 OC Retirees Assoc $0.00 OC Retirees Assoc - Total $0,00 97137 OCSD Jail Visitation Project $13,047.5Q OCSD • Jail Visitation Project - Total $13,047.50 35530 GIS Implementation Support - Parks $135.00 44066 PRADM SyslernrfCustomor Support 429.00 77010 PRAM- Technology Assessment 6 679.50 Parks & Recreation - Total $7,243.50 79101 Radio Communications - E91 1 $889.25 Radio Communications - E911 - Total $889.25 601 TREASURER - DTRF 19010 Treasurer's Office System $359,019.25 19050 Drain Apportionment 45,404,00 18060 Michigan Business Fax 33 313.50 Treasurer DTRF - Total $437,736.75 Prepared by: Information ittohnology; 10+16+2008 Pnge 9 of 10 4th Qb 2008.x1s 12546 LSAT Grant (ERID) $92.0O UASI Grant (ERP) - Total $592.00 23011 Oracle Supp - Water & SeVVe4 Accrg - 5.2% 95669 Water & Sewer Accrg Water & Sewer Accrg - Total 546 LIAM GRANT (ERR} 656 WATER & SEWER ACCTG $2,734.52 27,048.5Q $29,783.02 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT 1 SUPPORT DETAIL - FOURTH QUARTER, 2008 r'repared by Information ThchruoIoy. ta1/6120 113 Rope 11 of 10 4O's Qtr 2,308 xIS Resolution #08244 November 61 2008 The Chairperson referred the resolution to the Finance Committee. There were no objections. FISCAL NOTE (MISC. #08244) November 20, 2008 BY: FINANCE COMMITTEE, MIKE ROGERS, CHAIRPERSON JNI RE: DEPARTMENT OF INFORMATION TECHNOLOGY — FOURTH QUARTER 2908 DEVELOPMENT APPROPRIATION TRANSFER TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS Chairperson, Ladies and Gentlemen: Pursuant to Rule Xli-C of this Board, the Finance Committee has reviewed the above- referenced resolution and finds: 1. The resolution appropriates and charges the Information Technology Fourth Quarter 2008 Development cost to benefiting departments, 2. The fourth quarter development charges are $1,518.883.37; imaging development charges are $15,676.52 for General Fund/General Purpose departments; direct charges to Special Revenue and Proprietary fund departments are $701,952.39, non-governmental imaging development are $10,353,60, and charges to non-county agencies are $1,533.00. 3. The respective departmental Fiscal Year 2008 budgets are to be amended as specified in the attached detail schedule. FINANCE COMMITTEE FINANCE COMMITTEE Motion carried unanimously on a roll call vote with Kowa, Crawford, Potter and Rogers absent. I HEREBY APPROVE THE FOREGOING RESOLUTION of•"^— Resolution #08244 November 20, 2008 Moved by Potter supported by Nash the resolutions (with fiscal notes attached) on the Consent Agenda be adopted (with accompanying reports being accepted). AYES: Burns, Clark, Coleman, Coulter, Crawford, Douglas, Gershenson, Gingell, Gosselin, Gregory, Greimel, Hatchett, Jacobsen, KowaII, Long, Middleton, Nash, Potter, Potts, Scott. Spector, Zack. Bullard. (23) NAYS: None. (0) A sufficient majority having voted in favor, the resolutions (with fiscal notes attached) on the Consent Agenda were adopted (with accompanying reports being accepted). 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 oh November 20, 2008, 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 20th day of November, 2008. Ruth Johnson, County Clerk