9741 ATL_OFFLOAD Entity Published / External 7284 AFSC/FMA/North Pacific Groundfish and Halibut Observer Program, Post 2008 Fishery Statistics. Data Set Completed This entity represents an offload event at a processing plant or mothership. Loaded by batch 2390, 06-30-2009 16:11 Theme AFSC Theme ATL Theme ATLAS Theme BYCATCH Theme DELIVERY Theme FMA Theme GROUNDFISH Theme NORPAC Theme OBSERVER Theme OFFLOAD Spatial AI Spatial ALEUTIAN ISLANDS Spatial BERING SEA Spatial BS Spatial BSAI Spatial GOA Spatial GULF OF ALASKA Data Table Yes NORPAC This entity represents an offload event at a processing plant or mothership. 1 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 Refers to more than one entity 1 cruise1 NUMBER 22 No No 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER Refers to more than one entity 2 OFFLOAD_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for an offload record NUMBER 3 OFFLOAD_NUMBER NUMBER 22 Yes No 38 Active Identifier of an offload within an observer cruise entered by the observer. The value of this user defined column must be unique within a Cruise-Permit combination. NUMBER 4 TRIP_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a trip NUMBER NORPAC.ATL_FMA_TRIP 5 PLANT_SEQ NUMBER 22 No No 9 0 Active Optional FK to Plant. Part of arc involving catcher vessel, haul, and cruise plant. Code identifying a processing plant - inherited from the NORPAC data set. The plant seq is an autogenerated unique identifier. NUMBER NORPAC.ATL_LOV_PLANT 6 CRUISE_PLANT_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique value for a cruise plant record. NUMBER NORPAC.ATL_CRUISE_PLANT 7 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 8 GEAR_TYPE_CODE NUMBER 22 No No 38 Active Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record NUMBER NORPAC.ATL_LOV_GEAR_TYPE 9 GEARTYPE_FORM VARCHAR2 1 No 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 NORPAC.ATL_LOV_GEAR_TYPE 10 DELIVERY_END_DATE DATE 7 No No Active Date the delivery was complete. DATE 11 NMFS_AREA VARCHAR2 3 No No Active NMFS Reporting Area VARCHAR2 12 DELIVERED_WEIGHT NUMBER 22 No No 10 3 Active Total weight of the delivery NUMBER 13 TOTAL_POLLOCK_WEIGHT NUMBER 22 No No 10 3 Active Identifies the total weight of pollock delivered NUMBER 14 LB_MT VARCHAR2 2 No No Active Pounds or Metric Tons identifier of weight. VARCHAR2 15 SORTED_AT_SEA_FLAG VARCHAR2 1 Yes No Active Identifies catch sorted by the catcher vessel at sea. VARCHAR2 16 GROUNDFISH_WEIGHED_FLAG VARCHAR2 1 No No Active Identifies whether or not all the groundfish were weighed. VARCHAR2 17 OFFLOAD_TO_TENDER_FLAG VARCHAR2 1 No No Active Identifies if a tender was used to make this delivery. VARCHAR2 18 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 Refers to more than one entity 19 LANDING_REPORT_ID NUMBER 22 No No 10 0 Active The region uses the landing report id off the electronic fish ticket as a join column for the catch accounting system. The value is printed on the lower quadrant of every ER fish ticket. Landing_Report_ID is unique to an offload. NUMBER gov.noaa.nmfs.inport:9741 Doug Turnbull 2009-06-30T16:11:43 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