Loading...
HomeMy WebLinkAboutResolutions - 2004.03.17 - 27555MISCELLANEOUS RESOLUTION #04053 March 4, 2004 BY: GENERAL GOVERNMENT COMMITTEE, WILLIAM PATTERSON, CHAIRPERSON IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FIRST QUARTER 2004 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 2004 data processing development charges to be $1,099,261.22 and the imaging development charge to be $90,295.00 for the General Fund/General Purpose County departments; and WHEREAS direct charges to Special Revenue and Proprietary fund departments are $110,311.50 and non-county agencies are $0 for the First Quarter 2004; 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 2004 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 GOV RNMENT COMMITTEE General Government Committee Vote: Motion carried on a roll call vote with Potter and Hatchett absent. • I tat Qtr 2nd Qtr S2CLL122& DIVISION ACCOUNT # Atha/ July - Scot 3rd Qtr Aor Jun $10,732.70 $10,732.70 $10,732.70 $10,732.64 $3.348.00 $0.00 $1,597.50 $4,270.00 $17,505.00 $22,031.50 $10,600.90 $13,822.00 $1,92000 $25,108.00 $2,318.00 $3,309.76 $0.00 $671.00 $.566.00 $6,962.00 $0.00 $589.00 $17,104.00 $060 $40,610.50 $6,632.50 $1,121.50 $40,770.03 $20,461.50 $191,278.00 $203,948.10 $4,167.00 $9,013.00 $0.00 647,381.30 $3,309.76 $1,262.00 $23,170.00 $758.00 631,967.76 $4,050.00 $8,699.50 $16,847,20 579.663.50 $34,526.00 $5,255,60 ;47.513.50 $997,0713.72 $67,284.00 $34 .729.50 $102,083.50 ka.42 699.00 61.999261.22 $10,732.70 $10.732,70 $10,732.70 $10,732.64 $3,348.00 $0.00 64.270.00 $17,505.00 $222,031.50 $10,60000 $13,822.00 $1,920.00 $25,106.00 $2,318.00 63,309.76 $0.00 $671.00 5568,00 56.962,00 $0.00 $589.00 $17,104.00 $0.00 $40,610.50 $6,632.50 $1,121.50 $40,770.00 $20.461.50 $191,278.00 $203,948.10 $4,167,60 $9,013.00 $0.00 $47,381.30 $3,309.76 $1,262.00 $23,170.00 $756.00 $,31,967.76 $4,050.00 $8,699.50 516647.20 $79.683.50 $34,526.00 55,255.60 647,513.50 $997,078.72 667,284.00 534.799.5Q $102,083.50 599,00 $99.00 51.099.261,72 $0.00 $0.00 $0.00 ELM $0.00 $0.00 $0.00 12.42. $0.00 $0.00 $0.00 E124 .1222 $0.00 Eta. ELM 0.00 11.22 DA& 1224 so.00 21211 WI& 186,953.00 60.00 $3.342.0Q $90,295.00 $1,189,556.22 (51.189.556.221 1122 $86,953.00 $0.00 /1212.0 ;9Q.295.00 $1,189,556.22 .41.169.566221 #11.932 INFORMATION "tfECHNOLOGY DATA FRODESSINp DEVELOPMENT SUMMARY ' 1ST QUARTER 2004 540 101 550 101 560 101 530 101 630 101 620 101 725 101 440 101 410 101 724 101 720 101 723 101 785 101 522 101 430 101 495 101 505 101 474 101 487 101 492 101 491 101 483 101 499 101 420 101 498 101 500 101 493 101 730 101 900 101 740 101 660 101 641 101 872 101 710 101 680 101 509 101 510 101 481 101 479 101 145 101 690 101 637 101 650 101 195 101 191 101 445 101 600 101 flealth Fund [2211 640 221 2-16-201200-33100-6030 643 221 2)16-220200-67000-6030 GOVERNMENTAL FUNDS Genera' Fund [1011 2-32-201200-20001-6030 2-32-301200-20001-6030 2-32-401200-20001-6030 2-32-501200-20001-64330 2-17-802200-80301-6030 2-11-220103-10000-6030 2-21-220100-10000-6033 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-17-402200-70001-6030 2-11-250100-20300-6030 2-35-220000-12000-6030 2-35-244000-31100-6030 2-35-244000-33000-6030 2-35-242000.11000-6030 2-35-242000-44000-6030 2-35-242000-43000-6030 2-35-243000-11000-6030 2-35-230000-22100-6030 2-35-230000-31200-5030 2-35-230000-212006030 2-35-230000-22200-6030 2-35-210000-11000-6030 2-61-211001-10300-6030 2-11-101112-65001-6030 2-12-240000-41000-6030 2-12-601200-10001-6030 2-13-138502-15100-6030 2-17-912000-15000.6030 2-17-501200-50001-6030 2-15-402200-10001-8030 2-34-101203-40001-6030 2-34-403200-40005-6030 2-34-101200-31100.6030 2-34-101200-31200-6030 2-41-21100041700-6030 2-12-40120040010-6030 2-13-133203-12000.6030 2-12-701200-34000-6030 2-43-023301-20000-6030 2-43-023601-30000-6030 2-13-136203-15100-6030 2-22-221120-01000-6030 18-636111-10000-0735 52/1 District Court 52/2 - District Court 52/3 - District Court 52/4 • District Court Animal Control Auditing Cleric - Admin Cleric - Elections Clerk - Jury Commission Clerk - Legal Records Clerk - Register of Deeds Cleric - Vital Statistics Community & Economic Development Community Corrections Admin COrporation Counsel Courts-Duskiest Division Coo rts-FD - Judicial Courts-FD Juvenile Support Courts-FD-Court Services-Admin Courts-FD-Court Services-Adoptions Courts-FD-Court Services-Youth Assistance Courts-FD-Judiclat Support-Admin Couns-GJ-Assignment Courts-GJ-Family Support Courts-GJ-Judlcial Support Courts•GJ-Mediation Courts-Judicial Administration Drain Commissioner Emergency Response & Prep Unit Equalization Division Fiscal Services - Admin Materials Management - Gen Fund Medical Examiner MSU Extension - Oakland Personnel Probate - Judicial Admin Probate-Estates/Mental Health Support Probate-FD-Judicial Probate-FD-Judiclat Support Prosecuting Attorney • General Prosecution Purchasing Records Retention Reimbursement Division Sheriff Sheriff - CLEWS Support Services Treasurer Sub-Total Fund 101 Health Health Environmental Sub-Total Fund 221 DATA PROCESSING DEVELOPMENT FOR GOVERNMENTAL FUND APPROPRIATION )uventleAlaintenance Fund t291 665 293 2-16-501200-25001-6030 Children's Village Sub-Total Fund 293 IMAGING 722 2-21-221000.01000-6039 2-35-243000-33000-6039 512 2-34-403200-40005-6039 18-636111-10000-0573 TOTAL IMAGING DEVELOPMENT APPROPRIATION SUB-TOTAL GOVERNMENTAL / IMAGING DEVELOPMENT APPROPRIATION: 90-290000-25000-6030 Information Technology Development TOTAL GOVERNMENT: Cleric Image Courts-FD-Juv-Sup-Irnaging Probate-Estates/Mental Health Image Prepared by; Inlormation Technology: 1/23/04 1st Ctir 2004.xls INFORMATION TECHNOLOGY DATA PROCESSING DEVELOPMENT SUMMARY 1ST QUARTER 2004 let Otr 2nd Car 3rd Car 4th Olt ACCOUNT # DIVISION 00 - De; Jan - Mai Mr - June July - Seo Y.T.D NON-GOVERNMENTAL DIRECT CHARGES 055 CLEMIS 64,545.00 $4,545.00 471 Courts-FOC Exp-CS Enforcement Image $6.929.00 $6,929.00 470 Courts-FOG Exp-Family Counseling $432.00 $432.00 507 Courts-FOG Exp-CS Enforcement Image $1,281.00 $1,281.00 210 Fire Records Management System $1,890.00 $1,890.00 757 FM-Wk ReVJail MgVVido Cent 671,794.00 $71,794.00 750 FkA&0 53,754.00 $3,754.00 380 Health - Immunization Grant $1,134.00 $1,134.00 870 Medical Care Facility $6,932.00 $6,932.00 653 0.C. International Airport $5,684.50 $5.664.50 770 Parks and Recreation - Administration $468.00 $488.00 695 Risk Management $549.00 $549.00 656 Water & Sewer Accounting $4,899.00 $4,809.00 18-636111-10000-0715 SUB-TOTAL DIRECT CHARGES FOR DATA 010.31140 KM NM UM $110.311.50 PROCESSING DEVELOPMENT TOTAL COUNTY DEVELOPMENT CHARGES $1299.667.72 1192 UN $0.00 $1.299.857.7a NON-COUNTY AGENCIES 18-636111-10000-0429 Non-County Agencies 10,22 AIL4 11.44 fallg TOTAL DEVELOPMENT CHARGES $1,299,867.72 $0.00 $0.00 $00.00 $1,299.867.72 Prepared by; Information Technology; 12/18/03 1st Qtr 2004.xls 90603 95176 95196 95173 95186 95193 95474 $3,348.00 $0.00 $99.00 $1,597.50 $4,270.00 $10,600.00 $86,953.00 $17,505.00 $22,031.50 $13,822.00 $25,108.00 $1,920.00 $3,309.76 $568.00 $6,962.00 $0.00 $589.00 $671.00 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL- FIRST QUARTER, 2004 LAL# GOVERNMENTAL FUNDS 630 ANIMAL CONTROL 620 AUDITING 665 CHILDRENS VILLAGE 725 CLERK- ARMIN 440 CLERK - ELECTIONS 720 CLERK / REGISTER OF DEEDS 722 CLERK - IMAGING 410 CLERK - JURY COMMISSION( 724 CLERK - LEGAL RECORDS 723 cLERK -VITAL STATISTICS 522 COMMUNITY CORRECTIONS-ADMIN lC01 785 COMMUNITY & EGO DEVELOPMENT 430 CORPORATION COUNSEL 495 CTS-BUSINESS DIV. AIMS 487 CTS-FD-CT SEFIV-ADMIN 492 CTS-FD-CT SERV-ADOPTIONS 505 CTS-FD-JUDICIAL 483 CTS-FD-JUDICIAL SUPPORT-ADM 474 CTS-FD-JUVENILE SUPPORT 95682 Dog System Animal Control-Total 95468 Auditing-Cust Supt Auditing - Total 95665 Childrens Village Childrens Village - Total 72500 Clerk - Admin Clerk - Admin - Total 95443 Elections Clerk -Elections - Total 36510 GIS implementation Support-ROD 95493 Reg Deeds System Maintenance 95498 Clerk/Reg of Deeds 95558 User Support/ROD ClerWReg of Deeds - Total 65420 Clerk - Image Replace - 21% 95158 Clerk - Imaging Clerk - Imaging - Total 95512 Jury Commission Clerk -Jury Commission - Total 95189 Circuit Court System Clerk - Legal Records - Total 95161 Vital Stets Index Clerk - Vital Statistics - Total 52200 Comm Corr-Admin (County) Community Corrections - Total 36500 GIS Implementation Support C&E Dev 95785 Comm & Eco Developmt Community & Eco Dev - Total 95501 Corporation Counsel Corporation Counsel - Total JIMS - Circuit Court - 25% CTS-Business Div - JIMS CTS-Business Div - JIMS - Total CTS-FD-Ct Serv - Admin CTS-FD-Ct Serv-Admin - Total CTS-FD-Ct Serv-Adoptions CTS-FD-Ct Sew-Adoptions - Total CTS-FD/ADMIN-Family Judges CTS-FD-Judicial - Total CTS-FD-Judicial Suport-Adm CTS-FD-Judicial Suport-Adm - Total CTS-FD-Admin-Juvenile Support CTS-FD-Juvenile Support - Total $3.348.00 12,Qg 699.00 $1.597,50 $4.27120 $0.00 8,648.00 0.00 1.952,0Q $12,459.00 74 494.00 $17.505.00 22.031.5Q $11822.00 $25.108.00 $732.00 1.188,00 $2.318.00 $3,309.76 D..14 $568.0Q 0.962.00 $0.0Q $589.0Q $671.00 62,318.00 Prepared try; Information Technology; 12/18/03 1st Qtr 2004,xls $52,809.00 4,503.00 27,297.50 106.668..50 $191,278.00 $45,932.00 72,807.50 0.00 29,252.00 108.00 0.00 0.00 37,232.40 18,616.20 $203,948.10 36525 GIS Implementation Support Health 37025 CHAMPS - P.O.P. 96842 Health Admin Health - Total $61.00 8,451.00 58.772.00 $67,284.00 37002 Environmental $18,361.50 84200 El-I - Projects 16,438.00 84300 Ehealth Program QQQ Health-Environmental - Total 95440 Materials Management 95704 Performance Series - 25% Materials Mgmt-Gen Fund - Total 87202 Med Exam - Cust Support Medical Examiner • Total $34,799.50 $4,167.00 $9,013.00 $4,167.00 $0.00 $9.013.00 $47,381.30 6,841.00 3,307.90 37232.40 44043 PER-Systems Enhancements 95556 Personnel User Supt 96002 Human Res-Personnel 40% Personnel - Total INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER, 2004 499 CTS-GJ-ASSIGNMENT 420 CTS - GJ - FAMILY SUPPORT 498 CTS-GEN JUR IS-JUDICIAL SUPPT 500 CTS-GJ-MEDIATION 493 CTS-JUDICIAL ADMIN 730 DRAIN COMMISSIONER 95180 CTS-GJ-Assignment CTS-GJ-Assignment - Total 95195 Cir Crt Admin Courts - GJ - Family Support - Total 95179 CTS -Gen Juris-Judicial Suppt CTS -Gen Juris-Judicial Suppt - Total 95181 CTS-GJ-Mediation CTS-GJ-Mediation - Total 95174 CTS-Judicial Admin CTS-Judicial Admin - Total 28009 Drain Commissioner $0.00 28011 Drain Commissioner Application 0.00 36520 GIS Implementation Support Drain 40,770.00 95669 Water & Sewer Accounting QQQ Drain Commissioner - Total $17,104.00 $0.00 $40,610.50 $6.632.50 $1.121.50 $17,104.00 $0.00 $40,610.50 $6,632.50 $1,121.50 $40,770.00 900 EMERGENCY RESPONSE & PREPAREnNFSS 36545 GIS Implementation Support EMS 98990 Emergency Response ERP - Total $12,939.50 $7.522.00 $20,461.50 740 EQUALIZATION 660 FISCAL SERVICES ADMIN 840 HEALTH DEPARTMENT 843 HEALTH - ENVIRONMENTAL 641 MATERIALS MGMT-GEN SUPPORT SERV 872 MEDICAL EXAMINER 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 44077 BUD-System Maintenance 95702 Pert Series - Fiscal Services 25% 95703 Pert Series - Budget 25% 96001 Human Res-Acct 40% 96003 Human Res.-Budget 20% Fiscal Services Admin - Total 710 MSV EXTENSION- OAKLAND 36535 GIS Implem Support - MSU Ext $0.00 GIS implem Support - MSU Ext - Total $0.00 680 PERSONNEL Prepared by: Information Technoiogy; 12/18/03 1st Qtr 20O4ids $3,342.00 $3.309.76 $1,262.00 $23.170.0Q $756.00 $3,309,76 28,550,00 108,00 $648.00 $3.402.00 $8.699,50 $7,314.40 9.02.80 54,033.00 25.650.50 34.526,00 $5.255.60 1.708.00 3,489.50 108.00 6,927.09 3,538.00 19,947.00 11.796,0Q $827.45 9.905.25 $827.45 9,905.25 $827.45 9.905,25 $827.39 9.905.25 $3,342.00 $3,309.76 $1,262.00 $23,170.00 $756.00 $31,967.76 $4,050.00 $8,699.50 $16,847.20 $79,683.50 $34,526.00 $5,255.60 $47,513.50 $10,732.70 $10,732.70 $10,732.70 $10,732.64 690 PURCHASING 637 RECORDS RETENTION 550 REIMBURSEMENT 195 SHERIFF 191 SHERIFF - CLEWS 445 SUPPORT SERVICES 600 TREASURER 90606 JIMS • 52/1 DC - 6.25% 95527 DC Suprt-25%-52/1 52/1 District Court - Total 90607 JIMS - 52/2 DC - 6.25% 95528 DC Suprt-25%-52/2 52/2 District Court - Total 90608 JIMS - 5213 DC - 6.25% 95529 DC Suprt-25%-52/3 52/3 District Court - Total 90609 JIMS - 52/4 DC - 6.25% 95530 DC Suprt-25%-52/4 52/4 District Court - Total INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER, 2004 512 PROB-ESTATES/MENTL HLTH IMAGE 95207 Prob-Est/Mnti Filth Image Prob-Est/Mntl HIth Image - Total 509 PROB-JUDICIAL ADMIN 90604 JIMS Probate 25% Prob-Judicial Admin - Total 510 PROB-ESTATES/MENTL HLTH SUPPORT 92198 Prob-Est/Mntl Filth Support Prob-Est/Mntl Hlth Support - Total 481 PROBATE-FD JUDICIAL, 95168 Prob-FD Judicial Prob-FD Judicial - Total 479 PROB-FD-JUDICIAL SUPPORT 95188 PIROB-FD Judicial Support PROB-FD Judicial Support Total 145 PROSECUTOR - GENERAL PROSECUTION 90605 JIMS - Prosecutor 25% 95622 Prosecutor/Executive 97001 Prosecutor Data Proc Prosecutor - Total 44026 PUR-System/Customer Support 44027 PUR-System Maintenance Purchasing - Total 44054 Rec-New Development Rec-New Development - Total 95470 Reimbursement System 95542 Reimburse User Support Reimbursement - Total 97163 Sheriff 97164 Sheriff-Development 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-Systern Maintenance 44063 Tre-System Enhancement 95008 Del Tax On Line 95303 Del Tax System Maintenance 95561 User Support/Del Tax Treasurer - Total 540 52/1 DISTRICT COURT - NOVI 550 52/2 DISTRICT COURT - CLARKSTON 560 52/3 DISTRICT COURT - ROCHESTER 530 52/4 DISTRICT COURT - TROY 7 lsrt Qtr 200-I xis Prepared by; /nformation Technology; 12/18/03 Cust # DIRECT FUNDS 055 CLEMIS 471 CTS-F0C-EXP-CS ENFORC-IMAGE 470 CTS-FOC-EXP-FAM COUNSELING 507 CTS-FOC EXP-CS ENFORCEMENT 210 FIRE RECORDS MANAGEMENT SYSTEM 750 FM8igi 98003 CLEMIS Customer Support CLEMIS - Total 92194 CTS-FOC-Exp-CS Enf-Image CTS-FOC Exp-CS Enf-Image - Total 92195 CTS-FOC-Exp-Fam Counseling CTS-FOC-Exp-Fam Counseling - Total 92193 CTS-FOC Exp-CD Enforc-Dev CTS-FOC Exp-CD Enforc-Dev - Total 21010 Fire Records Mgmt Fund 531 Fire Records Mgmt - Total 21001 FM&O 75503 FM&O Development FM&O - Total 757 FM-WK RELEASE/JAIL MGMTNIDEO CONF 75700 Fac Mgmt - Video Arraignments 571,794,0D FM-Wk ReVJail MgmtNideo Cont - Total 380 klEALTH IMMUNIZATION - GRANT 38000 Health - Immunization $1.t31.00 Health - Immunization - Total 870 MEDICAL CARE FACILITY 98873 MCF - Support $6.932.00 MCF - Support - Total 653 O.C. INTERNATIONAL AIRPORT 65301 Airport User Support s5.e84.5o Airport User Support - Total 770 PARKS AND RECREATION 36530 GIS Implementation Support Parks Dept $0.00 95419 PRADM-Administration 488,00 Parks & Recreation - Total $4.545,00 $6.929.00 $432.00 $1.281,00 $1.890.00 $3,172.00 $582.00 695 RISK MANAGEMENT 656 WATER & SEWER ACCTG $549.00 19114 $854.00 4.045.00 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER, 2004 44036 ASK-System/Customer Support 95695 Risk Management Risk Management - Total 44049 WS-New Development 95669 Water & Sewer Acct'g Water & Sewer Acct'g - Total $4,545.00 $6,929.00 $432.00 $1,281,00 $1,890.00 3,754.00 $71.794.00 $1,134.00 $6,932.00 $5,684.50 $488.00 $549.00 $4,899.00 Prepared by; Information Technology; 12118/03 8 1st Qtr 2004.xls FISCAL NOTE (MISC. #04053) March 18, 2004 BY: FINANCE COMMITTEE, CHUCK MOSS, CHAIRPERSON IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FIRST QUARTER 2004 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 First Quarter 2004 Development cost to benefiting departments. 2. The first quarter data processing development charges are $1,099,261.22; imaging development charges are $90,295.00 for General Fund/General Purpose departments; direct charges to Special Revenue and Proprietary fund departments are $110,311.50 and charges to non-county agencies are $0. 3. The respective departmental Fiscal Year 2004 budgets are to be amended as specified in the attached detail schedule. FINANCE COMMITTEE FINANCE COMMITTEE Motion carried unanimously on a roll call vote. Resolution #04053 March 4, 2004 The Chairperson referred the resolution to the Finance Committee. There were no objections. 12-2- to 010 moo G. William Caddell, County Clerk Resolution #04053 March 18, 2004 Moved by Crawford supported by Hatchett the resolutions on the Consent Agenda, be adopted (with accompanying reports being accepted). Discussion followed. Vote on resolutions on the Consent Agenda: AYES: Coleman, Coulter, Crawford, Douglas, Gregory, Hatchett, Jamian, Knollenberg, Kowell, Law, Long, McMillin, Middleton, Moffitt, Moss, Palmer, Patterson, Potter, Rogers, Scott, Suarez, Webster, Wilson, Zack, Bullard. (25) NAYS: None. (0) A sufficient majority having voted therefore, the resolutions on the Consent Agenda were adopted (with accompanying reports being accepted). 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 18, 2004 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 18th day of March, 2004,