9734 ATL_MESSAGE_PERMIT Entity Published / External 7284 AFSC/FMA/North Pacific Groundfish and Halibut Observer Program, Post 2008 Fishery Statistics. Data Set Completed Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC Tracks who is the current inseason advisor. OLS_STAFF_ID VARCHAR2 No No Active FK to ols_lov_staff for the staff advisor for this permit. PC_DUMMY_BOAT_FLAG VARCHAR2 No No Active A value of 'Y' denotes this permit is used strictly for Atlas advising purposes. An observer is not actually deployed to the vessel. SUB_ADVISOR_START_DATE DATE No No Active The start date for the substitute advisor. If this column is null then the advisor is the primary advisor. SUB_ADVISOR_END_DATE DATE No No Active The End date for the substitute inseason advisor. If this column is null then the advisor is the primary advisor. MESSAGE_PERMIT_SEQ NUMBER No No Active Primary key unique for each row. 1 PERMIT NUMBER 22 Yes Yes 38 Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau NUMBER 4 PRIMARY_ADVISOR_FLAG VARCHAR2 1 Yes No Active Column contains 'Y' or 'N' to indicate if the staff member is the primary advisor for the vessel. Primary advisors are responsible for the vessel a majority of the time, but may on occassion need to have another staff cover the inseason communications duties (during vacation or field assignments for e.g.). If the staff in question has the primary advisor flag set to 'Y' and current advisor flag set to 'N', another staff is currently monitoring messages for the vessel. VARCHAR2 gov.noaa.nmfs.inport:9734 Doug Turnbull 2009-06-30T16:11:41 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 https://www.afsc.noaa.gov 0700-1700 Pacific Time 1001 Public No 2018-09-26 1 Year 2019-09-26