Query for all active employees in a year
Hi
Please assist with a SQL query for all employees with person-type: "Employee" active within 2023, 01-Jan-2023 to 31-Dec-2023 only.
is there a standard report on EBS that can pull this information?
Also how to get the Original Assignment Start date of an employee? (using Assignment effective_start_date takes into consideration any change made on the assignment)
Kind regards
Sylvester