7303
Table: DMS_UPDATE_LOG
DMS_UPDATE_LOG
Entity
Published / External
7291
Standardization Of Dealers
Data Set
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
gov.noaa.nmfs.inport:7303
Lee Weinberger
2008-03-26T16:04:09
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