Metadata Rubric

100%

6 / 6

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

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

	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.

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