Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Support table identifying all vessel codes and descriptions.

Notes:

Loaded by batch 9100, 07-29-2016 12:08

Entity Information

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

Support table identifying all vessel codes and descriptions.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
VESSEL_NAME VARCHAR2 Name of vessel.
100
Primary Key VESSEL_ABBREV VARCHAR2 Vessel abbreviation. See SVDBS.SV_VESSEL
100
COUNTRY_OF_ORIGIN VARCHAR2 Country of origin of vessel.
100
HOME_PORT VARCHAR2 City where vessel maintains its home port.
100
AGENCY_NAME VARCHAR2 Name of state or federal agency that utilizes the vessel.
100
LENGTH_OVERALL_FT NUMBER Overall length of vessel measured to nearest foot.
100
CONSTRUCTION VARCHAR2 Construction material of vessel.
100
YEAR_BUILT VARCHAR2 Year vessel was built.

Attribute Details

VESSEL_NAME

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

Name of vessel.

General Data Type: VARCHAR2

VESSEL_ABBREV

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

Vessel abbreviation. See SVDBS.SV_VESSEL

General Data Type: VARCHAR2

COUNTRY_OF_ORIGIN

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

Country of origin of vessel.

General Data Type: VARCHAR2

HOME_PORT

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

City where vessel maintains its home port.

General Data Type: VARCHAR2

AGENCY_NAME

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

Name of state or federal agency that utilizes the vessel.

General Data Type: VARCHAR2

LENGTH_OVERALL_FT

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

Overall length of vessel measured to nearest foot.

General Data Type: NUMBER

CONSTRUCTION

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

Construction material of vessel.

General Data Type: VARCHAR2

YEAR_BUILT

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

Year vessel was built.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 33827
GUID: gov.noaa.nmfs.inport:33827
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-29 12:08+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2019-05-31
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2019-05-31
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2020-05-31