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. Virgin Islands Commercial Landings Statist... >

Table: GEAR_USVI_NMFS_FIN_XREF

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

Summary

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.

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.

Entity Information

Entity Type
Data Table

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

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_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