Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

View Of Experimental Haul Logs.

Description

View Of Experimental Haul Logs.

Entity Information

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

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: View: POP_HAUL_LOG_EXP_V
Short Name: POP_HAUL_LOG_EXP_V
Status: Completed
Abstract:

View Of Experimental Haul Logs.

Notes:

Loaded by batch 1683, 10-12-2007 05:01

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: POPOL
Description:

View Of Experimental Haul Logs.

Data Attributes

Attribute Summary

Rubric Score Primary Key? 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: 16153
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: 16177
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: 16131
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: 16118
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: 16123
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: 16137
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: 16097
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: 16134
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: 16163
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: 16160
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: 16094
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: 16175
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: 16172
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: 16106
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: 16174
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: 16103
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: 16116
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: 16148
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: 16161
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: 16115
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: 16121
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: 16147
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: 16149
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: 16178
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: 16132
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: 16144
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: 16127
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: 16107
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: 16095
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: 16105
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: 16122
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: 16145
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: 16133
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: 16162
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: 16114
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: 16143
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: 16157
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: 16180
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: 16109
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: 16168
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: 16130
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: 16182
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: 16154
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: 16129
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: 16096
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: 16146
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: 16139
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: 16141
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: 16152
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: 16125
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: 16170
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: 16158
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: 16167
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: 16136
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: 16176
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: 16117
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: 16169
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: 16102
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: 16108
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: 16119
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: 16184
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: 16155
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: 16166
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: 16099
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: 16100
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: 16111
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: 16183
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: 16101
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: 16110
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: 16126
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: 16171
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: 16151
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: 16150
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: 16165
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: 16124
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: 16140
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: 16113
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: 16098
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: 16104
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: 16181
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: 16179
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: 16164
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: 16138
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: 16120
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: 16173
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: 16142
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: 16112
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: 16135
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: 16156
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: 16159
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: 16128
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 Details

Catalog Item ID: 5348
GUID: gov.noaa.nmfs.inport:5348
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-10-12 05:01+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-06
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