HomeMy WebLinkAboutResolutions - 1998.03.18 - 25397WO,
March 5, 1998
MISCELLANEOUS RESOLUTION #98035
BY: STRATEGIC PLANNING COMMITTEE, DENNIS POWERS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FIRST 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
First Quarter 1998 data processing development charges to be $698,327 and the
imaging development charge to be $2,158 for the governmental fund County
departments; and
WHEREAS direct charges to non-governmental fund departments are $160,478
and non-county agencies are $15,384 for the First 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 First Quarter 1998 Data Processing Development
and approves the first quarter appropriation transfer.
Chairperson, on behalf of the Strategic Planning Committee, I move the
adoption of the foregoing resolution.
191-C7 .A,1nPnA.0 IV 6)0444 NAANN.A.4 6;4.4414
S TEGIC PLANNING COMMITTEE
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
1ST QUARTER 1998
ACCOUNT #
2-17-802200-21000-6030
2-11-220100-10000-6030
2-51-211000-10000-6030
2-16-501200-10000-6030
2-31-101200-10001-6030
2-21-240100-01000-6030
2-21-230100-01000-6030
2-21-250100-01000-6030
2-19-210000-10000-6030
2-11-210100-01000-6030
2-19-221000-10000-6030
2-61-211001-10000-6030
2-19-240000-40016-6030
2-12-601200-10001-6030
2-12-621200-62326-6030
2-31-201200-10004-6030
2-16-201200-10000-6030
2-16-220200-65000-6030
2-16-301200-10000-6030
2-16-912000-15000-6030
2-15-402200-10001-6030
2-34-401200-40001-6030
2-34-101200-40001-6030
2-41-211000-10000-6030
2-13-138203-00010-6030
2-12-701200-70130-6030
2-51-233000-53500-6030
2-43-023310-20021-6030
2-22-221120-01000-6030
2-17-302200-21000-6030
2-32-201200-20001-6030
2-32-301200-20001-6030
2-32-401200-20001-6030
2-32-501200-20001-6030
18-636111-10000-0735
2-31-205200-1004-3348
2-21-221000-01000-6039
2-31-201200-10004-6039
18-636111-10000-0573
2-18-636112-10000-6030
2-18-636112-10000-6039
DIVISION
Animal Control
Auditing
Board of Commissioners - Mm.
Children's Village
Circuit Court - Administration
Clerk Register of Deeds
Clerk - Elections
Clerk - Jury Commission
Community & Economic Development
County Executive
Development & Planning Division
Drain Commissioner
Equalization Division
Fiscal Services - Admin
Fiscal Services - General
Friend of the Court
Health - CHAMPS
Health Environmental
Medical Care Facility
Medical Examiner
Personnel
Probate Court - Estates & Mental Health
Probate Court - Juvenile
Prosecuting Attorney
Records Retention
Reimbursement Division
Research Library
Sheriff
Treasurer
Veteran's Services
5211 District Court
52/2 District Court
5213 District Court
52/4 District Court
DATA PROCESSING DEVELOPMENT FOR
GOVERNMENTAL FUND APPROPRIATION
FOC - Professional Services
Clerk
Friend of the Court
TOTAL IMAGING DEVELOPMENT
APPROPRIATION
Information Technology
Imaging Development
TOTAL GOVERNMENT:
1st Qtr Y.T.D.
Oct. Dec TOTAL
$1,891.50 1,891.50
115.50 115.50
46.50 46.50
1,455.50 1,455.50
44,152.00 44,152.00
4,561.00 4,561.00
390.50 390.50
6,045.50 6,045.50
437.10 437.10
213.90 213.90
46.50 46.50
325.50 325.50
370,221.90 370,221.90
49,302.10 49,302.10
14,861.80 14,861.80
35,675.70 35,675.70
9,207.50 9,207.50
2,348.50 2,348.50
1,395.00 1,395.00
16,898.00 16,898.00
30,034.60 30,034.60
21,779.00 21,779.00
924.00 924.00
2,282.00 2,282.00
38.50 38.50
26,422.00 26,422.00
74.40 74.40
39,656.00 39,656.00
14,455.50 14,455.50
325.50 325.50
685.88 685.88
685.88 685.88
685.88 685.88
685.86 685.86
6211.326-50 698_.3Z6.50
21,229,00 21,229,00
719,555.50 719,555.50
46.50 46.50
2,111in 2,111,10
2,157.10 2,157-60
(698,326.50) (698,326.50)
(2,157.60) (2,157.=
$0.00 $0.00
02/06/98: 02:39 PM 1FY98DEV.WK4
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
1ST QUARTER 1998
1st Qtr Y.T.D.
ACCOUNT # DIVISION Qtec T_QTAL
Community Corrections $1,371.00 1,371.00
Community Development Grant 46.50 46.50
Community Mental Health - Admin 17,087.50 17,087.50
Facilities Maintenance & Operations 288.30 288.30
Garage 1,501.50 1,501.50
Health Immunization 616.00 616.00
Oakland County International Airport 46.50 46.50
Parks and Recreation - Administration 208.50 208.50
Water & Sewer Accounting 154.00 154.00
100% Tax Payment Fund 139.158.50 139.158.50
18-838111-10000-0715 DIRECT CHARGES FOR DATA 8160.478.30 160,478.30
PROCESSING DEVELOPMENT
TOTAL DEVELOPMENT CHARGES S882,191.40 882,19140
•
18-838111 -10000-0429 Sidwell 14,798.50 14,798.50
18-838111-10000-0759 Federal District Court 585.00 585.0Q
TOTAL NON COUNTY AGENCIES 15.383.50 15.383.5Q
(Information Purposes Only) Information Technology 243,791.70 243,791.70
1FY98DEV.VVK4 02/06/98; 02:41 PM
$1 .891.50
$115.50
$46.50
$1.455.50
$42,557.50
1.594.5Q
$1,891.50
$115.50
$46.50
$1,455.50
$44,152.00
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAll. - FIRST QUARTER, F.Y. 1998
GOVERNMENTAL FUNDS
630 ANIMAL CONTROL
620 AUDITING
005 BD OF COMMISSIONERS
665 CHILDRENS VILLAGE
420 CIRCUIT COURT
95682 •Dog System
Animal Control - Total
95468 Auditing - Cust Support
Auditing - Total
91404 BOC - Customer Support
Board of Commissioners - Total
95665 Childrens Village
Childrens Village - Total
95195 Cir Court Admin
95452 Assignment Clerk
Circuit Court - Total
720 CLERK! REGISTER_OF DEEDS 95161 Vital Stats Index $192.50
95189 Circuit Court System 3,263.50
95483 Reg Deeds System Maintenance 500.50
95558 . User Support/ROD 604.50
Clerk/Reg of Deeds - Total $4,561.00
440 CLERK ELECTIONS 95443 Elections $390.50
Elections - Total $390.50
722 CLERK - IMAGING 95158 Clerk - Imaging $46.50
Clerk - Imaging - Total $46.50
410 CLERK - JURY COMMISSION 95512 Jury Commission $6.045.50
Jury Commission - Total $6,045.50
785 COMMUNITY & ECO DEV 95785 Comm & Eco Development $437.10
Commun & Eco Dev - Total $437.10
015 COUNTY EXECUTIVE 95656 County Executive Support $213.90
County Executive - Total $213.90
775 DEVELOPMENT & PLANNING 95600 Cust / System Support $46.50
Development & Planning - Total $46.50
730 DRAM 28009 Drain - Administration $325.50
Drain - Total $325.50
740 EQUALIZATION 31075 Equal - Development $18,834.00
31077 EAC-C/I Upgrade 100,426.00
95559 User Support/Equal 226,435.90
95693 Equal-System Maintenance 24.526.00
Equalization - Total $370,221.90
660 FISCAL SERVICES ADMIN 44001 Oakland Co. Payroll $14,416.50
44002 FIMIS Accounting 4,851.00
95554 Accounting - User Support 465.00
96001 Human Services - Acct'g 29569.60
Fiscal Services Admin - Total $49,302.10
670 FISCAL SERVICES - GENERAL 44077 Bud-System Maintenance $77.00
96003 Human Resources - Budget $14.784.8Q
Fiscal Services - General - Total $14,861.80
01/29/98; 11:02 AM 1 1FY98DEV.VVK4
44042
96002
95200
95202
95203
$35,675.70
$2,111.10
$9,207.50
$2,348.50 $2,348.50
$1,395.00
$16,898.00
$465.00
29.56.9.60
$30,034.60
$35.675.7Q
$2.111.1Q
$9.207.50
IL395.110 IL395.110
AWL® MEL®
$5,717.00
14,014.00
2,048.00
$924.00
$2,282.00
$38.50
$21,779.00
$924.00
$2,282.00
$38.50
$346.50
26,075.5Q
$26,422.00
$74.40
$74.40
$39,656.00
$39,656.00
$1,264.00
154.00
423.50
5,475.00
2,117.00
102216
$14,455.50
$325-50
$325.50
—
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER, F.Y. 1998
GOVERNMENTAL FUNDS
470 FRIEND OF THE COURT
471 FRIEND OF THE CT IMAGING
840 HEALTH DEPARTMENT
843 HEALTH - ENVIRONMENTAL
870 MEDICAL CARE FACIUTY
872 MEDICAL EXAMIRER
680 PERSONNEL
480 PROBATE COURT
481 PROBATE-JUVENILE
145 PROSECUTOR
637 RECORDS RETENTION
650 REIMBURSEMENT
907 RESEARCH LIBRARY
195 SHERIFF
600 TREASURER
910 VETERANS SERVICES
34041 Friend of the Court
Friend of the Court - Total
34042 FOC Develop Image
FOC Develop Image - Total
37025 CHAMPS - P.O.P.
Health - Total
37002 Environmental
Health-Environmental - Total
98873 MCF - Support
Medical Care Facility - Total"
87202 Med Exam - Cust Support
Medical Examiner - Total
Per-System Maintenance
Human Res. - Personnel
Personnel - Total
Probate - Admin
Probate - Estates
Probate - Field Services
Probate - Total
95191 Probate Crt Juv Div
Probate Juvenile - Total
95622 Prosecutor/Executive
Prosecutor - Total
95637 Records Retention
Records Retention - Total
95469 Reimbursement Div
95470 Reimbursement System
Reimbursement - Total
91405 Library Board
Research Library - Total
95476 Jail Management System
Sheriff - Total
44060 Tre-Customer/lssue Management
44061 Tre-System/Customer Support
95303 Del Tax System Maintenance
95313 DTX-Enhance/Developm
95523 User Suppt - Treas
95561 User Support/Del Tax
Treasurer - Total
95651 Veterans Cust Support
Veterans Servicse - Total
2 1-98DEV.VVK4 01/06/98; 02:00 PM
560 52/3 DISTRICT COURT - ROCHESTER 95529 DC Suprt -25%-5213
52/3 District Court - Total
ROCHESTER $655118
$685.88
1685.116
$685.86
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - FIRST QUARTER, F.Y. 1998
GOVERNMENTAL FUNDS
540 5211 DISTRICT COURT - NOVI 95527 DC Suprt -25%-5211
52/1 District Court - Total
$685.88
$685.88
550 5212 DISTRICT COURT - CLARKSTON 95528 DC Suprt -25%-52/2
52/2 District Court - Total
$68.5.1311
$685.88
530 52/4 DISTRICT COURT - TROY 95530 DC Suprt -25%-5214
52/4 District Court - Total
01/06/88; 02:00 PM 3 1-88DEV.WK4
SLIZLEKI
$46.50
S17.087.513
$288.30
$1.501.50
16.11134
$9,858.00
35.5.04
$137,612.30
1,999.50
57,121.50
186.00
3,503.50
5,022.00
8,769.90
14,840.50
462.00
248.5Q
$3.813.00
$93.00
77.00
38.50
$154.00
$139,158.50
$1,371.00
$46.50
$17,087.50
$288.30
$1,501.50
$616.00
$10,213.00
$229,765.70
$3,813.00
$46.50
$208.50
$154.00
$139,158.50
$15,383.50
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER, F.Y. 1998
DIRECT FUNDS
0735 657 COMMUNITY CORRECTIONS
0735 661 COMMUNITY DEVELOPMENT
0716 663 ChilitADOEN
0715 750 MC MAINT & OPERATIONS
0715 655 GARAGE
0735 380 HEALTH IMMUNIZATION - GRANT
010 INFORMATION TECHNOLOGY
Administrative Services
Systems Develop/Support
Technical Sys/Networking
0715 653 O.C. INTERNATIONAL AIRPORT
0715 770 PARKS & REC ADMINISTRATION
0715 656 WATER & SEWER ACCOUNTING
0735 602 100% TAX PAYMENT FUND
0759 NON-COUNTY AGENCIES
65701 Community Correction
Community Corrections - Total
66103 Comm Dev User Support
Community Development - Total
66306 CMH System Development
CMH Admin - Total
75503 FM0 Development
FM&O - Total
65498 Garage Support
Garage - Total
38000 Health - Immunization -
Health - Immunization - Total
91514 System Support - Adrnin Service
95485 Job Acct System lnst
02000 Year 2000 Project
25200 Open Systems Administraiton
25400 Oracle Administration
31008 Dev Billed to Private Sector
84200 Health Grant Overhead
91501 System Support - Finance/Adrnin
91503 System Support - Office Automation
91510 System Support - Sys Dev & Support
91512 System Support. Health Plus
95456 Equipment Inventory
95689 Database Tech Support
65301 Airport User Support
O.C. Intemat'l Airport - Total
PRADM-Customer Support
PRTS - Tech Support
P&R - Addison Oaks
Parks & Rec Admin - Total
95669 Water & Sewer Acctg
Water & Sewer Acctg - Total
95310 Delinquent Tax Oracle Fund
100% Tax Payment Fund - Total
95413
95415
95418
01/22/98; 04:13 PM 1FY98DEV.VVK4 4
•
Resolution #98035 March 5, 1998
The Chairperson referred the resolution to the Finance Committee. There
were no objections.
FISCAL NOTE (MSC. #98035) March 19, 1998
BY: FINANCE, SUE ANN DOUGLAS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FIRST 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 and Personnel Committee
has reviewed the above referenced Resolution and finds:
1. Information Technology has completed first quarter Data Processing
Development for governmental fund County departments and requests an
appropriation transfer to the user departments.
2. The transfer has been reviewed by the Strategic Planning Committee.
3. The FY1998 Budget should be amended, per the attached document
entitled Information Technology Data Processing Development Summary.
4. 1998 First Quarter Development for the 100t Tax Payment Fund equals
$139,159. This amount reflects a direct reduction of the
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
DEPT/OCA/PCA/OBJECT
18-636111-10000-0715 Non-Govt. Develop. S 139,159
Expense
18-636122-15000-3348 Professional Serv. $ 139,159
FINANCE COMMITTEE
Resolution #98035 March 19, 1998
Moved by Powers supported by Johnson the resolution be adopted.
AYES: Law, McCulloch, McPherson, Millard, Moffitt, Obrecht, Palmer,
Powers, Schmid, Taub, Wolf, Amos, Coleman, Devine, Dingeldey, Douglas, Garfield,
Gregory, Holbert, Huntoon, Jacobs, Jensen, Johnson, Kaczmar, Kingzett. (25)
NAYS: None. (0)
A sufficient majority having voted therefor, the resolution was adopted.
I HERJ13)r}FAIOVg/THE FOREGOING RESOLUTION
)/2 L. Brooke-Patterson. County Executive Date
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, Lynn D. Allen, 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 19, 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
County of Oakland at Pontiac, Michigan this 19th day of Marc4r1998.
7 . Allen, County Clerk n7D ..""4-