Time and Labor Scripts

Time and Labor Scripts 

EXPORT tl_rptd_time 

 WHERE emplid = '02326475' and dur = %datein('2020-08-03') and seq_nbr = 10202; 

UPDATE PS_TL_RPTD_TIME  

   set seq_nbr = 999

 WHERE emplid = '02326475' and dur = %datein('2020-08-03') and seq_nbr = 10202;  

export TL_EXCEPTION where exception_status='U' and emplid = '02086261';

export tl_tr_status where emplid = '02086261';

delete PS_TL_EXCEPTION where exception_status='U' and emplid = '02086261';

update ps_tl_tr_status set TA_STATUS ='N' where emplid = '02086261';