View: V_LLP_CRAB_LICENSE
Alaska Regional Office
Entity
(ENT)
| ID: 27350
| Published / External
Created: 2015-09-22
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 11798
ID: 27350
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | View: V_LLP_CRAB_LICENSE |
---|---|
Short Name | V_LLP_CRAB_LICENSE |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
This view retrieves details about the License Limitation Program (LLP) crab licenses. |
* Purpose | |
Notes |
Loaded by batch 7095, 09-22-2015 13:02 |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | Data View |
---|---|
Active Version? | Y |
Alias | |
Schema Name | AKFISH |
» Description |
This view retrieves details about the License Limitation Program (LLP) crab licenses. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | STATE | VARCHAR2 | State in which the license owner resides. |
100 | No | No | LICENSE | VARCHAR2 | LLP number. |
100 | No | No | LINKED_LICENSE | VARCHAR2 | The groundfish license to which this license is linked. Transfers must include both licenses unless there is a court order. |
100 | Yes | No | PERSON_ID | NUMBER | NMFS ID of the contact person who owns the license. |
100 | No | No | LICENSEE_NAME | VARCHAR2 | Name of the contact person who owns the license. |
100 | No | No | OPERATION_TYPE | VARCHAR2 | CV = catcher vessel, C/P = catcher/processor. |
100 | Yes | No | MLOA | NUMBER | Maximum length overall for the named vessel. |
100 | No | No | ISSUE_DATE | DATE | The date that the last certificate was created. |
100 | No | No | INTERIM_TEXT | VARCHAR2 | The license might be temporary until adjudication is completed. |
100 | No | No | LICENSE_TRANSFERABLE | VARCHAR2 | Yes indicates that the license is transferable. Applies to people as well as the named vessel. |
100 | No | No | ORIGINAL_VESSEL_ADFG | VARCHAR2 | ADFG license number of the original qualifying vessel. |
100 | No | No | ORIGINAL_VESSEL_NAME | VARCHAR2 | Name of the original qualifying vessel. |
100 | No | No | CURRENT_VESSEL_ADFG | VARCHAR2 | ADFG license number of the named vessel. |
100 | No | No | CURRENT_VESSEL_NAME | VARCHAR2 | Current name of the named vessel. |
100 | Yes | No | 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 | No | No | INTERESTED_PARTY | VARCHAR2 | People who have asserted an interest in the license and would like to be notified before a transfer occurs. |
100 | No | No | MINOR_SPECIES | VARCHAR2 | Y indicates that this license has the Minor Species endorsement; N, if it does not. |
100 | No | No | 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 | No | No | AI_OPILIO_BAIRDI | VARCHAR2 | Y indicates that this license has the Aleutian Islands Opilio and Bairdi endorsement; N, if it does not. |
100 | No | No | 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 | No | No | NS_ONLY | VARCHAR2 | Y indicates that this license has ONLY the Norton Sound Red and Blue King Crab endorsement and no others. |
Attribute Details
Attribute Name | STATE |
---|---|
Seq. Order | 1 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
State in which the license owner resides. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LICENSE |
---|---|
Seq. Order | 2 |
Data Storage Type | VARCHAR2 |
Max Length | 43 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
LLP number. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LINKED_LICENSE |
---|---|
Seq. Order | 3 |
Data Storage Type | VARCHAR2 |
Max Length | 43 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PERSON_ID |
---|---|
Seq. Order | 4 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LICENSEE_NAME |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | 81 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of the contact person who owns the license. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OPERATION_TYPE |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
CV = catcher vessel, C/P = catcher/processor. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MLOA |
---|---|
Seq. Order | 7 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 4 |
Scale | 1 |
Status | Active |
Description |
Maximum length overall for the named vessel. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ISSUE_DATE |
---|---|
Seq. Order | 8 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The date that the last certificate was created. |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | INTERIM_TEXT |
---|---|
Seq. Order | 9 |
Data Storage Type | VARCHAR2 |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The license might be temporary until adjudication is completed. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LICENSE_TRANSFERABLE |
---|---|
Seq. Order | 10 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Yes indicates that the license is transferable. Applies to people as well as the named vessel. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ORIGINAL_VESSEL_ADFG |
---|---|
Seq. Order | 11 |
Data Storage Type | VARCHAR2 |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
ADFG license number of the original qualifying vessel. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ORIGINAL_VESSEL_NAME |
---|---|
Seq. Order | 12 |
Data Storage Type | VARCHAR2 |
Max Length | 60 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of the original qualifying vessel. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CURRENT_VESSEL_ADFG |
---|---|
Seq. Order | 13 |
Data Storage Type | VARCHAR2 |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
ADFG license number of the named vessel. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CURRENT_VESSEL_NAME |
---|---|
Seq. Order | 14 |
Data Storage Type | VARCHAR2 |
Max Length | 60 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Current name of the named vessel. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | AFA_VESSEL_FLAG |
---|---|
Seq. Order | 15 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | INTERESTED_PARTY |
---|---|
Seq. Order | 16 |
Data Storage Type | VARCHAR2 |
Max Length | 4000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MINOR_SPECIES |
---|---|
Seq. Order | 17 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Y indicates that this license has the Minor Species endorsement; N, if it does not. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | EASTERN_ALEUTIAN_I_RED_KING |
---|---|
Seq. Order | 18 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | AI_OPILIO_BAIRDI |
---|---|
Seq. Order | 19 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NORTON_S_RED_BLUE_KING |
---|---|
Seq. Order | 20 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NS_ONLY |
---|---|
Seq. Order | 21 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 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 Workflow State | Published / External |
Metadata Last Review Date | 2015-12-14 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2016-12-14 |
Tags |
---|