LL_LENGTH
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:35950 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Table contains the length data for each station
DescriptionTable 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
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
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
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
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
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
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
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
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
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
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
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
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 |