Intern:Campaign

The CAMPAIGN table contains metadata about campaigns (synonyms: cruise, expedition, leg) and are related to a certain project. Campaign as the second level in the data model may be used as an option, but is recommended to more easily list separate sampling locations. If no metainformation is available, a generic campaign label or the label 'not_given' may be used.

Define new Campaigns

 * by opening CAMPAIGN and clicking on New and filling out the fields as described below. Input to relational fields must be defined in the related tables first.

Import new Campaigns
CAMPAIGN IMPORT FORM 
 * For lists of new campaigns to be imported, please use the
 * For importing campaign Attributes, add the attribute name or ID in the header.
 * Import via 4D-Menu File/Import, choose Campaigns.

Field descriptions
Field descriptions for the campaign table; recommendations on how to fill out the columns in the import form are given in italics.

Basics tab

 * Name of the campaign; must be unique and does not contain blanks (use _ instead); use abbreviations instead of full names. (The campaign name is used in the Event import list InpEvent.xls to set the relation between events and campaign.)
 * Optional label may contain any additional name(s) or labels of a campaign as free text, separated by blank.
 * Basis is the station platform used for the operation of the campaign; > relational to table Basis > contains the name as defined in the Basis table.
 * Begin defines the start date of the campaign, format as set up in the local operation system.
 * End defines the end.
 * Responsible scientist(s) are persons being responsible for a campaign; > multiple choice relation to Staff; use names or staff-IDs separated by ; for import. (Sverdrup, Harald Ulrik or Sverdrup, HU or 30411. ID of staff is preferred.)
 * Project is related to table Project and set in the requester when choosing Import/Campaign from the menu.
 * Events info only; shows event labels and the number of events, related to this campaign, automatically updated by the relational system

Details tab

 * Report may contain the citation of the campaigns report (e.g. cruise report); > related to table Reference; relations to be set by hand; use ReferenceID for import.
 * Comment free text for any additional information.


 * Additional attributes after selecting Schema, you can add further information

In some international projects (e.g. WOCE, CarboOcean), cruises of research vessels are identfied via the NODC Ship code, called EXPOCODE.

Links

 * Ship tracker
 * NODC country codes
 * NODC ship codes
 * DDI on cruise lists of some important research vessels