Table: DEBRIEFED_HAUL

Identifier of Source Table

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

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

Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel.

Sequence generated unique identifier for a haul record

This is a uniquie identifier of a haul record composed by concatenation of cruise, permit and haul_seq. For domestic table records this is a sequence generated unique identifier for a haul.

Sequence generated unique identifier for a trip as defined in ATL_fma_trip.

Surrogate FK to haul, It is a unique identifier of a trip record created by concatenating cruise, permit, and trip_seq (TO_NUMBER ( t.cruise||LPAD (t.permit, 6,'0')||LPAD (t.trip_seq, 9, '0')) AS trip_join)

OBSINT.DEBRIEFED_TRIP

Date of haul retrieval.

Number which is entered by the observer identifying a unique haul within a trip.

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.

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

Unique performance code for a gear type. see ATL_LOV_gear_perfomrance.

Unique identifier of a vessel type, see ATL_LOV_vessel_type

Date and time of gear deployment

Gear deployment position.

Gear deployment position

The conversion of longitude is required of values to the east of the 180th meridian. The configuration within Oracle Spatial uses a 360 degree globe - 179 E must therefore be submitted as 181. The calling program must, as in the conversion to decimal degrees submit latitude to the east of the 180th meridian as a negative number.

Gear deployment position.

Gear deployment position.

Gear deployment position.

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

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

Date and time of gear retrieval.

Duration of a haul calculated in minutes.

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

Retrieval location.

Retrieval location.

Gear retrieval position.

Gear retrieval position.

Retrieval location. The conversion of longitude is required of values to the east of the 180th meridian. The configuration within Oracle Spatial uses a 360 degree globe - 179 E must therefore be submitted as 181. The calling program must, as in the conversion to decimal degrees submit latitude to the east of the 180th meridian as a negative number.

Retrieval location.

This attirbute is no longer collected, but is retained for the domestic data set.

This attribute is computed using the MDSYS.SDO_GEOMETRY package and an ESRI shape file.

This attribute is computed using the MDSYS.SDO_GEOMETRY package and an ESRI shape file.

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

Total catch weight as estimated by the observer in kgs and converted to MT for this presentation.

Total catch weight as estimated by the observer in kgs and converted to MT for this presentation.

Method used to determine the observer estimated catch.

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

If this haul was delivered to a mothership or catcher processor, this attibute records the adfg negistration number of that vessel.

Flag which identifies whether fishing is on an IFQ quota with the subsequent application of IFQ rules.

Unique AlphaNumeric code representing a CDQ or research group.

Number of skates for longline fishing.

Number of hooks per skate for longline fishing usually calculated as the average number of hooks per segment from the atl_haul_hook_count table.

Total number of hooks deployed for this haul, usually calculated as the average number of hooks per segment from the atl_haul_hook_count table * the number of skates in set. Or in the case of a pot fishery the total number of pots deployed in a haul.

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.

Random Sample Reference Table code reference.

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

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.

Deterrence code from NORPAC bird or mammal deterance tables.

This attirbute is no longer collected, but is retained from the domestic data set. See the atl_bird _module deployed in 2010 for complete observer seabird data.

Processor is computed by atl_utilities, and returns the shore plant processor code for catcher vessels who have an offload, and the processor permit for catcher processors and motherships.

Fishing start date is defined as the first haul deployment of a trip. If the deployment date is null due to unverifiable observer data then the trip start date is used; if null the default is a mandatory value haul retrieval date.

Date of entry is now (2010) recorded when a haul is loaded into the Norpac data set. In the case that that value is null then it is computed from the latest load date recorded in atl_record_status.';

Year is extracted from the haul rettrv_date_time field.

Latitude decimal degrees is computed from the retrieval latitude.

Longitude decimal degrees is computed from the retrieval longitude.

Latitude decimal degrees is computed from the deployment latitude.

Longitude decimal degrees is computed from the deployment longitude.

This attirbute is no longer collected, but is retained from the domestic data set. See the atl_bird _module deployed in 2010 for complete observer seabird data.

If this haul data was transmitted from the field. This attribute records the version of the software used.

Observer estimate of total discards in kgs.

Domestic Observer Data began to be collected in 1986 and is ongoing.