Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Fisheries Statistics Division > FISHERIES MONITORING > Commercial Catch and Effort > Commercial Landings Project > Commercial Fisheries Landings for U.S. Caribbea... > U.S. Virgin Islands Commercial Landings Statist... >

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 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

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.

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.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
VI_SCIENTIFIC_NAME
VARCHAR2 		Scientific name of USVI species or species group
VI_COMMON_NAME
VARCHAR2 		Common name of USVI species or species group. Primary Key.
SPECIES_ITIS
VARCHAR2 		The International Taxonomic Information System (ITIS) code for the species or species group. This is the standard code.
ITIS_COMMON_NAME
VARCHAR2 		The ITIS common name for the species or species group. This is the standard common name.
ITIS_SCIENTIFIC_NAME
VARCHAR2 		The scientific name for species or species group.
GENUS_ITIS
VARCHAR2 		The standard ITIS code for the genus. Is null if species group classed higher than genus.
GENUS_NAME
VARCHAR2 		The scientific name for the genus. Is null if initial species group classed higher than genus.
FAMILY_ITIS
VARCHAR2 		The standard ITIS code for family. Is null if initial species group is classed higher than family.
FAMILY_NAME
VARCHAR2 		The scientific name for the family. Is null if species group initially classed higher than family.
ORDER_ITIS
VARCHAR2 		The standard ITIS code for order. Is null if species or species group initally classed higher than order.
ORDER_NAME
VARCHAR2 		The scientific name for the order. Is null if species group initially classed higher than order.
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.
NMFS_COMMON_NAME
VARCHAR2 		The NMFS common name for the species or species group.
FMU
VARCHAR2 		The Caribbean Fishery Management Unit for the species or species group.
FAMILY
VARCHAR2 		The common family name for species or species group.
T_LEVEL
VARCHAR2 		The first initial for the taxonomic level of the species or species group.
ACL_UNIT
VARCHAR2 		The current ACL (Allowable Catch Level) unit for the species or species group.
SERO_SAS_COMMON_NAME_2010
VARCHAR2 		Common name of unit described in 2010
SERO_SAS_COMMON_NAME_2011
VARCHAR2 		Common name of unit desribed in 2011
SERO_SAS_ACL_UNIT
VARCHAR2 		Common name of ACL Unit

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

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

Rubric Score Primary Key? 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

CC ID: 267339
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

CC ID: 267350
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

CC ID: 267352
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

CC ID: 267353
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

CC ID: 267354
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

CC ID: 267355
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

CC ID: 267356
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

CC ID: 267357
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

CC ID: 267358
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

CC ID: 267340
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

CC ID: 267341
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

CC ID: 267342
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

CC ID: 267343
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

CC ID: 267344
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

CC ID: 267345
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

CC ID: 267346
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

CC ID: 267347
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

CC ID: 267348
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

CC ID: 267349
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

CC ID: 267351
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