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

Summary

Item Identification

Entity Info

Data Attributes

Support Roles

Catalog Details

Abstract

Nekton and plankton composition log data collected around Oahu, Hawaii between September 1985 and June 1986.

Description

Nekton and plankton composition log data collected around Oahu, Hawaii between September 1985 and June 1986.

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	Last two digits of the year of the cruise and two digits incremental number of the cruise for the year.
TRAWL_YEAR VARCHAR2	Year of the trawl operation.
TRAWL_MONTH VARCHAR2	Month of the trawl operation.
TRAWL_DAY VARCHAR2	Day of the trawl operation.
STATION_NUMBER VARCHAR2	Station number of the trawl operation.
GEAR_CODE VARCHAR2	Code for the type of trawl.
SAMPLE_CODE_1 VARCHAR2	Code for replicate.
SAMPLE_CODE_2 VARCHAR2	Code for net number.
SAMPLE_CODE_3 VARCHAR2	Code for sample number.
LOCATION_CODE_1 VARCHAR2	Code for the bank.
LOCATION_CODE_2 VARCHAR2	Code for the direction.
LOCATION_CODE_3 VARCHAR2	Code for the distance.
LOCATION_CODE_4 VARCHAR2	Code for the time.
START_TIME VARCHAR2	Start time of the trawl operation.
END_TIME VARCHAR2	End time of the trawl operation.
MINIMUM_DEPTH VARCHAR2	Minimum depth, in meters. Units for values are meters.
MAXIMUM_DEPTH VARCHAR2	Maximum depth, in meters. Units for values are meters.
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.
SAMPLE_VOLUME VARCHAR2	Sample volume, in milliliters. Units for values are milliliters.
TOTAL_NUMBER_SPECIMENS VARCHAR2	Total number of specimens in the sample.
ROW_NUMBER VARCHAR2	A consecutive number for each entry on the data collection form.
SPECIES_CODE VARCHAR2	Ten-digit CZM code for the species.
NUMBER_SPECIES VARCHAR2	Number of species items in the sample.
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.
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

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

TRAWL_YEAR
VARCHAR2

Year of the trawl operation.

TRAWL_MONTH
VARCHAR2

Month of the trawl operation.

TRAWL_DAY
VARCHAR2

Day of the trawl operation.

STATION_NUMBER
VARCHAR2

Station number of the trawl operation.

GEAR_CODE
VARCHAR2

Code for the type of trawl.

SAMPLE_CODE_1
VARCHAR2

Code for replicate.

SAMPLE_CODE_2
VARCHAR2

Code for net number.

SAMPLE_CODE_3
VARCHAR2

Code for sample number.

LOCATION_CODE_1
VARCHAR2

Code for the bank.

LOCATION_CODE_2
VARCHAR2

Code for the direction.

LOCATION_CODE_3
VARCHAR2

Code for the distance.

LOCATION_CODE_4
VARCHAR2

Code for the time.

START_TIME
VARCHAR2

Start time of the trawl operation.

END_TIME
VARCHAR2

End time of the trawl operation.

MINIMUM_DEPTH
VARCHAR2

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

MAXIMUM_DEPTH
VARCHAR2

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

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.

SAMPLE_VOLUME
VARCHAR2

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

TOTAL_NUMBER_SPECIMENS
VARCHAR2

Total number of specimens in the sample.

ROW_NUMBER
VARCHAR2

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

SPECIES_CODE
VARCHAR2

Ten-digit CZM code for the species.

NUMBER_SPECIES
VARCHAR2

Number of species items in the sample.

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.

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.

Point of Contact
Eva M Schemmel
eva.schemmel@noaa.gov

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 Type:	Data Table
Active Version?:	Yes
Description:	Nekton and plankton composition log data collected around Oahu, Hawaii between September 1985 and June 1986.

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

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

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

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

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

TRAWL_YEAR

TRAWL_MONTH

TRAWL_DAY

STATION_NUMBER

GEAR_CODE

SAMPLE_CODE_1

SAMPLE_CODE_2

SAMPLE_CODE_3

LOCATION_CODE_1

LOCATION_CODE_2

LOCATION_CODE_3

LOCATION_CODE_4

START_TIME

END_TIME

MINIMUM_DEPTH

MAXIMUM_DEPTH

WATER_VOLUME_FILTERED

SAMPLE_VOLUME

TOTAL_NUMBER_SPECIMENS

ROW_NUMBER

SPECIES_CODE

NUMBER_SPECIES

JOB_NUMBER

SEQUENCE_NUMBER

DATE_LOADED

Support Roles

Point of Contact

Catalog Details