Loading...
HomeMy WebLinkAboutResolutions - 2007.08.30 - 28378MISCELLANEOUS RESOLUTION #07187 August 16, 2007 G) BY: GENERAL GOVERNMENT COMMITTEE, CHRISTINE LONG, CHAIRPERSON IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - THIRD 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 Third Quarter 2007 data processing development charges to be $1,468,078.51 and the imaging development charge to be ($81,925.59) for the General Fund/General Purpose County departments; and WHEREAS direct charges to Special Revenue and Proprietary fund departments are $179,398.52, non-governmental imaging development are $146.40, and non-county agencies are $5,479,00 for the Third 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 Third Quarter 2007 Data Processing Development Report and approves the Third Quarter appropriation transfer as specified on the attached schedule. Chairperson, on behalf of the General Government Committee, 1 move the adoption of the foregoing resolution. GENERAL GOVERNMENT COMMITTEE GENERAL GOVERNMENT COMMITTEE VOTE: Motion carried unanimously on a roll call vote. 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 10130-1010201-181010-773630 10100-5010101-180010-773630 10100-2010201-180000-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-181020-773630 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-3010301-121220-773630 10100-3010301-121110-773600 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-773630 10100-1040101-1400W-773630 10100-1020601-182020-773630 10100-1050401-183010-773630 10100-5010303-165040-773630 10100-1030850-184030-773630 10100-1074601-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-773630 10100-4010101-122050-773630 10100-1020401-182090-773630 10100-1030803-184020-773530 10100-1020701-126020-773630 10100-4030301-112590-773630 10100-4030601-110000-773630 10100-1030803-184030-773630 10100-7010101-186040-773630 10100-1070301-132050-773530 540 101 541 101 550 101 551 101 550 10^ 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 484 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 580 101 907 101 641 101 872 101 710 101 775 101 509 101 510 101 481 101 479 101 145 101 690 101 537 101 850 101 195 101 191 101 445 101 500 101 910 101 $7 840 DO $3.593.40 $19,394.20 $266,468 71 5329,574.91 5893,829.00 5274.338 71 5333.168.31 50.00 5913.223.20 57.950 80 5297,755 38 $305,746 18 $45900 55,13r'.20 $3,428.60 $10,024.80 5459 00 $6 137.20 $3,428.60 $0.00 510,024 80 $1,539,657.88 $1,158,828.69 51.468,078.51 $0.00 GOVERNMENTAL IMAGING 722 101 10100-2010210-125000-773539 512 101 10100-3040403-124010-773539 Clerk Image Probate-Estates/Vietal Health Image $17 449.44 (581.998.79) $73.20 $179,511 58 $244 00 $40.80 5114,962 53 $366.00 INFORMATION TECHNOLOGY DATA PROCESSING DEVELOPMENT SUMMARY 3RD QUARTER 2607 CUST# FUND # ACCOUNT # ls. Qv 2n5 Ctr 3rd Qtr 9th Qtr DIVISION Oct - Dec Jan - Mar Apr - June July - Sept Y.T.D. 52/1 - District Cowl 52/1 - District Court - Probato-. 52/2 - District Court 52%2 - District Court - Proba•o , 5213 - District Court 52%3 - District Court - PrObatnon 52/4 - District Cart 52/4 - District Court - Probation Animal Contro Auditing Board of Commissioners Clerk - Admin Clerk - Electrons Clerk - Jury Corvus SS ClOrk - Legal Records Clerk - Register of Deees Clerk - Vital Statistics Economic Development & Community Affairs Comm,nity Corrections Adm. Corporation Counsel Courts-Bus ness Div sioi Courts-FE) Juvenie S2pport Courts-FD Juvenre Reterees Courts-FD-Coud Serwces•Admin Courts-FD-Court Services-Adootions Courts-ED-Judicial Support Courts-FD-Judicial Support-Adinin Courts-GJ•Assignment Courts.G.1-Farnry .512Doort Courts-General Juisd ct-od Courts-G,Ji.clicial Support Courts-GJ-Mediata, Courts - judicI / Adm nistration County Executive Drain Commissioner Emergency Response & Prep Equalization Division Facilit es Manageme -11 Fiscal Services - Admi- Human Resources Library Admit, Matenals Management - Gen Funo Medical Examiner MSU Extension • Oakland Planning & Econam ,c Development PrOnate - .11.1d.CW Adrrin Probate-Estates/Mental i-eath Supcort Probate-FD-Judicial Probate-FD-Judicial Supcort Prosecuting Attorney - General Prosecution Purchasing Records Retention Reimbursement 0-visor Sherif. Sheriff CLEMIS Support Services Treasure, Veterans Services Sub-Total Fund 101 66 971 45 $6 815 25 $10.847.50 $24,634.20 $3.03 $0 OD $0.00 $0,00 56 971 45 $6 815.25 $10,847.50 $24,634.20 53 03 $0.02 $0.00 50.00 56 971 45 $6815.25 $10,847.50 $24,634.20 50 03 80.00 $0.00 $0.00 86971 42 58,815 25 $10,847.50 $24,634.15 $0.03 50 00 $0.00 $000 $9 57052 523.686 12 $36,849.90 $70,106.12 $30503 0122 00 $183.00 $610.00 $732 OD $000 $366.00 $1.098.00 $16 942.00 $801 00 $89.00 $17,832.00 $42 941.03 53.371 00 $10,100.00 $56,412.00 58601:3 53.326 24 $4,432.41 $13,359.78 537 785.53 547.642 12 563,256 50 $148,654.12 518 382.221 521,764 12 ($5,547.10) $34,299.22 519 744.53 $000 $0.00 $19,744.50 540.617.25 59,646.50 $2,958.50 $53,223 25 548.829 63 $59.555 86 $46,768.41 $155,153.90 58.469 QC 82.379,00 $3459.00 $14,306.00 56.433 32 510 986.62 55,759 20 $23.179 14 50 00 $0.00 $0.00 $0.00 $0 00 $0.06 $0 00 $0.00 $0 00 00.00 $0.00 $0.00 50 00 50.00 $0.00 $0 00 50 00 5732.00 53.772 00 54,504 00 53.929 20 55299.12 $5,846.90 515.074 90 50 00 $0.00 $0.00 80.00 $3 416 00 $1737350 $5,781.00 $25.570.50 SO 00 $0.00 $0.00 $0.30 $34,429 00 $33.567.00 $45,072.00 5113068 00 $8.534 20 00 .00 $0.00 $8,534.20 $3.051 50 $24.40 $951.60 $4,027.50 $0.00 $0.00 $0.00 50.00 $63,107.50 066,816 87 $25,198.50 $155,122.87 $2,348.50 $1,736 50 $1,921.50 $13,008.50 $123347.50 5139,139 84 $320,227.71 $582.715.15 $0.00 $0.00 $0.00 $0.00 5275 558.37 $139.904 01 $173.521.46 $589,253.84 $120 758,19 035,398 80 $48.960.42 5208,147 41 $1 098.00 $2,954 00 5651.00 $4,713.00 $000 $000 $000 00.50 $27.27107 525.032 62 $19,774.75 575,078 44 51 403 00 50.00 $122.00 51,525.00 51 891.00 $976.00 3244.00 53,11100 $0.00 $0.00 $0.00 $0.00 55.723 28 $4.601.12 $8,581.50 $19,205.90 $0.00 50.00 51,897.00 $1.897.00 $0.00 $0.00 50.00 50.00 $12 472.00 516.260 12 $25.668.50 $54,400.62 $0 .00 $0.00 $0.00 $0.30 $5.146.00 $8,415.00 $10,919.00 527,483 00 516,256 00 54.392.00 55,238 00 $25,886.50 $105.721 07 $98.515.62 $96,128.20 5301.3E4.89 59,473 60 55,160 24 $4,737.41 519,371 25 $10,555.13 516.299 48 $15,781.42 $48.647.03 5103 251.53 539.227 96 598.420.71 5240.900 30 $122.00 50-0 $0.00 $122.00 51 233 452.70 5878.382 78 $1,131.481.60 $0.00 $3,243,317.08 Health Fund 12211 840 221 20221-1060201-133150-773630 543 221 20221-1060220-134350-773630 Juvenile Maintenance Fund [2931 685 293 20293-1060501-112090-773630 63600-1080101-152000-631365 Health Health Environmental Sub-Total Fund 22' Ch ldren s Village Sub-Total Fund 293 DATA PROCESSING DEVELOPMENT FOR GOVERNMENTAL FUND APPROPRIATION 63600-1080101-152000-530903 TOTAL GOVERNMENTAL IMAGING $179,755.88 $17,498.24 081.925,591 DEVELOPMENT APPROPRIATION SUB-TOTAL GOVERNMENTAL / IMAGING DEVELOPMENT APPROPRIATION( $1 719,413.76 $1,176,326.93 $1,386,152.92 10100-9090101-196030-773630 lnformaton Technology Development ($1 719,413.761 ($1,176,326.93) 01,386 152.92) TOTAL GOVERNMENT, $0.00 $0.00 $0.05 $115,328.53 $0.00 $4,281,093.61 30 00 ($4,281.893 611 $0.00 $0.00 50.00 Prepared by: Information Technology: 8/6/2007 07aug063rd Qtr 2007.xls CUST# FUND N ACCOUNT lot Ott 2nd Qtr 3rd 41r Oct - Dec Jan - Mar Apr -June 4th Qtr July - Sept DIVISION Y.T.D. INFORMATION TECHNOLOGY DATA PROCESSING DEVELOPMENT SUMMARY 3RD QUARTER 2007 NON-GOVERNMENTAL DIRECT CHARGES 055 CLEMIS 565 405 79 $53.493 00 562,503.70 $194 402.49 056 CLEMIS FUND 53530 90 00 $300 $1,342.00 $1,342.00 096 CLEMIS 2005 IBIS Graht $36900 $2.925.00 $610.00 $3,904.00 719 ClerK/ROD Automat c^ Funs; $000 53.00 57,073.50 $7,073.50 661 Community & Hcme Improvement 5671 00 $122.00 ($854.00) ($61.00) 470 Courts-FOC Exp-FaA,.iy CoLnseling $000 53 00 $0.00 $0.00 507 Courts-FOC Exo-CS Enforcement $6 606 OU $6 143 02 511,565.00 $24,314.00 210 Fife Records Management System $4 203 07 $2 326 62 $2.506.00 59,035.59 757 FM-VA ReliJall rtrIgnideo Con( 51 735.13 $3 697 24 $6.600.41 $22.035.78 758 FM-Jail Mgmt Replace",em 53 00 $5.00 $0.00 $0.00 750 FM & 0 53 755 00 54030.12 52.411.00 $10,196.12 655 Gararge 53 714 03 5500 $0.00 53.714.00 380 heath - mlmunizat,on Grant 53 03 90 00 $0.00 $0.00 662 Major Department Support Project Fund 54 758 00 $17 795 03 53.477.00 $26,025.00 870 Medical Care Facihty 53 853 57 55.03 $244.00 $4,097.57 248 Medical Care Fee:: ty - Pharmacy 53.00 55 OD $0.00 $0.00 653 0.c; 1,tern4t5na' A Tor: $' 792.03 873203 $1.676.00 54.20000 770 Parks and Recrea• o ; - Ac'r, ,stra: or, 335502 $1 922 OD 51.262.00 $3,550.00 790 Radio Communicaticnz 53 03 $0 00 $0.00 50 00 695 Risk Management 53 03 5484 OD $149.00 $637.00 663 Secunty Camera Project (GT; 0203 523 475.00 $25,687.50 850,19250 601 Treas.irer - DTRF 510 844 53 8157 465.03 $3,302.00 $171,606 50 602 Treas,rer -100% Tao Payr^t F ,d 330503 918300 51.32160 51,870.00 656 Water & Sewer Account ^g 58 843 13 54 431 74 $47,522.41 $60,794 28 850 Workforce Develcprrenr 5305 03 90.03 50 00 9305.00 63500-1080101-152000-631302 SUB-TOTAL DIRECT CHARGES FOR DATA $130,584.19 5279,221.72 $179,398.52 $0.00 $589,204.43 PROCESSING DEVELOPMENT NON-GOVERNMENTAL IMAGING 471 Courts-F00 ;hug CS EnforcemeM 519 495.25 95768 5146 40 $19,740.25 63600-1083101-15200-630903 TOTAL NON-GOVERNMENTAL IMAGING $19,496.25 $97.60 $146.40 $0.00 $19,740.25 DEVELOPMENT APPROPRIATION TOTAL COUNTY DEVELOPMENT CHARGES $1,869,494.20 $1,455,646.25 51,565,697.84 $0.00 14,890,838.29 NON-COUNTY AGENCIES 63600-1080101-152000-635017 Non-County Agenc es $1,344 05 $372.10 $5.479 00 $7.195.10 TOTAL DEVELOPMENT CHARGES $1,870,838.20 81.456.018.35 $1,571,176.84 $0.00 $4,898.033.39 Prepared by: Information Technology; 13/6/2007 07aug063rd Otr 2007.xls $366.00 $366.00 005 BOARD OF COMMISSIONERS 91404 30C-Gust Supt BOC - Total $2,959.50 $3,459.00 487 CTS-FD-CT SERV-ADMIN 95196 CTS-FD-Ct Serv - Admin $0.00 CTS-FD-Ct Serv-Admin - Total Prepared by: Information Technology: 8/6/2007 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - THIRD QUARTER, 2007 Gust # GOVERNMENTAL FUNDS 630 ANIMAL CONTROL 24017 SQL Server Supp - Animal Control $2,075.50 95628 Web License Registration 17,873.00 95682 Dog System 16 901.00 Animal Control-Total 620 AUDITING 95463 Auditing-Customer Support $183.00 Auditing - Total 665 CHILDRENS VILLAGE 95665 Childrens Village $3.428.60 Childrens Village - Total 725 CLERK - ADMIN 72500 Clerk - Admin $89.00 Clerk - Admin - Total 440 CLERK - ELECTIONS 95443 Elections $10,100.00 Clerk -Elections - Total 720 CLERK! REGISTER OF DEEDS 20004 IDMS Support - Register of Deeds $451.40 24003 SQL Server Supp - ROD 3.5% 2,075.50 36510 GIS Implementation Support-ROD 0.00 36511 ROD Application - HNV Support 244.00 95493 Reg Deeds System Maintenance 0.00 95162 Clerk - DW Support (10,990.00) 95163 Clerk - DW Maintenance (488.00) 95558 User Support/ROD 2,860.00 95564 ROD - DW Support 0.00 Clerk/Reg of Deeds - Total 722 CLERK - IMAGING 13001 Clerk - eFiling - 50% $915.00 23007 Oracle Support - Clerk Image 5.2% 4,432.41 65420 Clerk - Image Replace 0.00 95158 Clerk-Imaging (87,346.20) Clerk - Imaging - Total 410 CLERK - JURY COMMISSION 23008 Oracle Support - Jury Comm - 5.2% $4,432.41 95512 Jury Commission 0.00 Clerk -Jury Commission - Totai 724 CLERK - LEGAL RECORDS 24015 SQL Server Supp - Circuit Ct 3.5% $2,075.50 95189 Circuit Court System 61,181.00 Clerk - Legal Records - Total 723 CLERK - VITAL STATISTICS 95161 Vital Stats Index $0.00 Clerk - Vital Statistics - Total 522 COMMUNITY CORRECTIONS-ADMIN (CO) 23003 Oracle Support-Comm Corr - 52% $4,432.41 24012 SQL Server Supp - Community Corr 3.5% 2,075.50 52200 Comm Corr-Admin (County) 39,092.50 52201 Comm Corr-DW Supp 1,168.00 Community Corrections - Total 785 COMMUNITY & ECO DEVELOPMENT 36500 GIS Implementation Support C&E Day $183.00 36501 CED Application - HNV Support 549.00 95785 Comm & Eco Developrnt 2,227.50 Community & Eco Day - Total 430 CORPORATION COUNSEL 95501 Corporation Counsel $3,459.00 Corporation Counsel - Total $36,849.50 $183.00 $3,428.60 $89.00 $10.100.00 ($5,847.10) ($81,998.79) $4,432.41 $63,256.50 $0.00 $46,768.41 495 CTS-BUSINESS DIVISION 12002 Circuit Ct-Courts/Criminal Warehouse 50% $0.00 14001 CTS-DW SupporUCircuit Ct - 75% 4.092.00 15001 CTS-DW Maint/Circuit Ct - 75% (549.00) 23010 Oracle Support-CC7/CTS Grim Whse 2.6% 2,216.20 CTS-Business Divisioi - Total $5,759.20 $0.00 07aug063rd Qtr 2007 xls 13002 95174 $0.00 $0,00 $3,772.00 $2,075.50 3.77100 $0.00 $0.00 $0.00 $5,781.00 $0.00 $45,072.00 $0.00 $915.00 36.60 $2,075.50 (21,678.50) 25,326.00 7,911.50 11,564.00 0 00 $1,403.00 518,50 0.00 $902.80 4,432.41 6,226.50 1,744.00 152.50 14,223.75 166,716.75 8,599 50 24,319.00 12,505.00 216.00 28,810.00 51 379.50 $0.00 $0.00 $3,772.00 $5.846.50 $0.00 $0.00 $0.00 $5,781 00 $0 00 $45.072.00 $0.00 $951,60 $25,198.50 $1,921.50 $320,227.71 $0.00 $0.00 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - THIRD QUARTER, 2007 492 CTS-FD-CT SERV-ADOPTIONS 505 CTS-FD-JUDICIAL 506 CTS-FD-JUDICIAL SUPPORT 483 CTS-FD-JUDICIAL SUPPORT-ADM 484 CTS-FD-JUVENILE REFEREES 474 CTS-FD-JUVENILE SUPPORT 499 CTS-GJ-ASSIGNMENT 420 CTS - GJ - FAMILY SUPPORT 496 CTS - GJ 498 CTS-GEN JURIS-JUDICIAL SUPPT 500 CTS-GJ-MEDIATION 493 CTS-JUDICIAL ADMIN 730 DRAIN COMMISSIONER 900 EMERGENCY RESPONSE & PREPAREDNESS 740 EQUALIZATION 95173 CTS-FD-Ct Serv-Adootions CTS-FD-Ct Serv-Adoptions - Total 95185 CTS-FD/ADMIN-Family Judges CTS-FO-Judicial - Total 95187 CTS-FD/Adrnin - Fam Supot Staff CTS-FD-Judicial Suport - Total 24009 SQL Serv Supp - CTS-Jud Sup Adm - 3.5% 95193 CTS-FD-Judicial Suport-Adm CTS-FD-Judicial Suport-Adm - Total 95191 CTS-FD-Admin-Juvenie Referees CTS-FD-Juvenile Referees - Tota[ 95474 CTS-FD-Admin-Juvenile Support CTS-FD-Juvenile Support - Total 95180 CTS-GJ-Assignment CTS-GJ-Assignment - Total 95195 Cir Crt Admin Courts - GJ - Family Support - Total 95203 CTS - OW Maintenance CTS - GJ - Total 95179 CTS -Gen Juris-Juaicial Suppt CTS -Gen Juris-Juuicial Suppt - Total 95181 CTS-GJ-Mediation CTS-GJ-Mediation - Total CTS-eFiling - 50% CTS-Judicial Admin CTS-Judicial Admin - Total 24003 SQL Server Supp - Drain 3.5% 28009 Drain Administration 28211 Drain Commissioner Application 35520 GIS Implementation Support Drain 35521 OCDC Application - H/W Support 95669 Water & Sewer Accounting Drain Commissioner - Total 36545 GIS Implementation Support EMS 36546 ERP Application - H/W Support 93990 Emergency Response ERP - Total 20001 IDMS Support-Equalization - 40% 23012 Oracle Support-Equalization - 5.2% 24006 SQL Server Supp-Equalization - 10.5% 31075 Equal - Development 36506 GIS Implementation Support Equalization 36506 Equal Application - H/VV 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 755 FACILITIES MANAGEMENT 91500 FM - System Support Facilities Mgmt - Tota' Prepared by: Information Techeclogy: 8/6/2007 07aug063rd Otr 2007.xls $13,297.21 4,432.41 1,037.75 61,611.00 30,440.00 2,928.00 0.00 0.00 526.50 0.00 39,499.06 19,749.53 $451.40 2,332.00 0.00 810.00 $4.432.41 8,302.00 0.00 316,840.50 0.00 $4,432.41 1,037.75 0.00 2,888.20 1.103.00 39,499.06 $651.00 $0.00 $2.075.50 17.699.25 $122.00 $173,521.46 $3,593.40 $329,574.91 $48,960.42 $651.00 $0.00 $19,774.75 $8,881.50 $1.897.00 $244.00 $73.20 • INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER, 2007 660 FISCAL SERVICES ADMIN 840 HEALTH DIVISION 843 HEALTH - ENVIRONMENTAL 680 HUMAN RESOURCES 907 LIBRARY - ADMIN 641 MATERIALS MGMT-GEN SUPPORT SERV 872 MEDICAL EXAMINER 710 MSU EXTENSION - OAKLAND 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. 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 23014 Oracle Support-HR/Personnel - 5.2% 24007 SQL Server Suppport-PR/Personnel - 1.75% 44042 HR-Systems Maintenance 44044 HR-New Development 95556 HR User Supt 96002 Human Res-Personnel 40% Human Resources - Total 01405 Library Board Library Admin - Total 95440 Materials Management Materials Mgmt-Gen Fund - Total 24002 SQL Server Support - Medical Exam - 3.5% 87202 Medical Examiner - Customer Support Medical Examiner - Total 95576 MSJ Ext Equipment Maintenance MSU Extension - Oakland - Total $122.00 775 PLANNING & ECONOMIC DEVELOPMENT 512 PROB-ESTATES/MENTL HLTH IMAGE 509 PROB-JUDICIAL ADMIN 510 PROB-ESTATES/MENTL HLTH SUPPORT 481 PROBATE-FD JUDICIAL 95786 PEDS DW Support 95787 PEDS - DW Maintenance PEDS - Total 95207 Prob-Est/Mntl Hlth Image Prob-Est/Mntl Hlth Image - Total 24310 SQL Serv Supp-PCT-Est/Mental - 3.5% 92198 Prob-Est/Mntl Hlth Support Prob-Est/Mntl Hlth Support - Total 95168 Prob-FD Judicial Prob-FD Judicial - Total $0.00 244.00 $73.20 $2.075.50 6.806.00 $1,897.00 95165 PC-Judicial Admin-Admin Serv $0.00 Prob-Judicial Admin - Total $0,00 479 PROB-FD-JUDICIAL SUPPORT 95188 PROB-FD Judicial Support $0.00 PROB-FD Judicial Support - Total $0.00 Prepared by Information Technology: 8/612007 07aug063rd Qtr 2007.xls $3.00 0.00 $0.00 44026 PUR-System/Customer Support 44027 PUR-System Maintenance Purchasing - Total 690 PURCHASING 637 RECORDS RETENTION 650 REIMBURSEMENT 195 SHERIFF 191 SHERIFF - CLEMIS 445 SUPPORT SERVICES 600 TREASURER $10,919.00 $5,238.00 $96,128.20 $4,737.41 $15,781.42 $98,420.71 $0.00 10.919 00 $0.00 4,018.00 1.220,00 $0.00 2,216.20 79,610.50 12,032.00 2,269.50 $4,43241 305.00 $4,432.41 4,151.01 7,198.00 $4,432.41 8,864.80 0.00 14,637.00 8,599.50 2,601.00 8,655.50 0.00 14,396.00 4,143.00 854.00 3 1 ,237.50 0.00 $0.00 910 VETERANS SERVICES 95651 Veterans Gust Support $341.00 (45.75) 10 552.25 $10,847.50 $0.00 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - THIRD QUARTER, 2007 145 PROSECUTOR -GENERAL PROSECUTION 24016 SQL Server Supp - Proescutors 3.5% 95622 Prosecutor/Executive 97001 Prosecutor Data Prop Prosecutor - Total $2.075.50 18.421.00 5,172.00 $25,668.50 44052 Rep-System Maintenance 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/Crimmal 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 / CLEMlS - 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 - H/W Support 36602 Land System Enhancements - Treas (50%) 44061 Tre-System/Customer Support 44062 Tre-System Maintenance 44064 Tre-New Development 44080 Tre-DW Support 44082 Tre-DW Maintenance 95008 Del Tax On Line 95303 Del Tax System Maintenance 95561 User Support/Del Tax Treasurer - Total Veterans Services - Iota $0.00 540 52/1 DISTRICT COURT - NOVI 14002 CTS-DW Support-5211 - 6.25% 15002 CTS-DW Maint 52/1 - 6.25% 95527 DC Suort- 52/1 - 25% 52/1 District Court - Total 541 52/1 DISTRICT COURT - NOVI - PROBATION 94542 DC Probation Support - 5211 - 25% 52/1 District Court - Probation - Total $0.00 550 52/2 DISTRICT COURT - CLARKSTON 14003 CTS-DW Support-52/2 - 6 25% 15003 CTS-DW Maint 52/2 - 6.25% 95528 DC Suprt- 52/2 - 25% 52/2 District Court - Total $341.00 (45.75) 10.552.25 $10,847.50 551 52/2 DISTRICT COURT - CLARKSTON - PROBATIC 94552 DC Probation Support - 52/2 - 25% $0.00 52/2 District Court - Probation - Total $0.00 Prepared by: Information Technology: 616/2007 07aug063rd Otr 2007.xls $4.432.41 2.168.00 $0.00 $6,600.41 $0.00 44057 GAR - Systems Maintenance 44058 GAR - Systems Enhancements Garage - Total 655 GARAGE $0.00 0.00 $0.00 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - THIRD QUARTER, 2007 560 52/3 DISTRICT COURT - ROCHESTER 14004 CTS-DW Support-52/3 - 6.25% 15004 CTS-DW Maint 52/3 - 6.25% 95529 DC Suprt - 52/3 - 25% 52/3 District Court - Total $341.00 (45.75) 10 552.25 $10,847.50 561 ,§2/3 DISTRICT COURT - ROCHESTER - PROBATK 94562 DC Probation Support - 52/3 - 25% 52/3 District Court - Probation - Total $0.00 $0.00 530 5214 DISTRICT COURT - TROY 531 52/4 DISTRICT COURT- TROY - PROBATION cust # DIRECT FUNDS 14005 CTS-DW Support-52/4 - 6.25% 15005 CTS-CW Maint 52/4 - 6.25% 95530 DC Suprt- 52/4 - 25% 52/4 District Court - Total 94532 DC Probation Support - 52/4 - 25% 52/4 District Court - Probation - Total $341.00 (45.75) 10 552.25 $10,847.50 $0.00 $0.00 055 CLEMIS 20003 IDMS Support - 5 6% $451.40 23018 Oracle Support - Sheriff CLEMIS 5.2% 4,432 30 24004 SQL Server Support - 24 5% 14,528.50 90507 CAD Customer Support 0.00 95409 CRISNET/GLEMIS LRM 0.00 95430 CLEMIS Maintenance 799150 95431 CLEWS Enhancements 0.00 95432 CLEMIS Adhoc Reports 0.00 98003 CLEMIS User Support 35 100 00 CLEMIS - Total 056 CLEMIS FUND 63500 63500 CLEMIS Fund $1,342 00 CLEMIS 63503 Fund - Total 096 CLEMIS 2005 IBIS GRANT 63596 2005 Federal Approp - IBIS Project $610.00 CLEMIS 2005 IBIS Grant - Total 661 COMMUN & HOME IMPROVEMENT 66103 Comm Dev User Support ($854.00) Commun & Home Improvement - Total 719 CLERK/ROD AUTOMATION FUND 95719 Register of Deeds Automation $7,073.50 Clerk/ROD Automation Fund - Total 471 CTS-FOC-EXP-CS ENFORC-IMAGE 92194 CTS-FOC-Exp-CS Enf-Image $146.40 CTS-FOC Exp-CS Enf-Image - Total 470 CTS-FOC-EXP-FAM COUNSELING 92195 CTS-F0C-Exp-Fam Counseling $0.00 CTS-FOC-Exp-Fam Counseling - Total 507 CTS-FOC EXP-CS ENFORCEMENT 92193 CTS-FOC Exn-CD Enforc-Dev $11,565.00 CTS-FOC En-CD Enforc-Dev - Total 210 FIRE RECORDS MANAGEMENT SYSTEM 21010 Fire Records Mgmt Fund 531 $430.50 24001 SQL Server Support - FRMS 3.5% 2,075.50 Fire Records Mgmt - Total $62,503.70 $1,342.00 $610.00 ($854.00) $7,073.50 $146.40 $0.00 $11,565.00 $2,506 00 750 FM&O 21001 FIMO $0.00 24013 SQL Server Supp - FM&O 2,075.50 75503 FM&O Development 335.50 FM&O - Total $2,411.00 757 FM-WK RELEASE/JAIL MGMT/VIDEO CONF 758 FM - JAIL MGMT REPLACEMENT 23004 Oracle Support - 03K Video - 5.2% 75700 Fac Mgmt - Video Arraignments FM-Wk Rel/Jail Mgmt/Video Conf - Total 75800 FM - Jail Mgmt Replacement FM - Jail Mgrrt Replacement - Total Prepared by: Information Technology: 8/6/2007 07aug063rd Qtr 2007.xls INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - THIRD QUARTER, 2007 380 HEALTH IMMUNIZATION - GRANT 3800C Health - Immunization $0.00 Health - Immunization - Total $0.00 662 MAJOR DEPT SUPP PROJ FUND 6820C e-Financial-Peoplesoft Implementation $3,477.00 Major Dept Supp Proj Fund - Total $3,477.00 870 MEDICAL CARE FACILITY 98873 MCF - Support $244.00 MCF - Total $244.00 248 MEDICAL CARE FACILITY - PHARMACY 98248 MCF - Pharmacy $0.00 MCF - Pharmacy - Total $0.00 653 0.C. INTERNATIONAL AIRPORT 36540 GIS Implementation Support-Aviation $61.00 65331 Airport User Support 1 615.00 O.C. International Airport-Total $1,676.00 770 PARKS AND RECREATION 95419 PRADM-Administration 11,262.00 Parks & Recreation - Total $1,262.00 790 RADIO COMMUNICATION 79001 Radio Communications $0.00 Radio Communications - Total $0.00 695 RISK MANAGEMENT 44035 RSK-System/Customer Support $149.00 95695 Risk Management 0.00 Risk Management - Total $149.00 663 SECURITY CAMERA PROJECT fGF) 66300 Security Camera Project ((OF) $26,687.50 Security Camera Project ((OF) - Total $26,687.50 601 TREASURER - DTRF 18010 Treasurer's Office System $3,302.00 Treasurer DTRF - Total $3,332.00 602 TREASURER-100% TAX PAYMT FUND 99002 Treasurer's Office §1,321.00 Treasurer 100% Tax Pmt Fund - Total $1,321.00 656 WATER & SEWER ACCTG 23011 Oracle Supp - Water & Sewer Acct'g - 5.2% $4,432.41 95669 Water & Sewer Acct'g 43 090.00 Water & Sewer Acct'g - Total $47,522.41 850 WORKFORCE DEVELOPMENT 95670 Workforce Development $0.00 Workforce Development - Total $0.00 Prepared by: Information Technology. 8/6/2007 07aug0e3rd Qtr 2007.xls Resolution #07187 August 16, 2007 The Chairperson referred the resolution to the Finance Committee. There were no objections. ziFI2ANCE rg.of4MITTEE / Finance Committee Vote: Motion carried unanimously on a roll call vote August 30, 2007 FISCAL NOTE (MISC. 407187) BY: FINANCE COMMITTEE, MIKE ROGERS, CHAIRPERSON IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - THIRD 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 Third Quarter 2007 Development cost to benefiting departments. 2. The third quarter data processing development charges are $1,468,078.51; imaging development charges are ($81,925.59) for General Fund/General Purpose departments; direct charges to Special Revenue and Proprietary fund departments are $179,398.52, non-governmental imaging development are $146.40, and charges to non-county agencies are $5,479.00. 3. The respective departmental Fiscal Year 2007 budgets are to be amended as specified in the attached detail schedule. Ru nson, County Clerk Resolution #07187 August 30, 2007 Moved by Gosselin supported by Woodward the resolutions (with fiscal notes attached) on the Consent Agenda be adopted (with accompanying reports being accepted). AYES: Burns, Coleman, Coulter, Crawford, Douglas, Gershenson, Gingell, Gosselin, Gregory, Greimel, Hatchett, Jacobsen, KowaII, Long, Middleton, Nash, Potter, Potts, Rogers, Scott, Spector, Suarez, Woodward, Zack, Bullard. (25) 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 on August 30, 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 30th day of August, 2007.