Table: HYDRO_CRUISE
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33507 | Updated: August 9, 2022 | Published / External
Item Identification
| 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 Information
| 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. |
Data Attributes
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. |
Attribute Details
CRUISE_ID
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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 Details
| 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 |