Loading...
HomeMy WebLinkAboutResolutions - 2006.12.14 - 28089MISCELLANEOUS RESOLUTION 106228 November 30, 2006 BY: GENERAL GOVERNMENT COMMITTEE, CHRISTINE LONG, CHAIRPERSON IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FOURTH QUARTER 2006 DEVELOPMENT APPROPRIATION TRANSFER TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS (S.) 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 2006 data processing development charges to be $1,494,376.19 and the imaging development charge to be $118,790.40 for the General Fund/General Purpose County departments; and WHEREAS direct charges to Special Revenue and Proprietary fund departments are $168,758.96, non-governmental imaging development are $17,713.20, and non-county agencies are $3,448.00 for the Fourth Quarter 2006; 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 2006 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. GENERAL GOVERNMENT COMMITTEE GENERAL GOVERNMENT COMMITTEE VOTE: Motion carried on a roll call vote with Coulter and Melton absent. 1st Qtr 2nd Qtr 3rd Qtr 4111 Qtr Oct - Dec an - Mar Apr - June July - Sent Y.T.D. DIVISION ACCOUNT # GOVERNMENTAL FUNDS General Fund 11011 101004020201-121020-773630 10100-3020205-113290-773630 10100-3020301-121020-773630 10100-3020305-113290-773630 10100-3020401-121020.773630 10100-3020405-113290-773830 10100-3020501-121020-773630 10100-3020505-113290-773630 10100-1070801-114000-773630 10100-1010201-181010-773630 10100-5010101-180010-773630 10100-2010201-180000-773630 10100-2010301-185010-773430 10100-2010501-125000-773630 10100-2010210-125000-773630 10100-2010401-172190.773630 10100-2010205-132300-773630 10100.1090101-171000-773830 10100-1070401-113000-773830 10100-1010501-181020-773830 10100-3010201-121110-773630 101.00-3010401-121240-773830 10100-3010403-121230-773630 10100-3010402-121100.773630 10100-3010402-135080-773530 10100-3010401-121220-773630 10100-3010403-121100.773630 10100-3010301-121140-773630 10100-3010301-121160-773630 10100-3010301-121220.773630 10100-3010301-121110-773630 10100-3010301-121130-7731330 10100.3010301-121150-773630 10100-3010101-121100-773830 10100-1010101-181000-773630 10100-6010101-155010-773830 10100-1010115-115090-773630 10100-1020501-173010-773630 10100-1040101-140000-773630 10100-1020801-182020-773630 10100-1050401-183010-773630 10100-5010303-165040-773630 10100.1030850-184030-773630 10100-1070601-132030-773630 10100-1070501-174000-773630 10100-1090201-171000-773830 10100-3040101-121080-773630 10100-3040403-124010-773630 10100-3040101-121080-773830 10100-3040101-121070-773830 10100-4010101-122050-773630 10100-1020401-152090-773830 10100-1030803-184020-773630 10100-1020701-126020-773630 101004030301-112590-773630 10100-4030801-110000-773630 10100-1030803-184030-773630 10100-7010101-188040-773630 Health Fund 12211 20221-1080201-133150-773630 20221-10130220-134390-773630 540 101 541 101 550 101 551 101 560 101 581 101 530 101 531 101 630 101 820 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 501 101 420 101 498 101 498 101 500 101 493 101 015 101 730 101 900 101 740 101 755 101 66(1 101 600 101 907 101 641 101 872 101 710 101 775 101 509 101 510 101 481 101 479 101 145 101 690 101 837 101 850 101 195 101 191 101 445 101 800 101 640 221 843 221 ,I0venile Maintenance Fund 1293j 685 293 20293-1080501-112090-773630 63600-1080101-152000-631365 GOVERNMENTAL IMAGING 722 10100-2010210-125000-773839 512 10100-3040403-124010-773839 63600-1060101-152000-1330903 SUB-TOTAL GOVE 101004090101496030-773630 INFORMATION TECHNOLOGY DATA PROCESSING DEVELOPMENT SUMMARY 4TH QUARTER 2006 52/1 - Distnct Court 52/1 - District Court - Probation 52/2 - DIstnct Court 52/2 - District Court - Probation 52/3 - Dislnct Court 52/3 - District Court - Probation 52/4 - District Court 52/4- District Court - Probation Animal Control Auditing Board of Commissioners Cleric - Admin Cleric - Elections Clerk - Jury Commission Clerk - Legal Records Clerk - Register of Deeds Clerk - Vital Statistics Economic Development & Community Affaks Community Correcttons Admin Corporation Counsel Courts-Business Division Courts-FD Juvenile Support Courts-FD Juvenile Referees Courts-PO-Court Services-As:1min Courts-FD-Court Services-Adoptions Courts-FD-Judicial Support Courts-PO-Judicial Support-Admin Courts-GJ-Assignment COURTS GJ-Criminal Case Support Courts-GJ-Family Support Courts-General Jurisclictior. Courts-GJ-Judicial Support CourtS-GJ-Mediation Courts - Judical / Administration County Executive Drain Commissioner Emergency Response & Prep Unit Equalization Division Fackkies Management Fiscal Services - Adrnin Human Resources Library Admin Materials Management - Gen Fund Medical Examiner MSU Extension - Oakland Planning & Economic Development Probate - Judicial Admin Probate-Estates/Mental Health Support Probate-FD-Judicia. Probate-PO-Judicial Support Prosecuting Attorney - General Prosecution Purchasing Records Retention Reknbursement Division Sheriff Sheriff - CLEM'S Support Services Treasurer Sub-Total Fund 101 1-4ealth Health Environmental Sub-Total Fund 221 Children's Wage Sub-Total Fund 293 DATA PROCESSING DEVELOPMENT FOR GOVERNMENTAL FUND APPROPRIATION Clerk Image Probate-Estates/Mental Health Image 910,756.64 $804563 $5,841.53 $11266.15 $35.909,95 $4,208.75 51,185.88 $1,871.50 $0.00 $7,06813 $1075664 $8.04563 $5,841.53 $11,256.15 $35,909.95 $4.208.75 $1,185.88 $1,671.50 $0.00 $7.066.13 $10,756.64 $8,045.63 $5.841.53 $11286.15 $35,909.95 $4,205.75 $1,185.86 $1,671.50 $0.00 $7,066.11 $10,756 55 $8,045.61 $5,841.53 $11,266.17 $35,909.89 $4,208.75 51.185.88 $1,671.50 $0.00 $7.066.13 $75,017.90 $25,542.00 $25,948.00 $25,985.00 $153,470.00 5366.00 50.00 5244.00 50.00 $5810.00 $6,679.50 $1.095.00 $2.379.00 $2,318.00 $12,474.50 $0.00 $0.00 $6,941.00 $5,833.00 $12,774.00 $44,468.00 $5,897.00 $18,270.00 $39,048.00 $67,583.00 $7.383.93 $7,755.08 $7,605.48 $9,485.40 $32.289.89 $24.014 00 $36.451.00 $29,626.50 $20,913.50 $111,007.00 $3506.20 $5,755.20 $2,236.00 $5187.50 $16,684.90 52.20000 53,977.50 $9,128.50 537,760.50 $53,154.50 53,541 50 52,806.00 $3,740,50 $35,835.00 $40,023.00 $31,340.93 $88,499.58 $78,358,46 535,911.40 $214,108.39 $1,732.00 $4138.00 $1,403.00 $1,220.00 $4.843.00 $2,587.03 $9,359.54 $9,274.12 $14,950,58 $36,151.27 50.00 $0.00 $11,192.00 $0.00 $11,192.00 $0.00 $0.00 $0.00 $0.00 $000 $0.00 $0,00 $0.00 $0.00 $0.00 $7,529.00 50.00 $0.00 $0,00 $7,529.00 57.814.00 $3,024.00 $8,114.50 $729.00 $19,681.50 $4,367.31 $5.104.16 s8,465./1 $4,878.11 $22,837.69 $2.391.00 $805.00 $22,257.00 $915.00 $6,368.00 $0,00 $4,725.00 $1,690.00 $0.00 $6,415.00 $6,744.00 $9,857.50 $9,218.00 $3,965.00 $29,584.50 $32400 $385.08 $1 62.00 $0.00 $871.00 520,026.50 528,902.50 $45.589.00 $23,552.00 $118,070.00 56.890.00 $1,259.00 $5,929.50 $44,956.00 $19,034.50 $32,330.25 $22,453 55 $22,237.45 59,135.55 586.158.80 $0.00 $o oo 50.00 $0.00 $0.00 $59.585.00 $91,503.00 $52259.50 $60,355.50 $263,703.00 $2,897.50 $1,830.00 $2,196.00 $8,235.00 $15,158.50 $100,586.44 $86,140.81 $97.647.71 $86,700.51 5371.075.57 $0.00 $0.00 $00.00 $0.00 $0.00 $1313,552.29 $197.114.87 $301,408.52 $271,931.79 $909,007.47 $55,378.62 $97,217.66 $99,736.32 $102,556.56 $354,869.16 $0.00 $0.00 $1,647.00 $1,098.00 $2,745.00 $0.00 $0,00 $24.40 $00.00 $24.40 $77,160 1' 580.035.33 $65,708.23 $30.292.21 $273,195.88 $0 00 $0,00 $0,00 $0.00 $0.00 $108.00 $0.00 $366.00 $81.00 $535.00 $461.07 $7,622.50 $0.00 $0.00 $8,083.57 $3,388.28 $3.697.17 $5,658.10 $3,886.10 518,629.65 5190.00 5528.00 $1,150.00 $1,162.00 $3,030.00 $0.00 $0.00 $0.00 $0 00 $0.00 523,397.17 546,289.60 $18,941.00 514,423.00 $103,050.67 $44,212.00 50.00 $0.00 $0.00 $44,212.00 $9,696.00 $15,414.00 518,542.00 $12,877.00 $58,529,90 $11.691.00 $6,171.00 $22,001.20 $85,418.40 $95,281.60 $76.052.96 $59,938.04 $97.035.24 $91,063.70 $324,090.84 527.343.41 $10,210.00 $10,862.99 $9,149.36 $57,555.76 $7.725 93 $4,986.05 $15,068.08 $13,084.40 S40,1364 49 $68,541.81 $54,920.08 $85.094.98 $83.629.60 $312.15639 $990,251.26 $1,044.488.65 $1255,488.53 $1,173,547.29 54,472,775.73 $51,628.20 $42,175.70 $29,812.00 520,088.00 5143,683.90 5343.181.43 $342,238.58 1414.636.98 17,22,761.20 51299.615.69 $394,809.83 $384,412.28 $344,447.98 $319,829.90 $1,443,499.79 $44,745.00 $1,458.00 $1.917.00 $999.00 59.119.00 $4,745.00 $1.458.00 $1.917.00 $999.00 $9.119.00 $1,398.805,89 $1,430,358.93 51,801.853,51 51.494.378.19 Ittala_24. $71,973.18 $54.738.23 $58.852.83 $116,748.80 $302,313.04 $2.0131.00 $3.480.60 53.183 40 $2.041.80 $10.708.60 TOTAL GOVERNMENTAL IMAGING $74.054.18 $58,218.83 582,038.23 5118.790,40 $313499.64 DEVELOPMENT APPROPRIATION RNMENTAL / IMAGING DEVELOPMENT APPROPRIATION: 81,472,800.07 $1,488,577.76 $1,663,1159.74 $1,613,166.59 $6,235,494,16 Information Technology Development f$1.472.860.07) 151 488,577.76) f$1,663,889 74) 41.613,166.59) 158238.494 16) TOTAL GOVERNMENT: $0.00 $0.00 ELL/0 $0.00 59,00 Prepared by; Intormaton Tecnnology, 10/6/2006 4th Qtr 2096 xis INFORMATION TECHNOLOGY DATA PROCESSING DEVELOPMENT SUMMARY 4TH QUARTER 2006 ACCOUNT # 1st Otr 2nd Qv 3rd Car 4th Qtr DIVISION Oc: - Dec Jan - Mar Apr - June JO, - Seal Y.T.D. NON-GOVERNMENTAL DIRECT CHARGES 055 CLEMIS $43,070.81 $39,015.23 $38,384.64 $88,538.24 $209,508.92 056 CLEMIS FUND 63500 50.00 $0.00 $0.00 $0.00 $0.00 096 CLEMIS 2005 IBIS Grant $732.02 $549.00 $488.00 $0.00 $1,769.00 719 ClePUROD Automation Fund $21.630.00 $35,624.40 $5,114.00 $108.00 $62,477.00 521 Community Corrections f Grant) $0.00 $0.20 50.00 $2,403.00 $2,403.00 861 COmmunity & Home Improvement $0.00 $0.00 $366.00 $610.00 $976.00 470 Courts-FOC Exp-Family Counseling $0.00 s0.00 s0,90 $0.00 $0.00 507 Courts-FOC Exp-CS Enforcement $976.00 $3,111.00 $4087.00 $894.00 $9,068.00 210 Fire Records Management System $4.985.61 $2,847.83 $4.396.73 $5.367.21 $17,597.38 757 FM-Wk ReV,Jail MetNideo Coot $28,079.93 $12.546.08 $6.912.48 59065.40 $56,603.89 758 FM-Jail Mgmt Replacement $486.00 $954.00 $0.00 $0.00 $1,442.00 750 FM & 0 $1,878.00 $0.00 $2,526.00 $3,023.00 $7,427.00 759 F M & 0-Safely Overhead $0.00 $0.00 $0.00 $0.00 $0.00 655 Gararge $24.014.00 $27,891.00 $6,489.00 $6,139.00 $64,533.00 809 Health - Blo Flu Clinic Grant $0.00 $0.00 $10,914.00 $34,545.50 $45.459.50 380 Health - Immunization Grant $2.556.00 $4266.00 $4,698.00 $2,754.00 $14,284.00 751 IT - Telephone Commumuausns $0.00 $0.00 $0.00 $0.00 $0.00 662 Major Department Support Project Fund $359,632.10 5108.204.20 $19.703.15 $324.00 $487,863.45 870 Medical Care Facility $7,538.51 $3,164.33 $3,800.23 $5,380.21 $19,883.38 248 Medical Care Facility - Pharmacy $0.00 $0.00 $0.00 $0.00 $0.00 651 O.C. International Airport-GRE Grant $0.00 $0.00 $0.00 $0.00 $0.00 653 0.C. International A:rport $683.00 $7,214.00 $1,952.00 $2,135.00 $11.984.00 770 Parks and Recreation . Administration $0.00 $1,082.00 $1,938.00 $1,525.00 54.545.00 790 Radlo Communications $0.00 $0.00 $0.00 $0.00 $0.00 695 Risk Management $0.00 $0.00 $81.00 $244.00 $305.00 602 Treasurer -100% Tax Paymt Fund ($1,485.50) $527.00 ($527.00) $0,00 ($1,455.50) 666 VVater & Sewer Accounting $5.065.93 $6,341.06 $6,567.48 $5,703.40 $23,677.89 850 Workforce Development $0.00 §. P. 22 $0.00 19.22 $0,00 63600-1080101-152000-631302 SUB-TOTAL DIRECT CHARGES FOR DATA $500,354,49 $253,337.75 5117.870,71 5166.756,96 ;1,040.321.91 PROCESSING DEVELOPMENT NON-GOVERNMENTAL IMAGING 471 Courts-FOG Exp-CS Enforcement Image $6,522.50 $10.603.70 $7,527.80 $17,713.20 $42.467.20 63800-1080101-152000-630903 TOTAL NON-GOVERNMENTAL IMAGING $6,622,50 ;10,603.70 57.527.80 $17.71320 $42 467 20 DEVELOPMENT APPROPRIATION TOTAL COUNTY DEVELOPMENT CHARGES $1,979,637.08 $1,752,519.21 $1.769.266,25 51.799.636.75 $7.321263.27 NON-COUNTY AGENCIES 63600-1080101-152000-635017 Non-County Agencies $2,215.00 $1,114.50 $732.00 $3.448,00 57.50050 TOTAL DEVELOPMENT CHARGES $1,982,052.06 51,753,633.71 $1,799,020.25 $1,803,088.75 $7,328,792,77 Prepared by: Information Technology: 1010/2006 4th Qtr 2006.xls $9,086.75 5,093.40 3,699.00 98 889.65 $116,748.80 $5,093.40 4,392.00 $20.913.50 $37,760.50 $5,093.40 29,729.00 1,089.00 $1,220.00 $9,485.40 $20.913.50 $37,760.50 $35,911.40 495 CTS-BUSINESS DIVISION 487 CTS-FD-CT SERV-ADMIN 492 CTS-FD-CT SERV-ADOPTIONS $11,566.13 837.75 2,546.70 $0.00 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - FOURTH QUARTER, 2006 Gust # GOVERNMENTAL FUNDS 005 BOARD OF COMMISSIONERS 91404 BOC-Cust Supt $2,318.00 BOG-Total $2,318.00 630 ANIMAL CONTROL 95628 Web License Registration $4,148.00 95682 Dog System 21.817.00 Animal Control-Total $25.965.00 620 AUDITING 44032 Auditing-System Maintenance $0.00 95468 Auditing-Gust Supt 0,00 Auditing - Total $0.00 665 CHILDRENS VILLAGE 95665 Childrens Village $999.00 Childrens Village - Total $999.00 725 CLERK - ADMIN 72500 Clerk - Admin $5,833.00 Clerk - Admin - Total $5.833.00 440 CLERK -ELECTIONS 95443 Elections $39,048.00 Clerk -Elections - Total $39.048.00 720 CLERK! REGISTER OF DEEDS 20004 IDMS Support - Register of Deeds $976.00 36510 GIS Implementation Support-ROD 91.50 36511 ROD Application - I-11W Support 3,782.00 95493 Reg Deeds System Maintenance 0.00 95162 Clerk - OW Support 338.00 95558 User Support/ROD 0.00 95564 ROD - DW Support 0.00 Clerk/Reg of Deeds - Total $5,187.50 722 CLERK-IMAGING 13001 Clerk - eFiling - 50% 23007 Oracle Support - Clerk Image 65420 Clerk - Image Replace 95158 Clerk - Imaging Clerk - Imaging - Total 410 CLERK - JURY COMMISSION 23008 Oracle Support - Jury Comm 95512 Jury Commission Clerk -Jury Commission - Total 724 CLERK - LEGAL RECORDS 95189 Circuit Court System Clerk - Legal Records - Total 723 CLERK -VITAL STATISTICS 95161 Vital Stats Index Clerk Vital Statistics - Total 522 COMMUNITY CORRECTIONS-ADMIN ICCfl 23003 Oracle Support-Comm Corr 52200 Comm Corr-Admin (County) 52201 Comm Corr-OW Supp Community Corrections - Total 430 CORPORATION COUNSEL 95501 Corporation Counsel Corporation Counsel - Total $1,220.00 14001 DW Support - Circuit Court 15001 OW Maint - Circuit Court 23010 Oracle Support-CCT/CTS Grim Whse CTS-Business Division - Total 95196 CTS-FD-Ct Serv - Admin CTS-FD-Ct Serv-Admin - Total 95173 CTS-FD-Ct Serv-Adoptions $0.00 CTS-FD-Ct Serv-Adoptions - Total $14.950.58 $0.00 $0.00 Prepared by: inrormatton Technology: 101612006 410 Ger 2006.xis 730 DRAIN COMMISSIONER 785 ECONOMIC DEV & COMM AFFAIRS 50.00 18,414.00 21,212.50 20,729.00 0.00 $60.355.50 $122.00 1,769.00 33 944.00 $35,835.00 $5,490.00 2,745.00 0.00 £8,235.00 $1,952.00 5,093.40 4,752.21 0.00 152.50 2,355.00 21,448.00 11,865.00 984.50 13,382.00 24,716.00 $86,700.61 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT SUPPORT DETAIL - FOURTH QUARTER, 2006 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 $729.00 CTS-FD-Judicial Suport - Tota $729.00 483 CTS-FD-JUDICIAL SUPPORT-ADM 24009 SQL Serv Supp - CTS-Jud Sup Mm $2,376 11 95193 CTS-FD-Judicial Suport-Adm 2,50200 CTS-FD-Judicial Suport-Adm - Total $4,878.11 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-Juvenite Support - Total $0.00 471 CTS-F0C-EXP-CS ENFORC4MAGE 92194 CTS-FOC-Exp-CS Enf-lmage $17,713.20 CTS-FOC Exp-CS Enf-Image - Total $17,71120 499 CTS-GJ-ASSIGNMENT 95180 CTS-GJ-Assignment $915.00 CTS-GJ-Assignment - Total $915.00 501 CTS-GJ-CRIMINAL CASE SUPPORT 95182 CTS-GJ-Criminal Case Support $0.00 CTS-GJ-Criminal Case Support - Total $0.00 420 CTS - GJ - FAMILY SUPPORT 95195 Cir Crt Admin $3,965.00 Courts - GJ - Family Support - Total $3,965.00 496 CTS - GENERAL JURISDICTION 95208 CTS - OW Maintenance VAQ CTS - General Jurisdiction - Total $0.00 498 CTS-GEN JURIS-JUDICIAL SUPPT 95179 CTS -Gen Juris-Judicial Suppt $23 552 00 CTS -Gen Juris-Judicial Suppt - Total $23,552.00 500 CTS-GJ-MEDIATION 95181 CTS-GJ-Mediation $4,956,00 CTS-GJ-Mediation - Total $4,956.00 493 CTS-JUDICIAL ADMIN 13002 Courts - eFiling 50% $9,086.75 95174 CTS-Judicial Admin 10% 48.80 CTS-Judicial Admin - Total $9.135.55 740 EQUALIZATION 28007 Drain Commissioner 28011 Drain Commissioner Application 36520 GIS Implementation Support Drain 36521 OCDC Application - H/VV Support 95669 Water & Sewer Accounting Drain Commissioner - Total 36500 GIS Implementation Support C&E Dev 36501 CEO Application - H/W Support 95785 Comm & Eco Developmt Economic Dev & Comm Affairs - Total 20001 IDMS Support-Equalization 23012 Oracle Support-Equalization 24005 SQL Server Supp-Equalization 31075 Equal - Development 36505 GIS Implementation Support Equalization 36506 Equal Application - H/W Support 95559 User Support/Equal 95562 Equalization - OW Support 95570 Equalization - DW Maintenance 95693 Equal-System Maintenance 95699 BS&A Master Appraisal Sup/Maint Equalization - Total 900 EMERGENCY RESPONSE & PREPAREDNES% 36545 GlS Implementation Support ERP 36546 ERP Application - H/VV Support 98990 Emergency Response ERP - Total Prepared by Information Technology; 10/62006 4th QC, 2006.xls 24007 SQL Server Suppport-HR/Personnel 1,915.07 44042 PER-Systems Maintenance 1,962.00 95556 Personnel User Supt 1,077.00 96002 Human Res-Personnel 40% 87,688.56 Human Resources - Total 907 LIBRARY - ADMINISTRATION 91405 Library - Admin $1,098.00 Library - Admin - Total INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - FOURTH QUARTER, 2006 755 FACILITIES MANAGEMENT 91500 FM - System Support $0.00 Facilities Mgmt - Total 660 FISCAL SERVICES ADMIN 23001 Oracle Support - Fiscal Serv $10,186.79 23013 Oracle Support - HR-Acctg/Budget 14,825.42 24006 SQL Serv Supp - HR-Acctg 1,915.07 24008 SQL Serv Supp - Budget 922.07 44021 FS-System/Customer Support 51,792.60 44022 FS-System Maintenance 55,245.50 44023 FS-System Enhancements 3.041.00 44024 FS-New Development 0.00 44077 BUD-System Maintenance 0.00 44079 FS - DW Support 2,470.50 44081 FS - OW Maintenance 0.00 96001 Human Res-Acct 40% 87,688.56 96003 Human Res.-Budget 20% 43,844,28 Fiscal Services Admin - Total 840 HEALTH DIVISION 20002 IDMS Support - CHAMPS $976.00 36525 GIS Implementation Support Health 10,437.00 37025 CHAMPS - POP. 2,970.00 96842 Health Admin 5.68500 Health - Total 843 HEALTH ENVIRONMENTAL 23005 Oracle Support - EH Projects $5,093,40 37002 Environmental 1,972.00 84200 EH - Projects 227,030.00 84300 Ehealth Program 65,666.50 Health-Environmental - Total 880 HUMAN RESOURCES 23014 Oracle Support-HR/Personnel $9,913.93 $0.00 $271,931.79 $20.068.00 $299,761.90 $102,556.56 $1.098.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 $4,752.21 87202 Medical Examiner - Customer Support 25.540.00 Medical Examiner - Total 710 MSU EXTENSION - OAKLAND 95676 MSU Ext Equipment Maintenance $0.00 MSU Extension - Oakland - Total 775 PLANNING & ECONOMIC DEVELOPMENT 95786 PEDS - DW Support $61.00 REDS - Total 512 PROB-ESTATES/MENTL HLTH IMAGE 95207 Prob-Est/Mntl Hlth Image $2,041.60 Prob-Est/Mntl Filth Image - Total 509 F'ROB-JUDICIAL ADMIN 95165 PC-Judicial Admin-Admin Serv $0.00 Prob-Judicial Admin - Total 510 PROB-ESTATES/MENTL HLTH SUPPORT 24010 SQL Serv Supp-PCT-Est/Mental $2,376.10 92198 Prob-Est/Mntl Hlth Support 1,510.00 Prob-Est/Mntl Hlth Support - Total 481 PROBATE-FD JUDICIAL 95168 Prob-FD Judicial $1,162.00 Prob-FD Judicial - Total 95188 PROB-FD Judicial Support PROB-FD Judicial Support - Total 479 PROB-FD-JUDICIAL SUPPORT $0.00 $30,292.21 $0.00 $61,00 $2,041.60 $0.00 $3,886.10 $1,162.00 $0.00 Prepared by Information Tachnoiogy, 1016/2046 4th Qtr 2006.xls 44052 44054 95636 95469 95470 95542 $14,423.00 $0.00 $12,877.00 $55418.40 14002 15002 95527 $11.266.15 OW Support - 52/1 OW Maint -52/1 DC Suprt-25%-52/1 52/1 District Court - Total 540 5211 DISTRICT COURT • NOVI $963.84 69.81 10 232.50 $0.00 $0.00 14003 15003 95528 $11,266.15 $963.84 69,81 10,232.50 550 52/2 DISTRICT COURT - CLARKSTON DW Support - 52/2 OW Maint - 52/2 DC Suprt-25%-5212 52/2 District Court - Total 551 52/2 DISTRICT COURT CLARKSTON - PROBA 94552 DC Probation Support - 52/2 - 25% 52/2 District Court - Probation - Total $0.00 $0.00 14004 15004 95529 $11,266.15 6963.84 69.81 10,232.50 560 52/3 DISTRICT COURT- ROCHESTER DW Support - 52/3 DW Maint - 52/3 DC Suprt-25%-52/3 52/3 District Court - Total INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2006 145 PROSECUTOR - GENERAL PROSECUTION 690 PURCHASING 637 RECORDS RETENTION 650 REIMBURSEMENT 195 SHERIFF 191 SHERIFF - CLEMIS 445 SUPPORT SERVICES 600 TREASURER 95622 Prosecutor/Executive 97001 Prosecutor Data Proc Prosecutor - Total 44026 PUR-System/Customer Support 44027 PUR-System Maintenance Purchasing - Total Rec-System Maintenance Rec-New Development Mail Room Records Retention - Total Reimbursement State Mandate Reimbursement System Reimburse User Support Reimbursement - Total 23009 Oracle Suppport - OCSD/CTS Grim Whse 97163 Sheriff 97164 Sheriff-Development 97165 Sheriff-DW Support 97166 Sheriff-OW Maintenance Sheriff - Total 23015 Oracle Suppport - Sheriff! CLEMIS 96163 Sheriff - CLEMIS Sheriff - CLEMIS - Total 23002 Oracle Support - Supp Serv 44500 Support Services Support Services - Total 23006 Oracle Support - Del Tax 36515 GIS Implementation Support-Treasurer 36516 Treasurer Application - I-1/W Support 44061 Tre-System/Customer Support 44062 Tre-System Maintenance 44064 Tre-New Development 44080 Tre-OW Support 44082 Tre-DW Maintenance 95008 Del Tax On Line 95303 Del Tax System Maintenance 95561 User Support/Del Tax Treasurer - Total $14,423.00 0.00 $0.00 0.00 $0.00 12,877.00 0.00 $20,524.60 29,709.80 5184,00 $2,546.70 70,402.50 0.00 11,756.00 6,358.50 $5,093.36 4,056.00 $5,093.40 7,991.00 $5,093.40 427.00 32,921.00 1,693.60 11,727.00 2,440.00 16,582.50 756.00 732.00 11,257.00 0.00 $91,063.70 $9,149.36 $13,084.40 $83,629.50 541 5211 DISTRICT COURT - NOVI - PROBATION 94542 DC Probation Support - 52/1 - 25% 52/1 District Court - Probation - Total P1131)afflitl by Information Technology. 10/6/2006 4tn Ott 2006.xls $11,266.17 530 5214 DISTRICT COURT - TROY $963.85 69.82 10.23250 14005 DW Support - 52/4 15005 DW Maint - 52/4 95530 DC Suprt-25%-52/4 52/4 District Court - Total INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2006 561 5213 DISTRICT COURT - ROCHESTER - PROBA- 94562 DC Probation Support - 5213- 25% $0.00 52/3 District Court - Probation - Total $0.00 531 52/4 DISTRICT COURT - TROY - PROBATION 94532 DC Probation Support - 52/4 - 25% $0.00 5214 District Court - Probation - Total $0.00 Gust # DIRECT FUNDS 055 LEMIS 20003 IDMS Support $976.00 24004 SQL Server Support 42.415,24 95409 CRISNET/CLEMIS LRM 0.00 95430 CLEMIS Maintenance 11,343.00 95431 CLEMIS Enhancements 0.00 98003 User Support - UE 33 804.00 CLEMIS - Total $88,538.24 056 CLEMIS FUND 63500 63500 CLEMIS Fund $0.00 CLEMIS Fund - Total $0.00 096 gums 2005 IBIS GRANT 63596 2004 Federal Approp - IBIS Project $0.00 CLEMIS 2005 IBIS Grant - Total $0.00 719 CLERK/ROD AUTOMATION FUND 95719 Register of Deeds Automation $108.00 Register of Deeds Automation - Total $108.00 521 COMMUNITY CORRECTIONS • ADMIN 1GRANTI 52102 Community Corr - COMPAS App $2 403 00 Community Corr - Admin (Grant) - Total $2,403.00 661 COMMUNITY & HOME IMPROVEMENT 66103 Community & Home Improvement $610.00 Community & Home Improvement - Total $610.00 470 CTS-FOC-EXP-FAM COUNSELING 92195 CTS-FOC-Exp-Fam Counseling $0.00 CTS-FOC-Exp-Fam Counseling - Total $0.00 507 CTS-FOC EXP•CS ENFORCEMENT 92193 CTS-FOC Exp-CD Enforc-Dev $894.00 CTS-FOC Exp-CD Enforc-Dev - Total $894.00 210 FIRE RECORDS MANAGEMENT SYSTEM 21010 Fire Records Mgmt Fund 531 $615.00 24001 SQL Server Support - FMS 4,752.21 Fire Records Mgmt - Total $5,367.21 750 FM&O 21001 FM&O $647.00 75503 FM&O Development 2 376.00 FM&O - Total $3.023.00 757 FM-WK RELEASE/JAIL MGMTNIDEO CONF 23004 Oracle Support - Oak Video $5,093.40 75700 Fac Mgmt - Video Arraignments 3.972.00 FM-Wk ReVJail MgmtNideo Conf - Total 69,065.40 758 FM - JAIL MGMT REPLACEMENT 75800 FM - Jail Mgmt Replacement $0.00 FM - Jail Mgmt Replacement - Total $0.00 655 GARAGE 44057 GAR - Systems Maintenance $6.139.00 44058 GAR - Systems Enhancements 0.00 Garage - Total $6,139.00 809 HEALTH - BIO FLU CLINIC GRANT 80900 Health - Bio Flu Clinic $34,545.50 Health - Bio Flu Clinic - Total $34.545.50 380 HEALTH IMMUNIZATION - GRANT 38000 Health - Immunization $2 754 00 Health - Immunization - Total $2754.00 Prepared by Information Technology; 10/6/2006 4111 Qtr 2006.xls 850 WORKFORCE DEVELOPMENT 95670 Workforce Development $0.00 Workforce Development - Total $0,00 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2006 662 MAJOR DEPT SUPP PROJ FUND 66200 e-Financial-Peoplesoft Implementation $324,00 Major Dept Supp Proj Fund - Total $324.00 870 MEDICAL CARE FACILITY 24003 SQL Server Support - MCF $4,752.21 98873 MCF - Support 628.00 MCF - Support - Total $5,380.21 248 MEDICAL CARE FACILITY - PHARMACY 98248 MCF - Pharmacy $0.00 MCF - Pharmacy - Total $0.00 653 O.C. INTERNATIONAL AIRPORT 36540 GIS Implementation Support-Aviation $1.220.00 65301 Airport User Support 915.00 0.C. International Airport - Total $2,135.00 770 PARKS AND RECREATION 36530 GIS Implementation Support-Parks $854.00 95419 PRADM-Administration 671.00 Parks & Recreation - Total $1,525.00 no RADIO COMMUNICATION 79001 Radio Communications MILO Radio Communications - Total $0.00 695 RISK MANAGEMENT 44036 RSK-System/Customer Support $244.00 95695 Risk Management 0.00 Risk Management - Total $244,00 602 TREASURER-100% TAX PAYMT FUND 99002 Treasurer's Office MILO Treasurer's Office - Total $0.00 656 WATER & SEWER ACCTG 23011 Oracle Supp - Water & Sewer Acct'g 95669 Water & Sewer Acct'g Water & Sewer Acct'g - Total $5,093.40 610.00 $5,703.40 Prepared by: Information Technorogy; 10/612406 415 Qtr 2006.45 Resolution #06228 November 30, 2006 The Chairperson referred the resolution to the Finance Committee. There were no objections. FISCAL NOTE (MISC. #06228) December 14, 2006 BY: FINANCE COMMITTEE, CHUCK MOSS, CHAIRPERSON IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FOURTH QUARTER 2006 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 2006 Development cost to benefiting departments. 2. The fourth quarter data processing development charges are $1,494,376.19; imaging development charges are $118,790.40 for General Fund/General Purpose departments; direct charges to Special Revenue and Proprietary fund departments are $168,758.96, non-governmental imaging development are $17,713.20, and charges to non-county agencies are $3,448.00, 3. The respective departmental Fiscal Year 2006 budgets are to be amended as specified in the attached detail schedule. FINANCE COMMITTEE i) FINANCE COMMITTEE Motion carried on a roll call vote with Rogers absent. e(--z- I MY APPROVE THE FOREGOING MOTION Ruth Johnson, County Clerk Resolution 06228 December 14, 2006 Moved by Molnar supported by Gregory the resolutions (with fiscal notes attached) on the Consent Agenda, be adopted (with accompanying reports being accepted). AYES: Coulter, Crawford, Douglas, Gershenson, Gregory, Hatchett, Jacobsen, Jamian, KowaII, Long, Melton, Middleton, Molnar, Moss, Nash, Palmer, Potter, Rogers, Scott, Suarez, Wilson, 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 on December 14, 2006, 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 14th day of December, 2006.