u/PrivateWorkSeal

Hi team,

I wanted to know at a high level, is it possible before i deep dive into solution mode.

We do not want to create a Security Group for this purpose.

Example:

Business Process: Job Requisition (Default)

- Our company has multiple divisions, If the Job requisition is created for Division A, i want to route to a specific Position ID(Person)?

- In Division A, 5 People hold the same Position attributes such as Job Profile.

- We do not want to do this approval step for other divisions.

My Current Idea: (Unsuccessful)

Add an Approval Chain Step

Entry Condition: Is the Job Req created For Division A?

While Running Condition:
Calculated Field Called = Attempt 1
Object: Event
Source Field = Workers Possible Assigned next
Condition = Any is True
Fields to Aggregate = Position

Condition Rule, CF(Attempt 1) Equal to (Persons position)

Exploring Next Idea: Some form of an Adhoc Approval? but unsure how this would be designed.

Thank you

Hi Team,

I was wondering if i could get your advice on how to build the below report.

Essentially we need to export Workday data in a SCP II format, or a Slowly Changing Dimension table,

Desired Outcome, Calculate employee attributes such headcount or position, at any given point in time for analysis in Power BI and modeling to other data sources.

Structurally needs to handle rehire and termination scenarios and all position attribute movements, into a single table.

The sample below is what I'm seeking, but i need guidance on best practice for developing this report in Workday.

If anyone has a template, they are willing to share as a starting point, i would really appreciate your help.

Thank you

Employee ID	Employee Name	Hire Date	Termination Date	Location	Effective From	Effective To
E001	John Smith	2022-03-15		Sydney	2022-03-15	2023-05-31
E001	John Smith	2022-03-15		Melbourne	2023-06-01
E002	Raj Patel	2020-01-10	2023-04-30	Brisbane	2020-01-10	2023-04-30
E003	Tom Wilson	2018-07-01	2020-12-31	Sydney	2018-07-01	2020-12-31
E003	Tom Wilson	2022-09-15		Sydney	2022-09-15	2024-01-31
E003	Tom Wilson	2022-09-15		Perth	2024-02-01
E004	Aisha Hublot	2019-04-01	2021-08-15	Melbourne	2019-04-01	2021-08-15
E004	Aisha Hublot	2023-01-10	2024-09-30	Melbourne	2023-01-10	2023-10-31
E004	Aisha Hublot	2023-01-10	2024-09-30	Sydney	2023-11-01	2024-09-30
E005	David Lee	2024-05-20		Brisbane	2024-05-20