Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Table of Standard Dealer Codes

Notes:

Loaded by batch 2006, 12-03-2007 10:40

Entity Information

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

Table of Standard Dealer Codes

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key ID VARCHAR2 Standard Dealer Code
100
NAME VARCHAR2 Dealer Name
100
STATE_ID VARCHAR2 State Code
100
COUNTY_ID VARCHAR2 Standard County Code

Attribute Details

ID

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

Standard Dealer Code

General Data Type: VARCHAR2

NAME

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

Dealer Name

General Data Type: VARCHAR2

STATE_ID

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

State Code

General Data Type: VARCHAR2

COUNTY_ID

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

Standard County Code

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 6670
GUID: gov.noaa.nmfs.inport:6670
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-12-03 10:40+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-11-04 13:14+0000
Metadata Record Published: 2021-11-04
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-11-05