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

Table: CRAT_IFQ_IPQ_PERMIT

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

Summary

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.

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.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
PERMIT_NUMBER
NUMBER 		Sequentially-issued permit number from IFQ_PERMIT table.
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).
SECTOR_CODE
VARCHAR2 		Four QS sectors for Catcher Vessel-Catcher/Processor shares and one PQS sector for the Processor shares.
ISSUED_TO_PERSON
NUMBER 		NMFS ID of IFQ or IPQ permit holder.
REGIONAL_DELIVERY_CODE
VARCHAR2 		Regional delivery requirements as applicable to a fishery: N = North, S = South, W = West, U = Undesignated.
COOP_FLAG
VARCHAR2 		Y indicates that this permit is issued to a Crab Rationalization fishing COOP.
ROFR_ID
NUMBER 		Current ECC_ID from CRAT_ECC_ROFR_COOLING_OFF where ECC_TYPE = ROFR.
COOLING_OFF_ID
NUMBER 		ECC_ID from CRAT_ECC_ROFR_COOLING_OFF where ECC_TYPE = COOL. Expired at end of fishing year 2006.
FORMER_ROFR_ID
NUMBER 		Former ROFR ID (from PQS) if ROFR privilege was used, or waived at time of transfer.

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: 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

Rubric Score Primary Key? Name Type Description
100
 Primary Key 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

CC ID: 223143
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

CC ID: 223144
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

CC ID: 223145
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

CC ID: 223142
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

CC ID: 223146
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

CC ID: 223147
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

CC ID: 223148
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

CC ID: 223149
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

CC ID: 223150
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