Table: LOV_PLANT
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:7525 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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.
DescriptionThe 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.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
PLANT_SEQ
NUMBER |
Sequence generated unique identifier for a processing plant. |
NAME
VARCHAR2 |
Name of a processing plant - inherited from the NORPAC data set |
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. |
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: 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
Name | Type | Description | ||
---|---|---|---|---|
100
|
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
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
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
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 |