Account Creation Issues: We have received reports of issues with creating new user accounts and linking accounts to CAM, and are currently investigating the root cause. In the meantime: - If you're experiencing errors creating new users, please use the "Quick Add" feature instead (click the "Quick Add" button on the Manage Users page). - If you're experiencing errors linking CAM accoun...
View All
Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Fisheries Statistics Division > FISHERIES MONITORING > Commercial Catch and Effort > Commercial Landings Project > Accumulative Landings System (ALS) > Accumulative Landings System Code Tables >

Table: STATE_CODE_NMFS

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

Summary

Abstract

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

Purpose

Table Of Valid NMFS 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

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

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