Slide Menu
Search Help Show/Hide Menu

Item Identification

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

NMFS Species Code Table, WIth Size Code , Condition Code, Grade, Maturoty and Sex In The Table

Notes:

Loaded by batch 2005, 12-03-2007 10:12

Entity Information

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

NMFS Species Code Table, WIth Size Code , Condition Code, Grade, Maturoty and Sex In The Table

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
NMFS_CODE VARCHAR2 Four Digit NMFS Species Code
100
COMMON_NAME VARCHAR2 Common Name
100
SIZE_CODE VARCHAR2 Size Description/Code
100
CONDITION VARCHAR2 Condition Description
100
GRADE VARCHAR2 Grade Description
100
SEX VARCHAR2 Description Of Sex of Animal
100
MATURITY VARCHAR2 Maturity State Of Animal

Attribute Details

NMFS_CODE

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

Four Digit NMFS Species Code

General Data Type: VARCHAR2

COMMON_NAME

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

Common Name

General Data Type: VARCHAR2

SIZE_CODE

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

Size Description/Code

General Data Type: VARCHAR2

CONDITION

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

Condition Description

General Data Type: VARCHAR2

GRADE

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

Grade Description

General Data Type: VARCHAR2

SEX

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

Description Of Sex of Animal

General Data Type: VARCHAR2

MATURITY

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

Maturity State Of Animal

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 6592
GUID: gov.noaa.nmfs.inport:6592
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-12-03 10:12+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-11-04 13:14+0000
Metadata Record Published: 2021-11-04
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-11-05