Slide Menu
Jump to Section...
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_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

Rubric Score Primary Key? Name Type Description
100
 Primary Key RCR_NUMBER NUMBER Permit number foreign key to CRAT_RCR_ANNUAL_PERMIT.
100
 Primary Key YEAR NUMBER Crab fishing year.
100
 Primary Key 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