28558
Table: TRIP_AREA
TRIP_AREA
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 Fishing Areas associated to a Fishing Trip. May also be Fishing Areas associated to a Gear Type used on a Fishing Trip, depending on the relationship to TRIP or TRIP_GEAR_TYPE.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
A table of Fishing Areas associated to a Fishing Trip. May also be Fishing Areas associated to a Gear Type used on a Fishing Trip, depending on the relationship to TRIP or TRIP_GEAR_TYPE.
1
TRIP_AREA_ID
NUMBER
22
Yes
Yes
Active
Primary key for this table.
NUMBER
2
TRIP_ID
NUMBER
22
No
No
38
Active
TrI Area Code
NUMBER
CCL.TRIP
3
TRIP_GEAR_TYPE_ID
NUMBER
22
No
No
Active
This field is used to identify the Gear was used for a particular fishing Area of a Trip.
NUMBER
CCL.TRIP_GEAR_TYPE
4
AREA_CD
VARCHAR2
30
No
No
Active
A code identifying the area where fishing occured for a given Trip. Can be more than one fishing area.
VARCHAR2
5
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
6
LU_USER_ID
NUMBER
22
Yes
No
38
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
NUMBER
gov.noaa.nmfs.inport:28558
Joshua Bennett
2015-11-05T16:10:54
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