Metadata Rubric

100%

6 / 6

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_LOV_VESSEL

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

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

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

Thesaurus

Keyword

UNCONTROLLED

None

ALEUTIAN ISLANDS

None

BERING SEA

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

	Name	Type	Description
100	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.

Name

Type

Description

100

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