Table: REGISTERED_BUYER_CERTIFICATE
Entity (ENT) | Alaska Regional Office (AKRO)GUID: gov.noaa.nmfs.inport:27345 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
This table contains a record of the registered buyer's printed annual permit. Certificates may be printed more than once in a permit cycle.
DescriptionThis 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
Name | Type | Description | ||
---|---|---|---|---|
100
|
REGISTERED_BUYER_NUMBER | NUMBER | Registered Buyer ID Number. | |
100
|
EXPIRATION_YEAR | NUMBER | This registered buyer permit is good through this fishing year. | |
100
|
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
|
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |