HomeMy WebLinkAboutResolutions - 2008.09.04 - 9657MISCELLANEOUS RESOLUTION #08167 August 21, 2008
BY: GENERAL GOVERNMENT COMMITTEE, CHRISTINE LONG, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - THIRD QUARTER 2008
DEVELOPMENT APPROPRIATION TRANSFER
TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS
Chairperson, Ladies and Gentlemen:
WHEREAS all 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 Third Quarter 2008 development charges to be $1,630,573.35 and the
imaging development charge to be $10,290.12 for the General
Fund/General Purpose County departments; and
WHEREAS direct charges to Special Revenue and Proprietary Fund
departments are $749,648.02, non-governmental imaging development are
$4,646.80, and non-county agencies are $3885.00 for the Third Quarter
2008; 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 Third Quarter 2008 Development Report
and approves the Third Quarter appropriation transfer as specified on
the attached schedule.
Chairperson, on behalf of the General Government Committee,
move the adoption of the foregoing resolution.
GENERAL GOVERNMENT COMMITTEE
ci
GENERAL GOVERNMENT COMMITTEE VOTE!
Motion carried unanimously on a roll call vote with Jacobsen and Suarez
absent.
DIVISION ACCOUNT #
_ 540
550
560
530
630
620
005
725
440
410
724
720
723
785
522
430
495
506
483
420
498
493
015
730
900
740
660
680
907
872
710
003
775
510
481
145
637
650
663
195
191
445
600
I.
CUST # FUND #
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
3RD QUARTER 2008
1st Qtr
Oct - Dec
2nd Qtr 3rd Qtr 4th Qtr
Jan - Mar Apr - June July - Sept Y.T.D.
GOVERNMENTAL FUNDS
General Fund 11011
101 10100-3020201-121020-773630
101 10100-3020301-121020-773630
101 10100-3020401-121020-773630
101 10100-3020501-121020-773630
101 10100-1070801-114000-773630
101 10100-1010201-181010-773630
101 10100-5010101-180010-773630
101 10100-2010201-180000-773630
101 10100-2010301-185010-773630
101 10100-2010501-125000-773630
101 10100-2010210-125000-773630
101 10100-2010401-172190-773630
101 10100-2010205-132300-773630
101 10100-1090101-171000-773630
101 10100-1070401-113000-773630
101 10100-1010501-181020-773630
101 10100-3010201-121110-773630
101 10100-3010401-421220-773630
101 10100-3010403-121100-773630
101 10100-3010301-121220-773630
101 10100-3010301-121130-773630
101 10100-3010101-121100-773630
101 10100-1010101-181000-773630
101 10100-6010101-155010-773630
101 10100-1010115-115090-773630
101 10100-1020501-173010-773630
101 10100-1020601-182020-773630
101 10100-1050401-183010-773630
101 10100-5010303-165040-773630
101 10100-1070601-132030-773630
101 10100-1070501-174000-773630
101 67800-9011502-183190-773630
101 10100-1090201-171000-773630
101 10100-3040403-124010-773630
101 10100-3040101-121060-773630
101 10100-4010101-122050-773630
101 10100-1030803-184020-773630
101 10100-1020701-126020-773630
101 10100-9010101-140364-773630
101 10100-4030301-112590-773630
101 10100-4030601-110000-773630
101 10100-1030803-184025-773630
101 10100-7010101-186040-773630
52/1. _District Court
52/2 - District Court
52/3 - District Court
5214 - District Court
Animal Control
Auditing
Board of Commissioners
Clerk - Admin
Clerk - Elections
Clerk - Jury Commission
Clerk - Legal Records
Clerk - Register of Deeds
Clerk - Vital Statistics
Economic Development 8, Community Affairs
Community Corrections Admin
Corporation Counsel
Courts-Business Division
Courts-FD-Judicial Support
Courts-FD-Judicial Support-Admin
Courts-GJ-Family Support
Courts-GJ-Judicial Support
Courts - Judical / Administration
County Executive
Drain Commissioner
Emergency Response & Prep
Equalization Division
Fiscal Services - Admin
Human Resources
Library Admin
Medical Examiner
MSU Extension - Oakland
OC Retirees Association 1st & 2nd Qtr
Planning & Economic Development
Probate-Estates/Mental Health Support
Probate-FD-Judicial
Prosecuting Attorney - General Prosecution
Records Retention
Reimbursement Division
Security Camera Project (GF) 3rd Qtr
Sheriff
Sheriff - CLEMIS
Support Services
Treasurer
$11,757.1.7 $9;534-.66- - - - -$9;239..44- - - - --- - - • $30,528.27
$11,757.17 $9,531.66 $9,239.44 $30,528.27
$11,757.17 $9,531.66 $9,239.44 $30,528.27
$11,757.11 $9,531.64 $9,239.43 $30,528.18
$51,562.11 $61,825.60 $69,220.75 $182,608.46
$0.00 $793.00 $610.00 $1,403.00
$0.00 $122.00 $366.00 $488.00
$5,470.00 $0,00 $3,246.00 $8,716.00
$5,455.00 $7,646.00 $7,869.00 $20,970.00
$2,690.79 $3,588.97 $4,601.12 $10,880.88
$119,711.11 $117,216.85 $113,899.00 $350,826.96
'$2.866.41 $6,446.50 $4,681.70 $13,994.61
$000 $0.00 $40,636.00 $40,636.00
$3,182.00 $488.00 $3,019.50 $6,689.50
$14,302,40 $56,425.82 $65,544.62 $136,272.84
$427,00 $610.00 $244.00 $1,281.00
$3,031.27 $6,582.11 $6,110.32 $15,723.70
$366.00 $7,989.00 $0.00 $8,355.40
$9,748.61 $9,306.10 $14,982,50 $34,037.21
$5,811.00 $3,693.00 $17,178,50 $26,682.50
$37,234.50 $69,467.75 $72,965.00 $179,667.25
$122.00 $48.80 $1,162.20 $1,333.00
$91.50 $305.00 $305.00 $701.50
$71,127.36 $122,474.40 $171,671.25 $365,273.01
$2,569.50 $2,895.00 $2,850.00 $8,314.50
$126,679.06 $103,668.08 $139,135.29 $369,482.43
$245,135.60 $126,481.82 $110,818.95 $482,436.37
$58,135.95 $44,251.33 $44,012.37 $146,399.65
$0.00 $732.00 $0.00 $732.00
$12,152.61 $15,246,35 $16,041.00 $43,439.96
$30.50 $30.50 $244.00 $305.00
$0.00 $5,672.60 $0.00 $5,672.60
$1,464.00 $1,830.00 $3,050.00 $6,344.00
$8,087.61 $17,336.10 $23,727.50 $49,151.21
$0.00 $95.00 $0.00 $95.00
$14,446.11 $27,607.10 $33,008.00 $75,061.21
$5,162.25 $16,466,25 $25,684.50 $47,313.00
$9,851.40 $20,717.00 $36,685.00 $67,253.40
$0.00 $0.00 $8,069.50 $8,069.50
$75,527.39 $94,970.13 $64,431.07 $234,928.59
$3,910.79 $4,625.97 $4,723.12 $13,259.88
$13,551.51 $13,130.68 $17,742.11 $44,424.30
$175,192.63 $142,241.39 $152,097.43 $469,531.45
Prepared by; Information Technology; 811112008 Page 1 of 3 11_3rd_qtr_08_development_report.xls
DIVISION CUST # FUND # ACCOUNT #
Sub-Total Fund 101
Health Fund [2211_
-- —840— --2211 20221-1060201-133150-773630
843 221 20221-1060220-134390-773630
Juvenile Maintenance Fund 1293]
665 293 20293-1060501-112090-773630
63600-1080101-152000-631365
722 101
512 101
GOVERNMENTAL IMAGING
10100-2010210-125000-773639
10100-3040403-124010-773639
63600-1080101-152000-630903
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
3RD QUARTER 2008
1st Qtr 2nd Qtr 3rd Qtr 4th Qtr
Oct - Dec Jan - Mar Apr -June July - Sept Y.T.D.
$1,132,124.59 $1,151,152.82 $1,317,590.05 $0.00 $3,600,867.46
10100-9090101-196030-773630
_
Health
Health Environmental
Sub-Total Fund 221
Children's Village
Sub-Total Fund 293
DEVELOPMENT FOR GOVERNMENTAL FUND
APPROPRIATION
Clerk Image
Probate-Estates/Mental Health Image
TOTAL GOVERNMENTAL IMAGING
DEVELOPMENT APPROPRIATION
SUS-TOTAL GOVERNMENTAL! IMAGING
DEVELOPMENT APPROPRIATION:
Information Technology Development
TOTAL GOVERNMENT:
$29,021.30 $35,481.90 $14,690.70 $79,193.90
$242,467.21 $228_,820.38 $297,926.60 $769,214.19
$271,488.51 $264,302.28 $312,617.30 $0.00 $848,408.09
$427.00 $427.00 $366.00 $1,220.00
$427.00 $427,00 $366.00 $0.00 $1,220.00
$1,404,040.10 $1,415,882.10 $1,630,573.35 $9.00 $4,450,495.55
$874279 $3,735.37 $7,965.72 $20,443.88
$244.00 $97.60 82 324 40 $2,666.00
$8,986.79 $3,832.97 $10,290.12 $0.00 $23,109.88
$1,413,026.89 $1,419,715.07 $1,640,863.47 $0.00 $4,473,605.43
1$1,413,026.891 ($1,419,715 07) ($1,640,863.47) $0.00 ($4,473,605.43)
$0.00 $0.00 $0.00 $0.00 $0.00
11,
Page 2 of 3 • it...3rd_ritc08_development_report.xl5 Prepared by; nformation Technology; 8/11/2008
CUST # FUND # ACCOUNT # DIVISION
1st Qtr
Oct - Dec
2nd Qtr
Jan - Mar
3rd Qtr
Apr - June
4th Qtr
July - Sept Y.T.D.
NON-GOVERNMENTAL
DIRECT CHARGES
669
055
056
096
659
507
210
760
757
750
803
653
003
187
770
791
695
663
601
546
656
63600-1080101-152000-631302
NON-GOVERNMENTAL IMAGING
-
$0.00
$57,059.48
$990.00
($366.00)
$6,860.00
$37,728.00
$2,685.60
$2,548.00
$7,147.97
$6,912.60
$4,592.50
$244.00
$0.00
$0.00
$6,283.00
$4,688.25
$0.00
$12,815.50
$296,821.65
$3,628.50
$21,198.72
- - "
$9,549.25
$90,474.83
$755.50
$0.00
$37,273.25
$35,340.00
$3,514.50
$854.00
$12,001.12
$9,636.50
$11,956.50
S173.50
$3,526.00
$60,567.50
$10,113.00
$548.75
$0.00
$0.00
$421,334.45
$728.00
$41,301.37
$9,549.25
$200,905.18
$2,249.50
$0.00
$44,133.25
$86,577.00
$8,717.21
$21,228.00
$48,391,88
$21,983.96
$16,549.00
$844.50
S3,526 OD
$6056750
$19,110.50
$7,549.00
$122.00
$21,163.50
$896,160.00
$4,466.50
$74,826.88
$471,837.77 $749,648.02 $0.00 $1,548,620.61
Courts-FOC Exp-CS Enforcement Image $488.00 $195.20 $4,648.80 471 5,332.00
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
3RD QUARTER 2008
M-S-/C VT-Data Conversion $0.00
CLEMIS $53,370.87
CLEW FUND 63500 $504.00
CLEMIS 2005 IBIS Grant $366.00
Collaborative Asset Mgt Sys (CAMS) $0.00
Courts-FOC Exp-CS Enforcement $13,509.00
Fire Records Management System $2,517.11
FM-BOC Webcasting $17,826.00
FM-Wk Rel/Jail MgtNideo Conf $2924279
F M & 0 $5,434.86
Health - Bioterrorism Unit $0.00
0 C. International Airport $427.00
OC Retirees Association 3rd Qtr $000
OCSD - Jail Visitation Project $0.00
Parks and Recreation - Administration $2,714.50
Radio Communications E911 $2,312.00
Risk Management $122.00
Security Camera Project (GF) 1st & 2nd Qtr $8,348.00
Treasurer - DTRF $178,003.90
UASI Grant (ERP) $110.00
Water & Sewer Accounting $12,326.79
SUB-TOTAL DIRECT CHARGES FOR DEVELOPMENT $327,134.82
TOTAL NON-GOVERNMENTAL IMAGING $488.00 $195.20 $4,648.80 }0.00 $5,332.00
DEVELOPMENT APPROPRIATION
TOTAL COUNTY DEVELOPMENT CHARGES $1,740,649.71 $1.891,748.04 $2,395,160.29 so.og $6,027,558.04
$518.50 $366.00 $3.885,00 $4,769.50
$1,741,168.21
63600-1080101-15200-630903
NON-COUNTY AGENCIES
63600-1080101-152000-635017 Non-County Agencies
TOTAL DEVELOPMENT CHARGES $1,892,114.04 $2,399,045.29 $0.00 $6,032,327.54
Prepared by; information Technology; 8/11/2008 Page 3 of 3 it_3rd_qtr_08_development_repo1j.xls
722 CLERK - IMAGING
410 CLERK - JURY COMMISSION
.-
39,437.25
26,761.00
$610.00
$366.00
$366.00
$3,246.00
$7,869.00
$73.20
31 022.50
610.00
0.00
0.00
366.00
610.00
0.00
0.00
$0.00
4,479.12
0.00
3,486.60
$4,479.12
122.00
$69,220.75
$610.00
$366.00
$366.00
$3,246.00
$7,869.00
$4,681.70
$7,965.72
$4,601.12
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER, 2008
Cust # GOVERNMENTAL FUNDS
630 ANIMAL CONTROL. . 2401-7 -SQL Server Supp-- Animal-Control
95628 Web License Registration
95682 Dog System
. Animal Control-Total
620 AUDITING 95468 Auditing - Customer Support
Auditing - Total
005 BOARD OF COMMISSIONERS 91404 BOC - Customer Support
BOC - Total
665 CHILDRENS VILLAGE 95665 Childrens Village
Childrens Village - Total
725 CLERK - ADMIN 72500 Clerk - Admin
Clerk - Admin - Total
440 CLERK - ELECTIONS 95443 Elections
Clerk - Elections - Total
720 CLERK / REGISTER OF DEEDS 20004 IDMS Support - Register of Deeds
24003 SQL Server Supp - ROD 3.5%
36510 GIS Implementation Support-ROD
36511 ROD Application - HNV Support
95493 Reg Deeds System Maintenance
95162 Clerk - DW Support
95163 Clerk - DW Maintenance
95558 User Support/ROD
95564 ROD - DW Support
Clerk/Reg of Deeds - Total
13001 Clerk - eFiling - 50%
23007 Oracle Support - Clerk Image 5.2%
65420 Clerk - Image Replace
95158 Clerk - Imaging
Clerk - imaging - Total
23008 Oracle Support - Jury Comm - 5.2%
95512 Jury Commission
Clerk - Jury Commission - Total
Prepared by Information Technology; 8/1112008 Page 1 of 10 it_3rd_gtr_013_development report.xls
724 CLERK - LEGAL RECORDS
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - THIRD QUARTER, 2008
24015 SQL Server Supp - Circuit Ct 3.5%
. .951.89 _ Circuit-Court-System • -- -- -
Clerk - Legal Records - Total
$3,022.50
1.107876750- - -
$113,899.00
723 CLERK - VITAL STATITICS 95161 Vital Statistics $40,636.00
Vital Statistics - Total
522 COMMUNITY CORRECTIONS-ADMIN (CO) 23003 Oracle Support-Comm Corr - 5.2% $4,479.12
24012 SQL Server Supp - Community Corr 3.5% 3,022.50
52200 Comm Corr-Admin (County) 56,150.00
52201 Comm Corr-DW Supp 1,893.00
Community Corrections - Total
785 COMMUNITY & ECO DEVELOPMENT 36500 GIS Implementation Support C&E Dev $3,019.50
36501 CEO Application - HNV Support 0.00
95785 Comm & Eco Developmt 0.00
Community & Eco Dev - Total
430 CORPORATION COUNSEL 95501 Corporation Counsel $244.00
Corporation Counsel - Total
015 COUNTY EXECUTIVE 95656 County Executive Support $305.00
County Executive Support - Total
495 CTS-BUSINESS DIVISION 12002 Circuit Ct-Courts/Criminal Warehouse 50% $0.00
14001 CTS-DW Support/Circuit Ct - 75% 3,276.00
15001 CTS-DW Maint/Circuit Ct - 75% 594.75
23010 Oracle Support-CCT/CTS Crim Whse 2.6% 2239.57
CTS-Business Division - Total
506 CTS-FD-JUDICIAL SUPPORT 95187 CTS-FD/Admin - Fam Suppt Staff $0.00
CTS-FD-Judicial Suport - Total
483 CTS-FD-JUDICIAL SUPPORT-ADM 24009 SQL Serv Supp - CTS-Jud Sup Adm - 3.5% $3,022.50
95193 CTS-FD-Judicial Support-Adm 11 960.00
CTS-FD-Judicial Support-Adm - Total
420 CTS - GJ - FAMILY SUPPORT 95195 Cir Crt Admin $17,178.50
Courts - GJ - Family Support - Total
$40,636.00
$65,544.62
$3,019,50
$244.00
$305.00
$6,110.32
$0.00
$14,982.50
$17,178.50
Prepared by: Information Technology; 8/1112005 Page 2 of 10 it_3rd_qtr_08_development_report.xls
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER, 2008
498 CTS-GEN JURIS-JUDICIAL SUPPT
493 CTS-JUDICIAL ADMIN
730 DRAIN COMMISSIONER
900 EMERGENCY RESPONSE & PREPAREDNESS
740 EQUALIZATION
95179 CTS-Gen Juris-Judicial Suppt $72,965.00
CTS-Gen Juris-Judicial Suppt - Total $72,965.00
13002 CTS-eFiling - 50% $0.00
95174 CTS-Judicial Admin 1,162.20
CTS-Judicial Admin - Total $1,162.20
24008 SQL Server Supp - Drain 3.5% $3,022.50
28009 Drain Administration 0.00
28010 Drain - Customer Support 57,232.00
28011 Drain Commissioner Application 54,710.00
36520 GIS Implementation Support Drain 29 1371.00
36521 OCDC Application - HM/ Support 27,335.75
95669 Water & Sewer Accounting 000
Drain Commissioner - Total $171,671.25
36545 GIS Implementation Support EMS $2,043.50
36546 ERP Application - H/W Support 806.50
98990 Emergency Response 0.00
ERP - Total $2,850.00
20001 IDMS Support-Equalization - 40% $146.40
23012 Oracle Support-Equalization - 5.2% 4,479.12
24005 SQL Server Supp-Equalization - 10.5% 9,067.49
31075 Equal - Development 0.00
36505 GIS Implementation Support Equalization 882.00
36506 Equal Application - MN Support 10,549.50
36507 Equal LAMS Support/Mtce 0.00
36601 Land System Enhancements - Equal (50%) 8,925.75
36701 Land System Maintenance - Equal (50%) 10,885.50
36801 Land System Support - Equal (50%) 23,575.03
95559 User Support/Equal 0.00
95562 Equalization - OW Support 2,602.00
95570 Equalization - DW Maintenance 54.00
95693 Equal-System Maintenance 1,952.00
95699 BS&A Master Appraisal Sup/Maint 66 016.50
Equalization - Total $139,135.29
Page 3 of 10 it_3rd_qtr 08_developmentreportxls Prepared by: Information Technology; 8/11/200I3
660 FISCAL SERVICES ADM1N
840 HEALTH DIVISION
843 HEALTH - ENVIRONMENTAL
680 HUMAN RESOURCES
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER, 2008
23001 Oracle Support - Fiscal Serv - 15.6% $13,437.38
_Oracle Support-.HR-Acctg/Budget - - - -4,479.12'
24006 SQL Serv Supp - HR-Acctg - 1.75% 1,511.25
44021 FS-System/Customer Support 21,265.50
44022 FS-System Maintenance 6,903.00
44023 FS-System Enhancements 9,067.70
44024 FS-New Development 0.00
44076 BUD-System/Customer Support 0.00
44077 BUD-System Maintenance 0.00
44079 FS - DW Support 854.00
44081 FS - OW Maintenance 0.00
96001 Human Res - Acct 40% 35,534.00
96003 Human Res - Budget 20% 17,767.00
Fiscai Services Admin - Total
20002 IDMS Support - CHAMPS - 20% $73.20
36525 GIS Implementation Support Health 0.00
37025 CHAMPS - P.O.P. 378.00
95563 User Support-Health 11,933.00
96842 Health Admin 2,306.50
Health - Total
23005 Oracle Support - EH Projects - 5.2% $4,479.12
24014 SQL Server Suppt - Eheafth 14% 12,089.98
37002 Environmental 0.00
84200 ER-Projects 250,021.00
84300 Ehealth Program 31 336.50
Health-Environmental - Total
23014 Oracle Support-HR/Personnel - 5.2% $4,479.12
24007 SQL Server Suppport-HR/Personnel - 1.75% 1,511.25
44041 PER-System/Customer Support 1,192.00
44042 HR-Systems Maintenance 1,296.00
44044 HR-New Development 0.00
95556 HR User Supt 0.00
96002 Human Res-Personnel 40% 35 534.00
Human Resources - Total
$110,818.95
$14,690.70
$297,926.60
$44,012.37
Page 4 of 10 it_3rd_qtr 08_development_report.xls Prepared by: tntormation Technology; 8/11/2008
872 MEDICAL EXAMINER
710 MSU EXTENSION - OAKLAND
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - THIRD QUARTER, 2008
907 LIBRARY - LIBRARY ADMIN 91405 Library Board $0.00
.Library -.Library Admin.-Total- -
24002 SQL Server Support - Medical Exam - 3.5% $3,022.50
87202 Medical Examiner - Customer Support 13 018.50
Medical Examiner - Total
95676 MSU Ext Equipment Maintenance $244.00
MSU Extension - Oakland - Total
$16,041.00
$244.00
775 PLANNING & ECONOMIC DEVELOPMENT 95786 PEDS - DW Support $1,952.00
95787 PEDS - DW Maintenance 1,098.00
PEDS - Total
481 PROB-FD JUDICIAL 95168 PC-Judicial Adm - Family Judges $0.00
Prob-FD Judicial - Total
512 PROB-ESTATES/MENTL HLTH IMAGE 95207 Prob-Est/Mntl Hlth Image $2,324.4Q
Prob-Est/Mntl Hlth Image - Total
510 PROB-ESTATES/MENTL HLTH SUPPORT 24010 SQL Serv Supp-PCT-Est/Mental - 3.5% $3,022.50
92198 Prob-Est/Mntl Hlth Support 20.705.00
Prob-Est/Mntl Hlth Support - Total
145 PROSECUTOR - GENERAL PROSECUTION 24016 SQL Server Supp - Proesoutors 3.5% $3,022.50
95622 Prosecutor/Executive 20,630.00
97001 Prosecutor Data Proc 9355.50
Prosecutor - Total
637 RECORDS RETENTION 44052 Rec-System Maintenance $0.00
44053 Rec-System Enhancements 3,375.00
44054 Rec-New Development 22,309.50
95636 Mail Room 0.00
Records Retention - Total
$3,050.00
$0.00
$2,324.40
$23,727.50
$33,008.00
$25,684.50
Prepared by: Information Technology: 811 112008 Page 5 of 10 it_3rd_qtr_013_development_report.xls
650 REIMBURSEMENT
663 SECURITY CAMERA PROJECT (GF)
195 SHERIFF
191 SHERIFF - CLEMIS
445 SUPPORT SERVICES
600 TREASURER
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER, 2008
95469 Reimbursement Division $0.00
95470 Reimbursement System 18,433.00
95542. Reimburse •User-Support- - - - - - 18;252.0p
Reimbursement - Total
66300 Security Camera Project (GF) $8,069.50
Security Camera Project (GF) - Total
12001 OCSD-Courts/Criminal Warehouse $0.00
23009 Oracle Suppport - OCSD/CTS Crim Whse - 2.6% 2,239.57
97163 Sheriff 35,112.00
97165 Sheriff-DW Support 26,640.50
97166 Sheriff-DW Maintenance 439.00
Sheriff - Total
23015 Oracle Suppport - Sheriff! CLEMIS - 5.2% $4,479.12
96163 Sheriff - CLEMIS 244.00
Sheriff - CLEMIS - Total
23002 Oracle Support - Supp Serv - 5.2% $4,479.12
24011 SQL Server Supp - Suppt Services 7% 6,044.99
44500 Support Services 7 218.00
Support Services - Total
23006 Oracle Support - Del Tax - 5.2% $447912
23016 Oracle Support - Treasurer - 10.4% 8,958.24
36515 GIS Implementation Support-Treasurer 0.00
36516 Treasurer Application - HM/ Support 11,712.00
36602 Land System Enhancements - Treas (50%) 8,925.75
36702 Land System Maintenance - Treas (50%) 10,885.50
36802 Land System Support - Trees (50%) 23,575.02
44061 Ire-System/Customer Support 5,292.30
44062 Tre-System Maintenance . 6,403.00
44063 Ire-System Enhancements 0.00
44064 Tre-New Development 0.00
44080 Ire-OW Support 6,874.50
44082 Tre-DW Maintenance 1,118.00
95008 Del Tax On Line 1,586.00
95303 Del Tax System Maintenance 5,258.00
95561 User Support/Del Tax 18,421.50
95615 BS&A Annual Tax Support 38,60&50
Treasurer - Total
$36,685.00
$8,069.50
$64 431 07
$4,723.12
$17,742.11
$152,097.43
Prepared by: Information Technology; 8/11/2008 Page 8 of 10 it_3rd_otr_08_development_report.xls
$273.00
49.56
8,916.88
$9,239.44
$273.00
49.56
8.916.88
$9,239.44
$273.00
49.56
8.916.88
$923944
$27300
49.57
8.91686
$9,239.43
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER, 2008
540 52/1 DISTRICT COURT - NOVI 14002 CTS-DW Support-52/1 - 6.25%
- - - - -15002- -- CTS-DW•Maint 52/1-6.25% -
95527 DC Suprt- 52/1 - 25%
52/1 District Court - Total
550 52/2 DISTRICT COURT - CLARKSTON 14003 CTS-DW Support-52/2 - 6.25%
15003 CTS-DW Maint 52/2 - 6.25%
95528 DC Suprt- 52/2 - 25%
52/2 District Court - Total
560 52/3 DISTRICT COURT - ROCHESTER 14004 CTS-DW Support-52/3 - 6.25%
15004 CTS-DW Maint 52/3- 6.25%
95529 DC Suprt - 52/3 - 25%
52/3 District Court - Total
530 5214 DISTRICT COURT - TROY 14005 CTS-DW Support-52/4 - 5.25%
15005 CTS-DW Maint 52/4 - 6.25%
95530 DC Suprt- 52/4 - 25%
52/4 District Court - Total
Prepared by Information Technology; 8/11/2008 Page 7 of 10 it_3rd_qtr 08_development report.xls
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER, 2008
Gust # DIRECT FUNDS
055 CLEWS
056 CLEM'S FUND 63500
096 CLEMIS 2005 IBIS GRANT
669 CAMS/CVT DATA CONVERSION
659 COLLABORATIVE ASSET MGT SYS
471 CTS-FOC-EXP-CS ENFORC-IMAGE
507 CTS-FOC EXP-CS ENFORCEMENT
210 FIRE RECORDS MANAGEMENT SYSTEM
20003 IDMS Support - 5.6%
23018 Oracle Support - Sheriff CLEMIS 5.2%
24004 SQL Server Support - 24.5%
90507 CAD Customer Support
95409 CRISNET/CLEMIS LRM
95430 CLEMIS Maintenance
95431 CLEMIS Enhancements
95432 CLEMIS Adhoc Reports
98003 CLEMIS User Support
CLEMIS - Total
63500 CLEMIS Fund
CLEWS 63500 Fund - Total
63596 2005 Federal Approp - IBIS Project
CLEMIS 2005 IBIS Grant - Total
66901 CAMS/CVT Data Conversion
CAMS/CVT Data Conversion - Total
65901 Collabortive Asset Mgt Sys
Collabortive Asset Mgt Sys - Total
92194 CTS-FOC-Exp-CS Enf-lmage
CTS-FOC Exp-CS Enf-lmage - Total
92193 CTS-FOC Exp-CD Enforc-Dev
CTS-FOC Exp-CD Enforc-Dev - Total
21010 Fire Records Mgmt Fund 531
24001 SQL Server Support - FRMS 3.5%
Fire Records Mgmt - Total
$73.20
4,479.16
21,157.47
0.00
0.00
5,120.00
10,264.50
14,712.50
34,668 00
$755.50
$0.00
$9,549.25
$37,273.25
$4,648.80
$35,340.00
$492.00
3 022.50
$90,474.83
$755.50
$0.00
$9,549.25
$37,273.25
$4,648.80
$35,340.00
$3,514.50
750 FIVI&O 21001 FM&O $0.00
24013 SQL Server Supp FM&O 3,022.50
75503 FM&O Development 6,614.00
FM&O - Total $9,636.50
Page 8 of 10 it_3rd_qtr_08_development_report.xls Prepared by: Information Technology; 8111/2008
$0.00
0.00
$0.00
44036 RSK-System/Customer Support
95695 Risk Management
Risk Management - Total
695 RISK MANAGEMENT
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER, 2008
760 FM - BOC WEBCASTING 76000 FM - BOC Webcasting $854.00
--BOC Webcasting•- Total— - - - - -
757 FM-WK RELEASE/JAIL MGMTNIDEO CONF 23004 Oracle Support - Oak Video - 5.2% $4,479.12
75700 Fac Mgmt Video Arraignments 7,522.00
FM-Wk Rei/Jail MgmtNideo Conf - Total
803 HEALTH-BIOTERRORISM UNIT 80130 Health - Bioterrorism Unit 511,956.50
Health - Bioterrorism Unit - Total
653 0.C. INTERNATIONAL AIRPORT 36540 GIS Implementation Support-Aviation $122.00
--$854:00-
$12,001.12
$11,956.50
65301 Airport User Support 51.50
0 C. International Ad-port-Total $173.50
003 OC RETIREES ASSOCIATION 98872 OC Retirees Assoc $3.526.00
OC Retirees Assoc - Total $3,526.00
187 OCSD - JAIL VISITATION PROJECT 97187 OCSD - Jail Visitation Project $60,567.50
OCSD - Jail Visitation Project - Total $60,567.50
770 PARKS AND RECREATION 36530 GIS Implementation Support - Parks $548.00
44066 PRADM-System/Customer Support 3,221.00
77010 PRADM-Technology Assessment 6,344.00
Parks & Recreation - Total $10,113.00
791 RADIO COMMUNICATION - E911 79101 Radio Communications - E911 $548.75
Radio Communications - E911 - Total $548.75
601 TREASURER - DTRF
546 UASI GRANT (ERP)
Prepared by: Information Technology; 8111/2008
18010 Treasurers Office System • • $364,116.00
18050 Drain Apportionment 36,446.45
18060 Michigan Business Tax 20 772.00
Treasurer DTRF - Total
12546 UASI Grant (ERP) $728.00
UASI Grant (ERP) - Total
Page 9 of 10 iL3rd_qtr_08_development_report.xls
$421,334.45
$728.00
$4,479.12
36 822.25 - . _
$41,301.37
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER, 2008
656 WATER & SEWER ACCTG 23011 Oracle Supp - Water & Sewer Acct'g - 5.2%
_95669 -Water & Sewer AccVg
Water & Sewer Acct'g - Total
Prepared by: Information Technology: 8/11/2008 Page 10 of 10 it 3rd_qtr_08_devetopment_report.xis
Resolution #08167 August 21, 2008
The Chairperson referred the resolution to the Finance Committee. There were no objections.
L
•
FISCAL NOTE (MISC. #08167) September 4, 2008
BY: FINANCE COMMITTEE, MIKE ROGERS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - THIRD QUARTER 2008
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 Third Quarter 2008 Development cost to benefiting
departments.
2. The third quarter development charges are $1,630,573,.35;
imaging development charges are $10,290.12 for General
Fund/General Purpose departments; direct charges to Special
Revenue and Proprietary fund departments are $749,648.02, non-
governmental imaging development are $4,648.80, and charges to
non-county agencies are $3,885.00.
3. The respective departmental Fiscal Year 2008 budgets are
recommended to be amended as specified in the attached detail
schedule.
FI1NT:)ZMMITTEE
FINANCE COMMITTEE: Motion carried unanimously on a roll call vote With
Coulter absent.
I HEREBY APPROVE THE FOREGOING RESOLUTION
9;
.!-Et 4
Resolution #08167 September 4, 2008
Moved by Long supported by Middleton the resolutions (with fiscal notes attached) on the Consent
Agenda be adopted (with accompanying reports being accepted).
AYES: Burns, Coleman, Coulter, Douglas, Gershenson, Gingeli, Gosselin, Gregory, GreiMel,
Hatchett, Jacobsen, KowaII, Long, Middleton, Nash, Potts, Rogers, Scott, Spector, Woodward,
Zack, Bullard. (22)
NAYS: None. (0)
A sufficient majority having voted in favor, the resolutions (with fiscal notes attached) on the Consent
Agenda were adopted (with accompanying reports being accepted).
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
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
September 4, 2008, 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 4th day of September, 2008.
Ruth Johnson, County Clerk