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

Item Identification

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

Entity Information

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

Data Attributes

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

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.

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 Details

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