7296
Table: DMS_DEALERS
DMS_DEALERS
Entity
Published / External
7291
Standardization Of Dealers
Data Set
Completed
table stores current dms dealer personal/contact info
Loaded by batch 2163, 03-26-2008 16:04
Data Table
Yes
DMS
table stores current dms dealer personal/contact info
1
DMS_KEY
VARCHAR2
15
Yes
Yes
Active
Main application key for uniquely identifying dealers
VARCHAR2
2
EIN_SSN
VARCHAR2
15
No
No
Active
employer id/social security number
VARCHAR2
3
CORP_NAME
VARCHAR2
50
No
No
Active
business name
VARCHAR2
4
LAST_NAME
VARCHAR2
40
No
No
Active
owner last name
VARCHAR2
5
FIRST_NAME
VARCHAR2
40
No
No
Active
owner first name
VARCHAR2
6
MIDDLE_NAME
VARCHAR2
40
No
No
Active
owner middle name
VARCHAR2
7
NAME_SUFFIX
VARCHAR2
3
No
No
Active
name suffix (e.g. jr, sr, etc)
VARCHAR2
8
BIRTH_DATE
DATE
7
No
No
Active
owner birth date
DATE
9
CONTACT_LAST_NAME
VARCHAR2
40
No
No
Active
business contact person last name
VARCHAR2
10
CONTACT_FIRST_NAME
VARCHAR2
40
No
No
Active
business contact person first name
VARCHAR2
11
PHONE_NBR
VARCHAR2
20
No
No
Active
contact tel. phone number
VARCHAR2
12
FAX_NBR
VARCHAR2
20
No
No
Active
contact fax number
VARCHAR2
13
EMAIL
VARCHAR2
50
No
No
Active
contact email address
VARCHAR2
14
RSLVD
VARCHAR2
1
Yes
No
Active
'N' = ambiguous entities (reqires more research), 'Y' = dealer is resolved
VARCHAR2
gov.noaa.nmfs.inport:7296
Lee Weinberger
2008-03-26T16:04:07
SysAdmin InPortAdmin
2022-08-09T17:11:02
2021-05-06
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
www.sefsc.noaa.gov
8:00 a.m. - 4:30 p.m. EST
1001
Public
No
2021-05-06
1 Year
2022-05-06