Table: FVTR_VESSELS
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34397 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Materialized view of the GARFO table PERMIT.VPS_VESSEL; the federal permit history for vessels which have held a federal permit at any time since 1/1/2005
DescriptionMaterialized view of the GARFO table PERMIT.VPS_VESSEL; the federal permit history for vessels which have held a federal permit at any time since 1/1/2005
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
AP_NUM
NUMBER |
Application number - a unique, system generated number assigned to each vessel's permit renewal application |
VESSEL_PERMIT_NUM
NUMBER |
Federally issued 6-digit vessel permit number. Numbers >= 800000 are assigned to NY or ME state-permitted vessels. Matches Vessel_permit_num in the DOCUMENT table. |
VESSEL_HULL_ID
VARCHAR2 |
Hull number of vessel. Similar to the VIN on automobiles. |
VESSEL_NAME
VARCHAR2 |
Name of vessel. |
ISSUE_DATE
DATE |
Date a permit is issued to a vessel |
CANCEL_DATE
DATE |
Date a permit record is canceled |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (NEFSC) for inquiries on this record.
Item Identification
Title: | Table: FVTR_VESSELS |
---|---|
Short Name: | FVTR_VESSELS |
Status: | Completed |
Abstract: |
Materialized view of the GARFO table PERMIT.VPS_VESSEL; the federal permit history for vessels which have held a federal permit at any time since 1/1/2005 |
Notes: |
Loaded by batch 9209, 08-23-2016 08:38 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | FVTR |
Description: |
Materialized view of the GARFO table PERMIT.VPS_VESSEL; the federal permit history for vessels which have held a federal permit at any time since 1/1/2005 |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
![]() |
AP_NUM | NUMBER | Application number - a unique, system generated number assigned to each vessel's permit renewal application |
100
|
VESSEL_PERMIT_NUM | NUMBER | Federally issued 6-digit vessel permit number. Numbers >= 800000 are assigned to NY or ME state-permitted vessels. Matches Vessel_permit_num in the DOCUMENT table. | |
100
|
VESSEL_HULL_ID | VARCHAR2 | Hull number of vessel. Similar to the VIN on automobiles. | |
100
|
VESSEL_NAME | VARCHAR2 | Name of vessel. | |
100
|
ISSUE_DATE | DATE | Date a permit is issued to a vessel | |
100
|
CANCEL_DATE | DATE | Date a permit record is canceled |
Attribute Details
AP_NUM
Seq. Order: | 1 |
---|---|
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 |
VESSEL_PERMIT_NUM
Seq. Order: | 2 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Federally issued 6-digit vessel permit number. Numbers >= 800000 are assigned to NY or ME state-permitted vessels. Matches Vessel_permit_num in the DOCUMENT table. |
General Data Type: | NUMBER |
VESSEL_HULL_ID
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Hull number of vessel. Similar to the VIN on automobiles. |
General Data Type: | VARCHAR2 |
VESSEL_NAME
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 25 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of vessel. |
General Data Type: | VARCHAR2 |
ISSUE_DATE
Seq. Order: | 5 |
---|---|
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 |
CANCEL_DATE
Seq. Order: | 6 |
---|---|
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 |
Catalog Details
Catalog Item ID: | 34397 |
---|---|
GUID: | gov.noaa.nmfs.inport:34397 |
Metadata Record Created By: | Patricia L Jones |
Metadata Record Created: | 2016-08-23 08:38+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-08-23 |
Owner Org: | NEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-08-23 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-08-23 |