Search Help Show/Hide Menu
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 occurred.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
SEQ_NUMBER
NUMBER
Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, icrement by 1 and do not cycle.
CHANGED_BY
VARCHAR2
Oracle user who made a change to the transaction table record.
DATE_CHANGED
DATE
Timestamp of change to transaction record.
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. Since records are not physically deleted, trigger code preserves uniqueness by allowing only a single active record to exist (delete_marker IS NOT NULL).
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
TRIP_SEQ
NUMBER
Sequence generated unique identifier of a trip.
DELIVERY_VESSEL_ADFG
VARCHAR2
ADFG number entered by the observer if the delivering vessel does not exist in the vessel lookup table.
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_EW
VARCHAR2
Location of gear retrieval.
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_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. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water.
DEPLOY_EW
VARCHAR2
Location of gear deployment.Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water.
DEPLOY_LATITUDE_DEGREES
NUMBER
Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water.
DEPLOY_LATITUDE_MINUTES
NUMBER
Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water.
DEPLOY_LATITUDE_SECONDS
NUMBER
Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water.
DEPLOY_LONGITUDE_DEGREES
NUMBER
Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water.
DEPLOY_LONGITUDE_MINUTES
NUMBER
Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water.
DEPLOY_LONGITUDE_SECONDS
NUMBER
Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water.
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_DISCARDS
NUMBER
Observer estimate of total discards in kgs.
OBSVR_EST_METHOD
VARCHAR2
Method used to determine the observer estimated catch.
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
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 recalculation.
BIRD_MONITOR_LEVEL_CODE
VARCHAR2
Portion of the haulback that was monitored by the observer for bird interactions.
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.
SAMPLE_UNIT_CODE
VARCHAR2
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.
SAMPLE_SYSTEM_CODE
NUMBER
Unique numeric identifier of a sample coding system.

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_H
Short Name: ATL_HAUL_H
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.

Purpose:

Histories of all changes to data are maintained by trigger code on the parent table; allowing change control by user and datetime for all updates and delete events.

Notes:

Loaded by batch 2390, 06-30-2009 16:11

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NORPAC
Description:

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

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key SEQ_NUMBER NUMBER Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, icrement by 1 and do not cycle.
100
CHANGED_BY VARCHAR2 Oracle user who made a change to the transaction table record.
100
DATE_CHANGED DATE Timestamp of change to transaction record.
100
CRUISE NUMBER Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
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
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_EW VARCHAR2 Location of gear retrieval.
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_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. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water.
100
DEPLOY_EW VARCHAR2 Location of gear deployment.Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water.
100
DEPLOY_LATITUDE_DEGREES NUMBER Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water.
100
DEPLOY_LATITUDE_MINUTES NUMBER Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water.
100
DEPLOY_LATITUDE_SECONDS NUMBER Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water.
100
DEPLOY_LONGITUDE_DEGREES NUMBER Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water.
100
DEPLOY_LONGITUDE_MINUTES NUMBER Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water.
100
DEPLOY_LONGITUDE_SECONDS NUMBER Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water.
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_DISCARDS NUMBER Observer estimate of total discards in kgs.
100
OBSVR_EST_METHOD VARCHAR2 Method used to determine the observer estimated catch.
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
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
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 recalculation.
100
BIRD_MONITOR_LEVEL_CODE VARCHAR2 Portion of the haulback that was monitored by the observer for bird interactions.
100
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.
100
SAMPLE_UNIT_CODE VARCHAR2 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
SAMPLE_SYSTEM_CODE NUMBER Unique numeric identifier of a sample coding system.

Attribute Details

SEQ_NUMBER

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

Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, icrement by 1 and do not cycle.

General Data Type: NUMBER

CHANGED_BY

CC ID: 38396
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Oracle user who made a change to the transaction table record.

General Data Type: VARCHAR2

DATE_CHANGED

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

Timestamp of change to transaction record.

General Data Type: DATE

CRUISE

CC ID: 38397
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 22
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

HAUL_SEQ

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

Sequence generated unique identifier for a haul record.

General Data Type: NUMBER

HAUL_NUMBER

CC ID: 38415
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 22
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: 38416
Seq. Order: 7
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: 38395
Seq. Order: 8
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

TRIP_SEQ

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

Sequence generated unique identifier of a trip.

General Data Type: NUMBER

DELIVERY_VESSEL_ADFG

CC ID: 38399
Seq. Order: 10
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

VESSEL_TYPE

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

Unique identifier of a vessel type.

General Data Type: NUMBER

GEAR_PERFORMANCE_CODE

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

Unique performance code for a gear type.

General Data Type: NUMBER

GEARTYPE_FORM

CC ID: 38412
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
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

GEAR_TYPE_CODE

CC ID: 38414
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 22
Scale: 0
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

RBT_CODE

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

RST_CODE

CC ID: 38437
Seq. Order: 16
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

DETERRENCE_CODE

CC ID: 38410
Seq. Order: 17
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

ANIMAL_TYPE_CODE

CC ID: 38392
Seq. Order: 18
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

LOCATION_CODE

CC ID: 38419
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
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: 38429
Seq. Order: 20
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date recorded by the observer from the vessel log.

General Data Type: DATE

RETRV_EW

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

Location of gear retrieval.

General Data Type: VARCHAR2

RETRV_LATITUDE_DEGREES

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

Location of gear retrieval.

General Data Type: NUMBER

RETRV_LATITUDE_MINUTES

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

Location of gear retrieval.

General Data Type: NUMBER

RETRV_LATITUDE_SECONDS

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

Location of gear retrieval.

General Data Type: NUMBER

RETRV_LONGITUDE_DEGREES

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

Location of gear retrieval.

General Data Type: NUMBER

RETRV_LONGITUDE_MINUTES

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

Location of gear retrieval.

General Data Type: NUMBER

RETRV_LONGITUDE_SECONDS

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

Location of gear retrieval.

General Data Type: NUMBER

NMFS_AREA

CC ID: 38421
Seq. Order: 28
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 22
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: 38401
Seq. Order: 29
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. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water.

General Data Type: DATE

DEPLOY_EW

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

Location of gear deployment.Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water.

General Data Type: VARCHAR2

DEPLOY_LATITUDE_DEGREES

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

Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water.

General Data Type: NUMBER

DEPLOY_LATITUDE_MINUTES

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

Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water.

General Data Type: NUMBER

DEPLOY_LATITUDE_SECONDS

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

Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water.

General Data Type: NUMBER

DEPLOY_LONGITUDE_DEGREES

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

Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water.

General Data Type: NUMBER

DEPLOY_LONGITUDE_MINUTES

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

Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water.

General Data Type: NUMBER

DEPLOY_LONGITUDE_SECONDS

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

Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water.

General Data Type: NUMBER

BOTTOM_DEPTH

CC ID: 38394
Seq. Order: 37
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: 38411
Seq. Order: 38
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: 38409
Seq. Order: 39
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: 38447
Seq. Order: 40
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: 38424
Seq. Order: 41
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 kgs.

General Data Type: NUMBER

OBSVR_EST_DISCARDS

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

Observer estimate of total discards in kgs.

General Data Type: NUMBER

OBSVR_EST_METHOD

CC ID: 38426
Seq. Order: 43
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

DENSITY

CC ID: 38400
Seq. Order: 44
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. Recorded in kgs per m3.

General Data Type: NUMBER

INDIV_FISHING_QUOTA_FLAG

CC ID: 38418
Seq. Order: 45
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
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: 38438
Seq. Order: 46
Data Storage Type: NUMBER
Max Length: 22
Required: No
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. The observer of a haul is not necessarily the primary observer recorded for a cruise.

General Data Type: NUMBER

NUMBER_OF_SKATES

CC ID: 38423
Seq. Order: 47
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: 38422
Seq. Order: 48
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: 38443
Seq. Order: 49
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: 38445
Seq. Order: 50
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Total number of pots deployed for this haul.

General Data Type: NUMBER

MMAMMAL_MONITR_PCT

CC ID: 38420
Seq. Order: 51
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: 38427
Seq. Order: 52
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
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

VOLUME

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

Estimate of volume of catch

General Data Type: NUMBER

TOTAL_HOOKS_OVERIDE_FLAG

CC ID: 38444
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 recalculation.

General Data Type: VARCHAR2

BIRD_MONITOR_LEVEL_CODE

CC ID: 38393
Seq. Order: 55
Data Storage Type: VARCHAR2
Max Length: 4
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

SHORTWIRED_FLAG

CC ID: 38442
Seq. Order: 56
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
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.

General Data Type: VARCHAR2

SAMPLE_UNIT_CODE

CC ID: 38440
Seq. Order: 57
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
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: VARCHAR2

SAMPLE_SYSTEM_CODE

CC ID: 38439
Seq. Order: 58
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

Catalog Details

Catalog Item ID: 9676
GUID: gov.noaa.nmfs.inport:9676
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2009-06-30 16:11+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-09-26
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-09-26
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-09-26