Table: ATL_MESSAGE
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:19038 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
This entity captures messages transmitted from the atlas client to FMA. The functionality will be expanded to full duplex recording in 2009.
DescriptionThis entity captures messages transmitted from the atlas client to FMA. The functionality will be expanded to full duplex recording in 2009.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
MESSAGE_ID
NUMBER |
Unique sequence generated number - PK |
MESSAGE_TYPE
VARCHAR2 |
Identifies a record as In (I) Out (O) |
PERMIT
VARCHAR2 |
Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau |
FROM_ADDRESS
VARCHAR2 |
Intended to identify the sending clent. Currently a defaulted value. |
TO_ADDRESS
VARCHAR2 |
Intended to identify the sending clent. Currently a defaulted value. |
MESSAGE_TEXT
VARCHAR2 |
Observer message text. |
CREATE_DATE
DATE |
Timestamp for record entry into table. |
VESSEL_NAME
VARCHAR2 |
Name of vessel. |
CRUISE
NUMBER |
Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. |
TRANSMITTED
NUMBER |
Defaults to 0 becomes 1 when message is forwarded to the inseason advisor. |
OBSERVER_LNAME
VARCHAR2 |
Last name of the observer who originated the transmission. |
OBSERVER_FNAME
VARCHAR2 |
First name of the observer who originated the transmission. |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (AFSC) for inquiries on this record.
Item Identification
Title: | Table: ATL_MESSAGE |
---|---|
Short Name: | ATL_MESSAGE |
Status: | Completed |
Abstract: |
This entity captures messages transmitted from the atlas client to FMA. The functionality will be expanded to full duplex recording in 2009. |
Notes: |
Loaded by batch 4574, 05-03-2013 17:18 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | NPRB_1017 |
Description: |
This entity captures messages transmitted from the atlas client to FMA. The functionality will be expanded to full duplex recording in 2009. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
MESSAGE_ID | NUMBER | Unique sequence generated number - PK | |
100
|
MESSAGE_TYPE | VARCHAR2 | Identifies a record as In (I) Out (O) | |
100
|
PERMIT | VARCHAR2 | Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau | |
100
|
FROM_ADDRESS | VARCHAR2 | Intended to identify the sending clent. Currently a defaulted value. | |
100
|
TO_ADDRESS | VARCHAR2 | Intended to identify the sending clent. Currently a defaulted value. | |
100
|
MESSAGE_TEXT | VARCHAR2 | Observer message text. | |
100
|
CREATE_DATE | DATE | Timestamp for record entry into table. | |
100
|
VESSEL_NAME | VARCHAR2 | Name of vessel. | |
100
|
CRUISE | NUMBER | Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. | |
100
|
TRANSMITTED | NUMBER | Defaults to 0 becomes 1 when message is forwarded to the inseason advisor. | |
100
|
OBSERVER_LNAME | VARCHAR2 | Last name of the observer who originated the transmission. | |
100
|
OBSERVER_FNAME | VARCHAR2 | First name of the observer who originated the transmission. |
Attribute Details
MESSAGE_ID
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Unique sequence generated number - PK |
General Data Type: | NUMBER |
MESSAGE_TYPE
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Identifies a record as In (I) Out (O) |
General Data Type: | VARCHAR2 |
PERMIT
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau |
General Data Type: | VARCHAR2 |
FROM_ADDRESS
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 100 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Intended to identify the sending clent. Currently a defaulted value. |
General Data Type: | VARCHAR2 |
TO_ADDRESS
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 100 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Intended to identify the sending clent. Currently a defaulted value. |
General Data Type: | VARCHAR2 |
MESSAGE_TEXT
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4000 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Observer message text. |
General Data Type: | VARCHAR2 |
CREATE_DATE
Seq. Order: | 7 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Timestamp for record entry into table. |
General Data Type: | DATE |
VESSEL_NAME
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 35 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of vessel. |
General Data Type: | VARCHAR2 |
CRUISE
Seq. Order: | 9 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. |
General Data Type: | NUMBER |
TRANSMITTED
Seq. Order: | 10 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Defaults to 0 becomes 1 when message is forwarded to the inseason advisor. |
General Data Type: | NUMBER |
OBSERVER_LNAME
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Last name of the observer who originated the transmission. |
General Data Type: | VARCHAR2 |
OBSERVER_FNAME
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
First name of the observer who originated the transmission. |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 19038 |
---|---|
GUID: | gov.noaa.nmfs.inport:19038 |
Metadata Record Created By: | Doug Turnbull |
Metadata Record Created: | 2013-05-03 17:18+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-05-18 |
Owner Org: | AFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-05-18 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-05-18 |