Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: DPS_DEALER_PERMIT
Short Name: DPS_DEALER_PERMIT
Status: Completed
Abstract:

Dealer Permit Table .

Notes:

Loaded by batch 1703, 10-15-2007 10:13

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: FLS
Description:

Dealer Permit Table .

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
LU VARCHAR2 - Retrofitted
100
IDNUM VARCHAR2 - Retrofitted
100
TOP VARCHAR2 Type Of Permit
100
PNUMBER VARCHAR2 Permit Number
100
EDOP DATE Effective Date Of Permit
100
RDEDOP DATE - Retrofitted
100
RSEDOP DATE - Retrofitted
100
SGEDOP DATE - Retrofitted
100
SHEDOP DATE - Retrofitted
100
SDEDOP DATE - Retrofitted
100
EXPDATE DATE Expiration Date Of Permit
100
DOE DATE - Retrofitted
100
STATUS VARCHAR2 - Retrofitted
100
DOS DATE - Retrofitted
100
BNAME VARCHAR2 Business Name
100
BSTRT VARCHAR2 Business Stret Address
100
BPHONE VARCHAR2 Bisiness Phine Number
100
BCITY VARCHAR2 City In Business Address
100
BSTATE VARCHAR2 State Of Business Address
100
BZIPCODE VARCHAR2 Zip Code Of Business Address
100
BDOB DATE Business Date Of Incorporation or date of business start or application for permit
100
FNAME1 VARCHAR2 - Retrofitted
100
FPHONE1 VARCHAR2 - Retrofitted
100
FSTRT1 VARCHAR2 - Retrofitted
100
FCITY1 VARCHAR2 - Retrofitted
100
FSTATE1 VARCHAR2 - Retrofitted
100
FZIPCOD1 VARCHAR2 - Retrofitted
100
FNAME2 VARCHAR2 - Retrofitted
100
FPHONE2 VARCHAR2 - Retrofitted
100
FSTRT2 VARCHAR2 - Retrofitted
100
FCITY2 VARCHAR2 - Retrofitted
100
FSTATE2 VARCHAR2 - Retrofitted
100
FZIPCOD2 VARCHAR2 - Retrofitted
100
FNAME3 VARCHAR2 - Retrofitted
100
FPHONE3 VARCHAR2 - Retrofitted
100
FSTRT3 VARCHAR2 - Retrofitted
100
FCITY3 VARCHAR2 - Retrofitted
100
FSTATE3 VARCHAR2 - Retrofitted
100
FZIPCOD3 VARCHAR2 - Retrofitted
100
FNAME4 VARCHAR2 - Retrofitted
100
FPHONE4 VARCHAR2 - Retrofitted
100
FSTRT4 VARCHAR2 - Retrofitted
100
FCITY4 VARCHAR2 - Retrofitted
100
FSTATE4 VARCHAR2 - Retrofitted
100
FZIPCOD4 VARCHAR2 - Retrofitted
100
FNAME5 VARCHAR2 - Retrofitted
100
FPHONE5 VARCHAR2 - Retrofitted
100
FSTRT5 VARCHAR2 - Retrofitted
100
FCITY5 VARCHAR2 - Retrofitted
100
FSTATE5 VARCHAR2 - Retrofitted
100
FZIPCOD5 VARCHAR2 - Retrofitted
100
FNAME6 VARCHAR2 - Retrofitted
100
FPHONE6 VARCHAR2 - Retrofitted
100
FSTRT6 VARCHAR2 - Retrofitted
100
FCITY6 VARCHAR2 - Retrofitted
100
FSTATE6 VARCHAR2 - Retrofitted
100
FZIPCOD6 VARCHAR2 - Retrofitted
100
APPNAME VARCHAR2 - Retrofitted
100
APPPOS VARCHAR2 - Retrofitted
100
APPPHONE VARCHAR2 - Retrofitted
100
APPSSN VARCHAR2 - Retrofitted
100
APPDOB DATE - Retrofitted
100
APPSTRT VARCHAR2 - Retrofitted
100
APPCITY VARCHAR2 - Retrofitted
100
APPSTATE VARCHAR2 - Retrofitted
100
APPZIP VARCHAR2 - Retrofitted
100
REMARKS VARCHAR2 - Retrofitted
100
INITS VARCHAR2 - Retrofitted
100
NE_PNUMBER VARCHAR2 Permit Number Assigned By NE Regional Office for Permits that they are responsible for.
100
NMFS_STATE VARCHAR2 NMFS State Of Dealer Location
100
NMFS_CTY VARCHAR2 NMFS County
100
FL_STATE VARCHAR2 Florida State

Attribute Details

LU

CC ID: 16715
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

IDNUM

CC ID: 16714
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

TOP

CC ID: 16713
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Type Of Permit

General Data Type: VARCHAR2

PNUMBER

CC ID: 16712
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Permit Number

General Data Type: VARCHAR2

EDOP

CC ID: 16711
Seq. Order: 5
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Effective Date Of Permit

General Data Type: DATE

RDEDOP

CC ID: 16710
Seq. Order: 6
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: DATE

RSEDOP

CC ID: 16781
Seq. Order: 7
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: DATE

SGEDOP

CC ID: 16780
Seq. Order: 8
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: DATE

SHEDOP

CC ID: 16779
Seq. Order: 9
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: DATE

SDEDOP

CC ID: 16778
Seq. Order: 10
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: DATE

EXPDATE

CC ID: 16777
Seq. Order: 11
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Expiration Date Of Permit

General Data Type: DATE

DOE

CC ID: 16776
Seq. Order: 12
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: DATE

STATUS

CC ID: 16775
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

DOS

CC ID: 16774
Seq. Order: 14
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: DATE

BNAME

CC ID: 16773
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 45
Required: No
Primary Key: No
Status: Active
Description:

Business Name

General Data Type: VARCHAR2

BSTRT

CC ID: 16772
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Business Stret Address

General Data Type: VARCHAR2

BPHONE

CC ID: 16771
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

Bisiness Phine Number

General Data Type: VARCHAR2

BCITY

CC ID: 16770
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

City In Business Address

General Data Type: VARCHAR2

BSTATE

CC ID: 16769
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

State Of Business Address

General Data Type: VARCHAR2

BZIPCODE

CC ID: 16768
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Zip Code Of Business Address

General Data Type: VARCHAR2

BDOB

CC ID: 16767
Seq. Order: 21
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Business Date Of Incorporation or date of business start or application for permit

General Data Type: DATE

FNAME1

CC ID: 16766
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 45
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FPHONE1

CC ID: 16765
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FSTRT1

CC ID: 16764
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FCITY1

CC ID: 16763
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FSTATE1

CC ID: 16762
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FZIPCOD1

CC ID: 16761
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FNAME2

CC ID: 16760
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 45
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FPHONE2

CC ID: 16759
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FSTRT2

CC ID: 16758
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FCITY2

CC ID: 16757
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FSTATE2

CC ID: 16756
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FZIPCOD2

CC ID: 16755
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FNAME3

CC ID: 16754
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 45
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FPHONE3

CC ID: 16753
Seq. Order: 35
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FSTRT3

CC ID: 16752
Seq. Order: 36
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FCITY3

CC ID: 16751
Seq. Order: 37
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FSTATE3

CC ID: 16750
Seq. Order: 38
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FZIPCOD3

CC ID: 16749
Seq. Order: 39
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FNAME4

CC ID: 16748
Seq. Order: 40
Data Storage Type: VARCHAR2
Max Length: 45
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FPHONE4

CC ID: 16747
Seq. Order: 41
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FSTRT4

CC ID: 16746
Seq. Order: 42
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FCITY4

CC ID: 16745
Seq. Order: 43
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FSTATE4

CC ID: 16744
Seq. Order: 44
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FZIPCOD4

CC ID: 16743
Seq. Order: 45
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FNAME5

CC ID: 16742
Seq. Order: 46
Data Storage Type: VARCHAR2
Max Length: 45
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FPHONE5

CC ID: 16741
Seq. Order: 47
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FSTRT5

CC ID: 16740
Seq. Order: 48
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FCITY5

CC ID: 16739
Seq. Order: 49
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FSTATE5

CC ID: 16738
Seq. Order: 50
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FZIPCOD5

CC ID: 16737
Seq. Order: 51
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FNAME6

CC ID: 16736
Seq. Order: 52
Data Storage Type: VARCHAR2
Max Length: 45
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FPHONE6

CC ID: 16735
Seq. Order: 53
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FSTRT6

CC ID: 16734
Seq. Order: 54
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FCITY6

CC ID: 16733
Seq. Order: 55
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FSTATE6

CC ID: 16732
Seq. Order: 56
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

FZIPCOD6

CC ID: 16731
Seq. Order: 57
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

APPNAME

CC ID: 16730
Seq. Order: 58
Data Storage Type: VARCHAR2
Max Length: 35
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

APPPOS

CC ID: 16729
Seq. Order: 59
Data Storage Type: VARCHAR2
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

APPPHONE

CC ID: 16728
Seq. Order: 60
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

APPSSN

CC ID: 16727
Seq. Order: 61
Data Storage Type: VARCHAR2
Max Length: 11
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

APPDOB

CC ID: 16726
Seq. Order: 62
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: DATE

APPSTRT

CC ID: 16725
Seq. Order: 63
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

APPCITY

CC ID: 16724
Seq. Order: 64
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

APPSTATE

CC ID: 16723
Seq. Order: 65
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

APPZIP

CC ID: 16722
Seq. Order: 66
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

REMARKS

CC ID: 16721
Seq. Order: 67
Data Storage Type: VARCHAR2
Max Length: 250
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

INITS

CC ID: 16720
Seq. Order: 68
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

- Retrofitted

General Data Type: VARCHAR2

NE_PNUMBER

CC ID: 16719
Seq. Order: 69
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Permit Number Assigned By NE Regional Office for Permits that they are responsible for.

General Data Type: VARCHAR2

NMFS_STATE

CC ID: 16718
Seq. Order: 70
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

NMFS State Of Dealer Location

General Data Type: VARCHAR2

NMFS_CTY

CC ID: 16717
Seq. Order: 71
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

NMFS County

General Data Type: VARCHAR2

FL_STATE

CC ID: 16716
Seq. Order: 72
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Florida State

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 5403
GUID: gov.noaa.nmfs.inport:5403
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-10-15 10:13+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-06
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-06