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 9, 2022 | 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	Character	Source ID Code assigned by the data entry staff.
100	VERSION_CODE	Character	Code for the format version assigned by the data entry staff.
100	VESSEL_CODE	Number	Code for the vessel.
100	CRUISE_NUMBER	Number	Last two digits of the year of the cruise and two digits incremental number of the cruise for the year.
100	TRAWL_YEAR	Number	Year of the trawl operation.
100	TRAWL_MONTH	Number	Month of the trawl operation.
100	TRAWL_DAY	Number	Day of the trawl operation.
100	STATION_NUMBER	Number	Station number of the trawl operation.
100	GEAR_CODE	Number	Code for the type of trawl.
100	SAMPLE_CODE_1	Number	Code for replicate.
100	SAMPLE_CODE_2	Number	Code for net number.
100	SAMPLE_CODE_3	Number	Code for sample number.
100	LOCATION_CODE_1	Number	Code for the bank.
100	LOCATION_CODE_2	Number	Code for the directional field.
100	LOCATION_CODE_3	Number	Code for the distance category.
100	LOCATION_CODE_4	Number	Code for the temperal category.
100	START_TIME	Number	Start time of the trawl operation.
100	END_TIME	Number	End time of the trawl operation.
100	MINIMUM_DEPTH	Number	Minimum depth, in meters. Units for values are meters.
100	MAXIMUM_DEPTH	Number	Maximum depth, in meters. Units for values are meters.
100	WATER_VOLUME_FILTERED	Number	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	Number	Sample volume, in milliliters. Units for values are milliliters.
100	TOTAL_NUMBER_SPECIMENS	Number	Total number of specimens in the sample
100	ROW_NUMBER	Number	A consecutive number for each entry on the data entry form.
100	SPECIES_CODE	Number	Ten-digit CZM code for the species.
100	NUMBER_SPECIES	Number	Number of species items in the sample.
100	JOB_NUMBER	Character	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	Number	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

Character

Source ID Code assigned by the data entry staff.

100

VERSION_CODE

Character

Code for the format version assigned by the data entry staff.

100

VESSEL_CODE

Number

Code for the vessel.

100

CRUISE_NUMBER

Number

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

100

TRAWL_YEAR

Number

Year of the trawl operation.

100

TRAWL_MONTH

Number

Month of the trawl operation.

100

TRAWL_DAY

Number

Day of the trawl operation.

100

STATION_NUMBER

Number

Station number of the trawl operation.

100

GEAR_CODE

Number

Code for the type of trawl.

100

SAMPLE_CODE_1

Number

Code for replicate.

100

SAMPLE_CODE_2

Number

Code for net number.

100

SAMPLE_CODE_3

Number

Code for sample number.

100

LOCATION_CODE_1

Number

Code for the bank.

100

LOCATION_CODE_2

Number

Code for the directional field.

100

LOCATION_CODE_3

Number

Code for the distance category.

100

LOCATION_CODE_4

Number

Code for the temperal category.

100

START_TIME

Number

Start time of the trawl operation.

100

END_TIME

Number

End time of the trawl operation.

100

MINIMUM_DEPTH

Number

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

100

MAXIMUM_DEPTH

Number

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

100

WATER_VOLUME_FILTERED

Number

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

Number

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

100

TOTAL_NUMBER_SPECIMENS

Number

Total number of specimens in the sample

100

ROW_NUMBER

Number

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

100

SPECIES_CODE

Number

Ten-digit CZM code for the species.

100

NUMBER_SPECIES

Number

Number of species items in the sample.

100

JOB_NUMBER

Character

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

Number

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

Seq. Order:	1
Data Storage Type:	Character
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	Source ID Code assigned by the data entry staff.
General Data Type:	Character

VERSION_CODE

CC ID: 845384

Seq. Order:	2
Data Storage Type:	Character
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:	Character

VESSEL_CODE

CC ID: 845385

Seq. Order:	3
Data Storage Type:	Number
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for the vessel.
General Data Type:	Number
Allowed Values:	001 = NOAA R/V TOWNSEND CROMWELL

CRUISE_NUMBER

CC ID: 845386

Seq. Order:	4
Data Storage Type:	Number
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:	Number

TRAWL_YEAR

CC ID: 845387

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

TRAWL_MONTH

CC ID: 845388

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

TRAWL_DAY

CC ID: 845389

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

STATION_NUMBER

CC ID: 845390

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

GEAR_CODE

CC ID: 845391

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

SAMPLE_CODE_1

CC ID: 845392

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

SAMPLE_CODE_2

CC ID: 845393

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

SAMPLE_CODE_3

CC ID: 845394

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

LOCATION_CODE_1

CC ID: 845395

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

LOCATION_CODE_2

CC ID: 845396

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

LOCATION_CODE_3

CC ID: 845397

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

LOCATION_CODE_4

CC ID: 845398

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

START_TIME

CC ID: 845399

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

END_TIME

CC ID: 845400

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

MINIMUM_DEPTH

CC ID: 845401

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

MAXIMUM_DEPTH

CC ID: 845402

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

WATER_VOLUME_FILTERED

CC ID: 845403

Seq. Order:	21
Data Storage Type:	Number
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:	Number
Unit of Measure:	cubic meters

SAMPLE_VOLUME

CC ID: 845404

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

TOTAL_NUMBER_SPECIMENS

CC ID: 845405

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

ROW_NUMBER

CC ID: 845406

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

SPECIES_CODE

CC ID: 845407

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

NUMBER_SPECIES

CC ID: 845408

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

JOB_NUMBER

CC ID: 845409

Seq. Order:	27
Data Storage Type:	Character
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:	Character

SEQUENCE_NUMBER

CC ID: 845410

Seq. Order:	28
Data Storage Type:	Number
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:	Number

DATE_LOADED

CC ID: 845411

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

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:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2019-07-23
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2019-07-23
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2020-07-23