Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Fisheries Research and Monitoring Divisio... > Life History Program > Larval Fish Identification from Cruises at Oahu... >

RB008AA1_V

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

Item Identification

Title:	RB008AA1_V
Short Name:	RB008AA1_V
Status:	Completed
Abstract:	Nekton and plankton composition log data collected around Oahu, Hawaii between September 1985 and June 1986.

Entity Information

Entity Type:	Data Table
Active Version?:	Yes
Description:	Nekton and plankton composition log data collected around Oahu, Hawaii between September 1985 and June 1986.

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	Last two digits of the year of the cruise and two digits incremental number of the cruise for the year.
100	TRAWL_YEAR	VARCHAR2	Year of the trawl operation.
100	TRAWL_MONTH	VARCHAR2	Month of the trawl operation.
100	TRAWL_DAY	VARCHAR2	Day of the trawl operation.
100	STATION_NUMBER	VARCHAR2	Station number of the trawl operation.
100	GEAR_CODE	VARCHAR2	Code for the type of trawl.
100	SAMPLE_CODE_1	VARCHAR2	Code for replicate.
100	SAMPLE_CODE_2	VARCHAR2	Code for net number.
100	SAMPLE_CODE_3	VARCHAR2	Code for sample number.
100	LOCATION_CODE_1	VARCHAR2	Code for the bank.
100	LOCATION_CODE_2	VARCHAR2	Code for the direction.
100	LOCATION_CODE_3	VARCHAR2	Code for the distance.
100	LOCATION_CODE_4	VARCHAR2	Code for the time.
100	START_TIME	VARCHAR2	Start time of the trawl operation.
100	END_TIME	VARCHAR2	End time of the trawl operation.
100	MINIMUM_DEPTH	VARCHAR2	Minimum depth, in meters. Units for values are meters.
100	MAXIMUM_DEPTH	VARCHAR2	Maximum depth, in meters. Units for values are meters.
100	WATER_VOLUME_FILTERED	VARCHAR2	Water volume filtered, in tenths of a cubic meter. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are cubic meters. Measures are reported with a precision of 5.
100	SAMPLE_VOLUME	VARCHAR2	Sample volume, in milliliters. Units for values are milliliters.
100	TOTAL_NUMBER_SPECIMENS	VARCHAR2	Total number of specimens in the sample.
100	ROW_NUMBER	VARCHAR2	A consecutive number for each entry on the data collection form.
100	SPECIES_CODE	VARCHAR2	Ten-digit CZM code for the species.
100	NUMBER_SPECIES	VARCHAR2	Number of species items in the sample.
100	JOB_NUMBER	VARCHAR2	A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D89443.
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

Last two digits of the year of the cruise and two digits incremental number of the cruise for the year.

100

TRAWL_YEAR

VARCHAR2

Year of the trawl operation.

100

TRAWL_MONTH

VARCHAR2

Month of the trawl operation.

100

TRAWL_DAY

VARCHAR2

Day of the trawl operation.

100

STATION_NUMBER

VARCHAR2

Station number of the trawl operation.

100

GEAR_CODE

VARCHAR2

Code for the type of trawl.

100

SAMPLE_CODE_1

VARCHAR2

Code for replicate.

100

SAMPLE_CODE_2

VARCHAR2

Code for net number.

100

SAMPLE_CODE_3

VARCHAR2

Code for sample number.

100

LOCATION_CODE_1

VARCHAR2

Code for the bank.

100

LOCATION_CODE_2

VARCHAR2

Code for the direction.

100

LOCATION_CODE_3

VARCHAR2

Code for the distance.

100

LOCATION_CODE_4

VARCHAR2

Code for the time.

100

START_TIME

VARCHAR2

Start time of the trawl operation.

100

END_TIME

VARCHAR2

End time of the trawl operation.

100

MINIMUM_DEPTH

VARCHAR2

Minimum depth, in meters. Units for values are meters.

100

MAXIMUM_DEPTH

VARCHAR2

Maximum depth, in meters. Units for values are meters.

100

WATER_VOLUME_FILTERED

VARCHAR2

Water volume filtered, in tenths of a cubic meter. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are cubic meters. Measures are reported with a precision of 5.

100

SAMPLE_VOLUME

VARCHAR2

Sample volume, in milliliters. Units for values are milliliters.

100

TOTAL_NUMBER_SPECIMENS

VARCHAR2

Total number of specimens in the sample.

100

ROW_NUMBER

VARCHAR2

A consecutive number for each entry on the data collection form.

100

SPECIES_CODE

VARCHAR2

Ten-digit CZM code for the species.

100

NUMBER_SPECIES

VARCHAR2

Number of species items in the sample.

100

JOB_NUMBER

VARCHAR2

A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D89443.

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

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

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

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

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Last two digits of the year of the cruise and two digits incremental number of the cruise for the year.
General Data Type:	VARCHAR2

TRAWL_YEAR

CC ID: 1256353

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Year of the trawl operation.
General Data Type:	VARCHAR2

TRAWL_MONTH

CC ID: 1256354

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Month of the trawl operation.
General Data Type:	VARCHAR2

TRAWL_DAY

CC ID: 1256355

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Day of the trawl operation.
General Data Type:	VARCHAR2

STATION_NUMBER

CC ID: 1256356

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Station number of the trawl operation.
General Data Type:	VARCHAR2

GEAR_CODE

CC ID: 1256357

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for the type of trawl.
General Data Type:	VARCHAR2
Allowed Values:	30 = MANTA NEUSTON NET; 50 = MOCNESS NET

SAMPLE_CODE_1

CC ID: 1256358

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for replicate.
General Data Type:	VARCHAR2
Allowed Values:	1; 2

SAMPLE_CODE_2

CC ID: 1256359

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for net number.
General Data Type:	VARCHAR2
Allowed Values:	0 = MANTA NEUSTON NET; 1 = MOCNESS NET 1; 2 = MOCNESS NET 2; 3 = MOCNESS NET 3; 4 = MOCNESS NET 4; 5 = MOCNESS NET 5; 6 = MOCNESS NET 6; 7 = MOCNESS NET 7; 8 = MOCNESS NET 8; 9 = MOCNESS NET 9

SAMPLE_CODE_3

CC ID: 1256360

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for sample number.
General Data Type:	VARCHAR2
Allowed Values:	1

LOCATION_CODE_1

CC ID: 1256361

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for the bank.
General Data Type:	VARCHAR2
Allowed Values:	1 = OAHU

LOCATION_CODE_2

CC ID: 1256362

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for the direction.
General Data Type:	VARCHAR2
Allowed Values:	3 = EAST (WINDWARD); 7 = WEST (LEEWARD)

LOCATION_CODE_3

CC ID: 1256363

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for the distance.
General Data Type:	VARCHAR2
Allowed Values:	1 = 1 OR 2 NAUTICAL MILES; 2 = 5 NAUTICAL MILES; 3 = 15 NAUTICAL MILES

LOCATION_CODE_4

CC ID: 1256364

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for the time.
General Data Type:	VARCHAR2
Allowed Values:	1 = DAY; 3 = NIGHT

START_TIME

CC ID: 1256365

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Start time of the trawl operation.
General Data Type:	VARCHAR2

END_TIME

CC ID: 1256366

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	End time of the trawl operation.
General Data Type:	VARCHAR2

MINIMUM_DEPTH

CC ID: 1256367

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Minimum depth, in meters. Units for values are meters.
General Data Type:	VARCHAR2
Unit of Measure:	meters

MAXIMUM_DEPTH

CC ID: 1256368

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Maximum depth, in meters. Units for values are meters.
General Data Type:	VARCHAR2
Unit of Measure:	meters

WATER_VOLUME_FILTERED

CC ID: 1256369

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Scale:	1
Status:	Active
Description:	Water volume filtered, in tenths of a cubic meter. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are cubic meters. Measures are reported with a precision of 5.
General Data Type:	VARCHAR2
Unit of Measure:	cubic meters

SAMPLE_VOLUME

CC ID: 1256370

Seq. Order:	22
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	Sample volume, in milliliters. Units for values are milliliters.
General Data Type:	VARCHAR2
Unit of Measure:	milliliters

TOTAL_NUMBER_SPECIMENS

CC ID: 1256371

Seq. Order:	23
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Total number of specimens in the sample.
General Data Type:	VARCHAR2

ROW_NUMBER

CC ID: 1256372

Seq. Order:	24
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	A consecutive number for each entry on the data collection form.
General Data Type:	VARCHAR2

SPECIES_CODE

CC ID: 1256373

Seq. Order:	25
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	Ten-digit CZM code for the species.
General Data Type:	VARCHAR2

NUMBER_SPECIES

CC ID: 1256374

Seq. Order:	26
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Number of species items in the sample.
General Data Type:	VARCHAR2

JOB_NUMBER

CC ID: 1256375

Seq. Order:	27
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D89443.
General Data Type:	VARCHAR2

SEQUENCE_NUMBER

CC ID: 1256376

Seq. Order:	28
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: 1256377

Seq. Order:	29
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

Support Roles

Point of Contact

CC ID: 1268702

Date Effective From:	2023-08
Date Effective To:
Contact (Person):	Schemmel, Eva M
Email Address:	eva.schemmel@noaa.gov
Contact Instructions:	Contact via email.

Catalog Details

Catalog Item ID:	56552
GUID:	gov.noaa.nmfs.inport:56552
Metadata Record Created By:	Brent M Miyamoto
Metadata Record Created:	2019-05-30 15:24+0000
Metadata Record Last Modified By:	Brent M Miyamoto
Metadata Record Last Modified:	2023-08-25 21:58+0000
Metadata Record Published:	2023-06-14
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2023-06-13
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2024-06-13