RP022AA1_RSCH_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:65738 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | RP022AA1_RSCH_V |
---|---|
Short Name: | RP022AA1_RSCH_V |
Status: | Completed |
Abstract: |
Longline effort data collected during research cruises between 1950 and 1992 in the Pacific Ocean. |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Description: |
Longline effort data collected during research cruises between 1950 and 1992 in the Pacific Ocean. |
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 | Four digit incremental cruise number of the vessel, e.g., 0001, or the last two digits of the year of the cruise and two digits incremental number of the cruise for the year, e.g., 8101. | |
100
|
YEAR | VARCHAR2 | Year of set. | |
100
|
MONTH | VARCHAR2 | Month of set. | |
100
|
DAY | VARCHAR2 | Day of set. | |
100
|
SET_TIME_FIRST | VARCHAR2 | Set time of the first basket. | |
100
|
SET_OCTANT | VARCHAR2 | Set octant for the first basket. SET_OCTANT used to determine latitude direction (N/S), longitude direction (E/W) and the first digit of LONGITUDE_DEGREES (0/1). | |
100
|
SET_LATITUDE_DEGREES_FIRST | VARCHAR2 | Set latitude degrees of the first basket. Units for values are degrees. | |
100
|
SET_LATITUDE_MINUTES_FIRST | VARCHAR2 | Set latitude minutes of the first basket. Units for values are minutes. | |
100
|
SET_LATITUDE_DIRECTION_FIRST | VARCHAR2 | Set latitude direction of the first basket. SET_OCTANT used to determine SET_LATITUDE_DIRECTION_FIRST (N/S). | |
100
|
SET_LATITUDE_DD_FIRST | NUMBER | Set latitude, in decimal degrees, of the first basket. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. | |
100
|
SET_LONGITUDE_DEGREES_FIRST | VARCHAR2 | Set longitude degrees of the first basket. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using SET_OCTANT. Units for values are degrees. | |
100
|
SET_LONGITUDE_MINUTES_FIRST | VARCHAR2 | Set longitude minutes of the first basket. Units for values are minutes. | |
100
|
SET_LONGITUDE_DIRECTION_FIRST | VARCHAR2 | Set longitude direction of the first basket. SET_OCTANT used to determine SET_LONGITUDE_DIRECTION_FIRST (E/W). | |
100
|
SET_LONGITUDE_DD_FIRST | NUMBER | Set longitude, in decimal degrees, of the first basket. 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 the longline operation. | |
100
|
SET_LATITUDE_DEGREES_LAST | VARCHAR2 | Set latitude degrees of the last basket. Units for values are degrees. | |
100
|
SET_LATITUDE_MINUTES_LAST | VARCHAR2 | Set latitude minutes of the last basket. Units for values are minutes. | |
100
|
SET_LATITUDE_DIRECTION_LAST | VARCHAR2 | Set latitude direction of the last basket. SET_OCTANT used to determine SET_LATITUDE_DIRECTION_LAST (N/S). Measures are reported with a precision of 40. | |
100
|
SET_LATITUDE_DD_LAST | NUMBER | Set latitude, in decimal degrees, of the last basket. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. | |
100
|
SET_LONGITUDE_DEGREES_LAST | VARCHAR2 | Set longitude degrees of the last basket. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using SET_OCTANT. Units for values are degrees. | |
100
|
SET_LONGITUDE_MINUTES_LAST | VARCHAR2 | Set longitude minutes of the last basket. Units for values are minutes. | |
100
|
SET_LONGITUDE_DIRECTION_LAST | VARCHAR2 | Set longitude direction of the last basket. SET_OCTANT used to determine SET_LONGITUDE_DIRECTION_LAST (E/W). | |
100
|
SET_LONGITUDE_DD_LAST | NUMBER | Set longitude, in decimal degrees, of the last basket. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. | |
100
|
TOTAL_SETTING_TIME | VARCHAR2 | Total time, in minutes, of setting operation. Units for values are minutes. | |
100
|
HAUL_TIME_FIRST | VARCHAR2 | Haul time of the first basket. | |
100
|
HAUL_LATITUDE_DEGREES_FIRST | VARCHAR2 | Haul latitude degrees of the first basket. Units for values are degrees. | |
100
|
HAUL_LATITUDE_MINUTES_FIRST | VARCHAR2 | Haul latitude minutes of the first basket. Units for values are minutes. | |
100
|
HAUL_LATITUDE_DIRECTION_FIRST | VARCHAR2 | Haul latitude direction of the first basket. SET_OCTANT used to determine HAUL_LATITUDE_DIRECTION_FIRST (N/S). | |
100
|
HAUL_LATITUDE_DD_FIRST | NUMBER | Haul latitude, in decimal degrees, of the first basket. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. | |
100
|
HAUL_LONGITUDE_DEGREES_FIRST | VARCHAR2 | Haul longitude degrees of the first basket. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using SET_OCTANT. Units for values are degrees. | |
100
|
HAUL_LONGITUDE_MINUTES_FIRST | VARCHAR2 | Haul longitude minutes of the first basket. Units for values are minutes. | |
100
|
HAUL_LONGITUDE_DIRECTION_FIRST | VARCHAR2 | Haul longitude direction of the first basket. SET_OCTANT used to determine HAUL_LONGITUDE_DIRECTION_FIRST (E/W). | |
100
|
HAUL_LONGITUDE_DD_FIRST | NUMBER | Haul longitude, in decimal degrees, of the first basket. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. | |
100
|
HAUL_LATITUDE_DEGREES_LAST | VARCHAR2 | Haul latitude degrees of the last basket. Units for values are degrees. | |
100
|
HAUL_LATITUDE_MINUTES_LAST | VARCHAR2 | Haul latitude minutes of the last basket. Units for values are minutes. | |
100
|
HAUL_LATITUDE_DIRECTION_LAST | VARCHAR2 | Haul latitude direction of the last basket. SET_OCTANT used to determine HAUL_LATITUDE_DIRECTION_LAST (N/S). | |
100
|
HAUL_LATITUDE_DD_LAST | NUMBER | Haul latitude, in decimal degrees, of the last basket. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. | |
100
|
HAUL_LONGITUDE_DEGREES_LAST | VARCHAR2 | Haul longitude degrees of the last basket. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using SET_OCTANT. Units for values are degrees. | |
100
|
HAUL_LONGITUDE_MINUTES_LAST | VARCHAR2 | Haul longitude minutes of the last basket. Units for values are minutes. | |
100
|
HAUL_LONGITUDE_DIRECTION_LAST | VARCHAR2 | Haul longitude direction of the last basket. SET_OCTANT used to determine HAUL_LONGITUDE_DIRECTION_LAST (E/W). | |
100
|
HAUL_LONGITUDE_DD_LAST | NUMBER | Haul longitude, in decimal degrees, of the last basket. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. | |
100
|
ACTUAL_HAULING_TIME | VARCHAR2 | Actual time, in minutes of the hauling operation. Units for values are minutes. | |
100
|
DIRECTION_SET | VARCHAR2 | Direction of set, in 10s of degrees, e.g., 272 = 27. Units for values are degrees. | |
100
|
TOTAL_NUMBER_BASKETS_SET | VARCHAR2 | Total number of baskets set. | |
100
|
NUMBER_HOOKS_PER_BASKET | VARCHAR2 | Number of hooks per basket. | |
100
|
NUMBER_HOOKS_RETRIEVED | VARCHAR2 | Number of hooks retrieved. | |
100
|
DISTANCE_FROM_LAND | VARCHAR2 | For stations within 200 miles of land, the distance from land, in miles, of the first postion. Units for values are miles. | |
100
|
TIME_ZONE_CODE | VARCHAR2 | Code for the time zone. | |
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., D94471. | |
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; 004 = NOAA R/V HUGH M SMITH; 005 = NOAA R/V JOHN R MANNING; 007 = NOAA R/V CHARLES H GILBERT; 995 = HOKUSEI MARU |
CRUISE_NUMBER
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Four digit incremental cruise number of the vessel, e.g., 0001, or the last two digits of the year of the cruise and two digits incremental number of the cruise for the year, e.g., 8101. |
General Data Type: | VARCHAR2 |
YEAR
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Year of set. |
General Data Type: | VARCHAR2 |
MONTH
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Month of set. |
General Data Type: | VARCHAR2 |
DAY
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Day of set. |
General Data Type: | VARCHAR2 |
SET_TIME_FIRST
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Set time of the first basket. |
General Data Type: | VARCHAR2 |
SET_OCTANT
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Set octant for the first basket. SET_OCTANT used to determine latitude direction (N/S), longitude direction (E/W) and the first digit of LONGITUDE_DEGREES (0/1). |
General Data Type: | VARCHAR2 |
Allowed Values: | 0 = NORTH LATITUDE, 00° WEST - 89° 59’ WEST LONGITUDE; 1 = NORTH LATITUDE, 90° WEST - 179° 59’ WEST LONGITUDE; 2 = NORTH LATITUDE, 180° - 90° 01’ EAST LONGITUDE; 3 = NORTH LATITUDE, 90° EAST - 00° 01’ EAST LONGITUDE; 5 = SOUTH LATITUDE, 00° WEST - 89° 59’ WEST LONGITUDE; 6 = SOUTH LATITUDE, 90° WEST - 179° 59’ WEST LONGITUDE; 7 = SOUTH LATITUDE, 180° - 90° 01’ EAST LONGITUDE; 8 = SOUTH LATITUDE, 90° EAST - 00° 01’ EAST LONGITUDE |
SET_LATITUDE_DEGREES_FIRST
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Set latitude degrees of the first basket. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
SET_LATITUDE_MINUTES_FIRST
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Set latitude minutes of the first basket. Units for values are minutes. |
General Data Type: | VARCHAR2 |
Unit of Measure: | minutes |
SET_LATITUDE_DIRECTION_FIRST
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Set latitude direction of the first basket. SET_OCTANT used to determine SET_LATITUDE_DIRECTION_FIRST (N/S). |
General Data Type: | VARCHAR2 |
Allowed Values: | N = NORTH; S = SOUTH |
SET_LATITUDE_DD_FIRST
Seq. Order: | 13 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 42 |
Required: | No |
Primary Key: | No |
Scale: | 38 |
Status: | Active |
Description: |
Set latitude, in decimal degrees, of the first basket. Positive 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 |
SET_LONGITUDE_DEGREES_FIRST
Seq. Order: | 14 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Set longitude degrees of the first basket. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using SET_OCTANT. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
SET_LONGITUDE_MINUTES_FIRST
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Set longitude minutes of the first basket. Units for values are minutes. |
General Data Type: | VARCHAR2 |
Unit of Measure: | minutes |
SET_LONGITUDE_DIRECTION_FIRST
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Set longitude direction of the first basket. SET_OCTANT used to determine SET_LONGITUDE_DIRECTION_FIRST (E/W). |
General Data Type: | VARCHAR2 |
Allowed Values: | E = EAST; W = WEST |
SET_LONGITUDE_DD_FIRST
Seq. Order: | 17 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 41 |
Required: | No |
Primary Key: | No |
Scale: | 36 |
Status: | Active |
Description: |
Set longitude, in decimal degrees, of the first basket. 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
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Station number of the longline operation. |
General Data Type: | VARCHAR2 |
SET_LATITUDE_DEGREES_LAST
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Set latitude degrees of the last basket. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
SET_LATITUDE_MINUTES_LAST
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Set latitude minutes of the last basket. Units for values are minutes. |
General Data Type: | VARCHAR2 |
Unit of Measure: | minutes |
SET_LATITUDE_DIRECTION_LAST
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Scale: | 38 |
Status: | Active |
Description: |
Set latitude direction of the last basket. SET_OCTANT used to determine SET_LATITUDE_DIRECTION_LAST (N/S). Measures are reported with a precision of 40. |
General Data Type: | VARCHAR2 |
Allowed Values: | N = NORTH; S = SOUTH |
SET_LATITUDE_DD_LAST
Seq. Order: | 22 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 42 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Set latitude, in decimal degrees, of the last basket. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. |
General Data Type: | NUMBER |
Unit of Measure: | degrees |
SET_LONGITUDE_DEGREES_LAST
Seq. Order: | 23 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Set longitude degrees of the last basket. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using SET_OCTANT. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
SET_LONGITUDE_MINUTES_LAST
Seq. Order: | 24 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Set longitude minutes of the last basket. Units for values are minutes. |
General Data Type: | VARCHAR2 |
Unit of Measure: | minutes |
SET_LONGITUDE_DIRECTION_LAST
Seq. Order: | 25 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Set longitude direction of the last basket. SET_OCTANT used to determine SET_LONGITUDE_DIRECTION_LAST (E/W). |
General Data Type: | VARCHAR2 |
Allowed Values: | E = EAST; W = WEST |
SET_LONGITUDE_DD_LAST
Seq. Order: | 26 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 41 |
Required: | No |
Primary Key: | No |
Scale: | 36 |
Status: | Active |
Description: |
Set longitude, in decimal degrees, of the last basket. 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 |
TOTAL_SETTING_TIME
Seq. Order: | 27 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Total time, in minutes, of setting operation. Units for values are minutes. |
General Data Type: | VARCHAR2 |
Unit of Measure: | minutes |
HAUL_TIME_FIRST
Seq. Order: | 28 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Haul time of the first basket. |
General Data Type: | VARCHAR2 |
HAUL_LATITUDE_DEGREES_FIRST
Seq. Order: | 29 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Haul latitude degrees of the first basket. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
HAUL_LATITUDE_MINUTES_FIRST
Seq. Order: | 30 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Haul latitude minutes of the first basket. Units for values are minutes. |
General Data Type: | VARCHAR2 |
Unit of Measure: | minutes |
HAUL_LATITUDE_DIRECTION_FIRST
Seq. Order: | 31 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Haul latitude direction of the first basket. SET_OCTANT used to determine HAUL_LATITUDE_DIRECTION_FIRST (N/S). |
General Data Type: | VARCHAR2 |
Allowed Values: | N = NORTH; S= SOUTH |
HAUL_LATITUDE_DD_FIRST
Seq. Order: | 32 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 42 |
Required: | No |
Primary Key: | No |
Scale: | 38 |
Status: | Active |
Description: |
Haul latitude, in decimal degrees, of the first basket. Positive 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 |
HAUL_LONGITUDE_DEGREES_FIRST
Seq. Order: | 33 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Haul longitude degrees of the first basket. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using SET_OCTANT. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
HAUL_LONGITUDE_MINUTES_FIRST
Seq. Order: | 34 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Haul longitude minutes of the first basket. Units for values are minutes. |
General Data Type: | VARCHAR2 |
Unit of Measure: | minutes |
HAUL_LONGITUDE_DIRECTION_FIRST
Seq. Order: | 35 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Haul longitude direction of the first basket. SET_OCTANT used to determine HAUL_LONGITUDE_DIRECTION_FIRST (E/W). |
General Data Type: | VARCHAR2 |
Allowed Values: | E = EAST; W = WEST |
HAUL_LONGITUDE_DD_FIRST
Seq. Order: | 36 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 41 |
Required: | No |
Primary Key: | No |
Scale: | 36 |
Status: | Active |
Description: |
Haul longitude, in decimal degrees, of the first basket. 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 |
HAUL_LATITUDE_DEGREES_LAST
Seq. Order: | 37 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Haul latitude degrees of the last basket. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
HAUL_LATITUDE_MINUTES_LAST
Seq. Order: | 38 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Haul latitude minutes of the last basket. Units for values are minutes. |
General Data Type: | VARCHAR2 |
Unit of Measure: | minutes |
HAUL_LATITUDE_DIRECTION_LAST
Seq. Order: | 39 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Haul latitude direction of the last basket. SET_OCTANT used to determine HAUL_LATITUDE_DIRECTION_LAST (N/S). |
General Data Type: | VARCHAR2 |
Allowed Values: | N = NORTH; S = SOUTH |
HAUL_LATITUDE_DD_LAST
Seq. Order: | 40 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 42 |
Required: | No |
Primary Key: | No |
Scale: | 38 |
Status: | Active |
Description: |
Haul latitude, in decimal degrees, of the last basket. Positive 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 |
HAUL_LONGITUDE_DEGREES_LAST
Seq. Order: | 41 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Haul longitude degrees of the last basket. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using SET_OCTANT. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
HAUL_LONGITUDE_MINUTES_LAST
Seq. Order: | 42 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Haul longitude minutes of the last basket. Units for values are minutes. |
General Data Type: | VARCHAR2 |
Unit of Measure: | minutes |
HAUL_LONGITUDE_DIRECTION_LAST
Seq. Order: | 43 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Haul longitude direction of the last basket. SET_OCTANT used to determine HAUL_LONGITUDE_DIRECTION_LAST (E/W). |
General Data Type: | VARCHAR2 |
Allowed Values: | E = EAST; W = WEST |
HAUL_LONGITUDE_DD_LAST
Seq. Order: | 44 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 41 |
Required: | No |
Primary Key: | No |
Scale: | 36 |
Status: | Active |
Description: |
Haul longitude, in decimal degrees, of the last basket. 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 |
ACTUAL_HAULING_TIME
Seq. Order: | 45 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Actual time, in minutes of the hauling operation. Units for values are minutes. |
General Data Type: | VARCHAR2 |
Unit of Measure: | minutes |
DIRECTION_SET
Seq. Order: | 46 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Direction of set, in 10s of degrees, e.g., 272 = 27. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
TOTAL_NUMBER_BASKETS_SET
Seq. Order: | 47 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Total number of baskets set. |
General Data Type: | VARCHAR2 |
NUMBER_HOOKS_PER_BASKET
Seq. Order: | 48 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of hooks per basket. |
General Data Type: | VARCHAR2 |
NUMBER_HOOKS_RETRIEVED
Seq. Order: | 49 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of hooks retrieved. |
General Data Type: | VARCHAR2 |
DISTANCE_FROM_LAND
Seq. Order: | 50 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
For stations within 200 miles of land, the distance from land, in miles, of the first postion. Units for values are miles. |
General Data Type: | VARCHAR2 |
Unit of Measure: | miles |
TIME_ZONE_CODE
Seq. Order: | 51 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the time zone. |
General Data Type: | VARCHAR2 |
Allowed Values: | L = MINUS 11; M = MINUS 12; T = PLUS 7; U = PLUS 8; V = PLUS 9; W = PLUS 10; X = PLUS 11 |
JOB_NUMBER
Seq. Order: | 52 |
---|---|
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., D94471. |
General Data Type: | VARCHAR2 |
SEQUENCE_NUMBER
Seq. Order: | 53 |
---|---|
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: | 54 |
---|---|
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: | 65738 |
---|---|
GUID: | gov.noaa.nmfs.inport:65738 |
Metadata Record Created By: | Brent M Miyamoto |
Metadata Record Created: | 2021-10-28 01:51+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2021-10-29 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2021-10-29 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2022-10-29 |