28539
Table: FILTER
FILTER
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 to support filtering species by gears or species by class (such as palagico). The table consolidates the two types of Filters into one table.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
A table to support filtering species by gears or species by class (such as palagico). The table consolidates the two types of Filters into one table.
1
FILTER_ID
NUMBER
22
Yes
Yes
Active
Primary key for this Table. Used to join GEAR_LIST with SPECIES_FILTER or SPECIES_CLASS_LIST with SPECIES_FILTER. The join is convereted to Filter ID so the Species Filter table can support both kinds of filters.
NUMBER
2
SPECIES_CLASS_CD
VARCHAR2
30
No
No
Active
The table supports filtering Species by Gear or Class. This field is used when filtering by SPECIES_CLASS_CD.
VARCHAR2
CCL.SPECIES_CLASS_LIST
3
GEAR_TYPE_CD
VARCHAR2
30
No
No
Active
The table supports filtering Species by Gear or Class. This field is used when filtering by GEAR_CD.
VARCHAR2
CCL.GEAR_TYPE_LIST
4
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
5
LU_USER_ID
NUMBER
22
Yes
No
Active
Last update user.
NUMBER
6
FORM_TEMPLATE_CD
VARCHAR2
30
No
No
Active
FK to form template list, if the species code or gear code is present in the form template
VARCHAR2
CCL.FORM_TEMPLATE_LIST
7
FILTER_NM
VARCHAR2
60
No
No
Active
Unique Name for a filter. .
VARCHAR2
8
FILTER_DESC
VARCHAR2
250
No
No
Active
Description of a filter.
VARCHAR2
gov.noaa.nmfs.inport:28539
Joshua Bennett
2015-11-05T16:10:53
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