Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Historical Datasets Metadata Portfolio > Historical Research Biological Metadata Portfol... > Tuna Larvae: Length vs. Frequencies collected b... >

RB003AA1_V

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:58291  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

.

Description

.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
DATASET_CODE
VARCHAR2 		Source ID Code assigned by the data entry staff.
VERSION_CODE
VARCHAR2 		Code for the format version assigned by the data entry staff.
VESSEL_CODE
VARCHAR2 		Code for the vessel.
CRUISE_NUMBER
VARCHAR2 		Incremental number of the cruise for the vessel.
YEAR
VARCHAR2 		Year of plankton tow.
MONTH
VARCHAR2 		Month of plankton tow.
DAY
VARCHAR2 		Day of plankton tow.
TIME
VARCHAR2 		Time of plankton tow.
OCTANT
VARCHAR2 		Octant of the globe. Used OCTANT to determine 1) Latitude Direction (N, S); 2) Longitude Direction (E, W); and 3) First digit of Longitude degrees (0, 1).
LATITUDE_DEGREES
VARCHAR2 		Latitude degrees, in degrees. Units for values are degrees.
LATITUDE_MINUTES
VARCHAR2 		Latitude minutes, in minutes. Units for values are minutes.
LATITUDE_DIRECTION
VARCHAR2 		Latitude direction, determined using OCTANT.
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.
LONGITUDE_DEGREES
VARCHAR2 		Longitude degrees, in degrees. During data entry, the first digit (0 or 1) was omitted. It was inserted into the data using OCTANT. Units for values are degrees.
LONGITUDE_MINUTES
VARCHAR2 		Longitude minutes, in minutes. Units for values are minutes.
LONGITUDE_DIRECTION
VARCHAR2 		Longitude direction, determined using OCTANT.
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.
STATION_NUMBER
VARCHAR2 		Station number of tow operation.
SAMPLE_NUMBER
VARCHAR2 		A consecutive number assigned to each sample collected from the station.
SPECIES_CODE
VARCHAR2 		Species code for Thunnus albacares and Katsuwonus pelamis.
STANDARD_LENGTH
VARCHAR2 		Standard length, in mm. During data entry, the decimal point was omitted ; it has been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 3.
SEQUENCE_NUMBER
VARCHAR2 		A consecutive number assigned to each record for a block of data.
DATE_LOADED
DATE 		Date when the record was loaded into Oracle or updated.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

Item Identification

Title: RB003AA1_V
Short Name: RB003AA1_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. Used 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. During data entry, the first digit (0 or 1) was omitted. It was inserted into the data using OCTANT. 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
 SPECIES_CODE VARCHAR2 Species code for Thunnus albacares and Katsuwonus pelamis.
100
 STANDARD_LENGTH VARCHAR2 Standard length, in mm. During data entry, the decimal point was omitted ; it has been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 3.
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: 888480
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: 888481
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: 888482
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: 004 = NOAA R/V HUGH M SMITH 005 = NOAA R/V JOHN R MANNING 007 = NOAA R/V CHARLES H GILBERT 019 = NOAA R/V SPENCER F BAIRD 027 = USS ENERGY

CRUISE_NUMBER

CC ID: 888483
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: 888484
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: 888485
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: 888486
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: 888487
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: 888488
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Octant of the globe. Used 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

LATITUDE_DEGREES

CC ID: 888489
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: 888490
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: 888491
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: 888492
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: 888493
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Longitude degrees, in degrees. During data entry, the first digit (0 or 1) was omitted. It was inserted into the data using OCTANT. Units for values are degrees.
General Data Type: VARCHAR2
Unit of Measure: degrees

LONGITUDE_MINUTES

CC ID: 888494
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: 888495
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: 888496
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: 888497
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: 888498
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

SPECIES_CODE

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

Species code for Thunnus albacares and Katsuwonus pelamis.
General Data Type: VARCHAR2
Allowed Values: 02 = THUNNUS ALBACARES 10 = KATSUWONUS PELAMIS

STANDARD_LENGTH

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

Standard length, in mm. During data entry, the decimal point was omitted ; it has been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 3.
General Data Type: VARCHAR2
Unit of Measure: millimeters

SEQUENCE_NUMBER

CC ID: 888501
Seq. Order: 22
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: 888502
Seq. Order: 23
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: 58291
GUID: gov.noaa.nmfs.inport:58291
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2019-12-06 19:18+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2019-12-06
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2019-12-06
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2020-12-06