Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Fisheries Statistics Division > FISHERIES MONITORING > Standardization of permits > Dealer Management System > Standardization Of Dealers >

Table: DMS_UPDATE_LOG

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:7303  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

table stores history log of updates to dms

Description

table stores history log of updates to dms

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
UPDATE_ID
VARCHAR2 		identifier referring to a particular update/upload
UPDATE_DATE
DATE 		date update occurred
DATA_SOURCE
VARCHAR2 		Code for state/commission that provided the dealer information
FILE_ID
VARCHAR2 		identifier referring to an uploaded file
FILE_NAME
VARCHAR2 		uploaded file name
FILE_DESC
VARCHAR2 		uploaded file content description
PERIOD
VARCHAR2 		file data is either 'Current' or 'Historical'
USER_NAME
VARCHAR2 		user that uploaded the file

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

Item Identification

Title: Table: DMS_UPDATE_LOG
Short Name: DMS_UPDATE_LOG
Status: Completed
Abstract:

table stores history log of updates to dms
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 log of updates to dms

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key UPDATE_ID VARCHAR2 identifier referring to a particular update/upload
100
 UPDATE_DATE DATE date update occurred
100
 DATA_SOURCE VARCHAR2 Code for state/commission that provided the dealer information
100
 FILE_ID VARCHAR2 identifier referring to an uploaded file
100
 FILE_NAME VARCHAR2 uploaded file name
100
 FILE_DESC VARCHAR2 uploaded file content description
100
 PERIOD VARCHAR2 file data is either 'Current' or 'Historical'
100
 USER_NAME VARCHAR2 user that uploaded the file

Attribute Details

UPDATE_ID

CC ID: 27974
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 15
Required: Yes
Primary Key: Yes
Status: Active
Description:

identifier referring to a particular update/upload
General Data Type: VARCHAR2

UPDATE_DATE

CC ID: 27975
Seq. Order: 2
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

date update occurred
General Data Type: DATE

DATA_SOURCE

CC ID: 27976
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

FILE_ID

CC ID: 27977
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 15
Required: Yes
Primary Key: No
Status: Active
Description:

identifier referring to an uploaded file
General Data Type: VARCHAR2

FILE_NAME

CC ID: 27978
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

uploaded file name
General Data Type: VARCHAR2

FILE_DESC

CC ID: 27979
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 250
Required: No
Primary Key: No
Status: Active
Description:

uploaded file content description
General Data Type: VARCHAR2

PERIOD

CC ID: 27980
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 12
Required: Yes
Primary Key: No
Status: Active
Description:

file data is either 'Current' or 'Historical'
General Data Type: VARCHAR2

USER_NAME

CC ID: 27981
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

user that uploaded the file
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7303
GUID: gov.noaa.nmfs.inport:7303
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