Slide Menu
System Maintenance Notice, Monday, December 5, 2022 @ 1pm-5pm Eastern. The Operations Team will be performing system maintenance. During this scheduled downtime, InPort will not be available.
View All
Search Help Show/Hide Menu

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