Slide Menu
Jump to Section...
Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 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... >

ATL_LOV_VESSEL_NOTE

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:12662  |  Updated: August 9, 2022  |  Published / External 

Item Identification

Title: ATL_LOV_VESSEL_NOTE
Short Name: ATL_LOV_VESSEL_NOTE
Status: In Work
Abstract:

Additional note related to each vessel which is not captured with the database structure.

Entity Information

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

Additional note related to each vessel which is not captured with the database structure.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 VESSEL_NOTE_SEQ NUMBER Sequence Generated unique identifier of each vessel note.
100
 VESSEL_SEQ NUMBER Primary key value of atl_lov_vessel. Sequence Generated unique identifier of an Atlas vessel record. The lov vessel table combines the vessplant and catcher boat code tables.
100
 NOTE VARCHAR2 Single note for a vessel record. Can hold 4000 character per note.
100
 RMD_CHANGED_BY VARCHAR2 The user who changed the record lastly.
100
 RMD_TS_CHANGED TIMESTAMP The date on which the record was changed lastly.
100
 RMD_ACTION VARCHAR2 last action performed on the record. "I" for Inserting, "U" for Updating, "Rv" for Reverting to a previous record state, "Rc" for recovered from a deletion and "D" for Deleting. "D" only recorded on history record.
100
 RMD_CHANGE_COMMENT VARCHAR2 Comment on changing(updating) record.

Attribute Details

VESSEL_NOTE_SEQ

CC ID: 67563
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Sequence Generated unique identifier of each vessel note.

VESSEL_SEQ

CC ID: 67564
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Primary key value of atl_lov_vessel. Sequence Generated unique identifier of an Atlas vessel record. The lov vessel table combines the vessplant and catcher boat code tables.

NOTE

CC ID: 67565
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Single note for a vessel record. Can hold 4000 character per note.

RMD_CHANGED_BY

CC ID: 67566
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

The user who changed the record lastly.

RMD_TS_CHANGED

CC ID: 67567
Seq. Order: 5
Data Storage Type: TIMESTAMP
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

The date on which the record was changed lastly.

RMD_ACTION

CC ID: 67568
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

last action performed on the record. "I" for Inserting, "U" for Updating, "Rv" for Reverting to a previous record state, "Rc" for recovered from a deletion and "D" for Deleting. "D" only recorded on history record.

RMD_CHANGE_COMMENT

CC ID: 67569
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Comment on changing(updating) record.

Catalog Details

Catalog Item ID: 12662
GUID: gov.noaa.nmfs.inport:12662
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2012-07-18 14:50+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