Slide Menu
Search Help Show/Hide Menu

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: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07