7 czerwca 2012 20:08
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
12 czerwca 2012 01:54Moderator
The Reporting db holds copies of all Timesheet data, so I would read from there.
Rod Gill Project Management
12 czerwca 2012 04:37
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.
18 czerwca 2012 08:25
Take a look at ApproverResourceNameUID in the MSP_TimesheetLine table in the RDB.
21 czerwca 2012 17:51
Thats the timesheet line task status manager.
21 czerwca 2012 18:04
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.
27 czerwca 2012 21:46
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.
- Zmodyfikowany przez Pelican Carl 27 czerwca 2012 21:55