Skip to main content

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?

Hi ​@emiller3061,

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

Thank you, ​@Abdul!

Reply


Terms & ConditionsCookie settings