Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

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

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

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ERDMAN_GEAR_CODE
VARCHAR2
The Puerto Rico gear code.
ERDMAN_GEAR_NAME
VARCHAR2
The Puerto RIco gear name.
NMFS_GEAR_CODE
VARCHAR2
The NMFS gear code.
NMFS_GEAR_NAME
VARCHAR2
Thee NMFS gear name.
FIN_GEAR_CODE
VARCHAR2
The FIN (GSMFC) gear code
FIN_GEAR_NAME
VARCHAR2
The FIN gear name
FIN_CATEGORY_CODE
VARCHAR2
The FIN gear category code (good for rollup of confidential gears).
FIN_CATEGORY_NAME
VARCHAR2
The FIN gear category name
FIN_TYPE_CODE
VARCHAR2
The code for FIN gear type (good for rollup of confidential gears).
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_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: 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