28539 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