Metadata Rubric

100%

6 / 6

SEFSC Metadata Library > Fisheries Statistics Division > Observer Programs > Pelagic Longline Observer Program > PELAGIC OBSERVER PROGRAM (POP). Catch/Effort d... >

View: POP_HAUL_LOG_V

Entity (ENT) | Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:5350 | Updated: June 14, 2024 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Combined View Of Experimental and Non Experimental Haul Logs.

Description

Combined View Of Experimental and Non Experimental Haul Logs.

Entity Type
Data View

Data Attribute / Type	Description
TRIP_NUMBER VARCHAR2	TRIP_NUMBER
LANDING_DATE DATE	Date Of Landing Of The Vessel
HAUL_NUMBER NUMBER	Haul Number
GEAR_CODE VARCHAR2	NMFS Gear Code
WAS_HAUL_OBSERVED VARCHAR2	Was haul observed?
WAS_CATCH VARCHAR2	Were fish caught in the haul?
WAS_INCIDENTAL_TAKE VARCHAR2	Was incidental take?
WEATHER_DESCRIPTION VARCHAR2	Code For Weather Condition at time of the beginning of the haul.
WIND_SPEED NUMBER	In knots at the beginning of the haul.
WIND_DIRECTION VARCHAR2	In compass degrees at the beginning of the haul.
WAVE_HEIGHT NUMBER	Max. Wave Height at the beginning of the haul in feet
REVERSE_HAUL VARCHAR2	The last hook set is the first hook hauled.
GEAR_CONDITION VARCHAR2	Gear Condition at the completion of the haul
STRING_NUMBER NUMBER	STRING_NUMBER Of Parent Gear Log Record.
MAINLINE_LENGTH NUMBER	In nautical miles
SET_SPEED NUMBER	In Knots
BOTTOM_DEPTH_MINIMUM NUMBER	In fathoms.
BOTTOM_DEPTH_MAXIMUM NUMBER	In fathoms.
HOOK_DEPTH_MINIMUM NUMBER	In fathoms
HOOK_DEPTH_MAXIMUM NUMBER	In fathoms
TOTAL_ADDITIONAL_WEIGHT NUMBER	In Pounds
TARGET_SPECIES VARCHAR2	Uses Pop Species Code.
SOAK_DURATION NUMBER	In Hours
WERE_FLOATS_USED VARCHAR2	Were Floats Used
NUMBER_OF_FLOATS NUMBER	Number of floats used during the haul.
WERE_LIGHT_STICKS_USED VARCHAR2	Were Light Sticks Used
NUMBER_LIGHT_STICKS NUMBER	Populated only if were_light_sticks_used is set to yes.
WERE_RATTLERS_USED VARCHAR2	Were Rattlers Used
NUMBER_RATTLERS NUMBER	Populated only if were_rattlers_used is set to yes.
WERE_SURF_LITES_USED VARCHAR2	Were Surf Lites Used
NUMBER_SURF_LITES NUMBER	Populated only if were_surf_lites_used is set to yes.
WERE_RADIO_BEACONS_USED VARCHAR2	Were Radio Beacons Used
NUMBER_RADIO_BEACONS NUMBER	Populated only if were_radio_beacons_used is set to yes.
WERE_RADAR_REFLECTORS_USED VARCHAR2	Were radar relectors used
NUMBER_RADAR_REFLECTORS NUMBER	Populated only if number_radar_reflectors_used is set to yes.
ADDITIONAL_LINE_WEIGHTS_USED VARCHAR2	Were Additional Line Weights used
NUMBER_ADDITIONAL_LINE_WEIGHTS NUMBER	Populated only if addtional_line_weights_used is set to yes.
NUMBER_HOOKS_SET NUMBER	Number of Hooks set
NUMBER_HOOKS_LOST NUMBER	Number of Hooks lost. This should relate to the Gear Condition [POP_GEAR_LOG.GEAR_CONDITION] but it also includes bite offs and cut offs.
NUMBER_HOOKS_TENDED NUMBER	Number of Hooks Pulled during hotlining, which is when the vessel runs the line and pulls hooks where floats are submerged.
NUMBER_HOOKS_REBAITED NUMBER	Number of hooks pulled, rebaited and put back into the water. This is added to set number to get the total hooks for effort analysis.
BAIT_NUMBER_USED_1 NUMBER	Number Of Individual Baits For First Bait indicated for the haul
BAIT_WEIGHT_1 NUMBER	Baith Weight (Units Are In LBS) For First Bait Indicated for the haul
BAIT_KIND_1 VARCHAR2	A code which indicates the kind of bait used with first bait indicated for the haul.
BAIT_TYPE_1 VARCHAR2	A code which indicates the type of bait used/ (Whole, cut, lIve, Other etc) used with the first bait indicated for the haul
BAIT_CONDITION_1 VARCHAR2	The code for the condition of the bait used associated with the first bait indicated for the haul.
BAIT_NUMBER_USED_2 NUMBER	Number Of Individual Baits For Second Bait indicated for the haul
BAIT_WEIGHT_2 NUMBER	Baith Weight (Units Are In LBS) for Second Bait Indicated for the haul
BAIT_KIND_2 VARCHAR2	A code which indicates the kind of bait used with Second bait indicated for the haul.
BAIT_TYPE_2 VARCHAR2	A code which indicates the type of bait used/ (Whole, cut, lIve, Other etc) used with the second bait indicated for the haul
BAIT_CONDITION_2 VARCHAR2	The code for the condition of the bait used associated with the second bait indicated for the haul.
BAIT_NUMBER_USED_3 NUMBER	Number Of Individual Baits For Third Bait indicated for the haul
BAIT_WEIGHT_3 NUMBER	Baith Weight (Units Are In LBS) for the Third Bait Indicated for the Haul
BAIT_KIND_3 VARCHAR2	A code which indicates the kind of bait used with third bait indicated for the haul.
BAIT_TYPE_3 VARCHAR2	A code which indicates the type of bait used/ (Whole, cut, lIve, Other etc) used with the third bait indicated for the haul
BAIT_CONDITION_3 VARCHAR2	The code for the condition of the bait used associated with the third bait indicated for the haul.
BEGIN_SET_DATE DATE	Hours and minutes are included in the time.
BEGIN_SET_LATITUDE NUMBER	Begin Set Latitude Degrees
BEGIN_SET_LATITUDE_MINUTES NUMBER	Begin Set Latitude Minutes
BEGIN_SET_LATITUDE_HEMISPHERE VARCHAR2	Begin Set Latitude Hemisphere.
BEGIN_SET_LONGITUDE NUMBER	Begin Set Longitude Degrees
BEGIN_SET_LONGITUDE_MINUTES NUMBER	Begin Set Longitude Minutes
BEGIN_SET_LONGITUDE_HEMISPHERE VARCHAR2	Begin Set Longitude Hemisphere
BEGIN_SET_TEMPERATURE NUMBER	In Fahrenheit
END_SET_DATE DATE	Hours and minutes are included in the time.
END_SET_LATITUDE NUMBER	End Set Latitude Degrees
END_SET_LATITUDE_MINUTES NUMBER	End Set Latitude Minutes
END_SET_LATITUDE_HEMISPHERE VARCHAR2	End Set Latitude Hemisphere
END_SET_LONGITUDE NUMBER	End Set Longitude Degrees
END_SET_LONGITUDE_MINUTES NUMBER	End Set Longitude Minutes
END_SET_LONGITUDE_HEMISPHERE VARCHAR2	End Set Longitude Hemisphere
END_SET_TEMPERATURE NUMBER	In Fahrenheit
SET_DURATION NUMBER	Set Duration In Hours
BEGIN_HAUL_DATE DATE	Hours and minutes are included in the time.
BEGIN_HAUL_LATITUDE NUMBER	Begin Haul Latitude Degrees
BEGIN_HAUL_LATITUDE_MINUTES NUMBER	Begin Haul Latitude Minutes
BEGIN_HAUL_LATITUDE_HEMISPHERE VARCHAR2	Begin Haul Latitude Hemisphere
BEGIN_HAUL_LONGITUDE NUMBER	Begin Haul Longitude Degrees
BEGIN_HAUL_LONGITUDE_MINUTES NUMBER	Begin Haul Longitude Minutes
BEGIN_HAUL_LONGITUDE_HEMISPHER VARCHAR2	Begin Haul Longitude Hemisphere
BEGIN_HAUL_TEMPERATURE NUMBER	In Fahrenheit
END_HAUL_DATE DATE	Time includes year, date, hours and minutes.
END_HAUL_LATITUDE NUMBER	End Haul Latitude Degrees
END_HAUL_LATITUDE_MINUTES NUMBER	End Haul Latitude Minutes
END_HAUL_LATITUDE_HEMISPHERE VARCHAR2	End Haul Latitude Hemisphere
END_HAUL_LONGITUDE NUMBER	End Haul Longitude Degrees
END_HAUL_LONGITUDE_MINUTES NUMBER	End Haul Longitude Minutes
END_HAUL_LONGITUDE_HEMISPHERE VARCHAR2	End Haul Longitude Hemisphere
END_HAUL_TEMPERATURE NUMBER	In Fahrenheit
HAUL_DURATION NUMBER	In Hours
COMMENTS VARCHAR2	Observer comments about the haul

Data Attribute / Type

Description

TRIP_NUMBER
VARCHAR2

TRIP_NUMBER

LANDING_DATE
DATE

Date Of Landing Of The Vessel

HAUL_NUMBER
NUMBER

Haul Number

GEAR_CODE
VARCHAR2

NMFS Gear Code

WAS_HAUL_OBSERVED
VARCHAR2

Was haul observed?

WAS_CATCH
VARCHAR2

Were fish caught in the haul?

WAS_INCIDENTAL_TAKE
VARCHAR2

Was incidental take?

WEATHER_DESCRIPTION
VARCHAR2

Code For Weather Condition at time of the beginning of the haul.

WIND_SPEED
NUMBER

In knots at the beginning of the haul.

WIND_DIRECTION
VARCHAR2

In compass degrees at the beginning of the haul.

WAVE_HEIGHT
NUMBER

Max. Wave Height at the beginning of the haul in feet

REVERSE_HAUL
VARCHAR2

The last hook set is the first hook hauled.

GEAR_CONDITION
VARCHAR2

Gear Condition at the completion of the haul

STRING_NUMBER
NUMBER

STRING_NUMBER Of Parent Gear Log Record.

MAINLINE_LENGTH
NUMBER

In nautical miles

SET_SPEED
NUMBER

In Knots

BOTTOM_DEPTH_MINIMUM
NUMBER

In fathoms.

BOTTOM_DEPTH_MAXIMUM
NUMBER

In fathoms.

HOOK_DEPTH_MINIMUM
NUMBER

In fathoms

HOOK_DEPTH_MAXIMUM
NUMBER

In fathoms

TOTAL_ADDITIONAL_WEIGHT
NUMBER

In Pounds

TARGET_SPECIES
VARCHAR2

Uses Pop Species Code.

SOAK_DURATION
NUMBER

In Hours

WERE_FLOATS_USED
VARCHAR2

Were Floats Used

NUMBER_OF_FLOATS
NUMBER

Number of floats used during the haul.

WERE_LIGHT_STICKS_USED
VARCHAR2

Were Light Sticks Used

NUMBER_LIGHT_STICKS
NUMBER

Populated only if were_light_sticks_used is set to yes.

WERE_RATTLERS_USED
VARCHAR2

Were Rattlers Used

NUMBER_RATTLERS
NUMBER

Populated only if were_rattlers_used is set to yes.

WERE_SURF_LITES_USED
VARCHAR2

Were Surf Lites Used

NUMBER_SURF_LITES
NUMBER

Populated only if were_surf_lites_used is set to yes.

WERE_RADIO_BEACONS_USED
VARCHAR2

Were Radio Beacons Used

NUMBER_RADIO_BEACONS
NUMBER

Populated only if were_radio_beacons_used is set to yes.

WERE_RADAR_REFLECTORS_USED
VARCHAR2

Were radar relectors used

NUMBER_RADAR_REFLECTORS
NUMBER

Populated only if number_radar_reflectors_used is set to yes.

ADDITIONAL_LINE_WEIGHTS_USED
VARCHAR2

Were Additional Line Weights used

NUMBER_ADDITIONAL_LINE_WEIGHTS
NUMBER

Populated only if addtional_line_weights_used is set to yes.

NUMBER_HOOKS_SET
NUMBER

Number of Hooks set

NUMBER_HOOKS_LOST
NUMBER

Number of Hooks lost. This should relate to the Gear Condition [POP_GEAR_LOG.GEAR_CONDITION] but it also includes bite offs and cut offs.

NUMBER_HOOKS_TENDED
NUMBER

Number of Hooks Pulled during hotlining, which is when the vessel runs the line and pulls hooks where floats are submerged.

NUMBER_HOOKS_REBAITED
NUMBER

Number of hooks pulled, rebaited and put back into the water. This is added to set number to get the total hooks for effort analysis.

BAIT_NUMBER_USED_1
NUMBER

Number Of Individual Baits For First Bait indicated for the haul

BAIT_WEIGHT_1
NUMBER

Baith Weight (Units Are In LBS) For First Bait Indicated for the haul

BAIT_KIND_1
VARCHAR2

A code which indicates the kind of bait used with first bait indicated for the haul.

BAIT_TYPE_1
VARCHAR2

A code which indicates the type of bait used/ (Whole, cut, lIve, Other etc) used with the first bait indicated for the haul

BAIT_CONDITION_1
VARCHAR2

The code for the condition of the bait used associated with the first bait indicated for the haul.

BAIT_NUMBER_USED_2
NUMBER

Number Of Individual Baits For Second Bait indicated for the haul

BAIT_WEIGHT_2
NUMBER

Baith Weight (Units Are In LBS) for Second Bait Indicated for the haul

BAIT_KIND_2
VARCHAR2

A code which indicates the kind of bait used with Second bait indicated for the haul.

BAIT_TYPE_2
VARCHAR2

A code which indicates the type of bait used/ (Whole, cut, lIve, Other etc) used with the second bait indicated for the haul

BAIT_CONDITION_2
VARCHAR2

The code for the condition of the bait used associated with the second bait indicated for the haul.

BAIT_NUMBER_USED_3
NUMBER

Number Of Individual Baits For Third Bait indicated for the haul

BAIT_WEIGHT_3
NUMBER

Baith Weight (Units Are In LBS) for the Third Bait Indicated for the Haul

BAIT_KIND_3
VARCHAR2

A code which indicates the kind of bait used with third bait indicated for the haul.

BAIT_TYPE_3
VARCHAR2

A code which indicates the type of bait used/ (Whole, cut, lIve, Other etc) used with the third bait indicated for the haul

BAIT_CONDITION_3
VARCHAR2

The code for the condition of the bait used associated with the third bait indicated for the haul.

BEGIN_SET_DATE
DATE

Hours and minutes are included in the time.

BEGIN_SET_LATITUDE
NUMBER

Begin Set Latitude Degrees

BEGIN_SET_LATITUDE_MINUTES
NUMBER

Begin Set Latitude Minutes

BEGIN_SET_LATITUDE_HEMISPHERE
VARCHAR2

Begin Set Latitude Hemisphere.

BEGIN_SET_LONGITUDE
NUMBER

Begin Set Longitude Degrees

BEGIN_SET_LONGITUDE_MINUTES
NUMBER

Begin Set Longitude Minutes

BEGIN_SET_LONGITUDE_HEMISPHERE
VARCHAR2

Begin Set Longitude Hemisphere

BEGIN_SET_TEMPERATURE
NUMBER

In Fahrenheit

END_SET_DATE
DATE

Hours and minutes are included in the time.

END_SET_LATITUDE
NUMBER

End Set Latitude Degrees

END_SET_LATITUDE_MINUTES
NUMBER

End Set Latitude Minutes

END_SET_LATITUDE_HEMISPHERE
VARCHAR2

End Set Latitude Hemisphere

END_SET_LONGITUDE
NUMBER

End Set Longitude Degrees

END_SET_LONGITUDE_MINUTES
NUMBER

End Set Longitude Minutes

END_SET_LONGITUDE_HEMISPHERE
VARCHAR2

End Set Longitude Hemisphere

END_SET_TEMPERATURE
NUMBER

In Fahrenheit

SET_DURATION
NUMBER

Set Duration In Hours

BEGIN_HAUL_DATE
DATE

Hours and minutes are included in the time.

BEGIN_HAUL_LATITUDE
NUMBER

Begin Haul Latitude Degrees

BEGIN_HAUL_LATITUDE_MINUTES
NUMBER

Begin Haul Latitude Minutes

BEGIN_HAUL_LATITUDE_HEMISPHERE
VARCHAR2

Begin Haul Latitude Hemisphere

BEGIN_HAUL_LONGITUDE
NUMBER

Begin Haul Longitude Degrees

BEGIN_HAUL_LONGITUDE_MINUTES
NUMBER

Begin Haul Longitude Minutes

BEGIN_HAUL_LONGITUDE_HEMISPHER
VARCHAR2

Begin Haul Longitude Hemisphere

BEGIN_HAUL_TEMPERATURE
NUMBER

In Fahrenheit

END_HAUL_DATE
DATE

Time includes year, date, hours and minutes.

END_HAUL_LATITUDE
NUMBER

End Haul Latitude Degrees

END_HAUL_LATITUDE_MINUTES
NUMBER

End Haul Latitude Minutes

END_HAUL_LATITUDE_HEMISPHERE
VARCHAR2

End Haul Latitude Hemisphere

END_HAUL_LONGITUDE
NUMBER

End Haul Longitude Degrees

END_HAUL_LONGITUDE_MINUTES
NUMBER

End Haul Longitude Minutes

END_HAUL_LONGITUDE_HEMISPHERE
VARCHAR2

End Haul Longitude Hemisphere

END_HAUL_TEMPERATURE
NUMBER

In Fahrenheit

HAUL_DURATION
NUMBER

In Hours

COMMENTS
VARCHAR2

Observer comments about the haul

No Child Items for this record.

No contact information is available for this record.

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

Title:	View: POP_HAUL_LOG_V
Short Name:	POP_HAUL_LOG_V
Status:	Completed
Abstract:	Combined View Of Experimental and Non Experimental Haul Logs.
Notes:	Loaded by batch 1683, 10-12-2007 05:01

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	POPOL
Description:	Combined View Of Experimental and Non Experimental Haul Logs.

Attribute Summary

	Name	Type	Description
100	TRIP_NUMBER	VARCHAR2	TRIP_NUMBER
100	LANDING_DATE	DATE	Date Of Landing Of The Vessel
100	HAUL_NUMBER	NUMBER	Haul Number
100	GEAR_CODE	VARCHAR2	NMFS Gear Code
100	WAS_HAUL_OBSERVED	VARCHAR2	Was haul observed?
100	WAS_CATCH	VARCHAR2	Were fish caught in the haul?
100	WAS_INCIDENTAL_TAKE	VARCHAR2	Was incidental take?
100	WEATHER_DESCRIPTION	VARCHAR2	Code For Weather Condition at time of the beginning of the haul.
100	WIND_SPEED	NUMBER	In knots at the beginning of the haul.
100	WIND_DIRECTION	VARCHAR2	In compass degrees at the beginning of the haul.
100	WAVE_HEIGHT	NUMBER	Max. Wave Height at the beginning of the haul in feet
100	REVERSE_HAUL	VARCHAR2	The last hook set is the first hook hauled.
100	GEAR_CONDITION	VARCHAR2	Gear Condition at the completion of the haul
100	STRING_NUMBER	NUMBER	STRING_NUMBER Of Parent Gear Log Record.
100	MAINLINE_LENGTH	NUMBER	In nautical miles
100	SET_SPEED	NUMBER	In Knots
100	BOTTOM_DEPTH_MINIMUM	NUMBER	In fathoms.
100	BOTTOM_DEPTH_MAXIMUM	NUMBER	In fathoms.
100	HOOK_DEPTH_MINIMUM	NUMBER	In fathoms
100	HOOK_DEPTH_MAXIMUM	NUMBER	In fathoms
100	TOTAL_ADDITIONAL_WEIGHT	NUMBER	In Pounds
100	TARGET_SPECIES	VARCHAR2	Uses Pop Species Code.
100	SOAK_DURATION	NUMBER	In Hours
100	WERE_FLOATS_USED	VARCHAR2	Were Floats Used
100	NUMBER_OF_FLOATS	NUMBER	Number of floats used during the haul.
100	WERE_LIGHT_STICKS_USED	VARCHAR2	Were Light Sticks Used
100	NUMBER_LIGHT_STICKS	NUMBER	Populated only if were_light_sticks_used is set to yes.
100	WERE_RATTLERS_USED	VARCHAR2	Were Rattlers Used
100	NUMBER_RATTLERS	NUMBER	Populated only if were_rattlers_used is set to yes.
100	WERE_SURF_LITES_USED	VARCHAR2	Were Surf Lites Used
100	NUMBER_SURF_LITES	NUMBER	Populated only if were_surf_lites_used is set to yes.
100	WERE_RADIO_BEACONS_USED	VARCHAR2	Were Radio Beacons Used
100	NUMBER_RADIO_BEACONS	NUMBER	Populated only if were_radio_beacons_used is set to yes.
100	WERE_RADAR_REFLECTORS_USED	VARCHAR2	Were radar relectors used
100	NUMBER_RADAR_REFLECTORS	NUMBER	Populated only if number_radar_reflectors_used is set to yes.
100	ADDITIONAL_LINE_WEIGHTS_USED	VARCHAR2	Were Additional Line Weights used
100	NUMBER_ADDITIONAL_LINE_WEIGHTS	NUMBER	Populated only if addtional_line_weights_used is set to yes.
100	NUMBER_HOOKS_SET	NUMBER	Number of Hooks set
100	NUMBER_HOOKS_LOST	NUMBER	Number of Hooks lost. This should relate to the Gear Condition [POP_GEAR_LOG.GEAR_CONDITION] but it also includes bite offs and cut offs.
100	NUMBER_HOOKS_TENDED	NUMBER	Number of Hooks Pulled during hotlining, which is when the vessel runs the line and pulls hooks where floats are submerged.
100	NUMBER_HOOKS_REBAITED	NUMBER	Number of hooks pulled, rebaited and put back into the water. This is added to set number to get the total hooks for effort analysis.
100	BAIT_NUMBER_USED_1	NUMBER	Number Of Individual Baits For First Bait indicated for the haul
100	BAIT_WEIGHT_1	NUMBER	Baith Weight (Units Are In LBS) For First Bait Indicated for the haul
100	BAIT_KIND_1	VARCHAR2	A code which indicates the kind of bait used with first bait indicated for the haul.
100	BAIT_TYPE_1	VARCHAR2	A code which indicates the type of bait used/ (Whole, cut, lIve, Other etc) used with the first bait indicated for the haul
100	BAIT_CONDITION_1	VARCHAR2	The code for the condition of the bait used associated with the first bait indicated for the haul.
100	BAIT_NUMBER_USED_2	NUMBER	Number Of Individual Baits For Second Bait indicated for the haul
100	BAIT_WEIGHT_2	NUMBER	Baith Weight (Units Are In LBS) for Second Bait Indicated for the haul
100	BAIT_KIND_2	VARCHAR2	A code which indicates the kind of bait used with Second bait indicated for the haul.
100	BAIT_TYPE_2	VARCHAR2	A code which indicates the type of bait used/ (Whole, cut, lIve, Other etc) used with the second bait indicated for the haul
100	BAIT_CONDITION_2	VARCHAR2	The code for the condition of the bait used associated with the second bait indicated for the haul.
100	BAIT_NUMBER_USED_3	NUMBER	Number Of Individual Baits For Third Bait indicated for the haul
100	BAIT_WEIGHT_3	NUMBER	Baith Weight (Units Are In LBS) for the Third Bait Indicated for the Haul
100	BAIT_KIND_3	VARCHAR2	A code which indicates the kind of bait used with third bait indicated for the haul.
100	BAIT_TYPE_3	VARCHAR2	A code which indicates the type of bait used/ (Whole, cut, lIve, Other etc) used with the third bait indicated for the haul
100	BAIT_CONDITION_3	VARCHAR2	The code for the condition of the bait used associated with the third bait indicated for the haul.
100	BEGIN_SET_DATE	DATE	Hours and minutes are included in the time.
100	BEGIN_SET_LATITUDE	NUMBER	Begin Set Latitude Degrees
100	BEGIN_SET_LATITUDE_MINUTES	NUMBER	Begin Set Latitude Minutes
100	BEGIN_SET_LATITUDE_HEMISPHERE	VARCHAR2	Begin Set Latitude Hemisphere.
100	BEGIN_SET_LONGITUDE	NUMBER	Begin Set Longitude Degrees
100	BEGIN_SET_LONGITUDE_MINUTES	NUMBER	Begin Set Longitude Minutes
100	BEGIN_SET_LONGITUDE_HEMISPHERE	VARCHAR2	Begin Set Longitude Hemisphere
100	BEGIN_SET_TEMPERATURE	NUMBER	In Fahrenheit
100	END_SET_DATE	DATE	Hours and minutes are included in the time.
100	END_SET_LATITUDE	NUMBER	End Set Latitude Degrees
100	END_SET_LATITUDE_MINUTES	NUMBER	End Set Latitude Minutes
100	END_SET_LATITUDE_HEMISPHERE	VARCHAR2	End Set Latitude Hemisphere
100	END_SET_LONGITUDE	NUMBER	End Set Longitude Degrees
100	END_SET_LONGITUDE_MINUTES	NUMBER	End Set Longitude Minutes
100	END_SET_LONGITUDE_HEMISPHERE	VARCHAR2	End Set Longitude Hemisphere
100	END_SET_TEMPERATURE	NUMBER	In Fahrenheit
100	SET_DURATION	NUMBER	Set Duration In Hours
100	BEGIN_HAUL_DATE	DATE	Hours and minutes are included in the time.
100	BEGIN_HAUL_LATITUDE	NUMBER	Begin Haul Latitude Degrees
100	BEGIN_HAUL_LATITUDE_MINUTES	NUMBER	Begin Haul Latitude Minutes
100	BEGIN_HAUL_LATITUDE_HEMISPHERE	VARCHAR2	Begin Haul Latitude Hemisphere
100	BEGIN_HAUL_LONGITUDE	NUMBER	Begin Haul Longitude Degrees
100	BEGIN_HAUL_LONGITUDE_MINUTES	NUMBER	Begin Haul Longitude Minutes
100	BEGIN_HAUL_LONGITUDE_HEMISPHER	VARCHAR2	Begin Haul Longitude Hemisphere
100	BEGIN_HAUL_TEMPERATURE	NUMBER	In Fahrenheit
100	END_HAUL_DATE	DATE	Time includes year, date, hours and minutes.
100	END_HAUL_LATITUDE	NUMBER	End Haul Latitude Degrees
100	END_HAUL_LATITUDE_MINUTES	NUMBER	End Haul Latitude Minutes
100	END_HAUL_LATITUDE_HEMISPHERE	VARCHAR2	End Haul Latitude Hemisphere
100	END_HAUL_LONGITUDE	NUMBER	End Haul Longitude Degrees
100	END_HAUL_LONGITUDE_MINUTES	NUMBER	End Haul Longitude Minutes
100	END_HAUL_LONGITUDE_HEMISPHERE	VARCHAR2	End Haul Longitude Hemisphere
100	END_HAUL_TEMPERATURE	NUMBER	In Fahrenheit
100	HAUL_DURATION	NUMBER	In Hours
100	COMMENTS	VARCHAR2	Observer comments about the haul

Name

Type

Description

100

TRIP_NUMBER

VARCHAR2

TRIP_NUMBER

100

LANDING_DATE

DATE

Date Of Landing Of The Vessel

100

HAUL_NUMBER

NUMBER

Haul Number

100

GEAR_CODE

VARCHAR2

NMFS Gear Code

100

WAS_HAUL_OBSERVED

VARCHAR2

Was haul observed?

100

WAS_CATCH

VARCHAR2

Were fish caught in the haul?

100

WAS_INCIDENTAL_TAKE

VARCHAR2

Was incidental take?

100

WEATHER_DESCRIPTION

VARCHAR2

Code For Weather Condition at time of the beginning of the haul.

100

WIND_SPEED

NUMBER

In knots at the beginning of the haul.

100

WIND_DIRECTION

VARCHAR2

In compass degrees at the beginning of the haul.

100

WAVE_HEIGHT

NUMBER

Max. Wave Height at the beginning of the haul in feet

100

REVERSE_HAUL

VARCHAR2

The last hook set is the first hook hauled.

100

GEAR_CONDITION

VARCHAR2

Gear Condition at the completion of the haul

100

STRING_NUMBER

NUMBER

STRING_NUMBER Of Parent Gear Log Record.

100

MAINLINE_LENGTH

NUMBER

In nautical miles

100

SET_SPEED

NUMBER

In Knots

100

BOTTOM_DEPTH_MINIMUM

NUMBER

In fathoms.

100

BOTTOM_DEPTH_MAXIMUM

NUMBER

In fathoms.

100

HOOK_DEPTH_MINIMUM

NUMBER

In fathoms

100

HOOK_DEPTH_MAXIMUM

NUMBER

In fathoms

100

TOTAL_ADDITIONAL_WEIGHT

NUMBER

In Pounds

100

TARGET_SPECIES

VARCHAR2

Uses Pop Species Code.

100

SOAK_DURATION

NUMBER

In Hours

100

WERE_FLOATS_USED

VARCHAR2

Were Floats Used

100

NUMBER_OF_FLOATS

NUMBER

Number of floats used during the haul.

100

WERE_LIGHT_STICKS_USED

VARCHAR2

Were Light Sticks Used

100

NUMBER_LIGHT_STICKS

NUMBER

Populated only if were_light_sticks_used is set to yes.

100

WERE_RATTLERS_USED

VARCHAR2

Were Rattlers Used

100

NUMBER_RATTLERS

NUMBER

Populated only if were_rattlers_used is set to yes.

100

WERE_SURF_LITES_USED

VARCHAR2

Were Surf Lites Used

100

NUMBER_SURF_LITES

NUMBER

Populated only if were_surf_lites_used is set to yes.

100

WERE_RADIO_BEACONS_USED

VARCHAR2

Were Radio Beacons Used

100

NUMBER_RADIO_BEACONS

NUMBER

Populated only if were_radio_beacons_used is set to yes.

100

WERE_RADAR_REFLECTORS_USED

VARCHAR2

Were radar relectors used

100

NUMBER_RADAR_REFLECTORS

NUMBER

Populated only if number_radar_reflectors_used is set to yes.

100

ADDITIONAL_LINE_WEIGHTS_USED

VARCHAR2

Were Additional Line Weights used

100

NUMBER_ADDITIONAL_LINE_WEIGHTS

NUMBER

Populated only if addtional_line_weights_used is set to yes.

100

NUMBER_HOOKS_SET

NUMBER

Number of Hooks set

100

NUMBER_HOOKS_LOST

NUMBER

Number of Hooks lost. This should relate to the Gear Condition [POP_GEAR_LOG.GEAR_CONDITION] but it also includes bite offs and cut offs.

100

NUMBER_HOOKS_TENDED

NUMBER

Number of Hooks Pulled during hotlining, which is when the vessel runs the line and pulls hooks where floats are submerged.

100

NUMBER_HOOKS_REBAITED

NUMBER

Number of hooks pulled, rebaited and put back into the water. This is added to set number to get the total hooks for effort analysis.

100

BAIT_NUMBER_USED_1

NUMBER

Number Of Individual Baits For First Bait indicated for the haul

100

BAIT_WEIGHT_1

NUMBER

Baith Weight (Units Are In LBS) For First Bait Indicated for the haul

100

BAIT_KIND_1

VARCHAR2

A code which indicates the kind of bait used with first bait indicated for the haul.

100

BAIT_TYPE_1

VARCHAR2

A code which indicates the type of bait used/ (Whole, cut, lIve, Other etc) used with the first bait indicated for the haul

100

BAIT_CONDITION_1

VARCHAR2

The code for the condition of the bait used associated with the first bait indicated for the haul.

100

BAIT_NUMBER_USED_2

NUMBER

Number Of Individual Baits For Second Bait indicated for the haul

100

BAIT_WEIGHT_2

NUMBER

Baith Weight (Units Are In LBS) for Second Bait Indicated for the haul

100

BAIT_KIND_2

VARCHAR2

A code which indicates the kind of bait used with Second bait indicated for the haul.

100

BAIT_TYPE_2

VARCHAR2

A code which indicates the type of bait used/ (Whole, cut, lIve, Other etc) used with the second bait indicated for the haul

100

BAIT_CONDITION_2

VARCHAR2

The code for the condition of the bait used associated with the second bait indicated for the haul.

100

BAIT_NUMBER_USED_3

NUMBER

Number Of Individual Baits For Third Bait indicated for the haul

100

BAIT_WEIGHT_3

NUMBER

Baith Weight (Units Are In LBS) for the Third Bait Indicated for the Haul

100

BAIT_KIND_3

VARCHAR2

A code which indicates the kind of bait used with third bait indicated for the haul.

100

BAIT_TYPE_3

VARCHAR2

A code which indicates the type of bait used/ (Whole, cut, lIve, Other etc) used with the third bait indicated for the haul

100

BAIT_CONDITION_3

VARCHAR2

The code for the condition of the bait used associated with the third bait indicated for the haul.

100

BEGIN_SET_DATE

DATE

Hours and minutes are included in the time.

100

BEGIN_SET_LATITUDE

NUMBER

Begin Set Latitude Degrees

100

BEGIN_SET_LATITUDE_MINUTES

NUMBER

Begin Set Latitude Minutes

100

BEGIN_SET_LATITUDE_HEMISPHERE

VARCHAR2

Begin Set Latitude Hemisphere.

100

BEGIN_SET_LONGITUDE

NUMBER

Begin Set Longitude Degrees

100

BEGIN_SET_LONGITUDE_MINUTES

NUMBER

Begin Set Longitude Minutes

100

BEGIN_SET_LONGITUDE_HEMISPHERE

VARCHAR2

Begin Set Longitude Hemisphere

100

BEGIN_SET_TEMPERATURE

NUMBER

In Fahrenheit

100

END_SET_DATE

DATE

Hours and minutes are included in the time.

100

END_SET_LATITUDE

NUMBER

End Set Latitude Degrees

100

END_SET_LATITUDE_MINUTES

NUMBER

End Set Latitude Minutes

100

END_SET_LATITUDE_HEMISPHERE

VARCHAR2

End Set Latitude Hemisphere

100

END_SET_LONGITUDE

NUMBER

End Set Longitude Degrees

100

END_SET_LONGITUDE_MINUTES

NUMBER

End Set Longitude Minutes

100

END_SET_LONGITUDE_HEMISPHERE

VARCHAR2

End Set Longitude Hemisphere

100

END_SET_TEMPERATURE

NUMBER

In Fahrenheit

100

SET_DURATION

NUMBER

Set Duration In Hours

100

BEGIN_HAUL_DATE

DATE

Hours and minutes are included in the time.

100

BEGIN_HAUL_LATITUDE

NUMBER

Begin Haul Latitude Degrees

100

BEGIN_HAUL_LATITUDE_MINUTES

NUMBER

Begin Haul Latitude Minutes

100

BEGIN_HAUL_LATITUDE_HEMISPHERE

VARCHAR2

Begin Haul Latitude Hemisphere

100

BEGIN_HAUL_LONGITUDE

NUMBER

Begin Haul Longitude Degrees

100

BEGIN_HAUL_LONGITUDE_MINUTES

NUMBER

Begin Haul Longitude Minutes

100

BEGIN_HAUL_LONGITUDE_HEMISPHER

VARCHAR2

Begin Haul Longitude Hemisphere

100

BEGIN_HAUL_TEMPERATURE

NUMBER

In Fahrenheit

100

END_HAUL_DATE

DATE

Time includes year, date, hours and minutes.

100

END_HAUL_LATITUDE

NUMBER

End Haul Latitude Degrees

100

END_HAUL_LATITUDE_MINUTES

NUMBER

End Haul Latitude Minutes

100

END_HAUL_LATITUDE_HEMISPHERE

VARCHAR2

End Haul Latitude Hemisphere

100

END_HAUL_LONGITUDE

NUMBER

End Haul Longitude Degrees

100

END_HAUL_LONGITUDE_MINUTES

NUMBER

End Haul Longitude Minutes

100

END_HAUL_LONGITUDE_HEMISPHERE

VARCHAR2

End Haul Longitude Hemisphere

100

END_HAUL_TEMPERATURE

NUMBER

In Fahrenheit

100

HAUL_DURATION

NUMBER

In Hours

100

COMMENTS

VARCHAR2

Observer comments about the haul

Attribute Details

TRIP_NUMBER

CC ID: 16347

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	Yes
Primary Key:	No
Status:	Active
Description:	TRIP_NUMBER
General Data Type:	VARCHAR2

LANDING_DATE

CC ID: 16289

Seq. Order:	2
Data Storage Type:	DATE
Max Length:	7
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Date Of Landing Of The Vessel
General Data Type:	DATE

HAUL_NUMBER

CC ID: 16339

Seq. Order:	3
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Haul Number
General Data Type:	NUMBER

GEAR_CODE

CC ID: 16348

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	Yes
Primary Key:	No
Status:	Active
Description:	NMFS Gear Code
General Data Type:	VARCHAR2

WAS_HAUL_OBSERVED

CC ID: 16366

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Was haul observed?
General Data Type:	VARCHAR2

WAS_CATCH

CC ID: 16337

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Were fish caught in the haul?
General Data Type:	VARCHAR2

WAS_INCIDENTAL_TAKE

CC ID: 16361

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Was incidental take?
General Data Type:	VARCHAR2

WEATHER_DESCRIPTION

CC ID: 16279

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Code For Weather Condition at time of the beginning of the haul.
General Data Type:	VARCHAR2

WIND_SPEED

CC ID: 16298

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	In knots at the beginning of the haul.
General Data Type:	NUMBER

WIND_DIRECTION

CC ID: 16304

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	In compass degrees at the beginning of the haul.
General Data Type:	VARCHAR2

WAVE_HEIGHT

CC ID: 16364

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Max. Wave Height at the beginning of the haul in feet
General Data Type:	NUMBER

REVERSE_HAUL

CC ID: 16303

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	The last hook set is the first hook hauled.
General Data Type:	VARCHAR2

GEAR_CONDITION

CC ID: 16318

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Gear Condition at the completion of the haul
General Data Type:	VARCHAR2

STRING_NUMBER

CC ID: 16338

Seq. Order:	14
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	1
Scale:	0
Status:	Active
Description:	STRING_NUMBER Of Parent Gear Log Record.
General Data Type:	NUMBER

MAINLINE_LENGTH

CC ID: 16295

Seq. Order:	15
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	1
Status:	Active
Description:	In nautical miles
General Data Type:	NUMBER

SET_SPEED

CC ID: 16281

Seq. Order:	16
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	1
Status:	Active
Description:	In Knots
General Data Type:	NUMBER

BOTTOM_DEPTH_MINIMUM

CC ID: 16346

Seq. Order:	17
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	In fathoms.
General Data Type:	NUMBER

BOTTOM_DEPTH_MAXIMUM

CC ID: 16319

Seq. Order:	18
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	In fathoms.
General Data Type:	NUMBER

HOOK_DEPTH_MINIMUM

CC ID: 16301

Seq. Order:	19
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	In fathoms
General Data Type:	NUMBER

HOOK_DEPTH_MAXIMUM

CC ID: 16283

Seq. Order:	20
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	In fathoms
General Data Type:	NUMBER

TOTAL_ADDITIONAL_WEIGHT

CC ID: 16352

Seq. Order:	21
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	0
Status:	Active
Description:	In Pounds
General Data Type:	NUMBER

TARGET_SPECIES

CC ID: 16286

Seq. Order:	22
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Uses Pop Species Code.
General Data Type:	VARCHAR2

SOAK_DURATION

CC ID: 16354

Seq. Order:	23
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	1
Status:	Active
Description:	In Hours
General Data Type:	NUMBER

WERE_FLOATS_USED

CC ID: 16326

Seq. Order:	24
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Were Floats Used
General Data Type:	VARCHAR2

NUMBER_OF_FLOATS

CC ID: 16280

Seq. Order:	25
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Number of floats used during the haul.
General Data Type:	NUMBER

WERE_LIGHT_STICKS_USED

CC ID: 16325

Seq. Order:	26
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Were Light Sticks Used
General Data Type:	VARCHAR2

NUMBER_LIGHT_STICKS

CC ID: 16309

Seq. Order:	27
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Populated only if were_light_sticks_used is set to yes.
General Data Type:	NUMBER

WERE_RATTLERS_USED

CC ID: 16276

Seq. Order:	28
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Were Rattlers Used
General Data Type:	VARCHAR2

NUMBER_RATTLERS

CC ID: 16343

Seq. Order:	29
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Populated only if were_rattlers_used is set to yes.
General Data Type:	NUMBER

WERE_SURF_LITES_USED

CC ID: 16344

Seq. Order:	30
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Were Surf Lites Used
General Data Type:	VARCHAR2

NUMBER_SURF_LITES

CC ID: 16351

Seq. Order:	31
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Populated only if were_surf_lites_used is set to yes.
General Data Type:	NUMBER

WERE_RADIO_BEACONS_USED

CC ID: 16321

Seq. Order:	32
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Were Radio Beacons Used
General Data Type:	VARCHAR2

NUMBER_RADIO_BEACONS

CC ID: 16317

Seq. Order:	33
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Populated only if were_radio_beacons_used is set to yes.
General Data Type:	NUMBER

WERE_RADAR_REFLECTORS_USED

CC ID: 16358

Seq. Order:	34
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Were radar relectors used
General Data Type:	VARCHAR2

NUMBER_RADAR_REFLECTORS

CC ID: 16350

Seq. Order:	35
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Populated only if number_radar_reflectors_used is set to yes.
General Data Type:	NUMBER

ADDITIONAL_LINE_WEIGHTS_USED

CC ID: 16314

Seq. Order:	36
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Were Additional Line Weights used
General Data Type:	VARCHAR2

NUMBER_ADDITIONAL_LINE_WEIGHTS

CC ID: 16277

Seq. Order:	37
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Populated only if addtional_line_weights_used is set to yes.
General Data Type:	NUMBER

NUMBER_HOOKS_SET

CC ID: 16300

Seq. Order:	38
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Number of Hooks set
General Data Type:	NUMBER

NUMBER_HOOKS_LOST

CC ID: 16349

Seq. Order:	39
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Number of Hooks lost. This should relate to the Gear Condition [POP_GEAR_LOG.GEAR_CONDITION] but it also includes bite offs and cut offs.
General Data Type:	NUMBER

NUMBER_HOOKS_TENDED

CC ID: 16329

Seq. Order:	40
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Number of Hooks Pulled during hotlining, which is when the vessel runs the line and pulls hooks where floats are submerged.
General Data Type:	NUMBER

NUMBER_HOOKS_REBAITED

CC ID: 16363

Seq. Order:	41
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Number of hooks pulled, rebaited and put back into the water. This is added to set number to get the total hooks for effort analysis.
General Data Type:	NUMBER

BAIT_NUMBER_USED_1

CC ID: 16290

Seq. Order:	42
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Number Of Individual Baits For First Bait indicated for the haul
General Data Type:	NUMBER

BAIT_WEIGHT_1

CC ID: 16293

Seq. Order:	43
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Baith Weight (Units Are In LBS) For First Bait Indicated for the haul
General Data Type:	NUMBER

BAIT_KIND_1

CC ID: 16362

Seq. Order:	44
Data Storage Type:	VARCHAR2
Max Length:	4000
Required:	No
Primary Key:	No
Status:	Active
Description:	A code which indicates the kind of bait used with first bait indicated for the haul.
General Data Type:	VARCHAR2

BAIT_TYPE_1

CC ID: 16360

Seq. Order:	45
Data Storage Type:	VARCHAR2
Max Length:	4000
Required:	No
Primary Key:	No
Status:	Active
Description:	A code which indicates the type of bait used/ (Whole, cut, lIve, Other etc) used with the first bait indicated for the haul
General Data Type:	VARCHAR2

BAIT_CONDITION_1

CC ID: 16332

Seq. Order:	46
Data Storage Type:	VARCHAR2
Max Length:	4000
Required:	No
Primary Key:	No
Status:	Active
Description:	The code for the condition of the bait used associated with the first bait indicated for the haul.
General Data Type:	VARCHAR2

BAIT_NUMBER_USED_2

CC ID: 16323

Seq. Order:	47
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Number Of Individual Baits For Second Bait indicated for the haul
General Data Type:	NUMBER

BAIT_WEIGHT_2

CC ID: 16284

Seq. Order:	48
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Baith Weight (Units Are In LBS) for Second Bait Indicated for the haul
General Data Type:	NUMBER

BAIT_KIND_2

CC ID: 16334

Seq. Order:	49
Data Storage Type:	VARCHAR2
Max Length:	4000
Required:	No
Primary Key:	No
Status:	Active
Description:	A code which indicates the kind of bait used with Second bait indicated for the haul.
General Data Type:	VARCHAR2

BAIT_TYPE_2

CC ID: 16315

Seq. Order:	50
Data Storage Type:	VARCHAR2
Max Length:	4000
Required:	No
Primary Key:	No
Status:	Active
Description:	A code which indicates the type of bait used/ (Whole, cut, lIve, Other etc) used with the second bait indicated for the haul
General Data Type:	VARCHAR2

BAIT_CONDITION_2

CC ID: 16322

Seq. Order:	51
Data Storage Type:	VARCHAR2
Max Length:	4000
Required:	No
Primary Key:	No
Status:	Active
Description:	The code for the condition of the bait used associated with the second bait indicated for the haul.
General Data Type:	VARCHAR2

BAIT_NUMBER_USED_3

CC ID: 16288

Seq. Order:	52
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Number Of Individual Baits For Third Bait indicated for the haul
General Data Type:	NUMBER

BAIT_WEIGHT_3

CC ID: 16316

Seq. Order:	53
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Baith Weight (Units Are In LBS) for the Third Bait Indicated for the Haul
General Data Type:	NUMBER

BAIT_KIND_3

CC ID: 16311

Seq. Order:	54
Data Storage Type:	VARCHAR2
Max Length:	4000
Required:	No
Primary Key:	No
Status:	Active
Description:	A code which indicates the kind of bait used with third bait indicated for the haul.
General Data Type:	VARCHAR2

BAIT_TYPE_3

CC ID: 16355

Seq. Order:	55
Data Storage Type:	VARCHAR2
Max Length:	4000
Required:	No
Primary Key:	No
Status:	Active
Description:	A code which indicates the type of bait used/ (Whole, cut, lIve, Other etc) used with the third bait indicated for the haul
General Data Type:	VARCHAR2

BAIT_CONDITION_3

CC ID: 16331

Seq. Order:	56
Data Storage Type:	VARCHAR2
Max Length:	4000
Required:	No
Primary Key:	No
Status:	Active
Description:	The code for the condition of the bait used associated with the third bait indicated for the haul.
General Data Type:	VARCHAR2

BEGIN_SET_DATE

CC ID: 16285

Seq. Order:	57
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Hours and minutes are included in the time.
General Data Type:	DATE

BEGIN_SET_LATITUDE

CC ID: 16306

Seq. Order:	58
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Begin Set Latitude Degrees
General Data Type:	NUMBER

BEGIN_SET_LATITUDE_MINUTES

CC ID: 16336

Seq. Order:	59
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Begin Set Latitude Minutes
General Data Type:	NUMBER

BEGIN_SET_LATITUDE_HEMISPHERE

CC ID: 16356

Seq. Order:	60
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Begin Set Latitude Hemisphere.
General Data Type:	VARCHAR2

BEGIN_SET_LONGITUDE

CC ID: 16299

Seq. Order:	61
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Begin Set Longitude Degrees
General Data Type:	NUMBER

BEGIN_SET_LONGITUDE_MINUTES

CC ID: 16357

Seq. Order:	62
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Begin Set Longitude Minutes
General Data Type:	NUMBER

BEGIN_SET_LONGITUDE_HEMISPHERE

CC ID: 16359

Seq. Order:	63
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Begin Set Longitude Hemisphere
General Data Type:	VARCHAR2

BEGIN_SET_TEMPERATURE

CC ID: 16327

Seq. Order:	64
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	1
Status:	Active
Description:	In Fahrenheit
General Data Type:	NUMBER

END_SET_DATE

CC ID: 16287

Seq. Order:	65
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Hours and minutes are included in the time.
General Data Type:	DATE

END_SET_LATITUDE

CC ID: 16330

Seq. Order:	66
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	End Set Latitude Degrees
General Data Type:	NUMBER

END_SET_LATITUDE_MINUTES

CC ID: 16278

Seq. Order:	67
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	End Set Latitude Minutes
General Data Type:	NUMBER

END_SET_LATITUDE_HEMISPHERE

CC ID: 16328

Seq. Order:	68
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	End Set Latitude Hemisphere
General Data Type:	VARCHAR2

END_SET_LONGITUDE

CC ID: 16296

Seq. Order:	69
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	End Set Longitude Degrees
General Data Type:	NUMBER

END_SET_LONGITUDE_MINUTES

CC ID: 16294

Seq. Order:	70
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	End Set Longitude Minutes
General Data Type:	NUMBER

END_SET_LONGITUDE_HEMISPHERE

CC ID: 16313

Seq. Order:	71
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	End Set Longitude Hemisphere
General Data Type:	VARCHAR2

END_SET_TEMPERATURE

CC ID: 16308

Seq. Order:	72
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	1
Status:	Active
Description:	In Fahrenheit
General Data Type:	NUMBER

SET_DURATION

CC ID: 16302

Seq. Order:	73
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	1
Status:	Active
Description:	Set Duration In Hours
General Data Type:	NUMBER

BEGIN_HAUL_DATE

CC ID: 16320

Seq. Order:	74
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Hours and minutes are included in the time.
General Data Type:	DATE

BEGIN_HAUL_LATITUDE

CC ID: 16297

Seq. Order:	75
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Begin Haul Latitude Degrees
General Data Type:	NUMBER

BEGIN_HAUL_LATITUDE_MINUTES

CC ID: 16307

Seq. Order:	76
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Begin Haul Latitude Minutes
General Data Type:	NUMBER

BEGIN_HAUL_LATITUDE_HEMISPHERE

CC ID: 16342

Seq. Order:	77
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Begin Haul Latitude Hemisphere
General Data Type:	VARCHAR2

BEGIN_HAUL_LONGITUDE

CC ID: 16310

Seq. Order:	78
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Begin Haul Longitude Degrees
General Data Type:	NUMBER

BEGIN_HAUL_LONGITUDE_MINUTES

CC ID: 16341

Seq. Order:	79
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Begin Haul Longitude Minutes
General Data Type:	NUMBER

BEGIN_HAUL_LONGITUDE_HEMISPHER

CC ID: 16305

Seq. Order:	80
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Begin Haul Longitude Hemisphere
General Data Type:	VARCHAR2

BEGIN_HAUL_TEMPERATURE

CC ID: 16291

Seq. Order:	81
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	1
Status:	Active
Description:	In Fahrenheit
General Data Type:	NUMBER

END_HAUL_DATE

CC ID: 16345

Seq. Order:	82
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Time includes year, date, hours and minutes.
General Data Type:	DATE

END_HAUL_LATITUDE

CC ID: 16282

Seq. Order:	83
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	End Haul Latitude Degrees
General Data Type:	NUMBER

END_HAUL_LATITUDE_MINUTES

CC ID: 16365

Seq. Order:	84
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	End Haul Latitude Minutes
General Data Type:	NUMBER

END_HAUL_LATITUDE_HEMISPHERE

CC ID: 16340

Seq. Order:	85
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	End Haul Latitude Hemisphere
General Data Type:	VARCHAR2

END_HAUL_LONGITUDE

CC ID: 16292

Seq. Order:	86
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	End Haul Longitude Degrees
General Data Type:	NUMBER

END_HAUL_LONGITUDE_MINUTES

CC ID: 16312

Seq. Order:	87
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	End Haul Longitude Minutes
General Data Type:	NUMBER

END_HAUL_LONGITUDE_HEMISPHERE

CC ID: 16333

Seq. Order:	88
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	End Haul Longitude Hemisphere
General Data Type:	VARCHAR2

END_HAUL_TEMPERATURE

CC ID: 16335

Seq. Order:	89
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	1
Status:	Active
Description:	In Fahrenheit
General Data Type:	NUMBER

HAUL_DURATION

CC ID: 16353

Seq. Order:	90
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	1
Status:	Active
Description:	In Hours
General Data Type:	NUMBER

COMMENTS

CC ID: 16324

Seq. Order:	91
Data Storage Type:	VARCHAR2
Max Length:	2000
Required:	No
Primary Key:	No
Status:	Active
Description:	Observer comments about the haul
General Data Type:	VARCHAR2

Catalog Item ID:	5350
GUID:	gov.noaa.nmfs.inport:5350
Metadata Record Created By:	Lee M Weinberger
Metadata Record Created:	2007-10-12 05:01+0000
Metadata Record Last Modified By:	Lee M Weinberger
Metadata Record Last Modified:	2024-06-14 13:53+0000
Metadata Record Published:	2024-06-14
Owner Org:	SEFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2021-05-06
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2022-05-06

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

TRIP_NUMBER

LANDING_DATE

HAUL_NUMBER

GEAR_CODE

WAS_HAUL_OBSERVED

WAS_CATCH

WAS_INCIDENTAL_TAKE

WEATHER_DESCRIPTION

WIND_SPEED

WIND_DIRECTION

WAVE_HEIGHT

REVERSE_HAUL

GEAR_CONDITION

STRING_NUMBER

MAINLINE_LENGTH

SET_SPEED

BOTTOM_DEPTH_MINIMUM

BOTTOM_DEPTH_MAXIMUM

HOOK_DEPTH_MINIMUM

HOOK_DEPTH_MAXIMUM

TOTAL_ADDITIONAL_WEIGHT

TARGET_SPECIES

SOAK_DURATION

WERE_FLOATS_USED

NUMBER_OF_FLOATS

WERE_LIGHT_STICKS_USED

NUMBER_LIGHT_STICKS

WERE_RATTLERS_USED

NUMBER_RATTLERS

WERE_SURF_LITES_USED

NUMBER_SURF_LITES

WERE_RADIO_BEACONS_USED

NUMBER_RADIO_BEACONS

WERE_RADAR_REFLECTORS_USED

NUMBER_RADAR_REFLECTORS

ADDITIONAL_LINE_WEIGHTS_USED

NUMBER_ADDITIONAL_LINE_WEIGHTS

NUMBER_HOOKS_SET

NUMBER_HOOKS_LOST

NUMBER_HOOKS_TENDED

NUMBER_HOOKS_REBAITED

BAIT_NUMBER_USED_1

BAIT_WEIGHT_1

BAIT_KIND_1

BAIT_TYPE_1

BAIT_CONDITION_1

BAIT_NUMBER_USED_2

BAIT_WEIGHT_2

BAIT_KIND_2

BAIT_TYPE_2

BAIT_CONDITION_2

BAIT_NUMBER_USED_3

BAIT_WEIGHT_3

BAIT_KIND_3

BAIT_TYPE_3

BAIT_CONDITION_3

BEGIN_SET_DATE

BEGIN_SET_LATITUDE

BEGIN_SET_LATITUDE_MINUTES

BEGIN_SET_LATITUDE_HEMISPHERE

BEGIN_SET_LONGITUDE

BEGIN_SET_LONGITUDE_MINUTES

BEGIN_SET_LONGITUDE_HEMISPHERE

BEGIN_SET_TEMPERATURE

END_SET_DATE

END_SET_LATITUDE

END_SET_LATITUDE_MINUTES

END_SET_LATITUDE_HEMISPHERE

END_SET_LONGITUDE

END_SET_LONGITUDE_MINUTES

END_SET_LONGITUDE_HEMISPHERE