RB003AA1_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:58291 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | RB003AA1_V |
|---|---|
| Short Name: | RB003AA1_V |
| Status: | Completed |
| Abstract: |
. |
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Description: |
. |
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 | Incremental number of the cruise for the vessel. | |
|
100
|
YEAR | VARCHAR2 | Year of plankton tow. | |
|
100
|
MONTH | VARCHAR2 | Month of plankton tow. | |
|
100
|
DAY | VARCHAR2 | Day of plankton tow. | |
|
100
|
TIME | VARCHAR2 | Time of plankton tow. | |
|
100
|
OCTANT | VARCHAR2 | Octant of the globe. Used OCTANT to determine 1) Latitude Direction (N, S); 2) Longitude Direction (E, W); and 3) First digit of Longitude degrees (0, 1). | |
|
100
|
LATITUDE_DEGREES | VARCHAR2 | Latitude degrees, in degrees. Units for values are degrees. | |
|
100
|
LATITUDE_MINUTES | VARCHAR2 | Latitude minutes, in minutes. Units for values are minutes. | |
|
100
|
LATITUDE_DIRECTION | VARCHAR2 | Latitude direction, determined using OCTANT. | |
|
100
|
LATITUDE_DD | NUMBER | Computed latitude, in decimal degrees, of the plankton tow station. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. | |
|
100
|
LONGITUDE_DEGREES | VARCHAR2 | Longitude degrees, in degrees. During data entry, the first digit (0 or 1) was omitted. It was inserted into the data using OCTANT. Units for values are degrees. | |
|
100
|
LONGITUDE_MINUTES | VARCHAR2 | Longitude minutes, in minutes. Units for values are minutes. | |
|
100
|
LONGITUDE_DIRECTION | VARCHAR2 | Longitude direction, determined using OCTANT. | |
|
100
|
LONGITUDE_DD | NUMBER | Computed longitude, in decimal degrees, of the plankton tow station. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. | |
|
100
|
STATION_NUMBER | VARCHAR2 | Station number of tow operation. | |
|
100
|
SAMPLE_NUMBER | VARCHAR2 | A consecutive number assigned to each sample collected from the station. | |
|
100
|
SPECIES_CODE | VARCHAR2 | Species code for Thunnus albacares and Katsuwonus pelamis. | |
|
100
|
STANDARD_LENGTH | VARCHAR2 | Standard length, in mm. During data entry, the decimal point was omitted ; it has been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 3. | |
|
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: 888480
| 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: 888481
| 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: 888482
| 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: | 004 = NOAA R/V HUGH M SMITH 005 = NOAA R/V JOHN R MANNING 007 = NOAA R/V CHARLES H GILBERT 019 = NOAA R/V SPENCER F BAIRD 027 = USS ENERGY |
CRUISE_NUMBER
CC ID: 888483
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Incremental number of the cruise for the vessel. |
| General Data Type: | VARCHAR2 |
YEAR
CC ID: 888484
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Year of plankton tow. |
| General Data Type: | VARCHAR2 |
MONTH
CC ID: 888485
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Month of plankton tow. |
| General Data Type: | VARCHAR2 |
DAY
CC ID: 888486
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Day of plankton tow. |
| General Data Type: | VARCHAR2 |
TIME
CC ID: 888487
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Time of plankton tow. |
| General Data Type: | VARCHAR2 |
OCTANT
CC ID: 888488
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Octant of the globe. Used OCTANT to determine 1) Latitude Direction (N, S); 2) Longitude Direction (E, W); and 3) First digit of Longitude degrees (0, 1). |
| General Data Type: | VARCHAR2 |
LATITUDE_DEGREES
CC ID: 888489
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Latitude degrees, in degrees. Units for values are degrees. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | degrees |
LATITUDE_MINUTES
CC ID: 888490
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Latitude minutes, in minutes. Units for values are minutes. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | minutes |
LATITUDE_DIRECTION
CC ID: 888491
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Latitude direction, determined using OCTANT. |
| General Data Type: | VARCHAR2 |
| Allowed Values: | N = NORTH S = SOUTH |
LATITUDE_DD
CC ID: 888492
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 42 |
| Required: | No |
| Primary Key: | No |
| Scale: | 38 |
| Status: | Active |
| Description: |
Computed latitude, in decimal degrees, of the plankton tow station. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. |
| General Data Type: | NUMBER |
| Unit of Measure: | degrees |
LONGITUDE_DEGREES
CC ID: 888493
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Longitude degrees, in degrees. During data entry, the first digit (0 or 1) was omitted. It was inserted into the data using OCTANT. Units for values are degrees. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | degrees |
LONGITUDE_MINUTES
CC ID: 888494
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Longitude minutes, in minutes. Units for values are minutes. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | minutes |
LONGITUDE_DIRECTION
CC ID: 888495
| Seq. Order: | 16 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Longitude direction, determined using OCTANT. |
| General Data Type: | VARCHAR2 |
| Allowed Values: | E = EAST W = WEST |
LONGITUDE_DD
CC ID: 888496
| Seq. Order: | 17 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 41 |
| Required: | No |
| Primary Key: | No |
| Scale: | 36 |
| Status: | Active |
| Description: |
Computed longitude, in decimal degrees, of the plankton tow station. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. |
| General Data Type: | NUMBER |
| Unit of Measure: | degrees |
STATION_NUMBER
CC ID: 888497
| Seq. Order: | 18 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Station number of tow operation. |
| General Data Type: | VARCHAR2 |
SAMPLE_NUMBER
CC ID: 888498
| Seq. Order: | 19 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
A consecutive number assigned to each sample collected from the station. |
| General Data Type: | VARCHAR2 |
SPECIES_CODE
CC ID: 888499
| Seq. Order: | 20 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Species code for Thunnus albacares and Katsuwonus pelamis. |
| General Data Type: | VARCHAR2 |
| Allowed Values: | 02 = THUNNUS ALBACARES 10 = KATSUWONUS PELAMIS |
STANDARD_LENGTH
CC ID: 888500
| Seq. Order: | 21 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Scale: | 1 |
| Status: | Active |
| Description: |
Standard length, in mm. During data entry, the decimal point was omitted ; it has been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 3. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | millimeters |
SEQUENCE_NUMBER
CC ID: 888501
| Seq. Order: | 22 |
|---|---|
| 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: 888502
| Seq. Order: | 23 |
|---|---|
| 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: | 58291 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:58291 |
| Metadata Record Created By: | Brent M Miyamoto |
| Metadata Record Created: | 2019-12-06 19:18+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
| Metadata Record Published: | 2019-12-06 |
| Owner Org: | PIFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2019-12-06 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2020-12-06 |