TO:

Purpose;
Michael B. Cook, Director /s/
Office of Superfund Remediation and Technology Innovation

Superfiind National Policy Managers, Regions 1-10
.*»'<*
The purpose of this memorandum is to announce that the Superfund Site Progress Profiles
will be available to the public via the internet on February 11, 2005. We very much appreciate
the assistance of your staff during the extended development of these profiles. The profiles will
provide a nationwide web-based standard for communicating cleanup status at NPL and
Superfund Alternative Sites using CERCLIS data. The web address to search for a specific site
profile will be http.;//www.epa.gov/superfund/sites/cumtes/index.htm. We anticipate that the
profile pages will be accessed over 18,000 times each month. To maintain this as a consistent
source of accurate data your ongoing support is necessary.

Implementation:

The profiles will be automatically updated on a monthly basis. Please ensure that
CERCLIS is kept up-to-date with respect to the information being displayed through the profiles.
Attached are the profile Data Element Dictionary and Data Element Mapping files to assist your
efforts to maintain up-to-date and accurate data in CERCLIS.

The site profiles provide a direct link to regionally maintained Site Fact Sheets (also
known as NPL PADs). These must also be updated concurrently with CERCLIS to be consistent
with the profiles and reflect current site activities, cleanup status, and site contacts. In addition,
any reference to planned funding requests must be removed from these Fact Sheets. Some Fact
Sheets for active (non-CC) NPL sites have not been updated since 2002. HQ will perform regular
spot-check audits on a random number of sites to determine if profiles are up to date and the Site

-------
Fact Sheets provide information consistent with that being displayed by the profiles.

       I ask you to continually keep CERCLIS and all Site Fact Sheets up to date. OSRTIHQ
will begin its audit process on the first of March and continue the audits on a regular basis.
Results of the audits in your Region will be provided to you.

Conclusion:

       Finally, I wish to thank all Regional staff who assisted in the development of the
Superfund Site Progress Profiles. These profiles are an important communication tool for the
program and your efforts greatly contributed to a well-designed and useful product.  Questions
related to this should be directed to Melanie Hoff, (703) 603-8808.  Her email is
hoff.melanie(g).epa.gov.

cc:     Thomas Dunne, OSWER
Barry Breen, OSWER
Debbie Deitrich, OEM
Matt Hale, OSW
Linda Garczynski, OBCR
Marsha Minter, IPCO
Ed Chu, Land Revitalization Staff
JimWoolford,FFRRO
Dave Kling, FFEO
Susan Bromm, OSRE
Jim Drummond, OGC
Charles Openchowski, OGC
Earl Salo, OGC
Scott Sherman, OGC
Eric Steinhaus, Superfund Lead Region Coordinator, US EPA Region 8
Joanna Gibson, OSRTI Documents Coordinator

-------
Site Information/Location Data:
Data
Element
Label
Number
3
2
5

90
7
74
8
29
Data Element Label
Site Name
Site EPA ID
EPA Region

Site Address
County
U.S. Congressional
District
Population within
1-mile*
Technical Assistance
Grant
Accessing the Data in CERCLJS
Views>Site Information>Site
Location
Views>Site Information>Site
Location
Views>Site Inforination>Site
Location
Views>Site Information>Site
Location
Views>Site Information>Site
Location
Views>Site Information>Site
Location
N/A
Views>Project
Management>Project Schedule
CERCLIS Table
SITE.site_name
SITE.epa_id
SITE.rregion code

SITE.site_strt adrsl
SITE,site_cnty_code
SlTE.cngrsnl_dstrct_
code
N/A
ACTIORrat code =
TG'
Definition or URL associated
with Data Label?
No
Glossary Link
Link to Regional Homepage:
http://www.epa.gov/region9/
http://www.epa.gov/region
9/cleanup/
No
No
No
No
Glossary Link
Options Available for
Display
N/A
N/A
1, 2, 3, 4, 5, 6, 7, 8,
9, 10
N/A
N/A
N/A
0-100
101-1,000
1,001-5,000
5,001-10,000
50,000+
Will only be
displayed if TAG has
been awarded
'Population within 1 mile is stored in an independent database. For further information on how population within 1 -mile is calculated please see Attachment A.

-------
Federal Facility Oats:
Data
Element
Label
Number
9
64
66
Data Element Label
Federal Facility
Designation
BRAG Designation
Advisory Board
Accessing the Data in CERCLJS
Views>Site Information>Site
Status and Description/Operable
Units>Federal Facility Indicator
Views>Federal Facilities>BRAC
Site
Views>Project
Managemen1>Project Schedule
CERCLIS Table
SITE.rfed_fclty_code = ' Y'
SlTE.rbrac_code or
refj>rogram_priority_
init.rppt_code = 'FT'
Action.rat code = ('BW,
'BX')
Definition or URL
associated with Data
Label?
No
Glossary Link
Glossary Link
Options Available far
Display
-'Hull if site is not a
Federal Facility
-'This is a Federal
Facility'
-'Null' if site is not a
BRAC
-'This is a Federal
Facility and is a Base
Realignment and
Closure (BRAC) site'
Displays when site
currently has an active
(action has no
completion date)
'Restoration Advisory
Board' or a 'Site
Specific Advisory
Board'

-------
Data
Element
Label
Number
93

SO




28















Data Element Label



Cleanup Progress
Summary "Guys"
Cleanup Activities
Designation



NPL Status















Accessing the Data in CERCLIS



N/A

Views>Prqject
Management>Project Schedule



Views>Site Information>Site
Status and
Description/Operable
Units>NPL Status




V







CERCLIS Table



N/A

ACTIORrat code in
(BBVBFVIPyLVyLYVOFVPD'.'PJ
VRAVRLVRVYTA1) AND
action. act_actl atrt_date is not null

SITE.rnpl_status_code















DennitionorURL
associated with Data
Label?

No

No




Glossary Link







•







Options Available for
Display


See Page 5

-'Physical cleanup
activities have started'
-'Physical cleanup
activities have been
completed'
-Final - "This site is on
the NPL and is known
as Final NPL.'
-Proposed - *This site
is currently proposed to
be added to the NPL
and is known as a
Proposed to the NPL
site.'
-Deleted - "This site is
cleaned up, is no longer
a threat to human
health, has been deleted
from the NPL, and is
known as a Deleted
NPL site.
Cleanup Progress Summary Data:
Cleanup Progress Summary Data Continued:

-------
Data
Element
Label
Number
30

Data Element Label
Responsible Party
Designation

Accessing the Data in CERCIIS
Views>Project
Management>Project Schedule

CERCUS Table
(((Action.rat_code = any CA1',
'AS1, 'AY1, 'CM, 'CO', 'CQ1,
•DA', -ED', -EE', -EV, TE',
TM, TS', 'GM, 'GR1, 'GS',
•HA', HG', 'IP', 'JF1, 'JY', "LK,
tV, 1W, IX', -LV, W,
•ND', l-JIT, "NT, 'OF', 'OM1,
•PD1, -RA', RC, -RD', TtT, -RL',
•RO', -RS', -RV, 'SA', TA1,
TO',TS','WP)and
action.ralt code = any ("MR",
TS1,'RP,'SR1))or
action.rat code = any (T3B1,
BD1, -BE', BF', ME', -NA',
•NK', PT)) and
action.act_actl cmplln date is
not null
Definition or URL
associated with Data
Label?
Glossary Link

Options Available for
Display
-'Potentially
Responsible Parties are
involved in the cleanup
effort.'
-Not displayed if there
is no PRP involvement

-------
Cleanup Progress Summary "Guys"
            Study
            Not Begun
 Study Underway
                              Remedy S«tecte
-------
-------
Cleanup Impact Summary Data:
Data
Element
Label
Number
12
77a
77b
78
Data Element Label
Human Exposure
Metric
Solid Waste Volume
Liquid Waste
Volume
Population
Relocation
Accessing the Data in CERCLIS
Views>Program
Management>Environmental
Indicators>Human Exposures
tab
Views>Program
Managemem>Environmental
IndicatorsXJround Water
Releases tab
Views>Program
Management>Environmental
Indicators>Cleanup Volumes tab
Views>Program
Management>Environmenlal
Indicators>Populations Affected
tab
CERCLIS Table
ENVIRONMENTALJNDI
CATORS.rei code where
ENVIRONMENTALJNDI
CATORS.reic_code = 'HE'.
EI_CLEANUP.ec_standard
amount where rmedia code
= ('DB1, 'SB', 'SD1, 'SP, 'SL1,
•so1, 'sr, )
EI_CLEANUP.ec_standard
amount where rmedia code
- ('LWVGWYSWYLE')
EI_POPULATION_PROTE
CTED. epp_affected_amoun
t where
rpop rprotected type code
= 'PRL'
Definition or URL
associated with Data
Label?
Glossary Link
Glossary Link
Glossary Link
None
Options Available for
Display
-Current human
exposures at this site are
under control
-Current human
exposures at this site are
not under control
-At this site, EPA is still
working to determine if
human exposures are
under control.
Only displayed if a
volume is present in
CERCLIS
Only displayed if a
volume is present in
CERCLIS
Only displayed if
Population Relocated
data is present in
CERCLIS
-------
Cleanup Impact Summary Data Continued:
Data
Element
Label
Number
79
Data Element Label
Alternative Drinking
Water Supplied
Accessing the Data in CERCLJS
View$>Program
Management>Environmental
Indicators>Populations Affected
tab
CERCUS Table
EI_POPULATION_PROTE
CTED.epp_affected_amoun
t where
rpop [protected type code
= 'ADW
Definition or URL
associated with Data
Label?
None
Options Available for
Display
Only displayed if
Alternative Drinking
Water data is present in
CERCLIS
-------
Contamination Data:
Data
Element
Label
Number
17
Data Element Label
Contaminated Media
Accessing the Data in CERCIIS
Views>Remedy
Selection>Selected
Remedy>Select an
Action>Select Remedy
button>Select Add/Edit Media
button
CERCUS Table
REF MEDIA.rmedia_desc
Definition or URL
associated with Data
Label?
Glossary Link
Options Available for
Display
Air, Groundwater,
Debris, Leachate,
Liquid Waste, Other,
Residuals, Sediment,
Sludge, Soil, Surface
Water, Subsurface Soil,
Surface Soil, Surface
Water
-------
18






















Types of
Contaminants





















Views>Remedy Selection>Site
Characterization>Select an
Action>Select a Media




















REF_CONTAMINANT_G
ROUP.rcg_name





















Glossary Link






















Base Neutral Acids,
PAH,
Dioxins/Dibenzofurans,
Inorganicss, Metals,
Nitrate/Nitrite, Not
Provided, Organics,
VOC, Pesticides,
Petroleum
Hydrocarbon,
Carcinogens, Cement
Kiln Dust, Dissolved
Solids, Flammables,
Radioactive, Leachate,
Nitroaromatics,
Non-Carcinogens, Oil
& Grease, Organic &
Inorganic Liquid
Sludge, Oxidizers,
Petroleum Napthas,
Reactives, Unknown
Liq Waste, PCBs, No
Group Identified, Acids,
Data Not Available
10
-------
Exposure Module Data:
Data
Element
Label
Number
12
22
Data Element Label
Human Exposure
Metric
Institutional Control
Status
Accessing the Data in CERCLIS
Views>Program
Management>Environmental
Indicators>Human Exposure tab
N/A
CERCLIS Table
ENV1RONMENTALJNDI
CATORS.rei code where
ENVIRONMENTAL_INDI
CATORS.reic_code = 'HE'
N/A
Definition or URL
associated with Data
Label?
No
Glossary Link
Options Available for
Display
-Current human
exposures at this site are
under control
-Current human
exposures at this site are
not under control
-At this site, EPA is still
working to determine if
human exposures are
under control.
Institutional control data
is currently being
suppressed until ICTS
database is ready for
release.
 11
-------
Major Site Cleanup Milestones:

Data Element Label 32 - "Guy" graphics will be visible when completion of cleanup milestones has occurred at the site.  Milestones and logic for calculating
milestone completions include:

    •   1st Cleanup Action Completed - "Guy" is displayed based on the earliest completion of one of the following actions: Removal; Remedial Action; FF
        RA; PRP Removal; PRP Emergency Removal; PRP RA; and FF Removal.

    •   Proposed to the NPL - "Guy" is displayed based on completion of the following action:  'Proposed to NPL' (aotion.rat_oode = 'NP')

    •   Listed as Final on the NPL - "Guy" is displayed based upon the completion of the following action:  'Final Listing on NPL' (action,rat_code = 'NF')

    •   Final Remedy Selected - "Guy" is displayed when the Final Remedy Determination Trigger Action Flag = 'Yes' (frd_trigger_action_fUg)

    •   Construction Completion - 'Guy' is displayed when the Site Construction Completion Concurrence date is populated (site,co_concurrence_date is not
        null)

    •   Deleted from the NPL - "Guy" is displayed based upon the completion of the following action: 'Deletion from NPL' (action.rat_code = 'ND')


    -See Page 12 for Major Site Cleanup Milestone "Guy" display options.
12
-------
Major Site Cleanup Milestone "Guys"
   Cleanup Aclion
     Initiated
Proposed to the
     NPl
Listed as Final on the
       NPL
     Final Remedy
       Selected
 Construction
   Complete
    Deleted from
      the NPL
14
-------

13
-------
Cleanup Activities at IhU Site:

Data Element Label 34 - The "Cleanup Activities at this Site" module displays complete or underway cleanup activity dates by Operable Unit Dates that are
displayed on this chart are the most current underway or start dates (e.g. if OU 1 at a site has two removals completed, the most recent completion date will be
displayed).

Hie 5 Cleanup Activities are comprised of the following actions:


    •   Removal - PRP Removal, FF Removal, Initial Remedial Measure, PRP Emergency Removal, Removal

    •   Study and Remedy Selection - Remedial Investigation, Feasibility Study, Combined RI/FS, FRP Remedial Investigation, PRP Feasibility Study, PRP
        RI/FS, FF Remedial Investigation, FF Feasibility Study, FF RI/FS, Record of Decision

    *   Remedy Design - PRP Remedial Design, FF Remedial Design, Remedial Design

    •   Remedy Construction - Remedial Action, PRP Remedial Action, FF Remedial Action

    •   Post Construction - Long Term Response Action, Operations and Maintenance, PRP LR, FF LR
15
-------
Land Reuse Module:
Data
Element
Label
Number
47







Data Element Label
Restricted Use







Accessing the Data in
CERCLIS
Views>Project
ManagemenP-Prqject
Schedule>SeIect Record of
Decision>Select SCAP
button>Acres at site with
Land Ready for Restricted
Use





CERCLIS Table
SITE, S1TE_LAND_REUSE
where
sir current flag = T AND
sir acres ready restricted >0
AND
(site.rfed_fclty_code o T or
site.rfed_fclty_code is null)
AND ( (site.mpl_stotus_code in
(site.rnpl_status_code = *N' and
exists (select 'x* from
site_program_priority_init sppi
where sppi.site_id =
site.site id and sppi.rppt code
- T^E1)) OR
(site.rnpl_status_code='N' and
exists (select 'x' from action
where action, site id =
site.site id and action. rat code
inCRVVBB'Jand
action.ract critical flag code —
NT and
action.act_actl_cnipltn_date is
not null)
Definition or URL
associated with Data
Label?
None







Options Available for
Display
Acres







16
-------
Land Reuse Data Continued:
Data
Element
Label
Number
48























Data Element Label
Unrestricted Use























Accessing the Data in
CERCLIS
Views>Project
Management>Project
Schedule>Select Record of
Decision>Select SCAP
button>Acres at site with
Land Ready for Unrestricted
Use


'














CERCLIS Table
SITE, SITE_LAND_REUSE
where site.site_id =
site_Iand reuse.site_id AND
sir current_flag = 'Y AND
slr_acres ready unrestricted >
OAND
(site.rfed_fclty_code O V or
site.rfed_fclty_code is null)
AND ( (site.rnpl status code in
('PVF,1DVR','W))OR
(site.rnpl_status_code = W and
exists (select V from
site_program_priority_init sppi
where sppi.site_id = site.site_id
and sppi.rppt code = "NE')) OR
(site.rnpl_status_code=lN' and
exists (select V from action
where action.site_td =
site.site id and action.rat code
in ('RV.BB') and
action.ract critical flag code =
'NT and
action.act_actl cmpltn_date is
not null)
Definition or URL
associated with Data
Label?
None























Options Available for
Display
Acres























17
-------
Land Reuse Module Continued:
Data
Element
Label
Number
49

Data Element Label
Total Use

Accessing the Data in
CERCLJS
Views>Project
ManagemenP-Project
Schedule>Select Record of
Deeision>SelectSCAP
button>Total Acres of Site
with Land Ready for Reuse

CERCLIS Table
SITE, SITE_LAND_REUSE
where sir current Sag = 'V
AND
N VL( slr_acres_ready_restricte
d,0)+NVL(slr_acres_ready_unr
estricted,0) > 0 AND
(site.rfed_fclty_code o T or
site.rfed_fclty_code is null)
AND( (site.rnpl status code in
('PVF,1D1,'R','W))OR
(site.rnpl_status_code = "N" and
exists (select "x1 from
site_program_priority_init sppi
where sppi.site_id = site.site_id
and sppi.rppt_code - HE')) OR
(site.rnpl_status_code=lN' and
exists (select V from action
where action.site_id =
site.site id and action.rat code
in ('RV.'BB') and
action-met critical flag code =
•NT and
action.act_actl_cmpltn_date is
not null)
Definition or URL
associated with Data
Label?
None

Options Available for
Display
Acres
/
18
-------
Post-Construction Data:
Data
Element
Label
Number
51
52
53
i
Data Element Label
Last five-year review
at this site
Remedy deemed
protective?
Next five-year review
start date
Accessing the Data in CERCIIS
Views>Project
Management>Project
ScheduloSelect Record of
Decision>Select SCAP
button>Click More button>CIick
Five- Year Review button
Views>Project
Management>Project
Schedule>Five-Year Review
action>Select SCAP
button>Click More
button>Protectiveness Statement
tat»Protectiveness drop-down
Views>Project
Management>Project
Schedule>Select Record of
Dectsion>SeIect SCAP
buttonXMick More buttons-Click
Five- Year Review button
CERCLTS Table
ACTION.rat code in
('FEVVY') and
action.act_actl_cmpltn_date
is not null
REF_FYR_PROTECTIVE
NESS.rfyr_protectiveness_d
esc
ACTION.rat code in
('FEYVY) and
action.act_curr_pln_strt_dat
e is not null
Definition or URL
associated with Data
Label?
None
None
None
Options Available for
Display
Year '(YYYY)'
If more than one
Five- Year Review has
been completed,
dispkys most recent
Five- Year Review
-Not Protective
-Protective
-Protective in Short
Term
-Will be Protective
Once Remedy is
Complete
-Undetermined
(displayed when
rfyr_protectivehess_des
c is null)
Year '(YYYY)'
If there is more than one
Five- Year Review Start
Date lists the most
recent without a
complete date.
GPRA Module Data:
19
-------
Data
Element
Label
Number
57
58
Data Element Label
Final Site
Assessment Decision
Final Remedy
Selected
Accessing the Data in CERCLIS
Views>Site Status and
Description/Operable Units
Views>Project
Managemeni>Project
Schedule>Select Record of
Decision, ROD Amendment, or
Action Memo>Double click on
the Qualifier Column>Select 'R'
Final Remedy Determination
CERCLIS Table
FAD_STATUS_HISTORY.
fsh_decision = *Y'
Use most recent
fsh_decision_date
FINAL_REMEDY_Determi
nation. frd trigger action fl
ag = T
Definition or URL
associated with Data
Labelt
OPRA Module
contains definitions
for each GPRA
milestone
GPRA Module
contains definitions
for each GPRA
milestone
Options Available for
Display
-'Yes' -(-Site's non-NPL
status desc
-'No' + Site's non-NPL
status desc
-Not Applicable
-Current human
exposures at this site are
under control.
-EPA is working to
ensure human exposures
are under control.
-At this site, EPA is still
working to determine
whether there are any
human exposures to
contaminants.
GPRA Module Data Continued:
Data
Element
Label
Number
Data Element Label
Accessing the Data in CERCLIS
CERCLIS Table
Definition or URL
associated with Data
Label?
Options Available for
Display
20
-------
59










60














Human Exposure
Under Control









Contaminated
Ground water
Migration












Views>Program
ManagemenP-Environmental
Indicators>Human Exposure tab



-




Views>Program
Management>Environmental
Indicator$>Ground water
Releases tab
,










ENVIRONMENTAL INDI.
CATORS.rei_code = 'HE'
and
ENVIRONMENTAL INDI
CATORS.reic code = *Y'
or 'N* or 'X*.





ENVIRONMENTAL_INDI
CATORS.rei_code - 'GM
and
ENVIRONMENTAL INDI
CATORS.reic_code = 'Y'
or 'N' or 'D' or 'X'









GPRA Module
contains definitions
for each GPRA
milestone







GPRA Module
contains definitions
for each GPRA
milestone











-Current human
exposures at this site are
under control.
-EPA is working to
ensure human exposures
are under control.
-At this site, EPA is still
working to determine
whether there are any
human exposures to
contaminants.
-Contaminated Ground
Water Migration at this
site is under control.
-EPA is working to
ensure that
contaminated ground
water migration is under
control.
-At this site, EPA is still
working whether
contaminated ground
water migration is under
control.
-Not a Groundwater
Site.
GPRA Module Data Continued:
Data
Element
Label
Number
Data Element Label
Accessing the Data in CEKCUS
CERCI1S Table
Definition or URL
associated with Data
Label?
Options Available for
Display
-------
61



Construction
Complete


Views>Site Status and
Description/Operable
Units>Special Initiatives

SITE.site cc concurrence
date is not null


GPRA Module
contains definitions
for each GPRA
Milestone
-Yes
-No
-Not Applicable

22
-------
Attachment A- Methodology Used to Estimate Population within 1-Mile

Area Approximation Method
The latitude, longitude, and area of each site were pulled from the WasteLAN database. Site boundary shape files were not available; therefore, the site
boundary was represented by a circle with an equivalent site area centered around the site latitude/longitude. Using Arc View GIS 3.2, a circular buffer of 1-mile
radius was created around die circular site boundary.  Using 2000 Census Block data, all the census blocks were identified and the total population was
calculated in each buffer area.

Latitude/Longitude Method
For sites that do not have site area data, a point (located at the site latitude/longitude) was used for the boundary. Using Arc View GIS 3.2, a circular buffer of
1-mile radius was created around the point Using 2000 Census Block data, all the census blocks were identified and the total population was calculated in each
buffer area.

Population Density Estimate Method
For those sites in U.S. territories and protectorates (e.g., American Samoa, Guam, Virgin Islands) where Census Block data was not available, the population was
estimated by determining the population density of the island on which the site is located and multiplying it by the buffer area. This simple method does not take
into account density differences across the island or the presence of unpopulated areas (e.g, the ocean) within the buffer area.
23
-------
«=«^'
•<•
-------