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’);

screen-shot-2016-10-21-at-10-27-42-am

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

screen-shot-2016-10-21-at-10-27-35-am

 

Related Functions

LookupPeriodIdByBatchName

LookupPeriodIdByName

LookupPeriodName

LookupPeriodTypeById