Slide Menu
Jump to Section...
Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
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 

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