-------
OSWER Directive 9200.3-01C
APPENDIX C
CERCLIS CROSSWALK FOR
ENFORCEMENT ACTIVITIES AND REMEDIES
ENFORCEMENT
ACTIVITIES ( C1701)
4. Order Activities (Cont.)
Unilateral
Administrative
Order
5. RP Search/Other
Activities
Non-NPL Removal RP
Search
NPL RP Search
Issue Cost Recovery
Decision Document
Prepare Cost
Documentation Package
6. Settlement Activities
Administrative/
Voluntary Cost Rec.
CERCLIS
Activity
Code
UA
RP
NS
DD
PC
AV
REMEDIES (Sought or Achieved
bv Enforcement Activities) (C2731
- Same as AO on Consent
- N/A
- N/A
- N/A
- N/A
- Cost Recovery Oversight
- Cost Recovery of R A
- Cost Recovery of RD
- Cost Recovery of Removal
- Cost Recovery of RI/FS
)
CERCLIS
Remedy
Code
-
-
-
-
VS
VA
VD
VM
VO
EVENTS (C2101)
CERCLIS
Event
Code
-
-
-
-
-
C-3
-------
APPENDIX C
CERCLIS CROSSWALK FOR
ENFORCEMENT ACTIVITIES AND REMEDIES
OSWER Directive 9200.3-01C
ENFORCEMENT
ACTIVITIES ( C1701)
7. Settlement Activities
(Cont.)
Consent Decree
Federal Interagency
Agreement
Judgement
CERCLIS
Activity
Code
CD
FI
JG
REMEDIES (Sought or Achieved
by Enforcement Activities) (C2731)
- Cost Recovery Oversight
- Cost Recovery of RA
- Cost Recovery of RD
- Cost Recovery of Removal
- Cost Recovery of RI/FS
- 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
Same as Consent Decree,
except no Lien on Property
Same as Consent Decree,
except no Lien on Property
CERCLIS
Remedy
Code
VS
VA
VD
VM
VO
DE
ER
FS
IM
IN
LP
LR
OM
OH
RE
PR
RD
RA
RI
RV
CO
SE
TR
EVENTS (C2101)
CERCLIS
Event
Code
-
-
-
-
-
-
ER
FS
IM
-
-
LR
OM
OH
RE
-
RD
RA
RI
RV
CO
-
TR
C-4
-------
OSWER Directive 9200.3-01C
APPENDIX D
SCAP/SPMS TECHNICAL DEFINITIONS
-------
OSWER 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-l
INTRODUCTION D-l
PA Completions D-l
SI Completions D-l
LSI Starts D-2
Percent SI Candidates Completed D-2
REMEDIAL PROGRAM DEFINITIONS D-4
INTRODUCTION D-4
REMEDIAL INVESTIGATION/FEASIBILITY STUDIES
(RI/FS) D-4
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-ll
RA Start - First, Subsequent, and Final D-ll
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 DOJ 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 Rl/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 D-46
NPL SITES D-46
Expedited Response Action (ERA) D-46
HAZARDOUS SUBSTANCES RELEASE D-47
Hazardous Substances Release Notification D-47
Hazardous Substances Release Investigations D-47
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
-------
OSWER Directive 9200.3-01C
SCAP/SPMS DEFINITIONS FOR TARGETS AND MEASURES
PRE-REMEDIAL 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 process:
• 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 targets 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. Funds for pre-
remedial activities are included in the other remedial AOA.
ACTIVITY: PA Completions
DEFINITION: A preliminary assessment is the first stage of site assessment which
determines whether a site should be recommended for further CERCLA action.
Federal, State, and local government files, geological and hydrological data, and
data concerning site practices are reviewed to complete the PA report.
DEFINITION OF ACCOMPLISHMENT: A PA is complete when the 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-FY90:
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/FIT vs. State PA
completions. Separate commitments are also made for sites which are 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.
ACnvrTY: SI Completions
DEFINITION: The site inspection involves collection of field data from a
hazardous substance site for the purpose of characterizing the magnitude and
severity 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 ithe 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 an; 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.
I
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. m
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-FY90: 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
-------
OSWER Directive 9200.3-01C
PRE-REMEDIAL PROGRAM DEFINITIONS
Candidates
Completed
PLANNING REQUIREMENTS
SPMS COMMITMENT?
SCAP COMMITMENT?
TARGET OR MEASURE?
ANNUAL TARGETS/MEASURES SET?
QUARTERLY TARGETS/MEASURES
SET?
PRIOR
TOFY
PRIOR
TOFY
IF YES, WHEN?
PLANNED SITE SPECIFICALLY?
PRIOR
TOFY
IF YES, WHEN?
WHOLE
SITE
WHOLE
SITE
WHOLE
SITE
WHOLE
SITE
PLANNED ON OPERABLE UNIT
OR WHOLE SITE BASIS?
REPORTED ON COMBINED PROGRAM
LEAD OR ON A PROGRAM SPECIFIC
BASIS?
REPORTED SITE SPECIFICALLY OR IN
NON-SITE PORTION OF CERCLIS?
SITE-
SPECIFIC
SITE-
SPECIFIC
SITE-
SPECIFIC
NON-SITE
SPECIFIC
OTHER
REMEDIAL
OTHER
REMEDIAL
OTHER
REMEDIAL
AOA CATEGORY?
NON-SITE
PLANS
NON-SITE SITE SPEC
PLANS PLANS
BASIS FOR AOA?
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 are 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.
ACnVITY: 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
DEFINITION 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 con tract has been
signed by the contracting officer, an Interagency Agreement has been signed by the
other Federal Agency, or a cooperative agreement has been signed by 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, the 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 RtyFS 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 to DOT or
HQ. If the RI/FS is a PS lead and the site is covered by a State Enforcement
Cooperative Agreement, a Superfund Memorandum of Agreement containing a
schedule for RI/FS work at the site or other EPA/State agreement, credit will be
given on the day the State order is signed by the last appropriate official 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 DOT. 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-FY9Q: In order for a PS lead site to be
included as an accomplishment, EPA and the State must have an agreement 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-FY90:
SPECIAL PLANNING REQUIREMENTS: Commitments iare 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
-------
OSWER Directive 9200.3-01C
c0.2
Z.T*
OS
£*
2*
M 12
33
Q M
M ea
s^
«<^
rt J
^ -M
O M
«•*!
a. S
^1
|1
« V
W E
«.
D-7
-------
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 prior 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.
ACTIVITY: 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 (i.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 LAG 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 thesie 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 appropriate 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
-------
OSWER 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 an 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 RD 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 the 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.
ACnVITY: RD Completions
DEFINITION: An RD is complete when the plans and specifications and, 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 the date that
EPA concurs on or approves and accepts the plans, specifications and RA bid
package.
PRP-fmanced An RD is complete on the date that EPA concurs on or 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
SPMS COMMITMENT?
SCAP COMMITMENT?
TARGET OR MEASURE?
ANNUAL TARGETS/MEASURES SET?
QUARTERLY TARGETS/MEASURES
SET?
IF YES, WHEN?
PLANNED SITE SPECIFICALLY?
IF YES, WHEN?
PLANNED ON OPERABLE UNIT
OR WHOLE SITE BASIS?
REPORTED ON COMBINED PROGRAM
LEAD OR ON A PROGRAM SPECIFIC
BASIS?
REPORTED SITE SPECIFICALLY OR IN
NON-SITE PORTION OF CERCLIS?
AOA CATEGORY?
BASIS FOR AOA?
FIRST RD
START
YES**
YES
TARGET
YES
YES
PRIOR
TOFY
YES
PRIOR
TOFY
OPERABLE
UNIT
COMBINED*
PROGRAM
UEAD
SITE-
SPECIFIC
REMEDIAL
DESIGN
SITE SPEC.
PLANS
SUB. RD
START
YES**
YES
TARGET
YES
YES
PRIOR
TOFY
YES
PRIOR
TOFY
OPERABLE
UNIT
COMBINED*
PROGRAM
LEAD
SITE-
SPECIFIC
REMEDIAL
DESIGN
SITE SPEC.
PLANS
F1INAL RD
START
YES**
YES
TARGET
YES
YES
PRIOR
TOFY
YES
PRIOR
TOFY
OPERABLE
UNIT
COMBINED*
PROGRAM
LEAD
SITE-
SPECIFIC
REMEDIAL
DESIGN
SITE SPEC.
PLANS
COMP- 1
NO 1
YES 1
MEASURE 1
YES U
YES 1
PRIOR if
TOFY U
YES 1
PRIOR 1
TOFY 1
OPERABLE 1
UNIT H
COMBINED H
PROGRAM H
LEAD H
SITE- I
SPECIFIC 1
N/A 1
N/A I
* 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
-------
OSWER 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 reported 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 Rl/FS for the site is 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 been combined,
as have RA and final RA completion.
ACTIVITY: 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, IAG or cooperative agreement is awarded and funds are obligated.
(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 Administrative 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 Enforcement 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 an RA start
based on the date the design package was approved by EPA; 3) Where 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 or 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 die 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, USAGE 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 in 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.
ACTrVTTY: NPL Deletion Initiation
DEFINITION: The deletion process is initiated when performance monitoring of
the completed remedy or remedies for the site has verified the integrity 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
-------
OSWER Directive 9200.3-01C
cn2 I
Of i
v>
Z
>
Z
>
I/I
fl:
HH
a
n
GO
En
3
8
n
o
8
O
H "^
02
•a O
O
o 2
•a O
•nO
E$
&o
a-g
is
O
O
2
02
•a O
•nO
^ 93
• >
15
se
*>
i
w
e
z
HH
H
>M
O
V3
D-14
-------
OSWER Directive 9200.3-01C
D-15
-------
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-critical
and non-time-critical 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 prior 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 FLA 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.
ACnVITY: 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
severity 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
-------
OSWER Directive 9200.3-01C
CHANGES IN DEFINITION FY89 - FY9Q: 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 potential 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 region 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 has 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 began 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 (unilateral 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 made site
specifically prior to the quarter the removal is expected to begin; "to be determined"
sites are allowed. Annual targets for removals arc established in the Targets 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
during the FY. 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.
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 contractor(s) has
demobilized and left the site.
PRP-fmanced 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-FY90:
SPECIAL PLANNING REQUIREMENTS: Measures are 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 CEl^HELP 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-fmanced 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 notice 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
-------
OSWER Directive 9200.3-01C
0
to
JZ
> c
»TPL REMO
VESTIGA1
6
NPL
REMOVAL
SITE COMP.
REM.
COMP
NON-NPL
REM. START
NPL
REM. START
PLANNING REQUIREMENTS
Z
'
z
Q
•
1 SPMS COMMITMENT?
co
CO
S
8
CO
CO
1 SCAP COMMITMENT?
»?
MEASUF
TARGET
EASURE
§
TARGET
TARGET
1 TARGET OR MEASURE?
Z
co
CO
§2
CO
CO
P;
a
CX3
1 ANNUAL TARGETS/MEASURES
0
CO
§
§
'
W
(QUARTERLY TARGETS/MEASUI
SET?
0 ft.
0, H
1 IF YES, WHEN?
§
CO
CO
a
CO
*
*
PLANNED SITE SPECIFICALLY?
PRIOR
TO QUART.
'RIOR
QUART,
0
PRIOR
TO QUART.
PRIOR
TO QUART.
e-
6
WHOLE
SITE
WHOLE
SITE
Se
< to
WHOLE
SITE
WHOLE
SITE
PLANNED ON OPERABLE UNIT
OR WHOLE SITE BASIS?
1
COMBINED
Q
0
O
COMBINED*
COMBINED*
rH Pi
REPORTED ON COMBINED PROC
LEAD OR ON A PROGRAM SPEC
BASIS?
U
SITE-
SPECIF!
SITE-
SPECIFIC
SITE-
ECIFIC
' CU
CO
SITE-
SPECIFIC
SITE-
SPECIFIC
a
£
O £-•
REPORTED SITE SPECIFICALLY
NON-SITE PORTION OF CERCLIS
3l
REMOV
1
^
REMOVAL
REMOVAL
AOA CATEGORY?
U
E
%%
OH <^
^^
r
CO
Z
Z
SITE SPEC.
PLANS &
CONTINGENCY
SITE SPEC.
PLANS &
CONTINGENCY
1 BASIS FOR AOA?
D-19
-------
OSWER Dkective 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; I
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; A
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 period 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. Li instances where there is more than one
PRP and PRPs are likely to receive the Special Notice on different 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 other PRPs, fact
sheets on the site, volumetric ranking of substances at the facility
and a list of the volume and nature of substances contributed 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-FY9Q: 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.l04(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 te 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 ]x>ssible 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-FY9Q:
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.
DEFINITION 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
-------
OSWER 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 CERHELP 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 settlement document.
DEFINITION OF ACCOMPLISHMENT: RI/FS negotiations are started 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: RI/FS negotiations are complete when the region makes 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 notice letter or the schedule
in a general notice letter.
CHANGES IN DEFINITION FY89-FY90:
SPECIAL PLANNING REQUIREMENTS: The activity is planned site-
specifically in CERCLIS.
D-23
-------
OSWER Directive 9200.3-01C
ACTIVITY: Start of RD/RA Negotiations
DEFINITION: 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
RD/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
-------
OSWER 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 completed the
date: 1) An administrative order is signed, 2) A consent decree is referred 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 sites should be
reported.
D-25
-------
OSWER Directive 9200.3-01C
ENFORCEMENT DEFINITIONS
Searches and Negotiations
PLANNING REQUIREMENTS
SPMS COMMITMENT?
SCAP COMMITMENT?
TARGET OR MEASURE?
ANNUAL TARGETS/MEASURES SET?
QUARTERLY TARGETS/MEASURES
SET?
IF YES, WHEN?
PLANNED SITE SPECIFICALLY?
IF YES, WHEN?
PLANNED ON OPERABLE UNIT
OR WHOLE SITE BASIS?
REPORTED ON COMBINED PROGRAM
LEAD OR ON A PROGRAM SPECIFIC
BASIS?
REPORTED SITE SPECIFICALLY OR IN
NON-SITE PORTION OF CERCLIS?
AOA CATEGORY?
BASIS FOR AOA?
PRP t
SEARCH
NO
YES
MEASURE
NO
NO
YES
PRIOR
TOFY
WHOLE
SITE
N/A
SITE-
SPECIFIC
ENFORCE-
MENT
SITE-SPEC.
PLANS
PRP ft
SEARCH
NO
YES
MEASURE
NO
NO
NO
WHOLE
SITE
N/A
SITE-
SPECIFIC
ENFORCE-
MENT
NON-SITE
PLANS
COMPPRP
SEARCH t
NO
YES
MEASURE
NO
NO
YES
PRIOR
TOFY
WHOLE
SITE
N/A
SITE-
SPECMC
N/A
N/A
COMP PRP
SEARCH tt
NO
YES
MEASURE
NO
NO
NO
WHOLE
SITE
N/A
SITE-
SPECIFIC
N/A
N/A
jj$m$S$$3SSS$SSS3fflffifflffl
SEC. 104e
LETTERS
NO
YES
MEASURE
NO
NO
NO
WHOLE
SITE
N/A 1
NON-SITE I
I
N/A 1
N/A I
8§&&&&&&!&8&!!!!m
t NPL SITES
tt NON-NPL SITES
D-26
-------
OSWER Directive 9200.3-01C
i
2 o
S H
u
s
§
TARGET
S2 o
a
O
05
g
i
CO
ri 6
fe jS
CL,
CO
0)
z
LLJ
0)
Z
o
I
<
(0
UJ
W
Q.
o
z
i
i
2 ^
1
u
5
g
§5
W co
§
i
i
CO
a
s
u
J
•
-------
OSWER Directive 9200.3-01C
SETTLEMENTS. REFERRALS AND OVERSIGHT
Following are the settlement, referral and oversight activities iracked 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; I
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(61 Referrals/Order
DEFINITION: Section 104(e) referrals/orders are the enforcement actions taken to I
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 in the same manner as it is for other CERCLA ordexs.)
CHANGES IN DEFINITION FY89-FY90: This is anew 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
-------
OSWER Directive 9200.3-01C
sites where remedial or removal responses are planned or are occuring, 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 FY90.
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 Order. These 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 enter 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 FY90.
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 case 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 concluded 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 were 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-FY9Q: Definition has been updated to
conform with the Sec. 106 case resolution definition.
SPECIAL PLANNING REQUIREMENTS: Commitments are established site
specifically.
ACTTVITY: Cost Recovery Dollars Achieved
DEFINITION: This is the sum of all funds achieved through cost recovery actions.
This includes 1) litigation (upon entry of a judgement); 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; in FY89
SCAP, this activity was titled 'Sec. 107 Cost Recovery Judicial Settlement.1
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 KD,'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 DOT
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 included in this category. Should a target site in this category 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) above will
automatically increase by one.
3) Unilateral Orders: This measure includes all unilateral orders issued for RD/RA.
Orders must compel the PRP to initiate site work. Credit for issuance of the order
is based on the date the Regional Administrator signs the order as recorded in
CERCLIS. If the PRP is in compliance with the order, credit will also be provided
in Category (2) above. Should a target site in 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 in this category
will be decreased by one.
CHANGES IN DEFINITION FY89-FY90: All unilateral orders issued 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 for 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
the region in subsequent years, no credit will be provided for re-referral.
ACnVITY: Cost Recovery Cases Referred to DOJ or HO (>$200K)
DEFINITION: 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 toward 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),
RtyFS or RD equal to or greater than $200K under § 107 of CERCLA. Targets in
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 (i.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 ore-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), Rl/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 (i.e. removals, IRM or ERA without state match, RI/FS, or
RDs) greater than or equal to $200K under § 106/§ 107 of CEKCLA. 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 ladministrative
settlement with PRPs that provides for reimbursement of Fund monies under
section 107 and section 122(h)(l) 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 costs 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. Regions are
constrained to a maximum of one small case referral. Targets are established non-
site specifically.
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
PLANNING REQUIREMENTS COMPILATION ENFORCEMENT
SPMS COMMITMENT?
SCAP COMMITMENT?
TARGET OR MEASURE?
ANNUAL TARGETS/MEASURES SET?
QUARTERLY TARGETS/MEASURES
SET?
IF YES, WHEN?
PLANNED SITE SPECIFICALLY?
IF YES, WHEN?
PLANNED ON OPERABLE UNIT
OR WHOLE SITE BASIS?
OPERABLE
UNIT
OPERABLE
UNIT
REPORTED ON COMBINED PROGRAM
LEAD OR ON A PROGRAM SPECIFIC
BASIS?
REPORTED SITE SPECIFICALLY OR
IN NON-SITE PORTION OF CERCLIS?
SITE-SPECIFIC
ENFORCEMENT
OR OTHER
REMEDIAL
AOA CATEGORY?
ENFORCEMENT
SITE OR NON-
SITE SPECIFIC
PLANS
SITE-SPECIFIC
PLANS
BASIS FOR AOA?
D-34
-------
ENFORCEMENT DEFINITIONS
Settlements, Referrals and Oversight
OSWER Directive 9200.3-01C
PLANNING REQUIREMENTS
SPMS COMMITMENT?
SCAP COMMITMENT?
TARGET OR MEASURE?
ANNUAL TARGETS/MEASURES SET?
QUARTERLY TARGETS/MEASURES
SET?
IF YES, WHEN?
PLANNED SITE SPECIFICALLY?
IF YES, WHEN?
PLANNED ON OPERABLE UNIT
OR WHOLE SITE BASIS?
REPORTED ON COMBINED PROGRAM
LEAD OR ON A PROGRAM SPECIFIC
BASIS?
REPORTED SITE SPECIFICALLY OR IN
NON-SITE PORTION OF CERCLIS?
AOA CATEGORY?
BASIS FOR AOA?
1
NO
YES
TARGET
YES
YES
PRIOR
TOFY
YES
PRIOR
TOFY*
OPERABLE
UNIT
N/A
SITE-
SPECIFIC
ENFORCE-
MENT
SITE SPEC.
PLANS
2
NO
YES
TARGET
YES
YES
PRIOR
TOFY
YES
PRIOR
TOFY*
WHOLE
SITE
N/A
SITE-
SPECIFIC
ENFORCE-
MENT
SITE SPEC.
PLANS
3
NO
YES
TARGET
YES
YES
PRIOR
TOFY
NO
WHOLE
SITE
N/A
SITE-
SPECIFIC
ENFORCE-
MENT
SITE SPEC.
PLANS
4
YES
YES
MEASURE
YES
NO
NO
WHOLE
SITE
N/A
SITE-
SPECIFIC
N/A
N/A
5
YES
NO
MEASURE 1
NO I
NO
NO
WHOLE 1
SITE 1
N/A
SITE-
SPECIFIC 1
N/A
N/A
* "TBD" SITES ARE ALLOWED.
1. S. 106 CASE RESOLUTION
2. S. 107 CASE RESOLUTION
3. SMALL CASE COST RECOVERY AND
ADMINISTRATIVE SETTLEMENTS
4. ADMIN. ORDER FOR REMOVAL ACTIONS
5. COST RECOVERY ACHIEVED
D-35
-------
OSWER Directive 9200.3-01C
ENFORCEMENT DEFINITIONS
Settlements, Referrals and Oversight (Con t.)
PLANNING REQUIREMENTS
SPMS COMMITMENT?
SCAP COMMITMENT?
TARGET OR MEASURE?
ANNUAL TARGETS/MEASURES SET?
QUARTERLY TARGETS/MEASURES
SET?
IF YES, WHEN?
PLANNED SITE SPECIFICALLY?
IF YES, WHEN?
PLANNED ON OPERABLE UNIT
OR WHOLE SITE BASIS?
REPORTED ON COMBINED PROGRAM
LEAD OR ON A PROGRAM SPECIFIC
BASIS?
REPORTED SITE SPECIFICALLY OR IN
NON-SITE PORTION OF CERCLIS?
AOA CATEGORY?
BASIS FOR AOA?
SECTION 107 REFERRAL
PRE-RA ^A&PRE-RA
YES
YES
TARGET
YES
YES
PRIOR
TOFY
YES
PRIOR
TOFY
OPERABLE
UNTT
N/A
SITE-
SPECIFIC
ENFORCE-
MENT
SITE-SPEC.
PLANS
YES
YES
TARGET
YES
YES
PRIOR
TOFY
YES
PRIOR
TOFY
OPERABLE
UNIT
N/A
SITE-
SPECMC
ENFORCE-
MENT
SITE-SPEC.
PLANS
SECTION 106/107 REFERRAL
PRE-RA
YES
YES
MEASURE
YES
YES
PRIOR
TOFY
YES
PRIOR
TOFY
OPERABLE
UNIT
N/A
SITE-
SPECIFIC
ENFORCE-
MENT
SITE-SPEC.
PLANS
IA& PRE-RA
YES
YES
MEASURE
YES
YES
PRIOR
TOFY
YES
PRIOR
TOFY
OPERABLE
UNTT
N/A
SITE-
SPECIFIC
ENFORCE-
MENT
SITE-SPEC.
PLANS
SECTION 106
RD/RAREF/UAC
YES
YES
TARGET
YES
YES
PRIOR
TOFY
YES
PRIOR
TOFY
OPERABLE
UNIT
N/A
SITE-
SPECIFIC
ENFORCE-
MENT
SITE SPEC.
PLANS
D-36
-------
OSWER 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/IAG 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-FY90: Subsequent RI/FS start definition was
added.
SPECIAL PLANNING REQUIREMENTS: First and subsequent RI/FS 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 jointly 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-FY90:
SPECIAL PLANNING REQUIREMENTS: First, subsequent and final RODs are
combined SPMS and SCAP targets.
ACrrVTTY: 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
thelAG.
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.
ACnVITY: RA Starts
DEFINmON: 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.
DEFINITION 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/Interagency Agreements at NPL Sites
DEFINITION: Under § 120 of SARA, Federal Agencies are required to enter into a
Federal Facility Agreement/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 IAG for the Rl/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 requirements;
or 5) A formal referral has been made to the AA SWER for dispute resolution. A
site can only receive credit once under this measure.
CHANGES IN DEFINITION FY89-FY90:
SPECIAL PLANNING 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
-------
OSWER Directive 9200.3-01C
BASIS FOR AOA?
^
z;
I
1
z:
2:
AOA CATEGORY?
Z
^
^
12
2!
2Z
REPORTED SITE SPEC
NON-SITE PORTION C
>fl HH
il
•^3 O
Z
oo
T3 ^
SITE-
SPECIFI
n
00
n
srrE-
SPECIFI
n
IHIDHdS
-HJJS
n
00
Sg
I?
1 REPORTED ON COMB
LEAD OR ON A PROG
RASTS?
TO w
S o
S3
Q8
n 1>
1
2S
12
SZ
i
z
PLANNED ON OPERA
OR WHOLE SITE BAS
53g
-0 f*
tfl
WHOLE
SITE
OPERAB
UNIT
5
OPERABLE
UNIT
OPERAB]
UNIT
-
OPERABl
UNIT
tfl
O
•13
5
IF YES, WHEN?
PRIOR
TOFY
11
II
PRIOR
TOFY
°|
5 ^
•fl S
PLANNED SITE SPEC]
a
P
5
oo
,
i
00
oo
3
00
-o
•fl O
•< X
11
PRIOR
TOFY
PRIOR
TOFY
11
3 §
"s
(QUARTERLY TARGE1
SET?
00
cn
00
m
00
t
g
a
g
00
K
ANNUAL TARGETS/M
P
l>
oo
oo
•j
oo
•<
i
g
oo
$
\ TARGET OR MEASUR
ta
TARGET
TARGE
MnASURE
TARGE"
TAKOfc
-1
-1
£
Ci
El
SCAP COMMITMENT
oo
g
oo
g
oo
r3
oo
SPMS COMMITMENT'
g
oo
g
g
g
2
O
| PLANNING REQUIR!
y
> S2
25 Z
EDFFA/IA
PL SITES
0
FFRI/F
COMP
RA START
POST-SARA
RI/FS
START
tt
H
cn
H
D-40
-------
OSWER Directive 9200.3-01C
OIL SPILL ACTTVTTY 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.
ACTrVTrY: 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 regardless of
how many times an EPA On Scene Coordinator (OSC) or Technical Assistance
Team (TAT) goes back on-scene or how many phases the response entails.
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:
ACnVITY: On-Scene Monitoring of Responses to Oil Spills
DEFINITION: On-scene monitoring occurs when the PRP, State, local authorities
or other party responds and §31 l(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
CWA-FUNDED
OIL SPILLS*
OSM
OIL SPILLS
PLANNING REQUIREMENTS
SPMS COMMITMENT?
SCAP COMMITMENT?
TARGET OR MEASURE?
ANNUAL TARGETS/MEASURES SET?
QUARTERLY TARGETS/MEASURES?
IF YES, WHEN?
PLANNED SITE SPECIFICALLY?
IF YES, WHEN?
PLANNED ON OPERABLE UNIT
OR WHOLE SITE BASIS?
REPORTED ON COMBINED PROGRAM
LEAD OR ON A PROGRAM SPECIFIC
BASIS?
REPORTED SITE SPECIFICALLY OR
IN NON-SITE PORTION OF CERCLIS?
AOA CATEGORY?
BASIS FOR AOA?
' CLEANED UP BY EPA
D-42
-------
OSWER Directive 9200.3-01C
SECTION 2
MISCELLANEOUS DEFINITIONS
-------
OSWER Directive 9200.3-01C
REMEDIAL PROGRAM DEFINITIONS
PROJECT SUPPORT
ACTIVITY: Community Relations
DEFINITION: Community relations are the activities conducted in accordance 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 relations 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 activities 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.
ACnvrTY: Design Assistance
DEFINITION: Design assistance activities are undertaken by USAGE 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 on the pre-
selection list to ascertain interest in project; 4) Develop A/E selection list; and 5)
Tentative selection of A/E firm.
DEFINITION OF ACCOMPLISHMENT: The initiation of design assistance is the
obligation of funds. The completion of design assistance is the start of remedial
design.
CHANGES IN DEFINITION FY89-FY90:
SPECIAL PLANNING REQUIREMENTS: Funds for design assistance should be
obligated prior to the signature of the ROD. 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: Forward Planning
DEFINITION: Forward planning activities are 1) The development of
technical/financial information to support requests for funds for RI/FS activities;
2) The evaluation of the extent and utility of available data and the identification of
D-43
-------
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
-------
OSWER Directive 9200.3-01C
DEFINITION OF ACCOMPLISHMENT: The start of management assistance is
the signature of the Cooperative Agreement by the Regional Administrator 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 assistance 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 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: Operation and Maintenance (O&M)
DEFTNITION: 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 the 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 period specified 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 pan 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 purposes 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 assistance 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
DEFINITION: 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-FY90: I
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: Treatabilitv 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 NCP 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
-------
OSWER Directive 9200.3-01C
DEFINITION OF ACCOMPLISHMENT: An ERA is complete when 1) the
conditions specified in the Action Memorandum are complete, even if the
OSC/RPM determines that additional response work may be necessary; 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
DEFINITION: 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 release 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.
ACnVITY: Hazardous Substances Release Investigations
DEFINITION: A release investigation is the process of collecting field data on an
actual or potential hazardous substance site or spill for the purpose of characterizing
the magnitude and severity 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 CERHELP.
D-47
-------
OSWER Directive 9200.3-01C
ACTrVITY: 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 DEFTNTTTQNS
PRE-REMEDIA L
ACrrVTTY: 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 severity 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
-------
OSWER Directive 9200.3-01C
APPENDIX E
SELECT LOGIC FOR SCAP REPORTS
-------
APPENDIX E
SELECT LOGIC FOR SCAP REPORTS
TABLE OF CONTENTS
SCAP-4 FINANCIAL REPORT
SELECT LOGIC FOR FISCAL YEAR 1990 E-l
SCAP-14 TARGET AND ACCOMPLISHMENTS REPORT
SELECT LOGIC FOR FISCAL YEAR 1990 E-ll
SCAP-16 TARGET AND NEGOTIATIONS REPORT
SELECT LOGIC FOR FISCAL YEAR 1990 E 65
-------
\
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 report
contains two levels of detail. The first is a replica of the SCAP-15. The second contains a
similiar version of the SCAP-3 with the exception that the records displayed are 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 for 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 Logic
The select logic conatined here only pertains to PLANNED OBLIGATIONS for
FY90. It is broken by the PROGRAM ACTIVITY CATEGORIES displayed 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
SUM C1420 WHERE
SELECT LOGIC FOR
CURRENT YEAR
PLANNED OBLIGATIONS
CERCLIS
SUM C3230 WHERE
PA/SI
(C413EQ'PA'or'SI)AND
C1404 EQ 'P AND
C1415 GE '90/Selected
Qtr' AND
C1415LT'911'AND
C1419 EQ 'APR' AND
C1416 EQ 'R'
LSI
C2111EQ'ES'AND
(C2117 EQ'F'or'S'or
'SE1 or 'FE') AND
C3202 EQ 'PT AND
C3218 GE '90/Selected
Qtr' AND
C3218LT'911'AND
C3225 EQ 'APR' AND
C3229 EQ 'R'
RI/FS
C413EQ'FP'AND
C1404 EQ 'P' AND
C1415 GE '90/Selected
Qtr' AND
C1415LE'911'AND
C1419 EQ 'APR' AND
C1416 EQ 'R'
(C2111 EQ 'RI1 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
C3218LT'911'AND
[C3218NOTLT{C2132
orC2140}]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
SUM C1420 WHERE
SELECT LOGIC FOR
CURRENT YEAR
PLANNED OBLIGATIONS
CERCLIS
SUM C3230 WHERE
TREATABILITY
STUDY
C2111EQTS'AND
(C2117EQ'For'S'or
'SE'or'EP') AND
C3202 EQ 'P' AND
C3218 GE '90/Selected
Qtr1 AND
C3218LT'911'AND
[C3218NOTLT{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 'OM1 or
'RM' or TA' or TO1 or
'PN' or 'MS') AND
C1404 EQ 'P1 AND
C1415 GE '90/Selected
Qtr1 AND
C1415LE'9H'AND
C1419 EQ 'APR' AND
C1416 EQ 'R'
^lllEQ'AR'or'AS'or
'CR1 or 'DA' or 'GS1 or
'HA' or 'MA' or 'OM1 or
'RM' or TA' or TO') AND
(C2117EQ'F'or'S'or
'SE1 or 'FE1 or 'EP' or
'RP'or'PS') AND
C3202 EQ 'P' AND
C3218 GE '90/Selected
Qtr'AND
C3218LT'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
SUM C1420 WHERE
SELECT LOGIC FOR
CURRENT YEAR
PLANNED OBLIGATIONS
CERCLIS
SUM C3230 WHERE
TAG
C413EQ'CT'AND
C1404 EQ 'P1 AND
C1415 GE '90/Selected
Qtr'AND
C1415LT'911'AND
C1419EQ'APR'AND
C1416EQ'R'
C2111EQ'TG'AND
(C2117EQ'F'or'S'or
'SE1 or 'FE1 or 'EP or
'RP'or'PS') AND
C3202 EQ 'P1 AND
C3218 GE'90/Selected
Qtr1 AND
C3218LT'911'AND
C3225 EQ 'APR1 AND
C3229 EQ 'R'
CORE
C413EQ'SC'AND
C1404 EQ 'P' AND
C1415 GE '90/Selected
Qtr'AND
C1415LT'911'AND
C1419 EQ 'APR' AND
C1416 EQ 'R'
RPRD
OVERSIGHT
C413 EQ 'RD' AND
C1404 EQ 'P1 AND
C1415 GE '90/Selected
Qtr'AND
C1415LE'911'AND
C1419EQ'APR'AND
C1416EQ-R1
{[C2111 EQ'RD'AND
(C2117 EQ'RP'or'PS')] or
(C2111EQ'RD'and
C2117EQ'MR'and
C3239 NOT CONTAINS
'PRP')} AND
C3202 EQ 'P' AND
C3218 GE'90/Selected
Qtr'AND
C3218LT'911'AND
C3225 EQ 'APR' AND
C3229 EQ 'R1
E-5
-------
OSWER Dkective 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
RP RA
OVERSIGHT
C413 EQ 'RA' AND
C1404 EQ 'P AND
C1415 GE '90/Selected
Qtr' AND
C1415LE'911'AND
C1419EQ'APR'AND
C1416 EQ 'R'
{[C2111EQ'RA'AND
(C2117EQ'RP'or 'PS')] or
(C2111EQ'RA'and
C2117EQ'MR'and
C3239 NOT CONTAINS
'PRP')} AND
C3202 EQ 'P1 AND
C3218 GE '90/Selected
Qtr' AND
C3218LT'9H' AND
C322.5 EQ 'APR' AND
C3229 EQ 'R'
ARCS MGMT
C413 EQ 'PM' AND
C1404 EQ 'P1 AND
C1415 GE '90/Selected
Qtr' AND
C1415LT'9H' AND
C1419 EQ 'APR1 AND
C1416EQ'R'AND
C1408 CONTAINS 'ARC
OTHER
(C413 EQ 'OH' or 'OR') AND
C1404 EQ 'P' AND
C1415 GE '90/Selected
Qtr' AND
C1415LE'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
SE' or 'FE' or 'EP' or
'RP'or'PS') AND
C3202 EQ 'P' AND
C3218 GE'90/Selected
Qtr1 AND
C32]8LT'911'AND
C3225 EQ 'APR1 AND
C3229 EQ 'R1
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
SUM C1420 WHERE
SELECT LOGIC FOR
CURRENT YEAR
PLANNED OBLIGATIONS
CERCLIS
SUM C3230 WHERE
RD
C413 EQ 'RT AND
C1404 EQ 'P' AND
C1415GE'90/Selected
Qtr' AND
C1415LT'9H'AND
C1419 EQ 'APR' AND
C1416EQ'R'
C2111EQ'RD'AND
(C2117EQ'F'or'S'or
'SE' or 'FE' or 'EP') AND
C3202 EQ 'P' AND
C3218 GE '90/Selected
Qtr1 AND
C3218LT'911'AND
[C3218NOTLT{C2132
or C2140}] AND
C3225 EQ 'APR' AND
C3229 EQ 'R'
RA
(C2111 EQ 'RA' or 'LR') AND
(C2117EQ'F'or'S'or
'SE'or'EP') AND
C3202 EQ 'P' AND
C3218 GE '90/Selected
Qtr' AND
C3218LT'911'AND
[C3218NOTLT{C2132
orC2140}]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 'NA1 or 'NP' or
•RC) AND
C1404 EQ 'P' AND
C1415 GE '90/Selected
Qtr' AND
C1415LT'911'AND
C1419 EQ 'APR1 AND
C1416 EQ 'R'
C2111 EQ'RV'AND
C3202 EQ 'P' AND
C3218 GE '90/Selected
Qtr'AND
C3218LT'911'AND
C3225 EQ 'APR' AND
C3229 EQ 'V
REMOVAL
SUPPORT
[C413 EQ 'AU' or 'RE' or
'EZ' or ('RS' and
C1408 NE TAT' and
C1408 ne 'TAZ')] AND
C1404 EQ 'P1 AND
C1415 GE '90/Selected
Qtr'AND
C1415LT'911'AND
C1419 EQ 'APR' AND
C1416EQ'V
(C2111EQ'RC'or'EV'or
'TR') AND
C3202 EQ 'P1 AND
C3218 GE '90/Selected
Qtr1 AND
C3218LT'911'AND
C3223 EQ 'APR1 AND
C3229 EQ 'V
ENFORCEMENT
C413 EQ ANY CODE AND
C1404 EQ 'P' AND
C1415 GE '90/Selected
Qtr' AND
C1415LT'911'AND
C1419EQ'APR'AND
C1416EQ'E'
[C2111 EQ ANY CODE and
(C21L7 EQ 'FE1 or 'RP1 or
'PS') and
C3202 EQ P' and
C3218 GE'90/Selected
Qtr1 and
C3218LT'9irand
C3225 EQ 'APR' and
C3229 EQ '£'] OR
[C1732 EQ ANY CODE and
(C1707 EQ 'FE' or 'SE' or
'FF') and
C2903 EQ 'G' and
C2905 GE '90/Selected
Qtr1 and
C2905LT'911'and
C2909 EQ 'APR' and
C2918 EQ 'E']
E-8
-------
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
HEADQUARTERS
REMEDIAL
C413 EQ ANY CODE AND
C1404 EQ 'P' AND
C1415 GE '90/Selected
Qtr'AND
C1415LT'911'AND
C1419 EQ 'APR1 AND
C1416 EQ 'D1
C2111 EQ ANY CODE AND
C3202 EQ 'P' AND
C3218GE'90/Selected
Qtr'AND
C3218LT'911'AND
C3225 EQ 'APR1 AND
C3229 EQ 'D'
HEADQUARTERS
REMOVAL
[C413 EQ 'NA' or 'NP' or
'RC or 'AU' or 'RE' or
'EZ' or ('RS' and
CMOS NE TAT' and
CMOS ne TAZ')] AND
C1404 EQ 'P' AND
C1415 GE '90/Selected
Qtr1 AND
C1415LT'911'AND
C1419 EQ 'APR' AND
C1416 EQ 'M'
(C2111EQ'RC'or'EV'or
TR' or 'RV') AND
C3202 EQ 'P' AND
C3218 GE '90/Selected
Qtr'AND
C3218LT'911'AND
C3225 EQ 'APR' AND
C3229 EQ 'M'
HEADQUARTERS
ENFORCEMENT
C413 EQ ANY CODE AND
C1404 EQ 'P' AND
C1415 GE '90/Selected
Qtr' AND
C1415LT'911'ANP
C1419EQ'APR'AND
C1416 EQ 'N'
[C2111 EQ ANY CODE and
(C2117EQ'FE'or'RP'or
'PS') and
C3202 EQ 'P' and
C3218GE'90/Selected
Qtr' and
C3218LT'911'and
C3225 EQ 'APR' and
C3229 EQ 'N'] OR
[C1732 EQ ANY CODE and
(C1707 EQ 'FE' or 'SE' or
'FF') 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-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
PRELIMINARY ASSEiSSMENT COMPLETION
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'PA' AND
CP203 = '90' AND
CP206 = 'NL' AND
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: CERHELP
Select the number of sites
targeted for a Preliminary
Assessment completion
for Fiscal year 1990.
C305 NE 'O' AND
C2103 EXISTS AND
C2111 ='PA' AND
(C2117 = 'S'or'F) AND
C2141 = FIRST C2141 AND
C2141 GE 10/01/89 AND
C2141 LT 10/01/90
DATA BASE: CERCLIS
Select sites with a Federal or State
lead Preliminary Assessment
that has been completed during
fiscal year 1990 that is the
first to complete at that site.
E-ll
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
SITE INSPECTION COMPLETION
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'SI' AND
CP203 = '90' AND
CP206 = 'NL1 AND
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: CERHELP
Select the number of sites
targeted for a Site
Inspection completion
for Fiscal year 1990.
C305 NE 'O' AND
C2103 EXISTS AND
C2111 = 'SI' AND
(C2117 = 'S1or'F) AND
C2141 = FIRST C2141 AND
C2141GE 10/01/89 AND
C2141 LT 10/01/90
DATA BASE: CERCLIS
Select sites with a Federal or State
lead Site Inspection
that has been completed during
fiscal year 1990 that is the
first to complete at that site.
E-12
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS 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
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: CERHELP
ect sites with a targeted RI/FS
't start for any fiscal year 1990
liter.
(C305 = 'P or 'F or
'R' or 'D' or 'S') AND
(C2111 = 'RI' or'FS'or
'CO') AND
(C2115 = 'A'or'B') AND
C2110 = 'P'AND
(C2132 = '9011 or '902' or
'903' or '904') AND
{[C2117 = 'EP'or'RP'or
'MR' or 'PS'] or
[(C2117 = 'F'or'S'or
'SE') and
((C3202 = 'P1 and C3218 =
C2132 and C3225 = 'APR') or
C3202 = 'C and C3232
GTO))]}
DATA BASE: CERCLIS
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. 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
(C305 = 'P' or 'F' or
'R' or 'D') AND
(C2111 = 'RT or'FS'or
'CO') AND
(C2115 = 'A' or'B') AND
(C2117 = 'F1 or'S'or'SE'
or 'RP' or 'MR'
or 'EP' or 'PS') AND
C2140GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: CERCLIS
Select sites that are Proposed,
Final, Removed, or Deleted to the
NPL that have a Remedial
Investigation, Feasibility Study, or
Combined RI/FS that started during
fiscal year 1990 and was the first
at the site.
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RI/FS FIRST START (FUND CEILING)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'CS1 AND
CP203 = '90' AND
CP206 = 'NL1 AND
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: CERHELP
Select sites with a targeted RI/FS
first start for any fiscal year 1990
quarter.
(C305 = 'P1 or 'F or
'R' or T)1 or 'S') AND
(C2111 = 'RI' or'FS'or
'CO') AND
(C2115 = 'A1or'B') AND
C2110 = 'P' AND
(C2132 = '901' or '902' or
'903' or '904') AND
{C2117 = EPor
[(C2117 = 'For'S'or
'SE') and
((C3202 = 'F and C3218 =
C2132 and C3225 = 'APR') or
C3202 = 'C and C3232
GTO)]}
DATA BASE: CERCLIS
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 require EPA
funding or are In-House 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 RI/FS
unless there has already been a
commitment made.
E-14
(C305 = 'F or 'F or
'R' or 'D') AND
(C2111 = 'RT or 'FS' or
'CO') AND
(C2115 = 'A' or'B') AND
(C2117 = 'F or'S1 or'SE'
or 'EP') AND
C2140GE 10/01/89 AND
C2140 LT 10/01/90
DATA BASE: CERCLIS
Select sites that are Proposed,
Final, Removed, or Deleted to the
NPL that have a Remedial
Investigation, Feasibility Study, or
Combined RI/FS that started during
fiscal year 1990, was funded by
EPA, or was done In-House,
and was the first at the site.
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND ACCOMPLISHMENTS
REPORT
RI/FS FIRST START (FEDERAL FACILITY)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'CS' AND
CP203 = '90' AND
CP206 = 'FF AND
(CP1201 = Tor Tor
3' or '4')
DATA BASE: CERCLIS
Select sites with a targeted
Federal Facility lead RI/FS
first start for any fiscal year
1990 quarter.
C135 = 'Y'
(C305 = 'P' or 'F or
'R' or 'D') AND
C2110 = 'P'AND
(C2111 = 'RI' or'FS'or
'CO') AND
(C2115 ='A1 or 'B') AND
C2117 = 'FF AND
(C2132 = '901' or '902' or
'903' or '904')
DATA BASE : CERCLIS
Select sites that are Proposed, Final,
Removed, Deleted or Soon to be
proposed to the NPL that have a
Federal Facility lead
Remedial Investigation,
Feasibility Study, or Combined
RI/FS planned to start during
fiscal year 1990 that will bethe
first at the site.
C135 = 'Y1
(C305 = 'P' or 'F' or
'R' or 'D') AND
(C2111 = 'Rl'or'FS'or
'CO') AND
(C2115 = 'A' or'B') AND
C2117 = 'FF'AND
C2140GE 10/01/89 AND
C2 MOLT 10/01/90
DATA BASE: CERCLIS
Select sites that are Proposed,
Final, Removed, or Deleted
to the NPL that have a Federal
Facility lead Remedial
Investigation, Feasability Study,
or Combined RI/ FS that started
during fiscal year 1990 and was
the first start at the site.
E-15
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RI/FS SUBSEQUENT START
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'QC AND
CP203 = '90' AND
CP206 = 'ML' AND
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: CERHELP
Select sites with a targeted RI/FS
subsequent start for any fiscal year
1990 quarter.
(C305 = 'P' or F or
'R1 or T>' or 'S') AND
(C2111 = 'RI' or'FS'or
'CO') AND
(C2115 = 'C'or'D') AND
C2110 = 'P' AND
(C2132 = '901' or '902' or
'903' or '904') AND
{[C2117 = 'EP'or1RP'or
'MR' or 'PS'] or
[(C2117 = 'For'S'or
'SE') and
((C3202 = 'P' and C3218 =
C2132 and C3225 = 'APR') or
C3202 = 'C and C3232
GTO))]}
DATA BASE: CERCLIS
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. 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
(C305 = 'P' or 'F' or
'R' or T>') AND
(C2111 = 'Rl'or'FS'or
'CO') AND
(C2115 = 'C or'D') AND
(C2117 = 'F or 'S1 or 'SE'
or 'RP' or 'MR' or
'EP' or 'PS') AND
C2140GE 10/01/89 AND
C2140 LT 10/01/90
DATA BASE: CERCLIS
Select sites that are Proposed,
Final, Removed, or Deleted
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 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RI/FS SUBSEQUENT START (FUND CEILING)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'QC AND
CP203 = '90' AND
CP206 = 'NL' AND
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: CERHELP
Select sites with a targeted RI/FS
;ubsequent start for any fiscal year
1990 quarter.
(C305 = 'P1 or F or
'Rf or Df or 'S') AND
(C2111 = 'RI' or'FS'or
'CO') AND
(C2115 ='C or'D') AND
C2110 = 'P'AND
(C2132 = '901' or '902' or
'903' or '904') AND
{C2117=EPor
[(C2117 = 'For'S'or
'SE') and
((C3202 = 'P' and C3218 =
C2132 and C3225 = 'APR') or
C3202 = 'C' and C3232
GTO)]}
DATA BASE: CERCLIS
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
require EPA funding 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 RI/FS
unless there has already been a
commitment made.
E-17
(C305 = 'P1 or 'F' or
'R' or 'D') AND
(C2111 ='RF or'FS'or
'CO') AND
(C2115 = 'C or'D') AND
(C2117 ='F or'S'or'SE'
or 'EP') AND
C2140GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: CERCLIS
Select sites that are Proposed,
Final, Removed, or Deleted to
the NPL that have a Remedial
Investigation, Feasibility Study,
or Combined RI/FS that started
during fiscal year 1990, was
funded by EPA, and was a
subsequent at the site.
-------
OSWER Dkective 9200.3-QIC
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND ACCOMPLISHMENTS
REPORT
RI/FS SUBSEQUENT START (FEDERAL FACILITY)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'QC AND
CP203 = '90' AND
CP206 = 'FF AND
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: CERCLIS
Select sites with a targeted
Federal Facility lead RI/FS
subsequent start for any fiscal year
1990 quarter.
C135 = 'Y'
(C305 = 'P1 or 'F or
'R1 or T>' or 'S') AND
C2110 = 'P'AND
(C2111 = 'RI1 or'FS'or
'CO') AND
(C2115 = 'C'or'D') AND
C2117 ='FF AND
(C2132 = '901' or '902' or
'903' or '904')
DATA BASE: CERCLIS
Select sites that are Proposed, Final,
Removed, Deleted or Soon to be
proposed to the NPL that have a
Federal Facility lead
Remedial Investigation,
Feasibility Study, or Combined
RI/FS planned to start during
fiscal year 1990 that will be a
subsequent at the site.
C135 = 'Y'
(C305 = 'P1 or 'F' or
'R' or 'D') AND
(C2111 ='RT or'FS'or
'CO') AND
(C2115 = 'C' or'D') AND
C2117 = 'FF'AND
C2140 GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: CERCLIS
Select sites that are Proposed,
Final, Removed, or Deleted
to the NPL that have a Federal
Facility lead Remedial
Investigation, Feasability Study,
or Combined RI/ FS that started
during fiscal year 1990 and was a
subsequent start at the site.
E-18
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RI/FS FIRST COMPLETION (FIRST ROD)
TARGETDATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'OF AND
CP203 = '90' AND
CP206 = 'NL1 AND
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: CERHELP
elect sites with a targeted first
:ecord of Decision for any fiscal
;ar 1990 quarter.
C135NOT='Y'AND
(C305 = 'P' or 'F
or 'D' or 'S') AND
C2111 = 'RO' AND
(C2116 ='A1 or 'B') AND
(C2117 = 'EP'or 'RP'or'FE'
or 'MR1 or 'PS' or 'F'
or'S'or 'SE')
(C2133 = '901' or '902' or
'903' or '904') AND
DATA BASE: CERCLIS
Select 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.
The site cannot be a Federal Facility.
C135NOT = 'Y'AND
(C305 = 'P' or 'F1
or 'R1 or 'D') AND
C2111 ='RO' AND
(C2116 = 'A'or'B') AND
(C2117 = 'EP'or'RP'or
'FE' or 'MR1 or 'PS'
or'F or'S'or 'SE')
C2141GE 10/01/89 AND
C2141LT 10/01/90 AND
DATA BASE : CERCLIS
Select sites that are Proposed,
Final, Removed or Deleted to
the NPL that have a Record Of
Decision that was signed during
fiscal year 1990 and was the
first at the site. The site cannot
be a Federal Facility.
E-19
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RTFS FIRST COMPLETION (FIRST ROD)
(FEDERAL FACILITY)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'OF AND
CP206 = 'FF AND
CP203 = '90' AND
(CP1201 = 'I1 or '2' or
'3' or '4')
DATA BASE: CERHELP
Select sites with a targeted first
Record of Decision for any fiscal
year 1990 quarter with a
Federal Facility lead.
C135 = 'Y' AND
(C305 = 'P' or T
or 'D' or 'S') AND
C2111 ='RO' AND
(C2116 = 'A1or'B1) AND
(C2117 = 'FE'AND
C2133 = '901' or '902' or
'903' or '904')
DATA BASE: CERCLIS
Select Federal Facility sites that are
Proposed, Final, 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.
C135 = '¥' AND
(C305 = 'P1 or 'F
or 'R' or 'D') AND
C2111 = 'RO' AND
(C2116 = 'A'or'B') AND
(C2117 = 'FE'AND
C2141 GE 10/01/89 AND
C2141 LT 10/01/90
DATA BASE: CERCLIS
Select Federal Facility sites that
are Proposed, Final, Removed
or Deleted to the NPL that
have a Record Of Decision
that was signed during fiscal
year 1990 and was the first
at the site.
E-20
-------
OSWER Directive 9200.3-01 C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RI/FS SUBSEQUENT COMPLETION fSIJBSO ROD)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'OS' AND
CP203 = '90' AND
CP206 = 'NL1 AND
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: CERHELP
Select sites with a targeted
subsequent Record of Decision
for any fiscal year 1990 quarter.
C135 NOT = 'Y1 AND
(C305 = 'P' or 'F
or 'D' or 'S') AND
(C2111 ='RO' AND
(C2116 = 1C'or'D')AND
(C2117 = 'EP'or'RP'or'FE'
or 'MR' or 'PS' or 'F'
or'S'or 'SE')
(C2133 = '901' or '902' or
'903' or '904') AND
DATA BASE: CERCLIS
Select sites that are Proposed,
Final, 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 a subsequent at the site.
The site cannot be a Federal Facility.
C135 NOT = 'Y' AND
(C305 = 'P1 or 'F1
or 'R1 or 'D') AND
(C2111 ='RO' AND
(C2116 ='Cor T>') AND
(C2117 = 'EP'or'RP'or 'FE'
or 'MR1 or 'PS1 or 'F'
or'S'or 'SE')
C2141GE 10/01/89 AND
C2141LT 10/01/90 AND
DATA BASE: CERCLIS
Select sites that are Proposed,
Final, Removed or Deleted to
the NPL that have a Record
of Decision that was signed
during fiscal year 1990 and
was a subsequent at the site.
The site cannot be a Federal
Facility.
E-21
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND ACCOMPLISHMENTS
REPORT
RI/FS SUBSEQUENT COMPLETION (SUBSO ROD)
FEDERAL FACILITY
CP202 = 'OS' AND
CP203 = '90' AND
CP206 = 'FF AND
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: CERHELP
Select sites with a targeted
Federal Facility lead
subsequent Record of Decision
for any fiscal year 1990 quarter.
C135 EQ 'Y' AND(C305 =
'P1 or 'F' or 'R1
or T>' or 'S') AND
C2110 = 'F AND
(C2111 ='RO' AND
(C2116 = 'C'or'D') AND
C2117 = 'FE'AND
(C2133 = '901' or '902' or
'903' or '904')
DATA BASE: CERCLIS
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.
C135EQ'Y'AND
(C305 = 'P' or 'F'
or 'R' or T>' or 'S') AND
(C2111 = 'RO' AND
(C2116 = 'C'or'D') AND
C2117 = 'FE'AND
C2141GE 10/01/89 AND
C2141 LT 10/01/90
DATA BASE: CERCLIS
Select sites that are Proposed,
Final, Removed, Deleted or
Scon 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.
E-22
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RI/FS FINAL COMPLETION (FINAL ROD)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'OD1 AND
CP203 = '90' AND
CP206 = 'ML' AND
(CP1201 = Tor'2'or
'3' or '4')
DATA BASE: CERHELP
Select sites with a targeted final
Record of Decision for any fiscal
year 1990 quarter.
C135 NOT = '¥' AND
(C305 = 'P' or 'F
or 'D1 or 'S') AND
(C2111 ='RO' AND
(C2116 = 'A'or'D') AND
(C2133 = '901' or '902' or
'903' or '904') AND
(C2117 = 'EP1 or'RP'or'FE'
or 'MR' or 'PS' or 'F'
or'S'or 'SE')
DATA BASE: CERCLIS
Select sites that are Proposed, Final,
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
final at the site. The site cannot be
a Federal Facility.
C135NOT = 'Y'AND
(C305 = 'P' or 'F'
or 'R' or 'D') AND
(C2111 = 'RO' AND
(C2116 = 'A'or'D')AND
C2141GE 10/01/89 AND
C2141LT 10/01/90 AND
(C2117 = 'EP'or'RP'or
'FE' or 'MR' or 'PS'
or 'F or 'S' or 'SE' )
DATA BASE: CERCLIS
Select sites that are Proposed,
Final, Removed or Deleted to
the NPL that have a Record
of Decision that was signed
during fiscal year 1990 and was
the final at the site. The site
cannot be a Federal Facility.
E-23
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RI/FS COMPLETION (FS TO PUBLIC)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'RC AND
CP203 = '90' AND
CP206 = 'NL1 AND
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: CERHELP
Select sites with a targeted
Feasability Study to Public for
any fiscal year 1990 quarter.
C135 NOT = 'Y' AND
(C305 = 'P or 'F'
or T>' or 'S') AND
(C2111 ='FS' or'CO') AND
(C2116 = 'A'or'B'
or 'C or T>') AND
(C2117 = 'EP or 'RP'or'FE1
or 'MR1 or 'PS' or 'F'
or'S'or 'SE')AND
C3111 ='CF AND
(C3129 = '901' or '902'
or '903' or '904')
DATA BASE: CERCLIS
Select sites that are Proposed, Final,
Removed or Deleted or Soon to be
Proposed to the NPL that have a
Feasibility Study or Combined RI/FS
planned to be released to the public
during fiscal year 1990. The site
cannot be a Federal Facility.
C135 NOT = T' AND
(C305 = 'P' or 'F1
or 'R' or 'D') AND
(C2111 ='FS'
or' CO') AND
(C2116 = 'A'or'B'
or 'C' or 'D') AND
(C2117 = 'EP or 'RP or
'FE' or 'MR' or 'PS'
or 'F' or 'S' or 'SE' ) AND
C3111 = 'CF AND
C3125 GE 10/01/89 AND
C3125 LT 10/01/90
DATA BASE: CERCLIS
Select sites that are Proposed,
Final, or Deleted to the NPL that
have a Feasibility Study or
Combined RI/FS released to the
public during fiscal year 1990.
The site cannot be a Federal
Facility.
E-24
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RD FIRST START
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'DS' AND
CP203 = '90' AND
CP206 = 'NL' AND
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: CERHELP
Select sites with a targeted
Remedial Design
first start for any fiscal year 1990
quarter.
(C305 = 'P' or 'F' or
'D' or 'S') AND
C2110 = 'P'AND
C2111 ='RD' AND
(C2115 = 'A'or'B') AND
(C2132 = '901'or'902'or
'903' or '904') AND
{[C2117 ='EP'or'RP1 or
'MR' or 'PS'] or
[(C2117 = 'For'S'or
'SE') and
((C3202 = 'P' and C3218 =
C2132 and C3225 = 'APR') or
C3202 = 'C and C3232
GTO))]}
DATA BASE: CERCLIS
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. 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
(C305 = 'P' or 'F'
or 'D')AND
C2111 ='RD' AND
(C2115 = 'A' or'B') AND
(C2117 = For 'S'or 'SE'
or 'RP' or 'MR' or
'EP1 or 'PS') AND
C2140GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: CERCLIS
Select sites that are Proposed,
Final, or Deleted to the NPL that
have a Remedial Design
that started during fiscal year
1990 and was the first at the site.
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RD FIRST START (FUND CEILING)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'DS' AND
CP203 = '90' AND
CP206 = 'NL1 AND
(CP1201 = T or '21 or
'3' or '4')
DATA BASE: CERHELP
Select sites with a targeted
Remedial Design
first start for any fiscal year 1990
quarter.
(C305 = 'P or F or
'D' or 'S') AND
02110 = '?' AND
C2111 ='RD'AND
(C2115 = 'A'or'B') AND
(C2132 = '901'or'902'or
'903' or '904') AND
{C2117=EPor
[(C2117 = 'F'or'S'or
'SE') and
((C3202 = 'P' and C3218 =
C2132 and C3225 = 'APR') or
C3202 = 'C and C3232
GTO)]}
DATA BASE: CERCLIS
Select sites that are Proposed, Final,
Removed, 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 was done In-House
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
(C305 = 'P' or 'F'
or 'D')AND
(C2111 = 'RD' AND
(C2115 = 'A' or'B') AND
(C2117 = 'F' or 'S'
or 'EP' or 'SE') AND
C2140 GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE : CERCLIS
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 done In-
House, and was the first at the site.
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND ACCOMPLISHMENTS
REPORT
RD FIRST START (FEDERAL FACILITY)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'DS' AND
CP203 = '90' AND
CP206 = 'NL' AND
(CP1201 = Tor'2'or
'3' or '4')
DATA BASE: CERHELP
Select sites with a targeted
Remedial Design first
start for any fiscal year 1990
quarter.
C135EQ'Y'AND
(C305 = P1 or 'F or
'D' or 'S') AND
C2110 = 'P'AND
C2111 = 'RD' AND
(C2115 = 'A'or'B1
or BLANK) ANE}
C2117 = 'FF AND
(C2132 = '901' or '902' or
'903' or '904')
DATA BASE: CERCLIS
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.
C135EQ'Y'AND
(C305 = 'P' or 'F1 or 'R'
or 'D')AND
C2111 ='RD' AND
(C2115 = 'A1 or'B'
or BLANK) AND
C2117 = 'FF'AND
C2140GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: CERCLIS
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.
E-27
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RD SUBSEQUENT START
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'QD' AND
CP203 = '90' AND
CP206 = 'NL1 AND
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: CERHELP
Select sites with a targeted
Remedial Design subsequent
start for any fiscal year 1990
quarter.
(C305 = 'P' or 'F or
T>' or 'S') AND
C2110 = 'P'AND
C2111 ='RD' AND
(C2115 = 'CIor'D') AND
(C2132 = '901' or '902' or
'903' or '904') AND
{[C2117 = 'EP'or'RP'or
'MR' or 'PS'] or
[(C2117 = 'F'or'S'or
'SE') and
((C3202 = 'F and C3218 =
C2132 and C3225 = 'APR') or
C3202 = 'C and C3232
GTO))]}
DATA BASE : CERCLIS
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. 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-28
(C305 = 'P' or T'
or 'D')AND
C2111 = 'RD' AND
(C2115 = 'C or'D') AND
(C2117 = 'F or 'S'or 'SE'
or 'RP or 'MR1 or
'EP or 'PS') AND
C2140 GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE : CERCLIS
that are Proposed,
Final, or Deleted to the NPL that
have a Remedial Design
that started during fiscal year
19SO and was a subsequent
start at the site.
-------
OSWER Directive 9200.3-01 C
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
AND
CP203 = '90' AND
CP206 = 'NL' AND
(CP1201 = T or '2' or
'3' or '4')
DATA BASE : CERHELP
Select sites with a targeted
Remedial Design subsequent
start for any fiscal year 1990
quarter.
f or •*<• or
T>' or 'S') AND
C2110 = 'P'AND
C2111 ='RD'AND
(C2115 = 'C'or'D') AND
(C2132 = '901' or '902' or
'903' or '904') AND
{C2117 = EPor
[(C2117 = 'For'S'or
'SE') and
((C3202 = 'P1 and C3218 =
C2132 and C3225 = 'APR') or
C3202 = 'C1 and C3232
GTO)]}
DATA BASE : CERCLIS
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
= 'jf' or 'f
or 'D')AND
(C2111 ='RD' AND
(C2115 = 'C or'D') AND
(C2117 = 'For'S'
or 'EP' or 'SE') AND
C2140GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE : CERCLIS
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
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'QD' AND
CP203 = '90' AND
CP206 = 'FF AND
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: CERHELP
Select sites with a targeted
Federal Faciltiy lead
Remedial Design subsequent
start for any fiscal year 1990
quarter.
C135EQT'AND
(C305 = 'P' or 'F' or
D' or 'S') AND
C2110 = 'P' AND
C2111 ='RD' AND
(C2115 = 'Cor'D') AND
C2117 = 'FF'AND
(C2132 = '901' or '902' or
'903' or '904') AND
DATA BASE: CERCLIS
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.
C135 EQ '¥' AND
(C305 = 'P' or 'F1 or 'D'
AND
C2111 = 'RD' AND
(C2115 = 'C or D') AND
C2117 = 'FF AND
C2140 GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: CERCLIS
Select sites that are Proposed,
Final, 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-30
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS 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
(CP1201 = T or '2' or
'3' or '4')
)ATA BASE: CERHELP
elect sites with a targeted
lemedial Design final start
jr any fiscal year 1990 quarter.
(C305 = 'P' or F or
'D' or 'S') AND
C2110 = 'P' AND
C2111 ='RD'AND
(C2115 = 'A'or'D')AND
(C2132 = '90r or '902'or
'903' or '904') AND
{[C2117 = 'EP'or'RP'or
'MR' or 'PS'] or
[(C2117 = 'F'or'S'or
'SE') and
((C3202 = 'P'andC3218 =
C2132 and C3225 = 'APR') or
C3202 = 'C and C3232
GTO))]}
(C305 = 'P1 or 'F
or 'D')AND
(C2111 = 'RD' AND
(C2115 = 'A' or'D') AND
(C2117 = For'S' or'RP or
'MR' or 'PS1 or 'EP'
or 'SE') AND
C2140 GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: CERCLIS
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.
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
DATA BASE : CERCLIS
Select sites that are Proposed,
Final,or Deleted to the NPL that
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 TARGETS/ACCOMPLISHMENTS REPORT
RA FIRST START (PROGRAM)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'AS' AND
CP206 = 'NU AND
CP203 = '90' AND
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: CERHELP
Select sites with a targeted fund
lead Remedial Action first start
for any fiscal year 1990 quarter.
(C305 = 'P1 or 'F or
or 'D' or 'S') AND
C2110 = 'P' AND
C2111 = 'RA' AND
(C2115 = 'A'or'B') AND
(C2132 = '901' or '902' or
'903' or '904') AND
{[C2117 = 'EP']or
[(C2117 = For'S'or
'SE') and
((C3202 = 'P' and C3218 =
C2132 and C3225 = 'APR') or
C3202 = 'C and C3232
GTO))]}
(C305 = 'F' or 'D') AND
C2111 ='RA' AND
(C2115 = 'A' or'B') AND
(C2117 = 'F'or'S'or
'EP1 or 'SE') AND
C2140GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: CERCLIS
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. 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
DATA BASE : CERCLIS
Select sites that are Final, or Deleted
on the NPL that have a fund lead
Remedial Action that started during
fiscal year 1990 and was the first
at the site.
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RAFIRSl^STARTLfERP)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'AS1 AND
CP206 = 'RP AND
CP203 = '90' AND
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: CERHELP
Select sites with a targeted RP
lead Remedial Action first start
for any fiscal year 1990 quarter.
(C305 = 'P or 'F or 'S') AND
C2110 = 'PAND
C2111 ='RA' AND
(C2115 = 'A'or'B') AND
(C2132 = '901' or '902' or
'903' or '904') AND
(C2117 ='RP or'MR'or
'PS')
DATA BASE: 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' or'F or T>') AND
C2111 = 'RA' AND
(C2115 = 'A' or'B') AND
(C2117 = 'RPor'MR'or
'PS') AND
C2140GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: 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 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
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: CERCLIS
Select sites with a targeted
Federal Facility lead Remedial
Action first start for any fiscal year
1990 quarter.
C135EQ'Y'AND
(C305 = 'F 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')
DATA BASE : CERHELP
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 the
first at the site.
C135EQ'Y'AND
(C305 = 'F' or 'R1 or T>')
AND
C2111 = 'RA' AND
(C2115 = 'A' or'B'or
BLANK) AND
C2117 = 'FF AND
C2140 GE 10/01/89 AND
C2140 LT 10/01/90
DATA BASE: CERCLIS
Select sites that are Proposed, Final,
Deleted that have a Federal Facility lead
Remedial Action that started
during fiscal year 1990 and was the
first ait the site.
E-34
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RA SUBSEQUENT START (PROGRAM)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'QR' AND
CP206 = 'NL1 AND
CP203 = '90' AND
(CP1201 = 'I1 or '21 or
'3' or '4')
DATA BASE: CERHELP
select sites with a targeted fund
ead Remedial Action subsequent
tart for any fiscal year 1990
uarter.
(C305 = 'P or F or 'S') AND
C2110 = 'P'AND
C2111 ='RA' AND
(C2115 = 'Cor'D1)AND
(C2132 = '901'or'902'or
'903' or '904') AND
{[C2117 = 'EP'] or
[(C2117 = 'For'S'or
'SE') and
((C3202 = 'P' and C3218 =
C2132 and C3225 = 'APR') or
C3202 = 'C and C3232
GTO))]}
DATA BASE: CERCLIS
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 a
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
(C305 = 'F' or D1) AND
C2111 ='RA' AND
(C2115 = 'C or'D') AND
(C2117 ='For'S'or
'EP' or 'SE') AND
C2140GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: CERCLIS
Select sites that are Final, or Deleted
on the NPL that have a fund 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 TARGETS/ACCOMPLISHMENTS REPORT
RA SUBSEQUENT START
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'QR' AND
CP206 = 'RP' AND
CP203 = '90' AND
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: CERHELP
Select sites with a targeted RP
lead Remedial Action subsequent
start for any fiscal year 1990 quarter.
C135 = 'Y' AND
(C305 = 'P' or T' or 'S') AND
C2110 = 'P'AND
C2111 = 'RA' AND
(C2115 = 'C'or1D') AND
C2110 = 'P' AND
(C2132 = '901' or '902' or
'903' or '904') AND
(C2117 = 'RP'or'MR'or
'PS')
DATA BASE: 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.
CBS = 'Y1 AND
(C305 = 'P' or'F or 'D') AND
C2111='RA' AND
(C2115 = 'C or'D') AND
(C2117 = 'RP'or'MR'or
'PS') AND
C2140GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: 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 1990 TARGET AND ACCOMPLISHMENTS
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
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: CERCLIS
Select sites with a targeted
Federal Facility lead Remedial
Action subsequent start for any
fiscal year 1990 quarter.
C135EQ'Y'AND
(C305 = 'P' or 'F or 'S') AND
C2110 = 'P'AND
C2111 ='RA' AND
(C2115 = 'C1or'D')AND
C2117 = 'FFAND
(C2132 = '901' or '902' or
'903' or '904')
DATA BASE : CERHELP
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.
C135 EQ 'Y1 AND
(C305= 'For'D')AND
C2111 ='RA' AND
(C2115 = 'C or'D') AND
C2117 = 'FF AND
C2140GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE : CERCLIS
Select sites that are 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 at the site.
E-37
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RA FINAL START (PROGRAM)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'AF AND
CP206 = 'NL' AND
CP203 = '90' AND
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: CERHELP
Select sites with a targeted fund
lead Remedial Action final start
for any fiscal year 1990 quarter.
(C305 = T1 or F or or 'S')
AND
C2110 = 'P'AND
C2111='RA' AND
(C2115 = 'A1or'D1) AND
(C2132 = '901' or '902' or
'903' or '904') AND
{[C2117 = 'EF ] or
[(C2117 = 'F'or'S'or
'SE') and
((C3202 = 'P' and C3218 =
C2132 and C3225 = 'APR') or
C3202 = 'C and C3232
GTO))]}
DATA BASE: CERCLIS
Select sites that are Proposed, Final,
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. 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
(C305= 'For'D')AND
C2111 = 'RA' AND
(C2115 = 'A' or'D') AND
(C2117 = For'S'or
'EP or 'SE1) AND
C2140 GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: CERCLIS
Select sites that are Final, or Deleted
on the NPL that have a fund lead
Remedial Action that started during
fiscal year 1990 and was the final
at the site.
-------
OSWER Directive 9200.3-01 C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RA FINAL START (PRP)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'AF AND
CP206 = 'RP1 AND
CP203 = '90' AND
(CP1201 = T or '2' or
'3' or '4')
(C305 = 'F or 'F or 'S') AND
C2110 = 'FAND
C2111 ='RA' AND
(C2115 = 'A'or'DI) AND
(C2132 = '901' or '902' or
'903' or '904') AND
(C2117 = 'RP'or'MR1 or
'PS')
DATA BASE: CERHELP
Select sites with a targeted RP
lead Remedial Action final start
for any fiscal year 1990 quarter.
DATA BASE: 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
final at the site.
(C305 = 'P or 'F1 or 'D') AND
C2111 = 'RA' AND
(C2115 = 'A' or'D') AND
(C2117 = 'RP'or'MR'or
'PS') AND
C2140GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE : 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 the
final at the site.
E-39
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
POST-SARA RA START
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'SA' AND
CP203 = '90' AND
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: CERHELP
Select sites with a targeted
Post-SARA first Remedial
Action for any Fiscal year
1990 quarter.
(C305 = 'P1 or F or 'S') AND
C2111 = 'RA' AND
(C2115 = 'A'or1B1) AND
C3111 = 'ACAND
[(C3125 GE 10/16/86 AND
LE 10/16/90) or (C3125 Fails
and C3129 Spans Current
Quarter to 904)] AND
(C2140 EXISTS or
C2110 = 'P')
DATA BASE: CERCLIS
Select sites that are Proposed, Final,
or Soon to be proposed to
the NPL that have a Post-SARA
Remedial Action planned to start
prior to fiscal year 1990 that will be
the first at the site. There must be a
Contract Award subevent with an
actual completion date or an FY90
planned completion date.
E-40
(C305 = T'or 'D') AND
C2111 = 'RA' AND
(C2115 = 1A'or'B1) AND
C3111 = 'ACAND
C3125 GE 10/16/86 AND
C3125 LE 10/16/90 AND
[(C2117EQ 'RP'or'MR1
or 'PS') AND
C305 = 'P']
DATA BASE: CERCLIS
Select sites that are Final, or Deleted
on 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 TARGETS/ACCOMPLISHMENTS REPORT
RA FINAL COMPLETION
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'FRf AND
CP203 = '90' AND
CP206 = 'NL1 AND
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: 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'D') AND
(C2117 = 'For 'S'or 'RP
or 'MR' or 'SB' or
'PS' or'EP')AND
(C2133 = '901' or '902' or
'903' or '904') AND
(C2140 EXISTS or
C2110 = 'P')
DATA BASE: CERCLIS
Select sites that are Proposed, Final,
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.
(C305= 'F'or'D')AND
C2111 = 'RA' AND
(C2116 = 'A' or D1) AND
(C2117 = 'For 'S'or'RP'
or 'SE' or 'MR'
or 'PS1 or 'EP')
AND C2141 GE 10/01/89
AND C2141 LT 10/01/90
DATA BASE : CERCLIS
Select sites that are Proposed,
Final, Deleted 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
NPL SITE DELETION INITIATION
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'ND' AND
CP203 = '90' AND
(CP1201 = T or '2' or
'3' or '4')
(C305 = F or 'D') AND
C2111 = 'ND1 AND
(C2117 = F or'FE') AND
(C2132 ='901'or'902'or
'903' or '904') AND
C2110 = 'P'
(C305 = F or T>') AND
C2111 = 'NDt AND
(C2117 = F or 'FE') AND
C2140 GE 10/01/89 AND
C2140LE 10/01/90
DATA BASE: CERHELP
Select sites with a targeted
NPL Deletion Initiation
for any fiscal year 1990 quarter.
DATA BASE: CERCLIS
Select sites with a Federal or
Federal Enforcement lead NPL
Deletion Initiation planned for fiscal
year 1990.
DATA BASE: CERCLIS
Select sites with a Federal or
Federal Enforcement lead NPL
Deletion Initiation that occured during
fiscal year 1990.
E-42
-------
OSWER 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
DATA SELECTION
CRITERIA
CP202 = 'RF AND
CP203 = '90' AND
CP1201 = '5'
ATA BASE: CERHELP
lect the number of sites targeted
• a NPL Removal first start for
cal year 1990.
(C305 = P1 or 'F or
T>' or 'S') AND
C2111 = 'RVt AND
(C2115 = 'A1or'Bt) AND
C2110 = 'P'AND
(C2132 = '901' or '902' or
'903' or '904') AND
{C2117 = 'RP'or
[C2117 = 'Fand
((C3202 = 'P' and C3218 =
C2132 and C3225 = 'APR') or
C3202 = 'C and C3232
GTO)]}
(C305 = 'P1 or 'F1 or T>') AND
C2111 = 'RV AND
(C2117 = 'RP'or'F) AND
(C2115 = 'A1or'B1) AND
C2140 GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: CERCLIS
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.
DATA BASE: CERCLIS
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/ACCOMPLISHMENTS 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'
DATA BASE: CERHELP
Select the number of sites
targeted for a fund financed
Removal first start.
(C305 = 'P' or 'F or
'D1 or'S') AND
C2111 = 'RVI AND
(C2115 = 'A'or'B1) AND
C2110 = 'P1 AND
(C2132 = '901' or '902' or
'903' or '904') AND
[C2117 = 'Fand
((C3202 = 'P' and C3218 =
C2132 and C3225 = 'APR') or
C3202 = 'C and C3232
GTO)]
DATA BASE: CERCLIS
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.
(C305 = 'P' or 'F' or 'D') AND
C2111 = 'RV AND
C2117 = 'FAND
(C2115 = 'A'or'B') AND
C2140 GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: CERCLIS
Select sites that are Proposed, Final,
or Deleted to the NPL that have
a Fund-Financed Removal which
startedduring fiscal year 1990 and
was the first at the site.
E-44
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
NPL REMOVAL SUBSEQUENT START
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'SS' AND
CP203 = '90' AND
CP1201 = '5'
DATA BASE: CERHELP
Select the number of sites
targeted for a Removal
subsequent start.
(C305 = 'P' or F or
'D' or 'S') AND
C2111 = 'RVI AND
(C2115 = 'C'or'D')AND
C2110 = 'P' AND
(C2132 = '901' or '902' or
'903' or '904') AND
{C2117 = 'RP'or
[C2117 = 'F'and
((C3202 = 'P'andC3218 =
C2132 and C3225 = 'APR') or
C3202 = 'C and C3232
GTO)]}
(C305 = 'P' or F or 'D') AND
C2111 ='RV AND
(C2117 = 'RP1orF) AND
(C2115 = IC'orT))AND
C2140 GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: CERCLIS
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.
DATA BASE: CERCLIS
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.
E-45
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
NPL REMOVAL SUBSEQUENT START (FUND CEILING)
TARGET DAT A
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP210 WHERE
CP202 = 'SS' AND
CP203 = '90' AND
CP1201 = '5'
DATA BASE: CERHELP
Select the number of sites
with a targeted Fund- financed
NPL Removal subsequent
start for any fiscal year 1990
quarter.
(C305 = 'P or F or
T>' or 'S') AND
C2111='RV' AND
(C2115 = 1C'or1D1) AND
C2110 = 'P'AND
(C2132 = '901' or '902' or
'903' or '904') AND
[C2117 = 'Fand
((C3202 = 'P1 and C3218 =
C2132 and C3225 = 'APR') or
C3202 = 'C and C3232
GTO)]
(C303 = 'P' or 'F' or T>') AND
C2111 ='RV AND
C2117 = F AND
(C2ll5 = 'C'or'D')and
C2140GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: CERCLIS
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 was a
subsequent. These projects 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.
DATA BASE: CERCLIS
Select sites that are Proposed, Final,
or Deleted to the NPL that have a Fund-
Financed Removal which started
during fiscal year 1990 that was a
subsequent at the site.
E-46
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
NPL REMOVAL COMPLETION
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'RT' AND
CP203 = '90' AND
CP1201 = '5'
DATA BASE: CERHELP
Select the number of sites
argeted for a NPL Removal
:ompletion for fiscal year 1990.
(C305 = 'P or (F or
'D' or'S') AND
(C2111 = 'RV or'IR'or'PR')
AND (C2116 = 'A' or 'B' or 'C
or 'D') AND
(C2117 ='For 'RP'or
'CG') AND
(C2133 = '901' or '902' or
'903' or '904') AND
(C2140 EXISTS or
C2110 = 'P')
DATA BASE: CERCLIS
Select sites that are Proposed, Final,
Deleted or Soon to be proposed
to the NPL that have a Removal
planned to complete during
fiscal year 1990.
(C305 = 'P1 or 'F
or 'D') AND
(C2111 ='RV or'IR'or
'PR') AND
(C2116 = 'A'or'B'or
'C or 'D1) AND
(C2117 ='For'RP'or
'CG') AND
C2141 GE 10/01/89 AND
C2141 LT 10/01/90
DATA BASE: CERCLIS
Select sites that are Proposed, Final,
or Deleted to the NPL that have a
Removal which completed
during fiscal year 1990.
E-47
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
NON-NPL REMOVAL START
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'ST' AND
CP203 = '90' AND
CP1201 = '5'
DATA BASE: CERHELP
Select the number of sites with a
targeted Non - NPL Removal
start for fiscal year 1990.
(C305 = 'N1 or 'R1) AND
C2110 = 'P'AND
C2111 = 'RVt AND
(C2115 = 1A'or'B1or
'C or T>') AND
(C2132 = '901' or '902' or
'903' or '904') AND
{(C2117 = 1RP'or'CG1)or
[C2117 = Fand
((C3202 = 'P and C3218 =
C2132 and C3225 = 'APR') or
C3202 = 'C' and C3232
GTO)]}
DATA BASE: CERCLIS
Select sites that are not on the NPL
that have a Removal planned to start
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.
(C305 = 'N1 or 'R1 or
'S') AND
C2111 = 'RV' AND
(C2115 = 1A'or'B'or
'C1 or T>') AND
CC2117 = 'RP1or'For
'CG') AND
C2140 GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: CERCLIS
Select sites that are not on the
NPL that have a Removal
which started during fiscal year 1990.
E-48
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
NON-NPL REMOVAL START (FUND CEILING)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP210 WHERE
CP202 = 'ST AND
CP203 = '90' AND
CP1201 = '5'
DATA BASE: CERHELP
Select thenumber of sites
with a targeted Fund- financed
sfon-NPL Removal start for any
iscal year 1990 quarter.
(C305 = 'N1 or 'R') AND
C2111 = fRV' AND
C2110 = 'P' AND
(C2115 = 1A'or'B1or
'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
GTO)]
(C305 = 'N' or 'R1 or 'S') AND
C2111 = 'RV' AND
(C2115 = 'A'or'B'or
'C' or T>') AND
(C2117 = 'For'CG1) AND
C2140 GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: CERCLIS
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 for the
Removal unless there has already
been a commitment made.
DATA BASE: CERCLIS
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
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'FT AND
CP203 = '90' AND
CP1201 = '5'
(C305 = 'N' or 'R') AND
(C2111 = 'RV'or 1R'
or 'PR') AND
(C2116 = 'A'or'Btor'C1
or T>') AND
(C2117 = IFor'RP'or
'CG') AND
(C2133 = '901' or '902' or
'903' or '904') AND
(C2140 EXISTS or
C2110 = 'P)
(C305 = 'N' or 'R1 or 'S') AND
(C2L11 = 'RV or 'IR' or
'PR') AND
(C2L16 = 1A'or'B'or
C' or 'D1) AND
(C2117 = 'For'RP'or
'CG') AND
C2141 GE 10/01/89 AND
C2141 LT 10/01/90
DATA BASE: CERHELP
Select the number of sites
targeted for a Non- NPL Removal
completion for fiscal year 1990.
DATA BASE : CERCLIS
Select sites that are not included
on the NPL that have a Removal
planned to complete during
fiscal year 1990.
DATA BASE: CERCLIS
Select sites that are not included
on the NPL that have a
Removal which completed
during fiscal year 1990.
E-50
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND ACCOMPLISHMENTS
REPORT
RD/RA NEGOTIATION START
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'ED' AND
CP203 = '90' AND
(CP1201 = '1 or '2' or '3'
or '4')
C135 NE '¥' AND
(C305 = 'P or F or 'D'
or'S') AND
C1725 = 'P'
C1707 = 'FE' AND
C1732 = 'AN' AND
(C1713 = '901' or '902' or
'903' or '904')
DATA BASE: CERHELP
Select the number of sites with a
targeted RD/RA Negotiation
start for any fiscal year
1990 quarter.
DATA BASE: CERCLIS
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.
C135 NE '¥' AND
(C305 = 'P' or 'F or 'R'
or 'D' or 'S') AND
C1707 = 'FE' AND
C1732 = 'AN' AND
C1716GE 10/01/89 AND
C1716LT 10/01/90
DATA BASE: CERCLIS
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-51
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
RD/RA NEGOTIATION COMPLETION
TARGET DAT A
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'CO' AND
CP203 = W AND
(CP1201 = '1 or '2' or '3'
or '4')
(C305 = 'P1 or 'F or T>'
or'S') AND
C135 NE '¥'
C1732 = 'AN' AND
(C1715 = '901' or '902' or
'903' or '904') AND
C1725 = 'P1
(C305 = 'P1 or 'F
or 'D') AND
C135 NE 'Y1
C1732 = 'AN' AND
C1717 GE 10/01/89 AND
C1717 LT 10/01/90
DATA BASE: CERHELP
Select the number of sites with a
targeted RD/RA Negotiation
Completion for any fiscal year
1990 quarter.
DATA BASE: CERCLIS
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.
DATA BASE: CERCLIS
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 fPRE-RA) COST RECOVERY REFERRAL
GREATER THAN 200.000
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')
DATA BASE: CERHELP
Select the number of sites with
a targeted Removal Cost
Recovery Action for any fiscal
year 1990 quarter.
C1732 = 'SV AND
[(C2731 contains'VM1 or
'VO'or'VD') and
not contains'VA'] AND
C2903 = 'F AND
C2907GE 200,000 AND
C1707 = 'FE' AND
(C1713 = '901' or '902' or
'903' or '904') AND
C1725 = 'P'
DATA BASE: CERCLIS
Select Section 107 litigation activities
planned to start during fiscal year 1990
with a Federal Cost Recovery for
Removal, RI/FS or RD greater than
$200,000 planned.
C1732 = 'SV AND
[(C2731 contains 'VM1 or
'VO'or'VD') and
not contains'VA'] AND
C2903 = 'F AND
C2907 GE 200,000 AND
C1707 = 'FE1 AND
C1716GE 10/01/89 AND
C1716LT 10/01/90
DATA BASE: CERCLIS
Select Section 107 litigation which
started during fiscal year 1990 with
a Federal Cost Recovery for
Removal, RI/FS, or RD greater
than $200,000.
E-53
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
SECTION 107 REMEDIAL (RA^ COST RECOVERY REFERRAL
GREATER THAN 200.000
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'SQ' AND
CP203 = W AND
(CP1201 = '1 or '2' or '3'
or '4')
DATA BASE: CERHELP
Select the number of sites with a
targeted Remedial Cost Recovery
Action for any fiscal year 1990
quarter.
C1732 = 'SV AND
C2731 contains 'VA1 AND
C2903 = 'F AND
C2907 GE 200,000 AND
C1707 = 'FE' AND
(C1713 = '901' or '902' or
'903' or '904') AND
C1725 = 'P'
DATA BASE : CERCLIS
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.
C1732 = 'SV AND
C2731 contains 'VA' AND
C2903 = 'F' AND
C2907 GE 200,000 AND
C1707 = 'FE' AND
C1716 GE 10/01/89 AND
C1716 LT 10/01/90
DATA BASE: CERCLIS
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
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'RR' AND
CP203 = '90' AND
(CP1201 = '1 or '2' or '3'
or '4')
C1732 = 'SV AND
C2903 = 'Fr AND
C2907LT 200,000 AND
C1707 = 'FE' AND
(C1713 = '901' or '902' or
'903' or '904')
C1732 = 'SV AND
C2903 = 'F AND
C2907 LT 200,000 AND
C1707 = 'FE' AND
C1716 GE 10/01/89 AND
C1716LT 10/01/90
DATA BASE : CERHELP
Select the number of sites with a
targeted Remedial Cost Recovery
Action for any fiscal year 1990
quarter.
DATA BASE: CERCLIS
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.
DATA BASE : CERCLIS
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-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
(CP1201 = '1 or '2' or '3'
or '4')
(C1732 = 'AV or 'FI1 or 'AC'
or TJA') AND
C2903 = F AND
(C1715 = '901' or '902' or
'903' or '904')
DATA BASE: CERHELP
Select the number of sites with
a targeted Administrative Cost
Recovery Settlement for any
fiscal year 1990 quarter.
DATA BASE: CERCLIS
Select sites which have a Planned
Administrative Cost Recovery
Settlement during fiscal year 1990.
[C1732 = 'AV or 'FF or
'AC' or (C1732 = 'AU'
AND C1726 NE 'O'
or 'N')]
C2903 = 'F' AND
C2907 GT 0 AND
C1717 GE 10/01/89 AND
C1717 LT 10/01/90 AND
C1726 = T' AND
(C2731 contains 'VM'
or 'VO' or 'VD' or 'VA)
DATA BASE: CERCLIS
Se;lect 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
CP202 = 'SF AND
CP203 = '90' AND
(CP1201 = '1 OR '2' OR '3'
OR '4')
(C1732 = 'SX1 or 'CL') AND
C1707 = 'FE' AND
(C1715 = '901' or '902' or
'903' or '904')
(C1732 = 'SX' or 'CL') AND
C1707 = 'FE' AND
C1717GE 10/01/89 AND
C1717 LT 10/01/90
DATA BASE: CERHELP
Select the number of sites with
a targeted Section 106 or
106/107Case Resolution/ for
any fiscal year 1990 quarter.
DATA BASE: CERCLIS
Select sites that have a Section 106
or Combined Section 106/107
completion during fiscal year 1990
that fully resolves the case.
DATA BASE: CERCLIS
Select sites that have a Section 106
or Combined Section 106/107
litigation completed during fiscal
year 1990.
E-57
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
SECTION 107 CASE RESOLUTION
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'SE' AND
CP203 = '90' AND
(CP1201 = '1 or '2' or '3'
or '4')
C1707 = 'FE' AND
C1732 = 'SV AND
(C1715 = '901' or '902' or
'903' or '904')
C1707 = 'FE1 AND
C1732 = 'SV1 AND
C1717 GE 10/01/89 AND
C1717 LT 10/01/90
DATA BASE: CERHELP
Select the number of sites with
a targeted Section 107 Case
Resolution for any fiscal
year 1990 quarter.
DATA BASE: CERCLIS
Select sites that have a planned
Section 107 litigation completed
during fiscal year 1990.
DATA BASE : CERCLIS
Select sites that have a Section 107
litigation completed during
fiiscal year 1990.
E-58
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
106 REFERRAL FOR RD/RA WITHOUT SETTLEMENT
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'SD' AND
CP203 = W AND
(CP1201 = '1 or '2' or T
or '4')
DATA BASE: CERHELP
Select the number of sites with a
targeted Section 106 Referrals
for Remedial Design or Remedial
Action Without Settlement for
any fiscal year!990 quarter.
(C1732 = 'SX' or 'CL') AND
(C2731 contains 'RD'
or 'RA') AND
C1707 = 'FE' AND
(C1713 = '901' or '902' or
'903' or '904') AND
C1725 = 'P'
DATA BASE: CERCLIS
Selected sites which have an
Section 106 or Combined 106/107
litigation with Remedial Design or
Remedial Action Remedy
planned during fiscal year 1990.
(C1732 = 'SX' or 'CL') AND
(C2731 contains 'RD1
or 'RA') AND
C1707 = 'FE' AND
C1716 GE 10/01/89 AND
C1716 LT 10/01/90
DATA BASE: CERCLIS
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
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'SW AND
CP203 = '90' AND
(CP1201 = '1 or '2' or '3'
or '4')
DATA BASE: CERHELP
Select the number of sites with a
targeted Section 106 Referrals
for RD/RA With Settlement for
any fiscal year 1990 quarter.
{[C1732 = 'CD'and
(C1713 = '901' or '902' or
'903' or '904')]
or
[C1732 = 'UA1 and
(C1715 = '901'or'902'or
'903'or'904')]}
AND
C1707 = 'FE1 AND
C1725 = 'P1 AND
(C2731 contains 'RD' or 'RA')
DATA BASE: CERCLIS
Selected sites that have a
Consent Decree Unilateral order
for Remedial Design or Remedial
Action Remedy planned during
fiscal year 1990.
{(C1732 = 'CD'and
C1716GE 10/01/88 and
C1716 LT 10/01/89
or
[C1732 = 'UA' and
C1717 GE 10/01/88 and
C1717 LT 10/01/89 and
(C1726 = 'Ytor'MtorT)]}
AND
C1707 = 'FE' AND
(C2731 contains 'RD1 or 'RA')
DATA BASE: CERCLIS
Selected sites which have an
Consent Decree or Unilateral order
for Remedial Design or Remedial
Action where the PRP's are in
compliance.
E-60
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND ACCOMPLISHMENTS
REPORT
UNILATERAL ADMINISTRATIVE ORDER (UAQ) FOR RD/RA
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'AO1 AND
CP203 = '90' AND
(CP1201 = '1 or '2' or '3'
or '4')
C1732 = TJA' AND
C1707 = 'FE1 AND
(C1715 = '901'or'902'or
'903' or '904') AND
C1725 = 'P' AND
(C2731 contains 'RD' or 'RA')
C1732 = TJA1 AND
Cl 717 GE 10/01/89 AND
C1717LT 10/01/90 AND
(C1726 = 'M' or 'Y' or T) AND
(C2731 contains 'RD' or 'RA')
DATA BASE: CERHELP
Select the number of sites with a
targeted Unilateral Order for
fiscal year 1990.
DATA BASE: CERCLIS
Select sites that have a Unilateral
Order for Remedial Design or Remedial
Action planned to be issued during
fiscal year 1990.
DATA BASE: CERCLIS
Select sites that have a Unilateral
Administrative Order for Remedial
Design or Remedial Action issued
during fiscal year 1990.
E-61
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS/ACCOMPLISHMENTS REPORT
IAG AT FEDERAL FACILITIES',
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'IS' AND
CP203 = '90' AND
(CP1201 = '1 or '2' or '3'
or '4')
DATA BASE: CERHELP
Select the number of sites with
a targeted Interagency
Agreement at a Federal Facility
for any fiscal year 1990 quarter.
CBS = '¥' AND
(C305 = 'P' or 'F or 'S'
or 'D') AND
C135 NE T' AND
C1732 = 'FI1 AND
(C1715 = '901' or '902' or
'903' or '904') AND
C1725 = 'F
C135 = '¥' AND
(C305 = 'P1 or 'F' or 'S1
or 'D') AND
C135 NE '¥' AND
C1732 = 'FF AND
C1717 GE 10/01/89 AND
C1717 LT 10/01/90
DATA BASE : CERCLIS
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.
DATA BASE : CERCLIS
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
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'LA' AND
CP203 = '90' AND
CP206 = 'NL' AND
(CP1201 = '1 or '2' or '3'
or '4')
C135NE'Y'AND
(C2111 ='RI'OR'FS'
or 'RV') AND
(C2115 = 'A'OR'B')AND
C2140GE 10/01/89 AND
C2140LT 10/01/90 AND
C2140 = FIRST C2140
DATA BASE: CERHELP
Select the number of NPL sites
targeted to be Addressed
for Fiscal year 1990.
DATA BASE: CERCLIS
Select the number fo NPL sites
Addressed for Fiscal year 1990.
E-63
-------
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 = W AND
CP206 = 'NL' AND
(CP1201 = Tor'2'or
'3' or '4')
ATA BASE: CERHELP
Select the number of sites
targeted for a Preliminary
Assessment completion
for Fiscal year 1990.
E-65
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
SITE INSPECTION COMPLETION
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'SI' AND
CP203 = '90' AND
CP206 = 'NL1 AND
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: 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 = 'NL1 AND
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: CERHELP
'elect sites with a targeted RI/FS
irst start fat any fiscal year 1990
uarter.
(C305 = 'P1 or 'F or
'R1 or 'D' or 'S') AND
(C2111 ='RI' or'FS'or
'CO') AND
(C2115 = 'A'or'B1or
BLANK) AND
C2117NE'FF AND
(C2132 = '901' or '902' or
'903' or '904')
DATA BASE: CERCLIS
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.
(C305 = 'P1 or 'F' or
'R' or 'D' or 'S') AND
(C2111 = 'Rl'or'FS'or
'CO') AND
(C2115 = 'AT or'B'or
BLANK) AND
C2117NE'FF'AND
C2140GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: CERCLIS
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 that started during
fiscal year 1990 and was the first
at the site.
E-67
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RT/FS FIRST START (FEDERAL FACILITY)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'CS' AND
CP203 = '90' AND
CP206 = 'FF AND
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: CERCLIS
Select sites with a targeted
Federal Facility lead RI/FS
first start for any fiscal year
1990 quarter.
C135 = T1 AND
(C305 = 'P1 or 'F or
'R' or T>' or 'S') AND
(C2111 = 'RI1 or'FS'or
'CO') AND
(C2115 = 'A'or'B1
or BLANK) AND
C2117 ='FF AND
(C2132 = '901' or '902' or
'903' or '904')
DATA BASE: CERCLIS
Select sites that are Proposed, Final,
Removed, Deleted or Soon to be
proposed to the NPL that have a
Federal Facility lead
Remedial Investigation,
Feasibility Study, or Combined
RI/FS planned to start during
fiscal year 1990 that will bethe
first at the site.
C135 = 'Y' AND
(C305 = 'P' or 'F1 or
'R' or 'D1 or 'S') AND
(C2111 ='RI'or'FS1 or
'CO') AND
(C2115 = 'A' or'B'
or BLANK) AND
C2117 = 'FF'AND
C2140GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: CERCLIS
Select sites that are Proposed,
Final, Removed, Deleted, or
Soon to be proposed
to the NPL that have a Federal
Facility lead Remedial
Investigation, Feasability Study,
or Combined RI/ FS that started
during fiscal year 1990 and was
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
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'QC AND
CP203 = '90' AND
CP206 = 'NL1 AND
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: CERHELP
Select sites with a targeted RI/FS
subsequent start for any fiscal year
1990 quarter.
(C305 = 'P or 'F or
'R1 or 'D1 or 'S') AND
(C2111 ='RI' or'FS'or
'CO') AND
(C2115 = 'C'ortD')AND
C2117 NE 'FF AND
(C2132 = '901'or'902'or
'903' or '904')
DATA BASE: CERCLIS
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.
(C305 = 'P1 or 'F' or
'R' or 'D' or 'S1) AND
(C2111 = 'RT or'FS'or
'CO') AND
(C2115 = 'C or'D') AND
C2117NE'FF AND
C2140 GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: CERCLIS
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 Rty FS that started
during fiscal year 1990 and was a
subsequent start at the site.
E-69
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RI/FS SUBSEQUENT START (FEDERAL FACILITY^
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'QC AND
CP203 = '90' AND
CP206 = TF AND
(CP1201 = T or '21 or
'3' or '4')
DATA BASE: CERCLIS
Select sites with a targeted
Federal Facility lead RI/FS
subsequent start for any fiscal year
1990 quarter.
C135 = 'Y' AND
(C305 = 'P' or T1 or
'R' or 'D' or 'S') AND
(C2111 = 'RF or'FS'or
'CO') AND
(C2115 = 'C1or'D1) AND
C2117 = 'FF AND
(C2132 = '901' or '902' or
'903' or '904')
DATA BASE: CERCLIS
Select sites that are Proposed, Final,
Removed, Deleted or Soon to be
proposed to the NPL that have a
Federal Facility lead
Remedial Investigation,
Feasibility Study, or Combined
RI/FS planned to start during
fiscal year 1990 that will be a
subsequent at the site.
C135 = 'Y1 AND
(C305 = 'P1 or 'F or
'R1 or T>' or 'S') AND
(C2111 = 'RT or 'FS' or
'CO') AND
(C2115 = 'C or T)1) AND
C2117 = 'FF'AND
C2140 GE 10/01/89 AND
C2140 LT 10/01/90
DATA BASE: CERCLIS
Select sites that are Proposed,
Final, Removed, Deleted, or
Soon to be proposed
to the NPL that have a Federal
Facility lead Remedial
Investigation, Feasability Study,
or Combined RV FS that started
during fiscal year 1990 and was a
subsequent start at the site.
E-70
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RI/FS FIRST COMPLETION (FIRST ROD)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'OF AND
CP203 = '90' AND
CP206 = 'NL1 AND
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: CERHELP
ielect sites with a targeted first
Record of Decision for any fiscal
'ear 1990 quarter.
C135 NE 'Y1 AND
(C305 = 'P' or 'F' or 'R1
or 'D' or 'S') AND
C2111 = 'RO' AND
(C2116 = 1A'or'B'or
BLANK) AND
C2117NE 'FF AND
(C2133 = '901' or '902' or
'903' or '904')
DATA BASE: CERCLIS
Select 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.
The site cannot be a Federal Facility.
CBS NE 'Y' AND
(C305 = 'P' or 'F'
or 'R' or 'D' or 'S') AND
C2111 ='RO' AND
(C2116 = 'A'or'B'or
BLANK) AND
C2117NE'FF'AND
C2141GE 10/01/89 AND
C2141 LT 10/01/90
DATA BASE: CERCLIS
Select 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. 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 FTRST COMPLETION (FIRST ROD)
TFEDERAL FACILITY)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'OF AND
CP206 = 'FF AND
CP203 = '90' AND
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: CERHELP
Select sites with a targeted first
Record of Decision for any fiscal
year 1990 quarter with a
Federal Facility lead.
(C305 = 'P or T1 or 'R1
or 'D1 or 'S') AND
[(C135 = 'Y' and C2117 = 'FE')
orC2117EQ'FF]AND
C2111 = 'RO' AND
(C2116 = 1A'or'B1or
BLANK) AND
(C2133 = '901' or '902' or
'903' or '904')
DATA BASE: CERCLIS
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.
(C305 = 'P1 or F
or 'R' or 'D1 or 'S') AND
[(C135 = 'Y1andC2117 = 'FE')
orC2117EQ'FF] AND
C2111 ='RO' AND
(C2116 = 'A1or'B1or
BLANK) AND
C2141 GE 10/01/89 AND
C2141 LT 10/01/90
DATA BASE: CERCLIS
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
(luring fiscal year 1990 and was
the first at the site.
E-72
-------
OSWER Dkective 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RI/FS SUBSEQUENT COMPLETION (SUBSQ ROD)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'OS' AND
CP203 = '90' AND
CP206 = 'NL' AND
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: CERHELP
Select sites with a targeted
ubsequent Record of Decision
or any fiscal year 1990 quarter.
C135 NE 'Y1 AND
(C305 = 'P or F or 'R1
or 'D1 or'S') AND
(C2111='RO' AND
(C2116 = >C'or'D1) AND
C2117NE'FFAND
(C2133 = '901' or '902' or
'903' or '904')
DATA BASE: CERCLIS
Select 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 a subsequent at the site.
The site cannot be a Federal Facility.
C135 NE '¥' AND
(C305 = 'P1 or 'F'
or 'R' or 'D' or 'S') AND
(C2111 = 'RO' AND
(C2116 = 'C'or'D1) AND
C2117NE'FFAND
C2141 GE 10/01/89 AND
C2141 LT 10/01/90
DATA BASE: CERCLIS
Select 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 a subsequent at the site.
The site cannot be a Federal
Facility.
E-73
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGKT AND NEGOTIATIONS REPORT
RI/FS SUBSEQUENT COMPLETION fSUBSO ROD)
FEDERAL FACILITY
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'OS' AND
CP203 = '90' AND
CP206 = 'FF AND
(CP1201 = 'I1 or '2' or
'31 or '4')
DATA BASE: CERHELP
Select sites with a targeted
Federal Facility lead
subsequent Record of Decision
for any fiscal year 1990 quarter.
(C305 = 'P1 or F or R'
or T>' or'S') AND
[(C135 = 'Y1 and C2117 = 'FE')
orC2117EQ'FF']AND
(C2111=RO' AND
(C2116 = 1Cor'D1) AND
(C2133 = '901' or '902' or
'903' or '904')
DATA BASE: CERCLIS
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.
(C305 = 'P1 or 'F or
or T>' or'S') AND
[(C135 = 'Y1 and C2117 = TE1)
orC2117EQ'FF] AND
C2111 = RO' AND
(C2116 = 1CorfD1) AND
C2141 GE 10/01/89 AND
C2141 LT 10/01/90
DATA BASE: CERCLIS
Select sites that are Proposed,
Final, Removed, Deleted or
Scon 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.
E-74
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RI/FS FINAL COMPLETION (FINAL ROD)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'OD' AND
CP203 = '90' AND
CP206 = 'NL' AND
(CP1201 = 'I1 or '21 or
'3' or '4')
DATA BASE: CERHELP
elect sites with a targeted final
ecord of Decision for any fiscal
ar 1990 quarter.
C135 NE 'Y' AND
(C305 = 'P or F or 'R'
or 'D' or 'S') AND
(C2111 ='RO' AND
(C2116 = 'A1or'D'or
BLANK) AND
C2117NE'FF'AND
(C2133 = '901'or'902'or
'903' or '904')
DATA BASE : CERCLIS
Select sites that are Proposed, Final,
Removed, Deleted or Soon to be
proposed to the NPL that have a
Record OfDecision planned to be
signed during fiscal year 1990 that
will be the final at the site. The site
cannot be a Federal Facility.
C135 NE 'Y' AND
(C305 = 'P' or 'F' or 'S'
or 'R1 or 'D') AND
(C2111 = 'RO' AND
(C2116 = 1A'or'D'or
BLANK) AND
C2117NE'FFAND
C2141GE 10/01/89 AND
C2141 LT 10/01/90
DATA BASE: CERCLIS
Select 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 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 (FS TO PUBLIC)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'RC AND
CP203 = '90' AND
CP206 = 'NL' AND
(CP1201 = 'I1 or '2' or
'3' or '4')
DATA BASE: CERHELP
Select sites with a targeted
Feasability Study to Public for
any fiscal year 1990 quarter.
(C305 = 'P or 'F or 'R'
or 'D' or 'S') AND
(C2111='FS' or'CO') AND
C3111 ='CF'AND
C2117NE'FFAND
(C3129 = '901' or '902'
or '902' or '903')
DATA BASE: CERCLIS
Select sites that are Proposed, Final,
Removed, Deleted or Soon to be
Proposed to the NPL that have a
Feasibility Study or Combined RI/FS
planned to be released to the public
during fiscal year 1990. The site
cannot be a Federal Facility.
(C305 = 'P1 or 'F1
or 'R' or 'D' or 'S') AND
(C2111 ='FS'
or' CO1) AND
C3111 ='CFAND
C2117NETF AND
C3125 GE 10/01/89 AND
C3125 LT 10/01/90
DATA BASE: CERCLIS
Sel
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RD FIRST START
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'DS' AND
CP203 = '90' AND
CP206 = 'NL1 AND
(CP1201 = T or '2' or
'3' or '4')
(C305 = 'P or F or
'D' or 'S') AND
C2111 ='RD' AND
(C2115 ='A'or'B'or
BLANK) AND
C2117NE'FF'AND
(C2132 = '9011 or '902' or
'903' or '904') AND
(C305 = 'P' or 'F' or 'R'
or'S'or 'D')AND
C2111 = 'RD' AND
(02115 ='A1 or'B'or
BLANK) AND
C2117NE'FF'AND
C2140 GE 10/01/89 AND
C2140 LT 10/01/90
DATA BASE: CERHELP
:lect sites with a targeted
medial Design
st start for any fiscal year 1990
arter.
DATA BASE: CERCLIS
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.
DATA BASE: CERCLIS
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 was the first at the site.
E-77
-------
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 = DS' AND
CP203 = '90' AND
CP206 = 'ff AND
(CP1201 = T or '21 or
'3' or '4')
DATA BASE : CERHELP
Select sites with a targeted
Remedial Design first
start for any fiscal year 1990
quarter.
(C305 = 'P1 or 'F or
T>' or'S') AND
C2111 = 'RD' AND
(C2115 = 'A'or'B1
or BLANK) AND
C2117 = 'FF AND
(C2132 = '901' or '902' or
'903' or '904')
DATA BASE: CERCLIS
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.
(C305 = 'P' or 'F' or 'R' or
'S'or 'D')AND
C2111 ='RD' AND
(C2115 = 'A or'B1
or BLANK) AND
C2117 = 'FF'AND
C2140GE 10/01/89 AND
C2140 LT 10/01/90
DATA BASE: CERCLIS
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.
E-78
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL 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 = 'NL1 AND
(CP1201 = T or '2' or
'3' or '4')
(C305 = 'P' or 'F or
'D' or 'S') AND
C2111 = 'RD' AND
(C2115 = 1C'or'DI) AND
C2117NE'FF AND
(C2132 = '901' or '902' or
'903' or '904')
DATA BASE: CERHELP
Select sites with a targeted
Remedial Design subsequent
start for any fiscal year 1990
quarter.
DATA BASE: CERCLIS
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.
(C305 = 'P' or T' or 'R' or
'S'or 'D')AND
C2111 = 'RD1 AND
(C2115 = 'C or'D') AND
C2117NE'FFAND
C2140 GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: CERCLIS
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 subsequent
start at the site.
E-79
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RD SUBSEQUENT START (FEDERAL FAOLITY^
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'QD' AND
CP203 = '90' AND
CP206 = 'FF AND
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: CERHELP
Select sites with a targeted
Federal Faciltiy lead
Remedial Design subsequent
start to any fiscal year 1990
quarter.
(C305 = 'F or 'F' or
T>' or 'S') AND
C2111='RD' AND
(C2115 = 'C'or'DI) AND
C2117 = 'FF AND
(C2132 = '901' or '902' or
'903' or '904')
DATA BASE: CERCLIS
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.
(C305 = 'P' or F or 'R1 or
'S' or T>') AND
C2111 = 'RD' AND
(C2115 = 'C or'D') AND
C2117 = 'FFAND
C2140 GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: CERCLIS
Select sites that are Proposed,
Final, Removed, Soon to be
Proposed, or Deleted from the
NFL 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 = 'NL1 AND
(CP1201 = T or '2' or
'3' or '4')
(C305 = 'P' or F or
'D' or 'S') AND
C2111='RD'AND
(C2115 = 'A'or'D'or
BLANK) AND
C2117NE'FF'AND
(C2132 = '901'or'902'or
'903' or '904')
DATA BASE: CERHELP
•elect sites with a targeted
Remedial Design final start
or any fiscal year 1990 quarter.
DATA BASE: CERCLIS
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.
(C305 = 'P' or 'F1 or 'R1
or'D'or 'S')AND
(C2111 = 'RD1 AND
(C2115 = 'A' or'D'or
BLANK) AND
C2117NE'FFAND
C2140 GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: CERCLIS
Select sites that are Proposed,
Final, Removed, Deleted or
Soon to be proposed to the NPL
that have a Remedial Design that
started during fiscal year 1990,
and was the final start at the site.
E-81
-------
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 = 'NL1 AND
CP203 = '90' AND
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: CERHELP
Select sites with a targeted fund
lead Remedial Action first start
for any fiscal year 1990 quarter.
(C305 = 'P or T1 or 'D1
or'S') AND
C2111 = 'RA' AND
(C2115 = 'A'or'B'or
BLANK) AND
(C2117 ='F or'S1 or'FE1 or
'SN1 or 'EP or 'SE') AND
(C2132 = '901' or '902' or
'903' or '904')
DATA BASE: CERCLIS
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.
(C305 = 'P' or 'F1 or 'R1 or
'D1 or'S') AND
C2111='RA' AND
(C2115 = 'A' or'B'or
BLANK) AND
(C2117 ='F'or'S'or'FE'or
'SN1 or 'EP' or 'SE') AND
C2140GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: CERCLIS
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 first
al: the site.
E-82
-------
OSWER Directive 9200.3-01 C
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' AND
(CP1201 = Tor'2'or
'3' or '4')
DATA BASE: CERHELP
Select sites with a targeted RP
lead Remedial Action first start
for any fiscal year 1990 quarter.
(C305 = 'P1 or 'F or 'D1 or 'S')
AND
C2111 ='RA' AND
(C2115 = 1A'or'B1or
BLANK) AND
(C2117 = >RP'or'MR'or
'PS' or 'SR' or 'FF')
(C2132 = '901' or '902' or
'903' or '904')
DATA BASE: 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
'D1 or 'S') AND
C2111 = 'RA' AND
(C2115 = 'A' or'B'or
BLANK) AND
(C2117 = 'RP'or'MR'or
'SR' or FF' or 'PS') AND
C2140GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE : CERCLIS
Select sites 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
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS 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
(CP1201 = T or '2' or
'3' or '4')
(C305 = 'P1 or 'F or 'D1
or'S') AND
C2111 ='RA' AND
(C2115 = 'Ator'Blor
BLANK) AND
C2117 = 'FF AND
(C2132 = '901' or '902' or
'903' or '904')
DATA BASE: CERCLIS
Select sites with a targeted
Federal Facility lead Remedial
Action first start for any fiscal year
1990 quarter.
DATA BASE: CERHELP
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.
(C305 = 'P' or 'F or R' or
'D' or 'S') AND
C2111 = RA' AND
(C2115 = 'A' or'B'or
BLANK) AND
C2117 = 'FFAND
C2140 GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: CERCLIS
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 (PROGRAM)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'QR' AND
CP206 = 'NL1 AND
CP203 = '90' AND
(CP1201 = T or '2' or
'3' or '4')
(C305 = 'P or 'F or T>' or 'S')
AND
C2111 ='RA' AND
(C2115 = 1C1or1D')AND
(C2132 = '901' or '902' or
'903' or '904') AND
(C2117 = 'EP'or'F or'S'or
'FEf or 'SN' or 'SE')
DATA BASE: CERHELP
lelect sites with a targeted fund
ad Remedial Action subsequent
tart for any fiscal year 1990
uarter.
DATA BASE: CERCLIS
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 a
subsequent at the site.
(C305= 'P or 'F or 'R or
'RD1 or'S') AND
C2111 = 'RA' AND
(C2115 = 'C or'D') AND
(C2117 = 'For'S'or'FE'or
'SN1 or 'EP' or 'SE') AND
C2140GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: CERCLIS
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 a
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 = 'QR1 AND
CP206 = 'RP1 AND
CP203 = '90' AND
(CP1201 = T or '2' or
'3' or '4')
(C305 = 'P or 'F or 'D'
or'S') AND
C2111 = 'RAt AND
(C2115 = 'C'or'D1) AND
(C2117 = IRP'or'MR1or
'SR'or 'PS')
(C2132 = '901' or '902' or
'903' or '904')
DATA BASE: CERHELP
Select sites with a targeted RP
lead Remedial Action subsequent
start for any fiscal year 1990 quarter.
DATA BASE: 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.
(C305 = 'P' or 'F' or 'R' or
T)1 or'S') AND
C2111 = 'RA' AND
(C2115 = 'C or'D') AND
(C2117 = 'RPIor'MR1or
SR' or 'PS') AND
C2140GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: CERCLIS
Select sites that are Proposed,
Final, Removed, Deleted or
Soon to be proposed to the NPL
lhat have a RP lead Remedial
Action that started during fiscal
year 1990 and was a subsequent
at the site.
E-86
-------
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
(CP1201 = T or '2' or
'3' or '4')
DATA BASE: CERCLIS
Select sites with a targeted
Federal Facility lead Remedial
Action subsequent start for any
fiscal year 1990 quarter.
(C305 = 'P1 or 'F or T>'
or'S') AND
C2111 ='RA' AND
(C2115 = 1C1or'D')AND
C2117 = 'FFAND
(C2132 = '901' or '902' or
'903' or '904')
DATA BASE: CERHELP
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.
(C305 = 'P' or 'F' or 'R' or
'D1 or 'S') AND
C2111 = 'RA' AND
(C2115 = 'C or'D') AND
C2117 = 'FFAND
C2140GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: CERCLIS
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 a
subsequent at the site.
E-87
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
RA FINAL START (PROGRAM)
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'AF AND
CP206 = 'NL1 AND
CP203 = '90' AND
(CP1201 = 'I1 or '2' or
'3' or '4')
DATA BASE: CERHELP
Select sites with a targeted fund
lead Remedial Action final start
for any fiscal year 1990 quarter.
(C305 = 'P1 or F or T>'
or'S') AND
C2111='RA1 AND
(C2115 = 'A1or'D1or
BLANK) AND
(C2117 = 1EP'or'For'S1
or 'FE' or 'SN' or 'SE')
(C2132 = '9011 or '902' or
'903' or '904')
DATA BASE: CERCLIS
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.
(C305 = 'P' or 'F or 'R1 or
•D' or'S') AND
C2111 = 'RA' AND
1^2115 = ^' or'D'or
BLANK) AND
(C2117 ='F or'S'or'FE'or
'SN' or 'EF or 'SE') AND
C2140 GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: CERCLIS
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 ihe site.
E-J
-------
OSWER Directive 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
DATA SELECTION
CRITERIA
CP202 = 'AF AND
CP206 = 'RP' AND
CP203 = '90' AND
(CP1201 = 'I1 or '2' or
'3' or '4')
(C305 = 'P or 'F or T>'
or 'S')AND
C2111=1RAI AND
DATA BASE: CERHELP
lelect sites with a targeted RP
sad Remedial Action final start
or any fiscal year 1990 quarter.
BLANK) AND
(C2132 = '901' or '902' or
'903' or '904') AND
(C2117 = 'RP' or 'MR' or 'SR1
or 'PS')
DATA BASE: CERCLIS
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
(C305 = 'P' or 'F' or 'R' or
'D1 or 'S') AND
C2111 = 'RA' AND
(C2115 = 'A' or'D'or
BLANK) AND
(C2117 = 'RP' or 'MR' or 'SR'
or 'PS') AND
C2140GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: CERCLIS
Select sites that are Proposed, Final,
Removed, Deleted 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
(CP1201 = T or '2' or
'31 or '4')
DATA BASE: CERHELP
Select sites with a targeted
Post-SARA first Remedial
Action for any Fiscal year
1990 quarter.
(C305 = 'P or F or 'R1
'D1 or 'S') AND
C2111 = 'RA' AND
(C2115 = 1A'or'B1or
BLANK) AND
C2117NE'FFAND
CSll^'ACAND
[(C3125 GE 10/16/86 AND
LE 10/16/90) or (C3129 Spans
Current Quarter to 904)]
DATA BASE: CERCLIS
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 prior 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
(C305 = 'P1 or 'F1 or 'R1
or 'D1 or 'S') AND
C2111='RA1 AND
(C2115 = 'A'or'B1 or
BLANK) AND
C2117NE'FFAND
C3111 ='ACAND
C3125GE 10/16/86 AND
C3125 LE 10/16/90
DATA BASE: CERCLIS
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
(CP1201 = T or '2' or
'3' or '4')
(C305 = 'P1 or 'F1 or
'D' or 'S') AND
C2111 ='RA' AND
(C2116 = 'A1or'D1or
BLANK) AND
C2117NE'FF'AND
(C2133 = '901' or '902' or
'903' or '904')
DATA BASE: CERHELP
Select sites with a targeted final
Remedial Action completion for
any fiscal year 1990 quarter.
DATA BASE: CERCLIS
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.
(C305 = 'P1 or 'F' or 'R1 or
'D' or'S1) AND
C2111 ='RA' AND
(02116 ='A1 or'D'or
BLANK) AND
C2117NE'FFAND
AND C2141 GE 10/01/89
AND C2141 LT 10/01/90
DATA BASE: CERCLIS
Select sites that are Proposed,
Final, Removed, Deleted 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-91
-------
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
(CP1201 = T or '2' or
'3' or '4')
(C305 = 'P' or T or 'R1
or T>' or 'S') AND
C2111 = 'ND' AND
(C2132 = '901' or '902' or
'903' or '904')
(C305 = 'P1 or 'F or 'R' or
'D' or 'S') AND
C2111 = 'ND' AND
C2140 GE 10/01/89 AND
C2140 LE 10/01/90
DATA BASE: CERHELP
Select sites with a targeted
NPL Deletion Initiation
for any fiscal year 1990 quarter.
DATA BASE: CERCLIS
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.
DATA BASE: CERCLIS
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 REMOVAL FIRST START
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
'P202 = 'RF AND
P203 = '90' AND
P1201 = '5'
(C305 = 'P' or F or
T>' or 'S') AND
C2111 = 'RV' AND
(C2115 = 'A'or'BIor
BLANK) AND
(C2132 = '901' or '902' or
'903' or '904')
(C305 = 'P' or 'F1 or 'D') AND
C2111 = 'RV AND
(C2117 = 'RP'or'F') AND
(C2115 = 'A'or'B'or
BLANK) AND
C2140 GE 10/01/89 AND
C2140LT 10/01/90
TA BASE: CERHELP
;t the number of sites targeted
NPL Removal first start for
year 1990.
DATA BASE: CERCLIS
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.
DATA BASE: CERCLIS
Select sites that are Proposed, Final,
or Deleted to the NPL that have a
Removal which started during fiscal
year!990 that was 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 = W AND
CP1201 = '5'
(C305 = 'P1 or 'F or
T>' or 'S') AND
C2111 = 'RV' AND
(C2115 = 'CIor'D') AND
(C2132 = '901' or '902' or
'903' or '904')
DATA BASE: CERHELP
Select the number of sites
targeted for a Removal
subsequent start.
DATA BASE: CERCLIS
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.
(C305 = 'P1 or 'F' or T>') AND
C2111='RV' AND
(C2117 = 1RP'or1F) AND
(C2115 = 1Cor'D)and
C2140 GE 10/01/89 AND
C2140LT 10/01/90
DATA BASE: CERCLIS
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
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
NPL REMOVAL COMPLETION
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'RT' AND
CP203 = '90' AND
CP1201 = '5'
(C305 = 'P1 or F or
'D' or 'S') AND
(C2111 = 'RV or TR1 or'PR')
(C2133 = '901' or '902' or
'903' or '904')
(C305 = 'P' or 'F'
or 'D') AND
(C2111 = 'RV or TR' or
'PR') AND
C2141 GE 10/01/89AND
C2141 LT 10/01/90
DATA BASE: CERHELP
Select the number of sites
targeted for a NPL Removal
completion for fiscal year 1990.
DATA BASE: CERCLIS
Select sites that are Proposed, Final,
Deleted or Soon to be proposed
to the NPL that have a Removal
planned to complete during
fiscal year 1990.
DATA BASE: CERCLIS
Select sites that are Proposed, Final,
or Deleted to the NPL that have a
Removal which completed
during fiscal year 1990.
E-95
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGETS AND NEGOTIATIONS REPORT
NQN-NPL REMOVAL START
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'ST' AND
CP203 = '90' AND
CP1201 = '5'
(C305 = 'N' or 'R') AND
C2111='RV' AND
(C2132 = '901' or '902' or
'903' or '904')
(C305 = 'N1 or 'R1 or 'S' ) AND
C2111 = 'RV AND
C2140 GE 10/01/89 AND
C2140 LT 10/01/90
DATA BASE: CERHELP
Select the number of sites with a
targeted Non - NPL Removal
start for fiscal year 1990.
DATA BASE: CERCLIS
Select sites that are not on the NPL
that have a Removal planned to start
during fiscal year 1990.
DATA BASE: CERCLIS
Select sites that are not on the
NPL that have a Removal
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
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = TT AND
CP203 = '90' AND
CP1201 = '5'
(C305 = 'N1 or 'R') AND
(C2111 = 'RV'or 'IR'
or 'PR') AND
C2133 = '901' or '902' or
'903' or '904')
(C305 = 'N' or 'R' or 'S') AND
(C2111 ='RV or'IR'or
'PR') AND
C2141 GE 10/01/89 AND
C2141 LT 10/01/90
DATA BASE: CERHELP
Select the number of sites
targeted for a Non- NPL Removal
completion for fiscal year 1990.
DATA BASE: CERCLIS
Select sites that are not included
on the NPL that have a Removal
planned to complete during
fiscal year 1990.
DATA BASE: CERCLIS
Select sites that are not included
on the NPL that have a
Removal which completed
during fiscal year 1990.
E-97
-------
OSWER Directive 9200.3-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
(CP1201 = '1 or '2' or '3'
or '4')
C135 NE '¥' AND
(C305 = 'P1 or 'F or T>'
or'S') AND
C1732 = 'AN1 AND
(C1713 = '901' or '902' or
'903' or '904')
C135 NE 'Y' AND
(C305 = 'P' or F or 'R'
or T>' or 'S') AND
C1732 = 'AN' AND
C1716 GE 10/01/89 AND
C1716LT 10/01/90
DATA BASE: CERHELP
Select the number of sites with a
targeted RD/RA Negotiation
start for any fiscal year
1990 quarter.
DATA BASE: CERCLIS
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.
DATA BASE: CERCLIS
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-01 C
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
CP202 = 'CO' AND
CP203 = '90r AND
(CP1201 = '1 or '2' or '3'
or '4')
C135NE'Y'AND
(C305 = 'P' or 'F or 'D'
or'S') AND
C1732 = AN' AND
(C1715 = '901' or '902' or
'903' or '904')
CBS NE '¥' AND
(C305 = 'P' or 'F' or 'R'
or T>' or'S') AND
C1732 = 'AN1 AND
C1717 GE 10/01/89 AND
C1717 LT 10/01/90
DATA BASE: CERHELP
Select the number of sites with a
targeted RD/RA Negotiation
Completion for any fiscal year
1990 quarter.
DATA BASE: CERCLIS
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.
DATA BASE: CERCLIS
Select sites that 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 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
SECTTON 107 REMOVAL fPRE-RA) COST RECOVERY
REFERRAL > $2QOK
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')
DATA BASE: CERHELP
Select the number of sites with
a targeted Removal Cost
Recovery Action for any fiscal
year 1990 quarter.
C1732 = 'SV AND
[(C2731 contains 'VM' or
'VO'or'VD1) and
not contains'VA'] AND
C2903 = 'F AND
C2907GE 200,000 AND
(C1713 = '901' or '902' or
'903' or '904') AND
DATA BASE: CERCLIS
Select Section 107 litigation
activitiesplanned to start during fiscal
year 1990 with a Federal Cost
Recovery for Removal, RI/FS or RD
greater than $200,000 planned.
C1732 = 'SV1 AND
[(C2731 contains 'VM1 or
'VO'or'VD1) and
not contains 'VA'] AND
C2903 = 'F1 AND
C2907 GE 200,000 AND
C1716 GE 10/01/89 AND
C1716LT 10/01/90
DATA BASE: CERCLIS
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
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
SECTION 107 REMEDIAL (RA) COST RECOVERY
REFERRAL > S200K
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'SQ' AND
CP203 = '90' AND
(CP1201 = '1 or '2' or
or '4')
C1732 = 'SV AND
C2731 contains 'VA1 AND
C2903 = 'F AND
C2907 GE 200,000 AND
(C1713 = '901' or '902' or
'903' or '904')
DATA BASE: CERHELP
Select the number of sites with a
targeted Remedial Cost Recovery
Action for any fiscal year 1990
quarter.
DATA BASE : CERCLIS
Select Section 107 litigation
activities planned for fiscal
year 1990 with a Federal Cost
Recovery for Remedial Action
greater than $200,000.
C1732 = 'SV AND
C2731 contains 'VA' AND
C2903 = 'F' AND
C2907GE 200,000 AND
C1716 GE 10/01/89 AND
C1716 LT 10/01/90
DATA BASE: CERCLIS
Select Section 107 litigation
activitiesthat started during fiscal
year 1990 with a Federal Cost
Recovery for Remedial Action
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
(CP1201 = 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 = 'F1 AND
C2907LT 200,000 AND
C1716GE 10/01/89 AND
C1716LT 10/01/90
DATA BASE: CERHELP
Select the number of sites with a
targeted Remedial Cost Recovery
Action for any fiscal year 1990
quarter.
DATA BASE: CERCLIS
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.
DATA BASE: CERCLIS
Select sites that have a Section 107
litigation that started during fiscal
ye;ar 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
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'AL' AND
CP203 = '90' AND
(CP1201 = '1 OR '2' OR '3'
OR '4')
(C1732 = 'AV or 'FI1 or 'AC1
or TJA1) AND
C2903 = 'F AND
(C1715 = '901' or '902' or
'903' or '904')
DATA BASE: CERHELP
Select the number of sites with
a targeted Administrative Cost
Recovery Settlement for any
fiscal year 1990 quarter.
DATA BASE: CERCLIS
Select sites which have a Planned
Administrative Cost Recovery
Settlement during fiscal year 1990.
[C1732 = 'AV1 or 'FI' or
'AC' or (C1732 = TJA1
AND C1726 NE T>' AND
C1726 NE 'H')] AND
C2903 = 'F1 AND
C1717 GE 10/01/89 AND
C1717LT 10/01/90
DATA BASE: CERCLIS
Select sites that have an
Administrative Cost Recovery
Settlement during fiscal year 1990.
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
(CP1201 = '1 OR '2' OR '3'
OR '4')
(C1732 = 'SX' or 'CL') AND
(C1715 = '901' or '902' or
'903' or '904')
(C1732 = 'SX1 or 'CL') AND
C1717 GE 10/01/89 and
CV717 LT 10/01/90
DATA BASE: CERHELP
Select the number of sites with
a targeted Section 106 or
106/107 Case Resolution
for any fiscal year 1990 quarter.
DATA BASE: CERCLIS
Select sites that have a planned
Section 106 or!06/107 completion
during fiscal year 1990 that fully
resolves the case.
DATA BASE: CERCLIS
Select sites that have a Section 106
or Combined Section 106/107
litigation completed during fiscal
yeair 1990.
E-104
-------
OSWER 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 = 'SE1 AND
CP203 = '90' AND
(CP1201 = '1 or '2' or '3'
or '4')
C1732 = 'SV AND
(C1715 = '901' or '902' or
'903' or '904')
C1732 = 'SV1 AND
C1717GE 10/01/89 AND
C1717LT 10/01/90
DATA BASE: CERHELP
Select the number of sites with
a targeted Section 107 Case
Resolution for any fiscal
year 1990 quarter.
DATA BASE: CERCLIS
Select sites that have a Section 107
litigation completed during fiscal
year 1990.
DATA BASE: CERCLIS
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 WTTHQUT SETTLEMENT
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'SD' AND
CP203 = '90' AND
(CP1201 = '1 or '2' or '31
or '4')
(C1732 = 'SX' or 'CL') AND
(C2731 contains 'RD'
or 'RA') AND
(C1713 = '901' or '902' or
'903' or '904')
(C1732 = 'SX1 or 'CL') AND
(C2731 contains 'RD'
or 'RA') AND
C1716 GE 10/01/89 AND
C1716LT 10/01/90
DATA BASE: CERHELP
Select the number of sites with a
targeted Section 106 Referrals
for RDor RA Without Settlement
for any fiscal year 1990 quarter.
DATA BASE: CERCLIS
Select sites which have an
Section 106 or Combined 106/107
litigation with RD or RA Remedy
planned during fiscal year 1990.
DATA BASE: CERCLIS
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
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'SW AND
CP203 = '90' AND
(CP1201 = '1 or '2' or '3'
or '4')
{[C1732 = 'CD'and
(C1713 = 1901Ior'902'or
'903' or '904')]
or
[C1732 = 'UA1 and
(C1715 = '901'or'902'or
'903'or'904')]}
AND
(C2731 contains 'RD1 or 'RA')
DATA BASE: CERHELP
Select the number of sites with a
targeted Section 106 Referrals
~or RD/RA With Settlement for
.ny fiscal year 1990 quarter.
DATA BASE: CERCLIS
Selected sites which have a
Consent Decree with RD or RA
Remedy planned during fiscal
year 1990.
{(C1732 = 'CD'and
C1716GE 10/01/88 and
C1716LT 10/01/89
or
[C1732 = 'UA1 and
C1717 GE 10/01/88 and
C1717LT 10/01/89 and
(C1726 = 'Y'or'M'or'J')]}
AND
(C2731 contains 'RD' or 'RA1)
DATA BASE: CERCLIS
Selected sites which have an
Consent Decree or Administrative
Order on Consent or Section 106
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 fUAO) FOR RD/RA
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'AO' AND
CP203 = '90' AND
CP1201 = '5'
C1732 = TJA1 AND
(C1715 = '9011 or '902' or
'903' or '904') AND
(C2731 contains 'RD' or 'RA')
C1732 = 'UA' AND
C1717 GE 10/01/89 AND
C1717 LT 10/01/90 AND
(C2731 contains 'RD' or 'RA')
DATA BASE: CERHELP
Select the number of sites with a
targeted Unilateral Order for
fiscal year 1990.
DATA BASE: CERCLIS
Select sites that have a Unilateral
Order for Remedial Design or Remedial
Action planned to be issued during
fiscal year 1990.
DATA BASE: CERCLIS
Select sites that have a Unilateral
Administrative Order for Remedial
Design or Remedial Action issued
during fiscal year 1990.
E-108
-------
OSWER Directive 9200.3-01C
SELECT LOGIC
FISCAL YEAR 1990 TARGET AND NEGOTIATIONS REPORT
IAG AT FEDERAL FACILITIES
TARGET DATA
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'IS' AND
CP203 = '90' AND
(CP1201 = '1 or '2' or '3'
or '4')
C135 = 'Y'AND
(C305 = 'P' or 'F or 'S1
or 'D') AND
C1732 = 'FI' AND
(C1715 = '901' or '902' or
'903' or '904')
C135 = 'Y'AND
(C305 = 'P' or 'F'
or 'D') AND
C1732 = 'FI' AND
C1717GE 10/01/89 AND
C1717 LT 10/01/90
ATA BASE: CERHELP
Ject the number of sites with
rgeted Interagency
greement at a Federal Facility
• any fiscal year 1990 quarter.
DATA BASE: CERCLIS
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.
DATA BASE : CERCLIS
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
SELECTION
CRITERIA
PLANNING DATA
SELECTION
CRITERIA
ACCOMPLISHMENT
DATA SELECTION
CRITERIA
CP202 = 'LA' AND
CP203 = '90' AND
CP206 = 'NL1 AND
(CP1201 = '1 or '2' or '3'
or '4')
C135 NE T1 AND
(C2111 = 'RrOR'FS'
or 'RV') AND
(C2115 = 'A'OR 'B') AND
C2140GE 10/01/89 AND
C2 MOLT 10/01/90 AND
C2140 = FIRST C2140
DATA BASE: CERHELP
Select the number of NPL sites
targeted to be Addressed
for Fiscal year 1990.
DATA BASE: CERCLIS
Select the number fo NPL sites
Addressed for Fiscal year 1990.
E-110
-------
OSWER Directive 9200.3-01C
APPENDIX F
CEPP PROGRAM PLANNING REQUIREMENTS
-------
UNITED STATES ENVIRONMENTAL PROTECTION AGENCY
WASHINGTON, D.C. 20460
0
OFFICE OF
SOLID WASTE AND EMERGENCY RESPONSE
Chemical Emergency Preparedness and Prevention Office
(CEPP)
FY1990 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 SERCs 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 165 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 EPA training
for EPA employees or for EPA contractors will not count towards
meeting this measure.
-------
OFFICE OF SOLID WASTE AND EMERGENCY RESPONSE (OSWER)
CHEMICAL EMERGENCY PREPAREDNESS AND PREVENTION
OFFICE (CEPP)
GENERAL PREPAREDNESS PROGRAMS
FY 1990 SCAP MEASURES AND TARGETS
Program Area:
Objective:
Measure #1 :
Frequency:
Target:
Measure #2
Frequency:
Target:
Earthquake Preparedness Program
Improve Federal, State and local preparedness and
response to those catastrophic earthquakes which
activate the "Plan for Federal Response to a
Catastrophic Earthquake."
Report on the development and completion of: (a)
the Hazardous Materials Annex (ES? #10) to the
multi-agency plan for Federal response to a
catastrophic earthquake for the Region; (b)
risk-area specific sub-plans (if applicable);
(c) planning support provided to other EPA
Regions; and (d) on planning activity developments
in other ESF's for which EPA must provide support.
Q 1, 2, 3, and 4, by Region.
Completion of draft Hazmat Annex by [date to be
determined] for Regions I, II, IV-X; and,
Completion of approved Hazmat Annex by [date to be
determined] for Regions I, II, IV-X;
and,
Report on participation in the following
earthquake preparedness activities (exercises,
simulation, workshops, planning sessions and
other similar earthquake preparedness activities
involving Federal, State or local persons or
governments). «
Q 1, 2, 3 and 4, by Region.
Participation in 2 or more such activities during
the FY.
-------
Program Area; National Security Emergency Preparedness Prog ram
Objective: Improve EPA's preparedness for carrying out its
responsibilities as outlined in E.O. 12656 in the
event of a national security emergency event or
exercise.
Measure #1: Report on participation in the following National
Security Emergency Preparedness (N8EP) activities:
Headquarter's EPA, FEMA or other agency planning
sessions, workshops, training, or exercises; and
on assisting in the development of support
- materials (ie. policy papers, ADP info., etc.)
for the Program.
Frequency: Q 1, 2, 3, and 4, by Region.
Target: Participation in two or more such activities
during the FY.
-------
g.
u
a
u
o
o
0
CO
T
a
CO
E
ki
0
&
rt
. _ o
RESPONSl
Preventi
^* ^J
U C
z m
is to
AND EMER
990
parednes
«- 4)
u x C
f* fc< 0*
CO
< >1
X U
c
Q «
H (Jt
0 «
Eh
O H
u 5
U -H
0 U
e
0
o.
MEASURE
u
^
M
w
GO
O
„
»
rH
piemen ta
the Tit
6 ti
•H 0
H C
M O
c. Title ]
comple ti
°-&
0) 9
3 0
•P ki
(0 •£
to
to
4) 4)
C. **
' j -T!
4J
C W
o
kl
ti §
a*
ON O
£ -H
•r4
4) ^
O -H
C £t
C <0
4) U
m
CM
(N
5
CN
I
Wl
0
c o>
•H C
•H
ffl ft
V 0
^ .-I
4J (I
•H >
> 4>
0 C
0} -H
V TJ
O V
C -P
1C CO
•P -H
(0 0)
•H (0
0) 10
CO
« ki
U 0
•H to
£ §
o a
41 00
4-1
4) TJ
jQ 4)
-H 4J
ki U
O 3
CO -O
4) C
C < (0
a
O
4)
JJ
CO
•O 10
•H U
> 41
O
a
< 10
to
JS 41
U 4J
•H
JS 0
c c
0 TJ
4) 4)
09 *J
"o a
kl -H
4) U
X -H
41 4J
kl
a
ki ki
4) 0
*§ 0 C
3
-------
X
u
z
u
3
g"
A
b
U
8
u
i
a.
u
u
u
s
z
u
>
M
f
U
U
i
^
CO
*
M
*
*•
Oi
•9
1
ft
H
U
e
10
t,
M
CT>
O
U
CM
C
0
•H
4J
§
hi
0
14-1
C
H
0)
0)
(0
a>
rH
0)
£
rH
2
C
a>
•a
•H
u
2
<4-l
O
U
0)
1
3
4J
U
a
0)
a.
0)
x
4J
4-1
3
0
J2
M
nj
c
0
• f4
•u
>0
e
14
0
e
4J
J3
0
0
?
•
(0
0)
03
1)
•H
4)
h
CP
C
•H
>
5
0}
0)
•H
•P
,pj
M
•H
U
>0
U-l
0
4J
4J
C
41
0)
CO
4)
lj
•H
C
0
•H
V
CO
01
g-
^^
04
H
3
*
CO
4J
C
4)
T)
•^4
o
u
(0
i-H
<0
u
•H
41
£
U
1-1
0
a
u
en
3
(0
U
CO
4)
b
3
(0
10
4)
e
c
0
• H
4J
C
4)
>
01
U
a
•o
c
10
*
>,
4J
0)
HJ
10
0)
4J
iH
3
09
01
ti
<0
0]
10
W
4)
•H
4-1
-H
r-t
•H
U
10
X-l
X
A
C
4)
.*
IQ
4-1
^>
ro
^
(N
^
^.
o
in
U
i
4J
U
3
"O
O
o
CO
4J
•H
•o
3
«
>1
4-1
0>
u
10
0)
iH
10
U
•H
g
4)
£
U
«-<
O
u
V
i
3
C
0
4J
U
&
0)
£t
«
•
01
4J
C
4)
•a
•H
o
o
(0
h
(0
10
§
•H
3
0"
o
•H
.C
3
V)
10
0.
w
-------
M
M
M
Cb
W
QJ
rt.
u
o
to
0
•H
Cn
4)
•
C
rH
a
^
y
4)
Cn
•H
4J
c
8
y
±J
0
AJ
TJ
0)
4^
u
9
ts
c
0
u
CO
V
CO
•<-<
y
hi
X
4)
-0
l-t
0)
u
1
— 1
3
14-1
o
a
0
4->
1
4)
JO
10
4J
0)
hi
10
w
u
w
M
i
§
M
H
<
J
3
£
M
w
• CO
4) <0 4) *• 3
CO £ M M • 4J
•rt U 4J MM CO «C
y 4J M M W kJ 4J 4J -fH
U -rt *M H -H 11 4) 03
01 hi O ro 0> 4> .C P 0> >>
co x » e P-I -^ 4J hi e o> M
4) 4) 4)0 -P4-1 >0 *J 0
•^ -P E -H -^ -H hi 3 C rq 4J
4j 4) 0) 0 Cn E- E-i 0 CT « 43 .-H
•H«^3U4) U'tiycOhi
C hi 4J B -P Q! • 14-1 hi (0 hi
30 3 4) 04>4->4>e|MO>
e 4J hi c o hi -o « » o o 4J
§(000 «3 COCB -^
3M-l-H4)COCO 3 3 hi >i Cn X T3
y^H C" £ > ro -P 0 J3 D hi C
10 03 4) 4J 1) 4} reO) U3 « -4 8 -PU 73 B
04)01 -D > CO C 1> 0> (0 1 0>
04>C4)» re£-H 34J
CO -OArflOi-H 4) --I EH ^ - CO rtf
4) hi hi ti « jCrH a*< 4J
4J 4) a 4>^4J 4-> a ahireco
rq -o CO ro B • 3 0
4J 03 -H
4) 0) ro 1) 4) £6 4) O -H C" O 3 > O
.H -H 'H hi B -H 4J C 4J 4J 0 4J
y y a -H D hi 4-i h, -H rehi
ehi 3 js o m to o <« oi -P a to
U D D O1 -P MH -O 4) a !*-i 3 W hi
Cn X £ 1> hi 3 4) rfl C T3 41
ro 01 -P h. C 1) ro 0 hi — < ') hi -H ••* 3 4)
hi co jc -P u ^ e T3 B
JCCJ 0)4j'reO 334)-PC
4) > ^ o > m a to r- j; -H
4>jC<-43\4) 03 4J4)
y 4-1 0 1*^ T3 0 C 0 4) -H k4 rH *
C > C -H ro 4J 4) i 4) C j2 4)
4J -H -H 4J vui a T3-POO -<«
03 3T30 5-rtU-PC-H4J
•H 4) < 4J 4) < as yOiQCQ
03 4^ CL *H ^3 '"H £44 0 S 4) O *H ^ K
W |J W 4J .rt 1C W rH 0 tO 4-1(0
ma co>c vuccro T)
-rt 4) C O 0 rH > 0 -H E C kj
-rt -rt 3 y a O1 C TJ C CO C 0 -H 3
4J 4-1 ^H 4)k4 -rt 4) O M-l 4J
(0 hi y -P 4) « 4) 4)CQS-HC<04)
frBCOy -P hiC Cn-HSJS
a-HCC4)C -rt (0 X 4) hiH
hi X t: CO -3 4J CCUC J3 MH
Cn«Hi— IOIB3 C C 4) ,C 4-> C •
0 4) 3 0 *H C ro 0 X en y *H C
hi > 0 73 tfl -H -rt y hi ro 4) 0
a-^j3 CO W 4J C 4) 4) -O 4) -H
^j (0 ^**^ rtj ^3 £« CO CV S "^ ^ ^
hi U iO rH -rt 4) C" W O > (0 rn
0 * 4J -rt 0) 4) 4J 3 hi -p 0 4J -P
£• Wi jC? & CO O* fl) ft) ^ CO C
<-l04)0)-P 4) fi -P TJ a 0)
(0 4J 6 4J (D 4-> D W ro 4) 4)8
y arOCn^ JS 4J4J4JJS4)
•rthlOEC C 4J rH W 3 O 4-1 rH
c o rH *H *o *H re JQ c a
JC ^^ 4) CV J2i **4 CO y ^ *r^ C S
OT3>U-<3C -rtCOChiCOO-H
1) C 1> C hi O 0 J 0 4J D
4J(0'oreyjC-^ f< •HcoooiM
T3 CO 03 4J Ou Cn 4>) -H 'O C M
01 4) 4) -rt 4) re OCrOT) -rtM
T3 01 W D T-J 4-1 a (34-HrH C 4-1
•rt — i -rt C" u -rt U 73 03 X O hi 4)
>yy -u o u a 3 -rt rH -rt o ^
0 hi hi 1W U a -r4 rH CT> rH tT> Q4 4-1
hi 4) 4) 0 Q 4) 4J W y 41 ro D 4) -rt
a x x QuMhi D c rH c ce w H
4) W X 4) ro t- -rt -rt
o a h, » a <; D CT>
•Pao y^4) EH4J C04I341C
D rH ro C 0> 4) C EH M 3 « rfl ly •-<
a 4) -P -r4 X 01 (0 t/3 jC M 4J m 0 CT
X > -rt T3 4) — ' -P y 4J W S hi 1)
oi oi rH -H i y to MIOOIM a oi
13 -rt > 4J hi -rt H 0) I-H O « CO
oi y o 03 o> co H 4-> a •H'Ocv
hi 0 <0 hi O X CO C -rt 01 *4J £ C £
fl 4J >4-i O, a 4) »0 K-rtE-itiH-i4Jr84J
_3
M
f-(
4J
M
•
co
§
^
u*
0
hi
a
•o
c
rO
10
4)
3
£
•rH
"§
a
r0
y
a
0
-rt
4J
e
^
4)
a
, •
^
10
CO
CO
0)
•o
41
(0
a
41
0^
rove
a
a
•rt
0
4J
0)
co
•H
4J
0>
a
X
0)
14-1
0
o
to
•H
>
0
hi
a
4)
£
4J
01
•H
U
CJ
jg
i^
EH
W
M
J
2
o
M
2
5
W
£H
C
C
•H
10
4J 4J
y
D rH
h iO
•H S
•O hi
O
i£ *W
3° 0)
0 -O
hi 3
£ -I
•P y
•o -H
£ -P
0) 0
> c
*H n
« 0)
•0 0
d)
JQ -tJ
M
4J
' 0\ •
•H CO
« i
o s
1 SJ
CO JS
•H 4J
03 O
0}
(0 hi
0
CO
•H «
-e co
"I
• 03
4) X
y hi
!»
to -
•H «•».
03 4J
to c
ro 4)
•rt
y a
•H -H
14-1 y
•rt 1) •
C C
0) 4) 0)
•H .C S
o 4J a
CO -H
£ 3
T3 4J CT
C -H D
* *
Cn 4J 0
0 hi
hi c a
_ 0)
£ £
4-> C 4->
0 0
j3 -H W
4J 0
CO ro
4) -P 10
•O ^ 4)
3 3 tfl
rH CO hi
yes
coo
•* y U
0
4-1
T3
3
•rt
e
*— i
4J
0
c
CO
•*
4-1
3
^
CO
01
•o
3
r— 1
U
C
•H
4)
y
c
ro
4J
to
CO
to
10
to
.rt
r?
£*
3
I
1
0
4.)
1
4J
JS
•H
^1
^
4J
-H
I
5
y
0
*
c
0
•H
C
0)
1)
a
•h
CO
03
4)
e
1
a
4>
hi
a
en
c
4J
C
4)
E
0)
i— (
1-
•H
TJ
C
m
Cn
c
•H
a
o
1-1
4)
01
^
en •»
C 03
•H 4)
N -H
•r4 4-1
C -H
(0 >
^p *«H
hi 4-1
o y
ro
01 ro
U
C CO
ro B
•P ro
CO kn
CO 0
01 hi
ro a
^
"•
•H
CO
X
1—)
10
c
10
CO
•o
hi
8
40
J3
o>
c
a ^
o y
10 -H C
JK *•» 0
U -rt
0 C0 4J
31 C ro
rfl U
"O rH *iH
V Or C
4J 3
«8 > S
HUE
4) C 0
hi 0) y
1 Cn
O. hi *t
ft 4) CO
W S -rH
U 4) M
Cn 'W W
COO
•H
4J34-I
y oi c
3 -H 0)
•O > B
C 0) 0)
O hi c«
y ro
•o c
T3 C ro
C Q S
«
•P C
Cn C 0
C 4) -H
•H S 4J
N a ro
•rt 0 B
C -H kj
rfl 0) 0
hi 0) C
O T3 -H
C C C
•rt -r4 -rt
0) 0> 01
y y y
c c e
JS JS 3
10 CO CO
CO 00 CO
03 03 03
(0 (0 (0
CO
10
4)
4J
4J
<0
i
N
•0
0
4J
c
0>
!
4)
01
TJ
C
•H
0>
y
c
3
n
CD
03
ro
CO
^
•H
4J
u
4)
•r~i
jQ
. °
s y
4) -it
-P 03
CO ro
X J3
CO
0
C -P
•H
4-> .C
hi 03
•- 0) -H
O> rH 1-1
C ro a
"4 > i
K e o
OH U
•P ID U
•H rH (0
§ * 0
a -H
IQ 4)
jr x;
4J
03
4) C
•H 0
4J
•H CO
iH 4)
•H >
y -H
ro *J
•H
C -P
0 -H
C -H
0
•H C
•P 0
C -H
0) 4-1
4J C
4J 41
4)
•P hi
c a
4)
E 01
0> X
Cn rO
•0 4J
C hi
re 4)
e t3
e
rH 3
0)
> 0
4) 4J
1 E
-C 01
Cn JC
•H 4J
4)
03 4J
3 rfl
y rH
OM
rl
•H
£ ^
C^ CD
^^
c
C "H
O hi
C 3
o y
•H y
•P 0
£ E
M 0
O h*
I4H 1*4
C
4)
0) £
rO
hi 4J
3 C
y oi
y >
<0 4)
u
js a
4->
•rt 0
* -p
< hi
fe2
u
4) i)
T3 03
•iH
> CU
0 4J
U ro
a >
£'a
.•s.
J3
-------
(N
I
12
w
o
u
GGERED REL
^^
a
E-i
^
1^1
14-1
•H
4J
C
0)
T3
•rl
0
4J
TJ
0)
N
•H
r-l
•H
4J
3
Cr>
c
•H
01
ja
CO
u
0>
en
C"
•H
U
4J
U
0
fl
•rl
k4
0)
-P
•rl
l-l
y
0)
•P
«.
>,
rH
4J
C
0)
M
h
3
•
CO
3
0
•H
U
01
co
0)
M
fl
JS
u
•rl
•C
>
CO
01
co
fl
01
i—4
a/
ki
e
0
Cn
c
•rl
CO
3
y
0
U-l
(fl
•H
a.
H
5
• fl
0)
u
fl
(0
0>
CO
f*
V
tJ
'serious •
•
"5
0
•rl
rl
&
£
4J
C
0
B
0)
r-l
01
»
4J
fl
C
•rl
0)
CO
fl
1)
r-l
01
1J
£
4-1
C
5
0>
4J
jC
4J
•H
C7>
—4
•o
c
0)
1
fl
0)
co
fl
0)
r-H
0)
h
£
3
rl
3
0
u
0)
£
4-1
jC
4J
.-(
9
en
o Startin
14-1
0
0)
o
fl
0)
—4.
0)
u
fl
u
0
1
•
CO
JO
l-l
o
o
"
u
0
o
^
•*
^
II
«
en
c
•H
>
fl
jC
co
0>
y
1
CO
A
3
CO
CO
3
0
•o
M
fl
N
fl
A
l-i
0
<4-l
•
CO
X3
i-l
O
O
0
%
*"
c
fl
4-1
u
01
4J
fl
0)
kl
Cn
01
CO
«
0)
r-l
01
h
«c
0
•
CO
3
o
o
o
in
u
0
0
o
o
M
«-
II
&
«
en
•H
>
fl
CO
01
y
a
•U
CO
ja
3
co
(0
0
•o
h
fl
N
fl
u
0
IU
•
CO
£
rH
0
o
o
*
o
*
01
Cn
§
fl
•o
r^
fl
4J
C
0)
E
0
h
*
c
01
0)
IH
8
0)
CO
h
0
•*
>!
rl
3
•ri
C
•rl
%
£
4J
fl
0)
•o
c
•rl
en
•rl
4J
i— 1
3
co
0)
u
01
co
fl
01
l-l
01
w
>1
5
o
•
o
a
o>
5
0)
1
fl
01
u
c
JS
CO
jQ
3
CO
CO
0
'a
M
fl
N
fl
>1
•H
§
0)
E
4J
X
0)
CO
c u
fl at
M
1*4 4
0 Z
z
0) O
CO H
o A re lea
TERS/ QUEST
E-
H
J
0)
5
> IN
< 0
,4
O >i
fi 81
CJ U
in <
o
CO •
01 TJ
3 &
•H O
lj --I
0 01
£ >
•P 0)
3 "0
«
(0
J§2
4J
<
JP&
•H
C 0)
•H M
•9 'H
e fl
0 C
u c
0
-1 -H
0) 4J
•P (0
4J 01
01 3
H cr
fl 0)
4J 4-1
U-l
fl JZ
rl 4J
-O •-!
>
0
4J en
c
"85
to fl
•H
3 «
cr -i
0) 0)
h en
fl
(0 C
•ri n
E
0 *J
•rl C
Cn fl
01 -4
ct a
01 0)
SS
- 0
U 4J
0)
Cft 4J
Cn -H
•rl
hi tJ
-U C
0)
fl CO
JJ V
IS
o
CO OS
fl
.c <«
>< -
4J <
•H s
r-l O
•H
U •
fl 5
U-l <
U
fl
Oi rt
y 2
c <
O CO
•
(0
u
0)
4J
t(
fl
3
cr
73
fl
0)
I
0
4J
4J
C
01
CO
0)
J2
4J
CO
g
response i
>i
4J
0>
14-1
fl
CO
fl
a
0
u
<4-i
0)
4J
•H
co
fl
4J
fl
0)
c
0
•rl
4J
fl
U
0>
04
0
en
c
•H
rH
1
fl
\
CO
CO
0)
y
0
u
a
o>
h
• H
•U
C
01
01
JC
4J
0
r-l
rH
5
CO
fl
•>
C"
c
•rl
e
c
«
r4
o.
>1
y
c
0)
en
c
• rl
•U
c
0
y
TJ
c;
fl
en
•rl
c
•rl
fl
U
4-1
M
4J
C
0)
I
•rl
3
cr
V
>i
4J
•rl
r-l
•H
y
fl
K-l
CO
0>
U
3
•O
0)
y
0
IM
a
>,
4->
01
U
fl
CO
<4-l
0
4J
••H
TJ
fl
C -P
fl C
0)
co E
•rl 4J
•rl
•w e
M B
0
CJ
•
4-' 4J
stand poin
roanagemen
-------
o
z
U
Of
U
os
U,
ement
U
io
z
o
3*
CO
^
•*•
?*!
3
?5
•Li
f
•**
z
^»
U
f /*
Uj
2
^
™ •
3
o
CO
.
..
Li.
U.
0
CL
3
O
C
*
1
JJ
1
JJ
c
fc^
>
o ^
^ft «
^ «2
> 1
^
T3
»u
o
fy
Qj
U
0)
o
1 ,
M
fl\
V
U
U
Q
8
CO
s
a.
w
u
a:
3
CO
^
w
z
U
>
M
£-1
U
U
(^
o
« 0
* ^
n fl
(N CO
^^ ^_
ooa
rH
|
W
o"
Ul
c
o
JJ
«
0
>
0
J3
•M
U)
.0
a
<4-l U-l
O O
•
ui tn T
0 C O
g -H
3 JJ C
C fl O
CT--I
0 -H JJ
£ JJ U
JJ U) 0
0 CO
JJ >
Ui C
06 «
i
0
0
Ui n
0 Ui 0
C *^
0
0 (0 O
£, Ui n
JJ ^*
O CO
aui c
o a o
f-( -H
0 JJ JJ
> C U
000
Q e co
(N
0
n
tfl JJ
C O
O C
•H
JJ 0
U TJ
CO
U
0 C
•H O
J3-H
•*4 ^J
M (0
W -l
O O
(11
0 (N <0
m O
C 0 C
H 0 -H
^M^
A
(N
(H
f^
TJ
C
a
%
r4
r4
O
«
^
O
n
* 0
* jj
o (0
<• JJ
CN CO
«t
••H S*^
CX 03
fN
1
W
o"
tj
0
c
0
TJ •-<
0 CT
•H Q)
M-! cd
•H
JJ 0
C £
0 JJ
TJ
j3
U)
C TJ
O 0
•-* C
0
.a TJ
g «•
son
C n 01
•H
0 C JJ
£ O-H
JJ 0 O
Ul 0 (0
0 M U.
a
0) ^— .
(X (0 £
.
^^
o •».
JJ rt to
o -~~
'•^ f)
c c
0 «-H
C*0 «w
0 0 -H
a
n 0
0 C TJ
C. O 3
JJ -H rH
JJ U
0 U C
JJ 0) -H
CO
TJ -P
0 ^)
r^ fl
*- ±)
(N W
,
O< OQ
n
I
U
Cj"
TJ
(0 C
U it
0
TJ W
O O fl
Ul 0 Ui
0 > 0
£ -H <4J
e jj 0
3 (0 Ui
C Ui
JJ rH
0 CO fl
jC **4 'H
JJ C U
•rH -H
4J g TJ
>H TJ 3
0 < »-3
a
Q) -*^-.
en ,
OCQ
^
I
U
o"
• •
0)
0)
jg
J
07
U
o
JJ
10
rH
O
•H
>
«w
O
Ui
0
e ui
3 O
C
^
0 10
4= e
0
Ui C
o *^
a
0 —
ui tn
o ui
6)
< -H
0. ~H
u a
e
>! O
-Q U
1
U) C
c o
0 C
•H
JJ C
o •-•
(0
TJ
C JJ
0 -H
E 3
0 U
U 0
Ui Ui
0
0 (0
j5
pH
10 0
e jj
Ui (0
O JJ
***l
-Q
f
o
o
(0
a
e
o
u
o
JJ
CT
C
c
3
JJ
0
Ui
-------
OSWER Directive 9200.3-01C
APPENDIX G
CASEL BUDGET
-------
OSWER Directive 9200.3-01C
APPENDIX G
CASE BUDGET
TABLE OF CONTENTS
FINANCIAL PLANNING REQUIREMENTS G-l
CERCLIS Required Data Elements G-l
CERHELP Required Data Elements G-4
RPO AND IMC COORDINATION G-5
AOAFunding 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 SITE
SPECIFIC G-9
Mainframe CERHELP Coding Instructions G-9
WasteLAN CERHELP Coding Instructions G-10
OBLIGATING FUNDS TO COVERCONTRACT
BUYINWORK ASSIGNMENTS G-ll
Mainframe CERCLIS Coding Instructions for Site Information Forms. .G-ll
A Remedial Events G-ll
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 (TASKING)G-IS
A Remedial Events G-15
B Enforcement Events G-16
C Non-Site Specific Incidents G-16
WasteLAN Coding Instructions G-16
-------
OSWER Directive 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. Activity-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
Activity/Event
Plan Start FYQ
CERCLIS Data
Elements
Activity/Event
C1732/C2111
CHOI
C1713/C2132
Activity/Event
Actual Start Date
Activity/Event
Plan Complete FYQ
C1716/C2140
C1715/C2133
Valid Case
Budget Codes
see Exhibit VI-6
2 digit field indicating the
operable unit which
corresponds to the event
system generated based on
the current planned start date
(C1712/C2130)or3digit
code for fiscal year quarter
(YY/Q) entered manually
Actual 6 digit start date
(MM/DD/YY)
system generated based on
the current planned complete
dateC1714/C2131ora3
digit code for fiscal year
quarter (YY/Q) entered
manually
G-l
-------
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 Activity/Event Budget Codes
Activity/Event
Lead C1707/C2117 HE = 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 'G1. For events (e.g., removals, RI/FS, RD/RA, etc.) the code is 'P'.
Activity/Event
Financial Plan FYQ C2905/C3218 3 di git 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 Directive 9200.3-01C
CERCLIS Data
Elements Valid Case
Component Label Activity/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-6). 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 quarterly (e.g., RI/FS
oversight, Section 106 and 107 litigation.)
Activity/Event
Contract Vehicle C2908/C3239 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 =Geotrans
HKR = Hooker
IAG = Interagency
Agreement
MSC = Multi-Site
Cooperative
Agreement
REM = Remedial Planning
and Construction
TES## = TES 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 the 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 Activity/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 Reauired 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 = Geotrans
G-4
-------
OSWER Directive 9200.3-01C
Financial Planned
Obligation FYQ
Financial Fund
Source
Financial Number
of Sites
Financial Amount
Financial Comment
C1415
C1416
C1417
C1420
C1421
HKR = Hooker
IAG = Interagency
Agreement
MSC = Multi-Site
Cooperative
Agreement
REM = Remedial Planning
and Construction
TES = TES Contracts
3 digit code for fiscal year
quarter (YY/Q)
E = Enforcement
3 digit code for number of
sites for which non-site
specific request is made
9 digit code for amount
requested
30 character field to identify
specific requests
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 varies 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 then-
Case Budgets.
AQA 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 release 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-12 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
-------
OSWEK 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 are 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 f> -12 contracts. The
separation of obligations and tasking amounts will accurately reflect utilisation 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 Obligations
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 in CERHELP as "Other".
Coding guidance is included in 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 account" 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 in 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 in the comment field
when PRs are for Enforcement activities. Of course, non-Superfund buy-ins will not be entered in
CERCLIS.
G-6
-------
OSWER Directive 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 actual costs of
tasking the contractors when planned activities started. New CERCLIS reports will be available to
compare total commitments and obligations with total work assignment amounts 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 planned 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 relevant sequence
numbers. RPOs will describe the funding split in the comment field of TES work assignments that
cover multiple events, activities, or operable units. Regional Enforcement budgets 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 (Cl 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 MCs 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
'H1, 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 assignment amounts using
the June system revisions are provided.
G-7
-------
OSWER Directive 9200.3-01C
OBLIGATING FUNDS TO COVER REGIONAL CONTRACT PROGRAM 4
MANAGEMENT WORK ASSIGNMENTS \
At the beginning of each fiscal year, RPOs will write work assi gnments 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 kinds 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 IFMS 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 C1405.
10. Enter the FMS document control number (DCN) from the PR in C1407.
11. Enter 'TES05', 'TES061, 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 C1420.
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 C1425. (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 Activities.
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, i.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 '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.
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 control 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 JJMS 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 CERHELP 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 C1404 for a positive commitment, or 'M1 for a
decommitment (negative amount on PR).
9. Enter the FMS account number (ACN) from the PR in C1405.
10. Enter the FMS document control number (DCN) from the PR in C1407.
G-9
-------
OSWER Directive 9200.3-01C
11. Enter "TES051, "TES061, etc., for the TES contract number in C1408, Contract A
Vehicle. I
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 C1420.
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 C1425.
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 Wastel^AN, then
proceed with step 6, otherwise do steps 5a - 5e.
5a. Select Add New Activity.
5b. Enter 'FE1 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., OH01.
7. Select Financial S ystem.
8. Choose financial type, i.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 '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 Directive 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 financial comment 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 IFMS 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,enforcement activity, or
non-site specific function. The event or activity type will be coded on
the TESWATS form in: Item 10A, 10B, or IOC, respectively.
II. Access the appropriate side of the database, remedial site information,
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 event coding, part B
below for enforcement activity coding, and part C below for non-site specific
coding.
AL Remedial Events
A1. From the work assignment form, Item 6, enter the Site Name [American
Creosote] in C104.
A2. From the work assignment form, Item 7, enter the EPA ID Number
[LAD000239814] in C101. (The RPO may verify 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]inC207.
A6. From the work assignment form, Item 12, enter the work assignment
manager's name [Maria T.] in C2157, Event
Regional Contact.
A7. From the work assignment form, Item 13, enter the phone number [555-
llll]inC2158.
A8. From the work assignment form, Item 9, enter the operable unit number
[01] in CHOI.
A9. From the work assignment form, Item 10A, enter the event type [CO1] 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.
All. Enter a new planned start date, if necessary, based on discussions with the
Regional Project Manager (RPM), in C2130.
A12. Enter a new actual start date, if necessary, based on discussions 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, 'R1, 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.
Bi Enforcement Activities
B1. From the work assignment form, Item 6, enter the Site Name [American
Creosote] in C104.
B2. From the work assignment form, Item 7, enter ithe 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 C1707, 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.
B 8. 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).
BIO. 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
B11. The PR amount will be positive or negative. For a positive number, enter
'A' for obligation; for a negative number, enter TV for deobligation, 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, '£'. 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.
(7,- Non-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 C1404 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 C1407.
CIO. Enter 'TES05', 'TES061, etc., for the TES contract number in C1408,
Contract Vehicle.
Cl 1. Enter '2535' in C1413, Object/Subobject Class.
C12. 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, 'E1. Enter the appropriate source code in C1416, 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
forminC1411.
C17. Enter the last two digits of the amendment number from the TES work
assignment form in C1425.
G-13
-------
OSWIiR Dkective 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 lie/she should enter data for:
Budget Source (e.g., 'R1 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 Dkective 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, site, 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 (e.g., 'R' or '£')
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 (TASKING}
TO BE PAID FROM THE GENERIC OBLIGATION
Each TES work assignment without its own PR will be entered into CERCLIS using the
new codes for TES Work Assignment Amount. The data entry is much the same as for TES buy-
ins, but the new Financial Type codes will be used. Once the RPOs have approved a work
assignment for submittal to the Contract Officer, the Region can enter the work assignment into
CERCLIS. RPOs and IMCs will work together to make sure that all TES financial data is entered
into CERCLIS.
The CERCLIS Mainframe coding instructions are almost identical to those above for buy-
ins.
AI Remedial Events
A14. The work assignment amount will be positive or negative. For a positivenumber,
enter 'H' for work assignment amount; for a negative number, enter 'W to
decrease the work assignment amount, in C3202, Financial Type.
A15. Enter the budget source for Enforcement, 'E', in C3229, Budget Source.
A16. No data entry required.
A17. No data entry required.
A18. From the work assignment form, Item 11, enter the financial amount [15000] in
C3230.
A19. From the work assignment form, Item 14, enter the RPO signature date in C3220.
G-15
-------
OSWER Directive 9200.3-01C
BJ. 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, 'E1, in C2918, Budget Source.
B16. No data entry required.
B17. No data entry required.
GI Non-Site Specific Incidents
C7. Enter financial type 'H1 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', in C1416, Funding Source.
C14. From the work assignment form, Item 14, enter the RFC) signature date in C1418.
C15. From the work assignment form, Item 11, enter the financial amount [15000] in
C1420.
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
-------