7291 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 https://ror.org/0396y0w87 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 7293 Entity 7294 Entity 7295 Entity 7296 Entity 7297 Entity 7298 Entity 7299 Entity 7300 Entity 7301 Entity 7302 Entity 7303 Entity 7304 Entity 7305 Entity 7331 Entity gov.noaa.nmfs.inport:7291 Lee Weinberger 2008-03-26T16:00:54 SysAdmin InPortAdmin 2026-03-04T19:17:18 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 No 2021-05-06 1 Year 2022-05-06