Slide Menu
Search Help Show/Hide Menu

Item Identification

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

table stores replaced data for the past 25 updates, for restore purposes

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 replaced data for the past 25 updates, for restore purposes

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
UPDATE_ID VARCHAR2 identifier referring to a particular update/upload, key for restoring dealer data for dms (undoing updates)
100
DMS_KEY VARCHAR2 Main application key for uniquely identifying dealers
100
DATA_SOURCE VARCHAR2 Code for state/commission that provided the dealer information
100
DLR_CODE VARCHAR2 State, federal or commission dealer permit code issued to the dealer
100
EIN_SSN VARCHAR2 employer id/social security number
100
CORP_NAME VARCHAR2 business name
100
LAST_NAME VARCHAR2 owner last name
100
FIRST_NAME VARCHAR2 owner first name
100
MIDDLE_NAME VARCHAR2 owner middle name
100
NAME_SUFFIX VARCHAR2 name suffix (e.g. jr, sr, etc)
100
BIRTH_DATE DATE owner birth date
100
CONTACT_LAST_NAME VARCHAR2 business contact person last name
100
CONTACT_FIRST_NAME VARCHAR2 business contact person first name
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
100
PHONE_NBR VARCHAR2 contact tel. phone number
100
FAX_NBR VARCHAR2 contact fax number
100
EMAIL VARCHAR2 contact email address
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
UPDATE_ACTION VARCHAR2 application specific code for type of update

Attribute Details

UPDATE_ID

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

identifier referring to a particular update/upload, key for restoring dealer data for dms (undoing updates)

General Data Type: VARCHAR2

DMS_KEY

CC ID: 27935
Seq. Order: 2
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

DATA_SOURCE

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

Code for state/commission that provided the dealer information

General Data Type: VARCHAR2

DLR_CODE

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

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

General Data Type: VARCHAR2

EIN_SSN

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

employer id/social security number

General Data Type: VARCHAR2

CORP_NAME

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

business name

General Data Type: VARCHAR2

LAST_NAME

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

owner last name

General Data Type: VARCHAR2

FIRST_NAME

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

owner first name

General Data Type: VARCHAR2

MIDDLE_NAME

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

owner middle name

General Data Type: VARCHAR2

NAME_SUFFIX

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

name suffix (e.g. jr, sr, etc)

General Data Type: VARCHAR2

BIRTH_DATE

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

owner birth date

General Data Type: DATE

CONTACT_LAST_NAME

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

business contact person last name

General Data Type: VARCHAR2

CONTACT_FIRST_NAME

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

business contact person first name

General Data Type: VARCHAR2

ADDRESS_TYPE

CC ID: 27947
Seq. Order: 14
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: 27948
Seq. Order: 15
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: 27949
Seq. Order: 16
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: 27950
Seq. Order: 17
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: 27951
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

City

General Data Type: VARCHAR2

STATE

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

State

General Data Type: VARCHAR2

POSTAL_CODE

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

ZIp Code

General Data Type: VARCHAR2

PORT

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

Port of landing according to dealer location

General Data Type: VARCHAR2

NMFS_CNTY

CC ID: 27955
Seq. Order: 22
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: 27956
Seq. Order: 23
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: 27957
Seq. Order: 24
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: 27958
Seq. Order: 25
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

PHONE_NBR

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

contact tel. phone number

General Data Type: VARCHAR2

FAX_NBR

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

contact fax number

General Data Type: VARCHAR2

EMAIL

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

contact email address

General Data Type: VARCHAR2

LIC_MONTH

CC ID: 27962
Seq. Order: 29
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: 27963
Seq. Order: 30
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: 27964
Seq. Order: 31
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

date license was issued

General Data Type: DATE

UPDATE_ACTION

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

application specific code for type of update

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7301
GUID: gov.noaa.nmfs.inport:7301
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