Table: CRAT_IFQ_IPQ_PERMIT
Entity (ENT) | Alaska Regional Office (AKRO)GUID: gov.noaa.nmfs.inport:27340 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | Table: CRAT_IFQ_IPQ_PERMIT |
---|---|
Short Name: | CRAT_IFQ_IPQ_PERMIT |
Status: | Completed |
Abstract: |
This table contains IFQ permit information. Once issued, permit numbers are never transferred or deleted..The underlying permit account handles all balances on an annual basis. |
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 IFQ permit information. Once issued, permit numbers are never transferred or deleted..The underlying permit account handles all balances on an annual basis. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
PERMIT_NUMBER | NUMBER | Sequentially-issued permit number from IFQ_PERMIT table. | |
100
|
CLASS_CODE | VARCHAR2 | A = must be delivered to an RCR with A IPQ, B = Deliverable to any RCR, U = Undesignated class, R = Class with regional delivery restrictions (only issued if TAC-dependent IPQ requirements are met for a year). | |
100
|
SECTOR_CODE | VARCHAR2 | Four QS sectors for Catcher Vessel-Catcher/Processor shares and one PQS sector for the Processor shares. | |
100
|
ISSUED_TO_PERSON | NUMBER | NMFS ID of IFQ or IPQ permit holder. | |
100
|
REGIONAL_DELIVERY_CODE | VARCHAR2 | Regional delivery requirements as applicable to a fishery: N = North, S = South, W = West, U = Undesignated. | |
100
|
COOP_FLAG | VARCHAR2 | Y indicates that this permit is issued to a Crab Rationalization fishing COOP. | |
100
|
ROFR_ID | NUMBER | Current ECC_ID from CRAT_ECC_ROFR_COOLING_OFF where ECC_TYPE = ROFR. | |
100
|
COOLING_OFF_ID | NUMBER | ECC_ID from CRAT_ECC_ROFR_COOLING_OFF where ECC_TYPE = COOL. Expired at end of fishing year 2006. | |
100
|
FORMER_ROFR_ID | NUMBER | Former ROFR ID (from PQS) if ROFR privilege was used, or waived at time of transfer. |
Attribute Details
PERMIT_NUMBER
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Sequentially-issued permit number from IFQ_PERMIT table. |
General Data Type: | NUMBER |
CLASS_CODE
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
A = must be delivered to an RCR with A IPQ, B = Deliverable to any RCR, U = Undesignated class, R = Class with regional delivery restrictions (only issued if TAC-dependent IPQ requirements are met for a year). |
General Data Type: | VARCHAR2 |
SECTOR_CODE
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Four QS sectors for Catcher Vessel-Catcher/Processor shares and one PQS sector for the Processor shares. |
General Data Type: | VARCHAR2 |
ISSUED_TO_PERSON
Seq. Order: | 4 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
NMFS ID of IFQ or IPQ permit holder. |
General Data Type: | NUMBER |
Foreign Key Relations: |
AKFISH.CRAT_PERSON |
REGIONAL_DELIVERY_CODE
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Regional delivery requirements as applicable to a fishery: N = North, S = South, W = West, U = Undesignated. |
General Data Type: | VARCHAR2 |
COOP_FLAG
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Y indicates that this permit is issued to a Crab Rationalization fishing COOP. |
General Data Type: | VARCHAR2 |
ROFR_ID
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
Current ECC_ID from CRAT_ECC_ROFR_COOLING_OFF where ECC_TYPE = ROFR. |
General Data Type: | NUMBER |
COOLING_OFF_ID
Seq. Order: | 8 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
ECC_ID from CRAT_ECC_ROFR_COOLING_OFF where ECC_TYPE = COOL. Expired at end of fishing year 2006. |
General Data Type: | NUMBER |
FORMER_ROFR_ID
Seq. Order: | 9 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Former ROFR ID (from PQS) if ROFR privilege was used, or waived at time of transfer. |
General Data Type: | NUMBER |
Catalog Details
Catalog Item ID: | 27340 |
---|---|
GUID: | gov.noaa.nmfs.inport:27340 |
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 |