7301
Table: DMS_RESTORE
DMS_RESTORE
Entity
Published / External
7291
Standardization Of Dealers
Data Set
Completed
table stores replaced data for the past 25 updates, for restore purposes
Loaded by batch 2163, 03-26-2008 16:04
Data Table
Yes
DMS
table stores replaced data for the past 25 updates, for restore purposes
1
UPDATE_ID
VARCHAR2
15
Yes
No
Active
identifier referring to a particular update/upload, key for restoring dealer data for dms (undoing updates)
VARCHAR2
2
DMS_KEY
VARCHAR2
15
Yes
No
Active
Main application key for uniquely identifying dealers
VARCHAR2
3
DATA_SOURCE
VARCHAR2
4
No
No
Active
Code for state/commission that provided the dealer information
VARCHAR2
4
DLR_CODE
VARCHAR2
15
No
No
Active
State, federal or commission dealer permit code issued to the dealer
VARCHAR2
5
EIN_SSN
VARCHAR2
15
No
No
Active
employer id/social security number
VARCHAR2
6
CORP_NAME
VARCHAR2
50
No
No
Active
business name
VARCHAR2
7
LAST_NAME
VARCHAR2
40
No
No
Active
owner last name
VARCHAR2
8
FIRST_NAME
VARCHAR2
40
No
No
Active
owner first name
VARCHAR2
9
MIDDLE_NAME
VARCHAR2
40
No
No
Active
owner middle name
VARCHAR2
10
NAME_SUFFIX
VARCHAR2
3
No
No
Active
name suffix (e.g. jr, sr, etc)
VARCHAR2
11
BIRTH_DATE
DATE
7
No
No
Active
owner birth date
DATE
12
CONTACT_LAST_NAME
VARCHAR2
40
No
No
Active
business contact person last name
VARCHAR2
13
CONTACT_FIRST_NAME
VARCHAR2
40
No
No
Active
business contact person first name
VARCHAR2
14
ADDRESS_TYPE
VARCHAR2
1
No
No
Active
'P' for physical address, 'M' for mailing, 'U' for unknown
VARCHAR2
15
ADDRESS_1
VARCHAR2
50
No
No
Active
First Line of The Street Address
VARCHAR2
16
ADDRESS_2
VARCHAR2
50
No
No
Active
Second Line Of Street Address (may be null)
VARCHAR2
17
ADDRESS_3
VARCHAR2
50
No
No
Active
Third Line Of Street Address (may be null)
VARCHAR2
18
CITY
VARCHAR2
30
No
No
Active
City
VARCHAR2
19
STATE
VARCHAR2
30
No
No
Active
State
VARCHAR2
20
POSTAL_CODE
VARCHAR2
10
No
No
Active
ZIp Code
VARCHAR2
21
PORT
VARCHAR2
15
No
No
Active
Port of landing according to dealer location
VARCHAR2
22
NMFS_CNTY
VARCHAR2
2
No
No
Active
NMFS County Code Associated With The Address
VARCHAR2
23
FIPS_CNTY
VARCHAR2
3
No
No
Active
FIPS County Code Associated With The Address
VARCHAR2
24
NMFS_ST
VARCHAR2
2
No
No
Active
NMFS State Code Associated With The Address
VARCHAR2
25
FIPS_ST
VARCHAR2
2
No
No
Active
FIPS State Code Associated With the address
VARCHAR2
26
PHONE_NBR
VARCHAR2
20
No
No
Active
contact tel. phone number
VARCHAR2
27
FAX_NBR
VARCHAR2
20
No
No
Active
contact fax number
VARCHAR2
28
EMAIL
VARCHAR2
50
No
No
Active
contact email address
VARCHAR2
29
LIC_MONTH
NUMBER
22
No
No
2
0
Active
license issued month (where applicable)
NUMBER
30
LIC_YR
NUMBER
22
No
No
4
0
Active
license issued year
NUMBER
31
LIC_ISS_DATE
DATE
7
No
No
Active
date license was issued
DATE
32
UPDATE_ACTION
VARCHAR2
8
Yes
No
Active
application specific code for type of update
VARCHAR2
gov.noaa.nmfs.inport:7301
Lee Weinberger
2008-03-26T16:04:08
SysAdmin InPortAdmin
2022-08-09T17:11:01
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