Table: DPS_DEALER_PERMIT
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:5403 | Updated: August 9, 2022 | Published / External
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details
Data Attributes
Attribute Summary
|
|
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 |