Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Fisheries Research and Monitoring Divisio... > Fisheries Monitoring > Longline Logbook > Hawaii Longline Logbook >

NMFS W. Pacific Daily Longline Fishing Log - Hawaii

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:47316  |  Updated: February 20, 2025  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Hawaii Longline Logbook Data.

Description

Hawaii Longline Logbook Data.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
DATASET_CODE
VARCHAR2 		Source ID code assigned by data entry staff (FC048).
VERSION_CODE
VARCHAR2 		Format version of the data assigned by data entry staff.
TRIP_TYPE_CODE
VARCHAR2 		Trip type code (B)illfish, (T)una, (M)ixed.
TRIP_NUMBER
VARCHAR2 		The logbook trip number as assigned by the logbook Data Manager after the trip has returned.
RSCH_EXPMTL_CODE
VARCHAR2 		Is this trip a research or experimental trip? (R/X).
LANDING_YEAR
VARCHAR2 		Four-digit year that the boat returned to port.
LANDING_MONTH
VARCHAR2 		Month (00-12) that the boat returned to port.
SET_YEAR
VARCHAR2 		Four-digit year the set occurred.
SET_MONTH
VARCHAR2 		Two-digit month the set was made.
SET_DAY
VARCHAR2 		Two-digit day the set was made.
VESSEL_NAME
VARCHAR2 		Name of vessel.
PERMIT_NUMBER
VARCHAR2 		Permit number.
TARGET_SPECIES_CODE
VARCHAR2 		The code of the primary species of fish targeted to be caught on this trip, (T)una, (B)illfish, (M)ixed.
BAIT_CODE
VARCHAR2 		Code to represent what bait was used.
MAINLINE_LENGTH
VARCHAR2 		Length in miles of mainline used. Units for values are nautical miles.
NUMBER_OF_HOOKS_SET
VARCHAR2 		Number of hooks set.
MINIMUM_HOOKS_PER_FLOAT
VARCHAR2 		Minimum number of hooks used per float.
MAXIMUM_HOOKS_PER_FLOAT
VARCHAR2 		Maximum number of hooks used per float.
NUMBER_OF_LIGHT_STICKS
VARCHAR2 		Number of light sticks used.
MINIMUM_WINDSPEED
VARCHAR2 		Minimum wind speed during the setting of hooks. Units for values are knots.
MAXIMUM_WINDSPEED
VARCHAR2 		Maximum wind speed during the setting of hooks. Units for values are knots.
WIND_DIRECTION
VARCHAR2 		Direction the wind was blowing during the setting of hooks.
MINIMUM_WAVE_HEIGHT
VARCHAR2 		Minimum wave height during the setting of hooks. Units for values are feet.
MAXIMUM_WAVE_HEIGHT
VARCHAR2 		Maximum wave height during the setting of hooks. Units for values are feet.
SEA_SURFACE_TEMPERATURE
VARCHAR2 		Sea surface temperature during the setting of hooks. Units for values are degrees Farenheit. Measures are reported with a precision of 3.
BEGIN_SET_TIME
VARCHAR2 		Time when line setting began.
BEGIN_SET_LATITUDE_DEGREES
VARCHAR2 		Latitude degrees where line setting began. Units for values are degrees.
BEGIN_SET_LATITUDE_MINUTES
VARCHAR2 		Latitude minutes where line setting began. Units for values are minutes.
BEGIN_SET_LATITUDE_DIRECTION
VARCHAR2 		Latitude hemisphere where line setting began.
BEGIN_SET_LONGITUDE_DEGREES
VARCHAR2 		Longitude degrees where line setting began.
BEGIN_SET_LONGITUDE_MINUTES
VARCHAR2 		Longitude minutes where line setting began.
BEGIN_SET_LONGITUDE_DIRECTION
VARCHAR2 		Longitude hemisphere where line setting began.
END_SET_TIME
VARCHAR2 		Time when line setting ended.
END_SET_LATITUDE_DEGREES
VARCHAR2 		Latitude degrees where line setting ended. Units for values are degrees.
END_SET_LATITUDE_MINUTES
VARCHAR2 		Latitude minutes where line setting ended. Units for values are minutes.
END_SET_LATITUDE_DIRECTION
VARCHAR2 		Latitude hemisphere where line setting ended.
END_SET_LONGITUDE_DEGREES
VARCHAR2 		Longitude degrees where line setting ended. Units for values are degrees.
END_SET_LONGITUDE_MINUTES
VARCHAR2 		Longitude minutes where line setting ended. Units for values are minutes.
END_SET_LONGITUDE_DIRECTION
VARCHAR2 		Longitude hemisphere where line setting ended.
HAUL_YEAR
VARCHAR2 		Four-digit year when the haul began.
HAUL_MONTH
VARCHAR2 		Two-digit month when the haul began.
HAUL_DAY
VARCHAR2 		Two-digit day when the haul began.
BEGIN_HAUL_TIME
VARCHAR2 		Time when line hauling was started.
BEGIN_HAUL_LATITUDE_DEGREES
VARCHAR2 		Latitude degrees where line hauling began. Units for values are degrees.
BEGIN_HAUL_LATITUDE_MINUTES
VARCHAR2 		Latitude minutes where line hauling began. Units for values are minutes.
BEGIN_HAUL_LATITUDE_DIRECTION
VARCHAR2 		Latitude hemisphere where line hauling began.
BEGIN_HAUL_LONGITUDE_DEGREES
VARCHAR2 		Longitude degrees where line hauling began. Units for values are degrees.
BEGIN_HAUL_LONGITUDE_MINUTES
VARCHAR2 		Longitude minutes where line hauling began. Units for values are minutes.
BEGIN_HAUL_LONGITUDE_DIRECTION
VARCHAR2 		Longitude hemisphere where line hauling began.
END_HAUL_TIME
VARCHAR2 		Time when line hauling ended.
END_HAUL_LATITUDE_DEGREES
VARCHAR2 		Latitude degrees where line hauling ended. Units for values are degrees.
END_HAUL_LATITUDE_MINUTES
VARCHAR2 		Latitude minutes where line hauling ended. Units for values are minutes.
END_HAUL_LATITUDE_DIRECTION
VARCHAR2 		Latitude hemisphere where line hauling ended.
END_HAUL_LONGITUDE_DEGREES
VARCHAR2 		Longitude degrees where line hauling ended. Units for values are degrees.
END_HAUL_LONGITUDE_MINUTES
VARCHAR2 		Longitude minutes where line hauling ended. Units for values are minutes.
END_HAUL_LONGITUDE_DIRECTION
VARCHAR2 		Longitude hemisphere where line hauling ended.
SPECIES_CODE
VARCHAR2 		Pelagic species code (See reference table DSC.DSC_SPECIES_CROSSREF_NODC).
NUMBER_OF_SHARKS_FINNED
VARCHAR2 		Number of sharks that were Finned while fishing.
NUMBER_OF_FISH_KEPT
VARCHAR2 		Number of a particular species that were Kept while fishing.
NUMBER_OF_FISH_RELEASED
VARCHAR2 		Number of a particular species that were Released while fishing.
PROTECTED_SPECIES_CODE
VARCHAR2 		Protected species code (See reference table DSC.DSC_SPECIES_CROSSREF_NODC).
NUMBER_RELEASED_ALIVE_UNINJURE
VARCHAR2 		Number of a particular protected species released alive and uninjured.
NUMBER_RELEASED_INJURED
VARCHAR2 		Number of a particular protected species released injured.
NUMBER_RELEASED_DEAD
VARCHAR2 		Number of a partidular protected species released dead.
NUMBER_SIGHTED_IN_AREA_OF_GEAR
VARCHAR2 		Number of a particular protected species sighted in area of gear.
COMMERCIAL_MARINE_LICENSE_NUM
VARCHAR2 		Commercial Marine License (CML) number.
SIGN_YEAR
VARCHAR2 		Four-digit year when form was signed by the CML holder.
SIGN_MONTH
VARCHAR2 		Two-digit month when form was signed by the CML holder.
SIGN_DAY
VARCHAR2 		Two-digit day when form was signed by the fisher.
EDIT_CODE
VARCHAR2 		Code signifying when in the editing process a correction was made to this record.
SERIAL_NUMBER
VARCHAR2 		It is the page number that is printed on the logbook form, the number assigned by the electronic logbook program, or other solutions to enable identifying unique sets.
OBSERVER_ONBOARD_CODE
VARCHAR2 		Was an observer onboard? (Y/NULL).
DEPARTURE_YEAR
VARCHAR2 		Four-digit year fishing boat left port.
DEPARTURE_MONTH
VARCHAR2 		Two-digit month fishing boat left port.
DEPARTURE_DAY
VARCHAR2 		Two-digit day fishing boat left port.
DEPARTURE_PORT
VARCHAR2 		Code to represent departing port of vessel. Uses three-letter Airline City Codes.
RETURN_YEAR
VARCHAR2 		Four-digit year boat returned to port.
RETURN_MONTH
VARCHAR2 		Two-digit month boat returned to port.
RETURN_DAY
VARCHAR2 		Two-digit day boat returned to port.
RETURN_PORT
VARCHAR2 		Code to represent returning port of vessel. Uses three-letter Airline City Codes.
NIGHT_SETTING
VARCHAR2 		Bird mitigation. Was the set made at night? 1=used.
DYED_BAIT
VARCHAR2 		Bird mitigation. Was the bait dyed blue? 1=used.
TOWED_DETERRENT
VARCHAR2 		Bird mitigation. Was a towed deterrent used? 1=used.
WEIGHTED_GEAR
VARCHAR2 		Bird mitigation. Was the gear weighted? 1=used.
LINE_SHOOTER
VARCHAR2 		Bird mitigation. Was a line shooter used? 1=used.
OFFAL_DISCARD
VARCHAR2 		Bird mitigation. Was the offal discarded strategically? 1=used.
HOOKS_LOST
VARCHAR2 		Number of hooks lost on the set.
VERSION
VARCHAR2 		Llps extraction/archive date.
CERTIFICATE_NUMBER
VARCHAR2 		Unique number on the shallow-set certificate used to track each certificate (Hawaii Logbook Only).
BATCH_NUMBER
VARCHAR2 		A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D14001.
AREA
VARCHAR2 		Primary Economic Exclusivity Zone. Contains "OUT", or 4-letter EEZ code if Begin Set location is within established EEZ.
AREA2
VARCHAR2 		Secondary Economic Exclusivity Zone. Contains NULL, or 4-letter EEZ code.
DISTANCE
VARCHAR2 		Distance, calculated from Begin Set location to predefined location in AREA2.
SEQUENCE_NUMBER
VARCHAR2 		A consecutive number that is assigned to each record of a block of data.
UPDATED
DATE 		Date when the record was loaded into Oracle.
SIDE_SET
VARCHAR2 		Was the line set over the side of the vessel instead of the rear? (Y/N).
TYPE_SET
VARCHAR2 		Code signifying whether this set was either Deep or Shallow.
E150
VARCHAR2 		Indicates whether location in Eastern Pacific Ocean (Y/N); no longer used.
REMARKS
VARCHAR2 		A number or name assigned to any document containing any further notes on this trip.
TRIP_CORRECTION_CODE
VARCHAR2 		Code signifying when in the editing process a correction was made to the trip data in this record.
TRIP_LOCATION_CODE
VARCHAR2 		Code signifying whether ALL trip locations were to the East, West, or Straddled Longitude 150.
OBSERVER_TRIP_NUMBER
VARCHAR2 		The observer trip number as assigned by the Observer Program.
OBSERVER_SET_NUMBER
VARCHAR2 		The number of the set as assigned by the onboard observer, left-justified, leading zero(s) missing.
SET_CORRECTION_CODE
VARCHAR2 		Code signifying when in the editing process a correction was made to the set data in this record.
SET_TYPE
VARCHAR2 		Code signifying whether this set was either Deep or Shallow.
BEGIN_SET_LOCATION_CODE
VARCHAR2 		Code signifying whether this begin set location is East or West of Longitude 150. If = 150, it is West.
END_SET_LOCATION_CODE
VARCHAR2 		Code signifying whether this end set location is East or West of Longitude 150. If = 150, it is West.
BEGIN_HAUL_LOCATION_CODE
VARCHAR2 		Code signifying whether this begin haul location is East or West of Longitude 150. If = 150, it is West.
END_HAUL_LOCATION_CODE
VARCHAR2 		Code signifying whether this end haul location is East or West of Longitude 150. If = 150, it is west.
CATCH_CORRECTION_CODE
VARCHAR2 		Code signifying when in the editing process a correction was made to this species record.
PSI_CORRECTION_CODE
VARCHAR2 		Code signifying when in the editing process a correction was made to this protected species record.
VCODE
VARCHAR2 		Code based on the vessel's name, to disguise the identity of the boat, allowing release of data which could be otherwise confidential.
FLEET
VARCHAR2 		Indicates fleet (or Logbook) to which this record belongs. (e.g., AS = American Samoa Longline Logbook).
DPV
VARCHAR2 		Specifies whether a boat is a dual-permit vessel. Y = Yes, NULL = No.
MONUMENT
VARCHAR2 		Contains NULL, or 4-letter EEZ code if Begin Set location is within the Established Monument boundaries.
SERIAL_NUMBER2
VARCHAR2 		It is the page number that is printed on the logbook form or the number assigned by the electronic logbook program.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

Item Identification

Title: NMFS W. Pacific Daily Longline Fishing Log - Hawaii
Short Name: FC048A19
Status: Completed
Abstract:

Hawaii Longline Logbook Data.
Supplemental Information:

Source ID: FC048

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: ORADATA
Description:

Hawaii Longline Logbook Data.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 DATASET_CODE VARCHAR2 Source ID code assigned by data entry staff (FC048).
100
 VERSION_CODE VARCHAR2 Format version of the data assigned by data entry staff.
100
 TRIP_TYPE_CODE VARCHAR2 Trip type code (B)illfish, (T)una, (M)ixed.
100
 TRIP_NUMBER VARCHAR2 The logbook trip number as assigned by the logbook Data Manager after the trip has returned.
100
 RSCH_EXPMTL_CODE VARCHAR2 Is this trip a research or experimental trip? (R/X).
100
 LANDING_YEAR VARCHAR2 Four-digit year that the boat returned to port.
100
 LANDING_MONTH VARCHAR2 Month (00-12) that the boat returned to port.
100
 SET_YEAR VARCHAR2 Four-digit year the set occurred.
100
 SET_MONTH VARCHAR2 Two-digit month the set was made.
100
 SET_DAY VARCHAR2 Two-digit day the set was made.
100
 VESSEL_NAME VARCHAR2 Name of vessel.
100
 PERMIT_NUMBER VARCHAR2 Permit number.
100
 TARGET_SPECIES_CODE VARCHAR2 The code of the primary species of fish targeted to be caught on this trip, (T)una, (B)illfish, (M)ixed.
100
 BAIT_CODE VARCHAR2 Code to represent what bait was used.
100
 MAINLINE_LENGTH VARCHAR2 Length in miles of mainline used. Units for values are nautical miles.
100
 NUMBER_OF_HOOKS_SET VARCHAR2 Number of hooks set.
100
 MINIMUM_HOOKS_PER_FLOAT VARCHAR2 Minimum number of hooks used per float.
100
 MAXIMUM_HOOKS_PER_FLOAT VARCHAR2 Maximum number of hooks used per float.
100
 NUMBER_OF_LIGHT_STICKS VARCHAR2 Number of light sticks used.
100
 MINIMUM_WINDSPEED VARCHAR2 Minimum wind speed during the setting of hooks. Units for values are knots.
100
 MAXIMUM_WINDSPEED VARCHAR2 Maximum wind speed during the setting of hooks. Units for values are knots.
100
 WIND_DIRECTION VARCHAR2 Direction the wind was blowing during the setting of hooks.
100
 MINIMUM_WAVE_HEIGHT VARCHAR2 Minimum wave height during the setting of hooks. Units for values are feet.
100
 MAXIMUM_WAVE_HEIGHT VARCHAR2 Maximum wave height during the setting of hooks. Units for values are feet.
100
 SEA_SURFACE_TEMPERATURE VARCHAR2 Sea surface temperature during the setting of hooks. Units for values are degrees Farenheit. Measures are reported with a precision of 3.
100
 BEGIN_SET_TIME VARCHAR2 Time when line setting began.
100
 BEGIN_SET_LATITUDE_DEGREES VARCHAR2 Latitude degrees where line setting began. Units for values are degrees.
100
 BEGIN_SET_LATITUDE_MINUTES VARCHAR2 Latitude minutes where line setting began. Units for values are minutes.
100
 BEGIN_SET_LATITUDE_DIRECTION VARCHAR2 Latitude hemisphere where line setting began.
100
 BEGIN_SET_LONGITUDE_DEGREES VARCHAR2 Longitude degrees where line setting began.
100
 BEGIN_SET_LONGITUDE_MINUTES VARCHAR2 Longitude minutes where line setting began.
100
 BEGIN_SET_LONGITUDE_DIRECTION VARCHAR2 Longitude hemisphere where line setting began.
100
 END_SET_TIME VARCHAR2 Time when line setting ended.
100
 END_SET_LATITUDE_DEGREES VARCHAR2 Latitude degrees where line setting ended. Units for values are degrees.
100
 END_SET_LATITUDE_MINUTES VARCHAR2 Latitude minutes where line setting ended. Units for values are minutes.
100
 END_SET_LATITUDE_DIRECTION VARCHAR2 Latitude hemisphere where line setting ended.
100
 END_SET_LONGITUDE_DEGREES VARCHAR2 Longitude degrees where line setting ended. Units for values are degrees.
100
 END_SET_LONGITUDE_MINUTES VARCHAR2 Longitude minutes where line setting ended. Units for values are minutes.
100
 END_SET_LONGITUDE_DIRECTION VARCHAR2 Longitude hemisphere where line setting ended.
100
 HAUL_YEAR VARCHAR2 Four-digit year when the haul began.
100
 HAUL_MONTH VARCHAR2 Two-digit month when the haul began.
100
 HAUL_DAY VARCHAR2 Two-digit day when the haul began.
100
 BEGIN_HAUL_TIME VARCHAR2 Time when line hauling was started.
100
 BEGIN_HAUL_LATITUDE_DEGREES VARCHAR2 Latitude degrees where line hauling began. Units for values are degrees.
100
 BEGIN_HAUL_LATITUDE_MINUTES VARCHAR2 Latitude minutes where line hauling began. Units for values are minutes.
100
 BEGIN_HAUL_LATITUDE_DIRECTION VARCHAR2 Latitude hemisphere where line hauling began.
100
 BEGIN_HAUL_LONGITUDE_DEGREES VARCHAR2 Longitude degrees where line hauling began. Units for values are degrees.
100
 BEGIN_HAUL_LONGITUDE_MINUTES VARCHAR2 Longitude minutes where line hauling began. Units for values are minutes.
100
 BEGIN_HAUL_LONGITUDE_DIRECTION VARCHAR2 Longitude hemisphere where line hauling began.
100
 END_HAUL_TIME VARCHAR2 Time when line hauling ended.
100
 END_HAUL_LATITUDE_DEGREES VARCHAR2 Latitude degrees where line hauling ended. Units for values are degrees.
100
 END_HAUL_LATITUDE_MINUTES VARCHAR2 Latitude minutes where line hauling ended. Units for values are minutes.
100
 END_HAUL_LATITUDE_DIRECTION VARCHAR2 Latitude hemisphere where line hauling ended.
100
 END_HAUL_LONGITUDE_DEGREES VARCHAR2 Longitude degrees where line hauling ended. Units for values are degrees.
100
 END_HAUL_LONGITUDE_MINUTES VARCHAR2 Longitude minutes where line hauling ended. Units for values are minutes.
100
 END_HAUL_LONGITUDE_DIRECTION VARCHAR2 Longitude hemisphere where line hauling ended.
100
 SPECIES_CODE VARCHAR2 Pelagic species code (See reference table DSC.DSC_SPECIES_CROSSREF_NODC).
100
 NUMBER_OF_SHARKS_FINNED VARCHAR2 Number of sharks that were Finned while fishing.
100
 NUMBER_OF_FISH_KEPT VARCHAR2 Number of a particular species that were Kept while fishing.
100
 NUMBER_OF_FISH_RELEASED VARCHAR2 Number of a particular species that were Released while fishing.
100
 PROTECTED_SPECIES_CODE VARCHAR2 Protected species code (See reference table DSC.DSC_SPECIES_CROSSREF_NODC).
100
 NUMBER_RELEASED_ALIVE_UNINJURE VARCHAR2 Number of a particular protected species released alive and uninjured.
100
 NUMBER_RELEASED_INJURED VARCHAR2 Number of a particular protected species released injured.
100
 NUMBER_RELEASED_DEAD VARCHAR2 Number of a partidular protected species released dead.
100
 NUMBER_SIGHTED_IN_AREA_OF_GEAR VARCHAR2 Number of a particular protected species sighted in area of gear.
100
 COMMERCIAL_MARINE_LICENSE_NUM VARCHAR2 Commercial Marine License (CML) number.
100
 SIGN_YEAR VARCHAR2 Four-digit year when form was signed by the CML holder.
100
 SIGN_MONTH VARCHAR2 Two-digit month when form was signed by the CML holder.
100
 SIGN_DAY VARCHAR2 Two-digit day when form was signed by the fisher.
100
 EDIT_CODE VARCHAR2 Code signifying when in the editing process a correction was made to this record.
100
 SERIAL_NUMBER VARCHAR2 It is the page number that is printed on the logbook form, the number assigned by the electronic logbook program, or other solutions to enable identifying unique sets.
100
 OBSERVER_ONBOARD_CODE VARCHAR2 Was an observer onboard? (Y/NULL).
100
 DEPARTURE_YEAR VARCHAR2 Four-digit year fishing boat left port.
100
 DEPARTURE_MONTH VARCHAR2 Two-digit month fishing boat left port.
100
 DEPARTURE_DAY VARCHAR2 Two-digit day fishing boat left port.
100
 DEPARTURE_PORT VARCHAR2 Code to represent departing port of vessel. Uses three-letter Airline City Codes.
100
 RETURN_YEAR VARCHAR2 Four-digit year boat returned to port.
100
 RETURN_MONTH VARCHAR2 Two-digit month boat returned to port.
100
 RETURN_DAY VARCHAR2 Two-digit day boat returned to port.
100
 RETURN_PORT VARCHAR2 Code to represent returning port of vessel. Uses three-letter Airline City Codes.
100
 NIGHT_SETTING VARCHAR2 Bird mitigation. Was the set made at night? 1=used.
100
 DYED_BAIT VARCHAR2 Bird mitigation. Was the bait dyed blue? 1=used.
100
 TOWED_DETERRENT VARCHAR2 Bird mitigation. Was a towed deterrent used? 1=used.
100
 WEIGHTED_GEAR VARCHAR2 Bird mitigation. Was the gear weighted? 1=used.
100
 LINE_SHOOTER VARCHAR2 Bird mitigation. Was a line shooter used? 1=used.
100
 OFFAL_DISCARD VARCHAR2 Bird mitigation. Was the offal discarded strategically? 1=used.
100
 HOOKS_LOST VARCHAR2 Number of hooks lost on the set.
100
 VERSION VARCHAR2 Llps extraction/archive date.
100
 CERTIFICATE_NUMBER VARCHAR2 Unique number on the shallow-set certificate used to track each certificate (Hawaii Logbook Only).
100
 BATCH_NUMBER VARCHAR2 A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D14001.
100
 AREA VARCHAR2 Primary Economic Exclusivity Zone. Contains "OUT", or 4-letter EEZ code if Begin Set location is within established EEZ.
100
 AREA2 VARCHAR2 Secondary Economic Exclusivity Zone. Contains NULL, or 4-letter EEZ code.
100
 DISTANCE VARCHAR2 Distance, calculated from Begin Set location to predefined location in AREA2.
100
 SEQUENCE_NUMBER VARCHAR2 A consecutive number that is assigned to each record of a block of data.
100
 UPDATED DATE Date when the record was loaded into Oracle.
100
 SIDE_SET VARCHAR2 Was the line set over the side of the vessel instead of the rear? (Y/N).
100
 TYPE_SET VARCHAR2 Code signifying whether this set was either Deep or Shallow.
100
 E150 VARCHAR2 Indicates whether location in Eastern Pacific Ocean (Y/N); no longer used.
100
 REMARKS VARCHAR2 A number or name assigned to any document containing any further notes on this trip.
100
 TRIP_CORRECTION_CODE VARCHAR2 Code signifying when in the editing process a correction was made to the trip data in this record.
100
 TRIP_LOCATION_CODE VARCHAR2 Code signifying whether ALL trip locations were to the East, West, or Straddled Longitude 150.
100
 OBSERVER_TRIP_NUMBER VARCHAR2 The observer trip number as assigned by the Observer Program.
100
 OBSERVER_SET_NUMBER VARCHAR2 The number of the set as assigned by the onboard observer, left-justified, leading zero(s) missing.
100
 SET_CORRECTION_CODE VARCHAR2 Code signifying when in the editing process a correction was made to the set data in this record.
100
 SET_TYPE VARCHAR2 Code signifying whether this set was either Deep or Shallow.
100
 BEGIN_SET_LOCATION_CODE VARCHAR2 Code signifying whether this begin set location is East or West of Longitude 150. If = 150, it is West.
100
 END_SET_LOCATION_CODE VARCHAR2 Code signifying whether this end set location is East or West of Longitude 150. If = 150, it is West.
100
 BEGIN_HAUL_LOCATION_CODE VARCHAR2 Code signifying whether this begin haul location is East or West of Longitude 150. If = 150, it is West.
100
 END_HAUL_LOCATION_CODE VARCHAR2 Code signifying whether this end haul location is East or West of Longitude 150. If = 150, it is west.
100
 CATCH_CORRECTION_CODE VARCHAR2 Code signifying when in the editing process a correction was made to this species record.
100
 PSI_CORRECTION_CODE VARCHAR2 Code signifying when in the editing process a correction was made to this protected species record.
100
 VCODE VARCHAR2 Code based on the vessel's name, to disguise the identity of the boat, allowing release of data which could be otherwise confidential.
100
 FLEET VARCHAR2 Indicates fleet (or Logbook) to which this record belongs. (e.g., AS = American Samoa Longline Logbook).
100
 DPV VARCHAR2 Specifies whether a boat is a dual-permit vessel. Y = Yes, NULL = No.
100
 MONUMENT VARCHAR2 Contains NULL, or 4-letter EEZ code if Begin Set location is within the Established Monument boundaries.
100
 SERIAL_NUMBER2 VARCHAR2 It is the page number that is printed on the logbook form or the number assigned by the electronic logbook program.

Attribute Details

DATASET_CODE

CC ID: 583323
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Source ID code assigned by data entry staff (FC048).
General Data Type: VARCHAR2

VERSION_CODE

CC ID: 583324
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Format version of the data assigned by data entry staff.
General Data Type: VARCHAR2

TRIP_TYPE_CODE

CC ID: 583325
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Trip type code (B)illfish, (T)una, (M)ixed.
General Data Type: VARCHAR2

TRIP_NUMBER

CC ID: 583326
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

The logbook trip number as assigned by the logbook Data Manager after the trip has returned.
General Data Type: VARCHAR2

RSCH_EXPMTL_CODE

CC ID: 583327
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Is this trip a research or experimental trip? (R/X).
General Data Type: VARCHAR2

LANDING_YEAR

CC ID: 583328
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Four-digit year that the boat returned to port.
General Data Type: VARCHAR2

LANDING_MONTH

CC ID: 583329
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Month (00-12) that the boat returned to port.
General Data Type: VARCHAR2

SET_YEAR

CC ID: 583330
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Four-digit year the set occurred.
General Data Type: VARCHAR2

SET_MONTH

CC ID: 583331
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Two-digit month the set was made.
General Data Type: VARCHAR2

SET_DAY

CC ID: 583332
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Two-digit day the set was made.
General Data Type: VARCHAR2

VESSEL_NAME

CC ID: 583333
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Name of vessel.
General Data Type: VARCHAR2

PERMIT_NUMBER

CC ID: 583334
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

Permit number.
General Data Type: VARCHAR2

TARGET_SPECIES_CODE

CC ID: 583335
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

The code of the primary species of fish targeted to be caught on this trip, (T)una, (B)illfish, (M)ixed.
General Data Type: VARCHAR2

BAIT_CODE

CC ID: 583336
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Code to represent what bait was used.
General Data Type: VARCHAR2

MAINLINE_LENGTH

CC ID: 583337
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Length in miles of mainline used. Units for values are nautical miles.
General Data Type: VARCHAR2
Unit of Measure: nautical miles

NUMBER_OF_HOOKS_SET

CC ID: 583338
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Number of hooks set.
General Data Type: VARCHAR2

MINIMUM_HOOKS_PER_FLOAT

CC ID: 583339
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Minimum number of hooks used per float.
General Data Type: VARCHAR2

MAXIMUM_HOOKS_PER_FLOAT

CC ID: 583340
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Maximum number of hooks used per float.
General Data Type: VARCHAR2

NUMBER_OF_LIGHT_STICKS

CC ID: 583341
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Number of light sticks used.
General Data Type: VARCHAR2

MINIMUM_WINDSPEED

CC ID: 583342
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Minimum wind speed during the setting of hooks. Units for values are knots.
General Data Type: VARCHAR2
Unit of Measure: knots

MAXIMUM_WINDSPEED

CC ID: 583343
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Maximum wind speed during the setting of hooks. Units for values are knots.
General Data Type: VARCHAR2
Unit of Measure: knots

WIND_DIRECTION

CC ID: 583344
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Direction the wind was blowing during the setting of hooks.
General Data Type: VARCHAR2

MINIMUM_WAVE_HEIGHT

CC ID: 583345
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Minimum wave height during the setting of hooks. Units for values are feet.
General Data Type: VARCHAR2
Unit of Measure: feet

MAXIMUM_WAVE_HEIGHT

CC ID: 583346
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Maximum wave height during the setting of hooks. Units for values are feet.
General Data Type: VARCHAR2
Unit of Measure: feet

SEA_SURFACE_TEMPERATURE

CC ID: 583347
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Sea surface temperature during the setting of hooks. Units for values are degrees Farenheit. Measures are reported with a precision of 3.
General Data Type: VARCHAR2
Unit of Measure: degrees Farenheit

BEGIN_SET_TIME

CC ID: 583348
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Time when line setting began.
General Data Type: VARCHAR2

BEGIN_SET_LATITUDE_DEGREES

CC ID: 583349
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Latitude degrees where line setting began. Units for values are degrees.
General Data Type: VARCHAR2
Unit of Measure: degrees

BEGIN_SET_LATITUDE_MINUTES

CC ID: 583350
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Latitude minutes where line setting began. Units for values are minutes.
General Data Type: VARCHAR2
Unit of Measure: minutes

BEGIN_SET_LATITUDE_DIRECTION

CC ID: 583351
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Latitude hemisphere where line setting began.
General Data Type: VARCHAR2

BEGIN_SET_LONGITUDE_DEGREES

CC ID: 583352
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Longitude degrees where line setting began.
General Data Type: VARCHAR2

BEGIN_SET_LONGITUDE_MINUTES

CC ID: 583353
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Longitude minutes where line setting began.
General Data Type: VARCHAR2

BEGIN_SET_LONGITUDE_DIRECTION

CC ID: 583354
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Longitude hemisphere where line setting began.
General Data Type: VARCHAR2

END_SET_TIME

CC ID: 583355
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Time when line setting ended.
General Data Type: VARCHAR2

END_SET_LATITUDE_DEGREES

CC ID: 583356
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Latitude degrees where line setting ended. Units for values are degrees.
General Data Type: VARCHAR2
Unit of Measure: degrees

END_SET_LATITUDE_MINUTES

CC ID: 583357
Seq. Order: 35
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Latitude minutes where line setting ended. Units for values are minutes.
General Data Type: VARCHAR2
Unit of Measure: minutes

END_SET_LATITUDE_DIRECTION

CC ID: 583358
Seq. Order: 36
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Latitude hemisphere where line setting ended.
General Data Type: VARCHAR2

END_SET_LONGITUDE_DEGREES

CC ID: 583359
Seq. Order: 37
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Longitude degrees where line setting ended. Units for values are degrees.
General Data Type: VARCHAR2
Unit of Measure: degrees

END_SET_LONGITUDE_MINUTES

CC ID: 583360
Seq. Order: 38
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Longitude minutes where line setting ended. Units for values are minutes.
General Data Type: VARCHAR2
Unit of Measure: minutes

END_SET_LONGITUDE_DIRECTION

CC ID: 583361
Seq. Order: 39
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Longitude hemisphere where line setting ended.
General Data Type: VARCHAR2

HAUL_YEAR

CC ID: 583362
Seq. Order: 40
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Four-digit year when the haul began.
General Data Type: VARCHAR2

HAUL_MONTH

CC ID: 583363
Seq. Order: 41
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Two-digit month when the haul began.
General Data Type: VARCHAR2

HAUL_DAY

CC ID: 583364
Seq. Order: 42
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Two-digit day when the haul began.
General Data Type: VARCHAR2

BEGIN_HAUL_TIME

CC ID: 583365
Seq. Order: 43
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Time when line hauling was started.
General Data Type: VARCHAR2

BEGIN_HAUL_LATITUDE_DEGREES

CC ID: 583366
Seq. Order: 44
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Latitude degrees where line hauling began. Units for values are degrees.
General Data Type: VARCHAR2
Unit of Measure: degrees

BEGIN_HAUL_LATITUDE_MINUTES

CC ID: 583367
Seq. Order: 45
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Latitude minutes where line hauling began. Units for values are minutes.
General Data Type: VARCHAR2
Unit of Measure: minutes

BEGIN_HAUL_LATITUDE_DIRECTION

CC ID: 583368
Seq. Order: 46
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Latitude hemisphere where line hauling began.
General Data Type: VARCHAR2

BEGIN_HAUL_LONGITUDE_DEGREES

CC ID: 583369
Seq. Order: 47
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Longitude degrees where line hauling began. Units for values are degrees.
General Data Type: VARCHAR2
Unit of Measure: degrees

BEGIN_HAUL_LONGITUDE_MINUTES

CC ID: 583370
Seq. Order: 48
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Longitude minutes where line hauling began. Units for values are minutes.
General Data Type: VARCHAR2
Unit of Measure: minutes

BEGIN_HAUL_LONGITUDE_DIRECTION

CC ID: 583371
Seq. Order: 49
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Longitude hemisphere where line hauling began.
General Data Type: VARCHAR2

END_HAUL_TIME

CC ID: 583372
Seq. Order: 50
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Time when line hauling ended.
General Data Type: VARCHAR2

END_HAUL_LATITUDE_DEGREES

CC ID: 583373
Seq. Order: 51
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Latitude degrees where line hauling ended. Units for values are degrees.
General Data Type: VARCHAR2
Unit of Measure: degrees

END_HAUL_LATITUDE_MINUTES

CC ID: 583374
Seq. Order: 52
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Latitude minutes where line hauling ended. Units for values are minutes.
General Data Type: VARCHAR2
Unit of Measure: minutes

END_HAUL_LATITUDE_DIRECTION

CC ID: 583375
Seq. Order: 53
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Latitude hemisphere where line hauling ended.
General Data Type: VARCHAR2

END_HAUL_LONGITUDE_DEGREES

CC ID: 583376
Seq. Order: 54
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Longitude degrees where line hauling ended. Units for values are degrees.
General Data Type: VARCHAR2
Unit of Measure: degrees

END_HAUL_LONGITUDE_MINUTES

CC ID: 583377
Seq. Order: 55
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Longitude minutes where line hauling ended. Units for values are minutes.
General Data Type: VARCHAR2
Unit of Measure: minutes

END_HAUL_LONGITUDE_DIRECTION

CC ID: 583378
Seq. Order: 56
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Longitude hemisphere where line hauling ended.
General Data Type: VARCHAR2

SPECIES_CODE

CC ID: 583379
Seq. Order: 57
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Pelagic species code (See reference table DSC.DSC_SPECIES_CROSSREF_NODC).
General Data Type: VARCHAR2

NUMBER_OF_SHARKS_FINNED

CC ID: 583380
Seq. Order: 58
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Number of sharks that were Finned while fishing.
General Data Type: VARCHAR2

NUMBER_OF_FISH_KEPT

CC ID: 583381
Seq. Order: 59
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Number of a particular species that were Kept while fishing.
General Data Type: VARCHAR2

NUMBER_OF_FISH_RELEASED

CC ID: 583382
Seq. Order: 60
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Number of a particular species that were Released while fishing.
General Data Type: VARCHAR2

PROTECTED_SPECIES_CODE

CC ID: 583383
Seq. Order: 61
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Protected species code (See reference table DSC.DSC_SPECIES_CROSSREF_NODC).
General Data Type: VARCHAR2

NUMBER_RELEASED_ALIVE_UNINJURE

CC ID: 583384
Seq. Order: 62
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Number of a particular protected species released alive and uninjured.
General Data Type: VARCHAR2

NUMBER_RELEASED_INJURED

CC ID: 583385
Seq. Order: 63
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Number of a particular protected species released injured.
General Data Type: VARCHAR2

NUMBER_RELEASED_DEAD

CC ID: 583386
Seq. Order: 64
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Number of a partidular protected species released dead.
General Data Type: VARCHAR2

NUMBER_SIGHTED_IN_AREA_OF_GEAR

CC ID: 583387
Seq. Order: 65
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Number of a particular protected species sighted in area of gear.
General Data Type: VARCHAR2

COMMERCIAL_MARINE_LICENSE_NUM

CC ID: 583388
Seq. Order: 66
Data Storage Type: VARCHAR2
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Commercial Marine License (CML) number.
General Data Type: VARCHAR2

SIGN_YEAR

CC ID: 583389
Seq. Order: 67
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Four-digit year when form was signed by the CML holder.
General Data Type: VARCHAR2

SIGN_MONTH

CC ID: 583390
Seq. Order: 68
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Two-digit month when form was signed by the CML holder.
General Data Type: VARCHAR2

SIGN_DAY

CC ID: 583391
Seq. Order: 69
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Two-digit day when form was signed by the fisher.
General Data Type: VARCHAR2

EDIT_CODE

CC ID: 583392
Seq. Order: 70
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code signifying when in the editing process a correction was made to this record.
General Data Type: VARCHAR2

SERIAL_NUMBER

CC ID: 583393
Seq. Order: 71
Data Storage Type: VARCHAR2
Max Length: 18
Required: No
Primary Key: No
Status: Active
Description:

It is the page number that is printed on the logbook form, the number assigned by the electronic logbook program, or other solutions to enable identifying unique sets.
General Data Type: VARCHAR2

OBSERVER_ONBOARD_CODE

CC ID: 583394
Seq. Order: 72
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Was an observer onboard? (Y/NULL).
General Data Type: VARCHAR2

DEPARTURE_YEAR

CC ID: 583395
Seq. Order: 73
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Four-digit year fishing boat left port.
General Data Type: VARCHAR2

DEPARTURE_MONTH

CC ID: 583396
Seq. Order: 74
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Two-digit month fishing boat left port.
General Data Type: VARCHAR2

DEPARTURE_DAY

CC ID: 583397
Seq. Order: 75
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Two-digit day fishing boat left port.
General Data Type: VARCHAR2

DEPARTURE_PORT

CC ID: 583398
Seq. Order: 76
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Code to represent departing port of vessel. Uses three-letter Airline City Codes.
General Data Type: VARCHAR2

RETURN_YEAR

CC ID: 583399
Seq. Order: 77
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Four-digit year boat returned to port.
General Data Type: VARCHAR2

RETURN_MONTH

CC ID: 583400
Seq. Order: 78
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Two-digit month boat returned to port.
General Data Type: VARCHAR2

RETURN_DAY

CC ID: 583401
Seq. Order: 79
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Two-digit day boat returned to port.
General Data Type: VARCHAR2

RETURN_PORT

CC ID: 583402
Seq. Order: 80
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Code to represent returning port of vessel. Uses three-letter Airline City Codes.
General Data Type: VARCHAR2

NIGHT_SETTING

CC ID: 583403
Seq. Order: 81
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Bird mitigation. Was the set made at night? 1=used.
General Data Type: VARCHAR2

DYED_BAIT

CC ID: 583404
Seq. Order: 82
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Bird mitigation. Was the bait dyed blue? 1=used.
General Data Type: VARCHAR2

TOWED_DETERRENT

CC ID: 583405
Seq. Order: 83
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Bird mitigation. Was a towed deterrent used? 1=used.
General Data Type: VARCHAR2

WEIGHTED_GEAR

CC ID: 583406
Seq. Order: 84
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Bird mitigation. Was the gear weighted? 1=used.
General Data Type: VARCHAR2

LINE_SHOOTER

CC ID: 583407
Seq. Order: 85
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Bird mitigation. Was a line shooter used? 1=used.
General Data Type: VARCHAR2

OFFAL_DISCARD

CC ID: 583408
Seq. Order: 86
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Bird mitigation. Was the offal discarded strategically? 1=used.
General Data Type: VARCHAR2

HOOKS_LOST

CC ID: 583409
Seq. Order: 87
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Number of hooks lost on the set.
General Data Type: VARCHAR2

VERSION

CC ID: 583410
Seq. Order: 88
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Llps extraction/archive date.
General Data Type: VARCHAR2

CERTIFICATE_NUMBER

CC ID: 583411
Seq. Order: 89
Data Storage Type: VARCHAR2
Max Length: 9
Required: No
Primary Key: No
Status: Active
Description:

Unique number on the shallow-set certificate used to track each certificate (Hawaii Logbook Only).
General Data Type: VARCHAR2

BATCH_NUMBER

CC ID: 583412
Seq. Order: 90
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D14001.
General Data Type: VARCHAR2

AREA

CC ID: 583413
Seq. Order: 91
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Primary Economic Exclusivity Zone. Contains "OUT", or 4-letter EEZ code if Begin Set location is within established EEZ.
General Data Type: VARCHAR2

AREA2

CC ID: 583414
Seq. Order: 92
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Secondary Economic Exclusivity Zone. Contains NULL, or 4-letter EEZ code.
General Data Type: VARCHAR2

DISTANCE

CC ID: 583415
Seq. Order: 93
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Distance, calculated from Begin Set location to predefined location in AREA2.
General Data Type: VARCHAR2

SEQUENCE_NUMBER

CC ID: 583416
Seq. Order: 94
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

A consecutive number that is assigned to each record of a block of data.
General Data Type: VARCHAR2

UPDATED

CC ID: 583417
Seq. Order: 95
Data Storage Type: DATE
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Date when the record was loaded into Oracle.
General Data Type: DATE

SIDE_SET

CC ID: 583418
Seq. Order: 96
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Was the line set over the side of the vessel instead of the rear? (Y/N).
General Data Type: VARCHAR2

TYPE_SET

CC ID: 583419
Seq. Order: 97
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code signifying whether this set was either Deep or Shallow.
General Data Type: VARCHAR2

E150

CC ID: 583420
Seq. Order: 98
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicates whether location in Eastern Pacific Ocean (Y/N); no longer used.
General Data Type: VARCHAR2

REMARKS

CC ID: 583421
Seq. Order: 99
Data Storage Type: VARCHAR2
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

A number or name assigned to any document containing any further notes on this trip.
General Data Type: VARCHAR2

TRIP_CORRECTION_CODE

CC ID: 583422
Seq. Order: 100
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Code signifying when in the editing process a correction was made to the trip data in this record.
General Data Type: VARCHAR2

TRIP_LOCATION_CODE

CC ID: 583423
Seq. Order: 101
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code signifying whether ALL trip locations were to the East, West, or Straddled Longitude 150.
General Data Type: VARCHAR2

OBSERVER_TRIP_NUMBER

CC ID: 583424
Seq. Order: 102
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

The observer trip number as assigned by the Observer Program.
General Data Type: VARCHAR2

OBSERVER_SET_NUMBER

CC ID: 583425
Seq. Order: 103
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

The number of the set as assigned by the onboard observer, left-justified, leading zero(s) missing.
General Data Type: VARCHAR2

SET_CORRECTION_CODE

CC ID: 583426
Seq. Order: 104
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Code signifying when in the editing process a correction was made to the set data in this record.
General Data Type: VARCHAR2

SET_TYPE

CC ID: 583427
Seq. Order: 105
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code signifying whether this set was either Deep or Shallow.
General Data Type: VARCHAR2

BEGIN_SET_LOCATION_CODE

CC ID: 583428
Seq. Order: 106
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code signifying whether this begin set location is East or West of Longitude 150. If = 150, it is West.
General Data Type: VARCHAR2

END_SET_LOCATION_CODE

CC ID: 583429
Seq. Order: 107
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code signifying whether this end set location is East or West of Longitude 150. If = 150, it is West.
General Data Type: VARCHAR2

BEGIN_HAUL_LOCATION_CODE

CC ID: 583430
Seq. Order: 108
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code signifying whether this begin haul location is East or West of Longitude 150. If = 150, it is West.
General Data Type: VARCHAR2

END_HAUL_LOCATION_CODE

CC ID: 583431
Seq. Order: 109
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code signifying whether this end haul location is East or West of Longitude 150. If = 150, it is west.
General Data Type: VARCHAR2

CATCH_CORRECTION_CODE

CC ID: 583432
Seq. Order: 110
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Code signifying when in the editing process a correction was made to this species record.
General Data Type: VARCHAR2

PSI_CORRECTION_CODE

CC ID: 583433
Seq. Order: 111
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Code signifying when in the editing process a correction was made to this protected species record.
General Data Type: VARCHAR2

VCODE

CC ID: 583434
Seq. Order: 112
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Code based on the vessel's name, to disguise the identity of the boat, allowing release of data which could be otherwise confidential.
General Data Type: VARCHAR2

FLEET

CC ID: 583435
Seq. Order: 113
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Indicates fleet (or Logbook) to which this record belongs. (e.g., AS = American Samoa Longline Logbook).
General Data Type: VARCHAR2

DPV

CC ID: 583436
Seq. Order: 114
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Specifies whether a boat is a dual-permit vessel. Y = Yes, NULL = No.
General Data Type: VARCHAR2

MONUMENT

CC ID: 583437
Seq. Order: 115
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Contains NULL, or 4-letter EEZ code if Begin Set location is within the Established Monument boundaries.
General Data Type: VARCHAR2

SERIAL_NUMBER2

CC ID: 583438
Seq. Order: 116
Data Storage Type: VARCHAR2
Max Length: 18
Required: No
Primary Key: No
Status: Active
Description:

It is the page number that is printed on the logbook form or the number assigned by the electronic logbook program.
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 47316
GUID: gov.noaa.nmfs.inport:47316
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2017-09-11 21:15+0000
Metadata Record Last Modified By: Bradley M Gough
Metadata Record Last Modified: 2025-02-20 00:44+0000
Metadata Record Published: 2025-02-20
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year