12279
Table: ATL_LOV_VESSEL
ATL_LOV_VESSEL
Entity
Published / External
12269
AFSC/FMA/Observer Logistics System (OLS)
Data Set
Completed
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.
Loaded by batch 3083, 04-19-2012 13:25
Theme
fisheries
Theme
goa
Theme
groundfish
Theme
logistics
Theme
nmfs
Theme
noaa
Theme
norpac
Theme
observer
Theme
permit
Theme
vessel
Spatial
afsc
Spatial
bsa
Spatial
eez
Spatial
fma
Data Table
Yes
NORPAC
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.
1
VESSEL_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence Generated unique identifier of an Atlas vessel record. The lov vessel table combines the vessplant and catcher boat code tables.
NUMBER
2
VESSEL_CODE
VARCHAR2
6
Yes
No
Active
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.
VARCHAR2
3
NAME
VARCHAR2
50
No
No
Active
Name a vessel - inherited from the NORPAC data set
VARCHAR2
4
PERMIT
VARCHAR2
6
No
No
Active
Unique Code identifying a vessel - inherited from the NORPAC data set and created by the RAM division in Juneau
VARCHAR2
5
ADFG_NUMBER
VARCHAR2
6
No
No
Active
Alaska Dept of Fish and Game unique vessel identifier.
VARCHAR2
6
COAST_GUARD_NUMBER
NUMBER
22
No
No
7
0
Active
USCG Registration Number.
NUMBER
7
LENGTH
NUMBER
22
No
No
3
0
Active
Mandatory length of a vessel from the regional office LOA.
NUMBER
8
COMMUNICATION_CODE
NUMBER
22
No
No
3
0
Active
Indicates how observer data is transmitted from vessel
NUMBER
gov.noaa.nmfs.inport:12279
Doug Turnbull
2012-04-19T13:25:57
SysAdmin InPortAdmin
2022-08-09T17:11:05
2018-09-26
Alaska Fisheries Science Center
AFSC
7600 Sand Point Way N.E., Building 4
Seattle
WA
98115
USA
http://www.afsc.noaa.gov
0700-1700 Pacific Time
1001
Public
No
2018-09-26
1 Year
2019-09-26