RB005AA1_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:58307 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | RB005AA1_V |
---|---|
Short Name: | RB005AA1_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
|
SPECIES_CODE | VARCHAR2 | Two-digit species code. | |
100
|
STANDARD_LENGTH | VARCHAR2 | Standard length, in tenths of a millimeter. 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 4. | |
100
|
FORK_LENGTH | VARCHAR2 | Fork length, in tents of a millimeter. 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 4. | |
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |
SPECIES_CODE
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Two-digit species code. |
General Data Type: | VARCHAR2 |
Allowed Values: | 32 = KATSUWONUS PELAMIS - SKIPJACK TUNA 33 = EUTHYNNUS SPP. - LITTLE TUNNY 34 = THUNNUS OBESUS - BIGEYE TUNA 35 - THUNNUS ALBACARES - YELLOWFIN TUNA 36 - THUNNUS ALALUNGA - ALBACORE 41 - AUXIS SPP. - FRIGATE MACKEREL 44 - ACANTHOCYBIUM SOLANDRI - WAHOO. ONO |
STANDARD_LENGTH
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Scale: | 1 |
Status: | Active |
Description: |
Standard length, in tenths of a millimeter. 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 4. |
General Data Type: | VARCHAR2 |
Unit of Measure: | millimeters |
FORK_LENGTH
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Scale: | 1 |
Status: | Active |
Description: |
Fork length, in tents of a millimeter. 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 4. |
General Data Type: | VARCHAR2 |
Unit of Measure: | millimeters |
SEQUENCE_NUMBER
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
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: | 58307 |
---|---|
GUID: | gov.noaa.nmfs.inport:58307 |
Metadata Record Created By: | Brent M Miyamoto |
Metadata Record Created: | 2019-12-11 18:03+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2019-12-11 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2019-12-11 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2020-12-11 |