Query to find historical Timesheet Approver in Project Server 2010
-
7 czerwca 2012 20:08
Hi Folks,
I need the query to find original timesheet approvers for each timesheet. The current Timesheet Manager may have been changed so I don't want to rely on the field: MSP_EpmResource_UserView.ResourceTimesheetManagerUID.
Seems like I should be able to get this out of a MSP_Timesheet table....
MSP_Timesheet.LastStatusChangeResourceNameUID appears to be null
Carl
Wszystkie odpowiedzi
-
12 czerwca 2012 01:54Moderator
The Reporting db holds copies of all Timesheet data, so I would read from there.
Good luck!
Rod Gill
The one and only Project VBA Book
Rod Gill Project Management
-
12 czerwca 2012 04:37
Hi Rod,
Yes, the timesheet tables in the Reporting db is where I am looking (see my notes), but I can't find this basic information. I hope it exists.
Carl
-
18 czerwca 2012 08:25
Carl,
Take a look at ApproverResourceNameUID in the MSP_TimesheetLine table in the RDB.
Treb Gatte
-
21 czerwca 2012 17:51
Hi Treb,
Thats the timesheet line task status manager.
Carl
-
21 czerwca 2012 18:04
Hey Carl,
Then either the SDK is wrong or you found a bug or both. :-)
The SDK lists this field as "Resource GUID of the timesheet approver" which is typically not the same as the Task Status Manager.
What about LastStatusChangeResourceNameUID in the MSP_Timesheet where the TimesheetStatusID indicates approved? Otherwise, I'm out of ideas.
Treb Gatte
-
27 czerwca 2012 21:46
Hi Treb,
In my system, which has April patches, TimeSheet.LastStatusChangeResourceNameUID is null. My guess is that it only gets valued when someone "adjusts actuals" - that is just a guess; I haven't tested.
Its easy to use MSP_EpmResource_UserView.ResourceTimesheetManagerUID but that underminds the whole rational of the timesheet tables.
Carl
- Zmodyfikowany przez Pelican Carl 27 czerwca 2012 21:55
