19018
Table: ATL_LOV_PLANT
ATL_LOV_PLANT
Entity
Published / External
18964
AFSC/FMA/NPRB Alternative Catch Monitoring Table and Column Definitions
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 4574, 05-03-2013 17:18
Data Table
Yes
NPRB_1017
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
no-comment
VARCHAR2
gov.noaa.nmfs.inport:19018
Doug Turnbull
2013-05-03T17:18:47
SysAdmin InPortAdmin
2022-08-09T17:11:09
2016-05-18
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
2016-05-18
1 Year
2017-05-18