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 validNMFS State Codes.

Notes:

Loaded by batch 1743, 10-17-2007 04:25

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None nmfs state codes
None State Codes

Physical Location

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

Disk

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
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: 17614
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

2 character NMFS State Code

General Data Type: VARCHAR2

STATENAME

CC ID: 17613
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: 17612
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: 17611
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: 17610
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

Support Roles

Point of Contact

CC ID: 182699
Date Effective From: 2003-01-01
Date Effective To:
Contact (Person): Gloeckner, David
Address: 75 Virginia Beach Drive
Miami, FL 33139
Email Address: David.Gloeckner@noaa.gov
Phone: 305-361-4257
Fax: 305-361-4460

Catalog Details

Catalog Item ID: 5505
GUID: gov.noaa.nmfs.inport:5505
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-10-17 04:25+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