Sockeye Fish Tags in the Columbia and Snake River Basins
Entity (ENT) | Northwest Fisheries Science Center (NWFSC)GUID: gov.noaa.nmfs.inport:36789 | Updated: August 9, 2022 | Published / External
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
|
|
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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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: | 2022-08-09 17:11+0000 |
| Metadata Record Published: | 2018-02-27 |
| Owner Org: | NWFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2018-02-27 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2019-02-27 |