Table: LOV_VESSEL
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:7536 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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.
DescriptionThe 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. |
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. |
LENGTH
NUMBER |
Mandatory length of a vessel from the regional office LOA. |
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.
Item Identification
Title: | Table: LOV_VESSEL |
---|---|
Short Name: | 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 2204, 03-28-2008 14:09 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | TURNBULLD |
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
|
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
|
LENGTH | NUMBER | Mandatory length of a vessel from the regional office LOA. |
Attribute Details
VESSEL_SEQ
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 |
NAME
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Name a vessel - inherited from the NORPAC data set |
General Data Type: | VARCHAR2 |
PERMIT
Seq. Order: | 3 |
---|---|
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
Seq. Order: | 4 |
---|---|
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 |
LENGTH
Seq. Order: | 5 |
---|---|
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 |
Catalog Details
Catalog Item ID: | 7536 |
---|---|
GUID: | gov.noaa.nmfs.inport:7536 |
Metadata Record Created By: | Doug Turnbull |
Metadata Record Created: | 2008-03-28 14:10+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-05-04 |
Owner Org: | AFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-05-04 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-05-04 |