HomeMy WebLinkAboutResolutions - 2001.11.29 - 26557MISCELLANEOUS RESOLUTION #01298 November 8, 2001
BY: General Government Committee, William R. Patterson, Chairperson
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FOURTH 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 General Government Committee; and
WHEREAS the Department of Information Technology has determined the
Fourth Quarter 2001 data processing development charges to be $923,382
and the imaging development charge to be $55,677 for the General
Fund/General Purpose County departments; and
WHEREAS direct charges to Special Revenue and Proprietary fund
departments are $267,595 and non-county agencies is $2,320 for the Fourth
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 Fourth Quarter 2001 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.
GENERAL GOVERNMENT CO
5
MITTEE
6 7
GENERAL GOVERNMENT COMMITTEE
Motion carried unanimously on a roll call vote.
ACCOUNT #
INFORMATION TECHNOLOGY
, DATA PROCESSING DEVELOPMENT SUMMARY
4TH QUARTER 2001 '
1st Qtr 2nd Qtr 3rd Qtr 4th Qtr
DIVISION Oct - Dec Jan - Mar Apr - June July - Sept Y.T.D.
General Fund f1011
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-51-233000-53500-6030
2-1 6-91 2000-15000-6030
2-17-501200-50001-6030
2-15-402200-10001-6030
2-19-221000-10000-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-Judicial Administration
Equalization Division
Fiscal Services - Admin
Fiscal Services - General
Library - Admin
Medical Examiner
M.S.U. Extension - Oakland
Personnel
Planning & Economic Development
Probate-Estates/Mental Health Admin
Probate-Estates/Mental Health 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 7,296.94 12,653.14 38,731.06
11,716.73 7,064.25 7,296.94 12,653.14 38,731.06
11,716.73 7,064.25 7,296.94 12,653.14 38,731.06
11,716.73 7,064.24 7,296.89 12,653.13 38,730.99
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 23,951.91 0.00 113,881.82
6,836.70 7,596.89 8,789.94 8,310.94 31,534.47
30,835.97 11,268.56 2,890.28 13,983.45 58,978.26
3,813.56 12,345.82 7,079.45 3,741.89 26,980.72
1,640.54 3,853.30 348.55 1,548.43 7,390.82
1,090.86 872.71 1,029.43 0.00 2,993.00
1,596.00 0.00 0.00 0.00 1,596.00
44.52 845.33 208.37 0.00 1,098.22
8,999.08 7,934.37 3,378.43 3,961.41 24,273.29
1,472.70 4,071.85 2,802.73 1,337.70 9,684.98
36,327.35 16,686.55 21,009.86 11,544.48 85,568.24
9,663.86 6,034.90 2,469.05 3,384.60 21,552.41
14,586.00 16,284.00 8,423.81 19,156.94 58,450.75
18,747.00 0.00 0.00 0.00 18,747.00
1,340.90 8,854.17 3,964.15 557.68 14,716.90
1,380.28 672.07 958.04 1,352.52 4,362.91
143,817.20 198,066.20 206,863.53 203,705.19 752,452.12
182,377.26 200,016.94 252,254.33 184,051.88 818,700.41
46,130.77 47,976.73 92,620.34 43,917.35 230,645.19
278.84 0.00 278.84
47,864.46 12,938.78 17,384.86 11,845.29 90,033.39
997.37 0.00 364.84 0.00 1,362.21
89,411.95 96,343.70 180,281.42 84,123.77 450,160.84
139.42 0.00 139.42
2,486.26 7,383.05 2,960.68 2,960.68 15,790.67
7,605.62 6,706.70 0.00 0.00 14,312.32
4,490.10 2,251.32 4,035.58 4,035.58 14,812.58
522.07 539.63 3,615.82 3,615.82 8,293.34
18,524.83 5,166.23 7,378.12 5,530.33 36,599.51
534.30 2,844.46 2,666.59 5,773.60 11,818.95
0.00 6,657.64 0.00 0.00 6,657.64
11,860.00 1,269.47 8,900.25 12,237.67 34,267.39
77,540.02 73,580.78 71,114.71 74,515.03 296,750.54
30,719.05 (786.28) 2,930.47 3,906.41 36,769.65
68 454.57 95,726.36 94 576.99 48 715.41 307 473.33
979,122.27 919,333.64 1,064,858.50 808,426.60 3,771,741.01
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 (22,570.21) 3,381.31 3,832.15
1,429.27 12,127.61 1,386.35 7,021.82 21,965.05
22,223.40 12,655.73 2,280.63 0.00 37,159.76
65 203.27 54,621.76 56 933. 63 _i 99.639,44 276 398.10
88,855.94 102,426.15 38,030.40 110,042.57 339,355.06
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
Juvenile Maintenance Fund 12931
2-16-501200-25001-6030 Children's Village
Sub-Total Fund 293
9,216.71 6,311.79 7,507.27 4,912.55 27 948.32
9,216.71 6,311.79 7,507.27 4,912.55 27,948.32
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
DATA PROCESSING DEVELOPMENT FOR
GOVERNMENTAL FUND APPROPRIATION
Clerk Image
Courts-FD-Juv-Sup-Imaging
Courts-FOC Exp-CS Enforcement Image
Probate-Estates/Mental Health Image
TOTAL IMAGING DEVELOPMENT
APPROPRIATION
1,168,850.93 1,028,071.58 1,110,396.17 923 381 72 4,230,700.40
14,072.96 22,174.02 73,149.97 44,206.74 153,603.69
0.00 112.71 450.84 0.00 563.55
18,034.70 0.00 0.00 0.00 18,034.70
12 455.94 9,879.45 11,470.73 11 470.73 45 276.85
44 563.60 32,166.18 85 071.54 55 677.47 217,478.79
Information Technology Development
TOTAL GOVERNMENT:
Prepared by: Linda Munk, Info Tech: 9/24/2001:3:27 PM
(1,213,414.53) (1,060,237.76) (1,195,467.71) (979,059.19) (4,448,179.19)
$0.00 $0.00 $0.00 $0.00 0.00
4th qtr 2001.xls
90-290000-25000-6030
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
4TH QUARTER 2001
ACCOUNT #
1st Qtr 2nd Qtr 3rd Qtr 4th Qtr
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
Oakland County International Airport
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 6,052.32 955.10 23,937.64
54.95 139.42 1,041.10 0.00 1,235.47
0.00 36,873.87 17,761.87 2,379.41 57,015.15
0.00 20,524.32 74,894.57 55,050.51 150,469.40
0.00 17,335.62 70,414.61 34,635.89 122,386.12
89.05 0.00 278.84 139.42 507.31
6,937.08 2,874.13 958.07 924.27 11,693.55
0.00 450.84 1,153.81 2,785.17 4,389.82
16,127.36 6,417.00 4,184.08 2,303.19 29,031:63
139.42 0.00 139.42
163,173.89 118,974.13 129,525.26 148,102.25 559,775.53
5,759.86 1,603.33 2,997.53 1,673.04 12,033.76
0.00 334.00 0.00 1,118.30 1,452.30
25,606.56 17,639.80 35,704.20 16,825.84 95,776.40
6,100.01 4,796.64 278.84 702.97 11 878.46
$234,339.74 $234,402.34 $345,384.52 $267,595.36 1,081,721.96
TOTAL DEVELOPMENT CHARGES $1,447,754.27 $1,294,640.10 $1,540,852.23 $1,246,654.55 5,529,901.15
18-636111-10000-0429 Non-County Agencies 42 273.02 35,888.91 30 987.48 2,320.00 111,469.41
TOTAL NON-COUNTY AGENCIES 42 273, 02 _, 35,888.91 30. 987 48 _......._ 2,320.00 111,469.41
(Information Purposes Only) Information Technology 737,902.01 793,950.89 1,006,430.27 828,382.91 3,366,666.08
Prepared by: Linda Munk, Info Tech; 9/2812001; 10:09 AM 4th qtr 2001.xls
$4,912.55
$3,381.31
722 CLERK - IMAGING
410 CLERK - JURY COMMISSION
724 CLERK - LEGAL RECORDS
723 CLERK - VITAL STATISTICS
492 CTS-FD-CT SERV-ADOPTIONS
483 CTS-FD-JUDICIAL SUPPORT-ADM
499 CTS-GJ-ASSIGNMENT
420 CTS - GJ - FAMILY SUPPORT
498 CTS-GEN JURIS-JUDICIAL SUPPT
500 CTS-GJ-MEDIATION
493 CTS-JUDICIAL ADMIN
740 EQUALIZATION
660 FISCAL SERVICES ADMIN
670 FISCAL SERVICES - GENERAL
840 HEALTH DEPARTMENT
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2001
Cust # GOVERNMENTAL FUNDS
665 CHILDRENS VILLAGE 95665 Childrens Village $4,912.55
Childrens Village - Total
900 CLEMIS - EMS 95479 CLEMIS-EMS Cust Suppt $3,381.31
CLEMIS-EMS - Total
720 CLERK / REGISTER OF DEEDS 95493 Reg Deeds System Maintenance $1,747.01
95558 User Support/ROD 1,994.88
Clerk/Reg of Deeds - Total $3,741.89
65420 Clerk - Image Replace - 21% $2,927.53
95158 Clerk - Imaging 41,279.21
Clerk - Imaging - Total $44,206.74
95512 Jury Commission $8,310.94
Clerk -Jury Commission - Total $8,310.94
95189 Circuit Court System $13,983.45
Clerk - Legal Records - Total $13,983.45
95161 Vital Stats Index $1,548.43
Clerk - Vital Statistics - Total $1,548.43
95173 CTS-FD-Ct Serv-Adoptions $3,961.41
CTS-FD-Ct Serv-Adoptions - Total $3,961.41
95193 CTS-FD-Judicial Suport-Adm $1,337.70
CTS-FD-Judicial Suport-Adm - Total $1,337.70
95180 CTS-GJ-Assignment $3,384.60
CTS-GJ-Assignment - Total $3,384.60
95195 Cir Crt Admin 19,156.94
Courts - GJ - Family Support - Total $19,156.94
95179 CTS -Gen Juris-Judicial Suppt $11,544.48
CTS -Gen Juris-Judicial Suppt - Total $11,544.48
95181 CTS-GJ-Mediation $557.68
CTS-GJ-Mediation - Total $557.68
95174 CTS-Judicial Admin $1,352.52
CTS-Judicial Admin - Total $1,352.52
31075 Equal - Development $732.62
310778 EPP-Development $76,895.01
95559 User Support/Equal 30,254.14
95693 Equal-System Maintenance 95,823.42
Equalization - Total $203,705.19
44021 FS-System/Customer Support $35,211.66
44022 FS-System Maintenance 41,819.29
44023 FS-System Enhancements 23,036.60
96001 Human Res - Acctg 83 984.33
Fiscal Services Admin - Total
44077 BUD-System Maintenance $1,925.17
96003 Human Resources - Budget 41,992.18
Fiscal Services - General - Total
37025 CHAMPS - P.O.P. $5,534.07
96842 Health - Admin 1,487.75
Health - Total
$184,051.88
$43,917.35
$7,021.82
Prepared by: Linda Munk, Info Tech; 9/24/2001;
1 4th qtr 2001.xls
$11,845.29
$11,845.29
$139.42
83,984.35
$84,123.77
$2,960.68
$11,470.73
$3,615.82
$4,035.58
$2,960.68
$11,470.73
$3,615.82
$4,035.58
$5,304.91
225.42
$5,530.33
$2,871.17
1,577.94
1.324.49
$5,773.60
$1,174.66
11,063.01
$12,237.67
$74,515.03
$74,515.03
$3,906.41
$3,906.41
$7,095.83
1,882.17
112.71
9,261.50
30,363.20
$12,653.14
$12,653.14
$12,653.14
$12,653.13
$48,715.41
$12,653.14
$12,653.14
$12,653.14
$12,653.13
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2001
Gust # GOVERNMENTAL FUNDS
843 HEALTH - ENVIRONMENTAL 37002 Environmental
84200 EH - Projects
84300 Ehealth Program
Health-Environmental - Total
$1,070.78
28,705.06
69,863.60
$99,639.44
872 MEDICAL EXAMINER
680 PERSONNEL
512 PROB-ESTATES/MENTL HLTH IMAGE
479 PROB-FD JUDICIAL SUPPORT
481 PROBATE-FD JUDICIAL
145 PROSECUTOR
690 PURCHASING
650 REIMBURSEMENT
195 SHERIFF
445 SUPPORT SERVICES
600 TREASURER
540 52/1 DISTRICT COURT - NOVI
550 5212 DISTRICT COURT - CLARKSTON
560 52/3 DISTRICT COURT - ROCHESTER
530 52/4 DISTRICT COURT - TROY
87202 Med Exam - Cust Support
Medical Examiner - Total
95556 Personnel User Supt
96002 Human Res. - Personnel
Personnel - Total
Prob-Est/Ment Hlth-Admin
Prob-Est/Ment Hlth-Admin - Total
95207 Prob-Est/Mntl Hlth Image
Prob-Est/Mntl Hlth Image - Total
95188 Prob-FD Judicial Sup
Prob-FD Judicial Sup - Total
95168 Prob-FD Judicial
Prob-FD Judicial - Total
95622 Prosecutor/Executive
97001 Prosecutor Data Proc
Prosecutor - Total
44026 PUR-System/Customer Support
44027 PUR-System Maintenance
44029 PUR-New Development
Purchasing - Total
95470 Reimbursement System
95542 Reimburse User Support
Reimbursement - Total
97163 Sheriff
Sheriff - Total
44500 Support Services
Support Services - Total
Tre-Data Warehousing
Ire-System/Customer Support
Tre-System Maintenance
Del Tax System Maintenance
User Support/Del Tax
Treasurer - Total
95527 DC Suprt -25%-52/1
52/1 District Court - Total
95528 DC Suprt -25%-52/2
52/2 District Court - Total
95529 DC Suprt -25%-52/3
52/3 District Court - Total
95530 DC Suprt -25%-52/4
52/4 District Court - Total
480 PROB-ESTATES/MENTL HLTH-ADMIN 95200
44012
44061
44062
95303
95561
Prepared by: Linda Munk, Info Tech; 9/24/2001:
2 4th qtr 2001.xls
65701 Community Corrections Grant
Community Corrections - Total
34041 CTS-FOC Exp-Fam Counseling
92195 CTS-FOC Exp-Fam Couns-Dev
CTS-FOC Exp-Fam Couns-Dev - Total
92193 CTS-FOC Exp-CD Enforc-Dev
CTS-FOC Exp-CD Enforc-Dev - Total
38000 Health - Immunization
Health - Immunization - Total
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
95440 Materials Management
Materials Management - Total
98873 MCF - Support
MCF - Support - Total
90603 PA189 JIMS Circ Ct - 25%
90604 PA189 JIMS Probate - 25%
90605 PA189 JIMS Prosecutor - 25%
90606 PA189 JIMS 52/1 DC - .0625%
90607 PA189 JIMS 52/2 DC - .0625%
90608 PA189 JIMS 52/3 DC - .0625%
90609 PA189 JIMS 52/4 DC - .0625%
PA189 Projects - Total
95419 PRADM-Administration
Parks & Recreation - Total
95695 Risk Management
Risk Management - Total
92194
75503 FM0 Development
FM&O - Total
CTS-FOC-Exp-CS Enf-I
CTS-FOC Exp-Fam Coun - Total
30001
30002
30003
25200
25400
91516
95456
$955.10
$20,433.40
14,202.49
$2,379.41
$55,050.51
$139.42
$924.27
$249,667.62
39,285.62
73,825.29
$4,949.41
355,100.97
61,798.19
$43,755.81
$2,785.17
$2,303.19
37,025.56
37,025.56
37,025.56
9,256.39
9,256.39
9,256.39
9.256.40
$1,673.04
$1,118.30
$16,825.84
$139.42
563.55
$702.97
$955.10
$34,635.89
$2,379.41
$55,050.51
$139.42
$924.27
$362,778.53
$421,848.57
$43,755.81
$2,785.17
$2,303.19
$148,102.25
$1,673.04
$1,118.30
$16,825.84
• INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2001
Cust # DIRECT FUNDS
521 COMM CORR-ADM (GRANT).
470 CTS-FOC EXP-FAM COUNSELING
507 CTS-FOC EXP-CS ENFORCEMENT
471 CTS-FOC-EXP-CS ENFORC-IMAGE
750 FAC MAINT & OPERATIONS
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 PA189 PROJECTS
770 PARKS AND RECREATION
695 RISK MANAGEMENT
44049 WS-New Development
95669 Water & Sewer Acct'g
Water & Sewer Acct'g - Total
602 TREASURER-100% TAX PAYMENT FUND 95310 Del Tax Act 123 Project
Treasurer 100% Tax Pymt Fund - Total
656 WATER & SEWER ACCTG
NON-COUNTY AGENCIES
$2,320.00
Prepared by: Linda Munk, Info Tech: 9/28/2001;
3 4th qtr 2001.xls
Resolution #01298 November 8, 2001
The Chairperson referred the resolution to the Finance Committee. There
were no objections.
29, 2001
QUARTER 2001
Committee has
e Information
to benefiting
FISCAL NOTE (M.R. #01298) November
BY: FINANCE COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY — FOURTH
DEVELOPMENT APPROPRIATION TRANSFER
To the Oakland County Board of Commissioners
Chairperson, Ladies and Gentlemen:
Pursuant to Rule XII-C of this Board, the Finance
reviewed the above-reference resolution and finds:
1. The resolution appropriates and charges th
Technology Fourth Quarter 2001 Development cost
departments.
2. The fourth quarter data processing development charges are
$923,382; imaging development charges are $55,677 for General
Fund/General Purpose departments; direct charges to Special
Revenue and Proprietary fund departments are $267,595; and
charges to non-county agencies are $2,320.
3. The respective departmental Fiscal Year 2001 budgets are to be
amended as specified in the attached detail schedule.
Chairperson, on behalf of the Finance Committee, I move the adoption
of the foregoing resolution.
FINAACE COMMITTEE
(2-L„
FINANCE COMMITTEE
Motion carried unanimously on a roll call vote.
William Caddell, County Clerk
Resolution #01298 November 29, 2001
Moved by Dingeldey supported by Palmer the resolutions on the Consent
Agenda be adopted.
AYES: Brian, Buckley, Causey-Mitchell, Coleman, Crawford, Dingeldey,
Douglas, Galloway, Garfield, Gregory, Law, McPherson, Moffitt, Obrecht, Palmer,
Patterson, Sever, Suarez, Taub, Webster, Appel. (21)
NAYS: None. (0)
A sufficient majority having voted therefore, the resolutions on the
Consent Agenda were adopted.
6.. t.)100kb
) FoREcioNn r7nro
sm CowAyExecutive Date
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 November 29, 2001 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 29th day,00f November, 2001.