Table: STATE_CODE_NMFS
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:5505 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
SEFSC.STATE_CODE_NMFS gives a list of the validNMFS State Codes.
DescriptionSEFSC.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
|
|
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
| 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
| 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
| 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
| 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
| 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
| 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 |