Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Regional Office Library > AKRO Restricted Access Management (RAM) Program... > IFQ Halibut/Sablefish and CDQ Halibut Permit Pr... >

Table: IFQ_PERMIT

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

Summary

Abstract

This table contains information about the ability of a person to conduct Individual Fishing Quota (IFQ) fishing. Each permit is uniquely identified by an IFQ permit number..Permit numbers are not retired or transferred, once issued.

Description

This table contains information about the ability of a person to conduct Individual Fishing Quota (IFQ) fishing. Each permit is uniquely identified by an IFQ permit number..Permit numbers are not retired or transferred, once issued.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
PERMIT_NUMBER
NUMBER 		IFQ Permit Number.
ISSUED_TO_PERSON
NUMBER 		NMFS ID of the IFQ permit holder.
SPECIES
NUMBER 		Management Program Species ID.
IFQ_SPECIES_CODE
VARCHAR2 		200 = halibut, 710 = sablefish.
HALIBUT_VESSEL_CATEGORY_CODE
VARCHAR2 		Codes A, B, C, or D reflect how IFQ can be used in terms of vessel length and at-sea processing. Q reflects a CQE-derived permit that can be fished on any-sized vessel.
SABLEFISH_VESSEL_CATEGORY_CODE
VARCHAR2 		Codes A, B, or C reflect how IFQ can be used in terms of vessel length and at-sea processing. Q reflects a CQE-derived permit that can be fished on any-sized vessel.
FISH_DOWN_FLAG
VARCHAR2 		Y indicates that IFQ may be used on smaller vessels than the category dictates. Legacy.
UNDER_SANCTION_FLAG
VARCHAR2 		Y indicates that this permit is under IFQ sanction by NOAA General Council.
PIN
NUMBER 		PIN number for this permit's ATM card. Legacy.
RESET_PIN
NUMBER 		Reset when enable PIN. Legacy.
CDQ_GROUP_FLAG
VARCHAR2 		Y indicates that this permit is held by a Community Development Quota (CDQ) Group.
CQEA_DERIVED_IFQ_FLAG
VARCHAR2 		Y indicates that the IFQ on this permit was leased from a Community Quota Entity (CQE), and vessel category code 'Q' reflects that.
BENEFICIARY_DERIVED_IFQ_FLAG
VARCHAR2 		Y indicates that this permit is held by a beneficiary.
FISHABLE_BY_MASTER_FLAG
VARCHAR2 		Y indicates that the IFQ came from B, C or D Quota Share (QS) that was transferred post February 12, 2010, making it exempt from the hired master provision.

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: Table: IFQ_PERMIT
Short Name: IFQ_PERMIT
Status: Completed
Abstract:

This table contains information about the ability of a person to conduct Individual Fishing Quota (IFQ) fishing. Each permit is uniquely identified by an IFQ permit number..Permit numbers are not retired or transferred, once issued.
Notes:

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

Entity Information

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

This table contains information about the ability of a person to conduct Individual Fishing Quota (IFQ) fishing. Each permit is uniquely identified by an IFQ permit number..Permit numbers are not retired or transferred, once issued.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key PERMIT_NUMBER NUMBER IFQ Permit Number.
100
 ISSUED_TO_PERSON NUMBER NMFS ID of the IFQ permit holder.
100
 SPECIES NUMBER Management Program Species ID.
100
 IFQ_SPECIES_CODE VARCHAR2 200 = halibut, 710 = sablefish.
100
 HALIBUT_VESSEL_CATEGORY_CODE VARCHAR2 Codes A, B, C, or D reflect how IFQ can be used in terms of vessel length and at-sea processing. Q reflects a CQE-derived permit that can be fished on any-sized vessel.
100
 SABLEFISH_VESSEL_CATEGORY_CODE VARCHAR2 Codes A, B, or C reflect how IFQ can be used in terms of vessel length and at-sea processing. Q reflects a CQE-derived permit that can be fished on any-sized vessel.
100
 FISH_DOWN_FLAG VARCHAR2 Y indicates that IFQ may be used on smaller vessels than the category dictates. Legacy.
100
 UNDER_SANCTION_FLAG VARCHAR2 Y indicates that this permit is under IFQ sanction by NOAA General Council.
100
 PIN NUMBER PIN number for this permit's ATM card. Legacy.
100
 RESET_PIN NUMBER Reset when enable PIN. Legacy.
100
 CDQ_GROUP_FLAG VARCHAR2 Y indicates that this permit is held by a Community Development Quota (CDQ) Group.
100
 CQEA_DERIVED_IFQ_FLAG VARCHAR2 Y indicates that the IFQ on this permit was leased from a Community Quota Entity (CQE), and vessel category code 'Q' reflects that.
100
 BENEFICIARY_DERIVED_IFQ_FLAG VARCHAR2 Y indicates that this permit is held by a beneficiary.
100
 FISHABLE_BY_MASTER_FLAG VARCHAR2 Y indicates that the IFQ came from B, C or D Quota Share (QS) that was transferred post February 12, 2010, making it exempt from the hired master provision.

Attribute Details

PERMIT_NUMBER

CC ID: 223186
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 38
Scale: 0
Status: Active
Description:

IFQ Permit Number.
General Data Type: NUMBER

ISSUED_TO_PERSON

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

NMFS ID of the IFQ permit holder.
General Data Type: NUMBER
Foreign Key Relations:

AKFISH.PERSON

SPECIES

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

Management Program Species ID.
General Data Type: NUMBER
Foreign Key Relations:

AKFISH.MANAGEMENT_PROGRAM_SPEC

IFQ_SPECIES_CODE

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

200 = halibut, 710 = sablefish.
General Data Type: VARCHAR2

HALIBUT_VESSEL_CATEGORY_CODE

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

Codes A, B, C, or D reflect how IFQ can be used in terms of vessel length and at-sea processing. Q reflects a CQE-derived permit that can be fished on any-sized vessel.
General Data Type: VARCHAR2

SABLEFISH_VESSEL_CATEGORY_CODE

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

Codes A, B, or C reflect how IFQ can be used in terms of vessel length and at-sea processing. Q reflects a CQE-derived permit that can be fished on any-sized vessel.
General Data Type: VARCHAR2

FISH_DOWN_FLAG

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

Y indicates that IFQ may be used on smaller vessels than the category dictates. Legacy.
General Data Type: VARCHAR2

UNDER_SANCTION_FLAG

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

Y indicates that this permit is under IFQ sanction by NOAA General Council.
General Data Type: VARCHAR2

PIN

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

PIN number for this permit's ATM card. Legacy.
General Data Type: NUMBER

RESET_PIN

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

Reset when enable PIN. Legacy.
General Data Type: NUMBER

CDQ_GROUP_FLAG

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

Y indicates that this permit is held by a Community Development Quota (CDQ) Group.
General Data Type: VARCHAR2

CQEA_DERIVED_IFQ_FLAG

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

Y indicates that the IFQ on this permit was leased from a Community Quota Entity (CQE), and vessel category code 'Q' reflects that.
General Data Type: VARCHAR2

BENEFICIARY_DERIVED_IFQ_FLAG

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

Y indicates that this permit is held by a beneficiary.
General Data Type: VARCHAR2

FISHABLE_BY_MASTER_FLAG

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

Y indicates that the IFQ came from B, C or D Quota Share (QS) that was transferred post February 12, 2010, making it exempt from the hired master provision.
General Data Type: VARCHAR2

Catalog Details

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