Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
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: OLS_VESSEL_PLANT

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:12323  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

This entity represents the deployment, and the current role, of an observer to a vessel or processing plant. This differs from the atl_cruise_vessel and atl_cruise_plant objects in that the deployment is for all observers and the atl_ tables reference only the lead observer (cruise) in that deployment

Description

This entity represents the deployment, and the current role, of an observer to a vessel or processing plant. This differs from the atl_cruise_vessel and atl_cruise_plant objects in that the deployment is for all observers and the atl_ tables reference only the lead observer (cruise) in that deployment

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
VESSEL_PLANT_SEQ
NUMBER 		Sequence generated value for an observer deployment record.
PERMIT
VARCHAR2 		Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
CRUISE
NUMBER 		Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
EMBARK_DATE
DATE 		Date of embarkation
DISEMBARK_DATE
DATE 		Date of disembarkation
TRIP_CODE
VARCHAR2 		indicates if sole observer , lead observer, or second observer on deployment
SUBCONTRACTOR_CODE
VARCHAR2 		subcontractor employer code

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: OLS_VESSEL_PLANT
Short Name: OLS_VESSEL_PLANT
Status: Completed
Abstract:

This entity represents the deployment, and the current role, of an observer to a vessel or processing plant. This differs from the atl_cruise_vessel and atl_cruise_plant objects in that the deployment is for all observers and the atl_ tables reference only the lead observer (cruise) in that deployment
Notes:

Loaded by batch 3083, 04-19-2012 13:25

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NORPAC
Description:

This entity represents the deployment, and the current role, of an observer to a vessel or processing plant. This differs from the atl_cruise_vessel and atl_cruise_plant objects in that the deployment is for all observers and the atl_ tables reference only the lead observer (cruise) in that deployment

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key VESSEL_PLANT_SEQ NUMBER Sequence generated value for an observer deployment record.
100
 PERMIT VARCHAR2 Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
100
 CRUISE NUMBER Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
100
 EMBARK_DATE DATE Date of embarkation
100
 DISEMBARK_DATE DATE Date of disembarkation
100
 TRIP_CODE VARCHAR2 indicates if sole observer , lead observer, or second observer on deployment
100
 SUBCONTRACTOR_CODE VARCHAR2 subcontractor employer code

Attribute Details

VESSEL_PLANT_SEQ

CC ID: 65368
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 9
Scale: 0
Status: Active
Description:

Sequence generated value for an observer deployment record.
General Data Type: NUMBER

PERMIT

CC ID: 65369
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
General Data Type: VARCHAR2

CRUISE

CC ID: 65370
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 9
Scale: 0
Status: Active
Description:

Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.OLS_OBSERVER_CRUISE

EMBARK_DATE

CC ID: 65371
Seq. Order: 4
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Date of embarkation
General Data Type: DATE

DISEMBARK_DATE

CC ID: 65372
Seq. Order: 5
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date of disembarkation
General Data Type: DATE

TRIP_CODE

CC ID: 65373
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

indicates if sole observer , lead observer, or second observer on deployment
General Data Type: VARCHAR2
Foreign Key Relations:

NORPAC.OLS_LOV_TRIP_CODES

SUBCONTRACTOR_CODE

CC ID: 65374
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

subcontractor employer code
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 12323
GUID: gov.noaa.nmfs.inport:12323
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