PeriodsV[X] - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-10-15
dita:mapPath
yoz1556235523563.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.