Has anyone worked on BIP report to fetch the data of all employees who have been active in 2018 at s

Summary

Has anyone worked on BIP report to fetch the data of all employees who have been active in 2018 at some point with the latest legal employer info

Content

Hi,

Has anyone worked on BIP report to fetch the data of all employees who have been active in 2018 at some point along with the latest legal employer name.

The employees can be both active and inactive as long as the inactive status happened in 2018 only. So, we need the most current legal employer of all employees who could have had multiple transfers etc and those who have become inactive in 2018 due to termination.