Juan Parra

1
EPAs TRI Data Exchange -TRI-MEweb and State
Exchange Network

• Juan Parra
• State Exchange Project Coordinator
• US EPA - TRI program
• Exchange Network National Meeting
• Atlanta, GA
• April 28, 2009

2
Agenda

• About the TRI Data Network
• Updates to TRIME Web reporting
• What is new in TRI-MEweb this reporting year.
• What is the TRI State Data Exchange?
• Options available to non-member states to
  implement a State Data Exchange
• Discussion

3
The TRI-State Data Exchange Network Flow Diagram

• Approximately 7,238 (32) facilities located in
  all states used the TRI-MEweb application to
  submit 33,347 (36) chemical forms for RY 2007.
• Up from 3 of Forms in RY2006

Data Processing Center stores it into TRIPS
database
TRI-MEweb reporting
State Data Exchange
6.- Data received by state node
7.-Front-end application views data by State
employee
3.- Data accepted by TRIME Web Server
5.- XML Data converted stored in CDX node to be
sent to state
1.- Facility reporting TRI chemicals
4.- Data converted into XML format for web service
2.- Login into CDX TRIME Web account
4
TRIMEweb Data Flow Growth
5
What is TRI-MEweb?

• EPAs on-line TRI electronic reporting system
• No more software to download
• Can be accessed anywhere there is an internet
  connection
• Enhanced Security
• File format is extensible mark-up language (XML)
  instead of flat file

6
Important Notice about RY08 TRI

• As part of the 2009 Federal Omnibus Bill,
  Congress mandated a removal of the TRI Burden
  Reduction Rule
• For non-PBT chemicals, the rule reinstates the
  500-pound annual reporting amount (the total of
  releases and other waste management) and
  1,000,000 pounds manufactured, processed or
  otherwise used Form A eligibility threshold in
  effect prior to December 22, 2006.
• PBTs may not file using Form A

7
Why TRI-MEweb?

• Enhances internet reporting from facilities
• No need to email CDs
• No need to test operating system/software
  compatibility with the web-based system
• Application updates/changes can be made
  instantly
• Will lead to earlier data releases due to
  increases in internet reporting raw data in
  August-September/09

8
RY 2007 TRI-MEweb Full Release

• Approximately 7,238 (32) facilities located in
  all states used the TRI-MEweb application to
  submit 33,347 (36) chemical forms for RY 2006.
• Up from 3 of Forms in RY2006
• There were some issues.

9
TRIMEweb Issues

• Users had trouble finding the ESA
• Users had trouble knowing when their ESA was
  approved
• Submissions sometimes did not appear to the
  certifier

10
TRIME Solutions

• Moved the ESA process out earlier in the
  registration
• Implemented an email to inform users when ESAs
  are approved
• Currently undergoing an upgrade of the hardware
  (Weblogic-32 bit to JBOSS-64 bit) in CDX to allow
  for better processing to make sure submissions
  dont go into purgatory it can hand bigger
  loads

11
New for TRI-MEweb RY2008

• Available to all TRI reporters, including first
  time filers
• TRIFIDs and access keys generated on the fly
• Release Date of April 22
• Facilities will be e-mailed/mailed access keys as
  before
• Alternate option
• Enter a facilitys ID, technical contact name
  and phone number to gain access next slide

12
(No Transcript)
13
(No Transcript)
14
New for TRI-MEweb RY2008

• Reporting by Part
• First Time Filer Reporting
• Toxic Equivalency Quotient (TEQ) Reporting for
  Dioxin- new TRI requirement
• Submission Review Package next slide
• State Diskette Submission
• Note The file that will be on the diskette/CD
  will be the TRI-MEweb XML file
• It will NOT be the flat files like TRI-ME produces

15
(No Transcript)
16
New for TRI-MEweb RY2008

• Reporting by Part
• First Time Filer Reporting
• Toxic Equivalency Quotient (TEQ) Reporting for
  Dioxin- new TRI requirement
• Submission Review Package
• State Diskette Submission
• Note The file that will be on the diskette/CD
  will be the TRI-MEweb XML file
• It will NOT be the flat files like TRI-ME produces

17
TEQ Reporting for Dioxin

• Beginning RY2008, Dioxin reporters are required
  to file a Schedule 1 Report in addition to a Form
  R
• More Info http//www.epa.gov/tri/lawsandregs/teq/
  teqpfinalrule.html
• TRI-MEweb allows users to report Dioxin Form R
  and Schedule 1
• IMPORTANT TRI-ME does not allow the filing of
  Dioxin this year due to the new requirements for
  reporting and the imminent retirement of the
  application

18
Future of TRIMEweb

• Add additional the functionality of TRI-MEweb
  (RY2009)
• Third Party Load
• EPA has established a third party load workgroup
• We will beta test TPL in production this year
• It will be available to all facilities next
  reporting year
• UTIL for TRI-MEweb?
• Pick list from FRS for RCRA landfills and POTWs?
• Partial Chemicals?
• TRI-ME CD will not be produced next year

19
What is the State Data Exchange?

• Develop an outbound TRI data flow from EPA to the
  States of current submission data.
• Create a process such that TRI facilities can
  simultaneously report data to EPA and the States.
• Providing historic data and other data to the
  states via web services.

State Data Exchange
6.- Data received by state node
7.-Front-end application views data by State
employee
3.- Data accepted by TRIME Web Server
5.- XML Data converted stored in CDX node to be
sent to state
1.- Facility reporting TRI chemicals
4.- Data converted into XML format for web service
2.- Login into CDX TRIME Web account
20
TRI State Data Exchange Current status
18 States In Production All flows (Stage
2)-Production date

• Oregon - March 09
• Minnesota - Feb 09
• Hawaii - May 08
• Texas - May 08
• Ohio - May 07
• New Jersey - May 07
• Illinois - March 07
• Indiana - Jan 07
• Michigan - Oct 06

• Kansas Sept 06
• Kentucky -Sept 06
• Utah Aug 06
• Oklahoma - June06
• Delaware - June 06
• Colorado - May 06
• Washington -April 06
• Virginia - April 05

• Stage 1 Only TRIMEweb submissions sent by CDX to
  State Node
• South Carolina March 05

21
TRI State Data Exchange Current status
In Development (Stage 1 and Stage
2) Wisconsin Mississippi North
Carolina California Pennsylvania New
York Note denotes all flows MOA signed
22
State Data Exchange States in Production

• For Reporting Year 2007
• 46 of the national data (43,414 reports) flowed
  through the TRI State Data Exchange to
  participating states.
• 44.5 (10,156) of all TRI facilities had their
  reports submitted /processed to the State via the
  exchange.

23
TRIMEweb and State Data Exchange Growth
65
24
Options to implement a State Data Exchange

• Option 1 Do it yourself
• Solicit a Data Exchange Grant to fund TRI
  application on state data exchange node.
• Consult with other states that have implemented
  their own TRI SDX (Pennsylvania, Kentucky, and
  Oregon)
• Use TRI resources to get started
• State Data Exchange web site http//www.epa.gov/t
  ri/stakeholders/state/state_exchange/index.htm
• Step-by-Step handout to join the State Data
  Exchange
• CDX Hotline to test your node [phone]
• Attend EPAs Monthly State Data Exchange Call
  Third Wednesday of every month for advice or
  assistance

25
Options to implement a State Data Exchange-cont

• Option 2 Have someone do it for you
• Contractors that have established a TRI front end
  application that meet each states unique
  configuration on your State Node
• a PC-based application that parses the TRI
  submission from an XML format into a relational
  database.
• a web-based application that allows for browsing,
  extracting, and managing TRI submissions.
• Windsor Solutions
• InfoTech
• CGI
• ERG

26
Vendor-based TRI application -Several
Implementation Options

• Option 1 Self deployed application
• Must sign agreement on terms of use
• No support and no warranty
• State IT support needed
• State responsible for configuration
• Each state has unique setup parameters
• Multi state agencies may be involved
• Most economical option - free
• Option 2 Self deployed with remote assistance
• May be establish with a time-and-materials
  contract
• Ad-hoc assistance support provided
• 3-5K cost depending state environment

27
Vendor application -Several Implementation
Options-cont.

• Option 3 Vendor remote deployment
• State provided access needed
• Performed via Web meeting
• Requires remote access
• Fast and efficient, saves on travel
• Probably most cost effective 10-15K
• Option 4 Vendor onsite deployment
• Most costly option, but least burden on in-house
  staff gt15K
• Less troubleshooting
• Straightforward deployment, typically within a
  week

28
Issues raised about SDX

• Issue States can not certify that all TRI
  submissions have been received by State Node
• Leads to requests to have data re-pushed to state
  node during state reconciliation of data.
• Potential Solution
• Provide a web-based application where states can
  extract from the CDX node (central data exchange)
  their missing TRI chemical report submissions.

29
Issues raised about SDX

• Main drivers for States to join SDX
• State has a fee-based system
• eliminate paper and disk submissions to States
• We project that 50 of all States will join SDX
  by 2010.
• Issue How do we get the rest on board?
• Solution Develop a generic application that all
  States can use to download their TRI data from
  their node?
• Low tech support needed and low cost option but
  with limited features.

30
Future Direction

• Is the CDX the most efficient tool for States to
  obtain TRI data?
• Data Exchanges are often an intensive IT and
  costly State venture.
• Will a web-based option comply with EPCRA section
  313 reporting requirements?

31
Contact

• Juan Parra,
• TRI SDX Project Lead
• US EPA- Office of Environmental Information
• parra.juan_at_epa.gov
• Visit www.epa.gov/tri for information resources

32
Thank You

• Questions?
• Concerns?
• Comments?