Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Used to create a custom list by user of the dealer codes that the port agent excepts to see

Notes:

Loaded by batch 2007, 12-03-2007 11:22

Entity Information

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

Used to create a custom list by user of the dealer codes that the port agent excepts to see

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key USERNAME VARCHAR2 Sigon ID of TIPONLINE User
100
Primary Key ID VARCHAR2 Dealer Code
100
NAME VARCHAR2 Dealer Name
100
Primary Key STATE_ID VARCHAR2 State Id/Code
100
CREATED_DATE DATE Date/Time stamp of record creation
100
CREATED_BY_USER_ID VARCHAR2 User creating Record
100
MODIFIED_BY_USER_ID VARCHAR2 User modifying record
100
MODIFIED_DATE DATE Date/Time stamp of when record was modifed
100
Primary Key COUNTY_ID VARCHAR2 County ID/Code
100
FIN_CODE VARCHAR2 Dealer Code In FIN System
100
STANDARD_DEALER_ID VARCHAR2 Standard Dealer Code

Attribute Details

USERNAME

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

Sigon ID of TIPONLINE User

General Data Type: VARCHAR2

ID

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

Dealer Code

General Data Type: VARCHAR2

NAME

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

Dealer Name

General Data Type: VARCHAR2

STATE_ID

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

State Id/Code

General Data Type: VARCHAR2

CREATED_DATE

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

Date/Time stamp of record creation

General Data Type: DATE

CREATED_BY_USER_ID

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

User creating Record

General Data Type: VARCHAR2

MODIFIED_BY_USER_ID

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

User modifying record

General Data Type: VARCHAR2

MODIFIED_DATE

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

Date/Time stamp of when record was modifed

General Data Type: DATE

COUNTY_ID

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

County ID/Code

General Data Type: VARCHAR2

FIN_CODE

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

Dealer Code In FIN System

General Data Type: VARCHAR2

STANDARD_DEALER_ID

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

Standard Dealer Code

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 6694
GUID: gov.noaa.nmfs.inport:6694
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-12-03 11:22+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