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. |
Attribute Details
DATASET_CODE
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |