Table: ATL_LOV_PLANT
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:19018 | 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. |
PLANT_CODE
VARCHAR2 |
VessPlnt code from old NORPAC system. This code may ultimately be retired, but is essential to the transitional ETL from Atlas to Inseason and Domestic. |
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. |
LOCATION
VARCHAR2 |
no-comment |
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: ATL_LOV_PLANT |
---|---|
Short Name: | ATL_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 4574, 05-03-2013 17:18 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | NPRB_1017 |
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
|
PLANT_CODE | VARCHAR2 | VessPlnt code from old NORPAC system. This code may ultimately be retired, but is essential to the transitional ETL from Atlas to Inseason and Domestic. | |
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. | |
100
|
LOCATION | VARCHAR2 | no-comment |
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 |
PLANT_CODE
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
VessPlnt code from old NORPAC system. This code may ultimately be retired, but is essential to the transitional ETL from Atlas to Inseason and Domestic. |
General Data Type: | VARCHAR2 |
NAME
Seq. Order: | 3 |
---|---|
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: | 4 |
---|---|
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 |
LOCATION
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
no-comment |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 19018 |
---|---|
GUID: | gov.noaa.nmfs.inport:19018 |
Metadata Record Created By: | Doug Turnbull |
Metadata Record Created: | 2013-05-03 17:18+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 |