none
Timesheet Actual Approver RRS feed

  • Question

  • From which table can we read timesheet actual Approver?

    Which table will hold this details? 


    Regards, Syed Faizan ur Rehman, CBPM®,PRINCE2®, MCTS

    Sunday, July 5, 2015 11:02 AM

All replies

  • Hi Syed,

    If you use the classic timesheet manager approval, meaning not the timesheet manager list (PS2013), then you can retrieve the timesheet manager from the resource userview, since it will always be the timesheet manager who will approve the timesheet.


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller |

    Sunday, July 5, 2015 9:42 PM
    Moderator
  • Hi Guillaume,

      My client demands something quite different from earlier implementations, they want the actual approver who would have approved the timesheet in case a delegation was there. They need the delegate name to appear. 

      I was wondering if there was a way we can check the TS log table or some mechanism to have the accuracy as who actually clicked the approve button for a particular resource. 


    Regards, Syed Faizan ur Rehman, CBPM®,PRINCE2®, MCTS

    Monday, July 6, 2015 5:15 AM
  • There is the timesheet audit, but you'll not get the actual approver which is not logged as per your request.

    A trick is to retrieve the "last modified by" for approved timesheets, which will give you the approver's name and not the resource timesheet manager.

    See an example here:

    https://social.technet.microsoft.com/forums/projectserver/en-US/10b3aa21-724f-4098-b237-b6ee8e70d21f/weekly-resource-timesheet-status

    That being said, in case of delegation, you'll not have the delegate name, but still the name the delegate acts for. For your purpose, you'll have to create sort of delegation sessions logs.

    See an example with an event Handler:

    http://blogs.msdn.com/b/chrisfie/archive/2010/06/03/project-server-2010-delegation-audit-event-handler.aspx


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller |


    Monday, July 6, 2015 6:00 AM
    Moderator
  • I tried reading the field  MSP_Timesheet.LastStatusChangeResourceNameUID and for some reason it is having Null for all records, timesheet Auditing is enabled in the PWA settings..

    Regards, Syed Faizan ur Rehman, CBPM®,PRINCE2®, MCTS

    Monday, July 6, 2015 6:32 AM
  • Have you tried: MSP_TimesheetActual.LastChangedResourceNameUID ?

    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller |

    Monday, July 6, 2015 7:01 AM
    Moderator
  • There is also a line approver value placed in the timesheet line comment, along with the date of approval. This might be something else to view as timesheet approval can be delegated.

    Treb Gatte, Project MVP | Blog | Twitter | CIO Magazine Blog | Learn Resource Management

    Monday, July 6, 2015 6:48 PM
    Moderator