28559
Table: TRIP_CATCH
TRIP_CATCH
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
Table to store the Catch information by Gear for a Fishing Trip, such as the species caught and how many pounds.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
Table to store the Catch information by Gear for a Fishing Trip, such as the species caught and how many pounds.
1
TRIP_CATCH_ID
NUMBER
22
Yes
Yes
Active
Primary key for this table.
NUMBER
2
TRIP_GEAR_TYPE_ID
NUMBER
22
Yes
No
38
Active
FK to TRIP_GEAR. Identifies the Gear used to Catch the Species.
NUMBER
CCL.TRIP_GEAR_TYPE
3
SPECIES_CD
VARCHAR2
30
Yes
No
Active
FK to SPECIES_LIST. Identifies the Species caught on the Trip.
VARCHAR2
CCL.SPECIES_LIST
4
TRIP_GEAR_TYPE_GEAR_ID
NUMBER
22
No
No
38
Active
When we know the catch by gear, as apposed to knowing the catch by gear type, we record it here.
NUMBER
CCL.TRIP_GEAR_TYPE_GEAR
5
CATCH_LBS
NUMBER
22
No
No
8
2
Active
Records the pounds of fish caught for a particular Catch, Gear, and Species. In Puerto Rico the form does not specify the condition. In the USVI there is a seperate field for gutted lbs. So, for USVI this field (catch_lbs) represents whole.
NUMBER
6
PRICE_PER_LBS
NUMBER
22
No
No
5
2
Active
Records the price per lbs for the fish.
NUMBER
7
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
8
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
9
CATCH_GUTTED_LBS
NUMBER
22
No
No
8
2
Active
USVI gutted catch in pounds of fish caught for a particular Catch, Gear, and Species.
NUMBER
10
CREATED_DT
DATE
7
No
No
Active
Control column giving timestamp of records creation
DATE
11
CREATED_BY_USER_ID
NUMBER
22
No
No
38
Active
NUMBER
gov.noaa.nmfs.inport:28559
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