16.20 - PeriodsV[X] - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

Category: Schema

Database: DBC

View Column Data Type Format Comment
DatabaseName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) PeriodsVX.DatabaseName is the name of the database in which the table having period column.
Table_Name VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) PeriodsVX.Table_Name is the name of the table in which period column exists.
Period_Name VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) PeriodsVX.Period_Name is the name of a period column in a table.
Fid SMALLINT NOT NULL ---,--9 PeriodsVX.Fid is the field id of a period column in a table.
Tid BYTE(6) NOT NULL X(12) PeriodsVX.Tid is the table id of the table in which period column exists.
DBid BYTE(4) NOT NULL X(8) PeriodsVX.DBid is the database id of the database in which the table is having period column.
START_COLUMN_NAME VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) PeriodsVX.START_COLUMN_NAME is the name of the begin column of a derived period, otherwise returns null.
END_COLUMN_NAME VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) PeriodsVX.END_COLUMN_NAME is the name of the end column of a derived period, otherwise returns null.