HomeMy WebLinkAboutResolutions - 2003.10.29 - 27319MISCELLANEOUS RESOLUTION #03293 October 16, 2003
BY: GENERAL GOVERNMENT COMMITTEE, WILLIAM PATTERSON, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FOURTH QUARTER 2003
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 non-departmental 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 2003 data processing development charges to be
$1,174,100.56 and the imaging development charge to be $84,509.00 for
the General Fund/General Purpose County departments; and
WHEREAS direct charges to Special Revenue and Proprietary fund
departments are $112,630.90 and non-county agencies are $0 for the
Fourth Quarter 2003; and
WHEREAS an appropriation transfer to General Fund/General Purpose
County departments is needed to fund these development charges; and
NOW THEREFORE BE IT RESOLVED that the Oakland County Board of
Commissioners has reviewed the Fourth Quarter 2003 Data Processing
Development Report and approves the Fourth Quarter appropriation
transfer as specified on the attached schedule.
Chairperson, on behalf of the General Government Committee, I move the
adoption of the foregoing resolution.
GENERAL GOVERNMENT COMMITTEE
General Government Committee Vote:
Motion carried unanimously on a roll call vote.
30001 IT Disc Data Warehouse
30002 IT DISC Enhanced Access
30003 IT DISC GIS
30004 IT DISC E-Government
91511 System Support - DISC
95742 IT - FEMA Grant
DISC - Sub-Total:
91510 System Support - DISC
91516 CVT - New Development
95456 Equipment Inventory
Sys Dev Support - Sub Total:
25200 Open Systems Administration
25400 Oracle Administration
95685 I.T. - Disaster Recovery
95689 Database Tech Support
Tech Sys/Net - Sub-Total:
Digital Information Service Center
Systems Develop/Support
Technical Sys/Networking
INFORMATION TECHNOLGY
DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2003
Information Technology - Total:
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter II Y.T.D.
$27,978.00 $29,055.00 $15,184.00 $13,146.50 $85,363.50
7,244.50 0.00 $0.00 $0.00 7,244.50
99,401.58 84,870.00 $72,908.50 $130,822.00 388,002.08
45,500.50 101,352.00 $326,844.50 $264,326.00 738,023.00
0.00 57,507.50 $23,951.50 $0.00 81,459.00
0.00 0.00 0.00 0.00 0.00
$180,124.58 $272,784.50 $414,937.00 $408,294.50 $1,276,140.58
0.00 56,172.50 51,412.00 6,886.00 114,470.50
6,161.00 0.00 0.00 0.00 6,161.00
756.00 1,068.00 1,134.00 540.00 3,498.00
$6,917.00 $57,240.50 $52,546.00 $7,426.00 $124,129.50
$0.00 $0.00 $0.00 $0.00 $0.00
41,602.00 46,421.00 $38,491 00 $21,106.00 147,620.00
0.00 643.00 8,967.00 28,748.00 38,358.00
124,989.00 138 592 00 132,187.00 114,985.00 510,753.00
$166,591.00 $185,656.00 $179,645.00 $164,839.00 $696,731.00
$353,632.58 $515,681.00 $647,128.00 $580,559.50 $2,097,001.08
Prepared by; Information Technology; 10/6/03 03oct064thQtr2003.xls
DIVISION ACCOUNT a
GOVERNMENTAL FUNDS
General Fund 11011
101 2-32-201200-20001-6030
101 2-32-301200-20001-6030
101 2-32-401200-20001-6030
101 2-32-501200-20001-6030
101 2-17-802200-80001-6030
101 2-11-220100-10000-6030
101 2-51-211000-10000-6030
101 2-21-230100-31000-6030
101 2-21-250100-01000-6030
101 2-21-221000-01000-6030
101 2-21-240100-11000-6030
101 2-21-220500-40000-6030
101 2-19-210000-10000-6030
101 2-17-402200-70001-6030
101 2-11-250100-20000-6030
101 2-35-220000-12000-6030
101 2-35-244000-31100-6030
101 2-35-244000-33000-6030
101 2-35-242000-11000-6030
101 2-35-242000-44000-6030
101 2-35-242000-41000-6030
101 2-35-242000-43000-6030
101 2-35-243000-11000-6030
101 2-35-230000-22100-6030
101 2-35-230000-31200-6030
101 2-35-230000-21200-6030
101 2-35-230000-22200-6030
101 2-35-210000-11000-6030
101 2-61-211001-10000-6030
101 2-11-101112-65001-6030
101 2-12-240000-41000-6030
101 2-12-601200-10001-6030
101 2-12-621200-10001-6030
101 2-51-233000-53500-6030
101 2-13-138502-15100-6030
101 2-17-912000-15000-6030
101 2-17-501200-50001-6030
101 2-15-402200-10001-6030
101 2-19-221000-10000-6030
101 2-34-403200-40001-6030
101 2-34-101200-40001-6030
101 2-34-403200-40005-6030
101 2-34-101200-31100-6030
101 2-34-101200-31200-6030
101 2-41-211000-41100-6030
101 2-41-211000-41700-6030
101 2-12-401200-40010-6030
101 2-13-138203-00010-6030
101 2-12-701200-34000-6030
101 2-43-023301-20000-6030
101 2-43-023601-30000-6030
101 2-13-138201-15100-6030
101 2-22-221120-01000-6030
101 2-17-302200-30001-6030
Health Fund 12211
221 2-16-201200-33100-6030
221 2-16-234200-54600-6030
221 2-16-220200-67000-6030
Children's Village
Sub-Total Fund 293
juvenile Maintenance Fund 12931
293 2-16-501200-25001-6030
12931
2443Q $230.00 $264.00 $1.C2M $804.00
$244.00 $230.00 $264.00 $66.00 $804.00
INFORMATION TECi4NOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
4TH QUARTER 2003 .
151 Qtr
S2az.122G
2nd Otr 3rd Qtr 4th Qtr
Mar Apr - June July - Sept
52/1 • District Court
52/2 - District Court
52/3 - District Court
52/4 - District Court
Animal Control
Auditing
Board of Commissioners
Clerk - Elections
Clerk - Jury Commission
Clerk - Legal Records
Clerk - Register of Deeds
Clerk - Vital Statistics
Community & Economic Development
Community Corrections Admin
Corporation Counsel
Courts-Business Division - J1MS
Courts-FD - Judicial
Courts-FD Juvenile Support
Courts-FD-Court Services-Admin
Courts-FD-Court Services-Adoptions
Courts-FD-Court Services-Casework
Courts-FD-Court Services-Youth Assistance
Courts-FD-Judicial Support-Admin
Courts-GJ-Assignment
Courts-GJ-Family Support
Courts-GJ-Judicial Support
Courts-GJ-Mediation
Courts-Judicial Administration
Drain Commissioner
Emergency Response & Prep Unit
Equalization Division
Fiscal Services - Admin
Fiscal Services - General
Library - Admin
Materials Management - Gen Fund
Medical Examiner
MSU Extension - Oakland
Personnel
Planning and Economic Development
Probate - Estates/Mental Health Admin
Probate - Judicial Admin
Probate-Estates/Mental Health Support
Probate-FD-Judicial
Probate-FD-Judicial Support
Prosecuting Attorney - Administration
Prosecuting Attorney - General Prosecution
Purchasing
Records Retention
Reimbursement Division
Sheriff
Sheriff - CLEM1S
Support Services
Treasurer
Veterans
Sub-Total Fund 101
Health
Health - Clinic
Health Environmental
Sub-Total Fund 221
$9,733.88 $3,257.46 $12,438.72 $14,424.70 $39,854.76
$9,733.88 $3,257.46 $12,438.72 $14,424.70 $39,854.76
$9,733.89 $3,257.46 $12,438.72 $14,424.70 $39,854.77
$9,733.87 $3,257.35 $12,438.70 $14,424.65 $39,854.57
$1,242.00 $432.00 $1,998.00 $1,134.00 $4,806.00
$610.00 $767.50 $61.00 $216.00 $1,654.50
$0.00 $0.00 $0.00 $0.00 $0.00
$70,267.50 $1,920.00 $15,960.00 $5,673.00 $93,820.50
$5,906.00 $9,428.40 $11,220.00 $7,077.40 $33,631.80
$8,496.80 $3,914.00 $21,756.50 $26,190.00 $60,357.30
$12,379.90 $11,933.00 $5,063.00 $6,686.00 $36,061.90
$23,315.50 ($13,258.00) $6,716.00 $20,015.00 $36,788.50
$11,588.00 $3,332.00 $1,281.00 $2,309.50 $18,510.50
$46,67300 $21,393.00 $13,465.00 $18,653.50 $100,184.50
$122.00 $0.00 $9,577.00 ($9,699.00) $0.00
$10,246.25 $9,514.27 $6,935.88 $12,760.77 $39,457.17
$220.60 $0.00 $0.00 $0.00 $220.80
$366.00 $27.00 $488.00 $1,159.00 $2,040.00
$0.00 $244.00 $122.00 $1,094.00 $1,460.00
$2,210.00 $6,356.00 $4,860.00 $8,329.00 $21,755.00
$0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $324.00 $0.00 $324.00
$324.00 $709.00 $1,573.00 $3,181.00 $5,787.00
$1,518.00 $1,685.50 $7,609.00 $16,314.60 $27,127.10
$33,729.00 $14,982.00 $0.00 $0.00 $48,711.00
$11,866.00 $13,833.50 $26,290.00 $33,290.10 $85,279.60
$844.00 $1,827.00 $17,268.50 $10,486.50 $30,426.00
$932.00 $1,398.00 $2,025.00 $2,023.00 $6,378.00
$43,636.00 $39,389.00 $32,667.50 $33,898.00 $149,590.50
$5,438.50 $4,205.00 $8,545.00 $10,668.50 $28,857.00
$321,909.50 $229,428.50 $280,419.00 $213,812.50 $1,045,569.50
$300,168.10 $253,199.14 $222,325.92 $218,508.20 $994,201.36
$0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00
$11,681.50 $0.00 $183.00 $5,575.00 $17,439.50
$8,262.00 $8,250.00 $8,024.40 $3,213.00 $27,749.40
$756.00 ($756.00) $0.00 $0.00 $0.00
$161,750.90 $130,415.66 $45,555.58 $56,458.20 $394,180.34
$0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00
$7,625.00 $1,113.27 $6,935.88 $12,760.77 $28,434.92
$48.00 $0.00 $61.00 $427.00 $536.00
$9,436.80 $10,752.00 $14,058.00 $3,031.00 $37,277.80
$122.00 $366.00 $0.00 $54.00 $542.00
$0.00 $0.00 $0.00 $0.00 $0.00
$14,759.00 $14,566.77 $49,945.38 $37,639.17 $116,910.32
$10,086.50 $1,566.00 $3,024.00 $8,100.00 $22,776.50
$0.00 $1,037.00 $0.00 $0.00 $1,037.00
$17,867.40 $8,080.00 $9,410.60 $8,372.60 $43,730.60
$16,168.50 $51,646.50 $62,691.50 $85,899.50 $216,406.00
$32,208.00 $31,415.00 $31,049.00 $36,966.00 $131,638.00
$3,138.00 $7,462.00 $6,710.00 $6,933.00 $24,243.00
$110,87430 $85,322.50 $104,114.00 $75,759.00 $376,069.50
ELQS2 $0.00 1122 10.QQ $0.00
$1,357,727.97 $980,926.24 $1,090,067.50 $1,042,667.56 $4,471,389.27
$12,991.00 $50,006.00 $73,595.50 $125,697.00 $262,289.50
$0.00 $0.00 $0.00 $0.00 $0.00
.$76.577.50 $51.795.00 $16,993.00 $5.670.00 $151335.5Q
$89,568.50 $101,801.00 $90,588.50 $131,367.00 $413,325.00
18-636111-10000-0735
IMAGING
2-21-221000-01000-6039
2-35-243000-33000-6039
2-34-403200-40005-6039
DATA PROCESSING DEVELOPMENT FOR
GOVERNMENTAL FUND APPROPRIATION
Clerk Image
Courts-FD-Juv-Sup-Imeging
Probate-Estates/Mental Health Image
$1 .447.540.47 $1.082.957.24 §1 .160.920.00 $1 .174.100.56 54.885.518.27
$77,976.00 $63,583.00 $83,466.00 $81,67930 $306,704.00
$0.00 $0.00 $0.00 $0.00 $0.00
$2376.00 $2.640.00 54.945.00 $2.830.00 $12391.00
580.352,00 $66.223.00 588.411.00 $84.509.00 $319,495.00 TOTAL IMAGING DEVELOPMENT
APPROPRIATION
SUB-TOTAL GOVERNMENTAL / IMAGING DEVELOPMENT APPROPRIATION: $1,527,892A7 $1,149,180.24 $1,269,331.00 $1,258,609.56 $5,205,013.27
90-290000-25000-6030 Information Technology Development 151 .527.892.471 ($1.149.180.241 M1269331.001 1$1258.609.561 155205.013.271
TOTAL GOVERNMENT: /0_&12 $0.00 ARQ 141Q Q&Q
18-636111-10000-0573
Prepared by; Information Technology; 9/16/03 4th Qtr 2003.xls
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
4TH QUARTER 2003 .
let Qtr 2nd Oh 3rd Qtr 4th Otr
ACCOUNT *I DIVISION Oct - Dec Jan - Mar Apr - Jun@ Jul,/ - Sept
NON-GOVERNMENTAL
DIRECT CHARGES
Y.T.D.
18-636111-10000-0715
CLEMIS • $0.00 $5,718.00 $23,629.40 $17,838.90 $47,186.30
Community Corrections $0.00 $0.00 $10,000.00 $0.00 $10,000.00
Courts-FOC-Exp-CS Enforcement $0.00 $0.00 $0.00 $0.00 $0.00
Courts-FOC Exp-CS Enforcement Image $9,793.00 $11,343.00 $8,454.00 $7,121.00 $36,711.03
Courts-FOC Exp-Family Counseling $54.00 $702.00 $0.00 $162.00 $918.00
Courts-FOC Exp-CS Enforcement Image $0.00 $1,627.00 $0.00 $780.00 $2,407.00
Fire Records Management System $23,976.00 $12,528.00 $17,226.00 $3,078.00 $56,808.00
FM-Wk Rel/Jall Mgt/Vido Conf $7,808.00 $12,156.00 $32,940.00 $54,059.00 $106,963.00
F M & 0 $2,257.00 $3,477.00 $3,233.00 $2,928.00 $11,895.130
Health - Immunization Grant $594.00 $432.00 $1,782.00 $972.00 $3,780.00
IT - FEMA Grant $0.00 $0.00 $0.00 $0.00 $0.00
IT Tele Comm - Customer Support $0.00 $0.00 $11,468.00 $0.00 . $11,468.00
Materials Management $0.00 $0.00 $0.00 $0.00 $0.00
Medical Care Facility $676.00 $2,462.00 $9,246.00 $7,148.00 $19,532.00
O.C. International Airport $0.00 $0.00 $0.00 $488.00 $488.00
Parks and Recreation - Administration $514.00 $743.00 $497.00 $0.00 $1,754.00
Risk Management $23,028.00 $14,056.00 $9,699.00 $10,309.00 $57,092.00
Treasurer - 100% Tax Payment Fund $0.00 $0.00 $0.00 $0.00 $0.00
Treasurers Delinquent Tax Revolving Fund $0.00 $0.00 $0.00 $0.00 $0.00
Water & Sewer Accounting $34,875.00 $10,858.00 $17,860.00 $7,747.00 $71,340.00
Workforce Development 2.9_,X $0.00 ELM 1.Q...QQ ISIQ
SUB-TOTAL DIRECT CHARGES FOR DATA $103.675.00 $76,102.00 5146.034.40 $112.630.90 5438.342.30
PROCESSING DEVELOPMENT
TOTAL COUNTY DEVELOPMENT CHARGES $1,631.467.47 $1 225282.24 $1 ,415.365.40 51.371.240.44 55.643.355.57
NON-COUNTY AGENCIES
18-636111-10000-0429 Non-County Agencies Q.QQ $0.00 1.144 141124 14,a4
TOTAL DEVELOPMENT CHARGES $1,631,467.47 $1,225,282.24 $1,415,365.40 $1,371,240.46 $6,643,355.57
'1st quarter CLEMIS charge ($2,928) billed 2nd quarter 2003.
Prepared by; Information Technology; 9/16103 4th Qtr 2003.xls
$2,309.50
($9,699.00)
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2003
Cust # GOVERNMENTAL FUNDS
630 ANIMAL CONTROL
620 AUDITING
665 CHILDRENS VILLAGE
440 CLERK - ELECTIONS
720 CLERK! REGISTER OF DEEDS
722 CLERK - IMAGING
410 CLERK - JURY COMMISSION
724 CLERK -LEGAL RECORDS
723 CLERK - VITAL STATISTICS
522 COMMUNITY CORRECTIONS-ADMIN (COI
785 COMMUNITY & ECO DEVELOPMENT
430 CORPORATION COUNSEL
495 CTS-BUSINESS DIV - JIMS
487 CTS-FD-CT SERV-ADMIN
492 CTS-FD-CT SERV-ADOPTIONS
491 CTS-FD-CT SERV-YOUTH ASSISTANCE
483 CTS-FD-JUDICIAL SUPPORT-ADM
474 CTS-FD-JUVENILE SUPPORT
95682 Dog System
Animal Control-Total
95468 Auditing-Cust Supt
Auditing - Total
95665 Childrens Village
Childrens Village - Total
95443 Elections
Clerk -Elections - Total
36510 GIS Implementation Support-ROD
95493 Reg Deeds System Maintenance
95498 Clerk/Reg of Deeds
95558 User Support/ROD
Clerk/Reg of Deeds - Total
Clerk - Image Replace - 21%
Clerk - Imaging
Clerk - Imaging - Total
95512 Jury Commission
Clerk -Jury Commission - Total
95189 Circuit Court System
Clerk - Legal Records - Total
95161 Vital Stats Index
Clerk - Vital Statistics - Total
52200 Comm Corr-Admin (County)
Community Corrections - Total
36500 GIS Implementation Support C&E Dev
95785 Comm & Eco Developmt
Community & Eco Dev - Total
95501 Corporation Counsel
Corporation Counsel - Total
90603 JIMS - Circuit Court - 25%
95176 CTS-Business Div - JIMS
CTS-Business Div - JIMS - Total
95196 CTS-CT Serv - Admin
CTS-CT Serv - Admin - Total
CTS-FD-Ct Serv-Adoptions
CTS-FD-Ct Serv-Adoptions - Total
CTS-FD-Ct Serv-Youth Assistance
CTS-FD-Ct Serv-Assistance - Total
CTS-FD-Judicial Suport-Adm
CTS-FD-Judicial Suport-Adm - Total
CTS-FD-Admin-Juvenile Support
CTS-FD-Juvenile Support - Total
$1.134.00
$216.0Q
$66.00
$5,673.00
$0.00
5,100.00
0.00
1.586,00
$9,122.00
72,557.00
$7,077.40
26.190.00
$20.015.00
$18.653.50
$854.00
1.455.50
1$9.699.00)
$12,760.77
0.00
$1.094.00
$8.329.00
$0.00
$3.181.00
$1,159.00
65420
95158
95173
95172
95193
95474
$1,134.00
$216.00
$66.00
$5,673.00
$6,686.00
$81,679.00
$7,077.40
$26,190.00
$20,015.00
$18,653.50
$12,760.77
$1,094.00
$8,329.00
$0.00
$3,181.00
$1,159.00
Prepared by; Information Technology; 9/16/03 4th Qtr 2003.xls
$24,943.00
305.00
37,270.50
151.294,0Q
$213,812.50
$17,353.50
116,720.50
0.00
23,326.00
0.00
0.00
0.00
0.00
40,738.80
20.369.40
$218,508.20
$10,476.50
$0.00
5,242.90
40.738.8Q
$56,458.20
36525 GIS Implementation Support Health
37025 CHAMPS - P.O.P.
96842 Health Admin
Health - Total
$1,061.00
15,930.00
108.706.00
$125,697.00
$5,670.00
37002 Environmental $2,970.00
84200 EH - Projects 2,700.00
84300 Ehealth Program 0.00
Health-Environmental - Total
95440 Materials Management $5,575.00
95704 Performance Series - 25% _Q
Materials Mgmt-Gen Fund - Total $5,575.00
87202 Med Exam - Gust Support $3.213.00
Medical Examiner - Total 63,213.00
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - FOURTH QUARTER, 2003
499 CTS-GJ-ASSIGNMENT 95180 CTS-GJ-Assignment $16.314.60
CTS-GJ-Assignment - Total
498 CTS-GEN JURIS-JUDICIAL SUPPT 95179 CTS -Gen Juris-Judicial Suppt $33.290.10
CTS -Gen Juris-Judicial Suppt - Total
500 CTS-GJ-MEDIATION 95181 CTS-GJ-Mediation $10.486,5Q
CTS-GJ-Mediation - Total
493 CTS-JUDICIAL ADMIN 95174 CTS-Judicial Admin $2.023.00
CTS-Judicial Admin - Total
730 DRAIN COMMISSIONER 28007 Drain Commissioner $1,188.00
28009 Drain - Administration $366.00
28011 Drain Commissioner Application 0.00
36520 GIS Implementation Support Drain 32,344.00
95669 Water & Sewer Accounting QQQ
Drain Commissioner - Total
$16,314.60
$33,290.10
$10,486.50
$2,023.00
$33,898.00
900 EMERGENCY RESPONSE & PREPAREDNESS 36545 GIS Implementation Support EMS $10.668.50
ERP - Total $10,668.50
740 EQUALIZATION
660 FISCAL SERVICES ADMIN
840 HEALTH DEPARTMENT
843 HEALTH - ENVIRONMENTAL
641 MATERIALS MGMT-GEN SUPPORT SERV
872 MEDICAL EXAMINER
680 PERSONNEL
31075 Equal - Development
36505 GIS Implementation Support Equalization
95559 User Support/Equal
95693 Equal-System Maintenance
Equalization - Total
44021 FS-System/Customer Support
44022 FS-System Maintenance
44023 FS-System Enhancements
44024 FS-New Development
44076 BUD-System/Customer Support
44077 BUD-System Maintenance
95702 Pert Series - Fiscal Services 25%
95703 Pert Series - Budget 25%
96001 Human Res-Acct 40%
96003 Human Res.-Budget 20%
Fiscal Services Admin - Total
44043 PER-System Enhancement
44044 PER-New Development
95556 Personnel User Supt
96002 Human Res-Personnel 40%
Personnel - Total
Prepared by: Information Technology: 9/16/03 4th Qtr 2003.xls
$2,830.00
$12.760.77
$427.00
$3.031.00
$54.00
$2,830.00
$12,760.77
$427.00
$3,031.00
$54.00
690 PURCHASING 44026 PUR-System/Customer Support
44027 PUR-System Maintenance
95701 Performance Series 25%
Purchasing - Total
$0.00
$8,100.00
$0.00
$8,100.00
540 52/1 DISTRICT COURT - NOVI
550 5212 DISTRICT COURT - CLARKSTON
560 52/3 DISTRICT COURT - ROCHESTER
530 52/4 DISTRICT COURT - TROY
$3,190.19
11.234.51
$14,424.70
$3,190.19
11.234.51
$14,424.70
$3,190.19
11.234.51
$14,424.70
$3,190.16
11.234.49
$14,424.65
90606 JIMS - 52/1 DC - 6.25%
95527 DC Suprt-25%-5211
52/1 District Court - Total
90607 JIMS - 52/2 DC - 6.25%
95528 DC Suprt-25%-52/2
52/2 District Court - Total
90608 JIMS - 52/3 DC - 6.25%
95529 DC Suprt-25%-52/3
52/3 District Court - Total
90609 JIMS - 52/4 DC - 6.25%
95530 DC Suprt-25%-52/4
52/4 District Court - Total
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - FOURTH QUARTER, 2003
512 PROB-ESTATES/MENTL HLTH IMAGE
509 PROB-JUDICIAL, ADMIN
510 PROB-ESTATES/MENTL HLTH SUPPORT
481 PROBATE-FD JUDICIAL
479 PROB-FD-JUDICIAL SUPPORT
145 PROSECUTOR - GENERAL PROSECUTION
95207 Prob-Est/Mntl Hlth Image
Prob-Est/Mntl Hlth Image - Total
90604 JIMS Probate 25%
Prob-Judicial Admin - Total
92198 Prob-Est/Mntl Hlth Support
Prob-Est/Mntl Hlth Support - Total
95168 Prob-FD Judicial
Prob-FD Judicial - Total
95188 PROB-FD Judicial Support
PROB-FD Judicial Support - Total
90605 JIMS - Prosecutor 25% $12,760.77
95622 Prosecutor/Executive 24,682.40
97001 Prosecutor Data Proc 196.00
Prosecutor - Total $37,639.17
650 REIMBURSEMENT 95470 Reimbursement System $2,158.00
95542 Reimburse User Support 6.214.60
Reimbursement - Total $8,372.60
195 SHERIFF 97163 Sheriff 66,820.00
97164 Sheriff - Development 19,079.50
Sheriff - Total $85,899.50
191 SHERIFF - CLEMIS 96163 Sheriff - CLEMIS 36.966.00
Sheriff - CLEMIS - Total $36,966.00
445 SUPPORT SERVICES 44500 Support Services $6.933.00
Support Services - Total $6,933.00
600 TREASURER 36515 GIS Implementation Support-Treasurer 488.00
44061 Tre-System/Customer Support 1,347.00
44062 Tre-System Maintenance 432.00
44063 Tre-System Enhancement 8,092.00
44064 Tre-New Development 1,708.00
95008 Del Tax On Line 7,747.00
95303 Del Tax System Maintenance 45,592.00
95561 User Support/Del Tax 10.353.00
Treasurer - Total $75,759.00
Prepared by; Information Technology: 9/16/03 4th Qtr 2003.xls
Gust # DIRECT FUNDS
055 CLEMIS 95407 CLEMIS RMS Modifications $715.00
95430 CLEMIS System Maintenance $15,080.40
98003 CLEMIS Customer Support $2.043.50
CLEMIS - Total
521 COMMUNITY CORRECTIONS-ADMIN (GRANT) 52200 Comm Corr-Admin (Grant) $0.00
Community Corrections - Total
470 CTS-FOC-EXP-FAM COUNSELING 92195 CTS-FOC-Exp-Fam Counseling $162.00
CTS-FOC-Exp-Fam Counseling - Total
471 CTS-FOC-EXP-CS ENFORC-IMAGE 92194 CTS-FOC-Exp-CS Ent-Image $7,121.00
CTS-FOC Exp-CS Ent-Image - Total
507 CTS-FOC EXP-CS ENFORCEMENT 92193 CTS-FOC Exp-CD Enforc-Dev $780.00
CTS-FOC Exp-CD Enforc-Dev - Total
210 FIRE RECORDS MANAGEMENT SYSTEM 95404 FRMS - Phase II Projects $3.078.00
Fire Records Mgmt - Total
750 FM&O 21001 FM&O $2,928.00
FM&O - Total
757 FM-WK RELEASE/JAIL MGMTNIDEO CONF 75700 Fac Mgmt - Video Arraignments $54.059,00
FM-Wk ReVJail MgmtNideo Cont - Total
380 HEALTH IMMUNIZATION -GRANT 38000 Health - Immunization $972.00
Health - Immunization - Total
751 IT. TELEPHONE COMMUNICATIONS 75102 Tel Comm - Customer Support 0.00
Tel Comm - Total
$17,838.90
$0.00
$162.00
$7,121.00
$780.00
$3,078.00
2,928.00
$54,059.00
$972.00
$0.00
$0.00
0.00
$10,309.00
$0.00
$549.00
7,198.00
$0.00
$10,309.00
$7,747.00
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - FOURTH QUARTER, 2003
870 MEDICAL CARE FACILITY
653 O.C. INTN'L AIRPORT
770 PARKS AND RECREATION
695 RISK MANAGEMENT
656 WATER & SEWER ACCTG
98873 MCF - Support $7.148.00
MCF - Support - Total
65301 Airport User Support $488.00
Airport User Support-Total
36530 GIS Implementation Support Parks Dept
95419 PRADM-Administration
Parks & Recreation - Total
44036 ASK-System/Customer Support
95695 Risk Management
Risk Management - Total
44049 WS-New Development
95669 Water & Sewer Acct'g
Water & Sewer Acct'g - Total
$7,148.00
$488.00
Prepared by; Information Technology; 9/16/03 4th Qtr 2003.xls
FISCAL NOTE (MISC. #03293) October 30, 2003
BY: FINANCE COMMITTEE, CHUCK MOSS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FOURTH QUARTER 2003
DEVELOPMENT APPROPRIATION TRANSFER
TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS
Chairperson, Ladies and Gentlemen:
Pursuant to Rule XII-C of this Board, the Finance Committee has
reviewed the above-referenced resolution and finds:
1. The resolution appropriates and charges the Information
Technology Fourth Quarter 2003 Development cost to benefiting
departments.
2. The Fourth quarter data processing development charges are
$1,174,100.56; imaging development charges are $84,509.00 for
General Fund/General Purpose departments; direct charges to
Special Revenue and Proprietary fund departments are
$112,630.90 and charges to non-county agencies are $0.
3. The respective departmental Fiscal Year 2003 budgets are to be
amended as specified in the attached detail schedule.
FINANCE COMMITTEE
FINANCE COMMITTEE
Motion carried unanimously on a roll call vote with Gregory, Crawford,
and Webster absent.
Resolution #03293 October 16, 2003
The Chairperson referred the resolution to the Finance Committee. There were no objections.
In Testimony Whereof, I have hereunto set my hand and affixed the seal of the County of Oakland at
Pontiac, Michigan this 30th day of October, 2003.
G. William Caddell, County Clerk
Resolution #03293 October 30, 2003
Moved by Bullard supported by Hatchett the resolutions on the Consent Agenda be adopted (with
accompanying reports being accepted).
AYES: Coleman, Coulter, Crawford, Douglas, Gregory, Hatchett, Jamian, Knollenberg, KowaII,
Law, Long, McMillin, Middleton, Moffitt, Moss, Palmer, Patterson, Potter, Rogers, Scott, Suarez,
Webster, Wilson, Zack, Bullard. (25)
NAYS: None. (0)
A sufficient majority having voted therefore, the resolutions on the Consent Agenda were adopted (with
accompanying reports being accepted).
I Oft NPRK TIE FOREGOING ROWAN
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
October 30, 2003 with the original record thereof now remaining in my office.
