LookupPeriodIdByName
The LookupPeriodIdByName function returns the period_id for the given period name input parameter.
Syntax
LookupPeriodIdByName(<string>) |
Return Type
long
Details
The function returns the xactly.xc_period.period_id for the given period name input parameter. Null is returned if the period name does not exist.
Examples
eval LookupPeriodIdByName(‘APR-2016’);
select name from xactly.xc_period
where parent_period_id = (LookupPeriodIdByName(‘QTR-1-2016’));
