LookupParticipantIdByEmployeeId
Summary
The LookupParticipantIdByEmployeeId function returns thexactly.xc_participant.participant_id value for the given string input parameter.
Syntax
LookupParticipantIdByEmployeeId(<employee_id>) |
Return Type
Long
Details
The function returns null if the input parameter does not match a value in xactly.xc_participant.employee_id.
Examples
eval LookupParticipantIdByEmployeeId(‘S0002345’);
select employee_id,
LookupParticipantIdByEmployeeId(employee_id)
from staging.order_item_assignment;
Related Functions
LookupParticipantNameByEmployeeId