Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Sockeye Fish Tags in the Columbia and Snake River Basins
Short Name: Sockeye Fish Tags in the Columbia and Snake River Basins
Status: Planned
Abstract:

This table contains information about tagged fish and their release information for sockeye salmon in the Columbia and Snake River basins.

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Schema Name: PARR
Description:

This table contains information about tagged fish and their release information for sockeye salmon in the Columbia and Snake River basins.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
TAG_ID NUMBER Unique identifier for each tagged fish, generated for data connection purposes only.
100
SERIAL_NUM VARCHAR2 unique identifier for each tagged fish per year, based on channel and code of the radiotag and a letter.
100
PIT_TAG VARCHAR2 Code of PIT (passive integrated transponder) tag inserted into the fish upon tagging.
100
SPECIES VARCHAR2 Fish species tagged in this instance.
100
STUDY_YEAR NUMBER calendar year in which fish were tagged and tracked for the study. Units for values are year (YYYY).
100
TAGDATE DATE Date and time when the fish was tagged.
100
RELDATE DATE Date and time when the fish was released into the river.
100
RELEASE_SITE_ID NUMBER Unique identifier indicating the site at which the fish was released, for data connection purposes.
100
LENGTH NUMBER Fork length of the tagged fish. Units for values are millimeters (mm).
100
WEIGHT NUMBER Weight of the tagged fish. Units for values are grams (g).

Attribute Details

TAG_ID

CC ID: 731688
Seq. Order: 1
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Unique identifier for each tagged fish, generated for data connection purposes only.

General Data Type: NUMBER

SERIAL_NUM

CC ID: 731689
Seq. Order: 2
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

unique identifier for each tagged fish per year, based on channel and code of the radiotag and a letter.

General Data Type: VARCHAR2

PIT_TAG

CC ID: 731690
Seq. Order: 3
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Code of PIT (passive integrated transponder) tag inserted into the fish upon tagging.

General Data Type: VARCHAR2

SPECIES

CC ID: 731691
Seq. Order: 4
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Fish species tagged in this instance.

General Data Type: VARCHAR2

STUDY_YEAR

CC ID: 731692
Seq. Order: 5
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

calendar year in which fish were tagged and tracked for the study. Units for values are year (YYYY).

General Data Type: NUMBER
Unit of Measure: year (YYYY)
Format Mask: YYYY

TAGDATE

CC ID: 731693
Seq. Order: 6
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Date and time when the fish was tagged.

General Data Type: DATE
Format Mask: YYYY-MM-DDTHH:mi:ss

RELDATE

CC ID: 731694
Seq. Order: 7
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Date and time when the fish was released into the river.

General Data Type: DATE
Format Mask: YYYY-MM-DDTHH:mi:ss

RELEASE_SITE_ID

CC ID: 731695
Seq. Order: 8
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Unique identifier indicating the site at which the fish was released, for data connection purposes.

General Data Type: NUMBER

LENGTH

CC ID: 731696
Seq. Order: 9
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Fork length of the tagged fish. Units for values are millimeters (mm).

General Data Type: NUMBER
Unit of Measure: millimeters (mm)

WEIGHT

CC ID: 731697
Seq. Order: 10
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Weight of the tagged fish. Units for values are grams (g).

General Data Type: NUMBER
Unit of Measure: grams (g)

Catalog Details

Catalog Item ID: 36789
GUID: gov.noaa.nmfs.inport:36789
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2017-02-13 16:57+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2018-02-27
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2019-02-28