Used on or in active rotations/templates until date logic

When you inactivate a rotation row that contains a shift or remove a shift from the latest active version, the Used on or in active rotations/templates until value is also updated. This value shows the last day the shift is generated or published from a shift template or a rotation. Consider these rules when you are monitoring the last day that the shift is generated or published from a shift rotation:

  • When a rotation or a row is in Draft status, it is not considered in the calculation.
  • If the row is active with no inactivation date, the Used on or in active rotations/templates until value is the same as the Effective End Date.
  • When you specify an inactivation date, the Used on or in active rotations/templates until value is recalculated based on the earliest inactivation date. For example, a rotation is active until 01/01/3000 but the inactivation date is on 12/01/2025. Then, the Used on or in active rotations/templates until value is 30/11/2025.
  • When a rotation row has multiple active versions and no inactive version, the days that are effectively covered by the newer versions of the rotations are not considered in calculation. The Used on or in active rotations/templates until value only shows the outcome of the rotation row after the newest version of the rotation is activated.

    Refer to these scenarios as examples:

    In this example, there are two versions of row. Version 1 contains the shift 11D4 and is active from 07/21/2025-01/01/3000 while Version 2 does not contain a shift but is active from 07/23/2025-01/01/3000. Version 2 of the shift overrides Version 1 starting from 07/23/2025. As a result, the Used on or in active rotations/templates until value of 11D4 is on 07/22/2025.

    Version Shift Name Status Effective Date Used on or in active rotations/templates until
    1 11D4 Active 07/21/2025 - 01/01/3000 07/22/2025
    2 Active 07/23/2025 - 01/01/3000

    For this scenario, there are three versions of a rotation. Each version contains a shift. The same logic is applied to Versions 1 and 2. This means that shift 15E8 is generated or published until 08/31/2025 since 7D2 is effective from 08/31/2025. For Version 3, 8D7 is used in active rotations or templates until 01/01/3000 since there is no version of the rotation that overrides its effective dates.

    Version Shift Name Status Effective Date Used on or in active rotations/templates until
    1 15E8 Active 07/21/2025 - 01/01/3000 08/31/2025
    2 7D8 Active 09/01/2025 - 01/01/3000 11/30/2025
    3 8D7 Active 12/01/2025 - 01/01/3000 01/01/3000

    In this example, there are four rows in the rotation. Three rows are active and one is inactive. The calculation for the Used on or in active rotations/templates until value still follows same logic for rows that contain shifts. The effective date of the latest version of the rotation, remains part of the calculation, even if it is inactive. As a result, shift 8D7 publishes until 12/30/2025 since the latest rotation takes effect on 01/01/2026.

    Version Shift Name Status Effective Date Used on or in active rotations/templates until
    1 15E8 Active 07/21/2025 - 01/01/3000 08/31/2025
    2 7D8 Active 09/01/2025 - 01/01/3000 11/30/2025
    3 8D7 Active 12/01/2025 - 01/01/3000 12/30/2025
    4 Inactive 01/01/2026 - 01/01/3000

    When multiple versions of a shift exists, the newer version overrides the older version starting from its activation date.