28562
Table: TRIP_GEAR_HOOK_LINE_DETAIL
TRIP_GEAR_HOOK_LINE_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 Hook and Line, this table stores addition details about the Gear such as Line count or Hook count.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
When the Gear used on a Fishing Trip is Hook and Line, this table stores addition details about the Gear such as Line count or Hook count.
1
TRIP_GEAR_TYPE_ID
NUMBER
22
Yes
Yes
Active
Foreighn/Primary key for this table. This table stores addition information specific to the HOOK and LINE gear used used on the Fishing Trip.
NUMBER
CCL.TRIP_GEAR_TYPE
2
LINES_CNT
NUMBER
22
No
No
38
0
Active
The number of lines used when fishing.
NUMBER
3
HOOKS_PER_LINE_CNT
NUMBER
22
No
No
3
0
Active
The number of hooks per line.
NUMBER
4
FAD_NUM
VARCHAR2
30
No
No
Active
Amn attribute of Hook and Line Gear/Fishing for USVI.
VARCHAR2
5
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
6
LU_USER_ID
NUMBER
22
Yes
No
Active
Last update user.
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 records creater
NUMBER
gov.noaa.nmfs.inport:28562
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