SQL query to get offering start date and end date in learn module in fusion HCM

Content

Hi All,

I am working in a requirement where I need the following details:

Offering Name, Offering start date, Course Name, Person number enrolled in the offering, Person name enrolled in the offering, Minimum attendees of the offering

 

Requirement: I have developed a learning alert where I need to trigger the alert when-

1) If the enrolled person in an offering is less than minimum attendees.

2) Alert will be triggered 5 days before the offering start date.

Query: I have developed a learning alert using BI but I am not able to get offering start date and end date correctly. Instead of offering start and end date I am getting creation date and completion date.