9579
Table: FOREIGN_OBSERVER
FOREIGN_OBSERVER
Entity
Published / External
9556
AFSC/FMA/North Pacific Observer Foreign Fishing
Data Set
Completed
This table provides the observer name and contractor code associated with each cruise and vessel.
Loaded by batch 2364, 06-29-2009 18:15
Data Table
Yes
NORPAC
This table provides the observer name and contractor code associated with each cruise and vessel.
1
CRUISE
NUMBER
22
Yes
Yes
4
0
Active
A unique four-digit number assigned to the observer for the length of their contract period. This number alone identifies and groups a set of observer information.
NUMBER
NORPAC.FOREIGN_FISHING_OPERATI
2
VESSEL
VARCHAR2
4
Yes
Yes
Active
A unique, four-digit, alpha-numeric code identifying each vessel that contracts for observer coverage. All vessel codes begin with the alpha code B, followed by a three-digit number.
VARCHAR2
Refers to more than one entity
3
CONTRACTOR
VARCHAR2
5
No
No
Active
Abbreviation of the name of the organization that provided the observer. The NORPAC.FOREIGN_CONTRACTOR table contains a description of each abbreviation.
VARCHAR2
NORPAC.FOREIGN_CONTRACTOR
4
LAST_NAME
VARCHAR2
20
Yes
Yes
Active
Last name of the observer who collected the sample data.
VARCHAR2
5
FIRST_NAME
VARCHAR2
15
Yes
Yes
Active
First name of the observer who collected the sample data.
VARCHAR2
6
MIDDLE_NAME
VARCHAR2
15
No
No
Active
Middle name of the observer who collected the sample data.
VARCHAR2
7
DOMESTIC_OBSERVER_LINK
NUMBER
22
No
No
5
0
Active
For internal use only (is currently null).
NUMBER
gov.noaa.nmfs.inport:9579
Doug Turnbull
2009-06-29T18:15:08
SysAdmin InPortAdmin
2022-08-09T17:11:03
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