View: POP_HAUL_LOG_EXP_V
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:5348 | Updated: June 14, 2024 | Published / External
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
|
|
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: | Lee M Weinberger |
| Metadata Record Last Modified: | 2024-06-14 13:53+0000 |
| Metadata Record Published: | 2024-06-14 |
| Owner Org: | SEFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2021-05-06 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2022-05-06 |