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