BlogRead the Latest Articles

How to report on Primavera Timesheet approval delegates

There is no single screen to display all the delegations done by Primavera timesheet users but a database query will show delegates.

Timesheet approval delegates could be listed with below query. The query should run as a privileged database user or on Oracle databases as Primavera database admin user;

select  usr1.USER_NAME, usr2.USER_NAME delegate, project.PROJ_SHORT_NAME from tsdelegate, users usr1, project, users usr2 where project.proj_id(+)=tsdelegate.proj_id  and usr1.user_id=tsdelegate.user_id and usr2.user_id=tsdelegate.TS_DELEGATE_USER_ID;

Giriş yapmak için size sağlanan kullanıcı adını ve şifrenizi giriniz