UNITED STATES ENVIRONMENTAL PROTECTION
                             WASHINGTON, D.C, 20460
                                                                          OFFICE OF
                                                                    SOUD WASTE AN9 EMERGENCY
                                                                          RESPOND
                                                            OSWER 9320.1-18

                                 February 4, 2005


MEMORANDUM

SUBJECT:  Superfund Site Progress Profiles - Status Report

FROM:      Michael B. Cook, Director   /s/
             Office of Superfund Remediation and Technology Innovation

TO:         Superfund National Policy Managers, Regions 1-10

Purpose:

       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;//wvm,epa;gQ^                              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 tojiaje 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(ft>.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 Information>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
SITE.cngrsnl_dstrct_
code
N/A
ACTION.rat 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 fiirther information on how population within 1 -mile is calculated please see Attachment A.

-------
Federal Facility Data:
Data
Element
Label
Number
9
64
66
Data Element Label
Federal Facility
Designation
BRAC 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
Management>Project Schedule
CERCLIS Table
SITE.rfed_fclty_code = 'Y'
SITE.rbrac_code or
ref_program_priority
init.rppt_code = 'FT'
Action.rat code = ('BW,
'BX')
Definition or URL
associated with Data
Label?
No
Glossary Link
Glossary Link
Options Available for
Display
-'Null 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

80




28















Data Element Label



Cleanup Progress
Summary "Guys"
Cleanup Activities
Designation



NPL Status















Accessing the Data in CERCLJS



N/A

Views>Project
Nlanagement>Project Schedule



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




\







CERCUS Table



N/A

ACTION.rat_oode in
CBB',tBF',1IP','LV','LYyOF,'PD',PJ
','RA','RL','RV',TA') AND
action.act_actl_strt_date is not null

SITE.mpl status_code















Definition or URL
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




CERCLIS Table
(((Action.rat code = any CAT',
'AS', 'AY1, 'CM, 'CO1, 'CQ',
•DA', "ED', EE', EV, 'FE',
TM1, TS', 'GIvT, 'GR', 'GS',
•HA', HG', 'IP', 'JF', Tf, T.R',
•LV, 'LW, 1.X', "LV, MZ',
•ND', -NH1, -NT, 'OF', 'OM1,
•PD', 'RA', 'RC, -RD', fa', -RL',
•RO', "RS', TIV', 'SA', TA1,
TO', TS', 'WP') and
action.ralt code = any (MR1,
TS', 'RP', 'SR')) or
aotion.rat code = any ("BB1,
•BD', BE', BF', ME', -NA',
•NK', TJ1)) and
action.aot_actl_cmpltn_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

-Not displayed if there
is no PRP involvement


-------
Cleanup Progress Summary "Guys"
            Study
*;.   Study Underway
                                                                              Remedy Selected
           Design Underway
    Construction
    Underway
Construction
Complete
        /   Deleted from
       /    the NPL
                                         O
        Earty Action
        initiated/Completed

-------
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 CERCLJS
Views>Program
Management>Environmental
Indicators>Human Exposures
tab
Views>Program
Management>Environmental
Indicators>Ground Water
Releases tab
Views>Program
Management>Environmental
Indicators>Cleanup Volumes tab
Views>Program
Management>Environmental
Indicators>Populations Affected
tab
CERCLIS Table
ENVIRONMENTALJNDI
CATORS.rei code where
ENVIRONMENTAL_INDI
CATORS.reic_code = 'HE'.
EI_CLEANUP.ec_standard
amount where rmedia code
= ('DB', 'SB', 'SD', 'SF, 'SL',
'SO', 'ST, )
EI_CLEANUP.ec_standard
amount where rmedia code
= ('LWyGWYSWYLE')
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 CERCUS
Views>Program
Management>Environmental
Indicators>Populations Affected
tab
CERCLIS Table
EI_POPULATION_PROTE
CTED.epp_affected_amoun
t where
rpop rprotected 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 CERCLIS
Views>Remedy
Selection>Selected
Remedy>Select an
Action>Select Remedy
button>Select Add/Edit Media
button
CERCLIS 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
ENVIRONMENTALJNDI
CATORS.rei code where
ENVIRONMENTALJNDI
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' (action.rat_code = '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_flag)

    •   Construction Completion - 'Guy' is displayed when the Site Construction Completion Concurrence date is populated (site.cc_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"
 1s:; Cleanup Action
     initiated
Proposed to the
     NPL
Listed as Final on the
       NPL
     Final Remedy
       Selected
 Construction
  Complete
    Deleted from
      the NPL
14

-------
Cleanup Activities at this 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).

The 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, PRP 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
Management>Proj ect
Schedule>Select Record of
Decision>Select SCAP
button> Acres at site with
Land Ready for Restricted
Use

















CERCLIS Table
SITE, SITE_LAND_REUSE
where
slr_current_flag = 'V AND
sir acres ready restricted > 0
AND
(site.rfed_fclty_code o 'V or
site.rfed_fclty_code is null)
AND ( (site.rnpl status code in
(PVF.'D'.'R'.'W)) OR
(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
= 'NE')) OR
(site.rnpl_status_code=lN' and
exists (select 'x1 from action
where action. site_id =
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























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 land_reuse.site id AND
slr_current_flag = 'Y AND
sir acres ready unrestricted >
OAND
(site.rfed_fclty_code o 'V or
site.rfed_fclty_code is null)
AND ( (site.rnpl status code in
(TVF.'DVR'.W)) OR
(site.rnpl_status_code = tf and
exists (select 'x1 from
site_program_priority_init sppi
where sppi.site id = site.site id
and sppi.rppt_code = 'NE')) OR
(site.mpl_status code="N' and
exists (select V from action
where action.site_id =
site.site id and action.rat code
in ('RV,'BB') and
action.ract critical flag code =
Wand
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
CERCLIS
Views>Project
Management>Proj ect
Schedule>Select Record of
Decision>Select SCAP
button>Total Acres of Site
with Land Ready for Reuse


















CERCLIS Table
SITE, SITE_LAND_REUSE
where sir current flag = "V
AND
NVL(slr_acres_ready_restricte
d,0)+NVL(slr_acres_ready_unr
estricted,0) > 0 AND
(site.rfed_fclty_code o 'Y1 or
site.rfed_fclty_code is null)
AND( (site.rnpl status code in
(P'.'F.'D'.'R'.W)) OR
(site.mpl status code = "N* and
exists (select 'x' 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 'x1 from action
where action.site_id =
site.site id and action. rat code
in ('RVYBB') and
action.ract critical flag code =
Wand
action.act act! 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
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
Schedule>Select Record of
Decision>Select SCAP
button>Click More button>Click
Five- Year Review button
Views>Project
Management>Project
Schedule>Five-Year Review
action>Select SCAP
button>Click More
button>Protectiveness Statement
tab>Protectiveness drop-down
Views>Project
Management>Project
Schedule>Select Record of
Decision>Select SCAP
button>Click More button>Click
Five- Year Review button
CERCLIS 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
('FE'.'VY) 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,
displays most recent
Five- Year Review
-Not Protective
-Protective
-Protective in Short
Term
-Will be Protective
Once Remedy is
Complete
-Undetermined
(displayed when
rfyr_protectiveness_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 CERCIIS
Views>Site Status and
Description/Operable Units
Views>Project
Management>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 = "V
Use most recent
fsh_decision_date
FrNAL_REMEDY_Determi
nation.frd trigger action fl
ag = 'Y'
Definition or URL
associated with Data
Label?
GPRA 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
Groundwater
Migration












Views>Program
Management>Environmental
Indicators>Human Exposure tab








Views>Program
Management>Environmental
Indicators>Groundwater
Releases tab











EN VIRONMENTAL JNDI .
CATORS.rei_code = 'HE'
and
ENVIRONMENTALJNDI
CATORS.reic code = 'Y'
or 'N' or 'X'.





ENVIRONMENTALJNDI
CATORS.rei_code = 'GM
and
ENVIRONMENTALJNDI
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 CERCLJS
CERCLIS Table
Definition or URL
associated with Data
Label?
Options Available for
Display
21

-------
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 the 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

-------