Table: BENCRUISE
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:31070 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Benthic Cruise Master Table
DescriptionBenthic Cruise Master Table
Entity Information
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. |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (NEFSC) for inquiries on this record.
Item Identification
Title: | Table: BENCRUISE |
---|---|
Short Name: | BENCRUISE |
Status: | Completed |
Abstract: |
Benthic Cruise Master Table |
Notes: |
Loaded by batch 8254, 03-08-2016 15:45 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | BENTHIC |
Description: |
Benthic Cruise Master Table |
Data Attributes
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. |
Attribute Details
CRUISE_ID
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 Details
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 |