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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

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 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.

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.

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (AKRO) for inquiries on this record.

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 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.

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 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

Table: CRAT_VESSEL_PERMIT

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

PERMIT_ID

YEAR

STATUS

DATE_ENTERED

DATE_EFFECTIVE

DATE_EXPIRES

CONTACT_OWNER_ID

CONTACT_ADDRESS_SEQ

CONTACT_INFO_SEQ

EDR_REPRESENTATIVE_ID

PRINT_FLAG

USERID

RECEIPT_FLAG

Catalog Details