Monday, December 20, 2010

Time and Labor rules and WRK_ADHOC_TAO table

WRK_ADHOC_TAO is one of the most useful temporary tables used in the Time Administration processing. This table (conspicuous by the absence of a TL_ prefix as it is a scheduling table used!) is primarily used as the reference point for the schedule data of employees (output of the schedule resolution routines in  Time Admin). This table is commonly used in most of the delivered rule templates, especially those that track attendance infractions like Late In, Early Out etc. Handy uses of this table are:
1. HOLIDAY_IND field that says whether a particular day is a Holiday as per the holiday schedule.
2. OFFDAY_IND field that says whether a particular day is an off-day as per the work schedule of the employee.
3. SHIFT_ID field that gives the shift of an employee for a day which can be useful while tracking shift premiums.
4. Field that give the scheduled In and Out time for a day that can be useful while checking tardiness.

So, the next time you want to check whether a particular day is an off-day or holiday in Time and Labor rules, you know which table you need to refer!

No comments: