Slide Menu
System Maintenance Notice, Sunday, January 23, 2022 @ 8am-2pm Eastern. The Operations Team will be performing system maintenance on all server environments. During this scheduled downtime, InPort will not be available.
View All
Search Help Show/Hide Menu

Item Identification

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

Table Listing Species By Fisheries Management Unit

Notes:

Loaded by batch 2103, 02-28-2008 14:10

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Fisheries Management Unit
None FMU
None Species

Entity Information

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

Table Listing Species By Fisheries Management Unit

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key SPECIES_BY_FMU_KEY NUMBER Unique identifer.
100
FISHERIES_MANAGEMENT_UNIT VARCHAR2 Code that identifies the Fisheries Management Plan for each species.
100
SPECIES_CODE_NMFS VARCHAR2 Four digit NMFS code that identifies each species.

Attribute Details

SPECIES_BY_FMU_KEY

CC ID: 27342
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 10
Scale: 0
Status: Active
Description:

Unique identifer.

General Data Type: NUMBER

FISHERIES_MANAGEMENT_UNIT

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

Code that identifies the Fisheries Management Plan for each species.

General Data Type: VARCHAR2

SPECIES_CODE_NMFS

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

Four digit NMFS code that identifies each species.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7168
GUID: gov.noaa.nmfs.inport:7168
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-02-28 14:10+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07