Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

NMFS Species Code Table

Description

NMFS Species Code Table

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
SPECIES_CODE_NMFS
VARCHAR2
Four digit NMFS species code.
COMMON_NAME
VARCHAR2
Species common name.
SCIENTIFIC_NAME
VARCHAR2
Species Scientific Name.
CREATED_BY_USER_ID
VARCHAR2
Created by whom
CREATED_DATE
DATE
Created when
MODIFIED_BY_USER_ID
VARCHAR2
Modified by whom
MODIFIED_DATE
DATE
Modified when

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

NMFS Species Code Table

Notes:

Loaded by batch 1683, 10-12-2007 05:01

Entity Information

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

NMFS Species Code Table

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key SPECIES_CODE_NMFS VARCHAR2 Four digit NMFS species code.
100
COMMON_NAME VARCHAR2 Species common name.
100
SCIENTIFIC_NAME VARCHAR2 Species Scientific Name.
100
CREATED_BY_USER_ID VARCHAR2 Created by whom
100
CREATED_DATE DATE Created when
100
MODIFIED_BY_USER_ID VARCHAR2 Modified by whom
100
MODIFIED_DATE DATE Modified when

Attribute Details

SPECIES_CODE_NMFS

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

Four digit NMFS species code.

General Data Type: VARCHAR2

COMMON_NAME

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

Species common name.

General Data Type: VARCHAR2

SCIENTIFIC_NAME

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

Species Scientific Name.

General Data Type: VARCHAR2

CREATED_BY_USER_ID

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

Created by whom

General Data Type: VARCHAR2

CREATED_DATE

CC ID: 16441
Seq. Order: 5
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Created when

General Data Type: DATE

MODIFIED_BY_USER_ID

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

Modified by whom

General Data Type: VARCHAR2

MODIFIED_DATE

CC ID: 16439
Seq. Order: 7
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Modified when

General Data Type: DATE

Catalog Details

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