Table: IFQ_PERMIT
Entity (ENT) | Alaska Regional Office (AKRO)GUID: gov.noaa.nmfs.inport:27344 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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.
DescriptionThis 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
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
![]() |
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |