Slide Menu
Search Help Show/Hide Menu

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: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07