Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Regional Office Library > AKRO Restricted Access Management (RAM) Program... > Scallop License Limitation Program (SLLP) Permi... >

Table: SCALLOP_PERMIT

Entity (ENT)  |  Alaska Regional Office (AKRO)
GUID: gov.noaa.nmfs.inport:26542  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Holds all of the Scallop License Limitation Permit data.

Description

Holds all of the Scallop License Limitation Permit data.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
PERMIT_NUMBER
NUMBER 		NMFS ID assigned to the permit.
PERSON_ID
NUMBER 		NMFS person ID of first license holder.
MLOA
NUMBER 		Maximum length overall in feet of the permit.
TRANSFERABLE_FLAG
VARCHAR2 		If the permit is transferable to another person.
GEAR_RESTRICTION
VARCHAR2 		A description of any restrictions or None.
OTHER_OWNERS
VARCHAR2 		NMFS person IDs of additional license holders.

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

Holds all of the Scallop License Limitation Permit data.
Notes:

Loaded by batch 6892, 08-21-2015 13:41

Entity Information

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

Holds all of the Scallop License Limitation Permit data.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key PERMIT_NUMBER NUMBER NMFS ID assigned to the permit.
100
 PERSON_ID NUMBER NMFS person ID of first license holder.
100
 MLOA NUMBER Maximum length overall in feet of the permit.
100
 TRANSFERABLE_FLAG VARCHAR2 If the permit is transferable to another person.
100
 GEAR_RESTRICTION VARCHAR2 A description of any restrictions or None.
100
 OTHER_OWNERS VARCHAR2 NMFS person IDs of additional license holders.

Attribute Details

PERMIT_NUMBER

CC ID: 213760
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 5
Scale: 0
Status: Active
Description:

NMFS ID assigned to the permit.
General Data Type: NUMBER

PERSON_ID

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

NMFS person ID of first license holder.
General Data Type: NUMBER
Foreign Key Relations:

AKFISH.PERSON

MLOA

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

Maximum length overall in feet of the permit.
General Data Type: NUMBER

TRANSFERABLE_FLAG

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

If the permit is transferable to another person.
General Data Type: VARCHAR2

GEAR_RESTRICTION

CC ID: 213763
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

A description of any restrictions or None.
General Data Type: VARCHAR2

OTHER_OWNERS

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

NMFS person IDs of additional license holders.
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 26542
GUID: gov.noaa.nmfs.inport:26542
Metadata Record Created By: Pamela A Mason
Metadata Record Created: 2015-08-21 13:41+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