28560
Table: TRIP_DISCARD
TRIP_DISCARD
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
Records the count of fish/lobsters discarded during a fishing trip.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
Records the count of fish/lobsters discarded during a fishing trip.
1
TRIP_DISCARD_ID
NUMBER
22
Yes
Yes
38
Active
Primary key for this table.
NUMBER
2
TRIP_ID
NUMBER
22
Yes
No
Active
FK to Trip.
NUMBER
CCL.TRIP
3
TRIP_GEAR_TYPE_ID
NUMBER
22
No
No
38
Active
FK to optional gear type.
NUMBER
CCL.TRIP_GEAR_TYPE
4
FISH_LIVE_CNT
NUMBER
22
No
No
4
0
Active
The number (count) of live fish discarded during the trip, regardless of species.
NUMBER
5
FISH_DEAD_CNT
NUMBER
22
No
No
4
0
Active
The number (count) of dead fish discarded during the trip, regardless of species.
NUMBER
6
LOBSTER_LIVE_CNT
NUMBER
22
No
No
4
0
Active
The number (count) of live lobster discarded during the trip.
NUMBER
7
LOBSTER_DEAD_CNT
NUMBER
22
No
No
4
0
Active
The number (count) of dead lobster discarded during the trip.
NUMBER
8
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
9
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
10
OTHER_CNT
NUMBER
22
No
No
38
Active
The number (count) of unspecified species discard ed during the trip.
NUMBER
11
CREATED_DT
DATE
7
No
No
Active
Control column giving timestamp of records creation
DATE
12
CREATED_BY_USER_ID
NUMBER
22
No
No
Active
NUMBER
gov.noaa.nmfs.inport:28560
Joshua Bennett
2015-11-05T16:10:55
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