19049
Table: ATL_SAMPLE
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
http://www.afsc.noaa.gov
0700-1700 Pacific Time
1001
Public
No
2016-05-18
1 Year
2017-05-18