28535
Table: DIALECT_SPECIES_CLASS_LIST
DIALECT_SPECIES_CLASS_LIST
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
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
1
DIALECT_CD
VARCHAR2
30
Yes
Yes
Active
FK to DIALECT. Identifies the Dialect alternate name to use.
VARCHAR2
CCL.DIALECT_LIST
2
SPECIES_CLASS_CD
VARCHAR2
30
Yes
Yes
Active
FK to SPECIES_CLASS_LIST. Identifies the Species Class having an alternate dialect name.
VARCHAR2
CCL.SPECIES_CLASS_LIST
3
DIALECT_SPECIES_CLASS_NM
VARCHAR2
60
No
No
Active
The alternate dialect name.
VARCHAR2
4
SEQ
NUMBER
22
No
No
38
0
Active
The display sequence (order by). To help the online forms match the paper forms.
NUMBER
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
gov.noaa.nmfs.inport:28535
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