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

Summary

Abstract

Table Of Valid subarea codes

Description

Table Of Valid subarea codes

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
SUBAREA_ID
VARCHAR2
Menmonic Subarea Code
SUBAREA_DESCRIPTION
VARCHAR2
Subarea Description
SUBAREA_COUNTRY
VARCHAR2
Country Code Associated WIth Subarea
SUBAREA_STATE
VARCHAR2
State Code Associated WIth Subarea

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

Table Of Valid subarea 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 subarea codes

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
SUBAREA_ID VARCHAR2 Menmonic Subarea Code
100
SUBAREA_DESCRIPTION VARCHAR2 Subarea Description
100
SUBAREA_COUNTRY VARCHAR2 Country Code Associated WIth Subarea
100
SUBAREA_STATE VARCHAR2 State Code Associated WIth Subarea

Attribute Details

SUBAREA_ID

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

Menmonic Subarea Code

General Data Type: VARCHAR2

SUBAREA_DESCRIPTION

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

Subarea Description

General Data Type: VARCHAR2

SUBAREA_COUNTRY

CC ID: 26313
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Country Code Associated WIth Subarea

General Data Type: VARCHAR2

SUBAREA_STATE

CC ID: 26314
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

State Code Associated WIth Subarea

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7085
GUID: gov.noaa.nmfs.inport:7085
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