Transcript 2. Design Objectives- “One-Stop Shop” System Framework (12

UIC Data Exchange
System Objectives, Data Flow,
Challenges
Exchange Network National Meeting
Marriott New Orleans Convention Center
New Orleans, LA
April 25-26, 2007
Agenda
1. Quick Background
UIC Program, Business Case for New Data System, Status of Development, Project
Management
2. Proposed UIC System Design
Design Objectives, System Framework, Data Model, End to End Flow thru CDX to
Database
3. “Data Flow In” – Initial Implementation Strategy
4. Challenges and Progress
Part 1
Quick Background
UIC Program History, State Primacy, Status of
Development, Project Management
UIC Program History
• UIC Program:
-- Regulated under the Safe Drinking Water Act. Regulations issued in 1980
-- EPA works with states to regulate underground injection of fluids to
prevent endangerment of underground sources of drinking water (USDW).
-- More than 570,000 injection wells; potential expansion for new waste
streams (e.g., drinking water residuals, CO2 sequestration)
• Five UIC well classes:
-- Class I: Most strictly regulated. Injection of hazardous or municipal waste
into deep wells. Haz waste wells co-regulated under RCRA.
-- Class II: Brines & other fluids associated with oil and gas production.
-- Class III: Fluids associated with solution mining of minerals
-- Class IV: Haz/rad wastes into or above a USDW. Banned in most cases.
-- Class V: Injection into or above USDW. Typically shallow systems
• Primacy may be granted to a state for all well classes or split by SDWA
statutory authority (i.e., Section 1422, Section 1425). EPA Regions directly
implement (DI) for those UIC programs not delegated to the states. See
State Primacy
Status of Development
• OGWDW made decision to proceed on development
of new UIC database in June, 2006, based on a
requirements analysis prepared over 2005 and 2006.
• The final data model was approved in Nov 2006; XML
schema in testing, to be approved end of April, 2007
• An integrated project team (IPT), comprised of EPA
HQ, Regions, States had 1st biweekly mtg Nov, 2006.
• EPA is working with 10 states & 9 DI Regions to map
their data into UIC database by initial deployment date
Status of Development (cont’d)
• Completed to Date:
*
*
*
*
*
Mapping instructions
XML schema
Schematron Business Rules
CDX Node
UIC Oracle Database
• In Progress:
* Integration testing underway
* IPT Pilot Testing – 9 Regions, 10 states
* Data Warehouse: Reports & User Interface Dev
• Target date for initial deployment: Aug 31, 2007
Project Management
Core Project Management Team
Project Manager:
Alternative Project Manager:
USER Access, Data Security
UIC Program Contact
IT Team Leader:
Data Warehouse Team Leader:
Associate Branch chief
Carl B. Reeverts
Trang Le
Towana Dorsey
Robyn Delehanty
Abe Siegel
Lee Kyle
Leslie Cronkhite, Roy Simon
Integrated Project Team (proposed)
EPA HQ and Contractors:
DWPD Prevention Br: Robert Smith
Lee Whitehurst
OW
Joe Wilson
OEI:
Pat Garvey (FRS)
Cory Wagner (CDX)
Lockheed Martin
Maryam Balali
CADMUS
Cindy Huang
CSC
Ted Willard
EPA Regions and States:
Region 3
Region 4
Region 6
Region 7
Region 8
Region 9
Maria Conicelli
Brian Thames
Ron VanWyk
Kurt Hildebrandt
Valois Shea
Elizabeth Janes
UT Class 1/5
WY Class 1/5
DE Class 5
MT Class 2
MS Class 2
Candace Cady
John Passehl
Ron Graeber
Tom Richmond
Ron Tarbutton
Tom Carpenter
Mark McCasland
Dave Stitt
Perry Silver
Bert Granberg
Craig Tuttle
Dennis Murphy
Mark Layne
Arthell George
Part 2
Proposed UIC System Design
System Framework, Data Model, End to
End flow thru CDX to database
National UIC Database
System Framework (11/2006 )
Data Source’s site
Validator
OGWDW Management:
 7520 summary info
(2)
70+ Regional
and state
databases
ICIS
XML Doc
FRS
notification
(1)
Staging Access
Database
CDX
(XML Doc
Repository)
Validator
 UIC PAM Measures
 UIC Inventory Reporting Sys
 SWP/UIC Integration
 Class I Special Needs
 Class V Invent. Initiative
 Congr/GAO/OMB Questions
Data Analysis and
Report Generation
(Monthly, Quarterly, Yrly)
System
Integration
Message Reports :
1. Invalid data
2. Changes from last
data submission
Periodic Data
Extraction
UIC Database
DWPD Data Warehouse
RCRAInfo
TRI
UIC Data Model – ERD
Figure 2 - Relationship among UIC Business Objects
Constituent
Contact
Facility
(Class I only)
Permit
Waste
(Class I only)
Well
Well Type
Engineering
(Class I and deep
wells only)
Well Status
Geology
Location
(Class I and deep
wells only)
MI_Test
Permit
Activity
Violation
Enforcement
Response
Correction
Inspection
Part 3
“Data Flow In” – Initial
Implementation Strategy
Initial Implementation
We are working initially with 10 states & 9 Regional DI programs to map
their data into the new UIC database by the initial deployment date.
We have begun discussions through the Regions and GWPC to reach
agreement with all other states to provide data in subsequent rounds.
State/DI Trading Partners Participating in Initial Phase In:
Role of State/DI: To be initial State/DI programs to flow data to new UIC
DB by July 31, 2007
Proposed No. of States/DI: 9-15 States, 9 DI Regions
Project Period: Sept 2006 – Jul 31, 2007
Estimated Commitment Per State/DI = .15 FTE
State/DI Programs (Proposed):
• Round 1: MT, WY, UT, DE, MS, Regions 3, 4, 6, 7, 8, 9
• Round 2 (still in discussion): MA, FL, GA, NC, SC; TCEQ, TRRC;
NE, ND, UT, AK, CA (5 other States with Network Exchange grants);
Regions 2, 5, and 10
Data Mapping Process
1. Agree on data to transfer – review mapping instructions and agree on data to be
transferred.
2. Perform logical mapping – complete the EPA database mapping form.
3. Extract source data – extract the source data and put it in a temporary file or
staging tables.
4. Convert extracted data – convert the source data extracted from step 3 to the EPA
data format, which is defined in the UIC Data Model Version 7.5 and the Business
Rules document, and load the converted data to either an Access database, or an
XML file that conforms to the UIC XML schema.
5. Populate XML Data File – if choosing step 4a, run the EPA XML conversion tool to
convert data in the Access database into XML file. If choosing step 4b, develop and
use an XML conversion tool.
6. Validate XML Data File – run the EPA validation tool against the XML file and correct
any invalid entries.
Part 4
Challenges and Progress
Challenges:
1. Mapping to new database from 70 different State
and Region databases
2. UIC program resources sharply constrained to
take on new task
3. UIC programs and data are located in different
state agencies, multiple databases or
spreadsheets or paper files (particularly for Class
V wells)
4. Shift to electronic commerce to flow UIC data to
EPA is a “cultural change” requiring unique
state/EPA solutions
Progress:
• Reached agreement on single national data
model to meet well documented business case
that conforms to EPA data standards
• EPA data needs will be met through mapping
from existing State data bases.
• Four EPA Exchange Network grants underway
and another 10+ UIC state programs applied for
grants in 2007.
• Integrated Project Team (IPT) established last
Nov to guide and support UIC database dev.
• On target for deployment by end of fiscal year.