Table: POP_GEAR_LOG
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:5342 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | Table: POP_GEAR_LOG |
|---|---|
| Short Name: | POP_GEAR_LOG |
| Status: | Completed |
| Abstract: |
One record for each gear log in the trip |
| Notes: |
Loaded by batch 1683, 10-12-2007 05:01 |
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Schema Name: | POPOL |
| Description: |
One record for each gear log in the trip |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
|
GEAR_LOG_KEY | NUMBER | Generated primary key |
|
100
|
STRING_NUMBER | NUMBER | Consecutive number assigned to each string. Changes that result in a change of target species will necessitate a new string number. | |
|
100
|
NUMBER_HOOKS | NUMBER | Average number of hooks set calculated over all hauls with the same gear configuration. | |
|
100
|
ANCHOR_USED | VARCHAR2 | Was an anchor used? | |
|
100
|
ANCHOR_WEIGHT | NUMBER | Units are pounds. | |
|
100
|
MAINLINE_COLOR | VARCHAR2 | Coded color of the main line | |
|
100
|
MAINLINE_DIAMETER | NUMBER | In millimeters | |
|
100
|
MAINLINE_STRENGTH | NUMBER | In pounds | |
|
100
|
MAINLINE_MATERIAL | VARCHAR2 | Coded material that the mainline is constructed with. | |
|
100
|
MAINLINE_STRANDS | NUMBER | Number of strands in the mainline | |
|
100
|
WERE_OTHER_FLOATS_USED | VARCHAR2 | Were Other Floats Used | |
|
100
|
NUMBER_OTHER_FLOATS | NUMBER | Number of Other Floats used ? | |
|
100
|
NUMBER_HOOKS_BETWEEN_FLOATS | NUMBER | Maximum number of hooks between floats | |
|
100
|
NUMBER_RADIO_BEACONS | NUMBER | Number of radio beacons | |
|
100
|
NUMBER_RADAR_REFLECTORS | NUMBER | Number of radar reflectors | |
|
100
|
NUMBER_SECTIONS | NUMBER | Number of sections | |
|
100
|
DISTANCE_BETWEEN_SECTIONS | NUMBER | Distance between sections in nautical miles. | |
|
100
|
WERE_LIGHT_STICKS_USED | VARCHAR2 | Were light sticks used | |
|
100
|
LIGHT_STICK_COLOR | VARCHAR2 | Light stick color. Only populated if light sticks were used. | |
|
100
|
GANGION_DISTANCE | NUMBER | Distance between gangions in feet. | |
|
100
|
GANGION_DIAMETER | NUMBER | Gangion diameter to the nearest tenth of a millimeter. | |
|
100
|
GANGION_MATERIAL | VARCHAR2 | Code of material used for gangions | |
|
100
|
GANGION_COLOR | VARCHAR2 | Gangion Color Code | |
|
100
|
LEADER_LENGTH | NUMBER | Length of the leader to the nearest inch. | |
|
100
|
LEADER_STRENGTH | NUMBER | Test or Dry Breaking Weight Strength of the leader in pound. | |
|
100
|
LEADER_MATERIAL | VARCHAR2 | Code of Material Used For Leaders. | |
|
100
|
COMMENTS | VARCHAR2 | Comments | |
|
100
|
GENERATED_RECORD | VARCHAR2 | 'Y' if a Gear Log record was generated | |
|
100
|
CREATED_BY_USER_ID | VARCHAR2 | Created by whom | |
|
100
|
CREATED_DATE | DATE | Created when | |
|
100
|
MODIFIED_BY_USER_ID | VARCHAR2 | Modified by whom | |
|
100
|
MODIFIED_DATE | DATE | Modified when | |
|
100
|
WERE_POLYBALL_FLOATS_USED | VARCHAR2 | Were polybal floats used? | |
|
100
|
WERE_BULLET_FLOATS_USED | VARCHAR2 | Were Bulet Floats Used | |
|
100
|
NUMBER_POLYBALL_FLOATS | NUMBER | Number of polybal floats. | |
|
100
|
NUMBER_BULLET_FLOATS | NUMBER | Number of bulet floats | |
|
100
|
GANGION_TEST | NUMBER | Test or Dry Breaking Weight Strength of the gangion in pounds | |
|
100
|
TRIP_NUMBER | VARCHAR2 | Link to POP_TRIP_LOG | |
|
100
|
STATUS_ID | VARCHAR2 | Status Identifier |
Attribute Details
GEAR_LOG_KEY
CC ID: 15795
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | Yes |
| Precision: | 10 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Generated primary key |
| General Data Type: | NUMBER |
STRING_NUMBER
CC ID: 15794
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 1 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Consecutive number assigned to each string. Changes that result in a change of target species will necessitate a new string number. |
| General Data Type: | NUMBER |
NUMBER_HOOKS
CC ID: 15793
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Average number of hooks set calculated over all hauls with the same gear configuration. |
| General Data Type: | NUMBER |
ANCHOR_USED
CC ID: 15792
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Was an anchor used? |
| General Data Type: | VARCHAR2 |
ANCHOR_WEIGHT
CC ID: 15791
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 3 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Units are pounds. |
| General Data Type: | NUMBER |
MAINLINE_COLOR
CC ID: 15790
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Coded color of the main line |
| General Data Type: | VARCHAR2 |
MAINLINE_DIAMETER
CC ID: 15789
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 2 |
| Scale: | 1 |
| Status: | Active |
| Description: |
In millimeters |
| General Data Type: | NUMBER |
MAINLINE_STRENGTH
CC ID: 15788
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
In pounds |
| General Data Type: | NUMBER |
MAINLINE_MATERIAL
CC ID: 15787
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Coded material that the mainline is constructed with. |
| General Data Type: | VARCHAR2 |
MAINLINE_STRANDS
CC ID: 15786
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Number of strands in the mainline |
| General Data Type: | NUMBER |
WERE_OTHER_FLOATS_USED
CC ID: 15785
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Were Other Floats Used |
| General Data Type: | VARCHAR2 |
NUMBER_OTHER_FLOATS
CC ID: 15784
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Number of Other Floats used ? |
| General Data Type: | NUMBER |
NUMBER_HOOKS_BETWEEN_FLOATS
CC ID: 15783
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Maximum number of hooks between floats |
| General Data Type: | NUMBER |
NUMBER_RADIO_BEACONS
CC ID: 15782
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Number of radio beacons |
| General Data Type: | NUMBER |
NUMBER_RADAR_REFLECTORS
CC ID: 15781
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Number of radar reflectors |
| General Data Type: | NUMBER |
NUMBER_SECTIONS
CC ID: 15780
| Seq. Order: | 16 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 3 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Number of sections |
| General Data Type: | NUMBER |
DISTANCE_BETWEEN_SECTIONS
CC ID: 15779
| Seq. Order: | 17 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 3 |
| Scale: | 1 |
| Status: | Active |
| Description: |
Distance between sections in nautical miles. |
| General Data Type: | NUMBER |
WERE_LIGHT_STICKS_USED
CC ID: 15778
| Seq. Order: | 18 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Were light sticks used |
| General Data Type: | VARCHAR2 |
LIGHT_STICK_COLOR
CC ID: 15777
| Seq. Order: | 19 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Light stick color. Only populated if light sticks were used. |
| General Data Type: | VARCHAR2 |
GANGION_DISTANCE
CC ID: 15776
| Seq. Order: | 20 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Distance between gangions in feet. |
| General Data Type: | NUMBER |
GANGION_DIAMETER
CC ID: 15775
| Seq. Order: | 21 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 1 |
| Status: | Active |
| Description: |
Gangion diameter to the nearest tenth of a millimeter. |
| General Data Type: | NUMBER |
GANGION_MATERIAL
CC ID: 15774
| Seq. Order: | 22 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code of material used for gangions |
| General Data Type: | VARCHAR2 |
GANGION_COLOR
CC ID: 15773
| Seq. Order: | 23 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Gangion Color Code |
| General Data Type: | VARCHAR2 |
LEADER_LENGTH
CC ID: 15772
| Seq. Order: | 24 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Length of the leader to the nearest inch. |
| General Data Type: | NUMBER |
LEADER_STRENGTH
CC ID: 15771
| Seq. Order: | 25 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Test or Dry Breaking Weight Strength of the leader in pound. |
| General Data Type: | NUMBER |
LEADER_MATERIAL
CC ID: 15770
| Seq. Order: | 26 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code of Material Used For Leaders. |
| General Data Type: | VARCHAR2 |
COMMENTS
CC ID: 15769
| Seq. Order: | 27 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2000 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Comments |
| General Data Type: | VARCHAR2 |
GENERATED_RECORD
CC ID: 15768
| Seq. Order: | 28 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
'Y' if a Gear Log record was generated |
| General Data Type: | VARCHAR2 |
CREATED_BY_USER_ID
CC ID: 15767
| Seq. Order: | 29 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 20 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Created by whom |
| General Data Type: | VARCHAR2 |
CREATED_DATE
CC ID: 15766
| Seq. Order: | 30 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Created when |
| General Data Type: | DATE |
MODIFIED_BY_USER_ID
CC ID: 15765
| Seq. Order: | 31 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Modified by whom |
| General Data Type: | VARCHAR2 |
MODIFIED_DATE
CC ID: 15764
| Seq. Order: | 32 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Modified when |
| General Data Type: | DATE |
WERE_POLYBALL_FLOATS_USED
CC ID: 15763
| Seq. Order: | 33 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Were polybal floats used? |
| General Data Type: | VARCHAR2 |
WERE_BULLET_FLOATS_USED
CC ID: 15762
| Seq. Order: | 34 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Were Bulet Floats Used |
| General Data Type: | VARCHAR2 |
NUMBER_POLYBALL_FLOATS
CC ID: 15761
| Seq. Order: | 35 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Number of polybal floats. |
| General Data Type: | NUMBER |
NUMBER_BULLET_FLOATS
CC ID: 15760
| Seq. Order: | 36 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Number of bulet floats |
| General Data Type: | NUMBER |
GANGION_TEST
CC ID: 15759
| Seq. Order: | 37 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Test or Dry Breaking Weight Strength of the gangion in pounds |
| General Data Type: | NUMBER |
TRIP_NUMBER
CC ID: 15758
| Seq. Order: | 38 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 6 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Link to POP_TRIP_LOG |
| General Data Type: | VARCHAR2 |
STATUS_ID
CC ID: 15757
| Seq. Order: | 39 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Status Identifier |
| General Data Type: | VARCHAR2 |
Catalog Details
| Catalog Item ID: | 5342 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:5342 |
| 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 |