PES_MACRO_TIMEPHASE_ATTRIBUTES_SELF

PES_MACRO_TIMEPHASE_ATTRIBUTES_SELF_CONTRIBUTION is used to get all the self-contributing buckets for the time phase attributes in the system converted into the requested storage unit (i.e. currency, hours, FTE or units). This macro is different from PES_MACRO_TIMEPHASE_ATTRIBUTE_DETAIL in that it returns all the self-contributing buckets (PES_MACRO_TIMEPHASE_ATTRIBUTE_DETAIL only returns self-contributing buckets that have been promoted to the detail object).

The parameters for this macro are:

Temporary table name
WHERE clause applied against the PES_TimephaseAttributes table such that only the binary data is extracted for timephased attributes
Storage unit; the possible values are ‘FTE’, ‘Currency’, ‘Hours’, ‘Units’

This example shows how to join with PES_MACRO_TIMEPHASE_ATTRIBUTE_DETAIL to show detail data along with all the self contribution values.

SELECT self.Start, self.Finish, self.Value, detail.Description
FROM PES_MACRO_TIMEPHASE_ATTRIBUTES_SELF_CONTRIBUTION (self, obj_UID = 49, Currency)
LEFT OUTER JOIN
PES_MACRO_TIMEPHASE_ATTRIBUTE_DETAIL (detail, obj_InvestmentUID = 49,
 Description) ON self.obj_BucketUID = detail.obj_UID