Table: HAUL
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:7510 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | Table: HAUL |
---|---|
Short Name: | HAUL |
Status: | Completed |
Abstract: |
Hauls are unique fishing events of gear deployment and retrieval and may also contain information unique to a day where no fishing occured. |
Notes: |
Loaded by batch 2204, 03-28-2008 14:09 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | TURNBULLD |
Description: |
Hauls are unique fishing events of gear deployment and retrieval and may also contain information unique to a day where no fishing occured. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
HAUL_SEQ | NUMBER | Sequence generated unique identifier for a haul record | |
100
|
HAUL_NUMBER | NUMBER | Number which is entered by the observer identifying a unique haul within a trip. Since records are not physically deleted, trigger code preserves uniqueness by allowing only a single active record to exist (delete_marker IS NOT NULL). | |
100
|
HAUL_PURPOSE_CODE | VARCHAR2 | Haul data may be utilized for catch accounting, stock assessment, or for various special projects. This field is entered by the observer and not validated by ATLAS. Validation is performed when loaded into the production NORPAC data set. | |
100
|
CDQ_CODE | VARCHAR2 | Unique AlphaNumeric code representing a CDQ or research group | |
100
|
TRIP_SEQ | NUMBER | Sequence generated unique identifier of a trip | |
100
|
DELIVERY_VESSEL_ADFG | VARCHAR2 | ADFG number entered by the observer if the delivering vessel does not exist in the vessel lookup table. | |
100
|
GEAR_PERFORMANCE_CODE | NUMBER | Unique performance code for a gear type. | |
100
|
RBT_CODE | VARCHAR2 | Currently limted to Y (es) or N(o) | |
100
|
VESSEL_TYPE | NUMBER | Unique identifier of a vessel type | |
100
|
GEARTYPE_FORM | VARCHAR2 | Form that the gear is valid for. For example the gear may be Unknown for a delivery but will always be determined for a haul. | |
100
|
GEAR_TYPE_CODE | NUMBER | Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record | |
100
|
RST_CODE | VARCHAR2 | Random Sample Reference Table. Y = Yes - The haul is an ON haul, N = No - The haul is NOT an ON haul, x = RST Table not Used - Sampling All Hauls | |
100
|
DETERRENCE_CODE | VARCHAR2 | Deterrence code from NORPAC bird or mammal deterance tables | |
100
|
DETERRENCE_ANIMAL_TYPE | VARCHAR2 | Optional FK from LOV_Deterrence. Class of animal mammal (M), bird (B) for which the deterrence (if it exists) was utilized | |
100
|
LOCATION_CODE | VARCHAR2 | Identifies whether the information in a haul is based on retrieval or delivery (as in a mother ship) | |
100
|
RETRV_DATE_TIME | DATE | Date and time recorded by the observer from the vessel log. | |
100
|
RETRV_LATITUDE_DEGREES | NUMBER | Location of gear retrieval. | |
100
|
RETRV_LATITUDE_MINUTES | NUMBER | Location of gear retrieval. | |
100
|
RETRV_LATITUDE_SECONDS | NUMBER | Location of gear retrieval. | |
100
|
RETRV_EW | VARCHAR2 | Location of gear retrieval. | |
100
|
RETRV_LONGITUDE_DEGREES | NUMBER | Location of gear retrieval. | |
100
|
RETRV_LONGITUDE_MINUTES | NUMBER | Location of gear retrieval. | |
100
|
RETRV_LONGITUDE_SECONDS | NUMBER | Location of gear retrieval. | |
100
|
DEPLOY_DATE_TIME | DATE | Date and time recorded by the observer from the vessel log. | |
100
|
DEPLOY_LATITUDE_DEGREES | NUMBER | Location of gear deployment. | |
100
|
DEPLOY_LATITUDE_MINUTES | NUMBER | Location of gear deployment. | |
100
|
DEPLOY_LATITUDE_SECONDS | NUMBER | Location of gear deployment. | |
100
|
DEPLOY_EW | VARCHAR2 | Location of gear deployment. | |
100
|
DEPLOY_LONGITUDE_DEGREES | NUMBER | Location of gear deployment. | |
100
|
DEPLOY_LONGITUDE_MINUTES | NUMBER | Location of gear deployment. | |
100
|
DEPLOY_LONGITUDE_SECONDS | NUMBER | Location of gear deployment. | |
100
|
BOTTOM_DEPTH | NUMBER | Average bottom depth recorded by the observer from the vessel log. | |
100
|
FISHING_DEPTH | NUMBER | Average fishing depth recorded by the observer from the vessel log. | |
100
|
DEPTH_METER_FATHOM | VARCHAR2 | Identifies whether depth is recorded in meters or fathoms. | |
100
|
VESSEL_EST_CATCH | NUMBER | Total catch weight in metric tons as recorded in the vessel log. | |
100
|
OBSVR_EST_CATCH | NUMBER | Total catch weight as estimated by the observer in metric tons. | |
100
|
OBSVR_EST_METHOD | VARCHAR2 | Method used to determine the observer estimated catch | |
100
|
OBSVR_EST_DISCARDS | NUMBER | Observer estimate of total discards | |
100
|
DENSITY | NUMBER | Density used by the observer to determine the total catch weights. | |
100
|
INDIV_FISHING_QUOTA_FLAG | VARCHAR2 | Identifies whether fishing is on an IFQ quota with the subsequent application of IFQ rules. | |
100
|
SAMPLED_BY | NUMBER | Identifies where a haul is sampled by an observer and in some cases by which observer. | |
100
|
NUMBER_OF_SKATES | NUMBER | Number of skates for longline fishing. | |
100
|
NUMBER_OF_HOOKS_PER_SKATE | NUMBER | Number of hooks per skate for longline fishing. | |
100
|
TOTAL_HOOKS | NUMBER | Total number of hooks deployed for this haul | |
100
|
TOTAL_POTS | NUMBER | Total number of pots deployed for this haul. | |
100
|
MMAMMAL_MONITR_PCT | NUMBER | Percentage of time for this haul where marine mammal monitoring occured. For fixed gear deployments the valid values are anywhere in the range. For mobile gear deployments the values may be either 0 or 100. |
Attribute Details
HAUL_SEQ
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated unique identifier for a haul record |
General Data Type: | NUMBER |
HAUL_NUMBER
Seq. Order: | 2 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Number which is entered by the observer identifying a unique haul within a trip. Since records are not physically deleted, trigger code preserves uniqueness by allowing only a single active record to exist (delete_marker IS NOT NULL). |
General Data Type: | NUMBER |
HAUL_PURPOSE_CODE
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Haul data may be utilized for catch accounting, stock assessment, or for various special projects. This field is entered by the observer and not validated by ATLAS. Validation is performed when loaded into the production NORPAC data set. |
General Data Type: | VARCHAR2 |
CDQ_CODE
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique AlphaNumeric code representing a CDQ or research group |
General Data Type: | VARCHAR2 |
Foreign Key Relations: |
TURNBULLD.LOV_CDQ |
TRIP_SEQ
Seq. Order: | 5 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated unique identifier of a trip |
General Data Type: | NUMBER |
Foreign Key Relations: |
TURNBULLD.FMA_TRIP |
DELIVERY_VESSEL_ADFG
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
ADFG number entered by the observer if the delivering vessel does not exist in the vessel lookup table. |
General Data Type: | VARCHAR2 |
GEAR_PERFORMANCE_CODE
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Unique performance code for a gear type. |
General Data Type: | NUMBER |
Foreign Key Relations: |
TURNBULLD.LOV_GEAR_PERFORMANCE |
RBT_CODE
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Currently limted to Y (es) or N(o) |
General Data Type: | VARCHAR2 |
Foreign Key Relations: |
TURNBULLD.LOV_RBT_CODE |
VESSEL_TYPE
Seq. Order: | 9 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Unique identifier of a vessel type |
General Data Type: | NUMBER |
Foreign Key Relations: |
TURNBULLD.LOV_VESSEL_TYPE |
GEARTYPE_FORM
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Form that the gear is valid for. For example the gear may be Unknown for a delivery but will always be determined for a haul. |
General Data Type: | VARCHAR2 |
Foreign Key Relations: |
TURNBULLD.LOV_GEAR_TYPE |
GEAR_TYPE_CODE
Seq. Order: | 11 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record |
General Data Type: | NUMBER |
Foreign Key Relations: |
TURNBULLD.LOV_GEAR_TYPE |
RST_CODE
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Random Sample Reference Table. Y = Yes - The haul is an ON haul, N = No - The haul is NOT an ON haul, x = RST Table not Used - Sampling All Hauls |
General Data Type: | VARCHAR2 |
Foreign Key Relations: |
TURNBULLD.LOV_RST_CODE |
DETERRENCE_CODE
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Deterrence code from NORPAC bird or mammal deterance tables |
General Data Type: | VARCHAR2 |
Foreign Key Relations: |
TURNBULLD.LOV_DETERRENCE |
DETERRENCE_ANIMAL_TYPE
Seq. Order: | 14 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Optional FK from LOV_Deterrence. Class of animal mammal (M), bird (B) for which the deterrence (if it exists) was utilized |
General Data Type: | VARCHAR2 |
Foreign Key Relations: |
TURNBULLD.LOV_DETERRENCE |
LOCATION_CODE
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Identifies whether the information in a haul is based on retrieval or delivery (as in a mother ship) |
General Data Type: | VARCHAR2 |
RETRV_DATE_TIME
Seq. Order: | 16 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Date and time recorded by the observer from the vessel log. |
General Data Type: | DATE |
RETRV_LATITUDE_DEGREES
Seq. Order: | 17 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Location of gear retrieval. |
General Data Type: | NUMBER |
RETRV_LATITUDE_MINUTES
Seq. Order: | 18 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Location of gear retrieval. |
General Data Type: | NUMBER |
RETRV_LATITUDE_SECONDS
Seq. Order: | 19 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Location of gear retrieval. |
General Data Type: | NUMBER |
RETRV_EW
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Location of gear retrieval. |
General Data Type: | VARCHAR2 |
RETRV_LONGITUDE_DEGREES
Seq. Order: | 21 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Location of gear retrieval. |
General Data Type: | NUMBER |
RETRV_LONGITUDE_MINUTES
Seq. Order: | 22 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Location of gear retrieval. |
General Data Type: | NUMBER |
RETRV_LONGITUDE_SECONDS
Seq. Order: | 23 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Location of gear retrieval. |
General Data Type: | NUMBER |
DEPLOY_DATE_TIME
Seq. Order: | 24 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Date and time recorded by the observer from the vessel log. |
General Data Type: | DATE |
DEPLOY_LATITUDE_DEGREES
Seq. Order: | 25 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Location of gear deployment. |
General Data Type: | NUMBER |
DEPLOY_LATITUDE_MINUTES
Seq. Order: | 26 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Location of gear deployment. |
General Data Type: | NUMBER |
DEPLOY_LATITUDE_SECONDS
Seq. Order: | 27 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Location of gear deployment. |
General Data Type: | NUMBER |
DEPLOY_EW
Seq. Order: | 28 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Location of gear deployment. |
General Data Type: | VARCHAR2 |
DEPLOY_LONGITUDE_DEGREES
Seq. Order: | 29 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Location of gear deployment. |
General Data Type: | NUMBER |
DEPLOY_LONGITUDE_MINUTES
Seq. Order: | 30 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Location of gear deployment. |
General Data Type: | NUMBER |
DEPLOY_LONGITUDE_SECONDS
Seq. Order: | 31 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Location of gear deployment. |
General Data Type: | NUMBER |
BOTTOM_DEPTH
Seq. Order: | 32 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Average bottom depth recorded by the observer from the vessel log. |
General Data Type: | NUMBER |
FISHING_DEPTH
Seq. Order: | 33 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Average fishing depth recorded by the observer from the vessel log. |
General Data Type: | NUMBER |
DEPTH_METER_FATHOM
Seq. Order: | 34 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Identifies whether depth is recorded in meters or fathoms. |
General Data Type: | VARCHAR2 |
VESSEL_EST_CATCH
Seq. Order: | 35 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 2 |
Status: | Active |
Description: |
Total catch weight in metric tons as recorded in the vessel log. |
General Data Type: | NUMBER |
OBSVR_EST_CATCH
Seq. Order: | 36 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 2 |
Status: | Active |
Description: |
Total catch weight as estimated by the observer in metric tons. |
General Data Type: | NUMBER |
OBSVR_EST_METHOD
Seq. Order: | 37 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Method used to determine the observer estimated catch |
General Data Type: | VARCHAR2 |
OBSVR_EST_DISCARDS
Seq. Order: | 38 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 2 |
Status: | Active |
Description: |
Observer estimate of total discards |
General Data Type: | NUMBER |
DENSITY
Seq. Order: | 39 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 2 |
Status: | Active |
Description: |
Density used by the observer to determine the total catch weights. |
General Data Type: | NUMBER |
INDIV_FISHING_QUOTA_FLAG
Seq. Order: | 40 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Identifies whether fishing is on an IFQ quota with the subsequent application of IFQ rules. |
General Data Type: | VARCHAR2 |
SAMPLED_BY
Seq. Order: | 41 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 8 |
Scale: | 0 |
Status: | Active |
Description: |
Identifies where a haul is sampled by an observer and in some cases by which observer. |
General Data Type: | NUMBER |
NUMBER_OF_SKATES
Seq. Order: | 42 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Number of skates for longline fishing. |
General Data Type: | NUMBER |
NUMBER_OF_HOOKS_PER_SKATE
Seq. Order: | 43 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Number of hooks per skate for longline fishing. |
General Data Type: | NUMBER |
TOTAL_HOOKS
Seq. Order: | 44 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Total number of hooks deployed for this haul |
General Data Type: | NUMBER |
TOTAL_POTS
Seq. Order: | 45 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Total number of pots deployed for this haul. |
General Data Type: | NUMBER |
MMAMMAL_MONITR_PCT
Seq. Order: | 46 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Percentage of time for this haul where marine mammal monitoring occured. For fixed gear deployments the valid values are anywhere in the range. For mobile gear deployments the values may be either 0 or 100. |
General Data Type: | NUMBER |
Catalog Details
Catalog Item ID: | 7510 |
---|---|
GUID: | gov.noaa.nmfs.inport:7510 |
Metadata Record Created By: | Doug Turnbull |
Metadata Record Created: | 2008-03-28 14:09+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2018-10-03 |
Owner Org: | AFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2018-10-03 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2019-10-03 |