Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Contains Information On Dealers That purchase fish

Notes:

Loaded by batch 2103, 02-28-2008 14:10

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Dealers

Entity Information

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

Contains Information On Dealers That purchase fish

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key DEALER_KEY NUMBER Sequence number automatically generated by the system to uniquely identify each row in the table. Since these keys are not data dependent, if any element of data is changed, the link to the other tables in the system are not broken.Validation:Managed by the database. Each row in the table must have a unique value.
100
DEALER_CODE VARCHAR2 Unique identifier for each dealer. On the form, the dealer name is used. Thescanning process takes the name and converts it to a code using a list providedby Resource Management Division.Validation:The column is validated against the FLS_DEALER_CODES table.This field is mandatory, that it, it cannot be left empty.
100
DEALER_CODING_SYSTEM VARCHAR2 Identifies the coding system or source of the dealer code. This code isnecessary because there are many sources of dealer codes. Currently, the sourcefor all codes is the State list compiled by RMD.Validation:This column is validated using the domain CODING_SYSTEM. The column cannot be left empty.
100
DEALER_PERMIT VARCHAR2 A code assigned by the permitting body, i.e., SERO. This code currently matchesthe Dealer's employer ID number, but it is seldom available from the fisher.Validation:None.
100
LOGBOOK_KEY NUMBER Foreign key to the FLS_TRIPS and other master tables.Validation:A foreign key enforces that trip information must have been entered into the FLS_TRIPS table before purchasing dealers can be specified.

Attribute Details

DEALER_KEY

CC ID: 27317
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 10
Scale: 0
Status: Active
Description:

Sequence number automatically generated by the system to uniquely identify each row in the table. Since these keys are not data dependent, if any element of data is changed, the link to the other tables in the system are not broken.Validation:Managed by the database. Each row in the table must have a unique value.

General Data Type: NUMBER

DEALER_CODE

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

Unique identifier for each dealer. On the form, the dealer name is used. Thescanning process takes the name and converts it to a code using a list providedby Resource Management Division.Validation:The column is validated against the FLS_DEALER_CODES table.This field is mandatory, that it, it cannot be left empty.

General Data Type: VARCHAR2

DEALER_CODING_SYSTEM

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

Identifies the coding system or source of the dealer code. This code isnecessary because there are many sources of dealer codes. Currently, the sourcefor all codes is the State list compiled by RMD.Validation:This column is validated using the domain CODING_SYSTEM. The column cannot be left empty.

General Data Type: VARCHAR2

DEALER_PERMIT

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

A code assigned by the permitting body, i.e., SERO. This code currently matchesthe Dealer's employer ID number, but it is seldom available from the fisher.Validation:None.

General Data Type: VARCHAR2

LOGBOOK_KEY

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

Foreign key to the FLS_TRIPS and other master tables.Validation:A foreign key enforces that trip information must have been entered into the FLS_TRIPS table before purchasing dealers can be specified.

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 7165
GUID: gov.noaa.nmfs.inport:7165
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-02-28 14:10+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07