28557
Table: TRIP
TRIP
Entity
Published / External
27501
U.S. Caribbean Commercial Landings (CCL) Tables in new format since July 2011 for U.S. Virgin Islands and January 2012 for Puerto Rico
Data Set
Completed
A unique list of Fishing Trips. One record for each Fishing Trip reported.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
A unique list of Fishing Trips. One record for each Fishing Trip reported.
1
TRIP_ID
NUMBER
22
Yes
Yes
38
Active
Primary key for this table.
NUMBER
2
FORM_TEMPLATE_CD
VARCHAR2
30
Yes
No
Active
FK to FORM_TEMPLATE_LIST. Identifies the Form Template (both paper and online) used to record the Fishing Trip information.
VARCHAR2
CCL.FORM_TEMPLATE_LIST
3
VESSEL_CD
VARCHAR2
30
No
No
Active
Vessel identification value
VARCHAR2
4
TRIP_DT
DATE
7
Yes
No
Active
Trip report date
DATE
5
TRIP_TICKET_NUM
VARCHAR2
30
Yes
No
Active
Preprinted Trip Ticket number
VARCHAR2
6
TRIP_LANDING_LOCATION
VARCHAR2
60
No
No
Active
Location where the Trip landed the catch.
VARCHAR2
7
IS_DATA_TAKEN
NUMBER
22
No
No
38
0
Active
Trip Surveyed/sampled by DFW Sampler
NUMBER
8
IS_DAY_TRIP
NUMBER
22
No
No
1
0
Active
Did the fishing trip take place mainly during the day?.1 = Day fishing trip..
NUMBER
9
IS_FEDERAL_WATERS
NUMBER
22
No
No
1
0
Active
Was the Fishing Trip in Federal Waters. Yes, if more than 3 miles off shore for USVI and more than 9 miles off shore for Puerto Rico.
NUMBER
10
IS_TRIP_LEASED
NUMBER
22
No
No
1
0
Active
Is the Trip leased with paying customers.
NUMBER
11
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
12
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
13
TRIP_LANDING_CENTER
VARCHAR2
60
No
No
Active
Specific place where the Trip landed the catch (Port for Puerto Rico)
VARCHAR2
14
TRIP_HELPERS_NUM
NUMBER
22
No
No
38
0
Active
Number of helpers (excluding partners) on the trip
NUMBER
15
USVI_ISLAND_CD
CHAR
1
No
No
Active
Identifies which island for USVI catch reports..C) St. Croix.T) St. Thomas.J) St. John
CHAR
16
IS_SPLIT_CATCH
NUMBER
22
No
No
38
0
Active
Did other Permit Holders Split Catch 0 No, 1 Yes
NUMBER
17
TOTAL_TRIP_POUNDS
NUMBER
22
No
No
Active
Total trip pounds
NUMBER
18
TOTAL_TRAPS_IN_WATER
NUMBER
22
No
No
38
Active
Total # of Traps in water
NUMBER
19
IS_INCOMPLETE
NUMBER
22
No
No
1
0
Active
Flag to indicate if the logbook was saved as incomplete.
NUMBER
20
TRIP_TRAPS_DAYS_SOAKED
NUMBER
22
No
No
6
0
Active
Number Of days that the gear was in the water
NUMBER
21
CREATED_DT
DATE
7
No
No
Active
Date when the record was originally created
DATE
22
CREATED_BY_USER_ID
NUMBER
22
No
No
Active
User who created the record
NUMBER
23
LOGBOOK_RECEIVED_DT
DATE
7
No
No
Active
Date the logbook was received at the office
DATE
gov.noaa.nmfs.inport:28557
Joshua Bennett
2015-11-05T16:10:54
SysAdmin InPortAdmin
2022-08-09T17:11:13
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