Show new navigation
On
  • Help
    • Help
    • How Do I?
    • Why Do I?
    • 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
Back to SOW

This page provides details of the selected work element.

Work Element Summary PDF
Select a work element:

Contract Number:
40672
Contract Title:
2003-017-00 EXP ISEMP-ENVIRONMENTAL DATA SVCS
Contract Start Date:
12/1/2008
Contract End Date:
11/30/2009
WE ID:
160. Create/Manage/Maintain Database
Work Element Usage Report
Title:
F: 160 - ISEMP Data Management System Updates
Description:
The flow of information within the ISEMP data management system requires updates to protocols, data dictionaries, and data entry functions. Additionally, data must be validated at multiple stages within the ATM and formatted for submission to the STEM Databank. This work must be coordinated within and across pilot basins. Under this work element, Environmental Data Services will perform required system updates, develop queries to support data validation, and ensure consistency of work flow across pilot basins.
WE Agreement Type:
Contracted
Deliverable Specification:
Updates and modifications to the schema, forms, queries, or code in the Aquatic Resources Schema or the Automated Template Module as errors or bugs are identified during testing.
WSE Effective Budget:
$40,252
% of Total WSE Effective Budget:
22.34%
WSE Start:
12/01/2008
WSE End:
11/30/2009
WSE Completion:
11/30/2009
WSE Progress:
Concluded
WSE ID Continued From:
n/a
WSE ID Continued To:
n/a
Finite or Recurring:
Recurring

Back To Top

Budget History

SOWRevision Planned Updated Contractor Comments (optional) BPA Comments (optional)
1. 40672 (12/01/2008 - 11/30/2009) $24,000 $40,252
Work Element Budget (Current Performance Period) $24,000 $40,252

Back To Top

Milestones

5 Milestones
Sort Type Title Start End Status Modified By Modified Date
A System updates following the 2003-2007 data load process 12/1/2008 2/28/2009 Concluded Barbara Shields (Inactive) 8/13/2009 8:33:21 AM
Description: Updates to the Aquatic Resources Schema or the Automated Template Module to test and document data quality as data are migrated to the STEM Databank.
B Data validation for 2008 data load process 12/1/2008 11/30/2009 Concluded Barbara Shields (Inactive) 8/13/2009 8:33:21 AM
Description: Perform validation and transformation of the Wenatchee 2008 field data.
C Coordination for documenting 2009 protocols 3/1/2009 8/31/2009 Concluded Barbara Shields (Inactive) 8/13/2009 8:33:21 AM
Description: Coordination with ISEMP Monitoring Coordinators and Data Stewards to ensure proper documentation of 2009 protocols.
D Data validation for 2009 data load process 9/1/2009 11/30/2009 Concluded Barbara Shields (Inactive) 8/13/2009 8:33:21 AM
Description: Perform validation and transformation of the 2009 field data.
E DELIV ISEMP Data Management System Updates 11/30/2009 Concluded Barbara Shields (Inactive) 8/13/2009 8:33:21 AM
Description: Updates and modifications to the schema, forms, queries, or code in the Aquatic Resources Schema or the Automated Template Module as errors or bugs are identified during testing.

Back To Top

Metrics

Implementation Metrics
None

Back To Top

Location

None
Back To Top

Focal Species

This work element does not require Focal Species
Back To Top

Environmental Compliance

This work element does not require Environmental Compliance
Back To Top

RM&E Metadata

Data Repositories:
""

Back To Top