Create Employee Groups
Employee groups are used throughout the portal for permission assignments, benefit eligibility, and other purposes. Employee groups can be set up by condition or using an SQL query.
.Tip: To review membership of an existing employee group, select view in the # of Employees column.
Select Add New Group.
Note: To edit an existing employee group, select the Edit Group button for that specific group.
- Enter the employee group name, and select Add.
- To exclude employees set as inactive in Vista's PR Employees and the portal, select the Filter Out Inactive Employees check box.
Use the Add / Exclude By Condition
section to create an employee group based on conditions that you establish.
Tip: To review membership of an employee group as you are setting it up, select the View Membership button at the top of the Employee Groups page.
Select a PR Company.
The drop-down lists the PR Companies enabled in your portal.
- Select the Group Type: PR Group, Earn Code, Craft, PR Department, Craft / Class.
Select the Group Value for the
corresponding Group Type, or leave Group Value set to All.
For example, if you select Earn Code as the Group Type, the Group Value field shows all available earn codes in the current PR Company.
- In the Is Included / Is Excluded drop-down, choose whether this employee group should include all employees who meet the criteria for PR Company, Group Type, and Group value, or exclude employees who meet these criteria.
- Select a PR Company.
Use the Add / Exclude Specific
Employees area to add employees who do not meet established
group membership conditions but should be included in the group or to exclude
individual employees who meet membership conditions.
Note: The Add / Exclude Specific Employees section may be used in conjunction with Add / Exclude By Condition but not with SQL Choices Override.
- In the Employee field, enter or search for the employee.
- In the Is Included / Is Excluded drop-down, choose whether to add or exclude the employee.
- Select View Membership at the top of the page to ensure that the employee group includes the appropriate names.
Use the SQL Choices Override section
to create custom employee groups based on an SQL query.
Note: This option is meant for advanced users only. SQL groups operate on their own and do not affect group membership set by conditions. Viewpoint Views are not supported.
- Format the query to complete the following insert statement: UserGroupMemberPersist (UserGroupID, PRCo, Employee, EmployeeName)
- For example, to show all inactive employees
in PR Company 3, you can write the following query:
SELECT 2, PRCo, Employee, FirstName + ' ' + LastName from kPREH where PRCo = 3 and ActiveYN = 'N'
To rename a group, select rename next to the current
group name in the upper left.
This renames the group on all pages where it has been assigned in the portal.
- To remove all conditions, SQL, and employees from a group, select Clear Group.
- To remove an employee group from the portal, select Delete Group.