For recording External Learning, we intend to create a BI Publisher (BIP) report

Summary:

Hi Team,

For recording External Learning, we intend to create a BI Publisher (BIP) report that displays employee details along with the approver information and the approval status (approved / not approved).

However, we are currently unable to identify a direct join between employee details, the external learning hours recorded, and the person to whom the approval was assigned, along with the corresponding approval status.

We are seeking guidance on how to establish this linkage or identify the appropriate tables/views to retrieve the approver and approval status for external learning records.

Content (please ensure you mask any confidential information):