Metadata Rubric

100%

6 / 6

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Information about each capture of a fish.

Description

Information about each capture of a fish.

Entity Type
Data Table

Data Attribute / Type	Description
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.
RELEASE_ID NUMBER	Identifies the haul a fish is associated with - from COD_RELEASE data table
FISH_ID NUMBER	Identifies a specific fish, regardless of haul - from COD_FISH data table
FATE_ID NUMBER	Identifies condition of fish – from COD_FATE LUT
FISH_NUMBER NUMBER	Entered by user
LENGTH FLOAT	Length of fish. Measurement units can be found in COD_RELEASE table, FISH_LENGTH_UNIT_ID field
MILT NUMBER	0= Indicates no milt 1= Indicates presence of milt
EGGS NUMBER	0= Indicates no eggs 1= Indicates presence of eggs
DISTANCE_TRAVELED FLOAT	Distance fish traveled from last release (if applicable) Measured in nautical miles. Calculated during trip approval
COUNT_RECAPTURED NUMBER	Number of times fish has been recaptured. See FAQ for more information. Calculated during trip approval
USER_COMMENT VARCHAR2	Miscellaneous comments
LENGTH_UNCERTAIN NUMBER	0= Indicates fish length is accurate 1= Indicates fish length is estimated

Data Attribute / Type

Description

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.

RELEASE_ID
NUMBER

Identifies the haul a fish is associated with - from COD_RELEASE data table

FISH_ID
NUMBER

Identifies a specific fish, regardless of haul - from COD_FISH data table

FATE_ID
NUMBER

Identifies condition of fish – from COD_FATE LUT

FISH_NUMBER
NUMBER

Entered by user

LENGTH
FLOAT

Length of fish. Measurement units can be found in COD_RELEASE table, FISH_LENGTH_UNIT_ID field

MILT
NUMBER

0= Indicates no milt 1= Indicates presence of milt

EGGS
NUMBER

0= Indicates no eggs 1= Indicates presence of eggs

DISTANCE_TRAVELED
FLOAT

Distance fish traveled from last release (if applicable) Measured in nautical miles. Calculated during trip approval

COUNT_RECAPTURED
NUMBER

Number of times fish has been recaptured. See FAQ for more information. Calculated during trip approval

USER_COMMENT
VARCHAR2

Miscellaneous comments

LENGTH_UNCERTAIN
NUMBER

0= Indicates fish length is accurate 1= Indicates fish length is estimated

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

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 Type:	Data Table
Active Version?:	Yes
Schema Name:	CO_OP_RESEARCH
Description:	Information about each capture of a fish.

Attribute Summary

	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

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 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

Table: GMRI_COD_RELEASE_FISH

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

RELEASE_FISH_ID

RELEASE_ID

FISH_ID

FATE_ID

FISH_NUMBER

LENGTH

MILT

EGGS

DISTANCE_TRAVELED

COUNT_RECAPTURED

USER_COMMENT

LENGTH_UNCERTAIN

Catalog Details