29956
Table: PR_SPECIES_ERDMAN_ITIS_XREF
PR_SPECIES_ERDMAN_ITIS_XREF
Entity
Published / External
1919
Puerto Rico Commercial Landings Statistics 1983 and more recent in Accumulated Landings System (ALS) Compatible Format
Data Set
Completed
This is the primary species or species group lookup table for Puerto Rico commercial landings data. It uses the code developed by Erdman (1987) as its primary key. Table cross-reference ITIS coding at various taxonomic levels as well as NMFS coding and Caribbean ACL Unit.
Loaded by batch 7906, 12-22-2015 14:11
Data Table
Yes
ALS
This is the primary species or species group lookup table for Puerto Rico commercial landings data. It uses the code developed by Erdman (1987) as its primary key. Table cross-reference ITIS coding at various taxonomic levels as well as NMFS coding and Caribbean ACL Unit.
1
ERDMAN_CODE
VARCHAR2
3
No
No
Active
This is the primary index based on species coding (Erdman 1987).
VARCHAR2
2
ERDMAN_COMMON_NAME
VARCHAR2
22
No
No
Active
The species or species group common name (Erdman 1987)
VARCHAR2
3
ERDMAN_SCIENTIFIC_NAME
VARCHAR2
28
No
No
Active
The species or species group scientific name (Erdman 1987).
VARCHAR2
4
SPECIES_ITIS
VARCHAR2
6
No
No
Active
The International Taxonomic Information System (ITIS) code for the species or species group. This is the standard code.
VARCHAR2
5
ITIS_COMMON_NAME
VARCHAR2
28
No
No
Active
The ITIS common name for the species or species group. This is the standard common name.
VARCHAR2
6
ITIS_SCIENTIFIC_NAME
VARCHAR2
28
No
No
Active
The scientific name for species or species group.
VARCHAR2
7
GENUS_ITIS
VARCHAR2
6
No
No
Active
The standard ITIS code for the genus. Is null if species group classed higher than genus.
VARCHAR2
8
GENUS_NAME
VARCHAR2
17
No
No
Active
The scientific name for the genus. Is null if initial species group classed higher than genus.
VARCHAR2
9
FAMILY_ITIS
VARCHAR2
6
No
No
Active
The standard ITIS code for family. Is null if initial species group is classed higher than family
VARCHAR2
10
FAMILY_NAME
VARCHAR2
18
No
No
Active
The scientific name for the family. Is null if species group initially classed higher than family.
VARCHAR2
11
ORDER_ITIS
VARCHAR2
6
No
No
Active
The standard ITIS code for order. Is null if species or species group initally classed higher than order.
VARCHAR2
12
ORDER_NAME
VARCHAR2
18
No
No
Active
The scientific name for the order. Is null if species group initially classed higher than order.
VARCHAR2
13
NMFS_CODE
VARCHAR2
4
No
No
Active
The National Marine Fisheries (NMFS) code for the species or species group. The NMFS codes are replaced by the ITIS system as the coding standard for NOAA.
VARCHAR2
14
NMFS_COMMON_NAME
VARCHAR2
33
No
No
Active
The NMFS common name for the species or species group.
VARCHAR2
15
FMU
VARCHAR2
14
No
No
Active
The Caribbean Fishery Management Unit for the species or species group.
VARCHAR2
16
FAMILY
VARCHAR2
20
No
No
Active
The common family name for species or species group.
VARCHAR2
17
T_LEVEL
VARCHAR2
1
No
No
Active
The first initial for the taxonomic level of the species or species group.
VARCHAR2
18
ACL_UNIT
VARCHAR2
28
No
No
Active
The current ACL (Allowable Catch Level) unit for the species or species group.
VARCHAR2
19
ACL_YEAR
VARCHAR2
4
No
No
Active
The year that the ACL was established.
VARCHAR2
20
SERO_SAS_COMMON_NAME
VARCHAR2
26
No
No
Active
The common name for the species or species goup as extracted by the NOAA-SERO.
VARCHAR2
21
SERO_SAS_ACL_UNIT
VARCHAR2
20
No
No
Active
The name for the original NOAA-SERO ACL Unit for the species or species group.
VARCHAR2
22
FISHERY_TYPE
VARCHAR2
24
No
No
Active
The general fishery type for the species or species group.
VARCHAR2
gov.noaa.nmfs.inport:29956
Joshua Bennett
2015-12-22T14:11:37
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