none
Where is the approverUID located in the reporting database? RRS feed

  • Question

  • Just was wondering if anyone knew were in the reporting database the approverUID is located.  What I am trying to do is submit a preexisting timesheet into the queue.  I have the timesheetUID, I am just wondering were I can find the approverUID that corresponds to that timesheet so I can run the QueueSubmitTimesheet method.  
    Sunday, August 12, 2012 2:37 PM

Answers

  • The Timesheet manager UID (approverUID ) is the [ResourceTimesheetManagerUID] from MSP_EpmResources_UserValue in Reporting database.

    HTH.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    • Marked as answer by afire007 Monday, August 13, 2012 1:54 PM
    Monday, August 13, 2012 9:34 AM

All replies

  • Off the top of my head this is the ResourceUID of the [MSP_EpmResources] table or the [MSP_EpmResources_UserValue] view. Try that and see let me know if that is not the case.

    Regards,

    Piet Remen
    http://pietremen.blogspot.com.au

    Monday, August 13, 2012 9:19 AM
  • The Timesheet manager UID (approverUID ) is the [ResourceTimesheetManagerUID] from MSP_EpmResources_UserValue in Reporting database.

    HTH.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    • Marked as answer by afire007 Monday, August 13, 2012 1:54 PM
    Monday, August 13, 2012 9:34 AM