Issue with HCM Extract

Summary

Issue with HCM Extract

Content

HI All,

We have created new HCM Extract but we are facing below 2 issues:

1. We want to default one column in case if the employee is manager then it should be "Y" else "N" .

2.If the employee has an inactive assignment is the past then the value is picked up as N whereas the employee has current assignment. It should pick up the current assignment and give value as Y instead on N.

Can someone please advice how can i resolve these above issues.

Thanks,

Sahil