Component Missing

Problem

Client has reported that they are not able to see a particular scheme component in attendance marking page under a particular work. They had seen the component just before a few hours but its not there now.

Solution The client was asked to provide claim number of an old bill of same work which had the missing component. While checking in bill list, the claim number provided by client was found to have the missing component.

Get the work ID of work in question and run the following query to get full details of the components and HR staffs under it. <source lang="sql" highlight="3"> SELECT * FROM kwahr_core_work work LEFT JOIN kwahr_core_workdet workdet ON workdet.wrkdet_wrk_id=work.wrk_id LEFT JOIN kwahr_core_workemp workemp ON workdet.wrkdet_id=workemp.wrkemp_wrkdet_id LEFT JOIN kwahr_core_scheme_component schemecomp ON workemp.wrkemp_scheme_comp_id =schemecomp.scheme_comp_id WHERE work.wrk_id=5964 </source>

While checking the field,wrkemp_deletion_status, all the entries corresponding to the missing component was found to be set to 1 which means all those HR staff were removed from the work by the user himself. t_modified will give the time of deletion in GMT and u_deletedby will give the id of user who did the delete.

Client was informed that the particular user has deleted the data and the they have to contact KWA Head office for getting approval for restoration.