PIT Tag Details
Entity (ENT) | Northwest Fisheries Science Center (NWFSC)GUID: gov.noaa.nmfs.inport:36835 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | PIT Tag Details |
---|---|
Short Name: | PIT Tag Details |
Status: | Planned |
Abstract: |
Tag details for PIT tagged fish detected in estuary wetland channels from juvenile salmon. |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | PARR |
Description: |
Tag details for PIT tagged fish detected in estuary wetland channels from juvenile salmon. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
tag id | VARCHAR2 | The hexadecimal identification number of the passive integrated transponder tag. | |
100
|
tag file id | VARCHAR2 | The name of the tagging file that was upload to the regional database, PTAGIS. | |
100
|
tag date | DATE | The Date when fish were tagged. | |
100
|
tag site | VARCHAR2 | The location where fish were tagged. | |
100
|
release date | DATE | The Date when fish were released. | |
100
|
release site | VARCHAR2 | The location where fish were released. | |
100
|
migration year | NUMBER | The year in which fish were expected to migrate to the ocean. | |
100
|
organization | VARCHAR2 | The abbreviation for the agency or organization performing the tagging. | |
100
|
coordinator id | VARCHAR2 | The identification code for the person in charge of the tagging project. | |
100
|
huc code | NUMBER | The hydrologic unti code. | |
100
|
river km | NUMBER | The river kilometer where the fish were released. | |
100
|
sequence number | NUMBER | An automatically generated number to indicate in what order fish were tagged. | |
100
|
species | NUMBER | The species code of fish tagged. | |
100
|
run | NUMBER | The run code of fish tagged. | |
100
|
rear type | VARCHAR2 | The rear type code of fish tagged. | |
100
|
length | NUMBER | The fork lenth (mm) of fish tagged. | |
100
|
weight | NUMBER | The weight (g) of fish tagged. | |
100
|
flags | VARCHAR2 | This field indicates if a particular fish had a certain attribute predefined by PTAGIS. | |
100
|
session message | VARCHAR2 | This field describes the tagging study. | |
100
|
tagger | VARCHAR2 | The last name and first initial of person tagging the fish. | |
100
|
capture method | VARCHAR2 | The method of capturing the fish. | |
100
|
tag temp | NUMBER | The water temperature at the time of tagging (C). | |
100
|
tag comments | VARCHAR2 | A field where additional comments can be added. |
Attribute Details
tag id
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
The hexadecimal identification number of the passive integrated transponder tag. |
General Data Type: | VARCHAR2 |
tag file id
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The name of the tagging file that was upload to the regional database, PTAGIS. |
General Data Type: | VARCHAR2 |
tag date
Seq. Order: | 3 |
---|---|
Data Storage Type: | DATE |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The Date when fish were tagged. |
General Data Type: | DATE |
tag site
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The location where fish were tagged. |
General Data Type: | VARCHAR2 |
release date
Seq. Order: | 5 |
---|---|
Data Storage Type: | DATE |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The Date when fish were released. |
General Data Type: | DATE |
release site
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The location where fish were released. |
General Data Type: | VARCHAR2 |
migration year
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The year in which fish were expected to migrate to the ocean. |
General Data Type: | NUMBER |
organization
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The abbreviation for the agency or organization performing the tagging. |
General Data Type: | VARCHAR2 |
coordinator id
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The identification code for the person in charge of the tagging project. |
General Data Type: | VARCHAR2 |
huc code
Seq. Order: | 10 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The hydrologic unti code. |
General Data Type: | NUMBER |
river km
Seq. Order: | 11 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The river kilometer where the fish were released. |
General Data Type: | NUMBER |
sequence number
Seq. Order: | 12 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
An automatically generated number to indicate in what order fish were tagged. |
General Data Type: | NUMBER |
species
Seq. Order: | 13 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The species code of fish tagged. |
General Data Type: | NUMBER |
run
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The run code of fish tagged. |
General Data Type: | NUMBER |
rear type
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The rear type code of fish tagged. |
General Data Type: | VARCHAR2 |
length
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The fork lenth (mm) of fish tagged. |
General Data Type: | NUMBER |
weight
Seq. Order: | 17 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The weight (g) of fish tagged. |
General Data Type: | NUMBER |
flags
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
This field indicates if a particular fish had a certain attribute predefined by PTAGIS. |
General Data Type: | VARCHAR2 |
session message
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
This field describes the tagging study. |
General Data Type: | VARCHAR2 |
tagger
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The last name and first initial of person tagging the fish. |
General Data Type: | VARCHAR2 |
capture method
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The method of capturing the fish. |
General Data Type: | VARCHAR2 |
tag temp
Seq. Order: | 22 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The water temperature at the time of tagging (C). |
General Data Type: | NUMBER |
tag comments
Seq. Order: | 23 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
A field where additional comments can be added. |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 36835 |
---|---|
GUID: | gov.noaa.nmfs.inport:36835 |
Metadata Record Created By: | Jeffrey W Cowen |
Metadata Record Created: | 2017-02-16 19:25+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 |