Employee Job History

Hi

I am looking for a data mart/query I can use that provide employee job history.

For context, here is what I am looking to do. If we hire an employee into a specific role, say Intern, I want to be able to see the employee's first role (here the intern) and any subsequent jobs the employee may have held. Hoping the query has all current job details, action reason, all previous jobs held.

I have seen several OTBI reports on here but would like a query so we can modify on our end.

Thanks in advance.

Jose