Table: CRAT_RCR_CERTIFICATE
Entity (ENT) | Alaska Regional Office (AKRO)GUID: gov.noaa.nmfs.inport:27341 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
This table contains information about the annually-issued paper certificates stating authority of.Registered Crab Receivers to receive Crab Rationalization crab.
DescriptionThis table contains information about the annually-issued paper certificates stating authority of.Registered Crab Receivers to receive Crab Rationalization crab.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
RCR_NUMBER
NUMBER |
Permit number foreign key to CRAT_RCR_ANNUAL_PERMIT. |
YEAR
NUMBER |
Crab fishing year. |
SEQUENCE_NUMBER
NUMBER |
Sequence for the certificate, shows how many times in a year the certificate has been generated/printed. |
CURRENT_RECORD_FLAG
VARCHAR2 |
Y indicates this is the current active certificate. |
DATE_CREATED
DATE |
Date the certificate was created. |
DATE_EFFECTIVE
DATE |
Date the permit goes into effect. |
DATE_PRINTED
DATE |
This is the date the certificate was printed. (Seems currently to represent the date viewed.) |
DATE_EXPIRES
DATE |
Date the permit expires. |
PRINT_FLAG
VARCHAR2 |
Y indicates the certificate has been printed. |
RCR_NAME
VARCHAR2 |
Name of the permit holder. |
PLANT_VESSEL_NAME
VARCHAR2 |
For catcher/processor and stationary floating processor, this is the vessel name; for shoreside processor, the plant name. |
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. |
OPERATION_TYPE
VARCHAR2 |
CP = Catcher/Processor, SFP = Stationary Floating Processor, SHP = Shoreside Processor. Can be more than one. |
MAILING_ADDRESS1
VARCHAR2 |
This is address_line1 or PO BOX that is pointed to in the annual permit in the permit_address_seq column. |
MAILING_ADDRESS2
VARCHAR2 |
This is address_line2 that is pointed to in the annual permit in the permit_address_seq column. |
MAILING_ADDRESS3
VARCHAR2 |
This is state, city, zip code that is pointed to in the annual permit in the permit_address_seq column. |
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_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. |
Attribute Details
RCR_NUMBER
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |