7297
Table: DMS_DLR_CODES_HISTORY
DMS_DLR_CODES_HISTORY
Entity
Published / External
7291
Standardization Of Dealers
Data Set
Completed
table stores history of permit codes with related address info for dms dealers
Loaded by batch 2163, 03-26-2008 16:04
Data Table
Yes
DMS
table stores history of permit codes with related address info for dms dealers
1
DMS_KEY
VARCHAR2
15
Yes
No
Active
Main application key for uniquely identifying dealers
VARCHAR2
2
DLR_CODE
VARCHAR2
15
Yes
No
Active
State, federal or commission dealer permit code issued to the dealer
VARCHAR2
3
DATA_SOURCE
VARCHAR2
4
Yes
No
Active
Code for state/commission that provided the dealer information
VARCHAR2
4
LIC_MONTH
NUMBER
22
No
No
2
0
Active
license issued month (where applicable)
NUMBER
5
LIC_YR
NUMBER
22
No
No
4
0
Active
license issued year
NUMBER
6
LIC_ISS_DATE
DATE
7
No
No
Active
date license was issued
DATE
7
ADDRESS_TYPE
VARCHAR2
1
No
No
Active
'P' for physical address, 'M' for mailing, 'U' for unknown
VARCHAR2
8
ADDRESS_1
VARCHAR2
50
No
No
Active
First Line of The Street Address
VARCHAR2
9
ADDRESS_2
VARCHAR2
50
No
No
Active
Second Line Of Street Address (may be null)
VARCHAR2
10
ADDRESS_3
VARCHAR2
50
No
No
Active
Third Line Of Street Address (may be null)
VARCHAR2
11
CITY
VARCHAR2
30
No
No
Active
City
VARCHAR2
12
STATE
VARCHAR2
30
No
No
Active
State
VARCHAR2
13
POSTAL_CODE
VARCHAR2
10
No
No
Active
ZIp Code
VARCHAR2
14
PORT
VARCHAR2
30
No
No
Active
Port of landing according to dealer location
VARCHAR2
15
NMFS_CNTY
VARCHAR2
2
No
No
Active
NMFS County Code Associated With The Address
VARCHAR2
16
FIPS_CNTY
VARCHAR2
3
No
No
Active
FIPS County Code Associated With The Address
VARCHAR2
17
NMFS_ST
VARCHAR2
2
No
No
Active
NMFS State Code Associated With The Address
VARCHAR2
18
FIPS_ST
VARCHAR2
2
No
No
Active
FIPS State Code Associated With the address
VARCHAR2
gov.noaa.nmfs.inport:7297
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