Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Data Management Systems (DMS) > Benthic Habitat Database >

Table: BENCRUISE

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Benthic Cruise Master Table

Description

Benthic Cruise Master Table

Entity Type
Data Table

Data Attribute / Type	Description
CRUISE_ID VARCHAR2	Cruise ID formatted as 4 digit year, 2 character vessel code, and 2 character cruise number. This id was created from the original Woods Hole and Sandy Hook benthic codes for vessel and cruise.
PURPOSE_CODE VARCHAR2	Code referencing purpose of cruise conducted. See table SVDBS.SVCRUISE_PURPOSE for list of purpose codes.
VESSEL VARCHAR2	Two character field coding vessel name. Code assigned to vessel is in the NFMS master vessel table.
YEAR VARCHAR2	Year in which cruise was conducted.
START_DATE DATE	The date the vessel left the dock for the current cruise. Date format (DD-MON-YYYY).
END_DATE DATE	The date the vessel returned to port. Date format (DD-MON-YYYY).
OPSID VARCHAR2	Operation ID. Formatted as 4-digit year, 3 digit vessel cruise number, 4-character vessel code.
DATA_SOURCE VARCHAR2	Laboratory where sampling program was directed and data processed. (SH=Sandy Hook, WH=Woods Hole)
VESSEL_NUM VARCHAR2	The nth consecutive number of a cruise on the given vessel.
AREA_INVESTIGATION VARCHAR2	Brief description of the physical area of investigation of the cruise.
CHIEF_SCIENTIST VARCHAR2	Chief scientist for the cruise.
SCIENTIFIC_PARTY VARCHAR2	List of names of participants on the cruise. List of names were taken from the sailing orders, not the actual cruise results.
PURPOSE_DESC VARCHAR2	Brief description of the purpose for the cruise.
CRUISE_COMMENTS VARCHAR2	Comments at the cruise level, ie: notes about any discrepancies with the cruise data, absence of station or catch records, etc.
DOE DATE	Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).
UOE VARCHAR2	The Oracle username of the individual who entered the new record.
DOC DATE	Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).
UOC VARCHAR2	The Oracle username of the individual who changed the current record.

Data Attribute / Type

Description

CRUISE_ID
VARCHAR2

Cruise ID formatted as 4 digit year, 2 character vessel code, and 2 character cruise number. This id was created from the original Woods Hole and Sandy Hook benthic codes for vessel and cruise.

PURPOSE_CODE
VARCHAR2

Code referencing purpose of cruise conducted. See table SVDBS.SVCRUISE_PURPOSE for list of purpose codes.

VESSEL
VARCHAR2

Two character field coding vessel name. Code assigned to vessel is in the NFMS master vessel table.

YEAR
VARCHAR2

Year in which cruise was conducted.

START_DATE
DATE

The date the vessel left the dock for the current cruise. Date format (DD-MON-YYYY).

END_DATE
DATE

The date the vessel returned to port. Date format (DD-MON-YYYY).

OPSID
VARCHAR2

Operation ID. Formatted as 4-digit year, 3 digit vessel cruise number, 4-character vessel code.

DATA_SOURCE
VARCHAR2

Laboratory where sampling program was directed and data processed. (SH=Sandy Hook, WH=Woods Hole)

VESSEL_NUM
VARCHAR2

The nth consecutive number of a cruise on the given vessel.

AREA_INVESTIGATION
VARCHAR2

Brief description of the physical area of investigation of the cruise.

CHIEF_SCIENTIST
VARCHAR2

Chief scientist for the cruise.

SCIENTIFIC_PARTY
VARCHAR2

List of names of participants on the cruise. List of names were taken from the sailing orders, not the actual cruise results.

PURPOSE_DESC
VARCHAR2

Brief description of the purpose for the cruise.

CRUISE_COMMENTS
VARCHAR2

Comments at the cruise level, ie: notes about any discrepancies with the cruise data, absence of station or catch records, etc.

DOE
DATE

Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).

UOE
VARCHAR2

The Oracle username of the individual who entered the new record.

DOC
DATE

Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).

UOC
VARCHAR2

The Oracle username of the individual who changed the current record.

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: BENCRUISE
Short Name:	BENCRUISE
Status:	Completed
Abstract:	Benthic Cruise Master Table
Notes:	Loaded by batch 8254, 03-08-2016 15:45

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	BENTHIC
Description:	Benthic Cruise Master Table

Attribute Summary

	Name	Type	Description
100	CRUISE_ID	VARCHAR2	Cruise ID formatted as 4 digit year, 2 character vessel code, and 2 character cruise number. This id was created from the original Woods Hole and Sandy Hook benthic codes for vessel and cruise.
100	PURPOSE_CODE	VARCHAR2	Code referencing purpose of cruise conducted. See table SVDBS.SVCRUISE_PURPOSE for list of purpose codes.
100	VESSEL	VARCHAR2	Two character field coding vessel name. Code assigned to vessel is in the NFMS master vessel table.
100	YEAR	VARCHAR2	Year in which cruise was conducted.
100	START_DATE	DATE	The date the vessel left the dock for the current cruise. Date format (DD-MON-YYYY).
100	END_DATE	DATE	The date the vessel returned to port. Date format (DD-MON-YYYY).
100	OPSID	VARCHAR2	Operation ID. Formatted as 4-digit year, 3 digit vessel cruise number, 4-character vessel code.
100	DATA_SOURCE	VARCHAR2	Laboratory where sampling program was directed and data processed. (SH=Sandy Hook, WH=Woods Hole)
100	VESSEL_NUM	VARCHAR2	The nth consecutive number of a cruise on the given vessel.
100	AREA_INVESTIGATION	VARCHAR2	Brief description of the physical area of investigation of the cruise.
100	CHIEF_SCIENTIST	VARCHAR2	Chief scientist for the cruise.
100	SCIENTIFIC_PARTY	VARCHAR2	List of names of participants on the cruise. List of names were taken from the sailing orders, not the actual cruise results.
100	PURPOSE_DESC	VARCHAR2	Brief description of the purpose for the cruise.
100	CRUISE_COMMENTS	VARCHAR2	Comments at the cruise level, ie: notes about any discrepancies with the cruise data, absence of station or catch records, etc.
100	DOE	DATE	Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).
100	UOE	VARCHAR2	The Oracle username of the individual who entered the new record.
100	DOC	DATE	Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).
100	UOC	VARCHAR2	The Oracle username of the individual who changed the current record.

Name

Type

Description

100

CRUISE_ID

VARCHAR2

Cruise ID formatted as 4 digit year, 2 character vessel code, and 2 character cruise number. This id was created from the original Woods Hole and Sandy Hook benthic codes for vessel and cruise.

100

PURPOSE_CODE

VARCHAR2

Code referencing purpose of cruise conducted. See table SVDBS.SVCRUISE_PURPOSE for list of purpose codes.

100

VESSEL

VARCHAR2

Two character field coding vessel name. Code assigned to vessel is in the NFMS master vessel table.

100

YEAR

VARCHAR2

Year in which cruise was conducted.

100

START_DATE

DATE

The date the vessel left the dock for the current cruise. Date format (DD-MON-YYYY).

100

END_DATE

DATE

The date the vessel returned to port. Date format (DD-MON-YYYY).

100

OPSID

VARCHAR2

Operation ID. Formatted as 4-digit year, 3 digit vessel cruise number, 4-character vessel code.

100

DATA_SOURCE

VARCHAR2

Laboratory where sampling program was directed and data processed. (SH=Sandy Hook, WH=Woods Hole)

100

VESSEL_NUM

VARCHAR2

The nth consecutive number of a cruise on the given vessel.

100

AREA_INVESTIGATION

VARCHAR2

Brief description of the physical area of investigation of the cruise.

100

CHIEF_SCIENTIST

VARCHAR2

Chief scientist for the cruise.

100

SCIENTIFIC_PARTY

VARCHAR2

List of names of participants on the cruise. List of names were taken from the sailing orders, not the actual cruise results.

100

PURPOSE_DESC

VARCHAR2

Brief description of the purpose for the cruise.

100

CRUISE_COMMENTS

VARCHAR2

Comments at the cruise level, ie: notes about any discrepancies with the cruise data, absence of station or catch records, etc.

100

DOE

DATE

Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).

100

UOE

VARCHAR2

The Oracle username of the individual who entered the new record.

100

DOC

DATE

Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).

100

UOC

VARCHAR2

The Oracle username of the individual who changed the current record.

Attribute Details

CRUISE_ID

CC ID: 301519

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Cruise ID formatted as 4 digit year, 2 character vessel code, and 2 character cruise number. This id was created from the original Woods Hole and Sandy Hook benthic codes for vessel and cruise.
General Data Type:	VARCHAR2

PURPOSE_CODE

CC ID: 301529

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Code referencing purpose of cruise conducted. See table SVDBS.SVCRUISE_PURPOSE for list of purpose codes.
General Data Type:	VARCHAR2

VESSEL

CC ID: 301530

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Two character field coding vessel name. Code assigned to vessel is in the NFMS master vessel table.
General Data Type:	VARCHAR2

YEAR

CC ID: 301531

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Year in which cruise was conducted.
General Data Type:	VARCHAR2

START_DATE

CC ID: 301532

Seq. Order:	5
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	The date the vessel left the dock for the current cruise. Date format (DD-MON-YYYY).
General Data Type:	DATE

END_DATE

CC ID: 301533

Seq. Order:	6
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	The date the vessel returned to port. Date format (DD-MON-YYYY).
General Data Type:	DATE

OPSID

CC ID: 301534

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	11
Required:	No
Primary Key:	No
Status:	Active
Description:	Operation ID. Formatted as 4-digit year, 3 digit vessel cruise number, 4-character vessel code.
General Data Type:	VARCHAR2

DATA_SOURCE

CC ID: 301535

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Laboratory where sampling program was directed and data processed. (SH=Sandy Hook, WH=Woods Hole)
General Data Type:	VARCHAR2

VESSEL_NUM

CC ID: 301536

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	The nth consecutive number of a cruise on the given vessel.
General Data Type:	VARCHAR2

AREA_INVESTIGATION

CC ID: 301520

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	200
Required:	No
Primary Key:	No
Status:	Active
Description:	Brief description of the physical area of investigation of the cruise.
General Data Type:	VARCHAR2

CHIEF_SCIENTIST

CC ID: 301521

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	150
Required:	No
Primary Key:	No
Status:	Active
Description:	Chief scientist for the cruise.
General Data Type:	VARCHAR2

SCIENTIFIC_PARTY

CC ID: 301522

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	1000
Required:	No
Primary Key:	No
Status:	Active
Description:	List of names of participants on the cruise. List of names were taken from the sailing orders, not the actual cruise results.
General Data Type:	VARCHAR2

PURPOSE_DESC

CC ID: 301523

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	150
Required:	No
Primary Key:	No
Status:	Active
Description:	Brief description of the purpose for the cruise.
General Data Type:	VARCHAR2

CRUISE_COMMENTS

CC ID: 301524

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	500
Required:	No
Primary Key:	No
Status:	Active
Description:	Comments at the cruise level, ie: notes about any discrepancies with the cruise data, absence of station or catch records, etc.
General Data Type:	VARCHAR2

DOE

CC ID: 301525

Seq. Order:	15
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).
General Data Type:	DATE

UOE

CC ID: 301526

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	The Oracle username of the individual who entered the new record.
General Data Type:	VARCHAR2

DOC

CC ID: 301527

Seq. Order:	17
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).
General Data Type:	DATE

UOC

CC ID: 301528

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	The Oracle username of the individual who changed the current record.
General Data Type:	VARCHAR2

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

Table: BENCRUISE

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

CRUISE_ID

PURPOSE_CODE

VESSEL

YEAR

START_DATE

END_DATE

OPSID

DATA_SOURCE

VESSEL_NUM

AREA_INVESTIGATION

CHIEF_SCIENTIST

SCIENTIFIC_PARTY

PURPOSE_DESC

CRUISE_COMMENTS

DOE

UOE

DOC

UOC

Catalog Details