10660 DEBRIEFED_HAUL_HOOK_COUNT Entity Published / External 10657 AFSC/FMA/North Pacific Observer Debriefed Data Presentation Layer (OBSINT) Data Set Completed This table contains a flattened view of longline hook count data. Observers are required to determine the number and spacing of hooks used in fishing operations. These counts are assembled into deployable sets of hooks and assigned by the observer to a haul. Average hook counts and spacing is insufficient as mixed gear is allowed (sablefish and halobut for example). So this presentation layer provides detail information for analysis. Loaded by batch 2535, 11-09-2010 10:55 Data Table Yes OBSINT This table contains a flattened view of longline hook count data. Observers are required to determine the number and spacing of hooks used in fishing operations. These counts are assembled into deployable sets of hooks and assigned by the observer to a haul. Average hook counts and spacing is insufficient as mixed gear is allowed (sablefish and halobut for example). So this presentation layer provides detail information for analysis. 1 T_TABLE VARCHAR2 3 No No Active Source Table VARCHAR2 2 CRUISE NUMBER 22 Yes No 9 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 Yes 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_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier for a haul record NUMBER 5 HAUL_JOIN NUMBER 22 Yes No 38 Active This is a uniquie identifier of a haul record composed by 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 6 HAUL_NUMBER NUMBER 22 Yes No 5 0 Active Unique haul for an observer vessel cruise, defaulted to an incremented sequence by the GUI. May be entered and defined by the observer. NUMBER 7 COLLECTION_NUMBER NUMBER 22 Yes No 5 0 Active User Defined Hook Count Set number unique for a cruise permit. NUMBER 8 SEGMENT_NUMBER NUMBER 22 No No 3 0 Active This attribute represents a user defined integer identifying a unit of line for counting and spacing hooks. It must be unique within a hook_count_set. NUMBER 9 NUMBER_OF_HOOKS NUMBER 22 Yes No 8 0 Active Number of hooks as determined by the observer for this segment, contained within a counted set. NUMBER 10 HOOK_SPACING_IN_CM NUMBER 22 No No 4 0 Active Spacing between hooks on a segment. This value is optional for any specific segment except the first set of spacing-count on a trip NUMBER 11 VESSEL VARCHAR2 8 No No Active Vessel code from the ATL_LOV vessel table. VARCHAR2 gov.noaa.nmfs.inport:10660 Doug Turnbull 2010-11-09T10:55:44 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