Variables in table JLL_CATCH
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:27633 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Entity Information
Data Attribute / Type | Description |
---|---|
CATCH_KEY
VARCHAR2(20 BYTE) |
Unique key for this file; there is a one to 6 digit prefix (starts at 1 and goes sequentially up to 401,217) which is then followed by the trip ID number (see column 1 in the effort file documentation). This column could be used to link the catch to the effort, but the number preceding the trip ID would need to be trimmed out. |
HAUL_NUMBER
VARCHAR2(2 BYTE) |
Haul number of this trip that this animal was caught on. |
SPECIES_CODE
VARCHAR2(7 BYTE) |
Species code, which is formatted as an alpha-numeric string that combines the 3 letter POP alpha species codes with 4-digit NMFS numeric codes. So YFT4655 combines the POP code YFT for yellowfin tuna with the NMFS numeric code of 4655 for yellowfin tuna. |
LENGTH1
VARCHAR2(3 BYTE) |
Length in centimeters, for species other than sharks. |
LENGTH2
VVARCHAR2(3 BYTE) |
Length in centimeters, for species in the shark group. |
LENGTH_TYPE
VARCHAR2(1 BYTE) |
A length type code that relates to whatever length appears in columns LENGTH1 or LENGTH2. The codes are 0=unknown, 1=straight length measurement, 2=curved length measurement, and 3=estimated length measurement. |
SEX
VARCHAR2(1 BYTE) |
Sex ID of the observed animal: : 0 = unknown, 1 = male, and 2 = female. |
BEGIN_HAUL_DATE
VARCHAR2(20 BYTE) |
Begin haul date, in format YYYYMMDD. |
SPECIES_GROUP
VARCHAR2(20 BYTE) |
SPECIES_GROUP: Species group; an alpha code that describes the general group this species fits in. There are 11 distinct values: JAPSKATES/RAYS JAPTUNA OTHER JAPTUNA JAPBILLFISH JAPSEA BIRD JAPMARINE TURTLE JAPFINFISH OTHER JAPMARINE MAMMAL JAPFINFISH JAPSHARK JAPMISC |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (SEFSC) for inquiries on this record.
Item Identification
Title: | Variables in table JLL_CATCH |
---|---|
Short Name: | Catch variables |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
CATCH_KEY | VARCHAR2(20 BYTE) | Unique key for this file; there is a one to 6 digit prefix (starts at 1 and goes sequentially up to 401,217) which is then followed by the trip ID number (see column 1 in the effort file documentation). This column could be used to link the catch to the effort, but the number preceding the trip ID would need to be trimmed out. | |
100
|
HAUL_NUMBER | VARCHAR2(2 BYTE) | Haul number of this trip that this animal was caught on. | |
100
|
SPECIES_CODE | VARCHAR2(7 BYTE) | Species code, which is formatted as an alpha-numeric string that combines the 3 letter POP alpha species codes with 4-digit NMFS numeric codes. So YFT4655 combines the POP code YFT for yellowfin tuna with the NMFS numeric code of 4655 for yellowfin tuna. | |
100
|
LENGTH1 | VARCHAR2(3 BYTE) | Length in centimeters, for species other than sharks. | |
100
|
LENGTH2 | VVARCHAR2(3 BYTE) | Length in centimeters, for species in the shark group. | |
100
|
LENGTH_TYPE | VARCHAR2(1 BYTE) | A length type code that relates to whatever length appears in columns LENGTH1 or LENGTH2. The codes are 0=unknown, 1=straight length measurement, 2=curved length measurement, and 3=estimated length measurement. | |
100
|
SEX | VARCHAR2(1 BYTE) | Sex ID of the observed animal: : 0 = unknown, 1 = male, and 2 = female. | |
100
|
BEGIN_HAUL_DATE | VARCHAR2(20 BYTE) | Begin haul date, in format YYYYMMDD. | |
100
|
SPECIES_GROUP | VARCHAR2(20 BYTE) | SPECIES_GROUP: Species group; an alpha code that describes the general group this species fits in. There are 11 distinct values: JAPSKATES/RAYS JAPTUNA OTHER JAPTUNA JAPBILLFISH JAPSEA BIRD JAPMARINE TURTLE JAPFINFISH OTHER JAPMARINE MAMMAL JAPFINFISH JAPSHARK JAPMISC |
Attribute Details
CATCH_KEY
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2(20 BYTE) |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique key for this file; there is a one to 6 digit prefix (starts at 1 and goes sequentially up to 401,217) which is then followed by the trip ID number (see column 1 in the effort file documentation). This column could be used to link the catch to the effort, but the number preceding the trip ID would need to be trimmed out. |
HAUL_NUMBER
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2(2 BYTE) |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Haul number of this trip that this animal was caught on. |
SPECIES_CODE
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2(7 BYTE) |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Species code, which is formatted as an alpha-numeric string that combines the 3 letter POP alpha species codes with 4-digit NMFS numeric codes. So YFT4655 combines the POP code YFT for yellowfin tuna with the NMFS numeric code of 4655 for yellowfin tuna. |
LENGTH1
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2(3 BYTE) |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Length in centimeters, for species other than sharks. |
LENGTH2
Seq. Order: | 5 |
---|---|
Data Storage Type: | VVARCHAR2(3 BYTE) |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Length in centimeters, for species in the shark group. |
LENGTH_TYPE
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2(1 BYTE) |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
A length type code that relates to whatever length appears in columns LENGTH1 or LENGTH2. The codes are 0=unknown, 1=straight length measurement, 2=curved length measurement, and 3=estimated length measurement. |
SEX
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2(1 BYTE) |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Sex ID of the observed animal: : 0 = unknown, 1 = male, and 2 = female. |
BEGIN_HAUL_DATE
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2(20 BYTE) |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Begin haul date, in format YYYYMMDD. |
SPECIES_GROUP
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2(20 BYTE) |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
SPECIES_GROUP: Species group; an alpha code that describes the general group this species fits in. There are 11 distinct values: JAPSKATES/RAYS JAPTUNA OTHER JAPTUNA JAPBILLFISH JAPSEA BIRD JAPMARINE TURTLE JAPFINFISH OTHER JAPMARINE MAMMAL JAPFINFISH JAPSHARK JAPMISC |
Catalog Details
Catalog Item ID: | 27633 |
---|---|
GUID: | gov.noaa.nmfs.inport:27633 |
Metadata Record Created By: | Larry Beerkircher |
Metadata Record Created: | 2015-10-01 08:20+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2021-05-06 |
Owner Org: | SEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2021-05-06 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2022-05-06 |