RP022AA1_CONF_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:65749 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | RP022AA1_CONF_V |
---|---|
Status: | Completed |
Abstract: |
Longline effort data collected during research cruises between 1952 and 1959 in the Pacific Ocean. |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Description: |
Longline effort data collected during research cruises between 1952 and 1959 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. | |
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. |
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. |
VESSEL_CODE
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the vessel. |
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. |
YEAR
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Year of set. |
MONTH
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Month of set. |
DAY
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Day of set. |
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. |
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). |
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. |
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. |
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). |
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. |
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. |
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. |
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). |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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). |
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. |
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. |
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. |
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. |
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. |
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). |
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. |
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. |
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. |
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). |
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. |
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. |
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. |
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). |
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. |
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. |
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. |
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). |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
Catalog Details
Catalog Item ID: | 65749 |
---|---|
GUID: | gov.noaa.nmfs.inport:65749 |
Metadata Record Created By: | Brent M Miyamoto |
Metadata Record Created: | 2021-10-29 19:00+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 |