Table: PR_SPECIES_ERDMAN_ITIS_XREF
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:29956 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | Table: PR_SPECIES_ERDMAN_ITIS_XREF |
---|---|
Short Name: | PR_SPECIES_ERDMAN_ITIS_XREF |
Status: | Completed |
Abstract: |
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. |
Notes: |
Loaded by batch 7906, 12-22-2015 14:11 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | ALS |
Description: |
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. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
ERDMAN_CODE | VARCHAR2 | This is the primary index based on species coding (Erdman 1987). | |
100
|
ERDMAN_COMMON_NAME | VARCHAR2 | The species or species group common name (Erdman 1987) | |
100
|
ERDMAN_SCIENTIFIC_NAME | VARCHAR2 | The species or species group scientific name (Erdman 1987). | |
100
|
SPECIES_ITIS | VARCHAR2 | The International Taxonomic Information System (ITIS) code for the species or species group. This is the standard code. | |
100
|
ITIS_COMMON_NAME | VARCHAR2 | The ITIS common name for the species or species group. This is the standard common name. | |
100
|
ITIS_SCIENTIFIC_NAME | VARCHAR2 | The scientific name for species or species group. | |
100
|
GENUS_ITIS | VARCHAR2 | The standard ITIS code for the genus. Is null if species group classed higher than genus. | |
100
|
GENUS_NAME | VARCHAR2 | The scientific name for the genus. Is null if initial species group classed higher than genus. | |
100
|
FAMILY_ITIS | VARCHAR2 | The standard ITIS code for family. Is null if initial species group is classed higher than family | |
100
|
FAMILY_NAME | VARCHAR2 | The scientific name for the family. Is null if species group initially classed higher than family. | |
100
|
ORDER_ITIS | VARCHAR2 | The standard ITIS code for order. Is null if species or species group initally classed higher than order. | |
100
|
ORDER_NAME | VARCHAR2 | The scientific name for the order. Is null if species group initially classed higher than order. | |
100
|
NMFS_CODE | VARCHAR2 | 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. | |
100
|
NMFS_COMMON_NAME | VARCHAR2 | The NMFS common name for the species or species group. | |
100
|
FMU | VARCHAR2 | The Caribbean Fishery Management Unit for the species or species group. | |
100
|
FAMILY | VARCHAR2 | The common family name for species or species group. | |
100
|
T_LEVEL | VARCHAR2 | The first initial for the taxonomic level of the species or species group. | |
100
|
ACL_UNIT | VARCHAR2 | The current ACL (Allowable Catch Level) unit for the species or species group. | |
100
|
ACL_YEAR | VARCHAR2 | The year that the ACL was established. | |
100
|
SERO_SAS_COMMON_NAME | VARCHAR2 | The common name for the species or species goup as extracted by the NOAA-SERO. | |
100
|
SERO_SAS_ACL_UNIT | VARCHAR2 | The name for the original NOAA-SERO ACL Unit for the species or species group. | |
100
|
FISHERY_TYPE | VARCHAR2 | The general fishery type for the species or species group. |
Attribute Details
ERDMAN_CODE
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
This is the primary index based on species coding (Erdman 1987). |
General Data Type: | VARCHAR2 |
ERDMAN_COMMON_NAME
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The species or species group common name (Erdman 1987) |
General Data Type: | VARCHAR2 |
ERDMAN_SCIENTIFIC_NAME
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 28 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The species or species group scientific name (Erdman 1987). |
General Data Type: | VARCHAR2 |
SPECIES_ITIS
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The International Taxonomic Information System (ITIS) code for the species or species group. This is the standard code. |
General Data Type: | VARCHAR2 |
ITIS_COMMON_NAME
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 28 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The ITIS common name for the species or species group. This is the standard common name. |
General Data Type: | VARCHAR2 |
ITIS_SCIENTIFIC_NAME
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 28 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The scientific name for species or species group. |
General Data Type: | VARCHAR2 |
GENUS_ITIS
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The standard ITIS code for the genus. Is null if species group classed higher than genus. |
General Data Type: | VARCHAR2 |
GENUS_NAME
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 17 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The scientific name for the genus. Is null if initial species group classed higher than genus. |
General Data Type: | VARCHAR2 |
FAMILY_ITIS
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The standard ITIS code for family. Is null if initial species group is classed higher than family |
General Data Type: | VARCHAR2 |
FAMILY_NAME
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 18 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The scientific name for the family. Is null if species group initially classed higher than family. |
General Data Type: | VARCHAR2 |
ORDER_ITIS
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The standard ITIS code for order. Is null if species or species group initally classed higher than order. |
General Data Type: | VARCHAR2 |
ORDER_NAME
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 18 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The scientific name for the order. Is null if species group initially classed higher than order. |
General Data Type: | VARCHAR2 |
NMFS_CODE
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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. |
General Data Type: | VARCHAR2 |
NMFS_COMMON_NAME
Seq. Order: | 14 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 33 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The NMFS common name for the species or species group. |
General Data Type: | VARCHAR2 |
FMU
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 14 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The Caribbean Fishery Management Unit for the species or species group. |
General Data Type: | VARCHAR2 |
FAMILY
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The common family name for species or species group. |
General Data Type: | VARCHAR2 |
T_LEVEL
Seq. Order: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The first initial for the taxonomic level of the species or species group. |
General Data Type: | VARCHAR2 |
ACL_UNIT
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 28 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The current ACL (Allowable Catch Level) unit for the species or species group. |
General Data Type: | VARCHAR2 |
ACL_YEAR
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The year that the ACL was established. |
General Data Type: | VARCHAR2 |
SERO_SAS_COMMON_NAME
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 26 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The common name for the species or species goup as extracted by the NOAA-SERO. |
General Data Type: | VARCHAR2 |
SERO_SAS_ACL_UNIT
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The name for the original NOAA-SERO ACL Unit for the species or species group. |
General Data Type: | VARCHAR2 |
FISHERY_TYPE
Seq. Order: | 22 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 24 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The general fishery type for the species or species group. |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 29956 |
---|---|
GUID: | gov.noaa.nmfs.inport:29956 |
Metadata Record Created By: | Joshua Bennett |
Metadata Record Created: | 2015-12-22 14:11+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2021-05-06 |
Owner Org: | SEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2021-05-06 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2022-05-06 |