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 9069, 07-28-2016 10:55

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: 335455
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: 335456
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: 335457
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: 335458
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: 335459
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: 335460
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: 335461
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: 335462
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: 33592
GUID: gov.noaa.nmfs.inport:33592
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-28 10:55+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