Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: PDC_INT_REPORTING_LABELS
Short Name: PDC_INT_REPORTING_LABELS
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
BPHONE VARCHAR2 Business Phone Of Permit Holder
100
SE_PNUMBER VARCHAR2 South East Permit Number
100
NE_PNUMBER VARCHAR2 North East Permit Number
100
BEGIN_DATE DATE Start Date
100
END_DATE DATE End Date
100
USERID VARCHAR2 Oracle ID of the creator of this record
100
VOID VARCHAR2 Trick field. It will be TRUE if the record is not to be printed
100
TYPE_TOP VARCHAR2 Type Of Permit

Attribute Details

BNAME

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

Business Name

General Data Type: VARCHAR2

BPHONE

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

Business Phone Of Permit Holder

General Data Type: VARCHAR2

SE_PNUMBER

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

South East Permit Number

General Data Type: VARCHAR2

NE_PNUMBER

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

North East Permit Number

General Data Type: VARCHAR2

BEGIN_DATE

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

Start Date

General Data Type: DATE

END_DATE

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

End Date

General Data Type: DATE

USERID

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

Oracle ID of the creator of this record

General Data Type: VARCHAR2

VOID

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

Trick field. It will be TRUE if the record is not to be printed

General Data Type: VARCHAR2

TYPE_TOP

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

Type Of Permit

General Data Type: VARCHAR2

Catalog Details

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