FMA norpac.cruises 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.cruises Table Documentation

Table name	Definition
NORPAC.CRUISES	This is a table that joins the cruise number with the observer and the observer contract ID.

Column name	Type	Definition
CRUISE	number(8,0)	A unique five-digit number assigned to the observer for the length of their contract period. This number alone identifies and groups a set of observer information.
DATE_OF_ENTRY	date	The date in which this entry was made.
SEABIRDS	varchar2(1)	During debriefing a record is entered in this table if an observer has seabird notes in their logbook. If an observer has seabird notes in their logbook the debriefer makes a photocopy of these notes and gives the photocopy to one particular staff member in charge of seabirds.
OBSERVER_JOIN	number(6,0)	A unique number that identifies a specific observer.
OBSERVER_CONTRACT_ID	number(8,0)	This is a number associated with an observer's specific 90-day contract.
DEPLOYMENT_DATE	date	This is the date in which the observer was deployed on their first vessel or plant for this contract.

Return to Domestic_tables

Last Updated 02 - June - 2009