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) >

View: OLS_CRUISE_VESSPLNT_V

Entity (ENT) | Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:12281 | Updated: March 4, 2025 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Description

View used to combine unique vessel and plant deployment information.

Entity Type
Data View

Data Attribute / Type	Description
SOURCE VARCHAR2	Vessel or plant.
VESSEL_PLANT_SEQ NUMBER	Sequence generated value for an observer deployment record.
TRIP_CODE VARCHAR2	indicates if sole observer(3) , lead observer (1), second observer(2), or ResearchSampler (4) on deployment
CRUISE NUMBER	Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
VESSPLNT 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.
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.
COAST_GUARD_NUMBER NUMBER	USCG Registration Number.
LENGTH NUMBER	Mandatory length of a vessel from the regional office LOA.
LOCATION VARCHAR2	Always null
EMBARK_DATE DATE	Date of embarkation
DISEMBARK_DATE DATE	Date of disembarkation

Data Attribute / Type

Description

SOURCE
VARCHAR2

Vessel or plant.

VESSEL_PLANT_SEQ
NUMBER

Sequence generated value for an observer deployment record.

TRIP_CODE
VARCHAR2

indicates if sole observer(3) , lead observer (1), second observer(2), or ResearchSampler (4) on deployment

CRUISE
NUMBER

Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.

VESSPLNT
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.

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.

COAST_GUARD_NUMBER
NUMBER

USCG Registration Number.

LENGTH
NUMBER

Mandatory length of a vessel from the regional office LOA.

LOCATION
VARCHAR2

Always null

EMBARK_DATE
DATE

Date of embarkation

DISEMBARK_DATE
DATE

Date of disembarkation

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

Title:	View: OLS_CRUISE_VESSPLNT_V
Short Name:	OLS_CRUISE_VESSPLNT_V
Status:	Completed
Notes:	Loaded by batch 3083, 04-19-2012 13:25

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	NORPAC
Description:	View used to combine unique vessel and plant deployment information.

Attribute Summary

	Name	Type	Description
100	SOURCE	VARCHAR2	Vessel or plant.
100	VESSEL_PLANT_SEQ	NUMBER	Sequence generated value for an observer deployment record.
100	TRIP_CODE	VARCHAR2	indicates if sole observer(3) , lead observer (1), second observer(2), or ResearchSampler (4) on deployment
100	CRUISE	NUMBER	Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
100	VESSPLNT	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	LOCATION	VARCHAR2	Always null
100	EMBARK_DATE	DATE	Date of embarkation
100	DISEMBARK_DATE	DATE	Date of disembarkation

Name

Type

Description

100

SOURCE

VARCHAR2

Vessel or plant.

100

VESSEL_PLANT_SEQ

NUMBER

Sequence generated value for an observer deployment record.

100

TRIP_CODE

VARCHAR2

indicates if sole observer(3) , lead observer (1), second observer(2), or ResearchSampler (4) on deployment

100

CRUISE

NUMBER

Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.

100

VESSPLNT

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

LOCATION

VARCHAR2

Always null

100

EMBARK_DATE

DATE

Date of embarkation

100

DISEMBARK_DATE

DATE

Date of disembarkation

Attribute Details

SOURCE

CC ID: 65121

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Vessel or plant.
General Data Type:	VARCHAR2

VESSEL_PLANT_SEQ

CC ID: 65115

Seq. Order:	2
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	9
Scale:	0
Status:	Active
Description:	Sequence generated value for an observer deployment record.
General Data Type:	NUMBER

TRIP_CODE

CC ID: 65123

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	indicates if sole observer(3) , lead observer (1), second observer(2), or ResearchSampler (4) on deployment
General Data Type:	VARCHAR2

CRUISE

CC ID: 65120

Seq. Order:	4
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
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

VESSPLNT

CC ID: 65111

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
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: 65117

Seq. Order:	6
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: 65119

Seq. Order:	7
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: 65112

Seq. Order:	8
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: 65114

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	USCG Registration Number.
General Data Type:	NUMBER

LENGTH

CC ID: 65118

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Mandatory length of a vessel from the regional office LOA.
General Data Type:	NUMBER

LOCATION

CC ID: 65116

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Always null
General Data Type:	VARCHAR2

EMBARK_DATE

CC ID: 65122

Seq. Order:	12
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date of embarkation
General Data Type:	DATE

DISEMBARK_DATE

CC ID: 65113

Seq. Order:	13
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date of disembarkation
General Data Type:	DATE

Catalog Item ID:	12281
GUID:	gov.noaa.nmfs.inport:12281
Metadata Record Created By:	Doug Turnbull
Metadata Record Created:	2012-04-19 13:25+0000
Metadata Record Last Modified By:	michael moon
Metadata Record Last Modified:	2025-03-04 17:57+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

View: OLS_CRUISE_VESSPLNT_V

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

SOURCE

VESSEL_PLANT_SEQ

TRIP_CODE

CRUISE

VESSPLNT

NAME

PERMIT

ADFG_NUMBER

COAST_GUARD_NUMBER

LENGTH

LOCATION

EMBARK_DATE

DISEMBARK_DATE

Catalog Details