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

Summary

Abstract

Table That takes a name or abbreviation and converts it to a standard abbreviation

Description

Table That takes a name or abbreviation and converts it to a standard abbreviation

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
NAME
VARCHAR2
STREET DESIGNATOR, PREFIX OR SUFFIX FULLNAME OR VARIANT
ABBRV
VARCHAR2
DMS ABBREVIATION

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

Table That takes a name or abbreviation and converts it to a standard abbreviation

Notes:

Loaded by batch 2163, 03-26-2008 16:04

Entity Information

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

Table That takes a name or abbreviation and converts it to a standard abbreviation

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key NAME VARCHAR2 STREET DESIGNATOR, PREFIX OR SUFFIX FULLNAME OR VARIANT
100
ABBRV VARCHAR2 DMS ABBREVIATION

Attribute Details

NAME

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

STREET DESIGNATOR, PREFIX OR SUFFIX FULLNAME OR VARIANT

General Data Type: VARCHAR2

ABBRV

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

DMS ABBREVIATION

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7294
GUID: gov.noaa.nmfs.inport:7294
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-03-26 16:04+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