Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Fisheries Statistics Division > FISHERIES MONITORING > Commercial Catch and Effort > Dealer Reporting > Pelagic Dealer Compliance > Pelagic Dealer Commercial Landings Monitoring (... >

Table: PDC_NEW_PERMITS_HISTORY

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:5419  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Each record is a dealer soon to be mailed

Description

Each record is a dealer soon to be mailed

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
BNAME
VARCHAR2 		Business Name
SE_PNUMBER
VARCHAR2 		South East Permit Number
NE_PNUMBER
VARCHAR2 		North East Permit Number
STATUS
VARCHAR2 		Status. 'A' stands for Active
TOP
VARCHAR2 		Type Of Permit
EDOP
DATE 		Effective Date Of Permit or when the Permit is Effective
EXPDATE
DATE 		When the Permit is not effective anymore
BSTR
VARCHAR2 		Business Street Address Of Permit Holder
APPSTRT
VARCHAR2 		Applicants Street Address
TYPE_TOP
VARCHAR2 		Made 3 05/18/2004 By Lee WeinbergerSo load of historical data goes
NUM_REPORTING_PERIODS
NUMBER 		Number Of Reporting Periods IN the time period the permit is effective
BCITY
VARCHAR2 		Business CIty Of Permit Holder
BSTATE
VARCHAR2 		Business State Of Permit Holder
BZIPCODE
VARCHAR2 		Business Zip Code Of Permit Holder
BPHONE
VARCHAR2 		Business Phone Of Permit Holder
MAILING_PREPARATION_DATE
DATE 		Date Mailing was prepared for the Dealer

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

Item Identification

Title: Table: PDC_NEW_PERMITS_HISTORY
Short Name: PDC_NEW_PERMITS_HISTORY
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

Rubric Score Primary Key? 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 Applicants Street Address
100
 TYPE_TOP VARCHAR2 Made 3 05/18/2004 By Lee WeinbergerSo load of historical data goes
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
100
 MAILING_PREPARATION_DATE DATE Date Mailing was prepared for the Dealer

Attribute Details

BNAME

CC ID: 16994
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: 16993
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: 16992
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: 16991
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: 16990
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: 16989
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: 16988
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: 16987
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: 16986
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Applicants Street Address
General Data Type: VARCHAR2

TYPE_TOP

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

Made 3 05/18/2004 By Lee WeinbergerSo load of historical data goes
General Data Type: VARCHAR2

NUM_REPORTING_PERIODS

CC ID: 16984
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: 16983
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: 16982
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: 16981
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: 16980
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

MAILING_PREPARATION_DATE

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

Date Mailing was prepared for the Dealer
General Data Type: DATE

Catalog Details

Catalog Item ID: 5419
GUID: gov.noaa.nmfs.inport:5419
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