Difference Between Effective Start Date, Offering Start Date and Publish Start Date in Offerings HDL

Summary:

In Course Object under the Offering component, we have Effective Start Date, Effective End Date, Offering Start Date, Offering End Date, Publish Start and End Dates.

What is the relevance of each of these columns? How does this impact the data on the system/Front-End

What can be the different use cases and validations if we have different dates in these column pairs. i.e., Effective Start and End Dates, Offering Start and End Dates and also Publish Start and End Dates

Content (required):

METADATA|Offering|OfferingNumber|CourseNumber|EffectiveStartDate|EffectiveEndDate|Description|DescriptionText|EnableCapacity|EnableWaitlist|LanguageCode|MaximumCapacity|MinimumCapacity|OfferingStartDate|OfferingEndDate