Metadata Rubric

100%

6 / 6

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

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

	Name	Type	Description
100	PERMIT_ID	NUMBER	ID from the VESSEL table, which is also the federal crab vessel permit ID.
100	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.

Name

Type

Description

100

PERMIT_ID

NUMBER

ID from the VESSEL table, which is also the federal crab vessel permit ID.

100

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