View: POP_HAUL_LOG_V
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:5350 | Updated: August 9, 2022 | Published / External
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
|
|
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 |