Drinking Water Challenge Grant Project

1
Drinking Water Challenge Grant Project
Advisory Committee Conference Call 9/12/03
2
Presentation Purpose

• Review Advisory Committee Roles and
  Responsibilities
• Introduce Co-Chairs
• Provide context and background on the Draft Data
  Elements Requirement Document

3
Advisory Committee Purpose

• Purpose Assure that workgroup products and
  processes are responsive to stakeholder needs.

4
Advisory Committee Member Role

• An Advisory Committee member is expected to
• Review appropriate workgroup products for
  accuracy and relevance
• Provide feedback to Advisory Committee Co-Chairs
• Participate in Advisory Committee meetings

5
Advisory Committee Responsibilities

• Review and comment on the Data Elements
  Requirements document to use for the electronic
  submission of Laboratory Drinking Water data
• Review and comment on best practices to guide
  States during development of their lab data
  submission system
• Review and comment on Participation Agreement
  Template for States to adopt for lab data
  submission system
• Respond to workgroup questions

6
Advisory Committee Co-Chair Role

• A co-chair will
• Review appropriate workgroup products for
  accuracy and relevance
• Work closely with the project facilitator to
  coordinate with the workgroup
• Potentially participate in the workgroups
  quarterly meeting
• Be primarily responsible for disseminating
  information, coordinating presenters, and
  gathering comments from the Committee members.

7
Co-Chairs

• Co-Chair from a private laboratory
• Harvey Klein, Garden State Laboratory
• Co-Chair from a utility
• David Paris Manchester Water Works

8

• Data Elements
• Document Background

9
Develop Data Standard / Data Format

• Goal
• Have 1 data format for laboratory Drinking Water
  submissions that can be used as a National
  Standard
• Although focus is initially on Drinking Water,
  National standard will be first step in unifying
  laboratory data format for other environmental
  data flows (air, wastewater, etc.)
• This approach has backing of both States and EPA

10
Develop Data Standard / Data Format

• Process
• Review all DW forms from 5 states used for
  electronic submittal of DW data, compile common
  data element inventory, group into logical data
  blocks COMPLETED
• Compare this list with Laboratory Data Standard
  and modify if necessary. IN PROCESS, WAITING FOR
  COMPLETION OF LAB DATA STANDARD (OCTOBER)
• Compare and reconcile list with SDWIS Fields
  COMPLETED
• Create a Draft Data Element Requirements
  document.
• Convene group of interested States and EPA to
  review Draft Data Element Requirements and
  merge with companion e-DWR effort Ongoing

11
Develop Data Standard / Data Format
Process Continued

• Send our Data Element Requirements to Advisory
  Committee for comment. Revise to create Final
  Data Element Requirements. 9/12/03
• Submit the Final Data Element Requirements to
  EPA Standards Bodies for their consideration
• Environmental Data Standards Council
• Technical Resources Group

12
Document Structure

• Excel Spreadsheet with Two Tabs
• Forms List
• List of State forms used to initially draft Data
  Element List
• Data Elements
• Data Block Contains the name of the highest
  level grouping of the data elements document
• Data Field Name of the data element
• Data Field Definition
• SDWIS-State Sampling-for-EDI Field (Crosswalk
  Field)
• SDWIS-State Table/Field Name (Crosswalk Field)
• e-DWR Schema Element (Crosswalk Field)
• Lab Data Standard Element (Crosswalk Field)

13
Specific Questions on the Data Elements
Requirements

• Is the list of elements comprehensive?
• Is the definition of the data element clear?
• Is there any data that currently cannot be
  generated?
• Notes
• Many fields will be optional will depend on
  program and state
• Please focus primarily on the laboratory
  section of the document

14
Data Elements Requirements document location

• http//www.exchangenetwork.net/common/content.asp?
  enTA864193catseaYessetBothscaYessctLong
  pri5eadtbsadlt

15

• Questions?