Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Regional Office Library > AKRO Restricted Access Management (RAM) Program... > American Fisheries Act (AFA) Permit Program >

View: V_AFA_PERMIT

Entity (ENT)  |  Alaska Regional Office (AKRO)
GUID: gov.noaa.nmfs.inport:26547  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

The combined data from AFA COOPs, vessels and processors.

Description

The combined data from AFA COOPs, vessels and processors.

Entity Information

Entity Type
Data View

Data Attribute / Type Description
PERMIT_NUMBER
NUMBER 		This is the permit number assigned to the AFA entity.
PERMIT_TYPE
VARCHAR2 		This is the type of permit issued based on the AFA requirements: catcher vessel, catcher processor, inshore processor, inshore cooperative, mothership.
STATUS
VARCHAR2 		This indicates the current status of the permit: Active, Inactive, etc.
INTERIM_FLAG
VARCHAR2 		This flag indicates that the permit is interim and not permanent.
END_DATE
DATE 		This is the end date of the permit.
VESS_PROCPLANT_COOP
CHAR 		Indicates the type of ID found in the ID column: V = vessel ID, P = processing plant ID, C = AFA coop ID.
ID
NUMBER 		For vessels, this is the vessel ID; for processing plants, this is the plant ID; for AFA coops, this is the AFA coop ID.
NAME
VARCHAR2 		Name of the vessel, processing plant, or AFA coop.
INSHORE_PROCESSOR_TYPE
VARCHAR2 		F = Floating, S = Shoreside.
COOP_PROCESSOR_END_FLAG
VARCHAR2 		No longer used.
CRAB_END_BBRK_FLAG
VARCHAR2 		No longer used.
CRAB_END_STMBK_FLAG
VARCHAR2 		No longer used.
CRAB_END_PRBK_FLAG
VARCHAR2 		No longer used.
CRAB_END_AIBK_FLAG
VARCHAR2 		No longer used.
CRAB_END_AIRK_FLAG
VARCHAR2 		No longer used.
CRAB_END_BAOT_FLAG
VARCHAR2 		No longer used.
CRAB_END_BABT_FLAG
VARCHAR2 		No longer used.
VESSEL_REPLACEMENT_FLAG
VARCHAR2 		Indicates whether or not this vessel is a replacement vessel for AFA Permit purposes.
REPLACED_BY_VESSEL
VARCHAR2 		The vessel ID of the replacement vessel.
AFA_CV_DELIVERY_TO_CP_FLAG
VARCHAR2 		Indicates catcher vessel qualifies to deliver to catcher processors.
AFA_CV_DELIVERY_TO_M_FLAG
VARCHAR2 		Indicates catcher vessel qualifies to deliver to motherships.
AFA_CV_DELIVERY_TO_INS_FLAG
VARCHAR2 		Indicates catcher vessel qualifies to deliver to inshore processors.
AFA_CV_BSAI_PCOD_EXEMPT_FLAG
VARCHAR2 		Indicates whether a catcher vessel may be exempt from Bering Sea Aleutian Islands Pacific cod sideboards.
AFA_CV_GOA_SIDE_EXEMPT_FLAG
VARCHAR2 		Indicates whether a catcher vessel may be exempt from Gulf of Alaska sideboards.
AFA_CATCHER_PROCESSOR_FLAG
VARCHAR2 		Indicates whether the vessel qualifies as an AFA catcher processor.
AFA_MOTHERSHIP_FLAG
VARCHAR2 		Indicates whether the vessel qualifies as an AFA mothership.
AFA_UNRESTRICT_SHORESIDE_FLAG
VARCHAR2 		Indicates AFA eligibility by virtue of processing more than 2000 metric tons.
AFA_RESTRICTED_SHORESIDE_FLAG
VARCHAR2 		Indicates AFA eligibility by virtue of processing less than 2000 metric tons.
AFA_SECT_209_INELIGIBLE_FLAG
VARCHAR2 		Indicates permanent ineligibility for any limited access fishery.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (AKRO) for inquiries on this record.

Item Identification

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

The combined data from AFA COOPs, vessels and processors.
Notes:

Loaded by batch 6893, 08-21-2015 14:18

Entity Information

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

The combined data from AFA COOPs, vessels and processors.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 PERMIT_NUMBER NUMBER This is the permit number assigned to the AFA entity.
100
 PERMIT_TYPE VARCHAR2 This is the type of permit issued based on the AFA requirements: catcher vessel, catcher processor, inshore processor, inshore cooperative, mothership.
100
 STATUS VARCHAR2 This indicates the current status of the permit: Active, Inactive, etc.
100
 INTERIM_FLAG VARCHAR2 This flag indicates that the permit is interim and not permanent.
100
 END_DATE DATE This is the end date of the permit.
100
 VESS_PROCPLANT_COOP CHAR Indicates the type of ID found in the ID column: V = vessel ID, P = processing plant ID, C = AFA coop ID.
100
 ID NUMBER For vessels, this is the vessel ID; for processing plants, this is the plant ID; for AFA coops, this is the AFA coop ID.
100
 NAME VARCHAR2 Name of the vessel, processing plant, or AFA coop.
100
 INSHORE_PROCESSOR_TYPE VARCHAR2 F = Floating, S = Shoreside.
100
 COOP_PROCESSOR_END_FLAG VARCHAR2 No longer used.
100
 CRAB_END_BBRK_FLAG VARCHAR2 No longer used.
100
 CRAB_END_STMBK_FLAG VARCHAR2 No longer used.
100
 CRAB_END_PRBK_FLAG VARCHAR2 No longer used.
100
 CRAB_END_AIBK_FLAG VARCHAR2 No longer used.
100
 CRAB_END_AIRK_FLAG VARCHAR2 No longer used.
100
 CRAB_END_BAOT_FLAG VARCHAR2 No longer used.
100
 CRAB_END_BABT_FLAG VARCHAR2 No longer used.
100
 VESSEL_REPLACEMENT_FLAG VARCHAR2 Indicates whether or not this vessel is a replacement vessel for AFA Permit purposes.
100
 REPLACED_BY_VESSEL VARCHAR2 The vessel ID of the replacement vessel.
100
 AFA_CV_DELIVERY_TO_CP_FLAG VARCHAR2 Indicates catcher vessel qualifies to deliver to catcher processors.
100
 AFA_CV_DELIVERY_TO_M_FLAG VARCHAR2 Indicates catcher vessel qualifies to deliver to motherships.
100
 AFA_CV_DELIVERY_TO_INS_FLAG VARCHAR2 Indicates catcher vessel qualifies to deliver to inshore processors.
100
 AFA_CV_BSAI_PCOD_EXEMPT_FLAG VARCHAR2 Indicates whether a catcher vessel may be exempt from Bering Sea Aleutian Islands Pacific cod sideboards.
100
 AFA_CV_GOA_SIDE_EXEMPT_FLAG VARCHAR2 Indicates whether a catcher vessel may be exempt from Gulf of Alaska sideboards.
100
 AFA_CATCHER_PROCESSOR_FLAG VARCHAR2 Indicates whether the vessel qualifies as an AFA catcher processor.
100
 AFA_MOTHERSHIP_FLAG VARCHAR2 Indicates whether the vessel qualifies as an AFA mothership.
100
 AFA_UNRESTRICT_SHORESIDE_FLAG VARCHAR2 Indicates AFA eligibility by virtue of processing more than 2000 metric tons.
100
 AFA_RESTRICTED_SHORESIDE_FLAG VARCHAR2 Indicates AFA eligibility by virtue of processing less than 2000 metric tons.
100
 AFA_SECT_209_INELIGIBLE_FLAG VARCHAR2 Indicates permanent ineligibility for any limited access fishery.

Attribute Details

PERMIT_NUMBER

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

This is the permit number assigned to the AFA entity.
General Data Type: NUMBER

PERMIT_TYPE

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

This is the type of permit issued based on the AFA requirements: catcher vessel, catcher processor, inshore processor, inshore cooperative, mothership.
General Data Type: VARCHAR2

STATUS

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

This indicates the current status of the permit: Active, Inactive, etc.
General Data Type: VARCHAR2

INTERIM_FLAG

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

This flag indicates that the permit is interim and not permanent.
General Data Type: VARCHAR2

END_DATE

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

This is the end date of the permit.
General Data Type: DATE

VESS_PROCPLANT_COOP

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

Indicates the type of ID found in the ID column: V = vessel ID, P = processing plant ID, C = AFA coop ID.
General Data Type: CHAR

ID

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

For vessels, this is the vessel ID; for processing plants, this is the plant ID; for AFA coops, this is the AFA coop ID.
General Data Type: NUMBER

NAME

CC ID: 213844
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

Name of the vessel, processing plant, or AFA coop.
General Data Type: VARCHAR2

INSHORE_PROCESSOR_TYPE

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

F = Floating, S = Shoreside.
General Data Type: VARCHAR2

COOP_PROCESSOR_END_FLAG

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

No longer used.
General Data Type: VARCHAR2

CRAB_END_BBRK_FLAG

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

No longer used.
General Data Type: VARCHAR2

CRAB_END_STMBK_FLAG

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

No longer used.
General Data Type: VARCHAR2

CRAB_END_PRBK_FLAG

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

No longer used.
General Data Type: VARCHAR2

CRAB_END_AIBK_FLAG

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

No longer used.
General Data Type: VARCHAR2

CRAB_END_AIRK_FLAG

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

No longer used.
General Data Type: VARCHAR2

CRAB_END_BAOT_FLAG

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

No longer used.
General Data Type: VARCHAR2

CRAB_END_BABT_FLAG

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

No longer used.
General Data Type: VARCHAR2

VESSEL_REPLACEMENT_FLAG

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

Indicates whether or not this vessel is a replacement vessel for AFA Permit purposes.
General Data Type: VARCHAR2

REPLACED_BY_VESSEL

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

The vessel ID of the replacement vessel.
General Data Type: VARCHAR2

AFA_CV_DELIVERY_TO_CP_FLAG

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

Indicates catcher vessel qualifies to deliver to catcher processors.
General Data Type: VARCHAR2

AFA_CV_DELIVERY_TO_M_FLAG

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

Indicates catcher vessel qualifies to deliver to motherships.
General Data Type: VARCHAR2

AFA_CV_DELIVERY_TO_INS_FLAG

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

Indicates catcher vessel qualifies to deliver to inshore processors.
General Data Type: VARCHAR2

AFA_CV_BSAI_PCOD_EXEMPT_FLAG

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

Indicates whether a catcher vessel may be exempt from Bering Sea Aleutian Islands Pacific cod sideboards.
General Data Type: VARCHAR2

AFA_CV_GOA_SIDE_EXEMPT_FLAG

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

Indicates whether a catcher vessel may be exempt from Gulf of Alaska sideboards.
General Data Type: VARCHAR2

AFA_CATCHER_PROCESSOR_FLAG

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

Indicates whether the vessel qualifies as an AFA catcher processor.
General Data Type: VARCHAR2

AFA_MOTHERSHIP_FLAG

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

Indicates whether the vessel qualifies as an AFA mothership.
General Data Type: VARCHAR2

AFA_UNRESTRICT_SHORESIDE_FLAG

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

Indicates AFA eligibility by virtue of processing more than 2000 metric tons.
General Data Type: VARCHAR2

AFA_RESTRICTED_SHORESIDE_FLAG

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

Indicates AFA eligibility by virtue of processing less than 2000 metric tons.
General Data Type: VARCHAR2

AFA_SECT_209_INELIGIBLE_FLAG

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

Indicates permanent ineligibility for any limited access fishery.
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 26547
GUID: gov.noaa.nmfs.inport:26547
Metadata Record Created By: Pamela A Mason
Metadata Record Created: 2015-08-21 14:18+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