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... > Juvenile Tuna Numbers collected during NOAA R/V... >

RB005AA2_V

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:58335  |  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.
STATION_NUMBER
VARCHAR2 		Station number of trawl operation.
SAMPLE_NUMBER
VARCHAR2 		Sample number of the station.
YEAR
VARCHAR2 		Imported from RB004AA1 - Year of trawl.
MONTH
VARCHAR2 		Imported from RB004AA1 - Month of trawl.
DAY
VARCHAR2 		Imported from RB004AA1 - Day of trawl.
START_TIME
VARCHAR2 		Imported from RB004AA1 - Start time of trawl, in Hawaii Standard Time.
END_TIME
VARCHAR2 		Imported from RB004AA1 - End time of trawl, in Hawaii Standard Time.
OCTANT
VARCHAR2 		Imported from RB004AA1 - 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 		Imported from RB004AA1 - Start latitude, in tenths of a degree. During data entry, the decimal point was omitted; it has been Iinserted into the data. Units for values are degrees. Measures are reported with a precision of 3.
LATITUDE_DIRECTION
VARCHAR2 		Imported from RB004AA1 - Start latitude direction, determined using OCTANT.
LATITUDE_DD
NUMBER 		Imported from RB004AA1 - 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.
LONGITUDE_DEGREES
VARCHAR2 		Imported from RB004AA1 - 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.
LONGITUDE_DIRECTION
VARCHAR2 		Imported from dataset RB004AA1 - Start longitude direction, determined using OCTANT.
LONGITUDE_DD
NUMBER 		Imported from dataset RB004AA1 - 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.
NUMBER_K_PELAMIS
VARCHAR2 		Number of Katsuwonus pelamis.
NUMBER_T_ALBACARES
VARCHAR2 		Number of Thunnus albacares.
NUMBER_T_OBESUS
VARCHAR2 		Number of Thunnus obsesus.
NUMBER_T_ALALUNGA
VARCHAR2 		Number of Thunnus alalunga.
NUMBER_E_AFFINIS
VARCHAR2 		Number of Euthynnus affinis.
NUMBER_AUXIS_SP
VARCHAR2 		Number of Auxis species.
NUMBER_A_SOLANDRI
VARCHAR2 		Number of Acanthocybium solandri.
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: RB005AA2_V
Short Name: RB005AA2_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
 SAMPLE_NUMBER VARCHAR2 Sample number of the station.
100
 YEAR VARCHAR2 Imported from RB004AA1 - Year of trawl.
100
 MONTH VARCHAR2 Imported from RB004AA1 - Month of trawl.
100
 DAY VARCHAR2 Imported from RB004AA1 - Day of trawl.
100
 START_TIME VARCHAR2 Imported from RB004AA1 - Start time of trawl, in Hawaii Standard Time.
100
 END_TIME VARCHAR2 Imported from RB004AA1 - End time of trawl, in Hawaii Standard Time.
100
 OCTANT VARCHAR2 Imported from RB004AA1 - 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 Imported from RB004AA1 - Start latitude, in tenths of a degree. During data entry, the decimal point was omitted; it has been Iinserted into the data. Units for values are degrees. Measures are reported with a precision of 3.
100
 LATITUDE_DIRECTION VARCHAR2 Imported from RB004AA1 - Start latitude direction, determined using OCTANT.
100
 LATITUDE_DD NUMBER Imported from RB004AA1 - 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 Imported from RB004AA1 - 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 Imported from dataset RB004AA1 - Start longitude direction, determined using OCTANT.
100
 LONGITUDE_DD NUMBER Imported from dataset RB004AA1 - 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
 NUMBER_K_PELAMIS VARCHAR2 Number of Katsuwonus pelamis.
100
 NUMBER_T_ALBACARES VARCHAR2 Number of Thunnus albacares.
100
 NUMBER_T_OBESUS VARCHAR2 Number of Thunnus obsesus.
100
 NUMBER_T_ALALUNGA VARCHAR2 Number of Thunnus alalunga.
100
 NUMBER_E_AFFINIS VARCHAR2 Number of Euthynnus affinis.
100
 NUMBER_AUXIS_SP VARCHAR2 Number of Auxis species.
100
 NUMBER_A_SOLANDRI VARCHAR2 Number of Acanthocybium solandri.
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: 889355
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: 889356
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: 889357
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: 001 = NOAA R/V TOWNSEND CROMWELL

CRUISE_NUMBER

CC ID: 889358
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: 889359
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

SAMPLE_NUMBER

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

Sample number of the station.
General Data Type: VARCHAR2

YEAR

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

Imported from RB004AA1 - Year of trawl.
General Data Type: VARCHAR2

MONTH

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

Imported from RB004AA1 - Month of trawl.
General Data Type: VARCHAR2

DAY

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

Imported from RB004AA1 - Day of trawl.
General Data Type: VARCHAR2

START_TIME

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

Imported from RB004AA1 - Start time of trawl, in Hawaii Standard Time.
General Data Type: VARCHAR2

END_TIME

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

Imported from RB004AA1 - End time of trawl, in Hawaii Standard Time.
General Data Type: VARCHAR2

OCTANT

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

Imported from RB004AA1 - 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
Allowed Values: 1 = North Latitude; 90° West - 179° 59’ West Longitude

LATITUDE_DEGREES

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

Imported from RB004AA1 - Start latitude, in tenths of a degree. During data entry, the decimal point was omitted; it has been Iinserted 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: 889368
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Imported from RB004AA1 - Start latitude direction, determined using OCTANT.
General Data Type: VARCHAR2
Allowed Values: N = NORTH

LATITUDE_DD

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

Imported from RB004AA1 - 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: 889370
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Imported from RB004AA1 - 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: 889371
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Imported from dataset RB004AA1 - Start longitude direction, determined using OCTANT.
General Data Type: VARCHAR2
Allowed Values: W = WEST

LONGITUDE_DD

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

Imported from dataset RB004AA1 - 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

NUMBER_K_PELAMIS

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

Number of Katsuwonus pelamis.
General Data Type: VARCHAR2

NUMBER_T_ALBACARES

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

Number of Thunnus albacares.
General Data Type: VARCHAR2

NUMBER_T_OBESUS

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

Number of Thunnus obsesus.
General Data Type: VARCHAR2

NUMBER_T_ALALUNGA

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

Number of Thunnus alalunga.
General Data Type: VARCHAR2

NUMBER_E_AFFINIS

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

Number of Euthynnus affinis.
General Data Type: VARCHAR2

NUMBER_AUXIS_SP

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

Number of Auxis species.
General Data Type: VARCHAR2

NUMBER_A_SOLANDRI

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

Number of Acanthocybium solandri.
General Data Type: VARCHAR2

SEQUENCE_NUMBER

CC ID: 889380
Seq. Order: 26
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: 889382
Seq. Order: 28
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: 58335
GUID: gov.noaa.nmfs.inport:58335
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2019-12-16 15:42+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2019-12-16
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2019-12-16
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2020-12-16