Add Time dimension for Seniority Subject Area

Sam Reinhart

We would like to see a Time dimension added to FDI HCM - Worker Seniority subject area so that we can analyze the average tenure over time.  We are currently unable to add a time slicer for year, quarter and/or month in this subject area in FDI.  This would be helpful to track the change of tenure over time.  

Raghavendra Raghunath-Oracle

Hi @Sam Reinhart can you please provide an example as to how you plan to use Time dimension with the seniority data of the workers? This subject area provides you the latest seniority of the worker for each of the rules that have been setup.

A sample tabular illustration of how you plan to use this data with Time dimension will help me to prioritise this.

Thanks

Raghu

Sam Reinhart

Hi Raghu!

Here is our use case - We want to see the length of service bands YoY or QoQ, by time. We want to see how many people are in the 1-3 year LOS bands in 2024 vs 2023, by year, quarter and period. We do not currently have a sample illustration as we were hoping FDI could help with deeper insights into Seniority.

Thanks,

Sam

Raghavendra Raghunath-Oracle

Hi Sam,

Currently, The Seniority Data for the combination of worker and the rule name is as of the latest date on which the process was run to compute the seniority. For example: A worker's seniority for a rule is 3 Years hence is categorised under 3-4 Years band

Your requirement is, hypothetically if the rule was run last year then the same worker would have had seniority as 2 years and would be categorised under 0-2 Years band.

Person	Rule	Seniority	Band	Process Run date	Year
Person	Jon	Rule	Enterprise	Seniority	4 Years	Band	3-4	Process Run date	01-Apr-24	Year	2024
Person	Jon	Rule	Enterprise	Seniority	3 Years	Band	3-4	Process Run date	01-Apr-24	Year	2023
Person	Jon	Rule	Enterprise	Seniority	2 Years	Band	0-2	Process Run date	01-Apr-24	Year	2022
Person	Jon	Rule	Enterprise	Seniority	1 Years	Band	0-2	Process Run date	01-Apr-24	Year	2021

This is like having a snapshot of the Worker Seniority YOY

I see there are 8 votes already for your idea

But I want you and others to confirm if my understanding is right

We can evaluate and get back on the forum on the feasibility of this.

Raghu

Sam Reinhart

Thanks Raghu! Sorry for the delay, we are wrapping up our implementation phase. Yes this is the logic we are expecting for this idea/enhancement.