Active Employee Where Clause (ActiveEmpLOVCode) and Active Position Where Clause (ActivePosWhereClause) Parameters

You can choose to include only active employees for assignment rule evaluation. For example, you might want to effectively exclude inactive employees or employees who are on a leave of absence from assignment consideration.

You include active employees by using the Active Employee Where Clause component-level parameter (or using ActiveEmpLOVCode from the Server Manager command line) with an SQL WHERE clause that is based on any column (or columns) on the S_EMP_PER employee table. For example, you could use the EMP_STAT_CD column with the following value to indicate that you want only active employees considered for evaluation and assignment:

AND emp.EMP_STAT_CD='Active'

Other employees are excluded, even if they are explicitly added to an assignment rule as candidates.

Similarly, you can include only active positions by using the Active Position Where Clause component-level parameter (or using ActivePosWhereClause from the Server Manager command line).

Note: Updated values for these parameters take effect when assignment rules are released and the rulecache.dat file is updated, or when the component is restarted. (Updated values also take effect if the Siebel Server is restarted.)

Caution: When specifying the parameters, you must use the emp SQL alias for the S_EMP_PER employee table and the pos alias for the S_POSTN position table. Do this to differentiate from other columns by the same name in other tables that Assignment Manager might use in the same SQL. Otherwise, an SQL error (ambiguous reference to a column) might occur.