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_MAP_DEALERS_TO_DISPO

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

Summary

Abstract

This table converts a miscellaneous dealer selection (see FVTR_DEALERS_MISC) into an appropriate disposition code for apportionment

Description

This table converts a miscellaneous dealer selection (see FVTR_DEALERS_MISC) into an appropriate disposition code for apportionment

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
FD_DEALER_ID
VARCHAR2 		Dealer identifier (see FVTR_DEALERS_MISC)
FD_ISSUING_AGENCY
VARCHAR2 		Government agency which issued the dealer permit (eg. state or federal)
FDC_DISPOSITION_CODE
VARCHAR2 		Default disposition code assigned at apportionment when the dealer ID is selected

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_MAP_DEALERS_TO_DISPO
Short Name: FVTR_MAP_DEALERS_TO_DISPO
Status: Completed
Abstract:

This table converts a miscellaneous dealer selection (see FVTR_DEALERS_MISC) into an appropriate disposition code for apportionment
Notes:

Loaded by batch 9190, 08-11-2016 16:37

Entity Information

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

This table converts a miscellaneous dealer selection (see FVTR_DEALERS_MISC) into an appropriate disposition code for apportionment

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key FD_DEALER_ID VARCHAR2 Dealer identifier (see FVTR_DEALERS_MISC)
100
 Primary Key FD_ISSUING_AGENCY VARCHAR2 Government agency which issued the dealer permit (eg. state or federal)
100
 FDC_DISPOSITION_CODE VARCHAR2 Default disposition code assigned at apportionment when the dealer ID is selected

Attribute Details

FD_DEALER_ID

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

Dealer identifier (see FVTR_DEALERS_MISC)
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.FVTR_DEALERS

FD_ISSUING_AGENCY

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

Government agency which issued the dealer permit (eg. state or federal)
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.FVTR_DEALERS

FDC_DISPOSITION_CODE

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

Default disposition code assigned at apportionment when the dealer ID is selected
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.FVTR_DISPOSITIONS

Catalog Details

Catalog Item ID: 34260
GUID: gov.noaa.nmfs.inport:34260
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-08-11 16:37+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