Table: SVVESSEL
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33599 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Support table identifying all vessel codes and descriptions.
DescriptionSupport 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 9070, 07-28-2016 11:11 |
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
Name | Type | Description | ||
---|---|---|---|---|
100
|
VESSEL_NAME | VARCHAR2 | Name of vessel. | |
100
|
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
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
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
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
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
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
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
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
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: | 33599 |
---|---|
GUID: | gov.noaa.nmfs.inport:33599 |
Metadata Record Created By: | Patricia L Jones |
Metadata Record Created: | 2016-07-28 11:11+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 |