Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Northeast Cooperative Research Program (NCRP) > Gulf of Maine Cooperative Bottom Longline Surve... >

LL_BIOSAMPLING

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

Item Identification

Title:	LL_BIOSAMPLING
Short Name:	LL_BIOSAMPLING
Status:	Completed
Abstract:	Biological data for individual organisms

Entity Information

Entity Type:	Data Table
Active Version?:	Yes
Description:	Biological data for individual organisms

Data Attributes

Attribute Summary

	Name	Type	Description
100	CRUISE	NUMBER	Unique numerical code for each cruise. Specific to a vessel and season. Five digits, where first 2 digits indicate vessel, next 2 year, last digit season. For example 24142 = Tenacious II 2014 fall survey or 25151 = Mary Elizabeth 2015 spring survey. If last digit = 3 it is an experimental survey trip
100	STATION	NUMBER	Unique sequential order in which stations have been completed, unique to each cruise code. Failed gear deployments each receive a non-repeated consecutive number.
100	COMMON_NAME	VARCHAR2	A standard common name which represents a species caught. Refer to the SVDBS.SVSPECIES_LIST
100	SVSPP	NUMBER	A standard code which represents a species caught. Refer to the SVDBS.SVSPECIES_LIST
100	LENGTH	NUMBER	Measured length of species in millimeters (mm). Measure method differs by species.
100	WEIGHT	NUMBER	Weight of the current organism (kg)
100	SEX	NUMBER	Code indicating sex of fish or invertebrate species. See SVDBS.FSCS_SEX_CODES. Codes 0, 1, 2 and 4 are the only valid codes in fscs tables.
100	MATURITY	VARCHAR2	Stage of maturation of the organism being sampled. See SVDBS.FSCS_MATURITY_CODES. For skates see FSCS2.ORGANISM_ACTION_PARAMETERS.ORGANISM_ACTION_ID = 356 AND 357
100	FISH_ID	NUMBER	Unique numerical code assigned to age samples taken from a specimen
100	GONAD_WT	NUMBER	Weight of both gonads of the current organism (g)
100	LIVER_WT	NUMBER	Weight of the liver of the current organism (g)
100	GUTTED_WT	NUMBER	Weight of the current organism with organs removed (kg)
100	COMMENTS	VARCHAR2	Comments associated with the current organism
100	AGE	NUMBER	Age of specimen in years
100	EST_LENGTH	VARCHAR2	Binary indicator of whether the length of an organism was measured (N) or estimated by otolith back-calculation (Y)
100	AUDIT_FLAG	VARCHAR2	Binary flag that indicates a data issue was identified during the audit (if = Y), with details provided in the comments field. It may indicate a data field that is not recommended for use in analysis.

Name

Type

Description

100

CRUISE

NUMBER

Unique numerical code for each cruise. Specific to a vessel and season. Five digits, where first 2 digits indicate vessel, next 2 year, last digit season. For example 24142 = Tenacious II 2014 fall survey or 25151 = Mary Elizabeth 2015 spring survey. If last digit = 3 it is an experimental survey trip

100

STATION

NUMBER

Unique sequential order in which stations have been completed, unique to each cruise code. Failed gear deployments each receive a non-repeated consecutive number.

100

COMMON_NAME

VARCHAR2

A standard common name which represents a species caught. Refer to the SVDBS.SVSPECIES_LIST

100

SVSPP

NUMBER

A standard code which represents a species caught. Refer to the SVDBS.SVSPECIES_LIST

100

LENGTH

NUMBER

Measured length of species in millimeters (mm). Measure method differs by species.

100

WEIGHT

NUMBER

Weight of the current organism (kg)

100

SEX

NUMBER

Code indicating sex of fish or invertebrate species. See SVDBS.FSCS_SEX_CODES. Codes 0, 1, 2 and 4 are the only valid codes in fscs tables.

100

MATURITY

VARCHAR2

Stage of maturation of the organism being sampled. See SVDBS.FSCS_MATURITY_CODES. For skates see FSCS2.ORGANISM_ACTION_PARAMETERS.ORGANISM_ACTION_ID = 356 AND 357

100

FISH_ID

NUMBER

Unique numerical code assigned to age samples taken from a specimen

100

GONAD_WT

NUMBER

Weight of both gonads of the current organism (g)

100

LIVER_WT

NUMBER

Weight of the liver of the current organism (g)

100

GUTTED_WT

NUMBER

Weight of the current organism with organs removed (kg)

100

COMMENTS

VARCHAR2

Comments associated with the current organism

100

AGE

NUMBER

Age of specimen in years

100

EST_LENGTH

VARCHAR2

Binary indicator of whether the length of an organism was measured (N) or estimated by otolith back-calculation (Y)

100

AUDIT_FLAG

VARCHAR2

Binary flag that indicates a data issue was identified during the audit (if = Y), with details provided in the comments field. It may indicate a data field that is not recommended for use in analysis.

Attribute Details

CRUISE

CC ID: 363133

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Unique numerical code for each cruise. Specific to a vessel and season. Five digits, where first 2 digits indicate vessel, next 2 year, last digit season. For example 24142 = Tenacious II 2014 fall survey or 25151 = Mary Elizabeth 2015 spring survey. If last digit = 3 it is an experimental survey trip
General Data Type:	NUMBER

STATION

CC ID: 363134

Seq. Order:	2
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	0
Status:	Active
Description:	Unique sequential order in which stations have been completed, unique to each cruise code. Failed gear deployments each receive a non-repeated consecutive number.
General Data Type:	NUMBER

COMMON_NAME

CC ID: 363135

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	A standard common name which represents a species caught. Refer to the SVDBS.SVSPECIES_LIST
General Data Type:	VARCHAR2

SVSPP

CC ID: 363136

Seq. Order:	4
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	0
Status:	Active
Description:	A standard code which represents a species caught. Refer to the SVDBS.SVSPECIES_LIST
General Data Type:	NUMBER

LENGTH

CC ID: 363137

Seq. Order:	5
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Measured length of species in millimeters (mm). Measure method differs by species.
General Data Type:	NUMBER

WEIGHT

CC ID: 363138

Seq. Order:	6
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	3
Status:	Active
Description:	Weight of the current organism (kg)
General Data Type:	NUMBER

SEX

CC ID: 363139

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Code indicating sex of fish or invertebrate species. See SVDBS.FSCS_SEX_CODES. Codes 0, 1, 2 and 4 are the only valid codes in fscs tables.
General Data Type:	NUMBER

MATURITY

CC ID: 363140

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Stage of maturation of the organism being sampled. See SVDBS.FSCS_MATURITY_CODES. For skates see FSCS2.ORGANISM_ACTION_PARAMETERS.ORGANISM_ACTION_ID = 356 AND 357
General Data Type:	VARCHAR2

FISH_ID

CC ID: 363141

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	8
Scale:	0
Status:	Active
Description:	Unique numerical code assigned to age samples taken from a specimen
General Data Type:	NUMBER

GONAD_WT

CC ID: 363142

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	1
Status:	Active
Description:	Weight of both gonads of the current organism (g)
General Data Type:	NUMBER

LIVER_WT

CC ID: 363143

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	1
Status:	Active
Description:	Weight of the liver of the current organism (g)
General Data Type:	NUMBER

GUTTED_WT

CC ID: 363144

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	1
Status:	Active
Description:	Weight of the current organism with organs removed (kg)
General Data Type:	NUMBER

COMMENTS

CC ID: 363145

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	255
Required:	No
Primary Key:	No
Status:	Active
Description:	Comments associated with the current organism
General Data Type:	VARCHAR2

AGE

CC ID: 363146

Seq. Order:	14
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Age of specimen in years
General Data Type:	NUMBER

EST_LENGTH

CC ID: 712587

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Binary indicator of whether the length of an organism was measured (N) or estimated by otolith back-calculation (Y)

AUDIT_FLAG

CC ID: 712588

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Binary flag that indicates a data issue was identified during the audit (if = Y), with details provided in the comments field. It may indicate a data field that is not recommended for use in analysis.

Catalog Details

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