Metadata Rubric

100%

6 / 6

Alaska Regional Office Library > AKRO Restricted Access Management (RAM) Program... > Crab Rationalization Permit Program >

Table: CRAT_RCR_CERTIFICATE

Entity (ENT) | Alaska Regional Office (AKRO)
GUID: gov.noaa.nmfs.inport:27341 | Updated: August 9, 2022 | Published / External

Item Identification

Title:	Table: CRAT_RCR_CERTIFICATE
Short Name:	CRAT_RCR_CERTIFICATE
Status:	Completed
Abstract:	This table contains information about the annually-issued paper certificates stating authority of.Registered Crab Receivers to receive Crab Rationalization crab.
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 annually-issued paper certificates stating authority of.Registered Crab Receivers to receive Crab Rationalization crab.

Data Attributes

Attribute Summary

	Name	Type	Description
100	RCR_NUMBER	NUMBER	Permit number foreign key to CRAT_RCR_ANNUAL_PERMIT.
100	YEAR	NUMBER	Crab fishing year.
100	SEQUENCE_NUMBER	NUMBER	Sequence for the certificate, shows how many times in a year the certificate has been generated/printed.
100	CURRENT_RECORD_FLAG	VARCHAR2	Y indicates this is the current active certificate.
100	DATE_CREATED	DATE	Date the certificate was created.
100	DATE_EFFECTIVE	DATE	Date the permit goes into effect.
100	DATE_PRINTED	DATE	This is the date the certificate was printed. (Seems currently to represent the date viewed.)
100	DATE_EXPIRES	DATE	Date the permit expires.
100	PRINT_FLAG	VARCHAR2	Y indicates the certificate has been printed.
100	RCR_NAME	VARCHAR2	Name of the permit holder.
100	PLANT_VESSEL_NAME	VARCHAR2	For catcher/processor and stationary floating processor, this is the vessel name; for shoreside processor, the plant name.
100	PLANT_SFP_DETAIL	VARCHAR2	For shoreside processor, this is the city and state in which the plant is located; for stationary floating processor, the US Coast Guard number.
100	OPERATION_TYPE	VARCHAR2	CP = Catcher/Processor, SFP = Stationary Floating Processor, SHP = Shoreside Processor. Can be more than one.
100	MAILING_ADDRESS1	VARCHAR2	This is address_line1 or PO BOX that is pointed to in the annual permit in the permit_address_seq column.
100	MAILING_ADDRESS2	VARCHAR2	This is address_line2 that is pointed to in the annual permit in the permit_address_seq column.
100	MAILING_ADDRESS3	VARCHAR2	This is state, city, zip code that is pointed to in the annual permit in the permit_address_seq column.

Name

Type

Description

100

RCR_NUMBER

NUMBER

Permit number foreign key to CRAT_RCR_ANNUAL_PERMIT.

100

YEAR

NUMBER

Crab fishing year.

100

SEQUENCE_NUMBER

NUMBER

Sequence for the certificate, shows how many times in a year the certificate has been generated/printed.

100

CURRENT_RECORD_FLAG

VARCHAR2

Y indicates this is the current active certificate.

100

DATE_CREATED

DATE

Date the certificate was created.

100

DATE_EFFECTIVE

DATE

Date the permit goes into effect.

100

DATE_PRINTED

DATE

This is the date the certificate was printed. (Seems currently to represent the date viewed.)

100

DATE_EXPIRES

DATE

Date the permit expires.

100

PRINT_FLAG

VARCHAR2

Y indicates the certificate has been printed.

100

RCR_NAME

VARCHAR2

Name of the permit holder.

100

PLANT_VESSEL_NAME

VARCHAR2

For catcher/processor and stationary floating processor, this is the vessel name; for shoreside processor, the plant name.

100

PLANT_SFP_DETAIL

VARCHAR2

For shoreside processor, this is the city and state in which the plant is located; for stationary floating processor, the US Coast Guard number.

100

OPERATION_TYPE

VARCHAR2

CP = Catcher/Processor, SFP = Stationary Floating Processor, SHP = Shoreside Processor. Can be more than one.

100

MAILING_ADDRESS1

VARCHAR2

This is address_line1 or PO BOX that is pointed to in the annual permit in the permit_address_seq column.

100

MAILING_ADDRESS2

VARCHAR2

This is address_line2 that is pointed to in the annual permit in the permit_address_seq column.

100

MAILING_ADDRESS3

VARCHAR2

This is state, city, zip code that is pointed to in the annual permit in the permit_address_seq column.

Attribute Details

RCR_NUMBER

CC ID: 223151

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Precision:	6
Scale:	0
Status:	Active
Description:	Permit number foreign key to CRAT_RCR_ANNUAL_PERMIT.
General Data Type:	NUMBER
Foreign Key Relations:	AKFISH.CRAT_RCR_ANNUAL_PERMIT

YEAR

CC ID: 223152

Seq. Order:	2
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Precision:	4
Scale:	0
Status:	Active
Description:	Crab fishing year.
General Data Type:	NUMBER
Foreign Key Relations:	AKFISH.CRAT_RCR_ANNUAL_PERMIT

SEQUENCE_NUMBER

CC ID: 223160

Seq. Order:	3
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Precision:	6
Scale:	0
Status:	Active
Description:	Sequence for the certificate, shows how many times in a year the certificate has been generated/printed.
General Data Type:	NUMBER

CURRENT_RECORD_FLAG

CC ID: 223161

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Y indicates this is the current active certificate.
General Data Type:	VARCHAR2

DATE_CREATED

CC ID: 223162

Seq. Order:	5
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date the certificate was created.
General Data Type:	DATE

DATE_EFFECTIVE

CC ID: 223163

Seq. Order:	6
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date the permit goes into effect.
General Data Type:	DATE

DATE_PRINTED

CC ID: 223164

Seq. Order:	7
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	This is the date the certificate was printed. (Seems currently to represent the date viewed.)
General Data Type:	DATE

DATE_EXPIRES

CC ID: 223165

Seq. Order:	8
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date the permit expires.
General Data Type:	DATE

PRINT_FLAG

CC ID: 223166

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Y indicates the certificate has been printed.
General Data Type:	VARCHAR2

RCR_NAME

CC ID: 223153

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	60
Required:	No
Primary Key:	No
Status:	Active
Description:	Name of the permit holder.
General Data Type:	VARCHAR2

PLANT_VESSEL_NAME

CC ID: 223154

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	60
Required:	No
Primary Key:	No
Status:	Active
Description:	For catcher/processor and stationary floating processor, this is the vessel name; for shoreside processor, the plant name.
General Data Type:	VARCHAR2

PLANT_SFP_DETAIL

CC ID: 223155

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	40
Required:	No
Primary Key:	No
Status:	Active
Description:	For shoreside processor, this is the city and state in which the plant is located; for stationary floating processor, the US Coast Guard number.
General Data Type:	VARCHAR2

OPERATION_TYPE

CC ID: 223156

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	Yes
Primary Key:	No
Status:	Active
Description:	CP = Catcher/Processor, SFP = Stationary Floating Processor, SHP = Shoreside Processor. Can be more than one.
General Data Type:	VARCHAR2

MAILING_ADDRESS1

CC ID: 223157

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	60
Required:	No
Primary Key:	No
Status:	Active
Description:	This is address_line1 or PO BOX that is pointed to in the annual permit in the permit_address_seq column.
General Data Type:	VARCHAR2

MAILING_ADDRESS2

CC ID: 223158

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	60
Required:	No
Primary Key:	No
Status:	Active
Description:	This is address_line2 that is pointed to in the annual permit in the permit_address_seq column.
General Data Type:	VARCHAR2

MAILING_ADDRESS3

CC ID: 223159

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	60
Required:	No
Primary Key:	No
Status:	Active
Description:	This is state, city, zip code that is pointed to in the annual permit in the permit_address_seq column.
General Data Type:	VARCHAR2

Catalog Details

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