Slide Menu
InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.2.3. Downtime Schedule Tuesday, November 29, 2022 12:00pm - 1:30pm Eastern / 10:00am - 11:30pm Pacific / 7:00am - 8:30pm Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: https://www.fisheries.noaa.gov/inportserve/waf What's...
View All
Search Help Show/Hide Menu

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