DEFINE PEOPLE LISTS#
People lists allow users to define a generated list of employees that may be used to run reports or may be used for a list of people eligible to approve an item. The list can be based on a variety of conditions such as position, job, department, group and so on. People lists are built using ‘where clauses’ based on the conditions selected.
The user can define a people list in IMPL by specifying conditions in the Easy Add Where Clause Condition Values section. When a new people list is created a where clause will automatically be created using the people list code as the where clause code. If a where clause already exists with that code, an error is displayed saying so. The user is then responsible for creating the first ‘empty’ where clause (in which conditions don't exist) before selecting a condition value. This can be done by pressing the { } icon inside the Where Clause field in IMPL.
List Definition tab#
- People List
- This is a user defined code that identifies the name of the people list.
- Rederive On Use
- This toggle allows the system to query the employee data each time the people list is used to ensure that the people list has been built according to the most recent changes done in the system. By using this toggle, the Administrator would not have to manually update the people list each time there are HR changes.
If the Rederive on Use toggle is checked, the People tab will not contain any details and the Update Details button will be grayed out. When the details are requested, the where clause will be used in a query against the assignment details at runtime.
TIP: Depending on the where clause and the number of assignment detail records this may not give the best performance. If performance is an issue it would be better to use a people list that has the details pre-generated; however, the administrator is then responsible for updating the details.
- Where Clause
- When a people list is created, a where clause will automatically be created using the people list code as the where clause code.
- Update Details
- If the list is maintained manually and a condition is changed, the Update Details button should be pressed to regenerate the people list. Once the list has been generated, the list can be seen in the People tab. If the Rederive On Use is checked on, this button will be grayed out.
Easy Add WhereClause Condition Values#
- Employment Status
- Salary Range
