Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Fisheries Statistics Division > Observer Programs > Pelagic Longline Observer Program > PELAGIC OBSERVER PROGRAM (POP). Catch/Effort d... >

Table: POP_TRIP_LOG_DELETE

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:5372  |  Updated: June 14, 2024  |  Published / External 
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: Lee M Weinberger
Metadata Record Last Modified: 2024-06-14 13:53+0000
Metadata Record Published: 2024-06-14
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