Slide Menu
Jump to Section...
Search Help Show/Hide Menu
Metadata Rubric
67%
4 / 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_CRUISE_VESSPLNT_V

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:12281  |  Updated: August 9, 2022  |  Published / External 

Item Identification

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 Information

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

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
 SOURCE VARCHAR2
67
 VESSEL_PLANT_SEQ NUMBER
67
 TRIP_CODE VARCHAR2
67
 CRUISE NUMBER
67
 VESSPLNT VARCHAR2
67
 NAME VARCHAR2
67
 PERMIT VARCHAR2
67
 ADFG_NUMBER VARCHAR2
67
 COAST_GUARD_NUMBER NUMBER
67
 LENGTH NUMBER
67
 LOCATION VARCHAR2
67
 EMBARK_DATE DATE
67
 DISEMBARK_DATE DATE

Attribute Details

SOURCE

CC ID: 65121
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
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
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
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
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
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
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
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
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
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
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
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
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
General Data Type: DATE

Catalog Details

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