AnsweredAssumed Answered

Users w/timesheet approval and their approvals

Question asked by DanielSGHE on Oct 15, 2010
Latest reply on Oct 18, 2010 by Tammi
I have been requested to provide a list of users with Timesheet Approve rights (instance, OBS & group) and those employees that they approve. The list would look something like the below:

Manager Name ManagerID
Employee Name1 EmployeeID
Employee Name2 EmployeeID
Manager Name2 ManagerID
Employee Name1 EmployeeID
(etc...)

I am not a sql guru by any stretch. Can anyone point me in the right direction for obtaining this data? What tables can provide me with this information? Where are 'rights' info stored? We are running Clarity 12 on Oracle 11.

Thanks in advance for any assistance!

Daniel
SunGard Higher Education, Inc.

Outcomes