9619 ATLW_HAUL Entity Published / External 7284 AFSC/FMA/North Pacific Groundfish and Halibut Observer Program, Post 2008 Fishery Statistics. Data Set Completed Hauls are unique fishing events of gear deployment and retrieval and may also contain information unique to a day where no fishing occured. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC Hauls are unique fishing events of gear deployment and retrieval and may also contain information unique to a day where no fishing occured. 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 HAUL_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for a haul record NUMBER 4 HAUL_NUMBER NUMBER 22 Yes No 6 0 Active 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). NUMBER 5 HAUL_PURPOSE_CODE VARCHAR2 3 Yes No Active 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. VARCHAR2 6 CDQ_CODE VARCHAR2 3 No No Active Unique AlphaNumeric code representing a CDQ or research group VARCHAR2 7 TRIP_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier of a trip NUMBER 8 DELIVERY_VESSEL_ADFG VARCHAR2 6 No No Active ADFG number entered by the observer if the delivering vessel does not exist in the vessel lookup table. VARCHAR2 9 GEAR_PERFORMANCE_CODE NUMBER 22 Yes No 38 Active Unique performance code for a gear type. NUMBER 10 RBT_CODE VARCHAR2 1 Yes No Active Currently limted to Y (es) or N(o) VARCHAR2 11 VESSEL_TYPE NUMBER 22 Yes No 38 Active Unique identifier of a vessel type NUMBER 12 GEARTYPE_FORM VARCHAR2 1 Yes No Active 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. VARCHAR2 13 GEAR_TYPE_CODE NUMBER 22 Yes No 38 Active Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record NUMBER 14 RST_CODE VARCHAR2 1 No No Active VARCHAR2 15 DETERRENCE_CODE VARCHAR2 2 No No Active Deterrence code from NORPAC bird or mammal deterance tables VARCHAR2 16 ANIMAL_TYPE_CODE VARCHAR2 1 No No Active Optional FK from LOV_Deterrence. Class of animal mammal (M), bird (B) for which the deterrence (if it exists) was utilized VARCHAR2 17 LOCATION_CODE VARCHAR2 1 Yes No Active Identifies whether the information in a haul is based on retrieval or delivery (as in a mother ship) VARCHAR2 18 RETRV_DATE_TIME DATE 7 Yes No Active Date and time recorded by the observer from the vessel log. DATE 19 RETRV_LATITUDE_DEGREES NUMBER 22 Yes No 2 0 Active Location of gear retrieval. NUMBER 20 RETRV_LATITUDE_MINUTES NUMBER 22 Yes No 2 0 Active Location of gear retrieval. NUMBER 21 RETRV_LATITUDE_SECONDS NUMBER 22 No No 2 0 Active Location of gear retrieval. NUMBER 22 RETRV_EW VARCHAR2 1 Yes No Active Location of gear retrieval. VARCHAR2 23 RETRV_LONGITUDE_DEGREES NUMBER 22 Yes No 3 0 Active Location of gear retrieval. NUMBER 24 RETRV_LONGITUDE_MINUTES NUMBER 22 Yes No 2 0 Active Location of gear retrieval. NUMBER 25 RETRV_LONGITUDE_SECONDS NUMBER 22 No No 2 0 Active Location of gear retrieval. NUMBER 26 DEPLOY_DATE_TIME DATE 7 No No Active Date and time recorded by the observer from the vessel log. DATE 27 DEPLOY_LATITUDE_DEGREES NUMBER 22 No No 2 0 Active Location of gear deployment. NUMBER 28 DEPLOY_LATITUDE_MINUTES NUMBER 22 No No 2 0 Active Location of gear deployment. NUMBER 29 DEPLOY_LATITUDE_SECONDS NUMBER 22 No No 2 0 Active Location of gear deployment. NUMBER 30 DEPLOY_EW VARCHAR2 1 No No Active Location of gear deployment. VARCHAR2 31 DEPLOY_LONGITUDE_DEGREES NUMBER 22 No No 3 0 Active Location of gear deployment. NUMBER 32 DEPLOY_LONGITUDE_MINUTES NUMBER 22 No No 2 0 Active Location of gear deployment. NUMBER 33 DEPLOY_LONGITUDE_SECONDS NUMBER 22 No No 2 0 Active Location of gear deployment. NUMBER 34 BOTTOM_DEPTH NUMBER 22 No No 5 0 Active Average bottom depth recorded by the observer from the vessel log. NUMBER 35 FISHING_DEPTH NUMBER 22 No No 5 0 Active Average fishing depth recorded by the observer from the vessel log. NUMBER 36 DEPTH_METER_FATHOM VARCHAR2 1 No No Active Identifies whether depth is recorded in meters or fathoms. VARCHAR2 37 VESSEL_EST_CATCH NUMBER 22 No No 6 2 Active Total catch weight in metric tons as recorded in the vessel log. NUMBER 38 OBSVR_EST_CATCH NUMBER 22 No No 6 2 Active Total catch weight as estimated by the observer in metric tons. NUMBER 39 OBSVR_EST_METHOD VARCHAR2 1 No No Active Method used to determine the observer estimated catch VARCHAR2 40 OBSVR_EST_DISCARDS NUMBER 22 No No 6 2 Active Observer estimate of total discards NUMBER 41 DENSITY NUMBER 22 No No 3 2 Active Density used by the observer to determine the total catch weights. NUMBER 42 INDIV_FISHING_QUOTA_FLAG VARCHAR2 1 Yes No Active Identifies whether fishing is on an IFQ quota with the subsequent application of IFQ rules. VARCHAR2 43 SAMPLED_BY NUMBER 22 Yes No 38 Active Identifies where a haul is sampled by an observer and in some cases by which observer. NUMBER 44 NUMBER_OF_SKATES NUMBER 22 No No 4 2 Active Number of skates for longline fishing. NUMBER 45 NUMBER_OF_HOOKS_PER_SKATE NUMBER 22 No No 4 0 Active Number of hooks per skate for longline fishing. NUMBER 46 TOTAL_HOOKS NUMBER 22 No No 6 0 Active Total number of hooks deployed for this haul NUMBER 47 TOTAL_POTS NUMBER 22 No No 5 0 Active Total number of pots deployed for this haul. NUMBER 48 MMAMMAL_MONITR_PCT NUMBER 22 No No 3 0 Active 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. NUMBER 49 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 50 VOLUME NUMBER 22 No No 6 2 Active Estimate of volume of catch NUMBER 51 TOTAL_HOOKS_OVERIDE_FLAG VARCHAR2 1 No No Active 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. VARCHAR2 52 BIRD_MONITOR_LEVEL_CODE VARCHAR2 4 No No Active Portion of the haulback that was monitored by the observer for bird interactions. VARCHAR2 53 SHORTWIRED_FLAG VARCHAR2 1 Yes No Active 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. VARCHAR2 54 SAMPLE_UNIT_CODE VARCHAR2 6 No No Active 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. VARCHAR2 55 SAMPLE_SYSTEM_CODE NUMBER 22 No No 38 Active Unique numeric identifier of a sample coding system. NUMBER gov.noaa.nmfs.inport:9619 Doug Turnbull 2009-06-30T16:11:08 SysAdmin InPortAdmin 2022-08-09T17:11:03 2018-09-26 Alaska Fisheries Science Center AFSC 7600 Sand Point Way N.E., Building 4 Seattle WA 98115 USA https://www.afsc.noaa.gov 0700-1700 Pacific Time 1001 Public No 2018-09-26 1 Year 2019-09-26