Slide Menu
Jump to Section...
Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Northeast Cooperative Research Program (NCRP) > Northeast Regional Cod Tagging Program >

Table: GMRI_COD_RELEASE_FISH

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:34408  |  Updated: August 9, 2022  |  Published / External 

Item Identification

Title: Table: GMRI_COD_RELEASE_FISH
Short Name: GMRI_COD_RELEASE_FISH
Status: Completed
Abstract:

Information about each capture of a fish.
Notes:

Loaded by batch 9211, 08-23-2016 14:45

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: CO_OP_RESEARCH
Description:

Information about each capture of a fish.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 RELEASE_FISH_ID NUMBER Unique ID – identifies a specific fish capture within a haul. A fish will be assigned a different RELEASE_FISH_ID each time it is captured.
100
 RELEASE_ID NUMBER Identifies the haul a fish is associated with - from COD_RELEASE data table
100
 FISH_ID NUMBER Identifies a specific fish, regardless of haul - from COD_FISH data table
100
 FATE_ID NUMBER Identifies condition of fish – from COD_FATE LUT
100
 FISH_NUMBER NUMBER Entered by user
100
 LENGTH FLOAT Length of fish. Measurement units can be found in COD_RELEASE table, FISH_LENGTH_UNIT_ID field
100
 MILT NUMBER 0= Indicates no milt 1= Indicates presence of milt
100
 EGGS NUMBER 0= Indicates no eggs 1= Indicates presence of eggs
100
 DISTANCE_TRAVELED FLOAT Distance fish traveled from last release (if applicable) Measured in nautical miles. Calculated during trip approval
100
 COUNT_RECAPTURED NUMBER Number of times fish has been recaptured. See FAQ for more information. Calculated during trip approval
100
 USER_COMMENT VARCHAR2 Miscellaneous comments
100
 LENGTH_UNCERTAIN NUMBER 0= Indicates fish length is accurate 1= Indicates fish length is estimated

Attribute Details

RELEASE_FISH_ID

CC ID: 345563
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 11
Scale: 0
Status: Active
Description:

Unique ID – identifies a specific fish capture within a haul. A fish will be assigned a different RELEASE_FISH_ID each time it is captured.
General Data Type: NUMBER

RELEASE_ID

CC ID: 345567
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 11
Scale: 0
Status: Active
Description:

Identifies the haul a fish is associated with - from COD_RELEASE data table
General Data Type: NUMBER

FISH_ID

CC ID: 345568
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 11
Scale: 0
Status: Active
Description:

Identifies a specific fish, regardless of haul - from COD_FISH data table
General Data Type: NUMBER

FATE_ID

CC ID: 345569
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 11
Scale: 0
Status: Active
Description:

Identifies condition of fish – from COD_FATE LUT
General Data Type: NUMBER

FISH_NUMBER

CC ID: 345570
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 11
Scale: 0
Status: Active
Description:

Entered by user
General Data Type: NUMBER

LENGTH

CC ID: 345571
Seq. Order: 6
Data Storage Type: FLOAT
Max Length: 22
Required: Yes
Primary Key: No
Precision: 126
Status: Active
Description:

Length of fish. Measurement units can be found in COD_RELEASE table, FISH_LENGTH_UNIT_ID field
General Data Type: FLOAT

MILT

CC ID: 345572
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

0= Indicates no milt 1= Indicates presence of milt
General Data Type: NUMBER

EGGS

CC ID: 345573
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

0= Indicates no eggs 1= Indicates presence of eggs
General Data Type: NUMBER

DISTANCE_TRAVELED

CC ID: 345574
Seq. Order: 9
Data Storage Type: FLOAT
Max Length: 22
Required: No
Primary Key: No
Precision: 126
Status: Active
Description:

Distance fish traveled from last release (if applicable) Measured in nautical miles. Calculated during trip approval
General Data Type: FLOAT

COUNT_RECAPTURED

CC ID: 345564
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 11
Scale: 0
Status: Active
Description:

Number of times fish has been recaptured. See FAQ for more information. Calculated during trip approval
General Data Type: NUMBER

USER_COMMENT

CC ID: 345565
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 1020
Required: No
Primary Key: No
Status: Active
Description:

Miscellaneous comments
General Data Type: VARCHAR2

LENGTH_UNCERTAIN

CC ID: 345566
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

0= Indicates fish length is accurate 1= Indicates fish length is estimated
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 34408
GUID: gov.noaa.nmfs.inport:34408
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-08-23 14:45+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2017-02-24
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2017-02-24
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2018-02-24