9680
Table: ATL_HOOKS_PER_SEGMENT_H
ATL_HOOKS_PER_SEGMENT_H
Entity
Published / External
7284
AFSC/FMA/North Pacific Groundfish and Halibut Observer Program, Post 2008 Fishery Statistics.
Data Set
Completed
Stock assessment authors for sablefish (and potentially for P.cod) use catch-per-unit-effort information in their models. A key component of this is the spacing of the hooks on the gear. Every year, we issue a special project where the observers measure the spacing of the hooks on a few segments of gear. That special project has been absorbed into the standard data set for 2010. This entity represent the hook count and hook spacing measurements for a segment of gear.
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
Stock assessment authors for sablefish (and potentially for P.cod) use catch-per-unit-effort information in their models. A key component of this is the spacing of the hooks on the gear. Every year, we issue a special project where the observers measure the spacing of the hooks on a few segments of gear. That special project has been absorbed into the standard data set for 2010. This entity represent the hook count and hook spacing measurements for a segment of gear.
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
HOOKS_PER_SEGMENT_SEQ
NUMBER
22
Yes
No
9
0
Active
Sequence generated unique identifier of a hook count and measure for a segment of longline gear.
NUMBER
7
SET_SEQ
NUMBER
22
Yes
No
9
0
Active
Sequence generated unique identifier of a hook spacing set.
NUMBER
8
SEGMENT_NUMBER
NUMBER
22
No
No
3
0
Active
This attribute represents a user defined integer identifying a unit of line for counting and spacing hooks. It must be unique within a hook_count_set.
NUMBER
9
NUMBER_OF_HOOKS
NUMBER
22
Yes
No
8
0
Active
Number of hooks per segment
NUMBER
10
HOOK_SPACING_IN_CM
NUMBER
22
No
No
4
0
Active
Spacing between hooks on a segment. This value is optional for any specific segment except the first set of spacing-count on a trip
NUMBER
gov.noaa.nmfs.inport:9680
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
http://www.afsc.noaa.gov
0700-1700 Pacific Time
1001
Public
No
2018-09-26
1 Year
2019-09-26