Project Server Assignment Query RRS feed

  • Question

  • Hi,

    I am currently "migrating" a query that retrieves timesheet data from dbo.MSP_TimesheetLine_UserView and I am trying to migrate it to Assignments, I see that I do not have the "Billable" fields on any assignment view, is there a way I can get the billable information ? has anyone done this before?


    Thursday, April 10, 2014 1:56 PM

All replies

  • The Actual Work Billable/Non-Billable etc., are only available in the "Timesheet" views. As far as I can tell, the Actual Work in Assignment views is the equal of the Billable work.

    So you might have to modify your query to join with Timesheet views with Assignment Views. 

    Prasanna Adavi,PMP,MCTS,MCITP,MCT

    Thursday, April 10, 2014 3:23 PM