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

Table: RP_QUOTA_SHARE

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

Summary

Abstract

This table contains a record of the initially-issued quota shares for the Rockfish Program.

Description

This table contains a record of the initially-issued quota shares for the Rockfish Program.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
LLP_NUMBER
NUMBER 		License Limitation Program license number.
SECTOR_CODE
VARCHAR2 		CP = Catcher Processor, CV = Catcher Vessel.
SPECIES_GROUP_ID
NUMBER 		Unique identifier of the rockfish primary species group from the SPECIES_GROUP table.
NUMQS
NUMBER 		Number of quota shares (QS) issued to the LLP for the species.
DATE_OF_ISSUANCE
DATE 		Date of quota share issuance.
COMMENTS
VARCHAR2 		Information about the initial issuance.
REVOKED_FLAG
VARCHAR2 		Y indicates that the quota shares have been revoked; N, if not.
REVOKED_DATE
DATE 		Date the quota shares were revoked.
VERSION_NUMBER
NUMBER 		Version of record beginning with 1 for original, and sequentially incrementing for every change.
CURRENT_VERSION_FLAG
VARCHAR2 		Y indicates current version of record; N, otherwise.
CREATED_BY
VARCHAR2 		Username of the person who created the most current record.
CREATED_DATE
DATE 		Date the most current record was created.
INITIAL_ISSUANCE_FLAG
VARCHAR2 		Y indicates that this row was a part of the initial issuance.
DELINQUENT_FLAG
VARCHAR2 		Y indicates the LLP is a member of a cooperative that is delinquent on previous years' cost recovery fees; N, otherwise.

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

This table contains a record of the initially-issued quota shares for the Rockfish Program.
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 a record of the initially-issued quota shares for the Rockfish Program.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key LLP_NUMBER NUMBER License Limitation Program license number.
100
 Primary Key SECTOR_CODE VARCHAR2 CP = Catcher Processor, CV = Catcher Vessel.
100
 Primary Key SPECIES_GROUP_ID NUMBER Unique identifier of the rockfish primary species group from the SPECIES_GROUP table.
100
 NUMQS NUMBER Number of quota shares (QS) issued to the LLP for the species.
100
 DATE_OF_ISSUANCE DATE Date of quota share issuance.
100
 COMMENTS VARCHAR2 Information about the initial issuance.
100
 REVOKED_FLAG VARCHAR2 Y indicates that the quota shares have been revoked; N, if not.
100
 REVOKED_DATE DATE Date the quota shares were revoked.
100
 Primary Key VERSION_NUMBER NUMBER Version of record beginning with 1 for original, and sequentially incrementing for every change.
100
 CURRENT_VERSION_FLAG VARCHAR2 Y indicates current version of record; N, otherwise.
100
 CREATED_BY VARCHAR2 Username of the person who created the most current record.
100
 CREATED_DATE DATE Date the most current record was created.
100
 INITIAL_ISSUANCE_FLAG VARCHAR2 Y indicates that this row was a part of the initial issuance.
100
 DELINQUENT_FLAG VARCHAR2 Y indicates the LLP is a member of a cooperative that is delinquent on previous years' cost recovery fees; N, otherwise.

Attribute Details

LLP_NUMBER

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

License Limitation Program license number.
General Data Type: NUMBER
Foreign Key Relations:

AKFISH.LLP_GROUNDFISH_LICENSE

SECTOR_CODE

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

CP = Catcher Processor, CV = Catcher Vessel.
General Data Type: VARCHAR2

SPECIES_GROUP_ID

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

Unique identifier of the rockfish primary species group from the SPECIES_GROUP table.
General Data Type: NUMBER
Foreign Key Relations:

AKFISH.SPECIES_GROUP

NUMQS

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

Number of quota shares (QS) issued to the LLP for the species.
General Data Type: NUMBER

DATE_OF_ISSUANCE

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

Date of quota share issuance.
General Data Type: DATE

COMMENTS

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

Information about the initial issuance.
General Data Type: VARCHAR2

REVOKED_FLAG

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

Y indicates that the quota shares have been revoked; N, if not.
General Data Type: VARCHAR2

REVOKED_DATE

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

Date the quota shares were revoked.
General Data Type: DATE

VERSION_NUMBER

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

Version of record beginning with 1 for original, and sequentially incrementing for every change.
General Data Type: NUMBER

CURRENT_VERSION_FLAG

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

Y indicates current version of record; N, otherwise.
General Data Type: VARCHAR2

CREATED_BY

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

Username of the person who created the most current record.
General Data Type: VARCHAR2

CREATED_DATE

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

Date the most current record was created.
General Data Type: DATE

INITIAL_ISSUANCE_FLAG

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

Y indicates that this row was a part of the initial issuance.
General Data Type: VARCHAR2

DELINQUENT_FLAG

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

Y indicates the LLP is a member of a cooperative that is delinquent on previous years' cost recovery fees; N, otherwise.
General Data Type: VARCHAR2

Catalog Details

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