19018 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 https://www.afsc.noaa.gov 0700-1700 Pacific Time 1001 Public No 2016-05-18 1 Year 2017-05-18