Slide Menu
Search Help Show/Hide Menu

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

Rubric Score Primary Key? Name Type Description
100
Primary Key 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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