Time Reporting Codes and Referential Integrity

When you make a change to one area of the application, 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.

Prevention of Inactivation or Deletion of Effective-Dated Rows

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

Page

Condition

TRC

You cannot:

  • Inactivate a TRC that is associated with a TRC program.

  • Delete an effective-dated row if it invalidates the association with a TRC program.

  • Inactivate a TRC if it is associated to a Compensatory Time Off Plan.

  • Delete an effective-dated row if it invalidates the association with a Compensatory Time Off Plan.

TRC Program

You cannot:

  • Inactivate a TRC program if it is associated to a Workgroup.

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

  • Inactivate a TRC program if it is associated to a Time Collection Device.

  • Delete an effective-dated row if it invalidates the association to a Time Collection Device.

Execute Edit Error Checking

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

TRC

Unit of Measure, NA Earnings Code, GP Take Code, GP Earns Code

TRC Program

TRC

Nested Effective Dates

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

TRC

TRC Program, Compensatory Time Off Plan

TRC Program

Workgroup, TCD Setup