Daily Longline Fishing Log - American Samoa
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 47314
| Published / External
Created: 2017-09-11
|
Last Modified: 2025-02-20
Data Set (DS) | ID: 1775
ID: 47314
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Daily Longline Fishing Log - American Samoa |
---|---|
Short Name | FC048A19AS |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
American Samoa Longline Logbook Data. |
* Purpose | |
Notes | |
Other Citation Details | |
• Supplemental Information |
Source ID: FC048 |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | Data Table |
---|---|
Active Version? | Y |
Alias | |
Schema Name | ORADATA |
» Description |
American Samoa Longline Logbook Data. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | DATASET_CODE | VARCHAR2 | Source ID code assigned by data entry staff (FC048). |
100 | No | No | VERSION_CODE | VARCHAR2 | Format version of the data assigned by data entry staff. |
100 | No | No | TRIP_TYPE_CODE | VARCHAR2 | Trip type code (B)illfish, (T)una, (M)ixed. |
100 | No | No | TRIP_NUMBER | VARCHAR2 | The logbook trip number as assigned by the logbook Data Manager after the trip has returned. |
100 | No | No | RSCH_EXPMTL_CODE | VARCHAR2 | Is this trip a research or experimental trip? (R/X). |
100 | No | No | LANDING_YEAR | VARCHAR2 | Four-digit year that the boat returned to port. |
100 | No | No | LANDING_MONTH | VARCHAR2 | Month (00-12) that the boat returned to port. |
100 | No | No | SET_YEAR | VARCHAR2 | Four-digit year the set occurred. |
100 | No | No | SET_MONTH | VARCHAR2 | Two-digit month the set was made. |
100 | No | No | SET_DAY | VARCHAR2 | Two-digit day the set was made. |
100 | No | No | VESSEL_NAME | VARCHAR2 | Name of vessel. |
100 | No | No | PERMIT_NUMBER | VARCHAR2 | Permit number. |
100 | No | No | 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 | No | No | BAIT_CODE | VARCHAR2 | Code to represent what bait was used. |
100 | No | No | MAINLINE_LENGTH | VARCHAR2 | Length in miles of mainline used. Units for values are nautical miles. |
100 | No | No | NUMBER_OF_HOOKS_SET | VARCHAR2 | Number of hooks set. |
100 | No | No | MINIMUM_HOOKS_PER_FLOAT | VARCHAR2 | Minimum number of hooks used per float. |
100 | No | No | MAXIMUM_HOOKS_PER_FLOAT | VARCHAR2 | Maximum number of hooks used per float. |
100 | No | No | NUMBER_OF_LIGHT_STICKS | VARCHAR2 | Number of light sticks used. |
100 | No | No | MINIMUM_WINDSPEED | VARCHAR2 | Minimum wind speed during the setting of hooks. Units for values are knots. |
100 | No | No | MAXIMUM_WINDSPEED | VARCHAR2 | Maximum wind speed during the setting of hooks. Units for values are knots. |
100 | No | No | WIND_DIRECTION | VARCHAR2 | Direction the wind was blowing during the setting of hooks. |
100 | No | No | MINIMUM_WAVE_HEIGHT | VARCHAR2 | Minimum wave height during the setting of hooks. Units for values are feet. |
100 | No | No | MAXIMUM_WAVE_HEIGHT | VARCHAR2 | Maximum wave height during the setting of hooks. Units for values are feet. |
100 | No | No | 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 | No | No | BEGIN_SET_TIME | VARCHAR2 | Time when line setting began. |
100 | No | No | BEGIN_SET_LATITUDE_DEGREES | VARCHAR2 | Latitude degrees where line setting began. Units for values are degrees. |
100 | No | No | BEGIN_SET_LATITUDE_MINUTES | VARCHAR2 | Latitude minutes where line setting began. Units for values are minutes. |
100 | No | No | BEGIN_SET_LATITUDE_DIRECTION | VARCHAR2 | Latitude hemisphere where line setting began. |
100 | No | No | BEGIN_SET_LONGITUDE_DEGREES | VARCHAR2 | Longitude degrees where line setting began. |
100 | No | No | BEGIN_SET_LONGITUDE_MINUTES | VARCHAR2 | Longitude minutes where line setting began. |
100 | No | No | BEGIN_SET_LONGITUDE_DIRECTION | VARCHAR2 | Longitude hemisphere where line setting began. |
100 | No | No | END_SET_TIME | VARCHAR2 | Time when line setting ended. |
100 | No | No | END_SET_LATITUDE_DEGREES | VARCHAR2 | Latitude degrees where line setting ended. Units for values are degrees. |
100 | No | No | END_SET_LATITUDE_MINUTES | VARCHAR2 | Latitude minutes where line setting ended. Units for values are minutes. |
100 | No | No | END_SET_LATITUDE_DIRECTION | VARCHAR2 | Latitude hemisphere where line setting ended. |
100 | No | No | END_SET_LONGITUDE_DEGREES | VARCHAR2 | Longitude degrees where line setting ended. Units for values are degrees. |
100 | No | No | END_SET_LONGITUDE_MINUTES | VARCHAR2 | Longitude minutes where line setting ended. Units for values are minutes. |
100 | No | No | END_SET_LONGITUDE_DIRECTION | VARCHAR2 | Longitude hemisphere where line setting ended. |
100 | No | No | HAUL_YEAR | VARCHAR2 | Four-digit year when the haul began. |
100 | No | No | HAUL_MONTH | VARCHAR2 | Two-digit month when the haul began. |
100 | No | No | HAUL_DAY | VARCHAR2 | Two-digit day when the haul began. |
100 | No | No | BEGIN_HAUL_TIME | VARCHAR2 | Time when line hauling was started. |
100 | No | No | BEGIN_HAUL_LATITUDE_DEGREES | VARCHAR2 | Latitude degrees where line hauling began. Units for values are degrees. |
100 | No | No | BEGIN_HAUL_LATITUDE_MINUTES | VARCHAR2 | Latitude minutes where line hauling began. Units for values are minutes. |
100 | No | No | BEGIN_HAUL_LATITUDE_DIRECTION | VARCHAR2 | Latitude hemisphere where line hauling began. |
100 | No | No | BEGIN_HAUL_LONGITUDE_DEGREES | VARCHAR2 | Longitude degrees where line hauling began. Units for values are degrees. |
100 | No | No | BEGIN_HAUL_LONGITUDE_MINUTES | VARCHAR2 | Longitude minutes where line hauling began. Units for values are minutes. |
100 | No | No | BEGIN_HAUL_LONGITUDE_DIRECTION | VARCHAR2 | Longitude hemisphere where line hauling began. |
100 | No | No | END_HAUL_TIME | VARCHAR2 | Time when line hauling ended. |
100 | No | No | END_HAUL_LATITUDE_DEGREES | VARCHAR2 | Latitude degrees where line hauling ended. Units for values are degrees. |
100 | No | No | END_HAUL_LATITUDE_MINUTES | VARCHAR2 | Latitude minutes where line hauling ended. Units for values are minutes. |
100 | No | No | END_HAUL_LATITUDE_DIRECTION | VARCHAR2 | Latitude hemisphere where line hauling ended. |
100 | No | No | END_HAUL_LONGITUDE_DEGREES | VARCHAR2 | Longitude degrees where line hauling ended. Units for values are degrees. |
100 | No | No | END_HAUL_LONGITUDE_MINUTES | VARCHAR2 | Longitude minutes where line hauling ended. Units for values are minutes. |
100 | No | No | END_HAUL_LONGITUDE_DIRECTION | VARCHAR2 | Longitude hemisphere where line hauling ended. |
100 | No | No | SPECIES_CODE | VARCHAR2 | Pelagic species code (See reference table DSC.DSC_SPECIES_CROSSREF_NODC). |
100 | No | No | NUMBER_OF_SHARKS_FINNED | VARCHAR2 | Number of sharks that were Finned while fishing. |
100 | No | No | NUMBER_OF_FISH_KEPT | VARCHAR2 | Number of a particular species that were Kept while fishing. |
100 | No | No | NUMBER_OF_FISH_RELEASED | VARCHAR2 | Number of a particular species that were Released while fishing. |
100 | No | No | PROTECTED_SPECIES_CODE | VARCHAR2 | Protected species code (See reference table DSC.DSC_SPECIES_CROSSREF_NODC). |
100 | No | No | NUMBER_RELEASED_ALIVE_UNINJURE | VARCHAR2 | Number of a particular protected species released alive and uninjured. |
100 | No | No | NUMBER_RELEASED_INJURED | VARCHAR2 | Number of a particular protected species released injured. |
100 | No | No | NUMBER_RELEASED_DEAD | VARCHAR2 | Number of a partidular protected species released dead. |
100 | No | No | NUMBER_SIGHTED_IN_AREA_OF_GEAR | VARCHAR2 | Number of a particular protected species sighted in area of gear. |
100 | No | No | COMMERCIAL_MARINE_LICENSE_NUM | VARCHAR2 | Commercial Marine License (CML) number. |
100 | No | No | SIGN_YEAR | VARCHAR2 | Four-digit year when form was signed by the CML holder. |
100 | No | No | SIGN_MONTH | VARCHAR2 | Two-digit month when form was signed by the CML holder. |
100 | No | No | SIGN_DAY | VARCHAR2 | Two-digit day when form was signed by the fisher. |
100 | No | No | EDIT_CODE | VARCHAR2 | Code signifying when in the editing process a correction was made to this record. |
100 | Yes | No | 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 | No | No | OBSERVER_ONBOARD_CODE | VARCHAR2 | Was an observer onboard? (Y/NULL). |
100 | No | No | DEPARTURE_YEAR | VARCHAR2 | Four-digit year fishing boat left port. |
100 | No | No | DEPARTURE_MONTH | VARCHAR2 | Two-digit month fishing boat left port. |
100 | No | No | DEPARTURE_DAY | VARCHAR2 | Two-digit day fishing boat left port. |
100 | No | No | DEPARTURE_PORT | VARCHAR2 | Code to represent departing port of vessel. Uses three-letter Airline City Codes. |
100 | No | No | RETURN_YEAR | VARCHAR2 | Four-digit year boat returned to port. |
100 | No | No | RETURN_MONTH | VARCHAR2 | Two-digit month boat returned to port. |
100 | No | No | RETURN_DAY | VARCHAR2 | Two-digit day boat returned to port. |
100 | No | No | RETURN_PORT | VARCHAR2 | Code to represent returning port of vessel. Uses three-letter Airline City Codes. |
100 | No | No | NIGHT_SETTING | VARCHAR2 | Bird mitigation. Was the set made at night? 1=used. |
100 | No | No | DYED_BAIT | VARCHAR2 | Bird mitigation. Was the bait dyed blue? 1=used. |
100 | No | No | TOWED_DETERRENT | VARCHAR2 | Bird mitigation. Was a towed deterrent used? 1=used. |
100 | No | No | WEIGHTED_GEAR | VARCHAR2 | Bird mitigation. Was the gear weighted? 1=used. |
100 | No | No | LINE_SHOOTER | VARCHAR2 | Bird mitigation. Was a line shooter used? 1=used. |
100 | No | No | OFFAL_DISCARD | VARCHAR2 | Bird mitigation. Was the offal discarded strategically? 1=used. |
100 | No | No | HOOKS_LOST | VARCHAR2 | Number of hooks lost on the set. |
100 | No | No | VERSION | VARCHAR2 | Llps extraction/archive date. |
100 | No | No | 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 | No | No | 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 | No | No | AREA1 | VARCHAR2 | Primary Economic Exclusivity Zone. Contains "OUT", or 4-letter EEZ code if Begin Set location is within established EEZ. |
100 | No | No | AREA2 | VARCHAR2 | Secondary Economic Exclusivity Zone. Contains NULL, or 4-letter EEZ code. |
100 | No | No | DISTANCE | VARCHAR2 | Distance, calculated from Begin Set location to predefined location in AREA2. |
100 | No | No | SEQUENCE_NUMBER | VARCHAR2 | A consecutive number that is assigned to each record of a block of data. |
100 | No | No | UPDATED | DATE | Date when the record was loaded into Oracle. |
100 | No | No | SIDE_SET | VARCHAR2 | Was the line set over the side of the vessel instead of the rear? (Y/N). |
100 | No | No | TYPE_SET | VARCHAR2 | Code signifying whether this set was either Deep or Shallow. |
100 | No | No | E150 | VARCHAR2 | Null field; no longer being used to mark whether location in Eastern Pacific Ocean (Y/N). |
100 | No | No | REMARKS | VARCHAR2 | A number or name assigned to any document containing any further notes on this trip. |
100 | No | No | TRIP_CORRECTION_CODE | VARCHAR2 | Code signifying when in the editing process a correction was made to the trip data in this record. |
100 | No | No | TRIP_LOCATION_CODE | VARCHAR2 | Code signifying whether ALL trip locations were to the East, West, or Straddled Longitude 150. |
100 | No | No | OBSERVER_TRIP_NUMBER | VARCHAR2 | The observer trip number as assigned by the Observer Program. |
100 | No | No | OBSERVER_SET_NUMBER | VARCHAR2 | The number of the set as assigned by the onboard observer, left-justified, leading zero(s) missing. |
100 | No | No | SET_CORRECTION_CODE | VARCHAR2 | Code signifying when in the editing process a correction was made to the set data in this record. |
100 | No | No | SET_TYPE | VARCHAR2 | Code signifying whether this set was either Deep or Shallow. |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | CATCH_CORRECTION_CODE | VARCHAR2 | Code signifying when in the editing process a correction was made to this species record. |
100 | No | No | PSI_CORRECTION_CODE | VARCHAR2 | Code signifying when in the editing process a correction was made to this protected species record. |
100 | No | No | 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 | No | No | FLEET | VARCHAR2 | Indicates fleet (or Logbook) to which this record belongs. (e.g., AS = American Samoa Longline Logbook). |
100 | No | No | DPV | VARCHAR2 | Specifies whether a boat is a dual-permit vessel. Y = Yes, NULL = No. |
100 | No | No | MONUMENT | VARCHAR2 | Contains NULL, or 4-letter EEZ code if Begin Set location is within the Established Monument boundaries. |
100 | Yes | No | 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
Attribute Name | DATASET_CODE |
---|---|
Seq. Order | 1 |
Data Storage Type | VARCHAR2 |
Max Length | 5 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Source ID code assigned by data entry staff (FC048). |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | VERSION_CODE |
---|---|
Seq. Order | 2 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Format version of the data assigned by data entry staff. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TRIP_TYPE_CODE |
---|---|
Seq. Order | 3 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Trip type code (B)illfish, (T)una, (M)ixed. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TRIP_NUMBER |
---|---|
Seq. Order | 4 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The logbook trip number as assigned by the logbook Data Manager after the trip has returned. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RSCH_EXPMTL_CODE |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Is this trip a research or experimental trip? (R/X). |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LANDING_YEAR |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Four-digit year that the boat returned to port. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LANDING_MONTH |
---|---|
Seq. Order | 7 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Month (00-12) that the boat returned to port. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SET_YEAR |
---|---|
Seq. Order | 8 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Four-digit year the set occurred. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SET_MONTH |
---|---|
Seq. Order | 9 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Two-digit month the set was made. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SET_DAY |
---|---|
Seq. Order | 10 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Two-digit day the set was made. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | VESSEL_NAME |
---|---|
Seq. Order | 11 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of vessel. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PERMIT_NUMBER |
---|---|
Seq. Order | 12 |
Data Storage Type | VARCHAR2 |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Permit number. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TARGET_SPECIES_CODE |
---|---|
Seq. Order | 13 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BAIT_CODE |
---|---|
Seq. Order | 14 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code to represent what bait was used. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MAINLINE_LENGTH |
---|---|
Seq. Order | 15 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Length in miles of mainline used. Units for values are nautical miles. |
General Data Type | VARCHAR2 |
Unit of Measure | nautical miles |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NUMBER_OF_HOOKS_SET |
---|---|
Seq. Order | 16 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of hooks set. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MINIMUM_HOOKS_PER_FLOAT |
---|---|
Seq. Order | 17 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Minimum number of hooks used per float. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MAXIMUM_HOOKS_PER_FLOAT |
---|---|
Seq. Order | 18 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Maximum number of hooks used per float. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NUMBER_OF_LIGHT_STICKS |
---|---|
Seq. Order | 19 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of light sticks used. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MINIMUM_WINDSPEED |
---|---|
Seq. Order | 20 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Minimum wind speed during the setting of hooks. Units for values are knots. |
General Data Type | VARCHAR2 |
Unit of Measure | knots |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MAXIMUM_WINDSPEED |
---|---|
Seq. Order | 21 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Maximum wind speed during the setting of hooks. Units for values are knots. |
General Data Type | VARCHAR2 |
Unit of Measure | knots |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | WIND_DIRECTION |
---|---|
Seq. Order | 22 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Direction the wind was blowing during the setting of hooks. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MINIMUM_WAVE_HEIGHT |
---|---|
Seq. Order | 23 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Minimum wave height during the setting of hooks. Units for values are feet. |
General Data Type | VARCHAR2 |
Unit of Measure | feet |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MAXIMUM_WAVE_HEIGHT |
---|---|
Seq. Order | 24 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Maximum wave height during the setting of hooks. Units for values are feet. |
General Data Type | VARCHAR2 |
Unit of Measure | feet |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SEA_SURFACE_TEMPERATURE |
---|---|
Seq. Order | 25 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BEGIN_SET_TIME |
---|---|
Seq. Order | 26 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Time when line setting began. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BEGIN_SET_LATITUDE_DEGREES |
---|---|
Seq. Order | 27 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Latitude degrees where line setting began. Units for values are degrees. |
General Data Type | VARCHAR2 |
Unit of Measure | degrees |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BEGIN_SET_LATITUDE_MINUTES |
---|---|
Seq. Order | 28 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Latitude minutes where line setting began. Units for values are minutes. |
General Data Type | VARCHAR2 |
Unit of Measure | minutes |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BEGIN_SET_LATITUDE_DIRECTION |
---|---|
Seq. Order | 29 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Latitude hemisphere where line setting began. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BEGIN_SET_LONGITUDE_DEGREES |
---|---|
Seq. Order | 30 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Longitude degrees where line setting began. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BEGIN_SET_LONGITUDE_MINUTES |
---|---|
Seq. Order | 31 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Longitude minutes where line setting began. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BEGIN_SET_LONGITUDE_DIRECTION |
---|---|
Seq. Order | 32 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Longitude hemisphere where line setting began. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | END_SET_TIME |
---|---|
Seq. Order | 33 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Time when line setting ended. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | END_SET_LATITUDE_DEGREES |
---|---|
Seq. Order | 34 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Latitude degrees where line setting ended. Units for values are degrees. |
General Data Type | VARCHAR2 |
Unit of Measure | degrees |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | END_SET_LATITUDE_MINUTES |
---|---|
Seq. Order | 35 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Latitude minutes where line setting ended. Units for values are minutes. |
General Data Type | VARCHAR2 |
Unit of Measure | minutes |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | END_SET_LATITUDE_DIRECTION |
---|---|
Seq. Order | 36 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Latitude hemisphere where line setting ended. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | END_SET_LONGITUDE_DEGREES |
---|---|
Seq. Order | 37 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Longitude degrees where line setting ended. Units for values are degrees. |
General Data Type | VARCHAR2 |
Unit of Measure | degrees |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | END_SET_LONGITUDE_MINUTES |
---|---|
Seq. Order | 38 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Longitude minutes where line setting ended. Units for values are minutes. |
General Data Type | VARCHAR2 |
Unit of Measure | minutes |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | END_SET_LONGITUDE_DIRECTION |
---|---|
Seq. Order | 39 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Longitude hemisphere where line setting ended. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | HAUL_YEAR |
---|---|
Seq. Order | 40 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Four-digit year when the haul began. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | HAUL_MONTH |
---|---|
Seq. Order | 41 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Two-digit month when the haul began. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | HAUL_DAY |
---|---|
Seq. Order | 42 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Two-digit day when the haul began. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BEGIN_HAUL_TIME |
---|---|
Seq. Order | 43 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Time when line hauling was started. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BEGIN_HAUL_LATITUDE_DEGREES |
---|---|
Seq. Order | 44 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Latitude degrees where line hauling began. Units for values are degrees. |
General Data Type | VARCHAR2 |
Unit of Measure | degrees |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BEGIN_HAUL_LATITUDE_MINUTES |
---|---|
Seq. Order | 45 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Latitude minutes where line hauling began. Units for values are minutes. |
General Data Type | VARCHAR2 |
Unit of Measure | minutes |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BEGIN_HAUL_LATITUDE_DIRECTION |
---|---|
Seq. Order | 46 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Latitude hemisphere where line hauling began. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BEGIN_HAUL_LONGITUDE_DEGREES |
---|---|
Seq. Order | 47 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Longitude degrees where line hauling began. Units for values are degrees. |
General Data Type | VARCHAR2 |
Unit of Measure | degrees |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BEGIN_HAUL_LONGITUDE_MINUTES |
---|---|
Seq. Order | 48 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Longitude minutes where line hauling began. Units for values are minutes. |
General Data Type | VARCHAR2 |
Unit of Measure | minutes |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BEGIN_HAUL_LONGITUDE_DIRECTION |
---|---|
Seq. Order | 49 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Longitude hemisphere where line hauling began. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | END_HAUL_TIME |
---|---|
Seq. Order | 50 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Time when line hauling ended. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | END_HAUL_LATITUDE_DEGREES |
---|---|
Seq. Order | 51 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Latitude degrees where line hauling ended. Units for values are degrees. |
General Data Type | VARCHAR2 |
Unit of Measure | degrees |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | END_HAUL_LATITUDE_MINUTES |
---|---|
Seq. Order | 52 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Latitude minutes where line hauling ended. Units for values are minutes. |
General Data Type | VARCHAR2 |
Unit of Measure | minutes |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | END_HAUL_LATITUDE_DIRECTION |
---|---|
Seq. Order | 53 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Latitude hemisphere where line hauling ended. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | END_HAUL_LONGITUDE_DEGREES |
---|---|
Seq. Order | 54 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Longitude degrees where line hauling ended. Units for values are degrees. |
General Data Type | VARCHAR2 |
Unit of Measure | degrees |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | END_HAUL_LONGITUDE_MINUTES |
---|---|
Seq. Order | 55 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Longitude minutes where line hauling ended. Units for values are minutes. |
General Data Type | VARCHAR2 |
Unit of Measure | minutes |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | END_HAUL_LONGITUDE_DIRECTION |
---|---|
Seq. Order | 56 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Longitude hemisphere where line hauling ended. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SPECIES_CODE |
---|---|
Seq. Order | 57 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Pelagic species code (See reference table DSC.DSC_SPECIES_CROSSREF_NODC). |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NUMBER_OF_SHARKS_FINNED |
---|---|
Seq. Order | 58 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of sharks that were Finned while fishing. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NUMBER_OF_FISH_KEPT |
---|---|
Seq. Order | 59 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of a particular species that were Kept while fishing. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NUMBER_OF_FISH_RELEASED |
---|---|
Seq. Order | 60 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of a particular species that were Released while fishing. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PROTECTED_SPECIES_CODE |
---|---|
Seq. Order | 61 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Protected species code (See reference table DSC.DSC_SPECIES_CROSSREF_NODC). |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NUMBER_RELEASED_ALIVE_UNINJURE |
---|---|
Seq. Order | 62 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of a particular protected species released alive and uninjured. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NUMBER_RELEASED_INJURED |
---|---|
Seq. Order | 63 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of a particular protected species released injured. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NUMBER_RELEASED_DEAD |
---|---|
Seq. Order | 64 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of a partidular protected species released dead. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NUMBER_SIGHTED_IN_AREA_OF_GEAR |
---|---|
Seq. Order | 65 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of a particular protected species sighted in area of gear. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | COMMERCIAL_MARINE_LICENSE_NUM |
---|---|
Seq. Order | 66 |
Data Storage Type | VARCHAR2 |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Commercial Marine License (CML) number. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SIGN_YEAR |
---|---|
Seq. Order | 67 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Four-digit year when form was signed by the CML holder. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SIGN_MONTH |
---|---|
Seq. Order | 68 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Two-digit month when form was signed by the CML holder. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SIGN_DAY |
---|---|
Seq. Order | 69 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Two-digit day when form was signed by the fisher. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | EDIT_CODE |
---|---|
Seq. Order | 70 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code signifying when in the editing process a correction was made to this record. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SERIAL_NUMBER |
---|---|
Seq. Order | 71 |
Data Storage Type | VARCHAR2 |
Max Length | 18 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OBSERVER_ONBOARD_CODE |
---|---|
Seq. Order | 72 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Was an observer onboard? (Y/NULL). |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DEPARTURE_YEAR |
---|---|
Seq. Order | 73 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Four-digit year fishing boat left port. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DEPARTURE_MONTH |
---|---|
Seq. Order | 74 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Two-digit month fishing boat left port. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DEPARTURE_DAY |
---|---|
Seq. Order | 75 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Two-digit day fishing boat left port. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DEPARTURE_PORT |
---|---|
Seq. Order | 76 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code to represent departing port of vessel. Uses three-letter Airline City Codes. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RETURN_YEAR |
---|---|
Seq. Order | 77 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Four-digit year boat returned to port. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RETURN_MONTH |
---|---|
Seq. Order | 78 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Two-digit month boat returned to port. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RETURN_DAY |
---|---|
Seq. Order | 79 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Two-digit day boat returned to port. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RETURN_PORT |
---|---|
Seq. Order | 80 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code to represent returning port of vessel. Uses three-letter Airline City Codes. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NIGHT_SETTING |
---|---|
Seq. Order | 81 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Bird mitigation. Was the set made at night? 1=used. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DYED_BAIT |
---|---|
Seq. Order | 82 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Bird mitigation. Was the bait dyed blue? 1=used. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TOWED_DETERRENT |
---|---|
Seq. Order | 83 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Bird mitigation. Was a towed deterrent used? 1=used. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | WEIGHTED_GEAR |
---|---|
Seq. Order | 84 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Bird mitigation. Was the gear weighted? 1=used. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LINE_SHOOTER |
---|---|
Seq. Order | 85 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Bird mitigation. Was a line shooter used? 1=used. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OFFAL_DISCARD |
---|---|
Seq. Order | 86 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Bird mitigation. Was the offal discarded strategically? 1=used. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | HOOKS_LOST |
---|---|
Seq. Order | 87 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of hooks lost on the set. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | VERSION |
---|---|
Seq. Order | 88 |
Data Storage Type | VARCHAR2 |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Llps extraction/archive date. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CERTIFICATE_NUMBER |
---|---|
Seq. Order | 89 |
Data Storage Type | VARCHAR2 |
Max Length | 9 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BATCH_NUMBER |
---|---|
Seq. Order | 90 |
Data Storage Type | VARCHAR2 |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | AREA1 |
---|---|
Seq. Order | 91 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | AREA2 |
---|---|
Seq. Order | 92 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Secondary Economic Exclusivity Zone. Contains NULL, or 4-letter EEZ code. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DISTANCE |
---|---|
Seq. Order | 93 |
Data Storage Type | VARCHAR2 |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Distance, calculated from Begin Set location to predefined location in AREA2. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SEQUENCE_NUMBER |
---|---|
Seq. Order | 94 |
Data Storage Type | VARCHAR2 |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A consecutive number that is assigned to each record of a block of data. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | UPDATED |
---|---|
Seq. Order | 95 |
Data Storage Type | DATE |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date when the record was loaded into Oracle. |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SIDE_SET |
---|---|
Seq. Order | 96 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Was the line set over the side of the vessel instead of the rear? (Y/N). |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TYPE_SET |
---|---|
Seq. Order | 97 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code signifying whether this set was either Deep or Shallow. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | E150 |
---|---|
Seq. Order | 98 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Null field; no longer being used to mark whether location in Eastern Pacific Ocean (Y/N). |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | REMARKS |
---|---|
Seq. Order | 99 |
Data Storage Type | VARCHAR2 |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A number or name assigned to any document containing any further notes on this trip. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TRIP_CORRECTION_CODE |
---|---|
Seq. Order | 100 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TRIP_LOCATION_CODE |
---|---|
Seq. Order | 101 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code signifying whether ALL trip locations were to the East, West, or Straddled Longitude 150. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OBSERVER_TRIP_NUMBER |
---|---|
Seq. Order | 102 |
Data Storage Type | VARCHAR2 |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The observer trip number as assigned by the Observer Program. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OBSERVER_SET_NUMBER |
---|---|
Seq. Order | 103 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The number of the set as assigned by the onboard observer, left-justified, leading zero(s) missing. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SET_CORRECTION_CODE |
---|---|
Seq. Order | 104 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SET_TYPE |
---|---|
Seq. Order | 105 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code signifying whether this set was either Deep or Shallow. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BEGIN_SET_LOCATION_CODE |
---|---|
Seq. Order | 106 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | END_SET_LOCATION_CODE |
---|---|
Seq. Order | 107 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BEGIN_HAUL_LOCATION_CODE |
---|---|
Seq. Order | 108 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | END_HAUL_LOCATION_CODE |
---|---|
Seq. Order | 109 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CATCH_CORRECTION_CODE |
---|---|
Seq. Order | 110 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code signifying when in the editing process a correction was made to this species record. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PSI_CORRECTION_CODE |
---|---|
Seq. Order | 111 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code signifying when in the editing process a correction was made to this protected species record. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | VCODE |
---|---|
Seq. Order | 112 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FLEET |
---|---|
Seq. Order | 113 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates fleet (or Logbook) to which this record belongs. (e.g., AS = American Samoa Longline Logbook). |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DPV |
---|---|
Seq. Order | 114 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Specifies whether a boat is a dual-permit vessel. Y = Yes, NULL = No. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MONUMENT |
---|---|
Seq. Order | 115 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Contains NULL, or 4-letter EEZ code if Begin Set location is within the Established Monument boundaries. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SERIAL_NUMBER2 |
---|---|
Seq. Order | 116 |
Data Storage Type | VARCHAR2 |
Max Length | 18 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 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 Workflow State | Published / External |
Metadata Last Review Date | |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date |
Tags |
---|