Super Contributor.. JHarris941 Super Contributor..
Super Contributor..
335 views

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
Absent Member.. Mohit_Agrawal Absent Member..
Absent Member..

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

0 Likes
Super Contributor.. JHarris941 Super Contributor..
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

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.