Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

One record for each gear log in the trip

Description

One record for each gear log in the trip

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
GEAR_LOG_KEY
NUMBER
Generated primary key
STRING_NUMBER
NUMBER
Consecutive number assigned to each string. Changes that result in a change of target species will necessitate a new string number.
NUMBER_HOOKS
NUMBER
Average number of hooks set calculated over all hauls with the same gear configuration.
ANCHOR_USED
VARCHAR2
Was an anchor used?
ANCHOR_WEIGHT
NUMBER
Units are pounds.
MAINLINE_COLOR
VARCHAR2
Coded color of the main line
MAINLINE_DIAMETER
NUMBER
In millimeters
MAINLINE_STRENGTH
NUMBER
In pounds
MAINLINE_MATERIAL
VARCHAR2
Coded material that the mainline is constructed with.
MAINLINE_STRANDS
NUMBER
Number of strands in the mainline
WERE_OTHER_FLOATS_USED
VARCHAR2
Were Other Floats Used
NUMBER_OTHER_FLOATS
NUMBER
Number of Other Floats used ?
NUMBER_HOOKS_BETWEEN_FLOATS
NUMBER
Maximum number of hooks between floats
NUMBER_RADIO_BEACONS
NUMBER
Number of radio beacons
NUMBER_RADAR_REFLECTORS
NUMBER
Number of radar reflectors
NUMBER_SECTIONS
NUMBER
Number of sections
DISTANCE_BETWEEN_SECTIONS
NUMBER
Distance between sections in nautical miles.
WERE_LIGHT_STICKS_USED
VARCHAR2
Were light sticks used
LIGHT_STICK_COLOR
VARCHAR2
Light stick color. Only populated if light sticks were used.
GANGION_DISTANCE
NUMBER
Distance between gangions in feet.
GANGION_DIAMETER
NUMBER
Gangion diameter to the nearest tenth of a millimeter.
GANGION_MATERIAL
VARCHAR2
Code of material used for gangions
GANGION_COLOR
VARCHAR2
Gangion Color Code
LEADER_LENGTH
NUMBER
Length of the leader to the nearest inch.
LEADER_STRENGTH
NUMBER
Test or Dry Breaking Weight Strength of the leader in pound.
LEADER_MATERIAL
VARCHAR2
Code of Material Used For Leaders.
COMMENTS
VARCHAR2
Comments
GENERATED_RECORD
VARCHAR2
'Y' if a Gear Log record was generated
CREATED_BY_USER_ID
VARCHAR2
Created by whom
CREATED_DATE
DATE
Created when
MODIFIED_BY_USER_ID
VARCHAR2
Modified by whom
MODIFIED_DATE
DATE
Modified when
WERE_POLYBALL_FLOATS_USED
VARCHAR2
Were polybal floats used?
WERE_BULLET_FLOATS_USED
VARCHAR2
Were Bulet Floats Used
NUMBER_POLYBALL_FLOATS
NUMBER
Number of polybal floats.
NUMBER_BULLET_FLOATS
NUMBER
Number of bulet floats
GANGION_TEST
NUMBER
Test or Dry Breaking Weight Strength of the gangion in pounds
TRIP_NUMBER
VARCHAR2
Link to POP_TRIP_LOG
STATUS_ID
VARCHAR2
Status Identifier

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

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

Rubric Score Primary Key? Name Type Description
100
Primary Key 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