Hi there
I am trying to find the MAX EFFDT from PS_EMPLOYEES (alias EE) where ACTION = LOA. It appears that we have PAY and XFR actions when an employee is on Leave, so pulling the effdt date of the table is not getting me the correct information. Any help to guide me would be appreciated!
I am trying to find the MAX EFFDT from PS_EMPLOYEES (alias EE) where ACTION = LOA. It appears that we have PAY and XFR actions when an employee is on Leave, so pulling the effdt date of the table is not getting me the correct information. Any help to guide me would be appreciated!