Slide Menu
Jump to Section...
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_FISHERY_NER

Entity (ENT)  |  Greater Atlantic Regional Fisheries Office (GARFO)
GUID: gov.noaa.nmfs.inport:4017  |  Updated: August 9, 2022  |  Published / External 

Item Identification

Title: Table: VPS_FISHERY_NER
Short Name: VPS_FISHERY_NER
Status: Completed
Abstract:

Holds data for a vessel's permitted fisheries
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 a vessel's permitted fisheries

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 AP_YEAR NUMBER Application year (aka permit year) of a permitted fishery
100
 AP_NUM NUMBER Application number - connects fishery record to a unique vessel application
100
 VP_NUM NUMBER Vessel permit number
100
 PLAN VARCHAR2 Fishery management plan
100
 CAT VARCHAR2 Category of a fishery management plan
100
 DAS NUMBER Days at Sea - the maximum number of fishing days allowed for a particulat plan and category
100
 DATE_ISSUED DATE Date a permitted fishery is granted to a vessel
100
 START_DATE DATE First day a permitted fishery becomes active
100
 END_DATE DATE Last day a permitted fishery is active
100
 DATE_EXPIRED DATE Date a permitted fishery expires due to a fishery or owner change
100
 DATE_CANCELED DATE Date a permitted fishery is no longer valid due to a change or cancellation
100
 CANX NUMBER Cancellation reason
100
 DE DATE Date entered
100
 UE VARCHAR2 User of entry
100
 DC DATE Date changed
100
 UC VARCHAR2 User of change
100
 AUTH_ID NUMBER Authorization ID

Attribute Details

AP_YEAR

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

Application year (aka permit year) of a permitted fishery
General Data Type: NUMBER

AP_NUM

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

Application number - connects fishery record to a unique vessel application
General Data Type: NUMBER

VP_NUM

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

Vessel permit number
General Data Type: NUMBER

PLAN

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

Fishery management plan
General Data Type: VARCHAR2

CAT

CC ID: 7942
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Category of a fishery management plan
General Data Type: VARCHAR2

DAS

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

Days at Sea - the maximum number of fishing days allowed for a particulat plan and category
General Data Type: NUMBER

DATE_ISSUED

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

Date a permitted fishery is granted to a vessel
General Data Type: DATE

START_DATE

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

First day a permitted fishery becomes active
General Data Type: DATE

END_DATE

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

Last day a permitted fishery is active
General Data Type: DATE

DATE_EXPIRED

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

Date a permitted fishery expires due to a fishery or owner change
General Data Type: DATE

DATE_CANCELED

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

Date a permitted fishery is no longer valid due to a change or cancellation
General Data Type: DATE

CANX

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

Cancellation reason
General Data Type: NUMBER

DE

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

Date entered
General Data Type: DATE

UE

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

User of entry
General Data Type: VARCHAR2

DC

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

Date changed
General Data Type: DATE

UC

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

User of change
General Data Type: VARCHAR2

AUTH_ID

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

Authorization ID
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 4017
GUID: gov.noaa.nmfs.inport:4017
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