The URL can be used to link to this page

Home My WebLink AboutResolutions - 1999.08.19 - 25611MISCELLANEOUS RESOLUTION #99200 August 19, 1999 BY: FINANCE COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY -THIRD QUARTER 1999 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 Department of Information Technology budget and then an amount equal to the actual expense is transferred to the user department with a summary report to the Finance Committee; and WHEREAS the Department of Information Technology has determined the Third Quarter 1999 data processing development charges to be $1,177,915 and the imaging development charge to be $42,488 for the governmental fund County departments; and WHEREAS direct charges to non-governmental fund departments are $25,598 and non-county agencies are $15,744 for the Third Quarter 1999; and WHEREAS an appropriation transfer to governmental fund county departments is needed to fund these development charges. NOW THEREFORE BE IT RESOLVED that the Oakland County Board of Commissioners has reviewed the Third Quarter 1999 Data Processing Development and approves the third quarter appropriation transfer. Chairperson, on behalf of the Finance Committee, I move the adoption of the foregoing resolution. FINANCE COMMITTEE FINANCE COMMITTEE VOTE: Motion carried unanimously on a roll call vote with Friedman Appel, Coleman and Obrecht absent. ACCOUNT GeneraWA:SLIM) 101 2.32-201200-20001-6030 101 2-32-301200-20001-6030 101 2-32-401200-20001-6030 101 2-32-501200-20041-6030 101 2-11-220100-10000-6030 101 2-51-211000-10000-6030 101 2-31.101200.100131-6030 101 2-21-230100-01000-6030 101 2-21-250100-01000-6030 101 2-21.221000-01000-6030 101 2-21-240100-01000-6030 101 2-21-220500-01000-6030 101 2-19-210000-10000.6030 101 2-11-250100-20000-6030 101 2-11-210100-01000-6030 101 2-19-221000-10000.6030 101 2-61-211001-10000-6030 101 2-12.240000-4410116030 101 2-12-601200-10001-6030 101 2-12-621200-10001-6030 101 2-16-912000-15000-6030 101 2-17-501200.10001-6030 101 2-15-402200-10001-8030 101 2-34-401200-40001-8030 101 2-34-101200-40001-6030 101 2-M-211000-10000-6030 101 2-12-401200-40010-6030 101 2-13-138203-00010-6030 101 2-12-701200-10001-0030 101 2-51-231000-53000-6030 101 2-43-023310-20021-6030 101 2-13-138201-00010-6030 101 2-22-221120-01000-6030 101 2-17-302200-30001-6030 Friend of the Court Fund 121 215 2-12-705212-10401-6030 215 2-31-201200-10004-6030 Healthiund 12211 221 2-17-802200-10001-6030 221 2-18-213000-60000-6030 221 2-16-201200-10000-6030 221 2-16-220200-65000-6030 18-636111-10000-0735 2-2 -221000-01000-6039 2-31-201200.10004-6039 2-34-10/.200-40001-6039 18-636111-10000-0573 2-18-101112-10000-6030 2-18-101112-14000-6039 DIVISION 5211 District Court 5212 District Court 52/3 District Court 52/4 District Court Auditing Board of Commissioners - Adm. Circuit Court - Administration Clerk - Elections Clerk - Jury Commission Clerk - Legal Records Clerk - Register of Deeds Clerk - vital Statistics Community & Economic Development Corporation Counsel County Executive Development & Planning Division Drain Commissioner Equalization Division Fiscal Services - Admin Fiscal Services - General Medical Examiner M.S.U. Extension - Oakland Personnel Probate Court - Estates & Mental Health Probate Court - Juvenile Prosecuting Attorney Purchasing Records Retention Reimbursement Division Research Library Sheriff Support Services Treasurer Veteran's Services Sub-Total Fund 101 FCC/Child Support/Reimbursement Friend of the Court Sub-Total Fund 215 Animal Control IT -EMS Health Health Enywonmental Sub-Total Fund 221 DATA PROCESSING DEVELOPMENT FOR GOVERNMENTAL FUND APPROPRIATION Clerk Friend of the Court Probate TOTAL IMAGING DEVELOPMENT APPROPRIATION Information Technology Imaging Development TOTAL GOVERNMENT: Juvenile Maintssiancalund [29: 293 2-16-501200-25000-6030 (2931 Children's Village Sub-Total Fund 293 LLD. 62,152.91 62,152.91 62,152.91 62,152.90 299.00 0.00 293.180.68 57,550.50 18.790.50 44.561.75 10,682.00 5,181.50 22,608.50 2,411.50 166.00 77.359.25 1,084.00 303,718.25 266,081.64 69,181.57 101,949.00 2,377.00 127.714,14 88,666.40 73,743.50 61,736.00 7,034.00 0.00 76,310.40 0.00 40.71425 1,310.00 232,032.60 355.00 2,235,411.96 0.00 495,361.50 495,361.50 476.00 2,609.2$ 168,239.50 20.9/0310 192,314.75 5.452210 5,522.50 2.928.110.71 15,732.43 53,405.71 3,737.61 72,875.75 (2,928.610.71) (72,875.75) 69.0P INFORMATION TECHNOLOGY DATA PROCESSING DEVELOPMENT SUMMARY 3RD QUARTER 1999 151 QV 2nd Otr 3rd Ott 4th Ott Jarltlilar 6,990$ 14..-_Ba91 7,68057 12,067.99 42,384 35 7,680.57 12,068.00 42,384.34 7,680.57 12,088.00 42.384.34 7,680.54 12,488.01 42,384.35 47,00 252.00 25.049.50 59,766.25 208,363.13 34,170.00 11,685.00 11,695.50 3,216.00 6,342.25 9232.25 4,893.25 16,990.75 22,677.75 1,269.00 2,756.50 6.656.50 1,817.50 1,493.00 1,871.00 4,819.50 17,789.00 940.00 1,417.00 54.50 168.00 479.25 522.00 76,358.00 852 00 232.00 142,390.50 102,552.75 58,775.00 99,178.38 84,974.76 81,928.50 33,673,44 14,375.13 21,133.00 17,249.00 41,480.50 43,219.50 564,40 1,813,00 64,157.38 25,807.26 37,749,50 56,553.00 14,805.50 17,307.50 36,377.50 15,652.00 21,714.00 11,902.00 28,518,75 21,315.25 1,692.00 2,180.00 3,162.00 19,748.00 24,391.00 32,171.00 7.038.50 7,215.75 26,460.00 684.50 625.50 71.692.10 72,737.00 87,603.50 355.20 (LW 666,026 55 591,334.15 978,051 26 178,69210 172113.25 143.73625 178,692.00 172.913 25 143,756.25 308.00 84.00 84.00 2.609 25 87,523.50 37,715.00 43.001.00 15±104 14.5112.60 113,14.06 90.594.75 48,301.00 53,419.00 1.313.0 1.52.1,24 URA 1,313 50 1,521.00 2,683.00 936.621.10 114.069.40 1i77.914.51 2,06628 4.301.96 8,764.21 8,672.47 13,292.01 31,441.23 573Z7 881.53 2.21181 11.91.211) 1E1.475.50 42.41125 (936,626.80) (814,069.40) (1,177,914.51) (11.912.00) (18,475.50) (42,488.25) Prepared by Linda Swartz Info Tech, 08/04/99; 08 03 AM 1 3FY99DEV.INK4 INFORMATION TECHNOLOGY DATA PROCESSING DEVELOPMENT SUMMARY 3RD QUARTER 1999 let Cie 2nd Gtr 3rd Qtr 4111 Ott ACCOUNT I DIVISION OsilJAC .810_,Iittat apr..4132 Ifiy..zattpt LLD. Community Corrections 273.00 ' 273.00 Community Development Grant 3,358.75 2.376.00 2,855.50 8,590.25 Community Mental Health - Admin 13,205.00 8.492.00 4,536.00 26233.00 Facilities Maintenance & Operations 2,616.25 2.47100 3,571.50 8.660.75 FOC - Medical Support 1,916.00 721.50 2,637.50 Garage 192.50 192.60 Health Immunization 2.002.00 210.00 714.00 2226.00 Materials Management 799.00 109.00 908.00 Medical Care Facility 1,974.00 599.50 7.822.50 10,396.00 Oakland County International Airport 0.00 Parks and Recreation - Administration 115.50 1,108.00 2.274.00 3,497.50 Risk Management 0.00 Telephone Communications 381.50 272.50 664.00 Water & Sewer Accounting 1,462.50 1,454.25 3,278.50 6,195.25 100% Tax Payment Fund 12.101.00 52.783.00 QM 65 089.00 18-636111-10000-0715 DIRECT CHARGES FOR DATA SAWA $70,707.75 125.897„,fig $1311152.75 PROCESSING DEVELOPMENT TOTAL DEVELOPMENT CHARGES MAIM S903,252.65 $1146,000.21 13,137,73921 18-636111-10000-0429 Sidvrell 11,585.50 12,896.50 15,744.00 40,226.00 18-636111-10000-0759 Traffic Improvement Association 952.50 QM 100 962.50 TOTAL NON-COUNTY AGENCIES 12.54L00 12.111.50 14144.99 41.111.512 (Information Purposes Only) Information Technology 783,988.76 653,847.75 803,047.75 2,240.884.26 Prepared by: Linda Swartz. Info Tech; 08/04/99; 08:03 AM 2 3FY99DEV.WK4 Qat/ GOVERNMENTAL FUNDS 630 ANIMAL CONTROL 620 AUDMNQ• 665 CHILDRENS VILLAGE 420 CIRCUIT COURT 440 CLERK ELECTIONS 722 CLERK. IMAGING $84.00 $252.00 $252.00 $2,688.00 L688.0Q $2.688.0Q $7,272.50 15,405 25 $22.677.75 SLEt71.00 11,EUM $5.4.6.0 loam 76,358.00 $232,00 520.767.00 26,266.50 11,741.5.0 $20,163.50 24,649.00 3.7.116.00 81,871.00 $17,789.00 $54.50 $168,00 $76,358.00 $232.00 $58,775.00 ,2C.50 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER, 1999 720 CLERK! REGISTER OF DEEDS 410 CLERK - JURY COMMISSION 95682 Dog System Animal Control - Total 95468 Auditing-Cust Supt Auditing - Total 95665 Childrens Village Childrens Village - Total 90402 PA189 LIDS Ciro CI - 50% $139,045.13 95195 Cir Court Admin 15,950.25 95452 Assignment Clerk 53.367.75 Circuit Court - Total $208,363.13 95493 Reg Deeds System Maintenance $546.00 95558 User Support/ROD 6110.50 Clerk/Reg of Deeds - Total $6,656.50 95443 Elections ituitua Elections - Total $11,695.50 65420 Clerk - Image Replace - 21% $8,441.21 95158 Clerk - Imaging 32.1.01:1 Clerk - Imaging - Total $8,764.21 95512 Jury Commission $5232.25 Jury Commission - Total $9,232.25 724 CLERK - LEGAL RECORDS 723 CLERK -VITAL STATISTICS 785 C_OMNIUNITY & E_O_ONOMIC DEVELOPMENT 430 CORPORATION COUNSEL 015 COILEIrLEXECLITIVE 775 DEVELOPMENT & PLANNING 730 DRAIN QQMMISSIONER 740 EQUALIZATION 660 FISCAL_StRYLCES_ADMIN 95170 Legal Division 95189 Circuit Court System Clerk - Legal Records - Total 95161 Vital Stats Index Clerk - Vital Statistics - Total 95785 Comm & Eco Devlopmt Community & Eco Dev - Total 95501 .Corporation Counsel Corporation Counsel - Total 95656 County Executive Support County Executive - Total 95608 D&P Data Warehousing Dev & Planning - Total 28009 Drain - Administration Drain Commissioner - Total 31075 Equal - Development 95559 User Support/Equal 95693 Equal-System Maintenance Equalization - Total 44021 FS-System/Customer Support 44022 FS-System Maintenance 96001 Human Services - Accfg Fiscal Services Admin - Total Prepared by Linda Swartz, Info Tech; 07/15/99:10:09 AM I 3FY99DEV.1VK4 $21,133.00 $143,756.25 95556 95560 96002 95200 95202 95203 $43,001.00 $10,334.00 $43219.50 $37.749.50 $17,307.50 $2,282.81 521.714.00 $21,315.25 $3.162.00 $32,171.00 $26,460.00 $625.50 INFORMATION TECHNOLOGY • RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - THIRD QUARTER, 1999 Gush GOVERNMENTAL FUNDS 670 EISCAL_SEE NESAI. 44076 Bud-SystemCustorner Support 44077 Bud-System Maintenance 96003 Human Resources - Budget Fiscal Services - General - Total $558.50 2,016.50 I 8.558 00 470 moo OF THE COURT 471 FRIEND OF THE _CT IMAGING 840 HEALTH DEPARTMENT 843 tlEAL.Th - ENVIRONMENTAL 872 MEDICALIXAMINES 680 PERSONNEL 480 pRoBATE_CoURT 482 PROBATE -IMAGING 481 PRoBATEJILVENILE 1 45 F_EUISE_QUIOE 690 EURCJIAsiNG 650 13EIMILURSEmEiti 195 attERIF_E 445 S_UP_EORLSERVICES 600 TREASURER 34041 Friend of the Court Friend of the Court - Total 34042 FOC Develop Image 65410 FOC-Image Replace-74% FOC Develop Image - Total CHAMPS - P.O.P. Health South PC Net Health - Admin Health - Total 37002 Environmental Health-Environmental - Total 87202 Med Exam - Cust Support Medical Examiner - Total Personnel User Supt Personnel - Employee Human Res. - Personnel Personnel - Total Probate - Admin Probate - Estates Probate - Field Services Probate - Total 48200 Probate - Imaging Probate - Imaging - Total 95191 Probate Crt Juv Div Prbbate Juvenile - Total 95622 Prosecutor/Executive Prosecutor - Total Pur-System/Customer Support Pur-System Maintenance Purchasing - Total 95470 Reimbursement System Reimbursement - Total 97163 Sheriff Sheriff - Total 44500 Support Services User Support Support Services - Total Tre-Data Warehousing Ire-System/Customer Support Del Tax System Maintenance DTX - Enhance/Development User Support/Del Tax Treasurer - Total 5143 756.25 $24,878.00 3'15.00 manam 'amigo 543.21950 579.00 54.50 37.116.00 2313.50 14.364.00 MOO 52.28211 $21,714,C10 21,31125 ' $272.50 2.6112.50 32i/1.0 $625-5.0 $7,040.00 218.00 29,086.50 16,536.50 34.722..50 $87,603.50 37025 96841 96842 44026 44027 44012 44061 95303 95313 95561 $1.696.00 29.745.23 $1.696.00 29.745.23 $31,441.23 Prepared by: Linda Swartz, Info Tech; 07/15/99; 10:09 AM 2 3FY99 Ciati GOVERNMENTAL FUNDS 540 5211 DISTRICT COURT. NOVI 550 5212 DISTRICT COURT - CLARKSTON 560 5213 DISTRICT COURT - ROCHESTER 530 5214 DISTRICT COURT TROY INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL. THIRD QUARTER, 1999 90403 PA189 LIDS 52/1 DC- 12.5% 95530 DC Suprt-24%-5214 5211 District Court - Total 90404 PA189 LIDS 52/2 DC 12.5% $34,761.28 95528 DC Suprt -25%42/2 7121.06 52/2 District Court - Total $42,384.34 90405 PA189 LIDS 52/3 DC 12.5% $34.781.28 95529 DC Suprt -25%-52/3 7.623..06 52/3 District Court - Total $42,384.34 90406 PA189 LIDS 52/4 DC - 12.5% 95530 DC Suprt -25%-52/4 52/4 District Court - Total 134,761.28 7 623.07 $42,384.35 $34,7;1.28 7.823.07 $42,384.35 Prepared by; Linda Swartz. Info Tech; 07/15/99; 10:09 AM 3 3FY99DEV.VV1(4 $11.4.1:10 $189,418.50 21,054.50 4,796.00 170,803.00 117,799.25 4,687.00 31,889.00 21,594.50 206,381.00 8,023.00 6,164.50 $lalom $7.822.50 $2,274.00 $272.50 $3,278.50 $273.00 $2,855.50 $4,536.00 $3,571.50 $714.00 $784,68115 $18,366.50 $7,822.50 $2,274.00 $272.50 $3,278.50 $15,744.00 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER, 1999 Quit DIRECT FUNDS 657 COMMUNITY CORRECTIONS 661 COMMUNITY DEVELOPMENT 663 CMH - ADMIN 750 EAC.MAINTILGEEBAnGNS 380 HEALTH IMMUNIZATION - GRANT 010 INFORMATION TECHNOLOGY Systems Devilop/Suppert Technical Sys/Networking 870 MEDICALCA8E.EAGILL1a 770 PARKS AND RECREATION 751 LT. r_TELEeNONE_CKINIKUNICATIONLS 656 W.AIERALSE N.QINSLOUNTY AGENCIES 65701 Community Corrections Grant Community Corrections - Total 66103 Comm Dev User Support Community Development - Total 66306 CMH System Development CMH Admin - Total 75503 FM0 Development FM&O - Total 38000 Health - Immunization Health - Immunization - Total Year 2000 Project GIS-Administration Open Systems Administration Oracle Administration IT DISC Data Warehouse IT DISC Enhanced Access IT DISC GIS Health Grant Overhead CVT - New Development I.T. - New Operating System Equipment Inventory I.T. - Disaster Recovery 95689 Database Tech Support 98873 MCF - Support MCF - Support - Total 95419 PRADM-Administration 21012 l.1. - COMMUNICATIONS 13.-Telephone Comm - Total 95669 Water & Sewer Acct'g Water & Sewer Accfg - Total 02000 25100 25200 25400 30001 30002 30003 84200 91516 95150 95456 95685 UM%) $2,855 50 $3571.50 4 3FY99DE .VVK4 Prepared by: Linda Swartz, Info Tech; 07115199; 10.09 AM Resolution #99200 August 19, 1999 Moved by Douglas supported by Palmer the resolutions on the Consent Agenda be adopted (with accompanying reports being accepted). AYES: Causey-Mitchell, Colasanti, Coleman, Devine, Dingeldey, Douglas, Galloway, Garfield, Gregory, Jensen, Law, McCulloch, McPherson, Melton, Millard, Moffitt, Obrecht, Palmer, Patterson, Schmid, Sever, Suarez, Taub, Amos. (24) NAYS: None. (0) A sufficient majority having voted therefor, the resolutions on the Consent Agenda were adopted (with accompanying reports 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 August 19, 1999 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)79th 7 d of August, 1999. ? G. William Caddell, County Clerk