Project and Portfolio Management Practitioners Forum
cancel

Inherit global time policy

Highlighted
JHarris941
Super Contributor.

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
Outstanding Contributor.

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
Super Contributor.

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