Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Table Listing Dealers With Highest Recorded Purchases

Description

Table Listing Dealers With Highest Recorded Purchases

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
DEALER_NAME
VARCHAR2
Dealer Name
SE_PNUMBER
VARCHAR2
South East Permit Number
NE_PNUMBER
VARCHAR2
North East Permit Number
EXPIRATION_DATE
DATE
That is the date in which the permit expires
TOTAL_POUNDS
NUMBER
Total Pounds Reported
RANK
NUMBER
The rank according to the total pounds, being 1 the dealer with more total pounds
PERCENT
NUMBER
This dealer total pounds / ALL dealer total pounds * 100
USERID
VARCHAR2
Who is calling the report.

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_INT_MOST_ACTIVE_DLRS
Short Name: PDC_INT_MOST_ACTIVE_DLRS
Status: Completed
Abstract:

Table Listing Dealers With Highest Recorded Purchases

Notes:

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

Entity Information

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

Table Listing Dealers With Highest Recorded Purchases

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
DEALER_NAME VARCHAR2 Dealer Name
100
SE_PNUMBER VARCHAR2 South East Permit Number
100
NE_PNUMBER VARCHAR2 North East Permit Number
100
EXPIRATION_DATE DATE That is the date in which the permit expires
100
TOTAL_POUNDS NUMBER Total Pounds Reported
100
RANK NUMBER The rank according to the total pounds, being 1 the dealer with more total pounds
100
PERCENT NUMBER This dealer total pounds / ALL dealer total pounds * 100
100
USERID VARCHAR2 Who is calling the report.

Attribute Details

DEALER_NAME

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

Dealer Name

General Data Type: VARCHAR2

SE_PNUMBER

CC ID: 16880
Seq. Order: 2
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: 16879
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

EXPIRATION_DATE

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

That is the date in which the permit expires

General Data Type: DATE

TOTAL_POUNDS

CC ID: 16877
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Total Pounds Reported

General Data Type: NUMBER

RANK

CC ID: 16876
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

The rank according to the total pounds, being 1 the dealer with more total pounds

General Data Type: NUMBER

PERCENT

CC ID: 16875
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

This dealer total pounds / ALL dealer total pounds * 100

General Data Type: NUMBER

USERID

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

Who is calling the report.

General Data Type: VARCHAR2

Catalog Details

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