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

Summary

Abstract

Support table identifying all vessel codes and descriptions.

Description

Support table identifying all vessel codes and descriptions.

Entity Information

Entity Type
Data Table

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

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

Item Identification

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

Support table identifying all vessel codes and descriptions.

Notes:

Loaded by batch 9101, 07-29-2016 12:16

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: 340435
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: 340436
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: 340437
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: 340438
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: 340439
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: 340440
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: 340441
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: 340442
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: 33834
GUID: gov.noaa.nmfs.inport:33834
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-29 12:16+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