Item Identification

Title: RB002AA1_V
Short Name: RB002AA1_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
YEAR VARCHAR2 Year of plankton tow.
100
MONTH VARCHAR2 Month of plankton tow.
100
DAY VARCHAR2 Day of plankton tow.
100
TIME VARCHAR2 Time of plankton tow.
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 Latitude degrees, in degrees. Units for values are degrees.
100
LATITUDE_MINUTES VARCHAR2 Latitude minutes, in minutes. Units for values are minutes.
100
LATITUDE_DIRECTION VARCHAR2 Latitude direction, determined using OCTANT.
100
LATITUDE_DD NUMBER Computed latitude, in decimal degrees, of the plankton tow station. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.
100
LONGITUDE_DEGREES VARCHAR2 Longitude degrees, in degrees. Units for values are degrees.
100
LONGITUDE_MINUTES VARCHAR2 Longitude minutes, in minutes. Units for values are minutes.
100
LONGITUDE_DIRECTION VARCHAR2 Longitude direction, determined using OCTANT.
100
LONGITUDE_DD NUMBER Computed longitude, in decimal degrees, of the plankton tow station. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
100
STATION_NUMBER VARCHAR2 Station number of tow operation.
100
SAMPLE_NUMBER VARCHAR2 A consecutive number assigned to each sample collected from the station.
100
MINIMUM_TOW_DEPTH VARCHAR2 Minimum depth of tow, in meters. Units for values are meters.
100
MAXIMUM_TOW_DEPTH VARCHAR2 Maximum depth of tow, in meters. Units for values are meters.
100
TYPE_OF_TOW_NET_CODE VARCHAR2 Code for the type of tow.
100
WATER_STRAINED VARCHAR2 Volume of water strained, in cubic meters. Units for values are cubic meters.
100
SURFACE_TERMPERATURE VARCHAR2 Surface temperature, in tenths of Centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are 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
TOTAL_TUNA_LARVAE VARCHAR2 Total number of tuna larvae.
100
K_PELAMIS VARCHAR2 Number of larvae - Katsuwonus pelamis.
100
T_ALBACARES VARCHAR2 Number of larvae - Thunnus albacares.
100
T_OBESUS VARCHAR2 Number of larvae - Thunnus obesus.
100
T_ALALUNGA VARCHAR2 Number of larvae - Thunnus alalunga.
100
E_AFFINIS VARCHAR2 Number of larvae - Euthynnus affinis.
100
AUXIS_SP VARCHAR2 Number of larvae - Auxis sp.
100
UNIDENTIFIED VARCHAR2 Number of larvae - Unidentified.
100
EUTHYNNUS_LINEATUS VARCHAR2 Number of larvae - Euthynnus lineatus.
100
MISC_CODE VARCHAR2 Miscellaneous codes.
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: 887644
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: 887645
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: 887646
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
Allowed Values: 003 = M/V Makua (Charter) 004 = R/V Hugh M Smith 005 = R/V John R Manning 007 = R/V Charles H Gilbert 027 = USS Energy NULL = data provided by IATTC

CRUISE_NUMBER

CC ID: 887647
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

YEAR

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

Year of plankton tow.

General Data Type: VARCHAR2

MONTH

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

Month of plankton tow.

General Data Type: VARCHAR2

DAY

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

Day of plankton tow.

General Data Type: VARCHAR2

TIME

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

Time of plankton tow.

General Data Type: VARCHAR2

OCTANT

CC ID: 887652
Seq. Order: 9
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: 0 = North Latitude; 00° West - 89° 59’ West Longitude 1 = North Latitude; 90° West - 179° 59’ West Longitude 2 = North Latitude; 180° - 90° 01’ East Longitude 3 = North Latitude; 90° East - 00° 01’ East Longitude 5 = South Latitude; 00° West - 89° 59’ West Longitude 6 = South Latitude; 90° West - 179° 59’W Longitude 7 = South Latitude; 180° - 90° 01’ East Longitude 8 = South Latitude; 90° East - 00° 01’ East Longitude

LATITUDE_DEGREES

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

Latitude degrees, in degrees. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

LATITUDE_MINUTES

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

Latitude minutes, in minutes. Units for values are minutes.

General Data Type: VARCHAR2
Unit of Measure: minutes

LATITUDE_DIRECTION

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

Latitude direction, determined using OCTANT.

General Data Type: VARCHAR2
Allowed Values: N = NORTH S = SOUTH

LATITUDE_DD

CC ID: 887656
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 42
Required: No
Primary Key: No
Scale: 38
Status: Active
Description:

Computed latitude, in decimal degrees, of the plankton tow station. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.

General Data Type: NUMBER
Unit of Measure: degrees

LONGITUDE_DEGREES

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

Longitude degrees, in degrees. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

LONGITUDE_MINUTES

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

Longitude minutes, in minutes. Units for values are minutes.

General Data Type: VARCHAR2
Unit of Measure: minutes

LONGITUDE_DIRECTION

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

Longitude direction, determined using OCTANT.

General Data Type: VARCHAR2
Allowed Values: E = EAST W = WEST

LONGITUDE_DD

CC ID: 887660
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 41
Required: No
Primary Key: No
Scale: 36
Status: Active
Description:

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

General Data Type: NUMBER
Unit of Measure: degrees

STATION_NUMBER

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

Station number of tow operation.

General Data Type: VARCHAR2

SAMPLE_NUMBER

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

A consecutive number assigned to each sample collected from the station.

General Data Type: VARCHAR2

MINIMUM_TOW_DEPTH

CC ID: 887663
Seq. Order: 20
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

MAXIMUM_TOW_DEPTH

CC ID: 887664
Seq. Order: 21
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

TYPE_OF_TOW_NET_CODE

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

Code for the type of tow.

General Data Type: VARCHAR2
Allowed Values: 0 = Open, horizontal, single net 1 = Open, horizontal, paired net 2 = Open, horizontal, multiple net 3 = Open, oblique, single net 4 = Open, oblique, multiple net 5 = Open, special 6 - Closing, horizontal, multiple net 7 = Closing, oblique, multiple net 8 = Closing, special

WATER_STRAINED

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

Volume of water strained, in cubic meters. Units for values are cubic meters.

General Data Type: VARCHAR2
Unit of Measure: cubic meters

SURFACE_TERMPERATURE

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

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

General Data Type: VARCHAR2
Unit of Measure: Centigrade

SURFACE_SALINITY

CC ID: 887668
Seq. Order: 25
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

TOTAL_TUNA_LARVAE

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

Total number of tuna larvae.

General Data Type: VARCHAR2

K_PELAMIS

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

Number of larvae - Katsuwonus pelamis.

General Data Type: VARCHAR2

T_ALBACARES

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

Number of larvae - Thunnus albacares.

General Data Type: VARCHAR2

T_OBESUS

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

Number of larvae - Thunnus obesus.

General Data Type: VARCHAR2

T_ALALUNGA

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

Number of larvae - Thunnus alalunga.

General Data Type: VARCHAR2

E_AFFINIS

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

Number of larvae - Euthynnus affinis.

General Data Type: VARCHAR2

AUXIS_SP

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

Number of larvae - Auxis sp.

General Data Type: VARCHAR2

UNIDENTIFIED

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

Number of larvae - Unidentified.

General Data Type: VARCHAR2

EUTHYNNUS_LINEATUS

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

Number of larvae - Euthynnus lineatus.

General Data Type: VARCHAR2

MISC_CODE

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

Miscellaneous codes.

General Data Type: VARCHAR2
Allowed Values: 1 = Hawaii and Norpac 2 = IGY (International Geophysical Year) 6 = S 7 = O 8 = H 9 = F

SEQUENCE_NUMBER

CC ID: 887679
Seq. Order: 36
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: 887680
Seq. Order: 37
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: 58260
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2019-11-26 22:02+0000
Metadata Record Last Modified By: Brent M Miyamoto
Metadata Record Last Modified: 2019-11-27 12:58+0000
Metadata Record Published: 2019-11-27
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2020-11-27