none
Difference b\w TimeSheetStatus and TimeSheetLineStatus fields of MSP_TimeSheetLine_UserView . RRS feed

  • Question

  • The view is MSP_TimeSheetLine_UserView.

    I am getting Resources Entered Actual Hours from This View against Timesheet period. but here is little confusing.

    What is the difference b/w these fields

    TimeSheetStatus

    TimeSheetStatusID

              and

    TimeSheetLineStatus

    TimeSheetLineStatusID

    Which one I use for in having clause of Query . TimeSheetStatus or TimeSheetLineStatus.

    What is the difference b/w Accepted and Approved status on TimeSheetStatus and TimeSheetLineStatus Fields in the view of MSP_TimeSheetLine_UserView ?

    Saturday, January 5, 2013 9:05 AM

All replies

  • Hi John,

    As you know each timesheet consist of different line items task or administrative task, which represents timesheet lines. Having said that each timesheet line can have a status manager or multiple status manager. Hence each timesheet line carries its own status.  Down the line each timesheet for particular period will have it's own status which represents timesheet Status.

    TimeSheetStatusID = Status ID of the timesheet , values in are
                                    InProgress=0
                                    Submitted=1
                                    Acceptable=2
                                    Approved=3
                                    Rejected=4

    TimeSheetStatus =  Status of the timesheet
                                  Acceptable =2
                                  Approved =3
                                  InProgress =0
                                  Rejected =4
                                  Submitted =1

    TimeSheetLineStatus = Status of the timesheet line , values are
                                       Approved =1. The timesheet line is approved.  
                                      NotApplicable =3. The timesheet line is not applicable.  
                                      Pending =0. The timesheet line approval is pending.   
                                      Rejected =2. The timesheet line is rejected.  

    TimeSheetLineStatusID  = GUID of the timesheet line status.

    For more details about Project Server 2010 reporting schema, please download and extract project server 2010 SDK and navigate to installed folder and look for Project2010_ReportingDB.htm file inside Documentation\Schemas\Reporting and Cube" folder.
    http://www.microsoft.com/en-us/download/details.aspx?id=15511

    Depending on your report you can use either of TimeSheetStatus or TimeSheetLineStatus


    Hrishi Deshpande – Senior Consultant DeltaBahn
    Blog | < | LinkedIn

    Please click Mark As Answer; if a post solves your problem or Vote As Helpful.This can be beneficial to other community members reading the thread.

    Saturday, January 5, 2013 6:26 PM
    Moderator