Search Help Show/Hide Menu
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