Multi-State Hazardous Waste Information Exchange WasteX

1
Multi-State Hazardous Waste Information
ExchangeWasteX
February 28 March 1, 2005
2
Outline

• Purpose
• Prove the concept of data exchange between states
  
• using the Node
• Business Area
• Interstate Hazardous Waste shipments
• WasteX Node demonstration
• WA to OR and OR to WA and WA to WA
• Next Steps
• Example Generic Interface
• Prototype Manifest Discrepancy Report
• Conclusions
• Recommendations
• eFiling in Washington impacts for the Node

3
Purpose

• Prove the concept of data exchange between states
  using the National Environmental Information
  Exchange Network (NEIEN)
• Is the technology needed available?
• What is the level of effort?
• Build the flow without a national standard?
• Can we create a new flow using the existing
  Nodes at two states (WA and OR)?

4
Business Area Interstate Shipments of Hazardous
Waste (HW)

• Those who generate HW must send it to a Treatment
  Storage Disposal Recycling facility (TSDR) which
  is permitted for that type of waste.
• Large Quantity Generators must report on a
  Generation and Management form (GM).
• TSDR s must report the waste they receive on a
  Waste Received form (WR).

5
Business Area Interstate Shipments of Hazardous
Waste (HW)

• The Implementer (Tribe, State) must have a
  solution to manage the information, and provide
  data to EPA every other year (2001, 2003 )
• EPA stores data in the Biennial Report System
  (BRS) now part of RCRAInfo.
• BRS provides some reconciliation between
  implementers, but only every other year at a
  company level.

6
Hazardous Waste Movement from Washington
79,982,082 pounds 10,141 manifests
7
Data Management of Hazardous Waste Shipments (HW)

• The Node presents an opportunity for On-Line data
  sharing of HW manifest data Did they
  receive what we sent?
• Implementers can place data on their Network Node
  as soon as it is available

8
Washington and Oregon

• Washington State and Oregon require annual
  submissions of data.
• Track HW shipments by manifest.
• WA and OR have similar solutions.

9
Manifest Tracking Systems Evolution between WA
and OR
10
HW Movement between WA OR (WA TurboWaste.Net
data only)
WA
2,448 manifests
3,712 manifests
OR
43,340,000 lbs
32,760,000 lbs
11
WasteX Application Topology
12
Node Flow Example (WasteX Query)
Requestor
Provider (STATE)

• Data Request
• Authenticate at NAAS
• Perform Query

• Node Management
• Request received
• Account/Service Authorized at NAAS
• Request logged (Access, Query, Parameters etc.)

AGENCYNODE
TurboWaste.Net Application

• Data Transformation
• Query parameters parsed
• Relational data retrieved
• XML transformation
• Schema validation

PROGR.RDBMS
QueryProcessor

• Node Management
• Request results logged
• XML payload returned

• Data Received
• Response logged
• Payload staged

AGENCYNODE
TurboWaste.Net Application
Data available to the user
13
Node Information Flow Diagram
14
Lets take the Node for a test drive
Waste X
15
TurboWaste main screen
Node Demo
Enter ID
WAD041337130
Click Search
16
Company Search Results
Node Demo
Click View Reporting History
17
Company Waste Stream Listing
Node Demo
Click View for a single waste stream
18
Waste Shipment Detail Link to Node
Node Demo
Link icon means Node link
WA WA WA OR OR WA OR - OR
19
WasteX Results - Matching WA Generator and WA TSD
Node Demo
20
WasteX Results - Matching WA TSD and OR Generator
Node Demo
21
? Opens the data for our field inspectors
Data Sharing Challenges
? Opens the data for review
? Exposes data quality problems
? Exposes data quality problems
22
Next Steps for WasteX

• Is WasteX the right application for determining
  manifest discrepancy reporting?
• Develop simple tool for determining manifest
  discrepancies
• Develop a generic interface concept
• Define requirements

23
Concept Manifest Discrepancy Report
QUANTITY
MANIFEST
SHIPDATE
GENERATOR
RECEIVER
QUANTITY
MANIFEST
SHIPDATE
RECEIVER
GENERATOR
Its the differences in manifests and quantities
that we are interested in
24
Manifest Discrepancy Summary Report
25
Manifest Discrepancy Detail Report
Receiving TSDR
RecID WAD020257945

        Data  
GenID Manifest_NR GenShipmentDT RecShipmentDT Sum of GenPounds Sum of RecPounds
ORD000773937 5718 . 11/20/2003 0 1761.41
  82209 . 12/20/2002 0 24209.35
  86058 . 3/24/2003 0 23819.04
  94779 . 9/15/2003 0 33696.94
  99299 . 12/5/2003 0 36859.46
ORD000773937 Total ORD000773937 Total     0 120346.2
WA9214053465 2290A . 10/17/2002 0 5020
  3028A 1/28/2003 1/28/2003 2377 4190
  3044L 2/13/2003 2/13/2003 1 3720
  3097A . 4/7/2003 0 5660
  3099L 4/9/2003 4/9/2003 2502 1460
  3162A . 6/11/2003 0 13860
  3216A 8/4/2003 8/4/2003 3753 360
Date Generator Shipped
Sending Generator
Manifest Number
Date Received at Facility
Sent Pounds
Received Pounds
26
Manifest Discrepancy Detail Report
RecID WAD020257945

        Data  
GenID Manifest_NR GenShipmentDT RecShipmentDT Sum of GenPounds Sum of RecPounds
ORD000773937 5718 . 11/20/2003 0 1761.41
  82209 . 12/20/2002 0 24209.35
  86058 . 3/24/2003 0 23819.04
  94779 . 9/15/2003 0 33696.94
  99299 . 12/5/2003 0 36859.46
ORD000773937 Total ORD000773937 Total     0 120346.2
WA9214053465 2290A . 10/17/2002 0 5020
  3028A 1/28/2003 1/28/2003 2377 4190
  3044L 2/13/2003 2/13/2003 1 3720
  3097A . 4/7/2003 0 5660
  3099L 4/9/2003 4/9/2003 2502 1460
  3162A . 6/11/2003 0 13860
  3216A 8/4/2003 8/4/2003 3753 360
Missing Data (Yellow Boxes) Lost shipments
Data not reported by Generator
Missing Pounds ? No data from Generator
Extra Pounds TSD reported 120,346 pounds
27
Prototype Manifest Discrepancy Report
Generator reported 29,965 lbs
TSD reported 44,690 pounds
  3234A 8/25/2003 8/25/2003 2502 5640
  3254A 9/11/2003 9/11/2003 3367 4780
  3336A 12/2/2003 . 15463 0
WA9214053465 Total WA9214053465 Total     29965 44690
WAD038529137 9628 1/31/2003 1/31/2003 4770.48 4770.48
  2533B . 12/9/2003 0 17514
WAD038529137 Total WAD038529137 Total     4770.48 22284.48
WAD041337130 M0053 1/17/2002 1/17/2002 34235 34194
  M0055 1/16/2002 1/16/2002 20207 20182.8
  M0199 3/7/2002 3/7/2002 28348.25 28314.3
  M0200 3/7/2002 3/7/2002 26686.6 26654.64
  M0201 3/9/2002 3/9/2002 30310.5 30274.2
  M0229 3/17/2002 3/18/2002 27555 27522
  M0231 3/13/2002 3/13/2002 39658.32 41192.93
  M0360 4/30/2002 5/1/2002 18370 18348
  M0373 5/2/2002 5/2/2002 4342 4170
  M0447 6/1/2002 6/3/2002 26177.25 26145.9
  M0519 6/21/2002 6/21/2002 11695.84 11442.48
Difference 14,725 poundsWhere is the error?
Generator, TSDF, or a little of both.
28
Concept Manifest Discrepancy Report
  N1030 10/21/2003 10/21/2003 21125.5 21100.2
  N1125 11/7/2003 11/7/2003 1503 1417.8
  N1192 12/5/2003 12/5/2003 40080 40032
  N1193 12/5/2003 12/5/2003 40080 40032
  N1210 12/16/2003 12/16/2003 21125.5 21100.2
  N1256 12/23/2003 12/23/2003 29548.15 29512.76
WAD041337130 Total WAD041337130 Total     933176.38 927564.63
Grand Total       967911.86 1114885.31
No Missing Manifests Generator reports 933,176
pounds TSDF reports 927,564
pounds Difference 5,612
pounds
0.6
29
Generic Interface
EXCHANGE NODE Multi-State Hazardous Waste Tracking
Generators of HW
TSDR Facilities Receiving HW
Match to
30
Conclusions

• Technology is here
• Methods and techniques are fairly straight
  forward
• Opens new business opportunities for state
  cooperation
• Possible to create a data flow without a
  National Data Standard
• All partners must agree
• Be willing to rework to make a national standard

31
Follow sound project management principles
Recommendation 1
32
Recommendation 2
It has to be Win-Win for everybody
33
Recommendation 3
Know where you are going
34
Recommendation 4
WasteX shows that there are many ways to use the
Node capabilities
35
eFiling and the NodeTurboWaste.NetROI(Return
On Investment)
36
TurboWaste.Net Impacts the Node
37
Electronic Records Comprise 92 of the Data
Reported
38
Companies Reporting Electronically Rises
Dramatically
Reporting Deadline 3/1/05
TurboWaste.Net
TurboWaste Access Version
39
TurboWaste.Net is Changing Our Daily Business
Practices in One Year
91
18
40
How Did We Achieve These Results ?

• Listening to clients needs
• Investing in enhancements
• Client outreach
• Training
• Being flexible with deadlines

41
Lets take TurboWaste.Net for a Spin
TurboWaste
42
TurboWaste.Net
Welcome to TurboWaste.Net
43
TurboWaste.Net
Login
44
TurboWaste.Net
User Profile
45
TurboWaste.Net
Welcome to TurboWaste.Net
My Sites
46
TurboWaste.Net
Site Profile
47
TurboWaste.Net
Reporting History
48
TurboWaste.Net
Site ID Form
49
TurboWaste.Net
GM / WR Simple Version
50
TurboWaste.Net
GM / WR Expert Version
51
TurboWaste.Net
Annual Report Checklist
52
Key Features of TurboWaste.Net

• PIN security and encrypted passwords
• Administrators can easily add users and change
  permissions
• Administrators / Data Entry Staff responsible
  for many sites can see all their sites on one
  screen
• Three roles Administrators Data Entry View
  Only
• Only Administrators can submit data

53
Key Features of TurboWaste.Net

• Complete data validation rules in place
• Data can be imported, copied from an earlier
  year, or hand entered
• Expert versions of application screens for rapid
  data entry
• Simple versions of screens for drop down menus 

54
Key Features of TurboWaste.Net

• - Data is not available to Ecology for view until
  it is officially submitted or authorized for view
  by the client
• Annual Reporting can be combined with
  notification revisions and withdrawals (one Site
  ID form, multi purpose)
• First notification and ownership changes require
  paper submittals
• TurboWaste staff have administrator rights
• Ecology staff with view only rights on
  submitted data
•  

55
What our clients are saying about TurboWaste.Net
President of EnviroTech..I want to complain
about your TurboWaste, its too easy !   Beth
Gilbertson - Kent School District - she has many
sites and used it last year.  She absolutely
loves the new improvements we made this year!   I
submitted two weeks early.  Why?  Because the
turbowaste program now works so well.  It has
matured over the years, and your efforts have now
really paid off.  My hat's off to the turbowaste
staff.
56
Submitted in TurboWaste.Net Node Available
91
18
57
Credits
Debbie Stewart WA Department of Ecology Miles
Neale WA Department of Ecology Bill Kellum WA
Department of Ecology Mitch West - Oregon
Department of Environmental Quality Glen Carr
Oregon Department of Environmental
Quality Windsor Solutions Inc. (Lake Oswego, OR)
58
Thank You
Ed Bentley eben461_at_ecy.wa.gov
360.407.6466 Dan Kruger dkru461_at_ecy.wa.gov
360.407.6728
59
(No Transcript)