Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
GARFO Metadata Library > _Information Resources Management (IRM) Divisio... > Vessel Permit System > Vessel Permit System Data Set >

Table: VPS_VESSEL

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

Summary

Abstract

Holds data for vessels permitted by the National Marine Fisheries Service (NMFS), Northeast Region

Description

Holds data for vessels permitted by the National Marine Fisheries Service (NMFS), Northeast Region

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
AP_YEAR
NUMBER 		Application year (aka permit year) that is being issued
AP_NUM
NUMBER 		Application number - a unique, system generated number assigned to each vessel's permit renewal application
VP_NUM
NUMBER 		Permit Number
HULL_ID
VARCHAR2 		Hull identifier - this can be a state registration or a coast guard documentation number
HULL_ID_EXP_DATE
DATE 		Hull id expiration date - the date state registration or a coast guard documentation expires
VES_NAME
VARCHAR2 		Vessel name
STRT1
VARCHAR2 		Street address line 1 - primary street address information
STRT2
VARCHAR2 		Street address line 2 - auxilliary address information such as suite number or PO box number
CITY
VARCHAR2 		City name
ST
CHAR 		Standard two letter state abbreviation
ZIP1
CHAR 		Zip code 1 - 5 digit zip code
ZIP2
CHAR 		Zip code 2 - additional 4 digit zip code
TEL
CHAR 		Telephone number - area code, exchange and number
ADR_STAT
CHAR 		Address status - determines if address if known to be correct (T) or incorrect (F)
HPORT
VARCHAR2 		Hailing port -vessel mooring location
HPST
CHAR 		State in which hailing port is located
PPORT
VARCHAR2 		Principal port - main vessel landings location
PPST
CHAR 		State in which principal port is located
LEN
NUMBER 		Length, in feet, of the vessel
CREW
NUMBER 		Crew size - the number of people comprising the crew, including the Captain
GTONS
NUMBER 		Gross registered tonnage specified on the USCG documentation for a vessel
NTONS
NUMBER 		Net tonnage (gross tonnage minus the hold capacity) specified on the USCG documentation for a vessel
VHP
NUMBER 		Vessel engine horsepower
BLT
NUMBER 		Year the vessel was built
HOLD
NUMBER 		Hold capacity of the vessel, in pounds
TOC
NUMBER 		Type of construction - wood (1), fiberglass (2), steel (3), other (4)
TOP
NUMBER 		Type of propulsion - gasoline (1), deisel (2), other (3)
DATE_ISSUED
DATE 		Date a permit is issued to a vessel
DATE_CANCELED
DATE 		Date a permit record is canceled
CANX
NUMBER 		Cancellation reason (aka renewal reason) - reason code for renewal of permit and cancellation of the previous permit
DE
DATE 		Date of entry - Date a vessel record is entered
UE
VARCHAR2 		User of entry - User that entered the vessel record
DC
DATE 		Date Changed
UC
VARCHAR2 		User Changed
AGENT_FIRST
VARCHAR2 		Suffix (Esq, Sr., etc) of the vessel owner's or owners' authorized representative
AGENT_MIDDLE
VARCHAR2 		MIddle name or initial of the vessel owner's or owners' authorized representative
AGENT_LAST
VARCHAR2 		Last name of the vessel owner's or owners' authorized representative
AGENT_SUFFIX
VARCHAR2 		Agent Suffix
NPASS
NUMBER 		Maximum number of passengers allowed
DREGS
NUMBER 		Dredge gear size
DREGN
NUMBER 		Number of dredges in use
PHP
NUMBER 		Pump horsepower
NUM_TRAPS
NUMBER 		Number of lobster traps in use
REMARK
VARCHAR2 		Information relevent to the vessel or it's permit renewal circumstances
MAX_TRAP_LIMIT
NUMBER 		Max Trap Limit

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: VPS_VESSEL
Short Name: VPS_VESSEL
Status: Completed
Abstract:

Holds data for vessels permitted by the National Marine Fisheries Service (NMFS), Northeast Region
Notes:

Loaded by batch 1579, 09-04-2007 12:20

Entity Information

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

Holds data for vessels permitted by the National Marine Fisheries Service (NMFS), Northeast Region

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 AP_YEAR NUMBER Application year (aka permit year) that is being issued
100
 Primary Key AP_NUM NUMBER Application number - a unique, system generated number assigned to each vessel's permit renewal application
100
 VP_NUM NUMBER Permit Number
100
 HULL_ID VARCHAR2 Hull identifier - this can be a state registration or a coast guard documentation number
100
 HULL_ID_EXP_DATE DATE Hull id expiration date - the date state registration or a coast guard documentation expires
100
 VES_NAME VARCHAR2 Vessel name
100
 STRT1 VARCHAR2 Street address line 1 - primary street address information
100
 STRT2 VARCHAR2 Street address line 2 - auxilliary address information such as suite number or PO box number
100
 CITY VARCHAR2 City name
100
 ST CHAR Standard two letter state abbreviation
100
 ZIP1 CHAR Zip code 1 - 5 digit zip code
100
 ZIP2 CHAR Zip code 2 - additional 4 digit zip code
100
 TEL CHAR Telephone number - area code, exchange and number
100
 ADR_STAT CHAR Address status - determines if address if known to be correct (T) or incorrect (F)
100
 HPORT VARCHAR2 Hailing port -vessel mooring location
100
 HPST CHAR State in which hailing port is located
100
 PPORT VARCHAR2 Principal port - main vessel landings location
100
 PPST CHAR State in which principal port is located
100
 LEN NUMBER Length, in feet, of the vessel
100
 CREW NUMBER Crew size - the number of people comprising the crew, including the Captain
100
 GTONS NUMBER Gross registered tonnage specified on the USCG documentation for a vessel
100
 NTONS NUMBER Net tonnage (gross tonnage minus the hold capacity) specified on the USCG documentation for a vessel
100
 VHP NUMBER Vessel engine horsepower
100
 BLT NUMBER Year the vessel was built
100
 HOLD NUMBER Hold capacity of the vessel, in pounds
100
 TOC NUMBER Type of construction - wood (1), fiberglass (2), steel (3), other (4)
100
 TOP NUMBER Type of propulsion - gasoline (1), deisel (2), other (3)
100
 DATE_ISSUED DATE Date a permit is issued to a vessel
100
 DATE_CANCELED DATE Date a permit record is canceled
100
 CANX NUMBER Cancellation reason (aka renewal reason) - reason code for renewal of permit and cancellation of the previous permit
100
 DE DATE Date of entry - Date a vessel record is entered
100
 UE VARCHAR2 User of entry - User that entered the vessel record
100
 DC DATE Date Changed
100
 UC VARCHAR2 User Changed
100
 AGENT_FIRST VARCHAR2 Suffix (Esq, Sr., etc) of the vessel owner's or owners' authorized representative
100
 AGENT_MIDDLE VARCHAR2 MIddle name or initial of the vessel owner's or owners' authorized representative
100
 AGENT_LAST VARCHAR2 Last name of the vessel owner's or owners' authorized representative
100
 AGENT_SUFFIX VARCHAR2 Agent Suffix
100
 NPASS NUMBER Maximum number of passengers allowed
100
 DREGS NUMBER Dredge gear size
100
 DREGN NUMBER Number of dredges in use
100
 PHP NUMBER Pump horsepower
100
 NUM_TRAPS NUMBER Number of lobster traps in use
100
 REMARK VARCHAR2 Information relevent to the vessel or it's permit renewal circumstances
100
 MAX_TRAP_LIMIT NUMBER Max Trap Limit

Attribute Details

AP_YEAR

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

Application year (aka permit year) that is being issued
General Data Type: NUMBER

AP_NUM

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

Application number - a unique, system generated number assigned to each vessel's permit renewal application
General Data Type: NUMBER

VP_NUM

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

Permit Number
General Data Type: NUMBER

HULL_ID

CC ID: 14702
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Hull identifier - this can be a state registration or a coast guard documentation number
General Data Type: VARCHAR2

HULL_ID_EXP_DATE

CC ID: 14703
Seq. Order: 5
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Hull id expiration date - the date state registration or a coast guard documentation expires
General Data Type: DATE

VES_NAME

CC ID: 14721
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Vessel name
General Data Type: VARCHAR2

STRT1

CC ID: 14714
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Street address line 1 - primary street address information
General Data Type: VARCHAR2

STRT2

CC ID: 14715
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Street address line 2 - auxilliary address information such as suite number or PO box number
General Data Type: VARCHAR2

CITY

CC ID: 14690
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

City name
General Data Type: VARCHAR2

ST

CC ID: 14713
Seq. Order: 10
Data Storage Type: CHAR
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Standard two letter state abbreviation
General Data Type: CHAR

ZIP1

CC ID: 14724
Seq. Order: 11
Data Storage Type: CHAR
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Zip code 1 - 5 digit zip code
General Data Type: CHAR

ZIP2

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

Zip code 2 - additional 4 digit zip code
General Data Type: CHAR

TEL

CC ID: 14716
Seq. Order: 13
Data Storage Type: CHAR
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Telephone number - area code, exchange and number
General Data Type: CHAR

ADR_STAT

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

Address status - determines if address if known to be correct (T) or incorrect (F)
General Data Type: CHAR

HPORT

CC ID: 14700
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Hailing port -vessel mooring location
General Data Type: VARCHAR2

HPST

CC ID: 14701
Seq. Order: 16
Data Storage Type: CHAR
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

State in which hailing port is located
General Data Type: CHAR

PPORT

CC ID: 14710
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Principal port - main vessel landings location
General Data Type: VARCHAR2

PPST

CC ID: 14711
Seq. Order: 18
Data Storage Type: CHAR
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

State in which principal port is located
General Data Type: CHAR

LEN

CC ID: 14704
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 2
Status: Active
Description:

Length, in feet, of the vessel
General Data Type: NUMBER

CREW

CC ID: 14691
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Crew size - the number of people comprising the crew, including the Captain
General Data Type: NUMBER

GTONS

CC ID: 14698
Seq. Order: 21
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Gross registered tonnage specified on the USCG documentation for a vessel
General Data Type: NUMBER

NTONS

CC ID: 14707
Seq. Order: 22
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Net tonnage (gross tonnage minus the hold capacity) specified on the USCG documentation for a vessel
General Data Type: NUMBER

VHP

CC ID: 14722
Seq. Order: 23
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Vessel engine horsepower
General Data Type: NUMBER

BLT

CC ID: 14688
Seq. Order: 24
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Year the vessel was built
General Data Type: NUMBER

HOLD

CC ID: 14699
Seq. Order: 25
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 7
Scale: 0
Status: Active
Description:

Hold capacity of the vessel, in pounds
General Data Type: NUMBER

TOC

CC ID: 14717
Seq. Order: 26
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Type of construction - wood (1), fiberglass (2), steel (3), other (4)
General Data Type: NUMBER

TOP

CC ID: 14718
Seq. Order: 27
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Type of propulsion - gasoline (1), deisel (2), other (3)
General Data Type: NUMBER

DATE_ISSUED

CC ID: 14693
Seq. Order: 28
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date a permit is issued to a vessel
General Data Type: DATE

DATE_CANCELED

CC ID: 14692
Seq. Order: 29
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date a permit record is canceled
General Data Type: DATE

CANX

CC ID: 14689
Seq. Order: 30
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Cancellation reason (aka renewal reason) - reason code for renewal of permit and cancellation of the previous permit
General Data Type: NUMBER

DE

CC ID: 14695
Seq. Order: 31
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date of entry - Date a vessel record is entered
General Data Type: DATE

UE

CC ID: 14720
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

User of entry - User that entered the vessel record
General Data Type: VARCHAR2

DC

CC ID: 14694
Seq. Order: 33
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date Changed
General Data Type: DATE

UC

CC ID: 14719
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

User Changed
General Data Type: VARCHAR2

AGENT_FIRST

CC ID: 14682
Seq. Order: 35
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Suffix (Esq, Sr., etc) of the vessel owner's or owners' authorized representative
General Data Type: VARCHAR2

AGENT_MIDDLE

CC ID: 14684
Seq. Order: 36
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

MIddle name or initial of the vessel owner's or owners' authorized representative
General Data Type: VARCHAR2

AGENT_LAST

CC ID: 14683
Seq. Order: 37
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Last name of the vessel owner's or owners' authorized representative
General Data Type: VARCHAR2

AGENT_SUFFIX

CC ID: 14685
Seq. Order: 38
Data Storage Type: VARCHAR2
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Agent Suffix
General Data Type: VARCHAR2

NPASS

CC ID: 14706
Seq. Order: 39
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Maximum number of passengers allowed
General Data Type: NUMBER

DREGS

CC ID: 14697
Seq. Order: 40
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Dredge gear size
General Data Type: NUMBER

DREGN

CC ID: 14696
Seq. Order: 41
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Number of dredges in use
General Data Type: NUMBER

PHP

CC ID: 14709
Seq. Order: 42
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Pump horsepower
General Data Type: NUMBER

NUM_TRAPS

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

Number of lobster traps in use
General Data Type: NUMBER

REMARK

CC ID: 14712
Seq. Order: 44
Data Storage Type: VARCHAR2
Max Length: 144
Required: No
Primary Key: No
Status: Active
Description:

Information relevent to the vessel or it's permit renewal circumstances
General Data Type: VARCHAR2

MAX_TRAP_LIMIT

CC ID: 14705
Seq. Order: 45
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Max Trap Limit
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 5128
GUID: gov.noaa.nmfs.inport:5128
Metadata Record Created By: SysAdmin InPortAdmin
Metadata Record Created: 2007-09-04 12:20+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-02-29
Owner Org: GARFO
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-02-29
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-02-28