Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Sustainable Fisheries > Highly Migratory Species Branch > Recreational Billfish Survey > Recreational Billfish Survey (RBS) >

Table: SPECIES

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:6252  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Keywords
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Table Of Valid Species Codes

Description

Table Of Valid Species Codes

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
SPECIES_ID
VARCHAR2 		Mnemonic Name For FIsh
SPECIES_NUMBER
NUMBER 		NODC Code
COMMON_NAME
VARCHAR2 		Common Name
SCIENTIFIC_NAME
VARCHAR2 		Scientific Name
BIOLOGICAL_GROUP
VARCHAR2 		Group For Totaling and/or Reporting

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: SPECIES
Short Name: SPECIES
Status: Completed
Abstract:

Table Of Valid Species Codes
Notes:

Loaded by batch 1863, 11-02-2007 09:24

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Species Codes

Entity Information

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

Table Of Valid Species Codes

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 SPECIES_ID VARCHAR2 Mnemonic Name For FIsh
100
 SPECIES_NUMBER NUMBER NODC Code
100
 COMMON_NAME VARCHAR2 Common Name
100
 SCIENTIFIC_NAME VARCHAR2 Scientific Name
100
 BIOLOGICAL_GROUP VARCHAR2 Group For Totaling and/or Reporting

Attribute Details

SPECIES_ID

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

Mnemonic Name For FIsh
General Data Type: VARCHAR2

SPECIES_NUMBER

CC ID: 20707
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

NODC Code
General Data Type: NUMBER

COMMON_NAME

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

Common Name
General Data Type: VARCHAR2

SCIENTIFIC_NAME

CC ID: 20709
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Scientific Name
General Data Type: VARCHAR2

BIOLOGICAL_GROUP

CC ID: 20710
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Group For Totaling and/or Reporting
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 6252
GUID: gov.noaa.nmfs.inport:6252
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-11-02 09:24+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-05
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-05
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-05