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/Observer Logistics System (OLS) >

Table: ATL_LOV_VESSEL

Entity (ENT) | Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:12279 | 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.
Notes:	Loaded by batch 3083, 04-19-2012 13:25

Keywords

Theme Keywords

Thesaurus	Keyword
UNCONTROLLED
None	fisheries
None	goa
None	groundfish
None	logistics
None	nmfs
None	noaa
None	norpac
None	observer
None	permit
None	vessel

Thesaurus

Keyword

UNCONTROLLED

None

fisheries

None

goa

None

groundfish

None

logistics

None

nmfs

None

noaa

None

norpac

None

observer

None

permit

None

vessel

Spatial Keywords

Thesaurus	Keyword
UNCONTROLLED
None	afsc
None	bsa
None	eez
None	fma

Thesaurus

Keyword

UNCONTROLLED

None

afsc

None

bsa

None

eez

None

fma

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

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

Attribute Details

VESSEL_SEQ

CC ID: 65067

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: 65068

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: 65069

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: 65070

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: 65071

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: 65072

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: 65073

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: 65074

Seq. Order:	8
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Indicates how observer data is transmitted from vessel
General Data Type:	NUMBER

Catalog Details

Catalog Item ID:	12279
GUID:	gov.noaa.nmfs.inport:12279
Metadata Record Created By:	Doug Turnbull
Metadata Record Created:	2012-04-19 13:25+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