United States Solid Waste and Directive 9200.3-01 C
Environmental Protection Emergency Response July 19S9
Agency (OS 240)
>EPA Superfund Program
Management Manual
Fiscal Year 1990
Volume 2 Appendices
Appendix A—FY 91 Methodologies
Appendix B—Applicability of the Freedom of
Information Act
Appendix C—Crosswalk for Enforcement
Activities and Remedies
Appendix D—Definitions
Appendix E—Select Logic for SCAP Reports
Appendix F—CEPP Program Planning
Requirements
Appendix G—Coding for Case Budget
PriMtd •« Rtcycltd Fmptr
-------
OSWER Directive 9200 3 01C
APPENDIX A
SCAP/SPMS METHODOLOGIES FOR TARGETS AND
MEASURES
-------
OSNVER Directive 9200 3 01C
APPENDIX A
This appendix represents the FY91 methodologies for deriving each of ihe
SCAP/SPMS targets and projection measures
If the application of the methodologies result in preliminary targets above the
national budget, a proportional calibration back to budget will be applied Thi> appendix
should be used as a tool for understanding the initial SCAP targets/measures i<
-------
O > iVER Directive 9200 3 01C
APPENDIX A
FY91 METHODOLOGIES
TABLE OF CONTENTS
PRE REMEDIAL METHODOLOGIES A 1
PA Completions A 1
SI Completions A 1
LSI Starts A 2
REMEDIAL METHODOLOGIES A 3
REMEDIAL INVESTIGATION/FEASIBILITY STUDY (1WFS) A 3
First RI/FS Starts Program PRP and PS Lead A 3
Subsequent RI/FS starts Program and PRP Lead A 3
RI/FS To Public Program and PRP lead A 4
First RI/FS Completion (ROD) Program and PRP Lead A 4
Subsequent RI/FS Completion (ROD) Program and PRP Lead A-4
Final RI/FS Completion (ROD) Program and PRP Lead A 4
REMEDIAL DESIGN (RD) A 5
First RD Starts Program and PRP Lead A 5
Subsequent RD Starts Program and PRP Lead A 5
Final RD Starts Program and PRP Lead A 6
RD Completions Program and PRP Lead A 6
REMEDIAL ACTION (RA) A 6
First RA Starts Program and PRP Lead A 6
Subsequent RA Starts Program and PRP Lead A 6
Final RA Starts Program and PRP Lead A 7
NPL Sites with RA Starts Post SARA Program and PRP 11 ad A 7
RA Completions Program and PRP Lead A 7
Final RA Completions A 7
NPL Deletion Initiation A 7
REMOVAL METHODOLOGIES A 7
NPL Removal Starts Program and PRP Lead A 7
Non NPL Removal Starts Program and PRP Lead A 8
Removal Completions Program and PRP Lead A 8
NPL Site Completions through Removal Actions Program c nd
PRP Lead A 8
ENFORCEMENT METHODOLOGIES A 9
PRP Search Start at Non NPL Sites A 9
PRP Search Start at NPL Sites A 9
RI/FS Negotiation Starts A 9
RD/RA Negotiation Starts A 9
Conclusion of RD/RA Negotiations A 9
Administrative Settlements A 10
107 Removal Referrals <$200K A 10
107 Removal Referrals >$200K A 10
107 RA (Remedial Referrals) >$200K (w/wo settlement) A 10
RD/RA Consent Decree Referrals A 11
RD/RA UAOs A 11
RD/RA Section 106 or 106/107 Referrals w/o Settlement All
-------
OSWER Directive 9200 3 01C
Section 107 Bankruptcies Referred A 12
UAOs or AOCs for PRP Removals (NPL and non NPL) A 12
Section 106 or 106/107 Case Resolution A 12
Section 107 Case Resolution A 12
Section 104 (e) Referrals A 12
Section 104 (e) Case Resolutions A 12
FEDERAL FACILITY METHODOLOGIES A 13
REMEDIAL INVESTIGATION/FEASIBILITY STUDIES
(RI/FS) A 13
Federal Facility RI/FS Start A 13
Federal Facility RI/FS Completion (ROD) A 13
REMEDIAL DESIGN (RD) A 13
Federal Facility RD Starts A 13
REMEDIAL ACTION (RA) A 13
Federal Facility RA Starts A 13
RA Starts Post SARA at NPL Sites A 13
ENFORCEMENT A 14
Signed Federal Facility Agreement/Interagency Agreements at NPL
Sites A 14
OIL SPILL PROGRAM METHODOLOGIES A 14
Oil Spills Cleaned Up Using Clean Water Act (CWA) Funds A 14
On Scene Monitoring of Responses to Oil Spills A 14
SPCC Inspections/Reviews A 14
-------
Oc WER Directive 9200 3 01C
PRE REMEDIAL METHODOLOGIES
PA Completions
METHODOLOGY The national PA completion target for FY91 reflects the
number of expected PA completions in the budget
A PA completion target for a particular region is established through tie following
procedures
Tabulate the number of sites in CERCLIS in each region
Project the number of sites to be added to CERCLIS in FY91 and add this
number to the number of sites in CERCLIS The projected number of sites
is determined by the number of sites added to CERCLIS between
November 1988 and November 1989
• Subtract the number of sites with actual PA completions and the FY90 PA
completion targets The result supplies the universe of sites without PA
completions
Determine each region s percentage of sites without PA completions
Multiply that percentage by the national target
DIFFERENCE FY90 FY91 The number of sites projected to be added to
CERCLIS during FY91 were added to the total number of sites to be < valuated
SI Completions
METHODOLOGY The national SI completion target for FY91 was < stablished as
a reasonable goal given the Agency s program priorities
Regional SI completion targets are derived through the following procedures
• Determine the number of sites in CERCLIS in each region
Subtract 1) the sites which have an SI recorded in CERCLIS 2) sites with
no further action PA completions and 3) FY90 SI completion targets The
results provide the universe of current sites without SI completions in each
region
~ Add to the universe of current sites without SI completions a projection on
the number of sites that will need Sis as a result of the FY90 PA effort The
projection is based on the FY90 PA completion target multiplied by the
region s No Further Action rate (Sites with PA completions divided by
sites with No Further Action PA Completion) This total represents the
complete universe of sites without SI completions in each region
» Calculate regional percentages and apply these percentages to the FY91
national budget target to determine preliminary FY91 regional targets
A 1
-------
OSWER Directive 9200 3 01C
• Tabulate the number of Sis needed to eliminate the pre SARA backlog in
regions VII IX
Compare these numbers to the preliminary FY91 targets for these regions
If the preliminary FY91 regional targets are greater than the regional pre
SARA SI backlog the preliminary FY91 targets for all regions become the
initial FY91 targets
• If the pre SARA SI backlog in regions VII VIII or IX is greater than their
preliminary FY91 regional targets compare the backlog Sis to the FY90 SI
targets in these regions If the backlog is greater than the FY90 targets the
FY91 preliminary regional targets become the FY91 initial targets in all
regions
If the SI backlog in regions VII VIII or IX is less than their FY90 target
the FY90 target becomes the initial FY91 targets for that region The initial
FY91 targets for the remaining regions will be recalculated
Subtract the FY91 targets for the regions able to eliminate the pre SARA
backlog from the FY91 national budget target and from the complete
universe of sites without SI completions
• Recalculate the regional percentages for the remaining regions and apply
these percentages to the revised national budget target to determine the initial
FY91 regional targets for the remaining regions
DIFFERENCE FY90 FY91 An attempt is made through the methodology to
eliminate the pre SARA SI backlog in Regions VII VIII and IX
LSI Starts
METHODOLOGY The national LSI start target for FY91 reflects the number of
expected LSIs in the budget The regional LSI start target is established through the
following procedures
Determine the number of sites in CERCLIS in each region which have had
an SI and do not have a final disposition of No Further Remedial Action
Planned (NFRAP)
Subtract the FY90 LSI targets
Add up the regional totals to obtain a national total of sites recommended for
LSIs
Determine the region s percentage of the total national number of sites
recommended for LSIs
• Apply this percentage to the national target for LSI starts
DIFFERENCE FY90 FY91 The FY90 LSI targets were subtracted from the
universe of available sites
A 2
-------
0>iVER Directive 9200 3 01C
REMEDIAL METHODOLOGIES
REMEDIAL INVESTIGATION/FEASIBILITY STUDY (RI/FS)
First RI/FS Starts Program. PRP and PS Lead
METHODOLOGY The national target for first RI/FS starts is based on the FY91
budget The regional targets are established through a combination oi the universe
unaddressed sites and regional performance in signing RODs The following in the
methodology
Determine each region s share of the universe of unaddressed sites and
divide it in half The universe of unaddressed sites is determined by
subtracting from the total number of NPL sites 1) the numbei of Federal
Facility sites 2) sites where a remedial event was started between FY80 and
FY89 and 3) FY90 first RI/FS starts target
Tabulate the FY88 and FY89 first RODs by region
Multiply the region s FY90 first ROD target by the region s I ^89 ROD
performance
Add the numbers generated in the steps above and calculate the regional
percentage
Multiply the regional percentages by the Fund financed and PRP lead
budget ceiling to generate program specific FY91 regional projections
PS lead
Based on the projected PS lead sites in CERCLIS calibrated b u k to the
budget
• Each region which plans a PS lead site in CERCLIS shall receive at least
one PS lead RI/FS
Dli-hiiRENCE FY90 FY91 Regional targets have been established lor PS lead
projects Past regional ROD performance was a factor in the development of initial
targets
Subsequent RI/FS starts Program and PRP Lead
METHODOLOGY The national candidate list for subsequent RI/FS starts is based
on projected subsequent starts in CERCLIS All RI/FS starts following the first
RI/FS are used to determine the subsequent RI/FS start candidate list
The regional subsequent RI/FS start list is determined by projects identified in
CERCLIS
DIFFERENCE FY90 FY91
A 3
-------
OSWER Directive 9200 3 01C
RI/FS To Public - Program and PRP lead
METHODOLOGY The overall annual target for RI/FS to public is determined by
adding together the number of RODs planned to be signed between second quarter
FY91 and first quarter FY92
The initial targets for regional RI/FS to public are based on the number of RODs
planned to be signed between second quarter FY91 and first quarter FY92
multiplied by regional FY89 ROD performance not to exceed 100%
DIFFERENCE FY90 FY91 Regional performance was factored into the target
First RI/FS Completion CROP) Program and PRP Lead
METHODOLOGY The annual target for first RI/FS completions is determined by
adding together the total number of projected first RODs for all regions in FY91 as
identified in CERCLIS
The initial target for regional first RI/FS completions is based on projections in
CERCLIS for Program and PRP lead first RODs multiplied by regional FY89 first
ROD performance against their target not to exceed 100%
DIFFERENCE FY90 FY91 Regional performance was factored into the target
Subsequent RI/FS Completion (ROD) Program and PRP Lead
METHODOLOGY The national and regional targets for subsequent RI/FS
completions are described by determining the scheduled subsequent RODs in FY91
in CERCLIS
The regional targets are developed based on the scheduled subsequent RODs in
CERCLIS multiplied by regional FY89 subsequent ROD performance not to exceed
100% of performance
DIFFERENCE FY90 FY91 Regional performance was factored into the target
Final RI/FS Completion ("ROD1 Program and PRP Lead
METHODOLOGY The annual target for final RI/FS completions is determined by
adding together the total number of projected final RODs for all regions in FY91 as
identified in CERCLIS
The initial target for regional final RODs is based on projections in CERCLrS for
Program and PRP lead final RODs multiplied by regional final ROD performance in
FY89 not to exceed 100%
DIFFERENCE FY90 FY91 Regional performance was factored into the target
A 4
-------
OSWER Directive 9200 3 01C
REMEDIAL DESIGN (RD)
First RD Starts Program and PRP Lead
METHODOLOGY The national target for first RD starts is based on the regions
projected first RD starts in CERCLIS
The methodology used to derive the first regional RD start targets is is follows
Initial first RD candidate list for each region is determined from the first RD
starts in FY91 and the FY90 Alternate first RD starts scheduled in
CERCLIS The candidate list is separated into Fund and PRP lead sites
• The historical rate of PRP takeovers from a Fund or State le id first ROD
were calculated for each region The rate of takeover was d< nved from
calculating the number of FY88 and FY89 Fund and State kcid first RODs
resulting in PRP first RD starts
• The region s Fund lead first RD starts identified in CERCLIS were
multiplied by the historical rate of PRP takeovers This results in the
projected PRP lead first RD starts
• The FY91 Program lead targets were obtained by 1) subtracting the
projected PRP lead first RD starts from the program lead first RD starts
identified in CERCLIS 2) Calculating a regional percentage of first Fund
lead RD starts based on the remaining events and 3) Multiplying the
regional percentage by the Fund financed ceiling
The FY91 PRP lead targets were obtained by 1) adding the projected PRP
lead first RD starts to the PRP lead first RD starts identified in CERCLIS 2)
Calculating the regional percentage of first PRP lead RD starts and 3)
Multiplying the percentage by the national budget target
DIFFERENCE FY90 FY91 The region s historical rate of PRP takeovers was
factored into the target setting
Subsequent RD Starts - Program and PRP Lead
METHODOLOGY The national target for subsequent RD starts is based on the
region s projected subsequent RD starts as identified in CERCLIS
• The initial target for regional subsequent RD starts are based on projections
for subsequent RD starts scheduled in FY91 and Alternate subsequent RD
starts scheduled in FY90 in CERCLIS for Program and PRP lead
subsequent RDs
• Calculate each region s percentage of the universe of Program and PRP lead
subsequent RD starts identified in CERCLIS
• Multiply these percentages by the national budget targets fcr program and
PRP lead subsequent RD starts
DIFFERENCE FY90 FY91
A 5
-------
OSWER Directive 9200 3 01C
Final RD Starts Program and PRP Lead
METHODOLOGY The national and regional targets for final RD starts are derived
by determining the scheduled final RD starts for FY91 in CERCLIS
DIFFERENCE FY90 FY91
RD Completions Program and PRP Lead
METHODOLOGY The initial national and regional targets for RD completions are
based on projected RD completions in FY91 from CERCLIS
DIFFERENCE FY90 FY91
REMEDIAL ACTION (RA)
Prior to finalization of the RA start targets Fund financed RAs scheduled to begin
in FY91 or FY90 alternate RA starts will have to be evaluated against an RA environmental
prioritization
First RA Starts Program and PRP Lead
METHODOLOGY The initial national target for first RA starts is based on 100%
of the regions Alternate and Queued first RA starts in FY90 and the projected
first RA starts in FY91 in CERCLIS
The methodology used to derive the regional first RA start targets is as follows
• Initial Program lead RA candidate list for each region is based on the
number of Alternate and Queued first RA starts in FY90 and the number
of scheduled first RA starts in FY91 (within the limits of funds available)
Initial PRP lead RA candidate list in each region is based on the number of
first PRP RA starts identified in CERCLIS in FY91
DIFFERENCE FY90 FY91 Methodology was expanded to include those sites not
funded in FY90
Subsequent RA Starts Program and PRP Lead
METHODOLOGY The national and regional targets for subsequent RA starts are
derived by determining the scheduled subsequent Alternate and Queued RA
starts in FY90 and subsequent RA starts in FY91 in CERCLIS
DIFFERENCE FY90 FY91 Methodology was expanded to include those sites not
funded in FY90
A 6
-------
OivVER Directive 9200 3 01C
Final RA Starts Program and PRP Lead
METHODOLQGY The national and regional targets are estabhshec. by
determining the number of final RA starts identified in CERCLIS in FY91
DIFFERENCE FY90 FY91
NPL Sites with RA Starts Post SARA Program and PRP Lead
METHODOLOGY The national and regional targets for post SARA RA starts are
derived by determining the scheduled post SARA RA starts in CERCLIS
DIFFERENCE FY90 FY91
RA Completions Program and PRP Lead
METHODOLOGY The initial national and regional targets for RA (ompletions are
based on 100% of the candidate sites for first or subsequent RA completions
recorded in CERCLIS Final targets are set after negotiations
DIFFERENCE FY90 FY91
Final RA Completions
METHODOLOGY The national and regional targets for final RA completions are
derived by determining the scheduled final RA completions in FY91 :n CERCLIS
DIFFERENCE FY90-FY91
NPL Deletion Initiation
METHODOLOGY National and regional targets for NPL deletion initiation are
based on FY91 projected deletions in CERCLIS
DIFFERENCE FY90 FY91
REMOVAL METHODOLOGIES
NPL Removal Starts Program and PRP Lead
METHODOLOGY The national target for NPL removal activity includes Fund
financed and PRP removal actions taken under CERCLA at NPL sit;s
The initial regional Fund financed and PRP lead NPL removals targ< t methodology
as follows
• Determine each region's percentage of the combined number of Fund
financed NPL removal starts and PRP NPL removal completions for FY87
through FY89
A 7
-------
OSWER Directive 9200 3 01C
• Multiply this percentage by the national Fund lead NPL removal target to get
the preliminary NPL regional removal target
• Determine each region s percentage of the PRP NPL removals completed in
the last three years where a formal enforcement action (settlement or order)
has been required
• Muloply this percentage by the national PRP NPL removal target to
determine the preliminary regional PRP NPL removal target
DIFFERENCE FY90 FY91
Non NPL Removal Starts Program and PRP Lead
METHODOLOGY
• Determine each region s percentage of FY87 FY89 non NPL Fund
removal starts and PRP removal completions
Multiply this percentage by the national non NPL removal target to obtain
the region s target
• Multiply the regional non NPL removal target by the region s percentage of
non NPL PRP removals completed in the last three years where a formal
enforcement action (settlement or order) has been required to determine the
Fund/PRP distribution
DIFFERENCE FY90 FY91 The PRP removal calculations have been revised
Removal Completions - Program and PRP Lead
METHODOLOGY The initial national target for removal completions is based on
projected FY91 completions from the regions This target is very flexible and final
SCAP targets for removal completions will be determined only after extensive
discussions with the regions
Regional targets are determined using the following steps
Regions submit their projections for removal completions for FY91 through
the CERCLIS non site data base
• HQ totals each region s projections These projections become the initial
completion targets for each region (Completion targets should coincide to a
great extent with the region s NPL and non NPL start target)
DIFFERENCE FY90 FY91
NPL Site Completions through Removal Actions Program and PRP Lead
METHODOLOGY The initial naoonal target for NPL site completions through
removal actions is based on projected FY91 completions from the regions
A 8
-------
OnVER Directive 9200 3 01C
Regions submit their projections for NPL site completions through removal actions
for FY91 through the CERCLIS non site data base
DIFFERENCE FY90 FY91
ENFORCEMENT METHODOLOGIES
PRP Search Start at Non NPL Sites
MLTHODOLOG Y National and regional projections are based on 100% of all
targeted non NPL removals
Dll-FERENCE FY90 FY91 This is a new methodology for FY9
PRP Search Start at NPL Sites
MTTHODOLOG Y National and regional projections are based on 100% of all
sites scheduled for RI/FS start in FY91 This assumption was madt consistent
with the FY91 budget assumption
DIFFERENCE FY90 FY91 FY90 was based on the number of sites added to the
NPL rather than sites scheduled for RI/FS start
RI/FS Negotiation Starts
METHODOLOGY The national and regional projections are based on 90% of a
region s target for FY91 RI/FS starts This assumption was made consistent with
the FY91 budget assumptions
DIFFERENCE FY90 FY91 FY90 assumed negotiations started one quarter prior
to the RI/FS
RD/RA Negotiation Starts
METHODOLOGY The national and regional targets are based on ()0% of the
FY91 RODs scheduled for the Fund or PRPs This methodology i< based on the
following assumptions RD/RA negotiations will begin the same qi.arter as the
ROD no PS or IT lead RODs will be included and 10% of the RODs will be at
orphan sites The assumption RD/RA negotiations begin the same quarter as the
ROD was made to be consistent with the FY91 Budget Assumptions
DIFFERENCE FY90 FY91 FY90 assumed negotiations began one quarter prior
to the ROD FY91 assumes negotiations begin the same quarter as the ROD
Conclusion of RD/RA Negotiations
METHODOLOG Y The national and regional targets are based on 90% of the
F"V 91 RODs scheduled by the Fund or PRPs scheduled for completion 90/3 91/2
A 9
-------
OSWER Directive 9200 3 01C
This methodology is based on the assumptions RD/RA negotiations will begin the
same quarter as the ROD and end two quarters post ROD no PS or FF lead RODs
will be included and 10% of the RODs will be at orphan sites
DIFFERENCE FY90 FY91
Administrative Settlements
METHODOLOG Y The national and regional projections are based on 20% of the
unaddressed sites <$200K as identified in the Cost Recovery Category Report
(CRCR) If sufficient resources are not available each region will receive two
targets and the remaining resources will be distributed based on the percentage of
the remaining universe of unaddressed sites
DIFFERENCE FY90 FY91 This is a new methodology for FY91
107 Removal Referrals <$200K
METHODOLOGY The national and regional projections are based on 5% of the
unaddressed removal cost recovery universe <$2CK)K as identified in the CRCR
DIFFERENCE FY90 FY91 This is a new methodology for FY91
107 Removal Referrals >$200K
METHODOLOGY In FY91 each region will receive one preliminary target based
on the total unaddressed removal cost recovery universe >$200k as identified in the
CRCR The remainder of resources will be distributed based on the percentage of
the remaining universe
DIhhERENCE FY90 FY91 Preliminary target only with no selection criteria in
FY91
107 RA (Remedial Referralsl >$200K (w/wo settlement)
METHODOLOGY The following steps outline the methodology for determining
national and regional targets
• An initial universe of candidates is identified It is based on sites where
RAs are to be started by 12/31/90 and where the site will not be fully
addressed with respect to cost recovery before FY91 by referral
filing or settlement
RI/FS or RDs completed in calendar year 1988 where on site
constructions of the RA will not begin within three years of the
completion dates and where the sites will not be referred filed or
settled addressing the costs at the site
• From each of the above regions should
A 10
-------
OSWER Directive 9200 3 01C
Subtract cases identified for no further cost recovery c c tions
Determine the regional total of remaining RI/FS and RD universe
and remaining RA universe for cost recovery
Targets will be based on all remaining RI/FS and RD universe plus a
percentage of remaining RA universe in the CRCR E ach region
will receive at least one preliminary target
Note Negotiations will prioritize non settler 107 referrals and
Statute of Limitations (SOL) sites
• With settlement and without settlement split will be based on historical
performances (FY87 FY89) combining 107 and 106/107
DIFFERENCE FY90 FY91 Criteria to select candidates has been modified
RD/RA Consent Decree Referrals
Mb" 1 HODOIXXjY The national and regional targets are based on 75% of
targeted RD/RA completions in FY91
DIFFERENCE FY90 FY91 The FY90 methodology for 106 RD/RA
Referrals/Orders has been split into three categories for FY91 RD/RA Consent
Deciee Referrals RD/RA UAOs and RD/RA Section 106 or 106/107 Referrals w/o
settlement Therefore this is a new methodology for FY91
RD/RA UAOs
Mb" 1HODOLOGY The national and regional targets are based on 25% of
targeted RD/RA negotiation completions in FY91
DIFFERENCE FY90 FY91 The FY90 methodology for 106 RD/.RA
Referrals/Orders has been split into three categories for FY91 RD/F.A Consent
Decree Referrals RD/RA UAOs and RD/RA Section 106 or 106/107 Referrals w/o
settlement Therefore this is a new methodology for FY91
RD/RA Section 106 or 106/107 Referrals w/o Settlement
Mb" 1 HODOLOGY The national and regional targets are based on 5% of
completed RD/RA negotiations
DIFFERENCE FY90 FY91 The FY90 methodology for 106 RD/RA
Referrals/Orders has been split into three categories for FY91 RD/RA Consent
Deciee Referrals RD/RA UAOs and RD/RA Section 106 or 106/107 Referrals w/o
settlement Therefore this is a new methodology for FY91
A 11
-------
OSWER Directive 9200 3 01C
Section 107 Bankruptcies Referred
Mb" 1HODOLOGY The national and regional projections are based on one
bankruptcy per region
DIFFERENCE FY90 FY91 This is a new methodology for FY91
UAOs or AOCs for PRP Removals (NPL and non NPL1)
METHODOLOGY The national and regional projections are based on 70% of
the universe of targeted NPL and Non NPL removals
D lb FERE NCEFY90 FY91 The percentage of removals with orders is expected
to increase substantially in FY91 FY90 projections were based on a lower
percentage rate
Section 106 or 106/107 Case Resolution
METHODOLOGY The national and regional projections are based on the
number scheduled in CERCLIS
DIFFERENCE FY90 FY91 The FY90 methodology for 106/107 Case
Resolution/Cost Recovery Judicial Settlement has been split into two categories for
FY91 106 or 106/107 Case Resolution and 107 Case Resolution Therefore this
is a new methodology for FY91
Section 107 Case Resolution
METHODOLOGY The national and regional projections are based on the
number scheduled in CERCLIS
DIFFERENCE FY90 FY91 The FY90 methodology for 106/107 Case
Resolution/Cost Recovery Judicial Settlement has been split into two categories for
FY91 106 or 106/107 Case Resolution and 107 Case Resolution Therefore this
is a new methodology for FY91
Section 104 (el Referrals
Mb" 1 HODOLOGY The national and regional projections are based on 5% of the
total of NPL and Non NPL PRP search starts
DIFFERENCE FY90 FY91 This is a new methodology for FY91
Section 104 (e) Case Resolutions
METHODOLOGY The national and regional projections are based on the
number scheduled in CERCLIS
DIFFERENCE FY90 FY91 This is a new methodology for FY91
A 12
-------
OSWER Directive 9200 3 QIC
FEDERAL FACILITY METHODOLOGIES
REMEDIAL INVESTIGATION/FEASIBILITY STUDIES (RI/FS)
Federal Facility RI/FS Start
METHODOLOGY The initial national and regional targets for Federal Facility
RI/FS starts are based on projected RI/FS starts for FY91 in CERCLIS
DIFFERENCE FY90 FY91 New methodology for FY91
Federal Facility RI/FS Completion (ROD1
MFTHODOLOGY The national and regional candidate list for Fed( ial Facility
RODs is based on projected Federal Facility RODs in the CERCLIS iccords as
reported by the regions
DIFFERENCE FY90 FY91
REMEDIAL DESIGN (RD)
Federal Facility RD Starts
METHODOLOGY The initial national and regional targets for Fedt ial Facility RD
starts are based on projected RD starts for FY91 in CERCLIS
DIFFERENCE FY90 FY91 New methodology for FY91
REMEDIAL ACTION (RA)
Federal Facility RA Starts
METHODOLOGY The initial national and regional targets for Fedu al Facility RA
starts are based on projected RA starts for FY91 in CERCLIS
DIFFERENCE FY90-FY91 New methodology for FY91
RA Starts Post SARA at NPL Sites
METHODOLOGY The national and regional candidate list for Federal Facility RA
starts post SARA at NPL sites is based on projected sites in CERCL IS
DIFFERENCE FY90 FY91
A 13
-------
OSWER Directive 9200 3 01C
ENFORCEMENT
Signed Federal Facility Agreement/Interagencv Agreements at NPL Sites
METHODOLOGY The national and regional methodology for Interagency
Agreements at NPL sites is based on the number of proposed or final NP Federal
Facilities in each region without a signed FFA/IAG
DIFFERENCE FY90 FY91
OIL SPILL PROGRAM METHODOLOGIES
Oil Spills Cleaned Up Using Clean Water Act (CWA1 Funds
METHODOLOGY The national measure for this activity is based on the
President s budget
Determine each Region s percentage of FY87 FY89 spill cleanups Multiply this
by the national total to establish the region s share
DIFFERENCE FY90 FY91
On Scene Monitoring of Responses to Oil Spills
METHODOLOGY The national measure for this activity is based on the
President s budget
Determine each region s percentage of FY87 FY89 monitoring actions Multiply
this by the national total to establish the region s share
DIFFERENCE FY90 FY91
SPCC Inspections/Reviews
METHODOLOGY The national SPCC Inspection/Review measures are presented
in the President s budget
Determine each region s percentage pf FY87 FY89 SPCC inspections Multiply
this by the national total to establish the region s share
DIFFERENCE FY90 FY91
A 14
-------
OSWER Dircctivi 9200 3 01C
APPENDIX B
APPLICABILITY OF THE FREEDOM OF INFORMATION AC T TO SCAP
-------
OSWER Directive 9200 3 01C
APPENDIX B
APPLICABILITY OF THE FREEDOM OF INFORMATION ACT TO SCAP
TABLE OF CONTENTS
APPLICABILITY OF THE FREEDOM OF
INFORMATION ACT TO SCAP B 1
CERCLIS REPORTS RELEASABLE UNDER FOIA B 1
SENSITIVE SCAP-RELATED INFORMATION B 1
Exemption 7 Records or Information Compiled For Law Enforc e ment
Purposes B 2
Exemption 5 Privileged Interagency or Intra Agency Memoranda B 3
AD HOC REPORTING B 4
-------
OSWER Directive 0200 3 01C
APPLICABILITY OF THE FREEDOM OF
INFORMATION ACT TO SCAP
CERCLIS REPORTS RELEASABLE UNDER FOIA
There are a set of CERCLIS generated reports that have all sensitive matenal (records
or information that are protected under FOIA and cannot be released to the public) • emoved
and may be released under FOIA These include
• SCAP 11 (Public SCAP NPL Site Summary)
• SCAP 12 (Public SCAP Non NPL Site Summary)
List 1 (Site Location)
List 3 (Site/Alias Crosswalk)
• List 4 (Site/Alias Location)
List 8 (Site/Event Status) and
AUDT 11 (Final and Proposed NPL Sites)
SENSITIVE SCAP RELATED INFORMATION
FOIA is intended as a disclosure law not a withholding law In handling all FOIA
requests there should be a presumption in favor of releasing information There ire certain
types of information however that have been designated as restricted and therefore not
reLasable to the public because disclosure could cause significant harm to the Ag< ncy The
following information fits into this category
Section 106 and 107 Litigation and Consent Decees and all elated
information where the planning information indicate that the action has or will
be referred to HQ or to DOJ If the case is filed the information nay be
released
• PRP lead RI/FSs and all related information where only planning data exist
If there is an actual PRP RI/FS start the planned completion date (I Y/Q) can
be released No subsequent response date are releasable however
RD/RA AO/CD and all related information where only planning dita exist
This information is only releasable where an actual completion dale exists
~ Planned obligation amounts related to case budget activity associated with the
following activities
Litigation (106 106/107 107) Support
Removal negotiations
Non NPL and NPL PRP search
RI/FS negotiations
RD/RA negotiations and
B 1
-------
OSWER Directive 9200 3 01C
Cost recovery negotiations
RD and RA planned events where the lead is the RP with no actual starts
When there is an actual start the planned completion can be released
RI/FS and RD/RA negotiations planned start and completion dates When
there is an actual start the planned completion can be released
Compliance code and status indicator
Planned removal/remedial obligations
All planned activities for sites that have not been designated as final or
proposed NPL sites in the Federal Register
Information against the viability of the case on PRPs
This information is protected from mandatory disclosure by the following FOLA
exemptions and provisions
• Information falling under numbers 1 8 EXEMPTION 7 Records or
information compiled for law enforcement purposes Specifically
EXEMPTION 7 (a) Could reasonably be expected to interfere with
enforcement proceedings
Exemption 7 Records or Information Compiled For Law Enforcement Purposes
This exemption provides that records or information compiled for law
enforcement purposes need not be disclosed in six specific instances Even though a
document falls under Exemption 7 the Agency in its discretion encourages release
of the document unless release would significantly harm the Agency Under this
section records or information can be exempted if
Exemption 7(a) Disclosure could reasonably be expected to interfere
with enforcement proceedings Harm to the government s case in
court by premature release of evidence or information or damage to the
Agency s ability to conduct an investigation constitutes interference
under the exemption
Exemption 7(b) Disclosure would deprive a person of a right to fair
trial
Exemption 7(c) Disclosure could reasonably be expected to
constitute an unwarranted invasion of personal privacy
• Exemption 7(d) Disclosure could reasonably be expected to disclose
the identity of a confidential source This includes protection of
information provided by the source on a criminal law enforcement
investigation
• Exemption 7(e) Disclosure would reveal a special technique or
procedure for law enforcement investigations or prosecutions
B 2
-------
OSWER Directne 9200 3 01C
• Exemption 7(f) Disclosure could reasonably be expected to
endanger the life or safety of any person
As a result of 1986 Amendments to FOIA Exemption 7 the general coverage
of Exemption 7 is no longer investigatory records but records or information
compiled for law enforcement purposes As long as some law enforcement
authority exists and the record meets the threshold test for Exempuon 7 The
record need no longer reflect or result from specifically focused inquiries by
the Agency
• Information falling under number 9 EXEMPTION 5 Privileged
Interagency or Intra Agency Memoranda Specifically E
-------
OSWER Directive 9200 3 01C
The Attorney Work Product Privilege allows the withholding of
documents prepared in anticipation of possible lmgation Litigation
need not have commenced but it must be reasonably contemplated
This privilege does not extend to purely factual documents unless they
reflect the results of an attorney s evaluation
• The Attorney Client Privilege applies to confidential communications
between attorney and client including communications between an
Agency attorney and an Agency employee
• The Government Commercial Information Privilege is available to the
government for information it generates in the process leading up to
the award of a contract This privilege expires once the contract is
awarded or upon withdrawal of the contractual offer An example of
this privilege is cost estimates prepared by the government and used to
evaluate the construction proposals of private contractors
The Expert Witness Privilege is commonly invoked to allow the
withholding of records generated by an expert witness
The Confidential Witness Statement Privilege allows statements
obtained from confidential witnesses to be withheld
The Agency encourages the discretionary release of documents falling under
any of the privileges unless release would significantly harm the Agency
decision making process All of the privileges may be waived if the Agency
has disclosed the document to third parties
The sensitive information listed in numbers 1 10 above covers the information
restricted from public disclosure as of the compilaoon of this manual Addmonal information
may be added to this category and information may be restricted in specific instances (though
the prior disclosure rule must be adhered to) If requested information is potentially able to
be restricted under a FOLA provision (in this case under Exemptions 5 or 7) the official
receiving the request should contact the appropriate FOLA office to determine whether the
information should be restricted
AD HOC REPORTING
In general all regional requests for ad hoc reporting a special request for records or
information that is not part of the approved Public SCAP Reports should be referred to HQ
(the CERCLA Enforcement Division Director) immediately The regional official receiving
the request should inform the requestor of this policy and advise the requestor to contact HQ
for a decision on whether this information may be released If the requested information is
only available from a specific region and HQ has decided to release this information HQ
will inform the responsible region that the information should be compiled and disclosed to
the requestor
Ad hoc reporting requests should be treated like a FOLA request This includes the
following
If the informaoon is protected under one of the FOLA exemptions the
information will not be disclosed (except in cases of discreoonary release)
B 4
-------
OSWER Directive 9200 3 01C
• Absent FOIA exemption protection the information will be disclosed if it can
be compiled or obtained in a reasonable amount of time by an Agt ncy
employee familiar with the subject area
Fees for ad hoc reporting requests will be charged in accordance a ith the fee
structure used for FOIA requests
Depending on the complexity of the request Agency personnel will not hcive to
undertake the specific logging and routing procedures required for FOIA requesi <
However the request should be kept on file in a designated ad hoc reporting request file
If a request is very complex or compilation of the requested information -vould be
very time consuming the request should be denied If the requestor appeals this
determination the requestor should be informed that the request must be formulc ted into an
official FOIA request (a written request for specific records citing FOIA) and mu(t be sent to
the FOIA office
B 5
-------
O'WER Directive 9200 3 01C
APPENDIX C
CERCLIS CROSSWALK FOR ENFORCEMENT
ACTIVITIES AND REMEDIES
-------
APPENDIX C
OSWER Directive 9200 3 0:
CERCLIS CROSSWALK FOR
ENFORCEMENT ACTIVITIES AND REMEDIES
ENFORCEMENT
ACTIVITIES (C1701)
REMEDIES (Sought or Achieved
bv Enforcement Activities) (C2731)
EVENTS (C2101)
CERCLIS
Activity
Code
CERCLIS
Remedy
Code
CERCLIS
Event
Code
Claim in Bankruptcy
CB
N/A
Preliminary Injunction
PI
N/A
Section 106 Litigation
SX
Document Exchange
Expedited Response Action
Feasibility Study
Initial Remedial Measure
(historical only)
Interest
Lien on Property
Long Term Response
Operations & Maintenance
Other
Permanent Relocation
Premium
Remedial Design
Remedial Action
Remedial Investigation
Removal Action
RI/FS
Site Access
Temporary Relocation
DE
ER
FS
IM
IN
LP
LR
OM
OH
RE
PR
RD
RA
RI
RV
CO
SE
TR
EF
FS
IVI
LF
CM
OH
RF
RD
RA
KI
RV
CO
T F
Section 106/107
Litigation
CL
Same as Section 106
Litigation plus
Cost Recovery Oversight
Cost Recovery of RA
Cost Recovery of RD
Cost Recovery of Removal
Cost Recovery of RI/FS
Other Cost Recovery
VS
VA
VD
VM
VO
OH
Section 107 Litigation
SV
Cost Recovery Oversight
Cost Recovery of RA
Cost Recovery of RD
Cost Recovery of Removal
Cost Recovery of RI/FS
VS
VA
VD
VM
VO
Tempor iry Restraining
Order
TE
N/A
C 1
-------
APPENDIX C
CERCLIS CROSSWALK FOR
ENFORCEMENT ACTIVITIES AND REMEDIES
OSWER Directive 9200 3 01
ENFORCEMENT
REMEDIES (Sought or Achieved
cvirMTS fpiinn
ACTIVITIES r C1701)
bv Enforcement Activities) (C2731
)
CERCLIS
CERCLIS
CERCLIS
Activity
Remedy
Event
Code
Code
Code
1 Neeotiation Activity
Cost Recovery
NE
Cost Recovery Oversight
VS
Negotiation
Cost Recovery of RA
VA
Cost Recovery of RD
VD
Cost Recovery of Removal
VM
Cost Recovery of RI/FS
VO
RD/RA Negotiations
AN
RI/FS
CO
Removal Cost Recovery
OM
Remedial Design
RD
RI/FS Cost Recovery
VO
Remedial Action
RA
RD Cost Recovery
VD
RA Cost Recovery
VA
Removal Negotiations
RN
Expedited Response Action
ER
Removal Action
RV
Site Access
SE
Temporary Relocation
TR
TR
RI/FS Negotiation
FN
Feasability Study
FS
Remedial Investgations
RI
RI/FS
CO
Removal Cost Recovery
VM
3 Notice Letter Activities
Notice Letters Issued
NI
N/A
4 Order Activities
Administrative Order
AC
Cost Recovery Oversight
VS
on Consent
Cost Recovery of RA
VA
Cost Recovery of RD
VD
Cost Recovery of Removal
VM
Cost Recovery of RI/FS
VO
Document Exchange
DE
ER
Expedited Response Action
ER
Feasibility Study
FS
FS
Initial Remedial Measure
IM
(historical only)
IM
Interest
IN
LR
Long Term Response
LR
Operations & Maintenance
OM
OM
Other
OH
OH
Permanent Relocation
RE
RE
Premium
PR
Remedial Design
RD
RD
Remedial Action
RA
RA
Remedial Investigation
RI
RI
Removal Action
RV
RV
RI/FS
CO
CO
Site Access
SE
TR
Temporary Relocation
TR
C 2
-------
OSWER Directive 9200 3 01C
APPENDIX C
CERCLIS CROSSWALK FOR
ENFORCEMENT ACTIVITIES AND REMEDIES
ENFORCEMENT
ACTIVITIES f C1701)
REMEDIES (Sought or Achieved
bv Enforcement Activities) (C273!
)
EVENTS (C2101)
CERCLIS
Activity
Code
CERCLIS
Remedy
Code
CERC 1 IS
Event
Code
Order Activities fCcmt 1
UrulateraJ
Admmisti auve
Order
5 RP Search/Other
Activities
Non NPL Removal RP
Search
NPL RP Search
Issue Cosi Recovery
Decision Document
UA
RP
NS
DD
Same as AO on Consent
N/A
N/A
N/A
Prepare Cost
Documentation Package
PC
N/A
6 Settlement Activities
AdmimsD auve/
Voluntary Cost Rec
AV
Cost Recovery Oversight
Cost Recovery of RA
Cost Recovery of RD
Cost Recovery of Removal
Cost Recovery of RI/FS
VS
VA
VD
VM
VO
C 3
-------
APPENDIX C
CERCLIS CROSSWALK FOR
ENFORCEMENT ACTIVITIES AND REMEDIES
OSWER Directive 9200 3 01C
ENFORCEMENT
REMEDIES (Sought or Achieved
* J % Ifpfl / /-¦« A 1 A ( \
ACTIVITIES (CI70I)
by Enforcement Activities) (C273I)
EVENTS (C2101)
CERCLIS
CERCLIS
CERCLIS
Activity
Remedy
Event
Code
Code
Code
1 Settlement Activities
(Cont)
Consent Decree
CD
Cost Recovery Oversight
VS
Cost Recovery of RA
VA
Cost Recovery of RD
VD
Cost Recovery of Removal
VM
Cost Recovery of RI/FS
VO
Document Exchange
DE
Expedited Response Action
ER
ER
Feasibility Study
FS
FS
Initial Remedial Measure
(historical only)
IM
IM
Interest
IN
Lien on Property
LP
Long Term Response
LR
LR
Operations & Maintenance
OM
OM
Other
OH
OH
Permanent Relocation
RE
RE
Premium
PR
Remedial Design
RD
RD
Remedial Action
RA
RA
Remedial Investigation
RI
RI
Removal Action
RV
RV
RI/FS
CO
CO
Site Access
SE
Temporary Relocation
TR
TR
Federal Interagency
FI
Same as Consent Decree
Agreement
except no Lien on Property
Judgement
JG
Same as Consent Decree
except no Lien on Property
-------
OSWhR Directive 9200 3 01C
APPENDIX D
SCAP/SPMS TECHNICAL DEFINITIONS
-------
OSWCR Directive 9200 3 01C
Section I
SCAP/SPMS DEFINITIONS FOR TARGETS AND MEASURES
The definitions contained in this Appendix are those that were available at the time the
Manual went to the printer
Every effort has been made to ensure that the definitions
contained herein for SCAP and SPMS targets and measures were
consistent If there are inconsistencies, the SPMS definition is the
official definition If SPMS definitions are revised during the year an addendum to the
SCAP Manual will be published
-------
OSWER Directive 9200 3 01C
APPENDIX D
SCAP/SPMS TECHNICAL DEFINITIONS
TABLE OF CONTENTS
PRE-REMEDIAL PROGRAM DEFINITIONS D 1
INTRODUCTION D 1
PA Completions D-l
SI Completions D 1
LSI Starts D 2
Percent SI Candidates Completed D 2
REMEDIAL PROGRAM DEFINITIONS D 4
INTRODUCTION D^
REMEDIAL INVESTIGATION/FEASIBILITY STUDIES
(RI/FS) DA
RI/FS Start First and Subsequent D 4
Percent NPL Sites Addressed D 6
RI/FS to Public D 6
RI/FS Completion — First Subsequent and Final D 6
REMEDIAL DESIGN (RD) D 8
RD Starts - First Subsequent and Final D 8
RD Completions D 9
REMEDIAL ACTION (RA) D 11
RA Start — First Subsequent, and Final D 11
RA Starts Post-SARA at NPL Sites D 12
RA Completion First, Subsequent and Final D 12
NPL Deletion Initiation D 13
REMOVAL PROGRAM DEFINITIONS D-16
INTRODUCTION D 16
REMOVAL ACTIVITIES D 16
Removal Investigations at NPL Sites D-16
Removal Starts — NPL and Non NPL D-17
Removal Completions D 17
NPL Site Completions through Removal Actions D-18
ENFORCEMENT DEFINITIONS D-20
INTRODUCTION D 20
PRP SEARCHES AND NEGOTIATIONS D-20
Issuance of General Notice Letters D-20
Issuance of Special Notice Letters D 21
Section 104(e) Letters Issued D 22
Start of PRP Search D-22
Completed PRP Search D 22
Start of RI/FS Negotiations D 23
Conclusion of RI/FS Negotiations D 23
-------
OSWER Directive 9200 3 01C
Start of RD/RA Negotiations D-24
Conclusion of RD/RA Negotiations D 24
Start of Removal Negotiations D 24
Completion of Removal Negotiations D-25
SETTLEMENTS, REFERRALS AND OVERSIGHT D 28
Section 104(e) Referrals/Order D 28
Administrative Record Compilation Completion (Remedial and
Removal) D 28
Compliance Enforcement D 29
Section 106, 106/107 Case Resolution D 29
Section 107 Case Resolution D 29
Cost Recovery Dollars Achieved D-30
Section 106 or 106/107 RD/RA Referrals and Unilateral
Administrative D 30
Cost Recovery Cases Referred to DO J or HQ (>$200K) D 31
Small Case Cost Recovery Referrals and Administrative Settlements D 32
Administrative Order for Removal Actions D-33
FEDERAL FACILITY DEFINITIONS D-37
INTRODUCTION D 37
REMEDIAL D 37
Federal Facility RI/FS Starts D-37
Federal Facility RI/FS Completion (ROD) D 37
RD Starts D 37
RA Starts D 38
RA Starts Post-SARA at NPL Sites D-38
ENFORCEMENT D 39
Signed Federal Facility Agreement/Interagency Agreements at NPL
Sites D 39
OIL SPILL ACTIVITY DEFINITIONS D 41
INTRODUCTION D-41
Oil Spills Cleaned up Using Clean Water Act (CWA) Funds D-41
On Scene Monitoring of Responses to Oil Spills D-41
Spill Prevention Control and Countermeasure (SPCC)
Inspections/Reviews D-41
REMEDIAL PROGRAM DEFINITIONS D 43
PROJECT SUPPORT D-43
Community Relations D 43
Design Assistance D 43
Forward Planning D-43
Long Term Response (LTR) D 44
Management Assistance D 44
Operation and Maintenance (O&M) D 45
Technical Assistance D-45
Technical Assistance Grants D 46
Treatability Study D 46
-------
OSWER Directive 9200 3 01C
REMOVAL DEFINITIONS
NPL SITES
Expedited Response Action (ERA)
HAZARDOUS SUBSTANCES RELEASE
Hazardous Substances Release Notification
Hazardous Substances Release Investigations
On Scene Monitoring of Responses to Hazardous Substance
Releases D 48
FEDERAL FACILITY DEFINITIONS D-48
PRE-REMEDIAL D-48
PA Completions D-48
SI Completions D-48
D-46
D-46
D 46
D-47
D-47
D-47
-------
OSWER Directive 9200 3 01C
SCAP/SPMS DEFINITIONS FOR TARGETS AND MLASURES
PRE-REMEDTAI, PROGRAM DEFINITIONS
INTRODUCTION
The pre-remedial targets/measures track the initial events at Superfund sites Four
pre remedial events are projected and tracked through the SCAP/SPMS pixx ess
• Preliminary Assessment (PA) Completions,
• Screening Site Inspection (SI) Completions
• Listing Site Inspection (LSI) Starts, and
• Percent SI Candidates Requiring Further Action
PA completions are SCAP targets LSI starts are SCAP measures only no
corresponding SPMS target or measure is set PA and SI completion target»are set on a
quarterly basis LSI starts are established on an annual basis Regions propose targets for
all pre-remedial activities in the CERHELP non site/incident data system F unds for pre
remedial activities are included in the other remedial AOA
ACTIVITY PA Completions
DEFINITION A preliminary assessment is the first stage of site ass< ssment which
determines whether a site should be recommended for further CERCLA action
Federal State and local government files geological and hydrologii il data and
data concerning site practices are reviewed to complete the PA report
DEFINITION OF ACCOMPLISHMENT A PA is complete when iJie report is
reviewed and approved by the region and CERCLIS contains the PA completion
date and the decision on further activities is shown in the Event Qualifier Field
Although a site can have multiple PAs only the first completed PA with an 'S or
F lead counts toward the target
CHANGES IN DEFINITION FY89-FY9Q
SPECIAL PLANNING REQUIREMENTS Commitments are made based on the
sum of the EPA/FIT and State conducted PAs However for budget and resource
allocations, separate projections must be made for EPA/M l vs Stat< PA
completions Separate commitments are also made for sites which an being
assessed under CERCLA as part of the Environmental Priorities Initiative Regions
propose targets in the CERHELP non-site data system Accomplishments are
reported in the site-specific CERCLIS data system
ACTIVITY SI Completions
DEFINITION The site inspection involves collection of field data from a
hazardous substance site for the purpose of characterizing the magnitude and
seventy of the hazard posed by the site and/or to support enforcement. An SI
should provide adequate data to determine the site s Hazard Ranking System (HRS)
score
D-l
-------
OSWER Directive 9200 3 01C
DEFINITION OF ACCOMPLISHMENT An SI is complete when the SI is
reviewed and approved by the region and CERCLIS contains the SI completion
date and the decision on further activities shown in the Event Qualifier Field
Although a site can have multiple Sis only the first completed SI with an S or F
lead counts toward the target
CHANGES IN DEFINITION FY89 FY90
SPECIAL PLANNING REQUIREMENTS Commitments are made based on the
sum of the EPA/FIT and State conducted Sis However, for budget and resource
allocations, separate projections must be made for EPA/FIT vs State SI
completions Separate commitments are made for sites that are being investigated
under CERCLA under the Environmental Priorities Initiative Regions propose
targets in the CERHELP non site data system Accomplishments are reported in
the site specific CERCLIS data system
ACTIVITY LSI Starts
DEFINITION Listing site inspections involve the collection and analysis of
additional site data including information pertinent to hazardous waste resources
migration pathways, and receptors The data collected are generally beyond that
required for HRS scoring and will expedite the remedial investigation/feasibility
study (RI/FS) project planning phase at NPL sites
DEFINITION OF ACCOMPLISHMENT An LSI start is credited when EPA
approves the workplan for the LSI
CHANGES IN DEFINITION FY89-FY90
SPECIAL PLANNING REQUIREMENTS Planned obligations must be
associated with those candidate sites where state conducted LSIs are expected
Regions propose targets in the CERHELP non site data system Accomplishments
are reported in the site specific CERCLIS data system
ACTIVITY Percent SI Candidates Completed
DEFINITION The number of SI candidates is determined by 1) the number of
sites in CERCLIS that have not had a PA completion and 2) based on PA
completions have not been classified as No Further Action The number of Sis
completed to date is divided into the number of candidates to determine the percent
of Sis completed to date
DEFINITION OF ACCOMPLISHMENT Same as definition
CHANGES IN DEFINITION FY89-FY9Q New Definition for FY 90
SPECIAL PLANNING REQUIREMENTS CERCLIS will automatically calculate
this percentage and place it in the CERHELP Targets and Accomplishments file
D-2
-------
OSWCR Directive 9200 3 01C
PRE REMEDIAL PROGRAM DEFINITIONS
PLANNING REQUIREMENTS
PA
SSI
LSI
% SI i
Candidates |
Completed 1
SPMS COMMITMENT9
NO
YES
NO
YES I
SCAP COMMITMENT7
YES
YES
YES
NO
TARGET OR MEASURE7
TARGET
TARGET
MEASURE
MEASURE
ANNUAL TARGETS/MEASURES SET9
YES
YES
YES
NO
QUARTERLY TARGETS/MEASURES
SET9
YES
YES
NO
NO
IF YES WHEN9
PRIOR
TO FY
PRIOR
TO FY
PLANNED SITE SPECIFICALLY9
NO
NO
YES
NO B
IF YES WHEN9
prio:i
TOFr
PLANNED ON OPERABLE UNIT
OR WHOLE SITE BASIS9
WHOLE
SITE
WHOLE
SITE
WHOLE
srn
WHOLE
SITE
REPORTED ON COMBINED PROGRAM
LEAD OR ON A PROGRAM SPECIFIC
BASIS9
N\A
N\A
N\A
N\A i
REPORTED SITE SPECIFICALLY OR IN
NON SITE PORTION OF CERCLIS9
SITE
SPECIFIC
SITE
SPECIFIC
SITE
SPECIFIC
NON SITE 1
SPECIFIC I
AOA CATEGORY9
OTHER
REMEDIAL
OTHER
REMEDIAL
OTHLR
REMEDIAL
N/A I
BASIS FOR AOA9
NON SITE
PLANS
NON SITE
PLANS
SITE SFFC
PLANS
N/A H
D 3
-------
OSWER Directive 9200 3 01C
REMEDIAL PROGRAM DEFINITIONS
INTRODUCTION
The remedial program consists of on site remedial activities beginning with the first
RI/FS and proceeding through RD/RA to eventual deletion of the site from the NPL All
remedial activities are planned site specifically with quarterly and annual targets set prior to
the beginning of the fiscal year Remedial activities at sites arc program or PRP
REMEDIAL INVESTIGATION/FEASIBILITY STUDIES (RI/FS)
Following are the SCAP and SPMS activities tracked for RI/FS
• First RI/FS Starts
• Subsequent RI/FS Starts
• Percent NPL Sites Addressed
• RI/FS to Public
• First RI/FS Completion (ROD),
• Subsequent RI/FS Completion (ROD) and
• Final RI/FS Completion (ROD)
RI/FS completions (RODs) are a SPMS and SCAP target First RI/FS Starts and
First NPL Removal Starts are a combined target under SPMS measure S/C 1 Number of
Sites where Activity has Started Separate program targets are established in SCAP
Percent NPL sites addressed is a SPMS measure and includes remedial removal,
enforcement or Federal Facility actions taken All other RI/FS activities are SCAP targets
All commitments are made on a combined Fund and PRP financed basis Separate Fund
financed and PRP goals for RI/FS starts are set prior to the FY and there is a limit on the
number of RI/FS starts during the FY The commitment for RI/FS completion is also
based on combined leads All RI/FS activities are planned on a site operable unit and
project-specific basis and entered into CERCLIS Funds for RI/FS projects are in the
RI/FS AOA
Although regions may change activity leads without affecting SCAP or SPMS
targets care should be taken when substituting a program lead RI/FS for a PRP lead
project
For the definitions below first and subsequent RI/FS starts have been combined,
as have first, subsequent and final RI/FS completion
ACTIVITY RI/FS Start -- First and Subsequent
DEFINITION The intent of an RI/FS is to present carefully scoped solutions to a
contamination problem An RI/FS start involves the development of plans for
sampling operations quality assurance health and safety, and community
relations In order for the RI/FS to be counted as a first start it must not have a
prior CERCLA settlement for an RI/FS or prior Fund obligation for RI, FS or
RI/FS Forward planning community relations and/or other support activities do
not constitute an RI/FS start
D-4
-------
OSWER Directive 9200 3 01C
DEFINITIQN OF ACCOMPLISHMENT
Fund financed (Including F and S lead events ) A Fund RI/FS start is counted
when funds are obligated Funds are obligated when 1) A contract has been
signed by the contracting officer, an Interagency Agreement has beer, signed by the
other Federal Agency or a cooperative agreement has been signed bj the Regional
Administrator or his designee to conduct an RI/FS and 2) Obligations have been
recorded in CERCLIS
If a subsequent RI/FS is initiated without a new obligation of funds, die start date is
defined as EPA approval of the workplan for the subsequent RI/FS
PRP financed (Including RP MR and PS lead events) A PRP lead RI/FS counts
when 1) An Administrative Order is signed by the last appropriate official or party
or 2) The date the Consent Decree for RI/FS is referred by the region lo DOJ or
HQ If the RI/FS is a PS lead and the site is covered by a State Enfo: cement
Cooperative Agreement a Superfund Memorandum of Agreement containing a
schedule for RI/FS work at the site or other EPA/State agreement cruiit will be
given on the day the State order is signed by the last appropriate offk lal or party
The appropriate dates for the RI/FS start and Administrative Order/Consent Decree
must be entered into CERCLIS
I f a subsequent RI/FS is initiated without a new or amended Administrative Order
Consent Decree or State enforceable order the start date is defined as EPA (or State
for PS-lead events) approval of the workplan for the subsequent RI/FS
If an amended Administrative Order or Consent Decree is prepared for a PRP or
MR-lead subsequent RI/FS, the start is defined as 1) the date the last appropriate
official or party signs the amendment to the Administrative Order or 2) the date the
amended Consent Decree is transmitted to HQ or DOJ If the subsequent RI/FS is a
PS-lead the start is defined as the date the amended state order is signed by the last
appropriate official party
EP lead An EP-lead RI/FS counts when the region begins preparation of the
workplans following the initial scoping meeting
CHANGES IN DEFINITION FY89-FY90 In order for a PS lead s ite to be
included as an accomplishment, EPA and the State must have an agnx-ment with a
schedule for RI/FS work at the site in place A new definition for subsequent
RI/FS starts was added
SPECIAL PLANNING REQUIREMENTS Commitments are made based on
combined Fund and PRP financed RI/FS starts Fund-financed and PRP lead
RI/FS start goals will be established separately prior to the FY A limit will be
placed on the number of Fund financed RP and PS lead RI/FS that can be started
during the FY Targets are established site specifically For first RI/FS starts to
be determined sites are allowed
A shift between a Fund or PRP RI/FS can occur when there has been a Fund
obligation and work has not proceeded beyond the RI/FS workplan approval
stage If a PRP takes over a RI/FS before or at this juncture, the lead at this site
should be changed from Fund to PRP If the PRP begins the RI/FS and it is
subsequently taken over by the Fund the same criteria apply
D-5
-------
OSWER Directive 9200 3 01C
First RI/FS starts and First NPL Removal Starts are a combined target under
SPMS Separate targets are established in the SCAP for RI/FS starts and Removal
starts
ACTIVITY Percent NPL Sites Addressed
DEFINITION The number of proposed or final NPL sites where a removal action
RI/FS enforcement action (Section 106 referral or unilateral order) or RCRA
correction action has taken place divided by the total number of sites on the NPL
DEFINITION OF ACCOMPLISHMENT See Definition
CHANGES IN DEFINITIONS FY89 FY90 New Definition for FY90
SPECIAL PLANNING REQUIREMENTS RI/FS starts include Fund-financed
Federal Facility State Enforcement (with or without EPA involvement) and State
financed projects CERCLIS will automatically review the site specific records,
calculate the percentage and place it in the CERHELP Targets and Accomplishments
file
ACTIVITY RI/FS to Public
DEFINITION The RI/FS is released to the public when the contamination at the
site has been characterized and alternatives for remediation have been evaluated
DEFINITION OF ACCOMPLISHMENT An RI/FS is complete the date the public
comment period on the RI/FS report begins and the proposed plan is available to the
public This date must be recorded in CERCLIS under subevent code ' CF
CHANGES IN DEFINITIONS FY89-FY9Q
SPECIAL PLANNING REQUIREMENTS Commitments are made based on
first subsequent and final RI/FS released to the public regardless of lead
ACTIVITY RI/FS Completion -- First. Subsequent, and Final
DEFINITION A RI/FS completion is defined as the signature of the Record of
Decision (ROD) A ROD is the document prepared after completion of the public
comment period on the RI/FS which identifies the Agency s selected remedy for a
site or phase of site cleanup
DEFINITION OF ACCOMPLISHMENT The date the ROD is signed by the
Regional Administrator or the Assistant Administrator for OSWER is the
completion date This date must be entered in CERCLIS
CHANGES IN DEFINITION FY89-FY90
SPECIAL PLANNING REQUIREMENTS Commitments are made based on
RODs that result from F, S SE, FE, RP or PS lead RI/FS If the ROD is for a
site with a single operable unit and no further action is required, the site is also
included under SPMS Measure S/C-6 the number of NPL sites where all
remedial/removal implementation has been completed
D-6
-------
REMEDIAL PROGRAM DEFINITIONS
Remedial Investigation/Feasibility Studies
PLANNING REQUIREMENTS
FIRST RtfFS
START
SUB RI/FS
START
RI/FS TO
FIRST RI/FS
COMPt
SUBS RI/FS
COMP.t
FIN RI/FS
COMP f
SPMS COMMITMENT?
NO
NO
NO
YES**
YES**
YES*
SCAP COMMITMENT?
YES
YES
YES
YES
YES
YES
TARGET OR MEASURE?
TARGET
TARGET
TARGET
TARGET
TARGET
TARGET
ANNUAL TARGETS/MEASURES SET?
YES
YES
YES
YES
YES
YES gf
QUARTERLY TARGETS/MEASURES
SET?
YES
YES
YES
YES
YES
YES H
IF YES WHEN?
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PRIOR m
TO FY H§
PLANNED SITE SPECIFICALLY?
YES
YES
YES
YES
YES
YES H
IF YES WHEN?
PRIOR
TO FY*"
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PRIOR §
TO FY III
PLANNED ON OPERABLE UNIT
OR WHOLE SITE BASIS?
OPERABLE
UNIT
OPERABLE
UNIT
OPERABLE
UNTT
OPERABLE
UNIT
OPERABLE
UNIT
OPERABLE
UNTT
REPORTED ON COMBINED PROGRAM
LEAD OR ON A PROGRAM SPECIFIC
BASIS?
COMBINED#
COMBINED#
COMBINED
COMBINED
COMBINED
COMBINED
REPORTED SITE SPECIFICALLY OR IN
NON SITE PORTION OF CERCLIS?
SITE
SPECIFIC
SITE
SPECIFIC
SITE-
SPECIFIC
SITE-
SPECIFIC
SITE
SPECIFIC
SITE-
SPECIFIC
nOn C/\'uGOR
RI/FS
RT/FS
N/A
N/A
N/A
N/A
i
BASIS FOR AOA?
SITE SPEC
PLANS
SITE SPEC
PLANS
N/A
N/A
N/A
N/A
I
** THESE ARE A COMBINED TARGET UNDER SPMS f SITES WHERE THE FINAL ROD ALSO CONSTITUTES THE FIRST OR
*** TO BE DETERMINED SITES ARE ALLOWED SUBSEQUENT ROD SHOULD BE TARGETED AND REPORTED AS BOTH
# GOALS ARE ESTABLISHED ON A PROGRAM SPECIFIC BASIS FIRST AND FLN'AL RODs OR BOTH SUBSEQUENT AND FINAL RODs
-------
OSWER Directive 9200 3 01C
REMEDIAL DESIGN (RD)
RD activities have planning requirements that are similar to RI/FS requirements
Four separate SCAP and SPMS activities are tracked
First RD Start
• Subsequent RD Start
• Final RD Start, and
• RD Completion
First, subsequent and final, and Fund and PRP lead RD starts are a combined
SPMS target Separate targets for first subsequent and final starts are established in SCAP
and separate Fund and PRP goals for RD starts are established poor to the FY Like the
RI/FS starts there is a limit on the number of Fund-financed RDs that can be started during
the FY RD completion is a SCAP measure Projections for RD completions are set prior
to the FY and are used for resource allocation only RD completion projections are made
on a combined first, subsequent final and all lead basis RDs are planned on a site
operable unit and project specific basis and entered into CERCLIS
Initial schedules for RD are established when the RI/FS for the site is initiated
These initial schedules must be updated in CERCLIS as better planning data become
available The funds for program lead RDs are pulled directly from CERCLIS and are
allocated in the RD Advice of Allowance
In the definitions below first subsequent and final RD starts have been combined
AcnviTY RD Starts - First. Subsequent, and Final
DEFINITION An RD is the process of developing plans and specifications for the
selected remedy Design assistance or technical assistance do not constitute an RD
start Under certain circumstances an RD may be prepared by other parties (1 e
water lines where the city already prepared plans and specifications) or the plans
developed for one site may be used at a similar site Subsequent and final RD starts
occur at NPL sites where previous RD activity has already taken place
DEFINITION OF ACCOMPLISHMENT
Fund financed (Includes F and S lead events) The date of the RD obligation is
considered the definition of accomplishment An obligation is made when the
contracting officer signs the procurement request a cooperative agreement is signed
by the Regional Administrator or his designee or an IAG is signed by the other
Federal Agency In those instances where RD activities are conducted prior to ROD
signature, or there is not a new obligation of funds for a subsequent RD, the start of
RD is defined as the approval of the workplan to conduct these activities When an
RD already exists that can be used for the site the RD start is defined the same as
the RA start
PRP financed (Includes MR RP and PS lead events) For MR and RP lead
pursuant to a Judgement Consent Decree or Unilateral Order or pre-existing
Administrative Order or Consent Decree the RD start is credited either on the date
the RD contract is awarded by the PRPs for RD or RD/RA work or the date the
Consent Decree is lodged whichever date is later The appropnate date must be
entered in CERCLIS Where the PRPs have performed an RI/FS under a state
order or comparable enforcement document and the site is covered by a State
D-8
-------
OS^ER Directive 9200 3 01C
Enforcement Cooperative Agreement or a State Memorandum of Agreement
containing a schedule for RD work at the site and EPA has approved the selected
remedy, credit will be given based on the issuance of a State Order (PS lead) for
RD (or RD/RA) or if the RD is covered by a pre existing state order the RD notice
to proceed date If PRPs are doing the work in house pursuant to ari enforcement
settlement document, the start date is the notice to proceed or the date the Consent
Decree is lodged whichever is later Mixed funding projects (MR lead) are to be
treated as PRP lead
CHANGES IN DEFINITION FY89 FY90 Accomplishment of the PRP lead RD
start is defined as either contract award or lodging of the Consent Decree
whichever is later If the PRPs are doing the work in house, the start date is either
notice to proceed or lodging of Consent Decree, whichever is later
SPECIAL PLANNING REQUIREMENTS SPMS commitments are made based
on combined Fund and PRP financed and first subsequent and final 3D starts
Separate SCAP targets are established Separate Fund and PRP financed RD start
goals will be established prior to the FY A limit will be placed on th< number of
RDs that can be started during the FY The date of the Judgement Unilateral Order
or Consent Decree referral for RD must also be recorded in CERCLIS Funds for
oversight of RP lead RDs can be planned and obligated prior to the RD start if the
PRPs have initiated work at the site
ACTIVITY RD Completions
DEFINITION An RD is complete when the plans and specifications tJid in the
case of a program lead RD, a Fund financed RA bid package for the selected
remedy are developed
DEFINITION OF ACCOMPLISHMENT
Fund financed For program lead RD projects an RD completion is thic date that
EPA concurs on or approves and accepts the plans, specifications and RA bid
package
PRP financed An RD is complete on the date that EPA concurs on 01 approves and
accepts the plans and specifications For PS-lead RDs, the RD is complete when
the state concurs on or approves and accepts the plans and specifications
For Fund and PRP financed RDs, the state should concur on the design prior to
EPA concurrence or approval
CHANGES IN DEFINITION FY89-FY90
SPECIAL PLANNING REQUIREMENTS Commitments are made based on
combined Fund and PRP financed and first, subsequent and final RD completions
D-9
-------
OSWER Directive 9200 3 01C
REMEDIAL PROGRAM DEFINITIONS
Remedial Design
PLANNING REQUIREMENTS
FIRST RD
START
SUB RD
START
FINAL RD
START
RD L
COMP. 1
SPMS COMMITMENT*
YES**
YES**
YES**
NO
SCAP COMMITMENT7
YES
YES
YES
YES
TARGET OR MEASURE7
TARGET
TARGET
TARGET
MEASURE
ANNUAL TARGETS/MEASURES SET7
YES
YES
YES
YES
QUARTERLY TARGETS/MEASURES
SET7
YES
YES
YES
YES
IF YES WHEN7
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PLANNED SITE SPECIFICALLY7
YES
YES
YES
YES
IF YES WHEN7
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PLANNED ON OPERABLE UNIT
OR WHOLE SITE BASIS7
OPERABLE
UNIT
OPERABLE
UNIT
OPERABLE
UNIT
OPERABLE
UNIT
REPORTED ON COMBINED PROGRAM
LEAD OR ON A PROGRAM SPECIFIC
BASIS7
COMBINED*
PROGRAM
LEAD
COMBINED*
PROGRAM
LEAD
COMBINED*
PROGRAM
LEAD
COMBINED
PROGRAM
LEAD
REPORTED SITE SPECIFICALLY OR IN
NON SITE PORTION OF CERCLIS7
SITE
SPECIFIC
SITE
SPECIFIC
SITE
SPECIFIC
SITE H
SPECIFIC B
AOA CATEGORY7
REMEDIAL
DESIGN
REMEDIAL
DESIGN
REMEDIAL
DESIGN
N/A
BASIS FOR AOA7
SITE SPEC
PLANS
SITE SPEC
PLANS
SITE SPEC
PLANS
N/A
* SITES WHERE THE FIRST RD START IS ALSO A FINAL RD START OR A SUBSEQUENT RD
START IS ALSO A FINAL RD START SHOULD BE REPORTED AS BOTH
** THESE ARE A COMBINED TARGET UNDER SPMS
D 10
-------
OSV/ER Directive 9200 3 01C
REMEDIAL ACTION (RA)
Following are the seven SCAP and SPMS activities tracked for RA
• First RA Start,
• Subsequent RA Start,
• Final RA start
• NPL Sites with RA Start Post SARA,
• RA Completions
• Final RA Completion and
• NPL Deletion Initiation
RAs are planned site, operable unit and project specifically and report* d in
CERCLIS Funds are allocated site specifically in the RA AOA First subsequent and
final, and Fund and PRP lead RA starts are a combined target under SPMS Separate
targets for first subsequent and final starts and Fund vs PRP starts are established in
SCAP Post-SARA RA starts RA completions and deletions are targeted on a combined
program basis RA completion except final RA completion is a SCAP measure and is
used for resource allocation purposes only Final RA completions NPL site completions
through removal actions and no action RODs are combined as a single SPMS target
Separate SCAP targets are established
Initial schedules for RA are established when the RI/FS for the site i< initiated
These initial schedules must be updated in CERCLIS as better planning data become
available
In the definitions below first subsequent and final RA starts have besn combined
as have RA and final RA completion
ACTTVITY RA Start — First. Subsequent, and Final
DEFINITION A remedial action start is the initiation of construction activities for
the selected remedy A final RA start is the initiation of construction activities for
the selected remedy at the final operable unit
DEFINITION OF ACCOMPLISHMENT
Fund financed (F or S lead events) Credit for an RA start is given on the date a
contract LAG or cooperative agreement is awarded and funds are obligated
PRP financed (RP MR or PS lead events) Credit for an RA start is given when
one of the following occurs and has been recorded in CERCLIS 1) The RD is
complete under terms of Consent Decree or pre-existing Admimstrat ve Order, The
date on which EPA approves the PRP design package determines the quarter the
RA start is counted 2) When the RD is complete under a state order or comparable
enforcement document, and the site is covered by a State Enforcemeni Cooperative
Agreement or Superfund Memorandum of Agreement with a schedule for RA work
at the site, and EPA has approved the ROD, credit will be given for eji RA start
based on the date the design package was approved by EPA 3) Wh< re the Fund
has completed the RD and PRPs are either in compliance with a Unilateral
Administrative Order (UAO) or have reached settlement for an RA oi are
performing the RA pursuant to a judgement, the date of compliance with the UAO
or the date the Consent Decree is referred to HQ or DOJ (as recorded, in CERCLIS)
D-ll
-------
OSWER Directive 9200 3 01C
will be the basis for credit Where a PRP is in significant non-compliance with the
UAO credit will be withdrawn
CHANGES IN DEFINITION FY89-FY90 Credit will be given for a PS lead site
only when there is a formal agreement for the site between EPA and the state
SPECIAL PLANNING REQUIREMENTS Under SPMS first subsequent and
final, and Fund and PRP lead RA starts are a single target Separate targets are
established in SCAP A limit will be placed on the number of Fund-financed RAs
that can be started during the FY In the case of a PRP takeover at a targeted site a
corresponding PRP target increase and Fund target decrease will occur
automatically in SCAP Quarterly targets will not be amended as a result of a
takeover
ACTIVITY RA Starts Post-SARA at NPL Sites
DEFINITION A post SARA RA start is defined as the initiation of on-site
construction activities after October 16 1986
DEFINITION OF ACCOMPLISHMENT
Fund financed Sites where the EPA State USACE or BUREC has awarded a
contract as recorded in CERCLIS - to initiate Fund financed construction
activities
PRP financed Sites as recorded in CERCLIS where the PRPs have awarded a
contract for RA work In the event that the PRPs are responding under a State
order or issued a contract for both RD and RA or are performing the work in
house , the start date is the RA notice to proceed which is equivalent to an EPA
contract award
CHANGES IN DEFINITION FY89-FY90
SPECIAL PLANNING REQUIREMENTS Commitments are made based on
combined Fund and PRP financed actions
ACTIVITY RA Completion First. Subsequent and Final
DEFINITION A first and subsequent RA is complete when construction activities
are complete a final inspection has been conducted the remedy is operating as
designed and an Operable Unit RA Report has been prepared A final RA indicates
that all construction for all operable units has been completed, the remedy is
operating as designed and a final construction inspection for the site has been
conducted For the final RA, a Superfund Site Close Out Report must be prepared
which summarizes the site condition and construction activities and demonstrates
the NCP criteria for deletion has been met If the only activity remaining is
performance monitoring or long term response an Interim Superfund Site Close-
out Report must be prepared
DEFINITION OF ACCOMPLISHMENT The date the Regional Administrator
signs an Operable Unit RA Report is the accomplishment of the RA completion a
Site Close Out Report for the final operable unit is required for the final RA
completion The date the Operable Unit RA Report or interim or final Superfund
D 12
-------
OSWER Directive 9200 3 01C
Close-Out Report is signed by the Regional Administrator is considered the date of
the final completion The appropriate dates must be recorded m CERCLIS
CHANGES IN DEFINITION FY89 FY90 The remedy must be operating as
designed in order for the RA to be complete
SPECIAL PLANNING REQUIREMENTS Projections are made on a combined
program basis First and subsequent RA completions are combined and included in
this measure for resource allocation purposes Final RA completions, no further
action RODs and NPL site completions through removal actions are a single target
under SPMS measure S/C 6 sites where all remedial/removal implementation has
been completed. Separate SCAP targets for RA completions and removal
completions are established prior to the FY
ACTIVITY NPL Deletion Initiation
DEFINITION The deletion process is initiated when performance monitoring of
the completed remedy or remedies for the site has verified the integn tv of the action
and it has been determined that no further remedial action is required at the site
DEFINITION OF ACCOMPLISHMENT The deletion process is credited when a
notice of intent to delete the site is published in the Federal Register
CHANGES IN DEFINITION FY89 FY90
SPECIAL PLANNING REQUIREMENTS
D 13
-------
u
o
m
c-J
o
REMEDIAL PROGRAM DEFINITIONS
Remedial Action
PLANNING REQUIREMENTS
FIRST RA
START*
SUB RA
START*
FINAL RA
START*
POST SARA
START
RA
COMPL *
FINAL RA
COMPL *
NPL DEL L
PROC INTT S
SPMS COMMITMENT?
YES**
YES**
YES**
NO
NO
NO
NO H
SCAP COMMITMENT?
YES
YES
YES
YES
YES
YES
YES H
TARGET OR MEASURE?
TARGET
TARGET
TARGET
TARGET
MEASURE
TARGET
TARGET H
ANNUAL TARGETS/MEASURES SET?
YES
YES
YES
YES
YES
YES
QUARTERLY TARGETS/MEASURES
SET?
YES
YES
YES
YES
YES
YES
YES H
IF YES WHEN?
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PRIOR H
TO FY 18
PLANNED SITE SPECIFICALLY?
YES
YES
YES
YES
YES
YES
YES ¦
IF YES WHEN?
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PRIOR H
TO FY lii
PLANNED ON OPERABLE UNIT
OR WHOLE SITE BASIS?
OPERABLE
UNIT
OPERABLE
UNIT
OPERABLE
UNIT
OPERABLE
UNIT
OPERABLE
UNIT
OPERABLE
UNIT
WHOLE SITE H
REPORTED ON COMBINED PROGRAM
LEAD OR ON A PROGRAM SPECIFIC
BASIS?
COMBINED#
COMBINED#
COMBINED#
COMBINED
COMBINED
COMBINED
COMBINED ¦
REPORTED SITE SPECIFICALLY OR IN
NON SITE PORTION OF CERCLIS?
SITE
SPECIFIC
SITE
SPECIFIC
SITE
SPECIFIC
SITE
SPECIFIC
SITE
SPECIFIC
SITE
SPECIFIC
SITE if
SPECIFIC ¦
AOA CATEGORY?
RA
RA
RA
N/A
N/A
N/A
N/A ||
BASIS FOR AOA?
SITE SPEC
PLANS
SITE SPEC
PLANS
SITE SPEC
PLANS
N/A
N/A
N/A
N/A H
* SITES WHERE THE FIRST RA IS ALSO THE FINAL RA OR WHERE TOE SUBSEQUENT RA
IS ALSO THE FINAL RA SHOULD BE TARGETED AND REPORTED AS BOTH
THESE ARE A COMBINED TARGET UNDER SPMS
# GOALS ARE ESTABLISHED AND REPORTED IN SCAP ON A PROGRAM SPECIFIC BASIS
-------
REMEDIAL/REMOVAL PROGRAM DEFINITIONS
PLANNING REQUIREMENTS
NPL SITES ADDRESSED
THROUGH REMOVAL OR RI/FS
NPL SITES WHERE ALL
REMEDIAL/REMOVAL
IMPLEMENTATION COMPLETED
% NIV
SITES ADDRESSED
SPMS COMMITMENT?
YES
NO
YES##
SCAP COMMITMENT?
NO
NO
YES
TARGET OR MEASURE?
TARGET
TARGET
MEASURE
ANNUAL TARGETS/MEASURES SET?
YES
YES
NO
QUARTERLY TARGETS/MEASURES
SET?
YES
YES
NO
IF YES WHEN?
PRIOR
TO FY
PRIOR
TO FY
PLANNED SITE SPECIFICALLY?
NO
NO
IF YES WHEN?
PRIOR
TO FY
PRIOR
TO FY
PLANNED ON OPERABLE UNIT
OR WHOLE SITE BASIS?
OPERABLE
UNIT
WHOLE
SITE
WHOLE
SITE
REPORTED ON COMBINED PROGRAM
LEAD OR ON A PROGRAM SPECIFIC
BASIS?
COMBINED
COMBINED
COMBINED
REPORTED SITE SPECIFICALLY OR EN
NON SITE PORTION OF CERCLIS?
SITE-
SPKTIFir
SITE
SPECIFIC
SITE
SPECIFIC
AOA CATEGORY?
N/A
N/A
N/A
BASIS FOR AOA?
N/A
N/A
N/A
*
X
C
s
<
o
NC
K3
g
c
n
## UNDER SPMS MEASURE S/C 2 THIS ACTIVITY INCLUDES
REMEDIAL REMOVAL ENFORCEMENT OR FEDERAL FACILITY
ACTIVITIES
-------
OSWER Directive 9200 3 01C
REMOVAL PROGRAM DEFINITIONS
INTRODUCTION
Requirements for the removal program differ from the remedial program due to the
nature of removal activities The removal program responds to emergency, time-cntical
and non time-cntical situations at NPL and non-NPL sites Since so much of the removal
work cannot be anticipated in advance the planning horizon of these activities is
significantly shorter than for remedial activities Thus quarterly commitments are not
required All SCAP/SPMS targets however, are established on an annual basis Targets
are planned site-specifically prior to the quarter the removal is projected to begin Site
specific removal funding needs are placed in CERCLIS the quarter pnor to the expected
obligation date The annual removal commitments are placed in the Targets and
Accomplishments portion of the CERHELP non-site data system Credit will be given for
NPL or non NPL activities depending on the NPL status recorded in CERCLIS on the date
accomplishment reports are pulled
REMOVAL ACTIVITIES
The following removal activities are tracked in SCAP and SPMS
• Removal Investigations at NPL Sites,
• NPL Removal Starts
• Non-NPL Removal Starts
• Removal Completions
• NPL Site Completions through Removal Actions, and
• Percent NPL Sites Addressed
First NPL removal starts have been combined with first RI/FS starts as a single
SPMS target Separate RI/FS and removal targets are established in SCAP NPL site
completions through removal actions have been combined with final RA completion under
SPMS Separate targets are established in SCAP Percent NPL sites addressed is a SPMS
measure which includes remedial, removal enforcement or Federal Facility activities
Non-NPL and NPL removal starts are a SCAP target Removal investigations and removal
completions are SCAP measures NPL and non NPL removal start definitions have been
combined The definition for Percent NPL sites addressed is found in the Remedial
Program Definitions
ACTIVITY Removal Investigations at NPL Sites
DEFINITION A removal investigation at an NPL site is the process of collecting
field data at an NPL site for the purpose of characterizing the magnitude and
seventy of the problem to determine if a removal action is warranted
Investigations may be conducted by the State, EPA and/or TAT, and must include
an on site component, such as a walk around survey or sampling to be counted
DEFINITION OF ACCOMPLISHMENT The start of the removal investigation at
NPL sites is defined as the date of the site visit The completion is defined as the
signature of an Action Memorandum or the date of a memo to the file documenting
the decision not to perform a removal action
D 16
-------
CSWER Directive 9200 3 01C
CHANGES IN DEFINITION FY89 FY90 New activity in FY90
SPECIAL PLANNING REQUIREMENTS This is a SCAP reporting measure
Accomplishments should be reported against a new event in the CERCLIS site
specific data base
ACTIVITY Removal Starts NPL and Non-NPL
DEFINITION A removal is a response action taken to prevent or mitigate a threat
to public health, welfare or the environment posed by the release or |>orential release
of a CERCLA hazardous substance or an imminent or substantial risk posed by a
pollutant or contaminant The site must be on the proposed or final NPL prior to or
at any time during the conduct of the removal action in order for the r< gion to
receive credit for a NPL start. In addition for the first removal starts no prior
removal activity under the direction of EPA or through an Administrative Order
Consent Decree or judgement was conducted
DEFINITION OF ACCOMPLISHMENT
Fund financed A Fund removal counts when 1) The action memo his been
approved by the OSC Regional Administrator or Assistant Administrator 2) A
contract has been signed for an EPA or USCG on-site removal 3) An obligation for
the removal has been recorded in IFMS and CERCLIS or the OSC activates $50K
and 4) On site removal work has begun The date the on site work Ix gan is the
start date for removal activity
PRP financed A PRP removal counts when there is on-site removal activity
financed by the PRP in compliance with an administrative order (uni literal or
consent) or Consent Decree or judgement The date the PRPs begin actual on site
work (as entered in CERCLIS) is the start date
CHANGES IN DEFINITION FY89-FY90 Credit is given for Fund financed
removals when on-site work begins
SPECIAL PLANNING REQUIREMENTS Commitments are madi site
specifically prior to the quarter the removal is expected to begin, to be determined
sites are allowed Annual targets for removals are established in the T argets and
Accomplishments portion of the CERHELP data base Commitments are made
based on combined Fund and PRP financed and first and subsequent removals
Separate Fund and PRP financed removal goals are established prior to the FY A
limit will be placed on the number of Fund financed removals that can be started
dunngtheFY Regions may only exceed this limit with HQ approval First NPL
removal starts and first RI/FS starts are a combined target under SPMS Separate
targets are established in SCAP for RI/FS starts and removal starts
ACnVITY Removal Completions
DEFINITION The definition for removal completion is when the conditions
specified in the Action Memorandum have been met even if the OSC determines that
additional response work may be necessary
D-17
-------
OSWER Directive 9200 3 01C
DEFINITION OF ACCOMPLISHMENT
Fund financed Completions are counted on the day the clean up contractors) has
demobilized and left the site
PRP financed Completions will count when the region has certified by entering a
date in CERCLIS that the PRPs or their contractors have completed a removal
action and fully met the terms of an Administrative Order, Consent Decree or
judgement
CHANGES IN DEFINITION FY89-FY9Q
SPECIAL PLANNING REQUIREMENTS Measures arc reported based on
combined Fund and PRP financed and first and subsequent NPL and non-NPL
removal completions Projections on the number of NPL removal completions are
placed in the Targets and Accomplishments portion of the CERHELP non site data
system
ACTIVITY NPL Site Completions through Removal Actions
DEFINITION A site is completed through a removal action when the conditions
specified in the Action Memorandum or Record of Decision have been met and no
further remedial or removal response actions are necessary
DEFINITION OF ACCOMPLISHMENT
Fund financed A site is completed through a removal action when the OSC
demobilizes the clean up contractor and conditions specified in the Action
Memorandum have been met and the appropriate date has been entered into
CERCLIS
PRP financed A site is completed through a removal action when the PRP has
completed the removal action under the terms of an Administrative Order (Unilateral
or Consent) Consent Decree or judgment and the date has been entered into
CERCLIS
CHANGES IN DEFINITION FY89-FY90 Credit is given when the action is
complete, not when the nonce of intent to delete is published
SPECIAL PLANNING REQUIREMENTS Measures are reported on combined
Fund and PRP lead NPL site completions through removal actions NPL site
completions through removal actions final RA completions and no action RODs are
a single SPMS target Separate targets are established in SCAP for removal and
remedial activities
D-18
-------
REMOVAL PROGRAM DEFINITIONS
PLANNING REQUIREMENTS
NPL
REM START
NON NPL
REM START
REM
COMP
NPL
REMOVAL
SITE COMP
NPL REMOVAL
INVESTIGATIONS
SPMS COMMITMENT?
NO
NO
NO
NO
NO
SCAP COMMITMENT?
YES
YES
YES
YES
YES
TARGET OR MEASURE?
TARGET
TARGET
MEASURE
TARGET
MEASURE
ANNUAL TARGETS/MEASURES SET?
YES
YES
YES
YES
NO
QUARTERLY TARGETS/MEASURES
SET?
NO
NO
NO
YES
NO
IF YES WHEN?
PRIOR
TO FY
PLANNED SITE SPECIFICALLY?
YES **
YES
YES
YES
NO
IF YES WHEN?
PRIOR
TO QUART
PRIOR
TO QUART
PRIOR
TO QUART
PRIOR
TO QUART
PLANNED ON OPERABLE UNIT
OR WHOLE SITE BASIS9
WHOLE
SITE
WHOLE
SITE
WHOLE
SITE
WHOLE
SITE
WHOLE ¦
SITE n
REPORTED ON COMBINED PROGRAM
LEAD OR ON A PROGRAM SPECIFIC
BASIS?
COMBINED#
COMBINED#
COMBINED
COMBINED
N/A B
REPORTED SITE SPECIFICALLY OR IN
NON SITE PORTION OF CERCLIS''
SITE
SPECIFIC
SITE
SPECIFIC
SITE
SPECIFIC
SITE
SPECIFIC
SITE H
SPECIFIC H
AOA CATGOR"?
REMOVAL
PE"QV\L
IN/A
1>/>V
RElVlO V /VL- MR
1
BASIS FOR AOA'
SITE SPEC
PLANS &
CONTINGENCY
SITE SPEC
PLANS &
CONTINGENCY
N/A
N/A
SITE SPECIFIC I
PLANS H
•• TO BE DETERMINED SITES ARE ALLOWED
# SEPARATE PROGRAM SPECIFIC GOALS ARE ESTABLISHFD PRIOR TO THE FY
A LIMIT IS PLACED ON THE NUMBER OF FUND FINANCED NPL REMOVAL STARTS
-------
OSWER Directive 9200 3 01C
ENFORCEMENT DEFINITIONS
INTRODUCTION
The planning requirements for enforcement response activities parallels those used
under the remedial and removal programs These program requirements are discussed in
the previous sections In addition, there are enforcement specific targets/measures
Funding for the enforcement targets/measures are provided through the Case Budget
Enforcement definitions have been divided into two categories PRP Searches and
Negotiations and Settlements, Referrals and Oversight
PRP SEARCHES AND NEGOTIATIONS
Following are the search and negotiation activities tracked in SCAP and SPMS
• Issuance of General Notice Letters,
• Issuance of Special Notice Letters
• Section 104(e) Letter Issued
• Start of PRP Search at Non-NPL Sites
• Start of PRP Search at NPL Sites
• Completion of PRP Search at NPL Sites
• Completion of PRP Search at Non-NPL Sites
• Start of RI/FS Negotiations
• Conclusion of RI/FS Negotiations
• Start of RD/RA Negotiations
• Conclusion of RD/RA Negotiations,
• Removal Negotiations Start and
• Removal Negotiations Complete
The definitions for start of PRP search at NPL and non NPL sites and the
completion of PRP search at NPL and non NPL sites have been combined
ACTIVITY Issuance of General Notice Letters
DEFINITION This activity refers to the issuance of a General Notice letter (GNL)
by EPA to the PRP, under CERCLA Sec 122 General Notice letters designate an
entity as a PRP These letters are preliminary determinations of potential liability
as opposed to absolute determinations of liability Therefore, there is no
requirement that EPA must possess substantial evidence of an entity s liability
before a GNL can be issued GNL recipients must be approved by both Regional
management and the Office of Regional Counsel GNLs should be sent by certified
mail return receipt requested
DEFINITION OF ACCOMPLISHMENT Credit for this activity is based on the
date the General Notice letter is sent via certified mail, return receipt requested
CHANGES IN DEFINITION FY89-FY90 New definition for FY90
SPECIAL PLANNING REQUIREMENTS This is a SCAP reporting measure
D-20
-------
OSWER Directive 9200 3 01C
ACTIVITY Issuance of Special Notice Letters
DEFINITION This activity refers to the issuance of a Special Notice (SNL) letter
by EPA to the PRP under CERCLA Sec 122 The issuance of a Special Notice
letter by EPA signals a moratorium period of Fund financed activity and the
beginning of formal negotiations It also signifies to the PRP(s) that they have 60
days to make a good faith offer
1) RI/FS - The purpose of the moratorium is to provide for a formal penod of
negotiation between EPA and PRPs where the PRPs will be encouraged to conduct
response activities The special notice procedure should be utilized whenever it
would facilitate agreement The Special Notice letter should specify the calendar
date through which the moratorium runs In instances where there i< more than one
PRP and PRPs are likely to receive the Special Notice on differen: days the date
the moratorium begins should be approximately seven days from the date the letters
are mailed to the PRPs
2) RD/RA - The primary purposes of these Special Notice procedures are to
facilitate settlements for RD/RA through direct negotiations with PRPs and to
expedite cleanups The SNL should contain the following information
• Notice of the potential liability of the PRP
• The purpose of the SNL and the conditions of the negotiations
moratorium
• Description of future response actions if known,
• Description of the elements of a good faith offer
• Statement of work to be performed
• Additional information including information on othi i PRPs fact
sheets on the site volumetric ranking of substances at the facility
and a list of the volume and nature of substances contibuted by each
PRP
• Demand for payment of past costs,
The SNL should also include a copy of EPA s proposed plan or the ROD if
signed, a draft consent decree for the RD/RA, and a draft RD/RA statement of
work To the extent possible, the SNL should contain specific information to assist
the PRPs in developing a good faith offer including information stipulating the
minimum elements of an acceptable good faith offer and what the Region will not
accept
DEFINITION OF ACCOMPLISHMENT Credit for this activity is given on the
date the special notice letter is issued to the PRP by EPA via certified mail return
receipt requested
CHANGES IN DEFINITION FY89 FY90 New definition for FY90
SPECIAL PLANNING REQUIREMENTS This is a SCAP reporting measure
D 21
-------
OSWER Directive 9200 3 01C
ACTIVITY Section 104(6") Letters Issued
DEFINITION EPA issues information request letters under the authority of
CERCLA Sec 104(e) for the purpose of gathering information related to one or
more of the following 1) The nature and extent of a release or threatened release of
hazardous substances, pollutants, or contaminants, 2) Indemnification and nature
and quantity of materials and/or 3) The financial ability of a PRP to pay for or
perform a cleanup
DEFINITION OF ACCOMPLISHMENT Credit for this activity is based on the
date the information request letter is sent The letter must be sent via certified mail
return receipt requested (the use of post office boxes should be avoided)
CHANGES IN DEFINITION FY89-FY90 New definition for FY90
SPECIAL PLANNING REQUIREMENTS This is a SCAP reporting measure
ACTIVITY Start of PRP Search
DEFINITION The purpose of the PRP search is to identify PRPs at either NPL or
non-NPL sites At NPL sites it should be initiated at the same time as the LSI or, at
the latest with the listing of the site It should be completed in time to send general
notice which should be approximately two months before the special notice date and
at least 90 days prior to the obligation of funds for a RI/FS At non NPL sites it
should be done prior to the start of the removal action when possible or very soon
after the initiation of the emergency response
DEFINITION OF ACCOMPLISHMENT If the search is being conducted by a
contractor, the start date is considered to be the date the work assignment is
procured If it is conducted by EPA the start date is the day the EPA staff begins
the PRP search activities
CHANGES IN DEFINITION FY89 FY90
SPECIAL PLANNING REQUIREMENTS Non NPL PRP searches are not
planned on a site specific basis Funds for non NPL PRP searches are requested in
the CERHELP Non Site/Incident data system PRP searches should be planned for
all sites listed on the NPL and for all removals conducted during the fiscal year
ACTIVITY Completed PRP Search
DEFINITION A PRP search is the action taken by the region to identify the
responsible parties at a NPL or non-NPL site
DEFINI TION OF ACCOMPLISHMENT The PRP search is complete when 1)
The region has gathered information required by the program guidance including
information on generators and necessary information on financial viability and has
sufficient information to mail special notice letters (names and addresses of PRPs
volume and nature of substances contributed by each PRP, volumetric ranking)
and, at NPL sites the classification of the site has been determined or 2) If no
PRPs are found, the date and the outcome of the search are entered into CERCLIS
D-22
-------
O* WER Directive 9200 3 01C
CHANGES IN DEFINITION FY89-FY90
SPECIAL PLANNING REQUIREMENTS NPL PRP searches are planned on a
site specific basis, non NPL searches should be planned site-specifically to the
maximum extent possible All targeted non NPL removal starts should have an
associated projection for a non NPL PRP search These projections should be
placed in the Targets and Accomplishments portion of the CERHELF non-site data
system Funds for non-NPL PRP searches are requested in the CERHELP data
system
ACTIVITY Start of RI/FS Negotiations
DEFINITION RI/FS negotiations are defined as discussions between EPA and the
PRPs on their liability and ability to conduct the RI/FS If a special notice is given
to the PRPs under Section 122 of SARA, the PRPs have 60 days to submit a
proposal for the RI/FS to EPA If a good faith proposal is submitted, the PRPs
have 30 days to reach agreement on a setdement document
DEFINITION OF ACCOMPLISHMENT RI/FS negotiations are suited when the
first special notice letter is issued, when a waiver of special notice letter is issued
or when the first general notice letter with expected completion dates is issued
Both the date of the letter, waiver and RI/FS negotiations have to be recorded in
CERCLIS
CHANGES IN DEFINITION FY89-FY90 Negotiations are defined as the
issuance of a letter to the PRPs instead of face-to-face meeting
SPECIAL PLANNING REQUIREMENTS If the region does not plan to perform
RI/FS negotiations at a site, negotiation dates should not be placed in CERCLIS
The start of RI/FS negotiations should be planned site-specifically
ACTIVITY Conclusion of RI/FS Negotiations
DEFINITION RJ/FS negotiations are complete when the region mal < s a decision
on how to proceed with the RI/FS activities
DEFINITION OF ACCOMPLISHMENT RI/FS negotiations are complete when
either 1) An Administrative Order for RI/FS is issued, 2) A signed consent decree
for RI/FS is referred by the region to HQ or DOJ, 3) A decision is made to proceed
with a Fund-financed RI/FS as indicated by the obligation of RI/FS funds, or 4)
When the negotiation period has concluded per a special nouce letter or the schedule
in a general notice letter
CHANGES IN DEFINITION FY89-FY90
SPECIAL PLANNING REQUIREMENTS The activity is planned >ite-
specifically in CERCLIS
D 23
-------
OSWER Directive 9200 3 01C
ACTIVITY Start of RD/RA Negotiations
DEFINI TION RD/RA negotiations are defined as discussions between EPA and
the PRPs on the conduct of the design and construction of the selected remedy If
special notice is given to the PRPs under Section 122 of SARA the PRPs have 60
days to submit a good faith proposal for RD/RA to EPA If a good faith proposal is
submitted the PRPs have another 60 days to reach agreement on a settlement
document
DEFINITION OF ACCOMPLISHMENT RD/RA negotiations are initiated when
the first special notice letter is issued when a waiver of special notice letter is
issued, or when the first general notice letter with expected completion date is
issued This date must be recorded in CERCLIS
CHANGES IN DEFINITION FY89-FY90 Negotiations are defined as the
issuance of a letter to the PRPs instead of face to-face meeting
SPECIAL PLANNING REQUIREMENTS If the region does not plan to conduct
RD/RA negotiations, dates should not be entered into CERCLIS The start of
RD/RA negotiations is planned site-specifically
ACTIVITY Conclusion of RD/RA Negotiations
DEFINITION RD/RA negotiations are complete when the region makes a decision
on how to proceed with RD/RA activities
DEFINITION OF ACCOMPLISHMENT RD/RA negotiations are complete when
1) The signed consent decree (Section 106 or 106/107 referral with settlement) for
RJD/RA and 10 point analysis is referred by the region to either DOJ or HQ 2) A
Section 106 or 106/107 referral for RD/RA without settlement is referred to DOJ or
HQ 3) A Unilateral Administrative Order for RD and/or RA which compels the
PRP to initiate site work is issued or 4) A decision is made to proceed with RD as
indicated by the obligation of RD funds
CHANGES IN DEFINITION FY89 FY90
SPECIAL PLANNING REQUIREMENTS The activity is planned site
specifically in CERCLIS
ACTIVITY Start of Removal Negotiations
DEFINITION Removal negotiations are defined as discussions between EPA and
the PRPs on the liability for and conduct of a PRP financed removal
DEFINITION OF ACCOMPLISHMENT A removal negotiation start is defined
as the date the first general notice letter is issued by EPA to the PRP
CHANGES IN DEFINITION FY89 FY90 New definition for FY90
SPECIAL PLANNING REQUIREMENTS NPL and non NPL sites should be
reported
D-24
-------
CSWER Directive 9200 3 01C
ACTIVITY Completion of Removal Negotiations
DEFINITION Removal negotiations are complete when the region makes a
decision on how to proceed with the removal
DEFINITION OF ACCOMPLISHMENT Removal negotiations are < ompleted the
date 1) An administrative order is signed 2) A consent decree is 11 ferred by the
Region to DOJ/HQ 3) Funds are obligated for the removal
CHANGES IN DEFINITION FY89 FY90 New definition for FY90
SPECIAL PLANNING REQUIREMENTS NPL and non NPL
-------
OSWER Directive 9200 3 01C
ENFORCEMENT DEFINITIONS
Searches and Negotiations
PLANNING REQUIREMENTS
PRP t
SEARCH
PRP ft
SEARCH
COMP PRP
SEARCH t
COMP PRP
SEARCH tt
SEC 104c
LETTERS
SPMS COMMITMENT''
NO
NO
NO
NO
NO
SCAP COMMITMENT7
YES
YES
YES
YES
YES
TARGET OR MEASURE''
MEASURE
MEASURE
MEASURE
MEASURE
MEASURE |
ANNUAL TARGETS/MEASURES SET'
NO
NO
NO
NO
NO
QUARTERLY TARGETS/MEASURES
SET?
NO
NO
NO
NO
NO
IF YES WHEN''
PLANNED SITE SPECIFICALLY7
YES
NO
YES
NO
NO 1
IF YES WHEN''
PRIOR
TO FY
PRIOR
TO FY
PLANNED ON OPERABLE UNIT
OR WHOLE SITE BASIS7
WHOLE
SITE
WHOLE
SITE
WHOLE
SITE
WHOLE
SITE
WHOLE
SITE
REPORTED ON COMBINED PROGRAM
LEAD OR ON A PROGRAM SPECIFIC
BASIS7
N/A
N/A
N/A
N/A
N/A
REPORTED SITE SPECIFICALLY OR IN
NON SITE PORTION OF CERCLIS7
SITE
SPECIFIC
SITE
SPECIFIC
SITE
SPECIFIC
SITE
SPECIFIC
NON SITE 1
AOA CATEGORY7
ENFORCE
MENT
ENFORCE
MENT
N/A
N/A
N/A
BASIS FOR AOA7
SITE SPEC
PLANS
NON SITE
PLANS
N/A
N/A
N/A H
t NPL SITES
tt NON NPL SITES
D-26
-------
ENFORCEMENT DEFINITIONS
PRP SEARCHES AND NEGOTIATIONS
PLANNING REQUIREMENTS
GENERAL
NOTICE
LETTERS
SPECIAL
NOTICE
LETTERS
REMOVAL
NEG
START
REMOVAL
NEG
COMPLETE
RI/FS
NEG
START
RI/FS
NEG
COMP
RD/RA
NEG
START
COhC
RD/RA
NEG
SPMS COMMITMENT9
NO
NO
NO
NO
NO
NO
NO
NO
SCAP COMMITMENT''
NO
NO
NO
NO
YES
YES
YES
YES
TARGET OR MEASURE9
MEASURE
MEASURE
MEASURE
MEASURE
MEASURE
MEASURE
TARGET
TARGET
ANNUAL TARGETS/MEASURES SET9
NO
NO
NO
NO
NO
NO
YES
YES
QUARTERLY TARGETS/MEASURES
SET9
NO
NO
NO
NO
NO
NO
YES
YES
IF YES WHEN9
PRIOR
TO FY
PRIOR
TO FY
PLANNED SITE SPECIFICALLY9
NO
NO
NO
NO
YES
YES
YES
YES
IF YES WHEN9
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PLANNED ON OPERABLE UNIT OR
WHOLE SITE BASIS9
OPERABLE
UNIT
OPERABLE
UNIT
WHOLE
SITE
WHOLE sra
OPERABLE
UNIT
OPERABLE
UNIT
OPERABLE
UNIT
OPERABLE
UNIT
REPORTED ON COMBINED PROGRAM
LEAD OR ON A PROGRAM SPECIFIC BASIS9
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
D£UQD-rcr> crrc SDECIFTC\LLV 0° IN
NON SITE °ORT'ON OF CERCLIS9
SITF
bPBCfflC
SITE
SPECIFIC
srrp
SPECIFIC
STF
SPECIFIC
SITE-
SPhUHC
SITE
SPECIFIC
SITF
SPhUFIC
SITE-
SPECIFIC |
AOA CATEGORY9
ENFORCE-
MENT
ENFORCE-
MENT
ENFORCE
MENT
ENFORCE
MENT
ENFORCE-
MENT
N/A
ENFORCE
MENT
N/A I
BASIS FOR AOA9
SITE/NON
SITE SPEC
PLANS
SITE/NON
SITE SPEC
PLANS
SITE/NON
SITE-SPEC
PLANS
SITE/NON
SITE-SPEC
PLANS
SITE SPEC
PLANS
N/A
SITE-SPEC
PLANS
N/A I
U
C
r
-------
OSWER Directive 9200 3 01C
SETTLEMENTS. REFERRALS AND OVERSIGHT
Following are the settlement referral and oversight activities tracked in SCAP and
SPMS for enforcement
• Section 104(e) Referrals/Orders
• Administrative Record Compilation Completion (Removal and Remedial)
• Compliance Enforcement
• Section 106, 106/107 Case Resolution,
• Section 107 Cost Recovery Case Resolution
• Section 107 Cost Recovery Achieved
• Section 106 RD/RA Referrals and Unilateral Orders for RD/RA
• Cost Recovery Cases Referred to DOJ or HQ (>$200K)
1) Section 107 Referral for pre RA events,
2) Section 107 Referral for RA and pre RA events,
3) Section 106/107 Referral for pre RA events
4) Section 106/107 Referrals for RA and pre RA events
• Small Case Cost Recovery Referrals and Administrative Settlements
• Administrative Orders for Removal Actions
• Demand Letters Issued and
• Cost Recovery Close Out Memorandum
ACTIVITY Section 104(e) Referrals/Order
DEFINITION Section 104(e) referrals/orders are the enforcement actions taken to
compel parties to respond to EPA requests for information
DEFINITION OF ACCOMPLISHMENT
Section 104 referrals without settlement This measure includes all Section 106
referrals without settlement to HQ or DOJ, seeking injunctive relief Credit will be
based on the referral date recorded in CERCLIS
Section 104 referrals with settlement This measure includes all Section 104
referrals with a Consent Decree to HQ or DOJ seeking judicial concurrence Credit
will be based on the referral date recorded in CERCLIS
Unilateral orders This measure includes all Section 104 unilateral administrative
orders where the party is in compliance with the order (Note that in compliance
is defined m the same manner as it is for other CERCLA orders)
CHANGES IN DEFINITION FY89 FY90 This is a new activity for FY90
SPECIAL PLANNING REQUIREMENTS Targets are established on a site
specific basis to be determined sites are allowed with an explanation
ACTIVITY Administrative Record Compilation Completion (Remedial and Removal)
DEFINITION An Administrative Record is a compilation of all documents which
EPA used to make a specific decision on the appropriate response action to be taken
at a Superfund site SARA specifies that Administrative Records be compiled at
D 28
-------
OS WER Directive 9200 3 01C
sites where remedial or removal responses are planned or are occunnj or where
EPA is issuing a unilateral order or initiating litigation
DEFINITION OF ACCOMPLISHMENT The Administrative Record compilation
is complete when the Record is placed in the repository
CHANGES IN DEFINITION FY89-FY90 New definition for FY(>0
SPECIAL PLANNING REQUIREMENTS The number of Administrative
Records compiled must be reported quarterly in the CERHELP Targets and
Accomplishments data base
ACTIVITY Compliance Enforcement
DEFINITION Compliance enforcement are the civil or judicial actions taken to
enforce a Consent Decree Judgement or Administrative Older The »< actions are in
addition to the technical oversight provided for PRP lead removal RI/FS and
RD/RA events
DEFINITION OF ACCOMPLISHMENT Credit is given when stipulated penalties
are assessed a civil judicial penalty is assessed EPA and the PRP ent( r into dispute
resolution or other enforcement action is taken to compel PRP response under a
previously entered Consent Decree, Judgement or Administrative Order
CHANGES IN DEFINITION FY89 FY90 New definition for FY<>0
SPECIAL PLANNING REQUIREMENTS Since there is no historical data for
this activity there are no special planning requirements Based on observations in
FY90 special planning requirements may be initiated in FY91 Accomplishments
are reported as milestones in the Administrative Order or Consent Decree
ACTIVITY Section 106. 106/107 Case Resolution
DEFINITION The definition of §106 106/107 case resolution are the conclusion
of a § 106 judicial action that fully addressed all claims in the complaint
DEFINITION OF ACCOMPLISHMENT Section 106, 106/107 ca,< resolution is
credited when a settlement is entered in the court fully addressing the complaint
with all parties, or the case is withdrawn or dismissed, or a trial has < oncluded and
judgment entered fully addressing the complaint The accomplishment date will be
transferred by HQ into CERCLIS from the DOJ docket system
CHANGES IN DEFINITION FY89-FY90 Section 106/107 cases a ere added
SPECIAL PLANNING REQUIREMENTS Commitments are established site
specifically
ACTIVITY Section 107 Case Resolution
DEFINITION The definition of Section 107 case resolution is the conclusion of a
Section 107 Cost Recovery judicial action that fully addresses all claims in the
complaint
D 29
-------
OSWER Directive 9200 3 01C
DEFINITION OF ACCOMPLISHMENT A Section 107 case resolution is
credited when 1) A settlement is entered in the court fully addressing the complaint
with all parties, or 2) The case is withdrawn or dismissed, or 3) A trial has
concluded and a judgement entered The accomplishment date will be transferred
from HQ into CERCLIS from the DOJ docket
CHANGES IN DEFINITION FY89 FY90 Definition has been updated to
conform with the Sec 106 case resolution definition
SPECIAL PLANNING REQUIREMENTS Commitments are established site
specifically
ACTIVITY Cost Recovery Dollars Achieved
DEFINITION This is the sum of all funds achieved through cost recovery actions
This includes 1) litigation (upon entry of ajudgement), 2) settlement (upon referral
of a Consent Decree by the region to HQ or DOJ) 3) Administrative Order (upon
execution of last signature by EPA or the PRP) 4) Administrative settlements, 5)
bankruptcy settlements (upon payment) and 6) recovery of oversight costs (upon
billing)
DEFINITION OF ACCOMPLISHMENT Credit is given for the amount shown in
CERCLIS
CHANGES IN DEFINITION FY89 FY90 New measure for FY90 inFY89
SCAP this activity was titled Sec 107 Cost Recovery Judicial Settlement
SPECIAL PLANNING REQUIREMENTS This is a reporting measure only not
a targeted activity
ACTIVITY Section 106 or 106/107 RD/RA Referrals and Unilateral Administrative
Orders for RD/RA
DEFINITION The definition of section 106 or 106/107 RD/RA Referrals and
Unilateral Administrative Orders for RD/RA are the enforcement actions taken to
compel the PRPs to assume responsibility for RD and/or RA Referrals seeking
preliminary relief, penalties or payment of strictly past costs and Unilateral Orders
for access do not count toward this target
DEFINITION OF ACCOMPLISHMENT
1) Section 106 or Section 106/107 Referrals without Settlement This measure
includes all § 106 or § 106/§ 107 referrals without settlement for RD and/or RA to
HQ or DOJ seeking injunctive relief Credit will be based on the date the Regional
Administrator signs the referral transmittal letter to OECM or DOJ as recorded in
CERCLIS Should a targeted site in this category reach a settlement (Consent
Decree) prior to referral, this target will automatically be decreased by one while
the target for category (2) below will automatically be increased by one
2) Section 106 or Section 106/107 Referrals with Settlement This measure
includes all §106 or § 106/§ 107 referrals with a Consent Decree for RD and/or RA
to HQ or DOJ, seeking judicial concurrence The referral package submitted must
D 30
-------
OSWER Directive 9200 3 01C
contain, 1) signature pages from both the Regional Administrator and the PRPs
and 2) a complete 10 point analysis to obtain credit Credit will be based on the
date the Regional Administrator signs the referral transmittal letter to OECM or DOJ
as recorded in CERCLIS Referrals seeking both performance of RD/RA by PRPs
and cash-out of PRPs with money from cash out being used for performance of
RD/RA are mcluded m this category Should a target site in this cat< gory fail to
reach settlement and the region refers the site without settlement this target will
automatically decrease by one while the target for category (1) abovi will
automatically increase by one
3) Unilateral Orders This measure mcludes all unilateral orders issued for RD/RA
Orders must compel the PRP to initiate site work Credit for issuan;s of the order
is based on the date the Regional Administrator signs the order as recorded m
CERCLIS If the PRP is in compliance with the order credit will also be provided
m Category (2) above Should a target site m this category be referred either with
or without settlement, and it is determined through consultation between HQ and
the Region that there are no viable sites for substitution the target lr this category
will be decreased by one
CHANGES IN DEFINITION FY89 FY90 All unilateral orders is< ued are credited
and credit is given based on the Regional Administrator's signature date, not the
date of compliance Also if the PRPs are in compliance credit is provided in the
order and the referrals categories Contents of the referral package: or referrals
with settlement are specified Credit is based on the number of referrals not the
number of sites addressed
SPECIAL PLANNING REQUIREMENTS Separate targets are established site-
specifically for each category to be determined sites are allowed with an
explanation Credit will be withdrawn if a case is returned by OECM or DOJ for
additional work Credit will be reinstated upon re referral and will be based on the
quarter of re referral In the event that a case is referred in one year and returned to
die region m subsequent years no credit will be provided for re-referral
ACTIVITY Cost Recovery Cases Referred to DOJ or HO (>$20010
DEFINI TION Cost recovery cases referred to HQ (>$200K) occur at sites where
the region has referred a civil action to OECM or DOJ seeking reimbursement of
past Trust Fund expenditures for removal or remedial response totaling at least
$200K under §107 of CERCLA §107 Actions (>$200K) with a § 106 Action for
RD/RA (with or without settlement) are measured Proof of claims in bankruptcy
will not count against this target Funds to be collected for future site work do not
count torward the $200K Credit is withdrawn for the referral if it is returned to the
region for additional work Credit will be given upon re referral
DEFINITION OF ACCOMPLISHMENT
1) Section 107 Pre-RA events Credit is given for a § 107 pre-RA event (target)
when a region has referred with or without settlement, a civil action to OECM or
DOJ (as reflected in the OECM docket and CERCLIS) seeking reimbursement of
past Trust Fund expenditures for a removal, IRM or ERA (without state match)
RI/FS or RD equal to or greater than $200K under § 107 of CERCLA Targets m
this category must include at a minimum all responses with expenditures greater
than or equal to $200K where there is a potential statute of limitation problem and
there are viable PRPs, unless addressed in (3) below
D 31
-------
OSWER Directive 9200 3 01C
2) Section 107 RA and other pre-RA site response Credit is given for a § 107 RA
(target) when a region has referred with or without settlement a civil action to
OECM or DOJ (as reflected in the OECM docket and CERCLIS) seeking
reimbursement for past Trust Fund expenditures for a RA IRM or ERA where a
ROD was signed and the state provided match, plus any previous fund-financed site
work (1 e removals, IRM or ERA without state match RI/FS or RDs) greater than
or equal to $200K under § 107 of CERCLA Commitments must include sites
where there is a potential statute of limitation problem, and there are viable PRPs,
unless addressed in (4) below
3) Section 106/107 pre RA events Credit is given for a § 106/§ 107 pre-RA events
when a region has referred a civil action with or without settlement to OECM or
DOJ (as reflected in the OECM docket and CERLIS) seeking reimbursement of past
Trust Fund expenditures for a removal, IRM or ERA (without state match) RI/FS
or RD greater than or equal to $200K under §106/§ 107 of CERCLA This is a
reporting measure only
4) Section 106/107 RA and other pre-RA site response Credit is given for a
§ 106/§ 107 RA and other pre RA response when a region has referred a civil action
with or without settlement to OECM or DOJ (as reflected in the OECM docket and
CERCLIS) seeking reimbursement for past Trust Fund expenditures for a RA, IRM
or ERA where a ROD was signed and state match provided plus any previous fund
financed site work (l e removals IRM or ERA without state match RI/FS or
RDs) greater than or equal to $200K under § 106/§ 107 of CERCLA This is a
reporting measure only
CHANGES IN DEFINITION FY89 FY90 The names of the categories were
changed to pre-RA events and RA and other pre-RA site response events IRMs
and ERAs were classified as RA actions or pre-RA actions based on whether state
match was provided
SPECIAL PLANNING REQUIREMENTS Targets are based on the number of
actions and must include at a minimum all responses ripe for cost recovery where
there is a potential statute of limitations (SOL) problem and there are viable PRPs
with sufficient evidence to pursue If a Region fails to resolve a SOL site (has not
settled, referred or prepared a cost recovery Close-Out Memorandum), it will be
considered to have missed the target even if it refers cases in excess of its target
ACTIVITY Small Case Cost Recovery Referrals and Administrative Settlements
DEFINITION Small Case Cost Recovery Referrals and Administrative
Settlements occur at sites where the Agency has obtained an administrative
settlement with PRPs that provides for reimbursement of Fund monies under
section 107 and section 122(h)(1) of CERCLA for past removal or remedial
expenditures or the region has referred to HQ or DOJ Section 107 cost recovery
cases without settlement with past costs less than $200,000 Cost recovery for
reimbursement of oversight or miscellaneous expenses under § 106/§ 122
settlements for response action does not count against this target
DEFINITION OF ACCOMPLISHMENT For administrative actions credit is
given when the effective date of the administrative order or other settlement
document is entered into CERCLIS If the PRPs respond to demand letters and no
settlement documents exist, the date on which funds are received by the Financial
D 32
-------
OSWER Directive 9200 3 01C
Management Division determines the quarter in which the settlement is counted
There are no dollar limits for credit on administrative settlements Credit for small
case cost recovery referrals will be given based on the date the Regional
Administrator signs the transmittal letter for the referral package as recorded in
CERCLIS The dollar amount sought or settled for should be past i osts less than
$200,000 in order for the case to be counted in this activity Prospective costs do
not count in this measure
CHANGES IN DEFINITION FY89 FY90
SPECIAL PLANNING REQUIREMENTS Credit is based on the Administrative
Order or referral package per se not on the number of sites Region^ are
constrained to a maximum of one small case referral Targets are established non
site specifically
ACTIVITY Administrative Order for Removal Actions
DEFINITION Issuance of an Administrative Order (unilateral or consent) that
compels the PRPs to assume responsibility for removal actions Credit is given for
each order issued at the site Excluded from this measure are orders for RI/FS
RD and access
DEFINITION OF ACCOMPLISHMENT A § 106 administrative order for removal
action is counted when the order (unilateral or consent) has been signed and issued
by EPA and entered in CERCLIS
CHANGES IN DEFINITION FY89 FY90
SPECIAL PLANNING REQUIREMENTS Projections for Administrative Orders
for removal actions are made in the Targets and Accomplishments portion of the
CERHELP non-site data base This is a SPMS reporting measure for NPL and
non-NPL sites
D 33
-------
OSWER Directive 9200 3 01C
ENFORCEMENT DEFINITIONS
Settlements, Referrals and Oversight
PLANNING REQUIREMENTS ADMIN RECORD COMPLIANCE «
fLANNlNl! KkyuiKkMfclX IS COMPILATION ENFORCEMENT |
SPMS COMMITMENT9
NO
N0 R
SCAP COMMITMENT9
YES
YES I
TARGET OR MEASURE9
MEASURE
MEASURE 1
ANNUAL TARGETS/MEASURES SET9
NO
NO I
QUARTERLY TARGETS/MEASURES
SET9
NO
NO 1
IF YES WHEN9
I
PLANNED SITE SPECIFICALLY9
NO
NO I
IF YES WHEN9
I
PLANNED ON OPERABLE UNIT
OR WHOLE SITE BASIS9
OPERABLE
UNIT
OPERABLE I
UNIT H
REPORTED ON COMBINED PROGRAM
LEAD OR ON A PROGRAM SPECIFIC
BASIS9
COMBINED
N/A B
REPORTED SITE SPECIFICALLY OR
IN NON SITE PORTION OF CERCLIS9
NON SITE
SITE SPECIFIC I
AOA CATEGORY9
ENFORCEMENT
OR OTHER
REMEDIAL
ENFORCEMENT 1
BASIS FOR AOA9
SITE OR NON
SITE SPECIFIC
PLANS
SITE SPECIFIC H
PLANS ¦
D 34
-------
QSWER Directive 9200 3 01C
ENFORCEMENT DEFINITIONS
Settlements, Referrals and Ovei sight
PLANNING REQUIREMENTS
1
2
3
4
5 |
SPMS COMMITMENT9
NO
NO
NO
YES
YES j
SCAP COMMITMENT9
YES
YES
YES
YCS
NO 1
TARGET OR MEASURE9
TARGET
TARGET
TARGET
MLASURE
MEASURE 1
ANNUAL TARGETS/MEASURES SET9
YES
YES
YES
YES
NO I
QUARTERLY TARGETS/MEASURES
SET9
YES
YES
YES
NO
NO H
IF YES WHEN9
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PLANNED SITE SPECIFICALLY9
YES
YES
NO
NO
NO H
IF YES WHEN9
PRIOR
TO FY*
PRIOR
TO FY*
PLANNED ON OPERABLE UNIT
OR WHOLE SITE BASIS9
OPERABLE
UNIT
WHOLE
SITE
WHOLE
SITE
WHOLE
ilTE
WHOLE
SITE
REPORTED ON COMBINED PROGRAM
LEAD OR ON A PROGRAM SPECIFIC
BASIS9
N/A
N/A
N/A
N/A
N/A
REPORTED SITE SPECIFICALLY OR IN
NON SITE PORTION OF CERCLIS9
SITE
SPECIFIC
SITE
SPECIFIC
SITE
SPECIFIC
SITE
SPECIFIC
SITE
SPECIFIC
AOA CATEGORY9
ENFORCE
MENT
ENFORCE
MENT
ENFORCE
MENT
N/A
N/A
BASIS FOR AOA9
SITE SPEC
PLANS
SITE SPEC
PLANS
SITE SPEC
PLANS
N/A
N/A I
~ TBD SITES ARE ALLOWED
1 S 106 CASE RESOLUTION 4 ADMIN ORDER FOR REMOVAL ACTIONS
2 S 107 CASE RESOLUTION 5 COST RECOVERY ACHIEVED
3 SMALL CASE COST RECOVERY AND
ADMINISTRATIVE SETTLEMENTS
D 35
-------
OSWER Directive 9200 3 01C
ENFORCEMENT DEFINITIONS
Settlements, Referrals and Oversight (Cont)
PLANNING REQUIREMENTS
SECTION 107 REFERRAL
SECTION 106/107 REFERRAL
SECTION 106 L
PRERA
RA & PRE RA
PRERA
*A& PRERA
RD/RA REF/UAC
SPMS COMMITMENT9
YES
YES
YES
YES
YES
SCAP COMMITMENT9
YES
YES
YES
YES
YES
TARGET OR MEASURE9
TARGET
TARGET
MEASURE
MEASURE
TARGET
ANNUAL TARGETS/MEASURES SET9
YES
YES
YES
YES
YES
QUARTERLY TARGETS/MEASURES
SET9
YES
YES
YES
YES
YES
IF YES WHEN9
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PLANNED SITE SPECIFICALLY9
YES
YES
YES
YES
YES
IF YES WHEN9
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PLANNED ON OPERABLE UNIT
OR WHOLE SITE BASIS9
OPERABLE
UNIT
OPERABLE
UNIT
OPERABLE
UNIT
OPERABLE
UNIT
OPERABLE
UNIT
REPORTED ON COMBINED PROGRAM
LEAD OR ON A PROGRAM SPECIFIC
BASIS9
N/A
N/A
N/A
N/A
N/A
REPORTED SITE SPECIFICALLY OR IN
NON SITE PORTION OF CERCLIS9
SITE
SPECIFIC
SITE
SPECIFIC
SITE
SPECIFIC
SITE
SPECIFIC
SITE
SPECIFIC
AOA CATEGORY9
ENFORCE
MENT
ENFORCE
MEM-
ENFORCE
MENT
ENFORCE
MENT
ENFORCE
MENT
BASIS FOR AOA9
SITE-SPEC
PLANS
SITE SPEC
PLANS
SITE SPEC
PLANS
SITE SPEC
PLANS
SITE SPEC
PLANS
D 36
-------
()a«VER Directive 9200 3 01C
FEDERAL FACILITY DEFINITIONS
INTRODUCTION
Definitions for Federal Facility activities are generally the same as those used for
PRP financed actions The Federal Facility activity definitions have been divided into two
categories Remedial and Enforcement The SPMS measure NPL sites addressed
includes remedial, removal enforcement and Federal Facilities activities The definition
can be found in the Remedial Program Definitions section
REMEDIAL
The following Federal Facility remedial activities are tracked through SPMS and
SCAP The definitions encompasses first, subsequent and final activities
ACTIVITY Federal Facility RI/FS Starts
DEFINITION An RI/FS is the development of a carefully scoped solution or part
of a solution to a contamination problem Federal facility RI/FS are conducted by
the Federal entity The Federal agency is required to start an RI/FS within six
months of site listing on the NPL
DEFINITION OF ACCOMPLISHMENT The start date is either 1) A signed
FFA/LAG or 2) Publication of timetables and deadlines in consultation with the state
for expeditious completion of the RI/FS Subsequent RI/FS start is defined as the
receipt of the RI/FS workplan within the context of the FFA/IAG
CHANGES IN DEFINITION FY89 FY9Q Subsequent RI/FS start definition was
added
SPECIAL PLANNING REQUIREMENTS First and subsequent F17FS starts are
a combined SCAP target
ACTIVITY Federal Facility RI/FS Completion (ROD)
DEFINITION The ROD is the document which details the selection of remedy
The Federal entity and EPA joindy select the remedy at the facility
DEFINITION OF ACCOMPLISHMENT The date the initial subsequent, or final
ROD is signed by the Regional Administrator or the Assistant Administrator for
OSWER is the completion date This date must be entered in CERCLIS
CHANGES IN DEFINITION FY89-FY9Q
SPECIAL PLANNING REQUIREMENTS First, subsequent and final RODs are
combined SPMS and SCAP targets
ACTIVITY RD Starts
DEFINITION An RD is the process of developing plans and specifications for the
selected remedy The Federal agency and/or its contractor performs the RD
D 37
-------
OSWER Directive 9200 3 01C
DEFINITION OF ACCOMPLISHMENT The RD start is defined as the date the
RD workplan is received by EPA, as recorded in CERCLIS within the context of
the LAG
CHANGES IN DEFINITION FY89 FY90 The definition is the date of the receipt
of the workplan instead of award of RD contract
SPECIAL PLANNING REQUIREMENTS First, subsequent and final
RDs are a combined SCAP target
ACTIVITY RA Starts
DEFINITION An RA represents construction activities to address a release or
potential release of a hazardous substance at a site The Federal agency or its
contractor performs the RA at the Federal Facility
DEFINI TION OF ACCOMPLISHMENT An RA start is defined as the date as
recorded in CERCLIS that EPA receives the RA workplan within the context of an
IAG
CHANGES IN DEFINITION FY89 FY90 The definition is the receipt of the
workplan instead of the approval of the workplan
SPECIAL PLANNING REQUIREMENTS Separate projections are made for
first subsequent and final RA starts
ACTIVITY RA Starts Post-SARA at NPL Sites
DEFINITION A Post SARA RA start is defined as the initiation of on-site
construction activities after October 16, 1986
DEFINITION OF ACCOMPLISHMENT Credit is given when substantial and
continuous on-site work has begun at sites where EPA has concurred on the ROD
and an IAG/FFA is in place The date substantial and continuous on site work
begins must be recorded and documented in CERCLIS
CHANGES IN DEFINITION FY89-FY90
SPECIAL PLANNING REQUIREMENTS
D 38
-------
OSWER Directive 9200 3 01C
ENFORCEMENT
ACTIVITY Signed Federal Facility Agreement/Interagencv Agreements at NPL Sites
DEFINITION Under § 120 of SARA, Federal Agencies are requirec to enter into a
Federal Facility Agreemenl/Interagency Agreement with EPA within six months of
EPA review of RI/FS regarding 1) A schedule for completion of the remedy and
2) Arrangements for Operations and Management (O&M) at the facility OSWER
policy is to enter into an LAG for the RI/FS and RD/RA phases
DEFINITION OF ACCOMPLISHMENT Credit is given for any of the following
1) A signed § 120 FFA/IAG for an RI/FS/RD/RA or RD/RA only 2) Issuance of a
§3008(h) Corrective Action Order that addresses all releases 3) Referral of a
Section 106 Administrative Order to the Department of Justice for concurrence 4)
Issuance of a RCRA permit addressing all releases and all CERCLA -equirements
or 5) A formal referral has been made to the AA SWER for dispute r< solution A
site can only receive credit once under this measure
CHANGES IN DEFINITION FY89 FY90
SPECIAL PI ANNING REQUIREMENTS Issuance of a Section 3008(h) Order
issuance of a RCRA permit and formal referral to OSWER are not currently tracked
in CERCLIS
D 39
-------
o
CO
§
£ FEDERAL FACILITY DEFINITIONS
>
PLANNING REQUIREMENTS
SIGNED FFA/IAGS
AT NPL SITES
FF RI/FS
COMP
RA START
POST-SARA
RI/FS
START
RD
START
RA
START
SPMS COMMITMENT?
YES
YES
NO
NO
NO
NO
SCAP COMMITMENT?
YES
YES
YES
YES
YES
YES
TARGET OR MEASURE?
TARGET
TARGET
MEASURE
TARGET
TARGET
TARGET
ANNUAL TARGETS/MEASURES SET?
YES
YES
YES
YES
YES
YES
QUARTERLY TARGETS/MEASURES
SET?
YES
YES
YES
YES
YES
YES
IF YES WHEN?
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PLANNED SITE SPECIFICALLY?
YES
YES
YES
YES
YES
YES
IF YES WHEN?
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PRIOR
TO FY
PLANNED ON OPERABLE UNIT
OR WHOLE SITE BASIS?
WHOLE
SITE
OPERABLE
UNIT
OPERABLE
UNIT
OPERABLE
UNIT
OPERABLE
UNIT
OPERABLE
UNIT
REPORTED ON COMBINED PROGRAM
LEAD OR ON A PROGRAM SPECIFIC
HASTS7
N/A
N/A
N/A
N/A
N/A
N/A
REPORTED SITE SPECIFICALLY OR IN
NON SITE PORTION OF CERCLIS?
SITE
SPECIFIC
SITE
SPECIFIC
SITE
SPECIFIC
SITE
SPECIFIC
SITE
SPECIFIC
SITE
SPECIFIC
AOA CATEGORY?
N/A
N/A
N/A
N/A
N/A
N/A
BASIS FOR AOA?
N/A
N/A
N/A
N/A
N/A
N/A
-------
OS At ER Directive 9200 3 01C
OIL lSPUJ, ACTIVITY DEFINITIONS
INTRODUCTION
There are three oil spill activities that are planned and tracked through the SCAP
process They are planned on a non site specific basis and do not require regions to plan
obligations Accomplishments are reported in CERHELP in the aggregate not at the site
level These activities are the following
• Oil Spills Cleaned up Using Clean Water Act (CWA) Funds
• On-Scene Monitoring of Responses to Oil Spills, and
• Spill Prevention Control and Countermeasure (SPCC)
Inspections/Reviews
ACTIVITY Oil Spills Cleaned up Using Clean Water Act (CWA) Funds
DEFINITION CWA funded oil spill clean ups are oil spills cleaned up by EPA
using §31 l(k) funds A single incident should be counted only once r< gardless of
how many times an EPA On Scene Coordinator (OSC) or Technical A >sistance
Team (TAT) goes back on scene or how many phases the response emails
DEFINITION OF ACCOMPLISHMENT Completion of the clean up activities is
defined as oil spills cleaned up by EPA using CWA funds
CHANGES IN DEFINITION FY89-FY90
SPECIAL PLANNING REQUIREMENTS
ACTIVITY On-Scene Monitoring of Responses to Oil Spills
DEFINITION On scene monitoring occurs when the PRP State local authorities
or other party responds and §311 (k) funds are not invoked but where EPA or a
TAT provides on scene oversight or technical assistance to ensure adequate cleanup
takes place
DEFINITION OF ACCOMPLISHMENT Activation of EPA or TAT personnel in
response to activities conducted by other entities to clean up oil spills
CHANGES IN DEFINITION FY89-FY90
SPECIAL PLANNING REQUIREMENTS
ACTIVITY Spill Prevention Control and Countermeasure (SPCC) Inspections/Reviews
DEFINITION Spill prevention compliance reviews performed by EPA and/or a
TAT defines the SPCC inspections/reviews The count should include both on-site
inspections and detailed plan reviews Follow-up inspections at a single facility
may be counted separately
DEFINITION OF ACCOMPLISHMENT Completion of the review
CHANGES IN DEFINITION FY89 FY90
SPECIAL PLANNING REQUIREMENTS
D 41
-------
OSWER Directive 9200 3 01C
OIL SPILL ACTIVITY DEFINITIONS
PLANNING REQUIREMENTS
CWA FUNDED
OIL SPILLS*
OSM
OIL SPILLS
SPCC
I/R
SPMS COMMITMENT9
NO
NO
NO
SCAP COMMITMENT9
YES
YES
YES
TARGET OR MEASURE9
MEASURE
MEASURE
MEASURE
ANNUAL TARGETS/MEASURES SET9
YES
YES
YES
QUARTERLY TARGETS/MEASURES9
NO
NO
NO
IF YES WHEN9
PLANNED SITE SPECIFICALLY9
NO
NO
NO
IF YES WHEN9
PLANNED ON OPERABLE UNIT
OR WHOLE SITE BASIS9
N/A
N/A
N/A
REPORTED ON COMBINED PROGRAM
LEAD OR ON A PROGRAM SPECIFIC
BASIS9
N/A
N/A
N/A
REPORTED SITE SPECIFICALLY OR
IN NON SITE PORTION OF CERCLIS9
NON SITE
NON SITE
NON SITE
AOA CATEGORY9
N/A
N/A
N/A
BASIS FOR AOA9
N/A
N/A
N/A
~ CLEANED UP BY EPA
D-42
-------
O'WER Directive 9200 3 01C
SECTION 2
MISCELLANEOUS DEFINITIONS
-------
OSWCR Directive 9200 3 01C
REMEDIAL PROGRAM DEFINITIONS
PROJECT SUPPORT
ACTIVITY Community Relations
DEFINITION Community relations are the activities conducted in a< < ordance with
SARA the NCP and the Community Relations Handbook to involve the
community in response activities conducted at a site
DEFINITION OF ACCOMPLISHMENT The start of community rt lations is the
obligation of funds for the development of the community relations plan For PRP-
lead sites where the PRP is preparing the community relations plan in accordance
with an Administrative Order or consent decree the start of community relations is
defined as EPA approval of the community relations plan The completion of
community relations is the deletion of the site from the NPL or the conclusion of a
removal action
CHANGES IN DEFINITION FY89 FY90
SPECIAL PLANNING REQUIREMENTS Community relations ac tivities at PRP
sites are paid for by the Case Budget Planned and actual start and completion dates
are not required in CERCLIS Funds may be planned site or non site specifically
however they must be obligated site specifically Once funds are obligated the
non-site specific amount must be reduced
ACTIVITY Design Assistance
DEFINITION Design assistance activities are undertaken by US ACE in
preparation for initiating remedial design activities This includes 1) Synopsize
remedial design requirements in the Commerce Business Daily (CBD) 2) Develop
architect/engineer (A/E) firm pre selection list 3) Contact A/E firms c
-------
OSWER Directive 9200 3 01C
additional data needs and 3) The identification of administrative or procedural
problems that may affect project implementation
DEFINITION OF ACCOMPLISHMENT The start of forward planning is the
obligation of funds for forward planning The completion of forward planning is
the start of the RI/FS
CHANGES IN DEFINITION FY89 FY90
SPECIAL PLANNING REQUIREMENTS Planned and actual start and
completion dates are not required in CERCLIS Funds may be planned site or non-
site specifically, however, they must be obligated site-specifically Once funds are
obligated the non site specific amount must be reduced
ACnVITY Long Term Response (LTR)
DEFINITION A Long Term Response is an action which requires a continuous
period of on site activity before cleanup levels specified in the ROD or an Action
Memorandum are achieved These activities typically include pump and treat or
monitoring actions
DEFINITION OF ACCOMPLISHMENT LTR begins when the treatment or
monitoring is initiated and is operational and functional (typically when the interim
close out report is accepted) The completion date is defined as the point where the
levels specified in the ROD or Action Memorandum are achieved and no further
Superfund response is required to protect human health or the environment For
Fund financed remedial actions involving treatment or other measures to restore
contaminated ground or surface water quality the operation of such treatment or
measures for a period up to 10 years after the construction or installation and
commencement of operation will be considered part of Remedial Action Activities
required to maintain the effectiveness of such treatment or measures following the
10 year period or after remedial action is complete, whichever is earlier shall be
considered OPM The following shall not be considered treatment or other
measures to restore contaminated ground or surface water a) source control
measures initiated to prevent contamination of ground or surface water and b)
ground or surface water measures initiated for the primary purpose of providing
drinking water not for the purpose of restoring ground or surface water
CHANGES IN DEFINITION FY89-FY90
SPECIAL PLANNING REQUIREMENTS LTR is planned on a site-specific
basis in CERCLIS and is used for resource allocation purposes only
ACTIVITY Management Assistance
DEFINITION Management assistance is a site specific activities performed by the
state - monitoring progress and consulting with EPA on Federal-lead and PRP-lead
remedial activities
D 44
-------
0>*'ER Directive 9200 3 01C
DEFINITION OF ACCOMPLISHMENT The start of management assistance is
the signature of the Cooperative Agreement by the Regional Adminutrator or his
designee which awards funds to the State The completion of management
assistance is the completion of all remedial activities at the site
CHANGES IN DEFINITION FY89-FY90
SPECIAL PLANNING REQUIREMENTS Management assistant activities at
PRP and PS lead sites are paid for by the Enforcement Program and are contained
in the Case Budget Planned and actual start and completion dates zre not required
in CERCLIS Funds may be planned site or non site specifically however, they
must be obligated site-specifically Once funds are obligated the non-site specific
amount must be reduced
ACTIVITY Operation and Maintenance (O&MI
DEFINITION There are two phases of O&M The first is that phase of the
remedial action that ensures that a remedy is operational and functional EPA
financially supports this phase of a Fund financed action for a period up to one
year The one year period does not apply to sites where Long Term Response
actions are being conducted The second phase of O&M includes tho activities
required to maintain the effectiveness or the integrity of the remedy The State or
PRP is totally responsible for these activities for the time penod spec lfied in the
ROD
DEFINITION OF ACCOMPLISHMENT The start of O&M is defined as the date
construction activities are complete, the contractor demobilizes and the lead entity
has ensured the remedy is operational and functional The completion of O&M is
defined as the date specified in the Cooperative Agreement, Superfund State
Contract or Consent Decree
CHANGES IN DEFINITION FY89-FY90 Analyses to ensure the remedy is
operational and functional are part of the RA and not O&M The date of O&M
completion has been revised
SPECIAL PLANNING REQUIREMENTS Operation and maintenance is planned
site specifically in CERCLIS and is used for resource allocation puiposes only
ACTIVITY Technical Assistance
DEFINITION Technical Assistance is support provided by a third party to EPA in
the conduct of remedial activities
DEFINITION OF ACCOMPLISHMENT The start of technical as< istance is the
obligation of funds for technical assistance The completion is defined as the
completion of the remedial activities for which technical assistance was requested
CHANGES IN DEFINITION FY89-FY90
D-45
-------
OSWER Directive 9200 3 01C
SPECIAL PLANNING REQUIREMENTS Planned and actual start and
completion dates are not required in CERCLIS Funds may be planned site or non
site specifically however they must be obligated site specifically Once funds are
obligated the non site specific amount must be reduced
ACTIVITY Technical Assistance Grants
DEFINI TION Technical Assistance Grants are funds awarded to community
groups to hire technical advisors to review and interpret Superfund documents A
maximum of $50K can be awarded per site
DEFINITION OF ACCOMPLISHMENT The start of the Technical Assistance
Grant is the signature of the Cooperative Agreement to the community group The
completion of the Technical Assistance Grant is the completion of the final RA
CHANGES IN DEFINITION FY89 FY9Q
SPECIAL PLANNING REQUIREMENTS Planned and actual start and
completion dates are not required in CERCLIS Funds may be planned site or non
site specifically however they must be obligated site specifically Once funds are
obligated the non site specific amount must be reduced Funds for Technical
Assistance Grants are contained in the response budget
ACTIVITY Treatability Study
DEFINITION Treatability studies are the field efforts to support the evaluation of
alternatives to determine their applicability for the site
DEFINITION OF ACCOMPLISHMENT The start of the treatability study is the
obligation of funds specifically for the study If unexpended RI/FS or RD funds
are used for the treatability study the start date is the date of EPA approval, as
reflected in CERCLIS of the treatability study workplan The completion is the
approval of the report on the results of the treatability study
CHANGES IN DEFINITION FY89-FY90 New definition for FY90
SPECIAL PLANNING REQUIREMENTS Planned start and completion dates are
required in CERCLIS Actual start and completion dates must be reported Funds
are planned site specifically
REMOVAL DEFINITIONS
NPL SITES
ACTIVITY Expedited Response Action (ERA)
DEFINITION ERAs are actions that are conducted at NPL sites under the
expanded NOP and SARA removal authorities where the alternatives are clear and a
non time critical situation exists ERAs include site surface remediation, for
example, removal of contaminated soils, drums, or tanks
D-46
-------
0>WER Directive 9200 3 01C
DEFINITION OF ACCOMPLISHMENT An ERA is complete wh< n 1) the
conditions specified in the Action Memorandum are complete, even if the
OSC/RPM determines that additional response work may be necessaiy, and 2) the
OSC/RPM demobilizes the cleanup contractor
CHANGES IN DEFINITION FY89 FY90.
SPECIAL PLANNING REQUIREMENTS
HAZARDOUS SUBSTANCES RELEASE
ACTIVITY Hazardous Substances Release Notification
DEFINI TION The definition of hazardous substances release notification is a
report to EPA of a hazardous substance released into the environment
DEFINITION OF ACCOMPLISHMENT The definition for release notifications is
the number of sites/incidents where a release notification is received A release
notification is counted when a report of a hazardous substances relecise is received
processed and logged by EPA
CHANGES IN DEFINITION FY89-FY90
SPECIAL PLANNING REQUIREMENTS The count for hazardous substances
release notifications should not include state or USCG notifications forwarded ex-
post facto through monthly summaries unless followed up by EPA Count should
include potential releases, notifications not recognized through CERCLA and spills
at waste sites if reported to EPA Accomplishments should be reported in
CERHELP
ACTIVITY Hazardous Substances Release Investigations
DEFINITION A release investigation is the process of collecting fi< Id data on an
actual or potential hazardous substance site or spill for the purpose of characterizing
the magnitude and seventy of the hazard and/or to support enforcement This
activity includes all efforts from the decision to conduct an investigation up to the
decision to prepare an action memorandum for removal action
DEFINITION OF ACCOMPLISHMENT Investigations may be conducted by
EPA and/or a TAT, and must include an on-site component, such as a walk around
survey or sampling to be counted
CHANGES IN DEFINITION FY89 FY90
SPECIAL PLANNING REQUIREMENTS Investigations conducted entirely by
the state do not count Accomplishments should be reported in CEFHELP
D 47
-------
OSWER Directive 9200 3 01C
ACTIVITY On Scene Monitoring of Responses to Hazardous Substance Releases
DEFINITION On-scene monitoring of responses to hazardous substance release
occurs when CERCLA funds are not obligated for cleanup work, but EPA provides
on-scene oversight and technical assistance to ensure that all CERCLA
statutes/regulations are adhered to in site cleanup or stabilization
DEFINITION OF ACCOMPLISHMENT Credit is given for on-scene monitoring
when EPA goes on site to monitor cleanup activities
CHANGES IN DEFINITION FY89-FY90
SPECIAL PLANNING REQUIREMENTS State removals conducted through
cooperative agreement do not count toward this activity Accomplishments should
be reported in CERHELP
FEDERAL FACILITY DEFINITIONS
PRE-REMEDIAL
ACTIVITY PA Completions
DEFINITION A Preliminary Assessment is the first stage of site assessment
Geological and hydrological data and data concerning site practices are reviewed to
complete the PA report Federal agencies are required to conduct PAs at their
facilities
DEFINITION OF ACCOMPLISHMENT A PA is complete when the PA report is
reviewed and the PA completion date is entered into CERCLIS
CHANGES IN DEFINITION FY89-FY90
SPECIAL PLANNING REQUIREMENTS
ACTIVITY SI Completions
DEFINITION The site inspection involves collecting field data for the purpose of
characterizing the magnitude and seventy of the hazards posed by the facility An
SI should provide adequate data for EPA (using FIT resources) to determine the
site s Hazard Ranking System (HRS) score Federal agencies are required to
conduct Sis at their facilities
DEFINITION OF ACCOMPLISHMENT An SI is complete when EPA reviews
the SI report a draft HRS score has been derived, and the completion date is
entered into CERCLIS
CHANGES IN DEFINITION FY89-FY90
SPECIAL PLANNING REQUIREMENTS A projection must be made in
CERHELP of the FIT resources needed for HRS development
D 48
-------
APPENDIX E
SELECT LOGIC FOR SCAP REPORTS
OSWI R Directive 9200 3 01C
-------
APPENDIX E
SELECT LOGIC FOR SCAP REPORTS
TABLE OF CONTENTS
SCAP-4 FINANCIAL REPORT
SELECT LOGIC FOR FISCAL YEAR 1990
SCAP 14 TARGET AND ACCOMPLISHMENTS REPORT
SELECT LOGIC FOR FISCAL YEAR 1990
SCAP-16 TARGET AND NEGOTIATIONS REPORT
SELECT LOGIC FOR FISCAL YEAR 1990
-------
SCAP-4
SCAP FINANCIAL
REPORT SELECT LOGIC
FOR FISCAL YEAR 1990
JUNE 19, 1989
CURRENT AS OF
6/19/89
-------
OSWER Directive 9200 3 01C
Specifications for the FY 90
SCAP - 4 SCAP FINANCIAL REPORT
Introduction
The SCAP-4 report combines the SCAP-3 FUND FINANCED REMEDIAL
PROJECTS and SCAP-15 FINANCIAL SUMMARY reports The SCAP-4 leport
contains two levels of detail The first is a replica of the SCAP 15 The second contains a
simihar version of the SCAP-3 with the exception that the records displayed «ue listed by
financial transaction instead of being rolled up into the event level It is assumed that the
financial transaction display will enable the regions to better manage their budgets and
improve data quality
The event level rollup is currently being programmed so that when the report is
completed the user will have access to three levels of detail 1 Summary Information
(SCAP-15) 2 Event Funding Level (SCAP 3) 3 Financial Transaction Detail (New)
Currently the SCAP 4 is only programmed to calculate planned obligations foi FY90 due to
outstanding issues related to the IFMS transfer The SCAP 3 and SCAP 15 reports are
still to be used for FY89 reporting but will not run for FY90
Select Lopic
The select logic conatined here only pertains to PLANNED OBLIGA HONS for
FY90 It is broken by the PROGRAM ACTIVITY CATEGORIES displayec on the
SCAP-15 and the first section of the SCAP 4
E-l
-------
OSWER Directive 9200 3 01C
SELECT LOGIC FOR SCAP - 4 FINANCIAL REPORT
PROGRAM ACTIVITY
CATEGORY
SELECT LOGIC FOR
CURRENT YEAR
PLANNED OBLIGATIONS
CERHELP
SELECT LOGIC FOR
CURRENT YEAR
PLANNED OBLIGATIONS
CERCLIS
SUM C1420 WHERE
SUM C1230 WHERE
PA/SI
(C413 EQ PA or SI) AND
CI404 EQ P AND
C1415 GE 90/Selected
Qtr AND
C1415 LT 911 AND
C1419 EQ APR AND
C1416 EQ R
LSI
C2111 EQ ES AND
(C2117 EQ F or S or
SE or FE) AND
C3202 EQ P AND
C3218 GE 90/Selected
Qtr AND
C3218 LT 911 AND
C3225 EQ APR AND
C3229 EQ R'
RI/FS
C413 EQ FP AND
CI404 EQ P AND
C1415 GE 90/Selected
Qtr' AND
C1415LE 911 AND
C1419EQ APR AND
C1416 EQ R'
(C2111 EQ RI or FS or
CO or FP) AND
(C2117 EQ F or S or
'SE or FE or EP) AND
C3202 EQ P AND
C3218 GE 90/Selected
Qtr AND
C3218 LT 911 AND
[C3218NOTLT {C2132
or C2140}1 AND
C3225 EQ APR AND
C3229 EQ R
E 3
-------
OSWER Directive 9200 3 01C
SELECT LOGIC FOR SCAP - 4 FINANCIAL REPORT
PROGRAM ACTIVITY
CATEGORY
SELECT LOGIC FOR
CURRENT YEAR
PLANNED OBLIGATIONS
CERHELP
SELECT LOGIC FOR
CURRENT YEAR
PLANNED OBLIGATIONS
CERCLIS
SUM C1420 WHERE
SUM C3230 WHERE
TREATABILITY
STUDY
C2111 EQ TS AND
(C2117 EQ F or S or
SE or EP) AND
C3202 EQ P AND
C3218GE 90/Selected
Qtr AND
C3218LT 911'AND
[C3218 NOT LT {C2132
orC2140}] AND
C3225 EQ APR AND
C3229 EQ R'
PROJECT
SUPPORT
(C413 EQ AR or AS or
CR or DA or HG or
HA or MA or OM or
RM or TA or TO or
PN or MS) AND
CI404 EQ P AND
C1415GE 90/Selected
Qtr AND
C1415 LE '911 AND
C1419 EQ 'APR AND
C1416 EQ R
(C2111 EQ AR or AS or
CR or DA or GS or
HA or MA' or OM or
'RM or TA or TO) AND
(C2117 EQ F or S or
'SE or 'FE' or *EP or
RP or PS) AND
C3202 EQ P' AND
C3218 GE 90/Selected
Qtr AND
C3218 LT 911 AND
C3225 EQ APR' AND
C3229 EQ R'
E 4
-------
OSWER Directive 9200 3 01C
SELECT LOGIC FOR SCAP - 4 FINANCIAL REPORT
PROGRAM ACTIVITY
CATEGORY
SELECT LOGIC FOR
CURRENT YEAR
PLANNED OBLIGATIONS
CERHELP
SELECT LOGIC FOR
CURRENT YEAR
PLANNED OBLIGATIONS
CI' RCLIS
SUM C1420 WHERE
SUM CU30 WHERE
TAG
C413 EQ CT AND
CI404 EQ P AND
C1415 GE 90/Selected
Qtr AND
C1415 LT 911 AND
C1419 EQ 'APR AND
C1416 EQ R
C2111 EQ TG AND
(C2117 EQ ? or S or
SE or FE or EP or
RP or PS) AND
C3202 EQ P AND
C3218GE 90/Selected
Qtr AND
C3218 LT 91] AND
C3225 EQ APR AND
C3229 EQ R
CORE
C413 EQ SC AND
CI404 EQ 'P AND
C1415 GE 90/Selected
Qtr AND
C1415 LT 911 AND
C1419 EQ APR AND
C1416 EQ R
RP RD
OVERSIGHT
C413 EQ 'RD' AND
CI404 EQ P AND
C1415 GE 90/Selected
Qtr AND
C1415 LE 911 AND
C1419 EQ APR AND
C1416 EQ R
{[C2111 EQ RD AND
(C2117 EQ RP or PS)] or
(C2111 EQ 'RD and
C2117IQ MR'and
C3239 NOT CONTAINS
PRP)} AND
C3202 EQ P AND
C3218GE 90/Selected
Qtr' AND
C3218 LT 911 AND
C3225 EQ APR AND
C3229 EQ R
E 5
-------
OSWER Directive 9200 3 01C
SELECT LOGIC FOR SCAP - 4 FINANCIAL REPORT
PROGRAM ACTIVITY
CATEGORY
SELECT LOGIC FOR
CURRENT YEAR
PLANNED OBLIGATIONS
CERHELP
SELECT LOGIC FOR
CURRENT YEAR
PLANNED OBLIGATIONS
CERCLIS
SUM C1420 WHERE
SUM C3230 WHERE
RP RA
OVERSIGHT
C413 EQ RA AND
CI404 EQ P AND
C1415 GE 90/Selected
Qtr AND
C1415 LE 911 AND
C1419EQ APR AND
C1416EQ R
{[C2111 EQ RA AND
(C2117 EQ RP or PS)] or
(C2111 EQ RA and
C2117 EQ MR and
C3239 NOT CONTAINS
PRP)} AND
C3202 EQ P AND
C3218GE 90/Selected
Qtr AND
C3218 LT 911 AND
C3225 EQ APR AND
C3229 EQ R
ARCS MGMT
C413 EQ PM AND
CI404 EQ P AND
C1415 GE 90/Selected
Qtr AND
C1415 LT 911 AND
C1419 EQ APR AND
C1416EQ R AND
CI408 CONTAINS ARC
OTHER
(C413 EQ OH or OR) AND
C1404 EQ P AND
C1415 GE 90/Selected
Qtr AND
C1415 LE 911 AND
C1419 EQ APR' AND
C1416 EQ R
(C2111 EQ ND or OH or
ER or 'IM ) AND
(C2117 EQ F or 'S or
SE1 or TE or EP or
RP or PS) AND
C3202 EQ 'P AND
C3218GE 90/Selected
Qtr AND
C3218 LT 911 AND
C3225 EQ APR' AND
C3229 EQ R
E 6
-------
OSWER Directive 9200 3 01C
SELECT LOGIC FOR SCAP - 4 FINANCIAL REPORT
PROGRAM ACTIVITY
CATEGORY
SELECT LOGIC FOR
CURRENT YEAR
PLANNED OBLIGATIONS
CERHELP
SELECT LOGIC FOR
CURRENT YEAR
PLANNED OBLIGATIONS
CERCLIS
SUM C1420 WHERE
SUM CJP30 WHERE
RD
C413 EQ RT AND
C1404 EQ P' AND
C1415 GE 90/Selected
Qtr AND
C1415 LT 911 AND
C1419 EQ 'APR AND
C1416 EQ R
C2111 EQ RD AND
(C2117 EQ F or S or
'SE or FIZ or EP) AND
C3202 EQ P AND
C3218GE 90/Selected
Qtr AND
C3218 LT 911 AND
[C3218 NOT LT {C2132
or C2143}] AND
C3225 EQ A PR AND
C3229 EQ R
RA
(C2111 EQ RA or LR) AND
(C2117 EQ F or S or
SE or EP) AND
C3202 EQ P AND
C3218 GE 90/Selected
Qtr AND
C3218 LT 911 AND
[C3218 NOT LT {C2132
or C214G}] AND
C3225 EQ APR AND
C3229 EQ R
E 7
-------
OSWER Directive 9200 3 01C
SELECT LOGIC FOR SCAP - 4 FINANCIAL REPORT
PROGRAM ACTIVITY
CATEGORY
SELECT LOGIC FOR
CURRENT YEAR
PLANNED OBLIGATIONS
CERHELP
SUM C1420 WHERE
SELECT LOGIC FOR
CURRENT YEAR
PLANNED OBLIGATIONS
CERCLIS
SUM C3230 WHERE
REMOVAL
ACTIONS
(C413 EQ NA or 'NP or
RC)AND
CI404 EQ P AND
C1415 GE 90/Selected
Qtr AND
C1415 LT 911 AND
C14I9EQ APR AND
C1416 EQ R
C2111 EQ'RV AND
C3202 EQ P AND
C3218 GE 90/Selected
Qtr AND
C3218 LT 911 AND
C3225 EQ APR AND
C3229 EQ V
REMOVAL
SUPPORT
[C413 EQ AU or RE or
EZ or (RS and
CI408 NE TAT and
CI408 ne TAZ)] AND
C1404 EQ P AND
C1415 GE 90/Selected
Qtr AND
C1415 LT 911 AND
C1419 EQ 'APR AND
C1416 EQ V
(C2111 EQ RC or EV or
TR)AND
C3202 EQ P AND
C3218 GE 90/Selected
Qtr AND
C3218 LT 911 AND
C3225 EQ APR AND
C3229 EQ V
ENFORCEMENT
C413 EQ ANY CODE AND
CI404 EQ P AND
C1415 GE 90/Selected
Qtr AND
C1415 LT 911 AND
C1419EQ APR AND
C1416 EQ E
[C2111 EQ ANY CODE and
(C2117 EQ FE or RP or
PS) and
C3202 EQ P and
C3218 GE 90/Selected
Qtr and
C3218 LT 911' and
C3225 EQ APR and
C3229 EQ E ] OR
[C1732 EQ ANY CODE and
(C1707 EQ 'FE or SE or
FF) and
C2903 EQ G and
C2905 GE 90/Selected
Qtr and
C2905 LT 911 and
C2909 EQ APR and
C2918 EQ E]
E 8
-------
OSWER Directive 9200 3 OK
SELECT LOGIC FOR SCAP - 4 FINANCIAL REPORT
PROGRAM ACTIVITY
CATEGORY
SELECT LOGIC FOR
CURRENT YEAR
PLANNED OBLIGATIONS
CERHELP
SUM C1420 WHERE
SELECT LOGIC FOR
CURRENT YEAR
PLANNED OBLIGATIONS
CERCLIS
SUM C 3230 WHERE
HEADQUARTERS
REMEDIAL
C413 EQ ANY CODE AND
C1404 EQ P AND
C1415 GE 90/Selected
Qtr AND
C1415 LT 911 AND
C1419 EQ APR AND
C1416EQ D
C2111 EQ ^vNY CODE AND
C3202 EQ P AND
C3218GE 90/Selected
Qtr AND
C3218 LT 911 AND
C3225 EQ APR AND
C3229 EQ D
HEADQUARTERS
REMOVAL
[C413 EQ NA or NP or
RC or AU or RE or
EZ or (RS and
CI408 NE TAT and
CI408 ne TAZ)] AND
CI404 EQ P AND
C1415 GE 90/Selected
Qtr AND
C1415LT 911 AND
C1419 EQ APR' AND
C1416 EQ M
(C2 111 EQ RC or EV or
TR or RV) AND
C3202 EQ P AND
C3218 GE 90/Selected
Qtr AND
C3218 LT 911 AND
C3225 EQ APR AND
C3229 EQ M
HEADQUARTERS
ENFORCEMENT
C413 EQ ANY CODE AND
CI404 EQ 'P AND
C1415 GE 90/Selected
Qtr AND
C1415 LT 911 AND
C1419 EQ APR' AND
C1416 EQ N
[C2111 EQ ANY CODE and
(C2117 EQ FE' or 'RP' or
PS ) and
C3202 EQ P and
C3218 GE 90/Selected
Qtr and
C3218 LT 911 and
C3225 EQ APR' and
C3229 EQ N ] OR
[C1732 EQ ANY CODE and
(C1707 EQ 'FE or SE or
TF) and
C2903 EQ G and
C2905 GE 90/Selected
Qtr' and
C2905LT 911 and
C2909 EQ APR and
C2918 EQ N']
E 9
-------
SCAP-14
TARGET AND ACCOMPLISHMENTS
REPORT SELECT LOGIC
FOR FISCAL YEAR 1990
APRIL 23, 1989
CURRENT AS OF
4/23/89
-------
OSWER Directive 9200 3 (
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMEN TS REPORT
PRELIMINARY ASSESSMENT COMPLETION
TARGET DATA
PLANNING DATA
ACC OMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = PA AND
C305 NE O AND
CP203 = 90 AND
C2103 EXISTS AND
CP206 = NL AND
C2111 = PA AND
(CP 1201 = '1' or 2' or
(C2117 = S or F) AND
3 or 4)
C2141 = FIRST C2141 AND
C2141 GE 10/01/89 AND
C2141 LT 10/01/90
DATABASE CERHELP
DATA EASE CERCLIS
Select the number of sites
Select sites with a Federal or State
targeted for a Preliminary
lead Preliminary Assessment
Assessment completion
that has be .en completed during
for Fiscal year 1990
fiscal yeai 1990 that is the
first to coriplete at that site
E 11
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
SITE INSPECTION COMPLETION
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = SI AND
C305 NE O AND
CP203 = 90 AND
C2103 EXISTS AND
CP206 = NL AND
C2111 = SI AND
(CP 1201 = 1 or 2 or
(C2117 = S or F) AND
3 or 4)
C2141 = FIRST C2141 AND
C2141 GE 10/01/89 AND
C2141 LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
Select the number of sites
Select sites with a Federal or State
targeted for a Site
lead Site Inspection
Inspection completion
that has been completed during
for Fiscal year 1990
fiscal year 1990 that is the
first to complete at that site
E 12
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 199ft TARGETS/ACCOMPLISHMENTS REPORT
RI/FS FIRST START
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DA TA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = CS AND
(C305 = P or F or
(C305 = P or F or
CP203 = 90 AND
R or D or 'S') AND
'R or 'D) AND
CP206 = NL' AND
(C2111 = RI or 'FS or
(C2111 - RI or FS or
(CP! 201 = *1' or '2 or
CO) AND
¦CO) AND
3' or '4')
(C2115 = A or B) AND
(C2115 = A or B) AND
C2110 = P AND
(C2117 - 'F or S' or SE
(C2132 = 901 or 902 or
oi RP or MR
903 or 904) AND
or EP or PS ) AND
{[C2117 = EP or RP or
C2140CL 10/01/89 AND
MR' or PS ] or
C2140 LT 10/01/90
[(C2117 = F or S or
SE) and
((C3202 = P and C3218 =
C2132 and C3225 = APR) or
C3202 = C and C3232
GTO))]}
ATA BASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
ct sites with a targeted RI/FS
Select sites that are Proposed Final
Select sites that are Proposed
start for any fiscal year 1990
Removed Deleted or Soon to be
Final Remo\ ed or Deleted to the
ter
proposed to the NPL that have a
NPL that have a Remedial
Remedial Investigation
Investigation Feasibility Study or
Feasibility Study or Combined
Combined RI/FS that started during
RI/FS planned to start during
fiscal year 1990 and was the first
fiscal year 1990 that will be the
at the site
first at the site For projects with
F S and SE leads there must also
be Approved funding Planned
for the same FYQ (Fiscal Year
Quarter) as the start date for the RI/FS
unless therehas already been a
commitment made
E 13
-------
OSWER Directive 9200 3 01'
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RI/FS FIRST START (FUND CEILING)
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = CS AND
(C305 = P or F or
(C305 = P' or F or
CP203 = 90 AND
R'or D or S) AND
R or D ) AND
CP206 = NL AND
(C2 111 = RI or FS or
(C2 111 = RI or FS or
(CP1201 = 1 or 2 or
CO) AND
CO)AND
3 or 4)
(C2115 = A or B) AND
(C2115 = A or B) AND
C2110 = P AND
(C2117 = F or S or SE
(C2132 = 901 or 902 or
or EP) AND
903 or 904) AND
C2140 GE 10/01/89 AND
{C2117 = EP or
C2140LT 10/01/90
[(C2117 = F or S or
SE) and
((C3202 = P and C3218 =
C2132 and C3225 = APR) or
C3202 = C and C3232
GT 0)]}
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select sites with a targeted RI/FS
Select sites that are Proposed Final
Select sites that are Proposed
first start for any fiscal year 1990
Removed Deleted or Soon to be
Final Removed or Deleted to the
quarter
proposed to the NPL that have a
NPL that have a Remedial
Remedial Investigation
Investigation Feasibility Study or
Feasibility Study or Combined
Combined RI/FS that started during
RI/FS planned to start during
fiscal year 1990 was funded by
fiscal year 1990 that require EPA
EPA or was done In House
funding or are In House and will be the
and was the first at the site
first at the site These projects must
have Approved funding Planned
for the same FYQ (Fiscal Year
Quarter) as the start date for the RI/FS
unless there has already been a
commitment made
E-14
-------
CSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND ACCOMPLISHMENTS
REPORT
RI/FS FIRST START (FEDERAL FACILITY)
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = CS' AND
C135 = Y
C135 = Y
CP203 = 90 AND
(C305 = P or F or
(C305 = P or F or
CP206 = FF AND
R or D) AND
R or D) AND
(CP 1201 = '1 or 2 or
C2110 = P AND
(C211 ] = RI or FS or
3 or 4)
(C2111 = RI or FS or
CO) AND
CO) AND
(C211*» = A or B) AND
(C2115 = A or B) AND
C21 W = FF AND
C2117 = 'FF AND
C2140 GE 10/01/89 AND
(C2132 = '901 or 902 or
C2140 LT 10/01/90
903 or 904)
DATABASE CERCLIS
DATABASE CERCLIS
DATA BASE CERCLIS
Select sites with a targeted
Select sites that are Proposed Final
Select siU-s that are Proposed
Federal Facility lead RI/FS
Removed Deleted or Soon to be
Final Removed or Deleted
fust stan for any fiscal year
proposed to the NPL that have a
to the NPL that have a Federal
1990 quarter
Federal Facility lead
Facility lead Remedial
Remedial Investigation
Investigation Feasability Study
Feasibility Study or Combined
or Combined RI/ FS that started
RI/FS planned to start during
during fis al year 1990 and was
fiscal year 1990 that will bethe
the first s:art at the site
first at the site
E-15
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPIJSHMENTS REPORT
RI/FS SUBSEQUENT START
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = QC AND
(C305 = V or F or
(C305 = 'P or F' or
CP203 = 90' AND
Ror'DorS) AND
R' or D') AND
CP206 = NL AND
(C2 111 = RI or FS or
(C2 111 = RI or FS or
(CP1201 = 1 or 2 or
CO) AND
CO)AND
'3 or 4)
(C2115 = Cor D) AND
(C2115 = C or D') AND
C2110 = 'P AND
(C2117 = 'F or S* or SE
(C2132 = 901 or 902 or
or RP or MR or
903 or'904) AND
'EP or PS') AND
{[C2117 = EP or RP or
C2140 GE 10/01/89 AND
MR or 'PS'] or
C2140LT 10/01/90
[(C2117 = F or S' or
SE) and
((C3202 = P and C3218 =
C2132 and C3225 = APR) or
C3202 = C and C3232
GT0))]}
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select sites with a targeted RI/FS
Select sites that are Proposed Final
Select sites that are Proposed
subsequent start for any fiscal year
Removed Deleted or Soon to be
Final Removed or Deleted
1990 quarter
proposed to the NPL that have a
to the NPL that have a Remedial
Remedial Investigation
Investigation Feasability Study
Feasibility Study or Combined
or Combined RI/ FS that started
RI/FS planned to start during
during fiscal year 1990 and was a
fiscal year 1990 that will be a
subsequent start at the site
subsequent at the site For projects
with F S and SE leads there must also
be Approved funding planned
for the same FYQ (Fiscal Year
Quarter) as the start date for the RI/FS
unless there has already been a
commitment made
E 16
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RI/FS SUBSEQUENT START (FUND CEILING)
TARGET DATA
PLANNING DATA
AC COMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = QC AND
(C305 = P or F or
(C305 = P or F or
CP203 = 90 AND
R orD'or S) AND
R oi D) AND
CP206 = NL AND
(C2111 = RI or FS or
(C2111 =- RI or FS or
(CP 1201 = '1 or 2 or
CO) AND
CO)AND
'3 or 4)
(C2115 = C or D) AND
(C2115 = C or D) AND
C2110 = P AND
(C2117 = F or S or SE
(C2132 = 901' or 902 or
or EP) AND
903 or 904) AND
C2140 GE 10/01/89 AND
{C2117 = EP or
C2140 LT 10/01/90
[(C2117 = F or S or
SE) and
((C3202 = P and C3218 =
C2132 and C3225 = APR) or
C3202 = C and C3232
GT 0)]}
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
elect site.* with a targeted RI/FS
Select sites that are Proposed Final
Select sites that are Proposed
jbscquent start for any fiscal year
Removed Deleted or Soon to be
Final Removed or Deleted to
990 quarter
proposed to the NPL that have a
the NPL th it have a Remedial
Remedial Investigation Feasibility
Investigation Feasibility Study
Study or Combined RI/FS planned to
or Combined RI/FS that started
start during fiscal year 1990 that
during fiscal year 1990 was
require EPA funding and will be a
funded by CPA and was a
subsequent at the site These projects
subsequent at the site
must have Approved funding planned
I
for the same FYQ (Fiscal Year
f
Quarter) as the start date for the RI/FS
unless there has already been a
commitment made
E 17
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND ACCOMPLISHMENTS
REPORT
RI/FS SUBSEQUENT START (FEDERAL FACILITY)
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = QC AND
C135 = Y
C135 = Y
CP203 = 90 AND
(C305 = P or F or
(C305 = P or F or
CP206 = FF AND
R or D or S) AND
R or D) AND
(CP 1201 = 1 or 2 or
C2110 = P AND
(C2111 = RI or FS or
3 or 4)
(C2111 = RI or FS or
CO)AND
CO) AND
(C2115 = C or D) AND
(C2115 = C or'D) AND
C2117 = FF AND
C2117 = FF AND
C2140GE 10/01/89 AND
(C2132 = 901 or 902 or
C2140LT 10/01/90
903 or 904')
DATABASE CERCLIS
DATABASE CERCLIS
DATABASE CERCLIS
Select sites with a targeted
Select sites that are Proposed Final
Select sites that are Proposed
Federal Facility lead RI/FS
Removed Deleted or Soon to be
Final Removed or Deleted
subsequent start for any fiscal year
proposed to the NPL that have a
to the NPL that have a Federal
1990 quarter
Federal Facility lead
Facility lead Remedial
Remedial Investigation
Investigation Feasability Study
Feasibility Study or Combined
or Combined RI/ FS that started
RI/FS planned to start during
during fiscal year 1990 and was a
fiscal year 1990 that will be a
subsequent start at the site
subsequent at the site
E-18
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RI/FS FIRST COMPLETION CFIRST ROD1
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = OF AND
C135 NOT = Y AND
C135 NOT = Y AND
CP203 = 90' AND
(C305 = P or F
(C305 = P or F
CP206 = NL AND
or D or S ) AND
or R or D) AND
(CP 1201 = 1 or 2 or
C2111 = RO AND
C2111= RO AND
3 or 4)
(C2116 = A or B) AND
(C2116 = A or B ) AND
(C2117 = EP or RP or FE
(C2117 = EP or RP or
or MR or PS or F
FE or MR or PS
or S' or SE )
or F or S or SE )
(C2133 = 901 or 902 or
C2141GI 10/01/89 AND
903 or 904) AND
C2141 LI 10/01/90 AND
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
lect sites with a targeted first
Select sites that are Proposed Final
Select sites that are Proposed
cord of Decision for any fiscal
Removed Deleted or Soon to be
Final Rcmo/edor Deleted to
ir 1990 quarter
proposed to the NPL that have a
theNPLthu have a Record Of
Record Of Decision planned to
Decision that was signed during
be signed during fiscal year 1990
fiscal year ; 990 and was the
that will be the first at the site
first at the ite The site cannot
The site cannot be a Federal Facility
be a Federal Facility
E-19
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RIFS FIRST COMPLETION (FIRST ROD)
(FEDERAL FACILITY)
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = OF AND
C135 = Y AND
C135 = Y AND
CP206 = 'FF AND
(C305 = P or F
(C305 = P or F
CP203 = 90 AND
or D or S ) AND
or R or D ) AND
(CP 1201 = 1 or 2 or
C2111 = RO AND
C2111 = RO AND
3 or 4)
(C2116 = A or B) AND
(C2116 = A or B) AND
(C2117 = FE AND
(C2117 = FE AND
C2133 = 901 or 902 or
C2141 GE 10/01/89 AND
903 or 904)
C2141 LT 10/01/90
DATA BASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
ielect sites with a targeted first
Select Federal Facility sites that are
Select Federal Facility sites that
Record of Decision for any fiscal
Proposed Final Deleted or Soon
are Proposed Final Removed
'ear 1990 quarter with a
to be proposed to the NPL that
or Deleted to the NPL that
•ederal Facility lead
have a Record Of Decision planned
have a Record Of Decision
to be signed during fiscal year 1990
that was signed during fiscal
that will be the first at the site
year 1990 and was the first
at the site
E 20
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RI/FS SUBSEQUENT COMPLETION fSIIBSO ROD!
TARGETDATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = OS' AND
C135 NOT = Y AND
C135 NOT = Y AND
CP203 = 90 AND
(C305 = P' or F
(C305 - P or F
CP206 = NL AND
or D or S) AND
or R or D) AND
(CP 1201 = 1 or '2 or
(C2111 = RO AND
(C2111 = 'RO AND
3 or '4)
(C2116 = C or D) AND
(C2116 = C or D) AND
(C2117 = 'EP' or 'RP or FE
(C2117 = EP or RP or FE
or 'MR or PS' or F
cr MR or PS' or F
or S' or SE )
or S or SE )
(C2133 = 901 or 902 or
C2141 GE 10/01/89 AND
903 or 904) AND
C21411 r 10/01/90 AND
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select sites with a targeted
Select sites that are Proposed
Select sues that are Proposed
subsequent Record of Decision
Final Deleted or Soon to be
Final Removed or Deleted to
for any fiscal year 1990 quarter
proposed to the NPL that have a
the NPL that have a Record
Record Of Decision planned to
of Decision that was signed
be signed during fiscal year 1990
during fl>cal year 1990 and
that will be a subsequent at the site
was a subsequent at the site
The site cannot be a Federal Facility
The site i annot be a Federal
Facility
E 21
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND ACOMPLISHMENTS
REPORT
RI/FS SUBSEQUENT COMPLETION (SUBSO ROD)
FEDERAL FACILITY
CP202 = OS' AND
C135EQ Y AND(C305 =
CI35 EQ Y'AND
CP203 = 90' AND
P or F or 'R
(C305 = P' or T
CP206 = TF AND
or D or S ) AND
or R or D or S) AND
(CP 1201 = 1 or '2 or
C2110 = 'P AND
(C2111 = RO AND
3 or 4)
(C2111 = RO AND
(C2116 = Cor D) AND
(C2116 = C or D) AND
C2117 = FE AND
C2117 = FE AND
C2141 GE 10/01/89 AND
(C2133 = 901 or 902 or
C2141 LT 10/01/90
'903 or 904')
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
:lect sites with a targeted
Select sites that are Proposed
Select sites that are Proposed
sderal Facility lead
Final Removed Deleted or Soon to be
Final Removed Deleted or
ibsequent Record of Decision
proposed to the NPL that have a
Soon to be proposed to
r any fiscal year 1990 quarter
Federal Facility lead
the NPL that have a Federal
Record Of Decision planned to
Facility lead Record
be signed during fiscal year 1990
of Decision that was signed
that will be a subsequent at the site
during fiscal year 1990 and
was a subsequent at the site
E 22
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RI/FS FINAL COMPLETION (FINAL ROm
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
:P202 = OD' AND
C135 NOT = 'Y AND
CI35 NOT = Y'AND
:P203 = 90 AND
(C305 = P or F
(C305 = P or F
ZP206 = 'NL AND
or D or S) AND
or F or D) AND
CP 1201 = 1 or '2 or
(C2111 = RO AND
(C2111 = RO AND
3 or 4)
(C2116 = A or D) AND
(C2116 = A or D) AND
(C2133 = 901 or 902 or
C2141 GE 10/01/89 AND
903 or 904) AND
C2141L1 10/01/90 AND
(C2117 = "EP or RP or FE
(C2117 = 'EP or RP or
or MR' or PS or F
FE or MR or PS
or S or SE )
or F or S' or SE )
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
sleet sites with a targeted final
Select sites that are Proposed Final
Select sites that are Proposed
ecord of Decision for any fiscal
Deleted or Soon to be proposed
Final Removed or Deleted to
jar 1990 quarter
to the NPL that have a Record Of
the NPL that have a Record
Decision planned to be signed during
of Decision that was signed
fiscal year 1990 that will be the
during fiscal year 1990 and was
final at the site The site cannot be
the final at the site The site
a Federal Facility
cannot be
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RI/FS COMPLETION (FS TO PUBLIC)
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = RC AND
C135 NOT = Y AND
CI35 NOT = Y AND
CP203 = 90 AND
(C305 = P or F
(C305 = 'P or F
CP206 = NL AND
or D or S ) AND
or R or D) AND
(CP 1201 = 1' or 2 or
(C2111 = FS or CO) AND
(C2111 = FS
3 or 4)
(C2116 = A or B
or CO) AND
or C or 'D ) AND
(C2116 = 'A or 'B
(C2117 = EP or RP or FE
or C or D ) AND
or MR or PS or F'
(C2117 = EP' or RP or
or S or SE ) AND
FE or MR or PS
C3111 = CF AND
or 'F or S or SE ) AND
(C3129 = 901 or 902
C3111 = CF AND
or 903 or 904)
C3125 GE 10/01/89 AND
C3125 LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select sites with a targeted
Select sites that are Proposed Final
Select sites that are Proposed
Feasability Study to Public for
Removed or Deleted or Soon to be
Final or Deleted to the NPL that
any fiscal year 1990 quarter
Proposed to the NPL that have a
have a Feasibility Study or
Feasibility Study or Combined RI/FS
Combined RI/FS released to the
planned to be released to the public
public during fiscal year 1990
during fiscal year 1990 The site
The site cannot be a Federal
cannot be a Federal Facility
Facility
E-24
-------
OSWER Directive 9200 3 QIC
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RD FIRST START
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = DS AND
(C305 = P or F or
(C30f = P or F
CP203 = 90 AND
D or S) AND
or D) AND
CP206 = NL AND
C2110 = P AND
C211 I = RD AND
(CP 1201 = 1 or 2 or
C2111 = RD AND
(C2115 = A or B) AND
3 or 4)
(C2115 = A or B) AND
(C2117 = F or S or SE
(C2132 = 901 or 902 or
or RP or MR or
903 or 904) AND
EP or PS ) AND
{[C2117 = EP or RP or
C2140GE 10/01/89 AND
MR or PS ] or
C2140LT 10/01/90
[(C2117 = For S or
SE) and
((C3202 = P and C3218 =
C2132 and C3225 = APR) or
C3202 = C and C3232
GT0))]}
DATABASE CERHELP
DATABASE CERCLIS
DATA BASE CERCLIS
Select sites with a targeted
Select sites that are Proposed
Select sites that are Proposed
Remedial Design
Final Deleted or Soon to be
Final or Deleted to the NPL that
Irst start for any fiscal year 1990
proposed to the NPL that have a
have a Remedial Design
quarter
Remedial Design planned to start
that started during fiscal year
during fiscal year 1990 that will be the
1990 and *as the first at the site
first at the site For projects with
F S and SE leads there must also
be Approved funding planned
for the same FYQ (Fiscal Year
Quarter) as the start date for the RD
unless there has already been a
commitment made
E 25
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RD FIRST START fFIJND CEILING)
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = DS AND
(C305 = P or F or
(C305 = P or T
CP203 = 90 AND
D or S ) AND
or D) AND
CP206 = NL AND
C2110 = P AND
(C2 111 = RD AND
(CP1201 = 1 or 2 or
C2111 = RD AND
(C2115 = A or B) AND
3 or 4)
(C2115 = A or B) AND
(C2117 = T or S
(C2132 = 901 or 902 or
or EP or SE) AND
903' or 904') AND
C2140 GE 10/01/89 AND
{C2117 = EP or
C2140 LT 10/01/90
[(C2117 = F or S or
SE) and
((C3202 = P and C3218 =
C2132 and C3225 = APR) or
C3202 = C and C3232
GT 0)]}
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select sites with a targeted
Select sites that are Proposed Final
Select sites that arc Proposed
Remedial Design
Removed Deleted or Soon to be
Final or Deleted to the NPL
first start for any fiscal year 1990
proposed to the NPL that have a
that have a Remedial Design
quarter
Remedial Design planned to start
that started during fiscal year 1990
during fiscal year 1990 that require
was funded by EPA or was done In
EPA funding or was done In House
House and was the first at the site
and will be the first at the site
These projects must have Approved
funding planned for the same FYQ
(Fiscal Year Quarter) as the start date
for the RD unless there has already
been a commitment made
E 26
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND ACCOMPLISHMENTS
REPORT
RD FIRST START (FEDERAL FACILITY)
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = DS AND
C135 EQ Y AND
C135 EQ Y AND
CP203 = 90 AND
(C305 = P or F or
(C305 = P or F or R
CP206 = NL AND
D or S ) AND
or D) AND
(CP1201 = '1 or 2 or
C2110 = P AND
C2111 = RD AND
3' or 4)
C2111 = RD AND
(C2115 = A or B
(C2115 = A or B
or BLANK) AND
or BLANK) AND
C2117 = FF AND
C2117 = FF AND
C2140GE 10/01/89 AND
(C2132 = 901 or 902 or
C2140LT 10/01/90
903 or 904)
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select sites with a targeted
Select sites that are Proposed
Select sues that arc Proposed
Remedial Design First
Final Deleted or Soon to
Final Removed or Deleted from
start for any fiscal year 1990
be proposed to the NPL that have a
the NPL that have a Remedial
quarter
Remedial Design planned to start
Design that started during fiscal
during fiscal year 1990 that will be a
year 1990 and was a first
first at the site
start at the site
E-27
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RD SUBSEQUENT START
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = QD AND
(C305 = P or F or
(C305 = P' or F
CP203 = 90' AND
D or S ) AND
or D) AND
CP206 = NL AND
C2110 = P AND
C2111 = RD AND
(CP 1201 = 1' or 2 or
C2111 = RD AND
(C2115 = C or D) AND
3 or 4)
(C2115 = C or D) AND
(C2117 = F or S or SE
(C2132 = 901 or 902 or
or RP or 'MR' or
903 or 904) AND
EP or PS ) AND
{[ C2117 = EP' or RP' or
C2140GE 10/01/89 AND
MR or PS ] or
C2140LT 10/01/90
[(C2117 = F or S or
SE) and
((C3202 = P and C3218 =
C2132 and C3225 = APR) or
C3202 = C and C3232
GT0))]}
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select sites with a targeted
Select sites that are Proposed
Select sites that are Proposed
Remedial Design subsequent
Final Deleted or Soon to be
Final or Deleted to the NPL that
start for any fiscal year 1990
proposed to the NPL that have a
have a Remedial Design
quarter
Remedial Design planned to start
that started dunng fiscal year
during fiscal year 1990 that will be a
1990 and was a subsequent
subsequent at the site For projects
start at the site
with F S and SE leads there must
also be Approved funding planned
for the same FYQ (Fiscal Year
Quarter) as the start date for the RD
unless there has already been a
commitment made
E 28
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RD SUBSEQUENT START (FUND CEILING?
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
ue-zuz = AINU
CP203 = 90 AND
CP206 = NL AND
(CP 1201 = 1 or 2 or
'3'or 4)
(U.31D = f or t or
D or 'S ) AND
C2110 = 'P AND
C2111 = 'RD' AND
(C2115 = C or D) AND
(C2132 = 901 or 902 or
903 or 904) AND
{C2117 = EP or
[(C2117 = -F or S or
SE) and
((C3202 = P and C3218 =
C2132 and C3225 = APR) or
C3202 = C and C3232
GT 0)]}
(U^U3 = T' or f
or D)AND
(C2111 = RD AND
(C2115 = C or D) AND
(C2117 = ForS
or EP or SE) AND
C2140GE 10/01/89 AND
C2140 LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATA BASE CERCLIS
elect sites with a targeted
remedial Design subsequent
tart for any fiscal year 1990
uarter
Select sites that are Proposed Final
Deleted or Soon to be proposed
to the NPL that have a Remedial Design
planned to start during fiscal year
1990 that require EPA funding or will be
done In House and will be a subsequent
at the site These projects must
have Approved funding planned
for the same FYQ (Fiscal Year
Quarter) as the start date for the RD
unless there has already been a
commitment made
E 29
Select sites that are Proposed
Final or Deleted to the NPL that
have a Remedial Design that
started during fiscal year 1990
was funded by EPA or was
In House and was a
subsequent start at the site
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND ACCOMPLISHMENTS
REPORT
RD SUBSEQUENT START (FEDERAL FACILITY)
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = QD AND
C135EQ Y AND
C135 EQ Y AND
CP203 = 90 AND
(C305 = P or F or
(C305 = P or F or D
CP206 = FF AND
D or S ) AND
AND
(CP 1201 = 1 or 2 or
C2110 = P AND
C2 111 = RD AND
3 or 4)
C2111 = RD AND
(C2115 = C or D') AND
(C2115 = C or D) AND
C2117 = FF AND
C2117 = FF AND
C2140GE 10/01/89 AND
(C2132 = 901 or 902 or
C2140 LT 10/01/90
903 or 904) AND
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select sites with a targeted
Select sites that are Proposed
Select sites that arc Proposed
Federal Faciltiy lead
Final Deleted or Soon to be
Final or Deleted from the
Remedial Design subsequent
proposed to the NPL that have a
NPL that have a Federal Facility
start for any fiscal year 1990
Federal Facility lead
lead Remedial Design
quarter
Remedial Design planned to start
that started during fiscal year
during fiscal year 1990 that will be a
1990 and was a subsequent
subsequent at the site
start at the site
E-30
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RD FINAL START
TAFGETDATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = DF AND
(C305 - P or F or
(C305 = P or F
CP203 = 90 AND
D or S) AND
or D) AND
CP206 = NL AND
C2110 = P AND
(C2111 = RD AND
(CP 1201 = 1 or 2 or
C2 111 = RD AND
(C2115 = A or D) AND
3 or 4)
(C2115 = A or D) AND
(C2117 = F or S or RP or
(C2132 = 901 or 902 or
MR or PS or EP
903 or 904) AND
or SE) AND
{[C2117 = EP or 'RP or
C2140 G:E 10/01/89 AND
MR or PS ] or
C2140LT 10/01/90
[(C2117 = 'F or S' or
SE) and
((C3202 = P and C3218 =
C2132 and C3225 = APR) or
C3202 = C and C3232
GT0))]}
ATA BASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
lect sites with a targeted
Select sites that are Proposed Final
Select sites that are Proposed
medial Design final start
Deleted or Soon to be proposed to
Final or Deleted to the NPL that
• any fiscal year 1990 quarter
the NPL that have a Remedial Design
have a Remedial Design that
planned to start during fiscal year
started during fiscal year 1990
1990 that will be the final at the site
and was the final start at the site
For projects wtih F S SE leads there
must also be Approved funding
planned for the same FYQ
(Fiscal Year Quarter) as the start
date for the RD unless there has
already been a commitment made
E 31
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RA FIRST START (PROGRAM)
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = AS AND
(C305 = P or F or
(C305 = *F or D) AND
CP206 = NL AND
or D or S) AND
C2111 = RA AND
CP203 = 90 AND
C2110 = P AND
(C2115 = A or B) AND
(CP 1201 = 1 or 2 or
C2111 = RA AND
(C2117 = F or S or
3 or 4)
(C2115 = A or B) AND
EP or SE) AND
(C2132 = 901 or 902 or
C2140GE 10/01/89 AND
903 or 904) AND
C2140LT 10/01/90
{[C2117 = EP ] or
[(C2117 = F or S or
'SE) and
((C3202 = P and C3218 =
C2132 and C3225 = APR) or
C3202 = C and C3232
GT0))]}
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select sites with a targeted fund
Select sites that are Proposed Final
Select sites that are Final or Deleted
lead Remedial Action first start
Deleted or Soon to be proposed to
on the NPL that have a fund lead
for any fiscal year 1990 quarter
the NPL that have a fund lead
Remedial Action that started during
Remedial Action planned to start
fiscal year 1990 and was the first
during fiscal year 1990 that will be the
at the site
first at the site For projects with
F S and SE leads there must also
be Approved funding planned
for the same FYQ (Fiscal Year
Quarter) as the start date for the RA
unless there has already been a
commitment made
E-32
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RA FIRST START (PRP)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = AS AND
CP206 = RP AND
CP203 = '90' AND
(CP 1201 = 1 or 2 or
3 or '4)
>ATA BASE CERHELP
elect sites with a targeted RP
tad Remedial Action first start
3r any fiscal year 1990 quarter
(C305 = P or F or S') AND
C2110 = 'P AND
C2111 = 'RA AND
(C2115 = 'A or B) AND
(C2132 = 901 or 902 or
903 or 904) AND
(C2117 = RP or MR or
PS)
DATABASE CERCLIS
Select sites that are Proposed Final
or Soon to be proposed to
the NPL that have a RP lead
Remedial Action planned to start
during fiscal year 1990 that will be the
first at the site
(C305 = P orF or D) AND
C2111 = RA' AND
(C2115 = A or B) AND
(C2117 = RP or'MR or
PS) AND
C2140C.E 10/01/89 AND
C2140LT 10/01/90
DATABASE CERCLIS
Select sites thai are Proposed
Final or Deleted on the NPL that have
a RP lead Remedial Action that
started during fiscal year 1990 and
was the first at the site
E 33
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND ACCOMPLISHMENTS
REPORT
RA FIRST START (FEDERAL FACILITY)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = AS AND
CP206 = FF AND
CP203 = 90 AND
(CP 1201 = 1 or '2' or
3 or 4)
C135EQ Y AND
(C305 = P or F or S) AND
C2110 = P AND
C2111 = RA' AND
(C2115 = A or B or
BLANK)AND
C2117 = FF AND
(C2132 = '901 or 902 or
903 or 904)
CI35 EQ Y' AND
(C305 = T or R or D )
AND
C2111 = 'RA AND
(C2115 = A or B or
BLANK)AND
C2117 = FF AND
C2140GE 10/01/89 AND
C2140LT 10/01/90
DATABASE CERCLIS
DATABASE CERHELP
DATABASE CERCLIS
ielect sites with a targeted
-------
03 iVER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RA SUBSEQUENT START (PROGRAM)
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
:P202 = 'QR AND
(C305 = P or F or S) AND
(C305 = F or D') AND
:P206 = NL AND
C2110 = P AND
C2111 = RA AND
!P203 = 90 AND
C2111 = 'RA AND
(C2115 = C or D') AND
:P1201 = 1 or 2 or
(C2115 = C or D) AND
(C2117 = F or S or
3 or'4)
(C2132 = 901 or 902 or
EP or SE) AND
903 or 904) AND
C2140GE 1 OA) 1/89 AND
{[C2117 = EP ] or
C2140 L r 10/01/90
[(C2117 = F or S or
SE) and
((C3202 = 'P and C3218 =
C2132 and C3225 = APR) or
C3202 = C' and C3232
GT0))]}
\TA BASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
lect sites with a targeted fund
Select sites that are Proposed Final
Select sites that are Final or Deleted
d Remedial Action subsequent
Deleted or Soon to be proposed to
on the NPL that have a fund lead
rl for any fiscal year 1990
the NPL that have a fund lead
Remedial Action that started dunng
irter
Remedial Action planned to start
fiscal year 19(>0 and was a
during fiscal year 1990 that will be a
subsequent at the site
subsequent at the site For projects
with F S and SE leads there must also
be Approved funding planned
for the same FYQ (Fiscal Year
Quarter) as the start date for the RA
unless there has already been a
commitment made
E-35
-------
OSWER Directive 9200 3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RA SUBSEQUENT START fPRP^
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'QR' AND
CP206 = RP' AND
CP203 = 90 AND
(CP1201 = '1 or '2 or
3'or 4)
DATABASE CERHELP
Select sites with a targeted RP
lead Remedial Action subsequent
start for any fiscal year 1990 quarter
CI 35= Y' AND
(C305 = P or F or S') AND
C2110 = P AND
C2111 = 'RA AND
(C2115 = C' or T)) AND
C2110 = 'P AND
(C2132 = '901' or 902' or
903 or 904') AND
(C2117 = RP or MR or
PS')
DATABASE CERCLIS
Select sites that are Proposed Final
Deleted or Soon to be proposed to
the NPL that have a RP lead
Remedial Action planned to start
during fiscal year 1990 that will be a
subsequent at the site
C135 = Y' AND
(C305 = P or'F or T>) AND
C2111 = RA AND
(C2115 = C or T)) AND
(C2117 = 'RP' or 'MR or
PS) AND
C2140GE 10/01/89 AND
C2140LT 10/01/90
DATABASE CERCLIS
Select sites that are Proposed
Final or Deleted on the NPL that
have a RP lead Remedial Action
that started during fiscal year 1990
and was a subsequent at the site
E-36
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 199Q TARGET AND ACCOMPLISHMENTS
REPORT
RA SUBSEQUENT START (FEDERAL FACILITY)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DA IA SELECTION
CRITERIA
CP202 = 'QR AND
CP206 = FF AND
CP203 = 90 AND
(CP 1201 = '1' or '2 or
3 or 4)
C135EQ Y'AND
(C305 = P or F or S') AND
C2110 = P AND
C2111 = RA' AND
(C2115 = 'C or D) AND
C2117 = FF AND
(C2132 = 901 or 902 or
903 or 904)
CI35 EQ Y AND
(C305 = Por'D) AND
C2111 = RA AND
(C2115 = C or T)) AND
C2117 = 'FF AND
C2140 C.E 10/01/89 AND
C2140 LT 10/01/90
DATABASE CERCLIS
DATABASE CERHELP
DATABASE CERCLIS
Select sites with a targeted
-ederal Facility lead Remedial
Action subsequent start for any
Iscal year 1990 quarter
Select sites that are Proposed Final
or Soon to be proposed to
the NPL that have a Federal Facility
lead Remedial Action planned to start
during fiscal year 1990 that will be a
subsequent at the site
Select sites that arc Proposed Final
Deleted or to the NPL that have a
Federal Facility lead Remedial Action that
started during fiscal year 1990 and was a
subsequent a: the site
E-37
-------
OSWER Directive 9200 3 QIC
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RA FINAL START (PROGRAM)
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = 'AF AND
(C305 = P or F or or S)
(C305 = Por'D) AND
CP206 = NL AND
AND
C2111= RA' AND
CP203 = 90 AND
C2110 = P AND
(C2115 = 'A or T)) AND
(CP 1201 = 1 or 2 or
C2111 = RA AND
(C2117 = F or S or
3 or 4)
(C2115 = A or T)) AND
*EP or'SE) AND
(C2132 = 901 or 902 or
C2140GE 10/01/89 AND
903 or 904') AND
C2140 LT 10/01/90
{[C2117 = *EP ] or
[(C2117 = F or S' or
SE) and
((C3202 = P and C3218 =
C2132 and C3225 = 'APR) or
C3202 = 'C and C3232
GT0))]}
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Jelect sites with a targeted fund
Select sites that are Proposed Final
Select sites that are Final or Deleted
ead Remedial Action final start
or Soon to be proposed to
on the NPL that have a fund lead
or any fiscal year 1990 quarter
the NPL that have a fund lead
Remedial Action that started during
Remedial Action planned to start
fiscal year 1990 and was the final
during fiscal year 1990 that will be the
at the site
final at the site For projects with
F S and SE leads there must also
be Approved funding planned
for the same FYQ (Fiscal Year
Quarter) as the start date for the RA
unless there has already been a
commitment made
E 38
-------
C'SWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RA FINAL START fPRP)
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = 'AF* AND
(C305 = P' or F or rS') AND
(C305 = P or'F or T>') AND
CP206 = RP AND
C2110 = P AND
C2111 = RA AND
CP203 = '90 AND
C2111 = RA AND
(C2115 = A or 'D) AND
(CP 1201 = 1 or 2 or
(C2115 = A or'D) AND
(C2117 = RP or MR' or
3' or 4')
(C2132 = 901' or 902 or
PS) AND
903 or 904) AND
C2140GE 10/01/89 AND
(C2117 = 'RP or MR or
C2140LT 10/01/90
PS')
>ATA BASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
:lect sites with a targeted RP
Select sites that are Proposed Final
Select sites that are Proposed Final
ad Remedial Action final start
or Soon to be proposed to
or Deleted on the NPL that have a
r any fiscal year 1990 quarter
the NPL that have a RP lead
RP lead Remedial Action that started
Remedial Action planned to start
dunng fiscal year 1990 and was the
dunng fiscal year 1990 that will be the
final at the
-------
OSWER Directive 9200 3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
POST-SARA RA START
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = 'SA AND
(C305 = P or T or S) AND
(C305 = T or T>') AND
CP203 = '90 AND
C2111 = 'RA' AND
C2111 = 'RA' AND
(CP 1201 = 1 or 2' or
(C2115 = A or B') AND
(C2115 = 'A or B) AND
3' or 4')
C3111 = AC AND
C3111 = AC AND
[(C3125 GE 10/16/86 AND
C3125 GE 10/16/86 AND
LE 10/16/90) or (C3125 Fails
C3125LE 10/16/90 AND
and C3129 Spans Current
[(C2117 EQ 'RP' or MR
Quarter to 904)] AND
or PS') AND
(C2140 EXISTS or
C305 = P]
C2110 = P')
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select sites with a targeted
Select sites that are Proposed Final
Select sites that are Final or Deleted
Post SARA first Remedial
or Soon to be proposed to
on the NPL that have a Post SARA
Action for any Fiscal year
the NPL that have a Post SARA
Remedial Action with a Contract
1990 quarter
Remedial Action planned to start
Award subevent that completed
prior to fiscal year 1990 that will be
between 10/16/86 and 10/16/90
the first at the site There must be a
and was the first at the site
Contract Award subevent with an
actual completion date or an FY90
planned compleuon date
E-40
-------
OSWER Directive 9200 3-01C
SELECT WQIQ
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
KA FINAL COMPLETION
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = *FR
CP203 = '90'
CP206 = 'NL
(CP 1201 = 1
AND
AND
AND
or 2 or
3' or 4')
DATABASE CERHELP
Select sites with a targeted final
Remedial Action completion for
any fiscal year 1990 quarter
(C305 = 'P or F or S) AND
C2111 = 'RA' AND
(C2116 = A or T>) AND
(C2117 = F or *S' or 'RP
or 'MR' or SE or
PS' or BP) AND
(C2133 = 901' or '902 or
903' or '904') AND
(C2140 EXISTS or
C2I10 = P)
DATABASE CERCLIS
Select sites thai are Proposed Final
or Soon to be proposed to
the NPL that lave a Remedial Action
planned to complete during fiscal
year 1990 that will be the final at
the site
(C305 = T or D) AND
C2111 - RA' AND
(C2116 = A or 'D) AND
(C2117 = 'F or S or RP
or 'SE' or MR
or PS or 'EP)
AND C2141 GE 10/01/89
ANDC2141LT 10/01/90
DATA EASE CERCLIS
Select site 5 that are Proposed
Final Del< ted or Soon to be
proposed to the NPL that have
a final Remedial Action that
completed during fiscal year 1990
that will be the last at the site
E-41
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
NPI. SITE DELETION INITIATION
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'ND AND
CP203 = 90 AND
(CP 1201 = 1 or 2 or
3 or 4)
(C305 = F or T>) AND
C2111 = ND' AND
(C2117 = F or FE) AND
(C2132 = 901 or 902 or
903 or '904) AND
C2110 = P
(C305 = F or T>) AND
C2111 = 'ND' AND
(C2117 = *F or "FE) AND
C2140 GE 10/01/89 AND
C2140 LE 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select sites with a targeted
NPL Deletion Initiation
for any Fiscal year 1990 quarter
Select sites with a Federal or
Federal Enforcement lead NPL
Deletion Initiation planned for fiscal
year 1990
Select sites with a Federal or
Federal Enforcement lead NPL
Deletion Initiation that occured during
fiscal year 1990
E-42
-------
0< WER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
NPL REMOVAL FIRST START
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DAI A SELECTION
CRITERIA
P202 = RF AND
P203 = 90' AND
PI201 = 5
(C305 = P or "F or
T)' or 'S') AND
C2111 = RV AND
(C2115 = A' or B) AND
C2110 = P AND
(C2132 = 901' or 902' or
903 or 904) AND
{C2117 = RP" or
[C2117 = F and
((C3202 = 'P and C3218 =
C2132 and C3225 = APR) or
C3202 = C and C3232
GT 0)]}
(C305 = P or F or D) AND
02111 = E V AND
(C2117 = RP or F) AND
(C2115 = A or B) AND
C2140GE 10/01/89 AND
C2140 LT 10/01/90
OA BASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
xt the number of sites targeted
a NPL Removal first start for
al year 1990
Select sites that are Proposed Final
Deleted or Soon to be proposed
to the NPL that have a Removal
planned to start during fiscal year 1990
that will be the first at the site
Federal projects that require EPA
funding must have Approved
funding Planned for the same FYQ
(Fiscal Year Quarter) as the start date
for the Removal unless there has
already been a commitment made
Select sites that are Proposed Final
or Deleted to the NPL that have a
Removal which started during fiscal
year 1990 that was the first at the site
E 43
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPIJSHMENTS REPORT
NPL REMOVAL FIRST START (FUND CEILING)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP210 WHERE
CP202 = RF AND
CP203 = 90 AND
CP1201 = '5'
(C305 = P* or T or
D or S ) AND
C2111 = RV AND
(C2115 = A' or B') AND
C2110 = 'P' AND
(C2132 = 901' or '902' or
903' or 904') AND
[C2117 = T and
((C3202 = 'P* and C3218 =
C2132 and C3225 = 'APR) or
C3202 = C and C3232
GT0)]
(C305 = 'P' or T or T>') AND
C2111 = RV AND
C2117 = F AND
(C2115 = 'A' or'B') AND
C2140GE 10/01/89 AND
C2140 LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select the number of sites
targeted fa- a fund financed
Removal first start
Select sites that are Proposed Final
Deleted or Soon to be proposed
to the NPL that have a Fund financed
Removal planned to start during
fiscal year 1990 that will be the first
at the site These projects must
also have Approved funding Planned
for the same FYQ (Fiscal Year Quarter)
as the start date for the
Removal unless there has already
been a commitment made
Select sites that are Proposed, Final
or Deleted to the NPL that have
a Fund Financed Removal which
starteddunng fiscal year 1990 and
was the first at the site
E 44
-------
OSWER Directive 9200 3-01C
SELECT LOGIC
FISCAL YEAR 1990 TAROETS/ACCOMPLTSHMENTS REPORT
NPL REMOVAL SUBSEQUENT START
TARGETDATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'SS AND
CP203 = 90 AND
CP1201 = 5
(C305 = P or T or
T> or S) AND
C2111 = RV AND
(C2115 =CorD) AND
C2110 = 'P AND
(C2132 = '901' or '902 or
903' or '904') AND
{C2117 = RP' or
[C2117 = T and
((C3202 = P' and C3218 =
C2132 and C3225 = APR) or
C3202 = 'C and C3232
GT0)]}
(C305 = P or T' or *D) AND
C2111 = RV' AND
(C2117 = RP' or 'F') AND
(C2115 = C'or*D) AND
C2140GE 10/01/89 AND
C2140L1 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select the number of sites
targeted for a Removal
subsequent start
Select sites that are Proposed Final
Deleted or Soon to be proposed
to the NPL that have a Removal
planned to start during fiscal year
1990 that will be the first at the site
These projects must also have
Approved funding Planned for the
same FYQ (Fiscal Year Quarter)
as the start date for the
Removal unless there has already
been a commitment made
Select sites that are Proposed Final
Deleted or Soon to be proposed
to the NPL that have a Removal
which started during fiscal year
1990 and was the first at the site
I
E 45
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
NPL REMOVAL SUBSEQUENT START f FT INI) CEILING)
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
!P210 WHERE
(C305 = P or F or
(C305 = P or F'orD) AND
P202 = SS AND
D' or S) AND
C2111 = RV AND
'P203 - 90 AND
C2111 = RV AND
C2117 = F AND
1P1201 = 5
(C2115 = C or D) AND
(C2115 = C or T>) and
C2110 = P AND
C2140GE 10/01/89 AND
(C2132 = 901 or 902 or
C2140 LT 10/01/90
903 or 904) AND
[C2117 = F and
((C3202 = P and C3218 =
C2132 and C3225 = APR) or
C3202 = C and C3232
GT 0)]
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
•elect the number of sites
Select sites that are Proposed Final
Select sites that are Proposed Final
vith a targeted Fund financed
Deleted or Soon to be proposed
or Deleted to the NPL that have a Fund
-------
CISWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
NPL REMOVAL COMPLETION
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DA TA SELECTION
CRITERIA
CRITERIA
CRITERIA
P202 - RT' AND
(C305 = P or F or
(C305 = 'P or F
!P203 = 90 AND
Bor'S) AND
or "D) AND
P1201 = 5'
(C2111 = 'RV or 'IR or PR)
(C2111 = RV or 'IR or
AND (C2116 = A or B' or C
PR)AND
or D) AND
(C2116 = 'A or B or
(C2117 = F or RP or
C or D ) AND
CG') AND
(C2117 = F or RP or
(C2133 = 901' or 902 or
CG) AND
903 or 904) AND
C2141 GE 10/01/89 AND
(C2140 EXISTS or
C2141 LT 10/01/90
C2110 = P)
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
elect the number of sites
Select sites that are Proposed Final
Select sites that are Proposed Final
irgeted for a NPL Removal
Deleted or Soon to be proposed
or Deleted to [he NPL that have a
ompletion for fiscal year 1990
to the NPL that have a Removal
Removal which completed
planned to complete during
during fiscal >ear 1990
fiscal year 1990
E 47
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
NON-NPL REMOVAL START
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = ST AND
(C305 = N or'R ) AND
(C305 = N or 'R or
CP203 = '90 AND
C2110 = P' AND
S') AND
CP1201 = 5
C2111 = RV AND
C2111 = RV AND
(C2115 = A' or B' or
(C2115 = 'A or 'B or
C or D) AND
Cor'D) AND
(C2132 = '901 or 902' or
(C2117 = RP or F or
903 or 904') AND
CG) AND
{(C2117 = 'RP' or CG') or
C2140GE 10/01/89 AND
[C2117 = T and
C2140LT10/01/90
((C3202 = 'P' and C3218 =
C2132 and C3225 = 'APR') or
C3202 = C' and C3232
GT0)]}
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
ielect the number of sites with a
Select sites that are not on the NPL
Select sites that are not on the
argeted Non NPL Removal
that have a Removal planned to start
NPL that have a Removal
;tart for fiscal year 1990
during fiscal year 1990
which started during fiscal year 1990
Projects that require EPA funding
must have Approved funding
Planned for the same FYQ (Fiscal
Year Quarter) as the start date for the
Removal unless there has already
been a commitment made
E-48
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
NON-NPL REMOVAL START fFIJND CEILING
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DAT \ SELECTION
CRITERIA
CP210 WHERE
CP202 = 'ST' AND
CP203 = '90 AND
CP1201 = '5'
(C305 = N or R) AND
C2111 = RV' AND
C2110 = P AND
(C2115 = 'A' or B' or
C* or T>) AND
(C2132 = '901' or ,902' or
'903 or '904') AND
[(C2117 = F or CG') and
((C3202 = P and C3218 =
C2132 and C3225 = APR) or
C3202 = C' and C3232
GT0)]
(C305 = 'N or R or S) AND
C2111 = 'RV' AND
(C2115 = A or 'B1 or
C or 'D') AND
(C2117 = *F or CG) AND
C2140GE [0/01/89 AND
C2140 LT 10/01/90
•ATA BASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
elect thenumber of sites
ith a targeted Fund financed
(on NPL Removal start for any
seal year 1990 quarter
Select sites that are not included on
the NPL that have a Fund financed
Removal planned to start
during fiscal year 1990 Projects must
have Approved funding Planned
for the same FYQ (Fiscal Year
Quarter) as the start date far the
Removal unless there has already
been a commitment made
Select sites that are not on the NPL
that have a Fund Financed Removal
which started during fiscal year 1990
E 49
-------
OSWER Directive 9200 3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
NON-NPL REMOVAL COMPLETION
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = TT AND
(C305 = N or Rr) AND
(C305 = N or 'R or S) AND
CP203 = 90' AND
(C2111 = RV or IR'
(C2111 = RV' or 'IR' or
CP1201 = 5
or PR) AND
PR) AND
(C2116 = A or B or C
(C2116 = A or B' or
or T)') AND
C or T> ) AND
(C2117 = P or 'RP or
(C2117 = T or RP' or
'CG') AND
CG') AND
(C2133 = '901' or 902' or
C2141 GE 10/01/89 AND
903'or 904) AND
C2141 LT 10/01/90
(C2140 EXISTS or
C2110 = 'P)
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select the number of sites
Select sites that are not included
Select sites that are not included
targeted for a Non NPL Removal
cm the NPL that have a Removal
on the NPL that have a
completion for fiscal year 1990
planned to complete during
Removal which completed
fiscal year 1990
during fiscal year 1990
E-50
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND ACCOMPLISHMENTS
REPORT
RP/RA NEGOTIATION START
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = *ED AND
C135 NE 'Y AND
C135NE Y'AND
CP203 = '90 AND
(C305 =Por"ForD
(C305 = P or F or R
(CP 1201 = 1 or '2 or '3'
or'S') AND
or D or S') AND
or '4)
CI725 = P
CI707 TE AND
CI707 = FE AND
C1732 AN AND
C1732 = 'AN AND
C1716GE 10/01/89 AND
(C1713 = 901' or 902' or
C1716LT 10/01/90
'903 or '904)
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select the number of sites with a
Select sites that are Proposed Final
Select sites that are Proposed Final
targeted RD/RA Negotiation
Deleted, or Soon to be proposed which
Removed Di leted or Soon to be
start for any fiscal year
have an RD/RA Negotiation start
proposed to the NPL which have an
1990 quarter
planned during fiscal year 1990 The site
RD/RA Negotiation started
cannot be a Federal facility
during fiscal year 1990 The site cannot
be a Federal facility
E-51
-------
OSWER Directive 9200 3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RD/RA NEGOTIATION COMPTF.TION
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
:P202 = 'CO' AND
:P203 = 90' AND
CP1201 = 1 or 2 or 3
or '4')
(C305 = P' or 'F or T)'
or S) AND
C135 NE Y
C1732 = 'AN' AND
(C1715 = 901 or 902 or
903 or 904) AND
C1725 = P
(C305 = 'P* or 'F
or 'D) AND
C135 NE Y
C1732 = AN' AND
C1717 GE 10/01/89 AND
C1717LT 10/01/90
>ATA BASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
:lect the number of sites with a
rgeted RD/RA Negotiation
ampletion for any fiscal year
>90 quarter
Select sites that are Proposed, Final
Deleted or Soon to be proposed which
have a RD/RA Negotiation completion
planned during fiscal year 1990 The
site cannot be a Federal facility
Select sites that are Proposed Final
or Deleted to the NPL which have a
RD/RA Negotiation completed
during fiscal year 1990 The site cannot
be a Federal facility
E-52
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
SECTION 107 REMOVAL (PRE-RA) COST RECOVERY RFFERRAL
GREATER THAN 200,000
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = SB AND
C1732 = 'SV' AND
C1732 = 'SV' AND
CP203 = 90 AND
[(C2731 contains 'VM'or
[(C2731 contains W or
(CP 1201 = 1 or '2' or '3
VO or 'VD') and
'VO or 'VD') and
or '4')
not contains'VA'] AND
not contains 'VA'] AND
C2903 = 'F AND
C2903 =- F AND
C2907 GE 200,000 AND
C2907 GE 200 000 AND
CI707 = *FE' AND
CI707 = TE AND
(C1713 = '901' or 902 or
C1716GE 10/01/89 AND
903' or 904') AND
C1716 LT 10/01/90
C1725 = P
DATABASE CERHELP
DATABASE CERCLIS
DATA BASE CERCLIS
Select the number of sites with
Select Section 107 litigation activities
Select Section 107 litigation which
a targeted Removal Cost
planned to start during fiscal year 1990
started during fiscal year 1990 with
Recovery Action for any fiscal
with a Federal Cost Recovery for
a Federal Cost Recovery for
year 1990 quarter
Removal RI/FS or RD greater than
Removal PI/FS or RD greater
$200 000 planned
than $200 000
E-53
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
SECTION 107 REMEDIAL (R\) TOST RECOVERY REFERRAL
GREATER THAN 200.000
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = SQ AND
CP203 = 90 AND
(CP 1201 = 1 or 2 or 3
or 4)
C1732 = SV AND
C2731 contains VA'AND
C2903 = F AND
C2907 GE 200,000 AND
CI707 = FE AND
(C1713 = 901 or '902 or
903 or 904) AND
C1725 = P
C1732 = 'SV AND
C2731 contains VA' AND
C2903 = F AND
C2907 GE 200 000 AND
C1707 = FE AND
C1716GE 10/01/89 AND
C1716LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select the number of sites with a
targeted Remedial Cost Recovery
Action for any fiscal year 1990
quarter
Select sites that have a Section 107
litigation planned to start during fiscal
year 1990 with a Federal Cost
Recovery for Remedial Action
greater than $200 000
planned
Select sites that have a Section 107
litigation which started during Fiscal
year 1990 with a Federal Cost
Recovery for Remedial Action
greater than $200 000
E-54
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND ACCOMPLISHMENTS
REPORT
COST RECOVERY REFERRAL ACTIONS - LESS THAN 200.000
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACC OMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = RR AND
CP203 = 90' AND
(CP 1201 = 1 or 2 or 3'
or 4)
C1732 = SV AND
C2903 = 'F AND
C2907 LT 200 000 AND
C1707 = FE AND
(C1713 = 901 or 902 or
903 or 904)
C1732 - SV AND
C2903 F AND
C2907 L T 200 000 AND
C1707 - 'FE AND
C1716 CjE 10/01/89 AND
C1716LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select the number of sites with a
targeted Remedial Cost Recovery
Action for any fiscal year 1990
quarter
Select sites that have a Section 107
litigation planned to start during fiscal
year 1990 with a Federal Cost
Recovery for less than $200 000
planned
Select sites that have a Section 107
litigation that started during fiscal
year 1990 with a Federal Cost
Recovery lor less than $200 000
E 55
-------
OSWER Directive 9200 3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
ADMINISTRATIVE COST RECOVERY SETTLEMENT
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = AL' AND
CP203 = '90 AND
(CP 1201 = 1 or 2 or 3
or '4')
(CI732 = AV or FI or 'AC'
orUA) AND
C2903 = F AND
(C1715 = '901' or '902' or
903 or 904)
[C1732 = AV or FI or
'AC' or (CI732 = AU
AND C1726 NE O
or 'N')]
C2903 = "F AND
C2907 GT 0 AND
C1717GE 10/01/89 AND
C1717LT 10/01/90 AND
C1726 = Y' AND
(C2731 contains VM
or 'VO or VD or VA)
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select the number of sites with
a targeted Administrative Cost
Recovery Settlement for any
fiscal year 1990 quarter
Select sites which have a Planned
Administrative Cost Recovery
Settlement during fiscal year 1990
Select sites that have an
Administrative Cost Recovery
Settlement during fiscal year 1990
E 56
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
SECTION 106 OR 106/107 CASE RESOLUTION
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
HP202 = 'SF AND
DP203 = 90' AND
;CP1201 = 1 OR 2' OR 3
OR 4)
(C1732 = SX or CL) AND
C1707 = FE' AND
(C1715 = 901 or '902' or
903 or 904)
(CI732 = SX or CL) AND
C1707 = FE AND
C1717GE 10/01/89 AND
C1717LT ] 0/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select the number of sites with
i targeted Section 106 or
106/107Case Resolution/ for
iny fiscal year 1990 quarter
Select sites that have a Section 106
or Combined Section 106/107
completion dunng fiscal year 1990
that fully resolves the case
Select sites that have a Section 106
or Combined Section 106/107
litigation completed dunng fiscal
year 1990
E 57
-------
OSWER Directive 9200 3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
SECTION 107 CASK RESOLUTION
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = SE AND
CP203 = '90 AND
(CP 1201 = 1 or 2 or 3
or 4)
C1707 = FE' AND
C1732 = 'SV AND
(C1715 = 901 or 902 or
903 or 904)
CI 707 = TE'AND
C1732 = 'SV AND
C1717GE 10/01/89 AND
C1717LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select the number of sites with
a targeted Section 107 Case
Resolution for any fiscal
year 1990 quarter
Select sites that have a planned
Section 107 litigation completed
during fiscal year 1990
Select sites that have a Section 107
litigation completed during
fiscal year 1990
E-58
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
106 REFERRAL FOR RD/RA WITHOUT SETTLEMRNT
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = SD AND
CP203 = 90 AND
(CP 1201 = 1 or 2 or 3
or '4)
(C1732 = SX or CL) AND
(C2731 contains RD
or 'RA) AND
CI707 = TE AND
(C1713 = 901 or '902 or
903 or 904) AND
CI 725 = P
(C1732 = SX or CL) AND
(C2731 contains 'RD
or RA) AND
CI707 = TE AND
C1716GE ] 0/01/89 AND
C1716LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
elect the number of sites with a
irgeted Section 106 Referrals
v Remedial Design or Remedial
iCtion Vr ithout Settlement for
my fiscal year1990 quarter
Selected sites which have an
Section 106 or Combined 106/107
litigation with Remedial Design or
Remedial Action Remedy
planned during fiscal year 1990
Selected sites which have a
referred of Section 106 or
Combined Section 106/107
case completion during fiscal
year 1990
E 59
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
106 REFERRAL FOR RD/RA WITH SETTLEMENT
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = 'SW AND
{[C1732 = CD'and
{(C1732 = 'CD and
CP203 = 90' AND
(C1713 = '901 or 902 or
C1716GE 10/01/88 and
(CP 1201 = 1 or 2 or 3
903 or 904)]
C1716LT 10/01/89
or '4')
or
or
[C1732 = UA and
[C1732 = UA and
(C1715 = 901 or 902' or
C1717GE 10/01/88 and
903' or 904')]}
C1717 LT 10/01/89 and
AND
(CI726 = 'Y' or M' or 'J')]}
C1707 = TE AND
AND
C1725 = P AND
CI707 = FE' AND
(C2731 contains 'RD' or RA')
(C2731 contains 'RD or RA')
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select the number of sites with a
Selected sites that have a
Selected sites which have an
targeted Section 106 Referrals
Consent Decree Unilateral order
Consent Decree or Unilateral order
for RD/RA With Settlement for
for Remedial Design or Remedial
for Remedial Design or Remedial
any fiscal year 1990 quarter
Action Remedy planned during
Action where the PRP s are in
fiscal year 1990
compliance
E-60
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND ACCOMPLISHMENTS
REPORT
UNILATERAL ADMINISTRATIVE ORDER rtTAO^ FOR RD/RA
TARGETDATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = AO AND
CP203 = 90 AND
(CP 1201 = 1 or 2' or '3'
or 4)
C1732 = TJA' AND
C1707 = FE AND
(C1715 = '901 or '902 or
903 or 904) AND
CI725 = P' AND
(C2731 contains RD or RA)
C1732 = 1JA' AND
C1717GE 10/01/89 AND
C1717L1 10/01/90 AND
(C1726 = 'M' or Y' or J) AND
(C2731 contains RD' or 'RA')
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select the number of sites with a
targeted Unilateral Order for
fiscal year 1990
Select sites that have a Unilateral
Order for Remedial Design or Remedial
Action planned to be issued during
fiscal year 1990
Select sites that have a Unilateral
Admimstranvc Order for Remedial
Design or Femedial Action issued
during fisc
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
IAft AT FEDERAL FACILITIES
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = IS AND
CP203 = '90 AND
(CP 1201 = 1 or 2 or 3
or '4')
C135 = Y AND
(C305 = P or F or S'
or T)) AND
CI35 NE Y' AND
C1732 = FI AND
(C17I5 = 901 or '902' or
903 or 904) AND
C1725 = P
C135 = Y AND
(C305 = P or F or S
or T)) AND
C135 NE 'Y' AND
C1732 = Tl AND
C1717GE 10/01/89 AND
C1717 LT 10/01/90
DATABASE CERHELP
DATABASE CERCUS
DATABASE CERCUS
Select the number of sites with
i targeted Interagency
Agreement at a Federal Facility
or any fiscal year 1990 quarter
Select Federal Facility sites that
are Proposed Final Deleted or
Soon to be proposed to the NPL
that have an IAG planned to be
signed during fiscal year 1990
Select Federal Facility sites that
are Proposed Final Referred
Deleted or Soon to be proposed
to the NPL that have an IAG that
was during fiscal year 1990
E-62
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND ACCOMPLISHMENTS
REPORT
NPL SITES ADDRESSED
TARGET DATA
PLANNING DATA
ACC OMPLISHMENT
SELECTION
SELECTION
DAI A SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = "LA AND
C135 NE Y AND
CP203 = 90 AND
(C2111 = 'RI OR FS
CP206 = NL AND
or RV) AND
(CP 1201 = 1 or 2' or 3
(C2115 = A OR B) AND
or '4')
C2140 GE 10/01/89 AND
C2140LT 10/01/90 AND
C2140 = FIRST C2140
DATABASE CERHELP
DATABASE CERCLIS
Select the number of NPL sites
Select the number fo NPL sites
argeted to be Addressed
Addressed 1 or Fiscal year 1990
:or Fiscal year 1990
E-63
-------
*532^
d-
UJ
O
*
SCAP-16
TARGET AND NEGOTIATIONS
REPORT SELECT LOGIC
FOR FISCAL YEAR 1990
APRIL 23, 1989
CURRENT AS OF
4/23/89
-------
OSWER Directive 9200 3 01C
SELECT logic
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
PRELIMINARY ASSESSMENT COMPLETION
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = PA* AND
CP203 = 90 AND
CP206 = NL' AND
(CP 1201 = '1 or 2' or
'3 or 4')
TABASE CERHELP
ielecl the number of sites
argeted for a Preliminary
Assessment completion
or Fiscal year 1990
E-65
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
STTE INSPECTION COMPLETION
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = SI' AND
CP203 = '90' AND
CP206 = NL AND
(CP 1201 = T or '2' or
3 or 4)
DATABASE CERHELP
Select the number of sites
targeted for a Site
Inspection completion
for Fiscal year 1990
E-66
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RI/FS FIRST START
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'CS AND
CP203 = '90 AND
CP206 = 'NL' AND
(CP 1201 = 1 or '2 or
3 or 4)
(C305 = P or F' or
R or D or S) AND
(C2111 = 'RT or TS' or
CO) AND
(C2115 = 'A' or 'B' or
BLANK) AND
C2117 NE FF' AND
(C2132 = '901' or ,902' or
'903'or 904)
(C305 = P or "F or
R or D or S) AND
(C2111 = RI or FS or
•CO) AND
(C2115 = A or B or
BLANK) AND
C2117 NE FF AND
C2140 GE 10/01/89 AND
C2140 LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATA EASE CERCLIS
sleet sites with a targeted RI/FS
rst start for any fiscal year 1990
larter
Select sites that are Proposed Final
Removed Deleted or Soon to be
proposed to the NPL that have a
Remedial Investigation
Feasibility Study or Combined
RI/FS planned to start during
fiscal year 1990 that will be the
first at the site
E 67
Select sites that are Proposed,
Final Removed Deleted or
Soon to b< proposed to the
NPL that liave a Remedial
Investigation Feasibility Study or
Combined. RI/FS that started during
fiscal yeai 1990 and was the first
at the site
-------
OSWER Directive 9200 3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RT/FS FIRST START (FEDERAL FACILITY!
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = 'CS' AND
C135 = Y AND
C135 = Y' AND
CP203 = 90 AND
(C305 = 'P' or F or
(C305 = 'P or 'F or
CP206 = 'FF AND
'R or 'D or S') AND
R' or T>' or S ) AND
(CP 1201 = 1 or 2 or
(C2111 = RI or TS or
(C2111 = RI or TS or
'3' or '4')
CO') AND
•CO) AND
(C2115 = A or B
(C2115 = A or B
or BLANK) AND
or BLANK) AND
C2117 = FF AND
C2117 = FF AND
(C2132 = 901' or ,902' or
C2140GE 10/01/89 AND
903 or 904)
C2140 LT 10/01/90
DATABASE CERCLIS
DATABASE CERCLIS
DATABASE CERCLIS
Select sites with a targeted
Select sites that are Proposed Final
Select sites that are Proposed
Federal Facility lead RI/FS
Removed Deleted or Soon to be
Final Removed Deleted or
First start for any Fiscal year
proposed to the NPL that have a
Soon to be proposed
1990 quarter
Federal Facility lead
to the NPL that have a Federal
Remedial Investigation
Facility lead Remedial
Feasibility Study or Combined
Investigation Feasability Study
RI/FS planned to start during
ex* Combined RI/ FS that started
Fiscal year 1990 that will bethe
during fiscal year 1990 and was
first at the site
the First start at the site
E 68
-------
OSWER Directive 9200 3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RI/FS SUBSEQUENT START
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
A CCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'QC' AND
CP203 = '90 AND
CP206 = 'NL' AND
(CP1201 = 1 or 2 or
3 or'4)
(C305 = 'P' or F or
*R' or T>' or 'S) AND
(C2111 = 'RI orFS'or
CO) AND
(C2115 = C' orT)) AND
C2117 NE 'FF AND
(C2132 = '901' or '902 or
903 or 904)
(C305 = P or 'F or
R or D or 'S) AND
(C2111 = 'RT or TS or
CO') and
(C2115 = 'C' or T)') AND
C211 / NE FF AND
C2140 GE 10/01/89 AND
C2140 LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATA BASE CERCLIS
Select sites with a targeted RI/FS
subsequent start for any fiscal year
1990 quarter
Select sites that are Proposed Final
Removed Deleted or Soon to be
proposed to the NPL that have a
Remedial Investigation
Feasibility Study or Combined
RI/FS planned to start during
fiscal year 1990 that will be a
subsequent at the site
E-69
Select sites that are Proposed
Final Removed Deleted or
Soon to be proposed
to the NPL that have a Remedial
Investigation Feasability Study
or Combined RI/ FS that started
during fiscal year 1990 and was a
subsequent start at the site
-------
OSWER Directive 92003 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RI/FS SUBSEQUENT START (FEDERAL FACILITY!
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = QC AND
C135 = 'Y AND
C135 = 'Y AND
CP203 = '90' AND
(C305 = P or F or
(C305 = 'P or F or
CP206 = FF AND
R or 'D or 'S) AND
R' or T>* or 'S') AND
(CP1201 = 1 or 2 or
(C2111 = RI or "FS or
(C2 111 = RI or 'FS or
'3' or '4')
'CO') AND
'CO') AND
(C2115 =CorD) AND
(C2115 = C or T)) AND
C2117 = 'FF AND
C2117 = "FF AND
(C2132 = 901 or 902' or
C2140 GE 10/01/89 AND
'903 or'904)
C2140 LT 10/01/90
DATABASE CERCLIS
DATABASE CERCLIS
DATABASE CERCLIS
Select sites with a targeted
Select sites that are Proposed Final
Select sites that are Proposed
Federal Facility lead RI/FS
Removed Deleted or Soon to be
Final Removed Deleted or
subsequent start for any fiscal year
proposed to the NPL that have a
Soon to be proposed
1990 quarter
Federal Facility lead
to the NPL that have a Federal
Remedial Investigation
Facility lead Remedial
Feasibility Study or Combined
Investigation Feasability Study
RI/FS planned to start during
or Combined RI/ FS that started
fiscal year 1990 that will be a
during fiscal year 1990 and was a
subsequent at the site
subsequent start at the site
E70
-------
CK WER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RI/FS FIRST COMPLETION (FIRST ROD!
TARGETDATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = 'OF AND
CI 35 NE 'Y' AND
C135 NE Y AND
CP203 = 90 AND
(C305 = P or "F or R
(C305 = P or F
CP206 = 'NL AND
or D or S) AND
or R or D or 'S ) AND
(CP 1201 = 1 or 2 or
C2111 = RO AND
C2111 = RO AND
3 or '4*)
(C2116= A or B or
(C2116 A or B or
BLANK) AND
BLANK) ANI
C2117 NE FF AND
C2117 NE EF AND
(C2133 = '901' or '902 or
C2141 GE 10/01/89 AND
'903 or 904)
C2141 LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
jlect sites with a targeted first
Select sites that are Proposed, Final
Select sites that are Proposed
ecord of Decision for any fiscal
Removed Deleted or Soon to be
Final Removed Deleted or
ar 1990 quarter
proposed to the NPL that have a
Soon to b proposed to
Record Of Decision planned to
the NPL that have a Record Of
be signed during fiscal year 1990
Decision that was signed during
that will be the first at the site
fiscal yeai 1990 and was the
The site cannot be a Federal Facility
first at the site The site cannot
be a Federal Facility
E 71
-------
OSWER Directive 9200 3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RT/FS FIRST COMPLETION (FIRST ROD1
(FEDERAL FACILITY^
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'OF AND
CP206 = TF AND
CP203 = 90 AND
(CP 1201 = 1 or 2 or
'3' or '4')
(C305 = 'P' or F or 'R'
or T> or S) AND
[(CI 35 = Y and C2117 = 'FE,)
or C2117 EQ *FF] AND
C2111 = 'RO' AND
(C2116 = 'A or'B'or
BLANK) AND
(C2133 = 901' or 902' or
'903 or '904')
(C305 = 'P' or T
or 'R' or T> or 'S) AND
[(C135 = *Y' and C2117 = TE)
or C2117EQ FF] AND
C2111 ='RO* AND
(C2116 = A' or 'B' or
BLANK)AND
C2141 GE 10/01/89 AND
C2141 LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select sites with a targeted first
Record of Decision for any fiscal
year 1990 quarter with a
Federal Facility lead.
Select Federal Facility sites that are
Proposed Final Removed Deleted
or Soon to be proposed to the NPL
that have a Record Of Decision
planned to be signed during
fiscal year 1990 that will be the
first at the site
E72
Select Federal Facility sites that
are Proposed Final Removed,
Deleted or Soon to be proposed
to the NPL that have a Record
Of Decision that was signed
during fiscal year 1990 and was
the first at the site
-------
CSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RI/FS SUBSEQUENT COMPLETION (SUBSO ROD1
TARGET DATA
PLANNING DATA
AC COMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = OS' AND
C135 NE Y AND
C135 NL 'Y' AND
CP203 = 90' AND
(C305 = 'P' or T or 'R'
(C305 = *P' or F
CP206 = NL' AND
or T>' or S') AND
or 'R' or 'D' or S ) AND
(CP 1201 = T or '2' or
(C2111 = 'RO' AND
(C2111 = 'RO AND
'3 or '4)
(C2116 = 'C' or T)') AND
(C2116 = C or D') AND
C2117 NE 'FF AND
C2117 NE "FF AND
(C2133 = 901 or '902 or
C2141 CE 10/01/89 AND
*903 or *904)
C2141 LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
elect sites with a targeted
Select sites that are Proposed
Select sitt-s that are Proposed
ibsequent Record of Decision
Final Removed Deleted or Soon to be
Final Removed Deleted or
yr any fiscal year 1990 quarter
proposed to the NPL that have a
Soon to be proposed to
Record Of Decision planned to
the NPL that have a Record
be signed during fiscal year 1990
of Decision that was signed
that will be a subsequent at the site
dunng fis al year 1990 and
The site cannot be a Federal Facility
was a subsequent at the site
The site cannot be a Federal
Facility
E-73
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RI/FS SUBSEQUENT COMPLETION fSIJBSO ROD)
FEDERAL FACILITY
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = OS AND
CP203 = '90' AND
CP206 = PF AND
(CP 1201 = 1 or 2 or
'3' or '4)
(C305 = P or T or R
or D or'S') AND
[(C135 = Y and C2117 = *FE)
or C2117 EQ TF] AND
(C2111 = 'RO' AND
(C2116 = C or *D) AND
(C2133 = 901 or 902' or
903 or 904)
(C305 = P or F or
or D1 or'S') AND
[(C135 = Y' and C2117 = FE)
or C2117 EQ TF] AND
C2111 = 'RO' AND
(C2116 = C or *D) AND
C2141 GE 10/01/89 AND
C2141 LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select sites with a targeted
?ederal Facility lead
mbsequent Record of Decision
or any fiscal year 1990 quarter
Select sites that are Proposed,
Final Removed Deleted or Soon to be
proposed to the NPL that have a
Federal Facility lead
Record Of Decision planned to
be signed during fiscal year 1990
that will be a subsequent at the site
E-74 1
Select sites that are Proposed
Final Removed Deleted or
Soon to be proposed to
the NPL that have a Federal
Facility lead Record
of Decision that was signed
during fiscal year 1990 and
was a subsequent at the site
-------
Q< WER Directive 9200 3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RI/FS FINAL COMPLETION (FINAL ROm
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
!P202 = OD' AND
C135 NE 'Y' AND
C135 NE Y AND
!P203 - 90 AND
(C305 = 'P or *F or R
(C305 = 'P or F or S
P206 = 'NL' AND
or TV or 'S ) AND
or R or 'D) AND
:P1201 = '1 or 2* or
(C2111 = RO' AND
(C2111 = RO' AND
3' or '4')
(C2116 = A' or T>' or
(C2116 = 'V or D' or
BLANK) AND
BLANK) AND
C2117 NE FF AND
C2117 NE FF' AND
(C2133 = 901 or 902 or
C2141 GE 10/01/89 AND
903 or 904)
C2141 LT 10/01/90
>ATA BASE CERHELP
DATABASE CERCUS
DATABASE CERCLIS
lect sites with a targeted final
Select sites that are Proposed, Final
Select sites that are Proposed
cord of Decision for any fiscal
Removed Deleted or Soon to be
Final Removed Deleted or
ar 1990 quarter
proposed to the NPL that have a
Soon to be proposed to
Record OfDecision planned to be
the NPL that have a Record
signed during fiscal year 1990 that
of Decision that was signed
will be the final at the site The site
during fiscal year 1990 and was
cannot be a Federal Facility
the final at the site The site
cannot be a Federal Facility
E-75
-------
OSWER Directive 9200 3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RI/FS COMPLETION TFS TO PUBLIC)
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = RC AND
(C305 = P or P or 'R
(C305 = *P or "F1
CP203 = 90 AND
or T> or S) AND
or 'R' or T> or S') AND
CP206 = NL AND
(C2111 = TFS or CO) AND
(C2111 = FS
(CP 1201 = 1 or 2 or
C3111 = CF AND
or CO)AND
'3'or'4)
C2117 NE TT' AND
C3111 = 'CF AND
(C3129 = 901 or 902
C2117 NE FF AND
or 902' or 903)
C3125 GE 10/01/89 AND
C3125LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select sites with a targeted
Select sites that are Proposed Final
Select sites that are Proposed
Feasability Study to Public for
Removed Deleted or Soon to be
Final Removed Deleted or Soon
any fiscal year 1990 quarter
Proposed to the NPL that have a
to be proposed to the NPL that
Feasibility Study or Combined RI/FS
have a Feasibility Study or
planned to be released to the public
Combined RI/FS released to the
during fiscal year 1990 The site
public during fiscal year 1990
cannot be a Federal Facility
The site cannot be a Federal
Facility
E-76
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RP FIRST START
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = DS AND
CP203 = '90' AND
CP206 = NL' AND
(CP 1201 = '1 or 2 or
'3 or'4)
(C305 = P or F or
T>' or 'S ) AND
C2111 = RD' AND
(C2115 = A' or B' or
BLANK) AND
C2117 NE TF AND
(C2132 = 901 or '902 or
903 or 904') AND
(C305 = 'P' or T or R
or 'S' or T)) AND
C2111 = RD AND
(C2115 = A or B'or
BLANK)AND
C2117 NE 'FP AND
C2140GE 10/01/89 AND
C2140 LI 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
lect sites with a targeted
medial Design
st start for any fiscal year 1990
arter
Select sites that are Proposed
Final Deleted or Soon to
be proposed to the NPL that have a
Remedial Design planned to start
during fiscal year 1990 that will be the
first at the site
E-77
Select sites that are Proposed
Final Deleted Removed
or Soon to be proposed to the NPL
that have a Remedial Design
that started during fiscal year
1990 and wa* the first at the site
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RD FIRST START (FEDERAL FACILITY')
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = T)S' AND
CP203 = 90' AND
CP206 = *ff AND
(CP1201 = 1 or 2 or
3 or'4)
(C305 = 'P or T or
T> or S) AND
C2111 = RD' AND
(C2115 = A or B
or BLANK) AND
C2117 = TF AND
(C2132 = 901' or 902 or
903 or 904)
(C305 = P or F* or 'R* or
'S'or T>') AND
C2111 = RD' AND
(C2115 = A' or B
or BLANK) AND
C2117 = FF' AND
C2140GE 10/01/89 AND
C2140 LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select sites with a targeted
Remedial Design first
start for any fiscal year 1990
quarto1
Select sites that are Proposed
Final Deleted or Soon to
be proposed to the NPL that have a
Remedial Design planned to start
during fiscal year 1990 that will be a
first at the site
E-78
Select sites that are Proposed
Final Removed or Deleted from
the NPL that have a Remedial
Design that started during fiscal
year 1990 and was a first
start at the site
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FTSCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RD SUBSEQUENT START
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = QD' AND
CP203 = 90 AND
CP206 = NL' AND
(CP 1201 = 1 or 2 or
3 or 4')
(C305 = 'P' or 'F or
DorS) AND
C2111 = RD AND
(C2115 = C or D) AND
C2117 NE FF AND
(C2132 = 901' or 902' or
903 or 904)
(C305 = P or 'F' or R or
S or D) AND
C2111 - RD AND
(C211) = C or D) AND
C2117 VE FF AND
C2140 GE 10/01/89 AND
C2140 LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select sites with a targeted
Remedial Design subsequent
start for any fiscal year 1990
quarter
Select sites that are Proposed
Final Deleted or Soon to be
proposed to the NPL that have a
Remedial Design planned to start
during fiscal year 1990 that will be a
subsequent at the site
E 79
Select site > that are Proposed
Final Remo\ ed or Deleted from the
NPL that have a Remedial Design
that starteci during fiscal year
1990 and was a subsequent
start at the jite
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RD SUBSEQUENT START (FEDERAL FACILITY^
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'QD AND
CP203 = '90' AND
CP206 = FF AND
(CP1201 = '1 or 2 or
'3' or '4')
(C305 = P' or F or
*D or S) AND
C2111 = RD AND
(C2115 = C or D) AND
C2117 = FF AND
(C2I32 = 901 or 902 or
903 or 904)
(C305 = P or T or 'R or
¦S' or T>) AND
C2111 = RD AND
(C2115 = C or T>) AND
C2II7 = 'FF AND
C2140 GE 10/01/89 AND
C2I40LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
elect sites with a targeted
ederal Faciltiy lead
Remedial Design subsequent
tart far any fiscal year 1990
uarter
Select sites that are Proposed
Final Deleted or Soon to be
proposed to the NPL that have a
Federal Facility lead
Remedial Design planned to start
during fiscal year 1990 that will be a
subsequent at the site
Select sites that are Proposed
Final Removed Soon to be
Proposed or Deleted from the
NPL that have a Federal Facility
lead Remedial Design
that started during fiscal year
1990 and was a subsequent
start at the site
E 80
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RD FINAL START
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = DF AND
CP203 = 90 AND
CP206 = NL' AND
(CP 1201 = 1 or 2 or
3 or 4')
(C305 = P or P or
D or S) AND
C2111 = 'RD AND
(C2115 = A or D or
BLANK)AND
C2117 NE *FF AND
(C2132 = 901 or '902 or
903 or 904)
(C305 = 'P or 'F or R
or 'D' or S') AND
(C2111 =- RD AND
(C2115 - A or D or
BLANK) AND
C2117 NE FF AND
C2140 GE 10/01/89 AND
C2140I T 10/01/90
>ATA BASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
elect sites with a targeted
emedial Design final start
>r any fiscal year 1990 quarter
Select sites that are Proposed Final
Deleted or Soon to be proposed to
the NPL that have a Remedial Design
planned to start during fiscal year
1990 that will be the final at the site
E-81
Select sites that are Proposed
Final Removed Deleted or
Soon to be proposed to the NPL
thai have a Remedial Design that
started during fiscal year 1990
and was the final start at the site
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RA FIRST START (PROGRAM)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = AS AND
CP206 = 'NL' AND
CP203 = 90 AND
(CP 1201 = 1 or 2 or
'3' or 4)
(C305 = P' or F or 'D
or S') AND
C2111= RA AND
(C2115= A or B or
BLANK) AND
(C2117 = F' or 'S or 'FE' or
SN or EP' or SE') AND
(C2132 = 901 or 902 or
'903 or 904)
(C305 = P or 'F or R or
T>' or S) AND
C2111 = RA AND
(C2115 = 'A' or'B'or
BLANK)AND
(C2117 = *F or 'S' or FE' or
SN or *EP or SE) AND
C2140GE 10/01/89 AND
C2140LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
[elect sites with a targeted fund
ead Remedial Action first start
or any fiscal year 1990 quarter
Select sites that are Proposed, Final
Deleted or Soon to be proposed to
the NPL that have a fund lead
Remedial Action planned to start
during fiscal year 1990 that will be the
first at the site
E-82
Select sites that are Proposed
Final Removed, Deleted or
Soon to be proposed to the
NPL that have a fund lead
Remedial Action that started dunng
fiscal year 1990 and was the first
at the site
-------
OSWER Ehrecuvc 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RA FIRST START (PRP)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = AS AND
CP206 = RP" AND
CP203 = '90'
(CP 1201 = 1
AND
or 2' or
3'or'4)
DATABASE CERHELP
Select sites with a targeted RP
lead Remedial Action First start
for any fiscal year 1990 quarter
(C305 = P or'F or D or S)
AND
C2111 = RA' AND
(C2115 = A or B or
BLANK) AND
(C2117 = RP' or MR or
PS' or 'SR1 or FF)
(C2132 = 901 or 902 or
903'or 904)
DATABASE CERCLIS
Select sites that are Proposed Final
Deleted or Soon to be proposed to
the NPL that have a RP lead
Remedial Action planned to start
during Fiscal year 1990 that will be the
first at the site
(C305 = P or 'F or R or
D' or S) AND
C211. = RA AND
(C2115 = 'A' or B or
BLANK) ANI
(C2117 = RP or MR or
SR or FF or PS) AND
C2140GE 10/01/89 AND
C2140LT 10/01/90
DATA EASE CERCLIS
Select site.5 that are Proposed Final
Removed Deleted or Soon to be
proposed on the NPL that have a RP
lead Remedial Action that started
during fiscal year 1990 and was the
first at the site
E-83
-------
OS WER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RA FIRST START (FEDERAL FACTI-ITY)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = AS' AND
CP206 = FF AND
CP203 = 90 AND
(CP 1201 = 1 or 2 or
'3' or '4')
(C305 = P' or 'F or 'D'
or 'S) AND
C2111 = 'RA' AND
(C2115 = A or B or
BLANK) AND
C2117 = FF AND
(C2132 = '901 or *902'or
903 or 904)
(C305 = 'P' or 'F or 'R' or
D or S) AND
C2111 = RA AND
(C2115 = "A or B or
BLANK) AND
C2117 = 'FF AND
C2140GE 1 OA) 1/89 AND
C2140 LT 10/01/90
DATABASE CERCLIS
DATABASE CERHELP
DATABASE CERCLIS
•elect sites with a targeted
•ederal Facility lead Remedial
Vction first start for any fiscal year
990 quarter
Select sites that are Proposed Final
Deleted or Soon to be proposed to
the NPL that have a Federal Facility
lead Remedial Action planned to start
during fiscal year 1990 that will be the
first at the site
Select sites that are Proposed Final
Removed Deleted or Soon to be
proposed on the NPL that have a
Federal Facility lead
Remedial Action that started
during fiscal year 1990 and was the
first at the site
E 84
-------
OSWER Directive 9200 3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RA SUBSEQUENT START (PROGRAMS
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = QR AND
CP206 = NL AND
"P203 = 90 AND
CP 1201 = 1 or '2' or
'3 or '4')
(C305 = 'P or F or D or S')
AND
C2111 = RA AND
(C2115 = 'C or D) AND
(C2132 = 901' or 902 or
903 or 904) AND
(C2117 = *EP or F or S or
FE or'SN or SE)
(C305 = 'P' or 'F or R or
RD or S) AND
C2111 - RA AND
(C2115 = 'C' or 'D) AND
(C2117 - T or 'S' or TE' or
¦SN or 'EP or 'SE') AND
C2140GE 10/01/89 AND
C2140 LT 10/01/90
>ATA BASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
ilect sites with a targeted fund
Select sites that are Proposed Final
Select sites that are Proposed Final
ad Remedial Action subsequent
Deleted or Soon to be proposed to
Removed, Deleted or Soon to be
art for any fiscal year 1990
the NPL that have a fund lead
proposed to the NPL that have a
larter
Remedial Action planned to start
fund lead R smedial Action that started
during fiscal year 1990 that will be a
during fiscal year 1990 and was a
subsequent at the site
subsequent at the site
E 85
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RA SUBSEQUENT START (PRP)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'QR' AND
CP206 = 'RP AND
CP203 = 90' AND
(CP 1201 = 1 or 2 or
3' or '4')
(C305 = 'P* or F or 'D
or'S') AND
C2111 = RA AND
(C2115 = C or D) AND
(C2117 = 'RP' or'MR' or
SR or PS)
(C2132 = '901 or '902 or
903 or'904)
(C305 = 'P' or T or 'R or
D' or S) AND
C2111 = RA AND
(C2115 = C or D) AND
(C2117 = 'RP or MR or
SR' or 'PS') AND
C2140GE 10/01/89 AND
C2140 LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select sites with a targeted RP
lead Remedial Action subsequent
start for any fiscal year 1990 quarter
Select sites that are Proposed Final
Deleted or Soon to be proposed to
the NPL that have a RP lead
Remedial Action planned to start
during fiscal year 1990 that will be a
subsequent at the site
E-86
Select sites that are Proposed
Final Removed Deleted or
Soon to be proposed to the NPL
that have a RP lead Remedial
Action that started during fiscal
year 1990 and was a subsequent
at the site
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RA SUBSEQUENT START (FEDERAL FACILITY!
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = *QR' AND
CP206 = 'FF' AND
CP203 = '90' AND
(CP 1201 = '1' or 2' or
¦3'or '4)
(C305 = P or 'F or 'D'
or S) AND
C2111 = RA AND
(C2115 = 'C or D) AND
C2117 = FF AND
(C2132 = '901 or 902' or
'903 or 904)
(C305 = P or F or R or
T> or S) AND
C2111 RA AND
(C2115 - C or D) AND
C2117 = FF AND
C2140GE 10/01/89 AND
C2140 IT 10/01/90
DATABASE CERCLIS
DATABASE CERHELP
DATABASE CERCLIS
lelect sites with a targeted
'ederal Facility lead Remedial
Action subsequent start for any
Lscal year 1990 quarter
Select sites that are Proposed Final
Deleted or Soon to be proposed to
the NPL that have a Federal Facility
lead Remedial Action planned to start
during Fiscal year 1990 that will be a
subsequent at the site
Select sites that are Proposed Final
Removed Eyeleted or Soon to be
proposed on the NPL that have a
Federal Facility lead
Remedial Ai Hon that started
during fiscal year 1990 and was a
subsequent H the site
E 87
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTTATTTONS REPORT
RA FINAT. START (PROGRAM!
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'AF AND
CP206 = 'NL AND
CP203 = '90' AND
(CP1201 = 1 or 2 or
'3 or 4')
(C305 = 'P or *F or T>'
or *S) AND
C2111 = RA AND
(C2115 = A or T) or
BLANK) AND
(C2117 = EP or F or S
or TE' or 'SN or SE')
(C2132 = 901 or 902 or
903 or 904)
(C305 = P or F' or 'R or
T> or 'S') AND
C2111 = RA' AND
(C2115 = A or D or
BLANK) AND
(C2117 = F or 'S or FE or
'SN or 'EP' or SE) AND
C2140GE 10/01/89 AND
C2140 LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select sites with a targeted fund
lead Remedial Action final start
for any fiscal year 1990 quarter
Select sites that are Proposed Final
Deleted or Soon to be proposed to
the NPL that have a fund lead
Remedial Action planned to start
during fiscal year 1990 that will be the
final at the site
E-88
Select sites that are Proposed
Final Removed, Deleted or
Soon to be proposed to
the NPL that have a fund lead
Remedial Action that started during
fiscal year 1990 and was the final
at the site
-------
OSWER Ehrective 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RA FINAL START (PRP)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DiA T A SELECTION
CRITERIA
CP202 = AF AND
CP206 = 'RP' AND
CP203 = 90' AND
(CP 1201 = '1 or '2 or
3' or r4)
(C305 = 'P or F or D'
or 'S) AND
C2111 = 'RA' AND
(C2115 = A or D' or
BLANK) AND
(C2132 = 901 or 902 or
903 or 904) AND
(C2117 = 'RP or MR or SR
or PS)
(C305 = 'P or F or 'R or
DorS) AND
C2111 = 'RA AND
(C2115 = V or T> or
BLANK) AND
(C2117 = 'RP or 'MR' or 'SR
or PS) AND
C2140GE 10/01/89 AND
C2140 LT ] 0/01/90
)ATA BASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
ilect sites with a targeted RP
ad Remedial Action final start
r any fiscal year 1990 quarter
Select sites that are Proposed Final
Deleted or Soon to be proposed to
the NPL that have an RP lead
Remedial Action planned to start
during fiscal year 1990 that will be the
final at the site
E 89
Select sites :hat are Proposed Final
Removed Evicted or Soon to be
proposed to the NPL that have an
RP lead Remedial Action that started
during fiscal year 1990 and was
the final at the site
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
POST-SARA RA START
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = SA AND
CP203 = 90 AND
(CP 1201 = 1 or 2 or
3 or 4)
(C305 = P or T or R'
D or S) AND
C2111 = RA AND
(C2115 = A or B or
BLANK)AND
C2117 NE 'FF AND
C3111 = AC AND
[(C3125GE 10/16/86 AND
LE 10/16/90) or (C3129 Spans
Current Quarter to 904)]
(C305 = P* or 'F or 'R
or TV or 'S) AND
C2111 = RA AND
(C2115 = A1 or 'B' or
BLANK) ANC
C2117 NE "FF1 AND
C3111 = AC AND
C3125GE 10/16/86 AND
C3125 LE 10/16/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select sites with a targeted
Post SARA first Remedial
Action for any Fiscal year
1990 quarter
Select sites that are Proposed, Final
Removal Deleted or Soon to be
proposed to the NPL that have a
Post SARARemedial Action planned
to start pnor to fiscal year 1990 that
will bethe first at the site There must
be a Contract Award subevent with an
actual completion date or an FY90
planned start date
E-90
Select sites that are Proposed Final
Removed Deleted or Soon to be
proposed to the NPL that have a
Post SARA Remedial Action
with a Contract Award subevent that
completed between 10/16/86 and
10/16/90 and was the first at the site
-------
OSWER Directive 9200 3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RA FINAL COMPLETION
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = "FR AND
CP203 = '90' AND
CP206 = 'NL' AND
(CP 1201 = 1 or 2 or
'3' or '4')
(C305 = P' or F or
•D' or S*) AND
C2111 = 'RA AND
(C2116 = A or D or
BLANK) AND
C2117 NE *FF AND
(C2133 = '901 or 902 or
903' or 904)
(C305 - P' or F or R or
D' or S') AND
C2111 - 'RA' AND
(C2116 = A or D or
BLANK) AND
C2117NE 'FF AND
AND C 2141 GE 10/01/89
AND C1141 LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select sites with a targeted final
Remedial Action completion for
any fiscal year 1990 quarter
Select sites that are Proposed Final
Deleted or Soon to be proposed to
the NPL that have a Remedial Action
planned to complete during fiscal
year 1990 that will be the final at
the site
E-91
Select site > that are Proposed
Final Retrio\ed Deleted or Soon
to be proposed to the NPL that
have a final Remedial Action that
completed during fiscal year 1990
that will b the last at the site
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
NPL SITE DELETION INITIATION
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = ND' AND
CP203 = '90' AND
(CP 1201 = 1 or 2 or
3 or '4)
(C305 = 'P or F or R'
or D or S) AND
C2111 = ND AND
(C2132 = '901' or '902' or
903 or 904)
(C305 = P' or 'F or R or
T> or *S') AND
C2111 = ND AND
C2140GE 10/01/89 AND
C2140 LE 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select sites with a targeted
NPL Deletion Initiation
for any fiscal year 1990 quarter
Select sites that are Proposed
Final Removed Deleted or Soon to
be proposed to the NPL that have NPL
Deletion Initiation planned for fiscal
year 1990
Select sites that are Proposed
Final Removed Deleted or Soon to
be proposed to the NPL that have NPL
Deletion Initiation that occured during
fiscal year 1990
E-92
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
NPL REMOYAL FIRST START
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
202 = 'RF AND
>03 = 90 AND
1201 = '5
(C305 = P or F or
T> or S) AND
C2111 = RV AND
(C2115 = A' or 'B or
BLANK) AND
(C2132 = 901' or 902 or
903 or 904')
(C305 = P or F or T>) AND
C2111 = RV AND
(C2117 = RP or F) AND
(C2115 = A or B or
BLANK) AND
C2140GE 10/01/89 AND
C2140LT 10/01/90
"A BASE CERHELP
DATABASE CERCLIS
DATA BASf CERCLIS
t the number of sites targeted
NPL Removal first start for
year 1990
Select sites that are Proposed Final
Deleted or Soon to be proposed
to the NPL that have a Removal
planned to start dunng fiscal year 1990
that will be the first at the site
Select sites that are Proposed Final
or Deleted to the NPL that have a
Removal which started during fiscal
year1990 that w as the first at the site
E-93
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
NPL REMOVAL SUBSEQUENT START
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = SS' AND
CP203 = 90 AND
CPI20I = '5
(C305 = 'P' or T or
D or S ) AND
C2111 = RV AND
(C21I5 = 'C' or T>') AND
(C2132 = '901 or '902 or
•903' or '904')
(C305 = 'P or T or T>') AND
C2111 = RV AND
(C2117 = RP or F) AND
(C21I5 = Cor T>) and
C2140 GE 10/01/89 AND
C2140 LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select the number of sites
targeted for a Removal
subsequent start
Select sites that are Proposed Final
Deleted or Soon to be proposed
to the NPL that have a Removal
planned to start during fiscal year
1990 that will be the first at the site
Select sites that are Proposed Final
or Deleted from the NPL that have
a Removal which started during
fiscal year 1990 and was the first at
the site
E-94
-------
Oj iVER Directive 9200 3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
NPL REMOVAL COMPLETION
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
!P202 = RT AND
(C305 = P ot F or
(C305 = P or 'F
:P203 = '90 AND
T> or'S) AND
or T>) AND
!P1201 = '5
(C2111 = RV' or IR or PR')
(C2111 = RV' or IR' or
(C2133 = 901' or 902' or
'PR) AND
'903 or'904)
C2141 GE 10/01/89AND
C2141 LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
elect the number of sites
Select sites that are Proposed Final
Select sites that are Proposed Final
lrgeted for a NPL Removal
Deleted or Soon to be proposed
or Deleted to the NPL that have a
ompletion for fiscal year 1990
to the NPL that have a Removal
Removal which completed
planned to complete during
during fiscal /ear 1990
fiscal year 1990
E-95
-------
OSWER Directive 9200 3 01C
SELECT LOCfIC
FISCAL YEAR 1990 TARGETS AND NEGOTIATIONS REPORT
NON NPL REMOVAL START
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
:P202 = 'ST AND
(C305 = N or R) AND
(C305 = N or R or S ) AND
:P203 = 90 AND
C2111 = 'RV AND
C2111 = RV AND
:P1201 = 5
(C2132 = 901 or 902 or
C2140 GE 10/01/89 AND
'903' or '904')
C2140LT 10/01/90
ATA BASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
:lect the number of sites with a
Select sites that are not on the NPL
Select sites that are not on the
rgeted Non NPL Removal
that have a Removal planned to start
NPL that have a Removal
ut for fiscal year 1990
during fiscal year 1990
which started during fiscal year 1990
E-96
-------
OSWER Directive 9200 3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
NON-NPL REMOVAL COMPLETION
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
AC COMPLISIIMENT
DATA SELECTION
CRITERIA
2P202 = •FT' AND
(C305 = 'N' or 'R ) AND
(C305 = N or R' or S ) AND
2P203 = '90' AND
(C2111 ='RV or IR
(C2111 = RV or 'IR' or
:P1201 = '5'
or 'PR) AND
PR)AND
C2133 = 901 or 902 or
C2141 GE 10/01/89 AND
'903 or 904)
C2141 LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select the number of sites
Select sites that are not included
Select sites that are not included
targeted for a Non NPL Removal
on the NPL that have a Removal
on the NPL that have a
completion for fiscal year 1990
planned to complete during
Removal which completed
fiscal year 1990
during fiscal year 1990
E-97
-------
OSWER Directive 92003-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RD/RA NEGOTIATION START
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = *ED' AND
CP203 = 90 AND
(CP 1201 = 1 or 2' or 3
or '4')
C135 NE 'Y' AND
(C305 = P or F or *D
or S) AND
C1732 = 'AN' AND
(C1713 = 901 or 902 or
'903' or '904')
C135 NE 'Y' AND
(C305 = P or T or R
or D or 'S ) AND
C1732 = 'AN' AND
C1716GE 10/01/89 AND
C1716LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select the number of sites with a
targeted RD/RA Negotiation
start for any fiscal year
1990 quarter
Select sites that are Proposed, Final
Deleted or Soon to be proposed which
have an RD/RA Negotiation start
planned during fiscal year 1990 The
site cannot be a Federal Facility
Select sites that are Proposed Final
Removed Deleted or Soon to be
proposed to the NPL which have an
RD/RA Negotiation started
during fiscal year 1990 The site
cannot be a Federal Facility
E-98
-------
OSWER Directive 9200 3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RD/RA NEGOTIATION COMPLETION
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
:P202 = CO AND
:P203 = '90 AND
CP1201 = '1 or T or '3'
or '4')
C135 NE Y AND
(C305 = 'P1 or F or T>'
or 'S') AND
C1732 = 'AN AND
(C1715 = 901' or '902 or
903 or 904)
CI 35 NE Y AND
(C305 = P or T or R
or T> or 'S') AND
C1732 = AN AND
C1717 Gi: 10/01/89 AND
C1717Lr 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select the number of sites with a
targeted RD/RA Negotiation
Completion for any fiscal year
1990 quarter
Select sites that are Proposed Final
Deleted or Soon to be proposed which
have an RD/RA Negotiation completion
planned during fiscal year 1990 The site
cannot be a Federal Facility
Select sites th it are Proposed Final
Removed Deleted or Soon to be
proposed to the NPL which have an
RD/RA Negotiation completed
during fiscal year 1990 The site
cannot be a Federal Facility
E 99
-------
OSWER Directive 92003-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
SECTION 107 REMOVAL (PRE-RA1 COST RECOVERY
REFERRAL > S200K
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'SB' AND
CP203 = 90 AND
(CP1201 = 1 or 2 or 3
or 4)
C1732 = *SV AND
[(C2731 contains VM'or
VO or VD) and
not contains 'VA ] AND
C2903 = F AND
C2907GE 200,000 AND
(C1713 = '901 or 902 or
'903 or'904) AND
C1732 = 'SV' AND
[(C2731 contains 'VM* or
VO or VD) and
not contains VA] AND
C2903 = T AND
C2907 GE 200,000 AND
C1716GE 10/01/89 AND
C1716LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select the number of sites with
a targeted Removal Cost
Recovery Action for any fiscal
year 1990 quarter
Select Section 107 litigation
actmtiesplanned to start during fiscal
year 1990 with a Federal Cost
Recovery for Removal RI/FS or RD
greater than $200 000 planned
Select Section 107 litigation
activities which started during fiscal
year 1990 with a Federal Cost
Recovery for Removal RI/FS or RD
greater than $200 000
E-100
-------
OS MER Directive 9200 3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
SECTION 107 REMEDIAL (R\) COST RECOVERY
REFERRAL > S200K
TARGETDATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'SQ AND
CP203 = 90' AND
(CP 1201 = 1 or '2' or 3'
or '4')
C1732 = SV AND
C2731 contains 'VA' AND
C2903 = T AND
C2907 GE 200 000 AND
(C1713 = 901 or 902 or
903' or 904')
C1732 = SV AND
C2731 i ontains 'VA AND
C2903 - 'F AND
C2907 GL 200 000 AND
C1716GE 10/01/89 AND
C1716 LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select the number of sites with a
targeted Remedial Cost Recovery
Action for any fiscal year 1990
quarter
Select Section 107 litigauon
activities planned for fiscal
year 1990 with a Federal Cost
Recovery for Remedial Action
greater than $200 000
Select Section 107 litigauon
activtoesttat started during fiscal
year 1990 with a Federal Cost
Recovery for Remedial Actum
greater than $200 000
E-101
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
COST RECOVERY REFERRAL ACTIONS LESS THAN 200.000
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'RR' AND
CP203 = '90' AND
(CP 1201 = 1 or 2 or 3
or 4)
C1732 = SV' AND
C2903 = 'F AND
C2907 LT 200,000 AND
(C1713 = '901 or '902 or
903 or 904)
C1732 = SV' AND
C2903 = F AND
C2907 LT 200,000 AND
C1716GE 10/01/89 AND
C1716LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select the number of sites with a
targeted Remedial Cost Recovery
Action for any fiscal year 1990
quarter
Select sites that have a Section 107
litigation planned to start during fiscal
year 1990 with a Federal Cost
Recovery for less than $200 000
planned
Select sites that have a Section 107
litigation that started during fiscal
year 1990 with a Federal Cost
Recovery for less than $200 000
E-102
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
ADMINISTRATIVE COST RECOVERY SETTLEMENT
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = AL AND
(C1732 = AV or FI or AC
[C1732 = AV or FI or
CP203 = 90 AND
or UA) AND
AC or (CI732 = 'UA
(CP 1201 = '1 OR 2 OR 3'
C2903 = F AND
ANDCP26NE D AND
OR 4)
(C1715 = 901 or 902 or
CI726 NE H)] AND
903 or 904)
C2903 = F AND
C1717GE 10/01/89 AND
C1717 LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select the number of sites with
Select sites which have a Planned
Select site' that have an
a targeted Administrative Cost
Administrative Cost Recovery
Admimstra ti\ e Cost Recovery
Recovery Settlement for any
Settlement during fiscal year 1990
Settlement dunng fiscal year 1990
fiscal year 1990 quarter
E-103
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
SECTION 106 OR 106/107 CASE RESOLUTION
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'SF AND
CP203 = 90 AND
(CP 1201 = 1 OR 2 OR 3
OR '4')
(C1732 = SX' or CL') AND
(C1715 = 901' or 902' or
'903 or 904)
(C1732 = SX'or CL) AND
C1717 GE 10/01/89 and
C1717LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select the number of sites with
a targeted Section 106 or
106/107 Case Resolution
for any fiscal year 1990 quarter
Select sites that have a planned
Section 106 orl06/107 completion
during fiscal year 1990 that fully
resolves the case
Select sites that have a Section 106
or Combined Section 106/107
litigation completed during fiscal
year 1990
E-104
-------
OSV/ER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
SECTION 107 CASE RESOLUTION
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = SE AND
CP203 = '90' AND
(CP 1201 = '1 or '2 or '3'
or 4)
C1732 = 'SV AND
(C1715 = 901' or '902 or
903'or 904)
C1732 = SV AND
C1717GE 10/01/89 AND
C1717LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select the number of sites with
a targeted Section 107 Case
Resolution for any fiscal
year 1990 quarter
Select sites that have a Section 107
litigation completed during fiscal
year 1990
Select sites that have a Section 107
litigation which completed during
fiscal year 1990
E-105
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
106 REFERRAL FOR RD/RA WITHOUT SETTLEMENT
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = SD' AND
CP203 = 90 AND
(CP 1201 = 1 or 2 or 3
or 4)
(C1732 = 'SX' or 'CL) AND
(C2731 contains RD
or RA) AND
(C1713 = 901 or 902' or
903 or 904)
(C1732 = *SX' or CL) AND
(C2731 contains 'RD
or RA') AND
CI7I6GE 10/01/89 AND
C1716LT 10/01/90
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select the number of sites with a
targeted Section 106 Referrals
for RDor RA Without Settlement
for any fiscal year 1990 quarter
Select sites which have an
Section 106 or Combined 106/107
litigation with RD or RA Remedy
planned during fiscal year 1990
Select sites which have a referred
Section 106 or 106/107 Case
during fiscal year 1990
E-106
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
106 REFERRAL FOR RD/RA WITH SETTLEMENT
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
'CRITERIA
:P202 = ,SW' AND
{[C1732 = CD'and
{(C1731 = CD and
:P203 = '90' AND
(C1713 = 901' or 902 or
C1716GE 10/01/88 and
CP1201 = '1 or 2 or 3'
903 or '904)]
C1716I T 10/01/89
or '4')
or
or
[CI732 = UA' and
[CI732 = 'UA and
(C1715 = 901'or 902 or
C1717GE 10/01/88 and
903'or 904)]}
C1717LT 10/01/89 and
AND
(C1726 -= 'Y' or 'M' or 'J)]}
(C2731 contains RD or RA)
AND
(C2731 contains RD'or RA)
>ATA BASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
ielect the number of sites with a
Selected sites which have a
Selected sites which have an
argeted Section 106 Referrals
Consent Decree with RD or RA
Consent Decree or Administrative
or RD/RA With Settlement for
Remedy planned during fiscal
Order on Consent or Section 106
my fiscal year 1990 quarto1
year 1990
Referral with Settlement or Section
106/107 Referral with Agreement
during fiscal year 1990
E 107
-------
OSWER Directive 9200 3 01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
UNILATERAL ADMINISTRATIVE ORDER «JAO^ FOR RD/RA
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'AO' AND
CP203 = 90 AND
CP1201 = 5
C1732 = TJA AND
(C1715 = 901' or '902' or
903' or '904) AND
(C2731 contains RD or RA)
C1732 = TJA' AND
C1717GE 10/01/89 AND
C1717 LT 10/01/90 AND
(C2731 contains RD or RA)
DATABASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
Select the number of sites with a
targeted Unilateral Order fa-
fiscal year 1990
Select sites that have a Unilateral
Order for Remedial Design or Remedial
Action planned to be issued during
fiscal year 1990
Select sites that have a Unilateral
Administrative Order fey Remedial
Design ex Remedial Action issued
during fiscal year 1990
E 108
-------
OSWER DirecUve 9200 3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
IAG AT FEDERAL FACILITIES
TARGETDATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
2P202 = IS AND
:P203 = 90' AND
CP 1201 = '1 or '2' or 3'
or '4)
CI35 = Y' AND
(C305 = 'P' or 'F or S'
or'D) AND
C1732 = TT AND
(C1715 = '901 or 902' or
903 or 904)
C135 = 'Y'AND
(C305 = P or "F
or T)) AND
C1732 = FI AND
C1717GE 10/01/89 AND
C1717LT 10/01/90
ATA BASE CERHELP
DATABASE CERCLIS
DATABASE CERCLIS
iect the number of sites with
jrgeted Interagency
jreement at a Federal Facility
any fiscal year 1990 quarter
Select Federal Facility sites that
are Proposed Final Deleted or
Soon to be proposed to the NPL
that have an IAG planned to be
signed during fiscal year 1990
Select Federal Facility sites that
are Proposed Final Deleted or
Soon to be proposed to the NPL
that have an IAG that was
referred during fiscal year 1990
E-109
-------
OSWER Directive 9200 3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
NPL SITES ADDRESSED
TARGET DATA
PLANNING DATA
ACCOMPLISHMENT
SELECTION
SELECTION
DATA SELECTION
CRITERIA
CRITERIA
CRITERIA
CP202 = *LA AND
C135 NE 'Y' AND
CP203 = 90 AND
(C2111 = RI" OR 'FS
CP206 = NL AND
or RV) AND
(CP 1201 = '1 or 2 or '3
(C2115 = 'A' OR 'B') AND
or 4)
C2140 GE 10/01/89 AND
C2140LT 10/01/90 AND
C2140 = FIRST C2140
DATABASE CERHELP
DATABASE CERCLIS
Select the number of NPL sites
Select the number fo NPL sites
targeted to be Addressed
Addressed for Fiscal year 1990
for Fiscal year 1990
E-110
-------
OSWER Directive 9200 3 01C
APPENDIX F
CEPP PROGRAM PLANNING REQUIREMENTS
-------
•A* SP
I ^**£7 « UNITED STATES ENVIRONMENTAL PROTECTION AGENCY
3. X\l/X ° WASHINGTON DC 20460
'¦<< PROTt°
KA,\0 \ 0
^ OF F ICE OF
SOLID WASTE AND EMERGENCY RESPONSE
Chemical Emergency Preparedness and Prevention Office
(CFPP)
FY199P SCAP Measures
SCAP 1
Objective To achieve compliance among Federal, State and local
government and industry and to provide public at large with infor-
mation about Title III
Measure Report on number and types of outreach activities which
EPA conducted, sponsored, assisted in developing or participated
in and include number and type of target audience for each
activity
Definition Outreach activities include, but are not limited to
speeches, press releases, newsletters to SFRCs and LEPCs, and
dissemination of informational materials Outreach activities
should emphasize "multiplier" activities whereby the recipient
of the information will initiate further outreach activities
in that particular organization with the goal of reaching
the maximum number of persons possible
SCAP 2
Objective To enhance ability of Federal, State, and local
government and industry officials to effectively plan for and
respond to chemical emergencies
Measure Report number of formal training courses EPA sponsors,
conducts or participates in to improve Federal, State and local
chemical emergency preparedness programs Training courses may
include, but are not limited to Regional First Responder Courses
and 16*) courses
Definition Training activities are formal educational presen-
tations using instructional materials and techniques or exercises
such as table-top or field simulations In-house FPA training
for FPA employees or for EPA contractors will not count towards
meeting this measure
-------
OFPICE OP SOLID WASTE AND EMERGENCY RESPONSE (OSWER)
CHEMICAL EMERGENCY PREPAREDNESS AND PREVENT ION
OFPICE (CEPP)
GENERAL PREPAREDNESS PROGRAMS
PY 1990 SCAP MEASURES AND TARGETS
Program Area Earthquake Preparedness Program
Objective Improve Federal, State and local preparedness and
response to those catastrophic earthquakes which
activate the "Plan for Federal Response to a
Catastrophic Earthquake "
Measure #1 Report on the development and completion of (a)
the Hazardous Materials Annex (ESF #10) to the
multi-agency plan for Federal response to a
catastrophic earthquake for the R« gion; (b)
risk-area specific sub-plans (if appl cable)
(c) planning support provided to othei EPA
Regions, and (d) on planning activity developments
in other ESF's for which EPA must pro/ide support
Frequency Q 1, 2, 3, and 4, by Region
Target Completion of draft Hazmat Annex by [date to be
determined] for Regions I, II, IV-X; ind,
Completion of approved Hazmat Annex b/ [date to be
determined] for Regions I, II, IV-X
and,
Measure #2 Report on participation in th< following
earthquake preparedness activities lexerciaes,
simulation, workshops, planning sessions and
other similar earthquake preparedness activities
involving Federal, State or loca L persons or
governments) <
Frequency Q 1, 2, 3 and 4, by Region
Target Participation in 2 or more such activities during
the FY
-------
2
Progr-ii Area
Ob]ec tive
Measure #1
Frequency
Ta rge t
National Security Emergency Preparedness Program
Improve EPA's preparedness for carrying out its
responsibilities as outlined in E 0 12656 in the
event of a national security emergency event or
exercise
Report on participation in the following National
Security Emergency Preparedness (NSEP) activities
Headquarter1s EPA, FEMA or other agency planning
sessions, workshops, training, or exercises and
on assisting in the development of support
materials (le policy papers, ADP info , etc )
for the Program
Q 1, 2, 3, and 4, by Region
Participation in two or more such activities
during the FY
-------
OFFICE OF SOLID WASTE AND EMERGENCY RESPONSE
FY1990
Program Chemical Emergency preparedness and Prevention Program
OBJECTIVE MEASURE SPMS CODE FRE£
To improve State/local chemical
emergency preparedness and
enhance their response
capabilities
* Report and describe technical assistance activities in CEP-2 Q1»2
which EPA conducted, sponsored, assisted in developing, or
participated
* Report on he status of Title III implementation in each CEP-1 Q2,4
of your States through completion of the Title III State
Status Report
* Report on number of exercises in which EPA provided CEP-3 Q1,2
assistance to or participated in to test a Federal State,
or local plan
* SPMS measures which require Regional targets
-------
OBJECTIVE
MEASURE
SPMS CODE FREQUENCE
) obtain information about the
tuses of chemical accidents,
ifety, and prevention neasurea
iken by facilities as a result
: accidents
Report nunber of Accidental Release Information Program CEP-4
(ARIP) questionnaires sent to facilities having releases
Report on number of chemical safety audits conducted CEP-5
Q1,2,3 4
Q1,2,3,4
SPMS measures which require Regional targets
-------
CEPP DEFINITIONS
SIMULATION EXERCISES are table-top or full-field exercises conducted to test or evaluate a contingency plan Region:
are expected to provide technical or programmatic assistance to other federal agencies, States or communities
to develop the exercise and/or to actively participate m the exercise (e g , exercise leader, evaluator,
facilitator) Exercise development should include EPA involvement throughout the planning process for the exerc
Providing a copy of guidance material does not constitute fulfillment of this requirement The Region must writ<
post-exercise report describing the assistance provided and/or participation in the exercise and the outcome of
exercise This report should be held in the Regional office and made available for Regional Reviews Regional
assistance or participation in testing an internal EPA plan will not _ount towards meeting this measure
TITLE III STATE STATUS REPORT is the questionnaire developed to answer a range of questions on the status of Title I
in each State, including Local Emergency Planning Committee plan submissions, reporting compliance under Title I
Title III State legislation. State Baergency Response Commission funding and staffing, etc The format for this
report was originally distributed to each Region in October 1988 and will continue to be supplied by Headquarter:
If a State in a Region does not provide the information in the Title III State Status Report, a Region can meet
this measure by reporting on the State information available to tha Region and providing a summary of State st-
and progress in Title III implementation The word "State" in th s measure refers to each State and territory ii
the Region
TECHNICAL ASSISTANCE is the provision of expertise to improve preparedness an prevention capabilities and programs
includes both programmatic and scientific assistance This assistance might be delivered through direct
consultation (in the field with the recipient), workshops, or other means It does not include formal training
courses or the provision of equipment
This assistance includes, but is not limited to
assistance in organizing, developing, and implementing preparedness, prevention, or community right-to-know
programs and activities,
assistance in organizing and conducting CEPP-related workshops;
assistance in development and review of emergency plans (including hazards analysis)}
assistance in information management or risk communication
assistance m development ot haz-mat teams
assistance in dispersion modeling and air monitoring
assistance m evaluation or installation of alarm/alerting systems
ACCIDENTAL RELEASE INFORMATION PROGRAM 18 designed to accomplish two basic objectives
a) To focus high-level management attention on facilities having repeated or 'serious' releases, which may
stimulate them to undertake prevention initiatives on their own and
b) To provide EPA with accurate information on the causes of releases and the activities currently underway in
private set-tor to prevent them irom occurring
-------
- 2 -
IGERED RELEASES
ARIP is focusing on releases which are 'serious 1 Currently, the criteria or triggers being utilized to identify
'serious' releases are
o Starting with the fourth release and ending with the tenth release in a twelve-month period
o A release greater than 1,000 lbs for hazardous substances having RQb = 1, 10, or 100 lbs - or a release of
10,000 lbs for hazardous substances having RQs = 1,000 or 5,000 lbs
o Any release resulting in death, injury, or severe environmental damage
o A release of an extrenely hazardous substance above the RQ
ERS/QUESTIONNAIRES
Once a facility has met a trigger, the Region is required to draft a letter combining the authorities of CERCLA
SARA CAA, CWA, & RCRA, send it to the plant manager, along with the questionnaire EPA has developed A copy of the
response must be sent to Headquarters
ITE CHEMICAL AUDIT is an on-site inspection of the entire process/handling operations at a site from a safety
standpoint it is an audit of safety procedures facility equipment, training and contingency planning, as well as
management commitment
-------
OhFlCh Oh SOLID WAS Tb ANU LMLKGhNCV KhSl'ONSh
FY 1990
Emergency Planning and Community Riqht-to-Know Enforcement
OBJECTIVE MEASURE SPMS CODE FREQUEN<
Develop the enforce-
ment program for
Sections 302, 303,
304, 311, and 312
Report the number of
a) Investigations of possible violations
of Section 304
b) Investigations of possible Sections 302,
303, 311, or 312 violations (do not
include if in (a))
C/E-l
Ql. 2,3,4
By State
Report the number of
a) Section 304 violations identified
b) Facilities determined by the Region or
State (and reported to the Region) to
be in violation of Sections 302, 303,
311, or 312 (do not include if in (a))
C/E-2
Ql,2,3,4
By State
Report the number of
a) Administrative Orders
b) Judicial referrals and
c) State orders regarding violations of
Sections 302, 303, 304, 311, and 312
C/E-3
Ql, 2 3,4
By State
Report the number of violators where
- « - —— — 1
<1/ iiiiui mai ui
b) formal enforcement actions by EPA or
State have resulted in non-compllers
returning to compliance
C/E-4
Ql, 2,3 , 4
By State
-------
OSWER Directive 9200 3 01C
APPENDIX G
CASE BUDGET
-------
OSWBR Directive 9200 3 01
APPENDIX G
CASE BUDGET
TABLE OF CONTENTS
FINANCIAL PLANNING REQUIREMENTS G 1
CERCLIS Required Data Elements G 1
CERHELP Required Data Elements G-4
RPO AND IMC COORDINATION G5
AOA Funding G-5
Commitments and Obligations G 6
TES Work Assignment Amounts G-7
OBLIGATING FUNDS TO COVER REGIONAL CONTRACT
PROGRAM MANAGEMENT WORK ASSIGNMENTS G-8
CERHELP Mainframe Coding Instructions G 8
WasteLAN CERHELP Coding Instructions G 8
OBLIGATING FUNDS GENERICALLY TO COVER ALL S/TE
SPECIFIC G 9
Mainframe CERHELP Coding Instructions G 9
WasteLAN CERHELP Coding Instructions G 10
OBLIGATING FUNDS TO COVERCONTRACT
BUYINWORK ASSIGNMENTS G 11
Mainframe CERCLIS Coding Instructions for Site Information F orms G 11
A Remedial Events G 11
B Enforcement Activities G-12
C Non Site Specific Incidents G-13
WasteLAN Coding Instructions G-14
A Remedial Events G 14
B Enforcement Activities G 15
C Non Site Specific Incidents G 15
ENTERING TES WORK ASSIGNMENT AMOUNTS (TASHING)G 15
A Remedial Events G 15
B Enforcement Events G 16
C Non Site Specific Incidents G 16
WasteLAN Coding Instructions G 16
-------
OSWER Directi /e 9200 3 01C
FINANCIAL PLANNING REQUIREMENTS
This section reviews the required CERCLIS data elements In addition, detailed activity-
specific coding instructions are included that address complex coding issues At tmty-specific
financial planning in both the CERCLIS and CERHELP data bases is required to clearly identify
extramural Regional Enforcement funding requirements In order for CERCLIS to accurately
reflect Regional needs, specific coding instructions are necessary This guidance is provided to
assist the Regions in carrying out the Case Budget (CB) strategy and accurately entering into
CERCLIS specific financial plans
The list of enforcement activities and events with their corresponding codes that are funded
with Case Budget appears in Exhibit VI 6 It is important to note that additional coding
requirements exist in order for any of these planned activities to be considered as a Regional
request
CERCLIS Required Data Elements
Component Label
Activity/Event
Type
Event Operable Unit
CERCLIS Data
Elements
AcPvitv/Event
Valid Cast
Budget Codes
C1732/C2111
see Exhibit VI 6
CI 101
2 digit field indicating the
operable urut which
corresponds to the event
Activity/Event
Plan Start FYQ
C1713/C2132
system generated based on
the current planned start date
(C1712/C2130) or 3 digit
code for fiscal year quarter
(YY/Q) entered manually
Activity/Event
Actual Start Date
C1716/C2140
Actual 6 digit start date
(MM/DD/YY)
Activity/Event
Plan Complete FYQ C1715/C2133
system g< nerated based on
the current planned complete
date C1714/C2131 or a 3
digit code far fiscal year
quarter (YY/Q) entered
manually
G 1
-------
OSWER Directive 9200 3 01C
Accurate planned start and planned completion dates are required to identify when CB funds
will be needed Regions should also update these CERCLIS data elements throughout the
planning year as necessary
CERCLIS Data
Elements Valid Case
Component Label Activitv/Event Budget Codes
Activity/Event
Lead C1707/C2 117 FE = Federal Enforcement
SE = State Enforcement
FF = Federal Facility
MR = Mixed Funding
RP = Responsible Party
PS = PRP under State Order
It is important to note that not every lead is valid for each activity For example the only
valid lead for any type of litigation is FE for Federal Enforcement Specific activities and events
therefore require certain leads in order to be considered a valid CB request Exhibit VI 6 shows
the valid CB leads for each activity or event
Activity/Event
Financial Type C2903/C3202 G = Planned Obligation
for an Activity
P = Planned Obligation
for an Event
All events and activities must have one of these financial codes to be considered as a
planned obligation (request) For activities (e g , RP searches, RI/FS negotiations NBARs etc)
the code is 'G For events (e g removals RI/FS, RD/RA etc) the code is P
Activity/Event
Financial Plan FYQ C2905/C3218 3 digit code for fiscal year
quarter (YY/Q)
Regions should be consistent with planned or actual start and completion dates when coding
CB requests for specific quarters in the planned fiscal year For example if an RI/FS is planned to
start in the third quarter CB requests for this activity can not precede the quarter Similarly if a
RI/FS is to be completed in the second quarter requests should not be made in the third or fourth
quarters
G 2
-------
OSWER Directs 9200 3 01C
CERCLIS Data
Elements Valid C ase
Component Label Activitv/Event Budget Codes
Activity/Event
Financial Amount C2907/C3230 9 digit actual dollar amount
request
Proper coding of the planned financial amount is essential to the CB strategy Average
pricing factors have been established for CB funded activities (see Exhibit VI 61 Activities/events
whose duration is one year or less are fully funded (e g, PRP search, negotiations, removal
oversight) Activities/events with a duration exceeding one year are funded qu.irterly (e g RI/FS
oversight Section 106 and 107 litigation)
Activity/Event
Contract Vehicle C2908/C3239 3 digit alpna code followed
by 2 digit numeric code
ARC = Alternate
Remedial
Contract Strategy
CAG = Cooperative
Agreement
ETA = i. (A) Contract
GAN = Gannett
GEO = Geo trans
HKR = Hooker
LAG = Interagency
4 greement
MSC = Multi Site
Cooperative
4 greement
REM = Remedial Planning
ind Construction
TES## = rES Contracts
Regions must complete an entry for the Contract Vehicle (contract mechanism) for each
record where there is a CB request Requests for TES Contracts must indicate ihe TES number
(TES05, TES 11, etc ) Regions should not enter any requests in FY-90 with a contract vehicle of
TES 3 or TES 4
CERCLIS Data
Elements Valid Case
Component Label Activitv/Event Budget Codes
Activity/Event
Funding Status C2909/C3225 APR = Approved
ALT = Alternate
There are activities and events, supporting primary targets, where the application of
standard pricing factors results in a substantial underestimation of required resources due to site
complexity or size The Region must identify requests with a funding status code to identify these
G-3
-------
OSWER Directive 9200 3 01C
activities/events If the request for the activity exceeds the approved budget, two financial records
must be created The first record should contain the amount within the budget with APR in the
financial funding status The second record should contain the amount which exceeds the
allocation with 'ALT as the financial funding status Requests for activities and events supporting
alternate targets should be coded using only the alternate funding status
Budget Source
C2918/C3229
E = Enforcement
The Budget Source field in CERCLIS identifies the program paying for the planned
events/activities It is important that Regions accurately identify the budget source since each
program develops an annual budget and has a separate Advice of Allowance process For Non
TES and TES 5+ contracts, a budget source of E must be assigned Dollars for these activities
are transmitted to each Region in their quarterly AOA
CERHELP Required Data Elements
Component Label
Activity Type
CERHELP Data
Elements
C402
Activity Lead
C404
Valid Case
Budget Codes
see Exhibit VI 6 for specific
funded activities that may be
requested non site
specifically These are
notated by an *
FE = Federal Enforcement
SE = State Enforcement
FF = Federal Facility
MR = Mixed Funding-FE/RP
RP = Responsible Party
PS = PRP under State
Order
Component Label
Financial Vehicle
CERHELP Data
Elements
C1408
Valid Case
Budget Codes
3 digit alpha code followed
by 2 digit numeric code
ARC = Alternate Remedial
Contract Strategy
CAG = Cooperative
Agreement
ETA = 8(A) Contract
GAN = Gannett
GEO = Geo trans
G-4
-------
OSWER Direct 1 /c 9200 3 01C
Financial Planned
Obligation FYQ
Financial Fund
Source
Financial Number
of Sites
Financial Amount
Financial Comment
C1415
C1416
C1417
CI 420
C1421
HKR = Hooker
LAG = Interagency
Agreement
MSC = Vtulti-Site
Cooperative
Agreement
REM = Remedial Planning
and Construction
TES = TI S Contracts
3 digit code for fiscal year
quarter (YY/Q)
E = Enforcement
3 digit code for number of
sites for which non-site
specific n^quest is made
9 digit code for amount
requested
30 charactn field to identify
specific nuquests
RPO AND IMC COORDINATION
This section is a description of the integrated roles and responsibilities RPOs and IMCs
have in tracking the Case Budget AOA commitments and obligations, and TES work assignments
Other personnel may also be involved in planning the Enforcement activities in CERCLIS and
approving TES funding but, since this vanes by Region other roles and responsibilities are not
included in this attachment The following procedures will enable the Regions and Headquarters to
track TES work assignment financial information from TESWATS in CERCLIS to manage their
Case Budgets
AOA Funding
Funding for TES 5-12 contracts and other Enforcement vehicles is provided through the
Regions' AOA Headquarters enters the AOA amounts into CERHELP upon n lease of the AOA
by the Comptroller IMCs can then use CERCLIS to track obligations that draw on AOA funds
Obligations are made, to contracts for example, when Procurement Requests (PR) are sent to
Contracting Officers (CO) and contracts are modified to include the new funds RPOs make sure
that the PRs are committed by their Financial Management Offices before sending them to the CO
RPOs are responsible for reporting each commitment of funds into the TES 5 - ] ? contracts to their
IMCs This can be accomplished by providing a copy of each PR to the IMC at the time it is sent
to the CO Regions and Headquarters will then be able to see the status of the AOA (commitments
obligations and available balance) in CERCLIS, making it easier to confirm the IFMS data.
G-5
-------
OSWER Directive 9200 3 01C
TES work assignments show the amount of money available to the contractor to perform
specified tasks, usually called tasking amounts Tasking amounts arc not obligations but they do
show how the AOA is going to be used to support site activities or events Obligations from the
AOA are made periodically to fund the contracts and pay for the work assignments Obligations
and work assignment amounts will be recorded differently in CERCLIS to separately portray
progress made on obligating funds and tasking assignments to the TES 5-12 contracts The
separation of obligations and tasking amounts will accurately reflect utilization of the AOA and
prevent double counting work assignment amounts as obligations CERCLIS reports, such as the
SCAP 15 will be revised to compare work assignments tasked with planned amounts so as not to
double count TES generic commitments and obligations made in advance to cover planned work
assignments
In budget planning reports the AOA will be equal to the total of non-TES commitments
and obligations, plus TES 5-12 work assignment tasking, plus any Enforcement funded buy-in
work assignments that have their own PRs
Commitments and Obheations
RPOs will submit three types of obligations to the TES 5-12 contracts an obligation for
the amount of the Regional management work assignment obligations to cover the value of
Enforcement program work assignments, and obligations tied directly to single work assignments
to buy into the TES contracts The RPOs will take the PRs to their Superfund Finance Offices to
commit the funds then provide copies of the PRs to their IMCs when the PRs are sent to the COs
for obligation The IMCs will ensure that the data is properly coded to show the commitments in
CERHELP or CERCLIS
In the first type of obligation RPOs will send PRs to the COs to obligate funds to cover the
Regional management work assignments The RPOs will provide copies of the PRs and
CERCLIS coding forms, if necessary to the IMCs The IMCs or their designees, will enter the
PR commitment amounts in CERHELP as Contract Program Management using the coding
guidance included as Attachment 2
In the second type, RPOs will also send in PRs periodically to obligate funds for the value
of work assignments tasked to the contractors These PRs create non-site specific obligations that
will be charged to the site specific work assignments when the contractors' invoices are processed
by EPA RPOs must ensure that enough money is obligated to cover the total value of the work
assignments outstanding at any given time in each fiscal year Again, RPOs will provide copies of
PRs or coding forms to the IMCs for the commitments to be recorded m CERHELP as 'Other'
Coding guidance is mcluded m Attachment 3
The third type of obligation RPOs will make is for TES work assignments that are
submitted with their own funding PRs These work assignments are known as buy-ins RPOs
must record the PR account number in TESWATS in the funding account1 field Superfund site
specific buy ins will have to be properly coded into CERCLIS using the EPA site identification
number, operable unit number, event or enforcement activity type, and funding account number
RPOs will provide copies of PRs, properly coded work assignment forms, or CERCLIS coding
forms to the IMCs for the information to be entered m the appropriate site records Site specific
buy ins will be handled much the same as Remedial contract work assignments have been, except
that the accounting information required to match with IFMS can only be put m the comment field
when PRs are for Enforcement activities Of course non-Superfund buy-ins will not be entered in
CERCLIS
G-6
-------
OSWER Directwe 9200 3 01C
Again, obligations for TES contracts can only be made when PRs are sent to the COs
RPOs are responsible for reporting their commitments to the IMCs by providing them with copies
of PRs or coding forms
TES Work Assignment Amounts
TES work assignment amounts need to go into CERCLIS to show the a(tual costs of
tasking the contractors when planned activities started New CERCLIS reports at.11 be available to
compare total commitments and obligations with total work assignment amount* for TES contracts
to quickly identify any underfunding of the contracts Actual TES work assignment tasking
amounts (rather than commitments and obligations) will be compared to TES pLinned amounts to
show the balance of funds available for remaining TES plans
RPOs need to make sure that every TES 5-12 work assignment and amendment has an
accurate CERCLIS event or enforcement activity Headquarters will make available the
TESWATS transaction report that RPOs can use to audit their Regional data. The event or activity
codes will relate to the appropriate site targets being supported including the rel» /ant sequence
numbers RPOs will describe the funding split in the comment field of TES woi Y assignments that
cover multiple events activities or operable units Regional Enforcement budg< ts are planned in
CERCLIS by event, activity, and operable unit so TES work assignments will show those
planned amounts being used only when the coding is accurate The longer account numbers that
will be used in IFMS (now scheduled for FY91 implementation) will make it possible for the
contractor to invoice separately for each event activity, or operable unit when one work
assignment covers more than one event, etc
It is critical that RPOs put accurate CERCLIS codes for EPA ID number (C101), Operable
Unit number (CI 101), and either Enforcement Activity Type (C1701), Event Type (C2101) or
Non-Site Incident (NSS) in TESWATS RPOs can obtain this CERCLIS information from the
Regional Project Managers Enforcement Program Managers, or IMCs since they routinely use it
to prepare site specific plans IMCs should provide RPOs with CERCLIS reports showing
planned funding, by site for the current year (ENFR-13, for example) so that RPOs will know
what work assignments have an approved funding plan when Regional Project Managers request
contract work CERCLIS planning reports will also show the CERCLIS data that RPOs need to
enter into TESWATS
IMCs will ensure that data from TES work assignments is entered correctly into CERCLIS
until an automated data link between TESWATS and CERCLIS can be proposed developed
tested, approved, and implemented Once the RPOs approve a work assignment, the work
assignment amount can be entered into the financial type (C2903 or C3202) with, the new code
H', for TES Work Assignment Amount (tasking) Reductions in work assignment amounts
(detasking) can be entered with the new code W RPOs will provide copies of properly coded
work assignment forms or CERCLIS coding forms to the IMCs for the amounts to be recorded in
the appropriate site records Additional instructions for coding work assignmeni amounts using
the June system revisions are provided
G 7
-------
OSWER Directive 9200 3 01C
OBLIGATING FUNDS TO COVER REGIONAL CONTRACT PROGRAM
MANAGEMENT WORK ASSIGNMENTS
At the beginning of each fiscal year, RPOs will write work assignments to provide contract
management and administrative support for the contractors' regional offices Funds for these
management work assignments ought to be obligated independently of generic funds that cover site
specific work assignments so that the availability of funds for both lands of work is easy to
determine The split will also provide the unique account number and document control number
combinations required to make the CERCLIS to EFMS data transfer possible
CERHELP Mainframe Coding Instructions
1 Access NSIA Data Maintenance Screen 29
2 Enter region number in C401
3 Enter activity type as 'PM in C402
4 Enter activity name as Contract Program Management' in C403
5 Enter activity lead as FE in C404
6 Enter current fiscal year in C406
7 Enter any activity comment (e g work assignment amount or approved work plan
amount) in C408
8 Enter financial type C in C1404 for a positive commitment or M for a
decommitment (negative amount on PR)
9 Enter the FMS account number (ACN) from the PR in CI405
10 Enter the FMS document control number (DCN) from the PR in C1407
11 Enter 'TES05', 'TES06' etc for the TES contract number in C1408, Contract
Vehicle
12 Enter 2535' in C1413, Object/Subobject Class
13 Enter E for enforcement in C1416, Funding Source
14 Enter the estimated number of sites expected to have TES work assignments during
the fiscal year in C1417
15 Enter the date the Funds Control Clerk signed the PR in C1418
16 Enter the amount from the PR in CI420
17 Enter the six digit work assignment number from the TES work assignment form in
C1411
18 Enter the last two digits of the amendment number from the TES work assignment
forminC1425 (Change request #130)
WasteLAN CERHELP Coding Instructions
1 From Main Menu select CERHELP System
2 Select Non-Site/Incident from CERHELP Program screen
3 Select Modify/View Activitites
4 Enter PM in the Non Site/Incident Activity Code field
5 WasteLAN system generates the current fiscal year, but user
can overwrite the data in this field if desired
If the correct PM activity already exists in WasteLAN, then
proceed with step 6 otherwise do steps 5a - 5e
5a Select Add New Activity
5b Enter 'FE' as the Lead
5c Enter any activity comment desired
5d Select A to add the record.
5e Return to Step 2, above
6 Select the specific activity record needed, e g , PM01
G 8
-------
OSWER Directive 9200 3 01C
7 Select Financial System
8 Choose financial type, 1 e, Option 4 is commitment or
Option 5 is decommitment
9 Select Add New Record
10 Do not enter data into the date or amount fields, unless you have the correct FMS
amount and commitment date in order to
avoid creating duplicate records during the financial
download procedure
11 Enter any activity comments (e g, work assignment amount'
or 'approved work plan amount')
12 Enter the Document Control Number (DCN) from the PR
13 Enter the Account Number (ACN) from the PR
14 Enter 'TES051, 'TES06, etc , for the TES contract number
into the Vehicle field.
15 Enter the six digit (revised from four digits in June) work
assignmemt number in the Work Assignment field
16 Enter the last two digits from the TES work assignment
amendment number into the (new in June) Amendment Number
field
17 Enter 2535 in the Ob Subob Class field
18 Enter the contractor's name in the Contractor field
(optional)
19 Enter 'A' in order to add this financial record to the
database
OBLIGATING FUNDS GENERICALLY TO COVER ALL SITE SPECIFIC
WORK ASSIGNMENTS
RPOs will obligate funds to a non site specific (called generic) account to cover the value of
their site specific work assignments (including fees) each fiscal year The contractors will be paid
by work assignment from the generic PRs by identifying the PR document con xol number and site
specific account number to be charged on their invoices The contracts payment system will
deobligate funds from the generic account, then obligate and outlay the funds from the specific
accounts With future system developments to link EFMS and CERCLIS, CERCLIS will show the
outlay information in site specific records The generic PRs will be entered much the same as
contract program management PRs
Mainframe CF.RHF.LP Coding Instructions
1 Access NSIA Data Maintenance Screen 29
2 Enter region number in C401
3 Enter activity type as OH in C402
4 Enter activity name as Other" in C403
5 Enter activity lead as 'FE' in C404
6 Enter current fiscal year in C406
7 Enter any activity comment (e g, Funds to cover all TES work assignments) in
C408
8 Enter financial type 'C in CI404 for a positive commitment, or 'M for a
decommitment (negative amount on PR)
9 Enter the FMS account number (ACN) from the PR in CI405
10 Enter the FMS document control number (DCN) from the PR i a C1407
G-9
-------
OSWER Directive 9200 3 01C
11 Enter 'TES05', 'TES06 etc for the TES contract number in C1408, Contract
Vehicle
12 Enter'2535 inC1413 Object/Subobject Class
13 Enter 'E for enforcement in C1416, Funding Source
14 Enter the estimated number of sites expected to have TES work assignments during
the fiscal year in C1417
15 Enter the date the Funds Control Cleric signed the PR in C1418
16 Enter the amount from the PR in CI420
17 Enter the six digit work assignment number from the TES work assignment form in
C1411
18 Enter the last two digits of the amendment number from the TES work assignment
form in CI425
WasteLAN CERHELP Coding Instructions
1 From Main Menu select CERHELP System
2 Select Non-Site/Incident from CERHELP Program screen
3 Select Modify/View Activitites
4 Enter OH in the Non Site/Incident Activity Code field
5 WasteLAN system generates the current fiscal year, but user
can overwrite the data in this field if desired
If the correct PM activity already exists in WasteLAN then
proceed with step 6 otherwise do steps 5a - 5e
5a Select Add New Activity
5 b Enter FE as the Lead
5c Enter any activity comment desired
5d Select A to add the record
5e Return to Step 2, above
6 Select the specific activity record needed, e g, OHOl
7 Select Financial System
8 Choose financial type l e, Option 4 is commitment or
Option 5 is decommitmenL
9 Select Add New Record
10 Do not enter data into the date or amount fields, unless you have the correct FMS
amount and commitment date, in order to
avoid creating duplicate records during the financial
download procedure
11 Enter any activity comments (e g work assignment amount'
or approved work plan amount)
12 Enter the Document Control Number (DCN) from the PR
13 Enter the Account Number (ACN) from the PR
14 Enter TES05, 'TES06' etc for the TES contract number
into the Vehicle field
15 Enter the six digit (revised from four digits in June) work
assignmemt number in the Work Assignment field
16 Enter the last two digits from the TES work assignment
amendment number into the (new in June) Amendment Number
field
17 Enter'2535 in the Ob Subob Class field
18 Enter the contractor's name in the Contractor field
(optional)
19 Enter 'A' in order to add this financial record to the
database
G 10
-------
OSWER Directivs 9200 3 01C
OBLIGATING FUNDS TO COVERCONTRACT BUYINWORK ASSIGNMENTS
TES work assignments with accompanying PRs are called buy ins and can be handled
much like REM or ARCS work assignments that always have accompanying PRs However, if
the buy-in is for a CERCLIS enforcement activity, then the enforcement finance J c omment field
(C2910) will have to be used to enter the FMS ACN and DCN from the PR Future linkage of
IFMS and CERCLIS being developed by the enforcement financial work group will enable
downloads of EFMS data to enforcement financial records
Mainframe CERCLIS Coding Instructions for Site Information Forms
(Please refer to attached work assignment form)
I Determine whether the assignment is for a remedial event,enforccment activity or
non-site specific function The event or activity type will be cod id on
the TESWATS form in Item 10A 10B, or 10C, respectively
II Access the appropriate side of the database, remedial site infornution
enforcement site information, or non-site specific information
III At this point, instructions vary between remedial events enforcement activities, and
non-site specific assignments Use part A below for remedial ev< nt coding part B
below for enforcement activity coding and part C below for non site specific
coding
A. Remedial Events
A1 From the work assignment form Item 6 enter the Site Name [American
Creosote] in CI04
A2 From the work assignment form Item 7, enter the EPA ID Number
[LAD000239814] in C101 (The RPO may venfy Site Name and Number
with a CERCLIS Site Alias Location Listing,
report L 4)
A3 From the work assignment form Item 8, use the last two digits to enter the
FMS Site/Spill ID Number [G3] in C315
A4 From the work assignment form, Item 15, enter the RPO as the secondary
regional contact [Karen W ] in C206
A5 From the work assignment form, Item 16, enter the RPO s phone number
[555-1234] in C207
A6 From the work assignment form, Item 12 enter the wort assignment
manager's name [Maria T ] in C2157, Event
Regional Contact
A7 From the work assignment form, Item 13, enter the phone number [555-
1111] in C2158
A8 From the work assignment form, Item 9 enter the operable unit number
[01] in CI 101
A9 From the work assignment form, Item 10A, enter the event type [COl] in
C2101
A10 Enter a new lead for this event, if necessary, based on discussions with the
Regional Project Manager (RPM), in C2117, Event Lead
A11 Enter a new planned start date, if necessary, based on di< cussions with the
Regional Project Manager (RPM), in C2130
A12 Enter a new actual start date, if necessary, based on dis< ussions with the
Regional Project Manager (RPM), in C2140
G-ll
-------
OSWER Directive 9200 3 01C
A13 Enter a new plan complete date if necessary based on discussions with the
Regional Project Manager (RPM), in C2141
A14 The PR amount will be positive or negative For a positive number enter
'C for commitment for a negative number enter M for decommitment, in
C3202, Financial Type
A15 Enter the budget source for the buy-in based on where the PR funds came
from Buy ins will usually come from the
remedial program, R but may be Removal, V' or
Enforcement E Enter the appropriate source code in
C3229, Budget Source
A16 From the PR, or work assignment form Item 4 enter the FMS account
number [9TFA06LLG3] in C3204 FMS ACN
A17 From the PR, enter the FMS document control number in C3203, FMS
DCN
A18 From the PR or work assignment form, Item 11 enter the financial amount
[15000]in C3230
A19 From the PR enter the date the Funds Control Officer signed the PR to
make the EFMS commitment in C3220
A20 From the work assignment form Item 1 enter the TES
contract number [TES09] in C3239 Financial Vehicle
A21 From the work assignment form, Item 5, enter the
contractor's name [PRC] in C3241
A22 From the work assignment form Item 2 enter the work assignment number
[C06002] in C3228
A23 From the work assignment form, Item 3 enter the last two digits of the
amendment number [001] in C3234
Enforcement Activities
B1 From the work assignment form Item 6, enter the Site Name [American
Creosote] in CI04
B2 From the work assignment form, Item 7 enter the EPA ID Number
[LAD000239814] in C101 (The RPO may verify Site Name and Number
may be verified with a CERCLIS Site Alias Location Listing report L 4)
B3 From the work assignment form, Item 8, use the last two digits to enter the
FMS Site/Spill ID Number [G3] in C315
B4 From the work assignment form, Item 10B enter the event type [NS01] in
C1701
B5 Enter a new lead for this event, if necessary, based on discussions with the
Regional Project Manager (RPM) in CI707 Enforcement Event Lead
B6 Enter a new planned start date, if necessary based on discussions with the
Regional Project Manager (RPM), in C1712
B7 Enter a new actual start date if necessary, based on discussions with the
Regional Project Manager (RPM), in C1716
B8 Enter a new plan complete date if necessary, based on discussions with the
Regional Project Manager (RPM), in C1714
B9 From the work assignment form Item 9, enter the operable unit number
[01] in C2733 Remedy Operable Unit Indicator to tie the work assignment
to a particular operable unit(s)
B10 For enforcement activities related to remedial events (negotiations, litigation
support), enter the relevant remedy type in C2731, based on discussions
with the RPM
G 12
-------
OSWER Directive 9200 3 01C
Bll The PR amount will be positive or negative For a positive number, enter
A for obligation, for a negative number, enter D for d<*obligation in
C2903, Financial Type
(Obligation codes must be used because there are no
commitment codes for enforcement financial type)
B12 From the PR, or work assignment form Item 11, enter the financial amount
[15000] in C2907
B13 From the work assignment form, Item 1, enter the TES
contract number [TES09] in C2908 Financial Vehicle
B14 Enter the budget source for the buy-in based on where the PR funds came
from Buy-ins will usually come from the
remedial program, R', but may be Removal, 'V', or
Enforcement, E Enter the appropriate source code in
C2918, Budget Source
B15 From the work assignment form, Item 2 enter the work assignment number
[C06002] in C2919
B16 From the PR or work assignment form Item 4, enter the FMS account
number [9TFA10LLG3] in C2910 Enforcement Financial Note
B17 From the PR, enter the FMS document control number in C2910,
Enforcement Financial Note
B18 From the work assignment form, Item 3, enter the last two digits of the
amendment number [001] in C2922
Afan Site Specific Incidents
C1 Access NSIA Data Maintenance Screen 29
C2 Enter region number in C401
C3 Enter the activity type [OH] in C402
C4 Enter the activity lead if required in C404
C5 Enter current fiscal year in C406
C6 Enter any activity comments in C408
C7 Enter financial type 'C in CI404 for a positive commitment, or M' for a
decommitment (negative amount on PR)
C8 Enter the FMS account number (ACN) from the PR in C1405
C9 Enter the FMS document control number (DCN) from the PR in CI407
C10 Enter TES05', TES06, etc , for the TES contract number in CI408,
Contract Vehicle
CI 1 Enter 2535 in C1413, Object/Subobject Class
C12 Enter the budget source for the buy-m based on where the PR funds came
from Buy-ins will usually come from the
remedial program 'R1, but may be Removal, 'V, or
Enforcement, E Enter the appropriate source code in ( 1416 Funding
Source
C13 Enter the number of sites to be covered by this work assignment in C1417
C14 Enter the date the Funds Control Clerk signed the PR in C1418
C15 Enter the amount from the PR in C1420
C16 Enter the six digit work assignment number from the TES work assignment
form in C1411
C17 Enter the last two digits of the amendment number from the TES work
assignment form in CI425
G-13
-------
OSWER Directive 9200 3 01C
WasteLAN Coding Instructions
Use the TES work assignment form as your data entry source document then identify the
following
site name [Item 6 on work assignment form]
LAN reference number
site spill ID number [Item 8]
RPO [Item 15] for secondary Regional contact
RPO s phone number [Item 16]
Work Assignment Manager (WAM) [Item 12] is event Regional contact
WAM phone number [Item 13]
operable unit [Item 9]
event type activity type, or non site incident
Next, check the event lead, planned start date actual start date and planned complete date
For remedial events follow A below, for enforcement activities follow B below and for
non-site incidents follow C below
A. Remedial Events
Select Remedial system event site operable unit and event sequence Then
choose financial system and the appropriate financial type option
If the user selects commitments or decommitments he/she should enter data for
Budget Source (eg R or 'E)
Work Assignment Number [Item 2]
Document Control Number [from PR]
Account Number [from PR]
Comments (optional)
Adding an actual obligation or deobligation record allows entry of those
elements as well as
Contract Vehicle [ TES using number in Item 1]
Contractor [Item 5]
Object Class 2535
A new field (two digits) will be created by the June revisions for work
assignment amendment number
Do not enter the financial amount or date unless you have the correct FMS
amount and commitment date, in order to prevent duplicate records from being
created during the financial download procedure
\
G-14
-------
OSWER Duectiv 9200 3 01C
B. Enforcement Activities
Identify and enter the remedy type and remedy operable unit, when applicable
Select Enforcement module, activity category, activity type, sire activity
sequence, and financial data
Enter the following
Finacial Type C for commitment, M for decommitment
Amount from the PR (can be entered until financial download
is implemented for Enforcement)
Budget Source (eg, R' or 'E)
Contract Vehicle [TES ' using number from Item 1]
Work Assignment Number [Item 2]
ACN and DCN from the PR into Financial Note - in the 25
character field, use first ten for ACN 1 space, then 6 for
the DCN
A new field (two digits) will be created by the June revisions for work
assignment amendment number
C. Non Site Specific Incidents
Follow the same instructions as for generic obligations
ENTERING TES WORK ASSIGNMENT AMOUNTS
-------
OSWER Directive 9200 3 01C
JL Enforcement Events
B11 The work assignment amount will be positive or negative or a positive number
enter H for work assignment amount for a negative number, enter 'W to
decrease the work assignment amount, in C2903, Financial Type
B12 From the work assignment form Item 11 enter the financial amount [15000] in
C2907
B14 Enter the budget source for Enforcement E in C2918 Budget Source
B16 No data entry required
B17 No data entry required
£L Non-Site Specific Incidents
C7 Enter financial type H in C1404 for a positive work assignment amount or 'W
for a decrease (negative work assignment amount)
C8 No data entry required
C9 No data entry required
C12 Enter the budget source for Enforcement, E m C1416 Funding Source
CI4 From the work assignment form, Item 14, enter the RPO signature date in C1418
C15 From the work assignment form, Item 11, enter the financial amount [15000] in
CI 420
WasteLAN Coding Instructions
Also use the instructions outlined above but change the Financial Type codes to 'H for
positive work assignment amounts (tasking) and W' for negative work assignment amounts
(detasking)
G-16
-------
APPENDIX A FY91 METHODOLOGIES
APPENDIX B APPLICABILITY OF FOIA
APPENDIX C CROSSWALK FOR ENFORCEMENT ACTIVITIES
APPENDIX D DEFINITIONS
APPENDIX E SELECT LOGIC FOR SCAP REPORTS
APPENDIX F CEEP PROGRAM PLANNING REQUIREMENTS
APPENDIX G CODING FOR CASE BUDGET
------- |