9678 ATL_HAUL_HOOK_COUNT_H Entity Published / External 7284 AFSC/FMA/North Pacific Groundfish and Halibut Observer Program, Post 2008 Fishery Statistics. Data Set Completed This entity represents the observer matching of hauls by haul number to hook count sets by set number. That value is used to compute and populate the haul total hooks, and sample sample hooks-pots. Both total hooks and sample hooks may be overwritten by the observer, however as a general rule will be computed by the average hooks per segment computed for a hook count set * number of segments in the haul or number of segments sampled in the sample. Histories of all changes to data are maintained by trigger code on the parent table; allowing change control by user and datetime for all updates and delete events.. These modules both on the Atlas Client and NORPAC go live Jan 2010. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the observer matching of hauls by haul number to hook count sets by set number. That value is used to compute and populate the haul total hooks, and sample sample hooks-pots. Both total hooks and sample hooks may be overwritten by the observer, however as a general rule will be computed by the average hooks per segment computed for a hook count set * number of segments in the haul or number of segments sampled in the sample. 1 SEQ_NUMBER NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, icrement by 1 and do not cycle. NUMBER 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 CHANGED_BY VARCHAR2 30 No No Active Oracle user who made a change to the transaction table record. VARCHAR2 5 DATE_CHANGED DATE 7 No No Active Timestamp of change to transaction record. DATE 6 HAUL_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier for a haul record NUMBER 7 SET_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier of a hook spacing set. NUMBER 8 HAUL_NUMBER NUMBER 22 Yes No 38 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 9 COLLECTION_NUMBER NUMBER 22 Yes No 3 0 Active User Defined Hook Count Sent number unique for a cruise permit. NUMBER gov.noaa.nmfs.inport:9678 Doug Turnbull 2009-06-30T16:11:27 SysAdmin InPortAdmin 2022-08-09T17:11:02 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