Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: DLS_GEAR_CODES
Short Name: DLS_GEAR_CODES
Status: Completed
Abstract:

Holds the DLS Gear Codes information.

Notes:

Loaded by batch 5871, 04-20-2015 08:47

Entity Information

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

Holds the DLS Gear Codes information.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key DLS_GEAR_CODE VARCHAR2 DLS Gear Code
100
GEAR_LABEL VARCHAR2 Gear Description
100
NMFS_GEAR_CODE VARCHAR2 NMFS Gear Code Equivalent to DLS_GEAR_CODE
100
ICCAT_GEAR_CODE VARCHAR2 ICCAT Gear Code Equivalent to DLS_GEAR_CODE
100
ICCAT_GEAR_ORDER NUMBER ICCAT Gear Order Equivalent to DLS_GEAR_CODE
100
ICCAT_REPORT_NUMBER VARCHAR2 WHICH ICCAT Report is for Gear in question

Attribute Details

DLS_GEAR_CODE

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

DLS Gear Code

General Data Type: VARCHAR2

GEAR_LABEL

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

Gear Description

General Data Type: VARCHAR2

NMFS_GEAR_CODE

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

NMFS Gear Code Equivalent to DLS_GEAR_CODE

General Data Type: VARCHAR2

ICCAT_GEAR_CODE

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

ICCAT Gear Code Equivalent to DLS_GEAR_CODE

General Data Type: VARCHAR2

ICCAT_GEAR_ORDER

CC ID: 197651
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

ICCAT Gear Order Equivalent to DLS_GEAR_CODE

General Data Type: NUMBER

ICCAT_REPORT_NUMBER

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

WHICH ICCAT Report is for Gear in question

General Data Type: VARCHAR2

FAQs

FAQ 1

CC ID: 197700
Date: 2015-04-20 00:00:00
Author: Allison Shideler
Question:

When was buoy gear added to the gear code table?

Answer:

Buoy gear (BG) became a gear code in September 2006. Prior to that, any buoy gear trips were coded as handline (HL)

FAQ 2

CC ID: 197701
Date: 2015-04-20 00:00:00
Author: Allison Shideler
Question:

When was greenstick added to the gear code table?

Answer:

Greenstick (GS) became a gear code in June 2007.

FAQ 3

CC ID: 197702
Date: 2015-04-20 00:00:00
Author: Allison Shideler
Question:

Are electric and manual rod and reel gears reported differently in the gear codes table?

Answer:

No, within DLS, both electric and manual rod and reel have the same code (RR).

Catalog Details

Catalog Item ID: 24493
GUID: gov.noaa.nmfs.inport:24493
Metadata Record Created By: Allison Shideler
Metadata Record Created: 2015-04-20 08:47+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 Next Review Date: 2022-05-07