Loading...
HomeMy WebLinkAboutResolutions - 2005.12.08 - 27792MISCELLANEOUS RESOLUTION f05272 November 10, 2005 BY: GENERAL GOVERNMENT COMMITTEE, WILLIAM PATTERSON, CHAIRPERSON IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FOURTH QUARTER 2005 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 2005 data processing development charges to be $1,153,545.72 and the imaging development charge to be $63,928.34 for the General Fund/General Purpose County departments; and WHEREAS direct charges to Special Revenue and Proprietary fund departments are $579,216.49 and non-county agencies are $0 for the Fourth Quarter 2005; 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 Commi;sioners has reviewed the Fourth Quarter 2005 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. GENERALOVERNMENT COMMITTEE 0- w General Government Committee Vote: Motion carried on a roll call vote with Long, Hatchett and Molnar absent. ACCOUNT # DIVISION 1st Otr Oct - Dec 2nd Qtr Jan-Mar 3rd Ott Apr - June 4th OW Jul,/ - Seot Y.T.D. GOVERNMENTAL FUNDS General Fund 11011 2-32-201200-20001-6030 2-32-205200-20006-6030 2-32-301200-20001-6030 2-32-305200-20006-6030 2-32-401200-20001-6030 2-32405200-20006-6030 2-32-501200-20001-6030 2-32-505200-20006-6030 2-17-802200-80001-6030 2-11-220100-10000-6030 2-51-211000-10000-6030 2-21-220100-10000-6030 2-21-230100-31000-6030 2-21-250100-01000-6030 2-21-221000-01000-6030 2-21-240100-11000-6030 2-21-220500-40000-6030 2-19-210000-10000-6030 2-17402200-70001-6030 2-11-250100-20000-6030 2-35-220000-12000-6030 2-35-244000-33000-6030 2-35-243000-32000-6030 2-35-242000-11000-6030 2-35-242000-44000-6030 2-35-244000-31200-6030 2-35-243000-11000-6030 2-35-230000-22100-6030 2-36-230000-31200-6030 2-35-230000-12000-6030 2-35-230000-21200-6030 2-35-230000-22200-6030 2-35-210000-11000-6030 2-11-210100-01000-6030 2-61-211001-10000-6030 2-11-101112-65001-6030 2-12-240000-41000-6030 2-14-210000-10000-6030 2-12-601200-25000-6030 2-15-402200-10001-6030 2-13-138502-15100-6030 2-17-912000-15000-6030 2-17-501200-50000-6030 2-19-221000-10000-6030 2-34-10120040001-6030 2-34-40320040005-6030 2-34-101200-31100-6030 2-34-101200-31200-6030 2-41-21100041700-6030 2-1240120040010-6030 2-13-138203-12000-6030 2-12-701200-34000-6030 243-023301-20000-6030 243-023601-30000-6030 2-13-138203-15100-6030 2-22-221120-01000-6030 Health Fund 12211 2-16-201200-33100-6030 2-16-220200-67000-6030 18-636111-10000-0735 IMAGING 722 2-21-221000-01000-6039 512 2-34403200-40005-6039 18-636111-10000-0573 INFORMATION TECHNOLOGY DATA PROCESSING D4VELOI‘MENT SUMMARY 4TH QUARTER 2005 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 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 680 101 641 101 872 101 710 101 775 101 509 101 610 101 481 101 479 101 145 101 690 101 637 101 650 101 195 101 191 101 445 101 600 101 840 221 843 221 665 293 5211 - District Court 52/1 - District Court - Probation 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 Commission Clerk - Legal Records Clerk - Register of Deeds Clerk - Vital Statistics Community & Economic Development Community Corrections Admin Corporation Counsel Courts-Business Division Courts-FD Juvenile Support Courts-FD Juvenile Referees Courts-FD-Court Services-Admin Courts-FD-Court Services-Adoptions Courts-PD-Judicial Support Courts-FD-Judicial Support-Admin Courts-GJ-Assignment Courts-GJ-Family Support Courts-GJ-JIMS Courts-GJ-Judicial Support Courts-GJ-Mediation Courts - Judical Administration County Executive Drain Commissioner Emergency Response & Prep Unit Equalization Division Facilities Management Fiscal Services - Admin Human Resources Materials Management - Gen Fund Medical Examiner MSU Extension - Oakland Planning & Economic Development Probate - Judicial Admin Probate-Estates/Mental Health Support Probate-FD-Judicial Probate-FD-Judicial Support Prosecuting Attomey - General Prosecution Purchasing Records Retention Reimbursement Division Sheriff Sheriff - CLEM1S Support Services Treasurer Sub-Total Fund 101 Health Health Environmental Sub-Total Fund 221 DATA PROCESSING DEVELOPMENT FOR GOVERNMENTAL FUND APPROPRIATION Clerk Image Probate-Estates/Mental Health Image TOTAL IMAGING DEVELOPMENT APPROPRIATION $8,754.63 $7,765.65 $6,451.45 $7,287.25 $30,258.98 $30.50 $2,266.25 $1,589.75 $1,987.50 $5,874.00 $8,754.63 $7,765.65 $6,451.45 $7,287.25 $30,258.98 $30.50 $2,266.25 $1,589.75 $1,987.50 $5,874.00 $8,754.63 $7,765.65 $6,451.45 $7,287.25 $30,258.98 $30.50 $2,266.25 $1,589.75 $1,987.50 $5,874.00 $8,754.55 $7,765.65 $6,451.45 $7,287.25 $30,258.93 $30.50 $2,266.25 $1,589.75 $1,987.50 $5,874.00 $11,400.00 $13,018.00 $58,032.50 $41,323.50 $123,774.00 $244.00 $0.00 $122.00 $0.00 $368.00 $0.00 $0.00 $0.00 $3,880.00 $3,680.00 $4,275.00 $1,753.50 $0.00 $6,312.00 $12,340.50 $3,538.00 $24,438.00 $20,225.00 $3,111.00 $51,312.00 $4,906.87 $4,241.19 $8,565.75 $24,289.84 $42,003.65 $30,300.00 $41,309.20 $22,857.20 $21,778.00 $116,244.40 $4,855.60 $4,608.60 $1,488.40 $5,507.80 $16,460.40 $6,455.00 $3,789.00 $5,627.00 $4,407.00 $20,288.00 $4,725.50 ($61.00) $244.00 $4,654.00 $9,562.50 $35,302,87 $24,730.69 $16,488.75 $20,443.84 $96,966.15 $1,098.00 $976.00 $3,662.00 $549.00 $6,175.00 $5,664.88 $1,216.09 $2,089.38 $2,585.42 $11,545.77 $0.00 $0.00 $0.00 $0.00 $0.00 $13,513.25 $0.00 $0.00 $0.00 $13,513.25 $0.00 $0.00 $0.00 $0.00 $0.00 $5,174.00 $7,452.00 $27,212.50 $14,522.00 $54,380.50 $0.00 $0.00 $0.00 $1,281.00 $1,281.00 $7,184.85 $2,827.95 $1,627.18 $3,819.76 $15,459.72 $21,354.25 $17,522.00 $15,578.00 $7,195.00 $81,649.25 $0.00 $0.00 $2,074.00 $8,593.00 $10,667,00 $3,834.50 $3,502.00 $1,722.00 $390.00 $9,448.50 $33,836.50 $37,407.00 $17,588.00 $28,373.20 $117,204.70 $26,073.50 $3,533.00 $3,462.00 $5,846.00 $38,914.50 $36.60 $97.60 $9,424.50 .$9,644.10 $19,202.80 $0.00 $0.00 $0.00 $0.00 $0.00 $36,977.00 $42,373.50 $46,351.00 $84,253.50 $189,955.00 $7,427.00 $751.00 $3,004.00 $7,075.00 $18,257.00 $189,425.28 $132,180.78 $93,411.39 $113,257.97 $528,275.42 $108.00 $3,540.00 $2,379.00 $0.00 $6,027.00 $168,479.43 $146,435.54 $93,171.65 $70,840.45 $476,927.07 $49,428.77 $71,429.34 552,978.84 $31,933.32 $205,769.97 $244.00 $1,220.00 $432.00 $324.00 $2,220.00 $13,990.71 $38,852.14 $70,505.59 $94,304.53 $217,652.97 $732.00 ($732.00) $0.00 $0.00 $0.00 $1,830.00 $13,412.00 $2,446.00 $30.50 $17,718.50 $9,896.45 $0.00 $0.00 $0.00 $9,896.45 $7,628.35 $6,188.97 $3,232.16 $2,571.74 $19,62122 $23,588.00 $5,453.00 $11,820.00 $4,747.00 $45,608.00 $0.00 $0.00 $0.00 $0.00 $0.00 $10,947.45 $8,657.50 $26,197.00 $17,112.00 $62,913.95 $3,132.00 $1,296.00 $6,048.00 $6,588.00 $17,084.00 $5,290.00 $5,864.00 $6,389.00 $4,400.00 $21,943.00 $14,958.40 $12,591.40 $5,865.40 $6,588.00 $40,003.20 $92,718.43 $72,017.00 $75,449.88 $74,375.92 $314,561.23 $8,803.86 $4,705.22 $10,118.50 $13,402.51 $37,030.09 $4,322.47 $5,005.19 $8,879.75 $8,055.84 $26,263.25 $33,778.87 $28.184,19 $37.431.75 $32.121.84 $131.51665 $940,620.08 $831,923.19 $806,265.55 $807,346.58 $3,386,155.40 $34,382.60 $28,106.10 $54,252.40 $40,494.30 $167,235.40 $5.604.87 $99,087.79 $327.435.25 $294.854.84 $726.962.75 $39,987.47 $127,173.89 $381,687.65 $335,349.14 $884,198.15 $2.214.00 $3.660.00 $3,546.00 $10,850.00 $20,270.00 $2,214.00 $3,660.00 $3,546.00 $10,850.00 $20,270.00 $982,82t55 $962,757.08 $1.191.499.20 $1,153.545.72 $4.290.623.55 $47,554.67 $34,582.99 $53,956.25 $60,790.14 $196,884.05 $2.935.20 $2,868.20 $2.349.00 $3,138.20 $11.290.60 $50,489.87 $37,451.19 158,305.25 $83,928.34 $208,114.65 Juvenile Maintenance Fund 12931 2-16-501200-25001-6030 Children's Village Sub-Total Fund 293 SUB-TOTAL GOVERNMENTAL / IMAGING DEVELOPMENT APPROPRIATION: $1,033,311.42 $1,000,208.27 $1,247,804.45 $1,217,474.06 $4,498,798.20 90-290000-25000-6030 Information Technology Development ($1,033,311.42) ($1000208271 ($1247804451 ($1217474,06) ($4.498.79820) TOTAL GOVERNMENT: $0.00 $0.00 ELZI MI 0.00 Prepared by: Information Technology; 10/13/2005 4th Qtr 20051.4s INFORMATION TECHOLOGY DATA PROCESSING DEVELOPMENT SUMMARY 4TH QUARTER 2005 ACCOUNT if 1st Qtr 2nd QM 3rd Qtr 4th Ott DIVISION Oct - Dec Jan - Mar Apr - June July - Sect y.T.D, NON-GOVERNMENTAL DIRECT CHARGES 055 CLEMIS $36,179.35 $38,362.23 $30,974.12 $41,567.65 $147,083.35 056 CLEMIS FUND 63500 $1,464.00 $13,044.00 $23,673.50 $10,823.00 $49,004.50 096 CLEMIS 2004 IBIS Grant $0.00 $0.00 $0.00 $488,00 $488.00 521 Community Corrections (Grant) $0.00 $0.00 $0.00 $10,000.00 $10,000.00 661 Community & Home Improvement $0.00 $0.00 $206.00 ($206.00) $0.00 103 COPSMORE Grant - Excess Match $39,894.00 ($39,894.00) $0.00 $0.00 $0.00 471 Courts-FOC Exp-CS Enforcement Image $7,386.40 $9,122.40 $5,742.00 $7,288.40 $29,539,20 470 Courts-FOC Exp-Family Counseling $0.00 $0.00 $0.00 $0.00 $0,00 507 Courts-FOG Exp-CS Enforcement Image $1,220.00 $1,342.00 $1,525.00 $610.00 $4,697.00 210 i Fire Records Management System $2,413.71 $3,421.89 $3,103.84 $3,980.53 $12,919,97 757 FM-Wk ReVJail MgtNideo Conf $57,993.37 $53,241.19 $34,094.75 $28,472.84 $173,802.15 758 FM-Jail Mgrnt Replacement $0.00 $6,078.00 $5,673.00 $0.00 $11,751.00 750 FM & 0 $0.00 $1,741.00 $12,749.20 $2,066.00 $16,556.20 759 F M & 0-Safety Overhead $0.00 $648.00 $0.00 $0.00 $648.00 655 Gararge $0.00 $0.00 $0.00 $4,926.00 $4,926.00 380 Health - Immunization Grant $1,782.00 $1,566.00 $2,241.00 $3,510.00 $9,099.00 751 IT - Telephone Communications $0.00 $122.00 $0.00 $0.00 $122.00 662 Major Department Support Project Fund $364,031.20 $185,175.60 $313,483.00 $436,465.20 $1,299,155.00 870 Medical Care Facility $6,936.71 $3,895.89 $3,604.34 $5,319.53 $19,756.47 248 Medical Care Facility - Pharmacy $3,294.00 $1,134.00 $1,080.00 $1364.00 $6,372.00 651 O.C. International Airport-GRE Grant $0.00 $0.00 $0.00 $0.00 $0.00 653 0.C. International Airport $1,857.00 $413.00 $415.50 $503.00 $3,188.50 770 Parks and Recreation - Administration $108.00 $108.00 $1,244.00 $594.00 $2,054.00 790 Radio Communications $9,730.00 $207.00 $0.00 $0.00 $9,937.00 695 Risk Management $0.00 $0.00 $0.00 $0.00 $0.00 602 Treasurer -100% Tax Paymt Fund $0.00 $0.00 $0.00 ' $13,697.50 $13,697.50 656 Water & Sewer Accounting $4,550.87 $3,530.19 $8,074.75 $8,246.84 $24,402.65 850 Workforce Development $122.00 $0.00 $0.00 $0.00 $122.00 18-636111-10000-0715 SUB-TOTAL DIRECT CHARGES FOR DATA $538.962.81 $283,258.39 $447.884.00 $579216.49 $1.1149.321.49 PROCESSING DEVELOPMENT TOTAL COUNTY DEVELOPMENT CHARGES 51,572.274.03 $1,283,466.66 $1.695‘688.45 51.796.690.55 56.348.119.69 NON-COUNTY AGENCIES 18-636111-10000-0429 Non-County Agencies $0.00 $0.00 $0.00 ILO $0,00 TOTAL DEVELOPMENT CHARGES $1,572,214.03 $1,283,466.66 $1,695,688.45 $1,796,690.55 $6,348,119.69 Prepared by; Information Technology; 10113/2005 4th Qtr 20051.xls Cust # GOVERNMENTAL FUNDS 630 ANIMAL CONTROL 620 AUDITING 005 BD OF COMMISSIONERS 665 CHILDRENS VILLAGE 725 CLERK - ADMIN 440 CLERK - ELECTION4 720 CLERK / REGISTER OF DEEDS 722 CLERK • IMAGING 13001 Clerk - eFiling • 50% 23007 Oracle Support - Clerk Image 65420 Clerk - Image Replace -21% 95158 Clerk - Imaging Clerk • Imaging - Total $9,546.50 5,130.84 19,870.00 26.242,80 $60,790.14 $5,130.84 19,159.00 §21,778.00 $4,407.00 $24,289.84 $21,778.00 $4,407.00 $5,130.84 10,462,00 4,851.00 $20,443.84 495 CTS-BUSINESS DIV - JIM4 487 CTS-FD-CT SERV-ADMIN 492 CTS-FD-CT SERV-ADOPTIONS 505 CTS-FD-JUDICIAL 506 CTS-FD-JUDICIAL SUPPORT 483 CTS-FD-JUDICIAL SUPPORT-ADM $1,928.76 1,891.00 $3,819.76 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2005 95628 Web License Registration $36,214.50 95682 Dog System 5,109.00 Animal Control-Total 95468 Auditing-Cust Supt $0.00 Auditing - Total 91404 BOC - Customer Support $3.660.00 BOC - Total 95665 Childrens Village $10,850.00 Childrens Village - Total 72500 Clerk - Admin $6.312.00 Clerk - Admin - Total 95443 Elections $3.111.00 Clerk -Elections - Total 20004 IDMS Support - Register of Deeds - 20% 36510 GIS Implementation Support-ROD 95493 Reg Deeds System Maintenance 95162 Clerk - DW Support 95163 Clerk - DW Maintenance 95558 User Support/ROD 95564 ROD - DW Support Cleric/Reg of Deeds - Total $41,323.50 $0.00 $3,660.00 $10,850.00 $6,312.00 $3,111.00 $1,024.80 3,956.00 0.00 122.00 0.00 0.00 405.00 $5,507.80 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 IC01 23003 Oracle Support-Comm Corr 52200 Comm Corr-Admin (County) 52201 Comm Corr-DW Supp Community Corrections - Total 785 COMMUNITY 8, ECO DEVELOPMENT 430 CORPORATION COUNSEL 36500 GIS Implementation Support C&E Dev 95785 Comm & Eco Developmt Community & Eco Dev - Total 95501 Corporation Counsel Corporation Counsel - Total $4,654.00 0.00 $4,654.00 $549.00 $549.00 12001 Courts/Criminal Warehouse $0.00 23010 Oracle Support-CCT/CTS Crim Whse 2,565.42 90603 JIMS - Circuit Court - 25% 0.00 CTS-Business Div- JIMS - Total $2,565.42 95196 CTS-FD-Ct Serv - Admin $0.00 CTS-FD-Ct Serv-Adrnin - Total $0.00 95173 CTS-FD-Ct Serv-Adoptions $14.522.00 CTS-FD-Ct Sew-Adoptions - Total $14,522.00 95186 CTS-FD/ADMIN-Family Judges $0.00 CTS-FD-Judicial - Total $0.00 95187 CTS-FD/Admin Fam Suppt Staff $1,281.00 CTS-FD-Judicial Suport - Total $1,281.00 24009 SQL Sew Supp - CTS-Jud Sup Adm 95193 CTS-FD-Judicial Suport-Adm CTS-FD-Judicial Suport-Adm - Total Prepared by, Information Technology; 10/13/2005 4th Qtr 20051,xls 660 FISCAL SERVICES ADMIN 840 HEALTH DEPARTMENT $10,261.66 14,934.39 1,554.53 748.47 11,152.00 9,175.00 0.00 0.00 0.00 305.00 0.00 15,139.60 7,569.80 $70,840.45 $1,024.80 18,903.50 13,326.00 7,240.00 $40,494.30 900 EMERGENCY RESPONSE & PREPAREDNESS 36545 GIS Implementation Support EMS $7,075.00 98990 Emergency Response 0.00 ERP - Total $7,075.00 20001 IDMS Support-Equalization - 40% $2,049.60 23012 Oracle Support-Equalization - 5.6% 5,130.84 24005 SQL Server Supp-Equalization - 6.7% 3,857.53 31075 Equal - Development 4,143.00 36505 GIS Implementation Support Equalization 5,288.00 95559 User Support/Equal 41,428.00 95562 Equalization - OW Support 8,835.00 95570 Equalization - DW Maintenance 13,240.50 95693 Equal-System Maintenance 29,285.50 95699 BS&A Master Appraisal Sup/Maint 0.00 Equalization - Total 740 EQUALIZATION $113,257.97 755 FACILITIES MANAGEMENT 91500 FM - System Support $0.00 Facilities Mgmt - Total $0.00 INFORMATION TECHNOLOGY -RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2005 484 CTS-FD-JUVENILE REFEREES 95191 CTS-FD-Admin-Juvenile Referees $0.00 CTS-FD-Juvenile Referees - Total $0.00 474 QTS-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-P,ssignment $7.195.00 CTS-GJ-Assignment - Total $7,195.00 420 CTS • GJ - FAMILY SUPPORT 95195 Cir Crt Admin $8,593.00 Courts • GJ - Family Support - Total $8,593.00 496 CTS - GJ JIMS 95208 CTS - OW Maintenance $390.00 CTS - GJ - JIMS - Total $390.00 498 CTS-GEN JURIS-JUDICIAL SUPPT 95179 CTS -Gen Juris-Judicial Suppt $28,373.20 CTS -Gen Juris-Judicial Suppt - Total $28,373.20 500 CTS-GJ-MEDIATION 95181 CTS-GJ-Mediation $5.846.00 CTS-GJ-Mediation - Total $5,846.00 493 CTS-JUDICIAL ADMIN 13002 CTS-Judicial Admin eFiling - 50% $9,546.50 95174 CTS-Judicial Admin 97.60 CTS-Judicial Admin - Total $9,644.10 730 DRAIN COMMISSIONER $0.00 35,264.00 28,989.50 0.00 28007 Drain Commissioner 28011 Drain Commissioner Application 36520 GIS Implementation Support Drain 95669 Water & Sewer Accounting Drain Commissioner - Total 23001 Oracle Support - Fiscal Serv 23013 Oracle Support - HR-Acctg/Budget 24006 SQL Serv Supp - HR-Acctg 24008 SQL Serv Supp - Budget 44021 FS-System/Customer Support 44022 FS-System Maintenance 44023 FS-System Enhancements 44024 FS-New Development 44077 BUD-System Maintenance 44079 FS - OW 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 Adrnin Health - Total $64,253.50 Prepared by Information Technology; 10/1312005 4th Chr 20051.xls $5,130.84 3,162.00 153,243.50 133,318.50 $294,854.84 $9,986.79 1,554.53 801.00 486.00 19.105.00 $31,933.32 $324.00 $324.00 $3,857.53 90.447.00 $94,304.53 $0.00 $0.00 $1,650.00 2,750.00 0.00 $4,400.00 $3,686.00 2,902.00 $6,588.00 INFORMATION TECHNOLOGY -RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - FOURTH QUARTER, 2005 843 HEALTH - ENVIRONMENTAL 680 HUMAN RESOURCES 641 MATERIALS MGMT-GEN SUPPORT SERV 872 MEDICAL EXAMINER 710 MSU EXTENSION - OAKLAND 23005 Oracle Support - EH Projects - 5.6% 37002 Environmental 84200 EH - Projects 84300 Ehealth Program Health-Environmental • Total 23014 Oracle Support-HR/Personnel 24007 SQL Server Suppport-HFt/Personnel 44042 PER-Systems Maintenance 95556 Personnel User Supt 96002 Human Res-Personnel 40% Personnel • Total 95440 Materials Management Materials Mgmt-Gen Fund - Total 24002 SQL Server Support - Medical Exam - 6.7% 87202 Medical Examiner - Customer Support Medical Exarniner - Total 95676 MSU Ext Equipment Maintenance MSU Extension - Oakland - Total 775 PLANNING & ECONOMIC DEVELOPMENT 95786 PEDS - DW Support $30.50 95787 PEDS - DW Maintenance 21Q PEDS - Total $30.50 512 PROB-ESTATES/MENTL HLTH IMAGE 95207 Prob-Est/Mntl 1-I1th Image $3,13820 Prob-Est/Mntl Hlth Image - Total $3,138.20 509 PROB•JUDICIAL ADMIN 90604 JIMS Probate 25% $0.00 95165 PC-Judicial Admin-AdmIn SeN 0.00 Prob-Judidal Admin - Total $0.00 510 PROB-ESTATES/MENTL HLTH SUPPORT 24010 SQL Serv Supp-PCT-Est/Mental $1,928.74 92198 Prob-Est/Mntl Hlth Support 643 00 Prob-Est/Mntl Hlth Support - Total $2,571.74 481 PROBATE-FD JUDICIAL 95168 Prob-FD Judicial $4.747.00 Prob-FD Judicial - Total $4,747.00 479 PROB-FD-JUDICIAL SUPPORT 95188 PROB-FD Judicial Support $0.00, PROB-FD Judicial Support - Total $0.00 145 PROSECUTOR • GENERAL PROSECUTION 90605 JIMS - Prosecutor 25% $0.00 95622 Prosecutor/Executive 13,602.00 97001 Prosecutor Data Proc 3 510 00 Prosecutor - Total $17,112.00 690 PURCHASING 44026 PUR-SysterNCustomer Support $4,968.00 44027 FUR-System Maintenance 1,620.00 Purchasing - Total $6,588.00 650 REIMBURSEMENT 637 RECORDS RETENTION 44052 Rec-System Maintenance 44054 Rec-New Development 95636 Mail Room Rec-New Development - Total 95470 Reimbursement System 95542 Reimburse User Support Reimbursement - Total 195 SHERIFF 12001 OCSD - Courts/Criminal Warehouse $0.00 23009 Oracle Suppport - OCSD/CTS Crim Whse 2,565.42 97163 Sheriff 53,641.00 97164 Sheriff-Development 3,220.00 97165 Sheriff-DW Support 14,544.50 97166 Sheriff-DW Maintenance 405.00 Sheriff - Total $74,375.92 Prepared by Information Technology. 10/13/2005 4th Qtr 20051.xls $1,987.50 $1,987.50 $1.987.50 $1,987.50 $1,987.50 $1,987.50 530 52/4 DISTRICT COURT - TROY 90609 JIMS - 52/4 DC- 6.25% 95530 DC Suprt-25%-52/4 52/4 District Court - Total $0.00 7,287.25 $7,287.25 $1,987.50 $1,987.50 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL- FOURTH QUARTER, 2005 191 SHERIFF - CLEWS 445 SUPPORT SERVICES 600 TREASURER 540 52/1 DISTRICT COURT- NOVI 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 44061 Tre-System/Customer Support 44062 Tre-System Maintenance 44053 Tre-System Enhancement 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 90606 JIMS - 52/1 DC - 6.25% 95527 DC Suprt-25%-52/1 52/1 District Court - Total $5,130.76 8,271.75 $13,402.51 $5,130.84 2,925.00 $8,055.84 $5,130.84 3,660.00 2,089.00 4,783.00 0.00 0.00 61.00 0.00 1,342.00 15,056.00 0.00 $32,121.84 $0.00 7,287.25 $7,287.25 541 52/1 DISTRICT COURT NQVI - PROBATION 94542 DC Probation Support - 52/1 - 25% 52/1 District Court - Probation - Total 550 52/2 DISTRICT COURT - CLARKSTON 90607 JIMS - 52/2 DC - 6.25% 95528 DC Suprt-25%-52/2 52/2 District Court - Total $0.00 7,287.25 $7,287.25 551 52/2 DISTRICT COURT • CLARKSTON - PROBA1 94552 DC Probation Support - 52/2 - 25% 52/2 District Court - Probation - Total 560 52/3 DISTRICT COURT • ROCHESTER 90608 JIMS • 52/3 DC - 6.25% 95529 DC Suprt-25%-52/3 52/3 District Court - Total $0.00 7,287.26 $7,287.25 561 52/3 DISTRICT COURT - ROCHESTER - PROBA1 94562 DC Probation Support - 52/3 - 25% 52/3 District Court - Probation - Total 531 52/4 DISTRICT COURT - TROY - PROBATION 94532 DC Probation Support - 52/4 - 25% 52/4 District Court - Probation - Total Prepared by; Information Technology, 10/1312005 4th Qtr 20051.xls INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2005 Gust # DIRECT FUNDS 05$ CLEWS 20003 IDMS Support $1,024.80 24004 SQL Server Support 34,429.85 95409 CRISNET/CLEMIS LRM 549.00 95430 CLEMIS Maintenance 5,564.00 CLEMIS - Total 056 CLEMIS FUND 63500 63500 CLEMIS Fund $10.823.00 CLEMIS Fund - Total 096 CLEMIS 2004 IBIS GRANT 63596 2004 Federal Approp - IBIS Project $488.00 CLEMIS 2004 IBIS Grant - Total 521 COMMUNITY CORRECTIONS (GRANT 52100 Community Corrections Grant $10,000.00 Community Corrections Grant - Total 661 COMMUNITY & HOME IMPROVEMENT 66103 Comm Dev User Supt 13206.001 103 COPSMORE GRANT- EXCESS MATCH 63103 COPSMORE Grant - Excess Match $0.00 COPSMORE Grant - Excess Match - Total 471 CTS-FOC-EXP-CS ENFORC-IMAGE 92194 CTS-FOC-Exp-CS Enf-Image 7288.40 CTS-FOC Exp-CS Enf-Image - Total 470 CTS-FOC-EXP-FAM COUNSELING 92195 CTS•FOC-Exp-Fam Counseling $0.00 CTS-FOC-Exp-Fam Counseling - Total 507 CTS-FOC EXP-CS ENFORCEMENT 92193 CTS-FOC Exp-CD Enforc-Dev $610.00 CTS-FOC Exp-CD Enforc-Dev - Total 210 FIRE RECORDS MANAGEMENT SYSTEM 21010 Fire Records Mgrnt Fund 531 $123.00 24001 SQL Server Support - FRMS 3,857.53 Fire Records Mgmt - Total $41,567.65 $10,823.00 $488.00 $10,000.00 ($206.00) $0.00 $7,288.40 $0.00 $610.00 $3,980.53 750 FM&O 21001 FM&O $0.00 75503 FM&O Development 2,066.00 FM&O - Total $2,066.00 757 FM-WK RELEASE/JA1L MGMT/VIDEO CONF 23004 Oracle Support - Oak Video - 5.6% $5,130.84 75700 Fac Mgmt - Video Arraignments 23 342.00 FM-Wk Rd/Jail MgmtNIdeo Conf - Total $28,472.84 758 FM - JAIL MGMT REPLACEMENT 75800 FM - Jail Mgrnt Replacement $0.00 FM - Jail Mgmt Replacement - Total $0.00 759 FM&O • SAFETY OVERHEAD 75900 FM - Bomb Notification SW Upg $0.00 FM - Bomb Notification SW Upg - Total $0.00 655 GARAGE 44058 GAR - Systems Enhancements $4.926.00 Garage - Total $4,926.00 380 HEALTH IMMUNIZATION - GRANT 38000 Health - Immunization $3.510.00 Health - Immunization - Total $3,510.00 751 IT - TELEPHONE COMMUNICATIONS 75102 Tel Comm - Customer Support $0.00 Tel Comm - Customer Support • Total $0.00 662 MAJOR DEPT SUPP PROJ FUND 66200 e-Financial-Peoplesoft Implementation $436,485.20 e-Financial-Peoplesoft Implem-Total $436,465.20 870 MEDICAL CARE FACILITY 24003 SQL Server Support - MCF - 6.7 $3,857.53 98873 MCF - Support 1,462.00 MCF - Support - Total $5,319.53 248 MEDICAL CARE FACILITY - PHARMACY 98248 MCF • Pharmacy $864.00 MCF - Pharmacy - Total $864.00 653 O.C. INTERNATIONAL AIRPORT 36540 GIS Implementation Support-Aviation $244.00 65301 Airport User Support 259.00 O.C. International Airport - Total $503.00 770 PARKS AND RECREATION 36530 GIS Implementation Support - Parks $0.00 95419 PRADM-Administration 594.00 Parks & Recreation - Total $594.00 790 RADIO COMMUNICATION 79001 Radio Communications $0.00 Radio Communications - Total $0.00 Prepared by, Information Technology; 10/1312005 4th Qtr 20051.xls $0.00 0.00 $0.00 695 RISK MANAGEMENT 44036 RSK-SysternICustomer Support 95695 Risk Management Risk Management - Total $13,697.50 $13,697.50 $5,130.84 3,116.00 $8,246.84 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2005 602 TREASURER-100% TAX PAYMT FUND 656 WATER 8. SEWER ACCTG 99002 Treasurer's Office Treasurers Office - Total 2301 1 Oracle Supp - Water & Sewer Acct'g 95669 Water & Sewer Acct'g Water & Sewer Acct'g - Total 850 WORKFORCE DEVELOPMENT 95670 Employment & Training $0.00 Workforce Development - Total $0.00 Prepared by, Information Technology; 10/1312005 4th Qv 20051.xls FISCAL NOTE (MISC. #05272) BY: FINANCE COMMITTEE, CHUCK MOSS, CHAIRPERSON IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FOURTH QUARTER 2005 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 2005 Development cost to benefiting departments. 2. The fourth quarter data processing development charges are $1,153,545.72; imaging development charges are $63,928.34 for General Fund/General Purpose departments; direct charges to Special Revenue and Proprietary fund departments are $579,216.49 and charges to non-county agencies are $0. 3. The respective departmental Fiscal Year 2005 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 Melton absent. Resolution #05272 November 10, 2005 The Chairperson referred the resolution to the Finance Committee. There were no objections. APPROVE PE FORMNG minim Resolution #05272 December 8, 2005 Moved by Gregory supported by Douglas the resolutions on the Consent Agenda, as amended, be adopted (with accompanying reports being accepted). AYES: Crawford, Douglas, Gershenson, Gregory, Hatchett, Jamian, KowaII, Long, Melton, Molnar, Moss, Nash, Palmer, Patterson, Potter, Rogers, Scott, Suarez, Woodward, Zack, Bullard, Coulter. (22) NAYS: None. (0) A sufficient majority having voted in favor, the resolutions on the Consent Agenda, as amended, 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 8, 2005, 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 8th day of December, 2005. Ruth-dehnstfn, County Clerk