19049 ATL_SAMPLE Entity Published / External 18964 AFSC/FMA/NPRB Alternative Catch Monitoring Table and Column Definitions Data Set Completed This entity represents the individual samples of a type that may be collected from an observed haul. It is header information for species composition. If there are rare species present in sample and there exist multiple predominant species, a recursive subsample or subsamples may be created. The sum of the weights of the subsamples must be less than or equal to the parent sample. Loaded by batch 4574, 05-03-2013 17:18 Data Table Yes NPRB_1017 This entity represents the individual samples of a type that may be collected from an observed haul. It is header information for species composition. If there are rare species present in sample and there exist multiple predominant species, a recursive subsample or subsamples may be created. The sum of the weights of the subsamples must be less than or equal to the parent sample. 1 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 NPRB_1017.ATL_HAUL 2 SAMPLE_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a sample NUMBER 3 PARENT_SAMPLE_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a sample NUMBER NPRB_1017.ATL_SAMPLE 4 SAMPLE_NUMBER NUMBER 22 Yes No 9 0 Active Sequence within either haul or offload parent. This value is auto-generated but not necessarily unique. NUMBER 5 OFFLOAD_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for an offload record NUMBER NPRB_1017.ATL_OFFLOAD 6 HAUL_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for a haul record NUMBER NPRB_1017.ATL_HAUL 7 COMBINED_SAMPLE_FLAG VARCHAR2 1 Yes No Active Identifies whether unique samples within a haul have been aggregated together. VARCHAR2 8 PRESORTED_FLAG VARCHAR2 1 Yes No Active This flag indicates that child species composition records did not come from and unsorted catch. Generally if a single large animal was removed before sampling began and so was not available for inclusion in any random sample VARCHAR2 9 TOTAL_SAMPLE_WEIGHT NUMBER 22 No No 10 2 Active Total weight in kg of this sample. NUMBER 10 SAMPLE_HOOKS_POTS NUMBER 22 No No 6 0 Active Number of hooks or pots sampled. NUMBER 11 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 NPRB_1017.ATL_HAUL 12 SPECIES_COMP_IN_SAMPLE VARCHAR2 1 No No Active This flag indicates that fish were found or were absent in this sample - in the latter case composition records are not permitted and the sample is ignored for extrapolations. VARCHAR2 13 SAMPLE_DESIGN_FLAG VARCHAR2 1 Yes No Active Identifies this sample as complying (Y) or differing (N) from the protocol declared at the haul level. VARCHAR2 14 NUMBER_OF_SEGMENTS_SAMPLED NUMBER 22 No No 38 2 Active The number of segments (skates, racks) of hooks which went into this sample. This number may be fractional. NUMBER 15 SAMPLE_HOOKS_OVERIDE_FLAG VARCHAR2 1 No No Active This flag identifies an observer overide of the computed sample hooks - pots variable. The setting of the flag to Y will prohibit the automatic computation of sample hooks-pots from haul-hook-count * number-of-segments-sampled. VARCHAR2 16 SAMPLED_BY NUMBER 22 No No 38 0 Active no-comment NUMBER gov.noaa.nmfs.inport:19049 Doug Turnbull 2013-05-03T17:18:48 SysAdmin InPortAdmin 2022-08-09T17:11:09 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