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

Table: RPP_INITIAL_ISSUANCE

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

Summary

Abstract

A record of the initially issued QS

Description

A record of the initially issued QS

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
LLP_NUMBER
NUMBER 		llp license number
SPECIES_GROUP
VARCHAR2 		species group
SECTOR_CODE
VARCHAR2 		CP = Catcher Processor, CV = Catcher Vessel
NUMQS
NUMBER 		number of QS
DATE_OF_ISSUANCE
DATE 		date of issuance
COMMENTS
VARCHAR2 		comments
REVOKED_FLAG
VARCHAR2 		revoked?
REVOKED_DATE
DATE 		date revoked

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

A record of the initially issued QS
Notes:

Loaded by batch 1500, 07-13-2007 09:18

Physical Location

Organization: Alaska Regional Office
City: Juneau
State/Province: AK
Country: USA

Entity Information

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

A record of the initially issued QS

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key LLP_NUMBER NUMBER llp license number
100
 Primary Key SPECIES_GROUP VARCHAR2 species group
100
 Primary Key SECTOR_CODE VARCHAR2 CP = Catcher Processor, CV = Catcher Vessel
100
 NUMQS NUMBER number of QS
100
 DATE_OF_ISSUANCE DATE date of issuance
100
 COMMENTS VARCHAR2 comments
100
 Primary Key REVOKED_FLAG VARCHAR2 revoked?
100
 REVOKED_DATE DATE date revoked

Attribute Details

LLP_NUMBER

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

llp license number
General Data Type: NUMBER

SPECIES_GROUP

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

species group
General Data Type: VARCHAR2

SECTOR_CODE

CC ID: 11315
Seq. Order: 3
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

NUMQS

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

number of QS
General Data Type: NUMBER

DATE_OF_ISSUANCE

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

date of issuance
General Data Type: DATE

COMMENTS

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

comments
General Data Type: VARCHAR2

REVOKED_FLAG

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

revoked?
General Data Type: VARCHAR2

REVOKED_DATE

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

date revoked
General Data Type: DATE

Catalog Details

Catalog Item ID: 4613
GUID: gov.noaa.nmfs.inport:4613
Metadata Record Created By: Pamela A Mason
Metadata Record Created: 2007-07-13 09:18+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:10+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