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

Summary

Abstract

Haul Log Information

Description

Haul Log Information

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
GEAR_LOG_KEY
NUMBER
Gear Log Key
HAUL_LOG_KEY
NUMBER
Primary Key
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
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.
BEGIN_SET_DATE
DATE
Hours and minutes are included in the time.
END_SET_DATE
DATE
Hours and minutes are included in the time.
BEGIN_HAUL_DATE
DATE
Hours and minutes are included in the time.
END_HAUL_DATE
DATE
Time includes year, date, hours and minutes.
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.
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
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
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
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
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
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
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
BEGIN_SET_TEMPERATURE
NUMBER
In Fahrenheit
END_SET_TEMPERATURE
NUMBER
In Fahrenheit
BEGIN_HAUL_TEMPERATURE
NUMBER
In Fahrenheit
END_HAUL_TEMPERATURE
NUMBER
In Fahrenheit
SET_DURATION
NUMBER
Set Duration In Hours
HAUL_LOST_TIME
NUMBER
Time Lost During Haul. (In Hours)
HAUL_DURATION
NUMBER
In Hours
FISHING_AREA
VARCHAR2
Fishing Area
EXPERIMENTAL_TREATMENT
VARCHAR2
Refers to certain experimental PLOP data.The value assigned here is defined by experimental parameters that can be gotten from Cheryl Brown.
COMMENTS
VARCHAR2
Observer comments about the haul
IS_EXPERIMENT
VARCHAR2
Is an experimental haul?
CREATED_BY_USER_ID
VARCHAR2
Created by whom
CREATED_DATE
DATE
Created when
MODIFIED_BY_USER_ID
VARCHAR2
Modified by whom
MODIFIED_DATE
DATE
Modified when

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: Table: POP_HAUL_LOG
Short Name: POP_HAUL_LOG
Status: Completed
Abstract:

Haul Log Information

Notes:

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

Physical Location

Organization: Southeast Fisheries Science Center
City: Miami
State/Province: FL
Country: USA

Entity Information

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

Haul Log Information

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
GEAR_LOG_KEY NUMBER Gear Log Key
100
Primary Key HAUL_LOG_KEY NUMBER Primary Key
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
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
BEGIN_SET_DATE DATE Hours and minutes are included in the time.
100
END_SET_DATE DATE Hours and minutes are included in the time.
100
BEGIN_HAUL_DATE DATE Hours and minutes are included in the time.
100
END_HAUL_DATE DATE Time includes year, date, hours and minutes.
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
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
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
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
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
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
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
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
BEGIN_SET_TEMPERATURE NUMBER In Fahrenheit
100
END_SET_TEMPERATURE NUMBER In Fahrenheit
100
BEGIN_HAUL_TEMPERATURE NUMBER In Fahrenheit
100
END_HAUL_TEMPERATURE NUMBER In Fahrenheit
100
SET_DURATION NUMBER Set Duration In Hours
100
HAUL_LOST_TIME NUMBER Time Lost During Haul. (In Hours)
100
HAUL_DURATION NUMBER In Hours
100
FISHING_AREA VARCHAR2 Fishing Area
100
EXPERIMENTAL_TREATMENT VARCHAR2 Refers to certain experimental PLOP data.The value assigned here is defined by experimental parameters that can be gotten from Cheryl Brown.
100
COMMENTS VARCHAR2 Observer comments about the haul
100
IS_EXPERIMENT VARCHAR2 Is an experimental haul?
100
CREATED_BY_USER_ID VARCHAR2 Created by whom
100
CREATED_DATE DATE Created when
100
MODIFIED_BY_USER_ID VARCHAR2 Modified by whom
100
MODIFIED_DATE DATE Modified when

Attribute Details

GEAR_LOG_KEY

CC ID: 16093
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Gear Log Key

General Data Type: NUMBER

HAUL_LOG_KEY

CC ID: 16092
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 10
Scale: 0
Status: Active
Description:

Primary Key

General Data Type: NUMBER

HAUL_NUMBER

CC ID: 16091
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: 16090
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: 16089
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: 16088
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: 16087
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: 16086
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: 16085
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: 16084
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: 16083
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: 16082
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: 16081
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

MAINLINE_LENGTH

CC ID: 16080
Seq. Order: 14
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: 16079
Seq. Order: 15
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: 16078
Seq. Order: 16
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: 16077
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

HOOK_DEPTH_MINIMUM

CC ID: 16076
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_MAXIMUM

CC ID: 16075
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

TOTAL_ADDITIONAL_WEIGHT

CC ID: 16074
Seq. Order: 20
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: 16073
Seq. Order: 21
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: 16072
Seq. Order: 22
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: 16071
Seq. Order: 23
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: 16070
Seq. Order: 24
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: 16069
Seq. Order: 25
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: 16068
Seq. Order: 26
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: 16067
Seq. Order: 27
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: 16066
Seq. Order: 28
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: 16065
Seq. Order: 29
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: 16064
Seq. Order: 30
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: 16063
Seq. Order: 31
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: 16062
Seq. Order: 32
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: 16061
Seq. Order: 33
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: 16060
Seq. Order: 34
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: 16059
Seq. Order: 35
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: 16058
Seq. Order: 36
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: 16057
Seq. Order: 37
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: 16056
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 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: 16055
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 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: 16054
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, 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

BEGIN_SET_DATE

CC ID: 16053
Seq. Order: 41
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_DATE

CC ID: 16052
Seq. Order: 42
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_DATE

CC ID: 16051
Seq. Order: 43
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_HAUL_DATE

CC ID: 16050
Seq. Order: 44
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

BEGIN_SET_LATITUDE

CC ID: 16049
Seq. Order: 45
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: 16048
Seq. Order: 46
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: 16047
Seq. Order: 47
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Begin Set Latitude Hemisphere.

General Data Type: VARCHAR2

END_SET_LATITUDE

CC ID: 16046
Seq. Order: 48
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: 16045
Seq. Order: 49
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: 16044
Seq. Order: 50
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

End Set Latitude Hemisphere

General Data Type: VARCHAR2

BEGIN_HAUL_LATITUDE

CC ID: 16043
Seq. Order: 51
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: 16042
Seq. Order: 52
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: 16041
Seq. Order: 53
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Begin Haul Latitude Hemisphere

General Data Type: VARCHAR2

END_HAUL_LATITUDE

CC ID: 16040
Seq. Order: 54
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: 16039
Seq. Order: 55
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: 16038
Seq. Order: 56
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

End Haul Latitude Hemisphere

General Data Type: VARCHAR2

BEGIN_SET_LONGITUDE

CC ID: 16037
Seq. Order: 57
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: 16036
Seq. Order: 58
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: 16035
Seq. Order: 59
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Begin Set Longitude Hemisphere

General Data Type: VARCHAR2

END_SET_LONGITUDE

CC ID: 16034
Seq. Order: 60
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: 16033
Seq. Order: 61
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: 16032
Seq. Order: 62
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

End Set Longitude Hemisphere

General Data Type: VARCHAR2

BEGIN_HAUL_LONGITUDE

CC ID: 16031
Seq. Order: 63
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: 16030
Seq. Order: 64
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: 16029
Seq. Order: 65
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Begin Haul Longitude Hemisphere

General Data Type: VARCHAR2

END_HAUL_LONGITUDE

CC ID: 16028
Seq. Order: 66
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: 16027
Seq. Order: 67
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: 16026
Seq. Order: 68
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

End Haul Longitude Hemisphere

General Data Type: VARCHAR2

BEGIN_SET_TEMPERATURE

CC ID: 16025
Seq. Order: 69
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_TEMPERATURE

CC ID: 16024
Seq. Order: 70
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

BEGIN_HAUL_TEMPERATURE

CC ID: 16023
Seq. Order: 71
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_TEMPERATURE

CC ID: 16022
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: 16021
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

HAUL_LOST_TIME

CC ID: 16020
Seq. Order: 74
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 1
Status: Active
Description:

Time Lost During Haul. (In Hours)

General Data Type: NUMBER

HAUL_DURATION

CC ID: 16019
Seq. Order: 75
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

FISHING_AREA

CC ID: 16018
Seq. Order: 76
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Fishing Area

General Data Type: VARCHAR2

EXPERIMENTAL_TREATMENT

CC ID: 16017
Seq. Order: 77
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Refers to certain experimental PLOP data.The value assigned here is defined by experimental parameters that can be gotten from Cheryl Brown.

General Data Type: VARCHAR2

COMMENTS

CC ID: 16016
Seq. Order: 78
Data Storage Type: VARCHAR2
Max Length: 2000
Required: No
Primary Key: No
Status: Active
Description:

Observer comments about the haul

General Data Type: VARCHAR2

IS_EXPERIMENT

CC ID: 16015
Seq. Order: 79
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Is an experimental haul?

General Data Type: VARCHAR2

CREATED_BY_USER_ID

CC ID: 16014
Seq. Order: 80
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: No
Status: Active
Description:

Created by whom

General Data Type: VARCHAR2

CREATED_DATE

CC ID: 16013
Seq. Order: 81
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Created when

General Data Type: DATE

MODIFIED_BY_USER_ID

CC ID: 16012
Seq. Order: 82
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Modified by whom

General Data Type: VARCHAR2

MODIFIED_DATE

CC ID: 16011
Seq. Order: 83
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Modified when

General Data Type: DATE

Catalog Details

Catalog Item ID: 5347
GUID: gov.noaa.nmfs.inport:5347
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