Slide Menu
Search Help Show/Hide Menu

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