How can I check an employee’s status for a specific date in a PL/SQL script? Is there an API call that will provide that information? I’m struggling to find it. I can find the call to see their current status, but what about a previous employment period?
Solved
SQL Check Employee Status for Date
+4Best answer by Abdul
Hi
You can check Employees’ status for a specific date with below select statement.
SELECT EMPLOYEE_STATUS_DETAILS_API.GET_STATUS('&Company','&Emp_no',TO_DATE('&Valid_From','DD/MM/YYYY')) STATUS FROM DUAL
Regards
Abdul Rehman
+20Hi
You can check Employees’ status for a specific date with below select statement.
SELECT EMPLOYEE_STATUS_DETAILS_API.GET_STATUS('&Company','&Emp_no',TO_DATE('&Valid_From','DD/MM/YYYY')) STATUS FROM DUAL
Regards
Abdul Rehman
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.