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

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
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
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2019-12-11 18:03+0000
Metadata Record Last Modified By: Brent M Miyamoto
Metadata Record Last Modified: 2019-12-11 19:54+0000
Metadata Record Published: 2019-12-11
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2020-12-11