Time Administration and Referential Integrity Triggers
This section provides a table listing the situations in which Referential Integrity is initiated and is processed through Time Administration.
This table lists the RI triggers:
Page |
Prompt on Page |
System Action |
Validation ID |
Trigger TA? |
---|---|---|---|---|
Create/Maintain Time Reporter Data |
Workgroup |
Update |
TLX00440 |
Y |
|
Taskgroup |
Update |
TLX00070 |
Y |
|
|
|
TLX00090 |
|
|
|
|
TLX00100 |
|
|
Task Profile |
Update |
TLX00070 |
Y |
|
Rule Element 1-5 |
Update |
None |
Y |
Comp Plan Enrollment |
Compensatory Time Off Plan |
Add/Del/Update |
TLX00001 |
Y |
Time Reporting Code |
TRC Type − Changed to Hours |
Update |
TLX00490 |
Y |
|
TRC Type − Changed to Amount |
Update |
TLX00500 |
Y |
|
TRC Type − Changed to Units |
Update |
TLX00510 |
Y |
|
Maximum Quantity |
Update |
TLX00450 |
Y |
|
Minimum Quantity |
Update |
TLX00450 |
Y |
|
Flat Amount |
Update |
TLX00460 |
Y |
|
Rate |
Update |
TLX00470 |
Y |
|
Effect on Comp/Leave |
Update when indicator is changed from None to Comp Earned or Comp Taken |
TLX00001 |
Y |
|
|
Update when indicator is changed from None to Leave Taken |
TLX0010 |
Y |
TRC Program |
Time Reporting Code |
Add/Delete |
TLX00440 |
Y |
Workgroup |
TRC Program ID |
Update |
TLX00440 |
Y |
|
Rule Program ID |
Update |
None |
Y |
|
Comp Time Plan |
Update |
TLX00001 |
Y |
|
Holiday Schedule |
Update |
None |
Y |
|
Schedule ID |
Update |
None |
Y |
|
Needs Approval |
Update |
None |
Y |
|
Day Breaker |
Update |
None |
Y |
|
Day Breaker Range |
Update |
None |
Y |
|
Day Breaker Options |
Update |
None |
Y |
|
Round Punches Before Rules |
Update |
None |
Y |
|
Rounding Intervals (Mins) |
Update |
None |
Y |
|
Rounding Marker (Mins) |
Update |
None |
Y |
|
Round Duration After Rules |
Update |
None |
Y |
|
Rounding Options (Day, None, Segment) |
Update |
None |
Y |
Task Profile |
Task Profile ID |
Add/Update |
TLX00060 |
Y |
Taskgroup |
Taskgroup |
Add |
TLX00040 |
Y |
|
Task Template |
Update |
TLX00090 |
Y |
|
|
|
TLX00100 |
|
|
Default Task Profile ID |
Update |
None |
Y |
Taskgroup (Profile) |
Task Profile ID |
Inactivate |
TLX00070 |
Y |
|
|
|
TLX00080 |
|
|
|
Add |
TLX00070 |
Y |
|
|
|
TLX00080 |
|
Build Time Period Calendar |
Time Period ID |
Update |
None |
Y |
Rule Program |
Priority |
Update |
None |
Y |
|
Rule ID |
Update |
None |
Y |
Compensatory Time Off Plan |
Expiration Period |
Update |
TLX00001 |
Y |
|
Number |
Update |
TLX00001 |
Y |
|
Maximum Negative Hours Allowed |
Update |
TLX00001 |
Y |
|
Maximum Positive Hours Allowed |
Update |
TLX00001 |
Y |
Compensatory Time Off Plan (TRC) |
Time Reporting Code |
Add/Delete |
TLX00001 |
Y |
Assign Work Schedule |
Schedule ID |
Update |
None |
Y |
Override Scheduled Workday |
Shift |
Add/Update |
None |
Y |
Job Data |
All Fields |
Add/Update |
TLX00830* |
Y |
Department |
Use Actuals Distribution |
Update |
TLX00830** |
Y |
Leave Plan Table |
Maximum Negative Hours Allowed |
Update |
TLX00010 |
Y |
|
Accrued Balance Goes Negative |
Update |
TLX00010 |
Y |
Leave Plans (USA) |
Benefit Plan |
Add/Update |
TLX00010 |
Y |
|
Plan Type |
Update |
TLX00010 |
Y |
|
Coverage Election |
UpdateECD |
TLX00010 |
Y |
*Any effective dated change to JOB data for an employee causes the ECD for the employee to be moved back to the earliest instance of reported or payable time that is on or after the effective dated change to JOB data. When the Time Administration process is run a new row in the RI Control table validates this time for this employee, and processes validation TLX00830, which checks that the Commitment Accounting flag is in consistent with the taskgroup in reported and payable time, and the DEPTID on JOB data for the employee. The update to the RI Control table for the JOB data change is made possible through the use of the Workforce Sync message.
**Any change to a department in the Department table triggers the Department Sync message to insert a row into the RI Control table to validate that no employee that is associated with the department has a change in the commitment accounting flag that is inconsistent with the commitment accounting flag of the taskgroup used in reported or payable time for that employee, as of the effective date of the change or greater.