Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Fisheries Statistics Division > FISHERIES MONITORING > Commercial Catch and Effort > Commercial Landings Project > Commercial Fisheries Landings for U.S. Caribbea... > U.S. Caribbean Commercial Landings (CCL) Tables... >

Table: GEAR_LIST

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:28546  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Activity Log
Catalog Details

Summary

Abstract

A unique list of fishing gears such as Net or Trap.

Description

A unique list of fishing gears such as Net or Trap.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
GEAR_CD
VARCHAR2 		Primary key for this table.
GEAR_TYPE_CD
VARCHAR2 		FK to GEAR_TYPE_LIST. Identifies the Type of gear for a specific gear, such as Net (Gear Type) for Gill Net (Gear).
GEAR_NM
VARCHAR2 		Unique Name for a gear. Alternate names for the gear can be found in the Dialect table.
GEAR_DESC
VARCHAR2 		Description of a Gear.
LU_DT
DATE 		Last update date.
LU_USER_ID
NUMBER 		Last update user.
IS_ENABLED
NUMBER 		Is the value enabled for use.

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: GEAR_LIST
Short Name: GEAR_LIST
Status: Completed
Abstract:

A unique list of fishing gears such as Net or Trap.
Notes:

Loaded by batch 7533, 11-05-2015 16:10

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: CCL
Description:

A unique list of fishing gears such as Net or Trap.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key GEAR_CD VARCHAR2 Primary key for this table.
100
 GEAR_TYPE_CD VARCHAR2 FK to GEAR_TYPE_LIST. Identifies the Type of gear for a specific gear, such as Net (Gear Type) for Gill Net (Gear).
100
 GEAR_NM VARCHAR2 Unique Name for a gear. Alternate names for the gear can be found in the Dialect table.
100
 GEAR_DESC VARCHAR2 Description of a Gear.
100
 LU_DT DATE Last update date.
100
 LU_USER_ID NUMBER Last update user.
100
 IS_ENABLED NUMBER Is the value enabled for use.

Attribute Details

GEAR_CD

CC ID: 246985
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: Yes
Status: Active
Description:

Primary key for this table.
General Data Type: VARCHAR2

GEAR_TYPE_CD

CC ID: 246984
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

FK to GEAR_TYPE_LIST. Identifies the Type of gear for a specific gear, such as Net (Gear Type) for Gill Net (Gear).
General Data Type: VARCHAR2
Foreign Key Relations:

CCL.GEAR_TYPE_LIST

GEAR_NM

CC ID: 246986
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 60
Required: Yes
Primary Key: No
Status: Active
Description:

Unique Name for a gear. Alternate names for the gear can be found in the Dialect table.
General Data Type: VARCHAR2

GEAR_DESC

CC ID: 246987
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 250
Required: No
Primary Key: No
Status: Active
Description:

Description of a Gear.
General Data Type: VARCHAR2

LU_DT

CC ID: 246988
Seq. Order: 5
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Last update date.
General Data Type: DATE

LU_USER_ID

CC ID: 246989
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Last update user.
General Data Type: NUMBER

IS_ENABLED

CC ID: 246990
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Is the value enabled for use.
General Data Type: NUMBER

Activity Log

Activity Log 1

CC ID: 256528
Activity Date/Time: 2011-11-23
Activity Type: Gear code additions and edits
Responsible Party: Joshua Bennett
Description:

Gear Code HL_POW was replaced by HL_TROLL in lookups and data. (The spanish name is SILGA for trolling hook and line). HL_POW_REEL was added to (spanish name is MALACATE for hook and line, electric reel). HL_HAND code gear name ('HAND') was renamed 'HANDLINE' in lookup and 'CORDEL DE MANO' in dialect lookup. Bottom Longline (CODE HL_BLL) was renamed (PALANGRE DE FONDO)IN dialect lookup. Drift Longline (code HL_DLL) was renamed (PALANGRE horizontal DE superfecie) IN dialect lookup. Vertical Longline (code HL_VLL) was renamed (PALANGRE vertical) IN dialect lookup. HL_BUOY (yo-yo) was dropped from dialect list. New code 'HL_BOTTOM' (Bottom Fishing Hook and Line) was added to lookup and listed as 'CALA' in dialect list. Another gear code addition: GILL_NET_BOTT for Gill Nets Fished on or near the sea bottom. Translates to Trasmallo in dialect list for SP01. The code of GILL_NET, named SURFACE GILL NET, was retained for surface gill nets and translates now to FILETE in dialect list for SP01.

Activity Log 2

CC ID: 256529
Activity Date/Time: 2015-11-23
Activity Type: Gear code additions
Responsible Party: Joshua Bennett
Description:

Gear codes NET_AQUARFISH for 'AQUARIUM FISH NET' and NET_GILL_SCUBA 'GILL NET, FISHED USING SCUBA' were added to the CCL.GEAR_LIST table and to the CCL.DIALECT_GEAR_LIST as 'REDES PARA PECES ORNAMENTALES' AND 'TRASMALLO CON BUCEO CON TANQUE' respectively.

Catalog Details

Catalog Item ID: 28546
GUID: gov.noaa.nmfs.inport:28546
Metadata Record Created By: Joshua Bennett
Metadata Record Created: 2015-11-05 16:10+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