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 |