Slide Menu
Jump to Section...
Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Resource Evaluation and Assessment Division > Protected Species Branch > Specimen curation and analysis > Tissue Tracking > Tissue Tracking System >

Table: TTSPEC

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:35927  |  Updated: August 9, 2022  |  Published / External 

Item Identification

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

lookup table for species codes
Notes:

Loaded by batch 9570, 12-12-2016 13:35

Entity Information

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

lookup table for species codes

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key SPCODE VARCHAR2 4 letter species code
100
 COMNM VARCHAR2 common name
100
 SCIGENUS VARCHAR2 genus
100
 SCISPECIES VARCHAR2 species
100
 NESPP4 VARCHAR2 numeric species code

Attribute Details

SPCODE

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

4 letter species code
General Data Type: VARCHAR2

COMNM

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

common name
General Data Type: VARCHAR2

SCIGENUS

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

genus
General Data Type: VARCHAR2

SCISPECIES

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

species
General Data Type: VARCHAR2

NESPP4

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

numeric species code
General Data Type: VARCHAR2

Catalog Details

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