Downtime Notice: Thursday, May 29 @ 2:00pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 6.0.2. Downtime Schedule May 29, 2025 2:00pm - 3:00pm Eastern / 11:00am - 12:00pm Pacific / 8:00am - 9:00am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: https://www.fisheri...
View All
Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Regional Office Library > AKRO Restricted Access Management (RAM) Program... > Crab Rationalization Permit Program >

Table: CRAT_VESSEL_PERMIT

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

Summary

Abstract

This table contains information about the yearly permits for all vessels fishing under the Crab Rationalization regulations.

Description

This table contains information about the yearly permits for all vessels fishing under the Crab Rationalization regulations.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
PERMIT_ID
NUMBER 		ID from the VESSEL table, which is also the federal crab vessel permit ID.
YEAR
NUMBER 		CRAT fishing year.
STATUS
VARCHAR2 		(A)ctive, (I)nactive, (R)evoked, e(X)pired, (S)anctioned.
DATE_ENTERED
DATE 		The date the row was created, whether it is a new permit or an amended permit.
DATE_EFFECTIVE
DATE 		The date the vessel may begin fishing (either beginning of crab fishing year, or date permit created, whichever comes last).
DATE_EXPIRES
DATE 		End of the crab fishing year.
CONTACT_OWNER_ID
NUMBER 		ID from the PERSON table of the vessel owner that is the contact person for this permit.
CONTACT_ADDRESS_SEQ
NUMBER 		The sequence number from the PERSON_ADDRESS table for the contact owner.
CONTACT_INFO_SEQ
NUMBER 		Part of foreign key to the PERSON_CONTACT table, so that we can look up email and phone number information.
EDR_REPRESENTATIVE_ID
NUMBER 		ID from PERSON table for the EDR representative.
PRINT_FLAG
VARCHAR2 		Y indicates that this row has been printed. This becomes important when fishers start creating their permits from the Internet.
USERID
VARCHAR2 		Identifies who created this row.
RECEIPT_FLAG
VARCHAR2 		Y indicates that this certificate was included in the RAM receipt report. Used for RAM record of online submissions.

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

This table contains information about the yearly permits for all vessels fishing under the Crab Rationalization regulations.
Notes:

Loaded by batch 7095, 09-22-2015 13:02

Entity Information

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

This table contains information about the yearly permits for all vessels fishing under the Crab Rationalization regulations.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key PERMIT_ID NUMBER ID from the VESSEL table, which is also the federal crab vessel permit ID.
100
 Primary Key YEAR NUMBER CRAT fishing year.
100
 STATUS VARCHAR2 (A)ctive, (I)nactive, (R)evoked, e(X)pired, (S)anctioned.
100
 DATE_ENTERED DATE The date the row was created, whether it is a new permit or an amended permit.
100
 DATE_EFFECTIVE DATE The date the vessel may begin fishing (either beginning of crab fishing year, or date permit created, whichever comes last).
100
 DATE_EXPIRES DATE End of the crab fishing year.
100
 CONTACT_OWNER_ID NUMBER ID from the PERSON table of the vessel owner that is the contact person for this permit.
100
 CONTACT_ADDRESS_SEQ NUMBER The sequence number from the PERSON_ADDRESS table for the contact owner.
100
 CONTACT_INFO_SEQ NUMBER Part of foreign key to the PERSON_CONTACT table, so that we can look up email and phone number information.
100
 EDR_REPRESENTATIVE_ID NUMBER ID from PERSON table for the EDR representative.
100
 PRINT_FLAG VARCHAR2 Y indicates that this row has been printed. This becomes important when fishers start creating their permits from the Internet.
100
 USERID VARCHAR2 Identifies who created this row.
100
 RECEIPT_FLAG VARCHAR2 Y indicates that this certificate was included in the RAM receipt report. Used for RAM record of online submissions.

Attribute Details

PERMIT_ID

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

ID from the VESSEL table, which is also the federal crab vessel permit ID.
General Data Type: NUMBER
Foreign Key Relations:

AKFISH.VESSEL

YEAR

CC ID: 223175
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 4
Scale: 0
Status: Active
Description:

CRAT fishing year.
General Data Type: NUMBER

STATUS

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

(A)ctive, (I)nactive, (R)evoked, e(X)pired, (S)anctioned.
General Data Type: VARCHAR2

DATE_ENTERED

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

The date the row was created, whether it is a new permit or an amended permit.
General Data Type: DATE

DATE_EFFECTIVE

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

The date the vessel may begin fishing (either beginning of crab fishing year, or date permit created, whichever comes last).
General Data Type: DATE

DATE_EXPIRES

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

End of the crab fishing year.
General Data Type: DATE

CONTACT_OWNER_ID

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

ID from the PERSON table of the vessel owner that is the contact person for this permit.
General Data Type: NUMBER
Foreign Key Relations:

AKFISH.PERSON

CONTACT_ADDRESS_SEQ

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

The sequence number from the PERSON_ADDRESS table for the contact owner.
General Data Type: NUMBER
Foreign Key Relations:

AKFISH.PERSON_ADDRESS

CONTACT_INFO_SEQ

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

Part of foreign key to the PERSON_CONTACT table, so that we can look up email and phone number information.
General Data Type: NUMBER
Foreign Key Relations:

AKFISH.PERSON_CONTACT

EDR_REPRESENTATIVE_ID

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

ID from PERSON table for the EDR representative.
General Data Type: NUMBER
Foreign Key Relations:

AKFISH.PERSON

PRINT_FLAG

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

Y indicates that this row has been printed. This becomes important when fishers start creating their permits from the Internet.
General Data Type: VARCHAR2

USERID

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

Identifies who created this row.
General Data Type: VARCHAR2

RECEIPT_FLAG

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

Y indicates that this certificate was included in the RAM receipt report. Used for RAM record of online submissions.
General Data Type: VARCHAR2

Catalog Details

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