Navigation :

EQUITY_BUCKET_DESC

note

While this table is currently required in the DirectQuery database schema, it will be removed in a future version.

The EQUITY_BUCKET_DESC table provides canonical descriptions for the equity buckets.

Column Name	Type	Not Null	Cube Field	Description
AS_OF_DATE	DATE	Y	See field in joined table (UNDERLYING_DESCRIPTION)	Timestamp (at close of business) for the data.
RISK_CLASS	STRING	Y	See field in joined table (UNDERLYING_DESCRIPTION)	The risk-class (set to “Equity”)
BUCKET	STRING	Y	See field in joined table (UNDERLYING_DESCRIPTION)	The Bucket the Underlying belongs to.
MARKET_CAP_CATEGORY	STRING		Equity Market Cap Category	The canonical name for the bucket market cap.
ECONOMY_CATEGORY	STRING		Equity Economy Category	The canonical name for the bucket economy.
SECTOR_CATEGORY	STRING		Equity Sector Category	The canonical name for the bucket sector.

Unique Key

Columns
AS_OF_DATE
RISK_CLASS
BUCKET

Incoming Joins

Source Table	Source Columns	Target Columns
UNDERLYING_DESCRIPTION	AS_OF_DATE RISK_CLASS BUCKET	AS_OF_DATE RISK_CLASS BUCKET