15.10 - ResolvedDTSV[X] - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Schema

DBC

 

View Column

Data Type

Format

Source Table.Column

ResolvedCurrent_Date

DATE

YY/MM/DD

TableConstraints.ResolvedCurrent_Date

ResolvedCurrent_TimeStamp

TIMESTAMP(6) WITH TIME ZONE

YYYY-MM-DDBHH:MI:SS.S(F)Z

TableConstraints.ResolvedCurrent_TimeStamp

TableName

VARCHAR(128)

UNICODE

NOT NULL

X(128)

TVM.TableName

DatabaseName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

Possible Values for ResolvedCurrent_TimeStamp and ResolvedCurrent_Date

  • This is the last reconciled timestamp or date if the object is a join index or a table that is defined using:
  • CURRENT_TIMESTAMP
  • CURRENT_DATE or DATE
  • Either the partition, JI definition, or temporal table has a system-defined join index.

  • NULL in all other cases.
  • The following SELECT statement selects the last resolved date from the ResolvedDTSV view:

    ==> SELECT ResolvedCurrent_Date 
        FROM ResolvedDTSV
        WHERE TableName='Customer'
        AND DatabaseName='Sales'
        AND ResolvedCurrent_Date IS NOT NULL;

    The query returns the following result:

    ResolvedCurrent_Date
    --------------------
                09/01/01