Absence and TimeAdmin processing
Run ZTTT_BAJAUS – Absence dropping process into Timesheet runs for all employees for any pending
transactions.
Navigation - Main Menu > Time and Labor > Report Time > Bajada de Ausencias
Spanish - Menú Principal> Gestión de Tiempos y Tareas > Registro de Horas >Bajada de
Ausencias
Page screenshot:
The example below Will run the process from 1st Jan 2024 to today’s date (23rd Apr 2024). Processes
absence for all the employees.
Employee wise processing- Run TL_TIMEADMIN
Navigation: Main Menu > Time and Labor > Process Time > Request Time Administration
Spanish - Menú Principal> Gestión de Tiempos y Tareas> Proceso de Horas
>Administración de Tiempo
To run the time admin process for any particular employee we need to do the following in the
database:
1. Check and Update the following table to set the retro limit, as per requirement:
select * from ps_zttt_retro_tbl;
update ps_zttt_retro_tbl set zmeses_TA =3 , months=3;
Note: The number 3 here signifies that it will have the limit to process upto last 3
months of timesheet data, of the employee in concern. It can be any number.
2. Update the TL core table to set the earliest change date and process thru date for
the employee.
Note: Earliest change date- Date from which the timesheet entries are needed to
be processed for the employee. It must be within the retro limit described in point
1.
Process through date - Date upto which the timesheet entries will get processes
for the employee. The process through date can also be entered in the online run
control page, as shown below in the screenshot in step 3.
update ps_tl_tr_status
set earliest_chgdt ='1-jan-24' , ta_status='y', process_instance=0, oprid =' ',
run_cntl_id=' '
where emplid in ('080021', '454613'
) and empl_rcd =0;
Check the data updated-
select * from ps_tl_tr_status where emplid in ('080021', '454613') and empl_rcd
=0;
3. After this we need to run the time Admin process from the online navigation: Multiple
employees can be added in the Employees to process grid.
4. Save and run the process TL_TIMEADMIN in the next process schedular request page.
Table s affected by the TimeAdmin Process:
input -- raw data from Timesheet PS_TL_RPTD_TIME
output -- the variables populated by timeadmin, used by payroll datewise and employeewise --
PS_ZTTT_CNSTRC_DIA
output -- the variables populated by timeadmin, used by payroll datewise and employeewise --
PS_TL_PAYABLE_TIME
To check if process had run for an employee-
Check TA_STATUS which we updated to Y before processing in table PS_TL_TR_STATUS. This changes
to N once the process is completed and in process monitor the timeadmin process goes to success.
Use the below SQL:
select * from PS_TL_TR_STATUS where emplid in ('018568') and empl_rcd =0;
