9733 ATL_MESSAGE Entity Published / External 7284 AFSC/FMA/North Pacific Groundfish and Halibut Observer Program, Post 2008 Fishery Statistics. Data Set Completed This entity captures messages transmitted from the atlas client to FMA. The functionality has been expanded to direct messages to specific staff for the purposes of inseason advising.. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity captures messages transmitted from the atlas client to FMA. The functionality has been expanded to direct messages to specific staff for the purposes of inseason advising.. 1 MESSAGE_ID NUMBER 22 Yes No 10 0 Active Unique sequence generated number - PK NUMBER 2 MESSAGE_TYPE VARCHAR2 10 Yes No Active Identifies a record as In (I) Out (O) VARCHAR2 3 PERMIT VARCHAR2 6 Yes No Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 4 FROM_ADDRESS VARCHAR2 100 Yes No Active Intended to identify the sending clent. Currently a defaulted value. VARCHAR2 5 TO_ADDRESS VARCHAR2 100 Yes No Active Intended to identify the sending clent. Currently a defaulted value. VARCHAR2 6 MESSAGE_TEXT VARCHAR2 4000 No No Active Observer message text. VARCHAR2 7 CREATE_DATE DATE 7 Yes No Active Timestamp for record entry into table. DATE 8 VESSEL_NAME VARCHAR2 35 No No Active Name of vessel. VARCHAR2 9 CRUISE NUMBER 22 No No 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 10 TRANSMITTED NUMBER 22 Yes No 38 Active Defaults to 0 becomes 1 when message is forwarded to the inseason advisor. NUMBER 11 OBSERVER_LNAME VARCHAR2 20 No No Active Last name of the observer who originated the transmission. VARCHAR2 12 OBSERVER_FNAME VARCHAR2 20 No No Active First name of the observer who originated the transmission. VARCHAR2 gov.noaa.nmfs.inport:9733 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