28565
Table: TRIP_GEAR_TRAP_DETAIL
TRIP_GEAR_TRAP_DETAIL
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
When the Gear used on a Fishing Trip is Trap, this table stores addition details about the Gear such as number of traps or how long the traps soaked.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
When the Gear used on a Fishing Trip is Trap, this table stores addition details about the Gear such as number of traps or how long the traps soaked.
1
TRIP_GEAR_TYPE_ID
NUMBER
22
Yes
Yes
Active
Foreighn/Primary key for this table. This table stores addition information specific to the TRAP gear used used on the Fishing Trip.
NUMBER
CCL.TRIP_GEAR_TYPE
2
LOBSTER_TRAPS_HAULED
NUMBER
22
No
No
38
0
Active
The count of lobster traps hauled on the fishing trip.
NUMBER
3
FISH_TRAPS_HAULED
NUMBER
22
No
No
3
0
Active
The count of fish traps hauled on the fishing trip.
NUMBER
4
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
5
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
6
FISH_TRAPS_HOURS_SOAKED
NUMBER
22
No
No
6
2
Active
Soak time for Fish Traps in hours -- hours fished in trip_gear_type are is for lobster time in hours
NUMBER
7
LOBSTER_TRAPS_DAYS_SOAKED
NUMBER
22
No
No
6
2
Active
Soak time for Lobster Traps in days
NUMBER
8
FISH_TRAPS_DAYS_SOAKED
NUMBER
22
No
No
6
2
Active
Soak time for Fish Traps in days
NUMBER
9
CREATED_DT
DATE
7
No
No
Active
Time stamp of the creationof the record
DATE
10
CREATED_BY_USER_ID
NUMBER
22
No
No
38
Active
Controp column giving oracle userid of the creator of this record
NUMBER
gov.noaa.nmfs.inport:28565
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