How do we report on ORC Applicant data

Summary:

I have tried to use the Recuriting - Hiring Event Real time, but I only see the applicant. I do not see any actions

But when I add anything else, such as Events or Offers it does not return any data.

Using a Data Model, I can see data in the IRC_CANDIDATES, IRC_SUBMISSIONS and IRC_REQUISITIONS_B tables.

But when I add in IRC_CAND_ACTIONS or IRC_LC_HISTORY, I do not get data.

I believe I need the IRC_LC_HISTORY to get the STATE_ID AND PHASE_ID to link to the IRC_PHASES_TL and IRC_STATES_TL tables.