Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Inherit global time policy

Highlighted
JHarris941
Regular Collector

Inherit global time policy

Hello All,

 

I included a screenshot for clarification as well.  There is a radio button called "inherit global policy" in a resource under the "Time Managent" tab.  What table is that information stored on in the database?  I tried ktmg_policies but it just has the other field "Use this policy" record.

 

Thanks,

Jajcen

2 REPLIES
Mohit_Agrawal
Frequent Visitor

Re: Inherit global time policy

Hi..

 

if you need to find out the resources who are having "Inherit global policy" then first find out the global time sheet policy Id and then run below query:

 

SELECT ku.full_name,
  kp.policy_name
FROM rsc_resources kr,
  ktmg_policies kp,
  knta_users ku
WHERE ku.user_id            = kr.user_id
AND kr.time_sheet_policy_id = kp.policy_id
AND kp.policy_id            =  <global_policy_id>;

 

Thanks

Mohit

JHarris941
Regular Collector

Re: Inherit global time policy

Thanks Mohit,

 

This returns users who have a time policy, but not users who do not have a time policy and the radio button is set to inherit global time policy.  Users who are set to "Use this Policy" are fine.

 

Jajcen

//Add this to "OnDomLoad" event