Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Entity Information

Entity Type
Data View

Data Attribute / Type Description
SOURCE
VARCHAR2
VESSEL_PLANT_SEQ
NUMBER
TRIP_CODE
VARCHAR2
CRUISE
NUMBER
VESSPLNT
VARCHAR2
NAME
VARCHAR2
PERMIT
VARCHAR2
ADFG_NUMBER
VARCHAR2
COAST_GUARD_NUMBER
NUMBER
LENGTH
NUMBER
LOCATION
VARCHAR2
EMBARK_DATE
DATE
DISEMBARK_DATE
DATE

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