Environmental and Disposal Liabilities Intranet Reporting System March

Environmental and Disposal Liabilities Intranet Reporting System March 2006 Training Guide

DOI Environmental Database Training Guide Slides 8 -10 – Register and Login • For Registration or Login assistance contact Renu_Chaudhry@nbc. gov • • Access the Intranet URL http: //ecl. doi. gov Select Login then Register Here Fill out registration form and Submit Access verification will be sent via an email message Slide 11 – User Options, Select as Appropriate • For Database assistance contact kpower@do. usbr. gov • Add a New EDL Site Search for and Edit or Remove an existing site • Run a Report • Route a site for Review and Approval

DOI Environmental Database Training Guide (continued) Slides 12 -21 & 25 – Add a New EDL Site Fill out General Information page (Slides 12 -16) • Fields designated with * are required to move to the next page, but all field are necessary • The Site Description field can be used to identify the problem (e. g. , the contaminants of concern, media affected, problems encountered, etc. ) • The User can add notes by selecting the Add Note button • The User can attach an electronic document (from the Users desk top) by selecting the Attach button

DOI Environmental Database Training Guide (continued) Slides 12 -21 & 25 – Add a New EDL Site Fill out Likelihood page (Slide 17) Select the appropriate liability status: probable, reasonably possible or remote based on the likelihood of a future outflow of resources (costs) • If a future outflow of resources (costs) is probable (likely to occur), select the applicable reason for this designation • If the likelihood is reasonably possible (less that probable but greater than remote) or remote (only slight), indicate if the financial responsibility is Government Acknowledged (GA) – GA sites are rare – Examples include cleanup activities on BIA Trust lands and associated with natural disasters

DOI Environmental Database Training Guide (continued) Slides 12 -21 & 25 – Add a New EDL Site Fill out Estimated Costs page (Slide 18) • Provide a date the last estimate was created or updated • User can provide estimated ranges for interim-action costs (e. g. , Study, Cleanup, LTM) or provide a single amount (single amounts are recorded in the Lower Limit cell) • If the Total Cleanup Cost (bureau’s responsibility) is known, User can record the total costs in the Cleanup cells • Provide an estimated date of completion for each activity (in quarter and year) and the actual date of completion (when known) • Provide some general information on the quality of the estimate (select from pull-down lists)

DOI Environmental Database Training Guide (continued) Slides 12 -21& 25 – Add a New EDL Site Fill out Liability page (Slide 19) • List known Responsible Parties (RPs) (other than self) • Record the percentage (if known) of the total cleanup costs (including all RPs) for which the bureau is responsible – The amount recorded on the Estimated Costs page is the costs for which the bureau is responsible – If the percentage has not been determined, default to 100% • Review Summary page, and if correct, route site for Review/Approval (Slide 25)

DOI Environmental Database Training Guide (continued) Slides 22 -25 – Revise/Edit or Remove an EDL Site • Select Search/Edit • Revise/Edit an existing EDL Site – Select Site Code to access the General Info, Likelihood, Estimated Costs, and Liability pages – Edit as appropriate – Route for Review/Approval (Slide 25) • Remove an EDL Site from the inventory (Slides 23 -24) – Select Remove Site button – Document reason for removing site (attach closure documents (e. g. , No-Further-Action letter), if available Slide 26 – Reviewers and Approvers direct access to changed EDL Sites Slides 27 -30 – Run a Report Slides 31 -32 – Complete the Process

OEPC Environmental and Disposal Liability Reporting Homepage http: //ecl. doi. gov XXX 8

EDL Reporting Login First Time User select Register Here

First Time Users Registration • Fill Out • Select the appropriate User Access – • Submit 10

EDL User Options After completing User Registration and logging in for the first time, the User will be presented with 6 options 1. 2. 3. 4. 5. 6. New EDL Site Search / Edit Reporting Review / Approval Admin Workgroup

New EDL Site - Select Facility and Region If the new site is within an existing facility or add new facility name 12

New EDL Site - Select Site Type The Site Type field allows users to identify other comparable EDLs

New EDL Site - Select Affected Media, COCs Select Affected Media and up to four Potential Primary Contaminants of Concern (COCs), in order of importance. Quick access to specific chemicals by repeating the first letter (e. g. , p, p, p…) 14

New EDL Site - Select Site Stage The Cleanup progress can be tracked by the Cleanup Stage

Provide a short description of the site

New EDL Site – Likelihood - Probable Agreements/documents can be attached and stored in database 17

Estimated Costs Page User can download the Cost Estimate Documentation Sheet to their desktop by selecting this link option Provides a level of confidence in the cost estimate 18

New EDL Site - Shared Liability Documents Responsible Parties 25, 000 30, 000 19

EDL Site - Add Note Button Allows user to document pertinent site information, such as the site problem (e. g. , PCBs in soil from past transformer storage), etc. 20

EDL Site - Attach Document User can attach Cost Estimate Documentation Sheet (if completed), or other pertinent documents including: • RI Summary • Site Map • Study Results • Contractor cost estimates • NFA Letter Adds an electronic document from your desktop directory 21

To edit or remove a site From the EDL Inventory, search for site by selecting the applicable Region, or typing in the Site Code (if known) and Select Search Pull down Region Type in Site Code (if Known) Select Search 22

To Remove a site (work completed) select Remove Site To edit a site select the Site Code Then edit applicable pages (slides 12 -21)

EDL Site –Remove From Inventory Archiving an EDL Site will remove it from the EDL Inventory list for the current quarter as well as all future quarters. Only users with administrative privileges can un-Archive an EDL site. 24

Route Site For Review and Approval When all edits are completed, review the Summary Page and if correct, Route for Review and Approval from bureau administrative personnel

Bureau Reviewers and Administrators can access changed EDL Sites directly by selecting the Review/Approval Button Approval My Facility / My Site

USER OPTIONS - Reports Choose EDL reports from the following sections: 1. EDL Site Details 2. EDL Cost Summaries 3. EDL Site Statistics 4. Multi-listed EDL Sites 27

Create a Custom Report 28

USER OPTIONS - Reports Example: Cost Sum By Bureau Quick access to Quarterly Reports Report results removed for confidentiality

USER OPTIONS - Reports Example: EDL Quarter Variance Report Easy Access to Variance Reports Report Results Removed for Confidentiality 30

Complete the Process Fill out an Evaluation Form to provide essential feedback Remember to Logout after completing the Evaluation Form

Fill out an Evaluation Form and Submit then Logout Environmental and Disposal Liability

Review/Approve or Unroute a Removed Site Bureau Admin approves EDL Site Removal Reviewers and Bureau Admin can Unroute EDL Site for additional edits or if Site should NOT be Removed from active Site list 33 33