Table: ATL_HAUL_H

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.

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

Timestamp of change to transaction record.

Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.

Sequence generated unique identifier for a haul record.

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 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.

Unique AlphaNumeric code representing a CDQ or research group

Sequence generated unique identifier of a trip.

ADFG number entered by the observer if the delivering vessel does not exist in the vessel lookup table.

Unique identifier of a vessel type.

Unique performance code for a gear type.

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.

Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record

Random Break Table identifier Currently limted to Y (es) or N(o)

Random Sample Reference Table code reference.

Deterrence code from NORPAC bird or mammal deterance tables.

Optional FK from LOV_Deterrence. Class of animal mammal (M), bird (B) for which the deterrence (if it exists) was utilized.

Identifies whether the information in a haul is based on retrieval or delivery (as in a mother ship).

Date recorded by the observer from the vessel log.

Location of gear retrieval.

Location of gear retrieval.

Location of gear retrieval.

Location of gear retrieval.

Location of gear retrieval.

Location of gear retrieval.

Location of gear retrieval.

This is a calculated value from retrieval lat-long. It is stored for the convenience of the user community.

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.

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.

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.

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.

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.

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.

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.

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.

Average bottom depth recorded by the observer from the vessel log.

Average fishing depth recorded by the observer from the vessel log.

Identifies whether depth is recorded in meters or fathoms.

Total catch weight in metric tons as recorded in the vessel log.

Total catch weight as estimated by the observer in kgs.

Observer estimate of total discards in kgs.

Method used to determine the observer estimated catch.

Density used by the observer to determine the total catch weights. Recorded in kgs per m3.

Identifies whether fishing is on an IFQ quota with the subsequent application of IFQ rules.

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 for longline fishing.

Number of hooks per skate for longline fishing.

Total number of hooks deployed for this haul

Total number of pots deployed for this haul.

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.

Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau

Estimate of volume of catch

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.

Portion of the haulback that was monitored by the observer for bird interactions.

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.

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.

Unique numeric identifier of a sample coding system.