28564
Table: TRIP_GEAR_SPEAR_DETAIL
TRIP_GEAR_SPEAR_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 Spear or By Hand, this table stores addition details about the Gear such as number of Divers?
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
When the Gear used on a Fishing Trip is Spear or By Hand, this table stores addition details about the Gear such as number of Divers?
1
TRIP_GEAR_TYPE_ID
NUMBER
22
Yes
Yes
Active
Foreighn/Primary key for this table. This table stores addition information specific to the SPEAR or HAND gear used used on the Fishing Trip.
NUMBER
CCL.TRIP_GEAR_TYPE
2
DIVERS_CNT
NUMBER
22
No
No
38
0
Active
The count of divers (number of people diving) on this fishing trip.
NUMBER
3
DIVES_CNT
NUMBER
22
No
No
3
0
Active
The count of dives which took place while fishing on this 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
IS_SCUBA
NUMBER
22
No
No
1
0
Active
Check flag for scuba diving
NUMBER
7
CREATED_DT
DATE
7
No
No
Active
Control column giving timestamp of records creation
DATE
8
CREATED_BY_USER_ID
NUMBER
22
No
No
38
Active
Control column giving oracle usercode of the creater of the record
NUMBER
gov.noaa.nmfs.inport:28564
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