Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Special Projects > Alternative catch monitoring of Alaskan groundf... > AFSC/FMA/NPRB Alternative Catch Monitoring Tabl... >

Table: ATL_HAUL

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:18986  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Hauls are unique fishing events of gear deployment and retrieval and may also contain information unique to a day where no fishing occured.

Description

Hauls are unique fishing events of gear deployment and retrieval and may also contain information unique to a day where no fishing occured.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
CRUISE
NUMBER 		Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
HAUL_SEQ
NUMBER 		Sequence generated unique identifier for a haul record
HAUL_NUMBER
NUMBER 		Number which is entered by the observer identifying a unique haul within a trip.
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.
CDQ_CODE
VARCHAR2 		Unique AlphaNumeric code representing a CDQ or research group
DELIVERY_VESSEL_ADFG
VARCHAR2 		ADFG number entered by the observer if the delivering vessel does not exist in the vessel lookup table.
TRIP_SEQ
NUMBER 		Sequence generated unique identifier of a trip
VESSEL_TYPE
NUMBER 		Unique identifier of a vessel type
GEAR_PERFORMANCE_CODE
NUMBER 		Unique performance code for a gear type.
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.
GEAR_TYPE_CODE
NUMBER 		Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record
RBT_CODE
VARCHAR2 		Random Break Table identifier Currently limted to Y (es) or N(o)
RST_CODE
VARCHAR2 		Random Sample Reference Table code reference.
DETERRENCE_CODE
VARCHAR2 		Deterrence code from NORPAC bird or mammal deterance tables
ANIMAL_TYPE_CODE
VARCHAR2 		Optional FK from LOV_Deterrence. Class of animal mammal (M), bird (B) for which the deterrence (if it exists) was utilized
LOCATION_CODE
VARCHAR2 		Identifies whether the information in a haul is based on retrieval or delivery (as in a mother ship)
RETRV_DATE_TIME
DATE 		Date recorded by the observer from the vessel log.
RETRV_LATITUDE_DEGREES
NUMBER 		Location of gear retrieval.
RETRV_LATITUDE_MINUTES
NUMBER 		Location of gear retrieval.
RETRV_LATITUDE_SECONDS
NUMBER 		Location of gear retrieval.
RETRV_EW
VARCHAR2 		Location of gear retrieval.
RETRV_LONGITUDE_DEGREES
NUMBER 		Location of gear retrieval.
RETRV_LONGITUDE_MINUTES
NUMBER 		Location of gear retrieval.
RETRV_LONGITUDE_SECONDS
NUMBER 		Location of gear retrieval.
NMFS_AREA
NUMBER 		This is a calculated value from retrieval lat-long. It is stored for the convenience of the user community.
DEPLOY_DATE_TIME
DATE 		Date and time recorded by the observer from the vessel log.
DEPLOY_LATITUDE_DEGREES
NUMBER 		Location of gear deployment.
DEPLOY_LATITUDE_MINUTES
NUMBER 		Location of gear deployment.
DEPLOY_LATITUDE_SECONDS
NUMBER 		Location of gear deployment.
DEPLOY_EW
VARCHAR2 		Location of gear deployment.
DEPLOY_LONGITUDE_DEGREES
NUMBER 		Location of gear deployment.
DEPLOY_LONGITUDE_MINUTES
NUMBER 		Location of gear deployment.
DEPLOY_LONGITUDE_SECONDS
NUMBER 		Location of gear deployment.
BOTTOM_DEPTH
NUMBER 		Average bottom depth recorded by the observer from the vessel log.
FISHING_DEPTH
NUMBER 		Average fishing depth recorded by the observer from the vessel log.
DEPTH_METER_FATHOM
VARCHAR2 		Identifies whether depth is recorded in meters or fathoms.
VESSEL_EST_CATCH
NUMBER 		Total catch weight in metric tons as recorded in the vessel log.
OBSVR_EST_CATCH
NUMBER 		Total catch weight as estimated by the observer in kgs.
OBSVR_EST_METHOD
VARCHAR2 		Method used to determine the observer estimated catch
OBSVR_EST_DISCARDS
NUMBER 		Observer estimate of total discards in kgs.
DENSITY
NUMBER 		Density used by the observer to determine the total catch weights. Recorded in kgs per m3.
INDIV_FISHING_QUOTA_FLAG
VARCHAR2 		Identifies whether fishing is on an IFQ quota with the subsequent application of IFQ rules.
SAMPLED_BY
NUMBER 		Identifies where a haul is sampled by an observer and in some cases by which observer. The observer of a haul is not necessarily the primary observer recorded for a cruise.
NUMBER_OF_SKATES
NUMBER 		Number of skates for longline fishing.
NUMBER_OF_HOOKS_PER_SKATE
NUMBER 		Number of hooks per skate for longline fishing.
TOTAL_HOOKS
NUMBER 		Total number of hooks deployed for this haul
TOTAL_POTS
NUMBER 		Total number of pots deployed for this haul.
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.
PERMIT
VARCHAR2 		Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
VOLUME
NUMBER 		Estimate of volume of catch
DATE_OF_ENTRY
DATE 		When a haul record is inserted or updated the system date is recorded here. This value is not used for catch or quota purposes, but is useful for identifying errors or ommissions at the haul level by both the Alaska Region and Inseason Advising.
SAMPLE_SYSTEM_CODE
NUMBER 		Unique numeric identifier of a sample coding system.
SAMPLE_UNIT_CODE
NUMBER 		Unique code identifying the unit of measure for a sampling design. Sample Design and units are mandatory at the haul level and optional at the sample level.
TOTAL_HOOKS_OVERIDE_FLAG
VARCHAR2 		If an observer believes that the calculated value of total hooks is not correct. It is allowed that the value is overridden. If that is the case then this flag will be set to Y by trigger code, and total-hooks will be protected from automatic recalculateion.
BIRD_HAULBACK_CODE
VARCHAR2 		Portion of the haulback that was monitored by the observer for bird interactions.
BIRD_SHORTWIRED_FLAG
VARCHAR2 		Denoting whether the net was shortwired during the haulback. Do not record a Y when the net is shortwired during the tow but then returned to fishing depth. The purpose of this flag differs from the gear performance code in that interactions between birds and the warps or third wire transducer cable may occur during periods where the cod end is being towed while fish on deck are possessed or in other instances outside of shortwiring for turns or known obstacles.
UNITS
VARCHAR2 		no-comment
POPULATION_SIZE
NUMBER 		no-comment
UNIT_SIZE
NUMBER 		no-comment
NUMBER_OF_UNITS_SAMPLED
NUMBER 		no-comment
UNITS_IN_POPULATION
NUMBER 		no-comment

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

Item Identification

Title: Table: ATL_HAUL
Short Name: ATL_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 4574, 05-03-2013 17:18

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NPRB_1017
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 CRUISE NUMBER Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
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.
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
 DELIVERY_VESSEL_ADFG VARCHAR2 ADFG number entered by the observer if the delivering vessel does not exist in the vessel lookup table.
100
 TRIP_SEQ NUMBER Sequence generated unique identifier of a trip
100
 VESSEL_TYPE NUMBER Unique identifier of a vessel type
100
 GEAR_PERFORMANCE_CODE NUMBER Unique performance code for a gear 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
 RBT_CODE VARCHAR2 Random Break Table identifier Currently limted to Y (es) or N(o)
100
 RST_CODE VARCHAR2 Random Sample Reference Table code reference.
100
 DETERRENCE_CODE VARCHAR2 Deterrence code from NORPAC bird or mammal deterance tables
100
 ANIMAL_TYPE_CODE 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 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
 NMFS_AREA NUMBER This is a calculated value from retrieval lat-long. It is stored for the convenience of the user community.
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 kgs.
100
 OBSVR_EST_METHOD VARCHAR2 Method used to determine the observer estimated catch
100
 OBSVR_EST_DISCARDS NUMBER Observer estimate of total discards in kgs.
100
 DENSITY NUMBER Density used by the observer to determine the total catch weights. Recorded in kgs per m3.
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. The observer of a haul is not necessarily the primary observer recorded for a cruise.
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.
100
 Primary Key PERMIT VARCHAR2 Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
100
 VOLUME NUMBER Estimate of volume of catch
100
 DATE_OF_ENTRY DATE When a haul record is inserted or updated the system date is recorded here. This value is not used for catch or quota purposes, but is useful for identifying errors or ommissions at the haul level by both the Alaska Region and Inseason Advising.
100
 SAMPLE_SYSTEM_CODE NUMBER Unique numeric identifier of a sample coding system.
100
 SAMPLE_UNIT_CODE NUMBER Unique code identifying the unit of measure for a sampling design. Sample Design and units are mandatory at the haul level and optional at the sample level.
100
 TOTAL_HOOKS_OVERIDE_FLAG VARCHAR2 If an observer believes that the calculated value of total hooks is not correct. It is allowed that the value is overridden. If that is the case then this flag will be set to Y by trigger code, and total-hooks will be protected from automatic recalculateion.
100
 BIRD_HAULBACK_CODE VARCHAR2 Portion of the haulback that was monitored by the observer for bird interactions.
100
 BIRD_SHORTWIRED_FLAG VARCHAR2 Denoting whether the net was shortwired during the haulback. Do not record a Y when the net is shortwired during the tow but then returned to fishing depth. The purpose of this flag differs from the gear performance code in that interactions between birds and the warps or third wire transducer cable may occur during periods where the cod end is being towed while fish on deck are possessed or in other instances outside of shortwiring for turns or known obstacles.
100
 UNITS VARCHAR2 no-comment
100
 POPULATION_SIZE NUMBER no-comment
100
 UNIT_SIZE NUMBER no-comment
100
 NUMBER_OF_UNITS_SAMPLED NUMBER no-comment
100
 UNITS_IN_POPULATION NUMBER no-comment

Attribute Details

CRUISE

CC ID: 111920
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 9
Scale: 0
Status: Active
Description:

Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
General Data Type: NUMBER
Foreign Key Relations:

NPRB_1017.ATL_FMA_TRIP

HAUL_SEQ

CC ID: 111940
Seq. Order: 2
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: 111951
Seq. Order: 3
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.
General Data Type: NUMBER

HAUL_PURPOSE_CODE

CC ID: 111930
Seq. Order: 4
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
Foreign Key Relations:

NPRB_1017.ATL_LOV_HAUL_PURPOSE

CDQ_CODE

CC ID: 111924
Seq. Order: 5
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:

NPRB_1017.ATL_LOV_CDQ

DELIVERY_VESSEL_ADFG

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

TRIP_SEQ

CC ID: 111922
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Sequence generated unique identifier of a trip
General Data Type: NUMBER
Foreign Key Relations:

NPRB_1017.ATL_FMA_TRIP

VESSEL_TYPE

CC ID: 111935
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Status: Active
Description:

Unique identifier of a vessel type
General Data Type: NUMBER
Foreign Key Relations:

NPRB_1017.ATL_LOV_VESSEL_TYPE

GEAR_PERFORMANCE_CODE

CC ID: 111927
Seq. Order: 9
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:

NPRB_1017.ATL_LOV_GEAR_PERFORM

GEARTYPE_FORM

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

NPRB_1017.ATL_LOV_GEAR_TYPE

GEAR_TYPE_CODE

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

NPRB_1017.ATL_LOV_GEAR_TYPE

RBT_CODE

CC ID: 111931
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Random Break Table identifier Currently limted to Y (es) or N(o)
General Data Type: VARCHAR2
Foreign Key Relations:

NPRB_1017.ATL_LOV_RBT_CODE

RST_CODE

CC ID: 111932
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Random Sample Reference Table code reference.
General Data Type: VARCHAR2
Foreign Key Relations:

NPRB_1017.ATL_LOV_RST_CODE

DETERRENCE_CODE

CC ID: 111925
Seq. Order: 14
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:

NPRB_1017.ATL_LOV_DETERRENCE

ANIMAL_TYPE_CODE

CC ID: 111926
Seq. Order: 15
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:

NPRB_1017.ATL_LOV_DETERRENCE

LOCATION_CODE

CC ID: 111936
Seq. Order: 16
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: 111937
Seq. Order: 17
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Date recorded by the observer from the vessel log.
General Data Type: DATE

RETRV_LATITUDE_DEGREES

CC ID: 111938
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_MINUTES

CC ID: 111939
Seq. Order: 19
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: 111941
Seq. Order: 20
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: 111942
Seq. Order: 21
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: 111943
Seq. Order: 22
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Location of gear retrieval.
General Data Type: NUMBER

RETRV_LONGITUDE_MINUTES

CC ID: 111944
Seq. Order: 23
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: 111945
Seq. Order: 24
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

NMFS_AREA

CC ID: 111946
Seq. Order: 25
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

This is a calculated value from retrieval lat-long. It is stored for the convenience of the user community.
General Data Type: NUMBER

DEPLOY_DATE_TIME

CC ID: 111947
Seq. Order: 26
Data Storage Type: DATE
Max Length: 7
Required: No
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: 111948
Seq. Order: 27
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Location of gear deployment.
General Data Type: NUMBER

DEPLOY_LATITUDE_MINUTES

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

CC ID: 111950
Seq. Order: 29
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: 111952
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Location of gear deployment.
General Data Type: VARCHAR2

DEPLOY_LONGITUDE_DEGREES

CC ID: 111953
Seq. Order: 31
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Location of gear deployment.
General Data Type: NUMBER

DEPLOY_LONGITUDE_MINUTES

CC ID: 111954
Seq. Order: 32
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_LONGITUDE_SECONDS

CC ID: 111955
Seq. Order: 33
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: 111956
Seq. Order: 34
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: 111957
Seq. Order: 35
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: 111958
Seq. Order: 36
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: 111959
Seq. Order: 37
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
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: 111960
Seq. Order: 38
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 2
Status: Active
Description:

Total catch weight as estimated by the observer in kgs.
General Data Type: NUMBER

OBSVR_EST_METHOD

CC ID: 111961
Seq. Order: 39
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: 111962
Seq. Order: 40
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 2
Status: Active
Description:

Observer estimate of total discards in kgs.
General Data Type: NUMBER

DENSITY

CC ID: 111963
Seq. Order: 41
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Density used by the observer to determine the total catch weights. Recorded in kgs per m3.
General Data Type: NUMBER

INDIV_FISHING_QUOTA_FLAG

CC ID: 111964
Seq. Order: 42
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: 111965
Seq. Order: 43
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Identifies where a haul is sampled by an observer and in some cases by which observer. The observer of a haul is not necessarily the primary observer recorded for a cruise.
General Data Type: NUMBER

NUMBER_OF_SKATES

CC ID: 111966
Seq. Order: 44
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 7
Scale: 2
Status: Active
Description:

Number of skates for longline fishing.
General Data Type: NUMBER

NUMBER_OF_HOOKS_PER_SKATE

CC ID: 111967
Seq. Order: 45
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: 111968
Seq. Order: 46
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: 111969
Seq. Order: 47
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: 111970
Seq. Order: 48
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

PERMIT

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

Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
General Data Type: VARCHAR2
Foreign Key Relations:

NPRB_1017.ATL_FMA_TRIP

VOLUME

CC ID: 111971
Seq. Order: 50
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 2
Status: Active
Description:

Estimate of volume of catch
General Data Type: NUMBER

DATE_OF_ENTRY

CC ID: 111972
Seq. Order: 51
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

When a haul record is inserted or updated the system date is recorded here. This value is not used for catch or quota purposes, but is useful for identifying errors or ommissions at the haul level by both the Alaska Region and Inseason Advising.
General Data Type: DATE

SAMPLE_SYSTEM_CODE

CC ID: 111933
Seq. Order: 52
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Unique numeric identifier of a sample coding system.
General Data Type: NUMBER
Foreign Key Relations:

NPRB_1017.ATL_LOV_SAMPLE_SYSTE

SAMPLE_UNIT_CODE

CC ID: 111934
Seq. Order: 53
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Unique code identifying the unit of measure for a sampling design. Sample Design and units are mandatory at the haul level and optional at the sample level.
General Data Type: NUMBER
Foreign Key Relations:

NPRB_1017.ATL_LOV_SAMPLE_UNIT

TOTAL_HOOKS_OVERIDE_FLAG

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

If an observer believes that the calculated value of total hooks is not correct. It is allowed that the value is overridden. If that is the case then this flag will be set to Y by trigger code, and total-hooks will be protected from automatic recalculateion.
General Data Type: VARCHAR2

BIRD_HAULBACK_CODE

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

Portion of the haulback that was monitored by the observer for bird interactions.
General Data Type: VARCHAR2
Foreign Key Relations:

NPRB_1017.ATL_LOV_BIRD_HAULBAC

BIRD_SHORTWIRED_FLAG

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

Denoting whether the net was shortwired during the haulback. Do not record a Y when the net is shortwired during the tow but then returned to fishing depth. The purpose of this flag differs from the gear performance code in that interactions between birds and the warps or third wire transducer cable may occur during periods where the cod end is being towed while fish on deck are possessed or in other instances outside of shortwiring for turns or known obstacles.
General Data Type: VARCHAR2

UNITS

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

no-comment
General Data Type: VARCHAR2

POPULATION_SIZE

CC ID: 111976
Seq. Order: 58
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 16
Scale: 6
Status: Active
Description:

no-comment
General Data Type: NUMBER

UNIT_SIZE

CC ID: 111977
Seq. Order: 59
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 16
Scale: 6
Status: Active
Description:

no-comment
General Data Type: NUMBER

NUMBER_OF_UNITS_SAMPLED

CC ID: 111979
Seq. Order: 60
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 6
Status: Active
Description:

no-comment
General Data Type: NUMBER

UNITS_IN_POPULATION

CC ID: 111980
Seq. Order: 61
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 6
Status: Active
Description:

no-comment
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 18986
GUID: gov.noaa.nmfs.inport:18986
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2013-05-03 17:18+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-18
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-18
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-18