Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Historical Datasets Metadata Portfolio > Historical Research Pelagics Metadata Portfolio > Longline effort data collected during research... >

RP022AA1_RSCH_V

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:65738 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Longline effort data collected during research cruises between 1950 and 1992 in the Pacific Ocean.

Description

Longline effort data collected during research cruises between 1950 and 1992 in the Pacific Ocean.

Entity Type
Data Table

Data Attribute / Type	Description
DATASET_CODE VARCHAR2	Source ID Code assigned by the data entry staff.
VERSION_CODE VARCHAR2	Code for the format version assigned by the data entry staff.
VESSEL_CODE VARCHAR2	Code for the vessel.
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.
YEAR VARCHAR2	Year of set.
MONTH VARCHAR2	Month of set.
DAY VARCHAR2	Day of set.
SET_TIME_FIRST VARCHAR2	Set time of the first basket.
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).
SET_LATITUDE_DEGREES_FIRST VARCHAR2	Set latitude degrees of the first basket. Units for values are degrees.
SET_LATITUDE_MINUTES_FIRST VARCHAR2	Set latitude minutes of the first basket. Units for values are minutes.
SET_LATITUDE_DIRECTION_FIRST VARCHAR2	Set latitude direction of the first basket. SET_OCTANT used to determine SET_LATITUDE_DIRECTION_FIRST (N/S).
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.
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.
SET_LONGITUDE_MINUTES_FIRST VARCHAR2	Set longitude minutes of the first basket. Units for values are minutes.
SET_LONGITUDE_DIRECTION_FIRST VARCHAR2	Set longitude direction of the first basket. SET_OCTANT used to determine SET_LONGITUDE_DIRECTION_FIRST (E/W).
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.
STATION_NUMBER VARCHAR2	Station number of the longline operation.
SET_LATITUDE_DEGREES_LAST VARCHAR2	Set latitude degrees of the last basket. Units for values are degrees.
SET_LATITUDE_MINUTES_LAST VARCHAR2	Set latitude minutes of the last basket. Units for values are minutes.
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.
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.
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.
SET_LONGITUDE_MINUTES_LAST VARCHAR2	Set longitude minutes of the last basket. Units for values are minutes.
SET_LONGITUDE_DIRECTION_LAST VARCHAR2	Set longitude direction of the last basket. SET_OCTANT used to determine SET_LONGITUDE_DIRECTION_LAST (E/W).
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.
TOTAL_SETTING_TIME VARCHAR2	Total time, in minutes, of setting operation. Units for values are minutes.
HAUL_TIME_FIRST VARCHAR2	Haul time of the first basket.
HAUL_LATITUDE_DEGREES_FIRST VARCHAR2	Haul latitude degrees of the first basket. Units for values are degrees.
HAUL_LATITUDE_MINUTES_FIRST VARCHAR2	Haul latitude minutes of the first basket. Units for values are minutes.
HAUL_LATITUDE_DIRECTION_FIRST VARCHAR2	Haul latitude direction of the first basket. SET_OCTANT used to determine HAUL_LATITUDE_DIRECTION_FIRST (N/S).
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.
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.
HAUL_LONGITUDE_MINUTES_FIRST VARCHAR2	Haul longitude minutes of the first basket. Units for values are minutes.
HAUL_LONGITUDE_DIRECTION_FIRST VARCHAR2	Haul longitude direction of the first basket. SET_OCTANT used to determine HAUL_LONGITUDE_DIRECTION_FIRST (E/W).
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.
HAUL_LATITUDE_DEGREES_LAST VARCHAR2	Haul latitude degrees of the last basket. Units for values are degrees.
HAUL_LATITUDE_MINUTES_LAST VARCHAR2	Haul latitude minutes of the last basket. Units for values are minutes.
HAUL_LATITUDE_DIRECTION_LAST VARCHAR2	Haul latitude direction of the last basket. SET_OCTANT used to determine HAUL_LATITUDE_DIRECTION_LAST (N/S).
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.
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.
HAUL_LONGITUDE_MINUTES_LAST VARCHAR2	Haul longitude minutes of the last basket. Units for values are minutes.
HAUL_LONGITUDE_DIRECTION_LAST VARCHAR2	Haul longitude direction of the last basket. SET_OCTANT used to determine HAUL_LONGITUDE_DIRECTION_LAST (E/W).
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.
ACTUAL_HAULING_TIME VARCHAR2	Actual time, in minutes of the hauling operation. Units for values are minutes.
DIRECTION_SET VARCHAR2	Direction of set, in 10s of degrees, e.g., 272 = 27. Units for values are degrees.
TOTAL_NUMBER_BASKETS_SET VARCHAR2	Total number of baskets set.
NUMBER_HOOKS_PER_BASKET VARCHAR2	Number of hooks per basket.
NUMBER_HOOKS_RETRIEVED VARCHAR2	Number of hooks retrieved.
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.
TIME_ZONE_CODE VARCHAR2	Code for the time zone.
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.
SEQUENCE_NUMBER VARCHAR2	A consecutive number assigned to each record for a block of data.
DATE_LOADED DATE	Date when the record was loaded into Oracle or updated.

Data Attribute / Type

Description

DATASET_CODE
VARCHAR2

Source ID Code assigned by the data entry staff.

VERSION_CODE
VARCHAR2

Code for the format version assigned by the data entry staff.

VESSEL_CODE
VARCHAR2

Code for the vessel.

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.

YEAR
VARCHAR2

Year of set.

MONTH
VARCHAR2

Month of set.

DAY
VARCHAR2

Day of set.

SET_TIME_FIRST
VARCHAR2

Set time of the first basket.

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).

SET_LATITUDE_DEGREES_FIRST
VARCHAR2

Set latitude degrees of the first basket. Units for values are degrees.

SET_LATITUDE_MINUTES_FIRST
VARCHAR2

Set latitude minutes of the first basket. Units for values are minutes.

SET_LATITUDE_DIRECTION_FIRST
VARCHAR2

Set latitude direction of the first basket. SET_OCTANT used to determine SET_LATITUDE_DIRECTION_FIRST (N/S).

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.

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.

SET_LONGITUDE_MINUTES_FIRST
VARCHAR2

Set longitude minutes of the first basket. Units for values are minutes.

SET_LONGITUDE_DIRECTION_FIRST
VARCHAR2

Set longitude direction of the first basket. SET_OCTANT used to determine SET_LONGITUDE_DIRECTION_FIRST (E/W).

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.

STATION_NUMBER
VARCHAR2

Station number of the longline operation.

SET_LATITUDE_DEGREES_LAST
VARCHAR2

Set latitude degrees of the last basket. Units for values are degrees.

SET_LATITUDE_MINUTES_LAST
VARCHAR2

Set latitude minutes of the last basket. Units for values are minutes.

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.

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.

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.

SET_LONGITUDE_MINUTES_LAST
VARCHAR2

Set longitude minutes of the last basket. Units for values are minutes.

SET_LONGITUDE_DIRECTION_LAST
VARCHAR2

Set longitude direction of the last basket. SET_OCTANT used to determine SET_LONGITUDE_DIRECTION_LAST (E/W).

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.

TOTAL_SETTING_TIME
VARCHAR2

Total time, in minutes, of setting operation. Units for values are minutes.

HAUL_TIME_FIRST
VARCHAR2

Haul time of the first basket.

HAUL_LATITUDE_DEGREES_FIRST
VARCHAR2

Haul latitude degrees of the first basket. Units for values are degrees.

HAUL_LATITUDE_MINUTES_FIRST
VARCHAR2

Haul latitude minutes of the first basket. Units for values are minutes.

HAUL_LATITUDE_DIRECTION_FIRST
VARCHAR2

Haul latitude direction of the first basket. SET_OCTANT used to determine HAUL_LATITUDE_DIRECTION_FIRST (N/S).

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.

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.

HAUL_LONGITUDE_MINUTES_FIRST
VARCHAR2

Haul longitude minutes of the first basket. Units for values are minutes.

HAUL_LONGITUDE_DIRECTION_FIRST
VARCHAR2

Haul longitude direction of the first basket. SET_OCTANT used to determine HAUL_LONGITUDE_DIRECTION_FIRST (E/W).

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.

HAUL_LATITUDE_DEGREES_LAST
VARCHAR2

Haul latitude degrees of the last basket. Units for values are degrees.

HAUL_LATITUDE_MINUTES_LAST
VARCHAR2

Haul latitude minutes of the last basket. Units for values are minutes.

HAUL_LATITUDE_DIRECTION_LAST
VARCHAR2

Haul latitude direction of the last basket. SET_OCTANT used to determine HAUL_LATITUDE_DIRECTION_LAST (N/S).

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.

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.

HAUL_LONGITUDE_MINUTES_LAST
VARCHAR2

Haul longitude minutes of the last basket. Units for values are minutes.

HAUL_LONGITUDE_DIRECTION_LAST
VARCHAR2

Haul longitude direction of the last basket. SET_OCTANT used to determine HAUL_LONGITUDE_DIRECTION_LAST (E/W).

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.

ACTUAL_HAULING_TIME
VARCHAR2

Actual time, in minutes of the hauling operation. Units for values are minutes.

DIRECTION_SET
VARCHAR2

Direction of set, in 10s of degrees, e.g., 272 = 27. Units for values are degrees.

TOTAL_NUMBER_BASKETS_SET
VARCHAR2

Total number of baskets set.

NUMBER_HOOKS_PER_BASKET
VARCHAR2

Number of hooks per basket.

NUMBER_HOOKS_RETRIEVED
VARCHAR2

Number of hooks retrieved.

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.

TIME_ZONE_CODE
VARCHAR2

Code for the time zone.

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.

SEQUENCE_NUMBER
VARCHAR2

A consecutive number assigned to each record for a block of data.

DATE_LOADED
DATE

Date when the record was loaded into Oracle or updated.

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

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 Type:	Data Table
Active Version?:	Yes
Description:	Longline effort data collected during research cruises between 1950 and 1992 in the Pacific Ocean.

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.

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

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

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

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

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

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

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

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

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: 1094973

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: 1094974

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: 1094975

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

CC ID: 1094976

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

CC ID: 1094977

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

CC ID: 1094978

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

CC ID: 1094979

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

CC ID: 1094980

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

CC ID: 1094981

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

CC ID: 1094982

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

CC ID: 1094983

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

CC ID: 1094984

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

CC ID: 1094985

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

CC ID: 1094986

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

CC ID: 1094987

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

CC ID: 1094988

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

CC ID: 1094989

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

CC ID: 1094990

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

CC ID: 1094991

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

CC ID: 1094992

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

CC ID: 1094993

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

CC ID: 1094994

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

CC ID: 1094995

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

CC ID: 1094996

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

CC ID: 1094997

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

CC ID: 1094998

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

CC ID: 1094999

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

CC ID: 1095000

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

CC ID: 1095001

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

CC ID: 1095002

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

CC ID: 1095003

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

CC ID: 1095004

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

CC ID: 1095005

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

CC ID: 1095006

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

CC ID: 1095007

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

CC ID: 1095008

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

CC ID: 1095009

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

CC ID: 1095010

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

CC ID: 1095011

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

CC ID: 1095012

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

CC ID: 1095013

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

CC ID: 1095014

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

CC ID: 1095015

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

CC ID: 1095016

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

CC ID: 1095017

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

CC ID: 1095018

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

CC ID: 1095019

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

CC ID: 1095020

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

CC ID: 1095021

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

CC ID: 1095022

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

CC ID: 1095023

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

CC ID: 1095024

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

CC ID: 1095025

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

CC ID: 1095026

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 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

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

DATASET_CODE

VERSION_CODE

VESSEL_CODE

CRUISE_NUMBER

YEAR

MONTH

DAY

SET_TIME_FIRST

SET_OCTANT

SET_LATITUDE_DEGREES_FIRST

SET_LATITUDE_MINUTES_FIRST

SET_LATITUDE_DIRECTION_FIRST

SET_LATITUDE_DD_FIRST

SET_LONGITUDE_DEGREES_FIRST

SET_LONGITUDE_MINUTES_FIRST

SET_LONGITUDE_DIRECTION_FIRST

SET_LONGITUDE_DD_FIRST

STATION_NUMBER

SET_LATITUDE_DEGREES_LAST

SET_LATITUDE_MINUTES_LAST

SET_LATITUDE_DIRECTION_LAST

SET_LATITUDE_DD_LAST

SET_LONGITUDE_DEGREES_LAST

SET_LONGITUDE_MINUTES_LAST

SET_LONGITUDE_DIRECTION_LAST

SET_LONGITUDE_DD_LAST

TOTAL_SETTING_TIME

HAUL_TIME_FIRST

HAUL_LATITUDE_DEGREES_FIRST

HAUL_LATITUDE_MINUTES_FIRST

HAUL_LATITUDE_DIRECTION_FIRST

HAUL_LATITUDE_DD_FIRST

HAUL_LONGITUDE_DEGREES_FIRST

HAUL_LONGITUDE_MINUTES_FIRST

HAUL_LONGITUDE_DIRECTION_FIRST

HAUL_LONGITUDE_DD_FIRST

HAUL_LATITUDE_DEGREES_LAST

HAUL_LATITUDE_MINUTES_LAST

HAUL_LATITUDE_DIRECTION_LAST

HAUL_LATITUDE_DD_LAST

HAUL_LONGITUDE_DEGREES_LAST

HAUL_LONGITUDE_MINUTES_LAST

HAUL_LONGITUDE_DIRECTION_LAST

HAUL_LONGITUDE_DD_LAST

ACTUAL_HAULING_TIME

DIRECTION_SET

TOTAL_NUMBER_BASKETS_SET

NUMBER_HOOKS_PER_BASKET

NUMBER_HOOKS_RETRIEVED

DISTANCE_FROM_LAND

TIME_ZONE_CODE

JOB_NUMBER

SEQUENCE_NUMBER

DATE_LOADED

Catalog Details