Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Regional Office Library > AKRO Restricted Access Management (RAM) Program... > IFQ Halibut/Sablefish and CDQ Halibut Permit Pr... >

Table: REGISTERED_BUYER_CERTIFICATE

Entity (ENT)  |  Alaska Regional Office (AKRO)
GUID: gov.noaa.nmfs.inport:27345  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

This table contains a record of the registered buyer's printed annual permit. Certificates may be printed more than once in a permit cycle.

Description

This table contains a record of the registered buyer's printed annual permit. Certificates may be printed more than once in a permit cycle.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
REGISTERED_BUYER_NUMBER
NUMBER 		Registered Buyer ID Number.
EXPIRATION_YEAR
NUMBER 		This registered buyer permit is good through this fishing year.
SEQUENCE_NUMBER
NUMBER 		The sequence number representing creation of a single certificate.
RB_NAME
VARCHAR2 		The formatted name of the registered buyer on the certificate.
RB_ADDRESS_LINE_1
VARCHAR2 		RB Certificate mailing address line 1.
RB_ADDRESS_LINE_2
VARCHAR2 		RB Certificate mailing address line 2.
RB_POST_OFFICE_BOX
VARCHAR2 		RB Certificate mailing address line 3.
RB_CITY_NAME
VARCHAR2 		RB mailing address city.
RB_STATE_CODE
VARCHAR2 		RB mailing address state.
RB_ZIP_CODE
VARCHAR2 		RB mailing address zip code.
RB_COUNTRY_CODE
VARCHAR2 		RB mailing address country code.
PICK_UP_FLAG
VARCHAR2 		Y indicates hold for pick up in office.
CREATION_DATETIME
DATE 		Date/time the certificate was created.
RB_PRINT_RB_NUMBER
VARCHAR2 		Printed format of registered buyer number for certificate.
PRINT_DATETIME
DATE 		Date/time the certificate was printed.
USERID
VARCHAR2 		Creator's Oracle user ID.
PRINT_FLAG
VARCHAR2 		Y indicates that the certificate has been printed.
DUPLICATE_FLAG
VARCHAR2 		Y indicates that this is a duplicate certificate.
RB_PROCESSING_PLANT_NAME
VARCHAR2 		Processing plant facility or vessel. Optional.
END_DATE
DATE 		End of the permit cycle for this permit.
RECEIPT_FLAG
VARCHAR2 		Y indicates that this certificate was included in RAM's receipt report. Used for RAM's record of online submissions.

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: REGISTERED_BUYER_CERTIFICATE
Short Name: REGISTERED_BUYER_CERTIFICATE
Status: Completed
Abstract:

This table contains a record of the registered buyer's printed annual permit. Certificates may be printed more than once in a permit cycle.
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 a record of the registered buyer's printed annual permit. Certificates may be printed more than once in a permit cycle.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key REGISTERED_BUYER_NUMBER NUMBER Registered Buyer ID Number.
100
 Primary Key EXPIRATION_YEAR NUMBER This registered buyer permit is good through this fishing year.
100
 Primary Key SEQUENCE_NUMBER NUMBER The sequence number representing creation of a single certificate.
100
 RB_NAME VARCHAR2 The formatted name of the registered buyer on the certificate.
100
 RB_ADDRESS_LINE_1 VARCHAR2 RB Certificate mailing address line 1.
100
 RB_ADDRESS_LINE_2 VARCHAR2 RB Certificate mailing address line 2.
100
 RB_POST_OFFICE_BOX VARCHAR2 RB Certificate mailing address line 3.
100
 RB_CITY_NAME VARCHAR2 RB mailing address city.
100
 RB_STATE_CODE VARCHAR2 RB mailing address state.
100
 RB_ZIP_CODE VARCHAR2 RB mailing address zip code.
100
 RB_COUNTRY_CODE VARCHAR2 RB mailing address country code.
100
 PICK_UP_FLAG VARCHAR2 Y indicates hold for pick up in office.
100
 Primary Key CREATION_DATETIME DATE Date/time the certificate was created.
100
 RB_PRINT_RB_NUMBER VARCHAR2 Printed format of registered buyer number for certificate.
100
 PRINT_DATETIME DATE Date/time the certificate was printed.
100
 USERID VARCHAR2 Creator's Oracle user ID.
100
 PRINT_FLAG VARCHAR2 Y indicates that the certificate has been printed.
100
 DUPLICATE_FLAG VARCHAR2 Y indicates that this is a duplicate certificate.
100
 RB_PROCESSING_PLANT_NAME VARCHAR2 Processing plant facility or vessel. Optional.
100
 END_DATE DATE End of the permit cycle for this permit.
100
 RECEIPT_FLAG VARCHAR2 Y indicates that this certificate was included in RAM's receipt report. Used for RAM's record of online submissions.

Attribute Details

REGISTERED_BUYER_NUMBER

CC ID: 223198
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 8
Scale: 0
Status: Active
Description:

Registered Buyer ID Number.
General Data Type: NUMBER

EXPIRATION_YEAR

CC ID: 223209
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 4
Scale: 0
Status: Active
Description:

This registered buyer permit is good through this fishing year.
General Data Type: NUMBER

SEQUENCE_NUMBER

CC ID: 223212
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 3
Scale: 0
Status: Active
Description:

The sequence number representing creation of a single certificate.
General Data Type: NUMBER

RB_NAME

CC ID: 223213
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 60
Required: Yes
Primary Key: No
Status: Active
Description:

The formatted name of the registered buyer on the certificate.
General Data Type: VARCHAR2

RB_ADDRESS_LINE_1

CC ID: 223214
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

RB Certificate mailing address line 1.
General Data Type: VARCHAR2

RB_ADDRESS_LINE_2

CC ID: 223215
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

RB Certificate mailing address line 2.
General Data Type: VARCHAR2

RB_POST_OFFICE_BOX

CC ID: 223216
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

RB Certificate mailing address line 3.
General Data Type: VARCHAR2

RB_CITY_NAME

CC ID: 223217
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

RB mailing address city.
General Data Type: VARCHAR2

RB_STATE_CODE

CC ID: 223218
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

RB mailing address state.
General Data Type: VARCHAR2

RB_ZIP_CODE

CC ID: 223199
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

RB mailing address zip code.
General Data Type: VARCHAR2

RB_COUNTRY_CODE

CC ID: 223200
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

RB mailing address country code.
General Data Type: VARCHAR2

PICK_UP_FLAG

CC ID: 223201
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Y indicates hold for pick up in office.
General Data Type: VARCHAR2

CREATION_DATETIME

CC ID: 223202
Seq. Order: 13
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: Yes
Status: Active
Description:

Date/time the certificate was created.
General Data Type: DATE

RB_PRINT_RB_NUMBER

CC ID: 223203
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 12
Required: Yes
Primary Key: No
Status: Active
Description:

Printed format of registered buyer number for certificate.
General Data Type: VARCHAR2

PRINT_DATETIME

CC ID: 223204
Seq. Order: 15
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date/time the certificate was printed.
General Data Type: DATE

USERID

CC ID: 223205
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

Creator's Oracle user ID.
General Data Type: VARCHAR2

PRINT_FLAG

CC ID: 223206
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Y indicates that the certificate has been printed.
General Data Type: VARCHAR2

DUPLICATE_FLAG

CC ID: 223207
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Y indicates that this is a duplicate certificate.
General Data Type: VARCHAR2

RB_PROCESSING_PLANT_NAME

CC ID: 223208
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

Processing plant facility or vessel. Optional.
General Data Type: VARCHAR2

END_DATE

CC ID: 223210
Seq. Order: 20
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

End of the permit cycle for this permit.
General Data Type: DATE

RECEIPT_FLAG

CC ID: 223211
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Y indicates that this certificate was included in RAM's receipt report. Used for RAM's record of online submissions.
General Data Type: VARCHAR2

Catalog Details

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