The URL can be used to link to this page

Home My WebLink AboutResolutions - 2003.03.06 - 27205MISCELLANEOUS RESOLUTION 103026 February 13, 2003 BY: GENERAL GOVERNMENT COMMITTEE, WILLIAM PATTERSON, CHAIRPERSON IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FIRST QUARTER 2003 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 First Quarter 2003 data processing development charges to be $1,447,540.47 and the imaging development charge to be $80,352.00 for the General Fund/General Purpose County departments; and WHEREAS direct charges to Special Revenue and Proprietary fund departments are $103,575.00 and non-county agencies are $0 for the First Quarter 2003; and WHEREAS an appropriation transfer to General Fund/General Purpose County departments is needed to fund these development charges; and NOW THEREFORE BE IT RESOLVED that the Oakland County Board of Commissioners has reviewed the First Quarter 2003 Data Processing Development Report and approves the First 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 GOVERNM T COMMITTEE 0. / General Government Committee Vote: Motion carried unanimously on a roll call vote. DIVISION ACCOUNT Y.T,O, 3rd Otr Apr - June 4th Otr July - Scot 52/1 - District Court 52/2 - District Court 52/3 - District Court 62/4 - District Court Animal Control AucNting Board of commissioners Clerk - Elections Clerk - Jury Commission Clerk - Legal Records Clerk - Register of Deeds Clerk • Vital Statistics Community Corrections Admin Community & Economic Development Corporation Counsel Courts-Business Division - JIMS Courts-ED-Court Services-Admin Courts-ED•Court Senaces-Adoptions Courts-FD-Court Services-Casework Courts-ED - Judicial Courts-FD-Judicial Support-Admin Courts-FD Juvenile Support Courts-GJ-Judictal Support Courts-0J-Assignment Courls-GJ-Earbily Support Courls-CJ-Mediation Courts-Judicial Administration Drain Commissioner Emergency Response & Prep Unit Equalization Division Fiscal Services - AdmIn Fiscal Services - General Library - Admin Materials Management - Gen Fund Medical Examiner MSU Extension - Oakland Personnel Planning and Economic Development Probate - Estates/Mental Health Admin Probate-Estates/Mental Health Support Probate-ED-Judicial Probate - Judicial Admin Probate-ED-Judicial Support Prosecuting Attorney - General Prosecution Prosecuting Attorney - Administration Purchasirg Reimbursement Division Sheriff Sheriff - CLEMIS Support Services Treasurer Veterans Sub-Total Fund 101 Health Health - Clinic Health Environmental Sub-Total Fund 221 DATA PROCESSING DEVELOPMENT FOR GOVERNMENTAL FUND APPROPRIATION Clerk Image Courts-PD-Jun-Sup-Imaging Probate-Estates/Mental Health Image TOTAL IMAGING DEVELOPMENT APPROPRIATION $10,649.76 $10,549,76 $10,549.76 $10,549.74 $1,242.00 $610.00 $0.00 $70,257.54 $1,146.00 $8,496.80 $12,379.90 $23,315.50 $44,721.00 $11.588.00 $122.00 $13,509 75 $2,210.00 $220.80 6324.00 6366.00 $11,856.00 $1.516.00 $33,729.00 $844.00 $932.00 $43436.00 $5,438.50 $321,909.50 $300,168.10 $11,681.50 $8,262.00 $756.00 $161,750.90 $48.00 $9,436.50 $10,858.50 $122.00 $18,022.50 $10,066.50 $17,867.40 $16,165.50 632206.00 $3,138.00 $110,574.00 $1,364,071.97 12,991.00 76.577,50 $139,555.50 Z44.00 $244.00 $1 A63.864.47 71,632.00 2,376,00 $74.008.00 $1,527,892.47 161.527.802,47), 1.19_4 $0,00 $0.00 19.44 1.4.92 $0.00 ;0.00 $10,549.76 10.549.76 10,549.76 10,549.74 1,242.00 610.00 0.00 70257.50 1,148.00 8,496.80 12,379.90 23,315.50 44 721.00 11,588.00 122.00 13,509.75 0.00 2,210.00 0.00 220.80 324.00 366.00 11,866.00 1,518.00 33,729.00 844.00 932.00 43,636.00 5,438.50 321.909.50 300 168.10 0.00 0.00 11,681 50 8,262.00 756.00 161,750.90 0.00 0.00 48.00 9.436.60 10,886.50 122.00 18,022.50 0.00 10,066.50 17,867.40 16,168,50 3,138.00 110,874 00 $0.00 1,364,071.97 12,991.00 0.00 76.577.5Q 89,568.50 Z44.00 244.00 S1.453,884,47 71,632.00 9,124 2,376.00 ;0,00 $74,008.00 80.00 $1,527,892.47 $0.00 151,527,1392,471 1)1(/ $0.00 $0.00 $0.00 .£4,911 $0.00 KIN tug juvenile Maintenance Fund 12931 293 2-16-50120p-25001-600 12931 Children's Village Sub-Total Fund 293 SUB-TOTAL GOVERNMENTAL / IMAGING DEVELOPMENT APPROPRIATION: 90-293000-25000-6330 Information Technology Development TOTAL GOVERNMENT: INFORMATION TECHNOLOGY DATA PROCESSING DEVELOPMENT SUMMARY 1ST QUARTER 2003 1st Otr 2nd Qtr Oct - Deg Jan - mar GOVERNMENTAL FUNDS General FUnd 11011 101 2-32-201200-20001-6030 101 2-32-301200-20001-6030 101 2-32-401200-20001-6030 101 2-32-501200-20001-6030 101 2-17-802200-80001-6034 101 2-11-220100-10000-6030 101 2-51-211000-10000-6030 101 2-21-230130-31000-6030 101 2-21-250100-01000-6030 101 2-21-221000-01000-6030 101 2-21-240100-11000-5030 101 2-21-220500-40000-6030 101 2-1 7-402200-70001 -6030 101 2-19-210000-10300-6030 101 2-11-250100-20000-6030 101 2-35-220000-12000-6030 101 2-35-242000-11000-6030 101 2-35-242000-44000-6030 101 2-35-242000-41000-6039 101 2-35-244000-31100-6030 101 2-35-243000-11000-6030 101 2-35-244300-33000-6030 101 2-35-230000-21200-6030 101 2-35-230000-22100-6030 101 2-35-230000-31200-6030 101 2-35-230000-22200-6033 101 2-35-210000-11000-6030 101 2-61-211001-10000-5030 101 2-11-101112-65001-6030 101 2-12-240000-41000-6030 101 2-12-601200-10001-6030 101 2-12-621200-10001-6030 101 2-51-233000-53500-6030 101 2-13-135502-15100-6030 101 2-17-912000-15000-6030 101 2-17-501200-50001-6030 101 2-15-402200-10001-6030 101 2-19-221000-10000-6030 101 2-34-403200-40001-6030 101 2-34-403200-40005-6030 101 2-34-101200-31100-6030 101 2-34-101200-40001-6030 101 2-34-101200-31200-6030 101 2-41-211000-41700-5030 101 2-41-211000-41100-5030 101 2-12-401200-40010-6030 101 2-12-701200-10001-6030 101 2-43-023301-20000-6030 101 2-43-023601-30000-6030 101 2•13-138201-15100-6030 101 2-22-221120-01000-6030 101 2-17-302200-30001-6030 Health Fund 12211 221 2-16-201200-33100-6030 221 2-16-234200-54600-6030 221 2-16-220200-67000-6030 18-636111-10000-0735 IMAGING 2-21-221000_01000-6039 2-35-243000-33000-6039 2-34-403200-40005-6039 18-636111-10000-0573 Prepared ty: Lisa Schmidt, info Tech; 1/24103; 1:16 PM 1st qtr 2003.xls Y.T.D. 4th Otr JUIY - SeDI 9,793.00 54,00 23.976.00 7,808.00 2,257.00 594.00 676.00 514.00 23,028.00 34,875.00 0.00 INFORMATION TECHNOLOGY DATA PROCESSING DEVELOPMENT SUMMARY 1ST QUARTER 2003 ist Qtr 2nd Qtr 3rd QS ACCOUNT # DIVISION Oct Dec Ja-r - Mar Apr - June NON-GOVERNMENTAL DIRECT CHARGES CLEMIS Community Corrections Courts-F0C-Exp-CS Enforcement Courts-FOG Exp-CS Enforcement Image Courts-FOC Exp.Family Counseling Fire Records Management System FM-Wk Rel/Jail Mg/Mido Cont F M & 0 Health • immunization Grant 17 - FEMA Grant Materials Management Medical Care Facility ac. International Airport Parks and Recreation - Administration Risk Management Treasurer - 100% Tax Payment Fund Treasurers Delinquent Tax Revolving Fund Water & Sewer Accounting Workforce Development $0.00 0.00 0.00 9.793 00 54.00 23,976.00 7,808.00 2,257.00 594.00 000 0.00 676.00 0.00 514.00 23,028.00 0.00 0.00 34,875.00 18-636111-10000-0715 SUB-TOTAL DIRECT CHARGES FOR DATA $103.575.011 ILE 19,24 HAQ $103,575.00 PROCESSING DEVELOPMENT TOTAL COUNTY DEVELOPMENT CHARGES $1.631.467.47 al& 1912 1P,Q2 51 .631.467.47 NON-COUNTY AGENCIES 10-636111-10000-0429 Non-County Agencies 50,00 $000 TOTAL DEVELOPMENT CHARGES 81,631,467.47 $0.00 $0.00 $0.00 SI,631,467.47 Prepared by: Lisa Schmidt Into Tech: 1124/03; 1:16 PM 1st Or 2003.xls $10,888.50 2.621.25 $2,210.00 $220.80 $324.00 $366.00 $13,509.75 $2,210.00 $220.80 $324.00 $366.00 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER, 2003 Cust # GOVERNMENTAL FUNDS 630 ANIMAL CONTROL 95682 Dog System $1,242.00 Animal Control-Total $1,242.00 620 AUDITING 95468 Auditing-Cust Supt $610.00 Auditing - Total $610.00 665 CHILDRENS VILLAGE 95665 Childrens Village $244.00 Childrens Village - Total $244.00 440 CLERK - ELECTIONS 95443 Elections $70.267.50 Clerk -Elections - Total $70,267.50 720 CLERK (REGISTER OF DEEDS 36510 GIS Implementation Support-ROD $7,691,50 95493 Reg Deeds System Maintenance 488.00 95498 Cleric/Reg of Deeds 662.40 95558 User Support/ROD 3.538,00 Clerk/Reg of Deeds - Total $12,379.90 722 CLERK - IMAGING 65420 Clerk - Image Replace - 21% $8,278.00 95158 Clerk - Imaging 63,354.00 Clerk - Imaging - Total $71,632.00 410 CLERK - JURY COMMISSION 95512 Jury Commission $1.148.00 Clerk -Jury Commission - Total $1,148.00 724 CLERK - LEGAL RECORDS 95189 Circuit Court System 8.496.80 Clerk - Legal Records - Total $8,496.80 723 CLERK - VITAL STATISTICS 95161 Vital Stets Index $23.515.50 Clerk - Vital Statistics - Total $23,315.50 522 COMMUNITY CORRECTIONS-ADMIN (CO) 52200 Comm Corr-Admin (County) $44,721.00 Community Corrections - Total $44,721.00 785 COMMUNITY & ECO DEVELOPMENT 36500 GIS Implementation Support C&E Dev $1,455.00 95785 Comm & Eco Developmt 10,133.00 Community & Eco Dev - Total $11,588.00 430 CORPORATION COUNSEL 95501 Corporation Counsel $122.00 Corporation Counsel - Total $122.03 495 CTS-BUSINESS DIV - JIMS 492 CTS-FD-CT SERV-ADOPTIONS 505 CTS-FD-JUDICIAL 483 CTS-FD-JUDICIAL SUPPORT-ADM 474 CTS-FD-JUVENILE SUPPORT 90603 MS - Circuit Court - 25% 95176 CTS-Business Div - JIMS CTS-Business Div - JIMS - Total 95173 CTS-FD-Ct Serv-Adoptions CTS-FD-Ct Serv-Adoptions - Total 95186 CTS-FD/ADMIN-Family Judges CTS-FD-Judicial - Total 95193 CTS-FD-Judicial Suport-Adm CTS-FD-Judicial Suport-Adm - Total 95474 CTS-FD-Admin-Juvenile Support CTS-FD-Juvenile Support - Total Prepared by Lisa Schmidt: Info Tech: 1/24/03 5 1st qtr 2003.xls $1.518.00 $33.729.00 $11.866.00 $844.00 $932,00 $732.00 7,128.00 32,238.00 3.538.00 $43,636.00 $1,518.00 $33,729.00 $11,866.00 $844.00 $932.00 $5.438.50 641 MATERIALS MGMT-GEN SUPPORT SERV 95440 Materials Management 95704 Performance Series - 25% Materials Mgmt-Gen Fund - Total 872 MEDICAL EXAMINER 87202 Med Exam - Cust Support Medical Examiner - Total 36525 GIS Implementation Support Health 37025 CHAMPS - P.O.P. 96842 Health Admin Health - Total $3,456.00 8,559.00 976.00 37002 Environmental $216.00 84200 EH - Projects 16,275.00 84300 Ehealth Program 60.086.50 Health-Environmental - Total $321,909.50 $300,168.10 $12,991,00 $76,577.50 $11,681.50 $8,262.00 95556 Personnel User Supt 96002 Human Res-Personnel 40% Personnel - Total 1,904.00 199546.90 $161,750.90 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER, 2003 499 CTS-GJ-ASSIGNMENT 95180 CTS-GJ-Assignment CTS-GJ-Assignment - Total 420 CTS - GJ - FAMILY SUPPORT 95195 Cir Cr? Admin Courts - GJ - Family Support - Total 498 CTS-GEN JURIS-JUDICIAL SUPPT 95179 CTS -Gen Juris-Judicial Suppt CTS -Gen Juris-Judicial Suppt - Total 500 CTS-GJ-MEDIATION 95181 CTS-GJ-Mediation CTS-GJ-Mediation - Total 493 CTS-JUDICIAL ADMIN 95174 CTS-Judicial Admin CTS-Judicial Admin - Total 730 DRAIN COMMISSIONER 28009 Drain Commissioner 28011 Drain Commissioner Application 36520 GIS Implementation Support Drain 95669 Water & Sewer Accounting Drain Commissioner - Total 900 EMERGENCY RESPONSE & PREPAREDNESS 36545 GIS Implementation Support EMS EMS - Total $5,438.50 740 EQUALIZATION 660 FISCAL SERVICES ADMIN 840 HEALTH DEPARTMENT 843 HEALTH - ENVIRONMENTAL 31075 Equal - Development 36505 GIS Implementation Support Equalization 95559 User Support/Equal 95693 Equal-System Maintenance Equalization - Total 44021 FS-System/Customer Support 44022 FS-System Maintenance 44023 FS-System Enhancements 44024 FS-New Development 44076 BUD-System/Customer Support 95702 Perf Series - Fiscal Services 25% 95703 Pert Series - Budget 25% 96001 Human Res-Acct 40% 96003 Human Res.-Budget 20% Fiscal Services Admin - Total $69,624.00 1,530.00 33,286.00 217.469.50 $45,186.00 60,762.00 47,066.00 7,564.00 216.00 9,546.50 9,546.50 80,187.40 40.093.70 $2,135.00 $9,546.50 $8.262,00 710 MSU EXTENSION - OAKLAND 36535 GIS lmplem Support - MSU Ext $756.00 GIS Implem Support - MSU Ext - Total $756.00 680 PERSONNEL Prepared by Lisa Schrradt, Info Tech: 1/24/03 6 1st qtr 2003.xls $540.00 $9.546.50 $10,086.50 $3,776.40 14.001.00 16.168.50 32.208,00 $3,138.00 244.00 6,836.00 11,472.00 7,991.00 42,287.00 42.044,00 $2,722.13 7.827.63 $2,722.13 7.827,63 $2,722.13 7.827.63 $2,722.13 7.827.6 $17,867.40 $16,168.50 $32,208.00 $3,138,00 $110,874.00 $10,549.76 $10,549.76 $10,549.76 $10,549.74 INFORMATION TECHNOLOQY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER, 2003 512 PROB-ESTATES/MENTL HLTH IMAGE 95207 Prob-Est/Mntl Hlth Image $2,376.00 Prob-Est/Mnti 1-11th Image - Total $2,376.00 509 PROB-JUDICIAL ADMIN 90604 JIMS Probate 25% $10,868.50 Prob-Judicial Admin - Total $10,888.50 510 pROB-ESTATES/MENTL HLTH SUPPORT 92198 Prob-Est/Mntl Hlth Support $2aQt) Prob-Est/Mntl 1-11th Support - Total $48.00 481 PROBATE-FD JUDICIAL 95168 Prob-FD Judicial $9.436.80 Prob-FD Judicial - Total $9,436,80 479 PROB-FD-JUDICIAL SUPPORT 95188 PROB-FD Judicial Support $122.00 P1-OB-FD Judicial Support - Total $122.00 145 PROSECUTOR - GENERAL PROSECUTION 90605 JIMS - Prosecutor 25% $10,888.50 95622 Prosecutor/Executive 7,026.00 97001 Prosecutor Data Proc 106,00 Prosecutor - Total $18,022.50 690 PURCHASING 650 REIMBURSEMENT 195 SHERIFF 191 SHERIFF - CLEMIS 445 SUPPORT SERVICES 600 TREASURER 540 52/1 DISTRICT COURT - NOVI 550 52/2 DLSIRLCT COURT - CLARKSTON 560 52/,3 DISTRICT COURT • ROCHESTER 530 52/4 DISTRICT COURT- TROY 44026 PUR-System/Customer Support 95701 Performance Series 25% Purchasing - Total 95470 Reimbursement System 95542 Reimburse User Support Reimbursement - Total 97163 Sheriff Sheriff - Total 96163 Sheriff - CLEMIS Sheriff - CLEMIS - Total 44500 Support Services Support Services - Total 36515 GIS Implementation Support-Treasurer 44061 Tre-System/Customer Support 44062 Tre-System Maintenance 95008 Del Tax On Line 95303 Del Tax System Maintenance 95561 User Support/Del Tax Treasurer - Total 90606 JIMS - 5211 DC - 6.25% 95527 DC Supd-25%-52/1 52/1 District Court • Total 90607 JIMS - 52/2 DC - 6.25% 95528 DC Supd-25%-52/2 52/2 District Court - Total 90608 JIMS - 52/3 DC - 6.25% 95529 DC Supd-25%-5213 52/3 District Court - Total 90609 JIMS - 52/4 DC - 6.25% 95530 DC Supd-25%-52/4 52/4 District Court - Total Prepared by Lisa Schmidt Info Tech; 1/24/03 7 lst qtr 2003.xls $244.00 $22,784.00 $23,028.00 44036 RSK-System/Customer Support 95695 Risk Management Risk Management - Total 695 RISK MANAGEMENT $34,875.00 656 WATER & SEWER ACCTG $31,805.00 3,070,00 44049 WS-New Development 95669 Water & Sewer Acct'g Water & Sewer Acct'g - Total INFORMATION TECHNOLOAY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER, 2003 Cust # DIRECT FUNDS 471 CTS•F0C-EXP-CS ENFORC-IMAGe 92194 CTS-FOC-Exp-CS Ent-Image 59,793.00 CTS-FOC Exp-05 al-Image - Total $9,793.00 470 CTS-FOC-EXP-FAM COUNSELING 92195 CTS-FOC-Exp-Farn Counseling $54.00 CTS-FOC-Exp-Farn Counseling - Total $54.00 210 FIRE RECORDS MANAGEMENT SYSTEM 21010 Fire Records Mgmt Fund 531 $8,640.00 95404 FRMS - Phase II Projects $15.336.00 Fire Records Mgmt - Total $23,976,00 750 FM&O 21001 FM&O $2.257.0Q FM&O - Total 2,257.00 757 FM-WK RELEASE/JAIL MGMTNIDEO CONF 75700 Fac Mgmt - Video Arraignments 57.808.00 FM-Wk Rel/Jail MgmtNideo Conf - Total $7,808.00 380 HEALTH IMMUNIZATION - GRANT 38000 Health - Immunization $594.00 Health - Immunization - Total $594.00 870 MEDICAL CARE FACILITY 98873 MCF - Support $676,00 MCF - Support - Total $676.00 770 PARKS AND RECREATION 36530 GIS Implementation Support Parks Dept $338.00 95419 PRADM-Administration 176.00 Parks & Recreation - Total $514.00 Prepared by Lisa Schmidt; Taft, Tech: 1/24/03 8 tst qtr 2003.xls March 6, 2003 - FIRST QUARTER 2003 are to be FISCAL NOTE (MISC. #03026) BY: FINANCE COMMITTEE, CHUCK MOSS, CHAIRPERSON IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY DEVELOPMENT APPROPRIATION TRANSFER TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS Chairperson, Ladies and Gentlemen: Pursuant to Rule XII-C of this Board, reviewed 1. departments. 2. The first quarter data processing development charges $1,447,540.47; imaging development charges are $80,352.00 General Fund/General Purpose departments; direct charges Special Revenue and Proprietary fund departments $103,575.00 and charges to non-county agencies are $0. 3. The respective departmental Fiscal Year 2003 budgets amended as specified in the attached detail schedule. FINANCE COMMITTEE FINANCE COMMITTEE Motion carried unanimously on a roll call vote with Obrecht, Palmer, Patterson and Zack absent. Committee the The resolution appropriates Technology First Quarter 2003 has are for to are the Finance above-referenced resolution and finds: and charges the Information Development cost to benefiting Resolution #03026 February 13, 2003 The Chairperson referred the resolution to the Finance Committee. There were no objections. . William Caddell, County Clerk Resolution #03026 March 6, 2003 Moved by Jamian supported by Coulter the resolutions on the Consent Agenda, be adopted. AYES: Coulter, Crawford, Douglas, Gregory, Hatchett, Jamian, Knollenberg, KowaII, Law, Long, McMillin, Middleton, Moffitt, Moss, Palmer, Patterson, Potter, Rogers, Scott, Suarez, Zack, Bullard, Coleman. (23) NAYS: None. (0) A sufficient majority having voted therefore, the resolutions on the Consent Agenda, were adopted. I HEREBY -Mil FOREGOING RESOLtf lb/ /D L. BroOka Ditt6rtson, Gounty ExeoitIve STATE OF MICHIGAN) COUNTY OF OAKLAND) I, G. William Caddell, 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 March 6, 2003, 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 6th day of March, 2003. Date