none
Reporting Database: Retreving Unapproved Data.... RRS feed

  • General discussion

  • Hi Guys,

    I need to retreive unapproved timesheet data for one of my reports.

    On looking into the Reporting Database, I am not able to find  any Unapproved TimeSheet data, the only data i can see is Approved ones. Though I found something called TimeSheetLineStatus that describes of Approved/Unapproved data, but i didn't find any records of my projects in that particular schema.

    FYI.., we fill the timesheet and task progress details in PWA->My Work->Tasks->My assignment View...

    Is there any other way that we can generate the unapproved data?

    Any help would be appreciated...

    Thanks!!!!

    Tuesday, May 17, 2011 11:25 AM

All replies

  • Please use the following tables in Project Server Reporting database:

    MSP_TimesheetLine_UserView which has the ProjectUID, ResourceUID, ProjecTName, PeriodName & TimesheetUID, TimesheetStatus

    TimesheetStatus is ENUM value:

    InProgress=0, Submitted=1, Acceptable=2, Approved=3, and Rejected=4.

    You can join the View with MSP_EpmResource_UserView or project, task user view to get all the information.

    Hope that helps.

    Please let me know if you need more help in this.

    Thanks,

    Amit Khare

    Tuesday, May 17, 2011 2:11 PM
  • hi Amit,

    Now thats the issue here, I am not able to see any data in MSP_TimesheetLine_UserView for my project where we filled the time using Task View.

    I see only those records for the projects whose timesheet are filled using TimeSheet View...

    Wednesday, May 18, 2011 4:25 AM
  • Hello 

    Are you using only My task functionality in PS2010. My Task & Timesheet both are different in terms of usage. If you are entering time in Timesheets & getting approved/rejected by Time sheet manager. You will see the data in MSP_TimesheetLine_UserView but seems that you are using My task so that might be the case. Try using Single Entry mode if you want the hours filled in TS & Task should be in sync.

    http://technet.microsoft.com/en-us/library/gg597652.aspx

    http://technet.microsoft.com/en-us/library/gg597642.aspx

     

    Does that help?

    Thanks,

    Amit Khare


    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
    Wednesday, May 18, 2011 8:13 AM