Table: VPS_VESSEL
Entity (ENT) | Greater Atlantic Regional Fisheries Office (GARFO)GUID: gov.noaa.nmfs.inport:4019 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Holds data for vessels permitted by the National Marine Fisheries Service (NMFS), Northeast Region
DescriptionHolds 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 |
6 digit Vessel Permit Number assigned by NERO permit office |
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 |
Maximum 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 1413, 04-20-2007 12:05 |
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
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
AP_YEAR | NUMBER | Application year (aka permit year) that is being issued | |
100
|
![]() |
AP_NUM | NUMBER | Application number - a unique, system generated number assigned to each vessel's permit renewal application |
100
|
VP_NUM | NUMBER | 6 digit Vessel Permit Number assigned by NERO permit office | |
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 | Maximum Trap Limit |
Attribute Details
AP_YEAR
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
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
Seq. Order: | 3 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
6 digit Vessel Permit Number assigned by NERO permit office |
General Data Type: | NUMBER |
HULL_ID
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Seq. Order: | 45 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Maximum Trap Limit |
General Data Type: | NUMBER |
Catalog Details
Catalog Item ID: | 4019 |
---|---|
GUID: | gov.noaa.nmfs.inport:4019 |
Metadata Record Created By: | Dave Gouveia |
Metadata Record Created: | 2007-04-20 12:05+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:10+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 |