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
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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.
DescriptionTable 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
|
|
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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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 |