Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: View: V_FEDERAL_FISHERIES_PERMIT
Short Name: V_FEDERAL_FISHERIES_PERMIT
Status: Completed
Abstract:

This view retrieves current information about Federal Fisheries Permits, as well as Federal Processor Permits..Each endorsement is in its own column, and there is one row per permit.

Notes:

Loaded by batch 7095, 09-22-2015 13:02

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: AKFISH
Description:

This view retrieves current information about Federal Fisheries Permits, as well as Federal Processor Permits..Each endorsement is in its own column, and there is one row per permit.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
PERMIT_ID NUMBER Unique ID of the permit.
100
PERMIT_TYPE VARCHAR2 F = fishing vessel, P = processing vessel or shoreside plant.
100
VESSEL_PROCESSOR_CODE CHAR V = vessel, P = shoreside.
100
PERMIT_OWNER_ID NUMBER NMFS ID of the permit owner.
100
PLANT_ID NUMBER NMFS ID of the shoreside plant.
100
BEGIN_DATE DATE Permit cycle begin date.
100
END_DATE DATE Permit cycle end date.
100
ISSUE_DATE DATE Date the permit was created or the permit cycle begin date, whichever is later.
100
UNDER_SANCTION_FLAG VARCHAR2 Y indicates that the permit is sanctioned.
100
STATUS VARCHAR2 A = Active, X = eXpired, P = Pending, V = Voluntary surrender, R = Revoked.
100
CREATE_DATE DATE Date row was created.
100
PROCESSING_FLAG VARCHAR2 Y indicates receives a Federal Processor Permit (FPP).
100
BERINGSEA_FLAG VARCHAR2 Y indicates endorsed for fishing in the Bering Sea.
100
GULFALASKA_FLAG VARCHAR2 Y indicates endorsed for fishing in the Gulf of Alaska.
100
HOOKLINE_FLAG VARCHAR2 Y indicates endorsed for hook and line gear.
100
JIGTROLL_FLAG VARCHAR2 Y indicates endorsed for jig/troll gear.
100
POT_FLAG VARCHAR2 Y indicates endorsed for pot gear.
100
TRAWL_FLAG VARCHAR2 Y indicates endorsed for trawl gear.
100
CATCHER_FLAG VARCHAR2 Y indicates catcher vessel.
100
CATCHER_PROCESSOR_FLAG VARCHAR2 Y indicates catcher/processor vessel.
100
MTH_3_200_FLAG VARCHAR2 Y indicates mothership within the 3- to 200-mile zone.
100
SUPPORT_VESSEL_FLAG VARCHAR2 Y indicates support vessel.
100
TENDER_VESSEL_FLAG VARCHAR2 Y indicates tender vessel.
100
STATIONARY_FLOATING_FLAG VARCHAR2 Y indicates stationary floating vessel (gets a Federal Processor Permit).
100
PCOD_HAL_FLAG VARCHAR2 Y indicates Pacific cod fishery with hook and line gear.
100
PCOD_POT_FLAG VARCHAR2 Y indicates Pacific cod fishery with pot gear.
100
PCOD_TRW_FLAG VARCHAR2 Y indicates Pacific cod fishery with trawl gear.
100
PLCK_HAL_FLAG VARCHAR2 Y indicates pollock fishery with hook and line gear.
100
PLCK_POT_FLAG VARCHAR2 Y indicates pollock fishery with pot gear.
100
PLCK_TRW_FLAG VARCHAR2 Y indicates pollock fishery with trawl gear.
100
AMCK_HAL_FLAG VARCHAR2 Y indicates Atka mackerel fishery with hook and line gear.
100
AMCK_POT_FLAG VARCHAR2 Y indicates Atka mackerel fishery with pot gear.
100
AMCK_TRW_FLAG VARCHAR2 Y indicates Atka mackerel fishery with trawl gear.
100
GOA_INSHORE_FLAG VARCHAR2 Y indicates Gulf of Alaska Inshore fishery.
100
GOA_PCOD_FLAG VARCHAR2 Y indicates Gulf of Alaska Pacific cod fishery.
100
BSAI_PCOD_FLAG VARCHAR2 Y indicates Bering Sea Aleutian Islands Pacific cod fishery.
100
GOA_PLCK_FLAG VARCHAR2 Y indicates Gulf of Alaska pollock fishery.
100
BSAI_PLCK_FLAG VARCHAR2 Y indicates Bering Sea Aleutian Islands pollock fishery.
100
CRAT_SIDEBOARD_FLAG VARCHAR2 Y indicates subject to GOA groundfish directed fishery sideboard closures.
100
CRAT_EXCEPT_PCOD_FLAG VARCHAR2 Y indicates subject to GOA groundfish directed fishery sideboard closures, not including Pacific cod closures.
100
CRAT_NO_PCOD_FLAG VARCHAR2 Y indicates may not directed fish for GOA Pacific cod.
100
CRAT_EXCEPT_PCOD_PLCK_FLAG VARCHAR2 Y indicates subject to GOA groundfish directed fishery sideboard closures, except Pacific cod and pollock.
100
CRAT_EXCEPT_PLCK_FLAG VARCHAR2 Y indicates subject to GOA groundfish directed fishery sideboard closures, except pollock.
100
RPP_CV_FLAG VARCHAR2 Y indicates subject to catcher vessel rockfish sideboard.
100
RPP_CP_FLAG VARCHAR2 Y indicates subject to catcher/processor rockfish sideboard.
100
A80_FLAG VARCHAR2 Y indicates Amendment 80 vessel and subject to its sideboards.
100
GOA_FLOAT_FLAG VARCHAR2 Y indicates GOA Community Quota Entity (CQE) Floating Processor regulations, effective January 2012, established new floating processor for GOA operating in CQE communities.
100
SHORESIDE_FLAG CHAR Y indicates shoreside processing plant.

Attribute Details

PERMIT_ID

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

Unique ID of the permit.

General Data Type: NUMBER

PERMIT_TYPE

CC ID: 223252
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

F = fishing vessel, P = processing vessel or shoreside plant.

General Data Type: VARCHAR2

VESSEL_PROCESSOR_CODE

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

V = vessel, P = shoreside.

General Data Type: CHAR

PERMIT_OWNER_ID

CC ID: 223274
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

NMFS ID of the permit owner.

General Data Type: NUMBER

PLANT_ID

CC ID: 223284
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

NMFS ID of the shoreside plant.

General Data Type: NUMBER

BEGIN_DATE

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

Permit cycle begin date.

General Data Type: DATE

END_DATE

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

Permit cycle end date.

General Data Type: DATE

ISSUE_DATE

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

Date the permit was created or the permit cycle begin date, whichever is later.

General Data Type: DATE

UNDER_SANCTION_FLAG

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

Y indicates that the permit is sanctioned.

General Data Type: VARCHAR2

STATUS

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

A = Active, X = eXpired, P = Pending, V = Voluntary surrender, R = Revoked.

General Data Type: VARCHAR2

CREATE_DATE

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

Date row was created.

General Data Type: DATE

PROCESSING_FLAG

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

Y indicates receives a Federal Processor Permit (FPP).

General Data Type: VARCHAR2

BERINGSEA_FLAG

CC ID: 223245
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Y indicates endorsed for fishing in the Bering Sea.

General Data Type: VARCHAR2

GULFALASKA_FLAG

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

Y indicates endorsed for fishing in the Gulf of Alaska.

General Data Type: VARCHAR2

HOOKLINE_FLAG

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

Y indicates endorsed for hook and line gear.

General Data Type: VARCHAR2

JIGTROLL_FLAG

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

Y indicates endorsed for jig/troll gear.

General Data Type: VARCHAR2

POT_FLAG

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

Y indicates endorsed for pot gear.

General Data Type: VARCHAR2

TRAWL_FLAG

CC ID: 223250
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Y indicates endorsed for trawl gear.

General Data Type: VARCHAR2

CATCHER_FLAG

CC ID: 223251
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Y indicates catcher vessel.

General Data Type: VARCHAR2

CATCHER_PROCESSOR_FLAG

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

Y indicates catcher/processor vessel.

General Data Type: VARCHAR2

MTH_3_200_FLAG

CC ID: 223254
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Y indicates mothership within the 3- to 200-mile zone.

General Data Type: VARCHAR2

SUPPORT_VESSEL_FLAG

CC ID: 223255
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Y indicates support vessel.

General Data Type: VARCHAR2

TENDER_VESSEL_FLAG

CC ID: 223256
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Y indicates tender vessel.

General Data Type: VARCHAR2

STATIONARY_FLOATING_FLAG

CC ID: 223257
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Y indicates stationary floating vessel (gets a Federal Processor Permit).

General Data Type: VARCHAR2

PCOD_HAL_FLAG

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

Y indicates Pacific cod fishery with hook and line gear.

General Data Type: VARCHAR2

PCOD_POT_FLAG

CC ID: 223259
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Y indicates Pacific cod fishery with pot gear.

General Data Type: VARCHAR2

PCOD_TRW_FLAG

CC ID: 223260
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Y indicates Pacific cod fishery with trawl gear.

General Data Type: VARCHAR2

PLCK_HAL_FLAG

CC ID: 223261
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Y indicates pollock fishery with hook and line gear.

General Data Type: VARCHAR2

PLCK_POT_FLAG

CC ID: 223262
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Y indicates pollock fishery with pot gear.

General Data Type: VARCHAR2

PLCK_TRW_FLAG

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

Y indicates pollock fishery with trawl gear.

General Data Type: VARCHAR2

AMCK_HAL_FLAG

CC ID: 223265
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Y indicates Atka mackerel fishery with hook and line gear.

General Data Type: VARCHAR2

AMCK_POT_FLAG

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

Y indicates Atka mackerel fishery with pot gear.

General Data Type: VARCHAR2

AMCK_TRW_FLAG

CC ID: 223267
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Y indicates Atka mackerel fishery with trawl gear.

General Data Type: VARCHAR2

GOA_INSHORE_FLAG

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

Y indicates Gulf of Alaska Inshore fishery.

General Data Type: VARCHAR2

GOA_PCOD_FLAG

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

Y indicates Gulf of Alaska Pacific cod fishery.

General Data Type: VARCHAR2

BSAI_PCOD_FLAG

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

Y indicates Bering Sea Aleutian Islands Pacific cod fishery.

General Data Type: VARCHAR2

GOA_PLCK_FLAG

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

Y indicates Gulf of Alaska pollock fishery.

General Data Type: VARCHAR2

BSAI_PLCK_FLAG

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

Y indicates Bering Sea Aleutian Islands pollock fishery.

General Data Type: VARCHAR2

CRAT_SIDEBOARD_FLAG

CC ID: 223273
Seq. Order: 39
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Y indicates subject to GOA groundfish directed fishery sideboard closures.

General Data Type: VARCHAR2

CRAT_EXCEPT_PCOD_FLAG

CC ID: 223275
Seq. Order: 40
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Y indicates subject to GOA groundfish directed fishery sideboard closures, not including Pacific cod closures.

General Data Type: VARCHAR2

CRAT_NO_PCOD_FLAG

CC ID: 223276
Seq. Order: 41
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Y indicates may not directed fish for GOA Pacific cod.

General Data Type: VARCHAR2

CRAT_EXCEPT_PCOD_PLCK_FLAG

CC ID: 223277
Seq. Order: 42
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Y indicates subject to GOA groundfish directed fishery sideboard closures, except Pacific cod and pollock.

General Data Type: VARCHAR2

CRAT_EXCEPT_PLCK_FLAG

CC ID: 223278
Seq. Order: 43
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Y indicates subject to GOA groundfish directed fishery sideboard closures, except pollock.

General Data Type: VARCHAR2

RPP_CV_FLAG

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

Y indicates subject to catcher vessel rockfish sideboard.

General Data Type: VARCHAR2

RPP_CP_FLAG

CC ID: 223280
Seq. Order: 45
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Y indicates subject to catcher/processor rockfish sideboard.

General Data Type: VARCHAR2

A80_FLAG

CC ID: 223281
Seq. Order: 46
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Y indicates Amendment 80 vessel and subject to its sideboards.

General Data Type: VARCHAR2

GOA_FLOAT_FLAG

CC ID: 223282
Seq. Order: 47
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Y indicates GOA Community Quota Entity (CQE) Floating Processor regulations, effective January 2012, established new floating processor for GOA operating in CQE communities.

General Data Type: VARCHAR2

SHORESIDE_FLAG

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

Y indicates shoreside processing plant.

General Data Type: CHAR

Catalog Details

Catalog Item ID: 27348
GUID: gov.noaa.nmfs.inport:27348
Metadata Record Created By: Pamela A Mason
Metadata Record Created: 2015-09-22 13:02+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2015-12-14
Owner Org: AKRO
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2015-12-14
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2016-12-14