LookupPeriodTypeByPeriodName
The LookupPeriodTypeByPeriodName function returns the xactly.xc_period_type.name
value for the corresponding period name given in the input parameter.
Syntax
LookupPeriodTypeByPeriodName(<string>) |
Return Type
String
Details
The function returns null if the period name input parameter does not tie to a valid Incent period.
Examples
eval LookupPeriodTypeByPeriodName(‘APR-2016’);
select name, start_date, end_date, period_type_id_fk
from xactly.xc_period
where LookupPeriodTypeByPeriodName(name) = ‘MONTHLY’;