5403
Table: DPS_DEALER_PERMIT
DPS_DEALER_PERMIT
Entity
Published / External
5402
Pelagic Dealer Commercial Landings Monitoring (HMS Dealers)
Data Set
Completed
Dealer Permit Table .
Loaded by batch 1703, 10-15-2007 10:13
Data Table
Yes
FLS
Dealer Permit Table .
1
LU
VARCHAR2
1
No
No
Active
- Retrofitted
VARCHAR2
2
IDNUM
VARCHAR2
15
No
No
Active
- Retrofitted
VARCHAR2
3
TOP
VARCHAR2
40
No
No
Active
Type Of Permit
VARCHAR2
4
PNUMBER
VARCHAR2
4
No
No
Active
Permit Number
VARCHAR2
5
EDOP
DATE
7
No
No
Active
Effective Date Of Permit
DATE
6
RDEDOP
DATE
7
No
No
Active
- Retrofitted
DATE
7
RSEDOP
DATE
7
No
No
Active
- Retrofitted
DATE
8
SGEDOP
DATE
7
No
No
Active
- Retrofitted
DATE
9
SHEDOP
DATE
7
No
No
Active
- Retrofitted
DATE
10
SDEDOP
DATE
7
No
No
Active
- Retrofitted
DATE
11
EXPDATE
DATE
7
No
No
Active
Expiration Date Of Permit
DATE
12
DOE
DATE
7
No
No
Active
- Retrofitted
DATE
13
STATUS
VARCHAR2
1
No
No
Active
- Retrofitted
VARCHAR2
14
DOS
DATE
7
No
No
Active
- Retrofitted
DATE
15
BNAME
VARCHAR2
45
No
No
Active
Business Name
VARCHAR2
16
BSTRT
VARCHAR2
30
No
No
Active
Business Stret Address
VARCHAR2
17
BPHONE
VARCHAR2
12
No
No
Active
Bisiness Phine Number
VARCHAR2
18
BCITY
VARCHAR2
30
No
No
Active
City In Business Address
VARCHAR2
19
BSTATE
VARCHAR2
2
No
No
Active
State Of Business Address
VARCHAR2
20
BZIPCODE
VARCHAR2
10
No
No
Active
Zip Code Of Business Address
VARCHAR2
21
BDOB
DATE
7
No
No
Active
Business Date Of Incorporation or date of business start or application for permit
DATE
22
FNAME1
VARCHAR2
45
No
No
Active
- Retrofitted
VARCHAR2
23
FPHONE1
VARCHAR2
12
No
No
Active
- Retrofitted
VARCHAR2
24
FSTRT1
VARCHAR2
30
No
No
Active
- Retrofitted
VARCHAR2
25
FCITY1
VARCHAR2
30
No
No
Active
- Retrofitted
VARCHAR2
26
FSTATE1
VARCHAR2
2
No
No
Active
- Retrofitted
VARCHAR2
27
FZIPCOD1
VARCHAR2
10
No
No
Active
- Retrofitted
VARCHAR2
28
FNAME2
VARCHAR2
45
No
No
Active
- Retrofitted
VARCHAR2
29
FPHONE2
VARCHAR2
12
No
No
Active
- Retrofitted
VARCHAR2
30
FSTRT2
VARCHAR2
30
No
No
Active
- Retrofitted
VARCHAR2
31
FCITY2
VARCHAR2
30
No
No
Active
- Retrofitted
VARCHAR2
32
FSTATE2
VARCHAR2
2
No
No
Active
- Retrofitted
VARCHAR2
33
FZIPCOD2
VARCHAR2
10
No
No
Active
- Retrofitted
VARCHAR2
34
FNAME3
VARCHAR2
45
No
No
Active
- Retrofitted
VARCHAR2
35
FPHONE3
VARCHAR2
12
No
No
Active
- Retrofitted
VARCHAR2
36
FSTRT3
VARCHAR2
30
No
No
Active
- Retrofitted
VARCHAR2
37
FCITY3
VARCHAR2
30
No
No
Active
- Retrofitted
VARCHAR2
38
FSTATE3
VARCHAR2
2
No
No
Active
- Retrofitted
VARCHAR2
39
FZIPCOD3
VARCHAR2
10
No
No
Active
- Retrofitted
VARCHAR2
40
FNAME4
VARCHAR2
45
No
No
Active
- Retrofitted
VARCHAR2
41
FPHONE4
VARCHAR2
12
No
No
Active
- Retrofitted
VARCHAR2
42
FSTRT4
VARCHAR2
30
No
No
Active
- Retrofitted
VARCHAR2
43
FCITY4
VARCHAR2
30
No
No
Active
- Retrofitted
VARCHAR2
44
FSTATE4
VARCHAR2
2
No
No
Active
- Retrofitted
VARCHAR2
45
FZIPCOD4
VARCHAR2
10
No
No
Active
- Retrofitted
VARCHAR2
46
FNAME5
VARCHAR2
45
No
No
Active
- Retrofitted
VARCHAR2
47
FPHONE5
VARCHAR2
12
No
No
Active
- Retrofitted
VARCHAR2
48
FSTRT5
VARCHAR2
30
No
No
Active
- Retrofitted
VARCHAR2
49
FCITY5
VARCHAR2
30
No
No
Active
- Retrofitted
VARCHAR2
50
FSTATE5
VARCHAR2
2
No
No
Active
- Retrofitted
VARCHAR2
51
FZIPCOD5
VARCHAR2
10
No
No
Active
- Retrofitted
VARCHAR2
52
FNAME6
VARCHAR2
45
No
No
Active
- Retrofitted
VARCHAR2
53
FPHONE6
VARCHAR2
12
No
No
Active
- Retrofitted
VARCHAR2
54
FSTRT6
VARCHAR2
30
No
No
Active
- Retrofitted
VARCHAR2
55
FCITY6
VARCHAR2
30
No
No
Active
- Retrofitted
VARCHAR2
56
FSTATE6
VARCHAR2
2
No
No
Active
- Retrofitted
VARCHAR2
57
FZIPCOD6
VARCHAR2
10
No
No
Active
- Retrofitted
VARCHAR2
58
APPNAME
VARCHAR2
35
No
No
Active
- Retrofitted
VARCHAR2
59
APPPOS
VARCHAR2
25
No
No
Active
- Retrofitted
VARCHAR2
60
APPPHONE
VARCHAR2
12
No
No
Active
- Retrofitted
VARCHAR2
61
APPSSN
VARCHAR2
11
No
No
Active
- Retrofitted
VARCHAR2
62
APPDOB
DATE
7
No
No
Active
- Retrofitted
DATE
63
APPSTRT
VARCHAR2
30
No
No
Active
- Retrofitted
VARCHAR2
64
APPCITY
VARCHAR2
30
No
No
Active
- Retrofitted
VARCHAR2
65
APPSTATE
VARCHAR2
2
No
No
Active
- Retrofitted
VARCHAR2
66
APPZIP
VARCHAR2
10
No
No
Active
- Retrofitted
VARCHAR2
67
REMARKS
VARCHAR2
250
No
No
Active
- Retrofitted
VARCHAR2
68
INITS
VARCHAR2
8
No
No
Active
- Retrofitted
VARCHAR2
69
NE_PNUMBER
VARCHAR2
4
No
No
Active
Permit Number Assigned By NE Regional Office for Permits that they are responsible for.
VARCHAR2
70
NMFS_STATE
VARCHAR2
2
No
No
Active
NMFS State Of Dealer Location
VARCHAR2
71
NMFS_CTY
VARCHAR2
2
No
No
Active
NMFS County
VARCHAR2
72
FL_STATE
VARCHAR2
2
No
No
Active
Florida State
VARCHAR2
gov.noaa.nmfs.inport:5403
Lee Weinberger
2007-10-15T10:13:54
SysAdmin InPortAdmin
2022-08-09T17:11:00
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