Slide Menu
System Maintenance Notice, Sunday, January 23, 2022 @ 8am-2pm Eastern. The Operations Team will be performing system maintenance on all server environments. During this scheduled downtime, InPort will not be available.
View All
Search Help Show/Hide Menu

Item Identification

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

Table is lookup for Puerto Rico gear codes. It also cross-references the PR codes to the NMFS gear codes and the FIN gear codes. The Puerto Rico gear coding is limited and general concerning the gears used in their fisheries. For this reason, this table may soon be updated with more descriptive codes and definitions

Notes:

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

Entity Information

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

Table is lookup for Puerto Rico gear codes. It also cross-references the PR codes to the NMFS gear codes and the FIN gear codes. The Puerto Rico gear coding is limited and general concerning the gears used in their fisheries. For this reason, this table may soon be updated with more descriptive codes and definitions

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ERDMAN_GEAR_CODE VARCHAR2 The Puerto Rico gear code.
100
ERDMAN_GEAR_NAME VARCHAR2 The Puerto RIco gear name.
100
NMFS_GEAR_CODE VARCHAR2 The NMFS gear code.
100
NMFS_GEAR_NAME VARCHAR2 Thee NMFS gear name.
100
FIN_GEAR_CODE VARCHAR2 The FIN (GSMFC) gear code
100
FIN_GEAR_NAME VARCHAR2 The FIN gear name
100
FIN_CATEGORY_CODE VARCHAR2 The FIN gear category code (good for rollup of confidential gears).
100
FIN_CATEGORY_NAME VARCHAR2 The FIN gear category name
100
FIN_TYPE_CODE VARCHAR2 The code for FIN gear type (good for rollup of confidential gears).
100
FIN_TYPE_NAME VARCHAR2 The FIN gear type name.
100
FIN_DESCRIPTION VARCHAR2 The FIN gear description

Attribute Details

ERDMAN_GEAR_CODE

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

The Puerto Rico gear code.

General Data Type: VARCHAR2

ERDMAN_GEAR_NAME

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

The Puerto RIco gear name.

General Data Type: VARCHAR2

NMFS_GEAR_CODE

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

The NMFS gear code.

General Data Type: VARCHAR2

NMFS_GEAR_NAME

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

Thee NMFS gear name.

General Data Type: VARCHAR2

FIN_GEAR_CODE

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

The FIN (GSMFC) gear code

General Data Type: VARCHAR2

FIN_GEAR_NAME

CC ID: 267289
Seq. Order: 6
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: 267290
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

The FIN gear category code (good for rollup of confidential gears).

General Data Type: VARCHAR2

FIN_CATEGORY_NAME

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

The FIN gear category name

General Data Type: VARCHAR2

FIN_TYPE_CODE

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

The code for FIN gear type (good for rollup of confidential gears).

General Data Type: VARCHAR2

FIN_TYPE_NAME

CC ID: 267283
Seq. Order: 10
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: 267284
Seq. Order: 11
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: 29954
GUID: gov.noaa.nmfs.inport:29954
Metadata Record Created By: Joshua Bennett
Metadata Record Created: 2015-12-22 14:11+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