9622 ATLW_HOOK_COUNT_SET Entity Published / External 7284 AFSC/FMA/North Pacific Groundfish and Halibut Observer Program, Post 2008 Fishery Statistics. Data Set Completed Twice a week an observer is required to measure hook spacing and total hooks for twenty percent of the segments (skates/racks) of a typical haul. These measurements may be taken all at once or over a period of time and accumulated into a set. This entity represents that collection of hook and spacing data. Working Tables accept the raw data from field transmissions or data entry. They are unconstrained, Relational integrity data validation is performed when data are loaded into NORPAC transaction tables. Error checking is performed by batch processes on production data. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC Twice a week an observer is required to measure hook spacing and total hooks for twenty percent of the segments (skates/racks) of a typical haul. These measurements may be taken all at once or over a period of time and accumulated into a set. This entity represents that collection of hook and spacing data. 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 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 3 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 4 SET_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a hook spacing set. NUMBER 5 COLLECTION_NUMBER NUMBER 22 Yes No 3 0 Active User Defined Hook Count Sent number unique for a cruise permit. NUMBER 6 CRUISE_VESSEL_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier for a cruise vessel. NUMBER 7 COLLECTION_DATE DATE 7 Yes No Active Date and Time count taken. DATE gov.noaa.nmfs.inport:9622 Doug Turnbull 2009-06-30T16:11:09 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