IsValidEmployeeId
Summary
The IsValidEmployeeId function checks whether the given employee_id exists in xactly.xc_participant.employee_id.
Syntax
IsValidEmployeeId(<employee_id>) |
Return Type
Boolean
Details
One possible use case is to call the function when performing data validations prior to uploading staging.sales_order_assignment rows into Incent. The function may obviate the need to explicitly join to xactly.xc_participant for certain use cases.
Examples
eval IsValidEmployeeId(‘abc123-bogus_id’);
select IsValidEmployeeId(employee_id) as emp_exists, count(*)
from staging.order_item_assignment;
