Hi Prachi,
Precise answer to your question is - if the time sheet current status is NOT IN RETURN status - unfortunately it would not be possible to capture the user name who actually returned the time sheet.
if you would like to find out who actually modified the time sheet based on status - It is mandatory that the respective time sheet status should be in the same status which you are looking for.
DB Process behind the screen:
Only field/attribute we have in Clarity DB to find out who has performed the latest update to a specific time sheet is PRMODBY on PRTIMESHEET table.
whenever any kind of event(Submitted, Returned, Approved, Posted etc..) occurs to any specific time sheet PRMODBY field will get updated.
Please see the below steps it will give you more details in terms of how this field get updated.
For example:
1.you have submitted the time sheet - Meaning PRMODBY field value will get updated to your user id on PRTIMESHEET table
2.Resource Manager 1 Rejected it - Meaning PRMODBY field value will again get updated to the RM1 user id on PRTIMESHEET table
3.You again adjusted and Re-Submitted it - Meaning PRMODBY field value will again get updated to your user id on PRTIMESHEET table
4.Resource Manager 2 Approved it - Meaning PRMODBY field value will get updated to the RM2 user id on PRTIMESHEET table
However if your requirement is on going requirement(meaning if it is not ONE TIME REQUIREMENT) then you achieve this by performing DB Customization(which may not support by Ca & you'll have take care of it explicitly during the upgrade time).
Limitation - This requirement will only work for future activities, it will not work for the time sheets which has already posted.
1.Develop a DB Trigger on PRTIMESHEET table based on whenever a RETURN event occurs to PRSTATUS field on PRTIMESHEET table.
2.You'll have to create a custom table(fields like timesheet id, timeperiodid,submitted by, submitted time, returned by, returned time, approved by,approved time etc.. ) where you are going insert a new record for every time when a time sheet has been rejected.
Hope my explanation will address your query.
Best Regards
Jagadeesh