LookupParticipantNameByEmployeeId
Summary
The LookupParticipantNameByEmployeeId helper function returns the xactly.xc_participant.name value for the specified employee_id input parameter.
Syntax
LookupParticipantNameByEmployeeId(<employee_id>) |
Return Type
String. Null if no match found.
Details
Use the function instead of writing explicit joins to the xactly.xc_participant table.
Examples
eval LookupParticipantNameByEmployeeId(‘005j000000AvTQCAA3‘);
select employee_id, LookupParticipantNameByEmployeeId(employee_id) as lkup_name
from staging.person;
