5371
Table: POP_TRIP_LOG
POP_TRIP_LOG
Entity
Published / External
30713
PELAGIC OBSERVER PROGRAM (POP). Catch/Effort data collected by observers on board U.S. commercial Pelagic Longline vessels
Data Set
Completed
One record for each trip where observers where located
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
One record for each trip where observers where located
1
TRIP_NUMBER
VARCHAR2
6
Yes
Yes
Active
Primary Key
VARCHAR2
2
POP_VESSEL_CODE
VARCHAR2
8
Yes
No
Active
POP Vessel Code, more than 90% of the time = Coast Guard Vessel Id
VARCHAR2
3
VESSEL_NAME
VARCHAR2
20
No
No
Active
Vessel Name
VARCHAR2
4
DEPARTURE_DATE
DATE
7
No
No
Active
Departure Date of the Vessel
DATE
5
LANDING_DATE
DATE
7
Yes
No
Active
Landing Date of the Vessel
DATE
6
SEA_DAYS
NUMBER
22
No
No
3
0
Active
Calculated as LANDING_DATE-DEPARTURE_DATE+1
NUMBER
7
COMMENTS
VARCHAR2
2000
No
No
Active
Comments on the trip
VARCHAR2
8
OBSERVER_TYPE
VARCHAR2
3
Yes
No
Active
Observer Type
VARCHAR2
9
OBSERVER_INIT
VARCHAR2
4
No
No
Active
Observer Init
VARCHAR2
10
TRIP_TYPE
VARCHAR2
1
No
No
Active
Trip Type
VARCHAR2
11
TRIP_SUMMARY
VARCHAR2
10
No
No
Active
Linking Column With PLL and DLS Data.
VARCHAR2
12
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
13
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
14
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Modified by whom
VARCHAR2
15
MODIFIED_DATE
DATE
7
No
No
Active
Modified when
DATE
16
STATUS_ID
VARCHAR2
1
No
No
Active
Status Identifier
VARCHAR2
17
TOTAL_SETS
NUMBER
22
No
No
3
0
Active
How many sets there are in the trip
NUMBER
18
TOTAL_HAULS
NUMBER
22
No
No
3
0
Active
How many hauls there are in the trip
NUMBER
gov.noaa.nmfs.inport:5371
Lee Weinberger
2007-10-12T05:01:46
SysAdmin InPortAdmin
2022-08-09T17:11:00
2021-05-06
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
www.sefsc.noaa.gov
8:00 a.m. - 4:30 p.m. EST
1001
Public
No
2021-05-06
1 Year
2022-05-06