7301 DMS_RESTORE Entity Published / External 7291 Standardization Of Dealers Data Set 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 gov.noaa.nmfs.inport:7301 Lee Weinberger 2008-03-26T16:04:08 SysAdmin InPortAdmin 2022-08-09T17:11: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