28560 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