7291
Standardization Of Dealers
Standardization Of Dealers
Data Set
Published / External
3834
Dealer Management System
Project
In Work
The dealer management system (DMS) is a data warehouse that stores federal and state dealer permit and license information. The issuing agency, whether it is a state or federal agency, provides information on the seafood businesses, i.e., company name, mailing/physical address, telephone and license/permit number, to the Southeast Fisheries Science Center and these data are stored in the DMS. The system is developed to identify multiple records for the same dealer, i.e., dealers that have licenses or permits that are issued by different agencies. These separate dealer codes are linked such that the separate licenses/permits can be identified for the same dealer.
Although the DMS was developed in 2004, the data in the warehouse begin in 1999.
This system was developed to meet several purposes. First, it provides a verification table for all valid dealer codes, either state or federally issued, against which other databases are validated. Second, the DMS provides a cross-reference for all permit and/or license numbers issued to the same dealer or business. This cross-reference provides the link between data collected for and stored in multiple data collection programs. For example, through the DMS, data collected to monitor a specific fishery quota can easily be verified against the general canvass data in the Accumulative Landings System (ALS). Third, it allows users, especially economists and other analysts to identify the location of the initial transaction between the fishermen and the purchaser to geographic localities more precise than the county aggregations that are available in the ALS. This association provides the ability to associate fisheries data, whether it is landings data, size frequency data, catch per unit effort data, etc., with the dealer where the seafood product is landed. Lastly, the DMS also provides current contact information for participating dealers.
Theme
PARR Exclusion
Non-Environmental Data
Theme
address
Theme
dealers
Theme
federal
Theme
fishdep
Theme
fishery-dependent
Theme
permits
Theme
standardization
Theme
state dealer permits
Spatial
Alabama
Spatial
Florida
Spatial
Georgia
Spatial
Louisiana
Spatial
Mississippi
Spatial
North Carolina
Spatial
SE United States
Spatial
South Carolina
Spatial
Texas
Stratum
state
Southeast Fisheries Science Center
Miami
FL
USA
Data Set
Database
As Needed
Table (digital)
N/A
N/A
N/A
7292
Table: DATA_SOURCE
DATA_SOURCE
Published / External
Completed
Table Of Data Sources, Mnemonic Abbreviations For The data Sources , and a Longer description for the Dealer Management
Loaded by batch 2163, 03-26-2008 16:04
Data Table
Yes
DMS
Table Of Data Sources, Mnemonic Abbreviations For The data Sources , and a Longer description for the Dealer Management
1
DATA_SOURCE
VARCHAR2
4
Yes
Yes
Active
Primary Key of This table. Code for state/commission that provided the dealer information
VARCHAR2
2
DS_ABBREV
VARCHAR2
10
Yes
No
Active
Mnemonic Abbreviation For The Data Source
VARCHAR2
3
DS_NAME
VARCHAR2
100
Yes
No
Active
Complete Data Source Name
VARCHAR2
7293
Table: DMS_ADDRESSES
DMS_ADDRESSES
Published / External
Completed
table stores current address info for dms dealers
Loaded by batch 2163, 03-26-2008 16:04
Data Table
Yes
DMS
table stores current address info for dms dealers
1
DMS_KEY
VARCHAR2
15
Yes
No
Active
Main application key for uniquely identifying dealers
VARCHAR2
2
ADDRESS_TYPE
VARCHAR2
1
Yes
No
Active
'P' for physical address, 'M' for mailing, 'U' for unknown
VARCHAR2
3
ADDRESS_1
VARCHAR2
50
No
No
Active
First Line of The Street Address
VARCHAR2
4
ADDRESS_2
VARCHAR2
50
No
No
Active
Second Line Of Street Address (may be null)
VARCHAR2
5
ADDRESS_3
VARCHAR2
50
No
No
Active
Third Line Of Street Address (may be null)
VARCHAR2
6
CITY
VARCHAR2
30
No
No
Active
City
VARCHAR2
7
STATE
VARCHAR2
2
No
No
Active
State
VARCHAR2
8
POSTAL_CODE
VARCHAR2
10
No
No
Active
ZIp Code
VARCHAR2
9
PORT
VARCHAR2
15
No
No
Active
Port of landing according to dealer location
VARCHAR2
10
NMFS_CNTY
VARCHAR2
2
No
No
Active
NMFS County Code Associated With The Address
VARCHAR2
11
FIPS_CNTY
VARCHAR2
3
No
No
Active
FIPS County Code Associated With The Address
VARCHAR2
12
NMFS_ST
VARCHAR2
2
No
No
Active
NMFS State Code Associated With The Address
VARCHAR2
13
FIPS_ST
VARCHAR2
2
No
No
Active
FIPS State Code Associated With the address
VARCHAR2
7294
Table: DMS_ADDRESS_ABRV
DMS_ADDRESS_ABRV
Published / External
Completed
Table That takes a name or abbreviation and converts it to a standard abbreviation
Loaded by batch 2163, 03-26-2008 16:04
Data Table
Yes
DMS
Table That takes a name or abbreviation and converts it to a standard abbreviation
1
NAME
VARCHAR2
20
Yes
Yes
Active
STREET DESIGNATOR, PREFIX OR SUFFIX FULLNAME OR VARIANT
VARCHAR2
2
ABBRV
VARCHAR2
10
Yes
No
Active
DMS ABBREVIATION
VARCHAR2
7295
Table: DMS_ALIASES
DMS_ALIASES
Published / External
Completed
table stores alternate names for dms dealers
Loaded by batch 2163, 03-26-2008 16:04
Data Table
Yes
DMS
table stores alternate names for dms dealers
1
DMS_KEY
VARCHAR2
15
Yes
No
Active
Main application key for uniquely identifying dealers
VARCHAR2
2
ALIAS_NAME
VARCHAR2
50
No
No
Active
Alternate name for dealer
VARCHAR2
7296
Table: DMS_DEALERS
DMS_DEALERS
Published / External
Completed
table stores current dms dealer personal/contact info
Loaded by batch 2163, 03-26-2008 16:04
Data Table
Yes
DMS
table stores current dms dealer personal/contact info
1
DMS_KEY
VARCHAR2
15
Yes
Yes
Active
Main application key for uniquely identifying dealers
VARCHAR2
2
EIN_SSN
VARCHAR2
15
No
No
Active
employer id/social security number
VARCHAR2
3
CORP_NAME
VARCHAR2
50
No
No
Active
business name
VARCHAR2
4
LAST_NAME
VARCHAR2
40
No
No
Active
owner last name
VARCHAR2
5
FIRST_NAME
VARCHAR2
40
No
No
Active
owner first name
VARCHAR2
6
MIDDLE_NAME
VARCHAR2
40
No
No
Active
owner middle name
VARCHAR2
7
NAME_SUFFIX
VARCHAR2
3
No
No
Active
name suffix (e.g. jr, sr, etc)
VARCHAR2
8
BIRTH_DATE
DATE
7
No
No
Active
owner birth date
DATE
9
CONTACT_LAST_NAME
VARCHAR2
40
No
No
Active
business contact person last name
VARCHAR2
10
CONTACT_FIRST_NAME
VARCHAR2
40
No
No
Active
business contact person first name
VARCHAR2
11
PHONE_NBR
VARCHAR2
20
No
No
Active
contact tel. phone number
VARCHAR2
12
FAX_NBR
VARCHAR2
20
No
No
Active
contact fax number
VARCHAR2
13
EMAIL
VARCHAR2
50
No
No
Active
contact email address
VARCHAR2
14
RSLVD
VARCHAR2
1
Yes
No
Active
'N' = ambiguous entities (reqires more research), 'Y' = dealer is resolved
VARCHAR2
7297
Table: DMS_DLR_CODES_HISTORY
DMS_DLR_CODES_HISTORY
Published / External
Completed
table stores history of permit codes with related address info for dms dealers
Loaded by batch 2163, 03-26-2008 16:04
Data Table
Yes
DMS
table stores history of permit codes with related address info for dms dealers
1
DMS_KEY
VARCHAR2
15
Yes
No
Active
Main application key for uniquely identifying dealers
VARCHAR2
2
DLR_CODE
VARCHAR2
15
Yes
No
Active
State, federal or commission dealer permit code issued to the dealer
VARCHAR2
3
DATA_SOURCE
VARCHAR2
4
Yes
No
Active
Code for state/commission that provided the dealer information
VARCHAR2
4
LIC_MONTH
NUMBER
22
No
No
2
0
Active
license issued month (where applicable)
NUMBER
5
LIC_YR
NUMBER
22
No
No
4
0
Active
license issued year
NUMBER
6
LIC_ISS_DATE
DATE
7
No
No
Active
date license was issued
DATE
7
ADDRESS_TYPE
VARCHAR2
1
No
No
Active
'P' for physical address, 'M' for mailing, 'U' for unknown
VARCHAR2
8
ADDRESS_1
VARCHAR2
50
No
No
Active
First Line of The Street Address
VARCHAR2
9
ADDRESS_2
VARCHAR2
50
No
No
Active
Second Line Of Street Address (may be null)
VARCHAR2
10
ADDRESS_3
VARCHAR2
50
No
No
Active
Third Line Of Street Address (may be null)
VARCHAR2
11
CITY
VARCHAR2
30
No
No
Active
City
VARCHAR2
12
STATE
VARCHAR2
30
No
No
Active
State
VARCHAR2
13
POSTAL_CODE
VARCHAR2
10
No
No
Active
ZIp Code
VARCHAR2
14
PORT
VARCHAR2
30
No
No
Active
Port of landing according to dealer location
VARCHAR2
15
NMFS_CNTY
VARCHAR2
2
No
No
Active
NMFS County Code Associated With The Address
VARCHAR2
16
FIPS_CNTY
VARCHAR2
3
No
No
Active
FIPS County Code Associated With The Address
VARCHAR2
17
NMFS_ST
VARCHAR2
2
No
No
Active
NMFS State Code Associated With The Address
VARCHAR2
18
FIPS_ST
VARCHAR2
2
No
No
Active
FIPS State Code Associated With the address
VARCHAR2
7298
Table: DMS_DLR_NOTES
DMS_DLR_NOTES
Published / External
Completed
table stores pertinent notes for dms dealers
Loaded by batch 2163, 03-26-2008 16:04
Data Table
Yes
DMS
table stores pertinent notes for dms dealers
1
DMS_KEY
VARCHAR2
15
Yes
Yes
Active
Main application key for uniquely identifying dealers
VARCHAR2
2
NOTES
VARCHAR2
1000
No
No
Active
Pertinent notes about the dealer
VARCHAR2
7299
Table: DMS_FLGD_LOG
DMS_FLGD_LOG
Published / External
Completed
table stores dms keys for unresolved dealers
Loaded by batch 2163, 03-26-2008 16:04
Data Table
Yes
DMS
table stores dms keys for unresolved dealers
1
UPDATE_ID
VARCHAR2
15
Yes
No
Active
identifier referring to a particular update/upload
VARCHAR2
2
DMS_KEY
VARCHAR2
15
Yes
No
Active
Main application key for uniquely identifying dealers
VARCHAR2
7300
Table: DMS_LOCATION_GRP
DMS_LOCATION_GRP
Published / External
Completed
table stores dms keys for grouping of dealers
Loaded by batch 2163, 03-26-2008 16:04
Data Table
Yes
DMS
table stores dms keys for grouping of dealers
1
DMS_KEY
VARCHAR2
15
Yes
No
Active
Main application key for uniquely identifying dealers
VARCHAR2
2
GRP_NAME
VARCHAR2
100
Yes
No
Active
name & key given for a group of dealers, of the same entity
VARCHAR2
7301
Table: DMS_RESTORE
DMS_RESTORE
Published / External
Completed
table stores replaced data for the past 25 updates, for restore purposes
Loaded by batch 2163, 03-26-2008 16:04
Data Table
Yes
DMS
table stores replaced data for the past 25 updates, for restore purposes
1
UPDATE_ID
VARCHAR2
15
Yes
No
Active
identifier referring to a particular update/upload, key for restoring dealer data for dms (undoing updates)
VARCHAR2
2
DMS_KEY
VARCHAR2
15
Yes
No
Active
Main application key for uniquely identifying dealers
VARCHAR2
3
DATA_SOURCE
VARCHAR2
4
No
No
Active
Code for state/commission that provided the dealer information
VARCHAR2
4
DLR_CODE
VARCHAR2
15
No
No
Active
State, federal or commission dealer permit code issued to the dealer
VARCHAR2
5
EIN_SSN
VARCHAR2
15
No
No
Active
employer id/social security number
VARCHAR2
6
CORP_NAME
VARCHAR2
50
No
No
Active
business name
VARCHAR2
7
LAST_NAME
VARCHAR2
40
No
No
Active
owner last name
VARCHAR2
8
FIRST_NAME
VARCHAR2
40
No
No
Active
owner first name
VARCHAR2
9
MIDDLE_NAME
VARCHAR2
40
No
No
Active
owner middle name
VARCHAR2
10
NAME_SUFFIX
VARCHAR2
3
No
No
Active
name suffix (e.g. jr, sr, etc)
VARCHAR2
11
BIRTH_DATE
DATE
7
No
No
Active
owner birth date
DATE
12
CONTACT_LAST_NAME
VARCHAR2
40
No
No
Active
business contact person last name
VARCHAR2
13
CONTACT_FIRST_NAME
VARCHAR2
40
No
No
Active
business contact person first name
VARCHAR2
14
ADDRESS_TYPE
VARCHAR2
1
No
No
Active
'P' for physical address, 'M' for mailing, 'U' for unknown
VARCHAR2
15
ADDRESS_1
VARCHAR2
50
No
No
Active
First Line of The Street Address
VARCHAR2
16
ADDRESS_2
VARCHAR2
50
No
No
Active
Second Line Of Street Address (may be null)
VARCHAR2
17
ADDRESS_3
VARCHAR2
50
No
No
Active
Third Line Of Street Address (may be null)
VARCHAR2
18
CITY
VARCHAR2
30
No
No
Active
City
VARCHAR2
19
STATE
VARCHAR2
30
No
No
Active
State
VARCHAR2
20
POSTAL_CODE
VARCHAR2
10
No
No
Active
ZIp Code
VARCHAR2
21
PORT
VARCHAR2
15
No
No
Active
Port of landing according to dealer location
VARCHAR2
22
NMFS_CNTY
VARCHAR2
2
No
No
Active
NMFS County Code Associated With The Address
VARCHAR2
23
FIPS_CNTY
VARCHAR2
3
No
No
Active
FIPS County Code Associated With The Address
VARCHAR2
24
NMFS_ST
VARCHAR2
2
No
No
Active
NMFS State Code Associated With The Address
VARCHAR2
25
FIPS_ST
VARCHAR2
2
No
No
Active
FIPS State Code Associated With the address
VARCHAR2
26
PHONE_NBR
VARCHAR2
20
No
No
Active
contact tel. phone number
VARCHAR2
27
FAX_NBR
VARCHAR2
20
No
No
Active
contact fax number
VARCHAR2
28
EMAIL
VARCHAR2
50
No
No
Active
contact email address
VARCHAR2
29
LIC_MONTH
NUMBER
22
No
No
2
0
Active
license issued month (where applicable)
NUMBER
30
LIC_YR
NUMBER
22
No
No
4
0
Active
license issued year
NUMBER
31
LIC_ISS_DATE
DATE
7
No
No
Active
date license was issued
DATE
32
UPDATE_ACTION
VARCHAR2
8
Yes
No
Active
application specific code for type of update
VARCHAR2
7302
Table: DMS_ST_CNTY_CODE_XREF
DMS_ST_CNTY_CODE_XREF
Published / External
Completed
state/county cross reference table
Loaded by batch 2163, 03-26-2008 16:04
Data Table
Yes
DMS
state/county cross reference table
1
STATE_ABRV
VARCHAR2
2
No
No
Active
state abbreviation
VARCHAR2
2
STATE_NAME
VARCHAR2
21
No
No
Active
state name
VARCHAR2
3
COUNTY_NAME
VARCHAR2
37
No
No
Active
county name
VARCHAR2
4
STATE
VARCHAR2
2
Yes
No
Active
fips state code
VARCHAR2
5
COUNTY
VARCHAR2
3
Yes
No
Active
fips county code
VARCHAR2
6
NMFS_STATE
VARCHAR2
2
No
No
Active
nmfs state code
VARCHAR2
7
NMFS_COUNTY
VARCHAR2
3
No
No
Active
nmfs county code
VARCHAR2
8
REGION
VARCHAR2
1
No
No
Active
region code
VARCHAR2
7303
Table: DMS_UPDATE_LOG
DMS_UPDATE_LOG
Published / External
Completed
table stores history log of updates to dms
Loaded by batch 2163, 03-26-2008 16:04
Data Table
Yes
DMS
table stores history log of updates to dms
1
UPDATE_ID
VARCHAR2
15
Yes
Yes
Active
identifier referring to a particular update/upload
VARCHAR2
2
UPDATE_DATE
DATE
7
Yes
No
Active
date update occurred
DATE
3
DATA_SOURCE
VARCHAR2
4
Yes
No
Active
Code for state/commission that provided the dealer information
VARCHAR2
4
FILE_ID
VARCHAR2
15
Yes
No
Active
identifier referring to an uploaded file
VARCHAR2
5
FILE_NAME
VARCHAR2
50
Yes
No
Active
uploaded file name
VARCHAR2
6
FILE_DESC
VARCHAR2
250
No
No
Active
uploaded file content description
VARCHAR2
7
PERIOD
VARCHAR2
12
Yes
No
Active
file data is either 'Current' or 'Historical'
VARCHAR2
8
USER_NAME
VARCHAR2
50
Yes
No
Active
user that uploaded the file
VARCHAR2
7304
Table: DMS_UPLOADED_DLR_FILES
DMS_UPLOADED_DLR_FILES
Published / External
Completed
table stores dealer data from files
Loaded by batch 2163, 03-26-2008 16:04
Data Table
Yes
DMS
table stores dealer data from files
1
FILE_ID
VARCHAR2
15
Yes
No
Active
identifier referring to an uploaded file
VARCHAR2
2
ROW_NUM
NUMBER
22
Yes
No
38
Active
row number for specific file record
NUMBER
3
ROW_CONTENT
VARCHAR2
1200
No
No
Active
contents of specific file record
VARCHAR2
7305
Table: DMS_USERS
DMS_USERS
Published / External
Completed
List Of AUthorized Users For The Dealer Management System
Loaded by batch 2163, 03-26-2008 16:04
Data Table
Yes
DMS
List Of AUthorized Users For The Dealer Management System
1
ROLE_CODE
VARCHAR2
4
Yes
No
Active
9999 for administrator, 1000 for quality assurance, 2000 reports only
VARCHAR2
2
USER_NAME
VARCHAR2
50
Yes
No
Active
Name Of User
VARCHAR2
3
USER_PWD
VARCHAR2
15
Yes
No
Active
User Password
VARCHAR2
4
EMAIL
VARCHAR2
50
No
No
Active
User email address
VARCHAR2
5
PHONE_NBR
VARCHAR2
20
No
No
Active
User Phone
VARCHAR2
6
NOTES
VARCHAR2
250
No
No
Active
Extra Notes On User
VARCHAR2
7
USER_ID
VARCHAR2
4
Yes
Yes
Active
Oracle Id Of The User
VARCHAR2
7331
Table: ZIP_CODE_DATA
ZIP_CODE_DATA
Published / External
Completed
comprehensive zip code table, for cross referencing purpose
Loaded by batch 2163, 03-26-2008 16:04
Data Table
Yes
DMS
comprehensive zip code table, for cross referencing purpose
1
CDC
VARCHAR2
1
No
No
Active
Coded Value
VARCHAR2
2
ZIP_CODE
VARCHAR2
5
Yes
No
Active
five digit zip code
VARCHAR2
3
CITY_STATE_KEY
VARCHAR2
6
No
No
Active
Control key For City State Combination
VARCHAR2
4
ZIP_CLASS_CODE
VARCHAR2
1
No
No
Active
Zip Code Class Code
VARCHAR2
5
CITY_STATE_NAME
VARCHAR2
28
No
No
Active
city name
VARCHAR2
6
CITY_STATE_NAME_ABBREV
VARCHAR2
13
No
No
Active
abbreviated city state name
VARCHAR2
7
CTYST_NAME_FACILITY_CODE
VARCHAR2
1
No
No
Active
County State Name Facility Code
VARCHAR2
8
CTYST_MAILING_NAME_IND
VARCHAR2
1
No
No
Active
County State Mailing Name Indicator
VARCHAR2
9
PREFD_LAST_LINE_CTYST_KEY
VARCHAR2
6
No
No
Active
Preffered Last Line County State Key
VARCHAR2
10
PREFD_LAST_LINE_CTYST_NAM
VARCHAR2
28
No
No
Active
Preffered Last Line County State Name
VARCHAR2
11
CTYST_DELVVV_IND
VARCHAR2
1
No
No
Active
Control Column
VARCHAR2
12
CARR_RTE_RATE_SORT_IND
VARCHAR2
1
No
No
Active
Sorting Indicator
VARCHAR2
13
UNIQUE_ZIP_NAME_INC
VARCHAR2
1
No
No
Active
Control Column (often blank)
VARCHAR2
14
FINANCE_NO
VARCHAR2
6
No
No
Active
Finance Number
VARCHAR2
15
STATE_ABBREV
VARCHAR2
2
No
No
Active
state abbreviation
VARCHAR2
16
COUNTY_NO
VARCHAR2
3
No
No
Active
fips county code
VARCHAR2
17
COUNTY_NAME
VARCHAR2
25
No
No
Active
county name
VARCHAR2
18
LOAD_DATE
DATE
7
No
No
Active
FIN specific load date
DATE
Data Steward
2018
Person
Gloeckner, David
David.Gloeckner@noaa.gov
75 Virginia Beach Drive
Miami
FL
33139
305-361-4257
305-361-4460
Data Steward
2006-01-01
2018
Person
Turner, Steve C
Distributor
2006
Organization
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
https://www.fisheries.noaa.gov/about/southeast-fisheries-science-center
About SEFSC
Online Resource
8:00 a.m. - 4:30 p.m. EST
Metadata Contact
2006
Person
Gloeckner, David
David.Gloeckner@noaa.gov
75 Virginia Beach Drive
Miami
FL
33139
305-361-4257
305-361-4460
Point of Contact
2016
Person
Judge, Michael
Michael.Judge@noaa.gov
75 Virginia Beach Drive
Miami
FL
33149
305-361-4235
305-361-4562
The Southeastern Coastline of the United States from North Carolina through Texas. Puerto Rico and US Virgin Islands listed separately.
The Southeastern US coastline out to 200 nm from North Carolina through Texas. Puerto Rico and USVI listed separately.
Continuing
2004
US Dealers who buy fish caught in federal, state or international waters
Sensitive
Contact Data Steward
Waiver required, though dealers may access their own data
Files are examined for matches. The matches can be confirmed by contacting the dealers in question
No
Unknown
No
Yes
365
To Be Determined
365
tbd
Dealers are matched
7292
Entity
Table: DATA_SOURCE
7293
Entity
Table: DMS_ADDRESSES
7294
Entity
Table: DMS_ADDRESS_ABRV
7295
Entity
Table: DMS_ALIASES
7296
Entity
Table: DMS_DEALERS
7297
Entity
Table: DMS_DLR_CODES_HISTORY
7298
Entity
Table: DMS_DLR_NOTES
7299
Entity
Table: DMS_FLGD_LOG
7300
Entity
Table: DMS_LOCATION_GRP
7301
Entity
Table: DMS_RESTORE
7302
Entity
Table: DMS_ST_CNTY_CODE_XREF
7303
Entity
Table: DMS_UPDATE_LOG
7304
Entity
Table: DMS_UPLOADED_DLR_FILES
7305
Entity
Table: DMS_USERS
7306
Entity
Table: TEMP_CMBND_DLRS
7307
Entity
Table: TEMP_CMBND_DLRS_ALIASES
7308
Entity
Table: TEMP_CMBND_DLRS_HIST
7309
Entity
Table: TEMP_CMBND_DLRS_STG
7310
Entity
Table: TEMP_DEALERS
7311
Entity
Table: TEMP_DISCARDED_DLRS
7312
Entity
Table: TEMP_DMS_GRP
7313
Entity
Table: TEMP_DMS_GRP_MNL
7314
Entity
Table: TEMP_DMS_MRG_MNL
7315
Entity
Table: TEMP_FILE_GRP
7316
Entity
Table: TEMP_FLAGGED_DLRS
7317
Entity
Table: TEMP_MATCH_ADDRESS
7318
Entity
Table: TEMP_MATCH_DLR_ID
7319
Entity
Table: TEMP_MATCH_EIN_SSN
7320
Entity
Table: TEMP_MATCH_IDENT
7321
Entity
Table: TEMP_MATCH_PHN_NBR
7322
Entity
Table: TEMP_MATCH_TYPO
7323
Entity
Table: TEMP_MERGED_DLRS
7324
Entity
Table: TEMP_MERGED_DLRS_STG
7325
Entity
Table: TEMP_UNIQUE_DLRS
7326
Entity
Table: TEMP_UNIQUE_DLRS_DMS
7327
Entity
Table: TEMP_UNIQUE_DLRS_RSLVD
7328
Entity
Table: TEMP_UPDATE_AUTO_DLR_CODE
7329
Entity
Table: TEMP_UPDATE_AUTO_DLR_DATA
7330
Entity
Table: TEMP_UPDATE_DLRS_DMS
7331
Entity
Table: ZIP_CODE_DATA
gov.noaa.nmfs.inport:7291
Lee Weinberger
2008-03-26T16:00:54
Bryson Anderson
2023-01-27T17:28:01
2021-05-06
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
www.sefsc.noaa.gov
8:00 a.m. - 4:30 p.m. EST
1001
Public
No
2021-05-06
1 Year
2022-05-06