HomeMy WebLinkAboutCOM 0070.015 1998-2000 /
0
COUNTY OF HAWAII
DEPARTMENT OF FINANCE
DATA PROCESSING DIVISION
RECEIVED `
Time_-- • By- - - - -- --
Data....._. /) 5i99
` County Council
•
YEAR 2000
STATUS REPORT
January 15, 1999
Page
Project Statistics ............................... 1
Recent Accomplishments 2
Year 2000 Survey Results t
Y2R Status Tables . 5
Project Schedule for 1999 6 -10
Year 2000 Survey Summary Tables:
Computer Applications (running on mainframe and minicomputers) Table A
Cumpater Applications (running on LANs and PCs) Table B
Computer Systems (Minicomputers & Nord Processor Computer Systems) Table C
Computer Systems (PC -Based Local Area Network LANs) Table D
Personal Computers (Desktop, Laptop. Notebook PCs) Table E
Questions regarding this report or }2K issues should be directed to
GA Rock, County of Ha t'aii / Project Coordinator, at (808) 961 -8452 0 o is
Comm. No. / 7
File No. f'
Ref. To NM HS ED C
. .
0 0
YEAR 2000 PROJECT STATISTICS
at a glance
Computer hardware /software costs
Expended to date S 355.700
Budgeted this FY 1998 -99 S 106.700
Bud<_reted next FY 1999 -00 S 10.200
Total projected Y2K costs for all computer systems /applications $472,600
� I
Staff time spent on Y2K projects for Data Processing Division
Expended to date 2.800 hours
Projected throughout 1999 3.000 hours
Total projected Y2K staff time within Data Processing Division 5,800 hours
Estimated Y2K labor costs within Data Processing Division $ 104,400
NOTE
Actual staff time incurred by County employees outside of Data Processing DIN ision
is not as actable A rough estimate a ould be comparable to that spent by DP DR ision
staff as many departments and agencies have been involved with a variety of Year !
2000 activities such as education. project planing and coordination sessions. survey
preparation. reports, outside vendor communications, attending meetings and
skorkshops, des eloping and re'i ewtng bid specifications, overseeing upgrades,
conducting 1'1K assessments. coordinating upgrades and replacements, testing
systems and applications. retraining staff, adapting replacement systems and
applications. etc
Projected completion levels As of 1/11/99 By 6/30/99 By 9/30/99
Computer Applications ' 30 4'% 61 85% 72 100%
Computer Systems b 20% 1 70% 30 100%
PC Systems 383 83% 523 90% 583 100%
-I-
1.
0 0
RECENT ACCOMPLISHMENTS
Much work has been completed since the last status report and we are pleased to report the
following solid progress:
✓ Year 2000 surveys that were distributed to all County departments and agencies to obtain
important status information have been compiled and summarized. See the following
section that discusses the surveys in more detail.
✓ Data Processing Division provided significant advice and assistance to County
organizations as they prepare for the Year 2000.
✓ County departments and agencies were advised to budget for any remaining Y2K related
needs requiring funding in the first half of next fiscal year (FY 1999 -2000) to ensure
readiness before the turn of the century.
✓ Year 2000 compliance terminology was provided to all County organizations for
insertion into bid specifications, purchase orders, purchase contracts, warranties,
consultant contracts, and other documents where needed to ensure that any purchases
made will carry the County into the next century.
✓ Departments and agencies began sending the County's Y2K Readiness Questionnaire
forms to outside vendors and government organizations that provide products. services,
and support related to computer systems and applications, information technology. and
other products used by the County that could be impacted by the Y2K issue.
✓ Responses were provided to numerous outside businesses and individuals requesting
information pertaining to the County's Y2K plans and status. These included letters,
completed surveys, phone calls, and Internet e-mail as appropriate.
✓ A methodology and set of tables were developed to enable establishment of checkpoints
and ongoing Y2K compliance monitoring and simplified progress reporting on an
objective level for the County's Y2K project.
✓ The Housing & Community Development agency began installing their Y2K compliant
Windows NT LAN computer system to replace its Novell LAN systems. This project
will utilize federal funding.
I '
O O
✓ Scheduling of final Y2K validation and data flow testing for the custom written
applications that run on the County's central Wang computer system and supported
internally by the County Data Processing Division was completed.
✓ Final Y2K validation testing was completed for the following critical applications
running on the County's central Wang computer system:
Payroll System
Manual Warrant Processing for the Payroll System
Manual Warrant Processing for the Accounting System
Sewer Billing System
Inventory Control /Fixed Asset System
Cemetery Plots Management System
Dog Licensing System.
Purchase Orders Processing
Election Timekeeping System.
✓ Assurances were provided by the City & County of Honolulu that Y2K fixes have been
completed and Y2K compliance has been achieved for the following cntical applications:
Motor Vehicle Registration
Drivers Licensing
Voters Registration
Real Property (Tax Administration and Accounting Components)
National Crime Information Center (NCIC) Access.
✓ Assurances v, ere provided by the State government that Y2K fixes have been completed
and Y2K compliance has been achieved for the following critical applications:
Criminal Offender Based Tracking System (OBTS)
Juvenile Justice Information System.
-3-
O
YEAR 2000 SURVEY RESULTS
Year 2000 surveys were distributed to all County departments and agencies to obtain
important status information in the following areas:
• Computer systems (minicomputers, multi -user word processors, & PC -LANs)
• Personal Computers (desktop, laptop, notebook PCs)
• Computer applications.
This information received has been used to make a comprehensive inventory of all of the
County's critical computer applications and systems. It also has provided information that is
necessary for further planning and implementation of the County's Y2K initiatives
throughout 1999 Finally, it will enable ongoing Y2K compliance monitoring and progress
reporting on an objective level.
The results have been compiled based upon the information reported by County departments
and agencies. They are summarized in the Year 2000 Status Table on the following page.
Readers interested in obtaining more detailed information regarding specific computer
applications and computer systems can refer to the Y2K Survey Summary Tables A thru E
appearing at the end of this report. The completed items are listed first followed by open
items listed in order of estimated completion date, earliest first.
The PC survey forms provided information on "commercial off - the - shelf" (COTS) software
applications used by various County departments and agencies. This includes general office
automation software such as word processing, spreadsheet, and database packages typically
found in today's business environment. Data Processing Division will be tracking the Y2K
issues related to these general COTS packages and will periodically notify users about Y2K
ramifications. Upgrade, replacement, and "work- around" recommendations will be made as
may be necessary.
Of note. a survey will be developed and sent to all County departments and agencies to
obtain information regarding the Y2K status of critical "embedded chip" and "process
control" products and systems in use by vanous County departments and agencies. This
information will be compiled and used to track progress in these areas and to ensure that such
products systems will be Y2K ready in time.
O O
YEAR 2000 STATUS TABLES
as of 1/11/99
COMPUTER APPLICATIONS Software and Related Costs
Running on all types of computer systems FY 98 -99 FY 99 -00
Count To Date Budget Budget (est
Y2K compliant 30 I
Y2K Compliant but awaiting final validation testing III
To be modified for Y2K by outside vendor 3 I 11.000
To be modified for Y2K by County staff 1 I
To be replaced with new Y2K compliant application I 11 I 42.700 3.100
To continue use with known Y2K shortcomings
To discontinue use after 12 I . 1 I
Not assessed vet 15 I
TOTALS 72 542.700 514,100 -0-
COMPUTER SYSTEMS Hardware & Software Costs
Minicomputers / PC -LANS / Wang 015 Word
Processor FY 98 -99 FY 99 -00
rocessor systems
Count To Date Budget Budget (est.)
Y2K compliant 6 89.000
Usgraded for Y2K. awaiting final validation testin• 3
To be upgraded to Y2K level 5 2.000 29.000
To be re.laced with a new system or alternatives I 11 I 169.500 56.100 10.200
To continue use with known Y2K shortcomings 3 - --
To discontinue use after 12 %31/99 --
Not assessed vet 2 I
TOTALS 30 I 5260.500 585.100 I 510.200
PC SYSTEMS Hardware & Software Costs
Desktop, Laptop & Notebook PCs FY 98 -99 FY 99 -00
Count To Date Budget Budget (est.)
Y2K compliant I 455 I
To be upgraded to Y2K level 1 I
To be replaced with new PC system 45 I 52,500 7.500 I
To continue use with known Y2K shortcomings 28 I
To discontinue use after 12/31/99 I
Not assessed yet 54
TOTALS 583 I 552.500 S7,500 -
NOTES
Information is based upon material submitted by departments and agencies on the Y2K survey forms that were distributed
by Data Processing Division In some instances, supplemental information was also obtained erbally
Counts are expected to Nary slightly throughout 1999 to reflect changes in the County's inventory due to new information
rem n ed or the impact of new purchases or disposals that may take place throughout the year
Dollar amounts include both actual and estimates based upon current information and will be updated as new information
becomes mailable In some instances. contracts with outside vendors for Y2K upgrades and replacements may include
additional hardware and software components that were added into the package to improve overall system performance or to
extend capabilities and use
Funding sources for the various Y2K projects includes county. state. and federal sources
i'
0 0
YEAR 2000 PROJECT SCHEDULE
JANUARY 1999
Issue a Year 2000 status report.
Meet with the Mayor and Managing Director to review Y2K progress. Additional penodic meetings
will be held throughout the year.
Conduct a Y2K presentation for the County Council to review Y2K project status. Additional status
updates will be provided throughout the year as needed
Coordinate a meeting with representatives from Data Processing Division, Police Department. and
Prosecuting Attorney to review overall Y2K project status to date and upcoming needs and activities.
Conduct follow -ups where needed with County departments and agencies to obtain additional
information for the County's Y2K surveys.
Conduct follow -ups where needed with outside information technology service providers (vendors
and other government organizations) who have not responded to earlier Y2K Readiness
Questionnaire forms sent out by the County.
Final Y2K data flow and validation testing is expected to be completed for the Budget System
running on the County's central Wang computer system.
FEBRUARY 1999
Prepare a general Y2K Status Disclosure Notice that can be used to reply to the numerous Y2K
inquines expected. This can also be distributed to outside parties as desired.
Add a Y2K status information page to the County's Internet web site (www.hawaii - county.com).
Meet with Y2K coordinators from all County departments and agencies to review overall Y2K
project status to date and to announce upcoming activities.
Complete initial research and issue a preliminary advisory to all County departments and agencies
regarding the Y2K status of various "commercial off -the- shelf" (COTS) software packages in
common use based upon the Y2K survey results.
Develop a Y2K letter and survey to send out to major essential service providers whose products and
services have a direct impact upon the basic daily living needs of Big Island residents (e.g., utilities.
communications, inter - island transportation. etc.). At the same time, inform these organizations of
the County government's Y2K initiatives and status using the 72K Status Disclosure Notice that was
developed in January.
-6-
0 0
Conduct a survey to obtain baseline Y2K information pertaining to "embedded chip" and "process
control" products and systems in use by various County depatunents and agencies. This information
will be compiled and used to determine the Y2K impact upon vanous related cntical services. which
the County provides to its citizens. It will facilitate Y2K planning and tracking of progress in these
areas to ensure they will be Y2K ready in time.
Begin coordinating installation of Y2K- compliant LAN replacement system and claims management
soft\\ are package at the Safety Coordinator's Worker Compensation Unit.
Begin planning for Public Works' Automotive Division Y2K software conversion for their fleet
management application. A bid will have to be put out through Purchasing Division for a new Y2K-
compliant LAN replacement system
Final Y2K data flow and validation testing is expected to be completed for the following applications
running on the County's central Wang computer system'
Accounting System
Improvement District Billing
Public Works Permitting System (Building. Electrical, Plumbing, Signs)
MARCH 1999
Compile the basic information regarding Y2K preparedness and plans from the essential service
providers for subsequent distribution as requested by citizens and organizations. If feasible, post a
summary on the County's Internet web site.
Final Y2K data flow and validation testing is expected to be completed for the following applications
running on the County's central Wang computer system.
Bicycle Licenses
Library Information System
Real Property Inquiry (on the County's central computer system)
Senior Citizen Registration System.
Meet Huth representatives from Data Processing Division, Police Department, and Prosecuting
Attorney to review overall Y2K project status to date and upcoming needs and activities.
Conduct follow -ups where needed with County departments and agencies to obtain additional Y2K
status and progress information relating to areas being tracked.
Conduct follow -ups where needed with outside information technology service providers (vendors
and other government organizations) to obtain more current Y2K status information for items being
tracked.
-7-
•
0 0
APRIL 1999
Issue a Year 2000 status report.
Meet with Y2K coordinators from all County departments and agencies to review overall Y2K
project status to date and to announce upcoming activities.
Update the County's general Y2K Status Disclosure Notice and information on the County's Internet
web site
MAY 1999
Develop a list of the County's major vendors who provide critical goods. supplies, and services that
are generally required for the County government to operate. Send them Y2K Readiness
Questionnaires to ascertain their ability to continue to provide these items to the County government
beyond 12/31/99. Note... technology providers" should have already been surveyed
prior to this and need not be included with this survey.
JUNE 1999
Complete the implementation of the conversion to dial -up access to the County's central computer
system for various County departments and agencies affected on the Hilo side of the island.
Conduct follow -ups where needed with County departments and agencies to obtain additional Y2K
status and progress information relating to areas being tracked.
Conduct follow -ups where needed with outside information technology service providers (vendors
and other government organizations) to obtain more current Y2K status information for items being
tracked.
Meet with representatives from Data Processing Division. Police Department. and Prosecuting
Attorney to review overall Y2K project status to date and upcoming needs and activities.
JULY 1999
Issue a Year 2000 status report.
Meet with Y2K coordinators from all County departments and agencies to review overall Y2K
project status to date and to announce upcoming activities.
Update the County's general Y2K Status Disclosure Notice and information on the County's Internet
web site.
-8-
•
0 0
Review need for and develop contingency plans for all critical computer applications. computer
systems. embedded chip and process control products and systems. Also, consider outside services
where justified.
Issue an updated advisory to all County departments and agencies regarding the Y2K status of various
"commercial off - the - shelf " (COTS) software packages to common use based upon the Y2K
survey results and provide recommendations.
AUGUST 1999
Conduct Y2K status follow -ups where needed with major essential service providers whose products
and services have a direct impact upon the basic daily living needs of Big Island residents (e.g..
utilities. communications, inter - island transportation, etc ). These providers were to have been
originally surveyed in February.
Finalize contingency plans for all computer applications. computer systems, embedded systems, and
outside services where justified.
SEPTEMBER 1999
Conduct follow -ups where needed with County departments and agencies to obtain additional Y2K
status and progress information relating to areas being tracked.
Conduct follow -ups where needed with outside information technology service providers (vendors
and other government organizations) to obtain more current Y2K status information for items being
tracked.
Meet with representatives from Data Processing Division. Police Department. and Prosecuting
Attorney to review overall Y2K project status to date and upcoming needs and activities.
issue a Year 2000 status report.
Update the County's general Y2K Status Disclosure Notice and information on the County's Internet
web site.
Complete the implementation of the conversion to dial -up access to the County's central computer
system for various County departments and agencies affected on the Kona side of the island.
OCTOBER 1999
Meet with Y2K coordinators from all County departments and agencies to review overall Y2K
project status to date and to announce upcoming activities.
Issue an updated advisory to all County departments and agencies regarding the Y2K status of various
"commercial off -the- shelf " (COTS) software packages in common use based upon the Y2K
survey results and provide recommendations.
-9-
•
0 0
NOVEMBER 1999
issue a Year 2000 status report.
Conduct an update for the benefit of the County Council to review Y2K project status
Update the County's general 1'2K Status Disclosure Notice and information on the County's Internet
web site.
Review. update. and finalize any contingency plans to be used.
DECEMBER 1999
Conduct any additional assurance testine deemed necessary for critical computer systems and
applications or other areas of concerns.
Issue any final Y2K alerts such as reminder PC users to check their date upon restarting their
computers when they return to work in January, 2000.
Conduct an update for the benefit of the County Council if necessary to review Y2K project status.
Update the County's general 1 Status Disclosure Notice and information on the County's Internet
web site
Hold a final meeting before the turn of the century with Y2K coordinators from all County
departments and agencies to discuss final planning and implementation issues related to the rollover
to the new century.
JANUARY FEBRUARY 2000
Issue a final Year 2000 status report based upon any problems that may have occurred as a result of
the rollover to the Year 2000.
If necessary, meet with Y2K coordinators from all County departments and agencies to review and
discuss fall out issues related to operating in the new century.
.I0-
•
YEAR 2000 Mainframe & Minicomputer Computer Applications Survey (as of 01/11/99)
Application Name County Impor- Computer Support Organization Y2K Status Y2K Estimated Comments
Agency Lance System Costs Completion
Date
Payroll Accounts "•• Wang VS 6230 Data Processing Y2K Compliant r Completed Internally compliant May want to
test data exchanges if outside
vendors allow.
Purchase Order System Purchasing *In' Wang VS 6230 Data Processing Y2K Compliant Completed
Sewer Billing Wastewater '•• Wang VS 6230 Data Processing Y2K Compliant Completed Tested and is compliant May
want to test Dec- January billing O
boundaries.
Molor Vehicle Treasury "'• IBM C & C Honolulu Y2K Compliant Completed City gave assurance the system is
Registration Mainframe _ compliant.
Drivers Licensing Police "•• IBM C & C Honolulu Y2K Compliant Completed City gave assurance that the
Mainframe _ system is compliant
Voters Registration Elections ••" IBM C & C Honolulu Y2K Compliant Completed City gave assurance the system is
Mainframe compliant. _
Offender Based Tracking Police "" IBM State Y2K Compliant Completed State gave assurance the system is
System — OBTS Mainframe I compliant.
Juvenile Justice Police ••• IBM State Y2K Compliant Completed State gave assurances that the
Information System JBIS Mainframe system is compliant.
National Crime Police •"' Mainland C & C Honolulu Y2K Compliant Completed City gave assurance the system is
Information Center NCIC Mainframe compliant.
Manual Accounting Accounts "• Wang VS 6230 Data Processing Y2K Compliant Completed
Wai rants
Manual Payroll Warrants Accounts "" Wang VS 6230 Data Processing Y2K Compliant Completed
Inventory/Fixed Assets Accounts ••• Wang VS 6230 Data Processing Y2K Compliant Completed
(Equipment, Real O
Ihoperty, Buildings,
Streets, )
- enietery Plots Parks & ••• Wang VS 6230 Data Processing Y2K Compliant Completed
Recreation
3 g Licenses Treasury "" Wang VS 6230 Data Processing _ Y2K Compliant Completed
I imekeeping System Elections •• Wang VS 6230 Data Processing Y2K Compliant Completed_
Wang WP and W P+ Word Data "" Wang VS 6230 Data Processing Y2K Compliant Completed Vendor gave written assurances
Processing Processing that the product is Y2K conrpha:if
Wang Office E - Mail Data '"" Wang VS 6230 Data Processing Y2K Compliant Completed Vendor gave written assurances
__ Processing _ that the product is Y2K compliant
SNA Communications to Data "• Wang VS 6230 Wang Global Y2K Compliant Completed Vendor gave written assurances
- mined to C &C Ionolulu Processing that the product is \'2K compliant
and the State of Hawaii r
Table A
Application Name County Impor- Computer Support Organization \'2K Status Y2K Estimated Comments
Agency tance System Costs Completion
Date
Data Fnny Package Data *** Wang VS 6230 Data Processing ¥2K Compliant Completed
_ _ Processing__
D('l'A Contractor File Building * ** IBM State Y2K Compliant Completed State gave written assurance the
Ingin _ Mainframe jpplicatmn is compliant - —
Bridget Budget * ** Wang VS 6230 Data Processing to be validated 1/99 Initial assessment and fixes
completed
I rallic Accidents & Police * ** Wang VS 7010 Police To be assessed 1/99
Citations
Planning Permit 'Tracking Planning * ** Wang VS 6230 Data Processing To be assessed 1/99 Already has some Y2K issues to he
fixed O
Land Use Inventory Planning +* Wang VS 6230 Data Processing To be assessed 1/99 Needs assessment and possible
Fixes
Accounting System Accounts * ** Wang VS 6230 Data Processing To be validated 2/99 Initial assessment and fixes
completed
Improvement District 7 ur
7easy * ** Wang VS 6230 Data Processing To be validated 2/99 Initial assessment and fixes
Billing completed —
Public Works Building, Building * ** Wang VS 6230 Data Processing To be validated 2/99 Initial assessment and fixes
Electric, Plumbing, Sign completed.
Penn its .
Bicycle Licenses Treasury * ** Wang VS 6230 Data Processing To be validated 3/99 Initial assessment and Fixes
completed.
Library Information Research & * ** Wang VS 6230 Data Processing To be validated 3/99 Initial assessment and fixes
System I )eve lopme completed.
nt
Real Property Inquiry Planning ** Wang VS 6230 Data Processing To be validated 3/99 Initial assessment and fixes
completed.
Senior Citizen Aging ** Wang VS 6230 Data Processing To be validated 3/99 Initial assessment and fixes
Registration completed
—
Police Alpha Crime File Police * ** Wang VS 7010 Police To be assessed 3/99
Arrestee File Police * ** Wang VS 7010 Police To be assessed 3/99 _
Juvenile Arrestee File Police * ** Wang VS 7010 Police To be assessed 3/99
Stolen /Recovered Police * ** Wang VS 7010 Police To he assessed 3/98
Property file
I de Access Case Tracking Prosecuting * ** Wang VS 7010 Prosecuting Attorney To be modified 4,000 est 6/99 Outside Vendor (LANG Group) is
System - FACTS Attorney _ _collecting fur Y2K _ _—
Speed II Software Pwsecutmg * +* Wang VS 7010 To be assessed 6/99 LANG Group will be testing along
Package _ Attorney with FACTS upgrade
I ightspced Software Prosecuting * ** Wang VS 7010 Lnghtspeed Software To be upgraded 6/99 Upgraded pr ov riled no cost, Ilios
Emulation Package Attoi ney Attorney staff to install
Real R opeity Tax and Real + *+ IBM C & C Honolulu '1 o be modified 6/99 Outside Vendor is correcting fun
Assessment System Property Mainfiame _ ¥2K
Application Name County lining- Computer Support Organization V2K Status V2K Estimated Comments Agency tance System Costs Completion
Date
l ountil I egislative Index County * ** Wang VS 6230 Data Processing I be replaced 6/99 Vendor (Wang (dohal) is
531l!k1121. _ - __ -_ l lei 6 - _ _ _ Iymentmg a new system
I .meigency 911 Police tit** G FE 'I a he replaced 9/99 Vendor to implement —_
Water Billing System Water * ** IBM AS 4110 Water "hi he modified 9/99 Long range plan is tot eplat e
or replaced Interim plan is upgrade as needed
by 9/99
Water Department Payroll Water * ** IBM AS 400 Water to he mod rfied 9/99 Lung range plan is to replace
or replaced Interim plan is upgrade as needed
- - - -- -- - -- - - -- -_
by 9/99
Water Department Daily Water *** __ _ IBM AS 400 Water 'I o he modified 9/99 Long range plan is to replace O
( "ash Receipts or replaced Inter im plan is upgrade as needed
by 9/99
Resource Information Coordinate * Wang VS 6230 Data Processing To be assessed 9/99 Assessment deferred, may he
System for Seniors d Services discontinued
I lo'rke Legislative Inquiry Legislative * IBM State "lo he N/A State to discontinue application
Auditor Mainframe discontinued rather than make Y2K correct
To he replaced with Internet access
-__ - system.
0
Year 2000 PC /LAN Applications Survey (as of 1/11/99)
N A
O 0
m 0 c
u d n o
C -
it m y t ry
o a System's Application Support x E E y E
Application Name County Organization E Operating System vendor Y2k Status y a w Y V Comments
Motor Vehicle Daily Posting FINANCE- TREASURY "' WINDOWS 95 Data Processing Division Y2k Compliant Completed
COMMUNITY 2020 for HUD Grants HOUSING & COMM DEVLP " NOVELL 4 1 LAN HUD Y2k Compliant Completed LAN to be replaced
Timecard /Satelite ( Acctg) HOUSING & COMM DEVLP "' NOVELL 4 1 LAN APPLIED LOGIC Y2k Compliant Completed LAN to be replaced
MAS 90 (Acctg) HOUSING & COMM DEVLP "' NOVELL 4 1 LAN Taketa Iwata Hara Y2k Compliant Completed LAN to be replaced O
MICRO HUD HOUSING & COMM DEVLP "' DOS/WINDOWS RENT ROLL, INC Y2k Compliant Completed LAN to be replaced
OTG Document Imaging HOUSING & COMM DEVLP "' WIN NT LAN Paradise Canyon Y2k Compliant Completed LAN to be replaced
Fleet Mamt for Windows MASS TRANSIT "' Windows 95 LAN DPSI Y2k Compliant Completed
Mitchell On -line Repair Demand PWRKS- AUTOMOTIVE " DOSNVINDOWS Mitchell Repair Info Y2k Compliant Completed
Job CostSystem/Budget Module PWRKS- HIGHWAYS " WINDOWS 95 Crawford Business System Y2k Compliant Completed
Computer Aided Dispatch POLICE /FIRE "' WIN NT LAN Intergraph Public Safety To be assessed 04/99 Per Contract, to be Y2k compliant
ACCPAC Plus Acctg Package PWRKS- SOLID WASTE "' WINDOW S 3.x C omputant Comp ut C on. To be upgrade d 04/99 Getting Quotes for Upgrade
CLERK - COUNCIL
Legislative History Database SERVICES '•• WIN NT LAN WANG GLOBAL To be validated 06/99 Per Contract, to be Y2k compliant
VSIGN Voters Signature Registration COUNTY- ELECTIONS "' WINDOWS 95 Mike Sato To be validated 06/99 Compliant, but tope validated
Integrity Elections Mgt Software COUNTY- ELECTIONS "' WIN NT LAN State of Hawaii - Elections _ To be validated 06/99 Compliant, but to be validated
Records Management System FIRE "' WIN NT LAN Sun Pro To be assessed 06/9 0
Upon last conversation, it was Y2k
CAMEO Hazmat Mgt Software FIRE "' WINDOWS 95 NOAA -EPA To be assessed 06/99 compliant
NAN MCKAY PHA MANAGER (Acctg) HOUSING & COMM DEVLP "' NOVELL 4.1 LAN NAN MCKAY To be replaced 06/99 To be replaced by Master Software
Comp2000 Workers Comp INDUSTRIAL SAFETY "' Lantastic LAN David Corp To be replaced 42,700 06/99 To be replaced with Renaissance
LIPS (Permit Tracking /Land Use) PLANNING " NOVELL 4 01 LAN Richard Paley To be assessed 06/99 Dept to decide on future use
Covered under software
Real Property Cashiering System FINANCE- REAL PROP "' Lantastic LAN Computer Store To be assessed 06/99 maintenance
Covered under software
Gasboy Fuel Management PWRKS- AUTOMOTIVE "' DOSNVINDOWS '`M Nakai Repair Service To be replaced 08/99 maintenance
Liquor Control Info System LIQUOR CONTROL "' NOVELL 3 x LAN WANG GLOBAL May upgrade 7,000 esl 09/99 (Looking at Alternatives
Table B
Year 2000 PC /LAN Applications Survey (as of 1/11/99) .
co
m
m 0
m U c
a o
qC N m
L m m
n System's Application Support y E E E
Application Name County Organization E Operating System vendor Y2k Status y U w Y U Comments
Fairbanks Datamaster Scales PWRKS- SOLID WASTE "' DOS Centerscale Automation To be upgraded � 09/99 Getting Quotes for Upgrade
I
Toledo Scale Model I PWRKS- SOLID WASTE "' i DOS Toledo Scale Hawaii To be upgraded : 09/99 Getting Quotes for Upgrade
MP2 Wastewater Maintenance PWRKS- WASTEWATER "' WINDOWS 95 Datastream To be assessed 09/99 Waiting for vendor's response
Awaiting for Purchasing's action on
Fleet Maint/Fuel Log for Windows IPWRKS- AUTOMOTIVE "' WIN NT LAN IDPSI Y2k Compliant I 3,100 09/99 est hardware bid
0
0
YEAR 2000 WANG & IBM Minicomputer / Word Processor Computer System Survey
(as of 01/11/99)
Computer System Name County Organization Impor- System Y2K Status Y2K Cost Est. Y2K Comments
Lance Support Completion
Wang VS6230 Finance / Data Processing Div "' Wang \'2K Compliant 389,000 Completed County's main computer system Expect to retest
_ complete system again in 10/99 O
Wang 01550 Police Department (North Kohala) • None Jse as standalone system Completed Back Date CPU Limited time & materials
maintenance support expected
Wang 01550 Civil Defense "• Wang Replaced with dial -up $15,000 2/99 Users follow -up training to be done
Finish user training
Wang VS7010 Police Department (Hilo) '•• Wang To be validated 6/99 Y2K Hardware /software upgrades have been
' nstalled Partial validation testing done
Wang VS7010 Prosecuting Attorney (Hilo) '•• Wang To be validated 6/99 Y2K Hardware /software upgrades have been
'installed.
Wang VS65 Finance / Data Processing Div Wang To replace with dial up $2,400 est 6/99 Office of Aging & Police Commission completed
+ 5 agencies (Hilo Lagoon Ctr.) Civil Service & Liquor Control remain
Wang 01570 Parks & Recreation ••• Wang To replace with dial up 317,300 est 6/99 two dial in access currently in use Add three
Elderly Activities Division (Hilo) more _
Wang 01570 Public Works Wastewater Div ••• Wang To replace with dial up $1,800 est 6/99 Finalize migration plans in 2/99
+2 agencies
Wang 015140 Police Department (Puna) '• Wang Use as standalone system 3350 7/99 Back date CPU Limited time & materials
Add one dial -up PC access maintenance support expected
Wang VS65 Police Department (Kona) ••• Wang Use as standalone system 3350 7/99 Back date CPU Limited time & materials
Add one dial -up PC access. maintenance support expected
Wang VS65 Prosecuting Attorney (Kona) '•' Wang To be upgraded $19,000 est 9/99 Bid was conducted
System to be upgraded to VS /6000
Wang VS65 Finance / Data Processing Div ""' Wang 4o replace with dial up $6,600 est 9/99 Finalize migration plans in 3/99 O
+ 6 agencies (Kona Service Ctr )
Wang 01S70 Parks & Recreation "•• Wang 7o replace with dial up $6,500 est 9/99 One dial in access in use
Elderly Activities Division (Kona) Finalize migration plans in 2/99
IBM AS/ 400 -C20 Water Supply Department ••• IBM Upgrade current system or $10,000 est 9/99 Long range plan is to replace Interim plan is
replace with new system to upgrade .rpgrade as needed by 9/99
Table C
Year 2000 PC -Based LAN Computer Systems Surveys (as of 1111199)
d
o o
o 0
U c
E o
o
m o
u E 9 E
E a E
0 E U
Computer System Name County Organization System Support vendor E Y2k Status y w > Notes /Comments O
WINDOWS NT LAN COUNTY- ELECTIONS State of Hawaii - Elections "' Y2k Compliant Completed Per State, Should be Y2k compliant
WINDOWS 95 Peer -to -Peer LAN MASS TRANSIT NONE "' Y2k Compliant Completed Windows 95 Peer -to -Peer
WINDOWS NT LAN PROSECUTORS State of Hawaii "' Y2k Compliant Completed Presumably, Ali Y2k compliant
WINDOWS NT LAN PWRKS - ADMINISTRATION Prof. Computer Svcs "' Y2k Compliant Completed
NOVELL LAN COUNTY- ELECTIONS NONE "' To be upgraded 2,000 est 04/99 NOS to be upgraded in April, 1999
WINDOWS NT LAN FINANCE -DATA PROCESSING Prof Computer Svcs "' To be validated 04/99 Per Contract, All Y2k compliant
WINDOWS NT LAN POLICE Intergraph Public Safety "' To be upgraded 04/99 Being upgraded now
In Development, Per contract- Y2k
WINDOWS NT LAN CLERK - COUNCIL SERVICES WANG GLOBAL "' Y2k Compliant 06/99 Compliant
NOVELL LAN LIQUOR CONTROL Computer Store "' To be replaced 06/99
NOVELL LAN PLANNING Prof Computer Svcs "' To be upgraded 06/99 Hardware Okayed Per Vendor
WINDOWS NT LAN PWRKS - WASTEWATER Kona Computers "' To be assessed 06/99 Awaiting Reply from Vendor
WINDOWS NT LAN PWRKS - WASTEWATER Kona Computers "' To be assessed 06/99 Awaiting Reply from Vendor
LANTASTIC Peer -to -Peer LAN INDUSTRIAL SAFETY NONE "' To be replaced 22,500 est. 06/99 est Install Plans are In progress
Awaiting for Purchasing's action on
NOVELL LAN PWRKS- AUTOMOTIVE Prof Computer Svcs "' To be replaced 16,000 est 09/99 est hardware bid
NOVELL LAN #1 (HOUSING & COMM DEVLP Prof Computer Svcs "' To be replaced 89,000 est 09/99 (Y2k Written Consent by Vendor
NOVELL LAN #2 ;HOUSING & COMM DEVLP Prof Computer Svcs "' To be replaced 58,000 est 109/99 1Y2k Written Consent by Vendor
Table D
Year 2000 Personal Computers Survey (as of 1111199)
Y2k Compliant? Importance Y2k Action Required
0 o
W O N
J o
N Cl y
N N
O d , N
C ›- C o
In 5 IS r
A N
a
•
m
d �
F u m m � L° � � c
County Organization ° y y z z a f 3 z D co ¢ Y2K Cost NOTES/COMMENTS
AGING 5 4 1 4 1 4 1 Replace with Fed. Funds by 04/99 O
CIVIL DEFENSE 2 2 2 2
CIVIL SERVICE 14 13 1 4 8 2 13 1
CLERK - COUNCIL 31 31 31 31 _
CLERK - ELECTIONS 22 7 15 22 7 15
CLERK -LEG AUD 15 15 15 15
CORP COUNCIL 17 17 17 17
FINANCE - ACCOUNTS 10 10 2 8 10
FINANCE -ADMIN 3 3 3 3
FINANCE - BUDGET 2 2 2 2
FINANCE -DATA PROCESSING 31 13 18 4 27 13 18
FINANCE - PURCHASING 6 6 5 1 6
FINANCE -REAL PROPERTY 20 5 15 18 2 5 14 1 21,000 est. Part of LAN installation Replace by 04/99.
FINANCE - TREASURY 2 2 2 2
FIRE 13 9 4 2 10 1 9 4 O
HOUSING & COMM DEVLP 36 15 21 29 1 6 15 21 27,000 est Part of LAN installation. Replace by 06/99.
INDUSTRIAL SAFETY 5 1 4 5 1 4 4,500 est Part of LAN installation. Replace by 06/99
LIQUOR 3 3 1 2 3
MASS TRANSIT 3 3 3 3
MAYOR - CLERICAL SVCS 4 3 1 4 3 1
MAYOR'S OFFICE 2 1 1 2 1 1
P &R -ADMIN 5 5 1 2 2 5
P &R- AQUATICS 3 1 2 2 1 1 2
P &R- CULTURE /ARTS 1 1 1 1
P &R- EAD -CSE 8 8 3 5 8
P &R -EAD- NUTRITION 3 1 2 3 1 2
Table E
Year 2000 Personal Computers Survey (as of 1111199) •
Y2k Compliant? Importance Y2k Action Required
N o
m o 2
J
N N N
N N
r W
C Y O 3
f a o o
N L N W W A N
o.
W 7
N N f- a V c E = y c
3 County Organization ° y y z i a f i m w w u Y2K Cost NOTESICOMMENTS
P &R- EAD -REC 2 1 1 1 1 1 1 O
P &R -EAD -RSVP 2 2 1 1 _ 2
P &R- EAD -SR EMPL _ 6 1 1 4 2 4 1 1 4
P &R -GOLF 4 2 2 3 1 2 2 _
P &R MAINTENANCE 4 4 4 4 __
P &R- RECr2EATION _ 4 4_ 3 1 4 _
P &R -ZOO 1 1 1 1
PLANNING 37 19 17 1 36 1 19 17 1
POLICE 106 44 25 17 20 106 44 25 37
PROSECUTING ATTORNEYS 39 8 31 39 8 31
PWRKS -ADMIN 15 15 15 15
PWRKS- AUTOMOTIVE 7 1 6 7 1 1 5 7,500 est. Part of LAN installation. Awaiting Bid
PWRKS - BUILDING _ 13 7 6 _ 4 7 2 7 6
PWRKS - ENGINEERING 18 15 2 1 6 11 1 15 2 1
PWRKS- HIGHWAYS 10 10 _ 10 10
PWRKS - SOLIDWASTE _ 5 1 4 1 3 1 1 4 O
PWRKS - TRAFFIC 8 7 1 _ 8_ 7 1
PWRKS - WASTEWATER 9 6 1 2 7 2 6 1 2
RESEARCH & DEVLP 8 8 8 8
WATER -ENGR 4 4 4 4
WATER - FIN 8 7 1 6 2 7 1
WATER -OPNS 5 5 1 4 5
WATER -OPNS KONA 2 1 1 1 1 1 1
GRAND TOTALS 583 350 111 68 54 348 167 68 350 1 45 105 82 60,000 est