HomeMy WebLinkAboutResolutions - 1996.11.21 - 24865November 7, 1996
MISCELLANEOUS RESOLUTION 196259
BY: STRATEGIC PLANNING COMMITTEE, DENNIS POWERS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - THIRD QUARTER 1996 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 Third
Quarter 1996 data processing development charges to be $510,417 and the imaging
development charge to be $3,835 for the governmental fund County departments; and
WHEREAS direct charges to non-governmental fund departments and non-County
agencies are $570,807 for the Third Quarter 1996; 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 1996 Data Processing Development and approves the
third quarter appropriation transfer.
Chairperson, on behalf of the Strategic Planning Committee, I move the
adoption of the foregoing resolution.
S TEGIC PLANNING COMMITTEE e
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
3RD QUARTER 1996
FUND/DIVISION/ACCOUNT
4-10100-123-01-00-6361
4-22100-178-01-00-6361
4-10100-112-01-00-6361
4-10100-511-01-00-6361
4-10100-122-01-00-6361
4-29230-165-01-00-6361
4-21500-127-05-00-6361
4-10100-311-01-00-6361
4-10100-179-01-00-6361
4-10100-214-01-00-6361
4-10100-213-01-00-6361
4-10100-21541-00-6361
4-10100-191-01-00-6361
4-10100-111-05-00-6361
4-10100-175-01-00-6361
4-10100-115-01-00-6361
4-10100-111-01-00-6361
4-10100-192-01-00-6361
4-10100-611-01-00-6361
4-10100-194-01-00-6361
4-10100-148-01-00-6361
4-10100-141-01-00-6361
4-22100-141-30-00-6361
4-10100-126-01-00-6361
4-21500-312-01-00-6361
4-10100-121-01-00-6361
4-22100-162-01-00-6361
4-22100-162-01-00-6361
4-22100-162-20-00-6361
4-52100-163-01-00-6361
4-10100-169-01-00-6361
4-10100-151-01-00-6361
4-10100-171-03-00-6361
4-10100-344-01-00-6361
4-10100-341-01-00-6361
4-10100-411-01-00-6361
4-10100-124-01-00-6361
4-10100-138-03-00-6361
4-10100-127-01-00-6361
4-10100-513-03-00-6361
4-10100-433-10-00-6361
4-10100-221-01-00-6361
4-10100-173-01-00-6361
4-10100-322-01-00-6361
4-10100-322-05-00-6361
DIVISION
Accounting
Animal Control
Auditing
Board of Commissioners - Adm.
Budget
Children's Village
Child Support/FOC/Reimbursement
Circuit Court - Administration
Circuit Court Probation
Clerk Register of Deeds
Clerk - Elections
Clerk - Jury Commission
Community & Economic Development
Community & Minority / Cultural Affairs
Cooperative Extension Service
Corporation Counsel
County Executive
Development & Planning Division
Drain Commissioner
Equalization Division
Facility Engineering
Facilities Management - Administration
Facilities Management - EMS
Fiscal Services
Friend of the Court
GIS - Management & Budget
Health - CHAMPS
Health Division
Health Environmental
Medical Care Facility
Medical Examiner
Personnel
Pretrial Services - County
Probate Court - Estates & Mental Health
Probate Court - Juvenile
Prosecuting Attorney
Purchasing Division
Records Retention
Reimbursement Division
Research Library
Sheriff
Treasurer
Veteran's Services
52/1 District Court
52/1 District Court Probation
3rd Qtr Y.T.D.
(July - Sept.) TOTAL
165,056.40
1,632.00 1,761.50
2,970.00 11,055.00
2,992.80 9,515.20
31,263.20
1,482.00 7,312.00
2,094.00 3,346.00
43,153.26 90,509.80
156.00 . 1,287.00
39,751.00 79,621.50
14,795.00 21,680.00
7,132.00 16,890.00
275.20 6,425.50
172.00 412.80
506.50
1,236.50
60.20 3,024.40
9,808.40 23,154.90
1,287.20 1,674.20
58,390.00 226,578.90
94.60
25.80 956.80
851.40 1,874.80
94,645.00 94,645.00
69,015.97 179,032.65
5,947.00
14,155.20 53,753.60
3,168.00
816.00
1,734.00 3,090.50
104.00 2,383.00
18,551.00 54,754.60
494.00
9,554.00 32,156.00
21,984.37 84,772.85
7,152.00 43,729.60
2,730.00 6,718.50
1,548.80 11,072.80
15,194.00 48,292.00
3,190.60 6,275.60
11,623.00 105,156.50
18,111.00 64,640.00
223.60 3,646.10
8,468.00 20,300.33
340.50
10/21/96
4,274.00
19,556.00
23,830.00
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
3RD QUARTER 1996
FUND/DIVISION/ACCOUNT
4-10100-323-01-00-6361
4-10100-323-05-00-6361
4-10100-324-01-00-6361
4-10100-325-01-00-6361
DIVISION
52/2 District Court
52/2 District Court Probation
52/3 District Court
5214 District Court
3rd Qtr
(July - Sept.)
8,468.00
8,468.00
8.468.00
Y.T.D.
TOTAL
19,827.33
137.50
20,577.33
20,704.25
DATA PROCESSING DEVELOPMENT FOR
GOVERNMENTAL FUND APPROPRIATION
4-10100-212-10-00-6367 Clerk
4-21500-312-01-00-6367 Friend of the Court
TOTAL IMAGING DEVELOPMENT
APPROPRIATION
4-10100-181-01-00-6361 Information Technology
4-10100-181-01-00-6367 Imaging Development
TOTAL GOVERNMENT:
Community Corrections
Community Development Grant
Community Mental Health
Delinquent Tax Personal Property
Facilities Maintenance & Operations
FM&O - Telephone Communications
Garage
Health Immunization
In-Car Terminals
Information Technology
Oakland County International Airport
Parks and Recreation
Parks and Recreation - Recreation Admin
Parks and Recreation - Tech Support
Pretrial Services - Grant
Print Shop
Risk Management
Water & Sewer Accounting
Grants Miscellaneous
Non-County Agencies
100% Tax Payment Fund
510,416.80
86.00
3.749.00
3,835.00
(510,416.80)
(3.835.00)
$ILO
17,893.00
490.20
29,833.60
5,576.00
1,487.00
2,544,00
16,415.20
325,051.20
240.80
2,524.00
650.00
2,382.00
11,669.00
250.80
153,800.00
1,426,612.64
(1,426,612.64)
(23,830.00)
$191
18,820.50
3,419.10
61,989.70
8,930.00
5,317.00
7,882.00
4,521.00
16,415.20
2,675.00
1,087,464.79
1,407,30
19,646.00
982.00
714.00
1,069.50
952.00
3,694.00
21,105.00
30,902.80
3,253.20
329,210.20
DIRECT CHARGES FOR DATA
PROCESSING DEVELOPMENT
TOTAL DEVELOPMENT CHARGES
$570,806.80 1,630,370.29
$1.085,058.60 3,080,812.93
10/21/96
$156.00
$156.00
$86.00
659.00
510.00
34,440.00
1,732.00
1,196.00
1.214.00
$7.132.00
$275.20
$172.00
$60.20
S9.808.40
$39,837.00
$7,132.00
$275.20
$172.00
$60.20
$9,808.40
• INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL -THIRD QUARTER, 1996
GOVERNMENTAL FUNDS
ANIMAL CONTROL 95682 Dog System $L632.00
Animal Control - Total
AUDITING 95468 Auditing - Cust Support $2.970.00
Auditing - Total
BD OF COMMISSIONERS 91404 BOC - Customer Support $2.992.80
Board of Commissioners - Total
CH1LDRENS VILLAGE 95665 Childrens Village $1.482.00
Childrens Village - Total
CHILD SUPPORT / FOC I REIMS 34001 Child Support $2 094 00
Child Support/FOC/Reimb - Total
••
$1,632.00
$2,970.00
$2,992.80
$1,482.00
$2,094.00
CIRCUIT COURT 95195
95452
Cir Court Admin
Assignment Clerk
Circuit Court - Total
$39,963.26
3.190.00
$43,153.26
CLERK - JURY COMMISSION
COMMUNITY & ECON DEVELOPMENT
COMM & MIN / CULTURAL AFFAIRS.
COUNTY EXECUTIVE
DEVELOPMENT & PLANNINQ
CIRCUIT COURT PROBATION
CLERK/ REGISTER OF DEEDS
80204 Circuit Court Probation
Circuit Court Probation - Total
95158 Clerk - Imaging
95161 Vital Stets Index
95170 Legal Division
95189 Circuit Court System
95495 Land Records
95497 Reg of Deeds Development
95558 User Support/ROD
Clerk/Reg of Deeds - Total
95512 Jury Commission
Jury Commission - Total
95785 Comm & Eco Development
Commun & Eco Dev - Total
95535 Comm & Minority Affairs
Comm & Min / Cultural Affairs - Total
95656 County Executive Support
County Executive - Total
95600 Cust I System Support
Development & Planning - Total
10/18/96
91500 FM - System Support
Facilities Management - Total
95479 FM&O-EMS-Cust Support
Facilities Management-EMS - Total
25110 GIS Development
44001 Oakland Co. Payroll
44002 FIMIS Accounting
65506 Accounting - Drain
95554 Accounting - User Support
95555 Budget User Support
96001 Human Res - Accounting
96003 Human Resources - Budget
Fiscal Services - Accounting - Total
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
43001 Hospital
98873 MCF - Support
Medical Care Facility - Total
$1.287.20
$14.72.5S10
$6,998.00
2,623.00
11,324.00
4,759.00
32,084.00
602.00
$25.80
$851,40
$17,913.00
16,647.00
13,665.00
702.00
12,960.00
$7,955.00
23,962.00
841.00
$69.015.97
$3.749.00
$14.155,20
$1,287.20
$14,795.00
$58,390.00
$25.80
$851.40
$94,645.00
$69,015.97
$3,749.00
$14,155.20
$578.00
1.156.00
$1,734.00
• INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL THIRD QUARTER, 1996
GOVERNMENTAL FUNDS
DRAIN 28009 Drain - Administration
Drain - Total
ELECTIONS 95443 Elections
Elections - Total
EQUALIZATION 31071 EMA - Development
31072 SLF - Development
31073 SEQ - Development
31075 Equal - Development
95559 User Support/Equal
95694 ETA - Development
Equalization - Total
FACILITIES MANAGEMENT
FACILITIES MANAGEMENT - EMS
FISCAL SERVICES
FRIEND OF THE COURT
FRIEND OF THE CT IMAGING
HEALTH DEPARTMENT
MEDICAL CARE FACILITY
MEDICAL EXAMINER 87202 Med Exam - Cust Support
Medical Examiner - Total
$104.00
$104.00
10118/96 2
$306.00
13,246.00
1,958.00
3.041.00
$18,551.00
$1,156.00
4,930.00
3.468.00
$9,554.00
S21.984.37
$21,984.37
$2,380.00
1,237.00
3,535.00
$7,152.00
PURCHASING
RECORDS RETENTION
REIMBURSEMENT
RESEARCH LIBRARY
SHERIFF
TREASURER
VETERANS SERVICES
5711 DISTRICT COURI- NOVt
$2.730.00
$2,730.00
326.80
1.222.00
$15.194.00
$3.190.60
1,548.80
$15,194.00
$3,190.60
$11,155.00
4E6-411
$11,623.00
$9,360.00
8.751.00
$18,111.00
$223.60
$8,468.00
$223.60
$8.468.00
* INFORMATION TECHNOLOGY RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER, 1996
GOVERNMENTAL FUNDS
PERSONNEL 95434 Personnel Appl Exam
95556 Personnel User Support
95560 Personnel - Employee Benefits
96002 Human Res. - Personnel
Personnel - Total
PROBATE COURT 95201 Probate - Adoptions
95202 Probate - Estates
95206 Probate - Psych Clinic
Probate-Total
PROBATE -JUVENILE 95191 Probate Crt Juv Div
Probate Juvenile - Total
PROSECUTOR 95664 Prosecutor Warrants
96148 Victim Witness Unit
97004 Prosecutor Case Records
Prosecutor - Total
• 95663 Purchasing
Purchasing - Total
79003 Radio - Customer/System
95637 Records Retention
Records Retention - Total
95470 Reimbursement System
Reimbursement - Total
91405 Library Board
Research Library - Total
95476 Jail Management System
95543 User Support/Sheriff
Sheriff - Total
95483 Fund Management •
95561 User Support/Del Tax
Treasurer - Total
95651 Veterans Cust Support
Veterans Servicse - Total
95527 DC Suprt -25%-5211
52/1 District Court - Total
10118/96 3
DC Suprt -25%-52/2
52/2 District Court - Total
DC Suprt -25%-52/3
5213 District Court - Total
DC Suprt -25%-52/4
52/4 District Court - Total
MAUD
itiLgifiag
$8.468.00
$8,468.00
$8,468.00
$8,468.00
•• INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER, 1996
GOVERNMENTAL FUNDS
02 DISTRICT COURT - CLARKSTON 95528
5213 DISTRICT COURT - ROCHESTIN 95529
52/4 DISTRICT COURT - TROY 95530
10/18/96 4
COMMUNITY CORRECTIONS
COMMUNITY DEVELOPMENT
COMMUNITY MENTAL HEALTH
DELINQUENT TAX. PERS PROP
FAC MAINT & OPERATIONS
GARAGE
HEALTH IMMUNIZATION - GRANT
INFORMATION TECHNOLOGY
Employee Skills Development
Administrative Services
Systems Develop/Support
Technical Sys/Networking
- INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - THIRD QUARTER, 1996
DIRECT FUNDS
65701 Community Corrections
Community Corrections - Total
66103 Comm Dev User Support
Community Development - Total
66306 CMH System Development
CMH - Total
95616 Del Tax Personal Property
Delinquent Tax - Total
75503 FM0 Development
FM&O - Total
65498 Garage Support
Garage - Total
38000 Health - Immunization
Health - Immunization - Total
00101 Skills Upgrade
Proj Mgmt DBase/PMD
System Support - Admin
Job Acct System Inst
02000 Year 2000 Project
25200 Open Systems Administration
25300 HP-UX Administration
25400 Oracle Administration
50198 Tax Rec Maintenance
84200 DIT - Health Grant
91412 FOC - CSES
91501 System Support - Finance
91503 System Support - Office Automation
91505 System Support - Law Enforcement
91506 System Support - Courts
91507 System Support - Land Systems
91510 System Support. Sys Dev & Support
91512 System Support - Health Plus
91506 Tax Prop "A" Mods
95405 MVR-Machine Charges
95456 Equipment Inventory
95472 FDC Wheel County Development
95689 Database Tech Support
$17.893.00
$490.20
$29.833.60
$5.576.00
$1.487.00
$2.544.00
$16.415.20
$60.980.00
$78.00
9,468.60
16.390.40
6917.00
21,304.00
9,947.00
55,703.00
1,870.00
2,339.20
989.00
27,486.00
2,953.60
136.00
24,372.00
8,780.00
48,870.20
2,511.20
559.00
510.00
988.00 eatim
$27.219.00
91511
91514
95485
$17,893.00
$490.20
$29,833.60
$5,576.00
$1,487.00
$2,544.00
$16,415.20
$60,980.00
$25,937.00
$210,915.20
$27,219.00
10118/96 5
$240.80
$2,524.00
$650.00
$2,382.00
$153,800.00
11,669.00
- INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER, 1996
DIRECT FUNDS
Q.C. INTERNATIONAL AIRPORT
PARKS & RECREATION
PRINT SHOP
WATER & SEWER ACCOUNTINQ
100% TAX PAYMENT FUND
GRANTS
65301 Airport User Support $240.80
O.C. Internet, Airport - Total
95416 P&R - Recreation Admin $2.524.00
Parks & Recreation - Total
64301 Printing Support $650.00
Print Shop - Total
95669 Water & Sewer Acctg $2.382.00
Water & Sewer Acctg - Total
95310 Delinquent Tax Oracle $153.800.00
100% Tax Payment Fund - Total
HON-COUNTY AGENCIES 250.80
FISCAL NOTE (M.R.#96259)
BY: FINANCE AND PERSONNEL COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - THIRD QUARTER 1996 DEVELOPMENT
APPROPRIATION TRANSFER
TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS
Chairperson, Ladies and Gentlemen:
Pursuant to Rule XII-G of this Board, the Finance and Personnel
Committee has reviewed Miscellaneous Resolution 196259 and finds:
1. Information Technology has completed third 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 1996 Biennial Budget should be amended, per the attached
document entitled Information Technology Data Processing
Development Summary.
4. 1996 Third Quarter Development for the 100% Tax Payment Fund
equals $153,800. 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.
Revenue
3-63600-181-01-00-2349 Non-Govt. Develop. $153,800
Expense
4-63600-182-01-00-3128 Professional Serv. $153,800
$ -0-=
FINANCE AND PERSONNEL COMMITTEE
Resolution #96259 November 21, 1996
Moved by Powers supported by Pernick the resolution be adopted.
AYES: McCulloch, McPherson, Moffitt, Obrecht, Palmer, Pernick, Powers,
Quarles, Schmid, Taub, Wolf, Amos, Crake, Devine, Dingeldey, Douglas, Garfield,
Holbert, Huntoon, Jacobs, Jensen, Johnson, Kaczmar, Kingzett. (24)
NAYS: None. (0)
A sufficient majority having voted therefor, the resolution was adopted.
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 November 21, 1996 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 21st day pf Nove 1996.
D. Allen, County Clerk