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

Summary

Abstract

One record for each trip where observers where located

Description

One record for each trip where observers where located

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TRIP_NUMBER
VARCHAR2
Primary Key
POP_VESSEL_CODE
VARCHAR2
POP Vessel Code, more than 90% of the time = Coast Guard Vessel Id
VESSEL_NAME
VARCHAR2
Vessel Name
DEPARTURE_DATE
DATE
Departure Date of the Vessel
LANDING_DATE
DATE
Landing Date of the Vessel
SEA_DAYS
NUMBER
Calculated as LANDING_DATE-DEPARTURE_DATE+1
COMMENTS
VARCHAR2
Comments on the trip
OBSERVER_TYPE
VARCHAR2
Observer Type
OBSERVER_INIT
VARCHAR2
Observer Init
TRIP_TYPE
VARCHAR2
Trip Type
TRIP_SUMMARY
VARCHAR2
Linking Column With PLL and DLS Data.
CREATED_BY_USER_ID
VARCHAR2
Created by whom
CREATED_DATE
DATE
Created when
MODIFIED_BY_USER_ID
VARCHAR2
Modified by whom
MODIFIED_DATE
DATE
Modified when
STATUS_ID
VARCHAR2
Status Identifier
TOTAL_SETS
NUMBER
How many sets there are in the trip
TOTAL_HAULS
NUMBER
How many hauls there are in the trip

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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