Slide Menu
Search Help Show/Hide Menu

Item Identification

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

table stores history of permit codes with related address info for dms dealers

Notes:

Loaded by batch 2163, 03-26-2008 16:04

Entity Information

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

table stores history of permit codes with related address info for dms dealers

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
DMS_KEY VARCHAR2 Main application key for uniquely identifying dealers
100
DLR_CODE VARCHAR2 State, federal or commission dealer permit code issued to the dealer
100
DATA_SOURCE VARCHAR2 Code for state/commission that provided the dealer information
100
LIC_MONTH NUMBER license issued month (where applicable)
100
LIC_YR NUMBER license issued year
100
LIC_ISS_DATE DATE date license was issued
100
ADDRESS_TYPE VARCHAR2 'P' for physical address, 'M' for mailing, 'U' for unknown
100
ADDRESS_1 VARCHAR2 First Line of The Street Address
100
ADDRESS_2 VARCHAR2 Second Line Of Street Address (may be null)
100
ADDRESS_3 VARCHAR2 Third Line Of Street Address (may be null)
100
CITY VARCHAR2 City
100
STATE VARCHAR2 State
100
POSTAL_CODE VARCHAR2 ZIp Code
100
PORT VARCHAR2 Port of landing according to dealer location
100
NMFS_CNTY VARCHAR2 NMFS County Code Associated With The Address
100
FIPS_CNTY VARCHAR2 FIPS County Code Associated With The Address
100
NMFS_ST VARCHAR2 NMFS State Code Associated With The Address
100
FIPS_ST VARCHAR2 FIPS State Code Associated With the address

Attribute Details

DMS_KEY

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

Main application key for uniquely identifying dealers

General Data Type: VARCHAR2

DLR_CODE

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

State, federal or commission dealer permit code issued to the dealer

General Data Type: VARCHAR2

DATA_SOURCE

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

Code for state/commission that provided the dealer information

General Data Type: VARCHAR2

LIC_MONTH

CC ID: 27913
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

license issued month (where applicable)

General Data Type: NUMBER

LIC_YR

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

license issued year

General Data Type: NUMBER

LIC_ISS_DATE

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

date license was issued

General Data Type: DATE

ADDRESS_TYPE

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

'P' for physical address, 'M' for mailing, 'U' for unknown

General Data Type: VARCHAR2

ADDRESS_1

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

First Line of The Street Address

General Data Type: VARCHAR2

ADDRESS_2

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

Second Line Of Street Address (may be null)

General Data Type: VARCHAR2

ADDRESS_3

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

Third Line Of Street Address (may be null)

General Data Type: VARCHAR2

CITY

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

City

General Data Type: VARCHAR2

STATE

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

State

General Data Type: VARCHAR2

POSTAL_CODE

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

ZIp Code

General Data Type: VARCHAR2

PORT

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

Port of landing according to dealer location

General Data Type: VARCHAR2

NMFS_CNTY

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

NMFS County Code Associated With The Address

General Data Type: VARCHAR2

FIPS_CNTY

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

FIPS County Code Associated With The Address

General Data Type: VARCHAR2

NMFS_ST

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

NMFS State Code Associated With The Address

General Data Type: VARCHAR2

FIPS_ST

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

FIPS State Code Associated With the address

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7297
GUID: gov.noaa.nmfs.inport:7297
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-03-26 16:04+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