Table: PDC_NEW_PERMITS_SUBSET
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:5420 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | Table: PDC_NEW_PERMITS_SUBSET |
---|---|
Short Name: | PDC_NEW_PERMITS_SUBSET |
Status: | Completed |
Abstract: |
Each record is a dealer soon to be mailed |
Notes: |
Loaded by batch 1703, 10-15-2007 10:13 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | FLS |
Description: |
Each record is a dealer soon to be mailed |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
BNAME | VARCHAR2 | Business Name | |
100
|
SE_PNUMBER | VARCHAR2 | South East Permit Number | |
100
|
NE_PNUMBER | VARCHAR2 | North East Permit Number | |
100
|
STATUS | VARCHAR2 | Status. 'A' stands for Active | |
100
|
TOP | VARCHAR2 | Type Of Permit | |
100
|
EDOP | DATE | Effective Date Of Permit or when the Permit is Effective | |
100
|
EXPDATE | DATE | When the Permit is not effective anymore | |
100
|
BSTR | VARCHAR2 | Business Street Address Of Permit Holder | |
100
|
APPSTRT | VARCHAR2 | Street Address Of Applicant | |
100
|
TYPE_TOP | VARCHAR2 | Type Of Permit | |
100
|
NUM_REPORTING_PERIODS | NUMBER | Number Of Reporting Periods IN the time period the permit is effective | |
100
|
BCITY | VARCHAR2 | Business CIty Of Permit Holder | |
100
|
BSTATE | VARCHAR2 | Business State Of Permit Holder | |
100
|
BZIPCODE | VARCHAR2 | Business Zip Code Of Permit Holder | |
100
|
BPHONE | VARCHAR2 | Business Phone Of Permit Holder |
Attribute Details
BNAME
CC ID: 17009
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 45 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Business Name |
General Data Type: | VARCHAR2 |
SE_PNUMBER
CC ID: 17008
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
South East Permit Number |
General Data Type: | VARCHAR2 |
NE_PNUMBER
CC ID: 17007
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
North East Permit Number |
General Data Type: | VARCHAR2 |
STATUS
CC ID: 17006
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Status. 'A' stands for Active |
General Data Type: | VARCHAR2 |
TOP
CC ID: 17005
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 40 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Type Of Permit |
General Data Type: | VARCHAR2 |
EDOP
CC ID: 17004
Seq. Order: | 6 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Effective Date Of Permit or when the Permit is Effective |
General Data Type: | DATE |
EXPDATE
CC ID: 17003
Seq. Order: | 7 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
When the Permit is not effective anymore |
General Data Type: | DATE |
BSTR
CC ID: 17002
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Business Street Address Of Permit Holder |
General Data Type: | VARCHAR2 |
APPSTRT
CC ID: 17001
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Street Address Of Applicant |
General Data Type: | VARCHAR2 |
TYPE_TOP
CC ID: 17000
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Type Of Permit |
General Data Type: | VARCHAR2 |
NUM_REPORTING_PERIODS
CC ID: 16999
Seq. Order: | 11 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Number Of Reporting Periods IN the time period the permit is effective |
General Data Type: | NUMBER |
BCITY
CC ID: 16998
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Business CIty Of Permit Holder |
General Data Type: | VARCHAR2 |
BSTATE
CC ID: 16997
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Business State Of Permit Holder |
General Data Type: | VARCHAR2 |
BZIPCODE
CC ID: 16996
Seq. Order: | 14 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Business Zip Code Of Permit Holder |
General Data Type: | VARCHAR2 |
BPHONE
CC ID: 16995
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Business Phone Of Permit Holder |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 5420 |
---|---|
GUID: | gov.noaa.nmfs.inport:5420 |
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 |