none
Where is the "Comment" is saved from the timesheet of every task ? RRS feed

  • Question

  • I want to know the timesheet column name "Comment" where these values are saving w.r.t timesheet period .

    In which database and which table.

    Thursday, November 29, 2012 5:56 AM

All replies

  • Hi John,

    The MSP_TIMESHEET_LINES & MSP_TimesheetLine_OlapView contains the Comment field in Reporting database. It shows the comments of timesheet approvers. Is that what are you looking for?

    Another way to retrieve the Timesheet comments from The TS_Action_Comments field from publsihed database using the PSI.

    Does that help?


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Thursday, November 29, 2012 6:28 AM
  • When the user open the timesheet and enter hours. then there is field name Comment. which the user fill . and I am asking about that comment field.
    • Edited by John.Eddie Thursday, November 29, 2012 6:53 AM
    Thursday, November 29, 2012 6:53 AM
  • In that case, You will need to use the PSI to get the TS_Action_Comments from Timesheet web service. Tiemsheet Transaction information is not stored in Reporting database. 

    Thanks,


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Thursday, November 29, 2012 7:32 AM
  • Went on a hunt for this myself, in Project Server Online, 2013.  Found the "Comment" value in the table: TimesheetLines and the field name is: TimesheetLineComment. Note this field gets overwritten with the approvers comments upon approval of the task status update request.
    Saturday, November 29, 2014 5:11 PM