Slide Menu
Search Help Show/Hide Menu

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

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