9750
Table: ATL_SAMPLE_H
ATL_SAMPLE_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 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.
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.
Loaded by batch 2390, 06-30-2009 16:11
Data Table
Yes
NORPAC
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.
SAMPLED_BY
NUMBER
No
No
Active
Cruise of sampling observer.
1
SEQ_NUMBER
NUMBER
22
Yes
Yes
10
0
Active
Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, increment by 1 and do not cycle.
NUMBER
2
CHANGED_BY
VARCHAR2
30
No
No
Active
Oracle user who made a change to the transaction table record.
VARCHAR2
3
DATE_CHANGED
DATE
7
No
No
Active
Timestamp of change to transaction record.
DATE
4
CRUISE
NUMBER
22
No
No
22
0
Active
Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
NUMBER
5
SAMPLE_SEQ
NUMBER
22
No
No
22
0
Active
Sequence generated unique identifier of a sample
NUMBER
6
PARENT_SAMPLE_SEQ
NUMBER
22
No
No
22
0
Active
Sequence generated unique identifier of a sample
NUMBER
7
SAMPLE_NUMBER
NUMBER
22
No
No
22
0
Active
Sequence within either haul or offload parent. This value is auto-generated but not necessarily unique.
NUMBER
8
OFFLOAD_SEQ
NUMBER
22
No
No
22
0
Active
Sequence generated unique identifier for an offload record
NUMBER
9
HAUL_SEQ
NUMBER
22
No
No
22
0
Active
Sequence generated unique identifier for a haul record
NUMBER
10
COMBINED_SAMPLE_FLAG
VARCHAR2
1
No
No
Active
Identifies whether unique samples within a haul have been aggregated together.
VARCHAR2
11
PRESORTED_FLAG
VARCHAR2
1
No
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
12
TOTAL_SAMPLE_WEIGHT
NUMBER
22
No
No
10
2
Active
Total weight in kg of this sample.
NUMBER
13
SAMPLE_HOOKS_POTS
NUMBER
22
No
No
6
0
Active
Number of hooks or pots sampled.
NUMBER
14
PERMIT
VARCHAR2
6
No
No
Active
Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
VARCHAR2
15
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
16
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
17
NUMBER_OF_SEGMENTS_SAMPLED
NUMBER
22
No
No
2
2
Active
The number of segments (skates, racks) of hooks which went into this sample. This number may be fractional.
NUMBER
18
SAMPLE_HOOKS_OVERIDE_FLAG
VARCHAR2
1
Yes
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
gov.noaa.nmfs.inport:9750
Doug Turnbull
2009-06-30T16:11:46
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
http://www.afsc.noaa.gov
0700-1700 Pacific Time
1001
Public
No
2018-09-26
1 Year
2019-09-26