You are currently viewing Query to get FTE in Oracle Fusion HCM Cloud

Query to get FTE in Oracle Fusion HCM Cloud

Below Query will help us fetch the FTE Values for assignments in Oracle Fusion HCM Cloud

SQL
				SELECT paam.assignment_number,
       pawmf.value FTE
FROM   per_assign_work_measures_f pawmf,
       per_all_assignments_m paam
WHERE  1 = 1
       AND paam.assignment_id = pawmf.assignment_id
       AND pawmf.unit = 'FTE'
       AND paam.assignment_type = 'E'
       AND TRUNC(SYSDATE) BETWEEN paam.effective_start_date AND paam.effective_end_date
       AND TRUNC(SYSDATE) BETWEEN pawmf.effective_start_date AND pawmf.effective_end_date

Below is the sample output of the Query which fetches the Assignment Number and the corresponding FTE Value