Slide Menu
Search Help Show/Hide Menu

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: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year