HomeMy WebLinkAboutResolutions - 1999.11.18 - 25834MISCELLANEOUS RESOLUTION #99280 November 18, 1999
BY: FINANCE COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FOURTH QUARTER 1999 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 Finance Committee; and
WHEREAS the Department of Information Technology has determined the Fourth
Quarter 1999 data processing development charges to be $575,770 and the imaging
development charge to be $97,506 for the governmental fund County departments;
and
WHEREAS direct charges to non-governmental fund departments are $633,119
and non-county agencies are $56,175 for the Fourth Quarter 1999; 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 1999 Data Processing Development and approves the
fourth quarter appropriation transfer.
Chairperson, on behalf of the Finance Committee, I move the adoption of the
foregoing resolution.
FINANCE COMMITTEE
//24/ZA.42L- 44H?a.
FINANCE COMMITTEE VOTE:
Motion carried unanimously on a roll call vote.
1st Qtr 2nd Qtr
DIVISION Oct: Dec Jan:, Mar
3rd Qtr
Apr: June
4th Ott
July, Sept ACCOUNT* Y.T,D
General Fund 11011
2-32-201200-20001-6030
2-32-301200-20001-6030
2-32-401200-20001-6030
2-32-501200-20001-6030
2-11-220100-10000-6030
2-51-211000-10000-6030
2-31-101200-10001-6030
2-21-230100-01000-6030
2-21-250100-01000-6030
2-21-221000-01000-6030
2-21-240100-01000-6030
2-21-220500-01000-6030
2-19-210000-10000-6030
2-11-250100-20000-6030
2-11-210100-01000-6030
2-19-221000-10000-6030
2-61-211001-10000-6030
2-12-240000-44100-6030
2-12-601200-10001-6030
2-12-621200-10001-6030
2-51-233000-53500-6636
2-16-912000-15000-6030
2-17-501200-10001-6030
2-15-402200-10001-6030
2-34-401200-40001-6030
2-34-101200-40001-6030
2-41-211000-10000-6030
2-12-401200-40010-6030
2-1 3-1 38203-00010-6030
2-12-701200-10001-6030
2-51-231000-53000-6030
243-023310-20021-6030
2-13-138201-00010-6030
2-22-221120-01000-6030
2-17-302200-30001-6030
Friend of the COUrt Fund 1215)
2-12-705212-10001-6030
2-31-201200-10004-6030
Health Fund 12211
2-17-802200-10001-6030
2-18-221112-60000-6030
2-16-201200-10000-6030
2-16-220200-65000-8030
18-636111-10000-0735
2-21-221000-01000-6039
2-31-201200-10004-6039
2-34-101200-40001-6039
18-636111-10000-0573
2-18-101112-10000-6030
2-18-101112-10000-6039
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
4TH QUARTER 1999
52/1 Distnot Court
52/2 District Court
52/3 District Court
52/4 District Court
Auditing
Board of Commissioners - Adm.
Circuit Court - Administration
Clerk - Elections
Clerk - Jury Commission
Clerk - Legal Records
Clerk - Register of Deeds
Clerk - Vital Statistics
Community & Economic Development
Corporation Counsel
County Executive
Development & Planning Division
Drain Commissioner
Equalization Division
Fiscal Services - Admin
Fiscal Services - General
Library Admin
Medical Examiner
M.S.U. Extension - Oakland
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 SupportiReimbursement
Friend of the Court
Sub-Total Fund 215
Animal Control
I.T. - EMS
Health
Health Environmental
Sub-Total Fund 221
DATA PROCESSING DEVELOPMENT FOR
GOVERNMENTAL FUND APPROPRIATION
Clerk
Friend of the Court
Probate
TOTAL IMAGING DEVELOPMENT
APPROPRIATION
Information Technology
Imaging Development
TOTAL GOVERNMENT:
7.680 57 12,087.99 42,384.35 (28,696.40) 33,456.51
7,680 57 12.088.00 42,384 34 (28,696 41) 33.456.50
7,680.57 12,088.00 42,384 34 (28.696.41) 33.456.50
7,680 54 12.088.01 42.384 35 (28.696.42) 33,456.48
47.00 252.00 299.00
0 00
25,049 50 59,768.25 208,363.13 (103,522.38) 189,658.50
34,170 00 11,685.00 11,695.50 9,425.00 66,975.50
3,216.00 6.342.25 9,232.25 9.965.50 28,758.00
4.893.25 16,990.75 22,677.75 11,097.50 55,659.25
1,269.00 2,756.50 6.656.50 24.451.00 35,133.00
1.817.50 1.493.00 1,871 00 84.00 5.265.50
4,819.50 17,789.00 22.608.50
940.00 1,417.00 54.50 172.00 2.583,50
168.00 168.00
479.25 522.00 76,358.00 23,242.00 100,601.25
852.00 232 00 5.981.50 7,065.50
142,390.50 102.552.75 58.775.00 84,929 00 388,647.25
99,178.38 84,974.76 81.928.50 85.846,05 351,927.69
33,673.44 14,375.13 21,133.00 17,109.90 86,291.47
245.25 245.25
17,249.00 41,480.50 43.219.50 33.920.50 135,869.50
564.00 1.813.00 1,090.00 3,467.00
64.157.38 25,807.26 37,749,50 37,530.55 165,244.69
56,553.00 14,805.50 17,307 50 26,407.00 115,073.00
36,377.50 15,652.00 21 714.00 22,218_00 95.961.50
11,902.00 28,518.75 21.315.25 13,461.75 75,197 75
1.692.00 2.180.00 3,162.00 1,117.00 8,151.00
0.00
19,748.00 24.391.00 32,171.00 17,396.00 93,706.00
0.00
7,038 50 7,215.75 26,460.00 73,703.06 114,417.31
684.50 625.50 1,310.00
71,692.10 72,737,00 87,603.50 115,881.00 347. 913.60
355-00 0.00 0,00 272,5_0 627,50
666,026.55 591.334.15 978,051.26 397,238.04 • 2,632.650 00
176,692,00 172,913 25 143.75625 :14,642_50 630,004_00
178,692 00 172,913.25 143,756.25 134,642 50 630.004.00
308 00 84 00 84.00 571.00 1.04700
2,609.25 2,609.25
87,523.50 37.715 00 43,001.00 37,959.00 206,198.50
154.00 10.502_00 10.3.34.013 714,00 21,704,Q0
90.594.75 48,301 00 53,419.00 39,244.00 . 231,558.75
1.3.1.3,50 1.521.0.0 2,546-09 4,64100 a 0,157.513
1,313.50 1.521.00 2.688.00 4,645.00 10,167.50
936.625.80 814,069.40 1,177,914.51 575,169,54' 3,504,390.25
2,666.26 4.301 96 8.764.21 23,714.38 39,446 81
8,672.47 13.292.01 31,441 23 68,940.24 122.345.95
5.727 881,53 2,262,11 415113 8,589_24
11.412,14 18,47_54Q 4Z,485,25 97,50.6,25 17.0,352,00
(936.626 80) (814,069.40) (1,177,914.51) (575,769 54) (3,504,380 25)
(11.912 001 (18.475 50) (42,488 25) (97,506 25) (170.382.00)
$0.00 $0.00 $0.00 ($0.09) $0.00
JuvenileMaintenance_fund_12.63)
2-16-501200-25001 -6030 Children's Village
Sub-Total Fund 293
Prepared by Linda Swartz. Info Tech; 09/30199; 05:33 PM 1 4FY99DEV.VVK4
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
4TH QUARTER 1999
1st Qtr 2nd Qtr 3rd Qtr 4th Qtr
ACCOUNT # DIVISION laCt 7. OK Jan.:Bar Apr,_Juge Juty _aept Y.,IJ1
Community Corrections 273.00 474.50 747,50
Community Development Grant 3,358.75 2,376.00 2,855.50 844.75 9,435,00
Community Mental Health - Admin 13,205.00 8,492.00 4,536.00 8:442.00 34.675.00
Facilities Maintenance & Operations 2,616.25 2,473.00 3,571.50 1,283.75 9,944,50
FOC - Medical Support 1,916.00 721.50 2,637.50
Garage 192.50 192.50
Health Immunization 2,002.00 210.00 714.00 1.764.00 4,690.00
IT - Telephone Communications 381.50 272.50 1,117.00 1,771.00
Materials Management 799.00 109.00 908.00
Medical Care Facility 1.974.00 599.50 7,822.50 3,564.50 13,960.50
Oakland County International Airport 0.00
PA189 Protects 611,274.77 611,274.77
Parks and Recreation - Administration 115.50 1.108.00 2.274,00 485.00 3,982.50
Risk Management 0.00
Water & Sewer Accounting 1,462.50 1,454.25 3,278.50 3...8_68-5.0 10,063.75
100% Tax Payment Fund 12.3(15..00 52.783.09 UK/ 66.0.89-130
18-636111-10000-0715 DIRECT CHARGES FOR DATA $39.94/10 970.707.75 $25.597-50 S5.3.3..118.7Z sztu7t52
PROCESSING DEVELOPMENT
TOTAL DEVELOPMENT CHARGES S988.486.30 993.252.65 $1,246.009.26 $1,306.394.56 S4,644.13377
18-636111-10000-0429 Sidwell 11,585.50 12,896.50 15,744.00 56,175.00 96,401.00
18-636111-10000-0759 Traffic Improvement Association 962,50 0.00 1X00 0.00 962.50
TOTAL NON-COUNTY AGENCIES 12,548,00 12,886.50 15.744,00 58.1/5.00 97,361.5.0
(Information Purposes Only) Information Technology
(Information Purposes Only) In-Car Terminals
783,988.76 653,847.75 803,047.75 593,380.84 2,934,265 10
4,407.00 4,947.50 6,414.00 (2,580.00) 13,088.50
Prepared by Linda Swartz, Info Tech; 09/30/99, 08.33 PM 2 4FY99DEV.WK4
$24.451.00
$9,425.00
$23,714.38
$9,965.50
$11,097.50
$84.00
$172.00
$23,242.00
$5,981.50
$13,023.50
22,076.50
49,.829.00
$28,025.00
24,952.25
32.86830
$348.50
327.00
16_4,34,40
$101.179.50
33,461Q0
$84,929.00
$85,846.05
$17,109.90
$134,642.50
4FY99DEV.WK4
740 EQUALIZATION
660 FISCAL SERVJCESADMIN
31075
95559
95693
44021
44022
96001
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 1999
Cust // GOVERNMENTAL FUNDS
630 ANIMAL_CONTROL
665 CHILDRENS VILLAGE
420 CIRCUIT_COURT
95682 Dog System
Animal Control - Total
95665 Childrens Village
Childrens Village - Total
PA189 IJDS - Ciro Ct 50%
PA189 JIMS - Circ Ct 20%
Cir Court Admin
Assignment Clerk
Circuit Court - Total
$571,00
$571.00
$4,645,00
$4,645.00
($156,352.88)
(211.50)
10,962.75
42,079.25
($103,522.38)
90402
90603
95195
95452
720 CLERKLREGISTER OF_DEEDS
440 CLERK ELECTIONS
722 CLERK.- IMAGING
410 CLERKz_JURY COMMISSION
724 CLERK -..LEGAL RECORDS
723 CLERK ,VITAL_STATISTICS
430 CORPORATION_COUNSEL
775 DEVELOPMENT & PLANNING
730 DRAIN C.QMMISSIONER
95558 User Support/ROD
Clerk/Reg of Deeds - Total
95443 Elections
Elections - Total
65420 Clerk - Image Replace - 21%
95158 Clerk - Imaging
Clerk - Imaging - Total
95512 Jury Commission
Clerk -Jury Commission - Total
90602 PA189 JIMS - Clerk - 20%
95170 Legal Division
95189 Circuit Court System
Clerk - Legal Records - Total
95161 Vital Stets Index
Clerk - Vital Statistics - Total
95501 Corporation Counsel
Corporation Counsel - Total
95600 Cust/System Support
95608 D&P - Data Warehousing
Development & Planning - Total
28009 Drain - Administration
74505 Drain - Ops & Maint
Drain Commissioner - Total
$24,451.00
$%425.00
$23.672.38
42.00
$9,965.50
($211.50)
4,680.00
6,629,00
$84,00
$172.00
$675.00
22167,00
$54.50
5,927.0
Equal - Development
User Support/Equal
Equal-System Maintenance
Equalization - Total
FS-System/Customer Support
FS-System Maintenance
Human Res - Acctg
Fiscal Services Admin - Total
44076 BUD-System/Customer Support
44077 BUD-System Maintenance
96003 Human Resources - Budget
Fiscal Services - General - Total
34041 Fnend of the Court
34046 FOC - Professional Services
Friend of the Court - Total
Prepared by Linda Swartz Info Tech; 09/30/99, 08.35 PM 1
670 FISCAL SERVICES - GENERAL
470 FRIEND OF THE COURT
95556
95560
96002
90604
95200
95202
95203
$75.50
6&864.74
$15.368.00
872.00
21,719.00
$714.00
$245.25
$33,920.50
$1,090,00
$4,334.75
327.00
32,868.80
($211.50)
3,308.50
16,968.00
6,342.00
$4..851_63
$22,2.1100
$504.00
613.00
$1739_6.00
$18,629.56
55,0750
$68.940.24
$37.959.00
$714.00
$245.25
$33.920.50
$1.090.00
$37.530.55
$26,407.00
$4,851.63
$22.218.00
$1,117.00
$17.396.00
$73.703.06
($211.50)
$13,673,25
$13,461.75
843 HEALTH..t_EN_VIRONMENTAL
907 LIBRARY ADMIN
872 MEDICALEXAMINER
710 M.S,U—EXTENSION
680 PERSONNEL
480 PROBATE.CQURT
482 PROBATEAMAGIN_G
481 PROBATE—m.JUVENILE
145 PROSECUTOR
690 PURCHASING
650 REIMB_URSEMENI
195 SHERIFF
600 TREASURER
910 VETERANS SERVICES
$46,945.00
327.00
436.00
55,515.50
924.00
11.733.50
$115,881.00
$272.50(
4FY99DEV.VVK4
$272.50
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 1999
471 FRIEND.OF_THE_CtIMAGING
840 HEALTH DEPARTMENT
34042 FOC Develop Image
65410 FOC-Image Replace-74%
FOC Develop Image - Total
CHAMPS - P.O.P.
Health South PC Net
Health - Admin
Health - Total
37002 Environmental
Health-Environmental - Total
91405 Library Board
Library Admin - Total
87202 Med Exam - Cust Support
Medical Examiner - Total
95676 MSU Ext Equipment Maintenance
MSU Extension - Total
Personnel User Supt
Personnel - Employee
Human Res. - Personnel
Personnel - Total
PA189 JIMS - Probate - 20%
Probate - Admin
Probate - Estates
Probate - Field Services
Probate - Total
48200 Probate - Imaging
Probate - Imaging - Total
95191 Probate Crt Juv Div
Probate Juvenile - Total
90605 PA189 JIMS - Prosecutor - 20%
95622 Prosecutor/Executive
Prosecutor - Total
44026 PUR-System/Customer Support
44027 PUR-System Maintenance
Purchasing - Total
95470 Reimbursement System
Reimbursement - Total
97163 Sheriff
97164 Sheriff Development
Sheriff - Total
37025
96841
96842
Ire-Data Warehousing
Tre-System/Customer Support
Tre-System Maintenance
Del Tax System Maintenance
DTX - Enhance/Development
User Support/Del Tax
Treasurer - Total
95651 Veterans Cust Support
Veterans - Total
Prepared by: Linda Swartz, Info Tech: 09/30/39; 08:35 PM 2
44012
44061
44062
95303
95313
95561
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 1999
540 5211 DISTRICT. COURT -_NOVI 90403 PA189 IJDS - 52/1 DC- 12.5% ($39,088.21)
90606 PA189 MS - 52/1 DC - 5% (52.88)
95527 DC Suprt -25%-52/1 10,444,69
52/1 District Court - Total ($28,696.40)
550 52/2 DISTRICT COURT - CLARKSTON 90404 PA189 IJDS - 52/2 DC - 12.5% ($39.088,22)
90607 PA189 JIMS - 52/2 DC - 5% (52.88)
95528 DC Suprt -25%-52/2 10,444.69
52/2 District Court - Total ($28,696.41)
560 52/3 DISTRICT COURT-ROCHEST.ER 90405 PA189 IJDS - 52/3 DC - 12.5% ($39,088.22)
90608 PA189 JIMS - 52/3 DC - 5% (52.88)
95529 DC Suprt -25%-52/3 10,444.69
5213 District Court - Total ($28,696.41)
530 5214_DISTRICT COURT -..TROY 90406 PA189 IJDS - 52/4 DC - 12.5% ($39.088.22)
90609 PA189 JIMS - 52/4 DC - 5% (52.88)
95530 DC Suprt -25%-52/4 10,44448
52/4 District Court - Total ($28,696.42)
Cust # DIRECTFUNDS
663 CMH - ADMIN 66306 CMH System Development $8,442,00
CMH Admin - Total $8,442.00
657 COMMUNITY CORRECTIONS 55701 Community Corrections Grant $4Z4.50
Community Corrections - Total $474,50
661 commuNirt DEVELOPMENT 66103 Community Development $844..75
Community Development - Total $844.75
750 FAC MAINT & OPERATIONS 75503 FM0 Development $1.283.Z5
FM&O - Total $1.283,75
380 HEALTH IMMUNIZATION__-_GRANT 38000 Health - Immunization $1104.00
Health - Immunization - Total $1,764.00
010 INFORMATION TECHNOLOQY
Systems Develop/Support 02000 Year 2000 Project 159,442.25
22000 Enhanced Access Project 490.50
25100 GIS - Administration 3,612.00
25200 Open Systems Administration 2,779.50
25400 Oracle Administration 182,536.00
30001 IT DISC Data Warehouse 115,653.25
30003 IT DISC GIS 36,297.50
31008 Dev Billed to Private Sector 109.00
84200 Health Grant Overhead 19,205.16
91515 System Support - Health Plus 125,955.84
95150 IT - New Operating System 163.50
95456 Equipment Inventory 5,900.50
95685 I.T. - Disaster Recovery 2,98644
Technical Sys/Networking 95689 Database Tech Support 538,249.00
004 PA189 PROJECTS 1st, 2nd, 3rd Qtr Adjustments $313,763.27
90402 PA189 IJDS Ciro Ct - 50% 147,970.75
90403 PA189 IJDS 5211 DC - 12.5% 36,992.69
$655,131.84
$38,249.00
575 I.T. - TELEPHONE COMMUNICA_TIONS 21012 I.T. - Communications
I.T. - Communications - Total $1,117.00
870 MEDICAL.CARE_FACILITY 98873 MCF - Support $3,564.50
MCF - Support - Total $3,564.50
Prepared by Linda Swartz, Info Tech: 09130/99. 08.35 PM 3 4FY99DEV.WK4
36.992.69
36,992.69
36,992.68
392.50
392.50
392.50
98.13
98.13
98.13
98.11
$611,274.77
$485.00
$3,868.50
$56,175.00
56,175.00
$485.00
$3,868.50
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 1999
770 PARKS AND_ RECREATION
656 WATERILSEVVER ACCIG
NoN,couNry AGENCIES
PA189 IJDS 52/2 DC - 12.5%
PA189 IJDS 52/3 DC - 12.5%
PA189 IJDS 52/4 DC - 12.5%
PA189 JIMS Circ Ct - 25%
PA189 JIMS Probate - 25%
PA189 JIMS Prosecutor - 25%
PA189 JIMS 52/1 DC - .0625%
PA189 JIMS 52/2 DC - .0625%
PA189 JIMS 52/3 DC - .0625%
PA189 JIMS 52/4 DC - .0625%
PA189 Projects - Total
95419 PRADM-Administration
Parks & Recreation - Total
95669 Water & Sewer Acct'g
Water & Sewer Accrg - Total
Federal District Court
Sidwell
T.I.A.
90404
90405
90406
90603
90604
90605
90606
90607
90608
90609
Prepared by: Linda Swartz. Info Tech- 09/30/99; 08:35 PM 4 4r(99DEV.W
Resolution #99280 November 18, 1999
Moved by Douglas supported by Suarez the resolution be adopted.
AYES: Galloway, Garfield, Gregory, Jensen, Law, McCulloch, Melton, Millard,
Moffitt, Obrecht, Palmer, Patterson, Schmid, Sever, Suarez, Taub, Amos, Appel,
Causey-Mitchell, Colasanti, Devine, Dingeldey, Douglas. (23)
NAYS: None. (0)
A sufficient majority having voted therefor, the resolution was adopted.
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 18, 1999 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 18th day jef November, 1999.
GT William Caddell, County Clerk