Understanding the TCD Interface and Referential Integrity
When you change one area of the application, referential integrity ensures that changes do not adversely affect another area of the application. The system checks for retroactive changes to effective-dated setup data or time-reporter-related data that could invalidate related objects or values.
The following sections describe referential integrity actions when certain changes, inactivations, or deletions are made during TCD processing.
The following table lists the pages and conditions when the system will not allow the inactivation or deletion of effective-dated rows.
|
Page |
Condition |
|---|---|
|
TCD Group |
You cannot inactivate a TCD group that is associated with a time reporter. You cannot delete an effective-dated row if the deletion invalidates the association to a time reporter. |
|
TCD Setup |
You cannot inactivate a TCD if the TCD is attached to a TCD group. You cannot delete an effective-dated row if it invalidates the association to a TCD group. |
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 the page.
|
Page |
Prompts on Page |
|---|---|
|
TCD Setup |
TCD Type TRC Program Taskgroup |
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 |
|---|---|
|
TCD Type |
TCD Setup |
|
TCD Setup |
TCD Group |
|
TCD Restriction Profile |
TCD Group |
|
TCD Group |
Maintain TR Data |