Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Historical Datasets Metadata Portfolio > Historical Research Biological Metadata Portfol... > Juvenile Tuna Lengths collected during NOAA R/V... >

RB005AA1_V

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:58307 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Description

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.
SPECIES_CODE VARCHAR2	Two-digit species code.
STANDARD_LENGTH VARCHAR2	Standard length, in tenths of a millimeter. 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 4.
FORK_LENGTH VARCHAR2	Fork length, in tents of a millimeter. 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 4.
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.

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.

SPECIES_CODE
VARCHAR2

Two-digit species code.

STANDARD_LENGTH
VARCHAR2

Standard length, in tenths of a millimeter. 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 4.

FORK_LENGTH
VARCHAR2

Fork length, in tents of a millimeter. 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 4.

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.

No Child Items for this record.

No contact information is available for this record.

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

Title:	RB005AA1_V
Short Name:	RB005AA1_V
Status:	Completed
Abstract:	.

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

Attribute Summary

	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	SPECIES_CODE	VARCHAR2	Two-digit species code.
100	STANDARD_LENGTH	VARCHAR2	Standard length, in tenths of a millimeter. 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 4.
100	FORK_LENGTH	VARCHAR2	Fork length, in tents of a millimeter. 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 4.
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.

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

100

LATITUDE_DIRECTION

VARCHAR2

Imported from RB004AA1 - Start latitude direction, determined using OCTANT.

100

LATITUDE_DD

NUMBER

100

LONGITUDE_DEGREES

VARCHAR2

100

LONGITUDE_DIRECTION

VARCHAR2

Imported from dataset RB004AA1 - Start longitude direction, determined using OCTANT.

100

LONGITUDE_DD

NUMBER

100

SPECIES_CODE

VARCHAR2

Two-digit species code.

100

STANDARD_LENGTH

VARCHAR2

100

FORK_LENGTH

VARCHAR2

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: 889102

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: 889103

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: 889104

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: 889105

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: 889106

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: 889107

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: 889108

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: 889109

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: 889110

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: 889111

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: 889112

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: 889113

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: 889114

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: 889115

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: 889116

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: 889117

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: 889118

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: 889119

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

SPECIES_CODE

CC ID: 889120

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Two-digit species code.
General Data Type:	VARCHAR2
Allowed Values:	32 = KATSUWONUS PELAMIS - SKIPJACK TUNA 33 = EUTHYNNUS SPP. - LITTLE TUNNY 34 = THUNNUS OBESUS - BIGEYE TUNA 35 - THUNNUS ALBACARES - YELLOWFIN TUNA 36 - THUNNUS ALALUNGA - ALBACORE 41 - AUXIS SPP. - FRIGATE MACKEREL 44 - ACANTHOCYBIUM SOLANDRI - WAHOO. ONO

STANDARD_LENGTH

CC ID: 889121

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Scale:	1
Status:	Active
Description:	Standard length, in tenths of a millimeter. 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 4.
General Data Type:	VARCHAR2
Unit of Measure:	millimeters

FORK_LENGTH

CC ID: 889122

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Scale:	1
Status:	Active
Description:	Fork length, in tents of a millimeter. 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 4.
General Data Type:	VARCHAR2
Unit of Measure:	millimeters

SEQUENCE_NUMBER

CC ID: 889123

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: 889124

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

RB005AA1_V

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

DATASET_CODE

VERSION_CODE

VESSEL_CODE

CRUISE_NUMBER

STATION_NUMBER

SAMPLE_NUMBER

YEAR

MONTH

DAY

START_TIME

END_TIME

OCTANT

LATITUDE_DEGREES

LATITUDE_DIRECTION

LATITUDE_DD

LONGITUDE_DEGREES

LONGITUDE_DIRECTION

LONGITUDE_DD

SPECIES_CODE

STANDARD_LENGTH

FORK_LENGTH

SEQUENCE_NUMBER

DATE_LOADED

Catalog Details