Slide Menu
Search Help Show/Hide Menu

Item Identification

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

table stores current dms dealer personal/contact info

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 dms dealer personal/contact info

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key DMS_KEY VARCHAR2 Main application key for uniquely identifying dealers
100
EIN_SSN VARCHAR2 employer id/social security number
100
CORP_NAME VARCHAR2 business name
100
LAST_NAME VARCHAR2 owner last name
100
FIRST_NAME VARCHAR2 owner first name
100
MIDDLE_NAME VARCHAR2 owner middle name
100
NAME_SUFFIX VARCHAR2 name suffix (e.g. jr, sr, etc)
100
BIRTH_DATE DATE owner birth date
100
CONTACT_LAST_NAME VARCHAR2 business contact person last name
100
CONTACT_FIRST_NAME VARCHAR2 business contact person first name
100
PHONE_NBR VARCHAR2 contact tel. phone number
100
FAX_NBR VARCHAR2 contact fax number
100
EMAIL VARCHAR2 contact email address
100
RSLVD VARCHAR2 'N' = ambiguous entities (reqires more research), 'Y' = dealer is resolved

Attribute Details

DMS_KEY

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

Main application key for uniquely identifying dealers

General Data Type: VARCHAR2

EIN_SSN

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

employer id/social security number

General Data Type: VARCHAR2

CORP_NAME

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

business name

General Data Type: VARCHAR2

LAST_NAME

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

owner last name

General Data Type: VARCHAR2

FIRST_NAME

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

owner first name

General Data Type: VARCHAR2

MIDDLE_NAME

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

owner middle name

General Data Type: VARCHAR2

NAME_SUFFIX

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

name suffix (e.g. jr, sr, etc)

General Data Type: VARCHAR2

BIRTH_DATE

CC ID: 27903
Seq. Order: 8
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

owner birth date

General Data Type: DATE

CONTACT_LAST_NAME

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

business contact person last name

General Data Type: VARCHAR2

CONTACT_FIRST_NAME

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

business contact person first name

General Data Type: VARCHAR2

PHONE_NBR

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

contact tel. phone number

General Data Type: VARCHAR2

FAX_NBR

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

contact fax number

General Data Type: VARCHAR2

EMAIL

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

contact email address

General Data Type: VARCHAR2

RSLVD

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

'N' = ambiguous entities (reqires more research), 'Y' = dealer is resolved

General Data Type: VARCHAR2

Catalog Details

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