Slide Menu
Search Help Show/Hide Menu

Item Identification

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

SEFSC.STATE_CODE_NMFS gives a list of the valid NMFS State Codes.

Purpose:

Table Of Valid NMFS State Codes

Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None State Codes

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None States

Physical Location

Organization: Southeast Fisheries Science Center
City: Miami
State/Province: FL
Country: USA

Entity Information

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

SEFSC.STATE_CODE_NMFS gives a list of the validNMFS State Codes.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key NMFSSTATE VARCHAR2 2 character NMFS State Code
100
STATENAME VARCHAR2 State Name
100
STATEABREV VARCHAR2 State Abbreviation
100
ALSSTATE VARCHAR2 State Code In Accumulative Landings System
100
ALSLDCODE VARCHAR2 Code That will be put in the whichone column in the ALS System

Attribute Details

NMFSSTATE

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

2 character NMFS State Code

General Data Type: VARCHAR2

STATENAME

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

State Name

General Data Type: VARCHAR2

STATEABREV

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

State Abbreviation

General Data Type: VARCHAR2

ALSSTATE

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

State Code In Accumulative Landings System

General Data Type: VARCHAR2

ALSLDCODE

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

Code That will be put in the whichone column in the ALS System

General Data Type: VARCHAR2

Access Information

Security Class: Unclassified
Data Use Constraints:

None

Metadata Use Constraints:

None

Catalog Details

Catalog Item ID: 6432
GUID: gov.noaa.nmfs.inport:6432
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-11-09 10:56+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 Review Frequency: 1 Year