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.

Item Identification

Title: Table: POP_TRIP_LOG
Short Name: POP_TRIP_LOG
Status: Completed
Abstract:

One record for each trip where observers where located

Notes:

Loaded by batch 1683, 10-12-2007 05:01

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: POPOL
Description:

One record for each trip where observers where located

Data Attributes

Attribute Summary

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

Attribute Details

TRIP_NUMBER

CC ID: 16519
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 6
Required: Yes
Primary Key: Yes
Status: Active
Description:

Primary Key

General Data Type: VARCHAR2

POP_VESSEL_CODE

CC ID: 16518
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 8
Required: Yes
Primary Key: No
Status: Active
Description:

POP Vessel Code, more than 90% of the time = Coast Guard Vessel Id

General Data Type: VARCHAR2

VESSEL_NAME

CC ID: 16517
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Vessel Name

General Data Type: VARCHAR2

DEPARTURE_DATE

CC ID: 16516
Seq. Order: 4
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Departure Date of the Vessel

General Data Type: DATE

LANDING_DATE

CC ID: 16515
Seq. Order: 5
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Landing Date of the Vessel

General Data Type: DATE

SEA_DAYS

CC ID: 16514
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Calculated as LANDING_DATE-DEPARTURE_DATE+1

General Data Type: NUMBER

COMMENTS

CC ID: 16513
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 2000
Required: No
Primary Key: No
Status: Active
Description:

Comments on the trip

General Data Type: VARCHAR2

OBSERVER_TYPE

CC ID: 16512
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 3
Required: Yes
Primary Key: No
Status: Active
Description:

Observer Type

General Data Type: VARCHAR2

OBSERVER_INIT

CC ID: 16511
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Observer Init

General Data Type: VARCHAR2

TRIP_TYPE

CC ID: 16510
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Trip Type

General Data Type: VARCHAR2

TRIP_SUMMARY

CC ID: 16509
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Linking Column With PLL and DLS Data.

General Data Type: VARCHAR2

CREATED_BY_USER_ID

CC ID: 16508
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: No
Status: Active
Description:

Created by whom

General Data Type: VARCHAR2

CREATED_DATE

CC ID: 16507
Seq. Order: 13
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Created when

General Data Type: DATE

MODIFIED_BY_USER_ID

CC ID: 16506
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Modified by whom

General Data Type: VARCHAR2

MODIFIED_DATE

CC ID: 16505
Seq. Order: 15
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Modified when

General Data Type: DATE

STATUS_ID

CC ID: 16504
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Status Identifier

General Data Type: VARCHAR2

TOTAL_SETS

CC ID: 16503
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

How many sets there are in the trip

General Data Type: NUMBER

TOTAL_HAULS

CC ID: 16502
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

How many hauls there are in the trip

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 5371
GUID: gov.noaa.nmfs.inport:5371
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-10-12 05:01+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-06
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-06