Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Variables in table JLL_CATCH
Short Name: Catch variables

Data Attributes

Attribute Summary

Rubric Score Primary Key? 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

CC ID: 227149
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

CC ID: 227150
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

CC ID: 227151
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

CC ID: 227152
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

CC ID: 227153
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

CC ID: 227154
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

CC ID: 227155
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

CC ID: 227156
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

CC ID: 227157
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