Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
GARFO Metadata Library > _Sustainable Fisheries Division (SFD) Metadata... > Research Document System > RDD Databases >

Table: VESSEL_INFORMATION

Entity (ENT)  |  Greater Atlantic Regional Fisheries Office (GARFO)
GUID: gov.noaa.nmfs.inport:17215  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Physical Location
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Vessel Information

Description

Vessel Information

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
PERMIT_NUMBER
VARCHAR2 		Vessel permit number
HULL_NUMBER
VARCHAR2 		Vessel Hull Number
VESSEL_NAME
VARCHAR2 		Vessel name
ACTIVE
CHAR 		Vessel active?
ID_NUMBER
NUMBER 		Form ID (foreign key)
VESSEL_KEY
NUMBER 		Vessel key
WAIVER
CHAR 		Waiver? (bool)
SANCTION
CHAR 		Sanction? (bool)

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

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

Vessel Information
Notes:

Loaded by batch 3835, 12-12-2012 17:48

Physical Location

Organization: Greater Atlantic Regional Fisheries Office
City: Gloucester
State/Province: MA
Country: USA
Location Description:

Sustainable Fisheries Division

55 Great Republic Drive

Entity Information

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

Vessel Information

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 PERMIT_NUMBER VARCHAR2 Vessel permit number
100
 HULL_NUMBER VARCHAR2 Vessel Hull Number
100
 VESSEL_NAME VARCHAR2 Vessel name
100
 ACTIVE CHAR Vessel active?
100
 ID_NUMBER NUMBER Form ID (foreign key)
100
 Primary Key VESSEL_KEY NUMBER Vessel key
100
 WAIVER CHAR Waiver? (bool)
100
 SANCTION CHAR Sanction? (bool)

Attribute Details

PERMIT_NUMBER

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

Vessel permit number
General Data Type: VARCHAR2

HULL_NUMBER

CC ID: 80920
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 400
Required: No
Primary Key: No
Status: Active
Description:

Vessel Hull Number
General Data Type: VARCHAR2

VESSEL_NAME

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

Vessel name
General Data Type: VARCHAR2

ACTIVE

CC ID: 80918
Seq. Order: 4
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Vessel active?
General Data Type: CHAR

ID_NUMBER

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

Form ID (foreign key)
General Data Type: NUMBER

VESSEL_KEY

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

Vessel key
General Data Type: NUMBER

WAIVER

CC ID: 80916
Seq. Order: 7
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Waiver? (bool)
General Data Type: CHAR

SANCTION

CC ID: 80914
Seq. Order: 8
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Sanction? (bool)
General Data Type: CHAR

Catalog Details

Catalog Item ID: 17215
GUID: gov.noaa.nmfs.inport:17215
Metadata Record Created By: Denise A Washick
Metadata Record Created: 2012-12-12 17:48+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-02-25
Owner Org: GARFO
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-02-25
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-02-25