Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Table contains the length data for each station

Description

Table contains the length data for each station

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
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
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.
SVSPP
NUMBER
A standard code which represents a species caught. Refer to the SVDBS.SVSPECIES_LIST
COMMON_NAME
VARCHAR2
A standard common name which represents a species caught. Refer to the SVDBS.SVSPECIES_LIST
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.
LENGTH
NUMBER
Measured length of an individual in centimeters (cm). Measure method differs by species
ENTRY_ORDER
NUMBER
Order in which fish were measured or entered into the field computer.
NOTES
VARCHAR2
Comments related to the measurement of the individual organism's length.
VESSEL
NUMBER
Two digit code for the vessel on which the organism was collected and measured. Matches with code in LL_STATION.CRUISE. Values are 24 = Tenacious II or 25 = Mary Elizabeth
EST_LENGTH
VARCHAR2
Binary indicator of whether the length of an organism was measured (N) or estimated by otolith back-calculation (Y)
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.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: LL_LENGTH
Short Name: LL_LENGTH
Status: Completed
Abstract:

Table contains the length data for each station

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

Table contains the length data for each station

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
SVSPP NUMBER A standard code which represents a species caught. Refer to the SVDBS.SVSPECIES_LIST
100
COMMON_NAME VARCHAR2 A standard common name which represents a species caught. Refer to the SVDBS.SVSPECIES_LIST
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
LENGTH NUMBER Measured length of an individual in centimeters (cm). Measure method differs by species
100
ENTRY_ORDER NUMBER Order in which fish were measured or entered into the field computer.
100
NOTES VARCHAR2 Comments related to the measurement of the individual organism's length.
100
VESSEL NUMBER Two digit code for the vessel on which the organism was collected and measured. Matches with code in LL_STATION.CRUISE. Values are 24 = Tenacious II or 25 = Mary Elizabeth
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: 363157
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: 363158
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

SVSPP

CC ID: 363159
Seq. Order: 3
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

COMMON_NAME

CC ID: 363160
Seq. Order: 4
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

SEX

CC ID: 363161
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
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

LENGTH

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

Measured length of an individual in centimeters (cm). Measure method differs by species

General Data Type: NUMBER

ENTRY_ORDER

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

Order in which fish were measured or entered into the field computer.

General Data Type: NUMBER

NOTES

CC ID: 363164
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Comments related to the measurement of the individual organism's length.

General Data Type: VARCHAR2

VESSEL

CC ID: 363165
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Two digit code for the vessel on which the organism was collected and measured. Matches with code in LL_STATION.CRUISE. Values are 24 = Tenacious II or 25 = Mary Elizabeth

General Data Type: NUMBER

EST_LENGTH

CC ID: 363166
Seq. Order: 10
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)

General Data Type: VARCHAR2

AUDIT_FLAG

CC ID: 712578
Seq. Order: 11
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: 35950
GUID: gov.noaa.nmfs.inport:35950
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