Slide Menu
Search Help Show/Hide Menu

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

Rubric Score Primary Key? 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

CC ID: 733413
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

CC ID: 733414
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

CC ID: 733415
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

CC ID: 733416
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

CC ID: 733417
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

CC ID: 733418
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

CC ID: 733419
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

CC ID: 733420
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

CC ID: 733421
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

CC ID: 733422
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

CC ID: 733423
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

CC ID: 733424
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

CC ID: 733425
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

CC ID: 733426
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

CC ID: 733427
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

CC ID: 733428
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

CC ID: 733429
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

CC ID: 733430
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

CC ID: 733431
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

CC ID: 733432
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

CC ID: 733433
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

CC ID: 733434
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

CC ID: 733435
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: 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