I need a query to show all the times an employee went from fulltime to parftime and vice versa.
Oracle HRMS EBS version 12
Anyone have a query that would show all the times an employee went from fulltime to parttime and vice versa?
Example:
Emp 1234 went from FTP to PTP 25-feb-24.
Emp 1234 went from PTP to FTP 13-mar-23
Emp 1234 went from PTT to PTP 13-dec-22