Manage query & folder templates

Security templates allow you to control who can access Query Manager's public queries and Catalogue folders.  You manage templates, their authorised users, and their objects (queries and folders) from Query Management Administration.

Assign a user to a template

To assign a user to a template:

  1. Go to Administration > System Security > Query Manager Administration.
  2. EmpowerHR displays the Query Manager - Administrator screen.
  3. Click Template Users.
  4. At the Template Users tab, select a template from the Template Name dropdown list. 
  5. EmpowerHR displays the Authorised Users and Unauthorised Users lists.
  6. Click Open.  
  7. To:
    1. assign a user to the template, select the user in the Unauthorised Users list, and click Move Left.  The user is added to the Authorised Users list. 
    2. remove an assigned user from the template, select the user in the Authorised Users list, and click Move Right.  The user is moved to the Unauthorised Users list. 
  1. Click Save.

Change access to an object

To change access to an object (query or folder):

  1. Go to Administration > System Security > Query Manager Administration.
  2. EmpowerHR displays the Query Manager - Administrator screen.
  3. At the Access Profile tab, select a template from the Template Name dropdown list.
  4. EmpowerHR displays a list of Authorised Users and the objects (queries and folders) for which the template provides access.
  5. Click Open.  
  6. Review the objects listed in the Query/Folder Access panel and use the following table to understand what the check marks mean:
This check mark...
means...
green
access is granted
clear
access is undefined (that is, access is neither granted nor denied)
orange
access is mixed (access is granted to some descendant objects, while denied for others)
  1. To change access to granted or denied, double-click the object.  When you grant access to a query, EmpowerHR automatically grants access to any sub-queries, drill-down queries, and union queries associated with the query. 
Information

If you change access for a parent folder, the change applies to all its descendants.

  1. Click Save.

Assign templates to a user 

    You can assign multiple templates to a user.

    To assign a template to a user:

    1. Go to Administration > System Security > Query Manager Administration.
    2. EmpowerHR displays the Query Manager - Administrator screen.
    3. Click User Templates.
    4. At the User Templates tab, select a user from the User Name dropdown list. 
    5. EmpowerHR displays the Authorised Templates and Unauthorised Templates lists.
    6. Click Open.  
    7. To:
      1. assign a template to the user, select the template in the Unauthorised Templates list, and click Move Left.  The template is added to the Authorised Templates list. 
      2. remove an assigned template from the user, select the template in the Authorised Templates list, and click Move Right.  The template is moved to the Unauthorised Templates list. 
    1. Click Save.

    Define folders 

    You can define the folders/sub-folders where authorised Query Manager users can store their saved queries.

    To define a folder/sub-folder:

    1. Go to Administration > System Security > Query Manager Administration.
    2. EmpowerHR displays the Query Manager - Administrator screen.
    3. Click Folder Control.
    4. At the Folder Control tab, select a folder from the Classification Folder dropdown list. 
    5. EmpowerHR displays the Approved Sub-Classification Folders and Available Sub-Classification Folders lists.
    6. Click Open.  
    7. To:
      1. add a sub-folder, select the item in the Available Sub-Classification Folders list, and click Move Left.  The item is added to the Approved Sub-Classification Folders list. 
      2. remove an assigned sub-folder, select the item in the Approved Sub-Classification Folders list, and click Move Right.  The item is moved to the Available Sub-Classification Folders list. 
    Information Query Manager prevents you from removing an assigned sub-folder that already exists in Saved Queries,
    1. Click Save.

    Define element filters 

    You can define the pay elements and leave elements you want to use as filters in Query Manager.

    Registered element filters are available from the Filters tab of Query Manager. 

    To define and register element filters:

    1. Go to Administration > System Security > Query Manager Administration.
    2. EmpowerHR displays the Query Manager - Administrator screen.
    3. Select a template.
    4. Click Filter Control.
    5. At the Filter Control tab, select an element type from the Element Type dropdown list. 
    6. EmpowerHR displays the Registered Element Filters and Available Elements lists.
    Information Users can still modify or delete any payment code associated with a pay element.  Query Manager lists all element definitions, showing deleted elements with coloured highlighting. 
    1. Click Open.  
    2. To:
      1. add an element, select the element in the Available Elements list, and click Move Left.  The element is added to the Registered Element Filters list. 
      2. remove an element, select the element in the Registered Element Filters list, and click Move Right. 
    1. If you try to remove a registered element:
      1. not currently used in any queries, after you click Move Right, the element is moved to the Available Elements list. 
      2. currently used in a query, EmpowerHR displays a warning with a list of queries.  Check the list and modify or delete each of the existing queries and then remove the element.
    Information Query Manager prevents you from removing a registered pay element that is currently used in a query.  EmpowerHR displays a warning and lists each query, the owner, date last used, and the saved queries folder/subfolder.  You must modify or delete the existing queries before you can remove the element.
    1. Click Save.  ​

    Create a new template 

    To create a new template:

    1. Go to Administration > System Security > Query Manager Administration.
    2. EmpowerHR displays the Query Manager - Administrator screen.
    3. Click New.
    4. At Define Security Template, enter a name for the new template, and then press Tab. 
    5. Click Save. 
    6. Follow the preceding instructions to assign users, determine access, etc.





    Next topic

    Register & manage self service forms




    © 2023 Fusion5. All rights reserved.