19038
Table: ATL_MESSAGE
ATL_MESSAGE
Entity
Published / External
18964
AFSC/FMA/NPRB Alternative Catch Monitoring Table and Column Definitions
Data Set
Completed
This entity captures messages transmitted from the atlas client to FMA. The functionality will be expanded to full duplex recording in 2009.
Loaded by batch 4574, 05-03-2013 17:18
Data Table
Yes
NPRB_1017
This entity captures messages transmitted from the atlas client to FMA. The functionality will be expanded to full duplex recording in 2009.
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
No
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
38
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
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:19038
Doug Turnbull
2013-05-03T17:18:48
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