Show new navigation
On
  • Help
    • Help
    • Help Center
    • Data dictionary
    • EF&W Program documents
    • Request support
    • Send feedback
      • View all help topics
Columbia Basin Fish and Wildlife Program Columbia Basin Fish and Wildlife Program
  • Mitigation work
    Mitigation work View all mitigation work topics
  • Reporting
    Reporting View all reporting topics
  • Funding
    Funding View all funding topics
  • Search
View Work Elements Available in FY:

Summary

This page presents detailed associations and definitions for this Work Element. Information on how this Work Element is being used in BPA field work is also included.

<<
<
>
>>
Work Element 160: Create/Manage/Maintain Database - Published

Basics

WE Name:
160. Create/Manage/Maintain Database (Manage Database)
Work Category:
RM & E and Data Management
WE Agreement Type:
Contracted
Status:
Active
Owner:
Russell Scranton
Definition:
Any work that maintains or improves the security, quality, accessibility, or utility of data. Includes creation of relational databases; creation of computer applications to manage data, creation of standardized data formats, management of the data within the database, database hardware/software maintenance and improvement, QA/QC, building and maintaining connectivity with interrelated applications (e.g., GIS), integrating with distributed information management systems using industry standards for discovery (i.e., web portals) and creation of metadata/documentation and user-support materials for the consolidated data, etc. This applies both to larger regional, secondary databases and to local primary databases (can include spreadsheets) maintained on desktops for individual projects. Does not include generation of data queries or reports, except for internal data management and QA.
WSE Description Template:
Effective Dates:
FY2005 to <no end date>
Work Phase:
monitoring/evaluation
Sort Sequence:
13.06
Focal Species Required:
No
RM&E Metadata Required:
Yes
Finite or Recurring:
Recurring
Is BPA Internal:
No
Is Contracted:
Yes
Is Cost Share:
No
Is Construction:
No

Back To Top

Note

None



Back To Top

Associated Work Elements


Back To Top

Potential Deliverables

Deliverable Status:
Required
Default Deliverable Desc:
Data
Potential Deliverables:

Back To Top

Rules and Examples

  • Rule 1 (Metrics): Use this work element when the effort/cost of creating, managing, or maintaining a database is significant relative to the purpose of the data collection itself. Otherwise, database work could be a milestone under the work element associated with the purpose (usually 157. Collect/Generate/Validate Field and Lab Data).

    Examples:

    Option 1 (lumping):

    WE: 157. Collect/Generate/Validate Field and Lab Data
    WE Title: Redd surveys for bull trout
    WE Description: Survey 6 miles of Cold Creek and 12 index reaches in Fast River for bull trout redds. Submit data to quality control measures and enter redd locations in database.

    Option 2 (splitting):

    WE: 157. Collect/Generate/Validate Field and Lab Data
    WE Title: Redd surveys for bull trout
    WE Description: Survey 6 miles of Cold Creek and 12 index reaches in Fast River for bull trout redds.

    WE: 160. Create/Manage/Maintain Database
    WE Title: Improve database for bull trout
    WE Description: Create database and migrate old spreadsheet info to new database, improve standardized data format for bull trout data, provide quality control of data, and enter current season's redd locations in database.


Back To Top

Milestones

None


Back To Top

Metrics

2 Metrics Associated With Work Element 160: Create/Manage/Maintain Database

Metric Metric Association Status Last Comment Date Last Comment By Unit Type FY Start FY End Required / Optional Is Activated By Default Included in PI Supports PCSRF/PNSHP (Katz) PNSHP Metric Code PNSHP Metric
1464: Primary R, M, and E Focal Strategy [Population Status, Hydrosystem, Tributary Habitat, Estuary/Ocean, Harvest, Hatchery, Predation, Multiple Strategies] Active RMEFocalAreaList 2022 Required Yes No No
1495: Secondary R, M, and E Focal Strategy [Population Status, Hydrosystem, Tributary Habitat, Estuary/Ocean, Harvest, Hatchery, Predation, Multiple Strategies] Active RMEFocalAreaList 2022 Required Yes No No

Back To Top

Measures by Metric

None


Back To Top

CBFish Metric Sets

None


Back To Top

PCSRF/PNSHP (Katz)

Supports PCSRF/PNSHP (Katz):

No


Back To Top

Location Requirements

Location Requirement Type:
No Location

Back To Top

Environmental Compliance

Applicability and status of the following environmental compliance requirements can be found on the Environmental Compliance tab for that work element in your SOW for all 2007 contracts forward. BPA's Environmental staff will update and maintain this information in CBFish in real time, so that you can check the status of environmental compliance on your project at any time.

Note: Many of the fields are set to auto-load in CBFish, but the settings will be reviewed by BPA's Environmental staff prior to the contract being finalized, and may be revised depending on the specific circumstances.

  • National Environmental Policy Act (NEPA)
    NEPA coverage for this work element will be determined by BPA's Environmental staff and could include an Environmental Impact Statement (EIS), Environmental Assessment (EA), Record of Decision to an existing EIS, or Categorical Exclusion.

  • Endangered Species Act (ESA)
    ESA consultation is typically not required for this work element.

  • National Historic Preservation Act (NHPA)
    NHPA Section 106 consultation is typically not required for this work element.

  • Public Involvement
    Public involvement is typically not required for this work element.


Back To Top

Usage

Reports that Use this Work Element

This work element and its metrics are used in measures in the following reports. These PDF reports are generated dynamically, always showing you the most up to date information. Most of them also have links to download the underlying data sets to structured text or Excel format.

Stats and Overview

Number of active contracts using Work Element #160 by FY

Top 5 BPA Project Managers using this Work Element:
(by number of current contracts)
Virgil Watts III 169
Tracy Hauser 92
Deborah Docherty (Inactive) 74
Carlos Matthew 72
Russell Scranton 52
Average Work Element Budget: $56,517
Average Duration: 11 months

Back To Top