Task Reporting and Referential Integrity

When you make a change to one area of Time and Labor, the RI process makes sure the changes do not adversely affect another area of the application. It checks for retroactive changes to effective-dated setup data or employee related data that could invalidate related objects or values in the system.

This table lists the pages and conditions when the system will not allow the inactivation or deletion of effective-dated rows.

Page

Condition

Taskgroup

You cannot:

  • Inactivate a taskgroup that is assigned to a time reporter through the Create/Maintain Time Reporter Data page.

  • Inactivate a taskgroup that is assigned to a time collection device (TCD) on the TCD Taskgroup page.

  • Delete an effective-dated row if it invalidates the association to a time reporter.

  • Delete an effective-dated row if it invalidates the association to a TCD Group.

Task profile

You cannot:

  • Inactivate a task profile that is assigned to a taskgroup.

  • Delete an effective-dated row if it invalidates the association to a taskgroup

You cannot change the minimum effective date on a page to be less than the minimum effective date of a field that acts as a prompt on this page.

Page

Prompts on Page

Taskgroup

Task Profile

You cannot change the effective date of the prompt table to be greater than the effective date of the target table.

Prompt Table

Target Table

Taskgroup

Create/Maintain Time Reporter Data

TCD Setup

Task Profile

Taskgroup

Taskgroup Profile

Taskgroup