Slide Menu
Search Help Show/Hide Menu

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