Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Table Of Valid State Codes

Description

Table Of Valid State Codes

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
STATE_ID
VARCHAR2
Mnemonic state code.
STATE_NAME
VARCHAR2
The state name.

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: CTS_STATES
Short Name: CTS_STATES
Status: Completed
Abstract:

Table Of Valid State Codes

Notes:

Loaded by batch 2083, 02-22-2008 12:10

Entity Information

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

Table Of Valid State Codes

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key STATE_ID VARCHAR2 Mnemonic state code.
100
STATE_NAME VARCHAR2 The state name.

Attribute Details

STATE_ID

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

Mnemonic state code.

General Data Type: VARCHAR2

STATE_NAME

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

The state name.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7083
GUID: gov.noaa.nmfs.inport:7083
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-02-22 12:11+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-05
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-05
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-05