none
Timesheet status different in PWA and in reporting DB

    Question

  • Hello,

    We have a situation! 
    A user have entered 56Hours in a week's timesheet.
    PWA Timesheet show the status as:

    Status: Approval (Final). Total: 40h  --> 40h not 56h that he actually entered.

    And there is no Approval pending.

    When we check a report generated from reporting DB that shows the status through - 'TimesheetStatusID' column in DB,
    It shows 'In Progress' status of the timesheet.

    We need to know how is 'TimesheetStatusID' column calculated, so we understand the discrepancy.

    Thanks!

    Tuesday, April 18, 2017 3:21 PM

All replies

  • Hi,

    First of all, please find here the different timesheet status ID.

    If you confirm that in a report (so from Reporting DB) the timesheet status is "in progress" and in PWA the status of the same timesheet is "approved", the reporting DB might have not been correctly sync'ed. Either you could delete and recreate/submit the given timesheet, or rebuild the Reporting DB.


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller

    Wednesday, April 19, 2017 7:27 AM
    Moderator
  • Here something I blogged about three years ago that may help.

    http://myprojectexpert.com/Lists/Posts/Post.aspx?ID=55 



    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Friday, April 21, 2017 3:24 AM
    Moderator