28566
Table: TRIP_GEAR_TYPE
TRIP_GEAR_TYPE
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
A table of Gear types used on a Fishing Trip. A one-to-many => TRIP to TRIP_GEAR_TYPE.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
A table of Gear types used on a Fishing Trip. A one-to-many => TRIP to TRIP_GEAR_TYPE.
1
TRIP_GEAR_TYPE_ID
NUMBER
22
Yes
Yes
Active
Primary key for this table.
NUMBER
2
TRIP_ID
NUMBER
22
Yes
No
38
Active
FK to TRIP. Identifies the Trip which used these Trip Gears.
NUMBER
CCL.TRIP
3
GEAR_TYPE_CD
VARCHAR2
30
No
No
Active
FK to GEAR_TYPE_LIST. The type of gear used on the fishing trip, such as Net or Trap. Both catch reports record the type of gear used on a fishing trip, in addition to the specific gear within the type. However, multiple gears can be identified so they are stored in a seperate table. Example: Net - Seine and Gill.
VARCHAR2
CCL.GEAR_TYPE_LIST
4
HOURS_FISHED
NUMBER
22
No
No
38
2
Active
The amount of hours the Fisher fished on a Trip OR how long the Traps soaked between hauls recorded in hours.
NUMBER
5
DEPTH
NUMBER
22
No
No
8
2
Active
Fishing gear depth
NUMBER
6
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
7
LU_USER_ID
NUMBER
22
Yes
No
38
Active
Last update user.
NUMBER
8
GEAR_QTY_SIZE
NUMBER
22
No
No
8
2
Active
Stores a number which represents the gear size or quantity. The value is understood depending on the gear used. (the paper for has no unit of measure)
NUMBER
9
DEPTH_UOM
VARCHAR2
30
No
No
Active
Unit of Measure for Depth Choices Fathoms and Feet
VARCHAR2
10
SPECIES_CLASS_CD
VARCHAR2
30
No
No
Active
Species class is used here to identify the user chosen species class when filling out the logbook/catch report forms. When OTHER species are recorded, the user interface stores the species class chosen by the user (whether it is correct or not). This value will also allow the UI to redraw the values where they were entered when editing a logbook/catch report.
VARCHAR2
CCL.SPECIES_CLASS_LIST
11
CREATED_DT
DATE
7
No
No
Active
Control column giving timestamp of records creation
DATE
12
CREATED_BY_USER_ID
NUMBER
22
No
No
38
Active
Control column giving oracle usercode of records creater
NUMBER
gov.noaa.nmfs.inport:28566
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