9711
Table: ATL_LOV_PLANT
ATL_LOV_PLANT
Entity
Published / External
7284
AFSC/FMA/North Pacific Groundfish and Halibut Observer Program, Post 2008 Fishery Statistics.
Data Set
Completed
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.
Loaded by batch 2390, 06-30-2009 16:11
Theme
AFSC
Theme
ATL
Theme
ATLAS
Theme
BYCATCH
Theme
FMA
Theme
GROUNDFISH
Theme
NORPAC
Theme
OBSERVER
Theme
PROCESSING PLANT
Spatial
AI
Spatial
ALEUTIAN ISLANDS
Spatial
BERING SEA
Spatial
BS
Spatial
BSAI
Spatial
GOA
Spatial
GULF OF ALASKA
Data Table
Yes
NORPAC
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.
1
PLANT_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated unique identifier for a processing plant.
NUMBER
2
PLANT_CODE
VARCHAR2
4
No
No
Active
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.
VARCHAR2
3
NAME
VARCHAR2
50
Yes
No
Active
Name of a processing plant - inherited from the NORPAC data set
VARCHAR2
4
PERMIT
VARCHAR2
6
Yes
No
Active
Unique Permit identifying a processing plant - inherited from the NORPAC data set. It is assigned by RAM division at the regional office in Juneau.
VARCHAR2
5
LOCATION
VARCHAR2
50
No
No
Active
This attribute represents the city or other identifying location for a plant. The value is not currently validate.
VARCHAR2
gov.noaa.nmfs.inport:9711
Doug Turnbull
2009-06-30T16:11:35
SysAdmin InPortAdmin
2022-08-09T17:11:03
2018-09-26
Alaska Fisheries Science Center
AFSC
7600 Sand Point Way N.E., Building 4
Seattle
WA
98115
USA
http://www.afsc.noaa.gov
0700-1700 Pacific Time
1001
Public
No
2018-09-26
1 Year
2019-09-26