7293
Table: DMS_ADDRESSES
DMS_ADDRESSES
Entity
Published / External
7291
Standardization Of Dealers
Data Set
Completed
table stores current address info for dms dealers
Loaded by batch 2163, 03-26-2008 16:04
Data Table
Yes
DMS
table stores current address info for dms dealers
1
DMS_KEY
VARCHAR2
15
Yes
No
Active
Main application key for uniquely identifying dealers
VARCHAR2
2
ADDRESS_TYPE
VARCHAR2
1
Yes
No
Active
'P' for physical address, 'M' for mailing, 'U' for unknown
VARCHAR2
3
ADDRESS_1
VARCHAR2
50
No
No
Active
First Line of The Street Address
VARCHAR2
4
ADDRESS_2
VARCHAR2
50
No
No
Active
Second Line Of Street Address (may be null)
VARCHAR2
5
ADDRESS_3
VARCHAR2
50
No
No
Active
Third Line Of Street Address (may be null)
VARCHAR2
6
CITY
VARCHAR2
30
No
No
Active
City
VARCHAR2
7
STATE
VARCHAR2
2
No
No
Active
State
VARCHAR2
8
POSTAL_CODE
VARCHAR2
10
No
No
Active
ZIp Code
VARCHAR2
9
PORT
VARCHAR2
15
No
No
Active
Port of landing according to dealer location
VARCHAR2
10
NMFS_CNTY
VARCHAR2
2
No
No
Active
NMFS County Code Associated With The Address
VARCHAR2
11
FIPS_CNTY
VARCHAR2
3
No
No
Active
FIPS County Code Associated With The Address
VARCHAR2
12
NMFS_ST
VARCHAR2
2
No
No
Active
NMFS State Code Associated With The Address
VARCHAR2
13
FIPS_ST
VARCHAR2
2
No
No
Active
FIPS State Code Associated With the address
VARCHAR2
gov.noaa.nmfs.inport:7293
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