View: V_LLP_GROUNDFISH_LICENSE
Entity (ENT) | Alaska Regional Office (AKRO)GUID: gov.noaa.nmfs.inport:26549 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Current groundfish license details all in one view.
DescriptionCurrent 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |