28555
Table: SPECIES_LIST
SPECIES_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
A unique list of Species.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
A unique list of Species.
1
SPECIES_CD
VARCHAR2
30
Yes
Yes
Active
Primary key for this table.
VARCHAR2
2
SPECIES_FAMILY_CD
VARCHAR2
30
Yes
No
Active
FK to SPECIES_FAMILY_LIST. Identify the Species Family for the Species. Multiple Species can be associated to a Species Family, such as Coney and Graysby are both Groupes.
VARCHAR2
CCL.SPECIES_FAMILY_LIST
3
ERDMANS_CD
VARCHAR2
30
No
No
Active
The 3 digit Erdmans code for the species.
VARCHAR2
4
SPECIES_NM
VARCHAR2
60
Yes
No
Active
Unique Name for a Species.
VARCHAR2
5
SPECIES_DESC
VARCHAR2
250
No
No
Active
Description of a Species.
VARCHAR2
6
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
7
LU_USER_ID
NUMBER
22
Yes
No
Active
Last update user.
NUMBER
8
IS_ENABLED
NUMBER
22
Yes
No
38
0
Active
Is the value enabled for use.
NUMBER
gov.noaa.nmfs.inport:28555
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