10661 DEBRIEFED_LENGTH Entity Published / External 10657 AFSC/FMA/North Pacific Observer Debriefed Data Presentation Layer (OBSINT) Data Set Completed The debriefed length table was created as a successor to the debriefed length materialized view. The table is a bridge object between the Domestic data (pre 2008) and the ATL data (2008 onwards) As such, refinements to the structure and statistical reliability realized in the redevelopment of Norpac are lost. The use of this table is primarily for status of stocks authors who require a longitudinal view of observer data. Loaded by batch 2535, 11-09-2010 10:55 Data Table Yes OBSINT The debriefed length table was created as a successor to the debriefed length materialized view. The table is a bridge object between the Domestic data (pre 2008) and the ATL data (2008 onwards) As such, refinements to the structure and statistical reliability realized in the redevelopment of Norpac are lost. The use of this table is primarily for status of stocks authors who require a longitudinal view of observer data. 1 T_TABLE VARCHAR2 18 No No Active Identifier of Source Table. VARCHAR2 2 CRUISE 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 3 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. VARCHAR2 4 HAUL_JOIN NUMBER 22 No No 38 Active Surrogate FK to haul if length record is so derived Composed of concatenation of cruise, permit and haul_seq. For domestic table records this is a sequence generated unique identifier for a haul. NUMBER OBSINT.DEBRIEFED_HAUL 5 PORT_JOIN NUMBER 22 No No 38 Active Surrogate FK to offload if length record is so derived. Composed of concatenation of cruise, permit and offload_seq. For domestic table records this is a sequence generated unique identifier for a port. NUMBER 6 LENGTH_SEQ NUMBER 22 No No 38 Active Sequence generated unique identifier of an atl_length. NUMBER 7 VESSEL VARCHAR2 7 No No Active Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel. VARCHAR2 8 HAUL_OFFLOAD_DATE DATE 7 No No Active Date of offload or haul retrieval depending on whether this length frequency record was derived from an offload or a haul. DATE 9 HAUL_OFFLOAD NUMBER 22 No No 38 Active Number which is entered by the observer identifying a unique haul or offload depending on which was the ultimate data source. NUMBER 10 GEAR NUMBER 22 No No 38 Active Gear type code. NUMBER 11 NMFS_AREA NUMBER 22 No No 3 0 Active Inherited from parent haul when appropriate NULL for offloads and domestic table data. NUMBER 12 LATDD_START NUMBER 22 No No 38 Active Inherited from parent haul when appropriate NULL for offloads and domestic table data. NUMBER 13 LONDD_START NUMBER 22 No No 38 Active Inherited from parent haul when appropriate NULL for offloads and domestic table data. NUMBER 14 LATDD_END NUMBER 22 No No 38 Active Inherited from parent haul when appropriate NULL for offloads and domestic table data. NUMBER 15 LONDD_END NUMBER 22 No No 38 Active Inherited from parent haul when appropriate NULL for offloads and domestic table data. NUMBER 16 SPECIES NUMBER 22 No No 38 Active Species either inherited from species composition or recorded in length if different, or if the length record is a child of haul or offload. NUMBER 17 SEX VARCHAR2 1 No No Active Sex of length frequency animals VARCHAR2 18 LENGTH NUMBER 22 No No 38 Active Measured length of organism. NUMBER 19 FREQUENCY NUMBER 22 No No 38 Active Number of animals measured. NUMBER 20 EGGS VARCHAR2 1 No No Active Indicator of presence or absence of eggs. VARCHAR2 21 YEAR NUMBER 22 No No 38 Active Year extracted from haul retrieval date or offload deleivery end date NUMBER 22 VIABILITY VARCHAR2 1 No No Active Halibut viability code. VARCHAR2 23 INJURY VARCHAR2 40 No No Active Halibut injury code. VARCHAR2 24 SAMPLE_SYSTEM NUMBER 22 No No 38 Active Code for sampling system employed by the observer. NUMBER 25 VESSEL_TYPE NUMBER 2 No No Active A one-digit numeric code that indicates whether the vessel processes fish or delivers it to a processing plant where: 1 = a catcher processor vessel, 2 = a mothership or a ship that receives unsorted codends from other vessels, 3 = a catcher only vessel that delivers unprocessed fish to a shoreside or floating plant or vessel, 4 = a mothership that receives sorted codends, 5 = a vessel that sells the majority of their catch over the side to other fishing vessels who will utilize the fish for bait, 6 = vessels that discard all catch from a haul. Would be used for codend dumping of an entire haul. 26 GEAR_PERFORMANCE NUMBER 2 No No Active Unique performance code for a gear type. FK to atl_lov_gear_performance gov.noaa.nmfs.inport:10661 Doug Turnbull 2010-11-09T10:55:45 SysAdmin InPortAdmin 2022-08-09T17:11:03 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