Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Table Of Valid Species Codes For Louisiana

Notes:

Loaded by batch 1924, 11-09-2007 10:56

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Cross Tables
None Species Codes

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None Lousiana

Entity Information

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

Table Of Valid Species Codes For Louisiana

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key LA_CODE VARCHAR2 Louisiana Species Code
100
NODC_CODE VARCHAR2 NODC Code
100
COMMON_NAME VARCHAR2 Comment Name
100
SCIENTIFIC_NAME VARCHAR2 Scientific Name

Attribute Details

LA_CODE

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

Louisiana Species Code

General Data Type: VARCHAR2

NODC_CODE

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

NODC Code

General Data Type: VARCHAR2
Validation Rules:

Must be found in Standard NODC Species Code Table

COMMON_NAME

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

Comment Name

General Data Type: VARCHAR2

SCIENTIFIC_NAME

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

Scientific Name

General Data Type: VARCHAR2

Access Information

Security Class: Unclassified
Data Use Constraints:

None

Metadata Use Constraints:

None

Catalog Details

Catalog Item ID: 6428
GUID: gov.noaa.nmfs.inport:6428
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-11-09 10:56+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:10+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