Report - Notifications a learner received on learnings

Summary

SQL / Report to Get List of notifications a learner received

Content

Team,

We have a requirement to build a report to display Offering Details (Offering Title, Start Date, End Date, etc) with Recipients, Subject, Message Text , etc.,

We are unable to find all the details in the subject area "Human Capital Management - Approval Notification Archive Real Time" in OTBI.

Tried with the below tables in BI and could not find the details.

 fa_fusion_soainfra.wftask                    fwt

       , fa_fusion_soainfra.wfassignee                fwa

       , fa_fusion_soainfra.wftaskhistory             fwh

       , fa_fusion_soainfra.wfcomments                fwc

       , fa_fusion_soainfra.wfattachment              fwat

       , fa_fusion_soainfra.wftaskassignmentstatistic fwst