Help with Fast Formula to Check Element Entry
Summary:
Hello, we are currently trying to create a Fast Formula. The goal of this formula is to verify if a specific Element Entry is associated with the employee. However, we are facing an issue in getting the correct result.
Content (please ensure you mask any confidential information):
Value Set.
FROM Clause: per_all_assignments_m paam,pay_element_entries_f peef,pay_element_types_f petf,pay_input_values_f pivf ,pay_element_entry_values_f peevf
Value Column Name: TO_CHAR(peevf.screen_entry_Value)
WHERE Clause:
1=1
AND paam.person_id = :{PARAMETER.PersonId}
and paam.assignment_type in ('E','C')