18986 ATL_HAUL Entity Published / External 18964 AFSC/FMA/NPRB Alternative Catch Monitoring Table and Column Definitions 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 4574, 05-03-2013 17:18 Data Table Yes NPRB_1017 Hauls are unique fishing events of gear deployment and retrieval and may also contain information unique to a day where no fishing occured. 1 CRUISE NUMBER 22 Yes Yes 9 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER NPRB_1017.ATL_FMA_TRIP 2 HAUL_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for a haul record NUMBER 3 HAUL_NUMBER NUMBER 22 Yes No 6 0 Active Number which is entered by the observer identifying a unique haul within a trip. NUMBER 4 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 NPRB_1017.ATL_LOV_HAUL_PURPOSE 5 CDQ_CODE VARCHAR2 3 No No Active Unique AlphaNumeric code representing a CDQ or research group VARCHAR2 NPRB_1017.ATL_LOV_CDQ 6 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 7 TRIP_SEQ NUMBER 22 Yes No 38 0 Active Sequence generated unique identifier of a trip NUMBER NPRB_1017.ATL_FMA_TRIP 8 VESSEL_TYPE NUMBER 22 Yes No Active Unique identifier of a vessel type NUMBER NPRB_1017.ATL_LOV_VESSEL_TYPE 9 GEAR_PERFORMANCE_CODE NUMBER 22 Yes No 38 Active Unique performance code for a gear type. NUMBER NPRB_1017.ATL_LOV_GEAR_PERFORM 10 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 NPRB_1017.ATL_LOV_GEAR_TYPE 11 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 NPRB_1017.ATL_LOV_GEAR_TYPE 12 RBT_CODE VARCHAR2 1 No No Active Random Break Table identifier Currently limted to Y (es) or N(o) VARCHAR2 NPRB_1017.ATL_LOV_RBT_CODE 13 RST_CODE VARCHAR2 1 No No Active Random Sample Reference Table code reference. VARCHAR2 NPRB_1017.ATL_LOV_RST_CODE 14 DETERRENCE_CODE VARCHAR2 2 No No Active Deterrence code from NORPAC bird or mammal deterance tables VARCHAR2 NPRB_1017.ATL_LOV_DETERRENCE 15 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 NPRB_1017.ATL_LOV_DETERRENCE 16 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 17 RETRV_DATE_TIME DATE 7 Yes No Active Date recorded by the observer from the vessel log. DATE 18 RETRV_LATITUDE_DEGREES NUMBER 22 Yes No 2 0 Active Location of gear retrieval. NUMBER 19 RETRV_LATITUDE_MINUTES NUMBER 22 Yes No 2 0 Active Location of gear retrieval. NUMBER 20 RETRV_LATITUDE_SECONDS NUMBER 22 No No 2 0 Active Location of gear retrieval. NUMBER 21 RETRV_EW VARCHAR2 1 Yes No Active Location of gear retrieval. VARCHAR2 22 RETRV_LONGITUDE_DEGREES NUMBER 22 Yes No 38 0 Active Location of gear retrieval. NUMBER 23 RETRV_LONGITUDE_MINUTES NUMBER 22 Yes No 2 0 Active Location of gear retrieval. NUMBER 24 RETRV_LONGITUDE_SECONDS NUMBER 22 No No 2 0 Active Location of gear retrieval. NUMBER 25 NMFS_AREA NUMBER 22 No No 3 0 Active This is a calculated value from retrieval lat-long. It is stored for the convenience of the user community. 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 38 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 38 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 38 2 Active Total catch weight in metric tons as recorded in the vessel log. NUMBER 38 OBSVR_EST_CATCH NUMBER 22 No No 10 2 Active Total catch weight as estimated by the observer in kgs. 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 38 2 Active Observer estimate of total discards in kgs. NUMBER 41 DENSITY NUMBER 22 No No 6 2 Active Density used by the observer to determine the total catch weights. Recorded in kgs per m3. 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 0 Active 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 44 NUMBER_OF_SKATES NUMBER 22 No No 7 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 6 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 NPRB_1017.ATL_FMA_TRIP 50 VOLUME NUMBER 22 No No 38 2 Active Estimate of volume of catch NUMBER 51 DATE_OF_ENTRY DATE 7 No No Active 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. DATE 52 SAMPLE_SYSTEM_CODE NUMBER 22 No No 38 Active Unique numeric identifier of a sample coding system. NUMBER NPRB_1017.ATL_LOV_SAMPLE_SYSTE 53 SAMPLE_UNIT_CODE NUMBER 22 No No 6 0 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. NUMBER NPRB_1017.ATL_LOV_SAMPLE_UNIT 54 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 55 BIRD_HAULBACK_CODE VARCHAR2 10 No No Active Portion of the haulback that was monitored by the observer for bird interactions. VARCHAR2 NPRB_1017.ATL_LOV_BIRD_HAULBAC 56 BIRD_SHORTWIRED_FLAG VARCHAR2 1 No 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. 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. VARCHAR2 57 UNITS VARCHAR2 4 No No Active no-comment VARCHAR2 58 POPULATION_SIZE NUMBER 22 No No 16 6 Active no-comment NUMBER 59 UNIT_SIZE NUMBER 22 No No 16 6 Active no-comment NUMBER 60 NUMBER_OF_UNITS_SAMPLED NUMBER 22 No No 10 6 Active no-comment NUMBER 61 UNITS_IN_POPULATION NUMBER 22 No No 10 6 Active no-comment NUMBER gov.noaa.nmfs.inport:18986 Doug Turnbull 2013-05-03T17:18:46 SysAdmin InPortAdmin 2022-08-09T17:11:09 2016-05-18 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 2016-05-18 1 Year 2017-05-18