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
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.
TOTAL_SETS
NUMBER
How many sets there are in the trip
TOTAL_HAULS
NUMBER
How many hauls there are in the trip
COMMENTS
VARCHAR2
Comments on the trip
STATUS_ID
VARCHAR2
Status Identifier
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
DELETED_BY_USER_ID
VARCHAR2
Who deleted the record
DELETED_DATE
DATE
When Record Was Deleted
DELETE_REASON_CODE
VARCHAR2
Reason Code For WHy Record Was Deleted

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_DELETE
Short Name: POP_TRIP_LOG_DELETE
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
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
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
TOTAL_SETS NUMBER How many sets there are in the trip
100
TOTAL_HAULS NUMBER How many hauls there are in the trip
100
COMMENTS VARCHAR2 Comments on the trip
100
STATUS_ID VARCHAR2 Status Identifier
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
DELETED_BY_USER_ID VARCHAR2 Who deleted the record
100
DELETED_DATE DATE When Record Was Deleted
100
DELETE_REASON_CODE VARCHAR2 Reason Code For WHy Record Was Deleted

Attribute Details

TRIP_NUMBER

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

Primary Key

General Data Type: VARCHAR2

POP_VESSEL_CODE

CC ID: 16539
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: 16538
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: 16537
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: 16536
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: 16535
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

OBSERVER_TYPE

CC ID: 16534
Seq. Order: 7
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: 16533
Seq. Order: 8
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: 16532
Seq. Order: 9
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: 16531
Seq. Order: 10
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

TOTAL_SETS

CC ID: 16530
Seq. Order: 11
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: 16529
Seq. Order: 12
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

COMMENTS

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

Comments on the trip

General Data Type: VARCHAR2

STATUS_ID

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

Status Identifier

General Data Type: VARCHAR2

CREATED_BY_USER_ID

CC ID: 16526
Seq. Order: 15
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: 16525
Seq. Order: 16
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: 16524
Seq. Order: 17
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: 16523
Seq. Order: 18
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Modified when

General Data Type: DATE

DELETED_BY_USER_ID

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

Who deleted the record

General Data Type: VARCHAR2

DELETED_DATE

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

When Record Was Deleted

General Data Type: DATE

DELETE_REASON_CODE

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

Reason Code For WHy Record Was Deleted

General Data Type: VARCHAR2

Catalog Details

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