Workgroups and Referential Integrity

When you make a change to one area of the application, Referential Integrity makes sure that these 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.

The following tables describe Referential Integrity actions that occur when certain changes, inactivations, or deletions are made to workgroup data.

Prevent Inactivation or Deletion of Effective-Dated Rows

You cannot inactivate a workgroup or delete effective-dated rows in the following cases:

Feature	Action
Workgroup	You cannot inactivate a workgroup if the workgroup is associated to a time reporter on the Create/Maintain Time Reporter Data pages. You cannot delete an effective-dated row if the deletion invalidates an association to a time reporter on the Create/Maintain Time Reporter Data pages.

Execute Error Edit Checking

You cannot change the effective date of the target table to be greater than the effective date of the prompt table. This prevents an invalid association between the prompt value and the target table.

Target Table	Prompt Table
Workgroup	Rule Program ID TRC Program ID Compensatory Time Off Plan Schedule ID Overtime Limit ID

Nested Effective Dates

You cannot change the effective date of the source table to be greater than the effective date of the target table. This ensures the validity of a value that acts as a prompt on another page.

Source Table	Target Table
Workgroup	Create/Maintain Time Reporter Data