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 |
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
![]() |
![]() |
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |