State of Washington Department of Ecology

Information Technology Tactical Plan

September 1997
Revised November 1997

In accordance with guidance from the Department of Information Services (DIS), this plan is limited to projects related to the Year 2000 problem. Ecology has identified its "mission-critical systems" (see definition below) which have been prioritized using the following criteria provided by DIS:

1. Maintenance of public health and safety
2. Income maintenance for citizens
3. Income maintenance for government employees
4. Payments to vendors for goods and services
5. Requirements for compliance or regulation
6. Effect on state government cash flow
7. Recovery costs
8. Effect on production and delivery of services
9. Volume of activity
10. Effect on public image
11. Intersystem dependency (external system)

None of Ecology's mission-critical systems can be certified at this time as "Year 2000 compliant" (see definition below). The appendix to this document presents high-level project plans to address each of these systems to assure that "there will be no interruption of vital public services or loss of accountability of public resources as a result of the Year 2000 Date Change Problem."

The Administrative Services Manager, a member of Ecology's Senior Management Team, is the executive sponsor of Ecology's Y2K Program. Ecology assigned a Y2K Program Coordinator in 1995 and each program appointed a lead person. The Y2K Program Coordinator and the program leads constitute Ecology's Y2K Work Group. Each Ecology program is responsible for developing and implementing a plan to address their program-specific systems. The Information Services Section is responsible for agencywide systems, including financial and administrative systems, and for compiling the agencywide plan.

Ecology's Y2K Work Group members worked with their respective program management teams to identify their computer systems with the greatest business impact (i.e., "mission critical" systems). The agencywide plan was reviewed by Ecology's Information Services Council (an agencywide technical direction setting group) and by executive management. After the original publication of this plan in September 1997, Ecology's IS Executive Steering Committee continued to refine the list of the agency's mission-critical systems. This amended list of mission-critical systems is presented below.

"Mission-critical systems" are defined by DIS as automated systems that are essential to the agency to complete required legal obligations or legislatively mandated business functions. Additionally, any system that could jeopardize the health, safety, or financial well being of the citizens or employees of the State of Washington should be considered mission-critical.

"Year 2000 Compliant" is defined by Ecology as follows:

1. Any date data stored in Ecology information technology (IT) components and systems will use four digit year formats. This excludes components used to bridge to non-Ecology systems, and also excludes archived data and scanned images.
2. Any date displayed or printed must either show all four digits of year or the year must be obvious to users of the output.
3. IT components and systems will perform as specified with any valid system date from January 1, 1980 through December 31, 2049. All clocks shall be checked to verify that they correctly roll over from the following dates: 12-31-1998; 9-9-1999; 12-31-1999; 2-28-2000; 3-1-2000; 12-31-2000; 1-1-2001; and 12-31-2027. It is acceptable that manual intervention be used to set the proper year on PCs on 01-01-2000.
4. IT components and systems will perform as specified with any transaction data with valid dates from January 1, 1800 through December 31, 9999. Dates of special concern include: 9-9-1999; 12-31-1999; 1-1-2000; and 2-29-2000.
5. No Ecology developed IT components or systems shall use special date values as logical flags. "0000" or "9999" may be used in the year field when a numeric entry is required.
6. Any Ecology IT component or system defined as year 2000 compliant shall have stored test results which prove compliance, or have legal documents from the supplier of the resource which warrant compliance. Where possible, all business critical IT components or systems shall be tested by Ecology staff.

The table below lists Ecology's mission-critical systems by agency program. The key to the criteria identified in this table is presented in the Introduction to this document. Following the table are the high-level project plans to address Y2K issues for each of Ecology's noncertified mission-critical systems.

The following pages present the high-level project plans to address Y2K issues for each of Ecology's noncertified mission-critical systems. The following information is presented for each system:

System Name:

Description: Description of the major business functions and activities supported by the system.

Business Risk: Description of the business risk (most likely business impact) to the agency if the system is not Y2K compliant.

Platform: PC/LAN, minicomputer, mainframe computer

Software: Major system software including data base, front end, reporting tools, and other software.

First Failure Date: Most likely first failure date if the system is not Y2K compliant.

Planned Test Start Date: Start date of planned testing if there are no known Y2K problems.

Planned Conversion Start Date: Start date of planned conversion if there are known or suspected Y2K problems.

Planned Certification Date: Date by which Ecology plans to certify Y2K compliance to DIS.

Staff Time Required (hours): Resource estimate for conversion, testing, and certification.

External Interfaces: Other systems which provide and/or receive data from this system. These do not include any systems within Ecology which interface this system.

Ecology Program: Ecology program which has primary business responsibility for this system.

System Name: TELEPHONE CALL HANDLING SYSTEM (CONVEYANT)

Description: Provides telephone call handling (including employee/expertise directory) capability for selected Ecology facilities.

Business Risk: Ecology would lack an effective and efficient telephone call handling capability for the reception desks at several Ecology facilities. This would adversely impact the reception function at these facilities.

Platform: PC/LAN

Software: Conveyant

First Failure Date: 1/1/2000

Planned Test Start Date: Not applicable

Planned Conversion Start Date: The agency currently is converting to Microsoft Exchange as part of Ecology's migration to a 32-bit desktop environment and an enterprise network operating system. A 32-bit version of Conveyant has been announced by the vendor and Ecology also plans to evaluate to feasibility of replacing the functionality of Conveyant with a planned agency-level employee database and telphone dialing capability native to the computer operating system.

Planned Certification Date: Not scheduled at this time.

Staff Time Required (hours): Unknown at this time.

External Interfaces: None

Ecology Program: Administrative Services

System Name: ELECTRONIC MESSAGING

Description: Provides agencywide E-mail, calendaring, and "bulletin board" including Internet mail.

Business Risk: Ecology would lack an effective and efficient E-mail, calendaring, and bulletin board capability which would seriously impact internal electronic communications as well as electronic communications between Ecology staff and agency clients and partners.

Platform: PC/LAN

Software: Microsoft Exchange and Outlook

First Failure Date: 1/1/1999

Planned Test Start Date: Not applicable

Planned Conversion Start Date: Not applicable. The agency currently is converting to Microsoft Exchange as part of Ecology's migration to a 32-bit desktop environment and an enterprise network operating system.

Planned Certification Date: 7/1/1998

Staff Time Required (hours): Unknown; effort will be coordinated with other agencies via the State Exchange Administrators Group.

External Interfaces: DIS

Ecology Program: Administrative Services

System Name: ENVIRONMENTAL INFORMATION MANAGEMENT (EIM)

Description: Tracks sample, study and station environmental data

Business Risk: Ecology would lack a comprehensive, integrated environmental data base for use in its various activities to protect the environment and public health.

Platform: Minicomputer

Software: Sterling Software COOL:Gen, Sybase, ArcView

First Failure Date: 1/1/2000

Planned Test Start Date: 10/1/1997

Planned Conversion Start Date: Not applicable

Planned Certification Date: 12/1/1997

Staff Time Required (hours): Claremont Technology Group (consultant)

External Interfaces: None

Ecology Program: Administrative Services

System Name: FACILITY/SITE IDENTIFICATION SYSTEM (FSID)

Description: Spatial and tabular identification of facilities/sites Ecology is interested in

Business Risk: Ecology would lack a comprehensive, integrated facility/site data base and such data would be managed much less efficiently and effectively.

Platform: Minicomputer

Software: Sterling Software COOL:Gen, Sybase, ArcView

First Failure Date: 1/1/2000

Planned Test Start Date: 10/1/1997

Planned Conversion Start Date: Not applicable

Planned Certification Date: 12/1/1997

Staff Time Required (hours): Claremont Technology Group (consultant)

External Interfaces: None

Ecology Program: Administrative Services

System Name: PUBLICATION DISTRIBUTION SYSTEM (PDS)

Description: Assists in the control and distribution of educational and other printed material to the public or agency staff

Business Risk: Ecology's public image would be harmed as public service would be impaired.

Platform: PC/LAN

Software: Paradox 3.5, Crystal Reports 4.0

First Failure Date: 1/1/2000

Planned Test Start Date: Not applicable

Planned Conversion Start Date: Not applicable. This system will be converted to Access 97 as part of Ecology's migration to a 32-bit desktop environment.

Planned Certification Date: 7/1/1999

Staff Time Required (hours): 80

External Interfaces: None

Ecology Program: Administrative Services

System Name: WORKFORCE MANAGEMENT SYSTEM

Description: This is a set of systems used by Employee Services to:

• Track training and produce sign-up sheets and cancellation/no-show reports.
• Download data from Department of Personnel and Office of Financial Management to populate local systems.
• Tracks status of personnel actions.
• Tracks vacant positions and positions scheduled to be cut. Includes history.
• Tracks status of non-permanent assignments, produces notification that assignments are scheduled to end. Used for reduction-in-force reporting.
• Tracks Affirmative Action goals and current status in compliance with state and federal laws.

Business Risk: There are federal and state laws and regulations governing workforce management that would be violated and could result in lawsuits.

Ecology may not be able to identify options for employees at-risk of losing their positions during the reduction-in-force. This could result in loss of pay or loss of state employment for the employee and would put Ecology at risk of lawsuits.

Platform: PC/LAN and mainframe (DIS) (employee data acquisition only)

Software: Paradox 3.5 and 3.51, Microsoft Access 2.0, and Focus (employee data acquisition only)

First Failure Date: 6/1/1996 through 1/1/2000

Planned Test Start Date: Not applicable

Planned Conversion Start Date: Not applicable. This system will be converted to Access 97 as part of Ecology's migration to a 32-bit desktop environment.

Planned Certification Date: 6/30/1998 through 6/30/1999

Staff Time Required (hours): 310 (Conversion, testing, and certification)

External Interfaces: HRIS (employee data acquisition only)

Ecology Program: Employee Services

System Name: L & I CLAIM TRACKING

Description: Tracks and assists in managing L&I worker compensation claims reported to the Ecology Safety Office.

Business Risk: Monetary impact - improperly managed worker claims would increase worker compensation premiums paid to L&I by the agency and by employees. May also result in penalty payments to L&I.

Platform: PC/LAN

Software: Microsoft Access 2.0

First Failure Date: 1/1/2000

Planned Test Start Date: Not applicable

Planned Conversion Start Date: Not applicable. This system will be converted to Access 97 as part of Ecology's migration to a 32-bit desktop environment.

Planned Certification Date: 7/1/1999

Staff Time Required (hours): 80 (conversion, testing, and certification)

External Interfaces: None

Ecology Program: Employee Services

System Name: MEDICAL MONITORING

Description: Tracks Ecology employees who are required to participate in a medical surveillance program as required by Ch. 296-62 WAC.

Business Risk: Risk to Ecology employee's health from exposure to hazardous materials. Would put Ecology at risk of lawsuits.

Platform: PC/LAN

Software: Microsoft Access 2.0

First Failure Date: 1/1/1995

Planned Test Start Date: Not applicable

Planned Conversion Start Date: Not applicable. This system will be converted to Access 97 as part of Ecology's migration to a 32-bit desktop environment.

Planned Certification Date: 4/1/1999

Staff Time Required (hours): 80 (Conversion, testing, and certification)

External Interfaces: None

Ecology Program: Employee Services

System Name: RESPIRATOR FIT TEST

Description: Tracking of Respirator Fit testing as required by Ch. 296-62 WAC.

Business Risk: Employee health risk from exposure to hazardous chemicals on the job. Would put Ecology at risk of lawsuits.

Platform: PC

Software: FitPro Fit Test Software (dBASE 4)

First Failure Date: 1/1/1999

Planned Test Start Date: Not applicable

Planned Conversion Start Date: 10/1/1997 (New third party software will be purchased and installed.)

Planned Certification Date: 1/1/1998

Staff Time Required (hours): 10 (Testing and certification only.)

External Interfaces: No

Ecology Program: Employee Services

System Name: ACCOUNTS RECEIVABLE

Description: Maintains records for amounts due to Ecology

Business Risk: Financial

Platform: PC/LAN

Software: Microsoft Access 97

First Failure Date: 9/1/1999

Planned Test Start Date: 10/1/1997

Planned Conversion Start Date: Not applicable. This is a new system which is nearing completion. Y2K compliance is a provision of the contract for the development of this system.

Planned Certification Date: 12/1/1997

Staff Time Required (hours): Contractor (Cindy DeGies)

External Interfaces: None

Ecology Program: Financial Services

System Name: AFRS DATA DISTRIBUTION SYSTEM (ADDS)

Description: This system downloads AFRS data from the DIS mainframe and automatically loads it into a Sybase SQL server. Users access the data to perform routine/standard and ad hoc reporting.

Business Risk: Ecology's managers would lack adequate financial information for this decision-making.

Platform: PC/LAN

Software: Microsoft NT Server 4.0, Sybase 11, Microsoft Access 2.0

First Failure Date: 1/1/2000

Planned Test Start Date: Not applicable

Planned Conversion Start Date: Not applicable. This system will be migrated to a data warehouse for other business reasons.

Planned Certification Date: 7/1/1999

Staff Time Required (hours): 40 (Testing and certification only)

External Interfaces: AFRS

Ecology Program: Financial Services

System Name: AGENCY CASH RECEIPTING & REPORTING SYSTEM

Description: Agency cash receipting and reporting system

Business Risk: Financial

Platform: Minicomputer

Software: Prime Info

First Failure Date: 12/24/1999

Planned Test Start Date: Not applicable

Planned Conversion Start Date: Not applicable. A new Sybase/PowerBuilder system has been developed for other business reasons and currently is being tested prior to being put into production. Y2K compliance is a provision of the contract for the development of the new system.

Planned Certification Date: 12/1/1997

Staff Time Required (hours): 10 (Testing and certification of new system)

External Interfaces: AFRS, State Treasurer

Ecology Program: Financial Services

System Name: CONTRACTS & GRANTS PAYABLE

Description: To track and compute amounts to be paid to Ecology's contractors and grantors

Business Risk: Financial

Platform: PC/LAN

Software: Sybase 10, Microsoft Visual Basic 3, Crystal Reports

First Failure Date: 1/1/2000

Planned Test Start Date: Not applicable

Planned Conversion Start Date: Not applicable. This system will be converted to 32-bit prior to 2000 as part of agencywide migration.

Planned Certification Date: 7/1/1999

Staff Time Required (hours): 120 (includes upgrade to VB 5, testing, and certification)

External Interfaces: None

Ecology Program: Financial Services

System Name: FEDERAL GRANTS RECEIVABLE SYSTEM (GRS)

Description: Calculates federal & state shares, direct & indirect, cost allocation and generates AFRS JV's to make AFRS grant data more accurate & timely. downloads & uploads to AFRS

Business Risk: Financial

Platform: Mainframe

Software: NATURAL

First Failure Date: 1/1/1993 when system was put into production

Planned Test Start Date: 10/1/1997

Planned Conversion Start Date: Not applicable

Planned Certification Date: 12/1/1997

Staff Time Required (hours): Contractor (Leo Webb)

External Interfaces: AFRS

Ecology Program: Financial Services

System Name: AIR QUALITY TELEMETRY

Description: Collects statewide ambient air quality data on a real-time basis, warns of air pollution episodes, and provides data for EPA

Business Risk: EPA may declare areas of Washington in violation of air quality standards.

Platform: Minicomputer

Software: C

First Failure Date: 1/1/2000

Planned Test Start Date: Not applicable

Planned Conversion Start Date: Not applicable. This system is being modified for other business reasons.

Planned Certification Date: 8/1/1998

Staff Time Required (hours): 500 (Not all of this time is due to Y2K requirements.)

External Interfaces: Local air pollution control authorities, EPA, US Forest Service, U of W

Ecology Program: Air Quality

System Name: LABCERT

Description: Tracks information on laboratories accredited by Department of Ecology, including municipal, industrial, pre-treatment, tribal, academic, federal, and commercial environmental testing laboratories

Business Risk: Target dates for accreditation process would likely be exceeded; the lab accreditation program could not fully support Ecology staff or regulated public in matters pertaining to accreditation of environmental labs

Software: Paradox 4.5 (current), Access 97 (conversion)

First Failure Date: 01/01/1999

Platform: PC/LAN

Test Start Date: 12/01/1998

Conversion Start Date: 12/01/1997

Y2K Compliant Installed Date: 01/01/1999

Certification Date: 01/01/1999

Staff Time Required (hrs): ?

External Interfaces: None

Ecology Program Code: EILS

System Name: LABORATORY INFORMATION MANAGEMENT SYSTEM (LIMS)

Description: Track status & analytical results of samples in the laboratory

Business Risk: Data on laboratory samples and results would be managed much less efficiently and effectively. Critical client sensitive data would take longer to process.

Platform: PC/LAN

Software: Microsoft Windows NT Server, Oracle, SQR

First Failure Date: Not applicable

Planned Test Start Date: Not applicable

Planned Conversion Start Date: Completed; system tested and verified 8/18/1997

Planned Certification Date: 10/1/1997

Staff Time Required (hours): Completed

External Interfaces: Pending

Ecology Program: EILS

System Name: Emergency Planning and Community Right to know Act (EPCRA)

Description: Manages information from:

• EPA Form R "Toxic Release Inventory (TRI)"
• EPA Tier II chemical storage
• Local Emergency Planning Committees
• Chemical Information

Business Risk: TRI information is used for billing the Hazardous Waste Education Fee which is a necessary source of funds in the HWTR program. Information is used to inform public in compliance with EPCRA.

Platform: LAN/PC

Software: FOCUS for Windows

First Failure Date: 1/1/2001

Planned Test Start Date: 11/1/1997

Planned Conversion Start Date: 1/15/1998

Planned Certification Date: 2/17/1998

Staff Time Required (hours): 80

External Interfaces: EPA Emergency Response Data Systems: EIS and Cameo

Ecology Program: HWTR

System Name: HAZARDOUS WASTE INFORMATION MANAGEMENT SYSTEM (HWIMSy)

Description: Manages information from annual reports submitted by permittees

Business Risk: Inability to determine permit compliance and to respond to public information requests on waste generation and management

Platform: Minicomputer

Software: Sterling Software COOL:Gen, Sybase, Access

First Failure Date: 1/1/2000

Planned Test Start Date: 10/1/1997

Planned Conversion Start Date: Not applicable

Planned Certification Date: 11/15/1997

Staff Time Required (hours): Claremont Technology Group (consultant)

External Interfaces: EPA RCRIS, EPA Biennial Report System (BRS)

Ecology Program: HWTR

System Name: TURBO WASTE

Description: HWIMSy electronic reporting interface provided to the business community

Business Risk: Submitted HWIMSy date would not be Y2K compliant.

Platform: PC/LAN

Software: Visual Basic, Access

First Failure Date: 1/1/2000

Planned Test Start Date: 10/15/1997

Planned Conversion Start Date: Not applicable

Planned Certification Date: 11/15/1997

Staff Time Required (hours): Claremont Technology Group (consultant)

External Interfaces: Data loaded into HWIMSy and provided to EPA RCRIS and Biennial Report System (BRS)

Ecology Program: HWTR

System Name: LOW LEVEL RADIOACTIVE WASTE PERMIT TRACKING

Description: Includes all entities with site use permits, fees and waste disposal data (volume and activity)

Business Risk: Some permits may not be issued which could have a commercial impact.

Platform: PC/LAN

Software: Access 7.0

First Failure Date: 1/1/1999

Planned Test Start Date: 10/1/1997

Planned Conversion Start Date: Not applicable

Planned Certification Date: 12/1/1997

Staff Time Required (hours): 10

External Interfaces: None

Ecology Program: Nuclear Waste

System Name: NUCLEAR WASTE PROGRAM PLANNING SUPPORT

Description: Provides for detailed tracking of all Hanford/NWP technical projects by Ecology

Business Risk: Ecology Hanford employees would not have a record of Ecology interactions with external parties.

Platform: PC/LAN

Software: Microsoft Access 97

First Failure Date: 7/1/1997

Planned Test Start Date: 10/1/1997

Planned Conversion Start Date: Not applicable

Planned Certification Date: 1/1/1998

Staff Time Required (hours): 40

External Interfaces: None

Ecology Program: Nuclear Waste

System Name: CORPS OF ENGINEERS 401 PERMIT TRACKING SYSTEM

Description: Tracks Corps permits

Business Risk: It would be more difficult to coordinate our actions with the Corps of Engineers.

Platform: PC/LAN

Software: Microsoft Access 2.0

First Failure Date: 1/1/2000

Planned Test Start Date: Not applicable

Planned Conversion Start Date: Not applicable. This system will be converted to Access 97 as part of Ecology's migration to a 32-bit desktop environment.

Planned Certification Date: 7/1/1998

Staff Time Required (hours): 344 (Not all of this time is due to Y2K requirements.)

External Interfaces: None

Ecology Program: Shorelands & Environmental Assistance

System Name: ENFORCEMENT TRACKING

Description: Tracks Ecology's formal enforcement actions

Business Risk: Ecology could not efficiently report formal actions at an agency level.

Platform: PC/LAN

Software: ?

First Failure Date: ?

Planned Test Start Date: ?

Planned Conversion Start Date: ?

Planned Certification Date: ?

Staff Time Required (hours): ?

External Interfaces: ?

Ecology Program: Shorelands & Environmental Assistance

NOTE: Organizational responsibility for this business function and system is currently unknown but is expected to be determined as part of the ongoing reorganization of Central Programs.

System Name: PERMIT ASSISTANCE CENTER ACTIVITY TRACKING

Description: Tracks activity of staff supporting the agency's permit assistance center

Business Risk: Ecology could not deliver services to the public as quickly.

Platform: PC/LAN

Software: Microsoft Access 2.0

First Failure Date: 1/1/2000

Planned Test Start Date: Not applicable

Planned Conversion Start Date: Not applicable. This system will be converted to Access 97 as part of Ecology's migration to a 32-bit desktop environment.

Planned Certification Date: 3/1/1998

Staff Time Required (hours): 80-100 (Conversion, testing, and certification)

External Interfaces: None

Ecology Program: Shorelands & Environmental Assistance

System Name: SEDQUAL

Description: Maintain and report the results of sediment tests throughout the state

Business Risk: Ecology would fail to comply with some regulations.

Platform: PC/LAN

Software: Microsoft Access 2.0, VISUAL BASIC 4

First Failure Date: 1/1/2000

Planned Test Start Date: Not applicable

Planned Conversion Start Date: Not applicable. Conversion to Access 97 and Visual Basic 5 is nearly complete.

Planned Certification Date: 12/1/1997

Staff Time Required (hours): 100 (Remainder of conversion, testing, and certification)

External Interfaces: None

Ecology Program: Shorelands & Environmental Assistance

System Name: STATE ENVIRONMENTAL POLICY ACT (SEPA)

Description: Maintain a file of all environmental policy communications and subsequent actions

Business Risk: The SEPA register would not be published as required by law.

Platform: PC/LAN

Software: Paradox 3.5

First Failure Date: 1/1/2000

Planned Test Start Date: Not applicable

Planned Conversion Start Date: Not applicable. System is currently being redeveloped in Sybase and Livewire as an Internet application.

Planned Certification Date: 12/1/1997

Staff Time Required (hours): 516 (Not all of this time is due to Y2K requirements.)

External Interfaces: None

Ecology Program: Shorelands & Environmental Assistance

System Name: CLEANUP CONTRACTS/COST RECOVERY TRACKING

Description: Tracks Ecology attempts to recover costs expended to cleanup spills and drug labs

Business Risk: Cost recovery

Platform: PC/LAN

Software: Microsoft Access 2.0

First Failure Date: 1/1/2000

Planned Test Start Date: Not applicable

Planned Conversion Start Date: Not applicable. This system will be converted to Access 97 or another data base management system as part of Ecology's migration to a 32-bit desktop environment.

Planned Certification Date: 9/1/1998

Staff Time Required (hours): 170

External Interfaces: None

Ecology Program: Spills

System Name: ENVIRONMENTAL REPORTS TRACKING SYSTEM (ERTS)

Description: Regional office based, agencywide system to track all incoming calls reporting environmental concerns and followup referral to programs/other agencies for response and/or investigation

Business Risk: Ecology could not effectively track reports of spills and the agency's response.

Platform: PC/LAN

Software: Microsoft Access 2.0, Microsoft Visual Basic 3.0, TRUEGRID PRO 2.1, Crystal Reports 3.0

First Failure Date: 1/1/2000

Planned Test Start Date: 6/1/1998

Planned Conversion Start Date: Not applicable. System is believed to be Y2K compliant but other business drivers may require system redevelopment.

Planned Certification Date: 7/1/1998

Staff Time Required (hours): 10 (Testing and certification only)

External Interfaces: None

Ecology Program: Spills

System Name: MARINE INFORMATION SYSTEM (MIS)

Description: Primary vessel tracking, screening and inspection system for regulated vessels in Washington waters

Business Risk: Washington waters would be exposed to greater risk.

Platform: PC/LAN

Software: Microsoft SQL Server, Microsoft Visual Basic 3

First Failure Date: 1/1/2000

Planned Test Start Date: Not applicable

Planned Conversion Start Date: 11/1/1997

Planned Certification Date: 6/1/1998

Staff Time Required (hours): 1000 (Only 20% of this time is due to Y2K requirements. This need is currently unfunded.)

External Interfaces: None

Ecology Program: Spills

System Name: PRIMARY RESPONSE CONTRACTORS AND EQUIPMENT TRACKING SYSTEM

Description: To keep track of spill response contractors information and equipment

Business Risk: Contracting for spills response would be less efficient.

Platform: PC/LAN

Software: Microsoft Access 2.0

First Failure Date: 1/1/2000

Planned Test Start Date: Not applicable

Planned Conversion Start Date: Not applicable. This system will be converted to Access 97 or another data base management system as part of Ecology's migration to a 32-bit desktop environment.

Planned Certification Date: 9/1/1998

Staff Time Required (hours): 170 (Conversion, testing, and certification)

External Interfaces: None

Ecology Program: Spills

System Name: ACTIVE GRANTS STATUS

Description: Provide detailed task and/or activity information on active and pending grants

Business Risk: Ecology would have less information about the effectiveness of the use of grants awarded by the agency.

Platform: PC/LAN

Software: Microsoft Access 2.0

First Failure Date: 1/1/2000

Planned Test Start Date: Not applicable

Planned Conversion Start Date: Not applicable. This system will be converted to Access 97 as part of Ecology's migration to a 32-bit desktop environment.

Planned Certification Date: 7/1/1998

Staff Time Required (hours): 10 (Testing and certification only)

External Interfaces: None

Ecology Program: SWFA

System Name: MODERATE RISK WASTE (MRW) SYSTEM

Description: Detailed and summary information of local MRW programs covering; small quantity generators (SQG) and household hazardous waste (HHW) collection, quantities, type, cost, waste disposition; SQG visits/audits: wastes generated, accumulated, types, etc.; MRW

Business Risk: Data flow to local governments would be interrupted.

Platform: PC/LAN

Software: Microsoft Access 2.0

First Failure Date: 1/1/2000

Planned Test Start Date: Not applicable

Planned Conversion Start Date: Not applicable. This system will be converted to Access 97 as part of Ecology's migration to a 32-bit desktop environment.

Planned Certification Date: 12/1/1997

Staff Time Required (hours): 10 (Testing and certification only)

External Interfaces: None

Ecology Program: SWFA

System Name: SOLID WASTE FACILITY DATABASE

Description: Contains information on solid waste disposal facilities, making the information available at HQ and the regional offices

Business Risk: Ecology could not respond to information requests about solid waste facilities.

Platform: PC/LAN

Software: Microsoft Access 2.0

First Failure Date: 1/1/2000

Planned Test Start Date: Not applicable

Planned Conversion Start Date: Not applicable. This system will be converted to Access 97 as part of Ecology's migration to a 32-bit desktop environment.

Planned Certification Date: 4/1/1998

Staff Time Required (hours): 10 (Testing and certification only)

External Interfaces: None

Ecology Program: SWFA

System Name: WASHINGTON STATE ANNUAL RECYCLING SURVEY SYSTEM

Description: Description of disposed waste tonnage, waste generated and recycled materials; analyze results; produce printed report for state, county & selective city recycling rates

Business Risk: Ecology could not calculate the state recycling rate which is required to be published.

Platform: PC/LAN

Software: Microsoft Access 2.0

First Failure Date: 1/1/2000

Planned Test Start Date: Not applicable

Planned Conversion Start Date: Not applicable. This system will be converted to Access 97 as part of Ecology's migration to a 32-bit desktop environment.

Planned Certification Date: 1/1/1998

Staff Time Required (hours): 10 (Testing and certification only)

External Interfaces: None

Ecology Program: SWFA

System Name: SITE INFORMATION SYSTEM (SIS) 2

Description: Provides site information to program management, the public and the legislature

Business Risk: Information delivery could be delayed.

Platform: Minicomputer

Software: Sterling Software COOL:Gen, Sybase

First Failure Date: 1/1/2000

Planned Test Start Date: 3/1/1999

Planned Conversion Start Date: Not applicable

Planned Certification Date: 6/1/1999

Staff Time Required (hours): 90 (This includes some time for any conversion which may be required.)

External Interfaces: None

Ecology Program: Toxics Cleanup

System Name: UST BASE

Description: Database management tracking and analysis for underground storage tanks. includes tank registration & leaking UST information

Business Risk: Ecology's ability to manage leaking underground storage tanks would be limited.

Platform: PC/LAN

Software: Microsoft NT Server, Sybase, PowerBuilder 4.0

First Failure Date: 1/1/2000

Planned Test Start Date: 3/1/1999

Planned Conversion Start Date: Not applicable

Planned Certification Date: 6/1/1999

Staff Time Required (hours): 90 (This includes some time for any conversion which may be required.)

External Interfaces: DOL

Ecology Program: Toxics Cleanup

System Name: WASTEWATER DISCHARGE REVENUE SYSTEM (WDRS)

Description: Performs annual and semi-annual billings and tracks wastewater discharge permit fees

Business Risk: State cash flow could be affected.

Software: Paradox 4.02, R&R REPORT WRITER 4.0

First Failure Date: 1/1/2000

Platform: PC/LAN

Pre-Test Start Date: Not applicable

Conversion Start Date: ?

Y2K Compliant Installed Date: ?

Certification Date: ?

Staff Time Required (hours): ?

External Interfaces: None

Ecology Program: Water Quality

NOTE: This system must be redeveloped for other business reasons but no resources have been committed to date.

System Name: WQ PERMIT LIFE CYCLE SYSTEM (WPLCS)

Description: Data repository for facility, permit, compliance, enforcement and monitoring information

Business Risk:

Software: Oracle 7.1, Oracle Tools 6

First Failure Date: 1/1/1995

Platform: PC/LAN

Pre-Test Start Date: Not applicable

Conversion Start Date: ?

Y2K Compliant Installed Date: ?

Certification Date: ?

Staff Time Required (hours): ?

External Interfaces: None

Ecology Program: Water Quality

NOTE: The front-end software is currently unsupported and the system must be redeveloped as part of the migration to a 32-bit desktop environment. No resources have been committed to date.

System Name: NOTIFICATION OF INTENT TRACKING SYSTEM (NITS)

Description: Tracks all water wells drilled in the state

Business Risk: Permit issuance could be delayed.

Platform: PC/LAN

Software: Paradox 3.5

First Failure Date: 1/1/2000

Planned Test Start Date: Not applicable

Planned Conversion Start Date: ?

Planned Certification Date: ?

Staff Time Required (hours): ?

External Interfaces: None

Ecology Program: Water Resources

NOTE: Redevelopment of this system in Sybase/Powerbuilder has been initiated and is 50% complete. No resources are committed at this time to project completion.

System Name: WATER ADJUDICATION REPORT WRITING SYSTEM

Description: Collect data & produce documents relating to the adjudication of water rights

Business Risk: Court documents could be filed late.

Platform: Minicomputer

Software: IBM AS/400 QUERY, COBOL, IBM WP, PC SUPPORT

First Failure Date: 1/1/2000

Planned Test Start Date: 1/1/1999

Planned Conversion Start Date: 2/1/1999

Planned Certification Date: 7/1/1999

Staff Time Required (hours): 80

External Interfaces: None

Ecology Program: Water Resources

System Name: WATER RIGHTS APPLICATION TRACK SYSTEM (WRATS)

Description: Tracks water right processing from application through certificate stage

Business Risk: Ecology's water rights processing service delivery could be reduced, including publication of application status information.

Platform: PC/LAN

Software: Paradox 4.0

First Failure Date: 1/1/2000

Planned Test Start Date: 3/1/1998

Planned Conversion Start Date: Not applicable

Planned Certification Date: 4/1/1998

Staff Time Required (hours): 20 (Testing and certification only)

External Interfaces: DNR

Ecology Program: Water Resources