none
Where is Remaining Work updated via timesheet stored RRS feed

  • Question

  • Project Server 2010 running in single entry mode.

    We have an SSRS report which shows the user a preview of their pending timesheet approvals and as part of this we want to show the remaining work value 'New' and 'Old'.

    ie. we show what the remaining work is now, and what the remaining work will be if timesheet updates are approved.

    This works perfectly when the remaining work is calculated by the system, as in the user enters time against the task and remaining work is automatically adjusted. It does NOT work when the user submits a new value of remaining work manually, via their timesheet.

    Where does this bit of data go? I have searched PWA_Reporting and cannot find this value.

    Tuesday, June 17, 2014 9:10 AM

Answers

  • Hi Laura,

    take a look into the published database. MSP_Assignments_Saved and MSP_Assigments_Submitted tables.

    Hope that helps

    Kind regards

    Christoph


    Christoph Muelder | Senior Consultant, MCTS, MCSE, MCT | SOLVIN information management GmbH, Germany

    • Marked as answer by Laura_ink Friday, September 12, 2014 1:46 PM
    Tuesday, July 15, 2014 6:36 PM

All replies

  • Hi Laura,

    take a look into the published database. MSP_Assignments_Saved and MSP_Assigments_Submitted tables.

    Hope that helps

    Kind regards

    Christoph


    Christoph Muelder | Senior Consultant, MCTS, MCSE, MCT | SOLVIN information management GmbH, Germany

    • Marked as answer by Laura_ink Friday, September 12, 2014 1:46 PM
    Tuesday, July 15, 2014 6:36 PM
  • That is perfect Christoph, thank you
    Friday, September 12, 2014 1:46 PM