Headcount Validation OBIA HR Analytics with EBS source system

Question

Hi,

I want to validate the headcount field in OBIA HR analytics module with the source system data. My source system is EBS 12.1.3. Can somebody provide me the query that i can execute on source system and validate the results.

Thomas Dodds · Answer

You'll have to modify the query to suit your needs ... but it contains the EBS tables you need.

3027317 · Answer

Thanks for the query thomas. But I believe this gives me the total count. I need a count of employees that are currently working on today date and they are permanent employees

Thomas Dodds · Answer

https://gist.github.com/jgilmour/4612391

^ is employee + supervisor, but has the tables you need and can be easily modified for your needs