LL_LENGTH
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:35950 | Updated: August 9, 2022 | Published / External
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 |