locked
Administrative time approval status RRS feed

  • Question

  • Hi. Help is required with Project server 2007.

    I'm writing a report and I need to know how to get Approval Status of an Administrative time line of a Timesheet from the database. I didn't find anything useful among MSP_Timesheet* tables.

    • Edited by AnDenixD Tuesday, March 1, 2011 11:12 AM
    Tuesday, March 1, 2011 10:34 AM

Answers

  • Hi,

    sorry for my late reply.

    I was so happy when I read your question for 2010, since queries for timesheets had been really improved with this new view. I looked for a solution, but I am afraid that you will need to write either a stored procedure or query published DB, what is not supported.

    I can't find this information in any table in RDB and it is also not provided in cube Timesheet, so I think it is definitely not available there.

    Sorry!
    Barbara

    Tuesday, March 1, 2011 1:23 PM

All replies

  • Hi,

    if you use dbo.MSP_TimesheetLine_UserViewCF view, you will find this information in TimeSheetLineStatus.

    Does that help?
    Barbara

    Tuesday, March 1, 2011 10:52 AM
  • Sorry for the mistake, I've got Project server 2007. Didn't find MSP_TimesheetLine_UserViewCF view inr ProjectServer_Reporting database.
    Tuesday, March 1, 2011 11:14 AM
  • Is it possible that is is [ProjectServer_Published].[dbo].[MSP_TIMESHEET_LINES].[TS_LINE_STATUS] ? But then, what is the corresponding field in [ProjectServer_Reporting].[dbo] ?
    Tuesday, March 1, 2011 11:22 AM
  • I suppose, I have to write a stored function in [ProjectServer_Reporting] that extracts data from [ProjectServer_Published].[dbo].[MSP_TIMESHEET_LINES]
    Tuesday, March 1, 2011 12:23 PM
  • Hi,

    sorry for my late reply.

    I was so happy when I read your question for 2010, since queries for timesheets had been really improved with this new view. I looked for a solution, but I am afraid that you will need to write either a stored procedure or query published DB, what is not supported.

    I can't find this information in any table in RDB and it is also not provided in cube Timesheet, so I think it is definitely not available there.

    Sorry!
    Barbara

    Tuesday, March 1, 2011 1:23 PM