Only Active records when using Termination

[DariusSoreata]

Hello @YSE-1 

I searched in the forum, but couldn't find a solution for my problem. 

I saw that a lot of people have the same problem, which is, when trying to view Terminations, all records are being shown as Active, yet in the system we have Terminated employees. The thing is, it's not about termination day, as a lot of employees have been terminated a few months ago. I saw something similar that I would like to try, but I'm not proficient in SQL.

Here Solved: Termination metric not capturing data - SAP Community What is the exact code that I would have to type in this measure? I tried deleting the EXC expression, but when I click validate then ok, nothing happens, when I open it again, it's the same expression. Nothing has changed. It even says with red "Measure saved successfully" yet the changes are not saved. 

I attached a screenshot from the system which shows that when selecting terminations and analyzing by Employment Status, they all show as Active. The Employment Statuses are correctly put in the system(at least, I think so, will upload a screenshot from Edit Hierarchies). I went to Drill to Detail and checked multiple Person IDs and they were terminated a few month ago, so I don't think the problem would be the -1 day logic.

Thank you!  

[DariusSoreata]

Hi @YSE-1 

Did some digging into the configuration and apparently, the Employment Status Dimension was different from what is in the Manual Implementation guide. It was like this, with the following SQL code: 

SELECT EMPLOYMENT_STATUS.EXTERNAL_CODE, EMPLOYMENT_STATUS.LABEL

FROM [%PICKLIST(PICKLIST__EMP_JOB_INFO_T.EMPLOYMENT_STATUS)%] EMPLOYMENT_STATUS

WHERE EMPLOYMENT_STATUS.LOCALE = 'en_GB'

After I changed it to what it looks like in the Manual Implementation Guide for Employment Status Dimension, it seems that the problem has been solved, as now I'm able to see employees with terminated status(see screenshot below). So for now, I believe this can be classified as the solution, at least for my configuration. Thank you for your help. 

[YSE-1]

Hi @DariusSoreata,

The If clause in the measure formula is used to filter certain termination where their event reason is mapped under Excluded category in Separation Reason dimension so they won't be counted in the measure.  Trying to remove that exclusion logic does not have anything to do with Termination showing with Active status.  Besides, there is no event reason mapped under Exclude category in Separation Reason, so that exclusion does not exclude any Terminations:

As for Termination showing with active status, the only explanation I have is with termination date logic.  When minus 1 day logic is used, the termination is reported on effective start date - 1 day and on this day, the employment status is still Active. 

The screen shot in your post showed termination in 2025.  When you say the employee already terminated a few months ago, is it still within 2025?  If still within 2025 then they will show on WFA site for Termination in 2025 with Active status.

[DariusSoreata]

Hi @YSE-1 , thank you for your quick reply! 🙂

I ran again a report on WFA.  From Workforce Mobility-Inputs-Termination with Analyse by Employment Status and I went to Drill to Detail and checked a few records. The first one for example it shows in WFA with Active status, but in EC, it's terminated in 1st of May 2024.(attached a screenshot with it). So therefore, by what you said, it should show as Terminated in WFA, yet it shows as Active. Also, do you think it could be a problem the fact that in WFA we have "Employment Status" while in EC we have "Employee Status"? Thank you for your help! 

[YSE-1]

@DariusSoreata - please check again what is the effective date for the Terminated status. It is said 1 May 2024. My assumption is there is termination event on 1 May 2024 as well. Since the termination date was setup with minus 1 day logic, the termination is reported on 30 April 2024. On 30 April, the employee status is Active.