Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Resolutions - 2001.08.02 - 26320
MISCELLANEOUS RESOLUTION #01 1 97 August 2, 2001 BY: General Government Committee, William R. Patterson, Chairperson IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - SECOND QUARTER 2001 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 Second Quarter 2001 data processing development charges to be $1,028,072 and the imaging development charge to be $32,166 for the General Fund/General Purpose County departments; and WHEREAS direct charges to Special Revenue and Proprietary fund departments are $234,402 and non-county agencies are $35,889 for the Second Quarter 2001; 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 Second Quarter 2001 Data Processing Development Report and approves the Second 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 Motion carried unanimously on a roll call vote with Law absent. Children's Village Sub-Total Fund 293 Juvenile Maintenance Fund 12931 2-16-501200-25001-6030 2931 9.216,71 6,311.79 0.00 0.00 15 528.50 9,216.71 6,311.79 0.00 0.00 15,528.50 Info Tech; 4/2512001; 10:24 AM DATA PROCESSING DEVELOPMENT FOR GOVERNMENTAL FUND APPROPRIATION TOTAL IMAGING DEVELOPMENT APPROPRIATION TOTAL GOVERNMENT: Clerk Image Courts-FD-Juv-Sup-lmaging Courts-FOC Exp-CS Enforcement Image Probate-Estates/Mental Health Image Information Technology Development 18-636111-10000-0735 2-21-221000-01000-6039 2-35-243000-33000-6039 2-35-241215-71000-6030 2-34-403200-40005-6039 18-636111-10000-0573 90-290000-25000-6030 Prepared by: Linda Munk, 1 168 850.93 1,028,071.58 0.00 0.00 2 196 922.51 14,072.96 22,174.02 0.00 0.00 36,246.98 0.00 112.71 0.00 0.00 112.71 18,034.70 0.00 0.00 0.00 18,034.70 12 455.94 9,879.45 0.00 0.00 22 335.39 44 563.60 32 166.18 0.00 0.00 76.729,78 (1,213,414.53) (1,060,237.76) 0.00 0.00 (2,273,652.29) $0.00 $0.00 $0.00 $0.00 0.00 2nd qtr 2001.xls INFORMATION TECHNOLOGY DATA PROCESSING DEVELOPMENT SUMMARY 2ND QUARTER 2001 ACCOUNT 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr DIVISION Oct - Dec Jan - Mar Apr - June July - Sept Y.T.D. General Fund 11011 2-32-201200-20001-6030 2-32-301200-20001-6030 2-32-401200-20001-6030 2-32-501200-20001-6030 2-17-802200-80001-6030 2-11-220100-10000-6030 2-21-220100-01000-6030 2-21-230100-01000-6030 2-21-250100-01000-6030 2-21-221000-01000-6030 2-21-240100-11000-6030 2-21-220500-01000-6030 2-35-242000-11000-6030 2-35-242000-42000-6030 2-35-242000-43000-6030 2-35-242000-44000-6030 2-35-243000-11000-6030 2-35-230000-21200-6030 2-35-230000-22100-6030 2-35-230000-31200-6030 2-35-230000-25000-6030 2-35-230000-22200-6030 2-35-210000-11000-6030 2-12-240000-44100-6030 2-12-601200-10001-6030 2-12-621200-10001-6030 2-16-912000-15000-6030 2-17-501200-50001-6030 2-15-402200-10001-6030 2-34-403200-40001-6030 2-34-403200-40005-6030 2-34-101200-31100-6030 2-34-101200-31200-6030 2-41-211000-10000-6030 2-12-401200-40010-6030 2-13-138203-00010-6030 2-12-701200-10001-6030 2-43-023301-20000-6030 2-13-138201-00010-6030 2-22-221120-01000-6030 Health Fund 12211 2-23-221112-65001-6030 2-16-201200-33100-6030 2-16-234200-54600-6030 2-16-220200-67000-6030 52/1 District Court 52/2 District Court 52/3 District Court 52/4 District Court Animal Control Auditing Clerk - Admin Clerk - Elections Clerk - Jury Commission Clerk - Legal Records Clerk - Register of Deeds Clerk - Vital Statistics Courts-FD-Court Services-Admin Courts-FD-Court Services-Clinic Courts-FD-Court Services-Youth Assistance Courts-FD-Court Services-Adoptions Courts-FD-Judicial Support-Admin Courts-GJ-Judicial Support Courts-GJ-Assignment Courts-GJ-Family Support Courts-GJ-Legal Courts-GJ-Mediation Courts-Judiclai Administration Equalization Division Fiscal Services - Admin Fiscal Services - General Medical Examiner M.S.U. Extension - Oakland Personnel Probate-Estates/Mental Health Admin Probate-Estates/Mental Hearth Support Probate-FD-Judicial Probate-FD-Judicial Support Prosecuting Attorney Purchasing Records Retention Reimbursement Division Sheriff Support Services Treasurer Sub-Total Fund 101 CLEMIS-EMS Health Health - Clinic Health Environmental Sub-Total Fund 221 11,716.73 7,064.25 0.00 0.00 18,780.98 11,716.73 7,064.25 0.00 0.00 18,780.98 11,716.73 7,064.25 0.00 0.00 18,780.98 11,716.73 7,064.24 0.00 0.00 18,780.97 1,976.94 112.71 0.00 0.00 2,089.65 0.00 5,576.80 0.00 0.00 5,576.80 22.26 0.00 0.00 0.00 22.26 58,545.00 31,384.91 0.00 0.00 89,929.91 6,836.70 7,596.89 0.00 0.00 14,433.59 30,835.97 11,268.56 0.00 0.00 42,104.53 3,813.56 12,345.82 0.00 0.00 16,159.38 1,640.54 3,853.30 0.00 0.00 5,493.84 1,090.86 872.71 0.00 0.00 1,963.57 1,596.00 0.00 0.00 0.00 1,596.00 44.52 845.33 0.00 0.00 889.85 8,999.08 7,934.37 0.00 0.00 16,933.45 1,472.70 4,071.85 0.00 0.00 5,544.55 36,327.35 16,686.55 0.00 0.00 53,013.90 9,663.86 6,034.90 0.00 0.00 15,698.76 14,586.00 16,284.00 0.00 0.00 30,870.00 18,747.00 0.00 0.00 0.00 18,747.00 1,340.90 8,854.17 0.00 0.00 10,195.07 1,380.28 672.07 0.00 0.00 2,052.35 143,817.20 198,066.20 0.00 0.00 341,883.40 182,377.26 200,016.94 0.00 0.00 382,394.20 46,130.77 47,976.73 0.00 0.00 94,107.50 47,864.46 12,938.78 0.00 0.00 60,803.24 997.37 0.00 0.00 0.00 997.37 89,411.95 96,343.70 0.00 0.00 185,755.65 2,486.26 7,38305 0.00 0.00 9,869.31 7,605.62 6,706.70 0.00 0.00 14,312.32 4,490.10 2,251.32 0.00 0.00 6,741.42 522.07 539.63 0.00 0.00 1,061.70 18,524.83 5,166.23 0.00 0.00 23,691.06 534.30 2,844.46 0.00 0.00 3,378.76 0.00 6,657.64 0.00 0.00 6,657.64 11,860.00 1,269.47 0.00 0.00 13,129.47 77,540.02 73,580.78 0.00 0.00 151,120.80 30,719.05 (786.28) 0.00 0.00 29,932.77 68 454.57 95 726.36 0.00 0.00 164 180.93 979,122.27 919,333.64 0.00 0.00 1,898,455.91 69,411.81 0.00 0.00 0.00 69,411.81 22.244,20 0.00 0.00 0.00 22 244.20 91,656.01 0.00 0.00 0.00 91,656.01 0.00 23,021.05 0.00 0.00 23,021.05 1,429.27 12,127.61 0.00 0.00 13,556.88 22,223.40 12,655.73 0.00 0.00 34,879.13 65.203,27 54 621.76 0.00 0.00 119.825,03 88,855.94 102,426.15 0.00 0.00 191,282.09 Friend of the Court Fund 12151 2-35-241215-71000-6030 Courts-FOC-Exp-CS Enforcement 2-35-241215-81000-6030 Court-FOC Exp-Family Counseling Sub-Total Fund 215 INFORMATION TECHNOLOGY DATA PROCESSING DEVELOPMENT SUMMARY 2ND QUARTER 2001 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr ACCOUNT # DIVISION Oct - Dec Jan - Mar Apr - June July - Sept Y.T.D. Community Corrections Community & Home Improvement Courts-FOC-Exp-CS Enforcement Courts-FOC Exp-CS Enforcement Image Courts-FOC Exp-Family Counseling Facilities Maintenance & Operations Health Immunization Materials Management Medical Care Facility PA189 Projects Parks and Recreation - Administration Risk Management Treasurer - 100% Tax Payment Fund Water & Sewer Accounting 18-636111-10000-0715 DIRECT CHARGES FOR DATA PROCESSING DEVELOPMENT 10,490.98 6,439.24 0.00 0.00 16,930.22 54.95 139.42 0.00 0.00 194.37 0.00 36,873.87 0.00 0.00 36,873.87 0.00 20,524.32 0.00 0.00 20,524.32 0.00 17,335.62 0.00 0.00 17,335.62 89.05 0.00 0.00 0.00 89.05 6,937.08 2,874.13 0.00 0.00 9,811.21 0.00 450.84 0.00 0.00 460.84 16,127.36 6,417.00 0.00 0.00 22,544.36 163,173.89 118,974.13 0.00 0.00 282,148.02 5,759.86 1,603.33 0.00 0.00 7,363.19 0.00 334.00 0.00 0.00 334.00 25,606.56 17,639.80 0.00 0.00 43,246.36 6,100.01 4,796.64 0.00 0.00 10 896.65 $234.339.74 $234,402.34 $0.00 $0.00 468 742.08 TOTAL DEVELOPMENT CHARGES $1.447,754.27 $1,294,640.10 $0.00 $0.00 2.742,394.37 18-636111-10000-0429 Sidwell 42 273.02 35 888.91 0.00 0.00 78 161.93 TOTAL NON-COUNTY AGENCIES 42 273.02 35 888.91 0.00 0.09 78,161.93 (Information Purposes Only) Information Technology 737,902.01 793,950.89 0.00 0.00 1,531,852.90 Prepared by: Linda Munk, Info Tech; 4/2512001, 10:25 AM 2nd qtr 2001.xls INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER, 2001 Cust# GOVERNMENTAL FUNDS 630 ANIMAL CONTROL 95682 Dog System $112.71 Animal Control - Total $112.71 620 AUDITING 44032 Aud-System Maintenance $5576.80 Aud-System Maintenance - Total $5,576.80 665 CHILDRENS VILLAGE 95665 Childrens Village $6,311.79 Childrens Village - Total $6,311.79 900 CLEMIS -EMS 95479 CLEMIS-EMS Gust Suppt $23,021.05 -- CLEMIS-EMS - Total $23,021.05 720 CLERK! REGISTER OF DEEDS 95.493 Reg Deeds System Maintenance $9,974.84 95558 User Support/ROD 2,370.98 Clerk/Reg of Deeds - Total $12,345.82 440 CLERK ELECTIONS 95443 Elections $31,384.91 Elections - Total $31,384.91 722 CLERK-IMAGING 65420 Clerk-Image Replace-21% $20,102.03 95158 Clerk-Imaging 2,071.99 Clerk - Imaging - Total $22,174.02 410 CLERK -JURY COMMISSION 95512 Jury Commission $7,596.89 Jury Commission - Total $7,596.89 724 CLERK - LEGAL 95170 Legal Division $252.01 95189 Circuit Ct System 11 016.55 Clerk - Legal - Total $11,268.56 723 CLERK - VITAL STATISTICS 95161 Vital Stats Index $3,853.30 Clerk -Vital Statistics - Total $3,853.30 487 CTS-FD-COURT SERVICES-ADMIN 95196 CTS-FD-Ct Serv - Admin $872.71 CTS-FD-Ct Serv - Admin - Total $872.71 492 CTS-FD-CT SERV-ADOPTIONS 95173 CTS-FD-Ct Serv-Adoptions $7,934.37 CTS-FD-Ct Serv-Adoptions - Total $7,934.37 491 CTS-FD-CT SERV-YOUTH ASST 95172 CTS-FD-Ct Serv-Youth $845.33 CTS-FD-Ct Serv-Youth Asst - Total $845.33 483 CTS-FD-JUDICIAL SUPPORT-ADM 95193 CTS-FD-Judicial Support $4,071.85 CTS-FD-Judicial Support Adm - Total $4,071.85 488 CTS-FD-JUV-SUP-IMAGING 48201 CTS-FD-Juv Supp-Image $112.71 CTS-FD-Juv Supp-Image - Total $112.71 499 CTS-GJ-ASSIGNMENT 95180 CTS-GJ-Assignment $6,034.90 CTS-GJ-Assignment - Total $6,034.90 420 COURTS - GJ - FAMILY SUPPORT 95195 Cir Crt Admin 16,284.00 Courts - GJ - Family Support - Total $16,284.00 498 CTS-GEN JURIS-JUDICIAL SUPPT 95179 CTS -Gen Juris-Judicial Suppt $16,686.55 CTS -Gen Juris-Judicial Suppt - Total $16,686.55 500 CTS-GJ-MEDIATION 95181 CTS-GJ-Mediation $8,854.17 CTS-GJ-Mediation - Total $8,854.17 Prepared by: Linda Munk, Info Tech; 4/24/2001; 1 2nd qtr 2001 recep.xls 845 HEALTH - CLINIC 843 HEALTH - ENVIRONMENTAL INFORMATION TECHNOLOGY- RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER, 2001 Cust # GOVERNMENTAL FUNDS 493 CTS-JUDICIAL ADMIN 95174 CTS-Judicial Admin $672.07 CTS-Judicial Admin - Total $672.07 740 EQUALIZATION 31075 Equal - Development $5,273.90 31078 EPP-Development 83,985.63 95559 User Support/Equal 22,855.79 95690 Personal Property 26,890.32 95693 Equal-System Maintenance 59 060.56 Equalization - Total $198,066.20 660 FISCAL SERVICES ADMIN 44021 FS-System/Customer Suppor4-- $16,501.91 44022 FS-System Maintenance 49,192.24 44023 FS-System Enhancements 39,721.84 96001 Human Res - Acct 94 800.95 Fiscal Services Admin - Total $200,016.94 670 FISCAL SERVICES • GENERAL 44076 Bud-System/Customer Support $676.26 96003 Human Resources - Budget 47 300 47 Fiscal Services - General - Total $47,976.73 840 HEALTH DEPARTMENT 872 MEDICAL EXAMINER 37025 CHAMPS - P.O.P. $3,499.66 96842 Health - Admin 8,627.95 Health - Total $12,127.61 37007 Clinic $12.655.73 Health-Clinic - Total $12,655.73 37002 Environmental $1,318.72 84200 EH - Projects 53 303.04 Health-Environmental - Total $54,621.76 87202 Med Exam - Cust Support $12.938.78 Medical Examiner-Total $12,938.78 680 PERSONNEL 95556 Personnel User Supt $1,742.75 96002 Human Res. - Personnel 94.600,95 Personnel - Total 480 PROB-ESTATES/MENTL HLTHADMIN 95200 Prob-Est/Ment Hlth-Admin $7,383.05 Prob-Est/Ment Htth-Admin - Total 512 PROB-ESTATES/MENTL HLTH IMAGE 95207 Prob-Est/Mntl Hlth Image $9,879.45 Prob-Est/Mntl Filth Image - Total 510 PROB-ESTATES/MENTL HLTH SUPPORT 92198 Prob-Est/Mentl Hlth Supt-Dev $6,706.70 Prob-EsVMentl Hlth Support - Total 479 PROB-FD JUDICIAL SUPPORT 95188 Prob-FD Judicial Sup $539.63 Prob-FD Judicial Sup - Total 481 PROBATE-FD JUDICIAL 95168 Prob-FD Judicial $2,251.32 Prob-FD Judicial - Total 145 PROSECUTOR 95622 Prosecutor/Executive $3,926.42 97001 Prosecutor Data Processing 1,239.81 $96,343.70 $7,383.05 $9,879.45 $6,706.70 $539.63 $2,251.32 Prosecutor - Total $5,166.23 690 PURCHASING 44026 Pur-System/Customer Support §2.844.46 Purchasing - Total $2,844.46 Prepared by: Linda Munk, Info Tech; 4/24/2001; 2 2nd qtr 2001 recep.xls Cust # GOVERNMENTAL FUNDS 637 RECORDS RETENTION 650 REIMBURSEMENT $95,726.36 $7,064.25 $7,064.25 $7,064.25 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - SECOND QUARTER, 2001 195 SHERIFF 95637 Records Retention $6,657.64 Records Retention - Total $6,657.64 95470 Reimbursement System $278.85 95542 Reimburse User Supt 990 62 Reimbursement - Total $1,269.47 97163 Sheriff $73,580,78 Sheriff - Total $73,580.78 445 SUPPORT SERVICES 44500 Support Services — $5,871.36 44500 Support Services-credit Rec Reten chg (6,657.64) Support Services - Total ($786.28) 600 TREASURER 44012 Tre-Data Warehousing $10,103.45 44061 Tre-Systern/Customer Support 10,512.00 44062 Tre-System Maintenance 18,473.75 95303 Del Tax System Maintenance 10,549,29 95561 User Support/Del Tax 46 087 87 Treasurer - Total 540 52/1 DISTRICT COURT - NOVI 95527 DC Suprt -25%-52/1 $7,064.25 52/1 District Court - Total 550 5212 DISTRICT COURT - CLARKSTON 95528 DC Suprt -25%-52/2 $7,064.25 52/2 District Court - Total • 560 52/3 DISTRICT COURT - ROCHESTER 95529 DC Suprt -25%-52/3 $7,064.25 52/3 District Court - Total 530 52/4 DISTRICT COURT - TROY 95530 DC Suprt -25%-52/4 $7,064,24 52/4 District Court - Total $7,064.24 Prepared by: Linda Munk, Info Tech; 4/24/2001, 3 2nd qtr 2001 recep.xls 25100 30001 30002 30003 25200 25400 91516 95456 65701 Community Corrections Grant $6,439.24 Community Corrections Grant - Total 66103 Community Dev User Support $139.42 Community & Home Imp - Total 34041 CTS-FOC Exp-Fam Coun $2,028.79 92195 CTS-FOC-Exp-Fam Couns-Dev 15 306.83 CTS-FOC Exp-Fam Coun - Total $17,335.62 92193 CTS-FOC Exp-CD Enforc-Dev $36.873.87 CTS-FOC Exp-CD Enforcement - Total $36,873.87 34044 CTS-FOC Exp-CS Enforc-image $450.83 92194 CTS-FOC-Exp-CS Enf-I 20 073.49 CTS-FOC Exp-Fam Coun - Total 38000 Health - Immunization - Total $450.86 38100 Health-Regional Immun Registry 2,423.27 Health - Immunization - Total $20,524.32 $2,874.13 $6,439.24 $139.42 14 433.48 $450.84 $6,417.00 $29,743.54 29,743.54 29,743.54 7,435.88 7,435.88 7,435.88 7435.87 Treasurer-100% Tax Pymt Fund $17,639.80 Treasurer-100% Tax Pymt Fund - Total $17,639.80 Water & Sewer Acctg $4,796.64 Water & Sewer Acctg - Total $4,796.64 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER, 2001 Gust # DIRECT FUNDS 657 COMMUNITY CORRECTIONS 661 COMMUNITY & HOME IMPROVEMENT 470 COURTS-F0C-EXP-FAM COUNSELING 507 COURTS-FOC EXP-CS ENFORCEMENT 471 COURTS-FOC-EXP-CS ENFORC-IMAGE 380 HEALTH IMMUNIZATION -GRANT 010 INFORMATION TECHNOLOGY Digital Information Service Center Systems Develop/Support Technical Sys/Networking 640 MATERIALS MANAGEMENT 870 MEDICAL CARE FACILITY 004 PA 189 J1MS PROJECT 770 PARKS AND RECREATION 695 RISK MANAGEMENT 602 TREASURER-100% TAX PAYMENT FUND 656 WATER & SEWER ACCTG GIS - Administration IT Disc Data Warehouse IT DISC Enhanced Access IT DISC GIS Open Systems Administration Oracle Administration CVT - New Development Equipment Inventory 95689 Database Tech Support Information Technology - Total 95440 Materials Management Materials Management - Total 98873 MCF - Support MCF - Support - Total 90603 JIMS Project - Circuit Court 25% 90604 JIMS Project - Probate - 25% 90605 JIMS Project - Prosecutor 25% 90606 J1MS Project - 52/1 DC 6.25% 90607 JIMS Project - 52/2 DC 6.25% 90608 JIMS Project - 52/3 DC 6.25% 90609 JIMS Project - 5214 DC 6.25% PA 189 JIMS Project - Total 95695 95310 95669 3,206.66 205,574.47 42,307.03 93 517.82 $344,605.98 1,324.49 298,252.72 135,221.51 112.71 434,911.43 $14,433.48 $450.84 $6,417.00 $118,974.13 $1,603.33 $334.00 95419 PRADM - Administration $1,603.33 Parks and Recreation - Total Risk Management $334.00 Risk Management - Total NON-COUNTY AGENCIES $35,888.91 Prepared by: Linda Munk, Info Tech; 4/24/2001; 4 2nd qtr 2001 recep.xls Resolution #01197 August 2, 2001 The Chairperson referred the resolution to the Finance Committee. There were no objections.