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: VOU_VESOP
Short Name: VOU_VESOP
Status: Completed
Abstract:

This master data table provides information on U.S. Coast Guard registered vessels that were identified as actively fishing commercially, as verified by a local port agent, or via one of the sales receipt systems.

Purpose:

Master Data Table

Notes:

Loaded by batch 1685, 10-12-2007 07:37

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None port agent
None state registered vessels
None Vessels

Temporal Keywords

Thesaurus Keyword
UNCONTROLLED
None 1996-present

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None Alabama
None Atlantic
None Florida
None Georgia
None Gulf Of Mexico
None Louisiana
None Mississippi
None North Carolina
None South Carolina
None Texas

Stratum Keywords

Thesaurus Keyword
UNCONTROLLED
None area
None county
None gear
None state

Physical Location

Organization: Southeast Fisheries Science Center
City: Miami
State/Province: FL
Country: USA

Entity Information

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

This provides information on U.S. Coast Guard registered vessels that were identified as actively fishing commercially, as verified by a local port agent, or via one of the sales receipt systems.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
VESSELNAME VARCHAR2 The name of the vessel.
100
PTCREW NUMBER The number of part time crew members. They derive less than 50 percent of their gross income from fishing. The same crew members may be counted for different gears.
100
DUPPTCREW NUMBER When a part time crew member fishes more than one gear, they are listed as a duplicate part time crew member for all gears except for one.
100
TYPEOFCONS VARCHAR2 Type of contruction of the hull 1 = Wood, 2 = Steel, 3 = Composite, 4 = Iron, 5 = Bronze, 6 = Concrete, 7 = Aluminum, 8 = Filberglass, 9 = Plastic
100
VESSELNUM NUMBER The vessel number, the official identifier for a vessel.
100
RIG VARCHAR2 Propulsion system 1 = Steam, 2 = Gas, 3 = Oil screw 4 = Sail
100
GROSSTONS NUMBER The registered gross tonnage of the vessel.
100
VESSELLEN NUMBER The length of the vessel in feet.
100
YRBUILT NUMBER The last three digits of the year the vessel was built as shown by the builder!s certificate.
100
HORSEPOWER NUMBER The horsepower of the vessel!s engine(s). For multiple engine craft, the horsepower listed is the sum of the horsepower for each engine.
100
FTCREW NUMBER The number of full time crew members. They derive 50 percent or more of their gross income from fishing. The same crew members may be counted for different gears.
100
GEAR VARCHAR2 The NMFS gear code for the gear that was fished by this vessel in thys state and county.
100
GEARNUM NUMBER The greatest number of units of gear in use at one time. For example, 4 gillnets.
100
GEARQTY NUMBER The greatest quantity of gear used at any one time. For example, 4,000 square yards gill nets or 10,000 hooks.
100
YEAR NUMBER The year in which the vessel fished with these operating characteristics.
100
STATE VARCHAR2 The NMFS state code for the state in which the vessel fished with these operating characteristics.
100
COUNTY VARCHAR2 NMFS County where the vessel operated.
100
REGION VARCHAR2 A region code, 4 = South Atlantic States, 5 = Gulf States
100
MOTORS NUMBER The number of motorized accessory boats. Usually only for the Menhaden Fleet
100
OTHER NUMBER The number of non-motorized accessory boats.
100
TRANSFLD VARCHAR2 This field is not used. There is only one non-null value out of about 250,000 records.
100
RESERVED VARCHAR2 The first two character positions of the reserved field for change transactions indicate the field being changed.
100
DUPFTCREW NUMBER When a full time crew member fishes more than one gear, they are listed as a duplicate full time crew member for all gears except for one.
100
TRANSCODE VARCHAR2 A transaction code (A)dd, (C)hange, (D)elete
100
STATE_REG_NUMBER VARCHAR2 State Registration Number

Attribute Details

VESSELNAME

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

The name of the vessel.

General Data Type: VARCHAR2

PTCREW

CC ID: 16665
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

The number of part time crew members. They derive less than 50 percent of their gross income from fishing. The same crew members may be counted for different gears.

General Data Type: NUMBER

DUPPTCREW

CC ID: 16664
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

When a part time crew member fishes more than one gear, they are listed as a duplicate part time crew member for all gears except for one.

General Data Type: NUMBER

TYPEOFCONS

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

Type of contruction of the hull 1 = Wood, 2 = Steel, 3 = Composite, 4 = Iron, 5 = Bronze, 6 = Concrete, 7 = Aluminum, 8 = Filberglass, 9 = Plastic

General Data Type: VARCHAR2

VESSELNUM

CC ID: 16662
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

The vessel number, the official identifier for a vessel.

General Data Type: NUMBER

RIG

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

Propulsion system 1 = Steam, 2 = Gas, 3 = Oil screw 4 = Sail

General Data Type: VARCHAR2

GROSSTONS

CC ID: 16660
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

The registered gross tonnage of the vessel.

General Data Type: NUMBER

VESSELLEN

CC ID: 16659
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

The length of the vessel in feet.

General Data Type: NUMBER

YRBUILT

CC ID: 16658
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

The last three digits of the year the vessel was built as shown by the builder!s certificate.

General Data Type: NUMBER

HORSEPOWER

CC ID: 16657
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

The horsepower of the vessel!s engine(s). For multiple engine craft, the horsepower listed is the sum of the horsepower for each engine.

General Data Type: NUMBER

FTCREW

CC ID: 16656
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

The number of full time crew members. They derive 50 percent or more of their gross income from fishing. The same crew members may be counted for different gears.

General Data Type: NUMBER

GEAR

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

The NMFS gear code for the gear that was fished by this vessel in thys state and county.

General Data Type: VARCHAR2

GEARNUM

CC ID: 16654
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

The greatest number of units of gear in use at one time. For example, 4 gillnets.

General Data Type: NUMBER

GEARQTY

CC ID: 16653
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 7
Scale: 0
Status: Active
Description:

The greatest quantity of gear used at any one time. For example, 4,000 square yards gill nets or 10,000 hooks.

General Data Type: NUMBER

YEAR

CC ID: 16652
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

The year in which the vessel fished with these operating characteristics.

General Data Type: NUMBER

STATE

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

The NMFS state code for the state in which the vessel fished with these operating characteristics.

General Data Type: VARCHAR2

COUNTY

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

NMFS County where the vessel operated.

General Data Type: VARCHAR2

REGION

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

A region code, 4 = South Atlantic States, 5 = Gulf States

General Data Type: VARCHAR2

MOTORS

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

The number of motorized accessory boats. Usually only for the Menhaden Fleet

General Data Type: NUMBER

OTHER

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

The number of non-motorized accessory boats.

General Data Type: NUMBER

TRANSFLD

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

This field is not used. There is only one non-null value out of about 250,000 records.

General Data Type: VARCHAR2

RESERVED

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

The first two character positions of the reserved field for change transactions indicate the field being changed.

General Data Type: VARCHAR2

DUPFTCREW

CC ID: 16644
Seq. Order: 23
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

When a full time crew member fishes more than one gear, they are listed as a duplicate full time crew member for all gears except for one.

General Data Type: NUMBER

TRANSCODE

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

A transaction code (A)dd, (C)hange, (D)elete

General Data Type: VARCHAR2

STATE_REG_NUMBER

CC ID: 16642
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

State Registration Number

General Data Type: VARCHAR2

Access Information

Security Class: Confidential

Catalog Details

Catalog Item ID: 5386
GUID: gov.noaa.nmfs.inport:5386
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-10-12 07:37+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