Slide Menu
InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.2.3. Downtime Schedule Tuesday, November 29, 2022 12:00pm - 1:30pm Eastern / 10:00am - 11:30pm Pacific / 7:00am - 8:30pm Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: https://www.fisheries.noaa.gov/inportserve/waf What's...
View All
Search Help Show/Hide Menu

Item Identification

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 Information

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

Combined View Of Experimental and Non 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: 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 Details

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