PeriodsV[X] - Teradata VantageCloud Lake

Lake - Database Reference

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
ohi1683672393549.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
ohi1683672393549

Category: Schema

Database: DBC

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