Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: LOV_PLANT
Short Name: LOV_PLANT
Status: Completed
Abstract:

The lov_plant table is populated from the vessplant table in Norpac. In Norpac a plant is identified by a leading P in the vessel code field.

Notes:

Loaded by batch 2204, 03-28-2008 14:09

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: TURNBULLD
Description:

The lov_plant table is populated from the vessplant table in Norpac. In Norpac a plant is identified by a leading P in the vessel code field.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key PLANT_SEQ NUMBER Sequence generated unique identifier for a processing plant.
100
NAME VARCHAR2 Name of a processing plant - inherited from the NORPAC data set
100
PERMIT VARCHAR2 Unique Permit identifying a processing plant - inherited from the NORPAC data set. It is assigned by RAM division at the regional office in Juneau.

Attribute Details

PLANT_SEQ

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

Sequence generated unique identifier for a processing plant.

General Data Type: NUMBER

NAME

CC ID: 29678
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

Name of a processing plant - inherited from the NORPAC data set

General Data Type: VARCHAR2

PERMIT

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

Unique Permit identifying a processing plant - inherited from the NORPAC data set. It is assigned by RAM division at the regional office in Juneau.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7525
GUID: gov.noaa.nmfs.inport:7525
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2008-03-28 14:09+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-04
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-04
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-04