PES_TimephaseAttributes

This table contains data for the timephased attributes.

Column	Data Type	Description
obj_UID	int	A unique identifier. Every record in the table has a unique ID.
dim_UID	tinyint	The ID of the dimension that this row’s data belongs to. Can join to PES_Dimension table.
att_UID	int	The ID of the attribute that this row’s data belongs to. Can join to PES_Attribute table.
tpa_BinData	image	Contains all the timephased attribute data for a given attribute / dimension combination. This data is stored in binary and requires a macro to extract it.

MACRO: PES_MACRO_ TIMEPHASE_ATTRIBUTES_TIMESCALE. For example:

SELECT * FROM PES_MACRO_TIMEPHASE_ATTRIBUTES_TIMESCALE (tmp, obj_UID = 281, Currency, Calendar Year, 1/1/2006,12/31/2007, true)