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

View: OLS_OBSERVER_COMMENTS_V

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

Summary

Abstract

Summarizes the all observer contracts to satisfy old norpac reports requirements

Description

Summarizes the all observer contracts to satisfy old norpac reports requirements

Entity Information

Entity Type
Data View

Data Attribute / Type Description
CRUISE
NUMBER 		Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
PERMIT
VARCHAR2 		Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
VESSEL_PLANT_SEQ
NUMBER 		Sequence generated value for an observer deployment record.
COMMENT_TYPE
CHAR 		Type of comment.
STAFF_ID
VARCHAR2 		Sequence derived unique identifier of an employee.
COMMENTS
VARCHAR2 		FMA staff-entered comments regarding an observer deployment.

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

Summarizes the all observer contracts to satisfy old norpac reports requirements
Purpose:

Summarizes the all observer contracts to satisfy old norpac reports requirements
Notes:

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

Entity Information

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

Summarizes the all observer contracts to satisfy old norpac reports requirements

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 CRUISE NUMBER Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise 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
 VESSEL_PLANT_SEQ NUMBER Sequence generated value for an observer deployment record.
100
 COMMENT_TYPE CHAR Type of comment.
100
 STAFF_ID VARCHAR2 Sequence derived unique identifier of an employee.
100
 COMMENTS VARCHAR2 FMA staff-entered comments regarding an observer deployment.

Attribute Details

CRUISE

CC ID: 65269
Seq. Order: 1
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

PERMIT

CC ID: 65270
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

VESSEL_PLANT_SEQ

CC ID: 65267
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

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

COMMENT_TYPE

CC ID: 65266
Seq. Order: 4
Data Storage Type: CHAR
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Type of comment.
General Data Type: CHAR

STAFF_ID

CC ID: 65265
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Sequence derived unique identifier of an employee.
General Data Type: VARCHAR2

COMMENTS

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

FMA staff-entered comments regarding an observer deployment.
General Data Type: VARCHAR2

Catalog Details

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