Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Ecosystems & Aquaculture Division (EAD) > Oceans & Climate Branch (OCB) > Conductivity/Temperature/Depth > Oceanography Branch Hydrographic Database >

Table: HYDRO_CRUISE

Entity (ENT) | Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:33507 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Table that contains cruises that collected hydrographic data. The linking field is cruise_id to the next level; hydro_event.

Description

Table that contains cruises that collected hydrographic data. The linking field is cruise_id to the next level; hydro_event.

Entity Type
Data Table

Data Attribute / Type	Description
CRUISE_ID VARCHAR2	Cruise name used to identify the survey or cruise (and as listed in /ftp/pub/hydro).
GEAR_DESC VARCHAR2	Brief description of the instrument type used to collect hydrographic data on the cruise: bottle, XBT, SBE-19, SBE-911+, MK-5, MK-3 (various CTD types).
VESSEL VARCHAR2	The 2-character abbreviation of the vessel used for each cruise. The look up table for the abbreviations is called sv_vessel and is located on SOLE.
YEAR VARCHAR2	The year in which the cruise took place.
START_DATE DATE	The start date for the first cast/station on the cruise.
END_DATE DATE	The date of the last cast for which there are data on a cruise
OPSID VARCHAR2	The linking field for the master cruise table used Center-wide.
DOE DATE	The date of the last entry
DOC DATE	The date of the last change to the table
UOE VARCHAR2	Who made the last entry (identified by oracle username).
UOC VARCHAR2	Who made the last change to the table (identified by their oracle username).
PURPOSE_CODE NUMBER	The purpose of the cruise indicated by a 2-digit code for which there is a look-up table maintained by DMS.

Data Attribute / Type

Description

CRUISE_ID
VARCHAR2

Cruise name used to identify the survey or cruise (and as listed in /ftp/pub/hydro).

GEAR_DESC
VARCHAR2

Brief description of the instrument type used to collect hydrographic data on the cruise: bottle, XBT, SBE-19, SBE-911+, MK-5, MK-3 (various CTD types).

VESSEL
VARCHAR2

The 2-character abbreviation of the vessel used for each cruise. The look up table for the abbreviations is called sv_vessel and is located on SOLE.

YEAR
VARCHAR2

The year in which the cruise took place.

START_DATE
DATE

The start date for the first cast/station on the cruise.

END_DATE
DATE

The date of the last cast for which there are data on a cruise

OPSID
VARCHAR2

The linking field for the master cruise table used Center-wide.

DOE
DATE

The date of the last entry

DOC
DATE

The date of the last change to the table

UOE
VARCHAR2

Who made the last entry (identified by oracle username).

UOC
VARCHAR2

Who made the last change to the table (identified by their oracle username).

PURPOSE_CODE
NUMBER

The purpose of the cruise indicated by a 2-digit code for which there is a look-up table maintained by DMS.

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

Title:	Table: HYDRO_CRUISE
Short Name:	HYDRO_CRUISE
Status:	Completed
Abstract:	Table that contains cruises that collected hydrographic data. The linking field is cruise_id to the next level; hydro_event.
Notes:	Loaded by batch 9028, 07-18-2016 21:14

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	OCDBS
Description:	Table that contains cruises that collected hydrographic data. The linking field is cruise_id to the next level; hydro_event.

Attribute Summary

	Name	Type	Description
100	CRUISE_ID	VARCHAR2	Cruise name used to identify the survey or cruise (and as listed in /ftp/pub/hydro).
100	GEAR_DESC	VARCHAR2	Brief description of the instrument type used to collect hydrographic data on the cruise: bottle, XBT, SBE-19, SBE-911+, MK-5, MK-3 (various CTD types).
100	VESSEL	VARCHAR2	The 2-character abbreviation of the vessel used for each cruise. The look up table for the abbreviations is called sv_vessel and is located on SOLE.
100	YEAR	VARCHAR2	The year in which the cruise took place.
100	START_DATE	DATE	The start date for the first cast/station on the cruise.
100	END_DATE	DATE	The date of the last cast for which there are data on a cruise
100	OPSID	VARCHAR2	The linking field for the master cruise table used Center-wide.
100	DOE	DATE	The date of the last entry
100	DOC	DATE	The date of the last change to the table
100	UOE	VARCHAR2	Who made the last entry (identified by oracle username).
100	UOC	VARCHAR2	Who made the last change to the table (identified by their oracle username).
100	PURPOSE_CODE	NUMBER	The purpose of the cruise indicated by a 2-digit code for which there is a look-up table maintained by DMS.

Name

Type

Description

100

CRUISE_ID

VARCHAR2

Cruise name used to identify the survey or cruise (and as listed in /ftp/pub/hydro).

100

GEAR_DESC

VARCHAR2

Brief description of the instrument type used to collect hydrographic data on the cruise: bottle, XBT, SBE-19, SBE-911+, MK-5, MK-3 (various CTD types).

100

VESSEL

VARCHAR2

The 2-character abbreviation of the vessel used for each cruise. The look up table for the abbreviations is called sv_vessel and is located on SOLE.

100

YEAR

VARCHAR2

The year in which the cruise took place.

100

START_DATE

DATE

The start date for the first cast/station on the cruise.

100

END_DATE

DATE

The date of the last cast for which there are data on a cruise

100

OPSID

VARCHAR2

The linking field for the master cruise table used Center-wide.

100

DOE

DATE

The date of the last entry

100

DOC

DATE

The date of the last change to the table

100

UOE

VARCHAR2

Who made the last entry (identified by oracle username).

100

UOC

VARCHAR2

Who made the last change to the table (identified by their oracle username).

100

PURPOSE_CODE

NUMBER

The purpose of the cruise indicated by a 2-digit code for which there is a look-up table maintained by DMS.

Attribute Details

CRUISE_ID

CC ID: 332873

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	9
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Cruise name used to identify the survey or cruise (and as listed in /ftp/pub/hydro).
General Data Type:	VARCHAR2

GEAR_DESC

CC ID: 332877

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Brief description of the instrument type used to collect hydrographic data on the cruise: bottle, XBT, SBE-19, SBE-911+, MK-5, MK-3 (various CTD types).
General Data Type:	VARCHAR2

VESSEL

CC ID: 332878

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	The 2-character abbreviation of the vessel used for each cruise. The look up table for the abbreviations is called sv_vessel and is located on SOLE.
General Data Type:	VARCHAR2

YEAR

CC ID: 332879

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	Yes
Primary Key:	No
Status:	Active
Description:	The year in which the cruise took place.
General Data Type:	VARCHAR2

START_DATE

CC ID: 332880

Seq. Order:	5
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	The start date for the first cast/station on the cruise.
General Data Type:	DATE

END_DATE

CC ID: 332881

Seq. Order:	6
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	The date of the last cast for which there are data on a cruise
General Data Type:	DATE

OPSID

CC ID: 332882

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	11
Required:	Yes
Primary Key:	Yes
Status:	Active
Description:	The linking field for the master cruise table used Center-wide.
General Data Type:	VARCHAR2

DOE

CC ID: 332883

Seq. Order:	8
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	The date of the last entry
General Data Type:	DATE

DOC

CC ID: 332884

Seq. Order:	9
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	The date of the last change to the table
General Data Type:	DATE

UOE

CC ID: 332874

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	Who made the last entry (identified by oracle username).
General Data Type:	VARCHAR2

UOC

CC ID: 332875

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	Who made the last change to the table (identified by their oracle username).
General Data Type:	VARCHAR2

PURPOSE_CODE

CC ID: 332876

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Precision:	4
Scale:	0
Status:	Active
Description:	The purpose of the cruise indicated by a 2-digit code for which there is a look-up table maintained by DMS.
General Data Type:	NUMBER

Catalog Item ID:	33507
GUID:	gov.noaa.nmfs.inport:33507
Metadata Record Created By:	Patricia L Jones
Metadata Record Created:	2016-07-18 21:14+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2016-07-27
Owner Org:	NEFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2016-07-27
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2017-07-27

Table: HYDRO_CRUISE

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

CRUISE_ID

GEAR_DESC

VESSEL

YEAR

START_DATE

END_DATE

OPSID

DOE

DOC

UOE

UOC

PURPOSE_CODE

Catalog Details