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