Search Help Show/Hide Menu
Summary
Item Identification
Keywords
Physical Location
Entity Info
Data Attributes
Support Roles
Catalog Details

Summary

Abstract

Code Table to validate Area Codes and Sub Area Codes

Description

Code Table to validate Area Codes and Sub Area Codes

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
AREA_CODE
VARCHAR2
Area Code
SUBAREA_CODE
VARCHAR2
Sub ARea Code
DESCRIPTION
VARCHAR2
Description Of Codes

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

Code Table to validate Area Codes and Sub Area Codes

Notes:

Loaded by batch 1743, 10-17-2007 04:25

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None area codes
None code tables

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

Code Table to validate Area Codes and Sub Area Codes

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
AREA_CODE VARCHAR2 Area Code
100
SUBAREA_CODE VARCHAR2 Sub ARea Code
100
DESCRIPTION VARCHAR2 Description Of Codes

Attribute Details

AREA_CODE

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

Area Code

General Data Type: VARCHAR2

SUBAREA_CODE

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

Sub ARea Code

General Data Type: VARCHAR2

DESCRIPTION

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

Description Of Codes

General Data Type: VARCHAR2

Support Roles

Point of Contact

CC ID: 182681
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: 5485
GUID: gov.noaa.nmfs.inport:5485
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