Thursday, 7 June, 2012 8:08 PM
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
Tuesday, 12 June, 2012 1:54 AMModerator
The Reporting db holds copies of all Timesheet data, so I would read from there.
Rod Gill Project Management
Tuesday, 12 June, 2012 4:37 AM
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.
Monday, 18 June, 2012 8:25 AM
Take a look at ApproverResourceNameUID in the MSP_TimesheetLine table in the RDB.
Thursday, 21 June, 2012 5:51 PM
Thats the timesheet line task status manager.
Thursday, 21 June, 2012 6:04 PM
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.
Wednesday, 27 June, 2012 9:46 PM
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.
- Edited by Pelican Carl Wednesday, 27 June, 2012 9:55 PM