Account Creation Issues: We have received reports of issues with creating new user accounts and linking accounts to CAM, and are currently investigating the root cause. In the meantime: - If you're experiencing errors creating new users, please use the "Quick Add" feature instead (click the "Quick Add" button on the Manage Users page). - If you're experiencing errors linking CAM accoun...
View All
Search Help Show/Hide Menu
Metadata Rubric
85%
5.1 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > North Pacific (NORPAC) Groundfish and Halibut O... > AFSC/FMA/North Pacific Groundfish and Halibut O... >

Table: ATL_OUT_MESSAGES

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:9743  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Created for the convenience of loading data into the local version of atlas.

Description

Created for the convenience of loading data into the local version of atlas.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
OUT_MESSAGE_ID
NUMBER 		Sequence generated
OBSERVER_LNAME
VARCHAR2
OBSERVER_FNAME
VARCHAR2
VESSEL_NAME
VARCHAR2
PERMIT
NUMBER
CRUISE
NUMBER
CREATE_DATE
DATE
TRANSMITTED
NUMBER
MESSAGE_TEXT
LONG
MESSAGE_TYPE
VARCHAR2

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_OUT_MESSAGES
Short Name: ATL_OUT_MESSAGES
Status: Completed
Abstract:

Created for the convenience of loading data into the local version of atlas.
Notes:

Loaded by batch 2390, 06-30-2009 16:11

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NORPAC
Description:

Created for the convenience of loading data into the local version of atlas.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key OUT_MESSAGE_ID NUMBER Sequence generated
67
 OBSERVER_LNAME VARCHAR2
67
 OBSERVER_FNAME VARCHAR2
67
 VESSEL_NAME VARCHAR2
67
 PERMIT NUMBER
67
 CRUISE NUMBER
67
 CREATE_DATE DATE
67
 TRANSMITTED NUMBER
67
 MESSAGE_TEXT LONG
67
 MESSAGE_TYPE VARCHAR2

Attribute Details

OUT_MESSAGE_ID

CC ID: 38863
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 10
Scale: 0
Status: Active
Description:

Sequence generated
General Data Type: NUMBER

OBSERVER_LNAME

CC ID: 38862
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

OBSERVER_FNAME

CC ID: 38861
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

VESSEL_NAME

CC ID: 38866
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

PERMIT

CC ID: 38864
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
General Data Type: NUMBER

CRUISE

CC ID: 38858
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
General Data Type: NUMBER

CREATE_DATE

CC ID: 38857
Seq. Order: 7
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
General Data Type: DATE

TRANSMITTED

CC ID: 38865
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
General Data Type: NUMBER

MESSAGE_TEXT

CC ID: 38859
Seq. Order: 9
Data Storage Type: LONG
Required: No
Primary Key: No
Status: Active
General Data Type: LONG

MESSAGE_TYPE

CC ID: 38860
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 9743
GUID: gov.noaa.nmfs.inport:9743
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2009-06-30 16:11+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-09-26
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-09-26
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-09-26