OTBI Leave of Absence Report - No Absence Module

Summary:

Hello,

We are trying to use the Assignment Event SA to build a report that will reflect all of the employees who are currently still on Leave of Absence and have been on leave since effective date 10/7/2017 and prior.

Important Notes:

• We do not have the Absence module, our only indicator of LOA employees is the Assignment Status field.
• We would like to use OTBI column formula functions, not logical SQL if possible.

I attended the customer connect session and was asked to put our requirements here.

I am stuck on where/how to begin as I'm trying to get a variation of top of stack and historical data at the same time.