HomeMy WebLinkAboutResolutions - 2006.05.25 - 28243MISCELLANEOUS RESOLUTION #.06091 May 11, 2006
BY: GENERAL GOVERNMENT COMMITTEE, WILLIAM PATTERSON, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - SECOND QUARTER 2006
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 Second Quarter 2006 data processing development charges to be
$1,430,358.93 and the imaging development charge to be $68,822.53 for
the General Fund/General Purpose County departments; and
WHEREAS direct charges to Special Revenue and Proprietary fund
departments are $253,337.75 and non-county agencies are $1,114.50 for
the Second Quarter 2006; and
WHEREAS an appropriation transfer to General Fund/General Purpose
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 2006 Data Processing
Development Report and approves the Second 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
WIL ,e
General Government Committee Vote:
Motion carried on a roll call vote with Hatchett absent.
1st Qtr 2nd Off
Oct-Dec Jan-Mar DIVISION ACCOUNT 0 Y.T.D
41h Qtr
July- Sept
3rd QV
Apr -June
Health Fund 12211
640 221 20221-1060201-133150-773630
843 221 20221-1060220-134390-773630
Health
Health Env ronmental
Sub-Total Fund 221
$51,628.20 $442,175.70
$343,181 43 $342,236.55
5394.609.63 5384.412.28
$93.803.90
$665,418.01
$0.00 $779,221.91 $000
$71,973.18 $64,708.23
$6.622 50 $10.603.70
$2,081 00 53,480 60
Clerk Image
Courts-FOC Exp-CS Enforcement Image
Probate-Estates/Mental Health Image
63600-1080101-152000-630903 $80,875.88 $68,822.53
$0.00
$0.00
TOTAL IMAGING DEVELOPMENT
APPROPRIATION
SUB-TOTAL GOVERNMENTAL / IMAGING DEVELOPMENT APPROPRIATION: 61,479,482.57 $1,499,181.48
10100-9090101-198030.173830 Information Technology Development 151,479,482.57) 151,499,181 46)
TOTAL GOVERNMENT- $0.00 $0.00
IMAGING
722 10100-2010210-125009-773639
471 27100-3010404-126030-773839
512 10100-3040403-124010-773639
$126,711.41
$17.226.20
$5,561.60
,F30 $0.00 $149,499.21
$0.00 $2,978,864.03
$0 OQ 42.978,884.031
$0.00 $0.00
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
2ND QUARTER 2006
540 101
541 101
550 101
551 101
560 101
561 101
530 101
531 101
630 101
620 101
005 101
725 101
440 101
410 101
724 101
720 101
723 101
785 101
522 101
430 101
495 101
474 101
484 101
487 10'
492 10'
506 101
483 101
499 101
501 101
420 101
496 101
498 101
500 101
493 101
015 101
730 101
900 101
740 101
755 101
660 101
680 101
641 101
872 101
710 1D1
775 101
509 101
510 101
481 101
479 101
145 101
690 101
637 101
650 101
195 101
191 10'
445 101
600 101
GOVERNMENTAL FUNDS
General Fund 11011
10100-3020201-121020-773630
10100-3020205-113290-773630
10100-3020301-121020-773630
10100-3020305-113290-773630
10100-3020401-121020-773630
10100-3020405-113290-773630
10100-3020501-121020-773630
10100-3020505-113290473630
10100-1070801-114000-773630
10100-1010201-181010-773630
10100-5010101-180010-773830
10100-2010201-180000-773630
10100-2010301-185010-773630
10100-2010501-125000-773630
10100-2010210-125000-773630
10100-2010401472190-773630
10100-2010205-132300-773630
10100-1090101-171000-773630
10100-1070401-113000-773630
10100-1010501-181020-773630
10100-3010201-121110-773630
10100-3010401-121240-773630
10100-3010403-121230-773630
10100-3010402-121100-773630
10140-3010402-135080-773630
10100-3010401-121220-773630
10100-3010403-121100-773630
10100-3010301-121140-773630
10100-3010301-121160-773630
10100-3010301-121220-773630
10100-3010301-121110-773630
10100-3010301-121130-773630
10100-3010301-121150-773630
10100-3010101-121100-773630
10100-1010101-181000-773630
10100-6010101-155010-773630
10100-1010115-115090-773630
10100-1020501-173010-773630
10100-1040101-140000-773630
10100-1020601-182020-773630
10100-1050401-183010-773630
10100-1030650-184030473630
10100-1070601-132030-773630
10100-1070501-174000-773630
10100-1090201-171000-773630
10100-3040101-121080-773630
10100-3040403-124010-773630
10100-3040101-121060-773630
10100-3040101-121070-773630
10100-4010101-122050-773630
10100-1020401-182090-773630
10100-1030803-184020-773630
10100-1020701-126020-773630
10100-4030301-112590-773630
10100-40306014 10000-773630
10100-1030803-184030-773630
10100-7010101-186040-773630
52/1 - District Court
52/1 - District Court - Probation
52/2 - District Court
5212 - District Court - Probation
,52/3 - District Coun
52/3 - District Coui - Probation
52/4 - District Court
52/4 - District Court - Probation
Animal Contra
Auditing
Board of Commissioners
Clerk - Adtrin
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
Courts-FD Juvenile Support
Courts-FD Juvenile Referees
Courts-FD-Court Services-Admin.
Courts-FD-Court Services-Adoptions
Courts-FD-Judicial Support
Courts-FD-Judicial Suppori-Admin
Courts-GJ-Assignment
COURTS GI-Criminal Cass Support
Courts-GJ-Family Sui3oort
Courls-GJ-JIMS
Courts-GJ-Judicial Support
Courts-GJ-Mediation
Courts - Judical / Administration
County Executive
Drain Commissioner
Emergency Response 8. Prep Unit
Equalization Division
Facilities Management
Fiscal Services - Admin
Human Resources
Materials Management - Gen Fund
Medical Examiner
MSU Extension - Oakland
Planning & Economic Development
Probate - Judicial Aornin
Probate-Estates/Mental Health Support
Probate-FD-Judicial
Probate-FD-uudicial Support
Prosecuting Attorney - General Prosecution
Purchasing
Records Retention
Reimbursement Division
Sheriff
Sheriff - CLEMIS
Support SerVces
Treasurer
Sub-Total Fund 101
510,76664 $8.045.63
$4208 75 $1,185.88
510.756 54 58.045.63
54,20875 $1,185.88
$1075664 $8,045.63
$4208 75 01,185.66
$10.756 58 $8,045.61
$4206 75 $1,185.68
376 017.00 525,542.00
$366.00 $0.00
$6.679.50 $1,098 00
$0.00 $0.00
54.468 00 $5,897.00
$7,383 93 $7.755.08
$24,014 00 $36.451.00
$3.506.20 $5.755.20
$2.290.00 $3 977.50
53.641 50 52808.00
531.340 93 $68.499.58
51,732 00 $46800
$2,567.03 $9,359.54
50.00 $0.00
$0.00 $0.00
$0.00 $0.00
$7,529.00 $0.00
$7,814 00 $3.024.00
$4,367.31 $5.104.16
$2.391.00 $805.00
$0.20 $4,725.00
$6,744.00 $9,657.50
$32400 $355.00
520,02620 $28,902.50
$6,890 00 $1.259.00
$32.330.25 $22,453.55
$0.00 $0.00
559.585 00 $91,503.00
$2.897 50 $1,830.00
$100,586 44 $66,140.61
$0 00 $0.00
5138.552.29 $197,114.87
$55.378 62 $97.217.66
$0.00 $0.00
$77 160.V $80.035.33
$0.00 $0.00
$108.00 $0.00
$461.07 57.622.50
$3,388.28 $3.697.17
$190.00 $528.00
$0.00 $0.00
$23,397.17 $46,289.50
$4,2t200 50.00
$9.696.00 $15,414.00
$11.691 OD $6,171.00
$76.052.96 $59.938.04
$27,343.41 510.210.00
$7,725.93 $4.985.08
$88,541.83 $54,920.08
$999,251.26 $1,044,408.66
$18.802.27
$5,394.63
$18,80227
$5,394.63
$18,802.27
$5,394.61
518,802.19
$5,394.63
$101,659.00
$366,00
$7.777.50
$0.00
$10.365.00
$15,139.01
$60,465.00
$9,261.40
$6,267.50
$6,447.50
$99,840.51
$2,220.00
$11,926.57
$0.00
$0.00
$0.00
$7.529.00
$10,838.00
$9,471.47
$3,196.00
$4,725.00
$16,401.50
$709.00
$48,929.00
$8,149.00
$54,783.80
$0.00
$151,088.00
$4,727.50
$156,727.25
$000
$335,667.16
$152,596.28
$0.00
$157,195.44
$0.00
$108.00
$8.083.57
$7,085.45
$718.00
$0.00
$69,686.67
$4,212.00
$25,110.00
$17.862.00
$135,991.00
$37,553.41
$12,712.01
5143.451 91
$0.00 $0.00 52,043.739.91
juvenile Maintenance Fund 12931
665 293 20293-1060501-112090-773630
63600-1080101-152000-631365
Children's village
Sub-Total Fund 293
DATA PROCESSING DEVELOPMENT FOR
GOVERNMENTAL FUND APPROPRIATION
$4,745 CO $1,455.00
$4.745 CO $1,458.00
$1,398,805.89 $1.430.358.93
$6,203.02
$0.00 $0.00 $6,203.00
$0.00 $0.00 $2.829,184.82
Prepared by; Information Technology; 4/12/2006 2nd Qtr 2006.xls
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
2N,D QUARTER 2006
1st Dtr 2nd Ctr 510 Qtr 4th Qtr
ACCOUNT # DIVISION Oct - Dec Jan - Mar Apr - Jun July - Seat
NON-GOVERNMENTAL
DIRECT CHARGES
055 CLEMIS $43.570.81 $39,015.23 $82,586.04
056 CLEMIS FUND 63500 $0.00 $0.00 $0.00
096 CLEMIS 2004 IBIS Grant $73200 $549.00 $1.281.00
719 Clerk/ROD Automation Fund $21,630.00 $35,625.00 $57255.00
521 Community Corrections (Grant) $0.00 $0.00 $0.00
861 Community & Home Improvement $0.00 $0.00 $0.00
470 Courts-FOC Exp-Family Counseling $0.00 $0.00 $0.00
507 Courts-FOC Exp-CS Enforcement $976.00 $3.111.00 $4,087.00
210 Fire Records Management System $4.985.61 $2,847.83 $7,833.44
757 FM-Wli Rel/Jail MgtNide() Con f $28,079 93 $12,546.08 $40,626.01
758 FM-Jail Mgrnt Replacement $488.00 $954.05 $1,442.00
750 FM&O 51,878.00 $0.00 $1.878.00
759 F M & 0-Safety Overhead $0.00 $0.00 $0.00
655 Gararge $24,014.00 $27,891.00 $51,905.00
380 Health - ImmunizaVon Grant $2,566.00 $4,266.00 $8,832.00
751 I' - Telephone Comm,,ni,;aeons $0 00 $0.00 $0.00
662 Major Department Supoorl Project Fund $359,632.10 $108,204.20 $467,836.30
870 Medical Care Facility $7,538.61 $3,164.33 $10,702 94
248 Medical Care Facility - Pharmacy $0.00 $0.00 $0.00
651 O.C. International Airport-GRE Grant $0 00 $0.00 $0.00
653 0.C. International Airport $683,00 $7,214.00 $7.697.00
770 Parks and Recreation - Administration $000 $1,082.00 $1,082.00
790 Radio Communications $0.00 $0.00 $0.00
695 Risk Management $0 .00 $0.00 $0.00
602 Treasurer -100% Tax Paymt Fund ($1,485 50) $527.00 ($958.50)
656 Water & Sewer Accounting $5,065.93 $6,541.08 $11,407.01
850 Workforce Deve,oprr ent 50.00 SO 00 $0.0Q
83600-1080101-152000-631302 SUB-TOTAL DIRECT CHARGES FOR DATA $500,354.49 $3,337.75 $0,00 $753.592.24t
PROCESSING DEVELOPMENT
TOTAL COUNTY DEVELOPMENT CHARGES $1,979.537.06 S1,752,519.21 $0.00 mg, $3.732,355.27
NON-COUNTY AGENCIES
53000-1080101-152000-635017 Non-County Agencies $2,215.00 $1,114.50, m00 $0.00 $3,329.50
TOTAL DEVELOPMENT CHARGES $1,982,052.06 $1,753,633.01 $0.00 $0.00 $3.735,685.77
Y.T.D.
Prepared by; Information Technology. 4/1212006 2nd Qtr 2006 xls
722 CLERK -IMAGING 23007
13001
65420
95158
$3,474.08
4,281.00
$36,451.00
$3.977.50
$7,755.08
$36,451.00
$3,977.50
$3,474.08
64,115.50
910,00
$68,499,58
$61.00
2,745.00
0.00
$2,806.00
$488.00
$488.00
$1,737.04
7,622.50
$9,359.54
$0.00
$0.00
$0.00
$0.00
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER, 2006
Gust* GOVERNMENTAL FUNDS
005 BOARD OF COMMISSIONERS
630 ANIMAL CONTROL
620 AUDITING
665 CHILDRENS VILLAGE
725 CLERK - ADM1N
440 CLERK - ELECTIONS
720 CLERK! REGISTER OF DEEDS
91404 BOC-Cust Supt
BOG-Total
95628 Web License Registration
95682 Dog System
Animal Control-Total
44032 Auditing-System Maintenance
Auditing - Total
95665 Childrens Village
Childrens Village - Total
72500 Clerk - Admin
Clerk - Admin - Total
95443 Elections
Clerk -Elections - Total
20004 IDMS Support - Register of Deeds
36510 GIS Implementation Support-ROD
36511 ROD Application - H/VV Support
95493 Reg Deeds System Maintenance
95162 Clerk - DW Support
95558 User Support/ROD
95564 ROD - DW Support
Clerk/Reg of Deeds - Total
$1,098.00
$1,098.00
$8,425.00
17,117.00
$0.00
$1,458.00
$0.00
$5,897.00
$1,110.20
488.00
1,900.00
0.00
2,257.00
0.00
0.00
$5,755.20
$25.542.00
$0.00
$1,458.00
$0.00
$5,897,00
Oracle Support - Clerk Image
Clerk - eFiling - 50%
Clerk - Image Replace
Clerk - Imaging
Clerk - Imaging - Total
$3,474.08
22,404.75
10,324.00
18 535.40
$54.738.23
410 CLERK-JURY COMMISSION
724 CLERK -LEGAL RECORDS
723 CLERK - VITAL STATISTICS
522 COMMUNITY CORRECTIONS-AMIN (CO)
785 COMMUNITY & EGO DEVELOPMENT
430 CORPORATION COUNSEL
495 CTS-BUSINESS DIV -JIMS
487 CTS-FD-CT SERV-ADMIN
492 CTS-FD-CT SERV-ADOPTIONS
Oracle Support - Jury Comm
Jury Commission
Clerk -Jury Commission - Total
95189 Circuit Court System
Clerk - Legal Records - Total
95161 Vital Stats Index
Clerk - Vital Statistics - Total
Oracle Support-Comm Corr
Comm Corr-Admin (County)
Comm Corr-DW Supp
Community Corrections - Total
36500 GIS Implementation Support C&E Dev
36501 CEO Application - l-INV Support
95785 Comm & Eco Developmt
Community & Eco Dev - Total
95501 Corporation Counsel
Corporation Counsel - Total
23010 Oracle Support-CCT1CTS Crim Whse
90603 -MS - Circuit Court - 25%
CTS-Business Div - JIMS - Total
95196 CTS-FD-Ct Serv - Admin
CTS-FD-Ct Serv-Admin - Total
95173 CTS-FD-Ct Serv-Adoptions
CTS-FD-Ct Serv-Adoptions - Total
23008
95512
23003
52200
52201
Prepared try: Information Technology, 4/12/2006 200 Qtr 2006.xls
$1,620.00
37,829.00
33,846.00
18,208.00
0.00
$91,503.00
$2,220.40
3,474.08
2,786.33
0.00
14,430.00
9,634.50
4,514.00
12,444.00
865.00
7,641.50
28.131.00
$86,140.81
INFORMATION TECHNOLOY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER, 2006
505 CTS-FD-JUDICIAL 95186 CTS-FD/ADMIN-Family Judges $0.00
CTS-FD-Judicial - Total $0.00
506 CTS-FD-JUDICIAL SUPPORT 95187 CTS-FD/Admin - Fam Suppt Staff $3,024.00
CTS-FD-Judicial Suport - Total $3,024.00
483 CTS-FD-JUDICIAL SUPPORT-ADM 24009 SQL Serv Supp - CTS-Jud Sup Adm $1,393.16
95193 CTS-FD-Judicial Suport-Adm 3,71100
CTS-FD-Judicial Suport-Adm - Total $5,104.16
484 CTS-FD-JUVENILE REFEREES 95191 CTS-FD-Admin-Juvenile Referees $0.00
CTS-FD-Juvenile Referees - Total $0.00
474 CTS-FD-JUVENILE SUPPORT 95474 CTS-FD-Admin-Juvenile Support $0.00
CTS-FD-Juvenile Support - Total $0.00
499 CTS-GJ-ASSIGNMENT 95180 CTS-GJ-Assignment $805.00
CTS-GJ-Assignment - Total $805.00
501 cTS-GJ-CRIMINAL CASE SUPPORT 95182 CTS-GJ-Criminal Case Support $4,725.00
CTS-GJ-Criminal Case Support - Total $4,725.00
420 CTS - GJ - FAMILY SUPPORT 95195 Cir Crt Admin $9,657,50
Courts - GJ - Family Support - Total $9,657,50
496 CTS - GJ -JIMS 95208 CTS - OW Maintenance $385.00
CTS - GJ - JIMS - Total $385.00
498 CTS-GEN JURIS-JUDICIAL SUPPT 95179 CTS -Gen Juris-Judicial Suppt $28,902.50
CTS -Gen Juris-Judicial Suppt - Total $28.902.50
500 CTS-GJ-MEDIATION 95181 CTS-GJ-Mediation $1,259.00
CTS-GJ-Mediation - Total $1,259.00
493 CTS-JUDICIAL ADMIN 13002 Courts - eFiling 50% $22,404.75
95174 CTS-Judicial Admin 10% 48.80
CTS-Judicial Admin - Total $22,453.55
730 DRAIN COMMISSIONER
740 EQUALIZATION
28007 Drain Commissioner
28011 Drain Commissioner Application
36520 GIS Implementation Support Drain
36521 OCDC Application - HNV Support
95669 Water & Sewer Accounting
Drain Commissioner - Total
20001 IDMS Support-Equalization
23012 Oracle Support-Equalization
24005 SQL Server Supp-Equalization
31075 Equal - Development
36505 GIS Implementation Support Equalization
36506 Equal Application - H/W Support
95559 User Supporl/Equai
95562 Equalization - DW Support
95570 Equalization - DW Maintenance
95693 Equal-System Maintenance
95699 BS&A Master Appraisal Sup/Maim
Equalization - Total
$1,830.00
900 fMERGENCY RESPONSE & PREPAREDNESS 36545 GIS Implementation Support EMS $1,525.00
36546 ERP Application - H/W Support 305.00
98990 Emergency Response $0.00
ERP - Total
755 FACILITIES MANAGEMENT 91500 FM - System Support $0.00
Facilities Mgmt - Total $0.00
Prepared by: Information Technology; 4/12/2006 2nd OW 2008.xls
$6,948.14
10,112.03
1,122.85
540.63
28,629.40
25,610.00
1,281.00
0,00
0.00
1,372.50
0.00
80,998.88
40.499.44
$197,114.87
510 PROB-ESTATES/MENTL HLTH SUPPORT
481 PROBATE-FD JUDICIAL
479 PROB-FD-JUDICIAL SUPPORT
$1,393.17
2,304.00
$528,00
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - SECOND QUARTER, 2006
660 FISCAL SERVICES ADMIN 23001 Oracle Support - Fiscal Serv
23013 Oracle Support - HR-Acctg/Budget
24006 SQL Serv Supp HR-Acctg
24008 SQL Serv Supp - Budget
44021 FS-System/Customer Support
44022 FS-System Maintenance
44023 FS-System Enhancements
44024 FS-New Development
44077 BUD-System Maintenance
44079 FS - DW Support
44081 FS - OW Maintenance
96001 Human Res-Acct 40%
96003 Human Res.-Budget 20%
Fiscal Services Admin Total
840 HEALTH DEPARTMENT 20002 IDMS Support-CHAMPS $1,110.20
36525 GIS Implementation Support Health 26,467.50
37025 CHAMPS - P.O.P. 4,428.00
96842 Health Admin 10,170.00
Health Total $42,175,70
843 HEALTH -ENVIRONMENTAL 23005 Oracle Support - EH Projects $3,474.08
37002 Environmental 3,348.00
84200 EH - Projects 203,739.50
64300 Ehealth Program 131,675.00
Health-Environmental - Total $342,236.58
680 HUMAN RESOURCES 23014 Oracle Support-HR/Personnel $6,762.03
24007 SQL Server Suppport-HR/Personnel 1,122.85
44042 PER-Systems Maintenance 3,981.50
95556 Personnel User Supt 2,448.00
96002 Human Res-Personnel 40% 82 903.28
Personnel - Total $97,217.66
641 MATERIALS MGMT-GEN SUPPORT SERV 95440 Materials Management $0.00
Materials Mgmt-Gen Fund - Total $0.00
872 MEDICAL EXAMINER 24002 SQL Server Support - Medical Exam $2,786.33
87202 Medical Examiner - Customer Support 77,249.00
Medical Examiner - Total $80,035.33
710 MSU EXTENSION - OAKLAND 95676 MSU Ext Equipment Maintenance $0.00
MSU Extension - Oakland - Total $0.00
775 PLANNING & ECONOMIC DEVELOPMENT 95786 PEDS - OW Support $0.00
PEDS - Total $0.00
512 PROB-ESTATES/MENTL HLTH IMAGE 95207 Prob-Est/Mntl Hlth Image $3,480.60
Prob-Est/Mntl Hlth Image - Total $3480.60
509 PROB-JUDICIAL ADMIN 90604 JIMS Probate 25% $7,622.50
95165 PC-Judicial Admin-Admin Serv 0.00
Prob-Judicial Admin - Total $7,622.50
24010 SQL Serv Supp-PCT-Est/Mental
92198 Prob-Est/Mntl Hlth Support
Prob-Est/Mntl HIth Support - Total
95168 Prob-FD Judicial
Prob-FD Judicial - Tote(
95188 PROB-FD Judicial Support $0.00
PROB-FD Judicial Support - Total
$3,897.17
$528,00
$0.00
Prepared by: Information Technology; 4/12/2006 2nd Chr 2006.xls
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER, 2006
145 PROSECUTOR GENERAL PROSECUTION 90605 JIMS - Prosecutor 25% $7,622.50
95622 Prosecutor/Executive 38,127.00
97001 Prosecutor Data Proc 540.00
Prosecutor - Total $46,289.50
690 PURCHASING
637 RECORDS RETENTION
650 REIMBURSEMENT
195 SHERIFF
191 SHERIFF - CLEMIS
445 SUPPORT SERVICES
600 TREASURER
540 52/1 DISTRICT COURT - NOVI
541 52/1 DISTRICT COURT. NOVI -PROBATION
550 5212 DISTRICT COURT - CLARKSTON
44026 PUR-System/Customer Support
44027 PUR-System Maintenance
Purchasing - Total
95479 Reimbursement System
95542 Reimburse User Support
Reimbursement - Total
23009 Oracle Suppport - OCSD/CTS Crim Whse
97163 Sheriff
97164 Sheriff-Development
97165 Sheriff-DW Support
97166 Sheriff-DW Maintenance
Sheriff-Total
23015 Oracle Suppport - Sheriff / CLEMIS
96163 Sheriff - CLEMIS
Sheriff - CLEMIS - Total
23002 Oracle Support - Supp Serv
44500 Support Services
Support Services - Total
23006 Oracle Support - Del Tax
36515 GIS Implementation Support-Treasurer
36516 Treasurer Application - I-1/W Support
44061 Tre-System/Customer Support
44062 Tre-System Maintenance
44080 Tre-DW Support
44082 Tre-DW Maintenance
95008 Del Tax On Line
95303 Del Tax System Maintenance
95561 User Support/Del Tax
Treasurer - Total
90606 JIMS - 52/1 DC - 6.25%
95527 DC Suprt-25%-5211
5211 District Court - Total
94542 DC Probation Support - 52/1 - 25%
52/1 District Court - Probation - Total
90607 JIMS - 52/2 DC - 6.25%
95528 DC Suprt-25%-5212
52/2 District Court - Total
$0.00
0.00
$0.00
$4,346.00
1.825,00
$6,171.00
$1,737.04
46291.00
0.00
11,910.00
0.00
$59,938.04
$3,474.00
6,736.00
$10,210,00
$3,474.08
1,512.00
$4,986.08
$3,474.08
0.00
10,956.00
582.00
15,401.00
12,795.50
2,160.00
1,220,00
8,331.50
0.00
$54,920.08
$1,905.63
6,140,00
$8,045.63
$1,185,88
$1,185.88
$1,905.63
6 140 00
$8,045.63
$1,185.88
$1.185.88
551 52/2 DISTRICT COURT - CLARKSTON - PROBAT 94552 DC Probation Support - 52/2 - 25%
52/2 District Court - Probation - Total
44052 Rec-System Maintenance $0.00
44054 Rec-New Development 15.414,00
95636 Mail Room 0.00
Rec-New Development - Total $15,414.00
560 52/3 DISTRICT COURT. ROCHESTER 90608 JIMS - 52/3 DC - 6.25% $1,905.63
95529 DC Suprt-25%-52/3 6 140 00
52/3 District Court - Total $8,045.63
Prepared by: Information Technology; 4112/2006 2nd Oir 2006.xls
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER, 2006
561 5213 DISTRICT COURT - ROCHESTER - PROBAT 94562 DC Probation Support - 52/3 - 25% $1.185.86
52/3 District Court - Probation - Total $1,185.86
530 52/4 DISTRICT COURT - TROY 90609 JIMS - 52/4 DC - 6.25% $1,905.61
95530 DC Supr1-25%-52/4 6,140.00
52/4 District Court - Total $8,045.61
531 52/4 DISTRICT COURT TROY - PROBATION 94532 DC Probation Support - 52/4 - 25% $1,185.88
52/4 District Court - Probation - Total $1,185.88
Cust# DIRECT FUNDS
055 CLEMIS 20003 IDMS Support $1,110.20
24004 SQL Server Support 24,869.03
95409 CRISNET/CLEMIS LRM 0.00
95430 CLEMIS Maintenance 11,643.00
95431 CLEMIS Enhancements 1.393.00
CLEMIS - Total $39,015.23
056 CLEWS FUND 63500 63500 CLEMIS Fund $0.00
CLEMIS Fund Total $0.00
096 CLEMIS 2004 IBIS GRANT 63596 2004 Federal Approp - IBIS Project $549.00
CLEMIS 2004 IBIS Grant - Total $549.00
719 CLERK/ROD AUTOMATION FUND 95719 Register of Deects Automation $35,625.00
Register of Deeds Automation - Total $35.625.00
471 CTS-FOC-EXP-CS ENFORC-IMAG 92194 CTS-FOC-Exp-CS Enf-Image $10,603.70
CTS-FOC Exp-CS Enf-Image - Total $10,603.70
470 CTS-FOC-EXP-FAM COUNSELING 92195 CTS-FOC-Exp-Fam Counseling $0.00
CTS-FOC-Exp-Fam Counseling - Total $0.00
507 CTS-FOC EXP-CS ENFORCEMENT 92193 CTS-FOC Exp-CD Enforc-Dev $3,111.00
CTS-FOC Exp-CD Enforc-Dev - Total $3,111.00
210 FIRE RECORDS MANAGEMENT SYSTEM 21010 Fire Records Mgmt Fund 531 $61.50
24001 SQL Server Support - FIRMS 2.78633
Fire Records Mgmt - Total $2.847.83
750 FM&O 21001 FM&O $0.00
75503 FM&O Development 0.00
FM8k0 - Total $0.00
757 FM-WK RELEASE/JAIL MGMTNIDEO CONF 23004 Oracle Support - Oak Video $3,474.08
75700 Fac Mgmt - Video Arraignments 9,072.00
FM-Wk ReVJail MgmtNideo Conf - Total $12,546.08
758 FM -JAIL MGMT REPLACEMENT 75800 FM - Jail Mgmt Replacement $954.09
FM - Jail Mgmt Replacement - Total $954.00
655 GARAGE 44057 GAR - Systems Maintenance $27,891.00
44058 GAR - Systems Ennancements 0.00
Garage - Total $27,891.00
380 HEALTH IMMUNIZATION - GRANT 38000 Health - Immunization $4,286.00
Health - Immunization - Total $4,266.00
Prepared try Information Technotogy: 411212006 2nd Qtr 2006.xis
INFORMATION TECtINOLOqY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER, 2006
662 MAJOR DEPT SUPP PROJ FUND 66200 e-Financial-Peoplesoft Implementation $108.204.20
e-Financial-Peoplesoft Implem-Total $108,204.20
870 MEDICAL CARE FACILITY 24003 SQL Server Support - MCF $2,786.33
98873 MCF - Support 378.00
MCF - Support - Total $3,164.33
248 MEDICAL CARE FACILITY - PHARMACY 98248 MCF - Pharmacy
MCF - Pharmacy - Total $0.00
653 O.C. INTERNATIONAL AIRPORT 36540 GIS Implementation Support-Aviation $5,227.00
65301 Airport User Support 1,987.00
Airport User Support - Total $7,214.00
770 PARKS AND RECREATION 36530 GIS Implementation Support-Parks $488.00
95419 PRADM-Administration 594.00
Parks & Recreation - Total $1,082.00
790 RADIO COMMUNICATION 79001 Radio Communications $0.00
Radio Communications - Total $0.00
695 RISK MANAGEMENT 44036 RSK-System/Customer Support $0.00
95695 Risk Management 0.00
Risk Management - Total $0.00
602 TREASURER-100% TAX PAYMT FUND 99002 Treasurers Office $527.00
Treasurer's Office - Total $527.00
656 WATER & SEWER ACCTG 23011 Oracle Supp - Water & Sewer Acct'g $3,474.08
95669 Water & Sewer Acct'g 2,867.00
Water & Sewer Acct'g - Total $6,341.08
850 WORKFORCE DEVELOPMENT 95670 Workforce Development $0.00
Workforce Development - Total $0.00
Prepared by: Information Technology; 4112(2006 2nd Qtr 2006:xis
FISCAL NOTE (MISC. #06091) May 25, 2006
BY: FINANCE COMMITTEE, CHUCK MOSS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - SECOND QUARTER 2006
DEVELOPMENT APPROPRIATION TRANSFER
TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS
Chairperson, Ladies and Gentlemen:
Pursuant to Rule XIT-C of this Board, the Finance Committee has
reviewed the above-referenced resolution and finds:
1. The resolution appropriates and charges the Information
Technology Second Quarter 2006 Development cost to benefiting
departments.
2. The second quarter data processing development charges are
$1,430,358.93; imaging development charges are $68,822.53 for
General Fund/General Purpose departments; direct charges to
Special Revenue and Proprietary fund departments are
$253,337.75 and charges to non-county agencies are $1,114.50.
3. The respective departmental Fiscal Year 2006 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 Palmer and Rogers
absent.
Resolution #06091 May 11, 2006
The Chairperson referred the Resolution to the Finance Committee. There were no objections.
May 25, 2006
notes attached) on the Consent
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
Resolution #06091
Moved by Coleman supported by Wilson the resolutions (with fiscal
Agenda be adopted (with accompanying reports being accepted).
AYES: Crawford, Douglas, Gershenson, Gregory, Hatchett,
Middleton, Molnar, Moss, Nash, Palmer, Patterson, Potter,
Woodward, Zack, Bullard, Coleman, Coulter. (25)
NAYS: None. (0)
A sufficient majority having voted in favor, the resolutions (with fiscal
Agenda were adopted (with accompanying reports being accepted).
Jamian, KowaII, Long, Melton,
Rogers, Scott, Suarez, Wilson,
notes attached) on the Consent
OEM
MEN APPROVE ME MON IESOUR1011
I, Ruth Johnson, 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 May 25, 2006, 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 25th day of May, 2006.
Ruth Johnibn, County Clerk