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.