Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: PDC_PNUMBER_XREF
Short Name: PDC_PNUMBER_XREF
Status: Completed
Abstract:

Provides a cross reference between NE and SE Permits

Notes:

Loaded by batch 1703, 10-15-2007 10:13

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: FLS
Description:

Provides a cross reference between NE and SE Permits

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
SE_PNUMBER VARCHAR2 Permit Number from SE
100
NE_PNUMBER VARCHAR2 Permt Number from NE
100
BNAME VARCHAR2 Business Name

Attribute Details

SE_PNUMBER

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

Permit Number from SE

General Data Type: VARCHAR2

NE_PNUMBER

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

Permt Number from NE

General Data Type: VARCHAR2

BNAME

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

Business Name

General Data Type: VARCHAR2

Catalog Details

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