Loading...
HomeMy WebLinkAboutResolutions - 2007.12.13 - 28387MISCELLANEOUS RESOLUTION #07269 November 29, 2007 BY: GENERAL GOVERNMENT COMMITTEE, CHRISTINE LONG, CHAIRPERSON IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FOURTH QUARTER 2007 DEVELOPMENT APPROPRIATION TRANSFER TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS Chairperson, Ladies and Gentlemen: WHEREAS all data processing 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 2007 data processing development charges to be $1,237,691.75 and the imaging development charge to be $17,015.36 for the General Fund/General Purpose County departments; and WHEREAS direct charges to Special Revenue and Proprietary fund departments are $216,323.80, non-governmental imaging development are $536.80, and non-county agencies are $1,748.00 for the Fourth Quarter 2007; 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 2007 Data Processing 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 adoption of the foregoing resolution. GENEL GOVERNMENT COMMITTEE r i L 1-: 0,1/4,1 \-L Ck - ( cilib GENERAL GOVERNMENT COMMITTEE VOTE: Motion carried on a roll call vote with Hatchett and Gregory absent. GOVERNMENTAL FUNDS General Fund 11011 10100-3020201-121020-773630 10100-3020205-113290-773630 10100-3020301-121020-773630 10100-3020305-113290-773630 10100-3020401-121020-773630 10100-3020405-113290-773630 10100-3020501-121020-773630 10100-3020505-113290-773630 10100-1070801-114000-773630 10100-1010201-181010-773630 10100-5010101-180010-773630 10100-2010201-160000-773630 10100-2010301-185010-773630 10100.2010501-125000-773630 10100-2010210-125000-773630 10100-2010401-172190-773630 10100-2010205-132300-773630 10100.1090101-171000-773630 10100-1070401-113000-773630 10100-1010501-161020-773030 10100-3010201-121110-773630 10100-3010401-121240-773630 10100-3010403-121230-773630 10100-3010402-121100-773630 10100-3010402-135080-773630 10100-3010401-121220-773630 10100-3010403-121100-773630 10100-3010301-121140-773630 10100-301 0301 -121220-773630 10100.3010301-121110-773630 10100-3010301-121130-773630 10100-3010301-121150-773630 10100-3010101-121100-773630 10100-1010101-181000-773630 10100-6010101-155010-773630 10100-1010115-115090-773630 10100-1020501-173010-773530 10100-1040101-140000-773630 101004020601-182020-773630 101004050401-183010-773630 10100-5010303-165040-773630 10100-1030850-184030-773630 10100-1070601-132030-773630 10100-1070501-174000-773630 10100-1090201-171000-773630 10100-3040101-121080-773630 10100-3040403-124010-773630 10100-3040101-121060-773630 10100-3040101-121070-773530 101004010101-122050-773630 10100-1020401-182090-773630 10100-1030803-184020-773530 10100-1020701-126020-773630 10100-4030301-112590-773530 10100-4030601-110000-773530 10100-1030803-184030-773530 10100-7010101-166040-773630 10100-1070301-132050-773630 540 101 541 101 550 101 551 101 560 101 561 101 530 101 531 101 630 101 620 101 005 101 725 101 440 101 410 101 724 101 720 101 723 101 785 101 522 101 430 101 495 101 474 101 404 101 487 101 492 101 506 101 483 101 499 101 420 101 496 101 498 101 500 101 493 101 015 101 730 101 900 101 740 101 755 101 660 101 680 101 907 101 641 101 672 101 710 101 775 101 509 101 510 101 481 101 479 101 145 101 690 101 637 101 650 101 195 101 191 101 445 101 600 101 910 101 SUB-TOTAL GOVE 10100-9090101-196030-773630 INFORMATION TECHNOLOGY DATA PROCESSING DEVELOPMENT SUMMARY ' 4TH QUARTER 2007 GUSTO FUND# ACCOUNTS 1s1 Qtr 2nd Qtr 3rd QV 4th Qtr DIVISION Oct - Dec len - Mar Apr - June July - Sept Y.T.D. 52/1 - Distnct Court 52/1 - District Court - Protration 52/2- District Court 52/2 - District Court - Probation 52/3- District Court 52/3 - District Court - Probation 52/4 - District Court 52/4- District Court - Probation Animal Control Auditing Board of Commissioners Clerk - Admin Clerk - Elections Clerk - Jury Commissioi Clerk - Legal Records Clerk - Register of Deeds Clerk - Vital Statistics Economic Development & Community Affairs Community Corrections Admin Corporation Counsel Courts-Business Division Courts-PO Juvenile Support Courts-FD Juvenile Referees Courts-PO-Court Services-Act mm Courts-FD-Court Services-Adoptions Courts-FD-Judicial Support Courts-TO-Judicial Supoort-A0t01n Courts-GJ-Assignment Courts-GJ-FamIly Support Courts-General Jurisdiction Courts-GJ-Judicial Support Courts-GJ-Mediation Courts - Judical / Administration County Executive Drain Commissioner Emergency Response & Prep Equalization Division Facilities Management Fiscal Services - Admin Human Resources Library Admin Matenals Management - Gen Fund Medical Examiner MSU Extension - Oaklan0 Planning & Economic Development Probate - Judicial Admin Probate-Estates/Mental health Support Probate-TO-Judicial Probate-FD-Judicial Support Prosecuting Attorney - General Prosecution Purchasing Records Retention Reimbursement Division Sheriff Sheriff - CLEM1S Support Se'vices Treasure' Veterans Services Sub-Total Fund 101 $6.971.45 $081525 $10,547.50 $6,443.60 $31,077.80 $0.00 $0 00 $0.00 $0.00 $0.00 $6,971.45 $6.815.25 $10,847.50 $6,443.60 $31,077.80 $0.00 $0.00 $0.00 $0.00 $00.00 $6,971.45 56.815.25 510.847.50 $6,443.50 $31,077.80 $0.00 $0.00 $0.00 $0.00 $0.00 $6,971.40 $6,815.25 $10,847.50 $6,443.57 $31,077.72 $0.00 $0.00 $0.00 $0.00 $0.00 $9.570.50 523.686 12 $36.849.50 $47,024.13 $117,130.25 5305 00 5122 00 $183.00 $183.00 $793.00 $732.00 $0.00 $366.00 $0.00 $1,098.130 $16,942.00 5801.00 $89.00 $0.00 $17,832.00 $42.941.00 $3,371.00 $10,100.00 $2.633.00 $59.045.00 55.691.13 $3.326.24 $4.432.41 $3,495.36 $16.855.14 $37,765.50 $47.642 12 $63,256.50 $80,939.13 $206623.25 $18.382.20 $21,764.12 ($5,847.10) $3,930.43 $38.229.65 $19.744 50 $000 $0.00 $0.00 $19.744.50 $40,617.25 $9,645.50 $2,959.50 $2,016.50 $55239.75 $48,829.53 559,555.86 $446,768.41 $13,577.49 5188.731.39 $8,468.00 $2,379.00 $3,459.00 $122.00 $14,428.00 $6,433.32 $10,9136.62 $5.759.20 $4,895.51 $28,074.95 $0.00 $0.00 $0.00 $0.00 $0.00 10 DO $0.00 50.00 $0.00 $0.00 SO 00 50.00 50.00 $0.00 $0.00 50.00 50.00 50.00 $0.00 $0.00 $0 .00 $732.00 $3,772.00 $44,339.00 $8,843.00 $3.929.28 $5.299.12 $6.846.50 $6.219.63 $21,294.53 $0.00 50.00 50.00 $0.00 $0,00 $3,416.00 $17.373.50 $5,781.00 $6,351.00 $32,921.50 $0.00 $000 $0.00 $0.00 $0.00 534.429 00 $33,567.00 $45.072.00 $50,042.50 $163.110.50 $8,534.20 $0.00 50.00 $0.00 58,534.20 $3.051.50 $24,40 $951.60 $134.20 $4,181.70 $0 00 $0.00 $0.00 $0.00 50.00 $63,107.50 $66,816.87 $25.198.50 $64.142.13 $219,265.00 $2,348.50 51,738.50 51.921.50 53,147.25 59,155.75 $123,347.50 $139.13924 5320.227.71 $168,899.64 $751,614.69 $0.00 $0.00 50.00 50.00 50.00 $275,808.37 $139.904.01 $173.521.46 $160,625.40 $749,919.24 5120.788.19 538.398.80 $48,960.42 $42,623.97 $250,771.38 s1.098.00 52,964 00 $651.00 $0.00 $4,713.00 $0.00 Woo s0.00 $0.00 $0.00 $27,271 07 528.032.52 519,774.75 $18,304.93 $93,383,07 $1,403.00 $0.00 $122.00 $30.50 $1,555.50 $1,891.00 $976.00 $244.00 $732.00 $3,843.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5,72328 $4.601.12 $8,881.50 $6,475.63 525.581.53 $0.00 $0.00 $1.897.00 $305.00 52,202.00 $0.00 $0.00 50.00 $0.00 50.00 $12.472.00 $16.260.12 $25,668.50 $21.711.13 576,111.75 $0.00 $0.00 $0.00 $0.00 50.00 $8,146.00 $8,418.00 $10.919.00 $7.793.75 $35276.75 $16256.00 $4.392.00 $5.2313.00 $11.384.40 537,270,40 $108,721.07 598,515.62 596,128.20 $80.713.90 $382,078.79 $9,473.60 $5,160.24 $4,737.41 $6,874.38 $25,245.61 $16.566.13 $16,299.48 $15,781.42 $12.215.61 $60,862.64 $103,251.63 $39,227.96 $98,420.71 $106.766.79 $347,667.09 $122.00 $0.00 $0.00 :11) $122,00 51233.452.70 $878,382.78 $1,131,481.60 5943,423.84 $4,166,740.92 Health Fund [2211 840 221 20221-1060201-133150-773530 843 221 20221-1060220-134390-773630 Health Health Environmental Sub-Total Fund 221 57.960 80 57,840.00 53,593.40 $207,785.38 5266.468 71 ;329,574.91 $305.746.1 a $274.308.7t $333,168.31 $18.487.30 537.881 50 $274.194.61 $1,1643,023.61 5292,681.91 61,205,905.11 Jtivende Maintenance Fund 12931 665 293 20293-1060501-112020-773630 63600.1080101-152000-631365 GOVERNMENTAL IMAGING 722 101 10100-2010210.125000-773539 512 101 10100-3040403-124010-773539 63600-1080101-152000-630903 Children's Village Sub-Total Fund 293 DATA PROCESSING DEVELOPMENT FOR GOVERNMENTAL FUND APPROPRIATION Clerk image Probate-Estates/Mental Health Image TOTAL GOVERNMENTAL IMAGING DEVELOPMENT APPROPRIATION $459.00 $6.137.20 $3,428.00 51.586.00 511.610,80 $459.00 $6,137.20 $3,428.60 $1,586.00 511.610 80 51,539,657.68 51.158,828.69 $1.468.078.51 51.237.691.75 55.404,258.83 1179,511 se $17,449.44 (581.998.79) $16,746.96 $131,709.49 $244.00 kiLso 573.20 5268.40 5634.40 $179,755.88 $17,498.24 1581.925.591 $17,015.36 5132,343 29 RNMENTAL / IMAGING DEVELOPMENT APPROPRIATION: 51,719,413.76 51,176,326.93 $1,386,152.92 $1,254.707.11 55,536,600.72 Information Technology Development L$1.719.413.711 151,176,326,931 M386,152,921 151.254,707.111 155,536,600.72) TOTAL GOVERNMENT: $0.00 t.).00 $0.00 $0.00 $0.00 Prepared by Information Technology 101312007 4111 Qtr 2007.xls DIVISION rut Otn 2nd OP 314 Se 4th GE Oct - Dec Jan - Mar Apr July - Sept Y.T.D. CUST# FUND* ACCOUNT # INFORMATION TECHNOLOGY DATA PROCESSING DEVELOPMENT SUMMARY 4TH QUARTER 2007 NON-GOVERNMENTAL DIRECT CHARGES 055 CLEM'S $68,405 79 553,493.00 $62,503.70 $57,420.57 5251823.06 056 CLEMIS FUND 53500 $0.00 $0.00 $1.342.00 $2,170.00 53.512 00 096 CLEMIS 2005 IBIS Grant $366.00 $2.928.00 $610.00 50.00 53.904.00 719 Clerk/ROD Automation Fund $0.00 5000 57.073.50 $0.00 $7.073.50 661 Community 8, Home improvement $671.00 $122.00 (glum) 5080 ($61.00) 470 Courts-FOC Exp-Family Counseling $0.00 $2.00 $0.00 $0.90 $0.00 507 Courts-FOC Cop-CS Enforcement $6,606.00 $6,143.00 $11,565.00 511,610.00 $35,924 00 210 Fire Records Management System $4.203.07 $2.326.62 $2.506.00 52,743.63 511,779.32 760 FM-BOC VVetrcastiny $0 .00 $0.00 $0.00 $14,127.00 $14,127.00 757 FM-Wk Rel/Jail MytiVigeo Conf $11,738.13 $3,697.24 $6,600.41 $25,850.35 $47,886.14 758 FM-Jail Mgmt Replacement $0.00 $0.00 WM $0.00 $0.00 750 F M & 0 $3,755.00 $4,030.12 $2,411.00 $3,156.88 £13.353.00 655 Gararge $3.714.00 $0.00 $0.00 $0.00 $3,714.00 809 Health - Bio (Flu Clinic Grant) $0.00 $0.00 £0.00 $0.00 $0.00 380 Health - Immunization Grant $000 $0.00 50.00 $0.00 $0.00 662 Major Department Support Project Fund $4.758.00 $17,790.03 $3,477.00 ($21,267.00) $4,758.00 870 Medical Care Facility $3.853 57 $0.00 $244.00 $1,150 00 55.247 57 248 Medical Care Facility - Pharmacy $0.00 $0.00 $0.00 £0.00 $0.00 653 D.C.International Airport $1.792 00 $732.00 51,676.00 $122.00 $4,322.00 770 Pedro and Recreation - Administration $366.00 $1,922.00 $1,262.00 $1,464.00 $5,014 00 790 Radio Communications $o oo $lop $0.00 50.00 $0 .00 791 Radio Communications E911 $0.00 $3.00 $0.00 $15.956.50 $15,956 50 695 Risk Management 50 00 5488.00 $149.00 $0.00 $637.00 663 Security Camera Project 1GF) 8000 $23,475.00 $26,687.50 $29,748.50 $79.911.00 601 Treasurer - DTRF $10.844.50 $157,460.00 $3.302.00 $45,874.00 $217,460.50 602 Treasurer -100% Tax Paym: Fund $36800 5183.00 $1,321.00 ($1,870.00) $0.00 656 Water & Sewer Accounting $8,640.13 $4,431.74 $47,522.41 $18.067.35 $78,861.64 850 Workforce Development $305.00 $0.00 $0.00 $0.00 $305.00 63600-1080101 -152000-631302 SUB-TOTAL DIRECT CHARGES FOR DATA $130,584.19 $279,221.72 $178,398.52 5216,323.80 5805,528.23 PROCESSING DEVELOPMENT NON-GOVERNMENTAL IMAGING 471 Courts-FOC Exp-CS Enforcement Image $19,496,25 $97.60 $146,40 $538.80 $20277.05 63600-1080101-15200-630903 TOTAL NON•GOVERNMENTAL IMAGING $19,496.25 $97.04 $146.40 $536.80 520,277.05 DEVELOPMENT APPROPRIATION TOTAL COUNTY DEVELOPMENT CHARGES $1,869,494.20 $1,455,64625 kt.585,697,84 $1,471,567.71 $6,382,406,00 NON-COUNTY AGENCIES 63600-1080101-152000-635017 Non-County Agencies 51,344.00 $372.10 $5,479.00 $1.748.00 $8,943.10 TOTAL DEVELOPMENT CHARGES $1,870,838.20 $1,456,018.35 $1,571,176.84 $1,473,315.71 $6,371,349.10 Prepared by tnformaten Technoteby 160/2007 4th Qtr 2007.xls $0.00 $0.00 91404 BOC-Cust Supt BOC - Total 005 BOARD OF COMMISSIONERS 665 CHILDRENS VILLAGE 95665 Childrens Village $1.586.00 Childrens Village - Total 725 CLERK - ADMIN 72500 Clerk - Admin $0.00, Clerk - Admin - Total $60,939.13 $0.00 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2007 cust # GOVERNMENTAL FUNDS 630 ANIMAL CONTROL 24017 SQL Server Supp - Animal Control $2,011.63 $47.024.13 620 AUDITING 95468 Auditing-Customer Support $183.00, Auditing - Total $183.00 $1,586.00 $0.00 440 CLERK - ELECTIONS 95443 Elections $2,633.00 Clerk -Elections - Total $2,633.00 95628 Web License Registration 30,181.00 95682 Dog System 14 831.50 Animal Control-Tota 720 CLERK / REGISTER OF DEEDS 20004 IDMS Support - Register of Deeds $658.80 24003 SQL Server Supp - ROD 3.5% 2,011 63 36510 GIS Implementation Support-ROD 540.00 36511 ROD Application - H/W Support 0.00 95493 Reg Deeds System Maintenance 0.00 95162 Clerk - OW Support 0.00 95163 Clerk - OW Maintenance 610.00 95558 User Support/ROD 110.00 95564 ROD - OW Support 0.00 Clerk/Reg of Deeds - Total $3,930.43 722 CLERK - IMAGING 410 CLERK - JURY COMMISSION 724 CLERK - LEGAL RECORDS 723 CLERK - VITAL STATISTICS 522 COMMUNITY CORRECTIONS-ADMIN (CO) 13001 Clerk - eFiling - 50% 23007 Oracle Support - Clerk Image 5.2% 65420 Clerk - Image Replace 95158 Clerk - Imaging Clerk - Imaging - Total 23008 Oracle Support - Jury Comm - 5.2% 95512 Jury Commission Clerk -Jury Commission - Total 24015 SQL Server Supp Circuit Ct 3.5% 95189 Circuit Court System Clerk - Legal Records - Total 95161 Vital Stets Index Clerk - Vital Statistics - Total 23003 Oracle Support-Comm Corr - 5.2% 24012 SQL Server Supp - Community Corr 3.5% 52200 Comm Corr-Admin (County) 52201 Comm Corr-DW Supp Community Corrections - Total $0.00 3,495.36 0.00 13.251,60 $3,495.36 0.00 $2,011.63 58.927 50 $0.00 $3,495.36 2,011.63 5,783.00 2.287.50 $16,746.96 $3.495.36 $13,577.49 785 COMMUNITY & ECO DEVELOPMENT 430 CORPORATION COUNSEL 495 CTS-BUSINESS DIVISION 487 CTS-FD-CT SERV-ADMIN Prepared by Information Technology. 10/3/2007 36500 GIS Implementation Support C&E Dev $1,071.00 36501 CEO Application - HMI Support 945.50 95785 Comm & Eco Developmt 0.00 Community & Eco Dev - Total $2,016.50 95501 Corporation Counsel $122.00 Corporation Counsel - Total $122.00 12002 Circuit Ct-Courts/Criminal Warehouse 50% $0.00 14001 CTS-DW Support/Circuit Ct - 75% 2,551.50 15001 CTS-DW Maint/Circuit Ct - 75% 596.63 23010 Oracle Support-CCT/CTS Crim Whse 2.6% 1,747.68 CTS-Business Division - Total $4.895.81 95196 CTS-FD-Ct Serv - Admin $0.00 CTS-FD-Ct Serv-Admin - Total $0.00 41h Qtr 2007.xls $2,011.63 (4,012.00) 36,578.00 7,137.00 22,427.50 0.00 $64,142.13 $1,317.60 3,495.36 6,034.88 1,844 00 3,888.00 14,903.00 26,024.25 11,267.00 20,345.00 8,022.00 297.00 21,704.25 49.757.50 $168.899.84 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2007 492 CTS-FD-CT SERV-ADOPTIONS 95173 CTS-FD-Ct Serv-Adoptions $0.00 CTS-FD-Ct Serv-Adoptions - Total $0.00 505 CTS-FD-JUDICIAL 95186 CTS-FD/ADMIN-Family Judges $0.00 CTS-FD-Judicial - Total $0.00 506 CTS-FD-JUDICIAL SUPPORT 95187 CTS-FD/Admin - Fam Suppt Staff $4,339.00 CTS-FD-Judicial Suport - Total $4.339.00 483 CTS-FD-JUDICIAL SUPPORT-ADM 24009 SQL Serv Supp - CTS-Jud Sup Adm - 3.5% $2,011.63 95193 CTS-FD-Judicial Suport-Adm 4.208,00 CTS-FD-Judicial Suport-Adm - Total $6.219.63 484 CTS-FD-JUVENILE REFEREES 95191 CTS-FD-Admin-Juvenile Referees $0.00 CTS-FD-Juvenile Referees - Total $0.00 474 CTS-FD-JUVENILE SUPPORT 95474 CTS-FD-Admin-Juvenile Support $0.00 CTS-FD-Juvenile Support - Total $0.00 499 CTS-GJ-ASSIGNMENT 95180 CTS-GJ-Assignment $0.00 CTS-GJ-Assignment - Total $0,00 420 CTS - GJ - FAMILY SUPPORT 95195 Cir Crt Admin $6,351,00 Courts - GJ - Family Support - Total $6,351.00 496 CTS - GJ 95208 CTS - DW Maintenance $0.00 CTS GJ - Total $0.00 498 CTS-GEN JURIS-JUDICIAL SUPPT 95179 CTS -Gen Juris-Judicial Suppt $50.042.50 CTS -Gen Juris-Judicial Suppt - Total $50,042.50 500 CTS-GJ-MEDIATION 95181 CTS-GJ-Mediation $0.00 CTS-GJ-Mediation - Total $0.00 493 CTS-JUDICIAL ADMIN 13002 CTS-eFiling - 50% $0.00 95174 CTS-Judicial Admin 134.20 CTS-Judicial Admin - Total $134.20 730 DRAIN COMMISSIONER 740 EQUALIZATION 24008 SQL Server Supp - Drain 3.5% 28009 Drain Administration 28011 Drain Commissioner Application 36520 GIS Implementation Support Drain 36521 OCIDC Application - H/W Support 95669 Water 8k Sewer Accounting Drain Commissioner - Total 20001 IDMS Support-Equalization - 40% 23012 Oracle Support-Eaualization - 5.2% 24005 SQL Server Supp-Equalization - 10.5% 31075 Equal - Development 36505 GIS Implementation Support Equalization 36506 Equal Application - H/W Support 36507 Equal LAMS Support/Mtce 36601 Land System Enhancements - Equal (50%) 95559 User Support/Equal 95562 Equalization - DW Support 95570 Equalization - DW Maintenance 95693 Equal-System Maintenance 95699 BS&A Master Appraisal Sup/Maint Equalization - Total $3,147.25 900 EMERGENCY RESPONSE 8. PREPAREDNESS 36545 GIS Implementation Support EMS $1.830.00 36546 ERP Application -1-1/W Support 1,317.25 98990 Emergency Response 0.00 ERP - Total 755 FACILITIES MANAGEMENT 91500 FM - System Support $0.00 Facilities Mgmt - Total $0.00 Prepared by. Information Tecnnolccy, 1013/2007 410 Qtr 2007.xls 660 FISCAL SERVICES ADMIN 840 HEALTH DIVISION 843 HEALTH - ENVIRONMENTAL $10,486.08 3,495.36 1,005.81 41,608.00 61,273.00 0.00 0.00 0.00 1.525.00 0.00 27,488.10 13,744.05 $160.625.40 $658.80 5,025.50 2,376.00 9,644.00 783.00 $18,487.30 $3,495.36 8,046.50 0.00 262.652.75 0.00 $274,194.61 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2007 23001 Oracle Support - Fiscal Serv - 15.6% 23013 Oracle Support - HR-Acctg/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 44077 BUD-System Maintenance 44079 FS - DW Support 44081 FS - DW Maintenance 96001 Human Res-Acct 40% 96003 Human Res.-Budget 20% Fiscal Services Admin - Total 20002 IDMS Support - CHAMPS - 20% 36525 GIS Implementation Support Health 37025 CHAMPS - P.O.P 95563 User Support / Health 96842 Health Admin Health - Total 23005 Oracle Support - EH Projects - 5.2% 24014 SQL Server Suppt - Ehealth 14% 37002 Environmental 84200 EH - Projects 84300 Ehealth Program Health-Environmental - Total 680 HUMAN RESOURCES 23014 Oracle Support-HR/Personnel - 5.2% $3,495,36 24007 SQL Server Suppport-HR'Personnel - 1.75% 1,005.81 44042 HR-Systems Maintenance 432.00 44044 HR-New Development 3.746.30 95556 HR User Supt 1,844.80 96002 Human Res-Personnel 40% 32 099.70 Human Resources - Total $42,623.97 907 LIBRARY - ADMIN 91405 Library Board $0.00 Library Admin - Total $0.00 641 MATERIALS MGMT-GEN SUPPORT SERV 95440 Materials Management $0.00 Materials Mgmt-Gen Fund - Total $0.00 872 MEDICAL EXAMINER 24002 SQL Server Support - Medical Exam - 3.5% $2,011.63 87202 Medical Examiner - Customer Support 16 293.00 Medical Examiner - Total $18,304.63 710 MSU EXTENSION - OAKLAND 95676 MSU Ext Equipment Maintenance $30.50 MSU Extension - Oakland - Total $30.50 775 PLANNING & ECONOMIC DEVELOPMENT 95786 PEDS - OW Support $244.00 95787 PEDS - OW Maintenance 488.00 PEDS - Total $732.00 512 PROB-ESTATES/MENTL HLTH IMAGE 95207 Prob-Est/Mntl Hlth Image $268.40 Prob-Est/Mntl Hlth Image - Total $268.40 509 PROB-JUDICIAL ADMIN 95165 PC-Judicial Admin-Admin Serv $0.00 Prob-Judicial Admin - Total $0.00 510 PROB-ESTATES/MENTL HLTH SUPPORT 24010 SQL Serv Supp-PCT-Est/Mental - 3.5% $2,011.63 92198 Prob-Est/Mntl Hlth Support 4,464.00 Prob-Est/MMI Filth Support - Total $6,475.63 481 PROBATE-FD JUDICIAL 95168 Prob-FD Judicial $305.00 Prob-FD Judicial - Tota $305.00 479 PROB-FD-JUDICIAL SUPPORT 95188 PROB-FD Judicial Support $0.00 PROB-FD Judicial Support Total $0.00 Prepared by Information Technology, 10/3/2007 4111 Qtr 2007.xls $0.00 0.00 $0.00 44026 PUR-System/Customer Support 44027 PUR-System Maintenance Purchasing - Tote 690 PURCHASING $0.00 5,353.75 2,440.00 0.00 $7,793.75 $0.00 10,774.40 610.00 $11,384.40 $0,00 1,747.68 70,985.72 7,174.50 806.00 $80,713.90 $3,495.36 2.379.00 $5,874.36 $3,495.36 4,023.25 4.697.00 $12,215.61 $3,495.36 6,990.73 1,476.00 21,159.00 11,267.00 904.20 20,570.50 0.00 10,563.50 486.00 1.159.00 28.695.50 0.00 $0.00 $212.63 49.72 6.181.25 60.00 $212.63 49.72 6,181.25 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2007 145 PROSECUTOR - GENERAL PROSECUTION 24016 SQL Server Supp - Proescutors 3.5% 95622 Prosecutor/Executive 97001 Prosecutor Data Proc Prosecutor - Total $2,011.63 17,586.50 1113.00 $21,711.13 637 RECORDS RETENTION 650 REIMBURSEMENT 195 SHERIFF 191 SHERIFF • CLEMIS 445 SUPPORT SERVICES 600 TREASURER 910 VETERANS SERVICES 540 52/1 DISTRICT COURT - NOVI 541 52/1 DISTRICT COURT - NOVI • PROBATION 550 5212 DISTRICT COURT - CLARKSTON 44052 Rec-System Maintenance 44053 Rec-System Enhancements 44054 Rec-New Development 95636 Mail Room Records Retention - Total 95469 Reimbursement Division 95470 Reimbursement System 95542 Reimburse User Support Reimbursement - Total 12001 OCSD-Courts/Criminal Warehouse 23009 Oracle Suppport - OCSD/CTS Crim Whse - 2.6% 97163 Sheriff 97165 Sheriff-DW Support 97166 Sheriff-DW Maintenance Sheriff - Total 23015 Oracle Suppport - Sheriff / CLEMIS - 5.2% 96163 Sheriff - CLEMIS Sheriff - CLEMIS - Total 23002 Oracle Support - Supp Serv - 5.2% 24011 SQL Server Supp - Suppt Services 7% 44500 Support Services Support Services - Total 23006 Oracle Support - Del Tax - 5.2% 23016 Oracle Support - Treasurer - 10.4% 36515 GIS Implementation Support-Treasurer 36516 Treasurer Application - I-1/W Support 36602 Land System Enhancements - Trees (50%) 44061 Tre-System/Customer Support 44062 Ire-System Maintenance 44064 Ire-New Development 44080 Ire-OW Support 44082 Ire-OW Maintenance 95008 Del Tax On Line 95303 Del Tax System Maintenance 95561 User Support/Del Tax Treasurer - Total 95651 Veterans Cust Support Veterans Services - Total 14002 CTS-DW Support-52/1 - 6.25% 15002 CTS-DVV Maint 52/1 - 6.25% 95527 DC Suprt- 52/1 - 25% 52/1 District Court - Total 94542 DC Probation Support - 52/1 - 25% 52/1 District Court - Probation - Total 14003 CTS-DW Support-5212 - 6.25% 15003 CTS-DW Maint 52/2 - 6.25% 95528 DC Suprt- 52/2 - 25% 52/2 District Court - Total $106,766.79 $0.00 $6443.60 $0.00 $6.443 60 $0.00 551 6212 DISTRICT COURT - CLARKSTON - PROBATIC 94552 DC Probation Support - 52/2 - 25% $0.00 52/2 District Court - Probation - Total PrePared by. Information Technology: 10/3/2007 4th Qtr 2007.xls $658.80 3,495.39 14,081.38 0.00 0.00 10,601.50 14,283.50 0.00 24 300.00 $2,170.00 $0.00 $0.00 $67,420.57 $2,170.00 $0.00 $0.00 $732.00 2,011.63 $2,743.63 $0.00 2,011.63 1,145.25 $3,156.88 $14,127.00 $14,127.00 $3,495.36 22,355.00 $25,850.36 $0.00 $0.00 95719 Register of Deeds Automation $0.0_0 Clerk/ROD Automation Fund - Total 92194 CTS-FOC-Exp-CS Enf-Image $536.80 CTS-FOC Exp-CS Ertl-Image - Total 92195 CTS-FOC-Exp-Fam Counseling $0.00 CTS-FOC-Exp-Fam Counseling - Total 92193 CTS-FOC Exp-CD Enforc-Dev $11,610.00 CTS-FOC Exp-CD Enforc-Dev - Total INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2007 560 52/3 DISTRICT COURT - ROCHESTER 14004 CTS-DVV Support-52/3 - 6.25% 15004 CTS-DW Maint 52/3 - 6.25% 95529 DC Suprt - 52/3 - 25% 52/3 District Court - Total $212.63 49.72 6,181.25 $6,443.60 561 62/3 DISTRICT COURT ROCHESTER - PROBATIC 94562 DC Probation Support - 52/3 - 25% $0.00 52/3 District Court - Probation - Total $0.00 530 5214 DISTRICT COURT - TROY 14005 CTS-DW Support-52/4 - 6.25% $212.61 15005 CTS-DW Maint 52/4 - 6.25% 49,71 95530 DC Suprt- 52/4 - 25% 6,181.25 52/4 District Court - Total $6,443.57 531 52/4 DISTRICT COURT - TROY - PROBATION 94532 DC Probation Support -52/4 - 25% $0.00 52/4 District Court - Probation - Total $0.00 Gust # DIRECT FUNDS 055 CLEMIS 056 CLEMIS FUND 63500 096 CLEMIS 2005 IBIS GRANT 661 COMMUN & HOME IMPROVEMENT 719 CLERIC/ROD AUTOMATION FUND 471 CTS-FOC-EXP-CS ENFORC-IMAGE 470 CTS-FOC-EXP-FAM COUNSELING 507 CTS-FOC EXP-CS ENFORCEMENT 210 FIRE RECORDS MANAGEMENT SYSTEM 750 FM&O 760 FM - BOC WEBCASTING 757 FM-WK RELEASE/JAIL MGMT/VIDEO CONF 758 FM - JAIL MGMT REPLACEMENT 20003 10MS Support - 5,6% 23018 Oracle Support - Sheriff CLEMIS 5.2% 24004 SQL Server Support - 24.5% 90507 CAD Customer Support 95409 CRISNET/CLEMIS LRM 95430 CLEMIS Maintenance 95431 CLEMIS Enhancements 95432 CLEMIS Adhoc Reports 98003 CLEMIS User Support CLEMIS - Total 63500 CLEMIS Fund CLEMIS 63500 Fund - Total 63596 2005 Federal Approp - IBIS Project CLEMIS 2005 IBIS Grant - Total 66103 Comm Dev User Support C,ommun & Home Improvement - Total 21010 Fire Records Mgmt Fund 531 24001 SQL Server Support - FRMS 3.5% Fire Records Mgmt - Total 21001 FM&O 24013 SQL Server Supp - FM&O 75503 FM&O Development FM&O - Total 76000 FM - BOC Webcasting FM - BOC Webcasting - Total 23004 Oracle Support - Oak Video - 5.2% 75700 Fac Mgmt - Video Arraignments FM-Wk Rel/Jail Mgmt/VIdeo Cant - Total 75800 FM - Jail Mgmt Replacement FM - Jail Mgmt Replacement - Total $0.00 $536.80 $0.00 $11,610.00 Prepared by. Information Technology, 10/3/2007 4th Car 2007 xi:. $0.00 0.00 $0.00 $21,267.001 $1.150.00 $0.0Q $122.00 0.00 $1,464.00 $0.00 $15,956.50 $0.00 $0.00 ($21,267,00) S1,150.00 $0.00 $122.00 $1.464.00 $0.00 $15,956.50 $0.00 0.00 $0.00 $29,748.50 $29,748.50 $38,781.50 7,092.50 $45,874.00 ($1,870.00) ($1,870.00) INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2007 655 GARAGE 380 HEALTH IMMUNIZATION - GRANT 662 MAJOR DEPT SUPP PROJ FUND 870 MEDICAL CARE FACILITY 248 MEDICAL CARE FACILITY - PHARMACY 653 Q.C. INTERNATIONAL AIRPORT 770 PARKS AND RECREATION 790 RADIO COMMUNICATION 791 RADIO COMMUNICATION - E911 695 RISK MANAGEMENT 663 SECURITY CAMERA PROJECT (GF) 601 TREASURER - DTRF 602 7REASURER-100% TAX PAYMT FUND 44057 GAR - Systems Maintenance 44058 GAR - Systems Enhancements Garage - Total Health - Immunization Health - Immunization - Total 65200 e-Financial-Peoplesoft Implementation Major Dept Supp Proj Fund - Total 98873 MCF - Support MCF - Total 98248 MCF - Pharmacy MCF - Pharmacy - Total 35540 GIS Implementation Support-Aviation 65301 Airport User Support O.C. International Airport-Total 95419 PR/NOM-Administration Parks & Recreation - Total 79001 Radio Communications Radio Communications - Total 79101 Radio Communications - E911 Radio Communications - E911 - Total 44036 RSK-System/Customer Support 95695 Risk Management Risk Management - Total 66300 Security Camera Project (OF) Security Camera Project (OF) - Total 18010 Treasurers Office System 18050 Drain Apportionment Treasurer DTRF - Total 99002 Treasurers Office Treasurer 100% Tax Pmt Fund - Total 38000 656 WATER & SEWER ACCTG 850 WORKFORCE DEVELOPMENT 23011 Oracle Supp - Water & Sewer Acct'g - 5,2% 95669 Water & Sewer Acct'g Water & Sewer Acct'g - Total 95670 Workforce Development Workforce Development - Total $3,495.36 14 572.00 $18,067.36 Moo $0.00 Prepared by: Information Techncogy: 10/3/2007 4th Cer 2007.xls Resolution #07269 November 29, 2007 The Chairperson referred the resolution to the Finance Committee. There were no objections. FISCAL NOTE (MISC. #07269) December 13, 2007 BY: FINANCE COMMITTEE, MIKE ROGERS, CHAIRPERSON IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FOURTH QUARTER 2007 DEVELOPMENT APPROPRIATION TRANSFER TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS Chairperson, Ladies and Gentlemen: Pursuant to Rule XII-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 2007 Development cost to benefiting departments. 2. The fourth quarter data processing development charges are $1,237,691.75; imaging development charges are $17,015.36 for General Fund/General Purpose departments; direct charges to Special Revenue and Proprietary fund departments are $216,323.80, non-governmental imaging development are $536.80, and charges to non-county agencies are $1,748.00. 3. The respective departmental Fiscal Year 2007 budgets are to be amended as specified in the attached detail schedule. FINANCE COMMITTEE FINANCE COMMITTEE Motion carried unanimously on a roll call vote. /2---//,1/47 Ruth Jo1in4in, County Clerk Resolution #07269 December 13, 2007 Moved by Kowall supported by Middleton the resolutions (with fiscal notes attached) on the Consent Agenda be adopted. AYES: Burns, Coulter, Crawford, Douglas, Gershenson, Gingell, Gosselin, Gregory, Greimel, Hatchett, Jacobsen, KowaII, Long, Middleton, Nash, Potter, Potts, Rogers, Scott, Spector, Woodward, 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. I HEREBY APPROVE THE FOREGOING RESOLUTION 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 December 13, 2007, 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 13th day of December, 2007.