Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Current groundfish license details all in one view.

Description

Current groundfish license details all in one view.

Entity Information

Entity Type
Data View

Data Attribute / Type Description
STATE
VARCHAR2
State in which the license owner resides.
LICENSE
VARCHAR2
LLP number.
LINKED_LICENSE
VARCHAR2
The crab license to which this license is linked. Transfers must include both licenses unless there is a court order.
PERSON_ID
NUMBER
NMFS ID of the contact person who owns the license.
LICENSEE_NAME
VARCHAR2
Name of the contact person who owns the license.
OPERATION_TYPE
VARCHAR2
CV = Catcher Vessel, C/P = Catcher/Processor.
MLOA
NUMBER
Maximum length overall for the named vessel.
ISSUE_DATE
DATE
The date that the last certificate was created.
EXPIRATION_DATE
DATE
Date a license owned by a Community Quota Entity expires.
INTERIM_TEXT
VARCHAR2
The license might be temporary until adjudication is completed.
TRANSFERABLE
VARCHAR2
Yes = The license is transferable. Applies to owners as well as named vessels.
OQ_VESSEL_ONLY
VARCHAR2
Y = Only the original qualifying vessel may be named on this license.
ORIGINAL_VESSEL_ID
NUMBER
NMFS ID of the original qualifying vessel.
ORIGINAL_VESSEL_ADFG
VARCHAR2
Alaska Department of Fish and Game number of the original qualifying vessel.
ORIGINAL_VESSEL_NAME
VARCHAR2
Name of the original qualifying vessel.
CURRENT_VESSEL_ID
NUMBER
Current NMFS ID of the named vessel.
CURRENT_VESSEL_ADFG
VARCHAR2
Current Alaska Department of Fish and Game number of the named vessel.
CURRENT_VESSEL_NAME
VARCHAR2
Current name of the named vessel.
AFA_VESSEL
VARCHAR2
Y = This license was earned by a vessel that is or was AFA-permitted. May only be used on an AFA vessel.
INTERESTED_PARTY
VARCHAR2
People who have asserted an interest in the license and would like to be notified before a transfer occurs.
ALEUTIAN_ISLANDS_GROUNDFISH
VARCHAR2
License is endorsed for this area.
BERING_SEA_GROUNDFISH
VARCHAR2
License is endorsed for this area.
CENTRAL_GULF_GROUNDFISH
VARCHAR2
License is endorsed for this area.
SOUTHEAST_OUTSIDE_GROUNDFISH
VARCHAR2
License is endorsed for this area.
WESTERN_GULF_GROUNDFISH
VARCHAR2
License is endorsed for this area.
PCOD
VARCHAR2
List of Pacific cod endorsements for this license.
CR_SIDEBOARDS
VARCHAR2
List of crab rationalization sideboards for this license.
RP_CV_SIDEBOARDED
VARCHAR2
Y = Subject to rockfish catcher vessel sideboards.
RP_CP_SIDEBOARDED
VARCHAR2
Y = Subject to rockfish catcher processor sideboards.
RP_CV_QUOTA
VARCHAR2
Y = Holds rockfish catcher vessel quota.
RP_CP_QUOTA
VARCHAR2
Y = Holds rockfish catcher processor quota.
AMENDMENT_80
VARCHAR2
Y = Has an Amendment 80 endorsement.
AI_SEVERABLE
VARCHAR2
Y = Aleutian Islands endorsement that can be transferred to another license.
AI_NON_SEVERABLE
VARCHAR2
Y = Aleutian Islands endorsement that cannot be transferred to another license.
MLOA_EXEMPT_BS_POLLOCK
VARCHAR2
Y = Named vessel is exempt from license MLOA for Bering Sea Pollock only.

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

Current groundfish license details all in one view.

Notes:

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

Entity Information

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

Current groundfish license details all in one view.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
STATE VARCHAR2 State in which the license owner resides.
100
LICENSE VARCHAR2 LLP number.
100
LINKED_LICENSE VARCHAR2 The crab 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
EXPIRATION_DATE DATE Date a license owned by a Community Quota Entity expires.
100
INTERIM_TEXT VARCHAR2 The license might be temporary until adjudication is completed.
100
TRANSFERABLE VARCHAR2 Yes = The license is transferable. Applies to owners as well as named vessels.
100
OQ_VESSEL_ONLY VARCHAR2 Y = Only the original qualifying vessel may be named on this license.
100
ORIGINAL_VESSEL_ID NUMBER NMFS ID of the original qualifying vessel.
100
ORIGINAL_VESSEL_ADFG VARCHAR2 Alaska Department of Fish and Game number of the original qualifying vessel.
100
ORIGINAL_VESSEL_NAME VARCHAR2 Name of the original qualifying vessel.
100
CURRENT_VESSEL_ID NUMBER Current NMFS ID of the named vessel.
100
CURRENT_VESSEL_ADFG VARCHAR2 Current Alaska Department of Fish and Game number of the named vessel.
100
CURRENT_VESSEL_NAME VARCHAR2 Current name of the named vessel.
100
AFA_VESSEL VARCHAR2 Y = 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
ALEUTIAN_ISLANDS_GROUNDFISH VARCHAR2 License is endorsed for this area.
100
BERING_SEA_GROUNDFISH VARCHAR2 License is endorsed for this area.
100
CENTRAL_GULF_GROUNDFISH VARCHAR2 License is endorsed for this area.
100
SOUTHEAST_OUTSIDE_GROUNDFISH VARCHAR2 License is endorsed for this area.
100
WESTERN_GULF_GROUNDFISH VARCHAR2 License is endorsed for this area.
100
PCOD VARCHAR2 List of Pacific cod endorsements for this license.
100
CR_SIDEBOARDS VARCHAR2 List of crab rationalization sideboards for this license.
100
RP_CV_SIDEBOARDED VARCHAR2 Y = Subject to rockfish catcher vessel sideboards.
100
RP_CP_SIDEBOARDED VARCHAR2 Y = Subject to rockfish catcher processor sideboards.
100
RP_CV_QUOTA VARCHAR2 Y = Holds rockfish catcher vessel quota.
100
RP_CP_QUOTA VARCHAR2 Y = Holds rockfish catcher processor quota.
100
AMENDMENT_80 VARCHAR2 Y = Has an Amendment 80 endorsement.
100
AI_SEVERABLE VARCHAR2 Y = Aleutian Islands endorsement that can be transferred to another license.
100
AI_NON_SEVERABLE VARCHAR2 Y = Aleutian Islands endorsement that cannot be transferred to another license.
100
MLOA_EXEMPT_BS_POLLOCK VARCHAR2 Y = Named vessel is exempt from license MLOA for Bering Sea Pollock only.

Attribute Details

STATE

CC ID: 213867
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: 213878
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: 213889
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 43
Required: No
Primary Key: No
Status: Active
Description:

The crab 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: 213896
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: 213897
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: 213898
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: 213899
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: 213900
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

EXPIRATION_DATE

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

Date a license owned by a Community Quota Entity expires.

General Data Type: DATE

INTERIM_TEXT

CC ID: 213868
Seq. Order: 10
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

TRANSFERABLE

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

Yes = The license is transferable. Applies to owners as well as named vessels.

General Data Type: VARCHAR2

OQ_VESSEL_ONLY

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

Y = Only the original qualifying vessel may be named on this license.

General Data Type: VARCHAR2

ORIGINAL_VESSEL_ID

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

NMFS ID of the original qualifying vessel.

General Data Type: NUMBER

ORIGINAL_VESSEL_ADFG

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

Alaska Department of Fish and Game number of the original qualifying vessel.

General Data Type: VARCHAR2

ORIGINAL_VESSEL_NAME

CC ID: 213873
Seq. Order: 15
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_ID

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

Current NMFS ID of the named vessel.

General Data Type: NUMBER

CURRENT_VESSEL_ADFG

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

Current Alaska Department of Fish and Game number of the named vessel.

General Data Type: VARCHAR2

CURRENT_VESSEL_NAME

CC ID: 213876
Seq. Order: 18
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

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

Y = 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: 213879
Seq. Order: 20
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

ALEUTIAN_ISLANDS_GROUNDFISH

CC ID: 213880
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 16
Required: No
Primary Key: No
Status: Active
Description:

License is endorsed for this area.

General Data Type: VARCHAR2

BERING_SEA_GROUNDFISH

CC ID: 213881
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 16
Required: No
Primary Key: No
Status: Active
Description:

License is endorsed for this area.

General Data Type: VARCHAR2

CENTRAL_GULF_GROUNDFISH

CC ID: 213882
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 16
Required: No
Primary Key: No
Status: Active
Description:

License is endorsed for this area.

General Data Type: VARCHAR2

SOUTHEAST_OUTSIDE_GROUNDFISH

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

License is endorsed for this area.

General Data Type: VARCHAR2

WESTERN_GULF_GROUNDFISH

CC ID: 213884
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 16
Required: No
Primary Key: No
Status: Active
Description:

License is endorsed for this area.

General Data Type: VARCHAR2

PCOD

CC ID: 213885
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

List of Pacific cod endorsements for this license.

General Data Type: VARCHAR2

CR_SIDEBOARDS

CC ID: 213886
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

List of crab rationalization sideboards for this license.

General Data Type: VARCHAR2

RP_CV_SIDEBOARDED

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

Y = Subject to rockfish catcher vessel sideboards.

General Data Type: VARCHAR2

RP_CP_SIDEBOARDED

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

Y = Subject to rockfish catcher processor sideboards.

General Data Type: VARCHAR2

RP_CV_QUOTA

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

Y = Holds rockfish catcher vessel quota.

General Data Type: VARCHAR2

RP_CP_QUOTA

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

Y = Holds rockfish catcher processor quota.

General Data Type: VARCHAR2

AMENDMENT_80

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

Y = Has an Amendment 80 endorsement.

General Data Type: VARCHAR2

AI_SEVERABLE

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

Y = Aleutian Islands endorsement that can be transferred to another license.

General Data Type: VARCHAR2

AI_NON_SEVERABLE

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

Y = Aleutian Islands endorsement that cannot be transferred to another license.

General Data Type: VARCHAR2

MLOA_EXEMPT_BS_POLLOCK

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

Y = Named vessel is exempt from license MLOA for Bering Sea Pollock only.

General Data Type: VARCHAR2

Catalog Details

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