Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Daily Longline Fishing Log - American Samoa
Short Name: FC048A19AS
Status: Completed
Abstract:

American Samoa Longline Logbook Data.

Supplemental Information:

Source ID: FC048

Entity Information

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

American Samoa 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 stamped on the logbook form or the number assigned by the electronic logbook program. For American Samoa data, SERIAL_NUMBER and SERIAL_NUMBER2 contain the same data.
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 Null field; unique number on the shallow-set certificate used to track each certificate (Hawaii Logbook Only - Leave Blank for AS).
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
AREA1 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 Null field; no longer being used to mark whether location in Eastern Pacific Ocean (Y/N).
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 stamped on the logbook form or the number assigned by the electronic logbook program. For American Samoa data, SERIAL_NUMBER AND SERIAL_NUMBER2 contain the same data.

Attribute Details

DATASET_CODE

CC ID: 583092
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: 583093
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: 583094
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: 583095
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: 583096
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: 583097
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: 583098
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: 583099
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: 583100
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: 583101
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: 583102
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: 583103
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: 583104
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: 583105
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: 583106
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: 583107
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: 583108
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: 583109
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: 583110
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: 583111
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: 583112
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: 583113
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: 583114
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: 583115
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: 583116
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: 583117
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: 583118
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: 583119
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: 583120
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: 583121
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: 583122
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: 583123
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: 583124
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: 583125
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: 583126
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: 583127
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: 583128
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: 583129
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: 583130
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: 583131
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: 583132
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: 583133
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: 583134
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: 583135
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: 583136
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: 583137
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: 583138
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: 583139
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: 583140
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: 583141
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: 583142
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: 583143
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: 583144
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: 583145
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: 583146
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: 583147
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: 583148
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: 583149
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: 583150
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: 583151
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: 583152
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: 583153
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: 583154
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: 583155
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: 583156
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: 583157
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: 583158
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: 583159
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: 583160
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: 583161
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: 583162
Seq. Order: 71
Data Storage Type: VARCHAR2
Max Length: 18
Required: Yes
Primary Key: No
Status: Active
Description:

It is the page number that is stamped on the logbook form or the number assigned by the electronic logbook program. For American Samoa data, SERIAL_NUMBER and SERIAL_NUMBER2 contain the same data.

General Data Type: VARCHAR2

OBSERVER_ONBOARD_CODE

CC ID: 583163
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: 583164
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: 583165
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: 583166
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: 583167
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: 583168
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: 583169
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: 583170
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: 583171
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: 583172
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: 583173
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: 583174
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: 583175
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: 583176
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: 583177
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: 583178
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: 583179
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: 583180
Seq. Order: 89
Data Storage Type: VARCHAR2
Max Length: 9
Required: No
Primary Key: No
Status: Active
Description:

Null field; unique number on the shallow-set certificate used to track each certificate (Hawaii Logbook Only - Leave Blank for AS).

General Data Type: VARCHAR2

BATCH_NUMBER

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

AREA1

CC ID: 583182
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: 583183
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: 583184
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: 583185
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: 583186
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: 583187
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: 583188
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: 583189
Seq. Order: 98
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Null field; no longer being used to mark whether location in Eastern Pacific Ocean (Y/N).

General Data Type: VARCHAR2

REMARKS

CC ID: 583190
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: 583191
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: 583192
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: 583193
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: 583194
Seq. Order: 103
Data Storage Type: VARCHAR2
Max Length: 3
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: 583195
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: 583196
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: 583197
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: 583198
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: 583199
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: 583200
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: 583201
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: 583202
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: 583203
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: 583204
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: 583205
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: 583206
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: 583207
Seq. Order: 116
Data Storage Type: VARCHAR2
Max Length: 18
Required: Yes
Primary Key: No
Status: Active
Description:

It is the page number that is stamped on the logbook form or the number assigned by the electronic logbook program. For American Samoa data, SERIAL_NUMBER AND SERIAL_NUMBER2 contain the same data.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 47314
GUID: gov.noaa.nmfs.inport:47314
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:43+0000
Metadata Record Published: 2025-02-20
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year