Understanding the Data Store

The Intermediate Payable Time data store is made up of the following five tables:

• TL_IPT1

• TL_IPT2

• TL_IPT3

• TL_IPT4

• TL_IPT5

All of these tables use the same TL_IPT_SBR sub-record.

Initially, Time Administration loads all reported and scheduled time data for all time reporters who must be processed into TL_IPT1. In your rules, you can move data back and forth between TL_IPT1 and the other Intermediate Payable Time Tables, or to other working tables in the system. For example, your rule could move time data from TL_IPT1 to TL_IPT2, apply a specific TRC to this time, and then update the original row of data in TL_IPT1 with the new TRC associated data.

Note:

Only processed data in TL_IPT1 is transferred to Payable Time at the end of the Time Administration run. Therefore, after your rules work on the data in other tables, you must return any processed data you want to send to Payable Time back to TL_IPT1.

WARNING:

Never truncate or delete the data in TL_IPT1; it contains time data in raw form that is needed to execute your rules. If you delete this data, your rules will be left with nothing to process.

This diagram illustrates the movement of data from scheduled and reported time to Intermediate Payable Time, and from Intermediate Payable Time to Payable Time