Slide Menu
Lineage Process Step Issue: We have received reports of issues when working with Lineage Process Steps. We are currently trying to identify the root cause of this issue and release a fix as soon as possible. We apologize for any inconvenience in the meantime.
View All
Search Help Show/Hide Menu

Item Identification

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

Hawaii Longline Logbook Data

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
DATASET VARCHAR2 Source ID code assigned by data entry staff (FC048).
100
VERSION VARCHAR2 Format version of the data assigned by data entry staff.
100
TRIPTYPE VARCHAR2 Trip type code (B)illfish, (T)una, (M)ixed.
100
TRIPNUM VARCHAR2 The logbook trip number as assigned by the logbook Data Manager after the trip has returned. A value is required.
100
RSCH_EXPMTL_CODE CHAR Is this trip a research or experimental trip? (R/X).
100
LANDYR VARCHAR2 Four-digit year that the boat returned to port. A value is required.
100
LANDMON VARCHAR2 Month (00-12) that the boat returned to port.
100
SETYR VARCHAR2 Four-digit year the set occurred.
100
SETMON VARCHAR2 Two-digit month the set was made.
100
SETDAY VARCHAR2 Two-digit day the set was made.
100
VESSELNAME VARCHAR2 Name of vessel.
100
PERMITNUM VARCHAR2 Permit number.
100
TARGET VARCHAR2 The code of the primary species of fish targeted to be caught on this trip, (T)una, (B)illfish, (M)ixed.
100
BAIT VARCHAR2 Code to represent what bait was used.
100
MAINLINE VARCHAR2 Length in miles of mainline used. Units for values are nautical miles.
100
HOOKSSET VARCHAR2 Number of hooks set.
100
MINHKSFLT VARCHAR2 Minimum number of hooks used per float.
100
MAXHKSFLT VARCHAR2 Maximum number of hooks used per float.
100
LIGHTSTICKS VARCHAR2 Number of light sticks used.
100
MINWINDSPD VARCHAR2 Minimum wind speed during the setting of hooks. Units for values are knots.
100
MAXWINDSPD VARCHAR2 Maximum wind speed during the setting of hooks. Units for values are knots.
100
WINDDIR VARCHAR2 Direction the wind was blowing during the setting of hooks.
100
MINWAVEHGT VARCHAR2 Minimum wave height during the setting of hooks. Units for values are feet.
100
MAXWAVEHGT VARCHAR2 Maximum wave height during the setting of hooks. Units for values are feet.
100
SURFTEMP VARCHAR2 Sea surface temperature during the setting of hooks. Units for values are degrees Fahrenheit.
100
BSHR VARCHAR2 Hour when line setting began.
100
BSMIN VARCHAR2 Minute when line setting began.
100
BSLATDEG VARCHAR2 Latitude degrees where line setting began. Units for values are degrees.
100
BSLATMIN VARCHAR2 Latitude minutes where line setting began. Units for values are minutes.
100
BSLATDIR VARCHAR2 Latitude hemisphere where line setting began.
100
BSLONGDEG VARCHAR2 Longitude degrees where line setting began. Units for values are degrees.
100
BSLONGMIN VARCHAR2 Longitude minutes where line setting began. Units for values are minutes.
100
BSLONGDIR VARCHAR2 Longitude hemisphere where line setting began.
100
ESHR VARCHAR2 Hour when line setting ended.
100
ESMIN VARCHAR2 Minute when line setting ended.
100
ESLATDEG VARCHAR2 Latitude degrees where line setting ended. Units for values are degrees.
100
ESLATMIN VARCHAR2 Latitude minutes where line setting ended. Units for values are minutes.
100
ESLATDIR VARCHAR2 Latitude hemisphere where line setting ended.
100
ESLONGDEG VARCHAR2 Longitude degrees where line setting ended. Units for values are degrees.
100
ESLONGMIN VARCHAR2 Longitude minutes where line setting ended. Units for values are minutes.
100
ESLONGDIR VARCHAR2 Longitude hemisphere where line setting ended.
100
HAULYR VARCHAR2 Four-digit year when the haul began.
100
HAULMON VARCHAR2 Two-digit month when the haul began.
100
HAULDAY VARCHAR2 Two-digit day when the haul began.
100
BHHR VARCHAR2 Hour when line hauling was started.
100
BHMIN VARCHAR2 Minute when line hauling was started.
100
BHLATDEG VARCHAR2 Latitude degrees where line hauling began.
100
BHLATMIN VARCHAR2 Latitude minutes where line hauling began.
100
BHLATDIR VARCHAR2 Latitude hemisphere where line hauling began.
100
BHLONGDEG VARCHAR2 Longitude degrees where line hauling began.
100
BHLONGMIN VARCHAR2 Longitude minutes where line hauling began.
100
BHLONGDIR VARCHAR2 Longitude hemisphere where line hauling began.
100
EHHR VARCHAR2 Hour when line hauling ended.
100
EHMIN VARCHAR2 Minute when line hauling ended.
100
EHLATDEG VARCHAR2 Latitude degrees where line hauling ended.
100
EHLATMIN VARCHAR2 Latitude minutes where line hauling ended.
100
EHLATDIR VARCHAR2 Latitude hemisphere where line hauling ended.
100
EHLONGDEG VARCHAR2 Longitude degrees where line hauling ended.
100
EHLONGMIN VARCHAR2 Longitude minutes where line hauling ended.
100
EHLONGDIR VARCHAR2 Longitude hemisphere where line hauling ended.
100
CML VARCHAR2 Commercial Marine License (CML) number.
100
SIGNYR VARCHAR2 Four-digit year when form was signed by the CML holder.
100
SIGNMON VARCHAR2 Two-digit month when form was signed by the CML holder.
100
SIGNDAY VARCHAR2 Two-digit day when form was signed by the fisher.
100
EDIT VARCHAR2 Code signifying when in the editing process a correction was made to this record.
100
SERIALNUM 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. A value is required.
100
OBSERVER_YN VARCHAR2 Was an observer onboard? (Y/NULL).
100
DEPART_YR VARCHAR2 Four-digit year fishing boat left port.
100
DEPART_MON VARCHAR2 Two-digit month fishing boat left port.
100
DEPART_DAY VARCHAR2 Two-digit day fishing boat left port.
100
DEPART_PORT VARCHAR2 Code to represent departing port of vessel. Uses three-letter Airline City Codes.
100
RETURN_YR VARCHAR2 Four-digit year boat returned to port.
100
RETURN_MON 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
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
CERTNUM VARCHAR2 Unique number on the shallow-set certificate used to track each certificate (Hawaii Logbook Only).
100
SIDESET VARCHAR2 Was the line set over the side of the vessel instead of the rear? (Y/N).
100
TRIP_CORR VARCHAR2 Code signifying when in the editing process a correction was made to the trip data in this record.
100
TRIPLOCA VARCHAR2 Code signifying whether ALL trip locations were to the East, West, or Straddled Longitude 150.
100
OBSTRIPNUM VARCHAR2 The observer trip number as assigned by the Observer Program.
100
OBSSETNUM VARCHAR2 The number of the set as assigned by the onboard observer, left-justified, leading zero(s) missing.
100
SET_CORR 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
BSETLOCA VARCHAR2 Code signifying whether this begin set location is East or West of Longitude 150. If = 150, it is West.
100
ESETLOCA VARCHAR2 Code signifying whether this end set location is East or West of Longitude 150. If = 150, it is West.
100
BHAULOCA VARCHAR2 Code signifying whether this begin haul location is East or West of Longitude 150. If = 150, it is West.
100
EHAULOCA VARCHAR2 Code signifying whether this end haul location is East or West of Longitude 150. If = 150, it is west.
100
REMARKS VARCHAR2 A number or name assigned to any document containing any further notes on this trip.
100
FLEET VARCHAR2 Indicates fleet (or Logbook) to which this record belongs. (e.g., AS = American Samoa Longline Logbook).
100
MONUMENT VARCHAR2 Contains NULL, or 4-letter EEZ code if Begin Set location is within the Established Monument boundaries.
100
DPV VARCHAR2 Specifies whether a boat is a dual-permit vessel. Y = Yes, NULL = No.
100
BATCHNO 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
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
CONF VARCHAR2 Null field; used for American Samoa fleet only; denotes code for confidentiality.
100
SERIALNUM2 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

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

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

TRIPTYPE

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

TRIPNUM

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

The logbook trip number as assigned by the logbook Data Manager after the trip has returned. A value is required.

General Data Type: VARCHAR2

RSCH_EXPMTL_CODE

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

Is this trip a research or experimental trip? (R/X).

General Data Type: CHAR

LANDYR

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

Four-digit year that the boat returned to port. A value is required.

General Data Type: VARCHAR2

LANDMON

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

SETYR

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

SETMON

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

SETDAY

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

VESSELNAME

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

PERMITNUM

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

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

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

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

HOOKSSET

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

MINHKSFLT

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

MAXHKSFLT

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

LIGHTSTICKS

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

MINWINDSPD

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

MAXWINDSPD

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

WINDDIR

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

MINWAVEHGT

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

MAXWAVEHGT

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

SURFTEMP

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

Sea surface temperature during the setting of hooks. Units for values are degrees Fahrenheit.

General Data Type: VARCHAR2
Unit of Measure: degrees Fahrenheit

BSHR

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

Hour when line setting began.

General Data Type: VARCHAR2

BSMIN

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

Minute when line setting began.

General Data Type: VARCHAR2

BSLATDEG

CC ID: 707463
Seq. Order: 28
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

BSLATMIN

CC ID: 707464
Seq. Order: 29
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

BSLATDIR

CC ID: 707465
Seq. Order: 30
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

BSLONGDEG

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

Longitude degrees where line setting began. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

BSLONGMIN

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

Longitude minutes where line setting began. Units for values are minutes.

General Data Type: VARCHAR2
Unit of Measure: minutes

BSLONGDIR

CC ID: 707468
Seq. Order: 33
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

ESHR

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

Hour when line setting ended.

General Data Type: VARCHAR2

ESMIN

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

Minute when line setting ended.

General Data Type: VARCHAR2

ESLATDEG

CC ID: 707471
Seq. Order: 36
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

ESLATMIN

CC ID: 707472
Seq. Order: 37
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

ESLATDIR

CC ID: 707473
Seq. Order: 38
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

ESLONGDEG

CC ID: 707474
Seq. Order: 39
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

ESLONGMIN

CC ID: 707475
Seq. Order: 40
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

ESLONGDIR

CC ID: 707476
Seq. Order: 41
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

HAULYR

CC ID: 707477
Seq. Order: 42
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

HAULMON

CC ID: 707478
Seq. Order: 43
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

HAULDAY

CC ID: 707479
Seq. Order: 44
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

BHHR

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

Hour when line hauling was started.

General Data Type: VARCHAR2

BHMIN

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

Minute when line hauling was started.

General Data Type: VARCHAR2

BHLATDEG

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

Latitude degrees where line hauling began.

General Data Type: VARCHAR2

BHLATMIN

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

Latitude minutes where line hauling began.

General Data Type: VARCHAR2

BHLATDIR

CC ID: 707484
Seq. Order: 49
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

BHLONGDEG

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

Longitude degrees where line hauling began.

General Data Type: VARCHAR2

BHLONGMIN

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

Longitude minutes where line hauling began.

General Data Type: VARCHAR2

BHLONGDIR

CC ID: 707487
Seq. Order: 52
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

EHHR

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

Hour when line hauling ended.

General Data Type: VARCHAR2

EHMIN

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

Minute when line hauling ended.

General Data Type: VARCHAR2

EHLATDEG

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

Latitude degrees where line hauling ended.

General Data Type: VARCHAR2

EHLATMIN

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

Latitude minutes where line hauling ended.

General Data Type: VARCHAR2

EHLATDIR

CC ID: 707492
Seq. Order: 57
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

EHLONGDEG

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

Longitude degrees where line hauling ended.

General Data Type: VARCHAR2

EHLONGMIN

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

Longitude minutes where line hauling ended.

General Data Type: VARCHAR2

EHLONGDIR

CC ID: 707495
Seq. Order: 60
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

CML

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

Commercial Marine License (CML) number.

General Data Type: VARCHAR2

SIGNYR

CC ID: 707497
Seq. Order: 62
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

SIGNMON

CC ID: 707498
Seq. Order: 63
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

SIGNDAY

CC ID: 707499
Seq. Order: 64
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

CC ID: 707500
Seq. Order: 65
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

SERIALNUM

CC ID: 707501
Seq. Order: 66
Data Storage Type: VARCHAR2
Max Length: 18
Required: Yes
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. A value is required.

General Data Type: VARCHAR2

OBSERVER_YN

CC ID: 707502
Seq. Order: 67
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

DEPART_YR

CC ID: 707503
Seq. Order: 68
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

DEPART_MON

CC ID: 707504
Seq. Order: 69
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

DEPART_DAY

CC ID: 707505
Seq. Order: 70
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

DEPART_PORT

CC ID: 707506
Seq. Order: 71
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_YR

CC ID: 707507
Seq. Order: 72
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_MON

CC ID: 707508
Seq. Order: 73
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: 707509
Seq. Order: 74
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: 707510
Seq. Order: 75
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: 707511
Seq. Order: 76
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: 707512
Seq. Order: 77
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: 707513
Seq. Order: 78
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: 707514
Seq. Order: 79
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: 707515
Seq. Order: 80
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: 707516
Seq. Order: 81
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: 707517
Seq. Order: 82
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

AREA

CC ID: 707518
Seq. Order: 83
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: 707519
Seq. Order: 84
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: 707520
Seq. Order: 85
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

CERTNUM

CC ID: 707521
Seq. Order: 86
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

SIDESET

CC ID: 707522
Seq. Order: 87
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

TRIP_CORR

CC ID: 707523
Seq. Order: 88
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

TRIPLOCA

CC ID: 707524
Seq. Order: 89
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

OBSTRIPNUM

CC ID: 707525
Seq. Order: 90
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

OBSSETNUM

CC ID: 707526
Seq. Order: 91
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_CORR

CC ID: 707527
Seq. Order: 92
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: 707528
Seq. Order: 93
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

BSETLOCA

CC ID: 707529
Seq. Order: 94
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

ESETLOCA

CC ID: 707530
Seq. Order: 95
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

BHAULOCA

CC ID: 707531
Seq. Order: 96
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

EHAULOCA

CC ID: 707532
Seq. Order: 97
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

REMARKS

CC ID: 707533
Seq. Order: 98
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

FLEET

CC ID: 707534
Seq. Order: 99
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

MONUMENT

CC ID: 707535
Seq. Order: 100
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

DPV

CC ID: 707536
Seq. Order: 101
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

BATCHNO

CC ID: 707537
Seq. Order: 102
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

VCODE

CC ID: 707538
Seq. Order: 103
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

CONF

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

Null field; used for American Samoa fleet only; denotes code for confidentiality.

General Data Type: VARCHAR2

SERIALNUM2

CC ID: 707540
Seq. Order: 105
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: 50941
GUID: gov.noaa.nmfs.inport:50941
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2017-12-29 16:19+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