Table: USVI_SPECIES_NMFS_ITIS_XREF
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:29959 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | Table: USVI_SPECIES_NMFS_ITIS_XREF |
---|---|
Short Name: | USVI_SPECIES_NMFS_ITIS_XREF |
Status: | Completed |
Abstract: |
This is the primary species or species group lookup table for USVI commercial landings data. It links to common names (vi_species) in the als_landings_usvi table. 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 USVI commercial landings data. It links to common names (vi_species) in the als_landings_usvi table. 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
|
VI_SCIENTIFIC_NAME | VARCHAR2 | Scientific name of USVI species or species group | |
100
|
VI_COMMON_NAME | VARCHAR2 | Common name of USVI species or species group. Primary Key. | |
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
|
SERO_SAS_COMMON_NAME_2010 | VARCHAR2 | Common name of unit described in 2010 | |
100
|
SERO_SAS_COMMON_NAME_2011 | VARCHAR2 | Common name of unit desribed in 2011 | |
100
|
SERO_SAS_ACL_UNIT | VARCHAR2 | Common name of ACL Unit |
Attribute Details
VI_SCIENTIFIC_NAME
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Scientific name of USVI species or species group |
General Data Type: | VARCHAR2 |
VI_COMMON_NAME
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Common name of USVI species or species group. Primary Key. |
General Data Type: | VARCHAR2 |
SPECIES_ITIS
Seq. Order: | 3 |
---|---|
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: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
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: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The scientific name for species or species group. |
General Data Type: | VARCHAR2 |
GENUS_ITIS
Seq. Order: | 6 |
---|---|
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: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
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: | 8 |
---|---|
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: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
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: | 10 |
---|---|
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: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
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: | 12 |
---|---|
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: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 40 |
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: | 14 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
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: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
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: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
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: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
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 |
SERO_SAS_COMMON_NAME_2010
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Common name of unit described in 2010 |
General Data Type: | VARCHAR2 |
SERO_SAS_COMMON_NAME_2011
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Common name of unit desribed in 2011 |
General Data Type: | VARCHAR2 |
SERO_SAS_ACL_UNIT
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Common name of ACL Unit |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 29959 |
---|---|
GUID: | gov.noaa.nmfs.inport:29959 |
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 |