Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Regional Office Library > AKRO Restricted Access Management (RAM) Program... > IFQ Halibut/Sablefish and CDQ Halibut Permit Pr... >

View: QS_HOLDERS_W_ADDRESS

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

Summary

Abstract

This view shows all current Pacific halibut and sablefish quota share holders with current mailing address.

Description

This view shows all current Pacific halibut and sablefish quota share holders with current mailing address.

Entity Information

Entity Type
Data View

Data Attribute / Type Description
PERSON_ID
NUMBER 		NMFS Person ID of the quota share holder.
NAME
VARCHAR2 		Name of quota share holder.
ADDRESS_LINE_1
VARCHAR2 		Mailing address of the quota share holder.
ADDRESS_LINE_2
VARCHAR2 		Mailing address of the quota share holder.
CITY
VARCHAR2 		Mailing address city.
STATE
VARCHAR2 		Mailing address state.
ZIP
VARCHAR2 		Mailing address zip code.
SPECIES
VARCHAR2 		200 = Halibut, 710 = Sablefish.
AREA
VARCHAR2 		IFQ Area Code: IPHC area code for halibut or NMFS management area for sablefish.
VCC
VARCHAR2 		Vessel category - A: Processor, B: >60 ft, C: <=60ft (sablefish), C: >35<=60 ft (halibut), D: <=35ft, E: category B that is not fish-downable.
BLOCKED
VARCHAR2 		B = Blocked, U = Unblocked, C = CDQ compensation quota share awarded in unearned areas as compensation for QS awarded to CDQ Groups in other areas, NULL = No units.
FISH_DOWN
VARCHAR2 		Indicates whether or not IFQ associated with this quota share can be fished on a smaller vessel.
NUMQS
NUMBER 		Number of quota share units.
EQUIVELANT_IFQ
NUMBER 		Number of IFQ pounds that may be associated with this number of quota share units based on annual Total Allowable Catch and quota share pools.
QS_ID
NUMBER 		ID of the quota share group to which the quota share units are assigned.
QS_SEQUENCE
NUMBER 		Sequence number within the quota share group.
START_QS_NUMBER
NUMBER 		Beginning serial number for total quota share units.
CDQ_COMP
CHAR 		Indicates whether or not quota share was awarded as CDQ compensation.

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

This view shows all current Pacific halibut and sablefish quota share holders with current mailing address.
Notes:

Loaded by batch 6893, 08-21-2015 14:18

Entity Information

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

This view shows all current Pacific halibut and sablefish quota share holders with current mailing address.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 PERSON_ID NUMBER NMFS Person ID of the quota share holder.
100
 NAME VARCHAR2 Name of quota share holder.
100
 ADDRESS_LINE_1 VARCHAR2 Mailing address of the quota share holder.
100
 ADDRESS_LINE_2 VARCHAR2 Mailing address of the quota share holder.
100
 CITY VARCHAR2 Mailing address city.
100
 STATE VARCHAR2 Mailing address state.
100
 ZIP VARCHAR2 Mailing address zip code.
100
 SPECIES VARCHAR2 200 = Halibut, 710 = Sablefish.
100
 AREA VARCHAR2 IFQ Area Code: IPHC area code for halibut or NMFS management area for sablefish.
100
 VCC VARCHAR2 Vessel category - A: Processor, B: >60 ft, C: <=60ft (sablefish), C: >35<=60 ft (halibut), D: <=35ft, E: category B that is not fish-downable.
100
 BLOCKED VARCHAR2 B = Blocked, U = Unblocked, C = CDQ compensation quota share awarded in unearned areas as compensation for QS awarded to CDQ Groups in other areas, NULL = No units.
100
 FISH_DOWN VARCHAR2 Indicates whether or not IFQ associated with this quota share can be fished on a smaller vessel.
100
 NUMQS NUMBER Number of quota share units.
100
 EQUIVELANT_IFQ NUMBER Number of IFQ pounds that may be associated with this number of quota share units based on annual Total Allowable Catch and quota share pools.
100
 QS_ID NUMBER ID of the quota share group to which the quota share units are assigned.
100
 QS_SEQUENCE NUMBER Sequence number within the quota share group.
100
 START_QS_NUMBER NUMBER Beginning serial number for total quota share units.
100
 CDQ_COMP CHAR Indicates whether or not quota share was awarded as CDQ compensation.

Attribute Details

PERSON_ID

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

NMFS Person ID of the quota share holder.
General Data Type: NUMBER

NAME

CC ID: 213786
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 61
Required: No
Primary Key: No
Status: Active
Description:

Name of quota share holder.
General Data Type: VARCHAR2

ADDRESS_LINE_1

CC ID: 213787
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 45
Required: No
Primary Key: No
Status: Active
Description:

Mailing address of the quota share holder.
General Data Type: VARCHAR2

ADDRESS_LINE_2

CC ID: 213788
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Mailing address of the quota share holder.
General Data Type: VARCHAR2

CITY

CC ID: 213789
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Mailing address city.
General Data Type: VARCHAR2

STATE

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

Mailing address state.
General Data Type: VARCHAR2

ZIP

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

Mailing address zip code.
General Data Type: VARCHAR2

SPECIES

CC ID: 213792
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

200 = Halibut, 710 = Sablefish.
General Data Type: VARCHAR2

AREA

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

IFQ Area Code: IPHC area code for halibut or NMFS management area for sablefish.
General Data Type: VARCHAR2

VCC

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

Vessel category - A: Processor, B: >60 ft, C: <=60ft (sablefish), C: >35<=60 ft (halibut), D: <=35ft, E: category B that is not fish-downable.
General Data Type: VARCHAR2

BLOCKED

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

B = Blocked, U = Unblocked, C = CDQ compensation quota share awarded in unearned areas as compensation for QS awarded to CDQ Groups in other areas, NULL = No units.
General Data Type: VARCHAR2

FISH_DOWN

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

Indicates whether or not IFQ associated with this quota share can be fished on a smaller vessel.
General Data Type: VARCHAR2

NUMQS

CC ID: 213780
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Number of quota share units.
General Data Type: NUMBER

EQUIVELANT_IFQ

CC ID: 213781
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Number of IFQ pounds that may be associated with this number of quota share units based on annual Total Allowable Catch and quota share pools.
General Data Type: NUMBER

QS_ID

CC ID: 213782
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

ID of the quota share group to which the quota share units are assigned.
General Data Type: NUMBER

QS_SEQUENCE

CC ID: 213783
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Sequence number within the quota share group.
General Data Type: NUMBER

START_QS_NUMBER

CC ID: 213784
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Beginning serial number for total quota share units.
General Data Type: NUMBER

CDQ_COMP

CC ID: 213785
Seq. Order: 18
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicates whether or not quota share was awarded as CDQ compensation.
General Data Type: CHAR

Catalog Details

Catalog Item ID: 26544
GUID: gov.noaa.nmfs.inport:26544
Metadata Record Created By: Pamela A Mason
Metadata Record Created: 2015-08-21 14:18+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