delete from users where usrlvl<>'Supervisor'
truncate table leavesfile1;
truncate table leavereqfile2;
truncate table overtimefile1;
truncate table overtimereqfile2;
truncate table undertimefile1;
truncate table undertimereqfile2;
truncate table obfile1;
truncate table obreqfile2;
truncate table daytran2;
truncate table approverfile2;
truncate table approverfile;
truncate table appnotificationfile;
truncate table reqnotificationfile;
truncate table approverfile3;
truncate table approverfile3;

truncate table approver_policy_file3;
truncate table approver_policy_file4;
truncate table approver_policy_file5;

truncate table cosfile1;
truncate table cosreqfile2;
truncate table useractivitylogfile;