22441 DEBRIEFED_OFFLOAD Entity Published / External 10657 AFSC/FMA/North Pacific Observer Debriefed Data Presentation Layer (OBSINT) Data Set In Work This entity represents the offload of a vessel which is observed by the observer assigned to the processing plant. The data comes from ATL_Offload, and does not include offloads recorded by vessel observers. Provides a flattened and denormalized view of debriefed offload observer data for use by status of stocks authors and other researchers. Theme AFSC Theme DEBRIEFED Theme DOMESTIC Theme FMA Theme GROUNDFISH Theme HAKE Theme NORPAC Theme OBSERVER Theme OBSINT Theme POLLOCK Temporal CONTINUOUS Spatial AI Spatial ALASKA Spatial BS Spatial BSAI Spatial GOA Spatial NORTH PACIFIC Stratum DEMERSAL Stratum FIXED Stratum MOBILE Stratum OCEANIC Stratum PELEGIC Alaska Fisheries Science Center Seattle WA USA Data Table debriefed_haul obsint This entity represents the offload of a vessel which is observed by the observer assigned to the processing plant. The data comes from ATL_Offload, and does not include offloads recorded by vessel observers. 1 T_TABLE varchar2 20 Yes No Active Identifier of Source Table 2 OFFLOAD_JOIN number 20 Yes No Active Surrogate FK to offload if salmon record is so derived Composed of concatenation of cruise, permit and offloadl_seq. 3 DELIVERY_VESSEL_ADFG varchar2 6 No No Active ADFG number which may be entered by the plant observer without validation, this value is not internally validated at the time of entry. 4 CDQ_CODE varchar2 3 No No Active Unique AlphaNumeric code representing a CDQ or research group 5 PGM_CODE varchar2 8 No No Active Unique Identifier of a valid catcher vessel landing management program. 6 LANDING_REPORT_ID number 10 No No 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. 7 OFFLOAD_SEQ number 9 No No Active Sequence generated unique identifier for an offload record 8 CRUISE number 9 No No Active Sequence generated by Norpac and supplied to the observer as an unique identifier for a processing plant observer cruise record 9 PERMIT VARCHAR2 6 No No Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau 10 OFFLOAD_NUMBER NUMBER 9 No No Active Unique offload for an observer cruise entered by the observer. The number must be unique within a cruise/permit combination. 11 PLANT_SEQ NUMBER 9 No No Active Sequence generated unique identifier for a processing plant. 12 PLANT_CODE VARCHAR2 4 No No Active VessPlnt code from old NORPAC system plus new plants recorded in ATL_LOV_Plant. This code may ultimately be retired, but is essential to the transitional ETL from Atlas to Inseason and Domestic. 13 PLANT_NAME VARCHAR2 50 No No Active 14 GEAR_TYPE_CODE NUMBER 3 No No Active Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record 15 NMFS_AREA VARCHAR2 3 No No Active NMFS Reporting Area 16 DELIVERED_WEIGHT_IN_KG NUMBER 10 No No 10 3 Active Identifies the total weight of all species delivered recorded in kilograms or lbs. 17 TOTAL_POLLOCK_WEIGHT_IN_KG NUMBER 10 No No 10 3 Active Identifies the total weight of pollock delivered recorded in kilograms or lbs. 18 DELIVERY_END_DATE DATE 6 No No Active Date the delivery was complete. 19 LAST_MODIFIED_DATE DATE 6 No No Active Everytime an offload record from the production schema is processed the the obsint.load_DEBRIEFED_offload the processing datetime is recorded here. This does not necessarily mean the DEBRIEFED offload record was modified as the program processes every offload within a cruise permit when initiated. 20 FISHING_START_DATE DATE 6 No No Active 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. 21 OFFLOAD_HASH VARCHAR2 32 No No Active The offload hash is utilized by AKRO to identify changes to an offload record. The hash is created every time that a record is created or updated. Only critical data columns are referenced and change is denoted by a change in the hash value. 22 SALMON_HASH VARCHAR2 32 No No Active The salmon hash is utilized by AKRO to identify changes to a salmon retention record. The hash is created every time that a record is created or updated. Only critical data columns are referenced and change is denoted by a change in the hash value. gov.noaa.nmfs.inport:22441 Doug Turnbull 2014-11-05T13:36:19 SysAdmin InPortAdmin 2022-08-09T17:11:02 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