Item Identification

Title: RB004AA1_V
Short Name: RB004AA1_V
Status: Completed
Abstract:

.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
DATASET_CODE VARCHAR2 Source ID Code assigned by the data entry staff.
100
VERSION_CODE VARCHAR2 Code for the format version assigned by the data entry staff.
100
VESSEL_CODE VARCHAR2 Code for the vessel.
100
CRUISE_NUMBER VARCHAR2 Incremental number of the cruise for the vessel.
100
STATION_NUMBER VARCHAR2 Station number of trawl operation.
100
YEAR VARCHAR2 Year of trawl.
100
MONTH VARCHAR2 Month of trawl.
100
DAY VARCHAR2 Day of trawl.
100
START_TIME VARCHAR2 Start time of trawl, in Hawaii Standard Time.
100
END_TIME VARCHAR2 End time of trawl, in Hawaii Standard Time.
100
OCTANT VARCHAR2 Octant of the globe. Use OCTANT to determine 1) Latitude Direction (N, S); 2) Longitude Direction (E, W); and 3) First digit of Longitude degrees (0, 1).
100
LATITUDE_DEGREES VARCHAR2 Start latitude, in tenths of a degree. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees. Measures are reported with a precision of 3.
100
LATITUDE_DIRECTION VARCHAR2 Start latitude direction, determined using OCTANT.
100
LATITUDE_DD NUMBER Computed start latitude, in decimal degrees, of the trawl station. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 3.
100
LONGITUDE_DEGREES VARCHAR2 Start longitude, in tenths of a degree. During data entry, the first digit (0 or 1) and the decimal point were omitted; both have been inserted into the data. Units for values are degrees. Measures are reported with a precision of 4.
100
LONGITUDE_DIRECTION VARCHAR2 Start longitude direction, determined using OCTANT.
100
LONGITUDE_DD NUMBER Computed start longitude, in decimal degrees, of the trawl station. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 4.
100
SHIP_SPEED VARCHAR2 Speed of ship, in tenths of a knot. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are knots. Measures are reported with a precision of 2.
100
NET_TYPE_CODE VARCHAR2 Code for the type of net used.
100
LENGTH_CABLE_OUT VARCHAR2 Length, in meters, that the cable was let out. Units for values are meters.
100
MINIMUM_DEPTH_TOW VARCHAR2 Minimum depth of tow, in meters. Units for values are meters.
100
TEMPERATURE_1 VARCHAR2 Temperature, in tenths of a degree Centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Centigrade. Measures are reported with a precision of 3.
100
MAXIMUM_DEPTH_TOW VARCHAR2 Maximum depth of tow, in meters. Units for values are meters.
100
TEMPERATURE_2 VARCHAR2 Temperature, in tenths of a degree Centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Centigrade. Measures are reported with a precision of 3.
100
BT_SLIDE_NUMBER VARCHAR2 Bt slide number.
100
SURFACE_TEMPERATURE VARCHAR2 Surface temperature, in tenths of a degree Centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Centigrade. Measures are reported with a precision of 3.
100
SURFACE_SALINITY VARCHAR2 Surface salinity, in parts per thousand. During data entry, the first digit (3) and the decimal point were omitted; both have been inserted into the data. Units for values are parts per thousand. Measures are reported with a precision of 4.
100
DEPTH_MIXED_LAYER VARCHAR2 Depth of the mixed layer, in meters. Units for values are meters.
100
DEPTH_25DEG_ISOTHERM VARCHAR2 Depth of the 25 degree Centigrade isotherm, in meters. Units for values are meters.
100
DEPTH_20DEG_ISOTHERM VARCHAR2 Depth of the 20 degree Centigrade isotherm, in meters. Units for values are meters.
100
MOON_AGE VARCHAR2 Number of days since the last new moon. Units for values are days.
100
LMT_SUNRISE VARCHAR2 Local Mean Time Sunrise.
100
LMT_SUNSET VARCHAR2 Local Mean Time Sunset.
100
SEQUENCE_NUMBER VARCHAR2 A consecutive number assigned to each record for a block of data.
100
DATE_LOADED DATE Date when the record was loaded into Oracle or updated.

Attribute Details

DATASET_CODE

CC ID: 886225
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Source ID Code assigned by the data entry staff.

General Data Type: VARCHAR2

VERSION_CODE

CC ID: 886226
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Code for the format version assigned by the data entry staff.

General Data Type: VARCHAR2

VESSEL_CODE

CC ID: 886227
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Code for the vessel.

General Data Type: VARCHAR2

CRUISE_NUMBER

CC ID: 886228
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Incremental number of the cruise for the vessel.

General Data Type: VARCHAR2

STATION_NUMBER

CC ID: 886229
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Station number of trawl operation.

General Data Type: VARCHAR2

YEAR

CC ID: 886230
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Year of trawl.

General Data Type: VARCHAR2

MONTH

CC ID: 886231
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Month of trawl.

General Data Type: VARCHAR2

DAY

CC ID: 886232
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Day of trawl.

General Data Type: VARCHAR2

START_TIME

CC ID: 886233
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Start time of trawl, in Hawaii Standard Time.

General Data Type: VARCHAR2

END_TIME

CC ID: 886234
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

End time of trawl, in Hawaii Standard Time.

General Data Type: VARCHAR2

OCTANT

CC ID: 886235
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Octant of the globe. Use OCTANT to determine 1) Latitude Direction (N, S); 2) Longitude Direction (E, W); and 3) First digit of Longitude degrees (0, 1).

General Data Type: VARCHAR2
Allowed Values: 1 = North Latitude; 90° West - 179° 59’ West Longitude

LATITUDE_DEGREES

CC ID: 886236
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Start latitude, in tenths of a degree. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees. Measures are reported with a precision of 3.

General Data Type: VARCHAR2
Unit of Measure: degrees

LATITUDE_DIRECTION

CC ID: 886237
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Start latitude direction, determined using OCTANT.

General Data Type: VARCHAR2
Allowed Values: N = North S = South

LATITUDE_DD

CC ID: 886238
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 4
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Computed start latitude, in decimal degrees, of the trawl station. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 3.

General Data Type: NUMBER
Unit of Measure: degrees

LONGITUDE_DEGREES

CC ID: 886239
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Start longitude, in tenths of a degree. During data entry, the first digit (0 or 1) and the decimal point were omitted; both have been inserted into the data. Units for values are degrees. Measures are reported with a precision of 4.

General Data Type: VARCHAR2
Unit of Measure: degrees

LONGITUDE_DIRECTION

CC ID: 886240
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Start longitude direction, determined using OCTANT.

General Data Type: VARCHAR2
Allowed Values: E = East W = West

LONGITUDE_DD

CC ID: 886241
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 6
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Computed start longitude, in decimal degrees, of the trawl station. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 4.

General Data Type: NUMBER
Unit of Measure: degrees

SHIP_SPEED

CC ID: 886242
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Speed of ship, in tenths of a knot. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are knots. Measures are reported with a precision of 2.

General Data Type: VARCHAR2
Unit of Measure: knots

NET_TYPE_CODE

CC ID: 886243
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Code for the type of net used.

General Data Type: VARCHAR2

LENGTH_CABLE_OUT

CC ID: 886244
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Length, in meters, that the cable was let out. Units for values are meters.

General Data Type: VARCHAR2
Unit of Measure: meters

MINIMUM_DEPTH_TOW

CC ID: 886245
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Minimum depth of tow, in meters. Units for values are meters.

General Data Type: VARCHAR2
Unit of Measure: meters

TEMPERATURE_1

CC ID: 886246
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Temperature, in tenths of a degree Centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Centigrade. Measures are reported with a precision of 3.

General Data Type: VARCHAR2
Unit of Measure: Centigrade

MAXIMUM_DEPTH_TOW

CC ID: 886247
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Maximum depth of tow, in meters. Units for values are meters.

General Data Type: VARCHAR2
Unit of Measure: meters

TEMPERATURE_2

CC ID: 886248
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Temperature, in tenths of a degree Centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Centigrade. Measures are reported with a precision of 3.

General Data Type: VARCHAR2
Unit of Measure: Centigrade

BT_SLIDE_NUMBER

CC ID: 886249
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Bt slide number.

General Data Type: VARCHAR2

SURFACE_TEMPERATURE

CC ID: 886250
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Surface temperature, in tenths of a degree Centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Centigrade. Measures are reported with a precision of 3.

General Data Type: VARCHAR2
Unit of Measure: Centigrade

SURFACE_SALINITY

CC ID: 886251
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Scale: 2
Status: Active
Description:

Surface salinity, in parts per thousand. During data entry, the first digit (3) and the decimal point were omitted; both have been inserted into the data. Units for values are parts per thousand. Measures are reported with a precision of 4.

General Data Type: VARCHAR2
Unit of Measure: parts per thousand

DEPTH_MIXED_LAYER

CC ID: 886252
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Depth of the mixed layer, in meters. Units for values are meters.

General Data Type: VARCHAR2
Unit of Measure: meters

DEPTH_25DEG_ISOTHERM

CC ID: 886253
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Depth of the 25 degree Centigrade isotherm, in meters. Units for values are meters.

General Data Type: VARCHAR2
Unit of Measure: meters

DEPTH_20DEG_ISOTHERM

CC ID: 886254
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Depth of the 20 degree Centigrade isotherm, in meters. Units for values are meters.

General Data Type: VARCHAR2
Unit of Measure: meters

MOON_AGE

CC ID: 886255
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Number of days since the last new moon. Units for values are days.

General Data Type: VARCHAR2
Unit of Measure: days

LMT_SUNRISE

CC ID: 886256
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Local Mean Time Sunrise.

General Data Type: VARCHAR2

LMT_SUNSET

CC ID: 886257
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Local Mean Time Sunset.

General Data Type: VARCHAR2

SEQUENCE_NUMBER

CC ID: 886258
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

A consecutive number assigned to each record for a block of data.

General Data Type: VARCHAR2

DATE_LOADED

CC ID: 886259
Seq. Order: 35
Data Storage Type: DATE
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Date when the record was loaded into Oracle or updated.

General Data Type: DATE

Catalog Details

Catalog Item ID: 58186
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2019-11-08 22:04+0000
Metadata Record Last Modified By: Brent M Miyamoto
Metadata Record Last Modified: 2019-12-11 17:05+0000
Metadata Record Published: 2019-11-15
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2020-11-15