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

Rubric Score Primary Key? 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
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: 2019-07-23 22:28+0000
Metadata Record Published: 2019-07-23
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2020-07-23