Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Fisheries Statistics Division > FISHERIES MONITORING > Commercial Catch and Effort > Dock Interviews and Samples > South Atlantic Shrimp System > South Atlantic Shrimp System >

Table: STATE_CODE_NMFS

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:5505  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Keywords
Physical Location
Entity Info
Data Attributes
Support Roles
Catalog Details

Summary

Abstract

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

Description

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

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
NMFSSTATE
VARCHAR2 		2 character NMFS State Code
STATENAME
VARCHAR2 		State Name
STATEABREV
VARCHAR2 		State Abbreviation
ALSSTATE
VARCHAR2 		State Code In Accumulative Landings System
ALSLDCODE
VARCHAR2 		Code That will be put in the whichone column in the ALS System

Child Items

No Child Items for this record.

Contact Information

Point of Contact
David Gloeckner
David.Gloeckner@noaa.gov
305-361-4257

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: 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