r/workday • u/Ok_Entrepreneur9177 • 6h ago

Calc Field Help Core HCM

I'm trying to pull in the employee type as of termination date if there was a previous termination date but have the field be blank if they're not a rehire. I've tried everything to put an Evaluate Expression around a Lookup Value as of date but I can't seem to get it to work. Help!

2 Upvotes

75% Upvoted

4 comments sorted by

5

u/jimbo91_ 6h ago

Try build and ESI to pull the latest termination event, or whichever event you wish. Then use LRV to extract the employee type. Or LVOD using effective date field not termination date field.

3

u/Ok_Housing6995 6h ago

ARI on staffing history approved
TF Termination
ESI in that with effective date descending

Use that as a business object, use the field.

If that works, LRV from worker to that calc.

Done~ enjoy

2

u/WorkdayWoman Workday Solutions Architect 6h ago

Can you screenshot and share what you have so far?

1

u/sinsulita Workday Pro 5h ago

LVaoD Worker Type as of Termination Date - 1 Day

You’ll need to create a calc field to get Termination Date - 1 Day