Slide Menu
Search Help Show/Hide Menu

Item Identification

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

View of the CFDBS Gear Support Table, listing just the Gears and Gear Codes used in the Observer Database System.

Notes:

Loaded by batch 8950, 07-06-2016 08:24

Entity Information

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

View of the CFDBS Gear Support Table, listing just the Gears and Gear Codes used in the Observer Database System.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
NEGEAR VARCHAR2 Northeast gear code. See OBGEAR table. Collected for ASM where applicable.
100
GEARNM VARCHAR2 Common name(s) for negear code.
100
OBGEARCAT VARCHAR2 Gear Category used by observer program: OT = Otter trawl,GG = gillnet, PT = Pots and traps , LL = Longline and other line gear, BS = beach set, SD = Scallop Dredge, PR = pair trawl,PS = purse seine, ST = Scallop Trawl, TT Twin Trawl, NK =Not known, OB=Obsolete.
100
LISTCOL VARCHAR2 Shortened description of column used for IPAQ data entry.
100
SECGEARFISH VARCHAR2 Sector gear fishery code from VTR gear code. Collected for ASM. Derived using VTR gear codes in OBGEAR as reference.
100
DOC DATE Date associated record was updated.

Attribute Details

NEGEAR

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

Northeast gear code. See OBGEAR table. Collected for ASM where applicable.

General Data Type: VARCHAR2

GEARNM

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

Common name(s) for negear code.

General Data Type: VARCHAR2

OBGEARCAT

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

Gear Category used by observer program: OT = Otter trawl,GG = gillnet, PT = Pots and traps , LL = Longline and other line gear, BS = beach set, SD = Scallop Dredge, PR = pair trawl,PS = purse seine, ST = Scallop Trawl, TT Twin Trawl, NK =Not known, OB=Obsolete.

General Data Type: VARCHAR2

LISTCOL

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

Shortened description of column used for IPAQ data entry.

General Data Type: VARCHAR2

SECGEARFISH

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

Sector gear fishery code from VTR gear code. Collected for ASM. Derived using VTR gear codes in OBGEAR as reference.

General Data Type: VARCHAR2

DOC

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

Date associated record was updated.

General Data Type: DATE

Catalog Details

Catalog Item ID: 33339
GUID: gov.noaa.nmfs.inport:33339
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-06 08:24+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-07-28
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-07-28
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-07-28