Table: DMS_DLR_CODES_HISTORY
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:7297 | Updated: August 9, 2022 | Published / External
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
|
|
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: | 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 |