9748
Table: ATL_SALMON_H
ATL_SALMON_H
Entity
Published / External
7284
AFSC/FMA/North Pacific Groundfish and Halibut Observer Program, Post 2008 Fishery Statistics.
Data Set
Completed
This entity records the number of prohibited pacific salmon recorded as bycatch ,by species, for an offload or a haul.
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 records the number of prohibited pacific salmon recorded as bycatch ,by species, for an offload or a haul.
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
SALMON_SEQ
NUMBER
22
No
No
22
0
Active
Sequence generated unique identifier of a salmon record
NUMBER
6
OFFLOAD_SEQ
NUMBER
22
No
No
22
0
Active
Sequence generated unique identifier for an offload record
NUMBER
7
HAUL_SEQ
NUMBER
22
No
No
22
0
Active
Sequence generated unique identifier for a haul record
NUMBER
8
RELIABILITY_CODE
NUMBER
22
No
No
22
0
Active
Unique Numeric Value recording who (industry and or observer) recorded the salmon census. FK from lov_salmon_reliability.
NUMBER
9
SCALE
VARCHAR2
1
No
No
Active
Whether the temperature was recorded in degrees farenheit or celsius.
VARCHAR2
10
FISHING_TEMP
NUMBER
22
No
No
22
0
Active
Temperature recorded at fishing depth
NUMBER
11
NUMBER_CHINOOK
NUMBER
22
No
No
22
0
Active
Number of Chinook recorded for this Haul or Offload. (Census of Salmon beginning 2011).
NUMBER
12
NUMBER_OTHER
NUMBER
22
No
No
22
0
Active
Number of Other salmon species recorded for this Haul or Offload. (Census of Salmon beginning 2011).
NUMBER
13
NUMBER_UNIDENTIFIED
NUMBER
22
No
No
22
0
Active
Number of Salmon which could not be identified by species for this Haul or Offload. (Census of Salmon beginning 2011).
NUMBER
14
SURFACE_TEMP
NUMBER
22
No
No
22
0
Active
Surface temperature of the water. Applicable only to hauls.
NUMBER
15
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
16
NUMBER_PINK
NUMBER
22
No
No
5
0
Active
Number of Pink salmon tallied for this offload.
NUMBER
17
NUMBER_SOCKEYE
NUMBER
22
No
No
5
0
Active
Number of Sockeye salmon tallied for this offload.
NUMBER
18
NUMBER_COHO
NUMBER
22
No
No
5
0
Active
Number of Coho salmon tallied for this offload.
NUMBER
gov.noaa.nmfs.inport:9748
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