Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Data Management Systems (DMS) > Vessel Electronic Reporting System (VERS) >

Table: FVTR_DEALERS

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

Summary

Abstract

Materialized view of the GARFO table PERMIT.DEALER table where CANCEL_DATE is null; a list dealer information for those dealers which currently hold a federal seafood dealer permit in the NE Region.

Description

Materialized view of the GARFO table PERMIT.DEALER table where CANCEL_DATE is null; a list dealer information for those dealers which currently hold a federal seafood dealer permit in the NE Region.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
DEALER_ID
VARCHAR2 		Dealer identification number
DEALER_NAME
VARCHAR2 		Dealer Name
ISSUE_DATE
DATE 		Date on which the permit was issued
CANCEL_DATE
DATE 		Date on which the permit was cancelled or expired
ISSUING_AGENCY
VARCHAR2 		Agency authorized to issue a dealer permit
CITY
VARCHAR2 		City in which the seafood dealer is located
STATE
VARCHAR2 		State in which the seafood dealer is located

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

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

Materialized view of the GARFO table PERMIT.DEALER table where CANCEL_DATE is null; a list dealer information for those dealers which currently hold a federal seafood dealer permit in the NE Region.
Notes:

Loaded by batch 9209, 08-23-2016 08:38

Entity Information

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

Materialized view of the GARFO table PERMIT.DEALER table where CANCEL_DATE is null; a list dealer information for those dealers which currently hold a federal seafood dealer permit in the NE Region.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key DEALER_ID VARCHAR2 Dealer identification number
100
 DEALER_NAME VARCHAR2 Dealer Name
100
 ISSUE_DATE DATE Date on which the permit was issued
100
 CANCEL_DATE DATE Date on which the permit was cancelled or expired
100
 Primary Key ISSUING_AGENCY VARCHAR2 Agency authorized to issue a dealer permit
100
 CITY VARCHAR2 City in which the seafood dealer is located
100
 STATE VARCHAR2 State in which the seafood dealer is located

Attribute Details

DEALER_ID

CC ID: 345412
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 40
Required: Yes
Primary Key: Yes
Status: Active
Description:

Dealer identification number
General Data Type: VARCHAR2

DEALER_NAME

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

Dealer Name
General Data Type: VARCHAR2

ISSUE_DATE

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

Date on which the permit was issued
General Data Type: DATE

CANCEL_DATE

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

Date on which the permit was cancelled or expired
General Data Type: DATE

ISSUING_AGENCY

CC ID: 345416
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: Yes
Status: Active
Description:

Agency authorized to issue a dealer permit
General Data Type: VARCHAR2

CITY

CC ID: 345417
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

City in which the seafood dealer is located
General Data Type: VARCHAR2

STATE

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

State in which the seafood dealer is located
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 34392
GUID: gov.noaa.nmfs.inport:34392
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-08-23 08:38+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-08-23
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-08-23
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-08-23