17.00 - PeriodsV[X] - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

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.