HomeMy WebLinkAboutResolutions - 1998.12.10 - 25334STRATEGIC PLANNING COMMITTEE
DECEMBER 10) 1998
MISCELLANEOUS RESOLUTION *98326
BY: STRATEGIC PLANNING COMMITTEE, RUTH JOHNSON, VICE-CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY -FOURTH QUARTER 1998 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 Strategic Planning Committee; and
WHEREAS the Department of Information Technology has determined the
Fourth Quarter 1998 data processing development charges to be $1,006,846 and
the imaging development charge to be $25,508 for the governmental fund County
departments; and
WHEREAS direct charges to non-governmental fund departments are $61,693
and non-county agencies are $16,107 for the Fourth Quarter 1998; 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 Fourth Quarter 1998 Data Processing Development
and approves the fourth quarter appropriation transfer.
Chairperson, on behalf of the Strategic Planning Committee, I move the
adoption of the foregoing resolution.
STRATEGIC PLANNING COMMITTEE VOTE:
MOTION CARRIED UNANIMOUSLY ON A ROLL CALL VOTE WITH JOHNSON
AND JENSEN ABSENT.
FISCAL NOTE (Misc. #98326) December 10, 1998
BY: FINANCE COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FOURTH QUARTER 1998 DEVELOPMENT
APPROPRIATION TRANSFER
TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS
Chairperson, Ladies and Gentlemen:
Pursuant to Rule XII-F of this Board, the Finance Committee has reviewed
the above referenced resolution and finds:
1. Information Technology has completed fourth quarter Data Processing
Development for General Fund/General Purpose operations and request
an appropriation transfer to the user departments.
2. The transfer has been reviewed by the Strategic Planning Committee.
3. The FY 1998 budget should be amended, per the attached document
entitled Information Technology Data Processing Development Summary.
4. FY 1998 Fourth Quarter Development for the 100% Tax Payment Fund
equals $39,998. This amount reflects a direct charge against
Information Technology Professional Services line-item which was not
budgeted. The following budget amendment is required to restore the
line-item:
•
Information Technology Fund
Revenue
18-636111-10000-0715 Non-Gov't Development
Expense
18-636122-15000-3348 Professional Services
$39.998
$39.998
$ _0
FINANCE COMMITTEE
FINANCE COMMITTEE VOTE:
Motion carried unanimously on a roll call vote.
ACCOUNT 0
Cutrigral Fund (1On
101 2-32-201200-20001-8030
101 2-32-301200-200014030
101 2-32-401200-200014030
101 2-32-501200-20001-6030
101 2-11 -2201004 00004030
101 2-51-211000-10000-6030
101 2-31-101200-10031-6030
101 2-21-230100-01000-6030
101 2-21-250100-01000-6030
101 2-21-221000-01000-8030
101 2-21-240100-01000-6030
101 2-21-220500-010004030
101 2-19-210000-1000043030
101 2-11-250100-20000-8030
101 2-11-210100.0100043030
101 2-19-221000-10000-8030
101 2-61-211001-10000-6030
101 2-19-240000-400164030
101 2-12-601200-10001-6030
101 2-12-821200-82328-8030
101 2-18-912000-150004030
101 2-17-502200-550004030
101 2-15-402200-10001-6030
101 2-34-401200-40001-6030
101 2-34-101200-400014030
101 2-41-211000-10000-8030
101 2-12-401200-40010-8030
101 2-13-138203-00010-6030
101 2-12-701200-70130-6030
101 2-51-233000-53500-8030
101 2-43-023310-20021-8030
101 2-13-138210400104030
101 2-22-2211.20-01000-6030
101 2-17-302200-21000-8030
Friend of the Court Fund L21;
215 2-12-705212-705354030
215 2-31-201200-10004-8030
215 2-31-201200.10004-6030
Health Fund (2211
221 2-17-802200-21000-6030
221 2-16-201200.10000-6030
221 2-16-22020045000-8030
06/1SION
52/1 District Court
52/2 District Court
52/3 District Court
52/4 District Court
Auditing
Board of Commissioners - Mm.
Circuit Court - Administration
Clerk - Elections
Clerk - Jury Commission
Clerk - Legal Records
Clerk • Register of Deeds
Clerk - Vital Stalistica
Community & Economic Development
Corporation Counsel
County Executive
Development 6 Planning Division
Drain Commissioner
Equalization Division
Fiscal Services - Admin
Fiscal Services - General
Medical Examiner
M.S.U. Extension - Gypsy Moth Program
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
FOC/Child Support/Reimbursement
Friend of the Court
Friend of the Court * (Outside Contractor)
Sub-Total Fund 215
Animal Control
Health - CHAMPS
Health Environmental
Sub-Total Fund 221
luitnilis/10113 31:1
293 2-18-501200-10000-6030
L2231
Children's Village
Sub-Total Fund 293
18-636111-10000-0735
2-21-221000-01000-6039
2-31-201200-10004-6039
2-34-101200-40001-6039
18-836111-10000-0573
DATA PROCESSING DEVELOPMENT FOR
GOVERNMENTAL FUND APPROPRIATION
Clerk
Friend of the Court
Probate
TOTAL IMAGING DEVELOPMENT
APPROPRIATION
2-16401112-10000-6030
2-18401112-10000-8039
Information Technology
Imaging Development
TOTAL GOVERNMENT:
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
4Th QUARTER 1998
lit Ott 2nd Ott 3rd Qtr 4th fatr T.1.13.
act_tatc 'MILAN Apr.z...lana 'UAL
685.88 105.75 8.007.65 8,033.50 18,832.78
885.88 105.75 8.007.65 8,033.50 16,832.78
885.88 105.75 8,007.65 8,033.50 10,832.78
885.86 105.75 8,007,61 8.033.50 16,83212
115.50 94.00 811.00 820.50
46.50 46.50
44.152.00 34,060.00 49,551.01 17,15225 144,015.26
390.50 8,155.50 9.639.75 34,178.00 52,363.75
8.045.50 1,872.50 12,703.50 1,580.00 22,001.50
8.244.70 11,358.25 19,602.95
4,561.00 5,192.00 1,627,00 1.389.00 12,789.00
9,165.50 761.00 9.926,50
437.10 437.10
378.00 470.00 846.00
213.90 213.90
46.50 46.50
325.50 141.00 488.50
370,221.90 549.706.90 486,403.06 209,068.34 1,615,400.20
49.302.10 21245.88 141,929.79 112,901,80 325,379.57
14,861,80 5,817.44 60.2ee.35 43.150.65 123,898.24
16,898.00 1,324.00 10,979.80 13,307.00 42,508,80
8,183.60 8.183.60
30,034.80 12,362.88 126,408.79 81,490.30 250.298.57
21,779.00 5,742.50 12,258.70 20,692.75 60,472.95
924.00 24,850.50 6,135.50 11,819.50 43,529.50
2,282.00 1,673.20 8,502.70 7,496.25 17,968.15
811.00 2,914.00 3.525.00
38.50 38.50
26,422.00 2.303.00 1312.00 5.959.25 35,496.25
74.40 329.00 329.00 732,40
39,656.00 31,350.70 87,259.85 38,650.85 176,917.20
282.00 470.00 752.00
14,455.50 29,124.00 1,32.07.4.00 75A14..50 251,788.00
32.513 CLOD 32i50
646,352.80 734,933.00 1,178,425.36 729,254.29 3,288,985.45
142.00 2,920.00 3,062.00
35.675.70 31143,30 78.517.56 115.137.25 286,073.81
121.231.1X/ 131 936(11)
35,675.70 36,885.30 81,437.56 247,073.25 401,071,81
$1,891.50 $556.00 $346.50 $847.00 3,841.00
9,207.50 15,827.00 32,402.50 28,829.50 86,286.50
2.X0.54 154494 0.16.1X1 1,12.54 voism
13,447,50 21,927.00 33,365.00 29.869,00 98,808.50
1.455.50 218.54 1.114.111 549..54 4.064.21
1,455.50 248.50 1114.50 648.50 4,068.00
096,131.50 793.993.64 1197.942A2 199li541.0±1 3,71911325
46.50 94.00 1,788.74 6,174,14 8,081.38
2.111.14 47..00 5,915.84 15,176.66 26,250,40
371.02 1.12312 1.532.52
2.157.60 141.42 11.011127 25.507.59 35.184.37
(698,931 50) (793,993.844 (1,292,942.42) (1,006,844.04) (3,790,713.78)
(2 157 60) (141.00) (WWI 711 (25.507.60) (35.664.37)
$Q9 06 MUM ULM (SOW
• Previously charged to Professional Services 1 st, 2nd & 3rd quarters
1 4FY9IIDEVANK4 Prepared by: Linda Swartz, Info Tech: 10/26198; 09:21 AM
•
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
4TH QUARTER 1998
let Qtr 2nd Qtr 3rd QM 4th Otr Y.T.D.
ACCOUNT I DNISION Ott_l_ORG JARASAE Aar.Amoa .1918_-_SmM TOTAL
Con unify Corrections $1.371.00 $47.00 1,418.00
Community Development Grunt 48.50 47.00 93,50
Community Mental Health - Adrnin 17.087,50 7,977.50 12,228.00 6,977.00 44,270,00
Facilities Maintenance & Operations 288.30 122.20 376,00 04.00 880.50
FOC - Medical Support 12.862.50 4.802.50 17.725.00
Garage 1,501.50 308.00 2,030.00 3,839,50
Health Immunization 816.00 654.50 2,502.50 1.078.00 4,851.00
In-Car Terminals 1,304.00 (1,504.00) 0.00
Materials Management 611.00 2.867.00 3,478.00
Medical Care Facility 1,395.00 3,252.50 3,105.00 4,485.00 12,217.50
Oakland County international Airport 46.50 46.50
Parks and Recreation - Admintstration 208.50 38.50 278.00 525.00
Risk Management 47.00 47.00
Water 8, Sewer Accounting 154.00 2.000.50 500.00 2,744,50
100% Tax Payment Fund 1.39.15130 22.414.10 MMUS 38.928.110 307-221.09
18-636111-10000-0715 DIRECT CHARGES FOR DATA 115.1.122.10 MAIM $91.322.1111 MEWS MUSLIM
PROCESSING DEVELOPMENT
TOTAL DEVELOPMENT CHARGES $60.952-40 5678.I21-42 5I.392-30035 11,924.048.94 84.225.I35.22
18-636111-10000-0429 &dwell 14,798 50 24,405.00 27..71 15,790.50 82263.71
18-638111-10000-0759 Indic Improvement Association 77.00 318.14 393,50
18-638111-10000-0759 Federal District Court 5135.00 0.00 585.00
TOTAL NON-COUNTY AGENCIES 15,383.50 24.482.0 Z421911 18.197.011 8124211
(lnformation Purposes Only) Information Technology 243,791.70 192,893.40 434,123.17 484,680.75 1,335,498.02
2 4FY980EVWX4 Plowed by: Untis Swift Info Tech; 1W26198; 09:21 AM
95682 Dog System
Animal Control - Total
44032 Aud-System Maintenance
Auditing - Total
95665 Chiklrens Village
Childrens Village - Total
Circ Ct JIMS Project - 20%
Cir Court Admin
Assignment Clerk
Circuit Court - Total
95493 Reg Deeds System Maintenance
95558 User Support/ROD
Clerk/Reg of Deeds - Total
95443 Elections
Elections - Total
Clerk - Image Replace - 21%
Clerk - Imaging
Clerk - Imaging - Total
95512 Jury Commission
Jury Commission - Total
90602 Clerk - JIMS Project - 20%
95189 Circuit Court System
Clerk - Legal Records - Total
95161 Vital Stats Index
Clerk - Vital Statistics - Total
95501 Corporation Counsel
Corporation Counsel - Total
71100 Gypsy Moth Program
MSU Extension - Gypsy Moth - Total:
90603
95195
95452
65420
95158
31075
31077
95559
95893
95898
44001
44002
95554
96702
96001
1847-212
$447.00
1811-011
1411.00
PM=
$849,50
$2,515.75
7,987.00
8.11411.14
;17,152.25
$308.00
1,911.99
$1,389.00
S34.178.00
$34,178.00
$4,858.14
1.316.00
$8,174.14
$1.580.00
$1,580.00
$2,515.75
8.842.50
$761.00
$470.00
$6.183.60
$11,358.25
$761.00
$470.00
$6,183.60
$14,554.00
81,039.00
91,287.34
16,031.00
6.157.0Q
$209,068.34
$14,837.50
4,995.00
9,2/2.00
2.867.00
80.990.30
$112,901.80
$94.00
2,867.00
40.189.65
$43,150.85
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 1998
casti GOVERNMENTAL FUNDS
630 ANIMAL CONTROL
620 AUIXIING
665 CHLDRENS VILLAGE
420 CIRCUIT COURT
720 CLERK LREGISTER OF DEEDS
440 CLERK ELECTIONS
722 CLERK- IMAGING
410 CLERK- JURY COMMISSION
724 CLERK - LEGAL RECORDS
723 CLERK- VITAL STATISTICS
430 CORPORATION COUNSEL
711 M.S.U. EXTENSION - GYPSY MOTH
740 EQUALIZATION
seo FISCAL SERMICEIADMIN
670 EISCALIERYICEL-SANEBAI.
Equal - Development
EAC - C/I Upgrade
User Support/Equal
Equal-System Maintenance
Compuware Req Study
Equalization - Total
Oakland Co. Payroll
FIMIS Accounting
Accounting User Support
Fisc Serv - PSMS - 25%
Human Services - Accrg
Fiscal Services Admin - Total
44075 BUD-Customer/Issue Management
95703 Budget - PSMS - 25%
96003 Human Resources. Budget
Fiscal Services - General - Total
Prepared by: Linda Swartz, Info Tech; 10/28198; 09:33 AM 1 4FY98DEV,WK4
470 FRIEND OF THE COURT
471 FRIEND OF THE CT IMAGING
840 HEALTH DEPARTMENT
843 HEALTH - ENVIRONMENTAL
872 MEDICAL F.XAMINER
880 PERSONNEL
$109,264.25
5,873.00
8247,073.25
81,057.50
17.119.15
521.829.10
8192.50
$.13-197.21
$18,175.88
$28,829.50
$192.50
$13.307.00
$94,00
329.00
888.00
80.37930
$81,490.30
$2,515.75
378.00
17,031.00
IMOD
51.15070
$11.819.50
$20,692.75
$1.158.70
811.819.50
$2,515,75
4.982.50
87,498.25
847.00
$2,914.00
$846.00
5.113.25
$5,959.25
$5,597.50
33_053.35
$38,850.85
$470.00
$470.00
$1,457.00
6,298.00
1,128.00
30,132.00
15,420,50
21,079.00
$75,514.50
$628.94
7404.56
$8,033.50
$028.94
Z4.124.111
88,033.50
$628.94
74.04.58
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - FOURTH QUARTER, ME
34041 Friend of the Court
34848 FCC • Professional ServICes
34046 FOC - Professional Services (31d Ott rtf)
Friend of the Court - Total
34042 FOC Develop Image
65419 FCC-Image Replace-74%
FOC Develop Image - Total
37025 CHAMPS - P.O.P.
Health - Total
37002 Environmental
Health-Environmental - Total
87202 Med Exam - Cust Support
Medical Examiner - Total
Per-System Maintenance
Personnel User Supt
Personnel - Employee
Human Res. - Personnel
Personnel - Total
44042
95556
95560
98002
480 PROBATE COURT
482 PROBATE - IMAGING
481 PROBATE - JUVENILE
145 ER.Q.S.E.M.OR
690 PURCHASING
650 REIMBURSEMENT
195 SHERIFF
445 SUPPORT SERVICES
Goo TREASURER
540 5211 DISTRICT COURT NOVI
550 5212 DISTRICT COURT- CLARKSTON
sea 5211DIBTRICMCDURT_RDCHEATER.
90604 Probate - JIMS Project - 20%
95200 Probate - Admin
95202 Probate - Estates
95203 Probate - Field Services
Probate - Total
48200 Probate-Imaging
Probate - Imaging - Total
95191 Probate Crt Juv Div
Probate Juvenile - Total
90805 Prosecutor-JIMS Project-20%
95622 Prosecutor/Executive
Prosecutor - Total
95663 Purchasing
95701 Purch - PSMS - 25%
Purchasing - Total
95469 Reimbursement Div
95470 Reimbursement System
Reimbursement - Total
Jail Management System
Sheriff
Sheriff - Total
44500 Support Services User Support
Support Services - Total
44060 Tre-Customer/Issue Management
44061 Tre-System/Customer Support
44062 Tre-System Maintenance
95303 Del Tax System Maintenance
95313 DTX - Enhance/Development
95561 User Support/Del Tax
Treasurer - Total
90806 52/1 • JIMS Project - 5%
95527 DC Sued -25%-52/1
5211 District Court - Total
90607 52/2 - JIMS Project - 5%
95528 DC Suprt -25%-52/2
5212 District Court - Total
90608 52/3 - JIMS Project -5%
95529 DC Suprt •25%-52/3
95476
97163
prepored by: Linda Swartz, Info Tech; 10128/98:09:33 AM 2 4FY98DEV.VVK4
•
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 1998
52/3 District Court- Total $505350
530 6214 DISTRICT COURT - TROY 90609 52/4 - JIMS Project - 5% $628.93
95530 DC Suprt -25%-52/4 7404.57
52/4 District Court - Total $803350
Cust I DIRECT FUNDS
0715 683 Crini:ADMIN 58308 CMH System Development SEM.S14
CMH Admin - Total $6,977.00
0715 750 MC MAINT 8 OPERATIONS 75503 FM0 Development 494.951
FM&O - Total $94.00
0715 473 FOC - MEDICAL SUPPORT 47300 FOC-Medical Support Grant 14.-51250
FOG-Medical Support Grant - Total $4,882.50
0715 655 GARAGE 55498 Garage Support SZEINSII
Garage - Total $2,030.00
0715 380 HEALTH IMMUNIZATION - GRANT 38000 Health - Immunization
Health - Immunization - Total $1,076.00
0715 057 IN-CAR IERMINALS 95428 MDT Network Support LS1.504.001
In-Car Terminals - Total ($1,504.00)
010 INFORMATION TECHNOLOGY
Systems Dmmlop/Support 02000 Year 2000 Project 404,811.25
25200 Open Systems Administration 4,780.00
25400 Oracle Administration 35,089.00
31008 Dev Billed to Private Sector 329.00
84200 Health Grant Overhead 4,508.00
91505 System Support - Law Enforcement 1,504.00
91512 System Support - Health Plus 816.00
95402 MIT Maintenance 289.50
95458 Equipment Inventory 2,073.00
95472 FDC Wheel County Development 9122.1112
$454,888.75
Technical Sys/Networking 95889 Database Tech Support $9.821.00
$9,821.00
0715 840 MATERIALS MANAGEMENT 95704 Mat Mgmt - PSMS - 25% $2,887.00
Materials Management - Total $2.887.00
0715 870 MEDICAL CARE FACILITY 98873 MCF - Support $A,4.05M
MCF - Support - Total $4,465.00
0715 770 PARKS AND RECREATION 95415 PRTS - Tech Support $154.00
95418 PRAO-Addison Oaks 77.00
95419 PRADM-Administration 42.00
Parks & Recreation - Total 278.00
0715 895 RISK MANAGEMENT 95895 Risk Management $ALA
Risk Management - Total $47.00
0715 eSe WATER... SEWER ACCTO 95889 Water & Sewer Acct'g $500.00
Water & Sewer Acct'g - Total $500.00
0715 602 100% 'TAX PAYMENT FUND 95310 Delinquent Tax Oracle Fund $39_998.00
100% Tax Payment Fund - Total $39,908.00
NON-COUNTY AGENCIES $18,107.00
Federal District Court
Sidwell 15,790.50
T.I.A. 318,50
3 4FY98DEVW1(4 Prepanftl by: Undo Swartz, Info Tech; 10/26/98; 09:33 AM
Resolution #98326 December 10, 1998
Moved by Wolf supported by Taub the resolutjohs on the Consent Agenda be
adopted and the resolutions on the Consent Agenda being amended to conform with
their committee reports be adopted as amended.
AYES: Coleman, Dingeldey, Douglas, Garfield, Gregory, Hoffman, Holbert,
Huntoon, Jacobs, Jensen, Johnson, Kaczmar, Kingzett, Taw, McCulloch, McPherson,
Millard, Moffitt, Obrecht, Palmer, Taub, Wolf, Amos. (23;
NAYS: None. (0)
A sufficient majority having voted therefor, the resolutions on the Consent
Agenda were adopted and the resolutions on the Consent Agenda being amended to
conform with their committee reports were adopted as amended.
HEREEMPORakft-11% FOREGOING RESOLUTION
EBrooks PatiAZ;—n, County Executive Dett
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 Hoard of Commissioners on December 10, 1998 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
" diell401,
County of Oakland at Pontiac, Michigan thp I Oth day o4,December, 1998.
G. William Caddell, County Clerk