LookupPeriodNameById
Summary
The LookupPeriodNameById function returns the period name from the xactly.xc_period table for the corresponding period_id expression given in the input parameter.
Syntax
LookupPeriodNameById(<numeric>) |
Return Type
String
Details
The function matches the input parameter to xactly.xc_period.period_id. It returns null if no match is found.
Examples
select period_id,
LookupPeriodNameById(period_id),
count(*)
from xactly.xc_order_stage;
Related Functions
LookupPeriodIdByBatchName