Table: VPS_VESSEL
Entity (ENT) | Greater Atlantic Regional Fisheries Office (GARFO)GUID: gov.noaa.nmfs.inport:5128 | Updated: August 9, 2022 | Published / External
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
|
|
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 | 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 |