28567
Table: TRIP_GEAR_TYPE_GEAR
TRIP_GEAR_TYPE_GEAR
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 which gears of the type identified for the trip were used. The USVI logbook paper form allows more than one gear to be recorded for a catch. Such as, "These species were caught using these kinds of Nets." Exmaple: Net - Gill AND Seine.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
Records which gears of the type identified for the trip were used. The USVI logbook paper form allows more than one gear to be recorded for a catch. Such as, "These species were caught using these kinds of Nets." Exmaple: Net - Gill AND Seine.
1
TRIP_GEAR_TYPE_GEAR_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_TYPE. Indetified the type of gear used on the fishing trip while catching the TRIP_CATCH species.
NUMBER
CCL.TRIP_GEAR_TYPE
3
GEAR_CD
VARCHAR2
30
Yes
No
Active
FK to TRIP_GEAR_TYPE. Indetified the type of gear used on the fishing trip while catching the TRIP_CATCH species.
VARCHAR2
CCL.GEAR_LIST
4
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
5
LU_USER_ID
NUMBER
22
Yes
No
Active
Control column giving oracle usercode of the last one that changed this record
NUMBER
6
CREATED_DT
DATE
7
No
No
Active
Control column giving timestamp of records creation
DATE
7
CREATED_BY_USER_ID
NUMBER
22
No
No
38
Active
Control column giving oracle usercode of records creater
NUMBER
gov.noaa.nmfs.inport:28567
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