Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: PDC_NEW_PERMITS
Short Name: PDC_NEW_PERMITS
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 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: 16978
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: 16977
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: 16976
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: 16975
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: 16974
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: 16973
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: 16972
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: 16971
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: 16970
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: 16969
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: 16968
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: 16967
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: 16966
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: 16965
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: 16964
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: 5418
GUID: gov.noaa.nmfs.inport:5418
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-10-15 10:13+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07