28563
Table: TRIP_GEAR_NET_DETAIL
TRIP_GEAR_NET_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 Net, this table stores addition details about the Gear such as Length of net or Hours soaked.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
When the Gear used on a Fishing Trip is Net, this table stores addition details about the Gear such as Length of net or Hours 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 NET gear used used on the Fishing Trip.
NUMBER
CCL.TRIP_GEAR_TYPE
2
LENGTH
NUMBER
22
No
No
38
0
Active
Length of the net in length_uom (Fathoms/Feet)
NUMBER
3
MESH_IN
NUMBER
22
No
No
5
2
Active
Mesh size of the net in inches.
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
NET_CNT
NUMBER
22
No
No
5
2
Active
Net count
NUMBER
7
LENGTH_UOM
VARCHAR2
30
No
No
Active
Net length unit of measure
VARCHAR2
8
CREATED_DT
DATE
7
No
No
Active
Control column giving timestamp of records creation
DATE
9
CREATED_BY_USER_ID
NUMBER
22
No
No
38
Active
Control column giving oracle usercode of records creater
NUMBER
gov.noaa.nmfs.inport:28563
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