Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: FVTR_SPECIES_ITIS
Short Name: FVTR_SPECIES_ITIS
Status: Completed
Abstract:

Species listing for all species available in the FVTR and VERS schemas.

Notes:

Loaded by batch 9209, 08-23-2016 08:38

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: FVTR
Description:

Species listing for all species available in the FVTR and VERS schemas.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key SPECIES_ITIS VARCHAR2 The Integrated Taxonomic Information System (ITIS) serial number for a species.
100
COMMON_NAME VARCHAR2 Vernacular name of the species.
100
SCIENTIFIC_NAME VARCHAR2 Genus and species.

Attribute Details

SPECIES_ITIS

CC ID: 345439
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 11
Required: Yes
Primary Key: Yes
Status: Active
Description:

The Integrated Taxonomic Information System (ITIS) serial number for a species.

General Data Type: VARCHAR2

COMMON_NAME

CC ID: 345440
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

Vernacular name of the species.

General Data Type: VARCHAR2

SCIENTIFIC_NAME

CC ID: 345441
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Genus and species.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 34396
GUID: gov.noaa.nmfs.inport:34396
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-08-23 08:38+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-08-23
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-08-23
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-08-23