Advise on Learning Initiatives for Renewals

Summary:

Hello Experts,

We have few refresher courses which are assigned based on previous year completions, Course level Initiatives are setup using Renewals and works fine.

We want to enable Offering level initiative using OTBI with Current date filter and link courses and offering records.

Wanted to check

1)what column basis does system start showing No Active Offering Records to Learners is it Enrolled on Date or Effective date.

2)Say if previous year completion and current course as well shows 12:30 PM and we have created an offering initiative running with Current date filter. When does the offering assignment link to course?