Table: FOREIGN_PRODUCT_CODE
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:9584 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
This table links the product code in the NORPAC.FOREIGN_PRODUCT table with a description of the code.
DescriptionThis table links the product code in the NORPAC.FOREIGN_PRODUCT table with a description of the code.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
PRODUCT_CODE
NUMBER |
A two-digit numeric code to identify the type of product associated with the recovery rate. |
PRODUCT_CODE_DEFINITION
VARCHAR2 |
A description of the product code. |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (AFSC) for inquiries on this record.
Item Identification
Title: | Table: FOREIGN_PRODUCT_CODE |
---|---|
Short Name: | FOREIGN_PRODUCT_CODE |
Status: | Completed |
Abstract: |
This table links the product code in the NORPAC.FOREIGN_PRODUCT table with a description of the code. |
Notes: |
Loaded by batch 2364, 06-29-2009 18:15 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | NORPAC |
Description: |
This table links the product code in the NORPAC.FOREIGN_PRODUCT table with a description of the code. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
PRODUCT_CODE | NUMBER | A two-digit numeric code to identify the type of product associated with the recovery rate. | |
100
|
PRODUCT_CODE_DEFINITION | VARCHAR2 | A description of the product code. |
Attribute Details
PRODUCT_CODE
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
A two-digit numeric code to identify the type of product associated with the recovery rate. |
General Data Type: | NUMBER |
PRODUCT_CODE_DEFINITION
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
A description of the product code. |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 9584 |
---|---|
GUID: | gov.noaa.nmfs.inport:9584 |
Metadata Record Created By: | Doug Turnbull |
Metadata Record Created: | 2009-06-29 18:15+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-05-18 |
Owner Org: | AFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-05-18 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-05-18 |