Slide Menu
System Maintenance Notice, Monday, December 5, 2022 @ 1pm-5pm Eastern. The Operations Team will be performing system maintenance. During this scheduled downtime, InPort will not be available.
View All
Search Help Show/Hide Menu

Item Identification

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

Table assigns a NMFS gear code to als.als_landings_usvi nmfsgear based on gear_type_1 and gear_type_2 from the als.usvi_species_group_all table.

Notes:

Loaded by batch 7906, 12-22-2015 14:11

Entity Information

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

Table assigns a NMFS gear code to als.als_landings_usvi nmfsgear based on gear_type_1 and gear_type_2 from the als.usvi_species_group_all table.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
GEAR_TYPE1 VARCHAR2 The 1st recorded gear type on the form.
100
GEAR_NUM1_DESCRIPTION VARCHAR2 The description of the primary gear quanity recorded on the form
100
GEAR_TYPE2 VARCHAR2 The 2nd recorded gear type on form
100
GEAR_NUM2_DESCRIPTION VARCHAR2 The description of the secondary gear quantity recorded
100
USVI_GEAR_DESCRIPTION VARCHAR2 The description of the assigned gear code
100
NMFS_GEAR_CODE VARCHAR2 The assigned NMFS gear code
100
NMFS_GEAR_DESCRIPTION VARCHAR2 The description of the assigned NMFS gear code
100
FIN_GEAR_CODE VARCHAR2 The Fisheries Information Network (FIN) of the Gulf States Marine FIsheries Commission (GSMFC) code for the gear.
100
FIN_GEAR_NAME VARCHAR2 The FIN gear name
100
FIN_CATEGORY_CODE VARCHAR2 The FIN code for gear category
100
FIN_CATEGORY_NAME VARCHAR2 The FIN category name
100
FIN_TYPE_CODE VARCHAR2 The FIN gear type code
100
FIN_TYPE_NAME VARCHAR2 The FIN gear type name
100
FIN_DESCRIPTION VARCHAR2 The FIN gear description

Attribute Details

GEAR_TYPE1

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

The 1st recorded gear type on the form.

General Data Type: VARCHAR2

GEAR_NUM1_DESCRIPTION

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

The description of the primary gear quanity recorded on the form

General Data Type: VARCHAR2

GEAR_TYPE2

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

The 2nd recorded gear type on form

General Data Type: VARCHAR2

GEAR_NUM2_DESCRIPTION

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

The description of the secondary gear quantity recorded

General Data Type: VARCHAR2

USVI_GEAR_DESCRIPTION

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

The description of the assigned gear code

General Data Type: VARCHAR2

NMFS_GEAR_CODE

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

The assigned NMFS gear code

General Data Type: VARCHAR2

NMFS_GEAR_DESCRIPTION

CC ID: 267304
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 28
Required: No
Primary Key: No
Status: Active
Description:

The description of the assigned NMFS gear code

General Data Type: VARCHAR2

FIN_GEAR_CODE

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

The Fisheries Information Network (FIN) of the Gulf States Marine FIsheries Commission (GSMFC) code for the gear.

General Data Type: VARCHAR2

FIN_GEAR_NAME

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

The FIN gear name

General Data Type: VARCHAR2

FIN_CATEGORY_CODE

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

The FIN code for gear category

General Data Type: VARCHAR2

FIN_CATEGORY_NAME

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

The FIN category name

General Data Type: VARCHAR2

FIN_TYPE_CODE

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

The FIN gear type code

General Data Type: VARCHAR2

FIN_TYPE_NAME

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

The FIN gear type name

General Data Type: VARCHAR2

FIN_DESCRIPTION

CC ID: 267298
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 1000
Required: No
Primary Key: No
Status: Active
Description:

The FIN gear description

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 29955
GUID: gov.noaa.nmfs.inport:29955
Metadata Record Created By: Joshua Bennett
Metadata Record Created: 2015-12-22 14:11+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