View: V_FEDERAL_FISHERIES_PERMIT
Entity (ENT) | Alaska Regional Office (AKRO)GUID: gov.noaa.nmfs.inport:27348 | Updated: August 9, 2022 | Published / External
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
![]() |
![]() |
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |