LookupPeriodTypeById

The LookupPeriodTypeById function returns the xactly.xc_period_type.name value for the corresponding period_type_id given in the input parameter.

LookupPeriodTypeById(<long>)

String

The function returns null if the period_type_id input parameter is not found in xactly.xc_period_type.period_type_id.

eval LookupPeriodTypeById(858599122);

screen-shot-2016-10-21-at-10-31-25-am

select name, start_date, end_date, period_type_id_fk
from xactly.xc_period
where LookupPeriodTypeById(period_type_id_fk) = ‘QUARTERLY’;

screen-shot-2016-10-21-at-10-31-19-am