Metadata Rubric

100%

6 / 6

Alaska Regional Office Library > AKRO Restricted Access Management (RAM) Program... > Groundfish/Crab License Limitation Program (LLP... >

View: V_LLP_CRAB_LICENSE

Entity (ENT) | Alaska Regional Office (AKRO)
GUID: gov.noaa.nmfs.inport:27350 | Updated: August 9, 2022 | Published / External

Item Identification

Title:	View: V_LLP_CRAB_LICENSE
Short Name:	V_LLP_CRAB_LICENSE
Status:	Completed
Abstract:	This view retrieves details about the License Limitation Program (LLP) crab licenses.
Notes:	Loaded by batch 7095, 09-22-2015 13:02

Entity Information

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	AKFISH
Description:	This view retrieves details about the License Limitation Program (LLP) crab licenses.

Data Attributes

Attribute Summary

	Name	Type	Description
100	STATE	VARCHAR2	State in which the license owner resides.
100	LICENSE	VARCHAR2	LLP number.
100	LINKED_LICENSE	VARCHAR2	The groundfish license to which this license is linked. Transfers must include both licenses unless there is a court order.
100	PERSON_ID	NUMBER	NMFS ID of the contact person who owns the license.
100	LICENSEE_NAME	VARCHAR2	Name of the contact person who owns the license.
100	OPERATION_TYPE	VARCHAR2	CV = catcher vessel, C/P = catcher/processor.
100	MLOA	NUMBER	Maximum length overall for the named vessel.
100	ISSUE_DATE	DATE	The date that the last certificate was created.
100	INTERIM_TEXT	VARCHAR2	The license might be temporary until adjudication is completed.
100	LICENSE_TRANSFERABLE	VARCHAR2	Yes indicates that the license is transferable. Applies to people as well as the named vessel.
100	ORIGINAL_VESSEL_ADFG	VARCHAR2	ADFG license number of the original qualifying vessel.
100	ORIGINAL_VESSEL_NAME	VARCHAR2	Name of the original qualifying vessel.
100	CURRENT_VESSEL_ADFG	VARCHAR2	ADFG license number of the named vessel.
100	CURRENT_VESSEL_NAME	VARCHAR2	Current name of the named vessel.
100	AFA_VESSEL_FLAG	VARCHAR2	Y indicates that this license was earned by a vessel that is or was AFA-permitted. May only be used on an AFA vessel.
100	INTERESTED_PARTY	VARCHAR2	People who have asserted an interest in the license and would like to be notified before a transfer occurs.
100	MINOR_SPECIES	VARCHAR2	Y indicates that this license has the Minor Species endorsement; N, if it does not.
100	EASTERN_ALEUTIAN_I_RED_KING	VARCHAR2	Y indicates that this license has the Eastern Aleutian Islands Red King Crab endorsement; N, if it does not.
100	AI_OPILIO_BAIRDI	VARCHAR2	Y indicates that this license has the Aleutian Islands Opilio and Bairdi endorsement; N, if it does not.
100	NORTON_S_RED_BLUE_KING	VARCHAR2	Y indicates that this license has the Norton Sound Red and Blue King Crab endorsement; N, if it does not.
100	NS_ONLY	VARCHAR2	Y indicates that this license has ONLY the Norton Sound Red and Blue King Crab endorsement and no others.

Name

Type

Description

100

STATE

VARCHAR2

State in which the license owner resides.

100

LICENSE

VARCHAR2

LLP number.

100

LINKED_LICENSE

VARCHAR2

The groundfish license to which this license is linked. Transfers must include both licenses unless there is a court order.

100

PERSON_ID

NUMBER

NMFS ID of the contact person who owns the license.

100

LICENSEE_NAME

VARCHAR2

Name of the contact person who owns the license.

100

OPERATION_TYPE

VARCHAR2

CV = catcher vessel, C/P = catcher/processor.

100

MLOA

NUMBER

Maximum length overall for the named vessel.

100

ISSUE_DATE

DATE

The date that the last certificate was created.

100

INTERIM_TEXT

VARCHAR2

The license might be temporary until adjudication is completed.

100

LICENSE_TRANSFERABLE

VARCHAR2

Yes indicates that the license is transferable. Applies to people as well as the named vessel.

100

ORIGINAL_VESSEL_ADFG

VARCHAR2

ADFG license number of the original qualifying vessel.

100

ORIGINAL_VESSEL_NAME

VARCHAR2

Name of the original qualifying vessel.

100

CURRENT_VESSEL_ADFG

VARCHAR2

ADFG license number of the named vessel.

100

CURRENT_VESSEL_NAME

VARCHAR2

Current name of the named vessel.

100

AFA_VESSEL_FLAG

VARCHAR2

Y indicates that this license was earned by a vessel that is or was AFA-permitted. May only be used on an AFA vessel.

100

INTERESTED_PARTY

VARCHAR2

People who have asserted an interest in the license and would like to be notified before a transfer occurs.

100

MINOR_SPECIES

VARCHAR2

Y indicates that this license has the Minor Species endorsement; N, if it does not.

100

EASTERN_ALEUTIAN_I_RED_KING

VARCHAR2

Y indicates that this license has the Eastern Aleutian Islands Red King Crab endorsement; N, if it does not.

100

AI_OPILIO_BAIRDI

VARCHAR2

Y indicates that this license has the Aleutian Islands Opilio and Bairdi endorsement; N, if it does not.

100

NORTON_S_RED_BLUE_KING

VARCHAR2

Y indicates that this license has the Norton Sound Red and Blue King Crab endorsement; N, if it does not.

100

NS_ONLY

VARCHAR2

Y indicates that this license has ONLY the Norton Sound Red and Blue King Crab endorsement and no others.

Attribute Details

STATE

CC ID: 223307

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	State in which the license owner resides.
General Data Type:	VARCHAR2

LICENSE

CC ID: 223318

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	43
Required:	No
Primary Key:	No
Status:	Active
Description:	LLP number.
General Data Type:	VARCHAR2

LINKED_LICENSE

CC ID: 223321

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	43
Required:	No
Primary Key:	No
Status:	Active
Description:	The groundfish license to which this license is linked. Transfers must include both licenses unless there is a court order.
General Data Type:	VARCHAR2

PERSON_ID

CC ID: 223322

Seq. Order:	4
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	38
Scale:	0
Status:	Active
Description:	NMFS ID of the contact person who owns the license.
General Data Type:	NUMBER

LICENSEE_NAME

CC ID: 223323

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	81
Required:	No
Primary Key:	No
Status:	Active
Description:	Name of the contact person who owns the license.
General Data Type:	VARCHAR2

OPERATION_TYPE

CC ID: 223324

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	CV = catcher vessel, C/P = catcher/processor.
General Data Type:	VARCHAR2

MLOA

CC ID: 223325

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	4
Scale:	1
Status:	Active
Description:	Maximum length overall for the named vessel.
General Data Type:	NUMBER

ISSUE_DATE

CC ID: 223326

Seq. Order:	8
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	The date that the last certificate was created.
General Data Type:	DATE

INTERIM_TEXT

CC ID: 223327

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	The license might be temporary until adjudication is completed.
General Data Type:	VARCHAR2

LICENSE_TRANSFERABLE

CC ID: 223308

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Yes indicates that the license is transferable. Applies to people as well as the named vessel.
General Data Type:	VARCHAR2

ORIGINAL_VESSEL_ADFG

CC ID: 223309

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	ADFG license number of the original qualifying vessel.
General Data Type:	VARCHAR2

ORIGINAL_VESSEL_NAME

CC ID: 223310

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	60
Required:	No
Primary Key:	No
Status:	Active
Description:	Name of the original qualifying vessel.
General Data Type:	VARCHAR2

CURRENT_VESSEL_ADFG

CC ID: 223311

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	ADFG license number of the named vessel.
General Data Type:	VARCHAR2

CURRENT_VESSEL_NAME

CC ID: 223312

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	60
Required:	No
Primary Key:	No
Status:	Active
Description:	Current name of the named vessel.
General Data Type:	VARCHAR2

AFA_VESSEL_FLAG

CC ID: 223313

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Y indicates that this license was earned by a vessel that is or was AFA-permitted. May only be used on an AFA vessel.
General Data Type:	VARCHAR2

INTERESTED_PARTY

CC ID: 223314

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	4000
Required:	No
Primary Key:	No
Status:	Active
Description:	People who have asserted an interest in the license and would like to be notified before a transfer occurs.
General Data Type:	VARCHAR2

MINOR_SPECIES

CC ID: 223315

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Y indicates that this license has the Minor Species endorsement; N, if it does not.
General Data Type:	VARCHAR2

EASTERN_ALEUTIAN_I_RED_KING

CC ID: 223316

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Y indicates that this license has the Eastern Aleutian Islands Red King Crab endorsement; N, if it does not.
General Data Type:	VARCHAR2

AI_OPILIO_BAIRDI

CC ID: 223317

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Y indicates that this license has the Aleutian Islands Opilio and Bairdi endorsement; N, if it does not.
General Data Type:	VARCHAR2

NORTON_S_RED_BLUE_KING

CC ID: 223319

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Y indicates that this license has the Norton Sound Red and Blue King Crab endorsement; N, if it does not.
General Data Type:	VARCHAR2

NS_ONLY

CC ID: 223320

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Y indicates that this license has ONLY the Norton Sound Red and Blue King Crab endorsement and no others.
General Data Type:	VARCHAR2

Catalog Details

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