FMA norpac.foreign_observer Table Documentation

Note: You need to enable scripting and Javascript in your browser settings to best view and navigate our website. Otherwise, use our keyboard navigation and search page. For keyboard tabbing on this page you can bypass the top menu bar navigation and jump to the page sidebar navigation (if applicable), or jump to the page body. Our print link for screen media is scripted. Your computer's normal print command will print this page. Please contact us if you have difficulty in accessing our web pages.

Mobile users can use the Site Map to access the principal pages

FMA norpac.foreign_observer Table Documentation

Table name	Definition
NORPAC.FOREIGN_OBSERVER	This table provides the observer name and contractor code associated with each cruise and vessel.

Column name	Type	Definition
CRUISE	number(4,0)	A unique four-digit number to represent each occasion that an observer was aboard a different fishing vessel during deployment. Cruise number is associated with all of the data collected by the observer aboard the vessel.
VESSEL	varchar2(4)	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.
CONTRACTOR	varchar2(5)	Abbreviation of the name of the organization that provided the observer. The NORPAC.FOREIGN_CONTRACTOR table contains a description of each abbreviation..
LAST_NAME	varchar2(20)	Last name of the observer who collected the sample data.
FIRST_NAME	varchar2(15)	First name of the observer who collected the sample data.
MIDDLE_NAME	varchar2(15)	Middle name of the observer who collected the sample data.
DOMESTIC_OBSERVER_LINK	number(5,0)	For internal use only (is currently null).

Return to Foreign_tables

Last Updated 27 - May - 2009