Smarter end of service dates in Workday
Filtering an integration or report's results by termination status is probably one of the most common filters behind 'Worker Type' in Workday. Usually, you can just add a 'Terminated (based on Report Date)' to the filters and be on your way. But sometimes, a little something extra is needed. For example:
- Include workers for X days after their termination date on the file to make sure they are sent as 'inactive' for X days to the consumer.
- Many times the identity and access management system reference "last day of work" instead of "termination date" and you need to reflect enforce status based on "last day of work" instead of Terminated T/F.
Workday delivers two fields, "Termination Date" and "Last Day of Work", but there's a big "gotcha" with these fields. If a worker terminates and then is rehired, reporting on them still shows a termination date or last day of work from their prior employment term. Without planning ahead for that, workers can be filtered out of a data set that shouldn't be.
There's a vary easy way to solve this with evaluate expression fields like so:
Field Name: CF EE Smarter Last Day of Work
Business Object: Worker
Field Type: Date
Default Value: Blank Date
Condition: Return Value if True:
CF TF LDOW >= Hire Date Last Day of Work
And for the TF condition...
Name: CF TF LDOW >= Hire Date
Business Object: Worker
Field: Last Day of Work
Operator: greater than or equal to
Comparison Type: Value from another field
Comparison Value: Hire Date