Slide Menu
Search Help Show/Hide Menu

Item Identification

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

This table links the vessel_type_code in the NORPAC.FOREIGN_FISHING_OPERATION table with a description of the code.

Notes:

Loaded by batch 2364, 06-29-2009 18:15

Entity Information

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

This table links the vessel_type_code in the NORPAC.FOREIGN_FISHING_OPERATION table with a description of the code.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key VESSEL_TYPE_CODE NUMBER A one-digit numeric code to identify the type of fishing operation performed by the vessel.
100
VESSEL_TYPE_DEFINITION VARCHAR2 A description of the fishing operation associated with the vessel_type_code.

Attribute Details

VESSEL_TYPE_CODE

CC ID: 37478
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 1
Scale: 0
Status: Active
Description:

A one-digit numeric code to identify the type of fishing operation performed by the vessel.

General Data Type: NUMBER

VESSEL_TYPE_DEFINITION

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

A description of the fishing operation associated with the vessel_type_code.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 9593
GUID: gov.noaa.nmfs.inport:9593
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2009-06-29 18:15+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-18
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-18
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-18