Configure Dependent Date Shift

Learn how to configure how dates are shifted relative to an original value by defining a range, interval, time unit, and optional roll behavior.

Steps

  1. In Delphix Compliance Services (DCS), select Compliance > Algorithms > New Algorithm.

  2. On the Details dialog, enter the following information:

    • Name (required): A unique, descriptive name for the algorithm. The Name field cannot contain the following special characters: ~ ! @ # $ % ^ & * ( ) " ? ; , / \ + = [ ] { } | < > ' `

    • Description: A short explanation of what the algorithm does.

    • Example: An example value that illustrates the algorithm’s output.

    • Usage: Additional guidance describing when and how the algorithm should be used.

    Click Next.

  3. On the Configuration dialog, provide the following information:

    • Algorithm Framework: Select Dependent Date Shift.

    • Minimum Range: Enter the smallest offset that can be applied to the original date.

      • Use a negative value to allow shifts into the past, or a positive value to allow shifts into the future.

      • The value must be less than or equal to the maximum range.

      • The minimum and maximum values cannot both be zero.

    • Maximum Range: Enter the largest offset that can be applied to the original date.

      • Use a negative value to allow shifts into the past, or a positive value to allow shifts into the future.

      • The value must be greater than or equal to the minimum range.

    • Interval: Enter the allowed variation in the time gap between the two dates.

      • The value must be 0 or greater.

      • A value of 0 preserves the original gap exactly.

      • A larger value allows the gap between the masked dates to differ from the original by up to this many Shift Units in either direction, while always preserving which date comes first.

    • Shift Unit: Select the time unit used to apply the offset.

      Available options include Years, Months, Days, Hours, Minutes, and Seconds.

    • Roll (optional): Select this option to constrain date shifts within the current time period.

      • When enabled, only the selected Shift Unit field changes — all units larger than the Shift Unit remain unchanged.

      • When disabled, standard date arithmetic is applied — a shift that crosses a period boundary will change higher‑order fields.

      • Roll cannot be enabled when Shift Unit is set to Years.

    Click Next.

  4. On the Domains dialog, select Next.

  5. Review the configuration summary and select Save.

Results

The Dependent Date Shift configuration is saved in the Algorithms list.

Troubleshooting

  • If the minimum range is greater than the maximum range, adjust the values so that the minimum is less than or equal to the maximum.
  • If the interval is negative, enter a value of 0 or greater.
  • If Roll is enabled and Shift Unit is set to Years, either disable Roll or change the Shift Unit to a unit that supports rolling (Months, Days, Hours, Minutes, or Seconds).
  • If both Minimum Range and Maximum Range are 0, set at least one to a non-zero value. A zero offset is not permitted because it would leave the date unchanged.

See Also

Dependent Date Shift