Daily Longline Fishing Log - American Samoa
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:47314 | Updated: February 20, 2025 | Published / External
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
![]() |
![]() |
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |