HomeMy WebLinkAboutResolutions - 1996.09.12 - 24912AUGUST 29, 1996
MISCELLANEOUS RESOLUTION #96198
BY: STRATEGIC PLANNING COMMITTEE, DENNIS POWERS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - SECOND 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
Second Quarter 1996 data processing development charges to be $580,056 and the
imaging development charge to be $3,986 for the governmental fund County
departments; and
WHEREAS direct charges to non-governmental fund departments and non-
County agencies are $547,708 for the Second 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 Second Quarter 1996 Data Processing Development
and approves the second quarter appropriation transfer.
Chairperson, on behalf of the Strategic Planning Committee, I move the
adoption of the foregoing resolution.
C
S TEGIC PLANNING COMMITTEE
2 v1 e CI1041t4
FISCAL NOTE( M.R. #96198)
BY: FINANCE AND PERSONNEL COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - SECOND 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 #96198 and finds:
1. Information Technology has completed second 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 Second Quarter Development for the 100% Tax Payment Fund
equals $118,088. 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. $118.088
Expense
4-63600-182-01-00-3128 Professional Serv. $118,088
$ -0-=
FINANCE AND PERSONNEL COMMITTEE
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
2ND QUARTER 1996
2nd Qtr
(Apr - June)
91,59t00
102.00
3,598.00
5,486.80
13,833.00
2,080.00
21,514.04
636.00
18,500.00
2,374.00
8,705.00
567.80
240.80
387.00
154.80
11,570.60
387.00
97,656.40
94.60
825.60
1,023.40
66,993.18
15,683.40
1,166.00
816.00
612.00
832.00
18,889.20
494.00
18,802.00
31,224.98
14,370.00
2,002.00
6,544,20
18,195.00
2,279.00
52,860.00
22,223.00
2,924.00
5,792.52
5,319.52
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-215-01-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-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
4-10100-323-01-00-6361
4-10100-323-05-00-6361
DIVISION
Accounting - Administration
Animal Control
Auditing
Board of Commissioners - Adm.
Budget Division
Children's Village
Child Support/FOG/Reimbursement
Circuit Court - Administration
Circuit Court Probation
Clerk Register of Deeds
Clerk - Elections
Clerk - Jury Commission
Community & Economic Development
Community & Minority Affairs
Cooperative Extension Service
Corporation Counsel
County Executive
Development & Planning Division
Drain Commissioner
Equalization Division
Facility Engineering
Facilities Management - Administration
Facilities Management - EMS
Friend of the Court
GIS - Management & Budget
Health - CHAMPS
Health Division
Health Environment
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
52/2 District Court
52/2 District Court Probation
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
2ND QUARTER 1996
2nd Qtr
FUND/DIVISION/ACCOUNT DIVISION (Apr - June)
4-10100-324-01-00-6361 52/3 District Court 5,319.52
4-10100-325-01-00-6361 52/4 District Court 5,386.44
DATA PROCESSING DEVELOPMENT FOR
GOVERNMENTAL FUND APPROPRIATION $580,055.80
4-10100-212-10-00-6367 Clerk 1,290.00
4-21500-312-01-00-6367 Friend of the Court 2.,696.00
TOTAL IMAGING DEVELOPMENT 3,986‘00
APPROPRIATION
4-10100-181-01-00-6361 Information Technology (580,055.80)
4-10100-181-01-00-6367 Imaging Development (3.986.00)
TOTAL GOVERNMENT: ($0,00)
Community Corrections 686.00
Community Development Grant 1,023.40
Community Mental Health 16,707.60
Delinquent Tax Rewrite 3,354.00
Facilities Maintenance & Operations 3,013.00
FM&O - Telephone Communications 2,820.00
Garage 1,450.00
In-Car Terminals
Information Technology 371,660.80
Oakland County International Airport 808.40
Parks and Recreation 5,134.00
Parks and Recreation - Recreation Admin 982.00
Parks and Recreation - Tech Support 714.00
Pretrial Services - Grant
Print Shop 302.00
Risk Management 215.00
Water & Sewer Accounting 11,828.00
Grants Miscellaneous 8,149.80
Non-County Agencies 771.90
100% Tax Payment Fund 118,088.20
DIRECT CHARGES FOR DATA $547,708.10
PROCESSING DEVELOPMENT
TOTAL DEVELOPMENT CHARGES $551,694.10
91511 Proj Mgmt DBase/PMD 7,422.00
91514 System Support - Admin Services 28,663.80
95000 Freedom of Information 86.00
95485 Job Act Sys Inst 7.834.60
Administrative Services - Total
25200 Open Systems Administration 27,221.00
25300 HP-UX Administration 9,831,00
25400 Oracle Administration 56,550.00
42302 Project User Support 86.00
50198 Tax Rec Maintenance 1,700.00
84200 DIT-Health Grant Overhead 36,987.40
91412 FOC - CSES 43.00
91501 System Support - Finance 24,217.00
91506 System Support - Courts/Health 28,199.80
91507 System Support - Land Systems 8,212.00
91510 System Support - Sys Dev/Support 41,727.20
91512 System Support - Health Plus 6,637.80
91522 CLEWS Tracking - Non-Bill 3,444.40
95106 Tax Prop "A" Mods 645.00
95405 MVR-Machine Charges 510.00
95472 FDC Wheel Count Development 14.620.00
Systems Develop/Support = Total
$44,006.40
$260,631.60
Administrative Services
Systems Develop/Support
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER, 1996
GOVERNMENTAL FUNDS
DIRECT CHARGES
657 COMMUNITY CORRECTIONS 65701 Community Corrections Office $686.00
Community Corrections - Total
661 COMMUNITY DEVELOPMENT 66103 Community Dev User Support $1.023.40
Community Development - Total
663 COMMUNITY MENTAL HEALTH 66306 CMH System Development $16107.60
Community Mental Health - Total
601 DELING TAX - PERSONAL PROPERTY 95307 Del Tax Rewrite $3.354.00
Del Tax Rewrite - Total
750 FACILITIES MAINTENANCE & OPER 75503 FM&O - Development sun=
Facilities Maintenance & Oper - Total
751 FM&O-TELEPHONE COMMUNICATIONS 75102 Tel Comm- Customer Support $2,820.00
FM&O-Tel Communications - Total
655 GARAGE 65498 Garage - Support $1.450.00
Garage- Total
010 iNFORMATION TECHNOLOGY
Employee Skills Development 00101 Skills Upgrade $31.240.00
Employee Skills Development - Total $31,240.00
$686.00
$1,023.40
$16,707.60
$3,354.00
$3,013.00
$2,820.00
$1,450.00
Technical Sys/Networking 3,317.80
32.465.00
91503 System Support - Office Automatio
95689 Database Tech Supt
Technical Sys/Networking - Total
$808.40
$35,782.80
$808.40
653 OAKLAND COUNTY
INTERNATIONAL AIRPORT
65301 Airport User Support
0.C. Intemt'l Airport - Total
NON-COUNTY AGENCIES $771.90
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER, 1996
GOVERNMENTAL FUNDS
770 PARKS & RECREATION
771 p & R - RECREATION ADMIN
772 p a R- TECH SUPPORT
643 PRINT SHOP
695 RISK MANAGEMENT
656 WATER & SEWER ACCOUNTING
602 100% TAX PAYMENT FUND
GRANTS
95169 Parks & Rec - Admin Services
95413 Parks & Rec - Customer Support
Parks & Recreation - Total
95416 Parks & Rec - Recreation Admin
P&R - Recreation Admin - Total
95415 P&R - Tech Support
P&R - Tech Support - Total
64301 Printing Support
Print Shop - Total
95695 Risk Management
Risk Management - Total
95669 Water & Sewer Accounting
Water & Sewer Accounting - Total
95310 Delinquent Tax Revolving Fund
100% Tax Payment Fund - Total
$2,618.00
2516.00
$982.00
$714.00
$302.00
$215.00
511.828.00
$118.088.20
$5,134.00
$982.00
$714.00
$302.00
$215.00
$11,828.00
$118,088.20
$8,149.80
37025
95563
CHAMPS-POP.
User Support / Health
Health - Total
840 HEALTH $15,683.40
1.166.00
$16,849.40
$816.00
$816.00
$812.00
$612.00
$832.00
$832.00
$952.00
1,962.20
2,910.00
748.00
12.317.00
$18,889.20
$149121
$494.00
$2,040.00
13,838.00
2,210.00
714.114
$18,802.00
$31.224..Q8
$31,224,98
3,096.00
102.00
664.00
$2,298.00
688.00
136.00
7.386.00
$14,370.00
$2.002.00
$2,002.00
$60.20
6,4tM.0Q
$6,544.20
$18.195.00
$18,195.00
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER, 1996
GOVERNMENTAL FUNDS
843 HEALTH - ENVIRONMENTAL
870 MEDICAL CARE FACILITY
872 MEDICAL EXAMINER
680 PERSONNEL
658 PRETRIAL SERVICES - COUNTY
480 PROBATE COURT
481 PROBATE JUVENILE
145 PROSECUTOR
690 PURCHASING
637 RECORDS RETENTION
650 REIMBURSEMENT
37002 Environmental
Health-Environmental - Total
98873 MCF - Support
Medical Care Facility - Total
87202 Med Exam - Customer Support
Medical Examiner - Total
Misc - Empl Rel
Personnel - Web Project
Pers Appl Exam
Personnel - Employee Benefits
Human Res. - Personnel
Personnel - Total
95199 Pre-Trial Services County
Pretrial Services-County - Total:
Probate - Adoptions
Probate - Estates
Probate - Psych Clinic
Probate Court System
Probate Court - Total
95191 Prob Court Juvenile Division
Probate Juvenile - Total
PC Netwk/Prosecutors
PROMIS
Pros/Executive
Prosecutor Warrants
Victim Witness Unit
Prosecutor Data Proc
Prosecutor Case Records
Prosecutor - Total
95663 Purchasing
Purchasing - Total
79003 Radio - Customer/System Support
95637 Records Retention
Records Retention - Total
95470 Reimbursement System
Reimbursement - Total
01020
95304
95434
95560
96002
95201
95202
95206
95618
95007
95619
95622
95664
96148
97001
97004
91405 Library Board $2.279.00 907 RESEARCH LIBRARY
95116 Annual Conversion $2,890.00
95309 Treas Bond Rewrite $1,456.00
95311 DIX-Prop "A" Upgrade 1,360.00
95483 Fund Management 8,274.00
95561 User Support/Del Tax 8.243.911
Treasurer - Total
95650 Veterans Services - Equipment
95651 Veterans Cust Support
Veterans Services Total
95509 Cash & Violations 52/1
95527 DC Support - 25%-52/1
52/1 District Court - Total
95528 DC Suprt - 25%-52/2
5212 District Court - Total
95529 DC Support-25%-52/3
52/3 District Court - Total
95530 DC Support-25%-52/4
52/4 District Court - Total
195 SHERIFF 95476 Jail Mgmt System $48,726.00
95543 User Support/Sheriff 1,898.00
97164 Sheriff-Development 2.236.00
Sheriff - Total $52,860.00
$22,223.00
600 TREASURERS
910 VETERANS SERVICES
540 5211 DISTRICT COURT
550 62/2 DISTRICT COURT
560 5213 DISTRICT COURT
530 6214 DISTRICT COURT
$240.80
2.683.20
$2,924.00
$473.00
5.319.52
$5,792.52
$5.319.52
$5.319.52
$5.386.44
$5,319.52
$5,319.52
$5,386.44
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER, 1996
GOVERNMENTAL FUNDS
Research Library - Total $2,279.00
80204 Circuit Court Probation
Circuit Court Probation - Total
95195
95452 -
95510
Cir Crt Admin —
Assignment Clerk
Development - Drug Grant
Circuit Court - Total
$19,061.00
15,591.00
18,231.00
38.708.00
$102.00
$3,598.00
55.486.80
$91,591.00
$102.00
$3,598.00
$5,486.80
$9,447.00
4.386.00
$13,833.00
$2.080.0Q
$18,257.04
2,655.00
602.00
$636.00
$2,080.00
$21,514.04
$636.00
Clerk-Imaging
V/R J/D Prog Mod
Vital Stats Index
Legal Division
Circuit Court System
Land Records
User Support/ROD
Clerk Reg of Deeds - Total
95158
95159
95161
95170
95189
95495
95558
95443 Elections
Clerk - Elections - Total
INFORMATION .TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER, 1996
GOVERNMENTAL FUNDS
660 ACCOUNTING
630 ANIMAL CONTROL
620 AUDITING
005 ED OF COMMISSIONERS
670 MGM
665 CHILDRENS VILLAGE
420 CIRCUIT COURT
450 CIRCUIT COURT PROBATION
GIS - Development
FIMIS Acctg
Accounting User Support
Human Res - Acctg
Accounting - Total
95682 Dog System
Animal Control - Total
95468 Auditing - Cust Support
Auditing - Total
91404 BOC - Customer Support
Bd of Commissioners - Total
95555 Budget User Support
96003 Human Res. - Budget
Budget - Total
95665 Childrens Village
Childrens Village - Total
25119
44002
95554
96001
720 CLERK REG OF DEEDS
440 CLERK - ELECTIONS
410 CLERK - JURY COMMISSION
$1,290.00
$344.00
1,197.00
258.00
11,305.00
2,042.00
3,354.00
$2.374.00
$19,790.00
$2,374.00
$8,705.00
95512 Jury Commission $111125.110
Clerk - Jury Commission - Total
730 DRAIN COMMISSIONER Drain Commissioner
Drain Eng & Construc
Drain - Administration
Drain Commissioner - Total
$17.20
25.80
344.21
28007
28008
28009
$387.00
$1,935.00
1,176.40
16,430.20
5,171.00
12,653.40
8,428.00
19,480.00
32.382.40
_ $97,656.40
$825.60
51.023.40
$68,993.18
$2.696.00
$94.60
$825.60
$1,023.40
$66,993.18
$2,696.00
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER, 1996
GOVERNMENTAL FUNDS
785 COMMUNITY & ECONOMIC
DEVELOPMENT
017 COMMUNITY & MINORITY AFFAIRS
430 CORPORATION COUNSEL
015 ..C.Q.UNMEXECLEEIYI
95785 Comm & Eco Development
Comm & Eco Development - Total
95535 Comm & Min Affairs
Comm & Min Affairs - Total
95501 Corporation Counsel
Corporation Counsel - Total
Development - County Executive
County Executive Support
County Executive - Total
$567.80
$567.80
$240.80
$240.80
$387.00
$387.00
$68.80
116-22
$154.80
95654
95656
775 DEVELOPMENT & PLANNING 95600 Cust/System Support
Development & Planning - Total
$11.570.60
$11,570.60
740 EQUALIZATION
752 FACILITY ENGINEERING
755 FACILITIES MANAGEMENT - ADM
900 FACILITIES MANAGEMENT -EMS
470 FRIEND OF THE COURT
472 FRIEND OF THE CT IMAGING
SID Sales Anal
SLF-Development
SEQ-Development
STB-Development
Equal-Development
Headlee Modif
User Support/Equal
ETA - Development
Equalization - Total
75504 DPW - FE Development
Facility Engineering - Total
91500 FM - System Support
Facilities Management - Total
95479 FM&O - EMS Cust Support
Facilities Management - EMS - Total
34041 Friend of the Court
Friend of the Court - Total
34042 F 0 C Develop Image
FOC Imaging - Total
31062
31072
31073
31074
31075
95457
95559
95694
Resolution #96198 September 12, 1996
Moved by Powers supported by Kaczmar the resolution be adopted.
AYES: McPherson, Moffitt, Obrecht, Palmer, Pernick, Powers, Schmid, Taub,
Wolf, Amos, Crake, Devine, Dingeldey, Douglas, Garfield, Holbert, Huntoon,
Jacobs, Jensen, Johnson, Kaczmar, Kingzett, Law, McCulloch. (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 September 12, 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 12th day of SepteimbPr 1996
Lyin D. Allen, County Clerk