Table: FOREIGN_PRODUCT_CODE

Entity (ENT) | Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:9584 | Updated: August 9, 2022 | Published / External

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 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.

		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.

Name

Type

Description

100

NUMBER

A two-digit numeric code to identify the type of product associated with the recovery rate.

100

VARCHAR2

A description of the product code.

CC ID: 37379

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

CC ID: 37380

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 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