Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Population and Ecosystems Monitoring and Analys... > Ecosystems Surveys Branch > Dredge Surveys > Sea Scallop Survey >

Table: SVVESSEL

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:33726  |  Updated: August 9, 2022  |  Published / External 
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 9087, 07-28-2016 17:26

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: 337800
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: 337801
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: 337802
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: 337803
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: 337804
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: 337805
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: 337806
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: 337807
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: 33726
GUID: gov.noaa.nmfs.inport:33726
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-28 17:26+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