RB005AA2_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:58335 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | RB005AA2_V |
|---|---|
| Short Name: | RB005AA2_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
|
STATION_NUMBER | VARCHAR2 | Station number of trawl operation. | |
|
100
|
SAMPLE_NUMBER | VARCHAR2 | Sample number of the station. | |
|
100
|
YEAR | VARCHAR2 | Imported from RB004AA1 - Year of trawl. | |
|
100
|
MONTH | VARCHAR2 | Imported from RB004AA1 - Month of trawl. | |
|
100
|
DAY | VARCHAR2 | Imported from RB004AA1 - Day of trawl. | |
|
100
|
START_TIME | VARCHAR2 | Imported from RB004AA1 - Start time of trawl, in Hawaii Standard Time. | |
|
100
|
END_TIME | VARCHAR2 | Imported from RB004AA1 - End time of trawl, in Hawaii Standard Time. | |
|
100
|
OCTANT | VARCHAR2 | Imported from RB004AA1 - 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 | Imported from RB004AA1 - Start latitude, in tenths of a degree. During data entry, the decimal point was omitted; it has been Iinserted into the data. Units for values are degrees. Measures are reported with a precision of 3. | |
|
100
|
LATITUDE_DIRECTION | VARCHAR2 | Imported from RB004AA1 - Start latitude direction, determined using OCTANT. | |
|
100
|
LATITUDE_DD | NUMBER | Imported from RB004AA1 - Computed start latitude, in decimal degrees, of the trawl station. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 3. | |
|
100
|
LONGITUDE_DEGREES | VARCHAR2 | Imported from RB004AA1 - Start longitude, in tenths of a degree. During data entry, the first digit (0 or 1) and the decimal point were omitted; both have been inserted into the data. Units for values are degrees. Measures are reported with a precision of 4. | |
|
100
|
LONGITUDE_DIRECTION | VARCHAR2 | Imported from dataset RB004AA1 - Start longitude direction, determined using OCTANT. | |
|
100
|
LONGITUDE_DD | NUMBER | Imported from dataset RB004AA1 - Computed start longitude, in decimal degrees, of the trawl station. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 4. | |
|
100
|
NUMBER_K_PELAMIS | VARCHAR2 | Number of Katsuwonus pelamis. | |
|
100
|
NUMBER_T_ALBACARES | VARCHAR2 | Number of Thunnus albacares. | |
|
100
|
NUMBER_T_OBESUS | VARCHAR2 | Number of Thunnus obsesus. | |
|
100
|
NUMBER_T_ALALUNGA | VARCHAR2 | Number of Thunnus alalunga. | |
|
100
|
NUMBER_E_AFFINIS | VARCHAR2 | Number of Euthynnus affinis. | |
|
100
|
NUMBER_AUXIS_SP | VARCHAR2 | Number of Auxis species. | |
|
100
|
NUMBER_A_SOLANDRI | VARCHAR2 | Number of Acanthocybium solandri. | |
|
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: 889355
| 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: 889356
| 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: 889357
| 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: 889358
| 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 |
STATION_NUMBER
CC ID: 889359
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Station number of trawl operation. |
| General Data Type: | VARCHAR2 |
SAMPLE_NUMBER
CC ID: 889360
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Sample number of the station. |
| General Data Type: | VARCHAR2 |
YEAR
CC ID: 889361
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Imported from RB004AA1 - Year of trawl. |
| General Data Type: | VARCHAR2 |
MONTH
CC ID: 889362
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Imported from RB004AA1 - Month of trawl. |
| General Data Type: | VARCHAR2 |
DAY
CC ID: 889363
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Imported from RB004AA1 - Day of trawl. |
| General Data Type: | VARCHAR2 |
START_TIME
CC ID: 889364
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Imported from RB004AA1 - Start time of trawl, in Hawaii Standard Time. |
| General Data Type: | VARCHAR2 |
END_TIME
CC ID: 889365
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Imported from RB004AA1 - End time of trawl, in Hawaii Standard Time. |
| General Data Type: | VARCHAR2 |
OCTANT
CC ID: 889366
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Imported from RB004AA1 - 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 |
| Allowed Values: | 1 = North Latitude; 90° West - 179° 59’ West Longitude |
LATITUDE_DEGREES
CC ID: 889367
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Scale: | 1 |
| Status: | Active |
| Description: |
Imported from RB004AA1 - Start latitude, in tenths of a degree. During data entry, the decimal point was omitted; it has been Iinserted into the data. Units for values are degrees. Measures are reported with a precision of 3. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | degrees |
LATITUDE_DIRECTION
CC ID: 889368
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Imported from RB004AA1 - Start latitude direction, determined using OCTANT. |
| General Data Type: | VARCHAR2 |
| Allowed Values: | N = NORTH |
LATITUDE_DD
CC ID: 889369
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Scale: | 1 |
| Status: | Active |
| Description: |
Imported from RB004AA1 - Computed start latitude, in decimal degrees, of the trawl station. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 3. |
| General Data Type: | NUMBER |
| Unit of Measure: | degrees |
LONGITUDE_DEGREES
CC ID: 889370
| Seq. Order: | 16 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Scale: | 1 |
| Status: | Active |
| Description: |
Imported from RB004AA1 - Start longitude, in tenths of a degree. During data entry, the first digit (0 or 1) and the decimal point were omitted; both have been inserted into the data. Units for values are degrees. Measures are reported with a precision of 4. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | degrees |
LONGITUDE_DIRECTION
CC ID: 889371
| Seq. Order: | 17 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Imported from dataset RB004AA1 - Start longitude direction, determined using OCTANT. |
| General Data Type: | VARCHAR2 |
| Allowed Values: | W = WEST |
LONGITUDE_DD
CC ID: 889372
| Seq. Order: | 18 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Scale: | 1 |
| Status: | Active |
| Description: |
Imported from dataset RB004AA1 - Computed start longitude, in decimal degrees, of the trawl station. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 4. |
| General Data Type: | NUMBER |
| Unit of Measure: | degrees |
NUMBER_K_PELAMIS
CC ID: 889373
| Seq. Order: | 19 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of Katsuwonus pelamis. |
| General Data Type: | VARCHAR2 |
NUMBER_T_ALBACARES
CC ID: 889374
| Seq. Order: | 20 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of Thunnus albacares. |
| General Data Type: | VARCHAR2 |
NUMBER_T_OBESUS
CC ID: 889375
| Seq. Order: | 21 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of Thunnus obsesus. |
| General Data Type: | VARCHAR2 |
NUMBER_T_ALALUNGA
CC ID: 889376
| Seq. Order: | 22 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of Thunnus alalunga. |
| General Data Type: | VARCHAR2 |
NUMBER_E_AFFINIS
CC ID: 889377
| Seq. Order: | 23 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of Euthynnus affinis. |
| General Data Type: | VARCHAR2 |
NUMBER_AUXIS_SP
CC ID: 889378
| Seq. Order: | 24 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of Auxis species. |
| General Data Type: | VARCHAR2 |
NUMBER_A_SOLANDRI
CC ID: 889379
| Seq. Order: | 25 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of Acanthocybium solandri. |
| General Data Type: | VARCHAR2 |
SEQUENCE_NUMBER
CC ID: 889380
| Seq. Order: | 26 |
|---|---|
| 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: 889382
| Seq. Order: | 28 |
|---|---|
| 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: | 58335 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:58335 |
| Metadata Record Created By: | Brent M Miyamoto |
| Metadata Record Created: | 2019-12-16 15:42+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
| Metadata Record Published: | 2019-12-16 |
| Owner Org: | PIFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2019-12-16 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2020-12-16 |