Search Help Show/Hide Menu
Summary
Item Identification
Keywords
Entity Info
Data Attributes
Extents
Catalog Details

Summary

Abstract

The lov_vessel table is populated from the VessPlnt table in Norpac. A vessel is identified by a leading A in the vessel_code field.

This table was modified in July 2012 to support the North Pacific Restructure published in the Federal Register on April 18, 2012 (77 FR 23326)

Description

The lov_vessel table is populated from the VessPlnt table in Norpac. A vessel is identified by a leading A in the vessel_code field.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
VESSEL_SEQ
NUMBER
Sequence Generated unique identifier of an Atlas vessel record. The lov vessel table combines the vessplant and catcher boat code tables.
VESSEL_CODE
VARCHAR2
VessPlnt code from old NORPAC system. This code may ultimately be retired, but is essential to the transitional ETL from Atlas to Inseason and Domestic.
NAME
VARCHAR2
Name a vessel - inherited from the NORPAC data set
PERMIT
VARCHAR2
Unique Code identifying a vessel - inherited from the NORPAC data set and created by the RAM division in Juneau
ADFG_NUMBER
VARCHAR2
Alaska Dept of Fish and Game unique vessel identifier.
COAST_GUARD_NUMBER
NUMBER
USCG Registration Number.
LENGTH
NUMBER
Mandatory length of a vessel from the regional office LOA.
COMMUNICATION_CODE
NUMBER
Indicates how observer data is transmitted from vessel
IGNORE_AUTOSYNC
VARCHAR2
Flag that ff "Y" the record will be excluded from automatic database synchroniztion process.
PERSON_ID
NUMBER
Fk to atl_lov_vessel_contact. Unique identifier generated in AKR database.
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.
RMD_CHANGED_BY
VARCHAR2
The user who changed the record lastly.
RMD_CHANGE_COMMENT
VARCHAR2
Comment on changing(updating) record.
RMD_TS_CHANGED
TIMESTAMP
The date on which the record was changed lastly.

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.

Extents

Time Frame 1
2008-12-15 - Present

Item Identification

Title: Table: ATL_LOV_VESSEL
Short Name: ATL_LOV_VESSEL
Status: Completed
Abstract:

The lov_vessel table is populated from the VessPlnt table in Norpac. A vessel is identified by a leading A in the vessel_code field.

This table was modified in July 2012 to support the North Pacific Restructure published in the Federal Register on April 18, 2012 (77 FR 23326)

Notes:

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

This table was modified in July 2012 to support the North Pacific Restructure published in the Federal Register on April 18, 2012 (77 FR 23326)

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None AFSC
None ATL
None ATLAS
None BYCATCH
None CRUISE
None FMA
None GROUNDFISH
None NORPAC
None OBSERVER
None VESSEL

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None AI
None ALEUTIAN ISLANDS
None BERING SEA
None BS
None BSAI
None GOA
None GULF OF ALASKA

Entity Information

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

The lov_vessel table is populated from the VessPlnt table in Norpac. A vessel is identified by a leading A in the vessel_code field.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key VESSEL_SEQ NUMBER Sequence Generated unique identifier of an Atlas vessel record. The lov vessel table combines the vessplant and catcher boat code tables.
100
VESSEL_CODE VARCHAR2 VessPlnt code from old NORPAC system. This code may ultimately be retired, but is essential to the transitional ETL from Atlas to Inseason and Domestic.
100
NAME VARCHAR2 Name a vessel - inherited from the NORPAC data set
100
PERMIT VARCHAR2 Unique Code identifying a vessel - inherited from the NORPAC data set and created by the RAM division in Juneau
100
ADFG_NUMBER VARCHAR2 Alaska Dept of Fish and Game unique vessel identifier.
100
COAST_GUARD_NUMBER NUMBER USCG Registration Number.
100
LENGTH NUMBER Mandatory length of a vessel from the regional office LOA.
100
COMMUNICATION_CODE NUMBER Indicates how observer data is transmitted from vessel
100
IGNORE_AUTOSYNC VARCHAR2 Flag that ff "Y" the record will be excluded from automatic database synchroniztion process.
100
PERSON_ID NUMBER Fk to atl_lov_vessel_contact. Unique identifier generated in AKR database.
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_CHANGED_BY VARCHAR2 The user who changed the record lastly.
100
RMD_CHANGE_COMMENT VARCHAR2 Comment on changing(updating) record.
100
RMD_TS_CHANGED TIMESTAMP The date on which the record was changed lastly.

Attribute Details

VESSEL_SEQ

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

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

General Data Type: NUMBER

VESSEL_CODE

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

VessPlnt code from old NORPAC system. This code may ultimately be retired, but is essential to the transitional ETL from Atlas to Inseason and Domestic.

General Data Type: VARCHAR2

NAME

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

Name a vessel - inherited from the NORPAC data set

General Data Type: VARCHAR2

PERMIT

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

Unique Code identifying a vessel - inherited from the NORPAC data set and created by the RAM division in Juneau

General Data Type: VARCHAR2

ADFG_NUMBER

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

Alaska Dept of Fish and Game unique vessel identifier.

General Data Type: VARCHAR2

COAST_GUARD_NUMBER

CC ID: 38628
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 7
Scale: 0
Status: Active
Description:

USCG Registration Number.

General Data Type: NUMBER

LENGTH

CC ID: 38629
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Mandatory length of a vessel from the regional office LOA.

General Data Type: NUMBER

COMMUNICATION_CODE

CC ID: 67520
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Indicates how observer data is transmitted from vessel

General Data Type: NUMBER

IGNORE_AUTOSYNC

CC ID: 67522
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 1
Min Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Flag that ff "Y" the record will be excluded from automatic database synchroniztion process.

General Data Type: VARCHAR2
Case Restriction: Upper
Allowed Values: Y, N
Default Value: N

PERSON_ID

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

Fk to atl_lov_vessel_contact. Unique identifier generated in AKR database.

RMD_ACTION

CC ID: 67524
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 2
Min Length: 1
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.

General Data Type: VARCHAR2
Case Restriction: Upper

RMD_CHANGED_BY

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

The user who changed the record lastly.

General Data Type: VARCHAR2
Case Restriction: Mixed

RMD_CHANGE_COMMENT

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

Comment on changing(updating) record.

General Data Type: VARCHAR2
Case Restriction: Mixed

RMD_TS_CHANGED

CC ID: 67527
Seq. Order: 14
Data Storage Type: TIMESTAMP
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

The date on which the record was changed lastly.

Extents

Extent Group 1

Extent Group 1 / Time Frame 1

CC ID: 67521
Time Frame Type: Continuing
Start: 2008-12-15

Catalog Details

Catalog Item ID: 9723
GUID: gov.noaa.nmfs.inport:9723
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