Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: DMS_ADDRESSES
Short Name: DMS_ADDRESSES
Status: Completed
Abstract:

table stores current address info for dms dealers

Notes:

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

Entity Information

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

table stores current address info for dms dealers

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
DMS_KEY VARCHAR2 Main application key for uniquely identifying dealers
100
ADDRESS_TYPE VARCHAR2 'P' for physical address, 'M' for mailing, 'U' for unknown
100
ADDRESS_1 VARCHAR2 First Line of The Street Address
100
ADDRESS_2 VARCHAR2 Second Line Of Street Address (may be null)
100
ADDRESS_3 VARCHAR2 Third Line Of Street Address (may be null)
100
CITY VARCHAR2 City
100
STATE VARCHAR2 State
100
POSTAL_CODE VARCHAR2 ZIp Code
100
PORT VARCHAR2 Port of landing according to dealer location
100
NMFS_CNTY VARCHAR2 NMFS County Code Associated With The Address
100
FIPS_CNTY VARCHAR2 FIPS County Code Associated With The Address
100
NMFS_ST VARCHAR2 NMFS State Code Associated With The Address
100
FIPS_ST VARCHAR2 FIPS State Code Associated With the address

Attribute Details

DMS_KEY

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

Main application key for uniquely identifying dealers

General Data Type: VARCHAR2

ADDRESS_TYPE

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

'P' for physical address, 'M' for mailing, 'U' for unknown

General Data Type: VARCHAR2

ADDRESS_1

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

First Line of The Street Address

General Data Type: VARCHAR2

ADDRESS_2

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

Second Line Of Street Address (may be null)

General Data Type: VARCHAR2

ADDRESS_3

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

Third Line Of Street Address (may be null)

General Data Type: VARCHAR2

CITY

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

City

General Data Type: VARCHAR2

STATE

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

State

General Data Type: VARCHAR2

POSTAL_CODE

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

ZIp Code

General Data Type: VARCHAR2

PORT

CC ID: 27887
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Port of landing according to dealer location

General Data Type: VARCHAR2

NMFS_CNTY

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

NMFS County Code Associated With The Address

General Data Type: VARCHAR2

FIPS_CNTY

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

FIPS County Code Associated With The Address

General Data Type: VARCHAR2

NMFS_ST

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

NMFS State Code Associated With The Address

General Data Type: VARCHAR2

FIPS_ST

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

FIPS State Code Associated With the address

General Data Type: VARCHAR2

Catalog Details

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