Display MR and OTS template effective dates

To help users select valid dates when opening an active MR or OTS template, the effective start and end dates of the rotation are displayed in the Select Date Range page. These dates are also displayed in the Effective Start Date and Effective End Date columns in the Manage Master Rotation and Manage One-time Schedule Templates maintenance forms.

The effective dates are the full range of valid dates that the MR or OTS template can be opened on. They are determined by the earliest start date and latest end date of all row versions associated with the rotation, regardless of the status of each row version.