Clarity

  • 1.  Find the returned by in timesheet

    Posted Jul 22, 2016 06:23 AM

    I have a requirement where a approved time sheet is returned by someone and then force approved by admin and posted. i need to find the user who return the timesheet. In my environment every resource manager have global rights. so not able to find on the basis of rights.



  • 2.  Re: Find the returned by in timesheet

    Posted Jul 22, 2016 07:07 AM

    if the timesheet is in returned status, can't you check the modified by field ????

     

    NJ



  • 3.  Re: Find the returned by in timesheet

    Posted Jul 22, 2016 07:12 AM

    Timesheet is not in returned status. but I need to check who returned the timesheet.



  • 4.  Re: Find the returned by in timesheet

    Posted Jul 22, 2016 07:24 AM

    Then, I guess, the data is lost.

     

    Please vote on this :

     

    Modify Timesheet Construct In Clarity

     

    Although, UNSUPPORTED, check this for future reference.

     

    NJ



  • 5.  Re: Find the returned by in timesheet

    Posted Jul 22, 2016 07:24 AM


  • 6.  Re: Find the returned by in timesheet

    Broadcom Employee
    Posted Jul 22, 2016 03:00 PM

    The PRTIMESHEET.PRMODBY will be updated when the timesheet is edited, saved, approved, or returned.



  • 7.  Re: Find the returned by in timesheet

    Posted Jul 25, 2016 02:42 AM

    Timesheet is updated after returning. so prmodby is not giving the returned by.



  • 8.  Re: Find the returned by in timesheet

     
    Posted Jul 27, 2016 06:14 PM

    Hi Prachi.Jain - Did any of the responses help answer your question? If so please mark as Correct Answer. Thanks!



  • 9.  Re: Find the returned by in timesheet

    Posted Jul 25, 2016 10:00 AM

    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



  • 10.  Re: Find the returned by in timesheet

    Posted Jul 26, 2016 07:26 AM

    If it is really required to track who returned the timesheet, you could simply create a process to run when the timesheet is returned. Create a custom object and create new instances in the object via XOG from the process step to keep track of who returned the timesheet. You don't need any level of customization.

    Although the solution will work, you should check with the stakeholders if the development effort is worth the information on who returned the timesheet. You may also look into the possibility that resource managers do not have access to all timesheets and that access is limited.

     

    -Sankhadeep