Table: DMS_RESTORE
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:7301 | Updated: August 9, 2022 | Published / External
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
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
|
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
City |
General Data Type: | VARCHAR2 |
STATE
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
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
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
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
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
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
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
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
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 |
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
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
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
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
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: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2021-05-06 |
Owner Org: | SEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2021-05-06 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2022-05-06 |